DBA Data[Home] [Help]

APPS.PAY_PEU_BUS dependencies on HR_UTILITY

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

36: l_proc varchar2(72) := g_package||'set_security_group_id';
37: --
38: begin
39: --
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error

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

67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);
72: --
73: end set_security_group_id;
74: --
75: -- ---------------------------------------------------------------------------

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

96: l_proc varchar2(72) := g_package||'return_legislation_code';
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error

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

114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := pay_peu_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function
122: -- or this is the first call to this function.

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

131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --

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

140: close csr_leg_code;
141: pay_peu_bus.g_event_update_id := p_event_update_id;
142: pay_peu_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;
147: --
148: -- ----------------------------------------------------------------------------

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

258: l_proc varchar2(72) := g_package||'chk_event_type';
259: --
260: Begin
261: --
262: hr_utility.set_location('Entering:'||l_proc, 5);
263: --
264: hr_api.mandatory_arg_error
265: (p_api_name => l_proc
266: ,p_argument => 'event_type'

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

275: --
276: fnd_message.set_name('PAY','HR_xxxx_INVALID_EVENT_TYPE');
277: fnd_message.raise_error;
278: end if;
279: hr_utility.set_location(l_proc,30);
280: --
281: -- Set the global variables so the values are
282: -- available for the next call to this function.
283: --

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

306: --
307: fnd_message.set_name('PAY','HR_xxxx_INVALID_CHANGE_TYPE');
308: fnd_message.raise_error;
309: end if;
310: hr_utility.set_location(l_proc,30);
311: --
312: -- Set the global variables so the values are
313: -- available for the next call to this function.
314: --

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

363: );
364: --
365: Begin
366: --
367: hr_utility.set_location('Entering:'||l_proc, 5);
368: --
369: If (p_rec.event_type = 'U')
370: Then
371: hr_api.mandatory_arg_error

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

388: Close csr_chk_column;
389: End If;
390: --
391: --
392: hr_utility.set_location(' Leaving:'||l_proc, 10);
393: end chk_column;
394: -- Bug no. 3526519. Added check procedure for duplicate check.
395: --
396: -- ----------------------------------------------------------------------------

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

425: business_group_id is null));
426: --
427: begin
428: --
429: hr_utility.set_location('Entering:'||l_proc, 1);
430: hr_utility.set_location('Business_group_id :'||p_rec.business_Group_id, 2);
431: hr_utility.set_location('legislation_code :'||p_rec.legislation_code, 3);
432: hr_utility.set_location('event_type :'||p_rec.event_type, 4);
433: hr_utility.set_location('column_name :'||p_rec.column_name, 5);

Line 430: hr_utility.set_location('Business_group_id :'||p_rec.business_Group_id, 2);

426: --
427: begin
428: --
429: hr_utility.set_location('Entering:'||l_proc, 1);
430: hr_utility.set_location('Business_group_id :'||p_rec.business_Group_id, 2);
431: hr_utility.set_location('legislation_code :'||p_rec.legislation_code, 3);
432: hr_utility.set_location('event_type :'||p_rec.event_type, 4);
433: hr_utility.set_location('column_name :'||p_rec.column_name, 5);
434: hr_utility.set_location('change_type :'||p_rec.change_type, 6);

Line 431: hr_utility.set_location('legislation_code :'||p_rec.legislation_code, 3);

427: begin
428: --
429: hr_utility.set_location('Entering:'||l_proc, 1);
430: hr_utility.set_location('Business_group_id :'||p_rec.business_Group_id, 2);
431: hr_utility.set_location('legislation_code :'||p_rec.legislation_code, 3);
432: hr_utility.set_location('event_type :'||p_rec.event_type, 4);
433: hr_utility.set_location('column_name :'||p_rec.column_name, 5);
434: hr_utility.set_location('change_type :'||p_rec.change_type, 6);
435: hr_utility.set_location('event_type :'||p_rec.table_name, 7);

Line 432: hr_utility.set_location('event_type :'||p_rec.event_type, 4);

428: --
429: hr_utility.set_location('Entering:'||l_proc, 1);
430: hr_utility.set_location('Business_group_id :'||p_rec.business_Group_id, 2);
431: hr_utility.set_location('legislation_code :'||p_rec.legislation_code, 3);
432: hr_utility.set_location('event_type :'||p_rec.event_type, 4);
433: hr_utility.set_location('column_name :'||p_rec.column_name, 5);
434: hr_utility.set_location('change_type :'||p_rec.change_type, 6);
435: hr_utility.set_location('event_type :'||p_rec.table_name, 7);
436: --

