APPS.PAY_PWO_INS dependencies on HR_UTILITY

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

54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: pay_pwo_shd.g_api_dml := true; -- Set the api dml status
62: --

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

80: );
81: --
82: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status
83: --
84: hr_utility.set_location(' Leaving:'||l_proc, 10);
85: Exception
86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
88: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status

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

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

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

154: Open C_Sel1;
155: Fetch C_Sel1 Into p_rec.occupation_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 198: hr_utility.set_location('Entering:'||l_proc, 5);

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

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

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

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

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

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

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

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

301: --
302: p_occupation_id := l_rec.occupation_id;
303: p_object_version_number := l_rec.object_version_number;
304: --
305: hr_utility.set_location(' Leaving:'||l_proc, 10);
306: End ins;
307: --
308: end pay_pwo_ins;