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.IGS_ST_GEN_004 dependencies on APP_EXCEPTION

Line 98: App_Exception.Raise_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:
101: Function Stap_Get_Tot_Exmpt(
102: p_person_id IN NUMBER ,

Line 145: App_Exception.Raise_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:
148: Function Stap_Get_Un_Comp_Sts(
149: p_person_id IN NUMBER ,

Line 214: App_Exception.Raise_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:
217:
218: Function Stap_Ins_Govt_Snpsht(

Line 755: App_Exception.Raise_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(
758: p_sub_yr IGS_ST_GVT_STDNTLOAD.submission_yr%TYPE,
759: p_sub_number IGS_ST_GVT_STDNTLOAD.submission_number%TYPE,

Line 835: App_Exception.Raise_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(
838: p_current_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,
839: -- current person_id

Line 906: App_Exception.Raise_Exception;

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;
909: IF (p_birth_dt IS NULL) THEN
910: IF (p_logged_ind = FALSE) THEN

Line 1041: App_Exception.Raise_Exception;

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
1043: IF c_get_person_dtls%ISOPEN THEN
1044: CLOSE c_get_person_dtls;
1045: END IF;

Line 1062: App_Exception.Raise_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 (
1065: p_sub_yr IGS_ST_GVT_STDNT_LBL.submission_yr%TYPE,
1066: p_sub_number IGS_ST_GVT_STDNT_LBL.submission_number%TYPE,

Line 1138: App_Exception.Raise_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:
1141: BEGIN -- main
1142: -- This process is used to create a snapshot of

Line 1363: App_Exception.Raise_Exception;

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;
1366: -- set the attendance mode values
1367: -- retrieve the first record only from each

Line 1386: App_Exception.Raise_Exception;

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;
1389: -- external attendance mode
1390: OPEN c_get_att_mode_2;

Line 1403: App_Exception.Raise_Exception;

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;
1406: -- multi-modal attendance mode
1407: OPEN c_get_att_mode_3;

Line 1421: App_Exception.Raise_Exception;

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;
1423: CLOSE c_get_att_mode_3;
1424:
1425:

Line 1471: App_Exception.Raise_Exception;

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;
1473: END IF;
1474: IF (p_submission_number = 1 OR
1475: (p_submission_number = 2 AND

Line 1509: App_Exception.Raise_Exception;

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;
1512: END IF;
1513: -- determine if the record is government

Line 1581: App_Exception.Raise_Exception;

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
1584: -- government student enrolment records
1585: -- are created in submission 1 only.

Line 1697: App_Exception.Raise_Exception;

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;
1700: END IF;
1701: -- determine the IGS_PS_UNIT completion status

Line 1781: App_Exception.Raise_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;
1784: -- create the government student load record
1785: stapl_ins_govt_sdnt_load_rec(

Line 1901: App_Exception.Raise_Exception;

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;
1904: END IF;
1905: -- determine the IGS_PS_UNIT completion status

Line 2131: App_Exception.Raise_Exception;

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
2134: v_off = TRUE) THEN
2135: v_composite := TRUE;

Line 2168: App_Exception.Raise_Exception;

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
2171: BEGIN
2172: FOR v_gse_upd3_rec IN c_gse_upd3(

Line 2257: App_Exception.Raise_Exception;

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;
2260: -- select records from IGS_ST_GOVT_STDNT_EN which
2261: -- the SUM(eftsu) is greater than the lower_enr_load_range

Line 2820: App_Exception.Raise_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:
2823: Procedure Stap_Ins_Gsch(
2824: p_submission_yr IN NUMBER ,

Line 3770: App_Exception.Raise_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:
3773:
3774: Procedure Stas_Ins_Govt_Snpsht(

Line 3807: App_Exception.Raise_Exception;

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;
3810: END;
3811: EXCEPTION

Line 3816: App_Exception.Raise_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:
3819: END IGS_ST_GEN_004;