APPS.OTA_TAV_BUS dependencies on HR_UTILITY

Line 45: hr_utility.set_location('Entering:'||l_proc,10);

41: --
42: l_proc varchar2(72) := g_package || 'chk_ddf';
43: --
44: begin
45: hr_utility.set_location('Entering:'||l_proc,10);
46: --
47: if ((p_rec.activity_version_id is not null) and (
48: nvl(ota_tav_shd.g_old_rec.tav_information_category, hr_api.g_varchar2) <>
49: nvl(p_rec.tav_information_category, hr_api.g_varchar2) or

Line 144: hr_utility.set_location(' Leaving:'||l_proc,20);

140: ,p_attribute20_value => p_rec.tav_information20
141: );
142: end if;
143: --
144: hr_utility.set_location(' Leaving:'||l_proc,20);
145: end chk_ddf;
146: --
147:
148: --

Line 167: hr_utility.set_location('Entering:'||v_proc, 5);

163: v_proc varchar2(72) := g_package||'check_min_max_values';
164: --
165: Begin
166: --
167: hr_utility.set_location('Entering:'||v_proc, 5);
168: --
169: ota_tav_api_business_rules.check_min_max_values( p_min
170: , p_max );
171: --

Line 172: hr_utility.set_location(' Leaving:'||v_proc, 10);

168: --
169: ota_tav_api_business_rules.check_min_max_values( p_min
170: , p_max );
171: --
172: hr_utility.set_location(' Leaving:'||v_proc, 10);
173: --
174: exception
175: when app_exception.application_exception then
176: if hr_multi_message.exception_add

Line 180: hr_utility.set_location(' Leaving:'|| v_proc,70);

176: if hr_multi_message.exception_add
177: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.MINIMUM_ATTENDEES'
178: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.MAXIMUM_ATTENDEES'
179: ) then
180: hr_utility.set_location(' Leaving:'|| v_proc,70);
181: raise;
182: end if;
183: hr_utility.set_location(' Leaving:'|| v_proc,80);
184: End check_min_max_values;

Line 183: hr_utility.set_location(' Leaving:'|| v_proc,80);

179: ) then
180: hr_utility.set_location(' Leaving:'|| v_proc,70);
181: raise;
182: end if;
183: hr_utility.set_location(' Leaving:'|| v_proc,80);
184: End check_min_max_values;
185: --
186: -- ----------------------------------------------------------------------------
187: -- |--------------------------< check_unique_name >---------------------------|

Line 206: hr_utility.set_location('Entering:'|| v_proc, 5);

202: v_proc varchar2(72) := g_package||'check_unique_name';
203: --
204: Begin
205: --
206: hr_utility.set_location('Entering:'|| v_proc, 5);
207: --
208: ota_tav_api_business_rules.check_unique_name( p_business_group_id
209: , p_activity_id
210: , p_version_name

Line 213: hr_utility.set_location(' Leaving:'|| v_proc, 10);

209: , p_activity_id
210: , p_version_name
211: , p_activity_version_id);
212: --
213: hr_utility.set_location(' Leaving:'|| v_proc, 10);
214: --
215: End check_unique_name;
216:
217: -- ----------------------------------------------------------------------------

Line 230: hr_utility.set_location(' Leaving:'||l_proc, 10);

226: l_proc VARCHAR2(72) := g_package||'chk_competency_update_level';
227: l_api_updating boolean;
228:
229: BEGIN
230: hr_utility.set_location(' Leaving:'||l_proc, 10);
231: --
232: -- check mandatory parameters has been set
233: --
234: hr_api.mandatory_arg_error

Line 249: hr_utility.set_location(' Leaving:'||l_proc, 20);

245: NVL(ota_tav_shd.g_old_rec.competency_update_level,hr_api.g_varchar2) <>
246: NVL(p_competency_update_level, hr_api.g_varchar2))
247: OR NOT l_api_updating AND p_competency_update_level IS NOT NULL) THEN
248:
249: hr_utility.set_location(' Leaving:'||l_proc, 20);
250: --
251:
252: IF p_competency_update_level IS NOT NULL THEN
253: IF hr_api.not_exists_in_hr_lookups

Line 260: hr_utility.set_location(' Leaving:'||l_proc, 30);

256: ,p_lookup_code => p_competency_update_level) THEN
257: fnd_message.set_name('OTA','OTA_443411_COMP_UPD_LEV_INVLD');
258: fnd_message.raise_error;
259: END IF;
260: hr_utility.set_location(' Leaving:'||l_proc, 30);
261:
262: END IF;
263:
264: END IF;

Line 265: hr_utility.set_location(' Leaving:'||l_proc, 40);

261:
262: END IF;
263:
264: END IF;
265: hr_utility.set_location(' Leaving:'||l_proc, 40);
266:
267: EXCEPTION
268:
269: WHEN app_exception.application_exception THEN

Line 274: hr_utility.set_location(' Leaving:'||l_proc, 42);

270:
271: IF hr_multi_message.exception_add
272: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.COMPETENCY_UPDATE_LEVEL') THEN
273:
274: hr_utility.set_location(' Leaving:'||l_proc, 42);
275: RAISE;
276: END IF;
277:
278: hr_utility.set_location(' Leaving:'||l_proc, 44);

Line 278: hr_utility.set_location(' Leaving:'||l_proc, 44);

274: hr_utility.set_location(' Leaving:'||l_proc, 42);
275: RAISE;
276: END IF;
277:
278: hr_utility.set_location(' Leaving:'||l_proc, 44);
279:
280: END chk_competency_update_level;
281:
282: --

Line 303: hr_utility.set_location('Entering:'|| v_proc, 5);

299: v_proc varchar2(72) := g_package||'check_superseding_version';
300: --
301: Begin
302: --
303: hr_utility.set_location('Entering:'|| v_proc, 5);
304: --
305: ota_tav_api_business_rules.check_superseding_version( p_sup_act_vers_id
306: , p_end_date );
307: --

Line 308: hr_utility.set_location(' Leaving:'|| v_proc, 10);

304: --
305: ota_tav_api_business_rules.check_superseding_version( p_sup_act_vers_id
306: , p_end_date );
307: --
308: hr_utility.set_location(' Leaving:'|| v_proc, 10);
309: --
310: exception
311: when app_exception.application_exception then
312: if hr_multi_message.exception_add

Line 315: hr_utility.set_location(' Leaving:'|| v_proc,70);

311: when app_exception.application_exception then
312: if hr_multi_message.exception_add
313: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.SUPERSEDE_BY_ACT_VERSION_ID'
314: ) then
315: hr_utility.set_location(' Leaving:'|| v_proc,70);
316: raise;
317: end if;
318: hr_utility.set_location(' Leaving:'|| v_proc,80);
319: End check_superseding_version;

Line 318: hr_utility.set_location(' Leaving:'|| v_proc,80);

314: ) then
315: hr_utility.set_location(' Leaving:'|| v_proc,70);
316: raise;
317: end if;
318: hr_utility.set_location(' Leaving:'|| v_proc,80);
319: End check_superseding_version;
320: --
321: -- ----------------------------------------------------------------------------
322: -- |--------------------------< check_user_status >---------------------------|

Line 338: hr_utility.set_location('Entering:'|| v_proc, 5);

334: v_proc varchar2(72) := g_package||'check_user_status';
335: --
336: Begin
337: --
338: hr_utility.set_location('Entering:'|| v_proc, 5);
339: --
340: ota_tav_api_business_rules.check_user_status( p_user_status );
341: --
342: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 342: hr_utility.set_location(' Leaving:'|| v_proc, 10);

338: hr_utility.set_location('Entering:'|| v_proc, 5);
339: --
340: ota_tav_api_business_rules.check_user_status( p_user_status );
341: --
342: hr_utility.set_location(' Leaving:'|| v_proc, 10);
343: --
344: exception
345: when app_exception.application_exception then
346: if hr_multi_message.exception_add

Line 349: hr_utility.set_location(' Leaving:'|| v_proc,70);

345: when app_exception.application_exception then
346: if hr_multi_message.exception_add
347: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.USER_STATUS'
348: ) then
349: hr_utility.set_location(' Leaving:'|| v_proc,70);
350: raise;
351: end if;
352: hr_utility.set_location(' Leaving:'|| v_proc,80);
353: End check_user_status;

Line 352: hr_utility.set_location(' Leaving:'|| v_proc,80);

348: ) then
349: hr_utility.set_location(' Leaving:'|| v_proc,70);
350: raise;
351: end if;
352: hr_utility.set_location(' Leaving:'|| v_proc,80);
353: End check_user_status;
354: --
355: -- ----------------------------------------------------------------------------
356: -- |-------------------------< check_success_criteria >-----------------------|

Line 372: hr_utility.set_location('Entering:'|| v_proc, 5);

368: v_proc varchar2(72) := g_package||'check_success_criteria';
369: --
370: Begin
371: --
372: hr_utility.set_location('Entering:'|| v_proc, 5);
373: --
374: ota_tav_api_business_rules.check_success_criteria( p_succ_criteria );
375: --
376: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 376: hr_utility.set_location(' Leaving:'|| v_proc, 10);

372: hr_utility.set_location('Entering:'|| v_proc, 5);
373: --
374: ota_tav_api_business_rules.check_success_criteria( p_succ_criteria );
375: --
376: hr_utility.set_location(' Leaving:'|| v_proc, 10);
377: --
378: exception
379: when app_exception.application_exception then
380: if hr_multi_message.exception_add

Line 383: hr_utility.set_location(' Leaving:'|| v_proc,70);

379: when app_exception.application_exception then
380: if hr_multi_message.exception_add
381: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.SUCCESS_CRITERIA'
382: ) then
383: hr_utility.set_location(' Leaving:'|| v_proc,70);
384: raise;
385: end if;
386: hr_utility.set_location(' Leaving:'|| v_proc,80);
387: End check_success_criteria;

Line 386: hr_utility.set_location(' Leaving:'|| v_proc,80);

382: ) then
383: hr_utility.set_location(' Leaving:'|| v_proc,70);
384: raise;
385: end if;
386: hr_utility.set_location(' Leaving:'|| v_proc,80);
387: End check_success_criteria;
388: --
389: -- ----------------------------------------------------------------------------
390: -- |----------------------< get_activity_version_id >-------------------------|

Line 408: hr_utility.set_location('Entering:'|| v_proc, 5);

404: v_proc varchar2(72) := g_package||'get_activity_version_id';
405: --
406: Begin
407: --
408: hr_utility.set_location('Entering:'|| v_proc, 5);
409: --
410: Return ota_tav_api_business_rules.get_activity_version_id( p_activity_id
411: , p_version_name );
412: --

Line 413: hr_utility.set_location(' Leaving:'|| v_proc, 10);

409: --
410: Return ota_tav_api_business_rules.get_activity_version_id( p_activity_id
411: , p_version_name );
412: --
413: hr_utility.set_location(' Leaving:'|| v_proc, 10);
414: --
415: End get_activity_version_id;
416: --
417: -- ----------------------------------------------------------------------------

Line 458: hr_utility.set_location('Entering:'|| v_proc, 5);

454: v_proc varchar2(72) := g_package||'check_start_end_dates';
455: --
456: Begin
457: --
458: hr_utility.set_location('Entering:'|| v_proc, 5);
459: --
460: ota_tav_api_business_rules.check_start_end_dates( p_start_date
461: , p_end_date );
462: --

Line 463: hr_utility.set_location(' Leaving:'|| v_proc, 10);

459: --
460: ota_tav_api_business_rules.check_start_end_dates( p_start_date
461: , p_end_date );
462: --
463: hr_utility.set_location(' Leaving:'|| v_proc, 10);
464: --
465: exception
466: when app_exception.application_exception then
467: if hr_multi_message.exception_add

Line 471: hr_utility.set_location(' Leaving:'|| v_proc,70);

467: if hr_multi_message.exception_add
468: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
469: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
470: ) then
471: hr_utility.set_location(' Leaving:'|| v_proc,70);
472: raise;
473: end if;
474: hr_utility.set_location(' Leaving:'|| v_proc,80);
475: End check_start_end_dates;

Line 474: hr_utility.set_location(' Leaving:'|| v_proc,80);

470: ) then
471: hr_utility.set_location(' Leaving:'|| v_proc,70);
472: raise;
473: end if;
474: hr_utility.set_location(' Leaving:'|| v_proc,80);
475: End check_start_end_dates;
476: --
477: -- ----------------------------------------------------------------------------
478: -- |-------------------------< check_dates_update_ple >-----------------------|

Line 510: hr_utility.set_location('Entering:'|| v_proc, 5);

506: (p_check_message_name1 => 'OTA_13312_GEN_DATE_ORDER'
507: ) then
508:
509: --
510: hr_utility.set_location('Entering:'|| v_proc, 5);
511: --
512: ota_tav_api_business_rules.check_dates_update_ple( p_activity_version_id
513: , p_start_date
514: , p_end_date );

Line 516: hr_utility.set_location(' Leaving:'|| v_proc, 10);

512: ota_tav_api_business_rules.check_dates_update_ple( p_activity_version_id
513: , p_start_date
514: , p_end_date );
515: --
516: hr_utility.set_location(' Leaving:'|| v_proc, 10);
517: --
518: end if;
519: exception
520: when app_exception.application_exception then

Line 525: hr_utility.set_location(' Leaving:'|| v_proc,70);

521: if hr_multi_message.exception_add
522: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
523: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
524: ) then
525: hr_utility.set_location(' Leaving:'|| v_proc,70);
526: raise;
527: end if;
528: hr_utility.set_location(' Leaving:'|| v_proc,80);
529: End check_dates_update_ple;

