DBA Data[Home] [Help]

APPS.PAY_BCT_BUS dependencies on HR_UTILITY

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

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

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

74: hr_api.set_security_group_id
75: (p_security_group_id => l_security_group_id
76: );
77: --
78: hr_utility.set_location(' Leaving:'|| l_proc, 20);
79: --
80: end set_security_group_id;
81: --
82: -- ---------------------------------------------------------------------------

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

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

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

128: -- call to this function. Just return the value in the global
129: -- variable.
130: --
131: l_legislation_code := pay_bct_bus.g_legislation_code;
132: hr_utility.set_location(l_proc, 20);
133: else
134: --
135: -- The ID is different to the last call to this function
136: -- or this is the first call to this function.

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

145: close csr_leg_code;
146: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
147: fnd_message.raise_error;
148: end if;
149: hr_utility.set_location(l_proc,30);
150: --
151: -- Set the global variables so the values are
152: -- available for the next call to this function.
153: --

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

154: close csr_leg_code;
155: pay_bct_bus.g_batch_control_id := p_batch_control_id;
156: pay_bct_bus.g_legislation_code := l_legislation_code;
157: end if;
158: hr_utility.set_location(' Leaving:'|| l_proc, 40);
159: return l_legislation_code;
160: end return_legislation_code;
161: --
162: -- ----------------------------------------------------------------------------

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

208: fnd_message.set_token('STEP ', '5');
209: fnd_message.raise_error;
210: END IF;
211: --
212: hr_utility.set_location(l_proc, 10);
213: --
214: if nvl(p_rec.batch_id, hr_api.g_number) <>
215: pay_bct_shd.g_old_rec.batch_id then
216: l_argument := 'batch_id';

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

322: from pay_batch_headers bth
323: where bth.batch_id = p_batch_id;
324: --
325: begin
326: hr_utility.set_location('Entering:'||l_proc, 1);
327: --
328: -- Check mandatory batch_id is set
329: --
330: hr_api.mandatory_arg_error

Line 336: hr_utility.set_location(l_proc, 5);

332: ,p_argument => 'BATCH_ID'
333: ,p_argument_value => p_batch_id
334: );
335: --
336: hr_utility.set_location(l_proc, 5);
337: --
338: --
339: --
340: -- Only proceed with validation if :

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

341: -- a) on insert (non-updateable param)
342: --
343: if (p_batch_control_id is null) then
344: --
345: hr_utility.set_location(l_proc, 10);
346: --
347: -- Check that the batch_id is in the pay_batch_headers.
348: --
349: open csr_batch_id_exists;

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

354: end if;
355: close csr_batch_id_exists;
356: end if;
357: --
358: hr_utility.set_location(' Leaving:'||l_proc, 15);
359: --
360: end chk_batch_id;
361: --
362: -- ---------------------------------------------------------------------------

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

402: l_proc varchar2(72) := g_package||'chk_control_status';
403: l_api_updating boolean;
404: --
405: begin
406: hr_utility.set_location('Entering:'||l_proc, 1);
407: --
408: -- Check mandatory batch_name exists
409: --
410: hr_api.mandatory_arg_error

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

420: ,p_argument => 'session_date'
421: ,p_argument_value => p_session_date
422: );
423: --
424: hr_utility.set_location(l_proc, 10);
425: --
426: l_api_updating := pay_bct_shd.api_updating
427: (p_batch_control_id => p_batch_control_id,
428: p_object_version_number => p_object_version_number

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

426: l_api_updating := pay_bct_shd.api_updating
427: (p_batch_control_id => p_batch_control_id,
428: p_object_version_number => p_object_version_number
429: );
430: hr_utility.set_location(l_proc,20);
431: --
432: -- Only proceed with SQL validation if absolutely necessary
433: --
434: if ((l_api_updating and

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

435: nvl(pay_bct_shd.g_old_rec.control_status,hr_api.g_varchar2) <>
436: nvl(p_control_status,hr_api.g_varchar2))
437: or (NOT l_api_updating)) then
438: --
439: hr_utility.set_location(l_proc,30);
440: --
441: -- Validate against the hr_lookup.
442: --
443: if hr_api.not_exists_in_hr_lookups

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

448: end if;
449: --
450: end if;
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 40);
453: --
454: end chk_control_status;
455: --
456: -- ---------------------------------------------------------------------------

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

495: l_proc varchar2(72) := g_package||'chk_control_type';
496: l_api_updating boolean;
497: --
498: begin
499: hr_utility.set_location('Entering:'||l_proc, 1);
500: --
501: -- Check mandatory session_date exists
502: --
503: hr_api.mandatory_arg_error

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

505: ,p_argument => 'session_date'
506: ,p_argument_value => p_session_date
507: );
508: --
509: hr_utility.set_location(l_proc, 10);
510: --
511: l_api_updating := pay_bct_shd.api_updating
512: (p_batch_control_id => p_batch_control_id,
513: p_object_version_number => p_object_version_number

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

511: l_api_updating := pay_bct_shd.api_updating
512: (p_batch_control_id => p_batch_control_id,
513: p_object_version_number => p_object_version_number
514: );
515: hr_utility.set_location(l_proc,20);
516: --
517: -- Only proceed with SQL validation if absolutely necessary
518: --
519: if ((l_api_updating and

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

520: nvl(pay_bct_shd.g_old_rec.control_type,hr_api.g_varchar2) <>
521: nvl(p_control_type,hr_api.g_varchar2))
522: or (NOT l_api_updating)) then
523: --
524: hr_utility.set_location(l_proc,30);
525: --
526: -- Validate against the hr_lookup.
527: --
528: if (p_control_type is not null) then

Line 530: hr_utility.set_location(l_proc,35);

526: -- Validate against the hr_lookup.
527: --
528: if (p_control_type is not null) then
529: --
530: hr_utility.set_location(l_proc,35);
531: --
532: -- Validate against the hr_lookup.
533: --
534: if hr_api.not_exists_in_hr_lookups

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

543: end if;
544: --
545: end if;
546: --
547: hr_utility.set_location(' Leaving:'||l_proc, 40);
548: --
549: end chk_control_type;
550: --
551: -- added for bug 6013383

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

571:
572: --
573: begin
574:
575: hr_utility.set_location('Entering:'||l_proc, 10);
576: --
577: l_control_total_dup := p_control_total ;
578:
579: -- gets currency_code

Line 589: hr_utility.set_location('Validating Control_Total Number format' || l_proc ,20) ;

585: --
586:
587: if p_control_type like '%_TOTAL_%' OR p_control_type like '%_COUNT_%' then
588:
589: hr_utility.set_location('Validating Control_Total Number format' || l_proc ,20) ;
590:
591: hr_chkfmt.checkformat ( l_control_total_dup ,
592: 'NUMBER' ,
593: l_control_total_dup1,

Line 602: hr_utility.set_location(' Leaving:'||l_proc, 30);

598: null );
599:
600: end if;
601: --
602: hr_utility.set_location(' Leaving:'||l_proc, 30);
603: --
604: end chk_control_total;
605: --
606: -- ---------------------------------------------------------------------------

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

645: where pml.source_id = p_batch_control_id
646: and pml.source_type = 'C';
647: --
648: begin
649: hr_utility.set_location('Entering:'||l_proc, 1);
650: --
651: -- Check mandatory session_date exists
652: --
653: hr_api.mandatory_arg_error

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

655: ,p_argument => 'batch_control_id'
656: ,p_argument_value => p_batch_control_id
657: );
658: --
659: hr_utility.set_location('Entering:'||l_proc, 10);
660: --
661: open csr_message_lines;
662: --
663: fetch csr_message_lines into l_exists;

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

672: End If;
673: --
674: close csr_message_lines;
675: --
676: hr_utility.set_location(' Leaving:'||l_proc, 20);
677: --
678: end chk_delete;
679: --
680: -- ----------------------------------------------------------------------------

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

687: --
688: l_proc varchar2(72) := g_package||'insert_validate';
689: --
690: Begin
691: hr_utility.set_location('Entering:'||l_proc, 5);
692: --
693: -- Call all supporting business operations
694: --
695: --

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

