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

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

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

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

83: (p_security_group_id => l_security_group_id
84: );
85: end if;
86: --
87: hr_utility.set_location(' Leaving:'|| l_proc, 20);
88: --
89: end set_security_group_id;
90: --
91: -- ---------------------------------------------------------------------------

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

114: l_proc varchar2(72) := g_package||'return_legislation_code';
115: --
116: Begin
117: --
118: hr_utility.set_location('Entering:'|| l_proc, 10);
119: --
120: -- Ensure that all the mandatory parameter are not null
121: --
122: hr_api.mandatory_arg_error

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

139: -- call to this function. Just return the value in the global
140: -- variable.
141: --
142: l_legislation_code := pay_spr_bus.g_legislation_code;
143: hr_utility.set_location(l_proc, 20);
144: else
145: --
146: -- The ID is different to the last call to this function
147: -- or this is the first call to this function.

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

156: close csr_leg_code;
157: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
158: fnd_message.raise_error;
159: end if;
160: hr_utility.set_location(l_proc,30);
161: --
162: -- Set the global variables so the values are
163: -- available for the next call to this function.
164: --

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

166: pay_spr_bus.g_security_profile_id := p_security_profile_id;
167: pay_spr_bus.g_payroll_id := p_payroll_id;
168: pay_spr_bus.g_legislation_code := l_legislation_code;
169: end if;
170: hr_utility.set_location(' Leaving:'|| l_proc, 40);
171: return l_legislation_code;
172: end return_legislation_code;
173: --
174: -- --------------------------------------------------------------------------

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

183: --
184: l_proc varchar2(80) := g_package||'chk_payroll_id';
185: --
186: Begin
187: hr_utility.set_location('Entering:'||l_proc, 5);
188:
189: hr_utility.set_location(to_char(p_payroll_id),10);
190: hr_utility.set_location(to_char(p_security_profile_id),15);
191:

Line 189: hr_utility.set_location(to_char(p_payroll_id),10);

185: --
186: Begin
187: hr_utility.set_location('Entering:'||l_proc, 5);
188:
189: hr_utility.set_location(to_char(p_payroll_id),10);
190: hr_utility.set_location(to_char(p_security_profile_id),15);
191:
192: --Ensure that the payroll_id and security_profile_id are valid
193:

Line 190: hr_utility.set_location(to_char(p_security_profile_id),15);

186: Begin
187: hr_utility.set_location('Entering:'||l_proc, 5);
188:
189: hr_utility.set_location(to_char(p_payroll_id),10);
190: hr_utility.set_location(to_char(p_security_profile_id),15);
191:
192: --Ensure that the payroll_id and security_profile_id are valid
193:
194: Select distinct pay_all_payrolls_f.business_group_id

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

218: e_null_business_group_id Exception;
219: l_proc varchar2(80) := g_package||'chk_security_profile';
220: --
221: Begin
222: hr_utility.set_location('Entering:'||l_proc, 5);
223:
224: --Ensure that the security profile id is not global
225:
226: Select business_group_id

Line 230: hr_utility.set_location(to_char(p_business_group_id),15);

226: Select business_group_id
227: Into p_business_group_id
228: From per_security_profiles
229: Where security_profile_id = p_security_profile_id;
230: hr_utility.set_location(to_char(p_business_group_id),15);
231: If p_business_group_id is null then
232: hr_utility.set_location(to_char(p_business_group_id),16);
233: Raise e_null_business_group_id;
234: End if;

Line 232: hr_utility.set_location(to_char(p_business_group_id),16);

228: From per_security_profiles
229: Where security_profile_id = p_security_profile_id;
230: hr_utility.set_location(to_char(p_business_group_id),15);
231: If p_business_group_id is null then
232: hr_utility.set_location(to_char(p_business_group_id),16);
233: Raise e_null_business_group_id;
234: End if;
235:
236: Exception

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

240:
241: When no_data_found then
242: fnd_message.set_name ('PER', 'HR_289799_INVALID_SEC_PROFILE');
243: fnd_message.raise_error;
244: hr_utility.set_location('Leaving:'||l_proc, 10);
245: End chk_security_profile;
246: --
247: -- --------------------------------------------------------------------------
248: -- |-----------------------------------------------------|

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

266: AND spr.payroll_id = p_payroll_id;
267:
268: BEGIN
269:
270: hr_utility.set_location('Entering:'||l_proc, 10);
271:
272: --
273: -- Only proceed with validation when the Multiple Message List
274: -- does not already contain an error associated with the

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

280: ,p_check_column2 => pay_spr_shd.g_tab_nam||'.PAYROLL_ID'
281: ,p_associated_column2 => pay_spr_shd.g_tab_nam||'.PAYROLL_ID')
282: THEN
283:
284: hr_utility.set_location(l_proc, 20);
285:
286: OPEN csr_chk_for_dup;
287: FETCH csr_chk_for_dup INTO l_dummy;
288:

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

289: IF csr_chk_for_dup%FOUND THEN
290: --
291: -- This security profile already has this payroll; raise an error.
292: --
293: hr_utility.set_location(l_proc, 30);
294: CLOSE csr_chk_for_dup;
295: fnd_message.set_name('PER','PER_7061_DEF_SECPROF_PAY_EXIST');
296: fnd_message.raise_error;
297:

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

297:
298: END IF;
299: CLOSE csr_chk_for_dup;
300:
301: hr_utility.set_location('Leaving:'||l_proc, 40);
302:
303: END IF;
304:
305: EXCEPTION

Line 316: hr_utility.set_location(' Leaving:'|| l_proc, 50);

312:
313: IF hr_multi_message.exception_add
314: (p_same_associated_columns => 'Y') THEN
315:
316: hr_utility.set_location(' Leaving:'|| l_proc, 50);
317: RAISE;
318:
319: END IF;
320: hr_utility.set_location(' Leaving:'|| l_proc, 60);

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

316: hr_utility.set_location(' Leaving:'|| l_proc, 50);
317: RAISE;
318:
319: END IF;
320: hr_utility.set_location(' Leaving:'|| l_proc, 60);
321:
322: END chk_for_duplicate;
323: --
324: -- --------------------------------------------------------------------------

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

341: WHERE psp.security_profile_id = p_security_profile_id;
342:
343: BEGIN
344:
345: hr_utility.set_location('Entering:'||l_proc, 10);
346:
347: --
348: -- Only proceed with validation when the Multiple Message List
349: -- does not already contain an error associated with the

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

353: (p_check_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID'
354: ,p_associated_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID')
355: THEN
356:
357: hr_utility.set_location(l_proc, 20);
358:
359: OPEN csr_get_view_all_payrolls;
360: FETCH csr_get_view_all_payrolls INTO l_view_all_payrolls_flag;
361: CLOSE csr_get_view_all_payrolls;

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

364: --
365: -- Payrolls cannot be added for this profile because it is set to
366: -- "View All Payrolls."
367: --
368: hr_utility.set_location(l_proc, 30);
369: fnd_message.set_name('PER','HR_289830_SPR_VIEW_ALL_PAY_SET');
370: fnd_message.raise_error;
371:
372: END IF;

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

370: fnd_message.raise_error;
371:
372: END IF;
373:
374: hr_utility.set_location('Leaving:'||l_proc, 40);
375:
376: END IF;
377:
378: EXCEPTION

Line 389: hr_utility.set_location(' Leaving:'|| l_proc, 50);

385:
386: IF hr_multi_message.exception_add
387: (p_same_associated_columns => 'Y') THEN
388:
389: hr_utility.set_location(' Leaving:'|| l_proc, 50);
390: RAISE;
391:
392: END IF;
393: hr_utility.set_location(' Leaving:'|| l_proc, 60);

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

389: hr_utility.set_location(' Leaving:'|| l_proc, 50);
390: RAISE;
391:
392: END IF;
393: hr_utility.set_location(' Leaving:'|| l_proc, 60);
394:
395: END chk_view_all_payrolls_flag;
396: --
397: -- --------------------------------------------------------------------------

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

414: WHERE spr.security_profile_id = p_security_profile_id;
415:
416: BEGIN
417:
418: hr_utility.set_location('Entering:'||l_proc, 10);
419:
420: OPEN csr_get_security_payrolls;
421: FETCH csr_get_security_payrolls INTO l_dummy;
422:

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

423: IF csr_get_security_payrolls%NOTFOUND THEN
424: --
425: -- Update the view all payrolls flag on the Security Profile.
426: --
427: hr_utility.set_location(l_proc, 30);
428:
429: UPDATE per_security_profiles
430: SET view_all_payrolls_flag = 'Y'
431: WHERE security_profile_id = p_security_profile_id;

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

433: END IF;
434:
435: CLOSE csr_get_security_payrolls;
436:
437: hr_utility.set_location('Leaving:'||l_proc, 40);
438:
439: END set_view_all_payrolls_flag;
440: --
441: -- ----------------------------------------------------------------------------

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

501: l_proc varchar2(72) := g_package||'insert_validate';
502: --
503:
504: Begin
505: hr_utility.set_location('Entering:'||l_proc, 5);
506: --
507: -- Call all supporting business operations
508: --
509: hr_api.validate_bus_grp_id

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

530: --
531: chk_view_all_payrolls_flag
532: (p_security_profile_id => p_rec.security_profile_id);
533:
534: hr_utility.set_location(' Leaving:'||l_proc, 10);
535:
536: End insert_validate;
537: --
538: -- ----------------------------------------------------------------------------

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

544: --
545: l_proc varchar2(72) := g_package||'delete_validate';
546: --
547: Begin
548: hr_utility.set_location('Entering:'||l_proc, 5);
549: --
550: -- Call all supporting business operations
551: --
552: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

548: hr_utility.set_location('Entering:'||l_proc, 5);
549: --
550: -- Call all supporting business operations
551: --
552: hr_utility.set_location(' Leaving:'||l_proc, 10);
553: End delete_validate;
554: --
555: --
556: end pay_spr_bus;