DBA Data[Home] [Help]

APPS.PAY_ETM_BUS dependencies on FND_MESSAGE

Line 119: fnd_message.set_name('PAY', 'PAY_50069_ETM_LEG_BUS_NOT_NULL');

115: --
116: if p_business_group_id is not null and p_legislation_code is not null
117: then
118: hr_utility.set_location(' Leaving:'||l_proc, 10);
119: fnd_message.set_name('PAY', 'PAY_50069_ETM_LEG_BUS_NOT_NULL');
120: fnd_message.raise_error;
121: end if;
122: --
123: -- Validate business_group_id.

Line 120: fnd_message.raise_error;

116: if p_business_group_id is not null and p_legislation_code is not null
117: then
118: hr_utility.set_location(' Leaving:'||l_proc, 10);
119: fnd_message.set_name('PAY', 'PAY_50069_ETM_LEG_BUS_NOT_NULL');
120: fnd_message.raise_error;
121: end if;
122: --
123: -- Validate business_group_id.
124: --

Line 138: fnd_message.set_name('PAY', 'PAY_50070_INVALID_LEG_CODE');

134: fetch csr_valid_leg_code into l_valid;
135: if csr_valid_leg_code%notfound then
136: hr_utility.set_location(' Leaving:'||l_proc, 15);
137: close csr_valid_leg_code;
138: fnd_message.set_name('PAY', 'PAY_50070_INVALID_LEG_CODE');
139: fnd_message.raise_error;
140: end if;
141: close csr_valid_leg_code;
142: end if;

Line 139: fnd_message.raise_error;

135: if csr_valid_leg_code%notfound then
136: hr_utility.set_location(' Leaving:'||l_proc, 15);
137: close csr_valid_leg_code;
138: fnd_message.set_name('PAY', 'PAY_50070_INVALID_LEG_CODE');
139: fnd_message.raise_error;
140: end if;
141: close csr_valid_leg_code;
142: end if;
143: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 217: fnd_message.set_name('PAY', 'PAY_50071_ETM_NAME_EXISTS');

213: fetch csr_template_name_exists into l_exists;
214: if csr_template_name_exists%found then
215: close csr_template_name_exists;
216: hr_utility.set_location(' Leaving:'||l_proc, 10);
217: fnd_message.set_name('PAY', 'PAY_50071_ETM_NAME_EXISTS');
218: fnd_message.set_token('TEMPLATE_NAME', p_template_name);
219: fnd_message.raise_error;
220: end if;
221: close csr_template_name_exists;

Line 218: fnd_message.set_token('TEMPLATE_NAME', p_template_name);

214: if csr_template_name_exists%found then
215: close csr_template_name_exists;
216: hr_utility.set_location(' Leaving:'||l_proc, 10);
217: fnd_message.set_name('PAY', 'PAY_50071_ETM_NAME_EXISTS');
218: fnd_message.set_token('TEMPLATE_NAME', p_template_name);
219: fnd_message.raise_error;
220: end if;
221: close csr_template_name_exists;
222: end if;

Line 219: fnd_message.raise_error;

215: close csr_template_name_exists;
216: hr_utility.set_location(' Leaving:'||l_proc, 10);
217: fnd_message.set_name('PAY', 'PAY_50071_ETM_NAME_EXISTS');
218: fnd_message.set_token('TEMPLATE_NAME', p_template_name);
219: fnd_message.raise_error;
220: end if;
221: close csr_template_name_exists;
222: end if;
223: hr_utility.set_location(' Leaving:'||l_proc, 15);

Line 270: fnd_message.set_name('PAY', 'PAY_50072_ETM_PRIORITY_UPDATE');

266: -- Check that an update is not being done for a template type of 'U'.
267: --
268: if l_api_updating and p_template_type = 'U' then
269: hr_utility.set_location(' Leaving:'||l_proc, 10);
270: fnd_message.set_name('PAY', 'PAY_50072_ETM_PRIORITY_UPDATE');
271: fnd_message.raise_error;
272: end if;
273: --
274: -- Check that the priority is not null.

Line 271: fnd_message.raise_error;

267: --
268: if l_api_updating and p_template_type = 'U' then
269: hr_utility.set_location(' Leaving:'||l_proc, 10);
270: fnd_message.set_name('PAY', 'PAY_50072_ETM_PRIORITY_UPDATE');
271: fnd_message.raise_error;
272: end if;
273: --
274: -- Check that the priority is not null.
275: --

Line 287: fnd_message.set_name('PAY', 'PAY_50073_ETM_PRIORITY_RANGE');

283: --
284: if p_base_processing_priority < l_lower or
285: p_base_processing_priority > l_upper then
286: hr_utility.set_location(' Leaving:'||l_proc, 15);
287: fnd_message.set_name('PAY', 'PAY_50073_ETM_PRIORITY_RANGE');
288: fnd_message.set_token('LOWER', l_lower);
289: fnd_message.set_token('UPPER', l_upper);
290: fnd_message.raise_error;
291: end if;

Line 288: fnd_message.set_token('LOWER', l_lower);

284: if p_base_processing_priority < l_lower or
285: p_base_processing_priority > l_upper then
286: hr_utility.set_location(' Leaving:'||l_proc, 15);
287: fnd_message.set_name('PAY', 'PAY_50073_ETM_PRIORITY_RANGE');
288: fnd_message.set_token('LOWER', l_lower);
289: fnd_message.set_token('UPPER', l_upper);
290: fnd_message.raise_error;
291: end if;
292: if l_api_updating then

Line 289: fnd_message.set_token('UPPER', l_upper);

285: p_base_processing_priority > l_upper then
286: hr_utility.set_location(' Leaving:'||l_proc, 15);
287: fnd_message.set_name('PAY', 'PAY_50073_ETM_PRIORITY_RANGE');
288: fnd_message.set_token('LOWER', l_lower);
289: fnd_message.set_token('UPPER', l_upper);
290: fnd_message.raise_error;
291: end if;
292: if l_api_updating then
293: open csr_priority_too_large;

Line 290: fnd_message.raise_error;

286: hr_utility.set_location(' Leaving:'||l_proc, 15);
287: fnd_message.set_name('PAY', 'PAY_50073_ETM_PRIORITY_RANGE');
288: fnd_message.set_token('LOWER', l_lower);
289: fnd_message.set_token('UPPER', l_upper);
290: fnd_message.raise_error;
291: end if;
292: if l_api_updating then
293: open csr_priority_too_large;
294: fetch csr_priority_too_large into l_too_large;

Line 297: fnd_message.set_name('PAY', 'PAY_50074_ETM_PRI_SUM_RANGE');

293: open csr_priority_too_large;
294: fetch csr_priority_too_large into l_too_large;
295: if csr_priority_too_large%found then
296: hr_utility.set_location(' Leaving:'||l_proc, 20);
297: fnd_message.set_name('PAY', 'PAY_50074_ETM_PRI_SUM_RANGE');
298: fnd_message.set_token('LOWER', l_lower);
299: fnd_message.set_token('UPPER', l_upper);
300: fnd_message.raise_error;
301: end if;

Line 298: fnd_message.set_token('LOWER', l_lower);

294: fetch csr_priority_too_large into l_too_large;
295: if csr_priority_too_large%found then
296: hr_utility.set_location(' Leaving:'||l_proc, 20);
297: fnd_message.set_name('PAY', 'PAY_50074_ETM_PRI_SUM_RANGE');
298: fnd_message.set_token('LOWER', l_lower);
299: fnd_message.set_token('UPPER', l_upper);
300: fnd_message.raise_error;
301: end if;
302: close csr_priority_too_large;

Line 299: fnd_message.set_token('UPPER', l_upper);

