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_AD_GEN_002 dependencies on IGS_GE_MSG_STACK

Line 125: IGS_GE_MSG_STACK.ADD;

121: EXCEPTION
122: WHEN OTHERS THEN
123: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
124: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_chk_non_num');
125: IGS_GE_MSG_STACK.ADD;
126: App_Exception.Raise_Exception;
127: END admpl_chk_non_num;
128: ---------------
129: ---------------

Line 157: IGS_GE_MSG_STACK.ADD;

153: EXCEPTION
154: WHEN OTHERS THEN
155: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
156: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_strip_non_alpha');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END admpl_strip_non_alpha;
160: ---------------
161: ---------------

Line 185: IGS_GE_MSG_STACK.ADD;

181: EXCEPTION
182: WHEN OTHERS THEN
183: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
184: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_strip_spaces');
185: IGS_GE_MSG_STACK.ADD;
186: App_Exception.Raise_Exception;
187: END admpl_strip_spaces;
188: ---------------
189: ---------------

Line 270: IGS_GE_MSG_STACK.ADD;

266: EXCEPTION
267: WHEN OTHERS THEN
268: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
269: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_store_matched_table');
270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: END admpl_store_matched_table;
273: ---------------
274: ---------------

Line 303: IGS_GE_MSG_STACK.ADD;

299: EXCEPTION
300: WHEN OTHERS THEN
301: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
302: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria11');
303: IGS_GE_MSG_STACK.ADD;
304: App_Exception.Raise_Exception;
305: END admpl_match_criteria11;
306: ---------------
307: ---------------

Line 333: IGS_GE_MSG_STACK.ADD;

329: EXCEPTION
330: WHEN OTHERS THEN
331: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
332: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria10');
333: IGS_GE_MSG_STACK.ADD;
334: App_Exception.Raise_Exception;
335: END admpl_match_criteria10;
336: ---------------
337: ---------------

Line 393: IGS_GE_MSG_STACK.ADD;

389: EXCEPTION
390: WHEN OTHERS THEN
391: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
392: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria9');
393: IGS_GE_MSG_STACK.ADD;
394: App_Exception.Raise_Exception;
395: END admpl_match_criteria9;
396: ---------------
397: ---------------

Line 435: IGS_GE_MSG_STACK.ADD;

431: EXCEPTION
432: WHEN OTHERS THEN
433: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
434: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria8');
435: IGS_GE_MSG_STACK.ADD;
436: App_Exception.Raise_Exception;
437: END admpl_match_criteria8;
438: ---------------
439: ---------------

Line 496: IGS_GE_MSG_STACK.ADD;

492: EXCEPTION
493: WHEN OTHERS THEN
494: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
495: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria7');
496: IGS_GE_MSG_STACK.ADD;
497: App_Exception.Raise_Exception;
498: END admpl_match_criteria7;
499: ---------------
500: ---------------

Line 541: IGS_GE_MSG_STACK.ADD;

537: EXCEPTION
538: WHEN OTHERS THEN
539: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
540: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria6');
541: IGS_GE_MSG_STACK.ADD;
542: App_Exception.Raise_Exception;
543: END admpl_match_criteria6;
544: ---------------
545: ---------------

Line 575: IGS_GE_MSG_STACK.ADD;

571: EXCEPTION
572: WHEN OTHERS THEN
573: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
574: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria5');
575: IGS_GE_MSG_STACK.ADD;
576: App_Exception.Raise_Exception;
577: END admpl_match_criteria5;
578: ---------------
579: ---------------

Line 611: IGS_GE_MSG_STACK.ADD;

607: EXCEPTION
608: WHEN OTHERS THEN
609: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
610: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria4a');
611: IGS_GE_MSG_STACK.ADD;
612: App_Exception.Raise_Exception;
613: END admpl_match_criteria4a;
614: ---------------
615: ---------------

Line 679: IGS_GE_MSG_STACK.ADD;

