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_AW_LI_IMPORT dependencies on IGF_AP_GEN

Line 1272: g_processing_string := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||

1268: -- initialize the return statuses, assuming all the validations are successful.
1269: l_return_value :='S'; l_status_open_awd_yr :='S'; l_return_status_db := 'S';
1270: -- initialize applicable global variables here.
1271: g_base_id := NULL; g_fund_code := NULL; g_fed_fund_code := NULL; g_fund_id := NULL;
1272: g_processing_string := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||
1273: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_NUMBER')|| ' : '
1274: || li_awd_rec.award_number_txt ||' '||
1275: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','FUND_CODE')
1276: || ' : '|| li_awd_rec.fund_code;

Line 1273: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_NUMBER')|| ' : '

1269: l_return_value :='S'; l_status_open_awd_yr :='S'; l_return_status_db := 'S';
1270: -- initialize applicable global variables here.
1271: g_base_id := NULL; g_fund_code := NULL; g_fed_fund_code := NULL; g_fund_id := NULL;
1272: g_processing_string := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||
1273: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_NUMBER')|| ' : '
1274: || li_awd_rec.award_number_txt ||' '||
1275: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','FUND_CODE')
1276: || ' : '|| li_awd_rec.fund_code;
1277: FND_FILE.PUT_LINE(FND_FILE.LOG,g_processing_string);

Line 1275: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','FUND_CODE')

1271: g_base_id := NULL; g_fund_code := NULL; g_fed_fund_code := NULL; g_fund_id := NULL;
1272: g_processing_string := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||
1273: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_NUMBER')|| ' : '
1274: || li_awd_rec.award_number_txt ||' '||
1275: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','FUND_CODE')
1276: || ' : '|| li_awd_rec.fund_code;
1277: FND_FILE.PUT_LINE(FND_FILE.LOG,g_processing_string);
1278:
1279: IF(li_awd_rec.import_record_type = 'U' OR li_awd_rec.import_record_type IS NULL) THEN

Line 1307: OR igf_ap_gen.get_aw_lookup_meaning('IGF_AWARD_STATUS',li_awd_rec.award_status_code, g_sys_award_year) IS NULL)THEN

1303:
1304:
1305: -- first validate if the award year status code is valid
1306: IF(li_awd_rec.award_status_code IN ('E_ACCEPTED','E_OFFERED','REVISED','SIMULATED','STOPPED')
1307: OR igf_ap_gen.get_aw_lookup_meaning('IGF_AWARD_STATUS',li_awd_rec.award_status_code, g_sys_award_year) IS NULL)THEN
1308: l_return_value :='E';
1309: FND_MESSAGE.SET_NAME('IGF','IGF_AW_LI_INVALID_AWD_STATUS');
1310: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1311: END IF;

Line 1958: g_processing_string := l_padding_string || igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||

1954: l_padding_string := RPAD(' ',3,' ')||'-- ';
1955: -- open the cusrsor cur_legacy_disb_total and obtain the total values
1956: cur_legacy_disb_total_rec := NULL;
1957: OPEN cur_legacy_disb_total; FETCH cur_legacy_disb_total INTO cur_legacy_disb_total_rec; CLOSE cur_legacy_disb_total;
1958: g_processing_string := l_padding_string || igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||
1959: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DISBURSMNT');
1960: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1961: FND_FILE.PUT_LINE(FND_FILE.LOG,g_processing_string);
1962:

Line 1959: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DISBURSMNT');

1955: -- open the cusrsor cur_legacy_disb_total and obtain the total values
1956: cur_legacy_disb_total_rec := NULL;
1957: OPEN cur_legacy_disb_total; FETCH cur_legacy_disb_total INTO cur_legacy_disb_total_rec; CLOSE cur_legacy_disb_total;
1958: g_processing_string := l_padding_string || igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||
1959: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DISBURSMNT');
1960: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1961: FND_FILE.PUT_LINE(FND_FILE.LOG,g_processing_string);
1962:
1963: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 2051: g_processing_string := RPAD(' ',3,' ')||'-- '|| igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||

2047: l_ctr := 0; -- this initialization is necessary for checking only one disb record for sponsorships
2048: FOR cur_legacy_disb_int_rec IN cur_legacy_disb_int LOOP
2049: l_ctr := l_ctr + 1;
2050: -- validate the term calendar
2051: g_processing_string := RPAD(' ',3,' ')||'-- '|| igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||
2052: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DISBURSEMENT_NUMBER');
2053: FND_FILE.PUT_LINE(FND_FILE.LOG,g_processing_string||': '||cur_legacy_disb_int_rec.disbursement_num);
2054: l_ret_val := igf_ap_gen.validate_cal_inst('LOAD',li_awd_rec.ci_alternate_code,
2055: cur_legacy_disb_int_rec.ld_alternate_code,

Line 2052: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DISBURSEMENT_NUMBER');

2048: FOR cur_legacy_disb_int_rec IN cur_legacy_disb_int LOOP
2049: l_ctr := l_ctr + 1;
2050: -- validate the term calendar
2051: g_processing_string := RPAD(' ',3,' ')||'-- '|| igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||
2052: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DISBURSEMENT_NUMBER');
2053: FND_FILE.PUT_LINE(FND_FILE.LOG,g_processing_string||': '||cur_legacy_disb_int_rec.disbursement_num);
2054: l_ret_val := igf_ap_gen.validate_cal_inst('LOAD',li_awd_rec.ci_alternate_code,
2055: cur_legacy_disb_int_rec.ld_alternate_code,
2056: l_var_cal_type,

Line 2054: l_ret_val := igf_ap_gen.validate_cal_inst('LOAD',li_awd_rec.ci_alternate_code,

2050: -- validate the term calendar
2051: g_processing_string := RPAD(' ',3,' ')||'-- '|| igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||
2052: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DISBURSEMENT_NUMBER');
2053: FND_FILE.PUT_LINE(FND_FILE.LOG,g_processing_string||': '||cur_legacy_disb_int_rec.disbursement_num);
2054: l_ret_val := igf_ap_gen.validate_cal_inst('LOAD',li_awd_rec.ci_alternate_code,
2055: cur_legacy_disb_int_rec.ld_alternate_code,
2056: l_var_cal_type,
2057: l_var_seq_number);
2058:

Line 2200: IF(igf_ap_gen.get_aw_lookup_meaning('IGF_DB_TRANS_TYPE',cur_legacy_disb_int_rec.trans_type_code,g_sys_award_year)IS NULL)THEN

2196: END IF;
2197: END IF;
2198:
2199: -- validate transacation type. valid values are ACTUAL(A), PLANNED(P), CANCELLED(C)
2200: IF(igf_ap_gen.get_aw_lookup_meaning('IGF_DB_TRANS_TYPE',cur_legacy_disb_int_rec.trans_type_code,g_sys_award_year)IS NULL)THEN
2201: p_return_status := 'E';
2202: FND_MESSAGE.SET_NAME('IGF','IGF_AP_INV_FLD_VAL');
2203: FND_MESSAGE.SET_TOKEN('FIELD','TRANS_TYPE_CODE');
2204: FND_FILE.PUT_LINE(FND_FILE.LOG,l_padding_string || FND_MESSAGE.GET);

Line 2232: igf_ap_gen.get_aw_lookup_meaning('IGF_GR_RFMS_ENROL_STAT',cur_legacy_disb_int_rec.base_attendance_type_code,g_sys_award_year) IS NULL)

2228: END IF;
2229:
2230: IF (
2231: g_fed_fund_code = 'PELL' AND
2232: igf_ap_gen.get_aw_lookup_meaning('IGF_GR_RFMS_ENROL_STAT',cur_legacy_disb_int_rec.base_attendance_type_code,g_sys_award_year) IS NULL)
2233: OR (
2234: g_fed_fund_code <> 'PELL' AND
2235: cur_legacy_disb_int_rec.base_attendance_type_code IS NOT NULL
2236: )

Line 2257: l_ret_val := igf_ap_gen.validate_cal_inst('TEACHING',cur_legacy_disb_int_rec.ld_alternate_code,

2253: END IF;
2254:
2255: -- validate teaching calendar
2256: l_ret_val := FALSE; l_var_cal_type:=NULL; l_var_seq_number:=NULL;
2257: l_ret_val := igf_ap_gen.validate_cal_inst('TEACHING',cur_legacy_disb_int_rec.ld_alternate_code,
2258: cur_legacy_disb_int_rec.tp_alternate_code,
2259: l_var_cal_type,
2260: l_var_seq_number);
2261: IF(l_ret_val = FALSE AND l_var_cal_type IS NULL)THEN

Line 2640: g_processing_string := l_padding_string || igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||

2636: l_padding_string := RPAD(' ',6,' ')||'-- ';
2637: l_disbact_rec := NULL;
2638:
2639: OPEN cur_li_disb_act_int; FETCH cur_li_disb_act_int INTO l_disbact_rec;
2640: g_processing_string := l_padding_string || igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||
2641: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DISBURSEMENT_ACTIVITY');
2642: FND_FILE.PUT_LINE(FND_FILE.LOG,g_processing_string);
2643: -- if transaction type is Actual and disb records are not found.
2644:

Line 2641: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DISBURSEMENT_ACTIVITY');

2637: l_disbact_rec := NULL;
2638:
2639: OPEN cur_li_disb_act_int; FETCH cur_li_disb_act_int INTO l_disbact_rec;
2640: g_processing_string := l_padding_string || igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||
2641: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DISBURSEMENT_ACTIVITY');
2642: FND_FILE.PUT_LINE(FND_FILE.LOG,g_processing_string);
2643: -- if transaction type is Actual and disb records are not found.
2644:
2645: IF(cur_li_disb_act_int%NOTFOUND AND li_awd_disb_rec.trans_type_code = 'A')THEN

Line 2711: g_processing_string := l_padding_string || igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||

2707: -- l_ctr has a different meaning here. used in calculating the disb_net_amt
2708: l_ctr := 0;
2709: FOR cur_li_disb_act_int_rec IN cur_li_disb_act_int LOOP
2710: l_ctr := l_ctr +1;
2711: g_processing_string := l_padding_string || igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||
2712: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DISBURSEMENT_ACTIVITY');
2713: FND_FILE.PUT_LINE(FND_FILE.LOG,g_processing_string||': '||cur_li_disb_act_int_rec.disb_activity_num);
2714: l_trans_invoice_id := NULL; l_trans_credit_id := NULL; l_trans_spnsr_credit_id := NULL; l_trans_spnsr_charge_id := NULL;
2715:

Line 2712: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DISBURSEMENT_ACTIVITY');

2708: l_ctr := 0;
2709: FOR cur_li_disb_act_int_rec IN cur_li_disb_act_int LOOP
2710: l_ctr := l_ctr +1;
2711: g_processing_string := l_padding_string || igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||
2712: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DISBURSEMENT_ACTIVITY');
2713: FND_FILE.PUT_LINE(FND_FILE.LOG,g_processing_string||': '||cur_li_disb_act_int_rec.disb_activity_num);
2714: l_trans_invoice_id := NULL; l_trans_credit_id := NULL; l_trans_spnsr_credit_id := NULL; l_trans_spnsr_charge_id := NULL;
2715:
2716: -- Disb Activity Table should not be processed for Disb Transaction Type is PLANNED

Line 3169: g_processing_string := l_padding_string || igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||

3165:
3166: BEGIN
3167: p_return_status := 'S';
3168: l_padding_string := RPAD(' ',6,' ')||'-- ';
3169: g_processing_string := l_padding_string || igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||
3170: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DISBURSEMENT_HOLD');
3171: FOR cur_li_disb_hold_int_rec IN cur_li_disb_hold_int LOOP
3172: FND_FILE.PUT_LINE(FND_FILE.LOG,g_processing_string||': '||cur_li_disb_hold_int_rec.hold_code);
3173: -- validate hold code

Line 3170: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DISBURSEMENT_HOLD');

3166: BEGIN
3167: p_return_status := 'S';
3168: l_padding_string := RPAD(' ',6,' ')||'-- ';
3169: g_processing_string := l_padding_string || igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' '||
3170: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DISBURSEMENT_HOLD');
3171: FOR cur_li_disb_hold_int_rec IN cur_li_disb_hold_int LOOP
3172: FND_FILE.PUT_LINE(FND_FILE.LOG,g_processing_string||': '||cur_li_disb_hold_int_rec.hold_code);
3173: -- validate hold code
3174: -- should be one of 'CL','DL','DL_PROM','ENROLMENT','MISC','OVERAWARD','PELL' unless some are removed for certain award years

Line 3175: IF(igf_ap_gen.get_aw_lookup_meaning('IGF_DB_DISB_HOLDS',cur_li_disb_hold_int_rec.hold_code, g_sys_award_year)IS NULL)THEN

3171: FOR cur_li_disb_hold_int_rec IN cur_li_disb_hold_int LOOP
3172: FND_FILE.PUT_LINE(FND_FILE.LOG,g_processing_string||': '||cur_li_disb_hold_int_rec.hold_code);
3173: -- validate hold code
3174: -- should be one of 'CL','DL','DL_PROM','ENROLMENT','MISC','OVERAWARD','PELL' unless some are removed for certain award years
3175: IF(igf_ap_gen.get_aw_lookup_meaning('IGF_DB_DISB_HOLDS',cur_li_disb_hold_int_rec.hold_code, g_sys_award_year)IS NULL)THEN
3176: p_return_status := 'E';
3177: FND_MESSAGE.SET_NAME('IGF','IGF_AW_LI_INVAL_HOLD_CODE');
3178: FND_MESSAGE.SET_TOKEN('HOCDE',cur_li_disb_hold_int_rec.hold_code);
3179: FND_FILE.PUT_LINE(FND_FILE.LOG,l_padding_string ||FND_MESSAGE.GET);

Line 3351: IF(igf_ap_gen.check_profile = 'N') THEN

3347: -- copy the values into global variables for further processing
3348: g_ci_cal_type := l_cal_type; g_ci_sequence_number := l_seq_number;
3349:
3350: -- <1> validate if the school is configured for us financial aid functionallity
3351: IF(igf_ap_gen.check_profile = 'N') THEN
3352: FND_MESSAGE.SET_NAME('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
3353: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3354: retcode := 2;
3355: RETURN;

Line 3362: FND_FILE.PUT_LINE(FND_FILE.LOG,igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS'));

3358: -- obtain the alternate code corresponding to the passed cal_type and seq_number
3359: OPEN cur_alt_code(l_cal_type,l_seq_number); FETCH cur_alt_code INTO l_alternate_code;CLOSE cur_alt_code;
3360:
3361: -- Record the parameters in the log
3362: FND_FILE.PUT_LINE(FND_FILE.LOG,igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS'));
3363: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YEAR'),25) || ' : '|| l_alternate_code);
3364: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','BATCH_NUMBER'),25) || ' : '|| p_batch_number);
3365: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DELETE_FLAG'),25) || ' : '||
3366: igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag));

Line 3363: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YEAR'),25) || ' : '|| l_alternate_code);

3359: OPEN cur_alt_code(l_cal_type,l_seq_number); FETCH cur_alt_code INTO l_alternate_code;CLOSE cur_alt_code;
3360:
3361: -- Record the parameters in the log
3362: FND_FILE.PUT_LINE(FND_FILE.LOG,igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS'));
3363: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YEAR'),25) || ' : '|| l_alternate_code);
3364: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','BATCH_NUMBER'),25) || ' : '|| p_batch_number);
3365: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DELETE_FLAG'),25) || ' : '||
3366: igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag));
3367: FND_FILE.PUT_LINE(fnd_file.log,RPAD('-',55,'-'));

Line 3364: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','BATCH_NUMBER'),25) || ' : '|| p_batch_number);

3360:
3361: -- Record the parameters in the log
3362: FND_FILE.PUT_LINE(FND_FILE.LOG,igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS'));
3363: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YEAR'),25) || ' : '|| l_alternate_code);
3364: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','BATCH_NUMBER'),25) || ' : '|| p_batch_number);
3365: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DELETE_FLAG'),25) || ' : '||
3366: igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag));
3367: FND_FILE.PUT_LINE(fnd_file.log,RPAD('-',55,'-'));
3368:

Line 3365: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DELETE_FLAG'),25) || ' : '||

3361: -- Record the parameters in the log
3362: FND_FILE.PUT_LINE(FND_FILE.LOG,igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS'));
3363: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YEAR'),25) || ' : '|| l_alternate_code);
3364: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','BATCH_NUMBER'),25) || ' : '|| p_batch_number);
3365: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DELETE_FLAG'),25) || ' : '||
3366: igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag));
3367: FND_FILE.PUT_LINE(fnd_file.log,RPAD('-',55,'-'));
3368:
3369: l_var_cal_type := l_cal_type;

Line 3366: igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag));

3362: FND_FILE.PUT_LINE(FND_FILE.LOG,igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS'));
3363: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YEAR'),25) || ' : '|| l_alternate_code);
3364: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','BATCH_NUMBER'),25) || ' : '|| p_batch_number);
3365: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DELETE_FLAG'),25) || ' : '||
3366: igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag));
3367: FND_FILE.PUT_LINE(fnd_file.log,RPAD('-',55,'-'));
3368:
3369: l_var_cal_type := l_cal_type;
3370: l_var_seq_number := l_seq_number;

Line 3371: l_ret_value := igf_ap_gen.validate_cal_inst('AWARD',l_alternate_code,NULL,l_var_cal_type,l_var_seq_number);

3367: FND_FILE.PUT_LINE(fnd_file.log,RPAD('-',55,'-'));
3368:
3369: l_var_cal_type := l_cal_type;
3370: l_var_seq_number := l_seq_number;
3371: l_ret_value := igf_ap_gen.validate_cal_inst('AWARD',l_alternate_code,NULL,l_var_cal_type,l_var_seq_number);
3372:
3373: -- <2> validate the existence of award year in the calendar system
3374: -- sjalasut, is this validation required ?
3375: IF(l_ret_value = FALSE AND l_var_cal_type IS NULL AND l_var_seq_number IS NULL) THEN

Line 3408: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YR_STATUS'),25)|| ' : '||

3404: END IF;
3405: END IF;
3406:
3407: -- award year status code that is printed before starting the transaction
3408: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YR_STATUS'),25)|| ' : '||
3409: igf_ap_gen.get_lookup_meaning('IGF_AWARD_YEAR_STATUS',g_award_year_status_code));
3410:
3411: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('-',55,'-'));
3412:

Line 3409: igf_ap_gen.get_lookup_meaning('IGF_AWARD_YEAR_STATUS',g_award_year_status_code));

3405: END IF;
3406:
3407: -- award year status code that is printed before starting the transaction
3408: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YR_STATUS'),25)|| ' : '||
3409: igf_ap_gen.get_lookup_meaning('IGF_AWARD_YEAR_STATUS',g_award_year_status_code));
3410:
3411: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('-',55,'-'));
3412:
3413: -- final minute validation on batch number. if the config changes and the interface tables are not updated then error

Line 3414: IF(igf_ap_gen.check_batch(p_batch_number,'AWD') = 'N')THEN

3410:
3411: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('-',55,'-'));
3412:
3413: -- final minute validation on batch number. if the config changes and the interface tables are not updated then error
3414: IF(igf_ap_gen.check_batch(p_batch_number,'AWD') = 'N')THEN
3415: FND_MESSAGE.SET_NAME('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');
3416: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3417: RETURN;
3418: END IF;

Line 3438: FND_FILE.PUT_LINE(FND_FILE.LOG,igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING')||' '||

3434:
3435: l_out_person_id := NULL; l_out_base_id := NULL; g_award_id := NULL;
3436: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3437: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('-',40,'-'));
3438: FND_FILE.PUT_LINE(FND_FILE.LOG,igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING')||' '||
3439: igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER')||' '||cur_legacy_award_int_rec.person_number);
3440: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('-',40,'-'));
3441: igf_ap_gen.check_person(cur_legacy_award_int_rec.person_number,
3442: l_cal_type,

Line 3439: igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER')||' '||cur_legacy_award_int_rec.person_number);

3435: l_out_person_id := NULL; l_out_base_id := NULL; g_award_id := NULL;
3436: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3437: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('-',40,'-'));
3438: FND_FILE.PUT_LINE(FND_FILE.LOG,igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING')||' '||
3439: igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER')||' '||cur_legacy_award_int_rec.person_number);
3440: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('-',40,'-'));
3441: igf_ap_gen.check_person(cur_legacy_award_int_rec.person_number,
3442: l_cal_type,
3443: l_seq_number,

Line 3441: igf_ap_gen.check_person(cur_legacy_award_int_rec.person_number,

3437: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('-',40,'-'));
3438: FND_FILE.PUT_LINE(FND_FILE.LOG,igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING')||' '||
3439: igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER')||' '||cur_legacy_award_int_rec.person_number);
3440: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('-',40,'-'));
3441: igf_ap_gen.check_person(cur_legacy_award_int_rec.person_number,
3442: l_cal_type,
3443: l_seq_number,
3444: l_out_person_id,
3445: l_out_base_id

Line 3534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40)||' : '||l_total_records);

3530: FND_MESSAGE.SET_NAME('IGS','IGS_FI_NO_RECORD_AVAILABLE');
3531: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3532: -- write the summary into the out files.
3533: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));
3534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40)||' : '||l_total_records);
3535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'),40)||' : '||l_success_records);
3536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_WARN'),40)||' : '||l_warning_records);
3537: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'),40)||' : '||l_rejected_records);
3538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));

Line 3535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'),40)||' : '||l_success_records);

3531: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3532: -- write the summary into the out files.
3533: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));
3534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40)||' : '||l_total_records);
3535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'),40)||' : '||l_success_records);
3536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_WARN'),40)||' : '||l_warning_records);
3537: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'),40)||' : '||l_rejected_records);
3538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));
3539: ELSE

Line 3536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_WARN'),40)||' : '||l_warning_records);

3532: -- write the summary into the out files.
3533: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));
3534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40)||' : '||l_total_records);
3535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'),40)||' : '||l_success_records);
3536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_WARN'),40)||' : '||l_warning_records);
3537: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'),40)||' : '||l_rejected_records);
3538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));
3539: ELSE
3540: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 3537: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'),40)||' : '||l_rejected_records);

3533: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));
3534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40)||' : '||l_total_records);
3535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'),40)||' : '||l_success_records);
3536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_WARN'),40)||' : '||l_warning_records);
3537: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'),40)||' : '||l_rejected_records);
3538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));
3539: ELSE
3540: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3541: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40)||' : '||l_total_records);

Line 3541: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40)||' : '||l_total_records);

3537: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'),40)||' : '||l_rejected_records);
3538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));
3539: ELSE
3540: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3541: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40)||' : '||l_total_records);
3542: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'),40)||' : '||l_success_records);
3543: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_WARN'),40)||' : '||l_warning_records);
3544: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'),40)||' : '||l_rejected_records);
3545: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 3542: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'),40)||' : '||l_success_records);

3538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));
3539: ELSE
3540: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3541: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40)||' : '||l_total_records);
3542: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'),40)||' : '||l_success_records);
3543: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_WARN'),40)||' : '||l_warning_records);
3544: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'),40)||' : '||l_rejected_records);
3545: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3546:

Line 3543: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_WARN'),40)||' : '||l_warning_records);

3539: ELSE
3540: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3541: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40)||' : '||l_total_records);
3542: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'),40)||' : '||l_success_records);
3543: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_WARN'),40)||' : '||l_warning_records);
3544: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'),40)||' : '||l_rejected_records);
3545: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3546:
3547: -- write the summary into the out files.

Line 3544: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'),40)||' : '||l_rejected_records);

3540: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3541: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40)||' : '||l_total_records);
3542: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'),40)||' : '||l_success_records);
3543: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_WARN'),40)||' : '||l_warning_records);
3544: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'),40)||' : '||l_rejected_records);
3545: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3546:
3547: -- write the summary into the out files.
3548: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));

Line 3549: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40)||' : '||l_total_records);

3545: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3546:
3547: -- write the summary into the out files.
3548: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));
3549: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40)||' : '||l_total_records);
3550: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'),40)||' : '||l_success_records);
3551: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_WARN'),40)||' : '||l_warning_records);
3552: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'),40)||' : '||l_rejected_records);
3553: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));

Line 3550: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'),40)||' : '||l_success_records);

3546:
3547: -- write the summary into the out files.
3548: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));
3549: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40)||' : '||l_total_records);
3550: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'),40)||' : '||l_success_records);
3551: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_WARN'),40)||' : '||l_warning_records);
3552: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'),40)||' : '||l_rejected_records);
3553: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));
3554: END IF;

Line 3551: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_WARN'),40)||' : '||l_warning_records);

3547: -- write the summary into the out files.
3548: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));
3549: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40)||' : '||l_total_records);
3550: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'),40)||' : '||l_success_records);
3551: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_WARN'),40)||' : '||l_warning_records);
3552: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'),40)||' : '||l_rejected_records);
3553: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));
3554: END IF;
3555: EXCEPTION WHEN OTHERS THEN

Line 3552: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'),40)||' : '||l_rejected_records);

3548: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));
3549: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40)||' : '||l_total_records);
3550: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'),40)||' : '||l_success_records);
3551: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_WARN'),40)||' : '||l_warning_records);
3552: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'),40)||' : '||l_rejected_records);
3553: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));
3554: END IF;
3555: EXCEPTION WHEN OTHERS THEN
3556: ROLLBACK;