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

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

26: There might be a draft already existing.
27: ============================================================================== */
28: g_pkg_name CONSTANT VARCHAR2(1000) := 'po_autocreate_mainproc_pvt';
29: g_log_head CONSTANT VARCHAR2(1000) := 'po.plsql.PO_AUTOCREATE_MAINPROC_PVT.';
30: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
31: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
32: x_lines PO_AUTOCREATE_TYPES.lines_rec_type;
33:
34: --

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

27: ============================================================================== */
28: g_pkg_name CONSTANT VARCHAR2(1000) := 'po_autocreate_mainproc_pvt';
29: g_log_head CONSTANT VARCHAR2(1000) := 'po.plsql.PO_AUTOCREATE_MAINPROC_PVT.';
30: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
31: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
32: x_lines PO_AUTOCREATE_TYPES.lines_rec_type;
33:
34: --
35: PROCEDURE sync_complex_pricing(p_po_line_id_tbl IN PO_TBL_NUMBER,

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

58: l_style_id NUMBER;
59: BEGIN
60:
61: IF g_debug_stmt THEN
62: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
63: END IF;
64:
65: l_progress := '010';
66: /* Get the matching lines and transfer the required records

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

95: FROM po_headers_all
96: WHERE po_header_id = po_autocreate_params.g_po_header_id;
97:
98: IF g_debug_stmt THEN
99: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
100: p_token => l_progress,
101: p_message => 'Style Id : '||l_style_id);
102: END IF;
103:

Line 105: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'No of Matched Line Records : '||po_line_id_tbl.Count);

101: p_message => 'Style Id : '||l_style_id);
102: END IF;
103:
104: IF g_debug_stmt THEN
105: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'No of Matched Line Records : '||po_line_id_tbl.Count);
106: END IF;
107:
108: l_progress := '020';
109: IF po_line_id_tbl.Count > 0 THEN

Line 119: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'After Sync Line Draft From Transaction');

115: p_style_id => l_style_id);
116: END IF;
117:
118: IF g_debug_stmt THEN
119: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'After Sync Line Draft From Transaction');
120: END IF;
121:
122: l_progress := '030';
123: SELECT plla.line_location_id ,

Line 147: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'No of Matched Shipment Records : '||po_line_loc_id_tbl.Count );

143: AND plld.line_location_id = plla.line_location_id
144: );
145:
146: IF g_debug_stmt THEN
147: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'No of Matched Shipment Records : '||po_line_loc_id_tbl.Count );
148: END IF;
149:
150: l_progress := '040';
151: PO_LINE_LOCATIONS_DRAFT_PKG.sync_draft_from_txn (p_line_location_id_tbl => po_line_loc_id_tbl ,

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

159: p_style_id => l_style_id);
160: END IF;
161:
162: IF g_debug_stmt THEN
163: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
164: p_message => 'After Sync Line Locations Draft From Transaction');
165: END IF;
166:
167: /*CLM Phase-2 Changes*/

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

168: --Syncing Distributions Draft From Transaction
169: l_progress := '050';
170:
171: IF g_debug_stmt THEN
172: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
173: p_message => 'Before Sync Distributions Draft From Transaction');
174: END IF;
175:
176: SELECT pod.po_distribution_id ,

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

196: p_delete_flag_tbl => delete_flag_tbl ,
197: x_record_already_exist_tbl => x_record_already_exist_tbl );
198:
199: IF g_debug_stmt THEN
200: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
201: p_message => 'After Sync Distributions Draft From Transaction');
202: END IF;
203: /*CLM Phase-2 Ends*/
204:

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

202: END IF;
203: /*CLM Phase-2 Ends*/
204:
205: IF g_debug_stmt THEN
206: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
207: END IF;
208: EXCEPTION
209: WHEN OTHERS THEN
210: IF g_debug_unexp THEN

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

207: END IF;
208: EXCEPTION
209: WHEN OTHERS THEN
210: IF g_debug_unexp THEN
211: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
212: END IF;
213:
214: --CLM Phase 2 changes : error handling
215: PO_AUTOCREATE_PVT.report_error('PO_AUTO_MERGE_TO_DRAFTS_ERR',x_token1_value => sqlerrm);

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

261: l_intf_txn_FLOW_HEADER_ID NUMBER; -- INTERFACE.TRANSACTION_FLOW_HEADER_ID
262: BEGIN
263:
264: IF g_debug_stmt THEN
265: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
266: END IF;
267:
268: /* Get the profile option values to determine grouping criteria */
269: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');

Line 285: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'One-time location. Shipment num = -1');

281: IF PO_AUTOCREATE_PARAMS.g_document_type = 'PO' AND x_drop_ship_flag = 'Y' THEN
282: x_create_new_line := 'Y';
283: END IF;
284: IF g_debug_stmt THEN
285: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'One-time location. Shipment num = -1');
286: END IF;
287: RETURN;
288: END IF;
289:

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

316: AND ROWNUM = 1;
317: EXCEPTION
318: WHEN NO_DATA_FOUND THEN
319: IF g_debug_stmt THEN
320: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: ' || SQLERRM);
321: END IF;
322: x_po_shipment_num := -1;
323: IF NVL(l_needby_prf, 'Y') = 'Y' THEN
324: x_create_new_line := 'Y';

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

324: x_create_new_line := 'Y';
325: END IF;
326: WHEN OTHERS THEN
327: IF g_debug_unexp THEN
328: PO_DEBUG.debug_exc(p_log_head => g_log_head || l_api_name, p_progress => l_progress);
329: END IF;
330: -- wrapup(x_interface_header_id);
331: RAISE;
332: END;

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

349: AND ROWNUM = 1;
350: EXCEPTION
351: WHEN NO_DATA_FOUND THEN
352: IF g_debug_stmt THEN
353: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: ' || SQLERRM);
354: END IF;
355: x_po_shipment_num := -1;
356: IF NVL(l_shipto_prf, 'Y') = 'Y' THEN
357: x_create_new_line := 'Y';

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

357: x_create_new_line := 'Y';
358: END IF;
359: WHEN OTHERS THEN
360: IF g_debug_unexp THEN
361: PO_DEBUG.debug_exc(p_log_head => g_log_head || l_api_name, p_progress => l_progress);
362: END IF;
363: --wrapup(x_interface_header_id);
364: RAISE;
365: END;

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

383: AND ROWNUM = 1;
384: EXCEPTION
385: WHEN NO_DATA_FOUND THEN
386: IF g_debug_stmt THEN
387: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: ' || SQLERRM);
388: END IF;
389: x_po_shipment_num := -1;
390: x_create_new_line := 'Y';
391: WHEN OTHERS THEN

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

389: x_po_shipment_num := -1;
390: x_create_new_line := 'Y';
391: WHEN OTHERS THEN
392: IF g_debug_unexp THEN
393: PO_DEBUG.debug_exc(p_log_head => g_log_head || l_api_name, p_progress => l_progress);
394: END IF;
395: --wrapup(x_interface_header_id);
396: RAISE;
397: END;

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

433:
434: EXCEPTION
435: WHEN NO_DATA_FOUND THEN
436: IF g_debug_stmt THEN
437: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: ' || SQLERRM);
438: END IF;
439: x_po_shipment_num := -1;
440: WHEN OTHERS THEN
441: IF g_debug_unexp THEN

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

438: END IF;
439: x_po_shipment_num := -1;
440: WHEN OTHERS THEN
441: IF g_debug_unexp THEN
442: PO_DEBUG.debug_exc(p_log_head => g_log_head || l_api_name, p_progress => l_progress);
443: END IF;
444: --wrapup(x_interface_header_id);
445: RAISE;
446: END;

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

502:
503: EXCEPTION
504: WHEN NO_DATA_FOUND THEN
505: IF g_debug_stmt THEN
506: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: ' || SQLERRM);
507: END IF;
508: WHEN OTHERS THEN
509: IF g_debug_unexp THEN
510: PO_DEBUG.debug_exc(p_log_head => g_log_head || l_api_name, p_progress => l_progress);

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

506: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: ' || SQLERRM);
507: END IF;
508: WHEN OTHERS THEN
509: IF g_debug_unexp THEN
510: PO_DEBUG.debug_exc(p_log_head => g_log_head || l_api_name, p_progress => l_progress);
511: END IF;
512:
513: RAISE;
514: END;

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

581:
582: EXCEPTION
583: WHEN NO_DATA_FOUND THEN
584: IF g_debug_stmt THEN
585: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: ' || SQLERRM);
586: END IF;
587: x_po_shipment_num := -1;
588:
589: WHEN OTHERS THEN

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

587: x_po_shipment_num := -1;
588:
589: WHEN OTHERS THEN
590: IF g_debug_unexp THEN
591: PO_DEBUG.debug_exc(p_log_head => g_log_head || l_api_name, p_progress => l_progress);
592: END IF;
593: --wrapup(x_interface_header_id);
594: RAISE;
595: END;

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

661:
662: EXCEPTION
663: WHEN NO_DATA_FOUND THEN
664: IF g_debug_stmt THEN
665: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: ' || SQLERRM);
666: END IF;
667: x_po_shipment_num := -1;
668:
669: WHEN OTHERS THEN

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

667: x_po_shipment_num := -1;
668:
669: WHEN OTHERS THEN
670: IF g_debug_unexp THEN
671: PO_DEBUG.debug_exc(p_log_head => g_log_head || l_api_name, p_progress => l_progress);
672: END IF;
673: RAISE;
674: END;
675: END IF;

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

680: x_po_shipment_num := -1;
681: END IF;
682:
683: IF g_debug_stmt THEN
684: PO_DEBUG.debug_end(p_log_head => g_log_head || l_api_name);
685: END IF;
686:
687: EXCEPTION
688:

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

687: EXCEPTION
688:
689: WHEN NO_DATA_FOUND THEN
690: IF g_debug_stmt THEN
691: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name, p_token => l_progress || '_main', p_message => 'NO_DATA_FOUND: ' || SQLERRM);
692: END IF;
693:
694: WHEN OTHERS THEN
695: IF g_debug_unexp THEN

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

692: END IF;
693:
694: WHEN OTHERS THEN
695: IF g_debug_unexp THEN
696: PO_DEBUG.debug_exc(p_log_head => g_log_head || l_api_name, p_progress => l_progress);
697: END IF;
698:
699: --CLM Phase 2 changes : error handling
700: PO_AUTOCREATE_PVT.report_error('PO_AUTO_GET_SHIP_NUM_ERR',x_token1_value => sqlerrm);

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

724: l_progress VARCHAR2 (3) := '000';
725: BEGIN
726:
727: IF g_debug_stmt THEN
728: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);
729: END IF;
730:
731: /* Shipment Exists */
732: IF (x_po_shipment_num <> -1) THEN

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

873: END IF;
874:
875: /* Shipment Exists */
876: IF g_debug_stmt THEN
877: po_debug.debug_end (p_log_head => g_log_head || l_api_name);
878: END IF;
879:
880: EXCEPTION
881: WHEN NO_DATA_FOUND THEN

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

879:
880: EXCEPTION
881: WHEN NO_DATA_FOUND THEN
882: IF g_debug_stmt THEN
883: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress || '_main', p_message => 'NO_DATA_FOUND: ' || SQLERRM );
884: END IF;
885: WHEN OTHERS THEN
886: IF g_debug_unexp THEN
887: po_debug.debug_exc (p_log_head => g_log_head || l_api_name, p_progress => l_progress );

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

883: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress || '_main', p_message => 'NO_DATA_FOUND: ' || SQLERRM );
884: END IF;
885: WHEN OTHERS THEN
886: IF g_debug_unexp THEN
887: po_debug.debug_exc (p_log_head => g_log_head || l_api_name, p_progress => l_progress );
888: END IF;
889: po_message_s.sql_error ('update_shipment', l_progress, SQLCODE);
890:
891: --CLM Phase 2 changes : error handling

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

929:
930: BEGIN
931:
932: IF g_debug_stmt THEN
933: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
934: END IF;
935:
936: l_progress := '010';
937: PO_AUTO_HEADER_PROCESS_PVT.fetch_headers( p_interface_header_id => PO_AUTOCREATE_PARAMS.x_interface_header_id, x_headers => x_headers );

Line 958: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'End of Process');

954: PO_AUTOCREATE_PVT.calculate_local(PO_AUTOCREATE_PARAMS.g_document_subtype, 'HEADER', x_headers.po_header_id);
955: END IF;
956:
957: IF g_debug_stmt THEN
958: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'End of Process');
959: END IF;
960:
961: IF g_debug_stmt THEN
962: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

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

958: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'End of Process');
959: END IF;
960:
961: IF g_debug_stmt THEN
962: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
963: END IF;
964:
965: EXCEPTION
966:

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

965: EXCEPTION
966:
967: WHEN OTHERS THEN
968: IF g_debug_unexp THEN
969: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
970: END IF;
971:
972: --CLM Phase 2 error reporting
973: PO_AUTOCREATE_PVT.report_error('PO_AUTO_HEADER_ERR',x_token1_value => sqlerrm);

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

1287:
1288: BEGIN
1289:
1290: IF g_debug_stmt THEN
1291: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);
1292: END IF;
1293:
1294: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
1295: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');

Line 1298: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,

1294: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
1295: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');
1296:
1297: IF g_debug_stmt THEN
1298: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,
1299: p_message => 'PO: Use Need-by Date for Default Autocreate grouping : ' || l_needby_prf);
1300: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,
1301: p_message => 'PO: Use Ship-to Organization and Location for Default Autocreate grouping : ' || l_shipto_prf);
1302: END IF;

Line 1300: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,

1296:
1297: IF g_debug_stmt THEN
1298: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,
1299: p_message => 'PO: Use Need-by Date for Default Autocreate grouping : ' || l_needby_prf);
1300: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,
1301: p_message => 'PO: Use Ship-to Organization and Location for Default Autocreate grouping : ' || l_shipto_prf);
1302: END IF;
1303:
1304: -- Fetch the Document Type Code, Doc Sub type, groupe_code, and action

Line 1320: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,

1316: WHERE phi.interface_header_id = x_interface_header_id;
1317:
1318: l_progress := '020';
1319: IF g_debug_stmt THEN
1320: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,
1321: p_message => 'Mode is:' || PO_AUTOCREATE_PARAMS.g_mode ||' g_group_code '|| PO_AUTOCREATE_PARAMS.g_group_code );
1322: END IF;
1323:
1324: IF (x_document_type_code IN ('PO', 'PA')) THEN

Line 1425: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'Group_interface_lines: mode is :' || PO_AUTOCREATE_PARAMS.g_mode );

1421: -- Shipment num should be 1.
1422: l_progress := '120';
1423:
1424: IF g_debug_stmt THEN
1425: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'Group_interface_lines: mode is :' || PO_AUTOCREATE_PARAMS.g_mode );
1426: END IF;
1427:
1428: SELECT NVL (MAX (pl.line_num), 0)
1429: INTO x_line_num

Line 1476: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'Before open interface: Grouping is default' );

1472: IF (x_document_subtype IN ('STANDARD', 'PLANNED', 'BLANKET')) THEN
1473:
1474: l_progress := '230';
1475: IF g_debug_stmt THEN
1476: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'Before open interface: Grouping is default' );
1477: END IF;
1478: --
1479: -- Get maximum line number in interface table, to be used later
1480: SELECT NVL (MAX (pli.line_num), 0)

Line 1581: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'Before get_shipment_num' );

1577: -- req lines to the same po line and the shipments are identical.
1578: l_progress := '250';
1579:
1580: IF g_debug_stmt THEN
1581: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'Before get_shipment_num' );
1582: END IF;
1583:
1584: -- As info lines and option lines will not have any shipments
1585: -- set only line number.

Line 1643: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'x_action = ' || x_action );

1639: -- check if a shipment exists that we can add to, otherwise
1640: -- get the next highest shipment number.
1641: l_progress := '270';
1642: IF g_debug_stmt THEN
1643: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'x_action = ' || x_action );
1644: END IF;
1645:
1646: --We need to retrieve the po_line_id for the
1647: -- line the user picked in the manual build process.

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

1677: -- Issue
1678: EXCEPTION
1679: WHEN NO_DATA_FOUND THEN
1680: IF g_debug_stmt THEN
1681: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: ' || SQLERRM );
1682: END IF;
1683: WHEN OTHERS THEN
1684: IF g_debug_unexp THEN
1685: po_debug.debug_exc (p_log_head => g_log_head || l_api_name, p_progress => l_progress );

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

1681: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: ' || SQLERRM );
1682: END IF;
1683: WHEN OTHERS THEN
1684: IF g_debug_unexp THEN
1685: po_debug.debug_exc (p_log_head => g_log_head || l_api_name, p_progress => l_progress );
1686: END IF;
1687:
1688: --CLM Phase 2 changes : error handling
1689: PO_AUTOCREATE_PVT.report_error('PO_AUTO_MATCH_LINE_ERR',x_token1_value => sqlerrm);

Line 1738: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'x_action = ' || x_action );

1734:
1735: l_progress := '310';
1736:
1737: IF g_debug_stmt THEN
1738: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'x_action = ' || x_action );
1739: END IF;
1740:
1741: --: allow lines grouping for blankets also
1742: IF (PO_AUTOCREATE_PARAMS.g_document_type IN ('PO', 'PA')) THEN

Line 1859: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,

1855:
1856: EXCEPTION
1857: WHEN NO_DATA_FOUND THEN
1858: IF g_debug_stmt THEN
1859: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,
1860: p_message => 'NO_DATA_FOUND: No match to po line: Doc type = ' || PO_AUTOCREATE_PARAMS.g_document_type );
1861: END IF;
1862: x_po_line_num := -1;
1863: WHEN OTHERS THEN

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

1861: END IF;
1862: x_po_line_num := -1;
1863: WHEN OTHERS THEN
1864: IF g_debug_unexp THEN
1865: po_debug.debug_exc (p_log_head => g_log_head || l_api_name, p_progress => l_progress );
1866: END IF;
1867: --wrapup(x_interface_header_id);
1868: --CLM Phase 2 changes : error handling
1869: PO_AUTOCREATE_PVT.report_error('PO_AUTO_MATCH_LINE_ERR',x_token1_value => sqlerrm);

Line 1987: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,

1983: ;
1984: EXCEPTION
1985: WHEN NO_DATA_FOUND THEN
1986: IF g_debug_stmt THEN
1987: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,
1988: p_message => 'NO_DATA_FOUND: No match to po line in Interface- Doc type = ' || PO_AUTOCREATE_PARAMS.g_document_type );
1989: END IF;
1990: x_po_line_num := -1;
1991: WHEN OTHERS THEN

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

1989: END IF;
1990: x_po_line_num := -1;
1991: WHEN OTHERS THEN
1992: IF g_debug_unexp THEN
1993: po_debug.debug_exc (p_log_head => g_log_head || l_api_name, p_progress => l_progress );
1994: END IF;
1995: --CLM Phase 2 changes : error handling
1996: PO_AUTOCREATE_PVT.report_error('PO_AUTO_MATCH_LINE_REQ_ERR',x_token1_value => sqlerrm);
1997: RAISE;

Line 2003: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,

1999: END IF; -- PO/PA
2000: END IF; -- if x_po_line_num = -1 (interface table)
2001:
2002: IF g_debug_stmt THEN
2003: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,
2004: p_message => 'At group Interface Lines: x_po_line_num:'||x_po_line_num );
2005: END IF;
2006:
2007: IF (x_po_line_num <> -1) THEN

Line 2018: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,

2014: -- backing req line exists
2015: -- Since get_shipment_num will need it, we update the
2016: -- line number here.
2017: IF g_debug_stmt THEN
2018: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,
2019: p_message => 'Before update line_num: Line Id:'||x_requisition_line_id||' Line Num:'||x_po_line_num );
2020: END IF;
2021:
2022: UPDATE po_lines_interface pli

Line 2046: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'Before update_shipment' );

2042: x_receipt_req_flag,
2043: x_create_new_line ); -- FPI GA
2044:
2045: IF g_debug_stmt THEN
2046: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'Before update_shipment' );
2047: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,
2048: p_message => 'x_create_new_line:'||x_create_new_line||
2049: 'x_po_line_num:'||x_po_line_num||
2050: 'x_po_shipment_num:'||x_po_shipment_num );

Line 2047: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,

2043: x_create_new_line ); -- FPI GA
2044:
2045: IF g_debug_stmt THEN
2046: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'Before update_shipment' );
2047: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,
2048: p_message => 'x_create_new_line:'||x_create_new_line||
2049: 'x_po_line_num:'||x_po_line_num||
2050: 'x_po_shipment_num:'||x_po_shipment_num );
2051: END IF;

Line 2099: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,

2095: -- The shipment number should be 1.
2096:
2097: l_progress := '410';
2098: IF g_debug_stmt THEN
2099: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,
2100: p_message => 'Group_interface_lines: Line does not exist' );
2101: END IF;
2102:
2103: SELECT NVL (MAX (pl.line_num), 0)

Line 2116: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,

2112:
2113: -- Get the max line number already assigne in the interface table
2114: l_progress := '420';
2115: IF g_debug_stmt THEN
2116: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,
2117: p_message => 'Before select max line_num from po_lines_interface' );
2118: END IF;
2119:
2120: SELECT NVL (MAX (pli.line_num), 0)

Line 2135: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,

2131: l_progress := '430';
2132:
2133: --: when req line id is null, use x_row_id
2134: IF g_debug_stmt THEN
2135: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,
2136: p_message => 'Sourcing to PO: Update Line Num : x_line_num : '|| x_line_num );
2137: END IF;
2138:
2139: IF (x_requisition_line_id IS NOT NULL) THEN

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

2166: END IF; -- of same as REQUISITION mode
2167: END IF; -- of PO mode
2168:
2169: IF g_debug_stmt THEN
2170: po_debug.debug_end (p_log_head => g_log_head || l_api_name);
2171: END IF;
2172:
2173: EXCEPTION
2174: WHEN NO_DATA_FOUND THEN

Line 2176: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'Exception block: NO_DATA_FOUND: ' || SQLERRM );

2172:
2173: EXCEPTION
2174: WHEN NO_DATA_FOUND THEN
2175: IF g_debug_stmt THEN
2176: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'Exception block: NO_DATA_FOUND: ' || SQLERRM );
2177: END IF;
2178: NULL;
2179: WHEN OTHERS THEN
2180: IF g_debug_unexp THEN

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

2177: END IF;
2178: NULL;
2179: WHEN OTHERS THEN
2180: IF g_debug_unexp THEN
2181: po_debug.debug_exc (p_log_head => g_log_head || l_api_name, p_progress => l_progress || '_main' );
2182: END IF;
2183:
2184: --CLM Phase 2 changes : error handling
2185: PO_AUTOCREATE_PVT.report_error('PO_AUTO_GRP_RECORDS_ERR',x_token1_value => sqlerrm);

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

2235:
2236: BEGIN
2237:
2238: IF g_debug_stmt THEN
2239: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2240: END IF;
2241:
2242: l_progress := '010';
2243: PO_AUTO_LINE_PROCESS_PVT.setup_interface_data;

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

2264: l_progress := '070';
2265: PO_AUTO_LINE_PROCESS_PVT.merge_to_attr_values_draft(p_lines => x_lines);
2266:
2267: IF g_debug_stmt THEN
2268: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
2269: p_message => 'After calling all the procedures from PO_AUTO_LINE_PROCESS_PVT');
2270: END IF;
2271:
2272: IF g_debug_stmt THEN

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

2269: p_message => 'After calling all the procedures from PO_AUTO_LINE_PROCESS_PVT');
2270: END IF;
2271:
2272: IF g_debug_stmt THEN
2273: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
2274: END IF;
2275:
2276: EXCEPTION
2277:

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

2276: EXCEPTION
2277:
2278: WHEN OTHERS THEN
2279: IF g_debug_unexp THEN
2280: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2281: END IF;
2282:
2283: --CLM Phase 2 changes : error handling
2284: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_ERR',x_token1_value => sqlerrm);

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

2309:
2310: BEGIN
2311:
2312: IF g_debug_stmt THEN
2313: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2314: END IF;
2315:
2316: IF po_autocreate_params.g_document_subtype = 'BLANKET' THEN
2317:

Line 2343: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'End of Line Locations Process');

2339: l_progress := '040';
2340: PO_AUTO_LINE_LOC_PROCESS_PVT.update_req_lines(x_lines);
2341:
2342: IF g_debug_stmt THEN
2343: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'End of Line Locations Process');
2344: END IF;
2345:
2346: IF g_debug_stmt THEN
2347: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

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

2343: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'End of Line Locations Process');
2344: END IF;
2345:
2346: IF g_debug_stmt THEN
2347: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
2348: END IF;
2349:
2350: EXCEPTION
2351:

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

2350: EXCEPTION
2351:
2352: WHEN OTHERS THEN
2353: IF g_debug_unexp THEN
2354: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2355: END IF;
2356:
2357: --CLM Phase 2 changes : error handling
2358: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_LOC_ERR',x_token1_value => sqlerrm);

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

2381:
2382: BEGIN
2383:
2384: IF g_debug_stmt THEN
2385: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2386: END IF;
2387:
2388: IF (po_autocreate_params.g_is_complex_work_po) THEN
2389:

Line 2393: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'create_payitem_dists');

2389:
2390: l_progress := '010';
2391: po_auto_dist_process_pvt.create_payitem_dists( p_lines => x_lines );
2392: IF g_debug_stmt THEN
2393: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'create_payitem_dists');
2394: END IF;
2395:
2396: ELSE
2397:

Line 2401: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'derive_and_default_dists');

2397:
2398: l_progress := '020';
2399: po_auto_dist_process_pvt.derive_and_default_dists( p_lines => x_lines);
2400: IF g_debug_stmt THEN
2401: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'derive_and_default_dists');
2402: END IF;
2403:
2404: END IF;
2405:

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

2403:
2404: END IF;
2405:
2406: IF g_debug_stmt THEN
2407: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
2408: END IF;
2409:
2410: -- ACRN proj changes
2411: l_progress := '030';

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

2412: -- Calling Default_Acrn_Values API
2413: po_auto_dist_process_pvt.Default_Acrn_Values;
2414:
2415: IF g_debug_stmt THEN
2416: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
2417: END IF;
2418: -- ACRN proj end
2419:
2420: EXCEPTION

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

2419:
2420: EXCEPTION
2421: WHEN OTHERS THEN
2422: IF g_debug_unexp THEN
2423: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2424: END IF;
2425:
2426: --CLM Phase 2 changes : error handling
2427: PO_AUTOCREATE_PVT.report_error('PO_AUTO_DIST_ERR',x_token1_value => sqlerrm);

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

2452:
2453: BEGIN
2454:
2455: IF g_debug_stmt THEN
2456: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2457: END IF;
2458:
2459: -- process each entity from upper to lower level
2460: l_progress := '010';

Line 2474: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'End of Process');

2470: l_progress := '040';
2471: process_distributions;
2472:
2473: IF g_debug_stmt THEN
2474: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'End of Process');
2475: END IF;
2476:
2477: EXCEPTION
2478: WHEN OTHERS THEN

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

2477: EXCEPTION
2478: WHEN OTHERS THEN
2479:
2480: IF g_debug_unexp THEN
2481: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2482: END IF;
2483:
2484: -- CLM Phase 2 Changes : Error Handling
2485: PO_AUTOCREATE_PVT.report_error('PO_AUTO_MAINPROC_ERR',x_token1_value => sqlerrm);

Line 2524: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,

2520: AND pk2_value = 'ONE_TIME_LOCATION'
2521: AND ROWNUM = 1;
2522:
2523: IF g_debug_stmt THEN
2524: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,
2525: p_message => 'Req line ' || p_req_line_id || ' has one-time attachment' );
2526: END IF;
2527:
2528: RETURN TRUE;

Line 2533: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'Req line is null' );

2529:
2530: ELSE
2531:
2532: IF g_debug_stmt THEN
2533: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'Req line is null' );
2534: END IF;
2535:
2536: RETURN FALSE;
2537:

Line 2545: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,

2541:
2542: WHEN NO_DATA_FOUND THEN
2543:
2544: IF g_debug_stmt THEN
2545: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,
2546: p_message => 'NO_DATA_FOUND: No one-time attachment for req line ' || p_req_line_id );
2547: END IF;
2548:
2549: RETURN FALSE;

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

2550:
2551: WHEN OTHERS THEN
2552:
2553: IF g_debug_unexp THEN
2554: po_debug.debug_exc (p_log_head => g_log_head || l_api_name, p_progress => l_progress );
2555: END IF;
2556:
2557: RETURN FALSE;
2558:

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

2677: x_msg_data VARCHAR2(1000);
2678:
2679: BEGIN
2680: IF g_debug_stmt THEN
2681: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2682: END IF;
2683:
2684: l_progress := '020';
2685: IF g_debug_stmt THEN

Line 2686: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name , p_token => l_progress , p_message => 'Style ID :' || p_style_id );

2682: END IF;
2683:
2684: l_progress := '020';
2685: IF g_debug_stmt THEN
2686: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name , p_token => l_progress , p_message => 'Style ID :' || p_style_id );
2687: END IF;
2688:
2689: l_progress := '030';
2690: l_target_template_id := PO_UDA_AUTOCREATE_PKG.get_uda_template_id

Line 2696: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name , p_token => l_progress , p_message => 'Target Tempalte ID :' || l_target_template_id );

2692: p_doc_type => 'STANDARD' ,
2693: p_doc_level => 'LINE' ,
2694: p_doc_style_id => p_style_id );
2695: IF g_debug_stmt THEN
2696: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name , p_token => l_progress , p_message => 'Target Tempalte ID :' || l_target_template_id );
2697: END IF;
2698:
2699: l_progress := '040';
2700: FOR i IN 1..p_po_line_id_tbl.Count

Line 2709: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name , p_token => l_progress , p_message => 'l_src_template_id' || l_src_template_id );

2705: p_po_line_id_tbl(i) ,
2706: NULL,
2707: NULL);
2708: IF g_debug_stmt THEN
2709: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name , p_token => l_progress , p_message => 'l_src_template_id' || l_src_template_id );
2710: END IF;
2711:
2712: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY ( EGO_COL_NAME_VALUE_PAIR_OBJ
2713: ('PO_LINE_ID',

Line 2718: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name , p_token => l_progress , p_message => 'PO_LINE_ID : ' || p_po_line_id_tbl(i) );

2714: p_po_line_id_tbl(i) ),
2715: EGO_COL_NAME_VALUE_PAIR_OBJ
2716: ( 'DRAFT_ID', -1) );
2717: IF g_debug_stmt THEN
2718: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name , p_token => l_progress , p_message => 'PO_LINE_ID : ' || p_po_line_id_tbl(i) );
2719: END IF;
2720:
2721: l_progress := '100';
2722:

Line 2735: po_debug.debug_var(p_log_head => g_log_head||l_api_name , p_progress => l_progress , p_name => 'l_attr_group_tbl' , p_value => l_attr_group_tbl );

2731: AND tu.template_id = l_src_template_id
2732: AND tu.attribute_category = 'PRICING';
2733:
2734: IF g_debug_stmt THEN
2735: po_debug.debug_var(p_log_head => g_log_head||l_api_name , p_progress => l_progress , p_name => 'l_attr_group_tbl' , p_value => l_attr_group_tbl );
2736: END IF;
2737:
2738: l_progress := '120';
2739: to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY ( EGO_COL_NAME_VALUE_PAIR_OBJ

Line 2761: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name ,

2757: x_return_status => x_return_status ,
2758: x_msg_count => x_msg_count ,
2759: x_msg_data => x_msg_data );
2760: IF g_debug_stmt THEN
2761: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name ,
2762: p_token => l_progress ,
2763: p_message => 'After Calling PO_UDA_DATA_UTIL.AutoCreate_User_Attrs Return Status ' || x_return_status ||
2764: ' Message Count :' || x_msg_count ||' Message Data: '|| x_msg_data );
2765: END IF;

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

2771: END IF;
2772: END LOOP;
2773:
2774: IF g_debug_stmt THEN
2775: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
2776: END IF;
2777:
2778: EXCEPTION
2779: WHEN FND_API.G_EXC_ERROR THEN

Line 2784: PO_DEBUG.debug_end(g_log_head||l_api_name);

2780: l_progress := '150';
2781: fnd_msg_pub.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2782: IF (PO_LOG.d_exc) THEN
2783: PO_LOG.exc(g_log_head||l_api_name, l_progress, x_msg_data );
2784: PO_DEBUG.debug_end(g_log_head||l_api_name);
2785: END IF;
2786:
2787: WHEN OTHERS THEN
2788: IF g_debug_unexp THEN

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

2785: END IF;
2786:
2787: WHEN OTHERS THEN
2788: IF g_debug_unexp THEN
2789: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2790: END IF;
2791: END sync_complex_pricing;
2792:
2793:

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

2814: l_return_status VARCHAR2(1):= NULL;
2815:
2816: BEGIN
2817: IF g_debug_stmt THEN
2818: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2819: END IF;
2820:
2821: l_progress := '010';
2822:

Line 2824: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'p_style_id : '||p_style_id);

2820:
2821: l_progress := '010';
2822:
2823: IF g_debug_stmt THEN
2824: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'p_style_id : '||p_style_id);
2825: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Entity Level : '||p_level);
2826: END IF;
2827:
2828: l_progress := '020';

Line 2825: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Entity Level : '||p_level);

2821: l_progress := '010';
2822:
2823: IF g_debug_stmt THEN
2824: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'p_style_id : '||p_style_id);
2825: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Entity Level : '||p_level);
2826: END IF;
2827:
2828: l_progress := '020';
2829: l_template_id := PO_UDA_AUTOCREATE_PKG.get_uda_template_id

Line 2835: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'l_template_id : '||l_template_id);

2831: p_doc_type => 'STANDARD' ,
2832: p_doc_level => p_level ,
2833: p_doc_style_id => p_style_id );
2834: IF g_debug_stmt THEN
2835: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'l_template_id : '||l_template_id);
2836: END IF;
2837:
2838: IF p_level ='LINE' THEN
2839: l_progress := '040';

Line 2844: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Line Id : '||p_po_line_id_tbl(i));

2840: FOR i IN 1..p_po_line_id_tbl.Count
2841: LOOP
2842: l_progress := '050';
2843: IF g_debug_stmt THEN
2844: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Line Id : '||p_po_line_id_tbl(i));
2845: END IF;
2846:
2847: SELECT DISTINCT ag.attr_group_name BULK COLLECT
2848: INTO x_attr_group_tbl

Line 2878: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

2874: x_return_status => l_return_status,
2875: x_msg_count => l_msg_count,
2876: x_msg_data => l_msg_data );
2877: IF g_debug_stmt THEN
2878: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
2879: ,p_token => l_progress
2880: ,p_message => 'After Calling PO_UDA_DATA_UTIL.Copy_User_Attrs for LINE '|| l_return_status ||
2881: ' Message Count :' || l_msg_count ||' Message Data: '|| l_msg_data );
2882: END IF;

Line 2895: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Line Location Id : '||p_line_location_id_tbl(i));

2891: FOR i IN 1..p_line_location_id_tbl.Count
2892: LOOP
2893: l_progress := '080';
2894: IF g_debug_stmt THEN
2895: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Line Location Id : '||p_line_location_id_tbl(i));
2896: END IF;
2897:
2898: SELECT DISTINCT ag.attr_group_name BULK COLLECT
2899: INTO x_attr_group_tbl

Line 2928: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

2924: x_return_status => l_return_status,
2925: x_msg_count => l_msg_count,
2926: x_msg_data => l_msg_data );
2927: IF g_debug_stmt THEN
2928: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
2929: ,p_token => l_progress
2930: ,p_message => 'After Calling PO_UDA_DATA_UTIL.Copy_User_Attrs for LINE '|| l_return_status ||
2931: ' Message Count :' || l_msg_count ||' Message Data: '|| l_msg_data );
2932: END IF;

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

2937: END IF;
2938: END LOOP;
2939: END IF;
2940: IF g_debug_stmt THEN
2941: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
2942: END IF;
2943: EXCEPTION
2944: WHEN FND_API.G_EXC_ERROR THEN
2945: l_progress := '100';

Line 2949: PO_DEBUG.debug_end(g_log_head||l_api_name);

2945: l_progress := '100';
2946: fnd_msg_pub.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
2947: IF (PO_LOG.d_exc) THEN
2948: PO_LOG.exc(g_log_head||l_api_name, l_progress, l_msg_data );
2949: PO_DEBUG.debug_end(g_log_head||l_api_name);
2950: END IF;
2951: WHEN OTHERS THEN
2952: IF g_debug_unexp THEN
2953: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

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

2949: PO_DEBUG.debug_end(g_log_head||l_api_name);
2950: END IF;
2951: WHEN OTHERS THEN
2952: IF g_debug_unexp THEN
2953: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2954: END IF;
2955: END sync_uda;
2956:
2957: