eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_BDGT_ACTUAL_CMMTMNT_PKG dependencies on FND_MESSAGE

Line 117: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_BUDGET_VERSION');

113: If csr_bdgt%notfound then
114: --Raise exception
115: --
116: Close csr_bdgt;
117: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_BUDGET_VERSION');
118: APP_EXCEPTION.RAISE_EXCEPTION;
119: --
120: End if;
121: --

Line 167: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_POSITION');

163: Open csr_pos;
164: Fetch csr_pos into l_dummy;
165: If csr_pos%notfound then
166: Close csr_pos;
167: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_POSITION');
168: APP_EXCEPTION.RAISE_EXCEPTION;
169: End if;
170: Close csr_pos;
171: --

Line 178: FND_MESSAGE.SET_NAME('PQH','PQH_POSITION_NOT_IN_BDGT_VER');

174: Open csr_positions_in_bdgt;
175: Fetch csr_positions_in_bdgt into l_dummy;
176: If csr_positions_in_bdgt%notfound then
177: Close csr_positions_in_bdgt;
178: FND_MESSAGE.SET_NAME('PQH','PQH_POSITION_NOT_IN_BDGT_VER');
179: APP_EXCEPTION.RAISE_EXCEPTION;
180: End if;
181: --
182: Close csr_positions_in_bdgt;

Line 227: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_ENTITY_TYPE');

223: If csr_job%notfound then
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;

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 242: FND_MESSAGE.SET_NAME('PQH','PQH_ENT_TYPE_NOT_IN_BDGT_VER');

238: Open csr_jobs_in_bdgt;
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;

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 290: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_ENTITY_TYPE');

286: If csr_grade%notfound then
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;

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 303: FND_MESSAGE.SET_NAME('PQH','PQH_ENT_TYPE_NOT_IN_BDGT_VER');

299: Open csr_grades_in_bdgt;
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;

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 352: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_ENTITY_TYPE');

348: Fetch csr_organization into l_dummy;
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;

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 365: FND_MESSAGE.SET_NAME('PQH','PQH_ENT_TYPE_NOT_IN_BDGT_VER');

361: Open csr_orgs_in_bdgt;
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;

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 399: FND_MESSAGE.SET_NAME('PQH','PQH_ACT_INVALID_ASSIGNMENT');

395: Fetch csr_assg into l_dummy;
396: If csr_assg%notfound then
397: --Raise error
398: Close csr_assg;
399: FND_MESSAGE.SET_NAME('PQH','PQH_ACT_INVALID_ASSIGNMENT');
400: APP_EXCEPTION.RAISE_EXCEPTION;
401: --
402: End if;
403: hr_utility.set_location('Leaving :'||l_proc,10);

Line 431: FND_MESSAGE.SET_NAME('PQH','PQH_ACT_INVALID_ELMNT_TYPE');

427: Open csr_elmnt_type;
428: Fetch csr_elmnt_type into l_dummy;
429: If csr_elmnt_type%notfound then
430: Close csr_elmnt_type;
431: FND_MESSAGE.SET_NAME('PQH','PQH_ACT_INVALID_ELMNT_TYPE');
432: APP_EXCEPTION.RAISE_EXCEPTION;
433: End if;
434: Close csr_elmnt_type;
435: else

Line 436: FND_MESSAGE.SET_NAME('PQH','PQH_ACT_INVALID_ELMNT_TYPE');

432: APP_EXCEPTION.RAISE_EXCEPTION;
433: End if;
434: Close csr_elmnt_type;
435: else
436: FND_MESSAGE.SET_NAME('PQH','PQH_ACT_INVALID_ELMNT_TYPE');
437: APP_EXCEPTION.RAISE_EXCEPTION;
438: end if;
439: --
440: hr_utility.set_location('Leaving :'||l_proc,10);

Line 465: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_BUDGET_UOM');

461: Open csr_uom;
462: Fetch csr_uom into p_unit_of_measure_desc;
463: If csr_uom%notfound then
464: Close csr_uom;
465: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_BUDGET_UOM');
466: APP_EXCEPTION.RAISE_EXCEPTION;
467: End if;
468: Close csr_uom;
469: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 500: FND_MESSAGE.SET_NAME('PQH','PQH_UOM_NOT_IN_BDGT');

496: Open csr_uom_in_bdgt;
497: Fetch csr_uom_in_bdgt into l_dummy;
498: If csr_uom_in_bdgt%notfound then
499: Close csr_uom_in_bdgt;
500: FND_MESSAGE.SET_NAME('PQH','PQH_UOM_NOT_IN_BDGT');
501: APP_EXCEPTION.RAISE_EXCEPTION;
502: End if;
503: Close csr_uom_in_bdgt;
504: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 528: FND_MESSAGE.SET_NAME('PQH','PQH_END_DT_LESS_THAN_START_DT');

524: Begin
525: hr_utility.set_location('Entering:'||l_proc, 5);
526: -- 1) Check if p_actuals_end_dt > p_actuals_start_dt.
527: If p_actuals_end_dt < p_actuals_start_dt then
528: FND_MESSAGE.SET_NAME('PQH','PQH_END_DT_LESS_THAN_START_DT');
529: APP_EXCEPTION.RAISE_EXCEPTION;
530: End if;
531: Open csr_bdgt;
532: Fetch csr_bdgt into l_budget_start_date,l_budget_end_date;

Line 539: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_ACTUALS_START_DT');

535: -- 3) Check if p_actual_start_dt > l_budget_end_date
536: if p_actuals_start_dt < l_budget_start_date
537: OR p_actuals_start_dt > l_budget_end_date then
538: --
539: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_ACTUALS_START_DT');
540: APP_EXCEPTION.RAISE_EXCEPTION;
541: End if;
542: -- 4) Check if p_actuals_end_dt > l_budget_end_date
543: if p_actuals_end_dt > l_budget_end_date then

Line 544: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_ACTUALS_END_DT');

540: APP_EXCEPTION.RAISE_EXCEPTION;
541: End if;
542: -- 4) Check if p_actuals_end_dt > l_budget_end_date
543: if p_actuals_end_dt > l_budget_end_date then
544: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_ACTUALS_END_DT');
545: APP_EXCEPTION.RAISE_EXCEPTION;
546: End if;
547: hr_utility.set_location('Leaving:'||l_proc, 10);
548: Exception When others then

Line 572: FND_MESSAGE.SET_NAME('PQH','PQH_END_DT_LESS_THAN_START_DT');

568: --
569: hr_utility.set_location('Entering:'||l_proc, 5);
570: --
571: If p_cmmtmnt_end_dt < p_cmmtmnt_start_dt then
572: FND_MESSAGE.SET_NAME('PQH','PQH_END_DT_LESS_THAN_START_DT');
573: APP_EXCEPTION.RAISE_EXCEPTION;
574: End if;
575: Open csr_bdgt;
576: Fetch csr_bdgt into l_budget_start_date,l_budget_end_date;

Line 580: FND_MESSAGE.SET_NAME('PQH','PQH_CMT_START_BEF_BDGT_START');

576: Fetch csr_bdgt into l_budget_start_date,l_budget_end_date;
577: Close csr_bdgt;
578: -- 2) Check if p_cmmtmnt_start_dt < p_budget_start_date
579: if p_cmmtmnt_start_dt < l_budget_start_date then
580: FND_MESSAGE.SET_NAME('PQH','PQH_CMT_START_BEF_BDGT_START');
581: APP_EXCEPTION.RAISE_EXCEPTION;
582: End if;
583: -- 3) Check if p_cmmtmnt_start_dt > l_budget_end_date
584: if p_cmmtmnt_start_dt > l_budget_end_date then

Line 585: FND_MESSAGE.SET_NAME('PQH','PQH_CMTMNT_START_AFT_BDGT_END');

581: APP_EXCEPTION.RAISE_EXCEPTION;
582: End if;
583: -- 3) Check if p_cmmtmnt_start_dt > l_budget_end_date
584: if p_cmmtmnt_start_dt > l_budget_end_date then
585: FND_MESSAGE.SET_NAME('PQH','PQH_CMTMNT_START_AFT_BDGT_END');
586: APP_EXCEPTION.RAISE_EXCEPTION;
587: End if;
588: -- 4) Check if p_cmmtmnt_end_dt > l_budget_end_date
589: if p_cmmtmnt_end_dt > l_budget_end_date then

Line 590: FND_MESSAGE.SET_NAME('PQH','PQH_CMTMNT_END_AFT_BDGT_END');

586: APP_EXCEPTION.RAISE_EXCEPTION;
587: End if;
588: -- 4) Check if p_cmmtmnt_end_dt > l_budget_end_date
589: if p_cmmtmnt_end_dt > l_budget_end_date then
590: FND_MESSAGE.SET_NAME('PQH','PQH_CMTMNT_END_AFT_BDGT_END');
591: APP_EXCEPTION.RAISE_EXCEPTION;
592: End if;
593: hr_utility.set_location('Leaving:'||l_proc, 10);
594: Exception When others then

Line 1658: FND_MESSAGE.SET_NAME('PQH','PQH_END_DT_LESS_THAN_START_DT');

1654: -- 1) Check if p_actuals_end_dt > p_actuals_start_dt.
1655: --
1656: If p_actuals_end_date < p_actuals_start_date then
1657: --
1658: FND_MESSAGE.SET_NAME('PQH','PQH_END_DT_LESS_THAN_START_DT');
1659: APP_EXCEPTION.RAISE_EXCEPTION;
1660: --
1661: End if;
1662: