DBA Data[Home] [Help]

APPS.PAY_PWR_INS dependencies on HR_UTILITY

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

54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: pay_pwr_shd.g_api_dml := true; -- Set the api dml status
62: --

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

84: );
85: --
86: pay_pwr_shd.g_api_dml := false; -- Unset the api dml status
87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: pay_pwr_shd.g_api_dml := false; -- Unset the api dml status

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

150: --
151: Cursor C_Sel1 is select pay_wci_rates_s.nextval from sys.dual;
152: --
153: Begin
154: hr_utility.set_location('Entering:'||l_proc, 5);
155: --
156: --
157: -- Select the next sequence number
158: --

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

159: Open C_Sel1;
160: Fetch C_Sel1 Into p_rec.rate_id;
161: Close C_Sel1;
162: --
163: hr_utility.set_location(' Leaving:'||l_proc, 10);
164: End pre_insert;
165: --
166: -- ----------------------------------------------------------------------------
167: -- |-----------------------------< post_insert >------------------------------|

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

199: --
200: l_proc varchar2(72) := g_package||'post_insert';
201: --
202: Begin
203: hr_utility.set_location('Entering:'||l_proc, 5);
204: --
205: --
206: -- Start of API User Hook for post_insert.
207: --

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

231: --
232: -- End of API User Hook for post_insert.
233: --
234: --
235: hr_utility.set_location(' Leaving:'||l_proc, 10);
236: End post_insert;
237: --
238: -- ----------------------------------------------------------------------------
239: -- |---------------------------------< ins >----------------------------------|

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

245: --
246: l_proc varchar2(72) := g_package||'ins';
247: --
248: Begin
249: hr_utility.set_location('Entering:'||l_proc, 5);
250: --
251: -- Call the supporting insert validate operations
252: --
253: pay_pwr_bus.insert_validate(p_rec);

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

284: l_rec pay_pwr_shd.g_rec_type;
285: l_proc varchar2(72) := g_package||'ins';
286: --
287: Begin
288: hr_utility.set_location('Entering:'||l_proc, 5);
289: --
290: -- Call conversion function to turn arguments into the
291: -- p_rec structure.
292: --

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

313: --
314: p_rate_id := l_rec.rate_id;
315: p_object_version_number := l_rec.object_version_number;
316: --
317: hr_utility.set_location(' Leaving:'||l_proc, 10);
318: End ins;
319: --
320: end pay_pwr_ins;