[Home] [Help]
98: AND poh.vendor_id = p_vendor_id
99: AND poh.authorization_status IN ('APPROVED','REQUIRES REAPPROVAL')
100: and pol.item_id = p_inventory_item_id
101: AND ((nvl(pol.ALLOW_PRICE_OVERRIDE_FLAG,'N') = 'Y' AND poh.type_lookup_code = 'BLANKET')
102: OR (poh.type_lookup_code = 'STANDARD'))
103: LEFT OUTER JOIN po_line_locations_all pll
104: ON pol.po_line_id = pll.po_line_id
105: AND nvl(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED')
106: AND pll.quantity_received = 0
127: ------------------------------------------
128:
129: po_moac_utils_pvt.set_org_context(l_item_price_rec.org_id);
130:
131: -- Standard begin of API savepoint
132: SAVEPOINT Update_PurchasePrice_PVT;
133: -- Standard call to check for call compatibility.
134: IF NOT FND_API.Compatible_API_Call ( l_api_version,
135: p_api_version,
129: po_moac_utils_pvt.set_org_context(l_item_price_rec.org_id);
130:
131: -- Standard begin of API savepoint
132: SAVEPOINT Update_PurchasePrice_PVT;
133: -- Standard call to check for call compatibility.
134: IF NOT FND_API.Compatible_API_Call ( l_api_version,
135: p_api_version,
136: l_api_name,
137: G_PKG_NAME) THEN
706: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
708: END IF;
709:
710: -- Standard check for p_commit
711: IF FND_API.to_Boolean( p_commit )
712: THEN
713: COMMIT WORK;
714: END IF;
714: END IF;
715: -- Debug Message
716: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'end');
717:
718: -- Standard call to get message count and if count is 1, get message info.
719: FND_MSG_PUB.Count_And_Get
720: (p_count => x_msg_count,
721: p_data => x_msg_data
722: );
724: EXCEPTION
725: WHEN FND_API.G_EXC_ERROR THEN
726: ROLLBACK TO UPDATE_PURCHASEPRICE_PVT;
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: -- Standard call to get message count and if count=1, get the message
729: FND_MSG_PUB.Count_And_Get (
730: p_encoded => FND_API.G_FALSE,
731: p_count => x_msg_count,
732: p_data => x_msg_data
739:
740: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
741: ROLLBACK TO UPDATE_PURCHASEPRICE_PVT;
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: -- Standard call to get message count and if count=1, get the message
744: FND_MSG_PUB.Count_And_Get (
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_msg_count,
747: p_data => x_msg_data
759: fnd_message.set_token('ROUTINE', l_full_name);
760: fnd_message.set_token('ERRNO', sqlcode);
761: fnd_message.set_token('REASON', sqlerrm);
762: FND_MSG_PUB.add;
763: -- Standard call to get message count and if count=1, get the message
764: FND_MSG_PUB.Count_And_Get (
765: p_encoded => FND_API.G_FALSE,
766: p_count => x_msg_count,
767: p_data => x_msg_data
1039: AND ROWNUM = 1;
1040:
1041: -- report card id: 872003
1042: BEGIN
1043: -- Standard call to check for call compatibility.
1044: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1045: p_api_version,
1046: l_api_name,
1047: G_PKG_NAME) THEN
1131: -- Debug Message
1132: IF g_debug THEN
1133: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'end');
1134: END IF;
1135: -- Standard call to get message count and if count is 1, get message info.
1136: FND_MSG_PUB.Count_And_Get
1137: (p_count => x_msg_count,
1138: p_data => x_msg_data
1139: );
1139: );
1140: EXCEPTION
1141: WHEN FND_API.G_EXC_ERROR THEN
1142: x_return_status := FND_API.G_RET_STS_ERROR;
1143: -- Standard call to get message count and if count=1, get the message
1144: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
1145: p_count => x_msg_count,
1146: p_data => x_msg_data
1147: );
1152: END IF;
1153:
1154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1156: -- Standard call to get message count and if count=1, get the message
1157: FND_MSG_PUB.Count_And_Get (
1158: p_encoded => FND_API.G_FALSE,
1159: p_count => x_msg_count,
1160: p_data => x_msg_data
1171: fnd_message.set_token('ROUTINE', l_full_name);
1172: fnd_message.set_token('ERRNO', sqlcode);
1173: fnd_message.set_token('REASON', sqlerrm);
1174: FND_MSG_PUB.add;
1175: -- Standard call to get message count and if count=1, get the message
1176: FND_MSG_PUB.Count_And_Get (
1177: p_encoded => FND_API.G_FALSE,
1178: p_count => x_msg_count,
1179: p_data => x_msg_data