DBA Data[Home] [Help]

APPS.IGF_GR_GEN dependencies on APP_EXCEPTION

Line 248: app_exception.raise_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:
251: END get_alt_code;
252:

Line 298: app_exception.raise_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:
301: END get_calendar_desc;
302:

Line 347: app_exception.raise_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;
350:
351:

Line 394: app_exception.raise_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;
397:
398:

Line 437: app_exception.raise_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;
440:
441:

Line 480: app_exception.raise_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;
483:
484:

Line 575: app_exception.raise_exception;

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:
578: END insert_sys_holds;
579:

Line 713: app_exception.raise_exception;

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:
716: END get_pell_header;
717:

Line 788: app_exception.raise_exception;

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;
791:
792:

Line 1168: app_exception.raise_exception;

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;
1171:
1172:

Line 1220: app_exception.raise_exception;

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;
1223:
1224:

Line 1258: app_exception.raise_exception;

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:
1261: END get_min_pell_disb;
1262:

Line 1294: app_exception.raise_exception;

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;
1297:
1298:

Line 1385: app_exception.raise_exception;

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;
1388:
1389:

Line 1441: app_exception.raise_exception;

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;
1444:
1445:

Line 1480: app_exception.raise_exception;

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:
1483: END get_fund_id;
1484:

Line 1511: app_exception.raise_exception;

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;
1514:
1515:

Line 1688: app_exception.raise_exception;

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;
1691:
1692:

Line 1918: app_exception.raise_exception;

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;
1921:
1922:

Line 1989: app_exception.raise_exception;

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;
1992:
1993: --

Line 2054: app_exception.raise_exception;

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:
2057: END ovrd_coa_exist;
2058:

Line 2152: app_exception.raise_exception;

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;
2155:
2156: PROCEDURE insert_coa_items( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,

Line 2272: app_exception.raise_exception;

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;
2275:
2276: PROCEDURE insert_coa_terms( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,

Line 2340: app_exception.raise_exception;

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;
2343:
2344:

Line 2391: app_exception.raise_exception;

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;
2394:
2395: --CODE ADDED BY GAUTAM

Line 2442: app_exception.raise_exception;

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;
2445:
2446: PROCEDURE delete_stu_coa_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,

Line 2489: app_exception.raise_exception;

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;
2492:
2493:

Line 2546: app_exception.raise_exception;

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;
2549:
2550: PROCEDURE update_stu_coa_items( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,

Line 2616: app_exception.raise_exception;

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;
2619:
2620:

Line 2732: app_exception.raise_exception;

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;
2735:
2736: PROCEDURE update_current_ssn (p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

Line 2848: WHEN app_exception.record_lock_exception THEN

2844: IF cur_get_pell%ISOPEN THEN
2845: CLOSE cur_get_pell;
2846: END IF;
2847:
2848: WHEN app_exception.record_lock_exception THEN
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');

Line 2855: app_exception.raise_exception;

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
2858: IF cur_get_pell%ISOPEN THEN
2859: CLOSE cur_get_pell;

Line 2864: app_exception.raise_exception;

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;
2867:
2868: PROCEDURE update_pell_status (p_award_id IN igf_aw_award_all.award_id%TYPE,

Line 2927: app_exception.raise_exception;

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;
2930:
2931: PROCEDURE match_file_version (p_version IN igf_lookups_view.lookup_code%TYPE,

Line 2987: app_exception.raise_exception;

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;
2990:
2991: