[Home] [Help]
729:
730: -- replace g_miss_char/num/date with current column values
731: complete_chan_rec(p_chan_rec, l_chan_rec);
732: -- item level
733: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
734: check_chan_items(
735: p_chan_rec => l_chan_rec, -- change from p_chan_rec vmodur
736: p_validation_mode => JTF_PLSQL_API.g_update,
737: x_return_status => l_return_status
732: -- item level
733: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
734: check_chan_items(
735: p_chan_rec => l_chan_rec, -- change from p_chan_rec vmodur
736: p_validation_mode => JTF_PLSQL_API.g_update,
737: x_return_status => l_return_status
738: );
739: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
740: RAISE FND_API.g_exc_unexpected_error;
746: --=============================================================================
747: -- Following call is added by ptendulk on Jul 13th 2000 Ref: Bug#1353602
748: --=============================================================================
749:
750: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
751: Check_Chan_Record(
752: p_chan_rec => l_chan_rec, -- change from p_chan_rec vmodur
753: p_complete_rec => l_chan_rec,
754: x_return_status => l_return_status
959:
960: AMS_Utility_PVT.debug_message(l_full_name||': check items');
961: END IF;
962:
963: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
964: check_chan_items(
965: p_chan_rec => p_chan_rec,
966: p_validation_mode => JTF_PLSQL_API.g_create,
967: x_return_status => l_return_status
962:
963: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
964: check_chan_items(
965: p_chan_rec => p_chan_rec,
966: p_validation_mode => JTF_PLSQL_API.g_create,
967: x_return_status => l_return_status
968: );
969: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
970: RAISE FND_API.g_exc_unexpected_error;
979: IF (AMS_DEBUG_HIGH_ON) THEN
980:
981: AMS_Utility_PVT.debug_message(l_full_name||': check Records');
982: END IF;
983: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
984: Check_Chan_Record(
985: p_chan_rec => p_chan_rec,
986: p_complete_rec => null,
987: x_return_status => l_return_status
1121: -- 23/11/99 mpande Created.
1122: ---------------------------------------------------------------------
1123: PROCEDURE check_chan_uk_items(
1124: p_chan_rec IN chan_rec_type,
1125: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1126: x_return_status OUT NOCOPY VARCHAR2
1127: )
1128: IS
1129: l_valid_flag VARCHAR2(1);
1159: x_return_status := FND_API.g_ret_sts_success;
1160: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message('Check the uniqueness Count - begin'); END IF;
1161: -- For create_channel, when channel_id is passed in, we need to
1162: -- check if this channel_id is unique.
1163: IF p_validation_mode = JTF_PLSQL_API.g_create
1164: AND p_chan_rec.channel_id IS NOT NULL
1165: THEN
1166: IF AMS_Utility_PVT.check_uniqueness(
1167: 'ams_channels_vl',
1180:
1181:
1182: -- Check if channel_name is unique. Need to handle create and
1183: -- update differently.
1184: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1185:
1186: -- rrajesh start 11/08. Replaced the AMS_Utility_PVT call
1187: -- with the new cursor.
1188: --modified by rrajesh on 12/07/00
1451: -- 11/23/99 mpande Created.
1452: ---------------------------------------------------------------------
1453: PROCEDURE check_chan_items(
1454: p_chan_rec IN chan_rec_type,
1455: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1456: x_return_status OUT NOCOPY VARCHAR2
1457: )
1458: IS
1459: BEGIN