DBA Data[Home] [Help]

APPS.PO_RELGEN_PKG dependencies on PO_DEBUG

Line 33: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;

29:
30: -- Read the profile option that enables/disables the debug log
31: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
32:
33: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;
34:
35: --
36: g_chktype_TRACKING_QTY_IND CONSTANT
37: MTL_SYSTEM_ITEMS_B.TRACKING_QUANTITY_IND%TYPE

Line 213: PO_DEBUG.debug_stmt (

209: l_progress := '042';
210:
211: IF l_tax_return_status <> FND_API.G_RET_STS_SUCCESS THEN
212: IF (g_debug_stmt) THEN
213: PO_DEBUG.debug_stmt (
214: p_log_head => c_log_head||l_api_name,
215: p_token => '',
216: p_message => 'Error in tax calcualtion'
217: ||' po_release_id: '||x_po_release_id

Line 340: PO_DEBUG.debug_stmt (

336: -- Rollback the creation of the release.
337: ROLLBACK TO PORELGEN_1;
338: -- Bug 3570793 START
339: IF (g_debug_stmt) THEN
340: PO_DEBUG.debug_stmt (
341: p_log_head => c_log_head||l_api_name,
342: p_token => '',
343: p_message => 'Preapproval checks failed; rollback'
344: ||' po_release_id: '||x_po_release_id

Line 374: PO_DEBUG.debug_stmt (p_log_head => c_log_head||l_api_name,

370: WHERE pda.line_location_id = x_line_location_id
371: AND pda.lcm_flag = 'Y';
372:
373: IF (g_debug_stmt) THEN
374: PO_DEBUG.debug_stmt (p_log_head => c_log_head||l_api_name,
375: p_token => '',
376: p_message => 'Preapproval checks for LCM features failed'
377: ||' po_release_id: '||x_po_release_id);
378: END IF;

Line 487: PO_DEBUG.debug_stmt (

483: p_calling_program =>'PORELGEB');
484: l_progress := '042';
485: IF l_tax_return_status <> FND_API.G_RET_STS_SUCCESS THEN
486: IF (g_debug_stmt) THEN
487: PO_DEBUG.debug_stmt (
488: p_log_head => c_log_head||l_api_name,
489: p_token => '',
490: p_message => 'Error in tax calcualtion'
491: ||' po_release_id: '||x_po_release_id

Line 597: PO_DEBUG.debug_stmt (

593: -- Rollback the creation of the release.
594: ROLLBACK TO PORELGEN_1;
595: -- Bug 3570793 START
596: IF (g_debug_stmt) THEN
597: PO_DEBUG.debug_stmt (
598: p_log_head => c_log_head||l_api_name,
599: p_token => '',
600: p_message => 'Preapproval checks failed; rollback'
601: ||' po_release_id: '||x_po_release_id

Line 631: PO_DEBUG.debug_stmt (p_log_head => c_log_head||l_api_name,

627: WHERE pda.line_location_id = x_line_location_id
628: AND pda.lcm_flag = 'Y';
629:
630: IF (g_debug_stmt) THEN
631: PO_DEBUG.debug_stmt (p_log_head => c_log_head||l_api_name,
632: p_token => '',
633: p_message => 'Preapproval checks for LCM features failed'
634: ||' po_release_id: '||x_po_release_id);
635: END IF;

Line 666: PO_DEBUG.write_msg_list_to_file (

662: EXCEPTION
663: -- Bug 3570793 START
664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
665: -- Write the errors on the message list to the concurrent program log.
666: PO_DEBUG.write_msg_list_to_file (
667: p_log_head => c_log_head || l_api_name,
668: p_progress => l_progress
669: );
670: raise_application_error(-20001,sqlerrm||'---'||msgbuf);

Line 755: PO_DEBUG.debug_stmt (

751: WHERE PO_HEADER_ID = req_line.blanket_po_header_id;
752:
753: -- Bug 3570793 START
754: IF (g_debug_stmt) THEN
755: PO_DEBUG.debug_stmt (
756: p_log_head => c_log_head||l_api_name,
757: p_token => '',
758: p_message => 'Create release header;'
759: ||' req_line_id: '||req_line.requisition_line_id

Line 1116: PO_DEBUG.debug_stmt (

1112: then we should not convert the quantity. */
1113:
1114: -- Bug 3570793 START
1115: IF (g_debug_stmt) THEN
1116: PO_DEBUG.debug_stmt (
1117: p_log_head => c_log_head||l_api_name,
1118: p_token => '',
1119: p_message => 'Create release shipment;'
1120: ||' req_line_id: '||req_line.requisition_line_id

Line 1404: PO_DEBUG.debug_stmt (

1400:
1401: BEGIN --
1402: -- Bug 3570793 START
1403: IF (g_debug_stmt) THEN
1404: PO_DEBUG.debug_stmt (
1405: p_log_head => c_log_head||l_api_name,
1406: p_token => '',
1407: p_message => 'Create release distributions;'
1408: ||' req_line_id: '||req_line.requisition_line_id

Line 3447: PO_DEBUG.write_msg_list_to_file (

3443: EXCEPTION
3444: WHEN FND_API.G_EXC_ERROR THEN
3445: ROLLBACK TO PORELGEN_1;
3446: -- Bug 3570793 Write the message list to the concurrent program log.
3447: PO_DEBUG.write_msg_list_to_file (
3448: p_log_head => c_log_head || l_api_name,
3449: p_progress => l_progress
3450: );
3451:

Line 3455: PO_DEBUG.write_msg_list_to_file (

3451:
3452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3453: ROLLBACK TO PORELGEN_1;
3454: -- Bug 3570793 Write the message list to the concurrent program log.
3455: PO_DEBUG.write_msg_list_to_file (
3456: p_log_head => c_log_head || l_api_name,
3457: p_progress => l_progress
3458: );
3459:

Line 3581: PO_DEBUG.write_msg_list_to_file (

3577:
3578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3579:
3580: -- Bug 3570793 Write the message list to the concurrent program log.
3581: PO_DEBUG.write_msg_list_to_file (
3582: p_log_head => c_log_head || l_api_name,
3583: p_progress => l_progress
3584: );
3585:

Line 3637: PO_DEBUG.debug_begin(p_log_head => c_log_head||l_api_name);

3633: l_aslid NUMBER;
3634: begin
3635:
3636: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
3637: PO_DEBUG.debug_begin(p_log_head => c_log_head||l_api_name);
3638: END IF;
3639:
3640: l_progress := '010';
3641: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 3642: PO_DEBUG.debug_stmt(p_log_head => c_log_head||l_api_name,

3638: END IF;
3639:
3640: l_progress := '010';
3641: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
3642: PO_DEBUG.debug_stmt(p_log_head => c_log_head||l_api_name,
3643: p_token => l_progress,
3644: p_message => 'Get_asl_id : item_id : '||p_item_id||
3645: 'category_id : '||p_category_id||
3646: 'destination_organization_id : '||p_destination_organization_id||

Line 3703: PO_DEBUG.debug_stmt(p_log_head => c_log_head||l_api_name,

3699: WHERE rownum < 2 ;
3700:
3701: l_progress := '030';
3702: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
3703: PO_DEBUG.debug_stmt(p_log_head => c_log_head||l_api_name,
3704: p_token => l_progress,
3705: p_message => 'Get_asl_id : l_aslid : '||l_aslid);
3706: END IF;
3707:

Line 3716: PO_DEBUG.debug_stmt(p_log_head => c_log_head||l_api_name,

3712: EXCEPTION WHEN NO_DATA_FOUND THEN
3713: l_aslid := -1;
3714: l_progress := '040';
3715: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
3716: PO_DEBUG.debug_stmt(p_log_head => c_log_head||l_api_name,
3717: p_token => l_progress,
3718: p_message => 'Get_asl_id in exception block : l_aslid : '||l_aslid);
3719: END IF;
3720: RETURN l_aslid;