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.IGS_FI_PRC_FIN_LT_CHG dependencies on FND_MESSAGE

Line 105: fnd_message.set_name('IGS',l_v_pln_cr_message);

101: l_v_planned_credits_ind := igs_fi_gen_001.finp_get_planned_credits_ind(l_v_pln_cr_message);
102:
103: IF l_v_pln_cr_message IS NOT NULL THEN
104: --Log error message and raise exception
105: fnd_message.set_name('IGS',l_v_pln_cr_message);
106: fnd_file.put_line(fnd_file.log,fnd_message.get());
107: fnd_file.put_line(fnd_file.log,' ');
108: RAISE l_validation_exp;
109: END IF;

Line 106: fnd_file.put_line(fnd_file.log,fnd_message.get());

102:
103: IF l_v_pln_cr_message IS NOT NULL THEN
104: --Log error message and raise exception
105: fnd_message.set_name('IGS',l_v_pln_cr_message);
106: fnd_file.put_line(fnd_file.log,fnd_message.get());
107: fnd_file.put_line(fnd_file.log,' ');
108: RAISE l_validation_exp;
109: END IF;
110:

Line 254: fnd_message.set_name('IGS','IGS_FI_PROC_PERSON');

250: FETCH cur_person INTO l_cur_person;
251: CLOSE cur_person;
252:
253: fnd_file.put_line(fnd_file.log,g_v_hor_line);
254: fnd_message.set_name('IGS','IGS_FI_PROC_PERSON');
255: fnd_message.set_token('NUMBER',l_cur_person.person_number);
256: fnd_message.set_token('NAME',l_cur_person.full_name) ;
257: fnd_file.put_line(fnd_file.log,fnd_message.get);
258: END log_person;

Line 255: fnd_message.set_token('NUMBER',l_cur_person.person_number);

251: CLOSE cur_person;
252:
253: fnd_file.put_line(fnd_file.log,g_v_hor_line);
254: fnd_message.set_name('IGS','IGS_FI_PROC_PERSON');
255: fnd_message.set_token('NUMBER',l_cur_person.person_number);
256: fnd_message.set_token('NAME',l_cur_person.full_name) ;
257: fnd_file.put_line(fnd_file.log,fnd_message.get);
258: END log_person;
259:

Line 256: fnd_message.set_token('NAME',l_cur_person.full_name) ;

252:
253: fnd_file.put_line(fnd_file.log,g_v_hor_line);
254: fnd_message.set_name('IGS','IGS_FI_PROC_PERSON');
255: fnd_message.set_token('NUMBER',l_cur_person.person_number);
256: fnd_message.set_token('NAME',l_cur_person.full_name) ;
257: fnd_file.put_line(fnd_file.log,fnd_message.get);
258: END log_person;
259:
260: PROCEDURE log_amount(p_amount igs_fi_balances.standard_balance%TYPE, p_msg_name VARCHAR2 ) IS

Line 257: fnd_file.put_line(fnd_file.log,fnd_message.get);

253: fnd_file.put_line(fnd_file.log,g_v_hor_line);
254: fnd_message.set_name('IGS','IGS_FI_PROC_PERSON');
255: fnd_message.set_token('NUMBER',l_cur_person.person_number);
256: fnd_message.set_token('NAME',l_cur_person.full_name) ;
257: fnd_file.put_line(fnd_file.log,fnd_message.get);
258: END log_person;
259:
260: PROCEDURE log_amount(p_amount igs_fi_balances.standard_balance%TYPE, p_msg_name VARCHAR2 ) IS
261: /***********************************************************************************************

Line 274: fnd_message.set_name('IGS',p_msg_name);

270:
271: ********************************************************************************************** */
272:
273: BEGIN
274: fnd_message.set_name('IGS',p_msg_name);
275: fnd_message.set_token('AMOUNT',TO_CHAR(p_amount));
276: fnd_file.put_line(fnd_file.log,fnd_message.get);
277: END log_amount;
278:

Line 275: fnd_message.set_token('AMOUNT',TO_CHAR(p_amount));

271: ********************************************************************************************** */
272:
273: BEGIN
274: fnd_message.set_name('IGS',p_msg_name);
275: fnd_message.set_token('AMOUNT',TO_CHAR(p_amount));
276: fnd_file.put_line(fnd_file.log,fnd_message.get);
277: END log_amount;
278:
279: FUNCTION lookup_desc( p_type IN VARCHAR2 ,

Line 276: fnd_file.put_line(fnd_file.log,fnd_message.get);

272:
273: BEGIN
274: fnd_message.set_name('IGS',p_msg_name);
275: fnd_message.set_token('AMOUNT',TO_CHAR(p_amount));
276: fnd_file.put_line(fnd_file.log,fnd_message.get);
277: END log_amount;
278:
279: FUNCTION lookup_desc( p_type IN VARCHAR2 ,
280: p_code IN VARCHAR2 )

Line 321: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');

317: Who When What
318:
319: ********************************************************************************************** */
320: BEGIN
321: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
322: fnd_message.set_token('PARAMETER_NAME',p_msg_name);
323: fnd_message.set_token('PARAMETER_VAL' ,p_msg_val) ;
324: fnd_file.put_line(fnd_file.log,fnd_message.get);
325: END log_messages ;

Line 322: fnd_message.set_token('PARAMETER_NAME',p_msg_name);

318:
319: ********************************************************************************************** */
320: BEGIN
321: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
322: fnd_message.set_token('PARAMETER_NAME',p_msg_name);
323: fnd_message.set_token('PARAMETER_VAL' ,p_msg_val) ;
324: fnd_file.put_line(fnd_file.log,fnd_message.get);
325: END log_messages ;
326:

Line 323: fnd_message.set_token('PARAMETER_VAL' ,p_msg_val) ;

319: ********************************************************************************************** */
320: BEGIN
321: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
322: fnd_message.set_token('PARAMETER_NAME',p_msg_name);
323: fnd_message.set_token('PARAMETER_VAL' ,p_msg_val) ;
324: fnd_file.put_line(fnd_file.log,fnd_message.get);
325: END log_messages ;
326:
327:

Line 324: fnd_file.put_line(fnd_file.log,fnd_message.get);

320: BEGIN
321: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
322: fnd_message.set_token('PARAMETER_NAME',p_msg_name);
323: fnd_message.set_token('PARAMETER_VAL' ,p_msg_val) ;
324: fnd_file.put_line(fnd_file.log,fnd_message.get);
325: END log_messages ;
326:
327:
328:

Line 357: fnd_message.set_name('IGS','IGS_FI_OFFSET_DAYS');

353: log_messages(lookup_desc('IGS_FI_LOCKBOX','ACCRUAL_TYPE'),
354: lookup_desc('IGS_FI_ACCRUAL_TYPE',p_cur_plan.accrual_type));
355: log_messages(lookup_desc('IGS_FI_LOCKBOX','FEE_TYPE'),p_cur_plan.fee_type);
356:
357: fnd_message.set_name('IGS','IGS_FI_OFFSET_DAYS');
358: fnd_message.set_token('DAYS',p_cur_plan.offset_days);
359: fnd_file.put_line(fnd_file.log,fnd_message.get);
360: fnd_file.put_line(fnd_file.log,'');
361:

Line 358: fnd_message.set_token('DAYS',p_cur_plan.offset_days);

354: lookup_desc('IGS_FI_ACCRUAL_TYPE',p_cur_plan.accrual_type));
355: log_messages(lookup_desc('IGS_FI_LOCKBOX','FEE_TYPE'),p_cur_plan.fee_type);
356:
357: fnd_message.set_name('IGS','IGS_FI_OFFSET_DAYS');
358: fnd_message.set_token('DAYS',p_cur_plan.offset_days);
359: fnd_file.put_line(fnd_file.log,fnd_message.get);
360: fnd_file.put_line(fnd_file.log,'');
361:
362: fnd_message.set_name('IGS','IGS_FI_CHARGE_RATE');

Line 359: fnd_file.put_line(fnd_file.log,fnd_message.get);

355: log_messages(lookup_desc('IGS_FI_LOCKBOX','FEE_TYPE'),p_cur_plan.fee_type);
356:
357: fnd_message.set_name('IGS','IGS_FI_OFFSET_DAYS');
358: fnd_message.set_token('DAYS',p_cur_plan.offset_days);
359: fnd_file.put_line(fnd_file.log,fnd_message.get);
360: fnd_file.put_line(fnd_file.log,'');
361:
362: fnd_message.set_name('IGS','IGS_FI_CHARGE_RATE');
363: fnd_message.set_token('RATE',p_cur_plan.chg_rate);

Line 362: fnd_message.set_name('IGS','IGS_FI_CHARGE_RATE');

358: fnd_message.set_token('DAYS',p_cur_plan.offset_days);
359: fnd_file.put_line(fnd_file.log,fnd_message.get);
360: fnd_file.put_line(fnd_file.log,'');
361:
362: fnd_message.set_name('IGS','IGS_FI_CHARGE_RATE');
363: fnd_message.set_token('RATE',p_cur_plan.chg_rate);
364: fnd_file.put_line(fnd_file.log,fnd_message.get);
365: fnd_file.put_line(fnd_file.log,'');
366:

Line 363: fnd_message.set_token('RATE',p_cur_plan.chg_rate);

359: fnd_file.put_line(fnd_file.log,fnd_message.get);
360: fnd_file.put_line(fnd_file.log,'');
361:
362: fnd_message.set_name('IGS','IGS_FI_CHARGE_RATE');
363: fnd_message.set_token('RATE',p_cur_plan.chg_rate);
364: fnd_file.put_line(fnd_file.log,fnd_message.get);
365: fnd_file.put_line(fnd_file.log,'');
366:
367: fnd_message.set_name('IGS','IGS_FI_FLAT_AMOUNT');

Line 364: fnd_file.put_line(fnd_file.log,fnd_message.get);

360: fnd_file.put_line(fnd_file.log,'');
361:
362: fnd_message.set_name('IGS','IGS_FI_CHARGE_RATE');
363: fnd_message.set_token('RATE',p_cur_plan.chg_rate);
364: fnd_file.put_line(fnd_file.log,fnd_message.get);
365: fnd_file.put_line(fnd_file.log,'');
366:
367: fnd_message.set_name('IGS','IGS_FI_FLAT_AMOUNT');
368: fnd_message.set_token('AMT',p_cur_plan.flat_amount);

Line 367: fnd_message.set_name('IGS','IGS_FI_FLAT_AMOUNT');

363: fnd_message.set_token('RATE',p_cur_plan.chg_rate);
364: fnd_file.put_line(fnd_file.log,fnd_message.get);
365: fnd_file.put_line(fnd_file.log,'');
366:
367: fnd_message.set_name('IGS','IGS_FI_FLAT_AMOUNT');
368: fnd_message.set_token('AMT',p_cur_plan.flat_amount);
369: fnd_file.put_line(fnd_file.log,fnd_message.get);
370: fnd_file.put_line(fnd_file.log,'');
371:

Line 368: fnd_message.set_token('AMT',p_cur_plan.flat_amount);

364: fnd_file.put_line(fnd_file.log,fnd_message.get);
365: fnd_file.put_line(fnd_file.log,'');
366:
367: fnd_message.set_name('IGS','IGS_FI_FLAT_AMOUNT');
368: fnd_message.set_token('AMT',p_cur_plan.flat_amount);
369: fnd_file.put_line(fnd_file.log,fnd_message.get);
370: fnd_file.put_line(fnd_file.log,'');
371:
372: fnd_message.set_name('IGS','IGS_FI_MIN_BAL_AMOUNT');

Line 369: fnd_file.put_line(fnd_file.log,fnd_message.get);

365: fnd_file.put_line(fnd_file.log,'');
366:
367: fnd_message.set_name('IGS','IGS_FI_FLAT_AMOUNT');
368: fnd_message.set_token('AMT',p_cur_plan.flat_amount);
369: fnd_file.put_line(fnd_file.log,fnd_message.get);
370: fnd_file.put_line(fnd_file.log,'');
371:
372: fnd_message.set_name('IGS','IGS_FI_MIN_BAL_AMOUNT');
373: fnd_message.set_token('BAL_AMT',p_cur_plan.min_balance_amount);

Line 372: fnd_message.set_name('IGS','IGS_FI_MIN_BAL_AMOUNT');

368: fnd_message.set_token('AMT',p_cur_plan.flat_amount);
369: fnd_file.put_line(fnd_file.log,fnd_message.get);
370: fnd_file.put_line(fnd_file.log,'');
371:
372: fnd_message.set_name('IGS','IGS_FI_MIN_BAL_AMOUNT');
373: fnd_message.set_token('BAL_AMT',p_cur_plan.min_balance_amount);
374: fnd_file.put_line(fnd_file.log,fnd_message.get);
375: fnd_file.put_line(fnd_file.log,'');
376:

Line 373: fnd_message.set_token('BAL_AMT',p_cur_plan.min_balance_amount);

369: fnd_file.put_line(fnd_file.log,fnd_message.get);
370: fnd_file.put_line(fnd_file.log,'');
371:
372: fnd_message.set_name('IGS','IGS_FI_MIN_BAL_AMOUNT');
373: fnd_message.set_token('BAL_AMT',p_cur_plan.min_balance_amount);
374: fnd_file.put_line(fnd_file.log,fnd_message.get);
375: fnd_file.put_line(fnd_file.log,'');
376:
377: fnd_message.set_name('IGS','IGS_FI_MIN_CHG_AMOUNT');

Line 374: fnd_file.put_line(fnd_file.log,fnd_message.get);

