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

Line 53: fnd_message.set_name('OTA', 'OTA_13826_TPC_NO_MEASURE_DEF');

49: fetch csr_tp_measurement_type into l_cost_level;
50: if csr_tp_measurement_type%NOTFOUND then
51: close csr_tp_measurement_type;
52: hr_utility.set_location(' Step:'|| l_proc, 60);
53: fnd_message.set_name('OTA', 'OTA_13826_TPC_NO_MEASURE_DEF');
54: fnd_message.raise_error;
55: elsif l_cost_level = 'NONE' then
56: close csr_tp_measurement_type;
57: hr_utility.set_location(' Step:'|| l_proc, 70);

Line 54: fnd_message.raise_error;

50: if csr_tp_measurement_type%NOTFOUND then
51: close csr_tp_measurement_type;
52: hr_utility.set_location(' Step:'|| l_proc, 60);
53: fnd_message.set_name('OTA', 'OTA_13826_TPC_NO_MEASURE_DEF');
54: fnd_message.raise_error;
55: elsif l_cost_level = 'NONE' then
56: close csr_tp_measurement_type;
57: hr_utility.set_location(' Step:'|| l_proc, 70);
58: fnd_message.set_name('OTA', 'OTA_13827_TPC_BAD_COST_LEVEL');

Line 58: fnd_message.set_name('OTA', 'OTA_13827_TPC_BAD_COST_LEVEL');

54: fnd_message.raise_error;
55: elsif l_cost_level = 'NONE' then
56: close csr_tp_measurement_type;
57: hr_utility.set_location(' Step:'|| l_proc, 70);
58: fnd_message.set_name('OTA', 'OTA_13827_TPC_BAD_COST_LEVEL');
59: fnd_message.raise_error;
60: else
61: hr_utility.set_location(' Step:'|| l_proc, 80);
62: close csr_tp_measurement_type;

Line 59: fnd_message.raise_error;

55: elsif l_cost_level = 'NONE' then
56: close csr_tp_measurement_type;
57: hr_utility.set_location(' Step:'|| l_proc, 70);
58: fnd_message.set_name('OTA', 'OTA_13827_TPC_BAD_COST_LEVEL');
59: fnd_message.raise_error;
60: else
61: hr_utility.set_location(' Step:'|| l_proc, 80);
62: close csr_tp_measurement_type;
63: end if;

Line 109: fnd_message.set_name('OTA', 'OTA_13828_TPC_NO_TRAINING_PLAN');

105: fetch csr_training_plan_id into l_exists;
106: if csr_training_plan_id%NOTFOUND then
107: close csr_training_plan_id;
108: hr_utility.set_location(' Step:'|| l_proc, 60);
109: fnd_message.set_name('OTA', 'OTA_13828_TPC_NO_TRAINING_PLAN');
110: fnd_message.raise_error;
111: else
112: hr_utility.set_location(' Step:'|| l_proc, 80);
113: close csr_training_plan_id;

Line 110: fnd_message.raise_error;

106: if csr_training_plan_id%NOTFOUND then
107: close csr_training_plan_id;
108: hr_utility.set_location(' Step:'|| l_proc, 60);
109: fnd_message.set_name('OTA', 'OTA_13828_TPC_NO_TRAINING_PLAN');
110: fnd_message.raise_error;
111: else
112: hr_utility.set_location(' Step:'|| l_proc, 80);
113: close csr_training_plan_id;
114: end if;

Line 154: fnd_message.set_name('OTA', 'OTA_13829_TPC_NO_BOOKING');

150: fetch csr_booking_id into l_business_group_id;
151: if csr_booking_id%NOTFOUND then
152: close csr_booking_id;
153: hr_utility.set_location(' Step:'|| l_proc, 60);
154: fnd_message.set_name('OTA', 'OTA_13829_TPC_NO_BOOKING');
155: fnd_message.raise_error;
156: else
157: close csr_booking_id;
158: hr_utility.set_location(' Step:'|| l_proc, 70);

Line 155: fnd_message.raise_error;

151: if csr_booking_id%NOTFOUND then
152: close csr_booking_id;
153: hr_utility.set_location(' Step:'|| l_proc, 60);
154: fnd_message.set_name('OTA', 'OTA_13829_TPC_NO_BOOKING');
155: fnd_message.raise_error;
156: else
157: close csr_booking_id;
158: hr_utility.set_location(' Step:'|| l_proc, 70);
159: if l_business_group_id <> p_business_group_id then

Line 160: fnd_message.set_name('OTA', 'OTA_13830_TPC_BOOKING_BAD_BG');

156: else
157: close csr_booking_id;
158: hr_utility.set_location(' Step:'|| l_proc, 70);
159: if l_business_group_id <> p_business_group_id then
160: fnd_message.set_name('OTA', 'OTA_13830_TPC_BOOKING_BAD_BG');
161: fnd_message.raise_error;
162: end if;
163: end if;
164: end if;

Line 161: fnd_message.raise_error;

157: close csr_booking_id;
158: hr_utility.set_location(' Step:'|| l_proc, 70);
159: if l_business_group_id <> p_business_group_id then
160: fnd_message.set_name('OTA', 'OTA_13830_TPC_BOOKING_BAD_BG');
161: fnd_message.raise_error;
162: end if;
163: end if;
164: end if;
165: --

Line 210: fnd_message.set_name('OTA', 'OTA_13831_TPC_EVENT_OR_BOOKING');

206: --
207: -- One and only one of event_id, booking_id must be null;
208: --
209: If (p_booking_id is not null and p_event_id is not null) then
210: fnd_message.set_name('OTA', 'OTA_13831_TPC_EVENT_OR_BOOKING');
211: fnd_message.raise_error;
212: end if;
213:
214: hr_utility.set_location(' Step:'|| l_proc, 50);

Line 211: fnd_message.raise_error;

207: -- One and only one of event_id, booking_id must be null;
208: --
209: If (p_booking_id is not null and p_event_id is not null) then
210: fnd_message.set_name('OTA', 'OTA_13831_TPC_EVENT_OR_BOOKING');
211: fnd_message.raise_error;
212: end if;
213:
214: hr_utility.set_location(' Step:'|| l_proc, 50);
215: open csr_booking_event;

Line 220: fnd_message.set_name('OTA', 'OTA_13826_TPC_NO_MEASURE_DEF');

216: fetch csr_booking_event into l_cost_level;
217: if csr_booking_event%NOTFOUND then
218: close csr_booking_event;
219: hr_utility.set_location(' Step:'|| l_proc, 60);
220: fnd_message.set_name('OTA', 'OTA_13826_TPC_NO_MEASURE_DEF');
221: fnd_message.raise_error;
222: else
223: close csr_booking_event;
224: hr_utility.set_location(' Step:'|| l_proc, 70);

Line 221: fnd_message.raise_error;

217: if csr_booking_event%NOTFOUND then
218: close csr_booking_event;
219: hr_utility.set_location(' Step:'|| l_proc, 60);
220: fnd_message.set_name('OTA', 'OTA_13826_TPC_NO_MEASURE_DEF');
221: fnd_message.raise_error;
222: else
223: close csr_booking_event;
224: hr_utility.set_location(' Step:'|| l_proc, 70);
225: if (p_event_id is not null and l_cost_level <> 'EVENT') then

Line 226: fnd_message.set_name('OTA', 'OTA_13842_TPC_NOT_EVENT_COSTS');

222: else
223: close csr_booking_event;
224: hr_utility.set_location(' Step:'|| l_proc, 70);
225: if (p_event_id is not null and l_cost_level <> 'EVENT') then
226: fnd_message.set_name('OTA', 'OTA_13842_TPC_NOT_EVENT_COSTS');
227: fnd_message.raise_error;
228: elsif
229: (p_event_id is null and l_cost_level = 'EVENT') then
230: fnd_message.set_name('OTA', 'OTA_13832_TPC_EVENT_COST_LEVEL');

Line 227: fnd_message.raise_error;

223: close csr_booking_event;
224: hr_utility.set_location(' Step:'|| l_proc, 70);
225: if (p_event_id is not null and l_cost_level <> 'EVENT') then
226: fnd_message.set_name('OTA', 'OTA_13842_TPC_NOT_EVENT_COSTS');
227: fnd_message.raise_error;
228: elsif
229: (p_event_id is null and l_cost_level = 'EVENT') then
230: fnd_message.set_name('OTA', 'OTA_13832_TPC_EVENT_COST_LEVEL');
231: fnd_message.raise_error;

Line 230: fnd_message.set_name('OTA', 'OTA_13832_TPC_EVENT_COST_LEVEL');

226: fnd_message.set_name('OTA', 'OTA_13842_TPC_NOT_EVENT_COSTS');
227: fnd_message.raise_error;
228: elsif
229: (p_event_id is null and l_cost_level = 'EVENT') then
230: fnd_message.set_name('OTA', 'OTA_13832_TPC_EVENT_COST_LEVEL');
231: fnd_message.raise_error;
232: elsif (p_booking_id is not null) and
233: (l_cost_level = 'PLAN' OR l_cost_level = 'EVENT') then
234: hr_utility.set_location(' Step:'|| l_proc, 80);

Line 231: fnd_message.raise_error;

227: fnd_message.raise_error;
228: elsif
229: (p_event_id is null and l_cost_level = 'EVENT') then
230: fnd_message.set_name('OTA', 'OTA_13832_TPC_EVENT_COST_LEVEL');
231: fnd_message.raise_error;
232: elsif (p_booking_id is not null) and
233: (l_cost_level = 'PLAN' OR l_cost_level = 'EVENT') then
234: hr_utility.set_location(' Step:'|| l_proc, 80);
235: fnd_message.set_name('OTA', 'OTA_13833_TPC_DELEGATE_COST');

Line 235: fnd_message.set_name('OTA', 'OTA_13833_TPC_DELEGATE_COST');

231: fnd_message.raise_error;
232: elsif (p_booking_id is not null) and
233: (l_cost_level = 'PLAN' OR l_cost_level = 'EVENT') then
234: hr_utility.set_location(' Step:'|| l_proc, 80);
235: fnd_message.set_name('OTA', 'OTA_13833_TPC_DELEGATE_COST');
236: fnd_message.raise_error;
237: elsif (p_booking_id is null) and
238: (l_cost_level = 'DELEGATE') then
239: hr_utility.set_location(' Step:'|| l_proc, 90);

Line 236: fnd_message.raise_error;

232: elsif (p_booking_id is not null) and
233: (l_cost_level = 'PLAN' OR l_cost_level = 'EVENT') then
234: hr_utility.set_location(' Step:'|| l_proc, 80);
235: fnd_message.set_name('OTA', 'OTA_13833_TPC_DELEGATE_COST');
236: fnd_message.raise_error;
237: elsif (p_booking_id is null) and
238: (l_cost_level = 'DELEGATE') then
239: hr_utility.set_location(' Step:'|| l_proc, 90);
240: fnd_message.set_name('OTA', 'OTA_13841_TPC_SUPPLY_DELEGATE');

Line 240: fnd_message.set_name('OTA', 'OTA_13841_TPC_SUPPLY_DELEGATE');

236: fnd_message.raise_error;
237: elsif (p_booking_id is null) and
238: (l_cost_level = 'DELEGATE') then
239: hr_utility.set_location(' Step:'|| l_proc, 90);
240: fnd_message.set_name('OTA', 'OTA_13841_TPC_SUPPLY_DELEGATE');
241: fnd_message.raise_error;
242: end if;
243: end if;
244: --

Line 241: fnd_message.raise_error;

237: elsif (p_booking_id is null) and
238: (l_cost_level = 'DELEGATE') then
239: hr_utility.set_location(' Step:'|| l_proc, 90);
240: fnd_message.set_name('OTA', 'OTA_13841_TPC_SUPPLY_DELEGATE');
241: fnd_message.raise_error;
242: end if;
243: end if;
244: --
245: hr_utility.set_location(' Leaving:'||l_proc, 100);

Line 301: fnd_message.set_name('OTA', 'OTA_13834_TPC_NO_EVENT');

297: fetch csr_event_id into l_business_group_id, l_event_start_date;
298: if csr_event_id%NOTFOUND then
299: close csr_event_id;
300: hr_utility.set_location(' Step:'|| l_proc, 70);
301: fnd_message.set_name('OTA', 'OTA_13834_TPC_NO_EVENT');
302: fnd_message.raise_error;
303: else
304: close csr_event_id;
305: hr_utility.set_location(' Step:'|| l_proc, 80);

Line 302: fnd_message.raise_error;

298: if csr_event_id%NOTFOUND then
299: close csr_event_id;
300: hr_utility.set_location(' Step:'|| l_proc, 70);
301: fnd_message.set_name('OTA', 'OTA_13834_TPC_NO_EVENT');
302: fnd_message.raise_error;
303: else
304: close csr_event_id;
305: hr_utility.set_location(' Step:'|| l_proc, 80);
306: if l_business_group_id <> p_business_group_id then

Line 307: fnd_message.set_name('OTA', 'OTA_13835_TPC_EVENT_BAD_BG');

303: else
304: close csr_event_id;
305: hr_utility.set_location(' Step:'|| l_proc, 80);
306: if l_business_group_id <> p_business_group_id then
307: fnd_message.set_name('OTA', 'OTA_13835_TPC_EVENT_BAD_BG');
308: fnd_message.raise_error;
309: end if;
310: end if;
311: --

Line 308: fnd_message.raise_error;

304: close csr_event_id;
305: hr_utility.set_location(' Step:'|| l_proc, 80);
306: if l_business_group_id <> p_business_group_id then
307: fnd_message.set_name('OTA', 'OTA_13835_TPC_EVENT_BAD_BG');
308: fnd_message.raise_error;
309: end if;
310: end if;
311: --
312: -- Check that the dates correspond, if there is a course start date

Line 321: fnd_message.set_name('OTA', 'OTA_13836_TPC_EVENT_DATE');

317: fetch csr_event_id_dates into l_plan_start_date;
318: close csr_event_id_dates;
319: if l_plan_start_date > l_event_start_date then
320: hr_utility.set_location(' Step:'|| l_proc, 100);
321: fnd_message.set_name('OTA', 'OTA_13836_TPC_EVENT_DATE');
322: fnd_message.raise_error;
323: end if;
324: end if;
325: end if;

Line 322: fnd_message.raise_error;

318: close csr_event_id_dates;
319: if l_plan_start_date > l_event_start_date then
320: hr_utility.set_location(' Step:'|| l_proc, 100);
321: fnd_message.set_name('OTA', 'OTA_13836_TPC_EVENT_DATE');
322: fnd_message.raise_error;
323: end if;
324: end if;
325: end if;
326: --

Line 404: fnd_message.set_name('AOL', 'MC_INVALID_CURRENCY');

400: open csr_currency_code;
401: fetch csr_currency_code into l_exists;
402: if csr_currency_code%NOTFOUND then
403: close csr_currency_code;
404: fnd_message.set_name('AOL', 'MC_INVALID_CURRENCY');
405: fnd_message.set_token('CODE', p_currency_code);
406: fnd_message.raise_error;
407: else
408: close csr_currency_code;

Line 405: fnd_message.set_token('CODE', p_currency_code);

401: fetch csr_currency_code into l_exists;
402: if csr_currency_code%NOTFOUND then
403: close csr_currency_code;
404: fnd_message.set_name('AOL', 'MC_INVALID_CURRENCY');
405: fnd_message.set_token('CODE', p_currency_code);
406: fnd_message.raise_error;
407: else
408: close csr_currency_code;
409: end if;

Line 406: fnd_message.raise_error;

402: if csr_currency_code%NOTFOUND then
403: close csr_currency_code;
404: fnd_message.set_name('AOL', 'MC_INVALID_CURRENCY');
405: fnd_message.set_token('CODE', p_currency_code);
406: fnd_message.raise_error;
407: else
408: close csr_currency_code;
409: end if;
410: end if;

Line 419: fnd_message.set_name('OTA', 'OTA_13826_TPC_NO_MEASURE_DEF');

415: open csr_unit;
416: fetch csr_unit into l_unit;
417: if csr_unit%NOTFOUND then
418: close csr_unit;
419: fnd_message.set_name('OTA', 'OTA_13826_TPC_NO_MEASURE_DEF');
420: fnd_message.raise_error;
421: else
422: close csr_unit;
423: if (l_unit = 'M' and p_currency_code is null)

Line 420: fnd_message.raise_error;

416: fetch csr_unit into l_unit;
417: if csr_unit%NOTFOUND then
418: close csr_unit;
419: fnd_message.set_name('OTA', 'OTA_13826_TPC_NO_MEASURE_DEF');
420: fnd_message.raise_error;
421: else
422: close csr_unit;
423: if (l_unit = 'M' and p_currency_code is null)
424: or (l_unit <> 'M' and p_currency_code is not null) then

Line 425: fnd_message.set_name('OTA', 'OTA_13838_TPC_BAD_CURR_VALUE');

421: else
422: close csr_unit;
423: if (l_unit = 'M' and p_currency_code is null)
424: or (l_unit <> 'M' and p_currency_code is not null) then
425: fnd_message.set_name('OTA', 'OTA_13838_TPC_BAD_CURR_VALUE');
426: fnd_message.raise_error;
427: end if;
428: end if;
429: --

Line 426: fnd_message.raise_error;

422: close csr_unit;
423: if (l_unit = 'M' and p_currency_code is null)
424: or (l_unit <> 'M' and p_currency_code is not null) then
425: fnd_message.set_name('OTA', 'OTA_13838_TPC_BAD_CURR_VALUE');
426: fnd_message.raise_error;
427: end if;
428: end if;
429: --
430: -- validate the format of the value field

Line 500: fnd_message.set_name('OTA', 'OTA_13837_TPC_BAD_UNIQUE_COST');

496: fetch csr_unique into l_exists;
497: if csr_unique%FOUND then
498: close csr_unique;
499: hr_utility.set_location(' Step:'|| l_proc, 60);
500: fnd_message.set_name('OTA', 'OTA_13837_TPC_BAD_UNIQUE_COST');
501: fnd_message.raise_error;
502: else
503: close csr_unique;
504: hr_utility.set_location(' Step:'|| l_proc, 70);

Line 501: fnd_message.raise_error;

497: if csr_unique%FOUND then
498: close csr_unique;
499: hr_utility.set_location(' Step:'|| l_proc, 60);
500: fnd_message.set_name('OTA', 'OTA_13837_TPC_BAD_UNIQUE_COST');
501: fnd_message.raise_error;
502: else
503: close csr_unique;
504: hr_utility.set_location(' Step:'|| l_proc, 70);
505: end if;