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_DISB_ORIG dependencies on IGF_GR_RFMS_DISB

Line 1: PACKAGE BODY igf_gr_rfms_disb_orig AS

1: PACKAGE BODY igf_gr_rfms_disb_orig AS
2: /* $Header: IGFGR03B.pls 120.4 2006/02/08 23:46:42 ridas ship $ */
3:
4: ------------------------------------------------------------------------
5: -- bvisvana 07-July-2005 Bug # 4008991 - IGF_GR_BATCH_DOES_NOT_EXIST replaced by IGF_SL_GR_BATCH_DOES_NO_EXIST

Line 101: igf_gr_rfms_disb rfmd,

97: rfms.rep_pell_id,
98: rfms.attending_campus_id,
99: rfms.pell_amount
100: FROM igf_gr_rfms rfms ,
101: igf_gr_rfms_disb rfmd,
102: igf_gr_pell_setup setup
103: WHERE rfms.base_id = NVL(l_base_id,rfms.base_id)
104: AND rfms.ci_cal_type = l_ci_cal_type
105: AND rfms.ci_sequence_number = l_ci_sequence_number

Line 154: igf_gr_rfms_disb_pkg.update_row (

150: ------------------------------------------------------------------------------
151:
152: BEGIN
153:
154: igf_gr_rfms_disb_pkg.update_row (
155: x_rowid => p_rec_disb_orig.row_id,
156: x_rfmd_id => p_rec_disb_orig.rfmd_id ,
157: x_origination_id => p_rec_disb_orig.origination_id,
158: x_disb_ref_num => p_rec_disb_orig.disb_ref_num,

Line 179: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.UPD_RFMS_DISB');

175:
176: EXCEPTION
177: WHEN OTHERS THEN
178: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
179: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.UPD_RFMS_DISB');
180: igs_ge_msg_stack.add;
181: app_exception.raise_exception;
182: END upd_rfms_disb;
183:

Line 306: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.PREPARE_DATA');

302: RAISE;
303:
304: WHEN OTHERS THEN
305: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
306: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.PREPARE_DATA');
307: igs_ge_msg_stack.add;
308: app_exception.raise_exception;
309:
310: END prepare_data;

Line 357: PROCEDURE out_message( p_origination_id igf_gr_rfms_disb.origination_id%TYPE,

353: igs_ge_msg_stack.add;
354: app_exception.raise_exception;
355: END log_message;
356:
357: PROCEDURE out_message( p_origination_id igf_gr_rfms_disb.origination_id%TYPE,
358: p_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE)
359: IS
360: ------------------------------------------------------------------------------
361: --

Line 358: p_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE)

354: app_exception.raise_exception;
355: END log_message;
356:
357: PROCEDURE out_message( p_origination_id igf_gr_rfms_disb.origination_id%TYPE,
358: p_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE)
359: IS
360: ------------------------------------------------------------------------------
361: --
362: -- Created By : sjadhav

Line 406: PROCEDURE log_rej_message(p_origination_id igf_gr_rfms_disb.origination_id%TYPE,

402: app_exception.raise_exception;
403: END out_message;
404:
405:
406: PROCEDURE log_rej_message(p_origination_id igf_gr_rfms_disb.origination_id%TYPE,
407: p_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE,
408: p_edit_code igf_gr_rfms_disb.edit_code%TYPE)
409: IS
410: ------------------------------------------------------------------------------

Line 407: p_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE,

403: END out_message;
404:
405:
406: PROCEDURE log_rej_message(p_origination_id igf_gr_rfms_disb.origination_id%TYPE,
407: p_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE,
408: p_edit_code igf_gr_rfms_disb.edit_code%TYPE)
409: IS
410: ------------------------------------------------------------------------------
411: --

Line 408: p_edit_code igf_gr_rfms_disb.edit_code%TYPE)

404:
405:
406: PROCEDURE log_rej_message(p_origination_id igf_gr_rfms_disb.origination_id%TYPE,
407: p_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE,
408: p_edit_code igf_gr_rfms_disb.edit_code%TYPE)
409: IS
410: ------------------------------------------------------------------------------
411: --
412: -- Created By : sjadhav

Line 573: CURSOR cur_disb_amt_tot(cp_origination_id igf_gr_rfms_disb.origination_id%TYPE) IS

569: AND att.attending_pell_cd = cp_attending_pell;
570: l_attending_pell_exists cur_attending_pell%ROWTYPE;
571:
572: -- To get sum of disbursement amounts.
573: CURSOR cur_disb_amt_tot(cp_origination_id igf_gr_rfms_disb.origination_id%TYPE) IS
574: SELECT SUM(disb_amt) disb_amt_tot
575: FROM igf_gr_rfms_disb
576: WHERE origination_id = cp_origination_id;
577: rec_disb_amt_tot cur_disb_amt_tot%ROWTYPE;

Line 575: FROM igf_gr_rfms_disb

571:
572: -- To get sum of disbursement amounts.
573: CURSOR cur_disb_amt_tot(cp_origination_id igf_gr_rfms_disb.origination_id%TYPE) IS
574: SELECT SUM(disb_amt) disb_amt_tot
575: FROM igf_gr_rfms_disb
576: WHERE origination_id = cp_origination_id;
577: rec_disb_amt_tot cur_disb_amt_tot%ROWTYPE;
578:
579: BEGIN

Line 582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_cal_type:'||p_ci_cal_type);

578:
579: BEGIN
580:
581: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_cal_type:'||p_ci_cal_type);
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_sequence_number:'||p_ci_sequence_number);
584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_base_id:'||p_base_id);
585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_reporting_pell:'||p_reporting_pell);
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_attending_pell:'||p_attending_pell);

Line 583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_sequence_number:'||p_ci_sequence_number);

579: BEGIN
580:
581: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_cal_type:'||p_ci_cal_type);
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_sequence_number:'||p_ci_sequence_number);
584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_base_id:'||p_base_id);
585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_reporting_pell:'||p_reporting_pell);
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_attending_pell:'||p_attending_pell);
587: END IF;

Line 584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_base_id:'||p_base_id);

580:
581: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_cal_type:'||p_ci_cal_type);
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_sequence_number:'||p_ci_sequence_number);
584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_base_id:'||p_base_id);
585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_reporting_pell:'||p_reporting_pell);
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_attending_pell:'||p_attending_pell);
587: END IF;
588:

Line 585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_reporting_pell:'||p_reporting_pell);

581: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_cal_type:'||p_ci_cal_type);
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_sequence_number:'||p_ci_sequence_number);
584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_base_id:'||p_base_id);
585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_reporting_pell:'||p_reporting_pell);
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_attending_pell:'||p_attending_pell);
587: END IF;
588:
589: -- FA 126. Passed extra parameters p_reporting_pell and p_attending_pell to this cursor.

Line 586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_attending_pell:'||p_attending_pell);

582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_cal_type:'||p_ci_cal_type);
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_ci_sequence_number:'||p_ci_sequence_number);
584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_base_id:'||p_base_id);
585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_reporting_pell:'||p_reporting_pell);
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.rfms_disb_orig.debug','p_attending_pell:'||p_attending_pell);
587: END IF;
588:
589: -- FA 126. Passed extra parameters p_reporting_pell and p_attending_pell to this cursor.
590: OPEN cur_rfms_disb(p_base_id,p_ci_cal_type,p_ci_sequence_number, p_reporting_pell, p_attending_pell);

Line 762: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.RFMS_DISB_ORIG');

758: WHEN next_record THEN
759: RAISE;
760: WHEN OTHERS THEN
761: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
762: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.RFMS_DISB_ORIG');
763: igs_ge_msg_stack.add;
764: app_exception.raise_exception;
765: END rfms_disb_orig;
766:

Line 869: CURSOR cur_disb_orig(l_origination_id igf_gr_rfms_disb.origination_id%TYPE,

865: WHERE
866: gldr_id BETWEEN 2 AND (l_last_gldr_id - 1)
867: AND file_type = 'GR_RFMS_DISB_ORIG';
868:
869: CURSOR cur_disb_orig(l_origination_id igf_gr_rfms_disb.origination_id%TYPE,
870: l_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE)
871: IS
872: SELECT *
873: FROM igf_gr_rfms_disb

Line 870: l_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE)

866: gldr_id BETWEEN 2 AND (l_last_gldr_id - 1)
867: AND file_type = 'GR_RFMS_DISB_ORIG';
868:
869: CURSOR cur_disb_orig(l_origination_id igf_gr_rfms_disb.origination_id%TYPE,
870: l_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE)
871: IS
872: SELECT *
873: FROM igf_gr_rfms_disb
874: WHERE

Line 873: FROM igf_gr_rfms_disb

869: CURSOR cur_disb_orig(l_origination_id igf_gr_rfms_disb.origination_id%TYPE,
870: l_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE)
871: IS
872: SELECT *
873: FROM igf_gr_rfms_disb
874: WHERE
875: origination_id = l_origination_id AND
876: disb_ref_num = l_disb_ref_num
877: FOR UPDATE OF edit_code NOWAIT;

Line 880: l_rfms igf_gr_rfms_disb%ROWTYPE;

876: disb_ref_num = l_disb_ref_num
877: FOR UPDATE OF edit_code NOWAIT;
878:
879: rec_disb_orig cur_disb_orig%ROWTYPE;
880: l_rfms igf_gr_rfms_disb%ROWTYPE;
881: l_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE;
882:
883: BEGIN
884:

Line 881: l_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE;

877: FOR UPDATE OF edit_code NOWAIT;
878:
879: rec_disb_orig cur_disb_orig%ROWTYPE;
880: l_rfms igf_gr_rfms_disb%ROWTYPE;
881: l_disb_ref_num igf_gr_rfms_disb.disb_ref_num%TYPE;
882:
883: BEGIN
884:
885: FOR rec_data IN c_rfms_data LOOP

Line 987: igf_gr_rfms_disb_pkg.update_row (

983: l_rfms.pymt_prd_start_dt := rec_disb_orig.accpt_pymt_prd_start_dt;
984: l_rfms.disb_status_dt := TRUNC(SYSDATE);
985:
986: lp_count := lp_count + 1;
987: igf_gr_rfms_disb_pkg.update_row (
988: x_rowid => rec_disb_orig.row_id,
989: x_rfmd_id => l_rfms.rfmd_id ,
990: x_origination_id => l_rfms.origination_id,
991: x_disb_ref_num => l_rfms.disb_ref_num,

Line 1097: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.RFMS_DISB_ACK');

1093: WHEN igf_gr_gen.file_not_loaded THEN
1094: RAISE;
1095: WHEN OTHERS THEN
1096: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1097: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.RFMS_DISB_ACK');
1098: igs_ge_msg_stack.add;
1099: app_exception.raise_exception;
1100: END rfms_disb_ack;
1101:

Line 1281: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.main.debug','(A)calling rfms_disb_orig with base_id:'||ln_base_id);

1277: Main logic starts here.
1278: */
1279: IF ln_base_id IS NOT NULL THEN
1280: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1281: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.main.debug','(A)calling rfms_disb_orig with base_id:'||ln_base_id);
1282: END IF;
1283: --call the main processing routine
1284: rfms_disb_orig(l_ci_cal_type,l_ci_sequence_number,ln_base_id, p_reporting_pell, p_attending_pell);
1285:

Line 1288: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.main.debug','(B)calling rfms_disb_orig with attedning pell:'||p_attending_pell);

1284: rfms_disb_orig(l_ci_cal_type,l_ci_sequence_number,ln_base_id, p_reporting_pell, p_attending_pell);
1285:
1286: ELSIF p_attending_pell IS NOT NULL THEN
1287: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1288: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.main.debug','(B)calling rfms_disb_orig with attedning pell:'||p_attending_pell);
1289: END IF;
1290: --call the main processing routine
1291: rfms_disb_orig(l_ci_cal_type,l_ci_sequence_number,ln_base_id, p_reporting_pell, p_attending_pell);
1292:

Line 1311: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.main.debug','(C)calling rfms_disb_orig with base_id:'||ln_base_id);

1307:
1308: WHILE c_base_id%FOUND LOOP
1309: BEGIN
1310: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1311: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_rfms_disb_orig.main.debug','(C)calling rfms_disb_orig with base_id:'||ln_base_id);
1312: END IF;
1313:
1314: l_record := NVL(l_record,0) + 1;
1315: --call the main processing routine

Line 1482: END igf_gr_rfms_disb_orig;

1478: igs_ge_msg_stack.conc_exception_hndl;
1479:
1480: END main_ack;
1481:
1482: END igf_gr_rfms_disb_orig;