APPS.PO_VENDOR_SITES_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_VENDOR_SITES_SV AS
2: /* $Header: POXVDVSB.pls 120.17.12020000.2 2013/02/11 00:09:20 vegajula 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: -- FUNCTION : get_vendor_site_id --
9: -- TYPE : Private

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

745: END IF;
746:
747: p_vendor_site_record.error_record.error_status := 'U';
748: p_vendor_site_record.error_record.error_message := sqlerrm;
749: IF (g_asn_debug = 'Y') THEN
750: asn_debug.put_line(p_vendor_site_record.error_record.error_message);
751: END IF;
752:
753: END derive_vendor_site_info;

Line 750: asn_debug.put_line(p_vendor_site_record.error_record.error_message);

746:
747: p_vendor_site_record.error_record.error_status := 'U';
748: p_vendor_site_record.error_record.error_message := sqlerrm;
749: IF (g_asn_debug = 'Y') THEN
750: asn_debug.put_line(p_vendor_site_record.error_record.error_message);
751: END IF;
752:
753: END derive_vendor_site_info;
754:

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

1024: dbms_sql.close_cursor(X_cid);
1025: END IF;
1026: p_vendor_site_record.error_record.error_status := 'U';
1027: p_vendor_site_record.error_record.error_message := sqlerrm;
1028: IF (g_asn_debug = 'Y') THEN
1029: asn_debug.put_line(p_vendor_site_record.error_record.error_message);
1030: END IF;
1031:
1032: END validate_vendor_site_info;

Line 1029: asn_debug.put_line(p_vendor_site_record.error_record.error_message);

1025: END IF;
1026: p_vendor_site_record.error_record.error_status := 'U';
1027: p_vendor_site_record.error_record.error_message := sqlerrm;
1028: IF (g_asn_debug = 'Y') THEN
1029: asn_debug.put_line(p_vendor_site_record.error_record.error_message);
1030: END IF;
1031:
1032: END validate_vendor_site_info;
1033: