DBA Data[Home] [Help]

APPS.PER_PJI_BUS dependencies on HR_UTILITY

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

52: --
53: l_proc varchar2(72) := g_package||'chk_previous_job_id';
54: l_api_updating boolean;
55: begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: hr_utility.set_location(l_proc, 10);
59: l_api_updating
60: := per_pji_shd.api_updating(p_previous_job_extra_info_id

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

54: l_api_updating boolean;
55: begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: hr_utility.set_location(l_proc, 10);
59: l_api_updating
60: := per_pji_shd.api_updating(p_previous_job_extra_info_id
61: => p_previous_job_extra_info_id
62: ,p_object_version_number

Line 70: hr_utility.set_location(l_proc, 15);

66: and nvl(per_pji_shd.g_old_rec.previous_job_id, hr_api.g_number)
67: <> nvl(p_previous_job_id,hr_api.g_number))
68: or
69: (not l_api_updating)) then
70: hr_utility.set_location(l_proc, 15);
71: open csr_previous_job_id;
72: fetch csr_previous_job_id into l_previous_job_id;
73: if csr_previous_job_id%notfound then
74: hr_utility.set_location(l_proc, 20);

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

70: hr_utility.set_location(l_proc, 15);
71: open csr_previous_job_id;
72: fetch csr_previous_job_id into l_previous_job_id;
73: if csr_previous_job_id%notfound then
74: hr_utility.set_location(l_proc, 20);
75: close csr_previous_job_id;
76: fnd_message.set_name('PER','HR_289540_PJI_INV_PREV_JOB_ID');
77: fnd_message.raise_error;
78: end if;

Line 84: hr_utility.set_location('Leaving:'||l_proc, 25);

80: close csr_previous_job_id;
81: end if;
82: end if;
83: --
84: hr_utility.set_location('Leaving:'||l_proc, 25);
85: exception
86: when others then
87: raise;
88: end chk_previous_job_id;

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

129: --
130: l_proc varchar2(72) := g_package||'chk_information_type';
131: l_api_updating boolean;
132: begin
133: hr_utility.set_location('Entering:'||l_proc, 5);
134: --
135: hr_utility.set_location(l_proc, 10);
136: l_api_updating
137: := per_pji_shd.api_updating(p_previous_job_extra_info_id

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

131: l_api_updating boolean;
132: begin
133: hr_utility.set_location('Entering:'||l_proc, 5);
134: --
135: hr_utility.set_location(l_proc, 10);
136: l_api_updating
137: := per_pji_shd.api_updating(p_previous_job_extra_info_id
138: => p_previous_job_extra_info_id
139: ,p_object_version_number

Line 147: hr_utility.set_location(l_proc, 15);

143: and nvl(per_pji_shd.g_old_rec.information_type, hr_api.g_varchar2)
144: <> nvl(p_information_type,hr_api.g_varchar2))
145: or
146: (not l_api_updating)) then
147: hr_utility.set_location(l_proc, 15);
148: open csr_information_type;
149: fetch csr_information_type into l_information_type;
150: if csr_information_type%notfound then
151: hr_utility.set_location(l_proc, 20);

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

147: hr_utility.set_location(l_proc, 15);
148: open csr_information_type;
149: fetch csr_information_type into l_information_type;
150: if csr_information_type%notfound then
151: hr_utility.set_location(l_proc, 20);
152: close csr_information_type;
153: fnd_message.set_name('PER','HR_289539_PJI_INV_INFO_TYPE');
154: fnd_message.raise_error;
155: end if;

Line 161: hr_utility.set_location('Leaving:'||l_proc, 25);

157: close csr_information_type;
158: end if;
159: end if;
160: --
161: hr_utility.set_location('Leaving:'||l_proc, 25);
162: exception
163: when others then
164: raise;
165: end chk_information_type;

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

191: l_proc varchar2(72) := g_package||'set_security_group_id';
192: --
193: begin
194: --
195: hr_utility.set_location('Entering:'|| l_proc, 10);
196: --
197: -- Ensure that all the mandatory parameter are not null
198: --
199: hr_api.mandatory_arg_error

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

222: hr_api.set_security_group_id
223: (p_security_group_id => l_security_group_id
224: );
225: --
226: hr_utility.set_location(' Leaving:'|| l_proc, 20);
227: --
228: end set_security_group_id;
229: --
230: -- ---------------------------------------------------------------------------

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

254: l_proc varchar2(72) := g_package||'return_legislation_code';
255: --
256: Begin
257: --
258: hr_utility.set_location('Entering:'|| l_proc, 10);
259: --
260: -- Ensure that all the mandatory parameter are not null
261: --
262: hr_api.mandatory_arg_error

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

272: -- call to this function. Just return the value in the global
273: -- variable.
274: --
275: l_legislation_code := per_pji_bus.g_legislation_code;
276: hr_utility.set_location(l_proc, 20);
277: else
278: --
279: -- The ID is different to the last call to this function
280: -- or this is the first call to this function.

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

289: close csr_leg_code;
290: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
291: fnd_message.raise_error;
292: end if;
293: hr_utility.set_location(l_proc,30);
294: --
295: -- Set the global variables so the values are
296: -- available for the next call to this function.
297: --

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

298: close csr_leg_code;
299: per_pji_bus.g_previous_job_extra_info_id := p_previous_job_extra_info_id;
300: per_pji_bus.g_legislation_code := l_legislation_code;
301: end if;
302: hr_utility.set_location(' Leaving:'|| l_proc, 40);
303: return l_legislation_code;
304: end return_legislation_code;
305: --
306: -- ----------------------------------------------------------------------------

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

337: --
338: l_proc varchar2(72) := g_package || 'chk_ddf';
339: --
340: begin
341: hr_utility.set_location('Entering:'||l_proc,10);
342: --
343: if ((p_rec.previous_job_extra_info_id is not null) and (
344: nvl(per_pji_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
345: nvl(p_rec.information_type, hr_api.g_varchar2) or

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

478: ,p_attribute30_value => p_rec.pji_information30
479: );
480: end if;
481: --
482: hr_utility.set_location(' Leaving:'||l_proc,20);
483: end chk_ddf;
484: --
485: -- ----------------------------------------------------------------------------
486: -- |------------------------------< chk_df >----------------------------------|

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

516: --
517: l_proc varchar2(72) := g_package || 'chk_df';
518: --
519: begin
520: hr_utility.set_location('Entering:'||l_proc,10);
521: --
522: if ((p_rec.previous_job_extra_info_id is not null) and (
523: nvl(per_pji_shd.g_old_rec.pji_attribute_category, hr_api.g_varchar2) <>
524: nvl(p_rec.pji_attribute_category, hr_api.g_varchar2) or

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

655: ,p_attribute30_value => p_rec.pji_attribute30
656: );
657: end if;
658: --
659: hr_utility.set_location(' Leaving:'||l_proc,20);
660: end chk_df;
661: --
662: -- ----------------------------------------------------------------------------
663: -- |-----------------------< chk_non_updateable_args >------------------------|

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

734: (p_rec in per_pji_shd.g_rec_type) is
735: l_proc varchar2(72) := g_package||'insert_validate';
736: --
737: Begin
738: hr_utility.set_location('Entering:'||l_proc, 5);
739: --
740: -- Check whether the Previous Job Id is Valid
741: hr_api.mandatory_arg_error
742: (p_api_name => l_proc

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

749: ,p_argument => 'information_type'
750: ,p_argument_value => p_rec.information_type
751: );
752: --
753: hr_utility.set_location(l_proc, 10);
754: chk_previous_job_id(p_previous_job_id
755: => p_rec.previous_job_id
756: ,p_previous_job_extra_info_id
757: => p_rec.previous_job_extra_info_id

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

757: => p_rec.previous_job_extra_info_id
758: ,p_object_version_number
759: => p_rec.object_version_number);
760: -- Check for valid Information Types for selected Previous Job
761: hr_utility.set_location(l_proc, 15);
762: chk_information_type(p_previous_job_extra_info_id
763: => p_rec.previous_job_extra_info_id
764: ,p_object_version_number
765: => p_rec.object_version_number

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

765: => p_rec.object_version_number
766: ,p_information_type
767: => p_rec.information_type);
768: -- Call all supporting business operations
769: hr_utility.set_location(l_proc, 20);
770: per_pji_bus.chk_ddf(p_rec);
771: --
772: hr_utility.set_location(l_proc, 25);
773: per_pji_bus.chk_df(p_rec);

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

768: -- Call all supporting business operations
769: hr_utility.set_location(l_proc, 20);
770: per_pji_bus.chk_ddf(p_rec);
771: --
772: hr_utility.set_location(l_proc, 25);
773: per_pji_bus.chk_df(p_rec);
774: --
775: hr_utility.set_location(' Leaving:'||l_proc, 30);
776: End insert_validate;

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

771: --
772: hr_utility.set_location(l_proc, 25);
773: per_pji_bus.chk_df(p_rec);
774: --
775: hr_utility.set_location(' Leaving:'||l_proc, 30);
776: End insert_validate;
777: --
778: -- ----------------------------------------------------------------------------
779: -- |---------------------------< update_validate >----------------------------|

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

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

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

800: ,p_argument => 'information_type'
801: ,p_argument_value => p_rec.information_type
802: );
803: --
804: hr_utility.set_location(l_proc, 10);
805: chk_non_updateable_args(p_rec => p_rec);
806: -- Check for valid Information Types for selected Previous Job
807: hr_utility.set_location(l_proc, 20);
808: chk_information_type(p_previous_job_extra_info_id

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

803: --
804: hr_utility.set_location(l_proc, 10);
805: chk_non_updateable_args(p_rec => p_rec);
806: -- Check for valid Information Types for selected Previous Job
807: hr_utility.set_location(l_proc, 20);
808: chk_information_type(p_previous_job_extra_info_id
809: => p_rec.previous_job_extra_info_id
810: ,p_object_version_number
811: => p_rec.object_version_number

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

811: => p_rec.object_version_number
812: ,p_information_type
813: => p_rec.information_type);
814: --
815: hr_utility.set_location(l_proc, 25);
816: per_pji_bus.chk_ddf(p_rec);
817: --
818: hr_utility.set_location(l_proc, 30);
819: per_pji_bus.chk_df(p_rec);

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

814: --
815: hr_utility.set_location(l_proc, 25);
816: per_pji_bus.chk_ddf(p_rec);
817: --
818: hr_utility.set_location(l_proc, 30);
819: per_pji_bus.chk_df(p_rec);
820: --
821: hr_utility.set_location(' Leaving:'||l_proc, 35);
822: End update_validate;

Line 821: hr_utility.set_location(' Leaving:'||l_proc, 35);

817: --
818: hr_utility.set_location(l_proc, 30);
819: per_pji_bus.chk_df(p_rec);
820: --
821: hr_utility.set_location(' Leaving:'||l_proc, 35);
822: End update_validate;
823: --
824: -- ----------------------------------------------------------------------------
825: -- |---------------------------< delete_validate >----------------------------|

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

830: --
831: l_proc varchar2(72) := g_package||'delete_validate';
832: --
833: Begin
834: hr_utility.set_location('Entering:'||l_proc, 5);
835: --
836: -- Call all supporting business operations
837: --
838: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

834: hr_utility.set_location('Entering:'||l_proc, 5);
835: --
836: -- Call all supporting business operations
837: --
838: hr_utility.set_location(' Leaving:'||l_proc, 10);
839: End delete_validate;
840: --
841: end per_pji_bus;