DBA Data[Home] [Help]

APPS.PER_CHK_BUS dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

142: close csr_leg_code;
143: per_chk_bus.g_checklist_item_id := p_checklist_item_id;
144: per_chk_bus.g_legislation_code := l_legislation_code;
145: end if;
146: hr_utility.set_location(' Leaving:'|| l_proc, 40);
147: return l_legislation_code;
148: end return_legislation_code;
149: --
150: --

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

182: l_error exception;
183: l_argument varchar2(30);
184: --
185: Begin
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: --
188: -- Only proceed with validation if a row exists for
189: -- the current record in the HR Schema
190: --

Line 199: hr_utility.set_location(l_proc, 6);

195: fnd_message.set_token('PROCEDURE', l_proc);
196: fnd_message.set_token('STEP', '5');
197: end if;
198: --
199: hr_utility.set_location(l_proc, 6);
200: --
201: if nvl(p_rec.checklist_item_id,hr_api.g_number)
202: <> nvl(per_chk_shd.g_old_rec.checklist_item_id,hr_api.g_number) then
203: l_argument := 'checklist_item_id';

Line 206: hr_utility.set_location(l_proc, 7);

202: <> nvl(per_chk_shd.g_old_rec.checklist_item_id,hr_api.g_number) then
203: l_argument := 'checklist_item_id';
204: raise l_error;
205: end if;
206: hr_utility.set_location(l_proc, 7);
207: --
208: if nvl(p_rec.person_id,hr_api.g_number)
209: <> nvl(per_chk_shd.g_old_rec.person_id,hr_api.g_number) then
210: l_argument := 'person_id';

Line 213: hr_utility.set_location(l_proc, 8);

209: <> nvl(per_chk_shd.g_old_rec.person_id,hr_api.g_number) then
210: l_argument := 'person_id';
211: raise l_error;
212: end if;
213: hr_utility.set_location(l_proc, 8);
214: --
215: if nvl(p_rec.item_code,hr_api.g_varchar2)
216: <> nvl(per_chk_shd.g_old_rec.item_code,hr_api.g_varchar2) then
217: l_argument := 'item_code';

Line 220: hr_utility.set_location(l_proc, 9);

216: <> nvl(per_chk_shd.g_old_rec.item_code,hr_api.g_varchar2) then
217: l_argument := 'item_code';
218: raise l_error;
219: end if;
220: hr_utility.set_location(l_proc, 9);
221: --
222: exception
223: when l_error then
224: hr_api.argument_changed_error

Line 229: hr_utility.set_location(' Leaving:'||l_proc, 14);

225: (p_api_name => l_proc
226: ,p_argument => l_argument);
227: when others then
228: raise;
229: hr_utility.set_location(' Leaving:'||l_proc, 14);
230: end chk_non_updateable_args;
231: --
232: --
233: -- ----------------------------------------------------------------------------

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

265: l_person_id per_checklist_items.person_id%TYPE;
266:
267: Begin
268: --
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: --
272: hr_utility.set_location('At:'||l_proc, 30);
273:

Line 272: hr_utility.set_location('At:'||l_proc, 30);

268: --
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: --
272: hr_utility.set_location('At:'||l_proc, 30);
273:
274: OPEN chk_valid_person ;
275: FETCH chk_valid_person into l_person_id;
276: IF chk_valid_person%NOTFOUND THEN

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

281: END IF;
282:
283: CLOSE chk_valid_person;
284:
285: hr_utility.set_location('Leaving:'||l_proc, 10);
286: --
287: End chk_is_person_valid;
288: --
289: -- ----------------------------------------------------------------------------

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

315: l_proc varchar2(72) := g_package||'chk_is_status_valid';
316: --
317: Begin
318: --
319: hr_utility.set_location('Entering:'||l_proc, 5);
320: --
321: if (p_checklist_item_id is not null and p_status is not null and
322: (nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
323: <> nvl(p_status,hr_api.g_varchar2)))

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

333: END IF;
334:
335: end if;
336: --
337: hr_utility.set_location('Leaving:'||l_proc, 10);
338: --
339: End chk_is_status_valid;
340: --
341: -- ----------------------------------------------------------------------------

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

370: l_proc varchar2(72) := g_package||'chk_is_itemcode_valid';
371:
372: Begin
373: --
374: hr_utility.set_location('Entering:'||l_proc, 10);
375:
376: -- Checking to see if the item code is valid
377: IF hr_api.not_exists_in_hr_lookups( p_effective_date => p_effective_date,
378: p_lookup_type => 'CHECKLIST_ITEM',

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

388: -- This check will be done during the insert_dml
389: -- PER_CHECKLIST_ITEMS_U1
390:
391: --
392: hr_utility.set_location('Leaving:'||l_proc, 10);
393: --
394: End chk_is_itemcode_valid;
395: --
396: -- -----------------------------------------------------------------------

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

428: l_proc varchar2(72) := g_package||'chk_df';
429: --
430: begin
431: --
432: hr_utility.set_location('Entering:'||l_proc, 10);
433: --
434: -- if inserting and not required to validate flex data
435: -- then ensure all flex data passed is null
436: --

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

658: ,p_attribute30_value => p_rec.attribute30
659: );
660: End if;
661: --
662: hr_utility.set_location(' Leaving:'||l_proc, 20);
663: --
664: end chk_df;
665: --
666: -- ----------------------------------------------------------------------------

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

671: --
672: l_proc varchar2(72) := g_package||'insert_validate';
673: --
674: Begin
675: hr_utility.set_location('Entering:'||l_proc, 5);
676: --
677: -- Check mandatory arguments have been set
678: --
679: hr_api.mandatory_arg_error

Line 698: hr_utility.set_location('At:'||l_proc, 6);

694: ,p_argument_value => p_rec.item_code
695: );
696:
697: -- Checking whether the person id is valid
698: hr_utility.set_location('At:'||l_proc, 6);
699:
700: chk_is_person_valid
701: (p_effective_date => p_effective_date,
702: p_person_id => p_rec.person_id);

Line 718: hr_utility.set_location('At :'||l_proc, 10);

714:
715: -- Checking whether the item code for that particular person
716: -- is unique , not null and valid
717:
718: hr_utility.set_location('At :'||l_proc, 10);
719:
720: chk_is_itemcode_valid
721: (p_effective_date => p_effective_date,
722: p_item_code => p_rec.item_code);

Line 726: hr_utility.set_location('At :'||l_proc, 15);

722: p_item_code => p_rec.item_code);
723:
724: -- Checking whether the status code is valid and not null
725:
726: hr_utility.set_location('At :'||l_proc, 15);
727:
728: chk_is_status_valid(p_effective_date => p_effective_date,
729: p_checklist_item_id => p_rec.checklist_item_id,
730: p_status => p_rec.status );

Line 734: hr_utility.set_location('At :'||l_proc, 20);

730: p_status => p_rec.status );
731:
732: -- Validating the desc flex values
733:
734: hr_utility.set_location('At :'||l_proc, 20);
735:
736: chk_df(p_rec => p_rec
737: ,p_validate_df_flex => TRUE);
738:

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

735:
736: chk_df(p_rec => p_rec
737: ,p_validate_df_flex => TRUE);
738:
739: hr_utility.set_location(' Leaving:'||l_proc, 30);
740:
741: End insert_validate;
742: --
743: -- ----------------------------------------------------------------------------

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

748: --
749: l_proc varchar2(72) := g_package||'update_validate';
750: --
751: Begin
752: hr_utility.set_location('Entering:'||l_proc, 5);
753: --
754: -- Check mandatory arguments have been set
755: --
756: hr_api.mandatory_arg_error

Line 788: hr_utility.set_location('At :'||l_proc, 20);

784: p_person_id => p_rec.person_id
785: );
786: -- Checking whether the status code is valid and not null
787:
788: hr_utility.set_location('At :'||l_proc, 20);
789:
790: chk_is_status_valid(p_effective_date => p_effective_date,
791: p_checklist_item_id => p_rec.checklist_item_id,
792: p_status => p_rec.status );

Line 796: hr_utility.set_location('At :'||l_proc, 25);

792: p_status => p_rec.status );
793:
794: -- Validating the desc flex values
795:
796: hr_utility.set_location('At :'||l_proc, 25);
797:
798: chk_df(p_rec => p_rec
799: ,p_validate_df_flex => TRUE);
800: --

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

797:
798: chk_df(p_rec => p_rec
799: ,p_validate_df_flex => TRUE);
800: --
801: hr_utility.set_location(' Leaving:'||l_proc, 30);
802: End update_validate;
803: --
804: -- ----------------------------------------------------------------------------
805: -- |---------------------------< delete_validate >----------------------------|

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

808: --
809: l_proc varchar2(72) := g_package||'delete_validate';
810: --
811: Begin
812: hr_utility.set_location('Entering:'||l_proc, 5);
813: hr_utility.set_location(' Leaving:'||l_proc, 10);
814: End delete_validate;
815: --
816: end per_chk_bus;

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

809: l_proc varchar2(72) := g_package||'delete_validate';
810: --
811: Begin
812: hr_utility.set_location('Entering:'||l_proc, 5);
813: hr_utility.set_location(' Leaving:'||l_proc, 10);
814: End delete_validate;
815: --
816: end per_chk_bus;