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_GR_GEN_002 dependencies on APP_EXCEPTION

Line 251: --App_Exception.Raise_Exception;

247: FETCH c_gst INTO v_gst_rec;
248: IF c_gst%NOTFOUND THEN
249: CLOSE c_gst;
250: Fnd_Message.Set_Name('IGS', 'IGS_GE_INVALID_VALUE');
251: --App_Exception.Raise_Exception;
252: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151
253: RETURN;
254: END IF;
255: CLOSE c_gst;

Line 258: --App_Exception.Raise_Exception;

254: END IF;
255: CLOSE c_gst;
256: IF v_gst_rec.closed_ind = 'Y' THEN
257: Fnd_Message.Set_Name('IGS', 'IGS_GR_GRAD_STATUS_CLOSED');
258: --App_Exception.Raise_Exception;
259: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151
260: RETURN;
261: END IF;
262: -- Validate the eligible IGS_GR_GRADUAND status value

Line 270: --App_Exception.Raise_Exception;

266: FETCH c_gst INTO v_gst_rec;
267: IF c_gst%NOTFOUND THEN
268: CLOSE c_gst;
269: Fnd_Message.Set_Name('IGS', 'IGS_GE_INVALID_VALUE');
270: --App_Exception.Raise_Exception;
271: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151
272: RETURN;
273: END IF;
274: CLOSE c_gst;

Line 277: --App_Exception.Raise_Exception;

273: END IF;
274: CLOSE c_gst;
275: IF v_gst_rec.closed_ind = 'Y' THEN
276: Fnd_Message.Set_Name('IGS', 'IGS_GR_GRAD_STATUS_CLOSED');
277: --App_Exception.Raise_Exception;
278: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151
279: RETURN;
280: END IF;
281: -- Validate the IGS_GR_GRADUAND approval status value

Line 287: --App_Exception.Raise_Exception;

283: FETCH c_gas INTO v_gas_rec;
284: IF c_gas%NOTFOUND THEN
285: CLOSE c_gas;
286: Fnd_Message.Set_Name('IGS', 'IGS_GE_INVALID_VALUE');
287: --App_Exception.Raise_Exception;
288: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151
289: RETURN;
290: END IF;
291: CLOSE c_gas;

Line 294: --App_Exception.Raise_Exception;

290: END IF;
291: CLOSE c_gas;
292: IF v_gas_rec.closed_ind = 'Y' THEN
293: Fnd_Message.Set_Name('IGS', 'IGS_GR_GRAD_APPR_STATUS_CLOSE');
294: --App_Exception.Raise_Exception;
295: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151
296: RETURN;
297: END IF;
298: EXCEPTION

Line 311: App_Exception.Raise_Exception;

307: END;
308: EXCEPTION
309: WHEN OTHERS THEN
310: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
311: App_Exception.Raise_Exception;
312: END grdpl_val_graduand_status;
313: -------------------------------------------------------------------
314: PROCEDURE grdpl_ins_new_graduand(
315: p_person_id igs_en_stdnt_ps_att.person_id%TYPE,

Line 638: App_Exception.Raise_Exception;

634: END;
635: EXCEPTION
636: WHEN OTHERS THEN
637: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
638: App_Exception.Raise_Exception;
639: END grdpl_ins_new_graduand;
640: -------------------------------------------------------------------
641: BEGIN
642: -- 1. Check parameters

Line 654: --App_Exception.Raise_Exception;

650: p_potential_graduand_status IS NULL OR
651: p_eligible_graduand_status IS NULL OR
652: p_graduand_appr_status IS NULL THEN
653: Fnd_Message.Set_Name('IGS', 'IGS_GE_INVALID_VALUE');
654: --App_Exception.Raise_Exception;
655: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151
656: RETURN;
657: END IF;
658: -- Validate completion criterion

Line 662: --App_Exception.Raise_Exception;

658: -- Validate completion criterion
659: IF p_nominated_completion = 'N' AND
660: p_derived_completion = 'N' THEN
661: Fnd_Message.Set_Name('IGS', 'IGS_GR_NOMIN_DERV_COMPL_SET');
662: --App_Exception.Raise_Exception;
663: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151
664: RETURN;
665: END IF;
666: --

Line 995: App_Exception.Raise_Exception;

991: END;
992: EXCEPTION
993: WHEN OTHERS THEN
994: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
995: App_Exception.Raise_Exception;
996: END grdp_ins_gr_hist;
997:
998:
999: PROCEDURE grdp_prc_gac(

Line 1141: App_Exception.Raise_Exception;

1137: p_graduand_status IS NULL OR
1138: p_resolve_stalemate_type IS NULL OR
1139: p_ignore_unit_sets_ind IS NULL THEN
1140: Fnd_Message.Set_Name('IGS', 'IGS_GE_INSUFFICIENT_PARAMETER');
1141: App_Exception.Raise_Exception;
1142: END IF;
1143: -- 2.1 Find any closed IGS_GR_AWD_CEREMONY records for the specified
1144: -- IGS_GR_CRMN_ROUND and loop through them.
1145: FOR v_awc_rec IN c_awc LOOP

Line 1159: App_Exception.Raise_Exception;

1155: p_resolve_stalemate_type,
1156: p_ignore_unit_sets_ind,
1157: v_message_name) = FALSE THEN
1158: Fnd_Message.Set_Name('IGS', v_message_name);
1159: App_Exception.Raise_Exception;
1160: END IF;
1161: END LOOP; -- c_awc
1162: -- 3.1 Find closed IGS_GR_AWD_CRM_US_GP records for the specified
1163: -- IGS_GR_CRMN_ROUND and loop through them.

Line 1179: App_Exception.Raise_Exception;

1175: p_resolve_stalemate_type,
1176: p_ignore_unit_sets_ind,
1177: v_message_name) = FALSE THEN
1178: Fnd_Message.Set_Name('IGS', v_message_name);
1179: App_Exception.Raise_Exception;
1180: END IF;
1181: END LOOP; -- c_acusg
1182: -- 4.1 Find any IGS_GR_GRADUAND records matching the IGS_GR_CRMN_ROUND, location_cd
1183: -- and IGS_GR_STAT specified which do not have an existing

Line 1251: App_Exception.Raise_Exception;

1247: CLOSE c_gr_upd;
1248: END IF;
1249: ROLLBACK TO sp_prc_gac;
1250: Fnd_Message.Set_Name('IGS', 'IGS_GR_CANNOT_UPDATE_GRAD_REC');
1251: App_Exception.Raise_Exception;
1252: WHEN OTHERS THEN
1253: ROLLBACK TO sp_prc_gac;
1254: RAISE;
1255: END;

Line 1279: App_Exception.Raise_Exception;

1275: p_resolve_stalemate_type,
1276: p_ignore_unit_sets_ind,
1277: v_message_name) = FALSE THEN
1278: Fnd_Message.Set_Name('IGS', v_message_name);
1279: App_Exception.Raise_Exception;
1280: END IF;
1281: -- 4.4 If the IGS_GR_GRADUAND has been deferred into this IGS_GR_CRMN_ROUND and they
1282: -- have not been placed in a ceremony, ROLLBACK the change to the
1283: -- s_graduand_type to DEFERRED. If they were placed in a ceremony round

Line 1802: --App_Exception.Raise_Exception;

1798: p_order_by IS NULL OR
1799: p_ignore_unit_sets_ind IS NULL OR
1800: p_group_multi_award_ind IS NULL THEN
1801: Fnd_Message.Set_Name('IGS', 'IGS_GE_INSUFFICIENT_PARAMETER');
1802: --App_Exception.Raise_Exception;
1803: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2691809
1804: RETURN;
1805: END IF;
1806: --2. Loop through all of the IGS_GR_CRMN records

Line 1817: --App_Exception.Raise_Exception;

1813: IF c_awc%FOUND THEN
1814: --4. If any records are found raise an error.
1815: CLOSE c_awc;
1816: Fnd_Message.Set_Name('IGS', 'IGS_GR_AWD_CERM_REC_CLOSED');
1817: --App_Exception.Raise_Exception;
1818: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2691809
1819: RETURN;
1820: END IF;
1821: CLOSE c_awc;

Line 1831: --App_Exception.Raise_Exception;

1827: IF c_acusg%FOUND THEN
1828: --6. If any records are found raise an error.
1829: CLOSE c_acusg;
1830: Fnd_Message.Set_Name('IGS', 'IGS_GR_AWD_CERM_UNIT_SET_CLOS');
1831: --App_Exception.Raise_Exception;
1832: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2691809
1833: RETURN;
1834: END IF;
1835: CLOSE c_acusg;

Line 1890: --App_Exception.Raise_Exception;

1886: CLOSE c_gac_del;
1887: END IF;
1888: ROLLBACK TO sp_gac_del;
1889: Fnd_Message.Set_Name('IGS', 'IGS_GR_AWD_CERM_CANNOT_UPDATE');
1890: --App_Exception.Raise_Exception;
1891: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2691809
1892: WHEN OTHERS THEN
1893: ROLLBACK TO sp_gac_del;
1894: l_msg_text := fnd_message.get;

Line 2222: --App_Exception.Raise_Exception;

2218: END IF;
2219: DBMS_SQL.CLOSE_CURSOR(v_gac_upd_c_handle);
2220: ROLLBACK TO sp_gac_upd;
2221: FND_MESSAGE.SET_NAME('IGS', 'IGS_GR_AWD_CERM_CANNOT_UPDATE');
2222: --App_Exception.Raise_Exception;
2223: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2691809
2224: RETURN;
2225: WHEN OTHERS THEN
2226: ROLLBACK TO sp_gac_upd;