370: fnd_file.put_line(fnd_file.log,'');
371:
372: fnd_message.set_name('IGS','IGS_FI_MIN_BAL_AMOUNT');
373: fnd_message.set_token('BAL_AMT',p_cur_plan.min_balance_amount);
374: fnd_file.put_line(fnd_file.log,fnd_message.get);
375: fnd_file.put_line(fnd_file.log,'');
376:
377: fnd_message.set_name('IGS','IGS_FI_MIN_CHG_AMOUNT');
378: fnd_message.set_token('CHG_AMT',p_cur_plan.min_charge_amount);

Line 377: fnd_message.set_name('IGS','IGS_FI_MIN_CHG_AMOUNT');

373: fnd_message.set_token('BAL_AMT',p_cur_plan.min_balance_amount);
374: fnd_file.put_line(fnd_file.log,fnd_message.get);
375: fnd_file.put_line(fnd_file.log,'');
376:
377: fnd_message.set_name('IGS','IGS_FI_MIN_CHG_AMOUNT');
378: fnd_message.set_token('CHG_AMT',p_cur_plan.min_charge_amount);
379: fnd_file.put_line(fnd_file.log,fnd_message.get);
380: fnd_file.put_line(fnd_file.log,'');
381:

Line 378: fnd_message.set_token('CHG_AMT',p_cur_plan.min_charge_amount);

374: fnd_file.put_line(fnd_file.log,fnd_message.get);
375: fnd_file.put_line(fnd_file.log,'');
376:
377: fnd_message.set_name('IGS','IGS_FI_MIN_CHG_AMOUNT');
378: fnd_message.set_token('CHG_AMT',p_cur_plan.min_charge_amount);
379: fnd_file.put_line(fnd_file.log,fnd_message.get);
380: fnd_file.put_line(fnd_file.log,'');
381:
382: fnd_message.set_name('IGS','IGS_FI_MAX_CHG_AMOUNT');

Line 379: fnd_file.put_line(fnd_file.log,fnd_message.get);

375: fnd_file.put_line(fnd_file.log,'');
376:
377: fnd_message.set_name('IGS','IGS_FI_MIN_CHG_AMOUNT');
378: fnd_message.set_token('CHG_AMT',p_cur_plan.min_charge_amount);
379: fnd_file.put_line(fnd_file.log,fnd_message.get);
380: fnd_file.put_line(fnd_file.log,'');
381:
382: fnd_message.set_name('IGS','IGS_FI_MAX_CHG_AMOUNT');
383: fnd_message.set_token('CHG_AMT',p_cur_plan.max_charge_amount);

Line 382: fnd_message.set_name('IGS','IGS_FI_MAX_CHG_AMOUNT');

378: fnd_message.set_token('CHG_AMT',p_cur_plan.min_charge_amount);
379: fnd_file.put_line(fnd_file.log,fnd_message.get);
380: fnd_file.put_line(fnd_file.log,'');
381:
382: fnd_message.set_name('IGS','IGS_FI_MAX_CHG_AMOUNT');
383: fnd_message.set_token('CHG_AMT',p_cur_plan.max_charge_amount);
384: fnd_file.put_line(fnd_file.log,fnd_message.get);
385: fnd_file.put_line(fnd_file.log,'');
386:

Line 383: fnd_message.set_token('CHG_AMT',p_cur_plan.max_charge_amount);

379: fnd_file.put_line(fnd_file.log,fnd_message.get);
380: fnd_file.put_line(fnd_file.log,'');
381:
382: fnd_message.set_name('IGS','IGS_FI_MAX_CHG_AMOUNT');
383: fnd_message.set_token('CHG_AMT',p_cur_plan.max_charge_amount);
384: fnd_file.put_line(fnd_file.log,fnd_message.get);
385: fnd_file.put_line(fnd_file.log,'');
386:
387: fnd_message.set_name('IGS','IGS_FI_MIN_AMT_NO_CHG');

Line 384: fnd_file.put_line(fnd_file.log,fnd_message.get);

380: fnd_file.put_line(fnd_file.log,'');
381:
382: fnd_message.set_name('IGS','IGS_FI_MAX_CHG_AMOUNT');
383: fnd_message.set_token('CHG_AMT',p_cur_plan.max_charge_amount);
384: fnd_file.put_line(fnd_file.log,fnd_message.get);
385: fnd_file.put_line(fnd_file.log,'');
386:
387: fnd_message.set_name('IGS','IGS_FI_MIN_AMT_NO_CHG');
388: fnd_message.set_token('CHG_AMT',p_cur_plan.min_charge_amount_no_charge);

Line 387: fnd_message.set_name('IGS','IGS_FI_MIN_AMT_NO_CHG');

383: fnd_message.set_token('CHG_AMT',p_cur_plan.max_charge_amount);
384: fnd_file.put_line(fnd_file.log,fnd_message.get);
385: fnd_file.put_line(fnd_file.log,'');
386:
387: fnd_message.set_name('IGS','IGS_FI_MIN_AMT_NO_CHG');
388: fnd_message.set_token('CHG_AMT',p_cur_plan.min_charge_amount_no_charge);
389: fnd_file.put_line(fnd_file.log,fnd_message.get);
390:
391: fnd_file.put_line(fnd_file.log,' ');

Line 388: fnd_message.set_token('CHG_AMT',p_cur_plan.min_charge_amount_no_charge);

384: fnd_file.put_line(fnd_file.log,fnd_message.get);
385: fnd_file.put_line(fnd_file.log,'');
386:
387: fnd_message.set_name('IGS','IGS_FI_MIN_AMT_NO_CHG');
388: fnd_message.set_token('CHG_AMT',p_cur_plan.min_charge_amount_no_charge);
389: fnd_file.put_line(fnd_file.log,fnd_message.get);
390:
391: fnd_file.put_line(fnd_file.log,' ');
392: END log_plan_info;

Line 389: fnd_file.put_line(fnd_file.log,fnd_message.get);

385: fnd_file.put_line(fnd_file.log,'');
386:
387: fnd_message.set_name('IGS','IGS_FI_MIN_AMT_NO_CHG');
388: fnd_message.set_token('CHG_AMT',p_cur_plan.min_charge_amount_no_charge);
389: fnd_file.put_line(fnd_file.log,fnd_message.get);
390:
391: fnd_file.put_line(fnd_file.log,' ');
392: END log_plan_info;
393:

Line 458: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');

454: p_bal_start_dt IS NULL OR
455: p_bal_end_dt IS NULL OR
456: p_bal_type IS NULL OR
457: p_open_bal IS NULL ) THEN
458: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
459: igs_ge_msg_stack.add;
460: app_exception.raise_exception;
461: END IF;
462:

Line 465: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');

461: END IF;
462:
463: -- The Person_id passed as parameter to the procedure is validated
464: IF igs_fi_gen_007.validate_person(p_person_id) = 'N' THEN
465: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
466: igs_ge_msg_stack.add;
467: app_exception.raise_exception;
468: END IF;
469:

