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

Line 267: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EFC'),50) || ' : ' ||p_rfms_rec.efc);

263: fnd_message.set_name('IGF','IGF_GR_ORIG_DATA_REQD');
264: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_rfms_rec.base_id));
265: fnd_file.put_line(fnd_file.log,fnd_message.get);
266: fnd_file.new_line(fnd_file.log,1);
267: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EFC'),50) || ' : ' ||p_rfms_rec.efc);
268: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.pell_amount);
269: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','FT_PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.ft_pell_amount);
270: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TRANSACTION_NUM'),50) || ' : ' ||p_rfms_rec.transaction_num);
271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);

Line 268: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.pell_amount);

264: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_rfms_rec.base_id));
265: fnd_file.put_line(fnd_file.log,fnd_message.get);
266: fnd_file.new_line(fnd_file.log,1);
267: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EFC'),50) || ' : ' ||p_rfms_rec.efc);
268: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.pell_amount);
269: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','FT_PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.ft_pell_amount);
270: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TRANSACTION_NUM'),50) || ' : ' ||p_rfms_rec.transaction_num);
271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);
272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);

Line 269: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','FT_PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.ft_pell_amount);

265: fnd_file.put_line(fnd_file.log,fnd_message.get);
266: fnd_file.new_line(fnd_file.log,1);
267: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EFC'),50) || ' : ' ||p_rfms_rec.efc);
268: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.pell_amount);
269: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','FT_PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.ft_pell_amount);
270: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TRANSACTION_NUM'),50) || ' : ' ||p_rfms_rec.transaction_num);
271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);
272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);
273: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EST_DISB_DT1'),50) || ' : ' ||p_rfms_rec.est_disb_dt1);

Line 270: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TRANSACTION_NUM'),50) || ' : ' ||p_rfms_rec.transaction_num);

266: fnd_file.new_line(fnd_file.log,1);
267: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EFC'),50) || ' : ' ||p_rfms_rec.efc);
268: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.pell_amount);
269: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','FT_PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.ft_pell_amount);
270: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TRANSACTION_NUM'),50) || ' : ' ||p_rfms_rec.transaction_num);
271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);
272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);
273: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EST_DISB_DT1'),50) || ' : ' ||p_rfms_rec.est_disb_dt1);
274: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TOTAL_PYMT_PRDS'),50) || ' : ' ||p_rfms_rec.total_pymt_prds);

Line 271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);

267: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EFC'),50) || ' : ' ||p_rfms_rec.efc);
268: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.pell_amount);
269: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','FT_PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.ft_pell_amount);
270: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TRANSACTION_NUM'),50) || ' : ' ||p_rfms_rec.transaction_num);
271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);
272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);
273: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EST_DISB_DT1'),50) || ' : ' ||p_rfms_rec.est_disb_dt1);
274: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TOTAL_PYMT_PRDS'),50) || ' : ' ||p_rfms_rec.total_pymt_prds);
275: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_STATUS'),50) || ' : ' ||p_rfms_rec.enrollment_status);

Line 272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);

268: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.pell_amount);
269: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','FT_PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.ft_pell_amount);
270: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TRANSACTION_NUM'),50) || ' : ' ||p_rfms_rec.transaction_num);
271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);
272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);
273: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EST_DISB_DT1'),50) || ' : ' ||p_rfms_rec.est_disb_dt1);
274: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TOTAL_PYMT_PRDS'),50) || ' : ' ||p_rfms_rec.total_pymt_prds);
275: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_STATUS'),50) || ' : ' ||p_rfms_rec.enrollment_status);
276: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_DT'),50) || ' : ' ||p_rfms_rec.enrollment_dt);

Line 273: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EST_DISB_DT1'),50) || ' : ' ||p_rfms_rec.est_disb_dt1);

269: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','FT_PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.ft_pell_amount);
270: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TRANSACTION_NUM'),50) || ' : ' ||p_rfms_rec.transaction_num);
271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);
272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);
273: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EST_DISB_DT1'),50) || ' : ' ||p_rfms_rec.est_disb_dt1);
274: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TOTAL_PYMT_PRDS'),50) || ' : ' ||p_rfms_rec.total_pymt_prds);
275: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_STATUS'),50) || ' : ' ||p_rfms_rec.enrollment_status);
276: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_DT'),50) || ' : ' ||p_rfms_rec.enrollment_dt);
277: -- 'Data not sufficient to create Origination Record for Person '

