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 127: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 165: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

161: x_msg_data => l_msg_data,
162: x_return_status => l_return_status);
163:
164: -- 4537865 : Start
165: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
166: l_record_version_number := l_new_record_version_number ;
167: END IF;
168: -- End : 4537865
169: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

165: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
166: l_record_version_number := l_new_record_version_number ;
167: END IF;
168: -- End : 4537865
169: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
170: RAISE FND_API.G_EXC_ERROR;
171: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;

Line 170: RAISE FND_API.G_EXC_ERROR;

166: l_record_version_number := l_new_record_version_number ;
167: END IF;
168: -- End : 4537865
169: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
170: RAISE FND_API.G_EXC_ERROR;
171: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174:

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

167: END IF;
168: -- End : 4537865
169: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
170: RAISE FND_API.G_EXC_ERROR;
171: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174:
175: EXCEPTION

Line 172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

168: -- End : 4537865
169: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
170: RAISE FND_API.G_EXC_ERROR;
171: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174:
175: EXCEPTION
176: WHEN FND_API.G_EXC_ERROR THEN

Line 176: WHEN FND_API.G_EXC_ERROR THEN

172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174:
175: EXCEPTION
176: WHEN FND_API.G_EXC_ERROR THEN
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: x_error_message_code := l_msg_data;
179:
180: WHEN OTHERS THEN

Line 177: x_return_status := FND_API.G_RET_STS_ERROR;

173: END IF;
174:
175: EXCEPTION
176: WHEN FND_API.G_EXC_ERROR THEN
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: x_error_message_code := l_msg_data;
179:
180: WHEN OTHERS THEN
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

177: x_return_status := FND_API.G_RET_STS_ERROR;
178: x_error_message_code := l_msg_data;
179:
180: WHEN OTHERS THEN
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: x_error_message_code := SQLCODE; -- 4537865
183: RAISE;
184:
185: END Reverse_Candidate_Status;

Line 463: x_return_status := FND_API.G_RET_STS_SUCCESS;

459: BEGIN
460:
461: PA_DEBUG.init_err_stack('PA_CANDIDATE_UTIL.Update_No_Of_Active_Candidates');
462:
463: x_return_status := FND_API.G_RET_STS_SUCCESS;
464:
465: SELECT count(*)
466: INTO l_no_of_active_candidates
467: FROM pa_candidates cand,

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

491: p_no_of_active_candidates => l_no_of_active_candidates,
492: p_record_version_number => l_record_version_number,
493: x_return_status => l_return_status );
494:
495: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498:
499: EXCEPTION

Line 496: RAISE FND_API.G_EXC_ERROR;

492: p_record_version_number => l_record_version_number,
493: x_return_status => l_return_status );
494:
495: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498:
499: EXCEPTION
500: WHEN OTHERS THEN

Line 501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

497: END IF;
498:
499: EXCEPTION
500: WHEN OTHERS THEN
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502:
503: fnd_msg_pub.add_exc_msg
504: (p_pkg_name => 'PA_CANDIDATE_UTIL',
505: p_procedure_name => 'Update_No_Of_Active_Candidates' );