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.IGF_DB_DL_ORIG_ACK dependencies on IGF_AW_GEN

Line 179: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));

175:
176: IF l_rec_batch_rej_code IS NOT NULL THEN
177: fnd_message.set_name('IGF','IGF_GE_BATCH_REJECTED');
178: fnd_message.set_token('BATCH', l_rec_batch_id);
179: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));
180: igs_ge_msg_stack.add;
181: RAISE FILE_NOT_LOADED;
182: -- Message : Batch #BATCH was rejected. Reason : #REASON.
183:

Line 312: ridas 31-Jan-2006 Bug #4951401. Added procedure igf_aw_gen.set_org_id()

308: bvisvana 19-Jul-2005 Bug 4101317 - RAISE INVALID_PHASE_IN_PARTICIPANT in case on award year not a phase in participant
309: vvutukur 26-Feb-2003 Enh#2758823.FA117 Build. Replaced message IGS_GE_FILE_NOT_LOADED with IGF_GE_FILE_NOT_LOADED as the former one
310: is not a correct one.Removed validations regarding loan_num_status,disb_num_status,disb_seq_num_status,sch_code_status.
311: Removed if condition IF lcur_awdisb.booking_batch_id IS NOT NULL THEN.
312: ridas 31-Jan-2006 Bug #4951401. Added procedure igf_aw_gen.set_org_id()
313: ***************************************************************/
314:
315: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE; -- ## Variable for the batch ID
316: l_batch_type igf_sl_dl_batch.batch_type%TYPE;

Line 415: igf_aw_gen.set_org_id(p_org_id);

411: END;
412:
413: BEGIN
414:
415: igf_aw_gen.set_org_id(p_org_id);
416:
417: -- Load the Data into the Batch and Response Tables
418: disb_load_data(l_dbth_id, l_batch_id,l_dl_version, l_dl_file_type);
419:

Line 439: l_loan_number_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER');

435: END IF;
436:
437: -- ## Getting the Loopkup Descriptions.
438:
439: l_loan_number_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER');
440: l_disb_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM');
441: l_disb_seq_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_SEQ_NUM');
442: l_disb_gross_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT');
443: l_fee_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1');

Line 440: l_disb_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM');

436:
437: -- ## Getting the Loopkup Descriptions.
438:
439: l_loan_number_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER');
440: l_disb_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM');
441: l_disb_seq_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_SEQ_NUM');
442: l_disb_gross_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT');
443: l_fee_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1');
444: l_disb_net_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT');

Line 441: l_disb_seq_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_SEQ_NUM');

437: -- ## Getting the Loopkup Descriptions.
438:
439: l_loan_number_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER');
440: l_disb_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM');
441: l_disb_seq_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_SEQ_NUM');
442: l_disb_gross_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT');
443: l_fee_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1');
444: l_disb_net_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT');
445: l_int_rebate_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','INT_REBATE_AMT');

Line 442: l_disb_gross_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT');

438:
439: l_loan_number_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER');
440: l_disb_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM');
441: l_disb_seq_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_SEQ_NUM');
442: l_disb_gross_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT');
443: l_fee_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1');
444: l_disb_net_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT');
445: l_int_rebate_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','INT_REBATE_AMT');
446: l_disb_date_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE');

Line 443: l_fee_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1');

439: l_loan_number_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER');
440: l_disb_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM');
441: l_disb_seq_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_SEQ_NUM');
442: l_disb_gross_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT');
443: l_fee_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1');
444: l_disb_net_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT');
445: l_int_rebate_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','INT_REBATE_AMT');
446: l_disb_date_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE');
447:

Line 444: l_disb_net_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT');

440: l_disb_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM');
441: l_disb_seq_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_SEQ_NUM');
442: l_disb_gross_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT');
443: l_fee_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1');
444: l_disb_net_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT');
445: l_int_rebate_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','INT_REBATE_AMT');
446: l_disb_date_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE');
447:
448: FOR lcur_db_resp IN cur_db_resp(l_dbth_id)

Line 445: l_int_rebate_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','INT_REBATE_AMT');

441: l_disb_seq_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_SEQ_NUM');
442: l_disb_gross_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT');
443: l_fee_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1');
444: l_disb_net_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT');
445: l_int_rebate_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','INT_REBATE_AMT');
446: l_disb_date_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE');
447:
448: FOR lcur_db_resp IN cur_db_resp(l_dbth_id)
449: LOOP -- ## Open the Disb LOOP

Line 446: l_disb_date_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE');

442: l_disb_gross_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT');
443: l_fee_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1');
444: l_disb_net_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT');
445: l_int_rebate_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','INT_REBATE_AMT');
446: l_disb_date_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE');
447:
448: FOR lcur_db_resp IN cur_db_resp(l_dbth_id)
449: LOOP -- ## Open the Disb LOOP
450:

Line 504: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',

500: IF lcur_db_resp.disb_activity_status IS NOT NULL THEN
501:
502: log_start(lcur_db_resp.loan_number, lcur_db_resp.disb_num, lcur_db_resp.disb_seq_num);
503:
504: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',
505: LTRIM(RTRIM(SUBSTR(lcur_db_resp.disb_activity_status,1,2)))
506: )
507: );
508: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',

Line 508: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',

504: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',
505: LTRIM(RTRIM(SUBSTR(lcur_db_resp.disb_activity_status,1,2)))
506: )
507: );
508: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',
509: LTRIM(RTRIM(SUBSTR(lcur_db_resp.disb_activity_status,3,2)))
510: )
511: );
512: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',

Line 512: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',

508: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',
509: LTRIM(RTRIM(SUBSTR(lcur_db_resp.disb_activity_status,3,2)))
510: )
511: );
512: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',
513: LTRIM(RTRIM(SUBSTR(lcur_db_resp.disb_activity_status,5,2)))
514: )
515: );
516: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',

Line 516: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',

512: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',
513: LTRIM(RTRIM(SUBSTR(lcur_db_resp.disb_activity_status,5,2)))
514: )
515: );
516: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',
517: LTRIM(RTRIM(SUBSTR(lcur_db_resp.disb_activity_status,7,2)))
518: )
519: );
520: END IF;

Line 554: l_mesg_str2 := RPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS'),35);

550: OR NVL(lcur_db_resp.loc_disb_net_amt,lcur_awdisb.disb_net_amt) <> NVL(lcur_awdisb.disb_net_amt,0) THEN
551:
552:
553: l_mesg_str1 := RPAD(' ',35);
554: l_mesg_str2 := RPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS'),35);
555: l_mesg_str3 := RPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS'),35);
556:
557: l_mesg_str1 := l_mesg_str1 || LPAD(l_disb_gross_amt_desc,50);
558: l_mesg_str2 := l_mesg_str2 || LPAD(NVL(lcur_db_resp.loc_disb_gross_amt,''),50);

Line 555: l_mesg_str3 := RPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS'),35);

551:
552:
553: l_mesg_str1 := RPAD(' ',35);
554: l_mesg_str2 := RPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS'),35);
555: l_mesg_str3 := RPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS'),35);
556:
557: l_mesg_str1 := l_mesg_str1 || LPAD(l_disb_gross_amt_desc,50);
558: l_mesg_str2 := l_mesg_str2 || LPAD(NVL(lcur_db_resp.loc_disb_gross_amt,''),50);
559: l_mesg_str3 := l_mesg_str3 || LPAD(lcur_awdisb.disb_accepted_amt,50);