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.OTA_EVT_BUS dependencies on OTA_EVENTS

Line 108: ,p_descflex_name => 'OTA_EVENTS'

104: -- b) During insert.
105: --
106: hr_dflex_utility.ins_or_upd_descflex_attribs
107: (p_appl_short_name => 'OTA'
108: ,p_descflex_name => 'OTA_EVENTS'
109: ,p_attribute_category => p_rec.evt_information_category
110: ,p_attribute1_name => 'EVT_INFORMATION1'
111: ,p_attribute1_value => p_rec.evt_information1
112: ,p_attribute2_name => 'EVT_INFORMATION2'

Line 172: ,ota_events evt

168: --
169: CURSOR csr_sec_grp IS
170: SELECT inf.org_information14
171: FROM hr_organization_information inf
172: ,ota_events evt
173: WHERE evt.event_id = p_event_id
174: AND inf.organization_id = evt.business_group_id
175: AND inf.org_information_context || '' = 'Business Group Information';
176:

Line 264: ota_events evt

260: --
261: cursor csr_leg_code is
262: select legislation_code
263: from per_business_groups_perf pbg,
264: ota_events evt
265: where pbg.business_group_id = evt.business_group_id
266: and evt.event_id = p_event_id;
267:
268:

Line 334: OTA_EVENTS EVT ,

330: cursor c1 is
331: select BST.TYPE
332: FROM OTA_BOOKING_STATUS_TYPES BST ,
333: PER_ALL_PEOPLE_F DEL ,
334: OTA_EVENTS EVT ,
335: OTA_DELEGATE_BOOKINGS TDB
336: where tdb.business_group_id = p_business_group_id
337: and evt.event_id = p_event_id
338: AND TDB.BOOKING_STATUS_TYPE_ID = BST.BOOKING_STATUS_TYPE_ID

Line 366: l_event_title ota_events.title%type := '';

362: -- Returns the program title if the event is partof a program
363: --
364: function get_prog_title (p_event_id in number) return varchar2 is
365: --
366: l_event_title ota_events.title%type := '';
367: --
368: cursor c1 is
369: select a.title
370: from ota_events_tl a,

Line 370: from ota_events_tl a,

366: l_event_title ota_events.title%type := '';
367: --
368: cursor c1 is
369: select a.title
370: from ota_events_tl a,
371: ota_program_memberships b
372: where a.event_id = b.program_event_id
373: and b.event_id = p_event_id
374: and a.language = USERENV('LANG');

Line 397: procedure check_price_basis(p_event_id in ota_events.event_id%TYPE,

393: -- Description:
394: -- Checks whether the amount field has been filled in when we are dealing
395: -- with a student priced event.
396: --
397: procedure check_price_basis(p_event_id in ota_events.event_id%TYPE,
398: p_price_basis in ota_events.price_basis%TYPE,
399: p_parent_offering_id in ota_events.parent_offering_id%TYPE,
400: p_max_internal_attendees in ota_events.maximum_internal_attendees%TYPE) is
401: --

Line 398: p_price_basis in ota_events.price_basis%TYPE,

394: -- Checks whether the amount field has been filled in when we are dealing
395: -- with a student priced event.
396: --
397: procedure check_price_basis(p_event_id in ota_events.event_id%TYPE,
398: p_price_basis in ota_events.price_basis%TYPE,
399: p_parent_offering_id in ota_events.parent_offering_id%TYPE,
400: p_max_internal_attendees in ota_events.maximum_internal_attendees%TYPE) is
401: --
402: l_proc varchar2(30) := 'check_price_basis';

Line 399: p_parent_offering_id in ota_events.parent_offering_id%TYPE,

395: -- with a student priced event.
396: --
397: procedure check_price_basis(p_event_id in ota_events.event_id%TYPE,
398: p_price_basis in ota_events.price_basis%TYPE,
399: p_parent_offering_id in ota_events.parent_offering_id%TYPE,
400: p_max_internal_attendees in ota_events.maximum_internal_attendees%TYPE) is
401: --
402: l_proc varchar2(30) := 'check_price_basis';
403: l_dummy VARCHAR2(30);

Line 400: p_max_internal_attendees in ota_events.maximum_internal_attendees%TYPE) is

396: --
397: procedure check_price_basis(p_event_id in ota_events.event_id%TYPE,
398: p_price_basis in ota_events.price_basis%TYPE,
399: p_parent_offering_id in ota_events.parent_offering_id%TYPE,
400: p_max_internal_attendees in ota_events.maximum_internal_attendees%TYPE) is
401: --
402: l_proc varchar2(30) := 'check_price_basis';
403: l_dummy VARCHAR2(30);
404:

Line 477: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS',

473: hr_utility.set_location('Leaving '||l_proc,10);
474: --
475: EXCEPTION
476: WHEN app_exception.application_exception THEN
477: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS',
478: p_associated_column2 => 'OTA_EVENTS.STANDARD_PRICE') THEN
479: hr_utility.set_location(' Leaving:'||l_proc, 40);
480: RAISE;
481: END IF;

Line 478: p_associated_column2 => 'OTA_EVENTS.STANDARD_PRICE') THEN

474: --
475: EXCEPTION
476: WHEN app_exception.application_exception THEN
477: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS',
478: p_associated_column2 => 'OTA_EVENTS.STANDARD_PRICE') THEN
479: hr_utility.set_location(' Leaving:'||l_proc, 40);
480: RAISE;
481: END IF;
482: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 519: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS',

515: hr_utility.set_location('Leaving '||l_proc,10);
516: --
517: EXCEPTION
518: WHEN app_exception.application_exception THEN
519: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS',
520: p_associated_column2 => 'OTA_EVENTS.STANDARD_PRICE') THEN
521: hr_utility.set_location(' Leaving:'||l_proc, 40);
522: RAISE;
523: END IF;

Line 520: p_associated_column2 => 'OTA_EVENTS.STANDARD_PRICE') THEN

516: --
517: EXCEPTION
518: WHEN app_exception.application_exception THEN
519: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS',
520: p_associated_column2 => 'OTA_EVENTS.STANDARD_PRICE') THEN
521: hr_utility.set_location(' Leaving:'||l_proc, 40);
522: RAISE;
523: END IF;
524: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 546: ota_events evt

542: --
543: cursor c1 is
544: select null
545: from ota_program_memberships mem,
546: ota_events evt
547: where mem.program_event_id = p_event_id
548: and mem.event_id = evt.event_id
549: and evt.event_status = 'P';
550: --

Line 716: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_STATUS') THEN

712: end if;
713: hr_utility.set_location(' Leaving:'||l_proc,10);
714: EXCEPTION
715: WHEN app_exception.application_exception THEN
716: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_STATUS') THEN
717: hr_utility.set_location(' Leaving:'||l_proc, 40);
718: RAISE;
719: END IF;
720: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 833: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PUBLIC_EVENT_FLAG') THEN

829: --
830: hr_utility.set_location(' Leaving:'||l_proc,10);
831: EXCEPTION
832: WHEN app_exception.application_exception THEN
833: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PUBLIC_EVENT_FLAG') THEN
834: hr_utility.set_location(' Leaving:'||l_proc, 40);
835: RAISE;
836: END IF;
837: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 887: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ENROLMENT_START_DATE',

883: hr_utility.set_location(' Exitting:'||l_proc,10);
884: --
885: EXCEPTION
886: WHEN app_exception.application_exception THEN
887: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ENROLMENT_START_DATE',
888: p_associated_column2 => 'OTA_EVENTS.ENROLMENT_END_DATE') THEN
889: hr_utility.set_location(' Leaving:'||l_proc, 40);
890: RAISE;
891: END IF;

Line 888: p_associated_column2 => 'OTA_EVENTS.ENROLMENT_END_DATE') THEN

884: --
885: EXCEPTION
886: WHEN app_exception.application_exception THEN
887: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ENROLMENT_START_DATE',
888: p_associated_column2 => 'OTA_EVENTS.ENROLMENT_END_DATE') THEN
889: hr_utility.set_location(' Leaving:'||l_proc, 40);
890: RAISE;
891: END IF;
892: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 999: procedure chk_start_date( p_course_start_date IN ota_events.course_start_date%TYPE,

995: --
996: -- Checks if start date is null when start time is not null
997: --
998: --
999: procedure chk_start_date( p_course_start_date IN ota_events.course_start_date%TYPE,
1000: p_course_start_time IN ota_events.course_start_time%TYPE)
1001: is
1002: l_proc varchar2(30) := 'chk_start_date';
1003: begin

Line 1000: p_course_start_time IN ota_events.course_start_time%TYPE)

996: -- Checks if start date is null when start time is not null
997: --
998: --
999: procedure chk_start_date( p_course_start_date IN ota_events.course_start_date%TYPE,
1000: p_course_start_time IN ota_events.course_start_time%TYPE)
1001: is
1002: l_proc varchar2(30) := 'chk_start_date';
1003: begin
1004: hr_utility.set_location('Entering:'||l_proc,10);

Line 1015: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN

1011: hr_utility.set_location('Leaving:'||l_proc,20);
1012:
1013: EXCEPTION
1014: WHEN app_exception.application_exception THEN
1015: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1016: hr_utility.set_location(' Leaving:'||l_proc, 40);
1017: RAISE;
1018: END IF;
1019: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 1032: procedure CHK_END_DATE( p_course_end_date IN ota_events.course_end_date%TYPE,

1028: --
1029: -- Checks if end date is not null when end time is not null
1030: --
1031: --
1032: procedure CHK_END_DATE( p_course_end_date IN ota_events.course_end_date%TYPE,
1033: p_course_end_time IN ota_events.course_end_time%TYPE)
1034: is
1035: l_proc varchar2(30) := 'chk_end_date';
1036: begin

Line 1033: p_course_end_time IN ota_events.course_end_time%TYPE)

1029: -- Checks if end date is not null when end time is not null
1030: --
1031: --
1032: procedure CHK_END_DATE( p_course_end_date IN ota_events.course_end_date%TYPE,
1033: p_course_end_time IN ota_events.course_end_time%TYPE)
1034: is
1035: l_proc varchar2(30) := 'chk_end_date';
1036: begin
1037: hr_utility.set_location('Entering:'||l_proc,10);

Line 1047: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_END_TIME') THEN

1043: hr_utility.set_location('Leaving:'||l_proc,20);
1044:
1045: EXCEPTION
1046: WHEN app_exception.application_exception THEN
1047: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_END_TIME') THEN
1048: hr_utility.set_location(' Leaving:'||l_proc, 40);
1049: RAISE;
1050: END IF;
1051: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 1422: from ota_events

1418: l_dummy varchar2(30);
1419: --
1420: cursor check_dates is
1421: select null
1422: from ota_events
1423: where parent_event_id = p_event_id
1424: and event_type = 'SESSION'
1425: and (course_start_date < nvl(p_course_start_date,hr_api.g_sot)
1426: or course_start_date > nvl(p_course_end_date,hr_api.g_eot));

Line 1431: from ota_events

1427: --
1428: /*
1429: cursor check_course_null_dates is
1430: select 'X'
1431: from ota_events
1432: where parent_event_id = p_event_id
1433: and event_type = 'SESSION';
1434: */
1435: begin

Line 1490: from OTA_EVENTS_VL EVT

1486: W_TITLE_IS_UNIQUE boolean;
1487: --
1488: cursor C1 is
1489: select 1
1490: from OTA_EVENTS_VL EVT
1491: where EVT.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
1492: and ( (P_PARENT_EVENT_ID is null )
1493: or (EVT.PARENT_EVENT_ID = P_PARENT_EVENT_ID))
1494: and upper (EVT.TITLE) = upper (P_TITLE)

Line 1559: OTA_EVT_SHD.CONSTRAINT_ERROR ('OTA_EVENTS_UK2');

1555: P_TITLE => P_TITLE,
1556: P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID,
1557: P_PARENT_EVENT_ID => P_PARENT_EVENT_ID,
1558: P_EVENT_ID => P_EVENT_ID)) then
1559: OTA_EVT_SHD.CONSTRAINT_ERROR ('OTA_EVENTS_UK2');
1560: end if;
1561: --
1562: end if;
1563: --

Line 1568: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TITLE') THEN

1564: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
1565: --
1566: EXCEPTION
1567: WHEN app_exception.application_exception THEN
1568: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TITLE') THEN
1569: hr_utility.set_location(' Leaving:'||W_PROC, 40);
1570: RAISE;
1571: END IF;
1572: hr_utility.set_location(' Leaving:'||W_PROC, 50);

Line 1597: FROM ota_events

1593: SELECT course_start_date,
1594: course_start_time,
1595: course_end_date,
1596: course_end_time
1597: FROM ota_events
1598: WHERE event_id = p_parent_event_id;
1599:
1600: l_course_start_date ota_events.course_start_date%type;
1601: l_course_start_time ota_events.course_start_time%type;

Line 1600: l_course_start_date ota_events.course_start_date%type;

1596: course_end_time
1597: FROM ota_events
1598: WHERE event_id = p_parent_event_id;
1599:
1600: l_course_start_date ota_events.course_start_date%type;
1601: l_course_start_time ota_events.course_start_time%type;
1602: l_course_end_date ota_events.course_start_date%type;
1603: l_course_end_time ota_events.course_start_time%type;
1604:

Line 1601: l_course_start_time ota_events.course_start_time%type;

1597: FROM ota_events
1598: WHERE event_id = p_parent_event_id;
1599:
1600: l_course_start_date ota_events.course_start_date%type;
1601: l_course_start_time ota_events.course_start_time%type;
1602: l_course_end_date ota_events.course_start_date%type;
1603: l_course_end_time ota_events.course_start_time%type;
1604:
1605: w_proc constant varchar2(72) := G_PACKAGE||'check_session_time';

Line 1602: l_course_end_date ota_events.course_start_date%type;

1598: WHERE event_id = p_parent_event_id;
1599:
1600: l_course_start_date ota_events.course_start_date%type;
1601: l_course_start_time ota_events.course_start_time%type;
1602: l_course_end_date ota_events.course_start_date%type;
1603: l_course_end_time ota_events.course_start_time%type;
1604:
1605: w_proc constant varchar2(72) := G_PACKAGE||'check_session_time';
1606:

Line 1603: l_course_end_time ota_events.course_start_time%type;

1599:
1600: l_course_start_date ota_events.course_start_date%type;
1601: l_course_start_time ota_events.course_start_time%type;
1602: l_course_end_date ota_events.course_start_date%type;
1603: l_course_end_time ota_events.course_start_time%type;
1604:
1605: w_proc constant varchar2(72) := G_PACKAGE||'check_session_time';
1606:
1607: BEGIN

Line 1708: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN

1704: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);
1705:
1706: EXCEPTION
1707: WHEN app_exception.application_exception THEN
1708: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1709: hr_utility.set_location(' Leaving:'||w_proc, 60);
1710: RAISE;
1711: END IF;
1712: hr_utility.set_location(' Leaving:'||w_proc, 70);

Line 1800: from ota_events

1796: l_sessions_invalidated boolean;
1797: --
1798: cursor csr_invalid_sessions is
1799: select 1
1800: from ota_events
1801: where parent_event_id = p_event_id
1802: and event_type = 'SESSION'
1803: and course_start_date
1804: not between p_course_start_date

Line 1841: PROCEDURE check_class_session_times ( p_event_id IN ota_events.event_id%TYPE,

1837: -- This procedure checks if the session time is between the parent start
1838: -- and end time.
1839: --
1840: --------------------------------------------------------------------------------
1841: PROCEDURE check_class_session_times ( p_event_id IN ota_events.event_id%TYPE,
1842: p_course_start_date IN ota_events.course_start_date%TYPE,
1843: p_course_start_time IN ota_events.course_start_time%TYPE,
1844: p_course_end_date IN ota_events.course_end_date%TYPE,
1845: p_course_end_time IN ota_events.course_end_time%TYPE) is

Line 1842: p_course_start_date IN ota_events.course_start_date%TYPE,

1838: -- and end time.
1839: --
1840: --------------------------------------------------------------------------------
1841: PROCEDURE check_class_session_times ( p_event_id IN ota_events.event_id%TYPE,
1842: p_course_start_date IN ota_events.course_start_date%TYPE,
1843: p_course_start_time IN ota_events.course_start_time%TYPE,
1844: p_course_end_date IN ota_events.course_end_date%TYPE,
1845: p_course_end_time IN ota_events.course_end_time%TYPE) is
1846: --

Line 1843: p_course_start_time IN ota_events.course_start_time%TYPE,

1839: --
1840: --------------------------------------------------------------------------------
1841: PROCEDURE check_class_session_times ( p_event_id IN ota_events.event_id%TYPE,
1842: p_course_start_date IN ota_events.course_start_date%TYPE,
1843: p_course_start_time IN ota_events.course_start_time%TYPE,
1844: p_course_end_date IN ota_events.course_end_date%TYPE,
1845: p_course_end_time IN ota_events.course_end_time%TYPE) is
1846: --
1847: CURSOR get_ssn_times_cr is

Line 1844: p_course_end_date IN ota_events.course_end_date%TYPE,

1840: --------------------------------------------------------------------------------
1841: PROCEDURE check_class_session_times ( p_event_id IN ota_events.event_id%TYPE,
1842: p_course_start_date IN ota_events.course_start_date%TYPE,
1843: p_course_start_time IN ota_events.course_start_time%TYPE,
1844: p_course_end_date IN ota_events.course_end_date%TYPE,
1845: p_course_end_time IN ota_events.course_end_time%TYPE) is
1846: --
1847: CURSOR get_ssn_times_cr is
1848: SELECT course_start_date,

Line 1845: p_course_end_time IN ota_events.course_end_time%TYPE) is

1841: PROCEDURE check_class_session_times ( p_event_id IN ota_events.event_id%TYPE,
1842: p_course_start_date IN ota_events.course_start_date%TYPE,
1843: p_course_start_time IN ota_events.course_start_time%TYPE,
1844: p_course_end_date IN ota_events.course_end_date%TYPE,
1845: p_course_end_time IN ota_events.course_end_time%TYPE) is
1846: --
1847: CURSOR get_ssn_times_cr is
1848: SELECT course_start_date,
1849: course_start_time,

Line 1852: FROM ota_events

1848: SELECT course_start_date,
1849: course_start_time,
1850: course_end_date,
1851: course_end_time
1852: FROM ota_events
1853: WHERE parent_event_id = p_event_id
1854: AND event_type = 'SESSION';
1855:
1856: l_ssn_start_date ota_events.course_start_date%type;

Line 1856: l_ssn_start_date ota_events.course_start_date%type;

1852: FROM ota_events
1853: WHERE parent_event_id = p_event_id
1854: AND event_type = 'SESSION';
1855:
1856: l_ssn_start_date ota_events.course_start_date%type;
1857: l_ssn_start_time ota_events.course_start_time%type;
1858: l_ssn_end_date ota_events.course_start_date%type;
1859: l_ssn_end_time ota_events.course_start_time%type;
1860:

Line 1857: l_ssn_start_time ota_events.course_start_time%type;

1853: WHERE parent_event_id = p_event_id
1854: AND event_type = 'SESSION';
1855:
1856: l_ssn_start_date ota_events.course_start_date%type;
1857: l_ssn_start_time ota_events.course_start_time%type;
1858: l_ssn_end_date ota_events.course_start_date%type;
1859: l_ssn_end_time ota_events.course_start_time%type;
1860:
1861: w_proc constant varchar2(72) := G_PACKAGE||'check_class_session_times';

Line 1858: l_ssn_end_date ota_events.course_start_date%type;

1854: AND event_type = 'SESSION';
1855:
1856: l_ssn_start_date ota_events.course_start_date%type;
1857: l_ssn_start_time ota_events.course_start_time%type;
1858: l_ssn_end_date ota_events.course_start_date%type;
1859: l_ssn_end_time ota_events.course_start_time%type;
1860:
1861: w_proc constant varchar2(72) := G_PACKAGE||'check_class_session_times';
1862:

Line 1859: l_ssn_end_time ota_events.course_start_time%type;

1855:
1856: l_ssn_start_date ota_events.course_start_date%type;
1857: l_ssn_start_time ota_events.course_start_time%type;
1858: l_ssn_end_date ota_events.course_start_date%type;
1859: l_ssn_end_time ota_events.course_start_time%type;
1860:
1861: w_proc constant varchar2(72) := G_PACKAGE||'check_class_session_times';
1862:
1863: BEGIN

Line 1925: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN

1921: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);
1922:
1923: EXCEPTION
1924: WHEN app_exception.application_exception THEN
1925: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1926: hr_utility.set_location(' Leaving:'||w_proc, 60);
1927: RAISE;
1928: END IF;
1929: hr_utility.set_location(' Leaving:'||w_proc, 70);

Line 2001: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE',

1997: end if;
1998: --
1999: EXCEPTION
2000: WHEN app_exception.application_exception THEN
2001: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE',
2002: p_associated_column2 => 'OTA_EVENTS.COURSE_END_DATE') THEN
2003: hr_utility.set_location(' Leaving:'||w_proc, 40);
2004: RAISE;
2005: END IF;

Line 2002: p_associated_column2 => 'OTA_EVENTS.COURSE_END_DATE') THEN

1998: --
1999: EXCEPTION
2000: WHEN app_exception.application_exception THEN
2001: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE',
2002: p_associated_column2 => 'OTA_EVENTS.COURSE_END_DATE') THEN
2003: hr_utility.set_location(' Leaving:'||w_proc, 40);
2004: RAISE;
2005: END IF;
2006: hr_utility.set_location(' Leaving:'||w_proc, 50);

Line 2036: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.BUDGET_COST',

2032: hr_utility.set_location(' Leaving:'|| v_proc, 10);
2033: --
2034: EXCEPTION
2035: WHEN app_exception.application_exception THEN
2036: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.BUDGET_COST',
2037: p_associated_column2 => 'OTA_EVENTS.BUDGET_CURRENCY_CODE',
2038: p_associated_column3 => 'OTA_EVENTS.ACTUAL_COST') THEN
2039: hr_utility.set_location(' Leaving:'||v_proc, 40);
2040: RAISE;

Line 2037: p_associated_column2 => 'OTA_EVENTS.BUDGET_CURRENCY_CODE',

2033: --
2034: EXCEPTION
2035: WHEN app_exception.application_exception THEN
2036: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.BUDGET_COST',
2037: p_associated_column2 => 'OTA_EVENTS.BUDGET_CURRENCY_CODE',
2038: p_associated_column3 => 'OTA_EVENTS.ACTUAL_COST') THEN
2039: hr_utility.set_location(' Leaving:'||v_proc, 40);
2040: RAISE;
2041: END IF;

Line 2038: p_associated_column3 => 'OTA_EVENTS.ACTUAL_COST') THEN

2034: EXCEPTION
2035: WHEN app_exception.application_exception THEN
2036: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.BUDGET_COST',
2037: p_associated_column2 => 'OTA_EVENTS.BUDGET_CURRENCY_CODE',
2038: p_associated_column3 => 'OTA_EVENTS.ACTUAL_COST') THEN
2039: hr_utility.set_location(' Leaving:'||v_proc, 40);
2040: RAISE;
2041: END IF;
2042: hr_utility.set_location(' Leaving:'||v_proc, 50);

Line 2098: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE') THEN

2094: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
2095: --
2096: EXCEPTION
2097: WHEN app_exception.application_exception THEN
2098: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE') THEN
2099: hr_utility.set_location(' Leaving:'||w_proc, 40);
2100: RAISE;
2101: END IF;
2102: hr_utility.set_location(' Leaving:'||w_proc, 50);

Line 2233: from ota_events

2229: --
2230: cursor csr_programme_dates is
2231: --
2232: select 1
2233: from ota_events
2234: where event_id = p_parent_event_id
2235: and (p_enrolment_start_date not between enrolment_start_date
2236: and enrolment_end_date
2237: or p_enrolment_end_date not between enrolment_start_date

Line 2243: from ota_events

2239: --
2240: cursor csr_member_dates is
2241: --
2242: select 1
2243: from ota_events
2244: where parent_event_id = p_event_id
2245: and ((p_enrolment_start_date not between enrolment_start_date
2246: and enrolment_end_date)
2247: or(p_enrolment_end_date not between enrolment_start_date

Line 2388: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS') THEN

2384: --
2385: hr_utility.set_location ('Leaving:'||l_proc,10);
2386: EXCEPTION
2387: WHEN app_exception.application_exception THEN
2388: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS') THEN
2389: hr_utility.set_location(' Leaving:'||l_proc, 40);
2390: RAISE;
2391: END IF;
2392: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 2800: from ota_events

2796: -- cursor to check if sessions exist for the event
2797: --
2798: Cursor c_session_details is
2799: select 'X'
2800: from ota_events
2801: where parent_event_id = p_event_id;
2802: --
2803: -- cursor to check if resources exist for the event
2804: --

Line 3063: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_ID') THEN

3059:
3060: hr_utility.set_location(' Leaving:'||l_proc, 10);
3061: EXCEPTION
3062: WHEN app_exception.application_exception THEN
3063: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_ID') THEN
3064: hr_utility.set_location(' Leaving:'||l_proc, 70);
3065: RAISE;
3066: END IF;
3067: hr_utility.set_location(' Leaving:'||l_proc, 80);

Line 3186: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OWNER_ID') THEN

3182: END IF;
3183: End if;
3184: EXCEPTION
3185: WHEN app_exception.application_exception THEN
3186: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OWNER_ID') THEN
3187: hr_utility.set_location(' Leaving:'||l_proc, 40);
3188: RAISE;
3189: END IF;
3190: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 3238: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN

3234: end if;
3235: hr_utility.set_location('Entering:'||l_proc, 30);
3236: EXCEPTION
3237: WHEN app_exception.application_exception THEN
3238: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3239: hr_utility.set_location(' Leaving:'||l_proc, 40);
3240: RAISE;
3241: END IF;
3242: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 3386: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN

3382: end if;
3383: hr_utility.set_location('Leaving:'||l_proc, 30);
3384: EXCEPTION
3385: WHEN app_exception.application_exception THEN
3386: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3387: hr_utility.set_location(' Leaving:'||l_proc, 40);
3388: RAISE;
3389: END IF;
3390: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 3442: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TRAINING_CENTER_ID') THEN

3438: end if;
3439: hr_utility.set_location('Entering:'||l_proc, 30);
3440: EXCEPTION
3441: WHEN app_exception.application_exception THEN
3442: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TRAINING_CENTER_ID') THEN
3443: hr_utility.set_location(' Leaving:'||l_proc, 40);
3444: RAISE;
3445: END IF;
3446: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 3500: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LOCATION_ID') THEN

3496: end if;
3497: hr_utility.set_location('Entering:'||l_proc, 30);
3498: EXCEPTION
3499: WHEN app_exception.application_exception THEN
3500: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LOCATION_ID') THEN
3501: hr_utility.set_location(' Leaving:'||l_proc, 40);
3502: RAISE;
3503: END IF;
3504: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 3531: from ota_events

3527: l_exists varchar2(1);
3528:
3529: cursor csr_offering is
3530: select null
3531: from ota_events
3532: where offering_id = p_offering_id;
3533:
3534: Begin
3535:

Line 3549: ota_evt_shd.constraint_error(p_constraint_name =>'OTA_EVENTS_UK4');

3545: hr_utility.set_location('Entering:'||l_proc, 15);
3546: open csr_offering;
3547: fetch csr_offering into l_exists;
3548: if csr_offering%found then
3549: ota_evt_shd.constraint_error(p_constraint_name =>'OTA_EVENTS_UK4');
3550: end if;
3551: close csr_offering;
3552: hr_utility.set_location('Leaving:'||l_proc, 20);
3553: end if;

Line 3558: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OFFERING_ID') THEN

3554: end if;
3555: hr_utility.set_location('Leaving:'||l_proc, 30);
3556: EXCEPTION
3557: WHEN app_exception.application_exception THEN
3558: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OFFERING_ID') THEN
3559: hr_utility.set_location(' Leaving:'||l_proc, 70);
3560: RAISE;
3561: END IF;
3562: hr_utility.set_location(' Leaving:'||l_proc, 80);

Line 3608: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ACTIVITY_VERSION_ID') THEN

3604: close csr_offering;
3605: hr_utility.set_location('Leaving:'||l_proc, 20);
3606: EXCEPTION
3607: WHEN app_exception.application_exception THEN
3608: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ACTIVITY_VERSION_ID') THEN
3609: hr_utility.set_location(' Leaving:'||l_proc, 70);
3610: RAISE;
3611: END IF;
3612: hr_utility.set_location(' Leaving:'||l_proc, 80);

Line 3670: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.SECURE_EVENT_FLAG') THEN

3666: hr_utility.set_location('Leaving:'||l_proc, 20);
3667:
3668: EXCEPTION
3669: WHEN app_exception.application_exception THEN
3670: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.SECURE_EVENT_FLAG') THEN
3671: hr_utility.set_location('Leaving:'||l_proc, 40);
3672: RAISE;
3673: END IF;
3674: hr_utility.set_location('Leaving:'||l_proc, 50);