28:
29: /*******************************************************
30: -- Routing BO records
31: ********************************************************/
32: g_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
33: g_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
34: g_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
35: g_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
36: g_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
29: /*******************************************************
30: -- Routing BO records
31: ********************************************************/
32: g_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
33: g_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
34: g_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
35: g_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
36: g_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
37: g_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
30: -- Routing BO records
31: ********************************************************/
32: g_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
33: g_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
34: g_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
35: g_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
36: g_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
37: g_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
38:
31: ********************************************************/
32: g_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
33: g_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
34: g_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
35: g_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
36: g_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
37: g_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
38:
39: /* BOM BO RECORDS added for add_message procedure */
32: g_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
33: g_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
34: g_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
35: g_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
36: g_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
37: g_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
38:
39: /* BOM BO RECORDS added for add_message procedure */
40: g_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
33: g_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
34: g_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
35: g_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
36: g_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
37: g_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
38:
39: /* BOM BO RECORDS added for add_message procedure */
40: g_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
41: g_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
578: * and that the rest of the entities get the appropriate
579: * status and message.
580: ******************************************************************/
581: PROCEDURE Log_Error
582: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
583: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
584: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
585: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
586: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
579: * status and message.
580: ******************************************************************/
581: PROCEDURE Log_Error
582: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
583: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
584: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
585: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
586: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
587: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
580: ******************************************************************/
581: PROCEDURE Log_Error
582: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
583: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
584: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
585: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
586: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
587: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
588: , p_Mesg_Token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
581: PROCEDURE Log_Error
582: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
583: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
584: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
585: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
586: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
587: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
588: , p_Mesg_Token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
589: , p_error_status IN VARCHAR2
582: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
583: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
584: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
585: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
586: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
587: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
588: , p_Mesg_Token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
589: , p_error_status IN VARCHAR2
590: , p_error_scope IN VARCHAR2
583: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
584: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
585: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
586: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
587: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
588: , p_Mesg_Token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
589: , p_error_status IN VARCHAR2
590: , p_error_scope IN VARCHAR2
591: , p_other_message IN VARCHAR2
593: , p_other_status IN VARCHAR2
594: , p_other_token_tbl IN Error_Handler.Token_Tbl_Type
595: , p_error_level IN NUMBER
596: , p_entity_index IN NUMBER
597: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
598: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
599: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
600: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
601: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
594: , p_other_token_tbl IN Error_Handler.Token_Tbl_Type
595: , p_error_level IN NUMBER
596: , p_entity_index IN NUMBER
597: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
598: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
599: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
600: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
601: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
602: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
595: , p_error_level IN NUMBER
596: , p_entity_index IN NUMBER
597: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
598: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
599: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
600: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
601: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
602: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
603: )
596: , p_entity_index IN NUMBER
597: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
598: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
599: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
600: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
601: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
602: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
603: )
604:
597: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
598: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
599: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
600: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
601: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
602: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
603: )
604:
605: IS
598: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
599: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
600: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
601: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
602: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
603: )
604:
605: IS
606: l_message_name VARCHAR2(30);