APPS.OZF_OM_VALIDATION_PVT dependencies on FND_PROFILE

Line 103: l_price_list_id := FND_PROFILE.value('OZF_CLAIM_PRICE_LIST_ID');

99: END IF;
100: RAISE FND_API.g_exc_unexpected_error;
101: END IF;
102:
103: l_price_list_id := FND_PROFILE.value('OZF_CLAIM_PRICE_LIST_ID');
104:
105: IF OZF_DEBUG_HIGH_ON THEN
106: OZF_Utility_PVT.debug_message(l_full_name||' : price list id from profile = '||l_price_list_id);
107: END IF;

Line 199: l_inv_org_id := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');

195: IF i IS NOT NULL THEN
196: LOOP
197: IF l_p_x_line_tbl(i).adjusted_unit_price IS NULL THEN
198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
199: l_inv_org_id := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
200: l_prod_name := OZF_UTILITY_PVT.get_product_name(
201: p_prod_level => 'PRODUCT'
202: ,p_prod_id => p_x_item_tbl(i).item_id
203: --,p_org_id => TO_NUMBER(SUBSTRB(userenv('CLIENT_INFO'),1,10))

Line 899: l_org_id := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');

895: l_item_tbl(idx_item).quantity := p_x_claim_line_tbl(i).quantity;
896: -- UOM is required for pricing item
897: IF p_x_claim_line_tbl(i).quantity_uom IS NULL THEN
898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
899: l_org_id := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
900: OPEN csr_product_name(p_x_claim_line_tbl(i).item_id, l_org_id);
901: --OPEN csr_product_name(p_x_claim_line_tbl(i).item_id, l_org_id);
902: FETCH csr_product_name INTO l_csr_product_name;
903: CLOSE csr_product_name;

Line 1461: l_org_id := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');

1457: -- the product needs to belong to the same invoice/order line.
1458: IF p_claim_line_rec.item_id IS NOT NULL AND
1459: p_claim_line_rec.item_id <> l_item_id THEN
1460: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1461: l_org_id := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
1462: OPEN csr_product_name(p_claim_line_rec.item_id, l_org_id);
1463: -- OPEN csr_product_name(p_claim_line_rec.item_id, l_org_id);
1464: FETCH csr_product_name INTO l_csr_product_name;
1465: CLOSE csr_product_name;

Line 1549: l_org_id := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');

1545: -- Initialize API return status to sucess
1546: x_return_status := FND_API.g_ret_sts_success;
1547:
1548: -- l_org_id := TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'), 1, 10));
1549: l_org_id := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
1550:
1551: OPEN csr_item_attr(p_item_id, l_org_id);
1552: FETCH csr_item_attr INTO l_csr_item_attr;
1553: CLOSE csr_item_attr;