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 280: AND fun_tca_pkg.get_le_id(p_party_id) = le.party_id

276: AND EXISTS (SELECT 1
277: FROM hz_party_usg_assignments hua
278: WHERE hua.party_id = parties.party_id
279: AND hua.party_usage_code = 'INTERCOMPANY_ORG')
280: AND fun_tca_pkg.get_le_id(p_party_id) = le.party_id
281: AND p_le_id = le.legal_entity_id;
282: --AND transacting_flag = p_instance; Problem here with transacting flag
283:
284: BEGIN

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

285: Debug('IS_PARTY_VALID(+)');
286:
287: -- 7.2.2.2
288: x_return_status := FND_API.G_RET_STS_SUCCESS;
289: l_return_status := FUN_TCA_PKG.is_intercompany_org_valid(p_party_id, p_batch_date);
290: IF l_return_status = 'N' THEN
291: --Bug 5144930. Added new error messages to display the start date and end date.
292: FUN_TCA_PKG.get_ic_org_valid_dates(p_party_id,l_le_start_dt, l_le_end_dt);
293: IF p_type = 'I' THEN

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

288: x_return_status := FND_API.G_RET_STS_SUCCESS;
289: l_return_status := FUN_TCA_PKG.is_intercompany_org_valid(p_party_id, p_batch_date);
290: IF l_return_status = 'N' THEN
291: --Bug 5144930. Added new error messages to display the start date and end date.
292: FUN_TCA_PKG.get_ic_org_valid_dates(p_party_id,l_le_start_dt, l_le_end_dt);
293: IF p_type = 'I' THEN
294: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
295: IF l_le_start_dt IS NULL AND l_le_end_dt IS NULL THEN
296: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_INITIATOR');

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

360:
361: END IF;
362:
363: IF p_local = 'N' THEN
364: l_msr := Fun_Tca_Pkg.Get_System_Reference(p_party_id);
365: IF l_msr IS NULL THEN
366: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
367: FND_MESSAGE.SET_NAME('FUN', 'FUN_PARTY_NO_MSR');
368: FND_MSG_PUB.Add;

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

1369: /* Start of bug 5284760 */
1370: /* Fetch the operating unit id for the initiator party id */
1371: /* This is later passed to get_ar_trx_creation_sign to fetch the
1372: transaction creation sign */
1373: l_from_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_batch_rec.initiator_id,
1374: p_batch_rec.batch_date);
1375: IF l_from_ou_id IS NOT NULL
1376: THEN
1377: -- Fetch the transaction creation sign of

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

2106: x_return_status := FND_API.G_RET_STS_SUCCESS;
2107:
2108: -- API body
2109: Debug('IS_AR_VALID(+)');
2110: l_from_le_party_id := Fun_Tca_Pkg.Get_LE_Id(p_initiator_id, p_trx_date);
2111:
2112: IF l_from_le_party_id IS NOT NULL THEN -- 6145670
2113:
2114: SELECT legal_entity_id

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

2125: x_return_status => x_return_status);
2126:
2127: IF l_invoice_required = 'Y' THEN
2128:
2129: l_from_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_initiator_id, p_trx_date);
2130: IF l_from_ou_id IS NULL THEN
2131: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2132: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_OU');
2133: FND_MSG_PUB.Add;

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

2146: END IF;
2147: Set_Return_Status(x_orig_status => x_return_status,
2148: p_new_status => FND_API.G_RET_STS_ERROR);
2149: END IF;
2150: l_to_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_recipient_id, p_trx_date);
2151:
2152: -- To get the customer association, the transacting LE is the
2153: -- recipient LE.
2154: l_success := Fun_Trading_Relation.Get_Customer('INTERCOMPANY', p_to_le_id,

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

4245: Debug('IS_AP_VALID(+)');
4246: IF p_invoicing_rule = 'Y' THEN
4247:
4248: -- 7.3.1.3
4249: l_to_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_recipient_id, p_trx_date);
4250: IF l_to_ou_id IS NULL THEN
4251: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4252: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_OU');
4253: FND_MSG_PUB.Add;

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

4269: Return;
4270: END IF;
4271:
4272: --
4273: l_from_le_party_id := Fun_Tca_Pkg.Get_LE_Id(p_initiator_id, p_trx_date);
4274:
4275: SELECT legal_entity_id
4276: INTO l_from_le_id
4277: FROM xle_firstparty_information_v

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

4277: FROM xle_firstparty_information_v
4278: WHERE party_id = l_from_le_party_id;
4279: --
4280:
4281: l_from_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_initiator_id, p_trx_date);
4282: IF l_from_ou_id IS NULL THEN
4283: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4284: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_OU');
4285: FND_MSG_PUB.Add;

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

4400: FROM fun_trx_headers
4401: WHERE trx_id = p_trx_id;
4402:
4403: -- Retrieve Operating unit
4404: l_from_ou_id := Fun_Tca_Pkg.Get_OU_Id(l_initiator_id, l_trx_date);
4405:
4406: -- Retrieve memo line, ar trx type
4407: fun_trx_types_pub.Get_Trx_Type_Map(l_from_ou_id, l_trx_type_id,
4408: l_trx_date,