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

Line 127: App_Exception.Raise_Exception;

123: END IF;
124: IF c_note_seq%ISOPEN THEN
125: CLOSE c_note_seq;
126: END IF;
127: App_Exception.Raise_Exception;
128: END;
129: EXCEPTION
130: WHEN OTHERS THEN
131: IF SQLCODE >= cst_lower_limit_err AND

Line 135: App_Exception.Raise_Exception;

131: IF SQLCODE >= cst_lower_limit_err AND
132: SQLCODE <= cst_upper_limit_err THEN
133: p_message_name := 'IGS_PS_FAIL_COPY_UNIT_SET';
134: ELSE
135: App_Exception.Raise_Exception;
136: END IF;
137: END crspl_ins_duplicate_note;
138: --------------SUB-PROCEDURE 2--------------------
139: PROCEDURE crspl_unit_set_note

Line 187: App_Exception.Raise_Exception;

183: IF SQLCODE >= cst_lower_limit_err AND
184: SQLCODE <= cst_upper_limit_err THEN
185: p_message_name := 'IGS_PS_FAIL_COPY_UNIT_SET';
186: ELSE
187: App_Exception.Raise_Exception;
188: END IF;
189: END;
190: END LOOP;
191: EXCEPTION

Line 196: App_Exception.Raise_Exception;

192: WHEN OTHERS THEN
193: IF (c_usn%ISOPEN) THEN
194: CLOSE c_usn;
195: END IF;
196: App_Exception.Raise_Exception;
197: END;
198: EXCEPTION
199: WHEN OTHERS THEN
200: IF SQLCODE >= cst_lower_limit_err AND

Line 204: App_Exception.Raise_Exception;

200: IF SQLCODE >= cst_lower_limit_err AND
201: SQLCODE <= cst_upper_limit_err THEN
202: p_message_name := 'IGS_PS_FAIL_COPY_UNIT_SET';
203: ELSE
204: App_Exception.Raise_Exception;
205: END IF;
206: END crspl_unit_set_note;
207: ------------SUB-PROCEDURE 3-----------------------
208: PROCEDURE crspl_unit_set_crs_type

Line 234: App_Exception.Raise_Exception;

230: IF SQLCODE >= cst_lower_limit_err AND
231: SQLCODE <= cst_upper_limit_err THEN
232: p_message_name := 'IGS_PS_FAIL_COPY_UNIT_SET';
233: ELSE
234: App_Exception.Raise_Exception;
235: END IF;
236: END;
237: END LOOP;
238: EXCEPTION

Line 243: App_Exception.Raise_Exception;

239: WHEN OTHERS THEN
240: IF (c_usct%ISOPEN) THEN
241: CLOSE c_usct;
242: END IF;
243: App_Exception.Raise_Exception;
244: END;
245: EXCEPTION
246: WHEN OTHERS THEN
247: IF SQLCODE >= cst_lower_limit_err AND

Line 251: App_Exception.Raise_Exception;

247: IF SQLCODE >= cst_lower_limit_err AND
248: SQLCODE <= cst_upper_limit_err THEN
249: p_message_name := 'IGS_PS_FAIL_COPY_UNIT_SET';
250: ELSE
251: App_Exception.Raise_Exception;
252: END IF;
253: END crspl_unit_set_crs_type;
254: -----------------SUB-PROCEDURE 4-----------------
255: PROCEDURE crspl_crs_off_unit_set

Line 393: App_Exception.Raise_Exception;

389: IF SQLCODE >= cst_lower_limit_err AND
390: SQLCODE <= cst_upper_limit_err THEN
391: p_message_name := 'IGS_PS_FAIL_COPY_UNIT_SET';
392: ELSE
393: App_Exception.Raise_Exception;
394: END IF;
395: END;
396: END LOOP; --cous
397: EXCEPTION

Line 412: App_Exception.Raise_Exception;

408: END IF;
409: IF (c_coous%ISOPEN) THEN
410: CLOSE c_cousr_sup;
411: END IF;
412: App_Exception.Raise_Exception;
413: END;
414: EXCEPTION
415: WHEN OTHERS THEN
416: IF SQLCODE >= cst_lower_limit_err AND

Line 420: App_Exception.Raise_Exception;

416: IF SQLCODE >= cst_lower_limit_err AND
417: SQLCODE <= cst_upper_limit_err THEN
418: p_message_name := 'IGS_PS_FAIL_COPY_UNIT_SET';
419: ELSE
420: App_Exception.Raise_Exception;
421: END IF;
422: END crspl_crs_off_unit_set;
423: -----------------SUB-PROCEDURE 5-------------------------
424: PROCEDURE crspl_unit_set_rule

Line 456: App_Exception.Raise_Exception;

452: IF SQLCODE >= cst_lower_limit_err AND
453: SQLCODE <= cst_upper_limit_err THEN
454: p_message_name := 'IGS_PS_FAIL_COPY_UNIT_SET';
455: ELSE
456: App_Exception.Raise_Exception;
457: END IF;
458: END;
459: END LOOP;
460: EXCEPTION

Line 465: App_Exception.Raise_Exception;

461: WHEN OTHERS THEN
462: IF (c_usr%ISOPEN) THEN
463: CLOSE c_usr;
464: END IF;
465: App_Exception.Raise_Exception;
466: END;
467: EXCEPTION
468: WHEN OTHERS THEN
469: IF SQLCODE >= cst_lower_limit_err AND

Line 473: App_Exception.Raise_Exception;

469: IF SQLCODE >= cst_lower_limit_err AND
470: SQLCODE <= cst_upper_limit_err THEN
471: p_message_name := 'IGS_PS_FAIL_COPY_UNIT_SET';
472: ELSE
473: App_Exception.Raise_Exception;
474: END IF;
475: END crspl_unit_set_rule;
476: ----------------SUB-PROCEDURE 6---------------------
477: PROCEDURE crspl_coo_adm_cat_unit_set

Line 516: App_Exception.Raise_Exception;

512: IF SQLCODE >= cst_lower_limit_err AND
513: SQLCODE <= cst_upper_limit_err THEN
514: p_message_name := 'IGS_PS_FAIL_COPY_UNIT_SET';
515: ELSE
516: App_Exception.Raise_Exception;
517: END IF;
518: END;
519: END LOOP;
520: EXCEPTION

Line 525: App_Exception.Raise_Exception;

521: WHEN OTHERS THEN
522: IF (c_cacus%ISOPEN) THEN
523: CLOSE c_cacus;
524: END IF;
525: App_Exception.Raise_Exception;
526: END;
527: EXCEPTION
528: WHEN OTHERS THEN
529: IF SQLCODE >= cst_lower_limit_err AND

Line 533: App_Exception.Raise_Exception;

529: IF SQLCODE >= cst_lower_limit_err AND
530: SQLCODE <= cst_upper_limit_err THEN
531: p_message_name := 'IGS_PS_FAIL_COPY_UNIT_SET';
532: ELSE
533: App_Exception.Raise_Exception;
534: END IF;
535: END crspl_coo_adm_cat_unit_set;
536: ----------------- MAIN-------------------------
537: BEGIN

Line 600: App_Exception.Raise_Exception;

596: WHEN OTHERS THEN
597: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
598: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_008.crsp_ins_unit_set');
599: IGS_GE_MSG_STACK.ADD;
600: App_Exception.Raise_Exception;
601: END crsp_ins_unit_set;
602:
603: FUNCTION get_section_status (p_c_src_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE
604: ) RETURN VARCHAR2 AS

Line 768: App_Exception.Raise_Exception;

