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

Line 206: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

202: CLOSE csr_sec_grp;
203: --
204: -- The primary key is invalid therefore we must error
205: --
206: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
207: hr_multi_message.add
208: (p_associated_column1 => NVL(p_associated_column1, 'EVENT_ID'));
209: --
210: ELSE

Line 311: FND_MESSAGE.SET_NAME (810, 'OTA_13205_GEN_PARAMETERS');

307: P_OPTIONAL_MESSAGE in varchar2
308: ) is
309: begin
310: --
311: FND_MESSAGE.SET_NAME (810, 'OTA_13205_GEN_PARAMETERS');
312: FND_MESSAGE.SET_TOKEN ('PROCEDURE', P_PROCEDURE_NAME);
313: FND_MESSAGE.SET_TOKEN ('SPECIFIC_MESSAGE', P_OPTIONAL_MESSAGE);
314: FND_MESSAGE.RAISE_ERROR;
315: --

Line 312: FND_MESSAGE.SET_TOKEN ('PROCEDURE', P_PROCEDURE_NAME);

308: ) is
309: begin
310: --
311: FND_MESSAGE.SET_NAME (810, 'OTA_13205_GEN_PARAMETERS');
312: FND_MESSAGE.SET_TOKEN ('PROCEDURE', P_PROCEDURE_NAME);
313: FND_MESSAGE.SET_TOKEN ('SPECIFIC_MESSAGE', P_OPTIONAL_MESSAGE);
314: FND_MESSAGE.RAISE_ERROR;
315: --
316: end INVALID_PARAMETER;

Line 313: FND_MESSAGE.SET_TOKEN ('SPECIFIC_MESSAGE', P_OPTIONAL_MESSAGE);

309: begin
310: --
311: FND_MESSAGE.SET_NAME (810, 'OTA_13205_GEN_PARAMETERS');
312: FND_MESSAGE.SET_TOKEN ('PROCEDURE', P_PROCEDURE_NAME);
313: FND_MESSAGE.SET_TOKEN ('SPECIFIC_MESSAGE', P_OPTIONAL_MESSAGE);
314: FND_MESSAGE.RAISE_ERROR;
315: --
316: end INVALID_PARAMETER;
317: --

Line 314: FND_MESSAGE.RAISE_ERROR;

310: --
311: FND_MESSAGE.SET_NAME (810, 'OTA_13205_GEN_PARAMETERS');
312: FND_MESSAGE.SET_TOKEN ('PROCEDURE', P_PROCEDURE_NAME);
313: FND_MESSAGE.SET_TOKEN ('SPECIFIC_MESSAGE', P_OPTIONAL_MESSAGE);
314: FND_MESSAGE.RAISE_ERROR;
315: --
316: end INVALID_PARAMETER;
317: --
318: -- ----------------------------------------------------------------------------

Line 433: fnd_message.set_name('OTA','OTA_443486_NO_CHARGE_CUST_EVT');

429: OPEN evt_associations_cr('Y','N');
430: FETCH evt_associations_cr INTO l_dummy;
431: IF evt_associations_cr%found then
432: CLOSE evt_associations_cr;
433: fnd_message.set_name('OTA','OTA_443486_NO_CHARGE_CUST_EVT');
434: fnd_message.raise_error;
435: END IF;
436: CLOSE evt_associations_cr;
437:

Line 434: fnd_message.raise_error;

430: FETCH evt_associations_cr INTO l_dummy;
431: IF evt_associations_cr%found then
432: CLOSE evt_associations_cr;
433: fnd_message.set_name('OTA','OTA_443486_NO_CHARGE_CUST_EVT');
434: fnd_message.raise_error;
435: END IF;
436: CLOSE evt_associations_cr;
437:
438: end if;

Line 449: fnd_message.set_name('OTA','OTA_443489_PRICE_BASIS_DM');

445: OPEN dm_cr;
446: FETCH dm_cr INTO l_dummy;
447: IF dm_cr%notfound then
448: CLOSE dm_cr;
449: fnd_message.set_name('OTA','OTA_443489_PRICE_BASIS_DM');
450: fnd_message.raise_error;
451: END IF;
452: CLOSE dm_cr;
453:

Line 450: fnd_message.raise_error;

446: FETCH dm_cr INTO l_dummy;
447: IF dm_cr%notfound then
448: CLOSE dm_cr;
449: fnd_message.set_name('OTA','OTA_443489_PRICE_BASIS_DM');
450: fnd_message.raise_error;
451: END IF;
452: CLOSE dm_cr;
453:
454: IF (p_max_internal_attendees IS NULL OR

Line 457: fnd_message.set_name('OTA','OTA_443487_PRICE_BASIS_C_O');

453:
454: IF (p_max_internal_attendees IS NULL OR
455: p_max_internal_attendees > 0 )
456: THEN
457: fnd_message.set_name('OTA','OTA_443487_PRICE_BASIS_C_O');
458: fnd_message.raise_error;
459: END IF;
460:
461: OPEN evt_associations_cr('N','Y');

Line 458: fnd_message.raise_error;

454: IF (p_max_internal_attendees IS NULL OR
455: p_max_internal_attendees > 0 )
456: THEN
457: fnd_message.set_name('OTA','OTA_443487_PRICE_BASIS_C_O');
458: fnd_message.raise_error;
459: END IF;
460:
461: OPEN evt_associations_cr('N','Y');
462: FETCH evt_associations_cr INTO l_dummy;

Line 465: fnd_message.set_name('OTA','OTA_443488_PRICE_BASIS_INT');

461: OPEN evt_associations_cr('N','Y');
462: FETCH evt_associations_cr INTO l_dummy;
463: IF evt_associations_cr%found then
464: CLOSE evt_associations_cr;
465: fnd_message.set_name('OTA','OTA_443488_PRICE_BASIS_INT');
466: fnd_message.raise_error;
467: END IF;
468: CLOSE evt_associations_cr;
469:

Line 466: fnd_message.raise_error;

462: FETCH evt_associations_cr INTO l_dummy;
463: IF evt_associations_cr%found then
464: CLOSE evt_associations_cr;
465: fnd_message.set_name('OTA','OTA_443488_PRICE_BASIS_INT');
466: fnd_message.raise_error;
467: END IF;
468: CLOSE evt_associations_cr;
469:
470: END IF;

Line 505: fnd_message.set_name('OTA','OTA_13440_EVT_CURR_PB');

501: --
502: hr_utility.set_location('Entering '||l_proc,10);
503: --
504: if ( p_pricing_type is not null and p_pricing_type ='S' and (p_amount is null or p_currency_code is null)) then
505: fnd_message.set_name('OTA','OTA_13440_EVT_CURR_PB');
506: fnd_message.raise_error;
507: end if;
508:
509: if ( p_pricing_type is not null and p_pricing_type ='C' and (p_amount is not null or p_currency_code is null)) then

Line 506: fnd_message.raise_error;

502: hr_utility.set_location('Entering '||l_proc,10);
503: --
504: if ( p_pricing_type is not null and p_pricing_type ='S' and (p_amount is null or p_currency_code is null)) then
505: fnd_message.set_name('OTA','OTA_13440_EVT_CURR_PB');
506: fnd_message.raise_error;
507: end if;
508:
509: if ( p_pricing_type is not null and p_pricing_type ='C' and (p_amount is not null or p_currency_code is null)) then
510: fnd_message.set_name('OTA','OTA_13440_EVT_CURR_PB');

Line 510: fnd_message.set_name('OTA','OTA_13440_EVT_CURR_PB');

506: fnd_message.raise_error;
507: end if;
508:
509: if ( p_pricing_type is not null and p_pricing_type ='C' and (p_amount is not null or p_currency_code is null)) then
510: fnd_message.set_name('OTA','OTA_13440_EVT_CURR_PB');
511: fnd_message.raise_error;
512: end if;
513:
514: --

Line 511: fnd_message.raise_error;

507: end if;
508:
509: if ( p_pricing_type is not null and p_pricing_type ='C' and (p_amount is not null or p_currency_code is null)) then
510: fnd_message.set_name('OTA','OTA_13440_EVT_CURR_PB');
511: fnd_message.raise_error;
512: end if;
513:
514: --
515: hr_utility.set_location('Leaving '||l_proc,10);

Line 613: fnd_message.set_name('OTA', 'OTA_13481_ENROL_START_AFTER');

609: If nvl(l_course_start_date, hr_api.g_sot) < p_enrollment_start_date Then
610: --
611: --
612: -- ** TEMP ** Add error message with the following text.
613: fnd_message.set_name('OTA', 'OTA_13481_ENROL_START_AFTER');
614: fnd_message.raise_error;
615: --
616: End if;
617: End if;

Line 614: fnd_message.raise_error;

610: --
611: --
612: -- ** TEMP ** Add error message with the following text.
613: fnd_message.set_name('OTA', 'OTA_13481_ENROL_START_AFTER');
614: fnd_message.raise_error;
615: --
616: End if;
617: End if;
618: --

Line 628: fnd_message.set_name('OTA','OTA_13474_ENROLL_START_AFTER');

624: --
625: If nvl(p_enrollment_start_date, hr_api.g_sot) > l_course_end_date Then
626: --
627: -- ** TEMP ** Add error message with the following text.
628: fnd_message.set_name('OTA','OTA_13474_ENROLL_START_AFTER');
629: fnd_message.raise_error;
630: --
631: End if;
632: --

Line 629: fnd_message.raise_error;

625: If nvl(p_enrollment_start_date, hr_api.g_sot) > l_course_end_date Then
626: --
627: -- ** TEMP ** Add error message with the following text.
628: fnd_message.set_name('OTA','OTA_13474_ENROLL_START_AFTER');
629: fnd_message.raise_error;
630: --
631: End if;
632: --
633: -- Enrollment enddate is later than course enddate

Line 638: fnd_message.set_name('OTA','OTA_13475_ENROLL_END_AFTER');

634: --
635: /*If nvl(p_enrollment_end_date, l_course_end_date) > l_course_end_date Then
636: --
637: -- ** TEMP ** Add error message with the following text.
638: fnd_message.set_name('OTA','OTA_13475_ENROLL_END_AFTER');
639: fnd_message.raise_error;
640: --
641: End if;*/
642: --

Line 639: fnd_message.raise_error;

635: /*If nvl(p_enrollment_end_date, l_course_end_date) > l_course_end_date Then
636: --
637: -- ** TEMP ** Add error message with the following text.
638: fnd_message.set_name('OTA','OTA_13475_ENROLL_END_AFTER');
639: fnd_message.raise_error;
640: --
641: End if;*/
642: --
643: End if;

Line 709: fnd_message.set_name('OTA','OTA_13480_END_DATE_NULL');

705: --
706: hr_utility.set_location(' Entering:'||l_proc,10);
707: if (p_event_status <> 'P' AND p_event_status <> 'A') OR p_event_type <> 'SELFPACED' then
708: if p_course_end_date is null then
709: fnd_message.set_name('OTA','OTA_13480_END_DATE_NULL');
710: fnd_message.raise_error;
711: end if;
712: end if;
713: hr_utility.set_location(' Leaving:'||l_proc,10);

Line 710: fnd_message.raise_error;

706: hr_utility.set_location(' Entering:'||l_proc,10);
707: if (p_event_status <> 'P' AND p_event_status <> 'A') OR p_event_type <> 'SELFPACED' then
708: if p_course_end_date is null then
709: fnd_message.set_name('OTA','OTA_13480_END_DATE_NULL');
710: fnd_message.raise_error;
711: end if;
712: end if;
713: hr_utility.set_location(' Leaving:'||l_proc,10);
714: EXCEPTION

Line 812: fnd_message.set_name('OTA','OTA_13526_RESTRICTED_FLAG');

808: open get_enrollments;
809: fetch get_enrollments into l_exists;
810: if get_enrollments%found then
811: close get_enrollments;
812: fnd_message.set_name('OTA','OTA_13526_RESTRICTED_FLAG');
813: fnd_message.set_token('STEP','1');
814: fnd_message.raise_error;
815: end if;
816: close get_enrollments;

Line 813: fnd_message.set_token('STEP','1');

809: fetch get_enrollments into l_exists;
810: if get_enrollments%found then
811: close get_enrollments;
812: fnd_message.set_name('OTA','OTA_13526_RESTRICTED_FLAG');
813: fnd_message.set_token('STEP','1');
814: fnd_message.raise_error;
815: end if;
816: close get_enrollments;
817: --

Line 814: fnd_message.raise_error;

810: if get_enrollments%found then
811: close get_enrollments;
812: fnd_message.set_name('OTA','OTA_13526_RESTRICTED_FLAG');
813: fnd_message.set_token('STEP','1');
814: fnd_message.raise_error;
815: end if;
816: close get_enrollments;
817: --
818: elsif p_public_event_flag = 'Y' then

Line 823: fnd_message.set_name('OTA','OTA_13526_RESTRICTED_FLAG');

819: open get_tea;
820: fetch get_tea into l_exists;
821: if get_tea%found then
822: close get_tea;
823: fnd_message.set_name('OTA','OTA_13526_RESTRICTED_FLAG');
824: fnd_message.set_token('STEP','2');
825: fnd_message.raise_error;
826: end if;
827: close get_tea;

Line 824: fnd_message.set_token('STEP','2');

820: fetch get_tea into l_exists;
821: if get_tea%found then
822: close get_tea;
823: fnd_message.set_name('OTA','OTA_13526_RESTRICTED_FLAG');
824: fnd_message.set_token('STEP','2');
825: fnd_message.raise_error;
826: end if;
827: close get_tea;
828: end if;

Line 825: fnd_message.raise_error;

821: if get_tea%found then
822: close get_tea;
823: fnd_message.set_name('OTA','OTA_13526_RESTRICTED_FLAG');
824: fnd_message.set_token('STEP','2');
825: fnd_message.raise_error;
826: end if;
827: close get_tea;
828: end if;
829: --

Line 974: fnd_message.set_name('OTA','OTA_13474_ENROLL_START_AFTER');

970: --
971: If nvl( p_child_start, hr_api.g_sot) > p_par_end Then
972: --
973: -- ** TEMP ** Add error message with the following text.
974: fnd_message.set_name('OTA','OTA_13474_ENROLL_START_AFTER');
975: fnd_message.raise_error;
976: --
977: End if;
978: --

Line 975: fnd_message.raise_error;

971: If nvl( p_child_start, hr_api.g_sot) > p_par_end Then
972: --
973: -- ** TEMP ** Add error message with the following text.
974: fnd_message.set_name('OTA','OTA_13474_ENROLL_START_AFTER');
975: fnd_message.raise_error;
976: --
977: End if;
978: --
979: -- Child enddate is later than parent enddate

Line 1008: fnd_message.set_name('OTA','OTA_13065_CLASS_START_DATE');

1004: hr_utility.set_location('Entering:'||l_proc,10);
1005:
1006: if p_course_start_time is not null and p_course_start_date is null
1007: then
1008: fnd_message.set_name('OTA','OTA_13065_CLASS_START_DATE');
1009: fnd_message.raise_error;
1010: end if;
1011: hr_utility.set_location('Leaving:'||l_proc,20);
1012:

Line 1009: fnd_message.raise_error;

1005:
1006: if p_course_start_time is not null and p_course_start_date is null
1007: then
1008: fnd_message.set_name('OTA','OTA_13065_CLASS_START_DATE');
1009: fnd_message.raise_error;
1010: end if;
1011: hr_utility.set_location('Leaving:'||l_proc,20);
1012:
1013: EXCEPTION

Line 1040: fnd_message.set_name('OTA','OTA_443613_CLASS_END_DATE');

1036: begin
1037: hr_utility.set_location('Entering:'||l_proc,10);
1038: if p_course_end_time is not null and p_course_end_date is null
1039: then
1040: fnd_message.set_name('OTA','OTA_443613_CLASS_END_DATE');
1041: fnd_message.raise_error;
1042: end if;
1043: hr_utility.set_location('Leaving:'||l_proc,20);
1044:

Line 1041: fnd_message.raise_error;

1037: hr_utility.set_location('Entering:'||l_proc,10);
1038: if p_course_end_time is not null and p_course_end_date is null
1039: then
1040: fnd_message.set_name('OTA','OTA_443613_CLASS_END_DATE');
1041: fnd_message.raise_error;
1042: end if;
1043: hr_utility.set_location('Leaving:'||l_proc,20);
1044:
1045: EXCEPTION

Line 1103: fnd_message.set_name('OTA','OTA_13533_EVT_DATES_NULL');

1099: /*
1100: if p_event_status <> 'P' then
1101: if p_course_start_date is null or
1102: p_course_end_date is null then
1103: fnd_message.set_name('OTA','OTA_13533_EVT_DATES_NULL');
1104: fnd_message.raise_error;
1105: end if;
1106: end if;
1107: */

Line 1104: fnd_message.raise_error;

1100: if p_event_status <> 'P' then
1101: if p_course_start_date is null or
1102: p_course_end_date is null then
1103: fnd_message.set_name('OTA','OTA_13533_EVT_DATES_NULL');
1104: fnd_message.raise_error;
1105: end if;
1106: end if;
1107: */
1108: --

Line 1112: fnd_message.set_name('OTA','OTA_13480_END_DATE_NULL');

1108: --
1109: if (p_event_status <> 'P' AND p_event_status <> 'A') then
1110: if p_event_type <> 'SELFPACED' then
1111: if p_course_end_date is null then
1112: fnd_message.set_name('OTA','OTA_13480_END_DATE_NULL');
1113: fnd_message.raise_error;
1114: end if;
1115: end if;
1116: if p_course_start_date is null then

Line 1113: fnd_message.raise_error;

1109: if (p_event_status <> 'P' AND p_event_status <> 'A') then
1110: if p_event_type <> 'SELFPACED' then
1111: if p_course_end_date is null then
1112: fnd_message.set_name('OTA','OTA_13480_END_DATE_NULL');
1113: fnd_message.raise_error;
1114: end if;
1115: end if;
1116: if p_course_start_date is null then
1117: fnd_message.set_name('OTA','OTA_13533_EVT_DATES_NULL');

Line 1117: fnd_message.set_name('OTA','OTA_13533_EVT_DATES_NULL');

1113: fnd_message.raise_error;
1114: end if;
1115: end if;
1116: if p_course_start_date is null then
1117: fnd_message.set_name('OTA','OTA_13533_EVT_DATES_NULL');
1118: fnd_message.raise_error;
1119: end if;
1120:
1121: end if;

Line 1118: fnd_message.raise_error;

1114: end if;
1115: end if;
1116: if p_course_start_date is null then
1117: fnd_message.set_name('OTA','OTA_13533_EVT_DATES_NULL');
1118: fnd_message.raise_error;
1119: end if;
1120:
1121: end if;
1122:

Line 1164: fnd_message.set_name('OTA','OTA_13534_EVT_INVALID_DATES');

1160: if l_evt_start_date < l_start_date or
1161: l_evt_start_date > l_end_date or
1162: l_evt_end_date > l_end_date or
1163: l_evt_end_date < l_start_date then
1164: fnd_message.set_name('OTA','OTA_13534_EVT_INVALID_DATES');
1165: fnd_message.raise_error;
1166: end if;
1167:
1168: -- added for bug 3619563

Line 1165: fnd_message.raise_error;

1161: l_evt_start_date > l_end_date or
1162: l_evt_end_date > l_end_date or
1163: l_evt_end_date < l_start_date then
1164: fnd_message.set_name('OTA','OTA_13534_EVT_INVALID_DATES');
1165: fnd_message.raise_error;
1166: end if;
1167:
1168: -- added for bug 3619563
1169: open check_act_dates;

Line 1211: fnd_message.set_name('OTA','OTA_13168_EVT_ACT_DATE_OVERLAP');

1207: if l_evt_start_date < l_act_start_date or
1208: l_evt_start_date > l_act_end_date or
1209: l_evt_end_date > l_act_end_date or
1210: l_evt_end_date < l_act_start_date then
1211: fnd_message.set_name('OTA','OTA_13168_EVT_ACT_DATE_OVERLAP');
1212: fnd_message.raise_error;
1213: end if;
1214: --
1215: -- added for bug 3619563

Line 1212: fnd_message.raise_error;

1208: l_evt_start_date > l_act_end_date or
1209: l_evt_end_date > l_act_end_date or
1210: l_evt_end_date < l_act_start_date then
1211: fnd_message.set_name('OTA','OTA_13168_EVT_ACT_DATE_OVERLAP');
1212: fnd_message.raise_error;
1213: end if;
1214: --
1215: -- added for bug 3619563
1216: --

Line 1245: fnd_message.set_name('OTA','OTA_13533_EVT_DATES_NULL');

1241: hr_utility.trace('p_event_status'||p_event_status);
1242: if p_event_status <> 'P' then
1243: if p_course_start_date is null or
1244: p_course_end_date is null then
1245: fnd_message.set_name('OTA','OTA_13533_EVT_DATES_NULL');
1246: fnd_message.raise_error;
1247: end if;
1248: end if;
1249: --

Line 1246: fnd_message.raise_error;

1242: if p_event_status <> 'P' then
1243: if p_course_start_date is null or
1244: p_course_end_date is null then
1245: fnd_message.set_name('OTA','OTA_13533_EVT_DATES_NULL');
1246: fnd_message.raise_error;
1247: end if;
1248: end if;
1249: --
1250: open check_dates;

Line 1279: fnd_message.set_name('OTA','OTA_13534_EVT_INVALID_DATES');

1275: if l_evt_start_date < l_start_date or
1276: l_evt_start_date > l_end_date or
1277: l_evt_end_date > l_end_date or
1278: l_evt_end_date < l_start_date then
1279: fnd_message.set_name('OTA','OTA_13534_EVT_INVALID_DATES');
1280: fnd_message.raise_error;
1281: end if;
1282: --
1283: hr_utility.set_location(' Exiting:'||l_proc,10);

Line 1280: fnd_message.raise_error;

1276: l_evt_start_date > l_end_date or
1277: l_evt_end_date > l_end_date or
1278: l_evt_end_date < l_start_date then
1279: fnd_message.set_name('OTA','OTA_13534_EVT_INVALID_DATES');
1280: fnd_message.raise_error;
1281: end if;
1282: --
1283: hr_utility.set_location(' Exiting:'||l_proc,10);
1284: end COURSE_DATES_ARE_VALID;

Line 1327: fnd_message.set_name('OTA','OTA_13599_EVT_VALID_BOOKINGS');

1323: open check_dates;
1324: fetch check_dates into l_dummy;
1325: if check_dates%found then
1326: close check_dates;
1327: fnd_message.set_name('OTA','OTA_13599_EVT_VALID_BOOKINGS');
1328: fnd_message.raise_error;
1329: end if;
1330: close check_dates;
1331: --

Line 1328: fnd_message.raise_error;

1324: fetch check_dates into l_dummy;
1325: if check_dates%found then
1326: close check_dates;
1327: fnd_message.set_name('OTA','OTA_13599_EVT_VALID_BOOKINGS');
1328: fnd_message.raise_error;
1329: end if;
1330: close check_dates;
1331: --
1332: end if;

Line 1393: fnd_message.set_name('OTA','OTA_13600_EVT_VALID_BD');

1389: end if;
1390: --
1391: if l_start_date < l_evt_start_date or
1392: l_end_date > l_evt_end_date then
1393: fnd_message.set_name('OTA','OTA_13600_EVT_VALID_BD');
1394: fnd_message.raise_error;
1395: end if;
1396: --
1397: end loop;

Line 1394: fnd_message.raise_error;

1390: --
1391: if l_start_date < l_evt_start_date or
1392: l_end_date > l_evt_end_date then
1393: fnd_message.set_name('OTA','OTA_13600_EVT_VALID_BD');
1394: fnd_message.raise_error;
1395: end if;
1396: --
1397: end loop;
1398: --

Line 1446: fnd_message.set_name('OTA', 'OTA_13579_EVT_SESSION_DATES');

1442: if check_course_null_dates%found and
1443: (p_course_start_date is null or p_course_end_date is null) then
1444: --
1445: --
1446: fnd_message.set_name('OTA', 'OTA_13579_EVT_SESSION_DATES');
1447: fnd_message.raise_error;
1448: end if;
1449: close check_course_null_dates;
1450: --

Line 1447: fnd_message.raise_error;

1443: (p_course_start_date is null or p_course_end_date is null) then
1444: --
1445: --
1446: fnd_message.set_name('OTA', 'OTA_13579_EVT_SESSION_DATES');
1447: fnd_message.raise_error;
1448: end if;
1449: close check_course_null_dates;
1450: --
1451: */

Line 1458: fnd_message.set_name('OTA', 'OTA_13482_SESSION_CONFLICT');

1454: if check_dates%found then
1455: --
1456: -- Warn of session date
1457: --
1458: fnd_message.set_name('OTA', 'OTA_13482_SESSION_CONFLICT');
1459: fnd_message.raise_error;
1460: end if;
1461: close check_dates;
1462: hr_utility.set_location(' Leaving:'||l_proc,10);

Line 1459: fnd_message.raise_error;

1455: --
1456: -- Warn of session date
1457: --
1458: fnd_message.set_name('OTA', 'OTA_13482_SESSION_CONFLICT');
1459: fnd_message.raise_error;
1460: end if;
1461: close check_dates;
1462: hr_utility.set_location(' Leaving:'||l_proc,10);
1463: end session_valid;

Line 1627: fnd_message.set_name('OTA', 'OTA_13064_EVT_SSN_TIME');

1623: p_session_start_time IS NOT NULL AND
1624: p_session_end_time IS NOT NULL) THEN
1625:
1626: IF ( substr(p_session_start_time,1,2) > substr(p_session_end_time,1,2) ) then
1627: fnd_message.set_name('OTA', 'OTA_13064_EVT_SSN_TIME');
1628: fnd_message.raise_error;
1629: ELSIF (( substr(p_session_start_time,1,2) = substr(p_session_end_time,1,2) ) AND
1630: ( substr(p_session_start_time,4,2) > substr(p_session_end_time,4,2) )) then
1631: fnd_message.set_name('OTA', 'OTA_13064_EVT_SSN_TIME');

Line 1628: fnd_message.raise_error;

1624: p_session_end_time IS NOT NULL) THEN
1625:
1626: IF ( substr(p_session_start_time,1,2) > substr(p_session_end_time,1,2) ) then
1627: fnd_message.set_name('OTA', 'OTA_13064_EVT_SSN_TIME');
1628: fnd_message.raise_error;
1629: ELSIF (( substr(p_session_start_time,1,2) = substr(p_session_end_time,1,2) ) AND
1630: ( substr(p_session_start_time,4,2) > substr(p_session_end_time,4,2) )) then
1631: fnd_message.set_name('OTA', 'OTA_13064_EVT_SSN_TIME');
1632: fnd_message.raise_error;

Line 1631: fnd_message.set_name('OTA', 'OTA_13064_EVT_SSN_TIME');

1627: fnd_message.set_name('OTA', 'OTA_13064_EVT_SSN_TIME');
1628: fnd_message.raise_error;
1629: ELSIF (( substr(p_session_start_time,1,2) = substr(p_session_end_time,1,2) ) AND
1630: ( substr(p_session_start_time,4,2) > substr(p_session_end_time,4,2) )) then
1631: fnd_message.set_name('OTA', 'OTA_13064_EVT_SSN_TIME');
1632: fnd_message.raise_error;
1633: END IF;
1634:
1635: END IF;

Line 1632: fnd_message.raise_error;

1628: fnd_message.raise_error;
1629: ELSIF (( substr(p_session_start_time,1,2) = substr(p_session_end_time,1,2) ) AND
1630: ( substr(p_session_start_time,4,2) > substr(p_session_end_time,4,2) )) then
1631: fnd_message.set_name('OTA', 'OTA_13064_EVT_SSN_TIME');
1632: fnd_message.raise_error;
1633: END IF;
1634:
1635: END IF;
1636: --Bug 3451221

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

1653: IF substr(l_course_start_time ,1,2) =
1654: substr(p_session_start_time ,1,2) THEN
1655: IF substr(l_course_start_time ,4,2) >
1656: substr(p_session_start_time ,4,2) THEN
1657: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');
1658: fnd_message.raise_error;
1659: END IF;
1660: ELSIF substr(l_course_start_time ,1,2) >
1661: substr(p_session_start_time ,1,2) THEN

Line 1658: fnd_message.raise_error;

1654: substr(p_session_start_time ,1,2) THEN
1655: IF substr(l_course_start_time ,4,2) >
1656: substr(p_session_start_time ,4,2) THEN
1657: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');
1658: fnd_message.raise_error;
1659: END IF;
1660: ELSIF substr(l_course_start_time ,1,2) >
1661: substr(p_session_start_time ,1,2) THEN
1662: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');

Line 1662: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');

1658: fnd_message.raise_error;
1659: END IF;
1660: ELSIF substr(l_course_start_time ,1,2) >
1661: substr(p_session_start_time ,1,2) THEN
1662: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');
1663: fnd_message.raise_error;
1664: END IF;
1665: END IF;
1666: END IF;

Line 1663: fnd_message.raise_error;

1659: END IF;
1660: ELSIF substr(l_course_start_time ,1,2) >
1661: substr(p_session_start_time ,1,2) THEN
1662: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');
1663: fnd_message.raise_error;
1664: END IF;
1665: END IF;
1666: END IF;
1667:

Line 1675: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');

1671: IF substr(l_course_end_time ,1,2) =
1672: substr(p_session_end_time ,1,2) THEN
1673: IF substr(l_course_end_time ,4,2) <
1674: substr(p_session_end_time ,4,2) THEN
1675: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');
1676: fnd_message.raise_error;
1677: END IF;
1678: ELSIF substr(l_course_end_time ,1,2) <
1679: substr(p_session_end_time ,1,2) THEN

Line 1676: fnd_message.raise_error;

1672: substr(p_session_end_time ,1,2) THEN
1673: IF substr(l_course_end_time ,4,2) <
1674: substr(p_session_end_time ,4,2) THEN
1675: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');
1676: fnd_message.raise_error;
1677: END IF;
1678: ELSIF substr(l_course_end_time ,1,2) <
1679: substr(p_session_end_time ,1,2) THEN
1680: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');

Line 1680: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');

1676: fnd_message.raise_error;
1677: END IF;
1678: ELSIF substr(l_course_end_time ,1,2) <
1679: substr(p_session_end_time ,1,2) THEN
1680: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');
1681: fnd_message.raise_error;
1682: END IF;
1683: END IF;
1684: END IF;

Line 1681: fnd_message.raise_error;

1677: END IF;
1678: ELSIF substr(l_course_end_time ,1,2) <
1679: substr(p_session_end_time ,1,2) THEN
1680: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');
1681: fnd_message.raise_error;
1682: END IF;
1683: END IF;
1684: END IF;
1685: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);

Line 1745: fnd_message.set_name('OTA','OTA_13579_EVT_SESSION_DATES');

1741: -- check if course start and end date are null
1742: -- if null then set them to start and end of time
1743: --
1744: if l_course_start_date is null or l_course_end_date is null then
1745: fnd_message.set_name('OTA','OTA_13579_EVT_SESSION_DATES');
1746: fnd_message.raise_error;
1747: end if;
1748: /* if l_course_start_date is null then
1749: l_course_start_date := hr_api.g_sot;

Line 1746: fnd_message.raise_error;

1742: -- if null then set them to start and end of time
1743: --
1744: if l_course_start_date is null or l_course_end_date is null then
1745: fnd_message.set_name('OTA','OTA_13579_EVT_SESSION_DATES');
1746: fnd_message.raise_error;
1747: end if;
1748: /* if l_course_start_date is null then
1749: l_course_start_date := hr_api.g_sot;
1750: end if;

Line 1870: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');

1866: IF substr(p_course_start_time ,1,2) =
1867: substr(l_ssn_start_time ,1,2) THEN
1868: IF substr(p_course_start_time ,4,2) >
1869: substr(l_ssn_start_time ,4,2) THEN
1870: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');
1871: fnd_message.raise_error;
1872: END IF;
1873: ELSIF substr(p_course_start_time ,1,2) >
1874: substr(l_ssn_start_time ,1,2) THEN

Line 1871: fnd_message.raise_error;

1867: substr(l_ssn_start_time ,1,2) THEN
1868: IF substr(p_course_start_time ,4,2) >
1869: substr(l_ssn_start_time ,4,2) THEN
1870: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');
1871: fnd_message.raise_error;
1872: END IF;
1873: ELSIF substr(p_course_start_time ,1,2) >
1874: substr(l_ssn_start_time ,1,2) THEN
1875: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');

Line 1875: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');

1871: fnd_message.raise_error;
1872: END IF;
1873: ELSIF substr(p_course_start_time ,1,2) >
1874: substr(l_ssn_start_time ,1,2) THEN
1875: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');
1876: fnd_message.raise_error;
1877: END IF;
1878: END IF;
1879: END IF;

Line 1876: fnd_message.raise_error;

1872: END IF;
1873: ELSIF substr(p_course_start_time ,1,2) >
1874: substr(l_ssn_start_time ,1,2) THEN
1875: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');
1876: fnd_message.raise_error;
1877: END IF;
1878: END IF;
1879: END IF;
1880:

Line 1888: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');

1884: IF substr(p_course_end_time ,1,2) =
1885: substr(l_ssn_end_time ,1,2) THEN
1886: IF substr(p_course_end_time ,4,2) <
1887: substr(l_ssn_end_time ,4,2) THEN
1888: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');
1889: fnd_message.raise_error;
1890: END IF;
1891: ELSIF substr(p_course_end_time ,1,2) <
1892: substr(l_ssn_end_time ,1,2) THEN

Line 1889: fnd_message.raise_error;

1885: substr(l_ssn_end_time ,1,2) THEN
1886: IF substr(p_course_end_time ,4,2) <
1887: substr(l_ssn_end_time ,4,2) THEN
1888: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');
1889: fnd_message.raise_error;
1890: END IF;
1891: ELSIF substr(p_course_end_time ,1,2) <
1892: substr(l_ssn_end_time ,1,2) THEN
1893: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');

Line 1893: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');

1889: fnd_message.raise_error;
1890: END IF;
1891: ELSIF substr(p_course_end_time ,1,2) <
1892: substr(l_ssn_end_time ,1,2) THEN
1893: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');
1894: fnd_message.raise_error;
1895: END IF;
1896: END IF;
1897: END IF;

Line 1894: fnd_message.raise_error;

1890: END IF;
1891: ELSIF substr(p_course_end_time ,1,2) <
1892: substr(l_ssn_end_time ,1,2) THEN
1893: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');
1894: fnd_message.raise_error;
1895: END IF;
1896: END IF;
1897: END IF;
1898:

Line 2008: fnd_message.set_name('OTA','OTA_13394_TAV_COST_ATTR');

2004: --
2005: if (p_budget_cost is not null or p_actual_cost is not null) and
2006: p_budget_currency_code is null then
2007: --
2008: fnd_message.set_name('OTA','OTA_13394_TAV_COST_ATTR');
2009: fnd_message.raise_error;
2010: --
2011: end if;
2012: --

Line 2009: fnd_message.raise_error;

2005: if (p_budget_cost is not null or p_actual_cost is not null) and
2006: p_budget_currency_code is null then
2007: --
2008: fnd_message.set_name('OTA','OTA_13394_TAV_COST_ATTR');
2009: fnd_message.raise_error;
2010: --
2011: end if;
2012: --
2013: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 2350: fnd_message.set_name('OTA','OTA_13527_PRICE_BASIS_CHANGE');

2346: open get_enrollments;
2347: fetch get_enrollments into l_exists;
2348: if get_enrollments%found then
2349: close get_enrollments;
2350: fnd_message.set_name('OTA','OTA_13527_PRICE_BASIS_CHANGE');
2351: fnd_message.raise_error;
2352: end if;
2353: close get_enrollments;
2354: --

Line 2351: fnd_message.raise_error;

2347: fetch get_enrollments into l_exists;
2348: if get_enrollments%found then
2349: close get_enrollments;
2350: fnd_message.set_name('OTA','OTA_13527_PRICE_BASIS_CHANGE');
2351: fnd_message.raise_error;
2352: end if;
2353: close get_enrollments;
2354: --
2355: open get_event_associations;

Line 2359: fnd_message.set_name('OTA','OTA_13527_PRICE_BASIS_CHANGE');

2355: open get_event_associations;
2356: fetch get_event_associations into l_exists;
2357: if get_event_associations%found then
2358: close get_event_associations;
2359: fnd_message.set_name('OTA','OTA_13527_PRICE_BASIS_CHANGE');
2360: fnd_message.raise_error;
2361: end if;
2362: close get_event_associations;
2363: --

Line 2360: fnd_message.raise_error;

2356: fetch get_event_associations into l_exists;
2357: if get_event_associations%found then
2358: close get_event_associations;
2359: fnd_message.set_name('OTA','OTA_13527_PRICE_BASIS_CHANGE');
2360: fnd_message.raise_error;
2361: end if;
2362: close get_event_associations;
2363: --
2364: end if;

Line 2388: fnd_message.set_name('OTA','OTA_443982_TIMEZONE_ERROR');

2384: IS
2385: l_timezone_id NUMBER := ota_timezone_util.get_timezone_id(p_timezone);
2386: BEGIN
2387: IF l_timezone_id IS NULL THEN
2388: fnd_message.set_name('OTA','OTA_443982_TIMEZONE_ERROR');
2389: fnd_message.set_token('OBJECT_TYPE',ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','CL',810));
2390: fnd_message.raise_error;
2391: END IF;
2392: END check_timezone;

Line 2389: fnd_message.set_token('OBJECT_TYPE',ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','CL',810));

2385: l_timezone_id NUMBER := ota_timezone_util.get_timezone_id(p_timezone);
2386: BEGIN
2387: IF l_timezone_id IS NULL THEN
2388: fnd_message.set_name('OTA','OTA_443982_TIMEZONE_ERROR');
2389: fnd_message.set_token('OBJECT_TYPE',ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','CL',810));
2390: fnd_message.raise_error;
2391: END IF;
2392: END check_timezone;
2393: --

Line 2390: fnd_message.raise_error;

2386: BEGIN
2387: IF l_timezone_id IS NULL THEN
2388: fnd_message.set_name('OTA','OTA_443982_TIMEZONE_ERROR');
2389: fnd_message.set_token('OBJECT_TYPE',ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','CL',810));
2390: fnd_message.raise_error;
2391: END IF;
2392: END check_timezone;
2393: --
2394: -- ----------------------------------------------------------------------------

Line 2413: fnd_message.set_name('OTA','OTA_13444_EVT_TIME_FORMAT');

2409: and (substr(p_time,4,1) >= '0' and substr(p_time,4,1)<= '5')
2410: and (substr(p_time,5,1) >= '0' and substr(p_time,5,1)<= '9')
2411: and (to_number (substr (p_time, 1,2)) between 0 and 23
2412: and to_number (substr (p_time,4)) between 0 and 59))) then
2413: fnd_message.set_name('OTA','OTA_13444_EVT_TIME_FORMAT');
2414: fnd_message.raise_error;
2415: END IF;
2416: END IF;
2417: END;

Line 2414: fnd_message.raise_error;

2410: and (substr(p_time,5,1) >= '0' and substr(p_time,5,1)<= '9')
2411: and (to_number (substr (p_time, 1,2)) between 0 and 23
2412: and to_number (substr (p_time,4)) between 0 and 59))) then
2413: fnd_message.set_name('OTA','OTA_13444_EVT_TIME_FORMAT');
2414: fnd_message.raise_error;
2415: END IF;
2416: END IF;
2417: END;
2418:

Line 2744: FND_MESSAGE.SET_NAME ('OTA', 'OTA_OM_COMMITMENT');

2740: l_commitment_start_date,
2741: l_commitment_end_date);
2742: IF l_commitment_end_date IS NOT NULL
2743: AND p_rec.course_end_date > l_commitment_end_date THEN
2744: FND_MESSAGE.SET_NAME ('OTA', 'OTA_OM_COMMITMENT');
2745: FND_MESSAGE.SET_TOKEN ('COMMITMENT_NUMBER', l_commitment_number);
2746: FND_MESSAGE.SET_TOKEN ('COMMITMENT_END_DATE', fnd_date.date_to_chardate(l_commitment_end_date));
2747: FND_MESSAGE.RAISE_ERROR;
2748: END IF;

Line 2745: FND_MESSAGE.SET_TOKEN ('COMMITMENT_NUMBER', l_commitment_number);

2741: l_commitment_end_date);
2742: IF l_commitment_end_date IS NOT NULL
2743: AND p_rec.course_end_date > l_commitment_end_date THEN
2744: FND_MESSAGE.SET_NAME ('OTA', 'OTA_OM_COMMITMENT');
2745: FND_MESSAGE.SET_TOKEN ('COMMITMENT_NUMBER', l_commitment_number);
2746: FND_MESSAGE.SET_TOKEN ('COMMITMENT_END_DATE', fnd_date.date_to_chardate(l_commitment_end_date));
2747: FND_MESSAGE.RAISE_ERROR;
2748: END IF;
2749: END IF;

Line 2746: FND_MESSAGE.SET_TOKEN ('COMMITMENT_END_DATE', fnd_date.date_to_chardate(l_commitment_end_date));

2742: IF l_commitment_end_date IS NOT NULL
2743: AND p_rec.course_end_date > l_commitment_end_date THEN
2744: FND_MESSAGE.SET_NAME ('OTA', 'OTA_OM_COMMITMENT');
2745: FND_MESSAGE.SET_TOKEN ('COMMITMENT_NUMBER', l_commitment_number);
2746: FND_MESSAGE.SET_TOKEN ('COMMITMENT_END_DATE', fnd_date.date_to_chardate(l_commitment_end_date));
2747: FND_MESSAGE.RAISE_ERROR;
2748: END IF;
2749: END IF;
2750: END IF;

Line 2747: FND_MESSAGE.RAISE_ERROR;

2743: AND p_rec.course_end_date > l_commitment_end_date THEN
2744: FND_MESSAGE.SET_NAME ('OTA', 'OTA_OM_COMMITMENT');
2745: FND_MESSAGE.SET_TOKEN ('COMMITMENT_NUMBER', l_commitment_number);
2746: FND_MESSAGE.SET_TOKEN ('COMMITMENT_END_DATE', fnd_date.date_to_chardate(l_commitment_end_date));
2747: FND_MESSAGE.RAISE_ERROR;
2748: END IF;
2749: END IF;
2750: END IF;
2751:

Line 2878: fnd_message.set_name ('OTA', 'OTA_13823_EVT_NO_DEL_TPC_EXIST');

2874: open c_get_tpc_rows;
2875: fetch c_get_tpc_rows into l_dummy;
2876: if c_get_tpc_rows%found then
2877: close c_get_tpc_rows;
2878: fnd_message.set_name ('OTA', 'OTA_13823_EVT_NO_DEL_TPC_EXIST');
2879: fnd_message.raise_error;
2880: else
2881: close c_get_tpc_rows;
2882: -- Determine if the event has per_budget_element records

Line 2879: fnd_message.raise_error;

2875: fetch c_get_tpc_rows into l_dummy;
2876: if c_get_tpc_rows%found then
2877: close c_get_tpc_rows;
2878: fnd_message.set_name ('OTA', 'OTA_13823_EVT_NO_DEL_TPC_EXIST');
2879: fnd_message.raise_error;
2880: else
2881: close c_get_tpc_rows;
2882: -- Determine if the event has per_budget_element records
2883: open c_get_pbe_rows;

Line 2887: fnd_message.set_name ('OTA', 'OTA_13824_EVT_NO_DEL_BGE_EXIST');

2883: open c_get_pbe_rows;
2884: fetch c_get_pbe_rows into l_dummy;
2885: if c_get_pbe_rows%found then
2886: close c_get_pbe_rows;
2887: fnd_message.set_name ('OTA', 'OTA_13824_EVT_NO_DEL_BGE_EXIST');
2888: fnd_message.raise_error;
2889: else
2890: close c_get_pbe_rows;
2891: end if;

Line 2888: fnd_message.raise_error;

2884: fetch c_get_pbe_rows into l_dummy;
2885: if c_get_pbe_rows%found then
2886: close c_get_pbe_rows;
2887: fnd_message.set_name ('OTA', 'OTA_13824_EVT_NO_DEL_BGE_EXIST');
2888: fnd_message.raise_error;
2889: else
2890: close c_get_pbe_rows;
2891: end if;
2892: end if;

Line 2902: fnd_message.set_name ('OTA', 'OTA_13677_EVT_SESSION_EXISTS');

2898: if c_session_details%found then
2899: --
2900: close c_session_details;
2901: --
2902: fnd_message.set_name ('OTA', 'OTA_13677_EVT_SESSION_EXISTS');
2903: fnd_message.raise_error;
2904: --
2905: end if;
2906: --

Line 2903: fnd_message.raise_error;

2899: --
2900: close c_session_details;
2901: --
2902: fnd_message.set_name ('OTA', 'OTA_13677_EVT_SESSION_EXISTS');
2903: fnd_message.raise_error;
2904: --
2905: end if;
2906: --
2907: close c_session_details;

Line 2917: fnd_message.set_name ('OTA', 'OTA_13678_EVT_RES_EXISTS');

2913: if c_resource_details%found then
2914: --
2915: close c_resource_details;
2916: --
2917: fnd_message.set_name ('OTA', 'OTA_13678_EVT_RES_EXISTS');
2918: fnd_message.raise_error;
2919: --
2920: end if;
2921: --

Line 2918: fnd_message.raise_error;

2914: --
2915: close c_resource_details;
2916: --
2917: fnd_message.set_name ('OTA', 'OTA_13678_EVT_RES_EXISTS');
2918: fnd_message.raise_error;
2919: --
2920: end if;
2921: --
2922: close c_resource_details;

Line 2932: fnd_message.set_name ('OTA', 'OTA_13681_EVT_PMM_EXISTS');

2928: if c_program_membership_details%found then
2929: --
2930: close c_program_membership_details;
2931: --
2932: fnd_message.set_name ('OTA', 'OTA_13681_EVT_PMM_EXISTS');
2933: fnd_message.raise_error;
2934: --
2935: end if;
2936: --

Line 2933: fnd_message.raise_error;

2929: --
2930: close c_program_membership_details;
2931: --
2932: fnd_message.set_name ('OTA', 'OTA_13681_EVT_PMM_EXISTS');
2933: fnd_message.raise_error;
2934: --
2935: end if;
2936: --
2937: close c_program_membership_details;

Line 2947: fnd_message.set_name ('OTA', 'OTA_13683_EVT_TEA_EXISTS');

2943: if c_event_associations_details%found then
2944: --
2945: close c_event_associations_details;
2946: --
2947: fnd_message.set_name ('OTA', 'OTA_13683_EVT_TEA_EXISTS');
2948: fnd_message.raise_error;
2949: --
2950: end if;
2951: --

Line 2948: fnd_message.raise_error;

2944: --
2945: close c_event_associations_details;
2946: --
2947: fnd_message.set_name ('OTA', 'OTA_13683_EVT_TEA_EXISTS');
2948: fnd_message.raise_error;
2949: --
2950: end if;
2951: --
2952: close c_event_associations_details;

Line 2962: fnd_message.set_name ('OTA', 'OTA_13679_EVT_TDB_EXISTS');

2958: if c_delegate_bookings_details%found then
2959: --
2960: close c_delegate_bookings_details;
2961: --
2962: fnd_message.set_name ('OTA', 'OTA_13679_EVT_TDB_EXISTS');
2963: fnd_message.raise_error;
2964: --
2965: end if;
2966: --

Line 2963: fnd_message.raise_error;

2959: --
2960: close c_delegate_bookings_details;
2961: --
2962: fnd_message.set_name ('OTA', 'OTA_13679_EVT_TDB_EXISTS');
2963: fnd_message.raise_error;
2964: --
2965: end if;
2966: --
2967: close c_delegate_bookings_details;

Line 2977: fnd_message.set_name ('OTA', 'OTA_467095_EVT_EVAL_EXISTS');

2973: if c_evaluation_details%found then
2974: --
2975: close c_evaluation_details;
2976: --
2977: fnd_message.set_name ('OTA', 'OTA_467095_EVT_EVAL_EXISTS');
2978: fnd_message.raise_error;
2979: --
2980: end if;
2981: --

Line 2978: fnd_message.raise_error;

2974: --
2975: close c_evaluation_details;
2976: --
2977: fnd_message.set_name ('OTA', 'OTA_467095_EVT_EVAL_EXISTS');
2978: fnd_message.raise_error;
2979: --
2980: end if;
2981: --
2982: close c_evaluation_details;

Line 2992: fnd_message.set_name ('OTA', 'OTA_13680_EVT_TBD_EXISTS');

2988: if c_booking_deals_details%found then
2989: --
2990: close c_booking_deals_details;
2991: --
2992: fnd_message.set_name ('OTA', 'OTA_13680_EVT_TBD_EXISTS');
2993: fnd_message.raise_error;
2994: --
2995: end if;
2996: --

Line 2993: fnd_message.raise_error;

2989: --
2990: close c_booking_deals_details;
2991: --
2992: fnd_message.set_name ('OTA', 'OTA_13680_EVT_TBD_EXISTS');
2993: fnd_message.raise_error;
2994: --
2995: end if;
2996: --
2997: close c_booking_deals_details;

Line 3007: fnd_message.set_name ('OTA', 'OTA_13682_EVT_CAT_EXISTS');

3003: if c_act_cat_inclusions_details%found then
3004: --
3005: close c_act_cat_inclusions_details;
3006: --
3007: fnd_message.set_name ('OTA', 'OTA_13682_EVT_CAT_EXISTS');
3008: fnd_message.raise_error;
3009: --
3010: end if;
3011: --

Line 3008: fnd_message.raise_error;

3004: --
3005: close c_act_cat_inclusions_details;
3006: --
3007: fnd_message.set_name ('OTA', 'OTA_13682_EVT_CAT_EXISTS');
3008: fnd_message.raise_error;
3009: --
3010: end if;
3011: --
3012: close c_act_cat_inclusions_details;

Line 3022: fnd_message.set_name ('OTA', 'OTA_443538_EVT_ATT_EXISTS');

3018: if c_attempts_details%found then
3019: --
3020: close c_attempts_details;
3021: --
3022: fnd_message.set_name ('OTA', 'OTA_443538_EVT_ATT_EXISTS');
3023: fnd_message.raise_error;
3024: --
3025: end if;
3026: --

Line 3023: fnd_message.raise_error;

3019: --
3020: close c_attempts_details;
3021: --
3022: fnd_message.set_name ('OTA', 'OTA_443538_EVT_ATT_EXISTS');
3023: fnd_message.raise_error;
3024: --
3025: end if;
3026: --
3027: close c_attempts_details;

Line 3034: fnd_message.set_name('OTA', 'OTA_443916_EVT_CFR_EXISTS');

3030: open c_conference_details;
3031: fetch c_conference_details into l_dummy;
3032: if c_conference_details%found then
3033: close c_conference_details;
3034: fnd_message.set_name('OTA', 'OTA_443916_EVT_CFR_EXISTS');
3035: fnd_message.raise_error;
3036: end if;
3037: close c_conference_details;
3038:

Line 3035: fnd_message.raise_error;

3031: fetch c_conference_details into l_dummy;
3032: if c_conference_details%found then
3033: close c_conference_details;
3034: fnd_message.set_name('OTA', 'OTA_443916_EVT_CFR_EXISTS');
3035: fnd_message.raise_error;
3036: end if;
3037: close c_conference_details;
3038:
3039:

Line 3146: fnd_message.set_name('OTA','OTA_13887_EVT_OWNER_INVALID');

3142: OPEN c_people_cross;
3143: FETCH c_people_cross into l_exist;
3144: if c_people_cross%notfound then
3145: close c_people_cross;
3146: fnd_message.set_name('OTA','OTA_13887_EVT_OWNER_INVALID');
3147: fnd_message.raise_error;
3148: end if;
3149: close c_people_cross;
3150: else

Line 3147: fnd_message.raise_error;

3143: FETCH c_people_cross into l_exist;
3144: if c_people_cross%notfound then
3145: close c_people_cross;
3146: fnd_message.set_name('OTA','OTA_13887_EVT_OWNER_INVALID');
3147: fnd_message.raise_error;
3148: end if;
3149: close c_people_cross;
3150: else
3151: hr_utility.set_location('Entering:'||l_proc, 20);

Line 3156: fnd_message.set_name('OTA','OTA_13887_EVT_OWNER_INVALID');

3152: OPEN c_people;
3153: FETCH c_people into l_exist;
3154: if c_people%notfound then
3155: close c_people;
3156: fnd_message.set_name('OTA','OTA_13887_EVT_OWNER_INVALID');
3157: fnd_message.raise_error;
3158: end if;
3159: close c_people;
3160: end if;

Line 3157: fnd_message.raise_error;

3153: FETCH c_people into l_exist;
3154: if c_people%notfound then
3155: close c_people;
3156: fnd_message.set_name('OTA','OTA_13887_EVT_OWNER_INVALID');
3157: fnd_message.raise_error;
3158: end if;
3159: close c_people;
3160: end if;
3161: hr_utility.set_location('Leaving:'||l_proc, 40);

Line 3208: fnd_message.set_name('OTA','OTA_13888_TDB_LINE_INVALID');

3204: open csr_order_line;
3205: fetch csr_order_line into l_exists;
3206: if csr_order_line%notfound then
3207: close csr_order_line;
3208: fnd_message.set_name('OTA','OTA_13888_TDB_LINE_INVALID');
3209: fnd_message.raise_error;
3210: end if;
3211: close csr_order_line;
3212: hr_utility.set_location('Entering:'||l_proc, 20);

Line 3209: fnd_message.raise_error;

3205: fetch csr_order_line into l_exists;
3206: if csr_order_line%notfound then
3207: close csr_order_line;
3208: fnd_message.set_name('OTA','OTA_13888_TDB_LINE_INVALID');
3209: fnd_message.raise_error;
3210: end if;
3211: close csr_order_line;
3212: hr_utility.set_location('Entering:'||l_proc, 20);
3213: end if;

Line 3358: fnd_message.set_name('OTA','OTA_13896_EVT_ORDER_LINE_EXIST');

3354: Begin
3355: hr_utility.set_location('Entering:'||l_proc, 5);
3356:
3357: if p_line_id is not null then
3358: fnd_message.set_name('OTA','OTA_13896_EVT_ORDER_LINE_EXIST');
3359: fnd_message.raise_error;
3360: hr_utility.set_location('Entering:'||l_proc, 20);
3361:
3362: end if;

Line 3359: fnd_message.raise_error;

3355: hr_utility.set_location('Entering:'||l_proc, 5);
3356:
3357: if p_line_id is not null then
3358: fnd_message.set_name('OTA','OTA_13896_EVT_ORDER_LINE_EXIST');
3359: fnd_message.raise_error;
3360: hr_utility.set_location('Entering:'||l_proc, 20);
3361:
3362: end if;
3363: hr_utility.set_location('Leaving:'||l_proc, 30);

Line 3412: fnd_message.set_name('OTA','OTA_13907_TSR_TRNCTR_NOT_EXIST');

3408: open c_training_center;
3409: fetch c_training_center into l_exists;
3410: if c_training_center%notfound then
3411: close c_training_center;
3412: fnd_message.set_name('OTA','OTA_13907_TSR_TRNCTR_NOT_EXIST');
3413: fnd_message.raise_error;
3414: end if;
3415: close c_training_center;
3416: hr_utility.set_location('Entering:'||l_proc, 20);

Line 3413: fnd_message.raise_error;

3409: fetch c_training_center into l_exists;
3410: if c_training_center%notfound then
3411: close c_training_center;
3412: fnd_message.set_name('OTA','OTA_13907_TSR_TRNCTR_NOT_EXIST');
3413: fnd_message.raise_error;
3414: end if;
3415: close c_training_center;
3416: hr_utility.set_location('Entering:'||l_proc, 20);
3417: end if;

Line 3470: fnd_message.set_name('OTA','OTA_13908_TSR_LOC_NOT_EXIST');

3466: open c_location;
3467: fetch c_location into l_exists;
3468: if c_location%notfound then
3469: close c_location;
3470: fnd_message.set_name('OTA','OTA_13908_TSR_LOC_NOT_EXIST');
3471: fnd_message.raise_error;
3472: end if;
3473: close c_location;
3474: hr_utility.set_location('Entering:'||l_proc, 20);

Line 3471: fnd_message.raise_error;

3467: fetch c_location into l_exists;
3468: if c_location%notfound then
3469: close c_location;
3470: fnd_message.set_name('OTA','OTA_13908_TSR_LOC_NOT_EXIST');
3471: fnd_message.raise_error;
3472: end if;
3473: close c_location;
3474: hr_utility.set_location('Entering:'||l_proc, 20);
3475: end if;

Line 3581: fnd_message.set_name('OTA','OTA_443321_EVT_OFF_INVALID_ACT');

3577: open csr_offering;
3578: fetch csr_offering into l_exists;
3579: if csr_offering%notfound then
3580: close csr_offering;
3581: fnd_message.set_name('OTA','OTA_443321_EVT_OFF_INVALID_ACT');
3582: fnd_message.raise_error;
3583: end if;
3584: close csr_offering;
3585: hr_utility.set_location('Leaving:'||l_proc, 20);

Line 3582: fnd_message.raise_error;

3578: fetch csr_offering into l_exists;
3579: if csr_offering%notfound then
3580: close csr_offering;
3581: fnd_message.set_name('OTA','OTA_443321_EVT_OFF_INVALID_ACT');
3582: fnd_message.raise_error;
3583: end if;
3584: close csr_offering;
3585: hr_utility.set_location('Leaving:'||l_proc, 20);
3586: EXCEPTION

Line 3630: fnd_message.set_name('OTA', 'OTA_EVT_SECURE');

3626:
3627: OPEN csr_org;
3628: FETCH csr_org INTO l_username;
3629: if csr_org%notfound then
3630: fnd_message.set_name('OTA', 'OTA_EVT_SECURE');
3631: fnd_message.raise_error;
3632: end if;
3633: close csr_org;
3634:

Line 3631: fnd_message.raise_error;

3627: OPEN csr_org;
3628: FETCH csr_org INTO l_username;
3629: if csr_org%notfound then
3630: fnd_message.set_name('OTA', 'OTA_EVT_SECURE');
3631: fnd_message.raise_error;
3632: end if;
3633: close csr_org;
3634:
3635:

Line 3642: fnd_message.set_name('OTA', 'OTA_EVT_SECURE');

3638: FETCH csr_org INTO l_username;
3639: l_user := fnd_profile.value('USERNAME');
3640: l_condition := nvl(l_user, 'UNSET1') = nvl(l_username, 'UNSET2');
3641: IF NOT l_condition THEN
3642: fnd_message.set_name('OTA', 'OTA_EVT_SECURE');
3643: fnd_message.raise_error;
3644: END IF;
3645: CLOSE csr_org;*/
3646: hr_utility.set_location('Leaving:'||l_proc, 20);

Line 3643: fnd_message.raise_error;

3639: l_user := fnd_profile.value('USERNAME');
3640: l_condition := nvl(l_user, 'UNSET1') = nvl(l_username, 'UNSET2');
3641: IF NOT l_condition THEN
3642: fnd_message.set_name('OTA', 'OTA_EVT_SECURE');
3643: fnd_message.raise_error;
3644: END IF;
3645: CLOSE csr_org;*/
3646: hr_utility.set_location('Leaving:'||l_proc, 20);
3647: