eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_IBA_PL_PAGES_PVT dependencies on JTF_PLSQL_API

Line 204: , p_validation_mode => JTF_PLSQL_API.g_create

200: , p_iba_pl_pages_rec => p_iba_pl_pages_rec
201: , x_return_status => x_return_status
202: , x_msg_count => x_msg_count
203: , x_msg_data => x_msg_data
204: , p_validation_mode => JTF_PLSQL_API.g_create
205: );
206: END IF;
207:
208: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

Line 408: , p_validation_mode => JTF_PLSQL_API.g_update

404:
405: --Check if the page to be updated is being used in any of placements, if so, page_ref_code should not be modified.
406: l_page_placements := check_page_placements(
407: p_page_id => p_iba_pl_pages_rec.page_id
408: , p_validation_mode => JTF_PLSQL_API.g_update
409: , x_return_status => x_return_status
410: );
411:
412: IF (l_page_placements <> 0)

Line 416: , p_validation_mode => JTF_PLSQL_API.g_update

412: IF (l_page_placements <> 0)
413: THEN
414: l_pagerefcode_changed := is_page_ref_changed(
415: p_iba_pl_pages_rec => p_iba_pl_pages_rec
416: , p_validation_mode => JTF_PLSQL_API.g_update
417: , x_return_status => x_return_status
418: );
419:
420: IF (l_pagerefcode_changed = fnd_api.g_true)

Line 449: , p_validation_mode => JTF_PLSQL_API.g_update

445: , p_iba_pl_pages_rec => p_iba_pl_pages_rec
446: , x_return_status => x_return_status
447: , x_msg_count => x_msg_count
448: , x_msg_data => x_msg_data
449: , p_validation_mode => JTF_PLSQL_API.g_update
450: );
451: END IF;
452:
453: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

Line 599: , p_validation_mode => JTF_PLSQL_API.g_update

595:
596: --Check if the page to be deleted is being used in any of placements, if so, it should not be deleted.
597: l_page_placements := check_page_placements(
598: p_page_id => p_PAGE_ID
599: , p_validation_mode => JTF_PLSQL_API.g_update
600: , x_return_status => x_return_status
601: );
602:
603: IF (l_page_placements <> 0)

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

807:
808:
809: PROCEDURE check_iba_pl_pages_uk_items(
810: p_iba_pl_pages_rec IN iba_pl_pages_rec_type,
811: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
812: x_return_status OUT NOCOPY VARCHAR2)
813: IS
814: l_valid_flag VARCHAR2(1);
815: l_page_name_flag VARCHAR2(1);

Line 820: if p_validation_mode = JTF_PLSQL_API.g_create then

816: l_page_ref_code_flag VARCHAR2(1);
817: BEGIN
818: x_return_status := FND_API.g_ret_sts_success;
819: --If Validation_mode is create, check uniqueness of page_id, name, page_ref_code
820: if p_validation_mode = JTF_PLSQL_API.g_create then
821: -- Checking if the page name passed is unique
822: l_page_name_flag := ams_utility_pvt.check_uniqueness(
823: 'ams_iba_pl_pages_vl'
824: , 'name = ''' || p_iba_pl_pages_rec.name ||''' and site_ref_code = ''' || p_iba_pl_pages_rec.site_ref_code || ''''

Line 846: if p_validation_mode = JTF_PLSQL_API.g_update then

842: end if;
843: end if;
844:
845: --If Validation_mode is update, check uniqueness of page name, page_ref_code
846: if p_validation_mode = JTF_PLSQL_API.g_update then
847: -- Checking if the page name passed is unique
848: l_page_name_flag := ams_utility_pvt.check_uniqueness(
849: 'ams_iba_pl_pages_vl'
850: , 'name = ''' || p_iba_pl_pages_rec.name ||''' and page_id <> ' || p_iba_pl_pages_rec.page_id || ' and site_ref_code = ''' || p_iba_pl_pages_rec.site_ref_code || ''''

Line 875: -- IF p_validation_mode = JTF_PLSQL_API.g_create THEN

871: return;
872: end if;
873: end if;
874:
875: -- IF p_validation_mode = JTF_PLSQL_API.g_create THEN
876: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(
877: -- 'AMS_IBA_PL_PAGES_B',
878: -- 'PAGE_ID = ''' || p_iba_pl_pages_rec.PAGE_ID ||''''
879: -- );

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

894: END check_iba_pl_pages_uk_items;
895:
896: PROCEDURE check_iba_pl_pages_req_items(
897: p_iba_pl_pages_rec IN iba_pl_pages_rec_type,
898: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
899: x_return_status OUT NOCOPY VARCHAR2
900: )
901: IS
902: BEGIN

Line 905: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

901: IS
902: BEGIN
903: x_return_status := FND_API.g_ret_sts_success;
904:
905: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
906:
907:
908: IF p_iba_pl_pages_rec.page_id = FND_API.g_miss_num OR p_iba_pl_pages_rec.page_id IS NULL THEN
909: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_page_id');

Line 1223: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1219: IF FND_API.to_Boolean( p_init_msg_list )
1220: THEN
1221: FND_MSG_PUB.initialize;
1222: END IF;
1223: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1224: Check_iba_pl_pages_Items(
1225: p_iba_pl_pages_rec => p_iba_pl_pages_rec,
1226: p_validation_mode => p_validation_mode,
1227: x_return_status => x_return_status

Line 1242: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1238: p_iba_pl_pages_rec => p_iba_pl_pages_rec,
1239: x_complete_rec => l_iba_pl_pages_rec
1240: );
1241:
1242: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1243: Validate_iba_pl_pages_Rec(
1244: p_api_version_number => 1.0,
1245: p_init_msg_list => FND_API.G_FALSE,
1246: x_return_status => x_return_status,