APPS.JAI_AP_IA_DTC_TRIGGER_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 30: lv_open_period ap_invoice_distributions_all.period_name%type;

26: lv_process_message varchar2(1100);
27: ln_org_id ap_invoices_all.org_id%type;
28: ln_set_of_books_id ap_invoices_all.set_of_books_id%type;
29: lv_proc_name VARCHAR2 (100) := 'BRIUD_T1';
30: lv_open_period ap_invoice_distributions_all.period_name%type;
31: ld_accounting_date DATE;
32: ld_out_accounting_date DATE;
33: lv_count number := 0;
34: lv_payment varchar2(1) := 'N';

Line 61: FROM ap_invoice_distributions_all

57:
58: --Get GL_date from distribution
59: CURSOR get_dist_gl_date(cp_invoice_id IN ap_invoices_all.invoice_id%TYPE) IS
60: SELECT accounting_date
61: FROM ap_invoice_distributions_all
62: WHERE invoice_id = cp_invoice_id
63: AND distribution_line_number = 1;
64: -- Only one distribution will be created for TDS invoices and so
65: -- hard coded the distribution line number to 1.

Line 345: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message); */

341: );
342:
343: if nvl(lv_process_flag, 'N') = 'E' then
344: /* raise_application_error(-20002,
345: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message); */
346: pv_return_code := jai_constants.expected_error ;
347: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;
348: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_ERROR, GV_MODULE_PREFIX ||'.'|| lv_proc_name, pv_return_message);
349: return ;

Line 347: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;

343: if nvl(lv_process_flag, 'N') = 'E' then
344: /* raise_application_error(-20002,
345: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message); */
346: pv_return_code := jai_constants.expected_error ;
347: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;
348: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_ERROR, GV_MODULE_PREFIX ||'.'|| lv_proc_name, pv_return_message);
349: return ;
350: end if;
351: