DBA Data[Home] [Help]

APPS.PQH_RCT_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: -- Insert the row into: pqh_routing_categories

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

84: p_rec.object_version_number
85: );
86: --
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: pqh_rct_shd.constraint_error

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

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

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

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

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

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

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

235: --
236: -- End of API User Hook for post_insert.
237: --
238: --
239: hr_utility.set_location(' Leaving:'||l_proc, 10);
240: End post_insert;
241: --
242: -- ----------------------------------------------------------------------------
243: -- |---------------------------------< ins >----------------------------------|

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

250: --
251: l_proc varchar2(72) := g_package||'ins';
252: --
253: Begin
254: hr_utility.set_location('Entering:'||l_proc, 5);
255: --
256: -- Call the supporting insert validate operations
257: --
258: pqh_rct_bus.insert_validate(p_rec,p_effective_date);

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

293: l_rec pqh_rct_shd.g_rec_type;
294: l_proc varchar2(72) := g_package||'ins';
295: --
296: Begin
297: hr_utility.set_location('Entering:'||l_proc, 5);
298: --
299: -- Call conversion function to turn arguments into the
300: -- p_rec structure.
301: --

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

326: --
327: p_routing_category_id := l_rec.routing_category_id;
328: p_object_version_number := l_rec.object_version_number;
329: --
330: hr_utility.set_location(' Leaving:'||l_proc, 10);
331: End ins;
332: --
333: end pqh_rct_ins;