63: and effective_end_date;
64: --
65: Begin
66: --
67: hr_utility.set_location(' Entering:'||l_proc,10);
68: --
69: --
70: -- Check if the person_id exists in PER_ALL_PEOPLE_F.
71: --
70: -- Check if the person_id exists in PER_ALL_PEOPLE_F.
71: --
72: open csr_person_id;
73: fetch csr_person_id into l_party_id;
74: hr_utility.set_location(l_proc, 30);
75: if csr_person_id%notfound then
76: close csr_person_id;
77: fnd_message.set_name('PER','IRC_412157_PARTY_PERS_MISMTCH');
78: fnd_message.raise_error;
86: else
87: p_party_id:=l_party_id;
88: end if;
89: --
90: hr_utility.set_location(' Leaving:'||l_proc,70);
91: exception
92: when app_exception.application_exception then
93: if hr_multi_message.exception_add
94: (p_associated_column1 => 'IRC_JOB_BASKET_ITEMS.PARTY_ID'
92: when app_exception.application_exception then
93: if hr_multi_message.exception_add
94: (p_associated_column1 => 'IRC_JOB_BASKET_ITEMS.PARTY_ID'
95: ) then
96: hr_utility.set_location(' Leaving:'|| l_proc, 80);
97: raise;
98: end if;
99: hr_utility.set_location(' Leaving:'|| l_proc, 90);
100: --
95: ) then
96: hr_utility.set_location(' Leaving:'|| l_proc, 80);
97: raise;
98: end if;
99: hr_utility.set_location(' Leaving:'|| l_proc, 90);
100: --
101: End chk_person_id;
102: --
103: -- ----------------------------------------------------------------------------
112: where recruitment_activity_id = p_recruitment_activity_id;
113: l_proc varchar2(72) := g_package||'chk_recruitment_activity_id';
114: begin
115: --
116: hr_utility.set_location('Entering:'|| l_proc, 10);
117: --
118: open csr_recruitment_activity_id(p_recruitment_activity_id);
119: if csr_recruitment_activity_id%notfound then
120: close csr_recruitment_activity_id;
117: --
118: open csr_recruitment_activity_id(p_recruitment_activity_id);
119: if csr_recruitment_activity_id%notfound then
120: close csr_recruitment_activity_id;
121: hr_utility.set_message(800,'IRC_412044_JBI_INV_REC_ACT_ID');
122: hr_utility.raise_error;
123: end if;
124: close csr_recruitment_activity_id;
125: --
118: open csr_recruitment_activity_id(p_recruitment_activity_id);
119: if csr_recruitment_activity_id%notfound then
120: close csr_recruitment_activity_id;
121: hr_utility.set_message(800,'IRC_412044_JBI_INV_REC_ACT_ID');
122: hr_utility.raise_error;
123: end if;
124: close csr_recruitment_activity_id;
125: --
126: hr_utility.set_location('Leaving:'|| l_proc, 20);
122: hr_utility.raise_error;
123: end if;
124: close csr_recruitment_activity_id;
125: --
126: hr_utility.set_location('Leaving:'|| l_proc, 20);
127: end;
128: --
129: -- ----------------------------------------------------------------------------
130: -- |---------------------------< chk_unique_item >----------------------------|
140:
141: l_proc varchar2(72) := g_package||'chk_unique_item';
142: begin
143: --
144: hr_utility.set_location('Entering:'|| l_proc, 10);
145: --
146: open csr_unique_prim_key(p_job_basket_item_id);
147: if csr_unique_prim_key%found then
148: close csr_unique_prim_key;
145: --
146: open csr_unique_prim_key(p_job_basket_item_id);
147: if csr_unique_prim_key%found then
148: close csr_unique_prim_key;
149: hr_utility.set_message(800,'IRC_412043_JBI_INV_COMP_PK');
150: hr_utility.raise_error;
151: end if;
152: close csr_unique_prim_key;
153: --
146: open csr_unique_prim_key(p_job_basket_item_id);
147: if csr_unique_prim_key%found then
148: close csr_unique_prim_key;
149: hr_utility.set_message(800,'IRC_412043_JBI_INV_COMP_PK');
150: hr_utility.raise_error;
151: end if;
152: close csr_unique_prim_key;
153: --
154: hr_utility.set_location('Leaving:'|| l_proc, 20);
150: hr_utility.raise_error;
151: end if;
152: close csr_unique_prim_key;
153: --
154: hr_utility.set_location('Leaving:'|| l_proc, 20);
155: end;
156: --
157: -- ---------------------------------------------------------------------------
158: -- |----------------------< set_security_group_id >--------------------------|
179: l_proc varchar2(72) := g_package||'set_security_group_id';
180: --
181: begin
182: --
183: hr_utility.set_location('Entering:'|| l_proc, 10);
184: --
185: -- Ensure that all the mandatory parameter are not null
186: --
187: hr_api.mandatory_arg_error
215: hr_api.set_security_group_id
216: (p_security_group_id => l_security_group_id
217: );
218: --
219: hr_utility.set_location(' Leaving:'|| l_proc, 20);
220: --
221: end set_security_group_id;
222: --
223: -- ---------------------------------------------------------------------------
237: l_proc varchar2(72) := g_package||'return_legislation_code';
238: --
239: Begin
240: --
241: hr_utility.set_location('Entering:'|| l_proc, 10);
242: --
243: -- Ensure that all the mandatory parameter are not null
244: --
245: hr_api.mandatory_arg_error
248: ,p_argument_value => p_job_basket_item_id
249: );
250: --
251:
252: hr_utility.set_location(' Leaving:'|| l_proc, 40);
253: return l_legislation_code;
254: end return_legislation_code;
255:
256: --
323: --
324: l_proc varchar2(72) := g_package||'insert_validate';
325: --
326: Begin
327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: -- Call all supporting business operations
330: --
331: chk_person_id
341: --
342: -- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS."
343: --
344: --
345: hr_utility.set_location(' Leaving:'||l_proc, 10);
346: End insert_validate;
347: --
348: -- ----------------------------------------------------------------------------
349: -- |---------------------------< update_validate >----------------------------|
355: --
356: l_proc varchar2(72) := g_package||'update_validate';
357: --
358: Begin
359: hr_utility.set_location('Entering:'||l_proc, 5);
360: --
361: -- Call all supporting business operations
362: --
363: --
360: --
361: -- Call all supporting business operations
362: --
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 10);
365: End update_validate;
366: --
367: -- ----------------------------------------------------------------------------
368: -- |---------------------------< delete_validate >----------------------------|
373: --
374: l_proc varchar2(72) := g_package||'delete_validate';
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: -- Call all supporting business operations
380: --
381: hr_utility.set_location(' Leaving:'||l_proc, 10);
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: -- Call all supporting business operations
380: --
381: hr_utility.set_location(' Leaving:'||l_proc, 10);
382: End delete_validate;
383: --
384: end irc_jbi_bus;