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

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

1: PACKAGE BODY PO_PDOI_PRICE_DIFF_PROCESS_PVT AS
2: /* $Header: PO_PDOI_PRICE_DIFF_PROCESS_PVT.plb 120.13 2006/09/15 21:44:21 jinwang noship $ */
3:
4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_PDOI_PRICE_DIFF_PROCESS_PVT');
6:
7: --------------------------------------------------------------------------
8: ---------------------- PRIVATE PROCEDURES PROTOTYPE ----------------------
9: --------------------------------------------------------------------------

Line 54: IF (PO_LOG.d_proc) THEN

50:
51: BEGIN
52: d_position := 0;
53:
54: IF (PO_LOG.d_proc) THEN
55: PO_LOG.proc_begin(d_module, 'p_max_intf_price_diff_id',
56: p_max_intf_price_diff_id);
57: END IF;
58:

Line 55: PO_LOG.proc_begin(d_module, 'p_max_intf_price_diff_id',

51: BEGIN
52: d_position := 0;
53:
54: IF (PO_LOG.d_proc) THEN
55: PO_LOG.proc_begin(d_module, 'p_max_intf_price_diff_id',
56: p_max_intf_price_diff_id);
57: END IF;
58:
59: OPEN x_price_diffs_csr FOR

Line 106: IF (PO_LOG.d_proc) THEN

102: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
103: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
104: ORDER BY intf_price_diffs.price_diff_interface_id;
105:
106: IF (PO_LOG.d_proc) THEN
107: PO_LOG.proc_end (d_module);
108: END IF;
109:
110: EXCEPTION

Line 107: PO_LOG.proc_end (d_module);

103: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
104: ORDER BY intf_price_diffs.price_diff_interface_id;
105:
106: IF (PO_LOG.d_proc) THEN
107: PO_LOG.proc_end (d_module);
108: END IF;
109:
110: EXCEPTION
111: WHEN OTHERS THEN

Line 148: IF (PO_LOG.d_proc) THEN

144:
145: BEGIN
146: d_position := 0;
147:
148: IF (PO_LOG.d_proc) THEN
149: PO_LOG.proc_begin(d_module);
150: END IF;
151:
152: FETCH x_price_diffs_csr BULK COLLECT INTO

Line 149: PO_LOG.proc_begin(d_module);

145: BEGIN
146: d_position := 0;
147:
148: IF (PO_LOG.d_proc) THEN
149: PO_LOG.proc_begin(d_module);
150: END IF;
151:
152: FETCH x_price_diffs_csr BULK COLLECT INTO
153: x_price_diffs.intf_price_diff_id_tbl,

Line 178: IF (PO_LOG.d_proc) THEN

174: -- set initial value for error_flag
175: x_price_diffs.error_flag_tbl
176: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
177:
178: IF (PO_LOG.d_proc) THEN
179: PO_LOG.proc_end (d_module);
180: END IF;
181:
182: EXCEPTION

Line 179: PO_LOG.proc_end (d_module);

175: x_price_diffs.error_flag_tbl
176: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
177:
178: IF (PO_LOG.d_proc) THEN
179: PO_LOG.proc_end (d_module);
180: END IF;
181:
182: EXCEPTION
183: WHEN OTHERS THEN

Line 217: IF (PO_LOG.d_proc) THEN

213: d_position NUMBER;
214: BEGIN
215: d_position := 0;
216:
217: IF (PO_LOG.d_proc) THEN
218: PO_LOG.proc_begin(d_module);
219: END IF;
220:
221: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_DEFAULT);

Line 218: PO_LOG.proc_begin(d_module);

214: BEGIN
215: d_position := 0;
216:
217: IF (PO_LOG.d_proc) THEN
218: PO_LOG.proc_begin(d_module);
219: END IF;
220:
221: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_DEFAULT);
222:

Line 227: IF (PO_LOG.d_stmt) THEN

223: d_position := 10;
224:
225: FOR i IN 1..x_price_diffs.rec_count
226: LOOP
227: IF (PO_LOG.d_stmt) THEN
228: PO_LOG.stmt(d_module, d_position, 'index', i);
229: PO_LOG.stmt(d_module, d_position, 'line loc id',
230: x_price_diffs.loc_line_loc_id_tbl(i));
231: PO_LOG.stmt(d_module, d_position, 'po line id',

Line 228: PO_LOG.stmt(d_module, d_position, 'index', i);

224:
225: FOR i IN 1..x_price_diffs.rec_count
226: LOOP
227: IF (PO_LOG.d_stmt) THEN
228: PO_LOG.stmt(d_module, d_position, 'index', i);
229: PO_LOG.stmt(d_module, d_position, 'line loc id',
230: x_price_diffs.loc_line_loc_id_tbl(i));
231: PO_LOG.stmt(d_module, d_position, 'po line id',
232: x_price_diffs.ln_po_line_id_tbl(i));

Line 229: PO_LOG.stmt(d_module, d_position, 'line loc id',

225: FOR i IN 1..x_price_diffs.rec_count
226: LOOP
227: IF (PO_LOG.d_stmt) THEN
228: PO_LOG.stmt(d_module, d_position, 'index', i);
229: PO_LOG.stmt(d_module, d_position, 'line loc id',
230: x_price_diffs.loc_line_loc_id_tbl(i));
231: PO_LOG.stmt(d_module, d_position, 'po line id',
232: x_price_diffs.ln_po_line_id_tbl(i));
233: PO_LOG.stmt(d_module, d_position, 'entity type',

Line 231: PO_LOG.stmt(d_module, d_position, 'po line id',

227: IF (PO_LOG.d_stmt) THEN
228: PO_LOG.stmt(d_module, d_position, 'index', i);
229: PO_LOG.stmt(d_module, d_position, 'line loc id',
230: x_price_diffs.loc_line_loc_id_tbl(i));
231: PO_LOG.stmt(d_module, d_position, 'po line id',
232: x_price_diffs.ln_po_line_id_tbl(i));
233: PO_LOG.stmt(d_module, d_position, 'entity type',
234: x_price_diffs.entity_type_tbl(i));
235: PO_LOG.stmt(d_module, d_position, 'entity id',

Line 233: PO_LOG.stmt(d_module, d_position, 'entity type',

229: PO_LOG.stmt(d_module, d_position, 'line loc id',
230: x_price_diffs.loc_line_loc_id_tbl(i));
231: PO_LOG.stmt(d_module, d_position, 'po line id',
232: x_price_diffs.ln_po_line_id_tbl(i));
233: PO_LOG.stmt(d_module, d_position, 'entity type',
234: x_price_diffs.entity_type_tbl(i));
235: PO_LOG.stmt(d_module, d_position, 'entity id',
236: x_price_diffs.entity_id_tbl(i));
237: END IF;

Line 235: PO_LOG.stmt(d_module, d_position, 'entity id',

231: PO_LOG.stmt(d_module, d_position, 'po line id',
232: x_price_diffs.ln_po_line_id_tbl(i));
233: PO_LOG.stmt(d_module, d_position, 'entity type',
234: x_price_diffs.entity_type_tbl(i));
235: PO_LOG.stmt(d_module, d_position, 'entity id',
236: x_price_diffs.entity_id_tbl(i));
237: END IF;
238:
239: d_position := 20;

Line 308: IF (PO_LOG.d_proc) THEN

304: END LOOP;
305:
306: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_DEFAULT);
307:
308: IF (PO_LOG.d_proc) THEN
309: PO_LOG.proc_end (d_module);
310: END IF;
311:
312: EXCEPTION

Line 309: PO_LOG.proc_end (d_module);

305:
306: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_DEFAULT);
307:
308: IF (PO_LOG.d_proc) THEN
309: PO_LOG.proc_end (d_module);
310: END IF;
311:
312: EXCEPTION
313: WHEN OTHERS THEN

Line 357: IF (PO_LOG.d_proc) THEN

353:
354: BEGIN
355: d_position := 0;
356:
357: IF (PO_LOG.d_proc) THEN
358: PO_LOG.proc_begin(d_module);
359: END IF;
360:
361: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_VALIDATE);

Line 358: PO_LOG.proc_begin(d_module);

354: BEGIN
355: d_position := 0;
356:
357: IF (PO_LOG.d_proc) THEN
358: PO_LOG.proc_begin(d_module);
359: END IF;
360:
361: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_VALIDATE);
362:

Line 388: IF (PO_LOG.d_stmt) THEN

384:
385: d_position := 20;
386:
387: IF (l_result_type = po_validations.c_result_type_failure) THEN
388: IF (PO_LOG.d_stmt) THEN
389: PO_LOG.stmt(d_module, d_position, 'vaidate price diffs return failure');
390: END IF;
391:
392: PO_PDOI_ERR_UTL.process_val_type_errors

Line 389: PO_LOG.stmt(d_module, d_position, 'vaidate price diffs return failure');

385: d_position := 20;
386:
387: IF (l_result_type = po_validations.c_result_type_failure) THEN
388: IF (PO_LOG.d_stmt) THEN
389: PO_LOG.stmt(d_module, d_position, 'vaidate price diffs return failure');
390: END IF;
391:
392: PO_PDOI_ERR_UTL.process_val_type_errors
393: (

Line 409: IF (PO_LOG.d_stmt) THEN

405: );
406: END IF;
407:
408: IF l_result_type = po_validations.c_result_type_fatal THEN
409: IF (PO_LOG.d_stmt) THEN
410: PO_LOG.stmt(d_module, d_position, 'vaidate price diffs return fatal');
411: END IF;
412:
413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 410: PO_LOG.stmt(d_module, d_position, 'vaidate price diffs return fatal');

406: END IF;
407:
408: IF l_result_type = po_validations.c_result_type_fatal THEN
409: IF (PO_LOG.d_stmt) THEN
410: PO_LOG.stmt(d_module, d_position, 'vaidate price diffs return fatal');
411: END IF;
412:
413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
414: END IF;

Line 418: IF (PO_LOG.d_proc) THEN

414: END IF;
415:
416: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_VALIDATE);
417:
418: IF (PO_LOG.d_proc) THEN
419: PO_LOG.proc_end (d_module);
420: END IF;
421:
422: EXCEPTION

Line 419: PO_LOG.proc_end (d_module);

415:
416: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_VALIDATE);
417:
418: IF (PO_LOG.d_proc) THEN
419: PO_LOG.proc_end (d_module);
420: END IF;
421:
422: EXCEPTION
423: WHEN OTHERS THEN

Line 472: IF (PO_LOG.d_proc) THEN

468: l_intf_header_id NUMBER;
469: BEGIN
470: d_position := 0;
471:
472: IF (PO_LOG.d_proc) THEN
473: PO_LOG.proc_begin(d_module);
474: END IF;
475:
476: FOR i IN 1 .. x_price_diffs.intf_price_diff_id_tbl.COUNT LOOP

Line 473: PO_LOG.proc_begin(d_module);

469: BEGIN
470: d_position := 0;
471:
472: IF (PO_LOG.d_proc) THEN
473: PO_LOG.proc_begin(d_module);
474: END IF;
475:
476: FOR i IN 1 .. x_price_diffs.intf_price_diff_id_tbl.COUNT LOOP
477: l_index_tbl(x_price_diffs.intf_price_diff_id_tbl(i)) := i;

Line 494: IF (PO_LOG.d_stmt) THEN

490: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
491: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
492: d_position := 20;
493:
494: IF (PO_LOG.d_stmt) THEN
495: PO_LOG.stmt(d_module, d_position, 'after error tolerance exceeded, collect error on index', l_index);
496: END IF;
497:
498: -- collect price_diff_interface_ids to remove the errors from error intf table

Line 495: PO_LOG.stmt(d_module, d_position, 'after error tolerance exceeded, collect error on index', l_index);

491: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
492: d_position := 20;
493:
494: IF (PO_LOG.d_stmt) THEN
495: PO_LOG.stmt(d_module, d_position, 'after error tolerance exceeded, collect error on index', l_index);
496: END IF;
497:
498: -- collect price_diff_interface_ids to remove the errors from error intf table
499: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(x_price_diffs.intf_line_id_tbl(l_index))) THEN

Line 510: IF (PO_LOG.d_stmt) THEN

506: END IF;
507: ELSIF (x_results.result_type(i) = po_validations.c_result_type_failure) THEN
508: d_position := 40;
509:
510: IF (PO_LOG.d_stmt) THEN
511: PO_LOG.stmt(d_module, d_position, 'error on index', l_index);
512: END IF;
513:
514: x_price_diffs.error_flag_tbl(l_index) := FND_API.g_TRUE;

Line 511: PO_LOG.stmt(d_module, d_position, 'error on index', l_index);

507: ELSIF (x_results.result_type(i) = po_validations.c_result_type_failure) THEN
508: d_position := 40;
509:
510: IF (PO_LOG.d_stmt) THEN
511: PO_LOG.stmt(d_module, d_position, 'error on index', l_index);
512: END IF;
513:
514: x_price_diffs.error_flag_tbl(l_index) := FND_API.g_TRUE;
515:

Line 524: IF (PO_LOG.d_stmt) THEN

520: -- records
521: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(x_price_diffs.intf_line_id_tbl(l_index))) THEN
522: d_position := 50;
523:
524: IF (PO_LOG.d_stmt) THEN
525: PO_LOG.stmt(d_module, d_position, 'set error on line',
526: x_price_diffs.intf_line_id_tbl(l_index));
527: END IF;
528:

Line 525: PO_LOG.stmt(d_module, d_position, 'set error on line',

521: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(x_price_diffs.intf_line_id_tbl(l_index))) THEN
522: d_position := 50;
523:
524: IF (PO_LOG.d_stmt) THEN
525: PO_LOG.stmt(d_module, d_position, 'set error on line',
526: x_price_diffs.intf_line_id_tbl(l_index));
527: END IF;
528:
529: -- set corresponding line to ERROR

Line 541: IF (PO_LOG.d_stmt) THEN

537: IF (PO_PDOI_PARAMS.g_request.calling_module =
538: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
539: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines
540: = PO_PDOI_PARAMS.g_request.err_lines_tolerance) THEN
541: IF (PO_LOG.d_stmt) THEN
542: PO_LOG.stmt(d_module, d_position, 'threshold hit on line',
543: x_price_diffs.intf_line_id_tbl(l_index));
544: END IF;
545:

Line 542: PO_LOG.stmt(d_module, d_position, 'threshold hit on line',

538: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
539: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines
540: = PO_PDOI_PARAMS.g_request.err_lines_tolerance) THEN
541: IF (PO_LOG.d_stmt) THEN
542: PO_LOG.stmt(d_module, d_position, 'threshold hit on line',
543: x_price_diffs.intf_line_id_tbl(l_index));
544: END IF;
545:
546: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded := FND_API.g_TRUE;

Line 573: IF (PO_LOG.d_proc) THEN

569: AND interface_line_id = l_remove_err_line_tbl(i);
570:
571: d_position := 70;
572:
573: IF (PO_LOG.d_proc) THEN
574: PO_LOG.proc_end (d_module);
575: END IF;
576:
577: EXCEPTION

Line 574: PO_LOG.proc_end (d_module);

570:
571: d_position := 70;
572:
573: IF (PO_LOG.d_proc) THEN
574: PO_LOG.proc_end (d_module);
575: END IF;
576:
577: EXCEPTION
578: WHEN OTHERS THEN