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

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

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

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

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

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

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

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

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

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

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

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

152: close csr_leg_code;
153: ota_cpe_bus.g_cert_prd_enrollment_id := p_cert_prd_enrollment_id;
154: ota_cpe_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: -- ----------------------------------------------------------------------------

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

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

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

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

Line 367: hr_utility.set_location(' Step:'|| l_proc, 10);

363: BEGIN
364: --
365: -- check mandatory parameters have been set
366: --
367: hr_utility.set_location(' Step:'|| l_proc, 10);
368: hr_api.mandatory_arg_error
369: (p_api_name => l_proc
370: ,p_argument => 'p_period_status_code'
371: ,p_argument_value => p_period_status_code

Line 374: hr_utility.set_location(' Step:'|| l_proc, 20);

370: ,p_argument => 'p_period_status_code'
371: ,p_argument_value => p_period_status_code
372: );
373: --
374: hr_utility.set_location(' Step:'|| l_proc, 20);
375: IF hr_api.not_exists_in_hr_lookups
376: (p_effective_date => p_effective_date
377: ,p_lookup_type => 'OTA_CERT_PRD_ENROLL_STATUS'
378: ,p_lookup_code => p_period_status_code

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

381: fnd_message.set_name('OTA', 'OTA_443667_CPE_STAT_INVALID');
382: fnd_message.raise_error;
383: END IF;
384: --
385: hr_utility.set_location(' Leaving:'||l_proc, 30);
386:
387: --MULTI MESSAGE SUPPORT
388: EXCEPTION
389: WHEN app_exception.application_exception THEN

Line 392: hr_utility.set_location(' Leaving:'||l_proc, 32);

388: EXCEPTION
389: WHEN app_exception.application_exception THEN
390: IF hr_multi_message.exception_add(
391: p_associated_column1 => 'OTA_CERT_PRD_ENROLLMENTS.period_status_code') THEN
392: hr_utility.set_location(' Leaving:'||l_proc, 32);
393: RAISE;
394:
395: END IF;
396: hr_utility.set_location(' Leaving:'||l_proc, 35);

Line 396: hr_utility.set_location(' Leaving:'||l_proc, 35);

392: hr_utility.set_location(' Leaving:'||l_proc, 32);
393: RAISE;
394:
395: END IF;
396: hr_utility.set_location(' Leaving:'||l_proc, 35);
397:
398: END chk_period_status_code;
399: --
400: -- ----------------------------------------------------------------------------

Line 427: hr_utility.set_location(' Step:'|| l_proc, 10);

423: BEGIN
424: --
425: -- check mandatory parameters have been set
426: --
427: hr_utility.set_location(' Step:'|| l_proc, 10);
428: hr_api.mandatory_arg_error
429: (p_api_name => l_proc
430: ,p_argument => 'p_cert_enrollment_id'
431: ,p_argument_value => p_cert_enrollment_id

Line 440: hr_utility.set_location(' Step:'|| l_proc, 20);

436: FETCH csr_cert_mbr INTO l_CERTIFICATION_MEMBER_ID;
437: close csr_cert_mbr;
438:
439: if l_CERTIFICATION_MEMBER_ID is null then
440: hr_utility.set_location(' Step:'|| l_proc, 20);
441: fnd_message.set_name('OTA', 'OTA_443926_CME_NO_CURR_CRT_MBR');
442: fnd_message.raise_error;
443: END IF;
444:

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

441: fnd_message.set_name('OTA', 'OTA_443926_CME_NO_CURR_CRT_MBR');
442: fnd_message.raise_error;
443: END IF;
444:
445: hr_utility.set_location(' Leaving:'||l_proc, 20);
446:
447: END check_active_cert_members;
448:
449: -- ----------------------------------------------------------------------------

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

456: --
457: l_proc varchar2(72) := g_package||'insert_validate';
458: --
459: Begin
460: hr_utility.set_location('Entering:'||l_proc, 5);
461: --
462: -- Call all supporting business operations
463: --
464: -- Validate Important Attributes

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

482: check_active_cert_members(p_rec.cert_enrollment_id);
483: --
484: ota_cpe_bus.chk_df(p_rec);
485: --
486: hr_utility.set_location(' Leaving:'||l_proc, 10);
487: End insert_validate;
488: --
489: -- ----------------------------------------------------------------------------
490: -- |---------------------------< update_validate >----------------------------|

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

496: --
497: l_proc varchar2(72) := g_package||'update_validate';
498: --
499: Begin
500: hr_utility.set_location('Entering:'||l_proc, 5);
501: --
502: -- Call all supporting business operations
503: --
504: -- Validate Important Attributes

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

524: p_period_status_code => p_rec.period_status_code);
525: --
526: ota_cpe_bus.chk_df(p_rec);
527: --
528: hr_utility.set_location(' Leaving:'||l_proc, 10);
529: End update_validate;
530: --
531: -- ----------------------------------------------------------------------------
532: -- |---------------------------< delete_validate >----------------------------|

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

537: --
538: l_proc varchar2(72) := g_package||'delete_validate';
539: --
540: Begin
541: hr_utility.set_location('Entering:'||l_proc, 5);
542: --
543: -- Call all supporting business operations
544: --
545: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

541: hr_utility.set_location('Entering:'||l_proc, 5);
542: --
543: -- Call all supporting business operations
544: --
545: hr_utility.set_location(' Leaving:'||l_proc, 10);
546: End delete_validate;
547: --
548: end ota_cpe_bus;