APPS.AMS_IBA_PL_SITES_PVT dependencies on JTF_PLSQL_API

Line 221: , p_validation_mode => JTF_PLSQL_API.g_create

217: , p_iba_pl_sites_rec => p_iba_pl_sites_rec
218: , x_return_status => x_return_status
219: , x_msg_count => x_msg_count
220: , x_msg_data => x_msg_data
221: , p_validation_mode => JTF_PLSQL_API.g_create
222: );
223: END IF;
224:
225: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

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

430: -- if (p_iba_pl_sites_rec.site_id < 10000)
431: -- then
432: -- l_sitename_changed := is_site_name_changed(
433: -- p_iba_pl_sites_rec => p_iba_pl_sites_rec
434: -- , p_validation_mode => JTF_PLSQL_API.g_update
435: -- , x_return_status => x_return_status
436: -- );
437: --
438: -- l_siterefcode_changed := is_site_ref_changed(

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

436: -- );
437: --
438: -- l_siterefcode_changed := is_site_ref_changed(
439: -- p_iba_pl_sites_rec => p_iba_pl_sites_rec
440: -- , p_validation_mode => JTF_PLSQL_API.g_update
441: -- , x_return_status => x_return_status
442: -- );
443: --
444: -- IF ((l_sitename_changed=fnd_api.g_true) or (l_siterefcode_changed = fnd_api.g_true))

Line 458: , p_validation_mode => JTF_PLSQL_API.g_update

454:
455: --Check if the site to be updated has any pages, if so, site_ref_code should not be modified.
456: l_site_pages := check_site_pages(
457: p_site_id => p_iba_pl_sites_rec.site_id
458: , p_validation_mode => JTF_PLSQL_API.g_update
459: , x_return_status => x_return_status
460: );
461:
462: IF (l_site_pages <> 0)

Line 466: , p_validation_mode => JTF_PLSQL_API.g_update

462: IF (l_site_pages <> 0)
463: THEN
464: l_siterefcode_changed := is_site_ref_changed(
465: p_iba_pl_sites_rec => p_iba_pl_sites_rec
466: , p_validation_mode => JTF_PLSQL_API.g_update
467: , x_return_status => x_return_status
468: );
469:
470: IF (l_siterefcode_changed = fnd_api.g_true)

Line 497: , p_validation_mode => JTF_PLSQL_API.g_update

493: , p_iba_pl_sites_rec => p_iba_pl_sites_rec
494: , x_return_status => x_return_status
495: , x_msg_count => x_msg_count
496: , x_msg_data => x_msg_data
497: , p_validation_mode => JTF_PLSQL_API.g_update
498: );
499: END IF;
500:
501: IF (AMS_DEBUG_HIGH_ON) THEN

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

917:
918:
919: PROCEDURE check_iba_pl_sites_uk_items(
920: p_iba_pl_sites_rec IN iba_pl_sites_rec_type
921: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
922: , x_return_status OUT NOCOPY VARCHAR2
923: )
924: IS
925: l_valid_flag VARCHAR2(1);

Line 933: if p_validation_mode = JTF_PLSQL_API.g_create then

929:
930: BEGIN
931: x_return_status := FND_API.g_ret_sts_success;
932: --If Validation_mode is create, check uniqueness of site_id, name, site_ref_code
933: if p_validation_mode = JTF_PLSQL_API.g_create then
934: -- Checking if the site id passed is unique
935: l_site_id_flag := ams_uTILITY_pvt.check_uniqueness(
936: 'ams_iba_pl_sites_b'
937: , 'site_id = ''' || p_iba_pl_sites_rec.site_id ||''''

Line 970: if p_validation_mode = JTF_PLSQL_API.g_update then

966: end if;
967: end if;
968:
969: --If Validation_mode is update, check uniqueness of site name, site_ref_code
970: if p_validation_mode = JTF_PLSQL_API.g_update then
971: -- Checking if the site name passed is unique
972: l_site_name_flag := ams_utility_pvt.check_uniqueness(
973: 'ams_iba_pl_sites_vl'
974: , 'name = ''' || p_iba_pl_sites_rec.name ||''' and site_id <> ' || p_iba_pl_sites_rec.site_id

Line 1008: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1004: IS
1005: BEGIN
1006: x_return_status := FND_API.g_ret_sts_success;
1007:
1008: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1009:
1010: ---------------
1011: -- sodixit : commenting the following lines as validation of the required fields for mode = create will be done in middle tier
1012: ---------------

Line 1347: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1343: THEN
1344: FND_MSG_PUB.initialize;
1345: END IF;
1346: -- sodixit : commenting following lines as site items will be checked in middle tier
1347: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1348: check_iba_pl_sites_items(
1349: p_iba_pl_sites_rec => p_iba_pl_sites_rec
1350: , p_validation_mode => p_validation_mode
1351: , x_return_status => x_return_status

Line 1366: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1362: p_iba_pl_sites_rec => p_iba_pl_sites_rec,
1363: x_complete_rec => l_iba_pl_sites_rec
1364: );
1365:
1366: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1367: validate_iba_pl_sites_rec(
1368: p_api_version_number => 1.0,
1369: p_init_msg_list => FND_API.G_FALSE,
1370: x_return_status => x_return_status,