675: EXCEPTION
676: WHEN OTHERS THEN
677: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
678: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria4');
679: IGS_GE_MSG_STACK.ADD;
680: App_Exception.Raise_Exception;
681: END admpl_match_criteria4;
682: ---------------
683: ---------------

Line 730: IGS_GE_MSG_STACK.ADD;

726: EXCEPTION
727: WHEN OTHERS THEN
728: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
729: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria3');
730: IGS_GE_MSG_STACK.ADD;
731: App_Exception.Raise_Exception;
732: END admpl_match_criteria3;
733: ---------------
734: ---------------

Line 801: IGS_GE_MSG_STACK.ADD;

797: EXCEPTION
798: WHEN OTHERS THEN
799: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
800: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria2');
801: IGS_GE_MSG_STACK.ADD;
802: App_Exception.Raise_Exception;
803: END admpl_match_criteria2;
804: ---------------
805: ---------------

Line 853: IGS_GE_MSG_STACK.ADD;

849: EXCEPTION
850: WHEN OTHERS THEN
851: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
852: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria1');
853: IGS_GE_MSG_STACK.ADD;
854: App_Exception.Raise_Exception;
855: END admpl_match_criteria1;
856: ---------------
857: ---------------

Line 910: IGS_GE_MSG_STACK.ADD;

906: EXCEPTION
907: WHEN OTHERS THEN
908: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
909: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_any_name');
910: IGS_GE_MSG_STACK.ADD;
911: App_Exception.Raise_Exception;
912: END admpl_match_any_name;
913: ---------------
914: ---------------

Line 952: IGS_GE_MSG_STACK.ADD;

948: EXCEPTION
949: WHEN OTHERS THEN
950: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
951: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_loose_name');
952: IGS_GE_MSG_STACK.ADD;
953: App_Exception.Raise_Exception;
954: END admpl_match_loose_name;
955: ---------------
956: ---------------

Line 977: IGS_GE_MSG_STACK.ADD;

973: EXCEPTION
974: WHEN OTHERS THEN
975: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
976: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_exact_name');
977: IGS_GE_MSG_STACK.ADD;
978: App_Exception.Raise_Exception;
979: END admpl_match_exact_name;
980: ---------------
981: ---------------

Line 1042: IGS_GE_MSG_STACK.ADD;

1038: EXCEPTION
1039: WHEN OTHERS THEN
1040: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1041: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_any_id');
1042: IGS_GE_MSG_STACK.ADD;
1043: App_Exception.Raise_Exception;
1044: END admpl_match_any_id;
1045: ---------------
1046: ---------------

Line 1079: IGS_GE_MSG_STACK.ADD;

1075: EXCEPTION
1076: WHEN OTHERS THEN
1077: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1078: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_exact_id');
1079: IGS_GE_MSG_STACK.ADD;
1080: App_Exception.Raise_Exception;
1081: END admpl_match_exact_id;
1082: ---------------
1083: ---------------

Line 1137: IGS_GE_MSG_STACK.ADD;

