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_DTC_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 130: pv_return_code := jai_constants.successful ;

126: RETURN r_payment_status.payment_status_flag;
127: END get_invoice_payment_status;
128:
129: BEGIN
130: pv_return_code := jai_constants.successful ;
131: /*------------------------------------------------------------------------------------------
132: FILENAME: jai_ap_ia_dtc_t.plb
133:
134: CHANGE HISTORY:

Line 158: if pv_action = jai_constants.updating then

154: ------------------------------------------------------------------------------------------ */
155: /*
156: || Cancellation Functionality
157: */
158: if pv_action = jai_constants.updating then
159:
160: if pr_old.cancelled_date is null and pr_new.cancelled_date is not null then
161: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX ||'.'|| lv_proc_name, 'Cancelling invoice' || pr_old.invoice_id);
162:

Line 170: pv_return_code := jai_constants.expected_error;

166: /**Check payment status of TDS invoice to authority */
167: IF cur_rec.invoice_to_tds_authority_id IS NOT NULL THEN
168: lv_invoice_payment_status := get_invoice_payment_status(cur_rec.invoice_to_tds_authority_id);
169: IF NVL(lv_invoice_payment_status,'N') <> 'N' THEN
170: pv_return_code := jai_constants.expected_error;
171: pv_return_message := 'Invoice to TDS Authority - '|| cur_rec.invoice_to_tds_authority_id ||' is already paid. Current invoice can''t be cancelled';
172: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_ERROR, GV_MODULE_PREFIX ||'.'|| lv_proc_name, pv_return_message);
173: RETURN;
174: END IF;

Line 208: pv_return_code := jai_constants.expected_error;

204: P_Org_Id => ln_org_id);
205:
206: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX ||'.'|| lv_proc_name, lv_open_period);
207: if lv_open_period is null then
208: pv_return_code := jai_constants.expected_error;
209: pv_return_message := 'No open accounting Period after : ' || ld_accounting_date;
210: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_ERROR, GV_MODULE_PREFIX ||'.'|| lv_proc_name, pv_return_message || ' invoice_id :' ||cur_rec.invoice_to_tds_authority_id);
211: return;
212: end if;

Line 246: pv_return_code := jai_constants.expected_error;

242: P_Org_Id => ln_org_id);
243:
244: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX ||'.'|| lv_proc_name, lv_open_period);
245: if lv_open_period is null then
246: pv_return_code := jai_constants.expected_error;
247: pv_return_message := 'No open accounting Period after : ' || ld_accounting_date;
248: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_ERROR, GV_MODULE_PREFIX ||'.'|| lv_proc_name, pv_return_message || ' invoice_id :' ||cur_rec.invoice_to_vendor_id);
249: return;
250: end if;

Line 273: pv_return_code := jai_constants.expected_error;

269: end if;
270: end loop;
271: end loop;
272: if ((mod(lv_count, 2) <> 0) and lv_payment = 'Y') then
273: pv_return_code := jai_constants.expected_error;
274: pv_return_message := 'Threshold transition TDS has already been paid for the attached threshold_grp_id. Cannot cancel the invoice';
275: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_ERROR, GV_MODULE_PREFIX ||'.'|| lv_proc_name, pv_return_message);
276: end if;
277:

Line 284: end if; /* if pv_action = jai_constants.updating than */

280: end if; /* pr_new.source <> 'TDS' then */
281:
282: end if; /* if pr_old.cancelled_date is null and pr_new.cancelled_date is not null then */
283:
284: end if; /* if pv_action = jai_constants.updating than */
285:
286: /* Update invoice Ids in TDS tables for TDS invoices */
287: if pv_action = jai_constants.inserting and pr_new.source = 'INDIA TDS' then /* 'TDS' then --Ramanand for bug#4388958 */
288:

Line 287: if pv_action = jai_constants.inserting and pr_new.source = 'INDIA TDS' then /* 'TDS' then --Ramanand for bug#4388958 */

283:
284: end if; /* if pv_action = jai_constants.updating than */
285:
286: /* Update invoice Ids in TDS tables for TDS invoices */
287: if pv_action = jai_constants.inserting and pr_new.source = 'INDIA TDS' then /* 'TDS' then --Ramanand for bug#4388958 */
288:
289: jai_ap_tds_generation_pkg.populate_tds_invoice_id
290: (
291: p_invoice_id => pr_new.invoice_id,

Line 302: pv_return_code := jai_constants.expected_error ;

298:
299: if nvl(lv_process_flag, 'N') = 'E' then
300: /* raise_application_error(-20001,
301: 'Error - trigger ja_in_ap_aida_before_trg on ja_in_ap_aia_before_trg : ' || lv_process_message); */
302: pv_return_code := jai_constants.expected_error ;
303: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ja_in_ap_aia_before_trg : ' || lv_process_message ; return ;
304: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_ERROR, GV_MODULE_PREFIX ||'.'|| lv_proc_name, pv_return_message);
305: return ;
306: end if;

Line 311: if pv_action = jai_constants.inserting and pr_new.source = 'INDIA TAX INVOICE' then /* 'RECEIPT' then --Ramanand for bug#4388958 */

307:
308: end if; /* Update invoice Ids in TDS tables for TDS invoices */
309:
310: /* Update invoice Ids in Third Party tables for Third Party invoices */
311: if pv_action = jai_constants.inserting and pr_new.source = 'INDIA TAX INVOICE' then /* 'RECEIPT' then --Ramanand for bug#4388958 */
312:
313: jai_rcv_third_party_pkg.populate_tp_invoice_id
314: (
315: p_invoice_id => pr_new.invoice_id,

Line 322: if nvl(lv_process_flag, 'N') = jai_constants.unexpected_error then

318: p_vendor_site_id => pr_new.vendor_site_id,
319: p_process_flag => lv_process_flag,
320: p_process_message => lv_process_message
321: );
322: if nvl(lv_process_flag, 'N') = jai_constants.unexpected_error then
323: /* raise_application_error(-20002,
324: 'Error - trigger ja_in_ap_aida_before_trg on ja_in_ap_aia_before_trg : ' || lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=
325: 'Error - trigger ja_in_ap_aida_before_trg on ja_in_ap_aia_before_trg : ' || lv_process_message ; return ;
326: end if;

Line 324: 'Error - trigger ja_in_ap_aida_before_trg on ja_in_ap_aia_before_trg : ' || lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=

320: p_process_message => lv_process_message
321: );
322: if nvl(lv_process_flag, 'N') = jai_constants.unexpected_error then
323: /* raise_application_error(-20002,
324: 'Error - trigger ja_in_ap_aida_before_trg on ja_in_ap_aia_before_trg : ' || lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=
325: 'Error - trigger ja_in_ap_aida_before_trg on ja_in_ap_aia_before_trg : ' || lv_process_message ; return ;
326: end if;
327: end if;
328:

Line 334: if pv_action = jai_constants.deleting then

330: || Update invoice Ids in Third Party tables for Third Party invoices
331: */
332:
333: /* Deleting */
334: if pv_action = jai_constants.deleting then
335:
336: jai_ap_tds_tax_defaultation.process_delete
337: (
338: p_invoice_id => pr_old.invoice_id,

Line 346: pv_return_code := jai_constants.expected_error ;

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 ;
350: end if;

Line 359: Pv_return_code := jai_constants.unexpected_error;

355: exception
356: when others then
357: --raise_application_error(-20003, 'Error - trigger ja_in_ap_aia_before_trg on ap_invoices_all : ' || sqlerrm);
358: /* Added an exception block by Ramananda for bug#4570303 */
359: Pv_return_code := jai_constants.unexpected_error;
360: Pv_return_message := 'Encountered an error in JAI_AP_IA_TRIGGER_PKG.BRIUD_T1 ' ||
361: 'Error on ap_invoices_all : ' || substr(sqlerrm,1,1800);
362: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_ERROR, GV_MODULE_PREFIX ||'.'|| lv_proc_name, pv_return_message);
363: END BRIUD_T1 ;