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

Line 63: fnd_message.set_name ('OTA', 'OTA_13236_TDB_NO_PERSON_ADDR');

59: if c_address%notfound then
60: --
61: close c_address;
62: --
63: fnd_message.set_name ('OTA', 'OTA_13236_TDB_NO_PERSON_ADDR');
64: fnd_message.set_token ('PERSON_TYPE', p_delegate_or_contact);
65: fnd_message.raise_error;
66: --
67: end if;

Line 64: fnd_message.set_token ('PERSON_TYPE', p_delegate_or_contact);

60: --
61: close c_address;
62: --
63: fnd_message.set_name ('OTA', 'OTA_13236_TDB_NO_PERSON_ADDR');
64: fnd_message.set_token ('PERSON_TYPE', p_delegate_or_contact);
65: fnd_message.raise_error;
66: --
67: end if;
68: --

Line 65: fnd_message.raise_error;

61: close c_address;
62: --
63: fnd_message.set_name ('OTA', 'OTA_13236_TDB_NO_PERSON_ADDR');
64: fnd_message.set_token ('PERSON_TYPE', p_delegate_or_contact);
65: fnd_message.raise_error;
66: --
67: end if;
68: --
69: close c_address;

Line 203: --fnd_message.set_name('OTA', 'OTA_13670_TDB_DOUBLE_BOOKING');

199: l_dummy in (g_attended_booking, g_placed_booking) then
200: --
201: -- Professional UI requires only a warning message.
202: --
203: --fnd_message.set_name('OTA', 'OTA_13670_TDB_DOUBLE_BOOKING');
204: --fnd_message.raise_error;
205: l_warn := true;
206: --
207: else

Line 204: --fnd_message.raise_error;

200: --
201: -- Professional UI requires only a warning message.
202: --
203: --fnd_message.set_name('OTA', 'OTA_13670_TDB_DOUBLE_BOOKING');
204: --fnd_message.raise_error;
205: l_warn := true;
206: --
207: else
208: --

Line 308: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');

304: p_person_type,
305: p_person_address_type) then
306: --
307: if p_person_address_type = 'INTERNAL' then
308: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
309: fnd_message.set_token ('TABLE_NAME', 'OTA_PEOPLE_V');
310: fnd_message.set_token ('COLUMN_NAME', p_person_type||' Person');
311: fnd_message.raise_error;
312: elsif p_person_address_type = 'INTERNAL' then

Line 309: fnd_message.set_token ('TABLE_NAME', 'OTA_PEOPLE_V');

305: p_person_address_type) then
306: --
307: if p_person_address_type = 'INTERNAL' then
308: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
309: fnd_message.set_token ('TABLE_NAME', 'OTA_PEOPLE_V');
310: fnd_message.set_token ('COLUMN_NAME', p_person_type||' Person');
311: fnd_message.raise_error;
312: elsif p_person_address_type = 'INTERNAL' then
313: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');

Line 310: fnd_message.set_token ('COLUMN_NAME', p_person_type||' Person');

306: --
307: if p_person_address_type = 'INTERNAL' then
308: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
309: fnd_message.set_token ('TABLE_NAME', 'OTA_PEOPLE_V');
310: fnd_message.set_token ('COLUMN_NAME', p_person_type||' Person');
311: fnd_message.raise_error;
312: elsif p_person_address_type = 'INTERNAL' then
313: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
314: fnd_message.set_token ('TABLE_NAME', 'OTA_CUST_CONTACTS_V');

Line 311: fnd_message.raise_error;

307: if p_person_address_type = 'INTERNAL' then
308: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
309: fnd_message.set_token ('TABLE_NAME', 'OTA_PEOPLE_V');
310: fnd_message.set_token ('COLUMN_NAME', p_person_type||' Person');
311: fnd_message.raise_error;
312: elsif p_person_address_type = 'INTERNAL' then
313: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
314: fnd_message.set_token ('TABLE_NAME', 'OTA_CUST_CONTACTS_V');
315: fnd_message.set_token ('COLUMN_NAME', p_person_type||' Person');

Line 313: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');

309: fnd_message.set_token ('TABLE_NAME', 'OTA_PEOPLE_V');
310: fnd_message.set_token ('COLUMN_NAME', p_person_type||' Person');
311: fnd_message.raise_error;
312: elsif p_person_address_type = 'INTERNAL' then
313: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
314: fnd_message.set_token ('TABLE_NAME', 'OTA_CUST_CONTACTS_V');
315: fnd_message.set_token ('COLUMN_NAME', p_person_type||' Person');
316: fnd_message.raise_error;
317: end if;

Line 314: fnd_message.set_token ('TABLE_NAME', 'OTA_CUST_CONTACTS_V');

310: fnd_message.set_token ('COLUMN_NAME', p_person_type||' Person');
311: fnd_message.raise_error;
312: elsif p_person_address_type = 'INTERNAL' then
313: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
314: fnd_message.set_token ('TABLE_NAME', 'OTA_CUST_CONTACTS_V');
315: fnd_message.set_token ('COLUMN_NAME', p_person_type||' Person');
316: fnd_message.raise_error;
317: end if;
318: --

Line 315: fnd_message.set_token ('COLUMN_NAME', p_person_type||' Person');

311: fnd_message.raise_error;
312: elsif p_person_address_type = 'INTERNAL' then
313: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
314: fnd_message.set_token ('TABLE_NAME', 'OTA_CUST_CONTACTS_V');
315: fnd_message.set_token ('COLUMN_NAME', p_person_type||' Person');
316: fnd_message.raise_error;
317: end if;
318: --
319: end if;

Line 316: fnd_message.raise_error;

312: elsif p_person_address_type = 'INTERNAL' then
313: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
314: fnd_message.set_token ('TABLE_NAME', 'OTA_CUST_CONTACTS_V');
315: fnd_message.set_token ('COLUMN_NAME', p_person_type||' Person');
316: fnd_message.raise_error;
317: end if;
318: --
319: end if;
320: --

Line 398: fnd_message.set_name ('OTA','OTA_13510_ORG_BUSINESS_GROUP');

394: if not c_organization%found then
395: --
396: -- This organization has a different business group
397: --
398: fnd_message.set_name ('OTA','OTA_13510_ORG_BUSINESS_GROUP');
399: fnd_message.raise_error;
400: --
401: end if;
402: close c_organization;

Line 399: fnd_message.raise_error;

395: --
396: -- This organization has a different business group
397: --
398: fnd_message.set_name ('OTA','OTA_13510_ORG_BUSINESS_GROUP');
399: fnd_message.raise_error;
400: --
401: end if;
402: close c_organization;
403: --

Line 416: fnd_message.set_name ('OTA','OTA_13584_DEL_BUSINESS_GROUP');

412: if not c_person%found then
413: --
414: -- The delegate has adifferent business group
415: --
416: fnd_message.set_name ('OTA','OTA_13584_DEL_BUSINESS_GROUP');
417: fnd_message.raise_error;
418: --
419: end if;
420: close c_person;

Line 417: fnd_message.raise_error;

413: --
414: -- The delegate has adifferent business group
415: --
416: fnd_message.set_name ('OTA','OTA_13584_DEL_BUSINESS_GROUP');
417: fnd_message.raise_error;
418: --
419: end if;
420: close c_person;
421: --

Line 436: fnd_message.set_name ('OTA','OTA_13585_CON_BUSINESS_GROUP');

432: if not c_person%found then
433: --
434: -- The delegate has adifferent business group
435: --
436: fnd_message.set_name ('OTA','OTA_13585_CON_BUSINESS_GROUP');
437: fnd_message.raise_error;
438: --
439: end if;
440: close c_person;

Line 437: fnd_message.raise_error;

433: --
434: -- The delegate has adifferent business group
435: --
436: fnd_message.set_name ('OTA','OTA_13585_CON_BUSINESS_GROUP');
437: fnd_message.raise_error;
438: --
439: end if;
440: close c_person;
441: --

Line 456: fnd_message.set_name ('OTA','OTA_13586_DEL_ASS_BUS_GROUP');

452: if not c_assignment%found then
453: --
454: -- The delegate assignment has a different business group
455: --
456: fnd_message.set_name ('OTA','OTA_13586_DEL_ASS_BUS_GROUP');
457: fnd_message.raise_error;
458: --
459: end if;
460: close c_assignment;

Line 457: fnd_message.raise_error;

453: --
454: -- The delegate assignment has a different business group
455: --
456: fnd_message.set_name ('OTA','OTA_13586_DEL_ASS_BUS_GROUP');
457: fnd_message.raise_error;
458: --
459: end if;
460: close c_assignment;
461: --

Line 476: fnd_message.set_name ('OTA','OTA_13587_SPON_ASS_BUS_GROUP');

472: if not c_assignment%found then
473: --
474: -- The sponsor assignment has a different business group
475: --
476: fnd_message.set_name ('OTA','OTA_13587_SPON_ASS_BUS_GROUP');
477: fnd_message.raise_error;
478: --
479: end if;
480: close c_assignment;

Line 477: fnd_message.raise_error;

473: --
474: -- The sponsor assignment has a different business group
475: --
476: fnd_message.set_name ('OTA','OTA_13587_SPON_ASS_BUS_GROUP');
477: fnd_message.raise_error;
478: --
479: end if;
480: close c_assignment;
481: --

Line 546: fnd_message.set_name ('OTA','OTA_13509_CONTACT_ADDRESS_INV');

542: if not l_address%found then
543: --
544: -- Not a valid address for this customer
545: --
546: fnd_message.set_name ('OTA','OTA_13509_CONTACT_ADDRESS_INV');
547: fnd_message.raise_error;
548: --
549: end if;
550: close l_address;

Line 547: fnd_message.raise_error;

543: --
544: -- Not a valid address for this customer
545: --
546: fnd_message.set_name ('OTA','OTA_13509_CONTACT_ADDRESS_INV');
547: fnd_message.raise_error;
548: --
549: end if;
550: close l_address;
551: --

Line 591: fnd_message.set_name ('OTA','OTA_13503_SPONSOR_ASSIGNMENT');

587: --
588: -- Display error message as this should not occur
589: -- in this case p_sponsor_assignment_id is mandatory
590: --
591: fnd_message.set_name ('OTA','OTA_13503_SPONSOR_ASSIGNMENT');
592: fnd_message.raise_error;
593: end if;
594: --
595: if p_delegate_person_id is not null and

Line 592: fnd_message.raise_error;

588: -- Display error message as this should not occur
589: -- in this case p_sponsor_assignment_id is mandatory
590: --
591: fnd_message.set_name ('OTA','OTA_13503_SPONSOR_ASSIGNMENT');
592: fnd_message.raise_error;
593: end if;
594: --
595: if p_delegate_person_id is not null and
596: p_delegate_assignment_id is null then

Line 601: fnd_message.set_name ('OTA','OTA_13502_DELEGATE_ASSIGNMENT');

597: --
598: -- Display error message as this should not occur
599: -- in this case p_delegate_assignment_id is mandatory
600: --
601: fnd_message.set_name ('OTA','OTA_13502_DELEGATE_ASSIGNMENT');
602: fnd_message.raise_error;
603: end if;
604: --
605: end if;

Line 602: fnd_message.raise_error;

598: -- Display error message as this should not occur
599: -- in this case p_delegate_assignment_id is mandatory
600: --
601: fnd_message.set_name ('OTA','OTA_13502_DELEGATE_ASSIGNMENT');
602: fnd_message.raise_error;
603: end if;
604: --
605: end if;
606: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 646: fnd_message.set_name ('OTA','OTA_13485_DELEGATE_MUST_NULL');

642: if p_enrollment_type = 'S' then
643: if (p_person_id is not null) and
644: (ota_tdb_shd.g_old_rec.delegate_contact_id is null) and
645: (p_booking_id is not null) then
646: fnd_message.set_name ('OTA','OTA_13485_DELEGATE_MUST_NULL');
647: fnd_message.raise_error;
648: end if;
649: if p_person_id is null then
650: --

Line 647: fnd_message.raise_error;

