DBA Data[Home] [Help]

APPS.PAY_SFR_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_formula_rules

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

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

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

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

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

154: Open C_Sel1;
155: Fetch C_Sel1 Into p_rec.formula_result_rule_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: hr_utility.set_location(' Leaving:'||l_proc, 10);
201: End post_insert;
202: --

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

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

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

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

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

252: l_rec pay_sfr_shd.g_rec_type;
253: l_proc varchar2(72) := g_package||'ins';
254: --
255: Begin
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: -- Call conversion function to turn arguments into the
259: -- p_rec structure.
260: --

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

283: --
284: p_formula_result_rule_id := l_rec.formula_result_rule_id;
285: p_object_version_number := l_rec.object_version_number;
286: --
287: hr_utility.set_location(' Leaving:'||l_proc, 10);
288: End ins;
289: --
290: end pay_sfr_ins;