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

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

1: PACKAGE BODY PO_PDOI_ATTR_PROCESS_PVT AS
2: /* $Header: PO_PDOI_ATTR_PROCESS_PVT.plb 120.18 2011/12/01 12:24:16 sbontala ship $ */
3:
4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_PDOI_ATTR_PROCESS_PVT');
6:
7: --------------------------------------------------------------------------
8: ---------------------- PRIVATE PROCEDURES PROTOTYPE ----------------------
9: --------------------------------------------------------------------------

Line 50: IF (PO_LOG.d_proc) THEN

46:
47: BEGIN
48: d_position := 0;
49:
50: IF (PO_LOG.d_proc) THEN
51: PO_LOG.proc_begin(d_module, 'p_max_intf_attr_values_id',
52: p_max_intf_attr_values_id);
53: END IF;
54:

Line 51: PO_LOG.proc_begin(d_module, 'p_max_intf_attr_values_id',

47: BEGIN
48: d_position := 0;
49:
50: IF (PO_LOG.d_proc) THEN
51: PO_LOG.proc_begin(d_module, 'p_max_intf_attr_values_id',
52: p_max_intf_attr_values_id);
53: END IF;
54:
55: OPEN x_attr_values_csr FOR

Line 86: IF (PO_LOG.d_proc) THEN

82: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
83: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
84: ORDER BY intf_attrs.interface_attr_values_id;
85:
86: IF (PO_LOG.d_proc) THEN
87: PO_LOG.proc_end (d_module);
88: END IF;
89:
90: EXCEPTION

Line 87: PO_LOG.proc_end (d_module);

83: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
84: ORDER BY intf_attrs.interface_attr_values_id;
85:
86: IF (PO_LOG.d_proc) THEN
87: PO_LOG.proc_end (d_module);
88: END IF;
89:
90: EXCEPTION
91: WHEN OTHERS THEN

Line 135: IF (PO_LOG.d_proc) THEN

131:
132: BEGIN
133: d_position := 0;
134:
135: IF (PO_LOG.d_proc) THEN
136: PO_LOG.proc_begin(d_module);
137: END IF;
138:
139: FETCH x_attr_values_csr BULK COLLECT INTO

Line 136: PO_LOG.proc_begin(d_module);

132: BEGIN
133: d_position := 0;
134:
135: IF (PO_LOG.d_proc) THEN
136: PO_LOG.proc_begin(d_module);
137: END IF;
138:
139: FETCH x_attr_values_csr BULK COLLECT INTO
140: x_attr_values.intf_attr_values_id_tbl,

Line 158: IF (PO_LOG.d_proc) THEN

154: -- initial value for error_flag
155: x_attr_values.error_flag_tbl
156: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
157:
158: IF (PO_LOG.d_proc) THEN
159: PO_LOG.proc_end (d_module);
160: END IF;
161:
162: EXCEPTION

Line 159: PO_LOG.proc_end (d_module);

155: x_attr_values.error_flag_tbl
156: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
157:
158: IF (PO_LOG.d_proc) THEN
159: PO_LOG.proc_end (d_module);
160: END IF;
161:
162: EXCEPTION
163: WHEN OTHERS THEN

Line 236: IF (PO_LOG.d_proc) THEN

232: l_attr_ref_tbl DBMS_SQL.NUMBER_TABLE;
233: BEGIN
234: d_position := 0;
235:
236: IF (PO_LOG.d_proc) THEN
237: PO_LOG.proc_begin(d_module, 'x_processing_row_tbl.COUNT',
238: x_processing_row_tbl.COUNT);
239: l_index := x_processing_row_tbl.FIRST;
240: WHILE (l_index IS NOT NULL)

Line 237: PO_LOG.proc_begin(d_module, 'x_processing_row_tbl.COUNT',

233: BEGIN
234: d_position := 0;
235:
236: IF (PO_LOG.d_proc) THEN
237: PO_LOG.proc_begin(d_module, 'x_processing_row_tbl.COUNT',
238: x_processing_row_tbl.COUNT);
239: l_index := x_processing_row_tbl.FIRST;
240: WHILE (l_index IS NOT NULL)
241: LOOP

Line 242: PO_LOG.proc_begin(d_module, 'to be processed row num', l_index);

238: x_processing_row_tbl.COUNT);
239: l_index := x_processing_row_tbl.FIRST;
240: WHILE (l_index IS NOT NULL)
241: LOOP
242: PO_LOG.proc_begin(d_module, 'to be processed row num', l_index);
243: l_index := x_processing_row_tbl.NEXT(l_index);
244: END LOOP;
245: END IF;
246:

Line 294: IF (PO_LOG.d_stmt) THEN

290: FOR i IN 1..l_index_tbl.COUNT
291: LOOP
292: l_index := l_index_tbl(i);
293:
294: IF (PO_LOG.d_stmt) THEN
295: PO_LOG.stmt(d_module, d_position, 'index', l_index);
296: PO_LOG.stmt(d_module, d_position, 'current source exist?',
297: x_attr_values.source_tbl.EXISTS(l_index));
298: IF (x_attr_values.source_tbl.EXISTS(l_index)) THEN

Line 295: PO_LOG.stmt(d_module, d_position, 'index', l_index);

291: LOOP
292: l_index := l_index_tbl(i);
293:
294: IF (PO_LOG.d_stmt) THEN
295: PO_LOG.stmt(d_module, d_position, 'index', l_index);
296: PO_LOG.stmt(d_module, d_position, 'current source exist?',
297: x_attr_values.source_tbl.EXISTS(l_index));
298: IF (x_attr_values.source_tbl.EXISTS(l_index)) THEN
299: PO_LOG.stmt(d_module, d_position, 'current source',

Line 296: PO_LOG.stmt(d_module, d_position, 'current source exist?',

292: l_index := l_index_tbl(i);
293:
294: IF (PO_LOG.d_stmt) THEN
295: PO_LOG.stmt(d_module, d_position, 'index', l_index);
296: PO_LOG.stmt(d_module, d_position, 'current source exist?',
297: x_attr_values.source_tbl.EXISTS(l_index));
298: IF (x_attr_values.source_tbl.EXISTS(l_index)) THEN
299: PO_LOG.stmt(d_module, d_position, 'current source',
300: x_attr_values.source_tbl(l_index));

Line 299: PO_LOG.stmt(d_module, d_position, 'current source',

295: PO_LOG.stmt(d_module, d_position, 'index', l_index);
296: PO_LOG.stmt(d_module, d_position, 'current source exist?',
297: x_attr_values.source_tbl.EXISTS(l_index));
298: IF (x_attr_values.source_tbl.EXISTS(l_index)) THEN
299: PO_LOG.stmt(d_module, d_position, 'current source',
300: x_attr_values.source_tbl(l_index));
301: END IF;
302: PO_LOG.stmt(d_module, d_position, 'attr values id',
303: l_result_tbl(i));

Line 302: PO_LOG.stmt(d_module, d_position, 'attr values id',

298: IF (x_attr_values.source_tbl.EXISTS(l_index)) THEN
299: PO_LOG.stmt(d_module, d_position, 'current source',
300: x_attr_values.source_tbl(l_index));
301: END IF;
302: PO_LOG.stmt(d_module, d_position, 'attr values id',
303: l_result_tbl(i));
304: PO_LOG.stmt(d_module, d_position, ' new source',
305: l_source_tbl(i));
306: END IF;

Line 304: PO_LOG.stmt(d_module, d_position, ' new source',

300: x_attr_values.source_tbl(l_index));
301: END IF;
302: PO_LOG.stmt(d_module, d_position, 'attr values id',
303: l_result_tbl(i));
304: PO_LOG.stmt(d_module, d_position, ' new source',
305: l_source_tbl(i));
306: END IF;
307:
308: -- draft record will override txn record

Line 324: IF (PO_LOG.d_stmt) THEN

320: l_index := 0;
321: l_counter := x_processing_row_tbl.FIRST;
322: WHILE (l_counter IS NOT NULL)
323: LOOP
324: IF (PO_LOG.d_stmt) THEN
325: PO_LOG.stmt(d_module, d_position, 'counter', l_counter);
326: END IF;
327:
328:

Line 325: PO_LOG.stmt(d_module, d_position, 'counter', l_counter);

321: l_counter := x_processing_row_tbl.FIRST;
322: WHILE (l_counter IS NOT NULL)
323: LOOP
324: IF (PO_LOG.d_stmt) THEN
325: PO_LOG.stmt(d_module, d_position, 'counter', l_counter);
326: END IF;
327:
328:
329: -- check whether there is row existing in hashtable

Line 334: IF (PO_LOG.d_stmt) THEN

330: IF (NOT l_attr_ref_tbl.EXISTS(x_attr_values.ln_po_line_id_tbl(l_counter))) THEN
331: -- register it in the hashtbale
332: l_attr_ref_tbl(x_attr_values.ln_po_line_id_tbl(l_counter)) := l_counter;
333:
334: IF (PO_LOG.d_stmt) THEN
335: PO_LOG.stmt(d_module, d_position, 'row is handled in current loop');
336: PO_LOG.stmt(d_module, d_position, 'attr values id',
337: x_attr_values.attribute_values_id_tbl(l_counter));
338: END IF;

Line 335: PO_LOG.stmt(d_module, d_position, 'row is handled in current loop');

331: -- register it in the hashtbale
332: l_attr_ref_tbl(x_attr_values.ln_po_line_id_tbl(l_counter)) := l_counter;
333:
334: IF (PO_LOG.d_stmt) THEN
335: PO_LOG.stmt(d_module, d_position, 'row is handled in current loop');
336: PO_LOG.stmt(d_module, d_position, 'attr values id',
337: x_attr_values.attribute_values_id_tbl(l_counter));
338: END IF;
339:

Line 336: PO_LOG.stmt(d_module, d_position, 'attr values id',

332: l_attr_ref_tbl(x_attr_values.ln_po_line_id_tbl(l_counter)) := l_counter;
333:
334: IF (PO_LOG.d_stmt) THEN
335: PO_LOG.stmt(d_module, d_position, 'row is handled in current loop');
336: PO_LOG.stmt(d_module, d_position, 'attr values id',
337: x_attr_values.attribute_values_id_tbl(l_counter));
338: END IF;
339:
340: -- set actions

Line 371: IF (PO_LOG.d_proc) THEN

367: --Bug 12980629
368: x_attr_values.source_tbl.DELETE;
369:
370:
371: IF (PO_LOG.d_proc) THEN
372: PO_LOG.proc_end (d_module);
373: END IF;
374:
375: EXCEPTION

Line 372: PO_LOG.proc_end (d_module);

368: x_attr_values.source_tbl.DELETE;
369:
370:
371: IF (PO_LOG.d_proc) THEN
372: PO_LOG.proc_end (d_module);
373: END IF;
374:
375: EXCEPTION
376: WHEN OTHERS THEN

Line 420: IF (PO_LOG.d_proc) THEN

416:
417: BEGIN
418: d_position := 0;
419:
420: IF (PO_LOG.d_proc) THEN
421: PO_LOG.proc_begin(d_module);
422: END IF;
423:
424: OPEN x_attr_values_tlp_csr FOR

Line 421: PO_LOG.proc_begin(d_module);

417: BEGIN
418: d_position := 0;
419:
420: IF (PO_LOG.d_proc) THEN
421: PO_LOG.proc_begin(d_module);
422: END IF;
423:
424: OPEN x_attr_values_tlp_csr FOR
425: SELECT intf_attrs_tlp.interface_attr_values_tlp_id,

Line 459: IF (PO_LOG.d_proc) THEN

455: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
456: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
457: ORDER BY intf_attrs_tlp.interface_attr_values_tlp_id;
458:
459: IF (PO_LOG.d_proc) THEN
460: PO_LOG.proc_end (d_module);
461: END IF;
462:
463: EXCEPTION

Line 460: PO_LOG.proc_end (d_module);

456: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
457: ORDER BY intf_attrs_tlp.interface_attr_values_tlp_id;
458:
459: IF (PO_LOG.d_proc) THEN
460: PO_LOG.proc_end (d_module);
461: END IF;
462:
463: EXCEPTION
464: WHEN OTHERS THEN

Line 508: IF (PO_LOG.d_proc) THEN

504:
505: BEGIN
506: d_position := 0;
507:
508: IF (PO_LOG.d_proc) THEN
509: PO_LOG.proc_begin(d_module);
510: END IF;
511:
512: FETCH x_attr_values_tlp_csr BULK COLLECT INTO

Line 509: PO_LOG.proc_begin(d_module);

505: BEGIN
506: d_position := 0;
507:
508: IF (PO_LOG.d_proc) THEN
509: PO_LOG.proc_begin(d_module);
510: END IF;
511:
512: FETCH x_attr_values_tlp_csr BULK COLLECT INTO
513: x_attr_values_tlp.intf_attr_values_tlp_id_tbl,

Line 534: IF (PO_LOG.d_proc) THEN

530: -- initial value for error_flag
531: x_attr_values_tlp.error_flag_tbl
532: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
533:
534: IF (PO_LOG.d_proc) THEN
535: PO_LOG.proc_end (d_module);
536: END IF;
537:
538: EXCEPTION

Line 535: PO_LOG.proc_end (d_module);

531: x_attr_values_tlp.error_flag_tbl
532: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
533:
534: IF (PO_LOG.d_proc) THEN
535: PO_LOG.proc_end (d_module);
536: END IF;
537:
538: EXCEPTION
539: WHEN OTHERS THEN

Line 616: IF (PO_LOG.d_proc) THEN

612: l_attr_tlp_ref_tbl attr_tlp_ref_type;
613: BEGIN
614: d_position := 0;
615:
616: IF (PO_LOG.d_proc) THEN
617: PO_LOG.proc_begin(d_module, 'x_processing_row_tbl.COUNT',
618: x_processing_row_tbl.COUNT);
619: l_index := x_processing_row_tbl.FIRST;
620: WHILE (l_index IS NOT NULL)

Line 617: PO_LOG.proc_begin(d_module, 'x_processing_row_tbl.COUNT',

613: BEGIN
614: d_position := 0;
615:
616: IF (PO_LOG.d_proc) THEN
617: PO_LOG.proc_begin(d_module, 'x_processing_row_tbl.COUNT',
618: x_processing_row_tbl.COUNT);
619: l_index := x_processing_row_tbl.FIRST;
620: WHILE (l_index IS NOT NULL)
621: LOOP

Line 622: PO_LOG.proc_begin(d_module, 'to be processed row num', l_index);

618: x_processing_row_tbl.COUNT);
619: l_index := x_processing_row_tbl.FIRST;
620: WHILE (l_index IS NOT NULL)
621: LOOP
622: PO_LOG.proc_begin(d_module, 'to be processed row num', l_index);
623: l_index := x_processing_row_tbl.NEXT(l_index);
624: END LOOP;
625: END IF;
626:

Line 676: IF (PO_LOG.d_stmt) THEN

672: FOR i IN 1..l_index_tbl.COUNT
673: LOOP
674: l_index := l_index_tbl(i);
675:
676: IF (PO_LOG.d_stmt) THEN
677: PO_LOG.stmt(d_module, d_position, 'index', l_index);
678: PO_LOG.stmt(d_module, d_position, 'current source exist?',
679: x_attr_values_tlp.source_tbl.EXISTS(l_index));
680: IF (x_attr_values_tlp.source_tbl.EXISTS(l_index)) THEN

Line 677: PO_LOG.stmt(d_module, d_position, 'index', l_index);

673: LOOP
674: l_index := l_index_tbl(i);
675:
676: IF (PO_LOG.d_stmt) THEN
677: PO_LOG.stmt(d_module, d_position, 'index', l_index);
678: PO_LOG.stmt(d_module, d_position, 'current source exist?',
679: x_attr_values_tlp.source_tbl.EXISTS(l_index));
680: IF (x_attr_values_tlp.source_tbl.EXISTS(l_index)) THEN
681: PO_LOG.stmt(d_module, d_position, 'current source',

Line 678: PO_LOG.stmt(d_module, d_position, 'current source exist?',

674: l_index := l_index_tbl(i);
675:
676: IF (PO_LOG.d_stmt) THEN
677: PO_LOG.stmt(d_module, d_position, 'index', l_index);
678: PO_LOG.stmt(d_module, d_position, 'current source exist?',
679: x_attr_values_tlp.source_tbl.EXISTS(l_index));
680: IF (x_attr_values_tlp.source_tbl.EXISTS(l_index)) THEN
681: PO_LOG.stmt(d_module, d_position, 'current source',
682: x_attr_values_tlp.source_tbl(l_index));

Line 681: PO_LOG.stmt(d_module, d_position, 'current source',

677: PO_LOG.stmt(d_module, d_position, 'index', l_index);
678: PO_LOG.stmt(d_module, d_position, 'current source exist?',
679: x_attr_values_tlp.source_tbl.EXISTS(l_index));
680: IF (x_attr_values_tlp.source_tbl.EXISTS(l_index)) THEN
681: PO_LOG.stmt(d_module, d_position, 'current source',
682: x_attr_values_tlp.source_tbl(l_index));
683: END IF;
684: PO_LOG.stmt(d_module, d_position, 'attr values id',
685: l_result_tbl(i));

Line 684: PO_LOG.stmt(d_module, d_position, 'attr values id',

680: IF (x_attr_values_tlp.source_tbl.EXISTS(l_index)) THEN
681: PO_LOG.stmt(d_module, d_position, 'current source',
682: x_attr_values_tlp.source_tbl(l_index));
683: END IF;
684: PO_LOG.stmt(d_module, d_position, 'attr values id',
685: l_result_tbl(i));
686: PO_LOG.stmt(d_module, d_position, ' new source',
687: l_source_tbl(i));
688: END IF;

Line 686: PO_LOG.stmt(d_module, d_position, ' new source',

682: x_attr_values_tlp.source_tbl(l_index));
683: END IF;
684: PO_LOG.stmt(d_module, d_position, 'attr values id',
685: l_result_tbl(i));
686: PO_LOG.stmt(d_module, d_position, ' new source',
687: l_source_tbl(i));
688: END IF;
689:
690: -- draft record will override txn record

Line 709: IF (PO_LOG.d_stmt) THEN

705: LOOP
706: l_po_line_id := x_attr_values_tlp.ln_po_line_id_tbl(l_counter);
707: l_lang := x_attr_values_tlp.language_tbl(l_counter);
708:
709: IF (PO_LOG.d_stmt) THEN
710: PO_LOG.stmt(d_module, d_position, 'l_counter', l_counter);
711: PO_LOG.stmt(d_module, d_position, 'l_po_line_id', l_po_line_id);
712: PO_LOG.stmt(d_module, d_position, 'l_lang',l_lang);
713: END IF;

Line 710: PO_LOG.stmt(d_module, d_position, 'l_counter', l_counter);

706: l_po_line_id := x_attr_values_tlp.ln_po_line_id_tbl(l_counter);
707: l_lang := x_attr_values_tlp.language_tbl(l_counter);
708:
709: IF (PO_LOG.d_stmt) THEN
710: PO_LOG.stmt(d_module, d_position, 'l_counter', l_counter);
711: PO_LOG.stmt(d_module, d_position, 'l_po_line_id', l_po_line_id);
712: PO_LOG.stmt(d_module, d_position, 'l_lang',l_lang);
713: END IF;
714:

Line 711: PO_LOG.stmt(d_module, d_position, 'l_po_line_id', l_po_line_id);

707: l_lang := x_attr_values_tlp.language_tbl(l_counter);
708:
709: IF (PO_LOG.d_stmt) THEN
710: PO_LOG.stmt(d_module, d_position, 'l_counter', l_counter);
711: PO_LOG.stmt(d_module, d_position, 'l_po_line_id', l_po_line_id);
712: PO_LOG.stmt(d_module, d_position, 'l_lang',l_lang);
713: END IF;
714:
715: -- check whether there is row existing in hashtable

Line 712: PO_LOG.stmt(d_module, d_position, 'l_lang',l_lang);

708:
709: IF (PO_LOG.d_stmt) THEN
710: PO_LOG.stmt(d_module, d_position, 'l_counter', l_counter);
711: PO_LOG.stmt(d_module, d_position, 'l_po_line_id', l_po_line_id);
712: PO_LOG.stmt(d_module, d_position, 'l_lang',l_lang);
713: END IF;
714:
715: -- check whether there is row existing in hashtable
716: IF (NOT l_attr_tlp_ref_tbl.EXISTS(l_lang) OR

Line 723: IF (PO_LOG.d_stmt) THEN

719: -- IF (l_attr_tlp_ref_tbl(l_lang)(l_po_line_id) IS NULL) THEN
720: -- register it in the hashtbale
721: l_attr_tlp_ref_tbl(l_lang)(l_po_line_id) := l_counter;
722:
723: IF (PO_LOG.d_stmt) THEN
724: PO_LOG.stmt(d_module, d_position, 'row is handled in current loop');
725: PO_LOG.stmt(d_module, d_position, 'attr values tlp id',
726: x_attr_values_tlp.attribute_values_tlp_id_tbl(l_counter));
727: END IF;

Line 724: PO_LOG.stmt(d_module, d_position, 'row is handled in current loop');

720: -- register it in the hashtbale
721: l_attr_tlp_ref_tbl(l_lang)(l_po_line_id) := l_counter;
722:
723: IF (PO_LOG.d_stmt) THEN
724: PO_LOG.stmt(d_module, d_position, 'row is handled in current loop');
725: PO_LOG.stmt(d_module, d_position, 'attr values tlp id',
726: x_attr_values_tlp.attribute_values_tlp_id_tbl(l_counter));
727: END IF;
728:

Line 725: PO_LOG.stmt(d_module, d_position, 'attr values tlp id',

721: l_attr_tlp_ref_tbl(l_lang)(l_po_line_id) := l_counter;
722:
723: IF (PO_LOG.d_stmt) THEN
724: PO_LOG.stmt(d_module, d_position, 'row is handled in current loop');
725: PO_LOG.stmt(d_module, d_position, 'attr values tlp id',
726: x_attr_values_tlp.attribute_values_tlp_id_tbl(l_counter));
727: END IF;
728:
729: -- set actions

Line 758: IF (PO_LOG.d_proc) THEN

754:
755: --Bug12980629
756: x_attr_values_tlp.source_tbl.DELETE;
757:
758: IF (PO_LOG.d_proc) THEN
759: PO_LOG.proc_end (d_module);
760: END IF;
761:
762: EXCEPTION

Line 759: PO_LOG.proc_end (d_module);

755: --Bug12980629
756: x_attr_values_tlp.source_tbl.DELETE;
757:
758: IF (PO_LOG.d_proc) THEN
759: PO_LOG.proc_end (d_module);
760: END IF;
761:
762: EXCEPTION
763: WHEN OTHERS THEN

Line 815: IF (PO_LOG.d_proc) THEN

811: l_mfg_name_tbl PO_TBL_VARCHAR2000;
812: BEGIN
813: d_position := 0;
814:
815: IF (PO_LOG.d_proc) THEN
816: PO_LOG.proc_begin(d_module);
817: END IF;
818:
819: -- Bug7039409: Get master_org_id and inv_org_id

Line 816: PO_LOG.proc_begin(d_module);

812: BEGIN
813: d_position := 0;
814:
815: IF (PO_LOG.d_proc) THEN
816: PO_LOG.proc_begin(d_module);
817: END IF;
818:
819: -- Bug7039409: Get master_org_id and inv_org_id
820: -- Use master org to get mfg_part_num, manufacturer_name and long_description

Line 831: IF (PO_LOG.d_stmt) THEN

827: FROM mtl_parameters mtl,
828: financials_system_parameters fsp
829: WHERE fsp.inventory_organization_id = mtl.organization_id;
830:
831: IF (PO_LOG.d_stmt) THEN
832: PO_LOG.stmt(d_module, d_position, 'l_master_org_id', l_master_org_id);
833: PO_LOG.stmt(d_module, d_position, 'l_inv_org_id', l_inv_org_id);
834: END IF;
835:

Line 832: PO_LOG.stmt(d_module, d_position, 'l_master_org_id', l_master_org_id);

828: financials_system_parameters fsp
829: WHERE fsp.inventory_organization_id = mtl.organization_id;
830:
831: IF (PO_LOG.d_stmt) THEN
832: PO_LOG.stmt(d_module, d_position, 'l_master_org_id', l_master_org_id);
833: PO_LOG.stmt(d_module, d_position, 'l_inv_org_id', l_inv_org_id);
834: END IF;
835:
836: -- get lines for which default attr and attr_tlp rows need to be created

Line 833: PO_LOG.stmt(d_module, d_position, 'l_inv_org_id', l_inv_org_id);

829: WHERE fsp.inventory_organization_id = mtl.organization_id;
830:
831: IF (PO_LOG.d_stmt) THEN
832: PO_LOG.stmt(d_module, d_position, 'l_master_org_id', l_master_org_id);
833: PO_LOG.stmt(d_module, d_position, 'l_inv_org_id', l_inv_org_id);
834: END IF;
835:
836: -- get lines for which default attr and attr_tlp rows need to be created
837: SELECT draft_lines.draft_id,

Line 881: IF (PO_LOG.d_stmt) THEN

877: FROM po_attribute_values_draft
878: WHERE po_line_id = draft_lines.po_line_id
879: AND draft_id = draft_lines.draft_id);
880:
881: IF (PO_LOG.d_stmt) THEN
882: PO_LOG.stmt(d_module, d_position, 'l_draft_id_tbl', l_draft_id_tbl);
883: PO_LOG.stmt(d_module, d_position, 'l_po_line_id_tbl', l_po_line_id_tbl);
884: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl', l_item_id_tbl);
885: PO_LOG.stmt(d_module, d_position, 'l_ip_category_id_tbl',

Line 882: PO_LOG.stmt(d_module, d_position, 'l_draft_id_tbl', l_draft_id_tbl);

878: WHERE po_line_id = draft_lines.po_line_id
879: AND draft_id = draft_lines.draft_id);
880:
881: IF (PO_LOG.d_stmt) THEN
882: PO_LOG.stmt(d_module, d_position, 'l_draft_id_tbl', l_draft_id_tbl);
883: PO_LOG.stmt(d_module, d_position, 'l_po_line_id_tbl', l_po_line_id_tbl);
884: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl', l_item_id_tbl);
885: PO_LOG.stmt(d_module, d_position, 'l_ip_category_id_tbl',
886: l_ip_category_id_tbl);

Line 883: PO_LOG.stmt(d_module, d_position, 'l_po_line_id_tbl', l_po_line_id_tbl);

879: AND draft_id = draft_lines.draft_id);
880:
881: IF (PO_LOG.d_stmt) THEN
882: PO_LOG.stmt(d_module, d_position, 'l_draft_id_tbl', l_draft_id_tbl);
883: PO_LOG.stmt(d_module, d_position, 'l_po_line_id_tbl', l_po_line_id_tbl);
884: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl', l_item_id_tbl);
885: PO_LOG.stmt(d_module, d_position, 'l_ip_category_id_tbl',
886: l_ip_category_id_tbl);
887: PO_LOG.stmt(d_module, d_position, 'l_item_desc_tbl', l_item_desc_tbl);

Line 884: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl', l_item_id_tbl);

880:
881: IF (PO_LOG.d_stmt) THEN
882: PO_LOG.stmt(d_module, d_position, 'l_draft_id_tbl', l_draft_id_tbl);
883: PO_LOG.stmt(d_module, d_position, 'l_po_line_id_tbl', l_po_line_id_tbl);
884: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl', l_item_id_tbl);
885: PO_LOG.stmt(d_module, d_position, 'l_ip_category_id_tbl',
886: l_ip_category_id_tbl);
887: PO_LOG.stmt(d_module, d_position, 'l_item_desc_tbl', l_item_desc_tbl);
888: PO_LOG.stmt(d_module, d_position, 'l_lead_time_tbl', l_lead_time_tbl);

Line 885: PO_LOG.stmt(d_module, d_position, 'l_ip_category_id_tbl',

881: IF (PO_LOG.d_stmt) THEN
882: PO_LOG.stmt(d_module, d_position, 'l_draft_id_tbl', l_draft_id_tbl);
883: PO_LOG.stmt(d_module, d_position, 'l_po_line_id_tbl', l_po_line_id_tbl);
884: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl', l_item_id_tbl);
885: PO_LOG.stmt(d_module, d_position, 'l_ip_category_id_tbl',
886: l_ip_category_id_tbl);
887: PO_LOG.stmt(d_module, d_position, 'l_item_desc_tbl', l_item_desc_tbl);
888: PO_LOG.stmt(d_module, d_position, 'l_lead_time_tbl', l_lead_time_tbl);
889: END IF;

Line 887: PO_LOG.stmt(d_module, d_position, 'l_item_desc_tbl', l_item_desc_tbl);

883: PO_LOG.stmt(d_module, d_position, 'l_po_line_id_tbl', l_po_line_id_tbl);
884: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl', l_item_id_tbl);
885: PO_LOG.stmt(d_module, d_position, 'l_ip_category_id_tbl',
886: l_ip_category_id_tbl);
887: PO_LOG.stmt(d_module, d_position, 'l_item_desc_tbl', l_item_desc_tbl);
888: PO_LOG.stmt(d_module, d_position, 'l_lead_time_tbl', l_lead_time_tbl);
889: END IF;
890: d_position := 10;
891:

Line 888: PO_LOG.stmt(d_module, d_position, 'l_lead_time_tbl', l_lead_time_tbl);

884: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl', l_item_id_tbl);
885: PO_LOG.stmt(d_module, d_position, 'l_ip_category_id_tbl',
886: l_ip_category_id_tbl);
887: PO_LOG.stmt(d_module, d_position, 'l_item_desc_tbl', l_item_desc_tbl);
888: PO_LOG.stmt(d_module, d_position, 'l_lead_time_tbl', l_lead_time_tbl);
889: END IF;
890: d_position := 10;
891:
892: -- create default attr rows

Line 1006: IF (PO_LOG.d_stmt) THEN

1002: AND pavd.program_application_id = fnd_global.prog_appl_id
1003: AND pavd.program_id = fnd_global.conc_program_id
1004: GROUP BY pavd.inventory_item_id);
1005:
1006: IF (PO_LOG.d_stmt) THEN
1007: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl2', l_item_id_tbl2);
1008: PO_LOG.stmt(d_module, d_position, 'l_mfg_part_num_tbl', l_mfg_part_num_tbl);
1009: PO_LOG.stmt(d_module, d_position, 'l_mfg_name_tbl', l_mfg_name_tbl);
1010: END IF;

Line 1007: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl2', l_item_id_tbl2);

1003: AND pavd.program_id = fnd_global.conc_program_id
1004: GROUP BY pavd.inventory_item_id);
1005:
1006: IF (PO_LOG.d_stmt) THEN
1007: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl2', l_item_id_tbl2);
1008: PO_LOG.stmt(d_module, d_position, 'l_mfg_part_num_tbl', l_mfg_part_num_tbl);
1009: PO_LOG.stmt(d_module, d_position, 'l_mfg_name_tbl', l_mfg_name_tbl);
1010: END IF;
1011:

Line 1008: PO_LOG.stmt(d_module, d_position, 'l_mfg_part_num_tbl', l_mfg_part_num_tbl);

1004: GROUP BY pavd.inventory_item_id);
1005:
1006: IF (PO_LOG.d_stmt) THEN
1007: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl2', l_item_id_tbl2);
1008: PO_LOG.stmt(d_module, d_position, 'l_mfg_part_num_tbl', l_mfg_part_num_tbl);
1009: PO_LOG.stmt(d_module, d_position, 'l_mfg_name_tbl', l_mfg_name_tbl);
1010: END IF;
1011:
1012: -- Bug7039409: update po_attribute_values_draft.manufacturer_part_num

Line 1009: PO_LOG.stmt(d_module, d_position, 'l_mfg_name_tbl', l_mfg_name_tbl);

1005:
1006: IF (PO_LOG.d_stmt) THEN
1007: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl2', l_item_id_tbl2);
1008: PO_LOG.stmt(d_module, d_position, 'l_mfg_part_num_tbl', l_mfg_part_num_tbl);
1009: PO_LOG.stmt(d_module, d_position, 'l_mfg_name_tbl', l_mfg_name_tbl);
1010: END IF;
1011:
1012: -- Bug7039409: update po_attribute_values_draft.manufacturer_part_num
1013: FORALL i IN 1..l_item_id_tbl2.COUNT

Line 1047: IF (PO_LOG.d_proc) THEN

1043: AND pavd_tlp.program_application_id = fnd_global.prog_appl_id
1044: AND pavd_tlp.program_id = fnd_global.conc_program_id
1045: AND pavd_tlp.long_description IS NULL;
1046:
1047: IF (PO_LOG.d_proc) THEN
1048: PO_LOG.proc_end (d_module);
1049: END IF;
1050:
1051: EXCEPTION

Line 1048: PO_LOG.proc_end (d_module);

1044: AND pavd_tlp.program_id = fnd_global.conc_program_id
1045: AND pavd_tlp.long_description IS NULL;
1046:
1047: IF (PO_LOG.d_proc) THEN
1048: PO_LOG.proc_end (d_module);
1049: END IF;
1050:
1051: EXCEPTION
1052: WHEN OTHERS THEN