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_AUTO_LINE_PROCESS_PVT dependencies on PO_DEBUG

Line 28: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

24: ** 06/11/09 serukull Created
25: ============================================================================ */
26: g_pkg_name CONSTANT VARCHAR2(1000) := 'PO_AUTO_LINE_PROCESS_PVT';
27: g_log_head CONSTANT VARCHAR2(1000) := 'po.plsql.PO_AUTO_LINE_PROCESS_PVT.';
28: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
29: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
30: p_price_diff po_autocreate_types.price_diffs_rec_type;
31:
32: /* ----------------------------------------------------

Line 29: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;

25: ============================================================================ */
26: g_pkg_name CONSTANT VARCHAR2(1000) := 'PO_AUTO_LINE_PROCESS_PVT';
27: g_log_head CONSTANT VARCHAR2(1000) := 'po.plsql.PO_AUTO_LINE_PROCESS_PVT.';
28: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
29: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
30: p_price_diff po_autocreate_types.price_diffs_rec_type;
31:
32: /* ----------------------------------------------------
33: ----------------- PRIVATE PROCEDURES ----------------

Line 93: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);

89: WHEN No_Data_Found THEN
90: p_destination_type_code := NULL;
91: p_ship_to_org_id := NULL;
92: p_deliver_to_loc_id := NULL;
93: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);
94: WHEN OTHERS THEN
95: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);
96:
97: --CLM Phase 2 changes : error handling

Line 95: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);

91: p_ship_to_org_id := NULL;
92: p_deliver_to_loc_id := NULL;
93: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);
94: WHEN OTHERS THEN
95: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);
96:
97: --CLM Phase 2 changes : error handling
98: PO_AUTOCREATE_PVT.report_error('PO_AUTO_SHIPTO_ERR',
99: x_token1_value => sqlerrm);

Line 152: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);

148:
149: BEGIN
150:
151: IF g_debug_stmt THEN
152: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);
153: END IF;
154:
155: l_progress := '010';
156:

Line 195: po_debug.debug_end (p_log_head => g_log_head || l_api_name);

191: x_rate,
192: l_display_rate );
193:
194: IF g_debug_stmt THEN
195: po_debug.debug_end (p_log_head => g_log_head || l_api_name);
196: END IF;
197:
198: EXCEPTION
199: WHEN OTHERS THEN

Line 201: po_debug.debug_exc (p_log_head => g_log_head || l_api_name, p_progress => l_progress );

197:
198: EXCEPTION
199: WHEN OTHERS THEN
200: IF g_debug_unexp THEN
201: po_debug.debug_exc (p_log_head => g_log_head || l_api_name, p_progress => l_progress );
202: END IF;
203:
204: END get_rate_for_req_price;
205:

Line 292: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

288:
289: BEGIN
290:
291: IF g_debug_stmt THEN
292: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
293: END IF;
294:
295: IF PO_AUTOCREATE_PARAMS.g_interface_source_code ='SOURCING' THEN
296:

Line 336: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Before the update for withdrawn reqs');

332: -- With drawn req lines are deleted from po_requisition_lines
333: -- table. Hence require a separate update.
334:
335: IF g_debug_stmt THEN
336: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Before the update for withdrawn reqs');
337: END IF;
338:
339: UPDATE po_lines_interface pli
340: SET pli.requisition_line_id = NULL

Line 361: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

357: THEN
358: l_progress:='040';
359:
360: IF g_debug_stmt THEN
361: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
362: p_message => 'Before setting priced lines in interface tables');
363: END IF;
364:
365: UPDATE po_lines_interface pli2

Line 514: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

510:
511: l_progress:='050';
512:
513: IF g_debug_stmt THEN
514: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
515: p_message => 'Before setting Info lines in interface tables');
516: END IF;
517:
518: /* For Info-Lines */

Line 658: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

