200: IF cur_form%NOTFOUND THEN
201: CLOSE cur_form;
202: IF p_template_item_id is not null THEN
203: -- error message - invalid template item id
204: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
205: fnd_message.set_token('PROCEDURE ', l_proc);
206: fnd_message.set_token('STEP ', '10');
207: fnd_message.raise_error;
208: ELSIF p_form_item_id is not null THEN
201: CLOSE cur_form;
202: IF p_template_item_id is not null THEN
203: -- error message - invalid template item id
204: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
205: fnd_message.set_token('PROCEDURE ', l_proc);
206: fnd_message.set_token('STEP ', '10');
207: fnd_message.raise_error;
208: ELSIF p_form_item_id is not null THEN
209: -- error message - invalid form item id
202: IF p_template_item_id is not null THEN
203: -- error message - invalid template item id
204: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
205: fnd_message.set_token('PROCEDURE ', l_proc);
206: fnd_message.set_token('STEP ', '10');
207: fnd_message.raise_error;
208: ELSIF p_form_item_id is not null THEN
209: -- error message - invalid form item id
210: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
203: -- error message - invalid template item id
204: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
205: fnd_message.set_token('PROCEDURE ', l_proc);
206: fnd_message.set_token('STEP ', '10');
207: fnd_message.raise_error;
208: ELSIF p_form_item_id is not null THEN
209: -- error message - invalid form item id
210: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
211: fnd_message.set_token('PROCEDURE ', l_proc);
206: fnd_message.set_token('STEP ', '10');
207: fnd_message.raise_error;
208: ELSIF p_form_item_id is not null THEN
209: -- error message - invalid form item id
210: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
211: fnd_message.set_token('PROCEDURE ', l_proc);
212: fnd_message.set_token('STEP ', '20');
213: fnd_message.raise_error;
214: ELSIF p_template_item_context_id is not null THEN
207: fnd_message.raise_error;
208: ELSIF p_form_item_id is not null THEN
209: -- error message - invalid form item id
210: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
211: fnd_message.set_token('PROCEDURE ', l_proc);
212: fnd_message.set_token('STEP ', '20');
213: fnd_message.raise_error;
214: ELSIF p_template_item_context_id is not null THEN
215: -- error message - invalid template item context id
208: ELSIF p_form_item_id is not null THEN
209: -- error message - invalid form item id
210: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
211: fnd_message.set_token('PROCEDURE ', l_proc);
212: fnd_message.set_token('STEP ', '20');
213: fnd_message.raise_error;
214: ELSIF p_template_item_context_id is not null THEN
215: -- error message - invalid template item context id
216: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
209: -- error message - invalid form item id
210: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
211: fnd_message.set_token('PROCEDURE ', l_proc);
212: fnd_message.set_token('STEP ', '20');
213: fnd_message.raise_error;
214: ELSIF p_template_item_context_id is not null THEN
215: -- error message - invalid template item context id
216: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
217: fnd_message.set_token('PROCEDURE ', l_proc);
212: fnd_message.set_token('STEP ', '20');
213: fnd_message.raise_error;
214: ELSIF p_template_item_context_id is not null THEN
215: -- error message - invalid template item context id
216: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
217: fnd_message.set_token('PROCEDURE ', l_proc);
218: fnd_message.set_token('STEP ', '30');
219: fnd_message.raise_error;
220: END IF;
213: fnd_message.raise_error;
214: ELSIF p_template_item_context_id is not null THEN
215: -- error message - invalid template item context id
216: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
217: fnd_message.set_token('PROCEDURE ', l_proc);
218: fnd_message.set_token('STEP ', '30');
219: fnd_message.raise_error;
220: END IF;
221: END IF;
214: ELSIF p_template_item_context_id is not null THEN
215: -- error message - invalid template item context id
216: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
217: fnd_message.set_token('PROCEDURE ', l_proc);
218: fnd_message.set_token('STEP ', '30');
219: fnd_message.raise_error;
220: END IF;
221: END IF;
222: CLOSE cur_form;
215: -- error message - invalid template item context id
216: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
217: fnd_message.set_token('PROCEDURE ', l_proc);
218: fnd_message.set_token('STEP ', '30');
219: fnd_message.raise_error;
220: END IF;
221: END IF;
222: CLOSE cur_form;
223: END IF;
233: FETCH cur_item into l_prev_form_id;
234: IF cur_item%NOTFOUND THEN
235: CLOSE cur_item;
236: -- error message - invalid previous navigation item id
237: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
238: fnd_message.set_token('PROCEDURE ', l_proc);
239: fnd_message.set_token('STEP ', '40');
240: fnd_message.raise_error;
241: END IF;
234: IF cur_item%NOTFOUND THEN
235: CLOSE cur_item;
236: -- error message - invalid previous navigation item id
237: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
238: fnd_message.set_token('PROCEDURE ', l_proc);
239: fnd_message.set_token('STEP ', '40');
240: fnd_message.raise_error;
241: END IF;
242: CLOSE cur_item;
235: CLOSE cur_item;
236: -- error message - invalid previous navigation item id
237: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
238: fnd_message.set_token('PROCEDURE ', l_proc);
239: fnd_message.set_token('STEP ', '40');
240: fnd_message.raise_error;
241: END IF;
242: CLOSE cur_item;
243:
236: -- error message - invalid previous navigation item id
237: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
238: fnd_message.set_token('PROCEDURE ', l_proc);
239: fnd_message.set_token('STEP ', '40');
240: fnd_message.raise_error;
241: END IF;
242: CLOSE cur_item;
243:
244: IF l_prev_form_id <> l_form_id THEN
243:
244: IF l_prev_form_id <> l_form_id THEN
245: -- error message - previous navigation item id is not on the same form
246: -- as the item for which the item property is being created/amended
247: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
248: fnd_message.set_token('PROCEDURE ', l_proc);
249: fnd_message.set_token('STEP ', '50');
250: fnd_message.raise_error;
251: END IF;
244: IF l_prev_form_id <> l_form_id THEN
245: -- error message - previous navigation item id is not on the same form
246: -- as the item for which the item property is being created/amended
247: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
248: fnd_message.set_token('PROCEDURE ', l_proc);
249: fnd_message.set_token('STEP ', '50');
250: fnd_message.raise_error;
251: END IF;
252:
245: -- error message - previous navigation item id is not on the same form
246: -- as the item for which the item property is being created/amended
247: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
248: fnd_message.set_token('PROCEDURE ', l_proc);
249: fnd_message.set_token('STEP ', '50');
250: fnd_message.raise_error;
251: END IF;
252:
253: end if;
246: -- as the item for which the item property is being created/amended
247: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
248: fnd_message.set_token('PROCEDURE ', l_proc);
249: fnd_message.set_token('STEP ', '50');
250: fnd_message.raise_error;
251: END IF;
252:
253: end if;
254:
265: FETCH cur_item into l_next_form_id;
266: IF cur_item%NOTFOUND THEN
267: CLOSE cur_item;
268: -- error message - invalid next navigation item id
269: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
270: fnd_message.set_token('PROCEDURE ', l_proc);
271: fnd_message.set_token('STEP ', '60');
272: fnd_message.raise_error;
273: END IF;
266: IF cur_item%NOTFOUND THEN
267: CLOSE cur_item;
268: -- error message - invalid next navigation item id
269: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
270: fnd_message.set_token('PROCEDURE ', l_proc);
271: fnd_message.set_token('STEP ', '60');
272: fnd_message.raise_error;
273: END IF;
274: CLOSE cur_item;
267: CLOSE cur_item;
268: -- error message - invalid next navigation item id
269: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
270: fnd_message.set_token('PROCEDURE ', l_proc);
271: fnd_message.set_token('STEP ', '60');
272: fnd_message.raise_error;
273: END IF;
274: CLOSE cur_item;
275:
268: -- error message - invalid next navigation item id
269: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
270: fnd_message.set_token('PROCEDURE ', l_proc);
271: fnd_message.set_token('STEP ', '60');
272: fnd_message.raise_error;
273: END IF;
274: CLOSE cur_item;
275:
276: IF l_next_form_id <> l_form_id THEN
275:
276: IF l_next_form_id <> l_form_id THEN
277: -- error message - next item id is not on the same form
278: -- as the item for which the item property is being created/amended
279: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
280: fnd_message.set_token('PROCEDURE ', l_proc);
281: fnd_message.set_token('STEP ', '70');
282: fnd_message.raise_error;
283: END IF;
276: IF l_next_form_id <> l_form_id THEN
277: -- error message - next item id is not on the same form
278: -- as the item for which the item property is being created/amended
279: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
280: fnd_message.set_token('PROCEDURE ', l_proc);
281: fnd_message.set_token('STEP ', '70');
282: fnd_message.raise_error;
283: END IF;
284:
277: -- error message - next item id is not on the same form
278: -- as the item for which the item property is being created/amended
279: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
280: fnd_message.set_token('PROCEDURE ', l_proc);
281: fnd_message.set_token('STEP ', '70');
282: fnd_message.raise_error;
283: END IF;
284:
285: end if;
278: -- as the item for which the item property is being created/amended
279: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
280: fnd_message.set_token('PROCEDURE ', l_proc);
281: fnd_message.set_token('STEP ', '70');
282: fnd_message.raise_error;
283: END IF;
284:
285: end if;
286: --
355: --
356: -- The form item id is invalid therefore we must error
357: --
358: close csr_form_item;
359: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
360: fnd_message.set_token('PROCEDURE ', l_proc);
361: fnd_message.set_token('STEP ', '10');
362: fnd_message.raise_error;
363: end if;
356: -- The form item id is invalid therefore we must error
357: --
358: close csr_form_item;
359: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
360: fnd_message.set_token('PROCEDURE ', l_proc);
361: fnd_message.set_token('STEP ', '10');
362: fnd_message.raise_error;
363: end if;
364: hr_utility.set_location(l_proc,30);
357: --
358: close csr_form_item;
359: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
360: fnd_message.set_token('PROCEDURE ', l_proc);
361: fnd_message.set_token('STEP ', '10');
362: fnd_message.raise_error;
363: end if;
364: hr_utility.set_location(l_proc,30);
365: close csr_form_item;
358: close csr_form_item;
359: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
360: fnd_message.set_token('PROCEDURE ', l_proc);
361: fnd_message.set_token('STEP ', '10');
362: fnd_message.raise_error;
363: end if;
364: hr_utility.set_location(l_proc,30);
365: close csr_form_item;
366: --
373: --
374: -- The template item id is invalid therefore we must error
375: --
376: close csr_template_item;
377: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
378: fnd_message.set_token('PROCEDURE ', l_proc);
379: fnd_message.set_token('STEP ', '20');
380: fnd_message.raise_error;
381: end if;
374: -- The template item id is invalid therefore we must error
375: --
376: close csr_template_item;
377: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
378: fnd_message.set_token('PROCEDURE ', l_proc);
379: fnd_message.set_token('STEP ', '20');
380: fnd_message.raise_error;
381: end if;
382: hr_utility.set_location(l_proc,40);
375: --
376: close csr_template_item;
377: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
378: fnd_message.set_token('PROCEDURE ', l_proc);
379: fnd_message.set_token('STEP ', '20');
380: fnd_message.raise_error;
381: end if;
382: hr_utility.set_location(l_proc,40);
383: close csr_template_item;
376: close csr_template_item;
377: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
378: fnd_message.set_token('PROCEDURE ', l_proc);
379: fnd_message.set_token('STEP ', '20');
380: fnd_message.raise_error;
381: end if;
382: hr_utility.set_location(l_proc,40);
383: close csr_template_item;
384: --
391: --
392: -- The template item context id is invalid therefore we must error
393: --
394: close csr_template_item_context;
395: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
396: fnd_message.set_token('PROCEDURE ', l_proc);
397: fnd_message.set_token('STEP ', '30');
398: fnd_message.raise_error;
399: end if;
392: -- The template item context id is invalid therefore we must error
393: --
394: close csr_template_item_context;
395: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
396: fnd_message.set_token('PROCEDURE ', l_proc);
397: fnd_message.set_token('STEP ', '30');
398: fnd_message.raise_error;
399: end if;
400: hr_utility.set_location(l_proc,50);
393: --
394: close csr_template_item_context;
395: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
396: fnd_message.set_token('PROCEDURE ', l_proc);
397: fnd_message.set_token('STEP ', '30');
398: fnd_message.raise_error;
399: end if;
400: hr_utility.set_location(l_proc,50);
401: close csr_template_item_context;
394: close csr_template_item_context;
395: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
396: fnd_message.set_token('PROCEDURE ', l_proc);
397: fnd_message.set_token('STEP ', '30');
398: fnd_message.raise_error;
399: end if;
400: hr_utility.set_location(l_proc,50);
401: close csr_template_item_context;
402: --
652: IF NOT hr_itp_shd.api_updating
653: (p_item_property_id => p_rec.item_property_id
654: ,p_object_version_number => p_rec.object_version_number
655: ) THEN
656: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
657: fnd_message.set_token('PROCEDURE ', l_proc);
658: fnd_message.set_token('STEP ', '5');
659: fnd_message.raise_error;
660: END IF;
653: (p_item_property_id => p_rec.item_property_id
654: ,p_object_version_number => p_rec.object_version_number
655: ) THEN
656: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
657: fnd_message.set_token('PROCEDURE ', l_proc);
658: fnd_message.set_token('STEP ', '5');
659: fnd_message.raise_error;
660: END IF;
661: --
654: ,p_object_version_number => p_rec.object_version_number
655: ) THEN
656: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
657: fnd_message.set_token('PROCEDURE ', l_proc);
658: fnd_message.set_token('STEP ', '5');
659: fnd_message.raise_error;
660: END IF;
661: --
662: IF (nvl(p_rec.form_item_id,hr_api.g_number) <>
655: ) THEN
656: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
657: fnd_message.set_token('PROCEDURE ', l_proc);
658: fnd_message.set_token('STEP ', '5');
659: fnd_message.raise_error;
660: END IF;
661: --
662: IF (nvl(p_rec.form_item_id,hr_api.g_number) <>
663: nvl(hr_itp_shd.g_old_rec.form_item_id,hr_api.g_number)
717: and p_template_item_context_id is null)
718: or ( p_form_item_id is null
719: and p_template_item_id is null
720: and p_template_item_context_id is not null)) then
721: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
722: fnd_message.set_token('PROCEDURE', l_proc);
723: fnd_message.set_token('STEP','10');
724: fnd_message.raise_error;
725: end if;
718: or ( p_form_item_id is null
719: and p_template_item_id is null
720: and p_template_item_context_id is not null)) then
721: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
722: fnd_message.set_token('PROCEDURE', l_proc);
723: fnd_message.set_token('STEP','10');
724: fnd_message.raise_error;
725: end if;
726: --
719: and p_template_item_id is null
720: and p_template_item_context_id is not null)) then
721: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
722: fnd_message.set_token('PROCEDURE', l_proc);
723: fnd_message.set_token('STEP','10');
724: fnd_message.raise_error;
725: end if;
726: --
727: hr_utility.set_location('Leaving:'||l_proc, 100);
720: and p_template_item_context_id is not null)) then
721: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
722: fnd_message.set_token('PROCEDURE', l_proc);
723: fnd_message.set_token('STEP','10');
724: fnd_message.raise_error;
725: end if;
726: --
727: hr_utility.set_location('Leaving:'||l_proc, 100);
728: End chk_form_template_and_context;
843: (p_effective_date => p_effective_date
844: ,p_lookup_type => 'ALIGNMENTS'
845: ,p_lookup_code => p_alignment
846: ) then
847: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
848: fnd_message.set_token('PROCEDURE', l_proc);
849: fnd_message.set_token('STEP','10');
850: fnd_message.raise_error;
851: end if;
844: ,p_lookup_type => 'ALIGNMENTS'
845: ,p_lookup_code => p_alignment
846: ) then
847: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
848: fnd_message.set_token('PROCEDURE', l_proc);
849: fnd_message.set_token('STEP','10');
850: fnd_message.raise_error;
851: end if;
852: --
845: ,p_lookup_code => p_alignment
846: ) then
847: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
848: fnd_message.set_token('PROCEDURE', l_proc);
849: fnd_message.set_token('STEP','10');
850: fnd_message.raise_error;
851: end if;
852: --
853: end if;
846: ) then
847: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
848: fnd_message.set_token('PROCEDURE', l_proc);
849: fnd_message.set_token('STEP','10');
850: fnd_message.raise_error;
851: end if;
852: --
853: end if;
854: --
907: (p_effective_date => p_effective_date
908: ,p_lookup_type => 'BORDER_BEVELS'
909: ,p_lookup_code => p_bevel
910: ) then
911: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
912: fnd_message.set_token('PROCEDURE', l_proc);
913: fnd_message.set_token('STEP','10');
914: fnd_message.raise_error;
915: end if;
908: ,p_lookup_type => 'BORDER_BEVELS'
909: ,p_lookup_code => p_bevel
910: ) then
911: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
912: fnd_message.set_token('PROCEDURE', l_proc);
913: fnd_message.set_token('STEP','10');
914: fnd_message.raise_error;
915: end if;
916: --
909: ,p_lookup_code => p_bevel
910: ) then
911: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
912: fnd_message.set_token('PROCEDURE', l_proc);
913: fnd_message.set_token('STEP','10');
914: fnd_message.raise_error;
915: end if;
916: --
917: end if;
910: ) then
911: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
912: fnd_message.set_token('PROCEDURE', l_proc);
913: fnd_message.set_token('STEP','10');
914: fnd_message.raise_error;
915: end if;
916: --
917: end if;
918: --
971: (p_effective_date => p_effective_date
972: ,p_lookup_type => 'CASE_RESTRICTIONS'
973: ,p_lookup_code => p_case_restriction
974: ) then
975: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
976: fnd_message.set_token('PROCEDURE', l_proc);
977: fnd_message.set_token('STEP','10');
978: fnd_message.raise_error;
979: end if;
972: ,p_lookup_type => 'CASE_RESTRICTIONS'
973: ,p_lookup_code => p_case_restriction
974: ) then
975: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
976: fnd_message.set_token('PROCEDURE', l_proc);
977: fnd_message.set_token('STEP','10');
978: fnd_message.raise_error;
979: end if;
980: --
973: ,p_lookup_code => p_case_restriction
974: ) then
975: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
976: fnd_message.set_token('PROCEDURE', l_proc);
977: fnd_message.set_token('STEP','10');
978: fnd_message.raise_error;
979: end if;
980: --
981: end if;
974: ) then
975: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
976: fnd_message.set_token('PROCEDURE', l_proc);
977: fnd_message.set_token('STEP','10');
978: fnd_message.raise_error;
979: end if;
980: --
981: end if;
982: --
1035: (p_effective_date => p_effective_date
1036: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
1037: ,p_lookup_code => p_enabled
1038: ) then
1039: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1040: fnd_message.set_token('PROCEDURE', l_proc);
1041: fnd_message.set_token('STEP','10');
1042: fnd_message.raise_error;
1043: end if;
1036: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
1037: ,p_lookup_code => p_enabled
1038: ) then
1039: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1040: fnd_message.set_token('PROCEDURE', l_proc);
1041: fnd_message.set_token('STEP','10');
1042: fnd_message.raise_error;
1043: end if;
1044: --
1037: ,p_lookup_code => p_enabled
1038: ) then
1039: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1040: fnd_message.set_token('PROCEDURE', l_proc);
1041: fnd_message.set_token('STEP','10');
1042: fnd_message.raise_error;
1043: end if;
1044: --
1045: end if;
1038: ) then
1039: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1040: fnd_message.set_token('PROCEDURE', l_proc);
1041: fnd_message.set_token('STEP','10');
1042: fnd_message.raise_error;
1043: end if;
1044: --
1045: end if;
1046: --
1092: --
1093: hr_utility.set_location(l_proc,30);
1094: --
1095: if (p_height < 0) then
1096: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1097: fnd_message.set_token('PROCEDURE', l_proc);
1098: fnd_message.set_token('STEP','10');
1099: fnd_message.raise_error;
1100: end if;
1093: hr_utility.set_location(l_proc,30);
1094: --
1095: if (p_height < 0) then
1096: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1097: fnd_message.set_token('PROCEDURE', l_proc);
1098: fnd_message.set_token('STEP','10');
1099: fnd_message.raise_error;
1100: end if;
1101: --
1094: --
1095: if (p_height < 0) then
1096: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1097: fnd_message.set_token('PROCEDURE', l_proc);
1098: fnd_message.set_token('STEP','10');
1099: fnd_message.raise_error;
1100: end if;
1101: --
1102: end if;
1095: if (p_height < 0) then
1096: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1097: fnd_message.set_token('PROCEDURE', l_proc);
1098: fnd_message.set_token('STEP','10');
1099: fnd_message.raise_error;
1100: end if;
1101: --
1102: end if;
1103: --
1148: open csr_formula;
1149: fetch csr_formula into l_formula_type_name;
1150: if csr_formula%notfound then
1151: close csr_formula;
1152: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1153: fnd_message.set_token('PROCEDURE', l_proc);
1154: fnd_message.set_token('STEP','10');
1155: fnd_message.raise_error;
1156: end if;
1149: fetch csr_formula into l_formula_type_name;
1150: if csr_formula%notfound then
1151: close csr_formula;
1152: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1153: fnd_message.set_token('PROCEDURE', l_proc);
1154: fnd_message.set_token('STEP','10');
1155: fnd_message.raise_error;
1156: end if;
1157: close csr_formula;
1150: if csr_formula%notfound then
1151: close csr_formula;
1152: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1153: fnd_message.set_token('PROCEDURE', l_proc);
1154: fnd_message.set_token('STEP','10');
1155: fnd_message.raise_error;
1156: end if;
1157: close csr_formula;
1158: --
1151: close csr_formula;
1152: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1153: fnd_message.set_token('PROCEDURE', l_proc);
1154: fnd_message.set_token('STEP','10');
1155: fnd_message.raise_error;
1156: end if;
1157: close csr_formula;
1158: --
1159: -- Check formula is of type 'Template Information' if specified
1158: --
1159: -- Check formula is of type 'Template Information' if specified
1160: --
1161: if nvl(l_formula_type_name,hr_api.g_varchar2) <> 'Template Information' then
1162: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1163: fnd_message.set_token('PROCEDURE', l_proc);
1164: fnd_message.set_token('STEP','20');
1165: fnd_message.raise_error;
1166: end if;
1159: -- Check formula is of type 'Template Information' if specified
1160: --
1161: if nvl(l_formula_type_name,hr_api.g_varchar2) <> 'Template Information' then
1162: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1163: fnd_message.set_token('PROCEDURE', l_proc);
1164: fnd_message.set_token('STEP','20');
1165: fnd_message.raise_error;
1166: end if;
1167: --
1160: --
1161: if nvl(l_formula_type_name,hr_api.g_varchar2) <> 'Template Information' then
1162: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1163: fnd_message.set_token('PROCEDURE', l_proc);
1164: fnd_message.set_token('STEP','20');
1165: fnd_message.raise_error;
1166: end if;
1167: --
1168: end if;
1161: if nvl(l_formula_type_name,hr_api.g_varchar2) <> 'Template Information' then
1162: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1163: fnd_message.set_token('PROCEDURE', l_proc);
1164: fnd_message.set_token('STEP','20');
1165: fnd_message.raise_error;
1166: end if;
1167: --
1168: end if;
1169: --
1199: or p_information_param_item_id2 is not null
1200: or p_information_param_item_id3 is not null
1201: or p_information_param_item_id4 is not null
1202: or p_information_param_item_id5 is not null) then
1203: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1204: fnd_message.set_token('PROCEDURE', l_proc);
1205: fnd_message.set_token('STEP','10');
1206: fnd_message.raise_error;
1207: end if;
1200: or p_information_param_item_id3 is not null
1201: or p_information_param_item_id4 is not null
1202: or p_information_param_item_id5 is not null) then
1203: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1204: fnd_message.set_token('PROCEDURE', l_proc);
1205: fnd_message.set_token('STEP','10');
1206: fnd_message.raise_error;
1207: end if;
1208: end if;
1201: or p_information_param_item_id4 is not null
1202: or p_information_param_item_id5 is not null) then
1203: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1204: fnd_message.set_token('PROCEDURE', l_proc);
1205: fnd_message.set_token('STEP','10');
1206: fnd_message.raise_error;
1207: end if;
1208: end if;
1209: --
1202: or p_information_param_item_id5 is not null) then
1203: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1204: fnd_message.set_token('PROCEDURE', l_proc);
1205: fnd_message.set_token('STEP','10');
1206: fnd_message.raise_error;
1207: end if;
1208: end if;
1209: --
1210: hr_utility.set_location('Leaving:'||l_proc, 100);
1260: (p_effective_date => p_effective_date
1261: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
1262: ,p_lookup_code => p_insert_allowed
1263: ) then
1264: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1265: fnd_message.set_token('PROCEDURE', l_proc);
1266: fnd_message.set_token('STEP','10');
1267: fnd_message.raise_error;
1268: end if;
1261: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
1262: ,p_lookup_code => p_insert_allowed
1263: ) then
1264: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1265: fnd_message.set_token('PROCEDURE', l_proc);
1266: fnd_message.set_token('STEP','10');
1267: fnd_message.raise_error;
1268: end if;
1269: --
1262: ,p_lookup_code => p_insert_allowed
1263: ) then
1264: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1265: fnd_message.set_token('PROCEDURE', l_proc);
1266: fnd_message.set_token('STEP','10');
1267: fnd_message.raise_error;
1268: end if;
1269: --
1270: end if;
1263: ) then
1264: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1265: fnd_message.set_token('PROCEDURE', l_proc);
1266: fnd_message.set_token('STEP','10');
1267: fnd_message.raise_error;
1268: end if;
1269: --
1270: end if;
1271: --
1342: (p_effective_date => p_effective_date
1343: ,p_lookup_type => 'PROMPT_DISPLAY_STYLES'
1344: ,p_lookup_code => p_prompt_display_style
1345: ) then
1346: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1347: fnd_message.set_token('PROCEDURE', l_proc);
1348: fnd_message.set_token('STEP','10');
1349: fnd_message.raise_error;
1350: end if;
1343: ,p_lookup_type => 'PROMPT_DISPLAY_STYLES'
1344: ,p_lookup_code => p_prompt_display_style
1345: ) then
1346: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1347: fnd_message.set_token('PROCEDURE', l_proc);
1348: fnd_message.set_token('STEP','10');
1349: fnd_message.raise_error;
1350: end if;
1351: --
1344: ,p_lookup_code => p_prompt_display_style
1345: ) then
1346: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1347: fnd_message.set_token('PROCEDURE', l_proc);
1348: fnd_message.set_token('STEP','10');
1349: fnd_message.raise_error;
1350: end if;
1351: --
1352: end if;
1345: ) then
1346: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1347: fnd_message.set_token('PROCEDURE', l_proc);
1348: fnd_message.set_token('STEP','10');
1349: fnd_message.raise_error;
1350: end if;
1351: --
1352: end if;
1353: --
1406: (p_effective_date => p_effective_date
1407: ,p_lookup_type => 'PROMPT_EDGES'
1408: ,p_lookup_code => p_prompt_edge
1409: ) then
1410: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1411: fnd_message.set_token('PROCEDURE', l_proc);
1412: fnd_message.set_token('STEP','10');
1413: fnd_message.raise_error;
1414: end if;
1407: ,p_lookup_type => 'PROMPT_EDGES'
1408: ,p_lookup_code => p_prompt_edge
1409: ) then
1410: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1411: fnd_message.set_token('PROCEDURE', l_proc);
1412: fnd_message.set_token('STEP','10');
1413: fnd_message.raise_error;
1414: end if;
1415: --
1408: ,p_lookup_code => p_prompt_edge
1409: ) then
1410: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1411: fnd_message.set_token('PROCEDURE', l_proc);
1412: fnd_message.set_token('STEP','10');
1413: fnd_message.raise_error;
1414: end if;
1415: --
1416: end if;
1409: ) then
1410: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1411: fnd_message.set_token('PROCEDURE', l_proc);
1412: fnd_message.set_token('STEP','10');
1413: fnd_message.raise_error;
1414: end if;
1415: --
1416: end if;
1417: --
1470: (p_effective_date => p_effective_date
1471: ,p_lookup_type => 'PROMPT_EDGE_ALIGNMENTS'
1472: ,p_lookup_code => p_prompt_edge_alignment
1473: ) then
1474: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1475: fnd_message.set_token('PROCEDURE', l_proc);
1476: fnd_message.set_token('STEP','10');
1477: fnd_message.raise_error;
1478: end if;
1471: ,p_lookup_type => 'PROMPT_EDGE_ALIGNMENTS'
1472: ,p_lookup_code => p_prompt_edge_alignment
1473: ) then
1474: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1475: fnd_message.set_token('PROCEDURE', l_proc);
1476: fnd_message.set_token('STEP','10');
1477: fnd_message.raise_error;
1478: end if;
1479: --
1472: ,p_lookup_code => p_prompt_edge_alignment
1473: ) then
1474: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1475: fnd_message.set_token('PROCEDURE', l_proc);
1476: fnd_message.set_token('STEP','10');
1477: fnd_message.raise_error;
1478: end if;
1479: --
1480: end if;
1473: ) then
1474: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1475: fnd_message.set_token('PROCEDURE', l_proc);
1476: fnd_message.set_token('STEP','10');
1477: fnd_message.raise_error;
1478: end if;
1479: --
1480: end if;
1481: --
1552: (p_effective_date => p_effective_date
1553: ,p_lookup_type => 'PROMPT_TEXT_ALIGNMENTS'
1554: ,p_lookup_code => p_prompt_text_alignment
1555: ) then
1556: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1557: fnd_message.set_token('PROCEDURE', l_proc);
1558: fnd_message.set_token('STEP','10');
1559: fnd_message.raise_error;
1560: end if;
1553: ,p_lookup_type => 'PROMPT_TEXT_ALIGNMENTS'
1554: ,p_lookup_code => p_prompt_text_alignment
1555: ) then
1556: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1557: fnd_message.set_token('PROCEDURE', l_proc);
1558: fnd_message.set_token('STEP','10');
1559: fnd_message.raise_error;
1560: end if;
1561: --
1554: ,p_lookup_code => p_prompt_text_alignment
1555: ) then
1556: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1557: fnd_message.set_token('PROCEDURE', l_proc);
1558: fnd_message.set_token('STEP','10');
1559: fnd_message.raise_error;
1560: end if;
1561: --
1562: end if;
1555: ) then
1556: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1557: fnd_message.set_token('PROCEDURE', l_proc);
1558: fnd_message.set_token('STEP','10');
1559: fnd_message.raise_error;
1560: end if;
1561: --
1562: end if;
1563: --
1616: (p_effective_date => p_effective_date
1617: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
1618: ,p_lookup_code => p_query_allowed
1619: ) then
1620: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1621: fnd_message.set_token('PROCEDURE', l_proc);
1622: fnd_message.set_token('STEP','10');
1623: fnd_message.raise_error;
1624: end if;
1617: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
1618: ,p_lookup_code => p_query_allowed
1619: ) then
1620: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1621: fnd_message.set_token('PROCEDURE', l_proc);
1622: fnd_message.set_token('STEP','10');
1623: fnd_message.raise_error;
1624: end if;
1625: --
1618: ,p_lookup_code => p_query_allowed
1619: ) then
1620: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1621: fnd_message.set_token('PROCEDURE', l_proc);
1622: fnd_message.set_token('STEP','10');
1623: fnd_message.raise_error;
1624: end if;
1625: --
1626: end if;
1619: ) then
1620: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1621: fnd_message.set_token('PROCEDURE', l_proc);
1622: fnd_message.set_token('STEP','10');
1623: fnd_message.raise_error;
1624: end if;
1625: --
1626: end if;
1627: --
1680: (p_effective_date => p_effective_date
1681: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
1682: ,p_lookup_code => p_required
1683: ) then
1684: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1685: fnd_message.set_token('PROCEDURE', l_proc);
1686: fnd_message.set_token('STEP','10');
1687: fnd_message.raise_error;
1688: end if;
1681: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
1682: ,p_lookup_code => p_required
1683: ) then
1684: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1685: fnd_message.set_token('PROCEDURE', l_proc);
1686: fnd_message.set_token('STEP','10');
1687: fnd_message.raise_error;
1688: end if;
1689: --
1682: ,p_lookup_code => p_required
1683: ) then
1684: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1685: fnd_message.set_token('PROCEDURE', l_proc);
1686: fnd_message.set_token('STEP','10');
1687: fnd_message.raise_error;
1688: end if;
1689: --
1690: end if;
1683: ) then
1684: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1685: fnd_message.set_token('PROCEDURE', l_proc);
1686: fnd_message.set_token('STEP','10');
1687: fnd_message.raise_error;
1688: end if;
1689: --
1690: end if;
1691: --
1744: (p_effective_date => p_effective_date
1745: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
1746: ,p_lookup_code => p_update_allowed
1747: ) then
1748: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1749: fnd_message.set_token('PROCEDURE', l_proc);
1750: fnd_message.set_token('STEP','10');
1751: fnd_message.raise_error;
1752: end if;
1745: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
1746: ,p_lookup_code => p_update_allowed
1747: ) then
1748: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1749: fnd_message.set_token('PROCEDURE', l_proc);
1750: fnd_message.set_token('STEP','10');
1751: fnd_message.raise_error;
1752: end if;
1753: --
1746: ,p_lookup_code => p_update_allowed
1747: ) then
1748: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1749: fnd_message.set_token('PROCEDURE', l_proc);
1750: fnd_message.set_token('STEP','10');
1751: fnd_message.raise_error;
1752: end if;
1753: --
1754: end if;
1747: ) then
1748: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1749: fnd_message.set_token('PROCEDURE', l_proc);
1750: fnd_message.set_token('STEP','10');
1751: fnd_message.raise_error;
1752: end if;
1753: --
1754: end if;
1755: --
1802: open csr_formula;
1803: fetch csr_formula into l_formula_type_name;
1804: if csr_formula%notfound then
1805: close csr_formula;
1806: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1807: fnd_message.set_token('PROCEDURE', l_proc);
1808: fnd_message.set_token('STEP','10');
1809: fnd_message.raise_error;
1810: end if;
1803: fetch csr_formula into l_formula_type_name;
1804: if csr_formula%notfound then
1805: close csr_formula;
1806: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1807: fnd_message.set_token('PROCEDURE', l_proc);
1808: fnd_message.set_token('STEP','10');
1809: fnd_message.raise_error;
1810: end if;
1811: close csr_formula;
1804: if csr_formula%notfound then
1805: close csr_formula;
1806: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1807: fnd_message.set_token('PROCEDURE', l_proc);
1808: fnd_message.set_token('STEP','10');
1809: fnd_message.raise_error;
1810: end if;
1811: close csr_formula;
1812: --
1805: close csr_formula;
1806: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1807: fnd_message.set_token('PROCEDURE', l_proc);
1808: fnd_message.set_token('STEP','10');
1809: fnd_message.raise_error;
1810: end if;
1811: close csr_formula;
1812: --
1813: -- Check formula is of type 'Template Validation' if specified
1812: --
1813: -- Check formula is of type 'Template Validation' if specified
1814: --
1815: if nvl(l_formula_type_name,hr_api.g_varchar2) <> 'Template Validation' then
1816: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1817: fnd_message.set_token('PROCEDURE', l_proc);
1818: fnd_message.set_token('STEP','20');
1819: fnd_message.raise_error;
1820: end if;
1813: -- Check formula is of type 'Template Validation' if specified
1814: --
1815: if nvl(l_formula_type_name,hr_api.g_varchar2) <> 'Template Validation' then
1816: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1817: fnd_message.set_token('PROCEDURE', l_proc);
1818: fnd_message.set_token('STEP','20');
1819: fnd_message.raise_error;
1820: end if;
1821: --
1814: --
1815: if nvl(l_formula_type_name,hr_api.g_varchar2) <> 'Template Validation' then
1816: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1817: fnd_message.set_token('PROCEDURE', l_proc);
1818: fnd_message.set_token('STEP','20');
1819: fnd_message.raise_error;
1820: end if;
1821: --
1822: end if;
1815: if nvl(l_formula_type_name,hr_api.g_varchar2) <> 'Template Validation' then
1816: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1817: fnd_message.set_token('PROCEDURE', l_proc);
1818: fnd_message.set_token('STEP','20');
1819: fnd_message.raise_error;
1820: end if;
1821: --
1822: end if;
1823: --
1853: or p_validation_param_item_id2 is not null
1854: or p_validation_param_item_id3 is not null
1855: or p_validation_param_item_id4 is not null
1856: or p_validation_param_item_id5 is not null) then
1857: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1858: fnd_message.set_token('PROCEDURE', l_proc);
1859: fnd_message.set_token('STEP','10');
1860: fnd_message.raise_error;
1861: end if;
1854: or p_validation_param_item_id3 is not null
1855: or p_validation_param_item_id4 is not null
1856: or p_validation_param_item_id5 is not null) then
1857: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1858: fnd_message.set_token('PROCEDURE', l_proc);
1859: fnd_message.set_token('STEP','10');
1860: fnd_message.raise_error;
1861: end if;
1862: end if;
1855: or p_validation_param_item_id4 is not null
1856: or p_validation_param_item_id5 is not null) then
1857: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1858: fnd_message.set_token('PROCEDURE', l_proc);
1859: fnd_message.set_token('STEP','10');
1860: fnd_message.raise_error;
1861: end if;
1862: end if;
1863: --
1856: or p_validation_param_item_id5 is not null) then
1857: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1858: fnd_message.set_token('PROCEDURE', l_proc);
1859: fnd_message.set_token('STEP','10');
1860: fnd_message.raise_error;
1861: end if;
1862: end if;
1863: --
1864: hr_utility.set_location('Leaving:'||l_proc, 100);
1914: (p_effective_date => p_effective_date
1915: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
1916: ,p_lookup_code => p_visible
1917: ) then
1918: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1919: fnd_message.set_token('PROCEDURE', l_proc);
1920: fnd_message.set_token('STEP','10');
1921: fnd_message.raise_error;
1922: end if;
1915: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
1916: ,p_lookup_code => p_visible
1917: ) then
1918: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1919: fnd_message.set_token('PROCEDURE', l_proc);
1920: fnd_message.set_token('STEP','10');
1921: fnd_message.raise_error;
1922: end if;
1923: --
1916: ,p_lookup_code => p_visible
1917: ) then
1918: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1919: fnd_message.set_token('PROCEDURE', l_proc);
1920: fnd_message.set_token('STEP','10');
1921: fnd_message.raise_error;
1922: end if;
1923: --
1924: end if;
1917: ) then
1918: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1919: fnd_message.set_token('PROCEDURE', l_proc);
1920: fnd_message.set_token('STEP','10');
1921: fnd_message.raise_error;
1922: end if;
1923: --
1924: end if;
1925: --
1949: --
1950: hr_utility.set_location(l_proc,30);
1951: --
1952: if (p_width < 0) then
1953: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1954: fnd_message.set_token('PROCEDURE', l_proc);
1955: fnd_message.set_token('STEP','10');
1956: fnd_message.raise_error;
1957: end if;
1950: hr_utility.set_location(l_proc,30);
1951: --
1952: if (p_width < 0) then
1953: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1954: fnd_message.set_token('PROCEDURE', l_proc);
1955: fnd_message.set_token('STEP','10');
1956: fnd_message.raise_error;
1957: end if;
1958: --
1951: --
1952: if (p_width < 0) then
1953: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1954: fnd_message.set_token('PROCEDURE', l_proc);
1955: fnd_message.set_token('STEP','10');
1956: fnd_message.raise_error;
1957: end if;
1958: --
1959: end if;
1952: if (p_width < 0) then
1953: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1954: fnd_message.set_token('PROCEDURE', l_proc);
1955: fnd_message.set_token('STEP','10');
1956: fnd_message.raise_error;
1957: end if;
1958: --
1959: end if;
1960: --
1982: --
1983: hr_utility.set_location(l_proc,30);
1984: --
1985: if (p_x_position < 0) then
1986: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1987: fnd_message.set_token('PROCEDURE', l_proc);
1988: fnd_message.set_token('STEP','10');
1989: fnd_message.raise_error;
1990: end if;
1983: hr_utility.set_location(l_proc,30);
1984: --
1985: if (p_x_position < 0) then
1986: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1987: fnd_message.set_token('PROCEDURE', l_proc);
1988: fnd_message.set_token('STEP','10');
1989: fnd_message.raise_error;
1990: end if;
1991: --
1984: --
1985: if (p_x_position < 0) then
1986: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1987: fnd_message.set_token('PROCEDURE', l_proc);
1988: fnd_message.set_token('STEP','10');
1989: fnd_message.raise_error;
1990: end if;
1991: --
1992: end if;
1985: if (p_x_position < 0) then
1986: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1987: fnd_message.set_token('PROCEDURE', l_proc);
1988: fnd_message.set_token('STEP','10');
1989: fnd_message.raise_error;
1990: end if;
1991: --
1992: end if;
1993: --
2015: --
2016: hr_utility.set_location(l_proc,30);
2017: --
2018: if (p_y_position < 0) then
2019: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2020: fnd_message.set_token('PROCEDURE', l_proc);
2021: fnd_message.set_token('STEP','10');
2022: fnd_message.raise_error;
2023: end if;
2016: hr_utility.set_location(l_proc,30);
2017: --
2018: if (p_y_position < 0) then
2019: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2020: fnd_message.set_token('PROCEDURE', l_proc);
2021: fnd_message.set_token('STEP','10');
2022: fnd_message.raise_error;
2023: end if;
2024: --
2017: --
2018: if (p_y_position < 0) then
2019: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2020: fnd_message.set_token('PROCEDURE', l_proc);
2021: fnd_message.set_token('STEP','10');
2022: fnd_message.raise_error;
2023: end if;
2024: --
2025: end if;
2018: if (p_y_position < 0) then
2019: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2020: fnd_message.set_token('PROCEDURE', l_proc);
2021: fnd_message.set_token('STEP','10');
2022: fnd_message.raise_error;
2023: end if;
2024: --
2025: end if;
2026: --
2050: hr_utility.set_location(l_proc,20);
2051: --
2052: if p_rec.alignment is not null then
2053: if l_item_type not in ('DISPLAY_ITEM','TEXT_ITEM') then
2054: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2055: fnd_message.set_token('PROCEDURE', l_proc);
2056: fnd_message.set_token('STEP','10');
2057: fnd_message.raise_error;
2058: end if;
2051: --
2052: if p_rec.alignment is not null then
2053: if l_item_type not in ('DISPLAY_ITEM','TEXT_ITEM') then
2054: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2055: fnd_message.set_token('PROCEDURE', l_proc);
2056: fnd_message.set_token('STEP','10');
2057: fnd_message.raise_error;
2058: end if;
2059: end if;
2052: if p_rec.alignment is not null then
2053: if l_item_type not in ('DISPLAY_ITEM','TEXT_ITEM') then
2054: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2055: fnd_message.set_token('PROCEDURE', l_proc);
2056: fnd_message.set_token('STEP','10');
2057: fnd_message.raise_error;
2058: end if;
2059: end if;
2060: hr_utility.set_location(l_proc,30);
2053: if l_item_type not in ('DISPLAY_ITEM','TEXT_ITEM') then
2054: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2055: fnd_message.set_token('PROCEDURE', l_proc);
2056: fnd_message.set_token('STEP','10');
2057: fnd_message.raise_error;
2058: end if;
2059: end if;
2060: hr_utility.set_location(l_proc,30);
2061: --
2060: hr_utility.set_location(l_proc,30);
2061: --
2062: if p_rec.bevel is not null then
2063: if l_item_type not in ('CHART_ITEM','USER_AREA','IMAGE','TEXT_ITEM') then
2064: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2065: fnd_message.set_token('PROCEDURE', l_proc);
2066: fnd_message.set_token('STEP','20');
2067: fnd_message.raise_error;
2068: end if;
2061: --
2062: if p_rec.bevel is not null then
2063: if l_item_type not in ('CHART_ITEM','USER_AREA','IMAGE','TEXT_ITEM') then
2064: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2065: fnd_message.set_token('PROCEDURE', l_proc);
2066: fnd_message.set_token('STEP','20');
2067: fnd_message.raise_error;
2068: end if;
2069: end if;
2062: if p_rec.bevel is not null then
2063: if l_item_type not in ('CHART_ITEM','USER_AREA','IMAGE','TEXT_ITEM') then
2064: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2065: fnd_message.set_token('PROCEDURE', l_proc);
2066: fnd_message.set_token('STEP','20');
2067: fnd_message.raise_error;
2068: end if;
2069: end if;
2070: hr_utility.set_location(l_proc,40);
2063: if l_item_type not in ('CHART_ITEM','USER_AREA','IMAGE','TEXT_ITEM') then
2064: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2065: fnd_message.set_token('PROCEDURE', l_proc);
2066: fnd_message.set_token('STEP','20');
2067: fnd_message.raise_error;
2068: end if;
2069: end if;
2070: hr_utility.set_location(l_proc,40);
2071: --
2070: hr_utility.set_location(l_proc,40);
2071: --
2072: if p_rec.case_restriction is not null then
2073: if l_item_type not in ('TEXT_ITEM') then
2074: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2075: fnd_message.set_token('PROCEDURE', l_proc);
2076: fnd_message.set_token('STEP','30');
2077: fnd_message.raise_error;
2078: end if;
2071: --
2072: if p_rec.case_restriction is not null then
2073: if l_item_type not in ('TEXT_ITEM') then
2074: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2075: fnd_message.set_token('PROCEDURE', l_proc);
2076: fnd_message.set_token('STEP','30');
2077: fnd_message.raise_error;
2078: end if;
2079: end if;
2072: if p_rec.case_restriction is not null then
2073: if l_item_type not in ('TEXT_ITEM') then
2074: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2075: fnd_message.set_token('PROCEDURE', l_proc);
2076: fnd_message.set_token('STEP','30');
2077: fnd_message.raise_error;
2078: end if;
2079: end if;
2080: hr_utility.set_location(l_proc,50);
2073: if l_item_type not in ('TEXT_ITEM') then
2074: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2075: fnd_message.set_token('PROCEDURE', l_proc);
2076: fnd_message.set_token('STEP','30');
2077: fnd_message.raise_error;
2078: end if;
2079: end if;
2080: hr_utility.set_location(l_proc,50);
2081: --
2080: hr_utility.set_location(l_proc,50);
2081: --
2082: if p_rec.enabled is not null then
2083: if l_item_type not in ('BUTTON','CHECKBOX','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2084: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2085: fnd_message.set_token('PROCEDURE', l_proc);
2086: fnd_message.set_token('STEP','40');
2087: fnd_message.raise_error;
2088: end if;
2081: --
2082: if p_rec.enabled is not null then
2083: if l_item_type not in ('BUTTON','CHECKBOX','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2084: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2085: fnd_message.set_token('PROCEDURE', l_proc);
2086: fnd_message.set_token('STEP','40');
2087: fnd_message.raise_error;
2088: end if;
2089: end if;
2082: if p_rec.enabled is not null then
2083: if l_item_type not in ('BUTTON','CHECKBOX','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2084: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2085: fnd_message.set_token('PROCEDURE', l_proc);
2086: fnd_message.set_token('STEP','40');
2087: fnd_message.raise_error;
2088: end if;
2089: end if;
2090: hr_utility.set_location(l_proc,60);
2083: if l_item_type not in ('BUTTON','CHECKBOX','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2084: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2085: fnd_message.set_token('PROCEDURE', l_proc);
2086: fnd_message.set_token('STEP','40');
2087: fnd_message.raise_error;
2088: end if;
2089: end if;
2090: hr_utility.set_location(l_proc,60);
2091: --
2090: hr_utility.set_location(l_proc,60);
2091: --
2092: if p_rec.format_mask is not null then
2093: if l_item_type not in ('TEXT_ITEM') then
2094: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2095: fnd_message.set_token('PROCEDURE', l_proc);
2096: fnd_message.set_token('STEP','50');
2097: fnd_message.raise_error;
2098: end if;
2091: --
2092: if p_rec.format_mask is not null then
2093: if l_item_type not in ('TEXT_ITEM') then
2094: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2095: fnd_message.set_token('PROCEDURE', l_proc);
2096: fnd_message.set_token('STEP','50');
2097: fnd_message.raise_error;
2098: end if;
2099: end if;
2092: if p_rec.format_mask is not null then
2093: if l_item_type not in ('TEXT_ITEM') then
2094: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2095: fnd_message.set_token('PROCEDURE', l_proc);
2096: fnd_message.set_token('STEP','50');
2097: fnd_message.raise_error;
2098: end if;
2099: end if;
2100: hr_utility.set_location(l_proc,70);
2093: if l_item_type not in ('TEXT_ITEM') then
2094: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2095: fnd_message.set_token('PROCEDURE', l_proc);
2096: fnd_message.set_token('STEP','50');
2097: fnd_message.raise_error;
2098: end if;
2099: end if;
2100: hr_utility.set_location(l_proc,70);
2101: --
2100: hr_utility.set_location(l_proc,70);
2101: --
2102: if p_rec.height is not null then
2103: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2104: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2105: fnd_message.set_token('PROCEDURE', l_proc);
2106: fnd_message.set_token('STEP','53');
2107: fnd_message.raise_error;
2108: end if;
2101: --
2102: if p_rec.height is not null then
2103: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2104: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2105: fnd_message.set_token('PROCEDURE', l_proc);
2106: fnd_message.set_token('STEP','53');
2107: fnd_message.raise_error;
2108: end if;
2109: end if;
2102: if p_rec.height is not null then
2103: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2104: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2105: fnd_message.set_token('PROCEDURE', l_proc);
2106: fnd_message.set_token('STEP','53');
2107: fnd_message.raise_error;
2108: end if;
2109: end if;
2110: hr_utility.set_location(l_proc,73);
2103: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2104: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2105: fnd_message.set_token('PROCEDURE', l_proc);
2106: fnd_message.set_token('STEP','53');
2107: fnd_message.raise_error;
2108: end if;
2109: end if;
2110: hr_utility.set_location(l_proc,73);
2111: --
2110: hr_utility.set_location(l_proc,73);
2111: --
2112: if p_rec.information_formula_id is not null then
2113: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2114: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2115: fnd_message.set_token('PROCEDURE', l_proc);
2116: fnd_message.set_token('STEP','56');
2117: fnd_message.raise_error;
2118: end if;
2111: --
2112: if p_rec.information_formula_id is not null then
2113: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2114: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2115: fnd_message.set_token('PROCEDURE', l_proc);
2116: fnd_message.set_token('STEP','56');
2117: fnd_message.raise_error;
2118: end if;
2119: end if;
2112: if p_rec.information_formula_id is not null then
2113: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2114: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2115: fnd_message.set_token('PROCEDURE', l_proc);
2116: fnd_message.set_token('STEP','56');
2117: fnd_message.raise_error;
2118: end if;
2119: end if;
2120: hr_utility.set_location(l_proc,76);
2113: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2114: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2115: fnd_message.set_token('PROCEDURE', l_proc);
2116: fnd_message.set_token('STEP','56');
2117: fnd_message.raise_error;
2118: end if;
2119: end if;
2120: hr_utility.set_location(l_proc,76);
2121: --
2120: hr_utility.set_location(l_proc,76);
2121: --
2122: if p_rec.insert_allowed is not null then
2123: if l_item_type not in ('CHECKBOX','IMAGE','LIST','RADIO_BUTTON','TEXT_ITEM') then
2124: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2125: fnd_message.set_token('PROCEDURE', l_proc);
2126: fnd_message.set_token('STEP','60');
2127: fnd_message.raise_error;
2128: end if;
2121: --
2122: if p_rec.insert_allowed is not null then
2123: if l_item_type not in ('CHECKBOX','IMAGE','LIST','RADIO_BUTTON','TEXT_ITEM') then
2124: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2125: fnd_message.set_token('PROCEDURE', l_proc);
2126: fnd_message.set_token('STEP','60');
2127: fnd_message.raise_error;
2128: end if;
2129: end if;
2122: if p_rec.insert_allowed is not null then
2123: if l_item_type not in ('CHECKBOX','IMAGE','LIST','RADIO_BUTTON','TEXT_ITEM') then
2124: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2125: fnd_message.set_token('PROCEDURE', l_proc);
2126: fnd_message.set_token('STEP','60');
2127: fnd_message.raise_error;
2128: end if;
2129: end if;
2130: hr_utility.set_location(l_proc,80);
2123: if l_item_type not in ('CHECKBOX','IMAGE','LIST','RADIO_BUTTON','TEXT_ITEM') then
2124: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2125: fnd_message.set_token('PROCEDURE', l_proc);
2126: fnd_message.set_token('STEP','60');
2127: fnd_message.raise_error;
2128: end if;
2129: end if;
2130: hr_utility.set_location(l_proc,80);
2131: --
2130: hr_utility.set_location(l_proc,80);
2131: --
2132: if p_rec.next_navigation_item_id is not null then
2133: if l_item_type not in ('BUTTON','CHECKBOX','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2134: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2135: fnd_message.set_token('PROCEDURE', l_proc);
2136: fnd_message.set_token('STEP','61');
2137: fnd_message.raise_error;
2138: end if;
2131: --
2132: if p_rec.next_navigation_item_id is not null then
2133: if l_item_type not in ('BUTTON','CHECKBOX','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2134: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2135: fnd_message.set_token('PROCEDURE', l_proc);
2136: fnd_message.set_token('STEP','61');
2137: fnd_message.raise_error;
2138: end if;
2139: end if;
2132: if p_rec.next_navigation_item_id is not null then
2133: if l_item_type not in ('BUTTON','CHECKBOX','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2134: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2135: fnd_message.set_token('PROCEDURE', l_proc);
2136: fnd_message.set_token('STEP','61');
2137: fnd_message.raise_error;
2138: end if;
2139: end if;
2140: hr_utility.set_location(l_proc,81);
2133: if l_item_type not in ('BUTTON','CHECKBOX','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2134: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2135: fnd_message.set_token('PROCEDURE', l_proc);
2136: fnd_message.set_token('STEP','61');
2137: fnd_message.raise_error;
2138: end if;
2139: end if;
2140: hr_utility.set_location(l_proc,81);
2141: --
2140: hr_utility.set_location(l_proc,81);
2141: --
2142: if p_rec.previous_navigation_item_id is not null then
2143: if l_item_type not in ('BUTTON','CHECKBOX','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2144: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2145: fnd_message.set_token('PROCEDURE', l_proc);
2146: fnd_message.set_token('STEP','62');
2147: fnd_message.raise_error;
2148: end if;
2141: --
2142: if p_rec.previous_navigation_item_id is not null then
2143: if l_item_type not in ('BUTTON','CHECKBOX','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2144: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2145: fnd_message.set_token('PROCEDURE', l_proc);
2146: fnd_message.set_token('STEP','62');
2147: fnd_message.raise_error;
2148: end if;
2149: end if;
2142: if p_rec.previous_navigation_item_id is not null then
2143: if l_item_type not in ('BUTTON','CHECKBOX','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2144: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2145: fnd_message.set_token('PROCEDURE', l_proc);
2146: fnd_message.set_token('STEP','62');
2147: fnd_message.raise_error;
2148: end if;
2149: end if;
2150: hr_utility.set_location(l_proc,82);
2143: if l_item_type not in ('BUTTON','CHECKBOX','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2144: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2145: fnd_message.set_token('PROCEDURE', l_proc);
2146: fnd_message.set_token('STEP','62');
2147: fnd_message.raise_error;
2148: end if;
2149: end if;
2150: hr_utility.set_location(l_proc,82);
2151: --
2150: hr_utility.set_location(l_proc,82);
2151: --
2152: if p_rec.prompt_alignment_offset is not null then
2153: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2154: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2155: fnd_message.set_token('PROCEDURE', l_proc);
2156: fnd_message.set_token('STEP','63');
2157: fnd_message.raise_error;
2158: end if;
2151: --
2152: if p_rec.prompt_alignment_offset is not null then
2153: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2154: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2155: fnd_message.set_token('PROCEDURE', l_proc);
2156: fnd_message.set_token('STEP','63');
2157: fnd_message.raise_error;
2158: end if;
2159: end if;
2152: if p_rec.prompt_alignment_offset is not null then
2153: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2154: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2155: fnd_message.set_token('PROCEDURE', l_proc);
2156: fnd_message.set_token('STEP','63');
2157: fnd_message.raise_error;
2158: end if;
2159: end if;
2160: hr_utility.set_location(l_proc,83);
2153: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2154: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2155: fnd_message.set_token('PROCEDURE', l_proc);
2156: fnd_message.set_token('STEP','63');
2157: fnd_message.raise_error;
2158: end if;
2159: end if;
2160: hr_utility.set_location(l_proc,83);
2161: --
2160: hr_utility.set_location(l_proc,83);
2161: --
2162: if p_rec.prompt_display_style is not null then
2163: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2164: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2165: fnd_message.set_token('PROCEDURE', l_proc);
2166: fnd_message.set_token('STEP','64');
2167: fnd_message.raise_error;
2168: end if;
2161: --
2162: if p_rec.prompt_display_style is not null then
2163: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2164: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2165: fnd_message.set_token('PROCEDURE', l_proc);
2166: fnd_message.set_token('STEP','64');
2167: fnd_message.raise_error;
2168: end if;
2169: end if;
2162: if p_rec.prompt_display_style is not null then
2163: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2164: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2165: fnd_message.set_token('PROCEDURE', l_proc);
2166: fnd_message.set_token('STEP','64');
2167: fnd_message.raise_error;
2168: end if;
2169: end if;
2170: hr_utility.set_location(l_proc,84);
2163: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2164: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2165: fnd_message.set_token('PROCEDURE', l_proc);
2166: fnd_message.set_token('STEP','64');
2167: fnd_message.raise_error;
2168: end if;
2169: end if;
2170: hr_utility.set_location(l_proc,84);
2171: --
2170: hr_utility.set_location(l_proc,84);
2171: --
2172: if p_rec.prompt_edge is not null then
2173: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2174: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2175: fnd_message.set_token('PROCEDURE', l_proc);
2176: fnd_message.set_token('STEP','65');
2177: fnd_message.raise_error;
2178: end if;
2171: --
2172: if p_rec.prompt_edge is not null then
2173: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2174: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2175: fnd_message.set_token('PROCEDURE', l_proc);
2176: fnd_message.set_token('STEP','65');
2177: fnd_message.raise_error;
2178: end if;
2179: end if;
2172: if p_rec.prompt_edge is not null then
2173: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2174: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2175: fnd_message.set_token('PROCEDURE', l_proc);
2176: fnd_message.set_token('STEP','65');
2177: fnd_message.raise_error;
2178: end if;
2179: end if;
2180: hr_utility.set_location(l_proc,85);
2173: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2174: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2175: fnd_message.set_token('PROCEDURE', l_proc);
2176: fnd_message.set_token('STEP','65');
2177: fnd_message.raise_error;
2178: end if;
2179: end if;
2180: hr_utility.set_location(l_proc,85);
2181: --
2180: hr_utility.set_location(l_proc,85);
2181: --
2182: if p_rec.prompt_edge_alignment is not null then
2183: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2184: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2185: fnd_message.set_token('PROCEDURE', l_proc);
2186: fnd_message.set_token('STEP','66');
2187: fnd_message.raise_error;
2188: end if;
2181: --
2182: if p_rec.prompt_edge_alignment is not null then
2183: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2184: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2185: fnd_message.set_token('PROCEDURE', l_proc);
2186: fnd_message.set_token('STEP','66');
2187: fnd_message.raise_error;
2188: end if;
2189: end if;
2182: if p_rec.prompt_edge_alignment is not null then
2183: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2184: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2185: fnd_message.set_token('PROCEDURE', l_proc);
2186: fnd_message.set_token('STEP','66');
2187: fnd_message.raise_error;
2188: end if;
2189: end if;
2190: hr_utility.set_location(l_proc,86);
2183: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2184: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2185: fnd_message.set_token('PROCEDURE', l_proc);
2186: fnd_message.set_token('STEP','66');
2187: fnd_message.raise_error;
2188: end if;
2189: end if;
2190: hr_utility.set_location(l_proc,86);
2191: --
2190: hr_utility.set_location(l_proc,86);
2191: --
2192: if p_rec.prompt_edge_offset is not null then
2193: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2194: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2195: fnd_message.set_token('PROCEDURE', l_proc);
2196: fnd_message.set_token('STEP','67');
2197: fnd_message.raise_error;
2198: end if;
2191: --
2192: if p_rec.prompt_edge_offset is not null then
2193: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2194: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2195: fnd_message.set_token('PROCEDURE', l_proc);
2196: fnd_message.set_token('STEP','67');
2197: fnd_message.raise_error;
2198: end if;
2199: end if;
2192: if p_rec.prompt_edge_offset is not null then
2193: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2194: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2195: fnd_message.set_token('PROCEDURE', l_proc);
2196: fnd_message.set_token('STEP','67');
2197: fnd_message.raise_error;
2198: end if;
2199: end if;
2200: hr_utility.set_location(l_proc,87);
2193: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2194: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2195: fnd_message.set_token('PROCEDURE', l_proc);
2196: fnd_message.set_token('STEP','67');
2197: fnd_message.raise_error;
2198: end if;
2199: end if;
2200: hr_utility.set_location(l_proc,87);
2201: --
2200: hr_utility.set_location(l_proc,87);
2201: --
2202: if p_rec.prompt_text_alignment is not null then
2203: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2204: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2205: fnd_message.set_token('PROCEDURE', l_proc);
2206: fnd_message.set_token('STEP','68');
2207: fnd_message.raise_error;
2208: end if;
2201: --
2202: if p_rec.prompt_text_alignment is not null then
2203: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2204: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2205: fnd_message.set_token('PROCEDURE', l_proc);
2206: fnd_message.set_token('STEP','68');
2207: fnd_message.raise_error;
2208: end if;
2209: end if;
2202: if p_rec.prompt_text_alignment is not null then
2203: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2204: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2205: fnd_message.set_token('PROCEDURE', l_proc);
2206: fnd_message.set_token('STEP','68');
2207: fnd_message.raise_error;
2208: end if;
2209: end if;
2210: hr_utility.set_location(l_proc,88);
2203: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2204: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2205: fnd_message.set_token('PROCEDURE', l_proc);
2206: fnd_message.set_token('STEP','68');
2207: fnd_message.raise_error;
2208: end if;
2209: end if;
2210: hr_utility.set_location(l_proc,88);
2211: --
2210: hr_utility.set_location(l_proc,88);
2211: --
2212: if p_rec.query_allowed is not null then
2213: if l_item_type not in ('CHECKBOX','DISPLAY_ITEM','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2214: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2215: fnd_message.set_token('PROCEDURE', l_proc);
2216: fnd_message.set_token('STEP','70');
2217: fnd_message.raise_error;
2218: end if;
2211: --
2212: if p_rec.query_allowed is not null then
2213: if l_item_type not in ('CHECKBOX','DISPLAY_ITEM','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2214: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2215: fnd_message.set_token('PROCEDURE', l_proc);
2216: fnd_message.set_token('STEP','70');
2217: fnd_message.raise_error;
2218: end if;
2219: end if;
2212: if p_rec.query_allowed is not null then
2213: if l_item_type not in ('CHECKBOX','DISPLAY_ITEM','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2214: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2215: fnd_message.set_token('PROCEDURE', l_proc);
2216: fnd_message.set_token('STEP','70');
2217: fnd_message.raise_error;
2218: end if;
2219: end if;
2220: hr_utility.set_location(l_proc,90);
2213: if l_item_type not in ('CHECKBOX','DISPLAY_ITEM','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2214: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2215: fnd_message.set_token('PROCEDURE', l_proc);
2216: fnd_message.set_token('STEP','70');
2217: fnd_message.raise_error;
2218: end if;
2219: end if;
2220: hr_utility.set_location(l_proc,90);
2221: --
2220: hr_utility.set_location(l_proc,90);
2221: --
2222: if p_rec.required is not null then
2223: if l_item_type not in ('CHECKBOX','LIST','TEXT_ITEM') then
2224: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2225: fnd_message.set_token('PROCEDURE', l_proc);
2226: fnd_message.set_token('STEP','80');
2227: fnd_message.raise_error;
2228: end if;
2221: --
2222: if p_rec.required is not null then
2223: if l_item_type not in ('CHECKBOX','LIST','TEXT_ITEM') then
2224: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2225: fnd_message.set_token('PROCEDURE', l_proc);
2226: fnd_message.set_token('STEP','80');
2227: fnd_message.raise_error;
2228: end if;
2229: end if;
2222: if p_rec.required is not null then
2223: if l_item_type not in ('CHECKBOX','LIST','TEXT_ITEM') then
2224: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2225: fnd_message.set_token('PROCEDURE', l_proc);
2226: fnd_message.set_token('STEP','80');
2227: fnd_message.raise_error;
2228: end if;
2229: end if;
2230: hr_utility.set_location(l_proc,100);
2223: if l_item_type not in ('CHECKBOX','LIST','TEXT_ITEM') then
2224: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2225: fnd_message.set_token('PROCEDURE', l_proc);
2226: fnd_message.set_token('STEP','80');
2227: fnd_message.raise_error;
2228: end if;
2229: end if;
2230: hr_utility.set_location(l_proc,100);
2231: --
2230: hr_utility.set_location(l_proc,100);
2231: --
2232: if p_rec.update_allowed is not null then
2233: if l_item_type not in ('CHECKBOX','DISPLAY_ITEM','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2234: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2235: fnd_message.set_token('PROCEDURE', l_proc);
2236: fnd_message.set_token('STEP','90');
2237: fnd_message.raise_error;
2238: end if;
2231: --
2232: if p_rec.update_allowed is not null then
2233: if l_item_type not in ('CHECKBOX','DISPLAY_ITEM','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2234: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2235: fnd_message.set_token('PROCEDURE', l_proc);
2236: fnd_message.set_token('STEP','90');
2237: fnd_message.raise_error;
2238: end if;
2239: end if;
2232: if p_rec.update_allowed is not null then
2233: if l_item_type not in ('CHECKBOX','DISPLAY_ITEM','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2234: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2235: fnd_message.set_token('PROCEDURE', l_proc);
2236: fnd_message.set_token('STEP','90');
2237: fnd_message.raise_error;
2238: end if;
2239: end if;
2240: hr_utility.set_location(l_proc,110);
2233: if l_item_type not in ('CHECKBOX','DISPLAY_ITEM','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2234: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2235: fnd_message.set_token('PROCEDURE', l_proc);
2236: fnd_message.set_token('STEP','90');
2237: fnd_message.raise_error;
2238: end if;
2239: end if;
2240: hr_utility.set_location(l_proc,110);
2241: --
2240: hr_utility.set_location(l_proc,110);
2241: --
2242: if p_rec.validation_formula_id is not null then
2243: if l_item_type not in ('CHECKBOX','DISPLAY_ITEM','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2244: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2245: fnd_message.set_token('PROCEDURE', l_proc);
2246: fnd_message.set_token('STEP','100');
2247: fnd_message.raise_error;
2248: end if;
2241: --
2242: if p_rec.validation_formula_id is not null then
2243: if l_item_type not in ('CHECKBOX','DISPLAY_ITEM','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2244: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2245: fnd_message.set_token('PROCEDURE', l_proc);
2246: fnd_message.set_token('STEP','100');
2247: fnd_message.raise_error;
2248: end if;
2249: end if;
2242: if p_rec.validation_formula_id is not null then
2243: if l_item_type not in ('CHECKBOX','DISPLAY_ITEM','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2244: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2245: fnd_message.set_token('PROCEDURE', l_proc);
2246: fnd_message.set_token('STEP','100');
2247: fnd_message.raise_error;
2248: end if;
2249: end if;
2250: hr_utility.set_location(l_proc,120);
2243: if l_item_type not in ('CHECKBOX','DISPLAY_ITEM','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2244: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2245: fnd_message.set_token('PROCEDURE', l_proc);
2246: fnd_message.set_token('STEP','100');
2247: fnd_message.raise_error;
2248: end if;
2249: end if;
2250: hr_utility.set_location(l_proc,120);
2251: --
2250: hr_utility.set_location(l_proc,120);
2251: --
2252: if p_rec.visible is not null then
2253: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2254: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2255: fnd_message.set_token('PROCEDURE', l_proc);
2256: fnd_message.set_token('STEP','110');
2257: fnd_message.raise_error;
2258: end if;
2251: --
2252: if p_rec.visible is not null then
2253: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2254: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2255: fnd_message.set_token('PROCEDURE', l_proc);
2256: fnd_message.set_token('STEP','110');
2257: fnd_message.raise_error;
2258: end if;
2259: end if;
2252: if p_rec.visible is not null then
2253: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2254: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2255: fnd_message.set_token('PROCEDURE', l_proc);
2256: fnd_message.set_token('STEP','110');
2257: fnd_message.raise_error;
2258: end if;
2259: end if;
2260: hr_utility.set_location(l_proc,130);
2253: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2254: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2255: fnd_message.set_token('PROCEDURE', l_proc);
2256: fnd_message.set_token('STEP','110');
2257: fnd_message.raise_error;
2258: end if;
2259: end if;
2260: hr_utility.set_location(l_proc,130);
2261: --
2260: hr_utility.set_location(l_proc,130);
2261: --
2262: if p_rec.width is not null then
2263: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2264: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2265: fnd_message.set_token('PROCEDURE', l_proc);
2266: fnd_message.set_token('STEP','120');
2267: fnd_message.raise_error;
2268: end if;
2261: --
2262: if p_rec.width is not null then
2263: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2264: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2265: fnd_message.set_token('PROCEDURE', l_proc);
2266: fnd_message.set_token('STEP','120');
2267: fnd_message.raise_error;
2268: end if;
2269: end if;
2262: if p_rec.width is not null then
2263: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2264: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2265: fnd_message.set_token('PROCEDURE', l_proc);
2266: fnd_message.set_token('STEP','120');
2267: fnd_message.raise_error;
2268: end if;
2269: end if;
2270: hr_utility.set_location(l_proc,140);
2263: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2264: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2265: fnd_message.set_token('PROCEDURE', l_proc);
2266: fnd_message.set_token('STEP','120');
2267: fnd_message.raise_error;
2268: end if;
2269: end if;
2270: hr_utility.set_location(l_proc,140);
2271: --
2270: hr_utility.set_location(l_proc,140);
2271: --
2272: if p_rec.x_position is not null then
2273: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','SCROLLBAR','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2274: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2275: fnd_message.set_token('PROCEDURE', l_proc);
2276: fnd_message.set_token('STEP','130');
2277: fnd_message.raise_error;
2278: end if;
2271: --
2272: if p_rec.x_position is not null then
2273: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','SCROLLBAR','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2274: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2275: fnd_message.set_token('PROCEDURE', l_proc);
2276: fnd_message.set_token('STEP','130');
2277: fnd_message.raise_error;
2278: end if;
2279: end if;
2272: if p_rec.x_position is not null then
2273: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','SCROLLBAR','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2274: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2275: fnd_message.set_token('PROCEDURE', l_proc);
2276: fnd_message.set_token('STEP','130');
2277: fnd_message.raise_error;
2278: end if;
2279: end if;
2280: hr_utility.set_location(l_proc,150);
2273: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','SCROLLBAR','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2274: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2275: fnd_message.set_token('PROCEDURE', l_proc);
2276: fnd_message.set_token('STEP','130');
2277: fnd_message.raise_error;
2278: end if;
2279: end if;
2280: hr_utility.set_location(l_proc,150);
2281: --
2280: hr_utility.set_location(l_proc,150);
2281: --
2282: if p_rec.y_position is not null then
2283: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','SCROLLBAR','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2284: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2285: fnd_message.set_token('PROCEDURE', l_proc);
2286: fnd_message.set_token('STEP','140');
2287: fnd_message.raise_error;
2288: end if;
2281: --
2282: if p_rec.y_position is not null then
2283: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','SCROLLBAR','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2284: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2285: fnd_message.set_token('PROCEDURE', l_proc);
2286: fnd_message.set_token('STEP','140');
2287: fnd_message.raise_error;
2288: end if;
2289: end if;
2282: if p_rec.y_position is not null then
2283: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','SCROLLBAR','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2284: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2285: fnd_message.set_token('PROCEDURE', l_proc);
2286: fnd_message.set_token('STEP','140');
2287: fnd_message.raise_error;
2288: end if;
2289: end if;
2290: hr_utility.set_location(l_proc,160);
2283: if l_item_type not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','SCROLLBAR','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
2284: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2285: fnd_message.set_token('PROCEDURE', l_proc);
2286: fnd_message.set_token('STEP','140');
2287: fnd_message.raise_error;
2288: end if;
2289: end if;
2290: hr_utility.set_location(l_proc,160);
2291: --