DBA Data[Home] [Help]

APPS.IGS_FI_GEN_004 dependencies on IGS_GE_MSG_STACK

Line 275: IGS_GE_MSG_STACK.ADD;

271: p_commencement_dt IS NULL OR
272: p_completion_dt IS NULL THEN
273: -- Replaced message IGS_GE_INVALID_VALUE with IGS_FI_PARAMETER_NULL
274: Fnd_Message.Set_Name ('IGS', 'IGS_FI_PARAMETER_NULL');
275: IGS_GE_MSG_STACK.ADD;
276: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
277: END IF;
278: v_previous_fee_type := NULL;
279: FOR v_scafcflrv_rec IN c_scafcflrv('ACTIVE','N','INSTITUTN','OTHER','TUTNFEE','TUITION','TRUE','FCFL','FTCI') LOOP

Line 321: IGS_GE_MSG_STACK.ADD;

317: EXCEPTION
318: WHEN OTHERS THEN
319: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
320: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINP_PRC_CFAR');
321: IGS_GE_MSG_STACK.ADD;
322: App_Exception.Raise_Exception;
323: END finp_prc_cfar;
324: --
325: PROCEDURE finp_prc_disb_jnl(

Line 351: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

347: EXCEPTION
348: WHEN OTHERS THEN
349: RETCODE:=2;
350: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
351: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
352: END finp_prc_disb_jnl;
353: --
354: PROCEDURE finp_prc_disb_snpsht(
355: errbuf out NOCOPY varchar2,

Line 376: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

372: EXCEPTION
373: WHEN OTHERS THEN
374: RETCODE:=2;
375: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
376: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
377: END finp_prc_disb_snpsht;
378: --
379: PROCEDURE finp_prc_enr_fa_todo(
380: errbuf out NOCOPY varchar2,

Line 583: igs_ge_msg_stack.add;

579: p_ret_ci_sequence_number => l_fee_ci_sequence_number,
580: p_message_name => l_message) = FALSE THEN
581: -- Code to add to stack has been added as part of 2734512
582: fnd_message.set_name('IGS',l_message);
583: igs_ge_msg_stack.add;
584: x_msg_data := l_message;
585: RAISE fnd_api.g_exc_error;
586: END IF;
587: ELSE

Line 616: igs_ge_msg_stack.add;

612: fnd_message.set_name ('IGS', l_message_name);
613: IF l_message_name = 'IGS_FI_NO_CENSUS_DT_SETUP' THEN
614: fnd_message.set_token('ALT_CD', igs_fi_prc_fee_ass.g_v_load_alt_code);
615: END IF;
616: igs_ge_msg_stack.add;
617: x_msg_data := l_message_name;
618: RAISE FND_API.G_EXC_ERROR;
619: ELSE
620: -- If call is success, action off child record

Line 737: igs_ge_msg_stack.add;

733: p_ret_cal_type => l_v_load_cal_type,
734: p_ret_ci_sequence_number => l_n_load_ci_seq_num,
735: p_message_name => l_v_message) = FALSE THEN
736: fnd_message.set_name ('IGS', l_v_message);
737: igs_ge_msg_stack.add;
738: RAISE fnd_api.g_exc_error;
739: END IF;
740: ELSE
741: l_v_load_cal_type := NULL;

Line 772: igs_ge_msg_stack.conc_exception_hndl;

768: END;
769:
770: IF l_return_status = fnd_api.g_ret_sts_error THEN
771: -- Bug# 2734512, Added following message handling
772: igs_ge_msg_stack.conc_exception_hndl;
773: IF (l_msg_data IS NULL) THEN
774: fnd_msg_pub.count_and_get( p_count => l_n_msg_count,
775: p_data => l_v_msg_data);
776: IF l_n_msg_count = 1 THEN

Line 830: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

826: WHEN OTHERS THEN
827: RETCODE:=2;
828: FND_FILE.Put_Line(FND_FILE.Log,substr(sqlerrm,1,300));
829: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
830: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
831: END;
832: END finp_prc_enr_fa_todo;
833: --
834:

Line 987: igs_ge_msg_stack.ADD;

983: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,
984: p_v_message_name => l_v_message_name );
985: IF l_v_manage_accounts IS NULL THEN
986: fnd_message.set_name ( 'IGS', l_v_message_name );
987: igs_ge_msg_stack.ADD;
988: app_exception.raise_exception (NULL, NULL, fnd_message.get);
989: END IF;
990:
991: -- Validate parameters

