DBA Data[Home] [Help]

APPS.PO_AUTO_IMPLEMENT_PVT dependencies on PO_DEBUG

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

4:
5: g_pkg_name CONSTANT VARCHAR2(1000) := 'PO_AUTO_IMPLEMENT_PVT';
6: g_log_head CONSTANT VARCHAR2(1000) := 'po.plsql.PO_AUTO_IMPLEMENT_PVT.';
7:
8: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
9: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
10:
11:
12: x_org_id PO_HEADERS_INTERFACE.org_id%TYPE;

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

5: g_pkg_name CONSTANT VARCHAR2(1000) := 'PO_AUTO_IMPLEMENT_PVT';
6: g_log_head CONSTANT VARCHAR2(1000) := 'po.plsql.PO_AUTO_IMPLEMENT_PVT.';
7:
8: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
9: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
10:
11:
12: x_org_id PO_HEADERS_INTERFACE.org_id%TYPE;
13:

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

59:
60: BEGIN
61:
62: IF g_debug_stmt THEN
63: PO_DEBUG.debug_begin(p_log_head => g_log_head||'l_api_name');
64: END IF;
65:
66: /* Populate Header - starts here */
67:

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

106: INTO PO_AUTOCREATE_PARAMS.x_interface_header_id
107: FROM dual;
108:
109: IF g_debug_stmt THEN
110: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
111: p_token => l_progress,
112: p_message => 'After getting interface header id :'||PO_AUTOCREATE_PARAMS.x_interface_header_id);
113: END IF;
114:

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

178:
179: EXCEPTION
180: WHEN OTHERS THEN
181: IF g_debug_unexp THEN
182: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
183: p_progress => l_progress);
184: END IF;
185: PO_AUTOCREATE_PVT.wrapup;
186: RAISE;

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

187: END;
188:
189: l_progress:= '040';
190: IF g_debug_stmt THEN
191: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
192: p_token => l_progress,
193: p_message => 'After inserting records into po_headers_interface: interface_header_id : '||PO_AUTOCREATE_PARAMS.x_interface_header_id);
194: END IF;
195:

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

250:
251: EXCEPTION
252: WHEN No_Data_Found THEN
253: IF g_debug_unexp THEN
254: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
255: p_progress => l_progress);
256: END IF;
257: x_po_line_location_id := NULL;
258: PO_AUTOCREATE_PVT.wrapup;

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

272:
273:
274: l_progress:= '080';
275: IF g_debug_stmt THEN
276: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
277: p_token => l_progress,
278: p_message => 'After getting PO details : line_num : '||x_po_line_num||': shipment_num :'||x_po_shipment_num);
279: END IF;
280:

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

392:
393: EXCEPTION
394: WHEN OTHERS THEN
395: IF g_debug_unexp THEN
396: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
397: p_progress => l_progress);
398: END IF;
399: PO_AUTOCREATE_PVT.wrapup;
400: RAISE;

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

404:
405: /* Populate Lines - ends here */
406:
407: IF g_debug_stmt THEN
408: PO_DEBUG.debug_end(p_log_head => g_log_head||'l_api_name');
409: END IF;
410:
411:
412: EXCEPTION

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

412: EXCEPTION
413: WHEN OTHERS THEN
414: PO_AUTOCREATE_PVT.wrapup;
415: IF g_debug_unexp THEN
416: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
417: p_progress => l_progress);
418: END IF;
419: po_message_s.sql_error('populate_interface',l_progress,sqlcode);
420: raise;

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

453:
454: BEGIN
455:
456: IF g_debug_stmt THEN
457: PO_DEBUG.debug_begin(p_log_head => g_log_head||'l_api_name');
458: END IF;
459:
460: l_progress:= '010';
461:

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

496:
497: EXCEPTION
498: WHEN No_Data_Found THEN
499: IF g_debug_unexp THEN
500: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
501: p_progress => l_progress);
502: END IF;
503: x_po_line_location_id := NULL;
504: PO_AUTOCREATE_PVT.wrapup;

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

517:
518:
519: l_progress:= '040';
520: IF g_debug_stmt THEN
521: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
522: p_token => l_progress,
523: p_message => 'After getting PO details : po_header_id : '||x_po_header_id);
524: END IF;
525:

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

528: populate_interface(x_po_header_id, x_req_line_id);
529:
530: l_progress:= '050';
531: IF g_debug_stmt THEN
532: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
533: p_token => l_progress,
534: p_message => 'After populating the interface tables');
535: END IF;
536:

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

547: );
548:
549: l_progress:= '060';
550: IF g_debug_stmt THEN
551: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
552: p_token => l_progress,
553: p_message => 'The AutoCreate returns successfully');
554: END IF;
555:

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

554: END IF;
555:
556:
557: IF g_debug_stmt THEN
558: PO_DEBUG.debug_end(p_log_head => g_log_head||'l_api_name');
559: END IF;
560:
561:
562: EXCEPTION

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

562: EXCEPTION
563: WHEN OTHERS THEN
564: PO_AUTOCREATE_PVT.wrapup;
565: IF g_debug_unexp THEN
566: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
567: p_progress => l_progress);
568: END IF;
569: po_message_s.sql_error('process',l_progress,sqlcode);
570: raise;