72: if csr_unique_key%found then
73:
74: close csr_unique_key;
75:
76: fnd_message.set_name( 'PAY' , 'PAY_33256_INV_UKEY1' );
77: fnd_message.set_token( 'COL1' , 'BLOCK_NAME');
78: fnd_message.set_token( 'COL2' , 'REPORT_FORMAT');
79: fnd_message.set_token( 'COL1_VAL', p_block_name);
80: fnd_message.set_token( 'COL2_VAL', p_report_format);
73:
74: close csr_unique_key;
75:
76: fnd_message.set_name( 'PAY' , 'PAY_33256_INV_UKEY1' );
77: fnd_message.set_token( 'COL1' , 'BLOCK_NAME');
78: fnd_message.set_token( 'COL2' , 'REPORT_FORMAT');
79: fnd_message.set_token( 'COL1_VAL', p_block_name);
80: fnd_message.set_token( 'COL2_VAL', p_report_format);
81: fnd_message.raise_error ;
74: close csr_unique_key;
75:
76: fnd_message.set_name( 'PAY' , 'PAY_33256_INV_UKEY1' );
77: fnd_message.set_token( 'COL1' , 'BLOCK_NAME');
78: fnd_message.set_token( 'COL2' , 'REPORT_FORMAT');
79: fnd_message.set_token( 'COL1_VAL', p_block_name);
80: fnd_message.set_token( 'COL2_VAL', p_report_format);
81: fnd_message.raise_error ;
82:
75:
76: fnd_message.set_name( 'PAY' , 'PAY_33256_INV_UKEY1' );
77: fnd_message.set_token( 'COL1' , 'BLOCK_NAME');
78: fnd_message.set_token( 'COL2' , 'REPORT_FORMAT');
79: fnd_message.set_token( 'COL1_VAL', p_block_name);
80: fnd_message.set_token( 'COL2_VAL', p_report_format);
81: fnd_message.raise_error ;
82:
83: end if ;
76: fnd_message.set_name( 'PAY' , 'PAY_33256_INV_UKEY1' );
77: fnd_message.set_token( 'COL1' , 'BLOCK_NAME');
78: fnd_message.set_token( 'COL2' , 'REPORT_FORMAT');
79: fnd_message.set_token( 'COL1_VAL', p_block_name);
80: fnd_message.set_token( 'COL2_VAL', p_report_format);
81: fnd_message.raise_error ;
82:
83: end if ;
84:
77: fnd_message.set_token( 'COL1' , 'BLOCK_NAME');
78: fnd_message.set_token( 'COL2' , 'REPORT_FORMAT');
79: fnd_message.set_token( 'COL1_VAL', p_block_name);
80: fnd_message.set_token( 'COL2_VAL', p_report_format);
81: fnd_message.raise_error ;
82:
83: end if ;
84:
85: close csr_unique_key;
128: --
129: IF NOT pay_mgb_shd.api_updating
130: (p_magnetic_block_id => p_rec.magnetic_block_id
131: ) THEN
132: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
133: fnd_message.set_token('PROCEDURE ', l_proc);
134: fnd_message.set_token('STEP ', '5');
135: fnd_message.raise_error;
136: END IF;
129: IF NOT pay_mgb_shd.api_updating
130: (p_magnetic_block_id => p_rec.magnetic_block_id
131: ) THEN
132: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
133: fnd_message.set_token('PROCEDURE ', l_proc);
134: fnd_message.set_token('STEP ', '5');
135: fnd_message.raise_error;
136: END IF;
137: --
130: (p_magnetic_block_id => p_rec.magnetic_block_id
131: ) THEN
132: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
133: fnd_message.set_token('PROCEDURE ', l_proc);
134: fnd_message.set_token('STEP ', '5');
135: fnd_message.raise_error;
136: END IF;
137: --
138: --
131: ) THEN
132: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
133: fnd_message.set_token('PROCEDURE ', l_proc);
134: fnd_message.set_token('STEP ', '5');
135: fnd_message.raise_error;
136: END IF;
137: --
138: --
139: if nvl(p_rec.block_name, hr_api.g_varchar2) <>