692: --
693: -- Call all supporting business operations
694: --
695: --
696: hr_utility.set_location(l_proc, 10);
697: --
698: chk_batch_id(p_batch_control_id => p_rec.batch_control_id
699: ,p_batch_id => p_rec.batch_id);
700: --

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

699: ,p_batch_id => p_rec.batch_id);
700: --
701: pay_bth_bus.set_security_group_id(p_batch_id => p_rec.batch_id);
702: --
703: hr_utility.set_location(l_proc, 20);
704: --
705: chk_control_status(p_control_status => p_rec.control_status
706: ,p_session_date => p_session_date
707: ,p_batch_control_id => p_rec.batch_control_id

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

706: ,p_session_date => p_session_date
707: ,p_batch_control_id => p_rec.batch_control_id
708: ,p_object_version_number => p_rec.object_version_number);
709: --
710: hr_utility.set_location(l_proc, 30);
711: --
712: chk_control_type(p_control_type => p_rec.control_type
713: ,p_session_date => p_session_date
714: ,p_batch_control_id => p_rec.batch_control_id

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

720: p_control_total => p_rec.control_total,
721: p_batch_id => p_rec.batch_id
722: );
723: --
724: hr_utility.set_location(' Leaving:'||l_proc, 40);
725: End insert_validate;
726: --
727: -- ----------------------------------------------------------------------------
728: -- |---------------------------< update_validate >----------------------------|

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

734: --
735: l_proc varchar2(72) := g_package||'update_validate';
736: --
737: Begin
738: hr_utility.set_location('Entering:'||l_proc, 5);
739: --
740: -- Call all supporting business operations
741: --
742: --

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

745: chk_non_updateable_args
746: (p_rec => p_rec
747: );
748: --
749: hr_utility.set_location(l_proc, 20);
750: --
751: --
752: chk_transferred_status(p_batch_control_id => p_rec.batch_control_id);
753: --

Line 754: hr_utility.set_location(l_proc, 25);

750: --
751: --
752: chk_transferred_status(p_batch_control_id => p_rec.batch_control_id);
753: --
754: hr_utility.set_location(l_proc, 25);
755: --
756: chk_control_status(p_control_status => p_rec.control_status
757: ,p_session_date => p_session_date
758: ,p_batch_control_id => p_rec.batch_control_id

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

757: ,p_session_date => p_session_date
758: ,p_batch_control_id => p_rec.batch_control_id
759: ,p_object_version_number => p_rec.object_version_number);
760: --
761: hr_utility.set_location(l_proc, 30);
762: --
763: chk_control_type(p_control_type => p_rec.control_type
764: ,p_session_date => p_session_date
765: ,p_batch_control_id => p_rec.batch_control_id

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

771: p_control_total => p_rec.control_total,
772: p_batch_id => p_rec.batch_id
773: );
774: --
775: hr_utility.set_location(' Leaving:'||l_proc, 40);
776: End update_validate;
777: --
778: -- ----------------------------------------------------------------------------
779: -- |---------------------------< delete_validate >----------------------------|

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

784: --
785: l_proc varchar2(72) := g_package||'delete_validate';
786: --
787: Begin
788: hr_utility.set_location('Entering:'||l_proc, 5);
789: --
790: -- Call all supporting business operations
791: --
792: --

Line 797: hr_utility.set_location(l_proc, 25);

793: if payplnk.g_payplnk_call <> true then
794: chk_transferred_status(p_batch_control_id => p_rec.batch_control_id);
795: end if;
796: --
797: hr_utility.set_location(l_proc, 25);
798: --
799: chk_delete(p_batch_control_id => p_rec.batch_control_id);
800: --
801: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

797: hr_utility.set_location(l_proc, 25);
798: --
799: chk_delete(p_batch_control_id => p_rec.batch_control_id);
800: --
801: hr_utility.set_location(' Leaving:'||l_proc, 10);
802: End delete_validate;
803: --
804: end pay_bct_bus;