58: IF NOT hr_itf_shd.api_updating
59: (p_user_interface_id => p_rec.user_interface_id
60: ,p_object_version_number => p_rec.object_version_number
61: ) THEN
62: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE ', l_proc);
64: fnd_message.set_token('STEP ', '5');
65: fnd_message.raise_error;
66: END IF;
59: (p_user_interface_id => p_rec.user_interface_id
60: ,p_object_version_number => p_rec.object_version_number
61: ) THEN
62: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE ', l_proc);
64: fnd_message.set_token('STEP ', '5');
65: fnd_message.raise_error;
66: END IF;
67: --
60: ,p_object_version_number => p_rec.object_version_number
61: ) THEN
62: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE ', l_proc);
64: fnd_message.set_token('STEP ', '5');
65: fnd_message.raise_error;
66: END IF;
67: --
68: End chk_non_updateable_args;
61: ) THEN
62: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE ', l_proc);
64: fnd_message.set_token('STEP ', '5');
65: fnd_message.raise_error;
66: END IF;
67: --
68: End chk_non_updateable_args;
69:
124: (p_effective_date => p_effective_date
125: ,p_lookup_type => 'HR_KPI_UI_TYPE'
126: ,p_lookup_code => p_type
127: ) then
128: fnd_message.set_name('PER', 'PER_449936_ITF_INT_TYPE_INVAL');
129: fnd_message.raise_error;
130: end if;
131:
132: hr_utility.set_location(' Leaving:' || l_proc,30);
125: ,p_lookup_type => 'HR_KPI_UI_TYPE'
126: ,p_lookup_code => p_type
127: ) then
128: fnd_message.set_name('PER', 'PER_449936_ITF_INT_TYPE_INVAL');
129: fnd_message.raise_error;
130: end if;
131:
132: hr_utility.set_location(' Leaving:' || l_proc,30);
133:
216: fetch csr_form into l_found;
217:
218: if csr_form%NOTFOUND then
219: close csr_form;
220: fnd_message.set_name('PER','PER_449937_ITF_FORM_INVAL');
221: fnd_message.raise_error;
222: end if;
223:
224: close csr_form;
217:
218: if csr_form%NOTFOUND then
219: close csr_form;
220: fnd_message.set_name('PER','PER_449937_ITF_FORM_INVAL');
221: fnd_message.raise_error;
222: end if;
223:
224: close csr_form;
225:
235: fetch csr_form_unique into l_found;
236:
237: if csr_form_unique%FOUND then
238: close csr_form_unique;
239: fnd_message.set_name('PER','PER_449938_ITF_FORM_DUPLI');
240: fnd_message.raise_error;
241: end if;
242: close csr_form_unique;
243:
236:
237: if csr_form_unique%FOUND then
238: close csr_form_unique;
239: fnd_message.set_name('PER','PER_449938_ITF_FORM_DUPLI');
240: fnd_message.raise_error;
241: end if;
242: close csr_form_unique;
243:
244: end if;
328: fetch csr_form_functions into l_found;
329:
330: if csr_form_functions%NOTFOUND then
331: close csr_form_functions;
332: fnd_message.set_name('PER','PER_449939_ITF_PGRGNCD_INVLD');
333: fnd_message.raise_error;
334: end if;
335:
336: close csr_form_functions;
329:
330: if csr_form_functions%NOTFOUND then
331: close csr_form_functions;
332: fnd_message.set_name('PER','PER_449939_ITF_PGRGNCD_INVLD');
333: fnd_message.raise_error;
334: end if;
335:
336: close csr_form_functions;
337:
348:
349: if csr_reg_unique_check%FOUND
350: then
351: close csr_reg_unique_check;
352: fnd_message.set_name('PER','PER_449940_ITF_RGNCD_DUPLI');
353: fnd_message.raise_error;
354: end if;
355: close csr_reg_unique_check;
356: end if;
349: if csr_reg_unique_check%FOUND
350: then
351: close csr_reg_unique_check;
352: fnd_message.set_name('PER','PER_449940_ITF_RGNCD_DUPLI');
353: fnd_message.raise_error;
354: end if;
355: close csr_reg_unique_check;
356: end if;
357: end if;
426: p_page_region_code is not null or
427: p_region_code is not null)
428: )
429: then
430: fnd_message.set_name('PER','PER_449941_ITF_IVLDPUI_COMBN');
431: fnd_message.raise_error;
432: end if;
433:
434: if((p_type = g_ss_const or p_type = g_portal_const) and
427: p_region_code is not null)
428: )
429: then
430: fnd_message.set_name('PER','PER_449941_ITF_IVLDPUI_COMBN');
431: fnd_message.raise_error;
432: end if;
433:
434: if((p_type = g_ss_const or p_type = g_portal_const) and
435: (p_page_region_code is null or
435: (p_page_region_code is null or
436: p_form_name is not null)
437: )
438: then
439: fnd_message.set_name('PER','PER_449942_ITF_IVLDPG_COMBN');
440: fnd_message.raise_error;
441: end if;
442:
443: end if;
436: p_form_name is not null)
437: )
438: then
439: fnd_message.set_name('PER','PER_449942_ITF_IVLDPG_COMBN');
440: fnd_message.raise_error;
441: end if;
442:
443: end if;
444:
509: fetch csr_hnm_id into l_found;
510:
511: if csr_hnm_id%FOUND then
512: close csr_hnm_id;
513: fnd_message.set_name( 'PER','PER_449944_ITF_HNM_MAIN_EXIST');
514: fnd_message.raise_error;
515: end if;
516:
517: close csr_hnm_id;
510:
511: if csr_hnm_id%FOUND then
512: close csr_hnm_id;
513: fnd_message.set_name( 'PER','PER_449944_ITF_HNM_MAIN_EXIST');
514: fnd_message.raise_error;
515: end if;
516:
517: close csr_hnm_id;
518: