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_LPC_BUS dependencies on HR_UTILITY

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

40: l_legislation_code varchar2(150);
41: --
42: begin
43: --
44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Ensure that all the mandatory parameter are not null
47: --
48: hr_api.mandatory_arg_error

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

80: --
81: hr_api.set_legislation_context(l_legislation_code);
82: end if;
83: --
84: hr_utility.set_location(' Leaving:'|| l_proc, 20);
85: --
86: end set_security_group_id;
87: --
88: -- ---------------------------------------------------------------------------

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

109: l_proc varchar2(72) := g_package||'return_legislation_code';
110: --
111: Begin
112: --
113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: --
115: -- Ensure that all the mandatory parameter are not null
116: --
117: hr_api.mandatory_arg_error

Line 131: hr_utility.set_location(l_proc, 20);

127: -- call to this function. Just return the value in the global
128: -- variable.
129: --
130: l_legislation_code := ota_lpc_bus.g_legislation_code;
131: hr_utility.set_location(l_proc, 20);
132: else
133: --
134: -- The ID is different to the last call to this function
135: -- or this is the first call to this function.

Line 148: hr_utility.set_location(l_proc,30);

144: close csr_leg_code;
145: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
146: fnd_message.raise_error;
147: end if;
148: hr_utility.set_location(l_proc,30);
149: --
150: -- Set the global variables so the values are
151: -- available for the next call to this function.
152: --

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

153: close csr_leg_code;
154: ota_lpc_bus.g_learning_path_section_id := p_learning_path_section_id;
155: ota_lpc_bus.g_legislation_code := l_legislation_code;
156: end if;
157: hr_utility.set_location(' Leaving:'|| l_proc, 40);
158: return l_legislation_code;
159: end return_legislation_code;
160: --
161: -- ----------------------------------------------------------------------------

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

192: --
193: l_proc varchar2(72) := g_package || 'chk_df';
194: --
195: begin
196: hr_utility.set_location('Entering:'||l_proc,10);
197: --
198: if ((p_rec.learning_path_section_id is not null) and (
199: nvl(ota_lpc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

291: ,p_attribute20_value => p_rec.attribute20
292: );
293: end if;
294: --
295: hr_utility.set_location(' Leaving:'||l_proc,20);
296: end chk_df;
297: --
298: -- ----------------------------------------------------------------------------
299: -- |-----------------------< chk_non_updateable_args >------------------------|

Line 359: -- hr_utility.

355: -- ----------------------------------------------------------------------------
356: --
357: -- Description:
358: -- Passes the error information to the procedure set_message of package
359: -- hr_utility.
360: --
361: Procedure call_error_message
362: (
363: p_error_appl varchar2

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

367: v_proc varchar2(72) := g_package||'call_error_message';
368: --
369: Begin
370: --
371: hr_utility.set_location('Entering:'|| v_proc, 5);
372: --
373: -- ** TEMP ** Add error message with the following text.
374: --
375: fnd_message.set_name ( p_error_appl ,p_error_txt);

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

374: --
375: fnd_message.set_name ( p_error_appl ,p_error_txt);
376: fnd_message.raise_error;
377: --
378: hr_utility.set_location(' Leaving:'|| v_proc, 10);
379: --
380: End call_error_message;
381: --
382: --

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

414: AND p_learning_path_section_id <> lps.learning_path_section_id)) ;
415: --
416: Begin
417: --
418: hr_utility.set_location('Entering:'|| v_proc, 5);
419: --
420: IF p_learning_path_id IS NULL THEN
421: OPEN get_lp_id;
422: FETCH get_lp_id INTO l_lp_id;

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

439:
440:
441: END IF;
442:
443: hr_utility.set_location(' Leaving:'|| v_proc, 10);
444: --
445: EXCEPTION
446: WHEN app_exception.application_exception THEN
447:

Line 451: hr_utility.set_location(' Leaving:'||v_proc, 92);

447:
448: IF hr_multi_message.exception_add
449: (p_associated_column1 => 'OTA_LP_SECTIONS.COMPLETION_TYPE_CODE') THEN
450:
451: hr_utility.set_location(' Leaving:'||v_proc, 92);
452: RAISE;
453:
454: END IF;
455:

Line 456: hr_utility.set_location(' Leaving:'||v_proc, 94);

452: RAISE;
453:
454: END IF;
455:
456: hr_utility.set_location(' Leaving:'||v_proc, 94);
457:
458: End chk_completion_type_valid;
459: --
460: --

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

482: where lme.learning_path_section_id = p_learning_path_section_id;
483: --
484: Begin
485: --
486: hr_utility.set_location('Entering:'|| v_proc, 5);
487: --
488: Open sel_lme_exists;
489: fetch sel_lme_exists into v_exists;
490: --

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

501:
502: end if;
503: --
504: --
505: hr_utility.set_location(' Leaving:'|| v_proc, 10);
506: --
507: End chk_if_lme_exists;
508: --
509: -- ----------------------------------------------------------------------------

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

534: WHERE learning_path_id = l_lp_id;
535: --
536: Begin
537: --
538: hr_utility.set_location('Entering:'|| v_proc, 5);
539: --
540: Open get_lp_id;
541: Fetch get_lp_id INTO l_lp_id;
542: Close get_lp_id;

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

551: l_return := FALSE;
552:
553: END IF;
554:
555: hr_utility.set_location(' Leaving:'|| v_proc, 10);
556: --
557: RETURN l_return;
558:
559: End is_last_section;

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

580: where lps.learning_path_id = p_learning_path_id;
581: --
582: Begin
583: --
584: hr_utility.set_location('Entering:'|| v_proc, 5);
585: --
586: Open csr_is_catalog_lp;
587: fetch csr_is_catalog_lp into v_path_source_code;
588: close csr_is_catalog_lp;

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

589: --
590: IF v_path_source_code = 'CATALOG' THEN
591: l_return := TRUE;
592: END IF;
593: hr_utility.set_location(' Leaving:'|| v_proc, 10);
594: --
595: RETURN l_return;
596:
597: End is_catalog_lp;

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

620: where lps.learning_path_id = p_learning_path_id;
621: --
622: Begin
623: --
624: hr_utility.set_location('Entering:'|| v_proc, 5);
625: --
626: Open csr_is_catalog_lp;
627: fetch csr_is_catalog_lp into v_path_source_code;
628: close csr_is_catalog_lp;

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

636: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
637:
638: END IF;
639:
640: hr_utility.set_location(' Leaving:'|| v_proc, 10);
641: --
642: End disable_section_dff;
643: --
644: /* commented for Bug 4149025

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

666: where lpm.learning_path_section_id = p_learning_path_section_id;
667: --
668: Begin
669: --
670: hr_utility.set_location('Entering:'|| v_proc, 5);
671: --Added for Bug#3861877
672: IF NOT p_no_of_mandatory_courses > 0 THEN
673: fnd_message.set_name('OTA','OTA_443368_POSITIVE_NUMBER');
674: fnd_message.raise_error;

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

689: close sel_lpm_count;
690: END IF;
691:
692: --
693: hr_utility.set_location(' Leaving:'|| v_proc, 10);
694: --
695: EXCEPTION
696: WHEN app_exception.application_exception THEN
697:

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

697:
698: IF hr_multi_message.exception_add
699: (p_associated_column1 => 'OTA_LP_SECTIONS.NO_OF_MANDATORY_COURSES') THEN
700:
701: hr_utility.set_location(' Leaving:'||v_proc, 92);
702: RAISE;
703:
704: END IF;
705:

Line 706: hr_utility.set_location(' Leaving:'||v_proc, 94);

702: RAISE;
703:
704: END IF;
705:
706: hr_utility.set_location(' Leaving:'||v_proc, 94);
707:
708: End chk_no_of_mandatory_courses;
709: --
710: */

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

718: --
719: l_proc varchar2(72) := g_package||'insert_validate';
720: --
721: Begin
722: hr_utility.set_location('Entering:'||l_proc, 5);
723: --
724: -- Call all supporting business operations
725: --
726: hr_api.validate_bus_grp_id

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

748: IF is_catalog_lp(p_rec.learning_path_id) THEN
749: ota_lpc_bus.chk_df(p_rec);
750: END IF;
751: --
752: hr_utility.set_location(' Leaving:'||l_proc, 10);
753: End insert_validate;
754: --
755: -- ----------------------------------------------------------------------------
756: -- |---------------------------< update_validate >----------------------------|

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

770: := ota_general.value_changed(ota_lpc_shd.g_old_rec.no_of_mandatory_courses,
771: p_rec.no_of_mandatory_courses);
772:
773: Begin
774: hr_utility.set_location('Entering:'||l_proc, 5);
775: --
776: -- Call all supporting business operations
777: --
778: hr_api.validate_bus_grp_id

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

819: IF is_catalog_lp(p_rec.learning_path_id) THEN
820: ota_lpc_bus.chk_df(p_rec);
821: END IF;
822: --
823: hr_utility.set_location(' Leaving:'||l_proc, 10);
824: End update_validate;
825: --
826: -- ----------------------------------------------------------------------------
827: -- |---------------------------< delete_validate >----------------------------|

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

832: --
833: l_proc varchar2(72) := g_package||'delete_validate';
834: --
835: Begin
836: hr_utility.set_location('Entering:'||l_proc, 5);
837: --
838: -- Call all supporting business operations
839: --
840: chk_if_lme_exists(p_rec.learning_path_section_id);

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

841: IF NOT is_last_section(p_rec.learning_path_section_id) THEN
842: chk_completion_type_valid(p_learning_path_section_id => p_rec.learning_path_section_id,
843: p_learning_path_id => p_rec.learning_path_id);
844: END IF;
845: hr_utility.set_location(' Leaving:'||l_proc, 10);
846: End delete_validate;
847: --
848:
849: end ota_lpc_bus;