DBA Data[Home] [Help]

APPS.EAM_RES_INST_VALIDATE_PVT dependencies on FND_API

Line 102: l_return_status := FND_API.G_RET_STS_ERROR;

98: , p_token_tbl => l_token_tbl
99: );
100: l_mesg_token_tbl := l_out_mesg_token_tbl;
101:
102: l_return_status := FND_API.G_RET_STS_ERROR;
103:
104: ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND
105: p_eam_res_inst_rec.transaction_type IN
106: (EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)

Line 133: l_return_status := FND_API.G_RET_STS_ERROR;

129: , p_token_tbl => l_token_tbl
130: );
131: l_mesg_token_tbl := l_out_mesg_token_tbl;
132:
133: l_return_status := FND_API.G_RET_STS_ERROR;
134:
135: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
136: THEN
137: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 135: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR

131: l_mesg_token_tbl := l_out_mesg_token_tbl;
132:
133: l_return_status := FND_API.G_RET_STS_ERROR;
134:
135: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
136: THEN
137: l_out_mesg_token_tbl := l_mesg_token_tbl;
138: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
139: ( x_Mesg_token_tbl => l_out_Mesg_Token_Tbl

Line 145: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

141: , p_message_name => NULL
142: , p_message_text => 'Unexpected error while existence verification of ' || 'Resource Instance '|| p_eam_res_inst_rec.instance_id , p_token_tbl => l_token_tbl
143: );
144: l_mesg_token_tbl := l_out_mesg_token_tbl;
145: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146:
147: ELSE /* Assign the relevant transaction type for SYNC operations */
148: IF p_eam_res_inst_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN
149: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN

Line 155: l_return_status := FND_API.G_RET_STS_SUCCESS;

151: ELSE
152: x_old_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
153: END IF;
154: END IF;
155: l_return_status := FND_API.G_RET_STS_SUCCESS;
156:
157: END IF;
158:
159: x_return_status := l_return_status;

Line 207: x_return_status := FND_API.G_RET_STS_SUCCESS;

203: and wo.operation_seq_num = p_eam_res_inst_rec.operation_seq_num;
204:
205: end if;
206:
207: x_return_status := FND_API.G_RET_STS_SUCCESS;
208:
209: exception
210: when others then
211:

Line 224: x_return_status := FND_API.G_RET_STS_ERROR;

220: , x_mesg_token_tbl => l_out_mesg_token_tbl
221: );
222: l_mesg_token_tbl := l_out_mesg_token_tbl;
223:
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: x_mesg_token_tbl := l_mesg_token_tbl ;
226: return;
227:
228: end;

Line 249: x_return_status := FND_API.G_RET_STS_SUCCESS;

245: and wor.resource_seq_num = p_eam_res_inst_rec.resource_seq_num;
246:
247: end if;
248:
249: x_return_status := FND_API.G_RET_STS_SUCCESS;
250:
251: exception
252: when others then
253:

Line 266: x_return_status := FND_API.G_RET_STS_ERROR;

262: , x_mesg_token_tbl => l_out_mesg_token_tbl
263: );
264: l_mesg_token_tbl := l_out_mesg_token_tbl;
265:
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: x_mesg_token_tbl := l_mesg_token_tbl ;
268: return;
269:
270: end;

Line 304: x_return_status := FND_API.G_RET_STS_SUCCESS;

300: and wo.operation_seq_num = wor.operation_seq_num;
301:
302: end if;
303:
304: x_return_status := FND_API.G_RET_STS_SUCCESS;
305:
306: exception
307: when TOO_MANY_ROWS then
308: -- Do nothing. Multiple rows mean multiple serial numbers

Line 337: x_return_status := FND_API.G_RET_STS_ERROR;

333: , x_mesg_token_tbl => l_out_mesg_token_tbl
334: );
335: l_mesg_token_tbl := l_out_mesg_token_tbl;
336:
337: x_return_status := FND_API.G_RET_STS_ERROR;
338: x_mesg_token_tbl := l_mesg_token_tbl ;
339: return;
340:
341: end;

Line 366: x_return_status := FND_API.G_RET_STS_SUCCESS;

362: end if;
363:
364: end if;
365:
366: x_return_status := FND_API.G_RET_STS_SUCCESS;
367:
368: exception
369: when others then
370:

Line 383: x_return_status := FND_API.G_RET_STS_ERROR;

379: , x_mesg_token_tbl => l_out_mesg_token_tbl
380: );
381: l_mesg_token_tbl := l_out_mesg_token_tbl;
382:
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: x_mesg_token_tbl := l_mesg_token_tbl ;
385: return;
386:
387: end;

Line 398: raise fnd_api.g_exc_unexpected_error;

394:
395: if (p_eam_res_inst_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
396:
397: if p_eam_res_inst_rec.start_date > p_eam_res_inst_rec.completion_date then
398: raise fnd_api.g_exc_unexpected_error;
399: end if;
400:
401: end if;
402:

Line 403: x_return_status := FND_API.G_RET_STS_SUCCESS;

399: end if;
400:
401: end if;
402:
403: x_return_status := FND_API.G_RET_STS_SUCCESS;
404:
405: exception
406: when others then
407:

Line 420: x_return_status := FND_API.G_RET_STS_ERROR;

416: , x_mesg_token_tbl => l_out_mesg_token_tbl
417: );
418: l_mesg_token_tbl := l_out_mesg_token_tbl;
419:
420: x_return_status := FND_API.G_RET_STS_ERROR;
421: x_mesg_token_tbl := l_mesg_token_tbl ;
422: return;
423:
424: end;

Line 464: raise fnd_api.g_exc_unexpected_error;

460:
461:
462:
463: if(l_count_wt > 0) then
464: raise fnd_api.g_exc_unexpected_error;
465: end if;
466:
467: select count(*)
468: into l_count_wcti

Line 482: raise fnd_api.g_exc_unexpected_error;

478: AND rownum <=1 ;
479:
480:
481: if(l_count_wcti > 0) then
482: raise fnd_api.g_exc_unexpected_error;
483: end if;
484:
485:
486: end if;

Line 488: x_return_status := FND_API.G_RET_STS_SUCCESS;

484:
485:
486: end if;
487:
488: x_return_status := FND_API.G_RET_STS_SUCCESS;
489:
490: exception
491: when others then
492:

Line 505: x_return_status := FND_API.G_RET_STS_ERROR;

501: , x_mesg_token_tbl => l_out_mesg_token_tbl
502: );
503: l_mesg_token_tbl := l_out_mesg_token_tbl;
504:
505: x_return_status := FND_API.G_RET_STS_ERROR;
506: x_mesg_token_tbl := l_mesg_token_tbl ;
507: return;
508:
509: end;

Line 512: x_return_status := FND_API.G_RET_STS_SUCCESS;

508:
509: end;
510:
511:
512: x_return_status := FND_API.G_RET_STS_SUCCESS;
513:
514: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Resource Instance Check Attributes . . . '); END IF;
515:
516: END Check_Attributes;

Line 537: x_return_status := FND_API.G_RET_STS_SUCCESS;

533: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
534: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
535: BEGIN
536:
537: x_return_status := FND_API.G_RET_STS_SUCCESS;
538:
539:
540: IF p_eam_res_inst_rec.wip_entity_id IS NULL
541: THEN

Line 554: x_return_status := FND_API.G_RET_STS_ERROR;

550: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
551: );
552: l_mesg_token_tbl := l_out_mesg_token_tbl;
553:
554: x_return_status := FND_API.G_RET_STS_ERROR;
555:
556: END IF;
557:
558:

Line 573: x_return_status := FND_API.G_RET_STS_ERROR;

569: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
570: );
571: l_mesg_token_tbl := l_out_mesg_token_tbl;
572:
573: x_return_status := FND_API.G_RET_STS_ERROR;
574:
575: END IF;
576:
577: IF p_eam_res_inst_rec.operation_seq_num IS NULL

Line 591: x_return_status := FND_API.G_RET_STS_ERROR;

587: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
588: );
589: l_mesg_token_tbl := l_out_mesg_token_tbl;
590:
591: x_return_status := FND_API.G_RET_STS_ERROR;
592:
593: END IF;
594:
595:

Line 610: x_return_status := FND_API.G_RET_STS_ERROR;

606: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
607: );
608: l_mesg_token_tbl := l_out_mesg_token_tbl;
609:
610: x_return_status := FND_API.G_RET_STS_ERROR;
611:
612: END IF;
613:
614:

Line 629: x_return_status := FND_API.G_RET_STS_ERROR;

625: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
626: );
627: l_mesg_token_tbl := l_out_mesg_token_tbl;
628:
629: x_return_status := FND_API.G_RET_STS_ERROR;
630:
631: END IF;
632:
633:

Line 648: x_return_status := FND_API.G_RET_STS_ERROR;

644: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
645: );
646: l_mesg_token_tbl := l_out_mesg_token_tbl;
647:
648: x_return_status := FND_API.G_RET_STS_ERROR;
649:
650: END IF;
651:
652:

Line 667: x_return_status := FND_API.G_RET_STS_ERROR;

663: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
664: );
665: l_mesg_token_tbl := l_out_mesg_token_tbl;
666:
667: x_return_status := FND_API.G_RET_STS_ERROR;
668:
669: END IF;
670:
671: