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_GEN dependencies on IGF_GR_GEN

Line 1: PACKAGE BODY igf_gr_gen AS

1: PACKAGE BODY igf_gr_gen AS
2: /* $Header: IGFGR08B.pls 120.3 2006/04/06 06:11:10 veramach ship $ */
3:
4: -----------------------------------------------------------------------------------
5: -- Who When What

Line 246: fnd_message.set_token('NAME','IGF_GR_GEN.GET_ALT_CODE'|| ' ' || SQLERRM);

242:
243: EXCEPTION
244: WHEN OTHERS THEN
245: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
246: fnd_message.set_token('NAME','IGF_GR_GEN.GET_ALT_CODE'|| ' ' || SQLERRM);
247: igs_ge_msg_stack.add;
248: app_exception.raise_exception;
249:
250:

Line 296: fnd_message.set_token('NAME','IGF_GR_GEN.GET_CALENDAR_DESC'|| ' ' || SQLERRM);

292:
293: EXCEPTION
294: WHEN OTHERS THEN
295: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
296: fnd_message.set_token('NAME','IGF_GR_GEN.GET_CALENDAR_DESC'|| ' ' || SQLERRM);
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299:
300:

Line 345: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_NUM'|| ' ' || SQLERRM);

341:
342: EXCEPTION
343: WHEN OTHERS THEN
344: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
345: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_NUM'|| ' ' || SQLERRM);
346: igs_ge_msg_stack.add;
347: app_exception.raise_exception;
348:
349: END get_per_num;

Line 392: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_NUM'|| ' ' || SQLERRM);

388:
389: EXCEPTION
390: WHEN OTHERS THEN
391: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
392: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_NUM'|| ' ' || SQLERRM);
393: igs_ge_msg_stack.add;
394: app_exception.raise_exception;
395:
396: END get_per_num;

Line 435: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_ID'|| ' ' || SQLERRM);

431:
432: EXCEPTION
433: WHEN OTHERS THEN
434: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
435: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_ID'|| ' ' || SQLERRM);
436: igs_ge_msg_stack.add;
437: app_exception.raise_exception;
438:
439: END get_person_id;

Line 478: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_NUM_OSS'|| ' ' || SQLERRM);

474:
475: EXCEPTION
476: WHEN OTHERS THEN
477: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
478: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_NUM_OSS'|| ' ' || SQLERRM);
479: igs_ge_msg_stack.add;
480: app_exception.raise_exception;
481:
482: END get_per_num_oss;

Line 573: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_SYS_HOLDS'|| ' ' || SQLERRM);

569: IF l_name = 'IGF_DB_HOLD_EXISTS' THEN
570: NULL;
571: ELSE
572: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
573: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_SYS_HOLDS'|| ' ' || SQLERRM);
574: igs_ge_msg_stack.add;
575: app_exception.raise_exception;
576: END IF;
577:

Line 711: fnd_message.set_token('NAME','IGF_GR_GEN.PREPARE_HEADER'|| ' ' || SQLERRM);

707: RAISE;
708:
709: WHEN OTHERS THEN
710: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
711: fnd_message.set_token('NAME','IGF_GR_GEN.PREPARE_HEADER'|| ' ' || SQLERRM);
712: igs_ge_msg_stack.add;
713: app_exception.raise_exception;
714:
715:

Line 786: fnd_message.set_token('NAME','IGF_GR_GEN.PREPARE_TRAILER'|| ' ' || SQLERRM);

782: RAISE;
783:
784: WHEN OTHERS THEN
785: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
786: fnd_message.set_token('NAME','IGF_GR_GEN.PREPARE_TRAILER'|| ' ' || SQLERRM);
787: igs_ge_msg_stack.add;
788: app_exception.raise_exception;
789:
790: END get_pell_trailer;

Line 1016: x_efc => igf_gr_gen.get_pell_efc(cur_get_rfms.base_id),

1012: x_rfmb_id => NULL,
1013: x_sys_orig_ssn => cur_get_rfms.sys_orig_ssn,
1014: x_sys_orig_name_cd => cur_get_rfms.sys_orig_name_cd,
1015: x_transaction_num => cur_get_rfms.transaction_num,
1016: x_efc => igf_gr_gen.get_pell_efc(cur_get_rfms.base_id),
1017: x_ver_status_code => cur_get_rfms.ver_status_code,
1018: x_secondary_efc => cur_get_rfms.secondary_efc,
1019: x_secondary_efc_cd => igf_gr_gen.get_pell_efc_code(cur_get_rfms.base_id),
1020: x_pell_amount => cur_get_rfms.pell_amount,

Line 1019: x_secondary_efc_cd => igf_gr_gen.get_pell_efc_code(cur_get_rfms.base_id),

1015: x_transaction_num => cur_get_rfms.transaction_num,
1016: x_efc => igf_gr_gen.get_pell_efc(cur_get_rfms.base_id),
1017: x_ver_status_code => cur_get_rfms.ver_status_code,
1018: x_secondary_efc => cur_get_rfms.secondary_efc,
1019: x_secondary_efc_cd => igf_gr_gen.get_pell_efc_code(cur_get_rfms.base_id),
1020: x_pell_amount => cur_get_rfms.pell_amount,
1021: x_pell_profile => cur_get_rfms.pell_profile,
1022: x_enrollment_status => cur_get_rfms.enrollment_status,
1023: x_enrollment_dt => cur_get_rfms.enrollment_dt,

Line 1166: fnd_message.set_token('NAME','IGF_GR_GEN.PROCESS_PELL_ACK'|| ' ' || SQLERRM);

1162:
1163: WHEN OTHERS THEN
1164:
1165: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1166: fnd_message.set_token('NAME','IGF_GR_GEN.PROCESS_PELL_ACK'|| ' ' || SQLERRM);
1167: igs_ge_msg_stack.add;
1168: app_exception.raise_exception;
1169:
1170: END process_pell_ack;

Line 1218: fnd_message.set_token('NAME','IGF_GR_GEN.SEND_ORIG_DISB'|| ' ' || SQLERRM);

1214:
1215: WHEN OTHERS THEN
1216:
1217: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1218: fnd_message.set_token('NAME','IGF_GR_GEN.SEND_ORIG_DISB'|| ' ' || SQLERRM);
1219: igs_ge_msg_stack.add;
1220: app_exception.raise_exception;
1221:
1222: END send_orig_disb;

Line 1256: fnd_message.set_token('NAME','IGF_GR_GEN.GET_MIN_PELL_DISB'|| ' ' || SQLERRM);

1252: EXCEPTION
1253: WHEN OTHERS THEN
1254:
1255: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1256: fnd_message.set_token('NAME','IGF_GR_GEN.GET_MIN_PELL_DISB'|| ' ' || SQLERRM);
1257: igs_ge_msg_stack.add;
1258: app_exception.raise_exception;
1259:
1260:

Line 1292: fnd_message.set_token('NAME','IGF_GR_GEN.GET_MIN_AWD_DISB'|| ' ' || SQLERRM);

1288: EXCEPTION
1289: WHEN OTHERS THEN
1290:
1291: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1292: fnd_message.set_token('NAME','IGF_GR_GEN.GET_MIN_AWD_DISB'|| ' ' || SQLERRM);
1293: igs_ge_msg_stack.add;
1294: app_exception.raise_exception;
1295:
1296: END get_min_awd_disb;

Line 1383: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PELL_EFC_CODE'|| ' ' || SQLERRM);

1379:
1380: WHEN OTHERS THEN
1381:
1382: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1383: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PELL_EFC_CODE'|| ' ' || SQLERRM);
1384: igs_ge_msg_stack.add;
1385: app_exception.raise_exception;
1386:
1387: END get_pell_efc_code;

Line 1439: fnd_message.set_token('NAME','IGF_GR_GEN.FRESH_ORIGINTN'|| ' ' || SQLERRM);

1435:
1436: WHEN OTHERS THEN
1437:
1438: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1439: fnd_message.set_token('NAME','IGF_GR_GEN.FRESH_ORIGINTN'|| ' ' || SQLERRM);
1440: igs_ge_msg_stack.add;
1441: app_exception.raise_exception;
1442:
1443: END fresh_origintn;

Line 1478: fnd_message.set_token('NAME','IGF_GR_GEN.GET_FUND_ID'|| ' ' || SQLERRM);

1474:
1475: WHEN OTHERS THEN
1476:
1477: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1478: fnd_message.set_token('NAME','IGF_GR_GEN.GET_FUND_ID'|| ' ' || SQLERRM);
1479: igs_ge_msg_stack.add;
1480: app_exception.raise_exception;
1481:
1482:

Line 1509: fnd_message.set_token('NAME','IGF_GR_GEN.GET_SSN_DIGITS'|| ' ' || SQLERRM);

1505:
1506: WHEN OTHERS THEN
1507:
1508: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1509: fnd_message.set_token('NAME','IGF_GR_GEN.GET_SSN_DIGITS'|| ' ' || SQLERRM);
1510: igs_ge_msg_stack.add;
1511: app_exception.raise_exception;
1512:
1513: END get_ssn_digits;

Line 1686: fnd_message.set_token('NAME','IGF_GR_GEN.DELETE_COA'|| ' ' || SQLERRM);

1682: WHEN NO_DATA_FOUND THEN NULL;
1683: WHEN OTHERS THEN
1684:
1685: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1686: fnd_message.set_token('NAME','IGF_GR_GEN.DELETE_COA'|| ' ' || SQLERRM);
1687: igs_ge_msg_stack.add;
1688: app_exception.raise_exception;
1689:
1690: END delete_coa;

Line 1916: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_ITEM_DIST'|| ' ' || SQLERRM);

1912: EXCEPTION
1913: WHEN OTHERS THEN
1914:
1915: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1916: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_ITEM_DIST'|| ' ' || SQLERRM);
1917: igs_ge_msg_stack.add;
1918: app_exception.raise_exception;
1919:
1920: END update_item_dist;

Line 1987: fnd_message.set_token('NAME','IGF_GR_GEN.GET_DEF_AWD_YEAR'|| ' ' || SQLERRM);

1983: IF cur_get_awd_yr%ISOPEN THEN
1984: CLOSE cur_get_awd_yr;
1985: END IF;
1986: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1987: fnd_message.set_token('NAME','IGF_GR_GEN.GET_DEF_AWD_YEAR'|| ' ' || SQLERRM);
1988: igs_ge_msg_stack.add;
1989: app_exception.raise_exception;
1990:
1991: END get_def_awd_year;

Line 2052: fnd_message.set_token('NAME','IGF_GR_GEN.OVRD_COA_EXIST'|| ' ' || SQLERRM);

2048: IF cur_overide_ld%ISOPEN THEN
2049: CLOSE cur_overide_ld;
2050: END IF;
2051: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2052: fnd_message.set_token('NAME','IGF_GR_GEN.OVRD_COA_EXIST'|| ' ' || SQLERRM);
2053: igs_ge_msg_stack.add;
2054: app_exception.raise_exception;
2055:
2056:

Line 2150: fnd_message.set_token('NAME','IGF_GR_GEN.GET_TUFEES_CODE'|| ' ' || SQLERRM);

2146: CLOSE cur_tufees_code;
2147: END IF;
2148:
2149: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2150: fnd_message.set_token('NAME','IGF_GR_GEN.GET_TUFEES_CODE'|| ' ' || SQLERRM);
2151: igs_ge_msg_stack.add;
2152: app_exception.raise_exception;
2153:
2154: END get_tufees_code;

Line 2270: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_COA_ITEMS'|| ' ' || SQLERRM);

2266: CLOSE cur_overide;
2267: END IF;
2268:
2269: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2270: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_COA_ITEMS'|| ' ' || SQLERRM);
2271: igs_ge_msg_stack.add;
2272: app_exception.raise_exception;
2273:
2274: END insert_coa_items;

Line 2338: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_COA_TERMS'|| ' ' || SQLERRM);

2334: CLOSE cur_get_items;
2335: END IF;
2336:
2337: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2338: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_COA_TERMS'|| ' ' || SQLERRM);
2339: igs_ge_msg_stack.add;
2340: app_exception.raise_exception;
2341:
2342: END insert_coa_terms;

Line 2389: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_STU_COA_TERMS'|| ' ' || SQLERRM);

2385: CLOSE cur_get_terms;
2386: END IF;
2387:
2388: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2389: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_STU_COA_TERMS'|| ' ' || SQLERRM);
2390: igs_ge_msg_stack.add;
2391: app_exception.raise_exception;
2392:
2393: END insert_stu_coa_terms;

