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.POS_WCAPPROVE_PVT dependencies on POS_WCAPPROVE_PVT

Line 1: PACKAGE BODY POS_WCAPPROVE_PVT AS

1: PACKAGE BODY POS_WCAPPROVE_PVT AS
2: /* $Header: POSVWCAB.pls 120.31.12020000.5 2013/06/03 11:19:21 ppotnuru ship $ */
3: --
4: -- Purpose: APIs called from the receiving processor to approve WCR document.
5: --

Line 13: G_PKG_NAME CONSTANT VARCHAR2(30) := 'POS_WCAPPROVE_PVT';

9: -- pparthas 02/15/05 Created Package
10: --
11: --
12:
13: G_PKG_NAME CONSTANT VARCHAR2(30) := 'POS_WCAPPROVE_PVT';
14: G_FILE_NAME CONSTANT VARCHAR2(30) := 'POSVWCAS.pls';
15: g_module_prefix CONSTANT VARCHAR2(50) := 'pos.plsql.' || g_pkg_name || '.';
16:
17: g_asn_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

Line 38: l_module := 'pos.plsql.pos_wcapprove_pvt.'||p_api_name;

34: LEVEL_PROCEDURE CONSTANT NUMBER := 2;
35: LEVEL_STATEMENT CONSTANT NUMBER := 1;
36: */
37:
38: l_module := 'pos.plsql.pos_wcapprove_pvt.'||p_api_name;
39: IF(g_asn_debug = 'Y')THEN
40: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
41: FND_LOG.string(LOG_LEVEL => p_level,
42: MODULE => l_module,

Line 101: l_progress := 'POS_WCAPPROVE_PVT.start_wf_progress: 01';

97: l_orgid number;
98: l_po_header_id number;
99:
100: begin
101: l_progress := 'POS_WCAPPROVE_PVT.start_wf_progress: 01';
102:
103: IF (g_asn_debug = 'Y') THEN
104: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
105: 'Enter Start_wf_process ' || l_progress);

Line 124: l_progress := 'POS_WCAPPROVE_PVT.start_wf_process: 02';

120: /* Check to see if process has already been created.
121: * If so, dont create again.
122: */
123:
124: l_progress := 'POS_WCAPPROVE_PVT.start_wf_process: 02';
125: If ((p_itemtype is not null) and (l_itemkey is not null) and
126: (p_work_confirmation_id is not null)) then --{
127:
128: begin

Line 199: l_progress := 'POS_WCAPPROVE_PVT.start_wf_process: 03.';

195: aname => 'WORK_CONFIRMATION_NUMBER',
196: avalue => l_work_confirmation_number);
197:
198:
199: l_progress := 'POS_WCAPPROVE_PVT.start_wf_process: 03.';
200: select max(po_header_id)
201: into l_po_header_id
202: from rcv_shipment_lines
203: where shipment_header_id = p_work_confirmation_id;

Line 214: POS_WCAPPROVE_PVT.get_multiorg_context(l_po_header_id,l_orgid);

210: itemkey => l_itemkey,
211: aname => 'PO_DOCUMENT_ID',
212: avalue => l_po_header_id);
213:
214: POS_WCAPPROVE_PVT.get_multiorg_context(l_po_header_id,l_orgid);
215: IF l_orgid is NOT NULL THEN
216:
217: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
218:

Line 311: l_progress := 'POS_WCAPPROVE_PVT.close_old_notifications: 01';

307: l_api_name varchar2(50) := p_itemkey || ' close_old_notif';
308:
309: begin
310:
311: l_progress := 'POS_WCAPPROVE_PVT.close_old_notifications: 01';
312:
313: IF (g_asn_debug = 'Y') THEN
314: debug_log(FND_LOG.LEVEL_STATEMENT,
315: l_api_name,'Enter close_old_notif ' || l_progress);

Line 362: l_progress := 'POS_WCAPPROVE_PVT.close_old_notif: 02.';

358: end if;
359:
360: x_resultout := wf_engine.eng_completed ;
361:
362: l_progress := 'POS_WCAPPROVE_PVT.close_old_notif: 02.';
363:
364: IF (g_asn_debug = 'Y') THEN
365: debug_log(FND_LOG.LEVEL_STATEMENT,
366: l_api_name,'Leave close_old_notif ' || l_progress);

Line 400: l_progress := 'POS_WCAPPROVE_PVT.set_startup_values: 01.';

396: l_respond_to_wc_url varchar2(1000);
397: l_employee_id NUMBER;
398:
399: begin
400: l_progress := 'POS_WCAPPROVE_PVT.set_startup_values: 01.';
401: IF (g_asn_debug = 'Y') THEN
402: debug_log(FND_LOG.LEVEL_STATEMENT,
403: l_api_name,'Enter in set_startup_values ' || l_progress);
404: END IF;

Line 423: l_progress := 'POS_WCAPPROVE_PVT.set_startup_values: 02.';

419: l_api_name,'l_work_confirmation_id ' ||
420: l_work_confirmation_id);
421: END IF;
422:
423: l_progress := 'POS_WCAPPROVE_PVT.set_startup_values: 02.';
424: select created_by
425: into l_wc_preparer_id
426: from rcv_shipment_headers
427: where shipment_header_id= l_work_confirmation_id;

Line 446: l_progress := 'POS_WCAPPROVE_PVT.set_startup_values: 03.';

442: itemkey => p_itemkey,
443: aname => 'WC_PREPARER_ID',
444: avalue => l_wc_preparer_id);
445:
446: l_progress := 'POS_WCAPPROVE_PVT.set_startup_values: 03.';
447: if (l_employee_id is not null) then
448: get_user_name('PER',l_employee_id, l_wc_preparer_name,
449: l_wc_preparer_display_name);
450: else

Line 473: l_progress := 'POS_WCAPPROVE_PVT.set_startup_values: 04.';

469: itemkey => p_itemkey,
470: aname => 'WC_PREPARER_DISPLAY_NAME' ,
471: avalue => l_wc_preparer_display_name);
472:
473: l_progress := 'POS_WCAPPROVE_PVT.set_startup_values: 04.';
474: l_po_header_id :=
475: wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
476: itemkey => p_itemkey,
477: aname => 'PO_DOCUMENT_ID');

Line 494: l_progress := 'POS_WCAPPROVE_PVT.set_startup_values: 05.';

490: itemkey => p_itemkey,
491: aname => 'DOC_STATUS',
492: avalue => 'NOTREJECTED');
493:
494: l_progress := 'POS_WCAPPROVE_PVT.set_startup_values: 05.';
495: select poh.segment1,
496: poh.agent_id
497: into l_po_number,
498: l_po_preparer_id

Line 514: l_progress := 'POS_WCAPPROVE_PVT.set_startup_values: 06.';

510: itemkey => p_itemkey,
511: aname => 'PO_PREPARER_ID',
512: avalue => l_po_preparer_id);
513:
514: l_progress := 'POS_WCAPPROVE_PVT.set_startup_values: 06.';
515: get_user_name('PER',l_po_preparer_id, l_po_preparer_name,
516: l_po_preparer_display_name);
517:
518: IF (g_asn_debug = 'Y') THEN

Line 594: l_progress := 'POS_WCAPPROVE_PVT.set_startup_values: 06.';

590: avalue => l_respond_to_wc_url);
591:
592: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
593:
594: l_progress := 'POS_WCAPPROVE_PVT.set_startup_values: 06.';
595: IF (g_asn_debug = 'Y') THEN
596: debug_log(FND_LOG.LEVEL_STATEMENT,
597: l_api_name,'Leave set_startup_values '
598: || l_progress);

Line 621: l_progress := 'POS_WCAPPROVE_PVT.update_workflow_info: 01.';

617: l_progress varchar2(300);
618: l_api_name varchar2(50) := p_itemkey || ' update_workflow_info';
619: begin
620:
621: l_progress := 'POS_WCAPPROVE_PVT.update_workflow_info: 01.';
622: IF (g_asn_debug = 'Y') THEN
623: debug_log(FND_LOG.LEVEL_STATEMENT,
624: l_api_name,'Enter in update_workflow_info ' || l_progress);
625: END IF;

Line 638: l_progress := 'POS_WCAPPROVE_PVT.update_workflow_info: 02.';

634: (itemtype => p_itemtype,
635: itemkey => p_itemkey,
636: aname => 'WORK_CONFIRMATION_ID');
637:
638: l_progress := 'POS_WCAPPROVE_PVT.update_workflow_info: 02.';
639: IF (g_asn_debug = 'Y') THEN
640: debug_log(FND_LOG.LEVEL_STATEMENT,
641: l_api_name,'l_shipment_header_id ' || l_shipment_header_id);
642: END IF;

Line 648: l_progress := 'POS_WCAPPROVE_PVT.update_workflow_info: 02.';

644: UpdateWorkflowInfo(p_itemtype,p_itemkey,l_shipment_header_id);
645:
646: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
647:
648: l_progress := 'POS_WCAPPROVE_PVT.update_workflow_info: 02.';
649: IF (g_asn_debug = 'Y') THEN
650: debug_log(FND_LOG.LEVEL_STATEMENT,
651: l_api_name,'Leave update_workflow_info ' || l_progress);
652: END IF;

Line 686: l_progress := 'POS_WCAPPROVE_PVT.get_wc_attributes: 01.';

682: l_attachment_id number;
683: l_progress varchar2(300);
684: l_api_name varchar2(50) := p_itemkey || ' get_wc_attributes';
685: begin
686: l_progress := 'POS_WCAPPROVE_PVT.get_wc_attributes: 01.';
687: IF (g_asn_debug = 'Y') THEN
688: debug_log(FND_LOG.LEVEL_STATEMENT,
689: l_api_name,'Enter in get_wc_attributes '
690: || l_progress);

Line 712: l_progress := 'POS_WCAPPROVE_PVT.get_wc_attributes: 02.';

708:
709: /* See if atleast one shipment have attachments*/
710:
711: /*
712: l_progress := 'POS_WCAPPROVE_PVT.get_wc_attributes: 02.';
713: select count(*)
714: into l_attach_count
715: from fnd_attached_documents
716: where entity_name =' RCV_LINES'

Line 801: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 01.';

797: and object_type_code='WC'
798: and sequence_num = l_seq_num;
799: BEGIN
800:
801: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 01.';
802: IF (g_asn_debug = 'Y') THEN
803: debug_log(FND_LOG.LEVEL_STATEMENT,
804: l_api_name,'Enter in Ins_Actionhist_submit '
805: || l_progress);

Line 823: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 02.';

819: debug_log(FND_LOG.LEVEL_STATEMENT,
820: l_api_name,'l_shipment_header_id ' || l_shipment_header_id);
821: END IF;
822:
823: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 02.';
824: l_wc_preparer_id := wf_engine.GetItemAttrNumber
825: (itemtype => p_itemtype,
826: itemkey => p_itemkey,
827: aname => 'WC_PREPARER_ID');

Line 835: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 03.';

831: l_api_name,'l_wc_preparer_id ' || l_wc_preparer_id);
832: END IF;
833:
834:
835: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 03.';
836:
837: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 04.';
838:
839:

Line 837: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 04.';

833:
834:
835: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 03.';
836:
837: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 04.';
838:
839:
840: /* Check if this document had been submitted to workflow at
841: * some point and somehow kicked out. If that's the case, the

Line 845: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 05.';

841: * some point and somehow kicked out. If that's the case, the
842: * sequence number needs to be incremented by one. Otherwise
843: * start at zero.
844: */
845: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 05.';
846:
847: Open action_hist_cursor(l_shipment_header_id );
848: Fetch action_hist_cursor into l_sequence_num;
849: close action_hist_cursor;

Line 868: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 06.';

864: l_api_name,'l_sequence_num ' ||
865: l_sequence_num);
866: END IF;
867:
868: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 06.';
869:
870: IF ((l_sequence_num = 0)
871: OR
872: (l_sequence_num > 0 and l_action_code is NOT NULL)) THEN --{

Line 957: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 07.';

953:
954:
955: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
956:
957: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 07.';
958: IF (g_asn_debug = 'Y') THEN
959: debug_log(FND_LOG.LEVEL_STATEMENT,
960: l_api_name,'Leave Ins_Actionhist_submit ' || l_progress);
961: END IF;

Line 1002: l_progress := 'POS_WCAPPROVE_PVT.get_next_approver: 01.';

998: l_respond_to_wc_url varchar2(1000);
999: l_default_approver varchar2(30);
1000: BEGIN
1001:
1002: l_progress := 'POS_WCAPPROVE_PVT.get_next_approver: 01.';
1003: IF (g_asn_debug = 'Y') THEN
1004: debug_log(FND_LOG.LEVEL_STATEMENT,
1005: l_api_name,'Enter in get_next_approver '
1006: || l_progress);

Line 1058: l_progress := 'POS_WCAPPROVE_PVT.get_next_approver: 02.';

1054: IF (g_asn_debug = 'Y') THEN
1055: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
1056: 'l_transaction_type ' || l_transaction_type);
1057: END IF;
1058: l_progress := 'POS_WCAPPROVE_PVT.get_next_approver: 02.';
1059: IF (g_asn_debug = 'Y') THEN
1060: debug_log(FND_LOG.LEVEL_STATEMENT,
1061: l_api_name,'in get_next_approver '
1062: || l_progress);

Line 1303: l_progress := 'POS_WCAPPROVE_PVT.get_next_approver: 03.';

1299: aname => 'AME_AUTHORITY_TYPE' ,
1300: avalue => l_authority_type);
1301:
1302: l_orig_system:= 'PER';
1303: l_progress := 'POS_WCAPPROVE_PVT.get_next_approver: 03.';
1304:
1305: WF_DIRECTORY.GetUserName(l_orig_system,
1306: l_next_approver_id,
1307: l_next_approver_user_name,

Line 1417: l_progress := 'POS_WCAPPROVE_PVT.Insert_Action_History: 01.';

1413:
1414:
1415:
1416:
1417: l_progress := 'POS_WCAPPROVE_PVT.Insert_Action_History: 01.';
1418: IF (g_asn_debug = 'Y') THEN
1419: debug_log(FND_LOG.LEVEL_STATEMENT,
1420: l_api_name,'Enter in Insert_Action_History '
1421: || l_progress);

Line 1447: l_progress := 'POS_WCAPPROVE_PVT.Insert_Action_History: 04.';

1443:
1444:
1445:
1446: -- loop --{
1447: l_progress := 'POS_WCAPPROVE_PVT.Insert_Action_History: 04.';
1448:
1449: SELECT count(*)
1450: INTO l_count
1451: FROM PO_ACTION_HISTORY

Line 1626: l_progress := 'POS_WCAPPROVE_PVT.Approve_shipment_lines: 01.';

1622: ORDER BY activity_end_date DESC;
1623:
1624: BEGIN
1625:
1626: l_progress := 'POS_WCAPPROVE_PVT.Approve_shipment_lines: 01.';
1627: IF (g_asn_debug = 'Y') THEN
1628: debug_log(FND_LOG.LEVEL_STATEMENT,
1629: l_api_name,'Enter in Approve_shipment_lines '
1630: || l_progress);

Line 1722: l_progress := 'POS_WCAPPROVE_PVT Reject_shipment_lines: 01.';

1718: ORDER BY activity_end_date DESC;
1719:
1720: BEGIN
1721:
1722: l_progress := 'POS_WCAPPROVE_PVT Reject_shipment_lines: 01.';
1723: IF (g_asn_debug = 'Y') THEN
1724: debug_log(FND_LOG.LEVEL_STATEMENT,
1725: l_api_name,'Enter in Reject_shipment_lines '
1726: || l_progress);

Line 1806: l_progress := 'POS_WCAPPROVE_PVT.Approve_OR_Reject: 01.';

1802: l_api_name varchar2(50) := p_itemkey || ' approve_or_reject';
1803:
1804: BEGIN
1805:
1806: l_progress := 'POS_WCAPPROVE_PVT.Approve_OR_Reject: 01.';
1807: IF (g_asn_debug = 'Y') THEN
1808: debug_log(FND_LOG.LEVEL_STATEMENT,
1809: l_api_name,'Enter in Approve_OR_Reject '
1810: || l_progress);

Line 1933: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_List_Response: 01.';

1929: l_reject_lines number;
1930:
1931:
1932: begin
1933: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_List_Response: 01.';
1934: IF (g_asn_debug = 'Y') THEN
1935: debug_log(FND_LOG.LEVEL_STATEMENT,
1936: l_api_name,
1937: 'Enter in Update_Approval_List_Response '

Line 1989: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_List_Response'

1985: ' l_response '
1986: || substr(l_response,1,50));
1987: END IF;
1988:
1989: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_List_Response'
1990: || ': 02.';
1991:
1992:
1993: SELECT wfn.responder, wfn.recipient_role, wfn.end_date

Line 2040: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_List_Response'

2036: IF (c_responderid%ISOPEN) THEN
2037: CLOSE c_responderid;
2038: END IF;
2039:
2040: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_List_Response'
2041: || ':02.';
2042: wf_engine.SetItemAttrNumber(itemtype => p_itemType,
2043: itemkey => p_itemkey,
2044: aname => 'RESPONDER_ID',

Line 2065: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_List_Response'

2061: ' l_responder_disp_name '
2062: || l_responder_disp_name);
2063: end if;
2064:
2065: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_List_Response'
2066: || ': 03.';
2067: wf_engine.SetItemAttrText( itemtype => p_itemType,
2068: itemkey => p_itemkey,
2069: aname => 'RESPONDER_USER_NAME' ,

Line 2077: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_List_Response'

2073: itemkey => p_itemkey,
2074: aname => 'RESPONDER_DISPLAY_NAME' ,
2075: avalue => l_responder_disp_name);
2076:
2077: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_List_Response'
2078: || ': 04.';
2079:
2080: /* We cannot have response as forward. Need to remove it later
2081: IF (INSTR(l_response, 'FORWARD') > 0) THEN

Line 2095: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_List_Response'

2091: || l_forward_to_id);
2092: END IF;
2093: */
2094:
2095: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_List_Response'
2096: || ': 05.';
2097:
2098: END IF; -- }c_group_id
2099:

Line 2282: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_History_Approve: 01.';

2278: x_resultout out NOCOPY varchar2) IS
2279: l_progress varchar2(300);
2280: l_api_name varchar2(50) := p_itemkey || ' update_action_history_approve';
2281: begin
2282: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_History_Approve: 01.';
2283: IF (g_asn_debug = 'Y') THEN
2284: debug_log(FND_LOG.LEVEL_STATEMENT,
2285: l_api_name,
2286: 'Enter in Update_Action_History_Approve '

Line 2330: l_progress := 'POS_WCAPPROVE_PVT.Update_action_history_reject: 01.';

2326: x_resultout out NOCOPY varchar2) IS
2327: l_progress varchar2(300);
2328: l_api_name varchar2(50) := p_itemkey || ' update_action_history_Reject';
2329: begin
2330: l_progress := 'POS_WCAPPROVE_PVT.Update_action_history_reject: 01.';
2331: IF (g_asn_debug = 'Y') THEN
2332: debug_log(FND_LOG.LEVEL_STATEMENT,
2333: l_api_name,
2334: 'Enter in Update_Action_History_Reject '

Line 2411: l_progress := 'POS_WCAPPROVE_PVT.Update_Action_history: 01.';

2407: l_responder wf_notifications.responder%TYPE;
2408:
2409:
2410: begin
2411: l_progress := 'POS_WCAPPROVE_PVT.Update_Action_history: 01.';
2412: IF (g_asn_debug = 'Y') THEN
2413: debug_log(FND_LOG.LEVEL_STATEMENT,
2414: l_api_name,
2415: 'Enter in Update_Action_History '

Line 2433: l_progress := 'POS_WCAPPROVE_PVT.Update_Action_history: 02.';

2429: || l_shipment_header_id);
2430: END IF;
2431:
2432:
2433: l_progress := 'POS_WCAPPROVE_PVT.Update_Action_history: 02.';
2434: SELECT nvl(max(wf.notification_id), -9995)
2435: into l_notification_id
2436: FROM wf_notifications wf,
2437: wf_item_activity_statuses wias

Line 2450: l_progress := 'POS_WCAPPROVE_PVT.Update_Action_history: 03.';

2446: || l_notification_id);
2447: END IF;
2448:
2449:
2450: l_progress := 'POS_WCAPPROVE_PVT.Update_Action_history: 03.';
2451: SELECT wfn.responder, wfn.recipient_role,
2452: wfn.original_recipient, wfn.more_info_role
2453: INTO l_responder, l_recipient_role,
2454: l_original_recipient, l_more_info_role

Line 2519: l_progress := 'POS_WCAPPROVE_PVT.update_approval_history: 04.';

2515: l_more_origsysid);
2516: end if;
2517:
2518: --loop --{
2519: l_progress := 'POS_WCAPPROVE_PVT.update_approval_history: 04.';
2520:
2521:
2522: IF (g_asn_debug = 'Y') THEN
2523: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 2600: l_progress := 'POS_WCAPPROVE_PVT.UpdateActionHistory: 01.';

2596: Recinfo get_action_history%ROWTYPE;
2597:
2598: BEGIN
2599:
2600: l_progress := 'POS_WCAPPROVE_PVT.UpdateActionHistory: 01.';
2601: IF (g_asn_debug = 'Y') THEN
2602: debug_log(FND_LOG.LEVEL_STATEMENT,
2603: l_api_name,'Enter in UpdateActionHistory '
2604: || l_progress);

Line 2729: l_progress := 'POS_WCAPPROVE_PVT.UpdateActionHistory: 02.';

2725:
2726:
2727: end if; --}
2728:
2729: l_progress := 'POS_WCAPPROVE_PVT.UpdateActionHistory: 02.';
2730:
2731: IF (not p_last_approver) THEN
2732:
2733: /**

Line 2786: l_progress := 'POS_WCAPPROVE_PVT.get_user_name: 01.';

2782: l_api_name varchar2(50) := ' get_user_name';
2783:
2784: BEGIN
2785:
2786: l_progress := 'POS_WCAPPROVE_PVT.get_user_name: 01.';
2787: IF (g_asn_debug = 'Y') THEN
2788: debug_log(FND_LOG.LEVEL_STATEMENT,
2789: l_api_name,'Enter in get_user_name '
2790: || l_progress);

Line 2833: l_progress := 'POS_WCAPPROVE_PVT.UpdatePOActionHistory: 01.';

2829: l_api_name varchar2(50) := ' UpdatePOActionHistory';
2830: l_note po_action_history.note%type;
2831:
2832: BEGIN
2833: l_progress := 'POS_WCAPPROVE_PVT.UpdatePOActionHistory: 01.';
2834: IF (g_asn_debug = 'Y') THEN
2835: debug_log(FND_LOG.LEVEL_STATEMENT,
2836: l_api_name,'Enter in UpdatePOActionHistory '
2837: || l_progress);

Line 2882: l_progress := 'POS_WCAPPROVE_PVT.UpdatePOActionHistory: 02.';

2878: END IF;
2879:
2880: end if;
2881:
2882: l_progress := 'POS_WCAPPROVE_PVT.UpdatePOActionHistory: 02.';
2883: IF (g_asn_debug = 'Y') THEN
2884: debug_log(FND_LOG.LEVEL_STATEMENT,
2885: l_api_name,'Before Update '
2886: || l_progress);

Line 2925: l_progress := 'POS_WCAPPROVE_PVT.UpdatePOActionHistory: 02.';

2921: AND action_code IS NULL;
2922: --employee_id = NVL(p_old_employee_id, employee_id)
2923:
2924: ELSE --}{
2925: l_progress := 'POS_WCAPPROVE_PVT.UpdatePOActionHistory: 02.';
2926: IF (g_asn_debug = 'Y') THEN
2927: debug_log(FND_LOG.LEVEL_STATEMENT,
2928: l_api_name,
2929: 'Either object id or code is null '

Line 2982: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 01.';

2978: BEGIN
2979:
2980:
2981:
2982: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 01.';
2983: IF (g_asn_debug = 'Y') THEN
2984: debug_log(FND_LOG.LEVEL_STATEMENT,
2985: l_api_name,'Enter in InsertPOActionHistory '
2986: || l_progress);

Line 3000: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 02.';

2996:
2997: IF (l_sequence_num is NULL ) THEN --{
2998:
2999:
3000: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 02.';
3001:
3002: SELECT MAX(sequence_num)
3003: INTO l_sequence_num
3004: FROM PO_ACTION_HISTORY

Line 3008: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 03.';

3004: FROM PO_ACTION_HISTORY
3005: WHERE object_id = p_object_id
3006: AND object_type_code = p_object_type_code;
3007:
3008: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 03.';
3009:
3010: IF (l_sequence_num IS NULL) THEN
3011: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 04.';
3012: l_sequence_num := 0;

Line 3011: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 04.';

3007:
3008: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 03.';
3009:
3010: IF (l_sequence_num IS NULL) THEN
3011: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 04.';
3012: l_sequence_num := 0;
3013: ELSE
3014: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 05.';
3015: l_sequence_num := l_sequence_num + 1;

Line 3014: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 05.';

3010: IF (l_sequence_num IS NULL) THEN
3011: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 04.';
3012: l_sequence_num := 0;
3013: ELSE
3014: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 05.';
3015: l_sequence_num := l_sequence_num + 1;
3016: END IF;
3017:
3018: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 06.';

Line 3018: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 06.';

3014: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 05.';
3015: l_sequence_num := l_sequence_num + 1;
3016: END IF;
3017:
3018: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 06.';
3019:
3020:
3021: END IF; --}
3022:

Line 3023: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 07.';

3019:
3020:
3021: END IF; --}
3022:
3023: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 07.';
3024:
3025: IF (g_asn_debug = 'Y') THEN
3026: debug_log(FND_LOG.LEVEL_STATEMENT,
3027: l_api_name,'l_sequence_num before insert '

Line 3150: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 01.';

3146: Recinfo get_action_history%ROWTYPE;
3147:
3148: BEGIN
3149:
3150: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 01.';
3151: IF (g_asn_debug = 'Y') THEN
3152: debug_log(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Enter in post_approval_notif ' || l_progress);
3153: debug_log(FND_LOG.LEVEL_STATEMENT, l_api_name, 'p_itemtype ' || p_itemtype);
3154: debug_log(FND_LOG.LEVEL_STATEMENT, l_api_name, 'p_itemkey ' || p_itemkey);

Line 3177: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 02.';

3173: END IF;
3174:
3175: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_NEW_ROLE, l_origsys, l_new_recipient_id);
3176:
3177: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 02.';
3178:
3179: select max(sequence_num)
3180: into l_sequence_num
3181: from po_action_history

Line 3262: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 03.' ;

3258: else
3259: l_preserved_ctx := 'FALSE';
3260: end if;
3261:
3262: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 03.' ;
3263:
3264: --
3265: IF (g_asn_debug = 'Y') THEN
3266: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_progress ' ||l_progress);

Line 3279: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 04.' ;

3275: wf_notifications wfn
3276: WHERE wfn.notification_id = l_notification_id
3277: AND wfn.original_recipient = fu.user_name;
3278:
3279: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 04.' ;
3280:
3281: --
3282: IF (g_asn_debug = 'Y') THEN
3283: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_progress ' ||l_progress);

Line 3327: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 05.' ;

3323: l_preparer_appl_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
3324: itemkey => p_itemkey,
3325: aname => 'APPLICATION_ID');
3326:
3327: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 05.' ;
3328:
3329: --
3330: IF (g_asn_debug = 'Y') THEN
3331: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_progress ' ||l_progress);

Line 3344: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 06.' ;

3340: 1. when the response is made from email using guest user feature
3341: 2. When the response is made from sysadmin login
3342: */
3343:
3344: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 06.' ;
3345:
3346: --
3347: IF (g_asn_debug = 'Y') THEN
3348: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_progress ' ||l_progress || 'When the response is made from email using guest user feature');

Line 3365: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 07.' ;

3361: itemkey => p_itemkey,
3362: aname => 'RESPONDER_APPL_ID',
3363: avalue => l_preparer_appl_id);
3364: ELSE
3365: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 07.' ;
3366:
3367: --
3368: IF (g_asn_debug = 'Y') THEN
3369: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_progress ' ||l_progress || 'When the response is made from sysadmin login');

Line 3376: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 08.' ;

3372:
3373: if (l_session_resp_id is null) THEN
3374: /* possible when the response is made from the default worklist
3375: without choosing a valid responsibility */
3376: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 08.' ;
3377:
3378: --
3379: IF (g_asn_debug = 'Y') THEN
3380: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_progress ' ||l_progress || 'When the response is made from the default worklist');

Line 3404: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 09.' ;

3400: through the email or the background process picks the wf up.
3401: This may happen due to the fact that the mailer / background process
3402: carries the context set by the notification /wf it processed last */
3403:
3404: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 09.' ;
3405:
3406: --
3407: IF (g_asn_debug = 'Y') THEN
3408: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_progress ' ||l_progress || 'When the response is made after choosing a correct responsibility');

Line 3482: l_progress := 'POS_WCAPPROVE_PVT.reject_doc: 01.';

3478: l_work_confirmation_number varchar2(30);
3479: l_note varchar2(4000);
3480: l_view_wc_lines_detail_url varchar2(1000);
3481: begin
3482: l_progress := 'POS_WCAPPROVE_PVT.reject_doc: 01.';
3483: IF (g_asn_debug = 'Y') THEN
3484: debug_log(FND_LOG.LEVEL_STATEMENT,
3485: l_api_name,
3486: 'Enter in reject_doc '

Line 3495: l_progress := 'POS_WCAPPROVE_PVT.reject_doc: 02.';

3491: x_resultout := wf_engine.eng_null;
3492: return;
3493: end if;
3494:
3495: l_progress := 'POS_WCAPPROVE_PVT.reject_doc: 02.';
3496: l_shipment_header_id := wf_engine.GetItemAttrNumber
3497: (itemtype => p_itemtype,
3498: itemkey => p_itemkey,
3499: aname => 'WORK_CONFIRMATION_ID');

Line 3510: l_progress := 'POS_WCAPPROVE_PVT.reject_doc: 03.';

3506: p_level => 'HEADER',
3507: x_resultout => l_result);
3508:
3509:
3510: l_progress := 'POS_WCAPPROVE_PVT.reject_doc: 03.';
3511: IF (l_result = 'N') THEN
3512:
3513: IF (g_asn_debug = 'Y') THEN
3514: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 3600: l_progress := 'POS_WCAPPROVE_PVT.Approve_doc: 01.';

3596: l_note varchar2(4000);
3597: l_view_wc_lines_detail_url varchar2(1000);
3598: l_work_confirmation_number varchar2(30);
3599: begin
3600: l_progress := 'POS_WCAPPROVE_PVT.Approve_doc: 01.';
3601: IF (g_asn_debug = 'Y') THEN
3602: debug_log(FND_LOG.LEVEL_STATEMENT,
3603: l_api_name,
3604: 'Enter in Approve_doc '

Line 3613: l_progress := 'POS_WCAPPROVE_PVT.Approve_doc: 02.';

3609: x_resultout := wf_engine.eng_null;
3610: return;
3611: end if;
3612:
3613: l_progress := 'POS_WCAPPROVE_PVT.Approve_doc: 02.';
3614: l_shipment_header_id := wf_engine.GetItemAttrNumber
3615: (itemtype => p_itemtype,
3616: itemkey => p_itemkey,
3617: aname => 'WORK_CONFIRMATION_ID');

Line 3626: l_progress := 'POS_WCAPPROVE_PVT.Approve_doc: 03.';

3622: p_approval_status => l_approval_status,
3623: p_level => 'HEADER',
3624: x_resultout => l_result);
3625:
3626: l_progress := 'POS_WCAPPROVE_PVT.Approve_doc: 03.';
3627: IF (l_result = 'N') THEN
3628:
3629: IF (g_asn_debug = 'Y') THEN
3630: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 3721: l_progress := 'POS_WCAPPROVE_PVT.update_approval_status: 01.';

