DBA Data[Home] [Help]

APPS.PQH_BFS_BUS dependencies on HR_UTILITY

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_bfs_shd.api_updating
47: (p_budget_fund_src_id => p_budget_fund_src_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_budget_fund_src_id;
75: --
76: -- ----------------------------------------------------------------------------

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

112: where a.budget_element_id = p_budget_element_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_bfs_shd.api_updating
119: (p_budget_fund_src_id => p_budget_fund_src_id,
120: p_object_version_number => p_object_version_number);

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

143: close c1;
144: --
145: end if;
146: --
147: hr_utility.set_location('Leaving:'||l_proc,10);
148: --
149: End chk_budget_element_id;
150: --
151: --

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

179: ;
180:
181: Begin
182: --
183: hr_utility.set_location('Entering:'||l_proc, 5);
184: --
185: open csr_src;
186: fetch csr_src into l_dummy;
187: close csr_src;

Line 191: hr_utility.set_message(8302,'PQH_DUPLICATE_BUDGET_SRCS');

187: close csr_src;
188:
189: if nvl(l_dummy ,'Y') = 'X' then
190: --
191: hr_utility.set_message(8302,'PQH_DUPLICATE_BUDGET_SRCS');
192: hr_utility.raise_error;
193: --
194: end if;
195: if p_cost_allocation_keyflex_id is not null then

Line 192: hr_utility.raise_error;

188:
189: if nvl(l_dummy ,'Y') = 'X' then
190: --
191: hr_utility.set_message(8302,'PQH_DUPLICATE_BUDGET_SRCS');
192: hr_utility.raise_error;
193: --
194: end if;
195: if p_cost_allocation_keyflex_id is not null then
196: if p_project_id is not null

Line 201: hr_utility.set_message(8302,'PQH_BUDGET_SRC_GL_GMS');

197: or p_award_id is not null
198: or p_task_id is not null
199: or p_expenditure_type is not null
200: or p_organization_id is not null then
201: hr_utility.set_message(8302,'PQH_BUDGET_SRC_GL_GMS');
202: hr_utility.raise_error;
203: end if;
204: else
205: if p_project_id is null

Line 202: hr_utility.raise_error;

198: or p_task_id is not null
199: or p_expenditure_type is not null
200: or p_organization_id is not null then
201: hr_utility.set_message(8302,'PQH_BUDGET_SRC_GL_GMS');
202: hr_utility.raise_error;
203: end if;
204: else
205: if p_project_id is null
206: or p_award_id is null

Line 210: hr_utility.set_message(8302,'PQH_BUDGET_SRC_MANDATORY');

206: or p_award_id is null
207: or p_task_id is null
208: or p_expenditure_type is null
209: or p_organization_id is null then
210: hr_utility.set_message(8302,'PQH_BUDGET_SRC_MANDATORY');
211: hr_utility.raise_error;
212: end if;
213: end if;
214: --

Line 211: hr_utility.raise_error;

207: or p_task_id is null
208: or p_expenditure_type is null
209: or p_organization_id is null then
210: hr_utility.set_message(8302,'PQH_BUDGET_SRC_MANDATORY');
211: hr_utility.raise_error;
212: end if;
213: end if;
214: --
215: hr_utility.set_location('Leaving:'||l_proc,10);

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

211: hr_utility.raise_error;
212: end if;
213: end if;
214: --
215: hr_utility.set_location('Leaving:'||l_proc,10);
216: --
217: end chk_duplicate_src;
218: --
219: -- ----------------------------------------------------------------------------

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

234: where a.cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
235: --
236: Begin
237: --
238: hr_utility.set_location('Entering:'||l_proc,5);
239: --
240: l_api_updating := pqh_bfs_shd.api_updating
241: (p_budget_fund_src_id => p_budget_fund_src_id,
242: p_object_version_number => p_object_version_number);

Line 261: hr_utility.set_message(8302,'PQH_INVALID_COST_KEYFLEX');

257: --
258: -- raise error as FK does not relate to PK in pqh_budget_elements
259: -- table.
260: --
261: hr_utility.set_message(8302,'PQH_INVALID_COST_KEYFLEX');
262: hr_utility.raise_error;
263: --
264: end if;
265: --

Line 262: hr_utility.raise_error;

258: -- raise error as FK does not relate to PK in pqh_budget_elements
259: -- table.
260: --
261: hr_utility.set_message(8302,'PQH_INVALID_COST_KEYFLEX');
262: hr_utility.raise_error;
263: --
264: end if;
265: --
266: close c1;

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

266: close c1;
267: --
268: end if;
269: --
270: hr_utility.set_location('Leaving:'||l_proc,10);
271: --
272: End chk_cost_allocation_keyflex_id;
273:
274: -- ----------------------------------------------------------------------------

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

278: --
279: l_proc varchar2(72) := g_package||'insert_validate';
280: --
281: Begin
282: hr_utility.set_location('Entering:'||l_proc, 5);
283: --
284: -- Call all supporting business operations
285: --
286: chk_budget_fund_src_id

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

305: p_expenditure_type => p_rec.expenditure_type,
306: p_organization_id => p_rec.organization_id,
307: p_cost_allocation_keyflex_id => p_rec.cost_allocation_keyflex_id);
308: --
309: hr_utility.set_location(' Leaving:'||l_proc, 10);
310: End insert_validate;
311: --
312: -- ----------------------------------------------------------------------------
313: -- |---------------------------< update_validate >----------------------------|

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

316: --
317: l_proc varchar2(72) := g_package||'update_validate';
318: --
319: Begin
320: hr_utility.set_location('Entering:'||l_proc, 5);
321: --
322: -- Call all supporting business operations
323: --
324: chk_budget_fund_src_id

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

344: p_organization_id => p_rec.organization_id,
345: p_cost_allocation_keyflex_id => p_rec.cost_allocation_keyflex_id);
346: --
347: --
348: hr_utility.set_location(' Leaving:'||l_proc, 10);
349: End update_validate;
350: --
351: -- ----------------------------------------------------------------------------
352: -- |---------------------------< delete_validate >----------------------------|

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

355: --
356: l_proc varchar2(72) := g_package||'delete_validate';
357: --
358: Begin
359: hr_utility.set_location('Entering:'||l_proc, 5);
360: --
361: -- Call all supporting business operations
362: --
363: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

359: hr_utility.set_location('Entering:'||l_proc, 5);
360: --
361: -- Call all supporting business operations
362: --
363: hr_utility.set_location(' Leaving:'||l_proc, 10);
364: End delete_validate;
365: --
366: end pqh_bfs_bus;