DBA Data[Home] [Help]

APPS.OZF_OFFR_QUAL_PVT dependencies on FND_MSG_PUB

Line 122: FND_MSG_PUB.initialize;

118:
119: -- Initialize message list if p_init_msg_list is set to TRUE.
120: IF FND_API.to_Boolean( p_init_msg_list )
121: THEN
122: FND_MSG_PUB.initialize;
123: END IF;
124:
125:
126:

Line 251: FND_MSG_PUB.Count_And_Get

247: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
248:
249:
250: -- Standard call to get message count and if count is 1, get message info.
251: FND_MSG_PUB.Count_And_Get
252: (p_count => x_msg_count,
253: p_data => x_msg_data
254: );
255: EXCEPTION

Line 265: FND_MSG_PUB.Count_And_Get (

261: WHEN FND_API.G_EXC_ERROR THEN
262: ROLLBACK TO CREATE_Offr_Qual_PVT;
263: x_return_status := FND_API.G_RET_STS_ERROR;
264: -- Standard call to get message count and if count=1, get the message
265: FND_MSG_PUB.Count_And_Get (
266: p_encoded => FND_API.G_FALSE,
267: p_count => x_msg_count,
268: p_data => x_msg_data
269: );

Line 275: FND_MSG_PUB.Count_And_Get (

271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
272: ROLLBACK TO CREATE_Offr_Qual_PVT;
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: -- Standard call to get message count and if count=1, get the message
275: FND_MSG_PUB.Count_And_Get (
276: p_encoded => FND_API.G_FALSE,
277: p_count => x_msg_count,
278: p_data => x_msg_data
279: );

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

280:
281: WHEN OTHERS THEN
282: ROLLBACK TO CREATE_Offr_Qual_PVT;
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
285: THEN
286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
287: END IF;
288: -- Standard call to get message count and if count=1, get the message

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

282: ROLLBACK TO CREATE_Offr_Qual_PVT;
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
285: THEN
286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
287: END IF;
288: -- Standard call to get message count and if count=1, get the message
289: FND_MSG_PUB.Count_And_Get (
290: p_encoded => FND_API.G_FALSE,

Line 289: FND_MSG_PUB.Count_And_Get (

285: THEN
286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
287: END IF;
288: -- Standard call to get message count and if count=1, get the message
289: FND_MSG_PUB.Count_And_Get (
290: p_encoded => FND_API.G_FALSE,
291: p_count => x_msg_count,
292: p_data => x_msg_data
293: );

Line 379: FND_MSG_PUB.initialize;

375:
376: -- Initialize message list if p_init_msg_list is set to TRUE.
377: IF FND_API.to_Boolean( p_init_msg_list )
378: THEN
379: FND_MSG_PUB.initialize;
380: END IF;
381:
382:
383:

Line 499: FND_MSG_PUB.Count_And_Get

495: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
496:
497:
498: -- Standard call to get message count and if count is 1, get message info.
499: FND_MSG_PUB.Count_And_Get
500: (p_count => x_msg_count,
501: p_data => x_msg_data
502: );
503: EXCEPTION

Line 513: FND_MSG_PUB.Count_And_Get (

509: WHEN FND_API.G_EXC_ERROR THEN
510: ROLLBACK TO UPDATE_Offr_Qual_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: );

Line 523: FND_MSG_PUB.Count_And_Get (

519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
520: ROLLBACK TO UPDATE_Offr_Qual_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: );

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

528:
529: WHEN OTHERS THEN
530: ROLLBACK TO UPDATE_Offr_Qual_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

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

530: ROLLBACK TO UPDATE_Offr_Qual_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,

Line 537: FND_MSG_PUB.Count_And_Get (

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

Line 613: FND_MSG_PUB.initialize;

609:
610: -- Initialize message list if p_init_msg_list is set to TRUE.
611: IF FND_API.to_Boolean( p_init_msg_list )
612: THEN
613: FND_MSG_PUB.initialize;
614: END IF;
615:
616:
617:

Line 652: FND_MSG_PUB.Count_And_Get

648: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
649:
650:
651: -- Standard call to get message count and if count is 1, get message info.
652: FND_MSG_PUB.Count_And_Get
653: (p_count => x_msg_count,
654: p_data => x_msg_data
655: );
656: EXCEPTION

Line 666: FND_MSG_PUB.Count_And_Get (

662: WHEN FND_API.G_EXC_ERROR THEN
663: ROLLBACK TO DELETE_Offr_Qual_PVT;
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: -- Standard call to get message count and if count=1, get the message
666: FND_MSG_PUB.Count_And_Get (
667: p_encoded => FND_API.G_FALSE,
668: p_count => x_msg_count,
669: p_data => x_msg_data
670: );

Line 676: FND_MSG_PUB.Count_And_Get (

672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: ROLLBACK TO DELETE_Offr_Qual_PVT;
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: -- Standard call to get message count and if count=1, get the message
676: FND_MSG_PUB.Count_And_Get (
677: p_encoded => FND_API.G_FALSE,
678: p_count => x_msg_count,
679: p_data => x_msg_data
680: );

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

681:
682: WHEN OTHERS THEN
683: ROLLBACK TO DELETE_Offr_Qual_PVT;
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
685: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
686: THEN
687: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
688: END IF;
689: -- Standard call to get message count and if count=1, get the message

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

683: ROLLBACK TO DELETE_Offr_Qual_PVT;
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
685: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
686: THEN
687: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
688: END IF;
689: -- Standard call to get message count and if count=1, get the message
690: FND_MSG_PUB.Count_And_Get (
691: p_encoded => FND_API.G_FALSE,

Line 690: FND_MSG_PUB.Count_And_Get (

686: THEN
687: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
688: END IF;
689: -- Standard call to get message count and if count=1, get the message
690: FND_MSG_PUB.Count_And_Get (
691: p_encoded => FND_API.G_FALSE,
692: p_count => x_msg_count,
693: p_data => x_msg_data
694: );

Line 760: FND_MSG_PUB.initialize;

756:
757: -- Initialize message list if p_init_msg_list is set to TRUE.
758: IF FND_API.to_Boolean( p_init_msg_list )
759: THEN
760: FND_MSG_PUB.initialize;
761: END IF;
762:
763:
764:

Line 785: FND_MSG_PUB.count_and_get(

781: Ozf_Offr_Qual_Pkg.Lock_Row(l_qualifier_id,p_object_version);
782:
783:
784: -------------------- finish --------------------------
785: FND_MSG_PUB.count_and_get(
786: p_encoded => FND_API.g_false,
787: p_count => x_msg_count,
788: p_data => x_msg_data);
789: OZF_Utility_PVT.debug_message(l_full_name ||': end');

Line 800: FND_MSG_PUB.Count_And_Get (

796: WHEN FND_API.G_EXC_ERROR THEN
797: ROLLBACK TO LOCK_Offr_Qual_PVT;
798: x_return_status := FND_API.G_RET_STS_ERROR;
799: -- Standard call to get message count and if count=1, get the message
800: FND_MSG_PUB.Count_And_Get (
801: p_encoded => FND_API.G_FALSE,
802: p_count => x_msg_count,
803: p_data => x_msg_data
804: );

Line 810: FND_MSG_PUB.Count_And_Get (

806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
807: ROLLBACK TO LOCK_Offr_Qual_PVT;
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809: -- Standard call to get message count and if count=1, get the message
810: FND_MSG_PUB.Count_And_Get (
811: p_encoded => FND_API.G_FALSE,
812: p_count => x_msg_count,
813: p_data => x_msg_data
814: );

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

815:
816: WHEN OTHERS THEN
817: ROLLBACK TO LOCK_Offr_Qual_PVT;
818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
819: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
820: THEN
821: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
822: END IF;
823: -- Standard call to get message count and if count=1, get the message

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

817: ROLLBACK TO LOCK_Offr_Qual_PVT;
818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
819: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
820: THEN
821: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
822: END IF;
823: -- Standard call to get message count and if count=1, get the message
824: FND_MSG_PUB.Count_And_Get (
825: p_encoded => FND_API.G_FALSE,

Line 824: FND_MSG_PUB.Count_And_Get (

820: THEN
821: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
822: END IF;
823: -- Standard call to get message count and if count=1, get the message
824: FND_MSG_PUB.Count_And_Get (
825: p_encoded => FND_API.G_FALSE,
826: p_count => x_msg_count,
827: p_data => x_msg_data
828: );

Line 1269: FND_MSG_PUB.initialize;

1265:
1266: -- Initialize message list if p_init_msg_list is set to TRUE.
1267: IF FND_API.to_Boolean( p_init_msg_list )
1268: THEN
1269: FND_MSG_PUB.initialize;
1270: END IF;
1271: l_ozf_offr_qual_rec := p_ozf_offr_qual_rec ;
1272:
1273:

Line 1315: FND_MSG_PUB.Count_And_Get

1311: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1312:
1313:
1314: -- Standard call to get message count and if count is 1, get message info.
1315: FND_MSG_PUB.Count_And_Get
1316: (p_count => x_msg_count,
1317: p_data => x_msg_data
1318: );
1319: EXCEPTION

Line 1329: FND_MSG_PUB.Count_And_Get (

1325: WHEN FND_API.G_EXC_ERROR THEN
1326: ROLLBACK TO validate_offr_qual_Pvt;
1327: x_return_status := FND_API.G_RET_STS_ERROR;
1328: -- Standard call to get message count and if count=1, get the message
1329: FND_MSG_PUB.Count_And_Get (
1330: p_encoded => FND_API.G_FALSE,
1331: p_count => x_msg_count,
1332: p_data => x_msg_data
1333: );

Line 1339: FND_MSG_PUB.Count_And_Get (

1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1336: ROLLBACK TO validate_offr_qual_Pvt;
1337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1338: -- Standard call to get message count and if count=1, get the message
1339: FND_MSG_PUB.Count_And_Get (
1340: p_encoded => FND_API.G_FALSE,
1341: p_count => x_msg_count,
1342: p_data => x_msg_data
1343: );

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

1344:
1345: WHEN OTHERS THEN
1346: ROLLBACK TO validate_offr_qual_Pvt;
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1349: THEN
1350: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1351: END IF;
1352: -- Standard call to get message count and if count=1, get the message

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

1346: ROLLBACK TO validate_offr_qual_Pvt;
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1349: THEN
1350: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1351: END IF;
1352: -- Standard call to get message count and if count=1, get the message
1353: FND_MSG_PUB.Count_And_Get (
1354: p_encoded => FND_API.G_FALSE,

Line 1353: FND_MSG_PUB.Count_And_Get (

1349: THEN
1350: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1351: END IF;
1352: -- Standard call to get message count and if count=1, get the message
1353: FND_MSG_PUB.Count_And_Get (
1354: p_encoded => FND_API.G_FALSE,
1355: p_count => x_msg_count,
1356: p_data => x_msg_data
1357: );

Line 1374: FND_MSG_PUB.initialize;

1370: BEGIN
1371: -- Initialize message list if p_init_msg_list is set to TRUE.
1372: IF FND_API.to_Boolean( p_init_msg_list )
1373: THEN
1374: FND_MSG_PUB.initialize;
1375: END IF;
1376:
1377:
1378:

Line 1390: FND_MSG_PUB.Count_And_Get

1386:
1387: -- Debug Message
1388: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1389: -- Standard call to get message count and if count is 1, get message info.
1390: FND_MSG_PUB.Count_And_Get
1391: (p_count => x_msg_count,
1392: p_data => x_msg_data
1393: );
1394: END Validate_ozf_offr_qual_Rec;