[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
585: x_eam_wo_comp_mr_read_tbl := p_eam_wo_comp_mr_read_tbl;
586: x_eam_op_comp_tbl := p_eam_op_comp_tbl;
587:
588:
589: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling CHECK_BO_NETWORK ...') ; END IF ;
590:
591:
592: CHECK_BO_NETWORK
593: ( p_eam_wo_tbl => l_eam_wo_tbl
670: l_out_eam_op_comp_tbl.delete;
671: l_out_eam_request_tbl.delete;
672:
673:
674: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('CHECK_BO_NETWORK completed with status ='||l_return_status) ; END IF ;
675:
676: if nvl(l_return_status,FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS then
677:
678: l_out_mesg_token_tbl := l_mesg_token_tbl;
675:
676: if nvl(l_return_status,FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS then
677:
678: l_out_mesg_token_tbl := l_mesg_token_tbl;
679: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
680: ( p_message_name => 'EAM_WN_BO_NET_ERR'
681: , p_token_tbl => l_token_tbl
682: , p_mesg_token_tbl => l_mesg_token_tbl
683: , x_mesg_token_tbl => l_out_mesg_token_tbl
702: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
703: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
704: l_out_eam_request_tbl := l_eam_request_tbl;
705:
706: EAM_ERROR_MESSAGE_PVT.Log_Error
707: ( p_eam_wo_rec => l_eam_wo_rec
708: , p_eam_op_tbl => l_eam_op_tbl
709: , p_eam_op_network_tbl => l_eam_op_network_tbl
710: , p_eam_res_tbl => l_eam_res_tbl
714: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
715: , p_eam_direct_items_tbl => l_eam_di_tbl
716: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
717: , p_error_status => 'W'
718: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
719: , x_eam_wo_rec => l_out_eam_wo_rec
720: , x_eam_op_tbl => l_out_eam_op_tbl
721: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
722: , x_eam_res_tbl => l_out_eam_res_tbl
747: l_eam_request_tbl := l_out_eam_request_tbl;
748:
749: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
750: THEN
751: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
752: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
753: END IF;
754:
755:
748:
749: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
750: THEN
751: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
752: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
753: END IF;
754:
755:
756: l_eam_return_status := FND_API.G_RET_STS_ERROR;
754:
755:
756: l_eam_return_status := FND_API.G_RET_STS_ERROR;
757: x_return_status := FND_API.G_RET_STS_ERROR;
758: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
759: return;
760: end if;
761:
762:
761:
762:
763: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
764: THEN
765: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
766: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
767: END IF;
768:
769:
762:
763: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
764: THEN
765: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
766: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
767: END IF;
768:
769:
770:
958: l_token_tbl(1).token_name := 'Header Id';
959: l_token_tbl(1).token_value := l_eam_wo_rec_head.header_id;
960:
961: l_out_mesg_token_tbl := l_mesg_token_tbl;
962: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
963: ( p_message_name => 'EAM_WN_GEN_WARNING'
964: , p_token_tbl => l_token_tbl
965: , p_mesg_token_tbl => l_mesg_token_tbl
966: , x_mesg_token_tbl => l_out_mesg_token_tbl
967: );
968: l_mesg_token_tbl := l_out_mesg_token_tbl;
969:
970:
971: EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
972: ( p_mesg_token_tbl => l_mesg_token_tbl
973: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
974: , p_entity_index => l_eam_wo_rec_head.row_id
975: , p_application_id => 'EAM'
969:
970:
971: EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
972: ( p_mesg_token_tbl => l_mesg_token_tbl
973: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
974: , p_entity_index => l_eam_wo_rec_head.row_id
975: , p_application_id => 'EAM'
976: );
977:
1029: and l_return_status = 'S' then
1030: l_eam_wo_list(l_eam_wo_list.count + 1) := l_out_eam_wo_rec.wip_entity_name;
1031: end if;
1032:
1033: -- 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 ;
1034:
1035: if l_out_eam_wo_rec.transaction_type is not null then
1036: l_eam_wo_tbl(l_out_eam_wo_rec.row_id) := l_out_eam_wo_rec;
1037: end if;
1204:
1205: -- Delete the general warning message from both the fnd and eam message stacks
1206: fnd_msg_pub.delete_msg(p_msg_index => fnd_msg_pub.Count_Msg);
1207:
1208: EAM_ERROR_MESSAGE_PVT.Delete_Message;
1209:
1210: x_msg_count := EAM_ERROR_MESSAGE_PVT.GET_MESSAGE_COUNT();
1211:
1212:
1206: fnd_msg_pub.delete_msg(p_msg_index => fnd_msg_pub.Count_Msg);
1207:
1208: EAM_ERROR_MESSAGE_PVT.Delete_Message;
1209:
1210: x_msg_count := EAM_ERROR_MESSAGE_PVT.GET_MESSAGE_COUNT();
1211:
1212:
1213:
1214: -- Populate the wip_entity_id for newly created work orders
1256:
1257: -- If debug is Y then out dir must be specified
1258:
1259: l_out_mesg_token_tbl := l_mesg_token_tbl;
1260: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1261: ( 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'
1262: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1263: , x_Mesg_Token_Tbl => l_out_mesg_token_tbl
1264: , p_Token_Tbl => l_token_tbl
1274: l_out_eam_res_usage_tbl := l_eam_res_usage_tbl;
1275: l_out_eam_mat_req_tbl := l_eam_mat_req_tbl;
1276: l_out_eam_di_tbl := l_eam_di_tbl;
1277:
1278: EAM_ERROR_MESSAGE_PVT.Log_Error
1279: ( p_eam_wo_rec => l_eam_wo_rec
1280: , p_eam_op_tbl => l_eam_op_tbl
1281: , p_eam_op_network_tbl => l_eam_op_network_tbl
1282: , p_eam_res_tbl => l_eam_res_tbl
1286: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
1287: , p_eam_direct_items_tbl => l_eam_di_tbl
1288: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1289: , p_error_status => 'W'
1290: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
1291: , x_eam_wo_rec => l_out_eam_wo_rec
1292: , x_eam_op_tbl => l_out_eam_op_tbl
1293: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
1294: , x_eam_res_tbl => l_out_eam_res_tbl
1325: IF trim(p_debug_filename) IS NULL OR trim(p_debug_filename) = ''
1326: THEN
1327:
1328: l_out_mesg_token_tbl := l_mesg_token_tbl;
1329: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1330: ( 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'
1331: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1332: , x_Mesg_Token_Tbl => l_out_mesg_token_tbl
1333: , p_Token_Tbl => l_token_tbl
1352: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
1353: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
1354: l_out_eam_request_tbl := l_eam_request_tbl;
1355:
1356: EAM_ERROR_MESSAGE_PVT.Log_Error
1357: ( p_eam_wo_rec => l_eam_wo_rec
1358: , p_eam_op_tbl => l_eam_op_tbl
1359: , p_eam_op_network_tbl => l_eam_op_network_tbl
1360: , p_eam_res_tbl => l_eam_res_tbl
1364: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
1365: , p_eam_direct_items_tbl => l_eam_di_tbl
1366: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1367: , p_error_status => 'W'
1368: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
1369: , x_eam_wo_rec => l_out_eam_wo_rec
1370: , x_eam_op_tbl => l_out_eam_op_tbl
1371: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
1372: , x_eam_res_tbl => l_out_eam_res_tbl
1404:
1405: IF l_debug_flag = 'Y'
1406: THEN
1407: l_out_mesg_token_tbl := l_mesg_token_tbl;
1408: EAM_ERROR_MESSAGE_PVT.Open_Debug_Session
1409: ( p_debug_filename => p_debug_filename
1410: , p_output_dir => p_output_dir
1411: , p_debug_file_mode => 'a'
1412: , x_return_status => l_return_status
1445:
1446:
1447: l_temp_wip_entity_id := l_eam_wo_relations_tbl(i).PARENT_OBJECT_ID;
1448:
1449: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering the Check_Wo_Dates procedure ... ') ; END IF ;
1450:
1451: FOR l_temp_index in 1..2 LOOP
1452:
1453: if (l_eam_wo_relations_tbl(i).parent_relationship_type = 1) then
1464: x_msg_count => l_msg_count,
1465: x_msg_data => l_msg_data
1466: );
1467:
1468: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 1 ) THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check_Wo_Dates for parent wo completed with status of '||l_return_status) ; END IF ;
1469: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 2 ) THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check_Wo_Dates for child wo completed with status of '||l_return_status) ; END IF ;
1470: IF l_return_status = FND_API.G_RET_STS_ERROR OR
1471: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1472:
1465: x_msg_data => l_msg_data
1466: );
1467:
1468: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 1 ) THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check_Wo_Dates for parent wo completed with status of '||l_return_status) ; END IF ;
1469: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 2 ) THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check_Wo_Dates for child wo completed with status of '||l_return_status) ; END IF ;
1470: IF l_return_status = FND_API.G_RET_STS_ERROR OR
1471: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1472:
1473: --Before inserting the error message, insert the confirmation message of work order creation.
1471: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1472:
1473: --Before inserting the error message, insert the confirmation message of work order creation.
1474: x_return_status := l_return_status;
1475: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
1476: l_eam_return_status := FND_API.G_RET_STS_ERROR;
1477:
1478: if l_eam_wo_list.count > 0 then
1479: for l_new_wo_list in l_eam_wo_list.first..l_eam_wo_list.last loop
1491: eam_execution_jsp.add_message(p_app_short_name => 'EAM',
1492: p_msg_name => 'EAM_WO_CHK_DATES_ERR',
1493: p_token1 => 'WORKORDER', p_value1 => l_wo_name);
1494:
1495: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
1496: l_eam_return_status := FND_API.G_RET_STS_ERROR;
1497: end if;
1498: end if;
1499: l_temp_wip_entity_id := l_eam_wo_relations_tbl(i).CHILD_OBJECT_ID;
1503: if l_eam_wo_relations_tbl(i).parent_relationship_type in (1,3,4) then
1504:
1505: SAVEPOINT Add_WO_To_Network_Start;
1506:
1507: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering the Add_WO_To_Network procedure ... ') ; END IF ;
1508:
1509: EAM_WO_NETWORK_DEFAULT_PVT.Add_WO_To_Network(
1510: p_api_version => 1.0,
1511: p_init_msg_list => FND_API.G_FALSE,
1552: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
1553: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
1554: l_out_eam_request_tbl := l_eam_request_tbl;
1555:
1556: EAM_ERROR_MESSAGE_PVT.Log_Error
1557: ( p_eam_wo_rec => l_eam_wo_rec
1558: , p_eam_op_tbl => l_eam_op_tbl
1559: , p_eam_op_network_tbl => l_eam_op_network_tbl
1560: , p_eam_res_tbl => l_eam_res_tbl
1564: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
1565: , p_eam_direct_items_tbl => l_eam_di_tbl
1566: , p_mesg_token_tbl => l_mesg_token_tbl
1567: , p_error_status => FND_API.G_RET_STS_ERROR
1568: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1569: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1570: , p_other_message => l_other_message
1571: , p_other_token_tbl => l_other_token_tbl
1572: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1565: , p_eam_direct_items_tbl => l_eam_di_tbl
1566: , p_mesg_token_tbl => l_mesg_token_tbl
1567: , p_error_status => FND_API.G_RET_STS_ERROR
1568: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1569: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1570: , p_other_message => l_other_message
1571: , p_other_token_tbl => l_other_token_tbl
1572: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1573: , x_eam_wo_rec => l_out_eam_wo_rec
1568: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1569: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1570: , p_other_message => l_other_message
1571: , p_other_token_tbl => l_other_token_tbl
1572: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1573: , x_eam_wo_rec => l_out_eam_wo_rec
1574: , x_eam_op_tbl => l_out_eam_op_tbl
1575: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
1576: , x_eam_res_tbl => l_out_eam_res_tbl
1606:
1607: elsif l_eam_wo_relations_tbl(i).parent_relationship_type = 2 then
1608:
1609: SAVEPOINT Add_Dependency_Start;
1610: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering the Add_Dependency procedure ... ') ; END IF ;
1611:
1612: EAM_WO_NETWORK_DEFAULT_PVT.Add_Dependency
1613: (
1614: p_api_version => 1.0,
1655: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
1656: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
1657: l_out_eam_request_tbl := l_eam_request_tbl;
1658:
1659: EAM_ERROR_MESSAGE_PVT.Log_Error
1660: ( p_eam_wo_rec => l_eam_wo_rec
1661: , p_eam_op_tbl => l_eam_op_tbl
1662: , p_eam_op_network_tbl => l_eam_op_network_tbl
1663: , p_eam_res_tbl => l_eam_res_tbl
1667: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
1668: , p_eam_direct_items_tbl => l_eam_di_tbl
1669: , p_mesg_token_tbl => l_mesg_token_tbl
1670: , p_error_status => FND_API.G_RET_STS_ERROR
1671: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1672: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1673: , p_other_message => l_other_message
1674: , p_other_token_tbl => l_other_token_tbl
1675: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1668: , p_eam_direct_items_tbl => l_eam_di_tbl
1669: , p_mesg_token_tbl => l_mesg_token_tbl
1670: , p_error_status => FND_API.G_RET_STS_ERROR
1671: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1672: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1673: , p_other_message => l_other_message
1674: , p_other_token_tbl => l_other_token_tbl
1675: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1676: , x_eam_wo_rec => l_out_eam_wo_rec
1671: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1672: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1673: , p_other_message => l_other_message
1674: , p_other_token_tbl => l_other_token_tbl
1675: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1676: , x_eam_wo_rec => l_out_eam_wo_rec
1677: , x_eam_op_tbl => l_out_eam_op_tbl
1678: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
1679: , x_eam_res_tbl => l_out_eam_res_tbl
1713: if l_eam_wo_relations_tbl(i).parent_relationship_type in (1,3,4) then
1714:
1715: SAVEPOINT Delink_Relation_Start;
1716:
1717: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering the Delink_Child_From_parent procedure ... ') ; END IF ;
1718:
1719: EAM_WO_NETWORK_DEFAULT_PVT.Delink_Child_From_Parent
1720: (
1721: p_api_version => 1.0,
1765: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
1766: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
1767: l_out_eam_request_tbl := l_eam_request_tbl;
1768:
1769: EAM_ERROR_MESSAGE_PVT.Log_Error
1770: ( p_eam_wo_rec => l_eam_wo_rec
1771: , p_eam_op_tbl => l_eam_op_tbl
1772: , p_eam_op_network_tbl => l_eam_op_network_tbl
1773: , p_eam_res_tbl => l_eam_res_tbl
1777: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
1778: , p_eam_direct_items_tbl => l_eam_di_tbl
1779: , p_mesg_token_tbl => l_mesg_token_tbl
1780: , p_error_status => FND_API.G_RET_STS_ERROR
1781: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1782: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1783: , p_other_message => l_other_message
1784: , p_other_token_tbl => l_other_token_tbl
1785: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1778: , p_eam_direct_items_tbl => l_eam_di_tbl
1779: , p_mesg_token_tbl => l_mesg_token_tbl
1780: , p_error_status => FND_API.G_RET_STS_ERROR
1781: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1782: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1783: , p_other_message => l_other_message
1784: , p_other_token_tbl => l_other_token_tbl
1785: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1786: , x_eam_wo_rec => l_out_eam_wo_rec
1781: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1782: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1783: , p_other_message => l_other_message
1784: , p_other_token_tbl => l_other_token_tbl
1785: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1786: , x_eam_wo_rec => l_out_eam_wo_rec
1787: , x_eam_op_tbl => l_out_eam_op_tbl
1788: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
1789: , x_eam_res_tbl => l_out_eam_res_tbl
1818:
1819: elsif l_eam_wo_relations_tbl(i).parent_relationship_type = 2 then
1820:
1821: SAVEPOINT Delete_Dependency_Start;
1822: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering the Delete_Dependency procedure ... ') ; END IF ;
1823:
1824: EAM_WO_NETWORK_DEFAULT_PVT.Delete_Dependency
1825: (
1826: p_api_version => 1.0,
1870: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
1871: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
1872: l_out_eam_request_tbl := l_eam_request_tbl;
1873:
1874: EAM_ERROR_MESSAGE_PVT.Log_Error
1875: ( p_eam_wo_rec => l_eam_wo_rec
1876: , p_eam_op_tbl => l_eam_op_tbl
1877: , p_eam_op_network_tbl => l_eam_op_network_tbl
1878: , p_eam_res_tbl => l_eam_res_tbl
1882: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
1883: , p_eam_direct_items_tbl => l_eam_di_tbl
1884: , p_mesg_token_tbl => l_mesg_token_tbl
1885: , p_error_status => FND_API.G_RET_STS_ERROR
1886: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1887: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1888: , p_other_message => l_other_message
1889: , p_other_token_tbl => l_other_token_tbl
1890: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1883: , p_eam_direct_items_tbl => l_eam_di_tbl
1884: , p_mesg_token_tbl => l_mesg_token_tbl
1885: , p_error_status => FND_API.G_RET_STS_ERROR
1886: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1887: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1888: , p_other_message => l_other_message
1889: , p_other_token_tbl => l_other_token_tbl
1890: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1891: , x_eam_wo_rec => l_out_eam_wo_rec
1886: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
1887: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
1888: , p_other_message => l_other_message
1889: , p_other_token_tbl => l_other_token_tbl
1890: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
1891: , x_eam_wo_rec => l_out_eam_wo_rec
1892: , x_eam_op_tbl => l_out_eam_op_tbl
1893: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
1894: , x_eam_res_tbl => l_out_eam_res_tbl
1935: -- Call Validate Structure. If it returns error, then rollback everything
1936:
1937: 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
1938:
1939: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering the Validate_Structure procedure ... ') ; END IF ;
1940:
1941: EAM_WO_NETWORK_VALIDATE_PVT.Validate_Structure
1942: (
1943: p_api_version => 1.0,
1964:
1965: x_return_status := l_return_status; -- added for bug# 3544860
1966:
1967: l_out_mesg_token_tbl := l_mesg_token_tbl;
1968: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1969: ( p_message_name => 'EAM_WN_MAIN_VALIDATE_STRUCT'
1970: , p_token_tbl => l_token_tbl
1971: , p_mesg_token_tbl => l_mesg_token_tbl
1972: , x_mesg_token_tbl => l_out_mesg_token_tbl
1992: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
1993: l_out_eam_request_tbl := l_eam_request_tbl;
1994:
1995:
1996: EAM_ERROR_MESSAGE_PVT.Log_Error
1997: ( p_eam_wo_rec => l_eam_wo_rec
1998: , p_eam_op_tbl => l_eam_op_tbl
1999: , p_eam_op_network_tbl => l_eam_op_network_tbl
2000: , p_eam_res_tbl => l_eam_res_tbl
2004: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
2005: , p_eam_direct_items_tbl => l_eam_di_tbl
2006: , p_mesg_token_tbl => l_mesg_token_tbl
2007: , p_error_status => FND_API.G_RET_STS_ERROR
2008: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
2009: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
2010: , p_other_message => l_other_message
2011: , p_other_token_tbl => l_other_token_tbl
2012: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
2005: , p_eam_direct_items_tbl => l_eam_di_tbl
2006: , p_mesg_token_tbl => l_mesg_token_tbl
2007: , p_error_status => FND_API.G_RET_STS_ERROR
2008: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
2009: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
2010: , p_other_message => l_other_message
2011: , p_other_token_tbl => l_other_token_tbl
2012: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
2013: , x_eam_wo_rec => l_out_eam_wo_rec
2008: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
2009: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
2010: , p_other_message => l_other_message
2011: , p_other_token_tbl => l_other_token_tbl
2012: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
2013: , x_eam_wo_rec => l_out_eam_wo_rec
2014: , x_eam_op_tbl => l_out_eam_op_tbl
2015: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
2016: , x_eam_res_tbl => l_out_eam_res_tbl
2091: if nvl(l_eam_return_status,FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS then
2092: x_return_status := FND_API.G_RET_STS_ERROR;
2093: end if;
2094:
2095: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
2096:
2097: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
2098: THEN
2099: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
2095: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
2096:
2097: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
2098: THEN
2099: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
2100: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
2101: END IF;
2102:
2103: -- Standard check of p_commit.
2096:
2097: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
2098: THEN
2099: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
2100: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
2101: END IF;
2102:
2103: -- Standard check of p_commit.
2104: IF p_commit = 'Y' THEN
2108: EXCEPTION
2109:
2110: WHEN OTHERS THEN
2111:
2112: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
2113:
2114: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
2115: ( p_message_name => 'EAM_WN_UNKNOWN_ERROR'
2116: , p_token_tbl => l_token_tbl
2110: WHEN OTHERS THEN
2111:
2112: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
2113:
2114: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
2115: ( p_message_name => 'EAM_WN_UNKNOWN_ERROR'
2116: , p_token_tbl => l_token_tbl
2117: , p_mesg_token_tbl => l_mesg_token_tbl
2118: , x_mesg_token_tbl => l_out_mesg_token_tbl
2138: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
2139: l_out_eam_request_tbl := l_eam_request_tbl;
2140:
2141:
2142: EAM_ERROR_MESSAGE_PVT.Log_Error
2143: ( p_eam_wo_rec => l_eam_wo_rec
2144: , p_eam_op_tbl => l_eam_op_tbl
2145: , p_eam_op_network_tbl => l_eam_op_network_tbl
2146: , p_eam_res_tbl => l_eam_res_tbl
2150: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
2151: , p_eam_direct_items_tbl => l_eam_di_tbl
2152: , p_mesg_token_tbl => l_mesg_token_tbl
2153: , p_error_status => FND_API.G_RET_STS_ERROR
2154: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
2155: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
2156: , p_other_message => l_other_message
2157: , p_other_token_tbl => l_other_token_tbl
2158: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
2151: , p_eam_direct_items_tbl => l_eam_di_tbl
2152: , p_mesg_token_tbl => l_mesg_token_tbl
2153: , p_error_status => FND_API.G_RET_STS_ERROR
2154: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
2155: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
2156: , p_other_message => l_other_message
2157: , p_other_token_tbl => l_other_token_tbl
2158: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
2159: , x_eam_wo_rec => l_out_eam_wo_rec
2154: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
2155: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
2156: , p_other_message => l_other_message
2157: , p_other_token_tbl => l_other_token_tbl
2158: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
2159: , x_eam_wo_rec => l_out_eam_wo_rec
2160: , x_eam_op_tbl => l_out_eam_op_tbl
2161: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
2162: , x_eam_res_tbl => l_out_eam_res_tbl
2187: l_eam_request_tbl := l_out_eam_request_tbl;
2188:
2189: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
2190: THEN
2191: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
2192: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
2193: END IF;
2194:
2195:
2188:
2189: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
2190: THEN
2191: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
2192: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
2193: END IF;
2194:
2195:
2196: END PROCESS_MASTER_CHILD_WO;
3097: ) IS
3098:
3099: G_EXC_SEV_QUIT_OBJECT EXCEPTION;
3100: G_EXC_UNEXP_SKIP_OBJECT EXCEPTION;
3101: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
3102: l_other_message VARCHAR2(50);
3103: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
3104: l_err_text VARCHAR2(2000);
3105: l_return_status VARCHAR2(1);
3099: G_EXC_SEV_QUIT_OBJECT EXCEPTION;
3100: G_EXC_UNEXP_SKIP_OBJECT EXCEPTION;
3101: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
3102: l_other_message VARCHAR2(50);
3103: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
3104: l_err_text VARCHAR2(2000);
3105: l_return_status VARCHAR2(1);
3106: l_debug_file_mode VARCHAR2(1) := p_debug_file_mode;
3107:
3132: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3133: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3134: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3135: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3136: l_out_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.mesg_token_tbl_type;
3137:
3138: l_out_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
3139: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3140: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3176:
3177: --
3178: -- Set Business Object Idenfier in the System Information record.
3179: --
3180: EAM_ERROR_MESSAGE_PVT.Set_Bo_Identifier
3181: (p_bo_identifier => p_bo_identifier);
3182:
3183: --
3184: -- Initialize the message list if the user has set the Init Message List parameter
3184: -- Initialize the message list if the user has set the Init Message List parameter
3185: --
3186: IF p_init_msg_list
3187: THEN
3188: EAM_ERROR_MESSAGE_PVT.Initialize;
3189: END IF;
3190:
3191: -- Set the global variable for debug.
3192: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);
3199:
3200: -- If debug is Y then out dir must be specified
3201:
3202: l_out_mesg_token_tbl := l_mesg_token_tbl;
3203: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
3204: ( 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'
3205: , p_Mesg_Token_Tbl => l_mesg_token_tbl
3206: , x_Mesg_Token_Tbl => l_out_mesg_token_tbl
3207: , p_Token_Tbl => l_token_tbl
3227: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
3228: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
3229: l_out_eam_request_tbl := l_eam_request_tbl;
3230:
3231: EAM_ERROR_MESSAGE_PVT.Log_Error
3232: ( p_eam_wo_rec => l_eam_wo_rec
3233: , p_eam_op_tbl => l_eam_op_tbl
3234: , p_eam_op_network_tbl => l_eam_op_network_tbl
3235: , p_eam_res_tbl => l_eam_res_tbl
3239: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
3240: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3241: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3242: , p_error_status => 'W'
3243: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3244: , x_eam_wo_rec => l_out_eam_wo_rec
3245: , x_eam_op_tbl => l_out_eam_op_tbl
3246: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
3247: , x_eam_res_tbl => l_out_eam_res_tbl
3278: IF trim(p_debug_filename) IS NULL OR trim(p_debug_filename) = ''
3279: THEN
3280:
3281: l_out_mesg_token_tbl := l_mesg_token_tbl;
3282: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
3283: ( 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'
3284: , p_Mesg_Token_Tbl => l_mesg_token_tbl
3285: , x_Mesg_Token_Tbl => l_out_mesg_token_tbl
3286: , p_Token_Tbl => l_token_tbl
3305: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
3306: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
3307: l_out_eam_request_tbl := l_eam_request_tbl;
3308:
3309: EAM_ERROR_MESSAGE_PVT.Log_Error
3310: ( p_eam_wo_rec => l_eam_wo_rec
3311: , p_eam_op_tbl => l_eam_op_tbl
3312: , p_eam_op_network_tbl => l_eam_op_network_tbl
3313: , p_eam_res_tbl => l_eam_res_tbl
3317: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
3318: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3319: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3320: , p_error_status => 'W'
3321: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3322: , x_eam_wo_rec => l_out_eam_wo_rec
3323: , x_eam_op_tbl => l_out_eam_op_tbl
3324: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
3325: , x_eam_res_tbl => l_out_eam_res_tbl
3357:
3358: IF l_debug_flag = 'Y'
3359: THEN
3360: l_out_mesg_token_tbl := l_mesg_token_tbl;
3361: EAM_ERROR_MESSAGE_PVT.Open_Debug_Session
3362: ( p_debug_filename => p_debug_filename
3363: , p_output_dir => p_output_dir
3364: , p_debug_file_mode => l_debug_file_mode
3365: , x_return_status => l_return_status
3375: END IF;
3376:
3377: END IF;
3378:
3379: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('The BO as passed '); end if;
3380: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('WO Rec: ' || p_eam_wo_rec.wip_entity_id); end if;
3381: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Num of operations: ' || p_eam_op_tbl.COUNT); end if;
3382: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resources: ' || p_eam_res_tbl.COUNT); END IF;
3383: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of materials: ' || p_eam_mat_req_tbl.COUNT); END IF;
3376:
3377: END IF;
3378:
3379: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('The BO as passed '); end if;
3380: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('WO Rec: ' || p_eam_wo_rec.wip_entity_id); end if;
3381: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Num of operations: ' || p_eam_op_tbl.COUNT); end if;
3382: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resources: ' || p_eam_res_tbl.COUNT); END IF;
3383: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of materials: ' || p_eam_mat_req_tbl.COUNT); END IF;
3384: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of direct items: ' || p_eam_direct_items_tbl.COUNT); END IF;
3377: END IF;
3378:
3379: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('The BO as passed '); end if;
3380: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('WO Rec: ' || p_eam_wo_rec.wip_entity_id); end if;
3381: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Num of operations: ' || p_eam_op_tbl.COUNT); end if;
3382: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resources: ' || p_eam_res_tbl.COUNT); END IF;
3383: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of materials: ' || p_eam_mat_req_tbl.COUNT); END IF;
3384: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of direct items: ' || p_eam_direct_items_tbl.COUNT); END IF;
3385: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of sub resources: ' || p_eam_sub_res_tbl.COUNT); END IF;
3378:
3379: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('The BO as passed '); end if;
3380: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('WO Rec: ' || p_eam_wo_rec.wip_entity_id); end if;
3381: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Num of operations: ' || p_eam_op_tbl.COUNT); end if;
3382: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resources: ' || p_eam_res_tbl.COUNT); END IF;
3383: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of materials: ' || p_eam_mat_req_tbl.COUNT); END IF;
3384: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of direct items: ' || p_eam_direct_items_tbl.COUNT); END IF;
3385: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of sub resources: ' || p_eam_sub_res_tbl.COUNT); END IF;
3386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resource inst: ' || p_eam_res_inst_tbl.COUNT); END IF;
3379: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('The BO as passed '); end if;
3380: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('WO Rec: ' || p_eam_wo_rec.wip_entity_id); end if;
3381: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Num of operations: ' || p_eam_op_tbl.COUNT); end if;
3382: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resources: ' || p_eam_res_tbl.COUNT); END IF;
3383: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of materials: ' || p_eam_mat_req_tbl.COUNT); END IF;
3384: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of direct items: ' || p_eam_direct_items_tbl.COUNT); END IF;
3385: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of sub resources: ' || p_eam_sub_res_tbl.COUNT); END IF;
3386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resource inst: ' || p_eam_res_inst_tbl.COUNT); END IF;
3387: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op networks: ' || p_eam_op_network_tbl.COUNT); END IF;
3380: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('WO Rec: ' || p_eam_wo_rec.wip_entity_id); end if;
3381: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Num of operations: ' || p_eam_op_tbl.COUNT); end if;
3382: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resources: ' || p_eam_res_tbl.COUNT); END IF;
3383: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of materials: ' || p_eam_mat_req_tbl.COUNT); END IF;
3384: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of direct items: ' || p_eam_direct_items_tbl.COUNT); END IF;
3385: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of sub resources: ' || p_eam_sub_res_tbl.COUNT); END IF;
3386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resource inst: ' || p_eam_res_inst_tbl.COUNT); END IF;
3387: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op networks: ' || p_eam_op_network_tbl.COUNT); END IF;
3388:
3381: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Num of operations: ' || p_eam_op_tbl.COUNT); end if;
3382: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resources: ' || p_eam_res_tbl.COUNT); END IF;
3383: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of materials: ' || p_eam_mat_req_tbl.COUNT); END IF;
3384: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of direct items: ' || p_eam_direct_items_tbl.COUNT); END IF;
3385: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of sub resources: ' || p_eam_sub_res_tbl.COUNT); END IF;
3386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resource inst: ' || p_eam_res_inst_tbl.COUNT); END IF;
3387: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op networks: ' || p_eam_op_network_tbl.COUNT); END IF;
3388:
3389: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('WO Completion Rec WID: ' || l_eam_wo_comp_rec.wip_entity_id); END IF;
3382: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resources: ' || p_eam_res_tbl.COUNT); END IF;
3383: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of materials: ' || p_eam_mat_req_tbl.COUNT); END IF;
3384: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of direct items: ' || p_eam_direct_items_tbl.COUNT); END IF;
3385: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of sub resources: ' || p_eam_sub_res_tbl.COUNT); END IF;
3386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resource inst: ' || p_eam_res_inst_tbl.COUNT); END IF;
3387: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op networks: ' || p_eam_op_network_tbl.COUNT); END IF;
3388:
3389: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('WO Completion Rec WID: ' || l_eam_wo_comp_rec.wip_entity_id); END IF;
3390: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of qua records: ' || p_eam_wo_quality_tbl.COUNT); END IF;
3383: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of materials: ' || p_eam_mat_req_tbl.COUNT); END IF;
3384: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of direct items: ' || p_eam_direct_items_tbl.COUNT); END IF;
3385: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of sub resources: ' || p_eam_sub_res_tbl.COUNT); END IF;
3386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resource inst: ' || p_eam_res_inst_tbl.COUNT); END IF;
3387: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op networks: ' || p_eam_op_network_tbl.COUNT); END IF;
3388:
3389: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('WO Completion Rec WID: ' || l_eam_wo_comp_rec.wip_entity_id); END IF;
3390: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of qua records: ' || p_eam_wo_quality_tbl.COUNT); END IF;
3391: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT); END IF;
3385: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of sub resources: ' || p_eam_sub_res_tbl.COUNT); END IF;
3386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resource inst: ' || p_eam_res_inst_tbl.COUNT); END IF;
3387: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op networks: ' || p_eam_op_network_tbl.COUNT); END IF;
3388:
3389: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('WO Completion Rec WID: ' || l_eam_wo_comp_rec.wip_entity_id); END IF;
3390: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of qua records: ' || p_eam_wo_quality_tbl.COUNT); END IF;
3391: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT); END IF;
3392: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT); END IF;
3393: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT); END IF;
3386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resource inst: ' || p_eam_res_inst_tbl.COUNT); END IF;
3387: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op networks: ' || p_eam_op_network_tbl.COUNT); END IF;
3388:
3389: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('WO Completion Rec WID: ' || l_eam_wo_comp_rec.wip_entity_id); END IF;
3390: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of qua records: ' || p_eam_wo_quality_tbl.COUNT); END IF;
3391: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT); END IF;
3392: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT); END IF;
3393: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT); END IF;
3394: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT); END IF;
3387: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op networks: ' || p_eam_op_network_tbl.COUNT); END IF;
3388:
3389: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('WO Completion Rec WID: ' || l_eam_wo_comp_rec.wip_entity_id); END IF;
3390: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of qua records: ' || p_eam_wo_quality_tbl.COUNT); END IF;
3391: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT); END IF;
3392: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT); END IF;
3393: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT); END IF;
3394: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT); END IF;
3395: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op completion recs: ' || p_eam_op_comp_tbl.COUNT); END IF;
3388:
3389: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('WO Completion Rec WID: ' || l_eam_wo_comp_rec.wip_entity_id); END IF;
3390: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of qua records: ' || p_eam_wo_quality_tbl.COUNT); END IF;
3391: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT); END IF;
3392: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT); END IF;
3393: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT); END IF;
3394: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT); END IF;
3395: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op completion recs: ' || p_eam_op_comp_tbl.COUNT); END IF;
3396: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of work request recs: ' || p_eam_request_tbl.COUNT); END IF;
3389: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('WO Completion Rec WID: ' || l_eam_wo_comp_rec.wip_entity_id); END IF;
3390: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of qua records: ' || p_eam_wo_quality_tbl.COUNT); END IF;
3391: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT); END IF;
3392: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT); END IF;
3393: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT); END IF;
3394: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT); END IF;
3395: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op completion recs: ' || p_eam_op_comp_tbl.COUNT); END IF;
3396: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of work request recs: ' || p_eam_request_tbl.COUNT); END IF;
3397:
3390: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of qua records: ' || p_eam_wo_quality_tbl.COUNT); END IF;
3391: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT); END IF;
3392: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT); END IF;
3393: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT); END IF;
3394: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT); END IF;
3395: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op completion recs: ' || p_eam_op_comp_tbl.COUNT); END IF;
3396: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of work request recs: ' || p_eam_request_tbl.COUNT); END IF;
3397:
3398:
3391: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT); END IF;
3392: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT); END IF;
3393: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT); END IF;
3394: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT); END IF;
3395: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op completion recs: ' || p_eam_op_comp_tbl.COUNT); END IF;
3396: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of work request recs: ' || p_eam_request_tbl.COUNT); END IF;
3397:
3398:
3399: --
3392: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT); END IF;
3393: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT); END IF;
3394: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT); END IF;
3395: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op completion recs: ' || p_eam_op_comp_tbl.COUNT); END IF;
3396: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of work request recs: ' || p_eam_request_tbl.COUNT); END IF;
3397:
3398:
3399: --
3400: -- Verify if all the entity record(s) belong to the same business object
3398:
3399: --
3400: -- Verify if all the entity record(s) belong to the same business object
3401: --
3402: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Entering Check_BO_Record procedure, BO record validation'); END IF;
3403:
3404: CHECK_BO_RECORD
3405: ( p_eam_wo_rec => l_eam_wo_rec
3406: , p_eam_op_tbl => l_eam_op_tbl
3426:
3427: IF l_return_status <> 'S' THEN
3428: RAISE G_EXC_SEV_QUIT_OBJECT;
3429: END IF;
3430: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('BO record validation Passed'); END IF;
3431:
3432: --
3433: -- Call the Private API for performing further business rules validation
3434: --
3438: OR (p_eam_res_tbl.COUNT >0) OR (p_eam_res_inst_tbl.COUNT >0) OR (p_eam_sub_res_tbl.COUNT >0)
3439: OR (p_eam_mat_req_tbl.COUNT >0) OR (p_eam_direct_items_tbl.COUNT >0) OR (p_eam_res_usage_tbl.COUNT>0)
3440: THEN
3441:
3442: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Entering the PROCESS_WO private procedure'); END IF;
3443:
3444: EAM_PROCESS_WO_PVT.PROCESS_WO
3445: ( p_api_version_number => p_api_version_number
3446: , x_return_status => x_return_status
3495: l_out_eam_res_usage_tbl := l_eam_res_usage_tbl;
3496: l_out_eam_mat_req_tbl := l_eam_mat_req_tbl;
3497: l_out_eam_direct_items_tbl := l_eam_direct_items_tbl;
3498:
3499: EAM_ERROR_MESSAGE_PVT.Log_Error
3500: ( p_eam_wo_rec => l_eam_wo_rec
3501: , p_eam_op_tbl => l_eam_op_tbl
3502: , p_eam_op_network_tbl => l_eam_op_network_tbl
3503: , p_eam_res_tbl => l_eam_res_tbl
3506: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
3507: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
3508: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3509: , p_mesg_token_tbl => l_mesg_token_tbl
3510: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3511: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
3512: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3513: , p_other_message => l_other_message
3514: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3507: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
3508: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3509: , p_mesg_token_tbl => l_mesg_token_tbl
3510: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3511: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
3512: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3513: , p_other_message => l_other_message
3514: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3515: , p_other_token_tbl => l_token_tbl
3508: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3509: , p_mesg_token_tbl => l_mesg_token_tbl
3510: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3511: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
3512: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3513: , p_other_message => l_other_message
3514: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3515: , p_other_token_tbl => l_token_tbl
3516: , x_eam_wo_rec => l_out_eam_wo_rec
3510: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3511: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
3512: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3513: , p_other_message => l_other_message
3514: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3515: , p_other_token_tbl => l_token_tbl
3516: , x_eam_wo_rec => l_out_eam_wo_rec
3517: , x_eam_op_tbl => l_out_eam_op_tbl
3518: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
3548: --removed code for failure entry and shifted it to EAMVWOPB.pls
3549:
3550:
3551: x_return_status := l_return_status;
3552: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3553:
3554: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3555: THEN
3556: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3552: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3553:
3554: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3555: THEN
3556: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3557: IF p_eam_request_tbl.COUNT = 0 THEN
3558: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3559: END IF;
3560: END IF;
3554: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3555: THEN
3556: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3557: IF p_eam_request_tbl.COUNT = 0 THEN
3558: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3559: END IF;
3560: END IF;
3561:
3562:
3601: x_msg_count := l_msg_count;
3602:
3603: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3604: THEN
3605: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3606: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3607: END IF;
3608:
3609:
3602:
3603: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3604: THEN
3605: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3606: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3607: END IF;
3608:
3609:
3610: END IF;
3625: x_msg_count := l_msg_count;
3626:
3627: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3628: THEN
3629: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3630: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3631: END IF;
3632:
3633:
3626:
3627: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3628: THEN
3629: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3630: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3631: END IF;
3632:
3633:
3634: END IF;
3648: x_msg_count := l_msg_count;
3649:
3650: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3651: THEN
3652: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3653: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3654: END IF;
3655:
3656:
3649:
3650: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3651: THEN
3652: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3653: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3654: END IF;
3655:
3656:
3657: END IF;
3665: -- been logged. There is no need to do it again.
3666:
3667:
3668:
3669: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
3670: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3671:
3672: x_eam_wo_rec := l_eam_wo_rec;
3673: x_eam_op_tbl := l_eam_op_tbl;
3666:
3667:
3668:
3669: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
3670: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3671:
3672: x_eam_wo_rec := l_eam_wo_rec;
3673: x_eam_op_tbl := l_eam_op_tbl;
3674: x_eam_op_network_tbl := l_eam_op_network_tbl;
3689: x_eam_request_tbl := l_eam_request_tbl;
3690:
3691: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3692: THEN
3693: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3694: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3695: END IF;
3696:
3697:
3690:
3691: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3692: THEN
3693: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3694: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3695: END IF;
3696:
3697:
3698: WHEN G_EXC_UNEXP_SKIP_OBJECT THEN
3717: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
3718: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
3719: l_out_eam_request_tbl := l_eam_request_tbl;
3720:
3721: EAM_ERROR_MESSAGE_PVT.Log_Error
3722: ( p_eam_wo_rec => l_eam_wo_rec
3723: , p_eam_op_tbl => l_eam_op_tbl
3724: , p_eam_op_network_tbl => l_eam_op_network_tbl
3725: , p_eam_res_tbl => l_eam_res_tbl
3728: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
3729: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
3730: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3731: , p_mesg_token_tbl => l_mesg_token_tbl
3732: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED
3733: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3734: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_NOT_PICKED
3735: , p_other_message => l_other_message
3736: , p_other_token_tbl => l_token_tbl
3729: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
3730: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3731: , p_mesg_token_tbl => l_mesg_token_tbl
3732: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED
3733: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3734: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_NOT_PICKED
3735: , p_other_message => l_other_message
3736: , p_other_token_tbl => l_token_tbl
3737: , x_eam_wo_rec => l_out_eam_wo_rec
3730: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3731: , p_mesg_token_tbl => l_mesg_token_tbl
3732: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED
3733: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3734: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_NOT_PICKED
3735: , p_other_message => l_other_message
3736: , p_other_token_tbl => l_token_tbl
3737: , x_eam_wo_rec => l_out_eam_wo_rec
3738: , x_eam_op_tbl => l_out_eam_op_tbl
3782: x_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
3783: x_eam_op_comp_tbl := l_eam_op_comp_tbl;
3784: x_eam_request_tbl := l_eam_request_tbl;
3785:
3786: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
3787: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3788:
3789: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3790: THEN
3783: x_eam_op_comp_tbl := l_eam_op_comp_tbl;
3784: x_eam_request_tbl := l_eam_request_tbl;
3785:
3786: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
3787: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3788:
3789: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3790: THEN
3791: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3787: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3788:
3789: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3790: THEN
3791: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3792: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3793: END IF;
3794:
3795:
3788:
3789: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3790: THEN
3791: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3792: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3793: END IF;
3794:
3795:
3796: WHEN OTHERS THEN
3796: WHEN OTHERS THEN
3797:
3798: -- Call Error Handler
3799:
3800: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
3801: ( p_message_name => 'EAM_PR_WO_UNKNOWN_ERROR'
3802: , p_token_tbl => l_token_tbl
3803: , p_mesg_token_tbl => l_mesg_token_tbl
3804: , x_mesg_token_tbl => l_out_mesg_token_tbl
3825: l_out_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
3826: l_out_eam_op_comp_tbl := l_eam_op_comp_tbl;
3827: l_out_eam_request_tbl := l_eam_request_tbl;
3828:
3829: EAM_ERROR_MESSAGE_PVT.Log_Error
3830: ( p_eam_wo_rec => l_eam_wo_rec
3831: , p_eam_op_tbl => l_eam_op_tbl
3832: , p_eam_op_network_tbl => l_eam_op_network_tbl
3833: , p_eam_res_tbl => l_eam_res_tbl
3836: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
3837: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
3838: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3839: , p_mesg_token_tbl => l_mesg_token_tbl
3840: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED
3841: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3842: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3843: , p_other_message => l_other_message
3844: , x_eam_wo_rec => l_out_eam_wo_rec
3837: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
3838: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3839: , p_mesg_token_tbl => l_mesg_token_tbl
3840: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED
3841: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3842: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3843: , p_other_message => l_other_message
3844: , x_eam_wo_rec => l_out_eam_wo_rec
3845: , x_eam_op_tbl => l_out_eam_op_tbl
3838: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
3839: , p_mesg_token_tbl => l_mesg_token_tbl
3840: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED
3841: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
3842: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
3843: , p_other_message => l_other_message
3844: , x_eam_wo_rec => l_out_eam_wo_rec
3845: , x_eam_op_tbl => l_out_eam_op_tbl
3846: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
3889: x_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
3890: x_eam_op_comp_tbl := l_eam_op_comp_tbl;
3891: x_eam_request_tbl := l_eam_request_tbl;
3892:
3893: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
3894: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3895:
3896: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3897: THEN
3890: x_eam_op_comp_tbl := l_eam_op_comp_tbl;
3891: x_eam_request_tbl := l_eam_request_tbl;
3892:
3893: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
3894: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3895:
3896: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3897: THEN
3898: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3894: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3895:
3896: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3897: THEN
3898: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3899: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3900: END IF;
3901:
3902:
3895:
3896: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3897: THEN
3898: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3899: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3900: END IF;
3901:
3902:
3903: END PROCESS_WO;
4014: -- baroy
4015: l_wip_entity_id NUMBER := NULL;
4016: l_organization_id NUMBER := NULL;
4017: l_other_message VARCHAR2(50) := NULL;
4018: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
4019: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
4020:
4021: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
4022: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
4015: l_wip_entity_id NUMBER := NULL;
4016: l_organization_id NUMBER := NULL;
4017: l_other_message VARCHAR2(50) := NULL;
4018: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
4019: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
4020:
4021: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
4022: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
4023: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
4260: l_out_eam_mat_req_tbl := l_eam_mat_req_tbl;
4261: l_out_eam_direct_items_tbl := l_eam_direct_items_tbl;
4262:
4263: -- Log the error
4264: EAM_ERROR_MESSAGE_PVT.Log_Error
4265: ( p_eam_wo_rec => l_eam_wo_rec
4266: , p_eam_op_tbl => l_eam_op_tbl
4267: , p_eam_op_network_tbl => l_eam_op_network_tbl
4268: , p_eam_res_tbl => l_eam_res_tbl
4271: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
4272: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
4273: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
4274: , p_mesg_token_tbl => l_mesg_token_tbl
4275: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4276: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
4277: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
4278: , p_other_message => l_other_message
4279: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4272: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
4273: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
4274: , p_mesg_token_tbl => l_mesg_token_tbl
4275: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4276: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
4277: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
4278: , p_other_message => l_other_message
4279: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4280: , p_other_token_tbl => l_token_tbl
4273: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
4274: , p_mesg_token_tbl => l_mesg_token_tbl
4275: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4276: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
4277: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
4278: , p_other_message => l_other_message
4279: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4280: , p_other_token_tbl => l_token_tbl
4281: , x_eam_wo_rec => l_out_eam_wo_rec
4275: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4276: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
4277: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
4278: , p_other_message => l_other_message
4279: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4280: , p_other_token_tbl => l_token_tbl
4281: , x_eam_wo_rec => l_out_eam_wo_rec
4282: , x_eam_op_tbl => l_out_eam_op_tbl
4283: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
4309: l_organization_id := p_eam_wo_rec.organization_id;
4310: END IF;
4311: -- end - baroy
4312:
4313: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating OP record'); END IF;
4314:
4315: FOR I IN 1..p_eam_op_tbl.COUNT LOOP
4316: IF p_eam_op_tbl(I).wip_entity_id is not null AND (
4317: p_eam_op_tbl(I).wip_entity_id <> l_wip_entity_id OR
4321: l_other_message := 'EAM_WO_BO_REC_INVALID';
4322: END IF;
4323: END LOOP;
4324:
4325: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating OPN record'); END IF;
4326:
4327: FOR I IN 1..p_eam_op_network_tbl.COUNT LOOP
4328: IF p_eam_op_network_tbl(I).wip_entity_id is not null AND (
4329: p_eam_op_network_tbl(I).wip_entity_id <> l_wip_entity_id OR
4333: l_other_message := 'EAM_WO_BO_REC_INVALID';
4334: END IF;
4335: END LOOP;
4336:
4337: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating RES record'); END IF;
4338:
4339: FOR I IN 1..p_eam_res_tbl.COUNT LOOP
4340:
4341: IF p_eam_res_tbl(I).wip_entity_id is not null AND (
4346: l_other_message := 'EAM_WO_BO_REC_INVALID';
4347: END IF;
4348: END LOOP;
4349:
4350: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating RES_INST record'); END IF;
4351:
4352: FOR I IN 1..p_eam_res_inst_tbl.COUNT LOOP
4353: IF p_eam_res_inst_tbl(I).wip_entity_id is not null AND (
4354: p_eam_res_inst_tbl(I).wip_entity_id <> l_wip_entity_id OR
4358: l_other_message := 'EAM_WO_BO_REC_INVALID';
4359: END IF;
4360: END LOOP;
4361:
4362: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating SUB_RES record'); END IF;
4363:
4364: FOR I IN 1..p_eam_sub_res_tbl.COUNT LOOP
4365: IF p_eam_sub_res_tbl(I).wip_entity_id is not null AND (
4366: p_eam_sub_res_tbl(I).wip_entity_id <> l_wip_entity_id OR
4370: l_other_message := 'EAM_WO_BO_REC_INVALID';
4371: END IF;
4372: END LOOP;
4373:
4374: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating RES_USAGE record'); END IF;
4375:
4376: FOR I IN 1..p_eam_res_usage_tbl.COUNT LOOP
4377: IF p_eam_res_usage_tbl(I).wip_entity_id is not null AND (
4378: p_eam_res_usage_tbl(I).wip_entity_id <> l_wip_entity_id OR
4382: l_other_message := 'EAM_WO_BO_REC_INVALID';
4383: END IF;
4384: END LOOP;
4385:
4386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating MAT_REQ record'); END IF;
4387:
4388: FOR I IN 1..p_eam_mat_req_tbl.COUNT LOOP
4389: IF p_eam_mat_req_tbl(I).wip_entity_id is not null AND (
4390: p_eam_mat_req_tbl(I).wip_entity_id <> l_wip_entity_id OR
4394: l_other_message := 'EAM_WO_BO_REC_INVALID';
4395: END IF;
4396: END LOOP;
4397:
4398: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating DI record'); END IF;
4399:
4400: FOR I IN 1..p_eam_direct_items_tbl.COUNT LOOP
4401: IF p_eam_direct_items_tbl(I).wip_entity_id is not null AND (
4402: p_eam_direct_items_tbl(I).wip_entity_id <> l_wip_entity_id OR
4419: l_out_eam_res_usage_tbl := l_eam_res_usage_tbl;
4420: l_out_eam_mat_req_tbl := l_eam_mat_req_tbl;
4421: l_out_eam_direct_items_tbl := l_eam_direct_items_tbl;
4422:
4423: EAM_ERROR_MESSAGE_PVT.Log_Error
4424: ( p_eam_wo_rec => l_eam_wo_rec
4425: , p_eam_op_tbl => l_eam_op_tbl
4426: , p_eam_op_network_tbl => l_eam_op_network_tbl
4427: , p_eam_res_tbl => l_eam_res_tbl
4430: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
4431: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
4432: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
4433: , p_mesg_token_tbl => l_mesg_token_tbl
4434: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4435: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
4436: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
4437: , p_other_message => l_other_message
4438: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4431: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
4432: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
4433: , p_mesg_token_tbl => l_mesg_token_tbl
4434: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4435: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
4436: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
4437: , p_other_message => l_other_message
4438: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4439: , p_other_token_tbl => l_token_tbl
4432: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
4433: , p_mesg_token_tbl => l_mesg_token_tbl
4434: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4435: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
4436: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
4437: , p_other_message => l_other_message
4438: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4439: , p_other_token_tbl => l_token_tbl
4440: , x_eam_wo_rec => l_out_eam_wo_rec
4434: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4435: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
4436: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
4437: , p_other_message => l_other_message
4438: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4439: , p_other_token_tbl => l_token_tbl
4440: , x_eam_wo_rec => l_out_eam_wo_rec
4441: , x_eam_op_tbl => l_out_eam_op_tbl
4442: , x_eam_op_network_tbl => l_out_eam_op_network_tbl
4477: l_eam_wo_comp_rebuild_tbl := p_eam_wo_comp_rebuild_tbl;
4478: l_eam_wo_comp_mr_read_tbl := p_eam_wo_comp_mr_read_tbl;
4479:
4480:
4481: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating Quality record'); END IF;
4482:
4483: FOR I IN 1..l_eam_wo_quality_tbl.COUNT LOOP
4484: IF p_eam_wo_quality_tbl(I).wip_entity_id is not null AND (
4485: p_eam_wo_quality_tbl(I).wip_entity_id <> l_wip_entity_id OR
4489: l_other_message := 'EAM_WO_BO_REC_INVALID';
4490: END IF;
4491: END LOOP;
4492:
4493: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating Meter record'); END IF;
4494:
4495: FOR I IN 1..l_eam_meter_reading_tbl.COUNT LOOP
4496: IF p_eam_meter_reading_tbl(I).wip_entity_id is not null AND (
4497: p_eam_meter_reading_tbl(I).wip_entity_id <> l_wip_entity_id
4501: l_other_message := 'EAM_WO_BO_REC_INVALID';
4502: END IF;
4503: END LOOP;
4504:
4505: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating Counter Properties record'); END IF;
4506:
4507: FOR I IN 1..l_eam_counter_prop_tbl.COUNT LOOP
4508: IF p_eam_counter_prop_tbl(I).wip_entity_id is not null AND (
4509: p_eam_counter_prop_tbl(I).wip_entity_id <> l_wip_entity_id
4514: END IF;
4515: END LOOP;
4516:
4517:
4518: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating Meter Completion record'); END IF;
4519:
4520: FOR I IN 1..l_eam_wo_comp_rebuild_tbl.COUNT LOOP
4521: IF p_eam_wo_comp_rebuild_tbl(I).wip_entity_id is not null AND (
4522: p_eam_wo_comp_rebuild_tbl(I).wip_entity_id <> l_wip_entity_id OR
4526: l_other_message := 'EAM_WO_BO_REC_INVALID';
4527: END IF;
4528: END LOOP;
4529:
4530: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating Rebuild Completion record'); END IF;
4531:
4532: FOR I IN 1..l_eam_wo_comp_mr_read_tbl.COUNT LOOP
4533: IF p_eam_wo_comp_mr_read_tbl(I).wip_entity_id is not null AND (
4534: p_eam_wo_comp_mr_read_tbl(I).wip_entity_id <> l_wip_entity_id OR
4551: l_out_eam_res_usage_tbl := l_eam_res_usage_tbl;
4552: l_out_eam_mat_req_tbl := l_eam_mat_req_tbl;
4553: l_out_eam_direct_items_tbl := l_eam_direct_items_tbl;
4554:
4555: EAM_ERROR_MESSAGE_PVT.Log_Error
4556: ( p_eam_wo_rec => l_eam_wo_rec
4557: , p_eam_op_tbl => l_eam_op_tbl
4558: , p_eam_op_network_tbl => l_eam_op_network_tbl
4559: , p_eam_res_tbl => l_eam_res_tbl
4562: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
4563: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
4564: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
4565: , p_mesg_token_tbl => l_mesg_token_tbl
4566: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4567: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
4568: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
4569: , p_other_message => l_other_message
4570: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4563: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
4564: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
4565: , p_mesg_token_tbl => l_mesg_token_tbl
4566: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4567: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
4568: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
4569: , p_other_message => l_other_message
4570: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4571: , p_other_token_tbl => l_token_tbl
4564: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
4565: , p_mesg_token_tbl => l_mesg_token_tbl
4566: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4567: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
4568: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
4569: , p_other_message => l_other_message
4570: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4571: , p_other_token_tbl => l_token_tbl
4572: , x_eam_wo_rec => l_out_eam_wo_rec
4566: , p_error_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4567: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_ALL
4568: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL
4569: , p_other_message => l_other_message
4570: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
4571: , p_other_token_tbl => l_token_tbl
4572: , x_eam_wo_rec => l_out_eam_wo_rec
4573: , x_eam_op_tbl => l_out_eam_op_tbl
4574: , x_eam_op_network_tbl => l_out_eam_op_network_tbl