83: , p_token_tbl => l_token_tbl
84: );
85: l_mesg_token_tbl := l_out_mesg_token_tbl;
86:
87: l_return_status := FND_API.G_RET_STS_ERROR;
88:
89: ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND
90: p_eam_op_network_rec.transaction_type IN
91: (EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)
101: , p_token_tbl => l_token_tbl
102: );
103: l_mesg_token_tbl := l_out_mesg_token_tbl;
104:
105: l_return_status := FND_API.G_RET_STS_ERROR;
106:
107: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
108: THEN
109: l_out_mesg_token_tbl := l_mesg_token_tbl;
103: l_mesg_token_tbl := l_out_mesg_token_tbl;
104:
105: l_return_status := FND_API.G_RET_STS_ERROR;
106:
107: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
108: THEN
109: l_out_mesg_token_tbl := l_mesg_token_tbl;
110: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
111: ( x_Mesg_token_tbl => l_out_Mesg_Token_Tbl
113: , p_message_name => NULL
114: , p_message_text => 'Unexpected error while existence verification of ' || 'Operation Network '|| p_eam_op_network_rec.prior_operation , p_token_tbl => l_token_tbl
115: );
116: l_mesg_token_tbl := l_out_mesg_token_tbl;
117: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
118:
119: ELSE /* Assign the relevant transaction type for SYNC operations */
120: IF p_eam_op_network_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN
121: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN
123: ELSE
124: x_old_eam_op_network_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
125: END IF;
126: END IF;
127: l_return_status := FND_API.G_RET_STS_SUCCESS;
128:
129: END IF;
130:
131: x_return_status := l_return_status;
177: and nvl(wo.operation_completed,'N') = 'N';
178:
179: end if;
180:
181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182:
183: exception
184: when others then
185:
194: , x_mesg_token_tbl => l_out_mesg_token_tbl
195: );
196: l_mesg_token_tbl := l_out_mesg_token_tbl;
197:
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: x_mesg_token_tbl := l_mesg_token_tbl ;
200: return;
201:
202: end;
219: and nvl(wo.operation_completed,'N') = 'N';
220:
221: end if;
222:
223: x_return_status := FND_API.G_RET_STS_SUCCESS;
224:
225: exception
226: when others then
227:
236: , x_mesg_token_tbl => l_out_mesg_token_tbl
237: );
238: l_mesg_token_tbl := l_out_mesg_token_tbl;
239:
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: x_mesg_token_tbl := l_mesg_token_tbl ;
242: return;
243:
244: end;
242: return;
243:
244: end;
245:
246: x_return_status := FND_API.G_RET_STS_SUCCESS;
247:
248: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Operation Network Check Attributes . . . '); END IF;
249:
250:
268: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
269: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
270: BEGIN
271:
272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273:
274:
275: IF p_eam_op_network_rec.wip_entity_id IS NULL
276: THEN
285: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
286: );
287: l_mesg_token_tbl := l_out_mesg_token_tbl;
288:
289: x_return_status := FND_API.G_RET_STS_ERROR;
290:
291: END IF;
292:
293:
304: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
305: );
306: l_mesg_token_tbl := l_out_mesg_token_tbl;
307:
308: x_return_status := FND_API.G_RET_STS_ERROR;
309:
310: END IF;
311:
312:
323: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
324: );
325: l_mesg_token_tbl := l_out_mesg_token_tbl;
326:
327: x_return_status := FND_API.G_RET_STS_ERROR;
328:
329: END IF;
330:
331:
342: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
343: );
344: l_mesg_token_tbl := l_out_mesg_token_tbl;
345:
346: x_return_status := FND_API.G_RET_STS_ERROR;
347:
348: END IF;
349:
350: