DBA Data[Home] [Help]

APPS.PQH_RLM_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_list_members

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

76: p_rec.user_id
77: );
78: --
79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 10);
81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: pqh_rlm_shd.constraint_error

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

138: --
139: Cursor C_Sel1 is select pqh_routing_list_members_s.nextval from sys.dual;
140: --
141: Begin
142: hr_utility.set_location('Entering:'||l_proc, 5);
143: --
144: --
145: -- Select the next sequence number
146: --

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

147: Open C_Sel1;
148: Fetch C_Sel1 Into p_rec.routing_list_member_id;
149: Close C_Sel1;
150: --
151: hr_utility.set_location(' Leaving:'||l_proc, 10);
152: End pre_insert;
153: --
154: -- ----------------------------------------------------------------------------
155: -- |-----------------------------< post_insert >------------------------------|

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

188: --
189: l_proc varchar2(72) := g_package||'post_insert';
190: --
191: Begin
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: --
194: --
195: -- Start of API User Hook for post_insert.
196: --

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

221: --
222: -- End of API User Hook for post_insert.
223: --
224: --
225: hr_utility.set_location(' Leaving:'||l_proc, 10);
226: End post_insert;
227: --
228: -- ----------------------------------------------------------------------------
229: -- |---------------------------------< ins >----------------------------------|

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

236: --
237: l_proc varchar2(72) := g_package||'ins';
238: --
239: Begin
240: hr_utility.set_location('Entering:'||l_proc, 5);
241: --
242: -- Call the supporting insert validate operations
243: --
244: pqh_rlm_bus.insert_validate(p_rec

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

277: l_rec pqh_rlm_shd.g_rec_type;
278: l_proc varchar2(72) := g_package||'ins';
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: --
283: -- Call conversion function to turn arguments into the
284: -- p_rec structure.
285: --

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

307: --
308: p_routing_list_member_id := l_rec.routing_list_member_id;
309: p_object_version_number := l_rec.object_version_number;
310: --
311: hr_utility.set_location(' Leaving:'||l_proc, 10);
312: End ins;
313: --
314: end pqh_rlm_ins;