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;
327: THEN
328:
329: CLOSE csr_get_time_category_id;
330:
331: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
332: fnd_message.set_token('PROCEDURE', l_proc);
333: fnd_message.set_token('STEP','PTO Time Category');
334: fnd_message.raise_error;
335:
328:
329: CLOSE csr_get_time_category_id;
330:
331: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
332: fnd_message.set_token('PROCEDURE', l_proc);
333: fnd_message.set_token('STEP','PTO Time Category');
334: fnd_message.raise_error;
335:
336: END IF;
329: CLOSE csr_get_time_category_id;
330:
331: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
332: fnd_message.set_token('PROCEDURE', l_proc);
333: fnd_message.set_token('STEP','PTO Time Category');
334: fnd_message.raise_error;
335:
336: END IF;
337:
330:
331: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
332: fnd_message.set_token('PROCEDURE', l_proc);
333: fnd_message.set_token('STEP','PTO Time Category');
334: fnd_message.raise_error;
335:
336: END IF;
337:
338: WHILE csr_get_time_category_id%FOUND
801:
802: END IF;
803:
804: ELSE
805: fnd_message.set_name('HXC', 'HXC_WTD_INVALID_FORMULA_DDF');
806: fnd_message.set_token('FORMULA', p_rule_rec.formula_name);
807: fnd_message.raise_error;
808: END IF;
809:
802: END IF;
803:
804: ELSE
805: fnd_message.set_name('HXC', 'HXC_WTD_INVALID_FORMULA_DDF');
806: fnd_message.set_token('FORMULA', p_rule_rec.formula_name);
807: fnd_message.raise_error;
808: END IF;
809:
810: END LOOP; -- csr_get_flex_segments
803:
804: ELSE
805: fnd_message.set_name('HXC', 'HXC_WTD_INVALID_FORMULA_DDF');
806: fnd_message.set_token('FORMULA', p_rule_rec.formula_name);
807: fnd_message.raise_error;
808: END IF;
809:
810: END LOOP; -- csr_get_flex_segments
811:
1282: l_param_value := p_param_rec.param15_value;
1283:
1284: ELSE
1285:
1286: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1287: fnd_message.set_token('PROCEDURE', l_proc);
1288: fnd_message.set_token('STEP','Invalid formula param name');
1289: fnd_message.raise_error;
1290:
1283:
1284: ELSE
1285:
1286: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1287: fnd_message.set_token('PROCEDURE', l_proc);
1288: fnd_message.set_token('STEP','Invalid formula param name');
1289: fnd_message.raise_error;
1290:
1291: END IF;
1284: ELSE
1285:
1286: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1287: fnd_message.set_token('PROCEDURE', l_proc);
1288: fnd_message.set_token('STEP','Invalid formula param name');
1289: fnd_message.raise_error;
1290:
1291: END IF;
1292:
1285:
1286: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1287: fnd_message.set_token('PROCEDURE', l_proc);
1288: fnd_message.set_token('STEP','Invalid formula param name');
1289: fnd_message.raise_error;
1290:
1291: END IF;
1292:
1293: RETURN l_param_value;