[Home] [Help]
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;
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))
472: CLOSE csr_inv_line_price;
473: END IF;
474:
475: /*--Profile logic added for bug 7680032 (This profile option was obsolated from R12 ,They made the same as OM system paramter we modified the code accordingly.
476: IF fnd_profile.Value('OE_DISCOUNT_DETAILS_ON_INVOICE') = 'Y' THEN
477: OPEN csr_om_line_price(p_x_inv_line_tbl(i).source_object_line_id);
478: FETCH csr_om_line_price INTO p_x_inv_line_tbl(i).item_id
479: , p_x_inv_line_tbl(i).rate
480: , p_x_inv_line_tbl(i).quantity_uom;
954: l_item_tbl(idx_item).quantity := p_x_claim_line_tbl(i).quantity;
955: -- UOM is required for pricing item
956: IF p_x_claim_line_tbl(i).quantity_uom IS NULL THEN
957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
958: l_org_id := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
959: OPEN csr_product_name(p_x_claim_line_tbl(i).item_id, l_org_id);
960: --OPEN csr_product_name(p_x_claim_line_tbl(i).item_id, l_org_id);
961: FETCH csr_product_name INTO l_csr_product_name;
962: CLOSE csr_product_name;
1519: -- the product needs to belong to the same invoice/order line.
1520: IF p_claim_line_rec.item_id IS NOT NULL AND
1521: p_claim_line_rec.item_id <> l_item_id THEN
1522: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1523: l_org_id := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
1524: OPEN csr_product_name(p_claim_line_rec.item_id, l_org_id);
1525: -- OPEN csr_product_name(p_claim_line_rec.item_id, l_org_id);
1526: FETCH csr_product_name INTO l_csr_product_name;
1527: CLOSE csr_product_name;
1607: -- Initialize API return status to sucess
1608: x_return_status := FND_API.g_ret_sts_success;
1609:
1610: -- l_org_id := TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'), 1, 10));
1611: l_org_id := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
1612:
1613: OPEN csr_item_attr(p_item_id, l_org_id);
1614: FETCH csr_item_attr INTO l_csr_item_attr;
1615: CLOSE csr_item_attr;