DBA Data[Home] [Help]

APPS.PQH_SAT_INS dependencies on HR_UTILITY

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

51: --
52: l_proc varchar2(72) := g_package||'insert_dml';
53: --
54: Begin
55: hr_utility.set_location('Entering:'||l_proc, 5);
56: p_rec.object_version_number := 1; -- Initialise the object version
57: --
58: --
59: -- Insert the row into: pqh_special_attributes

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

83: p_rec.context
84: );
85: --
86: --
87: hr_utility.set_location(' Leaving:'||l_proc, 10);
88: Exception
89: When hr_api.check_integrity_violated Then
90: -- A check constraint has been violated
91: pqh_sat_shd.constraint_error

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

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

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

154: Open C_Sel1;
155: Fetch C_Sel1 Into p_rec.special_attribute_id;
156: Close C_Sel1;
157: --
158: hr_utility.set_location(' Leaving:'||l_proc, 10);
159: End pre_insert;
160: --
161: -- ----------------------------------------------------------------------------
162: -- |-----------------------------< post_insert >------------------------------|

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

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

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

230: --
231: -- End of API User Hook for post_insert.
232: --
233: --
234: hr_utility.set_location(' Leaving:'||l_proc, 10);
235: End post_insert;
236: --
237: -- ----------------------------------------------------------------------------
238: -- |---------------------------------< 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: pqh_sat_bus.insert_validate(p_rec

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

288: l_rec pqh_sat_shd.g_rec_type;
289: l_proc varchar2(72) := g_package||'ins';
290: --
291: Begin
292: hr_utility.set_location('Entering:'||l_proc, 5);
293: --
294: -- Call conversion function to turn arguments into the
295: -- p_rec structure.
296: --

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

320: --
321: p_special_attribute_id := l_rec.special_attribute_id;
322: p_object_version_number := l_rec.object_version_number;
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 10);
325: End ins;
326: --
327: end pqh_sat_ins;