APPS.AMS_ASSOCIATIONS_PVT dependencies on JTF_PLSQL_API

Line 867: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

863:
864: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
865: END IF;
866:
867: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
868: check_association_items(
869: p_association_rec => p_association_rec,
870: p_validation_mode => JTF_PLSQL_API.g_update,
871: x_return_status => l_return_status

Line 870: p_validation_mode => JTF_PLSQL_API.g_update,

866:
867: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
868: check_association_items(
869: p_association_rec => p_association_rec,
870: p_validation_mode => JTF_PLSQL_API.g_update,
871: x_return_status => l_return_status
872: );
873:
874: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 881: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

877: RAISE FND_API.g_exc_error;
878: END IF;
879: END IF;
880:
881: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
882: check_association_record(
883: p_association_rec => p_association_rec,
884: x_return_status => l_return_status
885: );

Line 1074: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1070:
1071: AMS_Utility_PVT.debug_message(l_full_name||': check items');
1072: END IF;
1073:
1074: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1075: check_association_items(
1076: p_association_rec => p_association_rec,
1077: p_validation_mode => JTF_PLSQL_API.g_create,
1078: x_return_status => l_return_status

Line 1077: p_validation_mode => JTF_PLSQL_API.g_create,

1073:
1074: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1075: check_association_items(
1076: p_association_rec => p_association_rec,
1077: p_validation_mode => JTF_PLSQL_API.g_create,
1078: x_return_status => l_return_status
1079: );
1080:
1081: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1096: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1092: AMS_Utility_PVT.debug_message(l_full_name||': check record');
1093:
1094: END IF;
1095:
1096: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1097: check_association_record(
1098: p_association_rec => p_association_rec,
1099: x_return_status => l_return_status
1100: );

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

1329: -- 11/10/99 sugupta created
1330: ---------------------------------------------------------------------
1331: PROCEDURE check_association_uk_items(
1332: p_association_rec IN association_rec_type,
1333: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1334: x_return_status OUT NOCOPY VARCHAR2
1335: )
1336: IS
1337: l_valid_flag VARCHAR2(1) := 'N';

Line 1365: IF p_validation_mode = JTF_PLSQL_API.g_create

1361:
1362: -- For create_associations, when association_id is passed in, we need to
1363: -- check if this association_id is unique.
1364: --
1365: IF p_validation_mode = JTF_PLSQL_API.g_create
1366: AND p_association_rec.object_association_id IS NOT NULL
1367: THEN
1368: IF AMS_Utility_PVT.check_uniqueness(
1369: 'ams_object_associations',

Line 1383: IF p_validation_mode = JTF_PLSQL_API.g_create

1379: RETURN;
1380: END IF;
1381: END IF;
1382:
1383: IF p_validation_mode = JTF_PLSQL_API.g_create
1384: AND p_association_rec.using_object_id <> FND_API.g_miss_num
1385: AND p_association_rec.master_object_id <> FND_API.g_miss_num
1386: AND p_association_rec.using_object_type <> FND_API.g_miss_char
1387: AND p_association_rec.master_object_type <> FND_API.g_miss_char

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

1716: -- 11/10/99 sugupta created
1717: ---------------------------------------------------------------------
1718: PROCEDURE check_association_items(
1719: p_association_rec IN association_rec_type,
1720: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1721: x_return_status OUT NOCOPY VARCHAR2
1722: )
1723: IS
1724: BEGIN