73: THEN
74:
75: CLOSE csr_get_asg_id;
76:
77: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
78: fnd_message.set_token('PROCEDURE', l_proc);
79: fnd_message.set_token('STEP','assignment context');
80: fnd_message.raise_error;
81:
74:
75: CLOSE csr_get_asg_id;
76:
77: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
78: fnd_message.set_token('PROCEDURE', l_proc);
79: fnd_message.set_token('STEP','assignment context');
80: fnd_message.raise_error;
81:
82: END IF;
75: CLOSE csr_get_asg_id;
76:
77: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
78: fnd_message.set_token('PROCEDURE', l_proc);
79: fnd_message.set_token('STEP','assignment context');
80: fnd_message.raise_error;
81:
82: END IF;
83:
76:
77: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
78: fnd_message.set_token('PROCEDURE', l_proc);
79: fnd_message.set_token('STEP','assignment context');
80: fnd_message.raise_error;
81:
82: END IF;
83:
84: CLOSE csr_get_asg_id;
328: THEN
329:
330: CLOSE csr_get_time_category_id;
331:
332: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
333: fnd_message.set_token('PROCEDURE', l_proc);
334: fnd_message.set_token('STEP','PTO Time Category');
335: fnd_message.raise_error;
336:
329:
330: CLOSE csr_get_time_category_id;
331:
332: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
333: fnd_message.set_token('PROCEDURE', l_proc);
334: fnd_message.set_token('STEP','PTO Time Category');
335: fnd_message.raise_error;
336:
337: END IF;
330: CLOSE csr_get_time_category_id;
331:
332: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
333: fnd_message.set_token('PROCEDURE', l_proc);
334: fnd_message.set_token('STEP','PTO Time Category');
335: fnd_message.raise_error;
336:
337: END IF;
338:
331:
332: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
333: fnd_message.set_token('PROCEDURE', l_proc);
334: fnd_message.set_token('STEP','PTO Time Category');
335: fnd_message.raise_error;
336:
337: END IF;
338:
339: WHILE csr_get_time_category_id%FOUND
802:
803: END IF;
804:
805: ELSE
806: fnd_message.set_name('HXC', 'HXC_WTD_INVALID_FORMULA_DDF');
807: fnd_message.set_token('FORMULA', p_rule_rec.formula_name);
808: fnd_message.raise_error;
809: END IF;
810:
803: END IF;
804:
805: ELSE
806: fnd_message.set_name('HXC', 'HXC_WTD_INVALID_FORMULA_DDF');
807: fnd_message.set_token('FORMULA', p_rule_rec.formula_name);
808: fnd_message.raise_error;
809: END IF;
810:
811: END LOOP; -- csr_get_flex_segments
804:
805: ELSE
806: fnd_message.set_name('HXC', 'HXC_WTD_INVALID_FORMULA_DDF');
807: fnd_message.set_token('FORMULA', p_rule_rec.formula_name);
808: fnd_message.raise_error;
809: END IF;
810:
811: END LOOP; -- csr_get_flex_segments
812:
1283: l_param_value := p_param_rec.param15_value;
1284:
1285: ELSE
1286:
1287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1288: fnd_message.set_token('PROCEDURE', l_proc);
1289: fnd_message.set_token('STEP','Invalid formula param name');
1290: fnd_message.raise_error;
1291:
1284:
1285: ELSE
1286:
1287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1288: fnd_message.set_token('PROCEDURE', l_proc);
1289: fnd_message.set_token('STEP','Invalid formula param name');
1290: fnd_message.raise_error;
1291:
1292: END IF;
1285: ELSE
1286:
1287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1288: fnd_message.set_token('PROCEDURE', l_proc);
1289: fnd_message.set_token('STEP','Invalid formula param name');
1290: fnd_message.raise_error;
1291:
1292: END IF;
1293:
1286:
1287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1288: fnd_message.set_token('PROCEDURE', l_proc);
1289: fnd_message.set_token('STEP','Invalid formula param name');
1290: fnd_message.raise_error;
1291:
1292: END IF;
1293:
1294: RETURN l_param_value;