3717: l_progress varchar2(300);
3718: l_api_name varchar2(50) := ' update_approval_status';
3719: l_note po_action_history.note%type;
3720: begin
3721: l_progress := 'POS_WCAPPROVE_PVT.update_approval_status: 01.';
3722: IF (g_asn_debug = 'Y') THEN
3723: debug_log(FND_LOG.LEVEL_STATEMENT,
3724: l_api_name,
3725: 'Enter in update_approval_status '

Line 4013: l_progress := 'POS_WCAPPROVE_PVT.insert_into_rti: 01.';

4009: x_sob_Id NUMBER;
4010: /* End of Bug #: 13924722 */
4011:
4012: begin
4013: l_progress := 'POS_WCAPPROVE_PVT.insert_into_rti: 01.';
4014: IF (g_asn_debug = 'Y') THEN
4015: debug_log(FND_LOG.LEVEL_STATEMENT,
4016: l_api_name,
4017: 'Enter in insert_into_rti '

Line 4081: l_progress := 'POS_WCAPPROVE_PVT.insert_into_rti:02.';

4077: open get_wcr_info(l_shipment_header_id);
4078: -- looping through the pay items associated with the current work confirmation
4079: loop --{
4080:
4081: l_progress := 'POS_WCAPPROVE_PVT.insert_into_rti:02.';
4082:
4083: IF (g_asn_debug = 'Y') THEN
4084: debug_log(FND_LOG.LEVEL_STATEMENT,
4085: l_api_name,'before cursor fetch');

Line 4156: l_progress := 'POS_WCAPPROVE_PVT.insert_into_rti:03.';

4152: open get_dist_info(wcr_line_info.po_line_location_id);
4153:
4154: -- looping through the distributions cursor to insert data in RTI
4155: loop --{
4156: l_progress := 'POS_WCAPPROVE_PVT.insert_into_rti:03.';
4157:
4158: IF (g_asn_debug = 'Y') THEN
4159: debug_log(FND_LOG.LEVEL_STATEMENT,
4160: l_api_name,'before cursor fetch');

Line 4861: l_progress := 'POS_WCAPPROVE_PVT.Launch_RTP_Immediate: 01.';

4857: l_result_id number;
4858: l_group_id number;
4859: l_api_name varchar2(50) := p_itemkey || ' Launch_RTP_Immediate';
4860: begin
4861: l_progress := 'POS_WCAPPROVE_PVT.Launch_RTP_Immediate: 01.';
4862: IF (g_asn_debug = 'Y') THEN
4863: debug_log(FND_LOG.LEVEL_STATEMENT,
4864: l_api_name,
4865: 'Enter in Launch_RTP_Immediate '

Line 4960: l_progress := 'POS_WCAPPROVE_PVT.CloseOldNotif: 01';

4956: l_api_name varchar2(50) := p_itemkey || ' CloseOldNotif';
4957: l_progress varchar2(300);
4958: begin
4959:
4960: l_progress := 'POS_WCAPPROVE_PVT.CloseOldNotif: 01';
4961:
4962: IF (g_asn_debug = 'Y') THEN
4963: debug_log(FND_LOG.LEVEL_UNEXPECTED,
4964: l_api_name,'Enter in CloseOldNotif ' || l_progress);

Line 4996: l_progress := 'POS_WCAPPROVE_PVT.UpdateWorkflowInfo: 01';

4992: l_api_name varchar2(50) := p_itemkey || ' UpdateWorkflowInfo';
4993: l_progress varchar2(300);
4994: begin
4995:
4996: l_progress := 'POS_WCAPPROVE_PVT.UpdateWorkflowInfo: 01';
4997:
4998: IF (g_asn_debug = 'Y') THEN
4999: debug_log(FND_LOG.LEVEL_STATEMENT,
5000: l_api_name,'Enter in UpdateWorkflowInfo ' || l_progress);

Line 5043: l_progress := 'POS_WCAPPROVE_PVT.Upd_ActionHistory_Submit: 01';

5039: l_api_name varchar2(50) := ' Upd_ActionHistory_Submit';
5040: l_progress varchar2(280);
5041: begin
5042:
5043: l_progress := 'POS_WCAPPROVE_PVT.Upd_ActionHistory_Submit: 01';
5044: IF (g_asn_debug = 'Y') THEN
5045: debug_log(FND_LOG.LEVEL_UNEXPECTED,
5046: l_api_name,'Enter in Upd_ActionHistory_Submit '
5047: || l_progress);

Line 5091: l_progress := 'POS_WCAPPROVE_PVT.get_multiorg_context: 01';

5087:
5088: l_progress varchar2(300);
5089: l_api_name varchar2(50) := ' get_multiorg_context';
5090: begin
5091: l_progress := 'POS_WCAPPROVE_PVT.get_multiorg_context: 01';
5092: IF (g_asn_debug = 'Y') THEN
5093: debug_log(FND_LOG.LEVEL_STATEMENT,
5094: l_api_name,'Enter in get_multiorg_context '
5095: || l_progress);

Line 5138: l_progress := 'POS_WCAPPROVE_PVT.get_PoHeaderId: 01';

5134: l_progress varchar2(500);
5135: l_po_header_id number;
5136: l_api_name varchar2(50) := 'get_PoHeaderId';
5137: begin
5138: l_progress := 'POS_WCAPPROVE_PVT.get_PoHeaderId: 01';
5139: IF (g_asn_debug = 'Y') THEN
5140: debug_log(FND_LOG.LEVEL_UNEXPECTED,
5141: l_api_name,'Enter in get_PoHeaderId ' || l_progress);
5142: END IF;

Line 5551: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','Inside POWC_SELECTOR procedure');

5547: BEGIN
5548:
5549: --
5550: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5551: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','Inside POWC_SELECTOR procedure');
5552: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_itemtype : '||p_itemtype);
5553: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_itemkey : '||p_itemkey);
5554: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_actid : '||p_actid);
5555: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_funcmode : '||p_funcmode);

Line 5552: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_itemtype : '||p_itemtype);

5548:
5549: --
5550: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5551: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','Inside POWC_SELECTOR procedure');
5552: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_itemtype : '||p_itemtype);
5553: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_itemkey : '||p_itemkey);
5554: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_actid : '||p_actid);
5555: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_funcmode : '||p_funcmode);
5556: END IF;

Line 5553: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_itemkey : '||p_itemkey);

5549: --
5550: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5551: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','Inside POWC_SELECTOR procedure');
5552: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_itemtype : '||p_itemtype);
5553: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_itemkey : '||p_itemkey);
5554: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_actid : '||p_actid);
5555: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_funcmode : '||p_funcmode);
5556: END IF;
5557: --

Line 5554: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_actid : '||p_actid);

5550: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5551: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','Inside POWC_SELECTOR procedure');
5552: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_itemtype : '||p_itemtype);
5553: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_itemkey : '||p_itemkey);
5554: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_actid : '||p_actid);
5555: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_funcmode : '||p_funcmode);
5556: END IF;
5557: --
5558:

Line 5555: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_funcmode : '||p_funcmode);

5551: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','Inside POWC_SELECTOR procedure');
5552: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_itemtype : '||p_itemtype);
5553: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_itemkey : '||p_itemkey);
5554: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_actid : '||p_actid);
5555: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','p_funcmode : '||p_funcmode);
5556: END IF;
5557: --
5558:
5559:

Line 5582: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','l_progress1 : '||l_progress);

5578: --
5579: l_progress :='010 - ses_user_id:'||l_session_user_id ||' ses_resp_id :'||l_session_resp_id||' responder id:' ||l_responder_id||' org id :'||l_org_id;
5580:
5581: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5582: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','l_progress1 : '||l_progress);
5583: END IF;
5584: --
5585:
5586: IF (p_funcmode = 'TEST_CTX') THEN

Line 5643: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','l_progress2 : '||l_progress);

5639: --
5640: l_progress := '020 selection fn responder id not null';
5641:
5642: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5643: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','l_progress2 : '||l_progress);
5644: END IF;
5645: --
5646:
5647: --

Line 5651: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','l_progress3 : '||l_progress);

5647: --
5648: l_progress :='030 selector fn : setting user id :'||l_responder_id ||' resp id '||l_resp_id_to_set||' l_appl id '||l_appl_id_to_set;
5649:
5650: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5651: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','l_progress3 : '||l_progress);
5652: END IF;
5653: --
5654: else
5655: l_user_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

Line 5668: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','l_progress4 : '||l_progress);

5664: --
5665: l_progress := '040 selector fn responder id null';
5666:
5667: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5668: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','l_progress4 : '||l_progress);
5669: END IF;
5670: --
5671:
5672: --

Line 5676: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','l_progress4 : '||l_progress);

5672: --
5673: l_progress := '050 selector fn : set user '||l_user_id_to_set||' resp id ' ||l_resp_id_to_set||' appl id '||l_appl_id_to_set;
5674:
5675: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5676: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','l_progress4 : '||l_progress);
5677: END IF;
5678: --
5679: end if;
5680:

Line 5696: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','Exception in Selector Procedure');

5692:
5693: EXCEPTION WHEN OTHERS THEN
5694:
5695: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5696: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','Exception in Selector Procedure');
5697: END IF;
5698:
5699: WF_CORE.context('POS_WCAPPROVE_PVT', 'POWC_SELECTOR', p_itemtype, p_itemkey, p_actid, p_funcmode);
5700: RAISE;

Line 5699: WF_CORE.context('POS_WCAPPROVE_PVT', 'POWC_SELECTOR', p_itemtype, p_itemkey, p_actid, p_funcmode);

5695: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5696: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','Exception in Selector Procedure');
5697: END IF;
5698:
5699: WF_CORE.context('POS_WCAPPROVE_PVT', 'POWC_SELECTOR', p_itemtype, p_itemkey, p_actid, p_funcmode);
5700: RAISE;
5701:
5702: END POWC_SELECTOR;
5703:

Line 5704: END POS_WCAPPROVE_PVT;

5700: RAISE;
5701:
5702: END POWC_SELECTOR;
5703:
5704: END POS_WCAPPROVE_PVT;