DBA Data[Home] [Help]

APPS.PAY_SF_INS dependencies on HR_UTILITY

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

51: --
52: l_proc varchar2(72) := g_package||'insert_dml';
53: --
54: Begin
55: hr_utility.set_location('Entering:'||l_proc, 5);
56: p_rec.object_version_number := 1; -- Initialise the object version
57: --
58: --
59: -- Insert the row into: pay_shadow_formulas

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

81: p_rec.object_version_number
82: );
83: --
84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: pay_sf_shd.constraint_error

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

143: --
144: Cursor C_Sel1 is select pay_shadow_formulas_s.nextval from sys.dual;
145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: --
150: -- Select the next sequence number
151: --

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

152: Open C_Sel1;
153: Fetch C_Sel1 Into p_rec.formula_id;
154: Close C_Sel1;
155: --
156: hr_utility.set_location(' Leaving:'||l_proc, 10);
157: End pre_insert;
158: --
159: -- ----------------------------------------------------------------------------
160: -- |-----------------------------< post_insert >------------------------------|

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

192: --
193: l_proc varchar2(72) := g_package||'post_insert';
194: --
195: Begin
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: --
198: hr_utility.set_location(' Leaving:'||l_proc, 10);
199: End post_insert;
200: --

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

194: --
195: Begin
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: --
198: hr_utility.set_location(' Leaving:'||l_proc, 10);
199: End post_insert;
200: --
201: -- ----------------------------------------------------------------------------
202: -- |---------------------------------< ins >----------------------------------|

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

208: --
209: l_proc varchar2(72) := g_package||'ins';
210: --
211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: -- Call the supporting insert validate operations
215: --
216: pay_sf_bus.insert_validate(p_effective_date, p_rec);

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

248: l_rec pay_sf_shd.g_rec_type;
249: l_proc varchar2(72) := g_package||'ins';
250: --
251: Begin
252: hr_utility.set_location('Entering:'||l_proc, 5);
253: --
254: -- Call conversion function to turn arguments into the
255: -- p_rec structure.
256: --

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

278: --
279: p_formula_id := l_rec.formula_id;
280: p_object_version_number := l_rec.object_version_number;
281: --
282: hr_utility.set_location(' Leaving:'||l_proc, 10);
283: End ins;
284: --
285: end pay_sf_ins;