DBA Data[Home] [Help]

APPS.PQH_PA_WHATIF_PROCESS dependencies on FND_MESSAGE

Line 163: fnd_message.set_name('BEN','BEN_92540_NOONE_TO_PROCESS_CM');

159: hr_utility.set_location('Number of non OVERRDG LE triggered: ' || to_char(l_non_ovridg_le_count),35);
160: hr_utility.set_location('Leaving: ' || l_proc,40);
161: end if;
162: IF l_ovridg_le_count+l_non_ovridg_le_count=0 THEN
163: fnd_message.set_name('BEN','BEN_92540_NOONE_TO_PROCESS_CM');
164: fnd_message.raise_error;
165: END IF;
166: IF l_ovridg_le_count >1 THEN l_ret_status :=true ;p_flag :='Y';
167: ELSIF l_ovridg_le_count =0 AND l_non_ovridg_le_count>1 THEN l_ret_status :=true ;p_flag :='N';

Line 164: fnd_message.raise_error;

160: hr_utility.set_location('Leaving: ' || l_proc,40);
161: end if;
162: IF l_ovridg_le_count+l_non_ovridg_le_count=0 THEN
163: fnd_message.set_name('BEN','BEN_92540_NOONE_TO_PROCESS_CM');
164: fnd_message.raise_error;
165: END IF;
166: IF l_ovridg_le_count >1 THEN l_ret_status :=true ;p_flag :='Y';
167: ELSIF l_ovridg_le_count =0 AND l_non_ovridg_le_count>1 THEN l_ret_status :=true ;p_flag :='N';
168: END IF;

Line 1650: fnd_message.set_name('BEN', 'BEN_93194_AGE_VALUE_ERROR');

1646: if(l_lf_evt_ocrd_dt < p_rec.hire_date) then
1647: OPEN csr_uom(l_uom);
1648: FETCH csr_uom into l_uom;
1649: CLOSE csr_uom;
1650: fnd_message.set_name('BEN', 'BEN_93194_AGE_VALUE_ERROR');
1651: fnd_message.set_token('AGE',l_age_val);
1652: fnd_message.set_token('UOM',l_uom);
1653: fnd_message.set_token('HIRE_DATE',to_char(p_rec.hire_date,'DD-MM-RRRR'));
1654: fnd_message.set_token('DOB',to_char(l_date,'DD-MM-RRRR'));

Line 1651: fnd_message.set_token('AGE',l_age_val);

1647: OPEN csr_uom(l_uom);
1648: FETCH csr_uom into l_uom;
1649: CLOSE csr_uom;
1650: fnd_message.set_name('BEN', 'BEN_93194_AGE_VALUE_ERROR');
1651: fnd_message.set_token('AGE',l_age_val);
1652: fnd_message.set_token('UOM',l_uom);
1653: fnd_message.set_token('HIRE_DATE',to_char(p_rec.hire_date,'DD-MM-RRRR'));
1654: fnd_message.set_token('DOB',to_char(l_date,'DD-MM-RRRR'));
1655: fnd_message.raise_error;

Line 1652: fnd_message.set_token('UOM',l_uom);

1648: FETCH csr_uom into l_uom;
1649: CLOSE csr_uom;
1650: fnd_message.set_name('BEN', 'BEN_93194_AGE_VALUE_ERROR');
1651: fnd_message.set_token('AGE',l_age_val);
1652: fnd_message.set_token('UOM',l_uom);
1653: fnd_message.set_token('HIRE_DATE',to_char(p_rec.hire_date,'DD-MM-RRRR'));
1654: fnd_message.set_token('DOB',to_char(l_date,'DD-MM-RRRR'));
1655: fnd_message.raise_error;
1656: end if;

Line 1653: fnd_message.set_token('HIRE_DATE',to_char(p_rec.hire_date,'DD-MM-RRRR'));

1649: CLOSE csr_uom;
1650: fnd_message.set_name('BEN', 'BEN_93194_AGE_VALUE_ERROR');
1651: fnd_message.set_token('AGE',l_age_val);
1652: fnd_message.set_token('UOM',l_uom);
1653: fnd_message.set_token('HIRE_DATE',to_char(p_rec.hire_date,'DD-MM-RRRR'));
1654: fnd_message.set_token('DOB',to_char(l_date,'DD-MM-RRRR'));
1655: fnd_message.raise_error;
1656: end if;
1657: END LOOP;

Line 1654: fnd_message.set_token('DOB',to_char(l_date,'DD-MM-RRRR'));

1650: fnd_message.set_name('BEN', 'BEN_93194_AGE_VALUE_ERROR');
1651: fnd_message.set_token('AGE',l_age_val);
1652: fnd_message.set_token('UOM',l_uom);
1653: fnd_message.set_token('HIRE_DATE',to_char(p_rec.hire_date,'DD-MM-RRRR'));
1654: fnd_message.set_token('DOB',to_char(l_date,'DD-MM-RRRR'));
1655: fnd_message.raise_error;
1656: end if;
1657: END LOOP;
1658: ELSIF C1.api_name = 'DRVDLOS' then

Line 1655: fnd_message.raise_error;

1651: fnd_message.set_token('AGE',l_age_val);
1652: fnd_message.set_token('UOM',l_uom);
1653: fnd_message.set_token('HIRE_DATE',to_char(p_rec.hire_date,'DD-MM-RRRR'));
1654: fnd_message.set_token('DOB',to_char(l_date,'DD-MM-RRRR'));
1655: fnd_message.raise_error;
1656: end if;
1657: END LOOP;
1658: ELSIF C1.api_name = 'DRVDLOS' then
1659: l_age_val := C2.number_value;

Line 2104: fnd_message.set_name('PER','HR_52401_PYP_NO_PROPOSED_AMT');

2100: );
2101: ELSIF C1.api_name= 'PER_PAY_PROPOSALS' THEN
2102:
2103: if l_proposed_salary_n is null then
2104: fnd_message.set_name('PER','HR_52401_PYP_NO_PROPOSED_AMT');
2105: fnd_message.raise_error;
2106:
2107: end if;
2108: ben_whatif_elig.WATIF_PAY_PROPOSAL_API(

Line 2105: fnd_message.raise_error;

2101: ELSIF C1.api_name= 'PER_PAY_PROPOSALS' THEN
2102:
2103: if l_proposed_salary_n is null then
2104: fnd_message.set_name('PER','HR_52401_PYP_NO_PROPOSED_AMT');
2105: fnd_message.raise_error;
2106:
2107: end if;
2108: ben_whatif_elig.WATIF_PAY_PROPOSAL_API(
2109: p_person_id => p_person_id

Line 4084: -- fnd_message.set_name('PQH','PQH_PA_WHTF_NO_PTNL_LER');

4080: ,p_effective_date => nvl(l_lf_evt_ocrd_dt,p_effective_date)
4081: ,p_business_group_id => nvl(l_new_business_group_id,p_business_group_id)
4082: ,p_ler_id => p_ler_id);
4083: ELSE
4084: -- fnd_message.set_name('PQH','PQH_PA_WHTF_NO_PTNL_LER');
4085: fnd_message.set_name('BEN','BEN_92540_NOONE_TO_PROCESS_CM');
4086: fnd_message.raise_error;
4087: END IF;
4088:

Line 4085: fnd_message.set_name('BEN','BEN_92540_NOONE_TO_PROCESS_CM');

4081: ,p_business_group_id => nvl(l_new_business_group_id,p_business_group_id)
4082: ,p_ler_id => p_ler_id);
4083: ELSE
4084: -- fnd_message.set_name('PQH','PQH_PA_WHTF_NO_PTNL_LER');
4085: fnd_message.set_name('BEN','BEN_92540_NOONE_TO_PROCESS_CM');
4086: fnd_message.raise_error;
4087: END IF;
4088:
4089:

Line 4086: fnd_message.raise_error;

4082: ,p_ler_id => p_ler_id);
4083: ELSE
4084: -- fnd_message.set_name('PQH','PQH_PA_WHTF_NO_PTNL_LER');
4085: fnd_message.set_name('BEN','BEN_92540_NOONE_TO_PROCESS_CM');
4086: fnd_message.raise_error;
4087: END IF;
4088:
4089:
4090: EXCEPTION