DBA Data[Home] [Help]

APPS.PQH_COMMITMENT_PKG dependencies on APP_EXCEPTION

Line 208: APP_EXCEPTION.RAISE_EXCEPTION;

204: --Raise exception
205: --
206: Close csr_bdgt;
207: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_BUDGET_VERSION');
208: APP_EXCEPTION.RAISE_EXCEPTION;
209: --
210: Else
211: --
212: -- DETERMINE WHETHER SELETED P_BUDGETED_ENTITY_CD , L_BUDGETED_ENTITY_CD ARE SAME OR NOT.

Line 217: APP_EXCEPTION.RAISE_EXCEPTION;

213: --
214: If l_budgeted_entity_cd <> p_budgeted_entity_cd then
215: --
216: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_BUDGET');
217: APP_EXCEPTION.RAISE_EXCEPTION;
218: --
219: End if;
220: --
221: End if;

Line 239: APP_EXCEPTION.RAISE_EXCEPTION;

235: --Raise exception
236: --
237: Close csr_bdgt_cal_freq;
238: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_BDGT_CALENDAR');
239: APP_EXCEPTION.RAISE_EXCEPTION;
240: --
241: End if;
242: --
243: Close csr_bdgt_cal_freq;

Line 356: APP_EXCEPTION.RAISE_EXCEPTION;

352: --Raise exception
353: --
354: Close csr_pos;
355: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_ENTITY');
356: APP_EXCEPTION.RAISE_EXCEPTION;
357: --
358: End if;
359: --
360: Close csr_pos;

Line 398: APP_EXCEPTION.RAISE_EXCEPTION;

394: --
395: If p_entity_id IS NULL then
396: --
397: FND_MESSAGE.SET_NAME('PQH','PQH_NO_ENTITIES_IN_BDGT_VER');
398: APP_EXCEPTION.RAISE_EXCEPTION;
399: --
400: Else
401: --
402: FND_MESSAGE.SET_NAME('PQH','PQH_ENTITY_NOT_IN_BDGT_VER');

Line 403: APP_EXCEPTION.RAISE_EXCEPTION;

399: --
400: Else
401: --
402: FND_MESSAGE.SET_NAME('PQH','PQH_ENTITY_NOT_IN_BDGT_VER');
403: APP_EXCEPTION.RAISE_EXCEPTION;
404: --
405: End if;
406: --
407: End If;

Line 428: APP_EXCEPTION.RAISE_EXCEPTION;

424: --Raise exception
425: --
426: Close csr_org;
427: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_ENTITY');
428: APP_EXCEPTION.RAISE_EXCEPTION;
429: --
430: End if;
431: --
432: Close csr_org;

Line 471: APP_EXCEPTION.RAISE_EXCEPTION;

467: --
468: If p_entity_id IS NULL then
469: --
470: FND_MESSAGE.SET_NAME('PQH','PQH_NO_ENTITIES_IN_BDGT_VER');
471: APP_EXCEPTION.RAISE_EXCEPTION;
472: --
473: Else
474: --
475: FND_MESSAGE.SET_NAME('PQH','PQH_ENTITY_NOT_IN_BDGT_VER');

Line 476: APP_EXCEPTION.RAISE_EXCEPTION;

472: --
473: Else
474: --
475: FND_MESSAGE.SET_NAME('PQH','PQH_ENTITY_NOT_IN_BDGT_VER');
476: APP_EXCEPTION.RAISE_EXCEPTION;
477: --
478: End if;
479: --
480: End If;

Line 504: APP_EXCEPTION.RAISE_EXCEPTION;

500: --Raise exception
501: --
502: Close csr_job;
503: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_ENTITY');
504: APP_EXCEPTION.RAISE_EXCEPTION;
505: --
506: End if;
507: --
508: Close csr_job;

Line 547: APP_EXCEPTION.RAISE_EXCEPTION;

543: --
544: If p_entity_id IS NULL then
545: --
546: FND_MESSAGE.SET_NAME('PQH','PQH_NO_ENTITIES_IN_BDGT_VER');
547: APP_EXCEPTION.RAISE_EXCEPTION;
548: --
549: Else
550: --
551: FND_MESSAGE.SET_NAME('PQH','PQH_ENTITY_NOT_IN_BDGT_VER');

Line 552: APP_EXCEPTION.RAISE_EXCEPTION;

548: --
549: Else
550: --
551: FND_MESSAGE.SET_NAME('PQH','PQH_ENTITY_NOT_IN_BDGT_VER');
552: APP_EXCEPTION.RAISE_EXCEPTION;
553: --
554: End if;
555: --
556: End If;

Line 578: APP_EXCEPTION.RAISE_EXCEPTION;

574: --Raise exception
575: --
576: Close csr_grade;
577: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_ENTITY');
578: APP_EXCEPTION.RAISE_EXCEPTION;
579: --
580: End if;
581: --
582: Close csr_grade;

Line 621: APP_EXCEPTION.RAISE_EXCEPTION;

617: --
618: If p_entity_id IS NULL then
619: --
620: FND_MESSAGE.SET_NAME('PQH','PQH_NO_ENTITIES_IN_BDGT_VER');
621: APP_EXCEPTION.RAISE_EXCEPTION;
622: --
623: Else
624: --
625: FND_MESSAGE.SET_NAME('PQH','PQH_ENTITY_NOT_IN_BDGT_VER');

Line 626: APP_EXCEPTION.RAISE_EXCEPTION;

622: --
623: Else
624: --
625: FND_MESSAGE.SET_NAME('PQH','PQH_ENTITY_NOT_IN_BDGT_VER');
626: APP_EXCEPTION.RAISE_EXCEPTION;
627: --
628: End if;
629: --
630: End If;

Line 732: APP_EXCEPTION.RAISE_EXCEPTION;

728: p_base_period_type := WEEKLY;
729: p_multiple := 1;
730: else
731: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_PERIOD_TYPE');
732: APP_EXCEPTION.RAISE_EXCEPTION;
733: end if;
734: --
735: hr_utility.set_location('Leaving:'||proc_name, 10);
736: --

Line 1030: APP_EXCEPTION.RAISE_EXCEPTION;

1026: --
1027: If l_start_dt_valid <> 'Y' then
1028: --
1029: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_CMMTMNT_START_DT');
1030: APP_EXCEPTION.RAISE_EXCEPTION;
1031: --
1032: End if;
1033: --
1034: if l_end_dt_valid <> 'Y' then

Line 1037: APP_EXCEPTION.RAISE_EXCEPTION;

1033: --
1034: if l_end_dt_valid <> 'Y' then
1035: --
1036: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_CMMTMNT_END_DT');
1037: APP_EXCEPTION.RAISE_EXCEPTION;
1038: --
1039: End if;
1040: --
1041: hr_utility.set_location('Leaving :'||l_proc,25);

Line 1075: APP_EXCEPTION.RAISE_EXCEPTION;

1071: --
1072: If p_cmmtmnt_end_dt < p_cmmtmnt_start_dt then
1073: --
1074: FND_MESSAGE.SET_NAME('PQH','PQH_END_DT_LESS_THAN_START_DT');
1075: APP_EXCEPTION.RAISE_EXCEPTION;
1076: --
1077: End if;
1078: --
1079: -- 2) Check if p_cmmtmnt_start_dt < p_budget_start_date

Line 1084: APP_EXCEPTION.RAISE_EXCEPTION;

1080: --
1081: if p_cmmtmnt_start_dt < p_budget_start_date then
1082: --
1083: FND_MESSAGE.SET_NAME('PQH','PQH_CMT_START_BEF_BDGT_START');
1084: APP_EXCEPTION.RAISE_EXCEPTION;
1085: --
1086: End if;
1087: -- commented by Sumit Goyal
1088: -- for relieving commitments you may have to calculate commitments beyond the budget date range

Line 1095: APP_EXCEPTION.RAISE_EXCEPTION;

1091: --
1092: if p_cmmtmnt_start_dt > p_budget_end_date then
1093: --
1094: FND_MESSAGE.SET_NAME('PQH','PQH_CMTMNT_START_AFT_BDGT_END');
1095: APP_EXCEPTION.RAISE_EXCEPTION;
1096: --
1097: End if;
1098: --
1099: -- 4) Check if p_cmmtmnt_end_dt > p_budget_end_date

Line 1104: APP_EXCEPTION.RAISE_EXCEPTION;

1100: --
1101: if p_cmmtmnt_end_dt > p_budget_end_date then
1102: --
1103: FND_MESSAGE.SET_NAME('PQH','PQH_CMTMNT_END_AFT_BDGT_END');
1104: APP_EXCEPTION.RAISE_EXCEPTION;
1105: --
1106: End if;
1107: --
1108: -- THE FOLL FUNCTION DOES THE FOLL VALIDATIONS . GIVEN THE FREQUENCY AND THE

Line 2067: APP_EXCEPTION.RAISE_EXCEPTION;

2063: --
2064: Close csr_bdgt_version;
2065: --
2066: FND_MESSAGE.SET_NAME('PQH','PQH_NO_BDGT_CMMTMNT_EMNTS');
2067: APP_EXCEPTION.RAISE_EXCEPTION;
2068: --
2069: End if;
2070: --
2071: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 3809: APP_EXCEPTION.RAISE_EXCEPTION;

3805: --Raise exception
3806: --
3807: Close csr_bdgt_cal_freq;
3808: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_BDGT_CALENDAR');
3809: APP_EXCEPTION.RAISE_EXCEPTION;
3810: --
3811: End if;
3812: --
3813: Close csr_bdgt_cal_freq;

Line 3939: APP_EXCEPTION.RAISE_EXCEPTION;

3935: -- PQH_INVALID_INPUTS_FOR_REF : Element type cannot be null. Please provide
3936: -- the Element Type id or Please pass input_value_id also null
3937: --
3938: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_INPUTS_FOR_REF');
3939: APP_EXCEPTION.RAISE_EXCEPTION;
3940: --
3941: End if;
3942:
3943: -- If Element Type Id is provided, fetching the input_value_id