65: close csr_sec_grp;
66: --
67: -- The primary key is invalid therefore we must error
68: --
69: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
70: hr_multi_message.add
71: (p_associated_column1
72: => nvl(p_associated_column1,'TEMPLATE_ASSOCIATION_ID')
73: );
152: --
153: -- The primary key is invalid therefore we must error
154: --
155: close csr_leg_code;
156: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
157: fnd_message.raise_error;
158: end if;
159: hr_utility.set_location(l_proc,30);
160: --
153: -- The primary key is invalid therefore we must error
154: --
155: close csr_leg_code;
156: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
157: fnd_message.raise_error;
158: end if;
159: hr_utility.set_location(l_proc,30);
160: --
161: -- Set the global variables so the values are
213: IF NOT irc_ita_shd.api_updating
214: (p_template_association_id => p_rec.template_association_id
215: ,p_object_version_number => p_rec.object_version_number
216: ) THEN
217: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
218: fnd_message.set_token('PROCEDURE ', l_proc);
219: fnd_message.set_token('STEP ', '5');
220: fnd_message.raise_error;
221: END IF;
214: (p_template_association_id => p_rec.template_association_id
215: ,p_object_version_number => p_rec.object_version_number
216: ) THEN
217: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
218: fnd_message.set_token('PROCEDURE ', l_proc);
219: fnd_message.set_token('STEP ', '5');
220: fnd_message.raise_error;
221: END IF;
222: --
215: ,p_object_version_number => p_rec.object_version_number
216: ) THEN
217: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
218: fnd_message.set_token('PROCEDURE ', l_proc);
219: fnd_message.set_token('STEP ', '5');
220: fnd_message.raise_error;
221: END IF;
222: --
223: --
216: ) THEN
217: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
218: fnd_message.set_token('PROCEDURE ', l_proc);
219: fnd_message.set_token('STEP ', '5');
220: fnd_message.raise_error;
221: END IF;
222: --
223: --
224: if irc_ita_shd.g_old_rec.template_association_id <> p_rec.template_association_id then
297: hr_utility.set_location(l_proc,30);
298: if(csr_template%notfound)
299: then
300: close csr_template;
301: fnd_message.set_name('PER','IRC_412326_OFFER_INV_TEMPLT_ID');
302: hr_multi_message.add
303: (p_associated_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.TEMPLATE_ID'
304: );
305: else
305: else
306: close csr_template;
307: end if;
308: else
309: fnd_message.set_name('PER','IRC_412327_OFFER_NULL_TMPLT_ID');
310: hr_multi_message.add
311: (p_associated_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.TEMPLATE_ID'
312: );
313:
388: fetch csr_org into l_org;
389: if (csr_org%notfound)
390: then
391: close csr_org;
392: fnd_message.set_name('PER','IRC_412091_ORG_NOT_EXIST');
393: fnd_message.raise_error;
394: end if;
395: close csr_org;
396: --
389: if (csr_org%notfound)
390: then
391: close csr_org;
392: fnd_message.set_name('PER','IRC_412091_ORG_NOT_EXIST');
393: fnd_message.raise_error;
394: end if;
395: close csr_org;
396: --
397: hr_utility.set_location(l_proc, 30);
473: --
474: if (csr_job%notfound) then
475: --
476: close csr_job;
477: fnd_message.set_name('PER','IRC_412037_RTM_INV_JOB_ID');
478: fnd_message.raise_error;
479: --
480: end if;
481: --
474: if (csr_job%notfound) then
475: --
476: close csr_job;
477: fnd_message.set_name('PER','IRC_412037_RTM_INV_JOB_ID');
478: fnd_message.raise_error;
479: --
480: end if;
481: --
482: close csr_job;
561: --
562: if (csr_pos%notfound) then
563: --
564: close csr_pos;
565: fnd_message.set_name('PER','IRC_412092_POS_NOT_EXIST');
566: fnd_message.raise_error;
567: --
568: end if;
569: --
562: if (csr_pos%notfound) then
563: --
564: close csr_pos;
565: fnd_message.set_name('PER','IRC_412092_POS_NOT_EXIST');
566: fnd_message.raise_error;
567: --
568: end if;
569: --
570: close csr_pos;
646: l_flag := l_flag + 1;
647: end if;
648: --
649: if (l_flag > 1) then
650: fnd_message.set_name('PER','IRC_412090_TOO_MANY_ARGS');
651: fnd_message.raise_error;
652: end if;
653: end if; -- no exclusive error
654: --
647: end if;
648: --
649: if (l_flag > 1) then
650: fnd_message.set_name('PER','IRC_412090_TOO_MANY_ARGS');
651: fnd_message.raise_error;
652: end if;
653: end if; -- no exclusive error
654: --
655: hr_utility.set_location(' Leaving:'|| l_proc, 40);
740: --
741: if (csr_job%found) then
742: --
743: close csr_job;
744: fnd_message.set_name('PER','IRC_412328_OFR_DUP_TEMPLATE_ID');
745: fnd_message.raise_error;
746: --
747: end if;
748: --
741: if (csr_job%found) then
742: --
743: close csr_job;
744: fnd_message.set_name('PER','IRC_412328_OFR_DUP_TEMPLATE_ID');
745: fnd_message.raise_error;
746: --
747: end if;
748: --
749: end if;
755: --
756: if (csr_pos%found) then
757: --
758: close csr_pos;
759: fnd_message.set_name('PER','IRC_412328_OFR_DUP_TEMPLATE_ID');
760: fnd_message.raise_error;
761: --
762: end if;
763: --
756: if (csr_pos%found) then
757: --
758: close csr_pos;
759: fnd_message.set_name('PER','IRC_412328_OFR_DUP_TEMPLATE_ID');
760: fnd_message.raise_error;
761: --
762: end if;
763: --
764:
771: --
772: if (csr_org%found) then
773: --
774: close csr_org;
775: fnd_message.set_name('PER','IRC_412328_OFR_DUP_TEMPLATE_ID');
776: fnd_message.raise_error;
777: --
778: end if;
779: --
772: if (csr_org%found) then
773: --
774: close csr_org;
775: fnd_message.set_name('PER','IRC_412328_OFR_DUP_TEMPLATE_ID');
776: fnd_message.raise_error;
777: --
778: end if;
779: --
780: end if;
869: )
870: then
871: --
872: hr_utility.set_location(l_proc,40);
873: fnd_message.set_name('PER','IRC_412329_OFR_INV_DEF_TMP_ASS');
874: fnd_message.raise_error;
875: --
876: end if;
877: end if;
870: then
871: --
872: hr_utility.set_location(l_proc,40);
873: fnd_message.set_name('PER','IRC_412329_OFR_INV_DEF_TMP_ASS');
874: fnd_message.raise_error;
875: --
876: end if;
877: end if;
878: end if; -- no exclusive error
951: hr_utility.set_location(l_proc,40);
952: --
953: if (p_start_date > nvl(p_end_date,hr_api.g_eot))
954: then
955: fnd_message.set_name('PER','IRC_ALL_DATE_START_END');
956: hr_multi_message.add
957: (p_associated_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.START_DATE'
958: ,p_associated_column2 => 'IRC_TEMPLATE_ASSOCIATIONS.END_DATE'
959: );