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.12.12010000.2 2008/08/04 08:38:25 rramasam 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 367: IF (PO_LOG.d_proc) THEN

363:
364: l_counter := x_processing_row_tbl.NEXT(l_counter);
365: END LOOP;
366:
367: IF (PO_LOG.d_proc) THEN
368: PO_LOG.proc_end (d_module);
369: END IF;
370:
371: EXCEPTION

Line 368: PO_LOG.proc_end (d_module);

364: l_counter := x_processing_row_tbl.NEXT(l_counter);
365: END LOOP;
366:
367: IF (PO_LOG.d_proc) THEN
368: PO_LOG.proc_end (d_module);
369: END IF;
370:
371: EXCEPTION
372: WHEN OTHERS THEN

Line 416: IF (PO_LOG.d_proc) THEN

412:
413: BEGIN
414: d_position := 0;
415:
416: IF (PO_LOG.d_proc) THEN
417: PO_LOG.proc_begin(d_module);
418: END IF;
419:
420: OPEN x_attr_values_tlp_csr FOR

Line 417: PO_LOG.proc_begin(d_module);

413: BEGIN
414: d_position := 0;
415:
416: IF (PO_LOG.d_proc) THEN
417: PO_LOG.proc_begin(d_module);
418: END IF;
419:
420: OPEN x_attr_values_tlp_csr FOR
421: SELECT intf_attrs_tlp.interface_attr_values_tlp_id,

Line 455: IF (PO_LOG.d_proc) THEN

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

Line 456: PO_LOG.proc_end (d_module);

452: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
453: ORDER BY intf_attrs_tlp.interface_attr_values_tlp_id;
454:
455: IF (PO_LOG.d_proc) THEN
456: PO_LOG.proc_end (d_module);
457: END IF;
458:
459: EXCEPTION
460: WHEN OTHERS THEN

Line 504: IF (PO_LOG.d_proc) THEN

500:
501: BEGIN
502: d_position := 0;
503:
504: IF (PO_LOG.d_proc) THEN
505: PO_LOG.proc_begin(d_module);
506: END IF;
507:
508: FETCH x_attr_values_tlp_csr BULK COLLECT INTO

Line 505: PO_LOG.proc_begin(d_module);

501: BEGIN
502: d_position := 0;
503:
504: IF (PO_LOG.d_proc) THEN
505: PO_LOG.proc_begin(d_module);
506: END IF;
507:
508: FETCH x_attr_values_tlp_csr BULK COLLECT INTO
509: x_attr_values_tlp.intf_attr_values_tlp_id_tbl,

Line 529: IF (PO_LOG.d_proc) THEN

525: -- initial value for error_flag
526: x_attr_values_tlp.error_flag_tbl
527: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
528:
529: IF (PO_LOG.d_proc) THEN
530: PO_LOG.proc_end (d_module);
531: END IF;
532:
533: EXCEPTION

Line 530: PO_LOG.proc_end (d_module);

526: x_attr_values_tlp.error_flag_tbl
527: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
528:
529: IF (PO_LOG.d_proc) THEN
530: PO_LOG.proc_end (d_module);
531: END IF;
532:
533: EXCEPTION
534: WHEN OTHERS THEN

Line 611: IF (PO_LOG.d_proc) THEN

607: l_attr_tlp_ref_tbl attr_tlp_ref_type;
608: BEGIN
609: d_position := 0;
610:
611: IF (PO_LOG.d_proc) THEN
612: PO_LOG.proc_begin(d_module, 'x_processing_row_tbl.COUNT',
613: x_processing_row_tbl.COUNT);
614: l_index := x_processing_row_tbl.FIRST;
615: WHILE (l_index IS NOT NULL)

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

608: BEGIN
609: d_position := 0;
610:
611: IF (PO_LOG.d_proc) THEN
612: PO_LOG.proc_begin(d_module, 'x_processing_row_tbl.COUNT',
613: x_processing_row_tbl.COUNT);
614: l_index := x_processing_row_tbl.FIRST;
615: WHILE (l_index IS NOT NULL)
616: LOOP

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

613: x_processing_row_tbl.COUNT);
614: l_index := x_processing_row_tbl.FIRST;
615: WHILE (l_index IS NOT NULL)
616: LOOP
617: PO_LOG.proc_begin(d_module, 'to be processed row num', l_index);
618: l_index := x_processing_row_tbl.NEXT(l_index);
619: END LOOP;
620: END IF;
621:

Line 671: IF (PO_LOG.d_stmt) THEN

667: FOR i IN 1..l_index_tbl.COUNT
668: LOOP
669: l_index := l_index_tbl(i);
670:
671: IF (PO_LOG.d_stmt) THEN
672: PO_LOG.stmt(d_module, d_position, 'index', l_index);
673: PO_LOG.stmt(d_module, d_position, 'current source exist?',
674: x_attr_values_tlp.source_tbl.EXISTS(l_index));
675: IF (x_attr_values_tlp.source_tbl.EXISTS(l_index)) THEN

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

668: LOOP
669: l_index := l_index_tbl(i);
670:
671: IF (PO_LOG.d_stmt) THEN
672: PO_LOG.stmt(d_module, d_position, 'index', l_index);
673: PO_LOG.stmt(d_module, d_position, 'current source exist?',
674: x_attr_values_tlp.source_tbl.EXISTS(l_index));
675: IF (x_attr_values_tlp.source_tbl.EXISTS(l_index)) THEN
676: PO_LOG.stmt(d_module, d_position, 'current source',

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

669: l_index := l_index_tbl(i);
670:
671: IF (PO_LOG.d_stmt) THEN
672: PO_LOG.stmt(d_module, d_position, 'index', l_index);
673: PO_LOG.stmt(d_module, d_position, 'current source exist?',
674: x_attr_values_tlp.source_tbl.EXISTS(l_index));
675: IF (x_attr_values_tlp.source_tbl.EXISTS(l_index)) THEN
676: PO_LOG.stmt(d_module, d_position, 'current source',
677: x_attr_values_tlp.source_tbl(l_index));

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

672: PO_LOG.stmt(d_module, d_position, 'index', l_index);
673: PO_LOG.stmt(d_module, d_position, 'current source exist?',
674: x_attr_values_tlp.source_tbl.EXISTS(l_index));
675: IF (x_attr_values_tlp.source_tbl.EXISTS(l_index)) THEN
676: PO_LOG.stmt(d_module, d_position, 'current source',
677: x_attr_values_tlp.source_tbl(l_index));
678: END IF;
679: PO_LOG.stmt(d_module, d_position, 'attr values id',
680: l_result_tbl(i));

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

675: IF (x_attr_values_tlp.source_tbl.EXISTS(l_index)) THEN
676: PO_LOG.stmt(d_module, d_position, 'current source',
677: x_attr_values_tlp.source_tbl(l_index));
678: END IF;
679: PO_LOG.stmt(d_module, d_position, 'attr values id',
680: l_result_tbl(i));
681: PO_LOG.stmt(d_module, d_position, ' new source',
682: l_source_tbl(i));
683: END IF;

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

677: x_attr_values_tlp.source_tbl(l_index));
678: END IF;
679: PO_LOG.stmt(d_module, d_position, 'attr values id',
680: l_result_tbl(i));
681: PO_LOG.stmt(d_module, d_position, ' new source',
682: l_source_tbl(i));
683: END IF;
684:
685: -- draft record will override txn record

Line 704: IF (PO_LOG.d_stmt) THEN

700: LOOP
701: l_po_line_id := x_attr_values_tlp.ln_po_line_id_tbl(l_counter);
702: l_lang := x_attr_values_tlp.language_tbl(l_counter);
703:
704: IF (PO_LOG.d_stmt) THEN
705: PO_LOG.stmt(d_module, d_position, 'l_counter', l_counter);
706: PO_LOG.stmt(d_module, d_position, 'l_po_line_id', l_po_line_id);
707: PO_LOG.stmt(d_module, d_position, 'l_lang',l_lang);
708: END IF;

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

701: l_po_line_id := x_attr_values_tlp.ln_po_line_id_tbl(l_counter);
702: l_lang := x_attr_values_tlp.language_tbl(l_counter);
703:
704: IF (PO_LOG.d_stmt) THEN
705: PO_LOG.stmt(d_module, d_position, 'l_counter', l_counter);
706: PO_LOG.stmt(d_module, d_position, 'l_po_line_id', l_po_line_id);
707: PO_LOG.stmt(d_module, d_position, 'l_lang',l_lang);
708: END IF;
709:

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

702: l_lang := x_attr_values_tlp.language_tbl(l_counter);
703:
704: IF (PO_LOG.d_stmt) THEN
705: PO_LOG.stmt(d_module, d_position, 'l_counter', l_counter);
706: PO_LOG.stmt(d_module, d_position, 'l_po_line_id', l_po_line_id);
707: PO_LOG.stmt(d_module, d_position, 'l_lang',l_lang);
708: END IF;
709:
710: -- check whether there is row existing in hashtable

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

703:
704: IF (PO_LOG.d_stmt) THEN
705: PO_LOG.stmt(d_module, d_position, 'l_counter', l_counter);
706: PO_LOG.stmt(d_module, d_position, 'l_po_line_id', l_po_line_id);
707: PO_LOG.stmt(d_module, d_position, 'l_lang',l_lang);
708: END IF;
709:
710: -- check whether there is row existing in hashtable
711: IF (NOT l_attr_tlp_ref_tbl.EXISTS(l_lang) OR

Line 718: IF (PO_LOG.d_stmt) THEN

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

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

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

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

716: l_attr_tlp_ref_tbl(l_lang)(l_po_line_id) := l_counter;
717:
718: IF (PO_LOG.d_stmt) THEN
719: PO_LOG.stmt(d_module, d_position, 'row is handled in current loop');
720: PO_LOG.stmt(d_module, d_position, 'attr values tlp id',
721: x_attr_values_tlp.attribute_values_tlp_id_tbl(l_counter));
722: END IF;
723:
724: -- set actions

Line 750: IF (PO_LOG.d_proc) THEN

746:
747: l_counter := x_processing_row_tbl.NEXT(l_counter);
748: END LOOP;
749:
750: IF (PO_LOG.d_proc) THEN
751: PO_LOG.proc_end (d_module);
752: END IF;
753:
754: EXCEPTION

Line 751: PO_LOG.proc_end (d_module);

747: l_counter := x_processing_row_tbl.NEXT(l_counter);
748: END LOOP;
749:
750: IF (PO_LOG.d_proc) THEN
751: PO_LOG.proc_end (d_module);
752: END IF;
753:
754: EXCEPTION
755: WHEN OTHERS THEN

Line 807: IF (PO_LOG.d_proc) THEN

803: l_mfg_name_tbl PO_TBL_VARCHAR2000;
804: BEGIN
805: d_position := 0;
806:
807: IF (PO_LOG.d_proc) THEN
808: PO_LOG.proc_begin(d_module);
809: END IF;
810:
811: -- Bug7039409: Get master_org_id and inv_org_id

Line 808: PO_LOG.proc_begin(d_module);

804: BEGIN
805: d_position := 0;
806:
807: IF (PO_LOG.d_proc) THEN
808: PO_LOG.proc_begin(d_module);
809: END IF;
810:
811: -- Bug7039409: Get master_org_id and inv_org_id
812: -- Use master org to get mfg_part_num, manufacturer_name and long_description

Line 823: IF (PO_LOG.d_stmt) THEN

819: FROM mtl_parameters mtl,
820: financials_system_parameters fsp
821: WHERE fsp.inventory_organization_id = mtl.organization_id;
822:
823: IF (PO_LOG.d_stmt) THEN
824: PO_LOG.stmt(d_module, d_position, 'l_master_org_id', l_master_org_id);
825: PO_LOG.stmt(d_module, d_position, 'l_inv_org_id', l_inv_org_id);
826: END IF;
827:

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

820: financials_system_parameters fsp
821: WHERE fsp.inventory_organization_id = mtl.organization_id;
822:
823: IF (PO_LOG.d_stmt) THEN
824: PO_LOG.stmt(d_module, d_position, 'l_master_org_id', l_master_org_id);
825: PO_LOG.stmt(d_module, d_position, 'l_inv_org_id', l_inv_org_id);
826: END IF;
827:
828: -- get lines for which default attr and attr_tlp rows need to be created

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

821: WHERE fsp.inventory_organization_id = mtl.organization_id;
822:
823: IF (PO_LOG.d_stmt) THEN
824: PO_LOG.stmt(d_module, d_position, 'l_master_org_id', l_master_org_id);
825: PO_LOG.stmt(d_module, d_position, 'l_inv_org_id', l_inv_org_id);
826: END IF;
827:
828: -- get lines for which default attr and attr_tlp rows need to be created
829: SELECT draft_lines.draft_id,

Line 873: IF (PO_LOG.d_stmt) THEN

869: FROM po_attribute_values_draft
870: WHERE po_line_id = draft_lines.po_line_id
871: AND draft_id = draft_lines.draft_id);
872:
873: IF (PO_LOG.d_stmt) THEN
874: PO_LOG.stmt(d_module, d_position, 'l_draft_id_tbl', l_draft_id_tbl);
875: PO_LOG.stmt(d_module, d_position, 'l_po_line_id_tbl', l_po_line_id_tbl);
876: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl', l_item_id_tbl);
877: PO_LOG.stmt(d_module, d_position, 'l_ip_category_id_tbl',

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

870: WHERE po_line_id = draft_lines.po_line_id
871: AND draft_id = draft_lines.draft_id);
872:
873: IF (PO_LOG.d_stmt) THEN
874: PO_LOG.stmt(d_module, d_position, 'l_draft_id_tbl', l_draft_id_tbl);
875: PO_LOG.stmt(d_module, d_position, 'l_po_line_id_tbl', l_po_line_id_tbl);
876: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl', l_item_id_tbl);
877: PO_LOG.stmt(d_module, d_position, 'l_ip_category_id_tbl',
878: l_ip_category_id_tbl);

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

871: AND draft_id = draft_lines.draft_id);
872:
873: IF (PO_LOG.d_stmt) THEN
874: PO_LOG.stmt(d_module, d_position, 'l_draft_id_tbl', l_draft_id_tbl);
875: PO_LOG.stmt(d_module, d_position, 'l_po_line_id_tbl', l_po_line_id_tbl);
876: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl', l_item_id_tbl);
877: PO_LOG.stmt(d_module, d_position, 'l_ip_category_id_tbl',
878: l_ip_category_id_tbl);
879: PO_LOG.stmt(d_module, d_position, 'l_item_desc_tbl', l_item_desc_tbl);

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

872:
873: IF (PO_LOG.d_stmt) THEN
874: PO_LOG.stmt(d_module, d_position, 'l_draft_id_tbl', l_draft_id_tbl);
875: PO_LOG.stmt(d_module, d_position, 'l_po_line_id_tbl', l_po_line_id_tbl);
876: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl', l_item_id_tbl);
877: PO_LOG.stmt(d_module, d_position, 'l_ip_category_id_tbl',
878: l_ip_category_id_tbl);
879: PO_LOG.stmt(d_module, d_position, 'l_item_desc_tbl', l_item_desc_tbl);
880: PO_LOG.stmt(d_module, d_position, 'l_lead_time_tbl', l_lead_time_tbl);

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

873: IF (PO_LOG.d_stmt) THEN
874: PO_LOG.stmt(d_module, d_position, 'l_draft_id_tbl', l_draft_id_tbl);
875: PO_LOG.stmt(d_module, d_position, 'l_po_line_id_tbl', l_po_line_id_tbl);
876: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl', l_item_id_tbl);
877: PO_LOG.stmt(d_module, d_position, 'l_ip_category_id_tbl',
878: l_ip_category_id_tbl);
879: PO_LOG.stmt(d_module, d_position, 'l_item_desc_tbl', l_item_desc_tbl);
880: PO_LOG.stmt(d_module, d_position, 'l_lead_time_tbl', l_lead_time_tbl);
881: END IF;

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

875: PO_LOG.stmt(d_module, d_position, 'l_po_line_id_tbl', l_po_line_id_tbl);
876: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl', l_item_id_tbl);
877: PO_LOG.stmt(d_module, d_position, 'l_ip_category_id_tbl',
878: l_ip_category_id_tbl);
879: PO_LOG.stmt(d_module, d_position, 'l_item_desc_tbl', l_item_desc_tbl);
880: PO_LOG.stmt(d_module, d_position, 'l_lead_time_tbl', l_lead_time_tbl);
881: END IF;
882: d_position := 10;
883:

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

876: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl', l_item_id_tbl);
877: PO_LOG.stmt(d_module, d_position, 'l_ip_category_id_tbl',
878: l_ip_category_id_tbl);
879: PO_LOG.stmt(d_module, d_position, 'l_item_desc_tbl', l_item_desc_tbl);
880: PO_LOG.stmt(d_module, d_position, 'l_lead_time_tbl', l_lead_time_tbl);
881: END IF;
882: d_position := 10;
883:
884: -- create default attr rows

Line 998: IF (PO_LOG.d_stmt) THEN

994: AND pavd.program_application_id = fnd_global.prog_appl_id
995: AND pavd.program_id = fnd_global.conc_program_id
996: GROUP BY pavd.inventory_item_id);
997:
998: IF (PO_LOG.d_stmt) THEN
999: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl2', l_item_id_tbl2);
1000: PO_LOG.stmt(d_module, d_position, 'l_mfg_part_num_tbl', l_mfg_part_num_tbl);
1001: PO_LOG.stmt(d_module, d_position, 'l_mfg_name_tbl', l_mfg_name_tbl);
1002: END IF;

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

995: AND pavd.program_id = fnd_global.conc_program_id
996: GROUP BY pavd.inventory_item_id);
997:
998: IF (PO_LOG.d_stmt) THEN
999: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl2', l_item_id_tbl2);
1000: PO_LOG.stmt(d_module, d_position, 'l_mfg_part_num_tbl', l_mfg_part_num_tbl);
1001: PO_LOG.stmt(d_module, d_position, 'l_mfg_name_tbl', l_mfg_name_tbl);
1002: END IF;
1003:

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

996: GROUP BY pavd.inventory_item_id);
997:
998: IF (PO_LOG.d_stmt) THEN
999: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl2', l_item_id_tbl2);
1000: PO_LOG.stmt(d_module, d_position, 'l_mfg_part_num_tbl', l_mfg_part_num_tbl);
1001: PO_LOG.stmt(d_module, d_position, 'l_mfg_name_tbl', l_mfg_name_tbl);
1002: END IF;
1003:
1004: -- Bug7039409: update po_attribute_values_draft.manufacturer_part_num

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

997:
998: IF (PO_LOG.d_stmt) THEN
999: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl2', l_item_id_tbl2);
1000: PO_LOG.stmt(d_module, d_position, 'l_mfg_part_num_tbl', l_mfg_part_num_tbl);
1001: PO_LOG.stmt(d_module, d_position, 'l_mfg_name_tbl', l_mfg_name_tbl);
1002: END IF;
1003:
1004: -- Bug7039409: update po_attribute_values_draft.manufacturer_part_num
1005: FORALL i IN 1..l_item_id_tbl2.COUNT

Line 1037: IF (PO_LOG.d_proc) THEN

1033: WHERE pavd_tlp.request_id = fnd_global.conc_request_id
1034: AND pavd_tlp.program_application_id = fnd_global.prog_appl_id
1035: AND pavd_tlp.program_id = fnd_global.conc_program_id;
1036:
1037: IF (PO_LOG.d_proc) THEN
1038: PO_LOG.proc_end (d_module);
1039: END IF;
1040:
1041: EXCEPTION

Line 1038: PO_LOG.proc_end (d_module);

1034: AND pavd_tlp.program_application_id = fnd_global.prog_appl_id
1035: AND pavd_tlp.program_id = fnd_global.conc_program_id;
1036:
1037: IF (PO_LOG.d_proc) THEN
1038: PO_LOG.proc_end (d_module);
1039: END IF;
1040:
1041: EXCEPTION
1042: WHEN OTHERS THEN