Line 274: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TOTAL_PYMT_PRDS'),50) || ' : ' ||p_rfms_rec.total_pymt_prds);

270: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TRANSACTION_NUM'),50) || ' : ' ||p_rfms_rec.transaction_num);
271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);
272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);
273: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EST_DISB_DT1'),50) || ' : ' ||p_rfms_rec.est_disb_dt1);
274: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TOTAL_PYMT_PRDS'),50) || ' : ' ||p_rfms_rec.total_pymt_prds);
275: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_STATUS'),50) || ' : ' ||p_rfms_rec.enrollment_status);
276: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_DT'),50) || ' : ' ||p_rfms_rec.enrollment_dt);
277: -- 'Data not sufficient to create Origination Record for Person '
278: fnd_file.new_line(fnd_file.log,1);

Line 275: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_STATUS'),50) || ' : ' ||p_rfms_rec.enrollment_status);

271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);
272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);
273: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EST_DISB_DT1'),50) || ' : ' ||p_rfms_rec.est_disb_dt1);
274: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TOTAL_PYMT_PRDS'),50) || ' : ' ||p_rfms_rec.total_pymt_prds);
275: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_STATUS'),50) || ' : ' ||p_rfms_rec.enrollment_status);
276: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_DT'),50) || ' : ' ||p_rfms_rec.enrollment_dt);
277: -- 'Data not sufficient to create Origination Record for Person '
278: fnd_file.new_line(fnd_file.log,1);
279: ELSE

Line 276: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_DT'),50) || ' : ' ||p_rfms_rec.enrollment_dt);

272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);
273: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EST_DISB_DT1'),50) || ' : ' ||p_rfms_rec.est_disb_dt1);
274: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TOTAL_PYMT_PRDS'),50) || ' : ' ||p_rfms_rec.total_pymt_prds);
275: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_STATUS'),50) || ' : ' ||p_rfms_rec.enrollment_status);
276: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_DT'),50) || ' : ' ||p_rfms_rec.enrollment_dt);
277: -- 'Data not sufficient to create Origination Record for Person '
278: fnd_file.new_line(fnd_file.log,1);
279: ELSE
280:

Line 382: fnd_message.set_token('EN_STAT',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT', p_rfms_rec.enrollment_status));

378: -- Since we are going to write the record to file, print log message if we had been set enrollment_status.
379: IF p_enrl_status_mesgnum = 1 THEN
380: -- default to 'Others'
381: fnd_message.set_name('IGF','IGF_GR_DEFAULT_ENRL_STAT');
382: fnd_message.set_token('EN_STAT',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT', p_rfms_rec.enrollment_status));
383: fnd_file.put_line(fnd_file.log,fnd_message.get);
384: ELSIF p_enrl_status_mesgnum = 2 THEN
385: -- set to pell attendance code.
386: fnd_message.set_name('IGF','IGF_GR_SET_ENRL_STAT');

Line 387: fnd_message.set_token('EN_STAT',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT', p_rfms_rec.enrollment_status));

383: fnd_file.put_line(fnd_file.log,fnd_message.get);
384: ELSIF p_enrl_status_mesgnum = 2 THEN
385: -- set to pell attendance code.
386: fnd_message.set_name('IGF','IGF_GR_SET_ENRL_STAT');
387: fnd_message.set_token('EN_STAT',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT', p_rfms_rec.enrollment_status));
388: fnd_file.put_line(fnd_file.log,fnd_message.get);
389: END IF;
390:
391: fnd_file.put_line(fnd_file.output,UPPER(l_data));

Line 397: fnd_message.set_token('ORIG_ID',igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID') ||

393: p_originated :='Y';
394: update_orig_rec(p_rfms_rec,p_rfmb_id);
395: ELSE
396: fnd_message.set_name('IGF','IGF_GR_VERF_STAT_W');
397: fnd_message.set_token('ORIG_ID',igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID') ||
398: ' : ' || p_rfms_rec.origination_id );
399: fnd_file.put_line(fnd_file.log,fnd_message.get);
400: p_originated :='N';
401: END IF;

Line 442: l_msg_str_0 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BATCH_ID'),50) ||

438: l_msg_str_1 VARCHAR2(1000);
439:
440: BEGIN
441:
442: l_msg_str_0 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BATCH_ID'),50) ||
443: RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID'),50);
444: l_msg_str_1 := RPAD(p_batch_id,50) ||
445: RPAD(p_origination_id,50);
446:

Line 443: RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID'),50);

439:
440: BEGIN
441:
442: l_msg_str_0 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BATCH_ID'),50) ||
443: RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID'),50);
444: l_msg_str_1 := RPAD(p_batch_id,50) ||
445: RPAD(p_origination_id,50);
446:
447: fnd_file.put_line(fnd_file.log,' ');

Line 490: l_msg_str_0 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID'),50);

486: BEGIN
487:
488:
489:
490: l_msg_str_0 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID'),50);
491: l_msg_str_1 := RPAD(p_origination_id,50);
492:
493: IF l_msg_prn_1 = TRUE THEN
494: fnd_message.set_name('IGF','IGF_GR_RECORDS_UPDATED');

Line 551: l_msg_str_0 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID'),50);

547: IF NVL(TO_NUMBER(RTRIM(LTRIM(p_orig_reject_code))),0) > 0 THEN
548: fnd_message.set_name('IGF','IGF_GR_REC_CONTAIN_EDIT_CODES');
549: fnd_file.put_line(fnd_file.log,fnd_message.get);
550:
551: l_msg_str_0 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID'),50);
552: l_msg_str_1 := RPAD(p_origination_id,50);
553: l_msg_str_2 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIG_REJECT_CODE'),50);
554:
555: fnd_file.put_line(fnd_file.log,' ');

Line 553: l_msg_str_2 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIG_REJECT_CODE'),50);

549: fnd_file.put_line(fnd_file.log,fnd_message.get);
550:
551: l_msg_str_0 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID'),50);
552: l_msg_str_1 := RPAD(p_origination_id,50);
553: l_msg_str_2 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIG_REJECT_CODE'),50);
554:
555: fnd_file.put_line(fnd_file.log,' ');
556: fnd_file.put_line(fnd_file.log,l_msg_str_0);
557: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));

Line 761: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BATCH_ID'),10)||' :'

757: p_ci_sequence_number
758: );
759:
760: fnd_file.new_line(fnd_file.log,1);
761: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BATCH_ID'),10)||' :'
762: ||' '|| l_batch_id);
763:
764: fnd_file.new_line(fnd_file.log,1);
765: fnd_message.set_name('IGF','IGF_GR_ORIG_RECORDS');

Line 1164: SYSTEM_STATUS := igf_aw_gen.lookup_desc('IGF_GR_ORIG_STATUS',get_pell_rec.orig_action_code);

1160: IF get_pell_rec.orig_action_code <> 'S' THEN
1161:
1162: fnd_message.set_name('IGF','IGF_GR_ORIG_NOT_IN_SENT');
1163: fnd_message.set_token('ORIG_ID',LTRIM(RTRIM(SUBSTR(rec_data.record_data,1,23))));
1164: SYSTEM_STATUS := igf_aw_gen.lookup_desc('IGF_GR_ORIG_STATUS',get_pell_rec.orig_action_code);
1165: fnd_message.set_token('SYS_STATUS',SYSTEM_STATUS);
1166: fnd_file.put_line(fnd_file.log,fnd_message.get);
1167: fnd_file.new_line(fnd_file.log,1);
1168: RAISE igf_gr_gen.skip_this_record;

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

1415: --
1416: -- Know limitations, enhancements or remarks
1417: -- Change History
1418: -- Who When What
1419: -- tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
1420: -- ugummall 08-Jan-2003 Bug 3318202. Changed the order of parameters and removed
1421: -- the parameter p_org_id.
1422: -- ugummall 03-DEC-2003 Bug 3252832. FA 131 - COD Updates
1423: -- 1. Added two parameters to this procedure namely

Line 1462: igf_aw_gen.set_org_id(NULL);

1458: mutually_exclusive BOOLEAN DEFAULT TRUE;
1459: l_cod_year_flag BOOLEAN;
1460:
1461: BEGIN
1462: igf_aw_gen.set_org_id(NULL);
1463: retcode := 0;
1464: ln_base_id := base_id;
1465: l_ci_cal_type := LTRIM(RTRIM(SUBSTR(award_year,1,10)));
1466: l_ci_sequence_number := NVL(TO_NUMBER(SUBSTR(award_year,11)),0);

Line 1484: l_msg_str_1 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','AWARD_YEAR'),30) ||

1480:
1481: END IF;
1482:
1483: -- show parameter 1 - award year
1484: l_msg_str_1 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','AWARD_YEAR'),30) ||
1485: RPAD(igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number),20);
1486: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1487:
1488: -- show parameter 2 - report pell id