Line 472: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');

468: END IF;
469:
470: -- The parameter Balance Start Date should less than Balance End Date
471: IF p_bal_start_dt > p_bal_end_dt THEN
472: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
473: igs_ge_msg_stack.add;
474: app_exception.raise_exception;
475: END IF;
476:

Line 551: fnd_message.set_name('IGS',l_v_pln_cr_message);

547:
548: END;
549:
550: IF l_b_success_flag = FALSE THEN
551: fnd_message.set_name('IGS',l_v_pln_cr_message);
552: fnd_file.put_line(fnd_file.log,fnd_message.get());
553: fnd_file.put_line(FND_FILE.LOG,' ');
554: ELSE
555: -- When no errors reduce the balance with the sum of planned credits.

Line 552: fnd_file.put_line(fnd_file.log,fnd_message.get());

548: END;
549:
550: IF l_b_success_flag = FALSE THEN
551: fnd_message.set_name('IGS',l_v_pln_cr_message);
552: fnd_file.put_line(fnd_file.log,fnd_message.get());
553: fnd_file.put_line(FND_FILE.LOG,' ');
554: ELSE
555: -- When no errors reduce the balance with the sum of planned credits.
556: p_red_bal := p_red_bal - NVL(l_n_planned_credit,0);

Line 644: fnd_message.set_name('IGS',l_v_message_name);

640: p_v_curr_desc => l_v_curr_desc,
641: p_v_message_name => l_v_message_name
642: );
643: IF l_v_message_name IS NOT NULL THEN
644: fnd_message.set_name('IGS',l_v_message_name);
645: fnd_msg_pub.add;
646: p_b_chrg_flag := FALSE;
647: RAISE fnd_api.g_exc_error;
648: END IF;

Line 719: fnd_message.set_encoded(l_msg_data);

715: x_waiver_amount => l_n_waiver_amount);
716:
717: IF l_ret_status <> 'S' THEN
718: IF l_msg_count = 1 THEN
719: fnd_message.set_encoded(l_msg_data);
720: fnd_file.put_line(fnd_file.log,fnd_message.get);
721: ELSE
722: FOR l_count IN 1 .. l_msg_count LOOP
723: l_msg := fnd_msg_pub.get(p_msg_index => l_count, p_encoded => 'T');

Line 720: fnd_file.put_line(fnd_file.log,fnd_message.get);

716:
717: IF l_ret_status <> 'S' THEN
718: IF l_msg_count = 1 THEN
719: fnd_message.set_encoded(l_msg_data);
720: fnd_file.put_line(fnd_file.log,fnd_message.get);
721: ELSE
722: FOR l_count IN 1 .. l_msg_count LOOP
723: l_msg := fnd_msg_pub.get(p_msg_index => l_count, p_encoded => 'T');
724: fnd_message.set_encoded(l_msg);

Line 724: fnd_message.set_encoded(l_msg);

720: fnd_file.put_line(fnd_file.log,fnd_message.get);
721: ELSE
722: FOR l_count IN 1 .. l_msg_count LOOP
723: l_msg := fnd_msg_pub.get(p_msg_index => l_count, p_encoded => 'T');
724: fnd_message.set_encoded(l_msg);
725: fnd_file.put_line(fnd_file.log,fnd_message.get);
726: END LOOP;
727: END IF;
728: p_b_chrg_flag := FALSE;

Line 725: fnd_file.put_line(fnd_file.log,fnd_message.get);

721: ELSE
722: FOR l_count IN 1 .. l_msg_count LOOP
723: l_msg := fnd_msg_pub.get(p_msg_index => l_count, p_encoded => 'T');
724: fnd_message.set_encoded(l_msg);
725: fnd_file.put_line(fnd_file.log,fnd_message.get);
726: END LOOP;
727: END IF;
728: p_b_chrg_flag := FALSE;
729: END IF;

Line 796: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_NO_CHG_APP'));

792:
793: p_b_chrg_flag := TRUE;
794:
795: IF (l_n_charge_amount <= 0 AND p_b_grt_min_bal_amt) THEN
796: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_NO_CHG_APP'));
797: p_b_chrg_flag := FALSE;
798: RETURN;
799: END IF;
800:

Line 803: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_NO_CHG_APP_MIN_BAL'));

799: END IF;
800:
801: --Incase the flag p_b_grt_min_bal_amt is FALSE, no need to proceed for creating a charge.
802: IF p_cur_plan.plan_type = g_v_late AND p_b_grt_min_bal_amt = FALSE THEN
803: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_NO_CHG_APP_MIN_BAL'));
804: p_b_chrg_flag := FALSE;
805: RETURN;
806: END IF;
807:

Line 813: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_NO_CHG_APP_MIN_CHG'));

809: --only when the plan type is not late and accrual type is not Flat Amount.
810: --Because only in that particular case only, these three fields will not have values.
811: IF (NOT((p_cur_plan.plan_type = g_v_late) AND (l_v_accrual_type = g_v_flat_amt))) THEN
812: IF l_n_charge_amount < NVL(l_n_min_chg_amt_no_chg,l_n_charge_amount) THEN
813: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_NO_CHG_APP_MIN_CHG'));
814: p_b_chrg_flag := FALSE;
815: RETURN;
816: END IF;
817:

Line 840: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_CHG_BILL'));

836: OPEN cur_bill(p_n_person_id);
837: FETCH cur_bill INTO l_cur_bill;
838: IF cur_bill%FOUND THEN
839: IF p_d_chg_crtn_dt < l_cur_bill.cut_off_date THEN
840: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_CHG_BILL'));
841: p_b_chrg_flag := FALSE;
842: CLOSE cur_bill;
843: RETURN;
844: END IF;

Line 1033: fnd_message.set_name('IGS','IGS_FI_NO_CHG_APP_DUE_DT');

1029:
1030: --Check if the balance as on the determination date is greater than zero,
1031: --otherwise log error message.
1032: IF NVL(igs_fi_gen_008.get_plan_balance(p_n_std_plan_id,l_d_effective_dt),0) <= 0 THEN
1033: fnd_message.set_name('IGS','IGS_FI_NO_CHG_APP_DUE_DT');
1034: fnd_file.put_line(fnd_file.log,fnd_message.get);
1035: RETURN;
1036: END IF;
1037:

Line 1034: fnd_file.put_line(fnd_file.log,fnd_message.get);

1030: --Check if the balance as on the determination date is greater than zero,
1031: --otherwise log error message.
1032: IF NVL(igs_fi_gen_008.get_plan_balance(p_n_std_plan_id,l_d_effective_dt),0) <= 0 THEN
1033: fnd_message.set_name('IGS','IGS_FI_NO_CHG_APP_DUE_DT');
1034: fnd_file.put_line(fnd_file.log,fnd_message.get);
1035: RETURN;
1036: END IF;
1037:
1038: --Get the charge rate.If the payment plan charge rate is not defined at, get the default charge rate.

