APPS.PO_DRAFTS_PVT dependencies on PO_LOG

Line 5: PO_LOG.get_package_base('PO_DRAFTS_PVT');

1: PACKAGE BODY PO_DRAFTS_PVT AS
2: /* $Header: PO_DRAFTS_PVT.plb 120.32 2006/11/21 03:08:36 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_DRAFTS_PVT');
6:
7:
8: -------------------------------------------------------
9: ----------- PRIVATE PROCEDURES PROTOTYPE --------------

Line 126: IF (PO_LOG.d_proc) THEN

122: d_position := 0;
123:
124: SAVEPOINT transfer_draft_to_txn_sp;
125:
126: IF (PO_LOG.d_proc) THEN
127: PO_LOG.proc_begin(d_module);
128: PO_LOG.proc_begin(d_module, 'p_init_msg_list', p_init_msg_list);
129: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
130: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);

Line 127: PO_LOG.proc_begin(d_module);

123:
124: SAVEPOINT transfer_draft_to_txn_sp;
125:
126: IF (PO_LOG.d_proc) THEN
127: PO_LOG.proc_begin(d_module);
128: PO_LOG.proc_begin(d_module, 'p_init_msg_list', p_init_msg_list);
129: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
130: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
131: PO_LOG.proc_begin(d_module, 'p_delete_processed_draft',

Line 128: PO_LOG.proc_begin(d_module, 'p_init_msg_list', p_init_msg_list);

124: SAVEPOINT transfer_draft_to_txn_sp;
125:
126: IF (PO_LOG.d_proc) THEN
127: PO_LOG.proc_begin(d_module);
128: PO_LOG.proc_begin(d_module, 'p_init_msg_list', p_init_msg_list);
129: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
130: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
131: PO_LOG.proc_begin(d_module, 'p_delete_processed_draft',
132: p_delete_processed_draft);

Line 129: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);

125:
126: IF (PO_LOG.d_proc) THEN
127: PO_LOG.proc_begin(d_module);
128: PO_LOG.proc_begin(d_module, 'p_init_msg_list', p_init_msg_list);
129: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
130: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
131: PO_LOG.proc_begin(d_module, 'p_delete_processed_draft',
132: p_delete_processed_draft);
133: PO_LOG.proc_begin(d_module, 'p_acceptance_action', p_acceptance_action);

Line 130: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);

126: IF (PO_LOG.d_proc) THEN
127: PO_LOG.proc_begin(d_module);
128: PO_LOG.proc_begin(d_module, 'p_init_msg_list', p_init_msg_list);
129: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
130: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
131: PO_LOG.proc_begin(d_module, 'p_delete_processed_draft',
132: p_delete_processed_draft);
133: PO_LOG.proc_begin(d_module, 'p_acceptance_action', p_acceptance_action);
134: END IF;

Line 131: PO_LOG.proc_begin(d_module, 'p_delete_processed_draft',

127: PO_LOG.proc_begin(d_module);
128: PO_LOG.proc_begin(d_module, 'p_init_msg_list', p_init_msg_list);
129: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
130: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
131: PO_LOG.proc_begin(d_module, 'p_delete_processed_draft',
132: p_delete_processed_draft);
133: PO_LOG.proc_begin(d_module, 'p_acceptance_action', p_acceptance_action);
134: END IF;
135:

Line 133: PO_LOG.proc_begin(d_module, 'p_acceptance_action', p_acceptance_action);

129: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
130: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
131: PO_LOG.proc_begin(d_module, 'p_delete_processed_draft',
132: p_delete_processed_draft);
133: PO_LOG.proc_begin(d_module, 'p_acceptance_action', p_acceptance_action);
134: END IF;
135:
136: IF (FND_API.to_boolean(p_init_msg_list)) THEN
137: FND_MSG_PUB.initialize;

Line 156: IF (PO_LOG.d_stmt) THEN

152:
153: -- if acceptance action is specified, we need to propogate the action to
154: -- all levels
155: IF (p_acceptance_action IS NOT NULL) THEN
156: IF (PO_LOG.d_stmt) THEN
157: PO_LOG.stmt(d_module, d_position, 'update acceptance action');
158: END IF;
159:
160: update_acceptance_status

Line 157: PO_LOG.stmt(d_module, d_position, 'update acceptance action');

153: -- if acceptance action is specified, we need to propogate the action to
154: -- all levels
155: IF (p_acceptance_action IS NOT NULL) THEN
156: IF (PO_LOG.d_stmt) THEN
157: PO_LOG.stmt(d_module, d_position, 'update acceptance action');
158: END IF;
159:
160: update_acceptance_status
161: ( p_draft_id => p_draft_id,

Line 210: IF (PO_LOG.d_stmt) THEN

206: l_type := PO_CATALOG_INDEX_PVT.TYPE_QUOTATION; --Bug#4902870
207: -- For quotations, there is no need to performa approval status or revision
208: -- checking
209:
210: IF (PO_LOG.d_stmt) THEN
211: PO_LOG.stmt(d_module, d_position, 'document is quotation');
212: END IF;
213:
214: d_position := 60;

Line 211: PO_LOG.stmt(d_module, d_position, 'document is quotation');

207: -- For quotations, there is no need to performa approval status or revision
208: -- checking
209:
210: IF (PO_LOG.d_stmt) THEN
211: PO_LOG.stmt(d_module, d_position, 'document is quotation');
212: END IF;
213:
214: d_position := 60;
215: apply_changes

Line 248: IF (PO_LOG.d_proc) THEN

244: p_po_header_id => p_po_header_id
245: );
246: end if;
247:
248: IF (PO_LOG.d_proc) THEN
249: PO_LOG.proc_end(d_module);
250: END IF;
251:
252: EXCEPTION

Line 249: PO_LOG.proc_end(d_module);

245: );
246: end if;
247:
248: IF (PO_LOG.d_proc) THEN
249: PO_LOG.proc_end(d_module);
250: END IF;
251:
252: EXCEPTION
253: WHEN OTHERS THEN

Line 304: IF (PO_LOG.d_proc) THEN

300:
301: BEGIN
302:
303: d_position := 0;
304: IF (PO_LOG.d_proc) THEN
305: PO_LOG.proc_begin(d_module);
306: END IF;
307:
308: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 305: PO_LOG.proc_begin(d_module);

301: BEGIN
302:
303: d_position := 0;
304: IF (PO_LOG.d_proc) THEN
305: PO_LOG.proc_begin(d_module);
306: END IF;
307:
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309:

Line 372: IF (PO_LOG.d_proc) THEN

368: WHERE draft_id = p_draft_id;
369: END IF;
370:
371: d_position := 100;
372: IF (PO_LOG.d_proc) THEN
373: PO_LOG.proc_end(d_module);
374: END IF;
375: EXCEPTION
376: WHEN OTHERS THEN

Line 373: PO_LOG.proc_end(d_module);

369: END IF;
370:
371: d_position := 100;
372: IF (PO_LOG.d_proc) THEN
373: PO_LOG.proc_end(d_module);
374: END IF;
375: EXCEPTION
376: WHEN OTHERS THEN
377: PO_MESSAGE_S.add_exc_msg

Line 428: IF (PO_LOG.d_proc) THEN

424:
425: BEGIN
426:
427: d_position := 0;
428: IF (PO_LOG.d_proc) THEN
429: PO_LOG.proc_begin(d_module);
430: END IF;
431:
432: x_draft_info.draft_id := p_draft_id;

Line 429: PO_LOG.proc_begin(d_module);

425: BEGIN
426:
427: d_position := 0;
428: IF (PO_LOG.d_proc) THEN
429: PO_LOG.proc_begin(d_module);
430: END IF;
431:
432: x_draft_info.draft_id := p_draft_id;
433: x_draft_info.po_header_id := p_po_header_id;

Line 556: IF (PO_LOG.d_stmt) THEN

552: );
553:
554: d_position := 130;
555:
556: IF (PO_LOG.d_stmt) THEN
557: PO_LOG.stmt(d_module, d_position, 'draft_id', x_draft_info.draft_id);
558: PO_LOG.stmt(d_module, d_position, 'po_header_id',
559: x_draft_info.po_header_id);
560: PO_LOG.stmt(d_module, d_position, 'doc_type', x_draft_info.doc_type);

Line 557: PO_LOG.stmt(d_module, d_position, 'draft_id', x_draft_info.draft_id);

553:
554: d_position := 130;
555:
556: IF (PO_LOG.d_stmt) THEN
557: PO_LOG.stmt(d_module, d_position, 'draft_id', x_draft_info.draft_id);
558: PO_LOG.stmt(d_module, d_position, 'po_header_id',
559: x_draft_info.po_header_id);
560: PO_LOG.stmt(d_module, d_position, 'doc_type', x_draft_info.doc_type);
561: PO_LOG.stmt(d_module, d_position, 'doc_subtype', x_draft_info.doc_subtype);

Line 558: PO_LOG.stmt(d_module, d_position, 'po_header_id',

554: d_position := 130;
555:
556: IF (PO_LOG.d_stmt) THEN
557: PO_LOG.stmt(d_module, d_position, 'draft_id', x_draft_info.draft_id);
558: PO_LOG.stmt(d_module, d_position, 'po_header_id',
559: x_draft_info.po_header_id);
560: PO_LOG.stmt(d_module, d_position, 'doc_type', x_draft_info.doc_type);
561: PO_LOG.stmt(d_module, d_position, 'doc_subtype', x_draft_info.doc_subtype);
562: PO_LOG.stmt(d_module, d_position, 'ga_flag', x_draft_info.ga_flag);

Line 560: PO_LOG.stmt(d_module, d_position, 'doc_type', x_draft_info.doc_type);

556: IF (PO_LOG.d_stmt) THEN
557: PO_LOG.stmt(d_module, d_position, 'draft_id', x_draft_info.draft_id);
558: PO_LOG.stmt(d_module, d_position, 'po_header_id',
559: x_draft_info.po_header_id);
560: PO_LOG.stmt(d_module, d_position, 'doc_type', x_draft_info.doc_type);
561: PO_LOG.stmt(d_module, d_position, 'doc_subtype', x_draft_info.doc_subtype);
562: PO_LOG.stmt(d_module, d_position, 'ga_flag', x_draft_info.ga_flag);
563: PO_LOG.stmt(d_module, d_position, 'new_document',
564: x_draft_info.new_document);

Line 561: PO_LOG.stmt(d_module, d_position, 'doc_subtype', x_draft_info.doc_subtype);

557: PO_LOG.stmt(d_module, d_position, 'draft_id', x_draft_info.draft_id);
558: PO_LOG.stmt(d_module, d_position, 'po_header_id',
559: x_draft_info.po_header_id);
560: PO_LOG.stmt(d_module, d_position, 'doc_type', x_draft_info.doc_type);
561: PO_LOG.stmt(d_module, d_position, 'doc_subtype', x_draft_info.doc_subtype);
562: PO_LOG.stmt(d_module, d_position, 'ga_flag', x_draft_info.ga_flag);
563: PO_LOG.stmt(d_module, d_position, 'new_document',
564: x_draft_info.new_document);
565: PO_LOG.stmt(d_module, d_position, 'headers_changed',

Line 562: PO_LOG.stmt(d_module, d_position, 'ga_flag', x_draft_info.ga_flag);

558: PO_LOG.stmt(d_module, d_position, 'po_header_id',
559: x_draft_info.po_header_id);
560: PO_LOG.stmt(d_module, d_position, 'doc_type', x_draft_info.doc_type);
561: PO_LOG.stmt(d_module, d_position, 'doc_subtype', x_draft_info.doc_subtype);
562: PO_LOG.stmt(d_module, d_position, 'ga_flag', x_draft_info.ga_flag);
563: PO_LOG.stmt(d_module, d_position, 'new_document',
564: x_draft_info.new_document);
565: PO_LOG.stmt(d_module, d_position, 'headers_changed',
566: x_draft_info.headers_changed);

Line 563: PO_LOG.stmt(d_module, d_position, 'new_document',

559: x_draft_info.po_header_id);
560: PO_LOG.stmt(d_module, d_position, 'doc_type', x_draft_info.doc_type);
561: PO_LOG.stmt(d_module, d_position, 'doc_subtype', x_draft_info.doc_subtype);
562: PO_LOG.stmt(d_module, d_position, 'ga_flag', x_draft_info.ga_flag);
563: PO_LOG.stmt(d_module, d_position, 'new_document',
564: x_draft_info.new_document);
565: PO_LOG.stmt(d_module, d_position, 'headers_changed',
566: x_draft_info.headers_changed);
567: PO_LOG.stmt(d_module, d_position, 'lines_changed',

Line 565: PO_LOG.stmt(d_module, d_position, 'headers_changed',

561: PO_LOG.stmt(d_module, d_position, 'doc_subtype', x_draft_info.doc_subtype);
562: PO_LOG.stmt(d_module, d_position, 'ga_flag', x_draft_info.ga_flag);
563: PO_LOG.stmt(d_module, d_position, 'new_document',
564: x_draft_info.new_document);
565: PO_LOG.stmt(d_module, d_position, 'headers_changed',
566: x_draft_info.headers_changed);
567: PO_LOG.stmt(d_module, d_position, 'lines_changed',
568: x_draft_info.lines_changed);
569: PO_LOG.stmt(d_module, d_position, 'line_locations_changed',

Line 567: PO_LOG.stmt(d_module, d_position, 'lines_changed',

563: PO_LOG.stmt(d_module, d_position, 'new_document',
564: x_draft_info.new_document);
565: PO_LOG.stmt(d_module, d_position, 'headers_changed',
566: x_draft_info.headers_changed);
567: PO_LOG.stmt(d_module, d_position, 'lines_changed',
568: x_draft_info.lines_changed);
569: PO_LOG.stmt(d_module, d_position, 'line_locations_changed',
570: x_draft_info.line_locations_changed);
571: PO_LOG.stmt(d_module, d_position, 'distributions_changed',

Line 569: PO_LOG.stmt(d_module, d_position, 'line_locations_changed',

565: PO_LOG.stmt(d_module, d_position, 'headers_changed',
566: x_draft_info.headers_changed);
567: PO_LOG.stmt(d_module, d_position, 'lines_changed',
568: x_draft_info.lines_changed);
569: PO_LOG.stmt(d_module, d_position, 'line_locations_changed',
570: x_draft_info.line_locations_changed);
571: PO_LOG.stmt(d_module, d_position, 'distributions_changed',
572: x_draft_info.distributions_changed);
573: PO_LOG.stmt(d_module, d_position, 'ga_org_assign_changed',

Line 571: PO_LOG.stmt(d_module, d_position, 'distributions_changed',

567: PO_LOG.stmt(d_module, d_position, 'lines_changed',
568: x_draft_info.lines_changed);
569: PO_LOG.stmt(d_module, d_position, 'line_locations_changed',
570: x_draft_info.line_locations_changed);
571: PO_LOG.stmt(d_module, d_position, 'distributions_changed',
572: x_draft_info.distributions_changed);
573: PO_LOG.stmt(d_module, d_position, 'ga_org_assign_changed',
574: x_draft_info.ga_org_assign_changed);
575: PO_LOG.stmt(d_module, d_position, 'price_diff_changed',

Line 573: PO_LOG.stmt(d_module, d_position, 'ga_org_assign_changed',

569: PO_LOG.stmt(d_module, d_position, 'line_locations_changed',
570: x_draft_info.line_locations_changed);
571: PO_LOG.stmt(d_module, d_position, 'distributions_changed',
572: x_draft_info.distributions_changed);
573: PO_LOG.stmt(d_module, d_position, 'ga_org_assign_changed',
574: x_draft_info.ga_org_assign_changed);
575: PO_LOG.stmt(d_module, d_position, 'price_diff_changed',
576: x_draft_info.price_diff_changed);
577: PO_LOG.stmt(d_module, d_position, 'notification_ctrl_changed',

Line 575: PO_LOG.stmt(d_module, d_position, 'price_diff_changed',

571: PO_LOG.stmt(d_module, d_position, 'distributions_changed',
572: x_draft_info.distributions_changed);
573: PO_LOG.stmt(d_module, d_position, 'ga_org_assign_changed',
574: x_draft_info.ga_org_assign_changed);
575: PO_LOG.stmt(d_module, d_position, 'price_diff_changed',
576: x_draft_info.price_diff_changed);
577: PO_LOG.stmt(d_module, d_position, 'notification_ctrl_changed',
578: x_draft_info.notification_ctrl_changed);
579: PO_LOG.stmt(d_module, d_position, 'attribute_values_changed',

Line 577: PO_LOG.stmt(d_module, d_position, 'notification_ctrl_changed',

573: PO_LOG.stmt(d_module, d_position, 'ga_org_assign_changed',
574: x_draft_info.ga_org_assign_changed);
575: PO_LOG.stmt(d_module, d_position, 'price_diff_changed',
576: x_draft_info.price_diff_changed);
577: PO_LOG.stmt(d_module, d_position, 'notification_ctrl_changed',
578: x_draft_info.notification_ctrl_changed);
579: PO_LOG.stmt(d_module, d_position, 'attribute_values_changed',
580: x_draft_info.attr_values_changed);
581: PO_LOG.stmt(d_module, d_position, 'attribute_values_tlp_changed',

Line 579: PO_LOG.stmt(d_module, d_position, 'attribute_values_changed',

575: PO_LOG.stmt(d_module, d_position, 'price_diff_changed',
576: x_draft_info.price_diff_changed);
577: PO_LOG.stmt(d_module, d_position, 'notification_ctrl_changed',
578: x_draft_info.notification_ctrl_changed);
579: PO_LOG.stmt(d_module, d_position, 'attribute_values_changed',
580: x_draft_info.attr_values_changed);
581: PO_LOG.stmt(d_module, d_position, 'attribute_values_tlp_changed',
582: x_draft_info.attr_values_tlp_changed);
583: END IF;

Line 581: PO_LOG.stmt(d_module, d_position, 'attribute_values_tlp_changed',

577: PO_LOG.stmt(d_module, d_position, 'notification_ctrl_changed',
578: x_draft_info.notification_ctrl_changed);
579: PO_LOG.stmt(d_module, d_position, 'attribute_values_changed',
580: x_draft_info.attr_values_changed);
581: PO_LOG.stmt(d_module, d_position, 'attribute_values_tlp_changed',
582: x_draft_info.attr_values_tlp_changed);
583: END IF;
584:
585: IF (PO_LOG.d_proc) THEN

Line 585: IF (PO_LOG.d_proc) THEN

581: PO_LOG.stmt(d_module, d_position, 'attribute_values_tlp_changed',
582: x_draft_info.attr_values_tlp_changed);
583: END IF;
584:
585: IF (PO_LOG.d_proc) THEN
586: PO_LOG.proc_end(d_module);
587: END IF;
588: EXCEPTION
589: WHEN OTHERS THEN

Line 586: PO_LOG.proc_end(d_module);

582: x_draft_info.attr_values_tlp_changed);
583: END IF;
584:
585: IF (PO_LOG.d_proc) THEN
586: PO_LOG.proc_end(d_module);
587: END IF;
588: EXCEPTION
589: WHEN OTHERS THEN
590: PO_MESSAGE_S.add_exc_msg

Line 622: IF (PO_LOG.d_proc) THEN

618: d_position NUMBER;
619:
620: BEGIN
621:
622: IF (PO_LOG.d_proc) THEN
623: PO_LOG.proc_begin(d_module);
624: END IF;
625:
626: d_position := 0;

Line 623: PO_LOG.proc_begin(d_module);

619:
620: BEGIN
621:
622: IF (PO_LOG.d_proc) THEN
623: PO_LOG.proc_begin(d_module);
624: END IF;
625:
626: d_position := 0;
627:

Line 639: IF (PO_LOG.d_proc) THEN

635: ( p_draft_info => p_draft_info
636: );
637:
638:
639: IF (PO_LOG.d_proc) THEN
640: PO_LOG.proc_end(d_module);
641: END IF;
642:
643: EXCEPTION

Line 640: PO_LOG.proc_end(d_module);

636: );
637:
638:
639: IF (PO_LOG.d_proc) THEN
640: PO_LOG.proc_end(d_module);
641: END IF;
642:
643: EXCEPTION
644: WHEN OTHERS THEN

Line 689: IF (PO_LOG.d_proc) THEN

685: d_position NUMBER;
686:
687: BEGIN
688: d_position := 0;
689: IF (PO_LOG.d_proc) THEN
690: PO_LOG.proc_begin(d_module);
691: END IF;
692:
693: --SQL What: Search for a non-completed draft given the document id

Line 690: PO_LOG.proc_begin(d_module);

686:
687: BEGIN
688: d_position := 0;
689: IF (PO_LOG.d_proc) THEN
690: PO_LOG.proc_begin(d_module);
691: END IF;
692:
693: --SQL What: Search for a non-completed draft given the document id
694: --SQL Why:

Line 707: IF (PO_LOG.d_proc) THEN

703: AND DFT.status <> g_status_COMPLETED;
704:
705: d_position := 10;
706:
707: IF (PO_LOG.d_proc) THEN
708: PO_LOG.proc_end(d_module, 'draft_id', x_draft_id);
709: PO_LOG.proc_end(d_module, 'draft_status', x_draft_status);
710: PO_LOG.proc_end(d_module, 'draft_owner_role', x_draft_owner_role);
711: PO_LOG.proc_end(d_module);

Line 708: PO_LOG.proc_end(d_module, 'draft_id', x_draft_id);

704:
705: d_position := 10;
706:
707: IF (PO_LOG.d_proc) THEN
708: PO_LOG.proc_end(d_module, 'draft_id', x_draft_id);
709: PO_LOG.proc_end(d_module, 'draft_status', x_draft_status);
710: PO_LOG.proc_end(d_module, 'draft_owner_role', x_draft_owner_role);
711: PO_LOG.proc_end(d_module);
712: END IF;

Line 709: PO_LOG.proc_end(d_module, 'draft_status', x_draft_status);

705: d_position := 10;
706:
707: IF (PO_LOG.d_proc) THEN
708: PO_LOG.proc_end(d_module, 'draft_id', x_draft_id);
709: PO_LOG.proc_end(d_module, 'draft_status', x_draft_status);
710: PO_LOG.proc_end(d_module, 'draft_owner_role', x_draft_owner_role);
711: PO_LOG.proc_end(d_module);
712: END IF;
713:

Line 710: PO_LOG.proc_end(d_module, 'draft_owner_role', x_draft_owner_role);

706:
707: IF (PO_LOG.d_proc) THEN
708: PO_LOG.proc_end(d_module, 'draft_id', x_draft_id);
709: PO_LOG.proc_end(d_module, 'draft_status', x_draft_status);
710: PO_LOG.proc_end(d_module, 'draft_owner_role', x_draft_owner_role);
711: PO_LOG.proc_end(d_module);
712: END IF;
713:
714: EXCEPTION

Line 711: PO_LOG.proc_end(d_module);

707: IF (PO_LOG.d_proc) THEN
708: PO_LOG.proc_end(d_module, 'draft_id', x_draft_id);
709: PO_LOG.proc_end(d_module, 'draft_status', x_draft_status);
710: PO_LOG.proc_end(d_module, 'draft_owner_role', x_draft_owner_role);
711: PO_LOG.proc_end(d_module);
712: END IF;
713:
714: EXCEPTION
715: WHEN NO_DATA_FOUND THEN

Line 754: IF (PO_LOG.d_proc) THEN

750: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
751:
752: BEGIN
753: d_position := 0;
754: IF (PO_LOG.d_proc) THEN
755: PO_LOG.proc_begin(d_module);
756: END IF;
757:
758: find_draft

Line 755: PO_LOG.proc_begin(d_module);

751:
752: BEGIN
753: d_position := 0;
754: IF (PO_LOG.d_proc) THEN
755: PO_LOG.proc_begin(d_module);
756: END IF;
757:
758: find_draft
759: ( p_po_header_id => p_po_header_id,

Line 765: IF (PO_LOG.d_proc) THEN

761: x_draft_status => l_draft_status,
762: x_draft_owner_role => l_draft_owner_role
763: );
764:
765: IF (PO_LOG.d_proc) THEN
766: PO_LOG.proc_end(d_module, 'draft_id', x_draft_id);
767: PO_LOG.proc_end(d_module);
768: END IF;
769: END find_draft;

Line 766: PO_LOG.proc_end(d_module, 'draft_id', x_draft_id);

762: x_draft_owner_role => l_draft_owner_role
763: );
764:
765: IF (PO_LOG.d_proc) THEN
766: PO_LOG.proc_end(d_module, 'draft_id', x_draft_id);
767: PO_LOG.proc_end(d_module);
768: END IF;
769: END find_draft;
770:

Line 767: PO_LOG.proc_end(d_module);

763: );
764:
765: IF (PO_LOG.d_proc) THEN
766: PO_LOG.proc_end(d_module, 'draft_id', x_draft_id);
767: PO_LOG.proc_end(d_module);
768: END IF;
769: END find_draft;
770:
771: -----------------------------------------------------------------------

Line 799: IF (PO_LOG.d_proc) THEN

795:
796: BEGIN
797: d_position := 0;
798:
799: IF (PO_LOG.d_proc) THEN
800: PO_LOG.proc_begin(d_module);
801: END IF;
802:
803: SELECT request_id

Line 800: PO_LOG.proc_begin(d_module);

796: BEGIN
797: d_position := 0;
798:
799: IF (PO_LOG.d_proc) THEN
800: PO_LOG.proc_begin(d_module);
801: END IF;
802:
803: SELECT request_id
804: INTO x_request_id

Line 808: IF (PO_LOG.d_proc) THEN

804: INTO x_request_id
805: FROM po_drafts
806: WHERE draft_id = p_draft_id;
807:
808: IF (PO_LOG.d_proc) THEN
809: PO_LOG.proc_end(d_module);
810: END IF;
811:
812: EXCEPTION

Line 809: PO_LOG.proc_end(d_module);

805: FROM po_drafts
806: WHERE draft_id = p_draft_id;
807:
808: IF (PO_LOG.d_proc) THEN
809: PO_LOG.proc_end(d_module);
810: END IF;
811:
812: EXCEPTION
813: WHEN OTHERS THEN

Line 850: IF (PO_LOG.d_proc) THEN

846:
847: BEGIN
848:
849: d_position := 0;
850: IF (PO_LOG.d_proc) THEN
851: PO_LOG.proc_begin(d_module);
852: END IF;
853:
854: --SQL What: get information about the user locking the document

Line 851: PO_LOG.proc_begin(d_module);

847: BEGIN
848:
849: d_position := 0;
850: IF (PO_LOG.d_proc) THEN
851: PO_LOG.proc_begin(d_module);
852: END IF;
853:
854: --SQL What: get information about the user locking the document
855: --SQL Why: these are the values getting returned

Line 863: IF (PO_LOG.d_proc) THEN

859: x_lock_owner_user_id
860: FROM po_headers_all
861: WHERE po_header_id = p_po_header_id;
862:
863: IF (PO_LOG.d_proc) THEN
864: PO_LOG.proc_end(d_module);
865: END IF;
866:
867: EXCEPTION

Line 864: PO_LOG.proc_end(d_module);

860: FROM po_headers_all
861: WHERE po_header_id = p_po_header_id;
862:
863: IF (PO_LOG.d_proc) THEN
864: PO_LOG.proc_end(d_module);
865: END IF;
866:
867: EXCEPTION
868: WHEN NO_DATA_FOUND THEN

Line 904: IF (PO_LOG.d_proc) THEN

900:
901: BEGIN
902:
903: d_position := 0;
904: IF (PO_LOG.d_proc) THEN
905: PO_LOG.proc_begin(d_module);
906: PO_LOG.proc_begin(d_module, 'p_role', p_role);
907: PO_LOG.proc_begin(d_module, 'p_role_user_id', p_role_user_id);
908: END IF;

Line 905: PO_LOG.proc_begin(d_module);

901: BEGIN
902:
903: d_position := 0;
904: IF (PO_LOG.d_proc) THEN
905: PO_LOG.proc_begin(d_module);
906: PO_LOG.proc_begin(d_module, 'p_role', p_role);
907: PO_LOG.proc_begin(d_module, 'p_role_user_id', p_role_user_id);
908: END IF;
909:

Line 906: PO_LOG.proc_begin(d_module, 'p_role', p_role);

902:
903: d_position := 0;
904: IF (PO_LOG.d_proc) THEN
905: PO_LOG.proc_begin(d_module);
906: PO_LOG.proc_begin(d_module, 'p_role', p_role);
907: PO_LOG.proc_begin(d_module, 'p_role_user_id', p_role_user_id);
908: END IF;
909:
910: --SQL What: update lock owner role and lock owner id

Line 907: PO_LOG.proc_begin(d_module, 'p_role_user_id', p_role_user_id);

903: d_position := 0;
904: IF (PO_LOG.d_proc) THEN
905: PO_LOG.proc_begin(d_module);
906: PO_LOG.proc_begin(d_module, 'p_role', p_role);
907: PO_LOG.proc_begin(d_module, 'p_role_user_id', p_role_user_id);
908: END IF;
909:
910: --SQL What: update lock owner role and lock owner id
911: --SQL Why: This is what this procedure is doing

Line 917: IF (PO_LOG.d_proc) THEN

913: SET lock_owner_role = p_role,
914: lock_owner_user_id = p_role_user_id
915: WHERE po_header_id = p_po_header_id;
916:
917: IF (PO_LOG.d_proc) THEN
918: PO_LOG.proc_end(d_module);
919: END IF;
920: END set_lock_owner_info;
921:

Line 918: PO_LOG.proc_end(d_module);

914: lock_owner_user_id = p_role_user_id
915: WHERE po_header_id = p_po_header_id;
916:
917: IF (PO_LOG.d_proc) THEN
918: PO_LOG.proc_end(d_module);
919: END IF;
920: END set_lock_owner_info;
921:
922:

Line 990: IF (PO_LOG.d_proc) THEN

986: l_updatable_state VARCHAR2(1); -- bug5532550
987: BEGIN
988:
989: d_position := 0;
990: IF (PO_LOG.d_proc) THEN
991: PO_LOG.proc_begin(d_module);
992: END IF;
993:
994: x_update_allowed := FND_API.G_TRUE;

Line 991: PO_LOG.proc_begin(d_module);

987: BEGIN
988:
989: d_position := 0;
990: IF (PO_LOG.d_proc) THEN
991: PO_LOG.proc_begin(d_module);
992: END IF;
993:
994: x_update_allowed := FND_API.G_TRUE;
995: x_locking_applicable := FND_API.G_TRUE;

Line 1004: IF (PO_LOG.d_stmt) THEN

1000:
1001: IF (p_po_header_id IS NULL) THEN
1002: d_position := 10;
1003:
1004: IF (PO_LOG.d_stmt) THEN
1005: PO_LOG.stmt (d_module, d_position, 'no po header id. Quitting');
1006: END IF;
1007:
1008: -- no document to check. Simply return

Line 1005: PO_LOG.stmt (d_module, d_position, 'no po header id. Quitting');

1001: IF (p_po_header_id IS NULL) THEN
1002: d_position := 10;
1003:
1004: IF (PO_LOG.d_stmt) THEN
1005: PO_LOG.stmt (d_module, d_position, 'no po header id. Quitting');
1006: END IF;
1007:
1008: -- no document to check. Simply return
1009: RETURN;

Line 1023: IF (PO_LOG.d_stmt) THEN

1019: );
1020:
1021: IF (l_draft_id IS NOT NULL) THEN
1022:
1023: IF (PO_LOG.d_stmt) THEN
1024: PO_LOG.stmt (d_module, d_position, 'has active draft');
1025: END IF;
1026:
1027: d_position := 30;

Line 1024: PO_LOG.stmt (d_module, d_position, 'has active draft');

1020:
1021: IF (l_draft_id IS NOT NULL) THEN
1022:
1023: IF (PO_LOG.d_stmt) THEN
1024: PO_LOG.stmt (d_module, d_position, 'has active draft');
1025: END IF;
1026:
1027: d_position := 30;
1028:

Line 1091: IF (PO_LOG.d_stmt) THEN

1087: );
1088:
1089: IF (l_upload_in_progress = FND_API.G_TRUE) THEN
1090: IF (l_upload_status_code IN (g_upload_status_PENDING, g_upload_status_RUNNING)) THEN
1091: IF (PO_LOG.d_stmt) THEN
1092: PO_LOG.stmt (d_module, d_position, 'in progress catalog upload');
1093: END IF;
1094:
1095: x_message := 'PO_UPLOAD_PENDING_RUNNING';

Line 1092: PO_LOG.stmt (d_module, d_position, 'in progress catalog upload');

1088:
1089: IF (l_upload_in_progress = FND_API.G_TRUE) THEN
1090: IF (l_upload_status_code IN (g_upload_status_PENDING, g_upload_status_RUNNING)) THEN
1091: IF (PO_LOG.d_stmt) THEN
1092: PO_LOG.stmt (d_module, d_position, 'in progress catalog upload');
1093: END IF;
1094:
1095: x_message := 'PO_UPLOAD_PENDING_RUNNING';
1096: x_update_allowed := FND_API.G_FALSE;

Line 1099: IF (PO_LOG.d_stmt) THEN

1095: x_message := 'PO_UPLOAD_PENDING_RUNNING';
1096: x_update_allowed := FND_API.G_FALSE;
1097: RETURN;
1098: ELSIF (l_upload_status_code = g_upload_status_ERROR) THEN
1099: IF (PO_LOG.d_stmt) THEN
1100: PO_LOG.stmt (d_module, d_position, 'errored catalog upload');
1101: END IF;
1102:
1103: x_message := 'PO_UPLOAD_ERROR';

Line 1100: PO_LOG.stmt (d_module, d_position, 'errored catalog upload');

1096: x_update_allowed := FND_API.G_FALSE;
1097: RETURN;
1098: ELSIF (l_upload_status_code = g_upload_status_ERROR) THEN
1099: IF (PO_LOG.d_stmt) THEN
1100: PO_LOG.stmt (d_module, d_position, 'errored catalog upload');
1101: END IF;
1102:
1103: x_message := 'PO_UPLOAD_ERROR';
1104: --If buyer is making changes and upload had errors and

Line 1124: IF (PO_LOG.d_stmt) THEN

1120: p_role => p_role
1121: );
1122:
1123: IF (x_locking_applicable = FND_API.G_FALSE) THEN
1124: IF (PO_LOG.d_stmt) THEN
1125: PO_LOG.stmt (d_module, d_position, 'locking is not applicable');
1126: END IF;
1127:
1128: -- if locking is not applicable, then we are done with the checks.

Line 1125: PO_LOG.stmt (d_module, d_position, 'locking is not applicable');

1121: );
1122:
1123: IF (x_locking_applicable = FND_API.G_FALSE) THEN
1124: IF (PO_LOG.d_stmt) THEN
1125: PO_LOG.stmt (d_module, d_position, 'locking is not applicable');
1126: END IF;
1127:
1128: -- if locking is not applicable, then we are done with the checks.
1129: -- simply return

Line 1177: IF (PO_LOG.d_stmt) THEN

1173: -- document is not in INCOMPLETE or APPROVED status
1174: IF ( p_role <> PO_GLOBAL.g_role_BUYER AND
1175: l_authorization_status NOT IN ('INCOMPLETE', 'APPROVED')) THEN
1176:
1177: IF (PO_LOG.d_stmt) THEN
1178: PO_LOG.stmt (d_module, d_position, 'auth status = ' ||
1179: l_authorization_status || '. This role cannot update the document ' ||
1180: 'in this status');
1181: END IF;

Line 1178: PO_LOG.stmt (d_module, d_position, 'auth status = ' ||

1174: IF ( p_role <> PO_GLOBAL.g_role_BUYER AND
1175: l_authorization_status NOT IN ('INCOMPLETE', 'APPROVED')) THEN
1176:
1177: IF (PO_LOG.d_stmt) THEN
1178: PO_LOG.stmt (d_module, d_position, 'auth status = ' ||
1179: l_authorization_status || '. This role cannot update the document ' ||
1180: 'in this status');
1181: END IF;
1182:

Line 1213: IF (PO_LOG.d_stmt) THEN

1209: x_lock_owner_role => l_current_lock_owner_role,
1210: x_lock_owner_user_id => l_current_lock_owner_id
1211: );
1212:
1213: IF (PO_LOG.d_stmt) THEN
1214: PO_LOG.stmt (d_module, d_position, 'lock owner role', l_current_lock_owner_role);
1215: PO_LOG.stmt (d_module, d_position, 'lock owner user id', l_current_lock_owner_id);
1216: END IF;
1217:

Line 1214: PO_LOG.stmt (d_module, d_position, 'lock owner role', l_current_lock_owner_role);

1210: x_lock_owner_user_id => l_current_lock_owner_id
1211: );
1212:
1213: IF (PO_LOG.d_stmt) THEN
1214: PO_LOG.stmt (d_module, d_position, 'lock owner role', l_current_lock_owner_role);
1215: PO_LOG.stmt (d_module, d_position, 'lock owner user id', l_current_lock_owner_id);
1216: END IF;
1217:
1218: IF ( l_calling_module in (g_call_mod_HTML_UI,g_call_mod_FORMS_PO_SUMMARY)) THEN --

Line 1215: PO_LOG.stmt (d_module, d_position, 'lock owner user id', l_current_lock_owner_id);

1211: );
1212:
1213: IF (PO_LOG.d_stmt) THEN
1214: PO_LOG.stmt (d_module, d_position, 'lock owner role', l_current_lock_owner_role);
1215: PO_LOG.stmt (d_module, d_position, 'lock owner user id', l_current_lock_owner_id);
1216: END IF;
1217:
1218: IF ( l_calling_module in (g_call_mod_HTML_UI,g_call_mod_FORMS_PO_SUMMARY)) THEN --
1219:

Line 1275: IF (PO_LOG.d_proc) THEN

1271: END IF;
1272:
1273: END IF;
1274:
1275: IF (PO_LOG.d_proc) THEN
1276: PO_LOG.proc_end(d_module);
1277: END IF;
1278:
1279: EXCEPTION

Line 1276: PO_LOG.proc_end(d_module);

1272:
1273: END IF;
1274:
1275: IF (PO_LOG.d_proc) THEN
1276: PO_LOG.proc_end(d_module);
1277: END IF;
1278:
1279: EXCEPTION
1280: WHEN OTHERS THEN

Line 1411: IF (PO_LOG.d_proc) THEN

1407:
1408: BEGIN
1409:
1410: d_position := 0;
1411: IF (PO_LOG.d_proc) THEN
1412: PO_LOG.proc_begin(d_module);
1413: END IF;
1414:
1415: find_draft

Line 1412: PO_LOG.proc_begin(d_module);

1408: BEGIN
1409:
1410: d_position := 0;
1411: IF (PO_LOG.d_proc) THEN
1412: PO_LOG.proc_begin(d_module);
1413: END IF;
1414:
1415: find_draft
1416: ( p_po_header_id => p_po_header_id,

Line 1425: IF (PO_LOG.d_stmt) THEN

1421:
1422: IF ( l_draft_id IS NOT NULL ) THEN
1423: d_position := 10;
1424:
1425: IF (PO_LOG.d_stmt) THEN
1426: PO_LOG.stmt(d_module, d_position, 'need to remove draft changes');
1427: END IF;
1428:
1429: PO_DRAFTS_PVT.remove_draft_changes

Line 1426: PO_LOG.stmt(d_module, d_position, 'need to remove draft changes');

1422: IF ( l_draft_id IS NOT NULL ) THEN
1423: d_position := 10;
1424:
1425: IF (PO_LOG.d_stmt) THEN
1426: PO_LOG.stmt(d_module, d_position, 'need to remove draft changes');
1427: END IF;
1428:
1429: PO_DRAFTS_PVT.remove_draft_changes
1430: ( p_draft_id => l_draft_id,

Line 1447: IF (PO_LOG.d_proc) THEN

1443: p_role => NULL,
1444: p_role_user_id => NULL
1445: );
1446:
1447: IF (PO_LOG.d_proc) THEN
1448: PO_LOG.proc_end(d_module);
1449: END IF;
1450:
1451: END unlock_document;

Line 1448: PO_LOG.proc_end(d_module);

1444: p_role_user_id => NULL
1445: );
1446:
1447: IF (PO_LOG.d_proc) THEN
1448: PO_LOG.proc_end(d_module);
1449: END IF;
1450:
1451: END unlock_document;
1452:

Line 1491: IF (PO_LOG.d_proc) THEN

1487: l_locking_applicable VARCHAR2(1);
1488: BEGIN
1489:
1490: d_position := 0;
1491: IF (PO_LOG.d_proc) THEN
1492: PO_LOG.proc_begin(d_module);
1493: END IF;
1494:
1495: l_locking_applicable := is_locking_applicable

Line 1492: PO_LOG.proc_begin(d_module);

1488: BEGIN
1489:
1490: d_position := 0;
1491: IF (PO_LOG.d_proc) THEN
1492: PO_LOG.proc_begin(d_module);
1493: END IF;
1494:
1495: l_locking_applicable := is_locking_applicable
1496: ( p_po_header_id => p_po_header_id,

Line 1517: IF (PO_LOG.d_proc) THEN

1513: p_role => p_role,
1514: p_role_user_id => p_role_user_id
1515: );
1516:
1517: IF (PO_LOG.d_proc) THEN
1518: PO_LOG.proc_end(d_module);
1519: END IF;
1520: END lock_document;
1521:

Line 1518: PO_LOG.proc_end(d_module);

1514: p_role_user_id => p_role_user_id
1515: );
1516:
1517: IF (PO_LOG.d_proc) THEN
1518: PO_LOG.proc_end(d_module);
1519: END IF;
1520: END lock_document;
1521:
1522:

Line 1555: IF (PO_LOG.d_proc) THEN

1551:
1552: BEGIN
1553:
1554: d_position := 0;
1555: IF (PO_LOG.d_proc) THEN
1556: PO_LOG.proc_begin(d_module);
1557: END IF;
1558:
1559: -- SQL What: Get several columns from PO tables

Line 1556: PO_LOG.proc_begin(d_module);

1552: BEGIN
1553:
1554: d_position := 0;
1555: IF (PO_LOG.d_proc) THEN
1556: PO_LOG.proc_begin(d_module);
1557: END IF;
1558:
1559: -- SQL What: Get several columns from PO tables
1560: -- SQL Why: Need all these columns to determine whether locking

Line 1585: IF (PO_LOG.d_proc) THEN

1581:
1582: l_applicable := FND_API.G_FALSE;
1583: END IF;
1584:
1585: IF (PO_LOG.d_proc) THEN
1586: PO_LOG.proc_end(d_module, 'l_applicable', l_applicable);
1587: END IF;
1588:
1589: RETURN l_applicable;

Line 1586: PO_LOG.proc_end(d_module, 'l_applicable', l_applicable);

1582: l_applicable := FND_API.G_FALSE;
1583: END IF;
1584:
1585: IF (PO_LOG.d_proc) THEN
1586: PO_LOG.proc_end(d_module, 'l_applicable', l_applicable);
1587: END IF;
1588:
1589: RETURN l_applicable;
1590:

Line 1626: IF (PO_LOG.d_proc) THEN

1622: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1623: BEGIN
1624: d_position := 0;
1625:
1626: IF (PO_LOG.d_proc) THEN
1627: PO_LOG.proc_begin(d_module);
1628: END IF;
1629:
1630: -- SQL What: Get several columns from PO tables

Line 1627: PO_LOG.proc_begin(d_module);

1623: BEGIN
1624: d_position := 0;
1625:
1626: IF (PO_LOG.d_proc) THEN
1627: PO_LOG.proc_begin(d_module);
1628: END IF;
1629:
1630: -- SQL What: Get several columns from PO tables
1631: -- SQL Why: Need all these columns to determine whether locking

Line 1652: IF (PO_LOG.d_proc) THEN

1648:
1649: l_applicable := FND_API.G_FALSE;
1650: END IF;
1651:
1652: IF (PO_LOG.d_proc) THEN
1653: PO_LOG.proc_end(d_module, 'l_applicable', l_applicable);
1654: END IF;
1655:
1656: RETURN l_applicable;

Line 1653: PO_LOG.proc_end(d_module, 'l_applicable', l_applicable);

1649: l_applicable := FND_API.G_FALSE;
1650: END IF;
1651:
1652: IF (PO_LOG.d_proc) THEN
1653: PO_LOG.proc_end(d_module, 'l_applicable', l_applicable);
1654: END IF;
1655:
1656: RETURN l_applicable;
1657:

Line 1710: IF (PO_LOG.d_proc) THEN

1706:
1707: BEGIN
1708:
1709: d_position := 0;
1710: IF (PO_LOG.d_proc) THEN
1711: PO_LOG.proc_begin(d_module);
1712: END IF;
1713:
1714: update_permission_check

Line 1711: PO_LOG.proc_begin(d_module);

1707: BEGIN
1708:
1709: d_position := 0;
1710: IF (PO_LOG.d_proc) THEN
1711: PO_LOG.proc_begin(d_module);
1712: END IF;
1713:
1714: update_permission_check
1715: ( p_calling_module => p_calling_module,

Line 1742: IF (PO_LOG.d_proc) THEN

1738: p_role_user_id => p_role_user_id,
1739: p_unlock_current => l_unlock_required
1740: );
1741:
1742: IF (PO_LOG.d_proc) THEN
1743: PO_LOG.proc_end(d_module);
1744: END IF;
1745: END lock_document_with_validate;
1746:

Line 1743: PO_LOG.proc_end(d_module);

1739: p_unlock_current => l_unlock_required
1740: );
1741:
1742: IF (PO_LOG.d_proc) THEN
1743: PO_LOG.proc_end(d_module);
1744: END IF;
1745: END lock_document_with_validate;
1746:
1747: -----------------------------------------------------------------------

Line 1771: IF (PO_LOG.d_proc) THEN

1767: l_cur_conc_request_id NUMBER := FND_GLOBAL.conc_request_id;
1768: BEGIN
1769:
1770: d_position := 0;
1771: IF (PO_LOG.d_proc) THEN
1772: PO_LOG.proc_begin(d_module);
1773: END IF;
1774:
1775: -- for request id, populate only if the draft is being processed by PDOI

Line 1772: PO_LOG.proc_begin(d_module);

1768: BEGIN
1769:
1770: d_position := 0;
1771: IF (PO_LOG.d_proc) THEN
1772: PO_LOG.proc_begin(d_module);
1773: END IF;
1774:
1775: -- for request id, populate only if the draft is being processed by PDOI
1776: UPDATE po_drafts

Line 1783: IF (PO_LOG.d_proc) THEN

1779: g_status_PDOI_PROCESSING, l_cur_conc_request_id,
1780: NULL)
1781: WHERE draft_id = p_draft_id;
1782:
1783: IF (PO_LOG.d_proc) THEN
1784: PO_LOG.proc_end(d_module);
1785: END IF;
1786:
1787: END update_draft_status;

Line 1784: PO_LOG.proc_end(d_module);

1780: NULL)
1781: WHERE draft_id = p_draft_id;
1782:
1783: IF (PO_LOG.d_proc) THEN
1784: PO_LOG.proc_end(d_module);
1785: END IF;
1786:
1787: END update_draft_status;
1788:

Line 1817: IF (PO_LOG.d_proc) THEN

1813: l_pending_changes_exist VARCHAR2(1) := FND_API.G_FALSE;
1814: BEGIN
1815:
1816: d_position := 0;
1817: IF (PO_LOG.d_proc) THEN
1818: PO_LOG.proc_begin(d_module);
1819: END IF;
1820:
1821: find_draft

Line 1818: PO_LOG.proc_begin(d_module);

1814: BEGIN
1815:
1816: d_position := 0;
1817: IF (PO_LOG.d_proc) THEN
1818: PO_LOG.proc_begin(d_module);
1819: END IF;
1820:
1821: find_draft
1822: ( p_po_header_id => p_po_header_id,

Line 1832: IF (PO_LOG.d_proc) THEN

1828: IF (l_draft_id IS NOT NULL) THEN
1829: l_pending_changes_exist := FND_API.G_TRUE;
1830: END IF;
1831:
1832: IF (PO_LOG.d_proc) THEN
1833: PO_LOG.proc_end(d_module, 'l_pending_changes_exist', l_pending_changes_exist);
1834: END IF;
1835:
1836: RETURN l_pending_changes_exist;

Line 1833: PO_LOG.proc_end(d_module, 'l_pending_changes_exist', l_pending_changes_exist);

1829: l_pending_changes_exist := FND_API.G_TRUE;
1830: END IF;
1831:
1832: IF (PO_LOG.d_proc) THEN
1833: PO_LOG.proc_end(d_module, 'l_pending_changes_exist', l_pending_changes_exist);
1834: END IF;
1835:
1836: RETURN l_pending_changes_exist;
1837:

Line 1872: IF (PO_LOG.d_proc) THEN

1868: BEGIN
1869:
1870: d_position := 0;
1871:
1872: IF (PO_LOG.d_proc) THEN
1873: PO_LOG.proc_begin (d_module);
1874: END IF;
1875:
1876: l_null_id_tbl.EXTEND(p_draft_id_tbl.COUNT);

Line 1873: PO_LOG.proc_begin (d_module);

1869:
1870: d_position := 0;
1871:
1872: IF (PO_LOG.d_proc) THEN
1873: PO_LOG.proc_begin (d_module);
1874: END IF;
1875:
1876: l_null_id_tbl.EXTEND(p_draft_id_tbl.COUNT);
1877: l_master_chg_exist_tbl.EXTEND(p_draft_id_tbl.COUNT);

Line 2001: IF (PO_LOG.d_proc) THEN

1997: l_master_chg_exist_tbl(i) := FND_API.G_TRUE;
1998: END IF;
1999: END LOOP;
2000:
2001: IF (PO_LOG.d_proc) THEN
2002: PO_LOG.proc_end (d_module);
2003: END IF;
2004:
2005: RETURN l_master_chg_exist_tbl;

Line 2002: PO_LOG.proc_end (d_module);

1998: END IF;
1999: END LOOP;
2000:
2001: IF (PO_LOG.d_proc) THEN
2002: PO_LOG.proc_end (d_module);
2003: END IF;
2004:
2005: RETURN l_master_chg_exist_tbl;
2006:

Line 2040: IF (PO_LOG.d_proc) THEN

2036: l_pending_acceptance VARCHAR2(1) := FND_API.G_FALSE;
2037: BEGIN
2038:
2039: d_position := 0;
2040: IF (PO_LOG.d_proc) THEN
2041: PO_LOG.proc_begin(d_module);
2042: END IF;
2043:
2044: find_draft

Line 2041: PO_LOG.proc_begin(d_module);

2037: BEGIN
2038:
2039: d_position := 0;
2040: IF (PO_LOG.d_proc) THEN
2041: PO_LOG.proc_begin(d_module);
2042: END IF;
2043:
2044: find_draft
2045: ( p_po_header_id => p_po_header_id,

Line 2055: IF (PO_LOG.d_proc) THEN

2051: IF (l_draft_status = g_status_IN_PROCESS) THEN
2052: l_pending_acceptance := FND_API.G_TRUE;
2053: END IF;
2054:
2055: IF (PO_LOG.d_proc) THEN
2056: PO_LOG.proc_end(d_module, 'l_pending_acceptance', l_pending_acceptance);
2057: END IF;
2058:
2059: RETURN l_pending_acceptance;

Line 2056: PO_LOG.proc_end(d_module, 'l_pending_acceptance', l_pending_acceptance);

2052: l_pending_acceptance := FND_API.G_TRUE;
2053: END IF;
2054:
2055: IF (PO_LOG.d_proc) THEN
2056: PO_LOG.proc_end(d_module, 'l_pending_acceptance', l_pending_acceptance);
2057: END IF;
2058:
2059: RETURN l_pending_acceptance;
2060:

Line 2103: IF (PO_LOG.d_proc) THEN

2099:
2100: BEGIN
2101:
2102: d_position := 0;
2103: IF (PO_LOG.d_proc) THEN
2104: PO_LOG.proc_begin(d_module);
2105: END IF;
2106:
2107: IF (p_view_name = 'PO_HEADERS_MERGE_V') THEN

Line 2104: PO_LOG.proc_begin(d_module);

2100: BEGIN
2101:
2102: d_position := 0;
2103: IF (PO_LOG.d_proc) THEN
2104: PO_LOG.proc_begin(d_module);
2105: END IF;
2106:
2107: IF (p_view_name = 'PO_HEADERS_MERGE_V') THEN
2108: d_position := 10;

Line 2221: IF (PO_LOG.d_proc) THEN

2217:
2218: RAISE INVALID_VIEW_NAME_EXC;
2219: END IF;
2220:
2221: IF (PO_LOG.d_proc) THEN
2222: PO_LOG.proc_end(d_module);
2223: END IF;
2224:
2225: RETURN FND_API.G_TRUE;

Line 2222: PO_LOG.proc_end(d_module);

2218: RAISE INVALID_VIEW_NAME_EXC;
2219: END IF;
2220:
2221: IF (PO_LOG.d_proc) THEN
2222: PO_LOG.proc_end(d_module);
2223: END IF;
2224:
2225: RETURN FND_API.G_TRUE;
2226:

Line 2234: IF (PO_LOG.d_exc) THEN

2230: l_success := FND_API.G_FALSE;
2231: RETURN FND_API.G_FALSE;
2232:
2233: WHEN INVALID_VIEW_NAME_EXC THEN
2234: IF (PO_LOG.d_exc) THEN
2235: PO_LOG.exc(d_module, d_position, 'Invalid view name');
2236: END IF;
2237:
2238: l_success := FND_API.G_FALSE;

Line 2235: PO_LOG.exc(d_module, d_position, 'Invalid view name');

2231: RETURN FND_API.G_FALSE;
2232:
2233: WHEN INVALID_VIEW_NAME_EXC THEN
2234: IF (PO_LOG.d_exc) THEN
2235: PO_LOG.exc(d_module, d_position, 'Invalid view name');
2236: END IF;
2237:
2238: l_success := FND_API.G_FALSE;
2239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2286: IF (PO_LOG.d_proc) THEN

2282:
2283: BEGIN
2284:
2285: d_position := 0;
2286: IF (PO_LOG.d_proc) THEN
2287: PO_LOG.proc_begin(d_module);
2288: END IF;
2289:
2290: SELECT supplier_auth_enabled_flag

Line 2287: PO_LOG.proc_begin(d_module);

2283: BEGIN
2284:
2285: d_position := 0;
2286: IF (PO_LOG.d_proc) THEN
2287: PO_LOG.proc_begin(d_module);
2288: END IF;
2289:
2290: SELECT supplier_auth_enabled_flag
2291: INTO l_supplier_auth_enabled_flag

Line 2340: IF (PO_LOG.d_proc) THEN

2336:
2337: BEGIN
2338:
2339: d_position := 0;
2340: IF (PO_LOG.d_proc) THEN
2341: PO_LOG.proc_begin(d_module);
2342: END IF;
2343:
2344: UPDATE po_headers_all

Line 2341: PO_LOG.proc_begin(d_module);

2337: BEGIN
2338:
2339: d_position := 0;
2340: IF (PO_LOG.d_proc) THEN
2341: PO_LOG.proc_begin(d_module);
2342: END IF;
2343:
2344: UPDATE po_headers_all
2345: SET supplier_auth_enabled_flag

Line 2392: IF (PO_LOG.d_proc) THEN

2388:
2389: BEGIN
2390:
2391: d_position := 0;
2392: IF (PO_LOG.d_proc) THEN
2393: PO_LOG.proc_begin(d_module);
2394: END IF;
2395:
2396: SELECT cat_admin_auth_enabled_flag

Line 2393: PO_LOG.proc_begin(d_module);

2389: BEGIN
2390:
2391: d_position := 0;
2392: IF (PO_LOG.d_proc) THEN
2393: PO_LOG.proc_begin(d_module);
2394: END IF;
2395:
2396: SELECT cat_admin_auth_enabled_flag
2397: INTO l_cat_admin_auth_enable_flag

Line 2446: IF (PO_LOG.d_proc) THEN

2442:
2443: BEGIN
2444:
2445: d_position := 0;
2446: IF (PO_LOG.d_proc) THEN
2447: PO_LOG.proc_begin(d_module);
2448: END IF;
2449:
2450: UPDATE po_headers_all

Line 2447: PO_LOG.proc_begin(d_module);

2443: BEGIN
2444:
2445: d_position := 0;
2446: IF (PO_LOG.d_proc) THEN
2447: PO_LOG.proc_begin(d_module);
2448: END IF;
2449:
2450: UPDATE po_headers_all
2451: SET cat_admin_auth_enabled_flag

Line 2610: IF (PO_LOG.d_proc) THEN

2606: BEGIN
2607:
2608: d_position := 0;
2609:
2610: IF (PO_LOG.d_proc) THEN
2611: PO_LOG.proc_begin(d_module,'p_commit',p_commit);
2612: PO_LOG.proc_begin(d_module,'p_po_header_id',p_po_header_id);
2613: END IF;
2614:

Line 2611: PO_LOG.proc_begin(d_module,'p_commit',p_commit);

2607:
2608: d_position := 0;
2609:
2610: IF (PO_LOG.d_proc) THEN
2611: PO_LOG.proc_begin(d_module,'p_commit',p_commit);
2612: PO_LOG.proc_begin(d_module,'p_po_header_id',p_po_header_id);
2613: END IF;
2614:
2615: SELECT org_id,

Line 2612: PO_LOG.proc_begin(d_module,'p_po_header_id',p_po_header_id);

2608: d_position := 0;
2609:
2610: IF (PO_LOG.d_proc) THEN
2611: PO_LOG.proc_begin(d_module,'p_commit',p_commit);
2612: PO_LOG.proc_begin(d_module,'p_po_header_id',p_po_header_id);
2613: END IF;
2614:
2615: SELECT org_id,
2616: segment1,

Line 2632: IF (PO_LOG.d_proc) THEN

2628: p_segment1 => l_segment1,
2629: p_revision_num => l_revision_num
2630: );
2631:
2632: IF (PO_LOG.d_proc) THEN
2633: PO_LOG.proc_end(d_module,'p_commit',p_commit);
2634: END IF;
2635:
2636: EXCEPTION

Line 2633: PO_LOG.proc_end(d_module,'p_commit',p_commit);

2629: p_revision_num => l_revision_num
2630: );
2631:
2632: IF (PO_LOG.d_proc) THEN
2633: PO_LOG.proc_end(d_module,'p_commit',p_commit);
2634: END IF;
2635:
2636: EXCEPTION
2637: WHEN OTHERS THEN

Line 2684: d_module CONSTANT VARCHAR2(2000) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

2680: p_segment1 IN VARCHAR2,
2681: p_revision_num IN NUMBER)
2682: IS
2683: d_api_name CONSTANT VARCHAR2(30) := 'unlock_document_and_send_notif';
2684: d_module CONSTANT VARCHAR2(2000) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
2685: d_pos NUMBER := 0;
2686:
2687: l_agreement_info FND_NEW_MESSAGES.message_text%type := NULL;
2688: l_doc_style_name PO_DOC_STYLE_LINES_TL.display_name%type := NULL;

Line 2697: IF (PO_LOG.d_proc) THEN

2693:
2694: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
2695: BEGIN
2696:
2697: IF (PO_LOG.d_proc) THEN
2698: PO_LOG.proc_begin(d_module,'p_commit',p_commit);
2699: PO_LOG.proc_begin(d_module,'p_po_header_id',p_po_header_id);
2700: PO_LOG.proc_begin(d_module,'p_org_id',p_org_id);
2701: PO_LOG.proc_begin(d_module,'p_segment1',p_segment1);

Line 2698: PO_LOG.proc_begin(d_module,'p_commit',p_commit);

2694: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
2695: BEGIN
2696:
2697: IF (PO_LOG.d_proc) THEN
2698: PO_LOG.proc_begin(d_module,'p_commit',p_commit);
2699: PO_LOG.proc_begin(d_module,'p_po_header_id',p_po_header_id);
2700: PO_LOG.proc_begin(d_module,'p_org_id',p_org_id);
2701: PO_LOG.proc_begin(d_module,'p_segment1',p_segment1);
2702: PO_LOG.proc_begin(d_module,'p_revision_num',p_revision_num);

Line 2699: PO_LOG.proc_begin(d_module,'p_po_header_id',p_po_header_id);

2695: BEGIN
2696:
2697: IF (PO_LOG.d_proc) THEN
2698: PO_LOG.proc_begin(d_module,'p_commit',p_commit);
2699: PO_LOG.proc_begin(d_module,'p_po_header_id',p_po_header_id);
2700: PO_LOG.proc_begin(d_module,'p_org_id',p_org_id);
2701: PO_LOG.proc_begin(d_module,'p_segment1',p_segment1);
2702: PO_LOG.proc_begin(d_module,'p_revision_num',p_revision_num);
2703: END IF;

Line 2700: PO_LOG.proc_begin(d_module,'p_org_id',p_org_id);

2696:
2697: IF (PO_LOG.d_proc) THEN
2698: PO_LOG.proc_begin(d_module,'p_commit',p_commit);
2699: PO_LOG.proc_begin(d_module,'p_po_header_id',p_po_header_id);
2700: PO_LOG.proc_begin(d_module,'p_org_id',p_org_id);
2701: PO_LOG.proc_begin(d_module,'p_segment1',p_segment1);
2702: PO_LOG.proc_begin(d_module,'p_revision_num',p_revision_num);
2703: END IF;
2704:

Line 2701: PO_LOG.proc_begin(d_module,'p_segment1',p_segment1);

2697: IF (PO_LOG.d_proc) THEN
2698: PO_LOG.proc_begin(d_module,'p_commit',p_commit);
2699: PO_LOG.proc_begin(d_module,'p_po_header_id',p_po_header_id);
2700: PO_LOG.proc_begin(d_module,'p_org_id',p_org_id);
2701: PO_LOG.proc_begin(d_module,'p_segment1',p_segment1);
2702: PO_LOG.proc_begin(d_module,'p_revision_num',p_revision_num);
2703: END IF;
2704:
2705: -- bug5090429

Line 2702: PO_LOG.proc_begin(d_module,'p_revision_num',p_revision_num);

2698: PO_LOG.proc_begin(d_module,'p_commit',p_commit);
2699: PO_LOG.proc_begin(d_module,'p_po_header_id',p_po_header_id);
2700: PO_LOG.proc_begin(d_module,'p_org_id',p_org_id);
2701: PO_LOG.proc_begin(d_module,'p_segment1',p_segment1);
2702: PO_LOG.proc_begin(d_module,'p_revision_num',p_revision_num);
2703: END IF;
2704:
2705: -- bug5090429
2706: -- Get who is locking the document

Line 2721: IF (PO_LOG.d_stmt) THEN

2717:
2718: d_pos := 10;
2719: --Get Operating Unit Name
2720: l_ou_name := PO_MOAC_UTILS_PVT.get_ou_name(p_org_id);
2721: IF (PO_LOG.d_stmt) THEN
2722: PO_LOG.stmt(d_module,d_pos,'l_ou_name',l_ou_name);
2723: END IF;
2724:
2725: d_pos := 20;

Line 2722: PO_LOG.stmt(d_module,d_pos,'l_ou_name',l_ou_name);

2718: d_pos := 10;
2719: --Get Operating Unit Name
2720: l_ou_name := PO_MOAC_UTILS_PVT.get_ou_name(p_org_id);
2721: IF (PO_LOG.d_stmt) THEN
2722: PO_LOG.stmt(d_module,d_pos,'l_ou_name',l_ou_name);
2723: END IF;
2724:
2725: d_pos := 20;
2726: --Get the Agreement's Title as we get by calling getTitle of HTML page's controller

Line 2736: IF (PO_LOG.d_stmt) THEN

2732: END IF;
2733:
2734: d_pos := 30;
2735: l_doc_style_name := PO_DOC_STYLE_PVT.get_style_display_name(p_po_header_id);
2736: IF (PO_LOG.d_stmt) THEN
2737: PO_LOG.stmt(d_module,d_pos,'l_doc_style_name',l_doc_style_name);
2738: END IF;
2739:
2740: d_pos := 40;

Line 2737: PO_LOG.stmt(d_module,d_pos,'l_doc_style_name',l_doc_style_name);

2733:
2734: d_pos := 30;
2735: l_doc_style_name := PO_DOC_STYLE_PVT.get_style_display_name(p_po_header_id);
2736: IF (PO_LOG.d_stmt) THEN
2737: PO_LOG.stmt(d_module,d_pos,'l_doc_style_name',l_doc_style_name);
2738: END IF;
2739:
2740: d_pos := 40;
2741: fnd_message.set_token('PONUM', p_segment1);

Line 2744: IF (PO_LOG.d_stmt) THEN

2740: d_pos := 40;
2741: fnd_message.set_token('PONUM', p_segment1);
2742: fnd_message.set_token('DOCSTYLE', l_doc_style_name);
2743: l_agreement_info := fnd_message.get;
2744: IF (PO_LOG.d_stmt) THEN
2745: PO_LOG.stmt(d_module,d_pos,'l_agreement_info',l_agreement_info);
2746: END IF;
2747:
2748: d_pos := 50;

Line 2745: PO_LOG.stmt(d_module,d_pos,'l_agreement_info',l_agreement_info);

2741: fnd_message.set_token('PONUM', p_segment1);
2742: fnd_message.set_token('DOCSTYLE', l_doc_style_name);
2743: l_agreement_info := fnd_message.get;
2744: IF (PO_LOG.d_stmt) THEN
2745: PO_LOG.stmt(d_module,d_pos,'l_agreement_info',l_agreement_info);
2746: END IF;
2747:
2748: d_pos := 50;
2749: --Send the notification

Line 2774: IF (PO_LOG.d_proc) THEN

2770: IF p_commit = FND_API.G_TRUE THEN
2771: COMMIT WORK;
2772: END IF;
2773:
2774: IF (PO_LOG.d_proc) THEN
2775: PO_LOG.proc_end(d_module);
2776: END IF;
2777: EXCEPTION
2778: WHEN OTHERS THEN

Line 2775: PO_LOG.proc_end(d_module);

2771: COMMIT WORK;
2772: END IF;
2773:
2774: IF (PO_LOG.d_proc) THEN
2775: PO_LOG.proc_end(d_module);
2776: END IF;
2777: EXCEPTION
2778: WHEN OTHERS THEN
2779: PO_MESSAGE_S.add_exc_msg

Line 2820: IF (PO_LOG.d_proc) THEN

2816:
2817: BEGIN
2818:
2819: d_position := 0;
2820: IF (PO_LOG.d_proc) THEN
2821: PO_LOG.proc_begin(d_module);
2822: END IF;
2823:
2824: IF (p_role IN (PO_GLOBAL.g_role_SUPPLIER,

Line 2821: PO_LOG.proc_begin(d_module);

2817: BEGIN
2818:
2819: d_position := 0;
2820: IF (PO_LOG.d_proc) THEN
2821: PO_LOG.proc_begin(d_module);
2822: END IF;
2823:
2824: IF (p_role IN (PO_GLOBAL.g_role_SUPPLIER,
2825: PO_GLOBAL.g_role_CAT_ADMIN)) THEN

Line 2841: IF (PO_LOG.d_proc) THEN

2837: ELSE
2838: RETURN FND_API.G_TRUE;
2839: END IF;
2840:
2841: IF (PO_LOG.d_proc) THEN
2842: PO_LOG.proc_end(d_module);
2843: END IF;
2844: EXCEPTION
2845: WHEN NO_DATA_FOUND THEN

Line 2842: PO_LOG.proc_end(d_module);

2838: RETURN FND_API.G_TRUE;
2839: END IF;
2840:
2841: IF (PO_LOG.d_proc) THEN
2842: PO_LOG.proc_end(d_module);
2843: END IF;
2844: EXCEPTION
2845: WHEN NO_DATA_FOUND THEN
2846: RETURN FND_API.G_FALSE;

Line 2879: IF (PO_LOG.d_proc) THEN

2875: d_position NUMBER;
2876:
2877: BEGIN
2878: d_position := 0;
2879: IF (PO_LOG.d_proc) THEN
2880: PO_LOG.proc_begin(d_module);
2881: END IF;
2882:
2883: PO_HEADERS_DRAFT_PVT.apply_changes

Line 2880: PO_LOG.proc_begin(d_module);

2876:
2877: BEGIN
2878: d_position := 0;
2879: IF (PO_LOG.d_proc) THEN
2880: PO_LOG.proc_begin(d_module);
2881: END IF;
2882:
2883: PO_HEADERS_DRAFT_PVT.apply_changes
2884: (p_draft_info => p_draft_info

Line 2928: IF (PO_LOG.d_proc) THEN

2924: (p_draft_info => p_draft_info
2925: );
2926:
2927: d_position := 90;
2928: IF (PO_LOG.d_proc) THEN
2929: PO_LOG.proc_end(d_module);
2930: END IF;
2931: EXCEPTION
2932: WHEN OTHERS THEN

Line 2929: PO_LOG.proc_end(d_module);

2925: );
2926:
2927: d_position := 90;
2928: IF (PO_LOG.d_proc) THEN
2929: PO_LOG.proc_end(d_module);
2930: END IF;
2931: EXCEPTION
2932: WHEN OTHERS THEN
2933: PO_MESSAGE_S.add_exc_msg

Line 2980: IF (PO_LOG.d_proc) THEN

2976: l_message VARCHAR2(2000);
2977:
2978: BEGIN
2979: d_position := 0;
2980: IF (PO_LOG.d_proc) THEN
2981: PO_LOG.proc_begin(d_module);
2982: END IF;
2983:
2984: IF (p_draft_info.new_document = FND_API.G_TRUE) THEN

Line 2981: PO_LOG.proc_begin(d_module);

2977:
2978: BEGIN
2979: d_position := 0;
2980: IF (PO_LOG.d_proc) THEN
2981: PO_LOG.proc_begin(d_module);
2982: END IF;
2983:
2984: IF (p_draft_info.new_document = FND_API.G_TRUE) THEN
2985: RETURN;

Line 3067: IF (PO_LOG.d_proc) THEN

3063: END IF;
3064: END LOOP;
3065:
3066: d_position := 100;
3067: IF (PO_LOG.d_proc) THEN
3068: PO_LOG.proc_end(d_module);
3069: END IF;
3070: EXCEPTION
3071: WHEN OTHERS THEN

Line 3068: PO_LOG.proc_end(d_module);

3064: END LOOP;
3065:
3066: d_position := 100;
3067: IF (PO_LOG.d_proc) THEN
3068: PO_LOG.proc_end(d_module);
3069: END IF;
3070: EXCEPTION
3071: WHEN OTHERS THEN
3072: PO_MESSAGE_S.add_exc_msg

Line 3118: IF (PO_LOG.d_proc) THEN

3114: l_exclude_ctrl_tbl VARCHAR2(1);
3115:
3116: BEGIN
3117: d_position := 0;
3118: IF (PO_LOG.d_proc) THEN
3119: PO_LOG.proc_begin(d_module);
3120: END IF;
3121:
3122: -- delete_draft = 'X' means that the PO_DRAFTS table should be

Line 3119: PO_LOG.proc_begin(d_module);

3115:
3116: BEGIN
3117: d_position := 0;
3118: IF (PO_LOG.d_proc) THEN
3119: PO_LOG.proc_begin(d_module);
3120: END IF;
3121:
3122: -- delete_draft = 'X' means that the PO_DRAFTS table should be
3123: -- excluded from deletion. We should just mark it as 'COMPLETED'

Line 3159: IF (PO_LOG.d_proc) THEN

3155: END IF;
3156: END IF;
3157:
3158: d_position := 30;
3159: IF (PO_LOG.d_proc) THEN
3160: PO_LOG.proc_end(d_module);
3161: END IF;
3162: EXCEPTION
3163: WHEN OTHERS THEN

Line 3160: PO_LOG.proc_end(d_module);

3156: END IF;
3157:
3158: d_position := 30;
3159: IF (PO_LOG.d_proc) THEN
3160: PO_LOG.proc_end(d_module);
3161: END IF;
3162: EXCEPTION
3163: WHEN OTHERS THEN
3164: PO_MESSAGE_S.add_exc_msg

Line 3210: IF (PO_LOG.d_proc) THEN

3206:
3207: BEGIN
3208:
3209: d_position := 0;
3210: IF (PO_LOG.d_proc) THEN
3211: PO_LOG.proc_begin(d_module);
3212: END IF;
3213:
3214: IF (p_acceptance_action = g_ACCEPT_ALL) THEN

Line 3211: PO_LOG.proc_begin(d_module);

3207: BEGIN
3208:
3209: d_position := 0;
3210: IF (PO_LOG.d_proc) THEN
3211: PO_LOG.proc_begin(d_module);
3212: END IF;
3213:
3214: IF (p_acceptance_action = g_ACCEPT_ALL) THEN
3215: l_change_accepted_flag := 'Y';

Line 3280: IF (PO_LOG.d_proc) THEN

3276:
3277:
3278: END IF;
3279:
3280: IF (PO_LOG.d_proc) THEN
3281: PO_LOG.proc_end(d_module);
3282: END IF;
3283:
3284: EXCEPTION

Line 3281: PO_LOG.proc_end(d_module);

3277:
3278: END IF;
3279:
3280: IF (PO_LOG.d_proc) THEN
3281: PO_LOG.proc_end(d_module);
3282: END IF;
3283:
3284: EXCEPTION
3285: WHEN OTHERS THEN