[Home] [Help]
85: -- Check_Venue_UK_Items
86: PROCEDURE Check_Venue_UK_Items (
87: p_venue_rec IN Venue_Rec_Type,
88: p_object_type IN VARCHAR2,
89: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
90: x_return_status OUT NOCOPY VARCHAR2
91: );
92:
93: -- Check_Venue_FK_Items
1338: -- for the upcoming update call.
1339:
1340:
1341: /* -- batoleti
1342: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1343: Check_Venue_Items (
1344: p_venue_rec => p_venue_rec,
1345: p_object_type => p_object_type,
1346: p_validation_mode => JTF_PLSQL_API.g_update,
1342: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1343: Check_Venue_Items (
1344: p_venue_rec => p_venue_rec,
1345: p_object_type => p_object_type,
1346: p_validation_mode => JTF_PLSQL_API.g_update,
1347: x_return_status => l_return_status
1348: );
1349:
1350: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1353: RAISE FND_API.g_exc_error;
1354: END IF;
1355: END IF;
1356:
1357: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1358: Check_Venue_Record (
1359: p_venue_rec => p_venue_rec,
1360: p_complete_rec => l_venue_rec,
1361: x_return_status => l_return_status
1826:
1827: AMS_Utility_PVT.debug_message (l_full_name || ': Check items');
1828: END IF;
1829:
1830: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1831: Check_Venue_Items (
1832: p_venue_rec => p_venue_rec,
1833: p_object_type => p_object_type,
1834: p_validation_mode => JTF_PLSQL_API.g_create,
1830: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1831: Check_Venue_Items (
1832: p_venue_rec => p_venue_rec,
1833: p_object_type => p_object_type,
1834: p_validation_mode => JTF_PLSQL_API.g_create,
1835: x_return_status => l_return_status
1836: );
1837:
1838: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1849: AMS_Utility_PVT.debug_message (l_full_name || ': Check record');
1850:
1851: END IF;
1852:
1853: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1854: Check_Venue_Record (
1855: p_venue_rec => p_venue_rec,
1856: p_complete_rec => NULL,
1857: x_return_status => l_return_status
1915: ---------------------------------------------------------------------
1916: PROCEDURE Check_Venue_Items (
1917: p_venue_rec IN Venue_Rec_Type,
1918: p_object_type IN VARCHAR2,
1919: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1920: x_return_status OUT NOCOPY VARCHAR2
1921: )
1922: IS
1923: BEGIN
2488: -- Check_Venue_UK_Items
2489: PROCEDURE Check_Venue_UK_Items (
2490: p_venue_rec IN Venue_Rec_Type,
2491: p_object_type IN VARCHAR2,
2492: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2493: x_return_status OUT NOCOPY VARCHAR2
2494: )
2495: IS
2496: l_valid_flag VARCHAR2(1);
2514:
2515: -- VENUE_ID
2516: -- For Create_Venue, when ID is passed in, we need to
2517: -- check if this ID is unique.
2518: IF p_validation_mode = JTF_PLSQL_API.g_create
2519: AND p_venue_rec.venue_id IS NOT NULL
2520: THEN
2521: IF AMS_Utility_PVT.check_uniqueness(
2522: 'ams_venues_vl',
2535: END IF;
2536:
2537: -- VENUE_NAME
2538: /*
2539: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2540: open c_vnu_name_crt(p_venue_rec.venue_name);
2541: fetch c_vnu_name_crt into l_dummy;
2542: close c_vnu_name_crt;
2543: bug # 1490374
2560: END IF;
2561: */
2562:
2563: /* FIX FOR BUG #1625651 DO THE FOLLOWING BLOCK FOR CREATE */
2564: IF ( (p_validation_mode = JTF_PLSQL_API.g_create OR p_validation_mode = JTF_PLSQL_API.g_update )
2565: AND (p_object_type = 'ROOM')
2566: )
2567: THEN
2568: