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