Line 433: hr_utility.set_location('column_name :'||p_rec.column_name, 5);

429: hr_utility.set_location('Entering:'||l_proc, 1);
430: hr_utility.set_location('Business_group_id :'||p_rec.business_Group_id, 2);
431: hr_utility.set_location('legislation_code :'||p_rec.legislation_code, 3);
432: hr_utility.set_location('event_type :'||p_rec.event_type, 4);
433: hr_utility.set_location('column_name :'||p_rec.column_name, 5);
434: hr_utility.set_location('change_type :'||p_rec.change_type, 6);
435: hr_utility.set_location('event_type :'||p_rec.table_name, 7);
436: --
437: open c_duplicate_row;

Line 434: hr_utility.set_location('change_type :'||p_rec.change_type, 6);

430: hr_utility.set_location('Business_group_id :'||p_rec.business_Group_id, 2);
431: hr_utility.set_location('legislation_code :'||p_rec.legislation_code, 3);
432: hr_utility.set_location('event_type :'||p_rec.event_type, 4);
433: hr_utility.set_location('column_name :'||p_rec.column_name, 5);
434: hr_utility.set_location('change_type :'||p_rec.change_type, 6);
435: hr_utility.set_location('event_type :'||p_rec.table_name, 7);
436: --
437: open c_duplicate_row;
438: fetch c_duplicate_row into l_exists;

Line 435: hr_utility.set_location('event_type :'||p_rec.table_name, 7);

431: hr_utility.set_location('legislation_code :'||p_rec.legislation_code, 3);
432: hr_utility.set_location('event_type :'||p_rec.event_type, 4);
433: hr_utility.set_location('column_name :'||p_rec.column_name, 5);
434: hr_utility.set_location('change_type :'||p_rec.change_type, 6);
435: hr_utility.set_location('event_type :'||p_rec.table_name, 7);
436: --
437: open c_duplicate_row;
438: fetch c_duplicate_row into l_exists;
439: if c_duplicate_row%found then

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

444: --
445: End If;
446: --
447: close c_duplicate_row;
448: hr_utility.set_location('Leaving:'||l_proc, 2);
449: End chk_unique_rules;
450: --
451: -- ----------------------------------------------------------------------------
452: -- |---------------------------< insert_validate >----------------------------|

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

458: --
459: l_proc varchar2(72) := g_package||'insert_validate';
460: --
461: Begin
462: hr_utility.set_location('Entering:'||l_proc, 5);
463: --
464: -- Call all supporting business operations
465: -- Commenting out the validate bus grp operation as bus grp can
466: -- take a null value.

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

476: --
477: -- Bug no. 3526519. call of check procedure for duplicate check.
478: chk_unique_rules(p_rec => p_rec);
479: --
480: hr_utility.set_location(' Leaving:'||l_proc, 10);
481: End insert_validate;
482: --
483: -- ----------------------------------------------------------------------------
484: -- |---------------------------< update_validate >----------------------------|

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

490: --
491: l_proc varchar2(72) := g_package||'update_validate';
492: --
493: Begin
494: hr_utility.set_location('Entering:'||l_proc, 5);
495: --
496: -- Call all supporting business operations
497: -- Commenting out the validate bus grp operation as bus grp can
498: -- take a null value.

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

514: --
515: -- Bug no. 3526519. call of check procedure for duplicate check.
516: chk_unique_rules(p_rec => p_rec);
517: --
518: hr_utility.set_location(' Leaving:'||l_proc, 10);
519: End update_validate;
520: --
521: -- ----------------------------------------------------------------------------
522: -- |---------------------------< delete_validate >----------------------------|

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

527: --
528: l_proc varchar2(72) := g_package||'delete_validate';
529: --
530: Begin
531: hr_utility.set_location('Entering:'||l_proc, 5);
532: --
533: -- Call all supporting business operations
534: --
535: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

531: hr_utility.set_location('Entering:'||l_proc, 5);
532: --
533: -- Call all supporting business operations
534: --
535: hr_utility.set_location(' Leaving:'||l_proc, 10);
536: End delete_validate;
537: --
538: end pay_peu_bus;