Line 2440: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_EXISTING_TERMS'|| ' ' || SQLERRM);

2436: CLOSE cur_get_existing_terms;
2437: END IF;
2438:
2439: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2440: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_EXISTING_TERMS'|| ' ' || SQLERRM);
2441: igs_ge_msg_stack.add;
2442: app_exception.raise_exception;
2443:
2444: END insert_existing_terms;

Line 2487: fnd_message.set_token('NAME','IGF_GR_GEN.DELETE_STU_COA_TERMS'|| ' ' || SQLERRM);

2483: CLOSE cur_get_terms;
2484: END IF;
2485:
2486: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2487: fnd_message.set_token('NAME','IGF_GR_GEN.DELETE_STU_COA_TERMS'|| ' ' || SQLERRM);
2488: igs_ge_msg_stack.add;
2489: app_exception.raise_exception;
2490:
2491: END delete_stu_coa_terms;

Line 2544: fnd_message.set_token('NAME','IGF_GR_GEN.DELETE_STU_COA_ITEMS'|| ' ' || SQLERRM);

2540: CLOSE cur_get_coa_terms;
2541: END IF;
2542:
2543: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2544: fnd_message.set_token('NAME','IGF_GR_GEN.DELETE_STU_COA_ITEMS'|| ' ' || SQLERRM);
2545: igs_ge_msg_stack.add;
2546: app_exception.raise_exception;
2547:
2548: END delete_stu_coa_items;

Line 2614: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_STU_COA_ITEMS'|| ' ' || SQLERRM);

2610: CLOSE cur_get_terms;
2611: END IF;
2612:
2613: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2614: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_STU_COA_ITEMS'|| ' ' || SQLERRM);
2615: igs_ge_msg_stack.add;
2616: app_exception.raise_exception;
2617:
2618: END update_stu_coa_items;

Line 2730: fnd_message.set_token('NAME','IGF_GR_GEN.GET_BASE_ID'|| ' ' || SQLERRM);

2726: IF cur_get_base%ISOPEN THEN
2727: CLOSE cur_get_base;
2728: END IF;
2729: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2730: fnd_message.set_token('NAME','IGF_GR_GEN.GET_BASE_ID'|| ' ' || SQLERRM);
2731: igs_ge_msg_stack.add;
2732: app_exception.raise_exception;
2733:
2734: END get_base_id;

Line 2853: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_CURRENT_SSN');

2849: IF cur_get_pell%ISOPEN THEN
2850: CLOSE cur_get_pell;
2851: END IF;
2852: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
2853: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_CURRENT_SSN');
2854: igs_ge_msg_stack.add;
2855: app_exception.raise_exception;
2856:
2857: WHEN OTHERS THEN

Line 2862: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_CURRENT_SSN'|| ' ' || SQLERRM);

2858: IF cur_get_pell%ISOPEN THEN
2859: CLOSE cur_get_pell;
2860: END IF;
2861: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2862: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_CURRENT_SSN'|| ' ' || SQLERRM);
2863: igs_ge_msg_stack.add;
2864: app_exception.raise_exception;
2865:
2866: END update_current_ssn;

Line 2925: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_PELL_STATUS'|| ' ' || SQLERRM);

2921: IF cur_get_pell%ISOPEN THEN
2922: CLOSE cur_get_pell;
2923: END IF;
2924: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2925: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_PELL_STATUS'|| ' ' || SQLERRM);
2926: igs_ge_msg_stack.add;
2927: app_exception.raise_exception;
2928:
2929: END update_pell_status;

Line 2985: fnd_message.set_token('NAME','IGF_GR_GEN.GET_MIN_DISB_NUMBER'|| ' ' || SQLERRM);

2981:
2982: WHEN OTHERS THEN
2983:
2984: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2985: fnd_message.set_token('NAME','IGF_GR_GEN.GET_MIN_DISB_NUMBER'|| ' ' || SQLERRM);
2986: igs_ge_msg_stack.add;
2987: app_exception.raise_exception;
2988:
2989: END get_min_disb_number;

Line 3086: END igf_gr_gen;

3082: END IF;
3083:
3084: END get_rep_pell_from_base;
3085:
3086: END igf_gr_gen;