1133: EXCEPTION
1134: WHEN OTHERS THEN
1135: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1136: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_standard_6');
1137: IGS_GE_MSG_STACK.ADD;
1138: App_Exception.Raise_Exception;
1139: END admpl_match_standard_6;
1140: PROCEDURE admpl_match_standard (
1141: p_convert_id IN IGS_PE_PERSON.person_id%TYPE,

Line 1228: IGS_GE_MSG_STACK.ADD;

1224: EXCEPTION
1225: WHEN OTHERS THEN
1226: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1227: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_standard');
1228: IGS_GE_MSG_STACK.ADD;
1229: App_Exception.Raise_Exception;
1230: END admpl_match_standard;
1231: ---------------
1232: ---------------

Line 1280: IGS_GE_MSG_STACK.ADD;

1276: EXCEPTION
1277: WHEN OTHERS THEN
1278: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1279: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_write_course_header');
1280: IGS_GE_MSG_STACK.ADD;
1281: App_Exception.Raise_Exception;
1282: END admpl_write_course_header;
1283: PROCEDURE admpl_write_student_details (
1284: p_matched_id IN r_matched_id_rec.person_id%TYPE,

Line 1789: IGS_GE_MSG_STACK.ADD;

1785: EXCEPTION
1786: WHEN OTHERS THEN
1787: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1788: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_write_student_details');
1789: IGS_GE_MSG_STACK.ADD;
1790: App_Exception.Raise_Exception;
1791: END admpl_write_student_details;
1792: FUNCTION admpl_prc_previous_header (
1793: p_previous_name_records_cnt IN NUMBER,

Line 1992: IGS_GE_MSG_STACK.ADD;

1988: v_convert_birth_dt,
1989: p_number_of_matches);
1990: ELSE
1991: Fnd_Message.Set_Name('IGS','IGS_AD_UNEXPECTED_MATCH_LEVEL');
1992: IGS_GE_MSG_STACK.ADD;
1993: RETURN FALSE;
1994: END IF;
1995: -- Now we have to work out NOCOPY te number_of_matches.
1996: -- Using the matching routines above, we can write

Line 2050: IGS_GE_MSG_STACK.ADD;

2046: EXCEPTION
2047: WHEN OTHERS THEN
2048: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2049: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_prc_previous_header');
2050: IGS_GE_MSG_STACK.ADD;
2051: App_Exception.Raise_Exception;
2052: END admpl_prc_previous_header;
2053: ---------------
2054: ---------------

Line 2095: IGS_GE_MSG_STACK.ADD;

2091: EXCEPTION
2092: WHEN OTHERS THEN
2093: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2094: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_store_rec');
2095: IGS_GE_MSG_STACK.ADD;
2096: App_Exception.Raise_Exception;
2097: END admpl_store_rec;
2098: ---------------
2099: ---------------

Line 2116: IGS_GE_MSG_STACK.ADD;

2112: IF (v_first_char = 'H') THEN
2113: p_record_type := 'H';
2114: IF (LENGTH(v_input_string) <> 157) THEN
2115: Fnd_Message.Set_Name('IGS','IGS_AD_HDR_REC_LEN_NOT_CORRECT');
2116: IGS_GE_MSG_STACK.ADD;
2117: p_record_type := 'X';
2118: END IF;
2119: ELSIF (v_first_char = 'P') THEN
2120: p_record_type := 'P';

Line 2123: IGS_GE_MSG_STACK.ADD;

2119: ELSIF (v_first_char = 'P') THEN
2120: p_record_type := 'P';
2121: IF (LENGTH(v_input_string) <> 51) THEN
2122: Fnd_Message.Set_Name('IGS','IGS_AD_PRE_NM_REC_LEN_NOT_CRCT');
2123: IGS_GE_MSG_STACK.ADD;
2124: p_record_type:= 'X';
2125: END IF;
2126: ELSE
2127: Fnd_Message.Set_Name('IGS','IGS_GE_UNKNOWN_REC_TYPE');

Line 2128: IGS_GE_MSG_STACK.ADD;

2124: p_record_type:= 'X';
2125: END IF;
2126: ELSE
2127: Fnd_Message.Set_Name('IGS','IGS_GE_UNKNOWN_REC_TYPE');
2128: IGS_GE_MSG_STACK.ADD;
2129: p_record_type := 'X';
2130: END IF;
2131: EXCEPTION
2132: WHEN NO_DATA_FOUND THEN

Line 2138: IGS_GE_MSG_STACK.ADD;

2134: RETURN;
2135: WHEN OTHERS THEN
2136: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2137: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_read_rec');
2138: IGS_GE_MSG_STACK.ADD;
2139: App_Exception.Raise_Exception;
2140: END admpl_read_rec;
2141: ---------------
2142: ---------------

Line 2152: IGS_GE_MSG_STACK.ADD;

2148: t_matched_ids := t_matched_ids_clear;
2149: -- Validate parameters and open files.
2150: IF (p_input_file IS NULL) THEN
2151: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
2152: IGS_GE_MSG_STACK.ADD;
2153: RETURN;
2154: END IF;
2155: IF (p_output_file IS NULL) THEN
2156: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 2157: IGS_GE_MSG_STACK.ADD;

2153: RETURN;
2154: END IF;
2155: IF (p_output_file IS NULL) THEN
2156: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
2157: IGS_GE_MSG_STACK.ADD;
2158: RETURN;
2159: END IF;
2160: IF (p_directory IS NULL) THEN
2161: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 2162: IGS_GE_MSG_STACK.ADD;

2158: RETURN;
2159: END IF;
2160: IF (p_directory IS NULL) THEN
2161: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
2162: IGS_GE_MSG_STACK.ADD;
2163: RETURN;
2164: END IF;
2165: -- Open input file
2166: BEGIN

Line 2171: IGS_GE_MSG_STACK.ADD;

2167: fp_input := UTL_FILE.FOPEN(p_directory, p_input_file, 'R');
2168: EXCEPTION
2169: WHEN UTL_FILE.INVALID_OPERATION THEN
2170: Fnd_Message.Set_Name('IGS','IGS_GE_UNABLE_READ_FILE');
2171: IGS_GE_MSG_STACK.ADD;
2172: RETURN;
2173: END;
2174: -- Open output file
2175: BEGIN

Line 2180: IGS_GE_MSG_STACK.ADD;

2176: fp_output := UTL_FILE.FOPEN(p_directory, p_output_file, 'W');
2177: EXCEPTION
2178: WHEN UTL_FILE.INVALID_OPERATION THEN
2179: Fnd_Message.Set_Name('IGS','IGS_GE_FAILED_TO_CREATE_FILE');
2180: IGS_GE_MSG_STACK.ADD;
2181: RETURN;
2182: END;
2183: -- Call to function to read from file and return record type.
2184: admpl_read_rec(

Line 2193: IGS_GE_MSG_STACK.ADD;

2189: UTL_FILE.FCLOSE(fp_output);
2190: RETURN;
2191: ELSIF (v_record_type <> 'H') THEN
2192: Fnd_Message.Set_Name('IGS','IGS_AD_FIRST_REC_MUST HDR_REC');
2193: IGS_GE_MSG_STACK.ADD;
2194: UTL_FILE.FCLOSE(fp_input);
2195: UTL_FILE.FCLOSE(fp_output);
2196: RETURN;
2197: ELSE

Line 2229: IGS_GE_MSG_STACK.ADD;

2225: v_input_string,
2226: v_previous_name_records_cnt);
2227: IF (v_previous_name_records_cnt >= 20) THEN
2228: Fnd_Message.Set_Name('IGS','IGS_AD_TOO_MANY_PRE_NM_REC');
2229: IGS_GE_MSG_STACK.ADD;
2230: EXIT;
2231: END IF;
2232: ELSIF (v_record_type = 'F') THEN
2233: -- Process previous header (3)

Line 2244: IGS_GE_MSG_STACK.ADD;

2240: ELSIF (v_record_type = 'X') THEN
2241: EXIT;
2242: ELSE
2243: Fnd_Message.Set_Name('IGS','IGS_GE_UNKNOWN_REC_TYPE');
2244: IGS_GE_MSG_STACK.ADD;
2245: EXIT;
2246: END IF;
2247: END LOOP;
2248: UTL_FILE.FCLOSE(fp_input);

Line 2255: IGS_GE_MSG_STACK.ADD;

2251: EXCEPTION
2252: WHEN OTHERS THEN
2253: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2254: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admp_ext_tac_arts');
2255: IGS_GE_MSG_STACK.ADD;
2256: App_Exception.Raise_Exception;
2257: END admp_ext_tac_arts;
2258: Procedure Admp_Ext_Vtac_Return(
2259: errbuf OUT NOCOPY VARCHAR2,

Line 2342: IGS_GE_MSG_STACK.ADD;

2338: UTL_FILE.FCLOSE(fp_input);
2339: RETURN FALSE;
2340: WHEN UTL_FILE.READ_ERROR THEN
2341: Fnd_Message.Set_Name('IGS','IGS_GE_UNABLE_READ_FILE');
2342: IGS_GE_MSG_STACK.ADD;
2343: App_Exception.Raise_Exception;
2344: RETURN FALSE;
2345: END admpl_read_input;
2346: -- Define a procedure for writing the output file.

Line 2380: IGS_GE_MSG_STACK.ADD;

2376: IF (p_acad_cal_type IS NULL OR
2377: p_acad_ci_sequence_number IS NULL OR
2378: p_input_file IS NULL) THEN
2379: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
2380: IGS_GE_MSG_STACK.ADD;
2381: App_Exception.Raise_Exception;
2382: END IF;
2383: fnd_profile.get('IGS_IN_FILE_PATH',v_tmp_dir);
2384: --Open input file

Line 2390: IGS_GE_MSG_STACK.ADD;

2386: fp_input := UTL_FILE.FOPEN(v_tmp_dir, p_input_file, 'R');
2387: EXCEPTION
2388: WHEN UTL_FILE.INVALID_OPERATION THEN
2389: Fnd_Message.Set_Name('IGS','IGS_GE_UNABLE_READ_FILE');
2390: IGS_GE_MSG_STACK.ADD;
2391: App_Exception.Raise_Exception;
2392: WHEN UTL_FILE.INVALID_PATH THEN
2393: Fnd_Message.Set_Name('IGS','IGS_GE_UNABLE_READ_FILE');
2394: IGS_GE_MSG_STACK.ADD;

Line 2394: IGS_GE_MSG_STACK.ADD;

2390: IGS_GE_MSG_STACK.ADD;
2391: App_Exception.Raise_Exception;
2392: WHEN UTL_FILE.INVALID_PATH THEN
2393: Fnd_Message.Set_Name('IGS','IGS_GE_UNABLE_READ_FILE');
2394: IGS_GE_MSG_STACK.ADD;
2395: App_Exception.Raise_Exception;
2396: END;
2397: WHILE admpl_read_input LOOP
2398: IF (v_vtac_number IS NULL OR

Line 2459: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

2455: EXCEPTION
2456: WHEN OTHERS THEN
2457: Retcode := 2;
2458: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
2459: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
2460: END admp_ext_vtac_return;
2461: Function Admp_Get_Aal_Sent_Dt(
2462: p_person_id IN NUMBER ,
2463: p_admission_appl_number IN NUMBER ,

Line 2521: IGS_GE_MSG_STACK.ADD;

2517: EXCEPTION
2518: WHEN OTHERS THEN
2519: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2520: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admp_get_aal_sent_dt');
2521: IGS_GE_MSG_STACK.ADD;
2522: App_Exception.Raise_Exception;
2523: END admp_get_aal_sent_dt;
2524: Function Admp_Get_Aa_Aas(
2525: p_person_id IN NUMBER ,

Line 2688: IGS_GE_MSG_STACK.ADD;

2684: EXCEPTION
2685: WHEN OTHERS THEN
2686: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2687: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admp_get_aa_aas');
2688: IGS_GE_MSG_STACK.ADD;
2689: App_Exception.Raise_Exception;
2690: END admp_get_aa_aas;
2691: Procedure Admp_Get_Aa_Created(
2692: p_person_id IN NUMBER ,

Line 2737: IGS_GE_MSG_STACK.ADD;

2733: EXCEPTION
2734: WHEN OTHERS THEN
2735: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2736: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admp_get_aa_created');
2737: IGS_GE_MSG_STACK.ADD;
2738: App_Exception.Raise_Exception;
2739: END admp_get_aa_created;
2740: Procedure Admp_Get_Aa_Dtl(
2741: p_person_id IN NUMBER ,

Line 2816: IGS_GE_MSG_STACK.ADD;

2812: EXCEPTION
2813: WHEN OTHERS THEN
2814: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2815: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admp_get_aa_dtl');
2816: IGS_GE_MSG_STACK.ADD;
2817: App_Exception.Raise_Exception;
2818: END admp_get_aa_dtl;
2819: Function Admp_Get_Acai_Acadcd(
2820: p_person_id IN NUMBER ,

Line 2911: IGS_GE_MSG_STACK.ADD;

2907: EXCEPTION
2908: WHEN OTHERS THEN
2909: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2910: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admp_get_acai_aos_dt');
2911: IGS_GE_MSG_STACK.ADD;
2912: App_Exception.Raise_Exception;
2913: END admp_get_acai_aos_dt;
2914: Procedure ADMS_EXT_TAC_ARTS (
2915: errbuf out NOCOPY varchar2,

Line 2956: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

2952: v_dir_path );
2953: Exception
2954: WHEN OTHERS THEN
2955: ERRBUF:= FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
2956: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
2957: retcode:=2;
2958: END ADMS_EXT_TAC_ARTS;
2959: Function Admp_Get_Appl_ID(
2960: p_person_id IN NUMBER ,

Line 3158: igs_ge_msg_stack.add;

3154: THEN
3155:
3156: IF NVL(IGS_AD_GEN_007.ADMP_GET_SAAS(l_appl_inst_status),'-1') = cst_withdrawn THEN
3157: fnd_message.set_name('IGS','IGS_AD_APPL_INST_WITHD');
3158: igs_ge_msg_stack.add;
3159: app_exception.raise_exception; -- application instance is withdrawn
3160: END IF;
3161:
3162: IF Is_App_Inst_Complete( p_person_id,

Line 3178: igs_ge_msg_stack.add;

3174: AND
3175: (l_def_term_adm_appl_num IS NOT NULL OR l_def_appl_sequence_num IS NOT NULL)
3176: THEN
3177: fnd_message.set_name('IGS','IGS_AD_APPL_INST_COMPL');
3178: igs_ge_msg_stack.add;
3179: app_exception.raise_exception;
3180: END IF;
3181:
3182: END IF;

Line 3207: igs_ge_msg_stack.add;

3203: ELSE
3204: fnd_message.set_name('IGS','IGS_AD_APPL_INST_COMPL');
3205: END IF;
3206:
3207: igs_ge_msg_stack.add;
3208: app_exception.raise_exception;
3209: END IF;
3210: ELSE
3211: IF IGS_AD_GEN_007.ADMP_GET_SAAS(l_adm_appl_status_new) = cst_withdrawn THEN

Line 3213: igs_ge_msg_stack.add;

3209: END IF;
3210: ELSE
3211: IF IGS_AD_GEN_007.ADMP_GET_SAAS(l_adm_appl_status_new) = cst_withdrawn THEN
3212: fnd_message.set_name('IGS','IGS_AD_CANNOT_CHG_APPL_DTL');
3213: igs_ge_msg_stack.add;
3214: app_exception.raise_exception;
3215: END IF;
3216: END IF;
3217:

Line 3324: IGS_GE_MSG_STACK.ADD;

3320: EXCEPTION
3321: WHEN OTHERS THEN
3322: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3323: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.res_pending_fee_status');
3324: IGS_GE_MSG_STACK.ADD;
3325: App_Exception.Raise_Exception;
3326: END res_pending_fee_status;
3327:
3328: PROCEDURE Admp_resub_inst(

Line 3358: l_msg_at_index := igs_ge_msg_stack.count_msg;

3354: acai_rec c_acai%ROWTYPE;
3355: l_msg_at_index NUMBER;
3356: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
3357: BEGIN
3358: l_msg_at_index := igs_ge_msg_stack.count_msg;
3359: OPEN c_acai;
3360: FETCH c_acai INTO acai_rec;
3361: IF (c_acai%FOUND) THEN
3362: -- Call to tbh to insert null values for Application instance status. This will resubmit the application instance.