DBA Data[Home] [Help]

APPS.IGS_FI_PRC_FEE_ASS dependencies on APP_EXCEPTION

Line 792: App_Exception.Raise_Exception;

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:
796: PROCEDURE finpl_retn_sort_table ( p_input_tbl1 IN OUT NOCOPY t_fee_as_items_typ,

Line 842: App_Exception.Raise_Exception;

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:
846: PROCEDURE finpl_prc_teach_prd_retn_levl(p_person_id igs_fi_fee_as_all.person_id%TYPE,

Line 1014: app_exception.raise_exception;

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,
1018: p_n_version_number IN igs_en_su_attempt_all.version_number%TYPE,

Line 1442: app_exception.raise_exception;

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:
1446: FUNCTION finp_clc_ass_amnt( p_effective_dt IN DATE ,

Line 1904: App_Exception.Raise_Exception;

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: -------------------------------------------------------------------------------
1908: FUNCTION finpl_get_derived_values (

Line 2367: app_exception.raise_exception;

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:
2371: -------------------------------------------------------------------------------

Line 2773: App_Exception.Raise_Exception;

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,
2777: p_v_fee_cat IN VARCHAR2,

Line 3913: App_Exception.Raise_Exception;

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',
3917: p_v_string => 'From exception handler of When Others.');

Line 3921: App_Exception.Raise_Exception;

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
3925:

Line 4477: App_Exception.Raise_Exception(Null, Null, fnd_message.get);

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',
4481: p_v_string => 'When Others.' || SUBSTR(sqlerrm,1,500));

Line 4503: App_Exception.Raise_Exception;

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;
4507: END finp_clc_ass_amnt;

Line 5641: app_exception.raise_exception;

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(
5645: p_person_id hz_parties.party_id%TYPE,

Line 6089: app_exception.raise_exception;

6085: p_encoded => 'T')
6086: );
6087: END LOOP;
6088: END IF;
6089: app_exception.raise_exception;
6090: END IF;
6091:
6092: IF (p_trace_on = 'Y') THEN
6093: -- Trace Entry

Line 6214: app_exception.raise_exception(NULL, NULL, fnd_message.get);

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
6218: ROLLBACK TO fee_calc_sp;

Line 6225: App_Exception.Raise_Exception(Null, Null, fnd_message.get);

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

Line 6235: App_Exception.Raise_Exception;

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: -------------------------------------------------------------------------------
6239: FUNCTION finpl_prc_sua_load (

Line 6687: app_exception.raise_exception;

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: ------------------------------------------------------------------------------
6691: FUNCTION finpl_clc_chg_mthd_elements(

Line 7707: App_Exception.Raise_Exception;

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:
7711: -------------------------------------------------------------------------------

Line 9131: app_exception.raise_exception(NULL, NULL, fnd_message.get);

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.' );
9135: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');

Line 9138: App_Exception.Raise_Exception;

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,
9142: p_v_course_cd IN igs_ps_ver_all.course_cd%TYPE,

Line 10741: app_exception.raise_exception(NULL, NULL, fnd_message.get);

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.' );
10745: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');

Line 10748: app_exception.raise_exception;

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:
10752: FUNCTION finpl_insert_record(p_n_person_id IN igs_fi_fee_as_all.person_id%TYPE,

Line 11163: app_exception.raise_exception;

11159: p_encoded => 'T')
11160: );
11161: END LOOP;
11162: END IF;
11163: app_exception.raise_exception;
11164: END IF;
11165: IF (p_trace_on = 'Y') THEN
11166: l_v_invoice_num := igs_fi_gen_008.get_invoice_number(l_n_invoice_id);
11167: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RET_CHG_NUM') || ': ' || l_v_invoice_num);