Line 528: hr_utility.set_location(' Leaving:'|| v_proc,80);

524: ) then
525: hr_utility.set_location(' Leaving:'|| v_proc,70);
526: raise;
527: end if;
528: hr_utility.set_location(' Leaving:'|| v_proc,80);
529: End check_dates_update_ple;
530: --
531: -- ----------------------------------------------------------------------------
532: -- |-------------------------< check_dates_update_tbd >-----------------------|

Line 555: hr_utility.set_location('Entering:'|| v_proc, 5);

551: if hr_multi_message.no_error_message
552: (p_check_message_name1 => 'OTA_13312_GEN_DATE_ORDER'
553: ) then
554: --
555: hr_utility.set_location('Entering:'|| v_proc, 5);
556: --
557: ota_tav_api_business_rules.check_dates_update_tbd( p_activity_version_id
558: , p_start_date
559: , p_end_date );

Line 561: hr_utility.set_location(' Leaving:'|| v_proc, 10);

557: ota_tav_api_business_rules.check_dates_update_tbd( p_activity_version_id
558: , p_start_date
559: , p_end_date );
560: --
561: hr_utility.set_location(' Leaving:'|| v_proc, 10);
562: --
563: end if;
564: exception
565: when app_exception.application_exception then

Line 570: hr_utility.set_location(' Leaving:'|| v_proc,70);

566: if hr_multi_message.exception_add
567: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
568: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
569: ) then
570: hr_utility.set_location(' Leaving:'|| v_proc,70);
571: raise;
572: end if;
573: hr_utility.set_location(' Leaving:'|| v_proc,80);
574: End check_dates_update_tbd;

Line 573: hr_utility.set_location(' Leaving:'|| v_proc,80);

569: ) then
570: hr_utility.set_location(' Leaving:'|| v_proc,70);
571: raise;
572: end if;
573: hr_utility.set_location(' Leaving:'|| v_proc,80);
574: End check_dates_update_tbd;
575: --
576: -- ----------------------------------------------------------------------------
577: -- |-------------------------< check_dates_update_evt >-----------------------|

Line 603: hr_utility.set_location('Entering:'|| v_proc, 5);

599: if hr_multi_message.no_error_message
600: (p_check_message_name1 => 'OTA_13312_GEN_DATE_ORDER'
601: ) then
602: --
603: hr_utility.set_location('Entering:'|| v_proc, 5);
604: --
605: ota_tav_api_business_rules.check_dates_update_evt( p_activity_version_id
606: , p_start_date
607: , p_end_date );

Line 609: hr_utility.set_location(' Leaving:'|| v_proc, 10);

605: ota_tav_api_business_rules.check_dates_update_evt( p_activity_version_id
606: , p_start_date
607: , p_end_date );
608: --
609: hr_utility.set_location(' Leaving:'|| v_proc, 10);
610: --
611: end if;
612: exception
613: when app_exception.application_exception then

Line 618: hr_utility.set_location(' Leaving:'|| v_proc,70);

614: if hr_multi_message.exception_add
615: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
616: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
617: ) then
618: hr_utility.set_location(' Leaving:'|| v_proc,70);
619: raise;
620: end if;
621: hr_utility.set_location(' Leaving:'|| v_proc,80);
622: End check_dates_update_evt;

Line 621: hr_utility.set_location(' Leaving:'|| v_proc,80);

617: ) then
618: hr_utility.set_location(' Leaving:'|| v_proc,70);
619: raise;
620: end if;
621: hr_utility.set_location(' Leaving:'|| v_proc,80);
622: End check_dates_update_evt;
623: /* bug 3795299
624: -- ----------------------------------------------------------------------------
625: -- |-------------------------< check_dates_update_tpm >-----------------------|

Line 648: hr_utility.set_location('Entering:'|| v_proc, 5);

644: if hr_multi_message.no_error_message
645: (p_check_message_name1 => 'OTA_13312_GEN_DATE_ORDER'
646: ) then
647: --
648: hr_utility.set_location('Entering:'|| v_proc, 5);
649: --
650: ota_trng_plan_util_ss.chk_valid_act_version_dates
651: (p_activity_version_id
652: ,p_start_date

Line 655: hr_utility.set_location(' Leaving:'|| v_proc, 10);

651: (p_activity_version_id
652: ,p_start_date
653: ,p_end_date);
654: --
655: hr_utility.set_location(' Leaving:'|| v_proc, 10);
656: --
657: end if;
658: exception
659: when app_exception.application_exception then

Line 664: hr_utility.set_location(' Leaving:'|| v_proc,70);

660: if hr_multi_message.exception_add
661: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
662: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
663: ) then
664: hr_utility.set_location(' Leaving:'|| v_proc,70);
665: raise;
666: end if;
667: hr_utility.set_location(' Leaving:'|| v_proc,80);
668: End check_dates_update_tpm;

Line 667: hr_utility.set_location(' Leaving:'|| v_proc,80);

663: ) then
664: hr_utility.set_location(' Leaving:'|| v_proc,70);
665: raise;
666: end if;
667: hr_utility.set_location(' Leaving:'|| v_proc,80);
668: End check_dates_update_tpm;
669: */
670: --
671: -- ----------------------------------------------------------------------------

Line 690: hr_utility.set_location('Entering:'|| v_proc, 5);

686: v_proc varchar2(72) := g_package||'check_if_evt_exists';
687: --
688: Begin
689: --
690: hr_utility.set_location('Entering:'|| v_proc, 5);
691: --
692: ota_tav_api_business_rules.check_if_evt_exists( p_activity_version_id );
693: --
694: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 694: hr_utility.set_location(' Leaving:'|| v_proc, 10);

690: hr_utility.set_location('Entering:'|| v_proc, 5);
691: --
692: ota_tav_api_business_rules.check_if_evt_exists( p_activity_version_id );
693: --
694: hr_utility.set_location(' Leaving:'|| v_proc, 10);
695: --
696: exception
697: when app_exception.application_exception then
698: if hr_multi_message.exception_add

Line 701: hr_utility.set_location(' Leaving:'|| v_proc,70);

697: when app_exception.application_exception then
698: if hr_multi_message.exception_add
699: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
700: ) then
701: hr_utility.set_location(' Leaving:'|| v_proc,70);
702: raise;
703: end if;
704: hr_utility.set_location(' Leaving:'|| v_proc,80);
705: End check_if_evt_exists;

Line 704: hr_utility.set_location(' Leaving:'|| v_proc,80);

700: ) then
701: hr_utility.set_location(' Leaving:'|| v_proc,70);
702: raise;
703: end if;
704: hr_utility.set_location(' Leaving:'|| v_proc,80);
705: End check_if_evt_exists;
706: -- ----------------------------------------------------------------------------
707: -- |-------------------------< check_if_evt_exists >--------------------------|
708: -- ----------------------------------------------------------------------------

Line 725: hr_utility.set_location('Entering:'|| v_proc, 5);

721: v_proc varchar2(72) := g_package||'check_if_off_exists';
722: --
723: Begin
724: --
725: hr_utility.set_location('Entering:'|| v_proc, 5);
726: --
727: ota_tav_api_business_rules.check_if_off_exists( p_activity_version_id );
728: --
729: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 729: hr_utility.set_location(' Leaving:'|| v_proc, 10);

725: hr_utility.set_location('Entering:'|| v_proc, 5);
726: --
727: ota_tav_api_business_rules.check_if_off_exists( p_activity_version_id );
728: --
729: hr_utility.set_location(' Leaving:'|| v_proc, 10);
730: --
731: exception
732: when app_exception.application_exception then
733: if hr_multi_message.exception_add

Line 736: hr_utility.set_location(' Leaving:'|| v_proc,70);

732: when app_exception.application_exception then
733: if hr_multi_message.exception_add
734: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
735: ) then
736: hr_utility.set_location(' Leaving:'|| v_proc,70);
737: raise;
738: end if;
739: hr_utility.set_location(' Leaving:'|| v_proc,80);
740: End check_if_off_exists;

Line 739: hr_utility.set_location(' Leaving:'|| v_proc,80);

735: ) then
736: hr_utility.set_location(' Leaving:'|| v_proc,70);
737: raise;
738: end if;
739: hr_utility.set_location(' Leaving:'|| v_proc,80);
740: End check_if_off_exists;
741: -- ---------------------------------------------------------------------------
742:
743: -- ---------------------------------------------------------------------------

Line 761: hr_utility.set_location('Entering:'|| v_proc, 5);

757: v_proc varchar2(72) := g_package||'check_if_tpm_exists';
758: --
759: Begin
760: --
761: hr_utility.set_location('Entering:'|| v_proc, 5);
762: --
763: ota_tav_api_business_rules.check_if_tpm_exists( p_activity_version_id );
764: --
765: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 765: hr_utility.set_location(' Leaving:'|| v_proc, 10);

761: hr_utility.set_location('Entering:'|| v_proc, 5);
762: --
763: ota_tav_api_business_rules.check_if_tpm_exists( p_activity_version_id );
764: --
765: hr_utility.set_location(' Leaving:'|| v_proc, 10);
766: --
767: --
768: exception
769: when app_exception.application_exception then

Line 773: hr_utility.set_location(' Leaving:'|| v_proc,70);

769: when app_exception.application_exception then
770: if hr_multi_message.exception_add
771: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
772: ) then
773: hr_utility.set_location(' Leaving:'|| v_proc,70);
774: raise;
775: end if;
776: hr_utility.set_location(' Leaving:'|| v_proc,80);
777: End check_if_tpm_exists;

Line 776: hr_utility.set_location(' Leaving:'|| v_proc,80);

772: ) then
773: hr_utility.set_location(' Leaving:'|| v_proc,70);
774: raise;
775: end if;
776: hr_utility.set_location(' Leaving:'|| v_proc,80);
777: End check_if_tpm_exists;
778: --
779: --
780: -- ---------------------------------------------------------------------------

Line 799: hr_utility.set_location('Entering:'|| v_proc, 5);

795: v_proc varchar2(72) := g_package||'check_if_lpm_exists';
796: --
797: Begin
798: --
799: hr_utility.set_location('Entering:'|| v_proc, 5);
800: --
801: ota_tav_api_business_rules.check_if_lpm_exists( p_activity_version_id );
802: --
803: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 803: hr_utility.set_location(' Leaving:'|| v_proc, 10);

799: hr_utility.set_location('Entering:'|| v_proc, 5);
800: --
801: ota_tav_api_business_rules.check_if_lpm_exists( p_activity_version_id );
802: --
803: hr_utility.set_location(' Leaving:'|| v_proc, 10);
804: --
805: --
806: exception
807: when app_exception.application_exception then

Line 811: hr_utility.set_location(' Leaving:'|| v_proc,70);

807: when app_exception.application_exception then
808: if hr_multi_message.exception_add
809: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
810: ) then
811: hr_utility.set_location(' Leaving:'|| v_proc,70);
812: raise;
813: end if;
814: hr_utility.set_location(' Leaving:'|| v_proc,80);
815: End check_if_lpm_exists;

Line 814: hr_utility.set_location(' Leaving:'|| v_proc,80);

810: ) then
811: hr_utility.set_location(' Leaving:'|| v_proc,70);
812: raise;
813: end if;
814: hr_utility.set_location(' Leaving:'|| v_proc,80);
815: End check_if_lpm_exists;
816: --
817: --
818:

Line 838: hr_utility.set_location('Entering:'|| v_proc, 5);

834: v_proc varchar2(72) := g_package||'check_if_tbd_exists';
835: --
836: Begin
837: --
838: hr_utility.set_location('Entering:'|| v_proc, 5);
839: --
840: ota_tav_api_business_rules.check_if_tbd_exists( p_activity_version_id );
841: --
842: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 842: hr_utility.set_location(' Leaving:'|| v_proc, 10);

838: hr_utility.set_location('Entering:'|| v_proc, 5);
839: --
840: ota_tav_api_business_rules.check_if_tbd_exists( p_activity_version_id );
841: --
842: hr_utility.set_location(' Leaving:'|| v_proc, 10);
843: --
844: exception
845: when app_exception.application_exception then
846: if hr_multi_message.exception_add

Line 849: hr_utility.set_location(' Leaving:'|| v_proc,70);

845: when app_exception.application_exception then
846: if hr_multi_message.exception_add
847: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
848: ) then
849: hr_utility.set_location(' Leaving:'|| v_proc,70);
850: raise;
851: end if;
852: hr_utility.set_location(' Leaving:'|| v_proc,80);
853: End check_if_tbd_exists;

Line 852: hr_utility.set_location(' Leaving:'|| v_proc,80);

848: ) then
849: hr_utility.set_location(' Leaving:'|| v_proc,70);
850: raise;
851: end if;
852: hr_utility.set_location(' Leaving:'|| v_proc,80);
853: End check_if_tbd_exists;
854: --
855:
856: -- ----------------------------------------------------------------------------

Line 875: hr_utility.set_location('Entering:'|| v_proc, 5);

871: v_proc varchar2(72) := g_package||'check_if_ple_exists';
872: --
873: Begin
874: --
875: hr_utility.set_location('Entering:'|| v_proc, 5);
876: --
877: ota_tav_api_business_rules.check_if_ple_exists( p_activity_version_id );
878: --
879: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 879: hr_utility.set_location(' Leaving:'|| v_proc, 10);

875: hr_utility.set_location('Entering:'|| v_proc, 5);
876: --
877: ota_tav_api_business_rules.check_if_ple_exists( p_activity_version_id );
878: --
879: hr_utility.set_location(' Leaving:'|| v_proc, 10);
880: --
881: exception
882: when app_exception.application_exception then
883: if hr_multi_message.exception_add

