104: IF NOT hr_ipt_shd.api_updating
105: (p_item_property_id => p_rec.item_property_id
106: ,p_language => p_rec.language
107: ) THEN
108: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE ', l_proc);
110: fnd_message.set_token('STEP ', '5');
111: fnd_message.raise_error;
112: END IF;
105: (p_item_property_id => p_rec.item_property_id
106: ,p_language => p_rec.language
107: ) THEN
108: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE ', l_proc);
110: fnd_message.set_token('STEP ', '5');
111: fnd_message.raise_error;
112: END IF;
113: --
106: ,p_language => p_rec.language
107: ) THEN
108: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE ', l_proc);
110: fnd_message.set_token('STEP ', '5');
111: fnd_message.raise_error;
112: END IF;
113: --
114: -- No non-updateable arguments
107: ) THEN
108: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE ', l_proc);
110: fnd_message.set_token('STEP ', '5');
111: fnd_message.raise_error;
112: END IF;
113: --
114: -- No non-updateable arguments
115: --
173: open csr_language;
174: fetch csr_language into l_installed_flag;
175: if csr_language%notfound then
176: close csr_language;
177: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
178: fnd_message.set_token('PROCEDURE', l_proc);
179: fnd_message.set_token('STEP','10');
180: fnd_message.raise_error;
181: end if;
174: fetch csr_language into l_installed_flag;
175: if csr_language%notfound then
176: close csr_language;
177: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
178: fnd_message.set_token('PROCEDURE', l_proc);
179: fnd_message.set_token('STEP','10');
180: fnd_message.raise_error;
181: end if;
182: close csr_language;
175: if csr_language%notfound then
176: close csr_language;
177: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
178: fnd_message.set_token('PROCEDURE', l_proc);
179: fnd_message.set_token('STEP','10');
180: fnd_message.raise_error;
181: end if;
182: close csr_language;
183: --
176: close csr_language;
177: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
178: fnd_message.set_token('PROCEDURE', l_proc);
179: fnd_message.set_token('STEP','10');
180: fnd_message.raise_error;
181: end if;
182: close csr_language;
183: --
184: /* 1653358: Not necessary
182: close csr_language;
183: --
184: /* 1653358: Not necessary
185: if nvl(l_installed_flag,hr_api.g_varchar2) not in ('I','B') then
186: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
187: fnd_message.set_token('PROCEDURE', l_proc);
188: fnd_message.set_token('STEP','20');
189: fnd_message.raise_error;
190: end if;
183: --
184: /* 1653358: Not necessary
185: if nvl(l_installed_flag,hr_api.g_varchar2) not in ('I','B') then
186: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
187: fnd_message.set_token('PROCEDURE', l_proc);
188: fnd_message.set_token('STEP','20');
189: fnd_message.raise_error;
190: end if;
191: */
184: /* 1653358: Not necessary
185: if nvl(l_installed_flag,hr_api.g_varchar2) not in ('I','B') then
186: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
187: fnd_message.set_token('PROCEDURE', l_proc);
188: fnd_message.set_token('STEP','20');
189: fnd_message.raise_error;
190: end if;
191: */
192: --
185: if nvl(l_installed_flag,hr_api.g_varchar2) not in ('I','B') then
186: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
187: fnd_message.set_token('PROCEDURE', l_proc);
188: fnd_message.set_token('STEP','20');
189: fnd_message.raise_error;
190: end if;
191: */
192: --
193: end if;
246: open csr_item_property;
247: fetch csr_item_property into l_information_formula_id;
248: if csr_item_property%notfound then
249: close csr_item_property;
250: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
251: fnd_message.set_token('PROCEDURE', l_proc);
252: fnd_message.set_token('STEP','10');
253: fnd_message.raise_error;
254: end if;
247: fetch csr_item_property into l_information_formula_id;
248: if csr_item_property%notfound then
249: close csr_item_property;
250: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
251: fnd_message.set_token('PROCEDURE', l_proc);
252: fnd_message.set_token('STEP','10');
253: fnd_message.raise_error;
254: end if;
255: close csr_item_property;
248: if csr_item_property%notfound then
249: close csr_item_property;
250: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
251: fnd_message.set_token('PROCEDURE', l_proc);
252: fnd_message.set_token('STEP','10');
253: fnd_message.raise_error;
254: end if;
255: close csr_item_property;
256: --
249: close csr_item_property;
250: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
251: fnd_message.set_token('PROCEDURE', l_proc);
252: fnd_message.set_token('STEP','10');
253: fnd_message.raise_error;
254: end if;
255: close csr_item_property;
256: --
257: -- Check information prompt has been specified if information formula has,
258: -- and has not been specified if information formula has not
259: --
260: if l_information_formula_id is null then
261: if p_information_prompt is not null then
262: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
263: fnd_message.set_token('PROCEDURE', l_proc);
264: fnd_message.set_token('STEP','20');
265: fnd_message.raise_error;
266: end if;
259: --
260: if l_information_formula_id is null then
261: if p_information_prompt is not null then
262: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
263: fnd_message.set_token('PROCEDURE', l_proc);
264: fnd_message.set_token('STEP','20');
265: fnd_message.raise_error;
266: end if;
267: elsif l_information_formula_id is not null then
260: if l_information_formula_id is null then
261: if p_information_prompt is not null then
262: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
263: fnd_message.set_token('PROCEDURE', l_proc);
264: fnd_message.set_token('STEP','20');
265: fnd_message.raise_error;
266: end if;
267: elsif l_information_formula_id is not null then
268: if p_information_prompt is null then
261: if p_information_prompt is not null then
262: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
263: fnd_message.set_token('PROCEDURE', l_proc);
264: fnd_message.set_token('STEP','20');
265: fnd_message.raise_error;
266: end if;
267: elsif l_information_formula_id is not null then
268: if p_information_prompt is null then
269: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
265: fnd_message.raise_error;
266: end if;
267: elsif l_information_formula_id is not null then
268: if p_information_prompt is null then
269: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
270: fnd_message.set_token('PROCEDURE', l_proc);
271: fnd_message.set_token('STEP','30');
272: fnd_message.raise_error;
273: end if;
266: end if;
267: elsif l_information_formula_id is not null then
268: if p_information_prompt is null then
269: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
270: fnd_message.set_token('PROCEDURE', l_proc);
271: fnd_message.set_token('STEP','30');
272: fnd_message.raise_error;
273: end if;
274: end if;
267: elsif l_information_formula_id is not null then
268: if p_information_prompt is null then
269: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
270: fnd_message.set_token('PROCEDURE', l_proc);
271: fnd_message.set_token('STEP','30');
272: fnd_message.raise_error;
273: end if;
274: end if;
275: end if;
268: if p_information_prompt is null then
269: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
270: fnd_message.set_token('PROCEDURE', l_proc);
271: fnd_message.set_token('STEP','30');
272: fnd_message.raise_error;
273: end if;
274: end if;
275: end if;
276: --
326: open csr_item_property;
327: fetch csr_item_property into l_form_item_id, l_template_item_id, l_template_item_context_id;
328: if csr_item_property%notfound then
329: close csr_item_property;
330: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE', l_proc||' '||to_char(p_item_property_id));
332: fnd_message.set_token('STEP','10');
333: fnd_message.raise_error;
334: end if;
327: fetch csr_item_property into l_form_item_id, l_template_item_id, l_template_item_context_id;
328: if csr_item_property%notfound then
329: close csr_item_property;
330: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE', l_proc||' '||to_char(p_item_property_id));
332: fnd_message.set_token('STEP','10');
333: fnd_message.raise_error;
334: end if;
335: close csr_item_property;
328: if csr_item_property%notfound then
329: close csr_item_property;
330: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE', l_proc||' '||to_char(p_item_property_id));
332: fnd_message.set_token('STEP','10');
333: fnd_message.raise_error;
334: end if;
335: close csr_item_property;
336: --
329: close csr_item_property;
330: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE', l_proc||' '||to_char(p_item_property_id));
332: fnd_message.set_token('STEP','10');
333: fnd_message.raise_error;
334: end if;
335: close csr_item_property;
336: --
337: l_item_type := hr_itp_bus.return_item_type
339: ,p_template_item_id => l_template_item_id
340: ,p_template_item_context_id => l_template_item_context_id
341: );
342: if nvl(l_item_type,hr_api.g_varchar2) not in ('BUTTON','CHECKBOX','RADIO_BUTTON') then
343: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
344: fnd_message.set_token('PROCEDURE', l_proc);
345: fnd_message.set_token('STEP','20');
346: fnd_message.raise_error;
347: end if;
340: ,p_template_item_context_id => l_template_item_context_id
341: );
342: if nvl(l_item_type,hr_api.g_varchar2) not in ('BUTTON','CHECKBOX','RADIO_BUTTON') then
343: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
344: fnd_message.set_token('PROCEDURE', l_proc);
345: fnd_message.set_token('STEP','20');
346: fnd_message.raise_error;
347: end if;
348: --
341: );
342: if nvl(l_item_type,hr_api.g_varchar2) not in ('BUTTON','CHECKBOX','RADIO_BUTTON') then
343: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
344: fnd_message.set_token('PROCEDURE', l_proc);
345: fnd_message.set_token('STEP','20');
346: fnd_message.raise_error;
347: end if;
348: --
349: end if;
342: if nvl(l_item_type,hr_api.g_varchar2) not in ('BUTTON','CHECKBOX','RADIO_BUTTON') then
343: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
344: fnd_message.set_token('PROCEDURE', l_proc);
345: fnd_message.set_token('STEP','20');
346: fnd_message.raise_error;
347: end if;
348: --
349: end if;
350: --
402: open csr_item_property;
403: fetch csr_item_property into l_form_item_id, l_template_item_id, l_template_item_context_id;
404: if csr_item_property%notfound then
405: close csr_item_property;
406: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
407: fnd_message.set_token('PROCEDURE', l_proc||' '||to_char(p_item_property_id));
408: fnd_message.set_token('STEP','10');
409: fnd_message.raise_error;
410: end if;
403: fetch csr_item_property into l_form_item_id, l_template_item_id, l_template_item_context_id;
404: if csr_item_property%notfound then
405: close csr_item_property;
406: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
407: fnd_message.set_token('PROCEDURE', l_proc||' '||to_char(p_item_property_id));
408: fnd_message.set_token('STEP','10');
409: fnd_message.raise_error;
410: end if;
411: close csr_item_property;
404: if csr_item_property%notfound then
405: close csr_item_property;
406: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
407: fnd_message.set_token('PROCEDURE', l_proc||' '||to_char(p_item_property_id));
408: fnd_message.set_token('STEP','10');
409: fnd_message.raise_error;
410: end if;
411: close csr_item_property;
412: --
405: close csr_item_property;
406: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
407: fnd_message.set_token('PROCEDURE', l_proc||' '||to_char(p_item_property_id));
408: fnd_message.set_token('STEP','10');
409: fnd_message.raise_error;
410: end if;
411: close csr_item_property;
412: --
413: l_item_type := hr_itp_bus.return_item_type
415: ,p_template_item_id => l_template_item_id
416: ,p_template_item_context_id => l_template_item_context_id
417: );
418: if nvl(l_item_type,hr_api.g_varchar2) not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
420: fnd_message.set_token('PROCEDURE', l_proc);
421: fnd_message.set_token('STEP','20');
422: fnd_message.raise_error;
423: end if;
416: ,p_template_item_context_id => l_template_item_context_id
417: );
418: if nvl(l_item_type,hr_api.g_varchar2) not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
420: fnd_message.set_token('PROCEDURE', l_proc);
421: fnd_message.set_token('STEP','20');
422: fnd_message.raise_error;
423: end if;
424: --
417: );
418: if nvl(l_item_type,hr_api.g_varchar2) not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
420: fnd_message.set_token('PROCEDURE', l_proc);
421: fnd_message.set_token('STEP','20');
422: fnd_message.raise_error;
423: end if;
424: --
425: end if;
418: if nvl(l_item_type,hr_api.g_varchar2) not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
420: fnd_message.set_token('PROCEDURE', l_proc);
421: fnd_message.set_token('STEP','20');
422: fnd_message.raise_error;
423: end if;
424: --
425: end if;
426: --
478: open csr_item_property;
479: fetch csr_item_property into l_form_item_id, l_template_item_id, l_template_item_context_id;
480: if csr_item_property%notfound then
481: close csr_item_property;
482: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
483: fnd_message.set_token('PROCEDURE', l_proc||' '||to_char(p_item_property_id));
484: fnd_message.set_token('STEP','10');
485: fnd_message.raise_error;
486: end if;
479: fetch csr_item_property into l_form_item_id, l_template_item_id, l_template_item_context_id;
480: if csr_item_property%notfound then
481: close csr_item_property;
482: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
483: fnd_message.set_token('PROCEDURE', l_proc||' '||to_char(p_item_property_id));
484: fnd_message.set_token('STEP','10');
485: fnd_message.raise_error;
486: end if;
487: close csr_item_property;
480: if csr_item_property%notfound then
481: close csr_item_property;
482: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
483: fnd_message.set_token('PROCEDURE', l_proc||' '||to_char(p_item_property_id));
484: fnd_message.set_token('STEP','10');
485: fnd_message.raise_error;
486: end if;
487: close csr_item_property;
488: --
481: close csr_item_property;
482: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
483: fnd_message.set_token('PROCEDURE', l_proc||' '||to_char(p_item_property_id));
484: fnd_message.set_token('STEP','10');
485: fnd_message.raise_error;
486: end if;
487: close csr_item_property;
488: --
489: l_item_type := hr_itp_bus.return_item_type
491: ,p_template_item_id => l_template_item_id
492: ,p_template_item_context_id => l_template_item_context_id
493: );
494: if nvl(l_item_type,hr_api.g_varchar2) not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','20');
498: fnd_message.raise_error;
499: end if;
492: ,p_template_item_context_id => l_template_item_context_id
493: );
494: if nvl(l_item_type,hr_api.g_varchar2) not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','20');
498: fnd_message.raise_error;
499: end if;
500: --
493: );
494: if nvl(l_item_type,hr_api.g_varchar2) not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','20');
498: fnd_message.raise_error;
499: end if;
500: --
501: end if;
494: if nvl(l_item_type,hr_api.g_varchar2) not in ('BUTTON','CHART_ITEM','CHECKBOX','DISPLAY_ITEM','IMAGE','LIST','OLE_OBJECT','RADIO_BUTTON','TEXT_ITEM','USER_AREA','VBX_CONTROL') then
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','20');
498: fnd_message.raise_error;
499: end if;
500: --
501: end if;
502: --