APPS.PV_GQ_ELEMENTS_PVT dependencies on JTF_PLSQL_API

Line 202: p_validation_mode => JTF_PLSQL_API.g_create,

198: Validate_gq_elements(
199: p_api_version_number => 1.0,
200: p_init_msg_list => FND_API.G_FALSE,
201: p_validation_level => p_validation_level,
202: p_validation_mode => JTF_PLSQL_API.g_create,
203: p_qsnr_element_rec => l_qsnr_element_rec,
204: x_return_status => x_return_status,
205: x_msg_count => x_msg_count,
206: x_msg_data => x_msg_data);

Line 796: p_validation_mode => JTF_PLSQL_API.g_update,

792: Validate_gq_elements(
793: p_api_version_number => 1.0,
794: p_init_msg_list => FND_API.G_FALSE,
795: p_validation_level => p_validation_level,
796: p_validation_mode => JTF_PLSQL_API.g_update,
797: p_qsnr_element_rec => p_qsnr_element_rec,
798: x_return_status => x_return_status,
799: x_msg_count => x_msg_count,
800: x_msg_data => x_msg_data);

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

1504:
1505:
1506: PROCEDURE check_Qsnr_Element_Uk_Items(
1507: p_qsnr_element_rec IN qsnr_element_rec_type,
1508: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1509: x_return_status OUT NOCOPY VARCHAR2)
1510: IS
1511: l_valid_flag VARCHAR2(1);
1512:

Line 1515: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1511: l_valid_flag VARCHAR2(1);
1512:
1513: BEGIN
1514: x_return_status := FND_API.g_ret_sts_success;
1515: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1516: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
1517: 'pv_ge_qsnr_elements_b',
1518: 'qsnr_element_id = ''' || p_qsnr_element_rec.qsnr_element_id ||''''
1519: );

Line 1530: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1526:
1527: -- Fixed for bug #3380368
1528: IF p_qsnr_element_rec.qsnr_elmt_type = 'QUESTION' and
1529: p_qsnr_element_rec.entity_attr_id is not null THEN
1530: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1531: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
1532: 'pv_ge_qsnr_elements_b',
1533: 'used_by_entity_id = ''' || p_qsnr_element_rec.used_by_entity_id ||''' AND entity_attr_id = ''' || p_qsnr_element_rec.entity_attr_id || '''');
1534:

Line 1539: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN

1535: IF l_valid_flag = FND_API.g_false THEN
1536: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_QSNR_PROFILE_ATTR_DUPLICATE');
1537: x_return_status := FND_API.g_ret_sts_error;
1538: END IF;
1539: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN
1540: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
1541: 'pv_ge_qsnr_elements_b',
1542: 'used_by_entity_id = ''' || p_qsnr_element_rec.used_by_entity_id ||''' AND entity_attr_id = ''' || p_qsnr_element_rec.entity_attr_id || ''' AND QSNR_ELEMENT_ID <> ''' || p_qsnr_element_rec.QSNR_ELEMENT_ID || '''');
1543:

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

1553:
1554:
1555: PROCEDURE check_Qsnr_Element_Req_Items(
1556: p_qsnr_element_rec IN qsnr_element_rec_type,
1557: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1558: x_return_status OUT NOCOPY VARCHAR2
1559: )
1560: IS
1561: BEGIN

Line 1564: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1560: IS
1561: BEGIN
1562: x_return_status := FND_API.g_ret_sts_success;
1563:
1564: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1565:
1566:
1567: IF p_qsnr_element_rec.qsnr_element_id = FND_API.G_MISS_NUM OR p_qsnr_element_rec.qsnr_element_id IS NULL THEN
1568: PVX_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'QSNR_ELEMENT_ID' );

Line 1994: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1990: PVX_UTILITY_PVT.debug_message('Check_qsnr_element_Items');
1991:
1992: END IF;
1993:
1994: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1995: Check_qsnr_element_Items(
1996: p_qsnr_element_rec => p_qsnr_element_rec,
1997: p_validation_mode => p_validation_mode,
1998: x_return_status => x_return_status

Line 2008: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

2004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2005: END IF;
2006: END IF;
2007:
2008: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2009: Default_Qsnr_Element_Items (p_qsnr_element_rec => p_qsnr_element_rec ,
2010: x_qsnr_element_rec => l_qsnr_element_rec) ;
2011: END IF ;
2012:

Line 2036: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

2032: PVX_UTILITY_PVT.debug_message('Validate_qsnr_element_Rec');
2033:
2034: END IF;
2035:
2036: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2037: Validate_qsnr_element_Rec(
2038: p_api_version_number => 1.0,
2039: p_init_msg_list => FND_API.G_FALSE,
2040: x_return_status => x_return_status,