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_INACTIVE_EMP_WF_PKG

Line 1: PACKAGE BODY AP_WEB_INACTIVE_EMP_WF_PKG AS

1: PACKAGE BODY AP_WEB_INACTIVE_EMP_WF_PKG AS
2: /* $Header: apwinacb.pls 120.23.12000000.3 2007/04/24 20:51:57 skoukunt ship $ */
3: --
4: -- Private Variables
5: --

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 192: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'Start_Inactive_Emp_Process',

188: and trunc(sysdate) between a.effective_start_date and a.effective_end_date;
189:
190: exception
191: when others then
192: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'Start_Inactive_Emp_Process',
193: l_item_type, l_item_key, to_char(0), l_debug_info);
194: raise;
195: end;
196:

Line 390: l_textValArr(iText) := 'plsql:AP_WEB_INACTIVE_EMP_WF_PKG.GenerateCCTrxList/'||l_item_type||':'||l_item_key;

386: l_debug_info := 'Set CC_TRX_DETAILS_TABLE Item Attribute';
387: ------------------------------------------------------
388: iText := iText + 1;
389: l_textNameArr(iText) := 'CC_TRX_DETAILS_TABLE';
390: l_textValArr(iText) := 'plsql:AP_WEB_INACTIVE_EMP_WF_PKG.GenerateCCTrxList/'||l_item_type||':'||l_item_key;
391:
392: ------------------------------------------------------
393: l_debug_info := 'Set OIE_CC_TRX_DETAILS_TABLE Item Attribute';
394: ------------------------------------------------------

Line 430: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', ' Start_inactive_emp_process ',

426: wf_engine.StartProcess(ItemType => l_Item_Type,
427: ItemKey => l_Item_Key);
428: exception
429: when others then
430: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', ' Start_inactive_emp_process ',
431: l_item_type, l_item_key, to_char(0), l_debug_info);
432: raise;
433: end;
434:

Line 537: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'GetInactEmpCcardTrxnCursor',

533: RETURN FALSE;
534:
535: WHEN OTHERS THEN
536:
537: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'GetInactEmpCcardTrxnCursor',
538: to_char(0), to_char(0), to_char(0), l_debug_info || FND_MESSAGE.GET);
539: APP_EXCEPTION.RAISE_EXCEPTION;
540: RETURN FALSE;
541:

Line 722: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'GenerateCCTrxList',

718: document_type := display_type;
719:
720: EXCEPTION
721: WHEN OTHERS THEN
722: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'GenerateCCTrxList',
723: document_id, l_debugInfo);
724: raise;
725: END GenerateCCTrxList;
726:

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 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 1000: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'SetAPRolePreparer',

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',
1001: p_item_type, p_item_key, to_char(0), l_debug_info || FND_MESSAGE.GET);
1002: raise;
1003: END SetAPRolePreparer;
1004:

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 1051: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'SetFromRoleForwardFrom',

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',
1052: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1053: raise;
1054: END SetFromRoleForwardFrom;
1055:

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 1132: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'RecordForwardFromInfo',

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',
1133: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1134: raise;
1135: END RecordForwardFromInfo;
1136:

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 1199: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'SetMangInfoPrepNoResp',

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',
1200: itemtype, itemkey, to_char(actid), l_debug_info);
1201: raise;
1202: end SetMangInfoPrepNoResp;
1203:

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 1287: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'CheckMangSecAttr',

1283: END IF;
1284:
1285: EXCEPTION
1286: WHEN OTHERS THEN
1287: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'CheckMangSecAttr',
1288: itemtype, itemkey, to_char(actid), l_debug_info);
1289: raise;
1290: end;
1291:

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 1328: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'CheckMangSecAttr',

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',
1329: itemtype, itemkey, to_char(actid), l_debug_info);
1330: raise;
1331: END CheckMangSecAttr;
1332:

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 1423: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'AddSecAttrPreparer',

1419: resultout := 'COMPLETE:N';
1420: ------------------------------------------------------------------
1421: l_debug_info := 'No Preparer WEB UserId';
1422: ------------------------------------------------------------------
1423: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'AddSecAttrPreparer',
1424: itemtype, itemkey, to_char(actid), l_debug_info);
1425: ELSE
1426:
1427: ---------------------------------------------------

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 1540: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'AddSecAttrPreparer',

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',
1541: itemtype, itemkey, to_char(actid), l_debug_info||l_error);
1542: raise;
1543: END AddSecAttrPreparer;
1544:

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 1638: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'RemoveSecAttrPreparer',

1634: resultout := 'COMPLETE:N';
1635: ----------------------------------------------------
1636: l_debug_info := 'No Inact Empl WEB UserId';
1637: -----------------------------------------------------
1638: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'RemoveSecAttrPreparer',
1639: itemtype, itemkey, to_char(actid), l_debug_info);
1640: ELSE
1641:
1642: open emp_sec_attr_cur(l_inact_employee_id,

Line 1671: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'RemoveSecAttrPreparer',

1667: resultout := 'COMPLETE:Y';
1668:
1669: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1670: format_message(l_return_status, l_msg_count, l_msg_data, l_error);
1671: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'RemoveSecAttrPreparer',
1672: itemtype, itemkey, to_char(actid), l_error);
1673:
1674: -- Bug 3320047 resultout was not set
1675: resultout := 'COMPLETE:N';

Line 1682: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'RemoveSecAttrPreparer',

1678: END IF;
1679:
1680: EXCEPTION
1681: WHEN OTHERS THEN
1682: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'RemoveSecAttrPreparer',
1683: itemtype, itemkey, to_char(actid), l_debug_info);
1684: raise;
1685: end;
1686:

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 1704: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'RemoveSecAttrPreparer',

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',
1705: itemtype, itemkey, to_char(actid), l_debug_info);
1706: raise;
1707: END RemoveSecAttrPreparer;
1708:

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 1879: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'CheckCCTransactionExists',

1875: close trx_exists_cur;
1876:
1877: exception
1878: when others then
1879: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'CheckCCTransactionExists',
1880: itemtype, itemkey, to_char(actid), l_debug_info);
1881: raise;
1882: end;
1883:

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 1900: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'CheckCCTransactionExists',

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',
1901: itemtype, itemkey, to_char(actid), l_debug_info);
1902: raise;
1903:
1904: END 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 2003: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'CheckWfExistsEmpl',

1999:
2000:
2001: exception
2002: when others then
2003: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'CheckWfExistsEmpl',
2004: itemtype, itemkey, to_char(actid), l_debug_info);
2005: raise;
2006: end;
2007:

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 2024: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'CheckWfExistsEmpl',

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',
2025: itemtype, itemkey, to_char(actid), l_debug_info);
2026: raise;
2027:
2028: END CheckWfExistsEmpl;

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 2273: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'IsNotifTransferred',

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',
2274: p_item_type, p_item_key, to_char(0), l_debug_info);
2275: RAISE;
2276:
2277: END 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 2387: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'SetPersonAs',

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',
2388: p_item_type, p_item_key, null, l_debug_info);
2389: raise;
2390: END SetPersonAs;
2391:

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 2497: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'CheckAPApproved',

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',
2498: itemtype, itemkey, to_char(actid), l_debug_info);
2499: raise;
2500:
2501: END CheckAPApproved;

Line 2541: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'GetUserIdForEmp',

2537: RETURN FALSE;
2538:
2539: WHEN OTHERS THEN
2540:
2541: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'GetUserIdForEmp',
2542: to_char(0), to_char(0), to_char(0), l_debug_info || FND_MESSAGE.GET);
2543: APP_EXCEPTION.RAISE_EXCEPTION;
2544: RETURN FALSE;
2545:

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',

Line 2653: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'ClearItemkeyCCTrx',

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',
2654: itemtype, itemkey, to_char(actid), l_debug_info);
2655: raise;
2656:
2657: END ClearItemkeyCCTrx;

Line 2659: END AP_WEB_INACTIVE_EMP_WF_PKG;

2655: raise;
2656:
2657: END ClearItemkeyCCTrx;
2658:
2659: END AP_WEB_INACTIVE_EMP_WF_PKG;