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.HR_SALARY_SURVEY_MAPPING_API dependencies on HR_UTILITY

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

53: l_effective_date date;
54: l_salary_survey_mapping_id number;
55: l_object_version_number number;
56: begin
57: hr_utility.set_location('Entering:'|| l_proc, 10);
58: --
59: -- Issue a savepoint
60: --
61: savepoint create_mapping;

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

58: --
59: -- Issue a savepoint
60: --
61: savepoint create_mapping;
62: hr_utility.set_location(l_proc, 20);
63: --
64: -- Truncate the time portion from all IN date parameters
65: --
66: l_effective_date := trunc(p_effective_date);

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

108: ,p_hook_type => 'BP'
109: );
110: end;
111: */
112: hr_utility.set_location(l_proc, 30);
113: --
114: -- Validation in addition to Row Handlers
115: --
116:

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

115: --
116:
117:
118:
119: hr_utility.set_location(l_proc, 40);
120: --
121: -- Process Logic
122: --
123: per_ssm_ins.ins(

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

155: ,p_effective_date => l_effective_date
156: );
157:
158:
159: hr_utility.set_location(l_proc, 50);
160: --
161: -- Call After Process User Hook
162: --
163: /*

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

203: ,p_hook_type => 'AP'
204: );
205: end;
206: */
207: hr_utility.set_location(l_proc, 60);
208: --
209: -- When in validation only mode raise the Validate_Enabled exception
210: --
211: if p_validate then

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

216: --
217: p_salary_survey_mapping_id := l_salary_survey_mapping_id;
218: p_object_version_number := l_object_version_number;
219: --
220: hr_utility.set_location(' Leaving:'||l_proc, 70);
221: exception
222: when hr_api.validate_enabled then
223: --
224: -- As the Validate_Enabled exception has been raised

Line 235: hr_utility.set_location(' Leaving:'||l_proc, 80);

231: -- when validation only mode is being used.)
232: --
233: p_salary_survey_mapping_id := null;
234: p_object_version_number := null;
235: hr_utility.set_location(' Leaving:'||l_proc, 80);
236: when others then
237: --
238: -- A validation or unexpected error has occured
239: --

Line 243: hr_utility.set_location(' Leaving:'||l_proc, 90);

239: --
240: p_salary_survey_mapping_id := null;
241: p_object_version_number := null;
242: rollback to create_mapping;
243: hr_utility.set_location(' Leaving:'||l_proc, 90);
244: raise;
245: end create_mapping;
246: --
247: -- ----------------------------------------------------------------------------

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

287: l_salary_survey_mapping_id number;
288: l_object_version_number number;
289: l_effective_date date;
290: begin
291: hr_utility.set_location('Entering:'|| l_proc, 10);
292: --
293: -- Issue a savepoint
294: --
295: savepoint update_mapping;

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

292: --
293: -- Issue a savepoint
294: --
295: savepoint update_mapping;
296: hr_utility.set_location(l_proc, 20);
297: --
298: -- Truncate the time portion from all IN date parameters
299: --
300: l_effective_date := trunc(p_effective_date);

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

341: ,p_hook_type => 'BP'
342: );
343: end;
344: */
345: hr_utility.set_location(l_proc, 30);
346: --
347: -- Validation in addition to Row Handlers
348: --
349:

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

348: --
349:
350:
351:
352: hr_utility.set_location(l_proc, 40);
353: --
354: -- Process Logic
355: --
356: per_ssm_upd.upd

Line 388: hr_utility.set_location(l_proc||' SSM OVN: '||l_object_version_number,49);

384: ,p_effective_date => l_effective_date
385: );
386:
387: p_object_version_number := l_object_version_number;
388: hr_utility.set_location(l_proc||' SSM OVN: '||l_object_version_number,49);
389:
390:
391: hr_utility.set_location(l_proc, 50);
392: /*

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

387: p_object_version_number := l_object_version_number;
388: hr_utility.set_location(l_proc||' SSM OVN: '||l_object_version_number,49);
389:
390:
391: hr_utility.set_location(l_proc, 50);
392: /*
393: --
394: -- Call After Process User Hook
395: --

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

431: ,p_hook_type => 'AP'
432: );
433: end;
434: */
435: hr_utility.set_location(l_proc, 60);
436: --
437: -- When in validation only mode raise the Validate_Enabled exception
438: --
439: if p_validate then

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

443: -- Set all output arguments
444: --
445: p_object_version_number := l_object_version_number;
446: --
447: hr_utility.set_location(' Leaving:'||l_proc, 70);
448: exception
449: when hr_api.validate_enabled then
450: --
451: -- As the Validate_Enabled exception has been raised

Line 461: hr_utility.set_location(' Leaving:'||l_proc, 80);

457: -- (Any key or derived arguments must be set to null
458: -- when validation only mode is being used.)
459: --
460: p_object_version_number := null;
461: hr_utility.set_location(' Leaving:'||l_proc, 80);
462: when others then
463: --
464: -- A validation or unexpected error has occured
465: --

Line 468: hr_utility.set_location(' Leaving:'||l_proc, 90);

464: -- A validation or unexpected error has occured
465: --
466: p_object_version_number := l_object_version_number;
467: rollback to update_mapping;
468: hr_utility.set_location(' Leaving:'||l_proc, 90);
469: raise;
470: end update_mapping;
471: --
472: -- ----------------------------------------------------------------------------

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

483: --
484:
485: l_proc varchar2(72) := g_package||'delete_mapping';
486: begin
487: hr_utility.set_location('Entering:'|| l_proc, 10);
488: --
489: -- Issue a savepoint
490: --
491: savepoint delete_mapping;

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

488: --
489: -- Issue a savepoint
490: --
491: savepoint delete_mapping;
492: hr_utility.set_location(l_proc, 20);
493: --
494: -- Truncate the time portion from all IN date parameters
495: --
496:

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

508: (p_module_name => 'DELETE_MAPPING'
509: ,p_hook_type => 'BP'
510: );
511: end;
512: hr_utility.set_location(l_proc, 30);
513: --
514: -- Validation in addition to Row Handlers
515: --
516:

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

515: --
516:
517:
518:
519: hr_utility.set_location(l_proc, 40);
520: --
521: -- Process Logic
522: --
523: per_ssm_del.del

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

524: (p_salary_survey_mapping_id => p_salary_survey_mapping_id
525: ,p_object_version_number => p_object_version_number
526: );
527: --
528: hr_utility.set_location(l_proc, 50);
529: --
530: -- Call After Process User Hook
531: --
532: begin

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

540: (p_module_name => 'DELETE_MAPPING'
541: ,p_hook_type => 'AP'
542: );
543: end;
544: hr_utility.set_location(l_proc, 60);
545: --
546: -- When in validation only mode raise the Validate_Enabled exception
547: --
548: if p_validate then

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

548: if p_validate then
549: raise hr_api.validate_enabled;
550: end if;
551: --
552: hr_utility.set_location(' Leaving:'||l_proc, 70);
553: exception
554: when hr_api.validate_enabled then
555: --
556: -- As the Validate_Enabled exception has been raised

Line 566: hr_utility.set_location(' Leaving:'||l_proc, 90);

562: --
563: -- A validation or unexpected error has occured
564: --
565: rollback to delete_mapping;
566: hr_utility.set_location(' Leaving:'||l_proc, 90);
567: raise;
568: end delete_mapping;
569: --
570: -- ----------------------------------------------------------------------------

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

664: and nvl(ssl.industry_code,hr_api.g_varchar2) = nvl(c_industry_code,hr_api.g_varchar2);
665:
666:
667: begin
668: hr_utility.set_location('Entering:'|| l_proc, 10);
669: --
670: -- Issue a savepoint
671: --
672: savepoint mass_update;

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

669: --
670: -- Issue a savepoint
671: --
672: savepoint mass_update;
673: hr_utility.set_location(l_proc, 20);
674: --
675: -- Truncate the time portion from all IN date parameters
676: --
677: l_effective_date := trunc(p_effective_date);

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

693: ,p_hook_type => 'BP'
694: );
695: end;
696: */
697: hr_utility.set_location(l_proc, 30);
698: --
699: -- Validation in addition to Row Handlers
700: --
701: hr_utility.set_location(l_proc, 40);

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

697: hr_utility.set_location(l_proc, 30);
698: --
699: -- Validation in addition to Row Handlers
700: --
701: hr_utility.set_location(l_proc, 40);
702: --
703: -- Process Logic
704: --
705: If p_job_id is null and p_position_id is null then

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

702: --
703: -- Process Logic
704: --
705: If p_job_id is null and p_position_id is null then
706: hr_utility.set_location(l_proc, 50);
707: fnd_message.set_name('PER','PER_52497_SSM_JOB_POS_NULL');
708: fnd_message.raise_error;
709: Elsif p_job_id is not null and p_position_id is not null then
710: hr_utility.set_location(l_proc, 60);

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

706: hr_utility.set_location(l_proc, 50);
707: fnd_message.set_name('PER','PER_52497_SSM_JOB_POS_NULL');
708: fnd_message.raise_error;
709: Elsif p_job_id is not null and p_position_id is not null then
710: hr_utility.set_location(l_proc, 60);
711: fnd_message.set_name('PER','PER_52498_SSM_JOB_POS_CONT_VAL');
712: fnd_message.raise_error;
713: Elsif p_job_id is not null then
714: hr_utility.set_location(l_proc, 70);

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

710: hr_utility.set_location(l_proc, 60);
711: fnd_message.set_name('PER','PER_52498_SSM_JOB_POS_CONT_VAL');
712: fnd_message.raise_error;
713: Elsif p_job_id is not null then
714: hr_utility.set_location(l_proc, 70);
715: l_parent_table_name := 'PER_JOBS';
716: open csr_get_job_dates;
717: fetch csr_get_job_dates into l_parent_date_from, l_parent_date_to;
718: If csr_get_job_dates%NOTFOUND then

Line 719: hr_utility.set_location(l_proc, 80);

715: l_parent_table_name := 'PER_JOBS';
716: open csr_get_job_dates;
717: fetch csr_get_job_dates into l_parent_date_from, l_parent_date_to;
718: If csr_get_job_dates%NOTFOUND then
719: hr_utility.set_location(l_proc, 80);
720: close csr_get_job_dates;
721: fnd_message.set_name('PER','PER_52483_SSM_INVL_JOB_ID');
722: fnd_message.raise_error;
723: Else

Line 724: hr_utility.set_location(l_proc, 90);

720: close csr_get_job_dates;
721: fnd_message.set_name('PER','PER_52483_SSM_INVL_JOB_ID');
722: fnd_message.raise_error;
723: Else
724: hr_utility.set_location(l_proc, 90);
725: close csr_get_job_dates;
726: l_max_date_from := l_parent_date_from;
727: --
728: l_min_date_to := l_parent_date_to;

Line 731: hr_utility.set_location(l_proc, 100);

727: --
728: l_min_date_to := l_parent_date_to;
729: --
730: For csr_get_mappings_rec in csr_get_mappings(l_parent_table_name) loop
731: hr_utility.set_location(l_proc, 100);
732: l_max_date_from := l_parent_date_from;
733: l_min_date_to := l_parent_date_to;
734: If csr_get_mappings_rec.max_end_date > l_max_date_from then
735: hr_utility.set_location(l_proc, 115);

Line 735: hr_utility.set_location(l_proc, 115);

731: hr_utility.set_location(l_proc, 100);
732: l_max_date_from := l_parent_date_from;
733: l_min_date_to := l_parent_date_to;
734: If csr_get_mappings_rec.max_end_date > l_max_date_from then
735: hr_utility.set_location(l_proc, 115);
736: l_max_date_from := csr_get_mappings_rec.max_end_date;
737: End If;
738: If csr_get_mappings_rec.grade_id is not null then
739: hr_utility.set_location(l_proc, 120);

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

735: hr_utility.set_location(l_proc, 115);
736: l_max_date_from := csr_get_mappings_rec.max_end_date;
737: End If;
738: If csr_get_mappings_rec.grade_id is not null then
739: hr_utility.set_location(l_proc, 120);
740: open csr_get_grade_dates(csr_get_mappings_rec.grade_id);
741: fetch csr_get_grade_dates into l_date_from, l_date_to;
742: close csr_get_grade_dates;
743: hr_utility.set_location(l_proc, 130);

Line 743: hr_utility.set_location(l_proc, 130);

739: hr_utility.set_location(l_proc, 120);
740: open csr_get_grade_dates(csr_get_mappings_rec.grade_id);
741: fetch csr_get_grade_dates into l_date_from, l_date_to;
742: close csr_get_grade_dates;
743: hr_utility.set_location(l_proc, 130);
744: If l_date_from > l_max_date_from then
745: hr_utility.set_location(l_proc, 140);
746: l_max_date_from := l_date_from;
747: End If;

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

741: fetch csr_get_grade_dates into l_date_from, l_date_to;
742: close csr_get_grade_dates;
743: hr_utility.set_location(l_proc, 130);
744: If l_date_from > l_max_date_from then
745: hr_utility.set_location(l_proc, 140);
746: l_max_date_from := l_date_from;
747: End If;
748: If l_date_to < l_min_date_to then
749: hr_utility.set_location(l_proc, 150);

Line 749: hr_utility.set_location(l_proc, 150);

745: hr_utility.set_location(l_proc, 140);
746: l_max_date_from := l_date_from;
747: End If;
748: If l_date_to < l_min_date_to then
749: hr_utility.set_location(l_proc, 150);
750: l_min_date_to := l_date_to;
751: End If;
752: End If;
753: --

Line 755: hr_utility.set_location(l_proc, 160);

751: End If;
752: End If;
753: --
754: If csr_get_mappings_rec.company_organization_id is not null then
755: hr_utility.set_location(l_proc, 160);
756: open csr_get_org_dates(csr_get_mappings_rec.company_organization_id);
757: fetch csr_get_org_dates into l_date_from, l_date_to;
758: close csr_get_org_dates;
759: hr_utility.set_location(l_proc, 170);

Line 759: hr_utility.set_location(l_proc, 170);

755: hr_utility.set_location(l_proc, 160);
756: open csr_get_org_dates(csr_get_mappings_rec.company_organization_id);
757: fetch csr_get_org_dates into l_date_from, l_date_to;
758: close csr_get_org_dates;
759: hr_utility.set_location(l_proc, 170);
760: If l_date_from > l_max_date_from then
761: hr_utility.set_location(l_proc, 180);
762: l_max_date_from := l_date_from;
763: End If;

Line 761: hr_utility.set_location(l_proc, 180);

757: fetch csr_get_org_dates into l_date_from, l_date_to;
758: close csr_get_org_dates;
759: hr_utility.set_location(l_proc, 170);
760: If l_date_from > l_max_date_from then
761: hr_utility.set_location(l_proc, 180);
762: l_max_date_from := l_date_from;
763: End If;
764: If l_date_to < l_min_date_to then
765: hr_utility.set_location(l_proc, 190);

Line 765: hr_utility.set_location(l_proc, 190);

761: hr_utility.set_location(l_proc, 180);
762: l_max_date_from := l_date_from;
763: End If;
764: If l_date_to < l_min_date_to then
765: hr_utility.set_location(l_proc, 190);
766: l_min_date_to := l_date_to;
767: End If;
768: hr_utility.set_location(l_proc, 192);
769: End If;

Line 768: hr_utility.set_location(l_proc, 192);

764: If l_date_to < l_min_date_to then
765: hr_utility.set_location(l_proc, 190);
766: l_min_date_to := l_date_to;
767: End If;
768: hr_utility.set_location(l_proc, 192);
769: End If;
770: --
771: hr_utility.set_location(l_proc||' Location ID: '||csr_get_mappings_rec.location_id,195);
772: hr_utility.set_location(l_proc||' Grade ID: '||csr_get_mappings_rec.grade_id,196);

Line 771: hr_utility.set_location(l_proc||' Location ID: '||csr_get_mappings_rec.location_id,195);

767: End If;
768: hr_utility.set_location(l_proc, 192);
769: End If;
770: --
771: hr_utility.set_location(l_proc||' Location ID: '||csr_get_mappings_rec.location_id,195);
772: hr_utility.set_location(l_proc||' Grade ID: '||csr_get_mappings_rec.grade_id,196);
773: hr_utility.set_location(l_proc||' Org ID: '||csr_get_mappings_rec.company_organization_id,197);
774: hr_utility.set_location(l_proc||' Comp Age Code: '||csr_get_mappings_rec.company_age_code,198);
775: --

Line 772: hr_utility.set_location(l_proc||' Grade ID: '||csr_get_mappings_rec.grade_id,196);

768: hr_utility.set_location(l_proc, 192);
769: End If;
770: --
771: hr_utility.set_location(l_proc||' Location ID: '||csr_get_mappings_rec.location_id,195);
772: hr_utility.set_location(l_proc||' Grade ID: '||csr_get_mappings_rec.grade_id,196);
773: hr_utility.set_location(l_proc||' Org ID: '||csr_get_mappings_rec.company_organization_id,197);
774: hr_utility.set_location(l_proc||' Comp Age Code: '||csr_get_mappings_rec.company_age_code,198);
775: --
776: For csr_get_ssl_ids_rec in csr_get_ssl_ids(csr_get_mappings_rec.survey_job_name_code

Line 773: hr_utility.set_location(l_proc||' Org ID: '||csr_get_mappings_rec.company_organization_id,197);

769: End If;
770: --
771: hr_utility.set_location(l_proc||' Location ID: '||csr_get_mappings_rec.location_id,195);
772: hr_utility.set_location(l_proc||' Grade ID: '||csr_get_mappings_rec.grade_id,196);
773: hr_utility.set_location(l_proc||' Org ID: '||csr_get_mappings_rec.company_organization_id,197);
774: hr_utility.set_location(l_proc||' Comp Age Code: '||csr_get_mappings_rec.company_age_code,198);
775: --
776: For csr_get_ssl_ids_rec in csr_get_ssl_ids(csr_get_mappings_rec.survey_job_name_code
777: ,csr_get_mappings_rec.survey_region_code

Line 774: hr_utility.set_location(l_proc||' Comp Age Code: '||csr_get_mappings_rec.company_age_code,198);

770: --
771: hr_utility.set_location(l_proc||' Location ID: '||csr_get_mappings_rec.location_id,195);
772: hr_utility.set_location(l_proc||' Grade ID: '||csr_get_mappings_rec.grade_id,196);
773: hr_utility.set_location(l_proc||' Org ID: '||csr_get_mappings_rec.company_organization_id,197);
774: hr_utility.set_location(l_proc||' Comp Age Code: '||csr_get_mappings_rec.company_age_code,198);
775: --
776: For csr_get_ssl_ids_rec in csr_get_ssl_ids(csr_get_mappings_rec.survey_job_name_code
777: ,csr_get_mappings_rec.survey_region_code
778: ,csr_get_mappings_rec.survey_seniority_code

Line 783: hr_utility.set_location(l_proc||' SSL ID: '||csr_get_ssl_ids_rec.salary_survey_line_id,199);

779: ,csr_get_mappings_rec.company_size_code
780: ,csr_get_mappings_rec.industry_code
781: ,l_max_date_from
782: ,l_min_date_to) Loop
783: hr_utility.set_location(l_proc||' SSL ID: '||csr_get_ssl_ids_rec.salary_survey_line_id,199);
784: --
785: hr_utility.set_location(l_proc, 200);
786: create_mapping
787: (p_validate => FALSE

Line 785: hr_utility.set_location(l_proc, 200);

781: ,l_max_date_from
782: ,l_min_date_to) Loop
783: hr_utility.set_location(l_proc||' SSL ID: '||csr_get_ssl_ids_rec.salary_survey_line_id,199);
784: --
785: hr_utility.set_location(l_proc, 200);
786: create_mapping
787: (p_validate => FALSE
788: ,p_effective_date => l_effective_date
789: ,p_business_group_id => p_business_group_id

Line 800: hr_utility.set_location(l_proc, 210);

796: ,p_company_age_code => csr_get_mappings_rec.company_age_code
797: ,p_salary_survey_mapping_id => l_salary_survey_mapping_id
798: ,p_object_version_number => l_object_version_number
799: );
800: hr_utility.set_location(l_proc, 210);
801: End loop;
802: End Loop;
803: End If;
804: Elsif p_position_id is not null then

Line 819: hr_utility.set_location(l_proc, 300);

815: --
816: l_min_date_to := l_parent_date_to;
817: --
818: For csr_get_mappings_rec in csr_get_mappings(l_parent_table_name) loop
819: hr_utility.set_location(l_proc, 300);
820: l_max_date_from := l_parent_date_from;
821: l_min_date_to := l_parent_date_to;
822: If csr_get_mappings_rec.max_end_date > l_max_date_from then
823: hr_utility.set_location(l_proc, 310);

Line 823: hr_utility.set_location(l_proc, 310);

819: hr_utility.set_location(l_proc, 300);
820: l_max_date_from := l_parent_date_from;
821: l_min_date_to := l_parent_date_to;
822: If csr_get_mappings_rec.max_end_date > l_max_date_from then
823: hr_utility.set_location(l_proc, 310);
824: l_max_date_from := csr_get_mappings_rec.max_end_date;
825: End If;
826: If csr_get_mappings_rec.grade_id is not null then
827: hr_utility.set_location(l_proc, 320);

Line 827: hr_utility.set_location(l_proc, 320);

823: hr_utility.set_location(l_proc, 310);
824: l_max_date_from := csr_get_mappings_rec.max_end_date;
825: End If;
826: If csr_get_mappings_rec.grade_id is not null then
827: hr_utility.set_location(l_proc, 320);
828: open csr_get_grade_dates(csr_get_mappings_rec.grade_id);
829: fetch csr_get_grade_dates into l_date_from, l_date_to;
830: close csr_get_grade_dates;
831: hr_utility.set_location(l_proc, 330);

Line 831: hr_utility.set_location(l_proc, 330);

827: hr_utility.set_location(l_proc, 320);
828: open csr_get_grade_dates(csr_get_mappings_rec.grade_id);
829: fetch csr_get_grade_dates into l_date_from, l_date_to;
830: close csr_get_grade_dates;
831: hr_utility.set_location(l_proc, 330);
832: If l_date_from > l_max_date_from then
833: hr_utility.set_location(l_proc, 340);
834: l_max_date_from := l_date_from;
835: End If;

Line 833: hr_utility.set_location(l_proc, 340);

829: fetch csr_get_grade_dates into l_date_from, l_date_to;
830: close csr_get_grade_dates;
831: hr_utility.set_location(l_proc, 330);
832: If l_date_from > l_max_date_from then
833: hr_utility.set_location(l_proc, 340);
834: l_max_date_from := l_date_from;
835: End If;
836: If l_date_to < l_min_date_to then
837: hr_utility.set_location(l_proc, 350);

Line 837: hr_utility.set_location(l_proc, 350);

833: hr_utility.set_location(l_proc, 340);
834: l_max_date_from := l_date_from;
835: End If;
836: If l_date_to < l_min_date_to then
837: hr_utility.set_location(l_proc, 350);
838: l_min_date_to := l_date_to;
839: End If;
840: End If;
841: --

Line 843: hr_utility.set_location(l_proc, 360);

839: End If;
840: End If;
841: --
842: If csr_get_mappings_rec.company_organization_id is not null then
843: hr_utility.set_location(l_proc, 360);
844: open csr_get_org_dates(csr_get_mappings_rec.company_organization_id);
845: fetch csr_get_org_dates into l_date_from, l_date_to;
846: close csr_get_org_dates;
847: hr_utility.set_location(l_proc, 370);

Line 847: hr_utility.set_location(l_proc, 370);

843: hr_utility.set_location(l_proc, 360);
844: open csr_get_org_dates(csr_get_mappings_rec.company_organization_id);
845: fetch csr_get_org_dates into l_date_from, l_date_to;
846: close csr_get_org_dates;
847: hr_utility.set_location(l_proc, 370);
848: If l_date_from > l_max_date_from then
849: hr_utility.set_location(l_proc, 380);
850: l_max_date_from := l_date_from;
851: End If;

Line 849: hr_utility.set_location(l_proc, 380);

845: fetch csr_get_org_dates into l_date_from, l_date_to;
846: close csr_get_org_dates;
847: hr_utility.set_location(l_proc, 370);
848: If l_date_from > l_max_date_from then
849: hr_utility.set_location(l_proc, 380);
850: l_max_date_from := l_date_from;
851: End If;
852: If l_date_to < l_min_date_to then
853: hr_utility.set_location(l_proc, 390);

Line 853: hr_utility.set_location(l_proc, 390);

849: hr_utility.set_location(l_proc, 380);
850: l_max_date_from := l_date_from;
851: End If;
852: If l_date_to < l_min_date_to then
853: hr_utility.set_location(l_proc, 390);
854: l_min_date_to := l_date_to;
855: End If;
856: hr_utility.set_location(l_proc, 392);
857: End If;

Line 856: hr_utility.set_location(l_proc, 392);

852: If l_date_to < l_min_date_to then
853: hr_utility.set_location(l_proc, 390);
854: l_min_date_to := l_date_to;
855: End If;
856: hr_utility.set_location(l_proc, 392);
857: End If;
858: --
859: hr_utility.set_location(l_proc||' Location ID: '||csr_get_mappings_rec.location_id,395);
860: hr_utility.set_location(l_proc||' Grade ID: '||csr_get_mappings_rec.grade_id,396);

Line 859: hr_utility.set_location(l_proc||' Location ID: '||csr_get_mappings_rec.location_id,395);

855: End If;
856: hr_utility.set_location(l_proc, 392);
857: End If;
858: --
859: hr_utility.set_location(l_proc||' Location ID: '||csr_get_mappings_rec.location_id,395);
860: hr_utility.set_location(l_proc||' Grade ID: '||csr_get_mappings_rec.grade_id,396);
861: hr_utility.set_location(l_proc||' Org ID: '||csr_get_mappings_rec.company_organization_id,397);
862: hr_utility.set_location(l_proc||' Comp Age Code: '||csr_get_mappings_rec.company_age_code,398);
863: --

Line 860: hr_utility.set_location(l_proc||' Grade ID: '||csr_get_mappings_rec.grade_id,396);

856: hr_utility.set_location(l_proc, 392);
857: End If;
858: --
859: hr_utility.set_location(l_proc||' Location ID: '||csr_get_mappings_rec.location_id,395);
860: hr_utility.set_location(l_proc||' Grade ID: '||csr_get_mappings_rec.grade_id,396);
861: hr_utility.set_location(l_proc||' Org ID: '||csr_get_mappings_rec.company_organization_id,397);
862: hr_utility.set_location(l_proc||' Comp Age Code: '||csr_get_mappings_rec.company_age_code,398);
863: --
864: For csr_get_ssl_ids_rec in csr_get_ssl_ids(csr_get_mappings_rec.survey_job_name_code

Line 861: hr_utility.set_location(l_proc||' Org ID: '||csr_get_mappings_rec.company_organization_id,397);

857: End If;
858: --
859: hr_utility.set_location(l_proc||' Location ID: '||csr_get_mappings_rec.location_id,395);
860: hr_utility.set_location(l_proc||' Grade ID: '||csr_get_mappings_rec.grade_id,396);
861: hr_utility.set_location(l_proc||' Org ID: '||csr_get_mappings_rec.company_organization_id,397);
862: hr_utility.set_location(l_proc||' Comp Age Code: '||csr_get_mappings_rec.company_age_code,398);
863: --
864: For csr_get_ssl_ids_rec in csr_get_ssl_ids(csr_get_mappings_rec.survey_job_name_code
865: ,csr_get_mappings_rec.survey_region_code

Line 862: hr_utility.set_location(l_proc||' Comp Age Code: '||csr_get_mappings_rec.company_age_code,398);

858: --
859: hr_utility.set_location(l_proc||' Location ID: '||csr_get_mappings_rec.location_id,395);
860: hr_utility.set_location(l_proc||' Grade ID: '||csr_get_mappings_rec.grade_id,396);
861: hr_utility.set_location(l_proc||' Org ID: '||csr_get_mappings_rec.company_organization_id,397);
862: hr_utility.set_location(l_proc||' Comp Age Code: '||csr_get_mappings_rec.company_age_code,398);
863: --
864: For csr_get_ssl_ids_rec in csr_get_ssl_ids(csr_get_mappings_rec.survey_job_name_code
865: ,csr_get_mappings_rec.survey_region_code
866: ,csr_get_mappings_rec.survey_seniority_code

Line 871: hr_utility.set_location(l_proc||' SSL ID: '||csr_get_ssl_ids_rec.salary_survey_line_id,399);

867: ,csr_get_mappings_rec.company_size_code
868: ,csr_get_mappings_rec.industry_code
869: ,l_max_date_from
870: ,l_min_date_to) Loop
871: hr_utility.set_location(l_proc||' SSL ID: '||csr_get_ssl_ids_rec.salary_survey_line_id,399);
872: --
873: hr_utility.set_location(l_proc, 400);
874: create_mapping
875: (p_validate => FALSE

Line 873: hr_utility.set_location(l_proc, 400);

869: ,l_max_date_from
870: ,l_min_date_to) Loop
871: hr_utility.set_location(l_proc||' SSL ID: '||csr_get_ssl_ids_rec.salary_survey_line_id,399);
872: --
873: hr_utility.set_location(l_proc, 400);
874: create_mapping
875: (p_validate => FALSE
876: ,p_effective_date => l_effective_date
877: ,p_business_group_id => p_business_group_id

Line 888: hr_utility.set_location(l_proc, 410);

884: ,p_company_age_code => csr_get_mappings_rec.company_age_code
885: ,p_salary_survey_mapping_id => l_salary_survey_mapping_id
886: ,p_object_version_number => l_object_version_number
887: );
888: hr_utility.set_location(l_proc, 410);
889: End loop;
890: End Loop;
891: End If;
892: End If;

Line 893: hr_utility.set_location(l_proc, 500);

889: End loop;
890: End Loop;
891: End If;
892: End If;
893: hr_utility.set_location(l_proc, 500);
894: --
895: -- Call After Process User Hook
896: --
897: /*

Line 913: hr_utility.set_location(l_proc, 510);

909: ,p_hook_type => 'AP'
910: );
911: end;
912: */
913: hr_utility.set_location(l_proc, 510);
914: --
915: -- When in validation only mode raise the Validate_Enabled exception
916: --
917: if p_validate then

Line 923: hr_utility.set_location(' Leaving:'||l_proc, 520);

919: end if;
920: --
921: -- Set all output arguments
922: --
923: hr_utility.set_location(' Leaving:'||l_proc, 520);
924: exception
925: when hr_api.validate_enabled then
926: --
927: -- As the Validate_Enabled exception has been raised

Line 932: hr_utility.set_location(' Leaving:'||l_proc, 530);

928: -- we must rollback to the savepoint
929: --
930: rollback to mass_update;
931: --
932: hr_utility.set_location(' Leaving:'||l_proc, 530);
933: when others then
934: --
935: -- A validation or unexpected error has occured
936: --

Line 938: hr_utility.set_location(' Leaving:'||l_proc, 540);

934: --
935: -- A validation or unexpected error has occured
936: --
937: rollback to mass_update;
938: hr_utility.set_location(' Leaving:'||l_proc, 540);
939: raise;
940: end mass_update;
941: --
942: end hr_salary_survey_mapping_api;