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_WO_COMP_VALIDATE_PVT dependencies on FND_API

Line 39: x_return_status := FND_API.G_RET_STS_SUCCESS;

35: BEGIN
36:
37: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Check Required'); END IF;
38:
39: x_return_status := FND_API.G_RET_STS_SUCCESS;
40:
41: SELECT wip_entity_name
42: INTO l_wip_entity_name
43: FROM wip_entities

Line 66: x_return_status := FND_API.G_RET_STS_ERROR;

62: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
63: );
64: l_mesg_token_tbl := l_out_mesg_token_tbl;
65: x_mesg_token_tbl := l_mesg_token_tbl ;
66: x_return_status := FND_API.G_RET_STS_ERROR;
67: return;
68: END IF;
69:
70: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check Actual end date'); END IF;

Line 85: x_return_status := FND_API.G_RET_STS_ERROR;

81: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
82: );
83: l_mesg_token_tbl := l_out_mesg_token_tbl;
84: x_mesg_token_tbl := l_mesg_token_tbl ;
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: return;
87: END IF;
88:
89: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check Actual duration '); END IF;

Line 104: x_return_status := FND_API.G_RET_STS_ERROR;

100: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
101: );
102: l_mesg_token_tbl := l_out_mesg_token_tbl;
103: x_mesg_token_tbl := l_mesg_token_tbl ;
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: return;
106: END IF;
107:
108: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE

Line 127: x_return_status := FND_API.G_RET_STS_ERROR;

123: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
124: );
125: l_mesg_token_tbl := l_out_mesg_token_tbl;
126: x_mesg_token_tbl := l_mesg_token_tbl ;
127: x_return_status := FND_API.G_RET_STS_ERROR;
128: return;
129: END IF;
130: END IF;
131: END IF;

Line 154: x_return_status := FND_API.G_RET_STS_ERROR;

150: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
151: );
152: l_mesg_token_tbl := l_out_mesg_token_tbl;
153: x_mesg_token_tbl := l_mesg_token_tbl ;
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: return;
156: END IF;
157: END Check_Required;
158:

Line 236: x_return_status := FND_API.G_RET_STS_SUCCESS;

232: BEGIN
233:
234: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Check_Attributes'); END IF;
235:
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237: x_eam_wo_comp_rec := p_eam_wo_comp_rec;
238: l_org_id := p_eam_wo_comp_rec.organization_id;
239:
240: SELECT wip_entity_name

Line 258: raise fnd_api.g_exc_unexpected_error;

254:
255: begin
256:
257: IF p_eam_wo_comp_rec.actual_start_date > p_eam_wo_comp_rec.actual_end_date THEN
258: raise fnd_api.g_exc_unexpected_error;
259: END IF;
260:
261: x_return_status := FND_API.G_RET_STS_SUCCESS;
262:

Line 261: x_return_status := FND_API.G_RET_STS_SUCCESS;

257: IF p_eam_wo_comp_rec.actual_start_date > p_eam_wo_comp_rec.actual_end_date THEN
258: raise fnd_api.g_exc_unexpected_error;
259: END IF;
260:
261: x_return_status := FND_API.G_RET_STS_SUCCESS;
262:
263: exception
264: when others then
265:

Line 278: x_return_status := FND_API.G_RET_STS_ERROR;

274: , x_mesg_token_tbl => l_out_mesg_token_tbl
275: );
276: l_mesg_token_tbl := l_out_mesg_token_tbl;
277:
278: x_return_status := FND_API.G_RET_STS_ERROR;
279: x_mesg_token_tbl := l_mesg_token_tbl ;
280: return;
281: end;
282:

Line 296: raise fnd_api.g_exc_unexpected_error;

292: /*Fix for bug 3235163*/
293: --Previously the check was for actual_end date.It has been changed to p_transaction_date
294:
295: IF (p_eam_wo_comp_rec.transaction_date < l_min_open_period) THEN
296: raise fnd_api.g_exc_unexpected_error;
297: END IF;
298: x_return_status := FND_API.G_RET_STS_SUCCESS;
299: exception
300: when others then

Line 298: x_return_status := FND_API.G_RET_STS_SUCCESS;

294:
295: IF (p_eam_wo_comp_rec.transaction_date < l_min_open_period) THEN
296: raise fnd_api.g_exc_unexpected_error;
297: END IF;
298: x_return_status := FND_API.G_RET_STS_SUCCESS;
299: exception
300: when others then
301:
302: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';

Line 314: x_return_status := FND_API.G_RET_STS_ERROR;

310: , x_mesg_token_tbl => l_out_mesg_token_tbl
311: );
312: l_mesg_token_tbl := l_out_mesg_token_tbl;
313:
314: x_return_status := FND_API.G_RET_STS_ERROR;
315: x_mesg_token_tbl := l_mesg_token_tbl ;
316: return;
317:
318: end;

Line 324: raise fnd_api.g_exc_unexpected_error;

320:
321: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check shutdown start and end date'); END IF;
322: begin
323: IF p_eam_wo_comp_rec.shutdown_start_date > p_eam_wo_comp_rec.shutdown_end_date THEN
324: raise fnd_api.g_exc_unexpected_error;
325: END IF;
326:
327: x_return_status := FND_API.G_RET_STS_SUCCESS;
328:

Line 327: x_return_status := FND_API.G_RET_STS_SUCCESS;

323: IF p_eam_wo_comp_rec.shutdown_start_date > p_eam_wo_comp_rec.shutdown_end_date THEN
324: raise fnd_api.g_exc_unexpected_error;
325: END IF;
326:
327: x_return_status := FND_API.G_RET_STS_SUCCESS;
328:
329: exception
330: when others then
331:

Line 344: x_return_status := FND_API.G_RET_STS_ERROR;

340: , x_mesg_token_tbl => l_out_mesg_token_tbl
341: );
342: l_mesg_token_tbl := l_out_mesg_token_tbl;
343:
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: x_mesg_token_tbl := l_mesg_token_tbl ;
346: return;
347: end;
348:

Line 390: raise fnd_api.g_exc_unexpected_error;

386: if (
387: ((p_eam_wo_comp_rec.actual_end_date < l_max_compl_op_date) AND (l_max_compl_op_date - p_eam_wo_comp_rec.actual_end_date > (0.000011575 * 60 ))) OR
388: ((p_eam_wo_comp_rec.actual_start_date > l_min_compl_op_date) AND (p_eam_wo_comp_rec.actual_start_date - l_min_compl_op_date > (0.000011575 * 60 )))
389: )then
390: raise fnd_api.g_exc_unexpected_error;
391:
392: end if;
393:
394: -- if p_actual_start_date is close to l_min_compl_op_date by a min or p_actual_end_date is close to l_max_compl_op_date

Line 425: x_return_status := FND_API.G_RET_STS_ERROR;

421: , x_mesg_token_tbl => l_out_mesg_token_tbl
422: );
423: l_mesg_token_tbl := l_out_mesg_token_tbl;
424:
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: x_mesg_token_tbl := l_mesg_token_tbl ;
427: return;
428:
429: end;

Line 439: raise fnd_api.g_exc_unexpected_error;

435: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE then
436:
437: begin
438: IF p_eam_wo_comp_rec.actual_duration < 0 THEN
439: raise fnd_api.g_exc_unexpected_error;
440: END IF;
441:
442: x_return_status := FND_API.G_RET_STS_SUCCESS;
443:

Line 442: x_return_status := FND_API.G_RET_STS_SUCCESS;

438: IF p_eam_wo_comp_rec.actual_duration < 0 THEN
439: raise fnd_api.g_exc_unexpected_error;
440: END IF;
441:
442: x_return_status := FND_API.G_RET_STS_SUCCESS;
443:
444: exception
445: when others then
446:

Line 459: x_return_status := FND_API.G_RET_STS_ERROR;

455: , x_mesg_token_tbl => l_out_mesg_token_tbl
456: );
457: l_mesg_token_tbl := l_out_mesg_token_tbl;
458:
459: x_return_status := FND_API.G_RET_STS_ERROR;
460: x_mesg_token_tbl := l_mesg_token_tbl ;
461: return;
462: end;
463: end if;

Line 472: raise fnd_api.g_exc_unexpected_error;

468: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE then
469: begin
470:
471: IF p_eam_wo_comp_rec.actual_end_date > sysdate THEN
472: raise fnd_api.g_exc_unexpected_error;
473: END IF;
474:
475: x_return_status := FND_API.G_RET_STS_SUCCESS;
476: exception

Line 475: x_return_status := FND_API.G_RET_STS_SUCCESS;

471: IF p_eam_wo_comp_rec.actual_end_date > sysdate THEN
472: raise fnd_api.g_exc_unexpected_error;
473: END IF;
474:
475: x_return_status := FND_API.G_RET_STS_SUCCESS;
476: exception
477: when others then
478:
479: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 488: x_return_status := FND_API.G_RET_STS_ERROR;

484: , x_mesg_token_tbl => l_out_mesg_token_tbl
485: );
486: l_mesg_token_tbl := l_out_mesg_token_tbl;
487:
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: x_mesg_token_tbl := l_mesg_token_tbl ;
490: return;
491: end;
492: end if;

Line 672: x_return_status := FND_API.G_RET_STS_ERROR;

668: , x_mesg_token_tbl => l_out_mesg_token_tbl
669: );
670: l_mesg_token_tbl := l_out_mesg_token_tbl;
671:
672: x_return_status := FND_API.G_RET_STS_ERROR;
673: x_mesg_token_tbl := l_mesg_token_tbl ;
674: return;
675:
676: WHEN G_EXC_NOT_ENOUGH_VALUES THEN

Line 689: x_return_status := FND_API.G_RET_STS_ERROR;

685: , x_mesg_token_tbl => l_out_mesg_token_tbl
686: );
687: l_mesg_token_tbl := l_out_mesg_token_tbl;
688:
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: x_mesg_token_tbl := l_mesg_token_tbl ;
691: return;
692:
693: WHEN G_EXC_LOCATOR_DEFAULT THEN

Line 706: x_return_status := FND_API.G_RET_STS_ERROR;

702: , x_mesg_token_tbl => l_out_mesg_token_tbl
703: );
704: l_mesg_token_tbl := l_out_mesg_token_tbl;
705:
706: x_return_status := FND_API.G_RET_STS_ERROR;
707: x_mesg_token_tbl := l_mesg_token_tbl ;
708: return;
709: WHEN G_EXC_RET_MAT_LOCATOR_NEEDED THEN
710: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';

Line 722: x_return_status := FND_API.G_RET_STS_ERROR;

718: , x_mesg_token_tbl => l_out_mesg_token_tbl
719: );
720: l_mesg_token_tbl := l_out_mesg_token_tbl;
721:
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: x_mesg_token_tbl := l_mesg_token_tbl ;
724: return;
725: WHEN G_EXC_RET_MAT_LOCATOR_RESTRIC THEN
726: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';

Line 738: x_return_status := FND_API.G_RET_STS_ERROR;

734: , x_mesg_token_tbl => l_out_mesg_token_tbl
735: );
736: l_mesg_token_tbl := l_out_mesg_token_tbl;
737:
738: x_return_status := FND_API.G_RET_STS_ERROR;
739: x_mesg_token_tbl := l_mesg_token_tbl ;
740: return;
741: WHEN G_EXC_NO_LOT_NUMBER THEN
742: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';

Line 754: x_return_status := FND_API.G_RET_STS_ERROR;

750: , x_mesg_token_tbl => l_out_mesg_token_tbl
751: );
752: l_mesg_token_tbl := l_out_mesg_token_tbl;
753:
754: x_return_status := FND_API.G_RET_STS_ERROR;
755: x_mesg_token_tbl := l_mesg_token_tbl ;
756: return;
757: WHEN G_EXC_LOT_NEEDED THEN
758: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';

Line 770: x_return_status := FND_API.G_RET_STS_ERROR;

766: , x_mesg_token_tbl => l_out_mesg_token_tbl
767: );
768: l_mesg_token_tbl := l_out_mesg_token_tbl;
769:
770: x_return_status := FND_API.G_RET_STS_ERROR;
771: x_mesg_token_tbl := l_mesg_token_tbl ;
772: return;
773: WHEN G_EXC_LOT_NOT_NEEDED THEN
774: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';

Line 786: x_return_status := FND_API.G_RET_STS_ERROR;

782: , x_mesg_token_tbl => l_out_mesg_token_tbl
783: );
784: l_mesg_token_tbl := l_out_mesg_token_tbl;
785:
786: x_return_status := FND_API.G_RET_STS_ERROR;
787: x_mesg_token_tbl := l_mesg_token_tbl ;
788: return;
789: end;
790:

Line 812: raise fnd_api.g_exc_unexpected_error;

808: AND wdj.status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,
809: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED,WIP_CONSTANTS.CANCELLED ));
810:
811: if (child_job_var = '1') then
812: raise fnd_api.g_exc_unexpected_error;
813: end if;
814: exception
815: WHEN NO_DATA_FOUND THEN
816: null;

Line 830: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 862: x_return_status := FND_API.G_RET_STS_ERROR;

858: , x_mesg_token_tbl => l_out_mesg_token_tbl
859: );
860: l_mesg_token_tbl := l_out_mesg_token_tbl;
861:
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: x_mesg_token_tbl := l_mesg_token_tbl ;
864: return;
865: end;
866: end if;

Line 892: raise fnd_api.g_exc_unexpected_error;

888:
889: );
890:
891: if (network_child_job_var = '1') then --In the network Work Order has Uncompleted Child Work Orders
892: raise fnd_api.g_exc_unexpected_error;
893: end if;
894:
895: exception
896: WHEN NO_DATA_FOUND THEN

Line 911: x_return_status := FND_API.G_RET_STS_ERROR;

907: , x_mesg_token_tbl => l_out_mesg_token_tbl
908: );
909: l_mesg_token_tbl := l_out_mesg_token_tbl;
910:
911: x_return_status := FND_API.G_RET_STS_ERROR;
912: x_mesg_token_tbl := l_mesg_token_tbl ;
913: return;
914: end;
915: end if;

Line 939: raise fnd_api.g_exc_unexpected_error;

935: WIP_CONSTANTS.COMP_NOCHRG,WIP_CONSTANTS.CLOSED)
936: );
937:
938: IF (sibling_parent_job_var = '1') THEN
939: raise fnd_api.g_exc_unexpected_error;
940: END IF;
941: exception
942: WHEN NO_DATA_FOUND THEN
943: null;

Line 957: x_return_status := FND_API.G_RET_STS_ERROR;

953: , x_mesg_token_tbl => l_out_mesg_token_tbl
954: );
955: l_mesg_token_tbl := l_out_mesg_token_tbl;
956:
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: x_mesg_token_tbl := l_mesg_token_tbl ;
959: return;
960: end;
961: end if;

Line 980: raise fnd_api.g_exc_unexpected_error;

976: FROM WIP_DISCRETE_JOBS
977: WHERE wip_entity_id = l_parent_wip_entity_id;
978:
979: IF(l_parent_status_type = WIP_CONSTANTS.COMP_CHRG) THEN
980: raise fnd_api.g_exc_unexpected_error;
981: END IF;
982:
983: END IF;
984: exception

Line 998: x_return_status := FND_API.G_RET_STS_ERROR;

994: , x_mesg_token_tbl => l_out_mesg_token_tbl
995: );
996: l_mesg_token_tbl := l_out_mesg_token_tbl;
997:
998: x_return_status := FND_API.G_RET_STS_ERROR;
999: x_mesg_token_tbl := l_mesg_token_tbl ;
1000: return;
1001: end;
1002:

Line 1026: x_return_status := FND_API.G_RET_STS_SUCCESS;

1022: BEGIN
1023:
1024: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Check_Attributes_b4_Defaulting'); END IF;
1025:
1026: x_return_status := FND_API.G_RET_STS_SUCCESS;
1027:
1028: -- organization_id
1029: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check organization_id'); END IF;
1030:

Line 1046: raise fnd_api.g_exc_unexpected_error;

1042: from hr_organization_units hou
1043: where organization_id = p_eam_wo_comp_rec.organization_id;
1044:
1045: if(l_disable_date < sysdate) then
1046: raise fnd_api.g_exc_unexpected_error;
1047: end if;
1048:
1049: x_return_status := FND_API.G_RET_STS_SUCCESS;
1050:

Line 1049: x_return_status := FND_API.G_RET_STS_SUCCESS;

1045: if(l_disable_date < sysdate) then
1046: raise fnd_api.g_exc_unexpected_error;
1047: end if;
1048:
1049: x_return_status := FND_API.G_RET_STS_SUCCESS;
1050:
1051: exception
1052: when others then
1053:

Line 1066: x_return_status := FND_API.G_RET_STS_ERROR;

1062: , x_mesg_token_tbl => l_out_mesg_token_tbl
1063: );
1064: l_mesg_token_tbl := l_out_mesg_token_tbl;
1065:
1066: x_return_status := FND_API.G_RET_STS_ERROR;
1067: x_mesg_token_tbl := l_mesg_token_tbl ;
1068: return;
1069:
1070: end;

Line 1085: x_return_status := FND_API.G_RET_STS_SUCCESS;

1081: where wep.organization_id = mp.organization_id
1082: and mp.eam_enabled_flag = 'Y'
1083: and wep.organization_id = p_eam_wo_comp_rec.organization_id;
1084:
1085: x_return_status := FND_API.G_RET_STS_SUCCESS;
1086:
1087: exception
1088: when others then
1089:

Line 1102: x_return_status := FND_API.G_RET_STS_ERROR;

1098: , x_mesg_token_tbl => l_out_mesg_token_tbl
1099: );
1100: l_mesg_token_tbl := l_out_mesg_token_tbl;
1101:
1102: x_return_status := FND_API.G_RET_STS_ERROR;
1103: x_mesg_token_tbl := l_mesg_token_tbl ;
1104: return;
1105:
1106: end;