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

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

1: PACKAGE BODY PO_PDOI_HEADER_GROUPING_PVT AS
2: /* $Header: PO_PDOI_HEADER_GROUPING_PVT.plb 120.10 2006/07/24 18:35:38 bao noship $ */
3:
4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_PDOI_HEADER_GROUPING_PVT');
6:
7: -------------------------------------------------------
8: ----------- PRIVATE PROCEDURES PROTOTYPE --------------
9: -------------------------------------------------------

Line 58: IF (PO_LOG.d_proc) THEN

54:
55: BEGIN
56: d_position := 0;
57:
58: IF (PO_LOG.d_proc) THEN
59: PO_LOG.proc_begin (d_module);
60: END IF;
61:
62: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_GROUPING);

Line 59: PO_LOG.proc_begin (d_module);

55: BEGIN
56: d_position := 0;
57:
58: IF (PO_LOG.d_proc) THEN
59: PO_LOG.proc_begin (d_module);
60: END IF;
61:
62: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_GROUPING);
63:

Line 100: IF (PO_LOG.d_proc) THEN

96: PO_PDOI_UTL.commit_work;
97:
98: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_GROUPING);
99:
100: IF (PO_LOG.d_proc) THEN
101: PO_LOG.proc_end (d_module);
102: END IF;
103:
104: EXCEPTION

Line 101: PO_LOG.proc_end (d_module);

97:
98: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_GROUPING);
99:
100: IF (PO_LOG.d_proc) THEN
101: PO_LOG.proc_end (d_module);
102: END IF;
103:
104: EXCEPTION
105: WHEN OTHERS THEN

Line 152: IF (PO_LOG.d_proc) THEN

148:
149: BEGIN
150: d_position := 0;
151:
152: IF (PO_LOG.d_proc) THEN
153: PO_LOG.proc_begin (d_module);
154: END IF;
155:
156: x_all_headers_processed := FND_API.G_FALSE;

Line 153: PO_LOG.proc_begin (d_module);

149: BEGIN
150: d_position := 0;
151:
152: IF (PO_LOG.d_proc) THEN
153: PO_LOG.proc_begin (d_module);
154: END IF;
155:
156: x_all_headers_processed := FND_API.G_FALSE;
157:

Line 161: IF (PO_LOG.d_stmt) THEN

157:
158: -- Increment round number
159: PO_PDOI_PARAMS.g_current_round_num := PO_PDOI_PARAMS.g_current_round_num + 1;
160:
161: IF (PO_LOG.d_stmt) THEN
162: PO_LOG.stmt(d_module, d_position, 'Current Round Number: ' ||
163: PO_PDOI_PARAMS.g_current_round_num);
164: END IF;
165:

