DBA Data[Home] [Help]

APPS.PQH_RFE_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 := pqh_rfe_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: pqh_rfe_bus.g_rate_factor_on_elmnt_id := p_rate_factor_on_elmnt_id;
154: pqh_rfe_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 285: hr_utility.set_location('Entering:'||l_proc, 10);

281: l_api_updating boolean;
282: --
283: Begin
284: --
285: hr_utility.set_location('Entering:'||l_proc, 10);
286: --
287: l_api_updating := pqh_rfe_shd.api_updating
288: (p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id,
289: p_object_version_number => p_object_version_number);

Line 306: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

302: p_effective_date => p_effective_date) then
303: --
304: -- raise error as does not exist as lookup
305: --
306: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
307: hr_utility.raise_error;
308: --
309: end if;
310: --

Line 307: hr_utility.raise_error;

303: --
304: -- raise error as does not exist as lookup
305: --
306: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
307: hr_utility.raise_error;
308: --
309: end if;
310: --
311: end if;

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

309: end if;
310: --
311: end if;
312: --
313: hr_utility.set_location('Leaving:'||l_proc,90);
314: --
315: end chk_rate_factor_val_record_tbl;
316:
317: -- ----------------------------------------------------------------------------

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

354:
355: --
356: Begin
357: --
358: hr_utility.set_location('Entering:'||l_proc,10);
359: --
360:
361: l_api_updating := pqh_rfe_shd.api_updating
362: (p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id,

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

391: --
392: --
393: end if;
394: --
395: hr_utility.set_location('Leaving:'||l_proc,90);
396: --
397: End chk_criteria_rate_element_id;
398: --
399:

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

437:
438: --
439: Begin
440: --
441: hr_utility.set_location('Entering:'||l_proc,10);
442: --
443:
444: l_api_updating := pqh_rfe_shd.api_updating
445: (p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id,

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

474: --
475: --
476: end if;
477: --
478: hr_utility.set_location('Leaving:'||l_proc,90);
479: --
480: End chk_criteria_rate_factor_id;
481: --
482:

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

539:
540: --
541: Begin
542: --
543: hr_utility.set_location('Entering:'||l_proc,10);
544: --
545:
546: l_api_updating := pqh_rfe_shd.api_updating
547: (p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id,

Line 585: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

581: end loop;
582: close c1;
583: end if;
584: if l_success = false then
585: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
586: hr_utility.raise_error;
587: end if;
588:
589:

Line 586: hr_utility.raise_error;

582: close c1;
583: end if;
584: if l_success = false then
585: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
586: hr_utility.raise_error;
587: end if;
588:
589:
590: end if;

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

588:
589:
590: end if;
591: --
592: hr_utility.set_location('Leaving:'||l_proc,90);
593: --
594: EXCEPTION
595: WHEN VALUE_ERROR then
596: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

Line 596: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

592: hr_utility.set_location('Leaving:'||l_proc,90);
593: --
594: EXCEPTION
595: WHEN VALUE_ERROR then
596: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
597: hr_utility.raise_error;
598:
599:
600: End chk_rate_factor_val_record_col;

Line 597: hr_utility.raise_error;

593: --
594: EXCEPTION
595: WHEN VALUE_ERROR then
596: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
597: hr_utility.raise_error;
598:
599:
600: End chk_rate_factor_val_record_col;
601: --

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

640:
641: --
642: Begin
643: --
644: hr_utility.set_location('Entering:'||l_proc,10);
645: --
646:
647: l_api_updating := pqh_rfe_shd.api_updating
648: (p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id,

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

677: --
678: --
679: end if;
680: --
681: hr_utility.set_location('Leaving:'||l_proc,90);
682: --
683: End chk_business_group_id;
684: --
685:

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

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

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

758: END IF;
759:
760:
761:
762: hr_utility.set_location(' Leaving:'||l_proc, 10);
763: End insert_validate;
764: --
765: -- ----------------------------------------------------------------------------
766: -- |---------------------------< update_validate >----------------------------|

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

772: --
773: l_proc varchar2(72) := g_package||'update_validate';
774: --
775: Begin
776: hr_utility.set_location('Entering:'||l_proc, 5);
777: --
778: -- Call all supporting business operations
779: --
780: --

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

840: ,p_rec => p_rec
841: );
842: --
843: --
844: hr_utility.set_location(' Leaving:'||l_proc, 10);
845: End update_validate;
846: --
847: -- ----------------------------------------------------------------------------
848: -- |---------------------------< delete_validate >----------------------------|

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

853: --
854: l_proc varchar2(72) := g_package||'delete_validate';
855: --
856: Begin
857: hr_utility.set_location('Entering:'||l_proc, 5);
858: --
859: --
860: chk_startup_action(false
861: ,pqh_rfe_shd.g_old_rec.business_group_id

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

875: END IF;
876: --
877: -- Call all supporting business operations
878: --
879: hr_utility.set_location(' Leaving:'||l_proc, 10);
880: End delete_validate;
881: --
882: end pqh_rfe_bus;