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

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

202: where grade_definition_id = l_grade_definition_id;
203: --
204: begin
205: --
206: hr_utility.set_location('Entering:'|| l_proc, 10);
207: --
208: -- Issue a savepoint
209: --
210: savepoint create_grade;

Line 233: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');

229: close isdel;
230: --
231: -- the flex structure has not been found
232: --
233: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');
234: hr_utility.raise_error;
235: end if;
236: close isdel;
237: --

Line 234: hr_utility.raise_error;

230: --
231: -- the flex structure has not been found
232: --
233: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');
234: hr_utility.raise_error;
235: end if;
236: close isdel;
237: --
238: -- get segment values if p_grade_definition_id entered with a value

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

240: if l_grade_definition_id is not null
241: --
242: then
243: --
244: hr_utility.set_location(l_proc, 15);
245: --
246: -- set indicator to show p_grade_definition_id did not enter program null
247: --
248: l_null_ind := 1;

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

398: then
399: --
400: -- Determine the Grade defintion by calling ins_or_sel
401: --
402: hr_utility.set_location(l_proc, 20);
403: --
404: hr_kflex_utility.ins_or_sel_keyflex_comb
405: (p_appl_short_name => 'PER'
406: ,p_flex_code => 'GRD'

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

445: then
446: --
447: -- Insert Grade.
448: --
449: hr_utility.set_location(l_proc, 30);
450: --
451: per_grd_ins.ins
452: (p_effective_date => p_effective_date
453: ,p_business_group_id => p_business_group_id

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

506: ,p_object_version_number => l_object_version_number
507: ,p_short_name => p_short_name
508: );
509: --
510: hr_utility.set_location(l_proc, 40);
511: --
512: end if;
513: --
514: -- MLS Processing

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

635: then
636: raise hr_api.validate_enabled;
637: end if;
638: --
639: hr_utility.set_location(' Leaving:'||l_proc, 50);
640: --
641: -- Set OUT parameters
642: --
643: p_grade_id := l_grade_id;

Line 648: hr_utility.set_location(' Leaving:'||l_proc, 60);

644: p_object_version_number := l_object_version_number;
645: p_grade_definition_id := l_grade_definition_id;
646: p_name := l_name;
647: --
648: hr_utility.set_location(' Leaving:'||l_proc, 60);
649: --
650: exception
651: --
652: when hr_api.validate_enabled then

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

669: p_object_version_number := null;
670: p_grade_definition_id := null;
671: p_name := null;
672: --
673: hr_utility.set_location(' Leaving:'||l_proc, 70);
674: --
675: when others then
676: --
677: -- A validation or unexpected error has occurred

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

679: --
680: --
681: ROLLBACK TO create_grade;
682: --
683: hr_utility.set_location(' Leaving:'||l_proc, 80);
684: --
685: raise;
686: --
687: end create_grade;

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

885: where grade_definition_id = l_grade_definition_id;
886: --
887: begin
888: --
889: hr_utility.set_location('Entering:'|| l_proc, 5);
890: --
891: -- Issue a savepoint
892: savepoint update_grade;
893: --

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

890: --
891: -- Issue a savepoint
892: savepoint update_grade;
893: --
894: hr_utility.set_location(l_proc, 10);
895: --
896: -- Validate the language parameter. l_language_code should be passed
897: -- instead of p_language_code from now on, to allow an IN OUT parameter to
898: -- be passed through.

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

905: l_api_updating := per_grd_shd.api_updating(
906: p_grade_id => p_grade_id
907: ,p_object_version_number => p_object_version_number);
908: --
909: hr_utility.set_location(l_proc, 15);
910: --
911: if not l_api_updating then
912: --
913: hr_utility.set_location(l_proc, 20);

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

909: hr_utility.set_location(l_proc, 15);
910: --
911: if not l_api_updating then
912: --
913: hr_utility.set_location(l_proc, 20);
914: --
915: -- As this an updating API, the grade should already exist.
916: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
917: hr_utility.raise_error;

Line 916: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

912: --
913: hr_utility.set_location(l_proc, 20);
914: --
915: -- As this an updating API, the grade should already exist.
916: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
917: hr_utility.raise_error;
918: --
919: else
920: --

Line 917: hr_utility.raise_error;

913: hr_utility.set_location(l_proc, 20);
914: --
915: -- As this an updating API, the grade should already exist.
916: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
917: hr_utility.raise_error;
918: --
919: else
920: --
921: if l_grade_definition_id is null then

Line 925: hr_utility.set_location(l_proc, 24);

921: if l_grade_definition_id is null then
922: --
923: l_null_ind := 0;
924: l_grade_definition_id := per_grd_shd.g_old_rec.grade_definition_id;
925: hr_utility.set_location(l_proc, 24);
926: --
927: else
928: --
929: -- get segment values if p_grade_definition_id entered with a value

Line 967: hr_utility.set_location(l_proc, 27);

963: l_segment29,
964: l_segment30;
965: close c_segments;
966: --
967: hr_utility.set_location(l_proc, 27);
968: --
969: end if;
970: --
971: end if;

Line 982: hr_utility.set_location('Entering: call - update_grade_b', 35);

978: close csr_old_seq;
979: end if;
980: --end changes for bug 6522394
981:
982: hr_utility.set_location('Entering: call - update_grade_b', 35);
983: --
984: -- Call Before Process User Hook
985: begin
986: --

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

1086: ,p_hook_type => 'BP');
1087: --
1088: end; -- End of API User Hook for the before hook of update_grade
1089: --
1090: hr_utility.set_location(l_proc, 30);
1091: --
1092: open isdel;
1093: fetch isdel into l_flex_num;
1094: if isdel%notfound then

Line 1096: hr_utility.set_location(l_proc, 38);

1092: open isdel;
1093: fetch isdel into l_flex_num;
1094: if isdel%notfound then
1095: --
1096: hr_utility.set_location(l_proc, 38);
1097: close isdel;
1098: --
1099: -- the flex structure has not been found
1100: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');

Line 1100: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');

1096: hr_utility.set_location(l_proc, 38);
1097: close isdel;
1098: --
1099: -- the flex structure has not been found
1100: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');
1101: hr_utility.raise_error;
1102: --
1103: end if;
1104: --

Line 1101: hr_utility.raise_error;

1097: close isdel;
1098: --
1099: -- the flex structure has not been found
1100: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');
1101: hr_utility.raise_error;
1102: --
1103: end if;
1104: --
1105: close isdel;

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

1102: --
1103: end if;
1104: --
1105: close isdel;
1106: hr_utility.set_location(l_proc, 40);
1107: l_date_from := trunc(p_date_from);
1108: l_date_to := trunc(p_date_to);
1109: --
1110: -- update grade definitions

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

1107: l_date_from := trunc(p_date_from);
1108: l_date_to := trunc(p_date_to);
1109: --
1110: -- update grade definitions
1111: hr_utility.set_location(l_proc, 50);
1112: hr_utility.trace('GRD before upd_or_sel '||l_grade_definition_id);
1113: --
1114: hr_kflex_utility.upd_or_sel_keyflex_comb(
1115: p_appl_short_name => 'PER'

Line 1112: hr_utility.trace('GRD before upd_or_sel '||l_grade_definition_id);

1108: l_date_to := trunc(p_date_to);
1109: --
1110: -- update grade definitions
1111: hr_utility.set_location(l_proc, 50);
1112: hr_utility.trace('GRD before upd_or_sel '||l_grade_definition_id);
1113: --
1114: hr_kflex_utility.upd_or_sel_keyflex_comb(
1115: p_appl_short_name => 'PER'
1116: ,p_flex_code => 'GRD'

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

1148: ,p_concat_segments_in => p_concat_segments
1149: ,p_ccid => l_grade_definition_id
1150: ,p_concat_segments_out => l_name);
1151: --
1152: hr_utility.set_location(l_proc, 60);
1153: --
1154: per_grd_upd.upd(
1155: p_effective_date => p_effective_date
1156: ,p_grade_id => p_grade_id

Line 1274: hr_utility.set_location('Entering: call - update_grade_a', 65);

1270: end;
1271: end if;
1272: --end changes for bug 6522394
1273:
1274: hr_utility.set_location('Entering: call - update_grade_a', 65);
1275: --
1276: begin
1277: --
1278: hr_grade_bk2.update_grade_a(

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

1376: p_module_name => 'UPDATE_GRADE'
1377: ,p_hook_type => 'AP');
1378: end; -- End of API User Hook for the after hook of update_grade
1379: --
1380: hr_utility.set_location(l_proc, 90);
1381: --
1382: -- When in validation only mode raise the Validate_Enabled exception
1383: if p_validate then
1384: raise hr_api.validate_enabled;

Line 1391: hr_utility.set_location(' Leaving:'||l_proc, 100);

1387: p_object_version_number := l_object_version_number;
1388: p_grade_definition_id := l_grade_definition_id;
1389: p_name := l_name;
1390: --
1391: hr_utility.set_location(' Leaving:'||l_proc, 100);
1392: --
1393: exception
1394: --
1395: when hr_api.validate_enabled then

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

1410: when others then
1411: --
1412: -- A validation or unexpected error has occured
1413: rollback to update_grade;
1414: hr_utility.set_location(' Leaving:'||l_proc, 120);
1415: raise;
1416: --
1417: end update_grade;
1418: --

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

1428:
1429: l_object_version_number number(9);
1430: l_proc varchar2(72) := g_package||'DELETE_GRADE';
1431: begin
1432: hr_utility.set_location('Entering:'|| l_proc, 10);
1433:
1434: --
1435: -- Issue a savepoint
1436: --

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

1451: (p_module_name => 'DELETE_GRADE'
1452: ,p_hook_type => 'BP'
1453: );
1454: end;
1455: hr_utility.set_location(l_proc, 20);
1456: --
1457: -- MLS Processing
1458: --
1459: per_gdt_del.del_tl(p_grade_id => p_grade_id);

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

1457: -- MLS Processing
1458: --
1459: per_gdt_del.del_tl(p_grade_id => p_grade_id);
1460: --
1461: hr_utility.set_location(l_proc, 30);
1462: --
1463: -- Process Logic
1464: --
1465: l_object_version_number := p_object_version_number;

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

1467: per_grd_del.del
1468: (p_grade_id => p_grade_id
1469: ,p_object_version_number => l_object_version_number);
1470: --
1471: hr_utility.set_location(l_proc, 40);
1472: --
1473: -- Call After Process User Hook
1474: --
1475: begin

Line 1499: hr_utility.set_location(' Leaving:'||l_proc, 100);

1495: --
1496: --
1497: p_object_version_number := l_object_version_number;
1498:
1499: hr_utility.set_location(' Leaving:'||l_proc, 100);
1500: exception
1501: when hr_api.validate_enabled then
1502: hr_utility.set_location(' Leaving...:'||l_proc, 80);
1503: --

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

1498:
1499: hr_utility.set_location(' Leaving:'||l_proc, 100);
1500: exception
1501: when hr_api.validate_enabled then
1502: hr_utility.set_location(' Leaving...:'||l_proc, 80);
1503: --
1504: -- As the Validate_Enabled exception has been raised
1505: -- we must rollback to the savepoint
1506: --

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

1510: -- (Any key or derived arguments must be set to null
1511: -- when validation only mode is being used.)
1512: --
1513: when others then
1514: hr_utility.set_location(' Leaving...:'||l_proc, 90);
1515: --
1516: -- A validation or unexpected error has occured
1517: --
1518: rollback to DELETE_GRADE;