[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: );
1010: p_argument_value => p_select_type);
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: );
1137: END IF;
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: );
1183: END IF;
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: );
1234: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
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: );
1283: p_argument=>'P_RATING_CODE' );
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: );
1321: p_api_name => p_api_name,
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: );
1354: x_return_status := FND_API.G_RET_STS_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: );
1387: x_return_status := FND_API.G_RET_STS_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: );