DBA Data[Home] [Help]

APPS.AMS_CAT_ACTIVITY_PVT dependencies on JTF_PLSQL_API

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

711:
712:
713: PROCEDURE check_cat_activity_uk_items(
714: p_cat_activity_rec IN cat_activity_rec_type,
715: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
716: x_return_status OUT NOCOPY VARCHAR2)
717: IS
718: l_valid_flag VARCHAR2(1);
719:

Line 723: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

719:
720: BEGIN
721: x_return_status := FND_API.g_ret_sts_success;
722: /****
723: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
724: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
725: 'AMS_CAT_ACTIVITIES',
726: 'CAT_ACTIVITY_ID = ''' || p_cat_activity_rec.CAT_ACTIVITY_ID ||''''
727: );

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

743: END check_cat_activity_uk_items;
744:
745: PROCEDURE check_cat_activity_req_items(
746: p_cat_activity_rec IN cat_activity_rec_type,
747: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
748: x_return_status OUT NOCOPY VARCHAR2
749: )
750: IS
751: BEGIN

Line 754: --IF p_validation_mode = JTF_PLSQL_API.g_create THEN

750: IS
751: BEGIN
752: x_return_status := FND_API.g_ret_sts_success;
753:
754: --IF p_validation_mode = JTF_PLSQL_API.g_create THEN
755: IF (AMS_DEBUG_HIGH_ON) THEN
756:
757: AMS_UTILITY_PVT.DEBUG_MESSAGE('MUS:: IN THE check_cat_activity_req_items :' ||p_cat_activity_rec.activity_id);
758: END IF;

Line 1024: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1020: IF FND_API.to_Boolean( p_init_msg_list )
1021: THEN
1022: FND_MSG_PUB.initialize;
1023: END IF;
1024: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1025: Check_cat_activity_Items(
1026: p_cat_activity_rec => p_cat_activity_rec,
1027: p_validation_mode => JTF_PLSQL_API.g_update,
1028: x_return_status => x_return_status

Line 1027: p_validation_mode => JTF_PLSQL_API.g_update,

1023: END IF;
1024: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1025: Check_cat_activity_Items(
1026: p_cat_activity_rec => p_cat_activity_rec,
1027: p_validation_mode => JTF_PLSQL_API.g_update,
1028: x_return_status => x_return_status
1029: );
1030:
1031: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1051: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1047: p_cat_activity_rec => p_cat_activity_rec,
1048: x_complete_rec => l_cat_activity_rec
1049: );
1050:
1051: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1052: Validate_cat_activity_Rec(
1053: p_api_version_number => 1.0,
1054: p_init_msg_list => FND_API.G_FALSE,
1055: x_return_status => x_return_status,