643: if (p_person_id is not null) and
644: (ota_tdb_shd.g_old_rec.delegate_contact_id is null) and
645: (p_booking_id is not null) then
646: fnd_message.set_name ('OTA','OTA_13485_DELEGATE_MUST_NULL');
647: fnd_message.raise_error;
648: end if;
649: if p_person_id is null then
650: --
651: fnd_message.set_name ('OTA', 'OTA_13484_DELEGATE_NULL');

Line 651: fnd_message.set_name ('OTA', 'OTA_13484_DELEGATE_NULL');

647: fnd_message.raise_error;
648: end if;
649: if p_person_id is null then
650: --
651: fnd_message.set_name ('OTA', 'OTA_13484_DELEGATE_NULL');
652: fnd_message.raise_error;
653: --
654: end if;
655: end if;

Line 652: fnd_message.raise_error;

648: end if;
649: if p_person_id is null then
650: --
651: fnd_message.set_name ('OTA', 'OTA_13484_DELEGATE_NULL');
652: fnd_message.raise_error;
653: --
654: end if;
655: end if;
656: --

Line 735: fnd_message.set_name ('OTA','OTA_13505_DELEGATE_VALID');

731: if p_delegate_person_id is not null then
732: open c_delegate;
733: fetch c_delegate into l_delegate_start_date,l_delegate_end_date;
734: if c_delegate%notfound then
735: fnd_message.set_name ('OTA','OTA_13505_DELEGATE_VALID');
736: fnd_message.raise_error;
737: end if;
738: close c_delegate;
739: --

Line 736: fnd_message.raise_error;

732: open c_delegate;
733: fetch c_delegate into l_delegate_start_date,l_delegate_end_date;
734: if c_delegate%notfound then
735: fnd_message.set_name ('OTA','OTA_13505_DELEGATE_VALID');
736: fnd_message.raise_error;
737: end if;
738: close c_delegate;
739: --
740: -- Check if delegate is valid for event and date booking placed date

Line 757: fnd_message.set_name ('OTA','OTA_13505_DELEGATE_VALID');

753: --
754: -- Delegate is not valid, display error
755: --
756: /*
757: fnd_message.set_name ('OTA','OTA_13505_DELEGATE_VALID');
758: fnd_message.raise_error;
759: end if;
760: */
761: end if;

Line 758: fnd_message.raise_error;

754: -- Delegate is not valid, display error
755: --
756: /*
757: fnd_message.set_name ('OTA','OTA_13505_DELEGATE_VALID');
758: fnd_message.raise_error;
759: end if;
760: */
761: end if;
762: --

Line 778: fnd_message.set_name ('OTA','OTA_13504_SPONSOR_VALID');

774: < p_date_booking_placed) then
775: --
776: -- Sponsor is not valid, display error
777: --
778: fnd_message.set_name ('OTA','OTA_13504_SPONSOR_VALID');
779: fnd_message.raise_error;
780: end if;
781: end if;
782: end if;

Line 779: fnd_message.raise_error;

775: --
776: -- Sponsor is not valid, display error
777: --
778: fnd_message.set_name ('OTA','OTA_13504_SPONSOR_VALID');
779: fnd_message.raise_error;
780: end if;
781: end if;
782: end if;
783: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 864: fnd_message.set_name ('OTA','OTA_13507_DELEGATE_CONTACT_INV');

860: if not c_delegate%found then
861: --
862: -- Delegate contact is not valid, display error
863: --
864: fnd_message.set_name ('OTA','OTA_13507_DELEGATE_CONTACT_INV');
865: fnd_message.raise_error;
866: end if;
867: close c_delegate;
868: end if;

Line 865: fnd_message.raise_error;

861: --
862: -- Delegate contact is not valid, display error
863: --
864: fnd_message.set_name ('OTA','OTA_13507_DELEGATE_CONTACT_INV');
865: fnd_message.raise_error;
866: end if;
867: close c_delegate;
868: end if;
869: --

Line 879: fnd_message.set_name ('OTA','OTA_13508_SPONSOR_CONTACT_INV');

875: if not c_sponsor%found then
876: --
877: -- Sponsor contact is not valid, display error
878: --
879: fnd_message.set_name ('OTA','OTA_13508_SPONSOR_CONTACT_INV');
880: fnd_message.raise_error;
881: end if;
882: close c_sponsor;
883: end if;

Line 880: fnd_message.raise_error;

876: --
877: -- Sponsor contact is not valid, display error
878: --
879: fnd_message.set_name ('OTA','OTA_13508_SPONSOR_CONTACT_INV');
880: fnd_message.raise_error;
881: end if;
882: close c_sponsor;
883: end if;
884: end if;

Line 917: fnd_message.set_name('OTA', 'OTA_13905_UPDATE_EVENT_FAILURE');

913: IF C_EVENT_REC.old_event_id is not null then
914: if p_event_id is not null and
915: p_event_id <> C_EVENT_REC.old_event_id then
916:
917: fnd_message.set_name('OTA', 'OTA_13905_UPDATE_EVENT_FAILURE');
918: fnd_message.raise_error;
919:
920:
921: end if;

Line 918: fnd_message.raise_error;

914: if p_event_id is not null and
915: p_event_id <> C_EVENT_REC.old_event_id then
916:
917: fnd_message.set_name('OTA', 'OTA_13905_UPDATE_EVENT_FAILURE');
918: fnd_message.raise_error;
919:
920:
921: end if;
922: END IF;

Line 962: fnd_message.set_name('OTA','OTA_OM_COMMITMENT');

958: l_commitment_start_date,
959: l_commitment_end_date);
960: IF l_commitment_end_date IS NOT NULL AND
961: l_event_end_date > l_commitment_end_date THEN
962: fnd_message.set_name('OTA','OTA_OM_COMMITMENT');
963: fnd_message.set_token('COMMITMENT_NUMBER',l_commitment_number);
964: fnd_message.set_token('COMMITMENT_END_DATE',fnd_date.date_to_chardate(l_commitment_end_date));
965: END IF;
966: hr_utility.set_location('Leaving:'||l_proc,30);

Line 963: fnd_message.set_token('COMMITMENT_NUMBER',l_commitment_number);

959: l_commitment_end_date);
960: IF l_commitment_end_date IS NOT NULL AND
961: l_event_end_date > l_commitment_end_date THEN
962: fnd_message.set_name('OTA','OTA_OM_COMMITMENT');
963: fnd_message.set_token('COMMITMENT_NUMBER',l_commitment_number);
964: fnd_message.set_token('COMMITMENT_END_DATE',fnd_date.date_to_chardate(l_commitment_end_date));
965: END IF;
966: hr_utility.set_location('Leaving:'||l_proc,30);
967: END check_commitment_date;

Line 964: fnd_message.set_token('COMMITMENT_END_DATE',fnd_date.date_to_chardate(l_commitment_end_date));

960: IF l_commitment_end_date IS NOT NULL AND
961: l_event_end_date > l_commitment_end_date THEN
962: fnd_message.set_name('OTA','OTA_OM_COMMITMENT');
963: fnd_message.set_token('COMMITMENT_NUMBER',l_commitment_number);
964: fnd_message.set_token('COMMITMENT_END_DATE',fnd_date.date_to_chardate(l_commitment_end_date));
965: END IF;
966: hr_utility.set_location('Leaving:'||l_proc,30);
967: END check_commitment_date;
968:

Line 1031: fnd_message.set_name('OTA','OTA_13956_TDB_CHECK_LOCATION');

1027: IF l_evt_country IS NOT NULL AND l_org_country IS NOT NULL THEN
1028: --check if the countries are same
1029: IF l_evt_country <> l_org_country THEN
1030: --
1031: fnd_message.set_name('OTA','OTA_13956_TDB_CHECK_LOCATION');
1032: fnd_message.raise_error;
1033: --
1034: END IF;
1035: END IF;

Line 1032: fnd_message.raise_error;

1028: --check if the countries are same
1029: IF l_evt_country <> l_org_country THEN
1030: --
1031: fnd_message.set_name('OTA','OTA_13956_TDB_CHECK_LOCATION');
1032: fnd_message.raise_error;
1033: --
1034: END IF;
1035: END IF;
1036: --