DBA Data[Home] [Help]

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 1260: hr_utility.set_location('Entering: call - update_grade_a', 65);

1256: end;
1257: end if;
1258: --end changes for bug 6522394
1259:
1260: hr_utility.set_location('Entering: call - update_grade_a', 65);
1261: --
1262: begin
1263: --
1264: hr_grade_bk2.update_grade_a(

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

1362: p_module_name => 'UPDATE_GRADE'
1363: ,p_hook_type => 'AP');
1364: end; -- End of API User Hook for the after hook of update_grade
1365: --
1366: hr_utility.set_location(l_proc, 90);
1367: --
1368: -- When in validation only mode raise the Validate_Enabled exception
1369: if p_validate then
1370: raise hr_api.validate_enabled;

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

1373: p_object_version_number := l_object_version_number;
1374: p_grade_definition_id := l_grade_definition_id;
1375: p_name := l_name;
1376: --
1377: hr_utility.set_location(' Leaving:'||l_proc, 100);
1378: --
1379: exception
1380: --
1381: when hr_api.validate_enabled then

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

1396: when others then
1397: --
1398: -- A validation or unexpected error has occured
1399: rollback to update_grade;
1400: hr_utility.set_location(' Leaving:'||l_proc, 120);
1401: raise;
1402: --
1403: end update_grade;
1404: --

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

1414:
1415: l_object_version_number number(9);
1416: l_proc varchar2(72) := g_package||'DELETE_GRADE';
1417: begin
1418: hr_utility.set_location('Entering:'|| l_proc, 10);
1419:
1420: --
1421: -- Issue a savepoint
1422: --

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

1437: (p_module_name => 'DELETE_GRADE'
1438: ,p_hook_type => 'BP'
1439: );
1440: end;
1441: hr_utility.set_location(l_proc, 20);
1442: --
1443: -- MLS Processing
1444: --
1445: per_gdt_del.del_tl(p_grade_id => p_grade_id);

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

1443: -- MLS Processing
1444: --
1445: per_gdt_del.del_tl(p_grade_id => p_grade_id);
1446: --
1447: hr_utility.set_location(l_proc, 30);
1448: --
1449: -- Process Logic
1450: --
1451: l_object_version_number := p_object_version_number;

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

1453: per_grd_del.del
1454: (p_grade_id => p_grade_id
1455: ,p_object_version_number => l_object_version_number);
1456: --
1457: hr_utility.set_location(l_proc, 40);
1458: --
1459: -- Call After Process User Hook
1460: --
1461: begin

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

1481: --
1482: --
1483: p_object_version_number := l_object_version_number;
1484:
1485: hr_utility.set_location(' Leaving:'||l_proc, 100);
1486: exception
1487: when hr_api.validate_enabled then
1488: hr_utility.set_location(' Leaving...:'||l_proc, 80);
1489: --

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

1484:
1485: hr_utility.set_location(' Leaving:'||l_proc, 100);
1486: exception
1487: when hr_api.validate_enabled then
1488: hr_utility.set_location(' Leaving...:'||l_proc, 80);
1489: --
1490: -- As the Validate_Enabled exception has been raised
1491: -- we must rollback to the savepoint
1492: --

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

1496: -- (Any key or derived arguments must be set to null
1497: -- when validation only mode is being used.)
1498: --
1499: when others then
1500: hr_utility.set_location(' Leaving...:'||l_proc, 90);
1501: --
1502: -- A validation or unexpected error has occured
1503: --
1504: rollback to DELETE_GRADE;