DBA Data[Home] [Help]

APPS.PQH_BDGT_ACTUAL_CMMTMNT_PKG dependencies on HR_GENERAL

Line 228: FND_MESSAGE.SET_TOKEN('ENTITY',hr_general.decode_lookup('PQH_BUDGET_ENTITY','JOB'));

224: --Write into error log
225: Close csr_job;
226: --
227: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_ENTITY_TYPE');
228: FND_MESSAGE.SET_TOKEN('ENTITY',hr_general.decode_lookup('PQH_BUDGET_ENTITY','JOB'));
229: APP_EXCEPTION.RAISE_EXCEPTION;
230: --
231: End if;
232: --

Line 243: FND_MESSAGE.SET_TOKEN('ENTITY',hr_general.decode_lookup('PQH_BUDGET_ENTITY','JOB'));

239: Fetch csr_jobs_in_bdgt into l_dummy;
240: If csr_jobs_in_bdgt%notfound then
241: Close csr_jobs_in_bdgt;
242: FND_MESSAGE.SET_NAME('PQH','PQH_ENT_TYPE_NOT_IN_BDGT_VER');
243: FND_MESSAGE.SET_TOKEN('ENTITY',hr_general.decode_lookup('PQH_BUDGET_ENTITY','JOB'));
244: APP_EXCEPTION.RAISE_EXCEPTION;
245: End if;
246: Close csr_jobs_in_bdgt;
247: hr_utility.set_location('Leaving :'||l_proc,10);

Line 291: FND_MESSAGE.SET_TOKEN('ENTITY',hr_general.decode_lookup('PQH_BUDGET_ENTITY','GRADE'));

287: --Write into error log
288: Close csr_grade;
289: --
290: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_ENTITY_TYPE');
291: FND_MESSAGE.SET_TOKEN('ENTITY',hr_general.decode_lookup('PQH_BUDGET_ENTITY','GRADE'));
292: APP_EXCEPTION.RAISE_EXCEPTION;
293: --
294: End if;
295: Close csr_grade;

Line 304: FND_MESSAGE.SET_TOKEN('ENTITY',hr_general.decode_lookup('PQH_BUDGET_ENTITY','GRADE'));

300: Fetch csr_grades_in_bdgt into l_dummy;
301: If csr_grades_in_bdgt%notfound then
302: Close csr_grades_in_bdgt;
303: FND_MESSAGE.SET_NAME('PQH','PQH_ENT_TYPE_NOT_IN_BDGT_VER');
304: FND_MESSAGE.SET_TOKEN('ENTITY',hr_general.decode_lookup('PQH_BUDGET_ENTITY','GRADE'));
305: APP_EXCEPTION.RAISE_EXCEPTION;
306: End if;
307: Close csr_grades_in_bdgt;
308: --

Line 353: FND_MESSAGE.SET_TOKEN('ENTITY',hr_general.decode_lookup('PQH_BUDGET_ENTITY','ORGANIZATION'));

349: If csr_organization%notfound then
350: --Write into error log
351: Close csr_organization;
352: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_ENTITY_TYPE');
353: FND_MESSAGE.SET_TOKEN('ENTITY',hr_general.decode_lookup('PQH_BUDGET_ENTITY','ORGANIZATION'));
354: APP_EXCEPTION.RAISE_EXCEPTION;
355: --
356: End if;
357: Close csr_organization;

Line 366: FND_MESSAGE.SET_TOKEN('ENTITY',hr_general.decode_lookup('PQH_BUDGET_ENTITY','ORGANIZATION'));

362: Fetch csr_orgs_in_bdgt into l_dummy;
363: If csr_orgs_in_bdgt%notfound then
364: Close csr_orgs_in_bdgt;
365: FND_MESSAGE.SET_NAME('PQH','PQH_ENT_TYPE_NOT_IN_BDGT_VER');
366: FND_MESSAGE.SET_TOKEN('ENTITY',hr_general.decode_lookup('PQH_BUDGET_ENTITY','ORGANIZATION'));
367: APP_EXCEPTION.RAISE_EXCEPTION;
368: End if;
369: Close csr_orgs_in_bdgt;
370: --

Line 2358: l_business_group_id hr_all_organization_units.Business_group_id%TYPE := hr_general.get_business_group_id;

2354: l_position_commitment number := 0;
2355: l_position_total number := 0;
2356:
2357: -- Following two Variable Declerations done by vevenkat for bug 2628563
2358: l_business_group_id hr_all_organization_units.Business_group_id%TYPE := hr_general.get_business_group_id;
2359: l_effective_date Date := hr_general.effective_date;
2360: --
2361:
2362: l_proc varchar2(72) := g_package||'get_pos_actual_and_cmmtmnt';

Line 2359: l_effective_date Date := hr_general.effective_date;

2355: l_position_total number := 0;
2356:
2357: -- Following two Variable Declerations done by vevenkat for bug 2628563
2358: l_business_group_id hr_all_organization_units.Business_group_id%TYPE := hr_general.get_business_group_id;
2359: l_effective_date Date := hr_general.effective_date;
2360: --
2361:
2362: l_proc varchar2(72) := g_package||'get_pos_actual_and_cmmtmnt';
2363: --

Line 2715: l_effective_date := hr_general.effective_date;

2711: --
2712: Return 0;
2713: --
2714: End if;
2715: l_effective_date := hr_general.effective_date;
2716: l_business_group_id := hr_general.get_business_group_id;
2717: If l_business_group_id is null Then
2718: Open csr_bg_id;
2719: Fetch csr_bg_id into l_business_group_id;

Line 2716: l_business_group_id := hr_general.get_business_group_id;

2712: Return 0;
2713: --
2714: End if;
2715: l_effective_date := hr_general.effective_date;
2716: l_business_group_id := hr_general.get_business_group_id;
2717: If l_business_group_id is null Then
2718: Open csr_bg_id;
2719: Fetch csr_bg_id into l_business_group_id;
2720: Close csr_bg_id;