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

Line 1: PACKAGE BODY PO_ChangeOrderWF_PVT AS

1: PACKAGE BODY PO_ChangeOrderWF_PVT AS
2: /* $Header: POXVSCWB.pls 120.52.12020000.3 2013/02/10 18:36:48 vegajula ship $ */
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(50) := 'PO_ChangeOrderWF_PVT';

Line 5: g_pkg_name CONSTANT VARCHAR2(50) := 'PO_ChangeOrderWF_PVT';

1: PACKAGE BODY PO_ChangeOrderWF_PVT AS
2: /* $Header: POXVSCWB.pls 120.52.12020000.3 2013/02/10 18:36:48 vegajula ship $ */
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(50) := 'PO_ChangeOrderWF_PVT';
6: g_module_prefix CONSTANT VARCHAR2(50) := 'po.plsql.' || g_pkg_name || '.';
7: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
8: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
9:

Line 168: t_varval(2) := 'PLSQLCLOB:PO_ChangeOrderWF_PVT.GEN_NTF_FOR_REQ_SUP_CHN/'||

164:
165: t_varname(1) := 'FROM_SUPPLIER';
166: t_varval(1) := l_supplier_username;
167: t_varname(2) := 'NTF_FOR_REQ_SUP_CHN';
168: t_varval(2) := 'PLSQLCLOB:PO_ChangeOrderWF_PVT.GEN_NTF_FOR_REQ_SUP_CHN/'||
169: '@' ||p_header_id||'#'
170: ||p_release_id||'$'
171: ||p_chg_req_grp_id||'%'
172: ||p_requestor_id||'^';

Line 175: t_varval(3) := 'PLSQL:PO_ChangeOrderWF_PVT.GEN_NTF_FOR_REQ_SUBJECT/'||l_item_key;

171: ||p_chg_req_grp_id||'%'
172: ||p_requestor_id||'^';
173:
174: t_varname(3) := 'NTF_FOR_REQ_SUBJECT';
175: t_varval(3) := 'PLSQL:PO_ChangeOrderWF_PVT.GEN_NTF_FOR_REQ_SUBJECT/'||l_item_key;
176: t_varname(4) := 'PREPARER_USERNAME';
177: t_varval(4) := l_requestor_username;
178:
179:

Line 264: t_varval(2) := 'PLSQLCLOB:PO_ChangeOrderWF_PVT.GEN_NTF_FOR_PLAN_SUP_CHN/'||

260:
261: t_varname(1) := 'FROM_SUPPLIER';
262: t_varval(1) := l_supplier_username;
263: t_varname(2) := 'NTF_FOR_PLAN_SUP_CHN';
264: t_varval(2) := 'PLSQLCLOB:PO_ChangeOrderWF_PVT.GEN_NTF_FOR_PLAN_SUP_CHN/'||
265: '@' ||p_header_id||'#'
266: ||p_release_id||'$'
267: ||p_chg_req_grp_id||'%'
268: ||p_planner_id||'^';

Line 271: t_varval(3) := 'PLSQL:PO_ChangeOrderWF_PVT.GEN_NTF_FOR_PLAN_SUBJECT/'||l_item_key;

267: ||p_chg_req_grp_id||'%'
268: ||p_planner_id||'^';
269:
270: t_varname(3) := 'NTF_FOR_PLAN_SUBJECT';
271: t_varval(3) := 'PLSQL:PO_ChangeOrderWF_PVT.GEN_NTF_FOR_PLAN_SUBJECT/'||l_item_key;
272: t_varname(4) := 'PLANNER_USERNAME';
273: t_varval(4) := l_planner_username;
274:
275:

Line 475: wf_core.context('PO_ChangeOrderWF_PVT',

471:
472: commit;
473: EXCEPTION
474: WHEN OTHERS THEN
475: wf_core.context('PO_ChangeOrderWF_PVT',
476: 'InsertActionHist'||sqlerrm,x_progress);
477: raise;
478:
479: END InsertActionHist;

Line 1080: *New version will call PO_ChangeOrderWF_PVT.IS_PO_HDR_REJECTED followed by PO_ChangeOrderWF_PVT.Register_rejection.

1076: /*
1077: *taken from PO_REQAPPROVAL_INIT1
1078: *PO_REQAPPROVAL_INIT1.Register_rejection will be updated to support older version of poxwfpoa.wft
1079: *In other words, initial version of poxwfpoa.wft only calls PO_REQ_APPROVAL_INIT1.Register_rejection.
1080: *New version will call PO_ChangeOrderWF_PVT.IS_PO_HDR_REJECTED followed by PO_ChangeOrderWF_PVT.Register_rejection.
1081: *In order for older version of workflow to have the new functionality, PO_REQ_APPROVAL_INIT1.Register_rejection will
1082: *need to include the logic of PO_ChangeOrderWF_PVT.IS_PO_HDR_REJECTED within.
1083: */
1084: procedure Register_rejection ( itemtype in varchar2,

Line 1082: *need to include the logic of PO_ChangeOrderWF_PVT.IS_PO_HDR_REJECTED within.

1078: *PO_REQAPPROVAL_INIT1.Register_rejection will be updated to support older version of poxwfpoa.wft
1079: *In other words, initial version of poxwfpoa.wft only calls PO_REQ_APPROVAL_INIT1.Register_rejection.
1080: *New version will call PO_ChangeOrderWF_PVT.IS_PO_HDR_REJECTED followed by PO_ChangeOrderWF_PVT.Register_rejection.
1081: *In order for older version of workflow to have the new functionality, PO_REQ_APPROVAL_INIT1.Register_rejection will
1082: *need to include the logic of PO_ChangeOrderWF_PVT.IS_PO_HDR_REJECTED within.
1083: */
1084: procedure Register_rejection ( itemtype in varchar2,
1085: itemkey in varchar2,
1086: actid in number,

Line 1218: x_supp_user_name := PO_ChangeOrderWF_PVT.getEmailResponderUserName

1214: end if;
1215:
1216: if (substr(x_supp_user_name, 1, 6) = 'email:') then
1217: --Get the username and store that in the supplier_user_name.
1218: x_supp_user_name := PO_ChangeOrderWF_PVT.getEmailResponderUserName
1219: (x_supp_user_name, l_ntf_role_name);
1220:
1221:
1222: end if;

Line 1238: wf_core.context('PO_ChangeOrderWF_PVT','Register_rejection',l_progress);

1234: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1235: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1236: l_api_name || '.others_exception', sqlerrm);
1237: END IF;
1238: wf_core.context('PO_ChangeOrderWF_PVT','Register_rejection',l_progress);
1239: raise;
1240: end;
1241:
1242: /*

Line 1531: wf_core.context('PO_ChangeOrderWF_PVT','IS_PO_HDR_REJECTED',x_progress);

1527: l_revision_num,
1528: resultout);
1529: end if;
1530: exception when others then
1531: wf_core.context('PO_ChangeOrderWF_PVT','IS_PO_HDR_REJECTED',x_progress);
1532: raise;
1533: END IS_PO_HDR_REJECTED;
1534:
1535: /*

Line 1598: wf_core.context('PO_ChangeOrderWF_PVT','IsPOHeaderRejected','000');

1594: x_result_code := 'N';
1595: end if;
1596: end if;
1597: exception when others then
1598: wf_core.context('PO_ChangeOrderWF_PVT','IsPOHeaderRejected','000');
1599: raise;
1600: END IsPOHeaderRejected;
1601:
1602: PROCEDURE GEN_NTF_FOR_REQ_SUP_CHN( p_code IN varchar2,

Line 5915: wf_core.context('PO_ChangeOrderWF_PVT','IS_PRORATE_NEEDED',x_progress);

5911: avalue => '');
5912:
5913: end if;
5914: exception when others then
5915: wf_core.context('PO_ChangeOrderWF_PVT','IS_PRORATE_NEEDED',x_progress);
5916: raise;
5917: END IS_PRORATE_NEEDED;
5918:
5919: /*

Line 6048: wf_core.context('PO_ChangeOrderWF_PVT','CHG_STATUS_TO_APPROVED',x_progress);

6044:
6045: end if;
6046:
6047: exception when others then
6048: wf_core.context('PO_ChangeOrderWF_PVT','CHG_STATUS_TO_APPROVED',x_progress);
6049: raise;
6050: END CHG_STATUS_TO_APPROVED;
6051:
6052:

Line 6112: wf_core.context('PO_ChangeOrderWF_PVT','CARRY_SUP_ACK_TO_NEW_REV',x_progress);

6108: l_release_id,
6109: l_revision_num);
6110:
6111: exception when others then
6112: wf_core.context('PO_ChangeOrderWF_PVT','CARRY_SUP_ACK_TO_NEW_REV',x_progress);
6113: raise;
6114: END CARRY_SUP_ACK_TO_NEW_REV;
6115:
6116: /*

Line 6155: wf_core.context('PO_ChangeOrderWF_PVT','DOES_PO_REQ_SUP_ACK',x_progress);

6151: resultout := 'N';
6152: END if;
6153:
6154: exception when others then
6155: wf_core.context('PO_ChangeOrderWF_PVT','DOES_PO_REQ_SUP_ACK',x_progress);
6156: raise;
6157: END DOES_PO_REQ_SUP_ACK;
6158:
6159: /*

Line 6697: t_varval(1) := 'PLSQL:PO_ChangeOrderWF_PVT.GEN_NTF_FOR_SUP_SUBJECT/'||itemkey;

6693: END IF;
6694: end if;
6695:
6696: t_varname(1) := 'NTF_FOR_SUP_SUBJECT';
6697: t_varval(1) := 'PLSQL:PO_ChangeOrderWF_PVT.GEN_NTF_FOR_SUP_SUBJECT/'||itemkey;
6698: t_varname(2) := 'NTF_FOR_SUP_BUY_RP';
6699: -- RDP set the item Attribute to point to the notifications page
6700: t_varval(2) := 'JSP:/OA_HTML/OA.jsp?page=/oracle/apps/pos/notifications/webui/PosNotificationsRN'||
6701: '&L_CHG_REQ_GRP_ID=-&CHANGE_REQUEST_GROUP_ID-&L_PO_HEADER_ID=-&PO_HEADER_ID-&L_PO_RELEASE_ID=-&PO_RELEASE_ID-'||

Line 6716: wf_core.context('PO_ChangeOrderWF_PVT','is_po_approved_by_hie',x_progress);

6712:
6713: Wf_Engine.SetItemAttrTextArray(itemtype, itemkey,t_varname,t_varval);
6714:
6715: exception when others then
6716: wf_core.context('PO_ChangeOrderWF_PVT','is_po_approved_by_hie',x_progress);
6717: raise;
6718: END is_po_approved_by_hie;
6719:
6720:

Line 6758: wf_core.context('PO_ChangeOrderWF_PVT','set_data_sup_chn_evt',x_progress);

6754: avalue => l_item_key );
6755:
6756:
6757: exception when others then
6758: wf_core.context('PO_ChangeOrderWF_PVT','set_data_sup_chn_evt',x_progress);
6759: raise;
6760: END set_data_sup_chn_evt;
6761:
6762:

Line 6856: wf_core.context('PO_ChangeOrderWF_PVT','ANY_NEW_SUP_CHN',x_progress);

6852: p_note => null,
6853: p_path_id => null);
6854: end if;
6855: exception when others then
6856: wf_core.context('PO_ChangeOrderWF_PVT','ANY_NEW_SUP_CHN',x_progress);
6857: raise;
6858: END ANY_NEW_SUP_CHN;
6859:
6860: procedure any_supplier_change( itemtype in varchar2,

Line 6982: wf_core.context('PO_ChangeOrderWF_PVT','any_supplier_change','010');

6978: resultout := 'N';
6979: end if;
6980:
6981: exception when no_data_found then
6982: wf_core.context('PO_ChangeOrderWF_PVT','any_supplier_change','010');
6983: raise;
6984: when others then
6985: wf_core.context('PO_ChangeOrderWF_PVT','any_supplier_change',x_progress);
6986: raise;

Line 6985: wf_core.context('PO_ChangeOrderWF_PVT','any_supplier_change',x_progress);

6981: exception when no_data_found then
6982: wf_core.context('PO_ChangeOrderWF_PVT','any_supplier_change','010');
6983: raise;
6984: when others then
6985: wf_core.context('PO_ChangeOrderWF_PVT','any_supplier_change',x_progress);
6986: raise;
6987: END any_supplier_change;
6988:
6989:

Line 7166: t_varval(2) := 'PLSQLCLOB:PO_ChangeOrderWF_PVT.GEN_NTF_FOR_SUP_BUY_RP/'|| p_chg_req_grp_id; */

7162:
7163: t_varname(1) := 'SUPPLIER_USERNAME';
7164: t_varval(1) := l_supplier_username;
7165: /* t_varname(2) := 'NTF_FOR_SUP_BUY_RP';
7166: t_varval(2) := 'PLSQLCLOB:PO_ChangeOrderWF_PVT.GEN_NTF_FOR_SUP_BUY_RP/'|| p_chg_req_grp_id; */
7167:
7168: t_varname(2) := 'NTF_FOR_SUP_BUY_RP'; -- RDP changing to point to the notifications Page
7169: t_varval(2) := 'JSP:/OA_HTML/OA.jsp?page=/oracle/apps/pos/notifications/webui/PosNotificationsRN'||
7170: '&L_CHG_REQ_GRP_ID=-&CHANGE_REQUEST_GROUP_ID-&L_PO_HEADER_ID=-&PO_HEADER_ID-&L_PO_RELEASE_ID=-&PO_RELEASE_ID-'||

Line 7173: t_varval(3) := 'PLSQL:PO_ChangeOrderWF_PVT.GEN_NTF_FOR_SUP_SUBJECT/'||l_item_key;

7169: t_varval(2) := 'JSP:/OA_HTML/OA.jsp?page=/oracle/apps/pos/notifications/webui/PosNotificationsRN'||
7170: '&L_CHG_REQ_GRP_ID=-&CHANGE_REQUEST_GROUP_ID-&L_PO_HEADER_ID=-&PO_HEADER_ID-&L_PO_RELEASE_ID=-&PO_RELEASE_ID-'||
7171: '&L_PO_ACC_REQ_FLAG=-&ACKNOWLEDGE_REQ_FLAG-&L_NOTIF_USAGE=-&NOTIF_USAGE-&L_EXPLAIN_FYI=-&EXPLAIN_FYI-&L_STYLE_PARAM=-&PO_STYLE_TYPE-';
7172: t_varname(3) := 'NTF_FOR_SUP_SUBJECT';
7173: t_varval(3) := 'PLSQL:PO_ChangeOrderWF_PVT.GEN_NTF_FOR_SUP_SUBJECT/'||l_item_key;
7174: t_varname(4) := 'FROM_BUYER';
7175: t_varval(4) := l_buyer_username;
7176: t_varname(5) := 'NOTIF_USAGE';
7177: t_varval(5) := 'BUYER_RESP';

Line 7700: wf_core.context('PO_ChangeOrderWF_PVT','NOTIFY_REQ_PLAN',l_progress);

7696: end loop;
7697: close l_planners_csr;
7698:
7699: exception when others then
7700: wf_core.context('PO_ChangeOrderWF_PVT','NOTIFY_REQ_PLAN',l_progress);
7701: raise;
7702: END NOTIFY_REQ_PLAN ;
7703:
7704: procedure PROCESS_RESPONSE ( itemtype in varchar2,

Line 7740: wf_core.context('PO_ChangeOrderWF_PVT','PROCESS_RESPONSE',x_progress);

7736: l_revision_num, l_chg_req_grp_id, fnd_global.user_id, l_err_msg,
7737: l_return_code,l_doc_check_rec_type, 'Y', 'Y');
7738:
7739: exception when others then
7740: wf_core.context('PO_ChangeOrderWF_PVT','PROCESS_RESPONSE',x_progress);
7741: raise;
7742: END PROCESS_RESPONSE;
7743:
7744: procedure BUYER_ACCEPT_CHANGE ( itemtype in varchar2,

Line 7779: wf_core.context('PO_ChangeOrderWF_PVT','BUYER_ACCEPT_CHANGE','000');

7775: where change_request_group_id = l_chg_req_grp_id
7776: and request_status in ('PENDING','REQ_APP'); -- RDP ( Update records lying in REQ_APP status too)
7777:
7778: exception when others then
7779: wf_core.context('PO_ChangeOrderWF_PVT','BUYER_ACCEPT_CHANGE','000');
7780: raise;
7781: end BUYER_ACCEPT_CHANGE;
7782:
7783: procedure BUYER_REJECT_CHANGE ( itemtype in varchar2,

Line 7849: wf_core.context('PO_ChangeOrderWF_PVT','BUYER_REJECT_CHANGE','000');

7845: response_date = sysdate
7846: where change_request_group_id = l_chg_req_grp_id
7847: and request_status in ('PENDING','REQ_APP'); -- RDP ( Update records lying in REQ_APP status too)
7848: exception when others then
7849: wf_core.context('PO_ChangeOrderWF_PVT','BUYER_REJECT_CHANGE','000');
7850: raise;
7851: end BUYER_REJECT_CHANGE;
7852:
7853: /*

Line 8003: t_varval(1) := 'PLSQL:PO_ChangeOrderWF_PVT.GEN_NTF_FOR_BUYER_SUBJECT/'||l_item_key;

7999: n_varname(4) := 'CHANGE_REQUEST_GROUP_ID';
8000: n_varval(4) := p_chg_req_grp_id;
8001:
8002: t_varname(1) := 'NTF_FOR_BUYER_SUBJECT';
8003: t_varval(1) := 'PLSQL:PO_ChangeOrderWF_PVT.GEN_NTF_FOR_BUYER_SUBJECT/'||l_item_key;
8004: t_varname(2) := 'NOTIF_FOR_BUYER_SUP_CHG'; -- RDP set the item Attibute value to the Notifications Page
8005: t_varval(2) := 'JSP:/OA_HTML/OA.jsp?page=/oracle/apps/pos/notifications/webui/PosNotificationsRN'||
8006: '&L_CHG_REQ_GRP_ID=-&CHANGE_REQUEST_GROUP_ID-&L_PO_HEADER_ID=-&PO_HEADER_ID-&L_PO_RELEASE_ID=-&PO_RELEASE_ID-'||
8007: '&L_PO_ACC_REQ_FLAG=-&ACKNOWLEDGE_REQ_FLAG-&L_NOTIF_USAGE=-&NOTIF_USAGE-&L_EXPLAIN_FYI=-&EXPLAIN_FYI-&L_STYLE_PARAM=-&PO_STYLE_TYPE-';

Line 8721: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 01.';

8717: l_preserved_ctx VARCHAR2(5);
8718:
8719: BEGIN
8720:
8721: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 01.';
8722: IF (g_fnd_debug = 'Y') THEN
8723: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_api_name, 'Enter in post_approval_notif ' || l_progress);
8724: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_api_name, 'p_itemtype ' || p_itemtype);
8725: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_api_name, 'p_itemkey ' || p_itemkey);

Line 8741: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 02.';

8737: end if;
8738:
8739:
8740: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_NEW_ROLE, l_origsys, l_new_recipient_id);
8741: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 02.';
8742:
8743: if (p_funcmode = 'RESPOND') then
8744: l_notification_id := WF_ENGINE.context_nid;
8745: IF (g_fnd_debug = 'Y') THEN

Line 8773: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 03.' ;

8769: else
8770: l_preserved_ctx := 'FALSE';
8771: end if;
8772:
8773: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 03.' ;
8774:
8775: --
8776: IF (g_fnd_debug = 'Y') THEN
8777: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_api_name,'l_progress ' ||l_progress);

Line 8790: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 04.' ;

8786: wf_notifications wfn
8787: WHERE wfn.notification_id = l_notification_id
8788: AND wfn.original_recipient = fu.user_name;
8789:
8790: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 04.' ;
8791:
8792: --
8793: IF (g_fnd_debug = 'Y') THEN
8794: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_api_name,'l_progress ' ||l_progress);

Line 8835: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 05.' ;

8831: l_preparer_appl_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
8832: itemkey => p_itemkey,
8833: aname => 'APPLICATION_ID');
8834:
8835: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 05.' ;
8836:
8837: --
8838: IF (g_fnd_debug = 'Y') THEN
8839: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_api_name,'l_progress ' ||l_progress);

Line 8851: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 06.' ;

8847: 1. when the response is made from email using guest user feature
8848: 2. When the response is made from sysadmin login
8849: */
8850:
8851: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 06.' ;
8852:
8853: --
8854: IF (g_fnd_debug = 'Y') THEN
8855: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_api_name,'l_progress ' ||l_progress || 'When the response is made from email using guest user feature');

Line 8872: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 07.' ;

8868: itemkey => p_itemkey,
8869: aname => 'RESPONDER_APPL_ID',
8870: avalue => l_preparer_appl_id);
8871: ELSE
8872: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 07.' ;
8873:
8874: --
8875: IF (g_fnd_debug = 'Y') THEN
8876: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_api_name,'l_progress ' ||l_progress || 'When the response is made from sysadmin login');

Line 8882: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 07.' ;

8878: --
8879:
8880: if (l_session_resp_id is null) THEN
8881: /* possible when the response is made from the default worklist without choosing a valid responsibility */
8882: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 07.' ;
8883: --
8884: IF (g_fnd_debug = 'Y') THEN
8885: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_api_name,'l_progress '||l_progress || 'When the response is made from the default worklist');
8886: END IF;

Line 8910: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 09.' ;

8906: picks the wf up. This may happen due to the fact that the
8907: mailer / background process carries the context set by
8908: the notification /wf it processed last */
8909:
8910: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 09.' ;
8911:
8912: --
8913: IF (g_fnd_debug = 'Y') THEN
8914: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_api_name,'l_progress ' ||l_progress || 'When the response is made after choosing a correct responsibility');

Line 9033: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','Inside PO_SUPCHG_SELECTOR procedure');

9029:
9030: BEGIN
9031: --
9032: IF (g_fnd_debug = 'Y') THEN
9033: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','Inside PO_SUPCHG_SELECTOR procedure');
9034: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_itemtype : '||p_itemtype);
9035: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_itemkey : '||p_itemkey);
9036: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_actid : '||p_actid);
9037: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_funcmode : '||p_funcmode);

Line 9034: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_itemtype : '||p_itemtype);

9030: BEGIN
9031: --
9032: IF (g_fnd_debug = 'Y') THEN
9033: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','Inside PO_SUPCHG_SELECTOR procedure');
9034: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_itemtype : '||p_itemtype);
9035: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_itemkey : '||p_itemkey);
9036: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_actid : '||p_actid);
9037: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_funcmode : '||p_funcmode);
9038: END IF;

Line 9035: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_itemkey : '||p_itemkey);

9031: --
9032: IF (g_fnd_debug = 'Y') THEN
9033: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','Inside PO_SUPCHG_SELECTOR procedure');
9034: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_itemtype : '||p_itemtype);
9035: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_itemkey : '||p_itemkey);
9036: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_actid : '||p_actid);
9037: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_funcmode : '||p_funcmode);
9038: END IF;
9039: --

Line 9036: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_actid : '||p_actid);

9032: IF (g_fnd_debug = 'Y') THEN
9033: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','Inside PO_SUPCHG_SELECTOR procedure');
9034: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_itemtype : '||p_itemtype);
9035: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_itemkey : '||p_itemkey);
9036: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_actid : '||p_actid);
9037: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_funcmode : '||p_funcmode);
9038: END IF;
9039: --
9040:

Line 9037: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_funcmode : '||p_funcmode);

9033: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','Inside PO_SUPCHG_SELECTOR procedure');
9034: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_itemtype : '||p_itemtype);
9035: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_itemkey : '||p_itemkey);
9036: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_actid : '||p_actid);
9037: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','p_funcmode : '||p_funcmode);
9038: END IF;
9039: --
9040:
9041:

Line 9064: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','l_progress1 : '||l_progress);

9060: --
9061: 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;
9062:
9063: IF (g_fnd_debug = 'Y') THEN
9064: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','l_progress1 : '||l_progress);
9065: END IF;
9066: --
9067:
9068: IF (p_funcmode = 'TEST_CTX') THEN

Line 9125: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','l_progress2 : '||l_progress);

9121: --
9122: l_progress := '020 selection fn responder id not null';
9123:
9124: IF (g_fnd_debug = 'Y') THEN
9125: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','l_progress2 : '||l_progress);
9126: END IF;
9127: --
9128:
9129: --

Line 9133: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','l_progress3 : '||l_progress);

9129: --
9130: 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;
9131:
9132: IF (g_fnd_debug = 'Y') THEN
9133: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','l_progress3 : '||l_progress);
9134: END IF;
9135: --
9136: else
9137: l_user_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

Line 9149: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','l_progress4 : '||l_progress);

9145: aname => 'APPLICATION_ID');
9146: --
9147: l_progress := '040 selector fn responder id null';
9148: IF (g_fnd_debug = 'Y') THEN
9149: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','l_progress4 : '||l_progress);
9150: END IF;
9151: --
9152:
9153: --

Line 9157: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','l_progress4 : '||l_progress);

9153: --
9154: 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;
9155:
9156: IF (g_fnd_debug = 'Y') THEN
9157: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','l_progress4 : '||l_progress);
9158: END IF;
9159: --
9160: end if;
9161:

Line 9175: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','Exception in Selector Procedure');

9171: END IF;
9172: EXCEPTION WHEN OTHERS THEN
9173:
9174: IF (g_fnd_debug = 'Y') THEN
9175: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','Exception in Selector Procedure');
9176: END IF;
9177:
9178: WF_CORE.context('PO_ChangeOrderWF_PVT', 'PO_SUPCHG_SELECTOR', p_itemtype, p_itemkey, p_actid, p_funcmode);
9179: RAISE;

Line 9178: WF_CORE.context('PO_ChangeOrderWF_PVT', 'PO_SUPCHG_SELECTOR', p_itemtype, p_itemkey, p_actid, p_funcmode);

9174: IF (g_fnd_debug = 'Y') THEN
9175: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','Exception in Selector Procedure');
9176: END IF;
9177:
9178: WF_CORE.context('PO_ChangeOrderWF_PVT', 'PO_SUPCHG_SELECTOR', p_itemtype, p_itemkey, p_actid, p_funcmode);
9179: RAISE;
9180:
9181: END PO_SUPCHG_SELECTOR;
9182:

Line 9183: END PO_ChangeOrderWF_PVT;

9179: RAISE;
9180:
9181: END PO_SUPCHG_SELECTOR;
9182:
9183: END PO_ChangeOrderWF_PVT;