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 1297: hr_utility.set_location(' Leaving:'||l_proc,30);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1541: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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