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_TEMPLATE_ATTR_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) := 'amsvpatb.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_Template_Attr(

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_Template_Attr(
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_Template_Attr(
27: p_api_version_number IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 74: FND_MSG_PUB.initialize;

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

Line 190: FND_MSG_PUB.Count_And_Get

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

Line 204: FND_MSG_PUB.Count_And_Get (

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

Line 214: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 228: FND_MSG_PUB.Count_And_Get (

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

Line 284: FND_MSG_PUB.initialize;

280:
281: -- Initialize message list if p_init_msg_list is set to TRUE.
282: IF FND_API.to_Boolean( p_init_msg_list )
283: THEN
284: FND_MSG_PUB.initialize;
285: END IF;
286:
287: -- Debug Message
288: IF (AMS_DEBUG_HIGH_ON) THEN

Line 461: FND_MSG_PUB.Count_And_Get

457: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
458: END IF;
459:
460: -- Standard call to get message count and if count is 1, get message info.
461: FND_MSG_PUB.Count_And_Get
462: (p_count => x_msg_count,
463: p_data => x_msg_data
464: );
465: EXCEPTION

Line 475: FND_MSG_PUB.Count_And_Get (

471: WHEN FND_API.G_EXC_ERROR THEN
472: ROLLBACK TO UPDATE_Template_Attr_PVT;
473: x_return_status := FND_API.G_RET_STS_ERROR;
474: -- Standard call to get message count and if count=1, get the message
475: FND_MSG_PUB.Count_And_Get (
476: p_encoded => FND_API.G_FALSE,
477: p_count => x_msg_count,
478: p_data => x_msg_data
479: );

Line 485: FND_MSG_PUB.Count_And_Get (

481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
482: ROLLBACK TO UPDATE_Template_Attr_PVT;
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: -- Standard call to get message count and if count=1, get the message
485: FND_MSG_PUB.Count_And_Get (
486: p_encoded => FND_API.G_FALSE,
487: p_count => x_msg_count,
488: p_data => x_msg_data
489: );

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

490:
491: WHEN OTHERS THEN
492: ROLLBACK TO UPDATE_Template_Attr_PVT;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
494: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
497: END IF;
498: -- Standard call to get message count and if count=1, get the message

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

492: ROLLBACK TO UPDATE_Template_Attr_PVT;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
494: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
497: END IF;
498: -- Standard call to get message count and if count=1, get the message
499: FND_MSG_PUB.Count_And_Get (
500: p_encoded => FND_API.G_FALSE,

Line 499: FND_MSG_PUB.Count_And_Get (

495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
497: END IF;
498: -- Standard call to get message count and if count=1, get the message
499: FND_MSG_PUB.Count_And_Get (
500: p_encoded => FND_API.G_FALSE,
501: p_count => x_msg_count,
502: p_data => x_msg_data
503: );

Line 540: FND_MSG_PUB.initialize;

536:
537: -- Initialize message list if p_init_msg_list is set to TRUE.
538: IF FND_API.to_Boolean( p_init_msg_list )
539: THEN
540: FND_MSG_PUB.initialize;
541: END IF;
542:
543: -- Debug Message
544: IF (AMS_DEBUG_HIGH_ON) THEN

Line 575: FND_MSG_PUB.Count_And_Get

571: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
572: END IF;
573:
574: -- Standard call to get message count and if count is 1, get message info.
575: FND_MSG_PUB.Count_And_Get
576: (p_count => x_msg_count,
577: p_data => x_msg_data
578: );
579: EXCEPTION

Line 589: FND_MSG_PUB.Count_And_Get (

585: WHEN FND_API.G_EXC_ERROR THEN
586: ROLLBACK TO DELETE_Template_Attr_PVT;
587: x_return_status := FND_API.G_RET_STS_ERROR;
588: -- Standard call to get message count and if count=1, get the message
589: FND_MSG_PUB.Count_And_Get (
590: p_encoded => FND_API.G_FALSE,
591: p_count => x_msg_count,
592: p_data => x_msg_data
593: );

Line 599: FND_MSG_PUB.Count_And_Get (

595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596: ROLLBACK TO DELETE_Template_Attr_PVT;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: -- Standard call to get message count and if count=1, get the message
599: FND_MSG_PUB.Count_And_Get (
600: p_encoded => FND_API.G_FALSE,
601: p_count => x_msg_count,
602: p_data => x_msg_data
603: );

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

604:
605: WHEN OTHERS THEN
606: ROLLBACK TO DELETE_Template_Attr_PVT;
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
609: THEN
610: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
611: END IF;
612: -- Standard call to get message count and if count=1, get the message

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

606: ROLLBACK TO DELETE_Template_Attr_PVT;
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
609: THEN
610: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
611: END IF;
612: -- Standard call to get message count and if count=1, get the message
613: FND_MSG_PUB.Count_And_Get (
614: p_encoded => FND_API.G_FALSE,

Line 613: FND_MSG_PUB.Count_And_Get (

609: THEN
610: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
611: END IF;
612: -- Standard call to get message count and if count=1, get the message
613: FND_MSG_PUB.Count_And_Get (
614: p_encoded => FND_API.G_FALSE,
615: p_count => x_msg_count,
616: p_data => x_msg_data
617: );

Line 659: FND_MSG_PUB.initialize;

655:
656: -- Initialize message list if p_init_msg_list is set to TRUE.
657: IF FND_API.to_Boolean( p_init_msg_list )
658: THEN
659: FND_MSG_PUB.initialize;
660: END IF;
661:
662: -- Standard call to check for call compatibility.
663: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

687: FETCH c_Template_Attr INTO l_TEMPLATE_ATTRIBUTE_ID;
688:
689: IF (c_Template_Attr%NOTFOUND) THEN
690: CLOSE c_Template_Attr;
691: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) 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;

Line 693: FND_MSG_PUB.add;

689: IF (c_Template_Attr%NOTFOUND) THEN
690: CLOSE c_Template_Attr;
691: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) 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 701: FND_MSG_PUB.count_and_get(

697:
698: CLOSE c_Template_Attr;
699:
700: -------------------- finish --------------------------
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: IF (AMS_DEBUG_HIGH_ON) THEN

Line 719: FND_MSG_PUB.Count_And_Get (

715: WHEN FND_API.G_EXC_ERROR THEN
716: ROLLBACK TO LOCK_Template_Attr_PVT;
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: -- Standard call to get message count and if count=1, get the message
719: FND_MSG_PUB.Count_And_Get (
720: p_encoded => FND_API.G_FALSE,
721: p_count => x_msg_count,
722: p_data => x_msg_data
723: );

Line 729: FND_MSG_PUB.Count_And_Get (

725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
726: ROLLBACK TO LOCK_Template_Attr_PVT;
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
728: -- Standard call to get message count and if count=1, get the message
729: FND_MSG_PUB.Count_And_Get (
730: p_encoded => FND_API.G_FALSE,
731: p_count => x_msg_count,
732: p_data => x_msg_data
733: );

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

734:
735: WHEN OTHERS THEN
736: ROLLBACK TO LOCK_Template_Attr_PVT;
737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
738: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
739: THEN
740: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
741: END IF;
742: -- Standard call to get message count and if count=1, get the message

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

736: ROLLBACK TO LOCK_Template_Attr_PVT;
737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
738: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
739: THEN
740: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
741: END IF;
742: -- Standard call to get message count and if count=1, get the message
743: FND_MSG_PUB.Count_And_Get (
744: p_encoded => FND_API.G_FALSE,

Line 743: FND_MSG_PUB.Count_And_Get (

739: THEN
740: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
741: END IF;
742: -- Standard call to get message count and if count=1, get the message
743: FND_MSG_PUB.Count_And_Get (
744: p_encoded => FND_API.G_FALSE,
745: p_count => x_msg_count,
746: p_data => x_msg_data
747: );

Line 818: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

814: IF (p_template_attr_rec.parent_select_all = 'Y'
815: AND(( p_template_attr_rec.editable_flag = 'N')
816: OR (p_template_attr_rec.default_flag = 'N')))
817: THEN
818: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
819: THEN
820: FND_MESSAGE.Set_Name('AMS', 'AMS_EDIT_SELECT_DEF_ERROR');
821: FND_MSG_PUB.Add;
822: END IF;

Line 821: FND_MSG_PUB.Add;

817: THEN
818: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
819: THEN
820: FND_MESSAGE.Set_Name('AMS', 'AMS_EDIT_SELECT_DEF_ERROR');
821: FND_MSG_PUB.Add;
822: END IF;
823:
824: x_return_status := FND_API.g_ret_sts_error;
825: RETURN;

Line 1045: FND_MSG_PUB.initialize;

1041:
1042: -- Initialize message list if p_init_msg_list is set to TRUE.
1043: IF FND_API.to_Boolean( p_init_msg_list )
1044: THEN
1045: FND_MSG_PUB.initialize;
1046: END IF;
1047: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1048: Check_template_attr_Items(
1049: p_template_attr_rec => p_template_attr_rec,

Line 1090: FND_MSG_PUB.Count_And_Get

1086: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end and the return status is '||x_return_status);
1087: END IF;
1088:
1089: -- Standard call to get message count and if count is 1, get message info.
1090: FND_MSG_PUB.Count_And_Get
1091: (p_count => x_msg_count,
1092: p_data => x_msg_data
1093: );
1094: EXCEPTION

Line 1104: FND_MSG_PUB.Count_And_Get (

1100: WHEN FND_API.G_EXC_ERROR THEN
1101: ROLLBACK TO VALIDATE_Template_Attr_;
1102: x_return_status := FND_API.G_RET_STS_ERROR;
1103: -- Standard call to get message count and if count=1, get the message
1104: FND_MSG_PUB.Count_And_Get (
1105: p_encoded => FND_API.G_FALSE,
1106: p_count => x_msg_count,
1107: p_data => x_msg_data
1108: );

Line 1114: FND_MSG_PUB.Count_And_Get (

1110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1111: ROLLBACK TO VALIDATE_Template_Attr_;
1112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1113: -- Standard call to get message count and if count=1, get the message
1114: FND_MSG_PUB.Count_And_Get (
1115: p_encoded => FND_API.G_FALSE,
1116: p_count => x_msg_count,
1117: p_data => x_msg_data
1118: );

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

1119:
1120: WHEN OTHERS THEN
1121: ROLLBACK TO VALIDATE_Template_Attr_;
1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1123: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1124: THEN
1125: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1126: END IF;
1127: -- Standard call to get message count and if count=1, get the message

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

1121: ROLLBACK TO VALIDATE_Template_Attr_;
1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1123: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1124: THEN
1125: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1126: END IF;
1127: -- Standard call to get message count and if count=1, get the message
1128: FND_MSG_PUB.Count_And_Get (
1129: p_encoded => FND_API.G_FALSE,

Line 1128: FND_MSG_PUB.Count_And_Get (

1124: THEN
1125: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1126: END IF;
1127: -- Standard call to get message count and if count=1, get the message
1128: FND_MSG_PUB.Count_And_Get (
1129: p_encoded => FND_API.G_FALSE,
1130: p_count => x_msg_count,
1131: p_data => x_msg_data
1132: );

Line 1149: FND_MSG_PUB.initialize;

1145: BEGIN
1146: -- Initialize message list if p_init_msg_list is set to TRUE.
1147: IF FND_API.to_Boolean( p_init_msg_list )
1148: THEN
1149: FND_MSG_PUB.initialize;
1150: END IF;
1151:
1152: -- Initialize API return status to SUCCESS
1153: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1166: FND_MSG_PUB.Count_And_Get

1162:
1163: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1164: END IF;
1165: -- Standard call to get message count and if count is 1, get message info.
1166: FND_MSG_PUB.Count_And_Get
1167: (p_count => x_msg_count,
1168: p_data => x_msg_data
1169: );
1170: END Validate_template_attr_Rec;