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.
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;
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;
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;
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');
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;
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;
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');
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;
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;
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');
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;
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;
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');
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;
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: --
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
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);
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
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
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
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
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);
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;
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