Line 995: igs_ge_msg_stack.ADD;

991: -- Validate parameters
992: -- Process can take only one parameter between Person Number and Person Group ID. Added as part of Enh# 2831569.
993: IF ( (l_n_person_id IS NOT NULL) AND (l_n_person_grp_id IS NOT NULL) ) THEN
994: fnd_message.set_name ( 'IGS', 'IGS_FI_PRS_PRSIDGRP_NULL') ;
995: igs_ge_msg_stack.ADD;
996: app_exception.raise_exception(null, null, fnd_message.get);
997: END IF;
998:
999: -- Enh# 3167098, Either of the two parameters must be specified.

Line 1003: igs_ge_msg_stack.ADD;

999: -- Enh# 3167098, Either of the two parameters must be specified.
1000: IF l_n_person_id IS NULL AND
1001: l_n_person_grp_id IS NULL THEN
1002: fnd_message.set_name ( 'IGS', 'IGS_FI_PRS_PRSIDGRP_NULL') ;
1003: igs_ge_msg_stack.ADD;
1004: app_exception.raise_exception(null, null, fnd_message.get);
1005: END IF;
1006:
1007: -- Validate the person id group

Line 1015: igs_ge_msg_stack.ADD;

1011: IF cur_pers_grp%NOTFOUND THEN
1012: CLOSE cur_pers_grp;
1013: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
1014: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP'));
1015: igs_ge_msg_stack.ADD;
1016: app_exception.raise_exception(null, null, fnd_message.get);
1017: END IF;
1018: CLOSE cur_pers_grp;
1019: END IF;

Line 1053: IGS_GE_MSG_STACK.ADD;

1049: -- ensuring that fee calendar instance is not null as a change implemented in
1050: -- fee calc build july-2001 (bug: 1851586)
1051: IF l_v_fee_cal_type IS NULL OR l_n_fee_ci_sequence_number IS NULL THEN
1052: Fnd_Message.Set_Name ('IGS', 'IGS_FI_PARAMETER_NULL');
1053: IGS_GE_MSG_STACK.ADD;
1054: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
1055: RETURN;
1056: END IF;
1057:

Line 1065: igs_ge_msg_stack.add;

1061: FETCH cur_wav_calc_flag INTO l_v_wav_calc_flag;
1062: CLOSE cur_wav_calc_flag;
1063: IF (l_v_wav_calc_flag = 'Y') THEN
1064: fnd_message.set_name('IGS', 'IGS_FI_WAV_FEE_TYPE');
1065: igs_ge_msg_stack.add;
1066: app_exception.raise_exception(Null, Null, fnd_message.get);
1067: RETURN;
1068: END IF;
1069: END IF;

Line 1080: IGS_GE_MSG_STACK.ADD;

1076: p_v_closing_status => l_c_closing_status,
1077: p_v_message_name => v_message_name);
1078: IF v_message_name IS NOT NULL THEN
1079: FND_MESSAGE.SET_NAME('IGS', v_message_name);
1080: IGS_GE_MSG_STACK.ADD;
1081: APP_EXCEPTION.RAISE_EXCEPTION;
1082: ELSIF l_c_closing_status NOT IN ('O','F') THEN
1083: FND_MESSAGE.SET_NAME('IGS', 'IGS_FI_INVALID_GL_DATE');
1084: FND_MESSAGE.SET_TOKEN('GL_DATE',l_d_gl_date);

Line 1085: IGS_GE_MSG_STACK.ADD;

1081: APP_EXCEPTION.RAISE_EXCEPTION;
1082: ELSIF l_c_closing_status NOT IN ('O','F') THEN
1083: FND_MESSAGE.SET_NAME('IGS', 'IGS_FI_INVALID_GL_DATE');
1084: FND_MESSAGE.SET_TOKEN('GL_DATE',l_d_gl_date);
1085: IGS_GE_MSG_STACK.ADD;
1086: APP_EXCEPTION.RAISE_EXCEPTION;
1087: END IF;
1088:
1089: -- validate fee assessment period

Line 1100: IGS_GE_MSG_STACK.ADD;

1096: v_record_found := TRUE;
1097: END LOOP;
1098: IF(v_record_found = FALSE) THEN
1099: Fnd_Message.Set_Name ('IGS', 'IGS_FI_NO_FEE_CAL_INS');
1100: IGS_GE_MSG_STACK.ADD;
1101: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
1102: RETURN;
1103: ELSE
1104: v_record_found := FALSE;

Line 1119: IGS_GE_MSG_STACK.ADD;

1115: -- Enh# 3167098, Removed INITIAL and COMBINED modes.
1116: IF NVL(p_process_mode, 'NULL') NOT IN ('ACTUAL', 'PREDICTIVE') THEN
1117: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER' );
1118: fnd_message.set_token('PARAMETER', igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'PROCESS_MODE' ) );
1119: IGS_GE_MSG_STACK.ADD;
1120: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
1121: RETURN;
1122: END IF;
1123:

Line 1130: igs_ge_msg_stack.ADD;

1126: -- Added as part of Enh# 3117341, Audit Special Fees.
1127: l_v_include_audit := fnd_profile.value('IGS_FI_CHARGE_AUDIT_FEES');
1128: IF l_v_include_audit IS NULL THEN
1129: fnd_message.set_name('IGS', 'IGS_FI_SP_FEE_NO_PROFILE');
1130: igs_ge_msg_stack.ADD;
1131: app_exception.raise_exception(null, null, fnd_message.get);
1132: END IF;
1133:
1134: fnd_file.new_line(fnd_file.log);

Line 1168: igs_ge_msg_stack.add;

1164: -- Get the select query for REF CURSOR by calling igs_pe_dynamic_persid_group.igs_get_dynamic_sql
1165: l_dynamic_sql := igs_pe_dynamic_persid_group.igs_get_dynamic_sql(l_n_person_grp_id,l_v_status );
1166: IF l_v_status <> 'S' THEN
1167: fnd_message.set_name('IGF','IGF_AP_INVALID_QUERY');
1168: igs_ge_msg_stack.add;
1169: app_exception.raise_exception(NULL,NULL,fnd_message.get);
1170: END IF;
1171:
1172:

Line 1222: IGS_GE_MSG_STACK.ADD;

1218: Fnd_Message.Set_Name ('IGS', v_message_name);
1219: IF v_message_name = 'IGS_FI_NO_CENSUS_DT_SETUP' THEN
1220: fnd_message.set_token('ALT_CD', igs_fi_prc_fee_ass.g_v_load_alt_code);
1221: END IF;
1222: IGS_GE_MSG_STACK.ADD;
1223: App_Exception.Raise_Exception(Null, Null, fnd_message.get );
1224: END IF;
1225: EXCEPTION
1226: WHEN OTHERS THEN

Line 1233: igs_ge_msg_stack.add;

1229: retcode:=1;
1230: l_v_person_number := igs_fi_gen_008.get_party_number(rec_person_grp.p_n_person_id);
1231: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');
1232: fnd_message.set_token('PERSON_NUM',l_v_person_number);
1233: igs_ge_msg_stack.add;
1234: END;
1235:
1236: END LOOP;
1237:

Line 1263: IGS_GE_MSG_STACK.ADD;

1259: Fnd_Message.Set_Name ('IGS', v_message_name);
1260: IF v_message_name = 'IGS_FI_NO_CENSUS_DT_SETUP' THEN
1261: fnd_message.set_token('ALT_CD', igs_fi_prc_fee_ass.g_v_load_alt_code);
1262: END IF;
1263: IGS_GE_MSG_STACK.ADD;
1264: App_Exception.Raise_Exception(Null, Null, fnd_message.get );
1265: END IF;
1266:
1267: END IF;

Line 1282: igs_ge_msg_stack.conc_exception_hndl;

1278: EXCEPTION
1279: WHEN OTHERS THEN
1280: retcode:=2;
1281: errbuf:=fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1282: igs_ge_msg_stack.conc_exception_hndl;
1283: END finp_prc_enr_fee_ass;
1284:
1285: --
1286: PROCEDURE finp_prc_hecs_pymnt_optn(

Line 1317: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: RETCODE:=2;
1316: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1317: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
1318: END finp_prc_hecs_pymnt_optn;
1319: --
1320: PROCEDURE finp_prc_penalties(
1321: errbuf out NOCOPY varchar2,

Line 1347: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

1343: EXCEPTION
1344: WHEN OTHERS THEN
1345: RETCODE:=2;
1346: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1347: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
1348: END finp_prc_penalties;
1349: --
1350: PROCEDURE finp_prc_sca_unconf(
1351: p_person_id IN NUMBER ,

Line 1440: IGS_GE_MSG_STACK.ADD;

1436: EXCEPTION
1437: WHEN OTHERS THEN
1438: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1439: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINP_PRC_INS_LOG_ENTRY');
1440: IGS_GE_MSG_STACK.ADD;
1441: App_Exception.Raise_Exception;
1442: END finpl_prc_ins_log_entry;
1443: PROCEDURE finpl_prc_end_fee_contract(
1444: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE,

Line 1496: IGS_GE_MSG_STACK.ADD;

1492: EXCEPTION
1493: WHEN OTHERS THEN
1494: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1495: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINP_PRC_END_FEE_CONTRACT');
1496: IGS_GE_MSG_STACK.ADD;
1497: App_Exception.Raise_Exception;
1498: END finpl_prc_end_fee_contract;
1499:
1500: PROCEDURE finpl_prc_reverse_fee_assess (

Line 1591: IGS_GE_MSG_STACK.ADD;

1587: EXCEPTION
1588: WHEN OTHERS THEN
1589: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1590: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINPL_PRC_REVERSE_FEE_ASSESS');
1591: IGS_GE_MSG_STACK.ADD;
1592: App_Exception.Raise_Exception;
1593: END finpl_prc_reverse_fee_assess;
1594: --Modified the declartion of datatype based on IGS_FI_FEE_ASS_DEBT_V to point to IGS_FI_FEE_AS.
1595: FUNCTION finpl_prc_this_crs_liable (

Line 1643: IGS_GE_MSG_STACK.ADD;

1639: EXCEPTION
1640: WHEN OTHERS THEN
1641: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1642: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINPL_PRC_THIS_CRS_LIABLE');
1643: IGS_GE_MSG_STACK.ADD;
1644: App_Exception.Raise_Exception;
1645: END finpl_prc_this_crs_liable;
1646: --Modified the declartion of datatype based on IGS_FI_FEE_ASS_DEBT_V to point to IGS_FI_FEE_AS.
1647: FUNCTION finpl_prc_another_crs_liable (

Line 1696: IGS_GE_MSG_STACK.ADD;

1692: EXCEPTION
1693: WHEN OTHERS THEN
1694: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1695: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINPL_PRC_ANOTHER_CRS_LIABLE');
1696: IGS_GE_MSG_STACK.ADD;
1697: App_Exception.Raise_Exception;
1698: END finpl_prc_another_crs_liable;
1699: PROCEDURE finpl_prc_delete_fee_contract (
1700: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE,

Line 1732: IGS_GE_MSG_STACK.ADD;

1728: EXCEPTION
1729: WHEN OTHERS THEN
1730: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1731: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINPL_PRC_DELETE_FEE_CONTRACT');
1732: IGS_GE_MSG_STACK.ADD;
1733: App_Exception.Raise_Exception;
1734: END finpl_prc_delete_fee_contract;
1735: BEGIN
1736: -- Validate input parameters

Line 1834: IGS_GE_MSG_STACK.ADD;

1830: EXCEPTION
1831: WHEN OTHERS THEN
1832: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1833: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINP_PRC_SCA_UNCONF');
1834: IGS_GE_MSG_STACK.ADD;
1835: App_Exception.Raise_Exception;
1836: END finp_prc_sca_unconf;
1837: END igs_fi_gen_004;