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_CL_ROSTER dependencies on IGF_AW_GEN

Line 939: tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);

935: Who When What
936: (reverse chronological order - newest change first)
937: ridas 07-Aug-2006 Build FA163. Added condition to check the Direct_to_borr_ind difference between
938: the roster information and the disbursement table information.
939: tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
940: veramach 3-NOV-2003 FA 125 Multiple Distr Methods
941: Changed the call of igf_aw_awd_disb_pkg.update_row to reflect the addition of attendance_type_code
942: ***************************************************************/
943:

Line 976: loan_number_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER');

972: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
973: AS
974: l_msg_str_0 VARCHAR2(1000);
975: BEGIN
976: loan_number_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER');
977: disb_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM');
978: loc_disb_desc := igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS');
979: ofa_disb_desc := igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS');
980: fee_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1');

Line 977: disb_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM');

973: AS
974: l_msg_str_0 VARCHAR2(1000);
975: BEGIN
976: loan_number_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER');
977: disb_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM');
978: loc_disb_desc := igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS');
979: ofa_disb_desc := igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS');
980: fee_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1');
981: fee_2_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2');

Line 978: loc_disb_desc := igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS');

974: l_msg_str_0 VARCHAR2(1000);
975: BEGIN
976: loan_number_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER');
977: disb_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM');
978: loc_disb_desc := igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS');
979: ofa_disb_desc := igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS');
980: fee_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1');
981: fee_2_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2');
982: disb_net_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT');

Line 979: ofa_disb_desc := igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS');

975: BEGIN
976: loan_number_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER');
977: disb_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM');
978: loc_disb_desc := igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS');
979: ofa_disb_desc := igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS');
980: fee_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1');
981: fee_2_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2');
982: disb_net_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT');
983: fee_paid_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1');

Line 980: fee_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1');

976: loan_number_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER');
977: disb_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM');
978: loc_disb_desc := igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS');
979: ofa_disb_desc := igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS');
980: fee_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1');
981: fee_2_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2');
982: disb_net_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT');
983: fee_paid_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1');
984: fee_paid_2_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2');

Line 981: fee_2_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2');

977: disb_num_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM');
978: loc_disb_desc := igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS');
979: ofa_disb_desc := igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS');
980: fee_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1');
981: fee_2_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2');
982: disb_net_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT');
983: fee_paid_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1');
984: fee_paid_2_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2');
985: disb_gross_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT');

Line 982: disb_net_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT');

978: loc_disb_desc := igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS');
979: ofa_disb_desc := igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS');
980: fee_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1');
981: fee_2_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2');
982: disb_net_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT');
983: fee_paid_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1');
984: fee_paid_2_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2');
985: disb_gross_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT');
986: direct_to_borr_ind_desc := igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','DIRECT_TO_BORR_IND');

Line 983: fee_paid_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1');

979: ofa_disb_desc := igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS');
980: fee_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1');
981: fee_2_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2');
982: disb_net_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT');
983: fee_paid_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1');
984: fee_paid_2_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2');
985: disb_gross_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT');
986: direct_to_borr_ind_desc := igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','DIRECT_TO_BORR_IND');
987: fnd_file.put_line(fnd_file.log, '');

Line 984: fee_paid_2_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2');

980: fee_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1');
981: fee_2_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2');
982: disb_net_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT');
983: fee_paid_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1');
984: fee_paid_2_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2');
985: disb_gross_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT');
986: direct_to_borr_ind_desc := igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','DIRECT_TO_BORR_IND');
987: fnd_file.put_line(fnd_file.log, '');
988: l_msg_str_0 := RPAD(loan_number_desc,30)||' : '|| p_loan_number ||'

Line 985: disb_gross_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT');

981: fee_2_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2');
982: disb_net_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT');
983: fee_paid_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1');
984: fee_paid_2_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2');
985: disb_gross_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT');
986: direct_to_borr_ind_desc := igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','DIRECT_TO_BORR_IND');
987: fnd_file.put_line(fnd_file.log, '');
988: l_msg_str_0 := RPAD(loan_number_desc,30)||' : '|| p_loan_number ||'
989: '||RPAD(disb_num_desc,30) ||' : '||TO_CHAR(p_disb_num);

Line 986: direct_to_borr_ind_desc := igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','DIRECT_TO_BORR_IND');

982: disb_net_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT');
983: fee_paid_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1');
984: fee_paid_2_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2');
985: disb_gross_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT');
986: direct_to_borr_ind_desc := igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','DIRECT_TO_BORR_IND');
987: fnd_file.put_line(fnd_file.log, '');
988: l_msg_str_0 := RPAD(loan_number_desc,30)||' : '|| p_loan_number ||'
989: '||RPAD(disb_num_desc,30) ||' : '||TO_CHAR(p_disb_num);
990:

Line 998: igf_aw_gen.set_org_id(NULL);

994:
995:
996: BEGIN
997:
998: igf_aw_gen.set_org_id(NULL);
999: retcode := 0;
1000: -- Load the data into the Batch and Response Table
1001:
1002: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1097: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code1));

1093: OR cbth_rec.err_code4 IS NOT NULL
1094: OR cbth_rec.err_code5 IS NOT NULL THEN
1095:
1096: IF cbth_rec.err_code1 IS NOT NULL THEN
1097: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code1));
1098: END IF;
1099: IF cbth_rec.err_code2 IS NOT NULL THEN
1100: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code2));
1101: END IF;

Line 1100: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code2));

1096: IF cbth_rec.err_code1 IS NOT NULL THEN
1097: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code1));
1098: END IF;
1099: IF cbth_rec.err_code2 IS NOT NULL THEN
1100: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code2));
1101: END IF;
1102: IF cbth_rec.err_code3 IS NOT NULL THEN
1103: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code3));
1104: END IF;

Line 1103: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code3));

1099: IF cbth_rec.err_code2 IS NOT NULL THEN
1100: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code2));
1101: END IF;
1102: IF cbth_rec.err_code3 IS NOT NULL THEN
1103: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code3));
1104: END IF;
1105: IF cbth_rec.err_code4 IS NOT NULL THEN
1106: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code4));
1107: END IF;

Line 1106: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code4));

1102: IF cbth_rec.err_code3 IS NOT NULL THEN
1103: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code3));
1104: END IF;
1105: IF cbth_rec.err_code4 IS NOT NULL THEN
1106: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code4));
1107: END IF;
1108: IF cbth_rec.err_code5 IS NOT NULL THEN
1109: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code5));
1110: END IF;

Line 1109: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code5));

1105: IF cbth_rec.err_code4 IS NOT NULL THEN
1106: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code4));
1107: END IF;
1108: IF cbth_rec.err_code5 IS NOT NULL THEN
1109: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code5));
1110: END IF;
1111: END IF;
1112:
1113: