DBA Data[Home] [Help]

APPS.IGS_PR_GEN_006 dependencies on APP_EXCEPTION

Line 69: App_Exception.Raise_Exception;

65: WHEN OTHERS THEN
66: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
67: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_SCSC_COMP');
68: IGS_GE_MSG_STACK.ADD;
69: App_Exception.Raise_Exception;
70: END IGS_PR_get_scsc_comp;
71:
72: FUNCTION IGS_PR_get_spo_aply_dt(
73: p_decision_status IN VARCHAR2 ,

Line 124: App_Exception.Raise_Exception;

120: WHEN OTHERS THEN
121: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
122: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_SPO_APLY_DT');
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception;
125: END IGS_PR_get_spo_aply_dt;
126:
127: FUNCTION IGS_PR_GET_SPO_CMT(
128: p_person_id IN NUMBER ,

Line 235: App_Exception.Raise_Exception;

231: WHEN OTHERS THEN
232: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
233: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_SPO_CMT');
234: IGS_GE_MSG_STACK.ADD;
235: App_Exception.Raise_Exception;
236: END IGS_PR_get_spo_cmt;
237: FUNCTION IGS_PR_get_spo_expiry(
238: p_person_id IN NUMBER ,
239: p_course_cd IN VARCHAR2 ,

Line 403: App_Exception.Raise_Exception;

399: WHEN OTHERS THEN
400: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
401: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_SPO_EXPIRY');
402: IGS_GE_MSG_STACK.ADD;
403: App_Exception.Raise_Exception;
404: END IGS_PR_get_spo_expiry;
405:
406: FUNCTION IGS_PR_get_sprc_dsp(
407: p_person_id IN NUMBER ,

Line 524: App_Exception.Raise_Exception;

520: WHEN OTHERS THEN
521: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
522: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_STD_GPA');
523: IGS_GE_MSG_STACK.ADD;
524: App_Exception.Raise_Exception;
525: END IGS_PR_get_std_gpa;
526:
527:
528: FUNCTION IGS_PR_GET_STD_WAM(

Line 561: App_Exception.Raise_Exception;

557: WHEN OTHERS THEN
558: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
559: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_STD_WAM');
560: IGS_GE_MSG_STACK.ADD;
561: App_Exception.Raise_Exception;
562: END IGS_PR_get_std_wam;
563:
564:
565: FUNCTION IGS_PR_get_within_appl(

Line 652: App_Exception.Raise_Exception;

648: WHEN OTHERS THEN
649: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
650: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_WITHIN_APPL.PRGPL_GET_ALIAS_VALUE');
651: IGS_GE_MSG_STACK.ADD;
652: App_Exception.Raise_Exception;
653: END prgpl_get_alias_value;
654:
655: BEGIN
656: IGS_PR_GEN_003.IGS_PR_get_config_parm (

Line 704: App_Exception.Raise_Exception;

700: WHEN OTHERS THEN
701: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
702: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_WITHIN_APPL');
703: IGS_GE_MSG_STACK.ADD;
704: App_Exception.Raise_Exception;
705: END IGS_PR_get_within_appl;
706:
707:
708: FUNCTION IGS_PR_INS_COPY_PRA(

Line 824: App_Exception.Raise_Exception;

820: WHEN OTHERS THEN
821: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
822: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.C_POC');
823: IGS_GE_MSG_STACK.ADD;
824: App_Exception.Raise_Exception;
825: END;
826: END LOOP;
827: FOR v_pous_rec IN c_pous LOOP
828: BEGIN

Line 851: App_Exception.Raise_Exception;

847: WHEN OTHERS THEN
848: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
849: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.C_POUS');
850: IGS_GE_MSG_STACK.ADD;
851: App_Exception.Raise_Exception;
852: END;
853: END LOOP;
854:
855:

Line 879: App_Exception.Raise_Exception;

875: WHEN OTHERS THEN
876: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
877: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.C_POA');
878: IGS_GE_MSG_STACK.ADD;
879: App_Exception.Raise_Exception;
880: END;
881:
882: END LOOP;
883:

Line 907: App_Exception.Raise_Exception;

903: WHEN OTHERS THEN
904: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
905: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.C_POPU');
906: IGS_GE_MSG_STACK.ADD;
907: App_Exception.Raise_Exception;
908: END;
909: END LOOP;
910:
911: --

Line 933: App_Exception.Raise_Exception;

929: WHEN OTHERS THEN
930: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
931: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.C_POPF');
932: IGS_GE_MSG_STACK.ADD;
933: App_Exception.Raise_Exception;
934: END;
935: END LOOP;
936: --
937: -- Start of new code added as per the FA110 PR Enh. Bug# 2658550.

Line 964: App_Exception.Raise_Exception;

960: WHEN OTHERS THEN
961: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
962: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_COPY_PRA.PRGPL_INS_POC_POUS_POPU.');
963: IGS_GE_MSG_STACK.ADD;
964: App_Exception.Raise_Exception;
965: END prgpl_ins_poc_pous_popu;
966:
967: FUNCTION prgpl_ins_copy_pra(
968: p_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,

Line 1155: App_Exception.Raise_Exception;

1151: WHEN OTHERS THEN
1152: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1153: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_COPY_PRA.RULE_COPY');
1154: IGS_GE_MSG_STACK.ADD;
1155: App_Exception.Raise_Exception;
1156: END;
1157: END IF;
1158: OPEN c_pra_sequence_number;
1159: FETCH c_pra_sequence_number INTO gv_new_pra_sequence_number;

Line 1238: App_Exception.Raise_Exception;

1234: WHEN OTHERS THEN
1235: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1236: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_COPY_PRA.INESRT_RULE_APPL');
1237: IGS_GE_MSG_STACK.ADD;
1238: App_Exception.Raise_Exception;
1239: END;
1240: IF v_error_ins_pra = FALSE THEN
1241: FOR v_prrc_rec IN c_prrc LOOP
1242: BEGIN

Line 1266: App_Exception.Raise_Exception;

1262: WHEN OTHERS THEN
1263: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1264: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_COPY_PRA.INSERT_RU_CA');
1265: IGS_GE_MSG_STACK.ADD;
1266: App_Exception.Raise_Exception;
1267: END;
1268: END LOOP;
1269: FOR v_pro_rec IN c_pro LOOP
1270: OPEN c_pro_sequence_number;

Line 1408: App_Exception.Raise_Exception;

1404: WHEN OTHERS THEN
1405: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1406: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_COPY_PRA.PRGPL_INS_COPY_PRA');
1407: IGS_GE_MSG_STACK.ADD;
1408: App_Exception.Raise_Exception;
1409: END prgpl_ins_copy_pra;
1410: BEGIN
1411: --kdande; 19-Jul-2002; Bug# 2462120; Changed the message name from 300 to IGS_PS_SUCCESS_COPY_PRGVER
1412: p_message_name := 'IGS_PS_SUCCESS_COPY_PRGVER';

Line 1455: App_Exception.Raise_Exception;

1451: WHEN OTHERS THEN
1452: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1453: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_COPY_PRA');
1454: IGS_GE_MSG_STACK.ADD;
1455: App_Exception.Raise_Exception;
1456: END IGS_PR_ins_copy_pra;
1457:
1458: FUNCTION IGS_PR_INS_SSP_CMP_DTL(
1459: p_rule_text IN VARCHAR2 ,

Line 1557: App_Exception.Raise_Exception;

1553: WHEN OTHERS THEN
1554: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1555: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_SSP_CMP_DTL');
1556: IGS_GE_MSG_STACK.ADD;
1557: App_Exception.Raise_Exception;
1558: END IGS_PR_ins_ssp_cmp_dtl;
1559:
1560:
1561: FUNCTION IGS_PR_upd_pen_clash(

Line 2035: App_Exception.Raise_Exception;

2031: WHEN OTHERS THEN
2032: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2033: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_UPD_PEN_CLASH.PRGPL_UPD_PEN_CHECK_CLASH');
2034: IGS_GE_MSG_STACK.ADD;
2035: App_Exception.Raise_Exception;
2036: END prgpl_upd_pen_check_clash;
2037: BEGIN
2038: -- Initialise output parameters
2039: p_message_level := NULL;

Line 2273: App_Exception.Raise_Exception;

2269: WHEN OTHERS THEN
2270: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2271: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_UPD_PEN_CLASH');
2272: IGS_GE_MSG_STACK.ADD;
2273: App_Exception.Raise_Exception;
2274: END IGS_PR_upd_pen_clash;
2275:
2276: FUNCTION IGS_PR_UPD_SCA_STATUS(
2277: p_person_id IN NUMBER ,

Line 2465: App_Exception.Raise_Exception;

2461: WHEN OTHERS THEN
2462: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2463: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_UPD_SCA_STATUS');
2464: IGS_GE_MSG_STACK.ADD;
2465: App_Exception.Raise_Exception;
2466: END IGS_PR_upd_sca_status;
2467:
2468:
2469: FUNCTION igs_pr_upd_spo_pen(

Line 3406: App_Exception.Raise_Exception;

3402: WHEN OTHERS THEN
3403: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3404: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_UPD_SPO_PEN.PRGPL_UPD_EXPIRY_DT1');
3405: IGS_GE_MSG_STACK.ADD;
3406: App_Exception.Raise_Exception;
3407: END prgpl_upd_expiry_dt1;
3408:
3409:
3410: FUNCTION prgpl_upd_expiry_dt2

Line 3749: App_Exception.Raise_Exception;

3745: WHEN OTHERS THEN
3746: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3747: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_UPD_SPO_PEN.PRGPL_UPD_EXPIRY_DT2');
3748: IGS_GE_MSG_STACK.ADD;
3749: App_Exception.Raise_Exception;
3750: END prgpl_upd_expiry_dt2;
3751:
3752: BEGIN
3753:

Line 4980: App_Exception.Raise_Exception;

4976: WHEN OTHERS THEN
4977: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4978: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_UPD_SPO_PEN');
4979: IGS_GE_MSG_STACK.ADD;
4980: App_Exception.Raise_Exception;
4981: END igs_pr_upd_spo_pen;
4982:
4983: FUNCTION igs_pr_get_spo_expiry(
4984:

Line 5022: App_Exception.Raise_Exception;

5018: WHEN OTHERS THEN
5019: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5020: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_SPO_EXPIRY');
5021: IGS_GE_MSG_STACK.ADD;
5022: App_Exception.Raise_Exception;
5023: END igs_pr_get_spo_expiry;
5024:
5025: FUNCTION get_antcp_compl_dt(
5026: p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,