eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_SPP_BUS dependencies on HR_UTILITY

Line 10: g_debug boolean := hr_utility.debug_enabled;

6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_spp_bus.'; -- Global package name
9: -- Start of 3335915
10: g_debug boolean := hr_utility.debug_enabled;
11: -- End of 3335915
12:
13: --
14: -- The following two global variables are only to be

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

77: and p_effective_date between
78: effective_start_date and effective_end_date;
79: --
80: begin
81: hr_utility.set_location('Entering:'|| l_proc, 10);
82: --
83: -- Check mandatory parameters have been set
84: --
85: hr_api.mandatory_arg_error

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

87: ,p_argument => 'assignment_id'
88: ,p_argument_value => p_assignment_id
89: );
90: --
91: hr_utility.set_location(l_proc, 20);
92: --
93: -- Check if inserting or updating with modified values
94: --
95: l_api_updating := per_spp_shd.api_updating

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

101: if ((l_api_updating and per_spp_shd.g_old_rec.assignment_id <> p_assignment_id)
102: or
103: (NOT l_api_updating))
104: then
105: hr_utility.set_location(l_proc, 30);
106: --
107: -- Check that the Assignment ID is linked to a
108: -- valid assignment_id on per_all_assignments
109: --

Line 116: hr_utility.raise_error;

112: if csr_valid_assignment_id%notfound then
113: --
114: close csr_valid_assignment_id;
115: fnd_message.set_name('PER', 'HR_289224_SPP_ASSIGNMENT_CHK');
116: hr_utility.raise_error;
117: --
118: else
119: close csr_valid_assignment_id;
120: if(p_datetrack_mode = 'INSERT') then

Line 127: hr_utility.raise_error;

123: if csr_placement_exists%found then
124: --
125: close csr_placement_exists;
126: fnd_message.set_name('PER', 'HR_289225_SPP_PLACEMENT_EXIST');
127: hr_utility.raise_error;
128: --
129: else
130: close csr_placement_exists;
131: end if;

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

132: end if;
133: end if;
134: end if;
135: --
136: hr_utility.set_location(' Leaving:'|| l_proc, 40);
137: end chk_assignment_id;
138: --
139: -- ---------------------------------------------------------------------------
140: -- |-----------------------< chk_pay_ass_ceiling >--------------------------|

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

201: and pgs.effective_end_date;
202: --
203: begin
204: --
205: hr_utility.set_location('Entering:'|| l_proc, 10);
206: --
207: -- Check mandatory parameters have been set
208: --
209: hr_api.mandatory_arg_error

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

223: ,p_argument => 'parent_spine_id'
224: ,p_argument_value => p_parent_spine_id
225: );
226: --
227: hr_utility.set_location(l_proc, 20);
228: --
229: -- First check if a special ceiling has been entered, if so then use this
230: -- ceiling instead of grade ceiling, else use the grade ceiling
231: --

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

233: fetch csr_special_ceiling into l_assignment_ceiling, l_grade_id;
234: --
235: if l_assignment_ceiling is null then
236: --
237: hr_utility.set_location(l_proc,30);
238: --
239: -- Use the grade scale ceiling
240: --
241: open csr_grade_ceiling;

Line 245: hr_utility.set_location(l_proc||' Grade Ceiling - '||l_grade_ceiling,40);

241: open csr_grade_ceiling;
242: fetch csr_grade_ceiling into l_grade_ceiling;
243: close csr_grade_ceiling;
244: --
245: hr_utility.set_location(l_proc||' Grade Ceiling - '||l_grade_ceiling,40);
246: --
247: l_ceiling_to_use := l_grade_ceiling;
248: --
249: elsif csr_special_ceiling%found then

Line 251: hr_utility.set_location(l_proc,50);

247: l_ceiling_to_use := l_grade_ceiling;
248: --
249: elsif csr_special_ceiling%found then
250: --
251: hr_utility.set_location(l_proc,50);
252: --
253: l_ceiling_to_use := l_assignment_ceiling;
254: --
255: end if;

Line 259: hr_utility.set_location('l_ceiling_to_use - '||l_ceiling_to_use,60);

255: end if;
256: --
257: close csr_special_ceiling;
258: --
259: hr_utility.set_location('l_ceiling_to_use - '||l_ceiling_to_use,60);
260: -- --------------------------------------------------------------------------
261: -- Procedure done every time an update occurs as it is possible to
262: -- be on a step id and then assign a step id as the limit which is below
263: -- the current step id, in which case it needs to through an error

Line 291: hr_utility.raise_error;

287: -- compare the two ceiling step_id's to the passed step_id
288: -- --------------------------------------------------------------------------
289: if (l_step_number > max_ceiling_number) then
290: fnd_message.set_name('PER', 'HR_289276_SPP_CEILING_CHK');
291: hr_utility.raise_error;
292: end if;
293: --
294: hr_utility.set_location(' Leaving:'|| l_proc, 999);
295: --

Line 294: hr_utility.set_location(' Leaving:'|| l_proc, 999);

290: fnd_message.set_name('PER', 'HR_289276_SPP_CEILING_CHK');
291: hr_utility.raise_error;
292: end if;
293: --
294: hr_utility.set_location(' Leaving:'|| l_proc, 999);
295: --
296: end chk_pay_ass_ceiling;
297: --
298: -- ---------------------------------------------------------------------------

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

333: l_proc varchar2(72) := g_package||'chk_reason';
334: --
335: BEGIN
336: --
337: hr_utility.set_location('Entering:'||l_proc, 10);
338: --
339: -- Only proceed with validation if :
340: -- there is a reason being passed
341: --

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

340: -- there is a reason being passed
341: --
342: IF (p_reason is not null) then
343: --
344: hr_utility.set_location(l_proc, 20);
345: --
346: -- Check that the reason type exists in HR_LOOKUPS
347: --
348: IF hr_api.not_exists_in_hr_lookups

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

349: (p_effective_date => p_effective_date
350: ,p_lookup_type => 'PLACEMENT_REASON'
351: ,p_lookup_code => p_reason) THEN
352: --
353: hr_utility.set_location(l_proc, 30);
354: --
355: fnd_message.set_name('PER', 'HR_289266_SPP_INVAL_REASON');
356: hr_utility.raise_error;
357: --

Line 356: hr_utility.raise_error;

352: --
353: hr_utility.set_location(l_proc, 30);
354: --
355: fnd_message.set_name('PER', 'HR_289266_SPP_INVAL_REASON');
356: hr_utility.raise_error;
357: --
358: END IF;
359: --
360: END IF;

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

358: END IF;
359: --
360: END IF;
361: --
362: hr_utility.set_location(' Leaving:'||l_proc, 40);
363: --
364: END chk_reason;
365: -- ---------------------------------------------------------------------------
366: -- |--------------------< chk_object_version_number >-----------------------|

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

413:
414:
415:
416: begin
417: hr_utility.set_location('Entering:'|| l_proc, 10);
418: --
419: -- Check mandatory parameters have been set
420: --
421: hr_api.mandatory_arg_error

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

423: ,p_argument => 'object_version_number'
424: ,p_argument_value => p_object_version_number
425: );
426: --
427: hr_utility.set_location(l_proc, 20);
428: --
429: -- Check if inserting or updating with modified values
430: --
431: l_api_updating := per_spp_shd.api_updating

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

433: ,p_effective_date => p_effective_date
434: ,p_object_version_number => p_object_version_number
435: );
436: --
437: hr_utility.set_location(l_proc, 30);
438: --
439: -- Check that the object version number is correct for the effective date
440: --
441: open csr_valid_ovn;

Line 447: hr_utility.raise_error;

443: if csr_valid_ovn%notfound then
444: --
445: close csr_valid_ovn;
446: fnd_message.set_name('PER', 'HR_289256_SPP_OBJECT_VER_NUM');
447: hr_utility.raise_error;
448: --
449: else
450: close csr_valid_ovn;
451: end if;

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

449: else
450: close csr_valid_ovn;
451: end if;
452: --
453: hr_utility.set_location(' Leaving:'|| l_proc, 40);
454: end chk_object_version_number;
455: --
456: -- ---------------------------------------------------------------------------
457: -- |-------------------------< chk_auto_inc_flag >--------------------------|

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

493: l_effective_date date := sysdate; -- not used
494: --
495: --
496: begin
497: hr_utility.set_location('Entering:'|| l_proc, 10);
498: --
499: -- Check mandatory parameters have been set
500: --
501: hr_api.mandatory_arg_error

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

503: ,p_argument => 'auto_increment_flag'
504: ,p_argument_value => p_auto_increment_flag
505: );
506: --
507: hr_utility.set_location(l_proc, 20);
508: hr_utility.set_location('p_increment_number:'||p_increment_number,23);
509: hr_utility.set_location('p_auto_increment_flag:'||p_auto_increment_flag, 24);
510: /*
511: -- The following section was commited out to deal with old records.

Line 508: hr_utility.set_location('p_increment_number:'||p_increment_number,23);

504: ,p_argument_value => p_auto_increment_flag
505: );
506: --
507: hr_utility.set_location(l_proc, 20);
508: hr_utility.set_location('p_increment_number:'||p_increment_number,23);
509: hr_utility.set_location('p_auto_increment_flag:'||p_auto_increment_flag, 24);
510: /*
511: -- The following section was commited out to deal with old records.
512: -- Increment Number is a new column and so there are cases where auto_inc_flag

Line 509: hr_utility.set_location('p_auto_increment_flag:'||p_auto_increment_flag, 24);

505: );
506: --
507: hr_utility.set_location(l_proc, 20);
508: hr_utility.set_location('p_increment_number:'||p_increment_number,23);
509: hr_utility.set_location('p_auto_increment_flag:'||p_auto_increment_flag, 24);
510: /*
511: -- The following section was commited out to deal with old records.
512: -- Increment Number is a new column and so there are cases where auto_inc_flag
513: -- will be 'Y' and not changed and the user does not enter a increment number

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

529: */
530: --
531: --
532:
533: hr_utility.set_location(l_proc, 30);
534: hr_utility.set_location('Auto Increment Flag:'||p_auto_increment_flag,31);
535: --
536: -- Check that the Auto Increment Flag is 'Y' or 'N'
537: If (p_auto_increment_flag not in ('Y','N') )

Line 534: hr_utility.set_location('Auto Increment Flag:'||p_auto_increment_flag,31);

530: --
531: --
532:
533: hr_utility.set_location(l_proc, 30);
534: hr_utility.set_location('Auto Increment Flag:'||p_auto_increment_flag,31);
535: --
536: -- Check that the Auto Increment Flag is 'Y' or 'N'
537: If (p_auto_increment_flag not in ('Y','N') )
538: --

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

536: -- Check that the Auto Increment Flag is 'Y' or 'N'
537: If (p_auto_increment_flag not in ('Y','N') )
538: --
539: then
540: hr_utility.set_location(l_proc, 35);
541: fnd_message.set_name('PER', 'HR_289223_SPP_AUTO_INC_FLG_CHK');
542: hr_utility.raise_error;
543: --
544: hr_utility.set_location(l_proc, 22);

Line 542: hr_utility.raise_error;

538: --
539: then
540: hr_utility.set_location(l_proc, 35);
541: fnd_message.set_name('PER', 'HR_289223_SPP_AUTO_INC_FLG_CHK');
542: hr_utility.raise_error;
543: --
544: hr_utility.set_location(l_proc, 22);
545: elsif (p_auto_increment_flag = 'Y') then
546: hr_utility.set_location(l_proc, 23);

Line 544: hr_utility.set_location(l_proc, 22);

540: hr_utility.set_location(l_proc, 35);
541: fnd_message.set_name('PER', 'HR_289223_SPP_AUTO_INC_FLG_CHK');
542: hr_utility.raise_error;
543: --
544: hr_utility.set_location(l_proc, 22);
545: elsif (p_auto_increment_flag = 'Y') then
546: hr_utility.set_location(l_proc, 23);
547: if (NVL(p_increment_number,0) <= 0) then
548: hr_utility.set_location(l_proc, 36);

Line 546: hr_utility.set_location(l_proc, 23);

542: hr_utility.raise_error;
543: --
544: hr_utility.set_location(l_proc, 22);
545: elsif (p_auto_increment_flag = 'Y') then
546: hr_utility.set_location(l_proc, 23);
547: if (NVL(p_increment_number,0) <= 0) then
548: hr_utility.set_location(l_proc, 36);
549: fnd_message.set_name('PER', 'HR_289243_SPP_INCREMENT_NUMBER');
550: hr_utility.raise_error;

Line 548: hr_utility.set_location(l_proc, 36);

544: hr_utility.set_location(l_proc, 22);
545: elsif (p_auto_increment_flag = 'Y') then
546: hr_utility.set_location(l_proc, 23);
547: if (NVL(p_increment_number,0) <= 0) then
548: hr_utility.set_location(l_proc, 36);
549: fnd_message.set_name('PER', 'HR_289243_SPP_INCREMENT_NUMBER');
550: hr_utility.raise_error;
551: end if;
552: hr_utility.set_location(l_proc, 40);

Line 550: hr_utility.raise_error;

546: hr_utility.set_location(l_proc, 23);
547: if (NVL(p_increment_number,0) <= 0) then
548: hr_utility.set_location(l_proc, 36);
549: fnd_message.set_name('PER', 'HR_289243_SPP_INCREMENT_NUMBER');
550: hr_utility.raise_error;
551: end if;
552: hr_utility.set_location(l_proc, 40);
553: end if;
554: -- end if;

Line 552: hr_utility.set_location(l_proc, 40);

548: hr_utility.set_location(l_proc, 36);
549: fnd_message.set_name('PER', 'HR_289243_SPP_INCREMENT_NUMBER');
550: hr_utility.raise_error;
551: end if;
552: hr_utility.set_location(l_proc, 40);
553: end if;
554: -- end if;
555: --
556: hr_utility.set_location(' Leaving:'|| l_proc, 45);

Line 556: hr_utility.set_location(' Leaving:'|| l_proc, 45);

552: hr_utility.set_location(l_proc, 40);
553: end if;
554: -- end if;
555: --
556: hr_utility.set_location(' Leaving:'|| l_proc, 45);
557: end chk_auto_inc_flag;
558: --
559: /*
560: -- Commented out as not going to inforce the reason for using 'REASON' to be

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

630: and effective_end_date;
631:
632:
633: begin
634: hr_utility.set_location(l_proc, 10);
635: --
636: -- Check that the record matches bar the reason
637: --
638: open csr_reason_1;

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

664:
665: end if;
666:
667: --
668: hr_utility.set_location(' Leaving:'|| l_proc, 40);
669: end chk_reason_only_update;
670: */
671: --
672: -- ---------------------------------------------------------------------------

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

759: and sps.effective_end_date;
760:
761:
762: begin
763: hr_utility.set_location('Entering:'|| l_proc, 10);
764: hr_utility.set_location('Step ID :'|| p_step_id, 10);
765: hr_utility.set_location('Parent Spine ID :'|| p_parent_spine_id,10);
766: hr_utility.set_location('Start Date in chk :'|| p_effective_start_date,10);
767: hr_utility.set_location('End Date :'|| p_effective_end_date,10);

Line 764: hr_utility.set_location('Step ID :'|| p_step_id, 10);

760:
761:
762: begin
763: hr_utility.set_location('Entering:'|| l_proc, 10);
764: hr_utility.set_location('Step ID :'|| p_step_id, 10);
765: hr_utility.set_location('Parent Spine ID :'|| p_parent_spine_id,10);
766: hr_utility.set_location('Start Date in chk :'|| p_effective_start_date,10);
767: hr_utility.set_location('End Date :'|| p_effective_end_date,10);
768: hr_utility.set_location('Placement ID :'|| p_placement_id,10);

Line 765: hr_utility.set_location('Parent Spine ID :'|| p_parent_spine_id,10);

761:
762: begin
763: hr_utility.set_location('Entering:'|| l_proc, 10);
764: hr_utility.set_location('Step ID :'|| p_step_id, 10);
765: hr_utility.set_location('Parent Spine ID :'|| p_parent_spine_id,10);
766: hr_utility.set_location('Start Date in chk :'|| p_effective_start_date,10);
767: hr_utility.set_location('End Date :'|| p_effective_end_date,10);
768: hr_utility.set_location('Placement ID :'|| p_placement_id,10);
769: --

Line 766: hr_utility.set_location('Start Date in chk :'|| p_effective_start_date,10);

762: begin
763: hr_utility.set_location('Entering:'|| l_proc, 10);
764: hr_utility.set_location('Step ID :'|| p_step_id, 10);
765: hr_utility.set_location('Parent Spine ID :'|| p_parent_spine_id,10);
766: hr_utility.set_location('Start Date in chk :'|| p_effective_start_date,10);
767: hr_utility.set_location('End Date :'|| p_effective_end_date,10);
768: hr_utility.set_location('Placement ID :'|| p_placement_id,10);
769: --
770: -- Check mandatory parameters have been set

Line 767: hr_utility.set_location('End Date :'|| p_effective_end_date,10);

763: hr_utility.set_location('Entering:'|| l_proc, 10);
764: hr_utility.set_location('Step ID :'|| p_step_id, 10);
765: hr_utility.set_location('Parent Spine ID :'|| p_parent_spine_id,10);
766: hr_utility.set_location('Start Date in chk :'|| p_effective_start_date,10);
767: hr_utility.set_location('End Date :'|| p_effective_end_date,10);
768: hr_utility.set_location('Placement ID :'|| p_placement_id,10);
769: --
770: -- Check mandatory parameters have been set
771: --

Line 768: hr_utility.set_location('Placement ID :'|| p_placement_id,10);

764: hr_utility.set_location('Step ID :'|| p_step_id, 10);
765: hr_utility.set_location('Parent Spine ID :'|| p_parent_spine_id,10);
766: hr_utility.set_location('Start Date in chk :'|| p_effective_start_date,10);
767: hr_utility.set_location('End Date :'|| p_effective_end_date,10);
768: hr_utility.set_location('Placement ID :'|| p_placement_id,10);
769: --
770: -- Check mandatory parameters have been set
771: --
772: hr_api.mandatory_arg_error

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

792: ,p_argument => 'effective_end_date'
793: ,p_argument_value => p_effective_end_date
794: );
795: --
796: hr_utility.set_location(l_proc, 20);
797: --
798: -- Check if inserting or updating with modified values
799: --
800: l_api_updating := per_spp_shd.api_updating

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

802: ,p_effective_date => l_effective_date
803: ,p_object_version_number => p_object_version_number
804: );
805: --
806: hr_utility.set_location(l_proc, 25);
807: --
808: if ((l_api_updating and (per_spp_shd.g_old_rec.parent_spine_id <> p_parent_spine_id)
809: or (per_spp_shd.g_old_rec.step_id <> p_step_id))
810: or

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

809: or (per_spp_shd.g_old_rec.step_id <> p_step_id))
810: or
811: (NOT l_api_updating))
812: then
813: hr_utility.set_location(l_proc, 30);
814: --
815: -- Check that the Parent Spine ID is linked to a
816: -- valid parent_spine_id on per_parent_spines table
817: -- and get the grade_spine_id from the per_grade_spines_f table

Line 844: hr_utility.raise_error;

840: end if;
841:
842: close csr_valid_parent_spine;
843:
844: hr_utility.raise_error;
845: --
846: else
847: close csr_valid_parent_spine_step_id;
848: end if;

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

848: end if;
849: --
850: end if;
851: --
852: hr_utility.set_location(' Leaving:'|| l_proc, 40);
853: end chk_parent_spine_step_id;
854: --
855: -- Start of fix for Bug 3335915
856: -- ----------------------------------------------------------------------------

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

937:
938:
939: begin
940: if g_debug then
941: hr_utility.set_location('Entering:'|| l_proc, 10);
942: hr_utility.set_location('p_placement_id'|| p_placement_id , 10);
943: hr_utility.set_location('p_effective_Date'|| p_effective_date , 10);
944: end if;
945: --

Line 942: hr_utility.set_location('p_placement_id'|| p_placement_id , 10);

938:
939: begin
940: if g_debug then
941: hr_utility.set_location('Entering:'|| l_proc, 10);
942: hr_utility.set_location('p_placement_id'|| p_placement_id , 10);
943: hr_utility.set_location('p_effective_Date'|| p_effective_date , 10);
944: end if;
945: --
946: -- IF delete mode is Delete next change,get the

Line 943: hr_utility.set_location('p_effective_Date'|| p_effective_date , 10);

939: begin
940: if g_debug then
941: hr_utility.set_location('Entering:'|| l_proc, 10);
942: hr_utility.set_location('p_placement_id'|| p_placement_id , 10);
943: hr_utility.set_location('p_effective_Date'|| p_effective_date , 10);
944: end if;
945: --
946: -- IF delete mode is Delete next change,get the
947: -- EED of the next record. otherwise it has to be EOT.

Line 959: hr_utility.set_location( l_proc ||': l_end_date '|| to_char(l_end_date), 30);

955: end if;
956: close c_next_spp_eed;
957:
958: if g_debug then
959: hr_utility.set_location( l_proc ||': l_end_date '|| to_char(l_end_date), 30);
960: end if;
961:
962: end if; -- mode = DNC
963:

Line 972: hr_utility.set_location( l_proc ||': grade ID '|| to_char(l_grade_id), 40);

968: end if;
969: close c_curr_grade;
970:
971: if g_debug then
972: hr_utility.set_location( l_proc ||': grade ID '|| to_char(l_grade_id), 40);
973: hr_utility.set_location( l_proc ||': ASG ID '|| to_char(l_asg_id), 40);
974: end if;
975:
976: open c_future_grade_chg(p_grade_id =>l_grade_id

Line 973: hr_utility.set_location( l_proc ||': ASG ID '|| to_char(l_asg_id), 40);

969: close c_curr_grade;
970:
971: if g_debug then
972: hr_utility.set_location( l_proc ||': grade ID '|| to_char(l_grade_id), 40);
973: hr_utility.set_location( l_proc ||': ASG ID '|| to_char(l_asg_id), 40);
974: end if;
975:
976: open c_future_grade_chg(p_grade_id =>l_grade_id
977: ,p_end_date => l_end_date);

Line 986: hr_utility.set_location( l_proc ||'raise error', 60);

982: --
983: close c_future_grade_chg;
984: --null;
985: if g_debug then
986: hr_utility.set_location( l_proc ||'raise error', 60);
987: end if;
988:
989: fnd_message.set_name (800,'PER_449912_FUT_GRD_CHG');
990: fnd_message.raise_error;

Line 999: hr_utility.set_location( 'leaving :'|| l_proc , 70);

995: close c_future_grade_chg;
996: end if;
997:
998: if g_debug then
999: hr_utility.set_location( 'leaving :'|| l_proc , 70);
1000: end if;
1001:
1002: end chk_future_asg_changes;
1003: --

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

1025: l_proc varchar2(72) := g_package||'set_security_group_id';
1026: --
1027: begin
1028: --
1029: hr_utility.set_location('Entering:'|| l_proc, 10);
1030: --
1031: -- Ensure that all the mandatory parameter are not null
1032: --
1033: hr_api.mandatory_arg_error

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

1056: hr_api.set_security_group_id
1057: (p_security_group_id => l_security_group_id
1058: );
1059: --
1060: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1061: --
1062: end set_security_group_id;
1063: --
1064: -- ---------------------------------------------------------------------------

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

1085: l_proc varchar2(72) := g_package||'return_legislation_code';
1086: --
1087: Begin
1088: --
1089: hr_utility.set_location('Entering:'|| l_proc, 10);
1090: --
1091: -- Ensure that all the mandatory parameter are not null
1092: --
1093: hr_api.mandatory_arg_error

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

1103: -- call to this function. Just return the value in the global
1104: -- variable.
1105: --
1106: l_legislation_code := per_spp_bus.g_legislation_code;
1107: hr_utility.set_location(l_proc, 20);
1108: else
1109: --
1110: -- The ID is different to the last call to this function
1111: -- or this is the first call to this function.

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

1120: close csr_leg_code;
1121: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1122: fnd_message.raise_error;
1123: end if;
1124: hr_utility.set_location(l_proc,30);
1125: --
1126: -- Set the global variables so the values are
1127: -- available for the next call to this function.
1128: --

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

1129: close csr_leg_code;
1130: per_spp_bus.g_placement_id := p_placement_id;
1131: per_spp_bus.g_legislation_code := l_legislation_code;
1132: end if;
1133: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1134: return l_legislation_code;
1135: end return_legislation_code;
1136: --
1137: -- ----------------------------------------------------------------------------

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

1174: --
1175: -- Only proceed with the validation if a row exists for the current
1176: -- record in the HR Schema.
1177: --
1178: hr_utility.set_location(' Entering:'||l_proc,10);
1179: IF NOT per_spp_shd.api_updating
1180: (p_placement_id => p_rec.placement_id
1181: ,p_effective_date => p_effective_date
1182: ,p_object_version_number => p_rec.object_version_number

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

1196: (p_api_name => l_proc
1197: ,p_argument => l_argument);
1198: WHEN OTHERS THEN
1199: RAISE;
1200: hr_utility.set_location(' Leaving:'||l_proc,20);
1201: End chk_non_updateable_args;
1202: --
1203: -- ----------------------------------------------------------------------------
1204: -- |--------------------------< dt_update_validate >--------------------------|

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

1244: Begin
1245: --
1246: -- Ensure that the p_datetrack_mode argument is not null
1247: --
1248: hr_utility.set_location(' Entering:'||l_proc,10);
1249: --
1250: hr_api.mandatory_arg_error
1251: (p_api_name => l_proc
1252: ,p_argument => 'datetrack_mode'

Line 1266: hr_utility.set_location(' Entering: More VAlidation'||l_proc,15);

1262: ,p_argument => 'validation_start_date'
1263: ,p_argument_value => p_validation_start_date
1264: );
1265: --
1266: hr_utility.set_location(' Entering: More VAlidation'||l_proc,15);
1267: --
1268: hr_api.mandatory_arg_error
1269: (p_api_name => l_proc
1270: ,p_argument => 'validation_end_date'

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

1291: l_table_name := 'all assignments';
1292: raise l_integrity_error;
1293: End If;
1294: --
1295: hr_utility.set_location(' Leaving:'||l_proc,30);
1296: --
1297: --
1298: Exception
1299: When l_integrity_error Then

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

1438: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
1439: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
1440: --
1441: Begin
1442: hr_utility.set_location('Entering:'||l_proc, 5);
1443: --
1444: -- Call all supporting business operations
1445: --
1446: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

1448: l_effective_start_date := p_effective_date; -- bug 2491732
1449: --l_effective_start_date := hr_api.g_sys commented out for bug 2491732;
1450: l_effective_end_date := hr_api.g_eot; -- do i want this?
1451: --
1452: hr_utility.set_location('Entering:chk_parent_spine_step_id : '||l_proc, 10);
1453: --
1454: hr_utility.set_location('Start Date :'|| l_effective_start_date,969);
1455: hr_utility.set_location('val Start Date :'|| p_validation_start_date,969);
1456: --

Line 1454: hr_utility.set_location('Start Date :'|| l_effective_start_date,969);

1450: l_effective_end_date := hr_api.g_eot; -- do i want this?
1451: --
1452: hr_utility.set_location('Entering:chk_parent_spine_step_id : '||l_proc, 10);
1453: --
1454: hr_utility.set_location('Start Date :'|| l_effective_start_date,969);
1455: hr_utility.set_location('val Start Date :'|| p_validation_start_date,969);
1456: --
1457: chk_parent_spine_step_id
1458: (p_step_id => p_rec.step_id

Line 1455: hr_utility.set_location('val Start Date :'|| p_validation_start_date,969);

1451: --
1452: hr_utility.set_location('Entering:chk_parent_spine_step_id : '||l_proc, 10);
1453: --
1454: hr_utility.set_location('Start Date :'|| l_effective_start_date,969);
1455: hr_utility.set_location('val Start Date :'|| p_validation_start_date,969);
1456: --
1457: chk_parent_spine_step_id
1458: (p_step_id => p_rec.step_id
1459: ,p_parent_spine_id => p_rec.parent_spine_id

Line 1465: hr_utility.set_location('Entering: chk_assignment_id'||l_proc, 15);

1461: ,p_effective_end_date => l_effective_end_date
1462: ,p_placement_id => p_rec.placement_id
1463: ,p_object_version_number => p_rec.object_version_number);
1464: --
1465: hr_utility.set_location('Entering: chk_assignment_id'||l_proc, 15);
1466: --
1467: chk_assignment_id
1468: (p_assignment_id => p_rec.assignment_id
1469: ,p_datetrack_mode => p_datetrack_mode

Line 1474: hr_utility.set_location('Entering: chk_pay_ass_ceiling'||l_proc, 16);

1470: ,p_placement_id => p_rec.placement_id
1471: ,p_object_version_number => p_rec.object_version_number
1472: ,p_effective_date => p_effective_date); -- Bug 2488727
1473: --
1474: hr_utility.set_location('Entering: chk_pay_ass_ceiling'||l_proc, 16);
1475: --
1476: chk_pay_ass_ceiling
1477: (p_step_id => p_rec.step_id
1478: ,p_parent_spine_id => p_rec.parent_spine_id

Line 1482: hr_utility.set_location('Entering: chk_auto_inc_flag'||l_proc, 18);

1478: ,p_parent_spine_id => p_rec.parent_spine_id
1479: ,p_assignment_id => p_rec.assignment_id
1480: ,p_effective_date => p_effective_date);
1481: --
1482: hr_utility.set_location('Entering: chk_auto_inc_flag'||l_proc, 18);
1483: --
1484: chk_auto_inc_flag
1485: (p_auto_increment_flag => p_rec.auto_increment_flag
1486: ,p_placement_id => p_rec.placement_id

Line 1490: hr_utility.set_location('Entering: chk_reason'||l_proc, 19);

1486: ,p_placement_id => p_rec.placement_id
1487: ,p_increment_number => p_rec.increment_number
1488: ,p_object_version_number => p_rec.object_version_number);
1489: --
1490: hr_utility.set_location('Entering: chk_reason'||l_proc, 19);
1491: --
1492: chk_reason
1493: (p_reason => p_rec.reason
1494: ,p_effective_date => p_effective_date);

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

1492: chk_reason
1493: (p_reason => p_rec.reason
1494: ,p_effective_date => p_effective_date);
1495: --
1496: hr_utility.set_location(' Leaving:'||l_proc, 20);
1497: End insert_validate;
1498: --
1499: -- ----------------------------------------------------------------------------
1500: -- |---------------------------< update_validate >----------------------------|

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

1523: and spp.effective_end_date ;
1524: --
1525: --
1526: Begin
1527: hr_utility.set_location('Entering:'||l_proc, 5);
1528: --
1529: -- Call all supporting business operations
1530: --
1531: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

Line 1539: hr_utility.raise_error;

1535: if csr_start_end_date%notfound then
1536: --
1537: close csr_start_end_date;
1538: fnd_message.set_name('PER', 'HR_289229_SPP_DATE_ERROR');
1539: hr_utility.raise_error;
1540: --
1541: else
1542: close csr_start_end_date;
1543: end if;

Line 1545: hr_utility.set_location('Entering: chk_object_version_number'||l_proc,7);

1541: else
1542: close csr_start_end_date;
1543: end if;
1544: --
1545: hr_utility.set_location('Entering: chk_object_version_number'||l_proc,7);
1546: --
1547: chk_object_version_number
1548: (p_placement_id => p_rec.placement_id
1549: ,p_object_version_number => p_rec.object_version_number

Line 1552: hr_utility.set_location('Entering: chk_parent_spine_step_id '||l_proc, 69);

1548: (p_placement_id => p_rec.placement_id
1549: ,p_object_version_number => p_rec.object_version_number
1550: ,p_effective_date => p_effective_date
1551: );
1552: hr_utility.set_location('Entering: chk_parent_spine_step_id '||l_proc, 69);
1553: --
1554: hr_utility.set_location('p_eff Date :'|| p_effective_date,69);
1555: hr_utility.set_location('Start Date :'|| l_effective_start_date,69);
1556: hr_utility.set_location('End Date :'|| l_effective_end_date,69);

Line 1554: hr_utility.set_location('p_eff Date :'|| p_effective_date,69);

1550: ,p_effective_date => p_effective_date
1551: );
1552: hr_utility.set_location('Entering: chk_parent_spine_step_id '||l_proc, 69);
1553: --
1554: hr_utility.set_location('p_eff Date :'|| p_effective_date,69);
1555: hr_utility.set_location('Start Date :'|| l_effective_start_date,69);
1556: hr_utility.set_location('End Date :'|| l_effective_end_date,69);
1557: hr_utility.set_location('val start Date :'|| p_validation_start_date,69);
1558: --

Line 1555: hr_utility.set_location('Start Date :'|| l_effective_start_date,69);

1551: );
1552: hr_utility.set_location('Entering: chk_parent_spine_step_id '||l_proc, 69);
1553: --
1554: hr_utility.set_location('p_eff Date :'|| p_effective_date,69);
1555: hr_utility.set_location('Start Date :'|| l_effective_start_date,69);
1556: hr_utility.set_location('End Date :'|| l_effective_end_date,69);
1557: hr_utility.set_location('val start Date :'|| p_validation_start_date,69);
1558: --
1559: chk_parent_spine_step_id

Line 1556: hr_utility.set_location('End Date :'|| l_effective_end_date,69);

1552: hr_utility.set_location('Entering: chk_parent_spine_step_id '||l_proc, 69);
1553: --
1554: hr_utility.set_location('p_eff Date :'|| p_effective_date,69);
1555: hr_utility.set_location('Start Date :'|| l_effective_start_date,69);
1556: hr_utility.set_location('End Date :'|| l_effective_end_date,69);
1557: hr_utility.set_location('val start Date :'|| p_validation_start_date,69);
1558: --
1559: chk_parent_spine_step_id
1560: (p_step_id => p_rec.step_id

Line 1557: hr_utility.set_location('val start Date :'|| p_validation_start_date,69);

1553: --
1554: hr_utility.set_location('p_eff Date :'|| p_effective_date,69);
1555: hr_utility.set_location('Start Date :'|| l_effective_start_date,69);
1556: hr_utility.set_location('End Date :'|| l_effective_end_date,69);
1557: hr_utility.set_location('val start Date :'|| p_validation_start_date,69);
1558: --
1559: chk_parent_spine_step_id
1560: (p_step_id => p_rec.step_id
1561: ,p_parent_spine_id => p_rec.parent_spine_id

Line 1567: hr_utility.set_location('Entering: chk_assignment_id'||l_proc, 15);

1563: ,p_effective_end_date => l_effective_end_date
1564: ,p_placement_id => p_rec.placement_id
1565: ,p_object_version_number => p_rec.object_version_number);
1566: --
1567: hr_utility.set_location('Entering: chk_assignment_id'||l_proc, 15);
1568: --
1569: chk_assignment_id
1570: (p_assignment_id => p_rec.assignment_id
1571: ,p_datetrack_mode => p_datetrack_mode

Line 1576: hr_utility.set_location('Entering: chk_pay_ass_ceiling'||l_proc, 16);

1572: ,p_placement_id => p_rec.placement_id
1573: ,p_object_version_number => p_rec.object_version_number
1574: ,p_effective_date => p_effective_date); -- Bug 2488727
1575: --
1576: hr_utility.set_location('Entering: chk_pay_ass_ceiling'||l_proc, 16);
1577: --
1578: chk_pay_ass_ceiling
1579: (p_step_id => p_rec.step_id
1580: ,p_parent_spine_id => p_rec.parent_spine_id

Line 1584: hr_utility.set_location('Entering: chk_auto_inc_flag'||l_proc, 18);

1580: ,p_parent_spine_id => p_rec.parent_spine_id
1581: ,p_assignment_id => p_rec.assignment_id
1582: ,p_effective_date => p_effective_date);
1583: --
1584: hr_utility.set_location('Entering: chk_auto_inc_flag'||l_proc, 18);
1585: --
1586: chk_auto_inc_flag
1587: (p_auto_increment_flag => p_rec.auto_increment_flag
1588: ,p_placement_id => p_rec.placement_id

Line 1592: hr_utility.set_location('Entering: chk_reason'||l_proc, 19);

1588: ,p_placement_id => p_rec.placement_id
1589: ,p_increment_number => p_rec.increment_number
1590: ,p_object_version_number => p_rec.object_version_number);
1591: --
1592: hr_utility.set_location('Entering: chk_reason'||l_proc, 19);
1593: --
1594: chk_reason
1595: (p_reason => p_rec.reason
1596: ,p_effective_date => p_effective_date);

Line 1613: hr_utility.set_location('Entering: chk_reason_only_update'||l_proc, 20);

1609: end if ;
1610: --
1611: -- End of fix for Bug 3335915
1612: /*
1613: hr_utility.set_location('Entering: chk_reason_only_update'||l_proc, 20);
1614: --
1615: -- If the only thing that changes on the record is the reason then
1616: -- the record can not be updated as thereason refers to the reason why
1617: -- a step id has changed. Therefor the datetrack mode is set to correction

Line 1628: hr_utility.set_location(' Entering: dt_update_validate'||l_proc, 30);

1624: ,p_validation_end_date => p_validation_end_date
1625: );
1626: */
1627: --
1628: hr_utility.set_location(' Entering: dt_update_validate'||l_proc, 30);
1629: --
1630: -- Call the datetrack update integrity operation
1631: --
1632: dt_update_validate

Line 1640: hr_utility.set_location(' Entering: chk_non_updateable_args'||l_proc, 35);

1636: ,p_validation_start_date => p_validation_start_date
1637: ,p_validation_end_date => p_validation_end_date
1638: );
1639: --
1640: hr_utility.set_location(' Entering: chk_non_updateable_args'||l_proc, 35);
1641: chk_non_updateable_args
1642: (p_effective_date => p_effective_date
1643: ,p_rec => p_rec
1644: );

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

1643: ,p_rec => p_rec
1644: );
1645: --
1646: --
1647: hr_utility.set_location(' Leaving:'||l_proc, 40);
1648: End update_validate;
1649: --
1650: -- ----------------------------------------------------------------------------
1651: -- |---------------------------< delete_validate >----------------------------|

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

1660: --
1661: l_proc varchar2(72) := g_package||'delete_validate';
1662: --
1663: Begin
1664: hr_utility.set_location('Entering:'||l_proc, 5);
1665: --
1666: -- Call all supporting business operations
1667: --
1668: hr_utility.set_location('Entering: chk_object_version_number'||l_proc,7);

Line 1668: hr_utility.set_location('Entering: chk_object_version_number'||l_proc,7);

1664: hr_utility.set_location('Entering:'||l_proc, 5);
1665: --
1666: -- Call all supporting business operations
1667: --
1668: hr_utility.set_location('Entering: chk_object_version_number'||l_proc,7);
1669: --
1670: chk_object_version_number
1671: (p_placement_id => p_rec.placement_id
1672: ,p_object_version_number => p_rec.object_version_number

Line 1679: hr_utility.set_location( l_proc ||'calling chk_fututre_asg_chng', 40);

1675: -- Start of fix for Bug 3335915
1676: if (not hr_assignment_internal.g_called_from_spp_asg) and
1677: (p_datetrack_mode in ('DELETE_NEXT_CHANGE','FUTURE_CHANGE'))then
1678: --
1679: hr_utility.set_location( l_proc ||'calling chk_fututre_asg_chng', 40);
1680: --
1681: chk_future_asg_changes
1682: (p_placement_id => p_rec.placement_id
1683: ,p_effective_date => p_effective_date

Line 1691: hr_utility.set_location('Entering: dt_delete_validate'||l_proc,8);

1687: end if ;
1688: --
1689: -- End of fix for Bug 3335915
1690: --
1691: hr_utility.set_location('Entering: dt_delete_validate'||l_proc,8);
1692: --
1693: dt_delete_validate
1694: (p_datetrack_mode => p_datetrack_mode
1695: ,p_validation_start_date => p_validation_start_date

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

1696: ,p_validation_end_date => p_validation_end_date
1697: ,p_placement_id => p_rec.placement_id
1698: );
1699: --
1700: hr_utility.set_location(' Leaving:'||l_proc, 10);
1701: End delete_validate;
1702: --
1703: end per_spp_bus;