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_JOB_UTILS dependencies on FND_API

Line 49: IF p_job_id IS NOT NULL AND p_job_id<>FND_API.G_MISS_NUM THEN

45: x_job_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
46: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
47: x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
48: BEGIN
49: IF p_job_id IS NOT NULL AND p_job_id<>FND_API.G_MISS_NUM THEN
50: IF p_check_id_flag = 'Y' THEN
51: SELECT job_id
52: INTO x_job_id
53: FROM per_jobs

Line 68: x_return_status := FND_API.G_RET_STS_SUCCESS;

64: WHERE name = p_job_name
65: AND job_group_id = nvl(p_job_group_id, job_group_id) -- 5130421
66: ;
67: END IF;
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: EXCEPTION
71: WHEN NO_DATA_FOUND THEN
72: x_return_status := FND_API.G_RET_STS_ERROR;

Line 72: x_return_status := FND_API.G_RET_STS_ERROR;

68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: EXCEPTION
71: WHEN NO_DATA_FOUND THEN
72: x_return_status := FND_API.G_RET_STS_ERROR;
73: x_error_message_code := 'PA_JOB_INVALID_AMBIGUOUS';
74: WHEN TOO_MANY_ROWS THEN
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: x_error_message_code := 'PA_JOB_INVALID_AMBIGUOUS';

Line 75: x_return_status := FND_API.G_RET_STS_ERROR;

71: WHEN NO_DATA_FOUND THEN
72: x_return_status := FND_API.G_RET_STS_ERROR;
73: x_error_message_code := 'PA_JOB_INVALID_AMBIGUOUS';
74: WHEN TOO_MANY_ROWS THEN
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: x_error_message_code := 'PA_JOB_INVALID_AMBIGUOUS';
77: WHEN OTHERS THEN
78: --PA_Error_Utils.Set_Error_Stack
79: -- (`pa_job_utils.check_jobname_or_id');

Line 82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

78: --PA_Error_Utils.Set_Error_Stack
79: -- (`pa_job_utils.check_jobname_or_id');
80: -- This sets the current program unit name in the
81: -- error stack. Helpful in Debugging
82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
83:
84: END Check_JobName_Or_id;
85:
86: --

Line 118: x_return_status := FND_API.G_RET_STS_SUCCESS;

114: FETCH joblevels into l_level;
115:
116: IF l_level IS NOT NULL THEN
117: x_valid := 'Y' ;
118: x_return_status := FND_API.G_RET_STS_SUCCESS;
119: ELSE
120: x_valid := 'N';
121: x_return_status := FND_API.G_RET_STS_ERROR;
122: x_error_message_code := 'PA_JOBLEVEL_INVALID_AMBIGUOUS';

Line 121: x_return_status := FND_API.G_RET_STS_ERROR;

117: x_valid := 'Y' ;
118: x_return_status := FND_API.G_RET_STS_SUCCESS;
119: ELSE
120: x_valid := 'N';
121: x_return_status := FND_API.G_RET_STS_ERROR;
122: x_error_message_code := 'PA_JOBLEVEL_INVALID_AMBIGUOUS';
123: END IF;
124:
125: CLOSE joblevels;

Line 129: x_return_status := FND_API.G_RET_STS_ERROR;

125: CLOSE joblevels;
126:
127: EXCEPTION
128: WHEN NO_DATA_FOUND THEN
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: x_error_message_code := 'PA_JOBLEVEL_INVALID_AMBIGUOUS';
131: WHEN OTHERS THEN
132: --PA_Error_Utils.Set_Error_Stack
133: -- (`pa_job_utils.check_jobname_or_id');

Line 136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

132: --PA_Error_Utils.Set_Error_Stack
133: -- (`pa_job_utils.check_jobname_or_id');
134: -- This sets the current program unit name in the
135: -- error stack. Helpful in Debugging
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
137:
138: END Check_JobLevel;
139:
140: -- PROCEDURE

Line 170: IF p_job_group_id IS NOT NULL AND p_job_group_id<>FND_API.G_MISS_NUM THEN

166: FROM per_job_groups
167: WHERE displayed_name = p_job_group_name;
168: BEGIN
169:
170: IF p_job_group_id IS NOT NULL AND p_job_group_id<>FND_API.G_MISS_NUM THEN
171: IF p_check_id_flag = 'Y' THEN
172: SELECT job_group_id
173: INTO x_job_group_id
174: FROM per_job_groups

Line 220: x_return_status := FND_API.G_RET_STS_SUCCESS;

216: x_job_group_id := NULL;
217: END IF;
218: END IF;
219:
220: x_return_status := FND_API.G_RET_STS_SUCCESS;
221:
222: EXCEPTION
223: WHEN NO_DATA_FOUND THEN
224: x_job_group_id := NULL;

Line 225: x_return_status := FND_API.G_RET_STS_ERROR;

221:
222: EXCEPTION
223: WHEN NO_DATA_FOUND THEN
224: x_job_group_id := NULL;
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: x_error_message_code := 'PA_JOBGROUP_INVALID';
227: WHEN TOO_MANY_ROWS THEN
228: x_job_group_id := NULL;
229: x_return_status := FND_API.G_RET_STS_ERROR;

Line 229: x_return_status := FND_API.G_RET_STS_ERROR;

225: x_return_status := FND_API.G_RET_STS_ERROR;
226: x_error_message_code := 'PA_JOBGROUP_INVALID';
227: WHEN TOO_MANY_ROWS THEN
228: x_job_group_id := NULL;
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: x_error_message_code := 'PA_JOBGROUP_INVALID';
231: WHEN OTHERS THEN
232: x_job_group_id := NULL;
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

229: x_return_status := FND_API.G_RET_STS_ERROR;
230: x_error_message_code := 'PA_JOBGROUP_INVALID';
231: WHEN OTHERS THEN
232: x_job_group_id := NULL;
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
234:
235: END Check_Job_GroupName_Or_Id;
236:
237: --

Line 262: x_return_status := FND_API.G_RET_STS_SUCCESS;

258:
259: BEGIN
260: -- Initialize the Error stack
261: PA_DEBUG.init_err_stack('PA_JOB_UTILS.validate_job_relationship');
262: x_return_status := FND_API.G_RET_STS_SUCCESS;
263: SELECT job_group_id
264: INTO v_job_group_id
265: FROM per_jobs
266: WHERE job_id = p_job_id

Line 270: v_return_status := FND_API.G_RET_STS_SUCCESS;

266: WHERE job_id = p_job_id
267: AND job_group_id = p_job_group_id;
268:
269: If v_job_group_id is NOT NULL then
270: v_return_status := FND_API.G_RET_STS_SUCCESS;
271: End if;
272:
273: -- reset the Error stack
274: PA_DEBUG.Reset_Err_Stack;

Line 278: x_return_status := FND_API.G_RET_STS_ERROR;

274: PA_DEBUG.Reset_Err_Stack;
275: EXCEPTION
276:
277: WHEN NO_DATA_FOUND THEN
278: x_return_status := FND_API.G_RET_STS_ERROR;
279: x_error_message_code := v_error_message_code;
280:
281: WHEN TOO_MANY_ROWS THEN
282: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 282: x_return_status := FND_API.G_RET_STS_SUCCESS;

278: x_return_status := FND_API.G_RET_STS_ERROR;
279: x_error_message_code := v_error_message_code;
280:
281: WHEN TOO_MANY_ROWS THEN
282: x_return_status := FND_API.G_RET_STS_SUCCESS;
283:
284: WHEN OTHERS THEN
285: -- Set the exception Message and the stack
286: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_JOB_UTILS.validate_job_relationship'

Line 288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

284: WHEN OTHERS THEN
285: -- Set the exception Message and the stack
286: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_JOB_UTILS.validate_job_relationship'
287: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
289: raise;
290: END validate_job_relationship;
291:
292: