DBA Data[Home] [Help]

APPS.PER_BPA_BUS dependencies on HR_UTILITY

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

39: l_proc varchar2(72) := g_package||'return_legislation_code';
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(p_api_name => l_proc

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

55: -- call to this function. Just return the value in the global
56: -- variable.
57: --
58: l_legislation_code := g_legislation_code;
59: hr_utility.set_location(l_proc, 20);
60: else
61: --
62: -- The ID is different to the last call to this function
63: -- or this is the first call to this function.

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

72: close csr_leg_code;
73: fnd_message.set_name('PER','HR_7220_INVALID_PRIMARY_KEY');
74: fnd_message.raise_error;
75: end if;
76: hr_utility.set_location(l_proc,30);
77: --
78: -- Set the global variables so the values are
79: -- available for the next call to this function.
80: --

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

81: close csr_leg_code;
82: g_processed_assignment_id := p_processed_assignment_id;
83: g_legislation_code := l_legislation_code;
84: end if;
85: hr_utility.set_location(' Leaving:'|| l_proc, 40);
86: return l_legislation_code;
87: end return_legislation_code;
88: --
89: -- ----------------------------------------------------------------------------

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

121: --
122: l_proc varchar2(72) := g_package || 'chk_df';
123: --
124: begin
125: hr_utility.set_location('Entering:'||l_proc,10);
126: --
127: if ((p_rec.processed_assignment_id is not null) and (
128: nvl(per_bpa_shd.g_old_rec.bpa_attribute_category, hr_api.g_varchar2) <>
129: nvl(p_rec.bpa_attribute_category, hr_api.g_varchar2) or

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

260: ,p_attribute30_value => p_rec.bpa_attribute30
261: );
262: end if;
263: --
264: hr_utility.set_location(' Leaving:'||l_proc,20);
265: end chk_df;
266: --
267: -- ----------------------------------------------------------------------------
268: -- |----------------------< check_non_updateable_args >-----------------------|

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

299: l_error EXCEPTION;
300: l_argument varchar2(30);
301: --
302: Begin
303: hr_utility.set_location('Entering:'||l_proc,5);
304: --
305: -- Only proceed with the validation if a row exists for the current
306: -- record in the HR Schema.
307: --

Line 312: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

308: IF NOT per_bpa_shd.api_updating
309: (p_processed_assignment_id => p_rec.processed_assignment_id
310: ,p_object_version_number => p_rec.object_version_number
311: ) THEN
312: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
313: hr_utility.set_message_token('PROCEDURE ', l_proc);
314: hr_utility.set_message_token('STEP ', '5');
315: END IF;
316: --

Line 313: hr_utility.set_message_token('PROCEDURE ', l_proc);

309: (p_processed_assignment_id => p_rec.processed_assignment_id
310: ,p_object_version_number => p_rec.object_version_number
311: ) THEN
312: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
313: hr_utility.set_message_token('PROCEDURE ', l_proc);
314: hr_utility.set_message_token('STEP ', '5');
315: END IF;
316: --
317: hr_utility.set_location(l_proc,10);

Line 314: hr_utility.set_message_token('STEP ', '5');

310: ,p_object_version_number => p_rec.object_version_number
311: ) THEN
312: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
313: hr_utility.set_message_token('PROCEDURE ', l_proc);
314: hr_utility.set_message_token('STEP ', '5');
315: END IF;
316: --
317: hr_utility.set_location(l_proc,10);
318: --

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

313: hr_utility.set_message_token('PROCEDURE ', l_proc);
314: hr_utility.set_message_token('STEP ', '5');
315: END IF;
316: --
317: hr_utility.set_location(l_proc,10);
318: --
319: IF nvl(p_rec.payroll_run_id, hr_api.g_number) <>
320: per_bpa_shd.g_old_rec.payroll_run_id then
321: l_argument:='payroll_run_id';

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

320: per_bpa_shd.g_old_rec.payroll_run_id then
321: l_argument:='payroll_run_id';
322: raise l_error;
323: END IF;
324: hr_utility.set_location(l_proc,20);
325: --
326: IF nvl(p_rec.assignment_id, hr_api.g_number) <>
327: per_bpa_shd.g_old_rec.assignment_id then
328: l_argument:='assigment_id';

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

327: per_bpa_shd.g_old_rec.assignment_id then
328: l_argument:='assigment_id';
329: raise l_error;
330: END IF;
331: hr_utility.set_location(l_proc,30);
332: --
333: --
334: EXCEPTION
335: WHEN l_error THEN

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

337: (p_api_name => l_proc
338: ,p_argument => l_argument);
339: WHEN OTHERS THEN
340: RAISE;
341: hr_utility.set_location(' Leaving:'||l_proc,40);
342: End chk_non_updateable_args;
343: --
344: -- ----------------------------------------------------------------------------
345: -- |----------------------< chk_assignment_id >-------------------------------|

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

382: l_eed DATE;
383: --
384: l_proc varchar2(72) := g_package||'chk_assignment_id';
385: BEGIN
386: hr_utility.set_location('Entering:'||l_proc, 5);
387: --
388: OPEN csr_get_asg_dates;
389: FETCH csr_get_asg_dates INTO l_esd, l_eed;
390: --

Line 397: hr_utility.set_message(800,'HR_52934_NO_ASG_AVAIL');

393: CLOSE csr_get_asg_dates ;
394: -- The assignment_id doesn't exist in the assignment table
395: -- for the specified time period, so error.
396: --
397: hr_utility.set_message(800,'HR_52934_NO_ASG_AVAIL');
398: hr_utility.raise_error;
399: --
400: END IF;
401: --

Line 398: hr_utility.raise_error;

394: -- The assignment_id doesn't exist in the assignment table
395: -- for the specified time period, so error.
396: --
397: hr_utility.set_message(800,'HR_52934_NO_ASG_AVAIL');
398: hr_utility.raise_error;
399: --
400: END IF;
401: --
402: CLOSE csr_get_asg_dates ;

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

436: l_temp VARCHAR2(1);
437: --
438: l_proc varchar2(72) := g_package||'chk_payroll_run_id';
439: BEGIN
440: hr_utility.set_location('Entering:'||l_proc, 5);
441: --
442: OPEN csr_get_run_dates;
443: FETCH csr_get_run_dates INTO l_temp;
444: --

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

505: l_run_bg NUMBER;
506: --
507: l_proc varchar2(72) := g_package||'chk_bg_are_same';
508: BEGIN
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: OPEN csr_get_payroll_run_bg;
512: FETCH csr_get_payroll_run_bg INTO l_run_bg;
513: CLOSE csr_get_payroll_run_bg;

Line 526: hr_utility.set_message(800,'HR_52936_DIFF_BGS');

522: IF l_asg_bg <> l_run_bg THEN
523: --
524: -- The business groups of the assignment and payroll run differ, so error.
525: --
526: hr_utility.set_message(800,'HR_52936_DIFF_BGS');
527: hr_utility.raise_error;
528: --
529: END IF;
530: --

Line 527: hr_utility.raise_error;

523: --
524: -- The business groups of the assignment and payroll run differ, so error.
525: --
526: hr_utility.set_message(800,'HR_52936_DIFF_BGS');
527: hr_utility.raise_error;
528: --
529: END IF;
530: --
531: END chk_bg_are_same;

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

554: where bpd.processed_assignment_id = p_processed_assignment_id;
555:
556: --
557: BEGIN
558: hr_utility.set_location('Entering: '||l_proc, 10);
559: --
560: if p_processed_assignment_id is not null then
561: --
562: open csr_balance_amount;

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

578: close csr_payment_detail;
579: --
580: end if;
581: --
582: hr_utility.set_location('Leaving: '||l_proc,50);
583: --
584: END chk_child_rows;
585: --
586: -- ----------------------------------------------------------------------------

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

603: where assignment_id = p_assignment_id
604: and payroll_run_id = p_payroll_run_id;
605: --
606: BEGIN
607: hr_utility.set_location('Entering: '||l_proc, 10);
608: --
609: hr_api.mandatory_arg_error(p_api_name => l_proc
610: ,p_argument => 'ASSIGNMENT_ID'
611: ,p_argument_value => p_assignment_id);

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

622: per_bpa_shd.constraint_error('PER_BF_PROCESSED_ASSIGNS_UK1');
623: end if;
624: close csr_id_unique;
625: --
626: hr_utility.set_location(' Leaving: '||l_proc, 50);
627: --
628: end chk_ids_unique;
629: --
630: -- ----------------------------------------------------------------------------

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

637: --
638: l_proc varchar2(72) := g_package||'insert_validate';
639: --
640: Begin
641: hr_utility.set_location('Entering:'||l_proc, 5);
642: --
643: -- Call all supporting business operations
644: --
645: -- Note: The chk_payroll_run_id is before the set_security_group_id

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

670: -- Validate flexfields
671: -- ===================
672: chk_df(p_rec => p_rec);
673: --
674: hr_utility.set_location(' Leaving:'||l_proc, 10);
675: End insert_validate;
676: --
677: -- ----------------------------------------------------------------------------
678: -- |---------------------------< update_validate >----------------------------|

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

684: --
685: l_proc varchar2(72) := g_package||'update_validate';
686: --
687: Begin
688: hr_utility.set_location('Entering:'||l_proc, 5);
689: --
690: -- Call parent set_security_group_id proc.
691: --
692: per_bpr_bus.set_security_group_id

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

700: -- Validate flexfields
701: -- ===================
702: chk_df(p_rec => p_rec);
703: --
704: hr_utility.set_location(' Leaving:'||l_proc, 10);
705: End update_validate;
706: --
707: -- ----------------------------------------------------------------------------
708: -- |---------------------------< delete_validate >----------------------------|

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

713: --
714: l_proc varchar2(72) := g_package||'delete_validate';
715: --
716: Begin
717: hr_utility.set_location('Entering:'||l_proc, 5);
718: --
719: -- Call all supporting business operations
720: --
721: chk_child_rows(p_processed_assignment_id => p_rec.processed_assignment_id);

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

719: -- Call all supporting business operations
720: --
721: chk_child_rows(p_processed_assignment_id => p_rec.processed_assignment_id);
722: --
723: hr_utility.set_location(' Leaving:'||l_proc, 10);
724: End delete_validate;
725: --
726: end per_bpa_bus;