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

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

83: l_max_scale_step per_rating_scales.max_scale_step%TYPE;
84: l_language_code per_rating_levels_tl.language%TYPE;
85: --
86: begin
87: hr_utility.set_location('Entering:'|| l_proc, 5);
88: --
89: -- Issue a savepoint.
90: --
91: savepoint create_rating_level;

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

88: --
89: -- Issue a savepoint.
90: --
91: savepoint create_rating_level;
92: hr_utility.set_location(l_proc, 6);
93:
94: l_language_code := p_language_code;
95: hr_api.validate_language_code(p_language_code => l_language_code);
96: --

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

145: -- End of Before Process User Hook call
146: --
147: -- Validation in addition to Table Handlers
148: --
149: hr_utility.set_location(l_proc, 7);
150: --
151: -- Process Logic
152: -- 1) Get min, max and object version number of competence/rating scale
153: -- 2) place lock on competence/rating scale

Line 163: hr_utility.set_message(801,'HR_51482_RTL_RSC_OR_CPN');

159: --
160: if ( ( p_rating_scale_id is not null and p_competence_id is not null )
161: or ( p_rating_scale_id is null and p_competence_id is null )
162: ) then
163: hr_utility.set_message(801,'HR_51482_RTL_RSC_OR_CPN');
164: hr_utility.raise_error;
165: end if;
166: --
167: if p_competence_id is not null then

Line 164: hr_utility.raise_error;

160: if ( ( p_rating_scale_id is not null and p_competence_id is not null )
161: or ( p_rating_scale_id is null and p_competence_id is null )
162: ) then
163: hr_utility.set_message(801,'HR_51482_RTL_RSC_OR_CPN');
164: hr_utility.raise_error;
165: end if;
166: --
167: if p_competence_id is not null then
168: -- if a rating level for a competence is being created then

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

352: );
353: end if;
354: end if;
355: --
356: hr_utility.set_location(l_proc, 8);
357: --
358: -- Call After Process User Hook
359: --
360: begin

Line 417: hr_utility.set_location(' Leaving:'||l_proc, 11);

413: p_rating_level_id := l_rating_level_id;
414: p_object_version_number := l_object_version_number;
415: p_obj_ver_number_cpn_or_rsc := l_obj_ver_number_cpn_or_rsc;
416: --
417: hr_utility.set_location(' Leaving:'||l_proc, 11);
418: exception
419: when hr_api.validate_enabled then
420: --
421: -- As the Validate_Enabled exception has been raised

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

445: raise;
446: --
447: -- End of fix.
448: --
449: hr_utility.set_location(' Leaving:'||l_proc, 12);
450: end create_rating_level;
451: --
452: --
453: -- ---------------------------------------------------------------------------

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

494: l_proc varchar2(72) := g_package||'update_rating_level';
495: l_object_version_number per_rating_levels.object_version_number%TYPE;
496: l_language_code per_rating_levels_tl.language%TYPE;
497: begin
498: hr_utility.set_location('Entering:'|| l_proc, 5);
499: --
500: -- Issue a savepoint.
501: --
502: savepoint update_rating_level;

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

500: -- Issue a savepoint.
501: --
502: savepoint update_rating_level;
503: l_language_code := p_language_code;
504: hr_utility.set_location(l_proc, 6);
505: --
506: -- Call Before Process User Hook
507: --
508: begin

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

546: -- End of Before Process User Hook call
547: --
548: -- Validation in addition to Table Handlers
549: --
550: hr_utility.set_location(l_proc, 7);
551: --
552: -- Process Logic
553: --
554: l_object_version_number := p_object_version_number;

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

590: ,p_rating_level_id => p_rating_level_id
591: ,p_name => p_name
592: ,p_behavioural_indicator => p_behavioural_indicator
593: );
594: hr_utility.set_location(l_proc, 8);
595: --
596: -- Call After Process User Hook
597: --
598: begin

Line 649: hr_utility.set_location(' Leaving:'||l_proc, 11);

645: -- object version number as the update was successful
646: --
647: p_object_version_number := l_object_version_number;
648: --
649: hr_utility.set_location(' Leaving:'||l_proc, 11);
650: exception
651: when hr_api.validate_enabled then
652: --
653: -- As the Validate_Enabled exception has been raised

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

674: raise;
675: --
676: -- End of fix.
677: --
678: hr_utility.set_location(' Leaving:'||l_proc, 12);
679: --
680: end update_rating_level;
681: --
682: --

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

749: -- competence and the rating scale api's. The actual date value itself has no
750: -- particular use at all and is not used for any sort of validation in the
751: -- api.
752: begin
753: hr_utility.set_location('Entering:'|| l_proc, 5);
754: --
755: -- Issue a savepoint.
756: --
757: savepoint delete_rating_level;

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

754: --
755: -- Issue a savepoint.
756: --
757: savepoint delete_rating_level;
758: hr_utility.set_location(l_proc, 6);
759: --
760: -- Call Before Process User Hook
761: --
762: begin

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

776: -- End of Before Process User hook
777: --
778: -- Validation in addition to Table Handlers
779: --
780: hr_utility.set_location(l_proc, 7);
781: --
782: -- Process Logic
783: -- 1) Get min and max step value from rating levels.
784: -- if inserting a rating level of competence then:

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

1019: --
1020: end if;
1021: --
1022: --
1023: hr_utility.set_location(l_proc, 8);
1024: --
1025: --
1026: -- Call After Process User Hook
1027: --

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

1049: -- Set all output parameters
1050: --
1051: p_obj_ver_number_cpn_or_rsc := l_obj_ver_number_cpn_or_rsc;
1052: --
1053: hr_utility.set_location(' Leaving:'||l_proc, 11);
1054: exception
1055: when hr_api.validate_enabled then
1056: --
1057: -- As the Validate_Enabled exception has been raised

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

1077: raise;
1078: --
1079: -- End of fix.
1080: --
1081: hr_utility.set_location(' Leaving:'||l_proc, 12);
1082: end delete_rating_level;
1083: --
1084: --
1085: -- ---------------------------------------------------------------------------

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

1138: and name = p_competence_name;
1139:
1140: begin
1141:
1142: hr_utility.set_location('Entering... ' || l_proc,10);
1143: --
1144: -- Issue a savepoint.
1145: --
1146: savepoint create_or_update_rating_level;

Line 1163: hr_utility.trace('l_effective_date : ' || l_effective_date);

1159: l_effective_date := trunc(sysdate);
1160: else
1161: l_effective_date := trunc(p_effective_date);
1162: end if;
1163: hr_utility.trace('l_effective_date : ' || l_effective_date);
1164:
1165: if (p_rating_scale_name is not NULL) then
1166: hr_utility.set_location(l_proc,40);
1167: open csr_rsc;

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

1162: end if;
1163: hr_utility.trace('l_effective_date : ' || l_effective_date);
1164:
1165: if (p_rating_scale_name is not NULL) then
1166: hr_utility.set_location(l_proc,40);
1167: open csr_rsc;
1168: fetch csr_rsc into l_rating_scale_id;
1169: if csr_rsc%NOTFOUND then
1170: close csr_rsc;

Line 1175: hr_utility.trace('l_rating_scale_id : ' || l_rating_scale_id);

1171: fnd_message.set_name('PER','HR_51928_APT_RSC_NOT_EXIST');
1172: fnd_message.raise_error;
1173: end if;
1174: close csr_rsc;
1175: hr_utility.trace('l_rating_scale_id : ' || l_rating_scale_id);
1176: end if;
1177:
1178: IF (p_translated_language IS NULL AND p_source_rating_level_name IS NULL)
1179: THEN

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

1176: end if;
1177:
1178: IF (p_translated_language IS NULL AND p_source_rating_level_name IS NULL)
1179: THEN
1180: hr_utility.set_location(l_proc,20);
1181:
1182: open csr_rtl(p_name,l_rating_scale_id);
1183: fetch csr_rtl into l_rating_level_id,l_ovn,l_step_value;
1184: if csr_rtl%NOTFOUND then

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

1186: l_rating_level_id := NULL;
1187: l_ovn := NULL;
1188: else
1189: close csr_rtl;
1190: hr_utility.set_location(l_proc,30);
1191: end if;
1192:
1193: hr_utility.trace('l_rating_level_id : ' || l_rating_level_id);
1194: hr_utility.trace('l_ovn : ' || l_ovn);

Line 1193: hr_utility.trace('l_rating_level_id : ' || l_rating_level_id);

1189: close csr_rtl;
1190: hr_utility.set_location(l_proc,30);
1191: end if;
1192:
1193: hr_utility.trace('l_rating_level_id : ' || l_rating_level_id);
1194: hr_utility.trace('l_ovn : ' || l_ovn);
1195: hr_utility.trace('l_step_value : ' || l_step_value);
1196:
1197: hr_utility.set_location(l_proc,50);

Line 1194: hr_utility.trace('l_ovn : ' || l_ovn);

1190: hr_utility.set_location(l_proc,30);
1191: end if;
1192:
1193: hr_utility.trace('l_rating_level_id : ' || l_rating_level_id);
1194: hr_utility.trace('l_ovn : ' || l_ovn);
1195: hr_utility.trace('l_step_value : ' || l_step_value);
1196:
1197: hr_utility.set_location(l_proc,50);
1198:

Line 1195: hr_utility.trace('l_step_value : ' || l_step_value);

1191: end if;
1192:
1193: hr_utility.trace('l_rating_level_id : ' || l_rating_level_id);
1194: hr_utility.trace('l_ovn : ' || l_ovn);
1195: hr_utility.trace('l_step_value : ' || l_step_value);
1196:
1197: hr_utility.set_location(l_proc,50);
1198:
1199: if (p_competence_name is not NULL) then

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

1193: hr_utility.trace('l_rating_level_id : ' || l_rating_level_id);
1194: hr_utility.trace('l_ovn : ' || l_ovn);
1195: hr_utility.trace('l_step_value : ' || l_step_value);
1196:
1197: hr_utility.set_location(l_proc,50);
1198:
1199: if (p_competence_name is not NULL) then
1200: hr_utility.trace('p_competence_name : ' || p_competence_name);
1201: open csr_comp;

Line 1200: hr_utility.trace('p_competence_name : ' || p_competence_name);

1196:
1197: hr_utility.set_location(l_proc,50);
1198:
1199: if (p_competence_name is not NULL) then
1200: hr_utility.trace('p_competence_name : ' || p_competence_name);
1201: open csr_comp;
1202: fetch csr_comp into l_competence_id;
1203: if csr_comp%NOTFOUND then
1204: close csr_comp;

Line 1209: hr_utility.trace('l_competence_id : ' || l_competence_id);

1205: fnd_message.set_name('PER','HR_52251_CEL_COMP_ID_INVL');
1206: fnd_message.raise_error;
1207: end if;
1208: close csr_comp;
1209: hr_utility.trace('l_competence_id : ' || l_competence_id);
1210: end if;
1211:
1212:
1213: if (l_rating_level_id is null and l_ovn is null) then

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

1210: end if;
1211:
1212:
1213: if (l_rating_level_id is null and l_ovn is null) then
1214: hr_utility.set_location(l_proc,60);
1215: if (p_step_value is NULL) then
1216: l_step_value := 1;
1217: else
1218: l_step_value := p_step_value;

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

1231: ,p_object_version_number => l_ovn
1232: ,p_obj_ver_number_cpn_or_rsc => l_obj_ver_number_cpn_or_rsc
1233: );
1234: else
1235: hr_utility.set_location(l_proc,70);
1236:
1237: if (p_step_value is not NULL and p_step_value <> l_step_value) then
1238: fnd_message.set_name('PER','HR_449168_NO_UPDATE_STEP_VALUE');
1239: fnd_message.raise_error;

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

1253: ELSE
1254: --
1255: -- p_translated_language is not NULL
1256: --
1257: hr_utility.set_location(l_proc,80);
1258:
1259: open csr_rtl(p_source_rating_level_name,l_rating_scale_id);
1260: fetch csr_rtl into l_source_rating_level_id,l_source_ovn,l_step_value;
1261: if csr_rtl%NOTFOUND then

Line 1263: hr_utility.set_message(800,'HR_449191_SOURCE_RTL_INVALID');

1259: open csr_rtl(p_source_rating_level_name,l_rating_scale_id);
1260: fetch csr_rtl into l_source_rating_level_id,l_source_ovn,l_step_value;
1261: if csr_rtl%NOTFOUND then
1262: close csr_rtl;
1263: hr_utility.set_message(800,'HR_449191_SOURCE_RTL_INVALID');
1264: hr_utility.raise_error;
1265: else
1266: close csr_rtl;
1267: hr_utility.set_location(l_proc,90);

Line 1264: hr_utility.raise_error;

1260: fetch csr_rtl into l_source_rating_level_id,l_source_ovn,l_step_value;
1261: if csr_rtl%NOTFOUND then
1262: close csr_rtl;
1263: hr_utility.set_message(800,'HR_449191_SOURCE_RTL_INVALID');
1264: hr_utility.raise_error;
1265: else
1266: close csr_rtl;
1267: hr_utility.set_location(l_proc,90);
1268: end if;

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

1263: hr_utility.set_message(800,'HR_449191_SOURCE_RTL_INVALID');
1264: hr_utility.raise_error;
1265: else
1266: close csr_rtl;
1267: hr_utility.set_location(l_proc,90);
1268: end if;
1269: hr_utility.trace('l_source_rating_level_id : ' || l_source_rating_level_id);
1270: hr_utility.trace('l_source_ovn : ' || l_ovn);
1271:

Line 1269: hr_utility.trace('l_source_rating_level_id : ' || l_source_rating_level_id);

1265: else
1266: close csr_rtl;
1267: hr_utility.set_location(l_proc,90);
1268: end if;
1269: hr_utility.trace('l_source_rating_level_id : ' || l_source_rating_level_id);
1270: hr_utility.trace('l_source_ovn : ' || l_ovn);
1271:
1272: l_translated_language := p_translated_language;
1273: hr_api.validate_language_code(p_language_code => l_translated_language);

Line 1270: hr_utility.trace('l_source_ovn : ' || l_ovn);

1266: close csr_rtl;
1267: hr_utility.set_location(l_proc,90);
1268: end if;
1269: hr_utility.trace('l_source_rating_level_id : ' || l_source_rating_level_id);
1270: hr_utility.trace('l_source_ovn : ' || l_ovn);
1271:
1272: l_translated_language := p_translated_language;
1273: hr_api.validate_language_code(p_language_code => l_translated_language);
1274:

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

1280: ,p_rating_level_id => l_source_rating_level_id
1281: ,p_name => p_name
1282: ,p_behavioural_indicator => p_behavioural_indicator
1283: );
1284: hr_utility.set_location(l_proc, 100);
1285: --
1286: -- Call After Process User Hook
1287: --
1288: begin

Line 1331: hr_utility.set_location('Leaving... ' || l_proc,110);

1327: -- End After Process User Hook
1328: --
1329: END IF;
1330: hr_rating_levels_api.g_ignore_df := 'N';
1331: hr_utility.set_location('Leaving... ' || l_proc,110);
1332: exception
1333: when hr_api.validate_enabled then
1334: --
1335: -- As the Validate_Enabled exception has been raised

Line 1342: hr_utility.set_location('Leaving... ' || l_proc,120);

1338: ROLLBACK TO create_or_update_rating_level;
1339: --
1340: hr_rating_levels_api.g_ignore_df := 'N';
1341: --
1342: hr_utility.set_location('Leaving... ' || l_proc,120);
1343: --
1344: when others then
1345: --
1346: -- A validation or unexpected error has occurred