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.PER_GRS_BUS dependencies on HR_UTILITY

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

41: l_api_updating boolean;
42: --
43: Begin
44: --
45: hr_utility.set_location('Entering:'||l_proc, 5);
46: --
47: l_api_updating := per_grs_shd.api_updating
48: (p_cagr_grade_structure_id => p_cagr_grade_structure_id,
49: p_object_version_number => p_object_version_number,

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

70: end if;
71: --
72: end if;
73: --
74: hr_utility.set_location('Leaving:'||l_proc, 10);
75: --
76: End chk_cagr_grade_structure_id;
77: --
78: -- ----------------------------------------------------------------------------

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

119: from per_collective_agreements per
120: where per.collective_agreement_id = p_collective_agreement_id;
121: --
122: begin
123: hr_utility.set_location('Entering:'||l_proc,5);
124: --
125: -- Perform COLLECTIVE_AGREEMENT_ID mandatory check
126: --
127: hr_api.mandatory_arg_error

Line 133: hr_utility.set_location(l_proc,10);

129: ,p_argument => 'collective_agreement_id'
130: ,p_argument_value => p_collective_agreement_id
131: );
132: --
133: hr_utility.set_location(l_proc,10);
134: --
135: -- Check for valid COLLECTIVE_AGREEMENT_ID
136: --
137: open csr_valid_cagr_id;

Line 144: hr_utility.set_message(800,'PER_52816_COLLECTIVE_AGREEMENT');

140: if (csr_valid_cagr_id%notfound) then
141: --
142: close csr_valid_cagr_id;
143: --
144: hr_utility.set_message(800,'PER_52816_COLLECTIVE_AGREEMENT');
145: hr_utility.raise_error;
146: end if;
147: --
148: close csr_valid_cagr_id;

Line 145: hr_utility.raise_error;

141: --
142: close csr_valid_cagr_id;
143: --
144: hr_utility.set_message(800,'PER_52816_COLLECTIVE_AGREEMENT');
145: hr_utility.raise_error;
146: end if;
147: --
148: close csr_valid_cagr_id;
149: --

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

146: end if;
147: --
148: close csr_valid_cagr_id;
149: --
150: hr_utility.set_location('Leaving:'|| l_proc, 20);
151: end chk_collective_agreement_id;
152: --
153: -- ----------------------------------------------------------------------------
154: -- |--------------------< chk_id_flex_num >-----------------------------------|

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

194: from fnd_id_flex_structures fnd
195: where fnd.id_flex_num = p_id_flex_num;
196: --
197: begin
198: hr_utility.set_location('Entering:'||l_proc,5);
199: --
200: -- Perform id_flex_num mandatory check
201: --
202: hr_api.mandatory_arg_error

Line 208: hr_utility.set_location(l_proc,10);

204: ,p_argument => 'id_flex_num'
205: ,p_argument_value => p_id_flex_num
206: );
207: --
208: hr_utility.set_location(l_proc,10);
209: --
210: -- Check for valid ID_FLEX_NUM
211: --
212: open csr_valid_id_flex_num;

Line 219: hr_utility.set_message(800,'HR_51741_ANC_FLEX_NOT_EXIST');

215: if (csr_valid_id_flex_num%notfound) then
216: --
217: close csr_valid_id_flex_num;
218: --
219: hr_utility.set_message(800,'HR_51741_ANC_FLEX_NOT_EXIST');
220: hr_utility.raise_error;
221: end if;
222: --
223: close csr_valid_id_flex_num;

Line 220: hr_utility.raise_error;

216: --
217: close csr_valid_id_flex_num;
218: --
219: hr_utility.set_message(800,'HR_51741_ANC_FLEX_NOT_EXIST');
220: hr_utility.raise_error;
221: end if;
222: --
223: close csr_valid_id_flex_num;
224: --

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

221: end if;
222: --
223: close csr_valid_id_flex_num;
224: --
225: hr_utility.set_location('Leaving:'||l_proc, 10);
226: end chk_id_flex_num;
227: --
228: -- ----------------------------------------------------------------------------
229: -- |--------------------< chk_comb_flex_cagr >--------------------------------|

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

270: where pcg.id_flex_num = p_id_flex_num
271: and pcg.collective_agreement_id = p_collective_agreement_id;
272: --
273: begin
274: hr_utility.set_location('Entering:'||l_proc,5);
275: --
276: -- Perform id_flex_num mandatory check
277: --
278: hr_api.mandatory_arg_error

Line 284: hr_utility.set_location(l_proc,10);

280: ,p_argument => 'id_flex_num'
281: ,p_argument_value => p_id_flex_num
282: );
283: --
284: hr_utility.set_location(l_proc,10);
285: --
286: -- Perform COLLECTIVE_AGREEMENT_ID mandatory check
287: --
288: hr_api.mandatory_arg_error

Line 294: hr_utility.set_location(l_proc,15);

290: ,p_argument => 'collective_agreement_id'
291: ,p_argument_value => p_collective_agreement_id
292: );
293: --
294: hr_utility.set_location(l_proc,15);
295: --
296: -- Check for valid combinaison
297: --
298: open csr_comb_flex_cagr;

Line 305: hr_utility.set_message(800,'PER_52808_CAGR_GRADE_EXISTS');

301: if (csr_comb_flex_cagr%found) then
302: --
303: close csr_comb_flex_cagr;
304: --
305: hr_utility.set_message(800,'PER_52808_CAGR_GRADE_EXISTS');
306: hr_utility.raise_error;
307: end if;
308: --
309: close csr_comb_flex_cagr;

Line 306: hr_utility.raise_error;

302: --
303: close csr_comb_flex_cagr;
304: --
305: hr_utility.set_message(800,'PER_52808_CAGR_GRADE_EXISTS');
306: hr_utility.raise_error;
307: end if;
308: --
309: close csr_comb_flex_cagr;
310: --

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

307: end if;
308: --
309: close csr_comb_flex_cagr;
310: --
311: hr_utility.set_location('Leaving:'||l_proc, 20);
312: end chk_comb_flex_cagr;
313: --
314: -- -----------------------------------------------------------------------
315: -- |------------------------------< chk_df >-----------------------------|

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

343: --
344: l_proc varchar2(72) := g_package||'chk_df';
345: --
346: begin
347: hr_utility.set_location('Entering:'||l_proc, 10);
348: --
349: if ((p_rec.cagr_grade_structure_id is not null) and (
350: nvl(per_grs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

443: ,p_attribute20_value => p_rec.attribute20
444: );
445: end if;
446: --
447: hr_utility.set_location(' Leaving:'||l_proc, 20);
448: end chk_df;
449: --
450: -- ---------------------------------------------------------------------------
451: -- |-----------------< chk_dynamic_insert_allowed >--------------------------|

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

484: l_exists varchar2(1);
485: l_api_updating boolean;
486: --
487: begin
488: hr_utility.set_location('Entering:'|| l_proc, 10);
489: --
490: -- Check mandatory parameters have been set
491: --
492: hr_api.mandatory_arg_error

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

500: ,p_argument => 'dynamic_insert_allowed'
501: ,p_argument_value => p_dynamic_insert_allowed
502: );
503: --
504: hr_utility.set_location(l_proc, 20);
505: --
506: l_api_updating := per_grs_shd.api_updating
507: (p_cagr_grade_structure_id => p_cagr_grade_structure_id
508: ,p_object_version_number => p_object_version_number

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

508: ,p_object_version_number => p_object_version_number
509: ,p_effective_date => p_effective_date
510: );
511: --
512: hr_utility.set_location(l_proc, 30);
513: --
514: if ((l_api_updating and
515: nvl(per_grs_shd.g_old_rec.dynamic_insert_allowed, hr_api.g_varchar2)<>
516: nvl(p_dynamic_insert_allowed, hr_api.g_varchar2))

Line 519: hr_utility.set_location(l_proc, 40);

515: nvl(per_grs_shd.g_old_rec.dynamic_insert_allowed, hr_api.g_varchar2)<>
516: nvl(p_dynamic_insert_allowed, hr_api.g_varchar2))
517: or (NOT l_api_updating))
518: then
519: hr_utility.set_location(l_proc, 40);
520: --
521: --
522: -- Check that the type exists in hr_lookups for the
523: -- lookup type 'YES_NO' with an enabled flag set to 'Y'.

Line 532: hr_utility.set_message(800, 'PER_52614_GRS_INV_DYNAMIC_INS');

528: ,p_lookup_code => p_dynamic_insert_allowed
529: )
530: then
531: --
532: hr_utility.set_message(800, 'PER_52614_GRS_INV_DYNAMIC_INS');
533: hr_utility.raise_error;
534: --
535: end if;
536: --

Line 533: hr_utility.raise_error;

529: )
530: then
531: --
532: hr_utility.set_message(800, 'PER_52614_GRS_INV_DYNAMIC_INS');
533: hr_utility.raise_error;
534: --
535: end if;
536: --
537: end if;

Line 539: hr_utility.set_location(' Leaving:'|| l_proc, 60);

535: end if;
536: --
537: end if;
538: --
539: hr_utility.set_location(' Leaving:'|| l_proc, 60);
540: --
541: end chk_dynamic_insert_allowed;
542: --
543: -- ---------------------------------------------------------------------------

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

575: l_exists varchar2(1);
576: --
577: begin
578: --
579: hr_utility.set_location('Entering:'|| l_proc, 10);
580: --
581: -- Perform CAGR_GRADE_STRUCTURE_ID mandatory check
582: --
583: hr_api.mandatory_arg_error

Line 589: hr_utility.set_location(l_proc,10);

585: ,p_argument => 'cagr_grade_structure_id'
586: ,p_argument_value => p_cagr_grade_structure_id
587: );
588: --
589: hr_utility.set_location(l_proc,10);
590: --
591: -- Check for valid CAGR_GRADE_STRUCTURE_ID
592: --
593: open csr_cagr_grade;

Line 600: hr_utility.set_message(800,'PER_52615_GRS_DEL_GRA');

596: if (csr_cagr_grade%found) then
597: --
598: close csr_cagr_grade;
599: --
600: hr_utility.set_message(800,'PER_52615_GRS_DEL_GRA');
601: hr_utility.raise_error;
602: end if;
603: --
604: close csr_cagr_grade;

Line 601: hr_utility.raise_error;

597: --
598: close csr_cagr_grade;
599: --
600: hr_utility.set_message(800,'PER_52615_GRS_DEL_GRA');
601: hr_utility.raise_error;
602: end if;
603: --
604: close csr_cagr_grade;
605: --

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

602: end if;
603: --
604: close csr_cagr_grade;
605: --
606: hr_utility.set_location('Leaving:'|| l_proc, 20);
607: --
608: end chk_cagr_grades_exists;
609: --
610: -- ----------------------------------------------------------------------------

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

615: --
616: l_proc varchar2(72) := g_package||'insert_validate';
617: --
618: Begin
619: hr_utility.set_location('Entering:'||l_proc, 5);
620: --
621: -- Call all supporting business operations
622: --
623: chk_cagr_grade_structure_id

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

646: );
647: --
648: --
649: --
650: hr_utility.set_location(' Leaving:'||l_proc, 10);
651: End insert_validate;
652: --
653: -- ----------------------------------------------------------------------------
654: -- |---------------------------< update_validate >----------------------------|

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

658: --
659: l_proc varchar2(72) := g_package||'update_validate';
660: --
661: Begin
662: hr_utility.set_location('Entering:'||l_proc, 5);
663: --
664: -- Call all supporting business operations
665: --
666: chk_cagr_grade_structure_id

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

682: ,p_dynamic_insert_allowed => p_rec.dynamic_insert_allowed
683: ,p_effective_date => p_effective_date
684: ,p_object_version_number => p_rec.object_version_number);
685: --
686: hr_utility.set_location(' Leaving:'||l_proc, 10);
687: --
688: End update_validate;
689: --
690: -- ----------------------------------------------------------------------------

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

695: --
696: l_proc varchar2(72) := g_package||'delete_validate';
697: --
698: Begin
699: hr_utility.set_location('Entering:'||l_proc, 5);
700: --
701: -- Call all supporting business operations
702: --
703: chk_cagr_grades_exists

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

702: --
703: chk_cagr_grades_exists
704: (p_cagr_grade_structure_id => p_rec.cagr_grade_structure_id);
705: --
706: hr_utility.set_location(' Leaving:'||l_proc, 10);
707: End delete_validate;
708: --
709: end per_grs_bus;