22:
23: --
24: -- Foreward Procedure Declarations
25: --
26: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
27: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
28: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
29:
30: PROCEDURE Default_Imp_Attribute_Items (
23: --
24: -- Foreward Procedure Declarations
25: --
26: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
27: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
28: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
29:
30: PROCEDURE Default_Imp_Attribute_Items (
31: p_imp_attribute_rec IN imp_attribute_rec_type ,
24: -- Foreward Procedure Declarations
25: --
26: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
27: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
28: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
29:
30: PROCEDURE Default_Imp_Attribute_Items (
31: p_imp_attribute_rec IN imp_attribute_rec_type ,
32: x_imp_attribute_rec OUT NOCOPY imp_attribute_rec_type
104:
105: -- Initialize message list if p_init_msg_list is set to TRUE.
106: IF FND_API.to_Boolean( p_init_msg_list )
107: THEN
108: FND_MSG_PUB.initialize;
109: END IF;
110:
111: -- Debug Message
112: IF (AMS_DEBUG_HIGH_ON) THEN
195: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
196: END IF;
197:
198: -- Standard call to get message count and if count is 1, get message info.
199: FND_MSG_PUB.Count_And_Get
200: (p_count => x_msg_count,
201: p_data => x_msg_data
202: );
203: EXCEPTION
209: WHEN FND_API.G_EXC_ERROR THEN
210: ROLLBACK TO CREATE_Dm_Imp_Attribute_PVT;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: -- Standard call to get message count and if count=1, get the message
213: FND_MSG_PUB.Count_And_Get (
214: p_encoded => FND_API.G_FALSE,
215: p_count => x_msg_count,
216: p_data => x_msg_data
217: );
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: ROLLBACK TO CREATE_Dm_Imp_Attribute_PVT;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: -- Standard call to get message count and if count=1, get the message
223: FND_MSG_PUB.Count_And_Get (
224: p_encoded => FND_API.G_FALSE,
225: p_count => x_msg_count,
226: p_data => x_msg_data
227: );
228:
229: WHEN OTHERS THEN
230: ROLLBACK TO CREATE_Dm_Imp_Attribute_PVT;
231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
232: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
233: THEN
234: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
235: END IF;
236: -- Standard call to get message count and if count=1, get the message
230: ROLLBACK TO CREATE_Dm_Imp_Attribute_PVT;
231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
232: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
233: THEN
234: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
235: END IF;
236: -- Standard call to get message count and if count=1, get the message
237: FND_MSG_PUB.Count_And_Get (
238: p_encoded => FND_API.G_FALSE,
233: THEN
234: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
235: END IF;
236: -- Standard call to get message count and if count=1, get the message
237: FND_MSG_PUB.Count_And_Get (
238: p_encoded => FND_API.G_FALSE,
239: p_count => x_msg_count,
240: p_data => x_msg_data
241: );
319:
320:
321: -- Initialize message list if p_init_msg_list is set to TRUE.
322: IF FND_API.to_Boolean( p_init_msg_list ) THEN
323: FND_MSG_PUB.initialize;
324: END IF;
325:
326: -- Debug Message
327: IF (AMS_DEBUG_HIGH_ON) THEN
427: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
428: END IF;
429:
430: -- Standard call to get message count and if count is 1, get message info.
431: FND_MSG_PUB.Count_And_Get
432: (p_count => x_msg_count,
433: p_data => x_msg_data
434: );
435: EXCEPTION
441: WHEN FND_API.G_EXC_ERROR THEN
442: ROLLBACK TO UPDATE_Dm_Imp_Attribute_PVT;
443: x_return_status := FND_API.G_RET_STS_ERROR;
444: -- Standard call to get message count and if count=1, get the message
445: FND_MSG_PUB.Count_And_Get (
446: p_encoded => FND_API.G_FALSE,
447: p_count => x_msg_count,
448: p_data => x_msg_data
449: );
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: ROLLBACK TO UPDATE_Dm_Imp_Attribute_PVT;
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454: -- Standard call to get message count and if count=1, get the message
455: FND_MSG_PUB.Count_And_Get (
456: p_encoded => FND_API.G_FALSE,
457: p_count => x_msg_count,
458: p_data => x_msg_data
459: );
460:
461: WHEN OTHERS THEN
462: ROLLBACK TO UPDATE_Dm_Imp_Attribute_PVT;
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
465: THEN
466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
467: END IF;
468: -- Standard call to get message count and if count=1, get the message
462: ROLLBACK TO UPDATE_Dm_Imp_Attribute_PVT;
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
465: THEN
466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
467: END IF;
468: -- Standard call to get message count and if count=1, get the message
469: FND_MSG_PUB.Count_And_Get (
470: p_encoded => FND_API.G_FALSE,
465: THEN
466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
467: END IF;
468: -- Standard call to get message count and if count=1, get the message
469: FND_MSG_PUB.Count_And_Get (
470: p_encoded => FND_API.G_FALSE,
471: p_count => x_msg_count,
472: p_data => x_msg_data
473: );
539:
540: -- Initialize message list if p_init_msg_list is set to TRUE.
541: IF FND_API.to_Boolean( p_init_msg_list )
542: THEN
543: FND_MSG_PUB.initialize;
544: END IF;
545:
546:
547:
587: END IF;
588:
589:
590: -- Standard call to get message count and if count is 1, get message info.
591: FND_MSG_PUB.Count_And_Get
592: (p_count => x_msg_count,
593: p_data => x_msg_data
594: );
595: EXCEPTION
601: WHEN FND_API.G_EXC_ERROR THEN
602: ROLLBACK TO DELETE_Dm_Imp_Attribute_PVT;
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: -- Standard call to get message count and if count=1, get the message
605: FND_MSG_PUB.Count_And_Get (
606: p_encoded => FND_API.G_FALSE,
607: p_count => x_msg_count,
608: p_data => x_msg_data
609: );
611: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
612: ROLLBACK TO DELETE_Dm_Imp_Attribute_PVT;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
614: -- Standard call to get message count and if count=1, get the message
615: FND_MSG_PUB.Count_And_Get (
616: p_encoded => FND_API.G_FALSE,
617: p_count => x_msg_count,
618: p_data => x_msg_data
619: );
620:
621: WHEN OTHERS THEN
622: ROLLBACK TO DELETE_Dm_Imp_Attribute_PVT;
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
625: THEN
626: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
627: END IF;
628: -- Standard call to get message count and if count=1, get the message
622: ROLLBACK TO DELETE_Dm_Imp_Attribute_PVT;
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
625: THEN
626: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
627: END IF;
628: -- Standard call to get message count and if count=1, get the message
629: FND_MSG_PUB.Count_And_Get (
630: p_encoded => FND_API.G_FALSE,
625: THEN
626: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
627: END IF;
628: -- Standard call to get message count and if count=1, get the message
629: FND_MSG_PUB.Count_And_Get (
630: p_encoded => FND_API.G_FALSE,
631: p_count => x_msg_count,
632: p_data => x_msg_data
633: );
702:
703: -- Initialize message list if p_init_msg_list is set to TRUE.
704: IF FND_API.to_Boolean( p_init_msg_list )
705: THEN
706: FND_MSG_PUB.initialize;
707: END IF;
708:
709: -- Standard call to check for call compatibility.
710: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
736: END IF;
737: CLOSE c_imp_attribute;
738:
739: -------------------- finish --------------------------
740: FND_MSG_PUB.count_and_get(
741: p_encoded => FND_API.g_false,
742: p_count => x_msg_count,
743: p_data => x_msg_data);
744: IF (AMS_DEBUG_HIGH_ON) THEN
754: WHEN FND_API.G_EXC_ERROR THEN
755: ROLLBACK TO LOCK_Dm_Imp_Attribute_PVT;
756: x_return_status := FND_API.G_RET_STS_ERROR;
757: -- Standard call to get message count and if count=1, get the message
758: FND_MSG_PUB.Count_And_Get (
759: p_encoded => FND_API.G_FALSE,
760: p_count => x_msg_count,
761: p_data => x_msg_data
762: );
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: ROLLBACK TO LOCK_Dm_Imp_Attribute_PVT;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: -- Standard call to get message count and if count=1, get the message
768: FND_MSG_PUB.Count_And_Get (
769: p_encoded => FND_API.G_FALSE,
770: p_count => x_msg_count,
771: p_data => x_msg_data
772: );
773:
774: WHEN OTHERS THEN
775: ROLLBACK TO LOCK_Dm_Imp_Attribute_PVT;
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
778: THEN
779: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
780: END IF;
781: -- Standard call to get message count and if count=1, get the message
775: ROLLBACK TO LOCK_Dm_Imp_Attribute_PVT;
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
778: THEN
779: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
780: END IF;
781: -- Standard call to get message count and if count=1, get the message
782: FND_MSG_PUB.Count_And_Get (
783: p_encoded => FND_API.G_FALSE,
778: THEN
779: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
780: END IF;
781: -- Standard call to get message count and if count=1, get the message
782: FND_MSG_PUB.Count_And_Get (
783: p_encoded => FND_API.G_FALSE,
784: p_count => x_msg_count,
785: p_data => x_msg_data
786: );
1146:
1147: -- Initialize message list if p_init_msg_list is set to TRUE.
1148: IF FND_API.to_Boolean( p_init_msg_list )
1149: THEN
1150: FND_MSG_PUB.initialize;
1151: END IF;
1152:
1153:
1154: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1200: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1201: END IF;
1202:
1203: -- Standard call to get message count and if count is 1, get message info.
1204: FND_MSG_PUB.Count_And_Get
1205: (p_count => x_msg_count,
1206: p_data => x_msg_data
1207: );
1208: EXCEPTION
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: ROLLBACK TO VALIDATE_Dm_Imp_Attribute_;
1216: x_return_status := FND_API.G_RET_STS_ERROR;
1217: -- Standard call to get message count and if count=1, get the message
1218: FND_MSG_PUB.Count_And_Get (
1219: p_encoded => FND_API.G_FALSE,
1220: p_count => x_msg_count,
1221: p_data => x_msg_data
1222: );
1224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1225: ROLLBACK TO VALIDATE_Dm_Imp_Attribute_;
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1227: -- Standard call to get message count and if count=1, get the message
1228: FND_MSG_PUB.Count_And_Get (
1229: p_encoded => FND_API.G_FALSE,
1230: p_count => x_msg_count,
1231: p_data => x_msg_data
1232: );
1233:
1234: WHEN OTHERS THEN
1235: ROLLBACK TO VALIDATE_Dm_Imp_Attribute_;
1236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1237: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1238: THEN
1239: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1240: END IF;
1241: -- Standard call to get message count and if count=1, get the message
1235: ROLLBACK TO VALIDATE_Dm_Imp_Attribute_;
1236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1237: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1238: THEN
1239: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1240: END IF;
1241: -- Standard call to get message count and if count=1, get the message
1242: FND_MSG_PUB.Count_And_Get (
1243: p_encoded => FND_API.G_FALSE,
1238: THEN
1239: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1240: END IF;
1241: -- Standard call to get message count and if count=1, get the message
1242: FND_MSG_PUB.Count_And_Get (
1243: p_encoded => FND_API.G_FALSE,
1244: p_count => x_msg_count,
1245: p_data => x_msg_data
1246: );
1259: BEGIN
1260: -- Initialize message list if p_init_msg_list is set to TRUE.
1261: IF FND_API.to_Boolean( p_init_msg_list )
1262: THEN
1263: FND_MSG_PUB.initialize;
1264: END IF;
1265:
1266: -- Initialize API return status to SUCCESS
1267: x_return_status := FND_API.G_RET_STS_SUCCESS;