53: IF NOT hr_hnm_shd.api_updating
54: (p_hierarchy_node_map_id => p_rec.hierarchy_node_map_id
55: ,p_object_version_number => p_rec.object_version_number
56: ) THEN
57: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE ', l_proc);
59: fnd_message.set_token('STEP ', '5');
60: fnd_message.raise_error;
61: END IF;
54: (p_hierarchy_node_map_id => p_rec.hierarchy_node_map_id
55: ,p_object_version_number => p_rec.object_version_number
56: ) THEN
57: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE ', l_proc);
59: fnd_message.set_token('STEP ', '5');
60: fnd_message.raise_error;
61: END IF;
62: --
55: ,p_object_version_number => p_rec.object_version_number
56: ) THEN
57: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE ', l_proc);
59: fnd_message.set_token('STEP ', '5');
60: fnd_message.raise_error;
61: END IF;
62: --
63: -- EDIT_HERE: Add checks to ensure non-updateable args have
56: ) THEN
57: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE ', l_proc);
59: fnd_message.set_token('STEP ', '5');
60: fnd_message.raise_error;
61: END IF;
62: --
63: -- EDIT_HERE: Add checks to ensure non-updateable args have
64: -- not been updated.
118: fetch csr_hrc_id into l_found;
119:
120: if(csr_hrc_id%NOTFOUND) then
121: close csr_hrc_id;
122: fnd_message.set_name('PER','PER_449922_HNM_HRCPRNT_ABSNT');
123: fnd_message.raise_error;
124: end if;
125: close csr_hrc_id;
126: end if;
119:
120: if(csr_hrc_id%NOTFOUND) then
121: close csr_hrc_id;
122: fnd_message.set_name('PER','PER_449922_HNM_HRCPRNT_ABSNT');
123: fnd_message.raise_error;
124: end if;
125: close csr_hrc_id;
126: end if;
127:
194: fetch csr_tpc_id into l_found;
195:
196: if(csr_tpc_id%NOTFOUND) then
197: close csr_tpc_id;
198: fnd_message.set_name('PER','PER_449923_HNM_TPCPRNT_ABSNT');
199: fnd_message.raise_error;
200: end if;
201: close csr_tpc_id;
202: end if;
195:
196: if(csr_tpc_id%NOTFOUND) then
197: close csr_tpc_id;
198: fnd_message.set_name('PER','PER_449923_HNM_TPCPRNT_ABSNT');
199: fnd_message.raise_error;
200: end if;
201: close csr_tpc_id;
202: end if;
203:
271: fetch csr_itf_id into l_found;
272:
273: if(csr_itf_id%NOTFOUND) then
274: close csr_itf_id;
275: fnd_message.set_name('PER','PER_449924_HNM_INTPRNT_ABSNT');
276: fnd_message.raise_error;
277: end if;
278: close csr_itf_id;
279: end if;
272:
273: if(csr_itf_id%NOTFOUND) then
274: close csr_itf_id;
275: fnd_message.set_name('PER','PER_449924_HNM_INTPRNT_ABSNT');
276: fnd_message.raise_error;
277: end if;
278: close csr_itf_id;
279: end if;
280:
349: if( (p_topic_id is null and p_user_interface_id is null) or
350: (p_topic_id is not null and p_user_interface_id is not null)
351: )
352: then
353: fnd_message.set_name('PER','PER_449928_HNM_HRCINVLD_COMB');
354: fnd_message.raise_error;
355: end if;
356:
357: else
350: (p_topic_id is not null and p_user_interface_id is not null)
351: )
352: then
353: fnd_message.set_name('PER','PER_449928_HNM_HRCINVLD_COMB');
354: fnd_message.raise_error;
355: end if;
356:
357: else
358:
358:
359: if(p_topic_id is null or
360: p_user_interface_id is null)
361: then
362: fnd_message.set_name('PER','PER_449929_HNM_TPINTINVLD_COM');
363: fnd_message.raise_error;
364: end if;
365:
366: end if;
359: if(p_topic_id is null or
360: p_user_interface_id is null)
361: then
362: fnd_message.set_name('PER','PER_449929_HNM_TPINTINVLD_COM');
363: fnd_message.raise_error;
364: end if;
365:
366: end if;
367:
524:
525: if(csr_hnm_hrctp%FOUND)
526: then
527: close csr_hnm_hrctp;
528: fnd_message.set_name('PER','PER_449925_HNM_HRCTPMAP_DUPLI');
529: fnd_message.raise_error;
530: end if;
531:
532: close csr_hnm_hrctp;
525: if(csr_hnm_hrctp%FOUND)
526: then
527: close csr_hnm_hrctp;
528: fnd_message.set_name('PER','PER_449925_HNM_HRCTPMAP_DUPLI');
529: fnd_message.raise_error;
530: end if;
531:
532: close csr_hnm_hrctp;
533:
539:
540: if(csr_hnm_hrcui%FOUND)
541: then
542: close csr_hnm_hrcui;
543: fnd_message.set_name('PER','PER_449926_HNM_HRCUIMAP_DUPLI');
544: fnd_message.raise_error;
545: end if;
546:
547: close csr_hnm_hrcui;
540: if(csr_hnm_hrcui%FOUND)
541: then
542: close csr_hnm_hrcui;
543: fnd_message.set_name('PER','PER_449926_HNM_HRCUIMAP_DUPLI');
544: fnd_message.raise_error;
545: end if;
546:
547: close csr_hnm_hrcui;
548:
559:
560: if(csr_hnm_tpui%FOUND)
561: then
562: close csr_hnm_tpui;
563: fnd_message.set_name('PER','PER_449927_HNM_TPCUIMAP_DUPLI');
564: fnd_message.raise_error;
565: end if;
566:
567: close csr_hnm_tpui;
560: if(csr_hnm_tpui%FOUND)
561: then
562: close csr_hnm_tpui;
563: fnd_message.set_name('PER','PER_449927_HNM_TPCUIMAP_DUPLI');
564: fnd_message.raise_error;
565: end if;
566:
567: close csr_hnm_tpui;
568: