DBA Data[Home] [Help]

APPS.IGS_FI_BILL_EXTRACT dependencies on IGS_FI_GEN_GL

Line 890: x_opening_balance => igs_fi_gen_gl.get_formatted_amount(l_n_opening_balance),

886: x_bill_date => TRUNC(SYSDATE),
887: x_due_date => p_d_due_dt,
888: x_person_id => p_n_person_id,
889: x_bill_from_date => l_d_start_date,
890: x_opening_balance => igs_fi_gen_gl.get_formatted_amount(l_n_opening_balance),
891: x_cut_off_date => p_d_cutoff_dt,
892: x_closing_balance => igs_fi_gen_gl.get_formatted_amount(l_n_closing_balance),
893: x_to_pay_amount => igs_fi_gen_gl.get_formatted_amount(l_to_pay_amount), --added as a part of bug:2293676
894: x_printed_flag => 'N',

Line 892: x_closing_balance => igs_fi_gen_gl.get_formatted_amount(l_n_closing_balance),

888: x_person_id => p_n_person_id,
889: x_bill_from_date => l_d_start_date,
890: x_opening_balance => igs_fi_gen_gl.get_formatted_amount(l_n_opening_balance),
891: x_cut_off_date => p_d_cutoff_dt,
892: x_closing_balance => igs_fi_gen_gl.get_formatted_amount(l_n_closing_balance),
893: x_to_pay_amount => igs_fi_gen_gl.get_formatted_amount(l_to_pay_amount), --added as a part of bug:2293676
894: x_printed_flag => 'N',
895: x_print_date => NULL,
896: x_mode => 'R'

Line 893: x_to_pay_amount => igs_fi_gen_gl.get_formatted_amount(l_to_pay_amount), --added as a part of bug:2293676

889: x_bill_from_date => l_d_start_date,
890: x_opening_balance => igs_fi_gen_gl.get_formatted_amount(l_n_opening_balance),
891: x_cut_off_date => p_d_cutoff_dt,
892: x_closing_balance => igs_fi_gen_gl.get_formatted_amount(l_n_closing_balance),
893: x_to_pay_amount => igs_fi_gen_gl.get_formatted_amount(l_to_pay_amount), --added as a part of bug:2293676
894: x_printed_flag => 'N',
895: x_print_date => NULL,
896: x_mode => 'R'
897: );

Line 928: l_v_fee_class_meaning := igs_fi_gen_gl.get_lkp_meaning(p_v_lookup_type => 'FEE_CLASS',

924: IF l_v_s_fee_type = 'SPONSOR' THEN
925: -- check if it has Fee_Class defined
926: IF l_v_fee_class IS NOT NULL THEN
927: --Get the fee class meaning
928: l_v_fee_class_meaning := igs_fi_gen_gl.get_lkp_meaning(p_v_lookup_type => 'FEE_CLASS',
929: p_v_lookup_code => l_v_fee_class);
930:
931: --Append the fee class meaning to the invoice_desc
932: rec_cur_charge_trans.invoice_desc := rec_cur_charge_trans.invoice_desc || ' : ' || l_v_fee_class_meaning;

Line 947: x_transaction_amount => igs_fi_gen_gl.get_formatted_amount(rec_cur_charge_trans.invoice_amount),

943: x_transaction_date => rec_cur_charge_trans.invoice_creation_date,
944: x_transaction_number => rec_cur_charge_trans.invoice_number,
945: x_fee_credit_type => rec_cur_charge_trans.fee_type,
946: x_transaction_description => rec_cur_charge_trans.invoice_desc,
947: x_transaction_amount => igs_fi_gen_gl.get_formatted_amount(rec_cur_charge_trans.invoice_amount),
948: x_mode => 'R'
949: );
950: END LOOP;
951:

Line 978: x_transaction_amount => igs_fi_gen_gl.get_formatted_amount(rec_cur_credit_trans.amount),

974: x_transaction_date => rec_cur_credit_trans.effective_date,
975: x_transaction_number => rec_cur_credit_trans.credit_number,
976: x_fee_credit_type => rec_cur_credit_trans.credit_type,
977: x_transaction_description => rec_cur_credit_trans.description,
978: x_transaction_amount => igs_fi_gen_gl.get_formatted_amount(rec_cur_credit_trans.amount),
979: x_mode => 'R'
980: );
981: END LOOP;
982:

Line 1022: x_pln_credit_amount => igs_fi_gen_gl.get_formatted_amount(l_cur_planned_crd.disb_net_amt),

1018: x_pln_credit_date => l_cur_planned_crd.disb_date,
1019: x_fund_id => l_cur_planned_crd.fund_id,
1020: x_fee_cal_type => l_fee_cal_type,
1021: x_fee_ci_sequence_number => l_fee_ci_seq_num,
1022: x_pln_credit_amount => igs_fi_gen_gl.get_formatted_amount(l_cur_planned_crd.disb_net_amt),
1023: x_mode => 'R',
1024: x_bill_desc => l_bill_desc
1025: );
1026: END LOOP;

Line 1317: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP'));

1313: FETCH cur_person_id_group INTO rec_cur_person_id_group;
1314: IF (cur_person_id_group%NOTFOUND) THEN
1315: CLOSE cur_person_id_group;
1316: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
1317: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP'));
1318: igs_ge_msg_stack.add;
1319: p_c_status := 'FALSE';
1320: RETURN;
1321: ELSE

Line 1331: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PARTY'));

1327: -- Check if the Person ID is valid.
1328: -- Bug 5178298 - changed the message to IGS_FI_INVALID_PARAMETER
1329: IF igs_fi_gen_007.validate_person(p_n_person_id) = 'N' THEN
1330: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
1331: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PARTY'));
1332: igs_ge_msg_stack.add;
1333: p_c_status := 'FALSE';
1334: RETURN;
1335: END IF;

Line 1346: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEST_MODE'));

1342: -- Check if the value of the parameter Test Mode is valid.
1343: -- Bug 5178298 - changed the message to IGS_FI_INVALID_PARAMETER
1344: IF ((p_c_test_mode NOT IN ('Y', 'N')) OR (p_c_test_mode IS NULL)) THEN
1345: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1346: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEST_MODE'));
1347: igs_ge_msg_stack.add;
1348: p_c_status := 'FALSE';
1349: RETURN;
1350: END IF;

Line 1413: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'BILL_ADDR_USG_1'));

1409: -- Bug 5178298 - Modified the message
1410:
1411: IF (p_c_site_usg_type_cd_1 IS NULL) THEN
1412: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1413: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'BILL_ADDR_USG_1'));
1414: igs_ge_msg_stack.add;
1415: p_c_status := 'FALSE';
1416: RETURN;
1417: END IF;

Line 1644: X_INSTALLMENT_AMT => igs_fi_gen_gl.get_formatted_amount(rec_pp_instlmnts.installment_amt),

1640: X_BILL_ID => p_n_bill_id,
1641: X_INSTALLMENT_ID => rec_pp_instlmnts.installment_id,
1642: X_INSTALLMENT_LINE_NUM => rec_pp_instlmnts.installment_line_num,
1643: X_INSTALLMENT_DUE_DATE => rec_pp_instlmnts.due_date,
1644: X_INSTALLMENT_AMT => igs_fi_gen_gl.get_formatted_amount(rec_pp_instlmnts.installment_amt),
1645: X_DUE_AMT => igs_fi_gen_gl.get_formatted_amount(rec_pp_instlmnts.due_amt),
1646: X_MODE => 'R'
1647: );
1648: END LOOP; -- end of payment plan installment loop

Line 1645: X_DUE_AMT => igs_fi_gen_gl.get_formatted_amount(rec_pp_instlmnts.due_amt),

1641: X_INSTALLMENT_ID => rec_pp_instlmnts.installment_id,
1642: X_INSTALLMENT_LINE_NUM => rec_pp_instlmnts.installment_line_num,
1643: X_INSTALLMENT_DUE_DATE => rec_pp_instlmnts.due_date,
1644: X_INSTALLMENT_AMT => igs_fi_gen_gl.get_formatted_amount(rec_pp_instlmnts.installment_amt),
1645: X_DUE_AMT => igs_fi_gen_gl.get_formatted_amount(rec_pp_instlmnts.due_amt),
1646: X_MODE => 'R'
1647: );
1648: END LOOP; -- end of payment plan installment loop
1649:

Line 1679: X_INSTALLMENT_AMT => igs_fi_gen_gl.get_formatted_amount(rec_pp_instlmnts.installment_amt),

1675: X_BILL_ID => p_n_bill_id,
1676: X_INSTALLMENT_ID => rec_pp_instlmnts.installment_id,
1677: X_INSTALLMENT_LINE_NUM => rec_pp_instlmnts.installment_line_num,
1678: X_INSTALLMENT_DUE_DATE => rec_pp_instlmnts.due_date,
1679: X_INSTALLMENT_AMT => igs_fi_gen_gl.get_formatted_amount(rec_pp_instlmnts.installment_amt),
1680: X_DUE_AMT => igs_fi_gen_gl.get_formatted_amount(rec_pp_instlmnts.due_amt),
1681: X_MODE => 'R'
1682: );
1683:

Line 1680: X_DUE_AMT => igs_fi_gen_gl.get_formatted_amount(rec_pp_instlmnts.due_amt),

1676: X_INSTALLMENT_ID => rec_pp_instlmnts.installment_id,
1677: X_INSTALLMENT_LINE_NUM => rec_pp_instlmnts.installment_line_num,
1678: X_INSTALLMENT_DUE_DATE => rec_pp_instlmnts.due_date,
1679: X_INSTALLMENT_AMT => igs_fi_gen_gl.get_formatted_amount(rec_pp_instlmnts.installment_amt),
1680: X_DUE_AMT => igs_fi_gen_gl.get_formatted_amount(rec_pp_instlmnts.due_amt),
1681: X_MODE => 'R'
1682: );
1683:
1684: END LOOP; -- end of payment plan installment loop