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 64: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');

60: --
61: if (ota_evt_bus2.get_vacancies(p_event_id) < p_number_of_places) and
62: l_booking_status in ('P','A','E') then
63: --
64: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
65: fnd_message.raise_error;
66: --
67: end if;
68: --

Line 65: fnd_message.raise_error;

61: if (ota_evt_bus2.get_vacancies(p_event_id) < p_number_of_places) and
62: l_booking_status in ('P','A','E') then
63: --
64: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
65: fnd_message.raise_error;
66: --
67: end if;
68: --
69: end if;

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

73: --
74:
75: if p_event_status = 'F' and l_booking_status in ('P','A','E','C') then
76: --
77: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');
78: fnd_message.raise_error;
79: --
80: end if;
81:

Line 78: fnd_message.raise_error;

74:
75: if p_event_status = 'F' and l_booking_status in ('P','A','E','C') then
76: --
77: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');
78: fnd_message.raise_error;
79: --
80: end if;
81:
82: --

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

89: fetch c_sign_info into l_sign_flag;
90: close c_sign_info;
91: if ((l_eval_mand is null or l_eval_mand = 'N') and (l_sign_flag is null or l_sign_flag='N') and l_booking_status = 'E') then
92: --
93: fnd_message.set_name('OTA','OTA_467111_TDB_MAND_EVL_STATUS');
94: fnd_message.raise_error;
95: --
96: end if;
97:

Line 94: fnd_message.raise_error;

90: close c_sign_info;
91: if ((l_eval_mand is null or l_eval_mand = 'N') and (l_sign_flag is null or l_sign_flag='N') and l_booking_status = 'E') then
92: --
93: fnd_message.set_name('OTA','OTA_467111_TDB_MAND_EVL_STATUS');
94: fnd_message.raise_error;
95: --
96: end if;
97:
98: --

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

100: --
101:
102: if p_event_status = 'P' and l_booking_status not in ('W','R') then
103: --
104: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');
105: fnd_message.raise_error;
106: --
107: end if;
108:

Line 105: fnd_message.raise_error;

101:
102: if p_event_status = 'P' and l_booking_status not in ('W','R') then
103: --
104: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');
105: fnd_message.raise_error;
106: --
107: end if;
108:
109: --

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

110: -- Check new status for Cancelled or Closed Events.
111: --
112: if p_event_status in ('A','C') and l_booking_status is not null then
113: --
114: fnd_message.set_name('OTA','OTA_13519_TDB_NEW_STATUS_A');
115: fnd_message.raise_error;
116: --
117: end if;
118:

Line 115: fnd_message.raise_error;

111: --
112: if p_event_status in ('A','C') and l_booking_status is not null then
113: --
114: fnd_message.set_name('OTA','OTA_13519_TDB_NEW_STATUS_A');
115: fnd_message.raise_error;
116: --
117: end if;
118:
119: --

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

120: -- Check new status for Normal Events.
121: --
122: if p_event_status = 'N' and l_booking_status in ('C') then
123: --
124: fnd_message.set_name('OTA','OTA_13520_TDB_NEW_STATUS_N');
125: fnd_message.raise_error;
126: --
127: end if;
128:

Line 125: fnd_message.raise_error;

121: --
122: if p_event_status = 'N' and l_booking_status in ('C') then
123: --
124: fnd_message.set_name('OTA','OTA_13520_TDB_NEW_STATUS_N');
125: fnd_message.raise_error;
126: --
127: end if;
128:
129: --

Line 357: fnd_message.set_name('OTA','OTA_467197_ERES_ENRST_CHNG_ERR');

353: l_status_change:= (p_booking_id is not null) and (l_type <>l_old_status_type);
354: if l_manual_update and l_status_change then
355: if l_type='A' then
356: if (l_old_sign_eval_status in ('SD','SE','UD','UE','VD','VE')) then
357: fnd_message.set_name('OTA','OTA_467197_ERES_ENRST_CHNG_ERR');
358: fnd_message.raise_error;
359: end if;
360: elsif l_old_status_type='A' and l_old_sign_eval_status='DD' then
361: fnd_message.set_name('OTA','OTA_467198_ERES_COMP_ERR');

Line 358: fnd_message.raise_error;

354: if l_manual_update and l_status_change then
355: if l_type='A' then
356: if (l_old_sign_eval_status in ('SD','SE','UD','UE','VD','VE')) then
357: fnd_message.set_name('OTA','OTA_467197_ERES_ENRST_CHNG_ERR');
358: fnd_message.raise_error;
359: end if;
360: elsif l_old_status_type='A' and l_old_sign_eval_status='DD' then
361: fnd_message.set_name('OTA','OTA_467198_ERES_COMP_ERR');
362: fnd_message.raise_error;

Line 361: fnd_message.set_name('OTA','OTA_467198_ERES_COMP_ERR');

357: fnd_message.set_name('OTA','OTA_467197_ERES_ENRST_CHNG_ERR');
358: fnd_message.raise_error;
359: end if;
360: elsif l_old_status_type='A' and l_old_sign_eval_status='DD' then
361: fnd_message.set_name('OTA','OTA_467198_ERES_COMP_ERR');
362: fnd_message.raise_error;
363: end if;
364: end if;
365: --9241537

Line 362: fnd_message.raise_error;

358: fnd_message.raise_error;
359: end if;
360: elsif l_old_status_type='A' and l_old_sign_eval_status='DD' then
361: fnd_message.set_name('OTA','OTA_467198_ERES_COMP_ERR');
362: fnd_message.raise_error;
363: end if;
364: end if;
365: --9241537
366: if l_sign_required is null then

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

660: begin
661: ota_evt_bus2.lock_event(p_event_id);
662: exception
663: when others then
664: fnd_message.set_name('OTA','OTA_443997_EVT_ROW_LCK_ERR');
665: fnd_message.set_token('CLASS_NAME', l_class_name);
666: fnd_message.raise_error;
667: end;
668: end if;

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

661: ota_evt_bus2.lock_event(p_event_id);
662: exception
663: when others then
664: fnd_message.set_name('OTA','OTA_443997_EVT_ROW_LCK_ERR');
665: fnd_message.set_token('CLASS_NAME', l_class_name);
666: fnd_message.raise_error;
667: end;
668: end if;
669:

Line 666: fnd_message.raise_error;

662: exception
663: when others then
664: fnd_message.set_name('OTA','OTA_443997_EVT_ROW_LCK_ERR');
665: fnd_message.set_token('CLASS_NAME', l_class_name);
666: fnd_message.raise_error;
667: end;
668: end if;
669:
670:

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

1330: ( p_event_status = 'F' or
1331: ota_evt_bus2.get_vacancies(p_event_id) <
1332: p_number_of_places ) then
1333:
1334: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
1335: fnd_message.raise_error;
1336: --
1337: end if;
1338:

Line 1335: fnd_message.raise_error;

1331: ota_evt_bus2.get_vacancies(p_event_id) <
1332: p_number_of_places ) then
1333:
1334: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
1335: fnd_message.raise_error;
1336: --
1337: end if;
1338:
1339: --Added for bug 6817203-Error message is displayed when learners with

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

1341: if p_event_id <> l_old_event_id and
1342: l_booking_status in ('A','P') and
1343: p_event_status = 'P' then
1344:
1345: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');
1346: fnd_message.raise_error;
1347: --
1348: end if;
1349: --

Line 1346: fnd_message.raise_error;

1342: l_booking_status in ('A','P') and
1343: p_event_status = 'P' then
1344:
1345: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');
1346: fnd_message.raise_error;
1347: --
1348: end if;
1349: --
1350: -- Check for exceeding max attendees.

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

1356: (l_booking_status in ('A','P','E') and
1357: l_old_booking_status not in ('A','P','E') and
1358: ota_evt_bus2.get_vacancies(p_event_id) < p_number_of_places) then
1359: --
1360: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
1361: fnd_message.raise_error;
1362: --
1363: end if;
1364: --

Line 1361: fnd_message.raise_error;

1357: l_old_booking_status not in ('A','P','E') and
1358: ota_evt_bus2.get_vacancies(p_event_id) < p_number_of_places) then
1359: --
1360: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
1361: fnd_message.raise_error;
1362: --
1363: end if;
1364: --
1365: -- 6683076.Check for Events with voluntary or null evaluation.

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

1371: fetch c_sign_info into l_sign_flag;
1372: close c_sign_info;
1373: if ((l_eval_mand is null or l_eval_mand = 'N') and (l_sign_flag is null or l_sign_flag='N') and l_booking_status = 'E') then
1374: --
1375: fnd_message.set_name('OTA','OTA_467111_TDB_MAND_EVL_STATUS');
1376: fnd_message.raise_error;
1377: --
1378: end if;
1379: --

Line 1376: fnd_message.raise_error;

1372: close c_sign_info;
1373: if ((l_eval_mand is null or l_eval_mand = 'N') and (l_sign_flag is null or l_sign_flag='N') and l_booking_status = 'E') then
1374: --
1375: fnd_message.set_name('OTA','OTA_467111_TDB_MAND_EVL_STATUS');
1376: fnd_message.raise_error;
1377: --
1378: end if;
1379: --
1380: -- Check booking status, if amended.

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

1396: ota_evt_bus2.get_vacancies(p_event_id) >= p_number_of_places
1397: and p_event_status <> 'P' then
1398: null;
1399: else
1400: fnd_message.set_name('OTA','OTA_13521_TDB_CH_STATUS_FP');
1401: fnd_message.raise_error;
1402: end if;
1403: --
1404: end if;

Line 1401: fnd_message.raise_error;

1397: and p_event_status <> 'P' then
1398: null;
1399: else
1400: fnd_message.set_name('OTA','OTA_13521_TDB_CH_STATUS_FP');
1401: fnd_message.raise_error;
1402: end if;
1403: --
1404: end if;
1405: --

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

1411: if p_event_status in ('A') then
1412: --
1413: if l_booking_status <> 'C' then
1414: --
1415: fnd_message.set_name('OTA','OTA_13522_TDB_CH_STATUS_C');
1416: fnd_message.raise_error;
1417: --
1418: end if;
1419: --

Line 1416: fnd_message.raise_error;

1412: --
1413: if l_booking_status <> 'C' then
1414: --
1415: fnd_message.set_name('OTA','OTA_13522_TDB_CH_STATUS_C');
1416: fnd_message.raise_error;
1417: --
1418: end if;
1419: --
1420: end if;

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

1870:
1871: l_enr_details_rec csr_get_enr_details%ROWTYPE;
1872:
1873: l_old_booking_status varchar2(30);
1874: l_evt_status_chg_comments varchar2(1000) := fnd_message.get_string('OTA','OTA_13523_TDB_STATUS_COMMENTS');
1875:
1876: CURSOR c_get_fin_line_status IS
1877: SELECT cancelled_flag
1878: FROM ota_finance_lines

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

2226: fetch c_attempt_info into l_temp;
2227: close c_attempt_info;
2228: end if;
2229: if l_temp=1 then
2230: fnd_message.set_name('OTA','OTA_467126_STAT_CHG_PE_ERR');
2231: fnd_message.raise_error;
2232: end if;
2233: end if;
2234: --end of changes for 7046809.

Line 2231: fnd_message.raise_error;

2227: close c_attempt_info;
2228: end if;
2229: if l_temp=1 then
2230: fnd_message.set_name('OTA','OTA_467126_STAT_CHG_PE_ERR');
2231: fnd_message.raise_error;
2232: end if;
2233: end if;
2234: --end of changes for 7046809.
2235: --8893725

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

3401: commit;
3402: --
3403: else
3404: --
3405: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
3406: fnd_message.raise_error;
3407: --
3408: end if;
3409: --

Line 3406: fnd_message.raise_error;

3402: --
3403: else
3404: --
3405: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
3406: fnd_message.raise_error;
3407: --
3408: end if;
3409: --
3410: if g_debug then