APPS.PO_ORGS_SV dependencies on ASN_DEBUG

Line 5: g_asn_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_RVCTP_ENABLE_TRACE'),'N');

1: PACKAGE BODY PO_ORGS_SV as
2: /* $Header: POXCOO2B.pls 120.1.12010000.3 2008/09/24 07:12:02 cvardia ship $*/
3:
4: -- Read the profile option that enables/disables the debug log
5: g_asn_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_RVCTP_ENABLE_TRACE'),'N');
6: /*===========================================================================
7:
8: PROCEDURE NAME : get_org_info()
9:

Line 455: IF (g_asn_debug = 'Y') THEN

451: p_org_record.error_record.error_status := 'W';
452: WHEN others THEN
453: p_org_record.error_record.error_status := 'U';
454: p_org_record.error_record.error_message := sqlerrm;
455: IF (g_asn_debug = 'Y') THEN
456: asn_debug.put_line(p_org_record.error_record.error_message);
457: END IF;
458:
459: END derive_org_info;

Line 456: asn_debug.put_line(p_org_record.error_record.error_message);

452: WHEN others THEN
453: p_org_record.error_record.error_status := 'U';
454: p_org_record.error_record.error_message := sqlerrm;
455: IF (g_asn_debug = 'Y') THEN
456: asn_debug.put_line(p_org_record.error_record.error_message);
457: END IF;
458:
459: END derive_org_info;
460:

Line 560: IF (g_asn_debug = 'Y') THEN

556: p_org_record.error_record.error_message := 'TOOMANYROWS';
557: WHEN OTHERS THEN
558: p_org_record.error_record.error_status := 'U';
559: p_org_record.error_record.error_message := sqlerrm;
560: IF (g_asn_debug = 'Y') THEN
561: asn_debug.put_line(p_org_record.error_record.error_message);
562: END IF;
563:
564:

Line 561: asn_debug.put_line(p_org_record.error_record.error_message);

557: WHEN OTHERS THEN
558: p_org_record.error_record.error_status := 'U';
559: p_org_record.error_record.error_message := sqlerrm;
560: IF (g_asn_debug = 'Y') THEN
561: asn_debug.put_line(p_org_record.error_record.error_message);
562: END IF;
563:
564:
565:

Line 687: IF (g_asn_debug = 'Y') THEN

683: dbms_sql.close_cursor(X_cid);
684: END IF;
685: p_org_record.error_record.error_status := 'U';
686: p_org_record.error_record.error_message := sqlerrm;
687: IF (g_asn_debug = 'Y') THEN
688: asn_debug.put_line(p_org_record.error_record.error_message);
689: END IF;
690: */
691: END validate_org_info;

Line 688: asn_debug.put_line(p_org_record.error_record.error_message);

684: END IF;
685: p_org_record.error_record.error_status := 'U';
686: p_org_record.error_record.error_message := sqlerrm;
687: IF (g_asn_debug = 'Y') THEN
688: asn_debug.put_line(p_org_record.error_record.error_message);
689: END IF;
690: */
691: END validate_org_info;
692: