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_DELEGATE_BOOKING_API dependencies on FND_MESSAGE

Line 57: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');

53: --
54: if (ota_evt_bus2.get_vacancies(p_event_id) < p_number_of_places) and
55: l_booking_status in ('P','A','E') then
56: --
57: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
58: fnd_message.raise_error;
59: --
60: end if;
61: --

Line 58: fnd_message.raise_error;

54: if (ota_evt_bus2.get_vacancies(p_event_id) < p_number_of_places) and
55: l_booking_status in ('P','A','E') then
56: --
57: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
58: fnd_message.raise_error;
59: --
60: end if;
61: --
62: end if;

Line 70: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');

66: --
67:
68: if p_event_status = 'F' and l_booking_status in ('P','A','E','C') then
69: --
70: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');
71: fnd_message.raise_error;
72: --
73: end if;
74:

Line 71: fnd_message.raise_error;

67:
68: if p_event_status = 'F' and l_booking_status in ('P','A','E','C') then
69: --
70: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');
71: fnd_message.raise_error;
72: --
73: end if;
74:
75: --

Line 83: fnd_message.set_name('OTA','OTA_467111_TDB_MAND_EVL_STATUS');

79: fetch c_eval_info into l_eval_mand;
80: close c_eval_info;
81: if (l_eval_mand is null or l_eval_mand = 'N') and l_booking_status = 'E' then
82: --
83: fnd_message.set_name('OTA','OTA_467111_TDB_MAND_EVL_STATUS');
84: fnd_message.raise_error;
85: --
86: end if;
87:

Line 84: fnd_message.raise_error;

80: close c_eval_info;
81: if (l_eval_mand is null or l_eval_mand = 'N') and l_booking_status = 'E' then
82: --
83: fnd_message.set_name('OTA','OTA_467111_TDB_MAND_EVL_STATUS');
84: fnd_message.raise_error;
85: --
86: end if;
87:
88: --

Line 94: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');

90: --
91:
92: if p_event_status = 'P' and l_booking_status not in ('W','R') then
93: --
94: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');
95: fnd_message.raise_error;
96: --
97: end if;
98:

Line 95: fnd_message.raise_error;

91:
92: if p_event_status = 'P' and l_booking_status not in ('W','R') then
93: --
94: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');
95: fnd_message.raise_error;
96: --
97: end if;
98:
99: --

Line 104: fnd_message.set_name('OTA','OTA_13519_TDB_NEW_STATUS_A');

100: -- Check new status for Cancelled or Closed Events.
101: --
102: if p_event_status in ('A','C') and l_booking_status is not null then
103: --
104: fnd_message.set_name('OTA','OTA_13519_TDB_NEW_STATUS_A');
105: fnd_message.raise_error;
106: --
107: end if;
108:

Line 105: fnd_message.raise_error;

101: --
102: if p_event_status in ('A','C') and l_booking_status is not null then
103: --
104: fnd_message.set_name('OTA','OTA_13519_TDB_NEW_STATUS_A');
105: fnd_message.raise_error;
106: --
107: end if;
108:
109: --

Line 114: fnd_message.set_name('OTA','OTA_13520_TDB_NEW_STATUS_N');

110: -- Check new status for Normal Events.
111: --
112: if p_event_status = 'N' and l_booking_status in ('C') then
113: --
114: fnd_message.set_name('OTA','OTA_13520_TDB_NEW_STATUS_N');
115: fnd_message.raise_error;
116: --
117: end if;
118:

Line 115: fnd_message.raise_error;

111: --
112: if p_event_status = 'N' and l_booking_status in ('C') then
113: --
114: fnd_message.set_name('OTA','OTA_13520_TDB_NEW_STATUS_N');
115: fnd_message.raise_error;
116: --
117: end if;
118:
119: --

Line 506: fnd_message.set_name('OTA','OTA_443997_EVT_ROW_LCK_ERR');

502: begin
503: ota_evt_bus2.lock_event(p_event_id);
504: exception
505: when others then
506: fnd_message.set_name('OTA','OTA_443997_EVT_ROW_LCK_ERR');
507: fnd_message.set_token('CLASS_NAME', l_class_name);
508: fnd_message.raise_error;
509: end;
510:

Line 507: fnd_message.set_token('CLASS_NAME', l_class_name);

503: ota_evt_bus2.lock_event(p_event_id);
504: exception
505: when others then
506: fnd_message.set_name('OTA','OTA_443997_EVT_ROW_LCK_ERR');
507: fnd_message.set_token('CLASS_NAME', l_class_name);
508: fnd_message.raise_error;
509: end;
510:
511:

Line 508: fnd_message.raise_error;

504: exception
505: when others then
506: fnd_message.set_name('OTA','OTA_443997_EVT_ROW_LCK_ERR');
507: fnd_message.set_token('CLASS_NAME', l_class_name);
508: fnd_message.raise_error;
509: end;
510:
511:
512: --

Line 1168: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');

1164: ( p_event_status = 'F' or
1165: ota_evt_bus2.get_vacancies(p_event_id) <
1166: p_number_of_places ) then
1167:
1168: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
1169: fnd_message.raise_error;
1170: --
1171: end if;
1172:

Line 1169: fnd_message.raise_error;

1165: ota_evt_bus2.get_vacancies(p_event_id) <
1166: p_number_of_places ) then
1167:
1168: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
1169: fnd_message.raise_error;
1170: --
1171: end if;
1172:
1173: --Added for bug 6817203-Error message is displayed when learners with

Line 1179: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');

1175: if p_event_id <> l_old_event_id and
1176: l_booking_status in ('A','P') and
1177: p_event_status = 'P' then
1178:
1179: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');
1180: fnd_message.raise_error;
1181: --
1182: end if;
1183: --

Line 1180: fnd_message.raise_error;

1176: l_booking_status in ('A','P') and
1177: p_event_status = 'P' then
1178:
1179: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');
1180: fnd_message.raise_error;
1181: --
1182: end if;
1183: --
1184: -- Check for exceeding max attendees.

Line 1194: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');

1190: (l_booking_status in ('A','P','E') and
1191: l_old_booking_status not in ('A','P','E') and
1192: ota_evt_bus2.get_vacancies(p_event_id) < p_number_of_places) then
1193: --
1194: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
1195: fnd_message.raise_error;
1196: --
1197: end if;
1198: --

Line 1195: fnd_message.raise_error;

1191: l_old_booking_status not in ('A','P','E') and
1192: ota_evt_bus2.get_vacancies(p_event_id) < p_number_of_places) then
1193: --
1194: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
1195: fnd_message.raise_error;
1196: --
1197: end if;
1198: --
1199: -- 6683076.Check for Events with voluntary or null evaluation.

Line 1206: fnd_message.set_name('OTA','OTA_467111_TDB_MAND_EVL_STATUS');

1202: fetch c_eval_info into l_eval_mand;
1203: close c_eval_info;
1204: if (l_eval_mand is null or l_eval_mand = 'N') and l_booking_status = 'E' then
1205: --
1206: fnd_message.set_name('OTA','OTA_467111_TDB_MAND_EVL_STATUS');
1207: fnd_message.raise_error;
1208: --
1209: end if;
1210: --

Line 1207: fnd_message.raise_error;

1203: close c_eval_info;
1204: if (l_eval_mand is null or l_eval_mand = 'N') and l_booking_status = 'E' then
1205: --
1206: fnd_message.set_name('OTA','OTA_467111_TDB_MAND_EVL_STATUS');
1207: fnd_message.raise_error;
1208: --
1209: end if;
1210: --
1211: -- Check booking status, if amended.

Line 1231: fnd_message.set_name('OTA','OTA_13521_TDB_CH_STATUS_FP');

1227: ota_evt_bus2.get_vacancies(p_event_id) >= p_number_of_places
1228: and p_event_status <> 'P' then
1229: null;
1230: else
1231: fnd_message.set_name('OTA','OTA_13521_TDB_CH_STATUS_FP');
1232: fnd_message.raise_error;
1233: end if;
1234: --
1235: end if;

Line 1232: fnd_message.raise_error;

1228: and p_event_status <> 'P' then
1229: null;
1230: else
1231: fnd_message.set_name('OTA','OTA_13521_TDB_CH_STATUS_FP');
1232: fnd_message.raise_error;
1233: end if;
1234: --
1235: end if;
1236: --

Line 1246: fnd_message.set_name('OTA','OTA_13522_TDB_CH_STATUS_C');

1242: if p_event_status in ('A') then
1243: --
1244: if l_booking_status <> 'C' then
1245: --
1246: fnd_message.set_name('OTA','OTA_13522_TDB_CH_STATUS_C');
1247: fnd_message.raise_error;
1248: --
1249: end if;
1250: --

Line 1247: fnd_message.raise_error;

1243: --
1244: if l_booking_status <> 'C' then
1245: --
1246: fnd_message.set_name('OTA','OTA_13522_TDB_CH_STATUS_C');
1247: fnd_message.raise_error;
1248: --
1249: end if;
1250: --
1251: end if;

Line 1704: l_evt_status_chg_comments varchar2(1000) := fnd_message.get_string('OTA','OTA_13523_TDB_STATUS_COMMENTS');

1700:
1701: l_enr_details_rec csr_get_enr_details%ROWTYPE;
1702:
1703: l_old_booking_status varchar2(30);
1704: l_evt_status_chg_comments varchar2(1000) := fnd_message.get_string('OTA','OTA_13523_TDB_STATUS_COMMENTS');
1705:
1706: CURSOR c_get_fin_line_status IS
1707: SELECT cancelled_flag
1708: FROM ota_finance_lines

Line 2029: fnd_message.set_name('OTA','OTA_467126_STAT_CHG_PE_ERR');

2025: fetch c_attempt_info into l_temp;
2026: close c_attempt_info;
2027: end if;
2028: if l_temp=1 then
2029: fnd_message.set_name('OTA','OTA_467126_STAT_CHG_PE_ERR');
2030: fnd_message.raise_error;
2031: end if;
2032: end if;
2033: --end of changes for 7046809.

Line 2030: fnd_message.raise_error;

2026: close c_attempt_info;
2027: end if;
2028: if l_temp=1 then
2029: fnd_message.set_name('OTA','OTA_467126_STAT_CHG_PE_ERR');
2030: fnd_message.raise_error;
2031: end if;
2032: end if;
2033: --end of changes for 7046809.
2034:

Line 3159: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');

3155: commit;
3156: --
3157: else
3158: --
3159: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
3160: fnd_message.raise_error;
3161: --
3162: end if;
3163: --

Line 3160: fnd_message.raise_error;

3156: --
3157: else
3158: --
3159: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
3160: fnd_message.raise_error;
3161: --
3162: end if;
3163: --
3164: if g_debug then