DBA Data[Home] [Help]

APPS.PAY_BALANCES_UPLOAD_PKG dependencies on FND_MESSAGE

Line 511: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

507:
508: if (l_temp_attribute_id is not NULL)then
509: --raise error ask to rerun the ldts after deleting the child
510: --rows
511: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
512: fnd_message.set_token('TABLE_NAME',
513: 'PAY_BAL_ATTRIBUTE_DEFINITIONS');
514: fnd_message.raise_error;
515: end if;

Line 512: fnd_message.set_token('TABLE_NAME',

508: if (l_temp_attribute_id is not NULL)then
509: --raise error ask to rerun the ldts after deleting the child
510: --rows
511: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
512: fnd_message.set_token('TABLE_NAME',
513: 'PAY_BAL_ATTRIBUTE_DEFINITIONS');
514: fnd_message.raise_error;
515: end if;
516:

Line 514: fnd_message.raise_error;

510: --rows
511: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
512: fnd_message.set_token('TABLE_NAME',
513: 'PAY_BAL_ATTRIBUTE_DEFINITIONS');
514: fnd_message.raise_error;
515: end if;
516:
517: open csr_pbad_id(l_attribute_id);
518: fetch csr_pbad_id into l_temp_attribute_id;

Line 524: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

520:
521: if(l_temp_attribute_id is not NULL)then
522: --raise error ask to rerun the ldts after deleting the child
523: --rows
524: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
525: fnd_message.set_token('TABLE_NAME',
526: 'PAY_BAL_ATTRIBUTE_DEFINITIONS');
527: fnd_message.raise_error;
528: end if;

Line 525: fnd_message.set_token('TABLE_NAME',

521: if(l_temp_attribute_id is not NULL)then
522: --raise error ask to rerun the ldts after deleting the child
523: --rows
524: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
525: fnd_message.set_token('TABLE_NAME',
526: 'PAY_BAL_ATTRIBUTE_DEFINITIONS');
527: fnd_message.raise_error;
528: end if;
529:

Line 527: fnd_message.raise_error;

523: --rows
524: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
525: fnd_message.set_token('TABLE_NAME',
526: 'PAY_BAL_ATTRIBUTE_DEFINITIONS');
527: fnd_message.raise_error;
528: end if;
529:
530: update PAY_BAL_ATTRIBUTE_DEFINITIONS
531: set ALTERABLE =p_ALTERABLE