19: --
20: -- 06-OCT-02 M V M P Tilak Initial Creation
21: ***************************************************************************/
22:
23: G_rtg_header_rec BOM_RTG_PUB.RTG_HEADER_REC_TYPE;
24: G_rtg_revision_tbl BOM_RTG_PUB.RTG_REVISION_TBL_TYPE;
25: G_operation_tbl BOM_RTG_PUB.OPERATION_TBL_TYPE;
26: G_op_resource_tbl BOM_RTG_PUB.OP_RESOURCE_TBL_TYPE;
27: G_sub_resource_tbl BOM_RTG_PUB.SUB_RESOURCE_TBL_TYPE;
20: -- 06-OCT-02 M V M P Tilak Initial Creation
21: ***************************************************************************/
22:
23: G_rtg_header_rec BOM_RTG_PUB.RTG_HEADER_REC_TYPE;
24: G_rtg_revision_tbl BOM_RTG_PUB.RTG_REVISION_TBL_TYPE;
25: G_operation_tbl BOM_RTG_PUB.OPERATION_TBL_TYPE;
26: G_op_resource_tbl BOM_RTG_PUB.OP_RESOURCE_TBL_TYPE;
27: G_sub_resource_tbl BOM_RTG_PUB.SUB_RESOURCE_TBL_TYPE;
28: G_op_network_tbl BOM_RTG_PUB.OP_NETWORK_TBL_TYPE;
21: ***************************************************************************/
22:
23: G_rtg_header_rec BOM_RTG_PUB.RTG_HEADER_REC_TYPE;
24: G_rtg_revision_tbl BOM_RTG_PUB.RTG_REVISION_TBL_TYPE;
25: G_operation_tbl BOM_RTG_PUB.OPERATION_TBL_TYPE;
26: G_op_resource_tbl BOM_RTG_PUB.OP_RESOURCE_TBL_TYPE;
27: G_sub_resource_tbl BOM_RTG_PUB.SUB_RESOURCE_TBL_TYPE;
28: G_op_network_tbl BOM_RTG_PUB.OP_NETWORK_TBL_TYPE;
29:
22:
23: G_rtg_header_rec BOM_RTG_PUB.RTG_HEADER_REC_TYPE;
24: G_rtg_revision_tbl BOM_RTG_PUB.RTG_REVISION_TBL_TYPE;
25: G_operation_tbl BOM_RTG_PUB.OPERATION_TBL_TYPE;
26: G_op_resource_tbl BOM_RTG_PUB.OP_RESOURCE_TBL_TYPE;
27: G_sub_resource_tbl BOM_RTG_PUB.SUB_RESOURCE_TBL_TYPE;
28: G_op_network_tbl BOM_RTG_PUB.OP_NETWORK_TBL_TYPE;
29:
30: PROCEDURE Populate_Header(P_organization_code IN VARCHAR2,
23: G_rtg_header_rec BOM_RTG_PUB.RTG_HEADER_REC_TYPE;
24: G_rtg_revision_tbl BOM_RTG_PUB.RTG_REVISION_TBL_TYPE;
25: G_operation_tbl BOM_RTG_PUB.OPERATION_TBL_TYPE;
26: G_op_resource_tbl BOM_RTG_PUB.OP_RESOURCE_TBL_TYPE;
27: G_sub_resource_tbl BOM_RTG_PUB.SUB_RESOURCE_TBL_TYPE;
28: G_op_network_tbl BOM_RTG_PUB.OP_NETWORK_TBL_TYPE;
29:
30: PROCEDURE Populate_Header(P_organization_code IN VARCHAR2,
31: P_organization_id IN NUMBER,
24: G_rtg_revision_tbl BOM_RTG_PUB.RTG_REVISION_TBL_TYPE;
25: G_operation_tbl BOM_RTG_PUB.OPERATION_TBL_TYPE;
26: G_op_resource_tbl BOM_RTG_PUB.OP_RESOURCE_TBL_TYPE;
27: G_sub_resource_tbl BOM_RTG_PUB.SUB_RESOURCE_TBL_TYPE;
28: G_op_network_tbl BOM_RTG_PUB.OP_NETWORK_TBL_TYPE;
29:
30: PROCEDURE Populate_Header(P_organization_code IN VARCHAR2,
31: P_organization_id IN NUMBER,
32: P_assembly_item_name IN VARCHAR2,
660: P_alternate_routing_designator IN VARCHAR2,
661: P_debug IN VARCHAR2 := 'N',
662: P_output_dir IN VARCHAR2 := NULL,
663: P_debug_filename IN VARCHAR2 := 'RTG_EXP_debug.log',
664: X_rtg_header_rec OUT NOCOPY BOM_RTG_PUB.Rtg_Header_Rec_Type,
665: X_rtg_revision_tbl OUT NOCOPY BOM_RTG_PUB.Rtg_Revision_Tbl_Type,
666: X_operation_tbl OUT NOCOPY BOM_RTG_PUB.Operation_Tbl_Type,
667: X_op_resource_tbl OUT NOCOPY BOM_RTG_PUB.Op_Resource_Tbl_Type,
668: X_sub_resource_tbl OUT NOCOPY BOM_RTG_PUB.Sub_Resource_Tbl_Type,
661: P_debug IN VARCHAR2 := 'N',
662: P_output_dir IN VARCHAR2 := NULL,
663: P_debug_filename IN VARCHAR2 := 'RTG_EXP_debug.log',
664: X_rtg_header_rec OUT NOCOPY BOM_RTG_PUB.Rtg_Header_Rec_Type,
665: X_rtg_revision_tbl OUT NOCOPY BOM_RTG_PUB.Rtg_Revision_Tbl_Type,
666: X_operation_tbl OUT NOCOPY BOM_RTG_PUB.Operation_Tbl_Type,
667: X_op_resource_tbl OUT NOCOPY BOM_RTG_PUB.Op_Resource_Tbl_Type,
668: X_sub_resource_tbl OUT NOCOPY BOM_RTG_PUB.Sub_Resource_Tbl_Type,
669: X_op_network_tbl OUT NOCOPY BOM_RTG_PUB.Op_Network_Tbl_Type,
662: P_output_dir IN VARCHAR2 := NULL,
663: P_debug_filename IN VARCHAR2 := 'RTG_EXP_debug.log',
664: X_rtg_header_rec OUT NOCOPY BOM_RTG_PUB.Rtg_Header_Rec_Type,
665: X_rtg_revision_tbl OUT NOCOPY BOM_RTG_PUB.Rtg_Revision_Tbl_Type,
666: X_operation_tbl OUT NOCOPY BOM_RTG_PUB.Operation_Tbl_Type,
667: X_op_resource_tbl OUT NOCOPY BOM_RTG_PUB.Op_Resource_Tbl_Type,
668: X_sub_resource_tbl OUT NOCOPY BOM_RTG_PUB.Sub_Resource_Tbl_Type,
669: X_op_network_tbl OUT NOCOPY BOM_RTG_PUB.Op_Network_Tbl_Type,
670: X_return_status OUT NOCOPY VARCHAR2,
663: P_debug_filename IN VARCHAR2 := 'RTG_EXP_debug.log',
664: X_rtg_header_rec OUT NOCOPY BOM_RTG_PUB.Rtg_Header_Rec_Type,
665: X_rtg_revision_tbl OUT NOCOPY BOM_RTG_PUB.Rtg_Revision_Tbl_Type,
666: X_operation_tbl OUT NOCOPY BOM_RTG_PUB.Operation_Tbl_Type,
667: X_op_resource_tbl OUT NOCOPY BOM_RTG_PUB.Op_Resource_Tbl_Type,
668: X_sub_resource_tbl OUT NOCOPY BOM_RTG_PUB.Sub_Resource_Tbl_Type,
669: X_op_network_tbl OUT NOCOPY BOM_RTG_PUB.Op_Network_Tbl_Type,
670: X_return_status OUT NOCOPY VARCHAR2,
671: X_msg_count OUT NOCOPY NUMBER
664: X_rtg_header_rec OUT NOCOPY BOM_RTG_PUB.Rtg_Header_Rec_Type,
665: X_rtg_revision_tbl OUT NOCOPY BOM_RTG_PUB.Rtg_Revision_Tbl_Type,
666: X_operation_tbl OUT NOCOPY BOM_RTG_PUB.Operation_Tbl_Type,
667: X_op_resource_tbl OUT NOCOPY BOM_RTG_PUB.Op_Resource_Tbl_Type,
668: X_sub_resource_tbl OUT NOCOPY BOM_RTG_PUB.Sub_Resource_Tbl_Type,
669: X_op_network_tbl OUT NOCOPY BOM_RTG_PUB.Op_Network_Tbl_Type,
670: X_return_status OUT NOCOPY VARCHAR2,
671: X_msg_count OUT NOCOPY NUMBER
672: ) IS
665: X_rtg_revision_tbl OUT NOCOPY BOM_RTG_PUB.Rtg_Revision_Tbl_Type,
666: X_operation_tbl OUT NOCOPY BOM_RTG_PUB.Operation_Tbl_Type,
667: X_op_resource_tbl OUT NOCOPY BOM_RTG_PUB.Op_Resource_Tbl_Type,
668: X_sub_resource_tbl OUT NOCOPY BOM_RTG_PUB.Sub_Resource_Tbl_Type,
669: X_op_network_tbl OUT NOCOPY BOM_RTG_PUB.Op_Network_Tbl_Type,
670: X_return_status OUT NOCOPY VARCHAR2,
671: X_msg_count OUT NOCOPY NUMBER
672: ) IS
673: l_organization_id NUMBER;
707: x_Mesg_Token_Tbl => l_mesg_token_tbl,
708: p_Token_Tbl => l_token_tbl);
709:
710: Bom_Rtg_Error_Handler.Log_Error
711: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
712: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
713: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
714: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
715: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
708: p_Token_Tbl => l_token_tbl);
709:
710: Bom_Rtg_Error_Handler.Log_Error
711: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
712: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
713: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
714: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
715: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
716: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
709:
710: Bom_Rtg_Error_Handler.Log_Error
711: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
712: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
713: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
714: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
715: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
716: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
717: p_mesg_token_tbl => l_mesg_token_tbl,
710: Bom_Rtg_Error_Handler.Log_Error
711: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
712: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
713: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
714: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
715: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
716: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
717: p_mesg_token_tbl => l_mesg_token_tbl,
718: p_error_status => 'W',
711: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
712: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
713: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
714: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
715: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
716: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
717: p_mesg_token_tbl => l_mesg_token_tbl,
718: p_error_status => 'W',
719: p_error_scope => NULL,
712: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
713: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
714: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
715: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
716: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
717: p_mesg_token_tbl => l_mesg_token_tbl,
718: p_error_status => 'W',
719: p_error_scope => NULL,
720: p_other_message => NULL,
753: p_Mesg_Token_Tbl => l_mesg_token_tbl,
754: x_Mesg_Token_Tbl => l_mesg_token_tbl,
755: p_Token_Tbl => l_token_tbl);
756: BOM_RTG_ERROR_HANDLER.Log_Error
757: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
758: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
759: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
760: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
761: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
754: x_Mesg_Token_Tbl => l_mesg_token_tbl,
755: p_Token_Tbl => l_token_tbl);
756: BOM_RTG_ERROR_HANDLER.Log_Error
757: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
758: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
759: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
760: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
761: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
762: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
755: p_Token_Tbl => l_token_tbl);
756: BOM_RTG_ERROR_HANDLER.Log_Error
757: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
758: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
759: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
760: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
761: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
762: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
763: p_mesg_token_tbl => l_mesg_token_tbl,
756: BOM_RTG_ERROR_HANDLER.Log_Error
757: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
758: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
759: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
760: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
761: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
762: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
763: p_mesg_token_tbl => l_mesg_token_tbl,
764: p_error_status => 'W',
757: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
758: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
759: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
760: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
761: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
762: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
763: p_mesg_token_tbl => l_mesg_token_tbl,
764: p_error_status => 'W',
765: p_error_scope => NULL,
758: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
759: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
760: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
761: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
762: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
763: p_mesg_token_tbl => l_mesg_token_tbl,
764: p_error_status => 'W',
765: p_error_scope => NULL,
766: p_other_message => NULL,
892: X_return_status := 'S';
893: EXCEPTION
894: WHEN G_EXC_SEV_QUIT_OBJECT THEN
895: BOM_RTG_ERROR_HANDLER.Log_Error
896: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
897: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
898: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
899: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
900: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
893: EXCEPTION
894: WHEN G_EXC_SEV_QUIT_OBJECT THEN
895: BOM_RTG_ERROR_HANDLER.Log_Error
896: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
897: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
898: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
899: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
900: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
901: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
894: WHEN G_EXC_SEV_QUIT_OBJECT THEN
895: BOM_RTG_ERROR_HANDLER.Log_Error
896: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
897: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
898: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
899: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
900: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
901: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
902: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl,
895: BOM_RTG_ERROR_HANDLER.Log_Error
896: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
897: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
898: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
899: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
900: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
901: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
902: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl,
903: p_error_status => Error_Handler.G_STATUS_ERROR,
896: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
897: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
898: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
899: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
900: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
901: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
902: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl,
903: p_error_status => Error_Handler.G_STATUS_ERROR,
904: p_error_level => Error_Handler.G_BO_LEVEL,
897: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
898: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
899: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
900: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
901: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
902: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl,
903: p_error_status => Error_Handler.G_STATUS_ERROR,
904: p_error_level => Error_Handler.G_BO_LEVEL,
905: p_error_scope => Error_Handler.G_SCOPE_ALL,
937: END IF;
938:
939: WHEN G_EXC_UNEXP_SKIP_OBJECT THEN
940: BOM_RTG_ERROR_HANDLER.Log_Error
941: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
942: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
943: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
944: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
945: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
938:
939: WHEN G_EXC_UNEXP_SKIP_OBJECT THEN
940: BOM_RTG_ERROR_HANDLER.Log_Error
941: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
942: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
943: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
944: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
945: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
946: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
939: WHEN G_EXC_UNEXP_SKIP_OBJECT THEN
940: BOM_RTG_ERROR_HANDLER.Log_Error
941: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
942: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
943: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
944: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
945: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
946: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
947: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl,
940: BOM_RTG_ERROR_HANDLER.Log_Error
941: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
942: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
943: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
944: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
945: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
946: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
947: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl,
948: p_error_status => Error_Handler.G_STATUS_UNEXPECTED,
941: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
942: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
943: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
944: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
945: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
946: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
947: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl,
948: p_error_status => Error_Handler.G_STATUS_UNEXPECTED,
949: p_error_scope => NULL,
942: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
943: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
944: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
945: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
946: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
947: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl,
948: p_error_status => Error_Handler.G_STATUS_UNEXPECTED,
949: p_error_scope => NULL,
950: p_other_mesg_appid => 'BOM',
980: ERROR_HANDLER.Close_Debug_Session;
981: END IF;
982: WHEN no_data_found THEN
983: BOM_RTG_ERROR_HANDLER.Log_Error
984: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
985: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
986: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
987: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
988: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
981: END IF;
982: WHEN no_data_found THEN
983: BOM_RTG_ERROR_HANDLER.Log_Error
984: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
985: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
986: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
987: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
988: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
989: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
982: WHEN no_data_found THEN
983: BOM_RTG_ERROR_HANDLER.Log_Error
984: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
985: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
986: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
987: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
988: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
989: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
990: p_mesg_token_tbl => l_mesg_token_tbl,
983: BOM_RTG_ERROR_HANDLER.Log_Error
984: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
985: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
986: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
987: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
988: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
989: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
990: p_mesg_token_tbl => l_mesg_token_tbl,
991: p_error_status => Error_Handler.G_STATUS_ERROR,
984: (p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC,
985: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
986: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
987: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
988: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
989: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
990: p_mesg_token_tbl => l_mesg_token_tbl,
991: p_error_status => Error_Handler.G_STATUS_ERROR,
992: p_other_mesg_appid => 'BOM',
985: p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL,
986: p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL,
987: p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL,
988: p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL,
989: p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL,
990: p_mesg_token_tbl => l_mesg_token_tbl,
991: p_error_status => Error_Handler.G_STATUS_ERROR,
992: p_other_mesg_appid => 'BOM',
993: p_other_token_tbl => Error_Handler.G_MISS_TOKEN_TBL,