DBA Data[Home] [Help]

APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on FND_MESSAGE

Line 939: fnd_message.set_name('PQP','PQP_230736_CC_MNDTRY');

935: IF l_ret_cc ='N' AND p_engine_capacity IS NOT NULL THEN
936:
937: l_engine_capacity :=p_engine_capacity;
938: ELSIF p_engine_capacity IS NULL AND l_ret_cc ='N'AND p_vehicle_type<>'P' THEN
939: fnd_message.set_name('PQP','PQP_230736_CC_MNDTRY');
940: fnd_message.raise_error;
941: hr_multi_message.end_validation_set;
942: ELSIF p_vehicle_type ='P' THEN
943:

Line 940: fnd_message.raise_error;

936:
937: l_engine_capacity :=p_engine_capacity;
938: ELSIF p_engine_capacity IS NULL AND l_ret_cc ='N'AND p_vehicle_type<>'P' THEN
939: fnd_message.set_name('PQP','PQP_230736_CC_MNDTRY');
940: fnd_message.raise_error;
941: hr_multi_message.end_validation_set;
942: ELSIF p_vehicle_type ='P' THEN
943:
944: l_engine_capacity:='0';

Line 957: fnd_message.set_name('PQP','PQP_230857_PAYROLL_NOT_EXST');

953: ,p_effective_date =>p_effective_date
954: ,p_payroll_id =>l_get_pay_det
955: );
956: IF l_ret_mesg<>0 THEN
957: fnd_message.set_name('PQP','PQP_230857_PAYROLL_NOT_EXST');
958: fnd_message.raise_error;
959: hr_multi_message.end_validation_set;
960: END IF;
961:

Line 958: fnd_message.raise_error;

954: ,p_payroll_id =>l_get_pay_det
955: );
956: IF l_ret_mesg<>0 THEN
957: fnd_message.set_name('PQP','PQP_230857_PAYROLL_NOT_EXST');
958: fnd_message.raise_error;
959: hr_multi_message.end_validation_set;
960: END IF;
961:
962: hr_utility.set_location(' Enter payroll details cursor:' || l_proc,30);

Line 997: fnd_message.raise_error;

993: ,p_message =>l_message
994: );
995:
996: IF l_chk_eligibility = 'N' THEN
997: fnd_message.raise_error;
998: hr_multi_message.end_validation_set;
999: END IF;
1000: hr_utility.set_location(' Enter Assignment level Element search:' || l_proc,50);
1001: --Find if element is present at the assignment level

Line 1105: fnd_message.set_name('PQP','PQP_230732_VLD_MLG_ELE_FAIL');

1101: END IF;
1102: END IF;
1103:
1104: IF l_element_type_id IS NULL THEN
1105: fnd_message.set_name('PQP','PQP_230732_VLD_MLG_ELE_FAIL');
1106: fnd_message.raise_error;
1107: hr_multi_message.end_validation_set;
1108: END IF;
1109:

Line 1106: fnd_message.raise_error;

1102: END IF;
1103:
1104: IF l_element_type_id IS NULL THEN
1105: fnd_message.set_name('PQP','PQP_230732_VLD_MLG_ELE_FAIL');
1106: fnd_message.raise_error;
1107: hr_multi_message.end_validation_set;
1108: END IF;
1109:
1110: hr_utility.set_location(' Enter element link search:' || l_proc,110);

Line 1205: fnd_message.raise_error;

1201: );
1202:
1203:
1204: IF l_chk_mndtry = 'N' THEN
1205: fnd_message.raise_error;
1206: hr_multi_message.end_validation_set;
1207: END IF;
1208:
1209: --Input values are vary from Private to Company vehicles

Line 1620: fnd_message.raise_error;

1616: exception
1617: --------
1618: When others then
1619: hr_utility.set_location(l_proc,180);
1620: fnd_message.raise_error;
1621: hr_multi_message.end_validation_set;
1622:
1623: END;
1624:

Line 1692: fnd_message.set_name('PQP','PQP_230718_CLM_PROC_DEL');

1688: ,p_element_entry_id =>p_element_entry_id
1689: );
1690: ELSE
1691: hr_utility.set_location(l_proc,40);
1692: fnd_message.set_name('PQP','PQP_230718_CLM_PROC_DEL');
1693: fnd_message.raise_error;
1694: hr_multi_message.end_validation_set;
1695: END IF;
1696:

Line 1693: fnd_message.raise_error;

1689: );
1690: ELSE
1691: hr_utility.set_location(l_proc,40);
1692: fnd_message.set_name('PQP','PQP_230718_CLM_PROC_DEL');
1693: fnd_message.raise_error;
1694: hr_multi_message.end_validation_set;
1695: END IF;
1696:
1697: ELSE

Line 1700: fnd_message.set_name('PQP','PQP_230718_CLM_PROC_DEL');

1696:
1697: ELSE
1698:
1699: hr_utility.set_location(l_proc,50);
1700: fnd_message.set_name('PQP','PQP_230718_CLM_PROC_DEL');
1701: fnd_message.raise_error;
1702: hr_multi_message.end_validation_set;
1703: END IF;
1704: END LOOP;

Line 1701: fnd_message.raise_error;

1697: ELSE
1698:
1699: hr_utility.set_location(l_proc,50);
1700: fnd_message.set_name('PQP','PQP_230718_CLM_PROC_DEL');
1701: fnd_message.raise_error;
1702: hr_multi_message.end_validation_set;
1703: END IF;
1704: END LOOP;
1705: exception

Line 1709: fnd_message.raise_error;

1705: exception
1706: --------
1707: When others then
1708: hr_utility.set_location(l_proc,60);
1709: fnd_message.raise_error;
1710: hr_multi_message.end_validation_set;
1711: END;
1712:
1713: --get element or rates from configuration

Line 1941: fnd_message.raise_error;

1937: CLOSE c_chk_active;
1938: IF l_st_date IS NOT NULL AND
1939: l_end_date IS NOT NULL THEN
1940:
1941: fnd_message.raise_error;
1942:
1943: ELSIF l_st_date IS NOT NULL AND
1944: l_end_date IS NULL THEN
1945:

Line 1946: fnd_message.raise_error;

1942:
1943: ELSIF l_st_date IS NOT NULL AND
1944: l_end_date IS NULL THEN
1945:
1946: fnd_message.raise_error;
1947: ELSIF l_st_date IS NULL AND
1948: l_end_date IS NOT NULL THEN
1949:
1950: fnd_message.raise_error;

Line 1950: fnd_message.raise_error;

1946: fnd_message.raise_error;
1947: ELSIF l_st_date IS NULL AND
1948: l_end_date IS NOT NULL THEN
1949:
1950: fnd_message.raise_error;
1951:
1952: END IF;
1953:
1954: END;

Line 2023: fnd_message.set_name('PQP', 'PQP_230859_VEHICLE_TYP_VALIDAT');

2019: IF c_get_veh_det%FOUND THEN
2020: hr_utility.set_location( l_proc,20);
2021: IF l_get_veh_det.vehicle_type<>p_vehicle_type THEN
2022: hr_utility.set_location( l_proc,30);
2023: fnd_message.set_name('PQP', 'PQP_230859_VEHICLE_TYP_VALIDAT');
2024: l_retvalue :='N';
2025: END IF;
2026: IF l_get_veh_det.engine_capacity_in_cc
2027: <>p_engine_capacity THEN

Line 2029: fnd_message.set_name('PQP', 'PQP_230860_ENGINE_CAP_VALIDAT');

2025: END IF;
2026: IF l_get_veh_det.engine_capacity_in_cc
2027: <>p_engine_capacity THEN
2028: hr_utility.set_location( l_proc,40);
2029: fnd_message.set_name('PQP', 'PQP_230860_ENGINE_CAP_VALIDAT');
2030: l_retvalue :='N';
2031:
2032: END IF;
2033: IF l_get_veh_det.fuel_type <>p_fuel_type THEN

Line 2035: fnd_message.set_name('PQP', 'PQP_230861_FUEL_TYP_VALIDAT');

