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: -- Insert the row into: pqh_txn_category_attributes

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

86: p_rec.value_style_cd
87: );
88: --
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 10);
91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: pqh_tca_shd.constraint_error

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

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

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

157: Open C_Sel1;
158: Fetch C_Sel1 Into p_rec.txn_category_attribute_id;
159: Close C_Sel1;
160: --
161: hr_utility.set_location(' Leaving:'||l_proc, 10);
162: End pre_insert;
163: --
164: -- ----------------------------------------------------------------------------
165: -- |-----------------------------< 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 240: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

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

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

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

297: l_rec pqh_tca_shd.g_rec_type;
298: l_proc varchar2(72) := g_package||'ins';
299: --
300: Begin
301: hr_utility.set_location('Entering:'||l_proc, 5);
302: --
303: -- Call conversion function to turn arguments into the
304: -- p_rec structure.
305: --

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

332: --
333: p_txn_category_attribute_id := l_rec.txn_category_attribute_id;
334: p_object_version_number := l_rec.object_version_number;
335: --
336: hr_utility.set_location(' Leaving:'||l_proc, 10);
337: End ins;
338: --
339: end pqh_tca_ins;