APPS.AMS_COMPETITOR_PRODUCT_PVT dependencies on JTF_PLSQL_API

Line 360: p_validation_mode => JTF_PLSQL_API.g_update,

356: Validate_comp_prod(
357: p_api_version_number => 1.0,
358: p_init_msg_list => FND_API.G_FALSE,
359: p_validation_level => p_validation_level,
360: p_validation_mode => JTF_PLSQL_API.g_update,
361: p_comp_prod_rec => p_comp_prod_rec,
362: x_return_status => x_return_status,
363: x_msg_count => x_msg_count,
364: x_msg_data => x_msg_data);

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

856: END Complete_comp_prod_rec;
857:
858: PROCEDURE check_comp_prod_uk_items(
859: p_comp_prod_rec IN comp_prod_rec_type,
860: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
861: x_return_status OUT NOCOPY VARCHAR2)
862: IS
863: l_valid_flag VARCHAR2(1);
864:

Line 867: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

863: l_valid_flag VARCHAR2(1);
864:
865: BEGIN
866: x_return_status := FND_API.g_ret_sts_success;
867: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
868: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
869: 'AMS_COMPETITOR_PRODUCTS_B',
870: 'competitor_product_id = '|| p_comp_prod_rec.competitor_product_id
871: );

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

888: END check_comp_prod_uk_items;
889:
890: PROCEDURE check_comp_Prod_req_items(
891: p_comp_Prod_rec IN comp_Prod_rec_type,
892: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
893: x_return_status OUT NOCOPY VARCHAR2
894: )
895: IS
896: BEGIN

Line 904: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

900: THEN
901: AMS_UTILITY_PVT.debug_message('INSIDE THE check_comp_Prod_req_items and p_validation_mode is:'||p_validation_mode);
902: END IF;
903:
904: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
905:
906: IF p_comp_Prod_rec.competitor_party_id = FND_API.g_miss_num OR p_comp_Prod_rec.competitor_party_id IS NULL THEN
907: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_comp_Prod_NO_competitor_party_id');
908: x_return_status := FND_API.g_ret_sts_error;

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

1171: PROCEDURE Validate_comp_prod(
1172: p_api_version_number IN NUMBER,
1173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1175: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1176: p_comp_prod_rec IN comp_prod_rec_type,
1177: x_return_status OUT NOCOPY VARCHAR2,
1178: x_msg_count OUT NOCOPY NUMBER,
1179: x_msg_data OUT NOCOPY VARCHAR2

Line 1217: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1213: FND_MSG_PUB.initialize;
1214: END IF;
1215:
1216:
1217: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1218: Check_comp_prod_Items(
1219: p_comp_prod_rec => p_comp_prod_rec,
1220: p_validation_mode => p_validation_mode, --JTF_PLSQL_API.g_update,
1221: x_return_status => x_return_status

Line 1220: p_validation_mode => p_validation_mode, --JTF_PLSQL_API.g_update,

1216:
1217: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1218: Check_comp_prod_Items(
1219: p_comp_prod_rec => p_comp_prod_rec,
1220: p_validation_mode => p_validation_mode, --JTF_PLSQL_API.g_update,
1221: x_return_status => x_return_status
1222: );
1223:
1224: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1236: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1232: p_comp_prod_rec => p_comp_prod_rec,
1233: x_complete_rec => l_comp_prod_rec_type_rec
1234: );
1235:
1236: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1237: Validate_comp_prod_rec(
1238: p_api_version_number => 1.0,
1239: p_init_msg_list => FND_API.G_FALSE,
1240: x_return_status => x_return_status,