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.

[Home] [Help]

APPS.IGS_FI_PRC_FEE_ROLLV dependencies on IGS_FI_FTCI_ACCTS

Line 42: gurprsin 03-Jun-2005 Enh# 3442712 - Modified TBH calls to table IGS_FI_FTCI_ACCTS to include 4 new Unit Level Attributes i.e. in insert_row method

38: gurprsin 28-Jun-2005 Bug# 3392088 Modified the rollover process to incorporate
39: sub element ranges and rates table rollover.
40: svuppala 03-Jun-2005 Enh# 3442712 - Modified TBH calls to table IGS_FI_FEE_AS_RATE to include
41: 5 new Unit Level Attributes in insert_row method
42: gurprsin 03-Jun-2005 Enh# 3442712 - Modified TBH calls to table IGS_FI_FTCI_ACCTS to include 4 new Unit Level Attributes i.e. in insert_row method
43: svuppala 11-Mar-2004 Bug 4224379 - Changed the function 'finp_ins_roll_uft'.
44: New cursor 'c_alt_cd' is created to get "Alternate code" from
45: igs_ca_inst_all and to send as a token in IGS_FI_ROLLOVER_UFT_ERROR.
46: Added an EXCEPTION to log a message in case of rolling over failure.

Line 3380: unit_mode,unit_class,unit_type_id to TBH call of igs_fi_ftci_accts_pkg

3376: Who When What
3377: sapanigr 14-Jun-2006 Bug 5148913. Unhandled exceptions at insert row caught and appropriate
3378: error message logged.
3379: gurprsin 30-MAY-2005 Enh# 3442712 Added 4 unit level Columns like unit_level,
3380: unit_mode,unit_class,unit_type_id to TBH call of igs_fi_ftci_accts_pkg
3381: in insert row method
3382: pathipat 26-Jun-2003 Bug:2992967 - Table validation value set for segments
3383: Removed cur_rev_account_Seg and its usage. Added call to
3384: fnd_flex_keyval.validate_segs()

Line 3390: FROM igs_fi_ftci_accts

3386: CURSOR cur_ftci_accts(cp_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
3387: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
3388: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
3389: SELECT *
3390: FROM igs_fi_ftci_accts
3391: WHERE fee_type = cp_v_fee_type
3392: AND fee_cal_type = cp_v_fee_cal_type
3393: AND fee_ci_sequence_number = cp_n_fee_ci_seq_number
3394: ORDER BY order_sequence;

Line 3403: TYPE inactive_acc_tab_type IS TABLE OF igs_fi_ftci_accts.order_sequence%TYPE INDEX BY BINARY_INTEGER;

3399: FROM igs_fi_acc
3400: WHERE account_cd = cp_v_rev_acct_cd;
3401: l_rec_rev_account_cd cur_rev_account_cd%ROWTYPE;
3402:
3403: TYPE inactive_acc_tab_type IS TABLE OF igs_fi_ftci_accts.order_sequence%TYPE INDEX BY BINARY_INTEGER;
3404: l_v_natural_account_segment igs_fi_ftci_accts.natural_account_segment%TYPE := NULL;
3405: l_v_revenue_account_cd igs_fi_ftci_accts.rev_account_cd%TYPE := NULL;
3406: l_n_acct_id igs_fi_ftci_accts.acct_id%TYPE;
3407: l_b_inactive_account BOOLEAN;

Line 3404: l_v_natural_account_segment igs_fi_ftci_accts.natural_account_segment%TYPE := NULL;

3400: WHERE account_cd = cp_v_rev_acct_cd;
3401: l_rec_rev_account_cd cur_rev_account_cd%ROWTYPE;
3402:
3403: TYPE inactive_acc_tab_type IS TABLE OF igs_fi_ftci_accts.order_sequence%TYPE INDEX BY BINARY_INTEGER;
3404: l_v_natural_account_segment igs_fi_ftci_accts.natural_account_segment%TYPE := NULL;
3405: l_v_revenue_account_cd igs_fi_ftci_accts.rev_account_cd%TYPE := NULL;
3406: l_n_acct_id igs_fi_ftci_accts.acct_id%TYPE;
3407: l_b_inactive_account BOOLEAN;
3408: l_b_records_found BOOLEAN;

Line 3405: l_v_revenue_account_cd igs_fi_ftci_accts.rev_account_cd%TYPE := NULL;

3401: l_rec_rev_account_cd cur_rev_account_cd%ROWTYPE;
3402:
3403: TYPE inactive_acc_tab_type IS TABLE OF igs_fi_ftci_accts.order_sequence%TYPE INDEX BY BINARY_INTEGER;
3404: l_v_natural_account_segment igs_fi_ftci_accts.natural_account_segment%TYPE := NULL;
3405: l_v_revenue_account_cd igs_fi_ftci_accts.rev_account_cd%TYPE := NULL;
3406: l_n_acct_id igs_fi_ftci_accts.acct_id%TYPE;
3407: l_b_inactive_account BOOLEAN;
3408: l_b_records_found BOOLEAN;
3409: tab_inactive_acc inactive_acc_tab_type;

Line 3406: l_n_acct_id igs_fi_ftci_accts.acct_id%TYPE;

3402:
3403: TYPE inactive_acc_tab_type IS TABLE OF igs_fi_ftci_accts.order_sequence%TYPE INDEX BY BINARY_INTEGER;
3404: l_v_natural_account_segment igs_fi_ftci_accts.natural_account_segment%TYPE := NULL;
3405: l_v_revenue_account_cd igs_fi_ftci_accts.rev_account_cd%TYPE := NULL;
3406: l_n_acct_id igs_fi_ftci_accts.acct_id%TYPE;
3407: l_b_inactive_account BOOLEAN;
3408: l_b_records_found BOOLEAN;
3409: tab_inactive_acc inactive_acc_tab_type;
3410: l_n_cntr PLS_INTEGER ;

Line 3422: fnd_message.set_name ( 'IGS', 'IGS_FI_FTCI_ACCTS_SETUP_EXISTS' );

3418: OPEN cur_ftci_accts ( p_v_fee_type, p_v_dest_cal_type, p_n_dest_sequence_number );
3419: FETCH cur_ftci_accts INTO l_rec_ftci_accts;
3420: IF ( cur_ftci_accts%FOUND )THEN
3421: CLOSE cur_ftci_accts;
3422: fnd_message.set_name ( 'IGS', 'IGS_FI_FTCI_ACCTS_SETUP_EXISTS' );
3423: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
3424: RETURN TRUE;
3425: END IF;
3426: CLOSE cur_ftci_accts;

Line 3483: igs_fi_ftci_accts_pkg.insert_row (

3479: l_n_acct_id := NULL;
3480: -- Rollover Account Attribute Record
3481: --Added 4 unit based parameters.
3482: BEGIN
3483: igs_fi_ftci_accts_pkg.insert_row (
3484: x_rowid => l_v_rowid,
3485: x_acct_id => l_n_acct_id,
3486: x_fee_type => l_rec_ftci_accts.fee_type,
3487: x_fee_cal_type => p_v_dest_cal_type,

Line 3526: fnd_message.set_name ( 'IGS', 'IGS_FI_FTCI_ACCTS_NO_SETUP' );

3522: fnd_message.set_name ( 'IGS', 'IGS_FI_ROLL_FTCI_ACCTS_SUCCESS' );
3523: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
3524: ELSE
3525: -- If No Accounting Information is defined at Source FTCI.
3526: fnd_message.set_name ( 'IGS', 'IGS_FI_FTCI_ACCTS_NO_SETUP' );
3527: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
3528: END IF;
3529:
3530: IF ( l_b_inactive_account ) THEN

Line 3532: fnd_message.set_name ( 'IGS', 'IGS_FI_FTCI_ACCTS_INVALID' );

3528: END IF;
3529:
3530: IF ( l_b_inactive_account ) THEN
3531: fnd_file.put_line ( fnd_file.LOG, ' ' );
3532: fnd_message.set_name ( 'IGS', 'IGS_FI_FTCI_ACCTS_INVALID' );
3533: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
3534: FOR l_n_cntr IN tab_inactive_acc.FIRST..tab_inactive_acc.LAST LOOP
3535: log_parameters ( igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'SEQUENCE'),
3536: tab_inactive_acc(l_n_cntr));