APPS.AMS_PARTYIMPORT_PVT dependencies on JTF_PLSQL_API

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

42: );
43:
44: PROCEDURE Check_Party_UK_Items (
45: p_party_rec IN Party_Rec_Type,
46: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
47: x_return_status OUT NOCOPY VARCHAR2
48: );
49:
50: PROCEDURE Check_Party_FK_Items (

Line 1085: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1081:
1082: -- replace g_miss_char/num/date with current column values
1083: Complete_Party_Rec (p_party_rec, l_party_rec);
1084:
1085: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1086: Check_Party_Items (
1087: p_party_rec => p_party_rec,
1088: p_validation_mode => JTF_PLSQL_API.g_update,
1089: x_return_status => l_return_status

Line 1088: p_validation_mode => JTF_PLSQL_API.g_update,

1084:
1085: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1086: Check_Party_Items (
1087: p_party_rec => p_party_rec,
1088: p_validation_mode => JTF_PLSQL_API.g_update,
1089: x_return_status => l_return_status
1090: );
1091:
1092: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1099: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1095: RAISE FND_API.g_exc_error;
1096: END IF;
1097: END IF;
1098:
1099: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1100: Check_Party_Record (
1101: p_party_rec => p_party_rec,
1102: p_complete_rec => l_party_rec,
1103: x_return_status => l_return_status

Line 1491: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1487:
1488: AMS_Utility_PVT.debug_message (l_full_name || ': Check items');
1489: END IF;
1490:
1491: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1492: Check_Party_Items (
1493: p_party_rec => p_party_rec,
1494: p_validation_mode => JTF_PLSQL_API.g_create,
1495: x_return_status => l_return_status

Line 1494: p_validation_mode => JTF_PLSQL_API.g_create,

1490:
1491: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1492: Check_Party_Items (
1493: p_party_rec => p_party_rec,
1494: p_validation_mode => JTF_PLSQL_API.g_create,
1495: x_return_status => l_return_status
1496: );
1497:
1498: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1513: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1509: AMS_Utility_PVT.debug_message (l_full_name || ': Check record');
1510:
1511: END IF;
1512:
1513: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1514: Check_Party_Record (
1515: p_party_rec => p_party_rec,
1516: p_complete_rec => NULL,
1517: x_return_status => l_return_status

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

1580: -- 08-Nov-1999 choang Created.
1581: ---------------------------------------------------------------------
1582: PROCEDURE Check_Party_Items (
1583: p_party_rec IN Party_Rec_Type,
1584: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1585: x_return_status OUT NOCOPY VARCHAR2
1586: )
1587: IS
1588: BEGIN

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

3416: -- 08-Nov-1999 choang Created.
3417: ---------------------------------------------------------------------
3418: PROCEDURE Check_Party_UK_Items (
3419: p_party_rec IN Party_Rec_Type,
3420: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
3421: x_return_status OUT NOCOPY VARCHAR2
3422: )
3423: IS
3424: l_where_clause VARCHAR2(4000);

Line 3431: IF p_validation_mode = JTF_PLSQL_API.g_create

3427: x_return_status := FND_API.g_ret_sts_success;
3428:
3429: -- For Create_Party, when ID is passed in, we need to
3430: -- check if this ID is unique.
3431: IF p_validation_mode = JTF_PLSQL_API.g_create
3432: AND p_party_rec.party_sources_id IS NOT NULL
3433: THEN
3434: IF AMS_Utility_PVT.check_uniqueness (
3435: 'ams_party_sources',