APPS.AMS_CELL_PVT dependencies on JTF_PLSQL_API

Line 560: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

556: complete_cell_rec(p_cell_rec, l_cell_rec);
557:
558: AMS_Utility_PVT.debug_message(l_full_name ||': after complete_cell_rec');
559: -- item level
560: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
561: check_cell_items(
562: p_cell_rec => l_cell_rec,
563: p_validation_mode => JTF_PLSQL_API.g_update,
564: x_return_status => l_return_status

Line 563: p_validation_mode => JTF_PLSQL_API.g_update,

559: -- item level
560: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
561: check_cell_items(
562: p_cell_rec => l_cell_rec,
563: p_validation_mode => JTF_PLSQL_API.g_update,
564: x_return_status => l_return_status
565: );
566: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
567: RAISE FND_API.g_exc_unexpected_error;

Line 722: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

718:
719: ---------------------- validate ------------------------
720: AMS_Utility_PVT.debug_message(l_full_name||': check items');
721:
722: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
723: check_cell_items(
724: p_cell_rec => p_cell_rec,
725: p_validation_mode => JTF_PLSQL_API.g_create,
726: x_return_status => l_return_status

Line 725: p_validation_mode => JTF_PLSQL_API.g_create,

721:
722: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
723: check_cell_items(
724: p_cell_rec => p_cell_rec,
725: p_validation_mode => JTF_PLSQL_API.g_create,
726: x_return_status => l_return_status
727: );
728: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
729: RAISE FND_API.g_exc_unexpected_error;

Line 830: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

826: -- 12/15/99 mpande Created.
827: ---------------------------------------------------------------------
828: PROCEDURE check_cell_uk_items(
829: p_cell_rec IN cell_rec_type,
830: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
831: x_return_status OUT NOCOPY VARCHAR2
832: )
833: IS
834: l_valid_flag VARCHAR2(1);

Line 841: IF p_validation_mode = JTF_PLSQL_API.g_create

837: x_return_status := FND_API.g_ret_sts_success;
838:
839: -- For create_cell, when cell_id is passed in, we need to
840: -- check if this cell_id is unique.
841: IF p_validation_mode = JTF_PLSQL_API.g_create
842: AND p_cell_rec.cell_id IS NOT NULL
843: THEN
844: IF AMS_Utility_PVT.check_uniqueness(
845: 'ams_cells_vl',

Line 862: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

858:
859:
860: -- Check if cell_name is unique. Need to handle create and
861: -- update differently.
862: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
863: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
864: 'ams_cells_vl',
865: 'cell_name = ''' || p_cell_rec.cell_name ||''''
866: );

Line 886: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

882: RETURN;
883: END IF;
884: -- Check if cell_code is unique. Need to handle create and
885: -- update differently.
886: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
887: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
888: 'ams_cells_vl',
889: 'cell_code = ''' || p_cell_rec.cell_code||''''
890: );

Line 1087: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

1083: -- 07/13/01 yxliu Added check_cell_hier_items
1084: ---------------------------------------------------------------------
1085: PROCEDURE check_cell_items(
1086: p_cell_rec IN cell_rec_type,
1087: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1088: x_return_status OUT NOCOPY VARCHAR2
1089: )
1090: IS
1091: BEGIN