[Home] [Help]
319: -- x_return_status OUT VARCHAR2
320: -- x_msg_count OUT NUMBER
321: -- x_msg_data OUT VARCHAR2
322: -- Version : Current version 1.0
323: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
324: -- and basic operation, developer must manually add parameters and business logic as necessary.
325: --
326: -- History
327: --
360: SELECT 1
361: FROM ozf_OFFER_ADJUSTMENT_LINES
362: WHERE offer_adjustment_line_id = l_id;
363: BEGIN
364: -- Standard Start of API savepoint
365: SAVEPOINT create_offer_adj_line_pvt;
366:
367: -- Standard call to check for call compatibility.
368: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
363: BEGIN
364: -- Standard Start of API savepoint
365: SAVEPOINT create_offer_adj_line_pvt;
366:
367: -- Standard call to check for call compatibility.
368: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
369: p_api_version_number,
370: l_api_name,
371: G_PKG_NAME)
481: --
482: -- End of API body
483: --
484:
485: -- Standard check for p_commit
486: IF FND_API.to_Boolean( p_commit )
487: THEN
488: COMMIT WORK;
489: END IF;
492: -- Debug Message
493: debug_message('Private API: ' || l_api_name || 'end');
494:
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: );
507:
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO CREATE_Offer_Adj_Line_PVT;
510: x_return_status := FND_API.G_RET_STS_ERROR;
511: -- Standard call to get message count and if count=1, get the message
512: FND_MSG_PUB.Count_And_Get (
513: p_encoded => FND_API.G_FALSE,
514: p_count => x_msg_count,
515: p_data => x_msg_data
517:
518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
519: ROLLBACK TO CREATE_Offer_Adj_Line_PVT;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521: -- Standard call to get message count and if count=1, get the message
522: FND_MSG_PUB.Count_And_Get (
523: p_encoded => FND_API.G_FALSE,
524: p_count => x_msg_count,
525: p_data => x_msg_data
531: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
532: THEN
533: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
534: END IF;
535: -- Standard call to get message count and if count=1, get the message
536: FND_MSG_PUB.Count_And_Get (
537: p_encoded => FND_API.G_FALSE,
538: p_count => x_msg_count,
539: p_data => x_msg_data
593: FROM ozf_offers
594: WHERE qp_list_header_id = p_list_header_id;
595:
596: BEGIN
597: -- Standard Start of API savepoint
598: SAVEPOINT create_new_offer_adj_line_pvt;
599:
600: -- Standard call to check for call compatibility.
601: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
596: BEGIN
597: -- Standard Start of API savepoint
598: SAVEPOINT create_new_offer_adj_line_pvt;
599:
600: -- Standard call to check for call compatibility.
601: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
602: p_api_version_number,
603: l_api_name,
604: G_PKG_NAME)
736: --
737: -- End of API body
738: --
739:
740: -- Standard check for p_commit
741: IF FND_API.to_Boolean( p_commit )
742: THEN
743: COMMIT WORK;
744: END IF;
746: -- Debug Message
747: debug_message('Private API: ' || l_api_name || 'end');
748:
749:
750: -- Standard call to get message count and if count is 1, get message info.
751: FND_MSG_PUB.Count_And_Get
752: (p_count => x_msg_count,
753: p_data => x_msg_data
754: );
760:
761: WHEN FND_API.G_EXC_ERROR THEN
762: ROLLBACK TO CREATE_new_Offer_Adj_Line_PVT;
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: -- Standard call to get message count and if count=1, get the message
765: FND_MSG_PUB.Count_And_Get (
766: p_encoded => FND_API.G_FALSE,
767: p_count => x_msg_count,
768: p_data => x_msg_data
770:
771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
772: ROLLBACK TO CREATE_New_Offer_Adj_Line_PVT;
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774: -- Standard call to get message count and if count=1, get the message
775: FND_MSG_PUB.Count_And_Get (
776: p_encoded => FND_API.G_FALSE,
777: p_count => x_msg_count,
778: p_data => x_msg_data
784: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
785: THEN
786: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
787: END IF;
788: -- Standard call to get message count and if count=1, get the message
789: FND_MSG_PUB.Count_And_Get (
790: p_encoded => FND_API.G_FALSE,
791: p_count => x_msg_count,
792: p_data => x_msg_data
816: -- x_return_status OUT VARCHAR2
817: -- x_msg_count OUT NUMBER
818: -- x_msg_data OUT VARCHAR2
819: -- Version : Current version 1.0
820: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
821: -- and basic operation, developer must manually add parameters and business logic as necessary.
822: --
823: -- History
824: --
860: l_tar_offadj_line_rec offadj_line_rec_type := P_offadj_line_rec;
861: l_rowid ROWID;
862:
863: BEGIN
864: -- Standard Start of API savepoint
865: SAVEPOINT update_offer_adj_line_pvt;
866:
867: -- Standard call to check for call compatibility.
868: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
863: BEGIN
864: -- Standard Start of API savepoint
865: SAVEPOINT update_offer_adj_line_pvt;
866:
867: -- Standard call to check for call compatibility.
868: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
869: p_api_version_number,
870: l_api_name,
871: G_PKG_NAME)
984: --
985: -- End of API body.
986: --
987:
988: -- Standard check for p_commit
989: IF FND_API.to_Boolean( p_commit )
990: THEN
991: COMMIT WORK;
992: END IF;
995: -- Debug Message
996: debug_message('Private API: ' || l_api_name || 'end');
997:
998:
999: -- Standard call to get message count and if count is 1, get message info.
1000: FND_MSG_PUB.Count_And_Get
1001: (p_count => x_msg_count,
1002: p_data => x_msg_data
1003: );
1009:
1010: WHEN FND_API.G_EXC_ERROR THEN
1011: ROLLBACK TO UPDATE_Offer_Adj_Line_PVT;
1012: x_return_status := FND_API.G_RET_STS_ERROR;
1013: -- Standard call to get message count and if count=1, get the message
1014: FND_MSG_PUB.Count_And_Get (
1015: p_encoded => FND_API.G_FALSE,
1016: p_count => x_msg_count,
1017: p_data => x_msg_data
1019:
1020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1021: ROLLBACK TO UPDATE_Offer_Adj_Line_PVT;
1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1023: -- Standard call to get message count and if count=1, get the message
1024: FND_MSG_PUB.Count_And_Get (
1025: p_encoded => FND_API.G_FALSE,
1026: p_count => x_msg_count,
1027: p_data => x_msg_data
1033: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1034: THEN
1035: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1036: END IF;
1037: -- Standard call to get message count and if count=1, get the message
1038: FND_MSG_PUB.Count_And_Get (
1039: p_encoded => FND_API.G_FALSE,
1040: p_count => x_msg_count,
1041: p_data => x_msg_data
1066: -- x_return_status OUT VARCHAR2
1067: -- x_msg_count OUT NUMBER
1068: -- x_msg_data OUT VARCHAR2
1069: -- Version : Current version 1.0
1070: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
1071: -- and basic operation, developer must manually add parameters and business logic as necessary.
1072: --
1073: -- History
1074: --
1124: WHERE qp_list_header_id = p_list_header_id;
1125:
1126:
1127: BEGIN
1128: -- Standard Start of API savepoint
1129: SAVEPOINT update_new_offer_adj_line_pvt;
1130:
1131: -- Standard call to check for call compatibility.
1132: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1127: BEGIN
1128: -- Standard Start of API savepoint
1129: SAVEPOINT update_new_offer_adj_line_pvt;
1130:
1131: -- Standard call to check for call compatibility.
1132: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1133: p_api_version_number,
1134: l_api_name,
1135: G_PKG_NAME)
1252: --
1253: -- End of API body
1254: --
1255:
1256: -- Standard check for p_commit
1257: IF FND_API.to_Boolean( p_commit )
1258: THEN
1259: COMMIT WORK;
1260: END IF;
1262: -- Debug Message
1263: debug_message('Private API: ' || l_api_name || 'end');
1264:
1265:
1266: -- Standard call to get message count and if count is 1, get message info.
1267: FND_MSG_PUB.Count_And_Get
1268: (p_count => x_msg_count,
1269: p_data => x_msg_data
1270: );
1276:
1277: WHEN FND_API.G_EXC_ERROR THEN
1278: ROLLBACK TO Update_new_Offer_Adj_Line_PVT;
1279: x_return_status := FND_API.G_RET_STS_ERROR;
1280: -- Standard call to get message count and if count=1, get the message
1281: FND_MSG_PUB.Count_And_Get (
1282: p_encoded => FND_API.G_FALSE,
1283: p_count => x_msg_count,
1284: p_data => x_msg_data
1286:
1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1288: ROLLBACK TO Update_New_Offer_Adj_Line_PVT;
1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1290: -- Standard call to get message count and if count=1, get the message
1291: FND_MSG_PUB.Count_And_Get (
1292: p_encoded => FND_API.G_FALSE,
1293: p_count => x_msg_count,
1294: p_data => x_msg_data
1300: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1301: THEN
1302: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1303: END IF;
1304: -- Standard call to get message count and if count=1, get the message
1305: FND_MSG_PUB.Count_And_Get (
1306: p_encoded => FND_API.G_FALSE,
1307: p_count => x_msg_count,
1308: p_data => x_msg_data
1334: -- x_return_status OUT VARCHAR2
1335: -- x_msg_count OUT NUMBER
1336: -- x_msg_data OUT VARCHAR2
1337: -- Version : Current version 1.0
1338: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
1339: -- and basic operation, developer must manually add parameters and business logic as necessary.
1340: --
1341: -- History
1342: --
1362: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1363: l_object_version_number NUMBER;
1364:
1365: BEGIN
1366: -- Standard Start of API savepoint
1367: SAVEPOINT delete_offer_adj_line_pvt;
1368:
1369: -- Standard call to check for call compatibility.
1370: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1365: BEGIN
1366: -- Standard Start of API savepoint
1367: SAVEPOINT delete_offer_adj_line_pvt;
1368:
1369: -- Standard call to check for call compatibility.
1370: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1371: p_api_version_number,
1372: l_api_name,
1373: G_PKG_NAME)
1405: --
1406: -- End of API body
1407: --
1408:
1409: -- Standard check for p_commit
1410: IF FND_API.to_Boolean( p_commit )
1411: THEN
1412: COMMIT WORK;
1413: END IF;
1416: -- Debug Message
1417: debug_message('Private API: ' || l_api_name || 'end');
1418:
1419:
1420: -- Standard call to get message count and if count is 1, get message info.
1421: FND_MSG_PUB.Count_And_Get
1422: (p_count => x_msg_count,
1423: p_data => x_msg_data
1424: );
1430:
1431: WHEN FND_API.G_EXC_ERROR THEN
1432: ROLLBACK TO DELETE_Offer_Adj_Line_PVT;
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434: -- Standard call to get message count and if count=1, get the message
1435: FND_MSG_PUB.Count_And_Get (
1436: p_encoded => FND_API.G_FALSE,
1437: p_count => x_msg_count,
1438: p_data => x_msg_data
1440:
1441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1442: ROLLBACK TO DELETE_Offer_Adj_Line_PVT;
1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1444: -- Standard call to get message count and if count=1, get the message
1445: FND_MSG_PUB.Count_And_Get (
1446: p_encoded => FND_API.G_FALSE,
1447: p_count => x_msg_count,
1448: p_data => x_msg_data
1454: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1455: THEN
1456: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1457: END IF;
1458: -- Standard call to get message count and if count=1, get the message
1459: FND_MSG_PUB.Count_And_Get (
1460: p_encoded => FND_API.G_FALSE,
1461: p_count => x_msg_count,
1462: p_data => x_msg_data
1488: -- x_return_status OUT VARCHAR2
1489: -- x_msg_count OUT NUMBER
1490: -- x_msg_data OUT VARCHAR2
1491: -- Version : Current version 1.0
1492: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
1493: -- and basic operation, developer must manually add parameters and business logic as necessary.
1494: --
1495: -- History
1496: --
1530: END IF;
1531:
1532:
1533:
1534: -- Standard call to check for call compatibility.
1535: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1536: p_api_version_number,
1537: l_api_name,
1538: G_PKG_NAME)
1564:
1565: WHEN FND_API.G_EXC_ERROR THEN
1566: ROLLBACK TO LOCK_Offer_Adj_Line_PVT;
1567: x_return_status := FND_API.G_RET_STS_ERROR;
1568: -- Standard call to get message count and if count=1, get the message
1569: FND_MSG_PUB.Count_And_Get (
1570: p_encoded => FND_API.G_FALSE,
1571: p_count => x_msg_count,
1572: p_data => x_msg_data
1574:
1575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1576: ROLLBACK TO LOCK_Offer_Adj_Line_PVT;
1577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1578: -- Standard call to get message count and if count=1, get the message
1579: FND_MSG_PUB.Count_And_Get (
1580: p_encoded => FND_API.G_FALSE,
1581: p_count => x_msg_count,
1582: p_data => x_msg_data
1588: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1589: THEN
1590: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1591: END IF;
1592: -- Standard call to get message count and if count=1, get the message
1593: FND_MSG_PUB.Count_And_Get (
1594: p_encoded => FND_API.G_FALSE,
1595: p_count => x_msg_count,
1596: p_data => x_msg_data
2101: l_object_version_number NUMBER;
2102: l_offadj_line_rec offadj_line_rec_type;
2103:
2104: BEGIN
2105: -- Standard Start of API savepoint
2106: SAVEPOINT validate_offer_adj_line_;
2107:
2108: -- Standard call to check for call compatibility.
2109: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2104: BEGIN
2105: -- Standard Start of API savepoint
2106: SAVEPOINT validate_offer_adj_line_;
2107:
2108: -- Standard call to check for call compatibility.
2109: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2110: p_api_version_number,
2111: l_api_name,
2112: G_PKG_NAME)
2175: -- Debug Message
2176: debug_message('Private API: ' || l_api_name || 'end');
2177:
2178:
2179: -- Standard call to get message count and if count is 1, get message info.
2180: FND_MSG_PUB.Count_And_Get
2181: (p_count => x_msg_count,
2182: p_data => x_msg_data
2183: );
2189:
2190: WHEN FND_API.G_EXC_ERROR THEN
2191: ROLLBACK TO VALIDATE_Offer_Adj_Line_;
2192: x_return_status := FND_API.G_RET_STS_ERROR;
2193: -- Standard call to get message count and if count=1, get the message
2194: FND_MSG_PUB.Count_And_Get (
2195: p_encoded => FND_API.G_FALSE,
2196: p_count => x_msg_count,
2197: p_data => x_msg_data
2199:
2200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2201: ROLLBACK TO VALIDATE_Offer_Adj_Line_;
2202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2203: -- Standard call to get message count and if count=1, get the message
2204: FND_MSG_PUB.Count_And_Get (
2205: p_encoded => FND_API.G_FALSE,
2206: p_count => x_msg_count,
2207: p_data => x_msg_data
2213: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2214: THEN
2215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2216: END IF;
2217: -- Standard call to get message count and if count=1, get the message
2218: FND_MSG_PUB.Count_And_Get (
2219: p_encoded => FND_API.G_FALSE,
2220: p_count => x_msg_count,
2221: p_data => x_msg_data
2250: -- x_return_status := FND_API.G_RET_STS_ERROR;
2251:
2252: -- Debug Message
2253: debug_message('Private API: Validate_dm_model_rec');
2254: -- Standard call to get message count and if count is 1, get message info.
2255: FND_MSG_PUB.Count_And_Get
2256: (p_count => x_msg_count,
2257: p_data => x_msg_data
2258: );