Line 886: hr_utility.set_location(' Leaving:'|| v_proc,70);

882: when app_exception.application_exception then
883: if hr_multi_message.exception_add
884: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
885: ) then
886: hr_utility.set_location(' Leaving:'|| v_proc,70);
887: raise;
888: end if;
889: hr_utility.set_location(' Leaving:'|| v_proc,80);
890: End check_if_ple_exists;

Line 889: hr_utility.set_location(' Leaving:'|| v_proc,80);

885: ) then
886: hr_utility.set_location(' Leaving:'|| v_proc,70);
887: raise;
888: end if;
889: hr_utility.set_location(' Leaving:'|| v_proc,80);
890: End check_if_ple_exists;
891: --
892:
893: -- ----------------------------------------------------------------------------

Line 912: hr_utility.set_location('Entering:'|| v_proc, 5);

908: v_proc varchar2(72) := g_package||'check_if_comp_exists';
909: --
910: Begin
911: --
912: hr_utility.set_location('Entering:'|| v_proc, 5);
913: --
914: ota_tav_api_business_rules.check_if_comp_exists( p_activity_version_id );
915: --
916: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 916: hr_utility.set_location(' Leaving:'|| v_proc, 10);

912: hr_utility.set_location('Entering:'|| v_proc, 5);
913: --
914: ota_tav_api_business_rules.check_if_comp_exists( p_activity_version_id );
915: --
916: hr_utility.set_location(' Leaving:'|| v_proc, 10);
917: --
918: exception
919: when app_exception.application_exception then
920: if hr_multi_message.exception_add

Line 923: hr_utility.set_location(' Leaving:'|| v_proc,70);

919: when app_exception.application_exception then
920: if hr_multi_message.exception_add
921: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
922: ) then
923: hr_utility.set_location(' Leaving:'|| v_proc,70);
924: raise;
925: end if;
926: hr_utility.set_location(' Leaving:'|| v_proc,80);
927: End check_if_comp_exists;

Line 926: hr_utility.set_location(' Leaving:'|| v_proc,80);

922: ) then
923: hr_utility.set_location(' Leaving:'|| v_proc,70);
924: raise;
925: end if;
926: hr_utility.set_location(' Leaving:'|| v_proc,80);
927: End check_if_comp_exists;
928:
929: -- ----------------------------------------------------------------------------
930: -- |-------------------------< check_if_tav_exists >--------------------------|

Line 949: hr_utility.set_location('Entering:'|| v_proc, 5);

945: v_proc varchar2(72) := g_package||'check_if_tav_exists';
946: --
947: Begin
948: --
949: hr_utility.set_location('Entering:'|| v_proc, 5);
950: --
951: ota_tav_api_business_rules.check_if_tav_exists( p_activity_version_id );
952: --
953: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 953: hr_utility.set_location(' Leaving:'|| v_proc, 10);

949: hr_utility.set_location('Entering:'|| v_proc, 5);
950: --
951: ota_tav_api_business_rules.check_if_tav_exists( p_activity_version_id );
952: --
953: hr_utility.set_location(' Leaving:'|| v_proc, 10);
954: --
955: exception
956: when app_exception.application_exception then
957: if hr_multi_message.exception_add

Line 960: hr_utility.set_location(' Leaving:'|| v_proc,70);

956: when app_exception.application_exception then
957: if hr_multi_message.exception_add
958: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
959: ) then
960: hr_utility.set_location(' Leaving:'|| v_proc,70);
961: raise;
962: end if;
963: hr_utility.set_location(' Leaving:'|| v_proc,80);
964: End check_if_tav_exists;

Line 963: hr_utility.set_location(' Leaving:'|| v_proc,80);

959: ) then
960: hr_utility.set_location(' Leaving:'|| v_proc,70);
961: raise;
962: end if;
963: hr_utility.set_location(' Leaving:'|| v_proc,80);
964: End check_if_tav_exists;
965: --
966: -- ----------------------------------------------------------------------------
967: -- |-------------------------< check_if_tsp_exists >--------------------------|

Line 984: hr_utility.set_location('Entering:'|| v_proc, 5);

980: v_proc varchar2(72) := g_package||'check_if_tsp_exists';
981: --
982: Begin
983: --
984: hr_utility.set_location('Entering:'|| v_proc, 5);
985: --
986: ota_tav_api_business_rules.check_if_tsp_exists( p_activity_version_id );
987: --
988: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 988: hr_utility.set_location(' Leaving:'|| v_proc, 10);

984: hr_utility.set_location('Entering:'|| v_proc, 5);
985: --
986: ota_tav_api_business_rules.check_if_tsp_exists( p_activity_version_id );
987: --
988: hr_utility.set_location(' Leaving:'|| v_proc, 10);
989: --
990: exception
991: when app_exception.application_exception then
992: if hr_multi_message.exception_add

Line 995: hr_utility.set_location(' Leaving:'|| v_proc,70);

991: when app_exception.application_exception then
992: if hr_multi_message.exception_add
993: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
994: ) then
995: hr_utility.set_location(' Leaving:'|| v_proc,70);
996: raise;
997: end if;
998: hr_utility.set_location(' Leaving:'|| v_proc,80);
999: End check_if_tsp_exists;

Line 998: hr_utility.set_location(' Leaving:'|| v_proc,80);

994: ) then
995: hr_utility.set_location(' Leaving:'|| v_proc,70);
996: raise;
997: end if;
998: hr_utility.set_location(' Leaving:'|| v_proc,80);
999: End check_if_tsp_exists;
1000: --
1001:
1002: --

Line 1020: hr_utility.set_location('Entering:'|| v_proc, 5);

1016: v_proc varchar2(72) := g_package||'check_duration_units';
1017: --
1018: Begin
1019: --
1020: hr_utility.set_location('Entering:'|| v_proc, 5);
1021: --
1022: ota_tav_api_business_rules.check_duration_units( p_duration_units );
1023: --
1024: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 1024: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1020: hr_utility.set_location('Entering:'|| v_proc, 5);
1021: --
1022: ota_tav_api_business_rules.check_duration_units( p_duration_units );
1023: --
1024: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1025: --
1026: exception
1027: when app_exception.application_exception then
1028: if hr_multi_message.exception_add

Line 1031: hr_utility.set_location(' Leaving:'|| v_proc,70);

1027: when app_exception.application_exception then
1028: if hr_multi_message.exception_add
1029: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.DURATION_UNITS'
1030: ) then
1031: hr_utility.set_location(' Leaving:'|| v_proc,70);
1032: raise;
1033: end if;
1034: hr_utility.set_location(' Leaving:'|| v_proc,80);
1035: End check_duration_units;

Line 1034: hr_utility.set_location(' Leaving:'|| v_proc,80);

1030: ) then
1031: hr_utility.set_location(' Leaving:'|| v_proc,70);
1032: raise;
1033: end if;
1034: hr_utility.set_location(' Leaving:'|| v_proc,80);
1035: End check_duration_units;
1036: --
1037: -- ----------------------------------------------------------------------------
1038: -- |--------------------------< check_duration >------------------------------|

Line 1054: hr_utility.set_location('Entering:'|| v_proc, 5);

1050: v_proc varchar2(72) := g_package||'check_duration';
1051: --
1052: Begin
1053: --
1054: hr_utility.set_location('Entering:'|| v_proc, 5);
1055: --
1056: ota_tav_api_business_rules.check_duration( p_duration );
1057: --
1058: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 1058: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1054: hr_utility.set_location('Entering:'|| v_proc, 5);
1055: --
1056: ota_tav_api_business_rules.check_duration( p_duration );
1057: --
1058: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1059: --
1060: exception
1061: when app_exception.application_exception then
1062: if hr_multi_message.exception_add

Line 1065: hr_utility.set_location(' Leaving:'|| v_proc,70);

1061: when app_exception.application_exception then
1062: if hr_multi_message.exception_add
1063: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.DURATION'
1064: ) then
1065: hr_utility.set_location(' Leaving:'|| v_proc,70);
1066: raise;
1067: end if;
1068: hr_utility.set_location(' Leaving:'|| v_proc,80);
1069: End check_duration;

Line 1068: hr_utility.set_location(' Leaving:'|| v_proc,80);

1064: ) then
1065: hr_utility.set_location(' Leaving:'|| v_proc,70);
1066: raise;
1067: end if;
1068: hr_utility.set_location(' Leaving:'|| v_proc,80);
1069: End check_duration;
1070: -- ----------------------------------------------------------------------------
1071: -- |---------------------------< check_dur_unit_comb >-----------------------------|
1072: -- ----------------------------------------------------------------------------

Line 1097: --hr_utility.set_location(' Leaving:'||v_proc, 22);

1093: p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.DURATION'
1094: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.DURATION_UNITS')
1095: THEN
1096:
1097: --hr_utility.set_location(' Leaving:'||v_proc, 22);
1098: RAISE;
1099:
1100: END IF;
1101: end check_dur_unit_comb;

Line 1120: hr_utility.set_location('Entering:'|| v_proc, 5);

1116: v_proc varchar2(72) := g_package||'check_language';
1117: --
1118: Begin
1119: --
1120: hr_utility.set_location('Entering:'|| v_proc, 5);
1121: --
1122: ota_tav_api_business_rules.check_language( p_language_id );
1123: --
1124: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 1124: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1120: hr_utility.set_location('Entering:'|| v_proc, 5);
1121: --
1122: ota_tav_api_business_rules.check_language( p_language_id );
1123: --
1124: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1125: --
1126: exception
1127: when app_exception.application_exception then
1128: if hr_multi_message.exception_add

Line 1131: hr_utility.set_location(' Leaving:'|| v_proc,70);

1127: when app_exception.application_exception then
1128: if hr_multi_message.exception_add
1129: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.LANGUAGE_ID'
1130: ) then
1131: hr_utility.set_location(' Leaving:'|| v_proc,70);
1132: raise;
1133: end if;
1134: hr_utility.set_location(' Leaving:'|| v_proc,80);
1135: End check_language;

Line 1134: hr_utility.set_location(' Leaving:'|| v_proc,80);

1130: ) then
1131: hr_utility.set_location(' Leaving:'|| v_proc,70);
1132: raise;
1133: end if;
1134: hr_utility.set_location(' Leaving:'|| v_proc,80);
1135: End check_language;
1136: --
1137: -- ----------------------------------------------------------------------------
1138: -- |-------------------< check_controlling_person >---------------------------|

Line 1156: hr_utility.set_location('Entering:'|| v_proc, 5);

1152: v_proc varchar2(72) := g_package||'check_controlling_person';
1153: --
1154: Begin
1155: --
1156: hr_utility.set_location('Entering:'|| v_proc, 5);
1157: --
1158: ota_tav_api_business_rules.check_controlling_person( p_person_id
1159: , p_date );
1160: --

Line 1161: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1157: --
1158: ota_tav_api_business_rules.check_controlling_person( p_person_id
1159: , p_date );
1160: --
1161: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1162: --
1163: exception
1164: when app_exception.application_exception then
1165: if hr_multi_message.exception_add

Line 1168: hr_utility.set_location(' Leaving:'|| v_proc,70);

1164: when app_exception.application_exception then
1165: if hr_multi_message.exception_add
1166: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.CONTROLLING_PERSON_ID'
1167: ) then
1168: hr_utility.set_location(' Leaving:'|| v_proc,70);
1169: raise;
1170: end if;
1171: hr_utility.set_location(' Leaving:'|| v_proc,80);
1172: End check_controlling_person;

Line 1171: hr_utility.set_location(' Leaving:'|| v_proc,80);

1167: ) then
1168: hr_utility.set_location(' Leaving:'|| v_proc,70);
1169: raise;
1170: end if;
1171: hr_utility.set_location(' Leaving:'|| v_proc,80);
1172: End check_controlling_person;
1173: --
1174: -- ----------------------------------------------------------------------------
1175: -- |-------------------< check_multiple_con_version >-----------------------|

Line 1196: hr_utility.set_location('Entering:'|| v_proc, 5);

1192: v_proc varchar2(72) := g_package||'check_multiple_con_versions';
1193: --
1194: Begin
1195: --
1196: hr_utility.set_location('Entering:'|| v_proc, 5);
1197: --
1198: ota_tav_api_business_rules.check_multiple_con_version
1199: ( p_activity_id
1200: , p_activity_version_id

Line 1204: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1200: , p_activity_version_id
1201: , p_start_date
1202: , p_end_date);
1203: --
1204: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1205: --
1206: exception
1207: when app_exception.application_exception then
1208: if hr_multi_message.exception_add

Line 1213: hr_utility.set_location(' Leaving:'|| v_proc,70);

1209: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
1210: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1211: ,p_associated_column3 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1212: ) then
1213: hr_utility.set_location(' Leaving:'|| v_proc,70);
1214: raise;
1215: end if;
1216: hr_utility.set_location(' Leaving:'|| v_proc,80);
1217: End check_multiple_con_version;

Line 1216: hr_utility.set_location(' Leaving:'|| v_proc,80);

1212: ) then
1213: hr_utility.set_location(' Leaving:'|| v_proc,70);
1214: raise;
1215: end if;
1216: hr_utility.set_location(' Leaving:'|| v_proc,80);
1217: End check_multiple_con_version;
1218: --
1219: -- ----------------------------------------------------------------------------
1220: -- |------------------< check_version_after_supersede >-----------------------|

Line 1240: hr_utility.set_location('Entering:'|| v_proc, 5);

1236: v_proc varchar2(72) := g_package||'check_version_after_supersede';
1237: --
1238: Begin
1239: --
1240: hr_utility.set_location('Entering:'|| v_proc, 5);
1241: --
1242: ota_tav_api_business_rules.check_version_after_supersede( p_activity_id );
1243: --
1244: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 1244: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1240: hr_utility.set_location('Entering:'|| v_proc, 5);
1241: --
1242: ota_tav_api_business_rules.check_version_after_supersede( p_activity_id );
1243: --
1244: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1245: --
1246: exception
1247: when app_exception.application_exception then
1248: if hr_multi_message.exception_add

Line 1251: hr_utility.set_location(' Leaving:'|| v_proc,70);

1247: when app_exception.application_exception then
1248: if hr_multi_message.exception_add
1249: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_ID'
1250: ) then
1251: hr_utility.set_location(' Leaving:'|| v_proc,70);
1252: raise;
1253: end if;
1254: hr_utility.set_location(' Leaving:'|| v_proc,80);
1255: End check_version_after_supersede;

Line 1254: hr_utility.set_location(' Leaving:'|| v_proc,80);

1250: ) then
1251: hr_utility.set_location(' Leaving:'|| v_proc,70);
1252: raise;
1253: end if;
1254: hr_utility.set_location(' Leaving:'|| v_proc,80);
1255: End check_version_after_supersede;
1256:
1257: --
1258: -- ----------------------------------------------------------------------------

Line 1289: hr_utility.set_location('Entering:'||l_proc, 5);

1285: , p_end_date );
1286:
1287: Begin
1288:
1289: hr_utility.set_location('Entering:'||l_proc, 5);
1290: ota_tav_api_business_rules.check_course_lp_dates( p_activity_version_id, p_start_date, p_end_date );
1291:
1292: exception
1293: when app_exception.application_exception then

Line 1297: hr_utility.set_location(' Leaving:'|| l_proc,70);

1293: when app_exception.application_exception then
1294: if l_start_date_changed AND hr_multi_message.exception_add
1295: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1296: ) then
1297: hr_utility.set_location(' Leaving:'|| l_proc,70);
1298: raise;
1299: elsif l_end_date_changed AND hr_multi_message.exception_add
1300: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1301: ) then

Line 1302: hr_utility.set_location(' Leaving:'|| l_proc,80);

1298: raise;
1299: elsif l_end_date_changed AND hr_multi_message.exception_add
1300: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1301: ) then
1302: hr_utility.set_location(' Leaving:'|| l_proc,80);
1303: raise;
1304: end if;
1305: hr_utility.set_location(' Leaving:'|| l_proc,90);
1306: hr_utility.set_location('Leaving:'||l_proc, 30);

Line 1305: hr_utility.set_location(' Leaving:'|| l_proc,90);

1301: ) then
1302: hr_utility.set_location(' Leaving:'|| l_proc,80);
1303: raise;
1304: end if;
1305: hr_utility.set_location(' Leaving:'|| l_proc,90);
1306: hr_utility.set_location('Leaving:'||l_proc, 30);
1307: End;
1308:
1309: --

Line 1306: hr_utility.set_location('Leaving:'||l_proc, 30);

1302: hr_utility.set_location(' Leaving:'|| l_proc,80);
1303: raise;
1304: end if;
1305: hr_utility.set_location(' Leaving:'|| l_proc,90);
1306: hr_utility.set_location('Leaving:'||l_proc, 30);
1307: End;
1308:
1309: --
1310: -- ----------------------------------------------------------------------------

Line 1341: hr_utility.set_location('Entering:'||l_proc, 5);

1337: , p_end_date );
1338:
1339: Begin
1340:
1341: hr_utility.set_location('Entering:'||l_proc, 5);
1342: ota_tav_api_business_rules.check_course_crt_dates( p_activity_version_id, p_start_date, p_end_date );
1343:
1344: exception
1345: when app_exception.application_exception then

Line 1349: hr_utility.set_location(' Leaving:'|| l_proc,70);

1345: when app_exception.application_exception then
1346: if l_start_date_changed AND hr_multi_message.exception_add
1347: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1348: ) then
1349: hr_utility.set_location(' Leaving:'|| l_proc,70);
1350: raise;
1351: elsif l_end_date_changed AND hr_multi_message.exception_add
1352: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1353: ) then

Line 1354: hr_utility.set_location(' Leaving:'|| l_proc,80);

1350: raise;
1351: elsif l_end_date_changed AND hr_multi_message.exception_add
1352: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1353: ) then
1354: hr_utility.set_location(' Leaving:'|| l_proc,80);
1355: raise;
1356: end if;
1357: hr_utility.set_location(' Leaving:'|| l_proc,90);
1358: hr_utility.set_location('Leaving:'||l_proc, 30);

Line 1357: hr_utility.set_location(' Leaving:'|| l_proc,90);

1353: ) then
1354: hr_utility.set_location(' Leaving:'|| l_proc,80);
1355: raise;
1356: end if;
1357: hr_utility.set_location(' Leaving:'|| l_proc,90);
1358: hr_utility.set_location('Leaving:'||l_proc, 30);
1359: End check_course_crt_dates;
1360:
1361: --

Line 1358: hr_utility.set_location('Leaving:'||l_proc, 30);

1354: hr_utility.set_location(' Leaving:'|| l_proc,80);
1355: raise;
1356: end if;
1357: hr_utility.set_location(' Leaving:'|| l_proc,90);
1358: hr_utility.set_location('Leaving:'||l_proc, 30);
1359: End check_course_crt_dates;
1360:
1361: --
1362: -- ----------------------------------------------------------------------------

Line 1392: hr_utility.set_location(' Entering:'||l_proc, 10);

1388: and oad.activity_id=p_activity_id;
1389:
1390:
1391: BEGIN
1392: hr_utility.set_location(' Entering:'||l_proc, 10);
1393: --
1394: OPEN csr_is_root_category;
1395: FETCH csr_is_root_category into l_parent_cat_usage_id;
1396: CLOSE csr_is_root_category;

Line 1404: hr_utility.set_location(' Leaving:'||l_proc, 20);

1400: IF l_parent_cat_usage_id IS NULL THEN
1401: fnd_message.set_name('OTA','OTA_443361_COURSE_IN_ROOT_CAT');
1402: fnd_message.raise_error;
1403: END IF;
1404: hr_utility.set_location(' Leaving:'||l_proc, 20);
1405:
1406: EXCEPTION
1407:
1408: WHEN app_exception.application_exception THEN

Line 1413: hr_utility.set_location(' Leaving:'||l_proc, 30);

1409:
1410: IF hr_multi_message.exception_add
1411: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.COMPETENCY_UPDATE_LEVEL') THEN
1412:
1413: hr_utility.set_location(' Leaving:'||l_proc, 30);
1414: RAISE;
1415: END IF;
1416:
1417: hr_utility.set_location(' Leaving:'||l_proc, 40);

Line 1417: hr_utility.set_location(' Leaving:'||l_proc, 40);

1413: hr_utility.set_location(' Leaving:'||l_proc, 30);
1414: RAISE;
1415: END IF;
1416:
1417: hr_utility.set_location(' Leaving:'||l_proc, 40);
1418:
1419: END chk_category;
1420:
1421:

Line 1430: hr_utility.set_location('Entering:'||l_proc, 5);

1426: --
1427: l_proc varchar2(72) := g_package||'insert_validate';
1428: --
1429: Begin
1430: hr_utility.set_location('Entering:'||l_proc, 5);
1431: --
1432: -- Validate Important Attributes
1433: --
1434: if p_rec.business_group_id is not null then

Line 1527: hr_utility.set_location(' Leaving:'||l_proc, 10);

1523: --
1524: ota_tav_bus.chk_ddf(p_rec);
1525:
1526: chk_category(p_rec.activity_id);
1527: hr_utility.set_location(' Leaving:'||l_proc, 10);
1528: End insert_validate;
1529: --
1530: -- ----------------------------------------------------------------------------
1531: -- |---------------------------< update_validate >----------------------------|

Line 1632: hr_utility.set_location('Entering:'||l_proc, 5);

1628: , p_rec.rco_id);
1629:
1630: --
1631: Begin
1632: hr_utility.set_location('Entering:'||l_proc, 5);
1633: --
1634: -- Validate Important Attributes
1635: --
1636: if p_rec.business_group_id is not null then

Line 1844: hr_utility.set_location(' Leaving:'||l_proc, 10);

1840:
1841: end if;
1842:
1843: ota_tav_bus.chk_ddf(p_rec);
1844: hr_utility.set_location(' Leaving:'||l_proc, 10);
1845: End update_validate;
1846: --
1847: -- ----------------------------------------------------------------------------
1848: -- |---------------------------< delete_validate >----------------------------|

Line 1855: hr_utility.set_location('Entering:'||l_proc, 5);

1851: --
1852: l_proc varchar2(72) := g_package||'delete_validate';
1853: --
1854: Begin
1855: hr_utility.set_location('Entering:'||l_proc, 5);
1856: --
1857: -- Call all supporting business operations
1858: --
1859: check_if_tpm_exists( p_rec.activity_version_id );

Line 1875: hr_utility.set_location(' Leaving:'||l_proc, 10);

1871: check_if_noth_exists( p_rec.activity_version_id );
1872:
1873: check_if_crt_exists(p_rec.activity_version_id);
1874: --
1875: hr_utility.set_location(' Leaving:'||l_proc, 10);
1876: End delete_validate;
1877: --
1878: --
1879: -- ----------------------------------------------------------------------------

Line 1906: hr_utility.set_location('Entering:'||l_proc, 5);

1902: l_proc varchar2(72) := g_package||'return_legislation_code';
1903: l_legislation_code varchar2(150);
1904: --
1905: Begin
1906: hr_utility.set_location('Entering:'||l_proc, 5);
1907: --
1908: -- Ensure that all the mandatory parameters are not null
1909: --
1910: hr_api.mandatory_arg_error (p_api_name => l_proc,

Line 1920: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

1916: close csr_leg_code;
1917: --
1918: -- The primary key is invalid therefore we must error out
1919: --
1920: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1921: hr_utility.raise_error;
1922: end if;
1923: --
1924: close csr_leg_code;

Line 1921: hr_utility.raise_error;

1917: --
1918: -- The primary key is invalid therefore we must error out
1919: --
1920: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1921: hr_utility.raise_error;
1922: end if;
1923: --
1924: close csr_leg_code;
1925: return l_legislation_code;

Line 1927: hr_utility.set_location(' Leaving:'||l_proc, 10);

1923: --
1924: close csr_leg_code;
1925: return l_legislation_code;
1926: --
1927: hr_utility.set_location(' Leaving:'||l_proc, 10);
1928: --
1929: End return_legislation_code;
1930:
1931: -- ----------------------------------------------------------------------------

Line 1951: hr_utility.set_location('Entering:'|| v_proc, 5);

1947: v_proc varchar2(72) := g_package||'check_if_noth_exists';
1948: --
1949: Begin
1950: --
1951: hr_utility.set_location('Entering:'|| v_proc, 5);
1952: --
1953: ota_tav_api_business_rules.check_if_noth_exists( p_activity_version_id );
1954: --
1955: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 1955: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1951: hr_utility.set_location('Entering:'|| v_proc, 5);
1952: --
1953: ota_tav_api_business_rules.check_if_noth_exists( p_activity_version_id );
1954: --
1955: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1956: --
1957: exception
1958: when app_exception.application_exception then
1959: if hr_multi_message.exception_add

Line 1962: hr_utility.set_location(' Leaving:'|| v_proc,70);

1958: when app_exception.application_exception then
1959: if hr_multi_message.exception_add
1960: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
1961: ) then
1962: hr_utility.set_location(' Leaving:'|| v_proc,70);
1963: raise;
1964: end if;
1965: hr_utility.set_location(' Leaving:'|| v_proc,80);
1966: end check_if_noth_exists;

Line 1965: hr_utility.set_location(' Leaving:'|| v_proc,80);

1961: ) then
1962: hr_utility.set_location(' Leaving:'|| v_proc,70);
1963: raise;
1964: end if;
1965: hr_utility.set_location(' Leaving:'|| v_proc,80);
1966: end check_if_noth_exists;
1967:
1968: -- ----------------------------------------------------------------------------
1969: -- |-------------------------< check_if_crt_exists >--------------------------|

Line 1988: hr_utility.set_location('Entering:'|| v_proc, 5);

1984: v_proc varchar2(72) := g_package||'check_if_crt_exists';
1985: --
1986: Begin
1987: --
1988: hr_utility.set_location('Entering:'|| v_proc, 5);
1989: --
1990: ota_tav_api_business_rules.check_if_crt_exists( p_activity_version_id );
1991: --
1992: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 1992: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1988: hr_utility.set_location('Entering:'|| v_proc, 5);
1989: --
1990: ota_tav_api_business_rules.check_if_crt_exists( p_activity_version_id );
1991: --
1992: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1993: --
1994: exception
1995: when app_exception.application_exception then
1996: if hr_multi_message.exception_add

Line 1999: hr_utility.set_location(' Leaving:'|| v_proc,70);

1995: when app_exception.application_exception then
1996: if hr_multi_message.exception_add
1997: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
1998: ) then
1999: hr_utility.set_location(' Leaving:'|| v_proc,70);
2000: raise;
2001: end if;
2002: hr_utility.set_location(' Leaving:'|| v_proc,80);
2003: end check_if_crt_exists;

Line 2002: hr_utility.set_location(' Leaving:'|| v_proc,80);

1998: ) then
1999: hr_utility.set_location(' Leaving:'|| v_proc,70);
2000: raise;
2001: end if;
2002: hr_utility.set_location(' Leaving:'|| v_proc,80);
2003: end check_if_crt_exists;
2004: --
2005: end ota_tav_bus;