134:
135: if csr_time_definition_id%notfound then
136:
137: close csr_time_definition_id;
138: fnd_message.set_name('PAY','PAY_34056_FLSA_INV_TIME_DEF_ID');
139: fnd_message.raise_error;
140:
141: end if;
142:
135: if csr_time_definition_id%notfound then
136:
137: close csr_time_definition_id;
138: fnd_message.set_name('PAY','PAY_34056_FLSA_INV_TIME_DEF_ID');
139: fnd_message.raise_error;
140:
141: end if;
142:
143: close csr_time_definition_id;
230: if csr_usage_type%notfound then
231:
232: close csr_usage_type;
233:
234: fnd_message.set_name('PAY','PAY_34059_FLSA_ARG_INVALID');
235: fnd_message.set_token('ARGUMENT', 'Usage Type');
236: fnd_message.raise_error;
237:
238: end if;
231:
232: close csr_usage_type;
233:
234: fnd_message.set_name('PAY','PAY_34059_FLSA_ARG_INVALID');
235: fnd_message.set_token('ARGUMENT', 'Usage Type');
236: fnd_message.raise_error;
237:
238: end if;
239:
232: close csr_usage_type;
233:
234: fnd_message.set_name('PAY','PAY_34059_FLSA_ARG_INVALID');
235: fnd_message.set_token('ARGUMENT', 'Usage Type');
236: fnd_message.raise_error;
237:
238: end if;
239:
240: close csr_usage_type;
244: close csr_definition_type;
245:
246: if l_definition_type = 'P' and p_usage_type = 'EA' then
247:
248: fnd_message.set_name('PAY','PAY_34063_FLSA_INV_USAGE_TYPE');
249: fnd_message.set_token('USAGE', l_meaning);
250: fnd_message.raise_error;
251:
252: end if;
245:
246: if l_definition_type = 'P' and p_usage_type = 'EA' then
247:
248: fnd_message.set_name('PAY','PAY_34063_FLSA_INV_USAGE_TYPE');
249: fnd_message.set_token('USAGE', l_meaning);
250: fnd_message.raise_error;
251:
252: end if;
253:
246: if l_definition_type = 'P' and p_usage_type = 'EA' then
247:
248: fnd_message.set_name('PAY','PAY_34063_FLSA_INV_USAGE_TYPE');
249: fnd_message.set_token('USAGE', l_meaning);
250: fnd_message.raise_error;
251:
252: end if;
253:
254: if l_definition_type in ('S','E','C') and p_usage_type in ('PP','RS','P') then
252: end if;
253:
254: if l_definition_type in ('S','E','C') and p_usage_type in ('PP','RS','P') then
255:
256: fnd_message.set_name('PAY','PAY_34063_FLSA_INV_USAGE_TYPE');
257: fnd_message.set_token('USAGE', l_meaning);
258: fnd_message.raise_error;
259:
260: end if;
253:
254: if l_definition_type in ('S','E','C') and p_usage_type in ('PP','RS','P') then
255:
256: fnd_message.set_name('PAY','PAY_34063_FLSA_INV_USAGE_TYPE');
257: fnd_message.set_token('USAGE', l_meaning);
258: fnd_message.raise_error;
259:
260: end if;
261:
254: if l_definition_type in ('S','E','C') and p_usage_type in ('PP','RS','P') then
255:
256: fnd_message.set_name('PAY','PAY_34063_FLSA_INV_USAGE_TYPE');
257: fnd_message.set_token('USAGE', l_meaning);
258: fnd_message.raise_error;
259:
260: end if;
261:
262: end if;