DBA Data[Home] [Help]

APPS.PAY_PAY_DEL dependencies on HR_UTILITY

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

61: l_proc varchar2(72) := g_package||'dt_delete_dml';
62: l_status_of_dml boolean;
63: --
64: Begin
65: hr_utility.set_location('Entering:'||l_proc, 5);
66: If (p_datetrack_mode = hr_api.g_delete_next_change) then
67: pay_pay_shd.g_api_dml := true; -- Set the api dml status
68: --
69: -- Delete the where the effective start date is equal

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

92: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
93:
94: --Checking the status of the above dml operation.
95: /*if (l_status_of_dml) then
96: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
97: hr_utility.set_message_token('PROCEDURE',
98: 'pay_payrolls_f_pkg.delete_row');
99: hr_utility.set_message_token('STEP','1');
100: hr_utility.raise_error;

Line 97: hr_utility.set_message_token('PROCEDURE',

93:
94: --Checking the status of the above dml operation.
95: /*if (l_status_of_dml) then
96: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
97: hr_utility.set_message_token('PROCEDURE',
98: 'pay_payrolls_f_pkg.delete_row');
99: hr_utility.set_message_token('STEP','1');
100: hr_utility.raise_error;
101: End if;*/

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

95: /*if (l_status_of_dml) then
96: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
97: hr_utility.set_message_token('PROCEDURE',
98: 'pay_payrolls_f_pkg.delete_row');
99: hr_utility.set_message_token('STEP','1');
100: hr_utility.raise_error;
101: End if;*/
102:
103: End If;

Line 100: hr_utility.raise_error;

96: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
97: hr_utility.set_message_token('PROCEDURE',
98: 'pay_payrolls_f_pkg.delete_row');
99: hr_utility.set_message_token('STEP','1');
100: hr_utility.raise_error;
101: End if;*/
102:
103: End If;
104: --

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

101: End if;*/
102:
103: End If;
104: --
105: hr_utility.set_location(' Leaving:'||l_proc, 20);
106: --
107: Exception
108: When Others Then
109: pay_pay_shd.g_api_dml := false; -- Unset the api dml status

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

125: l_proc varchar2(72) := g_package||'delete_dml';
126: --
127: Begin
128: --
129: hr_utility.set_location('Entering:'||l_proc, 5);
130: --
131: pay_pay_del.dt_delete_dml
132: (p_rec => p_rec
133: ,p_effective_date => p_effective_date

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

135: ,p_validation_start_date => p_validation_start_date
136: ,p_validation_end_date => p_validation_end_date
137: );
138: --
139: hr_utility.set_location(' Leaving:'||l_proc, 10);
140: --
141: End delete_dml;
142: --
143: -- ----------------------------------------------------------------------------

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

184: l_proc varchar2(72) := g_package||'dt_pre_delete';
185: --
186: Begin
187: --
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: --
190: If (p_datetrack_mode <> hr_api.g_zap) then
191: --
192: p_rec.effective_start_date

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

219: p_rec.effective_end_date := null;
220: --
221: End If;
222: --
223: hr_utility.set_location(' Leaving:'||l_proc, 10);
224: --
225: End dt_pre_delete;
226: --
227: -- ----------------------------------------------------------------------------

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

285: or t2.effective_end_date < p_validation_start_date));
286: --
287: --
288: Begin
289: hr_utility.set_location('Entering:'||l_proc, 5);
290: --
291: -- Delete any possible comments
292: --
293: For Comm_Del In C_Sel1 Loop

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

302: ,p_validation_start_date => p_validation_start_date
303: ,p_validation_end_date => p_validation_end_date
304: );
305: --
306: hr_utility.set_location(' Leaving:'||l_proc, 10);
307: --
308: End pre_delete;
309: --
310: -- ----------------------------------------------------------------------------

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

350: l_proc varchar2(72) := g_package||'post_delete';
351: --
352: Begin
353: --
354: hr_utility.set_location('Entering:'||l_proc, 5);
355: begin
356: --
357: -- Following call to a procedure Maintains payroll related tables on deletion of a payroll.
358: --

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

544: ,p_hook_type => 'AD');
545: --
546: end;
547: --
548: hr_utility.set_location(' Leaving:'||l_proc, 10);
549: --
550: End post_delete;
551: --
552: -- ----------------------------------------------------------------------------

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

563: l_validation_end_date date;
564: --
565: Begin
566: --
567: hr_utility.set_location('Entering:'||l_proc, 5);
568: --
569: -- Ensure that the DateTrack delete mode is valid
570: --
571: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);

Line 628: hr_utility.set_location(' Leaving:'||l_proc, 5);

624: --
625: -- Call to raise any errors on multi-message list
626: hr_multi_message.end_validation_set;
627: --
628: hr_utility.set_location(' Leaving:'||l_proc, 5);
629: End del;
630: --
631: -- ----------------------------------------------------------------------------
632: -- |--------------------------------< del >-----------------------------------|

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

643: l_rec pay_pay_shd.g_rec_type;
644: l_proc varchar2(72) := g_package||'del';
645: --
646: Begin
647: hr_utility.set_location('Entering:'||l_proc, 5);
648: --
649: -- As the delete procedure accepts a plsql record structure we do need to
650: -- convert the arguments into the record structure.
651: -- We don't need to call the supplied conversion argument routine as we

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

669: p_object_version_number := l_rec.object_version_number;
670: p_effective_start_date := l_rec.effective_start_date;
671: p_effective_end_date := l_rec.effective_end_date;
672: --
673: hr_utility.set_location(' Leaving:'||l_proc, 10);
674: End del;
675: --
676: end pay_pay_del;