2031:
2032: END IF;
2033: IF l_get_veh_det.fuel_type <>p_fuel_type THEN
2034: hr_utility.set_location( l_proc,50);
2035: fnd_message.set_name('PQP', 'PQP_230861_FUEL_TYP_VALIDAT');
2036: l_retvalue :='N';
2037: END IF;
2038:
2039:

Line 2053: fnd_message.set_name('PQP', 'PQP_230866_COMP_VEH_NOT_ALLOC');

2049: FETCH c_validate_comp_veh INTO l_validate_comp_veh;
2050: IF c_validate_comp_veh%NOTFOUND THEN
2051:
2052: hr_utility.set_location( l_proc,70);
2053: fnd_message.set_name('PQP', 'PQP_230866_COMP_VEH_NOT_ALLOC');
2054: l_retvalue :='N';
2055: END IF;
2056:
2057: CLOSE c_validate_comp_veh;

Line 2062: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

2058:
2059: END IF;
2060: IF p_ownership IS NULL THEN
2061: hr_utility.set_location( l_proc,80);
2062: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2063: fnd_message.set_token('TOKEN','Ownership');
2064: l_retvalue :='N';
2065: END IF;
2066:

Line 2063: fnd_message.set_token('TOKEN','Ownership');

2059: END IF;
2060: IF p_ownership IS NULL THEN
2061: hr_utility.set_location( l_proc,80);
2062: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2063: fnd_message.set_token('TOKEN','Ownership');
2064: l_retvalue :='N';
2065: END IF;
2066:
2067: --Commented out this now because this condition is no longer

Line 2071: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

2067: --Commented out this now because this condition is no longer
2068: --required as the code handles this during element entry.
2069: /*IF p_usage_type IS NULL THEN
2070: hr_utility.set_location( l_proc,90);
2071: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2072: fnd_message.set_token('TOKEN','Usage Type');
2073: l_retvalue :='N';
2074:
2075: END IF;*/

Line 2072: fnd_message.set_token('TOKEN','Usage Type');

2068: --required as the code handles this during element entry.
2069: /*IF p_usage_type IS NULL THEN
2070: hr_utility.set_location( l_proc,90);
2071: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2072: fnd_message.set_token('TOKEN','Usage Type');
2073: l_retvalue :='N';
2074:
2075: END IF;*/
2076:

Line 2079: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

2075: END IF;*/
2076:
2077: IF p_vehicle_type IS NULL THEN
2078: hr_utility.set_location( l_proc,100);
2079: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2080: fnd_message.set_token('TOKEN','Vehicle Type');
2081: l_retvalue :='N';
2082:
2083: END IF;

Line 2080: fnd_message.set_token('TOKEN','Vehicle Type');

2076:
2077: IF p_vehicle_type IS NULL THEN
2078: hr_utility.set_location( l_proc,100);
2079: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2080: fnd_message.set_token('TOKEN','Vehicle Type');
2081: l_retvalue :='N';
2082:
2083: END IF;
2084:

Line 2088: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

2084:
2085:
2086: IF p_start_date IS NULL THEN
2087: hr_utility.set_location( l_proc,110);
2088: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2089: fnd_message.set_token('TOKEN','Start Date');
2090: l_retvalue :='N';
2091:
2092: END IF;

Line 2089: fnd_message.set_token('TOKEN','Start Date');

2085:
2086: IF p_start_date IS NULL THEN
2087: hr_utility.set_location( l_proc,110);
2088: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2089: fnd_message.set_token('TOKEN','Start Date');
2090: l_retvalue :='N';
2091:
2092: END IF;
2093:

Line 2096: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

2092: END IF;
2093:
2094: IF p_end_date IS NULL THEN
2095: hr_utility.set_location( l_proc,120);
2096: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2097: fnd_message.set_token('TOKEN','End Date');
2098:
2099: l_retvalue :='N';
2100: END IF;

Line 2097: fnd_message.set_token('TOKEN','End Date');

2093:
2094: IF p_end_date IS NULL THEN
2095: hr_utility.set_location( l_proc,120);
2096: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2097: fnd_message.set_token('TOKEN','End Date');
2098:
2099: l_retvalue :='N';
2100: END IF;
2101: IF p_claimed_mileage IS NULL THEN

Line 2103: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

2099: l_retvalue :='N';
2100: END IF;
2101: IF p_claimed_mileage IS NULL THEN
2102: hr_utility.set_location( l_proc,130);
2103: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2104: fnd_message.set_token('TOKEN','Claimed Mileage');
2105: l_retvalue :='N';
2106:
2107: END IF;

Line 2104: fnd_message.set_token('TOKEN','Claimed Mileage');

2100: END IF;
2101: IF p_claimed_mileage IS NULL THEN
2102: hr_utility.set_location( l_proc,130);
2103: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2104: fnd_message.set_token('TOKEN','Claimed Mileage');
2105: l_retvalue :='N';
2106:
2107: END IF;
2108:

Line 2112: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');

2108:
2109:
2110: IF p_engine_capacity IS NULL THEN
2111: hr_utility.set_location( l_proc,140);
2112: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2113: fnd_message.set_token('TOKEN','Engine Capacity');
2114: l_retvalue :='N';
2115: END IF;
2116:

Line 2113: fnd_message.set_token('TOKEN','Engine Capacity');

2109:
2110: IF p_engine_capacity IS NULL THEN
2111: hr_utility.set_location( l_proc,140);
2112: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2113: fnd_message.set_token('TOKEN','Engine Capacity');
2114: l_retvalue :='N';
2115: END IF;
2116:
2117: IF p_element_type_id IS NULL THEN

Line 2120: fnd_message.set_name('PQP', 'PQP_230732_VLD_MLG_ELE_FAIL');

2116:
2117: IF p_element_type_id IS NULL THEN
2118: hr_utility.set_location( l_proc,150);
2119:
2120: fnd_message.set_name('PQP', 'PQP_230732_VLD_MLG_ELE_FAIL');
2121: l_retvalue :='N';
2122: END IF;
2123:
2124: IF FND_DATE.CHARDT_TO_DATE(p_end_date) <

Line 2127: fnd_message.set_name('PER','HR_289262_ST_DATE_BEFORE_EDATE');

2123:
2124: IF FND_DATE.CHARDT_TO_DATE(p_end_date) <
2125: FND_DATE.CHARDT_TO_DATE(p_start_date) THEN
2126: hr_utility.set_location( l_proc,160);
2127: fnd_message.set_name('PER','HR_289262_ST_DATE_BEFORE_EDATE');
2128: l_retvalue :='N';
2129: END IF;
2130:
2131: --RETURN('Y');

Line 2233: fnd_message.set_name('PQP', 'PQP_230715_CLM_CUT_OFF_DT');

2229: (l_get_config_info.prev_tax_yr_valid||
2230: TO_CHAR(p_effective_date,'YYYY'))
2231: THEN
2232: --Error handling missing
2233: fnd_message.set_name('PQP', 'PQP_230715_CLM_CUT_OFF_DT');
2234: p_message :='Violated Valid Tax Year';
2235:
2236: l_retvalue :='N';
2237: END IF;

Line 2259: fnd_message.set_name('PQP', 'PQP_230735_REGNUM_FRM_REP');

2255: END LOOP;
2256: CLOSE c_validate_veh;
2257:
2258: IF l_validate_veh.exst IS NULL THEN
2259: fnd_message.set_name('PQP', 'PQP_230735_REGNUM_FRM_REP');
2260: p_message:='Enter Only Vehicle in Repository';
2261:
2262: l_retvalue :='N';
2263: END IF;

Line 2280: fnd_message.set_name('PQP', 'PQP_230740_ONE_OWNRSHP_RSTRICT');

2276:
2277: END LOOP;
2278: CLOSE c_get_alloc_info;
2279: IF l_get_alloc_info.ownership<>p_ownership THEN
2280: fnd_message.set_name('PQP', 'PQP_230740_ONE_OWNRSHP_RSTRICT');
2281: p_message :='Enter Only one type of Claim';
2282: l_retvalue :='N';
2283: END IF;
2284: END IF;