DBA Data[Home] [Help]

APPS.PQH_CEP_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: -- Insert the row into: pqh_copy_entity_prefs
56: --

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

68: p_rec.select_flag,
69: p_rec.object_version_number
70: );
71: --
72: hr_utility.set_location(' Leaving:'||l_proc, 10);
73: Exception
74: When hr_api.check_integrity_violated Then
75: -- A check constraint has been violated
76: pqh_cep_shd.constraint_error

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

131: --
132: Cursor C_Sel1 is select pqh_copy_entity_prefs_s.nextval from sys.dual;
133: --
134: Begin
135: hr_utility.set_location('Entering:'||l_proc, 5);
136: --
137: --
138: -- Select the next sequence number
139: --

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

140: Open C_Sel1;
141: Fetch C_Sel1 Into p_rec.copy_entity_pref_id;
142: Close C_Sel1;
143: --
144: hr_utility.set_location(' Leaving:'||l_proc, 10);
145: End pre_insert;
146: --
147: -- ----------------------------------------------------------------------------
148: -- |-----------------------------< post_insert >------------------------------|

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

181: --
182: l_proc varchar2(72) := g_package||'post_insert';
183: --
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: --
187: --
188: -- Start of API User Hook for post_insert.
189: --

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

211: --
212: -- End of API User Hook for post_insert.
213: --
214: --
215: hr_utility.set_location(' Leaving:'||l_proc, 10);
216: End post_insert;
217: --
218: -- ----------------------------------------------------------------------------
219: -- |---------------------------------< ins >----------------------------------|

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

226: --
227: l_proc varchar2(72) := g_package||'ins';
228: --
229: Begin
230: hr_utility.set_location('Entering:'||l_proc, 5);
231: --
232: -- Call the supporting insert validate operations
233: --
234: pqh_cep_bus.insert_validate(p_rec

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

264: l_rec pqh_cep_shd.g_rec_type;
265: l_proc varchar2(72) := g_package||'ins';
266: --
267: Begin
268: hr_utility.set_location('Entering:'||l_proc, 5);
269: --
270: -- Call conversion function to turn arguments into the
271: -- p_rec structure.
272: --

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

291: --
292: p_copy_entity_pref_id := l_rec.copy_entity_pref_id;
293: p_object_version_number := l_rec.object_version_number;
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 10);
296: End ins;
297: --
298: end pqh_cep_ins;