Oracle OIE customization message could not return
Hi All,
As Oracle suggested ,if you want to get the customization message, you could extend the package---AP_WEB_OA_CUSTOM_PKG. So I extend the package by the following steps.
Steps:
1. We created a customized package to validate the expense report, the package has 2 parameters: same with AP_WEB_OA_CUSTOM_PKG.
2. Then we customize the AP_WEB_OA_CUSTOM_PKG, call our package using GetCustomizedExpRepSummary function in the AP_WEB_OA_CUSTOM_PKG.
3.I could get the message through the following script using sql/plus
1 declare
2 P_ReportHeaderId varchar2(20):='10165';
3 P_CurrentPage varchar2(40) :='OIEReviewPage';
4 l_return varchar2(1000);