eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_IA_TRIGGER_PKG dependencies on AP_INVOICES_ALL

Line 101: --raise_application_error(-20000, 'Error - trigger ja_in_ap_aia_after_trg on ap_invoices_all : ' || sqlerrm);

97:
98:
99: exception
100: when others then
101: --raise_application_error(-20000, 'Error - trigger ja_in_ap_aia_after_trg on ap_invoices_all : ' || sqlerrm);
102: /* Added an exception block by Ramananda for bug#4570303 */
103: Pv_return_code := jai_constants.unexpected_error;
104: Pv_return_message := 'Encountered an error in JAI_AP_IA_TRIGGER_PKG.ARI_T7 ' ||
105: 'Error on ap_invoices_all : ' || substr(sqlerrm,1,1800);

Line 105: 'Error on ap_invoices_all : ' || substr(sqlerrm,1,1800);

101: --raise_application_error(-20000, 'Error - trigger ja_in_ap_aia_after_trg on ap_invoices_all : ' || sqlerrm);
102: /* Added an exception block by Ramananda for bug#4570303 */
103: Pv_return_code := jai_constants.unexpected_error;
104: Pv_return_message := 'Encountered an error in JAI_AP_IA_TRIGGER_PKG.ARI_T7 ' ||
105: 'Error on ap_invoices_all : ' || substr(sqlerrm,1,1800);
106:
107: END ARUID_T1 ;
108:
109: /*

Line 124: ln_org_id ap_invoices_all.org_id%type;

120: lb_result boolean;
121: ln_req_id number;
122: lv_process_flag varchar2(20);
123: lv_process_message varchar2(1100);
124: ln_org_id ap_invoices_all.org_id%type;
125: ln_set_of_books_id ap_invoices_all.set_of_books_id%type;
126:
127: /*changes for bug 5662741 removed for bug 6493858/6411412*/
128:

Line 125: ln_set_of_books_id ap_invoices_all.set_of_books_id%type;

121: ln_req_id number;
122: lv_process_flag varchar2(20);
123: lv_process_message varchar2(1100);
124: ln_org_id ap_invoices_all.org_id%type;
125: ln_set_of_books_id ap_invoices_all.set_of_books_id%type;
126:
127: /*changes for bug 5662741 removed for bug 6493858/6411412*/
128:
129: /*START, Bgowrava for Bug#5638773 */

Line 137: lv_invoice_payment_status ap_invoices_all.payment_status_flag%TYPE;

133: FROM jai_ap_tds_thhold_trxs
134: WHERE invoice_id = cp_invoice_id;
135:
136: r_tds_invoice_id c_tds_invoice_id%ROWTYPE;
137: lv_invoice_payment_status ap_invoices_all.payment_status_flag%TYPE;
138:
139: FUNCTION get_invoice_payment_status(p_invoice_id IN NUMBER)
140: RETURN VARCHAR2
141: IS

Line 147: FROM ap_invoices_all

143:
144: CURSOR c_payment_status(cp_invoice_id NUMBER)
145: IS
146: SELECT payment_status_flag
147: FROM ap_invoices_all
148: WHERE invoice_id = cp_invoice_id;
149:
150: r_payment_status c_payment_status%ROWTYPE;
151: BEGIN

Line 353: --raise_application_error(-20003, 'Error - trigger ja_in_ap_aia_before_trg on ap_invoices_all : ' || sqlerrm);

349:
350:
351: exception
352: when others then
353: --raise_application_error(-20003, 'Error - trigger ja_in_ap_aia_before_trg on ap_invoices_all : ' || sqlerrm);
354: /* Added an exception block by Ramananda for bug#4570303 */
355: Pv_return_code := jai_constants.unexpected_error;
356: Pv_return_message := 'Encountered an error in JAI_AP_IA_TRIGGER_PKG.ARI_T7 ' ||
357: 'Error on ap_invoices_all : ' || substr(sqlerrm,1,1800);

Line 357: 'Error on ap_invoices_all : ' || substr(sqlerrm,1,1800);

353: --raise_application_error(-20003, 'Error - trigger ja_in_ap_aia_before_trg on ap_invoices_all : ' || sqlerrm);
354: /* Added an exception block by Ramananda for bug#4570303 */
355: Pv_return_code := jai_constants.unexpected_error;
356: Pv_return_message := 'Encountered an error in JAI_AP_IA_TRIGGER_PKG.ARI_T7 ' ||
357: 'Error on ap_invoices_all : ' || substr(sqlerrm,1,1800);
358:
359: END BRIUD_T1 ;
360:
361: END JAI_AP_IA_TRIGGER_PKG ;