DBA Data[Home] [Help]

APPS.PQH_TCA_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 109: hr_utility.set_location(' Leaving:'||l_proc, 10);

105: p_rec.value_style_cd
106: );
107: --
108: --
109: hr_utility.set_location(' Leaving:'||l_proc, 10);
110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: pqh_tca_shd.constraint_error

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

167: --
168: Cursor C_Sel1 is select pqh_txn_category_attributes_s.nextval from sys.dual;
169: --
170: Begin
171: hr_utility.set_location('Entering:'||l_proc, 5);
172: --
173: --
174: -- Select the next sequence number
175: --

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

176: Open C_Sel1;
177: Fetch C_Sel1 Into p_rec.txn_category_attribute_id;
178: Close C_Sel1;
179: --
180: hr_utility.set_location(' Leaving:'||l_proc, 10);
181: End pre_insert;
182: --
183: -- ----------------------------------------------------------------------------
184: -- |-----------------------------< post_insert >------------------------------|

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

217: --
218: l_proc varchar2(72) := g_package||'post_insert';
219: --
220: Begin
221: hr_utility.set_location('Entering:'||l_proc, 5);
222: --
223: --
224: -- Start of API User Hook for post_insert.
225: --

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

255: --
256: -- End of API User Hook for post_insert.
257: --
258: --
259: hr_utility.set_location(' Leaving:'||l_proc, 10);
260: End post_insert;
261: --
262: -- ----------------------------------------------------------------------------
263: -- |---------------------------------< ins >----------------------------------|

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

270: --
271: l_proc varchar2(72) := g_package||'ins';
272: --
273: Begin
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: --
276: -- Call the supporting insert validate operations
277: --
278: pqh_tca_bus.insert_validate(p_rec

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

316: l_rec pqh_tca_shd.g_rec_type;
317: l_proc varchar2(72) := g_package||'ins';
318: --
319: Begin
320: hr_utility.set_location('Entering:'||l_proc, 5);
321: --
322: -- Call conversion function to turn arguments into the
323: -- p_rec structure.
324: --

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

351: --
352: p_txn_category_attribute_id := l_rec.txn_category_attribute_id;
353: p_object_version_number := l_rec.object_version_number;
354: --
355: hr_utility.set_location(' Leaving:'||l_proc, 10);
356: End ins;
357: --
358: end pqh_tca_ins;