DBA Data[Home] [Help]

APPS.IGS_ST_GEN_004 dependencies on FND_MESSAGE

Line 95: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

91: RAISE;
92: END;
93: EXCEPTION
94: WHEN OTHERS THEN
95: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
96: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stap_get_supp_fos');
97: IGS_GE_MSG_STACK.ADD;
98: App_Exception.Raise_Exception;
99: END stap_get_supp_fos;

Line 96: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stap_get_supp_fos');

92: END;
93: EXCEPTION
94: WHEN OTHERS THEN
95: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
96: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stap_get_supp_fos');
97: IGS_GE_MSG_STACK.ADD;
98: App_Exception.Raise_Exception;
99: END stap_get_supp_fos;
100:

Line 142: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

138: RAISE;
139: END;
140: EXCEPTION
141: WHEN OTHERS THEN
142: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
143: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stap_get_tot_exmpt');
144: IGS_GE_MSG_STACK.ADD;
145: App_Exception.Raise_Exception;
146: END stap_get_tot_exmpt;

Line 143: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stap_get_tot_exmpt');

139: END;
140: EXCEPTION
141: WHEN OTHERS THEN
142: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
143: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stap_get_tot_exmpt');
144: IGS_GE_MSG_STACK.ADD;
145: App_Exception.Raise_Exception;
146: END stap_get_tot_exmpt;
147:

Line 211: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

207: RETURN v_ret_val;
208: END;
209: EXCEPTION
210: WHEN OTHERS THEN
211: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
212: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stap_get_un_comp_sts');
213: IGS_GE_MSG_STACK.ADD;
214: App_Exception.Raise_Exception;
215: END stap_get_un_comp_sts;

Line 212: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stap_get_un_comp_sts');

208: END;
209: EXCEPTION
210: WHEN OTHERS THEN
211: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
212: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stap_get_un_comp_sts');
213: IGS_GE_MSG_STACK.ADD;
214: App_Exception.Raise_Exception;
215: END stap_get_un_comp_sts;
216:

Line 752: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

748: p_uoo_id);
749: END;
750: EXCEPTION
751: WHEN OTHERS THEN
752: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
753: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stapl_val_unit_compltn_status');
754: IGS_GE_MSG_STACK.ADD;
755: App_Exception.Raise_Exception;
756: END stapl_val_unit_compltn_status;

Line 753: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stapl_val_unit_compltn_status');

749: END;
750: EXCEPTION
751: WHEN OTHERS THEN
752: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
753: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stapl_val_unit_compltn_status');
754: IGS_GE_MSG_STACK.ADD;
755: App_Exception.Raise_Exception;
756: END stapl_val_unit_compltn_status;
757: PROCEDURE stapl_ins_govt_sdnt_load_rec(

Line 832: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

828: END IF;
829: END;
830: EXCEPTION
831: WHEN OTHERS THEN
832: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
833: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stapl_ins_govt_sdnt_load_rec');
834: IGS_GE_MSG_STACK.ADD;
835: App_Exception.Raise_Exception;
836: END stapl_ins_govt_sdnt_load_rec;

Line 833: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stapl_ins_govt_sdnt_load_rec');

829: END;
830: EXCEPTION
831: WHEN OTHERS THEN
832: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
833: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stapl_ins_govt_sdnt_load_rec');
834: IGS_GE_MSG_STACK.ADD;
835: App_Exception.Raise_Exception;
836: END stapl_ins_govt_sdnt_load_rec;
837: PROCEDURE stapl_get_sca_data_for_liab(

Line 904: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

900: p_sex;
901: -- raise an exception if no IGS_PE_PERSON record found
902: IF (c_get_person_dtls%NOTFOUND) THEN
903: CLOSE c_get_person_dtls;
904: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
905: IGS_GE_MSG_STACK.ADD;
906: App_Exception.Raise_Exception;
907: END IF;
908: CLOSE c_get_person_dtls;

Line 1038: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

1034: CLOSE c_perm_res;
1035: END IF;
1036: v_other_detail := 'Cannot find student IGS_PS_COURSE attempt data- ' ||
1037: TO_CHAR(p_current_person_id);
1038: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1039: IGS_GE_MSG_STACK.ADD;
1040:
1041: App_Exception.Raise_Exception;
1042: WHEN OTHERS THEN

Line 1059: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1055: RAISE;
1056: END;
1057: EXCEPTION
1058: WHEN OTHERS THEN
1059: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1060: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stapl_get_sca_data_for_liab');
1061: IGS_GE_MSG_STACK.ADD;
1062: App_Exception.Raise_Exception;
1063: END stapl_get_sca_data_for_liab;

Line 1060: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stapl_get_sca_data_for_liab');

1056: END;
1057: EXCEPTION
1058: WHEN OTHERS THEN
1059: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1060: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stapl_get_sca_data_for_liab');
1061: IGS_GE_MSG_STACK.ADD;
1062: App_Exception.Raise_Exception;
1063: END stapl_get_sca_data_for_liab;
1064: PROCEDURE stapl_ins_govt_sdnt_liab_rec (

Line 1135: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1131: END IF;
1132: END;
1133: EXCEPTION
1134: WHEN OTHERS THEN
1135: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1136: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stapl_ins_govt_sdnt_liab_rec');
1137: IGS_GE_MSG_STACK.ADD;
1138: App_Exception.Raise_Exception;
1139: END stapl_ins_govt_sdnt_liab_rec;

Line 1136: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stapl_ins_govt_sdnt_liab_rec');

1132: END;
1133: EXCEPTION
1134: WHEN OTHERS THEN
1135: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1136: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stapl_ins_govt_sdnt_liab_rec');
1137: IGS_GE_MSG_STACK.ADD;
1138: App_Exception.Raise_Exception;
1139: END stapl_ins_govt_sdnt_liab_rec;
1140:

Line 1361: Fnd_Message.Set_Name('IGS',v_message_name);

1357: || ', p_submission_number- ' || TO_CHAR(p_submission_number)
1358: || ', p_dt_time- ' ||
1359: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
1360: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind;
1361: Fnd_Message.Set_Name('IGS',v_message_name);
1362: IGS_GE_MSG_STACK.ADD;
1363: App_Exception.Raise_Exception;
1364: END IF;
1365: CLOSE c_get_att_type;

Line 1384: Fnd_Message.Set_Name('IGS',v_message_name);

1380: || ', p_submission_number- ' || TO_CHAR(p_submission_number)
1381: || ', p_dt_time- ' ||
1382: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
1383: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind;
1384: Fnd_Message.Set_Name('IGS',v_message_name);
1385: IGS_GE_MSG_STACK.ADD;
1386: App_Exception.Raise_Exception;
1387: END IF;
1388: CLOSE c_get_att_mode_1;

Line 1401: Fnd_Message.Set_Name('IGS',v_message_name);

1397: || ', p_submission_number- ' || TO_CHAR(p_submission_number)
1398: || ', p_dt_time- ' ||
1399: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
1400: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind;
1401: Fnd_Message.Set_Name('IGS',v_message_name);
1402: IGS_GE_MSG_STACK.ADD;
1403: App_Exception.Raise_Exception;
1404: END IF;
1405: CLOSE c_get_att_mode_2;

Line 1418: Fnd_Message.Set_Name('IGS',v_message_name);

1414: || ', p_submission_number- ' || TO_CHAR(p_submission_number)
1415: || ', p_dt_time- ' ||
1416: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
1417: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind;
1418: Fnd_Message.Set_Name('IGS',v_message_name);
1419: IGS_GE_MSG_STACK.ADD;
1420:
1421: App_Exception.Raise_Exception;
1422: END IF;

Line 1468: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

1464: || ', p_ess_snapshot_dt_time- ' ||
1465: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
1466: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind || ' '
1467: || gv_extra_details;
1468: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1469: IGS_GE_MSG_STACK.ADD;
1470:
1471: App_Exception.Raise_Exception;
1472: END IF;

Line 1507: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

1503: || ', p_ess_snapshot_dt_time- ' ||
1504: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
1505: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind || ' '
1506: || gv_extra_details;
1507: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1508: IGS_GE_MSG_STACK.ADD;
1509: App_Exception.Raise_Exception;
1510: END IF;
1511: CLOSE c_alias_val;

Line 1579: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

1575: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
1576: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind || ' '
1577: || gv_extra_details;
1578:
1579: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1580: IGS_GE_MSG_STACK.ADD;
1581: App_Exception.Raise_Exception;
1582: END IF;
1583: IF (v_govt_reportable <> 'N') THEN

Line 1695: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

1691: || ', p_ess_snapshot_dt_time- ' ||
1692: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
1693: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind || ' '
1694: || gv_extra_details;
1695: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1696: IGS_GE_MSG_STACK.ADD;
1697: App_Exception.Raise_Exception;
1698: END IF;
1699: CLOSE c_get_indus_ind;

Line 1778: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1774: X_MODE => 'R');
1775:
1776: EXCEPTION
1777: WHEN OTHERS THEN
1778: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1779: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004. 1');
1780: IGS_GE_MSG_STACK.ADD;
1781: App_Exception.Raise_Exception;
1782: END;

Line 1779: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004. 1');

1775:
1776: EXCEPTION
1777: WHEN OTHERS THEN
1778: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1779: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004. 1');
1780: IGS_GE_MSG_STACK.ADD;
1781: App_Exception.Raise_Exception;
1782: END;
1783: END IF;

Line 1899: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

1895: || ', p_ess_snapshot_dt_time- ' ||
1896: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
1897: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind || ' '
1898: || gv_extra_details;
1899: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1900: IGS_GE_MSG_STACK.ADD;
1901: App_Exception.Raise_Exception;
1902: END IF;
1903: CLOSE c_get_indus_ind;

Line 2129: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

2125: || ', p_dt_time- ' ||
2126: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
2127: || ', p_ind- ' || p_use_most_recent_ess_ind
2128: || ', ' || gv_extra_details;
2129: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
2130: IGS_GE_MSG_STACK.ADD;
2131: App_Exception.Raise_Exception;
2132: END IF;
2133: IF (v_on = TRUE AND

Line 2166: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

2162: || ', p_dt_time- ' ||
2163: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
2164: || ', p_ind- ' || p_use_most_recent_ess_ind
2165: || ', ' || gv_extra_details;
2166: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
2167: IGS_GE_MSG_STACK.ADD;
2168: App_Exception.Raise_Exception;
2169: END IF;
2170: -- update IGS_ST_GOVT_STDNT_EN table

Line 2255: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

2251: || ', p_submission_number- ' || TO_CHAR(p_submission_number)
2252: || ', p_dt_time- ' ||
2253: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
2254: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind;
2255: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
2256: IGS_GE_MSG_STACK.ADD;
2257: App_Exception.Raise_Exception;
2258: END IF;
2259: CLOSE c_att;

Line 2817: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

2813: RAISE;
2814: END;
2815: EXCEPTION
2816: WHEN OTHERS THEN
2817: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2818: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stap_ins_govt_snpsht');
2819: IGS_GE_MSG_STACK.ADD;
2820: App_Exception.Raise_Exception;
2821: END stap_ins_govt_snpsht;

Line 2818: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stap_ins_govt_snpsht');

2814: END;
2815: EXCEPTION
2816: WHEN OTHERS THEN
2817: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2818: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stap_ins_govt_snpsht');
2819: IGS_GE_MSG_STACK.ADD;
2820: App_Exception.Raise_Exception;
2821: END stap_ins_govt_snpsht;
2822:

Line 3767: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

3763: RAISE;
3764: END;
3765: EXCEPTION
3766: WHEN OTHERS THEN
3767: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3768: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stap_ins_gsch');
3769: IGS_GE_MSG_STACK.ADD;
3770: App_Exception.Raise_Exception;
3771: END stap_ins_gsch;

Line 3768: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stap_ins_gsch');

3764: END;
3765: EXCEPTION
3766: WHEN OTHERS THEN
3767: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3768: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stap_ins_gsch');
3769: IGS_GE_MSG_STACK.ADD;
3770: App_Exception.Raise_Exception;
3771: END stap_ins_gsch;
3772:

Line 3805: Fnd_Message.Set_Name('IGS',gv_message_name);

3801: v_log_creation_dt) = FALSE) THEN
3802: ROLLBACK;
3803: p_log_creation_dt := v_log_creation_dt;
3804: -- Output the exception to the job run log.
3805: Fnd_Message.Set_Name('IGS',gv_message_name);
3806: IGS_GE_MSG_STACK.ADD;
3807: App_Exception.Raise_Exception;
3808: END IF;
3809: p_log_creation_dt := v_log_creation_dt;

Line 3813: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

3809: p_log_creation_dt := v_log_creation_dt;
3810: END;
3811: EXCEPTION
3812: WHEN OTHERS THEN
3813: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3814: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stas_ins_govt_snpsht');
3815: IGS_GE_MSG_STACK.ADD;
3816: App_Exception.Raise_Exception;
3817: END stas_ins_govt_snpsht;

Line 3814: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stas_ins_govt_snpsht');

3810: END;
3811: EXCEPTION
3812: WHEN OTHERS THEN
3813: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3814: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_004.stas_ins_govt_snpsht');
3815: IGS_GE_MSG_STACK.ADD;
3816: App_Exception.Raise_Exception;
3817: END stas_ins_govt_snpsht;
3818: