[Home] [Help]
565: AMS_Utility_PVT.debug_message(l_api_name||': check items');
566:
567:
568: END IF;
569: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item
570: THEN
571: Validate_Agenda_Items
572: ( p_agenda_rec => l_agenda_rec,
573: p_validation_mode => JTF_PLSQL_API.g_update,
569: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item
570: THEN
571: Validate_Agenda_Items
572: ( p_agenda_rec => l_agenda_rec,
573: p_validation_mode => JTF_PLSQL_API.g_update,
574: x_return_status => l_return_status
575: );
576:
577: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
590: AMS_Utility_PVT.debug_message(l_full_name ||': check records');
591:
592: END IF;
593:
594: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record
595: THEN
596: validate_agenda_record(
597: p_agenda_rec => p_agenda_rec,
598: p_complete_rec => l_agenda_rec,
1399:
1400: AMS_Utility_PVT.debug_message(l_full_name||': check items');
1401:
1402: END IF;
1403: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item
1404: THEN
1405: Validate_Agenda_Items
1406: ( p_agenda_rec => l_agenda_rec,
1407: p_validation_mode => JTF_PLSQL_API.g_create,
1403: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item
1404: THEN
1405: Validate_Agenda_Items
1406: ( p_agenda_rec => l_agenda_rec,
1407: p_validation_mode => JTF_PLSQL_API.g_create,
1408: x_return_status => l_return_status
1409: );
1410:
1411: -- If any errors happen abort API.
1424: IF (AMS_DEBUG_HIGH_ON) THEN
1425:
1426: AMS_Utility_PVT.debug_message(l_full_name||': check record level');
1427: END IF;
1428: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record
1429: THEN
1430: Validate_Agenda_Record(
1431: p_agenda_rec => l_agenda_rec,
1432: x_return_status => l_return_status
1553: -- 02/20/2002 gmadana Created.
1554: /*****************************************************************************************/
1555: PROCEDURE check_agenda_uk_items(
1556: p_agenda_rec IN agenda_rec_type,
1557: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1558: x_return_status OUT NOCOPY VARCHAR2
1559: )
1560: IS
1561: l_valid_flag VARCHAR2(1);
1573:
1574: -- For create_agenda, when agenda_id is passed in, we need to
1575: -- check if this agenda_id is unique.
1576:
1577: IF p_validation_mode = JTF_PLSQL_API.g_create
1578: AND p_agenda_rec.agenda_id IS NOT NULL
1579: THEN
1580: IF AMS_Utility_PVT.check_uniqueness(
1581: 'ams_agendas_v',
1863: /*****************************************************************************************/
1864:
1865: PROCEDURE Validate_Agenda_Items
1866: ( p_agenda_rec IN agenda_rec_type,
1867: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1868: x_return_status OUT NOCOPY VARCHAR2
1869: ) IS
1870:
1871: l_table_name VARCHAR2(30);
1932: -- Also when the event is in active stage, changes to marketing message and
1933: -- budget related columns should not be allowed.
1934:
1935: /* IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message('before ok_items'); END IF;
1936: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
1937: check_evo_update_ok_items(
1938: p_agenda_rec => p_agenda_rec,
1939: x_return_status => x_return_status
1940: );
1943: RETURN;
1944: END IF;
1945: END IF; */
1946:
1947: /* IF p_validation_mode = JTF_PLSQL_API.g_update THEN
1948: open c_get_resource_dates(p_agenda_rec.agenda_id);
1949: fetch c_get_resource_dates into l_start_date, l_end_date;
1950: close c_get_resource_dates;
1951: if (p_agenda_rec.START_DATE_TIME > l_start_date