DBA Data[Home] [Help]

APPS.AMS_ADV_FILTER_PVT dependencies on FND_MSG_PUB

Line 90: FND_MSG_PUB.initialize;

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');

Line 213: FND_MSG_PUB.Count_And_Get

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:

Line 228: FND_MSG_PUB.Count_And_Get (

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: );

Line 238: FND_MSG_PUB.Count_And_Get (

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: );

Line 247: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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,

Line 252: FND_MSG_PUB.Count_And_Get (

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: );

Line 308: FND_MSG_PUB.initialize;

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');

Line 346: FND_MSG_PUB.Count_And_Get (

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: );

Line 413: FND_MSG_PUB.Count_And_Get

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

Line 427: FND_MSG_PUB.Count_And_Get (

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: );

Line 437: FND_MSG_PUB.Count_And_Get (

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: );

Line 446: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 448: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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,

Line 451: FND_MSG_PUB.Count_And_Get (

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: );

Line 502: FND_MSG_PUB.initialize;

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');

Line 562: FND_MSG_PUB.Count_And_Get

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

Line 576: FND_MSG_PUB.Count_And_Get (

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: );

Line 586: FND_MSG_PUB.Count_And_Get (

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: );

Line 595: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 597: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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,

Line 600: FND_MSG_PUB.Count_And_Get (

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: );

Line 905: FND_MSG_PUB.initialize;

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(

Line 958: FND_MSG_PUB.Count_And_Get

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

Line 972: FND_MSG_PUB.Count_And_Get (

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: );

Line 982: FND_MSG_PUB.Count_And_Get (

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: );

Line 991: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 993: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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,

Line 996: FND_MSG_PUB.Count_And_Get (

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: );

Line 1019: FND_MSG_PUB.initialize;

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;

Line 1033: FND_MSG_PUB.Count_And_Get

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;

Line 1178: FND_MSG_PUB.Count_And_Get

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:

Line 1189: FND_MSG_PUB.Count_And_Get

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

Line 1199: FND_MSG_PUB.Count_And_Get

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

Line 1208: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 1210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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: (

Line 1213: FND_MSG_PUB.Count_And_Get

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

Line 1336: FND_MSG_PUB.initialize;

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:

Line 1423: FND_MSG_PUB.Count_And_Get (

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

Line 1432: FND_MSG_PUB.Count_And_Get (

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: );

Line 1441: FND_MSG_PUB.Count_And_Get (

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: );

Line 1449: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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 (

Line 1450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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,

Line 1453: FND_MSG_PUB.Count_And_Get (

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: );