DBA Data[Home] [Help]

APPS.HR_SALARY_SURVEY_LINE_API dependencies on HR_UTILITY

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

134: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
135: --
136: begin
137: --
138: hr_utility.set_location('Entering:'|| l_proc, 10);
139: --
140: -- Issue a savepoint
141: --
142: savepoint create_salary_survey_line;

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

140: -- Issue a savepoint
141: --
142: savepoint create_salary_survey_line;
143: --
144: hr_utility.set_location(l_proc, 20);
145: --
146: -- Truncate the time portion from IN date parameters to be stored in the database.
147: --
148: l_start_date := trunc(p_start_date);

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

242: ,p_hook_type => 'BP'
243: );
244: end;
245: --
246: hr_utility.set_location(l_proc, 30);
247: --
248: -- Validation in addition to Row Handlers
249: --
250: -- If we have a date overlap and the end_date of the overlapping

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

273: end if;
274: --
275: close csr_date_overlap;
276: --
277: hr_utility.set_location(l_proc, 40);
278: --
279: -- Process Logic
280: --
281: per_ssl_ins.ins(p_salary_survey_line_id => l_salary_survey_line_id,

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

362: p_attribute29 => p_attribute29,
363: p_attribute30 => p_attribute30
364: /* End Enhancement 4021737 */
365: );
366: hr_utility.set_location(l_proc, 50);
367: --
368: -- Call After Process User Hook
369: --
370: begin

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

461: (p_module_name => 'create_salary_survey_line'
462: ,p_hook_type => 'AP'
463: );
464: end;
465: hr_utility.set_location(l_proc, 60);
466: --
467: -- When in validation only mode raise the Validate_Enabled exception
468: --
469: if p_validate then

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

477: p_salary_survey_line_id := l_salary_survey_line_id;
478: p_ssl_object_version_number := l_ssl_object_version_number;
479: p_overlap_warning := l_overlap_warning;
480: --
481: hr_utility.set_location(' Leaving:'||l_proc, 70);
482: --
483: exception
484: when hr_api.validate_enabled then
485: --

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

495: p_salary_survey_line_id := null;
496: p_ssl_object_version_number := null;
497: p_overlap_warning := l_overlap_warning;
498: --
499: hr_utility.set_location(' Leaving:'||l_proc, 80);
500: --
501: when others then
502: --
503: -- A validation or unexpected error has occured

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

506: p_ssl_object_version_number := null;
507: p_overlap_warning := null;
508: rollback to create_salary_survey_line;
509: --
510: hr_utility.set_location(' Leaving:'||l_proc, 90);
511: --
512: raise;
513: --
514: end create_salary_survey_line;

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

616: l_ssl_object_version_number per_salary_survey_lines.object_version_number%TYPE;
617: --
618: begin
619: --
620: hr_utility.set_location('Entering:'|| l_proc, 10);
621: --
622: -- Issue a savepoint
623: --
624: savepoint update_salary_survey_line;

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

622: -- Issue a savepoint
623: --
624: savepoint update_salary_survey_line;
625: --
626: hr_utility.set_location(l_proc, 20);
627: --
628: -- Truncate tine portion from all IN date parameters being stored in
629: -- the database.
630: l_start_date := trunc(p_start_date);

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

724: (p_module_name => 'update_salary_survey_line'
725: ,p_hook_type => 'BP'
726: );
727: end;
728: hr_utility.set_location(l_proc, 30);
729: --
730: -- Process Logic
731: --
732: per_ssl_upd.upd(p_salary_survey_line_id => l_salary_survey_line_id,

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

810: p_attribute28 => p_attribute28,
811: p_attribute29 => p_attribute29,
812: p_attribute30 => p_attribute30
813: );
814: hr_utility.set_location(l_proc, 50);
815: --
816: -- Call After Process User Hook
817: --
818: begin

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

906: ,p_hook_type => 'AP'
907: );
908: end;
909: --
910: hr_utility.set_location(l_proc, 60);
911: --
912: -- When in validation only mode raise the Validate_Enabled exception
913: --
914: if p_validate then

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

920: -- Set all output arguments
921: --
922: p_ssl_object_version_number := l_ssl_object_version_number;
923: --
924: hr_utility.set_location(' Leaving:'||l_proc, 70);
925: --
926: exception
927: when hr_api.validate_enabled then
928: --

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

936: -- when validation only mode is being used.)
937: --
938: p_ssl_object_version_number := null;
939: --
940: hr_utility.set_location(' Leaving:'||l_proc, 80);
941: --
942: when others then
943: --
944: -- A validation or unexpected error has occured

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

945: --
946: p_ssl_object_version_number := l_ssl_object_version_number;
947: rollback to update_salary_survey_line;
948: --
949: hr_utility.set_location(' Leaving:'||l_proc, 90);
950: --
951: raise;
952: --
953: end update_salary_survey_line;

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

971: l_salary_survey_line_id per_salary_survey_lines.salary_survey_line_id%TYPE;
972: l_ssl_object_version_number per_salary_survey_lines.object_version_number%TYPE;
973: --
974: begin
975: hr_utility.set_location('Entering:'|| l_proc, 10);
976: --
977: -- Issue a savepoint
978: --
979: savepoint delete_salary_survey_line;

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

977: -- Issue a savepoint
978: --
979: savepoint delete_salary_survey_line;
980: --
981: hr_utility.set_location(l_proc, 20);
982: --
983: -- Call Before Process User Hook
984: --
985: l_salary_survey_line_id := p_salary_survey_line_id;

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

997: ,p_hook_type => 'BP'
998: );
999: end;
1000: --
1001: hr_utility.set_location(l_proc, 30);
1002: --
1003: -- Process Logic
1004: --
1005: per_ssl_del.del(p_salary_survey_line_id => l_salary_survey_line_id

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

1005: per_ssl_del.del(p_salary_survey_line_id => l_salary_survey_line_id
1006: ,p_object_version_number => l_ssl_object_version_number
1007: );
1008: --
1009: hr_utility.set_location(l_proc, 50);
1010: --
1011: -- Call After Process User Hook
1012: --
1013: begin

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

1021: (p_module_name => 'delete_salary_survey_line'
1022: ,p_hook_type => 'AP'
1023: );
1024: end;
1025: hr_utility.set_location(l_proc, 60);
1026: --
1027: -- When in validation only mode raise the Validate_Enabled exception
1028: --
1029: if p_validate then

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

1031: raise hr_api.validate_enabled;
1032: --
1033: end if;
1034: --
1035: hr_utility.set_location(' Leaving:'||l_proc, 70);
1036: --
1037: exception
1038: when hr_api.validate_enabled then
1039: --

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

1041: -- we must rollback to the savepoint
1042: --
1043: rollback to delete_salary_survey_line;
1044: --
1045: hr_utility.set_location(' Leaving:'||l_proc, 80);
1046: --
1047: when others then
1048: --
1049: -- A validation or unexpected error has occured

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

1049: -- A validation or unexpected error has occured
1050: --
1051: rollback to delete_salary_survey_line;
1052: --
1053: hr_utility.set_location(' Leaving:'||l_proc, 90);
1054: --
1055: raise;
1056: --
1057: end delete_salary_survey_line;