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';
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
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
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;
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';
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
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
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:
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:
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:
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:
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;
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';
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:
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:
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;
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:
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:
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:
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;
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:
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: