DBA Data[Home] [Help]

APPS.PQH_DFS_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_fund_srcs

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

80: p_rec.cost_allocation_keyflex_id
81: );
82: --
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: pqh_dfs_shd.constraint_error

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

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

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

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

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

202:
203: --
204:
205: Begin
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: --
209: open csr_element(p_dflt_budget_element_id => p_rec.dflt_budget_element_id);
210: fetch csr_element into l_sum;

Line 216: hr_utility.set_message(8302,'PQH_WKS_INVALID_SRCS_SUM');

212:
213: if l_sum > 100 then
214: -- sum cannot be more then 100
215: --
216: hr_utility.set_message(8302,'PQH_WKS_INVALID_SRCS_SUM');
217: hr_utility.raise_error;
218: --
219: end if;
220: --

Line 217: hr_utility.raise_error;

213: if l_sum > 100 then
214: -- sum cannot be more then 100
215: --
216: hr_utility.set_message(8302,'PQH_WKS_INVALID_SRCS_SUM');
217: hr_utility.raise_error;
218: --
219: end if;
220: --
221:

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

250: --
251: -- End of API User Hook for post_insert.
252: --
253: --
254: hr_utility.set_location(' Leaving:'||l_proc, 10);
255: End post_insert;
256: --
257: -- ----------------------------------------------------------------------------
258: -- |---------------------------------< ins >----------------------------------|

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

264: --
265: l_proc varchar2(72) := g_package||'ins';
266: --
267: Begin
268: hr_utility.set_location('Entering:'||l_proc, 5);
269: --
270: -- Call the supporting insert validate operations
271: --
272: pqh_dfs_bus.insert_validate(p_rec);

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

304: l_rec pqh_dfs_shd.g_rec_type;
305: l_proc varchar2(72) := g_package||'ins';
306: --
307: Begin
308: hr_utility.set_location('Entering:'||l_proc, 5);
309: --
310: -- Call conversion function to turn arguments into the
311: -- p_rec structure.
312: --

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

335: --
336: p_dflt_fund_src_id := l_rec.dflt_fund_src_id;
337: p_object_version_number := l_rec.object_version_number;
338: --
339: hr_utility.set_location(' Leaving:'||l_proc, 10);
340: End ins;
341: --
342: end pqh_dfs_ins;