DBA Data[Home] [Help]

APPS.CE_BAT_API dependencies on CE_BAT_UTILS

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

925: RETURN;
926: END IF;
927:
928: -- Foreign currency checks
929: l_source_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);
930: l_destination_ledger_id := CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
931:
932: SELECT currency_code
933: INTO l_source_ledger_curr

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

926: END IF;
927:
928: -- Foreign currency checks
929: l_source_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);
930: l_destination_ledger_id := CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
931:
932: SELECT currency_code
933: INTO l_source_ledger_curr
934: FROM gl_ledgers

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

974: END IF;
975:
976: -- Check if the transfer is within the same ledger or
977: -- different ledgers
978: l_from_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);
979: l_to_ledger_id := CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
980: l_from_bsv := CE_BAT_UTILS.get_bsv(p_source_ba_asset_ccid,l_from_ledger_id);
981: l_to_bsv := CE_BAT_UTILS.get_bsv(p_destination_ba_asset_ccid,l_to_ledger_id);
982: l_intercompany := true;

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

975:
976: -- Check if the transfer is within the same ledger or
977: -- different ledgers
978: l_from_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);
979: l_to_ledger_id := CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
980: l_from_bsv := CE_BAT_UTILS.get_bsv(p_source_ba_asset_ccid,l_from_ledger_id);
981: l_to_bsv := CE_BAT_UTILS.get_bsv(p_destination_ba_asset_ccid,l_to_ledger_id);
982: l_intercompany := true;
983:

Line 980: l_from_bsv := CE_BAT_UTILS.get_bsv(p_source_ba_asset_ccid,l_from_ledger_id);

976: -- Check if the transfer is within the same ledger or
977: -- different ledgers
978: l_from_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);
979: l_to_ledger_id := CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
980: l_from_bsv := CE_BAT_UTILS.get_bsv(p_source_ba_asset_ccid,l_from_ledger_id);
981: l_to_bsv := CE_BAT_UTILS.get_bsv(p_destination_ba_asset_ccid,l_to_ledger_id);
982: l_intercompany := true;
983:
984: -- Call Intercompany API to fetch CCIDs

Line 981: l_to_bsv := CE_BAT_UTILS.get_bsv(p_destination_ba_asset_ccid,l_to_ledger_id);

977: -- different ledgers
978: l_from_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);
979: l_to_ledger_id := CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
980: l_from_bsv := CE_BAT_UTILS.get_bsv(p_source_ba_asset_ccid,l_from_ledger_id);
981: l_to_bsv := CE_BAT_UTILS.get_bsv(p_destination_ba_asset_ccid,l_to_ledger_id);
982: l_intercompany := true;
983:
984: -- Call Intercompany API to fetch CCIDs
985: -- Bug 7357191: Intercompany API calls reworked. The call has to be made

Line 1004: CE_BAT_UTILS.get_intercompany_ccid (

1000: -- Payment LE ==> p_source_le_id
1001: -- Receipt LE ==> p_destination_le_id
1002:
1003: -- fetch debit CC
1004: CE_BAT_UTILS.get_intercompany_ccid (
1005: p_from_le_id => p_source_le_id,
1006: p_to_le_id => p_destination_le_id,
1007: p_from_cash_gl_ccid => p_source_ba_asset_ccid,
1008: p_to_cash_gl_ccid => p_destination_ba_asset_ccid,

Line 1021: CE_BAT_UTILS.get_intercompany_ccid (

1017: -- Set debit CCID as PAYMENT Offset
1018: G_bat_payment_offset_ccid := p_ccid;
1019:
1020: -- fetch credit CC
1021: CE_BAT_UTILS.get_intercompany_ccid (
1022: p_from_le_id => p_destination_le_id,
1023: p_to_le_id => p_source_le_id,
1024: p_from_cash_gl_ccid => p_destination_ba_asset_ccid,
1025: p_to_cash_gl_ccid => p_source_ba_asset_ccid,

Line 1045: CE_BAT_UTILS.get_intercompany_ccid (

1041: -- Payment LE ==> p_destination_le_id
1042: -- Receipt LE ==> p_source_le_id
1043:
1044: -- fetch debit CC
1045: CE_BAT_UTILS.get_intercompany_ccid (
1046: p_from_le_id => p_destination_le_id,
1047: p_to_le_id => p_source_le_id,
1048: p_from_cash_gl_ccid => p_destination_ba_asset_ccid,
1049: p_to_cash_gl_ccid => p_source_ba_asset_ccid,

Line 1062: CE_BAT_UTILS.get_intercompany_ccid (

1058: -- Set debit CCID as PAYMENT offset
1059: G_bat_payment_offset_ccid := p_ccid;
1060:
1061: -- fetch credit CC
1062: CE_BAT_UTILS.get_intercompany_ccid (
1063: p_from_le_id => p_source_le_id,
1064: p_to_le_id => p_destination_le_id,
1065: p_from_cash_gl_ccid => p_source_ba_asset_ccid,
1066: p_to_cash_gl_ccid => p_destination_ba_asset_ccid,

Line 1239: CE_BAT_UTILS.call_payment_process_request(

1235: WHERE payment_request_number = p_pay_proc_req_code;
1236:
1237: IF l_cnt > 0
1238: THEN
1239: CE_BAT_UTILS.call_payment_process_request(
1240: p_pay_proc_req_code,l_request_id);
1241:
1242: IF (l_request_id = 0)
1243: THEN

Line 1282: CE_BAT_UTILS.call_payment_process_request(l_pay_proc_req_code, l_request_id);

1278: WHERE trxn_reference_number = p_trxn_reference_number;
1279:
1280: -- call IBY Build program
1281: log_msg(l_debug_proc,'submitting the Payments build program');
1282: CE_BAT_UTILS.call_payment_process_request(l_pay_proc_req_code, l_request_id);
1283:
1284: IF l_request_id = 0 THEN
1285: FND_MESSAGE.set_name('CE','CE_BAT_IBY_BUILD_FAILED');
1286: FND_MSG_PUB.add;

Line 2303: CE_BAT_UTILS.transfer_payment_transaction(

2299: l_debug_proc VARCHAR2(30) := 'create_update_cashflows';
2300: BEGIN
2301: log_msg(l_debug_proc,'begin');
2302: --create cashflows
2303: CE_BAT_UTILS.transfer_payment_transaction(
2304: p_trxn_reference_number,
2305: G_multi_currency_flag,
2306: p_mode,
2307: p_cashflow_id1,

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

2388: RETURN;
2389: END IF;
2390:
2391: --Get the ledger currencies for source/destination
2392: l_source_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);
2393: l_destination_ledger_id:=CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
2394: SELECT currency_code
2395: INTO l_source_ledger_curr
2396: FROM gl_ledgers

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

2389: END IF;
2390:
2391: --Get the ledger currencies for source/destination
2392: l_source_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);
2393: l_destination_ledger_id:=CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
2394: SELECT currency_code
2395: INTO l_source_ledger_curr
2396: FROM gl_ledgers
2397: WHERE ledger_id=l_source_ledger_id;