[Home] [Help]
97: AND poh.vendor_id = p_vendor_id
98: AND poh.authorization_status IN ('APPROVED','REQUIRES REAPPROVAL')
99: and pol.item_id = p_inventory_item_id
100: AND ((nvl(pol.ALLOW_PRICE_OVERRIDE_FLAG,'N') = 'Y' AND poh.type_lookup_code = 'BLANKET')
101: OR (poh.type_lookup_code = 'STANDARD'))
102: LEFT OUTER JOIN po_line_locations_all pll
103: ON pol.po_line_id = pll.po_line_id
104: AND nvl(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED')
105: AND pll.quantity_received = 0
126: ------------------------------------------
127:
128: po_moac_utils_pvt.set_org_context(l_item_price_rec.org_id);
129:
130: -- Standard begin of API savepoint
131: SAVEPOINT Update_PurchasePrice_PVT;
132: -- Standard call to check for call compatibility.
133: IF NOT FND_API.Compatible_API_Call ( l_api_version,
134: p_api_version,
128: po_moac_utils_pvt.set_org_context(l_item_price_rec.org_id);
129:
130: -- Standard begin of API savepoint
131: SAVEPOINT Update_PurchasePrice_PVT;
132: -- Standard call to check for call compatibility.
133: IF NOT FND_API.Compatible_API_Call ( l_api_version,
134: p_api_version,
135: l_api_name,
136: G_PKG_NAME) THEN
715: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
717: END IF;
718:
719: -- Standard check for p_commit
720: IF FND_API.to_Boolean( p_commit )
721: THEN
722: COMMIT WORK;
723: END IF;
724: -- Debug Message
725: IF g_debug THEN
726: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
727: END IF;
728: -- Standard call to get message count and if count is 1, get message info.
729: FND_MSG_PUB.Count_And_Get
730: (p_count => x_msg_count,
731: p_data => x_msg_data
732: );
734: EXCEPTION
735: WHEN FND_API.G_EXC_ERROR THEN
736: ROLLBACK TO UPDATE_PURCHASEPRICE_PVT;
737: x_return_status := FND_API.G_RET_STS_ERROR;
738: -- Standard call to get message count and if count=1, get the message
739: FND_MSG_PUB.Count_And_Get (
740: p_encoded => FND_API.G_FALSE,
741: p_count => x_msg_count,
742: p_data => x_msg_data
749:
750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
751: ROLLBACK TO UPDATE_PURCHASEPRICE_PVT;
752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
753: -- Standard call to get message count and if count=1, get the message
754: FND_MSG_PUB.Count_And_Get (
755: p_encoded => FND_API.G_FALSE,
756: p_count => x_msg_count,
757: p_data => x_msg_data
769: fnd_message.set_token('ROUTINE', l_full_name);
770: fnd_message.set_token('ERRNO', sqlcode);
771: fnd_message.set_token('REASON', sqlerrm);
772: FND_MSG_PUB.add;
773: -- Standard call to get message count and if count=1, get the message
774: FND_MSG_PUB.Count_And_Get (
775: p_encoded => FND_API.G_FALSE,
776: p_count => x_msg_count,
777: p_data => x_msg_data
1048: AND ROWNUM = 1;
1049:
1050: -- report card id: 872003
1051: BEGIN
1052: -- Standard call to check for call compatibility.
1053: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1054: p_api_version,
1055: l_api_name,
1056: G_PKG_NAME) THEN
1141: -- Debug Message
1142: IF g_debug THEN
1143: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1144: END IF;
1145: -- Standard call to get message count and if count is 1, get message info.
1146: FND_MSG_PUB.Count_And_Get
1147: (p_count => x_msg_count,
1148: p_data => x_msg_data
1149: );
1149: );
1150: EXCEPTION
1151: WHEN FND_API.G_EXC_ERROR THEN
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: -- Standard call to get message count and if count=1, get the message
1154: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
1155: p_count => x_msg_count,
1156: p_data => x_msg_data
1157: );
1162: END IF;
1163:
1164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1166: -- Standard call to get message count and if count=1, get the message
1167: FND_MSG_PUB.Count_And_Get (
1168: p_encoded => FND_API.G_FALSE,
1169: p_count => x_msg_count,
1170: p_data => x_msg_data
1181: fnd_message.set_token('ROUTINE', l_full_name);
1182: fnd_message.set_token('ERRNO', sqlcode);
1183: fnd_message.set_token('REASON', sqlerrm);
1184: FND_MSG_PUB.add;
1185: -- Standard call to get message count and if count=1, get the message
1186: FND_MSG_PUB.Count_And_Get (
1187: p_encoded => FND_API.G_FALSE,
1188: p_count => x_msg_count,
1189: p_data => x_msg_data