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

Line 162: fnd_message.set_name('OTA','OTA_13264_TRB_ROLE_TO_PLAY_TYP');

158: --
159: open chk_roleplay;
160: fetch chk_roleplay into l_exists;
161: IF chk_roleplay%notfound THEN
162: fnd_message.set_name('OTA','OTA_13264_TRB_ROLE_TO_PLAY_TYP');
163: close chk_roleplay;
164: fnd_message.raise_error;
165: END IF;
166: close chk_roleplay;

Line 164: fnd_message.raise_error;

160: fetch chk_roleplay into l_exists;
161: IF chk_roleplay%notfound THEN
162: fnd_message.set_name('OTA','OTA_13264_TRB_ROLE_TO_PLAY_TYP');
163: close chk_roleplay;
164: fnd_message.raise_error;
165: END IF;
166: close chk_roleplay;
167: --
168: hr_utility.set_location('Leaving:'||l_proc,10);

Line 188: fnd_message.set_name('OTA','OTA_13264_TRB_ROLE_TO_PLAY_TYP');

184: --
185: IF p_role_to_play is not null THEN
186: IF not check_resource_type(p_supplied_resource_id,
187: 'T') THEN
188: fnd_message.set_name('OTA','OTA_13264_TRB_ROLE_TO_PLAY_TYP');
189: fnd_message.raise_error;
190: END IF;
191: END IF;
192: --

Line 189: fnd_message.raise_error;

185: IF p_role_to_play is not null THEN
186: IF not check_resource_type(p_supplied_resource_id,
187: 'T') THEN
188: fnd_message.set_name('OTA','OTA_13264_TRB_ROLE_TO_PLAY_TYP');
189: fnd_message.raise_error;
190: END IF;
191: END IF;
192: --
193: hr_utility.set_location('Leaving:'||l_proc,10);

Line 298: fnd_message.set_name('OTA','OTA_13265_TRB_QUANTITY_ENTERED');

294: --
295: if p_quantity > 1 then
296: if check_resource_type(p_supplied_resource_id,
297: 'V') THEN
298: fnd_message.set_name('OTA','OTA_13265_TRB_QUANTITY_ENTERED');
299: fnd_message.raise_error;
300: elsif check_resource_type(p_supplied_resource_id,
301: 'T') THEN
302: fnd_message.set_name('OTA','OTA_13265_TRB_QUANTITY_ENTERED');

Line 299: fnd_message.raise_error;

295: if p_quantity > 1 then
296: if check_resource_type(p_supplied_resource_id,
297: 'V') THEN
298: fnd_message.set_name('OTA','OTA_13265_TRB_QUANTITY_ENTERED');
299: fnd_message.raise_error;
300: elsif check_resource_type(p_supplied_resource_id,
301: 'T') THEN
302: fnd_message.set_name('OTA','OTA_13265_TRB_QUANTITY_ENTERED');
303: fnd_message.raise_error;

Line 302: fnd_message.set_name('OTA','OTA_13265_TRB_QUANTITY_ENTERED');

298: fnd_message.set_name('OTA','OTA_13265_TRB_QUANTITY_ENTERED');
299: fnd_message.raise_error;
300: elsif check_resource_type(p_supplied_resource_id,
301: 'T') THEN
302: fnd_message.set_name('OTA','OTA_13265_TRB_QUANTITY_ENTERED');
303: fnd_message.raise_error;
304: else
305: null;
306: --open chk_per;

Line 303: fnd_message.raise_error;

299: fnd_message.raise_error;
300: elsif check_resource_type(p_supplied_resource_id,
301: 'T') THEN
302: fnd_message.set_name('OTA','OTA_13265_TRB_QUANTITY_ENTERED');
303: fnd_message.raise_error;
304: else
305: null;
306: --open chk_per;
307: --fetch chk_per into l_person_id;

Line 310: --fnd_message.set_name('OTA','OTA_13265_TRB_QUANTITY_ENTERED');

306: --open chk_per;
307: --fetch chk_per into l_person_id;
308: --close chk_per;
309: --IF l_person_id is not null THEN
310: --fnd_message.set_name('OTA','OTA_13265_TRB_QUANTITY_ENTERED');
311: --fnd_message.raise_error;
312: --end if;
313: end if;
314: end if;

Line 311: --fnd_message.raise_error;

307: --fetch chk_per into l_person_id;
308: --close chk_per;
309: --IF l_person_id is not null THEN
310: --fnd_message.set_name('OTA','OTA_13265_TRB_QUANTITY_ENTERED');
311: --fnd_message.raise_error;
312: --end if;
313: end if;
314: end if;
315: --

Line 346: fnd_message.set_name('OTA','OTA_13266_TRB_DELIVERY_ADDRESS');

342: --
343: open chk_type;
344: fetch chk_type into l_exists;
345: IF l_exists = '1' AND p_del_add is not null THEN
346: fnd_message.set_name('OTA','OTA_13266_TRB_DELIVERY_ADDRESS');
347: close chk_type;
348: fnd_message.raise_error;
349: END IF;
350: close chk_type;

Line 348: fnd_message.raise_error;

344: fetch chk_type into l_exists;
345: IF l_exists = '1' AND p_del_add is not null THEN
346: fnd_message.set_name('OTA','OTA_13266_TRB_DELIVERY_ADDRESS');
347: close chk_type;
348: fnd_message.raise_error;
349: END IF;
350: close chk_type;
351: --
352: hr_utility.set_location('Leaving:'||l_proc,10);

Line 383: fnd_message.set_name('OTA','OTA_13267_TRB_BOOKING_ID');

379: --
380: open get_book;
381: fetch get_book into l_resbook_id;
382: IF get_book%notfound THEN
383: fnd_message.set_name('OTA','OTA_13267_TRB_BOOKING_ID');
384: close get_book;
385: fnd_message.raise_error;
386: END IF;
387: close get_book;

Line 385: fnd_message.raise_error;

381: fetch get_book into l_resbook_id;
382: IF get_book%notfound THEN
383: fnd_message.set_name('OTA','OTA_13267_TRB_BOOKING_ID');
384: close get_book;
385: fnd_message.raise_error;
386: END IF;
387: close get_book;
388: --
389: return (l_resbook_id);

Line 585: fnd_message.set_name('OTA','OTA_13269_TRB_REQUIRED_DATES');

581: --
582: open chk_dates_tsr;
583: fetch chk_dates_tsr into l_exists;
584: IF chk_dates_tsr%notfound THEN
585: fnd_message.set_name('OTA','OTA_13269_TRB_REQUIRED_DATES');
586: close chk_dates_tsr;
587: fnd_message.raise_error;
588: END IF;
589: close chk_dates_tsr;

Line 587: fnd_message.raise_error;

583: fetch chk_dates_tsr into l_exists;
584: IF chk_dates_tsr%notfound THEN
585: fnd_message.set_name('OTA','OTA_13269_TRB_REQUIRED_DATES');
586: close chk_dates_tsr;
587: fnd_message.raise_error;
588: END IF;
589: close chk_dates_tsr;
590: --
591: hr_utility.set_location('Leaving:'||l_proc,10);

Line 629: fnd_message.set_name('OTA','OTA_13270_BUS_GROUP_EQUAL');

625: --
626: open chk_bgroup;
627: fetch chk_bgroup into l_exists;
628: IF chk_bgroup%notfound THEN
629: fnd_message.set_name('OTA','OTA_13270_BUS_GROUP_EQUAL');
630: close chk_bgroup;
631: fnd_message.raise_error;
632: END IF;
633: close chk_bgroup;

Line 631: fnd_message.raise_error;

627: fetch chk_bgroup into l_exists;
628: IF chk_bgroup%notfound THEN
629: fnd_message.set_name('OTA','OTA_13270_BUS_GROUP_EQUAL');
630: close chk_bgroup;
631: fnd_message.raise_error;
632: END IF;
633: close chk_bgroup;
634: --
635: hr_utility.set_location('Leaving:'||l_proc,10);

Line 654: ELSE fnd_message.set_name('OTA','OTA_13271_TRB_FROM_TO_DATES');

650: begin
651: hr_utility.set_location('Entering:'||l_proc,5);
652: --
653: IF p_req_from <= nvl(p_req_to,hr_api.g_eot) THEN null;
654: ELSE fnd_message.set_name('OTA','OTA_13271_TRB_FROM_TO_DATES');
655: fnd_message.raise_error;
656: END IF;
657: --
658: hr_utility.set_location('Leaving:'||l_proc,10);

Line 655: fnd_message.raise_error;

651: hr_utility.set_location('Entering:'||l_proc,5);
652: --
653: IF p_req_from <= nvl(p_req_to,hr_api.g_eot) THEN null;
654: ELSE fnd_message.set_name('OTA','OTA_13271_TRB_FROM_TO_DATES');
655: fnd_message.raise_error;
656: END IF;
657: --
658: hr_utility.set_location('Leaving:'||l_proc,10);
659: end check_from_to_dates;

Line 690: fnd_message.set_name('OTA','OTA_13278_TRB_CHECK_TRA_DATES');

686: --
687: open chk_dates;
688: fetch chk_dates into l_exists;
689: IF chk_dates%found THEN
690: fnd_message.set_name('OTA','OTA_13278_TRB_CHECK_TRA_DATES');
691: close chk_dates;
692: fnd_message.raise_error;
693: END IF;
694: close chk_dates;

Line 692: fnd_message.raise_error;

688: fetch chk_dates into l_exists;
689: IF chk_dates%found THEN
690: fnd_message.set_name('OTA','OTA_13278_TRB_CHECK_TRA_DATES');
691: close chk_dates;
692: fnd_message.raise_error;
693: END IF;
694: close chk_dates;
695: --
696: hr_utility.set_location('Leaving:'||l_proc,10);

Line 725: fnd_message.set_name('OTA','OTA_13272_TRB_ALLOCATION_EXIST');

721: --
722: open chk_trn;
723: fetch chk_trn into l_exists;
724: IF chk_trn%found THEN
725: fnd_message.set_name('OTA','OTA_13272_TRB_ALLOCATION_EXIST');
726: close chk_trn;
727: fnd_message.raise_error;
728: END IF;
729: close chk_trn;

Line 727: fnd_message.raise_error;

723: fetch chk_trn into l_exists;
724: IF chk_trn%found THEN
725: fnd_message.set_name('OTA','OTA_13272_TRB_ALLOCATION_EXIST');
726: close chk_trn;
727: fnd_message.raise_error;
728: END IF;
729: close chk_trn;
730: --
731: hr_utility.set_location('Leaving:'||l_proc,10);

Line 760: fnd_message.set_name('OTA','OTA_13272_TRB_ALLOCATION_EXIST');

756: --
757: open chk_res;
758: fetch chk_res into l_exists;
759: IF chk_res%found THEN
760: fnd_message.set_name('OTA','OTA_13272_TRB_ALLOCATION_EXIST');
761: close chk_res;
762: fnd_message.raise_error;
763: END IF;
764: close chk_res;

Line 762: fnd_message.raise_error;

758: fetch chk_res into l_exists;
759: IF chk_res%found THEN
760: fnd_message.set_name('OTA','OTA_13272_TRB_ALLOCATION_EXIST');
761: close chk_res;
762: fnd_message.raise_error;
763: END IF;
764: close chk_res;
765: --
766: hr_utility.set_location('Leaving:'||l_proc,10);

Line 795: fnd_message.set_name('OTA','OTA_13204_GEN_INVALID_LOOKUP');

791: --
792: open chk_status;
793: fetch chk_status into l_exists;
794: IF chk_status%notfound THEN
795: fnd_message.set_name('OTA','OTA_13204_GEN_INVALID_LOOKUP');
796: fnd_message.set_token('FIELD','Status');
797: fnd_message.set_token('LOOKUP_TYPE','RESOURCE_BOOKING_STATUS');
798: close chk_status;
799: fnd_message.raise_error;

Line 796: fnd_message.set_token('FIELD','Status');

792: open chk_status;
793: fetch chk_status into l_exists;
794: IF chk_status%notfound THEN
795: fnd_message.set_name('OTA','OTA_13204_GEN_INVALID_LOOKUP');
796: fnd_message.set_token('FIELD','Status');
797: fnd_message.set_token('LOOKUP_TYPE','RESOURCE_BOOKING_STATUS');
798: close chk_status;
799: fnd_message.raise_error;
800: END IF;

Line 797: fnd_message.set_token('LOOKUP_TYPE','RESOURCE_BOOKING_STATUS');

793: fetch chk_status into l_exists;
794: IF chk_status%notfound THEN
795: fnd_message.set_name('OTA','OTA_13204_GEN_INVALID_LOOKUP');
796: fnd_message.set_token('FIELD','Status');
797: fnd_message.set_token('LOOKUP_TYPE','RESOURCE_BOOKING_STATUS');
798: close chk_status;
799: fnd_message.raise_error;
800: END IF;
801: close chk_status;

Line 799: fnd_message.raise_error;

795: fnd_message.set_name('OTA','OTA_13204_GEN_INVALID_LOOKUP');
796: fnd_message.set_token('FIELD','Status');
797: fnd_message.set_token('LOOKUP_TYPE','RESOURCE_BOOKING_STATUS');
798: close chk_status;
799: fnd_message.raise_error;
800: END IF;
801: close chk_status;
802: --
803: hr_utility.set_location('Leaving:'||l_proc,10);

Line 867: fnd_message.set_name('OTA','OTA_13273_TRB_PRIMARY_VENUE');

863: IF p_prim_ven = 'Y' THEN
864: open chk_primven;
865: fetch chk_primven into l_exists;
866: IF chk_primven%found THEN
867: fnd_message.set_name('OTA','OTA_13273_TRB_PRIMARY_VENUE');
868: close chk_primven;
869: fnd_message.raise_error;
870: END IF;
871: close chk_primven;

Line 869: fnd_message.raise_error;

865: fetch chk_primven into l_exists;
866: IF chk_primven%found THEN
867: fnd_message.set_name('OTA','OTA_13273_TRB_PRIMARY_VENUE');
868: close chk_primven;
869: fnd_message.raise_error;
870: END IF;
871: close chk_primven;
872: END IF;
873: --

Line 1657: fnd_message.set_name('OTA','OTA_13395_TRB_RES_DOUBLEBOOK');

1653: ,p_resource_booking_id
1654: ,p_book_entire_period_flag
1655: ,p_timezone
1656: ) then
1657: fnd_message.set_name('OTA','OTA_13395_TRB_RES_DOUBLEBOOK');
1658: fnd_message.raise_error;
1659: end if;
1660: end if;
1661: --

Line 1658: fnd_message.raise_error;

1654: ,p_book_entire_period_flag
1655: ,p_timezone
1656: ) then
1657: fnd_message.set_name('OTA','OTA_13395_TRB_RES_DOUBLEBOOK');
1658: fnd_message.raise_error;
1659: end if;
1660: end if;
1661: --
1662: end check_trainer_venue_book;

Line 1768: fnd_message.set_name('OTA','OTA_13274_TRB_TFL_EXIST');

1764: --
1765: open chk_tfl;
1766: fetch chk_tfl into l_exists;
1767: IF chk_tfl%found THEN
1768: fnd_message.set_name('OTA','OTA_13274_TRB_TFL_EXIST');
1769: close chk_tfl;
1770: fnd_message.raise_error;
1771: ELSE close chk_tfl;
1772: END IF;

Line 1770: fnd_message.raise_error;

1766: fetch chk_tfl into l_exists;
1767: IF chk_tfl%found THEN
1768: fnd_message.set_name('OTA','OTA_13274_TRB_TFL_EXIST');
1769: close chk_tfl;
1770: fnd_message.raise_error;
1771: ELSE close chk_tfl;
1772: END IF;
1773: --
1774: hr_utility.set_location('Leaving:'||l_proc,10);

Line 1805: fnd_message.set_name('OTA','OTA_13275_TRB_WRONG_EVENT_TYPE');

1801: open chk_type;
1802: fetch chk_type into l_exists;
1803: IF chk_type%notfound THEN
1804: close chk_type;
1805: fnd_message.set_name('OTA','OTA_13275_TRB_WRONG_EVENT_TYPE');
1806: fnd_message.raise_error;
1807: ELSE close chk_type;
1808: END IF;
1809: --

Line 1806: fnd_message.raise_error;

1802: fetch chk_type into l_exists;
1803: IF chk_type%notfound THEN
1804: close chk_type;
1805: fnd_message.set_name('OTA','OTA_13275_TRB_WRONG_EVENT_TYPE');
1806: fnd_message.raise_error;
1807: ELSE close chk_type;
1808: END IF;
1809: --
1810: hr_utility.set_location('Leaving:'||l_proc,10);

Line 2022: fnd_message.set_name('OTA','OTA_13640_TRB_START_END_TIMES');

2018: to_number(substr(p_end_time, 1, 2))
2019: and to_number(substr(p_start_time, 4, 2)) >
2020: to_number(substr(p_end_time, 4, 2))) then
2021: --
2022: fnd_message.set_name('OTA','OTA_13640_TRB_START_END_TIMES');
2023: fnd_message.raise_error;
2024: --
2025: end if;
2026: --

Line 2023: fnd_message.raise_error;

2019: and to_number(substr(p_start_time, 4, 2)) >
2020: to_number(substr(p_end_time, 4, 2))) then
2021: --
2022: fnd_message.set_name('OTA','OTA_13640_TRB_START_END_TIMES');
2023: fnd_message.raise_error;
2024: --
2025: end if;
2026: --
2027: hr_utility.set_location('Leaving:'||l_proc,10);