DBA Data[Home] [Help]

APPS.HR_WORKFLOW_SS dependencies on WF_CORE

Line 82: WF_CORE.CONTEXT(g_package

78: end if;
79: --
80: EXCEPTION
81: WHEN OTHERS THEN
82: WF_CORE.CONTEXT(g_package
83: ,'branch_on_approval_flag'
84: ,itemtype
85: ,itemkey
86: ,to_char(actid)

Line 126: WF_CORE.CONTEXT(g_package

122:
123: --
124: EXCEPTION
125: WHEN OTHERS THEN
126: WF_CORE.CONTEXT(g_package
127: ,'set_rejected_by_payroll'
128: ,itemtype
129: ,itemkey
130: ,to_char(actid)

Line 186: WF_CORE.CONTEXT(g_package

182:
183: --
184: EXCEPTION
185: WHEN OTHERS THEN
186: WF_CORE.CONTEXT(g_package
187: ,'copy_payroll_comment'
188: ,itemtype
189: ,itemkey
190: ,to_char(actid)

Line 233: WF_CORE.CONTEXT(g_package,'.get_item_type',p_transaction_id);

229: --return c_item_type;
230: return nvl(c_item_type,'-1');
231: EXCEPTION
232: WHEN OTHERS THEN
233: WF_CORE.CONTEXT(g_package,'.get_item_type',p_transaction_id);
234: RAISE;
235:
236: end get_item_type;
237:

Line 277: WF_CORE.CONTEXT(g_package,'.get_item_key',p_transaction_id);

273: --return get_item_key.c_item_key;
274: return nvl(get_item_key.c_item_key,'-1');
275: EXCEPTION
276: WHEN OTHERS THEN
277: WF_CORE.CONTEXT(g_package,'.get_item_key',p_transaction_id);
278: RAISE;
279:
280: end get_item_key;
281:

Line 301: WF_CORE.CONTEXT(g_package,'.get_process_name',c_item_type,c_item_key);

297: ignore_notfound => TRUE);
298: return c_process_name;
299: EXCEPTION
300: WHEN OTHERS THEN
301: WF_CORE.CONTEXT(g_package,'.get_process_name',c_item_type,c_item_key);
302: RAISE;
303: end get_process_name ;
304:
305: function get_approval_level

Line 324: WF_CORE.CONTEXT(g_package,'.get_approval_level',c_item_type,c_item_key);

320: aname => 'APPROVAL_LEVEL');
321: return c_approval_level;
322: EXCEPTION
323: WHEN OTHERS THEN
324: WF_CORE.CONTEXT(g_package,'.get_approval_level',c_item_type,c_item_key);
325: RAISE;
326:
327:
328: end get_approval_level ;

Line 350: WF_CORE.CONTEXT(g_package,'.get_effective_date',c_item_type,c_item_key);

346:
347: return c_effective_date;
348: EXCEPTION
349: WHEN OTHERS THEN
350: WF_CORE.CONTEXT(g_package,'.get_effective_date',c_item_type,c_item_key);
351: RAISE;
352:
353:
354: end get_effective_date;

Line 374: WF_CORE.CONTEXT(g_package,'.get_assignment_id',c_item_type,c_item_key);

370: aname => 'CURRENT_ASSIGNMENT_ID');
371: return c_assignment_id;
372: EXCEPTION
373: WHEN OTHERS THEN
374: WF_CORE.CONTEXT(g_package,'.get_assignment_id',c_item_type,c_item_key);
375: RAISE;
376:
377:
378: end get_assignment_id ;

Line 564: WF_CORE.CONTEXT(g_package,'.Get_Next_Approver',itemtype,itemkey,funmode);

560: end if;
561:
562: EXCEPTION
563: WHEN OTHERS THEN
564: WF_CORE.CONTEXT(g_package,'.Get_Next_Approver',itemtype,itemkey,funmode);
565: RAISE;
566:
567:
568: end Get_Next_Approver;

Line 664: WF_CORE.CONTEXT(g_package,'.update_approval_status',itemtype,itemkey,funmode);

660: --
661: end if;
662: EXCEPTION
663: WHEN OTHERS THEN
664: WF_CORE.CONTEXT(g_package,'.update_approval_status',itemtype,itemkey,funmode);
665: RAISE;
666:
667:
668:

Line 722: WF_CORE.CONTEXT(g_package,'.get_final_approver',c_item_type,c_item_key);

718:
719: return c_final_appprover_id;
720: EXCEPTION
721: WHEN OTHERS THEN
722: WF_CORE.CONTEXT(g_package,'.get_final_approver',c_item_type,c_item_key);
723: RAISE;
724:
725:
726: end get_final_approver;

Line 757: WF_CORE.CONTEXT(g_package,'.allow_requestor_approval',c_item_type,c_item_key);

753:
754:
755: EXCEPTION
756: WHEN OTHERS THEN
757: WF_CORE.CONTEXT(g_package,'.allow_requestor_approval',c_item_type,c_item_key);
758: RAISE;
759: end allow_requestor_approval ;
760:
761: --

Line 1005: WF_CORE.Context(g_package, '.apps_initialize',

1001: END IF;
1002:
1003: EXCEPTION
1004: WHEN OTHERS THEN NULL;
1005: WF_CORE.Context(g_package, '.apps_initialize',
1006: p_itemtype, p_itemkey, p_actid, p_funcmode);
1007: RAISE;
1008: END apps_initialize;
1009:

Line 1092: WF_CORE.CONTEXT(g_package,'.defer_commit',p_item_type,p_item_key);

1088: END IF;
1089:
1090: EXCEPTION
1091: WHEN OTHERS THEN
1092: WF_CORE.CONTEXT(g_package,'.defer_commit',p_item_type,p_item_key);
1093: RAISE;
1094:
1095: END defer_commit;
1096:

Line 1146: Wf_Core.Context('hr_workflow_ss', 'GetActivityAttrText', itemtype, itemkey,

1142: return null;
1143: end if;
1144: exception
1145: when others then
1146: Wf_Core.Context('hr_workflow_ss', 'GetActivityAttrText', itemtype, itemkey,
1147: to_char(actid), aname);
1148: raise;
1149: end GetActivityAttrText;
1150:

Line 1190: Wf_Core.Context('hr_workflow_ss', 'GetActivityAttrDate', itemtype, itemkey,

1186: return null;
1187: end if;
1188: exception
1189: when others then
1190: Wf_Core.Context('hr_workflow_ss', 'GetActivityAttrDate', itemtype, itemkey,
1191: to_char(actid), aname);
1192: raise;
1193: end GetActivityAttrDate;
1194:

Line 1237: Wf_Core.Context('hr_workflow_ss', 'GetActivityAttrNumber', itemtype, itemkey,

1233: return null;
1234: end if;
1235: exception
1236: when others then
1237: Wf_Core.Context('hr_workflow_ss', 'GetActivityAttrNumber', itemtype, itemkey,
1238: to_char(actid), aname);
1239: raise;
1240: end GetActivityAttrNumber;
1241:

Line 1412: Wf_Core.Context('hr_workflow_ss', 'GetItemAttrText', itemtype, itemkey,

1408: return null;
1409: end if;
1410: exception
1411: when others then
1412: Wf_Core.Context('hr_workflow_ss', 'GetItemAttrText', itemtype, itemkey,
1413: aname);
1414: raise;
1415: end GetItemAttrText;
1416:

Line 1463: Wf_Core.Context('hr_workflow_ss', 'get_item_type_and_key', p_ntfId);

1459:
1460: exception
1461: when others then
1462: hr_utility.set_location('hr_workflow_ss.get_item_type_and_key errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
1463: Wf_Core.Context('hr_workflow_ss', 'get_item_type_and_key', p_ntfId);
1464: raise;
1465: end get_item_type_and_key;
1466:
1467: procedure build_edit_link(document_id IN Varchar2,

Line 1615: Wf_Core.Context('hr_workflow_ss', 'build_edit_link', document_id, display_type);

1611: when others then
1612: document := null;
1613: document_type :=null;
1614: hr_utility.set_location('hr_workflow_ss.build_edit_link errored : '||SQLERRM ||' '||to_char(SQLCODE), 20);
1615: Wf_Core.Context('hr_workflow_ss', 'build_edit_link', document_id, display_type);
1616: raise;
1617: end build_edit_link;
1618:
1619:

Line 1634: wf_core.token('NID', to_char(nid));

1630: if g_debug then
1631: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1632: end if;
1633: if ((nid is null) or (aname is null)) then
1634: wf_core.token('NID', to_char(nid));
1635: wf_core.token('ANAME', aname);
1636: wf_core.raise('WFSQL_ARGS');
1637: end if;
1638:

Line 1635: wf_core.token('ANAME', aname);

1631: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1632: end if;
1633: if ((nid is null) or (aname is null)) then
1634: wf_core.token('NID', to_char(nid));
1635: wf_core.token('ANAME', aname);
1636: wf_core.raise('WFSQL_ARGS');
1637: end if;
1638:
1639: begin

Line 1636: wf_core.raise('WFSQL_ARGS');

1632: end if;
1633: if ((nid is null) or (aname is null)) then
1634: wf_core.token('NID', to_char(nid));
1635: wf_core.token('ANAME', aname);
1636: wf_core.raise('WFSQL_ARGS');
1637: end if;
1638:
1639: begin
1640: if g_debug then

Line 1652: wf_core.token('NID', to_char(nid));

1648: when no_data_found then
1649: if(ignore_notfound='TRUE') then
1650: return null;
1651: else
1652: wf_core.token('NID', to_char(nid));
1653: wf_core.token('ATTRIBUTE', aname);
1654: wf_core.raise('WFNTF_ATTR');
1655: end if;
1656: end;

Line 1653: wf_core.token('ATTRIBUTE', aname);

1649: if(ignore_notfound='TRUE') then
1650: return null;
1651: else
1652: wf_core.token('NID', to_char(nid));
1653: wf_core.token('ATTRIBUTE', aname);
1654: wf_core.raise('WFNTF_ATTR');
1655: end if;
1656: end;
1657:

Line 1654: wf_core.raise('WFNTF_ATTR');

1650: return null;
1651: else
1652: wf_core.token('NID', to_char(nid));
1653: wf_core.token('ATTRIBUTE', aname);
1654: wf_core.raise('WFNTF_ATTR');
1655: end if;
1656: end;
1657:
1658: return(lvalue);

Line 1661: wf_core.context('hr_workflow_ss', 'GetAttrNumber', to_char(nid), aname);

1657:
1658: return(lvalue);
1659: exception
1660: when others then
1661: wf_core.context('hr_workflow_ss', 'GetAttrNumber', to_char(nid), aname);
1662: hr_utility.set_location('Error querying wf_notification_attributes.NUMBER_VALUE for aname:nid'||aname||':'||nid||'-'||SQLERRM ||' '||to_char(SQLCODE), 10);
1663: raise;
1664: end GetAttrNumber;
1665:

Line 1679: wf_core.token('NID', to_char(nid));

1675: if g_debug then
1676: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1677: end if;
1678: if ((nid is null) or (aname is null)) then
1679: wf_core.token('NID', to_char(nid));
1680: wf_core.token('ANAME', aname);
1681: wf_core.raise('WFSQL_ARGS');
1682: end if;
1683:

Line 1680: wf_core.token('ANAME', aname);

1676: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1677: end if;
1678: if ((nid is null) or (aname is null)) then
1679: wf_core.token('NID', to_char(nid));
1680: wf_core.token('ANAME', aname);
1681: wf_core.raise('WFSQL_ARGS');
1682: end if;
1683:
1684: begin

Line 1681: wf_core.raise('WFSQL_ARGS');

1677: end if;
1678: if ((nid is null) or (aname is null)) then
1679: wf_core.token('NID', to_char(nid));
1680: wf_core.token('ANAME', aname);
1681: wf_core.raise('WFSQL_ARGS');
1682: end if;
1683:
1684: begin
1685: if g_debug then

Line 1697: wf_core.token('NID', to_char(nid));

1693: when no_data_found then
1694: if(ignore_notfound='TRUE') then
1695: return null;
1696: else
1697: wf_core.token('NID', to_char(nid));
1698: wf_core.token('ATTRIBUTE', aname);
1699: wf_core.raise('WFNTF_ATTR');
1700: end if;
1701: end;

Line 1698: wf_core.token('ATTRIBUTE', aname);

1694: if(ignore_notfound='TRUE') then
1695: return null;
1696: else
1697: wf_core.token('NID', to_char(nid));
1698: wf_core.token('ATTRIBUTE', aname);
1699: wf_core.raise('WFNTF_ATTR');
1700: end if;
1701: end;
1702:

Line 1699: wf_core.raise('WFNTF_ATTR');

1695: return null;
1696: else
1697: wf_core.token('NID', to_char(nid));
1698: wf_core.token('ATTRIBUTE', aname);
1699: wf_core.raise('WFNTF_ATTR');
1700: end if;
1701: end;
1702:
1703: return(lvalue);

Line 1706: wf_core.context('hr_workflow_ss', 'GetAttrText', to_char(nid), aname);

1702:
1703: return(lvalue);
1704: exception
1705: when others then
1706: wf_core.context('hr_workflow_ss', 'GetAttrText', to_char(nid), aname);
1707: hr_utility.set_location('Error querying wf_notification_attributes.text_value for aname:nid'||aname||':'||nid||'-'||SQLERRM ||' '||to_char(SQLCODE), 10);
1708: raise;
1709: end GetAttrText;
1710:

Line 1765: WF_CORE.CONTEXT(g_package,'.getApprStartingPointPersonId',c_item_type,c_item_key);

1761: return c_creator_person_id;
1762:
1763: EXCEPTION
1764: WHEN OTHERS THEN
1765: WF_CORE.CONTEXT(g_package,'.getApprStartingPointPersonId',c_item_type,c_item_key);
1766: RAISE;
1767: end getApprStartingPointPersonId;
1768:
1769:

Line 1843: WF_CORE.CONTEXT(g_package,'.updateSFLTransaction',itemtype,itemkey,funmode);

1839: end if;
1840:
1841: EXCEPTION
1842: WHEN OTHERS THEN
1843: WF_CORE.CONTEXT(g_package,'.updateSFLTransaction',itemtype,itemkey,funmode);
1844: hr_utility.set_location(''||SQLERRM ||' '||to_char(SQLCODE), 100);
1845: RAISE;
1846:
1847:

Line 1939: Wf_Core.Context('hr_workflow_ss', 'getProcessDisplayName', document_id, display_type);

1935: exception
1936: when others then
1937: document :=null;
1938: hr_utility.set_location('hr_workflow_ss.getProcessDisplayName errored : '||SQLERRM ||' '||to_char(SQLCODE), 20);
1939: Wf_Core.Context('hr_workflow_ss', 'getProcessDisplayName', document_id, display_type);
1940: raise;
1941: end getProcessDisplayName;
1942:
1943:

Line 1992: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);

1988: exception
1989: when others then
1990: document :=null;
1991: hr_utility.set_location('hr_workflow_ss.getApprovalMsgSubject errored for custom call: '||SQLERRM ||' '||to_char(SQLCODE), 100);
1992: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);
1993: raise;
1994: end;
1995:
1996:

Line 2138: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);

2134: exception
2135: when others then
2136: document :=null;
2137: hr_utility.set_location('hr_workflow_ss.getApprovalMsgSubject errored : '||SQLERRM ||' '||to_char(SQLCODE), 40);
2138: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);
2139: raise;
2140: end getApprovalMsgSubject;
2141:
2142: