DBA Data[Home] [Help]

APPS.IRC_IAD_BUS dependencies on FND_MESSAGE

Line 66: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

62: close csr_sec_grp;
63: --
64: -- The primary key is invalid therefore we must error
65: --
66: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
67: hr_multi_message.add
68: (p_associated_column1
69: => nvl(p_associated_column1,'ASSIGNMENT_DETAILS_ID')
70: );

Line 150: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

146: --
147: -- The primary key is invalid therefore we must error
148: --
149: close csr_leg_code;
150: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
151: fnd_message.raise_error;
152: end if;
153: hr_utility.set_location(l_proc,30);
154: --

Line 151: fnd_message.raise_error;

147: -- The primary key is invalid therefore we must error
148: --
149: close csr_leg_code;
150: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
151: fnd_message.raise_error;
152: end if;
153: hr_utility.set_location(l_proc,30);
154: --
155: -- Set the global variables so the values are

Line 210: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

206: (p_assignment_details_id => p_rec.assignment_details_id
207: ,p_effective_date => p_effective_date
208: ,p_object_version_number => p_rec.object_version_number
209: ) THEN
210: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
211: fnd_message.set_token('PROCEDURE ', l_proc);
212: fnd_message.set_token('STEP ', '5');
213: fnd_message.raise_error;
214: END IF;

Line 211: fnd_message.set_token('PROCEDURE ', l_proc);

207: ,p_effective_date => p_effective_date
208: ,p_object_version_number => p_rec.object_version_number
209: ) THEN
210: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
211: fnd_message.set_token('PROCEDURE ', l_proc);
212: fnd_message.set_token('STEP ', '5');
213: fnd_message.raise_error;
214: END IF;
215: --

Line 212: fnd_message.set_token('STEP ', '5');

208: ,p_object_version_number => p_rec.object_version_number
209: ) THEN
210: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
211: fnd_message.set_token('PROCEDURE ', l_proc);
212: fnd_message.set_token('STEP ', '5');
213: fnd_message.raise_error;
214: END IF;
215: --
216: -- Ensure non-updateable args have not been updated.

Line 213: fnd_message.raise_error;

209: ) THEN
210: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
211: fnd_message.set_token('PROCEDURE ', l_proc);
212: fnd_message.set_token('STEP ', '5');
213: fnd_message.raise_error;
214: END IF;
215: --
216: -- Ensure non-updateable args have not been updated.
217: --

Line 318: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

314: ,p_base_key_column => 'ASSIGNMENT_ID'
315: ,p_base_key_value => p_assignment_id
316: ,p_from_date => p_validation_start_date
317: ,p_to_date => p_validation_end_date))) Then
318: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
319: fnd_message.set_token('TABLE_NAME','all assignments');
320: hr_multi_message.add
321: (p_associated_column1 => irc_iad_shd.g_tab_nam || '.ASSIGNMENT_ID');
322: End If;

Line 319: fnd_message.set_token('TABLE_NAME','all assignments');

315: ,p_base_key_value => p_assignment_id
316: ,p_from_date => p_validation_start_date
317: ,p_to_date => p_validation_end_date))) Then
318: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
319: fnd_message.set_token('TABLE_NAME','all assignments');
320: hr_multi_message.add
321: (p_associated_column1 => irc_iad_shd.g_tab_nam || '.ASSIGNMENT_ID');
322: End If;
323: --

Line 330: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

326: --
327: -- An unhandled or unexpected error has occurred which
328: -- we must report
329: --
330: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE', l_proc);
332: fnd_message.set_token('STEP','15');
333: fnd_message.raise_error;
334: End dt_update_validate;

Line 331: fnd_message.set_token('PROCEDURE', l_proc);

327: -- An unhandled or unexpected error has occurred which
328: -- we must report
329: --
330: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE', l_proc);
332: fnd_message.set_token('STEP','15');
333: fnd_message.raise_error;
334: End dt_update_validate;
335: --

Line 332: fnd_message.set_token('STEP','15');

328: -- we must report
329: --
330: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE', l_proc);
332: fnd_message.set_token('STEP','15');
333: fnd_message.raise_error;
334: End dt_update_validate;
335: --
336: -- ----------------------------------------------------------------------------

Line 333: fnd_message.raise_error;

329: --
330: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE', l_proc);
332: fnd_message.set_token('STEP','15');
333: fnd_message.raise_error;
334: End dt_update_validate;
335: --
336: -- ----------------------------------------------------------------------------
337: -- |--------------------------< dt_delete_validate >--------------------------|

Line 427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

423: --
424: -- An unhandled or unexpected error has occurred which
425: -- we must report
426: --
427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
428: fnd_message.set_token('PROCEDURE', l_proc);
429: fnd_message.set_token('STEP','15');
430: fnd_message.raise_error;
431: --

Line 428: fnd_message.set_token('PROCEDURE', l_proc);

424: -- An unhandled or unexpected error has occurred which
425: -- we must report
426: --
427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
428: fnd_message.set_token('PROCEDURE', l_proc);
429: fnd_message.set_token('STEP','15');
430: fnd_message.raise_error;
431: --
432: End dt_delete_validate;

Line 429: fnd_message.set_token('STEP','15');

425: -- we must report
426: --
427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
428: fnd_message.set_token('PROCEDURE', l_proc);
429: fnd_message.set_token('STEP','15');
430: fnd_message.raise_error;
431: --
432: End dt_delete_validate;
433: --

Line 430: fnd_message.raise_error;

426: --
427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
428: fnd_message.set_token('PROCEDURE', l_proc);
429: fnd_message.set_token('STEP','15');
430: fnd_message.raise_error;
431: --
432: End dt_delete_validate;
433: --
434: -- ----------------------------------------------------------------------------

Line 516: fnd_message.set_name('PER', 'IRC_412233_INV_OTA_ATTEMPT');

512: --
513: if attempt_exists%notfound then
514: close attempt_exists;
515: hr_utility.set_location(l_proc, 30);
516: fnd_message.set_name('PER', 'IRC_412233_INV_OTA_ATTEMPT');
517: fnd_message.raise_error;
518: else
519: close attempt_exists;
520: end if;

Line 517: fnd_message.raise_error;

513: if attempt_exists%notfound then
514: close attempt_exists;
515: hr_utility.set_location(l_proc, 30);
516: fnd_message.set_name('PER', 'IRC_412233_INV_OTA_ATTEMPT');
517: fnd_message.raise_error;
518: else
519: close attempt_exists;
520: end if;
521: --

Line 537: fnd_message.set_name('PER', 'IRC_412235_OTA_ATTEMPT_INV_UPD');

533: if l_api_updating then
534: --
535: -- non applicant, attempt_id can only be updated to null
536: --
537: fnd_message.set_name('PER', 'IRC_412235_OTA_ATTEMPT_INV_UPD');
538: fnd_message.raise_error;
539: else -- inserting a non applicant
540: fnd_message.set_name('PER', 'IRC_412234_OTA_ATTEMPT_ASG');
541: fnd_message.raise_error;

Line 538: fnd_message.raise_error;

534: --
535: -- non applicant, attempt_id can only be updated to null
536: --
537: fnd_message.set_name('PER', 'IRC_412235_OTA_ATTEMPT_INV_UPD');
538: fnd_message.raise_error;
539: else -- inserting a non applicant
540: fnd_message.set_name('PER', 'IRC_412234_OTA_ATTEMPT_ASG');
541: fnd_message.raise_error;
542: end if;

Line 540: fnd_message.set_name('PER', 'IRC_412234_OTA_ATTEMPT_ASG');

536: --
537: fnd_message.set_name('PER', 'IRC_412235_OTA_ATTEMPT_INV_UPD');
538: fnd_message.raise_error;
539: else -- inserting a non applicant
540: fnd_message.set_name('PER', 'IRC_412234_OTA_ATTEMPT_ASG');
541: fnd_message.raise_error;
542: end if;
543: end if;
544: end if;

Line 541: fnd_message.raise_error;

537: fnd_message.set_name('PER', 'IRC_412235_OTA_ATTEMPT_INV_UPD');
538: fnd_message.raise_error;
539: else -- inserting a non applicant
540: fnd_message.set_name('PER', 'IRC_412234_OTA_ATTEMPT_ASG');
541: fnd_message.raise_error;
542: end if;
543: end if;
544: end if;
545: end if;