DBA Data[Home] [Help]

APPS.JA_INTERFACE_VAL dependencies on STANDARD

Line 345: -- 2 Tax Invoice Date GLOBAL_ATTRIBUTE2 FND_STANDARD_DATE No

341: --------------------------------------------------------------------------------------
342: -- No. Name Column Value Set Required
343: -- --- -------------------------- ------------------ ----------------- ------------
344: -- 1 Tax Invoice Number GLOBAL_ATTRIBUTE1 No
345: -- 2 Tax Invoice Date GLOBAL_ATTRIBUTE2 FND_STANDARD_DATE No
346: -- 3 Supplier Tax Invoice Number GLOBAL_ATTRIBUTE3 No
347: -- 4 Tax Accounting Period GLOBAL_ATTRIBUTE4 JATH_AP_TAX_ACCT_PERIOD No
348: --------------------------------------------------------------------------------------
349: PROCEDURE ja_th_apxiisim_invoices_folder

Line 385: -- Check if Tax Invoice Date is of Standard Date Format

381: BEGIN
382:
383: IF (p_global_attribute2 IS NOT NULL) THEN
384:
385: -- Check if Tax Invoice Date is of Standard Date Format
386:
387: BEGIN
388: SELECT fnd_date.canonical_to_date(p_global_attribute2)
389: INTO l_tax_inv_date

Line 881: arp_standard.debug('No data found in RA_CUSTOMERS table for Update');

877: WHERE
878: rc.orig_system_reference = l_orig_system_customer_ref;
879: EXCEPTION
880: WHEN NO_DATA_FOUND THEN
881: arp_standard.debug('No data found in RA_CUSTOMERS table for Update');
882: WHEN OTHERS THEN
883: arp_standard.debug('Exception in ja_interface_val.ja_tw_arxcudci_customers');
884: arp_standard.debug(SQLERRM);
885: END;

Line 883: arp_standard.debug('Exception in ja_interface_val.ja_tw_arxcudci_customers');

879: EXCEPTION
880: WHEN NO_DATA_FOUND THEN
881: arp_standard.debug('No data found in RA_CUSTOMERS table for Update');
882: WHEN OTHERS THEN
883: arp_standard.debug('Exception in ja_interface_val.ja_tw_arxcudci_customers');
884: arp_standard.debug(SQLERRM);
885: END;
886: ELSE
887: l_customer_id := 0;

Line 884: arp_standard.debug(SQLERRM);

880: WHEN NO_DATA_FOUND THEN
881: arp_standard.debug('No data found in RA_CUSTOMERS table for Update');
882: WHEN OTHERS THEN
883: arp_standard.debug('Exception in ja_interface_val.ja_tw_arxcudci_customers');
884: arp_standard.debug(SQLERRM);
885: END;
886: ELSE
887: l_customer_id := 0;
888: END IF;