DBA Data[Home] [Help]

APPS.PVX_PRTNR_PRFLS_PVT dependencies on JTF_PLSQL_API

Line 626: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

622: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
623: PVX_Utility_PVT.debug_message(l_full_name ||': validate');
624: END IF;
625:
626: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
627: Check_Prtnr_Prfls_Items(
628: p_prtnr_prfls_rec => p_prtnr_prfls_rec,
629: p_validation_mode => JTF_PLSQL_API.g_update,
630: x_return_status => l_return_status

Line 629: p_validation_mode => JTF_PLSQL_API.g_update,

625:
626: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
627: Check_Prtnr_Prfls_Items(
628: p_prtnr_prfls_rec => p_prtnr_prfls_rec,
629: p_validation_mode => JTF_PLSQL_API.g_update,
630: x_return_status => l_return_status
631: );
632:
633: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 648: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

644: --dbms_output.put_line('l_prtnr_prfls_rec.cm_id = '||TO_CHAR(l_prtnr_prfls_rec.cm_id));
645:
646: --dbms_output.put_line('Got complete record ');
647:
648: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
649: Check_Prtnr_Prfls_Record(
650: p_prtnr_prfls_rec => p_prtnr_prfls_rec,
651: p_complete_rec => l_prtnr_prfls_rec,
652: p_mode => l_mode,

Line 939: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

935: PVX_Utility_PVT.debug_message(l_full_name||': check items');
936: END IF;
937: --dbms_output.put_line(l_full_name||': start item validate');
938:
939: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
940: Check_Prtnr_Prfls_Items(
941: p_prtnr_prfls_rec => p_prtnr_prfls_rec,
942: p_validation_mode => JTF_PLSQL_API.g_create,
943: x_return_status => l_return_status

Line 942: p_validation_mode => JTF_PLSQL_API.g_create,

938:
939: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
940: Check_Prtnr_Prfls_Items(
941: p_prtnr_prfls_rec => p_prtnr_prfls_rec,
942: p_validation_mode => JTF_PLSQL_API.g_create,
943: x_return_status => l_return_status
944: );
945:
946: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 959: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

955: END IF;
956:
957: --dbms_output.put_line(l_full_name||': start record validate');
958:
959: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
960: Check_Prtnr_Prfls_Record(
961: p_prtnr_prfls_rec => p_prtnr_prfls_rec,
962: p_complete_rec => NULL,
963: x_return_status => l_return_status

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

1151: --
1152: ---------------------------------------------------------------------
1153: PROCEDURE Check_Uk_Items(
1154: p_prtnr_prfls_rec IN prtnr_prfls_rec_type
1155: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
1156: ,x_return_status OUT NOCOPY VARCHAR2
1157: )
1158: IS
1159: l_valid_flag VARCHAR2(1);

Line 1166: IF p_validation_mode = JTF_PLSQL_API.g_create

1162: x_return_status := FND_API.g_ret_sts_success;
1163:
1164: -- when attr_val_id is passed in, we need to
1165: -- check if this is unique.
1166: IF p_validation_mode = JTF_PLSQL_API.g_create
1167: AND p_prtnr_prfls_rec.partner_profile_id IS NOT NULL
1168: THEN
1169: IF PVX_Utility_PVT.check_uniqueness(
1170: 'PV_PARTNER_PROFILES',

Line 1292: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create

1288: -- Check_Prtnr_Prfls_Items
1289: --
1290: ---------------------------------------------------------------------
1291: PROCEDURE Check_Prtnr_Prfls_Items(
1292: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
1293: ,x_return_status OUT NOCOPY VARCHAR2
1294: ,p_prtnr_prfls_rec IN prtnr_prfls_rec_type
1295: )
1296: IS