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_TIMEZONE_UPGRADE dependencies on OTA_CLASSIC_UPGRADE

Line 135: timezone = decode(offering_id, NULL, timezone, ota_classic_upgrade.get_apps_timezone(timezone))

131: UPDATE ota_events
132: SET book_independent_flag = nvl(book_independent_flag, 'N'),
133: secure_event_flag = nvl(secure_event_flag, 'N'),
134: maximum_internal_attendees = decode(price_basis, 'C', 0, 'O', 0, maximum_internal_attendees),
135: timezone = decode(offering_id, NULL, timezone, ota_classic_upgrade.get_apps_timezone(timezone))
136: WHERE event_id = p_event_id;
137: ------*************** bug 5157917
138: -- Upgrade Events
139: -- 1) set public_event_flag to Y iff null and no learner access exists

Line 165: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_EVENTS',

161:
162: EXCEPTION
163: WHEN others THEN
164: l_err_msg := nvl(SUBSTR(sqlerrm, 1, 2000), l_msg);
165: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_EVENTS',
166: p_business_group_id => NULL,
167: p_source_primary_key => p_event_id,
168: p_object_value => l_upgrade_name,
169: p_message_text => l_err_msg,

Line 304: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',

300: ELSE
301: l_err_msg := nvl(l_err, l_msg);
302: END IF;
303:
304: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',
305: p_business_group_id => NULL,
306: p_source_primary_key => p_res_bkng_id,
307: p_object_value => l_upgrade_name,
308: p_message_text => l_err_msg,

Line 328: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',

324:
325: EXCEPTION
326: WHEN others THEN
327: l_err_msg := nvl(SUBSTR(sqlerrm, 1, 2000), l_msg);
328: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',
329: p_business_group_id => NULL,
330: p_source_primary_key => p_res_bkng_id,
331: p_object_value => l_upgrade_name,
332: p_message_text => l_err_msg,

Line 373: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_events',

369:
370: EXCEPTION
371: WHEN others THEN
372: l_err_msg := nvl(SUBSTR(sqlerrm, 1, 2000), l_msg);
373: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_events',
374: p_business_group_id => NULL,
375: p_source_primary_key => p_event_id, -- * event_sess_row.event_id,
376: p_object_value => l_upgrade_name,
377: p_message_text => l_err_msg,

Line 467: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_chats_b',

463:
464: EXCEPTION
465: WHEN others THEN
466: l_err_msg := nvl(SUBSTR(sqlerrm, 1, 2000), l_msg);
467: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_chats_b',
468: p_business_group_id => NULL,
469: p_source_primary_key => chats_row.chat_id,
470: p_object_value => l_upgrade_name,
471: p_message_text => l_err_msg,

Line 515: ota_classic_upgrade.add_log_entry(p_table_name => 'ota_chats_b',

511: BEGIN
512: l_others_msg := 'Error occurred while upgrading the timezone of category chats ';
513:
514: IF p_default_timezone IS NULL THEN
515: ota_classic_upgrade.add_log_entry(p_table_name => 'ota_chats_b',
516: p_business_group_id => NULL,
517: p_source_primary_key => -1,
518: p_object_value => 'Timezone',
519: p_message_text => l_default_msg,

Line 541: ota_classic_upgrade.add_log_entry(p_table_name => 'ota_chats_b',

537:
538: EXCEPTION
539: WHEN others THEN
540: l_err_msg := nvl(SUBSTR(sqlerrm, 1, 2000), l_others_msg);
541: ota_classic_upgrade.add_log_entry(p_table_name => 'ota_chats_b',
542: p_business_group_id => NULL,
543: p_source_primary_key => cat_chat_bkng_row.chat_id,
544: p_object_value => l_upgrade_name,
545: p_message_text => l_err_msg,

Line 576: ota_classic_upgrade.add_log_entry(p_table_name => 'Dummy',

572: EXCEPTION
573: WHEN others THEN
574: l_err_code := SQLCODE;
575: l_err_msg := nvl(SUBSTR(sqlerrm, 1, 2000), l_others_msg);
576: ota_classic_upgrade.add_log_entry(p_table_name => 'Dummy',
577: p_business_group_id => NULL,
578: p_source_primary_key => l_err_code,
579: p_object_value => l_upgrade_name,
580: p_message_text => l_err_msg,

Line 605: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',

601: BEGIN
602: l_msg := 'Error occurred while upgrading timezone of category forum resource booking';
603:
604: IF p_default_timezone IS NULL THEN
605: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',
606: p_business_group_id => NULL,
607: p_source_primary_key => l_upgrade_id,
608: p_object_value => 'Timezone',
609: p_message_text => l_default_msg,

Line 642: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',

638: EXCEPTION
639: WHEN others THEN
640: l_err_code := SQLCODE;
641: l_err_msg := nvl(SUBSTR(sqlerrm, 1, 2000), l_msg);
642: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',
643: p_business_group_id => NULL,
644: p_source_primary_key => -1,
645: p_object_value => l_upgrade_name,
646: p_message_text => l_err_msg,

Line 701: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_EVENTS',

697:
698: IF(l_time_zone IS NULL) THEN
699:
700: IF p_default_timezone IS NULL THEN
701: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_EVENTS',
702: p_business_group_id => NULL,
703: p_source_primary_key => class_ses_res_bkng_row.event_id,
704: p_object_value => 'Timezone',
705: p_message_text => l_default_msg,

Line 736: ota_classic_upgrade.add_log_entry(p_table_name => 'Dummy',

732: EXCEPTION
733: WHEN others THEN
734: l_err_code := SQLCODE;
735: l_err_msg := nvl(SUBSTR(sqlerrm, 1, 2000), l_msg);
736: ota_classic_upgrade.add_log_entry(p_table_name => 'Dummy',
737: p_business_group_id => NULL,
738: p_source_primary_key => l_err_code,
739: p_object_value => l_upgrade_name,
740: p_message_text => l_err_msg,

Line 789: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',

785:
786: IF(l_time_zone IS NULL) THEN
787:
788: IF p_default_timezone IS NULL THEN
789: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',
790: p_business_group_id => NULL,
791: p_source_primary_key => ind_res_bookings_row.supplied_resource_id,
792: p_object_value => 'Timezone',
793: p_message_text => l_default_msg,

Line 827: ota_classic_upgrade.add_log_entry(p_table_name => 'Dummy',

823: EXCEPTION
824: WHEN others THEN
825: l_err_code := SQLCODE;
826: l_err_msg := nvl(SUBSTR(sqlerrm, 1, 2000), l_msg);
827: ota_classic_upgrade.add_log_entry(p_table_name => 'Dummy',
828: p_business_group_id => NULL,
829: p_source_primary_key => l_err_code,
830: p_object_value => l_upgrade_name,
831: p_message_text => l_err_msg,

Line 932: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',

928: else
929: l_err_msg:=nvl(l_err_msg,l_others_msg);
930: end if;
931:
932: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',
933: p_business_group_id => NULL,
934: p_source_primary_key => get_resource_bookings_row.resource_booking_id,
935: p_object_value => l_upgrade_name,
936: p_message_text => l_err_msg,

Line 949: ota_classic_upgrade.add_log_entry(p_table_name => 'Dummy',

945: END IF;
946: l_loop_counter:=l_loop_counter+1;
947: if l_loop_counter >=1000 then
948: l_loop_counter:=0;
949: ota_classic_upgrade.add_log_entry(p_table_name => 'Dummy',
950: p_business_group_id => NULL,
951: p_source_primary_key => get_resource_bookings_row.resource_booking_id,
952: p_object_value => l_upgrade_name,
953: p_message_text => 'Records checked for the double booking validation',

Line 974: ota_classic_upgrade.add_log_entry(p_table_name => 'Dummy',

970: EXCEPTION
971: WHEN others THEN
972: l_err_code := SQLCODE;
973: l_err_msg := nvl(SUBSTR(sqlerrm, 1, 2000), l_others_msg);
974: ota_classic_upgrade.add_log_entry(p_table_name => 'Dummy',
975: p_business_group_id => NULL,
976: p_source_primary_key => l_err_code,
977: p_object_value => l_upgrade_name,
978: p_message_text => l_err_msg,