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_PJU_BUS dependencies on HR_UTILITY

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

55: --
56: l_proc varchar2(72) := g_package||'chk_previous_employer_id';
57: l_api_updating boolean;
58: begin
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: hr_utility.set_location(l_proc, 10);
62: if p_previous_employer_id is not null then
63: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id

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

57: l_api_updating boolean;
58: begin
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: hr_utility.set_location(l_proc, 10);
62: if p_previous_employer_id is not null then
63: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
64: => p_previous_job_usage_id
65: ,p_object_version_number

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

69: and nvl(per_pju_shd.g_old_rec.previous_employer_id, hr_api.g_number)
70: <> nvl(p_previous_employer_id,hr_api.g_number))
71: or
72: (not l_api_updating)) then
73: hr_utility.set_location(l_proc, 15);
74: open csr_previous_employer_id;
75: fetch csr_previous_employer_id into l_previous_employer_id;
76: if csr_previous_employer_id%notfound then
77: hr_utility.set_location(l_proc, 20);

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

73: hr_utility.set_location(l_proc, 15);
74: open csr_previous_employer_id;
75: fetch csr_previous_employer_id into l_previous_employer_id;
76: if csr_previous_employer_id%notfound then
77: hr_utility.set_location(l_proc, 20);
78: close csr_previous_employer_id;
79: fnd_message.set_name('PER','HR_289537_PJO_VALID_PR_EMPR_ID');
80: fnd_message.raise_error;
81: end if;

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

84: end if;
85: end if;
86: end if;
87: --
88: hr_utility.set_location('Leaving:'||l_proc, 25);
89: exception
90: when others then
91: raise;
92: end chk_previous_employer_id;

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

134: --
135: l_proc varchar2(72) := g_package||'chk_previous_job_id';
136: l_api_updating boolean;
137: begin
138: hr_utility.set_location('Entering:'||l_proc, 5);
139: --
140: hr_utility.set_location(l_proc, 10);
141: if p_previous_job_id is not null then
142: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id

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

136: l_api_updating boolean;
137: begin
138: hr_utility.set_location('Entering:'||l_proc, 5);
139: --
140: hr_utility.set_location(l_proc, 10);
141: if p_previous_job_id is not null then
142: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
143: => p_previous_job_usage_id
144: ,p_object_version_number

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

148: and nvl(per_pju_shd.g_old_rec.previous_job_id, hr_api.g_number)
149: <> nvl(p_previous_job_id,hr_api.g_number))
150: or
151: (not l_api_updating)) then
152: hr_utility.set_location(l_proc, 15);
153: open csr_previous_job_id;
154: fetch csr_previous_job_id into l_previous_job_id;
155: if csr_previous_job_id%notfound then
156: hr_utility.set_location(l_proc, 20);

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

152: hr_utility.set_location(l_proc, 15);
153: open csr_previous_job_id;
154: fetch csr_previous_job_id into l_previous_job_id;
155: if csr_previous_job_id%notfound then
156: hr_utility.set_location(l_proc, 20);
157: close csr_previous_job_id;
158: fnd_message.set_name('PER','HR_289540_PJI_INV_PREV_JOB_ID');
159: fnd_message.raise_error;
160: end if;

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

163: end if;
164: end if;
165: end if;
166: --
167: hr_utility.set_location('Leaving:'||l_proc, 25);
168: exception
169: when others then
170: raise;
171: end chk_previous_job_id;

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

212: --
213: l_proc varchar2(72) := g_package||'chk_assignment_id';
214: l_api_updating boolean;
215: begin
216: hr_utility.set_location('Entering:'||l_proc, 5);
217: --
218: hr_utility.set_location(l_proc, 10);
219: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
220: => p_previous_job_usage_id

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

214: l_api_updating boolean;
215: begin
216: hr_utility.set_location('Entering:'||l_proc, 5);
217: --
218: hr_utility.set_location(l_proc, 10);
219: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
220: => p_previous_job_usage_id
221: ,p_object_version_number
222: => p_object_version_number

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

225: and nvl(per_pju_shd.g_old_rec.assignment_id, hr_api.g_number)
226: <> nvl(p_assignment_id,hr_api.g_number))
227: or
228: (not l_api_updating)) then
229: hr_utility.set_location(l_proc, 15);
230: -- Check for valid Assignment ID.
231: open csr_assignment_id;
232: fetch csr_assignment_id into l_assignment_id;
233: if csr_assignment_id%notfound then

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

230: -- Check for valid Assignment ID.
231: open csr_assignment_id;
232: fetch csr_assignment_id into l_assignment_id;
233: if csr_assignment_id%notfound then
234: hr_utility.set_location(l_proc, 20);
235: close csr_assignment_id;
236: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
237: fnd_message.raise_error;
238: end if;

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

240: close csr_assignment_id;
241: end if;
242: end if;
243: --
244: hr_utility.set_location('Leaving:'||l_proc, 30);
245: exception
246: when others then
247: raise;
248: end chk_assignment_id;

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

285: in per_previous_job_usages.end_date%type) is
286: l_proc varchar2(72) := g_package||'chk_valid_job_dates';
287: l_api_updating boolean;
288: begin
289: hr_utility.set_location('Entering:'||l_proc, 5);
290: --
291: if p_start_date is not null and p_end_date is not null then
292: hr_utility.set_location(l_proc, 10);
293: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id

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

288: begin
289: hr_utility.set_location('Entering:'||l_proc, 5);
290: --
291: if p_start_date is not null and p_end_date is not null then
292: hr_utility.set_location(l_proc, 10);
293: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
294: => p_previous_job_usage_id
295: ,p_object_version_number
296: => p_object_version_number

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

303: <> nvl(p_end_date,hr_api.g_eot))
304: )
305: or
306: (not l_api_updating)) then
307: hr_utility.set_location(l_proc, 15);
308: if nvl(p_start_date,hr_api.g_sot) > nvl(p_end_date,hr_api.g_eot) then
309: hr_utility.set_location(l_proc, 20);
310: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
311: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);

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

305: or
306: (not l_api_updating)) then
307: hr_utility.set_location(l_proc, 15);
308: if nvl(p_start_date,hr_api.g_sot) > nvl(p_end_date,hr_api.g_eot) then
309: hr_utility.set_location(l_proc, 20);
310: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
311: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
312: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
313: fnd_message.raise_error;

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

314: end if;
315: end if;
316: end if;
317: --
318: hr_utility.set_location('Leaving:'||l_proc, 25);
319: exception
320: when others then
321: raise;
322: end chk_valid_job_dates;

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

356: in per_previous_job_usages.object_version_number%type) is
357: l_proc varchar2(72) := g_package||'chk_period_years';
358: l_api_updating boolean;
359: begin
360: hr_utility.set_location('Entering:'||l_proc, 5);
361: --
362: if p_period_years is not null then
363: hr_utility.set_location(l_proc, 10);
364: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id

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

359: begin
360: hr_utility.set_location('Entering:'||l_proc, 5);
361: --
362: if p_period_years is not null then
363: hr_utility.set_location(l_proc, 10);
364: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
365: => p_previous_job_usage_id
366: ,p_object_version_number
367: => p_object_version_number);

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

364: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
365: => p_previous_job_usage_id
366: ,p_object_version_number
367: => p_object_version_number);
368: hr_utility.set_location(l_proc, 15);
369: if ((l_api_updating and
370: ( nvl(p_period_years,hr_api.g_number)
371: <> nvl(per_pju_shd.g_old_rec.period_years,hr_api.g_number)
372: )

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

371: <> nvl(per_pju_shd.g_old_rec.period_years,hr_api.g_number)
372: )
373: ) or
374: (not l_api_updating)) then
375: hr_utility.set_location(l_proc, 20);
376: if p_period_years not between 0 and 99 then
377: hr_utility.set_location(l_proc, 25);
378: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
379: fnd_message.set_token('RANGE_START',0,true);

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

373: ) or
374: (not l_api_updating)) then
375: hr_utility.set_location(l_proc, 20);
376: if p_period_years not between 0 and 99 then
377: hr_utility.set_location(l_proc, 25);
378: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
379: fnd_message.set_token('RANGE_START',0,true);
380: fnd_message.set_token('RANGE_END',99,true);
381: fnd_message.raise_error;

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

382: end if;
383: end if;
384: end if;
385: --
386: hr_utility.set_location('Leaving:'||l_proc, 30);
387: exception
388: when others then
389: raise;
390: end chk_period_years;

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

424: in per_previous_job_usages.object_version_number%type) is
425: l_proc varchar2(72) := g_package||'chk_period_months';
426: l_api_updating boolean;
427: begin
428: hr_utility.set_location('Entering:'||l_proc, 5);
429: --
430: if p_period_months is not null then
431: hr_utility.set_location(l_proc, 10);
432: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id

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

427: begin
428: hr_utility.set_location('Entering:'||l_proc, 5);
429: --
430: if p_period_months is not null then
431: hr_utility.set_location(l_proc, 10);
432: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
433: => p_previous_job_usage_id
434: ,p_object_version_number
435: => p_object_version_number);

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

432: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
433: => p_previous_job_usage_id
434: ,p_object_version_number
435: => p_object_version_number);
436: hr_utility.set_location(l_proc, 15);
437: if ((l_api_updating and
438: ( nvl(p_period_months ,hr_api.g_number)
439: <> nvl(per_pju_shd.g_old_rec.period_months ,hr_api.g_number)
440: )

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

439: <> nvl(per_pju_shd.g_old_rec.period_months ,hr_api.g_number)
440: )
441: ) or
442: (not l_api_updating)) then
443: hr_utility.set_location(l_proc, 20);
444: if p_period_months not between 0 and 11 then
445: hr_utility.set_location(l_proc, 25);
446: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
447: fnd_message.set_token('RANGE_START',0,true);

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

441: ) or
442: (not l_api_updating)) then
443: hr_utility.set_location(l_proc, 20);
444: if p_period_months not between 0 and 11 then
445: hr_utility.set_location(l_proc, 25);
446: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
447: fnd_message.set_token('RANGE_START',0,true);
448: fnd_message.set_token('RANGE_END',11,true);
449: fnd_message.raise_error;

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

450: end if;
451: end if;
452: end if;
453: --
454: hr_utility.set_location('Leaving:'||l_proc, 30);
455: exception
456: when others then
457: raise;
458: end chk_period_months;

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

492: in per_previous_job_usages.object_version_number%type) is
493: l_proc varchar2(72) := g_package||'chk_period_days';
494: l_api_updating boolean;
495: begin
496: hr_utility.set_location('Entering:'||l_proc, 5);
497: --
498: if p_period_days is not null then
499: hr_utility.set_location(l_proc, 10);
500: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id

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

495: begin
496: hr_utility.set_location('Entering:'||l_proc, 5);
497: --
498: if p_period_days is not null then
499: hr_utility.set_location(l_proc, 10);
500: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
501: => p_previous_job_usage_id
502: ,p_object_version_number
503: => p_object_version_number);

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

500: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
501: => p_previous_job_usage_id
502: ,p_object_version_number
503: => p_object_version_number);
504: hr_utility.set_location(l_proc, 15);
505: if ((l_api_updating and
506: ( nvl(p_period_days ,hr_api.g_number)
507: <> nvl(per_pju_shd.g_old_rec.period_days ,hr_api.g_number)
508: )

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

507: <> nvl(per_pju_shd.g_old_rec.period_days ,hr_api.g_number)
508: )
509: ) or
510: (not l_api_updating)) then
511: hr_utility.set_location(l_proc, 20);
512: if p_period_days not between 0 and 365 then
513: hr_utility.set_location(l_proc, 25);
514: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
515: fnd_message.set_token('RANGE_START',0,true);

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

509: ) or
510: (not l_api_updating)) then
511: hr_utility.set_location(l_proc, 20);
512: if p_period_days not between 0 and 365 then
513: hr_utility.set_location(l_proc, 25);
514: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
515: fnd_message.set_token('RANGE_START',0,true);
516: fnd_message.set_token('RANGE_END',365,true);
517: fnd_message.raise_error;

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

518: end if;
519: end if;
520: end if;
521: --
522: hr_utility.set_location('Leaving:'||l_proc, 30);
523: exception
524: when others then
525: raise;
526: end chk_period_days;

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

580: --
581: l_api_updating boolean;
582: l_proc varchar2(72) := g_package||'chk_pju_start_end_dates';
583: begin
584: hr_utility.set_location('Entering:'||l_proc, 5);
585: --
586: if p_start_date is not null or p_end_date is not null then
587: hr_utility.set_location(l_proc, 10);
588: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id

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

583: begin
584: hr_utility.set_location('Entering:'||l_proc, 5);
585: --
586: if p_start_date is not null or p_end_date is not null then
587: hr_utility.set_location(l_proc, 10);
588: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
589: => p_previous_job_usage_id
590: ,p_object_version_number
591: => p_object_version_number

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

598: <> nvl(p_end_date,hr_api.g_eot))
599: )
600: or
601: (not l_api_updating)) then
602: hr_utility.set_location(l_proc, 15);
603: open csr_pem_start_end_dates;
604: fetch csr_pem_start_end_dates into l_previous_employer_id;
605: if csr_pem_start_end_dates%found then
606: hr_utility.set_location(l_proc, 20);

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

602: hr_utility.set_location(l_proc, 15);
603: open csr_pem_start_end_dates;
604: fetch csr_pem_start_end_dates into l_previous_employer_id;
605: if csr_pem_start_end_dates%found then
606: hr_utility.set_location(l_proc, 20);
607: close csr_pem_start_end_dates;
608: fnd_message.set_name('PER','HR_289550_PJU_DATES');
609: fnd_message.raise_error;
610: end if;

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

613: end if;
614: end if;
615: end if;
616: --
617: hr_utility.set_location('Leaving:'||l_proc, 25);
618: exception
619: when others then
620: raise;
621: end chk_pju_start_end_dates;

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

670: l_previous_job_usage_id per_previous_job_usages.previous_job_usage_id%type;
671: l_proc varchar2(72) := g_package||'chk_assignment_job';
672: l_api_updating boolean;
673: begin
674: hr_utility.set_location('Entering:'||l_proc, 5);
675: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
676: => p_previous_job_usage_id
677: ,p_object_version_number
678: => p_object_version_number

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

685: )
686: )
687: or
688: (not l_api_updating)) then
689: hr_utility.set_location(l_proc, 15);
690: open csr_asg_job;
691: fetch csr_asg_job into l_previous_job_usage_id;
692: if not csr_asg_job%notfound then
693: hr_utility.set_location(l_proc, 10);

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

689: hr_utility.set_location(l_proc, 15);
690: open csr_asg_job;
691: fetch csr_asg_job into l_previous_job_usage_id;
692: if not csr_asg_job%notfound then
693: hr_utility.set_location(l_proc, 10);
694: close csr_asg_job;
695: fnd_message.set_name('PER','HR_289551_PJU_ASG_JOB_DUP');
696: fnd_message.raise_error;
697: end if;

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

695: fnd_message.set_name('PER','HR_289551_PJU_ASG_JOB_DUP');
696: fnd_message.raise_error;
697: end if;
698: if csr_asg_job%isopen then
699: hr_utility.set_location(l_proc, 15);
700: close csr_asg_job;
701: end if;
702: end if;
703: --

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

700: close csr_asg_job;
701: end if;
702: end if;
703: --
704: hr_utility.set_location(l_proc, 20);
705: --
706: exception
707: when others then
708: raise;

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

766: where pjo.previous_employer_id = p_previous_employer_id
767: and pjo.previous_job_id = p_previous_job_id;
768: --
769: begin
770: hr_utility.set_location('Entering : '||l_proc, 5);
771: if p_previous_employer_id is not null and p_previous_job_id is not null then
772: hr_utility.set_location(l_proc, 10);
773: open csr_previous_job_dates;
774: fetch csr_previous_job_dates into p_start_date

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

768: --
769: begin
770: hr_utility.set_location('Entering : '||l_proc, 5);
771: if p_previous_employer_id is not null and p_previous_job_id is not null then
772: hr_utility.set_location(l_proc, 10);
773: open csr_previous_job_dates;
774: fetch csr_previous_job_dates into p_start_date
775: ,p_end_date
776: ,p_period_years

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

775: ,p_end_date
776: ,p_period_years
777: ,p_period_months
778: ,p_period_days;
779: hr_utility.set_location(l_proc, 15);
780: if csr_previous_job_dates%notfound then
781: hr_utility.set_location(l_proc, 20);
782: close csr_previous_job_dates;
783: fnd_message.set_name('PER','HR_289540_PJI_INV_PREV_JOB_ID');

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

777: ,p_period_months
778: ,p_period_days;
779: hr_utility.set_location(l_proc, 15);
780: if csr_previous_job_dates%notfound then
781: hr_utility.set_location(l_proc, 20);
782: close csr_previous_job_dates;
783: fnd_message.set_name('PER','HR_289540_PJI_INV_PREV_JOB_ID');
784: fnd_message.raise_error;
785: end if;

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

783: fnd_message.set_name('PER','HR_289540_PJI_INV_PREV_JOB_ID');
784: fnd_message.raise_error;
785: end if;
786: if csr_previous_job_dates%isopen then
787: hr_utility.set_location(l_proc, 25);
788: close csr_previous_job_dates;
789: end if;
790: end if;
791: --

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

788: close csr_previous_job_dates;
789: end if;
790: end if;
791: --
792: hr_utility.set_location('Leaving : '||l_proc, 30);
793: --
794: end get_previous_job_dates;
795: --
796: -- ---------------------------------------------------------------------------

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

901: l_proc varchar2(72) := g_package||'set_security_group_id';
902: --
903: begin
904: --
905: hr_utility.set_location('Entering:'|| l_proc, 10);
906: --
907: -- Ensure that all the mandatory parameter are not null
908: --
909: hr_api.mandatory_arg_error

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

932: hr_api.set_security_group_id
933: (p_security_group_id => l_security_group_id
934: );
935: --
936: hr_utility.set_location(' Leaving:'|| l_proc, 20);
937: --
938: end set_security_group_id;
939: --
940: -- ---------------------------------------------------------------------------

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

962: l_proc varchar2(72) := g_package||'return_legislation_code';
963: --
964: Begin
965: --
966: hr_utility.set_location('Entering:'|| l_proc, 10);
967: --
968: -- Ensure that all the mandatory parameter are not null
969: --
970: hr_api.mandatory_arg_error

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

980: -- call to this function. Just return the value in the global
981: -- variable.
982: --
983: l_legislation_code := per_pju_bus.g_legislation_code;
984: hr_utility.set_location(l_proc, 20);
985: else
986: --
987: -- The ID is different to the last call to this function
988: -- or this is the first call to this function.

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

997: close csr_leg_code;
998: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
999: fnd_message.raise_error;
1000: end if;
1001: hr_utility.set_location(l_proc,30);
1002: --
1003: -- Set the global variables so the values are
1004: -- available for the next call to this function.
1005: --

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

1006: close csr_leg_code;
1007: per_pju_bus.g_previous_job_usage_id := p_previous_job_usage_id;
1008: per_pju_bus.g_legislation_code := l_legislation_code;
1009: end if;
1010: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1011: return l_legislation_code;
1012: end return_legislation_code;
1013: --
1014: -- ----------------------------------------------------------------------------

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

1045: --
1046: l_proc varchar2(72) := g_package || 'chk_ddf';
1047: --
1048: begin
1049: hr_utility.set_location('Entering:'||l_proc,10);
1050: --
1051: if ((p_rec.previous_job_usage_id is not null) and (
1052: nvl(per_pju_shd.g_old_rec.pju_information_category, hr_api.g_varchar2) <>
1053: nvl(p_rec.pju_information_category, hr_api.g_varchar2) or

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

1144: ,p_attribute20_value => p_rec.pju_information20
1145: );
1146: end if;
1147: --
1148: hr_utility.set_location(' Leaving:'||l_proc,20);
1149: end chk_ddf;
1150: --
1151: -- ----------------------------------------------------------------------------
1152: -- |------------------------------< chk_df >----------------------------------|

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

1182: --
1183: l_proc varchar2(72) := g_package || 'chk_df';
1184: --
1185: begin
1186: hr_utility.set_location('Entering:'||l_proc,10);
1187: --
1188: if ((p_rec.previous_job_usage_id is not null) and (
1189: nvl(per_pju_shd.g_old_rec.pju_attribute_category, hr_api.g_varchar2) <>
1190: nvl(p_rec.pju_attribute_category, hr_api.g_varchar2) or

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

1281: ,p_attribute20_value => p_rec.pju_attribute20
1282: );
1283: end if;
1284: --
1285: hr_utility.set_location(' Leaving:'||l_proc,20);
1286: end chk_df;
1287: --
1288: -- ----------------------------------------------------------------------------
1289: -- |-----------------------< chk_non_updateable_args >------------------------|

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

1369: --
1370: l_proc varchar2(72) := g_package||'insert_validate';
1371: --
1372: Begin
1373: hr_utility.set_location('Entering:'||l_proc, 5);
1374: --
1375: -- Call all supporting business operations
1376: -- Check whether the Assignment Id is Valid
1377: hr_utility.set_location(l_proc, 10);

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

1373: hr_utility.set_location('Entering:'||l_proc, 5);
1374: --
1375: -- Call all supporting business operations
1376: -- Check whether the Assignment Id is Valid
1377: hr_utility.set_location(l_proc, 10);
1378: chk_assignment_id(p_previous_job_usage_id
1379: => p_rec.previous_job_usage_id
1380: ,p_object_version_number
1381: => p_rec.object_version_number

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

1381: => p_rec.object_version_number
1382: ,p_assignment_id
1383: => p_rec.assignment_id);
1384: -- Check whether the Previous Employer Id is Valid
1385: hr_utility.set_location(l_proc, 15);
1386: chk_previous_employer_id(p_previous_employer_id
1387: => p_rec.previous_employer_id
1388: ,p_previous_job_usage_id
1389: => p_rec.previous_job_usage_id

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

1389: => p_rec.previous_job_usage_id
1390: ,p_object_version_number
1391: => p_rec.object_version_number);
1392: -- Check whether the Previous Job Id is Valid
1393: hr_utility.set_location(l_proc, 20);
1394: chk_previous_job_id(p_previous_job_id
1395: => p_rec.previous_job_id
1396: ,p_previous_job_usage_id
1397: => p_rec.previous_job_usage_id

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

1397: => p_rec.previous_job_usage_id
1398: ,p_object_version_number
1399: => p_rec.object_version_number);
1400: -- Check whether the Start Date is Valid
1401: hr_utility.set_location(l_proc, 25);
1402: chk_assignment_job(p_previous_job_usage_id
1403: => p_rec.previous_job_usage_id
1404: ,p_object_version_number
1405: => p_rec.object_version_number

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

1408: ,p_assignment_id
1409: => p_rec.assignment_id
1410: );
1411: --
1412: hr_utility.set_location(l_proc, 30);
1413: chk_valid_job_dates(p_previous_job_usage_id
1414: => p_rec.previous_job_usage_id
1415: ,p_object_version_number
1416: => p_rec.object_version_number

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

1418: => p_rec.start_date
1419: ,p_end_date
1420: => p_rec.end_date);
1421: --
1422: hr_utility.set_location(l_proc, 35);
1423: chk_asg_job_start_date
1424: (p_previous_job_usage_id
1425: => p_rec.previous_job_usage_id
1426: ,p_object_version_number

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

1430: ,p_previous_job_id
1431: => p_rec.previous_job_id
1432: );
1433: --
1434: hr_utility.set_location(l_proc, 40);
1435: chk_pju_start_end_dates(p_previous_job_usage_id
1436: => p_rec.previous_job_usage_id
1437: ,p_object_version_number
1438: => p_rec.object_version_number

Line 1446: hr_utility.set_location(l_proc, 45);

1442: => p_rec.start_date
1443: ,p_end_date
1444: => p_rec.end_date);
1445: -- Check whether the Period Years is Valid
1446: hr_utility.set_location(l_proc, 45);
1447: chk_period_years(p_period_years
1448: => p_rec.period_years
1449: ,p_previous_job_usage_id
1450: => p_rec.previous_job_usage_id

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

1450: => p_rec.previous_job_usage_id
1451: ,p_object_version_number
1452: => p_rec.object_version_number);
1453: -- Check whether the Period Months is Valid
1454: hr_utility.set_location(l_proc, 50);
1455: chk_period_months(p_period_months
1456: => p_rec.period_months
1457: ,p_previous_job_usage_id
1458: => p_rec.previous_job_usage_id

Line 1462: hr_utility.set_location(l_proc, 55);

1458: => p_rec.previous_job_usage_id
1459: ,p_object_version_number
1460: => p_rec.object_version_number);
1461: -- Check whether the Period Days is Valid
1462: hr_utility.set_location(l_proc, 55);
1463: chk_period_days(p_period_days
1464: => p_rec.period_days
1465: ,p_previous_job_usage_id
1466: => p_rec.previous_job_usage_id

Line 1470: hr_utility.set_location(l_proc, 60);

1466: => p_rec.previous_job_usage_id
1467: ,p_object_version_number
1468: => p_rec.object_version_number);
1469: --
1470: hr_utility.set_location(l_proc, 60);
1471: per_pju_bus.chk_ddf(p_rec);
1472: --
1473: hr_utility.set_location(l_proc, 65);
1474: per_pju_bus.chk_df(p_rec);

Line 1473: hr_utility.set_location(l_proc, 65);

1469: --
1470: hr_utility.set_location(l_proc, 60);
1471: per_pju_bus.chk_ddf(p_rec);
1472: --
1473: hr_utility.set_location(l_proc, 65);
1474: per_pju_bus.chk_df(p_rec);
1475: --
1476: hr_utility.set_location(' Leaving:'||l_proc, 70);
1477: End insert_validate;

Line 1476: hr_utility.set_location(' Leaving:'||l_proc, 70);

1472: --
1473: hr_utility.set_location(l_proc, 65);
1474: per_pju_bus.chk_df(p_rec);
1475: --
1476: hr_utility.set_location(' Leaving:'||l_proc, 70);
1477: End insert_validate;
1478: --
1479: -- ----------------------------------------------------------------------------
1480: -- |---------------------------< update_validate >----------------------------|

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

1485: --
1486: l_proc varchar2(72) := g_package||'update_validate';
1487: --
1488: Begin
1489: hr_utility.set_location('Entering:'||l_proc, 5);
1490: --
1491: -- Call all supporting business operations
1492: hr_api.mandatory_arg_error
1493: (p_api_name => l_proc

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

1496: );
1497: --
1498: chk_non_updateable_args(p_rec => p_rec);
1499: -- Check whether the Assignment Id is Valid
1500: hr_utility.set_location(l_proc, 10);
1501: chk_assignment_id(p_rec.previous_job_usage_id
1502: ,p_rec.object_version_number
1503: ,p_rec.assignment_id);
1504: -- Check whether the Previous Job Id is Valid

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

1501: chk_assignment_id(p_rec.previous_job_usage_id
1502: ,p_rec.object_version_number
1503: ,p_rec.assignment_id);
1504: -- Check whether the Previous Job Id is Valid
1505: hr_utility.set_location(l_proc, 20);
1506: chk_previous_job_id(p_previous_job_id
1507: => p_rec.previous_job_id
1508: ,p_previous_job_usage_id
1509: => p_rec.previous_job_usage_id

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

1509: => p_rec.previous_job_usage_id
1510: ,p_object_version_number
1511: => p_rec.object_version_number);
1512: --
1513: hr_utility.set_location(l_proc, 25);
1514: chk_assignment_job(p_previous_job_usage_id
1515: => p_rec.previous_job_usage_id
1516: ,p_object_version_number
1517: => p_rec.object_version_number

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

1520: ,p_assignment_id
1521: => p_rec.assignment_id
1522: );
1523: -- Check whether the Start Date is Valid
1524: hr_utility.set_location(l_proc, 30);
1525: chk_valid_job_dates(p_rec.previous_job_usage_id
1526: ,p_rec.object_version_number
1527: ,p_rec.start_date
1528: ,p_rec.end_date);

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

1527: ,p_rec.start_date
1528: ,p_rec.end_date);
1529: -- Check whether the Start Date is before the Start Date of the
1530: -- Assignment mapped with.
1531: hr_utility.set_location(l_proc, 35);
1532: chk_asg_job_start_date
1533: (p_previous_job_usage_id
1534: => p_rec.previous_job_usage_id
1535: ,p_object_version_number

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

1539: ,p_previous_job_id
1540: => p_rec.previous_job_id
1541: );
1542: -- Check whether the Period Years is Valid
1543: hr_utility.set_location(l_proc, 40);
1544: chk_period_years(p_period_years
1545: => p_rec.period_years
1546: ,p_previous_job_usage_id
1547: => p_rec.previous_job_usage_id

Line 1551: hr_utility.set_location(l_proc, 45);

1547: => p_rec.previous_job_usage_id
1548: ,p_object_version_number
1549: => p_rec.object_version_number);
1550: -- Check whether the Period Months is Valid
1551: hr_utility.set_location(l_proc, 45);
1552: chk_period_months(p_period_months
1553: => p_rec.period_months
1554: ,p_previous_job_usage_id
1555: => p_rec.previous_job_usage_id

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

1555: => p_rec.previous_job_usage_id
1556: ,p_object_version_number
1557: => p_rec.object_version_number);
1558: -- Check whether the Period Days is Valid
1559: hr_utility.set_location(l_proc, 50);
1560: chk_period_days(p_period_days
1561: => p_rec.period_days
1562: ,p_previous_job_usage_id
1563: => p_rec.previous_job_usage_id

Line 1567: hr_utility.set_location(l_proc, 55);

1563: => p_rec.previous_job_usage_id
1564: ,p_object_version_number
1565: => p_rec.object_version_number);
1566: --
1567: hr_utility.set_location(l_proc, 55);
1568: chk_pju_start_end_dates(p_previous_job_usage_id
1569: => p_rec.previous_job_usage_id
1570: ,p_object_version_number
1571: => p_rec.object_version_number

Line 1579: hr_utility.set_location(l_proc, 60);

1575: => p_rec.start_date
1576: ,p_end_date
1577: => p_rec.end_date);
1578: --
1579: hr_utility.set_location(l_proc, 60);
1580: per_pju_bus.chk_ddf(p_rec);
1581: --
1582: hr_utility.set_location(l_proc, 65);
1583: per_pju_bus.chk_df(p_rec);

Line 1582: hr_utility.set_location(l_proc, 65);

1578: --
1579: hr_utility.set_location(l_proc, 60);
1580: per_pju_bus.chk_ddf(p_rec);
1581: --
1582: hr_utility.set_location(l_proc, 65);
1583: per_pju_bus.chk_df(p_rec);
1584: --
1585: hr_utility.set_location(' Leaving:'||l_proc, 70);
1586: End update_validate;

Line 1585: hr_utility.set_location(' Leaving:'||l_proc, 70);

1581: --
1582: hr_utility.set_location(l_proc, 65);
1583: per_pju_bus.chk_df(p_rec);
1584: --
1585: hr_utility.set_location(' Leaving:'||l_proc, 70);
1586: End update_validate;
1587: --
1588: -- ----------------------------------------------------------------------------
1589: -- |---------------------------< delete_validate >----------------------------|

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

1594: --
1595: l_proc varchar2(72) := g_package||'delete_validate';
1596: --
1597: Begin
1598: hr_utility.set_location('Entering:'||l_proc, 5);
1599: --
1600: -- Call all supporting business operations
1601: --
1602: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1598: hr_utility.set_location('Entering:'||l_proc, 5);
1599: --
1600: -- Call all supporting business operations
1601: --
1602: hr_utility.set_location(' Leaving:'||l_proc, 10);
1603: End delete_validate;
1604: --
1605: end per_pju_bus;