DBA Data[Home] [Help]

APPS.IGS_FI_PRC_FEE_ASS dependencies on IGS_GE_MSG_STACK

Line 791: IGS_GE_MSG_STACK.ADD;

787: log_to_fnd( p_v_module => 'finpl_sort_table',
788: p_v_string => 'From WHEN OTHERS. ' || SUBSTR(sqlerrm,1,500));
789: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
790: Fnd_Message.Set_Token('NAME','finpl_sort_table -'||SUBSTR(sqlerrm,1,500));
791: IGS_GE_MSG_STACK.ADD;
792: App_Exception.Raise_Exception;
793: END finpl_sort_table;
794:
795:

Line 841: IGS_GE_MSG_STACK.ADD;

837: log_to_fnd( p_v_module => 'finpl_retn_sort_table',
838: p_v_string => 'From WHEN OTHERS. ' || SUBSTR(sqlerrm,1,500));
839: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
840: Fnd_Message.Set_Token('NAME','finpl_retn_sort_table -'||SUBSTR(sqlerrm,1,500));
841: IGS_GE_MSG_STACK.ADD;
842: App_Exception.Raise_Exception;
843: END finpl_retn_sort_table;
844:
845:

Line 1013: igs_ge_msg_stack.add;

1009: log_to_fnd( p_v_module => 'finpl_prc_teach_prd_retn_levl',
1010: p_v_string => 'From Exception Handler of When Others.');
1011: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1012: Fnd_Message.Set_Token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_PRC_TEACH_PRD_RETN_LEVL-'||SUBSTR(SQLERRM,1,500));
1013: igs_ge_msg_stack.add;
1014: app_exception.raise_exception;
1015: END finpl_prc_teach_prd_retn_levl;
1016:
1017: FUNCTION finpl_clc_sua_cp( p_v_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,

Line 1441: igs_ge_msg_stack.add;

1437: log_to_fnd( p_v_module => 'finpl_get_derived_am_at',
1438: p_v_string => 'From Exception Handler of When Others.');
1439: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1440: fnd_message.set_token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_GET_DERIVED_AM_AT-'||SUBSTR(sqlerrm,1,500));
1441: igs_ge_msg_stack.add;
1442: app_exception.raise_exception;
1443: END finpl_get_derived_am_at;
1444: -----------------------------------------------------------------------------------
1445:

Line 1903: IGS_GE_MSG_STACK.ADD;

1899: log_to_fnd( p_v_module => 'finpl_ins_match_chg_rate',
1900: p_v_string => 'From WHEN OTHERS. ' || SUBSTR(sqlerrm,1,500));
1901: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1902: Fnd_Message.Set_Token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_INS_MATCH_CHG_RATE-'||SUBSTR(sqlerrm,1,500));
1903: IGS_GE_MSG_STACK.ADD;
1904: App_Exception.Raise_Exception;
1905: END finpl_ins_match_chg_rate;
1906:
1907: -------------------------------------------------------------------------------

Line 2366: igs_ge_msg_stack.add;

2362: log_to_fnd( p_v_module => 'finpl_get_derived_values',
2363: p_v_string => 'From Exception Handler of When Others.');
2364: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
2365: fnd_message.set_token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_GET_DERIVED_VALUES-'||SUBSTR(sqlerrm,1,500));
2366: igs_ge_msg_stack.add;
2367: app_exception.raise_exception;
2368: END finpl_get_derived_values;
2369:
2370:

Line 2772: IGS_GE_MSG_STACK.ADD;

2768: log_to_fnd( p_v_module => 'finpl_find_far',
2769: p_v_string => 'From exception handler of When Others.');
2770: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
2771: Fnd_Message.Set_Token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_FIND_FAR-'||SUBSTR(sqlerrm,1,500));
2772: IGS_GE_MSG_STACK.ADD;
2773: App_Exception.Raise_Exception;
2774: END finpl_find_far;
2775:
2776: PROCEDURE finpl_prc_element_ranges (p_n_person_id IN NUMBER,

Line 3912: IGS_GE_MSG_STACK.ADD;

3908: log_to_fnd( p_v_module => 'finpl_prc_element_ranges',
3909: p_v_string => 'From Exception Handler of e_one_record_expected.');
3910: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3911: FND_MESSAGE.SET_TOKEN('NAME','IGS_FI_PRC_FEE_ASS.FINPL_PRC_ELEMENT_RANGES-'||SUBSTR(sqlerrm,1,500));
3912: IGS_GE_MSG_STACK.ADD;
3913: App_Exception.Raise_Exception;
3914:
3915: WHEN OTHERS THEN
3916: log_to_fnd( p_v_module => 'finpl_prc_element_ranges',

Line 3920: IGS_GE_MSG_STACK.ADD;

3916: log_to_fnd( p_v_module => 'finpl_prc_element_ranges',
3917: p_v_string => 'From exception handler of When Others.');
3918: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
3919: Fnd_Message.Set_Token('NAME','igs_fi_prc_fee_ass.finpl_prc_element_ranges-'||SUBSTR(sqlerrm,1,500));
3920: IGS_GE_MSG_STACK.ADD;
3921: App_Exception.Raise_Exception;
3922: END finpl_prc_element_ranges;
3923:
3924: BEGIN

Line 4458: IGS_GE_MSG_STACK.ADD;

4454: log_to_fnd( p_v_module => 'finp_clc_ass_amnt',
4455: p_v_string => 'From Exception Handler of e_one_record_expected.');
4456: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4457: FND_MESSAGE.SET_TOKEN('NAME','IGS_FI_PRC_FEE_ASS.FINP_CLC_ASS_AMNT-'||SUBSTR(sqlerrm,1,500));
4458: IGS_GE_MSG_STACK.ADD;
4459: lv_param_values := to_char(p_effective_dt)||','||to_char(p_person_id)||','||
4460: p_course_cd||','||p_course_attempt_status||','||
4461: p_fee_type||','||
4462: to_char(p_fee_ci_sequence_number)||','||

Line 4476: IGS_GE_MSG_STACK.ADD;

4472: p_charge_elements||','||
4473: p_fee_assessment;
4474: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PARAMETERS');
4475: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
4476: IGS_GE_MSG_STACK.ADD;
4477: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
4478:
4479: WHEN OTHERS THEN
4480: log_to_fnd( p_v_module => 'finp_clc_ass_amnt',

Line 4484: IGS_GE_MSG_STACK.ADD;

4480: log_to_fnd( p_v_module => 'finp_clc_ass_amnt',
4481: p_v_string => 'When Others.' || SUBSTR(sqlerrm,1,500));
4482: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4483: FND_MESSAGE.SET_TOKEN('NAME','IGS_FI_PRC_FEE_ASS.FINP_CLC_ASS_AMNT');
4484: IGS_GE_MSG_STACK.ADD;
4485: lv_param_values := to_char(p_effective_dt)||','||to_char(p_person_id)||','||
4486: p_course_cd||','||p_course_attempt_status||','||
4487: p_fee_type||','||
4488: to_char(p_fee_ci_sequence_number)||','||

Line 4502: IGS_GE_MSG_STACK.ADD;

4498: p_charge_elements||','||
4499: p_fee_assessment;
4500: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PARAMETERS');
4501: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
4502: IGS_GE_MSG_STACK.ADD;
4503: App_Exception.Raise_Exception;
4504:
4505: END;
4506: END;

Line 5640: igs_ge_msg_stack.add;

5636: log_to_fnd( p_v_module => 'finpl_chk_debt_ret_sched',
5637: p_v_string => 'From Exception Handler of When Others.');
5638: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5639: Fnd_Message.Set_Token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_CHK_DEBT_RET_SCHED-'||SUBSTR(SQLERRM,1,500));
5640: igs_ge_msg_stack.add;
5641: app_exception.raise_exception;
5642: END finpl_chk_debt_ret_sched;
5643:
5644: PROCEDURE finpl_ins_fee_ass(

Line 6213: igs_ge_msg_stack.add;

6209: END IF;
6210: log_to_fnd( p_v_module => 'finpl_ins_fee_ass',
6211: p_v_string => 'From Exception Handler of e_unexpected_error.');
6212: fnd_message.set_name ('IGS', 'IGS_GE_UNEXPECTED_ERR');
6213: igs_ge_msg_stack.add;
6214: app_exception.raise_exception(NULL, NULL, fnd_message.get);
6215:
6216: WHEN e_one_record_expected THEN
6217: IF g_v_wav_calc_flag = 'N' THEN

Line 6224: IGS_GE_MSG_STACK.ADD;

6220: log_to_fnd( p_v_module => 'finpl_ins_fee_ass',
6221: p_v_string => 'From Exception Handler of e_one_record_expected.' || SUBSTR(sqlerrm,1,500));
6222: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
6223: Fnd_Message.Set_Token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_INS_FEE_ASS-'||SUBSTR(sqlerrm,1,500));
6224: IGS_GE_MSG_STACK.ADD;
6225: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
6226: WHEN OTHERS THEN
6227: IF g_v_wav_calc_flag = 'N' THEN
6228: ROLLBACK TO fee_calc_sp;

Line 6234: IGS_GE_MSG_STACK.ADD;

6230: log_to_fnd( p_v_module => 'finpl_ins_fee_ass',
6231: p_v_string => 'From Exception Handler of When Others.' || SUBSTR(sqlerrm,1,500));
6232: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
6233: Fnd_Message.Set_Token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_INS_FEE_ASS-'||SUBSTR(sqlerrm,1,500));
6234: IGS_GE_MSG_STACK.ADD;
6235: App_Exception.Raise_Exception;
6236: END finpl_ins_fee_ass;
6237:
6238: -------------------------------------------------------------------------------

Line 6686: igs_ge_msg_stack.ADD;

6682: log_to_fnd( p_v_module => 'finpl_prc_sua_load',
6683: p_v_string => 'From Exception Handler of When Others' );
6684: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
6685: fnd_message.set_token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_PRC_SUA_LOAD-'||SUBSTR(sqlerrm,1,500));
6686: igs_ge_msg_stack.ADD;
6687: app_exception.raise_exception;
6688: END finpl_prc_sua_load;
6689:
6690: ------------------------------------------------------------------------------

Line 7691: IGS_GE_MSG_STACK.ADD;

7687: log_to_fnd( p_v_module => 'finpl_clc_chg_mthd_elements',
7688: p_v_string => 'From Exception Handler of When Others.');
7689: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
7690: FND_MESSAGE.SET_TOKEN('NAME','IGS_FI_PRC_FEE_ASS.FINPL_CLC_CHG_MTHD_ELEMENTS-'||SUBSTR(sqlerrm,1,500));
7691: IGS_GE_MSG_STACK.ADD;
7692: lv_param_values := to_char(p_effective_dt)||','||p_trace_on||','||
7693: to_char(p_person_id)||','||
7694: p_course_cd||','||to_char(p_course_version_number)||','||
7695: p_attendance_type||','||p_course_attempt_status||','||

Line 7706: IGS_GE_MSG_STACK.ADD;

7702: p_s_fee_trigger_cat||','||
7703: p_charge_elements;
7704: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PARAMETERS');
7705: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
7706: IGS_GE_MSG_STACK.ADD;
7707: App_Exception.Raise_Exception;
7708: END finpl_clc_chg_mthd_elements;
7709:
7710:

Line 9130: igs_ge_msg_stack.add;

9126: p_v_string => 'In Exception Handler of e_lock_exception' );
9127: fnd_message.set_name('IGS', 'IGS_FI_FEEAS_NO_CONC_RUN');
9128: fnd_message.set_token('PERSON_NUM',g_v_person_number);
9129: fnd_message.set_token('FEE_PERIOD',g_v_fee_alt_code);
9130: igs_ge_msg_stack.add;
9131: app_exception.raise_exception(NULL, NULL, fnd_message.get);
9132: WHEN OTHERS THEN
9133: log_to_fnd( p_v_module => 'finpl_prc_fee_cat_fee_liab',
9134: p_v_string => 'From exception handler of WHEN OTHERS of finpl_prc_fee_cat_fee_liab.' );

Line 9137: IGS_GE_MSG_STACK.ADD;

9133: log_to_fnd( p_v_module => 'finpl_prc_fee_cat_fee_liab',
9134: p_v_string => 'From exception handler of WHEN OTHERS of finpl_prc_fee_cat_fee_liab.' );
9135: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
9136: Fnd_Message.Set_Token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_PRC_FEE_CAT_FEE_LIAB-'||SUBSTR(sqlerrm,1,500));
9137: IGS_GE_MSG_STACK.ADD;
9138: App_Exception.Raise_Exception;
9139: END finpl_prc_fee_cat_fee_liab;
9140:
9141: PROCEDURE finpl_prc_predictive_scas ( p_n_person_id IN igs_fi_fee_as_items.person_id%TYPE,

Line 10150: igs_ge_msg_stack.ADD;

10146: fnd_file.put_line (fnd_file.log, fnd_message.get);
10147: END IF;
10148: p_message_name := 'IGS_FI_INC_PRG_TRANSFER';
10149: fnd_message.set_name('IGS', 'IGS_FI_INC_PRG_TRANSFER');
10150: igs_ge_msg_stack.ADD;
10151: log_to_fnd( p_v_module => 'finp_ins_enr_fee_ass',
10152: p_v_string => 'Returning from finp_ins_enr_fee_ass with message ' || p_message_name );
10153: -- Return TRUE so that the message is shown in Report and continues with next person, if any.
10154: RETURN TRUE;

Line 10346: igs_ge_msg_stack.ADD;

10342: fnd_file.put_line(fnd_file.log,fnd_message.get);
10343: ELSE
10344: -- This is called from Self-Service Package. Return FALSE so that this message is shown on page.
10345: p_message_name := 'IGS_FI_NO_SPA_FEE_CAT';
10346: igs_ge_msg_stack.ADD;
10347: END IF;
10348: RETURN FALSE;
10349: END IF;
10350:

Line 10740: igs_ge_msg_stack.add;

10736: log_to_fnd( p_v_module => 'finp_ins_enr_fee_ass',
10737: p_v_string => 'In Exception Handler of e_one_record_expected.' );
10738: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
10739: fnd_message.set_token('NAME','IGS_FI_PRC_FEE_ASS.FINP_INS_ENR_FEE_ASS-'||SUBSTR(SQLERRM,1,500));
10740: igs_ge_msg_stack.add;
10741: app_exception.raise_exception(NULL, NULL, fnd_message.get);
10742: WHEN OTHERS THEN
10743: log_to_fnd( p_v_module => 'finp_ins_enr_fee_ass',
10744: p_v_string => 'In Exception Handler WHEN OTHERS.' );

Line 10747: igs_ge_msg_stack.add;

10743: log_to_fnd( p_v_module => 'finp_ins_enr_fee_ass',
10744: p_v_string => 'In Exception Handler WHEN OTHERS.' );
10745: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
10746: fnd_message.set_token('NAME','IGS_FI_PRC_FEE_ASS.FINP_INS_ENR_FEE_ASS-'||SUBSTR(SQLERRM,1,500));
10747: igs_ge_msg_stack.add;
10748: app_exception.raise_exception;
10749: END ;
10750: END finp_ins_enr_fee_ass;
10751: