[Home] [Help]
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_Boolean( p_init_msg_list )
61: THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64:
65:
66: -- Debug Message
63: END IF;
64:
65:
66: -- Debug Message
67: --AS_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
68:
69:
70: -- Initialize API return status to SUCCESS
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
77: -- Validate Environment
78: -- ******************************************************************
79: IF FND_GLOBAL.User_Id IS NULL
80: THEN
81: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
82: THEN
83: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
84: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
85: FND_MSG_PUB.ADD;
81: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
82: THEN
83: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
84: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
85: FND_MSG_PUB.ADD;
86: END IF;
87: RAISE FND_API.G_EXC_ERROR;
88: END IF;
89:
109: END IF;
110:
111:
112: -- Standard call to get message count and if count is 1, get message info.
113: FND_MSG_PUB.Count_And_Get
114: ( p_count => x_msg_count,
115: p_data => x_msg_data
116: );
117:
120: WHEN FND_API.G_EXC_ERROR THEN
121: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
122: P_API_NAME => L_API_NAME
123: ,P_PKG_NAME => G_PKG_NAME
124: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
125: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
126: ,X_MSG_COUNT => X_MSG_COUNT
127: ,X_MSG_DATA => X_MSG_DATA
128: ,X_RETURN_STATUS => X_RETURN_STATUS);
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
131: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
132: P_API_NAME => L_API_NAME
133: ,P_PKG_NAME => G_PKG_NAME
134: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
135: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
136: ,X_MSG_COUNT => X_MSG_COUNT
137: ,X_MSG_DATA => X_MSG_DATA
138: ,X_RETURN_STATUS => X_RETURN_STATUS);
197:
198: -- Initialize message list if p_init_msg_list is set to TRUE.
199: IF FND_API.to_Boolean( p_init_msg_list )
200: THEN
201: FND_MSG_PUB.initialize;
202: END IF;
203:
204:
205:
214: -- Validate Environment
215: -- ******************************************************************
216: IF FND_GLOBAL.User_Id IS NULL
217: THEN
218: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
219: THEN
220: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
221: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
222: FND_MSG_PUB.ADD;
218: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
219: THEN
220: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
221: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
222: FND_MSG_PUB.ADD;
223: END IF;
224: RAISE FND_API.G_EXC_ERROR;
225: END IF;
226:
245: COMMIT WORK;
246: END IF;
247:
248: -- Standard call to get message count and if count is 1, get message info.
249: FND_MSG_PUB.Count_And_Get
250: ( p_count => x_msg_count,
251: p_data => x_msg_data
252: );
253:
256: WHEN FND_API.G_EXC_ERROR THEN
257: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
258: P_API_NAME => L_API_NAME
259: ,P_PKG_NAME => G_PKG_NAME
260: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
261: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
262: ,X_MSG_COUNT => X_MSG_COUNT
263: ,X_MSG_DATA => X_MSG_DATA
264: ,X_RETURN_STATUS => X_RETURN_STATUS);
266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
267: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
268: P_API_NAME => L_API_NAME
269: ,P_PKG_NAME => G_PKG_NAME
270: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
271: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
272: ,X_MSG_COUNT => X_MSG_COUNT
273: ,X_MSG_DATA => X_MSG_DATA
274: ,X_RETURN_STATUS => X_RETURN_STATUS);
334:
335: -- Initialize message list if p_init_msg_list is set to TRUE.
336: IF FND_API.to_Boolean( p_init_msg_list )
337: THEN
338: FND_MSG_PUB.initialize;
339: END IF;
340:
341:
342: -- Initialize API return status to SUCCESS
350: -- Validate Environment
351: -- ******************************************************************
352: IF FND_GLOBAL.User_Id IS NULL
353: THEN
354: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
355: THEN
356: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
357: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
358: FND_MSG_PUB.ADD;
354: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
355: THEN
356: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
357: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
358: FND_MSG_PUB.ADD;
359: END IF;
360: RAISE FND_API.G_EXC_ERROR;
361: END IF;
362:
383: END IF;
384:
385:
386: -- Standard call to get message count and if count is 1, get message info.
387: FND_MSG_PUB.Count_And_Get
388: ( p_count => x_msg_count,
389: p_data => x_msg_data
390: );
391:
394: WHEN FND_API.G_EXC_ERROR THEN
395: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
396: P_API_NAME => L_API_NAME
397: ,P_PKG_NAME => G_PKG_NAME
398: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
399: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
400: ,P_SQLCODE => SQLCODE
401: ,P_SQLERRM => SQLERRM
402: ,X_MSG_COUNT => X_MSG_COUNT
406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
407: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
408: P_API_NAME => L_API_NAME
409: ,P_PKG_NAME => G_PKG_NAME
410: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
411: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
412: ,P_SQLCODE => SQLCODE
413: ,P_SQLERRM => SQLERRM
414: ,X_MSG_COUNT => X_MSG_COUNT
476:
477: -- Initialize message list if p_init_msg_list is set to TRUE.
478: IF FND_API.to_Boolean( p_init_msg_list )
479: THEN
480: FND_MSG_PUB.initialize;
481: END IF;
482:
483: -- Initialize API return status to SUCCESS
484: x_return_status := FND_API.G_RET_STS_SUCCESS;
491: -- Validate Environment
492: -- ******************************************************************
493: IF FND_GLOBAL.User_Id IS NULL
494: THEN
495: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
496: THEN
497: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
498: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
499: FND_MSG_PUB.ADD;
495: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
496: THEN
497: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
498: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
499: FND_MSG_PUB.ADD;
500: END IF;
501: RAISE FND_API.G_EXC_ERROR;
502: END IF;
503:
522: THEN
523: COMMIT WORK;
524: END IF;
525:
526: FND_MSG_PUB.Count_And_Get
527: ( p_count => x_msg_count,
528: p_data => x_msg_data
529: );
530:
533: WHEN FND_API.G_EXC_ERROR THEN
534: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
535: P_API_NAME => L_API_NAME
536: ,P_PKG_NAME => G_PKG_NAME
537: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
538: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
539: ,P_SQLCODE => SQLCODE
540: ,P_SQLERRM => SQLERRM
541: ,X_MSG_COUNT => X_MSG_COUNT
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
547: P_API_NAME => L_API_NAME
548: ,P_PKG_NAME => G_PKG_NAME
549: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
550: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
551: ,P_SQLCODE => SQLCODE
552: ,P_SQLERRM => SQLERRM
553: ,X_MSG_COUNT => X_MSG_COUNT
614:
615: -- Initialize message list if p_init_msg_list is set to TRUE.
616: IF FND_API.to_Boolean( p_init_msg_list )
617: THEN
618: FND_MSG_PUB.initialize;
619: END IF;
620:
621:
622: -- Initialize API return status to SUCCESS
630: -- Validate Environment
631: -- ******************************************************************
632: IF FND_GLOBAL.User_Id IS NULL
633: THEN
634: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
635: THEN
636: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
637: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
638: FND_MSG_PUB.ADD;
634: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
635: THEN
636: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
637: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
638: FND_MSG_PUB.ADD;
639: END IF;
640: RAISE FND_API.G_EXC_ERROR;
641: END IF;
642:
664:
665:
666:
667: -- Standard call to get message count and if count is 1, get message info.
668: FND_MSG_PUB.Count_And_Get
669: ( p_count => x_msg_count,
670: p_data => x_msg_data
671: );
672:
674: WHEN FND_API.G_EXC_ERROR THEN
675: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
676: P_API_NAME => L_API_NAME
677: ,P_PKG_NAME => G_PKG_NAME
678: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
679: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
680: ,P_SQLCODE => SQLCODE
681: ,P_SQLERRM => SQLERRM
682: ,X_MSG_COUNT => X_MSG_COUNT
686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
687: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
688: P_API_NAME => L_API_NAME
689: ,P_PKG_NAME => G_PKG_NAME
690: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
691: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
692: ,P_SQLCODE => SQLCODE
693: ,P_SQLERRM => SQLERRM
694: ,X_MSG_COUNT => X_MSG_COUNT
757:
758: -- Initialize message list if p_init_msg_list is set to TRUE.
759: IF FND_API.to_Boolean( p_init_msg_list )
760: THEN
761: FND_MSG_PUB.initialize;
762: END IF;
763:
764:
765:
774: -- Validate Environment
775: -- ******************************************************************
776: IF FND_GLOBAL.User_Id IS NULL
777: THEN
778: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
779: THEN
780: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
781: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
782: FND_MSG_PUB.ADD;
778: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
779: THEN
780: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
781: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
782: FND_MSG_PUB.ADD;
783: END IF;
784: RAISE FND_API.G_EXC_ERROR;
785: END IF;
786:
807: END IF;
808:
809:
810: -- Standard call to get message count and if count is 1, get message info.
811: FND_MSG_PUB.Count_And_Get
812: ( p_count => x_msg_count,
813: p_data => x_msg_data
814: );
815:
817: WHEN FND_API.G_EXC_ERROR THEN
818: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
819: P_API_NAME => L_API_NAME
820: ,P_PKG_NAME => G_PKG_NAME
821: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
822: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
823: ,X_MSG_COUNT => X_MSG_COUNT
824: ,X_MSG_DATA => X_MSG_DATA
825: ,X_RETURN_STATUS => X_RETURN_STATUS);
827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
828: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
829: P_API_NAME => L_API_NAME
830: ,P_PKG_NAME => G_PKG_NAME
831: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
832: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
833: ,X_MSG_COUNT => X_MSG_COUNT
834: ,X_MSG_DATA => X_MSG_DATA
835: ,X_RETURN_STATUS => X_RETURN_STATUS);
884:
885:
886: -- Initialize message list if p_init_msg_list is set to TRUE.
887: IF FND_API.to_Boolean( p_init_msg_list ) THEN
888: FND_MSG_PUB.initialize;
889: END IF;
890:
891:
892: -- Initialize API return status to SUCCESS
898: --
899:
900: -- Validate Environment
901: IF FND_GLOBAL.User_Id IS NULL THEN
902: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
903: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
904: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
905: FND_MSG_PUB.ADD;
906: END IF;
901: IF FND_GLOBAL.User_Id IS NULL THEN
902: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
903: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
904: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
905: FND_MSG_PUB.ADD;
906: END IF;
907: RAISE FND_API.G_EXC_ERROR;
908: END IF;
909:
930:
931:
932:
933: -- Standard call to get message count and if count is 1, get message info.
934: FND_MSG_PUB.Count_And_Get
935: ( p_count => x_msg_count,
936: p_data => x_msg_data
937: );
938:
940: WHEN FND_API.G_EXC_ERROR THEN
941: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
942: P_API_NAME => L_API_NAME
943: ,P_PKG_NAME => G_PKG_NAME
944: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
945: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
946: ,X_MSG_COUNT => X_MSG_COUNT
947: ,X_MSG_DATA => X_MSG_DATA
948: ,X_RETURN_STATUS => X_RETURN_STATUS);
950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
951: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
952: P_API_NAME => L_API_NAME
953: ,P_PKG_NAME => G_PKG_NAME
954: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
955: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
956: ,X_MSG_COUNT => X_MSG_COUNT
957: ,X_MSG_DATA => X_MSG_DATA
958: ,X_RETURN_STATUS => X_RETURN_STATUS);
1012:
1013:
1014: -- Initialize message list if p_init_msg_list is set to TRUE.
1015: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1016: FND_MSG_PUB.initialize;
1017: END IF;
1018:
1019:
1020:
1026: --
1027:
1028: -- Validate Environment
1029: IF FND_GLOBAL.User_Id IS NULL THEN
1030: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1031: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1032: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1033: FND_MSG_PUB.ADD;
1034: END IF;
1029: IF FND_GLOBAL.User_Id IS NULL THEN
1030: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1031: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1032: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1033: FND_MSG_PUB.ADD;
1034: END IF;
1035: RAISE FND_API.G_EXC_ERROR;
1036: END IF;
1037:
1055: END IF;
1056:
1057:
1058: -- Debug Message
1059: --AS_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1060:
1061:
1062: -- Standard call to get message count and if count is 1, get message info.
1063: FND_MSG_PUB.Count_And_Get
1059: --AS_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1060:
1061:
1062: -- Standard call to get message count and if count is 1, get message info.
1063: FND_MSG_PUB.Count_And_Get
1064: ( p_count => x_msg_count,
1065: p_data => x_msg_data
1066: );
1067:
1069: WHEN FND_API.G_EXC_ERROR THEN
1070: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1071: P_API_NAME => L_API_NAME
1072: ,P_PKG_NAME => G_PKG_NAME
1073: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1074: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1075: ,X_MSG_COUNT => X_MSG_COUNT
1076: ,X_MSG_DATA => X_MSG_DATA
1077: ,X_RETURN_STATUS => X_RETURN_STATUS);
1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1080: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1081: P_API_NAME => L_API_NAME
1082: ,P_PKG_NAME => G_PKG_NAME
1083: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1084: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1085: ,X_MSG_COUNT => X_MSG_COUNT
1086: ,X_MSG_DATA => X_MSG_DATA
1087: ,X_RETURN_STATUS => X_RETURN_STATUS);
1144:
1145: -- Initialize message list if p_init_msg_list is set to TRUE.
1146: IF FND_API.to_Boolean( p_init_msg_list )
1147: THEN
1148: FND_MSG_PUB.initialize;
1149: END IF;
1150:
1151:
1152: -- Initialize API return status to SUCCESS
1158:
1159: -- Validate Environment
1160: IF FND_GLOBAL.User_Id IS NULL
1161: THEN
1162: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1163: THEN
1164: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1165: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1166: FND_MSG_PUB.ADD;
1162: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1163: THEN
1164: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1165: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1166: FND_MSG_PUB.ADD;
1167: END IF;
1168: RAISE FND_API.G_EXC_ERROR;
1169: END IF;
1170:
1190:
1191:
1192:
1193: -- Standard call to get message count and if count is 1, get message info.
1194: FND_MSG_PUB.Count_And_Get
1195: ( p_count => x_msg_count,
1196: p_data => x_msg_data
1197: );
1198:
1200: WHEN FND_API.G_EXC_ERROR THEN
1201: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1202: P_API_NAME => L_API_NAME
1203: ,P_PKG_NAME => G_PKG_NAME
1204: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1205: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1206: ,X_MSG_COUNT => X_MSG_COUNT
1207: ,X_MSG_DATA => X_MSG_DATA
1208: ,X_RETURN_STATUS => X_RETURN_STATUS);
1210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1211: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1212: P_API_NAME => L_API_NAME
1213: ,P_PKG_NAME => G_PKG_NAME
1214: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1215: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1216: ,X_MSG_COUNT => X_MSG_COUNT
1217: ,X_MSG_DATA => X_MSG_DATA
1218: ,X_RETURN_STATUS => X_RETURN_STATUS);
1279:
1280: -- Initialize message list if p_init_msg_list is set to TRUE.
1281: IF FND_API.to_Boolean( p_init_msg_list )
1282: THEN
1283: FND_MSG_PUB.initialize;
1284: END IF;
1285:
1286: -- Initialize API return status to SUCCESS
1287: x_return_status := FND_API.G_RET_STS_SUCCESS;
1291:
1292: -- Validate Environment
1293: IF FND_GLOBAL.User_Id IS NULL
1294: THEN
1295: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1296: THEN
1297: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1298: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1299: FND_MSG_PUB.ADD;
1295: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1296: THEN
1297: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1298: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1299: FND_MSG_PUB.ADD;
1300: END IF;
1301: RAISE FND_API.G_EXC_ERROR;
1302: END IF;
1303: ASO_RELATED_OBJ_PVT.Create_related_obj(
1325:
1326:
1327:
1328: -- Standard call to get message count and if count is 1, get message info.
1329: FND_MSG_PUB.Count_And_Get
1330: ( p_count => x_msg_count,
1331: p_data => x_msg_data
1332: );
1333:
1336: WHEN FND_API.G_EXC_ERROR THEN
1337: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1338: P_API_NAME => L_API_NAME
1339: ,P_PKG_NAME => G_PKG_NAME
1340: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1341: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1342: ,P_SQLCODE => SQLCODE
1343: ,P_SQLERRM => SQLERRM
1344: ,X_MSG_COUNT => X_MSG_COUNT
1348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1349: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1350: P_API_NAME => L_API_NAME
1351: ,P_PKG_NAME => G_PKG_NAME
1352: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1353: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1354: ,P_SQLCODE => SQLCODE
1355: ,P_SQLERRM => SQLERRM
1356: ,X_MSG_COUNT => X_MSG_COUNT
1423:
1424: -- Initialize message list if p_init_msg_list is set to TRUE.
1425: IF FND_API.to_Boolean( p_init_msg_list )
1426: THEN
1427: FND_MSG_PUB.initialize;
1428: END IF;
1429:
1430:
1431: -- Initialize API return status to SUCCESS
1440: -- Validate Environment
1441: -- ******************************************************************
1442: IF FND_GLOBAL.User_Id IS NULL
1443: THEN
1444: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1445: THEN
1446: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1447: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1448: FND_MSG_PUB.ADD;
1444: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1445: THEN
1446: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1447: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1448: FND_MSG_PUB.ADD;
1449: END IF;
1450: RAISE FND_API.G_EXC_ERROR;
1451: END IF;
1452:
1475: END IF;
1476:
1477:
1478: -- Standard call to get message count and if count is 1, get message info.
1479: FND_MSG_PUB.Count_And_Get
1480: ( p_count => x_msg_count,
1481: p_data => x_msg_data
1482: );
1483:
1486: WHEN FND_API.G_EXC_ERROR THEN
1487: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1488: P_API_NAME => L_API_NAME
1489: ,P_PKG_NAME => G_PKG_NAME
1490: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1491: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1492: ,P_SQLCODE => SQLCODE
1493: ,P_SQLERRM => SQLERRM
1494: ,X_MSG_COUNT => X_MSG_COUNT
1498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1499: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1500: P_API_NAME => L_API_NAME
1501: ,P_PKG_NAME => G_PKG_NAME
1502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1503: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1504: ,P_SQLCODE => SQLCODE
1505: ,P_SQLERRM => SQLERRM
1506: ,X_MSG_COUNT => X_MSG_COUNT
1571:
1572: -- Initialize message list if p_init_msg_list is set to TRUE.
1573: IF FND_API.to_Boolean( p_init_msg_list )
1574: THEN
1575: FND_MSG_PUB.initialize;
1576: END IF;
1577:
1578:
1579: -- Initialize API return status to SUCCESS
1587: -- Validate Environment
1588: -- ******************************************************************
1589: IF FND_GLOBAL.User_Id IS NULL
1590: THEN
1591: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1592: THEN
1593: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1594: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1595: FND_MSG_PUB.ADD;
1591: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1592: THEN
1593: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1594: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1595: FND_MSG_PUB.ADD;
1596: END IF;
1597: RAISE FND_API.G_EXC_ERROR;
1598: END IF;
1599:
1623:
1624:
1625:
1626: -- Standard call to get message count and if count is 1, get message info.
1627: FND_MSG_PUB.Count_And_Get
1628: ( p_count => x_msg_count,
1629: p_data => x_msg_data);
1630:
1631: EXCEPTION
1632: WHEN FND_API.G_EXC_ERROR THEN
1633: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1634: P_API_NAME => L_API_NAME
1635: ,P_PKG_NAME => G_PKG_NAME
1636: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1637: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1638: ,P_SQLCODE => SQLCODE
1639: ,P_SQLERRM => SQLERRM
1640: ,X_MSG_COUNT => X_MSG_COUNT
1644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1645: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1646: P_API_NAME => L_API_NAME
1647: ,P_PKG_NAME => G_PKG_NAME
1648: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1649: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1650: ,P_SQLCODE => SQLCODE
1651: ,P_SQLERRM => SQLERRM
1652: ,X_MSG_COUNT => X_MSG_COUNT
1713:
1714: -- Initialize message list if p_init_msg_list is set to TRUE.
1715: IF FND_API.to_Boolean( p_init_msg_list )
1716: THEN
1717: FND_MSG_PUB.initialize;
1718: END IF;
1719:
1720:
1721: -- Initialize API return status to SUCCESS
1729: -- Validate Environment
1730: -- ******************************************************************
1731: IF FND_GLOBAL.User_Id IS NULL
1732: THEN
1733: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1734: THEN
1735: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1736: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1737: FND_MSG_PUB.ADD;
1733: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1734: THEN
1735: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1736: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1737: FND_MSG_PUB.ADD;
1738: END IF;
1739: RAISE FND_API.G_EXC_ERROR;
1740: END IF;
1741:
1762: END IF;
1763:
1764:
1765: -- Standard call to get message count and if count is 1, get message info.
1766: FND_MSG_PUB.Count_And_Get
1767: ( p_count => x_msg_count,
1768: p_data => x_msg_data
1769: );
1770:
1773: WHEN FND_API.G_EXC_ERROR THEN
1774: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1775: P_API_NAME => L_API_NAME
1776: ,P_PKG_NAME => G_PKG_NAME
1777: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1778: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1779: ,X_MSG_COUNT => X_MSG_COUNT
1780: ,X_MSG_DATA => X_MSG_DATA
1781: ,X_RETURN_STATUS => X_RETURN_STATUS);
1783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1784: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1785: P_API_NAME => L_API_NAME
1786: ,P_PKG_NAME => G_PKG_NAME
1787: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1788: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1789: ,X_MSG_COUNT => X_MSG_COUNT
1790: ,X_MSG_DATA => X_MSG_DATA
1791: ,X_RETURN_STATUS => X_RETURN_STATUS);
1847:
1848: -- Initialize message list if p_init_msg_list is set to TRUE.
1849: IF FND_API.to_Boolean( p_init_msg_list )
1850: THEN
1851: FND_MSG_PUB.initialize;
1852: END IF;
1853:
1854:
1855: -- Initialize API return status to SUCCESS
1863: -- Validate Environment
1864: -- ******************************************************************
1865: IF FND_GLOBAL.User_Id IS NULL
1866: THEN
1867: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1868: THEN
1869: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1870: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1871: FND_MSG_PUB.ADD;
1867: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1868: THEN
1869: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1870: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1871: FND_MSG_PUB.ADD;
1872: END IF;
1873: RAISE FND_API.G_EXC_ERROR;
1874: END IF;
1875:
1895: END IF;
1896:
1897:
1898: -- Standard call to get message count and if count is 1, get message info.
1899: FND_MSG_PUB.Count_And_Get
1900: ( p_count => x_msg_count,
1901: p_data => x_msg_data
1902: );
1903:
1906: WHEN FND_API.G_EXC_ERROR THEN
1907: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1908: P_API_NAME => L_API_NAME
1909: ,P_PKG_NAME => G_PKG_NAME
1910: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1911: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1912: ,X_MSG_COUNT => X_MSG_COUNT
1913: ,X_MSG_DATA => X_MSG_DATA
1914: ,X_RETURN_STATUS => X_RETURN_STATUS);
1916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1917: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1918: P_API_NAME => L_API_NAME
1919: ,P_PKG_NAME => G_PKG_NAME
1920: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1921: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1922: ,X_MSG_COUNT => X_MSG_COUNT
1923: ,X_MSG_DATA => X_MSG_DATA
1924: ,X_RETURN_STATUS => X_RETURN_STATUS);
1981:
1982: -- Initialize message list if p_init_msg_list is set to TRUE.
1983: IF FND_API.to_Boolean( p_init_msg_list )
1984: THEN
1985: FND_MSG_PUB.initialize;
1986: END IF;
1987:
1988: -- Initialize API return status to SUCCESS
1989: x_return_status := FND_API.G_RET_STS_SUCCESS;
1996: -- Validate Environment
1997: -- ******************************************************************
1998: IF FND_GLOBAL.User_Id IS NULL
1999: THEN
2000: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2001: THEN
2002: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
2003: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2004: FND_MSG_PUB.ADD;
2000: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2001: THEN
2002: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
2003: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2004: FND_MSG_PUB.ADD;
2005: END IF;
2006: RAISE FND_API.G_EXC_ERROR;
2007: END IF;
2008:
2028: END IF;
2029:
2030:
2031: -- Standard call to get message count and if count is 1, get message info.
2032: FND_MSG_PUB.Count_And_Get
2033: ( p_count => x_msg_count,
2034: p_data => x_msg_data
2035: );
2036:
2039: WHEN FND_API.G_EXC_ERROR THEN
2040: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2041: P_API_NAME => L_API_NAME
2042: ,P_PKG_NAME => G_PKG_NAME
2043: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2044: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2045: ,X_MSG_COUNT => X_MSG_COUNT
2046: ,X_MSG_DATA => X_MSG_DATA
2047: ,X_RETURN_STATUS => X_RETURN_STATUS);
2049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2050: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2051: P_API_NAME => L_API_NAME
2052: ,P_PKG_NAME => G_PKG_NAME
2053: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2054: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2055: ,X_MSG_COUNT => X_MSG_COUNT
2056: ,X_MSG_DATA => X_MSG_DATA
2057: ,X_RETURN_STATUS => X_RETURN_STATUS);