DBA Data[Home] [Help]

APPS.PQH_TCT_INS dependencies on HR_UTILITY

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

48: --
49: l_proc varchar2(72) := g_package||'insert_dml';
50: --
51: Begin
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: p_rec.object_version_number := 1; -- Initialise the object version
54: --
55: --
56: -- Added the following code as a part of Zero Downtime Patching Project.

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

118: p_rec.master_table_route_id
119: );
120: --
121: --
122: hr_utility.set_location(' Leaving:'||l_proc, 10);
123: Exception
124: When hr_api.check_integrity_violated Then
125: -- A check constraint has been violated
126: pqh_tct_shd.constraint_error

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

180: --
181: Cursor C_Sel1 is select pqh_transaction_categories_s.nextval from sys.dual;
182: --
183: Begin
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: --
187: -- Select the next sequence number
188: --

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

189: Open C_Sel1;
190: Fetch C_Sel1 Into p_rec.transaction_category_id;
191: Close C_Sel1;
192: --
193: hr_utility.set_location(' Leaving:'||l_proc, 10);
194: End pre_insert;
195: --
196: -- ----------------------------------------------------------------------------
197: -- |-----------------------------< post_insert >------------------------------|

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

230: --
231: l_proc varchar2(72) := g_package||'post_insert';
232: --
233: Begin
234: hr_utility.set_location('Entering:'||l_proc, 5);
235: --
236: --
237: -- Start of API User Hook for post_insert.
238: --

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

276: --
277: -- End of API User Hook for post_insert.
278: --
279: --
280: hr_utility.set_location(' Leaving:'||l_proc, 10);
281: End post_insert;
282: --
283: -- ----------------------------------------------------------------------------
284: -- |---------------------------------< ins >----------------------------------|

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

291: --
292: l_proc varchar2(72) := g_package||'ins';
293: --
294: Begin
295: hr_utility.set_location('Entering:'||l_proc, 5);
296: --
297: -- Call the supporting insert validate operations
298: --
299: pqh_tct_bus.insert_validate(p_rec

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

345: l_rec pqh_tct_shd.g_rec_type;
346: l_proc varchar2(72) := g_package||'ins';
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);
350: --
351: -- Call conversion function to turn arguments into the
352: -- p_rec structure.
353: --

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

388: --
389: p_transaction_category_id := l_rec.transaction_category_id;
390: p_object_version_number := l_rec.object_version_number;
391: --
392: hr_utility.set_location(' Leaving:'||l_proc, 10);
393: End ins;
394: --
395: end pqh_tct_ins;