103: IF NOT hr_fim_shd.api_updating
104: (p_form_item_id => p_rec.form_item_id
105: ,p_object_version_number => p_rec.object_version_number
106: ) THEN
107: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
108: fnd_message.set_token('PROCEDURE ', l_proc);
109: fnd_message.set_token('STEP ', '5');
110: fnd_message.raise_error;
111: END IF;
104: (p_form_item_id => p_rec.form_item_id
105: ,p_object_version_number => p_rec.object_version_number
106: ) THEN
107: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
108: fnd_message.set_token('PROCEDURE ', l_proc);
109: fnd_message.set_token('STEP ', '5');
110: fnd_message.raise_error;
111: END IF;
112: --
105: ,p_object_version_number => p_rec.object_version_number
106: ) THEN
107: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
108: fnd_message.set_token('PROCEDURE ', l_proc);
109: fnd_message.set_token('STEP ', '5');
110: fnd_message.raise_error;
111: END IF;
112: --
113: IF (nvl(p_rec.application_id,hr_api.g_number) <>
106: ) THEN
107: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
108: fnd_message.set_token('PROCEDURE ', l_proc);
109: fnd_message.set_token('STEP ', '5');
110: fnd_message.raise_error;
111: END IF;
112: --
113: IF (nvl(p_rec.application_id,hr_api.g_number) <>
114: nvl(hr_fim_shd.g_old_rec.application_id,hr_api.g_number)
188: FETCH cur_chk_app_id INTO l_check;
189: IF cur_chk_app_id%NOTFOUND THEN
190: CLOSE cur_chk_app_id;
191: -- error message
192: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
193: fnd_message.set_token('PROCEDURE', l_proc);
194: fnd_message.set_token('STEP','10');
195: fnd_message.raise_error;
196: END IF;
189: IF cur_chk_app_id%NOTFOUND THEN
190: CLOSE cur_chk_app_id;
191: -- error message
192: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
193: fnd_message.set_token('PROCEDURE', l_proc);
194: fnd_message.set_token('STEP','10');
195: fnd_message.raise_error;
196: END IF;
197: CLOSE cur_chk_app_id;
190: CLOSE cur_chk_app_id;
191: -- error message
192: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
193: fnd_message.set_token('PROCEDURE', l_proc);
194: fnd_message.set_token('STEP','10');
195: fnd_message.raise_error;
196: END IF;
197: CLOSE cur_chk_app_id;
198:
191: -- error message
192: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
193: fnd_message.set_token('PROCEDURE', l_proc);
194: fnd_message.set_token('STEP','10');
195: fnd_message.raise_error;
196: END IF;
197: CLOSE cur_chk_app_id;
198:
199: hr_utility.set_location('Leaving:'||l_proc, 100);
235: FETCH cur_chk_form_id INTO l_check;
236: IF cur_chk_form_id%NOTFOUND THEN
237: CLOSE cur_chk_form_id;
238: -- error message
239: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
240: fnd_message.set_token('PROCEDURE', l_proc);
241: fnd_message.set_token('STEP','10');
242: fnd_message.raise_error;
243: END IF;
236: IF cur_chk_form_id%NOTFOUND THEN
237: CLOSE cur_chk_form_id;
238: -- error message
239: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
240: fnd_message.set_token('PROCEDURE', l_proc);
241: fnd_message.set_token('STEP','10');
242: fnd_message.raise_error;
243: END IF;
244: CLOSE cur_chk_form_id;
237: CLOSE cur_chk_form_id;
238: -- error message
239: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
240: fnd_message.set_token('PROCEDURE', l_proc);
241: fnd_message.set_token('STEP','10');
242: fnd_message.raise_error;
243: END IF;
244: CLOSE cur_chk_form_id;
245: --
238: -- error message
239: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
240: fnd_message.set_token('PROCEDURE', l_proc);
241: fnd_message.set_token('STEP','10');
242: fnd_message.raise_error;
243: END IF;
244: CLOSE cur_chk_form_id;
245: --
246: hr_utility.set_location('Leaving:'||l_proc, 100);
298: open csr_form_canvas;
299: fetch csr_form_canvas into l_canvas_type;
300: if csr_form_canvas%notfound then
301: close csr_form_canvas;
302: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
303: fnd_message.set_token('PROCEDURE', l_proc);
304: fnd_message.set_token('STEP','10');
305: fnd_message.raise_error;
306: end if;
299: fetch csr_form_canvas into l_canvas_type;
300: if csr_form_canvas%notfound then
301: close csr_form_canvas;
302: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
303: fnd_message.set_token('PROCEDURE', l_proc);
304: fnd_message.set_token('STEP','10');
305: fnd_message.raise_error;
306: end if;
307: close csr_form_canvas;
300: if csr_form_canvas%notfound then
301: close csr_form_canvas;
302: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
303: fnd_message.set_token('PROCEDURE', l_proc);
304: fnd_message.set_token('STEP','10');
305: fnd_message.raise_error;
306: end if;
307: close csr_form_canvas;
308: --
301: close csr_form_canvas;
302: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
303: fnd_message.set_token('PROCEDURE', l_proc);
304: fnd_message.set_token('STEP','10');
305: fnd_message.raise_error;
306: end if;
307: close csr_form_canvas;
308: --
309: hr_utility.set_location(l_proc,50);
308: --
309: hr_utility.set_location(l_proc,50);
310: --
311: if nvl(l_canvas_type,hr_api.g_varchar2) not in ('CONTENT','TAB','STACKED') then
312: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
313: fnd_message.set_token('PROCEDURE', l_proc);
314: fnd_message.set_token('STEP','20');
315: fnd_message.raise_error;
316: end if;
309: hr_utility.set_location(l_proc,50);
310: --
311: if nvl(l_canvas_type,hr_api.g_varchar2) not in ('CONTENT','TAB','STACKED') then
312: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
313: fnd_message.set_token('PROCEDURE', l_proc);
314: fnd_message.set_token('STEP','20');
315: fnd_message.raise_error;
316: end if;
317: --
310: --
311: if nvl(l_canvas_type,hr_api.g_varchar2) not in ('CONTENT','TAB','STACKED') then
312: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
313: fnd_message.set_token('PROCEDURE', l_proc);
314: fnd_message.set_token('STEP','20');
315: fnd_message.raise_error;
316: end if;
317: --
318: end if;
311: if nvl(l_canvas_type,hr_api.g_varchar2) not in ('CONTENT','TAB','STACKED') then
312: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
313: fnd_message.set_token('PROCEDURE', l_proc);
314: fnd_message.set_token('STEP','20');
315: fnd_message.raise_error;
316: end if;
317: --
318: end if;
319: --
371: --
372: -- Check value is in uppercase
373: --
374: if p_full_item_name <> upper(p_full_item_name) then
375: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
376: fnd_message.set_token('PROCEDURE', l_proc);
377: fnd_message.set_token('STEP','10');
378: fnd_message.raise_error;
379: end if;
372: -- Check value is in uppercase
373: --
374: if p_full_item_name <> upper(p_full_item_name) then
375: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
376: fnd_message.set_token('PROCEDURE', l_proc);
377: fnd_message.set_token('STEP','10');
378: fnd_message.raise_error;
379: end if;
380: --
373: --
374: if p_full_item_name <> upper(p_full_item_name) then
375: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
376: fnd_message.set_token('PROCEDURE', l_proc);
377: fnd_message.set_token('STEP','10');
378: fnd_message.raise_error;
379: end if;
380: --
381: hr_utility.set_location(l_proc,20);
374: if p_full_item_name <> upper(p_full_item_name) then
375: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
376: fnd_message.set_token('PROCEDURE', l_proc);
377: fnd_message.set_token('STEP','10');
378: fnd_message.raise_error;
379: end if;
380: --
381: hr_utility.set_location(l_proc,20);
382: --
385: l_period_pos := instrb(p_full_item_name,'.',1,1);
386: if p_item_type = 'SCROLLBAR' then
387: if l_period_pos <> 0 then
388: -- Full item name (block name) contains a period
389: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
390: fnd_message.set_token('PROCEDURE', l_proc);
391: fnd_message.set_token('STEP','30');
392: fnd_message.raise_error;
393: end if;
386: if p_item_type = 'SCROLLBAR' then
387: if l_period_pos <> 0 then
388: -- Full item name (block name) contains a period
389: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
390: fnd_message.set_token('PROCEDURE', l_proc);
391: fnd_message.set_token('STEP','30');
392: fnd_message.raise_error;
393: end if;
394: else
387: if l_period_pos <> 0 then
388: -- Full item name (block name) contains a period
389: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
390: fnd_message.set_token('PROCEDURE', l_proc);
391: fnd_message.set_token('STEP','30');
392: fnd_message.raise_error;
393: end if;
394: else
395: if l_period_pos = 0 then
388: -- Full item name (block name) contains a period
389: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
390: fnd_message.set_token('PROCEDURE', l_proc);
391: fnd_message.set_token('STEP','30');
392: fnd_message.raise_error;
393: end if;
394: else
395: if l_period_pos = 0 then
396: -- Full item name does not contain period
393: end if;
394: else
395: if l_period_pos = 0 then
396: -- Full item name does not contain period
397: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
398: fnd_message.set_token('PROCEDURE', l_proc);
399: fnd_message.set_token('STEP','20');
400: fnd_message.raise_error;
401: elsif l_period_pos = 1 then
394: else
395: if l_period_pos = 0 then
396: -- Full item name does not contain period
397: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
398: fnd_message.set_token('PROCEDURE', l_proc);
399: fnd_message.set_token('STEP','20');
400: fnd_message.raise_error;
401: elsif l_period_pos = 1 then
402: -- Full item name does not contain data block name
395: if l_period_pos = 0 then
396: -- Full item name does not contain period
397: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
398: fnd_message.set_token('PROCEDURE', l_proc);
399: fnd_message.set_token('STEP','20');
400: fnd_message.raise_error;
401: elsif l_period_pos = 1 then
402: -- Full item name does not contain data block name
403: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
396: -- Full item name does not contain period
397: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
398: fnd_message.set_token('PROCEDURE', l_proc);
399: fnd_message.set_token('STEP','20');
400: fnd_message.raise_error;
401: elsif l_period_pos = 1 then
402: -- Full item name does not contain data block name
403: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
404: fnd_message.set_token('PROCEDURE', l_proc);
399: fnd_message.set_token('STEP','20');
400: fnd_message.raise_error;
401: elsif l_period_pos = 1 then
402: -- Full item name does not contain data block name
403: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
404: fnd_message.set_token('PROCEDURE', l_proc);
405: fnd_message.set_token('STEP','30');
406: fnd_message.raise_error;
407: elsif l_period_pos = length(p_full_item_name) then
400: fnd_message.raise_error;
401: elsif l_period_pos = 1 then
402: -- Full item name does not contain data block name
403: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
404: fnd_message.set_token('PROCEDURE', l_proc);
405: fnd_message.set_token('STEP','30');
406: fnd_message.raise_error;
407: elsif l_period_pos = length(p_full_item_name) then
408: -- Full item name does not contain item name
401: elsif l_period_pos = 1 then
402: -- Full item name does not contain data block name
403: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
404: fnd_message.set_token('PROCEDURE', l_proc);
405: fnd_message.set_token('STEP','30');
406: fnd_message.raise_error;
407: elsif l_period_pos = length(p_full_item_name) then
408: -- Full item name does not contain item name
409: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
402: -- Full item name does not contain data block name
403: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
404: fnd_message.set_token('PROCEDURE', l_proc);
405: fnd_message.set_token('STEP','30');
406: fnd_message.raise_error;
407: elsif l_period_pos = length(p_full_item_name) then
408: -- Full item name does not contain item name
409: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
410: fnd_message.set_token('PROCEDURE', l_proc);
405: fnd_message.set_token('STEP','30');
406: fnd_message.raise_error;
407: elsif l_period_pos = length(p_full_item_name) then
408: -- Full item name does not contain item name
409: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
410: fnd_message.set_token('PROCEDURE', l_proc);
411: fnd_message.set_token('STEP','40');
412: fnd_message.raise_error;
413: end if;
406: fnd_message.raise_error;
407: elsif l_period_pos = length(p_full_item_name) then
408: -- Full item name does not contain item name
409: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
410: fnd_message.set_token('PROCEDURE', l_proc);
411: fnd_message.set_token('STEP','40');
412: fnd_message.raise_error;
413: end if;
414: end if;
407: elsif l_period_pos = length(p_full_item_name) then
408: -- Full item name does not contain item name
409: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
410: fnd_message.set_token('PROCEDURE', l_proc);
411: fnd_message.set_token('STEP','40');
412: fnd_message.raise_error;
413: end if;
414: end if;
415: --
408: -- Full item name does not contain item name
409: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
410: fnd_message.set_token('PROCEDURE', l_proc);
411: fnd_message.set_token('STEP','40');
412: fnd_message.raise_error;
413: end if;
414: end if;
415: --
416: hr_utility.set_location(' Leaving:'||l_proc, 100);
471: (p_effective_date => p_effective_date
472: ,p_lookup_type => 'ITEM_TYPES'
473: ,p_lookup_code => p_item_type
474: ) then
475: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
476: fnd_message.set_token('PROCEDURE', l_proc);
477: fnd_message.set_token('STEP','10');
478: fnd_message.raise_error;
479: end if;
472: ,p_lookup_type => 'ITEM_TYPES'
473: ,p_lookup_code => p_item_type
474: ) then
475: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
476: fnd_message.set_token('PROCEDURE', l_proc);
477: fnd_message.set_token('STEP','10');
478: fnd_message.raise_error;
479: end if;
480: --
473: ,p_lookup_code => p_item_type
474: ) then
475: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
476: fnd_message.set_token('PROCEDURE', l_proc);
477: fnd_message.set_token('STEP','10');
478: fnd_message.raise_error;
479: end if;
480: --
481: end if;
474: ) then
475: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
476: fnd_message.set_token('PROCEDURE', l_proc);
477: fnd_message.set_token('STEP','10');
478: fnd_message.raise_error;
479: end if;
480: --
481: end if;
482: --
501: hr_utility.set_location('Entering:'||l_proc, 10);
502: --
503: if ( (p_item_type = 'RADIO_BUTTON')
504: and (p_radio_button_name is null) ) then
505: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
506: fnd_message.set_token('PROCEDURE', l_proc);
507: fnd_message.set_token('STEP','10');
508: fnd_message.raise_error;
509: elsif ( (p_item_type <> 'RADIO_BUTTON')
502: --
503: if ( (p_item_type = 'RADIO_BUTTON')
504: and (p_radio_button_name is null) ) then
505: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
506: fnd_message.set_token('PROCEDURE', l_proc);
507: fnd_message.set_token('STEP','10');
508: fnd_message.raise_error;
509: elsif ( (p_item_type <> 'RADIO_BUTTON')
510: and (p_radio_button_name is not null) ) then
503: if ( (p_item_type = 'RADIO_BUTTON')
504: and (p_radio_button_name is null) ) then
505: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
506: fnd_message.set_token('PROCEDURE', l_proc);
507: fnd_message.set_token('STEP','10');
508: fnd_message.raise_error;
509: elsif ( (p_item_type <> 'RADIO_BUTTON')
510: and (p_radio_button_name is not null) ) then
511: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
504: and (p_radio_button_name is null) ) then
505: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
506: fnd_message.set_token('PROCEDURE', l_proc);
507: fnd_message.set_token('STEP','10');
508: fnd_message.raise_error;
509: elsif ( (p_item_type <> 'RADIO_BUTTON')
510: and (p_radio_button_name is not null) ) then
511: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
512: fnd_message.set_token('PROCEDURE', l_proc);
507: fnd_message.set_token('STEP','10');
508: fnd_message.raise_error;
509: elsif ( (p_item_type <> 'RADIO_BUTTON')
510: and (p_radio_button_name is not null) ) then
511: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
512: fnd_message.set_token('PROCEDURE', l_proc);
513: fnd_message.set_token('STEP','20');
514: fnd_message.raise_error;
515: end if;
508: fnd_message.raise_error;
509: elsif ( (p_item_type <> 'RADIO_BUTTON')
510: and (p_radio_button_name is not null) ) then
511: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
512: fnd_message.set_token('PROCEDURE', l_proc);
513: fnd_message.set_token('STEP','20');
514: fnd_message.raise_error;
515: end if;
516: --
509: elsif ( (p_item_type <> 'RADIO_BUTTON')
510: and (p_radio_button_name is not null) ) then
511: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
512: fnd_message.set_token('PROCEDURE', l_proc);
513: fnd_message.set_token('STEP','20');
514: fnd_message.raise_error;
515: end if;
516: --
517: if (p_radio_button_name <> upper(p_radio_button_name)) then
510: and (p_radio_button_name is not null) ) then
511: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
512: fnd_message.set_token('PROCEDURE', l_proc);
513: fnd_message.set_token('STEP','20');
514: fnd_message.raise_error;
515: end if;
516: --
517: if (p_radio_button_name <> upper(p_radio_button_name)) then
518: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
514: fnd_message.raise_error;
515: end if;
516: --
517: if (p_radio_button_name <> upper(p_radio_button_name)) then
518: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE', l_proc);
520: fnd_message.set_token('STEP','30');
521: fnd_message.raise_error;
522: end if;
515: end if;
516: --
517: if (p_radio_button_name <> upper(p_radio_button_name)) then
518: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE', l_proc);
520: fnd_message.set_token('STEP','30');
521: fnd_message.raise_error;
522: end if;
523: --
516: --
517: if (p_radio_button_name <> upper(p_radio_button_name)) then
518: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE', l_proc);
520: fnd_message.set_token('STEP','30');
521: fnd_message.raise_error;
522: end if;
523: --
524: hr_utility.set_location('Leaving:'||l_proc, 100);
517: if (p_radio_button_name <> upper(p_radio_button_name)) then
518: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE', l_proc);
520: fnd_message.set_token('STEP','30');
521: fnd_message.raise_error;
522: end if;
523: --
524: hr_utility.set_location('Leaving:'||l_proc, 100);
525: End chk_radio_button_name;
597: (p_effective_date => p_effective_date
598: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
599: ,p_lookup_code => p_required_override
600: ) then
601: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
602: fnd_message.set_token('PROCEDURE', l_proc);
603: fnd_message.set_token('STEP','10');
604: fnd_message.raise_error;
605: end if;
598: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
599: ,p_lookup_code => p_required_override
600: ) then
601: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
602: fnd_message.set_token('PROCEDURE', l_proc);
603: fnd_message.set_token('STEP','10');
604: fnd_message.raise_error;
605: end if;
606: --
599: ,p_lookup_code => p_required_override
600: ) then
601: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
602: fnd_message.set_token('PROCEDURE', l_proc);
603: fnd_message.set_token('STEP','10');
604: fnd_message.raise_error;
605: end if;
606: --
607: end if;
600: ) then
601: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
602: fnd_message.set_token('PROCEDURE', l_proc);
603: fnd_message.set_token('STEP','10');
604: fnd_message.raise_error;
605: end if;
606: --
607: end if;
608: --
661: (p_effective_date => p_effective_date
662: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
663: ,p_lookup_code => p_visible_override
664: ) then
665: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
666: fnd_message.set_token('PROCEDURE', l_proc);
667: fnd_message.set_token('STEP','10');
668: fnd_message.raise_error;
669: end if;
662: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
663: ,p_lookup_code => p_visible_override
664: ) then
665: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
666: fnd_message.set_token('PROCEDURE', l_proc);
667: fnd_message.set_token('STEP','10');
668: fnd_message.raise_error;
669: end if;
670: --
663: ,p_lookup_code => p_visible_override
664: ) then
665: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
666: fnd_message.set_token('PROCEDURE', l_proc);
667: fnd_message.set_token('STEP','10');
668: fnd_message.raise_error;
669: end if;
670: --
671: end if;
664: ) then
665: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
666: fnd_message.set_token('PROCEDURE', l_proc);
667: fnd_message.set_token('STEP','10');
668: fnd_message.raise_error;
669: end if;
670: --
671: end if;
672: --
727: open csr_form_canvas;
728: fetch csr_form_canvas into l_application_id,l_form_id;
729: if csr_form_canvas%notfound then
730: close csr_form_canvas;
731: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
732: fnd_message.set_token('PROCEDURE', l_proc);
733: fnd_message.set_token('STEP','10');
734: fnd_message.raise_error;
735: end if;
728: fetch csr_form_canvas into l_application_id,l_form_id;
729: if csr_form_canvas%notfound then
730: close csr_form_canvas;
731: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
732: fnd_message.set_token('PROCEDURE', l_proc);
733: fnd_message.set_token('STEP','10');
734: fnd_message.raise_error;
735: end if;
736: close csr_form_canvas;
729: if csr_form_canvas%notfound then
730: close csr_form_canvas;
731: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
732: fnd_message.set_token('PROCEDURE', l_proc);
733: fnd_message.set_token('STEP','10');
734: fnd_message.raise_error;
735: end if;
736: close csr_form_canvas;
737: --
730: close csr_form_canvas;
731: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
732: fnd_message.set_token('PROCEDURE', l_proc);
733: fnd_message.set_token('STEP','10');
734: fnd_message.raise_error;
735: end if;
736: close csr_form_canvas;
737: --
738: hr_utility.set_location(l_proc,40);
738: hr_utility.set_location(l_proc,40);
739: --
740: if ( (nvl(p_application_id,hr_api.g_number) <> nvl(l_application_id,hr_api.g_number))
741: or (nvl(p_form_id,hr_api.g_number) <> nvl(l_form_id,hr_api.g_number))) then
742: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
743: fnd_message.set_token('PROCEDURE', l_proc);
744: fnd_message.set_token('STEP','10');
745: fnd_message.raise_error;
746: end if;
739: --
740: if ( (nvl(p_application_id,hr_api.g_number) <> nvl(l_application_id,hr_api.g_number))
741: or (nvl(p_form_id,hr_api.g_number) <> nvl(l_form_id,hr_api.g_number))) then
742: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
743: fnd_message.set_token('PROCEDURE', l_proc);
744: fnd_message.set_token('STEP','10');
745: fnd_message.raise_error;
746: end if;
747: --
740: if ( (nvl(p_application_id,hr_api.g_number) <> nvl(l_application_id,hr_api.g_number))
741: or (nvl(p_form_id,hr_api.g_number) <> nvl(l_form_id,hr_api.g_number))) then
742: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
743: fnd_message.set_token('PROCEDURE', l_proc);
744: fnd_message.set_token('STEP','10');
745: fnd_message.raise_error;
746: end if;
747: --
748: end if;
741: or (nvl(p_form_id,hr_api.g_number) <> nvl(l_form_id,hr_api.g_number))) then
742: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
743: fnd_message.set_token('PROCEDURE', l_proc);
744: fnd_message.set_token('STEP','10');
745: fnd_message.raise_error;
746: end if;
747: --
748: end if;
749: --
805: open csr_form_canvas;
806: fetch csr_form_canvas into l_canvas_type;
807: if csr_form_canvas%notfound then
808: close csr_form_canvas;
809: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
810: fnd_message.set_token('PROCEDURE', l_proc);
811: fnd_message.set_token('STEP','10');
812: fnd_message.raise_error;
813: end if;
806: fetch csr_form_canvas into l_canvas_type;
807: if csr_form_canvas%notfound then
808: close csr_form_canvas;
809: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
810: fnd_message.set_token('PROCEDURE', l_proc);
811: fnd_message.set_token('STEP','10');
812: fnd_message.raise_error;
813: end if;
814: close csr_form_canvas;
807: if csr_form_canvas%notfound then
808: close csr_form_canvas;
809: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
810: fnd_message.set_token('PROCEDURE', l_proc);
811: fnd_message.set_token('STEP','10');
812: fnd_message.raise_error;
813: end if;
814: close csr_form_canvas;
815: --
808: close csr_form_canvas;
809: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
810: fnd_message.set_token('PROCEDURE', l_proc);
811: fnd_message.set_token('STEP','10');
812: fnd_message.raise_error;
813: end if;
814: close csr_form_canvas;
815: --
816: hr_utility.set_location(l_proc,40);
822: --
823: hr_utility.set_location(l_proc,50);
824: --
825: if p_form_tab_page_id is null then
826: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
827: fnd_message.set_token('PROCEDURE', l_proc);
828: fnd_message.set_token('STEP','20');
829: fnd_message.raise_error;
830: end if;
823: hr_utility.set_location(l_proc,50);
824: --
825: if p_form_tab_page_id is null then
826: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
827: fnd_message.set_token('PROCEDURE', l_proc);
828: fnd_message.set_token('STEP','20');
829: fnd_message.raise_error;
830: end if;
831: --
824: --
825: if p_form_tab_page_id is null then
826: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
827: fnd_message.set_token('PROCEDURE', l_proc);
828: fnd_message.set_token('STEP','20');
829: fnd_message.raise_error;
830: end if;
831: --
832: hr_utility.set_location(l_proc,60);
825: if p_form_tab_page_id is null then
826: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
827: fnd_message.set_token('PROCEDURE', l_proc);
828: fnd_message.set_token('STEP','20');
829: fnd_message.raise_error;
830: end if;
831: --
832: hr_utility.set_location(l_proc,60);
833: --
834: open csr_form_tab_page;
835: fetch csr_form_tab_page into l_form_canvas_id;
836: if csr_form_tab_page%notfound then
837: close csr_form_tab_page;
838: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
839: fnd_message.set_token('PROCEDURE', l_proc);
840: fnd_message.set_token('STEP','30');
841: fnd_message.raise_error;
842: end if;
835: fetch csr_form_tab_page into l_form_canvas_id;
836: if csr_form_tab_page%notfound then
837: close csr_form_tab_page;
838: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
839: fnd_message.set_token('PROCEDURE', l_proc);
840: fnd_message.set_token('STEP','30');
841: fnd_message.raise_error;
842: end if;
843: close csr_form_tab_page;
836: if csr_form_tab_page%notfound then
837: close csr_form_tab_page;
838: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
839: fnd_message.set_token('PROCEDURE', l_proc);
840: fnd_message.set_token('STEP','30');
841: fnd_message.raise_error;
842: end if;
843: close csr_form_tab_page;
844: --
837: close csr_form_tab_page;
838: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
839: fnd_message.set_token('PROCEDURE', l_proc);
840: fnd_message.set_token('STEP','30');
841: fnd_message.raise_error;
842: end if;
843: close csr_form_tab_page;
844: --
845: hr_utility.set_location(l_proc,70);
845: hr_utility.set_location(l_proc,70);
846: --
847: if nvl(p_form_canvas_id,hr_api.g_number) <>
848: nvl(l_form_canvas_id,hr_api.g_number) then
849: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
850: fnd_message.set_token('PROCEDURE', l_proc);
851: fnd_message.set_token('STEP','40');
852: fnd_message.raise_error;
853: end if;
846: --
847: if nvl(p_form_canvas_id,hr_api.g_number) <>
848: nvl(l_form_canvas_id,hr_api.g_number) then
849: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
850: fnd_message.set_token('PROCEDURE', l_proc);
851: fnd_message.set_token('STEP','40');
852: fnd_message.raise_error;
853: end if;
854: --
847: if nvl(p_form_canvas_id,hr_api.g_number) <>
848: nvl(l_form_canvas_id,hr_api.g_number) then
849: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
850: fnd_message.set_token('PROCEDURE', l_proc);
851: fnd_message.set_token('STEP','40');
852: fnd_message.raise_error;
853: end if;
854: --
855: else
848: nvl(l_form_canvas_id,hr_api.g_number) then
849: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
850: fnd_message.set_token('PROCEDURE', l_proc);
851: fnd_message.set_token('STEP','40');
852: fnd_message.raise_error;
853: end if;
854: --
855: else
856: --
856: --
857: hr_utility.set_location(l_proc,80);
858: --
859: if p_form_tab_page_id is not null then
860: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
861: fnd_message.set_token('PROCEDURE', l_proc);
862: fnd_message.set_token('STEP','50');
863: fnd_message.raise_error;
864: end if;
857: hr_utility.set_location(l_proc,80);
858: --
859: if p_form_tab_page_id is not null then
860: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
861: fnd_message.set_token('PROCEDURE', l_proc);
862: fnd_message.set_token('STEP','50');
863: fnd_message.raise_error;
864: end if;
865: --
858: --
859: if p_form_tab_page_id is not null then
860: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
861: fnd_message.set_token('PROCEDURE', l_proc);
862: fnd_message.set_token('STEP','50');
863: fnd_message.raise_error;
864: end if;
865: --
866: end if;
859: if p_form_tab_page_id is not null then
860: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
861: fnd_message.set_token('PROCEDURE', l_proc);
862: fnd_message.set_token('STEP','50');
863: fnd_message.raise_error;
864: end if;
865: --
866: end if;
867: --
871: -- specified
872: --
873: if p_form_tab_page_id_override is not null then
874: if p_form_tab_page_id_override <> nvl(p_form_tab_page_id,hr_api.g_number) then
875: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
876: fnd_message.set_token('PROCEDURE', l_proc);
877: fnd_message.set_token('STEP','60');
878: fnd_message.raise_error;
879: end if;
872: --
873: if p_form_tab_page_id_override is not null then
874: if p_form_tab_page_id_override <> nvl(p_form_tab_page_id,hr_api.g_number) then
875: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
876: fnd_message.set_token('PROCEDURE', l_proc);
877: fnd_message.set_token('STEP','60');
878: fnd_message.raise_error;
879: end if;
880: end if;
873: if p_form_tab_page_id_override is not null then
874: if p_form_tab_page_id_override <> nvl(p_form_tab_page_id,hr_api.g_number) then
875: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
876: fnd_message.set_token('PROCEDURE', l_proc);
877: fnd_message.set_token('STEP','60');
878: fnd_message.raise_error;
879: end if;
880: end if;
881: --
874: if p_form_tab_page_id_override <> nvl(p_form_tab_page_id,hr_api.g_number) then
875: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
876: fnd_message.set_token('PROCEDURE', l_proc);
877: fnd_message.set_token('STEP','60');
878: fnd_message.raise_error;
879: end if;
880: end if;
881: --
882: end if;