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_AD_GEN_002

Line 1: PACKAGE BODY igs_ad_gen_002 AS

1: PACKAGE BODY igs_ad_gen_002 AS
2: /* $Header: IGSAD02B.pls 120.11 2006/01/16 20:23:16 rghosh ship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What

Line 124: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_chk_non_num');

120: RETURN FALSE;
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: ---------------

Line 156: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_strip_non_alpha');

152: RETURN v_output_string;
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: ---------------

Line 184: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_strip_spaces');

180: RETURN v_output_string;
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: ---------------

Line 269: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_store_matched_table');

265: t_matched_ids(p_number_of_matches) := r_matched_id_rec;
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: ---------------

Line 302: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria11');

298: END LOOP;
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: ---------------

Line 332: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria10');

328: END LOOP;
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: ---------------

Line 392: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria9');

388: END LOOP;
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: ---------------

Line 434: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria8');

430: END LOOP;
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: ---------------

Line 495: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria7');

491: END LOOP;
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: ---------------

Line 540: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria6');

536: END LOOP;
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: ---------------

Line 574: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria5');

570: END IF;
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: ---------------

Line 610: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria4a');

606: END IF;
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: ---------------

Line 678: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria4');

674: END LOOP;
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: ---------------

Line 729: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria3');

725: END IF;
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: ---------------

Line 800: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria2');

796: END LOOP;
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: ---------------

Line 852: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria1');

848: END IF;
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: ---------------

Line 909: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_any_name');

905: p_number_of_matches);
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: ---------------

Line 951: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_loose_name');

947: p_number_of_matches);
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: ---------------

Line 976: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_exact_name');

972: p_number_of_matches);
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: ---------------

Line 1041: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_any_id');

1037: p_number_of_matches);
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: ---------------

Line 1078: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_exact_id');

1074: p_number_of_matches);
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: ---------------

Line 1136: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_standard_6');

1132: p_number_of_matches);
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 (

Line 1227: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_standard');

1223: p_number_of_matches);
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: ---------------

Line 1279: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_write_course_header');

1275: UTL_FILE.FFLUSH(fp_output);
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 (

Line 1788: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_write_student_details');

1784: END IF;
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 (

Line 2049: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_prc_previous_header');

2045: RETURN TRUE;
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: ---------------

Line 2094: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_store_rec');

2090: END IF;
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: ---------------

Line 2137: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_read_rec');

2133: p_record_type := 'F';
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: ---------------

Line 2254: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admp_ext_tac_arts');

2250: END;
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(

Line 2520: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admp_get_aal_sent_dt');

2516: END;
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(

Line 2687: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admp_get_aa_aas');

2683: END;
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(

Line 2736: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admp_get_aa_created');

2732: END;
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(

Line 2815: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admp_get_aa_dtl');

2811: END;
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(

Line 2879: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admp_get_acai_acadcd');

2875: END;
2876: EXCEPTION
2877: WHEN OTHERS THEN
2878: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2879: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admp_get_acai_acadcd');
2880: END admp_get_acai_acadcd;
2881: Function Admp_Get_Acai_Aos_Dt(
2882: p_person_id IN NUMBER ,
2883: p_admission_appl_number IN NUMBER ,

Line 2910: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admp_get_acai_aos_dt');

2906: END;
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 (

Line 2949: IGS_AD_GEN_002.admp_ext_tac_arts(

2945: v_output_file := v_input_file;
2946: END IF;
2947: v_output_file := v_output_file||'.out';
2948: --Now call ADMP_EXT_TAC_ARTS with parameters
2949: IGS_AD_GEN_002.admp_ext_tac_arts(
2950: v_input_file ,
2951: v_output_file ,
2952: v_dir_path );
2953: Exception

Line 3136: l_adm_appl_status_new := IGS_AD_GEN_002.ADMP_GET_AA_AAS(

3132: FETCH c_adm_outcome_status INTO l_adm_outcome_status,l_appl_inst_status,l_def_term_adm_appl_num,l_def_appl_sequence_num;
3133: CLOSE c_adm_outcome_status;
3134: END IF;
3135: -- The Admission Application Status may have been re-derived
3136: l_adm_appl_status_new := IGS_AD_GEN_002.ADMP_GET_AA_AAS(
3137: p_person_id,
3138: p_admission_appl_number,
3139: l_adm_appl_status_old);
3140:

Line 3323: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.res_pending_fee_status');

3319: END;
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:

Line 3726: IF igs_ad_gen_002.is_app_inst_complete(p_person_id,p_admission_appl_number,p_nominated_course_cd,p_sequence_number) = 'Y'

3722: OPEN c_aa_acaiv;
3723: FETCH c_aa_acaiv INTO v_aa_acaiv_rec;
3724: CLOSE c_aa_acaiv;
3725:
3726: IF igs_ad_gen_002.is_app_inst_complete(p_person_id,p_admission_appl_number,p_nominated_course_cd,p_sequence_number) = 'Y'
3727: THEN
3728: IF (NOT l_is_reconisder_allowed ) -- APC step not allowed
3729: THEN
3730: p_message_name := 'IGS_AD_NO_RECONSIDERATION';

Line 3744: IF (igs_ad_gen_002.check_any_offer_inst (p_person_id, p_admission_appl_number, p_nominated_course_cd, p_sequence_number ) )

3740: p_message_name := 'IGS_AD_NO_RECONSIDERATION'; -- cannot be reconsidered as a future/deferred application exists.
3741: p_success := 'N';
3742: RETURN;
3743: END IF;
3744: IF (igs_ad_gen_002.check_any_offer_inst (p_person_id, p_admission_appl_number, p_nominated_course_cd, p_sequence_number ) )
3745: THEN
3746: p_success := 'Y';
3747: RETURN; -- can be reconsiderd, as this is an offered instance
3748: ELSE

Line 3780: igs_ad_gen_002.Is_inst_recon_allowed ( p_person_id,p_admission_appl_number,p_nominated_course_cd, p_sequence_number,p_success,p_message_name);

3776: RETURN VARCHAR2 IS
3777: p_message_name VARCHAR2(40) DEFAULT NULL;
3778: p_success VARCHAR2(1) DEFAULT NULL;
3779: BEGIN
3780: igs_ad_gen_002.Is_inst_recon_allowed ( p_person_id,p_admission_appl_number,p_nominated_course_cd, p_sequence_number,p_success,p_message_name);
3781: RETURN p_success;
3782: END Is_inst_recon_allowed;
3783:
3784: ---------------------------**************Reconsider_Appl_Inst***************-------------------------

Line 4572: END igs_ad_gen_002;

4568: v_ent_qual_codes := 'N';
4569: RETURN v_ent_qual_codes;
4570: END Is_EntQualCode_Allowed;
4571:
4572: END igs_ad_gen_002;
4573:
4574:
4575: