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 1689: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN

1685: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);
1686:
1687: EXCEPTION
1688: WHEN app_exception.application_exception THEN
1689: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1690: hr_utility.set_location(' Leaving:'||w_proc, 60);
1691: RAISE;
1692: END IF;
1693: hr_utility.set_location(' Leaving:'||w_proc, 70);

Line 1781: from ota_events

1777: l_sessions_invalidated boolean;
1778: --
1779: cursor csr_invalid_sessions is
1780: select 1
1781: from ota_events
1782: where parent_event_id = p_event_id
1783: and event_type = 'SESSION'
1784: and course_start_date
1785: not between p_course_start_date

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

1818: -- This procedure checks if the session time is between the parent start
1819: -- and end time.
1820: --
1821: --------------------------------------------------------------------------------
1822: PROCEDURE check_class_session_times ( p_event_id IN ota_events.event_id%TYPE,
1823: p_course_start_date IN ota_events.course_start_date%TYPE,
1824: p_course_start_time IN ota_events.course_start_time%TYPE,
1825: p_course_end_date IN ota_events.course_end_date%TYPE,
1826: p_course_end_time IN ota_events.course_end_time%TYPE) is

Line 1823: p_course_start_date IN ota_events.course_start_date%TYPE,

1819: -- and end time.
1820: --
1821: --------------------------------------------------------------------------------
1822: PROCEDURE check_class_session_times ( p_event_id IN ota_events.event_id%TYPE,
1823: p_course_start_date IN ota_events.course_start_date%TYPE,
1824: p_course_start_time IN ota_events.course_start_time%TYPE,
1825: p_course_end_date IN ota_events.course_end_date%TYPE,
1826: p_course_end_time IN ota_events.course_end_time%TYPE) is
1827: --

Line 1824: p_course_start_time IN ota_events.course_start_time%TYPE,

1820: --
1821: --------------------------------------------------------------------------------
1822: PROCEDURE check_class_session_times ( p_event_id IN ota_events.event_id%TYPE,
1823: p_course_start_date IN ota_events.course_start_date%TYPE,
1824: p_course_start_time IN ota_events.course_start_time%TYPE,
1825: p_course_end_date IN ota_events.course_end_date%TYPE,
1826: p_course_end_time IN ota_events.course_end_time%TYPE) is
1827: --
1828: CURSOR get_ssn_times_cr is

Line 1825: p_course_end_date IN ota_events.course_end_date%TYPE,

1821: --------------------------------------------------------------------------------
1822: PROCEDURE check_class_session_times ( p_event_id IN ota_events.event_id%TYPE,
1823: p_course_start_date IN ota_events.course_start_date%TYPE,
1824: p_course_start_time IN ota_events.course_start_time%TYPE,
1825: p_course_end_date IN ota_events.course_end_date%TYPE,
1826: p_course_end_time IN ota_events.course_end_time%TYPE) is
1827: --
1828: CURSOR get_ssn_times_cr is
1829: SELECT course_start_date,

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

1822: PROCEDURE check_class_session_times ( p_event_id IN ota_events.event_id%TYPE,
1823: p_course_start_date IN ota_events.course_start_date%TYPE,
1824: p_course_start_time IN ota_events.course_start_time%TYPE,
1825: p_course_end_date IN ota_events.course_end_date%TYPE,
1826: p_course_end_time IN ota_events.course_end_time%TYPE) is
1827: --
1828: CURSOR get_ssn_times_cr is
1829: SELECT course_start_date,
1830: course_start_time,

Line 1833: FROM ota_events

1829: SELECT course_start_date,
1830: course_start_time,
1831: course_end_date,
1832: course_end_time
1833: FROM ota_events
1834: WHERE parent_event_id = p_event_id
1835: AND event_type = 'SESSION';
1836:
1837: l_ssn_start_date ota_events.course_start_date%type;

Line 1837: l_ssn_start_date ota_events.course_start_date%type;

1833: FROM ota_events
1834: WHERE parent_event_id = p_event_id
1835: AND event_type = 'SESSION';
1836:
1837: l_ssn_start_date ota_events.course_start_date%type;
1838: l_ssn_start_time ota_events.course_start_time%type;
1839: l_ssn_end_date ota_events.course_start_date%type;
1840: l_ssn_end_time ota_events.course_start_time%type;
1841:

Line 1838: l_ssn_start_time ota_events.course_start_time%type;

1834: WHERE parent_event_id = p_event_id
1835: AND event_type = 'SESSION';
1836:
1837: l_ssn_start_date ota_events.course_start_date%type;
1838: l_ssn_start_time ota_events.course_start_time%type;
1839: l_ssn_end_date ota_events.course_start_date%type;
1840: l_ssn_end_time ota_events.course_start_time%type;
1841:
1842: w_proc constant varchar2(72) := G_PACKAGE||'check_class_session_times';

Line 1839: l_ssn_end_date ota_events.course_start_date%type;

1835: AND event_type = 'SESSION';
1836:
1837: l_ssn_start_date ota_events.course_start_date%type;
1838: l_ssn_start_time ota_events.course_start_time%type;
1839: l_ssn_end_date ota_events.course_start_date%type;
1840: l_ssn_end_time ota_events.course_start_time%type;
1841:
1842: w_proc constant varchar2(72) := G_PACKAGE||'check_class_session_times';
1843:

Line 1840: l_ssn_end_time ota_events.course_start_time%type;

1836:
1837: l_ssn_start_date ota_events.course_start_date%type;
1838: l_ssn_start_time ota_events.course_start_time%type;
1839: l_ssn_end_date ota_events.course_start_date%type;
1840: l_ssn_end_time ota_events.course_start_time%type;
1841:
1842: w_proc constant varchar2(72) := G_PACKAGE||'check_class_session_times';
1843:
1844: BEGIN

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

1902: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);
1903:
1904: EXCEPTION
1905: WHEN app_exception.application_exception THEN
1906: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1907: hr_utility.set_location(' Leaving:'||w_proc, 60);
1908: RAISE;
1909: END IF;
1910: hr_utility.set_location(' Leaving:'||w_proc, 70);

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

1978: end if;
1979: --
1980: EXCEPTION
1981: WHEN app_exception.application_exception THEN
1982: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE',
1983: p_associated_column2 => 'OTA_EVENTS.COURSE_END_DATE') THEN
1984: hr_utility.set_location(' Leaving:'||w_proc, 40);
1985: RAISE;
1986: END IF;

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

1979: --
1980: EXCEPTION
1981: WHEN app_exception.application_exception THEN
1982: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE',
1983: p_associated_column2 => 'OTA_EVENTS.COURSE_END_DATE') THEN
1984: hr_utility.set_location(' Leaving:'||w_proc, 40);
1985: RAISE;
1986: END IF;
1987: hr_utility.set_location(' Leaving:'||w_proc, 50);

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

2013: hr_utility.set_location(' Leaving:'|| v_proc, 10);
2014: --
2015: EXCEPTION
2016: WHEN app_exception.application_exception THEN
2017: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.BUDGET_COST',
2018: p_associated_column2 => 'OTA_EVENTS.BUDGET_CURRENCY_CODE',
2019: p_associated_column3 => 'OTA_EVENTS.ACTUAL_COST') THEN
2020: hr_utility.set_location(' Leaving:'||v_proc, 40);
2021: RAISE;

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

2014: --
2015: EXCEPTION
2016: WHEN app_exception.application_exception THEN
2017: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.BUDGET_COST',
2018: p_associated_column2 => 'OTA_EVENTS.BUDGET_CURRENCY_CODE',
2019: p_associated_column3 => 'OTA_EVENTS.ACTUAL_COST') THEN
2020: hr_utility.set_location(' Leaving:'||v_proc, 40);
2021: RAISE;
2022: END IF;

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

2015: EXCEPTION
2016: WHEN app_exception.application_exception THEN
2017: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.BUDGET_COST',
2018: p_associated_column2 => 'OTA_EVENTS.BUDGET_CURRENCY_CODE',
2019: p_associated_column3 => 'OTA_EVENTS.ACTUAL_COST') THEN
2020: hr_utility.set_location(' Leaving:'||v_proc, 40);
2021: RAISE;
2022: END IF;
2023: hr_utility.set_location(' Leaving:'||v_proc, 50);

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

2075: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
2076: --
2077: EXCEPTION
2078: WHEN app_exception.application_exception THEN
2079: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE') THEN
2080: hr_utility.set_location(' Leaving:'||w_proc, 40);
2081: RAISE;
2082: END IF;
2083: hr_utility.set_location(' Leaving:'||w_proc, 50);

Line 2214: from ota_events

2210: --
2211: cursor csr_programme_dates is
2212: --
2213: select 1
2214: from ota_events
2215: where event_id = p_parent_event_id
2216: and (p_enrolment_start_date not between enrolment_start_date
2217: and enrolment_end_date
2218: or p_enrolment_end_date not between enrolment_start_date

Line 2224: from ota_events

2220: --
2221: cursor csr_member_dates is
2222: --
2223: select 1
2224: from ota_events
2225: where parent_event_id = p_event_id
2226: and ((p_enrolment_start_date not between enrolment_start_date
2227: and enrolment_end_date)
2228: or(p_enrolment_end_date not between enrolment_start_date

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

2365: --
2366: hr_utility.set_location ('Leaving:'||l_proc,10);
2367: EXCEPTION
2368: WHEN app_exception.application_exception THEN
2369: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS') THEN
2370: hr_utility.set_location(' Leaving:'||l_proc, 40);
2371: RAISE;
2372: END IF;
2373: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 2780: from ota_events

2776: -- cursor to check if sessions exist for the event
2777: --
2778: Cursor c_session_details is
2779: select 'X'
2780: from ota_events
2781: where parent_event_id = p_event_id;
2782: --
2783: -- cursor to check if resources exist for the event
2784: --

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

3039:
3040: hr_utility.set_location(' Leaving:'||l_proc, 10);
3041: EXCEPTION
3042: WHEN app_exception.application_exception THEN
3043: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_ID') THEN
3044: hr_utility.set_location(' Leaving:'||l_proc, 70);
3045: RAISE;
3046: END IF;
3047: hr_utility.set_location(' Leaving:'||l_proc, 80);

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

3162: END IF;
3163: End if;
3164: EXCEPTION
3165: WHEN app_exception.application_exception THEN
3166: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OWNER_ID') THEN
3167: hr_utility.set_location(' Leaving:'||l_proc, 40);
3168: RAISE;
3169: END IF;
3170: hr_utility.set_location(' Leaving:'||l_proc, 50);

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

3214: end if;
3215: hr_utility.set_location('Entering:'||l_proc, 30);
3216: EXCEPTION
3217: WHEN app_exception.application_exception THEN
3218: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3219: hr_utility.set_location(' Leaving:'||l_proc, 40);
3220: RAISE;
3221: END IF;
3222: hr_utility.set_location(' Leaving:'||l_proc, 50);

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

3362: end if;
3363: hr_utility.set_location('Leaving:'||l_proc, 30);
3364: EXCEPTION
3365: WHEN app_exception.application_exception THEN
3366: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3367: hr_utility.set_location(' Leaving:'||l_proc, 40);
3368: RAISE;
3369: END IF;
3370: hr_utility.set_location(' Leaving:'||l_proc, 50);

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

3418: end if;
3419: hr_utility.set_location('Entering:'||l_proc, 30);
3420: EXCEPTION
3421: WHEN app_exception.application_exception THEN
3422: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TRAINING_CENTER_ID') THEN
3423: hr_utility.set_location(' Leaving:'||l_proc, 40);
3424: RAISE;
3425: END IF;
3426: hr_utility.set_location(' Leaving:'||l_proc, 50);

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

3476: end if;
3477: hr_utility.set_location('Entering:'||l_proc, 30);
3478: EXCEPTION
3479: WHEN app_exception.application_exception THEN
3480: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LOCATION_ID') THEN
3481: hr_utility.set_location(' Leaving:'||l_proc, 40);
3482: RAISE;
3483: END IF;
3484: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 3511: from ota_events

3507: l_exists varchar2(1);
3508:
3509: cursor csr_offering is
3510: select null
3511: from ota_events
3512: where offering_id = p_offering_id;
3513:
3514: Begin
3515:

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

3525: hr_utility.set_location('Entering:'||l_proc, 15);
3526: open csr_offering;
3527: fetch csr_offering into l_exists;
3528: if csr_offering%found then
3529: ota_evt_shd.constraint_error(p_constraint_name =>'OTA_EVENTS_UK4');
3530: end if;
3531: close csr_offering;
3532: hr_utility.set_location('Leaving:'||l_proc, 20);
3533: end if;

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

3534: end if;
3535: hr_utility.set_location('Leaving:'||l_proc, 30);
3536: EXCEPTION
3537: WHEN app_exception.application_exception THEN
3538: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OFFERING_ID') THEN
3539: hr_utility.set_location(' Leaving:'||l_proc, 70);
3540: RAISE;
3541: END IF;
3542: hr_utility.set_location(' Leaving:'||l_proc, 80);

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

3584: close csr_offering;
3585: hr_utility.set_location('Leaving:'||l_proc, 20);
3586: EXCEPTION
3587: WHEN app_exception.application_exception THEN
3588: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ACTIVITY_VERSION_ID') THEN
3589: hr_utility.set_location(' Leaving:'||l_proc, 70);
3590: RAISE;
3591: END IF;
3592: hr_utility.set_location(' Leaving:'||l_proc, 80);

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

3646: hr_utility.set_location('Leaving:'||l_proc, 20);
3647:
3648: EXCEPTION
3649: WHEN app_exception.application_exception THEN
3650: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.SECURE_EVENT_FLAG') THEN
3651: hr_utility.set_location('Leaving:'||l_proc, 40);
3652: RAISE;
3653: END IF;
3654: hr_utility.set_location('Leaving:'||l_proc, 50);