39: if csr_report_format_mapping_id%notfound then
40:
41: close csr_report_format_mapping_id;
42:
43: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
44: fnd_message.set_token('PARENT' , 'Report Format Mapping Id' );
45: fnd_message.raise_error;
46:
47: end if ;
40:
41: close csr_report_format_mapping_id;
42:
43: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
44: fnd_message.set_token('PARENT' , 'Report Format Mapping Id' );
45: fnd_message.raise_error;
46:
47: end if ;
48:
41: close csr_report_format_mapping_id;
42:
43: fnd_message.set_name('PAY', 'PAY_33174_PARENT_ID_INVALID');
44: fnd_message.set_token('PARENT' , 'Report Format Mapping Id' );
45: fnd_message.raise_error;
46:
47: end if ;
48:
49: close csr_report_format_mapping_id;
117: if csr_unique_key%found then
118:
119: close csr_unique_key;
120:
121: fnd_message.set_name( 'PAY' , 'PAY_33256_INV_UKEY1' );
122: fnd_message.set_token( 'COL1' , 'REPORT_FORMAT_MAPPING_ID');
123: fnd_message.set_token( 'COL2' , 'PARAMETER_NAME');
124: fnd_message.set_token( 'COL1_VAL', p_report_format_mapping_id);
125: fnd_message.set_token( 'COL2_VAL', p_parameter_name);
118:
119: close csr_unique_key;
120:
121: fnd_message.set_name( 'PAY' , 'PAY_33256_INV_UKEY1' );
122: fnd_message.set_token( 'COL1' , 'REPORT_FORMAT_MAPPING_ID');
123: fnd_message.set_token( 'COL2' , 'PARAMETER_NAME');
124: fnd_message.set_token( 'COL1_VAL', p_report_format_mapping_id);
125: fnd_message.set_token( 'COL2_VAL', p_parameter_name);
126: fnd_message.raise_error ;
119: close csr_unique_key;
120:
121: fnd_message.set_name( 'PAY' , 'PAY_33256_INV_UKEY1' );
122: fnd_message.set_token( 'COL1' , 'REPORT_FORMAT_MAPPING_ID');
123: fnd_message.set_token( 'COL2' , 'PARAMETER_NAME');
124: fnd_message.set_token( 'COL1_VAL', p_report_format_mapping_id);
125: fnd_message.set_token( 'COL2_VAL', p_parameter_name);
126: fnd_message.raise_error ;
127:
120:
121: fnd_message.set_name( 'PAY' , 'PAY_33256_INV_UKEY1' );
122: fnd_message.set_token( 'COL1' , 'REPORT_FORMAT_MAPPING_ID');
123: fnd_message.set_token( 'COL2' , 'PARAMETER_NAME');
124: fnd_message.set_token( 'COL1_VAL', p_report_format_mapping_id);
125: fnd_message.set_token( 'COL2_VAL', p_parameter_name);
126: fnd_message.raise_error ;
127:
128: end if ;
121: fnd_message.set_name( 'PAY' , 'PAY_33256_INV_UKEY1' );
122: fnd_message.set_token( 'COL1' , 'REPORT_FORMAT_MAPPING_ID');
123: fnd_message.set_token( 'COL2' , 'PARAMETER_NAME');
124: fnd_message.set_token( 'COL1_VAL', p_report_format_mapping_id);
125: fnd_message.set_token( 'COL2_VAL', p_parameter_name);
126: fnd_message.raise_error ;
127:
128: end if ;
129:
122: fnd_message.set_token( 'COL1' , 'REPORT_FORMAT_MAPPING_ID');
123: fnd_message.set_token( 'COL2' , 'PARAMETER_NAME');
124: fnd_message.set_token( 'COL1_VAL', p_report_format_mapping_id);
125: fnd_message.set_token( 'COL2_VAL', p_parameter_name);
126: fnd_message.raise_error ;
127:
128: end if ;
129:
130: close csr_unique_key;
221: (p_report_format_mapping_id => p_rec.report_format_mapping_id
222: ,p_parameter_name => p_rec.parameter_name
223: ,p_object_version_number => p_rec.object_version_number
224: ) THEN
225: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
226: fnd_message.set_token('PROCEDURE ', l_proc);
227: fnd_message.set_token('STEP ', '5');
228: fnd_message.raise_error;
229: END IF;
222: ,p_parameter_name => p_rec.parameter_name
223: ,p_object_version_number => p_rec.object_version_number
224: ) THEN
225: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
226: fnd_message.set_token('PROCEDURE ', l_proc);
227: fnd_message.set_token('STEP ', '5');
228: fnd_message.raise_error;
229: END IF;
230: --
223: ,p_object_version_number => p_rec.object_version_number
224: ) THEN
225: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
226: fnd_message.set_token('PROCEDURE ', l_proc);
227: fnd_message.set_token('STEP ', '5');
228: fnd_message.raise_error;
229: END IF;
230: --
231: End chk_non_updateable_args;
224: ) THEN
225: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
226: fnd_message.set_token('PROCEDURE ', l_proc);
227: fnd_message.set_token('STEP ', '5');
228: fnd_message.raise_error;
229: END IF;
230: --
231: End chk_non_updateable_args;
232: --