Line 1489: l_msg_str_3 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS', 'REPORT_PELL'),30) || p_reporting_pell;

1485: RPAD(igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number),20);
1486: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1487:
1488: -- show parameter 2 - report pell id
1489: l_msg_str_3 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS', 'REPORT_PELL'),30) || p_reporting_pell;
1490: fnd_file.put_line(fnd_file.log,l_msg_str_3);
1491:
1492: -- show parameter 3 - attend pell id
1493: IF (p_attending_pell IS NOT NULL) THEN

Line 1494: l_msg_str_4 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS', 'ATTEND_PELL'),30) || p_attending_pell;

1490: fnd_file.put_line(fnd_file.log,l_msg_str_3);
1491:
1492: -- show parameter 3 - attend pell id
1493: IF (p_attending_pell IS NOT NULL) THEN
1494: l_msg_str_4 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS', 'ATTEND_PELL'),30) || p_attending_pell;
1495: fnd_file.put_line(fnd_file.log,l_msg_str_4);
1496: END IF;
1497:
1498: -- show parameter 4 - base id

Line 1500: l_msg_str_2 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BASE_ID'),30) ||

1496: END IF;
1497:
1498: -- show parameter 4 - base id
1499: IF (base_id IS NOT NULL) THEN
1500: l_msg_str_2 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BASE_ID'),30) ||
1501: RPAD(igf_gr_gen.get_per_num(ln_base_id),20);
1502: fnd_file.put_line(fnd_file.log,l_msg_str_2);
1503: END IF;
1504:

Line 1510: l_msg_str_5 := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS', 'PERSON_ID_GROUP'),30) || rec_person_group.group_name;

1506: IF (p_persid_grp IS NOT NULL) THEN
1507: OPEN cur_person_group(p_persid_grp);
1508: FETCH cur_person_group INTO rec_person_group;
1509: CLOSE cur_person_group;
1510: l_msg_str_5 := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS', 'PERSON_ID_GROUP'),30) || rec_person_group.group_name;
1511: fnd_file.put_line(fnd_file.log,l_msg_str_5);
1512: END IF;
1513:
1514: -- show parameter 6 - Orgination Run Mode

Line 1515: l_msg_str_6 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS', 'PELL_ORIG_RUN_MODE'),30) || p_orig_run_mode;

1511: fnd_file.put_line(fnd_file.log,l_msg_str_5);
1512: END IF;
1513:
1514: -- show parameter 6 - Orgination Run Mode
1515: l_msg_str_6 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS', 'PELL_ORIG_RUN_MODE'),30) || p_orig_run_mode;
1516: fnd_file.put_line(fnd_file.log,l_msg_str_6);
1517:
1518: -- FA 126. base_id and attending pell are mutually exclusive.
1519: IF (base_id IS NOT NULL AND p_attending_pell IS NOT NULL) THEN

Line 1542: g_ver_num := igf_aw_gen.get_ver_num(l_ci_cal_type,l_ci_sequence_number,'P');

1538: RAISE param_error;
1539: END IF;
1540:
1541: -- Get the Flat File Version and then Proceed
1542: g_ver_num := igf_aw_gen.get_ver_num(l_ci_cal_type,l_ci_sequence_number,'P');
1543:
1544: -- Get the Cycle Year
1545: l_cy_yr := igf_gr_gen.get_cycle_year(l_ci_cal_type,l_ci_sequence_number);
1546:

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

1611: -- Change History
1612: -- Who When What
1613: --
1614: -- (reverse chronological order - newest change first)
1615: --tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
1616: ----------------------------------------------------------------------
1617:
1618: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
1619: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;

Line 1622: igf_aw_gen.set_org_id(NULL);

1618: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
1619: l_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;
1620:
1621: BEGIN
1622: igf_aw_gen.set_org_id(NULL);
1623: retcode := 0;
1624: l_ci_cal_type := LTRIM(RTRIM(SUBSTR(p_awd_yr,1,10)));
1625: l_ci_sequence_number := NVL(TO_NUMBER(SUBSTR(p_awd_yr,11)),0);
1626:

Line 1647: g_ver_num := igf_aw_gen.get_ver_num(l_ci_cal_type,l_ci_sequence_number,'P');

1643:
1644: --
1645: -- Get the Flat File Version and then Proceed
1646: --
1647: g_ver_num := igf_aw_gen.get_ver_num(l_ci_cal_type,l_ci_sequence_number,'P');
1648: g_alt_code := igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number);
1649: --
1650: -- Get the Cycle Year
1651: --