DBA Data[Home] [Help]

APPS.PAY_RFI_BUS dependencies on FND_MESSAGE

Line 93: fnd_message.set_name( 'PAY' , 'PAY_33258_INV_UKEY3' );

89: if csr_unique_key%found then
90:
91: close csr_unique_key;
92:
93: fnd_message.set_name( 'PAY' , 'PAY_33258_INV_UKEY3' );
94: fnd_message.set_token( 'COL1' , 'REPORT_TYPE');
95: fnd_message.set_token( 'COL2' , 'REPORT_QUALIFIER');
96: fnd_message.set_token( 'COL3' , 'REPORT_CATEGORY');
97: fnd_message.set_token( 'COL4' , 'USER_ENTITY_ID');

Line 94: fnd_message.set_token( 'COL1' , 'REPORT_TYPE');

90:
91: close csr_unique_key;
92:
93: fnd_message.set_name( 'PAY' , 'PAY_33258_INV_UKEY3' );
94: fnd_message.set_token( 'COL1' , 'REPORT_TYPE');
95: fnd_message.set_token( 'COL2' , 'REPORT_QUALIFIER');
96: fnd_message.set_token( 'COL3' , 'REPORT_CATEGORY');
97: fnd_message.set_token( 'COL4' , 'USER_ENTITY_ID');
98: fnd_message.set_token( 'COL1_VAL', p_report_type);

Line 95: fnd_message.set_token( 'COL2' , 'REPORT_QUALIFIER');

91: close csr_unique_key;
92:
93: fnd_message.set_name( 'PAY' , 'PAY_33258_INV_UKEY3' );
94: fnd_message.set_token( 'COL1' , 'REPORT_TYPE');
95: fnd_message.set_token( 'COL2' , 'REPORT_QUALIFIER');
96: fnd_message.set_token( 'COL3' , 'REPORT_CATEGORY');
97: fnd_message.set_token( 'COL4' , 'USER_ENTITY_ID');
98: fnd_message.set_token( 'COL1_VAL', p_report_type);
99: fnd_message.set_token( 'COL2_VAL', p_report_qualifier);

Line 96: fnd_message.set_token( 'COL3' , 'REPORT_CATEGORY');

92:
93: fnd_message.set_name( 'PAY' , 'PAY_33258_INV_UKEY3' );
94: fnd_message.set_token( 'COL1' , 'REPORT_TYPE');
95: fnd_message.set_token( 'COL2' , 'REPORT_QUALIFIER');
96: fnd_message.set_token( 'COL3' , 'REPORT_CATEGORY');
97: fnd_message.set_token( 'COL4' , 'USER_ENTITY_ID');
98: fnd_message.set_token( 'COL1_VAL', p_report_type);
99: fnd_message.set_token( 'COL2_VAL', p_report_qualifier);
100: fnd_message.set_token( 'COL3_VAL', p_report_category);

Line 97: fnd_message.set_token( 'COL4' , 'USER_ENTITY_ID');

93: fnd_message.set_name( 'PAY' , 'PAY_33258_INV_UKEY3' );
94: fnd_message.set_token( 'COL1' , 'REPORT_TYPE');
95: fnd_message.set_token( 'COL2' , 'REPORT_QUALIFIER');
96: fnd_message.set_token( 'COL3' , 'REPORT_CATEGORY');
97: fnd_message.set_token( 'COL4' , 'USER_ENTITY_ID');
98: fnd_message.set_token( 'COL1_VAL', p_report_type);
99: fnd_message.set_token( 'COL2_VAL', p_report_qualifier);
100: fnd_message.set_token( 'COL3_VAL', p_report_category);
101: fnd_message.set_token( 'COL4_VAL', p_user_entity_id);

Line 98: fnd_message.set_token( 'COL1_VAL', p_report_type);

94: fnd_message.set_token( 'COL1' , 'REPORT_TYPE');
95: fnd_message.set_token( 'COL2' , 'REPORT_QUALIFIER');
96: fnd_message.set_token( 'COL3' , 'REPORT_CATEGORY');
97: fnd_message.set_token( 'COL4' , 'USER_ENTITY_ID');
98: fnd_message.set_token( 'COL1_VAL', p_report_type);
99: fnd_message.set_token( 'COL2_VAL', p_report_qualifier);
100: fnd_message.set_token( 'COL3_VAL', p_report_category);
101: fnd_message.set_token( 'COL4_VAL', p_user_entity_id);
102: fnd_message.raise_error ;

Line 99: fnd_message.set_token( 'COL2_VAL', p_report_qualifier);

95: fnd_message.set_token( 'COL2' , 'REPORT_QUALIFIER');
96: fnd_message.set_token( 'COL3' , 'REPORT_CATEGORY');
97: fnd_message.set_token( 'COL4' , 'USER_ENTITY_ID');
98: fnd_message.set_token( 'COL1_VAL', p_report_type);
99: fnd_message.set_token( 'COL2_VAL', p_report_qualifier);
100: fnd_message.set_token( 'COL3_VAL', p_report_category);
101: fnd_message.set_token( 'COL4_VAL', p_user_entity_id);
102: fnd_message.raise_error ;
103:

Line 100: fnd_message.set_token( 'COL3_VAL', p_report_category);

96: fnd_message.set_token( 'COL3' , 'REPORT_CATEGORY');
97: fnd_message.set_token( 'COL4' , 'USER_ENTITY_ID');
98: fnd_message.set_token( 'COL1_VAL', p_report_type);
99: fnd_message.set_token( 'COL2_VAL', p_report_qualifier);
100: fnd_message.set_token( 'COL3_VAL', p_report_category);
101: fnd_message.set_token( 'COL4_VAL', p_user_entity_id);
102: fnd_message.raise_error ;
103:
104: end if ;

Line 101: fnd_message.set_token( 'COL4_VAL', p_user_entity_id);

97: fnd_message.set_token( 'COL4' , 'USER_ENTITY_ID');
98: fnd_message.set_token( 'COL1_VAL', p_report_type);
99: fnd_message.set_token( 'COL2_VAL', p_report_qualifier);
100: fnd_message.set_token( 'COL3_VAL', p_report_category);
101: fnd_message.set_token( 'COL4_VAL', p_user_entity_id);
102: fnd_message.raise_error ;
103:
104: end if ;
105:

Line 102: fnd_message.raise_error ;

98: fnd_message.set_token( 'COL1_VAL', p_report_type);
99: fnd_message.set_token( 'COL2_VAL', p_report_qualifier);
100: fnd_message.set_token( 'COL3_VAL', p_report_category);
101: fnd_message.set_token( 'COL4_VAL', p_user_entity_id);
102: fnd_message.raise_error ;
103:
104: end if ;
105:
106: close csr_unique_key;

Line 186: fnd_message.set_name( 'PAY' , 'PAY_33260_INVALID_RFM' );

182: if csr_report_format_mapping%notfound then
183:
184: close csr_report_format_mapping;
185:
186: fnd_message.set_name( 'PAY' , 'PAY_33260_INVALID_RFM' );
187: fnd_message.set_token( 'COL1' , p_report_type);
188: fnd_message.set_token( 'COL2' , p_report_qualifier);
189: fnd_message.set_token( 'COL3' , p_report_category);
190: fnd_message.raise_error ;

Line 187: fnd_message.set_token( 'COL1' , p_report_type);

183:
184: close csr_report_format_mapping;
185:
186: fnd_message.set_name( 'PAY' , 'PAY_33260_INVALID_RFM' );
187: fnd_message.set_token( 'COL1' , p_report_type);
188: fnd_message.set_token( 'COL2' , p_report_qualifier);
189: fnd_message.set_token( 'COL3' , p_report_category);
190: fnd_message.raise_error ;
191:

Line 188: fnd_message.set_token( 'COL2' , p_report_qualifier);

184: close csr_report_format_mapping;
185:
186: fnd_message.set_name( 'PAY' , 'PAY_33260_INVALID_RFM' );
187: fnd_message.set_token( 'COL1' , p_report_type);
188: fnd_message.set_token( 'COL2' , p_report_qualifier);
189: fnd_message.set_token( 'COL3' , p_report_category);
190: fnd_message.raise_error ;
191:
192: end if ;

Line 189: fnd_message.set_token( 'COL3' , p_report_category);

185:
186: fnd_message.set_name( 'PAY' , 'PAY_33260_INVALID_RFM' );
187: fnd_message.set_token( 'COL1' , p_report_type);
188: fnd_message.set_token( 'COL2' , p_report_qualifier);
189: fnd_message.set_token( 'COL3' , p_report_category);
190: fnd_message.raise_error ;
191:
192: end if ;
193:

Line 190: fnd_message.raise_error ;

186: fnd_message.set_name( 'PAY' , 'PAY_33260_INVALID_RFM' );
187: fnd_message.set_token( 'COL1' , p_report_type);
188: fnd_message.set_token( 'COL2' , p_report_qualifier);
189: fnd_message.set_token( 'COL3' , p_report_category);
190: fnd_message.raise_error ;
191:
192: end if ;
193:
194: close csr_report_format_mapping;

Line 259: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');

255: if csr_user_entity_id%notfound then
256:
257: close csr_user_entity_id;
258:
259: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
260: fnd_message.set_token('PARENT' , 'User Entity Id' );
261: fnd_message.raise_error;
262:
263: end if ;

Line 260: fnd_message.set_token('PARENT' , 'User Entity Id' );

256:
257: close csr_user_entity_id;
258:
259: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
260: fnd_message.set_token('PARENT' , 'User Entity Id' );
261: fnd_message.raise_error;
262:
263: end if ;
264:

Line 261: fnd_message.raise_error;

257: close csr_user_entity_id;
258:
259: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
260: fnd_message.set_token('PARENT' , 'User Entity Id' );
261: fnd_message.raise_error;
262:
263: end if ;
264:
265: close csr_user_entity_id;

Line 311: fnd_message.set_name( 'PAY' , 'PAY_33259_INVALID_UFLAG' );

307:
308: if p_updatable_flag is not null and
309: p_updatable_flag not in ('Y', 'N') then
310:
311: fnd_message.set_name( 'PAY' , 'PAY_33259_INVALID_UFLAG' );
312: fnd_message.raise_error ;
313:
314: end if;
315: --

Line 312: fnd_message.raise_error ;

308: if p_updatable_flag is not null and
309: p_updatable_flag not in ('Y', 'N') then
310:
311: fnd_message.set_name( 'PAY' , 'PAY_33259_INVALID_UFLAG' );
312: fnd_message.raise_error ;
313:
314: end if;
315: --
316: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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

360: (p_report_format_item_id => p_rec.report_format_item_id
361: ,p_effective_date => p_effective_date
362: ,p_object_version_number => p_rec.object_version_number
363: ) THEN
364: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
365: fnd_message.set_token('PROCEDURE ', l_proc);
366: fnd_message.set_token('STEP ', '5');
367: fnd_message.raise_error;
368: END IF;

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

361: ,p_effective_date => p_effective_date
362: ,p_object_version_number => p_rec.object_version_number
363: ) THEN
364: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
365: fnd_message.set_token('PROCEDURE ', l_proc);
366: fnd_message.set_token('STEP ', '5');
367: fnd_message.raise_error;
368: END IF;
369: --

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

362: ,p_object_version_number => p_rec.object_version_number
363: ) THEN
364: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
365: fnd_message.set_token('PROCEDURE ', l_proc);
366: fnd_message.set_token('STEP ', '5');
367: fnd_message.raise_error;
368: END IF;
369: --
370: --

Line 367: fnd_message.raise_error;

363: ) THEN
364: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
365: fnd_message.set_token('PROCEDURE ', l_proc);
366: fnd_message.set_token('STEP ', '5');
367: fnd_message.raise_error;
368: END IF;
369: --
370: --
371: if nvl(p_rec.report_type, hr_api.g_varchar2) <>

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

476: ,p_base_key_column => 'REPORT_FORMAT_MAPPING_ID'
477: ,p_base_key_value => p_report_format_mapping_id
478: ,p_from_date => p_validation_start_date
479: ,p_to_date => p_validation_end_date))) Then
480: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
481: fnd_message.set_token('TABLE_NAME','report format mappings');
482: hr_multi_message.add
483: (p_associated_column1 => pay_rfi_shd.g_tab_nam || '.REPORT_FORMAT_MAPPING
484: _ID');

Line 481: fnd_message.set_token('TABLE_NAME','report format mappings');

477: ,p_base_key_value => p_report_format_mapping_id
478: ,p_from_date => p_validation_start_date
479: ,p_to_date => p_validation_end_date))) Then
480: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
481: fnd_message.set_token('TABLE_NAME','report format mappings');
482: hr_multi_message.add
483: (p_associated_column1 => pay_rfi_shd.g_tab_nam || '.REPORT_FORMAT_MAPPING
484: _ID');
485: End If;

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

489: --
490: -- An unhandled or unexpected error has occurred which
491: -- we must report
492: --
493: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
494: fnd_message.set_token('PROCEDURE', l_proc);
495: fnd_message.set_token('STEP','15');
496: fnd_message.raise_error;
497: End dt_update_validate;

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

490: -- An unhandled or unexpected error has occurred which
491: -- we must report
492: --
493: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
494: fnd_message.set_token('PROCEDURE', l_proc);
495: fnd_message.set_token('STEP','15');
496: fnd_message.raise_error;
497: End dt_update_validate;
498: --

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

491: -- we must report
492: --
493: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
494: fnd_message.set_token('PROCEDURE', l_proc);
495: fnd_message.set_token('STEP','15');
496: fnd_message.raise_error;
497: End dt_update_validate;
498: --
499: -- ----------------------------------------------------------------------------

Line 496: fnd_message.raise_error;

492: --
493: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
494: fnd_message.set_token('PROCEDURE', l_proc);
495: fnd_message.set_token('STEP','15');
496: fnd_message.raise_error;
497: End dt_update_validate;
498: --
499: -- ----------------------------------------------------------------------------
500: -- |--------------------------< dt_delete_validate >--------------------------|

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

586: --
587: -- An unhandled or unexpected error has occurred which
588: -- we must report
589: --
590: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
591: fnd_message.set_token('PROCEDURE', l_proc);
592: fnd_message.set_token('STEP','15');
593: fnd_message.raise_error;
594: --

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

587: -- An unhandled or unexpected error has occurred which
588: -- we must report
589: --
590: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
591: fnd_message.set_token('PROCEDURE', l_proc);
592: fnd_message.set_token('STEP','15');
593: fnd_message.raise_error;
594: --
595: End dt_delete_validate;

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

588: -- we must report
589: --
590: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
591: fnd_message.set_token('PROCEDURE', l_proc);
592: fnd_message.set_token('STEP','15');
593: fnd_message.raise_error;
594: --
595: End dt_delete_validate;
596: --

Line 593: fnd_message.raise_error;

589: --
590: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
591: fnd_message.set_token('PROCEDURE', l_proc);
592: fnd_message.set_token('STEP','15');
593: fnd_message.raise_error;
594: --
595: End dt_delete_validate;
596: --
597: -- ----------------------------------------------------------------------------