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_MOD_CONTROL_PVT dependencies on PO_LOG

Line 4: d_pkg_name CONSTANT varchar2(50) :=PO_LOG.get_package_base('po_mod_control_pvt');

1: PACKAGE BODY PO_MOD_CONTROL_PVT AS
2: /* $Header: PO_MOD_CONTROL_PVT.plb 120.11.12020000.6 2013/04/12 22:21:48 rarajar ship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=PO_LOG.get_package_base('po_mod_control_pvt');
5:
6: procedure process_mod_control_action(p_draft_id in number,
7: p_action in varchar2,
8: p_po_header_id in number,

Line 22: IF (PO_LOG.d_proc) THEN

18: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
19:
20: begin
21: d_position := 0;
22: IF (PO_LOG.d_proc) THEN
23: PO_LOG.proc_begin(d_module);
24: END IF;
25: resultout := FND_API.G_RET_STS_SUCCESS;
26:

Line 23: PO_LOG.proc_begin(d_module);

19:
20: begin
21: d_position := 0;
22: IF (PO_LOG.d_proc) THEN
23: PO_LOG.proc_begin(d_module);
24: END IF;
25: resultout := FND_API.G_RET_STS_SUCCESS;
26:
27: d_position := 10;

Line 61: IF (PO_LOG.d_proc) THEN

57:
58: d_position := 60;
59: resultout := FND_API.G_RET_STS_SUCCESS;
60:
61: IF (PO_LOG.d_proc) THEN
62: PO_LOG.proc_end(d_module);
63: END IF;
64:
65: EXCEPTION

Line 62: PO_LOG.proc_end(d_module);

58: d_position := 60;
59: resultout := FND_API.G_RET_STS_SUCCESS;
60:
61: IF (PO_LOG.d_proc) THEN
62: PO_LOG.proc_end(d_module);
63: END IF;
64:
65: EXCEPTION
66: WHEN OTHERS THEN

Line 107: IF (PO_LOG.d_proc) THEN

103:
104: BEGIN
105:
106: d_position := 0;
107: IF (PO_LOG.d_proc) THEN
108: PO_LOG.proc_begin(d_module);
109: END IF;
110: result := FND_API.G_RET_STS_SUCCESS;
111:

Line 108: PO_LOG.proc_begin(d_module);

104: BEGIN
105:
106: d_position := 0;
107: IF (PO_LOG.d_proc) THEN
108: PO_LOG.proc_begin(d_module);
109: END IF;
110: result := FND_API.G_RET_STS_SUCCESS;
111:
112: d_position := 10;

Line 189: IF (PO_LOG.d_stmt) THEN

185: BULK COLLECT INTO l_withdrawn_dist_list
186: FROM po_distributions_draft_all
187: WHERE draft_id = p_draft_id;
188:
189: IF (PO_LOG.d_stmt) THEN
190: PO_LOG.stmt(d_module,d_position,'l_withdrawn_line_list',l_withdrawn_line_list);
191: PO_LOG.stmt(d_module,d_position,'l_withdrawn_dist_list',l_withdrawn_dist_list);
192: END IF;
193:

Line 190: PO_LOG.stmt(d_module,d_position,'l_withdrawn_line_list',l_withdrawn_line_list);

186: FROM po_distributions_draft_all
187: WHERE draft_id = p_draft_id;
188:
189: IF (PO_LOG.d_stmt) THEN
190: PO_LOG.stmt(d_module,d_position,'l_withdrawn_line_list',l_withdrawn_line_list);
191: PO_LOG.stmt(d_module,d_position,'l_withdrawn_dist_list',l_withdrawn_dist_list);
192: END IF;
193:
194: update_header_dummy_req(p_draft_id => p_draft_id);

Line 191: PO_LOG.stmt(d_module,d_position,'l_withdrawn_dist_list',l_withdrawn_dist_list);

187: WHERE draft_id = p_draft_id;
188:
189: IF (PO_LOG.d_stmt) THEN
190: PO_LOG.stmt(d_module,d_position,'l_withdrawn_line_list',l_withdrawn_line_list);
191: PO_LOG.stmt(d_module,d_position,'l_withdrawn_dist_list',l_withdrawn_dist_list);
192: END IF;
193:
194: update_header_dummy_req(p_draft_id => p_draft_id);
195:

Line 227: IF (PO_LOG.d_stmt) THEN

223: FROM po_distributions_draft_all
224: WHERE draft_id = p_draft_id
225: AND par_distribution_id IS NOT NULL;
226:
227: IF (PO_LOG.d_stmt) THEN
228: PO_LOG.stmt(d_module,d_position,'l_withdrawn_par_line_list',l_withdrawn_par_line_list);
229: PO_LOG.stmt(d_module,d_position,'l_withdrawn_par_dist_list',l_withdrawn_par_dist_list);
230: END IF;
231:

Line 228: PO_LOG.stmt(d_module,d_position,'l_withdrawn_par_line_list',l_withdrawn_par_line_list);

224: WHERE draft_id = p_draft_id
225: AND par_distribution_id IS NOT NULL;
226:
227: IF (PO_LOG.d_stmt) THEN
228: PO_LOG.stmt(d_module,d_position,'l_withdrawn_par_line_list',l_withdrawn_par_line_list);
229: PO_LOG.stmt(d_module,d_position,'l_withdrawn_par_dist_list',l_withdrawn_par_dist_list);
230: END IF;
231:
232: update_header_dummy_req(p_draft_id => p_draft_id);

Line 229: PO_LOG.stmt(d_module,d_position,'l_withdrawn_par_dist_list',l_withdrawn_par_dist_list);

225: AND par_distribution_id IS NOT NULL;
226:
227: IF (PO_LOG.d_stmt) THEN
228: PO_LOG.stmt(d_module,d_position,'l_withdrawn_par_line_list',l_withdrawn_par_line_list);
229: PO_LOG.stmt(d_module,d_position,'l_withdrawn_par_dist_list',l_withdrawn_par_dist_list);
230: END IF;
231:
232: update_header_dummy_req(p_draft_id => p_draft_id);
233:

Line 252: IF (PO_LOG.d_proc) THEN

248: END IF;
249: --*/
250: -- Bug: 15905347 - End
251:
252: IF (PO_LOG.d_proc) THEN
253: PO_LOG.proc_end(d_module);
254: END IF;
255:
256: EXCEPTION

Line 253: PO_LOG.proc_end(d_module);

249: --*/
250: -- Bug: 15905347 - End
251:
252: IF (PO_LOG.d_proc) THEN
253: PO_LOG.proc_end(d_module);
254: END IF;
255:
256: EXCEPTION
257: WHEN OTHERS THEN

Line 278: IF ( po_log.d_proc ) THEN

274: BEGIN
275:
276: d_position := 0;
277:
278: IF ( po_log.d_proc ) THEN
279: po_log.Proc_begin(d_module);
280: END IF;
281:
282: d_position := 10;

Line 279: po_log.Proc_begin(d_module);

275:
276: d_position := 0;
277:
278: IF ( po_log.d_proc ) THEN
279: po_log.Proc_begin(d_module);
280: END IF;
281:
282: d_position := 10;
283:

Line 299: IF (PO_LOG.d_stmt) THEN

295: AND prh.requisition_header_id = prl.requisition_header_id
296: AND Nvl(prh.par_flag, 'N') = 'Y'
297: );
298:
299: IF (PO_LOG.d_stmt) THEN
300: PO_LOG.stmt(d_module, d_position, 'Dummy Header Req Updated Count ', SQL%ROWCOUNT);
301: END IF;
302:
303: IF ( po_log.d_proc ) THEN

Line 300: PO_LOG.stmt(d_module, d_position, 'Dummy Header Req Updated Count ', SQL%ROWCOUNT);

296: AND Nvl(prh.par_flag, 'N') = 'Y'
297: );
298:
299: IF (PO_LOG.d_stmt) THEN
300: PO_LOG.stmt(d_module, d_position, 'Dummy Header Req Updated Count ', SQL%ROWCOUNT);
301: END IF;
302:
303: IF ( po_log.d_proc ) THEN
304: po_log.Proc_end(d_module);

Line 303: IF ( po_log.d_proc ) THEN

299: IF (PO_LOG.d_stmt) THEN
300: PO_LOG.stmt(d_module, d_position, 'Dummy Header Req Updated Count ', SQL%ROWCOUNT);
301: END IF;
302:
303: IF ( po_log.d_proc ) THEN
304: po_log.Proc_end(d_module);
305: END IF;
306:
307: END update_header_dummy_req;

Line 304: po_log.Proc_end(d_module);

300: PO_LOG.stmt(d_module, d_position, 'Dummy Header Req Updated Count ', SQL%ROWCOUNT);
301: END IF;
302:
303: IF ( po_log.d_proc ) THEN
304: po_log.Proc_end(d_module);
305: END IF;
306:
307: END update_header_dummy_req;
308:

Line 346: IF (PO_LOG.d_proc) THEN

342:
343: BEGIN
344:
345: d_position := 0;
346: IF (PO_LOG.d_proc) THEN
347: PO_LOG.proc_begin(d_module);
348: END IF;
349:
350: result := FND_API.G_RET_STS_SUCCESS;

Line 347: PO_LOG.proc_begin(d_module);

343: BEGIN
344:
345: d_position := 0;
346: IF (PO_LOG.d_proc) THEN
347: PO_LOG.proc_begin(d_module);
348: END IF;
349:
350: result := FND_API.G_RET_STS_SUCCESS;
351:

Line 460: IF (PO_LOG.d_stmt) THEN

456: BULK COLLECT INTO l_deleted_dist_list
457: FROM po_distributions_draft_all
458: WHERE draft_id = p_draft_id;
459:
460: IF (PO_LOG.d_stmt) THEN
461: PO_LOG.stmt(d_module,d_position,'l_deleted_line_list',l_deleted_line_list);
462: PO_LOG.stmt(d_module,d_position,'l_deleted_dist_list',l_deleted_dist_list);
463: END IF;
464:

Line 461: PO_LOG.stmt(d_module,d_position,'l_deleted_line_list',l_deleted_line_list);

457: FROM po_distributions_draft_all
458: WHERE draft_id = p_draft_id;
459:
460: IF (PO_LOG.d_stmt) THEN
461: PO_LOG.stmt(d_module,d_position,'l_deleted_line_list',l_deleted_line_list);
462: PO_LOG.stmt(d_module,d_position,'l_deleted_dist_list',l_deleted_dist_list);
463: END IF;
464:
465:

Line 462: PO_LOG.stmt(d_module,d_position,'l_deleted_dist_list',l_deleted_dist_list);

458: WHERE draft_id = p_draft_id;
459:
460: IF (PO_LOG.d_stmt) THEN
461: PO_LOG.stmt(d_module,d_position,'l_deleted_line_list',l_deleted_line_list);
462: PO_LOG.stmt(d_module,d_position,'l_deleted_dist_list',l_deleted_dist_list);
463: END IF;
464:
465:
466: -- Bug: 13948625 - Start

Line 520: IF (PO_LOG.d_proc) THEN

516: -- SBCR Integration Code to Delete associated SBCR Records END.
517:
518: PO_DRAFTS_PVT.remove_draft_changes(p_draft_id,FND_API.G_FALSE,result);
519:
520: IF (PO_LOG.d_proc) THEN
521: PO_LOG.proc_end(d_module);
522: END IF;
523:
524: EXCEPTION

Line 521: PO_LOG.proc_end(d_module);

517:
518: PO_DRAFTS_PVT.remove_draft_changes(p_draft_id,FND_API.G_FALSE,result);
519:
520: IF (PO_LOG.d_proc) THEN
521: PO_LOG.proc_end(d_module);
522: END IF;
523:
524: EXCEPTION
525: WHEN OTHERS THEN

Line 546: IF (PO_LOG.d_proc) THEN

542:
543: BEGIN
544:
545: d_position := 0;
546: IF (PO_LOG.d_proc) THEN
547: PO_LOG.proc_begin(d_module);
548: END IF;
549:
550: IF p_entity_level = 'PO_HEADER' THEN

Line 547: PO_LOG.proc_begin(d_module);

543: BEGIN
544:
545: d_position := 0;
546: IF (PO_LOG.d_proc) THEN
547: PO_LOG.proc_begin(d_module);
548: END IF;
549:
550: IF p_entity_level = 'PO_HEADER' THEN
551: DELETE FROM po_headers_all_ext_b

Line 688: IF (PO_LOG.d_proc) THEN

684: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
685:
686: begin
687: d_position := 0;
688: IF (PO_LOG.d_proc) THEN
689: PO_LOG.proc_begin(d_module);
690: END IF;
691: resultout := FND_API.G_RET_STS_SUCCESS;
692:

Line 689: PO_LOG.proc_begin(d_module);

685:
686: begin
687: d_position := 0;
688: IF (PO_LOG.d_proc) THEN
689: PO_LOG.proc_begin(d_module);
690: END IF;
691: resultout := FND_API.G_RET_STS_SUCCESS;
692:
693: d_position := 10;

Line 766: IF (PO_LOG.d_proc) THEN

762:
763: d_position := 60;
764: resultout := FND_API.G_RET_STS_SUCCESS;
765:
766: IF (PO_LOG.d_proc) THEN
767: PO_LOG.proc_end(d_module);
768: END IF;
769:
770: EXCEPTION

Line 767: PO_LOG.proc_end(d_module);

763: d_position := 60;
764: resultout := FND_API.G_RET_STS_SUCCESS;
765:
766: IF (PO_LOG.d_proc) THEN
767: PO_LOG.proc_end(d_module);
768: END IF;
769:
770: EXCEPTION
771: WHEN OTHERS THEN

Line 801: IF (PO_LOG.d_proc) THEN

797: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
798:
799: begin
800: d_position := 0;
801: IF (PO_LOG.d_proc) THEN
802: PO_LOG.proc_begin(d_module);
803: END IF;
804: resultout := FND_API.G_RET_STS_SUCCESS;
805:

Line 802: PO_LOG.proc_begin(d_module);

798:
799: begin
800: d_position := 0;
801: IF (PO_LOG.d_proc) THEN
802: PO_LOG.proc_begin(d_module);
803: END IF;
804: resultout := FND_API.G_RET_STS_SUCCESS;
805:
806: d_position := 10;

Line 840: IF (PO_LOG.d_proc) THEN

836:
837: d_position := 60;
838: resultout := FND_API.G_RET_STS_SUCCESS;
839:
840: IF (PO_LOG.d_proc) THEN
841: PO_LOG.proc_end(d_module);
842: END IF;
843:
844: EXCEPTION

Line 841: PO_LOG.proc_end(d_module);

837: d_position := 60;
838: resultout := FND_API.G_RET_STS_SUCCESS;
839:
840: IF (PO_LOG.d_proc) THEN
841: PO_LOG.proc_end(d_module);
842: END IF;
843:
844: EXCEPTION
845: WHEN OTHERS THEN

Line 886: IF (PO_LOG.d_proc) THEN

882: d_pos NUMBER;
883: l_api_name CONSTANT VARCHAR2(30) := 'get_mod_valid_control_actions';
884: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.get_mod_valid_control_actions';
885: BEGIN
886: IF (PO_LOG.d_proc) THEN
887: PO_LOG.proc_begin(d_module);
888: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
889: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
890: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);

Line 887: PO_LOG.proc_begin(d_module);

883: l_api_name CONSTANT VARCHAR2(30) := 'get_mod_valid_control_actions';
884: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.get_mod_valid_control_actions';
885: BEGIN
886: IF (PO_LOG.d_proc) THEN
887: PO_LOG.proc_begin(d_module);
888: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
889: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
890: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
891: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);

Line 888: PO_LOG.proc_begin(d_module,'p_mode',p_mode);

884: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.get_mod_valid_control_actions';
885: BEGIN
886: IF (PO_LOG.d_proc) THEN
887: PO_LOG.proc_begin(d_module);
888: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
889: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
890: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
891: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
892: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);

Line 889: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);

885: BEGIN
886: IF (PO_LOG.d_proc) THEN
887: PO_LOG.proc_begin(d_module);
888: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
889: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
890: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
891: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
892: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);
893: END IF;

Line 890: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);

886: IF (PO_LOG.d_proc) THEN
887: PO_LOG.proc_begin(d_module);
888: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
889: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
890: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
891: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
892: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);
893: END IF;
894:

Line 891: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);

887: PO_LOG.proc_begin(d_module);
888: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
889: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
890: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
891: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
892: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);
893: END IF;
894:
895: --Initialisation of local variables

Line 892: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);

888: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
889: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
890: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
891: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
892: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);
893: END IF;
894:
895: --Initialisation of local variables
896: x_return_status := FND_API.g_ret_sts_success;

Line 912: IF (PO_LOG.d_stmt) THEN

908: FROM po_headers_all
909: WHERE po_header_id = p_doc_header_id;
910: END IF;
911: d_pos := 20;
912: IF (PO_LOG.d_stmt) THEN
913: PO_LOG.stmt(d_module,d_pos,'l_agent_id',l_agent_id);
914: PO_LOG.stmt(d_module,d_pos,'l_doc_subtype',l_doc_subtype);
915: END IF;
916: IF (p_doc_level = PO_CORE_S.g_doc_level_HEADER) THEN --header level

Line 913: PO_LOG.stmt(d_module,d_pos,'l_agent_id',l_agent_id);

909: WHERE po_header_id = p_doc_header_id;
910: END IF;
911: d_pos := 20;
912: IF (PO_LOG.d_stmt) THEN
913: PO_LOG.stmt(d_module,d_pos,'l_agent_id',l_agent_id);
914: PO_LOG.stmt(d_module,d_pos,'l_doc_subtype',l_doc_subtype);
915: END IF;
916: IF (p_doc_level = PO_CORE_S.g_doc_level_HEADER) THEN --header level
917: d_pos := 30;

Line 914: PO_LOG.stmt(d_module,d_pos,'l_doc_subtype',l_doc_subtype);

910: END IF;
911: d_pos := 20;
912: IF (PO_LOG.d_stmt) THEN
913: PO_LOG.stmt(d_module,d_pos,'l_agent_id',l_agent_id);
914: PO_LOG.stmt(d_module,d_pos,'l_doc_subtype',l_doc_subtype);
915: END IF;
916: IF (p_doc_level = PO_CORE_S.g_doc_level_HEADER) THEN --header level
917: d_pos := 30;
918: PO_DOCUMENT_CONTROL_PVT.get_header_actions

Line 936: IF (PO_LOG.d_stmt) THEN

932: FROM po_lines_merge_v -- Replaced po_lines_all
933: WHERE po_line_id = p_doc_level_id
934: AND draft_id = p_draft_id;
935:
936: IF (PO_LOG.d_stmt) THEN
937: PO_LOG.stmt(d_module,d_pos,'l_item_id',l_agent_id);
938: END IF;
939:
940: PO_DOCUMENT_CONTROL_PVT.get_line_actions

Line 937: PO_LOG.stmt(d_module,d_pos,'l_item_id',l_agent_id);

933: WHERE po_line_id = p_doc_level_id
934: AND draft_id = p_draft_id;
935:
936: IF (PO_LOG.d_stmt) THEN
937: PO_LOG.stmt(d_module,d_pos,'l_item_id',l_agent_id);
938: END IF;
939:
940: PO_DOCUMENT_CONTROL_PVT.get_line_actions
941: ( p_doc_subtype => l_doc_subtype

Line 963: IF (PO_LOG.d_stmt) THEN

959: , x_return_status => x_return_status
960: , p_mode => l_mode);
961:
962: END IF;
963: IF (PO_LOG.d_stmt) THEN
964: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
965: END IF;
966: d_pos := 60;
967:

Line 964: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);

960: , p_mode => l_mode);
961:
962: END IF;
963: IF (PO_LOG.d_stmt) THEN
964: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
965: END IF;
966: d_pos := 60;
967:
968: IF (x_return_status = FND_API.g_ret_sts_success)then

Line 978: IF (PO_LOG.d_stmt) THEN

974: p_doc_header_id,
975: l_item_id);
976: END IF;
977: d_pos := 70;
978: IF (PO_LOG.d_stmt) THEN
979: PO_LOG.stmt(d_module,d_pos,'l_cons_trans_exist',l_cons_trans_exist);
980: END IF;
981: --
982: --Prevent cancel option for shipment if it is the only shipment on the

Line 979: PO_LOG.stmt(d_module,d_pos,'l_cons_trans_exist',l_cons_trans_exist);

975: l_item_id);
976: END IF;
977: d_pos := 70;
978: IF (PO_LOG.d_stmt) THEN
979: PO_LOG.stmt(d_module,d_pos,'l_cons_trans_exist',l_cons_trans_exist);
980: END IF;
981: --
982: --Prevent cancel option for shipment if it is the only shipment on the
983: --line that is not cancelled or finally closed.

Line 1006: IF PO_LOG.d_stmt THEN

1002: EXCEPTION
1003: WHEN NO_DATA_FOUND THEN
1004: --Current shipment is the only shipment on the line that is not cancelled or finally closed
1005: --OR there are no open, uncancelled shipments.
1006: IF PO_LOG.d_stmt THEN
1007: PO_LOG.stmt(d_module,d_pos,'Control Action cannot be performed on the shipment');
1008: END IF;
1009: l_ship_invalid_for_ctrl_actn := 'Y';
1010: END;

Line 1007: PO_LOG.stmt(d_module,d_pos,'Control Action cannot be performed on the shipment');

1003: WHEN NO_DATA_FOUND THEN
1004: --Current shipment is the only shipment on the line that is not cancelled or finally closed
1005: --OR there are no open, uncancelled shipments.
1006: IF PO_LOG.d_stmt THEN
1007: PO_LOG.stmt(d_module,d_pos,'Control Action cannot be performed on the shipment');
1008: END IF;
1009: l_ship_invalid_for_ctrl_actn := 'Y';
1010: END;
1011:

Line 1020: IF (PO_LOG.d_stmt) THEN

1016: LOOP
1017: d_pos := 80;
1018: l_current_action := l_valid_actions_tbl(i);
1019:
1020: IF (PO_LOG.d_stmt) THEN
1021: PO_LOG.stmt(d_module,d_pos,'l_current_action',l_current_action);
1022: END IF;
1023: -- If consumption transaction exist we don't allow Cancel and Finally
1024: -- Close actions

Line 1021: PO_LOG.stmt(d_module,d_pos,'l_current_action',l_current_action);

1017: d_pos := 80;
1018: l_current_action := l_valid_actions_tbl(i);
1019:
1020: IF (PO_LOG.d_stmt) THEN
1021: PO_LOG.stmt(d_module,d_pos,'l_current_action',l_current_action);
1022: END IF;
1023: -- If consumption transaction exist we don't allow Cancel and Finally
1024: -- Close actions
1025: IF (l_cons_trans_exist = 'Y'

Line 1045: IF (PO_LOG.d_stmt) THEN

1041: IF(l_mode = 'MODSUMMARY' AND l_current_action LIKE 'CANCEL%' ) THEN
1042: -- For Summary we Show Cancel Action as Cancel at all the Levels
1043:
1044: d_pos := 90;
1045: IF (PO_LOG.d_stmt) THEN
1046: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is replaced by CANCEL for summary mode');
1047: END IF;
1048: x_valid_ctrl_ctn_tbl(l_index) := 'CANCEL';
1049: ELSIF(l_mode = 'UPDATE' AND l_current_action = 'CANCEL PO') THEN

Line 1046: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is replaced by CANCEL for summary mode');

1042: -- For Summary we Show Cancel Action as Cancel at all the Levels
1043:
1044: d_pos := 90;
1045: IF (PO_LOG.d_stmt) THEN
1046: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is replaced by CANCEL for summary mode');
1047: END IF;
1048: x_valid_ctrl_ctn_tbl(l_index) := 'CANCEL';
1049: ELSIF(l_mode = 'UPDATE' AND l_current_action = 'CANCEL PO') THEN
1050:

Line 1052: IF (PO_LOG.d_stmt) THEN

1048: x_valid_ctrl_ctn_tbl(l_index) := 'CANCEL';
1049: ELSIF(l_mode = 'UPDATE' AND l_current_action = 'CANCEL PO') THEN
1050:
1051: d_pos := 100;
1052: IF (PO_LOG.d_stmt) THEN
1053: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is replaced by CANCEL for update mode');
1054: END IF;
1055: x_valid_ctrl_ctn_tbl(l_index) := 'CANCEL';
1056:

Line 1053: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is replaced by CANCEL for update mode');

1049: ELSIF(l_mode = 'UPDATE' AND l_current_action = 'CANCEL PO') THEN
1050:
1051: d_pos := 100;
1052: IF (PO_LOG.d_stmt) THEN
1053: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is replaced by CANCEL for update mode');
1054: END IF;
1055: x_valid_ctrl_ctn_tbl(l_index) := 'CANCEL';
1056:
1057: ELSE

Line 1059: IF (PO_LOG.d_stmt) THEN

1055: x_valid_ctrl_ctn_tbl(l_index) := 'CANCEL';
1056:
1057: ELSE
1058: d_pos := 110;
1059: IF (PO_LOG.d_stmt) THEN
1060: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is directly placed');
1061: END IF;
1062:
1063: x_valid_ctrl_ctn_tbl(l_index) := l_valid_actions_tbl(i);

Line 1060: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is directly placed');

1056:
1057: ELSE
1058: d_pos := 110;
1059: IF (PO_LOG.d_stmt) THEN
1060: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is directly placed');
1061: END IF;
1062:
1063: x_valid_ctrl_ctn_tbl(l_index) := l_valid_actions_tbl(i);
1064: END IF; --mode = 'SUMMARY' AND l_current_action LIKE 'CANCEL%'

Line 1072: IF (PO_LOG.d_stmt) THEN

1068: END LOOP;
1069:
1070: ELSIF (x_return_status = FND_API.g_ret_sts_error)then
1071: d_pos := 120;
1072: IF (PO_LOG.d_stmt) THEN
1073: PO_LOG.stmt(d_module,d_pos,'No Valid Control Action Found');
1074: END IF;
1075: ELSE
1076: d_pos := 130;

Line 1073: PO_LOG.stmt(d_module,d_pos,'No Valid Control Action Found');

1069:
1070: ELSIF (x_return_status = FND_API.g_ret_sts_error)then
1071: d_pos := 120;
1072: IF (PO_LOG.d_stmt) THEN
1073: PO_LOG.stmt(d_module,d_pos,'No Valid Control Action Found');
1074: END IF;
1075: ELSE
1076: d_pos := 130;
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1079: IF (PO_LOG.d_proc) THEN

1075: ELSE
1076: d_pos := 130;
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: END IF; --x_return_status = FND_API.g_ret_sts_success
1079: IF (PO_LOG.d_proc) THEN
1080: PO_LOG.proc_end(d_module);
1081: END IF;
1082: EXCEPTION
1083: WHEN OTHERS THEN

Line 1080: PO_LOG.proc_end(d_module);

1076: d_pos := 130;
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: END IF; --x_return_status = FND_API.g_ret_sts_success
1079: IF (PO_LOG.d_proc) THEN
1080: PO_LOG.proc_end(d_module);
1081: END IF;
1082: EXCEPTION
1083: WHEN OTHERS THEN
1084: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1086: IF PO_LOG.d_exc THEN

1082: EXCEPTION
1083: WHEN OTHERS THEN
1084: x_return_status := FND_API.g_ret_sts_unexp_error;
1085: FND_MSG_PUB.add_exc_msg(d_pkg_name, l_api_name||':'||d_pos);
1086: IF PO_LOG.d_exc THEN
1087: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
1088: END IF;
1089: END get_mod_valid_control_actions;
1090:

Line 1087: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);

1083: WHEN OTHERS THEN
1084: x_return_status := FND_API.g_ret_sts_unexp_error;
1085: FND_MSG_PUB.add_exc_msg(d_pkg_name, l_api_name||':'||d_pos);
1086: IF PO_LOG.d_exc THEN
1087: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
1088: END IF;
1089: END get_mod_valid_control_actions;
1090:
1091: ------------------------------------------------------------------------------

Line 1147: IF ( po_log.d_proc ) THEN

1143: -- 6) Abort all the open collaboration workflows.
1144:
1145: SAVEPOINT WITHDRAW_ACTION_SP;
1146:
1147: IF ( po_log.d_proc ) THEN
1148: po_log.Proc_begin(d_module);
1149: END IF;
1150:
1151: d_position := 10;

Line 1148: po_log.Proc_begin(d_module);

1144:
1145: SAVEPOINT WITHDRAW_ACTION_SP;
1146:
1147: IF ( po_log.d_proc ) THEN
1148: po_log.Proc_begin(d_module);
1149: END IF;
1150:
1151: d_position := 10;
1152:

Line 1170: IF po_log.d_stmt THEN

1166: AND podc.org_id = prh.org_id;
1167:
1168: PO_MOAC_UTILS_PVt.set_org_context(l_org_id);
1169:
1170: IF po_log.d_stmt THEN
1171: po_debug.Debug_stmt(d_module, d_position, 'Req Header Id : ' || l_req_header_id);
1172: END IF;
1173:
1174: d_position := 20;

Line 1205: IF (PO_LOG.d_stmt) THEN

1201: , p_org_id => NULL
1202: );
1203:
1204: d_position := 30;
1205: IF (PO_LOG.d_stmt) THEN
1206: PO_LOG.stmt(d_module, d_position, 'l_req_enc_on', l_req_enc_on);
1207: END IF;
1208:
1209: IF (l_req_enc_on) THEN

Line 1206: PO_LOG.stmt(d_module, d_position, 'l_req_enc_on', l_req_enc_on);

1202: );
1203:
1204: d_position := 30;
1205: IF (PO_LOG.d_stmt) THEN
1206: PO_LOG.stmt(d_module, d_position, 'l_req_enc_on', l_req_enc_on);
1207: END IF;
1208:
1209: IF (l_req_enc_on) THEN
1210:

Line 1239: IF (PO_LOG.d_stmt) THEN

1235: END IF;
1236:
1237: d_position := 60;
1238:
1239: IF (PO_LOG.d_stmt) THEN
1240: PO_LOG.stmt(d_module, d_position, 'l_enc_ret_code', l_enc_ret_code);
1241: PO_LOG.stmt(d_module, d_position, 'l_enc_report_id', l_enc_report_id);
1242: END IF;
1243:

Line 1240: PO_LOG.stmt(d_module, d_position, 'l_enc_ret_code', l_enc_ret_code);

1236:
1237: d_position := 60;
1238:
1239: IF (PO_LOG.d_stmt) THEN
1240: PO_LOG.stmt(d_module, d_position, 'l_enc_ret_code', l_enc_ret_code);
1241: PO_LOG.stmt(d_module, d_position, 'l_enc_report_id', l_enc_report_id);
1242: END IF;
1243:
1244: IF ((l_enc_ret_code = PO_DOCUMENT_FUNDS_PVT.g_return_SUCCESS)

Line 1241: PO_LOG.stmt(d_module, d_position, 'l_enc_report_id', l_enc_report_id);

1237: d_position := 60;
1238:
1239: IF (PO_LOG.d_stmt) THEN
1240: PO_LOG.stmt(d_module, d_position, 'l_enc_ret_code', l_enc_ret_code);
1241: PO_LOG.stmt(d_module, d_position, 'l_enc_report_id', l_enc_report_id);
1242: END IF;
1243:
1244: IF ((l_enc_ret_code = PO_DOCUMENT_FUNDS_PVT.g_return_SUCCESS)
1245: OR (l_enc_ret_code = PO_DOCUMENT_FUNDS_PVT.g_return_WARNING))

Line 1419: IF po_log.d_stmt THEN

1415: END IF;
1416: END LOOP;
1417: EXCEPTION
1418: WHEN no_data_found THEN
1419: IF po_log.d_stmt THEN
1420: po_debug.Debug_stmt(d_module, d_position, 'No notification data found');
1421: END IF;
1422: END;
1423:

Line 1428: IF ( po_log.d_proc ) THEN

1424: d_position := 190;
1425:
1426: x_return_status := fnd_api.g_ret_sts_success;
1427:
1428: IF ( po_log.d_proc ) THEN
1429: po_log.Proc_end(d_module);
1430: END IF;
1431:
1432: EXCEPTION

Line 1429: po_log.Proc_end(d_module);

1425:
1426: x_return_status := fnd_api.g_ret_sts_success;
1427:
1428: IF ( po_log.d_proc ) THEN
1429: po_log.Proc_end(d_module);
1430: END IF;
1431:
1432: EXCEPTION
1433: WHEN PO_CORE_S.g_early_return_exc THEN

Line 1435: IF PO_LOG.d_exc THEN

1431:
1432: EXCEPTION
1433: WHEN PO_CORE_S.g_early_return_exc THEN
1434:
1435: IF PO_LOG.d_exc THEN
1436: PO_LOG.exc(d_module, d_position, 'Exception occurred ' || x_return_mssg);
1437: END IF;
1438:
1439: ROLLBACK TO WITHDRAW_ACTION_SP;

Line 1436: PO_LOG.exc(d_module, d_position, 'Exception occurred ' || x_return_mssg);

1432: EXCEPTION
1433: WHEN PO_CORE_S.g_early_return_exc THEN
1434:
1435: IF PO_LOG.d_exc THEN
1436: PO_LOG.exc(d_module, d_position, 'Exception occurred ' || x_return_mssg);
1437: END IF;
1438:
1439: ROLLBACK TO WITHDRAW_ACTION_SP;
1440:

Line 1443: IF PO_LOG.d_exc THEN

1439: ROLLBACK TO WITHDRAW_ACTION_SP;
1440:
1441: WHEN OTHERS THEN
1442:
1443: IF PO_LOG.d_exc THEN
1444: PO_LOG.exc(d_module, d_position, 'Exception occurred ' || SQLERRM);
1445: END IF;
1446: x_return_status := fnd_api.G_RET_STS_ERROR;
1447: x_return_mssg := SQLERRM;

Line 1444: PO_LOG.exc(d_module, d_position, 'Exception occurred ' || SQLERRM);

1440:
1441: WHEN OTHERS THEN
1442:
1443: IF PO_LOG.d_exc THEN
1444: PO_LOG.exc(d_module, d_position, 'Exception occurred ' || SQLERRM);
1445: END IF;
1446: x_return_status := fnd_api.G_RET_STS_ERROR;
1447: x_return_mssg := SQLERRM;
1448: