DBA Data[Home] [Help]

APPS.CE_BAT_API dependencies on CE_BAT_UTILS

Line 764: l_source_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);

760: END IF;
761:
762: -- Both the bank accounts cannot be non-functional currency.
763:
764: l_source_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);
765: l_destination_ledger_id:=CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
766: SELECT currency_code
767: INTO l_source_ledger_curr
768: FROM gl_ledgers

Line 765: l_destination_ledger_id:=CE_BAT_UTILS.get_ledger_id(p_destination_le_id);

761:
762: -- Both the bank accounts cannot be non-functional currency.
763:
764: l_source_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);
765: l_destination_ledger_id:=CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
766: SELECT currency_code
767: INTO l_source_ledger_curr
768: FROM gl_ledgers
769: WHERE ledger_id=l_source_ledger_id;

Line 802: l_from_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);

798: END IF;
799:
800: -- Check if the transfer is within the same ledger or
801: -- different ledgers
802: l_from_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);
803: l_to_ledger_id := CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
804: l_from_bsv := CE_BAT_UTILS.get_bsv(p_source_ba_asset_ccid,
805: l_from_ledger_id);
806: l_to_bsv := CE_BAT_UTILS.get_bsv(p_destination_ba_asset_ccid,

Line 803: l_to_ledger_id := CE_BAT_UTILS.get_ledger_id(p_destination_le_id);

799:
800: -- Check if the transfer is within the same ledger or
801: -- different ledgers
802: l_from_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);
803: l_to_ledger_id := CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
804: l_from_bsv := CE_BAT_UTILS.get_bsv(p_source_ba_asset_ccid,
805: l_from_ledger_id);
806: l_to_bsv := CE_BAT_UTILS.get_bsv(p_destination_ba_asset_ccid,
807: l_to_ledger_id);

Line 804: l_from_bsv := CE_BAT_UTILS.get_bsv(p_source_ba_asset_ccid,

800: -- Check if the transfer is within the same ledger or
801: -- different ledgers
802: l_from_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);
803: l_to_ledger_id := CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
804: l_from_bsv := CE_BAT_UTILS.get_bsv(p_source_ba_asset_ccid,
805: l_from_ledger_id);
806: l_to_bsv := CE_BAT_UTILS.get_bsv(p_destination_ba_asset_ccid,
807: l_to_ledger_id);
808: /* commented these lines for bug 5528877

Line 806: l_to_bsv := CE_BAT_UTILS.get_bsv(p_destination_ba_asset_ccid,

802: l_from_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);
803: l_to_ledger_id := CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
804: l_from_bsv := CE_BAT_UTILS.get_bsv(p_source_ba_asset_ccid,
805: l_from_ledger_id);
806: l_to_bsv := CE_BAT_UTILS.get_bsv(p_destination_ba_asset_ccid,
807: l_to_ledger_id);
808: /* commented these lines for bug 5528877
809: IF (l_from_ledger_id <> l_to_ledger_id) THEN
810: l_intercompany := true;

Line 838: CE_BAT_UTILS.get_intercompany_ccid (

834: -- Payment LE ==> p_source_le_id
835: -- Receipt LE ==> p_destination_le_id
836:
837: -- fetch debit CC
838: CE_BAT_UTILS.get_intercompany_ccid (
839: p_from_le_id => p_source_le_id,
840: p_to_le_id => p_destination_le_id,
841: p_from_cash_gl_ccid => p_source_ba_asset_ccid,
842: p_to_cash_gl_ccid => p_destination_ba_asset_ccid,

Line 855: CE_BAT_UTILS.get_intercompany_ccid (

851: -- Set debit CCID as PAYMENT Offset
852: G_bat_payment_offset_ccid := p_ccid;
853:
854: -- fetch credit CC
855: CE_BAT_UTILS.get_intercompany_ccid (
856: p_from_le_id => p_destination_le_id,
857: p_to_le_id => p_source_le_id,
858: p_from_cash_gl_ccid => p_destination_ba_asset_ccid,
859: p_to_cash_gl_ccid => p_source_ba_asset_ccid,

Line 879: CE_BAT_UTILS.get_intercompany_ccid (

875: -- Payment LE ==> p_destination_le_id
876: -- Receipt LE ==> p_source_le_id
877:
878: -- fetch debit CC
879: CE_BAT_UTILS.get_intercompany_ccid (
880: p_from_le_id => p_destination_le_id,
881: p_to_le_id => p_source_le_id,
882: p_from_cash_gl_ccid => p_destination_ba_asset_ccid,
883: p_to_cash_gl_ccid => p_source_ba_asset_ccid,

Line 896: CE_BAT_UTILS.get_intercompany_ccid (

892: -- Set debit CCID as PAYMENT offset
893: G_bat_payment_offset_ccid := p_ccid;
894:
895: -- fetch credit CC
896: CE_BAT_UTILS.get_intercompany_ccid (
897: p_from_le_id => p_source_le_id,
898: p_to_le_id => p_destination_le_id,
899: p_from_cash_gl_ccid => p_source_ba_asset_ccid,
900: p_to_cash_gl_ccid => p_destination_ba_asset_ccid,

Line 1057: CE_BAT_UTILS.call_payment_process_request(

1053: FROM ce_payment_transactions
1054: WHERE payment_request_number = p_pay_proc_req_code;
1055:
1056: IF l_cnt > 0 THEN
1057: CE_BAT_UTILS.call_payment_process_request(
1058: p_pay_proc_req_code,l_request_id);
1059:
1060: IF (l_request_id = 0) THEN
1061: FND_MESSAGE.set_name('CE','CE_BAT_IBY_BUILD_FAILED');

Line 1087: CE_BAT_UTILS.call_payment_process_request(

1083: WHERE trxn_reference_number = p_trxn_reference_number;
1084:
1085: -- call IBY Build program
1086: log('submitting the Payments build program');
1087: CE_BAT_UTILS.call_payment_process_request(
1088: l_pay_proc_req_code,l_request_id);
1089:
1090: IF l_request_id = 0 THEN
1091: FND_MESSAGE.set_name('CE','CE_BAT_IBY_BUILD_FAILED');

Line 1903: CE_BAT_UTILS.transfer_payment_transaction(

1899: BEGIN
1900: log('>>create_update_cashflows..');
1901: log('>>creating cashflows..');
1902: --create cashflows
1903: CE_BAT_UTILS.transfer_payment_transaction(
1904: p_trxn_reference_number,
1905: G_multi_currency_flag,
1906: p_mode,
1907: p_cashflow_id1,

Line 1972: l_source_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);

1968: RETURN;
1969: END IF;
1970:
1971: --Get the ledger currencies for source/destination
1972: l_source_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);
1973: l_destination_ledger_id:=CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
1974: SELECT currency_code
1975: INTO l_source_ledger_curr
1976: FROM gl_ledgers

Line 1973: l_destination_ledger_id:=CE_BAT_UTILS.get_ledger_id(p_destination_le_id);

1969: END IF;
1970:
1971: --Get the ledger currencies for source/destination
1972: l_source_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);
1973: l_destination_ledger_id:=CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
1974: SELECT currency_code
1975: INTO l_source_ledger_curr
1976: FROM gl_ledgers
1977: WHERE ledger_id=l_source_ledger_id;