eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CANDIDATE_UTILS dependencies on FND_API

Line 131: x_return_status := FND_API.G_RET_STS_SUCCESS;

127: -- Initialize the Error Stack
128: PA_DEBUG.init_err_stack('PA_CANDIDATE_PUB.Reverse_Candidate_Status');
129:
130: -- initialize return_status to success
131: x_return_status := FND_API.G_RET_STS_SUCCESS;
132: x_error_message_code := NULL;
133:
134: BEGIN
135: SELECT candidate_id,

Line 186: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

182: x_msg_data => l_msg_data,
183: x_return_status => l_return_status);
184:
185: -- 4537865 : Start
186: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
187: l_record_version_number := l_new_record_version_number ;
188: END IF;
189: -- End : 4537865
190: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 190: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN

186: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
187: l_record_version_number := l_new_record_version_number ;
188: END IF;
189: -- End : 4537865
190: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
191: RAISE FND_API.G_EXC_ERROR;
192: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;

Line 191: RAISE FND_API.G_EXC_ERROR;

187: l_record_version_number := l_new_record_version_number ;
188: END IF;
189: -- End : 4537865
190: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
191: RAISE FND_API.G_EXC_ERROR;
192: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195:

Line 192: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

188: END IF;
189: -- End : 4537865
190: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
191: RAISE FND_API.G_EXC_ERROR;
192: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195:
196: EXCEPTION

Line 193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

189: -- End : 4537865
190: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
191: RAISE FND_API.G_EXC_ERROR;
192: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195:
196: EXCEPTION
197: WHEN FND_API.G_EXC_ERROR THEN

Line 197: WHEN FND_API.G_EXC_ERROR THEN

193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195:
196: EXCEPTION
197: WHEN FND_API.G_EXC_ERROR THEN
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: x_error_message_code := l_msg_data;
200:
201: WHEN OTHERS THEN

Line 198: x_return_status := FND_API.G_RET_STS_ERROR;

194: END IF;
195:
196: EXCEPTION
197: WHEN FND_API.G_EXC_ERROR THEN
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: x_error_message_code := l_msg_data;
200:
201: WHEN OTHERS THEN
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

198: x_return_status := FND_API.G_RET_STS_ERROR;
199: x_error_message_code := l_msg_data;
200:
201: WHEN OTHERS THEN
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: x_error_message_code := SQLCODE; -- 4537865
204: RAISE;
205:
206: END Reverse_Candidate_Status;

Line 484: x_return_status := FND_API.G_RET_STS_SUCCESS;

480: BEGIN
481:
482: PA_DEBUG.init_err_stack('PA_CANDIDATE_UTIL.Update_No_Of_Active_Candidates');
483:
484: x_return_status := FND_API.G_RET_STS_SUCCESS;
485:
486: SELECT count(*)
487: INTO l_no_of_active_candidates
488: FROM pa_candidates cand,

Line 516: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

512: p_no_of_active_candidates => l_no_of_active_candidates,
513: p_record_version_number => l_record_version_number,
514: x_return_status => l_return_status );
515:
516: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
517: RAISE FND_API.G_EXC_ERROR;
518: END IF;
519:
520: EXCEPTION

Line 517: RAISE FND_API.G_EXC_ERROR;

513: p_record_version_number => l_record_version_number,
514: x_return_status => l_return_status );
515:
516: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
517: RAISE FND_API.G_EXC_ERROR;
518: END IF;
519:
520: EXCEPTION
521: WHEN OTHERS THEN

Line 522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

518: END IF;
519:
520: EXCEPTION
521: WHEN OTHERS THEN
522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
523:
524: fnd_msg_pub.add_exc_msg
525: (p_pkg_name => 'PA_CANDIDATE_UTIL',
526: p_procedure_name => 'Update_No_Of_Active_Candidates' );