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:
991:
992: -- Initialize message list if p_init_msg_list is set to TRUE.
993: IF FND_API.to_Boolean( p_init_msg_list )
994: THEN
995: FND_MSG_PUB.initialize;
996: END IF;
997:
998:
999: -- Initialize API return status to SUCCESS
1009: END IF;
1010:
1011:
1012: -- Standard call to get message count and if count is 1, get message info.
1013: FND_MSG_PUB.Count_And_Get
1014: ( p_count => x_msg_count,
1015: p_data => x_msg_data
1016: );
1017:
1039:
1040: -- Initialize message list if p_init_msg_list is set to TRUE.
1041: IF FND_API.to_Boolean( p_init_msg_list )
1042: THEN
1043: FND_MSG_PUB.initialize;
1044: END IF;
1045:
1046:
1047: -- Initialize API return status to SUCCESS
1136: END IF;
1137: END IF;
1138:
1139: -- Standard call to get message count and if count is 1, get message info.
1140: FND_MSG_PUB.Count_And_Get
1141: ( p_count => x_msg_count,
1142: p_data => x_msg_data
1143: );
1144:
1159:
1160: -- Initialize message list if p_init_msg_list is set to TRUE.
1161: IF FND_API.to_Boolean( p_init_msg_list )
1162: THEN
1163: FND_MSG_PUB.initialize;
1164: END IF;
1165:
1166:
1167: -- Initialize API return status to SUCCESS
1182:
1183: END IF;
1184:
1185: -- Standard call to get message count and if count is 1, get message info.
1186: FND_MSG_PUB.Count_And_Get
1187: ( p_count => x_msg_count,
1188: p_data => x_msg_data
1189: );
1190:
1204:
1205: -- Initialize message list if p_init_msg_list is set to TRUE.
1206: IF FND_API.to_Boolean( p_init_msg_list )
1207: THEN
1208: FND_MSG_PUB.initialize;
1209: END IF;
1210:
1211:
1212: -- Initialize API return status to SUCCESS
1233: NULL;
1234: END IF;
1235:
1236: -- Standard call to get message count and if count is 1, get message info.
1237: FND_MSG_PUB.Count_And_Get
1238: ( p_count => x_msg_count,
1239: p_data => x_msg_data
1240: );
1241:
1256:
1257: -- Initialize message list if p_init_msg_list is set to TRUE.
1258: IF FND_API.to_Boolean( p_init_msg_list )
1259: THEN
1260: FND_MSG_PUB.initialize;
1261: END IF;
1262:
1263: -- Initialize API return status to SUCCESS
1264: x_return_status := FND_API.G_RET_STS_SUCCESS;
1282: END IF;
1283: END IF;
1284:
1285: -- Standard call to get message count and if count is 1, get message info.
1286: FND_MSG_PUB.Count_And_Get
1287: ( p_count => x_msg_count,
1288: p_data => x_msg_data
1289: );
1290:
1305:
1306: -- Initialize message list if p_init_msg_list is set to TRUE.
1307: IF FND_API.to_Boolean( p_init_msg_list )
1308: THEN
1309: FND_MSG_PUB.initialize;
1310: END IF;
1311:
1312:
1313: -- Initialize API return status to SUCCESS
1320: p_argument_value => p_check_upper_lower_flag,
1321: p_argument => 'P_CHECK_UPPER_LOWER_FLAG');
1322: END IF;
1323: -- Standard call to get message count and if count is 1, get message info.
1324: FND_MSG_PUB.Count_And_Get
1325: ( p_count => x_msg_count,
1326: p_data => x_msg_data
1327: );
1328:
1343:
1344: -- Initialize message list if p_init_msg_list is set to TRUE.
1345: IF FND_API.to_Boolean( p_init_msg_list )
1346: THEN
1347: FND_MSG_PUB.initialize;
1348: END IF;
1349:
1350:
1351: -- Initialize API return status to SUCCESS
1353:
1354: NULL;
1355:
1356: -- Standard call to get message count and if count is 1, get message info.
1357: FND_MSG_PUB.Count_And_Get
1358: ( p_count => x_msg_count,
1359: p_data => x_msg_data
1360: );
1361:
1376:
1377: -- Initialize message list if p_init_msg_list is set to TRUE.
1378: IF FND_API.to_Boolean( p_init_msg_list )
1379: THEN
1380: FND_MSG_PUB.initialize;
1381: END IF;
1382:
1383:
1384: -- Initialize API return status to SUCCESS
1386:
1387: NULL;
1388:
1389: -- Standard call to get message count and if count is 1, get message info.
1390: FND_MSG_PUB.Count_And_Get
1391: ( p_count => x_msg_count,
1392: p_data => x_msg_data
1393: );
1394: