DBA Data[Home] [Help]

APPS.PAY_TER_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: -- Insert the row into: pay_template_exclusion_rules
56: --

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

70: p_rec.description,
71: p_rec.object_version_number
72: );
73: --
74: hr_utility.set_location(' Leaving:'||l_proc, 10);
75: Exception
76: When hr_api.check_integrity_violated Then
77: -- A check constraint has been violated
78: pay_ter_shd.constraint_error

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

132: --
133: Cursor C_Sel1 is select pay_template_exclusion_rules_s.nextval from sys.dual;
134: --
135: Begin
136: hr_utility.set_location('Entering:'||l_proc, 5);
137: --
138: --
139: -- Select the next sequence number
140: --

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

141: Open C_Sel1;
142: Fetch C_Sel1 Into p_rec.exclusion_rule_id;
143: Close C_Sel1;
144: --
145: hr_utility.set_location(' Leaving:'||l_proc, 10);
146: End pre_insert;
147: --
148: -- ----------------------------------------------------------------------------
149: -- |-----------------------------< post_insert >------------------------------|

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

181: --
182: l_proc varchar2(72) := g_package||'post_insert';
183: --
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: --
187: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: End post_insert;
189: --

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

183: --
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: --
187: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: End post_insert;
189: --
190: -- ----------------------------------------------------------------------------
191: -- |---------------------------------< ins >----------------------------------|

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

197: --
198: l_proc varchar2(72) := g_package||'ins';
199: --
200: Begin
201: hr_utility.set_location('Entering:'||l_proc, 5);
202: --
203: -- Call the supporting insert validate operations
204: --
205: pay_ter_bus.insert_validate(p_rec);

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

233: l_rec pay_ter_shd.g_rec_type;
234: l_proc varchar2(72) := g_package||'ins';
235: --
236: Begin
237: hr_utility.set_location('Entering:'||l_proc, 5);
238: --
239: -- Call conversion function to turn arguments into the
240: -- p_rec structure.
241: --

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

260: --
261: p_exclusion_rule_id := l_rec.exclusion_rule_id;
262: p_object_version_number := l_rec.object_version_number;
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 10);
265: End ins;
266: --
267: end pay_ter_ins;