DBA Data[Home] [Help]

APPS.OTA_CMB_BUS dependencies on FND_MESSAGE

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

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,'CERTIFICATION_MEMBER_ID')
67: );

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

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: --

Line 145: fnd_message.raise_error;

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

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

336: IF NOT ota_cmb_shd.api_updating
337: (p_certification_member_id => p_rec.certification_member_id
338: ,p_object_version_number => p_rec.object_version_number
339: ) THEN
340: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
341: fnd_message.set_token('PROCEDURE ', l_proc);
342: fnd_message.set_token('STEP ', '5');
343: fnd_message.raise_error;
344: END IF;

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

337: (p_certification_member_id => p_rec.certification_member_id
338: ,p_object_version_number => p_rec.object_version_number
339: ) THEN
340: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
341: fnd_message.set_token('PROCEDURE ', l_proc);
342: fnd_message.set_token('STEP ', '5');
343: fnd_message.raise_error;
344: END IF;
345: --

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

338: ,p_object_version_number => p_rec.object_version_number
339: ) THEN
340: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
341: fnd_message.set_token('PROCEDURE ', l_proc);
342: fnd_message.set_token('STEP ', '5');
343: fnd_message.raise_error;
344: END IF;
345: --
346: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 343: fnd_message.raise_error;

339: ) THEN
340: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
341: fnd_message.set_token('PROCEDURE ', l_proc);
342: fnd_message.set_token('STEP ', '5');
343: fnd_message.raise_error;
344: END IF;
345: --
346: -- EDIT_HERE: Add checks to ensure non-updateable args have
347: -- not been updated.

Line 399: fnd_message.set_name('OTA','OTA_13312_GEN_DATE_ORDER');

395: CLOSE csr_av_start_end_date;
396:
397: if p_cmb_start_date is not null and p_cmb_end_date is not null
398: and p_cmb_start_date > p_cmb_end_date then
399: fnd_message.set_name('OTA','OTA_13312_GEN_DATE_ORDER');
400: fnd_message.raise_error;
401: end if;
402:
403: if l_av_start_date is null then

Line 400: fnd_message.raise_error;

396:
397: if p_cmb_start_date is not null and p_cmb_end_date is not null
398: and p_cmb_start_date > p_cmb_end_date then
399: fnd_message.set_name('OTA','OTA_13312_GEN_DATE_ORDER');
400: fnd_message.raise_error;
401: end if;
402:
403: if l_av_start_date is null then
404: l_av_start_date := hr_api.g_sot;

Line 424: fnd_message.set_name('OTA','OTA_443911_CMB_OUT_OF_AV_DATE');

420: l_cmb_start_date > l_av_end_date or
421: l_cmb_end_date > l_av_end_date or
422: l_cmb_end_date < l_av_start_date then
423:
424: fnd_message.set_name('OTA','OTA_443911_CMB_OUT_OF_AV_DATE');
425: fnd_message.raise_error;
426: end if;
427:
428: END IF;

Line 425: fnd_message.raise_error;

421: l_cmb_end_date > l_av_end_date or
422: l_cmb_end_date < l_av_start_date then
423:
424: fnd_message.set_name('OTA','OTA_443911_CMB_OUT_OF_AV_DATE');
425: fnd_message.raise_error;
426: end if;
427:
428: END IF;
429: --

Line 491: fnd_message.set_name('OTA','OTA_13312_GEN_DATE_ORDER');

487: CLOSE csr_cert_start_end_date;
488:
489: if p_cmb_start_date is not null and p_cmb_end_date is not null
490: and p_cmb_start_date > p_cmb_end_date then
491: fnd_message.set_name('OTA','OTA_13312_GEN_DATE_ORDER');
492: fnd_message.raise_error;
493: end if;
494:
495: if l_cert_start_date is null then

Line 492: fnd_message.raise_error;

488:
489: if p_cmb_start_date is not null and p_cmb_end_date is not null
490: and p_cmb_start_date > p_cmb_end_date then
491: fnd_message.set_name('OTA','OTA_13312_GEN_DATE_ORDER');
492: fnd_message.raise_error;
493: end if;
494:
495: if l_cert_start_date is null then
496: l_cert_start_date := hr_api.g_sot;

Line 516: fnd_message.set_name('OTA','OTA_443918_CMB_OUT_OF_CRT_DATE');

512: l_cmb_start_date > l_cert_end_date or
513: l_cmb_end_date > l_cert_end_date or
514: l_cmb_end_date < l_cert_start_date then
515:
516: fnd_message.set_name('OTA','OTA_443918_CMB_OUT_OF_CRT_DATE');
517: fnd_message.raise_error;
518: end if;
519:
520: END IF;

Line 517: fnd_message.raise_error;

513: l_cmb_end_date > l_cert_end_date or
514: l_cmb_end_date < l_cert_start_date then
515:
516: fnd_message.set_name('OTA','OTA_443918_CMB_OUT_OF_CRT_DATE');
517: fnd_message.raise_error;
518: end if;
519:
520: END IF;
521: --

Line 593: fnd_message.set_name('OTA','OTA_443927_CMB_DUPLICATE');

589: and a_dup_cmb.start_date_active <= nvl(p_cmb_end_date, hr_api.g_eot))
590: OR (nvl(a_dup_cmb.end_date_active, hr_api.g_eot) >= p_cmb_start_date
591: and nvl(a_dup_cmb.end_date_active, hr_api.g_eot) <= nvl(p_cmb_end_date, hr_api.g_eot))
592: then
593: fnd_message.set_name('OTA','OTA_443927_CMB_DUPLICATE');
594: fnd_message.raise_error;
595: end if;
596:
597: end loop;

Line 594: fnd_message.raise_error;

590: OR (nvl(a_dup_cmb.end_date_active, hr_api.g_eot) >= p_cmb_start_date
591: and nvl(a_dup_cmb.end_date_active, hr_api.g_eot) <= nvl(p_cmb_end_date, hr_api.g_eot))
592: then
593: fnd_message.set_name('OTA','OTA_443927_CMB_DUPLICATE');
594: fnd_message.raise_error;
595: end if;
596:
597: end loop;
598: END IF;