Line 1106: fnd_message.set_name('IGS','IGS_FI_PP_LT_NO_RECS');

1102: END LOOP;
1103:
1104: --If there are no installments considered for Late charge Calculation, log message.
1105: IF NOT l_b_inst_exists THEN
1106: fnd_message.set_name('IGS','IGS_FI_PP_LT_NO_RECS');
1107: fnd_file.put_line(fnd_file.log,fnd_message.get);
1108: END IF;
1109: END IF;
1110:

Line 1107: fnd_file.put_line(fnd_file.log,fnd_message.get);

1103:
1104: --If there are no installments considered for Late charge Calculation, log message.
1105: IF NOT l_b_inst_exists THEN
1106: fnd_message.set_name('IGS','IGS_FI_PP_LT_NO_RECS');
1107: fnd_file.put_line(fnd_file.log,fnd_message.get);
1108: END IF;
1109: END IF;
1110:
1111: END calculate_late_fee_charge;

Line 1216: fnd_message.set_name('IGS','IGS_FI_NO_CHG_APP_DUE_DT');

1212:
1213: --If the outstanding balance as on the above calculated start date is less than or equal to 0,
1214: --then log the error message and return from this procedure.
1215: IF NVL(igs_fi_gen_008.get_plan_balance(p_n_std_plan_id,l_d_eff_date),0) <= 0 THEN
1216: fnd_message.set_name('IGS','IGS_FI_NO_CHG_APP_DUE_DT');
1217: fnd_file.put_line(fnd_file.log,fnd_message.get);
1218: RETURN;
1219: END IF;
1220:

Line 1217: fnd_file.put_line(fnd_file.log,fnd_message.get);

1213: --If the outstanding balance as on the above calculated start date is less than or equal to 0,
1214: --then log the error message and return from this procedure.
1215: IF NVL(igs_fi_gen_008.get_plan_balance(p_n_std_plan_id,l_d_eff_date),0) <= 0 THEN
1216: fnd_message.set_name('IGS','IGS_FI_NO_CHG_APP_DUE_DT');
1217: fnd_file.put_line(fnd_file.log,fnd_message.get);
1218: RETURN;
1219: END IF;
1220:
1221: IF (NVL(p_cur_plan.payment_plan_accrl_type_code,p_cur_plan.accrual_type) = g_v_cutoff_dt) THEN

Line 1319: fnd_message.set_name('IGS',l_message_name);

1315: p_message_name => l_message_name );
1316: --If any message is returned, log that and error out.
1317: IF l_message_name IS NOT NULL THEN
1318: fnd_file.new_line(fnd_file.log);
1319: fnd_message.set_name('IGS',l_message_name);
1320: fnd_file.put_line(fnd_file.log,fnd_message.get());
1321: RAISE l_validation_exp;
1322: END IF;
1323:

Line 1320: fnd_file.put_line(fnd_file.log,fnd_message.get());

1316: --If any message is returned, log that and error out.
1317: IF l_message_name IS NOT NULL THEN
1318: fnd_file.new_line(fnd_file.log);
1319: fnd_message.set_name('IGS',l_message_name);
1320: fnd_file.put_line(fnd_file.log,fnd_message.get());
1321: RAISE l_validation_exp;
1322: END IF;
1323:
1324: --Get the payable balance

Line 1336: fnd_message.set_name('IGS',l_v_pln_cr_message);

1332: p_start_date => NULL,
1333: p_end_date => p_batch_cutoff_dt,
1334: p_message_name => l_v_pln_cr_message);
1335: IF l_v_pln_cr_message IS NOT NULL THEN
1336: fnd_message.set_name('IGS',l_v_pln_cr_message);
1337: fnd_file.put_line(fnd_file.log,fnd_message.get());
1338: fnd_file.put_line(fnd_file.log,' ');
1339: ELSE
1340: -- When no errors reduce the payable balance with the sum of planned credits.

Line 1337: fnd_file.put_line(fnd_file.log,fnd_message.get());

1333: p_end_date => p_batch_cutoff_dt,
1334: p_message_name => l_v_pln_cr_message);
1335: IF l_v_pln_cr_message IS NOT NULL THEN
1336: fnd_message.set_name('IGS',l_v_pln_cr_message);
1337: fnd_file.put_line(fnd_file.log,fnd_message.get());
1338: fnd_file.put_line(fnd_file.log,' ');
1339: ELSE
1340: -- When no errors reduce the payable balance with the sum of planned credits.
1341: l_payable_bal := l_payable_bal - NVL(l_n_planned_credit,0);

Line 1348: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_NO_CHG_APP_BT_CUT_OFF'));

1344: -- Changes due to SFCR018 - To include planned credits also when the indicator is set as 'Y'
1345:
1346: -- Balance as on the Batch Cutoff Date is less than or equal to Zero
1347: IF l_payable_bal <= 0 THEN
1348: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_NO_CHG_APP_BT_CUT_OFF'));
1349: RETURN;
1350: END IF;
1351:
1352: --Determining the overdue balance as on the offset date

Line 1363: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_NO_CHG_APP_DUE_DT'));

1359: p_red_bal => l_overdue_bal
1360: );
1361: -- Overdue Balance as of the offset date is less than or equal to zero
1362: IF l_overdue_bal <= 0 THEN
1363: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_NO_CHG_APP_DUE_DT'));
1364: RETURN;
1365: END IF;
1366:
1367: ELSE --if the person is on an Active Payment Plan..

Line 1370: fnd_message.set_name('IGS','IGS_FI_PP_PRSN_ON_PP');

1366:
1367: ELSE --if the person is on an Active Payment Plan..
1368:
1369: --Log the message that the Student is on an Active Payment Plan.
1370: fnd_message.set_name('IGS','IGS_FI_PP_PRSN_ON_PP');
1371: fnd_file.put_line(fnd_file.log,fnd_message.get);
1372: fnd_file.new_line(fnd_file.log);
1373:
1374: --If the plan type is 'Finance' then..

Line 1371: fnd_file.put_line(fnd_file.log,fnd_message.get);

1367: ELSE --if the person is on an Active Payment Plan..
1368:
1369: --Log the message that the Student is on an Active Payment Plan.
1370: fnd_message.set_name('IGS','IGS_FI_PP_PRSN_ON_PP');
1371: fnd_file.put_line(fnd_file.log,fnd_message.get);
1372: fnd_file.new_line(fnd_file.log);
1373:
1374: --If the plan type is 'Finance' then..
1375: IF p_cur_plan.plan_type = g_v_finance THEN

Line 1395: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_NO_CHG_APP_BT_CUT_OFF'));

1391: );
1392: IF l_payable_bal <= 0 THEN
1393: --Log different messages in the log file depending on accrual type.
1394: IF NVL(p_cur_plan.payment_plan_accrl_type_code,p_cur_plan.accrual_type) = g_v_cutoff_dt THEN
1395: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_NO_CHG_APP_BT_CUT_OFF'));
1396: RETURN;
1397: ELSIF NVL(p_cur_plan.payment_plan_accrl_type_code,p_cur_plan.accrual_type) = g_v_due_dt THEN
1398: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_PP_INST_NO_AMT_DUE'));
1399: RETURN;

Line 1398: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_PP_INST_NO_AMT_DUE'));

1394: IF NVL(p_cur_plan.payment_plan_accrl_type_code,p_cur_plan.accrual_type) = g_v_cutoff_dt THEN
1395: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_NO_CHG_APP_BT_CUT_OFF'));
1396: RETURN;
1397: ELSIF NVL(p_cur_plan.payment_plan_accrl_type_code,p_cur_plan.accrual_type) = g_v_due_dt THEN
1398: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_PP_INST_NO_AMT_DUE'));
1399: RETURN;
1400: END IF;
1401: END IF;
1402:

Line 1546: fnd_message.set_name ( 'IGS', l_v_message_name );

1542: -- If its NULL or OTHER then this process should error out by logging message.
1543: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,
1544: p_v_message_name => l_v_message_name );
1545: IF l_v_manage_accounts IS NULL OR l_v_manage_accounts = 'OTHER' THEN
1546: fnd_message.set_name ( 'IGS', l_v_message_name );
1547: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
1548: RAISE l_validation_exp;
1549: END IF;
1550:

Line 1547: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

1543: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,
1544: p_v_message_name => l_v_message_name );
1545: IF l_v_manage_accounts IS NULL OR l_v_manage_accounts = 'OTHER' THEN
1546: fnd_message.set_name ( 'IGS', l_v_message_name );
1547: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
1548: RAISE l_validation_exp;
1549: END IF;
1550:
1551: --Check whether Holds Balance Conversion Process is running or not. If yes, Error out.

Line 1557: fnd_message.set_name('IGS','IGS_FI_REASS_BAL_PRC_RUN');

1553: igs_fi_gen_007.finp_get_conv_prc_run_ind ( p_n_conv_process_run_ind => l_conv_process_run_ind,
1554: p_v_message_name => l_message_name );
1555: IF ((l_conv_process_run_ind IS NOT NULL) AND (l_conv_process_run_ind = 1)) THEN
1556: fnd_file.new_line(fnd_file.log);
1557: fnd_message.set_name('IGS','IGS_FI_REASS_BAL_PRC_RUN');
1558: fnd_file.put_line(fnd_file.log,fnd_message.get());
1559: RAISE l_validation_exp;
1560: ELSIF ((l_message_name IS NOT NULL) AND (l_conv_process_run_ind IS NULL)) THEN
1561: fnd_file.new_line(fnd_file.log);

Line 1558: fnd_file.put_line(fnd_file.log,fnd_message.get());

1554: p_v_message_name => l_message_name );
1555: IF ((l_conv_process_run_ind IS NOT NULL) AND (l_conv_process_run_ind = 1)) THEN
1556: fnd_file.new_line(fnd_file.log);
1557: fnd_message.set_name('IGS','IGS_FI_REASS_BAL_PRC_RUN');
1558: fnd_file.put_line(fnd_file.log,fnd_message.get());
1559: RAISE l_validation_exp;
1560: ELSIF ((l_message_name IS NOT NULL) AND (l_conv_process_run_ind IS NULL)) THEN
1561: fnd_file.new_line(fnd_file.log);
1562: fnd_message.set_name('IGS',l_message_name);

Line 1562: fnd_message.set_name('IGS',l_message_name);

1558: fnd_file.put_line(fnd_file.log,fnd_message.get());
1559: RAISE l_validation_exp;
1560: ELSIF ((l_message_name IS NOT NULL) AND (l_conv_process_run_ind IS NULL)) THEN
1561: fnd_file.new_line(fnd_file.log);
1562: fnd_message.set_name('IGS',l_message_name);
1563: fnd_file.put_line(fnd_file.log,fnd_message.get());
1564: RAISE l_validation_exp;
1565: END IF;
1566:

Line 1563: fnd_file.put_line(fnd_file.log,fnd_message.get());

1559: RAISE l_validation_exp;
1560: ELSIF ((l_message_name IS NOT NULL) AND (l_conv_process_run_ind IS NULL)) THEN
1561: fnd_file.new_line(fnd_file.log);
1562: fnd_message.set_name('IGS',l_message_name);
1563: fnd_file.put_line(fnd_file.log,fnd_message.get());
1564: RAISE l_validation_exp;
1565: END IF;
1566:
1567: --Logging the parameters

Line 1599: fnd_message.set_name('IGS','IGS_FI_ANC_LOG_PARM');

1595: OPEN cur_fee(l_cur_plan.fee_type,l_cal_type,l_sequence_number);
1596: FETCH cur_fee INTO l_cur_fee;
1597: CLOSE cur_fee;
1598:
1599: fnd_message.set_name('IGS','IGS_FI_ANC_LOG_PARM');
1600: fnd_file.put_line(fnd_file.log,fnd_message.get||':');
1601: fnd_file.new_line(fnd_file.log);
1602:
1603: log_messages(lookup_desc('IGS_FI_LOCKBOX','PARTY'),l_v_person_number);

Line 1600: fnd_file.put_line(fnd_file.log,fnd_message.get||':');

1596: FETCH cur_fee INTO l_cur_fee;
1597: CLOSE cur_fee;
1598:
1599: fnd_message.set_name('IGS','IGS_FI_ANC_LOG_PARM');
1600: fnd_file.put_line(fnd_file.log,fnd_message.get||':');
1601: fnd_file.new_line(fnd_file.log);
1602:
1603: log_messages(lookup_desc('IGS_FI_LOCKBOX','PARTY'),l_v_person_number);
1604: log_messages(lookup_desc('IGS_FI_LOCKBOX','PERSON_GROUP'),TO_CHAR(p_pers_id_grp_id));

Line 1623: fnd_message.set_name('IGS','IGS_FI_PARAMETER_NULL');

1619: -- of Bug# 2731350
1620: --Validating if all the mandatory parameter are passed
1621: IF ((p_plan_name IS NULL) OR (p_batch_cutoff_dt IS NULL) OR (p_batch_due_dt IS NULL)
1622: OR (p_fee_period IS NULL) OR (p_test_flag IS NULL) OR (p_chg_crtn_dt IS NULL) ) THEN
1623: fnd_message.set_name('IGS','IGS_FI_PARAMETER_NULL');
1624: fnd_file.put_line ( fnd_file.log, fnd_message.get );
1625: RAISE l_validation_exp;
1626: END IF;
1627:

Line 1624: fnd_file.put_line ( fnd_file.log, fnd_message.get );

1620: --Validating if all the mandatory parameter are passed
1621: IF ((p_plan_name IS NULL) OR (p_batch_cutoff_dt IS NULL) OR (p_batch_due_dt IS NULL)
1622: OR (p_fee_period IS NULL) OR (p_test_flag IS NULL) OR (p_chg_crtn_dt IS NULL) ) THEN
1623: fnd_message.set_name('IGS','IGS_FI_PARAMETER_NULL');
1624: fnd_file.put_line ( fnd_file.log, fnd_message.get );
1625: RAISE l_validation_exp;
1626: END IF;
1627:
1628:

Line 1631: fnd_message.set_name('IGS','IGS_FI_PRS_OR_PRSIDGRP');

1627:
1628:
1629: --Validating person Id and person id group cannot be present at a same time
1630: IF p_person_id IS NOT NULL AND p_pers_id_grp_id IS NOT NULL THEN
1631: fnd_message.set_name('IGS','IGS_FI_PRS_OR_PRSIDGRP');
1632: fnd_file.put_line ( fnd_file.log, fnd_message.get );
1633: RAISE l_validation_exp;
1634: END IF;
1635:

Line 1632: fnd_file.put_line ( fnd_file.log, fnd_message.get );

1628:
1629: --Validating person Id and person id group cannot be present at a same time
1630: IF p_person_id IS NOT NULL AND p_pers_id_grp_id IS NOT NULL THEN
1631: fnd_message.set_name('IGS','IGS_FI_PRS_OR_PRSIDGRP');
1632: fnd_file.put_line ( fnd_file.log, fnd_message.get );
1633: RAISE l_validation_exp;
1634: END IF;
1635:
1636: -- Either person Id or person id group should be passed as a parameter

Line 1638: fnd_message.set_name('IGS','IGS_FI_PRS_PRSIDGRP_NULL');

1634: END IF;
1635:
1636: -- Either person Id or person id group should be passed as a parameter
1637: IF p_person_id IS NULL AND p_pers_id_grp_id IS NULL THEN
1638: fnd_message.set_name('IGS','IGS_FI_PRS_PRSIDGRP_NULL');
1639: fnd_file.put_line ( fnd_file.log, fnd_message.get );
1640: RAISE l_validation_exp;
1641: END IF;
1642:

Line 1639: fnd_file.put_line ( fnd_file.log, fnd_message.get );

1635:
1636: -- Either person Id or person id group should be passed as a parameter
1637: IF p_person_id IS NULL AND p_pers_id_grp_id IS NULL THEN
1638: fnd_message.set_name('IGS','IGS_FI_PRS_PRSIDGRP_NULL');
1639: fnd_file.put_line ( fnd_file.log, fnd_message.get );
1640: RAISE l_validation_exp;
1641: END IF;
1642:
1643: --Validating person id group

Line 1646: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

1642:
1643: --Validating person id group
1644: IF p_pers_id_grp_id IS NOT NULL THEN
1645: IF NOT validate_persid_grp(p_pers_id_grp_id) THEN
1646: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1647: fnd_file.put_line ( fnd_file.log, fnd_message.get );
1648: RAISE l_validation_exp;
1649: END IF;
1650: END IF;

Line 1647: fnd_file.put_line ( fnd_file.log, fnd_message.get );

1643: --Validating person id group
1644: IF p_pers_id_grp_id IS NOT NULL THEN
1645: IF NOT validate_persid_grp(p_pers_id_grp_id) THEN
1646: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1647: fnd_file.put_line ( fnd_file.log, fnd_message.get );
1648: RAISE l_validation_exp;
1649: END IF;
1650: END IF;
1651:

Line 1655: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

1651:
1652: --Validating person id
1653: IF p_person_id IS NOT NULL THEN
1654: IF igs_fi_gen_007.validate_person(p_person_id)= 'N' THEN
1655: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1656: fnd_file.put_line ( fnd_file.log, fnd_message.get );
1657: RAISE l_validation_exp;
1658: END IF;
1659: END IF;

Line 1656: fnd_file.put_line ( fnd_file.log, fnd_message.get );

1652: --Validating person id
1653: IF p_person_id IS NOT NULL THEN
1654: IF igs_fi_gen_007.validate_person(p_person_id)= 'N' THEN
1655: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1656: fnd_file.put_line ( fnd_file.log, fnd_message.get );
1657: RAISE l_validation_exp;
1658: END IF;
1659: END IF;
1660:

Line 1663: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

1659: END IF;
1660:
1661: --Validating Plan Name
1662: IF NOT validate_plan_name(p_plan_name) THEN
1663: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1664: fnd_file.put_line ( fnd_file.log, fnd_message.get );
1665: RAISE l_validation_exp;
1666: END IF;
1667:

Line 1664: fnd_file.put_line ( fnd_file.log, fnd_message.get );

1660:
1661: --Validating Plan Name
1662: IF NOT validate_plan_name(p_plan_name) THEN
1663: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1664: fnd_file.put_line ( fnd_file.log, fnd_message.get );
1665: RAISE l_validation_exp;
1666: END IF;
1667:
1668: --Validating cut off date with due date

Line 1670: fnd_message.set_name('IGS','IGS_FI_CTDT_DUEDT');

1666: END IF;
1667:
1668: --Validating cut off date with due date
1669: IF l_batch_cutoff_dt >= l_batch_due_dt THEN
1670: fnd_message.set_name('IGS','IGS_FI_CTDT_DUEDT');
1671: fnd_file.put_line ( fnd_file.log, fnd_message.get );
1672: RAISE l_validation_exp;
1673: END IF;
1674:

Line 1671: fnd_file.put_line ( fnd_file.log, fnd_message.get );

1667:
1668: --Validating cut off date with due date
1669: IF l_batch_cutoff_dt >= l_batch_due_dt THEN
1670: fnd_message.set_name('IGS','IGS_FI_CTDT_DUEDT');
1671: fnd_file.put_line ( fnd_file.log, fnd_message.get );
1672: RAISE l_validation_exp;
1673: END IF;
1674:
1675: --Validating charge creation date with cut off date

Line 1677: fnd_message.set_name('IGS','IGS_FI_CTDT_CHG_DT');

1673: END IF;
1674:
1675: --Validating charge creation date with cut off date
1676: IF l_batch_cutoff_dt >= l_chg_crtn_dt THEN
1677: fnd_message.set_name('IGS','IGS_FI_CTDT_CHG_DT');
1678: fnd_file.put_line ( fnd_file.log, fnd_message.get );
1679: RAISE l_validation_exp;
1680: END IF;
1681:

Line 1678: fnd_file.put_line ( fnd_file.log, fnd_message.get );

1674:
1675: --Validating charge creation date with cut off date
1676: IF l_batch_cutoff_dt >= l_chg_crtn_dt THEN
1677: fnd_message.set_name('IGS','IGS_FI_CTDT_CHG_DT');
1678: fnd_file.put_line ( fnd_file.log, fnd_message.get );
1679: RAISE l_validation_exp;
1680: END IF;
1681:
1682:

Line 1685: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

1681:
1682:
1683: --Validating FTCI
1684: IF NOT validate_ftci(l_cur_plan,l_cal_type,l_sequence_number) THEN
1685: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1686: fnd_file.put_line ( fnd_file.log, fnd_message.get );
1687: RAISE l_validation_exp;
1688: END IF;
1689:

Line 1686: fnd_file.put_line ( fnd_file.log, fnd_message.get );

1682:
1683: --Validating FTCI
1684: IF NOT validate_ftci(l_cur_plan,l_cal_type,l_sequence_number) THEN
1685: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1686: fnd_file.put_line ( fnd_file.log, fnd_message.get );
1687: RAISE l_validation_exp;
1688: END IF;
1689:
1690: --GL date parameter is mandatory, hence if passed as null, error out NOCOPY of the concurrent job.

Line 1692: fnd_message.set_name('IGS','IGS_GE_INSUFFICIENT_PARAMETER');

1688: END IF;
1689:
1690: --GL date parameter is mandatory, hence if passed as null, error out NOCOPY of the concurrent job.
1691: IF p_d_gl_date IS NULL THEN
1692: fnd_message.set_name('IGS','IGS_GE_INSUFFICIENT_PARAMETER');
1693: fnd_file.put_line(fnd_file.log, fnd_message.get );
1694: RAISE l_validation_exp;
1695: END IF;
1696:

Line 1693: fnd_file.put_line(fnd_file.log, fnd_message.get );

1689:
1690: --GL date parameter is mandatory, hence if passed as null, error out NOCOPY of the concurrent job.
1691: IF p_d_gl_date IS NULL THEN
1692: fnd_message.set_name('IGS','IGS_GE_INSUFFICIENT_PARAMETER');
1693: fnd_file.put_line(fnd_file.log, fnd_message.get );
1694: RAISE l_validation_exp;
1695: END IF;
1696:
1697: --Validate the GL Date.

Line 1703: fnd_message.set_name('IGS',l_v_message_name);

1699: p_v_closing_status => l_v_closing_status,
1700: p_v_message_name => l_v_message_name
1701: );
1702: IF l_v_message_name IS NOT NULL THEN
1703: fnd_message.set_name('IGS',l_v_message_name);
1704: fnd_file.put_line(fnd_file.log,fnd_message.get);
1705: RAISE l_validation_exp;
1706: END IF;
1707:

Line 1704: fnd_file.put_line(fnd_file.log,fnd_message.get);

1700: p_v_message_name => l_v_message_name
1701: );
1702: IF l_v_message_name IS NOT NULL THEN
1703: fnd_message.set_name('IGS',l_v_message_name);
1704: fnd_file.put_line(fnd_file.log,fnd_message.get);
1705: RAISE l_validation_exp;
1706: END IF;
1707:
1708: --Error out NOCOPY the concurrent process if the GL Date is not a valid one.

Line 1710: fnd_message.set_name('IGS','IGS_FI_INVALID_GL_DATE');

1706: END IF;
1707:
1708: --Error out NOCOPY the concurrent process if the GL Date is not a valid one.
1709: IF l_v_closing_status IN ('C','N','W') THEN
1710: fnd_message.set_name('IGS','IGS_FI_INVALID_GL_DATE');
1711: fnd_message.set_token('GL_DATE',l_d_gl_date);
1712: fnd_file.put_line(fnd_file.log,fnd_message.get);
1713: RAISE l_validation_exp;
1714: END IF;

Line 1711: fnd_message.set_token('GL_DATE',l_d_gl_date);

1707:
1708: --Error out NOCOPY the concurrent process if the GL Date is not a valid one.
1709: IF l_v_closing_status IN ('C','N','W') THEN
1710: fnd_message.set_name('IGS','IGS_FI_INVALID_GL_DATE');
1711: fnd_message.set_token('GL_DATE',l_d_gl_date);
1712: fnd_file.put_line(fnd_file.log,fnd_message.get);
1713: RAISE l_validation_exp;
1714: END IF;
1715:

Line 1712: fnd_file.put_line(fnd_file.log,fnd_message.get);

1708: --Error out NOCOPY the concurrent process if the GL Date is not a valid one.
1709: IF l_v_closing_status IN ('C','N','W') THEN
1710: fnd_message.set_name('IGS','IGS_FI_INVALID_GL_DATE');
1711: fnd_message.set_token('GL_DATE',l_d_gl_date);
1712: fnd_file.put_line(fnd_file.log,fnd_message.get);
1713: RAISE l_validation_exp;
1714: END IF;
1715:
1716: --Logging the plan information

Line 1722: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_DUDT_OFFST'));

1718:
1719: --Validating offset date >= sysdate
1720: l_offset_date := l_batch_due_dt + NVL(l_cur_plan.offset_days,0);
1721: IF l_offset_date >= g_d_sysdate THEN
1722: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_DUDT_OFFST'));
1723: ELSE
1724: --Find the latest balance rule id for the balance type FEE.Return values last_conversion_date and
1725: --version number are ignored by passing null.
1726:

Line 1772: fnd_message.set_name('IGF','IGF_AP_INVALID_QUERY');

1768: );
1769: --If the sql returned is invalid.. then,
1770: IF l_v_status <> 'S' THEN
1771: --Log the error message and stop processing.
1772: fnd_message.set_name('IGF','IGF_AP_INVALID_QUERY');
1773: fnd_file.put_line(fnd_file.log,fnd_message.get);
1774: fnd_file.put_line(fnd_file.log,l_v_sql);
1775: retcode := 2;
1776: RETURN;

Line 1773: fnd_file.put_line(fnd_file.log,fnd_message.get);

1769: --If the sql returned is invalid.. then,
1770: IF l_v_status <> 'S' THEN
1771: --Log the error message and stop processing.
1772: fnd_message.set_name('IGF','IGF_AP_INVALID_QUERY');
1773: fnd_file.put_line(fnd_file.log,fnd_message.get);
1774: fnd_file.put_line(fnd_file.log,l_v_sql);
1775: retcode := 2;
1776: RETURN;
1777: END IF;

Line 1820: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_GE_TOTAL_REC_PROCESSED')||TO_CHAR(l_record_count));

1816: ROLLBACK TO s_calc_fin_lt_charge;
1817: END IF;
1818:
1819: fnd_file.put_line(fnd_file.log,g_v_hor_line);
1820: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_GE_TOTAL_REC_PROCESSED')||TO_CHAR(l_record_count));
1821: fnd_file.put_line(fnd_file.log,g_v_hor_line);
1822: fnd_file.new_line(fnd_file.log);
1823:
1824:

Line 1830: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;

1826: WHEN l_validation_exp THEN
1827: retcode := 2;
1828: WHEN OTHERS THEN
1829: retcode := 2;
1830: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
1831: igs_ge_msg_stack.conc_exception_hndl;
1832: END calc_fin_lt_charge;
1833:
1834: END igs_fi_prc_fin_lt_chg;