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

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

1: PACKAGE BODY PO_PRICE_ADJ_DRAFT_PKG AS
2: /* $Header: PO_PRICE_ADJ_DRAFT_PKG.plb 120.0.12010000.1 2009/06/01 23:30:02 ababujan noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_PRICE_ADJ_DRAFT_PKG');
6:
7: -----------------------------------------------------------------------
8: --Start of Comments
9: --Name: delete_rows

Line 44: IF (PO_LOG.d_proc) THEN

40: d_position NUMBER;
41:
42: BEGIN
43: d_position := 0;
44: IF (PO_LOG.d_proc) THEN
45: PO_LOG.proc_begin(d_module);
46: END IF;
47:
48: DELETE FROM po_price_adj_attribs_draft

Line 45: PO_LOG.proc_begin(d_module);

41:
42: BEGIN
43: d_position := 0;
44: IF (PO_LOG.d_proc) THEN
45: PO_LOG.proc_begin(d_module);
46: END IF;
47:
48: DELETE FROM po_price_adj_attribs_draft
49: WHERE draft_id = p_draft_id

Line 111: IF (PO_LOG.d_proc) THEN

107: l_duplicate_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
108:
109: BEGIN
110: d_position := 0;
111: IF (PO_LOG.d_proc) THEN
112: PO_LOG.proc_begin(d_module);
113: END IF;
114:
115: x_record_already_exist_tbl :=

Line 112: PO_LOG.proc_begin(d_module);

108:
109: BEGIN
110: d_position := 0;
111: IF (PO_LOG.d_proc) THEN
112: PO_LOG.proc_begin(d_module);
113: END IF;
114:
115: x_record_already_exist_tbl :=
116: PO_PRICE_ADJ_DRAFT_PVT.draft_changes_exist

Line 141: IF (PO_LOG.d_stmt) THEN

137: END IF;
138: END LOOP;
139:
140: d_position := 10;
141: IF (PO_LOG.d_stmt) THEN
142: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
143: END IF;
144:
145: FORALL i IN 1..p_price_adjustment_id_tbl.COUNT

Line 142: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');

138: END LOOP;
139:
140: d_position := 10;
141: IF (PO_LOG.d_stmt) THEN
142: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
143: END IF;
144:
145: FORALL i IN 1..p_price_adjustment_id_tbl.COUNT
146: INSERT INTO PO_PRICE_ADJUSTMENTS_DRAFT

Line 352: IF (PO_LOG.d_stmt) THEN

348: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
349: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
350:
351: d_position := 20;
352: IF (PO_LOG.d_stmt) THEN
353: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
354: END IF;
355:
356: FORALL i IN 1..p_price_adjustment_id_tbl.COUNT

Line 353: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

349: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
350:
351: d_position := 20;
352: IF (PO_LOG.d_stmt) THEN
353: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
354: END IF;
355:
356: FORALL i IN 1..p_price_adjustment_id_tbl.COUNT
357: UPDATE po_price_adjustments_draft

Line 366: IF (PO_LOG.d_stmt) THEN

362: AND NVL(delete_flag, 'N') <> 'Y'
363: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
364:
365: d_position := 30;
366: IF (PO_LOG.d_stmt) THEN
367: PO_LOG.stmt(d_module, d_position, 'update draft records that are already' ||
368: ' in draft table. Count = ' || SQL%ROWCOUNT);
369: END IF;
370:

Line 367: PO_LOG.stmt(d_module, d_position, 'update draft records that are already' ||

363: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
364:
365: d_position := 30;
366: IF (PO_LOG.d_stmt) THEN
367: PO_LOG.stmt(d_module, d_position, 'update draft records that are already' ||
368: ' in draft table. Count = ' || SQL%ROWCOUNT);
369: END IF;
370:
371: --No Need to update the price adjustment attributes if already found in draft table

Line 419: IF (PO_LOG.d_stmt) THEN

415: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
416: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
417:
418: d_position := 40;
419: IF (PO_LOG.d_stmt) THEN
420: PO_LOG.stmt(d_module, d_position, 'Attribute records transfer count = ' || SQL%ROWCOUNT);
421: END IF;
422:
423: d_position := 50;

Line 420: PO_LOG.stmt(d_module, d_position, 'Attribute records transfer count = ' || SQL%ROWCOUNT);

416: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
417:
418: d_position := 40;
419: IF (PO_LOG.d_stmt) THEN
420: PO_LOG.stmt(d_module, d_position, 'Attribute records transfer count = ' || SQL%ROWCOUNT);
421: END IF;
422:
423: d_position := 50;
424: IF (PO_LOG.d_proc) THEN

Line 424: IF (PO_LOG.d_proc) THEN

420: PO_LOG.stmt(d_module, d_position, 'Attribute records transfer count = ' || SQL%ROWCOUNT);
421: END IF;
422:
423: d_position := 50;
424: IF (PO_LOG.d_proc) THEN
425: PO_LOG.proc_end(d_module);
426: END IF;
427:
428: EXCEPTION

Line 425: PO_LOG.proc_end(d_module);

421: END IF;
422:
423: d_position := 50;
424: IF (PO_LOG.d_proc) THEN
425: PO_LOG.proc_end(d_module);
426: END IF;
427:
428: EXCEPTION
429: WHEN OTHERS THEN

Line 478: IF (PO_LOG.d_proc) THEN

474:
475: l_record_already_exist_tbl PO_TBL_VARCHAR1;
476: BEGIN
477: d_position := 0;
478: IF (PO_LOG.d_proc) THEN
479: PO_LOG.proc_begin(d_module);
480: PO_LOG.proc_begin(d_module, 'p_price_adjustment_id', p_price_adjustment_id);
481: END IF;
482:

Line 479: PO_LOG.proc_begin(d_module);

475: l_record_already_exist_tbl PO_TBL_VARCHAR1;
476: BEGIN
477: d_position := 0;
478: IF (PO_LOG.d_proc) THEN
479: PO_LOG.proc_begin(d_module);
480: PO_LOG.proc_begin(d_module, 'p_price_adjustment_id', p_price_adjustment_id);
481: END IF;
482:
483: sync_draft_from_txn

Line 480: PO_LOG.proc_begin(d_module, 'p_price_adjustment_id', p_price_adjustment_id);

476: BEGIN
477: d_position := 0;
478: IF (PO_LOG.d_proc) THEN
479: PO_LOG.proc_begin(d_module);
480: PO_LOG.proc_begin(d_module, 'p_price_adjustment_id', p_price_adjustment_id);
481: END IF;
482:
483: sync_draft_from_txn
484: ( p_price_adjustment_id_tbl => PO_TBL_NUMBER(p_price_adjustment_id),

Line 493: IF (PO_LOG.d_proc) THEN

489:
490: x_record_already_exist := l_record_already_exist_tbl(1);
491:
492: d_position := 10;
493: IF (PO_LOG.d_proc) THEN
494: PO_LOG.proc_end(d_module);
495: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
496: END IF;
497:

Line 494: PO_LOG.proc_end(d_module);

490: x_record_already_exist := l_record_already_exist_tbl(1);
491:
492: d_position := 10;
493: IF (PO_LOG.d_proc) THEN
494: PO_LOG.proc_end(d_module);
495: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
496: END IF;
497:
498: EXCEPTION

Line 495: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);

491:
492: d_position := 10;
493: IF (PO_LOG.d_proc) THEN
494: PO_LOG.proc_end(d_module);
495: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
496: END IF;
497:
498: EXCEPTION
499: WHEN OTHERS THEN

Line 550: IF (PO_LOG.d_proc) THEN

546: l_delete_flag_tbl PO_TBL_VARCHAR1;
547:
548: BEGIN
549: d_position := 0;
550: IF (PO_LOG.d_proc) THEN
551: PO_LOG.proc_begin(d_module);
552: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
553: PO_LOG.proc_begin(d_module, 'p_order_header_id', p_order_header_id);
554: PO_LOG.proc_begin(d_module, 'p_order_line_id', p_order_line_id);

Line 551: PO_LOG.proc_begin(d_module);

547:
548: BEGIN
549: d_position := 0;
550: IF (PO_LOG.d_proc) THEN
551: PO_LOG.proc_begin(d_module);
552: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
553: PO_LOG.proc_begin(d_module, 'p_order_header_id', p_order_header_id);
554: PO_LOG.proc_begin(d_module, 'p_order_line_id', p_order_line_id);
555: PO_LOG.proc_begin(d_module, 'p_delete_flag', p_delete_flag);

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

548: BEGIN
549: d_position := 0;
550: IF (PO_LOG.d_proc) THEN
551: PO_LOG.proc_begin(d_module);
552: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
553: PO_LOG.proc_begin(d_module, 'p_order_header_id', p_order_header_id);
554: PO_LOG.proc_begin(d_module, 'p_order_line_id', p_order_line_id);
555: PO_LOG.proc_begin(d_module, 'p_delete_flag', p_delete_flag);
556: END IF;

Line 553: PO_LOG.proc_begin(d_module, 'p_order_header_id', p_order_header_id);

549: d_position := 0;
550: IF (PO_LOG.d_proc) THEN
551: PO_LOG.proc_begin(d_module);
552: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
553: PO_LOG.proc_begin(d_module, 'p_order_header_id', p_order_header_id);
554: PO_LOG.proc_begin(d_module, 'p_order_line_id', p_order_line_id);
555: PO_LOG.proc_begin(d_module, 'p_delete_flag', p_delete_flag);
556: END IF;
557:

Line 554: PO_LOG.proc_begin(d_module, 'p_order_line_id', p_order_line_id);

550: IF (PO_LOG.d_proc) THEN
551: PO_LOG.proc_begin(d_module);
552: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
553: PO_LOG.proc_begin(d_module, 'p_order_header_id', p_order_header_id);
554: PO_LOG.proc_begin(d_module, 'p_order_line_id', p_order_line_id);
555: PO_LOG.proc_begin(d_module, 'p_delete_flag', p_delete_flag);
556: END IF;
557:
558: --Get all price_adjustment_ids under the order line id

Line 555: PO_LOG.proc_begin(d_module, 'p_delete_flag', p_delete_flag);

551: PO_LOG.proc_begin(d_module);
552: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
553: PO_LOG.proc_begin(d_module, 'p_order_header_id', p_order_header_id);
554: PO_LOG.proc_begin(d_module, 'p_order_line_id', p_order_line_id);
555: PO_LOG.proc_begin(d_module, 'p_delete_flag', p_delete_flag);
556: END IF;
557:
558: --Get all price_adjustment_ids under the order line id
559: SELECT ADJ.price_adjustment_id

Line 578: IF (PO_LOG.d_proc) THEN

574: );
575: --x_record_already_exist := l_record_already_exist_tbl(1);
576:
577: d_position := 10;
578: IF (PO_LOG.d_proc) THEN
579: PO_LOG.proc_end(d_module);
580: --PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
581: END IF;
582:

Line 579: PO_LOG.proc_end(d_module);

575: --x_record_already_exist := l_record_already_exist_tbl(1);
576:
577: d_position := 10;
578: IF (PO_LOG.d_proc) THEN
579: PO_LOG.proc_end(d_module);
580: --PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
581: END IF;
582:
583: EXCEPTION

Line 580: --PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);

576:
577: d_position := 10;
578: IF (PO_LOG.d_proc) THEN
579: PO_LOG.proc_end(d_module);
580: --PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
581: END IF;
582:
583: EXCEPTION
584: WHEN OTHERS THEN

Line 628: IF (PO_LOG.d_proc) THEN

624: l_price_adjustment_id_tbl NUMBER_TYPE;
625: BEGIN
626:
627: d_position := 0;
628: IF (PO_LOG.d_proc) THEN
629: PO_LOG.proc_begin(d_module);
630: END IF;
631:
632: -- Since putting DELETE within MERGE statement is causing database

Line 629: PO_LOG.proc_begin(d_module);

625: BEGIN
626:
627: d_position := 0;
628: IF (PO_LOG.d_proc) THEN
629: PO_LOG.proc_begin(d_module);
630: END IF;
631:
632: -- Since putting DELETE within MERGE statement is causing database
633: -- to thrown internal error, for now we just separate the DELETE statement.

Line 1115: IF (PO_LOG.d_stmt) THEN

1111: AND NVL(ADJD.delete_flag, 'N') <> 'Y'
1112: AND NVL(ADJD.change_accepted_flag, 'Y') = 'Y';
1113:
1114: d_position := 40;
1115: IF (PO_LOG.d_stmt) THEN
1116: PO_LOG.stmt(d_module, d_position, 'Attribute records transfer count = ' || SQL%ROWCOUNT);
1117: END IF;
1118:
1119: d_position := 50;

Line 1116: PO_LOG.stmt(d_module, d_position, 'Attribute records transfer count = ' || SQL%ROWCOUNT);

1112: AND NVL(ADJD.change_accepted_flag, 'Y') = 'Y';
1113:
1114: d_position := 40;
1115: IF (PO_LOG.d_stmt) THEN
1116: PO_LOG.stmt(d_module, d_position, 'Attribute records transfer count = ' || SQL%ROWCOUNT);
1117: END IF;
1118:
1119: d_position := 50;
1120: EXCEPTION

Line 1156: IF (PO_LOG.d_proc) THEN

1152: l_dummy NUMBER;
1153:
1154: BEGIN
1155: d_position := 0;
1156: IF (PO_LOG.d_proc) THEN
1157: PO_LOG.proc_begin(d_module);
1158: END IF;
1159:
1160: SELECT 1

Line 1157: PO_LOG.proc_begin(d_module);

1153:
1154: BEGIN
1155: d_position := 0;
1156: IF (PO_LOG.d_proc) THEN
1157: PO_LOG.proc_begin(d_module);
1158: END IF;
1159:
1160: SELECT 1
1161: INTO l_dummy

Line 1167: IF (PO_LOG.d_proc) THEN

1163: WHERE price_adjustment_id = p_price_adjustment_id
1164: AND draft_id = p_draft_id
1165: FOR UPDATE NOWAIT;
1166:
1167: IF (PO_LOG.d_proc) THEN
1168: PO_LOG.proc_end(d_module);
1169: END IF;
1170:
1171: EXCEPTION

Line 1168: PO_LOG.proc_end(d_module);

1164: AND draft_id = p_draft_id
1165: FOR UPDATE NOWAIT;
1166:
1167: IF (PO_LOG.d_proc) THEN
1168: PO_LOG.proc_end(d_module);
1169: END IF;
1170:
1171: EXCEPTION
1172: WHEN NO_DATA_FOUND THEN

Line 1200: IF (PO_LOG.d_proc) THEN

1196: l_dummy NUMBER;
1197:
1198: BEGIN
1199: d_position := 0;
1200: IF (PO_LOG.d_proc) THEN
1201: PO_LOG.proc_begin(d_module);
1202: END IF;
1203:
1204: SELECT 1

Line 1201: PO_LOG.proc_begin(d_module);

1197:
1198: BEGIN
1199: d_position := 0;
1200: IF (PO_LOG.d_proc) THEN
1201: PO_LOG.proc_begin(d_module);
1202: END IF;
1203:
1204: SELECT 1
1205: INTO l_dummy

Line 1210: IF (PO_LOG.d_proc) THEN

1206: FROM po_price_adjustments
1207: WHERE price_adjustment_id = p_price_adjustment_id
1208: FOR UPDATE NOWAIT;
1209:
1210: IF (PO_LOG.d_proc) THEN
1211: PO_LOG.proc_end(d_module);
1212: END IF;
1213:
1214: EXCEPTION

Line 1211: PO_LOG.proc_end(d_module);

1207: WHERE price_adjustment_id = p_price_adjustment_id
1208: FOR UPDATE NOWAIT;
1209:
1210: IF (PO_LOG.d_proc) THEN
1211: PO_LOG.proc_end(d_module);
1212: END IF;
1213:
1214: EXCEPTION
1215: WHEN NO_DATA_FOUND THEN