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.PAY_PPR_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 := pay_ppr_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: pay_ppr_bus.g_status_processing_rule_id := p_status_processing_rule_id;
154: pay_ppr_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 197: hr_utility.set_location('Entering:'||l_proc, 5);

193: l_argument varchar2(80);
194: l_error exception;
195: --
196: Begin
197: hr_utility.set_location('Entering:'||l_proc, 5);
198: --
199: -- Only proceed with the validation if a row exists for the current
200: -- record in the HR Schema.
201: --

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

209: fnd_message.set_token('STEP ', '5');
210: fnd_message.raise_error;
211: END IF;
212: --
213: hr_utility.set_location('Entering:'||l_proc, 10);
214: --
215: -- Ensure that the following attributes are not updated.
216: --
217: If nvl(p_rec.business_group_id,hr_api.g_number) <>

Line 225: hr_utility.set_location('Entering:'||l_proc, 15);

221: raise l_error;
222: --
223: End if;
224: --
225: hr_utility.set_location('Entering:'||l_proc, 15);
226: --
227: If nvl(p_rec.legislation_code,hr_api.g_varchar2) <>
228: nvl(pay_ppr_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then
229: --

Line 235: hr_utility.set_location('Entering:'||l_proc, 20);

231: raise l_error;
232: --
233: End if;
234: --
235: hr_utility.set_location('Entering:'||l_proc, 20);
236: --
237: If nvl(p_rec.status_processing_rule_id,hr_api.g_number) <>
238: nvl(pay_ppr_shd.g_old_rec.status_processing_rule_id,hr_api.g_number) then
239: --

Line 245: hr_utility.set_location('Entering:'||l_proc, 25);

241: raise l_error;
242: --
243: End if;
244: --
245: hr_utility.set_location('Entering:'||l_proc, 25);
246: --
247: If nvl(p_rec.assignment_status_type_id,hr_api.g_number) <>
248: nvl(pay_ppr_shd.g_old_rec.assignment_status_type_id,hr_api.g_number) then
249: --

Line 255: hr_utility.set_location('Entering:'||l_proc, 30);

251: raise l_error;
252: --
253: End if;
254: --
255: hr_utility.set_location('Entering:'||l_proc, 30);
256: --
257: If nvl(p_rec.element_type_id,hr_api.g_number) <>
258: nvl(pay_ppr_shd.g_old_rec.element_type_id,hr_api.g_number) then
259: --

Line 265: hr_utility.set_location('Entering:'||l_proc, 35);

261: raise l_error;
262: --
263: End if;
264: --
265: hr_utility.set_location('Entering:'||l_proc, 35);
266: --
267: If nvl(p_rec.legislation_subgroup,hr_api.g_varchar2) <>
268: nvl(pay_ppr_shd.g_old_rec.legislation_subgroup,hr_api.g_varchar2) then
269: --

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

271: raise l_error;
272: --
273: End if;
274: --
275: hr_utility.set_location('Leaving :'||l_proc, 40);
276: EXCEPTION
277: WHEN l_error THEN
278: hr_api.argument_changed_error
279: (p_api_name => l_proc

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

490: or ( astp.legislation_code is null and
491: astp.business_group_id is null));
492: --
493: Begin
494: hr_utility.set_location('Entering:'||l_proc, 5);
495: --
496: If p_assignment_status_type_id is not null then
497:
498: Open c_chk_assign_status_type;

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

506: End If;
507: Close c_chk_assign_status_type;
508: End If;
509: --
510: hr_utility.set_location('Leaving:'||l_proc, 10);
511: End;
512:
513: --
514: -- ----------------------------------------------------------------------------

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

567: l_formula_type ff_formula_types.formula_type_name%type;
568: l_assignment_status per_assignment_status_types.user_status%type;
569: --
570: Begin
571: hr_utility.set_location('Entering:'||l_proc, 5);
572:
573: --
574: -- if assignment status is of type 'Standard' or 'Balance Adjustment'
575: -- and formula is null then return 'P'

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

612: Close c_chk_formula_id;
613:
614:
615:
616: hr_utility.set_location('Entering:'||l_proc, 10);
617: --
618: --
619: -- check if formula is updated
620: -- formula can not be updated if result rule exist with in

Line 630: hr_utility.set_location('Entering:'||l_proc, 15);

626: fnd_message.set_name('PAY','HR_7135_SPR_FORMULA_NO_UPDATE');
627: fnd_message.raise_error;
628: end if;
629: --
630: hr_utility.set_location('Entering:'||l_proc, 15);
631: --
632: -- check whether input values for the element do not match the
633: -- data type of any of the inputs of the selected formula
634: --

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

643: p_formula_mismatch_warning := false;
644: end if;
645: End If;
646: --
647: hr_utility.set_location('Leaving:'||l_proc, 20);
648: End;
649: --
650: -- ----------------------------------------------------------------------------
651: -- |------------------------< chk_element_type_id >---------------------------|

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

685: = nvl(nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)),'~');
686:
687: --
688: Begin
689: hr_utility.set_location('Entering:'||l_proc, 5);
690: --
691: -- Check mandatory element_type_id exists
692: --
693: --

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

696: ,p_argument => 'element_type_id'
697: ,p_argument_value => p_element_type_id
698: );
699: --
700: hr_utility.set_location('Entering:'||l_proc, 10);
701: --
702: open c_chk_element_type;
703: fetch c_chk_element_type into l_exists;
704: if c_chk_element_type%notfound then

Line 712: hr_utility.set_location('Leaving:'||l_proc, 15);

708: fnd_message.raise_error;
709: end if;
710: close c_chk_element_type;
711: --
712: hr_utility.set_location('Leaving:'||l_proc, 15);
713: End;
714: --
715: -- ----------------------------------------------------------------------------
716: -- |------------------------< chk_legislation_code >--------------------------|

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

734: from fnd_territories
735: where territory_code = p_legislation_code;
736: --
737: Begin
738: hr_utility.set_location('Entering:'||l_proc, 5);
739: --
740: If p_legislation_code is not null then
741:
742: Open c_chk_leg_code;

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

753: Close c_chk_leg_code;
754:
755: End If;
756: --
757: hr_utility.set_location('Leaving:'||l_proc, 10);
758: End;
759:
760: --
761: -- ----------------------------------------------------------------------------

Line 795: hr_utility.set_location('Entering:'||l_proc, 1);

791: and status_processing_rule_id <> nvl(p_status_processing_rule_id,-1);
792: --
793: begin
794: --
795: hr_utility.set_location('Entering:'||l_proc, 1);
796: --
797: open c_duplicate_rule;
798: fetch c_duplicate_rule into l_exists;
799: if c_duplicate_rule%found then

Line 808: hr_utility.set_location('Leaving:'||l_proc, 2);

804: --
805: End If;
806: --
807: close c_duplicate_rule;
808: hr_utility.set_location('Leaving:'||l_proc, 2);
809: End chk_unique_rules;
810: --
811: -- ----------------------------------------------------------------------------
812: -- |------------------------< set_effective_end_date >------------------------|

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

836: l_max_end_date_of_element date;
837:
838: --
839: Begin
840: hr_utility.set_location('Entering:'||l_proc, 5);
841: --
842: -- find out max effective end date of the element
843: l_max_end_date_of_element :=
844: pay_element_types_pkg.element_end_date (p_element_type_id);

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

861: p_legislation_code =>p_legislation_code
862: );
863:
864: --
865: hr_utility.set_location('Leaving:'||l_proc, 10);
866: End;
867: --
868: -- ----------------------------------------------------------------------------
869: -- |----------------------< chk_startup_action >------------------------------|

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

923: l_processing_rule pay_status_processing_rules_f.processing_rule%type;
924: l_formula_mismatch_warning boolean;
925: --
926: Begin
927: hr_utility.set_location('Entering:'||l_proc, 5);
928: --
929: -- Call all supporting business operations
930: --
931: --

Line 932: hr_utility.set_location('Before chk_startup:'||l_proc, 6);

928: --
929: -- Call all supporting business operations
930: --
931: --
932: hr_utility.set_location('Before chk_startup:'||l_proc, 6);
933:
934: chk_startup_action(true
935: ,p_rec.business_group_id
936: ,p_rec.legislation_code

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

1009: ,p_element_type_id => p_rec.element_type_id
1010: ,p_status_processing_rule_id => p_rec.status_processing_rule_id
1011: );
1012: --
1013: hr_utility.set_location(' Leaving:'||l_proc, 10);
1014: End insert_validate;
1015: --
1016: -- ----------------------------------------------------------------------------
1017: -- |---------------------------< update_validate >----------------------------|

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

1030: l_formula_mismatch_warning boolean;
1031: l_processing_rule varchar2(1);
1032: --
1033: Begin
1034: hr_utility.set_location('Entering:'||l_proc, 5);
1035: --
1036: -- Call all supporting business operations
1037: --
1038: --

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

1090: ,p_rec => p_rec
1091: );
1092: --
1093: --
1094: hr_utility.set_location(' Leaving:'||l_proc, 10);
1095: End update_validate;
1096: --
1097: -- ----------------------------------------------------------------------------
1098: -- |---------------------------< delete_validate >----------------------------|

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

1107: --
1108: l_proc varchar2(72) := g_package||'delete_validate';
1109: --
1110: Begin
1111: hr_utility.set_location('Entering:'||l_proc, 5);
1112: --
1113: --
1114: chk_startup_action(false
1115: ,pay_ppr_shd.g_old_rec.business_group_id

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

1136: ,p_validation_end_date => p_validation_end_date
1137: ,p_status_processing_rule_id => p_rec.status_processing_rule_id
1138: );
1139: --
1140: hr_utility.set_location(' Leaving:'||l_proc, 10);
1141: End delete_validate;
1142: --
1143: end pay_ppr_bus;