[Home] [Help]
92: )IS
93:
94: G_EXC_SEV_QUIT_OBJECT EXCEPTION;
95: G_EXC_UNEXP_SKIP_OBJECT EXCEPTION;
96: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
97: l_other_message VARCHAR2(50);
98: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
99: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
100: l_err_text VARCHAR2(2000);
94: G_EXC_SEV_QUIT_OBJECT EXCEPTION;
95: G_EXC_UNEXP_SKIP_OBJECT EXCEPTION;
96: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
97: l_other_message VARCHAR2(50);
98: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
99: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
100: l_err_text VARCHAR2(2000);
101: l_return_status VARCHAR2(1) := null;
102: l_eam_return_status VARCHAR2(1) := null;
95: G_EXC_UNEXP_SKIP_OBJECT EXCEPTION;
96: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
97: l_other_message VARCHAR2(50);
98: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
99: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
100: l_err_text VARCHAR2(2000);
101: l_return_status VARCHAR2(1) := null;
102: l_eam_return_status VARCHAR2(1) := null;
103: l_msg_count NUMBER;
164: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
165: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
166: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
167: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
168: l_out_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.mesg_token_tbl_type;
169:
170: l_out_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
171: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
172: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
187: l_out_eam_sub_res_tbl_main EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
188: l_out_eam_res_usage_tbl_main EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
189: l_out_eam_mat_req_tbl_main EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
190: l_out_eam_di_tbl_main EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
191: l_out_mesg_token_tbl_main EAM_ERROR_MESSAGE_PVT.mesg_token_tbl_type;
192:
193: l_out_eam_wo_comp_rec_main EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
194: l_out_eam_wo_comp_tbl_main EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
195: l_out_eam_wo_quality_tbl_main EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
224: -- Initialize the message list if the user has set the Init Message List parameter
225: --
226: IF p_init_msg_list
227: THEN
228: EAM_ERROR_MESSAGE_PVT.Initialize;
229: END IF;
230:
231:
232:
249:
250: -- If debug is Y then out dir must be specified
251:
252: l_out_mesg_token_tbl := l_mesg_token_tbl;
253: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
254: ( p_Message_text => 'Debug is set to Y so an output directory' || ' must be specified. Debug will be turned' || ' off since no directory is specified'
255: , p_Mesg_Token_Tbl => l_mesg_token_tbl
256: , x_Mesg_Token_Tbl => l_out_mesg_token_tbl
257: , p_Token_Tbl => l_token_tbl
276: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
277: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
278: l_out_eam_request_tbl := l_eam_request_tbl;
279:
280: EAM_ERROR_MESSAGE_PVT.Log_Error
281: ( p_eam_wo_rec => l_eam_wo_rec
282: , p_eam_op_tbl => l_eam_op_tbl
283: , p_eam_op_network_tbl => l_eam_op_network_tbl
284: , p_eam_res_tbl => l_eam_res_tbl
288: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
289: , p_eam_direct_items_tbl => l_eam_di_tbl
290: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
291: , p_error_status => 'W'
292: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
293: , x_eam_wo_rec => l_out_eam_wo_rec
294: , x_eam_op_tbl => l_out_eam_op_tbl
295: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
296: , x_eam_res_tbl => l_out_eam_res_tbl
328: IF trim(p_debug_filename) IS NULL OR trim(p_debug_filename) = ''
329: THEN
330:
331: l_out_mesg_token_tbl := l_mesg_token_tbl;
332: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
333: ( p_Message_text => 'Debug is set to Y so an output filename' || ' must be specified. Debug will be turned' || ' off since no filename is specified'
334: , p_Mesg_Token_Tbl => l_mesg_token_tbl
335: , x_Mesg_Token_Tbl => l_out_mesg_token_tbl
336: , p_Token_Tbl => l_token_tbl
355: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
356: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
357: l_out_eam_request_tbl := l_eam_request_tbl;
358:
359: EAM_ERROR_MESSAGE_PVT.Log_Error
360: ( p_eam_wo_rec => l_eam_wo_rec
361: , p_eam_op_tbl => l_eam_op_tbl
362: , p_eam_op_network_tbl => l_eam_op_network_tbl
363: , p_eam_res_tbl => l_eam_res_tbl
367: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
368: , p_eam_direct_items_tbl => l_eam_di_tbl
369: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
370: , p_error_status => 'W'
371: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
372: , x_eam_wo_rec => l_out_eam_wo_rec
373: , x_eam_op_tbl => l_out_eam_op_tbl
374: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
375: , x_eam_res_tbl => l_out_eam_res_tbl
407:
408: IF l_debug_flag = 'Y'
409: THEN
410: l_out_mesg_token_tbl := l_mesg_token_tbl;
411: EAM_ERROR_MESSAGE_PVT.Open_Debug_Session
412: ( p_debug_filename => p_debug_filename
413: , p_output_dir => p_output_dir
414: , p_debug_file_mode => l_debug_file_mode
415: , x_return_status => l_return_status
586: x_eam_op_comp_tbl := p_eam_op_comp_tbl;
587:
588:
589: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
590: EAM_ERROR_MESSAGE_PVT.Write_Debug('') ;
591: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Start============================================================================') ;
592: END IF ;
593:
594: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling CHECK_BO_NETWORK ...') ; END IF ;
587:
588:
589: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
590: EAM_ERROR_MESSAGE_PVT.Write_Debug('') ;
591: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Start============================================================================') ;
592: END IF ;
593:
594: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling CHECK_BO_NETWORK ...') ; END IF ;
595:
590: EAM_ERROR_MESSAGE_PVT.Write_Debug('') ;
591: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Start============================================================================') ;
592: END IF ;
593:
594: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling CHECK_BO_NETWORK ...') ; END IF ;
595:
596:
597: CHECK_BO_NETWORK
598: ( p_eam_wo_tbl => l_eam_wo_tbl
675: l_out_eam_op_comp_tbl.delete;
676: l_out_eam_request_tbl.delete;
677:
678:
679: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : CHECK_BO_NETWORK completed with status ='||l_return_status) ; END IF ;
680:
681: if nvl(l_return_status,FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS then
682:
683: l_out_mesg_token_tbl := l_mesg_token_tbl;
680:
681: if nvl(l_return_status,FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS then
682:
683: l_out_mesg_token_tbl := l_mesg_token_tbl;
684: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
685: ( p_message_name => 'EAM_WN_BO_NET_ERR'
686: , p_token_tbl => l_token_tbl
687: , p_mesg_token_tbl => l_mesg_token_tbl
688: , x_mesg_token_tbl => l_out_mesg_token_tbl
707: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
708: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
709: l_out_eam_request_tbl := l_eam_request_tbl;
710:
711: EAM_ERROR_MESSAGE_PVT.Log_Error
712: ( p_eam_wo_rec => l_eam_wo_rec
713: , p_eam_op_tbl => l_eam_op_tbl
714: , p_eam_op_network_tbl => l_eam_op_network_tbl
715: , p_eam_res_tbl => l_eam_res_tbl
719: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
720: , p_eam_direct_items_tbl => l_eam_di_tbl
721: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
722: , p_error_status => 'W'
723: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
724: , x_eam_wo_rec => l_out_eam_wo_rec
725: , x_eam_op_tbl => l_out_eam_op_tbl
726: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
727: , x_eam_res_tbl => l_out_eam_res_tbl
752: l_eam_request_tbl := l_out_eam_request_tbl;
753:
754: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
755: THEN
756: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
757: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
758: END IF;
759:
760:
753:
754: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
755: THEN
756: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
757: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
758: END IF;
759:
760:
761: l_eam_return_status := FND_API.G_RET_STS_ERROR;
759:
760:
761: l_eam_return_status := FND_API.G_RET_STS_ERROR;
762: x_return_status := FND_API.G_RET_STS_ERROR;
763: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
764: return;
765: end if;
766:
767:
766:
767:
768: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
769: THEN
770: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
771: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
772: END IF;
773:
774:
767:
768: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
769: THEN
770: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
771: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
772: END IF;
773:
774:
775:
963: l_token_tbl(1).token_name := 'Header Id';
964: l_token_tbl(1).token_value := l_eam_wo_rec_head.header_id;
965:
966: l_out_mesg_token_tbl := l_mesg_token_tbl;
967: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
968: ( p_message_name => 'EAM_WN_GEN_WARNING'
969: , p_token_tbl => l_token_tbl
970: , p_mesg_token_tbl => l_mesg_token_tbl
971: , x_mesg_token_tbl => l_out_mesg_token_tbl
972: );
973: l_mesg_token_tbl := l_out_mesg_token_tbl;
974:
975:
976: EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
977: ( p_mesg_token_tbl => l_mesg_token_tbl
978: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
979: , p_entity_index => l_eam_wo_rec_head.row_id
980: , p_application_id => 'EAM'
974:
975:
976: EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
977: ( p_mesg_token_tbl => l_mesg_token_tbl
978: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
979: , p_entity_index => l_eam_wo_rec_head.row_id
980: , p_application_id => 'EAM'
981: );
982:
1034: and l_return_status = 'S' then
1035: l_eam_wo_list(l_eam_wo_list.count + 1) := l_out_eam_wo_rec.wip_entity_name;
1036: end if;
1037:
1038: -- IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Size of the list of newly created work orders:'||l_eam_wo_list.count) ; END IF ;
1039:
1040: if l_out_eam_wo_rec.transaction_type is not null then
1041: l_eam_wo_tbl(l_out_eam_wo_rec.row_id) := l_out_eam_wo_rec;
1042: end if;
1209:
1210: -- Delete the general warning message from both the fnd and eam message stacks
1211: fnd_msg_pub.delete_msg(p_msg_index => fnd_msg_pub.Count_Msg);
1212:
1213: EAM_ERROR_MESSAGE_PVT.Delete_Message;
1214:
1215: x_msg_count := EAM_ERROR_MESSAGE_PVT.GET_MESSAGE_COUNT();
1216:
1217:
1211: fnd_msg_pub.delete_msg(p_msg_index => fnd_msg_pub.Count_Msg);
1212:
1213: EAM_ERROR_MESSAGE_PVT.Delete_Message;
1214:
1215: x_msg_count := EAM_ERROR_MESSAGE_PVT.GET_MESSAGE_COUNT();
1216:
1217:
1218:
1219: -- Populate the wip_entity_id for newly created work orders
1261:
1262: -- If debug is Y then out dir must be specified
1263:
1264: l_out_mesg_token_tbl := l_mesg_token_tbl;
1265: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1266: ( p_Message_text => 'Debug is set to Y so an output directory' || ' must be specified. Debug will be turned' || ' off since no directory is specified'
1267: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1268: , x_Mesg_Token_Tbl => l_out_mesg_token_tbl
1269: , p_Token_Tbl => l_token_tbl
1279: l_out_eam_res_usage_tbl := l_eam_res_usage_tbl;
1280: l_out_eam_mat_req_tbl := l_eam_mat_req_tbl;
1281: l_out_eam_di_tbl := l_eam_di_tbl;
1282:
1283: EAM_ERROR_MESSAGE_PVT.Log_Error
1284: ( p_eam_wo_rec => l_eam_wo_rec
1285: , p_eam_op_tbl => l_eam_op_tbl
1286: , p_eam_op_network_tbl => l_eam_op_network_tbl
1287: , p_eam_res_tbl => l_eam_res_tbl
1291: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
1292: , p_eam_direct_items_tbl => l_eam_di_tbl
1293: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1294: , p_error_status => 'W'
1295: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
1296: , x_eam_wo_rec => l_out_eam_wo_rec
1297: , x_eam_op_tbl => l_out_eam_op_tbl
1298: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
1299: , x_eam_res_tbl => l_out_eam_res_tbl
1330: IF trim(p_debug_filename) IS NULL OR trim(p_debug_filename) = ''
1331: THEN
1332:
1333: l_out_mesg_token_tbl := l_mesg_token_tbl;
1334: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1335: ( p_Message_text => 'Debug is set to Y so an output filename' || ' must be specified. Debug will be turned' || ' off since no filename is specified'
1336: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1337: , x_Mesg_Token_Tbl => l_out_mesg_token_tbl
1338: , p_Token_Tbl => l_token_tbl
1357: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
1358: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
1359: l_out_eam_request_tbl := l_eam_request_tbl;
1360:
1361: EAM_ERROR_MESSAGE_PVT.Log_Error
1362: ( p_eam_wo_rec => l_eam_wo_rec
1363: , p_eam_op_tbl => l_eam_op_tbl
1364: , p_eam_op_network_tbl => l_eam_op_network_tbl
1365: , p_eam_res_tbl => l_eam_res_tbl
1369: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
1370: , p_eam_direct_items_tbl => l_eam_di_tbl
1371: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1372: , p_error_status => 'W'
1373: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
1374: , x_eam_wo_rec => l_out_eam_wo_rec
1375: , x_eam_op_tbl => l_out_eam_op_tbl
1376: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
1377: , x_eam_res_tbl => l_out_eam_res_tbl
1409:
1410: IF l_debug_flag = 'Y'
1411: THEN
1412: l_out_mesg_token_tbl := l_mesg_token_tbl;
1413: EAM_ERROR_MESSAGE_PVT.Open_Debug_Session
1414: ( p_debug_filename => p_debug_filename
1415: , p_output_dir => p_output_dir
1416: , p_debug_file_mode => 'a'
1417: , x_return_status => l_return_status
1450:
1451:
1452: l_temp_wip_entity_id := l_eam_wo_relations_tbl(i).PARENT_OBJECT_ID;
1453:
1454: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling the EAM_WO_NETWORK_DEFAULT_PVT.Check_Wo_Dates ') ; END IF ;
1455:
1456: FOR l_temp_index in 1..2 LOOP
1457:
1458: if (l_eam_wo_relations_tbl(i).parent_relationship_type = 1) then
1470: x_msg_data => l_msg_data
1471: );
1472:
1473: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 1 ) THEN
1474: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Check_Wo_Dates for parent wo completed with status of '||l_return_status) ;
1475: END IF ;
1476: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 2 ) THEN
1477: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Check_Wo_Dates for child wo completed with status of '||l_return_status) ;
1478: END IF ;
1473: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 1 ) THEN
1474: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Check_Wo_Dates for parent wo completed with status of '||l_return_status) ;
1475: END IF ;
1476: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 2 ) THEN
1477: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Check_Wo_Dates for child wo completed with status of '||l_return_status) ;
1478: END IF ;
1479:
1480: IF l_return_status = FND_API.G_RET_STS_ERROR OR
1481: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1481: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1482:
1483: --Before inserting the error message, insert the confirmation message of work order creation.
1484: x_return_status := l_return_status;
1485: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
1486: l_eam_return_status := FND_API.G_RET_STS_ERROR;
1487:
1488: if l_eam_wo_list.count > 0 then
1489: for l_new_wo_list in l_eam_wo_list.first..l_eam_wo_list.last loop
1501: eam_execution_jsp.add_message(p_app_short_name => 'EAM',
1502: p_msg_name => 'EAM_WO_CHK_DATES_ERR',
1503: p_token1 => 'WORKORDER', p_value1 => l_wo_name);
1504:
1505: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
1506: l_eam_return_status := FND_API.G_RET_STS_ERROR;
1507: end if;
1508: end if;
1509: l_temp_wip_entity_id := l_eam_wo_relations_tbl(i).CHILD_OBJECT_ID;
1513: if l_eam_wo_relations_tbl(i).parent_relationship_type in (1,3,4) then
1514:
1515: SAVEPOINT Add_WO_To_Network_Start;
1516:
1517: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling the AEAM_WO_NETWORK_DEFAULT_PVT.add_WO_To_Network ') ; END IF ;
1518:
1519: EAM_WO_NETWORK_DEFAULT_PVT.Add_WO_To_Network(
1520: p_api_version => 1.0,
1521: p_init_msg_list => FND_API.G_FALSE,
1562: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
1563: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
1564: l_out_eam_request_tbl := l_eam_request_tbl;
1565:
1566: EAM_ERROR_MESSAGE_PVT.Log_Error
1567: ( p_eam_wo_rec => l_eam_wo_rec
1568: , p_eam_op_tbl => l_eam_op_tbl
1569: , p_eam_op_network_tbl => l_eam_op_network_tbl
1570: , p_eam_res_tbl => l_eam_res_tbl
1574: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
1575: , p_eam_direct_items_tbl => l_eam_di_tbl
1576: , p_mesg_token_tbl => l_mesg_token_tbl
1577: , p_error_status => FND_API.G_RET_STS_ERROR
1578: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1579: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1580: , p_other_message => l_other_message
1581: , p_other_token_tbl => l_other_token_tbl
1582: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1575: , p_eam_direct_items_tbl => l_eam_di_tbl
1576: , p_mesg_token_tbl => l_mesg_token_tbl
1577: , p_error_status => FND_API.G_RET_STS_ERROR
1578: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1579: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1580: , p_other_message => l_other_message
1581: , p_other_token_tbl => l_other_token_tbl
1582: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1583: , x_eam_wo_rec => l_out_eam_wo_rec
1578: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1579: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1580: , p_other_message => l_other_message
1581: , p_other_token_tbl => l_other_token_tbl
1582: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1583: , x_eam_wo_rec => l_out_eam_wo_rec
1584: , x_eam_op_tbl => l_out_eam_op_tbl
1585: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
1586: , x_eam_res_tbl => l_out_eam_res_tbl
1617: elsif l_eam_wo_relations_tbl(i).parent_relationship_type = 2 then
1618:
1619: SAVEPOINT Add_Dependency_Start;
1620:
1621: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling the EAM_WO_NETWORK_DEFAULT_PVT.Add_Dependency') ; END IF ;
1622:
1623: EAM_WO_NETWORK_DEFAULT_PVT.Add_Dependency
1624: (
1625: p_api_version => 1.0,
1666: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
1667: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
1668: l_out_eam_request_tbl := l_eam_request_tbl;
1669:
1670: EAM_ERROR_MESSAGE_PVT.Log_Error
1671: ( p_eam_wo_rec => l_eam_wo_rec
1672: , p_eam_op_tbl => l_eam_op_tbl
1673: , p_eam_op_network_tbl => l_eam_op_network_tbl
1674: , p_eam_res_tbl => l_eam_res_tbl
1678: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
1679: , p_eam_direct_items_tbl => l_eam_di_tbl
1680: , p_mesg_token_tbl => l_mesg_token_tbl
1681: , p_error_status => FND_API.G_RET_STS_ERROR
1682: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1683: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1684: , p_other_message => l_other_message
1685: , p_other_token_tbl => l_other_token_tbl
1686: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1679: , p_eam_direct_items_tbl => l_eam_di_tbl
1680: , p_mesg_token_tbl => l_mesg_token_tbl
1681: , p_error_status => FND_API.G_RET_STS_ERROR
1682: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1683: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1684: , p_other_message => l_other_message
1685: , p_other_token_tbl => l_other_token_tbl
1686: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1687: , x_eam_wo_rec => l_out_eam_wo_rec
1682: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1683: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1684: , p_other_message => l_other_message
1685: , p_other_token_tbl => l_other_token_tbl
1686: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1687: , x_eam_wo_rec => l_out_eam_wo_rec
1688: , x_eam_op_tbl => l_out_eam_op_tbl
1689: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
1690: , x_eam_res_tbl => l_out_eam_res_tbl
1724: if l_eam_wo_relations_tbl(i).parent_relationship_type in (1,3,4) then
1725:
1726: SAVEPOINT Delink_Relation_Start;
1727:
1728: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling the Delink_Child_From_parent procedure ... ') ; END IF ;
1729:
1730: EAM_WO_NETWORK_DEFAULT_PVT.Delink_Child_From_Parent
1731: (
1732: p_api_version => 1.0,
1776: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
1777: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
1778: l_out_eam_request_tbl := l_eam_request_tbl;
1779:
1780: EAM_ERROR_MESSAGE_PVT.Log_Error
1781: ( p_eam_wo_rec => l_eam_wo_rec
1782: , p_eam_op_tbl => l_eam_op_tbl
1783: , p_eam_op_network_tbl => l_eam_op_network_tbl
1784: , p_eam_res_tbl => l_eam_res_tbl
1788: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
1789: , p_eam_direct_items_tbl => l_eam_di_tbl
1790: , p_mesg_token_tbl => l_mesg_token_tbl
1791: , p_error_status => FND_API.G_RET_STS_ERROR
1792: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1793: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1794: , p_other_message => l_other_message
1795: , p_other_token_tbl => l_other_token_tbl
1796: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1789: , p_eam_direct_items_tbl => l_eam_di_tbl
1790: , p_mesg_token_tbl => l_mesg_token_tbl
1791: , p_error_status => FND_API.G_RET_STS_ERROR
1792: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1793: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1794: , p_other_message => l_other_message
1795: , p_other_token_tbl => l_other_token_tbl
1796: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1797: , x_eam_wo_rec => l_out_eam_wo_rec
1792: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1793: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1794: , p_other_message => l_other_message
1795: , p_other_token_tbl => l_other_token_tbl
1796: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1797: , x_eam_wo_rec => l_out_eam_wo_rec
1798: , x_eam_op_tbl => l_out_eam_op_tbl
1799: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
1800: , x_eam_res_tbl => l_out_eam_res_tbl
1829:
1830: elsif l_eam_wo_relations_tbl(i).parent_relationship_type = 2 then
1831:
1832: SAVEPOINT Delete_Dependency_Start;
1833: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling the Delete_Dependency procedure ... ') ; END IF ;
1834:
1835: EAM_WO_NETWORK_DEFAULT_PVT.Delete_Dependency
1836: (
1837: p_api_version => 1.0,
1881: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
1882: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
1883: l_out_eam_request_tbl := l_eam_request_tbl;
1884:
1885: EAM_ERROR_MESSAGE_PVT.Log_Error
1886: ( p_eam_wo_rec => l_eam_wo_rec
1887: , p_eam_op_tbl => l_eam_op_tbl
1888: , p_eam_op_network_tbl => l_eam_op_network_tbl
1889: , p_eam_res_tbl => l_eam_res_tbl
1893: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
1894: , p_eam_direct_items_tbl => l_eam_di_tbl
1895: , p_mesg_token_tbl => l_mesg_token_tbl
1896: , p_error_status => FND_API.G_RET_STS_ERROR
1897: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1898: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1899: , p_other_message => l_other_message
1900: , p_other_token_tbl => l_other_token_tbl
1901: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1894: , p_eam_direct_items_tbl => l_eam_di_tbl
1895: , p_mesg_token_tbl => l_mesg_token_tbl
1896: , p_error_status => FND_API.G_RET_STS_ERROR
1897: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1898: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1899: , p_other_message => l_other_message
1900: , p_other_token_tbl => l_other_token_tbl
1901: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1902: , x_eam_wo_rec => l_out_eam_wo_rec
1897: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1898: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1899: , p_other_message => l_other_message
1900: , p_other_token_tbl => l_other_token_tbl
1901: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1902: , x_eam_wo_rec => l_out_eam_wo_rec
1903: , x_eam_op_tbl => l_out_eam_op_tbl
1904: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
1905: , x_eam_res_tbl => l_out_eam_res_tbl
1946: -- Call Validate Structure. If it returns error, then rollback everything
1947:
1948: IF l_eam_wo_tbl.count <> 0 and l_eam_wo_tbl(l_eam_wo_tbl.first).validate_structure = 'Y' then -- added for bug# 3544860
1949:
1950: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling the Validate_Structure procedure ... ') ; END IF ;
1951:
1952: EAM_WO_NETWORK_VALIDATE_PVT.Validate_Structure
1953: (
1954: p_api_version => 1.0,
1975:
1976: x_return_status := l_return_status; -- added for bug# 3544860
1977:
1978: l_out_mesg_token_tbl := l_mesg_token_tbl;
1979: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1980: ( p_message_name => 'EAM_WN_MAIN_VALIDATE_STRUCT'
1981: , p_token_tbl => l_token_tbl
1982: , p_mesg_token_tbl => l_mesg_token_tbl
1983: , x_mesg_token_tbl => l_out_mesg_token_tbl
2003: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
2004: l_out_eam_request_tbl := l_eam_request_tbl;
2005:
2006:
2007: EAM_ERROR_MESSAGE_PVT.Log_Error
2008: ( p_eam_wo_rec => l_eam_wo_rec
2009: , p_eam_op_tbl => l_eam_op_tbl
2010: , p_eam_op_network_tbl => l_eam_op_network_tbl
2011: , p_eam_res_tbl => l_eam_res_tbl
2015: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
2016: , p_eam_direct_items_tbl => l_eam_di_tbl
2017: , p_mesg_token_tbl => l_mesg_token_tbl
2018: , p_error_status => FND_API.G_RET_STS_ERROR
2019: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
2020: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
2021: , p_other_message => l_other_message
2022: , p_other_token_tbl => l_other_token_tbl
2023: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
2016: , p_eam_direct_items_tbl => l_eam_di_tbl
2017: , p_mesg_token_tbl => l_mesg_token_tbl
2018: , p_error_status => FND_API.G_RET_STS_ERROR
2019: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
2020: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
2021: , p_other_message => l_other_message
2022: , p_other_token_tbl => l_other_token_tbl
2023: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
2024: , x_eam_wo_rec => l_out_eam_wo_rec
2019: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
2020: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
2021: , p_other_message => l_other_message
2022: , p_other_token_tbl => l_other_token_tbl
2023: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
2024: , x_eam_wo_rec => l_out_eam_wo_rec
2025: , x_eam_op_tbl => l_out_eam_op_tbl
2026: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
2027: , x_eam_res_tbl => l_out_eam_res_tbl
2102: if nvl(l_eam_return_status,FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS then
2103: x_return_status := FND_API.G_RET_STS_ERROR;
2104: end if;
2105:
2106: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
2107:
2108: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
2109: THEN
2110: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
2106: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
2107:
2108: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
2109: THEN
2110: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
2111: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
2112: END IF;
2113:
2114: -- Standard check of p_commit.
2107:
2108: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
2109: THEN
2110: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
2111: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
2112: END IF;
2113:
2114: -- Standard check of p_commit.
2115: IF p_commit = 'Y' THEN
2115: IF p_commit = 'Y' THEN
2116: COMMIT WORK;
2117: END IF;
2118:
2119: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : End ==================================================== ') ; END IF ;
2120:
2121: EXCEPTION
2122:
2123: WHEN OTHERS THEN
2121: EXCEPTION
2122:
2123: WHEN OTHERS THEN
2124:
2125: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
2126:
2127: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
2128: ( p_message_name => 'EAM_WN_UNKNOWN_ERROR'
2129: , p_token_tbl => l_token_tbl
2123: WHEN OTHERS THEN
2124:
2125: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
2126:
2127: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
2128: ( p_message_name => 'EAM_WN_UNKNOWN_ERROR'
2129: , p_token_tbl => l_token_tbl
2130: , p_mesg_token_tbl => l_mesg_token_tbl
2131: , x_mesg_token_tbl => l_out_mesg_token_tbl
2151: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
2152: l_out_eam_request_tbl := l_eam_request_tbl;
2153:
2154:
2155: EAM_ERROR_MESSAGE_PVT.Log_Error
2156: ( p_eam_wo_rec => l_eam_wo_rec
2157: , p_eam_op_tbl => l_eam_op_tbl
2158: , p_eam_op_network_tbl => l_eam_op_network_tbl
2159: , p_eam_res_tbl => l_eam_res_tbl
2163: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
2164: , p_eam_direct_items_tbl => l_eam_di_tbl
2165: , p_mesg_token_tbl => l_mesg_token_tbl
2166: , p_error_status => FND_API.G_RET_STS_ERROR
2167: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
2168: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
2169: , p_other_message => l_other_message
2170: , p_other_token_tbl => l_other_token_tbl
2171: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
2164: , p_eam_direct_items_tbl => l_eam_di_tbl
2165: , p_mesg_token_tbl => l_mesg_token_tbl
2166: , p_error_status => FND_API.G_RET_STS_ERROR
2167: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
2168: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
2169: , p_other_message => l_other_message
2170: , p_other_token_tbl => l_other_token_tbl
2171: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
2172: , x_eam_wo_rec => l_out_eam_wo_rec
2167: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
2168: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
2169: , p_other_message => l_other_message
2170: , p_other_token_tbl => l_other_token_tbl
2171: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
2172: , x_eam_wo_rec => l_out_eam_wo_rec
2173: , x_eam_op_tbl => l_out_eam_op_tbl
2174: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
2175: , x_eam_res_tbl => l_out_eam_res_tbl
2200: l_eam_request_tbl := l_out_eam_request_tbl;
2201:
2202: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
2203: THEN
2204: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
2205: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
2206: END IF;
2207:
2208:
2201:
2202: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
2203: THEN
2204: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
2205: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
2206: END IF;
2207:
2208:
2209: END PROCESS_MASTER_CHILD_WO;
3110: ) IS
3111:
3112: G_EXC_SEV_QUIT_OBJECT EXCEPTION;
3113: G_EXC_UNEXP_SKIP_OBJECT EXCEPTION;
3114: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
3115: l_other_message VARCHAR2(50);
3116: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
3117: l_err_text VARCHAR2(2000);
3118: l_return_status VARCHAR2(1);
3112: G_EXC_SEV_QUIT_OBJECT EXCEPTION;
3113: G_EXC_UNEXP_SKIP_OBJECT EXCEPTION;
3114: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
3115: l_other_message VARCHAR2(50);
3116: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
3117: l_err_text VARCHAR2(2000);
3118: l_return_status VARCHAR2(1);
3119: l_debug_file_mode VARCHAR2(1) := p_debug_file_mode;
3120: l_pending_flag VARCHAR2(1);
3147: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3148: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3149: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3150: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3151: l_out_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.mesg_token_tbl_type;
3152:
3153: l_out_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
3154: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3155: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3218:
3219: --
3220: -- Set Business Object Idenfier in the System Information record.
3221: --
3222: EAM_ERROR_MESSAGE_PVT.Set_Bo_Identifier
3223: (p_bo_identifier => p_bo_identifier);
3224:
3225: --
3226: -- Initialize the message list if the user has set the Init Message List parameter
3226: -- Initialize the message list if the user has set the Init Message List parameter
3227: --
3228: IF p_init_msg_list
3229: THEN
3230: EAM_ERROR_MESSAGE_PVT.Initialize;
3231: END IF;
3232:
3233: -- Set the global variable for debug.
3234: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);
3241:
3242: -- If debug is Y then out dir must be specified
3243:
3244: l_out_mesg_token_tbl := l_mesg_token_tbl;
3245: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
3246: ( p_Message_text => 'Debug is set to Y so an output directory' || ' must be specified. Debug will be turned' || ' off since no directory is specified'
3247: , p_Mesg_Token_Tbl => l_mesg_token_tbl
3248: , x_Mesg_Token_Tbl => l_out_mesg_token_tbl
3249: , p_Token_Tbl => l_token_tbl
3269: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
3270: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
3271: l_out_eam_request_tbl := l_eam_request_tbl;
3272:
3273: EAM_ERROR_MESSAGE_PVT.Log_Error
3274: ( p_eam_wo_rec => l_eam_wo_rec
3275: , p_eam_op_tbl => l_eam_op_tbl
3276: , p_eam_op_network_tbl => l_eam_op_network_tbl
3277: , p_eam_res_tbl => l_eam_res_tbl
3281: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
3282: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3283: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3284: , p_error_status => 'W'
3285: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3286: , x_eam_wo_rec => l_out_eam_wo_rec
3287: , x_eam_op_tbl => l_out_eam_op_tbl
3288: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
3289: , x_eam_res_tbl => l_out_eam_res_tbl
3320: IF trim(p_debug_filename) IS NULL OR trim(p_debug_filename) = ''
3321: THEN
3322:
3323: l_out_mesg_token_tbl := l_mesg_token_tbl;
3324: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
3325: ( p_Message_text => 'Debug is set to Y so an output filename' || ' must be specified. Debug will be turned' || ' off since no filename is specified'
3326: , p_Mesg_Token_Tbl => l_mesg_token_tbl
3327: , x_Mesg_Token_Tbl => l_out_mesg_token_tbl
3328: , p_Token_Tbl => l_token_tbl
3347: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
3348: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
3349: l_out_eam_request_tbl := l_eam_request_tbl;
3350:
3351: EAM_ERROR_MESSAGE_PVT.Log_Error
3352: ( p_eam_wo_rec => l_eam_wo_rec
3353: , p_eam_op_tbl => l_eam_op_tbl
3354: , p_eam_op_network_tbl => l_eam_op_network_tbl
3355: , p_eam_res_tbl => l_eam_res_tbl
3359: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
3360: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3361: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3362: , p_error_status => 'W'
3363: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3364: , x_eam_wo_rec => l_out_eam_wo_rec
3365: , x_eam_op_tbl => l_out_eam_op_tbl
3366: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
3367: , x_eam_res_tbl => l_out_eam_res_tbl
3399:
3400: IF l_debug_flag = 'Y'
3401: THEN
3402: l_out_mesg_token_tbl := l_mesg_token_tbl;
3403: EAM_ERROR_MESSAGE_PVT.Open_Debug_Session
3404: ( p_debug_filename => p_debug_filename
3405: , p_output_dir => p_output_dir
3406: , p_debug_file_mode => l_debug_file_mode
3407: , x_return_status => l_return_status
3418:
3419: END IF;
3420:
3421: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN
3422: EAM_ERROR_MESSAGE_PVT.write_debug('==================================================Work Order==============================================================');
3423: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Start ========= fnd_global.user_id: '||FND_GLOBAL.user_id||' fnd_global.resp_id: '||fnd_global.resp_id||' login_id: '||FND_GLOBAL.login_id);
3424: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Workorder: ' || p_eam_wo_rec.wip_entity_name||' Wip Entity Id : '||p_eam_wo_rec.wip_entity_id);
3425: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Transaction Type : '||l_eam_wo_rec.TRANSACTION_TYPE||' (1:Create / 2:Update / 3:Delete / 4:Complete / 5:UnComplete)');
3426: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : System Status Id : '||p_eam_wo_rec.STATUS_TYPE||' User Defined Status Id : '||p_eam_wo_rec.USER_DEFINED_STATUS_ID);
3419: END IF;
3420:
3421: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN
3422: EAM_ERROR_MESSAGE_PVT.write_debug('==================================================Work Order==============================================================');
3423: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Start ========= fnd_global.user_id: '||FND_GLOBAL.user_id||' fnd_global.resp_id: '||fnd_global.resp_id||' login_id: '||FND_GLOBAL.login_id);
3424: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Workorder: ' || p_eam_wo_rec.wip_entity_name||' Wip Entity Id : '||p_eam_wo_rec.wip_entity_id);
3425: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Transaction Type : '||l_eam_wo_rec.TRANSACTION_TYPE||' (1:Create / 2:Update / 3:Delete / 4:Complete / 5:UnComplete)');
3426: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : System Status Id : '||p_eam_wo_rec.STATUS_TYPE||' User Defined Status Id : '||p_eam_wo_rec.USER_DEFINED_STATUS_ID);
3427: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Scheduled Start date : '||to_char(p_eam_wo_rec.SCHEDULED_START_DATE,'DD-MON-YY HH:MI:SS'));
3420:
3421: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN
3422: EAM_ERROR_MESSAGE_PVT.write_debug('==================================================Work Order==============================================================');
3423: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Start ========= fnd_global.user_id: '||FND_GLOBAL.user_id||' fnd_global.resp_id: '||fnd_global.resp_id||' login_id: '||FND_GLOBAL.login_id);
3424: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Workorder: ' || p_eam_wo_rec.wip_entity_name||' Wip Entity Id : '||p_eam_wo_rec.wip_entity_id);
3425: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Transaction Type : '||l_eam_wo_rec.TRANSACTION_TYPE||' (1:Create / 2:Update / 3:Delete / 4:Complete / 5:UnComplete)');
3426: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : System Status Id : '||p_eam_wo_rec.STATUS_TYPE||' User Defined Status Id : '||p_eam_wo_rec.USER_DEFINED_STATUS_ID);
3427: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Scheduled Start date : '||to_char(p_eam_wo_rec.SCHEDULED_START_DATE,'DD-MON-YY HH:MI:SS'));
3428: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Scheduled Completion Date : '||to_char(p_eam_wo_rec.SCHEDULED_COMPLETION_DATE,'DD-MON-YY HH:MI:SS'));
3421: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN
3422: EAM_ERROR_MESSAGE_PVT.write_debug('==================================================Work Order==============================================================');
3423: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Start ========= fnd_global.user_id: '||FND_GLOBAL.user_id||' fnd_global.resp_id: '||fnd_global.resp_id||' login_id: '||FND_GLOBAL.login_id);
3424: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Workorder: ' || p_eam_wo_rec.wip_entity_name||' Wip Entity Id : '||p_eam_wo_rec.wip_entity_id);
3425: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Transaction Type : '||l_eam_wo_rec.TRANSACTION_TYPE||' (1:Create / 2:Update / 3:Delete / 4:Complete / 5:UnComplete)');
3426: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : System Status Id : '||p_eam_wo_rec.STATUS_TYPE||' User Defined Status Id : '||p_eam_wo_rec.USER_DEFINED_STATUS_ID);
3427: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Scheduled Start date : '||to_char(p_eam_wo_rec.SCHEDULED_START_DATE,'DD-MON-YY HH:MI:SS'));
3428: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Scheduled Completion Date : '||to_char(p_eam_wo_rec.SCHEDULED_COMPLETION_DATE,'DD-MON-YY HH:MI:SS'));
3429: EAM_ERROR_MESSAGE_PVT.write_debug('');
3422: EAM_ERROR_MESSAGE_PVT.write_debug('==================================================Work Order==============================================================');
3423: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Start ========= fnd_global.user_id: '||FND_GLOBAL.user_id||' fnd_global.resp_id: '||fnd_global.resp_id||' login_id: '||FND_GLOBAL.login_id);
3424: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Workorder: ' || p_eam_wo_rec.wip_entity_name||' Wip Entity Id : '||p_eam_wo_rec.wip_entity_id);
3425: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Transaction Type : '||l_eam_wo_rec.TRANSACTION_TYPE||' (1:Create / 2:Update / 3:Delete / 4:Complete / 5:UnComplete)');
3426: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : System Status Id : '||p_eam_wo_rec.STATUS_TYPE||' User Defined Status Id : '||p_eam_wo_rec.USER_DEFINED_STATUS_ID);
3427: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Scheduled Start date : '||to_char(p_eam_wo_rec.SCHEDULED_START_DATE,'DD-MON-YY HH:MI:SS'));
3428: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Scheduled Completion Date : '||to_char(p_eam_wo_rec.SCHEDULED_COMPLETION_DATE,'DD-MON-YY HH:MI:SS'));
3429: EAM_ERROR_MESSAGE_PVT.write_debug('');
3430: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of operations: ' || p_eam_op_tbl.COUNT);
3423: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Start ========= fnd_global.user_id: '||FND_GLOBAL.user_id||' fnd_global.resp_id: '||fnd_global.resp_id||' login_id: '||FND_GLOBAL.login_id);
3424: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Workorder: ' || p_eam_wo_rec.wip_entity_name||' Wip Entity Id : '||p_eam_wo_rec.wip_entity_id);
3425: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Transaction Type : '||l_eam_wo_rec.TRANSACTION_TYPE||' (1:Create / 2:Update / 3:Delete / 4:Complete / 5:UnComplete)');
3426: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : System Status Id : '||p_eam_wo_rec.STATUS_TYPE||' User Defined Status Id : '||p_eam_wo_rec.USER_DEFINED_STATUS_ID);
3427: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Scheduled Start date : '||to_char(p_eam_wo_rec.SCHEDULED_START_DATE,'DD-MON-YY HH:MI:SS'));
3428: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Scheduled Completion Date : '||to_char(p_eam_wo_rec.SCHEDULED_COMPLETION_DATE,'DD-MON-YY HH:MI:SS'));
3429: EAM_ERROR_MESSAGE_PVT.write_debug('');
3430: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of operations: ' || p_eam_op_tbl.COUNT);
3431: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of resources: ' || p_eam_res_tbl.COUNT);
3424: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Workorder: ' || p_eam_wo_rec.wip_entity_name||' Wip Entity Id : '||p_eam_wo_rec.wip_entity_id);
3425: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Transaction Type : '||l_eam_wo_rec.TRANSACTION_TYPE||' (1:Create / 2:Update / 3:Delete / 4:Complete / 5:UnComplete)');
3426: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : System Status Id : '||p_eam_wo_rec.STATUS_TYPE||' User Defined Status Id : '||p_eam_wo_rec.USER_DEFINED_STATUS_ID);
3427: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Scheduled Start date : '||to_char(p_eam_wo_rec.SCHEDULED_START_DATE,'DD-MON-YY HH:MI:SS'));
3428: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Scheduled Completion Date : '||to_char(p_eam_wo_rec.SCHEDULED_COMPLETION_DATE,'DD-MON-YY HH:MI:SS'));
3429: EAM_ERROR_MESSAGE_PVT.write_debug('');
3430: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of operations: ' || p_eam_op_tbl.COUNT);
3431: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of resources: ' || p_eam_res_tbl.COUNT);
3432: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of materials: ' || p_eam_mat_req_tbl.COUNT);
3425: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Transaction Type : '||l_eam_wo_rec.TRANSACTION_TYPE||' (1:Create / 2:Update / 3:Delete / 4:Complete / 5:UnComplete)');
3426: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : System Status Id : '||p_eam_wo_rec.STATUS_TYPE||' User Defined Status Id : '||p_eam_wo_rec.USER_DEFINED_STATUS_ID);
3427: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Scheduled Start date : '||to_char(p_eam_wo_rec.SCHEDULED_START_DATE,'DD-MON-YY HH:MI:SS'));
3428: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Scheduled Completion Date : '||to_char(p_eam_wo_rec.SCHEDULED_COMPLETION_DATE,'DD-MON-YY HH:MI:SS'));
3429: EAM_ERROR_MESSAGE_PVT.write_debug('');
3430: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of operations: ' || p_eam_op_tbl.COUNT);
3431: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of resources: ' || p_eam_res_tbl.COUNT);
3432: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of materials: ' || p_eam_mat_req_tbl.COUNT);
3433: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of direct items: ' || p_eam_direct_items_tbl.COUNT);
3426: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : System Status Id : '||p_eam_wo_rec.STATUS_TYPE||' User Defined Status Id : '||p_eam_wo_rec.USER_DEFINED_STATUS_ID);
3427: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Scheduled Start date : '||to_char(p_eam_wo_rec.SCHEDULED_START_DATE,'DD-MON-YY HH:MI:SS'));
3428: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Scheduled Completion Date : '||to_char(p_eam_wo_rec.SCHEDULED_COMPLETION_DATE,'DD-MON-YY HH:MI:SS'));
3429: EAM_ERROR_MESSAGE_PVT.write_debug('');
3430: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of operations: ' || p_eam_op_tbl.COUNT);
3431: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of resources: ' || p_eam_res_tbl.COUNT);
3432: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of materials: ' || p_eam_mat_req_tbl.COUNT);
3433: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of direct items: ' || p_eam_direct_items_tbl.COUNT);
3434: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of sub resources: ' || p_eam_sub_res_tbl.COUNT);
3427: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Scheduled Start date : '||to_char(p_eam_wo_rec.SCHEDULED_START_DATE,'DD-MON-YY HH:MI:SS'));
3428: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Scheduled Completion Date : '||to_char(p_eam_wo_rec.SCHEDULED_COMPLETION_DATE,'DD-MON-YY HH:MI:SS'));
3429: EAM_ERROR_MESSAGE_PVT.write_debug('');
3430: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of operations: ' || p_eam_op_tbl.COUNT);
3431: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of resources: ' || p_eam_res_tbl.COUNT);
3432: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of materials: ' || p_eam_mat_req_tbl.COUNT);
3433: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of direct items: ' || p_eam_direct_items_tbl.COUNT);
3434: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of sub resources: ' || p_eam_sub_res_tbl.COUNT);
3435: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of resource inst: ' || p_eam_res_inst_tbl.COUNT);
3428: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Scheduled Completion Date : '||to_char(p_eam_wo_rec.SCHEDULED_COMPLETION_DATE,'DD-MON-YY HH:MI:SS'));
3429: EAM_ERROR_MESSAGE_PVT.write_debug('');
3430: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of operations: ' || p_eam_op_tbl.COUNT);
3431: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of resources: ' || p_eam_res_tbl.COUNT);
3432: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of materials: ' || p_eam_mat_req_tbl.COUNT);
3433: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of direct items: ' || p_eam_direct_items_tbl.COUNT);
3434: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of sub resources: ' || p_eam_sub_res_tbl.COUNT);
3435: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of resource inst: ' || p_eam_res_inst_tbl.COUNT);
3436: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of op networks: ' || p_eam_op_network_tbl.COUNT);
3429: EAM_ERROR_MESSAGE_PVT.write_debug('');
3430: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of operations: ' || p_eam_op_tbl.COUNT);
3431: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of resources: ' || p_eam_res_tbl.COUNT);
3432: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of materials: ' || p_eam_mat_req_tbl.COUNT);
3433: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of direct items: ' || p_eam_direct_items_tbl.COUNT);
3434: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of sub resources: ' || p_eam_sub_res_tbl.COUNT);
3435: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of resource inst: ' || p_eam_res_inst_tbl.COUNT);
3436: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of op networks: ' || p_eam_op_network_tbl.COUNT);
3437:
3430: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of operations: ' || p_eam_op_tbl.COUNT);
3431: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of resources: ' || p_eam_res_tbl.COUNT);
3432: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of materials: ' || p_eam_mat_req_tbl.COUNT);
3433: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of direct items: ' || p_eam_direct_items_tbl.COUNT);
3434: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of sub resources: ' || p_eam_sub_res_tbl.COUNT);
3435: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of resource inst: ' || p_eam_res_inst_tbl.COUNT);
3436: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of op networks: ' || p_eam_op_network_tbl.COUNT);
3437:
3438: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Workorder Completion Rec WipEntityId: ' || l_eam_wo_comp_rec.wip_entity_id);
3431: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of resources: ' || p_eam_res_tbl.COUNT);
3432: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of materials: ' || p_eam_mat_req_tbl.COUNT);
3433: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of direct items: ' || p_eam_direct_items_tbl.COUNT);
3434: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of sub resources: ' || p_eam_sub_res_tbl.COUNT);
3435: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of resource inst: ' || p_eam_res_inst_tbl.COUNT);
3436: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of op networks: ' || p_eam_op_network_tbl.COUNT);
3437:
3438: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Workorder Completion Rec WipEntityId: ' || l_eam_wo_comp_rec.wip_entity_id);
3439: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of qua records: ' || p_eam_wo_quality_tbl.COUNT);
3432: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of materials: ' || p_eam_mat_req_tbl.COUNT);
3433: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of direct items: ' || p_eam_direct_items_tbl.COUNT);
3434: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of sub resources: ' || p_eam_sub_res_tbl.COUNT);
3435: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of resource inst: ' || p_eam_res_inst_tbl.COUNT);
3436: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of op networks: ' || p_eam_op_network_tbl.COUNT);
3437:
3438: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Workorder Completion Rec WipEntityId: ' || l_eam_wo_comp_rec.wip_entity_id);
3439: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of qua records: ' || p_eam_wo_quality_tbl.COUNT);
3440: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT);
3434: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of sub resources: ' || p_eam_sub_res_tbl.COUNT);
3435: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of resource inst: ' || p_eam_res_inst_tbl.COUNT);
3436: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of op networks: ' || p_eam_op_network_tbl.COUNT);
3437:
3438: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Workorder Completion Rec WipEntityId: ' || l_eam_wo_comp_rec.wip_entity_id);
3439: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of qua records: ' || p_eam_wo_quality_tbl.COUNT);
3440: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT);
3441: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT);
3442: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT);
3435: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of resource inst: ' || p_eam_res_inst_tbl.COUNT);
3436: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of op networks: ' || p_eam_op_network_tbl.COUNT);
3437:
3438: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Workorder Completion Rec WipEntityId: ' || l_eam_wo_comp_rec.wip_entity_id);
3439: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of qua records: ' || p_eam_wo_quality_tbl.COUNT);
3440: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT);
3441: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT);
3442: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT);
3443: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT);
3436: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of op networks: ' || p_eam_op_network_tbl.COUNT);
3437:
3438: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Workorder Completion Rec WipEntityId: ' || l_eam_wo_comp_rec.wip_entity_id);
3439: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of qua records: ' || p_eam_wo_quality_tbl.COUNT);
3440: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT);
3441: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT);
3442: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT);
3443: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT);
3444: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of op completion recs: ' || p_eam_op_comp_tbl.COUNT);
3437:
3438: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Workorder Completion Rec WipEntityId: ' || l_eam_wo_comp_rec.wip_entity_id);
3439: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of qua records: ' || p_eam_wo_quality_tbl.COUNT);
3440: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT);
3441: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT);
3442: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT);
3443: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT);
3444: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of op completion recs: ' || p_eam_op_comp_tbl.COUNT);
3445: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of work request recs: ' || p_eam_request_tbl.COUNT);
3438: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Workorder Completion Rec WipEntityId: ' || l_eam_wo_comp_rec.wip_entity_id);
3439: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of qua records: ' || p_eam_wo_quality_tbl.COUNT);
3440: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT);
3441: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT);
3442: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT);
3443: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT);
3444: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of op completion recs: ' || p_eam_op_comp_tbl.COUNT);
3445: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of work request recs: ' || p_eam_request_tbl.COUNT);
3446: END IF;
3439: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of qua records: ' || p_eam_wo_quality_tbl.COUNT);
3440: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT);
3441: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT);
3442: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT);
3443: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT);
3444: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of op completion recs: ' || p_eam_op_comp_tbl.COUNT);
3445: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of work request recs: ' || p_eam_request_tbl.COUNT);
3446: END IF;
3447:
3440: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT);
3441: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT);
3442: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT);
3443: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT);
3444: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of op completion recs: ' || p_eam_op_comp_tbl.COUNT);
3445: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of work request recs: ' || p_eam_request_tbl.COUNT);
3446: END IF;
3447:
3448:
3441: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT);
3442: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT);
3443: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT);
3444: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of op completion recs: ' || p_eam_op_comp_tbl.COUNT);
3445: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Num of work request recs: ' || p_eam_request_tbl.COUNT);
3446: END IF;
3447:
3448:
3449:
3449:
3450: --
3451: -- Verify if all the entity record(s) belong to the same business object
3452: --
3453: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS__WO : Calling Check_BO_Record procedure, BO record validation'); END IF;
3454:
3455: CHECK_BO_RECORD
3456: ( p_eam_wo_rec => l_eam_wo_rec
3457: , p_eam_op_tbl => l_eam_op_tbl
3477:
3478: IF l_return_status <> 'S' THEN
3479: RAISE G_EXC_SEV_QUIT_OBJECT;
3480: END IF;
3481: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS__WO : BO record validation Successful'); END IF;
3482:
3483: --
3484: -- Call the Private API for performing further business rules validation
3485: --
3489: OR (p_eam_res_tbl.COUNT >0) OR (p_eam_res_inst_tbl.COUNT >0) OR (p_eam_sub_res_tbl.COUNT >0)
3490: OR (p_eam_mat_req_tbl.COUNT >0) OR (p_eam_direct_items_tbl.COUNT >0) OR (p_eam_res_usage_tbl.COUNT>0)
3491: THEN
3492:
3493: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS__WO : Calling the EAM_PROCESS_WO_PVT.PROCESS_WO procedure'); END IF;
3494:
3495: EAM_PROCESS_WO_PVT.PROCESS_WO
3496: ( p_api_version_number => p_api_version_number
3497: , x_return_status => x_return_status
3546: l_out_eam_res_usage_tbl := l_eam_res_usage_tbl;
3547: l_out_eam_mat_req_tbl := l_eam_mat_req_tbl;
3548: l_out_eam_direct_items_tbl := l_eam_direct_items_tbl;
3549:
3550: EAM_ERROR_MESSAGE_PVT.Log_Error
3551: ( p_eam_wo_rec => l_eam_wo_rec
3552: , p_eam_op_tbl => l_eam_op_tbl
3553: , p_eam_op_network_tbl => l_eam_op_network_tbl
3554: , p_eam_res_tbl => l_eam_res_tbl
3557: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
3558: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
3559: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3560: , p_mesg_token_tbl => l_mesg_token_tbl
3561: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3562: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
3563: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3564: , p_other_message => l_other_message
3565: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3558: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
3559: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3560: , p_mesg_token_tbl => l_mesg_token_tbl
3561: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3562: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
3563: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3564: , p_other_message => l_other_message
3565: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3566: , p_other_token_tbl => l_token_tbl
3559: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3560: , p_mesg_token_tbl => l_mesg_token_tbl
3561: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3562: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
3563: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3564: , p_other_message => l_other_message
3565: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3566: , p_other_token_tbl => l_token_tbl
3567: , x_eam_wo_rec => l_out_eam_wo_rec
3561: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3562: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
3563: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3564: , p_other_message => l_other_message
3565: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3566: , p_other_token_tbl => l_token_tbl
3567: , x_eam_wo_rec => l_out_eam_wo_rec
3568: , x_eam_op_tbl => l_out_eam_op_tbl
3569: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
3601:
3602: x_return_status := l_return_status;
3603:
3604: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
3605: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : End ======= Return Status from EAM_PROCESS_WO_PVT.PROCESS_WO : ' ||l_return_status||' Wip Entity Id: '||x_eam_wo_rec.wip_entity_id) ;
3606: END IF ;
3607:
3608: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3609:
3604: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
3605: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : End ======= Return Status from EAM_PROCESS_WO_PVT.PROCESS_WO : ' ||l_return_status||' Wip Entity Id: '||x_eam_wo_rec.wip_entity_id) ;
3606: END IF ;
3607:
3608: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3609:
3610: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3611: THEN
3612: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3608: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3609:
3610: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3611: THEN
3612: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3613: IF p_eam_request_tbl.COUNT = 0 THEN
3614: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3615: END IF;
3616: END IF;
3610: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3611: THEN
3612: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3613: IF p_eam_request_tbl.COUNT = 0 THEN
3614: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3615: END IF;
3616: END IF;
3617:
3618:
3632:
3633: END IF;
3634:
3635: IF (p_eam_wo_comp_rec.transaction_type is not null) THEN
3636: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Calling EAM_PROCESS_WO_PVT.COMP_UNCOMP_WORKORDER') ; END IF ;
3637:
3638:
3639: EAM_PROCESS_WO_PVT.COMP_UNCOMP_WORKORDER
3640: (
3655: );
3656:
3657: x_return_status := l_return_status;
3658: x_msg_count := l_msg_count;
3659: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Return status from EAM_PROCESS_WO_PVT.COMP_UNCOMP_WORKORDER: '||l_return_status); END IF ;
3660:
3661:
3662: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3663: THEN
3660:
3661:
3662: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3663: THEN
3664: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3665: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3666: END IF;
3667:
3668:
3661:
3662: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3663: THEN
3664: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3665: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3666: END IF;
3667:
3668:
3669: END IF;
3668:
3669: END IF;
3670:
3671: IF p_eam_op_comp_tbl.COUNT > 0 THEN
3672: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Calling EAM_PROCESS_WO_PVT.COMP_UNCOMP_OPERATION') ; END IF ;
3673:
3674: EAM_PROCESS_WO_PVT.COMP_UNCOMP_OPERATION
3675: (
3676: p_eam_op_compl_tbl => p_eam_op_comp_tbl
3682: );
3683:
3684: x_return_status := l_return_status;
3685: x_msg_count := l_msg_count;
3686: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Return status from EAM_PROCESS_WO_PVT.COMP_UNCOMP_OPERATION: '||l_return_status); END IF ;
3687:
3688: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3689: THEN
3690: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3686: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Return status from EAM_PROCESS_WO_PVT.COMP_UNCOMP_OPERATION: '||l_return_status); END IF ;
3687:
3688: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3689: THEN
3690: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3691: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3692: END IF;
3693:
3694:
3687:
3688: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3689: THEN
3690: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3691: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3692: END IF;
3693:
3694:
3695: END IF;
3695: END IF;
3696:
3697:
3698: IF p_eam_request_tbl.COUNT > 0 THEN
3699: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Calling EAM_PROCESS_WO_PVT.SERVICE_WORKREQUEST_ASSO'); END IF ;
3700: EAM_PROCESS_WO_PVT.SERVICE_WORKREQUEST_ASSO
3701: (
3702: p_eam_request_tbl => l_eam_request_tbl
3703: , x_eam_request_tbl => x_eam_request_tbl
3707:
3708: x_return_status := l_return_status;
3709: x_msg_count := l_msg_count;
3710:
3711: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Return status from EAM_PROCESS_WO_PVT.SERVICE_WORKREQUEST_ASSO : '||l_return_status); END IF ;
3712:
3713: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3714: THEN
3715: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3711: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Return status from EAM_PROCESS_WO_PVT.SERVICE_WORKREQUEST_ASSO : '||l_return_status); END IF ;
3712:
3713: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3714: THEN
3715: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3716: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3717: END IF;
3718:
3719:
3712:
3713: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3714: THEN
3715: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3716: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3717: END IF;
3718:
3719:
3720: END IF;
3728: -- been logged. There is no need to do it again.
3729:
3730:
3731:
3732: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
3733: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3734:
3735: x_eam_wo_rec := l_eam_wo_rec;
3736: x_eam_op_tbl := l_eam_op_tbl;
3729:
3730:
3731:
3732: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
3733: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3734:
3735: x_eam_wo_rec := l_eam_wo_rec;
3736: x_eam_op_tbl := l_eam_op_tbl;
3737: x_eam_op_network_tbl := l_eam_op_network_tbl;
3752: x_eam_request_tbl := l_eam_request_tbl;
3753:
3754: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3755: THEN
3756: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3757: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3758: END IF;
3759:
3760:
3753:
3754: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3755: THEN
3756: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3757: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3758: END IF;
3759:
3760:
3761: WHEN G_EXC_UNEXP_SKIP_OBJECT THEN
3780: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
3781: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
3782: l_out_eam_request_tbl := l_eam_request_tbl;
3783:
3784: EAM_ERROR_MESSAGE_PVT.Log_Error
3785: ( p_eam_wo_rec => l_eam_wo_rec
3786: , p_eam_op_tbl => l_eam_op_tbl
3787: , p_eam_op_network_tbl => l_eam_op_network_tbl
3788: , p_eam_res_tbl => l_eam_res_tbl
3791: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
3792: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
3793: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3794: , p_mesg_token_tbl => l_mesg_token_tbl
3795: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED
3796: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3797: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_NOT_PICKED
3798: , p_other_message => l_other_message
3799: , p_other_token_tbl => l_token_tbl
3792: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
3793: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3794: , p_mesg_token_tbl => l_mesg_token_tbl
3795: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED
3796: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3797: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_NOT_PICKED
3798: , p_other_message => l_other_message
3799: , p_other_token_tbl => l_token_tbl
3800: , x_eam_wo_rec => l_out_eam_wo_rec
3793: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3794: , p_mesg_token_tbl => l_mesg_token_tbl
3795: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED
3796: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3797: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_NOT_PICKED
3798: , p_other_message => l_other_message
3799: , p_other_token_tbl => l_token_tbl
3800: , x_eam_wo_rec => l_out_eam_wo_rec
3801: , x_eam_op_tbl => l_out_eam_op_tbl
3845: x_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
3846: x_eam_op_comp_tbl := l_eam_op_comp_tbl;
3847: x_eam_request_tbl := l_eam_request_tbl;
3848:
3849: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
3850: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3851:
3852: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3853: THEN
3846: x_eam_op_comp_tbl := l_eam_op_comp_tbl;
3847: x_eam_request_tbl := l_eam_request_tbl;
3848:
3849: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
3850: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3851:
3852: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3853: THEN
3854: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3850: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3851:
3852: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3853: THEN
3854: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3855: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3856: END IF;
3857:
3858:
3851:
3852: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3853: THEN
3854: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3855: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3856: END IF;
3857:
3858:
3859: WHEN OTHERS THEN
3859: WHEN OTHERS THEN
3860:
3861: -- Call Error Handler
3862:
3863: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
3864: ( p_message_name => 'EAM_PR_WO_UNKNOWN_ERROR'
3865: , p_token_tbl => l_token_tbl
3866: , p_mesg_token_tbl => l_mesg_token_tbl
3867: , x_mesg_token_tbl => l_out_mesg_token_tbl
3888: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
3889: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
3890: l_out_eam_request_tbl := l_eam_request_tbl;
3891:
3892: EAM_ERROR_MESSAGE_PVT.Log_Error
3893: ( p_eam_wo_rec => l_eam_wo_rec
3894: , p_eam_op_tbl => l_eam_op_tbl
3895: , p_eam_op_network_tbl => l_eam_op_network_tbl
3896: , p_eam_res_tbl => l_eam_res_tbl
3899: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
3900: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
3901: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3902: , p_mesg_token_tbl => l_mesg_token_tbl
3903: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED
3904: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3905: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3906: , p_other_message => l_other_message
3907: , x_eam_wo_rec => l_out_eam_wo_rec
3900: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
3901: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3902: , p_mesg_token_tbl => l_mesg_token_tbl
3903: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED
3904: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3905: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3906: , p_other_message => l_other_message
3907: , x_eam_wo_rec => l_out_eam_wo_rec
3908: , x_eam_op_tbl => l_out_eam_op_tbl
3901: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3902: , p_mesg_token_tbl => l_mesg_token_tbl
3903: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED
3904: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3905: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3906: , p_other_message => l_other_message
3907: , x_eam_wo_rec => l_out_eam_wo_rec
3908: , x_eam_op_tbl => l_out_eam_op_tbl
3909: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
3952: x_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
3953: x_eam_op_comp_tbl := l_eam_op_comp_tbl;
3954: x_eam_request_tbl := l_eam_request_tbl;
3955:
3956: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
3957: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3958:
3959: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3960: THEN
3953: x_eam_op_comp_tbl := l_eam_op_comp_tbl;
3954: x_eam_request_tbl := l_eam_request_tbl;
3955:
3956: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
3957: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3958:
3959: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3960: THEN
3961: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3957: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3958:
3959: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3960: THEN
3961: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3962: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3963: END IF;
3964:
3965:
3958:
3959: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3960: THEN
3961: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3962: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3963: END IF;
3964:
3965:
3966: END PROCESS_WO;
4021: l_eam_wc_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4022:
4023: BEGIN
4024:
4025: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits : Start ====================='); END IF ;
4026:
4027: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits : Preparing permit header and association tables'); END IF ;
4028:
4029: -- copy old table in 12.1.3 code to 12.2 code.
4023: BEGIN
4024:
4025: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits : Start ====================='); END IF ;
4026:
4027: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits : Preparing permit header and association tables'); END IF ;
4028:
4029: -- copy old table in 12.1.3 code to 12.2 code.
4030:
4031: IF(p_eam_permit_tbl IS NOT NULL AND p_eam_permit_tbl.COUNT>0) THEN
4135: END IF;
4136:
4137: -- Delegate call to new signature
4138:
4139: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits : Calling PROCESS_WO with Permits and clearances'); END IF;
4140:
4141: PROCESS_WO
4142: ( p_bo_identifier => p_bo_identifier
4143: , p_api_version_number => p_api_version_number
4188: , p_debug_filename =>p_debug_filename
4189: , p_debug_file_mode =>p_debug_file_mode
4190: );
4191:
4192: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits : End : Status : '||x_return_status); END IF;
4193:
4194: END PROCESS_WO;
4195:
4196:
4271: i number;
4272:
4273: BEGIN
4274:
4275: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits and Clearances : Start ==========='); END IF ;
4276:
4277: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits and Clearances : Calling plain PROCESS_WO'); END IF ;
4278:
4279: PROCESS_WO
4273: BEGIN
4274:
4275: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits and Clearances : Start ==========='); END IF ;
4276:
4277: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits and Clearances : Calling plain PROCESS_WO'); END IF ;
4278:
4279: PROCESS_WO
4280: ( p_bo_identifier => p_bo_identifier
4281: , p_api_version_number => p_api_version_number
4323: , p_debug_file_mode => p_debug_file_mode
4324: );
4325:
4326: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
4327: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits and Clearances : Return status from plain PROCESS_WO: '||l_return_status);
4328: END IF ;
4329:
4330: x_return_status := l_return_status ;
4331: IF x_return_status = 'E' THEN
4346: l_wip_entity_id :=p_eam_permit_wo_assoc_tbl(1).TARGET_REF_ID;
4347: END IF;
4348:
4349: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
4350: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Permits and Clearances : Preparing Permit header ('||p_eam_permit_tbl.COUNT||') and association ('||p_eam_permit_wo_assoc_tbl.COUNT||') tables');
4351: END IF ;
4352:
4353: -- Process new permit records(create WO)
4354:
4458:
4459: */
4460:
4461: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
4462: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Permits and Clearances :Calling EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_PERMIT Permit name: '||l_work_permit_header_rec.permit_name);
4463: END IF ;
4464:
4465: EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_PERMIT(
4466: p_bo_identifier => p_bo_identifier
4547:
4548: l_eam_work_clearance_rec := p_eam_work_clearance_tbl(i);
4549:
4550: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
4551: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Permits and Clearances :Calling EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_CLEARANCE Clearance name: '||l_eam_work_clearance_rec.WORK_CLEARANCE_NAME);
4552: END IF ;
4553: EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_CLEARANCE(
4554: p_init_msg_list => TRUE
4555: , p_work_clearance_header_rec => l_eam_work_clearance_rec
4603: END IF; -- if(l_return_staus='S'.....)
4604:
4605: x_return_status :='S'; -- Return success if the program is through other procedure calls.
4606:
4607: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Permits and Clearances :End :Status: '||x_return_status); END IF ;
4608:
4609: END PROCESS_WO;
4610:
4611:
4719: -- baroy
4720: l_wip_entity_id NUMBER := NULL;
4721: l_organization_id NUMBER := NULL;
4722: l_other_message VARCHAR2(50) := NULL;
4723: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
4724: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
4725:
4726: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
4727: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
4720: l_wip_entity_id NUMBER := NULL;
4721: l_organization_id NUMBER := NULL;
4722: l_other_message VARCHAR2(50) := NULL;
4723: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
4724: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
4725:
4726: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
4727: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
4728: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
4965: l_out_eam_mat_req_tbl := l_eam_mat_req_tbl;
4966: l_out_eam_direct_items_tbl := l_eam_direct_items_tbl;
4967:
4968: -- Log the error
4969: EAM_ERROR_MESSAGE_PVT.Log_Error
4970: ( p_eam_wo_rec => l_eam_wo_rec
4971: , p_eam_op_tbl => l_eam_op_tbl
4972: , p_eam_op_network_tbl => l_eam_op_network_tbl
4973: , p_eam_res_tbl => l_eam_res_tbl
4976: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
4977: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
4978: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
4979: , p_mesg_token_tbl => l_mesg_token_tbl
4980: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4981: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
4982: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
4983: , p_other_message => l_other_message
4984: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4977: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
4978: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
4979: , p_mesg_token_tbl => l_mesg_token_tbl
4980: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4981: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
4982: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
4983: , p_other_message => l_other_message
4984: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4985: , p_other_token_tbl => l_token_tbl
4978: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
4979: , p_mesg_token_tbl => l_mesg_token_tbl
4980: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4981: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
4982: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
4983: , p_other_message => l_other_message
4984: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4985: , p_other_token_tbl => l_token_tbl
4986: , x_eam_wo_rec => l_out_eam_wo_rec
4980: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4981: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
4982: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
4983: , p_other_message => l_other_message
4984: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4985: , p_other_token_tbl => l_token_tbl
4986: , x_eam_wo_rec => l_out_eam_wo_rec
4987: , x_eam_op_tbl => l_out_eam_op_tbl
4988: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
5014: l_organization_id := p_eam_wo_rec.organization_id;
5015: END IF;
5016: -- end - baroy
5017:
5018: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating OP record'); END IF;
5019:
5020: FOR I IN 1..p_eam_op_tbl.COUNT LOOP
5021: IF p_eam_op_tbl(I).wip_entity_id is not null AND (
5022: p_eam_op_tbl(I).wip_entity_id <> l_wip_entity_id OR
5026: l_other_message := 'EAM_WO_BO_REC_INVALID';
5027: END IF;
5028: END LOOP;
5029:
5030: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating OPN record'); END IF;
5031:
5032: FOR I IN 1..p_eam_op_network_tbl.COUNT LOOP
5033: IF p_eam_op_network_tbl(I).wip_entity_id is not null AND (
5034: p_eam_op_network_tbl(I).wip_entity_id <> l_wip_entity_id OR
5038: l_other_message := 'EAM_WO_BO_REC_INVALID';
5039: END IF;
5040: END LOOP;
5041:
5042: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating RES record'); END IF;
5043:
5044: FOR I IN 1..p_eam_res_tbl.COUNT LOOP
5045:
5046: IF p_eam_res_tbl(I).wip_entity_id is not null AND (
5051: l_other_message := 'EAM_WO_BO_REC_INVALID';
5052: END IF;
5053: END LOOP;
5054:
5055: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating RES_INST record'); END IF;
5056:
5057: FOR I IN 1..p_eam_res_inst_tbl.COUNT LOOP
5058: IF p_eam_res_inst_tbl(I).wip_entity_id is not null AND (
5059: p_eam_res_inst_tbl(I).wip_entity_id <> l_wip_entity_id OR
5063: l_other_message := 'EAM_WO_BO_REC_INVALID';
5064: END IF;
5065: END LOOP;
5066:
5067: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating SUB_RES record'); END IF;
5068:
5069: FOR I IN 1..p_eam_sub_res_tbl.COUNT LOOP
5070: IF p_eam_sub_res_tbl(I).wip_entity_id is not null AND (
5071: p_eam_sub_res_tbl(I).wip_entity_id <> l_wip_entity_id OR
5075: l_other_message := 'EAM_WO_BO_REC_INVALID';
5076: END IF;
5077: END LOOP;
5078:
5079: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating RES_USAGE record'); END IF;
5080:
5081: FOR I IN 1..p_eam_res_usage_tbl.COUNT LOOP
5082: IF p_eam_res_usage_tbl(I).wip_entity_id is not null AND (
5083: p_eam_res_usage_tbl(I).wip_entity_id <> l_wip_entity_id OR
5087: l_other_message := 'EAM_WO_BO_REC_INVALID';
5088: END IF;
5089: END LOOP;
5090:
5091: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating MAT_REQ record'); END IF;
5092:
5093: FOR I IN 1..p_eam_mat_req_tbl.COUNT LOOP
5094: IF p_eam_mat_req_tbl(I).wip_entity_id is not null AND (
5095: p_eam_mat_req_tbl(I).wip_entity_id <> l_wip_entity_id OR
5099: l_other_message := 'EAM_WO_BO_REC_INVALID';
5100: END IF;
5101: END LOOP;
5102:
5103: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating DI record'); END IF;
5104:
5105: FOR I IN 1..p_eam_direct_items_tbl.COUNT LOOP
5106: IF p_eam_direct_items_tbl(I).wip_entity_id is not null AND (
5107: p_eam_direct_items_tbl(I).wip_entity_id <> l_wip_entity_id OR
5124: l_out_eam_res_usage_tbl := l_eam_res_usage_tbl;
5125: l_out_eam_mat_req_tbl := l_eam_mat_req_tbl;
5126: l_out_eam_direct_items_tbl := l_eam_direct_items_tbl;
5127:
5128: EAM_ERROR_MESSAGE_PVT.Log_Error
5129: ( p_eam_wo_rec => l_eam_wo_rec
5130: , p_eam_op_tbl => l_eam_op_tbl
5131: , p_eam_op_network_tbl => l_eam_op_network_tbl
5132: , p_eam_res_tbl => l_eam_res_tbl
5135: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
5136: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
5137: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
5138: , p_mesg_token_tbl => l_mesg_token_tbl
5139: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
5140: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
5141: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
5142: , p_other_message => l_other_message
5143: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
5136: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
5137: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
5138: , p_mesg_token_tbl => l_mesg_token_tbl
5139: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
5140: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
5141: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
5142: , p_other_message => l_other_message
5143: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
5144: , p_other_token_tbl => l_token_tbl
5137: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
5138: , p_mesg_token_tbl => l_mesg_token_tbl
5139: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
5140: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
5141: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
5142: , p_other_message => l_other_message
5143: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
5144: , p_other_token_tbl => l_token_tbl
5145: , x_eam_wo_rec => l_out_eam_wo_rec
5139: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
5140: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
5141: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
5142: , p_other_message => l_other_message
5143: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
5144: , p_other_token_tbl => l_token_tbl
5145: , x_eam_wo_rec => l_out_eam_wo_rec
5146: , x_eam_op_tbl => l_out_eam_op_tbl
5147: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
5182: l_eam_wo_comp_rebuild_tbl := p_eam_wo_comp_rebuild_tbl;
5183: l_eam_wo_comp_mr_read_tbl := p_eam_wo_comp_mr_read_tbl;
5184:
5185:
5186: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating Quality record'); END IF;
5187:
5188: FOR I IN 1..l_eam_wo_quality_tbl.COUNT LOOP
5189: IF p_eam_wo_quality_tbl(I).wip_entity_id is not null AND (
5190: p_eam_wo_quality_tbl(I).wip_entity_id <> l_wip_entity_id OR
5194: l_other_message := 'EAM_WO_BO_REC_INVALID';
5195: END IF;
5196: END LOOP;
5197:
5198: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating Meter record'); END IF;
5199:
5200: FOR I IN 1..l_eam_meter_reading_tbl.COUNT LOOP
5201: IF p_eam_meter_reading_tbl(I).wip_entity_id is not null AND (
5202: p_eam_meter_reading_tbl(I).wip_entity_id <> l_wip_entity_id
5206: l_other_message := 'EAM_WO_BO_REC_INVALID';
5207: END IF;
5208: END LOOP;
5209:
5210: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating Counter Properties record'); END IF;
5211:
5212: FOR I IN 1..l_eam_counter_prop_tbl.COUNT LOOP
5213: IF p_eam_counter_prop_tbl(I).wip_entity_id is not null AND (
5214: p_eam_counter_prop_tbl(I).wip_entity_id <> l_wip_entity_id
5219: END IF;
5220: END LOOP;
5221:
5222:
5223: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating Meter Completion record'); END IF;
5224:
5225: FOR I IN 1..l_eam_wo_comp_rebuild_tbl.COUNT LOOP
5226: IF p_eam_wo_comp_rebuild_tbl(I).wip_entity_id is not null AND (
5227: p_eam_wo_comp_rebuild_tbl(I).wip_entity_id <> l_wip_entity_id OR
5231: l_other_message := 'EAM_WO_BO_REC_INVALID';
5232: END IF;
5233: END LOOP;
5234:
5235: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating Rebuild Completion record'); END IF;
5236:
5237: FOR I IN 1..l_eam_wo_comp_mr_read_tbl.COUNT LOOP
5238: IF p_eam_wo_comp_mr_read_tbl(I).wip_entity_id is not null AND (
5239: p_eam_wo_comp_mr_read_tbl(I).wip_entity_id <> l_wip_entity_id OR
5256: l_out_eam_res_usage_tbl := l_eam_res_usage_tbl;
5257: l_out_eam_mat_req_tbl := l_eam_mat_req_tbl;
5258: l_out_eam_direct_items_tbl := l_eam_direct_items_tbl;
5259:
5260: EAM_ERROR_MESSAGE_PVT.Log_Error
5261: ( p_eam_wo_rec => l_eam_wo_rec
5262: , p_eam_op_tbl => l_eam_op_tbl
5263: , p_eam_op_network_tbl => l_eam_op_network_tbl
5264: , p_eam_res_tbl => l_eam_res_tbl
5267: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
5268: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
5269: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
5270: , p_mesg_token_tbl => l_mesg_token_tbl
5271: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
5272: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
5273: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
5274: , p_other_message => l_other_message
5275: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
5268: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
5269: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
5270: , p_mesg_token_tbl => l_mesg_token_tbl
5271: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
5272: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
5273: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
5274: , p_other_message => l_other_message
5275: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
5276: , p_other_token_tbl => l_token_tbl
5269: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
5270: , p_mesg_token_tbl => l_mesg_token_tbl
5271: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
5272: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
5273: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
5274: , p_other_message => l_other_message
5275: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
5276: , p_other_token_tbl => l_token_tbl
5277: , x_eam_wo_rec => l_out_eam_wo_rec
5271: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
5272: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
5273: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
5274: , p_other_message => l_other_message
5275: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
5276: , p_other_token_tbl => l_token_tbl
5277: , x_eam_wo_rec => l_out_eam_wo_rec
5278: , x_eam_op_tbl => l_out_eam_op_tbl
5279: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
5301:
5302:
5303: x_return_status := 'S';
5304:
5305: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : End === Status : '||x_return_status||' ==================='); END IF;
5306:
5307: RETURN;
5308:
5309: END CHECK_BO_RECORD;