43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','10');
45: hr_utility.raise_error;
46: Else
47: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
50: fnd_message.raise_error;
51: End If;
44: hr_utility.set_message_token('STEP','10');
45: hr_utility.raise_error;
46: Else
47: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
50: fnd_message.raise_error;
51: End If;
52: --
45: hr_utility.raise_error;
46: Else
47: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
50: fnd_message.raise_error;
51: End If;
52: --
53: hr_utility.set_location(' Leaving:'||l_proc, 10);
46: Else
47: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
50: fnd_message.raise_error;
51: End If;
52: --
53: hr_utility.set_location(' Leaving:'||l_proc, 10);
54: End constraint_error;
256: if csr_magnetic_block_id%ROWCOUNT > 1 then
257:
258: close csr_magnetic_block_id;
259:
260: fnd_message.set_name( 'PAY' , 'PAY_33255_INV_SKEY' );
261: fnd_message.set_token( 'SURROGATE_ID' , 'MAGNETIC_BLOCK_ID' );
262: fnd_message.set_token( 'ENTITY' , 'MAGNETIC BLOCK' );
263: fnd_message.raise_error ;
264:
257:
258: close csr_magnetic_block_id;
259:
260: fnd_message.set_name( 'PAY' , 'PAY_33255_INV_SKEY' );
261: fnd_message.set_token( 'SURROGATE_ID' , 'MAGNETIC_BLOCK_ID' );
262: fnd_message.set_token( 'ENTITY' , 'MAGNETIC BLOCK' );
263: fnd_message.raise_error ;
264:
265: end if;
258: close csr_magnetic_block_id;
259:
260: fnd_message.set_name( 'PAY' , 'PAY_33255_INV_SKEY' );
261: fnd_message.set_token( 'SURROGATE_ID' , 'MAGNETIC_BLOCK_ID' );
262: fnd_message.set_token( 'ENTITY' , 'MAGNETIC BLOCK' );
263: fnd_message.raise_error ;
264:
265: end if;
266:
259:
260: fnd_message.set_name( 'PAY' , 'PAY_33255_INV_SKEY' );
261: fnd_message.set_token( 'SURROGATE_ID' , 'MAGNETIC_BLOCK_ID' );
262: fnd_message.set_token( 'ENTITY' , 'MAGNETIC BLOCK' );
263: fnd_message.raise_error ;
264:
265: end if;
266:
267: close csr_magnetic_block_id;