DBA Data[Home] [Help]

APPS.PQH_DEL_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_dflt_budget_elements

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

70: p_rec.object_version_number
71: );
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: pqh_del_shd.constraint_error

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

132: --
133: Cursor C_Sel1 is select pqh_dflt_budget_elements_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.dflt_budget_element_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 196: hr_utility.set_location('Entering:'||l_proc, 5);

192:
193: --
194:
195: Begin
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: --
198: --
199: open csr_element(p_dflt_budget_set_id => p_rec.dflt_budget_set_id );
200: fetch csr_element into l_sum;

Line 206: hr_utility.set_message(8302,'PQH_WKS_INVALID_ELMNT_SUM');

202:
203: if l_sum > 100 then
204: -- sum cannot be more then 100
205: --
206: hr_utility.set_message(8302,'PQH_WKS_INVALID_ELMNT_SUM');
207: hr_utility.raise_error;
208: --
209: end if;
210: --

Line 207: hr_utility.raise_error;

203: if l_sum > 100 then
204: -- sum cannot be more then 100
205: --
206: hr_utility.set_message(8302,'PQH_WKS_INVALID_ELMNT_SUM');
207: hr_utility.raise_error;
208: --
209: end if;
210: --
211:

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

235: --
236: -- End of API User Hook for post_insert.
237: --
238: --
239: hr_utility.set_location(' Leaving:'||l_proc, 10);
240: End post_insert;
241: --
242: -- ----------------------------------------------------------------------------
243: -- |---------------------------------< ins >----------------------------------|

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

249: --
250: l_proc varchar2(72) := g_package||'ins';
251: --
252: Begin
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: -- Call the supporting insert validate operations
256: --
257: pqh_del_bus.insert_validate(p_rec);

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

284: l_rec pqh_del_shd.g_rec_type;
285: l_proc varchar2(72) := g_package||'ins';
286: --
287: Begin
288: hr_utility.set_location('Entering:'||l_proc, 5);
289: --
290: -- Call conversion function to turn arguments into the
291: -- p_rec structure.
292: --

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

310: --
311: p_dflt_budget_element_id := l_rec.dflt_budget_element_id;
312: p_object_version_number := l_rec.object_version_number;
313: --
314: hr_utility.set_location(' Leaving:'||l_proc, 10);
315: End ins;
316: --
317: end pqh_del_ins;