654: IF (PO_AUTOCREATE_PARAMS.g_interface_source_code <> 'SOURCING') THEN
655:
656: l_progress :='060';
657: IF g_debug_stmt THEN
658: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
659: p_message => 'Before setting the CLIN SLIN and Options structure in Lines Interface Table');
660: END IF;
661:
662: /*

Line 720: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

716: l_slin_count := l_slin_count + 1;
717: END IF;
718:
719: IF g_debug_stmt THEN
720: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
721: p_message => 'Setting line_num_display for slins of ' || l_clin_num_display || ' for slin ' || l_slin_num_display);
722: END IF;
723:
724: l_progress :='066';

Line 734: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

730:
731: EXCEPTION
732: WHEN OTHERS THEN
733: IF g_debug_stmt THEN
734: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
735: p_message => 'Exception while setting line_num_display for ' || l_clin_num_display);
736: END IF;
737: END;
738: END IF; -- Req to modification project

Line 765: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Before insert into Distribution interface');

761: -- setup distributions interface
762: IF PO_AUTOCREATE_PARAMS.g_document_type = 'PO' THEN
763: l_progress :='080';
764: IF g_debug_stmt THEN
765: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Before insert into Distribution interface');
766: END IF;
767:
768: INSERT
769: INTO po_distributions_interface

Line 898: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

894: WHERE pda.req_distribution_id = prd.distribution_id))
895: );
896:
897: IF g_debug_stmt THEN
898: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
899: p_message => 'After insert into Distribution interface');
900: END IF;
901:
902: /* Option lines do not have distributions , but we still

Line 910: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'insert into p_dists record for Option Line');

906: IF po_autocreate_params.g_is_clm_po ='Y' THEN
907: l_progress :='090';
908:
909: IF g_debug_stmt THEN
910: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'insert into p_dists record for Option Line');
911: END IF;
912:
913: INSERT
914: INTO po_distributions_interface

Line 946: PO_DEBUG.debug_stmt( p_log_head => g_log_head||l_api_name, p_token => l_progress,

942: AND NVL(pli.clm_info_flag,'N') = 'N'
943: AND prl.requisition_line_id = pli.requisition_line_id;
944:
945: IF g_debug_stmt THEN
946: PO_DEBUG.debug_stmt( p_log_head => g_log_head||l_api_name, p_token => l_progress,
947: p_message => 'After insert into p_dists record for Option Line');
948: END IF;
949: END IF;
950:

Line 959: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Count from dist iterface is '||l_count_dist);

955: FROM po_distributions_interface
956: WHERE interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id;
957:
958: IF g_debug_stmt THEN
959: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Count from dist iterface is '||l_count_dist);
960: END IF;
961: END IF;--end RFQ , PO
962:
963: -- For D.o.D case need to set the Distributions properly.

Line 978: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

974: )
975: WHERE pdi.interface_header_id = po_autocreate_params.x_interface_header_id;
976:
977: IF g_debug_stmt THEN
978: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
979: p_message => 'No of Distribution records updated : ' || SQL%ROWCOUNT);
980: END IF;
981:
982: END IF;

Line 1106: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

1102: END LOOP;
1103: END IF;
1104:
1105: IF g_debug_stmt THEN
1106: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
1107: p_message => 'END: Default Distribution for Non Req Backing negotiations');
1108: END IF;
1109:
1110: IF g_debug_stmt THEN

Line 1111: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

1107: p_message => 'END: Default Distribution for Non Req Backing negotiations');
1108: END IF;
1109:
1110: IF g_debug_stmt THEN
1111: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
1112: END IF;
1113:
1114: EXCEPTION
1115: WHEN OTHERS THEN

Line 1117: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

1113:
1114: EXCEPTION
1115: WHEN OTHERS THEN
1116: IF g_debug_unexp THEN
1117: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1118: END IF;
1119:
1120: --CLM Phase 2 changes : error handling
1121: PO_AUTOCREATE_PVT.report_error('PO_AUTO_SETUP_INTF_DATA_ERR',x_token1_value => sqlerrm);

Line 1144: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

1140:
1141: BEGIN
1142:
1143: IF g_debug_stmt THEN
1144: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
1145: END IF;
1146:
1147: l_progress := '010';
1148:

Line 1594: PO_DEBUG.debug_stmt( p_log_head => g_log_head||l_api_name ,p_token => l_progress ,p_message => 'No of Records Fetched : ' || p_lines.intf_line_id_tbl.Count);

1590:
1591: l_progress := '020';
1592:
1593: IF g_debug_stmt THEN
1594: PO_DEBUG.debug_stmt( p_log_head => g_log_head||l_api_name ,p_token => l_progress ,p_message => 'No of Records Fetched : ' || p_lines.intf_line_id_tbl.Count);
1595: END IF;
1596:
1597: IF g_debug_stmt THEN
1598: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

Line 1598: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

1594: PO_DEBUG.debug_stmt( p_log_head => g_log_head||l_api_name ,p_token => l_progress ,p_message => 'No of Records Fetched : ' || p_lines.intf_line_id_tbl.Count);
1595: END IF;
1596:
1597: IF g_debug_stmt THEN
1598: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
1599: END IF;
1600:
1601: EXCEPTION
1602: WHEN OTHERS THEN

Line 1604: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

1600:
1601: EXCEPTION
1602: WHEN OTHERS THEN
1603: IF g_debug_unexp THEN
1604: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1605: END IF;
1606: --CLM Phase 2 changes : error handling
1607: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_FETCH_ERR',x_token1_value => sqlerrm);
1608:

Line 1769: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

1765: l_match_line_found BOOLEAN := FALSE;
1766:
1767: BEGIN
1768: IF g_debug_stmt THEN
1769: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
1770: PO_DEBUG.debug_stmt( p_log_head => g_log_head||l_api_name, p_token => l_progress,
1771: p_message => 'Document Type : '|| PO_AUTOCREATE_PARAMS.g_document_type ||
1772: ' Document_subtype : '|| PO_AUTOCREATE_PARAMS.g_document_subtype ||
1773: ' Interface Lines Count ' || p_lines.intf_line_id_tbl.Count );

Line 1770: PO_DEBUG.debug_stmt( p_log_head => g_log_head||l_api_name, p_token => l_progress,

1766:
1767: BEGIN
1768: IF g_debug_stmt THEN
1769: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
1770: PO_DEBUG.debug_stmt( p_log_head => g_log_head||l_api_name, p_token => l_progress,
1771: p_message => 'Document Type : '|| PO_AUTOCREATE_PARAMS.g_document_type ||
1772: ' Document_subtype : '|| PO_AUTOCREATE_PARAMS.g_document_subtype ||
1773: ' Interface Lines Count ' || p_lines.intf_line_id_tbl.Count );
1774: END IF;

Line 1871: po_debug.debug_exc (p_log_head => g_log_head || l_api_name, p_progress => l_progress );

1867: WHERE prl.requisition_line_id = p_lines.requisition_line_id_tbl (i);
1868: EXCEPTION
1869: WHEN OTHERS THEN
1870: IF g_debug_unexp THEN
1871: po_debug.debug_exc (p_log_head => g_log_head || l_api_name, p_progress => l_progress );
1872: END IF;
1873: PO_AUTOCREATE_PVT.wrapup();
1874: po_message_s.sql_error('CREATE_LINE',l_progress,SQLCODE);
1875: RAISE;

Line 1915: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

1911: FROM po_line_types
1912: WHERE line_type_id = p_lines.line_type_id_tbl (i);
1913:
1914: IF g_debug_stmt THEN
1915: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
1916: p_message => 'x_order_type_lookup_code: '|| x_order_type_lookup_code ||' l_purchase_basis :' || l_purchase_basis);
1917: END IF;
1918: END IF;
1919:

Line 1973: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Matching Line Found : '|| x_po_line_id);

1969:
1970: p_lines.po_line_id_tbl(i) := x_po_line_id;
1971: p_lines.po_header_id_tbl(i) := po_autocreate_params.g_po_header_id;
1972: IF g_debug_stmt THEN
1973: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Matching Line Found : '|| x_po_line_id);
1974: END IF;
1975:
1976: EXCEPTION
1977: WHEN NO_DATA_FOUND THEN

Line 1979: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

1975:
1976: EXCEPTION
1977: WHEN NO_DATA_FOUND THEN
1978: IF g_debug_stmt THEN
1979: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
1980: p_message => 'NO_DATA_FOUND: '||SQLERRM);
1981: END IF;
1982: WHEN OTHERS THEN
1983: IF g_debug_stmt THEN

Line 1984: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

1980: p_message => 'NO_DATA_FOUND: '||SQLERRM);
1981: END IF;
1982: WHEN OTHERS THEN
1983: IF g_debug_stmt THEN
1984: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
1985: p_message => SQLERRM);
1986: END IF;
1987: END;
1988: END IF;

Line 2015: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'After Getting receiving controls');

2011: x_days_late_receipt_allowed => p_lines.rc_days_late_recpt_tbl(i) ,
2012: x_receipt_days_exception_code => p_lines.rc_receipt_days_excep_code_tbl(i) );
2013:
2014: IF g_debug_stmt THEN
2015: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'After Getting receiving controls');
2016: END IF;
2017: END IF;
2018:
2019: -- When autocreating a PO that references a GA, and the req line and

Line 2040: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

2036: AND poh.po_header_id =pol.po_header_id;
2037: EXCEPTION
2038: WHEN OTHERS THEN
2039: IF g_debug_unexp THEN
2040: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2041: END IF;
2042:
2043: --CLM Phase 2 changes : error handling
2044: PO_AUTOCREATE_PVT.report_error('PO_AUTO_SRC_DOC_ERR',

Line 2056: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

2052:
2053: l_progress := '120';
2054:
2055: IF g_debug_stmt THEN
2056: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
2057: p_message => 'req uom: '||p_lines.unit_of_measure_tbl(i)||
2058: ' uom: '||l_ga_uom ||
2059: 'document type: ' || l_from_type_lookup_code);
2060: END IF;

Line 2074: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

2070:
2071: ELSE -- UOM Convert is No, so do not create this line.
2072:
2073: IF g_debug_stmt THEN
2074: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
2075: p_message => 'Create_line: Requisition UOM is different from GA UOM, and the Convert UOM profile is No. This PO line will not be created.');
2076: END IF;
2077: RETURN;
2078: END IF;

Line 2151: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);

2147: AND msi.organization_id = p_lines.dest_organization_id_tbl(i);
2148: EXCEPTION
2149: WHEN no_data_found THEN
2150: IF g_debug_stmt THEN
2151: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);
2152: END IF;
2153: WHEN OTHERS THEN
2154: IF g_debug_unexp THEN
2155: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

Line 2155: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

2151: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);
2152: END IF;
2153: WHEN OTHERS THEN
2154: IF g_debug_unexp THEN
2155: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2156: END IF;
2157:
2158: --CLM Phase 2 changes : error handling
2159: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_ITEM_ERR',

Line 2196: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

2192: WHERE msi.inventory_item_id = p_lines.item_id_tbl(i)
2193: AND msi.organization_id = po_autocreate_params.g_sys.master_inv_org_id;
2194:
2195: IF g_debug_stmt THEN
2196: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
2197: p_message => 'Item List Price : ' || p_lines.it_list_price_per_unit_tbl(i)
2198: ||'Item Market Price : ' || p_lines.it_market_price_tbl(i) );
2199: END IF;
2200: EXCEPTION

Line 2203: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);

2199: END IF;
2200: EXCEPTION
2201: WHEN no_data_found THEN
2202: IF g_debug_stmt THEN
2203: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);
2204: END IF;
2205: WHEN OTHERS THEN
2206: IF g_debug_unexp THEN
2207: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

Line 2207: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

2203: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);
2204: END IF;
2205: WHEN OTHERS THEN
2206: IF g_debug_unexp THEN
2207: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2208: END IF;
2209:
2210: --CLM Phase 2 changes : error handling
2211: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_ITEM_ERR',

Line 2249: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);

2245:
2246: EXCEPTION
2247: WHEN no_data_found THEN
2248: IF g_debug_stmt THEN
2249: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);
2250: END IF;
2251: WHEN OTHERS THEN
2252: IF g_debug_unexp THEN
2253: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

Line 2253: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

2249: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);
2250: END IF;
2251: WHEN OTHERS THEN
2252: IF g_debug_unexp THEN
2253: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2254: END IF;
2255:
2256: --CLM Phase 2 changes : error handling
2257: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_ONE_TIME_ITEM_ERR',

Line 2282: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);

2278: WHERE vendor.vendor_id = p_lines.hd_vendor_id_tbl(i);
2279: EXCEPTION
2280: WHEN no_data_found THEN
2281: IF g_debug_stmt THEN
2282: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);
2283: END IF;
2284: WHEN OTHERS THEN
2285: IF g_debug_unexp THEN
2286: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

Line 2286: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

2282: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);
2283: END IF;
2284: WHEN OTHERS THEN
2285: IF g_debug_unexp THEN
2286: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2287: END IF;
2288:
2289: --CLM Phase 2 changes : error handling
2290: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_VENDOR_ERR',

Line 2320: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);

2316:
2317: EXCEPTION
2318: WHEN no_data_found THEN
2319: IF g_debug_stmt THEN
2320: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);
2321: END IF;
2322: WHEN OTHERS THEN
2323: IF g_debug_unexp THEN
2324: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

Line 2324: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

2320: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);
2321: END IF;
2322: WHEN OTHERS THEN
2323: IF g_debug_unexp THEN
2324: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2325: END IF;
2326:
2327: --CLM Phase 2 changes : error handling
2328: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_SYTEM_ERR',

Line 2367: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

2363: END IF;
2364:
2365: l_progress := '210';
2366: IF g_debug_stmt THEN
2367: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
2368: p_message => 'Create_line: line taxable_flag: '||p_lines.it_taxable_flag_tbl(i));
2369: END IF;
2370:
2371: -- Perform currency conversion on price/amount/quantity.

Line 2400: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: PO line does not exist');

2396: IF(x_po_line_id IS NULL) THEN
2397: l_progress := '230';
2398:
2399: IF g_debug_stmt THEN
2400: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: PO line does not exist');
2401: END IF;
2402:
2403: /* set neg by preparer flag */
2404: p_lines.negotiated_flag_tbl(i) := 'N';

Line 2443: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);

2439: AND organization_id = po_autocreate_params.g_sys.master_inv_org_id;
2440: EXCEPTION
2441: WHEN no_data_found THEN
2442: IF g_debug_stmt THEN
2443: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);
2444: END IF;
2445: WHEN OTHERS THEN
2446: IF g_debug_unexp THEN
2447: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

Line 2447: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

2443: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);
2444: END IF;
2445: WHEN OTHERS THEN
2446: IF g_debug_unexp THEN
2447: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2448: END IF;
2449: RAISE;
2450: END;
2451:

Line 2462: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

2458: WHERE line_type_id= p_lines.line_type_id_tbl(i);
2459: EXCEPTION
2460: WHEN OTHERS THEN
2461: IF g_debug_unexp THEN
2462: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2463: END IF;
2464: RAISE;
2465: END;
2466: ELSE

Line 2488: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

2484: WHERE line_type_id = p_lines.line_type_id_tbl(i);
2485: EXCEPTION
2486: WHEN OTHERS THEN
2487: IF g_debug_unexp THEN
2488: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2489: END IF;
2490: RAISE;
2491: END;
2492: END IF;

Line 2557: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

2553: x_return_status => l_return_status ,
2554: p_req_line_price => p_lines.unit_price_tbl(i) );
2555: --
2556: IF g_debug_stmt THEN
2557: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
2558: p_message => 'Break Unit Price: '||x_unit_price
2559: || ' Price Break Id : ' || l_price_break_id
2560: || ' Base Unit Price : '|| l_base_unit_price );
2561: END IF;

