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_ANTICIPATED_DATA dependencies on FND_LOG

Line 150: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

146: IF p_interface.org_unit_cd IS NOT NULL THEN
147: OPEN c_org_unit(p_interface.org_unit_cd );
148: FETCH c_org_unit INTO l_org_unit;
149: IF c_org_unit%NOTFOUND THEN
150: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
151: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_org_unit%NOTFOUND');
152: END IF;
153:
154: lv_set_ant_data := 'N';

Line 151: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_org_unit%NOTFOUND');

147: OPEN c_org_unit(p_interface.org_unit_cd );
148: FETCH c_org_unit INTO l_org_unit;
149: IF c_org_unit%NOTFOUND THEN
150: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
151: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_org_unit%NOTFOUND');
152: END IF;
153:
154: lv_set_ant_data := 'N';
155: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');

Line 167: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

163: IF p_interface.program_type IS NOT NULL THEN
164: OPEN c_prog_type(p_interface.program_type);
165: FETCH c_prog_type INTO l_prog_type;
166: IF c_prog_type%NOTFOUND THEN
167: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
168: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_prog_type%NOTFOUND');
169: END IF;
170:
171: lv_set_ant_data := 'N';

Line 168: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_prog_type%NOTFOUND');

164: OPEN c_prog_type(p_interface.program_type);
165: FETCH c_prog_type INTO l_prog_type;
166: IF c_prog_type%NOTFOUND THEN
167: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
168: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_prog_type%NOTFOUND');
169: END IF;
170:
171: lv_set_ant_data := 'N';
172: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');

Line 184: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

180: IF p_interface.program_location_cd IS NOT NULL THEN
181: OPEN c_prog_loc(p_interface.program_location_cd);
182: FETCH c_prog_loc INTO l_prog_loc;
183: IF c_prog_loc%NOTFOUND THEN
184: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
185: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_prog_loc%NOTFOUND');
186: END IF;
187:
188: lv_set_ant_data := 'N';

Line 185: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_prog_loc%NOTFOUND');

181: OPEN c_prog_loc(p_interface.program_location_cd);
182: FETCH c_prog_loc INTO l_prog_loc;
183: IF c_prog_loc%NOTFOUND THEN
184: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
185: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_prog_loc%NOTFOUND');
186: END IF;
187:
188: lv_set_ant_data := 'N';
189: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');

Line 201: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

197: IF p_interface.program_cd IS NOT NULL THEN
198: OPEN c_prog_cd(p_interface.program_cd);
199: FETCH c_prog_cd INTO l_prog_cd;
200: IF c_prog_cd%NOTFOUND THEN
201: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
202: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_prog_cd%NOTFOUND');
203: END IF;
204:
205: lv_set_ant_data := 'N';

Line 202: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_prog_cd%NOTFOUND');

198: OPEN c_prog_cd(p_interface.program_cd);
199: FETCH c_prog_cd INTO l_prog_cd;
200: IF c_prog_cd%NOTFOUND THEN
201: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
202: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_prog_cd%NOTFOUND');
203: END IF;
204:
205: lv_set_ant_data := 'N';
206: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');

Line 218: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

214: IF p_interface.class_standing IS NOT NULL THEN
215: OPEN c_class_stnd(p_interface.class_standing);
216: FETCH c_class_stnd INTO l_class_stnd;
217: IF c_class_stnd%NOTFOUND THEN
218: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_class_stnd%NOTFOUND');
220: END IF;
221:
222: lv_set_ant_data := 'N';

Line 219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_class_stnd%NOTFOUND');

215: OPEN c_class_stnd(p_interface.class_standing);
216: FETCH c_class_stnd INTO l_class_stnd;
217: IF c_class_stnd%NOTFOUND THEN
218: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_class_stnd%NOTFOUND');
220: END IF;
221:
222: lv_set_ant_data := 'N';
223: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');

Line 235: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

231: IF p_interface.residency_status_code IS NOT NULL THEN
232: OPEN c_res_status(p_interface.residency_status_code,'PE_RES_STATUS');
233: FETCH c_res_status INTO l_res_status;
234: IF c_res_status%NOTFOUND THEN
235: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
236: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_res_status%NOTFOUND');
237: END IF;
238:
239: lv_set_ant_data := 'N';

Line 236: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_res_status%NOTFOUND');

232: OPEN c_res_status(p_interface.residency_status_code,'PE_RES_STATUS');
233: FETCH c_res_status INTO l_res_status;
234: IF c_res_status%NOTFOUND THEN
235: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
236: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_res_status%NOTFOUND');
237: END IF;
238:
239: lv_set_ant_data := 'N';
240: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');

Line 252: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

248: IF p_interface.housing_status_code IS NOT NULL THEN
249: OPEN c_res_status(p_interface.housing_status_code,'PE_TEA_PER_RES');
250: FETCH c_res_status INTO l_house_status;
251: IF c_res_status%NOTFOUND THEN
252: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
253: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_res_status%NOTFOUND');
254: END IF;
255:
256: lv_set_ant_data := 'N';

Line 253: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_res_status%NOTFOUND');

249: OPEN c_res_status(p_interface.housing_status_code,'PE_TEA_PER_RES');
250: FETCH c_res_status INTO l_house_status;
251: IF c_res_status%NOTFOUND THEN
252: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
253: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_res_status%NOTFOUND');
254: END IF;
255:
256: lv_set_ant_data := 'N';
257: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');

Line 269: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

265: IF p_interface.attendance_type IS NOT NULL THEN
266: OPEN c_atten_type(p_interface.attendance_type);
267: FETCH c_atten_type INTO l_atten_type;
268: IF c_atten_type%NOTFOUND THEN
269: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
270: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_atten_type%NOTFOUND');
271: END IF;
272:
273: lv_set_ant_data := 'N';

Line 270: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_atten_type%NOTFOUND');

266: OPEN c_atten_type(p_interface.attendance_type);
267: FETCH c_atten_type INTO l_atten_type;
268: IF c_atten_type%NOTFOUND THEN
269: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
270: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_atten_type%NOTFOUND');
271: END IF;
272:
273: lv_set_ant_data := 'N';
274: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');

Line 286: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

282: IF p_interface.attendance_mode IS NOT NULL THEN
283: OPEN c_atten_mode(p_interface.attendance_mode);
284: FETCH c_atten_mode INTO l_atten_mode;
285: IF c_atten_mode%NOTFOUND THEN
286: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
287: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_atten_mode%NOTFOUND');
288: END IF;
289:
290: lv_set_ant_data := 'N';

Line 287: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_atten_mode%NOTFOUND');

283: OPEN c_atten_mode(p_interface.attendance_mode);
284: FETCH c_atten_mode INTO l_atten_mode;
285: IF c_atten_mode%NOTFOUND THEN
286: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
287: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','c_atten_mode%NOTFOUND');
288: END IF;
289:
290: lv_set_ant_data := 'N';
291: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');

Line 301: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

297:
298: --validate months enrolled number
299: IF p_interface.months_enrolled_num IS NOT NULL THEN
300: IF p_interface.months_enrolled_num NOT BETWEEN 1 AND 12 THEN
301: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
302: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','p_interface.months_enrolled_num NOT BETWEEN 1 AND 12');
303: END IF;
304:
305: lv_set_ant_data := 'N';

Line 302: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','p_interface.months_enrolled_num NOT BETWEEN 1 AND 12');

298: --validate months enrolled number
299: IF p_interface.months_enrolled_num IS NOT NULL THEN
300: IF p_interface.months_enrolled_num NOT BETWEEN 1 AND 12 THEN
301: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
302: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','p_interface.months_enrolled_num NOT BETWEEN 1 AND 12');
303: END IF;
304:
305: lv_set_ant_data := 'N';
306: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');

Line 315: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

311:
312: --validate credit point number
313: IF p_interface.credit_points_num IS NOT NULL THEN
314: IF p_interface.credit_points_num < 0 THEN
315: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
316: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','p_interface.credit_points_num < 0');
317: END IF;
318:
319: lv_set_ant_data := 'N';

Line 316: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','p_interface.credit_points_num < 0');

312: --validate credit point number
313: IF p_interface.credit_points_num IS NOT NULL THEN
314: IF p_interface.credit_points_num < 0 THEN
315: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
316: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','p_interface.credit_points_num < 0');
317: END IF;
318:
319: lv_set_ant_data := 'N';
320: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');

Line 366: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

362: OPEN c_ant_data(p_base_id,p_ld_cal_type,p_ld_sequence_number);
363: FETCH c_ant_data INTO l_ant_data;
364: CLOSE c_ant_data;
365:
366: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
367: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','calling igf_ap_fa_ant_data_pkg.update_row');
368: END IF;
369:
370:

Line 367: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','calling igf_ap_fa_ant_data_pkg.update_row');

363: FETCH c_ant_data INTO l_ant_data;
364: CLOSE c_ant_data;
365:
366: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
367: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','calling igf_ap_fa_ant_data_pkg.update_row');
368: END IF;
369:
370:
371: igf_ap_fa_ant_data_pkg.update_row (

Line 396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

392:
393: ELSIF p_interface.import_record_type = 'I' THEN
394: lv_rowid := NULL;
395:
396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','calling igf_ap_fa_ant_data_pkg.insert_row');
398: END IF;
399:
400: igf_ap_fa_ant_data_pkg.insert_row (

Line 397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','calling igf_ap_fa_ant_data_pkg.insert_row');

393: ELSIF p_interface.import_record_type = 'I' THEN
394: lv_rowid := NULL;
395:
396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','calling igf_ap_fa_ant_data_pkg.insert_row');
398: END IF;
399:
400: igf_ap_fa_ant_data_pkg.insert_row (
401: x_mode => 'R',

Line 426: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

422:
423: END IF;
424:
425: IF p_delete_flag = 'Y' THEN
426: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','deleting from igf_aw_anticpt_ints');
428: END IF;
429:
430: DELETE FROM igf_aw_anticpt_ints

Line 427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','deleting from igf_aw_anticpt_ints');

423: END IF;
424:
425: IF p_delete_flag = 'Y' THEN
426: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','deleting from igf_aw_anticpt_ints');
428: END IF;
429:
430: DELETE FROM igf_aw_anticpt_ints
431: WHERE batch_num = p_interface.batch_num

Line 437: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

433: AND ld_alternate_code = p_interface.ld_alternate_code
434: AND person_number = p_interface.person_number;
435:
436: ELSE
437: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
438: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','updating in igf_aw_anticpt_ints');
439: END IF;
440:
441: UPDATE igf_aw_anticpt_ints

Line 438: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','updating in igf_aw_anticpt_ints');

434: AND person_number = p_interface.person_number;
435:
436: ELSE
437: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
438: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','updating in igf_aw_anticpt_ints');
439: END IF;
440:
441: UPDATE igf_aw_anticpt_ints
442: SET IMPORT_STATUS_TYPE = 'I'

Line 451: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

447:
448: END IF;
449:
450: ELSE
451: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
452: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','No data Imported');
453: END IF;
454:
455: fnd_message.set_name('IGS','IGS_EN_NO_DATA_IMP');

Line 452: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','No data Imported');

448: END IF;
449:
450: ELSE
451: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
452: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','No data Imported');
453: END IF;
454:
455: fnd_message.set_name('IGS','IGS_EN_NO_DATA_IMP');
456: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);

Line 458: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

454:
455: fnd_message.set_name('IGS','IGS_EN_NO_DATA_IMP');
456: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
457:
458: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
459: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','updating in igf_aw_anticpt_ints');
460: END IF;
461:
462: UPDATE igf_aw_anticpt_ints

Line 459: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','updating in igf_aw_anticpt_ints');

455: fnd_message.set_name('IGS','IGS_EN_NO_DATA_IMP');
456: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
457:
458: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
459: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','updating in igf_aw_anticpt_ints');
460: END IF;
461:
462: UPDATE igf_aw_anticpt_ints
463: SET IMPORT_STATUS_TYPE = 'E'

Line 475: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

471: EXCEPTION
472: WHEN OTHERS THEN
473: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
474: fnd_message.set_token('NAME','IGF_AW_ANTICIPATED_DATA.PROCESS_ANTI_DATA :' || SQLERRM);
475: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
476: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_anticipated_data.process_anti_data.exception','sql error:'||SQLERRM);
477: END IF;
478: igs_ge_msg_stack.conc_exception_hndl;
479: app_exception.raise_exception;

Line 476: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_anticipated_data.process_anti_data.exception','sql error:'||SQLERRM);

472: WHEN OTHERS THEN
473: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
474: fnd_message.set_token('NAME','IGF_AW_ANTICIPATED_DATA.PROCESS_ANTI_DATA :' || SQLERRM);
475: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
476: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_anticipated_data.process_anti_data.exception','sql error:'||SQLERRM);
477: END IF;
478: igs_ge_msg_stack.conc_exception_hndl;
479: app_exception.raise_exception;
480:

Line 595: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

591: ln_ci_sequence_number := TO_NUMBER(SUBSTR(p_award_year,11));
592: lv_alternate_code := igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number);
593: lv_person_number := '0';
594:
595: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
596: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','p_award_year:'||p_award_year);
597: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','p_batch_id:'||p_batch_id);
598: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','p_del_ind:'||p_del_ind);
599: END IF;

Line 596: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','p_award_year:'||p_award_year);

592: lv_alternate_code := igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number);
593: lv_person_number := '0';
594:
595: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
596: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','p_award_year:'||p_award_year);
597: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','p_batch_id:'||p_batch_id);
598: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','p_del_ind:'||p_del_ind);
599: END IF;
600:

Line 597: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','p_batch_id:'||p_batch_id);

593: lv_person_number := '0';
594:
595: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
596: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','p_award_year:'||p_award_year);
597: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','p_batch_id:'||p_batch_id);
598: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','p_del_ind:'||p_del_ind);
599: END IF;
600:
601: fnd_file.new_line(fnd_file.log,1);

Line 598: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','p_del_ind:'||p_del_ind);

594:
595: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
596: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','p_award_year:'||p_award_year);
597: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','p_batch_id:'||p_batch_id);
598: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','p_del_ind:'||p_del_ind);
599: END IF;
600:
601: fnd_file.new_line(fnd_file.log,1);
602:

Line 623: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

619: FETCH c_chk_batch INTO l_chk_batch;
620: CLOSE c_chk_batch;
621:
622: IF l_chk_batch.batch_num IS NULL THEN
623: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
624: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','l_chk_batch.batch_num IS NULL');
625: END IF;
626:
627: fnd_message.set_name('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');

Line 624: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','l_chk_batch.batch_num IS NULL');

620: CLOSE c_chk_batch;
621:
622: IF l_chk_batch.batch_num IS NULL THEN
623: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
624: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','l_chk_batch.batch_num IS NULL');
625: END IF;
626:
627: fnd_message.set_name('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');
628: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 640: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

636: FETCH c_chk_interface INTO l_chk_interface;
637: CLOSE c_chk_interface;
638:
639: IF l_chk_interface.val IS NULL THEN
640: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
641: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','l_chk_interface.val IS NULL');
642: END IF;
643:
644: fnd_message.set_name('IGS','IGS_FI_NO_RECORD_AVAILABLE');

Line 641: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','l_chk_interface.val IS NULL');

637: CLOSE c_chk_interface;
638:
639: IF l_chk_interface.val IS NULL THEN
640: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
641: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','l_chk_interface.val IS NULL');
642: END IF;
643:
644: fnd_message.set_name('IGS','IGS_FI_NO_RECORD_AVAILABLE');
645: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 653: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

649:
650: --Validate the person and INSERT/UPDATE based on the record type
651: FOR l_interface IN c_interface(p_batch_id,lv_alternate_code)
652: LOOP
653: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
654: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','validating person number :'||l_interface.person_number);
655: END IF;
656:
657: fnd_file.new_line(fnd_file.log,1);

Line 654: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','validating person number :'||l_interface.person_number);

650: --Validate the person and INSERT/UPDATE based on the record type
651: FOR l_interface IN c_interface(p_batch_id,lv_alternate_code)
652: LOOP
653: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
654: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','validating person number :'||l_interface.person_number);
655: END IF;
656:
657: fnd_file.new_line(fnd_file.log,1);
658:

Line 671: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

667:
668: lv_person_number := l_interface.person_number;
669:
670: IF ln_person_id IS NULL THEN
671: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
672: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','ln_person_id IS NULL');
673: END IF;
674:
675: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');

Line 672: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','ln_person_id IS NULL');

668: lv_person_number := l_interface.person_number;
669:
670: IF ln_person_id IS NULL THEN
671: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
672: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','ln_person_id IS NULL');
673: END IF;
674:
675: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
676: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);

Line 679: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

675: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
676: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
677: ELSE
678: IF ln_base_id IS NULL THEN
679: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
680: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','ln_base_id IS NULL');
681: END IF;
682:
683: fnd_message.set_name('IGF','IGF_AP_FABASE_NOT_FOUND');

Line 680: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','ln_base_id IS NULL');

676: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
677: ELSE
678: IF ln_base_id IS NULL THEN
679: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
680: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','ln_base_id IS NULL');
681: END IF;
682:
683: fnd_message.set_name('IGF','IGF_AP_FABASE_NOT_FOUND');
684: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);

Line 702: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

698: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
699:
700:
701: IF l_get_cal_typ_seq_num.ld_cal_type IS NULL OR l_get_cal_typ_seq_num.ld_sequence_number IS NULL THEN
702: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
703: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','l_get_cal_typ_seq_num IS NULL');
704: END IF;
705:
706: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');

Line 703: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','l_get_cal_typ_seq_num IS NULL');

699:
700:
701: IF l_get_cal_typ_seq_num.ld_cal_type IS NULL OR l_get_cal_typ_seq_num.ld_sequence_number IS NULL THEN
702: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
703: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','l_get_cal_typ_seq_num IS NULL');
704: END IF;
705:
706: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
707: fnd_message.set_token('FIELD','LD_ALTERNATE_CODE'||': '||l_interface.ld_alternate_code);

Line 710: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

706: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
707: fnd_message.set_token('FIELD','LD_ALTERNATE_CODE'||': '||l_interface.ld_alternate_code);
708: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
709:
710: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
711: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');
712: END IF;
713:
714: UPDATE igf_aw_anticpt_ints

Line 711: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');

707: fnd_message.set_token('FIELD','LD_ALTERNATE_CODE'||': '||l_interface.ld_alternate_code);
708: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
709:
710: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
711: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');
712: END IF;
713:
714: UPDATE igf_aw_anticpt_ints
715: SET IMPORT_STATUS_TYPE = 'E'

Line 735: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

731: CLOSE c_ant_data;
732:
733: IF l_interface.import_record_type = 'U' THEN
734: IF l_ant_data.base_id IS NULL THEN
735: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
736: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','No anticipated data for record type=U');
737: END IF;
738:
739: fnd_message.set_name('IGF','IGF_AW_IMP_ANT_AVAL');

Line 736: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','No anticipated data for record type=U');

732:
733: IF l_interface.import_record_type = 'U' THEN
734: IF l_ant_data.base_id IS NULL THEN
735: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
736: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','No anticipated data for record type=U');
737: END IF;
738:
739: fnd_message.set_name('IGF','IGF_AW_IMP_ANT_AVAL');
740: fnd_message.set_token('REC_TYPE',l_interface.import_record_type);

Line 743: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

739: fnd_message.set_name('IGF','IGF_AW_IMP_ANT_AVAL');
740: fnd_message.set_token('REC_TYPE',l_interface.import_record_type);
741: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
742:
743: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
744: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');
745: END IF;
746:
747: UPDATE igf_aw_anticpt_ints

Line 744: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');

740: fnd_message.set_token('REC_TYPE',l_interface.import_record_type);
741: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
742:
743: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
744: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');
745: END IF;
746:
747: UPDATE igf_aw_anticpt_ints
748: SET IMPORT_STATUS_TYPE = 'E'

Line 755: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

751: AND ld_alternate_code = l_interface.ld_alternate_code
752: AND person_number = l_interface.person_number;
753:
754: ELSE
755: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
756: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','calling process_anti_data');
757: END IF;
758:
759: process_anti_data(ln_base_id,lv_ld_cal_type,ln_ld_sequence_number,l_interface,p_del_ind);

Line 756: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','calling process_anti_data');

752: AND person_number = l_interface.person_number;
753:
754: ELSE
755: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
756: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','calling process_anti_data');
757: END IF;
758:
759: process_anti_data(ln_base_id,lv_ld_cal_type,ln_ld_sequence_number,l_interface,p_del_ind);
760: END IF;

Line 764: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

760: END IF;
761:
762: ELSIF l_interface.import_record_type = 'I' THEN
763: IF l_ant_data.base_id IS NOT NULL THEN
764: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
765: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','anticipated data available for record type=I');
766: END IF;
767:
768: fnd_message.set_name('IGF','IGF_AW_IMP_ANT_NOT_AVAL');

Line 765: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','anticipated data available for record type=I');

761:
762: ELSIF l_interface.import_record_type = 'I' THEN
763: IF l_ant_data.base_id IS NOT NULL THEN
764: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
765: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','anticipated data available for record type=I');
766: END IF;
767:
768: fnd_message.set_name('IGF','IGF_AW_IMP_ANT_NOT_AVAL');
769: fnd_message.set_token('REC_TYPE',l_interface.import_record_type);

Line 772: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

768: fnd_message.set_name('IGF','IGF_AW_IMP_ANT_NOT_AVAL');
769: fnd_message.set_token('REC_TYPE',l_interface.import_record_type);
770: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
771:
772: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
773: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');
774: END IF;
775:
776: UPDATE igf_aw_anticpt_ints

Line 773: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');

769: fnd_message.set_token('REC_TYPE',l_interface.import_record_type);
770: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
771:
772: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
773: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');
774: END IF;
775:
776: UPDATE igf_aw_anticpt_ints
777: SET IMPORT_STATUS_TYPE = 'E'

Line 784: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

780: AND ld_alternate_code = l_interface.ld_alternate_code
781: AND person_number = l_interface.person_number;
782:
783: ELSE
784: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
785: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','calling process_anti_data');
786: END IF;
787:
788: process_anti_data(ln_base_id,lv_ld_cal_type,ln_ld_sequence_number,l_interface,p_del_ind);

Line 785: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','calling process_anti_data');

781: AND person_number = l_interface.person_number;
782:
783: ELSE
784: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
785: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','calling process_anti_data');
786: END IF;
787:
788: process_anti_data(ln_base_id,lv_ld_cal_type,ln_ld_sequence_number,l_interface,p_del_ind);
789: END IF;