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

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

87: from per_valid_grades vgr
88: where vgr.job_id = p_job_id;
89: --
90: begin
91: hr_utility.set_location('Entering:'|| l_proc, 5);
92: --
93: IF p_maintenance_mode = c_date_from THEN
94: --
95: -- When maintain_valid_grades has been called to maintain the valid grades

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

101: (p_api_name => l_proc
102: ,p_argument => 'date_effective'
103: ,p_argument_value => p_date_from);
104: --
105: hr_utility.set_location(l_proc, 10);
106: --
107: FOR c_vgr_rec IN csr_valid_grades LOOP
108: --
109: -- If a valid grade for the job has a Date From that is earlier

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

110: -- than the new Date from of the job and a Date To that is
111: -- later than that new Date from or is null, then update that
112: -- valid grade's Date From to that new Date from.
113: --
114: hr_utility.set_location(l_proc, 15);
115: if (c_vgr_rec.date_from < p_date_from and
116: nvl(c_vgr_rec.date_to, hr_api.g_eot) > p_date_from ) then
117: --
118: hr_utility.set_location(l_proc, 20);

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

114: hr_utility.set_location(l_proc, 15);
115: if (c_vgr_rec.date_from < p_date_from and
116: nvl(c_vgr_rec.date_to, hr_api.g_eot) > p_date_from ) then
117: --
118: hr_utility.set_location(l_proc, 20);
119: --
120: per_vgr_upd.upd
121: (p_valid_grade_id => c_vgr_rec.valid_grade_id
122: ,p_object_version_number => c_vgr_rec.object_version_number

Line 136: hr_utility.set_location(l_proc, 25);

132: --
133: --
134: elsif (c_vgr_rec.date_to < p_date_from) then
135: --
136: hr_utility.set_location(l_proc, 25);
137: --
138: per_vgr_del.del
139: (p_valid_grade_id => c_vgr_rec.valid_grade_id
140: ,p_object_version_number => c_vgr_rec.object_version_number

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

158: (p_api_name => l_proc
159: ,p_argument => 'date_to'
160: ,p_argument_value => p_date_to);
161: --
162: hr_utility.set_location(l_proc, 30);
163: --
164: for c_vgr_rec in csr_valid_grades loop
165: --
166: -- If a valid grade for the job has a Date From that is earlier

Line 171: hr_utility.set_location(l_proc, 35);

167: -- than the new To Date of the job and a Date To that is later than
168: -- that new To Date or is null, then update that valid grade's Date To
169: -- to that new To Date.
170: --
171: hr_utility.set_location(l_proc, 35);
172: --
173: if (c_vgr_rec.date_from < p_date_to and
174: nvl(c_vgr_rec.date_to, hr_api.g_eot) > p_date_to ) then
175: --

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

172: --
173: if (c_vgr_rec.date_from < p_date_to and
174: nvl(c_vgr_rec.date_to, hr_api.g_eot) > p_date_to ) then
175: --
176: hr_utility.set_location(l_proc, 40);
177: --
178: per_vgr_upd.upd
179: (p_valid_grade_id => c_vgr_rec.valid_grade_id
180: ,p_object_version_number => c_vgr_rec.object_version_number

Line 193: hr_utility.set_location(l_proc, 45);

189: -- valid grades.
190: --
191: elsif (c_vgr_rec.date_from > p_date_to) then
192: --
193: hr_utility.set_location(l_proc, 45);
194: --
195: per_vgr_del.del
196: (p_valid_grade_id => c_vgr_rec.valid_grade_id
197: ,p_object_version_number => c_vgr_rec.object_version_number

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

204: END LOOP;
205: --
206: END IF;
207: --
208: hr_utility.set_location(l_proc, 50);
209: --
210: p_valid_grades_changed := l_valid_grade_changed;
211: hr_utility.set_location('Leaving: '||l_proc, 55);
212: --

Line 211: hr_utility.set_location('Leaving: '||l_proc, 55);

207: --
208: hr_utility.set_location(l_proc, 50);
209: --
210: p_valid_grades_changed := l_valid_grade_changed;
211: hr_utility.set_location('Leaving: '||l_proc, 55);
212: --
213: end maintain_valid_grades;
214: --
215: -- ----------------------------------------------------------------------------

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

404: where job_definition_id = l_job_definition_id;
405: --
406: begin
407: --
408: hr_utility.set_location('Entering:'|| l_proc, 10);
409: --
410: -- Issue a savepoint
411: --
412: savepoint create_job;

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

437: close idsel;
438: --
439: -- the flex structure has not been found
440: --
441: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');
442: hr_utility.raise_error;
443: end if;
444: close idsel;
445: --

Line 442: hr_utility.raise_error;

438: --
439: -- the flex structure has not been found
440: --
441: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');
442: hr_utility.raise_error;
443: end if;
444: close idsel;
445: --
446: -- 2242339 get segment values if p_job_definition_id entered with a value

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

448: if l_job_definition_id is not null
449: --
450: then
451: --
452: hr_utility.set_location(l_proc, 15);
453: --
454: -- set indicator to show p_job_definition_id did not enter program null
455: --
456: l_null_ind := 1;

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

593: --
594: --
595: -- Determine the Grade defintion by calling ins_or_sel
596: --
597: hr_utility.set_location(l_proc, 20);
598: --
599: hr_kflex_utility.ins_or_sel_keyflex_comb
600: (p_appl_short_name => 'PER'
601: ,p_flex_code => 'JOB'

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

639: then
640: --
641: -- Insert Job.
642: --
643: hr_utility.set_location(l_proc, 30);
644: --
645: per_job_ins.ins
646: (p_job_id => l_job_id
647: ,p_business_group_id => p_business_group_id

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

707: per_jbt_ins.ins_tl( p_language_code => l_language_code
708: ,p_job_id => l_job_id
709: ,p_name => p_name);
710: --
711: hr_utility.set_location(l_proc, 40);
712: --
713: end if;
714: --
715: --

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

821: then
822: raise hr_api.validate_enabled;
823: end if;
824: --
825: hr_utility.set_location(' Leaving:'||l_proc, 50);
826: --
827: -- Set OUT parameters
828: --
829: p_job_id := l_job_id;

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

830: p_object_version_number := l_object_version_number;
831: p_job_definition_id := l_job_definition_id;
832: p_name := l_name;
833: --
834: hr_utility.set_location(' Leaving:'||l_proc, 60);
835: --
836: exception
837: --
838: when hr_api.validate_enabled then

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

855: p_object_version_number := null;
856: p_job_definition_id := null;
857: p_name := null;
858: --
859: hr_utility.set_location(' Leaving:'||l_proc, 70);
860: --
861: when others then
862: --
863: -- A validation or unexpected error has occurred

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

872: p_object_version_number := null;
873: p_name := null;
874: p_job_definition_id := l_job_definition_id;
875: --
876: hr_utility.set_location(' Leaving:'||l_proc, 80);
877: --
878: raise;
879: --
880: end create_job;

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

1079: where job_definition_id = l_job_definition_id;
1080: --
1081: begin
1082: --
1083: hr_utility.set_location('Entering:'|| l_proc, 5);
1084: --
1085: -- Issue a savepoint
1086: --
1087: savepoint update_job;

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

1091: -- be passed through.
1092: --
1093: hr_api.validate_language_code(p_language_code => l_language_code);
1094: --
1095: hr_utility.set_location(l_proc, 10);
1096: --
1097: l_object_version_number := p_object_version_number;
1098: --
1099: -- Validation in addition to Table Handlers

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

1103: l_api_updating := per_job_shd.api_updating
1104: (p_job_id => p_job_id
1105: ,p_object_version_number => p_object_version_number);
1106: --
1107: hr_utility.set_location(l_proc, 15);
1108: --
1109: if not l_api_updating
1110: then
1111: hr_utility.set_location(l_proc, 20);

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

1107: hr_utility.set_location(l_proc, 15);
1108: --
1109: if not l_api_updating
1110: then
1111: hr_utility.set_location(l_proc, 20);
1112: --
1113: -- As this an updating API, the position should already exist.
1114: --
1115: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

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

1111: hr_utility.set_location(l_proc, 20);
1112: --
1113: -- As this an updating API, the position should already exist.
1114: --
1115: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1116: hr_utility.raise_error;
1117: else
1118: if l_job_definition_id is null
1119: then

Line 1116: hr_utility.raise_error;

1112: --
1113: -- As this an updating API, the position should already exist.
1114: --
1115: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1116: hr_utility.raise_error;
1117: else
1118: if l_job_definition_id is null
1119: then
1120: l_null_ind := 0;

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

1118: if l_job_definition_id is null
1119: then
1120: l_null_ind := 0;
1121: l_job_definition_id := per_job_shd.g_old_rec.job_definition_id;
1122: hr_utility.set_location(l_proc, 24);
1123: else
1124: -- 2242339
1125: -- get segment values if p_job_definition_id entered with a value
1126: -- set indicator to show p_job_definition_id did not enter program null

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

1159: l_segment28,
1160: l_segment29,
1161: l_segment30;
1162: close c_segments;
1163: hr_utility.set_location(l_proc, 27);
1164: --
1165: end if;
1166: --
1167: end if;

Line 1169: hr_utility.set_location('Entering: call - update_job_b',35);

1165: end if;
1166: --
1167: end if;
1168: --
1169: hr_utility.set_location('Entering: call - update_job_b',35);
1170: --
1171: --
1172: -- Call Before Process User Hook
1173: --

Line 1272: hr_utility.set_location('Entering:'|| l_proc, 30);

1268: ,p_hook_type => 'BP'
1269: );
1270: end; -- End of API User Hook for the before hook of update_job
1271: --
1272: hr_utility.set_location('Entering:'|| l_proc, 30);
1273: --
1274: -- Because we may need to maintain the valid grade dates, need to
1275: -- explicitly lock the per_jobs row.
1276: --

Line 1280: hr_utility.set_location('Entering:'|| l_proc, 36);

1276: --
1277: -- per_job_shd.lck(p_job_id => p_job_id
1278: -- ,p_object_version_number => l_object_version_number);
1279: --
1280: hr_utility.set_location('Entering:'|| l_proc, 36);
1281: --
1282: open idsel;
1283: fetch idsel into l_flex_num;
1284: if idsel%notfound

Line 1286: hr_utility.set_location('Entering:'|| l_proc, 38);

1282: open idsel;
1283: fetch idsel into l_flex_num;
1284: if idsel%notfound
1285: then
1286: hr_utility.set_location('Entering:'|| l_proc, 38);
1287: close idsel;
1288: --
1289: -- the flex structure has not been found
1290: --

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

1287: close idsel;
1288: --
1289: -- the flex structure has not been found
1290: --
1291: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');
1292: hr_utility.raise_error;
1293: end if;
1294: close idsel;
1295: hr_utility.set_location(l_proc, 40);

Line 1292: hr_utility.raise_error;

1288: --
1289: -- the flex structure has not been found
1290: --
1291: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');
1292: hr_utility.raise_error;
1293: end if;
1294: close idsel;
1295: hr_utility.set_location(l_proc, 40);
1296: l_date_from := trunc(p_date_from);

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

1291: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');
1292: hr_utility.raise_error;
1293: end if;
1294: close idsel;
1295: hr_utility.set_location(l_proc, 40);
1296: l_date_from := trunc(p_date_from);
1297: l_date_to := trunc(p_date_to);
1298: --
1299: --

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

1299: --
1300: -- update job definitions in per_job_definitions if p_job_definition_id had
1301: -- no value when passed into program
1302:
1303: hr_utility.set_location(l_proc, 50);
1304: hr_utility.trace('JBD before upd_or_sel '||l_job_definition_id);
1305: --
1306: hr_kflex_utility.upd_or_sel_keyflex_comb
1307: (p_appl_short_name => 'PER'

Line 1304: hr_utility.trace('JBD before upd_or_sel '||l_job_definition_id);

1300: -- update job definitions in per_job_definitions if p_job_definition_id had
1301: -- no value when passed into program
1302:
1303: hr_utility.set_location(l_proc, 50);
1304: hr_utility.trace('JBD before upd_or_sel '||l_job_definition_id);
1305: --
1306: hr_kflex_utility.upd_or_sel_keyflex_comb
1307: (p_appl_short_name => 'PER'
1308: ,p_flex_code => 'JOB'

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

1341: ,p_ccid => l_job_definition_id
1342: ,p_concat_segments_out => l_name
1343: );
1344: --
1345: hr_utility.set_location(l_proc, 60);
1346: --
1347: -- Because we may need to maintain the valid grade dates, need to
1348: -- explicitly lock the per_jobs row.
1349: --

Line 1353: hr_utility.set_location(l_proc, 65);

1349: --
1350: -- per_job_shd.lck(p_job_id => p_job_id
1351: -- ,p_object_version_number => l_object_version_number);
1352: --
1353: hr_utility.set_location(l_proc, 65);
1354: --
1355: -- If date_from is being updated , then need to maintain valid grades
1356: -- accordingly for that job.
1357: --

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

1369: ,p_valid_grades_changed => l_valid_grades_changed1
1370: ,p_effective_date => p_effective_date); --Added for Bug# 1760707
1371: end if;
1372: --
1373: hr_utility.set_location(l_proc, 70);
1374: --
1375: -- If date_end is being updated , then need to maintain valid grades
1376: -- accordingly for that job.
1377: --

Line 1396: hr_utility.set_location('Entering per_job_upd.upd'||l_proc,80);

1392: --
1393: --
1394: -- Update Job details.
1395: --
1396: hr_utility.set_location('Entering per_job_upd.upd'||l_proc,80);
1397: --
1398: --
1399: per_job_upd.upd
1400: (p_job_id => p_job_id

Line 1463: hr_utility.set_location('Entering: call - update_job_a',55);

1459: ,p_job_id => p_job_id
1460: ,p_name => p_name);
1461: --
1462:
1463: hr_utility.set_location('Entering: call - update_job_a',55);
1464: --
1465: begin
1466: --
1467: hr_job_api_bk2.update_job_a

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

1559: ,p_hook_type => 'AP'
1560: );
1561: end; -- End of API User Hook for the after hook of update_job
1562: --
1563: hr_utility.set_location(l_proc, 90);
1564: --
1565: -- When in validation only mode raise the Validate_Enabled exception
1566: --
1567: if p_validate

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

1578: end if;
1579: p_job_definition_id := l_job_definition_id;
1580: p_name := l_name;
1581: --
1582: hr_utility.set_location(' Leaving:'||l_proc, 100);
1583: exception
1584: when hr_api.validate_enabled then
1585: --
1586: -- As the Validate_Enabled exception has been raised

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

1616: p_name := null;
1617: p_valid_grades_changed_warning := FALSE;
1618: p_object_version_number := l_object_version_number;
1619: p_job_definition_id := l_job_definition_id;
1620: hr_utility.set_location(' Leaving:'||l_proc, 120);
1621: raise;
1622: end update_job;
1623: --
1624: --

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

1634:
1635: l_object_version_number number(9);
1636: l_proc varchar2(72) := g_package||'DELETE_JOB';
1637: begin
1638: hr_utility.set_location('Entering:'|| l_proc, 10);
1639:
1640: --
1641: -- Issue a savepoint
1642: --

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

1695: --
1696: --
1697: p_object_version_number := l_object_version_number;
1698:
1699: hr_utility.set_location(' Leaving:'||l_proc, 70);
1700: exception
1701: when hr_api.validate_enabled then
1702: --
1703: -- As the Validate_Enabled exception has been raised

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

1708: -- Only set output warning arguments
1709: -- (Any key or derived arguments must be set to null
1710: -- when validation only mode is being used.)
1711: --
1712: hr_utility.set_location(' Leaving:'||l_proc, 80);
1713: when others then
1714: --
1715: -- A validation or unexpected error has occured
1716: --

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

1718: --
1719: -- set in out parameters and set out parameters
1720: --
1721: p_object_version_number := l_object_version_number;
1722: hr_utility.set_location(' Leaving:'||l_proc, 90);
1723: raise;
1724: end delete_job;
1725: --
1726: -- ----------------------------------------------------------------------------

Line 1744: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1740: open c1;
1741: fetch c1 into p_job_id;
1742: if (C1%NOTFOUND) then
1743: CLOSE C1;
1744: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1745: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
1746: hr_utility.set_message_token('STEP','1');
1747: end if;
1748: close c1;

Line 1745: hr_utility.set_message_token('PROCEDURE','get_next_sequence');

1741: fetch c1 into p_job_id;
1742: if (C1%NOTFOUND) then
1743: CLOSE C1;
1744: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1745: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
1746: hr_utility.set_message_token('STEP','1');
1747: end if;
1748: close c1;
1749: end if;

Line 1746: hr_utility.set_message_token('STEP','1');

1742: if (C1%NOTFOUND) then
1743: CLOSE C1;
1744: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1745: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
1746: hr_utility.set_message_token('STEP','1');
1747: end if;
1748: close c1;
1749: end if;
1750: --

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

1747: end if;
1748: close c1;
1749: end if;
1750: --
1751: hr_utility.set_location(l_proc, 10);
1752: --
1753: end get_next_sequence;
1754: --
1755: -- ----------------------------------------------------------------------------

Line 1783: hr_utility.set_location('p_struct '||l_struct, 99);

1779: v_not_found := csr_job%NOTFOUND;
1780: close csr_job;
1781: --
1782: l_struct := p_structure_defining_column;
1783: hr_utility.set_location('p_struct '||l_struct, 99);
1784: --
1785: if v_not_found then
1786: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1787: hr_utility.set_message_token('PROCEDURE','get_job_flex_structure');

Line 1786: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1782: l_struct := p_structure_defining_column;
1783: hr_utility.set_location('p_struct '||l_struct, 99);
1784: --
1785: if v_not_found then
1786: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1787: hr_utility.set_message_token('PROCEDURE','get_job_flex_structure');
1788: hr_utility.set_message_token('STEP','1');
1789: hr_utility.raise_error;
1790: end if;

Line 1787: hr_utility.set_message_token('PROCEDURE','get_job_flex_structure');

1783: hr_utility.set_location('p_struct '||l_struct, 99);
1784: --
1785: if v_not_found then
1786: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1787: hr_utility.set_message_token('PROCEDURE','get_job_flex_structure');
1788: hr_utility.set_message_token('STEP','1');
1789: hr_utility.raise_error;
1790: end if;
1791: --

Line 1788: hr_utility.set_message_token('STEP','1');

1784: --
1785: if v_not_found then
1786: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1787: hr_utility.set_message_token('PROCEDURE','get_job_flex_structure');
1788: hr_utility.set_message_token('STEP','1');
1789: hr_utility.raise_error;
1790: end if;
1791: --
1792: hr_utility.set_location(l_proc, 10);

Line 1789: hr_utility.raise_error;

1785: if v_not_found then
1786: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1787: hr_utility.set_message_token('PROCEDURE','get_job_flex_structure');
1788: hr_utility.set_message_token('STEP','1');
1789: hr_utility.raise_error;
1790: end if;
1791: --
1792: hr_utility.set_location(l_proc, 10);
1793: --

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

1788: hr_utility.set_message_token('STEP','1');
1789: hr_utility.raise_error;
1790: end if;
1791: --
1792: hr_utility.set_location(l_proc, 10);
1793: --
1794: end get_job_flex_structure;
1795: --
1796: -- ----------------------------------------------------------------------------

Line 1823: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1819: and vg.job_id = p_job_id
1820: and nvl(vg.date_to, p_end_of_time) > p_date_to;
1821: --
1822: if (SQL%NOTFOUND) then
1823: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1824: hr_utility.set_message_token('PROCEDURE','update_valid_grades');
1825: hr_utility.set_message_token('STEP','1');
1826: hr_utility.raise_error;
1827: end if;

Line 1824: hr_utility.set_message_token('PROCEDURE','update_valid_grades');

1820: and nvl(vg.date_to, p_end_of_time) > p_date_to;
1821: --
1822: if (SQL%NOTFOUND) then
1823: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1824: hr_utility.set_message_token('PROCEDURE','update_valid_grades');
1825: hr_utility.set_message_token('STEP','1');
1826: hr_utility.raise_error;
1827: end if;
1828: --

Line 1825: hr_utility.set_message_token('STEP','1');

1821: --
1822: if (SQL%NOTFOUND) then
1823: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1824: hr_utility.set_message_token('PROCEDURE','update_valid_grades');
1825: hr_utility.set_message_token('STEP','1');
1826: hr_utility.raise_error;
1827: end if;
1828: --
1829: --

Line 1826: hr_utility.raise_error;

1822: if (SQL%NOTFOUND) then
1823: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1824: hr_utility.set_message_token('PROCEDURE','update_valid_grades');
1825: hr_utility.set_message_token('STEP','1');
1826: hr_utility.raise_error;
1827: end if;
1828: --
1829: --
1830: end update_valid_grades;

Line 1853: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1849: and vg.date_from > p_date_to;
1850: --
1851: --
1852: if (SQL%NOTFOUND) then
1853: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1854: hr_utility.set_message_token('PROCEDURE','delete_valid_grades');
1855: hr_utility.set_message_token('STEP','1');
1856: hr_utility.raise_error;
1857: end if;

Line 1854: hr_utility.set_message_token('PROCEDURE','delete_valid_grades');

1850: --
1851: --
1852: if (SQL%NOTFOUND) then
1853: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1854: hr_utility.set_message_token('PROCEDURE','delete_valid_grades');
1855: hr_utility.set_message_token('STEP','1');
1856: hr_utility.raise_error;
1857: end if;
1858: --

Line 1855: hr_utility.set_message_token('STEP','1');

1851: --
1852: if (SQL%NOTFOUND) then
1853: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1854: hr_utility.set_message_token('PROCEDURE','delete_valid_grades');
1855: hr_utility.set_message_token('STEP','1');
1856: hr_utility.raise_error;
1857: end if;
1858: --
1859: end delete_valid_grades;

Line 1856: hr_utility.raise_error;

1852: if (SQL%NOTFOUND) then
1853: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1854: hr_utility.set_message_token('PROCEDURE','delete_valid_grades');
1855: hr_utility.set_message_token('STEP','1');
1856: hr_utility.raise_error;
1857: end if;
1858: --
1859: end delete_valid_grades;
1860: --