32:
33:
34: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Offer_Adj_Line_PVT';
35: G_FILE_NAME CONSTANT VARCHAR2(12) := 'offvadjb.pls';
36: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
37: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
38:
39: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
40: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
33:
34: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Offer_Adj_Line_PVT';
35: G_FILE_NAME CONSTANT VARCHAR2(12) := 'offvadjb.pls';
36: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
37: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
38:
39: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
40: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
41: --
377:
378: -- Initialize message list if p_init_msg_list is set to TRUE.
379: IF FND_API.to_Boolean( p_init_msg_list )
380: THEN
381: FND_MSG_PUB.initialize;
382: END IF;
383:
384:
385:
494: debug_message('Private API: ' || l_api_name || 'end');
495:
496:
497: -- Standard call to get message count and if count is 1, get message info.
498: FND_MSG_PUB.Count_And_Get
499: (p_count => x_msg_count,
500: p_data => x_msg_data
501: );
502:
509: WHEN FND_API.G_EXC_ERROR THEN
510: ROLLBACK TO CREATE_Offer_Adj_Line_PVT;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: -- Standard call to get message count and if count=1, get the message
513: FND_MSG_PUB.Count_And_Get (
514: p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,
516: p_data => x_msg_data
517: );
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
520: ROLLBACK TO CREATE_Offer_Adj_Line_PVT;
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: -- Standard call to get message count and if count=1, get the message
523: FND_MSG_PUB.Count_And_Get (
524: p_encoded => FND_API.G_FALSE,
525: p_count => x_msg_count,
526: p_data => x_msg_data
527: );
528:
529: WHEN OTHERS THEN
530: ROLLBACK TO CREATE_Offer_Adj_Line_PVT;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
533: THEN
534: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
535: END IF;
536: -- Standard call to get message count and if count=1, get the message
530: ROLLBACK TO CREATE_Offer_Adj_Line_PVT;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
533: THEN
534: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
535: END IF;
536: -- Standard call to get message count and if count=1, get the message
537: FND_MSG_PUB.Count_And_Get (
538: p_encoded => FND_API.G_FALSE,
533: THEN
534: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
535: END IF;
536: -- Standard call to get message count and if count=1, get the message
537: FND_MSG_PUB.Count_And_Get (
538: p_encoded => FND_API.G_FALSE,
539: p_count => x_msg_count,
540: p_data => x_msg_data
541: );
610:
611: -- Initialize message list if p_init_msg_list is set to TRUE.
612: IF FND_API.to_Boolean( p_init_msg_list )
613: THEN
614: FND_MSG_PUB.initialize;
615: END IF;
616:
617:
618:
748: debug_message('Private API: ' || l_api_name || 'end');
749:
750:
751: -- Standard call to get message count and if count is 1, get message info.
752: FND_MSG_PUB.Count_And_Get
753: (p_count => x_msg_count,
754: p_data => x_msg_data
755: );
756:
762: WHEN FND_API.G_EXC_ERROR THEN
763: ROLLBACK TO CREATE_new_Offer_Adj_Line_PVT;
764: x_return_status := FND_API.G_RET_STS_ERROR;
765: -- Standard call to get message count and if count=1, get the message
766: FND_MSG_PUB.Count_And_Get (
767: p_encoded => FND_API.G_FALSE,
768: p_count => x_msg_count,
769: p_data => x_msg_data
770: );
772: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
773: ROLLBACK TO CREATE_New_Offer_Adj_Line_PVT;
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
775: -- Standard call to get message count and if count=1, get the message
776: FND_MSG_PUB.Count_And_Get (
777: p_encoded => FND_API.G_FALSE,
778: p_count => x_msg_count,
779: p_data => x_msg_data
780: );
781:
782: WHEN OTHERS THEN
783: ROLLBACK TO CREATE_New_Offer_Adj_Line_PVT;
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
785: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
786: THEN
787: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
788: END IF;
789: -- Standard call to get message count and if count=1, get the message
783: ROLLBACK TO CREATE_New_Offer_Adj_Line_PVT;
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
785: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
786: THEN
787: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
788: END IF;
789: -- Standard call to get message count and if count=1, get the message
790: FND_MSG_PUB.Count_And_Get (
791: p_encoded => FND_API.G_FALSE,
786: THEN
787: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
788: END IF;
789: -- Standard call to get message count and if count=1, get the message
790: FND_MSG_PUB.Count_And_Get (
791: p_encoded => FND_API.G_FALSE,
792: p_count => x_msg_count,
793: p_data => x_msg_data
794: );
877:
878: -- Initialize message list if p_init_msg_list is set to TRUE.
879: IF FND_API.to_Boolean( p_init_msg_list )
880: THEN
881: FND_MSG_PUB.initialize;
882: END IF;
883:
884:
885:
950: -- assigned to obj.ver.num variable which is passed to Update_Row() -- sangara
951: l_object_version_number := p_offadj_line_rec.object_version_number;
952:
953: -- Debug Message
954: debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW || 'Private API: Calling update table handler');
955:
956: -- Debug Message sangara
957: -- debug_message('OFFER_ADJUSTMENT_LINE_ID:' || p_offadj_line_rec.offer_adjustment_line_id);
958:
997: debug_message('Private API: ' || l_api_name || 'end');
998:
999:
1000: -- Standard call to get message count and if count is 1, get message info.
1001: FND_MSG_PUB.Count_And_Get
1002: (p_count => x_msg_count,
1003: p_data => x_msg_data
1004: );
1005: EXCEPTION
1011: WHEN FND_API.G_EXC_ERROR THEN
1012: ROLLBACK TO UPDATE_Offer_Adj_Line_PVT;
1013: x_return_status := FND_API.G_RET_STS_ERROR;
1014: -- Standard call to get message count and if count=1, get the message
1015: FND_MSG_PUB.Count_And_Get (
1016: p_encoded => FND_API.G_FALSE,
1017: p_count => x_msg_count,
1018: p_data => x_msg_data
1019: );
1021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1022: ROLLBACK TO UPDATE_Offer_Adj_Line_PVT;
1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1024: -- Standard call to get message count and if count=1, get the message
1025: FND_MSG_PUB.Count_And_Get (
1026: p_encoded => FND_API.G_FALSE,
1027: p_count => x_msg_count,
1028: p_data => x_msg_data
1029: );
1030:
1031: WHEN OTHERS THEN
1032: ROLLBACK TO UPDATE_Offer_Adj_Line_PVT;
1033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1034: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1035: THEN
1036: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1037: END IF;
1038: -- Standard call to get message count and if count=1, get the message
1032: ROLLBACK TO UPDATE_Offer_Adj_Line_PVT;
1033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1034: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1035: THEN
1036: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1037: END IF;
1038: -- Standard call to get message count and if count=1, get the message
1039: FND_MSG_PUB.Count_And_Get (
1040: p_encoded => FND_API.G_FALSE,
1035: THEN
1036: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1037: END IF;
1038: -- Standard call to get message count and if count=1, get the message
1039: FND_MSG_PUB.Count_And_Get (
1040: p_encoded => FND_API.G_FALSE,
1041: p_count => x_msg_count,
1042: p_data => x_msg_data
1043: );
1141:
1142: -- Initialize message list if p_init_msg_list is set to TRUE.
1143: IF FND_API.to_Boolean( p_init_msg_list )
1144: THEN
1145: FND_MSG_PUB.initialize;
1146: END IF;
1147:
1148: -- Debug Message
1149: debug_message('Private API: ' || l_api_name || 'start');
1264: debug_message('Private API: ' || l_api_name || 'end');
1265:
1266:
1267: -- Standard call to get message count and if count is 1, get message info.
1268: FND_MSG_PUB.Count_And_Get
1269: (p_count => x_msg_count,
1270: p_data => x_msg_data
1271: );
1272:
1278: WHEN FND_API.G_EXC_ERROR THEN
1279: ROLLBACK TO Update_new_Offer_Adj_Line_PVT;
1280: x_return_status := FND_API.G_RET_STS_ERROR;
1281: -- Standard call to get message count and if count=1, get the message
1282: FND_MSG_PUB.Count_And_Get (
1283: p_encoded => FND_API.G_FALSE,
1284: p_count => x_msg_count,
1285: p_data => x_msg_data
1286: );
1288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1289: ROLLBACK TO Update_New_Offer_Adj_Line_PVT;
1290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1291: -- Standard call to get message count and if count=1, get the message
1292: FND_MSG_PUB.Count_And_Get (
1293: p_encoded => FND_API.G_FALSE,
1294: p_count => x_msg_count,
1295: p_data => x_msg_data
1296: );
1297:
1298: WHEN OTHERS THEN
1299: ROLLBACK TO Update_New_Offer_Adj_Line_PVT;
1300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1301: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1302: THEN
1303: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1304: END IF;
1305: -- Standard call to get message count and if count=1, get the message
1299: ROLLBACK TO Update_New_Offer_Adj_Line_PVT;
1300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1301: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1302: THEN
1303: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1304: END IF;
1305: -- Standard call to get message count and if count=1, get the message
1306: FND_MSG_PUB.Count_And_Get (
1307: p_encoded => FND_API.G_FALSE,
1302: THEN
1303: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1304: END IF;
1305: -- Standard call to get message count and if count=1, get the message
1306: FND_MSG_PUB.Count_And_Get (
1307: p_encoded => FND_API.G_FALSE,
1308: p_count => x_msg_count,
1309: p_data => x_msg_data
1310: );
1379:
1380: -- Initialize message list if p_init_msg_list is set to TRUE.
1381: IF FND_API.to_Boolean( p_init_msg_list )
1382: THEN
1383: FND_MSG_PUB.initialize;
1384: END IF;
1385:
1386:
1387:
1418: debug_message('Private API: ' || l_api_name || 'end');
1419:
1420:
1421: -- Standard call to get message count and if count is 1, get message info.
1422: FND_MSG_PUB.Count_And_Get
1423: (p_count => x_msg_count,
1424: p_data => x_msg_data
1425: );
1426: EXCEPTION
1432: WHEN FND_API.G_EXC_ERROR THEN
1433: ROLLBACK TO DELETE_Offer_Adj_Line_PVT;
1434: x_return_status := FND_API.G_RET_STS_ERROR;
1435: -- Standard call to get message count and if count=1, get the message
1436: FND_MSG_PUB.Count_And_Get (
1437: p_encoded => FND_API.G_FALSE,
1438: p_count => x_msg_count,
1439: p_data => x_msg_data
1440: );
1442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1443: ROLLBACK TO DELETE_Offer_Adj_Line_PVT;
1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1445: -- Standard call to get message count and if count=1, get the message
1446: FND_MSG_PUB.Count_And_Get (
1447: p_encoded => FND_API.G_FALSE,
1448: p_count => x_msg_count,
1449: p_data => x_msg_data
1450: );
1451:
1452: WHEN OTHERS THEN
1453: ROLLBACK TO DELETE_Offer_Adj_Line_PVT;
1454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1455: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1456: THEN
1457: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1458: END IF;
1459: -- Standard call to get message count and if count=1, get the message
1453: ROLLBACK TO DELETE_Offer_Adj_Line_PVT;
1454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1455: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1456: THEN
1457: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1458: END IF;
1459: -- Standard call to get message count and if count=1, get the message
1460: FND_MSG_PUB.Count_And_Get (
1461: p_encoded => FND_API.G_FALSE,
1456: THEN
1457: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1458: END IF;
1459: -- Standard call to get message count and if count=1, get the message
1460: FND_MSG_PUB.Count_And_Get (
1461: p_encoded => FND_API.G_FALSE,
1462: p_count => x_msg_count,
1463: p_data => x_msg_data
1464: );
1526:
1527: -- Initialize message list if p_init_msg_list is set to TRUE.
1528: IF FND_API.to_Boolean( p_init_msg_list )
1529: THEN
1530: FND_MSG_PUB.initialize;
1531: END IF;
1532:
1533:
1534:
1551: OZF_Offer_Adj_Line_PKG.Lock_Row(l_offer_adjustment_line_id,p_object_version);
1552:
1553:
1554: -------------------- finish --------------------------
1555: FND_MSG_PUB.count_and_get(
1556: p_encoded => FND_API.g_false,
1557: p_count => x_msg_count,
1558: p_data => x_msg_data);
1559: debug_message(l_full_name ||': end');
1566: WHEN FND_API.G_EXC_ERROR THEN
1567: ROLLBACK TO LOCK_Offer_Adj_Line_PVT;
1568: x_return_status := FND_API.G_RET_STS_ERROR;
1569: -- Standard call to get message count and if count=1, get the message
1570: FND_MSG_PUB.Count_And_Get (
1571: p_encoded => FND_API.G_FALSE,
1572: p_count => x_msg_count,
1573: p_data => x_msg_data
1574: );
1576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1577: ROLLBACK TO LOCK_Offer_Adj_Line_PVT;
1578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1579: -- Standard call to get message count and if count=1, get the message
1580: FND_MSG_PUB.Count_And_Get (
1581: p_encoded => FND_API.G_FALSE,
1582: p_count => x_msg_count,
1583: p_data => x_msg_data
1584: );
1585:
1586: WHEN OTHERS THEN
1587: ROLLBACK TO LOCK_Offer_Adj_Line_PVT;
1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1589: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1590: THEN
1591: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1592: END IF;
1593: -- Standard call to get message count and if count=1, get the message
1587: ROLLBACK TO LOCK_Offer_Adj_Line_PVT;
1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1589: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1590: THEN
1591: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1592: END IF;
1593: -- Standard call to get message count and if count=1, get the message
1594: FND_MSG_PUB.Count_And_Get (
1595: p_encoded => FND_API.G_FALSE,
1590: THEN
1591: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1592: END IF;
1593: -- Standard call to get message count and if count=1, get the message
1594: FND_MSG_PUB.Count_And_Get (
1595: p_encoded => FND_API.G_FALSE,
1596: p_count => x_msg_count,
1597: p_data => x_msg_data
1598: );
2118:
2119: -- Initialize message list if p_init_msg_list is set to TRUE.
2120: IF FND_API.to_Boolean( p_init_msg_list )
2121: THEN
2122: FND_MSG_PUB.initialize;
2123: END IF;
2124:
2125: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2126: Check_offadj_line_Items(
2177: debug_message('Private API: ' || l_api_name || 'end');
2178:
2179:
2180: -- Standard call to get message count and if count is 1, get message info.
2181: FND_MSG_PUB.Count_And_Get
2182: (p_count => x_msg_count,
2183: p_data => x_msg_data
2184: );
2185: EXCEPTION
2191: WHEN FND_API.G_EXC_ERROR THEN
2192: ROLLBACK TO VALIDATE_Offer_Adj_Line_;
2193: x_return_status := FND_API.G_RET_STS_ERROR;
2194: -- Standard call to get message count and if count=1, get the message
2195: FND_MSG_PUB.Count_And_Get (
2196: p_encoded => FND_API.G_FALSE,
2197: p_count => x_msg_count,
2198: p_data => x_msg_data
2199: );
2201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2202: ROLLBACK TO VALIDATE_Offer_Adj_Line_;
2203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2204: -- Standard call to get message count and if count=1, get the message
2205: FND_MSG_PUB.Count_And_Get (
2206: p_encoded => FND_API.G_FALSE,
2207: p_count => x_msg_count,
2208: p_data => x_msg_data
2209: );
2210:
2211: WHEN OTHERS THEN
2212: ROLLBACK TO VALIDATE_Offer_Adj_Line_;
2213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2214: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2215: THEN
2216: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2217: END IF;
2218: -- Standard call to get message count and if count=1, get the message
2212: ROLLBACK TO VALIDATE_Offer_Adj_Line_;
2213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2214: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2215: THEN
2216: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2217: END IF;
2218: -- Standard call to get message count and if count=1, get the message
2219: FND_MSG_PUB.Count_And_Get (
2220: p_encoded => FND_API.G_FALSE,
2215: THEN
2216: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2217: END IF;
2218: -- Standard call to get message count and if count=1, get the message
2219: FND_MSG_PUB.Count_And_Get (
2220: p_encoded => FND_API.G_FALSE,
2221: p_count => x_msg_count,
2222: p_data => x_msg_data
2223: );
2249: BEGIN
2250: -- Initialize message list if p_init_msg_list is set to TRUE.
2251: IF FND_API.to_Boolean( p_init_msg_list )
2252: THEN
2253: FND_MSG_PUB.initialize;
2254: END IF;
2255:
2256:
2257:
2298:
2299: -- Debug Message
2300: debug_message('Private API: Validate_dm_model_rec');
2301: -- Standard call to get message count and if count is 1, get message info.
2302: FND_MSG_PUB.Count_And_Get
2303: (p_count => x_msg_count,
2304: p_data => x_msg_data
2305: );
2306: END Validate_offadj_line_Rec;