DBA Data[Home] [Help]

APPS.AMS_DELIVKITITEM_PVT dependencies on JTF_PLSQL_API

Line 732: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

728:
729: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
730: END IF;
731:
732: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
733: check_deliv_kit_item_items
734: (
735: p_deliv_kit_item_rec => p_deliv_kit_item_rec,
736: p_validation_mode => JTF_PLSQL_API.g_update,

Line 736: p_validation_mode => JTF_PLSQL_API.g_update,

732: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
733: check_deliv_kit_item_items
734: (
735: p_deliv_kit_item_rec => p_deliv_kit_item_rec,
736: p_validation_mode => JTF_PLSQL_API.g_update,
737: x_return_status => l_return_status
738: );
739:
740: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 750: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

746:
747: -- replace g_miss_char/num/date with current column values
748: complete_deliv_kit_item_rec(p_deliv_kit_item_rec, l_deliv_kit_item_rec);
749:
750: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
751: check_deliv_kit_item_record
752: (
753: p_deliv_kit_item_rec => p_deliv_kit_item_rec,
754: p_complete_rec => l_deliv_kit_item_rec,

Line 918: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

914: IF (AMS_DEBUG_HIGH_ON) THEN
915: AMS_Utility_PVT.debug_message(l_full_name||': check items');
916: END IF;
917:
918: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
919: check_deliv_kit_item_items
920: (
921: p_deliv_kit_item_rec => p_deliv_kit_item_rec,
922: p_validation_mode => JTF_PLSQL_API.g_create,

Line 922: p_validation_mode => JTF_PLSQL_API.g_create,

918: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
919: check_deliv_kit_item_items
920: (
921: p_deliv_kit_item_rec => p_deliv_kit_item_rec,
922: p_validation_mode => JTF_PLSQL_API.g_create,
923: x_return_status => l_return_status
924: );
925:
926: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 937: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

933: IF (AMS_DEBUG_HIGH_ON) THEN
934: AMS_Utility_PVT.debug_message(l_full_name||': check record');
935: END IF;
936:
937: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
938: check_deliv_kit_item_record
939: (
940: p_deliv_kit_item_rec => p_deliv_kit_item_rec,
941: p_complete_rec => NULL,

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

1054: ---------------------------------------------------------------------
1055:
1056: PROCEDURE check_deliv_kit_item_uk_items(
1057: p_deliv_kit_item_rec IN deliv_kit_item_rec_type,
1058: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1059: x_return_status OUT NOCOPY VARCHAR2
1060: )
1061: IS
1062:

Line 1071: IF p_validation_mode = JTF_PLSQL_API.g_create

1067: x_return_status := FND_API.g_ret_sts_success;
1068:
1069: -- For create_deliv_kit_item, when deliverable_kit_item_id is passed in, we need to
1070: -- check if this deliverable_kit_item_id is unique.
1071: IF p_validation_mode = JTF_PLSQL_API.g_create
1072: AND p_deliv_kit_item_rec.deliverable_kit_item_id IS NOT NULL
1073: THEN
1074: IF AMS_Utility_PVT.check_uniqueness(
1075: 'ams_deliv_kit_items',

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

1294: ---------------------------------------------------------------------
1295: PROCEDURE check_deliv_kit_item_items
1296: (
1297: p_deliv_kit_item_rec IN deliv_kit_item_rec_type,
1298: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1299: x_return_status OUT NOCOPY VARCHAR2
1300: )
1301: IS
1302: