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 FND_LOG

Line 14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

10: REM NOTES Refers to old trigger JAI_AP_IA_DTC_BRIUD_T1
11: REM
12: REM +======================================================================+
13: */
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

11: REM
12: REM +======================================================================+
13: */
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

12: REM +======================================================================+
13: */
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_AP_IA_DTC_TRIGGER_PKG';

Line 17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

13: */
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_AP_IA_DTC_TRIGGER_PKG';
21: GV_MODULE_PREFIX VARCHAR2 (100) := 'JAI.PLSQL.JAI_AP_IA_DTC_TRIGGER_PKG';

Line 18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_AP_IA_DTC_TRIGGER_PKG';
21: GV_MODULE_PREFIX VARCHAR2 (100) := 'JAI.PLSQL.JAI_AP_IA_DTC_TRIGGER_PKG';
22: PROCEDURE BRIUD_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS

Line 19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_AP_IA_DTC_TRIGGER_PKG';
21: GV_MODULE_PREFIX VARCHAR2 (100) := 'JAI.PLSQL.JAI_AP_IA_DTC_TRIGGER_PKG';
22: PROCEDURE BRIUD_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
23: lb_result boolean;

Line 152: 1. Call to JAI_CMN_UTILS_PKG.WRITE_FND_LOG, to write fnd log for future debug.

148: ----------
149: Sl No. Bug Dependent on
150: Bug/Patch set Details
151: -------------------------------------------------------------------------------------------------
152: 1. Call to JAI_CMN_UTILS_PKG.WRITE_FND_LOG, to write fnd log for future debug.
153: Call to ap_utilities_pkg.get_current_gl_date()
154: ------------------------------------------------------------------------------------------ */
155: /*
156: || Cancellation Functionality

Line 161: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX ||'.'|| lv_proc_name, 'Cancelling invoice' || pr_old.invoice_id);

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:
163: IF pr_new.source <> 'INDIA TDS' THEN /* 'TDS' then --Ramanand for bug#4388958 */
164: FOR cur_rec IN c_jai_ap_tds_thhold_trxs(pr_old.invoice_id) LOOP
165:

Line 172: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_ERROR, GV_MODULE_PREFIX ||'.'|| lv_proc_name, pv_return_message);

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;
175: END IF;
176:

Line 193: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX ||'.'|| lv_proc_name, ld_accounting_date);

189: INTO ld_accounting_date;
190: CLOSE c_get_lines_acct_date;
191: end if;
192:
193: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX ||'.'|| lv_proc_name, ld_accounting_date);
194: --Check if the given date is in current open period ( for TDS authority)
195: lv_open_period := ap_utilities_pkg.get_current_gl_date(P_Date => ld_accounting_date,
196: P_Org_Id => ln_org_id);
197:

Line 198: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX ||'.'|| lv_proc_name, lv_open_period);

194: --Check if the given date is in current open period ( for TDS authority)
195: lv_open_period := ap_utilities_pkg.get_current_gl_date(P_Date => ld_accounting_date,
196: P_Org_Id => ln_org_id);
197:
198: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX ||'.'|| lv_proc_name, lv_open_period);
199: if lv_open_period is null then
200:
201: ap_utilities_pkg.get_open_gl_date(p_date => ld_accounting_date, /* In date */
202: p_period_name => lv_open_period, /* out Period */

Line 206: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX ||'.'|| lv_proc_name, lv_open_period);

202: p_period_name => lv_open_period, /* out Period */
203: p_gl_date => ld_out_accounting_date, /* out date */
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);

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

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;
213: end if; /* lv_open_period is null */
214:

Line 232: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX ||'.'|| lv_proc_name, ld_accounting_date);

228: INTO ld_accounting_date;
229: CLOSE c_get_lines_acct_date;
230: end if;
231:
232: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX ||'.'|| lv_proc_name, ld_accounting_date);
233: --Check if the given date is in current open period ( for TDS authority)
234: lv_open_period := ap_utilities_pkg.get_current_gl_date(P_Date => ld_accounting_date,
235: P_Org_Id => ln_org_id);
236: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX ||'.'|| lv_proc_name, lv_open_period);

Line 236: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX ||'.'|| lv_proc_name, lv_open_period);

232: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX ||'.'|| lv_proc_name, ld_accounting_date);
233: --Check if the given date is in current open period ( for TDS authority)
234: lv_open_period := ap_utilities_pkg.get_current_gl_date(P_Date => ld_accounting_date,
235: P_Org_Id => ln_org_id);
236: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX ||'.'|| lv_proc_name, lv_open_period);
237: if lv_open_period is null then
238:
239: ap_utilities_pkg.get_open_gl_date(p_date => ld_accounting_date, /* In date */
240: p_period_name => lv_open_period, /* out Period */

Line 244: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX ||'.'|| lv_proc_name, lv_open_period);

240: p_period_name => lv_open_period, /* out Period */
241: p_gl_date => ld_out_accounting_date, /* out date */
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);

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

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;
251: end if; /* lv_open_period is null */
252: END LOOP; /*cur_rec IN c_jai_ap_tds_thhold_trxs(pr_old.invoice_id) LOOP*/

Line 275: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_ERROR, GV_MODULE_PREFIX ||'.'|| lv_proc_name, pv_return_message);

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:
278:
279:

Line 304: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_ERROR, GV_MODULE_PREFIX ||'.'|| lv_proc_name, pv_return_message);

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;
307:
308: end if; /* Update invoice Ids in TDS tables for TDS invoices */

Line 348: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_ERROR, GV_MODULE_PREFIX ||'.'|| lv_proc_name, pv_return_message);

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:
352: end if; /* Deleting */

Line 362: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_ERROR, GV_MODULE_PREFIX ||'.'|| lv_proc_name, pv_return_message);

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 ;
364:
365: END JAI_AP_IA_DTC_TRIGGER_PKG ;