295: if csr_priority_too_large%found then
296: hr_utility.set_location(' Leaving:'||l_proc, 20);
297: fnd_message.set_name('PAY', 'PAY_50074_ETM_PRI_SUM_RANGE');
298: fnd_message.set_token('LOWER', l_lower);
299: fnd_message.set_token('UPPER', l_upper);
300: fnd_message.raise_error;
301: end if;
302: close csr_priority_too_large;
303: end if;

Line 300: fnd_message.raise_error;

296: hr_utility.set_location(' Leaving:'||l_proc, 20);
297: fnd_message.set_name('PAY', 'PAY_50074_ETM_PRI_SUM_RANGE');
298: fnd_message.set_token('LOWER', l_lower);
299: fnd_message.set_token('UPPER', l_upper);
300: fnd_message.raise_error;
301: end if;
302: close csr_priority_too_large;
303: end if;
304: end if;

Line 345: fnd_message.set_name('PAY', 'PAY_50084_ETM_VERSION_NO_UPD');

341: -- Version number may not be updated for template type = 'U'.
342: --
343: if l_api_updating and p_template_type = 'U' then
344: hr_utility.set_location(' Leaving:'||l_proc, 10);
345: fnd_message.set_name('PAY', 'PAY_50084_ETM_VERSION_NO_UPD');
346: fnd_message.raise_error;
347: end if;
348: --
349: -- Updated version number must not be less than the previous

Line 346: fnd_message.raise_error;

342: --
343: if l_api_updating and p_template_type = 'U' then
344: hr_utility.set_location(' Leaving:'||l_proc, 10);
345: fnd_message.set_name('PAY', 'PAY_50084_ETM_VERSION_NO_UPD');
346: fnd_message.raise_error;
347: end if;
348: --
349: -- Updated version number must not be less than the previous
350: -- version number.

Line 355: fnd_message.set_name('PAY', 'PAY_50083_ETM_LOWER_VERSION_NO');

351: --
352: if l_api_updating and
353: p_version_number < pay_etm_shd.g_old_rec.version_number then
354: hr_utility.set_location(' Leaving:'||l_proc, 15);
355: fnd_message.set_name('PAY', 'PAY_50083_ETM_LOWER_VERSION_NO');
356: fnd_message.raise_error;
357: end if;
358: end if;
359: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 356: fnd_message.raise_error;

352: if l_api_updating and
353: p_version_number < pay_etm_shd.g_old_rec.version_number then
354: hr_utility.set_location(' Leaving:'||l_proc, 15);
355: fnd_message.set_name('PAY', 'PAY_50083_ETM_LOWER_VERSION_NO');
356: fnd_message.raise_error;
357: end if;
358: end if;
359: hr_utility.set_location(' Leaving:'||l_proc, 20);
360: End chk_version_number;

Line 394: fnd_message.set_name('PAY', 'PAY_50082_ETM_BAD_TEMP_TYPE');

390: ,p_lookup_code => p_template_type
391: )
392: then
393: hr_utility.set_location(' Leaving:'||l_proc, 10);
394: fnd_message.set_name('PAY', 'PAY_50082_ETM_BAD_TEMP_TYPE');
395: fnd_message.set_token('TEMPLATE_TYPE', p_template_type);
396: fnd_message.raise_error;
397: end if;
398: --

Line 395: fnd_message.set_token('TEMPLATE_TYPE', p_template_type);

391: )
392: then
393: hr_utility.set_location(' Leaving:'||l_proc, 10);
394: fnd_message.set_name('PAY', 'PAY_50082_ETM_BAD_TEMP_TYPE');
395: fnd_message.set_token('TEMPLATE_TYPE', p_template_type);
396: fnd_message.raise_error;
397: end if;
398: --
399: -- The legislation_code must be null and the business_group_id

Line 396: fnd_message.raise_error;

392: then
393: hr_utility.set_location(' Leaving:'||l_proc, 10);
394: fnd_message.set_name('PAY', 'PAY_50082_ETM_BAD_TEMP_TYPE');
395: fnd_message.set_token('TEMPLATE_TYPE', p_template_type);
396: fnd_message.raise_error;
397: end if;
398: --
399: -- The legislation_code must be null and the business_group_id
400: -- not null if the template_type is 'U'.

Line 406: fnd_message.set_name('PAY', 'PAY_50081_ETM_BAD_BUS_GROUP');

402: if p_template_type = 'U' and
403: (p_legislation_code is not null or p_business_group_id is null)
404: then
405: hr_utility.set_location(' Leaving:'||l_proc, 20);
406: fnd_message.set_name('PAY', 'PAY_50081_ETM_BAD_BUS_GROUP');
407: fnd_message.raise_error;
408: end if;
409: hr_utility.set_location(' Leaving:'||l_proc, 20);
410: End chk_template_type;

Line 407: fnd_message.raise_error;

403: (p_legislation_code is not null or p_business_group_id is null)
404: then
405: hr_utility.set_location(' Leaving:'||l_proc, 20);
406: fnd_message.set_name('PAY', 'PAY_50081_ETM_BAD_BUS_GROUP');
407: fnd_message.raise_error;
408: end if;
409: hr_utility.set_location(' Leaving:'||l_proc, 20);
410: End chk_template_type;
411: -- ----------------------------------------------------------------------------

Line 452: fnd_message.set_name('PAY', 'PAY_50080_ETM_UPD_BASE_NM_LEN');

448: -- is 'U'
449: --
450: if l_api_updating and p_template_type = 'U' then
451: hr_utility.set_location(' Leaving:'||l_proc, 10);
452: fnd_message.set_name('PAY', 'PAY_50080_ETM_UPD_BASE_NM_LEN');
453: fnd_message.raise_error;
454: end if;
455: --
456: -- Check that the length is within limits.

Line 453: fnd_message.raise_error;

449: --
450: if l_api_updating and p_template_type = 'U' then
451: hr_utility.set_location(' Leaving:'||l_proc, 10);
452: fnd_message.set_name('PAY', 'PAY_50080_ETM_UPD_BASE_NM_LEN');
453: fnd_message.raise_error;
454: end if;
455: --
456: -- Check that the length is within limits.
457: --

Line 461: fnd_message.set_name('PAY', 'PAY_50079_ETM_BASE_NAME_LENGTH');

457: --
458: if p_max_base_name_length < l_lower or p_max_base_name_length > l_upper
459: then
460: hr_utility.set_location(' Leaving:'||l_proc, 15);
461: fnd_message.set_name('PAY', 'PAY_50079_ETM_BASE_NAME_LENGTH');
462: fnd_message.set_token('LOWER', l_lower);
463: fnd_message.set_token('UPPER', l_upper);
464: fnd_message.raise_error;
465: end if;

Line 462: fnd_message.set_token('LOWER', l_lower);

458: if p_max_base_name_length < l_lower or p_max_base_name_length > l_upper
459: then
460: hr_utility.set_location(' Leaving:'||l_proc, 15);
461: fnd_message.set_name('PAY', 'PAY_50079_ETM_BASE_NAME_LENGTH');
462: fnd_message.set_token('LOWER', l_lower);
463: fnd_message.set_token('UPPER', l_upper);
464: fnd_message.raise_error;
465: end if;
466: end if;

Line 463: fnd_message.set_token('UPPER', l_upper);

459: then
460: hr_utility.set_location(' Leaving:'||l_proc, 15);
461: fnd_message.set_name('PAY', 'PAY_50079_ETM_BASE_NAME_LENGTH');
462: fnd_message.set_token('LOWER', l_lower);
463: fnd_message.set_token('UPPER', l_upper);
464: fnd_message.raise_error;
465: end if;
466: end if;
467: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 464: fnd_message.raise_error;

460: hr_utility.set_location(' Leaving:'||l_proc, 15);
461: fnd_message.set_name('PAY', 'PAY_50079_ETM_BASE_NAME_LENGTH');
462: fnd_message.set_token('LOWER', l_lower);
463: fnd_message.set_token('UPPER', l_upper);
464: fnd_message.raise_error;
465: end if;
466: end if;
467: hr_utility.set_location(' Leaving:'||l_proc, 20);
468: End chk_max_base_name_length;

Line 514: fnd_message.set_name('PAY', 'PAY_50078_ETM_BASE_NM_NOT_NULL');

510: -- Check that the base name is null if template type is 'T'.
511: --
512: if p_template_type = 'T' and p_base_name is not null then
513: hr_utility.set_location(' Leaving:'||l_proc, 10);
514: fnd_message.set_name('PAY', 'PAY_50078_ETM_BASE_NM_NOT_NULL');
515: fnd_message.raise_error;
516: end if;
517: --
518: -- Return if template type is 'T'.

Line 515: fnd_message.raise_error;

511: --
512: if p_template_type = 'T' and p_base_name is not null then
513: hr_utility.set_location(' Leaving:'||l_proc, 10);
514: fnd_message.set_name('PAY', 'PAY_50078_ETM_BASE_NM_NOT_NULL');
515: fnd_message.raise_error;
516: end if;
517: --
518: -- Return if template type is 'T'.
519: --

Line 537: fnd_message.set_name('PAY', 'PAY_50077_ETM_LONG_BASE_NAME');

533: -- Check that the base name is not too long.
534: --
535: if lengthb(p_base_name) > p_max_base_name_length then
536: hr_utility.set_location(' Leaving:'||l_proc, 20);
537: fnd_message.set_name('PAY', 'PAY_50077_ETM_LONG_BASE_NAME');
538: fnd_message.set_token('BASE_NAME', p_base_name);
539: fnd_message.set_token('MAX_LENGTH', p_max_base_name_length);
540: fnd_message.raise_error;
541: end if;

Line 538: fnd_message.set_token('BASE_NAME', p_base_name);

534: --
535: if lengthb(p_base_name) > p_max_base_name_length then
536: hr_utility.set_location(' Leaving:'||l_proc, 20);
537: fnd_message.set_name('PAY', 'PAY_50077_ETM_LONG_BASE_NAME');
538: fnd_message.set_token('BASE_NAME', p_base_name);
539: fnd_message.set_token('MAX_LENGTH', p_max_base_name_length);
540: fnd_message.raise_error;
541: end if;
542: --

Line 539: fnd_message.set_token('MAX_LENGTH', p_max_base_name_length);

535: if lengthb(p_base_name) > p_max_base_name_length then
536: hr_utility.set_location(' Leaving:'||l_proc, 20);
537: fnd_message.set_name('PAY', 'PAY_50077_ETM_LONG_BASE_NAME');
538: fnd_message.set_token('BASE_NAME', p_base_name);
539: fnd_message.set_token('MAX_LENGTH', p_max_base_name_length);
540: fnd_message.raise_error;
541: end if;
542: --
543: -- Check that the base name format is correct (payroll name).

Line 540: fnd_message.raise_error;

536: hr_utility.set_location(' Leaving:'||l_proc, 20);
537: fnd_message.set_name('PAY', 'PAY_50077_ETM_LONG_BASE_NAME');
538: fnd_message.set_token('BASE_NAME', p_base_name);
539: fnd_message.set_token('MAX_LENGTH', p_max_base_name_length);
540: fnd_message.raise_error;
541: end if;
542: --
543: -- Check that the base name format is correct (payroll name).
544: --

Line 569: fnd_message.set_name('PAY', 'PAY_50076_ETM_BASE_NAME_EXISTS');

565: fetch csr_name_exists_for_template into l_exists;
566: if csr_name_exists_for_template%found then
567: hr_utility.set_location(' Leaving:'||l_proc, 22);
568: close csr_name_exists_for_template;
569: fnd_message.set_name('PAY', 'PAY_50076_ETM_BASE_NAME_EXISTS');
570: fnd_message.set_token('BASE_NAME', p_base_name);
571: fnd_message.raise_error;
572: end if;
573: close csr_name_exists_for_template;

Line 570: fnd_message.set_token('BASE_NAME', p_base_name);

566: if csr_name_exists_for_template%found then
567: hr_utility.set_location(' Leaving:'||l_proc, 22);
568: close csr_name_exists_for_template;
569: fnd_message.set_name('PAY', 'PAY_50076_ETM_BASE_NAME_EXISTS');
570: fnd_message.set_token('BASE_NAME', p_base_name);
571: fnd_message.raise_error;
572: end if;
573: close csr_name_exists_for_template;
574: else

Line 571: fnd_message.raise_error;

567: hr_utility.set_location(' Leaving:'||l_proc, 22);
568: close csr_name_exists_for_template;
569: fnd_message.set_name('PAY', 'PAY_50076_ETM_BASE_NAME_EXISTS');
570: fnd_message.set_token('BASE_NAME', p_base_name);
571: fnd_message.raise_error;
572: end if;
573: close csr_name_exists_for_template;
574: else
575: --

Line 584: fnd_message.set_name('PAY', 'PAY_50076_ETM_BASE_NAME_EXISTS');

580: fetch csr_base_name_exists into l_exists;
581: if csr_base_name_exists%found then
582: hr_utility.set_location(' Leaving:'||l_proc, 25);
583: close csr_base_name_exists;
584: fnd_message.set_name('PAY', 'PAY_50076_ETM_BASE_NAME_EXISTS');
585: fnd_message.set_token('BASE_NAME', p_base_name);
586: fnd_message.raise_error;
587: end if;
588: close csr_base_name_exists;

Line 585: fnd_message.set_token('BASE_NAME', p_base_name);

581: if csr_base_name_exists%found then
582: hr_utility.set_location(' Leaving:'||l_proc, 25);
583: close csr_base_name_exists;
584: fnd_message.set_name('PAY', 'PAY_50076_ETM_BASE_NAME_EXISTS');
585: fnd_message.set_token('BASE_NAME', p_base_name);
586: fnd_message.raise_error;
587: end if;
588: close csr_base_name_exists;
589: end if;

Line 586: fnd_message.raise_error;

582: hr_utility.set_location(' Leaving:'||l_proc, 25);
583: close csr_base_name_exists;
584: fnd_message.set_name('PAY', 'PAY_50076_ETM_BASE_NAME_EXISTS');
585: fnd_message.set_token('BASE_NAME', p_base_name);
586: fnd_message.raise_error;
587: end if;
588: close csr_base_name_exists;
589: end if;
590: hr_utility.set_location(' Leaving:'||l_proc, 30);

Line 666: fnd_message.set_name('PAY', 'PAY_50075_ETM_INVALID_DELETE');

662: close csr_core_objects;
663: hr_utility.set_location(' Leaving:'||l_proc, 30);
664: exception
665: when l_error then
666: fnd_message.set_name('PAY', 'PAY_50075_ETM_INVALID_DELETE');
667: fnd_message.raise_error;
668: when others then
669: hr_utility.set_location(' Leaving:'||l_proc, 35);
670: raise;

Line 667: fnd_message.raise_error;

663: hr_utility.set_location(' Leaving:'||l_proc, 30);
664: exception
665: when l_error then
666: fnd_message.set_name('PAY', 'PAY_50075_ETM_INVALID_DELETE');
667: fnd_message.raise_error;
668: when others then
669: hr_utility.set_location(' Leaving:'||l_proc, 35);
670: raise;
671: End chk_delete;