DBA Data[Home] [Help]

APPS.AMS_DELIVERABLE_PUB dependencies on FND_MSG_PUB

Line 20: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Deliverable_PUB';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amspdelb.pls';
19:
20: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
22: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
23:
24: PROCEDURE Convert_PubRec_To_PvtRec(

Line 21: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Deliverable_PUB';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amspdelb.pls';
19:
20: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
22: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
23:
24: PROCEDURE Convert_PubRec_To_PvtRec(
25: p_deliv_rec_pub IN deliv_rec_type,

Line 22: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amspdelb.pls';
19:
20: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
22: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
23:
24: PROCEDURE Convert_PubRec_To_PvtRec(
25: p_deliv_rec_pub IN deliv_rec_type,
26: x_deliv_rec_pvt OUT NOCOPY AMS_Deliverable_PVT.deliv_rec_type

Line 158: FND_MSG_PUB.initialize;

154:
155: -- Initialize message list if p_init_msg_list is set to TRUE.
156: IF FND_API.to_Boolean( p_init_msg_list )
157: THEN
158: FND_MSG_PUB.initialize;
159: END IF;
160:
161: -- Debug Message
162: IF (AMS_DEBUG_HIGH_ON) THEN

Line 207: FND_MSG_PUB.Count_And_Get

203: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
204: END IF;
205:
206: -- Standard call to get message count and if count is 1, get message info.
207: FND_MSG_PUB.Count_And_Get
208: (p_count => x_msg_count,
209: p_data => x_msg_data
210: );
211:

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

212: EXCEPTION
213:
214: WHEN AMS_Utility_PVT.resource_locked THEN
215: x_return_status := FND_API.g_ret_sts_error;
216: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
217: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
218: FND_MSG_PUB.add;
219: END IF;
220:

Line 218: FND_MSG_PUB.add;

214: WHEN AMS_Utility_PVT.resource_locked THEN
215: x_return_status := FND_API.g_ret_sts_error;
216: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
217: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
218: FND_MSG_PUB.add;
219: END IF;
220:
221: WHEN FND_API.G_EXC_ERROR THEN
222: ROLLBACK TO CREATE_deliv_PUB;

Line 225: FND_MSG_PUB.Count_And_Get (

221: WHEN FND_API.G_EXC_ERROR THEN
222: ROLLBACK TO CREATE_deliv_PUB;
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: -- Standard call to get message count and if count=1, get the message
225: FND_MSG_PUB.Count_And_Get (
226: p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count,
228: p_data => x_msg_data
229: );

Line 235: FND_MSG_PUB.Count_And_Get (

231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
232: ROLLBACK TO CREATE_deliv_PUB;
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: -- Standard call to get message count and if count=1, get the message
235: FND_MSG_PUB.Count_And_Get (
236: p_encoded => FND_API.G_FALSE,
237: p_count => x_msg_count,
238: p_data => x_msg_data
239: );

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

240:
241: WHEN OTHERS THEN
242: ROLLBACK TO CREATE_deliv_PUB;
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
245: THEN
246: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
247: END IF;
248: -- Standard call to get message count and if count=1, get the message

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

242: ROLLBACK TO CREATE_deliv_PUB;
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
245: THEN
246: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
247: END IF;
248: -- Standard call to get message count and if count=1, get the message
249: FND_MSG_PUB.Count_And_Get (
250: p_encoded => FND_API.G_FALSE,

Line 249: FND_MSG_PUB.Count_And_Get (

245: THEN
246: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
247: END IF;
248: -- Standard call to get message count and if count=1, get the message
249: FND_MSG_PUB.Count_And_Get (
250: p_encoded => FND_API.G_FALSE,
251: p_count => x_msg_count,
252: p_data => x_msg_data
253: );

Line 299: FND_MSG_PUB.initialize;

295:
296: -- Initialize message list if p_init_msg_list is set to TRUE.
297: IF FND_API.to_Boolean( p_init_msg_list )
298: THEN
299: FND_MSG_PUB.initialize;
300: END IF;
301:
302: -- Debug Message
303: IF (AMS_DEBUG_HIGH_ON) THEN

Line 416: FND_MSG_PUB.Count_And_Get

412: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
413: END IF;
414:
415: -- Standard call to get message count and if count is 1, get message info.
416: FND_MSG_PUB.Count_And_Get
417: (p_count => x_msg_count,
418: p_data => x_msg_data
419: );
420:

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

421: EXCEPTION
422:
423: WHEN AMS_Utility_PVT.resource_locked THEN
424: x_return_status := FND_API.g_ret_sts_error;
425: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
426: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
427: FND_MSG_PUB.add;
428: END IF;
429:

Line 427: FND_MSG_PUB.add;

423: WHEN AMS_Utility_PVT.resource_locked THEN
424: x_return_status := FND_API.g_ret_sts_error;
425: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
426: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
427: FND_MSG_PUB.add;
428: END IF;
429:
430: WHEN FND_API.G_EXC_ERROR THEN
431: ROLLBACK TO CREATE_Deliverable_PUB;

Line 434: FND_MSG_PUB.Count_And_Get (

430: WHEN FND_API.G_EXC_ERROR THEN
431: ROLLBACK TO CREATE_Deliverable_PUB;
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: -- Standard call to get message count and if count=1, get the message
434: FND_MSG_PUB.Count_And_Get (
435: p_encoded => FND_API.G_FALSE,
436: p_count => x_msg_count,
437: p_data => x_msg_data
438: );

Line 444: FND_MSG_PUB.Count_And_Get (

440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
441: ROLLBACK TO CREATE_Deliverable_PUB;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: -- Standard call to get message count and if count=1, get the message
444: FND_MSG_PUB.Count_And_Get (
445: p_encoded => FND_API.G_FALSE,
446: p_count => x_msg_count,
447: p_data => x_msg_data
448: );

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

449:
450: WHEN OTHERS THEN
451: ROLLBACK TO CREATE_Deliverable_PUB;
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
453: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
454: THEN
455: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
456: END IF;
457: -- Standard call to get message count and if count=1, get the message

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

451: ROLLBACK TO CREATE_Deliverable_PUB;
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
453: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
454: THEN
455: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
456: END IF;
457: -- Standard call to get message count and if count=1, get the message
458: FND_MSG_PUB.Count_And_Get (
459: p_encoded => FND_API.G_FALSE,

Line 458: FND_MSG_PUB.Count_And_Get (

454: THEN
455: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
456: END IF;
457: -- Standard call to get message count and if count=1, get the message
458: FND_MSG_PUB.Count_And_Get (
459: p_encoded => FND_API.G_FALSE,
460: p_count => x_msg_count,
461: p_data => x_msg_data
462: );

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: IF (AMS_DEBUG_HIGH_ON) THEN

Line 545: FND_MSG_PUB.Count_And_Get

541: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
542: END IF;
543:
544: -- Standard call to get message count and if count is 1, get message info.
545: FND_MSG_PUB.Count_And_Get
546: (p_count => x_msg_count,
547: p_data => x_msg_data
548: );
549: EXCEPTION

Line 559: FND_MSG_PUB.Count_And_Get (

555: WHEN FND_API.G_EXC_ERROR THEN
556: ROLLBACK TO UPDATE_Deliv_PUB;
557: x_return_status := FND_API.G_RET_STS_ERROR;
558: -- Standard call to get message count and if count=1, get the message
559: FND_MSG_PUB.Count_And_Get (
560: p_encoded => FND_API.G_FALSE,
561: p_count => x_msg_count,
562: p_data => x_msg_data
563: );

Line 569: FND_MSG_PUB.Count_And_Get (

565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: ROLLBACK TO UPDATE_Deliv_PUB;
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: -- Standard call to get message count and if count=1, get the message
569: FND_MSG_PUB.Count_And_Get (
570: p_encoded => FND_API.G_FALSE,
571: p_count => x_msg_count,
572: p_data => x_msg_data
573: );

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

574:
575: WHEN OTHERS THEN
576: ROLLBACK TO UPDATE_Deliv_PUB;
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
579: THEN
580: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
581: END IF;
582: -- Standard call to get message count and if count=1, get the message

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

576: ROLLBACK TO UPDATE_Deliv_PUB;
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
579: THEN
580: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
581: END IF;
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,

Line 583: FND_MSG_PUB.Count_And_Get (

579: THEN
580: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
581: END IF;
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 628: FND_MSG_PUB.initialize;

624:
625: -- Initialize message list if p_init_msg_list is set to TRUE.
626: IF FND_API.to_Boolean( p_init_msg_list )
627: THEN
628: FND_MSG_PUB.initialize;
629: END IF;
630:
631: -- Debug Message
632: IF (AMS_DEBUG_HIGH_ON) THEN

Line 733: FND_MSG_PUB.Count_And_Get

729: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
730: END IF;
731:
732: -- Standard call to get message count and if count is 1, get message info.
733: FND_MSG_PUB.Count_And_Get
734: (p_count => x_msg_count,
735: p_data => x_msg_data
736: );
737: EXCEPTION

Line 747: FND_MSG_PUB.Count_And_Get (

743: WHEN FND_API.G_EXC_ERROR THEN
744: ROLLBACK TO UPDATE_Deliverable_PUB;
745: x_return_status := FND_API.G_RET_STS_ERROR;
746: -- Standard call to get message count and if count=1, get the message
747: FND_MSG_PUB.Count_And_Get (
748: p_encoded => FND_API.G_FALSE,
749: p_count => x_msg_count,
750: p_data => x_msg_data
751: );

Line 757: FND_MSG_PUB.Count_And_Get (

753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
754: ROLLBACK TO UPDATE_Deliverable_PUB;
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756: -- Standard call to get message count and if count=1, get the message
757: FND_MSG_PUB.Count_And_Get (
758: p_encoded => FND_API.G_FALSE,
759: p_count => x_msg_count,
760: p_data => x_msg_data
761: );

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

762:
763: WHEN OTHERS THEN
764: ROLLBACK TO UPDATE_Deliverable_PUB;
765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
766: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
767: THEN
768: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
769: END IF;
770: -- Standard call to get message count and if count=1, get the message

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

764: ROLLBACK TO UPDATE_Deliverable_PUB;
765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
766: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
767: THEN
768: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
769: END IF;
770: -- Standard call to get message count and if count=1, get the message
771: FND_MSG_PUB.Count_And_Get (
772: p_encoded => FND_API.G_FALSE,

Line 771: FND_MSG_PUB.Count_And_Get (

767: THEN
768: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
769: END IF;
770: -- Standard call to get message count and if count=1, get the message
771: FND_MSG_PUB.Count_And_Get (
772: p_encoded => FND_API.G_FALSE,
773: p_count => x_msg_count,
774: p_data => x_msg_data
775: );

Line 819: FND_MSG_PUB.initialize;

815:
816: -- Initialize message list if p_init_msg_list is set to TRUE.
817: IF FND_API.to_Boolean( p_init_msg_list )
818: THEN
819: FND_MSG_PUB.initialize;
820: END IF;
821:
822: -- Debug Message
823: IF (AMS_DEBUG_HIGH_ON) THEN

Line 935: FND_MSG_PUB.Count_And_Get

931: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
932: END IF;
933:
934: -- Standard call to get message count and if count is 1, get message info.
935: FND_MSG_PUB.Count_And_Get
936: (p_count => x_msg_count,
937: p_data => x_msg_data
938: );
939: EXCEPTION

Line 949: FND_MSG_PUB.Count_And_Get (

945: WHEN FND_API.G_EXC_ERROR THEN
946: ROLLBACK TO DELETE_Deliverable_PUB;
947: x_return_status := FND_API.G_RET_STS_ERROR;
948: -- Standard call to get message count and if count=1, get the message
949: FND_MSG_PUB.Count_And_Get (
950: p_encoded => FND_API.G_FALSE,
951: p_count => x_msg_count,
952: p_data => x_msg_data
953: );

Line 959: FND_MSG_PUB.Count_And_Get (

955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
956: ROLLBACK TO DELETE_Deliverable_PUB;
957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
958: -- Standard call to get message count and if count=1, get the message
959: FND_MSG_PUB.Count_And_Get (
960: p_encoded => FND_API.G_FALSE,
961: p_count => x_msg_count,
962: p_data => x_msg_data
963: );

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

964:
965: WHEN OTHERS THEN
966: ROLLBACK TO DELETE_Deliverable_PUB;
967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
968: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
969: THEN
970: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
971: END IF;
972: -- Standard call to get message count and if count=1, get the message

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

966: ROLLBACK TO DELETE_Deliverable_PUB;
967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
968: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
969: THEN
970: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
971: END IF;
972: -- Standard call to get message count and if count=1, get the message
973: FND_MSG_PUB.Count_And_Get (
974: p_encoded => FND_API.G_FALSE,

Line 973: FND_MSG_PUB.Count_And_Get (

969: THEN
970: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
971: END IF;
972: -- Standard call to get message count and if count=1, get the message
973: FND_MSG_PUB.Count_And_Get (
974: p_encoded => FND_API.G_FALSE,
975: p_count => x_msg_count,
976: p_data => x_msg_data
977: );

Line 1006: FND_MSG_PUB.initialize;

1002:
1003: -- initialize the message list;
1004: -- won't do it again when calling private API
1005: IF FND_API.to_boolean(p_init_msg_list) THEN
1006: FND_MSG_PUB.initialize;
1007: END IF;
1008:
1009: -- Initialize API return status to SUCCESS
1010: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1101: FND_MSG_PUB.Count_And_Get

1097: -- Debug Message
1098: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
1099:
1100: -- Standard call to get message count and if count is 1, get message info.
1101: FND_MSG_PUB.Count_And_Get
1102: (p_count => x_msg_count,
1103: p_data => x_msg_data
1104: );
1105:

Line 1111: FND_MSG_PUB.count_and_get(

1107:
1108: WHEN FND_API.g_exc_error THEN
1109: ROLLBACK TO validate_Deliverable_pub;
1110: x_return_status := FND_API.g_ret_sts_error;
1111: FND_MSG_PUB.count_and_get(
1112: p_encoded => FND_API.g_false,
1113: p_count => x_msg_count,
1114: p_data => x_msg_data
1115: );

Line 1120: FND_MSG_PUB.count_and_get(

1116:
1117: WHEN FND_API.g_exc_unexpected_error THEN
1118: ROLLBACK TO validate_Deliverable_pub;
1119: x_return_status := FND_API.g_ret_sts_unexp_error ;
1120: FND_MSG_PUB.count_and_get(
1121: p_encoded => FND_API.g_false,
1122: p_count => x_msg_count,
1123: p_data => x_msg_data
1124: );

Line 1131: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1127: WHEN OTHERS THEN
1128: ROLLBACK TO validate_Deliverable_pub;
1129: x_return_status := FND_API.g_ret_sts_unexp_error ;
1130:
1131: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1132: THEN
1133: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1134: END IF;
1135:

Line 1133: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1129: x_return_status := FND_API.g_ret_sts_unexp_error ;
1130:
1131: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1132: THEN
1133: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1134: END IF;
1135:
1136: FND_MSG_PUB.count_and_get(
1137: p_encoded => FND_API.g_false,

Line 1136: FND_MSG_PUB.count_and_get(

1132: THEN
1133: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1134: END IF;
1135:
1136: FND_MSG_PUB.count_and_get(
1137: p_encoded => FND_API.g_false,
1138: p_count => x_msg_count,
1139: p_data => x_msg_data
1140: );

Line 1180: FND_MSG_PUB.initialize;

1176:
1177: -- Initialize message list if p_init_msg_list is set to TRUE.
1178: IF FND_API.to_Boolean( p_init_msg_list )
1179: THEN
1180: FND_MSG_PUB.initialize;
1181: END IF;
1182:
1183: -- Debug Message
1184: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

Line 1292: FND_MSG_PUB.Count_And_Get (

1288: WHEN FND_API.G_EXC_ERROR THEN
1289: ROLLBACK TO LOCK_Deliverable_PUB;
1290: x_return_status := FND_API.G_RET_STS_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: );

Line 1302: FND_MSG_PUB.Count_And_Get (

1298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1299: ROLLBACK TO LOCK_Deliverable_PUB;
1300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1301: -- Standard call to get message count and if count=1, get the message
1302: FND_MSG_PUB.Count_And_Get (
1303: p_encoded => FND_API.G_FALSE,
1304: p_count => x_msg_count,
1305: p_data => x_msg_data
1306: );

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

1307:
1308: WHEN OTHERS THEN
1309: ROLLBACK TO LOCK_Deliverable_PUB;
1310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1311: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1312: THEN
1313: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1314: END IF;
1315: -- Standard call to get message count and if count=1, get the message

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

1309: ROLLBACK TO LOCK_Deliverable_PUB;
1310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1311: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1312: THEN
1313: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1314: END IF;
1315: -- Standard call to get message count and if count=1, get the message
1316: FND_MSG_PUB.Count_And_Get (
1317: p_encoded => FND_API.G_FALSE,

Line 1316: FND_MSG_PUB.Count_And_Get (

1312: THEN
1313: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1314: END IF;
1315: -- Standard call to get message count and if count=1, get the message
1316: FND_MSG_PUB.Count_And_Get (
1317: p_encoded => FND_API.G_FALSE,
1318: p_count => x_msg_count,
1319: p_data => x_msg_data
1320: );