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.POA_SAVINGS_NP dependencies on POA_LOG

Line 163: POA_LOG.debug_line('Populate_noncontract: entered');

159: );
160:
161: BEGIN
162:
163: POA_LOG.debug_line('Populate_noncontract: entered');
164: POA_LOG.debug_line(' ');
165:
166:
167: /* Delete from poa_bis_savings all rows which will is approved

Line 164: POA_LOG.debug_line(' ');

160:
161: BEGIN
162:
163: POA_LOG.debug_line('Populate_noncontract: entered');
164: POA_LOG.debug_line(' ');
165:
166:
167: /* Delete from poa_bis_savings all rows which will is approved
168: * and was modified in the date range specified.

Line 592: POA_LOG.debug_line('Opening cursor c_std_po');

588: /* Go through all the rows which we considered as leakages to
589: * calculate their potential savings
590: */
591:
592: POA_LOG.debug_line('Opening cursor c_std_po');
593: POA_LOG.debug_line(' ');
594:
595: select sysdate into l_start_time from dual;
596: begin

Line 593: POA_LOG.debug_line(' ');

589: * calculate their potential savings
590: */
591:
592: POA_LOG.debug_line('Opening cursor c_std_po');
593: POA_LOG.debug_line(' ');
594:
595: select sysdate into l_start_time from dual;
596: begin
597: select warehouse_currency_code,

Line 658: -- POA_LOG.debug_line('Lowest price determined using: creation_date=' ||

654: * get_currency_conv_rate(v_edw_global_currency_code,
655: v_currency_code,
656: v_rate_date,
657: v_edw_global_rate_type);
658: -- POA_LOG.debug_line('Lowest price determined using: creation_date=' ||
659: -- v_creation_date || ', quantity=' ||
660: -- v_quantity || ', unit of measure=' ||
661: -- v_unit_meas_lookup_code || ', currency=' ||
662: -- v_currency_code || ', item id=' ||

Line 667: -- POA_LOG.debug_line(' ');

663: -- v_item_id || ', item revision=' ||
664: -- v_item_revision || ', category id=' ||
665: -- v_category_id || ', ship to location_id=' ||
666: -- v_ship_to_location_id);
667: -- POA_LOG.debug_line(' ');
668:
669: poa_savings_np.insert_npcontract(v_po_distribution_id,
670: v_lowest_possible_price, p_start_time);
671:

Line 672: -- POA_LOG.debug_line('Inserting np contract for distribution_id=' ||

668:
669: poa_savings_np.insert_npcontract(v_po_distribution_id,
670: v_lowest_possible_price, p_start_time);
671:
672: -- POA_LOG.debug_line('Inserting np contract for distribution_id=' ||
673: -- v_po_distribution_id || ', lowest possible price=' ||
674: -- v_lowest_possible_price);
675: -- POA_LOG.debug_line(' ');
676:

Line 675: -- POA_LOG.debug_line(' ');

671:
672: -- POA_LOG.debug_line('Inserting np contract for distribution_id=' ||
673: -- v_po_distribution_id || ', lowest possible price=' ||
674: -- v_lowest_possible_price);
675: -- POA_LOG.debug_line(' ');
676:
677: END LOOP;
678:
679: select sysdate into l_end_time from dual;

Line 680: POA_LOG.put_line('Populate_npcontract: non one-time items with open blankets in batch '||p_batch_no || ' are ' || x_iteration);

676:
677: END LOOP;
678:
679: select sysdate into l_end_time from dual;
680: POA_LOG.put_line('Populate_npcontract: non one-time items with open blankets in batch '||p_batch_no || ' are ' || x_iteration);
681:
682: POA_LOG.put_line('Populate_npcontract: time to calculate lowest price: '||
683: poa_log.duration(l_end_time - l_start_time) || ', start time: ' ||
684: to_char(l_start_time, 'MM/DD/YYYY HH24:MI:SS') || ', end time: ' ||

Line 682: POA_LOG.put_line('Populate_npcontract: time to calculate lowest price: '||

678:
679: select sysdate into l_end_time from dual;
680: POA_LOG.put_line('Populate_npcontract: non one-time items with open blankets in batch '||p_batch_no || ' are ' || x_iteration);
681:
682: POA_LOG.put_line('Populate_npcontract: time to calculate lowest price: '||
683: poa_log.duration(l_end_time - l_start_time) || ', start time: ' ||
684: to_char(l_start_time, 'MM/DD/YYYY HH24:MI:SS') || ', end time: ' ||
685: to_char(l_end_time, 'MM/DD/YYYY HH24:MI:SS'));
686:

Line 683: poa_log.duration(l_end_time - l_start_time) || ', start time: ' ||

679: select sysdate into l_end_time from dual;
680: POA_LOG.put_line('Populate_npcontract: non one-time items with open blankets in batch '||p_batch_no || ' are ' || x_iteration);
681:
682: POA_LOG.put_line('Populate_npcontract: time to calculate lowest price: '||
683: poa_log.duration(l_end_time - l_start_time) || ', start time: ' ||
684: to_char(l_start_time, 'MM/DD/YYYY HH24:MI:SS') || ', end time: ' ||
685: to_char(l_end_time, 'MM/DD/YYYY HH24:MI:SS'));
686:
687: POA_LOG.debug_line('Populate_npcontract exit');

Line 687: POA_LOG.debug_line('Populate_npcontract exit');

683: poa_log.duration(l_end_time - l_start_time) || ', start time: ' ||
684: to_char(l_start_time, 'MM/DD/YYYY HH24:MI:SS') || ', end time: ' ||
685: to_char(l_end_time, 'MM/DD/YYYY HH24:MI:SS'));
686:
687: POA_LOG.debug_line('Populate_npcontract exit');
688: --
689: EXCEPTION
690: WHEN others THEN
691: v_buf := 'Non Contract function: ' || sqlcode || ': ' || sqlerrm || ': ' || x_progress;

Line 694: POA_LOG.put_line(v_buf);

690: WHEN others THEN
691: v_buf := 'Non Contract function: ' || sqlcode || ': ' || sqlerrm || ': ' || x_progress;
692: ROLLBACK;
693:
694: POA_LOG.put_line(v_buf);
695: POA_LOG.put_line(' ');
696:
697: RAISE;
698: --

Line 695: POA_LOG.put_line(' ');

691: v_buf := 'Non Contract function: ' || sqlcode || ': ' || sqlerrm || ': ' || x_progress;
692: ROLLBACK;
693:
694: POA_LOG.put_line(v_buf);
695: POA_LOG.put_line(' ');
696:
697: RAISE;
698: --
699: END populate_npcontract;

Line 749: POA_LOG.debug_line('Insert_npcontract: entered');

745:
746:
747: BEGIN
748:
749: POA_LOG.debug_line('Insert_npcontract: entered');
750: x_progress := '030';
751:
752: SELECT decode(psc.consigned_flag, 'Y', null, decode(psc.closed_code, 'FINALLY_CLOSED',
753: (decode(sign(nvl(pod.quantity_delivered,0)

Line 846: -- POA_LOG.debug_line(' v_rowcount is: ' || v_rowcount);

842: --If a row already exists, then delete it and reinsert the
843: --row with the updated information
844:
845: IF (v_rowcount > 0) THEN
846: -- POA_LOG.debug_line(' v_rowcount is: ' || v_rowcount);
847:
848: x_progress := '050';
849: DELETE FROM poa_bis_savings
850: WHERE distribution_transaction_id = v_po_distribution_id;

Line 949: POA_LOG.put_line(v_buf);

945: WHEN others THEN
946: v_buf := 'Insert non contract function: ' || sqlcode || ': ' || sqlerrm || ': ' || x_progress;
947:
948: ROLLBACK;
949: POA_LOG.put_line(v_buf);
950: POA_LOG.put_line(' ');
951:
952: RAISE;
953: END insert_npcontract;

Line 950: POA_LOG.put_line(' ');

946: v_buf := 'Insert non contract function: ' || sqlcode || ': ' || sqlerrm || ': ' || x_progress;
947:
948: ROLLBACK;
949: POA_LOG.put_line(v_buf);
950: POA_LOG.put_line(' ');
951:
952: RAISE;
953: END insert_npcontract;
954: