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.EAM_SUB_RESOURCE_VALIDATE_PVT dependencies on FND_API

Line 88: l_return_status := FND_API.G_RET_STS_ERROR;

84: , p_token_tbl => l_token_tbl
85: );
86: l_mesg_token_tbl := l_out_mesg_token_tbl;
87:
88: l_return_status := FND_API.G_RET_STS_ERROR;
89:
90: ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND
91: p_eam_sub_res_rec.transaction_type IN
92: (EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)

Line 106: l_return_status := FND_API.G_RET_STS_ERROR;

102: , p_token_tbl => l_token_tbl
103: );
104: l_mesg_token_tbl := l_out_mesg_token_tbl;
105:
106: l_return_status := FND_API.G_RET_STS_ERROR;
107:
108: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
109: THEN
110: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 108: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR

104: l_mesg_token_tbl := l_out_mesg_token_tbl;
105:
106: l_return_status := FND_API.G_RET_STS_ERROR;
107:
108: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
109: THEN
110: l_out_mesg_token_tbl := l_mesg_token_tbl;
111: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
112: ( x_Mesg_token_tbl => l_out_Mesg_Token_Tbl

Line 118: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

114: , p_message_name => NULL
115: , p_message_text => 'Unexpected error while existence verification of ' || 'Sub Resource '|| p_eam_sub_res_rec.resource_seq_num , p_token_tbl => l_token_tbl
116: );
117: l_mesg_token_tbl := l_out_mesg_token_tbl;
118: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
119:
120: ELSE /* Assign the relevant transaction type for SYNC operations */
121: IF p_eam_sub_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN
122: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN

Line 128: l_return_status := FND_API.G_RET_STS_SUCCESS;

124: ELSE
125: x_old_eam_sub_res_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
126: END IF;
127: END IF;
128: l_return_status := FND_API.G_RET_STS_SUCCESS;
129:
130: END IF;
131:
132: x_return_status := l_return_status;

Line 181: x_return_status := FND_API.G_RET_STS_SUCCESS;

177: and wo.operation_seq_num = p_eam_sub_res_rec.operation_seq_num;
178:
179: end if;
180:
181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182:
183: exception
184: when others then
185:

Line 198: x_return_status := FND_API.G_RET_STS_ERROR;

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;

Line 213: raise fnd_api.g_exc_unexpected_error;

209:
210: if (p_eam_sub_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
211:
212: if p_eam_sub_res_rec.start_date > p_eam_sub_res_rec.completion_date then
213: raise fnd_api.g_exc_unexpected_error;
214: end if;
215:
216: end if;
217:

Line 218: x_return_status := FND_API.G_RET_STS_SUCCESS;

214: end if;
215:
216: end if;
217:
218: x_return_status := FND_API.G_RET_STS_SUCCESS;
219:
220: exception
221: when others then
222:

Line 235: x_return_status := FND_API.G_RET_STS_ERROR;

231: , x_mesg_token_tbl => l_out_mesg_token_tbl
232: );
233: l_mesg_token_tbl := l_out_mesg_token_tbl;
234:
235: x_return_status := FND_API.G_RET_STS_ERROR;
236: x_mesg_token_tbl := l_mesg_token_tbl ;
237: return;
238:
239: end;

Line 250: raise fnd_api.g_exc_unexpected_error;

246:
247: if (p_eam_sub_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
248:
249: if (p_eam_sub_res_rec.assigned_units < 0 ) then
250: raise fnd_api.g_exc_unexpected_error;
251: end if;
252:
253: end if;
254:

Line 255: x_return_status := FND_API.G_RET_STS_SUCCESS;

251: end if;
252:
253: end if;
254:
255: x_return_status := FND_API.G_RET_STS_SUCCESS;
256:
257: exception
258: when others then
259:

Line 272: x_return_status := FND_API.G_RET_STS_ERROR;

268: , x_mesg_token_tbl => l_out_mesg_token_tbl
269: );
270: l_mesg_token_tbl := l_out_mesg_token_tbl;
271:
272: x_return_status := FND_API.G_RET_STS_ERROR;
273: x_mesg_token_tbl := l_mesg_token_tbl ;
274: return;
275:
276: end;

Line 294: x_return_status := FND_API.G_RET_STS_SUCCESS;

290: and resource_id = p_eam_sub_res_rec.resource_id;
291:
292: end if;
293:
294: x_return_status := FND_API.G_RET_STS_SUCCESS;
295:
296: exception
297: when others then
298:

Line 311: x_return_status := FND_API.G_RET_STS_ERROR;

307: , x_mesg_token_tbl => l_out_mesg_token_tbl
308: );
309: l_mesg_token_tbl := l_out_mesg_token_tbl;
310:
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: x_mesg_token_tbl := l_mesg_token_tbl ;
313: return;
314:
315: end;

Line 332: x_return_status := FND_API.G_RET_STS_SUCCESS;

328: where uom_code = p_eam_sub_res_rec.uom_code;
329:
330: end if;
331:
332: x_return_status := FND_API.G_RET_STS_SUCCESS;
333:
334: exception
335: when others then
336:

Line 349: x_return_status := FND_API.G_RET_STS_ERROR;

345: , x_mesg_token_tbl => l_out_mesg_token_tbl
346: );
347: l_mesg_token_tbl := l_out_mesg_token_tbl;
348:
349: x_return_status := FND_API.G_RET_STS_ERROR;
350: x_mesg_token_tbl := l_mesg_token_tbl ;
351: return;
352:
353: end;

Line 372: x_return_status := FND_API.G_RET_STS_SUCCESS;

368: and lookup_code = p_eam_sub_res_rec.basis_type;
369:
370: end if;
371:
372: x_return_status := FND_API.G_RET_STS_SUCCESS;
373:
374: exception
375: when others then
376:

Line 389: x_return_status := FND_API.G_RET_STS_ERROR;

385: , x_mesg_token_tbl => l_out_mesg_token_tbl
386: );
387: l_mesg_token_tbl := l_out_mesg_token_tbl;
388:
389: x_return_status := FND_API.G_RET_STS_ERROR;
390: x_mesg_token_tbl := l_mesg_token_tbl ;
391: return;
392:
393: end;

Line 417: x_return_status := FND_API.G_RET_STS_SUCCESS;

413: END IF;
414:
415: end if;
416:
417: x_return_status := FND_API.G_RET_STS_SUCCESS;
418:
419: exception
420: when others then
421:

Line 434: x_return_status := FND_API.G_RET_STS_ERROR;

430: , x_mesg_token_tbl => l_out_mesg_token_tbl
431: );
432: l_mesg_token_tbl := l_out_mesg_token_tbl;
433:
434: x_return_status := FND_API.G_RET_STS_ERROR;
435: x_mesg_token_tbl := l_mesg_token_tbl ;
436: return;
437:
438: end;

Line 457: x_return_status := FND_API.G_RET_STS_SUCCESS;

453: and lookup_code = p_eam_sub_res_rec.autocharge_type;
454:
455: end if;
456:
457: x_return_status := FND_API.G_RET_STS_SUCCESS;
458:
459: exception
460: when others then
461:

Line 474: x_return_status := FND_API.G_RET_STS_ERROR;

470: , x_mesg_token_tbl => l_out_mesg_token_tbl
471: );
472: l_mesg_token_tbl := l_out_mesg_token_tbl;
473:
474: x_return_status := FND_API.G_RET_STS_ERROR;
475: x_mesg_token_tbl := l_mesg_token_tbl ;
476: return;
477:
478: end;

Line 496: x_return_status := FND_API.G_RET_STS_SUCCESS;

492: and lookup_code = p_eam_sub_res_rec.scheduled_flag;
493:
494: end if;
495:
496: x_return_status := FND_API.G_RET_STS_SUCCESS;
497:
498: exception
499: when others then
500:

Line 513: x_return_status := FND_API.G_RET_STS_ERROR;

509: , x_mesg_token_tbl => l_out_mesg_token_tbl
510: );
511: l_mesg_token_tbl := l_out_mesg_token_tbl;
512:
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: x_mesg_token_tbl := l_mesg_token_tbl ;
515: return;
516:
517: end;

Line 530: raise fnd_api.g_exc_unexpected_error;

526:
527: IF (p_eam_sub_res_rec.standard_rate_flag is not NULL) and (p_eam_sub_res_rec.standard_rate_flag not in (1, 2))
528: THEN
529:
530: raise fnd_api.g_exc_unexpected_error;
531:
532: END IF;
533:
534: end if;

Line 536: x_return_status := FND_API.G_RET_STS_SUCCESS;

532: END IF;
533:
534: end if;
535:
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: exception
539: when others then
540:

Line 553: x_return_status := FND_API.G_RET_STS_ERROR;

549: , x_mesg_token_tbl => l_out_mesg_token_tbl
550: );
551: l_mesg_token_tbl := l_out_mesg_token_tbl;
552:
553: x_return_status := FND_API.G_RET_STS_ERROR;
554: x_mesg_token_tbl := l_mesg_token_tbl ;
555: return;
556:
557: end;

Line 592: x_return_status := FND_API.G_RET_STS_SUCCESS;

588: and wsor.department_id = p_eam_sub_res_rec.department_id;
589:
590: END IF;
591:
592: x_return_status := FND_API.G_RET_STS_SUCCESS;
593:
594: exception
595: when others then
596:

Line 606: x_return_status := FND_API.G_RET_STS_ERROR;

602: , x_mesg_token_tbl => l_out_mesg_token_tbl
603: );
604: l_mesg_token_tbl := l_out_mesg_token_tbl;
605:
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: x_mesg_token_tbl := l_mesg_token_tbl ;
608: return;
609:
610: end;

Line 643: raise fnd_api.g_exc_unexpected_error;

639:
640: IF (p_eam_sub_res_rec.usage_rate_or_amount < 0 and (p_eam_sub_res_rec.autocharge_type = 3 or l_uom_time_class_flag = 'Y'))
641: THEN
642:
643: raise fnd_api.g_exc_unexpected_error;
644:
645: END IF;
646:
647: end if;

Line 649: x_return_status := FND_API.G_RET_STS_SUCCESS;

645: END IF;
646:
647: end if;
648:
649: x_return_status := FND_API.G_RET_STS_SUCCESS;
650:
651: exception
652: when others then
653:

Line 666: x_return_status := FND_API.G_RET_STS_ERROR;

662: , x_mesg_token_tbl => l_out_mesg_token_tbl
663: );
664: l_mesg_token_tbl := l_out_mesg_token_tbl;
665:
666: x_return_status := FND_API.G_RET_STS_ERROR;
667: x_mesg_token_tbl := l_mesg_token_tbl ;
668: return;
669:
670: end;

Line 697: raise fnd_api.g_exc_unexpected_error;

693: and resource_seq_num = p_eam_sub_res_rec.resource_seq_num
694: and resource_id = p_eam_sub_res_rec.resource_id);
695:
696: if(l_count_wt > 0) then
697: raise fnd_api.g_exc_unexpected_error;
698: end if;
699:
700: select count(*)
701: into l_count_wcti

Line 712: raise fnd_api.g_exc_unexpected_error;

708: and resource_seq_num = p_eam_sub_res_rec.resource_seq_num
709: and resource_id = p_eam_sub_res_rec.resource_id);
710:
711: if(l_count_wcti > 0) then
712: raise fnd_api.g_exc_unexpected_error;
713: end if;
714:
715: select applied_resource_units
716: into l_applied_res_units

Line 725: raise fnd_api.g_exc_unexpected_error;

721: and resource_seq_num = p_eam_sub_res_rec.resource_seq_num
722: and resource_id = p_eam_sub_res_rec.resource_id;
723:
724: if(l_applied_res_units <> 0) then
725: raise fnd_api.g_exc_unexpected_error;
726: end if;
727:
728: end if;
729:

Line 730: x_return_status := FND_API.G_RET_STS_SUCCESS;

726: end if;
727:
728: end if;
729:
730: x_return_status := FND_API.G_RET_STS_SUCCESS;
731:
732: exception
733: when others then
734:

Line 747: x_return_status := FND_API.G_RET_STS_ERROR;

743: , x_mesg_token_tbl => l_out_mesg_token_tbl
744: );
745: l_mesg_token_tbl := l_out_mesg_token_tbl;
746:
747: x_return_status := FND_API.G_RET_STS_ERROR;
748: x_mesg_token_tbl := l_mesg_token_tbl ;
749: return;
750:
751: end;

Line 777: raise fnd_api.g_exc_unexpected_error;

773: and wip_resource_seq_num = p_eam_sub_res_rec.resource_seq_num
774: and bom_resource_id = p_eam_sub_res_rec.resource_id);
775:
776: if(l_count_po <> 0) then
777: raise fnd_api.g_exc_unexpected_error;
778: end if;
779:
780:
781: select count(*)

Line 793: raise fnd_api.g_exc_unexpected_error;

789: and wip_resource_seq_num = p_eam_sub_res_rec.resource_seq_num
790: and bom_resource_id = p_eam_sub_res_rec.resource_id);
791:
792: if(l_count_req <> 0) then
793: raise fnd_api.g_exc_unexpected_error;
794: end if;
795:
796:
797: select count(*)

Line 809: raise fnd_api.g_exc_unexpected_error;

805: and wip_resource_seq_num = p_eam_sub_res_rec.resource_seq_num
806: and bom_resource_id = p_eam_sub_res_rec.resource_id);
807:
808: if(l_count_dist <> 0) then
809: raise fnd_api.g_exc_unexpected_error;
810: end if;
811:
812: end if;
813:

Line 814: x_return_status := FND_API.G_RET_STS_SUCCESS;

810: end if;
811:
812: end if;
813:
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815:
816: exception
817: when others then
818:

Line 831: x_return_status := FND_API.G_RET_STS_ERROR;

827: , x_mesg_token_tbl => l_out_mesg_token_tbl
828: );
829: l_mesg_token_tbl := l_out_mesg_token_tbl;
830:
831: x_return_status := FND_API.G_RET_STS_ERROR;
832: x_mesg_token_tbl := l_mesg_token_tbl ;
833: return;
834:
835: end;

Line 839: x_return_status := FND_API.G_RET_STS_SUCCESS;

835: end;
836:
837:
838:
839: x_return_status := FND_API.G_RET_STS_SUCCESS;
840:
841: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Sub Resource Check Attributes . . . '); END IF;
842:
843:

Line 866: x_return_status := FND_API.G_RET_STS_SUCCESS;

862: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
863: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
864: BEGIN
865:
866: x_return_status := FND_API.G_RET_STS_SUCCESS;
867:
868: IF p_eam_sub_res_rec.wip_entity_id IS NULL
869: THEN
870: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';

Line 882: x_return_status := FND_API.G_RET_STS_ERROR;

878: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
879: );
880: l_mesg_token_tbl := l_out_mesg_token_tbl;
881:
882: x_return_status := FND_API.G_RET_STS_ERROR;
883:
884: END IF;
885:
886:

Line 901: x_return_status := FND_API.G_RET_STS_ERROR;

897: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
898: );
899: l_mesg_token_tbl := l_out_mesg_token_tbl;
900:
901: x_return_status := FND_API.G_RET_STS_ERROR;
902:
903: END IF;
904:
905:

Line 920: x_return_status := FND_API.G_RET_STS_ERROR;

916: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
917: );
918: l_mesg_token_tbl := l_out_mesg_token_tbl;
919:
920: x_return_status := FND_API.G_RET_STS_ERROR;
921:
922: END IF;
923:
924:

Line 939: x_return_status := FND_API.G_RET_STS_ERROR;

935: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
936: );
937: l_mesg_token_tbl := l_out_mesg_token_tbl;
938:
939: x_return_status := FND_API.G_RET_STS_ERROR;
940:
941: END IF;
942:
943:

Line 958: x_return_status := FND_API.G_RET_STS_ERROR;

954: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
955: );
956: l_mesg_token_tbl := l_out_mesg_token_tbl;
957:
958: x_return_status := FND_API.G_RET_STS_ERROR;
959:
960: END IF;
961:
962:

Line 977: x_return_status := FND_API.G_RET_STS_ERROR;

973: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
974: );
975: l_mesg_token_tbl := l_out_mesg_token_tbl;
976:
977: x_return_status := FND_API.G_RET_STS_ERROR;
978:
979: END IF;
980:
981:

Line 996: x_return_status := FND_API.G_RET_STS_ERROR;

992: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
993: );
994: l_mesg_token_tbl := l_out_mesg_token_tbl;
995:
996: x_return_status := FND_API.G_RET_STS_ERROR;
997:
998: END IF;
999:
1000:

Line 1015: x_return_status := FND_API.G_RET_STS_ERROR;

1011: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
1012: );
1013: l_mesg_token_tbl := l_out_mesg_token_tbl;
1014:
1015: x_return_status := FND_API.G_RET_STS_ERROR;
1016:
1017: END IF;
1018:
1019:

Line 1034: x_return_status := FND_API.G_RET_STS_ERROR;

1030: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
1031: );
1032: l_mesg_token_tbl := l_out_mesg_token_tbl;
1033:
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035:
1036: END IF;
1037:
1038:

Line 1053: x_return_status := FND_API.G_RET_STS_ERROR;

1049: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
1050: );
1051: l_mesg_token_tbl := l_out_mesg_token_tbl;
1052:
1053: x_return_status := FND_API.G_RET_STS_ERROR;
1054:
1055: END IF;
1056:
1057:

Line 1072: x_return_status := FND_API.G_RET_STS_ERROR;

1068: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
1069: );
1070: l_mesg_token_tbl := l_out_mesg_token_tbl;
1071:
1072: x_return_status := FND_API.G_RET_STS_ERROR;
1073:
1074: END IF;
1075:
1076:

Line 1091: x_return_status := FND_API.G_RET_STS_ERROR;

1087: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
1088: );
1089: l_mesg_token_tbl := l_out_mesg_token_tbl;
1090:
1091: x_return_status := FND_API.G_RET_STS_ERROR;
1092:
1093: END IF;
1094:
1095:

Line 1110: x_return_status := FND_API.G_RET_STS_ERROR;

1106: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
1107: );
1108: l_mesg_token_tbl := l_out_mesg_token_tbl;
1109:
1110: x_return_status := FND_API.G_RET_STS_ERROR;
1111:
1112: END IF;
1113:
1114:

Line 1129: x_return_status := FND_API.G_RET_STS_ERROR;

1125: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
1126: );
1127: l_mesg_token_tbl := l_out_mesg_token_tbl;
1128:
1129: x_return_status := FND_API.G_RET_STS_ERROR;
1130:
1131: END IF;
1132:
1133: IF p_eam_sub_res_rec.department_id IS NULL

Line 1145: x_return_status := FND_API.G_RET_STS_ERROR;

1141: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
1142: );
1143: l_mesg_token_tbl := l_out_mesg_token_tbl;
1144:
1145: x_return_status := FND_API.G_RET_STS_ERROR;
1146:
1147: END IF;
1148:
1149: