DBA Data[Home] [Help]

APPS.PO_APPROVED_SUPPLIER_LIST_SV dependencies on PO_DEBUG

Line 150: PO_DEBUG.put_line('Create PO ASL Entry for item: '||x_item_id||

146:
147: --
148:
149: IF (g_po_pdoi_write_to_file = 'Y') THEN
150: PO_DEBUG.put_line('Create PO ASL Entry for item: '||x_item_id||
151: ' vendor site id: '||x_vendor_site_id||
152: ' inv org: '||x_owning_organization_id);
153: END IF;
154:

Line 186: PO_DEBUG.put_line('Cannot create ASL entry. Purchasable: '

182: -- OR x_osp_flag = 'Y'
183: THEN
184: --< Bug 3560121 Start >
185: IF (g_po_pdoi_write_to_file = 'Y') THEN
186: PO_DEBUG.put_line('Cannot create ASL entry. Purchasable: '
187: ||x_purchasing_flag||' OSP item: '
188: ||x_osp_flag||'. Insert warning msg');
189: END IF;
190: PO_INTERFACE_ERRORS_SV1.handle_interface_errors

Line 228: PO_DEBUG.put_line('Cannot create ASL entry; item not defined in inv org. Insert warning msg');

224: --< Bug 3560121 Start > Should only catch NO_DATA_FOUND here. Also, need
225: -- to insert a warning message in this case.
226: WHEN NO_DATA_FOUND THEN
227: IF (g_po_pdoi_write_to_file = 'Y') THEN
228: PO_DEBUG.put_line('Cannot create ASL entry; item not defined in inv org. Insert warning msg');
229: END IF;
230: PO_INTERFACE_ERRORS_SV1.handle_interface_errors
231: ( x_interface_type => 'PO_DOCS_OPEN_INTERFACE'
232: , x_error_type => 'WARNING'

Line 275: PO_DEBUG.put_line('** ERROR: Please specify a default status in the ASL');

271: --
272: EXCEPTION
273: WHEN NO_DATA_FOUND THEN
274: IF (g_po_pdoi_write_to_file = 'Y') THEN
275: PO_DEBUG.put_line('** ERROR: Please specify a default status in the ASL');
276: PO_DEBUG.put_line('** Statuses form before proceeding with this.');
277: END IF;
278: X_process_flag := 'N';
279: po_interface_errors_sv1.handle_interface_errors(

Line 276: PO_DEBUG.put_line('** Statuses form before proceeding with this.');

272: EXCEPTION
273: WHEN NO_DATA_FOUND THEN
274: IF (g_po_pdoi_write_to_file = 'Y') THEN
275: PO_DEBUG.put_line('** ERROR: Please specify a default status in the ASL');
276: PO_DEBUG.put_line('** Statuses form before proceeding with this.');
277: END IF;
278: X_process_flag := 'N';
279: po_interface_errors_sv1.handle_interface_errors(
280: X_po_interface_error_code,

Line 366: PO_DEBUG.put_line('Creating Record in Po approved Supplier List');

362: INTO x_asl_id
363: FROM SYS.DUAL;
364:
365: IF (g_po_pdoi_write_to_file = 'Y') THEN
366: PO_DEBUG.put_line('Creating Record in Po approved Supplier List');
367: END IF;
368: --
369: INSERT INTO PO_APPROVED_SUPPLIER_LIST (
370: asl_id ,

Line 455: PO_DEBUG.put_line('Creating Record in Po Asl Attribbutes ');

451:
452: --
453:
454: IF (g_po_pdoi_write_to_file = 'Y') THEN
455: PO_DEBUG.put_line('Creating Record in Po Asl Attribbutes ');
456: END IF;
457:
458: -- create global ASL in po_asl_documents
459:

Line 522: PO_DEBUG.put_line('ASL exists for Vndr' || to_char(x_vendor_id));

518: ELSE --Record Not Unique
519: -- If supplier-item relation exists, return asl_id for this asl entry.
520: --
521: IF (g_po_pdoi_write_to_file = 'Y') THEN
522: PO_DEBUG.put_line('ASL exists for Vndr' || to_char(x_vendor_id));
523: PO_DEBUG.put_line('ASL exists for VndrSite' || to_char(x_vendor_site_id));
524: PO_DEBUG.put_line('ASL already exists for Item' || to_char(x_item_id));
525: END IF;
526: --

Line 523: PO_DEBUG.put_line('ASL exists for VndrSite' || to_char(x_vendor_site_id));

519: -- If supplier-item relation exists, return asl_id for this asl entry.
520: --
521: IF (g_po_pdoi_write_to_file = 'Y') THEN
522: PO_DEBUG.put_line('ASL exists for Vndr' || to_char(x_vendor_id));
523: PO_DEBUG.put_line('ASL exists for VndrSite' || to_char(x_vendor_site_id));
524: PO_DEBUG.put_line('ASL already exists for Item' || to_char(x_item_id));
525: END IF;
526: --
527: /* BUG No.1541387:For the case when the sourcing rule is purged and the

Line 524: PO_DEBUG.put_line('ASL already exists for Item' || to_char(x_item_id));

520: --
521: IF (g_po_pdoi_write_to_file = 'Y') THEN
522: PO_DEBUG.put_line('ASL exists for Vndr' || to_char(x_vendor_id));
523: PO_DEBUG.put_line('ASL exists for VndrSite' || to_char(x_vendor_site_id));
524: PO_DEBUG.put_line('ASL already exists for Item' || to_char(x_item_id));
525: END IF;
526: --
527: /* BUG No.1541387:For the case when the sourcing rule is purged and the
528: corresponding ASL consists of no supplier_site_code -

Line 620: PO_DEBUG.put_line('Doc already exists for this ASL');

616:
617: IF (NVL(x_date , sysdate+1) >= SYSDATE) THEN ---10192008
618:
619: IF (g_po_pdoi_write_to_file = 'Y') THEN
620: PO_DEBUG.put_line('Doc already exists for this ASL');
621: END IF;
622: null;
623:
624: ELSE

Line 636: PO_DEBUG.put_line('Updating the expired line on this ASL');

632: AND document_header_id = x_po_header_id;
633:
634:
635: IF (g_po_pdoi_write_to_file = 'Y') THEN
636: PO_DEBUG.put_line('Updating the expired line on this ASL');
637: END IF;
638:
639: END IF;
640:

Line 652: PO_DEBUG.put_line('Creating record in Po Asl Docs');

648: WHERE asl_id = x_asl_id
649: AND using_organization_id = l_using_organization_id; --
650: --
651: IF (g_po_pdoi_write_to_file = 'Y') THEN
652: PO_DEBUG.put_line('Creating record in Po Asl Docs');
653: END IF;
654: --
655: -- Insert doc into po_asl_documents
656: --

Line 694: PO_DEBUG.put_line('Exception caught while creating ASL entries.');

690: ROLLBACK TO create_po_asl_entries_SP; --
691: x_header_processable_flag := 'N'; -- Bug 2692597
692: --< Bug 3560121 Start >
693: IF (g_po_pdoi_write_to_file = 'Y') THEN
694: PO_DEBUG.put_line('Exception caught while creating ASL entries.');
695: END IF;
696: --< Bug 3560121 End >
697: po_message_s.sql_error('create_po_asl_entries', x_progress, sqlcode);
698: raise;