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_FISAP_PKG dependencies on IGF_AW_FISAP_PKG

Line 1: PACKAGE BODY IGF_AW_FISAP_PKG AS

1: PACKAGE BODY IGF_AW_FISAP_PKG AS
2: /* $Header: IGFAW22B.pls 120.9 2006/05/05 00:55:17 veramach noship $ */
3:
4: /*************************************************************
5: Created By : ugummall

Line 836: avalue => 'PLSQLCLOB:igf_aw_fisap_pkg.generate_partII/'|| ln_batch_id || ':' || lv_cal_type || ':' || ln_seq_number);

832: IF (funcmode = 'RUN') THEN
833: wf_engine.SetItemAttrText ( itemtype => itemtype,
834: itemkey => itemkey,
835: aname => 'FISAP_DATA',
836: avalue => 'PLSQLCLOB:igf_aw_fisap_pkg.generate_partII/'|| ln_batch_id || ':' || lv_cal_type || ':' || ln_seq_number);
837: resultout:= 'COMPLETE:';
838: RETURN;
839: END IF;
840: END generate_aggregate_data;

Line 1146: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_fisap_pkg.generate_partII.debug', 'Part II 1-14 rows cursor parameter values(cal type, seq no, batch id): ' || lv_cal_type || ', ' || ln_seq_number || ', ' || ln_batch_id);

1142: -- Part II. Eligible Aid Grid data. 14 Rows.
1143: OPEN cur_2f_depend_smry(lv_cal_type, ln_seq_number, ln_batch_id);
1144: OPEN cur_2f_independ_smry(lv_cal_type, ln_seq_number, ln_batch_id);
1145: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1146: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_fisap_pkg.generate_partII.debug', 'Part II 1-14 rows cursor parameter values(cal type, seq no, batch id): ' || lv_cal_type || ', ' || ln_seq_number || ', ' || ln_batch_id);
1147: END IF;
1148:
1149: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1150: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_fisap_pkg.generate_partII.debug', 'Before entering Part II 14 rows loop');

Line 1150: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_fisap_pkg.generate_partII.debug', 'Before entering Part II 14 rows loop');

1146: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_fisap_pkg.generate_partII.debug', 'Part II 1-14 rows cursor parameter values(cal type, seq no, batch id): ' || lv_cal_type || ', ' || ln_seq_number || ', ' || ln_batch_id);
1147: END IF;
1148:
1149: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1150: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_fisap_pkg.generate_partII.debug', 'Before entering Part II 14 rows loop');
1151: END IF;
1152:
1153: lv_and_over_mesg := get_lookup_meaning('IGF_AW_FISAP_HTML_REP','AND_OVER');
1154: LOOP

Line 1164: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_fisap_pkg.generate_partII.debug', '2F Depend Start range = ' || rec_2f_depend_smry.start_range_amt);

1160: END IF;
1161:
1162: l_c_document := l_c_document || '$' || rec_2f_depend_smry.start_range_amt;
1163: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1164: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_fisap_pkg.generate_partII.debug', '2F Depend Start range = ' || rec_2f_depend_smry.start_range_amt);
1165: END IF;
1166:
1167: IF rec_2f_depend_smry.end_range_amt IS NULL THEN
1168: end_range_amt_txt := ' ' || lv_and_over_mesg;

Line 1173: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_fisap_pkg.generate_partII.debug', '2F Depend Start range = ' || end_range_amt_txt);

1169: ELSE
1170: end_range_amt_txt := ' - $' || rec_2f_depend_smry.end_range_amt;
1171: END IF;
1172: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1173: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_fisap_pkg.generate_partII.debug', '2F Depend Start range = ' || end_range_amt_txt);
1174: END IF;
1175:
1176: l_c_document := l_c_document || end_range_amt_txt || '';
1177: l_c_document := l_c_document || NVL(rec_2f_depend_smry.ug_wout, 0)|| '';

Line 1228: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_fisap_pkg.generate_partII.debug', 'Before entering Part VI 1-7 Ug Dependent loop');

1224: l_c_document := l_c_document||'' || get_lookup_meaning('IGF_AW_FISAP_HTML_REP','UG_D') || '';
1225:
1226: -- Rows 1 to 7. Undergraduate Depedent.
1227: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1228: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_fisap_pkg.generate_partII.debug', 'Before entering Part VI 1-7 Ug Dependent loop');
1229: END IF;
1230: FOR rec IN cur_6a_ugdepend(lv_cal_type, ln_seq_number, ln_batch_id) LOOP
1231: ln_line_num := ln_line_num + 1;
1232: l_c_document := l_c_document || '' || ln_line_num || '$';

Line 1234: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_fisap_pkg.generate_partII.debug', 'preparing row# ' || ln_line_num || ' of Part VI 1-7 rows');

1230: FOR rec IN cur_6a_ugdepend(lv_cal_type, ln_seq_number, ln_batch_id) LOOP
1231: ln_line_num := ln_line_num + 1;
1232: l_c_document := l_c_document || '' || ln_line_num || '$';
1233: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1234: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_fisap_pkg.generate_partII.debug', 'preparing row# ' || ln_line_num || ' of Part VI 1-7 rows');
1235: END IF;
1236:
1237: IF rec.end_range_amt IS NULL THEN
1238: end_range_amt_txt := ' ' || lv_and_over_mesg;

Line 1262: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_fisap_pkg.generate_partII.debug', 'Before entering Part VI 8-14 Ug Independent loop');

1258: l_c_document := l_c_document || '' || get_lookup_meaning('IGF_AW_FISAP_HTML_REP','UG_I') || '';
1259:
1260: -- Rows 8 to 14. Undergraduate Indepedent.
1261: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1262: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_fisap_pkg.generate_partII.debug', 'Before entering Part VI 8-14 Ug Independent loop');
1263: END IF;
1264: FOR rec IN cur_6a_ugindepend(lv_cal_type, ln_seq_number, ln_batch_id) LOOP
1265: ln_line_num := ln_line_num + 1;
1266: l_c_document := l_c_document || '' || ln_line_num || '$';

Line 1268: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_fisap_pkg.generate_partII.debug', 'preparing row# ' || ln_line_num || ' of Part VI 8-14 rows');

1264: FOR rec IN cur_6a_ugindepend(lv_cal_type, ln_seq_number, ln_batch_id) LOOP
1265: ln_line_num := ln_line_num + 1;
1266: l_c_document := l_c_document || '' || ln_line_num || '$';
1267: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1268: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_fisap_pkg.generate_partII.debug', 'preparing row# ' || ln_line_num || ' of Part VI 8-14 rows');
1269: END IF;
1270:
1271: IF rec.end_range_amt IS NULL THEN
1272: end_range_amt_txt := ' ' || lv_and_over_mesg;

Line 1348: END IGF_AW_FISAP_PKG;

1344: WF_NOTIFICATION.WriteToClob(document, l_c_document);
1345:
1346: END generate_partII;
1347:
1348: END IGF_AW_FISAP_PKG;