DBA Data[Home] [Help]

APPS.IGS_FI_PRC_FEE_ASS dependencies on IGS_FI_PRC_FEE_ASS

Line 1: PACKAGE BODY igs_fi_prc_fee_ass AS

1: PACKAGE BODY igs_fi_prc_fee_ass AS
2: /* $Header: IGSFI09B.pls 120.45 2006/06/29 12:00:04 abshriva ship $ */
3:
4: /*************************************************************
5: Created By :

Line 1012: Fnd_Message.Set_Token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_PRC_TEACH_PRD_RETN_LEVL-'||SUBSTR(SQLERRM,1,500));

1008: WHEN Others THEN
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:

Line 1440: fnd_message.set_token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_GET_DERIVED_AM_AT-'||SUBSTR(sqlerrm,1,500));

1436: WHEN OTHERS THEN
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: -----------------------------------------------------------------------------------

Line 1902: Fnd_Message.Set_Token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_INS_MATCH_CHG_RATE-'||SUBSTR(sqlerrm,1,500));

1898: WHEN OTHERS THEN
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:

Line 2365: fnd_message.set_token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_GET_DERIVED_VALUES-'||SUBSTR(sqlerrm,1,500));

2361: WHEN OTHERS THEN
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:

Line 2771: Fnd_Message.Set_Token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_FIND_FAR-'||SUBSTR(sqlerrm,1,500));

2767: WHEN OTHERS THEN
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:

Line 3911: FND_MESSAGE.SET_TOKEN('NAME','IGS_FI_PRC_FEE_ASS.FINPL_PRC_ELEMENT_RANGES-'||SUBSTR(sqlerrm,1,500));

3907: WHEN e_one_record_expected THEN
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

Line 3919: Fnd_Message.Set_Token('NAME','igs_fi_prc_fee_ass.finpl_prc_element_ranges-'||SUBSTR(sqlerrm,1,500));

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.');
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:

Line 4457: FND_MESSAGE.SET_TOKEN('NAME','IGS_FI_PRC_FEE_ASS.FINP_CLC_ASS_AMNT-'||SUBSTR(sqlerrm,1,500));

4453: WHEN e_one_record_expected THEN
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||','||

Line 4483: FND_MESSAGE.SET_TOKEN('NAME','IGS_FI_PRC_FEE_ASS.FINP_CLC_ASS_AMNT');

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));
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||','||

Line 4955: Fnd_Message.Set_Token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_SUM_FEE_ASS_ITEM-'||SUBSTR(sqlerrm,1,500));

4951: p_v_string => 'From Exception Handler of When Others.');
4952: v_message_name := 'IGS_GE_UNHANDLED_EXP';
4953: IF (p_trace_on = 'Y') THEN
4954: fnd_message.set_name('IGS', v_message_name);
4955: Fnd_Message.Set_Token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_SUM_FEE_ASS_ITEM-'||SUBSTR(sqlerrm,1,500));
4956: fnd_file.put_line (fnd_file.log, fnd_message.get);
4957: END IF;
4958: p_message_name := v_message_name;
4959: RETURN FALSE;

Line 5639: Fnd_Message.Set_Token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_CHK_DEBT_RET_SCHED-'||SUBSTR(SQLERRM,1,500));

5635: WHEN Others THEN
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:

Line 6223: Fnd_Message.Set_Token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_INS_FEE_ASS-'||SUBSTR(sqlerrm,1,500));

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

Line 6233: Fnd_Message.Set_Token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_INS_FEE_ASS-'||SUBSTR(sqlerrm,1,500));

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

Line 6685: fnd_message.set_token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_PRC_SUA_LOAD-'||SUBSTR(sqlerrm,1,500));

6681: WHEN OTHERS THEN
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:

Line 7690: FND_MESSAGE.SET_TOKEN('NAME','IGS_FI_PRC_FEE_ASS.FINPL_CLC_CHG_MTHD_ELEMENTS-'||SUBSTR(sqlerrm,1,500));

7686: WHEN OTHERS THEN
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)||','||

Line 8346: Fnd_Message.Set_Token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_INIT_FEE_ASS_ITEM');

8342: p_v_string => 'From Exception Handler of When Others.');
8343: v_message_name := 'IGS_GE_UNHANDLED_EXP';
8344: IF (p_trace_on = 'Y') THEN
8345: fnd_message.set_name('IGS', v_message_name);
8346: Fnd_Message.Set_Token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_INIT_FEE_ASS_ITEM');
8347: fnd_file.put_line (fnd_file.log, fnd_message.get);
8348: END IF;
8349: RETURN FALSE;
8350: END finpl_init_fee_ass_item;

Line 9136: Fnd_Message.Set_Token('NAME','IGS_FI_PRC_FEE_ASS.FINPL_PRC_FEE_CAT_FEE_LIAB-'||SUBSTR(sqlerrm,1,500));

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');
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:

Line 10739: fnd_message.set_token('NAME','IGS_FI_PRC_FEE_ASS.FINP_INS_ENR_FEE_ASS-'||SUBSTR(SQLERRM,1,500));

10735: WHEN e_one_record_expected THEN
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',

Line 10746: fnd_message.set_token('NAME','IGS_FI_PRC_FEE_ASS.FINP_INS_ENR_FEE_ASS-'||SUBSTR(SQLERRM,1,500));

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');
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;

Line 11251: END igs_fi_prc_fee_ass;

11247: RETURN l_v_org_unit_cd;
11248:
11249: END finpl_get_org_unit_cd;
11250:
11251: END igs_fi_prc_fee_ass;