DBA Data[Home] [Help]

APPS.PER_CTC_DEL dependencies on HR_UTILITY

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

59: --
60: l_proc varchar2(72) := g_package||'dt_delete_dml';
61: --
62: Begin
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
65: hr_utility.set_location(l_proc, 10);
66: --
67: -- Delete the where the effective start date is equal

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

61: --
62: Begin
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
65: hr_utility.set_location(l_proc, 10);
66: --
67: -- Delete the where the effective start date is equal
68: -- to the validation end date.
69: --

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

71: where contract_id = p_rec.contract_id
72: and effective_start_date = p_validation_start_date;
73: --
74: Else
75: hr_utility.set_location(l_proc, 15);
76: --
77: -- Delete the row(s) where the effective start date is greater than
78: -- or equal to the validation start date.
79: --

Line 86: hr_utility.set_location(' Leaving:'||l_proc, 20);

82: and effective_start_date >= p_validation_start_date;
83: --
84: End If;
85: --
86: hr_utility.set_location(' Leaving:'||l_proc, 20);
87: --
88: Exception
89: When Others Then
90: Raise;

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

103: --
104: l_proc varchar2(72) := g_package||'delete_dml';
105: --
106: Begin
107: hr_utility.set_location('Entering:'||l_proc, 5);
108: --
109: dt_delete_dml(p_rec => p_rec,
110: p_effective_date => p_effective_date,
111: p_datetrack_mode => p_datetrack_mode,

Line 115: hr_utility.set_location(' Leaving:'||l_proc, 10);

111: p_datetrack_mode => p_datetrack_mode,
112: p_validation_start_date => p_validation_start_date,
113: p_validation_end_date => p_validation_end_date);
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: End delete_dml;
117: --
118: -- ----------------------------------------------------------------------------
119: -- |----------------------------< dt_pre_delete >-----------------------------|

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

158: --
159: l_proc varchar2(72) := g_package||'dt_pre_delete';
160: --
161: Begin
162: hr_utility.set_location('Entering:'||l_proc, 5);
163: --
164: If (p_datetrack_mode <> 'ZAP') then
165: --
166: p_rec.effective_start_date := per_ctc_shd.g_old_rec.effective_start_date;

Line 188: hr_utility.set_location(' Leaving:'||l_proc, 10);

184: Else
185: p_rec.effective_start_date := null;
186: p_rec.effective_end_date := null;
187: End If;
188: hr_utility.set_location(' Leaving:'||l_proc, 10);
189: End dt_pre_delete;
190: --
191: -- ----------------------------------------------------------------------------
192: -- |------------------------------< pre_delete >------------------------------|

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

230: --
231: l_proc varchar2(72) := g_package||'pre_delete';
232: --
233: Begin
234: hr_utility.set_location('Entering:'||l_proc, 5);
235: --
236: --
237: --
238: dt_pre_delete

Line 246: hr_utility.set_location(' Leaving:'||l_proc, 10);

242: p_validation_start_date => p_validation_start_date,
243: p_validation_end_date => p_validation_end_date);
244: --
245:
246: hr_utility.set_location(' Leaving:'||l_proc, 10);
247: End pre_delete;
248: --
249: -- ----------------------------------------------------------------------------
250: -- |-----------------------------< post_delete >------------------------------|

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

287: --
288: l_proc varchar2(72) := g_package||'post_delete';
289: --
290: Begin
291: hr_utility.set_location('Entering:'||l_proc, 5);
292: --
293: -- Start of API User Hook for post_delete.
294: --
295: begin

Line 385: hr_utility.set_location(' Leaving:'||l_proc, 10);

381: end;
382: --
383: -- End of API User Hook for post_delete.
384: --
385: hr_utility.set_location(' Leaving:'||l_proc, 10);
386: End post_delete;
387: --
388: -- ----------------------------------------------------------------------------
389: -- |---------------------------------< del >----------------------------------|

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

400: l_validation_start_date date;
401: l_validation_end_date date;
402: --
403: Begin
404: hr_utility.set_location('Entering:'||l_proc, 5);
405: --
406: -- Ensure that the DateTrack delete mode is valid
407: --
408: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);

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

471: l_rec per_ctc_shd.g_rec_type;
472: l_proc varchar2(72) := g_package||'del';
473: --
474: Begin
475: hr_utility.set_location('Entering:'||l_proc, 5);
476: --
477: -- As the delete procedure accepts a plsql record structure we do need to
478: -- convert the arguments into the record structure.
479: -- We don't need to call the supplied conversion argument routine as we

Line 497: hr_utility.set_location(' Leaving:'||l_proc, 10);

493: p_object_version_number := l_rec.object_version_number;
494: p_effective_start_date := l_rec.effective_start_date;
495: p_effective_end_date := l_rec.effective_end_date;
496: --
497: hr_utility.set_location(' Leaving:'||l_proc, 10);
498: End del;
499: --
500: -- ----------------------------------------------------------------------------
501: -- |-----------------------< delete_row >-------------------------------------|

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

514: l_proc varchar2(72) := g_package||'delete_row';
515: --
516: begin
517: --
518: hr_utility.set_location('Entering:'||l_proc, 5);
519: --
520: -- mandatory argument checking
521: --
522: hr_api.mandatory_arg_error

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

554: --
555: -- An unhandled or unexpected error has occurred which
556: -- we must report
557: --
558: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
559: hr_utility.set_message_token('PROCEDURE', l_proc);
560: hr_utility.set_message_token('STEP','5');
561: hr_utility.raise_error;
562: --

Line 559: hr_utility.set_message_token('PROCEDURE', l_proc);

555: -- An unhandled or unexpected error has occurred which
556: -- we must report
557: --
558: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
559: hr_utility.set_message_token('PROCEDURE', l_proc);
560: hr_utility.set_message_token('STEP','5');
561: hr_utility.raise_error;
562: --
563: end delete_row;

Line 560: hr_utility.set_message_token('STEP','5');

556: -- we must report
557: --
558: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
559: hr_utility.set_message_token('PROCEDURE', l_proc);
560: hr_utility.set_message_token('STEP','5');
561: hr_utility.raise_error;
562: --
563: end delete_row;
564: --

Line 561: hr_utility.raise_error;

557: --
558: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
559: hr_utility.set_message_token('PROCEDURE', l_proc);
560: hr_utility.set_message_token('STEP','5');
561: hr_utility.raise_error;
562: --
563: end delete_row;
564: --
565: end per_ctc_del;