182:
183: -- Initialize message list if p_init_msg_list is set to TRUE.
184: IF FND_API.to_Boolean( p_init_msg_list )
185: THEN
186: FND_MSG_PUB.initialize;
187: END IF;
188:
189:
190: -- Initialize API return status to SUCCESS
247: END IF;
248:
249:
250: -- Standard call to get message count and if count is 1, get message info.
251: FND_MSG_PUB.Count_And_Get
252: ( p_count => x_msg_count,
253: p_data => x_msg_data
254: );
255:
256: EXCEPTION
257: WHEN FND_API.G_EXC_ERROR THEN
258: ROLLBACK TO Create_Profile_Check_PVT;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: FND_MSG_PUB.Count_And_Get
261: ( p_count => x_msg_count,
262: p_data => x_msg_data
263: );
264: APP_EXCEPTION.RAISE_EXCEPTION;
264: APP_EXCEPTION.RAISE_EXCEPTION;
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: ROLLBACK TO Create_Profile_Check_PVT;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: FND_MSG_PUB.Count_And_Get
269: ( p_count => x_msg_count,
270: p_data => x_msg_data
271: );
272: APP_EXCEPTION.RAISE_EXCEPTION;
272: APP_EXCEPTION.RAISE_EXCEPTION;
273: WHEN OTHERS THEN
274: ROLLBACK TO Create_Profile_Check_PVT;
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
277: FND_MSG_PUB.Count_And_Get
278: ( p_count => x_msg_count,
279: p_data => x_msg_data
280: );
273: WHEN OTHERS THEN
274: ROLLBACK TO Create_Profile_Check_PVT;
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
277: FND_MSG_PUB.Count_And_Get
278: ( p_count => x_msg_count,
279: p_data => x_msg_data
280: );
281: APP_EXCEPTION.RAISE_EXCEPTION;
422:
423: -- Initialize message list if p_init_msg_list is set to TRUE.
424: IF FND_API.to_Boolean( p_init_msg_list )
425: THEN
426: FND_MSG_PUB.initialize;
427: END IF;
428:
429: -- Initialize API return status to SUCCESS
430: x_return_status := FND_API.G_RET_STS_SUCCESS;
462: l_ref_Check_rec.APPLICATION_ID;
463:
464: If ( C_Get_check%NOTFOUND) Then
465: close C_Get_Check;
466: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
467: THEN
468: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_Api_Name => l_api_name);
469: --FND_MESSAGE.Set_Name('CSC', 'API_MISSING_UPDATE_TARGET');
470: --FND_MESSAGE.Set_Token ('INFO', 'CHECK', FALSE);
467: THEN
468: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_Api_Name => l_api_name);
469: --FND_MESSAGE.Set_Name('CSC', 'API_MISSING_UPDATE_TARGET');
470: --FND_MESSAGE.Set_Token ('INFO', 'CHECK', FALSE);
471: --FND_MSG_PUB.Add;
472: END IF;
473: raise FND_API.G_EXC_ERROR;
474: END IF;
475: IF C_Get_Check%ISOPEN THEN
530: END IF;
531:
532:
533: -- Standard call to get message count and if count is 1, get message info.
534: FND_MSG_PUB.Count_And_Get
535: ( p_count => x_msg_count,
536: p_data => x_msg_data
537: );
538:
539: EXCEPTION
540: WHEN FND_API.G_EXC_ERROR THEN
541: ROLLBACK TO Update_Profile_check_PVT;
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: FND_MSG_PUB.Count_And_Get
544: ( p_encoded => FND_API.G_FALSE,p_count => x_msg_count,
545: p_data => x_msg_data
546: );
547: APP_EXCEPTION.RAISE_EXCEPTION;
547: APP_EXCEPTION.RAISE_EXCEPTION;
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549: ROLLBACK TO Update_Profile_check_PVT;
550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
551: FND_MSG_PUB.Count_And_Get
552: ( p_count => x_msg_count,
553: p_data => x_msg_data
554: );
555: APP_EXCEPTION.RAISE_EXCEPTION;
555: APP_EXCEPTION.RAISE_EXCEPTION;
556: WHEN OTHERS THEN
557: ROLLBACK TO Update_Profile_check_PVT;
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
560: FND_MSG_PUB.Count_And_Get
561: ( p_count => x_msg_count,
562: p_data => x_msg_data
563: );
556: WHEN OTHERS THEN
557: ROLLBACK TO Update_Profile_check_PVT;
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
560: FND_MSG_PUB.Count_And_Get
561: ( p_count => x_msg_count,
562: p_data => x_msg_data
563: );
564: APP_EXCEPTION.RAISE_EXCEPTION;
595:
596: -- Initialize message list if p_init_msg_list is set to TRUE.
597: IF FND_API.to_Boolean( p_init_msg_list )
598: THEN
599: FND_MSG_PUB.initialize;
600: END IF;
601:
602:
603:
622: END IF;
623:
624:
625: -- Standard call to get message count and if count is 1, get message info.
626: FND_MSG_PUB.Count_And_Get
627: ( p_count => x_msg_count,
628: p_data => x_msg_data
629: );
630:
631: EXCEPTION
632: WHEN FND_API.G_EXC_ERROR THEN
633: ROLLBACK TO DELETE_Profile_Checks_PVT;
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,p_count => x_msg_count,
636: p_data => x_msg_data
637: );
638: APP_EXCEPTION.RAISE_EXCEPTION;
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
638: APP_EXCEPTION.RAISE_EXCEPTION;
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK TO DELETE_Profile_Checks_PVT;
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
643: p_data => x_msg_data
644: );
645: APP_EXCEPTION.RAISE_EXCEPTION;
646: WHEN OTHERS THEN
645: APP_EXCEPTION.RAISE_EXCEPTION;
646: WHEN OTHERS THEN
647: ROLLBACK TO DELETE_Profile_Checks_PVT;
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
650: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
651: p_data => x_msg_data
652: );
653: APP_EXCEPTION.RAISE_EXCEPTION;
646: WHEN OTHERS THEN
647: ROLLBACK TO DELETE_Profile_Checks_PVT;
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
650: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
651: p_data => x_msg_data
652: );
653: APP_EXCEPTION.RAISE_EXCEPTION;
654: End Delete_profile_check;
678:
679: -- Initialize message list if p_init_msg_list is set to TRUE.
680: IF FND_API.to_Boolean( p_init_msg_list )
681: THEN
682: FND_MSG_PUB.initialize;
683: END IF;
684:
685: -- validate NOT NULL column
686: IF (p_CHECK_NAME is NULL)
775:
776: -- Initialize message list if p_init_msg_list is set to TRUE.
777: IF FND_API.to_Boolean( p_init_msg_list )
778: THEN
779: FND_MSG_PUB.initialize;
780: END IF;
781:
782:
783: -- Initialize API return status to SUCCESS
873:
874: -- Initialize message list if p_init_msg_list is set to TRUE.
875: IF FND_API.to_Boolean( p_init_msg_list )
876: THEN
877: FND_MSG_PUB.initialize;
878: END IF;
879:
880:
881: -- Initialize API return status to SUCCESS
890: x_return_status := FND_API.G_RET_STS_ERROR;
891: END IF;
892:
893: -- Standard call to get message count and if count is 1, get message info.
894: FND_MSG_PUB.Count_And_Get
895: ( p_count => x_msg_count,
896: p_data => x_msg_data
897: );
898:
913:
914: -- Initialize message list if p_init_msg_list is set to TRUE.
915: IF FND_API.to_Boolean( p_init_msg_list )
916: THEN
917: FND_MSG_PUB.initialize;
918: END IF;
919:
920:
921: -- Initialize API return status to SUCCESS
941: END IF;
942: END IF;
943:
944: -- Standard call to get message count and if count is 1, get message info.
945: FND_MSG_PUB.Count_And_Get
946: ( p_count => x_msg_count,
947: p_data => x_msg_data
948: );
949:
993:
994: -- Initialize message list if p_init_msg_list is set to TRUE.
995: IF FND_API.to_Boolean( p_init_msg_list )
996: THEN
997: FND_MSG_PUB.initialize;
998: END IF;
999:
1000:
1001: -- Initialize API return status to SUCCESS
1011: END IF;
1012:
1013:
1014: -- Standard call to get message count and if count is 1, get message info.
1015: FND_MSG_PUB.Count_And_Get
1016: ( p_count => x_msg_count,
1017: p_data => x_msg_data
1018: );
1019:
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:
1048:
1049: -- Initialize API return status to SUCCESS
1138: END IF;
1139: END IF;
1140:
1141: -- Standard call to get message count and if count is 1, get message info.
1142: FND_MSG_PUB.Count_And_Get
1143: ( p_count => x_msg_count,
1144: p_data => x_msg_data
1145: );
1146:
1161:
1162: -- Initialize message list if p_init_msg_list is set to TRUE.
1163: IF FND_API.to_Boolean( p_init_msg_list )
1164: THEN
1165: FND_MSG_PUB.initialize;
1166: END IF;
1167:
1168:
1169: -- Initialize API return status to SUCCESS
1184:
1185: END IF;
1186:
1187: -- Standard call to get message count and if count is 1, get message info.
1188: FND_MSG_PUB.Count_And_Get
1189: ( p_count => x_msg_count,
1190: p_data => x_msg_data
1191: );
1192:
1206:
1207: -- Initialize message list if p_init_msg_list is set to TRUE.
1208: IF FND_API.to_Boolean( p_init_msg_list )
1209: THEN
1210: FND_MSG_PUB.initialize;
1211: END IF;
1212:
1213:
1214: -- Initialize API return status to SUCCESS
1235: NULL;
1236: END IF;
1237:
1238: -- Standard call to get message count and if count is 1, get message info.
1239: FND_MSG_PUB.Count_And_Get
1240: ( p_count => x_msg_count,
1241: p_data => x_msg_data
1242: );
1243:
1258:
1259: -- Initialize message list if p_init_msg_list is set to TRUE.
1260: IF FND_API.to_Boolean( p_init_msg_list )
1261: THEN
1262: FND_MSG_PUB.initialize;
1263: END IF;
1264:
1265: -- Initialize API return status to SUCCESS
1266: x_return_status := FND_API.G_RET_STS_SUCCESS;
1284: END IF;
1285: END IF;
1286:
1287: -- Standard call to get message count and if count is 1, get message info.
1288: FND_MSG_PUB.Count_And_Get
1289: ( p_count => x_msg_count,
1290: p_data => x_msg_data
1291: );
1292:
1307:
1308: -- Initialize message list if p_init_msg_list is set to TRUE.
1309: IF FND_API.to_Boolean( p_init_msg_list )
1310: THEN
1311: FND_MSG_PUB.initialize;
1312: END IF;
1313:
1314:
1315: -- Initialize API return status to SUCCESS
1322: p_argument_value => p_check_upper_lower_flag,
1323: p_argument => 'P_CHECK_UPPER_LOWER_FLAG');
1324: END IF;
1325: -- Standard call to get message count and if count is 1, get message info.
1326: FND_MSG_PUB.Count_And_Get
1327: ( p_count => x_msg_count,
1328: p_data => x_msg_data
1329: );
1330:
1345:
1346: -- Initialize message list if p_init_msg_list is set to TRUE.
1347: IF FND_API.to_Boolean( p_init_msg_list )
1348: THEN
1349: FND_MSG_PUB.initialize;
1350: END IF;
1351:
1352:
1353: -- Initialize API return status to SUCCESS
1355:
1356: NULL;
1357:
1358: -- Standard call to get message count and if count is 1, get message info.
1359: FND_MSG_PUB.Count_And_Get
1360: ( p_count => x_msg_count,
1361: p_data => x_msg_data
1362: );
1363:
1378:
1379: -- Initialize message list if p_init_msg_list is set to TRUE.
1380: IF FND_API.to_Boolean( p_init_msg_list )
1381: THEN
1382: FND_MSG_PUB.initialize;
1383: END IF;
1384:
1385:
1386: -- Initialize API return status to SUCCESS
1388:
1389: NULL;
1390:
1391: -- Standard call to get message count and if count is 1, get message info.
1392: FND_MSG_PUB.Count_And_Get
1393: ( p_count => x_msg_count,
1394: p_data => x_msg_data
1395: );
1396: