59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'CWB_STOCK_OPTN_DTLS_ID')
67: );
140: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
223: close csr_per;
224:
225: if (p_person_id is null and (p_business_group_id is null or p_employee_number is null))
226: then
227: fnd_message.set_name('BEN','BEN_93358_CWB_INVALID_STK_ENT');
228: fnd_message.raise_error;
229: end if;
230: if ( p_person_id is not null and p_business_group_id <> l_per.business_group_id)
231: then
224:
225: if (p_person_id is null and (p_business_group_id is null or p_employee_number is null))
226: then
227: fnd_message.set_name('BEN','BEN_93358_CWB_INVALID_STK_ENT');
228: fnd_message.raise_error;
229: end if;
230: if ( p_person_id is not null and p_business_group_id <> l_per.business_group_id)
231: then
232: fnd_message.set_name('BEN','BEN_93360_CWB_INVALID_BG_ID');
228: fnd_message.raise_error;
229: end if;
230: if ( p_person_id is not null and p_business_group_id <> l_per.business_group_id)
231: then
232: fnd_message.set_name('BEN','BEN_93360_CWB_INVALID_BG_ID');
233: fnd_message.set_token('BUSINESS_GRP_ID',p_business_group_id);
234: fnd_message.set_token('PERSON_ID',p_person_id);
235: fnd_message.raise_error;
236: end if ;
229: end if;
230: if ( p_person_id is not null and p_business_group_id <> l_per.business_group_id)
231: then
232: fnd_message.set_name('BEN','BEN_93360_CWB_INVALID_BG_ID');
233: fnd_message.set_token('BUSINESS_GRP_ID',p_business_group_id);
234: fnd_message.set_token('PERSON_ID',p_person_id);
235: fnd_message.raise_error;
236: end if ;
237: if (p_person_id is not null and p_employee_number <> l_per.employee_number)
230: if ( p_person_id is not null and p_business_group_id <> l_per.business_group_id)
231: then
232: fnd_message.set_name('BEN','BEN_93360_CWB_INVALID_BG_ID');
233: fnd_message.set_token('BUSINESS_GRP_ID',p_business_group_id);
234: fnd_message.set_token('PERSON_ID',p_person_id);
235: fnd_message.raise_error;
236: end if ;
237: if (p_person_id is not null and p_employee_number <> l_per.employee_number)
238: then
231: then
232: fnd_message.set_name('BEN','BEN_93360_CWB_INVALID_BG_ID');
233: fnd_message.set_token('BUSINESS_GRP_ID',p_business_group_id);
234: fnd_message.set_token('PERSON_ID',p_person_id);
235: fnd_message.raise_error;
236: end if ;
237: if (p_person_id is not null and p_employee_number <> l_per.employee_number)
238: then
239: fnd_message.set_name('BEN','BEN_93359_CWB_INVALID_EMP_ID');
235: fnd_message.raise_error;
236: end if ;
237: if (p_person_id is not null and p_employee_number <> l_per.employee_number)
238: then
239: fnd_message.set_name('BEN','BEN_93359_CWB_INVALID_EMP_ID');
240: fnd_message.set_token('EMPLOYEE_NUMBER',p_employee_number);
241: fnd_message.set_token('PERSON_ID',p_person_id);
242: fnd_message.raise_error;
243: end if;
236: end if ;
237: if (p_person_id is not null and p_employee_number <> l_per.employee_number)
238: then
239: fnd_message.set_name('BEN','BEN_93359_CWB_INVALID_EMP_ID');
240: fnd_message.set_token('EMPLOYEE_NUMBER',p_employee_number);
241: fnd_message.set_token('PERSON_ID',p_person_id);
242: fnd_message.raise_error;
243: end if;
244:
237: if (p_person_id is not null and p_employee_number <> l_per.employee_number)
238: then
239: fnd_message.set_name('BEN','BEN_93359_CWB_INVALID_EMP_ID');
240: fnd_message.set_token('EMPLOYEE_NUMBER',p_employee_number);
241: fnd_message.set_token('PERSON_ID',p_person_id);
242: fnd_message.raise_error;
243: end if;
244:
245: hr_utility.set_location(' Leaving:'||l_proc,20);
238: then
239: fnd_message.set_name('BEN','BEN_93359_CWB_INVALID_EMP_ID');
240: fnd_message.set_token('EMPLOYEE_NUMBER',p_employee_number);
241: fnd_message.set_token('PERSON_ID',p_person_id);
242: fnd_message.raise_error;
243: end if;
244:
245: hr_utility.set_location(' Leaving:'||l_proc,20);
246:
466: IF NOT ben_cso_shd.api_updating
467: (p_cwb_stock_optn_dtls_id => p_rec.cwb_stock_optn_dtls_id
468: ,p_object_version_number => p_rec.object_version_number
469: ) THEN
470: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
471: fnd_message.set_token('PROCEDURE ', l_proc);
472: fnd_message.set_token('STEP ', '5');
473: fnd_message.raise_error;
474: END IF;
467: (p_cwb_stock_optn_dtls_id => p_rec.cwb_stock_optn_dtls_id
468: ,p_object_version_number => p_rec.object_version_number
469: ) THEN
470: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
471: fnd_message.set_token('PROCEDURE ', l_proc);
472: fnd_message.set_token('STEP ', '5');
473: fnd_message.raise_error;
474: END IF;
475: --
468: ,p_object_version_number => p_rec.object_version_number
469: ) THEN
470: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
471: fnd_message.set_token('PROCEDURE ', l_proc);
472: fnd_message.set_token('STEP ', '5');
473: fnd_message.raise_error;
474: END IF;
475: --
476: --
469: ) THEN
470: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
471: fnd_message.set_token('PROCEDURE ', l_proc);
472: fnd_message.set_token('STEP ', '5');
473: fnd_message.raise_error;
474: END IF;
475: --
476: --
477: End chk_non_updateable_args;