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 232: WF_CORE.CONTEXT(g_package,'.get_item_type',p_transaction_id);

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

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

271:
272: return get_item_key.c_item_key;
273: EXCEPTION
274: WHEN OTHERS THEN
275: WF_CORE.CONTEXT(g_package,'.get_item_key',p_transaction_id);
276: RAISE;
277:
278: end get_item_key;
279:

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

294: aname => 'PROCESS_NAME');
295: return c_process_name;
296: EXCEPTION
297: WHEN OTHERS THEN
298: WF_CORE.CONTEXT(g_package,'.get_process_name',c_item_type,c_item_key);
299: RAISE;
300: end get_process_name ;
301:
302: function get_approval_level

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

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

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

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

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

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

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

546: end if;
547:
548: EXCEPTION
549: WHEN OTHERS THEN
550: WF_CORE.CONTEXT(g_package,'.Get_Next_Approver',itemtype,itemkey,funmode);
551: RAISE;
552:
553:
554: end Get_Next_Approver;

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

626: --
627: end if;
628: EXCEPTION
629: WHEN OTHERS THEN
630: WF_CORE.CONTEXT(g_package,'.update_approval_status',itemtype,itemkey,funmode);
631: RAISE;
632:
633:
634:

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

684:
685: return c_final_appprover_id;
686: EXCEPTION
687: WHEN OTHERS THEN
688: WF_CORE.CONTEXT(g_package,'.get_final_approver',c_item_type,c_item_key);
689: RAISE;
690:
691:
692: end get_final_approver;

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

719:
720:
721: EXCEPTION
722: WHEN OTHERS THEN
723: WF_CORE.CONTEXT(g_package,'.allow_requestor_approval',c_item_type,c_item_key);
724: RAISE;
725: end allow_requestor_approval ;
726:
727: --

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

959: END IF;
960:
961: EXCEPTION
962: WHEN OTHERS THEN NULL;
963: WF_CORE.Context(g_package, '.apps_initialize',
964: p_itemtype, p_itemkey, p_actid, p_funcmode);
965: RAISE;
966: END apps_initialize;
967:

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

1046: END IF;
1047:
1048: EXCEPTION
1049: WHEN OTHERS THEN
1050: WF_CORE.CONTEXT(g_package,'.defer_commit',p_item_type,p_item_key);
1051: RAISE;
1052:
1053: END defer_commit;
1054:

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

1100: return null;
1101: end if;
1102: exception
1103: when others then
1104: Wf_Core.Context('hr_workflow_ss', 'GetActivityAttrText', itemtype, itemkey,
1105: to_char(actid), aname);
1106: raise;
1107: end GetActivityAttrText;
1108:

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

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

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

1191: return null;
1192: end if;
1193: exception
1194: when others then
1195: Wf_Core.Context('hr_workflow_ss', 'GetActivityAttrNumber', itemtype, itemkey,
1196: to_char(actid), aname);
1197: raise;
1198: end GetActivityAttrNumber;
1199:

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

1366: return null;
1367: end if;
1368: exception
1369: when others then
1370: Wf_Core.Context('hr_workflow_ss', 'GetItemAttrText', itemtype, itemkey,
1371: aname);
1372: raise;
1373: end GetItemAttrText;
1374:

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

1417:
1418: exception
1419: when others then
1420: hr_utility.set_location('hr_workflow_ss.get_item_type_and_key errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
1421: Wf_Core.Context('hr_workflow_ss', 'get_item_type_and_key', p_ntfId);
1422: raise;
1423: end get_item_type_and_key;
1424:
1425: procedure build_edit_link(document_id IN Varchar2,

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

1569: when others then
1570: document := null;
1571: document_type :=null;
1572: hr_utility.set_location('hr_workflow_ss.build_edit_link errored : '||SQLERRM ||' '||to_char(SQLCODE), 20);
1573: Wf_Core.Context('hr_workflow_ss', 'build_edit_link', document_id, display_type);
1574: raise;
1575: end build_edit_link;
1576:
1577:

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

1588: if g_debug then
1589: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1590: end if;
1591: if ((nid is null) or (aname is null)) then
1592: wf_core.token('NID', to_char(nid));
1593: wf_core.token('ANAME', aname);
1594: wf_core.raise('WFSQL_ARGS');
1595: end if;
1596:

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

1589: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1590: end if;
1591: if ((nid is null) or (aname is null)) then
1592: wf_core.token('NID', to_char(nid));
1593: wf_core.token('ANAME', aname);
1594: wf_core.raise('WFSQL_ARGS');
1595: end if;
1596:
1597: begin

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

1590: end if;
1591: if ((nid is null) or (aname is null)) then
1592: wf_core.token('NID', to_char(nid));
1593: wf_core.token('ANAME', aname);
1594: wf_core.raise('WFSQL_ARGS');
1595: end if;
1596:
1597: begin
1598: if g_debug then

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

1606: when no_data_found then
1607: if(ignore_notfound='TRUE') then
1608: return null;
1609: else
1610: wf_core.token('NID', to_char(nid));
1611: wf_core.token('ATTRIBUTE', aname);
1612: wf_core.raise('WFNTF_ATTR');
1613: end if;
1614: end;

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

1607: if(ignore_notfound='TRUE') then
1608: return null;
1609: else
1610: wf_core.token('NID', to_char(nid));
1611: wf_core.token('ATTRIBUTE', aname);
1612: wf_core.raise('WFNTF_ATTR');
1613: end if;
1614: end;
1615:

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

1608: return null;
1609: else
1610: wf_core.token('NID', to_char(nid));
1611: wf_core.token('ATTRIBUTE', aname);
1612: wf_core.raise('WFNTF_ATTR');
1613: end if;
1614: end;
1615:
1616: return(lvalue);

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

1615:
1616: return(lvalue);
1617: exception
1618: when others then
1619: wf_core.context('hr_workflow_ss', 'GetAttrNumber', to_char(nid), aname);
1620: hr_utility.set_location('Error querying wf_notification_attributes.NUMBER_VALUE for aname:nid'||aname||':'||nid||'-'||SQLERRM ||' '||to_char(SQLCODE), 10);
1621: raise;
1622: end GetAttrNumber;
1623:

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

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

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

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

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

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

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

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

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

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

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

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

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

1660:
1661: return(lvalue);
1662: exception
1663: when others then
1664: wf_core.context('hr_workflow_ss', 'GetAttrText', to_char(nid), aname);
1665: hr_utility.set_location('Error querying wf_notification_attributes.text_value for aname:nid'||aname||':'||nid||'-'||SQLERRM ||' '||to_char(SQLCODE), 10);
1666: raise;
1667: end GetAttrText;
1668:

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

1719: return c_creator_person_id;
1720:
1721: EXCEPTION
1722: WHEN OTHERS THEN
1723: WF_CORE.CONTEXT(g_package,'.getApprStartingPointPersonId',c_item_type,c_item_key);
1724: RAISE;
1725: end getApprStartingPointPersonId;
1726:
1727:

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

1797: end if;
1798:
1799: EXCEPTION
1800: WHEN OTHERS THEN
1801: WF_CORE.CONTEXT(g_package,'.updateSFLTransaction',itemtype,itemkey,funmode);
1802: hr_utility.set_location(''||SQLERRM ||' '||to_char(SQLCODE), 100);
1803: RAISE;
1804:
1805:

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

1893: exception
1894: when others then
1895: document :=null;
1896: hr_utility.set_location('hr_workflow_ss.getProcessDisplayName errored : '||SQLERRM ||' '||to_char(SQLCODE), 20);
1897: Wf_Core.Context('hr_workflow_ss', 'getProcessDisplayName', document_id, display_type);
1898: raise;
1899: end getProcessDisplayName;
1900:
1901:

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

1946: exception
1947: when others then
1948: document :=null;
1949: hr_utility.set_location('hr_workflow_ss.getApprovalMsgSubject errored for custom call: '||SQLERRM ||' '||to_char(SQLCODE), 100);
1950: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);
1951: raise;
1952: end;
1953:
1954:

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

2090: exception
2091: when others then
2092: document :=null;
2093: hr_utility.set_location('hr_workflow_ss.getApprovalMsgSubject errored : '||SQLERRM ||' '||to_char(SQLCODE), 40);
2094: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);
2095: raise;
2096: end getApprovalMsgSubject;
2097:
2098: