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
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
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;
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;
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;