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 1203: fnd_message.raise_error;

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

Line 1608: fnd_message.raise_error;

1604: exception
1605: --------
1606: When others then
1607: hr_utility.set_location(l_proc,180);
1608: fnd_message.raise_error;
1609: hr_multi_message.end_validation_set;
1610:
1611: END;
1612:

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

1676: ,p_element_entry_id =>p_element_entry_id
1677: );
1678: ELSE
1679: hr_utility.set_location(l_proc,40);
1680: fnd_message.set_name('PQP','PQP_230718_CLM_PROC_DEL');
1681: fnd_message.raise_error;
1682: hr_multi_message.end_validation_set;
1683: END IF;
1684:

Line 1681: fnd_message.raise_error;

1677: );
1678: ELSE
1679: hr_utility.set_location(l_proc,40);
1680: fnd_message.set_name('PQP','PQP_230718_CLM_PROC_DEL');
1681: fnd_message.raise_error;
1682: hr_multi_message.end_validation_set;
1683: END IF;
1684:
1685: ELSE

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

1684:
1685: ELSE
1686:
1687: hr_utility.set_location(l_proc,50);
1688: fnd_message.set_name('PQP','PQP_230718_CLM_PROC_DEL');
1689: fnd_message.raise_error;
1690: hr_multi_message.end_validation_set;
1691: END IF;
1692: END LOOP;

Line 1689: fnd_message.raise_error;

1685: ELSE
1686:
1687: hr_utility.set_location(l_proc,50);
1688: fnd_message.set_name('PQP','PQP_230718_CLM_PROC_DEL');
1689: fnd_message.raise_error;
1690: hr_multi_message.end_validation_set;
1691: END IF;
1692: END LOOP;
1693: exception

Line 1697: fnd_message.raise_error;

1693: exception
1694: --------
1695: When others then
1696: hr_utility.set_location(l_proc,60);
1697: fnd_message.raise_error;
1698: hr_multi_message.end_validation_set;
1699: END;
1700:
1701: --get element or rates from configuration

Line 1927: fnd_message.raise_error;

1923: CLOSE c_chk_active;
1924: IF l_st_date IS NOT NULL AND
1925: l_end_date IS NOT NULL THEN
1926:
1927: fnd_message.raise_error;
1928:
1929: ELSIF l_st_date IS NOT NULL AND
1930: l_end_date IS NULL THEN
1931:

Line 1932: fnd_message.raise_error;

1928:
1929: ELSIF l_st_date IS NOT NULL AND
1930: l_end_date IS NULL THEN
1931:
1932: fnd_message.raise_error;
1933: ELSIF l_st_date IS NULL AND
1934: l_end_date IS NOT NULL THEN
1935:
1936: fnd_message.raise_error;

Line 1936: fnd_message.raise_error;

1932: fnd_message.raise_error;
1933: ELSIF l_st_date IS NULL AND
1934: l_end_date IS NOT NULL THEN
1935:
1936: fnd_message.raise_error;
1937:
1938: END IF;
1939:
1940: END;

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

2005: IF c_get_veh_det%FOUND THEN
2006: hr_utility.set_location( l_proc,20);
2007: IF l_get_veh_det.vehicle_type<>p_vehicle_type THEN
2008: hr_utility.set_location( l_proc,30);
2009: fnd_message.set_name('PQP', 'PQP_230859_VEHICLE_TYP_VALIDAT');
2010: l_retvalue :='N';
2011: END IF;
2012: IF l_get_veh_det.engine_capacity_in_cc
2013: <>p_engine_capacity THEN

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

2011: END IF;
2012: IF l_get_veh_det.engine_capacity_in_cc
2013: <>p_engine_capacity THEN
2014: hr_utility.set_location( l_proc,40);
2015: fnd_message.set_name('PQP', 'PQP_230860_ENGINE_CAP_VALIDAT');
2016: l_retvalue :='N';
2017:
2018: END IF;
2019: IF l_get_veh_det.fuel_type <>p_fuel_type THEN

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

2017:
2018: END IF;
2019: IF l_get_veh_det.fuel_type <>p_fuel_type THEN
2020: hr_utility.set_location( l_proc,50);
2021: fnd_message.set_name('PQP', 'PQP_230861_FUEL_TYP_VALIDAT');
2022: l_retvalue :='N';
2023: END IF;
2024:
2025:

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

2035: FETCH c_validate_comp_veh INTO l_validate_comp_veh;
2036: IF c_validate_comp_veh%NOTFOUND THEN
2037:
2038: hr_utility.set_location( l_proc,70);
2039: fnd_message.set_name('PQP', 'PQP_230866_COMP_VEH_NOT_ALLOC');
2040: l_retvalue :='N';
2041: END IF;
2042:
2043: CLOSE c_validate_comp_veh;

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

2044:
2045: END IF;
2046: IF p_ownership IS NULL THEN
2047: hr_utility.set_location( l_proc,80);
2048: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2049: fnd_message.set_token('TOKEN','Ownership');
2050: l_retvalue :='N';
2051: END IF;
2052:

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

2045: END IF;
2046: IF p_ownership IS NULL THEN
2047: hr_utility.set_location( l_proc,80);
2048: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2049: fnd_message.set_token('TOKEN','Ownership');
2050: l_retvalue :='N';
2051: END IF;
2052:
2053: --Commented out this now because this condition is no longer

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

2053: --Commented out this now because this condition is no longer
2054: --required as the code handles this during element entry.
2055: /*IF p_usage_type IS NULL THEN
2056: hr_utility.set_location( l_proc,90);
2057: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2058: fnd_message.set_token('TOKEN','Usage Type');
2059: l_retvalue :='N';
2060:
2061: END IF;*/

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

2054: --required as the code handles this during element entry.
2055: /*IF p_usage_type IS NULL THEN
2056: hr_utility.set_location( l_proc,90);
2057: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2058: fnd_message.set_token('TOKEN','Usage Type');
2059: l_retvalue :='N';
2060:
2061: END IF;*/
2062:

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

2061: END IF;*/
2062:
2063: IF p_vehicle_type IS NULL THEN
2064: hr_utility.set_location( l_proc,100);
2065: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2066: fnd_message.set_token('TOKEN','Vehicle Type');
2067: l_retvalue :='N';
2068:
2069: END IF;

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

2062:
2063: IF p_vehicle_type IS NULL THEN
2064: hr_utility.set_location( l_proc,100);
2065: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2066: fnd_message.set_token('TOKEN','Vehicle Type');
2067: l_retvalue :='N';
2068:
2069: END IF;
2070:

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

2070:
2071:
2072: IF p_start_date IS NULL THEN
2073: hr_utility.set_location( l_proc,110);
2074: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2075: fnd_message.set_token('TOKEN','Start Date');
2076: l_retvalue :='N';
2077:
2078: END IF;

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

2071:
2072: IF p_start_date IS NULL THEN
2073: hr_utility.set_location( l_proc,110);
2074: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2075: fnd_message.set_token('TOKEN','Start Date');
2076: l_retvalue :='N';
2077:
2078: END IF;
2079:

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

2078: END IF;
2079:
2080: IF p_end_date IS NULL THEN
2081: hr_utility.set_location( l_proc,120);
2082: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2083: fnd_message.set_token('TOKEN','End Date');
2084:
2085: l_retvalue :='N';
2086: END IF;

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

2079:
2080: IF p_end_date IS NULL THEN
2081: hr_utility.set_location( l_proc,120);
2082: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2083: fnd_message.set_token('TOKEN','End Date');
2084:
2085: l_retvalue :='N';
2086: END IF;
2087: IF p_claimed_mileage IS NULL THEN

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

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

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

2086: END IF;
2087: IF p_claimed_mileage IS NULL THEN
2088: hr_utility.set_location( l_proc,130);
2089: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2090: fnd_message.set_token('TOKEN','Claimed Mileage');
2091: l_retvalue :='N';
2092:
2093: END IF;
2094:

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

2094:
2095:
2096: IF p_engine_capacity IS NULL THEN
2097: hr_utility.set_location( l_proc,140);
2098: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2099: fnd_message.set_token('TOKEN','Engine Capacity');
2100: l_retvalue :='N';
2101: END IF;
2102:

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

2095:
2096: IF p_engine_capacity IS NULL THEN
2097: hr_utility.set_location( l_proc,140);
2098: fnd_message.set_name('PQP', 'PQP_230734_FLD_MANDTRY');
2099: fnd_message.set_token('TOKEN','Engine Capacity');
2100: l_retvalue :='N';
2101: END IF;
2102:
2103: IF p_element_type_id IS NULL THEN

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

2102:
2103: IF p_element_type_id IS NULL THEN
2104: hr_utility.set_location( l_proc,150);
2105:
2106: fnd_message.set_name('PQP', 'PQP_230732_VLD_MLG_ELE_FAIL');
2107: l_retvalue :='N';
2108: END IF;
2109:
2110: IF FND_DATE.CHARDT_TO_DATE(p_end_date) <

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

2109:
2110: IF FND_DATE.CHARDT_TO_DATE(p_end_date) <
2111: FND_DATE.CHARDT_TO_DATE(p_start_date) THEN
2112: hr_utility.set_location( l_proc,160);
2113: fnd_message.set_name('PER','HR_289262_ST_DATE_BEFORE_EDATE');
2114: l_retvalue :='N';
2115: END IF;
2116:
2117: --RETURN('Y');

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

2215: (l_get_config_info.prev_tax_yr_valid||
2216: TO_CHAR(p_effective_date,'YYYY'))
2217: THEN
2218: --Error handling missing
2219: fnd_message.set_name('PQP', 'PQP_230715_CLM_CUT_OFF_DT');
2220: p_message :='Violated Valid Tax Year';
2221:
2222: l_retvalue :='N';
2223: END IF;

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

2241: END LOOP;
2242: CLOSE c_validate_veh;
2243:
2244: IF l_validate_veh.exst IS NULL THEN
2245: fnd_message.set_name('PQP', 'PQP_230735_REGNUM_FRM_REP');
2246: p_message:='Enter Only Vehicle in Repository';
2247:
2248: l_retvalue :='N';
2249: END IF;

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

2262:
2263: END LOOP;
2264: CLOSE c_get_alloc_info;
2265: IF l_get_alloc_info.ownership<>p_ownership THEN
2266: fnd_message.set_name('PQP', 'PQP_230740_ONE_OWNRSHP_RSTRICT');
2267: p_message :='Enter Only one type of Claim';
2268: l_retvalue :='N';
2269: END IF;
2270: END IF;