764: IF SQLCODE >= cst_lower_limit_err AND
765: SQLCODE <= cst_upper_limit_err THEN
766: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
767: ELSE
768: App_Exception.Raise_Exception;
769: END IF;
770: END crspl_ins_duplicate_note;
771:
772: PROCEDURE crspl_ins_unit_ver_note (

Line 812: App_Exception.Raise_Exception;

808: IF SQLCODE >= cst_lower_limit_err AND
809: SQLCODE <= cst_upper_limit_err THEN
810: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
811: ELSE
812: App_Exception.Raise_Exception;
813: END IF;
814: END;
815: END LOOP;
816: EXCEPTION

Line 821: App_Exception.Raise_Exception;

817: WHEN OTHERS THEN
818: IF SQLCODE >= cst_lower_limit_err OR SQLCODE <= cst_upper_limit_err THEN
819: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
820: ELSE
821: App_Exception.Raise_Exception;
822: END IF;
823: END crspl_ins_unit_ver_note;
824: PROCEDURE crspl_ins_unit_offer_note (
825: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,

Line 865: App_Exception.Raise_Exception;

861: IF SQLCODE >= cst_lower_limit_err AND
862: SQLCODE <= cst_upper_limit_err THEN
863: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
864: ELSE
865: App_Exception.Raise_Exception;
866: END IF;
867: END;
868: END LOOP;
869: EXCEPTION

Line 875: App_Exception.Raise_Exception;

871: IF SQLCODE >= cst_lower_limit_err AND
872: SQLCODE <= cst_upper_limit_err THEN
873: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
874: ELSE
875: App_Exception.Raise_Exception;
876: END IF;
877: END crspl_ins_unit_offer_note;
878: PROCEDURE crspl_ins_teach_resp (
879: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,

Line 907: App_Exception.Raise_Exception;

903: IF SQLCODE >= cst_lower_limit_err AND
904: SQLCODE <= cst_upper_limit_err THEN
905: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
906: ELSE
907: App_Exception.Raise_Exception;
908: END IF;
909: END;
910: END LOOP;
911: EXCEPTION

Line 917: App_Exception.Raise_Exception;

913: IF SQLCODE >= cst_lower_limit_err AND
914: SQLCODE <= cst_upper_limit_err THEN
915: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
916: ELSE
917: App_Exception.Raise_Exception;
918: END IF;
919: END crspl_ins_teach_resp;
920: PROCEDURE crspl_ins_unit_discipline (
921: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,

Line 948: App_Exception.Raise_Exception;

944: IF SQLCODE >= cst_lower_limit_err AND
945: SQLCODE <= cst_upper_limit_err THEN
946: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
947: ELSE
948: App_Exception.Raise_Exception;
949: END IF;
950: END;
951: END LOOP;
952: EXCEPTION

Line 958: App_Exception.Raise_Exception;

954: IF SQLCODE >= cst_lower_limit_err AND
955: SQLCODE <= cst_upper_limit_err THEN
956: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
957: ELSE
958: App_Exception.Raise_Exception;
959: END IF;
960: END crspl_ins_unit_discipline;
961: PROCEDURE crspl_ins_unit_categorisation (
962: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,

Line 994: App_Exception.Raise_Exception;

990: IF SQLCODE >= cst_lower_limit_err AND
991: SQLCODE <= cst_upper_limit_err THEN
992: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
993: ELSE
994: App_Exception.Raise_Exception;
995: END IF;
996: END;
997: END LOOP;
998: EXCEPTION

Line 1004: App_Exception.Raise_Exception;

1000: IF SQLCODE >= cst_lower_limit_err AND
1001: SQLCODE <= cst_upper_limit_err THEN
1002: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
1003: ELSE
1004: App_Exception.Raise_Exception;
1005: END IF;
1006: END crspl_ins_unit_categorisation;
1007: PROCEDURE crspl_ins_crs_unit_lvl (
1008: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,

Line 1045: App_Exception.Raise_Exception;

1041: IF SQLCODE >= cst_lower_limit_err AND
1042: SQLCODE <= cst_upper_limit_err THEN
1043: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
1044: ELSE
1045: App_Exception.Raise_Exception;
1046: END IF;
1047: END;
1048: END LOOP;
1049: EXCEPTION

Line 1055: App_Exception.Raise_Exception;

1051: IF SQLCODE >= cst_lower_limit_err AND
1052: SQLCODE <= cst_upper_limit_err THEN
1053: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
1054: ELSE
1055: App_Exception.Raise_Exception;
1056: END IF;
1057: END crspl_ins_crs_unit_lvl;
1058: PROCEDURE crspl_ins_unit_ref_cd (
1059: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,

Line 1087: App_Exception.Raise_Exception;

1083: IF SQLCODE >= cst_lower_limit_err AND
1084: SQLCODE <= cst_upper_limit_err THEN
1085: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
1086: ELSE
1087: App_Exception.Raise_Exception;
1088: END IF;
1089: END;
1090: END LOOP;
1091: EXCEPTION

Line 1097: App_Exception.Raise_Exception;

1093: IF SQLCODE >= cst_lower_limit_err AND
1094: SQLCODE <= cst_upper_limit_err THEN
1095: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
1096: ELSE
1097: App_Exception.Raise_Exception;
1098: END IF;
1099: END crspl_ins_unit_ref_cd;
1100: PROCEDURE crspl_ins_unit_off_opt_note (
1101: p_exist_uoo_id IN IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE,

Line 1146: App_Exception.Raise_Exception;

1142: IF SQLCODE >= cst_lower_limit_err AND
1143: SQLCODE <= cst_upper_limit_err THEN
1144: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
1145: ELSE
1146: App_Exception.Raise_Exception;
1147: END IF;
1148: END;
1149: END LOOP;
1150: EXCEPTION

Line 1156: App_Exception.Raise_Exception;

1152: IF SQLCODE >= cst_lower_limit_err AND
1153: SQLCODE <= cst_upper_limit_err THEN
1154: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
1155: ELSE
1156: App_Exception.Raise_Exception;
1157: END IF;
1158: END crspl_ins_unit_off_opt_note;
1159: PROCEDURE crspl_ins_teach_resp_ovrd(
1160: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,

Line 1212: App_Exception.Raise_Exception;

1208: IF SQLCODE >= cst_lower_limit_err AND
1209: SQLCODE <= cst_upper_limit_err THEN
1210: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
1211: ELSE
1212: App_Exception.Raise_Exception;
1213: END IF;
1214: END;
1215: END LOOP;
1216: EXCEPTION

Line 1222: App_Exception.Raise_Exception;

1218: IF SQLCODE >= cst_lower_limit_err AND
1219: SQLCODE <= cst_upper_limit_err THEN
1220: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
1221: ELSE
1222: App_Exception.Raise_Exception;
1223: END IF;
1224: END crspl_ins_teach_resp_ovrd;
1225:
1226:

Line 1530: App_Exception.Raise_Exception;

1526: ELSE
1527: IF (c_latest_gs_version%ISOPEN) THEN
1528: CLOSE c_latest_gs_version;
1529: END IF;
1530: App_Exception.Raise_Exception;
1531: END IF;
1532: END;
1533: END LOOP;
1534: EXCEPTION

Line 1543: App_Exception.Raise_Exception;

1539: ELSE
1540: IF (c_latest_gs_version%ISOPEN) THEN
1541: CLOSE c_latest_gs_version;
1542: END IF;
1543: App_Exception.Raise_Exception;
1544: END IF;
1545: END crspl_ins_unit_off_opt;
1546:
1547: PROCEDURE crspl_ins_unit_assmnt_item (

Line 1680: App_Exception.Raise_Exception;

1676: ELSIF SQLCODE >= cst_lower_limit_err AND
1677: SQLCODE <= cst_upper_limit_err THEN
1678: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
1679: ELSE
1680: App_Exception.Raise_Exception;
1681: END IF;
1682: END;
1683: END LOOP;
1684:

Line 1691: App_Exception.Raise_Exception;

1687: IF SQLCODE >= cst_lower_limit_err AND
1688: SQLCODE <= cst_upper_limit_err THEN
1689: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
1690: ELSE
1691: App_Exception.Raise_Exception;
1692: END IF;
1693: END;
1694: END LOOP;
1695:

Line 1703: App_Exception.Raise_Exception;

1699: IF SQLCODE >= cst_lower_limit_err AND
1700: SQLCODE <= cst_upper_limit_err THEN
1701: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
1702: ELSE
1703: App_Exception.Raise_Exception;
1704: END IF;
1705: END crspl_ins_unit_assmnt_item;
1706: PROCEDURE crspl_ins_unit_off_pat_note(
1707: p_unit_cd IN IGS_PS_UNT_OFR_PAT_N.unit_cd%TYPE,

Line 1752: App_Exception.Raise_Exception;

1748: IF SQLCODE >= cst_lower_limit_err AND
1749: SQLCODE <= cst_upper_limit_err THEN
1750: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
1751: ELSE
1752: App_Exception.Raise_Exception;
1753: END IF;
1754: END;
1755: END LOOP;
1756: EXCEPTION

Line 1762: App_Exception.Raise_Exception;

1758: IF SQLCODE >= cst_lower_limit_err AND
1759: SQLCODE <= cst_upper_limit_err THEN
1760: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
1761: ELSE
1762: App_Exception.Raise_Exception;
1763: END IF;
1764: END crspl_ins_unit_off_pat_note;
1765:
1766: /* Procedure : crspl_uofr_wlst_details

Line 1833: App_Exception.Raise_Exception;

1829: IF SQLCODE >= cst_lower_limit_err AND
1830: SQLCODE <= cst_upper_limit_err THEN
1831: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
1832: ELSE
1833: App_Exception.Raise_Exception;
1834: END IF;
1835: END crspl_uofr_wlist_details;
1836:
1837: PROCEDURE crspl_ins_unit_off_pat (

Line 1929: App_Exception.Raise_Exception;

1925: ELSE
1926: IF (c_unit_offer_pat_rec%ISOPEN) THEN
1927: CLOSE c_unit_offer_pat_rec;
1928: END IF;
1929: App_Exception.Raise_Exception;
1930: END IF;
1931: END crspl_ins_unit_off_pat;
1932: PROCEDURE crspl_ins_unit_offer (
1933: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,

Line 1966: App_Exception.Raise_Exception;

1962: IF SQLCODE >= cst_lower_limit_err AND
1963: SQLCODE <= cst_upper_limit_err THEN
1964: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
1965: ELSE
1966: App_Exception.Raise_Exception;
1967: END IF;
1968: END;
1969: END LOOP;
1970: EXCEPTION

Line 1976: App_Exception.Raise_Exception;

1972: IF SQLCODE >= cst_lower_limit_err AND
1973: SQLCODE <= cst_upper_limit_err THEN
1974: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
1975: ELSE
1976: App_Exception.Raise_Exception;
1977: END IF;
1978: END crspl_ins_unit_offer;
1979:
1980:

Line 2019: App_Exception.Raise_Exception;

2015: IF SQLCODE >= cst_lower_limit_err AND
2016: SQLCODE <= cst_upper_limit_err THEN
2017: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
2018: ELSE
2019: App_Exception.Raise_Exception;
2020: END IF;
2021: END crspl_ins_location_details;
2022:
2023: /* Procedure : crspl_ins_facility_details

Line 2059: App_Exception.Raise_Exception;

2055: IF SQLCODE >= cst_lower_limit_err AND
2056: SQLCODE <= cst_upper_limit_err THEN
2057: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
2058: ELSE
2059: App_Exception.Raise_Exception;
2060: END IF;
2061: END crspl_ins_facility_details;
2062:
2063: /* Procedure : crspl_ins_cros_ref_details

Line 2100: App_Exception.Raise_Exception;

2096: IF SQLCODE >= cst_lower_limit_err AND
2097: SQLCODE <= cst_upper_limit_err THEN
2098: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
2099: ELSE
2100: App_Exception.Raise_Exception;
2101: END IF;
2102: END crspl_ins_cros_ref_details;
2103:
2104:

Line 2143: App_Exception.Raise_Exception;

2139: IF SQLCODE >= cst_lower_limit_err AND
2140: SQLCODE <= cst_upper_limit_err THEN
2141: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
2142: ELSE
2143: App_Exception.Raise_Exception;
2144: END IF;
2145: END crspl_ins_grd_schm_details;
2146:
2147:

Line 2184: App_Exception.Raise_Exception;

2180: IF SQLCODE >= cst_lower_limit_err AND
2181: SQLCODE <= cst_upper_limit_err THEN
2182: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
2183: ELSE
2184: App_Exception.Raise_Exception;
2185: END IF;
2186: END crspl_ins_unt_fld_details;
2187:
2188: --removed the procedure CRSP_INS_UNIT_REVSEG by vvutukur as part of enh#2831572.

Line 2255: App_Exception.Raise_Exception;

2251: IF SQLCODE >= cst_lower_limit_err AND
2252: SQLCODE <= cst_upper_limit_err THEN
2253: p_message_name := 'IGS_PS_FAIL_COPY_PRGVERDETAIL';
2254: ELSE
2255: App_Exception.Raise_Exception;
2256: END IF;
2257: END crsp_ins_appr_ass_itm_grd;
2258:
2259: BEGIN

Line 2411: app_exception.raise_exception;

2407: IF l_status = 2 THEN -- ie. The procedure call has resulted in error.
2408:
2409: fnd_message.set_name('IGS', p_message_name);
2410: IGS_GE_MSG_STACK.ADD;
2411: app_exception.raise_exception;
2412:
2413: END IF;
2414:
2415: END IF;

Line 2426: App_Exception.Raise_Exception;

2422: END IF;
2423: IF (c_old_unit_vers_rec%ISOPEN) THEN
2424: CLOSE c_old_unit_vers_rec;
2425: END IF;
2426: App_Exception.Raise_Exception;
2427: END;
2428: EXCEPTION
2429: WHEN OTHERS THEN
2430: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

Line 2433: App_Exception.Raise_Exception;

2429: WHEN OTHERS THEN
2430: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2431: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_008.crsp_ins_unit_ver');
2432: IGS_GE_MSG_STACK.ADD;
2433: App_Exception.Raise_Exception;
2434: END crsp_ins_unit_ver;
2435:
2436:
2437:

Line 3853: App_Exception.Raise_Exception;

3849: END IF;
3850: IF c_uoo_seq_num%ISOPEN THEN
3851: CLOSE c_uoo_seq_num;
3852: END IF;
3853: App_Exception.Raise_Exception;
3854: END;
3855:
3856: -- jbegum As part of bug#2563596 the call to IGS_GE_GEN_003.genp_ins_log_entry was modified .
3857: -- The concatenated string being passed to parameter p_key has the substring FND_MESSAGE.GET_STRING('IGS', p_message_name)