DBA Data[Home] [Help]

APPS.AMS_ST_ASSOC_PVT dependencies on FND_MSG_PUB

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

18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvstab.pls';
19:
20:
21: -- Hint: Primary key needs to be returned.
22: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
23: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
24: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
25:
26: PROCEDURE Create_St_Assoc(

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

19:
20:
21: -- Hint: Primary key needs to be returned.
22: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
23: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
24: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
25:
26: PROCEDURE Create_St_Assoc(
27: p_api_version_number IN NUMBER,

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

20:
21: -- Hint: Primary key needs to be returned.
22: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
23: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
24: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
25:
26: PROCEDURE Create_St_Assoc(
27: p_api_version_number IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 72: FND_MSG_PUB.initialize;

68:
69: -- Initialize message list if p_init_msg_list is set to TRUE.
70: IF FND_API.to_Boolean( p_init_msg_list )
71: THEN
72: FND_MSG_PUB.initialize;
73: END IF;
74:
75: -- Debug Message
76: IF (AMS_DEBUG_HIGH_ON) THEN

Line 178: FND_MSG_PUB.Count_And_Get

174: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
175: END IF;
176:
177: -- Standard call to get message count and if count is 1, get message info.
178: FND_MSG_PUB.Count_And_Get
179: (p_count => x_msg_count,
180: p_data => x_msg_data
181: );
182:

Line 193: FND_MSG_PUB.Count_And_Get (

189: WHEN FND_API.G_EXC_ERROR THEN
190: ROLLBACK TO CREATE_St_Assoc_PVT;
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: -- Standard call to get message count and if count=1, get the message
193: FND_MSG_PUB.Count_And_Get (
194: p_encoded => FND_API.G_FALSE,
195: p_count => x_msg_count,
196: p_data => x_msg_data
197: );

Line 203: FND_MSG_PUB.Count_And_Get (

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

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

208:
209: WHEN OTHERS THEN
210: ROLLBACK TO CREATE_St_Assoc_PVT;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
213: THEN
214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
215: END IF;
216: -- Standard call to get message count and if count=1, get the message

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

210: ROLLBACK TO CREATE_St_Assoc_PVT;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
213: THEN
214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
215: END IF;
216: -- Standard call to get message count and if count=1, get the message
217: FND_MSG_PUB.Count_And_Get (
218: p_encoded => FND_API.G_FALSE,

Line 217: FND_MSG_PUB.Count_And_Get (

213: THEN
214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
215: END IF;
216: -- Standard call to get message count and if count=1, get the message
217: FND_MSG_PUB.Count_And_Get (
218: p_encoded => FND_API.G_FALSE,
219: p_count => x_msg_count,
220: p_data => x_msg_data
221: );

Line 272: FND_MSG_PUB.initialize;

268:
269: -- Initialize message list if p_init_msg_list is set to TRUE.
270: IF FND_API.to_Boolean( p_init_msg_list )
271: THEN
272: FND_MSG_PUB.initialize;
273: END IF;
274:
275: -- Debug Message
276: IF (AMS_DEBUG_HIGH_ON) THEN

Line 352: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');END IF;

348: END IF;
349:
350:
351: -- Debug Message
352: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');END IF;
353: --this above statement cause problem of char to number conversion error
354:
355: -- Invoke table handler(AMS_LIST_SRC_TYPE_ASSOCS_PKG.Update_Row)
356: AMS_LIST_SRC_TYPE_ASSOCS_PKG.Update_Row(

Line 391: FND_MSG_PUB.Count_And_Get

387: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
388: END IF;
389:
390: -- Standard call to get message count and if count is 1, get message info.
391: FND_MSG_PUB.Count_And_Get
392: (p_count => x_msg_count,
393: p_data => x_msg_data
394: );
395: EXCEPTION

Line 405: FND_MSG_PUB.Count_And_Get (

401: WHEN FND_API.G_EXC_ERROR THEN
402: ROLLBACK TO UPDATE_St_Assoc_PVT;
403: x_return_status := FND_API.G_RET_STS_ERROR;
404: -- Standard call to get message count and if count=1, get the message
405: FND_MSG_PUB.Count_And_Get (
406: p_encoded => FND_API.G_FALSE,
407: p_count => x_msg_count,
408: p_data => x_msg_data
409: );

Line 415: FND_MSG_PUB.Count_And_Get (

411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
412: ROLLBACK TO UPDATE_St_Assoc_PVT;
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414: -- Standard call to get message count and if count=1, get the message
415: FND_MSG_PUB.Count_And_Get (
416: p_encoded => FND_API.G_FALSE,
417: p_count => x_msg_count,
418: p_data => x_msg_data
419: );

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

420:
421: WHEN OTHERS THEN
422: ROLLBACK TO UPDATE_St_Assoc_PVT;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
427: END IF;
428: -- Standard call to get message count and if count=1, get the message

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

422: ROLLBACK TO UPDATE_St_Assoc_PVT;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
427: END IF;
428: -- Standard call to get message count and if count=1, get the message
429: FND_MSG_PUB.Count_And_Get (
430: p_encoded => FND_API.G_FALSE,

Line 429: FND_MSG_PUB.Count_And_Get (

425: THEN
426: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
427: END IF;
428: -- Standard call to get message count and if count=1, get the message
429: FND_MSG_PUB.Count_And_Get (
430: p_encoded => FND_API.G_FALSE,
431: p_count => x_msg_count,
432: p_data => x_msg_data
433: );

Line 470: FND_MSG_PUB.initialize;

466:
467: -- Initialize message list if p_init_msg_list is set to TRUE.
468: IF FND_API.to_Boolean( p_init_msg_list )
469: THEN
470: FND_MSG_PUB.initialize;
471: END IF;
472:
473: -- Debug Message
474: IF (AMS_DEBUG_HIGH_ON) THEN

Line 513: FND_MSG_PUB.Count_And_Get

509: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
510: END IF;
511:
512: -- Standard call to get message count and if count is 1, get message info.
513: FND_MSG_PUB.Count_And_Get
514: (p_count => x_msg_count,
515: p_data => x_msg_data
516: );
517: EXCEPTION

Line 527: FND_MSG_PUB.Count_And_Get (

523: WHEN FND_API.G_EXC_ERROR THEN
524: ROLLBACK TO DELETE_St_Assoc_PVT;
525: x_return_status := FND_API.G_RET_STS_ERROR;
526: -- Standard call to get message count and if count=1, get the message
527: FND_MSG_PUB.Count_And_Get (
528: p_encoded => FND_API.G_FALSE,
529: p_count => x_msg_count,
530: p_data => x_msg_data
531: );

Line 537: FND_MSG_PUB.Count_And_Get (

533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534: ROLLBACK TO DELETE_St_Assoc_PVT;
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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 546: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

542:
543: WHEN OTHERS THEN
544: ROLLBACK TO DELETE_St_Assoc_PVT;
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
546: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
547: THEN
548: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
549: END IF;
550: -- Standard call to get message count and if count=1, get the message

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

544: ROLLBACK TO DELETE_St_Assoc_PVT;
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
546: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
547: THEN
548: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
549: END IF;
550: -- Standard call to get message count and if count=1, get the message
551: FND_MSG_PUB.Count_And_Get (
552: p_encoded => FND_API.G_FALSE,

Line 551: FND_MSG_PUB.Count_And_Get (

547: THEN
548: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
549: END IF;
550: -- Standard call to get message count and if count=1, get the message
551: FND_MSG_PUB.Count_And_Get (
552: p_encoded => FND_API.G_FALSE,
553: p_count => x_msg_count,
554: p_data => x_msg_data
555: );

Line 597: FND_MSG_PUB.initialize;

593:
594: -- Initialize message list if p_init_msg_list is set to TRUE.
595: IF FND_API.to_Boolean( p_init_msg_list )
596: THEN
597: FND_MSG_PUB.initialize;
598: END IF;
599:
600: -- Standard call to check for call compatibility.
601: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

625: FETCH c_St_Assoc INTO l_LIST_SOURCE_TYPE_ASSOC_ID;
626:
627: IF (c_St_Assoc%NOTFOUND) THEN
628: CLOSE c_St_Assoc;
629: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
630: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
631: FND_MSG_PUB.add;
632: END IF;
633: RAISE FND_API.g_exc_error;

Line 631: FND_MSG_PUB.add;

627: IF (c_St_Assoc%NOTFOUND) THEN
628: CLOSE c_St_Assoc;
629: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
630: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
631: FND_MSG_PUB.add;
632: END IF;
633: RAISE FND_API.g_exc_error;
634: END IF;
635:

Line 639: FND_MSG_PUB.count_and_get(

635:
636: CLOSE c_St_Assoc;
637:
638: -------------------- finish --------------------------
639: FND_MSG_PUB.count_and_get(
640: p_encoded => FND_API.g_false,
641: p_count => x_msg_count,
642: p_data => x_msg_data);
643: IF (AMS_DEBUG_HIGH_ON) THEN

Line 657: FND_MSG_PUB.Count_And_Get (

653: WHEN FND_API.G_EXC_ERROR THEN
654: ROLLBACK TO LOCK_St_Assoc_PVT;
655: x_return_status := FND_API.G_RET_STS_ERROR;
656: -- Standard call to get message count and if count=1, get the message
657: FND_MSG_PUB.Count_And_Get (
658: p_encoded => FND_API.G_FALSE,
659: p_count => x_msg_count,
660: p_data => x_msg_data
661: );

Line 667: FND_MSG_PUB.Count_And_Get (

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

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

672:
673: WHEN OTHERS THEN
674: ROLLBACK TO LOCK_St_Assoc_PVT;
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
677: THEN
678: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
679: END IF;
680: -- Standard call to get message count and if count=1, get the message

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

674: ROLLBACK TO LOCK_St_Assoc_PVT;
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
677: THEN
678: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
679: END IF;
680: -- Standard call to get message count and if count=1, get the message
681: FND_MSG_PUB.Count_And_Get (
682: p_encoded => FND_API.G_FALSE,

Line 681: FND_MSG_PUB.Count_And_Get (

677: THEN
678: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
679: END IF;
680: -- Standard call to get message count and if count=1, get the message
681: FND_MSG_PUB.Count_And_Get (
682: p_encoded => FND_API.G_FALSE,
683: p_count => x_msg_count,
684: p_data => x_msg_data
685: );

Line 832: FND_MSG_PUB.add;

828: */
829: IF p_st_assoc_rec.master_source_type_id IS NULL THEN
830: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
831: FND_MESSAGE.set_token('MISS_FIELD', 'MASTER_SOURCE_TYPE_ID' );
832: FND_MSG_PUB.add;
833: x_return_status := FND_API.g_ret_sts_error;
834: RETURN;
835: END IF;
836:

Line 841: --FND_MSG_PUB.add;

837: -- code required
838: IF p_st_assoc_rec.sub_source_type_id IS NULL THEN
839: --FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
840: --FND_MESSAGE.set_token('MISS_FIELD', 'SUB_SOURCE_TYPE_ID' );
841: --FND_MSG_PUB.add;
842: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_NO_SUB_SOURCE_TYPE_ID');
843: x_return_status := FND_API.g_ret_sts_error;
844: RETURN;
845: END IF;

Line 852: --FND_MSG_PUB.add;

848: -- code foreign key required
849: IF p_st_assoc_rec.sub_source_type_pk_column IS NULL THEN
850: --FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
851: --FND_MESSAGE.set_token('MISS_FIELD', 'SUB_SOURCE_TYPE_PK_COLUMN' );
852: --FND_MSG_PUB.add;
853: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_NO_SUB_SOURCE_TYPE_PK_COL');
854: x_return_status := FND_API.g_ret_sts_error;
855: RETURN;
856: END IF;

Line 862: FND_MSG_PUB.add;

858:
859: IF p_st_assoc_rec.enabled_flag IS NULL THEN
860: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
861: FND_MESSAGE.set_token('MISS_FIELD', 'ENABLED_FLAG' );
862: FND_MSG_PUB.add;
863: x_return_status := FND_API.g_ret_sts_error;
864: RETURN;
865: END IF;
866: -- END IF;

Line 1084: FND_MSG_PUB.initialize;

1080:
1081: -- Initialize message list if p_init_msg_list is set to TRUE.
1082: IF FND_API.to_Boolean( p_init_msg_list )
1083: THEN
1084: FND_MSG_PUB.initialize;
1085: END IF;
1086:
1087: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1088: Check_st_assoc_Items(

Line 1141: FND_MSG_PUB.Count_And_Get

1137: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1138: END IF;
1139:
1140: -- Standard call to get message count and if count is 1, get message info.
1141: FND_MSG_PUB.Count_And_Get
1142: (p_count => x_msg_count,
1143: p_data => x_msg_data
1144: );
1145: EXCEPTION

Line 1155: FND_MSG_PUB.Count_And_Get (

1151: WHEN FND_API.G_EXC_ERROR THEN
1152: ROLLBACK TO VALIDATE_St_Assoc_;
1153: x_return_status := FND_API.G_RET_STS_ERROR;
1154: -- Standard call to get message count and if count=1, get the message
1155: FND_MSG_PUB.Count_And_Get (
1156: p_encoded => FND_API.G_FALSE,
1157: p_count => x_msg_count,
1158: p_data => x_msg_data
1159: );

Line 1165: FND_MSG_PUB.Count_And_Get (

1161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1162: ROLLBACK TO VALIDATE_St_Assoc_;
1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1164: -- Standard call to get message count and if count=1, get the message
1165: FND_MSG_PUB.Count_And_Get (
1166: p_encoded => FND_API.G_FALSE,
1167: p_count => x_msg_count,
1168: p_data => x_msg_data
1169: );

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

1170:
1171: WHEN OTHERS THEN
1172: ROLLBACK TO VALIDATE_St_Assoc_;
1173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1174: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1175: THEN
1176: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1177: END IF;
1178: -- Standard call to get message count and if count=1, get the message

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

1172: ROLLBACK TO VALIDATE_St_Assoc_;
1173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1174: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1175: THEN
1176: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1177: END IF;
1178: -- Standard call to get message count and if count=1, get the message
1179: FND_MSG_PUB.Count_And_Get (
1180: p_encoded => FND_API.G_FALSE,

Line 1179: FND_MSG_PUB.Count_And_Get (

1175: THEN
1176: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1177: END IF;
1178: -- Standard call to get message count and if count=1, get the message
1179: FND_MSG_PUB.Count_And_Get (
1180: p_encoded => FND_API.G_FALSE,
1181: p_count => x_msg_count,
1182: p_data => x_msg_data
1183: );

Line 1200: FND_MSG_PUB.initialize;

1196: BEGIN
1197: -- Initialize message list if p_init_msg_list is set to TRUE.
1198: IF FND_API.to_Boolean( p_init_msg_list )
1199: THEN
1200: FND_MSG_PUB.initialize;
1201: END IF;
1202:
1203: -- Initialize API return status to SUCCESS
1204: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1217: FND_MSG_PUB.Count_And_Get

1213:
1214: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1215: END IF;
1216: -- Standard call to get message count and if count is 1, get message info.
1217: FND_MSG_PUB.Count_And_Get
1218: (p_count => x_msg_count,
1219: p_data => x_msg_data
1220: );
1221: END Validate_st_assoc_Rec;