DBA Data[Home] [Help]

APPS.AMS_CODE_DEFINITION_PVT dependencies on FND_MSG_PUB

Line 79: FND_MSG_PUB.initialize;

75:
76: -- Initialize message list if p_init_msg_list is set to TRUE.
77: IF FND_API.to_Boolean( p_init_msg_list )
78: THEN
79: FND_MSG_PUB.initialize;
80: END IF;
81:
82: -- Debug Message
83: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

135: RAISE FND_API.G_EXC_ERROR;
136: END IF;
137:
138: IF p_code_def_rec.object_def IS NULL OR p_code_def_rec.object_def = FND_API.g_miss_char THEN
139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
140: FND_MESSAGE.set_name('AMS', 'AMS_OBJECT_TYPE_MISSING');
141: FND_MSG_PUB.add;
142: END IF;
143: RAISE FND_API.g_exc_error;

Line 141: FND_MSG_PUB.add;

137:
138: IF p_code_def_rec.object_def IS NULL OR p_code_def_rec.object_def = FND_API.g_miss_char THEN
139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
140: FND_MESSAGE.set_name('AMS', 'AMS_OBJECT_TYPE_MISSING');
141: FND_MSG_PUB.add;
142: END IF;
143: RAISE FND_API.g_exc_error;
144: END IF;
145:

Line 151: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

147: FETCH c_col_name INTO l_dummy;
148: CLOSE c_col_name;
149:
150: IF (l_dummy >0) THEN
151: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
152: FND_MESSAGE.set_name('AMS', 'AMS_DUPLICATE_COLUMN_NAME');
153: FND_MSG_PUB.add;
154: END IF;
155: RAISE FND_API.g_exc_error;

Line 153: FND_MSG_PUB.add;

149:
150: IF (l_dummy >0) THEN
151: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
152: FND_MESSAGE.set_name('AMS', 'AMS_DUPLICATE_COLUMN_NAME');
153: FND_MSG_PUB.add;
154: END IF;
155: RAISE FND_API.g_exc_error;
156: END IF;
157: -- Debug Message

Line 191: FND_MSG_PUB.Count_And_Get

187: -- Debug Message
188: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
189:
190: -- Standard call to get message count and if count is 1, get message info.
191: FND_MSG_PUB.Count_And_Get
192: (p_count => x_msg_count,
193: p_data => x_msg_data
194: );
195: EXCEPTION

Line 205: FND_MSG_PUB.Count_And_Get (

201: WHEN FND_API.G_EXC_ERROR THEN
202: ROLLBACK TO CREATE_Code_Definition_PVT;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: -- Standard call to get message count and if count=1, get the message
205: FND_MSG_PUB.Count_And_Get (
206: p_encoded => FND_API.G_FALSE,
207: p_count => x_msg_count,
208: p_data => x_msg_data
209: );

Line 215: FND_MSG_PUB.Count_And_Get (

211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
212: ROLLBACK TO CREATE_Code_Definition_PVT;
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
214: -- Standard call to get message count and if count=1, get the message
215: FND_MSG_PUB.Count_And_Get (
216: p_encoded => FND_API.G_FALSE,
217: p_count => x_msg_count,
218: p_data => x_msg_data
219: );

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

220:
221: WHEN OTHERS THEN
222: ROLLBACK TO CREATE_Code_Definition_PVT;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
225: THEN
226: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
227: END IF;
228: -- Standard call to get message count and if count=1, get the message

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

222: ROLLBACK TO CREATE_Code_Definition_PVT;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
225: THEN
226: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
227: END IF;
228: -- Standard call to get message count and if count=1, get the message
229: FND_MSG_PUB.Count_And_Get (
230: p_encoded => FND_API.G_FALSE,

Line 229: FND_MSG_PUB.Count_And_Get (

225: THEN
226: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
227: END IF;
228: -- Standard call to get message count and if count=1, get the message
229: FND_MSG_PUB.Count_And_Get (
230: p_encoded => FND_API.G_FALSE,
231: p_count => x_msg_count,
232: p_data => x_msg_data
233: );

Line 356: FND_MSG_PUB.initialize;

352:
353: -- Initialize message list if p_init_msg_list is set to TRUE.
354: IF FND_API.to_Boolean( p_init_msg_list )
355: THEN
356: FND_MSG_PUB.initialize;
357: END IF;
358:
359: -- Debug Message
360: --AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 456: FND_MSG_PUB.Count_And_Get

452: -- Debug Message
453: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
454:
455: -- Standard call to get message count and if count is 1, get message info.
456: FND_MSG_PUB.Count_And_Get
457: (p_count => x_msg_count,
458: p_data => x_msg_data
459: );
460: EXCEPTION

Line 470: FND_MSG_PUB.Count_And_Get (

466: WHEN FND_API.G_EXC_ERROR THEN
467: ROLLBACK TO UPDATE_Code_Definition_PVT;
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: -- Standard call to get message count and if count=1, get the message
470: FND_MSG_PUB.Count_And_Get (
471: p_encoded => FND_API.G_FALSE,
472: p_count => x_msg_count,
473: p_data => x_msg_data
474: );

Line 480: FND_MSG_PUB.Count_And_Get (

476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
477: ROLLBACK TO UPDATE_Code_Definition_PVT;
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: -- Standard call to get message count and if count=1, get the message
480: FND_MSG_PUB.Count_And_Get (
481: p_encoded => FND_API.G_FALSE,
482: p_count => x_msg_count,
483: p_data => x_msg_data
484: );

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

485:
486: WHEN OTHERS THEN
487: ROLLBACK TO UPDATE_Code_Definition_PVT;
488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
490: THEN
491: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
492: END IF;
493: -- Standard call to get message count and if count=1, get the message

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

487: ROLLBACK TO UPDATE_Code_Definition_PVT;
488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
490: THEN
491: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
492: END IF;
493: -- Standard call to get message count and if count=1, get the message
494: FND_MSG_PUB.Count_And_Get (
495: p_encoded => FND_API.G_FALSE,

Line 494: FND_MSG_PUB.Count_And_Get (

490: THEN
491: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
492: END IF;
493: -- Standard call to get message count and if count=1, get the message
494: FND_MSG_PUB.Count_And_Get (
495: p_encoded => FND_API.G_FALSE,
496: p_count => x_msg_count,
497: p_data => x_msg_data
498: );

Line 535: FND_MSG_PUB.initialize;

531:
532: -- Initialize message list if p_init_msg_list is set to TRUE.
533: IF FND_API.to_Boolean( p_init_msg_list )
534: THEN
535: FND_MSG_PUB.initialize;
536: END IF;
537:
538: -- Debug Message
539: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 569: FND_MSG_PUB.Count_And_Get

565: -- Debug Message
566: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
567:
568: -- Standard call to get message count and if count is 1, get message info.
569: FND_MSG_PUB.Count_And_Get
570: (p_count => x_msg_count,
571: p_data => x_msg_data
572: );
573: EXCEPTION

Line 583: FND_MSG_PUB.Count_And_Get (

579: WHEN FND_API.G_EXC_ERROR THEN
580: ROLLBACK TO DELETE_Code_Definition_PVT;
581: x_return_status := FND_API.G_RET_STS_ERROR;
582: -- Standard call to get message count and if count=1, get the message
583: FND_MSG_PUB.Count_And_Get (
584: p_encoded => FND_API.G_FALSE,
585: p_count => x_msg_count,
586: p_data => x_msg_data
587: );

Line 593: FND_MSG_PUB.Count_And_Get (

589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590: ROLLBACK TO DELETE_Code_Definition_PVT;
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: -- Standard call to get message count and if count=1, get the message
593: FND_MSG_PUB.Count_And_Get (
594: p_encoded => FND_API.G_FALSE,
595: p_count => x_msg_count,
596: p_data => x_msg_data
597: );

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

598:
599: WHEN OTHERS THEN
600: ROLLBACK TO DELETE_Code_Definition_PVT;
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
603: THEN
604: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
605: END IF;
606: -- Standard call to get message count and if count=1, get the message

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

600: ROLLBACK TO DELETE_Code_Definition_PVT;
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
603: THEN
604: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
605: END IF;
606: -- Standard call to get message count and if count=1, get the message
607: FND_MSG_PUB.Count_And_Get (
608: p_encoded => FND_API.G_FALSE,

Line 607: FND_MSG_PUB.Count_And_Get (

603: THEN
604: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
605: END IF;
606: -- Standard call to get message count and if count=1, get the message
607: FND_MSG_PUB.Count_And_Get (
608: p_encoded => FND_API.G_FALSE,
609: p_count => x_msg_count,
610: p_data => x_msg_data
611: );

Line 650: FND_MSG_PUB.initialize;

646:
647: -- Initialize message list if p_init_msg_list is set to TRUE.
648: IF FND_API.to_Boolean( p_init_msg_list )
649: THEN
650: FND_MSG_PUB.initialize;
651: END IF;
652:
653: -- Standard call to check for call compatibility.
654: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 676: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

672: FETCH c_Code_Definition INTO l_CODE_DEFINITION_ID;
673:
674: IF (c_Code_Definition%NOTFOUND) THEN
675: CLOSE c_Code_Definition;
676: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
677: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
678: FND_MSG_PUB.add;
679: END IF;
680: RAISE FND_API.g_exc_error;

Line 678: FND_MSG_PUB.add;

674: IF (c_Code_Definition%NOTFOUND) THEN
675: CLOSE c_Code_Definition;
676: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
677: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
678: FND_MSG_PUB.add;
679: END IF;
680: RAISE FND_API.g_exc_error;
681: END IF;
682:

Line 686: FND_MSG_PUB.count_and_get(

682:
683: CLOSE c_Code_Definition;
684:
685: -------------------- finish --------------------------
686: FND_MSG_PUB.count_and_get(
687: p_encoded => FND_API.g_false,
688: p_count => x_msg_count,
689: p_data => x_msg_data);
690: AMS_Utility_PVT.debug_message(l_full_name ||': end');

Line 701: FND_MSG_PUB.Count_And_Get (

697: WHEN FND_API.G_EXC_ERROR THEN
698: ROLLBACK TO LOCK_Code_Definition_PVT;
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: -- Standard call to get message count and if count=1, get the message
701: FND_MSG_PUB.Count_And_Get (
702: p_encoded => FND_API.G_FALSE,
703: p_count => x_msg_count,
704: p_data => x_msg_data
705: );

Line 711: FND_MSG_PUB.Count_And_Get (

707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
708: ROLLBACK TO LOCK_Code_Definition_PVT;
709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
710: -- Standard call to get message count and if count=1, get the message
711: FND_MSG_PUB.Count_And_Get (
712: p_encoded => FND_API.G_FALSE,
713: p_count => x_msg_count,
714: p_data => x_msg_data
715: );

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

716:
717: WHEN OTHERS THEN
718: ROLLBACK TO LOCK_Code_Definition_PVT;
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
721: THEN
722: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
723: END IF;
724: -- Standard call to get message count and if count=1, get the message

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

718: ROLLBACK TO LOCK_Code_Definition_PVT;
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
721: THEN
722: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
723: END IF;
724: -- Standard call to get message count and if count=1, get the message
725: FND_MSG_PUB.Count_And_Get (
726: p_encoded => FND_API.G_FALSE,

Line 725: FND_MSG_PUB.Count_And_Get (

721: THEN
722: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
723: END IF;
724: -- Standard call to get message count and if count=1, get the message
725: FND_MSG_PUB.Count_And_Get (
726: p_encoded => FND_API.G_FALSE,
727: p_count => x_msg_count,
728: p_data => x_msg_data
729: );

Line 913: FND_MSG_PUB.initialize;

909:
910: -- Initialize message list if p_init_msg_list is set to TRUE.
911: IF FND_API.to_Boolean( p_init_msg_list )
912: THEN
913: FND_MSG_PUB.initialize;
914: END IF;
915: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
916: Check_code_def_Items(
917: p_code_def_rec => p_code_def_rec,

Line 963: FND_MSG_PUB.Count_And_Get

959: -- Debug Message
960: -- AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
961:
962: -- Standard call to get message count and if count is 1, get message info.
963: FND_MSG_PUB.Count_And_Get
964: (p_count => x_msg_count,
965: p_data => x_msg_data
966: );
967: EXCEPTION

Line 977: FND_MSG_PUB.Count_And_Get (

973: WHEN FND_API.G_EXC_ERROR THEN
974: ROLLBACK TO VALIDATE_Code_Definition_;
975: x_return_status := FND_API.G_RET_STS_ERROR;
976: -- Standard call to get message count and if count=1, get the message
977: FND_MSG_PUB.Count_And_Get (
978: p_encoded => FND_API.G_FALSE,
979: p_count => x_msg_count,
980: p_data => x_msg_data
981: );

Line 987: FND_MSG_PUB.Count_And_Get (

983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
984: ROLLBACK TO VALIDATE_Code_Definition_;
985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
986: -- Standard call to get message count and if count=1, get the message
987: FND_MSG_PUB.Count_And_Get (
988: p_encoded => FND_API.G_FALSE,
989: p_count => x_msg_count,
990: p_data => x_msg_data
991: );

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

992:
993: WHEN OTHERS THEN
994: ROLLBACK TO VALIDATE_Code_Definition_;
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
996: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
997: THEN
998: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
999: END IF;
1000: -- Standard call to get message count and if count=1, get the message

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

994: ROLLBACK TO VALIDATE_Code_Definition_;
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
996: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
997: THEN
998: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
999: END IF;
1000: -- Standard call to get message count and if count=1, get the message
1001: FND_MSG_PUB.Count_And_Get (
1002: p_encoded => FND_API.G_FALSE,

Line 1001: FND_MSG_PUB.Count_And_Get (

997: THEN
998: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
999: END IF;
1000: -- Standard call to get message count and if count=1, get the message
1001: FND_MSG_PUB.Count_And_Get (
1002: p_encoded => FND_API.G_FALSE,
1003: p_count => x_msg_count,
1004: p_data => x_msg_data
1005: );

Line 1022: FND_MSG_PUB.initialize;

1018: BEGIN
1019: -- Initialize message list if p_init_msg_list is set to TRUE.
1020: IF FND_API.to_Boolean( p_init_msg_list )
1021: THEN
1022: FND_MSG_PUB.initialize;
1023: END IF;
1024:
1025: -- Initialize API return status to SUCCESS
1026: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1036: FND_MSG_PUB.Count_And_Get

1032:
1033: -- Debug Message
1034: -- AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1035: -- Standard call to get message count and if count is 1, get message info.
1036: FND_MSG_PUB.Count_And_Get
1037: (p_count => x_msg_count,
1038: p_data => x_msg_data
1039: );
1040: END Validate_code_def_Rec;