eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_PROD_TEMPLATE_PVT dependencies on FND_MSG_PUB

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

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

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

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

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

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

Line 100: FND_MSG_PUB.initialize;

96:
97: -- Initialize message list if p_init_msg_list is set to TRUE.
98: IF FND_API.to_Boolean( p_init_msg_list )
99: THEN
100: FND_MSG_PUB.initialize;
101: END IF;
102:
103: -- Debug Message
104: IF (AMS_DEBUG_HIGH_ON) THEN

Line 346: FND_MSG_PUB.Count_And_Get

342: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
343: END IF;
344:
345: -- Standard call to get message count and if count is 1, get message info.
346: FND_MSG_PUB.Count_And_Get
347: (p_count => x_msg_count,
348: p_data => x_msg_data
349: );
350: EXCEPTION

Line 360: FND_MSG_PUB.Count_And_Get (

356: WHEN FND_API.G_EXC_ERROR THEN
357: ROLLBACK TO CREATE_Prod_Template_PVT;
358: x_return_status := FND_API.G_RET_STS_ERROR;
359: -- Standard call to get message count and if count=1, get the message
360: FND_MSG_PUB.Count_And_Get (
361: p_encoded => FND_API.G_FALSE,
362: p_count => x_msg_count,
363: p_data => x_msg_data
364: );

Line 370: FND_MSG_PUB.Count_And_Get (

366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
367: ROLLBACK TO CREATE_Prod_Template_PVT;
368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
369: -- Standard call to get message count and if count=1, get the message
370: FND_MSG_PUB.Count_And_Get (
371: p_encoded => FND_API.G_FALSE,
372: p_count => x_msg_count,
373: p_data => x_msg_data
374: );

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

375:
376: WHEN OTHERS THEN
377: ROLLBACK TO CREATE_Prod_Template_PVT;
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
380: THEN
381: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
382: END IF;
383: -- Standard call to get message count and if count=1, get the message

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

377: ROLLBACK TO CREATE_Prod_Template_PVT;
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
380: THEN
381: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
382: END IF;
383: -- Standard call to get message count and if count=1, get the message
384: FND_MSG_PUB.Count_And_Get (
385: p_encoded => FND_API.G_FALSE,

Line 384: FND_MSG_PUB.Count_And_Get (

380: THEN
381: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
382: END IF;
383: -- Standard call to get message count and if count=1, get the message
384: FND_MSG_PUB.Count_And_Get (
385: p_encoded => FND_API.G_FALSE,
386: p_count => x_msg_count,
387: p_data => x_msg_data
388: );

Line 438: FND_MSG_PUB.initialize;

434:
435: -- Initialize message list if p_init_msg_list is set to TRUE.
436: IF FND_API.to_Boolean( p_init_msg_list )
437: THEN
438: FND_MSG_PUB.initialize;
439: END IF;
440:
441: -- Debug Message
442: IF (AMS_DEBUG_HIGH_ON) THEN

Line 559: FND_MSG_PUB.Count_And_Get

555: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
556: END IF;
557:
558: -- Standard call to get message count and if count is 1, get message info.
559: FND_MSG_PUB.Count_And_Get
560: (p_count => x_msg_count,
561: p_data => x_msg_data
562: );
563: EXCEPTION

Line 573: FND_MSG_PUB.Count_And_Get (

569: WHEN FND_API.G_EXC_ERROR THEN
570: ROLLBACK TO UPDATE_Prod_Template_PVT;
571: x_return_status := FND_API.G_RET_STS_ERROR;
572: -- Standard call to get message count and if count=1, get the message
573: FND_MSG_PUB.Count_And_Get (
574: p_encoded => FND_API.G_FALSE,
575: p_count => x_msg_count,
576: p_data => x_msg_data
577: );

Line 583: FND_MSG_PUB.Count_And_Get (

579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
580: ROLLBACK TO UPDATE_Prod_Template_PVT;
581: x_return_status := FND_API.G_RET_STS_UNEXP_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 592: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

588:
589: WHEN OTHERS THEN
590: ROLLBACK TO UPDATE_Prod_Template_PVT;
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
593: THEN
594: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
595: END IF;
596: -- Standard call to get message count and if count=1, get the message

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

590: ROLLBACK TO UPDATE_Prod_Template_PVT;
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
593: THEN
594: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
595: END IF;
596: -- Standard call to get message count and if count=1, get the message
597: FND_MSG_PUB.Count_And_Get (
598: p_encoded => FND_API.G_FALSE,

Line 597: FND_MSG_PUB.Count_And_Get (

593: THEN
594: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
595: END IF;
596: -- Standard call to get message count and if count=1, get the message
597: FND_MSG_PUB.Count_And_Get (
598: p_encoded => FND_API.G_FALSE,
599: p_count => x_msg_count,
600: p_data => x_msg_data
601: );

Line 638: FND_MSG_PUB.initialize;

634:
635: -- Initialize message list if p_init_msg_list is set to TRUE.
636: IF FND_API.to_Boolean( p_init_msg_list )
637: THEN
638: FND_MSG_PUB.initialize;
639: END IF;
640:
641: -- Debug Message
642: IF (AMS_DEBUG_HIGH_ON) THEN

Line 665: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

661: THEN
662: */
663: IF p_template_id < 10000
664: THEN
665: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
666: THEN
667: FND_MESSAGE.set_name('AMS', 'AMS_API_CANNOT_DELETE');
668: FND_MSG_PUB.add;
669: END IF;

Line 668: FND_MSG_PUB.add;

664: THEN
665: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
666: THEN
667: FND_MESSAGE.set_name('AMS', 'AMS_API_CANNOT_DELETE');
668: FND_MSG_PUB.add;
669: END IF;
670: RAISE FND_API.g_exc_error;
671: END IF;
672:

Line 678: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

674: WHERE TEMPLATE_ID = p_TEMPLATE_ID
675: AND object_version_number = p_object_version_number;
676:
677: IF (SQL%NOTFOUND) THEN
678: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
679: THEN
680: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
681: FND_MSG_PUB.add;
682: END IF;

Line 681: FND_MSG_PUB.add;

677: IF (SQL%NOTFOUND) THEN
678: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
679: THEN
680: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
681: FND_MSG_PUB.add;
682: END IF;
683: RAISE FND_API.g_exc_error;
684: END IF;
685:

Line 690: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

686: DELETE FROM AMS_PROD_TEMPLATES_TL
687: WHERE TEMPLATE_ID = p_TEMPLATE_ID;
688:
689: IF (SQL%NOTFOUND) THEN
690: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
691: THEN
692: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
693: FND_MSG_PUB.add;
694: END IF;

Line 693: FND_MSG_PUB.add;

689: IF (SQL%NOTFOUND) THEN
690: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
691: THEN
692: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
693: FND_MSG_PUB.add;
694: END IF;
695: RAISE FND_API.g_exc_error;
696: END IF;
697:

Line 722: FND_MSG_PUB.Count_And_Get

718: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
719: END IF;
720:
721: -- Standard call to get message count and if count is 1, get message info.
722: FND_MSG_PUB.Count_And_Get
723: (p_count => x_msg_count,
724: p_data => x_msg_data
725: );
726: EXCEPTION

Line 736: FND_MSG_PUB.Count_And_Get (

732: WHEN FND_API.G_EXC_ERROR THEN
733: ROLLBACK TO DELETE_Prod_Template_PVT;
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: -- Standard call to get message count and if count=1, get the message
736: FND_MSG_PUB.Count_And_Get (
737: p_encoded => FND_API.G_FALSE,
738: p_count => x_msg_count,
739: p_data => x_msg_data
740: );

Line 746: FND_MSG_PUB.Count_And_Get (

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

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

751:
752: WHEN OTHERS THEN
753: ROLLBACK TO DELETE_Prod_Template_PVT;
754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
755: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
756: THEN
757: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
758: END IF;
759: -- Standard call to get message count and if count=1, get the message

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

753: ROLLBACK TO DELETE_Prod_Template_PVT;
754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
755: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
756: THEN
757: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
758: END IF;
759: -- Standard call to get message count and if count=1, get the message
760: FND_MSG_PUB.Count_And_Get (
761: p_encoded => FND_API.G_FALSE,

Line 760: FND_MSG_PUB.Count_And_Get (

756: THEN
757: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
758: END IF;
759: -- Standard call to get message count and if count=1, get the message
760: FND_MSG_PUB.Count_And_Get (
761: p_encoded => FND_API.G_FALSE,
762: p_count => x_msg_count,
763: p_data => x_msg_data
764: );

Line 806: FND_MSG_PUB.initialize;

802:
803: -- Initialize message list if p_init_msg_list is set to TRUE.
804: IF FND_API.to_Boolean( p_init_msg_list )
805: THEN
806: FND_MSG_PUB.initialize;
807: END IF;
808:
809: -- Standard call to check for call compatibility.
810: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

834: FETCH c_Prod_Template INTO l_TEMPLATE_ID;
835:
836: IF (c_Prod_Template%NOTFOUND) THEN
837: CLOSE c_Prod_Template;
838: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
839: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
840: FND_MSG_PUB.add;
841: END IF;
842: RAISE FND_API.g_exc_error;

Line 840: FND_MSG_PUB.add;

836: IF (c_Prod_Template%NOTFOUND) THEN
837: CLOSE c_Prod_Template;
838: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
839: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
840: FND_MSG_PUB.add;
841: END IF;
842: RAISE FND_API.g_exc_error;
843: END IF;
844:

Line 848: FND_MSG_PUB.count_and_get(

844:
845: CLOSE c_Prod_Template;
846:
847: -------------------- finish --------------------------
848: FND_MSG_PUB.count_and_get(
849: p_encoded => FND_API.g_false,
850: p_count => x_msg_count,
851: p_data => x_msg_data);
852: IF (AMS_DEBUG_HIGH_ON) THEN

Line 866: FND_MSG_PUB.Count_And_Get (

862: WHEN FND_API.G_EXC_ERROR THEN
863: ROLLBACK TO LOCK_Prod_Template_PVT;
864: x_return_status := FND_API.G_RET_STS_ERROR;
865: -- Standard call to get message count and if count=1, get the message
866: FND_MSG_PUB.Count_And_Get (
867: p_encoded => FND_API.G_FALSE,
868: p_count => x_msg_count,
869: p_data => x_msg_data
870: );

Line 876: FND_MSG_PUB.Count_And_Get (

872: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
873: ROLLBACK TO LOCK_Prod_Template_PVT;
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
875: -- Standard call to get message count and if count=1, get the message
876: FND_MSG_PUB.Count_And_Get (
877: p_encoded => FND_API.G_FALSE,
878: p_count => x_msg_count,
879: p_data => x_msg_data
880: );

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

881:
882: WHEN OTHERS THEN
883: ROLLBACK TO LOCK_Prod_Template_PVT;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
886: THEN
887: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
888: END IF;
889: -- Standard call to get message count and if count=1, get the message

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

883: ROLLBACK TO LOCK_Prod_Template_PVT;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
886: THEN
887: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
888: END IF;
889: -- Standard call to get message count and if count=1, get the message
890: FND_MSG_PUB.Count_And_Get (
891: p_encoded => FND_API.G_FALSE,

Line 890: FND_MSG_PUB.Count_And_Get (

886: THEN
887: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
888: END IF;
889: -- Standard call to get message count and if count=1, get the message
890: FND_MSG_PUB.Count_And_Get (
891: p_encoded => FND_API.G_FALSE,
892: p_count => x_msg_count,
893: p_data => x_msg_data
894: );

Line 971: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

967: END IF;
968:
969: IF l_valid_flag = 'Y'
970: THEN
971: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
972: THEN
973: FND_MESSAGE.set_name('AMS','AMS_dup_name');
974: FND_MSG_PUB.add;
975: END IF;

Line 974: FND_MSG_PUB.add;

970: THEN
971: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
972: THEN
973: FND_MESSAGE.set_name('AMS','AMS_dup_name');
974: FND_MSG_PUB.add;
975: END IF;
976: x_return_status := FND_API.g_ret_sts_error;
977: RETURN;
978: END IF;

Line 1187: FND_MSG_PUB.initialize;

1183:
1184: -- Initialize message list if p_init_msg_list is set to TRUE.
1185: IF FND_API.to_Boolean( p_init_msg_list )
1186: THEN
1187: FND_MSG_PUB.initialize;
1188: END IF;
1189: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1190: Check_prod_template_Items(
1191: p_prod_template_rec => p_prod_template_rec,

Line 1243: FND_MSG_PUB.Count_And_Get

1239: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1240: END IF;
1241:
1242: -- Standard call to get message count and if count is 1, get message info.
1243: FND_MSG_PUB.Count_And_Get
1244: (p_count => x_msg_count,
1245: p_data => x_msg_data
1246: );
1247: EXCEPTION

Line 1257: FND_MSG_PUB.Count_And_Get (

1253: WHEN FND_API.G_EXC_ERROR THEN
1254: ROLLBACK TO VALIDATE_Prod_Template_;
1255: x_return_status := FND_API.G_RET_STS_ERROR;
1256: -- Standard call to get message count and if count=1, get the message
1257: FND_MSG_PUB.Count_And_Get (
1258: p_encoded => FND_API.G_FALSE,
1259: p_count => x_msg_count,
1260: p_data => x_msg_data
1261: );

Line 1267: FND_MSG_PUB.Count_And_Get (

1263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1264: ROLLBACK TO VALIDATE_Prod_Template_;
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266: -- Standard call to get message count and if count=1, get the message
1267: FND_MSG_PUB.Count_And_Get (
1268: p_encoded => FND_API.G_FALSE,
1269: p_count => x_msg_count,
1270: p_data => x_msg_data
1271: );

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

1272:
1273: WHEN OTHERS THEN
1274: ROLLBACK TO VALIDATE_Prod_Template_;
1275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1276: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1277: THEN
1278: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1279: END IF;
1280: -- Standard call to get message count and if count=1, get the message

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

1274: ROLLBACK TO VALIDATE_Prod_Template_;
1275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1276: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1277: THEN
1278: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1279: END IF;
1280: -- Standard call to get message count and if count=1, get the message
1281: FND_MSG_PUB.Count_And_Get (
1282: p_encoded => FND_API.G_FALSE,

Line 1281: FND_MSG_PUB.Count_And_Get (

1277: THEN
1278: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1279: END IF;
1280: -- Standard call to get message count and if count=1, get the message
1281: FND_MSG_PUB.Count_And_Get (
1282: p_encoded => FND_API.G_FALSE,
1283: p_count => x_msg_count,
1284: p_data => x_msg_data
1285: );

Line 1302: FND_MSG_PUB.initialize;

1298: BEGIN
1299: -- Initialize message list if p_init_msg_list is set to TRUE.
1300: IF FND_API.to_Boolean( p_init_msg_list )
1301: THEN
1302: FND_MSG_PUB.initialize;
1303: END IF;
1304:
1305: -- Initialize API return status to SUCCESS
1306: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1319: FND_MSG_PUB.Count_And_Get

1315:
1316: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1317: END IF;
1318: -- Standard call to get message count and if count is 1, get message info.
1319: FND_MSG_PUB.Count_And_Get
1320: (p_count => x_msg_count,
1321: p_data => x_msg_data
1322: );
1323: END Validate_prod_template_Rec;