[Home] [Help]
51: FROM OZF_OFFER_ADJ_NEW_PRODUCTS
52: WHERE OFFER_ADJ_NEW_PRODUCT_ID = l_id;
53:
54: BEGIN
55: -- Standard Start of API savepoint
56: SAVEPOINT CREATE_Adj_New_Prod_PVT;
57:
58: -- Standard call to check for call compatibility.
59: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
54: BEGIN
55: -- Standard Start of API savepoint
56: SAVEPOINT CREATE_Adj_New_Prod_PVT;
57:
58: -- Standard call to check for call compatibility.
59: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
60: p_api_version_number,
61: l_api_name,
62: G_PKG_NAME)
151: -- End of API body
152: --
153:
154: x_offer_adj_new_product_id:= l_offer_adj_new_product_id;
155: -- Standard check for p_commit
156: IF FND_API.to_Boolean( p_commit )
157: THEN
158: COMMIT WORK;
159: END IF;
161:
162: -- Debug Message
163: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
164:
165: -- Standard call to get message count and if count is 1, get message info.
166: FND_MSG_PUB.Count_And_Get
167: (p_count => x_msg_count,
168: p_data => x_msg_data
169: );
175:
176: WHEN FND_API.G_EXC_ERROR THEN
177: ROLLBACK TO CREATE_Adj_New_Prod_PVT;
178: x_return_status := FND_API.G_RET_STS_ERROR;
179: -- Standard call to get message count and if count=1, get the message
180: FND_MSG_PUB.Count_And_Get (
181: p_encoded => FND_API.G_FALSE,
182: p_count => x_msg_count,
183: p_data => x_msg_data
185:
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: ROLLBACK TO CREATE_Adj_New_Prod_PVT;
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: -- Standard call to get message count and if count=1, get the message
190: FND_MSG_PUB.Count_And_Get (
191: p_encoded => FND_API.G_FALSE,
192: p_count => x_msg_count,
193: p_data => x_msg_data
199: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
200: THEN
201: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
202: END IF;
203: -- Standard call to get message count and if count=1, get the message
204: FND_MSG_PUB.Count_And_Get (
205: p_encoded => FND_API.G_FALSE,
206: p_count => x_msg_count,
207: p_data => x_msg_data
239: l_tar_adj_new_prod_rec OZF_Adj_New_Prod_PVT.adj_new_prod_rec_type := P_adj_new_prod_rec;
240: l_rowid ROWID;
241:
242: BEGIN
243: -- Standard Start of API savepoint
244: SAVEPOINT UPDATE_Adj_New_Prod_PVT;
245:
246: -- Standard call to check for call compatibility.
247: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
242: BEGIN
243: -- Standard Start of API savepoint
244: SAVEPOINT UPDATE_Adj_New_Prod_PVT;
245:
246: -- Standard call to check for call compatibility.
247: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
248: p_api_version_number,
249: l_api_name,
250: G_PKG_NAME)
328: p_object_version_number => p_adj_new_prod_rec.object_version_number);
329: --
330: -- End of API body.
331: --
332: -- Standard check for p_commit
333: IF FND_API.to_Boolean( p_commit )
334: THEN
335: COMMIT WORK;
336: END IF;
336: END IF;
337: -- Debug Message
338: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
339:
340: -- Standard call to get message count and if count is 1, get message info.
341: FND_MSG_PUB.Count_And_Get
342: (p_count => x_msg_count,
343: p_data => x_msg_data
344: );
350:
351: WHEN FND_API.G_EXC_ERROR THEN
352: ROLLBACK TO UPDATE_Adj_New_Prod_PVT;
353: x_return_status := FND_API.G_RET_STS_ERROR;
354: -- Standard call to get message count and if count=1, get the message
355: FND_MSG_PUB.Count_And_Get (
356: p_encoded => FND_API.G_FALSE,
357: p_count => x_msg_count,
358: p_data => x_msg_data
360:
361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
362: ROLLBACK TO UPDATE_Adj_New_Prod_PVT;
363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
364: -- Standard call to get message count and if count=1, get the message
365: FND_MSG_PUB.Count_And_Get (
366: p_encoded => FND_API.G_FALSE,
367: p_count => x_msg_count,
368: p_data => x_msg_data
374: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
375: THEN
376: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
377: END IF;
378: -- Standard call to get message count and if count=1, get the message
379: FND_MSG_PUB.Count_And_Get (
380: p_encoded => FND_API.G_FALSE,
381: p_count => x_msg_count,
382: p_data => x_msg_data
401: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
402: l_object_version_number NUMBER;
403:
404: BEGIN
405: -- Standard Start of API savepoint
406: SAVEPOINT DELETE_Adj_New_Prod_PVT;
407:
408: -- Standard call to check for call compatibility.
409: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
404: BEGIN
405: -- Standard Start of API savepoint
406: SAVEPOINT DELETE_Adj_New_Prod_PVT;
407:
408: -- Standard call to check for call compatibility.
409: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
410: p_api_version_number,
411: l_api_name,
412: G_PKG_NAME)
433: p_OFFER_ADJ_NEW_PRODUCT_ID => p_OFFER_ADJ_NEW_PRODUCT_ID);
434: --
435: -- End of API body
436: --
437: -- Standard check for p_commit
438: IF FND_API.to_Boolean( p_commit )
439: THEN
440: COMMIT WORK;
441: END IF;
440: COMMIT WORK;
441: END IF;
442: -- Debug Message
443: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
444: -- Standard call to get message count and if count is 1, get message info.
445: FND_MSG_PUB.Count_And_Get
446: (p_count => x_msg_count,
447: p_data => x_msg_data
448: );
454:
455: WHEN FND_API.G_EXC_ERROR THEN
456: ROLLBACK TO DELETE_Adj_New_Prod_PVT;
457: x_return_status := FND_API.G_RET_STS_ERROR;
458: -- Standard call to get message count and if count=1, get the message
459: FND_MSG_PUB.Count_And_Get (
460: p_encoded => FND_API.G_FALSE,
461: p_count => x_msg_count,
462: p_data => x_msg_data
464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: ROLLBACK TO DELETE_Adj_New_Prod_PVT;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: -- Standard call to get message count and if count=1, get the message
469: FND_MSG_PUB.Count_And_Get (
470: p_encoded => FND_API.G_FALSE,
471: p_count => x_msg_count,
472: p_data => x_msg_data
478: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
479: THEN
480: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
481: END IF;
482: -- Standard call to get message count and if count=1, get the message
483: FND_MSG_PUB.Count_And_Get (
484: p_encoded => FND_API.G_FALSE,
485: p_count => x_msg_count,
486: p_data => x_msg_data
522: THEN
523: FND_MSG_PUB.initialize;
524: END IF;
525:
526: -- Standard call to check for call compatibility.
527: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
528: p_api_version_number,
529: l_api_name,
530: G_PKG_NAME)
566:
567: WHEN FND_API.G_EXC_ERROR THEN
568: ROLLBACK TO LOCK_Adj_New_Prod_PVT;
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: -- Standard call to get message count and if count=1, get the message
571: FND_MSG_PUB.Count_And_Get (
572: p_encoded => FND_API.G_FALSE,
573: p_count => x_msg_count,
574: p_data => x_msg_data
576:
577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
578: ROLLBACK TO LOCK_Adj_New_Prod_PVT;
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
580: -- Standard call to get message count and if count=1, get the message
581: FND_MSG_PUB.Count_And_Get (
582: p_encoded => FND_API.G_FALSE,
583: p_count => x_msg_count,
584: p_data => x_msg_data
590: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
591: THEN
592: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
593: END IF;
594: -- Standard call to get message count and if count=1, get the message
595: FND_MSG_PUB.Count_And_Get (
596: p_encoded => FND_API.G_FALSE,
597: p_count => x_msg_count,
598: p_data => x_msg_data
1118: l_object_version_number NUMBER;
1119: l_adj_new_prod_rec OZF_Adj_New_Prod_PVT.adj_new_prod_rec_type;
1120:
1121: BEGIN
1122: -- Standard Start of API savepoint
1123: SAVEPOINT VALIDATE_Adj_New_Prod_;
1124:
1125: -- Standard call to check for call compatibility.
1126: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1121: BEGIN
1122: -- Standard Start of API savepoint
1123: SAVEPOINT VALIDATE_Adj_New_Prod_;
1124:
1125: -- Standard call to check for call compatibility.
1126: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1127: p_api_version_number,
1128: l_api_name,
1129: G_PKG_NAME)
1182:
1183: -- Debug Message
1184: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1185:
1186: -- Standard call to get message count and if count is 1, get message info.
1187: FND_MSG_PUB.Count_And_Get
1188: (p_count => x_msg_count,
1189: p_data => x_msg_data
1190: );
1196:
1197: WHEN FND_API.G_EXC_ERROR THEN
1198: ROLLBACK TO VALIDATE_Adj_New_Prod_;
1199: x_return_status := FND_API.G_RET_STS_ERROR;
1200: -- Standard call to get message count and if count=1, get the message
1201: FND_MSG_PUB.Count_And_Get (
1202: p_encoded => FND_API.G_FALSE,
1203: p_count => x_msg_count,
1204: p_data => x_msg_data
1206:
1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1208: ROLLBACK TO VALIDATE_Adj_New_Prod_;
1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1210: -- Standard call to get message count and if count=1, get the message
1211: FND_MSG_PUB.Count_And_Get (
1212: p_encoded => FND_API.G_FALSE,
1213: p_count => x_msg_count,
1214: p_data => x_msg_data
1220: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1221: THEN
1222: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1223: END IF;
1224: -- Standard call to get message count and if count=1, get the message
1225: FND_MSG_PUB.Count_And_Get (
1226: p_encoded => FND_API.G_FALSE,
1227: p_count => x_msg_count,
1228: p_data => x_msg_data
1255: -- x_return_status := FND_API.G_RET_STS_ERROR;
1256:
1257: -- Debug Message
1258: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1259: -- Standard call to get message count and if count is 1, get message info.
1260: FND_MSG_PUB.Count_And_Get
1261: (p_count => x_msg_count,
1262: p_data => x_msg_data
1263: );