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_FI_PRC_HOLDS dependencies on FND_NEW_MESSAGES

Line 120: l_v_pln_cr_message fnd_new_messages.message_name%TYPE := NULL;

116:
117: ***************************************************************/
118:
119: l_v_planned_credits_ind igs_fi_control_all.planned_credits_ind%TYPE := NULL;
120: l_v_pln_cr_message fnd_new_messages.message_name%TYPE := NULL;
121:
122: BEGIN
123: --Call the genric function to get the value
124: l_v_planned_credits_ind := igs_fi_gen_001.finp_get_planned_credits_ind(l_v_pln_cr_message);

Line 273: l_message_name fnd_new_messages.message_name%TYPE := NULL;

269: l_hold_plan_rec c_hold_plan%ROWTYPE ;
270: l_holds_balance_rec c_holds_balance%ROWTYPE;
271: l_credit_amnt_rec c_credit_amnt%ROWTYPE;
272: l_invoice_amnt_rec c_invoice_amnt%ROWTYPE;
273: l_message_name fnd_new_messages.message_name%TYPE := NULL;
274: l_holds_balance igs_fi_balances.holds_balance%TYPE :=0;
275: l_payment_due_date igs_fi_person_holds.process_start_dT%TYPE;
276: l_credit_subac igs_fi_credits.amount%TYPE :=0;
277: l_tot_credits igs_fi_credits.amount%TYPE :=0;

Line 285: l_v_pln_cr_message fnd_new_messages.message_name%TYPE :=NULL;

281:
282: -- Changes due to SFCR018
283: -- Call the local function to get the value of planned_credits_ind
284: l_v_pln_cr_ind igs_fi_control_all.planned_credits_ind%TYPE := get_planned_credits_ind;
285: l_v_pln_cr_message fnd_new_messages.message_name%TYPE :=NULL;
286: l_n_planned_credit igs_fi_credits.amount%TYPE :=0;
287: -- Changes due to SFCR018
288:
289: l_n_threshold_amount igs_fi_hold_plan.threshold_amount%TYPE ;

Line 630: l_message_name fnd_new_messages.message_name%TYPE :=NULL;

626: AND TRUNC(start_dt) = TRUNC(p_hold_start_date);
627:
628: --local varaibles declaration
629: l_hold_exist_rec c_hold_exist%ROWTYPE;
630: l_message_name fnd_new_messages.message_name%TYPE :=NULL;
631: l_message_string fnd_new_messages.message_text%TYPE;
632: l_rowid VARCHAR2(25) :=NULL;
633:
634:

Line 631: l_message_string fnd_new_messages.message_text%TYPE;

627:
628: --local varaibles declaration
629: l_hold_exist_rec c_hold_exist%ROWTYPE;
630: l_message_name fnd_new_messages.message_name%TYPE :=NULL;
631: l_message_string fnd_new_messages.message_text%TYPE;
632: l_rowid VARCHAR2(25) :=NULL;
633:
634:
635: BEGIN

Line 1086: l_message_name fnd_new_messages.message_name%TYPE :=NULL;

1082: l_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE;
1083: l_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE;
1084: l_person_number igs_pe_person.person_number%TYPE :=NULL;
1085: l_person_name igs_pe_person_base_v.full_name%TYPE :=NULL;
1086: l_message_name fnd_new_messages.message_name%TYPE :=NULL;
1087: l_message_name_1 fnd_new_messages.message_name%TYPE :=NULL;
1088: l_hold_type igs_fi_hold_plan.hold_type%TYPE;
1089: l_hold_plan_level igs_fi_hold_plan.hold_plan_level%TYPE;
1090: l_hold_plan_name igs_fi_hold_plan.hold_plan_name%TYPE;

Line 1087: l_message_name_1 fnd_new_messages.message_name%TYPE :=NULL;

1083: l_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE;
1084: l_person_number igs_pe_person.person_number%TYPE :=NULL;
1085: l_person_name igs_pe_person_base_v.full_name%TYPE :=NULL;
1086: l_message_name fnd_new_messages.message_name%TYPE :=NULL;
1087: l_message_name_1 fnd_new_messages.message_name%TYPE :=NULL;
1088: l_hold_type igs_fi_hold_plan.hold_type%TYPE;
1089: l_hold_plan_level igs_fi_hold_plan.hold_plan_level%TYPE;
1090: l_hold_plan_name igs_fi_hold_plan.hold_plan_name%TYPE;
1091: l_holds_charges igs_fi_inv_int.invoice_amount%TYPE := 0;

Line 1102: l_v_message_name fnd_new_messages.message_name%TYPE :=NULL;

1098:
1099: l_process_run_ind igs_fi_control_all.conv_process_run_ind%TYPE;
1100:
1101: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;
1102: l_v_message_name fnd_new_messages.message_name%TYPE :=NULL;
1103: l_n_offset_days igs_fi_hold_plan.offset_days%TYPE :=0;
1104: l_n_student_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE;
1105: l_d_last_inst_due_date igs_fi_pp_instlmnts.due_date%TYPE;
1106: l_n_fnd_user_id fnd_user.user_id%TYPE;

Line 1109: l_v_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

1105: l_d_last_inst_due_date igs_fi_pp_instlmnts.due_date%TYPE;
1106: l_n_fnd_user_id fnd_user.user_id%TYPE;
1107: l_v_person_number hz_parties.party_number%TYPE;
1108: l_v_person_name hz_person_profiles.person_name%TYPE;
1109: l_v_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1110:
1111:
1112: BEGIN
1113:

Line 1522: P_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE)

1518:
1519: FUNCTION validate_param(p_person_id IN igs_pe_person_v.person_id%TYPE,
1520: p_person_id_group IN igs_pe_persid_group_v.group_id%TYPE,
1521: P_hold_plan_name IN igs_fi_hold_plan.hold_plan_name%Type,
1522: P_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE)
1523: RETURN BOOLEAN
1524: IS
1525: /***************************************************************
1526: Created By : bayadav

Line 1631: P_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE,

1627: FUNCTION validate_holds( p_person_id IN igs_pe_person.person_id%TYPE,
1628: P_hold_plan_name IN igs_fi_hold_plan.hold_plan_name%TYPE,
1629: P_test_run IN VARCHAR2 ,
1630: P_release OUT NOCOPY PLS_INTEGER,
1631: P_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE,
1632: p_release_credit_id IN igs_fi_person_holds.release_credit_id%TYPE := NULL,
1633: p_hold_plan_level IN igs_fi_hold_plan.hold_plan_level%TYPE := NULL
1634: ) RETURN BOOLEAN IS
1635: /***************************************************************

Line 1801: l_message_name fnd_new_messages.message_name%TYPE := NULL;

1797: l_hold_type_rec c_hold_type%ROWTYPE;
1798: l_credit_amount_rec c_credit_amount%ROWTYPE;
1799: l_total_balance_rec c_total_balance%ROWTYPE;
1800: l_hold_plan_name igs_fi_hold_plan.hold_plan_name%TYPE;
1801: l_message_name fnd_new_messages.message_name%TYPE := NULL;
1802: l_tot_amnt_all_subact igs_fi_credits.amount%TYPE := 0;
1803: l_non_ex_amnt_each_sc igs_fi_credits.amount%TYPE := 0;
1804: l_total_charges igs_fi_balances.holds_balance%TYPE := 0.0;
1805: l_final_balance_amnt igs_fi_balances.holds_balance%TYPE := 0.0;

Line 1818: l_v_pln_cr_message fnd_new_messages.message_name%TYPE :=NULL;

1814: l_hold_bal_amt igs_fi_balances.holds_balance%TYPE := 0.0;
1815:
1816: -- Changes due to SFCR018
1817: l_v_pln_cr_ind igs_fi_control_all.planned_credits_ind%TYPE := get_planned_credits_ind;
1818: l_v_pln_cr_message fnd_new_messages.message_name%TYPE :=NULL;
1819: l_n_planned_credit igs_fi_credits.amount%TYPE;
1820: -- Changes due to SFCR018
1821:
1822: l_c_message_name fnd_new_messages.message_name%TYPE := NULL;

Line 1822: l_c_message_name fnd_new_messages.message_name%TYPE := NULL;

1818: l_v_pln_cr_message fnd_new_messages.message_name%TYPE :=NULL;
1819: l_n_planned_credit igs_fi_credits.amount%TYPE;
1820: -- Changes due to SFCR018
1821:
1822: l_c_message_name fnd_new_messages.message_name%TYPE := NULL;
1823: l_n_threshold_amount igs_fi_hold_plan.threshold_amount%TYPE ;
1824: l_n_threshold_percent igs_fi_hold_plan.threshold_percent%TYPE ;
1825: --Boolean variable added for Bug 3049184
1826: l_b_ret_amt_grt_msg_flag BOOLEAN ;

Line 2222: P_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE)

2218: PROCEDURE finp_release_holds_main(p_person_id IN igs_pe_person.person_id%TYPE ,
2219: p_person_id_group IN igs_pe_persid_group_v.group_id%TYPE ,
2220: P_hold_plan_name IN Igs_fi_hold_plan.hold_plan_name%TYPE ,
2221: P_test_run IN VARCHAR2 ,
2222: P_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE)
2223: IS
2224: /***************************************************************
2225: Created By : bayadav
2226: Date Created By : 29-Nov-2001

Line 2273: l_message_name fnd_new_messages.message_name%TYPE :=NULL;

2269: l_person_number igs_pe_person.person_number%TYPE :=NULL;
2270: l_start_date igs_pe_pers_encumb.start_dt%TYPE;
2271: l_passed_hold_type igs_fi_person_holds.hold_type%TYPE ;
2272: l_hold_plan_name igs_fi_hold_plan.hold_plan_name%TYPE :=NULL;
2273: l_message_name fnd_new_messages.message_name%TYPE :=NULL;
2274: l_message_name_1 fnd_new_messages.message_name%TYPE :=NULL;
2275: l_release_hold VARCHAR2(10) :='Y';
2276: l_release NUMBER :=0;
2277: l_msg_str_0 VARCHAR2(1000);

Line 2274: l_message_name_1 fnd_new_messages.message_name%TYPE :=NULL;

2270: l_start_date igs_pe_pers_encumb.start_dt%TYPE;
2271: l_passed_hold_type igs_fi_person_holds.hold_type%TYPE ;
2272: l_hold_plan_name igs_fi_hold_plan.hold_plan_name%TYPE :=NULL;
2273: l_message_name fnd_new_messages.message_name%TYPE :=NULL;
2274: l_message_name_1 fnd_new_messages.message_name%TYPE :=NULL;
2275: l_release_hold VARCHAR2(10) :='Y';
2276: l_release NUMBER :=0;
2277: l_msg_str_0 VARCHAR2(1000);
2278: l_msg_str_1 VARCHAR2(1000);

Line 2288: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;

2284:
2285: l_n_total_count PLS_INTEGER := 0;
2286:
2287: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;
2288: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
2289: l_v_line_sepr VARCHAR2(1000) := '+-----------------------------------------------------------------------+';
2290:
2291: BEGIN
2292: p_message_name := NULL;

Line 2591: l_message_name fnd_new_messages.message_name%TYPE :=NULL;

2587: pathipat 26-Feb-2003 Enh 2747341 - Additional Security for Holds
2588: Added code related to messages IGS_PE_HOLD_AUTH_CR, IGS_GE_NOT_STAFF_MEMBER
2589: and IGS_FI_FEW_HOLDS_REL_ERR
2590: ***************************************************************/
2591: l_message_name fnd_new_messages.message_name%TYPE :=NULL;
2592: l_error NUMBER :=0;
2593:
2594: BEGIN
2595: --To set the org id

Line 2686: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;

2682: l_v_credit_number igs_fi_credits_all.credit_number%TYPE := NULL;
2683: l_d_last_conv_dt igs_fi_balance_rules.last_conversion_date%TYPE := NULL;
2684: l_n_version_number igs_fi_balance_rules.version_number%TYPE := NULL;
2685: l_n_release PLS_INTEGER := 0;
2686: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
2687:
2688: BEGIN
2689:
2690: OPEN cur_active_holds(p_person_id, p_hold_plan_level);