DBA Data[Home] [Help]

APPS.GHR_PA_REMARKS_API dependencies on HR_UTILITY

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

67: l_pa_remark_id := remark.pa_remark_id;
68: l_object_version_number := remark.object_version_number;
69: end loop;
70:
71: hr_utility.set_location('Entering:'|| l_proc, 5);
72: --
73: --
74: savepoint create_pa_remarks;
75: --

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

168: p_pa_remark_id := l_pa_remark_id;
169: p_object_version_number := l_object_version_number;
170:
171: --
172: hr_utility.set_location(' Leaving:'||l_proc, 11);
173: exception
174: when hr_api.validate_enabled then
175: --
176: -- As the Validate_Enabled exception has been raised

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

190: p_pa_remark_id := null;
191: p_object_version_number := null;
192: raise;
193:
194: hr_utility.set_location(' Leaving:'||l_proc, 12);
195:
196: end create_pa_remarks;
197: --
198:

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

216: l_object_version_number ghr_pa_remarks.object_version_number%TYPE;
217: l_init_ovn ghr_pa_remarks.object_version_number%TYPE;
218:
219: begin
220: hr_utility.set_location('Entering:'|| l_proc, 5);
221: --
222: l_init_ovn := p_object_version_number;
223: savepoint update_pa_remarks;
224: --

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

249: -- Store the original ovn in case we rollback when p_validate is true
250: --
251: l_object_version_number := p_object_version_number;
252:
253: hr_utility.set_location(l_proc, 6);
254: ghr_pre_upd.upd
255: (p_pa_remark_id => p_pa_remark_id
256: ,p_description => p_description
257: ,p_remark_code_information1 => p_remark_code_information1

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

294: -- Set all output arguments
295: --
296: -- p_object_version_number := l_object_version_number;
297: --
298: hr_utility.set_location(' Leaving:'||l_proc, 11);
299: exception
300: when hr_api.validate_enabled then
301: --
302: -- As the Validate_Enabled exception has been raised

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

316: --
317: p_object_version_number := l_init_ovn;
318:
319: raise;
320: hr_utility.set_location(' Leaving:'||l_proc, 12);
321: end update_pa_remarks;
322:
323: --
324: --

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

370: and nvl(par.effective_date,TRUNC(sysdate)) between nre.date_from
371: and nvl(nre.date_to,nvl(par.effective_date,TRUNC(sysdate)));
372:
373: begin
374: hr_utility.set_location('Entering:'|| l_proc, 5);
375: --
376: --
377: savepoint delete_pa_remarks;
378: --

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

393: end;
394: --
395: -- End of Before Process User Hook call
396: --
397: hr_utility.set_location(l_proc, 7);
398:
399: --
400: -- Process Logic - Delete pa_remarks details if the specific pa_remark_id is not required
401: -- for the first_noa_id specified for the pa_request_id

Line 410: hr_utility.set_message(8301,'GHR_38116_REM_REQD');

406: exit;
407: end loop;
408: -- if it is a reqd. remark for the 1st Noa, then error
409: if l_exists then
410: hr_utility.set_message(8301,'GHR_38116_REM_REQD');
411: hr_utility.raise_error;
412: else
413: -- if not reqd. for 1st noa, then check if it is reqd. for 2nd noa
414: for remark_reqd in c_remark_reqd2 loop

Line 411: hr_utility.raise_error;

407: end loop;
408: -- if it is a reqd. remark for the 1st Noa, then error
409: if l_exists then
410: hr_utility.set_message(8301,'GHR_38116_REM_REQD');
411: hr_utility.raise_error;
412: else
413: -- if not reqd. for 1st noa, then check if it is reqd. for 2nd noa
414: for remark_reqd in c_remark_reqd2 loop
415: l_exists := true;

Line 427: hr_utility.set_message(8301,'GHR_38128_REM_REQD_2');

423: ,p_validate => p_validate
424: );
425: Else
426: -- error to indicate reqd. remark for 2nd noa
427: hr_utility.set_message(8301,'GHR_38128_REM_REQD_2');
428: hr_utility.raise_error;
429: End if;
430: --
431: hr_utility.set_location(l_proc, 8);

Line 428: hr_utility.raise_error;

424: );
425: Else
426: -- error to indicate reqd. remark for 2nd noa
427: hr_utility.set_message(8301,'GHR_38128_REM_REQD_2');
428: hr_utility.raise_error;
429: End if;
430: --
431: hr_utility.set_location(l_proc, 8);
432: --

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

427: hr_utility.set_message(8301,'GHR_38128_REM_REQD_2');
428: hr_utility.raise_error;
429: End if;
430: --
431: hr_utility.set_location(l_proc, 8);
432: --
433: --
434: -- Call After Process User Hook
435: --

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

453: if p_validate then
454: raise hr_api.validate_enabled;
455: end if;
456: --
457: hr_utility.set_location(' Leaving:'||l_proc, 11);
458: exception
459: when hr_api.validate_enabled then
460: --
461: -- As the Validate_Enabled exception has been raised

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

466: When Others then
467: ROLLBACK TO delete_pa_remarks;
468: raise;
469:
470: hr_utility.set_location(' Leaving:'||l_proc, 12);
471: end delete_pa_remarks;
472: --
473: --
474: end ghr_pa_remarks_api;