DBA Data[Home] [Help]

APPS.AP_WEB_INACTIVE_EMP_WF_PKG dependencies on WF_CORE

Line 95: l_err_name := wf_core.error_name;

91: process => l_process);
92:
93: exception
94: when others then
95: l_err_name := wf_core.error_name;
96: if (l_err_name = 'WFENG_ITEM_UNIQUE') then
97: wf_core.clear;
98: else
99: raise;

Line 97: wf_core.clear;

93: exception
94: when others then
95: l_err_name := wf_core.error_name;
96: if (l_err_name = 'WFENG_ITEM_UNIQUE') then
97: wf_core.clear;
98: else
99: raise;
100: end if;
101: end;

Line 119: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then

115: 'ORG_ID',
116: l_n_Org_ID);
117: exception
118: when others then
119: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
120: -- ORG_ID item attribute doesn't exist, need to add it
121: WF_ENGINE.AddItemAttr(l_item_type, l_item_key, 'ORG_ID');
122: WF_ENGINE.SetItemAttrNumber(l_item_type,
123: l_item_key,

Line 161: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then

157: FND_PROFILE.VALUE('RESP_APPL_ID'));
158:
159: exception
160: when others then
161: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
162: null;
163: else
164: raise;
165: end if;

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 418: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then

414:
415:
416: exception
417: when others then
418: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
419: null;
420: else
421: raise;
422: end if;

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 531: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GetInactEmpCcardTrxnCursor',

527: RETURN TRUE;
528:
529: EXCEPTION
530: WHEN NO_DATA_FOUND THEN
531: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GetInactEmpCcardTrxnCursor',
532: to_char(0), to_char(0), to_char(0), l_debug_info || FND_MESSAGE.GET);
533: RETURN FALSE;
534:
535: WHEN OTHERS THEN

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 903: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'FindActiveMAnager',

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',
904: p_item_type, p_item_key, to_char(0), l_debug_info || FND_MESSAGE.GET);
905: raise;
906: END FindActiveMAnager;
907:

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 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 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 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 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 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 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 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 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 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 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 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 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 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 2068: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then

2064: p_s_item_key,
2065: 'ORG_ID');
2066: exception
2067: when others then
2068: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
2069: -- ORG_ID item attribute doesn't exist, need to add it
2070: wf_engine.AddItemAttr(p_s_item_type, p_s_item_key, 'ORG_ID');
2071: -- get the org_id from header for old reports
2072: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(

Line 2108: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then

2104: RESP_APPL_ID => l_n_resp_appl_id
2105: );
2106: exception
2107: when others then
2108: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
2109: null;
2110: else
2111: raise;
2112: end if;

Line 2208: Wf_Core.Raise(wf_core.translate('NO_ROLE_FOUND'));

2204: OPEN c_person_id;
2205: FETCH c_person_id into l_TransferToID;
2206: IF c_person_id%NOTFOUND THEN
2207: p_result := wf_engine.eng_completed||':'||wf_engine.eng_null;
2208: Wf_Core.Raise(wf_core.translate('NO_ROLE_FOUND'));
2209: RETURN;
2210: ELSE
2211: IF l_TransferToID IS NULL THEN
2212: p_result := wf_engine.eng_completed||':'||wf_engine.eng_null;

Line 2213: Wf_Core.Raise(wf_core.translate('PERSON_ID_NULL'));

2209: RETURN;
2210: ELSE
2211: IF l_TransferToID IS NULL THEN
2212: p_result := wf_engine.eng_completed||':'||wf_engine.eng_null;
2213: Wf_Core.Raise(wf_core.translate('PERSON_ID_NULL'));
2214: RETURN;
2215: END IF;
2216: END IF;
2217: CLOSE c_person_id;

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 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 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 2535: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GetUserIdForEmp',

2531: RETURN TRUE;
2532:
2533: EXCEPTION
2534: WHEN NO_DATA_FOUND THEN
2535: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GetUserIdForEmp',
2536: to_char(0), to_char(0), to_char(0), l_debug_info || FND_MESSAGE.GET);
2537: RETURN FALSE;
2538:
2539: WHEN OTHERS THEN

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 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;