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_BALANCES dependencies on IGS_FI_GEN_GL

Line 357: l_bal_standard := igs_fi_gen_gl.get_formatted_amount(l_bal_standard);

353: CLOSE cur_rec_exists;
354: --Insert a row in igs_fi_balances table.
355: -- Removed the parameter subaccount_id, as a part of Bug # 2564643
356:
357: l_bal_standard := igs_fi_gen_gl.get_formatted_amount(l_bal_standard);
358: l_bal_fee := igs_fi_gen_gl.get_formatted_amount(l_bal_fee);
359: l_bal_hold := igs_fi_gen_gl.get_formatted_amount(l_bal_hold);
360:
361: igs_fi_balances_pkg.insert_row

Line 358: l_bal_fee := igs_fi_gen_gl.get_formatted_amount(l_bal_fee);

354: --Insert a row in igs_fi_balances table.
355: -- Removed the parameter subaccount_id, as a part of Bug # 2564643
356:
357: l_bal_standard := igs_fi_gen_gl.get_formatted_amount(l_bal_standard);
358: l_bal_fee := igs_fi_gen_gl.get_formatted_amount(l_bal_fee);
359: l_bal_hold := igs_fi_gen_gl.get_formatted_amount(l_bal_hold);
360:
361: igs_fi_balances_pkg.insert_row
362: ( X_ROWID => l_rowid,

Line 359: l_bal_hold := igs_fi_gen_gl.get_formatted_amount(l_bal_hold);

355: -- Removed the parameter subaccount_id, as a part of Bug # 2564643
356:
357: l_bal_standard := igs_fi_gen_gl.get_formatted_amount(l_bal_standard);
358: l_bal_fee := igs_fi_gen_gl.get_formatted_amount(l_bal_fee);
359: l_bal_hold := igs_fi_gen_gl.get_formatted_amount(l_bal_hold);
360:
361: igs_fi_balances_pkg.insert_row
362: ( X_ROWID => l_rowid,
363: X_BALANCE_ID => l_balance_id,

Line 665: l_bal_standard := igs_fi_gen_gl.get_formatted_amount(l_bal_standard);

661: END IF;
662:
663: /* Start of insert into the IGS_FI_BALANCES */
664: BEGIN
665: l_bal_standard := igs_fi_gen_gl.get_formatted_amount(l_bal_standard);
666: l_bal_fee := igs_fi_gen_gl.get_formatted_amount(l_bal_fee);
667: l_bal_hold := igs_fi_gen_gl.get_formatted_amount(l_bal_hold);
668:
669:

Line 666: l_bal_fee := igs_fi_gen_gl.get_formatted_amount(l_bal_fee);

662:
663: /* Start of insert into the IGS_FI_BALANCES */
664: BEGIN
665: l_bal_standard := igs_fi_gen_gl.get_formatted_amount(l_bal_standard);
666: l_bal_fee := igs_fi_gen_gl.get_formatted_amount(l_bal_fee);
667: l_bal_hold := igs_fi_gen_gl.get_formatted_amount(l_bal_hold);
668:
669:
670: igs_fi_balances_pkg.insert_row ( X_ROWID => l_rowid ,

Line 667: l_bal_hold := igs_fi_gen_gl.get_formatted_amount(l_bal_hold);

663: /* Start of insert into the IGS_FI_BALANCES */
664: BEGIN
665: l_bal_standard := igs_fi_gen_gl.get_formatted_amount(l_bal_standard);
666: l_bal_fee := igs_fi_gen_gl.get_formatted_amount(l_bal_fee);
667: l_bal_hold := igs_fi_gen_gl.get_formatted_amount(l_bal_hold);
668:
669:
670: igs_fi_balances_pkg.insert_row ( X_ROWID => l_rowid ,
671: X_BALANCE_ID => l_balance_id ,

Line 693: l_n_table_standard_balance :=igs_fi_gen_gl.get_formatted_amount(l_n_table_standard_balance);

689: /* For update we update only the corresponding balance amoounts abd leave others same */
690:
691: IF p_balance_type = 'STANDARD' THEN
692: BEGIN
693: l_n_table_standard_balance :=igs_fi_gen_gl.get_formatted_amount(l_n_table_standard_balance);
694: igs_fi_balances_pkg.update_row
695: (
696: X_ROWID => rec_upd_balance.rowid ,
697: X_BALANCE_ID => rec_upd_balance.balance_id ,

Line 717: l_n_table_fee_balance :=igs_fi_gen_gl.get_formatted_amount(l_n_table_fee_balance);

713: END;
714:
715: ELSIF p_balance_type = 'FEE' THEN
716: BEGIN
717: l_n_table_fee_balance :=igs_fi_gen_gl.get_formatted_amount(l_n_table_fee_balance);
718: igs_fi_balances_pkg.update_row
719: ( X_ROWID => rec_upd_balance.rowid ,
720: X_BALANCE_ID => rec_upd_balance.balance_id ,
721: X_PARTY_ID => rec_upd_balance.party_id ,

Line 739: l_n_table_holds_balance :=igs_fi_gen_gl.get_formatted_amount(l_n_table_holds_balance);

735: END;
736:
737: ELSIF p_balance_type = 'HOLDS' THEN
738: BEGIN
739: l_n_table_holds_balance :=igs_fi_gen_gl.get_formatted_amount(l_n_table_holds_balance);
740: igs_fi_balances_pkg.update_row
741: ( X_ROWID => rec_upd_balance.rowid ,
742: X_BALANCE_ID => rec_upd_balance.balance_id ,
743: X_PARTY_ID => rec_upd_balance.party_id ,

Line 1124: X_STANDARD_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.standard_balance,0) + NVL(p_n_amount,0)) ,

1120: X_ROWID => rec_c_igs_fi_balances.rowid ,
1121: X_BALANCE_ID => rec_c_igs_fi_balances.balance_id ,
1122: X_PARTY_ID => rec_c_igs_fi_balances.party_id ,
1123: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1124: X_STANDARD_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.standard_balance,0) + NVL(p_n_amount,0)) ,
1125: X_FEE_BALANCE => rec_c_igs_fi_balances.fee_balance ,
1126: X_HOLDS_BALANCE => rec_c_igs_fi_balances.holds_balance ,
1127: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1128: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,

Line 1148: X_FEE_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.fee_balance,0) + NVL(p_n_amount,0) ) ,

1144: X_BALANCE_ID => rec_c_igs_fi_balances.balance_id ,
1145: X_PARTY_ID => rec_c_igs_fi_balances.party_id ,
1146: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1147: X_STANDARD_BALANCE => rec_c_igs_fi_balances.standard_balance ,
1148: X_FEE_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.fee_balance,0) + NVL(p_n_amount,0) ) ,
1149: X_HOLDS_BALANCE => rec_c_igs_fi_balances.holds_balance ,
1150: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1151: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1152: X_HOLDS_BALANCE_RULE_ID => rec_c_igs_fi_balances.holds_balance_rule_id ,

Line 1172: X_HOLDS_BALANCE => igs_fi_gen_gl.get_formatted_amount( NVL(rec_c_igs_fi_balances.holds_balance,0) + NVL(p_n_amount,0) ) ,

1168: X_PARTY_ID => rec_c_igs_fi_balances.party_id ,
1169: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1170: X_STANDARD_BALANCE => rec_c_igs_fi_balances.standard_balance ,
1171: X_FEE_BALANCE => rec_c_igs_fi_balances.fee_balance ,
1172: X_HOLDS_BALANCE => igs_fi_gen_gl.get_formatted_amount( NVL(rec_c_igs_fi_balances.holds_balance,0) + NVL(p_n_amount,0) ) ,
1173: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1174: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1175: X_HOLDS_BALANCE_RULE_ID => rec_c_igs_fi_balances.holds_balance_rule_id ,
1176: X_MODE => 'R'

Line 1478: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

1474: OPEN cur_person_number(l_rec_get_balances.party_id);
1475: FETCH cur_person_number INTO l_person_number;
1476:
1477: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
1478: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1479: p_v_lookup_code => 'PERSON')
1480: );
1481: fnd_message.set_token('PARM_CODE', l_person_number);
1482: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1485: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

1481: fnd_message.set_token('PARM_CODE', l_person_number);
1482: fnd_file.put_line(fnd_file.log, fnd_message.get);
1483:
1484: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1485: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1486: p_v_lookup_code => 'BALANCE_DATE')
1487: );
1488: fnd_message.set_token('PARM_CODE', l_rec_get_balances.balance_date);
1489: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1492: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

1488: fnd_message.set_token('PARM_CODE', l_rec_get_balances.balance_date);
1489: fnd_file.put_line(fnd_file.log, fnd_message.get);
1490:
1491: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1492: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1493: p_v_lookup_code => 'BALANCE_RULE_VERSION')
1494: );
1495: fnd_message.set_token('PARM_CODE', l_version_number);
1496: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1499: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

1495: fnd_message.set_token('PARM_CODE', l_version_number);
1496: fnd_file.put_line(fnd_file.log, fnd_message.get);
1497:
1498: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1499: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1500: p_v_lookup_code => 'BALANCE_AMOUNT')
1501: );
1502: fnd_message.set_token('PARM_CODE',igs_fi_gen_gl.get_formatted_amount(l_balance_sum));
1503: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 1502: fnd_message.set_token('PARM_CODE',igs_fi_gen_gl.get_formatted_amount(l_balance_sum));

1498: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1499: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1500: p_v_lookup_code => 'BALANCE_AMOUNT')
1501: );
1502: fnd_message.set_token('PARM_CODE',igs_fi_gen_gl.get_formatted_amount(l_balance_sum));
1503: fnd_file.put_line(fnd_file.log,fnd_message.get);
1504: fnd_file.new_line(fnd_file.log);
1505:
1506: CLOSE cur_person_number;

Line 1526: l_balance_sum := igs_fi_gen_gl.get_formatted_amount(l_balance_sum);

1522:
1523: l_balance_sum := NVL(l_balance_amt,0) + NVL(l_balance_sum,0); -- cumulative balance amount for each party id
1524: l_balance_amt := 0;
1525:
1526: l_balance_sum := igs_fi_gen_gl.get_formatted_amount(l_balance_sum);
1527: -- Update the cumulative balance amount in the fi_balances table under holds_balances
1528: -- and the balance_rule_id under holds_balance_rule_id
1529: IGS_FI_BALANCES_PKG.update_row ( x_rowid => l_rec_get_balances.rowid,
1530: x_balance_id => l_rec_get_balances.balance_id,

Line 1546: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

1542: -- (pathipat) Log file format changed from tabular format to multiline format
1543: -- Used generic function to get the description, and not the local func lookup_Desc
1544: -- Bug: 2672837
1545: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
1546: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1547: p_v_lookup_code => 'PERSON')
1548: );
1549: fnd_message.set_token('PARM_CODE', l_person_number);
1550: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1553: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

1549: fnd_message.set_token('PARM_CODE', l_person_number);
1550: fnd_file.put_line(fnd_file.log, fnd_message.get);
1551:
1552: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1553: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1554: p_v_lookup_code => 'BALANCE_DATE')
1555: );
1556: fnd_message.set_token('PARM_CODE', l_rec_get_balances.balance_date);
1557: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1560: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

1556: fnd_message.set_token('PARM_CODE', l_rec_get_balances.balance_date);
1557: fnd_file.put_line(fnd_file.log, fnd_message.get);
1558:
1559: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1560: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1561: p_v_lookup_code => 'BALANCE_RULE_VERSION')
1562: );
1563: fnd_message.set_token('PARM_CODE', l_version_number);
1564: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1567: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

1563: fnd_message.set_token('PARM_CODE', l_version_number);
1564: fnd_file.put_line(fnd_file.log, fnd_message.get);
1565:
1566: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1567: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1568: p_v_lookup_code => 'BALANCE_AMOUNT')
1569: );
1570: fnd_message.set_token('PARM_CODE',igs_fi_gen_gl.get_formatted_amount(l_balance_sum));
1571: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 1570: fnd_message.set_token('PARM_CODE',igs_fi_gen_gl.get_formatted_amount(l_balance_sum));

1566: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1567: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1568: p_v_lookup_code => 'BALANCE_AMOUNT')
1569: );
1570: fnd_message.set_token('PARM_CODE',igs_fi_gen_gl.get_formatted_amount(l_balance_sum));
1571: fnd_file.put_line(fnd_file.log,fnd_message.get);
1572: fnd_file.new_line(fnd_file.log);
1573:
1574: -- 4