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

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

32: l_legislation_code varchar2(150);
33: l_proc varchar2(72) := g_package||'return_legislation_code';
34: Begin
35: --
36: hr_utility.set_location('Entering:'||l_proc, 5);
37: hr_api.mandatory_arg_error(p_api_name => l_proc
38: ,p_argument => 'salary_survey_mapping_id'
39: ,p_argument_value => p_salary_survey_mapping_id
40: );

Line 49: hr_utility.set_location('Entering:'||l_proc, 6);

45: -- The legislation has already been found with a previous call to this
46: -- function. Just return the value in the global variable.
47: --
48: l_legislation_code := g_legislation_code;
49: hr_utility.set_location('Entering:'||l_proc, 6);
50: else
51: open csr_leg_code;
52: fetch csr_leg_code into l_legislation_code;
53: if csr_leg_code%notfound then

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

54: close csr_leg_code;
55: fnd_message.set_name('PER','PER_52479_SSM_INVL_SSM_ID');
56: fnd_message.raise_error;
57: end if;
58: hr_utility.set_location('Entering:'||l_proc, 7);
59: close csr_leg_code;
60: g_salary_survey_mapping_id := p_salary_survey_mapping_id;
61: g_legislation_code := l_legislation_code;
62: end if;

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

59: close csr_leg_code;
60: g_salary_survey_mapping_id := p_salary_survey_mapping_id;
61: g_legislation_code := l_legislation_code;
62: end if;
63: hr_utility.set_location(' Leaving:'||l_proc, 10);
64: --
65: return l_legislation_code;
66: End return_legislation_code;
67: --

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

76: l_error exception;
77: l_argument varchar2(30);
78: --
79: Begin
80: hr_utility.set_location('Entering:'||l_proc, 5);
81: --
82: -- Only proceed with validation if a row exists for
83: -- the current record in the HR Schema
84: --

Line 89: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

85: if not per_ssm_shd.api_updating
86: (p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id
87: ,p_object_version_number => p_rec.object_version_number
88: ) then
89: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
90: hr_utility.set_message_token('PROCEDURE', l_proc);
91: hr_utility.set_message_token('STEP', '5');
92: end if;
93: --

Line 90: hr_utility.set_message_token('PROCEDURE', l_proc);

86: (p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id
87: ,p_object_version_number => p_rec.object_version_number
88: ) then
89: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
90: hr_utility.set_message_token('PROCEDURE', l_proc);
91: hr_utility.set_message_token('STEP', '5');
92: end if;
93: --
94: hr_utility.set_location(l_proc, 6);

Line 91: hr_utility.set_message_token('STEP', '5');

87: ,p_object_version_number => p_rec.object_version_number
88: ) then
89: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
90: hr_utility.set_message_token('PROCEDURE', l_proc);
91: hr_utility.set_message_token('STEP', '5');
92: end if;
93: --
94: hr_utility.set_location(l_proc, 6);
95: --

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

90: hr_utility.set_message_token('PROCEDURE', l_proc);
91: hr_utility.set_message_token('STEP', '5');
92: end if;
93: --
94: hr_utility.set_location(l_proc, 6);
95: --
96: if nvl(p_rec.business_group_id, hr_api.g_number) <>
97: nvl(per_ssm_shd.g_old_rec.business_group_id, hr_api.g_number) then
98: l_argument := 'business_group_id';

Line 113: hr_utility.set_location(l_proc, 11);

109: nvl(per_ssm_shd.g_old_rec.parent_table_name, hr_api.g_varchar2) then
110: l_argument := 'parent_table_name';
111: raise l_error;
112: end if;
113: hr_utility.set_location(l_proc, 11);
114: --
115: exception
116: when l_error then
117: hr_api.argument_changed_error

Line 122: hr_utility.set_location(' Leaving:'||l_proc, 12);

118: (p_api_name => l_proc
119: ,p_argument => l_argument);
120: when others then
121: raise;
122: hr_utility.set_location(' Leaving:'||l_proc, 12);
123: end chk_non_updateable_args;
124: --
125: --
126: -- ----------------------------------------------------------------------------

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

159: where ssl.salary_survey_line_id = p_salary_survey_line_id;
160: --
161: Begin
162: --
163: hr_utility.set_location('Entering:'||l_proc,5);
164: --
165: open csr_get_dates;
166: --
167: fetch csr_get_dates into l_start_date;

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

168: --
169: return l_start_date;
170: --
171: --
172: hr_utility.set_location('Leaving:'||l_proc,10);
173: --
174: End get_salary_survey_line_start;
175: --
176: -- ----------------------------------------------------------------------------

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

215: where ssl.salary_survey_line_id = p_salary_survey_line_id;
216: --
217: Begin
218: --
219: hr_utility.set_location('Entering:'||l_proc,5);
220: --
221: open csr_get_dates;
222: --
223: fetch csr_get_dates into l_end_date;

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

224: --
225: return l_end_date;
226: --
227: --
228: hr_utility.set_location('Leaving:'||l_proc,10);
229: --
230: End get_salary_survey_line_end;
231: --
232: -- ----------------------------------------------------------------------------

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

270: where ssl.salary_survey_line_id = p_salary_survey_line_id;
271: --
272: Begin
273: --
274: hr_utility.set_location('Entering:'||l_proc,5);
275: --
276: -- Check mandatory parameters have been set
277: --
278: --hr_api.mandatory_arg_error

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

280: -- ,p_argument => 'salary_survey_line_id'
281: -- ,p_argument_value => p_salary_survey_line_id
282: -- );
283: --
284: hr_utility.set_location(l_proc,6);
285: --
286: l_api_updating := per_ssm_shd.api_updating
287: (p_salary_survey_mapping_id => p_salary_survey_mapping_id,
288: p_object_version_number => p_object_version_number);

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

316: close csr_chk_survey_line_exists;
317: --
318: End If;
319: --
320: hr_utility.set_location('Leaving:'||l_proc,10);
321: --
322: End chk_salary_survey_line_id;
323: --
324:

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

388: and effective_end_date = hr_general.end_of_time;
389: --
390: Begin
391: --
392: hr_utility.set_location('Entering:'||l_proc,5);
393: --
394: -- Check mandatory parameters have been set
395: --
396: -- hr_api.mandatory_arg_error

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

403: -- ,p_argument => 'parent_table_name'
404: -- ,p_argument_value => p_parent_table_name
405: -- );
406: --
407: hr_utility.set_location(l_proc,6);
408: --
409: l_api_updating := per_ssm_shd.api_updating
410: (p_salary_survey_mapping_id => p_salary_survey_mapping_id,
411: p_object_version_number => p_object_version_number);

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

409: l_api_updating := per_ssm_shd.api_updating
410: (p_salary_survey_mapping_id => p_salary_survey_mapping_id,
411: p_object_version_number => p_object_version_number);
412: --
413: hr_utility.set_location(l_proc,7);
414: --
415: If l_api_updating and
416: (nvl(p_parent_id,hr_api.g_number)
417: <> nvl(per_ssm_shd.g_old_rec.parent_id,hr_api.g_number)

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

417: <> nvl(per_ssm_shd.g_old_rec.parent_id,hr_api.g_number)
418: or nvl(p_parent_table_name,hr_api.g_varchar2)
419: <> nvl(per_ssm_shd.g_old_rec.parent_table_name,hr_api.g_varchar2)) then
420: --
421: hr_utility.set_location(l_proc,8);
422: --
423: -- Trying to update parent_id or parent_table_name.
424: fnd_message.set_name('PER','PER_52480_SSM_NON_UPD_FIELD');
425: fnd_message.raise_error;

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

424: fnd_message.set_name('PER','PER_52480_SSM_NON_UPD_FIELD');
425: fnd_message.raise_error;
426: Elsif not l_api_updating then
427: --
428: hr_utility.set_location(l_proc,9);
429: --
430: If p_parent_id is null then
431: --
432: hr_utility.set_location(l_proc,15);

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

428: hr_utility.set_location(l_proc,9);
429: --
430: If p_parent_id is null then
431: --
432: hr_utility.set_location(l_proc,15);
433: fnd_message.set_name('PER','PER_52481_SSM_NO_PARENT_ID');
434: fnd_message.raise_error;
435: Elsif p_parent_table_name is null then
436: --

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

433: fnd_message.set_name('PER','PER_52481_SSM_NO_PARENT_ID');
434: fnd_message.raise_error;
435: Elsif p_parent_table_name is null then
436: --
437: hr_utility.set_location(l_proc,20);
438: --
439: fnd_message.set_name('PER','PER_52482_SSM_NO_PRNT_TBL_NAME');
440: fnd_message.raise_error;
441: Else

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

439: fnd_message.set_name('PER','PER_52482_SSM_NO_PRNT_TBL_NAME');
440: fnd_message.raise_error;
441: Else
442: --
443: hr_utility.set_location(l_proc,25);
444: --
445: If p_parent_table_name = 'PER_JOBS' then
446: --
447: hr_utility.set_location(l_proc,30);

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

443: hr_utility.set_location(l_proc,25);
444: --
445: If p_parent_table_name = 'PER_JOBS' then
446: --
447: hr_utility.set_location(l_proc,30);
448: --
449: open csr_chk_job_id_exists;
450: fetch csr_chk_job_id_exists into l_business_group_id,l_parent_start_date,l_parent_end_date;
451: If csr_chk_job_id_exists%notfound Then

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

449: open csr_chk_job_id_exists;
450: fetch csr_chk_job_id_exists into l_business_group_id,l_parent_start_date,l_parent_end_date;
451: If csr_chk_job_id_exists%notfound Then
452: --
453: hr_utility.set_location(l_proc,35);
454: --
455: close csr_chk_job_id_exists;
456: --
457: -- raise error as FK does not relate to PK in per_jobs

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

460: fnd_message.set_name('PER','PER_52483_SSM_INVL_JOB_ID');
461: fnd_message.raise_error;
462: Elsif l_business_group_id <> p_business_group_id then
463: --
464: hr_utility.set_location(l_proc,40);
465: close csr_chk_job_id_exists;
466: fnd_message.set_name('PER','PER_52484_SSM_INVL_JOB_BG');
467: fnd_message.raise_error;
468: --

Line 472: hr_utility.set_location(l_proc,42);

468: --
469: Elsif (p_ssl_start_date > l_parent_end_date) or
470: (p_ssl_end_date < l_parent_start_date) then
471: --
472: hr_utility.set_location(l_proc,42);
473: close csr_chk_job_id_exists;
474: fnd_message.set_name('PER','PER_52485_SSM_JOB_DATE_INVL');
475: fnd_message.raise_error;
476: Else

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

474: fnd_message.set_name('PER','PER_52485_SSM_JOB_DATE_INVL');
475: fnd_message.raise_error;
476: Else
477: --
478: hr_utility.set_location(l_proc,45);
479: --
480: close csr_chk_job_id_exists;
481: End if;
482: --

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

481: End if;
482: --
483: Elsif p_parent_table_name = 'PER_POSITIONS' then
484: --
485: hr_utility.set_location(l_proc,50);
486: --
487: open csr_chk_position_id_exists;
488: --
489: fetch csr_chk_position_id_exists into l_business_group_id,l_parent_start_date,l_parent_end_date;

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

488: --
489: fetch csr_chk_position_id_exists into l_business_group_id,l_parent_start_date,l_parent_end_date;
490: If csr_chk_position_id_exists%notfound Then
491: --
492: hr_utility.set_location(l_proc,55);
493: --
494: close csr_chk_position_id_exists;
495: --
496: -- raise error as FK does not relate to PK in per_jobs

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

499: fnd_message.set_name('PER','PER_52486_SSM_INVL_POS_ID');
500: fnd_message.raise_error;
501: Elsif l_business_group_id <> p_business_group_id then
502: --
503: hr_utility.set_location(l_proc,60);
504: --
505: close csr_chk_position_id_exists;
506: fnd_message.set_name('PER','PER_52487_SSM_INVL_POS_BG');
507: fnd_message.raise_error;

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

509: Elsif (p_ssl_start_date > nvl(l_parent_end_date,hr_api.g_eot)) or
510: (nvl(p_ssl_end_date,hr_api.g_eot)< l_parent_start_date) then
511:
512: --
513: hr_utility.set_location(l_proc,62);
514: hr_utility.set_location('SSL start '||to_char(p_ssl_start_date,'DD-MON-YYYY'),62);
515: hr_utility.set_location('SSL end '||to_char(p_ssl_end_date,'DD-MON-YYYY'),62);
516: hr_utility.set_location('parent start '||to_char(l_parent_start_date,'DD-MON-YYYY'),62);
517: hr_utility.set_location('parent end '||to_char(l_parent_end_date,'DD-MON-YYYY'),62);

Line 514: hr_utility.set_location('SSL start '||to_char(p_ssl_start_date,'DD-MON-YYYY'),62);

510: (nvl(p_ssl_end_date,hr_api.g_eot)< l_parent_start_date) then
511:
512: --
513: hr_utility.set_location(l_proc,62);
514: hr_utility.set_location('SSL start '||to_char(p_ssl_start_date,'DD-MON-YYYY'),62);
515: hr_utility.set_location('SSL end '||to_char(p_ssl_end_date,'DD-MON-YYYY'),62);
516: hr_utility.set_location('parent start '||to_char(l_parent_start_date,'DD-MON-YYYY'),62);
517: hr_utility.set_location('parent end '||to_char(l_parent_end_date,'DD-MON-YYYY'),62);
518: close csr_chk_position_id_exists;

Line 515: hr_utility.set_location('SSL end '||to_char(p_ssl_end_date,'DD-MON-YYYY'),62);

511:
512: --
513: hr_utility.set_location(l_proc,62);
514: hr_utility.set_location('SSL start '||to_char(p_ssl_start_date,'DD-MON-YYYY'),62);
515: hr_utility.set_location('SSL end '||to_char(p_ssl_end_date,'DD-MON-YYYY'),62);
516: hr_utility.set_location('parent start '||to_char(l_parent_start_date,'DD-MON-YYYY'),62);
517: hr_utility.set_location('parent end '||to_char(l_parent_end_date,'DD-MON-YYYY'),62);
518: close csr_chk_position_id_exists;
519: fnd_message.set_name('PER','PER_52488_SSM_POS_DATE_INVL');

Line 516: hr_utility.set_location('parent start '||to_char(l_parent_start_date,'DD-MON-YYYY'),62);

512: --
513: hr_utility.set_location(l_proc,62);
514: hr_utility.set_location('SSL start '||to_char(p_ssl_start_date,'DD-MON-YYYY'),62);
515: hr_utility.set_location('SSL end '||to_char(p_ssl_end_date,'DD-MON-YYYY'),62);
516: hr_utility.set_location('parent start '||to_char(l_parent_start_date,'DD-MON-YYYY'),62);
517: hr_utility.set_location('parent end '||to_char(l_parent_end_date,'DD-MON-YYYY'),62);
518: close csr_chk_position_id_exists;
519: fnd_message.set_name('PER','PER_52488_SSM_POS_DATE_INVL');
520: fnd_message.raise_error;

Line 517: hr_utility.set_location('parent end '||to_char(l_parent_end_date,'DD-MON-YYYY'),62);

513: hr_utility.set_location(l_proc,62);
514: hr_utility.set_location('SSL start '||to_char(p_ssl_start_date,'DD-MON-YYYY'),62);
515: hr_utility.set_location('SSL end '||to_char(p_ssl_end_date,'DD-MON-YYYY'),62);
516: hr_utility.set_location('parent start '||to_char(l_parent_start_date,'DD-MON-YYYY'),62);
517: hr_utility.set_location('parent end '||to_char(l_parent_end_date,'DD-MON-YYYY'),62);
518: close csr_chk_position_id_exists;
519: fnd_message.set_name('PER','PER_52488_SSM_POS_DATE_INVL');
520: fnd_message.raise_error;
521: Else

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

519: fnd_message.set_name('PER','PER_52488_SSM_POS_DATE_INVL');
520: fnd_message.raise_error;
521: Else
522: --
523: hr_utility.set_location(l_proc,65);
524: --
525: close csr_chk_position_id_exists;
526: End if;
527: Elsif p_parent_table_name = 'PER_ASSIGNMENTS' then

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

525: close csr_chk_position_id_exists;
526: End if;
527: Elsif p_parent_table_name = 'PER_ASSIGNMENTS' then
528: --
529: hr_utility.set_location(l_proc,50);
530: --
531: open csr_chk_assignment_id_exists;
532: --
533: fetch csr_chk_assignment_id_exists into l_business_group_id,l_parent_start_date,l_parent_end_date;

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

532: --
533: fetch csr_chk_assignment_id_exists into l_business_group_id,l_parent_start_date,l_parent_end_date;
534: If csr_chk_assignment_id_exists%notfound Then
535: --
536: hr_utility.set_location(l_proc,55);
537: --
538: close csr_chk_assignment_id_exists;
539: --
540: -- raise error as FK does not relate to PK in per_jobs

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

543: fnd_message.set_name('PER','PER_SSM_INVL_ASG_ID');
544: fnd_message.raise_error;
545: Elsif l_business_group_id <> p_business_group_id then
546: --
547: hr_utility.set_location(l_proc,60);
548: --
549: close csr_chk_assignment_id_exists;
550: fnd_message.set_name('PER','PER_SSM_INVL_ASG_BG');
551: fnd_message.raise_error;

Line 557: hr_utility.set_location(l_proc,62);

553: Elsif (p_ssl_start_date > nvl(l_parent_end_date,hr_api.g_eot)) or
554: (nvl(p_ssl_end_date,hr_api.g_eot)< l_parent_start_date) then
555:
556: --
557: hr_utility.set_location(l_proc,62);
558: hr_utility.set_location('SSL start '||to_char(p_ssl_start_date,'DD-MON-YYYY'),62);
559: hr_utility.set_location('SSL end '||to_char(p_ssl_end_date,'DD-MON-YYYY'),62);
560: hr_utility.set_location('parent start '||to_char(l_parent_start_date,'DD-MON-YYYY'),62);
561: hr_utility.set_location('parent end '||to_char(l_parent_end_date,'DD-MON-YYYY'),62);

Line 558: hr_utility.set_location('SSL start '||to_char(p_ssl_start_date,'DD-MON-YYYY'),62);

554: (nvl(p_ssl_end_date,hr_api.g_eot)< l_parent_start_date) then
555:
556: --
557: hr_utility.set_location(l_proc,62);
558: hr_utility.set_location('SSL start '||to_char(p_ssl_start_date,'DD-MON-YYYY'),62);
559: hr_utility.set_location('SSL end '||to_char(p_ssl_end_date,'DD-MON-YYYY'),62);
560: hr_utility.set_location('parent start '||to_char(l_parent_start_date,'DD-MON-YYYY'),62);
561: hr_utility.set_location('parent end '||to_char(l_parent_end_date,'DD-MON-YYYY'),62);
562: close csr_chk_position_id_exists;

Line 559: hr_utility.set_location('SSL end '||to_char(p_ssl_end_date,'DD-MON-YYYY'),62);

555:
556: --
557: hr_utility.set_location(l_proc,62);
558: hr_utility.set_location('SSL start '||to_char(p_ssl_start_date,'DD-MON-YYYY'),62);
559: hr_utility.set_location('SSL end '||to_char(p_ssl_end_date,'DD-MON-YYYY'),62);
560: hr_utility.set_location('parent start '||to_char(l_parent_start_date,'DD-MON-YYYY'),62);
561: hr_utility.set_location('parent end '||to_char(l_parent_end_date,'DD-MON-YYYY'),62);
562: close csr_chk_position_id_exists;
563: fnd_message.set_name('PER','PER_SSM_ASG_DATE_INVL');

Line 560: hr_utility.set_location('parent start '||to_char(l_parent_start_date,'DD-MON-YYYY'),62);

556: --
557: hr_utility.set_location(l_proc,62);
558: hr_utility.set_location('SSL start '||to_char(p_ssl_start_date,'DD-MON-YYYY'),62);
559: hr_utility.set_location('SSL end '||to_char(p_ssl_end_date,'DD-MON-YYYY'),62);
560: hr_utility.set_location('parent start '||to_char(l_parent_start_date,'DD-MON-YYYY'),62);
561: hr_utility.set_location('parent end '||to_char(l_parent_end_date,'DD-MON-YYYY'),62);
562: close csr_chk_position_id_exists;
563: fnd_message.set_name('PER','PER_SSM_ASG_DATE_INVL');
564: fnd_message.raise_error;

Line 561: hr_utility.set_location('parent end '||to_char(l_parent_end_date,'DD-MON-YYYY'),62);

557: hr_utility.set_location(l_proc,62);
558: hr_utility.set_location('SSL start '||to_char(p_ssl_start_date,'DD-MON-YYYY'),62);
559: hr_utility.set_location('SSL end '||to_char(p_ssl_end_date,'DD-MON-YYYY'),62);
560: hr_utility.set_location('parent start '||to_char(l_parent_start_date,'DD-MON-YYYY'),62);
561: hr_utility.set_location('parent end '||to_char(l_parent_end_date,'DD-MON-YYYY'),62);
562: close csr_chk_position_id_exists;
563: fnd_message.set_name('PER','PER_SSM_ASG_DATE_INVL');
564: fnd_message.raise_error;
565: Else

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

563: fnd_message.set_name('PER','PER_SSM_ASG_DATE_INVL');
564: fnd_message.raise_error;
565: Else
566: --
567: hr_utility.set_location(l_proc,65);
568: --
569: close csr_chk_assignment_id_exists;
570: End if;
571: Else

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

570: End if;
571: Else
572:
573: --
574: hr_utility.set_location(l_proc,70);
575: --
576: -- Invalid parent_table_name.
577: fnd_message.set_name('PER','PER_52489_SSM_INVL_TBL_NAME');
578: fnd_message.raise_error;

Line 584: hr_utility.set_location('Leaving:'||l_proc,150);

580: End If;
581: End If;
582: --
583: --
584: hr_utility.set_location('Leaving:'||l_proc,150);
585: --
586: End chk_parent;
587: --
588: --

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

648: --
649: --
650: Begin
651: --
652: hr_utility.set_location('Entering:'||l_proc,5);
653: --
654: -- Check mandatory parameters have been set
655: --
656: hr_utility.set_location(l_proc,6);

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

652: hr_utility.set_location('Entering:'||l_proc,5);
653: --
654: -- Check mandatory parameters have been set
655: --
656: hr_utility.set_location(l_proc,6);
657: --
658: l_api_updating := per_ssm_shd.api_updating
659: (p_salary_survey_mapping_id => p_salary_survey_mapping_id,
660: p_object_version_number => p_object_version_number);

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

658: l_api_updating := per_ssm_shd.api_updating
659: (p_salary_survey_mapping_id => p_salary_survey_mapping_id,
660: p_object_version_number => p_object_version_number);
661: --
662: hr_utility.set_location(l_proc,8);
663: --
664: If not l_api_updating then
665: open csr_chk_unique_key;
666: fetch csr_chk_unique_key into l_exists;

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

672: End If;
673: End If;
674: --
675: --
676: hr_utility.set_location('Leaving:'||l_proc,10);
677: --
678: End chk_unique_key;
679: --
680: --

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

721: ;
722: --
723: Begin
724: --
725: hr_utility.set_location('Entering:'||l_proc,5);
726: --
727: -- Check mandatory parameters have been set
728: --
729: --

Line 736: hr_utility.set_location('Entering:'||l_proc,6);

732: open csr_chk_location_exists;
733: fetch csr_chk_location_exists into l_loc_date_to;
734: If csr_chk_location_exists%notfound then
735: --
736: hr_utility.set_location('Entering:'||l_proc,6);
737: --
738: close csr_chk_location_exists;
739: --
740: -- raise error as FK does not relate to PK in hr_locations

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

750: fnd_message.raise_error;
751: --
752: Else
753: --
754: hr_utility.set_location('Entering:'||l_proc,7);
755: --
756: close csr_chk_location_exists;
757: End If;
758: End if;

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

755: --
756: close csr_chk_location_exists;
757: End If;
758: End if;
759: hr_utility.set_location('Leaving:'||l_proc,10);
760: --
761: End chk_location_id;
762: --
763: --

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

817: where salary_survey_mapping_id = p_salary_survey_mapping_id;
818: --
819: Begin
820: --
821: hr_utility.set_location('Entering:'||l_proc,5);
822: --
823: l_api_updating := per_ssm_shd.api_updating
824: (p_salary_survey_mapping_id => p_salary_survey_mapping_id
825: ,p_object_version_number => p_object_version_number

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

860: Else
861: close csr_chk_grade_exists;
862: End If;
863: End If;
864: hr_utility.set_location('Leaving:'||l_proc,10);
865: --
866: End chk_grade_id;
867: --
868: --

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

920: where salary_survey_mapping_id = p_salary_survey_mapping_id;
921: --
922: Begin
923: --
924: hr_utility.set_location('Entering:'||l_proc,5);
925: --
926: l_api_updating := per_ssm_shd.api_updating
927: (p_salary_survey_mapping_id => p_salary_survey_mapping_id
928: ,p_object_version_number => p_object_version_number

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

936: l_bg := p_business_group_id;
937: End If;
938: --
939: If p_company_organization_id is not null then
940: hr_utility.set_location(l_proc,10);
941: open csr_chk_company_org;
942: fetch csr_chk_company_org into l_business_group_id, l_org_date_from, l_org_date_to;
943: If csr_chk_company_org%notfound then
944: hr_utility.set_location(l_proc,25);

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

940: hr_utility.set_location(l_proc,10);
941: open csr_chk_company_org;
942: fetch csr_chk_company_org into l_business_group_id, l_org_date_from, l_org_date_to;
943: If csr_chk_company_org%notfound then
944: hr_utility.set_location(l_proc,25);
945: close csr_chk_company_org;
946: --
947: -- raise error as FK does not relate to PK in hr_all_organization_units
948: -- table.

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

950: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK5');
951: --
952: -- Elsif l_business_group_id <> p_business_group_id then
953: Elsif l_business_group_id <> l_bg then
954: hr_utility.set_location(l_proc,30);
955: close csr_chk_company_org;
956: --
957: fnd_message.set_name('PER','PER_52493_SSM_INVL_ORG_BG');
958: fnd_message.raise_error;

Line 961: hr_utility.set_location(l_proc,32);

957: fnd_message.set_name('PER','PER_52493_SSM_INVL_ORG_BG');
958: fnd_message.raise_error;
959: Elsif p_ssl_end_date < l_org_date_from
960: or p_ssl_start_date > l_org_date_to then
961: hr_utility.set_location(l_proc,32);
962: close csr_chk_company_org;
963: --
964: fnd_message.set_name('PER','PER_52494_SSM_ORG_DATE_INVL');
965: fnd_message.raise_error;

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

964: fnd_message.set_name('PER','PER_52494_SSM_ORG_DATE_INVL');
965: fnd_message.raise_error;
966: --
967: Else
968: hr_utility.set_location(l_proc,35);
969: close csr_chk_company_org;
970: End If;
971: End If;
972: hr_utility.set_location('Leaving:'||l_proc,50);

Line 972: hr_utility.set_location('Leaving:'||l_proc,50);

968: hr_utility.set_location(l_proc,35);
969: close csr_chk_company_org;
970: End If;
971: End If;
972: hr_utility.set_location('Leaving:'||l_proc,50);
973: --
974: End chk_company_organization_id;
975: --
976: --

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

1020: and l.enabled_flag = 'Y';
1021: --
1022: Begin
1023: --
1024: hr_utility.set_location('Entering:'||l_proc,5);
1025: --
1026: If p_company_age_code is not null then
1027: open csr_chk_company_age_exists;
1028: fetch csr_chk_company_age_exists into l_exists;

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

1039: Else
1040: close csr_chk_company_age_exists;
1041: End If;
1042: End If;
1043: hr_utility.set_location('Leaving:'||l_proc,10);
1044: --
1045: End chk_company_age_code;
1046: --
1047: --

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

1079: --
1080: --
1081: Begin
1082: --
1083: hr_utility.set_location('Entering:'||l_proc,5);
1084: --
1085: l_effective_date := p_effective_date;
1086: --
1087: If l_effective_date is not null then

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

1094: fnd_message.set_name('PER','PER_52496_SSM_EFF_DATE_NULL');
1095: fnd_message.raise_error;
1096: End If;
1097: --
1098: hr_utility.set_location('Leaving:'||l_proc,10);
1099: --
1100: End chk_effective_date;
1101: --
1102: --

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

1133: --
1134: l_proc varchar2(72) := g_package||'chk_df';
1135: --
1136: Begin
1137: hr_utility.set_location('Entering:'||l_proc, 10);
1138: --
1139: If ((p_rec.salary_survey_mapping_id is not null) and (
1140: nvl(per_ssm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1141: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

1233: ,p_attribute20_value => p_rec.attribute20
1234: );
1235: End If;
1236: --
1237: hr_utility.set_location(' Leaving:'||l_proc, 20);
1238: End chk_df;
1239: --
1240: --
1241: --

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

1249: l_ssl_start_date date;
1250: l_ssl_end_date date;
1251: --
1252: Begin
1253: hr_utility.set_location('Entering:'||l_proc, 5);
1254: --
1255: -- Call all supporting business operations
1256: --
1257: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

1255: -- Call all supporting business operations
1256: --
1257: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1258: --
1259: hr_utility.set_location(l_proc, 6);
1260: --
1261: chk_unique_key( p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id
1262: , p_parent_id => p_rec.parent_id
1263: , p_parent_table_name => p_rec.parent_table_name

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

1268: , p_company_age_code => p_rec.company_age_code
1269: , p_object_version_number => p_rec.object_version_number
1270: );
1271: --
1272: hr_utility.set_location(l_proc, 7);
1273: --
1274: chk_salary_survey_line_id( p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id
1275: , p_salary_survey_line_id => p_rec.salary_survey_line_id
1276: , p_object_version_number => p_rec.object_version_number

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

1278: --
1279: l_ssl_start_date := get_salary_survey_line_start( p_salary_survey_line_id => p_rec.salary_survey_line_id);
1280: --
1281: l_ssl_end_date := get_salary_survey_line_end( p_salary_survey_line_id => p_rec.salary_survey_line_id);
1282: hr_utility.set_location(l_proc, 8);
1283: --
1284: chk_parent( p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id
1285: , p_parent_id => p_rec.parent_id
1286: , p_parent_table_name => p_rec.parent_table_name

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

1289: , p_ssl_start_date => l_ssl_start_date
1290: , p_ssl_end_date => l_ssl_end_date
1291: );
1292: --
1293: hr_utility.set_location(l_proc, 9);
1294: --
1295: chk_location_id( p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id
1296: , p_location_id => p_rec.location_id
1297: , p_object_version_number => p_rec.object_version_number

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

1297: , p_object_version_number => p_rec.object_version_number
1298: , p_ssl_start_date => l_ssl_start_date
1299: );
1300: --
1301: hr_utility.set_location(l_proc, 10);
1302: --
1303: chk_grade_id( p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id
1304: , p_grade_id => p_rec.grade_id
1305: , p_business_group_id => p_rec.business_group_id

Line 1311: hr_utility.set_location(l_proc, 11);

1307: , p_ssl_start_date => l_ssl_start_date
1308: , p_ssl_end_date => l_ssl_end_date
1309: );
1310: --
1311: hr_utility.set_location(l_proc, 11);
1312: --
1313: chk_company_organization_id( p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id
1314: , p_company_organization_id => p_rec.company_organization_id
1315: , p_business_group_id => p_rec.business_group_id

Line 1321: hr_utility.set_location(l_proc, 12);

1317: , p_ssl_start_date => l_ssl_start_date
1318: , p_ssl_end_date => l_ssl_end_date
1319: );
1320: --
1321: hr_utility.set_location(l_proc, 12);
1322: --
1323: chk_company_age_code
1324: ( p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id
1325: , p_company_age_code => p_rec.company_age_code

Line 1330: hr_utility.set_location(l_proc, 13);

1326: , p_effective_date => p_effective_date
1327: , p_object_version_number => p_rec.object_version_number
1328: );
1329: --
1330: hr_utility.set_location(l_proc, 13);
1331: --
1332: chk_effective_date(p_effective_date => p_effective_date);
1333: --
1334: -- chk_df(p_rec);

Line 1336: hr_utility.set_location(' Leaving:'||l_proc, 15);

1332: chk_effective_date(p_effective_date => p_effective_date);
1333: --
1334: -- chk_df(p_rec);
1335: --
1336: hr_utility.set_location(' Leaving:'||l_proc, 15);
1337: End insert_validate;
1338: --
1339: --
1340: -- ----------------------------------------------------------------------------

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

1347: l_ssl_start_date date;
1348: l_ssl_end_date date;
1349: --
1350: Begin
1351: hr_utility.set_location('Entering:'||l_proc, 5);
1352: --
1353: -- Call all supporting business operations
1354: --
1355: -- Check that non updateable arguments have not bee updated.

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

1358: --
1359: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1360: --
1361: --
1362: hr_utility.set_location(l_proc, 6);
1363: --
1364: chk_unique_key( p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id
1365: , p_parent_id => p_rec.parent_id
1366: , p_parent_table_name => p_rec.parent_table_name

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

1371: , p_company_age_code => p_rec.company_age_code
1372: , p_object_version_number => p_rec.object_version_number
1373: );
1374: --
1375: hr_utility.set_location(l_proc, 7);
1376: --
1377: chk_salary_survey_line_id( p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id
1378: , p_salary_survey_line_id => p_rec.salary_survey_line_id
1379: , p_object_version_number => p_rec.object_version_number

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

1382: l_ssl_start_date := get_salary_survey_line_start( p_salary_survey_line_id => p_rec.salary_survey_line_id);
1383: --
1384: l_ssl_end_date := get_salary_survey_line_end( p_salary_survey_line_id => p_rec.salary_survey_line_id);
1385: --
1386: hr_utility.set_location(l_proc, 8);
1387: --
1388: chk_parent( p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id
1389: , p_parent_id => p_rec.parent_id
1390: , p_parent_table_name => p_rec.parent_table_name

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

1393: , p_ssl_start_date => l_ssl_start_date
1394: , p_ssl_end_date => l_ssl_end_date
1395: );
1396: --
1397: hr_utility.set_location(l_proc, 9);
1398: --
1399: chk_location_id( p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id
1400: , p_location_id => p_rec.location_id
1401: , p_object_version_number => p_rec.object_version_number

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

1401: , p_object_version_number => p_rec.object_version_number
1402: , p_ssl_start_date => l_ssl_start_date
1403: );
1404: --
1405: hr_utility.set_location(l_proc, 10);
1406: --
1407: chk_grade_id( p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id
1408: , p_grade_id => p_rec.grade_id
1409: , p_business_group_id => p_rec.business_group_id

Line 1415: hr_utility.set_location(l_proc, 11);

1411: , p_ssl_start_date => l_ssl_start_date
1412: , p_ssl_end_date => l_ssl_end_date
1413: );
1414: --
1415: hr_utility.set_location(l_proc, 11);
1416: --
1417: chk_company_organization_id
1418: ( p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id
1419: , p_company_organization_id => p_rec.company_organization_id

Line 1426: hr_utility.set_location(l_proc, 12);

1422: , p_ssl_start_date => l_ssl_start_date
1423: , p_ssl_end_date => l_ssl_end_date
1424: );
1425: --
1426: hr_utility.set_location(l_proc, 12);
1427: --
1428: chk_company_age_code
1429: ( p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id
1430: , p_company_age_code => p_rec.company_age_code

Line 1435: hr_utility.set_location(l_proc, 13);

1431: , p_effective_date => p_effective_date
1432: , p_object_version_number => p_rec.object_version_number
1433: );
1434: --
1435: hr_utility.set_location(l_proc, 13);
1436: --
1437: chk_effective_date(p_effective_date => p_effective_date);
1438: --
1439: -- chk_df(p_rec);

Line 1441: hr_utility.set_location(' Leaving:'||l_proc, 15);

1437: chk_effective_date(p_effective_date => p_effective_date);
1438: --
1439: -- chk_df(p_rec);
1440: --
1441: hr_utility.set_location(' Leaving:'||l_proc, 15);
1442: End update_validate;
1443: --
1444: --
1445: --

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

1450: --
1451: l_proc varchar2(72) := g_package||'delete_validate';
1452: --
1453: Begin
1454: hr_utility.set_location('Entering:'||l_proc, 5);
1455: --
1456: -- Call all supporting business operations
1457: --
1458: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1454: hr_utility.set_location('Entering:'||l_proc, 5);
1455: --
1456: -- Call all supporting business operations
1457: --
1458: hr_utility.set_location(' Leaving:'||l_proc, 10);
1459: End delete_validate;
1460: --
1461: --
1462: end per_ssm_bus;