[Home] [Help]
51: FROM OZF_OFFER_ADJ_NEW_LINES
52: WHERE OFFER_ADJ_NEW_LINE_ID = l_id;
53:
54: BEGIN
55: -- Standard Start of API savepoint
56: SAVEPOINT CREATE_Adj_New_Line_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_Line_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)
160: --
161: -- End of API body
162: --
163:
164: -- Standard check for p_commit
165: IF FND_API.to_Boolean( p_commit )
166: THEN
167: COMMIT WORK;
168: END IF;
178:
179: WHEN FND_API.G_EXC_ERROR THEN
180: ROLLBACK TO CREATE_Adj_New_Line_PVT;
181: x_return_status := FND_API.G_RET_STS_ERROR;
182: -- Standard call to get message count and if count=1, get the message
183: FND_MSG_PUB.Count_And_Get (
184: p_encoded => FND_API.G_FALSE,
185: p_count => x_msg_count,
186: p_data => x_msg_data
188:
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: ROLLBACK TO CREATE_Adj_New_Line_PVT;
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: -- Standard call to get message count and if count=1, get the message
193: FND_MSG_PUB.Count_And_Get (
194: p_encoded => FND_API.G_FALSE,
195: p_count => x_msg_count,
196: p_data => x_msg_data
202: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
203: THEN
204: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
205: END IF;
206: -- Standard call to get message count and if count=1, get the message
207: FND_MSG_PUB.Count_And_Get (
208: p_encoded => FND_API.G_FALSE,
209: p_count => x_msg_count,
210: p_data => x_msg_data
244: l_tar_adj_new_line_rec OZF_Adj_New_Line_PVT.adj_new_line_rec_type := P_adj_new_line_rec;
245: l_rowid ROWID;
246:
247: BEGIN
248: -- Standard Start of API savepoint
249: SAVEPOINT UPDATE_Adj_New_Line_PVT;
250:
251: -- Standard call to check for call compatibility.
252: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
247: BEGIN
248: -- Standard Start of API savepoint
249: SAVEPOINT UPDATE_Adj_New_Line_PVT;
250:
251: -- Standard call to check for call compatibility.
252: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
253: p_api_version_number,
254: l_api_name,
255: G_PKG_NAME)
340: p_object_version_number => p_adj_new_line_rec.object_version_number);
341: --
342: -- End of API body.
343: --
344: -- Standard check for p_commit
345: IF FND_API.to_Boolean( p_commit )
346: THEN
347: COMMIT WORK;
348: END IF;
356:
357: WHEN FND_API.G_EXC_ERROR THEN
358: ROLLBACK TO UPDATE_Adj_New_Line_PVT;
359: x_return_status := FND_API.G_RET_STS_ERROR;
360: -- Standard call to get message count and if count=1, get the message
361: FND_MSG_PUB.Count_And_Get (
362: p_encoded => FND_API.G_FALSE,
363: p_count => x_msg_count,
364: p_data => x_msg_data
366:
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368: ROLLBACK TO UPDATE_Adj_New_Line_PVT;
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
370: -- Standard call to get message count and if count=1, get the message
371: FND_MSG_PUB.Count_And_Get (
372: p_encoded => FND_API.G_FALSE,
373: p_count => x_msg_count,
374: p_data => x_msg_data
380: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
381: THEN
382: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
383: END IF;
384: -- Standard call to get message count and if count=1, get the message
385: FND_MSG_PUB.Count_And_Get (
386: p_encoded => FND_API.G_FALSE,
387: p_count => x_msg_count,
388: p_data => x_msg_data
417: FROM ozf_offer_adj_new_lines
418: WHERE parent_adj_line_id = cp_offerAdjNewLineId;
419:
420: BEGIN
421: -- Standard Start of API savepoint
422: SAVEPOINT DELETE_Adj_New_Line_PVT;
423:
424: -- Standard call to check for call compatibility.
425: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
420: BEGIN
421: -- Standard Start of API savepoint
422: SAVEPOINT DELETE_Adj_New_Line_PVT;
423:
424: -- Standard call to check for call compatibility.
425: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
426: p_api_version_number,
427: l_api_name,
428: G_PKG_NAME)
482: -- End of API body
483: --
484: OZF_UTILITY_PVT.debug_message( 'Private API: Called delete table handler');
485:
486: -- Standard check for p_commit
487: IF FND_API.to_Boolean( p_commit )
488: THEN
489: COMMIT WORK;
490: END IF;
492:
493: -- Debug Message
494: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
495:
496: -- Standard call to get message count and if count is 1, get message info.
497: FND_MSG_PUB.Count_And_Get
498: (p_count => x_msg_count,
499: p_data => x_msg_data
500: );
506:
507: WHEN FND_API.G_EXC_ERROR THEN
508: ROLLBACK TO DELETE_Adj_New_Line_PVT;
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: -- Standard call to get message count and if count=1, get the message
511: FND_MSG_PUB.Count_And_Get (
512: p_encoded => FND_API.G_FALSE,
513: p_count => x_msg_count,
514: p_data => x_msg_data
516:
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518: ROLLBACK TO DELETE_Adj_New_Line_PVT;
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: -- Standard call to get message count and if count=1, get the message
521: FND_MSG_PUB.Count_And_Get (
522: p_encoded => FND_API.G_FALSE,
523: p_count => x_msg_count,
524: p_data => x_msg_data
530: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
531: THEN
532: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
533: END IF;
534: -- Standard call to get message count and if count=1, get the message
535: FND_MSG_PUB.Count_And_Get (
536: p_encoded => FND_API.G_FALSE,
537: p_count => x_msg_count,
538: p_data => x_msg_data
577: THEN
578: FND_MSG_PUB.initialize;
579: END IF;
580:
581: -- Standard call to check for call compatibility.
582: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
583: p_api_version_number,
584: l_api_name,
585: G_PKG_NAME)
624:
625: WHEN FND_API.G_EXC_ERROR THEN
626: ROLLBACK TO LOCK_Adj_New_Line_PVT;
627: x_return_status := FND_API.G_RET_STS_ERROR;
628: -- Standard call to get message count and if count=1, get the message
629: FND_MSG_PUB.Count_And_Get (
630: p_encoded => FND_API.G_FALSE,
631: p_count => x_msg_count,
632: p_data => x_msg_data
634:
635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
636: ROLLBACK TO LOCK_Adj_New_Line_PVT;
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
638: -- Standard call to get message count and if count=1, get the message
639: FND_MSG_PUB.Count_And_Get (
640: p_encoded => FND_API.G_FALSE,
641: p_count => x_msg_count,
642: p_data => x_msg_data
648: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
649: THEN
650: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
651: END IF;
652: -- Standard call to get message count and if count=1, get the message
653: FND_MSG_PUB.Count_And_Get (
654: p_encoded => FND_API.G_FALSE,
655: p_count => x_msg_count,
656: p_data => x_msg_data
1166: l_object_version_number NUMBER;
1167: l_adj_new_line_rec OZF_Adj_New_Line_PVT.adj_new_line_rec_type;
1168:
1169: BEGIN
1170: -- Standard Start of API savepoint
1171: SAVEPOINT VALIDATE_Adj_New_Line_;
1172:
1173: -- Standard call to check for call compatibility.
1174: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1169: BEGIN
1170: -- Standard Start of API savepoint
1171: SAVEPOINT VALIDATE_Adj_New_Line_;
1172:
1173: -- Standard call to check for call compatibility.
1174: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1175: p_api_version_number,
1176: l_api_name,
1177: G_PKG_NAME)
1233:
1234: WHEN FND_API.G_EXC_ERROR THEN
1235: ROLLBACK TO VALIDATE_Adj_New_Line_;
1236: x_return_status := FND_API.G_RET_STS_ERROR;
1237: -- Standard call to get message count and if count=1, get the message
1238: FND_MSG_PUB.Count_And_Get (
1239: p_encoded => FND_API.G_FALSE,
1240: p_count => x_msg_count,
1241: p_data => x_msg_data
1243:
1244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1245: ROLLBACK TO VALIDATE_Adj_New_Line_;
1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1247: -- Standard call to get message count and if count=1, get the message
1248: FND_MSG_PUB.Count_And_Get (
1249: p_encoded => FND_API.G_FALSE,
1250: p_count => x_msg_count,
1251: p_data => x_msg_data
1257: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1258: THEN
1259: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1260: END IF;
1261: -- Standard call to get message count and if count=1, get the message
1262: FND_MSG_PUB.Count_And_Get (
1263: p_encoded => FND_API.G_FALSE,
1264: p_count => x_msg_count,
1265: p_data => x_msg_data
1292: -- x_return_status := FND_API.G_RET_STS_ERROR;
1293:
1294: -- Debug Message
1295: OZF_UTILITY_PVT.debug_message('Private API: Validate_adj_new_line_rec');
1296: -- Standard call to get message count and if count is 1, get message info.
1297: FND_MSG_PUB.Count_And_Get
1298: (p_count => x_msg_count,
1299: p_data => x_msg_data
1300: );
1381: l_adj_new_line_rec adj_new_line_rec_type;
1382: l_adj_new_prod_rec OZF_Adj_New_Prod_PVT.adj_new_prod_rec_type;
1383: l_offer_adj_new_product_id NUMBER;
1384: BEGIN
1385: -- Standard Start of API savepoint
1386: SAVEPOINT Create_Adj_New_Disc_Pvt;
1387: -- Standard call to check for call compatibility.
1388: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1389: p_api_version_number,
1383: l_offer_adj_new_product_id NUMBER;
1384: BEGIN
1385: -- Standard Start of API savepoint
1386: SAVEPOINT Create_Adj_New_Disc_Pvt;
1387: -- Standard call to check for call compatibility.
1388: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1389: p_api_version_number,
1390: l_api_name,
1391: G_PKG_NAME)
1480:
1481: WHEN FND_API.G_EXC_ERROR THEN
1482: ROLLBACK TO Create_Adj_New_Disc_Pvt;
1483: x_return_status := FND_API.G_RET_STS_ERROR;
1484: -- Standard call to get message count and if count=1, get the message
1485: FND_MSG_PUB.Count_And_Get (
1486: p_encoded => FND_API.G_FALSE,
1487: p_count => x_msg_count,
1488: p_data => x_msg_data
1490:
1491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1492: ROLLBACK TO Create_Adj_New_Disc_Pvt;
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1494: -- Standard call to get message count and if count=1, get the message
1495: FND_MSG_PUB.Count_And_Get (
1496: p_encoded => FND_API.G_FALSE,
1497: p_count => x_msg_count,
1498: p_data => x_msg_data
1504: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1505: THEN
1506: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1507: END IF;
1508: -- Standard call to get message count and if count=1, get the message
1509: FND_MSG_PUB.Count_And_Get (
1510: p_encoded => FND_API.G_FALSE,
1511: p_count => x_msg_count,
1512: p_data => x_msg_data
1534: l_adj_new_line_rec adj_new_line_rec_type;
1535: l_adj_new_prod_rec OZF_Adj_New_Prod_PVT.adj_new_prod_rec_type;
1536: l_object_version_number NUMBER;
1537: BEGIN
1538: -- Standard Start of API savepoint
1539: SAVEPOINT Update_Adj_New_Disc_Pvt;
1540: -- Standard call to check for call compatibility.
1541: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1542: p_api_version_number,
1536: l_object_version_number NUMBER;
1537: BEGIN
1538: -- Standard Start of API savepoint
1539: SAVEPOINT Update_Adj_New_Disc_Pvt;
1540: -- Standard call to check for call compatibility.
1541: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1542: p_api_version_number,
1543: l_api_name,
1544: G_PKG_NAME)
1616: END IF;
1617: --
1618: -- End of API body.
1619: --
1620: -- Standard check for p_commit
1621: IF FND_API.to_Boolean( p_commit )
1622: THEN
1623: COMMIT WORK;
1624: END IF;
1632:
1633: WHEN FND_API.G_EXC_ERROR THEN
1634: ROLLBACK TO Update_Adj_New_Disc_Pvt;
1635: x_return_status := FND_API.G_RET_STS_ERROR;
1636: -- Standard call to get message count and if count=1, get the message
1637: FND_MSG_PUB.Count_And_Get (
1638: p_encoded => FND_API.G_FALSE,
1639: p_count => x_msg_count,
1640: p_data => x_msg_data
1642:
1643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1644: ROLLBACK TO Update_Adj_New_Disc_Pvt;
1645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1646: -- Standard call to get message count and if count=1, get the message
1647: FND_MSG_PUB.Count_And_Get (
1648: p_encoded => FND_API.G_FALSE,
1649: p_count => x_msg_count,
1650: p_data => x_msg_data
1656: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1657: THEN
1658: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1659: END IF;
1660: -- Standard call to get message count and if count=1, get the message
1661: FND_MSG_PUB.Count_And_Get (
1662: p_encoded => FND_API.G_FALSE,
1663: p_count => x_msg_count,
1664: p_data => x_msg_data