DBA Data[Home] [Help]

APPS.PAY_EVC_BUS dependencies on FND_MESSAGE

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

56: close csr_sec_grp;
57: --
58: -- The primary key is invalid therefore we must error
59: --
60: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
61: hr_multi_message.add
62: (p_associated_column1
63: => nvl(p_associated_column1,'EVENT_VALUE_CHANGE_ID')
64: );

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

133: --
134: -- The primary key is invalid therefore we must error
135: --
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --

Line 138: fnd_message.raise_error;

134: -- The primary key is invalid therefore we must error
135: --
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are

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

196: (p_event_value_change_id => p_rec.event_value_change_id
197: ,p_effective_date => p_effective_date
198: ,p_object_version_number => p_rec.object_version_number
199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
201: fnd_message.set_token('PROCEDURE ', l_proc);
202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;

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

197: ,p_effective_date => p_effective_date
198: ,p_object_version_number => p_rec.object_version_number
199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
201: fnd_message.set_token('PROCEDURE ', l_proc);
202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;
205: --

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

198: ,p_object_version_number => p_rec.object_version_number
199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
201: fnd_message.set_token('PROCEDURE ', l_proc);
202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;
205: --
206: -- Checks to ensure non-updateable args have

Line 203: fnd_message.raise_error;

199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
201: fnd_message.set_token('PROCEDURE ', l_proc);
202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;
205: --
206: -- Checks to ensure non-updateable args have
207: -- not been updated.

Line 313: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');

309: p_lookup_code => p_rec.default_event,
310: p_effective_date => p_effective_date)
311: then
312: hr_utility.set_location(' Leaving:'||l_proc, 10);
313: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
314: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
315: fnd_message.set_token('VALUE', p_rec.default_event);
316: fnd_message.raise_error;
317: end if;

Line 314: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');

310: p_effective_date => p_effective_date)
311: then
312: hr_utility.set_location(' Leaving:'||l_proc, 10);
313: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
314: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
315: fnd_message.set_token('VALUE', p_rec.default_event);
316: fnd_message.raise_error;
317: end if;
318: ELSE

Line 315: fnd_message.set_token('VALUE', p_rec.default_event);

311: then
312: hr_utility.set_location(' Leaving:'||l_proc, 10);
313: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
314: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
315: fnd_message.set_token('VALUE', p_rec.default_event);
316: fnd_message.raise_error;
317: end if;
318: ELSE
319: -- Validate against hr_standard_lookups as DateTracked and no bg context.

Line 316: fnd_message.raise_error;

312: hr_utility.set_location(' Leaving:'||l_proc, 10);
313: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
314: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
315: fnd_message.set_token('VALUE', p_rec.default_event);
316: fnd_message.raise_error;
317: end if;
318: ELSE
319: -- Validate against hr_standard_lookups as DateTracked and no bg context.
320: if hr_api.not_exists_in_dt_hrstanlookups

Line 329: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');

325: ,p_lookup_code => p_rec.default_event
326: )
327: then
328: hr_utility.set_location(' Leaving:'||l_proc, 10);
329: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
330: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
331: fnd_message.set_token('VALUE', p_rec.default_event);
332: fnd_message.raise_error;
333: end if;

Line 330: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');

326: )
327: then
328: hr_utility.set_location(' Leaving:'||l_proc, 10);
329: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
330: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
331: fnd_message.set_token('VALUE', p_rec.default_event);
332: fnd_message.raise_error;
333: end if;
334: END IF;

Line 331: fnd_message.set_token('VALUE', p_rec.default_event);

327: then
328: hr_utility.set_location(' Leaving:'||l_proc, 10);
329: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
330: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
331: fnd_message.set_token('VALUE', p_rec.default_event);
332: fnd_message.raise_error;
333: end if;
334: END IF;
335: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 332: fnd_message.raise_error;

328: hr_utility.set_location(' Leaving:'||l_proc, 10);
329: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
330: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
331: fnd_message.set_token('VALUE', p_rec.default_event);
332: fnd_message.raise_error;
333: end if;
334: END IF;
335: hr_utility.set_location(' Leaving:'||l_proc, 20);
336: End chk_default_event;

Line 390: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');

386: p_lookup_code => p_rec.valid_event,
387: p_effective_date => p_effective_date)
388: then
389: hr_utility.set_location(' Leaving:'||l_proc, 10);
390: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
391: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
392: fnd_message.set_token('VALUE', p_rec.valid_event);
393: fnd_message.raise_error;
394: end if;

Line 391: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');

387: p_effective_date => p_effective_date)
388: then
389: hr_utility.set_location(' Leaving:'||l_proc, 10);
390: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
391: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
392: fnd_message.set_token('VALUE', p_rec.valid_event);
393: fnd_message.raise_error;
394: end if;
395: ELSE

Line 392: fnd_message.set_token('VALUE', p_rec.valid_event);

388: then
389: hr_utility.set_location(' Leaving:'||l_proc, 10);
390: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
391: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
392: fnd_message.set_token('VALUE', p_rec.valid_event);
393: fnd_message.raise_error;
394: end if;
395: ELSE
396: -- Validate against hr_standard_lookups as DateTracked and no bg context.

Line 393: fnd_message.raise_error;

389: hr_utility.set_location(' Leaving:'||l_proc, 10);
390: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
391: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
392: fnd_message.set_token('VALUE', p_rec.valid_event);
393: fnd_message.raise_error;
394: end if;
395: ELSE
396: -- Validate against hr_standard_lookups as DateTracked and no bg context.
397: if hr_api.not_exists_in_dt_hrstanlookups

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

402: ,p_lookup_code => p_rec.valid_event
403: )
404: then
405: hr_utility.set_location(' Leaving:'||l_proc, 10);
406: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
407: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
408: fnd_message.set_token('VALUE', p_rec.valid_event);
409: fnd_message.raise_error;
410: end if;

Line 407: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');

403: )
404: then
405: hr_utility.set_location(' Leaving:'||l_proc, 10);
406: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
407: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
408: fnd_message.set_token('VALUE', p_rec.valid_event);
409: fnd_message.raise_error;
410: end if;
411: END IF;

Line 408: fnd_message.set_token('VALUE', p_rec.valid_event);

404: then
405: hr_utility.set_location(' Leaving:'||l_proc, 10);
406: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
407: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
408: fnd_message.set_token('VALUE', p_rec.valid_event);
409: fnd_message.raise_error;
410: end if;
411: END IF;
412: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 409: fnd_message.raise_error;

405: hr_utility.set_location(' Leaving:'||l_proc, 10);
406: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
407: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
408: fnd_message.set_token('VALUE', p_rec.valid_event);
409: fnd_message.raise_error;
410: end if;
411: END IF;
412: hr_utility.set_location(' Leaving:'||l_proc, 20);
413: End chk_valid_event;

Line 469: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');

465: p_lookup_code => p_rec.proration_style,
466: p_effective_date => p_effective_date)
467: then
468: hr_utility.set_location(' Leaving:'||l_proc, 10);
469: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
470: fnd_message.set_token('LOOKUP_TYPE', 'PAY_PRORATION_STYLE');
471: fnd_message.set_token('VALUE', p_rec.proration_style);
472: fnd_message.raise_error;
473: end if;

Line 470: fnd_message.set_token('LOOKUP_TYPE', 'PAY_PRORATION_STYLE');

466: p_effective_date => p_effective_date)
467: then
468: hr_utility.set_location(' Leaving:'||l_proc, 10);
469: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
470: fnd_message.set_token('LOOKUP_TYPE', 'PAY_PRORATION_STYLE');
471: fnd_message.set_token('VALUE', p_rec.proration_style);
472: fnd_message.raise_error;
473: end if;
474: ELSE

Line 471: fnd_message.set_token('VALUE', p_rec.proration_style);

467: then
468: hr_utility.set_location(' Leaving:'||l_proc, 10);
469: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
470: fnd_message.set_token('LOOKUP_TYPE', 'PAY_PRORATION_STYLE');
471: fnd_message.set_token('VALUE', p_rec.proration_style);
472: fnd_message.raise_error;
473: end if;
474: ELSE
475: -- Validate against hr_standard_lookups as DateTracked and no bg context.

Line 472: fnd_message.raise_error;

468: hr_utility.set_location(' Leaving:'||l_proc, 10);
469: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
470: fnd_message.set_token('LOOKUP_TYPE', 'PAY_PRORATION_STYLE');
471: fnd_message.set_token('VALUE', p_rec.proration_style);
472: fnd_message.raise_error;
473: end if;
474: ELSE
475: -- Validate against hr_standard_lookups as DateTracked and no bg context.
476: if hr_api.not_exists_in_dt_hrstanlookups

Line 485: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');

481: ,p_lookup_code => p_rec.proration_style
482: )
483: then
484: hr_utility.set_location(' Leaving:'||l_proc, 10);
485: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
486: fnd_message.set_token('LOOKUP_TYPE', 'PAY_PRORATION_STYLE');
487: fnd_message.set_token('VALUE', p_rec.proration_style);
488: fnd_message.raise_error;
489: end if;

Line 486: fnd_message.set_token('LOOKUP_TYPE', 'PAY_PRORATION_STYLE');

482: )
483: then
484: hr_utility.set_location(' Leaving:'||l_proc, 10);
485: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
486: fnd_message.set_token('LOOKUP_TYPE', 'PAY_PRORATION_STYLE');
487: fnd_message.set_token('VALUE', p_rec.proration_style);
488: fnd_message.raise_error;
489: end if;
490: END IF;

Line 487: fnd_message.set_token('VALUE', p_rec.proration_style);

483: then
484: hr_utility.set_location(' Leaving:'||l_proc, 10);
485: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
486: fnd_message.set_token('LOOKUP_TYPE', 'PAY_PRORATION_STYLE');
487: fnd_message.set_token('VALUE', p_rec.proration_style);
488: fnd_message.raise_error;
489: end if;
490: END IF;
491: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 488: fnd_message.raise_error;

484: hr_utility.set_location(' Leaving:'||l_proc, 10);
485: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
486: fnd_message.set_token('LOOKUP_TYPE', 'PAY_PRORATION_STYLE');
487: fnd_message.set_token('VALUE', p_rec.proration_style);
488: fnd_message.raise_error;
489: end if;
490: END IF;
491: hr_utility.set_location(' Leaving:'||l_proc, 20);
492: End chk_proration_style;

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

562: ,p_base_key_column => 'EVENT_QUALIFIER_ID'
563: ,p_base_key_value => p_event_qualifier_id
564: ,p_from_date => p_validation_start_date
565: ,p_to_date => p_validation_end_date))) Then
566: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
567: fnd_message.set_token('TABLE_NAME','event qualifiers');
568: hr_multi_message.add
569: (p_associated_column1 => pay_evc_shd.g_tab_nam || '.EVENT_QUALIFIER_ID');
570: End If;

Line 567: fnd_message.set_token('TABLE_NAME','event qualifiers');

563: ,p_base_key_value => p_event_qualifier_id
564: ,p_from_date => p_validation_start_date
565: ,p_to_date => p_validation_end_date))) Then
566: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
567: fnd_message.set_token('TABLE_NAME','event qualifiers');
568: hr_multi_message.add
569: (p_associated_column1 => pay_evc_shd.g_tab_nam || '.EVENT_QUALIFIER_ID');
570: End If;
571: --

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

574: --
575: -- An unhandled or unexpected error has occurred which
576: -- we must report
577: --
578: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
579: fnd_message.set_token('PROCEDURE', l_proc);
580: fnd_message.set_token('STEP','15');
581: fnd_message.raise_error;
582: End dt_update_validate;

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

575: -- An unhandled or unexpected error has occurred which
576: -- we must report
577: --
578: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
579: fnd_message.set_token('PROCEDURE', l_proc);
580: fnd_message.set_token('STEP','15');
581: fnd_message.raise_error;
582: End dt_update_validate;
583: --

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

576: -- we must report
577: --
578: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
579: fnd_message.set_token('PROCEDURE', l_proc);
580: fnd_message.set_token('STEP','15');
581: fnd_message.raise_error;
582: End dt_update_validate;
583: --
584: -- ----------------------------------------------------------------------------

Line 581: fnd_message.raise_error;

577: --
578: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
579: fnd_message.set_token('PROCEDURE', l_proc);
580: fnd_message.set_token('STEP','15');
581: fnd_message.raise_error;
582: End dt_update_validate;
583: --
584: -- ----------------------------------------------------------------------------
585: -- |--------------------------< dt_delete_validate >--------------------------|

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

671: --
672: -- An unhandled or unexpected error has occurred which
673: -- we must report
674: --
675: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
676: fnd_message.set_token('PROCEDURE', l_proc);
677: fnd_message.set_token('STEP','15');
678: fnd_message.raise_error;
679: --

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

672: -- An unhandled or unexpected error has occurred which
673: -- we must report
674: --
675: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
676: fnd_message.set_token('PROCEDURE', l_proc);
677: fnd_message.set_token('STEP','15');
678: fnd_message.raise_error;
679: --
680: End dt_delete_validate;

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

673: -- we must report
674: --
675: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
676: fnd_message.set_token('PROCEDURE', l_proc);
677: fnd_message.set_token('STEP','15');
678: fnd_message.raise_error;
679: --
680: End dt_delete_validate;
681: --

Line 678: fnd_message.raise_error;

674: --
675: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
676: fnd_message.set_token('PROCEDURE', l_proc);
677: fnd_message.set_token('STEP','15');
678: fnd_message.raise_error;
679: --
680: End dt_delete_validate;
681: --
682: -- ----------------------------------------------------------------------------