Line 2571: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

2567: END IF;
2568: x_unit_price := NVL(x_unit_price, p_lines.unit_price_tbl(i));
2569: l_base_unit_price := NVL(l_base_unit_price, p_lines.base_unit_price_tbl(i));
2570: IF g_debug_stmt THEN
2571: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
2572: p_message => 'Break Unit Price: '||x_unit_price
2573: || ' Price Break Id : ' || l_price_break_id
2574: || ' Base Unit Price : '|| l_base_unit_price );
2575: END IF;

Line 2612: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

2608: END IF;
2609:
2610: END IF;
2611: IF g_debug_stmt THEN
2612: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
2613: p_message => 'Before Inserting into the Price Diff table ' ||
2614: ' l_source_entity_type : '||l_source_entity_type ||
2615: ' l_source_entity_id : ' || l_source_entity_id );
2616: END IF;

Line 2643: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: Line id: '||x_po_line_id);

2639: --
2640: l_progress := '370';
2641:
2642: IF g_debug_stmt THEN
2643: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: Line id: '||x_po_line_id);
2644: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: Header_id : '||po_autocreate_params.g_po_header_id);
2645: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: Line number: '||p_lines.line_num_tbl(i));
2646: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: TRX RSON CODE : '||p_lines.transaction_reason_code_tbl(i));
2647: END IF;

Line 2644: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: Header_id : '||po_autocreate_params.g_po_header_id);

2640: l_progress := '370';
2641:
2642: IF g_debug_stmt THEN
2643: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: Line id: '||x_po_line_id);
2644: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: Header_id : '||po_autocreate_params.g_po_header_id);
2645: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: Line number: '||p_lines.line_num_tbl(i));
2646: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: TRX RSON CODE : '||p_lines.transaction_reason_code_tbl(i));
2647: END IF;
2648:

Line 2645: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: Line number: '||p_lines.line_num_tbl(i));

2641:
2642: IF g_debug_stmt THEN
2643: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: Line id: '||x_po_line_id);
2644: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: Header_id : '||po_autocreate_params.g_po_header_id);
2645: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: Line number: '||p_lines.line_num_tbl(i));
2646: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: TRX RSON CODE : '||p_lines.transaction_reason_code_tbl(i));
2647: END IF;
2648:
2649:

Line 2646: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: TRX RSON CODE : '||p_lines.transaction_reason_code_tbl(i));

2642: IF g_debug_stmt THEN
2643: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: Line id: '||x_po_line_id);
2644: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: Header_id : '||po_autocreate_params.g_po_header_id);
2645: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: Line number: '||p_lines.line_num_tbl(i));
2646: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_line: TRX RSON CODE : '||p_lines.transaction_reason_code_tbl(i));
2647: END IF;
2648:
2649:
2650: --

Line 2719: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

2715:
2716: EXCEPTION
2717: WHEN OTHERS THEN
2718: IF g_debug_stmt THEN
2719: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
2720: p_message => 'EXCEPTION caught; SQL Code is '||SQLCODE||'; Error is '||SQLERRM);
2721: END IF;
2722: l_negotiated_by_preparer_flag:=NULL;
2723: END;

Line 2871: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

2867: p_lines.price_break_lookup_code_tbl(i)
2868: FROM dual;
2869:
2870: IF g_debug_stmt THEN
2871: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2872: p_token => l_progress, p_message => 'Before Insert into Lines Draft '
2873: ||' List Price : ' || p_lines.list_price_per_unit_tbl(i)
2874: ||' Market Price : ' || p_lines.market_price_tbl(i)
2875: ||' Unit Price : ' || p_lines.unit_price_tbl(i));

Line 3095: PO_DEBUG.debug_stmt( p_log_head => g_log_head||l_api_name

3091: ELSE
3092:
3093: IF g_debug_stmt
3094: THEN
3095: PO_DEBUG.debug_stmt( p_log_head => g_log_head||l_api_name
3096: ,p_token => l_progress
3097: ,p_message => 'Adding to PO line id : '|| x_po_line_id );
3098:
3099: END IF;

Line 3131: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

3127: );
3128:
3129:
3130: IF l_return_status = 'E' THEN
3131: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
3132: p_token => l_progress,
3133: p_message => 'Derive_and_default_lines: Error while obtaining lock');
3134: Raise l_lock_exception;
3135: END IF;

Line 3161: PO_DEBUG.debug_stmt( p_log_head => g_log_head||l_api_name

3157: AND pl.draft_id=po_autocreate_params.g_draft_id;
3158:
3159: IF g_debug_stmt
3160: THEN
3161: PO_DEBUG.debug_stmt( p_log_head => g_log_head||l_api_name
3162: ,p_token => l_progress
3163: ,p_message => 'Quantity on the Line : '|| l_db_quantity );
3164:
3165: END IF;

Line 3169: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

3165: END IF;
3166: exception
3167: when others then
3168: IF g_debug_stmt THEN
3169: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
3170: p_token => l_progress,
3171: p_message => 'EXCEPTION caught; SQL Code is '||SQLCODE||'; Error is '||SQLERRM);
3172: END IF;
3173: end;

Line 3198: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

3194: and poll.shipment_num = l_min_shipment_num;
3195: EXCEPTION
3196: when others then
3197: IF g_debug_stmt THEN
3198: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
3199: p_token => l_progress,
3200: p_message => 'EXCEPTION caught; SQL Code is '||SQLCODE||'; Error is '||SQLERRM);
3201: END IF;
3202: END;

Line 3223: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

3219:
3220: EXCEPTION
3221: WHEN OTHERS THEN
3222: IF g_debug_stmt THEN
3223: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
3224: p_token => l_progress,
3225: p_message => 'EXCEPTION caught; SQL Code is '||SQLCODE||'; Error is '||SQLERRM);
3226: END IF;
3227: END;

Line 3280: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

3276: );
3277: --
3278:
3279: IF g_debug_stmt THEN
3280: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
3281: p_token => l_progress,
3282: p_message => 'Break Unit Price: '||x_unit_price
3283: || ' Price Break Id : ' || l_price_break_id
3284: || ' Base Unit Price : '|| l_base_unit_price

Line 3325: PO_DEBUG.debug_stmt( p_log_head => g_log_head||l_api_name

3321: -- update secondary quantity/uom to null
3322:
3323: IF g_debug_stmt
3324: THEN
3325: PO_DEBUG.debug_stmt( p_log_head => g_log_head||l_api_name
3326: ,p_token => l_progress
3327: ,p_message => 'Before updating the Lines draft Quantity : '|| x_quantity );
3328:
3329: END IF;

Line 3375: PO_DEBUG.debug_stmt( p_log_head => g_log_head||l_api_name

3371: END IF;
3372: --
3373: IF g_debug_stmt
3374: THEN
3375: PO_DEBUG.debug_stmt( p_log_head => g_log_head||l_api_name
3376: ,p_token => l_progress
3377: ,p_message => 'After updating the Lines draft Quantity : '|| l_quantity_temp );
3378:
3379: END IF;

Line 3425: PO_DEBUG.debug_stmt ( p_log_head => g_log_head||l_api_name

3421: po_autocreate_params.g_number_records_processed := p_lines.po_line_id_tbl.count;
3422:
3423: IF g_debug_stmt
3424: THEN
3425: PO_DEBUG.debug_stmt ( p_log_head => g_log_head||l_api_name
3426: ,p_token => l_progress
3427: ,p_message => 'po_autocreate_params.g_number_records_processed :'|| po_autocreate_params.g_number_records_processed );
3428:
3429: END IF;

Line 3432: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

3428:
3429: END IF;
3430:
3431: IF g_debug_stmt THEN
3432: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
3433: END IF;
3434:
3435:
3436: EXCEPTION

Line 3441: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,

3437:
3438: --autocreate grouping start
3439: WHEN l_lock_exception THEN
3440: IF g_debug_unexp THEN
3441: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
3442: p_progress => l_progress);
3443: END IF;
3444: po_message_s.sql_error('DERIVE_AND_DEFAULT_LINES',l_progress,sqlcode);
3445: PO_AUTOCREATE_PVT.wrapup();

Line 3451: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,

3447: --autocreate grouping end
3448:
3449: WHEN OTHERS THEN
3450: IF g_debug_unexp THEN
3451: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
3452: p_progress => l_progress);
3453: END IF;
3454: po_message_s.sql_error('DERIVE_AND_DEFAULT_LINES',l_progress,sqlcode);
3455: PO_AUTOCREATE_PVT.wrapup();

Line 3478: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

3474:
3475: BEGIN
3476:
3477: IF g_debug_stmt THEN
3478: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
3479: END IF;
3480:
3481: l_progress := '001';
3482:

Line 3528: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

3524:
3525: l_progress := '002';
3526:
3527: IF g_debug_stmt THEN
3528: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
3529: END IF;
3530:
3531: EXCEPTION
3532: WHEN OTHERS THEN

Line 3534: PO_DEBUG.debug_exc( p_log_head => g_log_head||l_api_name, p_progress => l_progress);

3530:
3531: EXCEPTION
3532: WHEN OTHERS THEN
3533: IF g_debug_unexp THEN
3534: PO_DEBUG.debug_exc( p_log_head => g_log_head||l_api_name, p_progress => l_progress);
3535: END IF;
3536:
3537: --CLM Phase 2 changes : error handling
3538: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_MERGE_DIFF_ERR',x_token1_value => sqlerrm);

Line 3567: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

3563:
3564: BEGIN
3565:
3566: IF g_debug_stmt THEN
3567: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
3568: END IF;
3569:
3570: --
3571: -- For intergration with Sourcing, during blanket creation from Renegotiate flow,

Line 3581: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

3577:
3578: l_progress:='001';
3579:
3580: IF g_debug_stmt THEN
3581: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
3582: p_message =>'Updating PO_LINE_IDs in attribute interface tables: '||p_lines.po_line_id_tbl.COUNT);
3583: END IF;
3584:
3585: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_INTERFACE table

Line 3599: PO_DEBUG.debug_stmt(p_log_head=>g_log_head||l_api_name,p_token=>l_progress,p_message=>'Number of PO_ATTR_VALUES_INTERFACE rows updated='||SQL% rowcount);

3595: WHERE po_attr_values_interface.interface_header_id = p_lines.intf_header_id_tbl(i)
3596: AND po_attr_values_interface.interface_line_id = p_lines.intf_line_id_tbl(i);
3597:
3598: IF g_debug_stmt THEN
3599: PO_DEBUG.debug_stmt(p_log_head=>g_log_head||l_api_name,p_token=>l_progress,p_message=>'Number of PO_ATTR_VALUES_INTERFACE rows updated='||SQL% rowcount);
3600: END IF;
3601:
3602: l_progress:='010';
3603: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_TLP_INTERFACE table

Line 3616: PO_DEBUG.debug_stmt(p_log_head=>g_log_head||l_api_name,p_token=>l_progress,

3612: WHERE po_attr_values_tlp_interface.interface_header_id = p_lines.intf_header_id_tbl(i)
3613: AND po_attr_values_tlp_interface.interface_line_id = p_lines.intf_line_id_tbl(i);
3614:
3615: IF g_debug_stmt THEN
3616: PO_DEBUG.debug_stmt(p_log_head=>g_log_head||l_api_name,p_token=>l_progress,
3617: p_message=>'Number of PO_ATTR_VALUES_TLP_INTERFACE rows updated='||SQL% rowcount);
3618: END IF;
3619:
3620: l_progress := '020';

Line 4283: PO_DEBUG.debug_stmt(p_log_head=>g_log_head||l_api_name ,p_token=>l_progress ,p_message=>'Number of rows inserted in PO_ATTRIBUTE_VALUES table='||SQL%ROWCOUNT );

4279: FROM PO_ATTR_VALUES_INTERFACE
4280: WHERE interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id;
4281:
4282: IF g_debug_stmt THEN
4283: PO_DEBUG.debug_stmt(p_log_head=>g_log_head||l_api_name ,p_token=>l_progress ,p_message=>'Number of rows inserted in PO_ATTRIBUTE_VALUES table='||SQL%ROWCOUNT );
4284: END IF;
4285:
4286: l_progress := '030';
4287: --insert tlp records from interface table

Line 4646: PO_DEBUG.debug_stmt(p_log_head=>g_log_head||l_api_name ,p_token=>l_progress ,p_message=>'Number of rows inserted in PO_ATTRIBUTE_VALUES_TLP table='||SQL%rowcount );

4642: WHERE interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id;
4643:
4644: --
4645: IF g_debug_stmt THEN
4646: PO_DEBUG.debug_stmt(p_log_head=>g_log_head||l_api_name ,p_token=>l_progress ,p_message=>'Number of rows inserted in PO_ATTRIBUTE_VALUES_TLP table='||SQL%rowcount );
4647: END IF;
4648:
4649: IF g_debug_stmt THEN
4650: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

Line 4650: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

4646: PO_DEBUG.debug_stmt(p_log_head=>g_log_head||l_api_name ,p_token=>l_progress ,p_message=>'Number of rows inserted in PO_ATTRIBUTE_VALUES_TLP table='||SQL%rowcount );
4647: END IF;
4648:
4649: IF g_debug_stmt THEN
4650: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
4651: END IF;
4652: END IF;
4653:
4654: EXCEPTION

Line 4657: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

4653:
4654: EXCEPTION
4655: WHEN OTHERS THEN
4656: IF g_debug_unexp THEN
4657: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
4658: END IF;
4659:
4660: --CLM Phase 2 changes : error handling
4661: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_MERGE_ATTR_ERR',x_token1_value => sqlerrm);

Line 4744: PO_DEBUG.debug_begin(l_log_head);

4740:
4741: BEGIN
4742:
4743: l_progress:='000';
4744: PO_DEBUG.debug_begin(l_log_head);
4745:
4746: -- Initialize Variables ===================================================
4747: -- Get the precision/extended precision for the PO Currency.
4748:

Line 4760: PO_DEBUG.debug_var(l_log_head,l_progress,'p_order_type_lookup_code',p_order_type_lookup_code);

4756:
4757: -- Convert ================================================================
4758: l_progress:='020';
4759:
4760: PO_DEBUG.debug_var(l_log_head,l_progress,'p_order_type_lookup_code',p_order_type_lookup_code);
4761:
4762: -- For 'Amount' based lines, we need to convert the quantity since
4763: -- quantity acts like amount.
4764: --

Line 4767: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Performing currency conversion on quantity.');

4763: -- quantity acts like amount.
4764: --
4765: IF ( p_order_type_lookup_code = 'AMOUNT' ) THEN
4766: l_progress :='020';
4767: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Performing currency conversion on quantity.');
4768: -- No conversion for same currency.
4769: /* Added Exception Block to make sure that Solicitations, which are not backed up by requisitions
4770: shouldn't throw no data found exceptions. */
4771: BEGIN

Line 4790: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);

4786: END IF;
4787:
4788: EXCEPTION
4789: WHEN OTHERS THEN
4790: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);
4791: END;
4792:
4793: -- For all other line types, convert the Price/Amount.
4794: --

Line 4802: PO_DEBUG.debug_stmt(l_log_head,l_progress,'p_interface_source_code IN (SOURCING, CONSUMPTION ADVICE) - no currency conversion performed');

4798: --
4799: IF ( p_interface_source_code IN ('SOURCING','CONSUMPTION_ADVICE') ) THEN
4800:
4801: l_progress :='050';
4802: PO_DEBUG.debug_stmt(l_log_head,l_progress,'p_interface_source_code IN (SOURCING, CONSUMPTION ADVICE) - no currency conversion performed');
4803:
4804: ELSE -- ( p_interface_source_code NOT IN ('SOURCING','CONSUMPTION_ADVICE') )
4805: -- Retrieve information from the backing Requisition Line.
4806: -- Join to financials_system_params_all and gl_sets_of_books to

Line 4839: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Req and PO Currency equivalent ('

4835: -- unit_price/amount to the PO Currency using the specified rate.
4836: --
4837: IF ( l_req_currency_code = p_po_currency_code ) THEN
4838: l_progress :='070';
4839: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Req and PO Currency equivalent ('
4840: || p_po_currency_code
4841: || ') - taking currency_unit_price/amount directly from the Req Line.');
4842:
4843: x_unit_price := l_req_currency_unit_price;

Line 4847: PO_DEBUG.debug_stmt(l_log_head,l_progress,'ROU Currency and PO Currency equivalent ('

4843: x_unit_price := l_req_currency_unit_price;
4844: x_amount := l_req_currency_amount;
4845: ELSIF (l_req_ou_currency_code = p_po_currency_code) THEN
4846: l_progress := '080';
4847: PO_DEBUG.debug_stmt(l_log_head,l_progress,'ROU Currency and PO Currency equivalent ('
4848: || p_po_currency_code
4849: || ') - taking unit_price/amount directory from the Req line');
4850:
4851: x_unit_price := l_req_unit_price;

Line 4855: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Req ('

4851: x_unit_price := l_req_unit_price;
4852: x_amount := l_req_amount;
4853: ELSE
4854: l_progress:='090';
4855: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Req ('
4856: || l_req_currency_code
4857: || ')/ ROU ('
4858: || l_req_ou_currency_code
4859: || ') and PO ('

Line 4874: PO_DEBUG.debug_end(l_log_head);

4870:
4871: END IF; -- p_order_type_lookup_code
4872:
4873: l_progress:='100';
4874: PO_DEBUG.debug_end(l_log_head);
4875: EXCEPTION
4876: WHEN OTHERS THEN
4877: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);
4878: RAISE;

Line 4877: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);

4873: l_progress:='100';
4874: PO_DEBUG.debug_end(l_log_head);
4875: EXCEPTION
4876: WHEN OTHERS THEN
4877: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);
4878: RAISE;
4879: --CLM Phase 2 changes : error handling
4880: PO_AUTOCREATE_PVT.report_error('PO_AUTO_CURRENCY_CONV_ERR',x_token1_value => sqlerrm);
4881:

Line 4913: PO_DEBUG.debug_begin(l_log_head);

4909:
4910: BEGIN
4911:
4912: l_progress:='000';
4913: PO_DEBUG.debug_begin(l_log_head);
4914:
4915: /*pon_award allocations allocated_funds amount will have total funds_remaining from req lines for that bid line.
4916: So each distribution will have this funded amount divided in the ratio of distribution
4917: i.e if the req line has 2 dist with funds_remaining as d1 and d2 and allocated_funds is f1 then funded value for this distribution

Line 4938: PO_DEBUG.debug_stmt(l_log_head,l_progress,'l_auction_header_id: '||l_auction_header_id);

4934: l_auction_header_id := NULL;
4935: END;
4936:
4937: l_progress :='020';
4938: PO_DEBUG.debug_stmt(l_log_head,l_progress,'l_auction_header_id: '||l_auction_header_id);
4939:
4940: --Line Stucture Enabled does not check for funtion security here.
4941: IF(l_auction_header_id IS NOT NULL AND PON_CLM_UTIL_PKG.get_line_structure_enabled(p_auction_header_id => l_auction_header_id) = 'Y') THEN
4942:

Line 5064: PO_DEBUG.debug_stmt(l_log_head,l_progress,'lines inserted into distributions interface'||l_count);

5060: AND req_dist_amt.requisition_line_id = paa.orig_req_line_id
5061: AND prd.funds_remaining > 0;
5062:
5063: l_count := SQL%ROWCOUNT;
5064: PO_DEBUG.debug_stmt(l_log_head,l_progress,'lines inserted into distributions interface'||l_count);
5065:
5066: END IF;
5067: l_progress:='50';
5068: PO_DEBUG.debug_end(l_log_head);

Line 5068: PO_DEBUG.debug_end(l_log_head);

5064: PO_DEBUG.debug_stmt(l_log_head,l_progress,'lines inserted into distributions interface'||l_count);
5065:
5066: END IF;
5067: l_progress:='50';
5068: PO_DEBUG.debug_end(l_log_head);
5069:
5070: EXCEPTION
5071: WHEN OTHERS THEN
5072: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);

Line 5072: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);

5068: PO_DEBUG.debug_end(l_log_head);
5069:
5070: EXCEPTION
5071: WHEN OTHERS THEN
5072: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);
5073: RAISE;
5074: --CLM Phase 2 changes : error handling
5075: PO_AUTOCREATE_PVT.report_error('create_pon_back_req_dist',x_token1_value => sqlerrm);
5076: