86: END IF;
87:
88: -- Initialize message list if p_init_msg_list is set to TRUE.
89: IF FND_API.to_Boolean( p_init_msg_list ) THEN
90: FND_MSG_PUB.initialize;
91: END IF;
92:
93: -- Debug Message
94: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
209: -- Debug Message
210: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
211:
212: -- Standard call to get message count and if count is 1, get message info.
213: FND_MSG_PUB.Count_And_Get
214: (p_count => x_msg_count,
215: p_data => x_msg_data
216: );
217:
224: WHEN FND_API.G_EXC_ERROR THEN
225: ROLLBACK TO CREATE_Filter_Row_PVT;
226: x_return_status := FND_API.G_RET_STS_ERROR;
227: -- Standard call to get message count and if count=1, get the message
228: FND_MSG_PUB.Count_And_Get (
229: p_encoded => FND_API.G_FALSE,
230: p_count => x_msg_count,
231: p_data => x_msg_data
232: );
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ROLLBACK TO CREATE_Filter_Row_PVT;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: -- Standard call to get message count and if count=1, get the message
238: FND_MSG_PUB.Count_And_Get (
239: p_encoded => FND_API.G_FALSE,
240: p_count => x_msg_count,
241: p_data => x_msg_data
242: );
243:
244: WHEN OTHERS THEN
245: ROLLBACK TO CREATE_Filter_Row_PVT;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
248: THEN
249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
250: END IF;
251: -- Standard call to get message count and if count=1, get the message
245: ROLLBACK TO CREATE_Filter_Row_PVT;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
248: THEN
249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
250: END IF;
251: -- Standard call to get message count and if count=1, get the message
252: FND_MSG_PUB.Count_And_Get (
253: p_encoded => FND_API.G_FALSE,
248: THEN
249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
250: END IF;
251: -- Standard call to get message count and if count=1, get the message
252: FND_MSG_PUB.Count_And_Get (
253: p_encoded => FND_API.G_FALSE,
254: p_count => x_msg_count,
255: p_data => x_msg_data
256: );
304:
305: -- Initialize message list if p_init_msg_list is set to TRUE.
306: IF FND_API.to_Boolean( p_init_msg_list )
307: THEN
308: FND_MSG_PUB.initialize;
309: END IF;
310:
311: -- Debug Message
312: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
342: x_msg_count => x_msg_count,
343: x_msg_data => x_msg_data);
344: END IF;
345:
346: FND_MSG_PUB.Count_And_Get (
347: p_encoded => FND_API.G_FALSE,
348: p_count => x_msg_count,
349: p_data => x_msg_data
350: );
409:
410: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
411:
412: -- Standard call to get message count and if count is 1, get message info.
413: FND_MSG_PUB.Count_And_Get
414: (p_count => x_msg_count,
415: p_data => x_msg_data
416: );
417: EXCEPTION
423: WHEN FND_API.G_EXC_ERROR THEN
424: ROLLBACK TO UPDATE_Filter_Row_PVT;
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: -- Standard call to get message count and if count=1, get the message
427: FND_MSG_PUB.Count_And_Get (
428: p_encoded => FND_API.G_FALSE,
429: p_count => x_msg_count,
430: p_data => x_msg_data
431: );
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: ROLLBACK TO UPDATE_Filter_Row_PVT;
435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
436: -- Standard call to get message count and if count=1, get the message
437: FND_MSG_PUB.Count_And_Get (
438: p_encoded => FND_API.G_FALSE,
439: p_count => x_msg_count,
440: p_data => x_msg_data
441: );
442:
443: WHEN OTHERS THEN
444: ROLLBACK TO UPDATE_Filter_Row_PVT;
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
447: THEN
448: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
449: END IF;
450: -- Standard call to get message count and if count=1, get the message
444: ROLLBACK TO UPDATE_Filter_Row_PVT;
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
447: THEN
448: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
449: END IF;
450: -- Standard call to get message count and if count=1, get the message
451: FND_MSG_PUB.Count_And_Get (
452: p_encoded => FND_API.G_FALSE,
447: THEN
448: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
449: END IF;
450: -- Standard call to get message count and if count=1, get the message
451: FND_MSG_PUB.Count_And_Get (
452: p_encoded => FND_API.G_FALSE,
453: p_count => x_msg_count,
454: p_data => x_msg_data
455: );
498:
499: -- Initialize message list if p_init_msg_list is set to TRUE.
500: IF FND_API.to_Boolean( p_init_msg_list )
501: THEN
502: FND_MSG_PUB.initialize;
503: END IF;
504:
505: -- Debug Message
506: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
558: -- Debug Message
559: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
560:
561: -- Standard call to get message count and if count is 1, get message info.
562: FND_MSG_PUB.Count_And_Get
563: (p_count => x_msg_count,
564: p_data => x_msg_data
565: );
566: EXCEPTION
572: WHEN FND_API.G_EXC_ERROR THEN
573: ROLLBACK TO DELETE_Filter_Row_PVT;
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: -- Standard call to get message count and if count=1, get the message
576: FND_MSG_PUB.Count_And_Get (
577: p_encoded => FND_API.G_FALSE,
578: p_count => x_msg_count,
579: p_data => x_msg_data
580: );
582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
583: ROLLBACK TO DELETE_Filter_Row_PVT;
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585: -- Standard call to get message count and if count=1, get the message
586: FND_MSG_PUB.Count_And_Get (
587: p_encoded => FND_API.G_FALSE,
588: p_count => x_msg_count,
589: p_data => x_msg_data
590: );
591:
592: WHEN OTHERS THEN
593: ROLLBACK TO DELETE_Filter_Row_PVT;
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
595: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
596: THEN
597: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
598: END IF;
599: -- Standard call to get message count and if count=1, get the message
593: ROLLBACK TO DELETE_Filter_Row_PVT;
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
595: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
596: THEN
597: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
598: END IF;
599: -- Standard call to get message count and if count=1, get the message
600: FND_MSG_PUB.Count_And_Get (
601: p_encoded => FND_API.G_FALSE,
596: THEN
597: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
598: END IF;
599: -- Standard call to get message count and if count=1, get the message
600: FND_MSG_PUB.Count_And_Get (
601: p_encoded => FND_API.G_FALSE,
602: p_count => x_msg_count,
603: p_data => x_msg_data
604: );
901:
902: -- Initialize message list if p_init_msg_list is set to TRUE.
903: IF FND_API.to_Boolean( p_init_msg_list )
904: THEN
905: FND_MSG_PUB.initialize;
906: END IF;
907:
908: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
909: Check_Filter_Items(
954: -- Debug Message
955: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
956:
957: -- Standard call to get message count and if count is 1, get message info.
958: FND_MSG_PUB.Count_And_Get
959: (p_count => x_msg_count,
960: p_data => x_msg_data
961: );
962: EXCEPTION
968: WHEN FND_API.G_EXC_ERROR THEN
969: ROLLBACK TO VALIDATE_Filter_Row;
970: x_return_status := FND_API.G_RET_STS_ERROR;
971: -- Standard call to get message count and if count=1, get the message
972: FND_MSG_PUB.Count_And_Get (
973: p_encoded => FND_API.G_FALSE,
974: p_count => x_msg_count,
975: p_data => x_msg_data
976: );
978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
979: ROLLBACK TO VALIDATE_Filter_Row;
980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
981: -- Standard call to get message count and if count=1, get the message
982: FND_MSG_PUB.Count_And_Get (
983: p_encoded => FND_API.G_FALSE,
984: p_count => x_msg_count,
985: p_data => x_msg_data
986: );
987:
988: WHEN OTHERS THEN
989: ROLLBACK TO VALIDATE_Filter_Row;
990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
991: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
992: THEN
993: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
994: END IF;
995: -- Standard call to get message count and if count=1, get the message
989: ROLLBACK TO VALIDATE_Filter_Row;
990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
991: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
992: THEN
993: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
994: END IF;
995: -- Standard call to get message count and if count=1, get the message
996: FND_MSG_PUB.Count_And_Get (
997: p_encoded => FND_API.G_FALSE,
992: THEN
993: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
994: END IF;
995: -- Standard call to get message count and if count=1, get the message
996: FND_MSG_PUB.Count_And_Get (
997: p_encoded => FND_API.G_FALSE,
998: p_count => x_msg_count,
999: p_data => x_msg_data
1000: );
1015: BEGIN
1016: -- Initialize message list if p_init_msg_list is set to TRUE.
1017: IF FND_API.to_Boolean( p_init_msg_list )
1018: THEN
1019: FND_MSG_PUB.initialize;
1020: END IF;
1021:
1022: -- Initialize API return status to SUCCESS
1023: x_return_status := FND_API.G_RET_STS_SUCCESS;
1029:
1030: -- Debug Message
1031: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1032: -- Standard call to get message count and if count is 1, get message info.
1033: FND_MSG_PUB.Count_And_Get
1034: (p_count => x_msg_count,
1035: p_data => x_msg_data
1036: );
1037: END Validate_Filter_Row_Rec;
1174: CLOSE c_filterRec;
1175:
1176: x_filters := l_filterRec_tbl;
1177:
1178: FND_MSG_PUB.Count_And_Get
1179: ( p_count => x_msg_count,
1180: p_data => x_msg_data
1181: );
1182:
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: CLOSE c_filterRec;
1187: x_return_status := FND_API.G_RET_STS_ERROR;
1188: -- Standard call to get message count and if count=1, get the message
1189: FND_MSG_PUB.Count_And_Get
1190: (
1191: p_encoded => FND_API.G_FALSE,
1192: p_count => x_msg_count,
1193: p_data => x_msg_data
1195:
1196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1198: -- Standard call to get message count and if count=1, get the message
1199: FND_MSG_PUB.Count_And_Get
1200: (
1201: p_encoded => FND_API.G_FALSE,
1202: p_count => x_msg_count,
1203: p_data => x_msg_data
1204: );
1205:
1206: WHEN OTHERS THEN
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1208: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1209: THEN
1210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1211: END IF;
1212: -- Standard call to get message count and if count=1, get the message
1206: WHEN OTHERS THEN
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1208: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1209: THEN
1210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1211: END IF;
1212: -- Standard call to get message count and if count=1, get the message
1213: FND_MSG_PUB.Count_And_Get
1214: (
1209: THEN
1210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1211: END IF;
1212: -- Standard call to get message count and if count=1, get the message
1213: FND_MSG_PUB.Count_And_Get
1214: (
1215: p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data
1332: END IF;
1333:
1334: -- Initialize message list if p_init_msg_list is set to TRUE.
1335: IF FND_API.to_Boolean( p_init_msg_list )THEN
1336: FND_MSG_PUB.initialize;
1337: END IF;
1338:
1339: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
1340:
1419: -- Debug Message
1420: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
1421:
1422: -- Standard call to get message count and if count is 1, get message info.
1423: FND_MSG_PUB.Count_And_Get (
1424: p_count => x_msg_count,
1425: p_data => x_msg_data
1426: );
1427: EXCEPTION
1428: WHEN FND_API.G_EXC_ERROR THEN
1429: ROLLBACK TO ams_filter_pvt_copy_filter;
1430: x_return_status := FND_API.G_RET_STS_ERROR;
1431: -- Standard call to get message count and if count=1, get the message
1432: FND_MSG_PUB.Count_And_Get (
1433: p_encoded => FND_API.G_FALSE,
1434: p_count => x_msg_count,
1435: p_data => x_msg_data
1436: );
1437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1438: ROLLBACK TO ams_filter_pvt_copy_filter;
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1440: -- Standard call to get message count and if count=1, get the message
1441: FND_MSG_PUB.Count_And_Get (
1442: p_encoded => FND_API.G_FALSE,
1443: p_count => x_msg_count,
1444: p_data => x_msg_data
1445: );
1445: );
1446: WHEN OTHERS THEN
1447: ROLLBACK TO ams_filter_pvt_copy_filter;
1448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1449: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1451: END IF;
1452: -- Standard call to get message count and if count=1, get the message
1453: FND_MSG_PUB.Count_And_Get (
1446: WHEN OTHERS THEN
1447: ROLLBACK TO ams_filter_pvt_copy_filter;
1448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1449: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1451: END IF;
1452: -- Standard call to get message count and if count=1, get the message
1453: FND_MSG_PUB.Count_And_Get (
1454: p_encoded => FND_API.G_FALSE,
1449: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1451: END IF;
1452: -- Standard call to get message count and if count=1, get the message
1453: FND_MSG_PUB.Count_And_Get (
1454: p_encoded => FND_API.G_FALSE,
1455: p_count => x_msg_count,
1456: p_data => x_msg_data
1457: );