DBA Data[Home] [Help]

APPS.EAM_REQUEST_VALIDATE_PVT dependencies on FND_API

Line 37: x_return_status := FND_API.G_RET_STS_SUCCESS;

33: BEGIN
34:
35: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Request/Service Request processing Check Required'); END IF;
36:
37: x_return_status := FND_API.G_RET_STS_SUCCESS;
38:
39: IF p_eam_request_rec.organization_id IS NULL
40: THEN
41: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';

Line 52: x_return_status := FND_API.G_RET_STS_ERROR;

48: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
49: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
50: );
51: l_mesg_token_tbl := l_out_mesg_token_tbl;
52: x_return_status := FND_API.G_RET_STS_ERROR;
53: return;
54: END IF;
55:
56: IF p_eam_request_rec.request_type IS NULL

Line 69: x_return_status := FND_API.G_RET_STS_ERROR;

65: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
66: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
67: );
68: l_mesg_token_tbl := l_out_mesg_token_tbl;
69: x_return_status := FND_API.G_RET_STS_ERROR;
70: return;
71: END IF;
72:
73: IF p_eam_request_rec.request_id IS NULL AND p_eam_request_rec.request_number IS NULL

Line 86: x_return_status := FND_API.G_RET_STS_ERROR;

82: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
83: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
84: );
85: l_mesg_token_tbl := l_out_mesg_token_tbl;
86: x_return_status := FND_API.G_RET_STS_ERROR;
87: return;
88: END IF;
89:
90: END CHECK_REQUIRED;

Line 106: x_return_status := FND_API.G_RET_STS_SUCCESS;

102: BEGIN
103:
104: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Request/Service Request processing Check Attributes'); END IF;
105:
106: x_return_status := FND_API.G_RET_STS_SUCCESS;
107:
108: IF p_eam_request_rec.request_number IS NULL
109: THEN
110: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';

Line 121: x_return_status := FND_API.G_RET_STS_ERROR;

117: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
118: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
119: );
120: l_mesg_token_tbl := l_out_mesg_token_tbl;
121: x_return_status := FND_API.G_RET_STS_ERROR;
122: return;
123: END IF;
124:
125: IF p_eam_request_rec.request_id IS NULL

Line 138: x_return_status := FND_API.G_RET_STS_ERROR;

134: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
135: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
136: );
137: l_mesg_token_tbl := l_out_mesg_token_tbl;
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: return;
140: END IF;
141:
142: -- organization_id

Line 159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

155: FROM hr_organization_units hou
156: WHERE organization_id = p_eam_request_rec.organization_id;
157:
158: IF(l_disable_date < sysdate) THEN
159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
160: END IF;
161:
162: x_return_status := FND_API.G_RET_STS_SUCCESS;
163:

Line 162: x_return_status := FND_API.G_RET_STS_SUCCESS;

158: IF(l_disable_date < sysdate) THEN
159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
160: END IF;
161:
162: x_return_status := FND_API.G_RET_STS_SUCCESS;
163:
164: EXCEPTION
165: WHEN OTHERS THEN
166:

Line 178: x_return_status := FND_API.G_RET_STS_ERROR;

174: , p_mesg_token_tbl => l_mesg_token_tbl
175: , x_mesg_token_tbl => l_out_mesg_token_tbl
176: );
177: l_mesg_token_tbl := l_out_mesg_token_tbl;
178: x_return_status := FND_API.G_RET_STS_ERROR;
179: x_mesg_token_tbl := l_mesg_token_tbl ;
180: RETURN;
181: END;
182:

Line 195: x_return_status := FND_API.G_RET_STS_SUCCESS;

191: WHERE wep.organization_id = mp.organization_id
192: AND mp.eam_enabled_flag = 'Y'
193: AND wep.organization_id = p_eam_request_rec.organization_id;
194:
195: x_return_status := FND_API.G_RET_STS_SUCCESS;
196:
197: EXCEPTION
198: WHEN OTHERS THEN
199:

Line 211: x_return_status := FND_API.G_RET_STS_ERROR;

207: , p_mesg_token_tbl => l_mesg_token_tbl
208: , x_mesg_token_tbl => l_out_mesg_token_tbl
209: );
210: l_mesg_token_tbl := l_out_mesg_token_tbl;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: x_mesg_token_tbl := l_mesg_token_tbl ;
213: return;
214:
215: END;

Line 226: x_return_status := FND_API.G_RET_STS_SUCCESS;

222: WHERE wdj.STATUS_TYPE IN (WIP_CONSTANTS.DRAFT,WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED,
223: WIP_CONSTANTS.HOLD,WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG)
224: AND wdj.wip_entity_id = p_eam_request_rec.wip_entity_id ;
225:
226: x_return_status := FND_API.G_RET_STS_SUCCESS;
227: exception
228: when others then
229:
230: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';

Line 241: x_return_status := FND_API.G_RET_STS_ERROR;

237: , p_mesg_token_tbl => l_mesg_token_tbl
238: , x_mesg_token_tbl => l_out_mesg_token_tbl
239: );
240: l_mesg_token_tbl := l_out_mesg_token_tbl;
241: x_return_status := FND_API.G_RET_STS_ERROR;
242: x_mesg_token_tbl := l_mesg_token_tbl ;
243: return;
244: end;
245:

Line 257: x_return_status := FND_API.G_RET_STS_SUCCESS;

253: WHERE wdj.STATUS_TYPE IN (WIP_CONSTANTS.DRAFT,WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED,
254: WIP_CONSTANTS.HOLD,WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG)
255: AND wdj.wip_entity_id = p_eam_request_rec.wip_entity_id ;
256:
257: x_return_status := FND_API.G_RET_STS_SUCCESS;
258:
259: exception
260: when others then
261:

Line 274: x_return_status := FND_API.G_RET_STS_ERROR;

270: , x_mesg_token_tbl => l_out_mesg_token_tbl
271: );
272: l_mesg_token_tbl := l_out_mesg_token_tbl;
273:
274: x_return_status := FND_API.G_RET_STS_ERROR;
275: x_mesg_token_tbl := l_mesg_token_tbl ;
276: return;
277: end;
278: END IF;

Line 288: x_return_status := FND_API.G_RET_STS_SUCCESS;

284: FROM WIP_EAM_WORK_REQUESTS wewr
285: WHERE wewr.work_request_id = p_eam_request_rec.request_id
286: AND WORK_REQUEST_STATUS_ID = 3 ;
287:
288: x_return_status := FND_API.G_RET_STS_SUCCESS;
289:
290: exception
291: when others then
292:

Line 305: x_return_status := FND_API.G_RET_STS_ERROR;

301: , x_mesg_token_tbl => l_out_mesg_token_tbl
302: );
303: l_mesg_token_tbl := l_out_mesg_token_tbl;
304:
305: x_return_status := FND_API.G_RET_STS_ERROR;
306: x_mesg_token_tbl := l_mesg_token_tbl ;
307: return;
308: end;
309:

Line 324: x_return_status := FND_API.G_RET_STS_SUCCESS;

320: AND nvl(citb.MAINTENANCE_FLAG,'N') = 'Y'
321: AND ciab.INCIDENT_ID = p_eam_request_rec.request_id;
322:
323:
324: x_return_status := FND_API.G_RET_STS_SUCCESS;
325:
326: exception
327: when others then
328:

Line 341: x_return_status := FND_API.G_RET_STS_ERROR;

337: , x_mesg_token_tbl => l_out_mesg_token_tbl
338: );
339: l_mesg_token_tbl := l_out_mesg_token_tbl;
340:
341: x_return_status := FND_API.G_RET_STS_ERROR;
342: x_mesg_token_tbl := l_mesg_token_tbl ;
343: return;
344: end;
345: END IF;

Line 368: x_return_status := FND_API.G_RET_STS_ERROR;

364: , x_mesg_token_tbl => l_out_mesg_token_tbl
365: );
366: l_mesg_token_tbl := l_out_mesg_token_tbl;
367:
368: x_return_status := FND_API.G_RET_STS_ERROR;
369: x_mesg_token_tbl := l_mesg_token_tbl ;
370: return;
371: END IF;
372:

Line 400: x_return_status := FND_API.G_RET_STS_ERROR;

396: , x_mesg_token_tbl => l_out_mesg_token_tbl
397: );
398: l_mesg_token_tbl := l_out_mesg_token_tbl;
399:
400: x_return_status := FND_API.G_RET_STS_ERROR;
401: x_mesg_token_tbl := l_mesg_token_tbl ;
402: return;
403: END IF;
404: