[Home] [Help]
258: -- check uniqueness of rank
259: ---------------------------------------------------------------------
260: PROCEDURE check_action_uk_items(
261: p_action_rec IN action_rec_type,
262: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
263: x_return_status OUT NOCOPY VARCHAR2
264: )
265: IS
266:
269: x_return_status := FND_API.g_ret_sts_success;
270:
271: -- For create_action, when action_id is passed in, we need to
272: -- check if this action_id is unique.
273: IF p_validation_mode = JTF_PLSQL_API.g_create
274: AND p_action_rec.list_select_action_id IS NOT NULL
275: THEN
276: IF AMS_Utility_PVT.check_uniqueness(
277: 'ams_list_select_actions',
286: RETURN;
287: END IF;
288: END IF;
289:
290: IF p_validation_mode = JTF_PLSQL_API.g_create
291: AND p_action_rec.order_number IS NOT NULL
292: THEN
293: IF AMS_Utility_PVT.check_uniqueness(
294: 'ams_list_select_actions',
305: RETURN;
306: END IF;
307: END IF;
308:
309: IF p_validation_mode = JTF_PLSQL_API.g_create
310: AND p_action_rec.rank IS NOT NULL
311: THEN
312: IF AMS_Utility_PVT.check_uniqueness(
313: 'ams_list_select_actions',
715: -- 10/14/99 tdonohoe Created.
716: ---------------------------------------------------------------------
717: PROCEDURE check_action_items(
718: p_action_rec IN action_rec_type,
719: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
720: x_return_status OUT NOCOPY VARCHAR2
721: )
722: IS
723: BEGIN
842: -- Initialize API return status to success
843: x_return_status := FND_API.G_RET_STS_SUCCESS;
844:
845: ---------------------- validate ------------------------
846: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
847: check_action_items(
848: p_action_rec => p_action_rec,
849: p_validation_mode => JTF_PLSQL_API.g_create,
850: x_return_status => l_return_status
845: ---------------------- validate ------------------------
846: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
847: check_action_items(
848: p_action_rec => p_action_rec,
849: p_validation_mode => JTF_PLSQL_API.g_create,
850: x_return_status => l_return_status
851: );
852:
853: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
857: END IF;
858: END IF;
859:
860:
861: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
862: check_action_record(
863: p_action_rec => p_action_rec,
864: p_complete_rec => NULL,
865: x_return_status => l_return_status
1326: complete_action_rec(p_action_rec, l_action_rec);
1327:
1328: -- Initialize API return status to success
1329: x_return_status := FND_API.G_RET_STS_SUCCESS;
1330: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1331: check_action_items(
1332: p_action_rec => l_action_rec,
1333: p_validation_mode => JTF_PLSQL_API.g_update,
1334: x_return_status => l_return_status);
1329: x_return_status := FND_API.G_RET_STS_SUCCESS;
1330: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1331: check_action_items(
1332: p_action_rec => l_action_rec,
1333: p_validation_mode => JTF_PLSQL_API.g_update,
1334: x_return_status => l_return_status);
1335:
1336: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1337: RAISE FND_API.g_exc_unexpected_error;
1342:
1343:
1344: -- replace g_miss_char/num/date with current column values
1345:
1346: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1347: check_action_record(
1348: p_action_rec => l_action_rec,
1349: p_complete_rec => l_action_rec,
1350: x_return_status => l_return_status