[Home] [Help]
166: l_api_version_number CONSTANT NUMBER := 1.0;
167: l_api_name_full VARCHAR2(61) := G_PKG_NAME || '.' || l_api_name ;
168: BEGIN
169:
170: -- Standard Start of API savepoint
171: SAVEPOINT CREATE_PROFILE_CHECK_PVT;
172:
173: -- Standard call to check for call compatibility.
174: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
169:
170: -- Standard Start of API savepoint
171: SAVEPOINT CREATE_PROFILE_CHECK_PVT;
172:
173: -- Standard call to check for call compatibility.
174: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
175: p_api_version_number,
176: l_api_name,
177: G_PKG_NAME)
239: RAISE FND_API.G_EXC_ERROR;
240: END IF;
241:
242:
243: -- Standard check for p_commit
244: IF FND_API.to_Boolean( p_commit )
245: THEN
246: COMMIT WORK;
247: END IF;
246: COMMIT WORK;
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: );
407: -- Local Variables
408: l_ref_Check_rec CSC_Profile_check_PVT.Check_Rec_Type;
409: l_rowid ROWID;
410: BEGIN
411: -- Standard Start of API savepoint
412: SAVEPOINT UPDATE_PROFILE_CHECK_PVT;
413:
414: -- Standard call to check for call compatibility.
415: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
410: BEGIN
411: -- Standard Start of API savepoint
412: SAVEPOINT UPDATE_PROFILE_CHECK_PVT;
413:
414: -- Standard call to check for call compatibility.
415: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
416: p_api_version_number,
417: l_api_name,
418: G_PKG_NAME)
522: --
523: -- End of API body.
524: --
525:
526: -- Standard check for p_commit
527: IF FND_API.to_Boolean( p_commit )
528: THEN
529: COMMIT WORK;
530: END IF;
529: COMMIT WORK;
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: );
579: IS
580: l_api_name CONSTANT VARCHAR2(30) := 'Delete_profile_check';
581: l_api_version_number CONSTANT NUMBER := 1.0;
582: BEGIN
583: -- Standard Start of API savepoint
584: SAVEPOINT DELETE_Profile_Checks_PVT;
585:
586: -- Standard call to check for call compatibility.
587: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
582: BEGIN
583: -- Standard Start of API savepoint
584: SAVEPOINT DELETE_Profile_Checks_PVT;
585:
586: -- Standard call to check for call compatibility.
587: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
588: p_api_version_number,
589: l_api_name,
590: G_PKG_NAME)
614: --
615: -- End of API body
616: --
617:
618: -- Standard check for p_commit
619: IF FND_API.to_Boolean( p_commit )
620: THEN
621: COMMIT WORK;
622: END IF;
621: COMMIT WORK;
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: );
889: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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: );
940: p_argument => 'p_seeded_flag');
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: );
1008: p_argument_value => p_select_type);
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: );
1135: END IF;
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: );
1181: END IF;
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: );
1232: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
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: );
1281: p_argument=>'P_RATING_CODE' );
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: );
1319: p_api_name => p_api_name,
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: );
1352: x_return_status := FND_API.G_RET_STS_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: );
1385: x_return_status := FND_API.G_RET_STS_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: );