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.FUN_TRX_PVT dependencies on FUN_TCA_PKG

Line 327: AND fun_tca_pkg.get_le_id(p_party_id) = le.party_id

323: AND EXISTS (SELECT 1
324: FROM hz_party_usg_assignments hua
325: WHERE hua.party_id = parties.party_id
326: AND hua.party_usage_code = 'INTERCOMPANY_ORG')
327: AND fun_tca_pkg.get_le_id(p_party_id) = le.party_id
328: AND p_le_id = le.legal_entity_id;
329: --AND transacting_flag = p_instance; Problem here with transacting flag
330:
331: BEGIN

Line 336: l_return_status := FUN_TCA_PKG.is_intercompany_org_valid(p_party_id, p_batch_date);

332: Debug('IS_PARTY_VALID(+)');
333:
334: -- 7.2.2.2
335: x_return_status := FND_API.G_RET_STS_SUCCESS;
336: l_return_status := FUN_TCA_PKG.is_intercompany_org_valid(p_party_id, p_batch_date);
337: IF l_return_status = 'N' THEN
338: --Bug 5144930. Added new error messages to display the start date and end date.
339: FUN_TCA_PKG.get_ic_org_valid_dates(p_party_id,l_le_start_dt, l_le_end_dt);
340: IF p_type = 'I' THEN

Line 339: FUN_TCA_PKG.get_ic_org_valid_dates(p_party_id,l_le_start_dt, l_le_end_dt);

335: x_return_status := FND_API.G_RET_STS_SUCCESS;
336: l_return_status := FUN_TCA_PKG.is_intercompany_org_valid(p_party_id, p_batch_date);
337: IF l_return_status = 'N' THEN
338: --Bug 5144930. Added new error messages to display the start date and end date.
339: FUN_TCA_PKG.get_ic_org_valid_dates(p_party_id,l_le_start_dt, l_le_end_dt);
340: IF p_type = 'I' THEN
341: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
342: IF l_le_start_dt IS NULL AND l_le_end_dt IS NULL THEN
343: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_INITIATOR');

Line 411: l_msr := Fun_Tca_Pkg.Get_System_Reference(p_party_id);

407:
408: END IF;
409:
410: IF p_local = 'N' THEN
411: l_msr := Fun_Tca_Pkg.Get_System_Reference(p_party_id);
412: IF l_msr IS NULL THEN
413: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
414: FND_MESSAGE.SET_NAME('FUN', 'FUN_PARTY_NO_MSR');
415: FND_MSG_PUB.Add;

Line 1443: l_from_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_batch_rec.initiator_id,

1439: /* Start of bug 5284760 */
1440: /* Fetch the operating unit id for the initiator party id */
1441: /* This is later passed to get_ar_trx_creation_sign to fetch the
1442: transaction creation sign */
1443: l_from_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_batch_rec.initiator_id,
1444: p_batch_rec.batch_date);
1445: /* IF l_from_ou_id IS NOT NULL
1446: THEN
1447: -- Fetch the transaction creation sign of

Line 2222: l_from_le_party_id := Fun_Tca_Pkg.Get_LE_Id(p_initiator_id, p_trx_date);

2218: x_return_status := FND_API.G_RET_STS_SUCCESS;
2219:
2220: -- API body
2221: Debug('IS_AR_VALID(+)');
2222: l_from_le_party_id := Fun_Tca_Pkg.Get_LE_Id(p_initiator_id, p_trx_date);
2223:
2224: IF l_from_le_party_id IS NOT NULL THEN -- 6145670
2225:
2226: SELECT legal_entity_id

Line 2241: l_from_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_initiator_id, p_trx_date);

2237: x_return_status => x_return_status);
2238:
2239: IF l_invoice_required = 'Y' THEN
2240:
2241: l_from_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_initiator_id, p_trx_date);
2242: IF l_from_ou_id IS NULL THEN
2243: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2244: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_OU');
2245: FND_MSG_PUB.Add;

Line 2262: l_to_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_recipient_id, p_trx_date);

2258: END IF;
2259: Set_Return_Status(x_orig_status => x_return_status,
2260: p_new_status => FND_API.G_RET_STS_ERROR);
2261: END IF;
2262: l_to_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_recipient_id, p_trx_date);
2263:
2264: -- To get the customer association, the transacting LE is the
2265: -- recipient LE.
2266: l_success := Fun_Trading_Relation.Get_Customer('INTERCOMPANY', p_to_le_id,

Line 4545: l_to_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_recipient_id, p_trx_date);

4541: Debug('IS_AP_VALID(+)');
4542: IF p_invoicing_rule = 'Y' THEN
4543:
4544: -- 7.3.1.3
4545: l_to_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_recipient_id, p_trx_date);
4546: IF l_to_ou_id IS NULL THEN
4547: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4548: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_OU');
4549: FND_MSG_PUB.Add;

Line 4569: l_from_le_party_id := Fun_Tca_Pkg.Get_LE_Id(p_initiator_id, p_trx_date);

4565: Return;
4566: END IF;
4567:
4568: --
4569: l_from_le_party_id := Fun_Tca_Pkg.Get_LE_Id(p_initiator_id, p_trx_date);
4570:
4571: SELECT legal_entity_id
4572: INTO l_from_le_id
4573: FROM xle_firstparty_information_v

Line 4577: l_from_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_initiator_id, p_trx_date);

4573: FROM xle_firstparty_information_v
4574: WHERE party_id = l_from_le_party_id;
4575: --
4576:
4577: l_from_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_initiator_id, p_trx_date);
4578: IF l_from_ou_id IS NULL THEN
4579: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4580: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_OU');
4581: FND_MSG_PUB.Add;

Line 4705: l_from_ou_id := Fun_Tca_Pkg.Get_OU_Id(l_initiator_id, l_trx_date);

4701: FROM fun_trx_headers
4702: WHERE trx_id = p_trx_id;
4703:
4704: -- Retrieve Operating unit
4705: l_from_ou_id := Fun_Tca_Pkg.Get_OU_Id(l_initiator_id, l_trx_date);
4706: -- ER:8288979. Passing p_trx_id.
4707: -- Retrieve memo line, ar trx type
4708: fun_trx_types_pub.Get_Trx_Type_Map(l_from_ou_id, l_trx_type_id,
4709: l_trx_date, p_trx_id,