Line 162: PO_LOG.stmt(d_module, d_position, 'Current Round Number: ' ||

158: -- Increment round number
159: PO_PDOI_PARAMS.g_current_round_num := PO_PDOI_PARAMS.g_current_round_num + 1;
160:
161: IF (PO_LOG.d_stmt) THEN
162: PO_LOG.stmt(d_module, d_position, 'Current Round Number: ' ||
163: PO_PDOI_PARAMS.g_current_round_num);
164: END IF;
165:
166: IF (PO_PDOI_PARAMS.g_original_doc_processed = FND_API.G_FALSE) THEN

Line 190: IF (PO_LOG.d_stmt) THEN

186: -- mark g_original_doc_processed to TRUE so that we won't process
187: -- NEW documents the next time we come here
188: PO_PDOI_PARAMS.g_original_doc_processed := FND_API.G_TRUE;
189:
190: IF (PO_LOG.d_stmt) THEN
191: PO_LOG.stmt(d_module, d_position, 'Finished progressing doc with ' ||
192: 'action = original ');
193: END IF;
194:

Line 191: PO_LOG.stmt(d_module, d_position, 'Finished progressing doc with ' ||

187: -- NEW documents the next time we come here
188: PO_PDOI_PARAMS.g_original_doc_processed := FND_API.G_TRUE;
189:
190: IF (PO_LOG.d_stmt) THEN
191: PO_LOG.stmt(d_module, d_position, 'Finished progressing doc with ' ||
192: 'action = original ');
193: END IF;
194:
195: -- IF there is no new doucment to create, we can go ahead and look for

Line 207: IF (PO_LOG.d_stmt) THEN

203: UPDATE po_headers_interface
204: SET processing_round_num = PO_PDOI_PARAMS.g_current_round_num
205: WHERE interface_header_id = l_intf_header_id_tbl(i);
206:
207: IF (PO_LOG.d_stmt) THEN
208: PO_LOG.stmt(d_module, d_position, 'updated ' || SQL%ROWCOUNT ||
209: 'rows with current round number ');
210: END IF;
211: END IF;

Line 208: PO_LOG.stmt(d_module, d_position, 'updated ' || SQL%ROWCOUNT ||

204: SET processing_round_num = PO_PDOI_PARAMS.g_current_round_num
205: WHERE interface_header_id = l_intf_header_id_tbl(i);
206:
207: IF (PO_LOG.d_stmt) THEN
208: PO_LOG.stmt(d_module, d_position, 'updated ' || SQL%ROWCOUNT ||
209: 'rows with current round number ');
210: END IF;
211: END IF;
212:

Line 253: IF (PO_LOG.d_stmt) THEN

249: l_process_list(l_po_header_id_tbl(i)) := l_intf_header_id_tbl(i);
250: END IF;
251:
252: IF (l_process_list.COUNT >= PO_PDOI_PARAMS.g_request.batch_size) THEN
253: IF (PO_LOG.d_stmt) THEN
254: PO_LOG.stmt(d_module, d_position, '# of documents to process has ' ||
255: 'reached the limit. Wait for the next round');
256: END IF;
257:

Line 254: PO_LOG.stmt(d_module, d_position, '# of documents to process has ' ||

250: END IF;
251:
252: IF (l_process_list.COUNT >= PO_PDOI_PARAMS.g_request.batch_size) THEN
253: IF (PO_LOG.d_stmt) THEN
254: PO_LOG.stmt(d_module, d_position, '# of documents to process has ' ||
255: 'reached the limit. Wait for the next round');
256: END IF;
257:
258: -- exit the loop if the number of document to process exceeds

Line 273: IF (PO_LOG.d_stmt) THEN

269: UPDATE po_headers_interface
270: SET processing_round_num = PO_PDOI_PARAMS.g_current_round_num
271: WHERE interface_header_id = l_process_list(i);
272:
273: IF (PO_LOG.d_stmt) THEN
274: PO_LOG.stmt(d_module, d_position, 'updated ' || SQL%ROWCOUNT ||
275: 'rows with current round number ');
276: END IF;
277:

Line 274: PO_LOG.stmt(d_module, d_position, 'updated ' || SQL%ROWCOUNT ||

270: SET processing_round_num = PO_PDOI_PARAMS.g_current_round_num
271: WHERE interface_header_id = l_process_list(i);
272:
273: IF (PO_LOG.d_stmt) THEN
274: PO_LOG.stmt(d_module, d_position, 'updated ' || SQL%ROWCOUNT ||
275: 'rows with current round number ');
276: END IF;
277:
278: ELSE

Line 280: IF (PO_LOG.d_stmt) THEN

276: END IF;
277:
278: ELSE
279:
280: IF (PO_LOG.d_stmt) THEN
281: PO_LOG.stmt(d_module, d_position, '** No more doc to process ***');
282: END IF;
283:
284: x_all_headers_processed := FND_API.G_TRUE;

Line 281: PO_LOG.stmt(d_module, d_position, ' No more doc to process *');

277:
278: ELSE
279:
280: IF (PO_LOG.d_stmt) THEN
281: PO_LOG.stmt(d_module, d_position, '** No more doc to process ***');
282: END IF;
283:
284: x_all_headers_processed := FND_API.G_TRUE;
285: END IF;

Line 289: IF (PO_LOG.d_proc) THEN

285: END IF;
286:
287: END IF;
288:
289: IF (PO_LOG.d_proc) THEN
290: PO_LOG.proc_end (d_module);
291: END IF;
292:
293: EXCEPTION

Line 290: PO_LOG.proc_end (d_module);

286:
287: END IF;
288:
289: IF (PO_LOG.d_proc) THEN
290: PO_LOG.proc_end (d_module);
291: END IF;
292:
293: EXCEPTION
294: WHEN OTHERS THEN

Line 351: IF (PO_LOG.d_proc) THEN

347: l_intf_hdr_id NUMBER; -- bug5129752
348: BEGIN
349: d_position := 0;
350:
351: IF (PO_LOG.d_proc) THEN
352: PO_LOG.proc_begin (d_module);
353: END IF;
354:
355: --SQL What: get all records that will be processed in current round. It also

Line 352: PO_LOG.proc_begin (d_module);

348: BEGIN
349: d_position := 0;
350:
351: IF (PO_LOG.d_proc) THEN
352: PO_LOG.proc_begin (d_module);
353: END IF;
354:
355: --SQL What: get all records that will be processed in current round. It also
356: -- locks the po_Headers of documents that are being updated

Line 405: IF (PO_LOG.d_stmt) THEN

401:
402: d_position := 30;
403:
404: IF (l_tmp_draft_id IS NULL) THEN
405: IF (PO_LOG.d_stmt) THEN
406: PO_LOG.stmt(d_module, d_position, 'draft id not found');
407: END IF;
408:
409: d_position := 40;

Line 406: PO_LOG.stmt(d_module, d_position, 'draft id not found');

402: d_position := 30;
403:
404: IF (l_tmp_draft_id IS NULL) THEN
405: IF (PO_LOG.d_stmt) THEN
406: PO_LOG.stmt(d_module, d_position, 'draft id not found');
407: END IF;
408:
409: d_position := 40;
410:

Line 422: IF (PO_LOG.d_stmt) THEN

418: PO_DRAFTS_PVT.g_status_PDOI_ERROR)) THEN
419:
420: d_position := 50;
421:
422: IF (PO_LOG.d_stmt) THEN
423: PO_LOG.stmt(d_module, d_position, 'existing draft is processed ' ||
424: 'by PDOI. check whether the previous PDOI is still ' ||
425: 'working on it');
426: END IF;

Line 423: PO_LOG.stmt(d_module, d_position, 'existing draft is processed ' ||

419:
420: d_position := 50;
421:
422: IF (PO_LOG.d_stmt) THEN
423: PO_LOG.stmt(d_module, d_position, 'existing draft is processed ' ||
424: 'by PDOI. check whether the previous PDOI is still ' ||
425: 'working on it');
426: END IF;
427:

Line 443: IF (PO_LOG.d_stmt) THEN

439:
440: IF (l_new_draft_needed = FND_API.G_TRUE) THEN
441: d_position := 70;
442:
443: IF (PO_LOG.d_stmt) THEN
444: PO_LOG.stmt(d_module, d_position, 'old draft can be removed. ' ||
445: 'Creating a new one');
446: END IF;
447:

Line 444: PO_LOG.stmt(d_module, d_position, 'old draft can be removed. ' ||

440: IF (l_new_draft_needed = FND_API.G_TRUE) THEN
441: d_position := 70;
442:
443: IF (PO_LOG.d_stmt) THEN
444: PO_LOG.stmt(d_module, d_position, 'old draft can be removed. ' ||
445: 'Creating a new one');
446: END IF;
447:
448: PO_DRAFTS_PVT.remove_draft_changes

Line 461: IF (PO_LOG.d_stmt) THEN

457: l_draft_id_tbl(i) := PO_DRAFTS_PVT.draft_id_nextval;
458: ELSE
459: d_position := 80;
460:
461: IF (PO_LOG.d_stmt) THEN
462: PO_LOG.stmt(d_module, d_position, 'old draft is still being ' ||
463: 'worked on. Fail the current intf record');
464: END IF;
465:

Line 462: PO_LOG.stmt(d_module, d_position, 'old draft is still being ' ||

458: ELSE
459: d_position := 80;
460:
461: IF (PO_LOG.d_stmt) THEN
462: PO_LOG.stmt(d_module, d_position, 'old draft is still being ' ||
463: 'worked on. Fail the current intf record');
464: END IF;
465:
466: PO_PDOI_ERR_UTL.add_fatal_error

Line 484: IF (PO_LOG.d_stmt) THEN

480: ELSE
481:
482: d_position := 90;
483:
484: IF (PO_LOG.d_stmt) THEN
485: PO_LOG.stmt(d_module, d_position, 'draft with id ' ||
486: l_tmp_draft_id || ' can be reused.');
487: END IF;
488:

Line 485: PO_LOG.stmt(d_module, d_position, 'draft with id ' ||

481:
482: d_position := 90;
483:
484: IF (PO_LOG.d_stmt) THEN
485: PO_LOG.stmt(d_module, d_position, 'draft with id ' ||
486: l_tmp_draft_id || ' can be reused.');
487: END IF;
488:
489: -- other draft status -- reuse the draft

Line 575: IF (PO_LOG.d_stmt) THEN

571: END LOOP;
572:
573: d_position := 150;
574:
575: IF (PO_LOG.d_stmt) THEN
576: PO_LOG.stmt(d_module, d_position,
577: 'Number of existing drafts: ' || l_existing_dft_idx_tbl.COUNT);
578: END IF;
579:

Line 576: PO_LOG.stmt(d_module, d_position,

572:
573: d_position := 150;
574:
575: IF (PO_LOG.d_stmt) THEN
576: PO_LOG.stmt(d_module, d_position,
577: 'Number of existing drafts: ' || l_existing_dft_idx_tbl.COUNT);
578: END IF;
579:
580: -- Since DB 10g has probems using VALUES OF against EMPTYCOLLECTION,

Line 596: IF (PO_LOG.d_proc) THEN

592: last_updated_by = FND_GLOBAL.user_id
593: WHERE draft_id = l_draft_id_tbl(i);
594: END IF;
595:
596: IF (PO_LOG.d_proc) THEN
597: PO_LOG.proc_end (d_module);
598: END IF;
599:
600: EXCEPTION

Line 597: PO_LOG.proc_end (d_module);

593: WHERE draft_id = l_draft_id_tbl(i);
594: END IF;
595:
596: IF (PO_LOG.d_proc) THEN
597: PO_LOG.proc_end (d_module);
598: END IF;
599:
600: EXCEPTION
601: WHEN OTHERS THEN

Line 635: IF (PO_LOG.d_proc) THEN

631: l_record_exist_tbl PO_TBL_VARCHAR1;
632: BEGIN
633: d_position := 0;
634:
635: IF (PO_LOG.d_proc) THEN
636: PO_LOG.proc_begin (d_module);
637: END IF;
638:
639: --SQL What: Get all the existing lines that match the category name given

Line 636: PO_LOG.proc_begin (d_module);

632: BEGIN
633: d_position := 0;
634:
635: IF (PO_LOG.d_proc) THEN
636: PO_LOG.proc_begin (d_module);
637: END IF;
638:
639: --SQL What: Get all the existing lines that match the category name given
640: -- Make sure that the lines are not cancelled, closed or expired

Line 657: IF (PO_LOG.d_stmt) THEN

653: AND NVL(POL.cancel_flag, 'N') = 'N'
654: AND NVL(POL.closed_code, 'OPEN') <> 'FINALLY CLOSED'
655: AND NVL(POL.expiration_date, SYSDATE+1) > SYSDATE;
656:
657: IF (PO_LOG.d_stmt) THEN
658: PO_LOG.stmt(d_module, d_position, 'Number of lines to expire',
659: l_line_id_tbl.COUNT);
660: END IF;
661:

Line 658: PO_LOG.stmt(d_module, d_position, 'Number of lines to expire',

654: AND NVL(POL.closed_code, 'OPEN') <> 'FINALLY CLOSED'
655: AND NVL(POL.expiration_date, SYSDATE+1) > SYSDATE;
656:
657: IF (PO_LOG.d_stmt) THEN
658: PO_LOG.stmt(d_module, d_position, 'Number of lines to expire',
659: l_line_id_tbl.COUNT);
660: END IF;
661:
662: IF (l_line_id_tbl.COUNT > 0) THEN

Line 686: IF (PO_LOG.d_proc) THEN

682: AND draft_id = l_draft_id_tbl(i);
683:
684: END IF;
685:
686: IF (PO_LOG.d_proc) THEN
687: PO_LOG.proc_end (d_module);
688: END IF;
689:
690: EXCEPTION

Line 687: PO_LOG.proc_end (d_module);

683:
684: END IF;
685:
686: IF (PO_LOG.d_proc) THEN
687: PO_LOG.proc_end (d_module);
688: END IF;
689:
690: EXCEPTION
691: WHEN OTHERS THEN

Line 731: IF (PO_LOG.d_proc) THEN

727:
728: BEGIN
729: d_position := 0;
730:
731: IF (PO_LOG.d_proc) THEN
732: PO_LOG.proc_begin (d_module);
733: END IF;
734:
735: PO_PDOI_PARAMS.g_docs_info.DELETE;

Line 732: PO_LOG.proc_begin (d_module);

728: BEGIN
729: d_position := 0;
730:
731: IF (PO_LOG.d_proc) THEN
732: PO_LOG.proc_begin (d_module);
733: END IF;
734:
735: PO_PDOI_PARAMS.g_docs_info.DELETE;
736:

Line 763: IF (PO_LOG.d_proc) THEN

759: PO_PDOI_PARAMS.g_docs_info(l_id).has_lines_to_notify := FND_API.G_FALSE;
760: PO_PDOI_PARAMS.g_docs_info(l_id).new_draft := FND_API.G_FALSE; -- bug5129752
761: END LOOP;
762:
763: IF (PO_LOG.d_proc) THEN
764: PO_LOG.proc_end (d_module);
765: END IF;
766:
767: EXCEPTION

Line 764: PO_LOG.proc_end (d_module);

760: PO_PDOI_PARAMS.g_docs_info(l_id).new_draft := FND_API.G_FALSE; -- bug5129752
761: END LOOP;
762:
763: IF (PO_LOG.d_proc) THEN
764: PO_LOG.proc_end (d_module);
765: END IF;
766:
767: EXCEPTION
768: WHEN OTHERS THEN

Line 815: IF (PO_LOG.d_proc) THEN

811:
812: BEGIN
813: d_position := 0;
814:
815: IF (PO_LOG.d_proc) THEN
816: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);
817: PO_LOG.proc_begin (d_module, 'p_status', p_status);
818: END IF;
819:

Line 816: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);

812: BEGIN
813: d_position := 0;
814:
815: IF (PO_LOG.d_proc) THEN
816: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);
817: PO_LOG.proc_begin (d_module, 'p_status', p_status);
818: END IF;
819:
820: x_new_draft_needed := FND_API.G_FALSE;

Line 817: PO_LOG.proc_begin (d_module, 'p_status', p_status);

813: d_position := 0;
814:
815: IF (PO_LOG.d_proc) THEN
816: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);
817: PO_LOG.proc_begin (d_module, 'p_status', p_status);
818: END IF;
819:
820: x_new_draft_needed := FND_API.G_FALSE;
821:

Line 843: IF (PO_LOG.d_proc) THEN

839: );
840:
841: END IF; -- if status = p_status = PO_DRAFTS_PVT.g_status_PDOI_ERROR
842:
843: IF (PO_LOG.d_proc) THEN
844: PO_LOG.proc_end (d_module, 'x_new_draft_needed', x_new_draft_needed);
845: END IF;
846:
847: EXCEPTION

Line 844: PO_LOG.proc_end (d_module, 'x_new_draft_needed', x_new_draft_needed);

840:
841: END IF; -- if status = p_status = PO_DRAFTS_PVT.g_status_PDOI_ERROR
842:
843: IF (PO_LOG.d_proc) THEN
844: PO_LOG.proc_end (d_module, 'x_new_draft_needed', x_new_draft_needed);
845: END IF;
846:
847: EXCEPTION
848: WHEN OTHERS THEN