65: ,p_lookup_code => p_process
66: )
67: then
68: hr_utility.set_location(' Leaving:'||l_proc, 20);
69: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
70: fnd_message.set_token('LOOKUP_TYPE', 'PAY_RECORDED_REQUESTS');
71: fnd_message.set_token('VALUE', p_process);
72: fnd_message.raise_error;
73: end if;
66: )
67: then
68: hr_utility.set_location(' Leaving:'||l_proc, 20);
69: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
70: fnd_message.set_token('LOOKUP_TYPE', 'PAY_RECORDED_REQUESTS');
71: fnd_message.set_token('VALUE', p_process);
72: fnd_message.raise_error;
73: end if;
74:
67: then
68: hr_utility.set_location(' Leaving:'||l_proc, 20);
69: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
70: fnd_message.set_token('LOOKUP_TYPE', 'PAY_RECORDED_REQUESTS');
71: fnd_message.set_token('VALUE', p_process);
72: fnd_message.raise_error;
73: end if;
74:
75: INSERT INTO pay_recorded_requests(recorded_request_id,
68: hr_utility.set_location(' Leaving:'||l_proc, 20);
69: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
70: fnd_message.set_token('LOOKUP_TYPE', 'PAY_RECORDED_REQUESTS');
71: fnd_message.set_token('VALUE', p_process);
72: fnd_message.raise_error;
73: end if;
74:
75: INSERT INTO pay_recorded_requests(recorded_request_id,
76: recorded_date,