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 APP_EXCEPTION

Line 118: APP_EXCEPTION.RAISE_EXCEPTION;

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: --
122: Close csr_bdgt;

Line 168: APP_EXCEPTION.RAISE_EXCEPTION;

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: --
172: -- Also check if the position belongs to the passed budget version

Line 179: APP_EXCEPTION.RAISE_EXCEPTION;

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;
183: --

Line 229: APP_EXCEPTION.RAISE_EXCEPTION;

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: --
233: Close csr_job;

Line 244: APP_EXCEPTION.RAISE_EXCEPTION;

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);
248: --

Line 292: APP_EXCEPTION.RAISE_EXCEPTION;

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;
296: -- Also check if the grade belongs to the passed budget version

Line 305: APP_EXCEPTION.RAISE_EXCEPTION;

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: --
309: hr_utility.set_location('Leaving :'||l_proc,10);

Line 354: APP_EXCEPTION.RAISE_EXCEPTION;

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;
358: -- Also check if the organization belongs to the passed budget version

Line 367: APP_EXCEPTION.RAISE_EXCEPTION;

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: --
371: hr_utility.set_location('Leaving :'||l_proc,10);

Line 400: APP_EXCEPTION.RAISE_EXCEPTION;

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);
404: Close csr_assg;

Line 432: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 437: 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);
441: EXCEPTION

Line 466: APP_EXCEPTION.RAISE_EXCEPTION;

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);
470: --

Line 501: APP_EXCEPTION.RAISE_EXCEPTION;

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);
505: Exception When others then

Line 529: APP_EXCEPTION.RAISE_EXCEPTION;

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;
533: Close csr_bdgt;

Line 540: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 545: 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
549: hr_utility.set_location('Exception:'||l_proc, 15);

Line 573: APP_EXCEPTION.RAISE_EXCEPTION;

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;
577: Close csr_bdgt;

Line 581: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 586: 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
590: FND_MESSAGE.SET_NAME('PQH','PQH_CMTMNT_END_AFT_BDGT_END');

Line 591: 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
595: hr_utility.set_location('Exception:'||l_proc, 15);

Line 1659: APP_EXCEPTION.RAISE_EXCEPTION;

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:
1663: --