DBA Data[Home] [Help]

APPS.PO_APPROVED_SUPPLIER_LIST_SV dependencies on PO_DEBUG

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

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

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

171: --Introducing the NVL around purchasing org
172: IF nvl(x_purchasing_flag, 'N') = 'N' OR x_osp_flag = 'Y' THEN
173: --< Bug 3560121 Start >
174: IF (g_po_pdoi_write_to_file = 'Y') THEN
175: PO_DEBUG.put_line('Cannot create ASL entry. Purchasable: '
176: ||x_purchasing_flag||' OSP item: '
177: ||x_osp_flag||'. Insert warning msg');
178: END IF;
179: PO_INTERFACE_ERRORS_SV1.handle_interface_errors

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

213: --< Bug 3560121 Start > Should only catch NO_DATA_FOUND here. Also, need
214: -- to insert a warning message in this case.
215: WHEN NO_DATA_FOUND THEN
216: IF (g_po_pdoi_write_to_file = 'Y') THEN
217: PO_DEBUG.put_line('Cannot create ASL entry; item not defined in inv org. Insert warning msg');
218: END IF;
219: PO_INTERFACE_ERRORS_SV1.handle_interface_errors
220: ( x_interface_type => 'PO_DOCS_OPEN_INTERFACE'
221: , x_error_type => 'WARNING'

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

260: --
261: EXCEPTION
262: WHEN NO_DATA_FOUND THEN
263: IF (g_po_pdoi_write_to_file = 'Y') THEN
264: PO_DEBUG.put_line('** ERROR: Please specify a default status in the ASL');
265: PO_DEBUG.put_line('** Statuses form before proceeding with this.');
266: END IF;
267: X_process_flag := 'N';
268: po_interface_errors_sv1.handle_interface_errors(

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

261: EXCEPTION
262: WHEN NO_DATA_FOUND THEN
263: IF (g_po_pdoi_write_to_file = 'Y') THEN
264: PO_DEBUG.put_line('** ERROR: Please specify a default status in the ASL');
265: PO_DEBUG.put_line('** Statuses form before proceeding with this.');
266: END IF;
267: X_process_flag := 'N';
268: po_interface_errors_sv1.handle_interface_errors(
269: X_po_interface_error_code,

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

351: INTO x_asl_id
352: FROM SYS.DUAL;
353:
354: IF (g_po_pdoi_write_to_file = 'Y') THEN
355: PO_DEBUG.put_line('Creating Record in Po approved Supplier List');
356: END IF;
357: --
358: INSERT INTO PO_APPROVED_SUPPLIER_LIST (
359: asl_id ,

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

440:
441: --
442:
443: IF (g_po_pdoi_write_to_file = 'Y') THEN
444: PO_DEBUG.put_line('Creating Record in Po Asl Attribbutes ');
445: END IF;
446:
447: -- create global ASL in po_asl_documents
448:

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

507: ELSE --Record Not Unique
508: -- If supplier-item relation exists, return asl_id for this asl entry.
509: --
510: IF (g_po_pdoi_write_to_file = 'Y') THEN
511: PO_DEBUG.put_line('ASL exists for Vndr' || to_char(x_vendor_id));
512: PO_DEBUG.put_line('ASL exists for VndrSite' || to_char(x_vendor_site_id));
513: PO_DEBUG.put_line('ASL already exists for Item' || to_char(x_item_id));
514: END IF;
515: --

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

508: -- If supplier-item relation exists, return asl_id for this asl entry.
509: --
510: IF (g_po_pdoi_write_to_file = 'Y') THEN
511: PO_DEBUG.put_line('ASL exists for Vndr' || to_char(x_vendor_id));
512: PO_DEBUG.put_line('ASL exists for VndrSite' || to_char(x_vendor_site_id));
513: PO_DEBUG.put_line('ASL already exists for Item' || to_char(x_item_id));
514: END IF;
515: --
516: /* BUG No.1541387:For the case when the sourcing rule is purged and the

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

509: --
510: IF (g_po_pdoi_write_to_file = 'Y') THEN
511: PO_DEBUG.put_line('ASL exists for Vndr' || to_char(x_vendor_id));
512: PO_DEBUG.put_line('ASL exists for VndrSite' || to_char(x_vendor_site_id));
513: PO_DEBUG.put_line('ASL already exists for Item' || to_char(x_item_id));
514: END IF;
515: --
516: /* BUG No.1541387:For the case when the sourcing rule is purged and the
517: corresponding ASL consists of no supplier_site_code -

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

587: AND document_type_code = x_type_lookup_code;
588:
589: IF x_dummy_count > 0 THEN
590: IF (g_po_pdoi_write_to_file = 'Y') THEN
591: PO_DEBUG.put_line('Doc already exists for this ASL');
592: END IF;
593: null;
594: ELSE
595: --

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

599: WHERE asl_id = x_asl_id
600: AND using_organization_id = l_using_organization_id; --
601: --
602: IF (g_po_pdoi_write_to_file = 'Y') THEN
603: PO_DEBUG.put_line('Creating record in Po Asl Docs');
604: END IF;
605: --
606: -- Insert doc into po_asl_documents
607: --

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

641: ROLLBACK TO create_po_asl_entries_SP; --
642: x_header_processable_flag := 'N'; -- Bug 2692597
643: --< Bug 3560121 Start >
644: IF (g_po_pdoi_write_to_file = 'Y') THEN
645: PO_DEBUG.put_line('Exception caught while creating ASL entries.');
646: END IF;
647: --< Bug 3560121 End >
648: po_message_s.sql_error('create_po_asl_entries', x_progress, sqlcode);
649: raise;