eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_INACTIVE_EMP_WF_PKG dependencies on AP_WEB_UTILITIES_PKG

Line 87: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start Start_inactive_emp_process');

83: BEGIN
84:
85: Begin
86:
87: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start Start_inactive_emp_process');
88:
89: wf_engine.CreateProcess(ItemType => l_Item_Type,
90: ItemKey => l_Item_Key,
91: process => l_process);

Line 435: AP_WEB_UTILITIES_PKG.logProcedure('AP_INACTIVE_EMP_WF_PKG', 'end Start_inactive_emp_process');

431: l_item_type, l_item_key, to_char(0), l_debug_info);
432: raise;
433: end;
434:
435: AP_WEB_UTILITIES_PKG.logProcedure('AP_INACTIVE_EMP_WF_PKG', 'end Start_inactive_emp_process');
436:
437: COMMIT;
438:
439: EXCEPTION

Line 587: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;

583: l_orgId NUMBER;
584: l_InactEmpCCTrxn_cursor InactEmpCCTrxnCursor;
585: l_debug_info VARCHAR2(1000);
586: l_expense_report_number VARCHAR2(60);
587: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;
588: l_title AK_REGIONS_VL.name%TYPE;
589: l_expense_report_status VARCHAR2(30);
590: l_displayed_status VARCHAR2(60);
591: l_total_dsp VARCHAR2(50);

Line 770: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start FindActiveMAnager');

766:
767: Begin
768:
769:
770: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start FindActiveMAnager');
771:
772: IF (p_funmode = 'RUN') THEN
773:
774: ------------------------------------------------------------

Line 828: AP_WEB_UTILITIES_PKG.GetEmployeeInfo(l_dummy_inact_emp_mang_name,

824: -----------------------------------------------------------------------------------
825: l_debug_info := 'Get the Manager Cost Center Associated With Inactive Employee Id';
826: -----------------------------------------------------------------------------------
827:
828: AP_WEB_UTILITIES_PKG.GetEmployeeInfo(l_dummy_inact_emp_mang_name,
829: l_inact_emp_mang_num,
830: l_inact_emp_cost_center,
831: l_inact_emp_manager_id);
832:

Line 899: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end FindActiveMAnager');

895: p_result := 'COMPLETE';
896:
897: END IF;
898:
899: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end FindActiveMAnager');
900:
901: EXCEPTION
902: WHEN OTHERS THEN
903: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'FindActiveMAnager',

Line 936: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start SetAPRolePreparer');

932: l_debug_info VARCHAR2(200);
933: l_role_org_id NUMBER;
934:
935: BEGIN
936: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start SetAPRolePreparer');
937:
938: IF (p_funmode = 'RUN') THEN
939:
940: ------------------------------------------------------------

Line 996: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end SetAPRolePreparer');

992: ELSIF (p_funmode = 'CANCEL') THEN
993: p_result := 'COMPLETE';
994: END IF;
995:
996: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end SetAPRolePreparer');
997:
998: EXCEPTION
999: WHEN OTHERS THEN
1000: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'SetAPRolePreparer',

Line 1029: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start SetFromRoleForwardFrom');

1025:
1026: l_debug_info VARCHAR2(200);
1027: BEGIN
1028:
1029: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start SetFromRoleForwardFrom');
1030:
1031: IF (p_funmode = 'RUN') THEN
1032: ----------------------------------------------------------------
1033: l_debug_info := 'Set #FROM_ROLE to Forward From';

Line 1047: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end SetFromRoleForwardFrom');

1043: ELSIF (p_funmode = 'CANCEL') THEN
1044: p_result := 'COMPLETE';
1045: END IF;
1046:
1047: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end SetFromRoleForwardFrom');
1048:
1049: EXCEPTION
1050: WHEN OTHERS THEN
1051: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'SetFromRoleForwardFrom',

Line 1083: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start RecordForwardFromInfo');

1079: l_preparer_display_name VARCHAR2(80);
1080: l_debug_info VARCHAR2(200);
1081: BEGIN
1082:
1083: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start RecordForwardFromInfo');
1084:
1085: IF (p_funmode = 'RUN') THEN
1086:
1087: ------------------------------------------------------------

Line 1128: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end RecordForwardFromInfo');

1124: p_result := 'COMPLETE';
1125:
1126: END IF;
1127:
1128: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end RecordForwardFromInfo');
1129:
1130: EXCEPTION
1131: WHEN OTHERS THEN
1132: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'RecordForwardFromInfo',

Line 1165: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start SetMangInfoPrepNoResp');

1161: l_debug_info VARCHAR2(200);
1162:
1163: BEGIN
1164:
1165: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start SetMangInfoPrepNoResp');
1166:
1167:
1168: if (funcmode = 'RUN') then
1169:

Line 1195: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end SetMangInfoPrepNoResp');

1191: resultout := 'COMPLETE';
1192:
1193: END IF;
1194:
1195: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end SetMangInfoPrepNoResp');
1196:
1197: EXCEPTION
1198: WHEN OTHERS THEN
1199: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'SetMangInfoPrepNoResp',

Line 1243: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start CheckMangSecAttr');

1239:
1240:
1241: BEGIN
1242:
1243: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start CheckMangSecAttr');
1244:
1245:
1246: IF (funcmode = 'RUN') then
1247:

Line 1324: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end CheckMangSecAttr');

1320:
1321: END IF;
1322:
1323:
1324: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end CheckMangSecAttr');
1325:
1326: EXCEPTION
1327: WHEN OTHERS THEN
1328: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'CheckMangSecAttr',

Line 1374: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start AddSecuringAttributePreparer');

1370: l_error_note Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
1371:
1372:
1373: BEGIN
1374: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start AddSecuringAttributePreparer');
1375:
1376: IF (funcmode = 'RUN') then
1377:
1378: ---------------------------------------------------------------

Line 1536: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end AddSecAttrPreparer');

1532: resultout := 'COMPLETE';
1533:
1534: END IF;
1535:
1536: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end AddSecAttrPreparer');
1537:
1538: EXCEPTION
1539: WHEN OTHERS THEN
1540: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'AddSecAttrPreparer',

Line 1594: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start RemoveSecAttrPreparer');

1590:
1591:
1592: BEGIN
1593:
1594: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start RemoveSecAttrPreparer');
1595:
1596: IF (funcmode = 'RUN') then
1597: ------------------------------------------------------------------
1598: l_debug_info := 'Retrieve Preparer Employee ID Item Attributes';

Line 1700: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end RemoveSecAttrPreparer');

1696: resultout := 'COMPLETE';
1697:
1698: END IF;
1699:
1700: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end RemoveSecAttrPreparer');
1701:
1702: EXCEPTION
1703: WHEN OTHERS THEN
1704: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'RemoveSecAttrPreparer',

Line 1734: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start format_message');

1730: l_error VARCHAR2(2000);
1731: l_debug_info VARCHAR2(200);
1732: BEGIN
1733:
1734: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start format_message');
1735:
1736: IF p_status = Fnd_Api.G_RET_STS_SUCCESS THEN
1737: p_error:= 'Status: Successful!';
1738: ELSIF p_status = Fnd_Api.G_RET_STS_ERROR THEN

Line 1750: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end format_message');

1746: END IF;
1747: p_error:= l_error || p_msg_data;
1748: END IF;
1749:
1750: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end format_message');
1751:
1752: END Format_message;
1753:
1754: PROCEDURE CheckCCTransactionExists (itemtype in varchar2,

Line 1826: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start CheckCCTransactionExists');

1822: ));
1823:
1824: BEGIN
1825:
1826: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start CheckCCTransactionExists');
1827:
1828: l_itemkey := itemkey;
1829:
1830: IF (funcmode = 'RUN') THEN

Line 1896: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end CheckCCTransactionExists');

1892: resultout := 'COMPLETE';
1893:
1894: END IF;
1895:
1896: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end CheckCCTransactionExists');
1897:
1898: exception
1899: when others then
1900: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'CheckCCTransactionExists',

Line 1963: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start CheckWfExistsEmpl');

1959: group by cct.trx_id);
1960:
1961: BEGIN
1962:
1963: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start CheckWfExistsEmpl');
1964:
1965: -- 3319945: Initialize l_itemkey
1966: l_itemkey := itemkey;
1967:

Line 2020: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end CheckWfExistsEmpl');

2016: resultout := 'COMPLETE';
2017:
2018: END IF;
2019:
2020: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end CheckWfExistsEmpl');
2021:
2022: EXCEPTION
2023: WHEN OTHERS THEN
2024: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'CheckWfExistsEmpl',

Line 2059: AP_WEB_UTILITIES_PKG.logProcedure('P_WEB_INACTIVE_EMP_WF_PKG', 'start CallbackFunction');

2055: l_n_resp_appl_id Number;
2056:
2057: BEGIN
2058:
2059: AP_WEB_UTILITIES_PKG.logProcedure('P_WEB_INACTIVE_EMP_WF_PKG', 'start CallbackFunction');
2060:
2061: begin
2062:
2063: l_n_org_id := WF_ENGINE.GetItemAttrNumber(p_s_item_type,

Line 2134: AP_WEB_UTILITIES_PKG.logProcedure('P_WEB_INACTIVE_EMP_WF_PKG', 'end CallbackFunction');

2130: END IF;
2131:
2132: END IF;
2133:
2134: AP_WEB_UTILITIES_PKG.logProcedure('P_WEB_INACTIVE_EMP_WF_PKG', 'end CallbackFunction');
2135:
2136: END CallbackFunction;
2137:
2138: PROCEDURE IsNotifTransferred( p_item_type IN VARCHAR2,

Line 2177: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start IsNotifTransferred');

2173: AND name = l_TransferToName;
2174:
2175: BEGIN
2176:
2177: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start IsNotifTransferred');
2178:
2179: if (p_funmode IN ('TRANSFER', 'FORWARD')) then
2180: -----------------------------------------
2181: l_debug_info := 'Get the Notification ID';

Line 2269: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end IsNotifTransferred');

2265:
2266: end if;
2267:
2268:
2269: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end IsNotifTransferred');
2270:
2271: EXCEPTION
2272: WHEN OTHERS THEN
2273: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'IsNotifTransferred',

Line 2306: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start SetPersonAs');

2302: l_preparer_org_id NUMBER;
2303:
2304: BEGIN
2305:
2306: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start SetPersonAs');
2307:
2308: ------------------------------------------------------------
2309: l_debug_info := 'Retrieve Preparer_Name Info for Preparer_Id';
2310: ------------------------------------------------------------

Line 2383: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end SetPersonAs');

2379:
2380:
2381: END IF;
2382:
2383: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end SetPersonAs');
2384:
2385: EXCEPTION
2386: WHEN OTHERS THEN
2387: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'SetPersonAs',

Line 2440: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start CheckAPApproved');

2436: and ac.employee_id = p_inact_employee_id;
2437:
2438: BEGIN
2439:
2440: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start CheckAPApproved');
2441:
2442:
2443: IF (funcmode = 'RUN') THEN
2444:

Line 2493: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end CheckAPApproved');

2489: resultout := 'COMPLETE';
2490:
2491: END IF;
2492:
2493: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end CheckAPApproved');
2494:
2495: EXCEPTION
2496: WHEN OTHERS THEN
2497: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'CheckAPApproved',

Line 2595: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start ClearItemkeyCCTrx');

2591: and ac.employee_id = p_inact_employee_id;
2592:
2593: BEGIN
2594:
2595: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start ClearItemkeyCCTrx');
2596:
2597:
2598: IF (funcmode = 'RUN') THEN
2599:

Line 2649: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end ClearItemkeyCCTrx');

2645: resultout := 'COMPLETE';
2646:
2647: END IF;
2648:
2649: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'end ClearItemkeyCCTrx');
2650:
2651: EXCEPTION
2652: WHEN OTHERS THEN
2653: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'ClearItemkeyCCTrx',