50: , p_alternate_routing_code IN VARCHAR2
51: , p_operation_seq_num IN NUMBER
52: , p_effectivity_date IN DATE
53: , p_operation_type IN NUMBER
54: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
55: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
56: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
58: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
51: , p_operation_seq_num IN NUMBER
52: , p_effectivity_date IN DATE
53: , p_operation_type IN NUMBER
54: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
55: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
56: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
58: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
59: , x_return_status IN OUT NOCOPY VARCHAR2
52: , p_effectivity_date IN DATE
53: , p_operation_type IN NUMBER
54: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
55: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
56: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
58: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
59: , x_return_status IN OUT NOCOPY VARCHAR2
60: )
53: , p_operation_type IN NUMBER
54: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
55: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
56: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
58: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
59: , x_return_status IN OUT NOCOPY VARCHAR2
60: )
61:
61:
62: IS
63:
64: /* Exposed and Unexposed record */
65: l_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;
66: l_op_res_unexp_rec Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type ;
67: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
68: l_old_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;
69: l_old_op_res_unexp_rec Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type ;
62: IS
63:
64: /* Exposed and Unexposed record */
65: l_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;
66: l_op_res_unexp_rec Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type ;
67: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
68: l_old_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;
69: l_old_op_res_unexp_rec Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type ;
70:
63:
64: /* Exposed and Unexposed record */
65: l_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;
66: l_op_res_unexp_rec Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type ;
67: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
68: l_old_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;
69: l_old_op_res_unexp_rec Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type ;
70:
71: /* Other Entities */
64: /* Exposed and Unexposed record */
65: l_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;
66: l_op_res_unexp_rec Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type ;
67: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
68: l_old_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;
69: l_old_op_res_unexp_rec Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type ;
70:
71: /* Other Entities */
72: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
65: l_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;
66: l_op_res_unexp_rec Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type ;
67: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
68: l_old_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;
69: l_old_op_res_unexp_rec Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type ;
70:
71: /* Other Entities */
72: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
73: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
68: l_old_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;
69: l_old_op_res_unexp_rec Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type ;
70:
71: /* Other Entities */
72: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
73: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
74: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
75: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type := p_sub_resource_tbl ;
76: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
69: l_old_op_res_unexp_rec Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type ;
70:
71: /* Other Entities */
72: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
73: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
74: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
75: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type := p_sub_resource_tbl ;
76: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
77:
70:
71: /* Other Entities */
72: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
73: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
74: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
75: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type := p_sub_resource_tbl ;
76: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
77:
78: /* Error Handling Variables */
71: /* Other Entities */
72: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
73: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
74: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
75: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type := p_sub_resource_tbl ;
76: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
77:
78: /* Error Handling Variables */
79: l_token_tbl Error_Handler.Token_Tbl_Type ;
72: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
73: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
74: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
75: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type := p_sub_resource_tbl ;
76: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
77:
78: /* Error Handling Variables */
79: l_token_tbl Error_Handler.Token_Tbl_Type ;
80: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type ;
478:
479: ELSIF l_return_status ='S' AND l_mesg_token_tbl .COUNT <>0
480: THEN
481: /*
482: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
483: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
484: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
485: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
486: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
479: ELSIF l_return_status ='S' AND l_mesg_token_tbl .COUNT <>0
480: THEN
481: /*
482: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
483: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
484: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
485: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
486: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
487: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
480: THEN
481: /*
482: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
483: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
484: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
485: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
486: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
487: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
488: */
481: /*
482: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
483: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
484: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
485: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
486: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
487: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
488: */
489:
482: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
483: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
484: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
485: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
486: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
487: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
488: */
489:
490: Bom_Rtg_Error_Handler.Log_Error
483: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
484: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
485: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
486: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
487: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
488: */
489:
490: Bom_Rtg_Error_Handler.Log_Error
491: (
488: */
489:
490: Bom_Rtg_Error_Handler.Log_Error
491: (
492: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
493: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
494: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
495: , p_op_resource_tbl => l_op_resource_tbl
496: , p_sub_resource_tbl => l_sub_resource_tbl
489:
490: Bom_Rtg_Error_Handler.Log_Error
491: (
492: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
493: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
494: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
495: , p_op_resource_tbl => l_op_resource_tbl
496: , p_sub_resource_tbl => l_sub_resource_tbl
497: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
490: Bom_Rtg_Error_Handler.Log_Error
491: (
492: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
493: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
494: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
495: , p_op_resource_tbl => l_op_resource_tbl
496: , p_sub_resource_tbl => l_sub_resource_tbl
497: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
498: , p_mesg_token_tbl => l_mesg_token_tbl
493: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
494: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
495: , p_op_resource_tbl => l_op_resource_tbl
496: , p_sub_resource_tbl => l_sub_resource_tbl
497: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
498: , p_mesg_token_tbl => l_mesg_token_tbl
499: , p_error_status => 'W'
500: , p_error_scope => NULL
501: , p_error_level => Error_Handler.G_RES_LEVEL
595: ELSIF l_return_status ='S' AND l_mesg_token_tbl .COUNT <> 0
596: THEN
597: Bom_Rtg_Error_Handler.Log_Error
598: (
599: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
600: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
601: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
602: , p_op_resource_tbl => l_op_resource_tbl
603: , p_sub_resource_tbl => l_sub_resource_tbl
596: THEN
597: Bom_Rtg_Error_Handler.Log_Error
598: (
599: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
600: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
601: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
602: , p_op_resource_tbl => l_op_resource_tbl
603: , p_sub_resource_tbl => l_sub_resource_tbl
604: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
597: Bom_Rtg_Error_Handler.Log_Error
598: (
599: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
600: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
601: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
602: , p_op_resource_tbl => l_op_resource_tbl
603: , p_sub_resource_tbl => l_sub_resource_tbl
604: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
605: , p_mesg_token_tbl => l_mesg_token_tbl
600: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
601: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
602: , p_op_resource_tbl => l_op_resource_tbl
603: , p_sub_resource_tbl => l_sub_resource_tbl
604: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
605: , p_mesg_token_tbl => l_mesg_token_tbl
606: , p_error_status => 'W'
607: , p_error_scope => NULL
608: , p_other_message => NULL
686: ELSIF l_return_status ='S' AND l_mesg_token_tbl .COUNT <> 0
687: THEN
688: Bom_Rtg_Error_Handler.Log_Error
689: (
690: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
691: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
692: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
693: , p_op_resource_tbl => l_op_resource_tbl
694: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
687: THEN
688: Bom_Rtg_Error_Handler.Log_Error
689: (
690: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
691: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
692: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
693: , p_op_resource_tbl => l_op_resource_tbl
694: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
695: , p_sub_resource_tbl => l_sub_resource_tbl
688: Bom_Rtg_Error_Handler.Log_Error
689: (
690: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
691: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
692: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
693: , p_op_resource_tbl => l_op_resource_tbl
694: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
695: , p_sub_resource_tbl => l_sub_resource_tbl
696: , p_mesg_token_tbl => l_mesg_token_tbl
690: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
691: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
692: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
693: , p_op_resource_tbl => l_op_resource_tbl
694: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
695: , p_sub_resource_tbl => l_sub_resource_tbl
696: , p_mesg_token_tbl => l_mesg_token_tbl
697: , p_error_status => 'W'
698: , p_error_scope => NULL
754: RAISE EXC_UNEXP_SKIP_OBJECT ;
755: ELSIF l_return_status ='S' AND l_mesg_token_tbl .COUNT <> 0
756: THEN
757: Bom_Rtg_Error_Handler.Log_Error
758: ( p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
759: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
760: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
761: , p_op_resource_tbl => l_op_resource_tbl
762: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
755: ELSIF l_return_status ='S' AND l_mesg_token_tbl .COUNT <> 0
756: THEN
757: Bom_Rtg_Error_Handler.Log_Error
758: ( p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
759: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
760: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
761: , p_op_resource_tbl => l_op_resource_tbl
762: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
763: , p_sub_resource_tbl => l_sub_resource_tbl
756: THEN
757: Bom_Rtg_Error_Handler.Log_Error
758: ( p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
759: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
760: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
761: , p_op_resource_tbl => l_op_resource_tbl
762: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
763: , p_sub_resource_tbl => l_sub_resource_tbl
764: , p_mesg_token_tbl => l_mesg_token_tbl
758: ( p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
759: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
760: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
761: , p_op_resource_tbl => l_op_resource_tbl
762: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
763: , p_sub_resource_tbl => l_sub_resource_tbl
764: , p_mesg_token_tbl => l_mesg_token_tbl
765: , p_error_status => 'W'
766: , p_error_scope => NULL
823: ELSIF l_return_status ='S' AND l_mesg_token_tbl .COUNT <> 0
824: THEN
825: Bom_Rtg_Error_Handler.Log_Error
826: (
827: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
828: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
829: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
830: , p_op_resource_tbl => l_op_resource_tbl
831: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
824: THEN
825: Bom_Rtg_Error_Handler.Log_Error
826: (
827: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
828: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
829: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
830: , p_op_resource_tbl => l_op_resource_tbl
831: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
832: , p_sub_resource_tbl => l_sub_resource_tbl
825: Bom_Rtg_Error_Handler.Log_Error
826: (
827: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
828: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
829: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
830: , p_op_resource_tbl => l_op_resource_tbl
831: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
832: , p_sub_resource_tbl => l_sub_resource_tbl
833: , p_mesg_token_tbl => l_mesg_token_tbl
827: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
828: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
829: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
830: , p_op_resource_tbl => l_op_resource_tbl
831: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
832: , p_sub_resource_tbl => l_sub_resource_tbl
833: , p_mesg_token_tbl => l_mesg_token_tbl
834: , p_error_status => 'W'
835: , p_error_scope => NULL
887: RAISE EXC_UNEXP_SKIP_OBJECT ;
888: ELSIF l_return_status ='S' AND l_mesg_token_tbl .COUNT <> 0
889: THEN
890: Bom_Rtg_Error_Handler.Log_Error
891: ( p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
892: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
893: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
894: , p_op_resource_tbl => l_op_resource_tbl
895: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
888: ELSIF l_return_status ='S' AND l_mesg_token_tbl .COUNT <> 0
889: THEN
890: Bom_Rtg_Error_Handler.Log_Error
891: ( p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
892: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
893: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
894: , p_op_resource_tbl => l_op_resource_tbl
895: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
896: , p_sub_resource_tbl => l_sub_resource_tbl
889: THEN
890: Bom_Rtg_Error_Handler.Log_Error
891: ( p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
892: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
893: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
894: , p_op_resource_tbl => l_op_resource_tbl
895: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
896: , p_sub_resource_tbl => l_sub_resource_tbl
897: , p_mesg_token_tbl => l_mesg_token_tbl
891: ( p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
892: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
893: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
894: , p_op_resource_tbl => l_op_resource_tbl
895: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
896: , p_sub_resource_tbl => l_sub_resource_tbl
897: , p_mesg_token_tbl => l_mesg_token_tbl
898: , p_error_status => 'W'
899: , p_error_scope => NULL
938: ELSIF l_return_status ='S' AND
939: l_mesg_token_tbl .COUNT <>0
940: THEN
941: Bom_Rtg_Error_Handler.Log_Error
942: ( p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
943: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
944: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
945: , p_op_resource_tbl => l_op_resource_tbl
946: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
939: l_mesg_token_tbl .COUNT <>0
940: THEN
941: Bom_Rtg_Error_Handler.Log_Error
942: ( p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
943: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
944: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
945: , p_op_resource_tbl => l_op_resource_tbl
946: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
947: , p_sub_resource_tbl => l_sub_resource_tbl
940: THEN
941: Bom_Rtg_Error_Handler.Log_Error
942: ( p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
943: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
944: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
945: , p_op_resource_tbl => l_op_resource_tbl
946: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
947: , p_sub_resource_tbl => l_sub_resource_tbl
948: , p_mesg_token_tbl => l_mesg_token_tbl
942: ( p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
943: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
944: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
945: , p_op_resource_tbl => l_op_resource_tbl
946: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
947: , p_sub_resource_tbl => l_sub_resource_tbl
948: , p_mesg_token_tbl => l_mesg_token_tbl
949: , p_error_status => 'W'
950: , p_error_scope => NULL
993:
994: EXCEPTION
995: WHEN EXC_SEV_QUIT_RECORD THEN
996: Bom_Rtg_Error_Handler.Log_Error
997: ( p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
998: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
999: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1000: , p_op_resource_tbl => l_op_resource_tbl
1001: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
994: EXCEPTION
995: WHEN EXC_SEV_QUIT_RECORD THEN
996: Bom_Rtg_Error_Handler.Log_Error
997: ( p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
998: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
999: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1000: , p_op_resource_tbl => l_op_resource_tbl
1001: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1002: , p_sub_resource_tbl => l_sub_resource_tbl
995: WHEN EXC_SEV_QUIT_RECORD THEN
996: Bom_Rtg_Error_Handler.Log_Error
997: ( p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
998: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
999: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1000: , p_op_resource_tbl => l_op_resource_tbl
1001: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1002: , p_sub_resource_tbl => l_sub_resource_tbl
1003: , p_mesg_token_tbl => l_mesg_token_tbl
997: ( p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
998: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
999: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1000: , p_op_resource_tbl => l_op_resource_tbl
1001: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1002: , p_sub_resource_tbl => l_sub_resource_tbl
1003: , p_mesg_token_tbl => l_mesg_token_tbl
1004: , p_error_status => Error_Handler.G_STATUS_ERROR
1005: , p_error_scope => Error_Handler.G_SCOPE_RECORD
1032: WHEN EXC_SEV_QUIT_BRANCH THEN
1033:
1034: Bom_Rtg_Error_Handler.Log_Error
1035: (
1036: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1037: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1038: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1039: , p_op_resource_tbl => l_op_resource_tbl
1040: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1033:
1034: Bom_Rtg_Error_Handler.Log_Error
1035: (
1036: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1037: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1038: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1039: , p_op_resource_tbl => l_op_resource_tbl
1040: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1041: , p_sub_resource_tbl => l_sub_resource_tbl
1034: Bom_Rtg_Error_Handler.Log_Error
1035: (
1036: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1037: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1038: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1039: , p_op_resource_tbl => l_op_resource_tbl
1040: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1041: , p_sub_resource_tbl => l_sub_resource_tbl
1042: , p_mesg_token_tbl => l_mesg_token_tbl
1036: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1037: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1038: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1039: , p_op_resource_tbl => l_op_resource_tbl
1040: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1041: , p_sub_resource_tbl => l_sub_resource_tbl
1042: , p_mesg_token_tbl => l_mesg_token_tbl
1043: , p_error_status => Error_Handler.G_STATUS_ERROR
1044: , p_error_scope => Error_Handler.G_SCOPE_CHILDREN
1069:
1070: WHEN EXC_SEV_SKIP_BRANCH THEN
1071: Bom_Rtg_Error_Handler.Log_Error
1072: (
1073: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1074: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1075: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1076: , p_op_resource_tbl => l_op_resource_tbl
1077: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1070: WHEN EXC_SEV_SKIP_BRANCH THEN
1071: Bom_Rtg_Error_Handler.Log_Error
1072: (
1073: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1074: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1075: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1076: , p_op_resource_tbl => l_op_resource_tbl
1077: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1078: , p_sub_resource_tbl => l_sub_resource_tbl
1071: Bom_Rtg_Error_Handler.Log_Error
1072: (
1073: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1074: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1075: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1076: , p_op_resource_tbl => l_op_resource_tbl
1077: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1078: , p_sub_resource_tbl => l_sub_resource_tbl
1079: , p_mesg_token_tbl => l_mesg_token_tbl
1073: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1074: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1075: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1076: , p_op_resource_tbl => l_op_resource_tbl
1077: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1078: , p_sub_resource_tbl => l_sub_resource_tbl
1079: , p_mesg_token_tbl => l_mesg_token_tbl
1080: , p_error_status => Error_Handler.G_STATUS_ERROR
1081: , p_error_scope => Error_Handler.G_SCOPE_CHILDREN
1104:
1105: WHEN EXC_SEV_QUIT_SIBLINGS THEN
1106: Bom_Rtg_Error_Handler.Log_Error
1107: (
1108: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1109: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1110: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1111: , p_op_resource_tbl => l_op_resource_tbl
1112: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1105: WHEN EXC_SEV_QUIT_SIBLINGS THEN
1106: Bom_Rtg_Error_Handler.Log_Error
1107: (
1108: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1109: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1110: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1111: , p_op_resource_tbl => l_op_resource_tbl
1112: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1113: , p_sub_resource_tbl => l_sub_resource_tbl
1106: Bom_Rtg_Error_Handler.Log_Error
1107: (
1108: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1109: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1110: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1111: , p_op_resource_tbl => l_op_resource_tbl
1112: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1113: , p_sub_resource_tbl => l_sub_resource_tbl
1114: , p_mesg_token_tbl => l_mesg_token_tbl
1108: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1109: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1110: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1111: , p_op_resource_tbl => l_op_resource_tbl
1112: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1113: , p_sub_resource_tbl => l_sub_resource_tbl
1114: , p_mesg_token_tbl => l_mesg_token_tbl
1115: , p_error_status => Error_Handler.G_STATUS_ERROR
1116: , p_error_scope => Error_Handler.G_SCOPE_SIBLINGS
1140:
1141: WHEN EXC_FAT_QUIT_BRANCH THEN
1142: Bom_Rtg_Error_Handler.Log_Error
1143: (
1144: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1145: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1146: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1147: , p_op_resource_tbl => l_op_resource_tbl
1148: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1141: WHEN EXC_FAT_QUIT_BRANCH THEN
1142: Bom_Rtg_Error_Handler.Log_Error
1143: (
1144: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1145: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1146: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1147: , p_op_resource_tbl => l_op_resource_tbl
1148: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1149: , p_sub_resource_tbl => l_sub_resource_tbl
1142: Bom_Rtg_Error_Handler.Log_Error
1143: (
1144: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1145: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1146: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1147: , p_op_resource_tbl => l_op_resource_tbl
1148: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1149: , p_sub_resource_tbl => l_sub_resource_tbl
1150: , p_mesg_token_tbl => l_mesg_token_tbl
1144: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1145: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1146: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1147: , p_op_resource_tbl => l_op_resource_tbl
1148: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1149: , p_sub_resource_tbl => l_sub_resource_tbl
1150: , p_mesg_token_tbl => l_mesg_token_tbl
1151: , p_error_status => Error_Handler.G_STATUS_FATAL
1152: , p_error_scope => Error_Handler.G_SCOPE_CHILDREN
1172:
1173: WHEN EXC_FAT_QUIT_SIBLINGS THEN
1174: Bom_Rtg_Error_Handler.Log_Error
1175: (
1176: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1177: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1178: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1179: , p_op_resource_tbl => l_op_resource_tbl
1180: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1173: WHEN EXC_FAT_QUIT_SIBLINGS THEN
1174: Bom_Rtg_Error_Handler.Log_Error
1175: (
1176: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1177: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1178: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1179: , p_op_resource_tbl => l_op_resource_tbl
1180: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1181: , p_sub_resource_tbl => l_sub_resource_tbl
1174: Bom_Rtg_Error_Handler.Log_Error
1175: (
1176: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1177: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1178: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1179: , p_op_resource_tbl => l_op_resource_tbl
1180: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1181: , p_sub_resource_tbl => l_sub_resource_tbl
1182: , p_mesg_token_tbl => l_mesg_token_tbl
1176: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1177: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1178: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1179: , p_op_resource_tbl => l_op_resource_tbl
1180: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1181: , p_sub_resource_tbl => l_sub_resource_tbl
1182: , p_mesg_token_tbl => l_mesg_token_tbl
1183: , p_error_status => Error_Handler.G_STATUS_FATAL
1184: , p_error_scope => Error_Handler.G_SCOPE_SIBLINGS
1230:
1231: WHEN EXC_UNEXP_SKIP_OBJECT THEN
1232: Bom_Rtg_Error_Handler.Log_Error
1233: (
1234: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1235: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1236: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1237: , p_op_resource_tbl => l_op_resource_tbl
1238: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1231: WHEN EXC_UNEXP_SKIP_OBJECT THEN
1232: Bom_Rtg_Error_Handler.Log_Error
1233: (
1234: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1235: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1236: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1237: , p_op_resource_tbl => l_op_resource_tbl
1238: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1239: , p_sub_resource_tbl => l_sub_resource_tbl
1232: Bom_Rtg_Error_Handler.Log_Error
1233: (
1234: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1235: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1236: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1237: , p_op_resource_tbl => l_op_resource_tbl
1238: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1239: , p_sub_resource_tbl => l_sub_resource_tbl
1240: , p_mesg_token_tbl => l_mesg_token_tbl
1234: p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1235: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1236: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1237: , p_op_resource_tbl => l_op_resource_tbl
1238: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1239: , p_sub_resource_tbl => l_sub_resource_tbl
1240: , p_mesg_token_tbl => l_mesg_token_tbl
1241: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1242: , p_error_scope => NULL
1301: , p_alternate_routing_code IN VARCHAR2 := NULL
1302: , p_operation_seq_num IN NUMBER := NULL
1303: , p_effectivity_date IN DATE := NULL
1304: , p_operation_type IN NUMBER := NULL
1305: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1306: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1307: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1308: , x_return_status IN OUT NOCOPY VARCHAR2
1309: )
1302: , p_operation_seq_num IN NUMBER := NULL
1303: , p_effectivity_date IN DATE := NULL
1304: , p_operation_type IN NUMBER := NULL
1305: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1306: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1307: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1308: , x_return_status IN OUT NOCOPY VARCHAR2
1309: )
1310:
1310:
1311: IS
1312:
1313: /* Exposed and Unexposed record */
1314: l_sub_resource_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type ;
1315: l_sub_res_unexp_rec Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type ;
1316: l_old_sub_resource_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type ;
1317: l_old_sub_res_unexp_rec Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type ;
1318:
1311: IS
1312:
1313: /* Exposed and Unexposed record */
1314: l_sub_resource_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type ;
1315: l_sub_res_unexp_rec Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type ;
1316: l_old_sub_resource_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type ;
1317: l_old_sub_res_unexp_rec Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type ;
1318:
1319: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
1312:
1313: /* Exposed and Unexposed record */
1314: l_sub_resource_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type ;
1315: l_sub_res_unexp_rec Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type ;
1316: l_old_sub_resource_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type ;
1317: l_old_sub_res_unexp_rec Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type ;
1318:
1319: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
1320:
1313: /* Exposed and Unexposed record */
1314: l_sub_resource_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type ;
1315: l_sub_res_unexp_rec Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type ;
1316: l_old_sub_resource_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type ;
1317: l_old_sub_res_unexp_rec Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type ;
1318:
1319: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
1320:
1321: /* Other Entities */
1315: l_sub_res_unexp_rec Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type ;
1316: l_old_sub_resource_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type ;
1317: l_old_sub_res_unexp_rec Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type ;
1318:
1319: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
1320:
1321: /* Other Entities */
1322: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
1323: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
1318:
1319: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
1320:
1321: /* Other Entities */
1322: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
1323: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
1324: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
1325: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
1326: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
1319: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
1320:
1321: /* Other Entities */
1322: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
1323: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
1324: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
1325: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
1326: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
1327:
1320:
1321: /* Other Entities */
1322: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
1323: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
1324: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
1325: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
1326: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
1327:
1328: /* Error Handling Variables */
1321: /* Other Entities */
1322: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
1323: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
1324: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
1325: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
1326: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
1327:
1328: /* Error Handling Variables */
1329: l_token_tbl Error_Handler.Token_Tbl_Type ;
1322: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
1323: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
1324: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
1325: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
1326: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
1327:
1328: /* Error Handling Variables */
1329: l_token_tbl Error_Handler.Token_Tbl_Type ;
1330: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type ;
1811: THEN
1812: Bom_Rtg_Error_Handler.Log_Error
1813: (
1814: p_sub_resource_tbl => l_sub_resource_tbl
1815: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1816: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1817: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1818: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
1819: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1812: Bom_Rtg_Error_Handler.Log_Error
1813: (
1814: p_sub_resource_tbl => l_sub_resource_tbl
1815: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1816: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1817: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1818: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
1819: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1820: , p_mesg_token_tbl => l_mesg_token_tbl
1813: (
1814: p_sub_resource_tbl => l_sub_resource_tbl
1815: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1816: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1817: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1818: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
1819: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1820: , p_mesg_token_tbl => l_mesg_token_tbl
1821: , p_error_status => 'W'
1814: p_sub_resource_tbl => l_sub_resource_tbl
1815: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1816: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1817: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1818: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
1819: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1820: , p_mesg_token_tbl => l_mesg_token_tbl
1821: , p_error_status => 'W'
1822: , p_error_level => Error_Handler.G_SR_LEVEL
1815: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1816: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1817: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1818: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
1819: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1820: , p_mesg_token_tbl => l_mesg_token_tbl
1821: , p_error_status => 'W'
1822: , p_error_level => Error_Handler.G_SR_LEVEL
1823: , p_entity_index => I
1929: ELSIF l_return_status ='S' AND l_mesg_token_tbl .COUNT <> 0
1930: THEN
1931: Bom_Rtg_Error_Handler.Log_Error
1932: ( p_sub_resource_tbl => l_sub_resource_tbl
1933: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1934: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1935: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1936: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
1937: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1930: THEN
1931: Bom_Rtg_Error_Handler.Log_Error
1932: ( p_sub_resource_tbl => l_sub_resource_tbl
1933: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1934: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1935: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1936: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
1937: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1938: , p_mesg_token_tbl => l_mesg_token_tbl
1931: Bom_Rtg_Error_Handler.Log_Error
1932: ( p_sub_resource_tbl => l_sub_resource_tbl
1933: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1934: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1935: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1936: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
1937: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1938: , p_mesg_token_tbl => l_mesg_token_tbl
1939: , p_error_status => 'W'
1932: ( p_sub_resource_tbl => l_sub_resource_tbl
1933: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1934: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1935: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1936: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
1937: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1938: , p_mesg_token_tbl => l_mesg_token_tbl
1939: , p_error_status => 'W'
1940: , p_error_level => Error_Handler.G_SR_LEVEL
1933: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1934: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1935: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1936: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
1937: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1938: , p_mesg_token_tbl => l_mesg_token_tbl
1939: , p_error_status => 'W'
1940: , p_error_level => Error_Handler.G_SR_LEVEL
1941: , p_entity_index => I
2020: ELSIF l_return_status ='S' AND l_mesg_token_tbl .COUNT <> 0
2021: THEN
2022: Bom_Rtg_Error_Handler.Log_Error
2023: ( p_sub_resource_tbl => l_sub_resource_tbl
2024: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2025: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2026: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2027: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2028: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2021: THEN
2022: Bom_Rtg_Error_Handler.Log_Error
2023: ( p_sub_resource_tbl => l_sub_resource_tbl
2024: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2025: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2026: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2027: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2028: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2029: , p_mesg_token_tbl => l_mesg_token_tbl
2022: Bom_Rtg_Error_Handler.Log_Error
2023: ( p_sub_resource_tbl => l_sub_resource_tbl
2024: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2025: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2026: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2027: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2028: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2029: , p_mesg_token_tbl => l_mesg_token_tbl
2030: , p_error_status => 'W'
2023: ( p_sub_resource_tbl => l_sub_resource_tbl
2024: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2025: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2026: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2027: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2028: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2029: , p_mesg_token_tbl => l_mesg_token_tbl
2030: , p_error_status => 'W'
2031: , p_error_level => Error_Handler.G_SR_LEVEL
2024: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2025: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2026: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2027: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2028: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2029: , p_mesg_token_tbl => l_mesg_token_tbl
2030: , p_error_status => 'W'
2031: , p_error_level => Error_Handler.G_SR_LEVEL
2032: , p_entity_index => I
2095: ELSIF l_return_status ='S' AND l_mesg_token_tbl .COUNT <> 0
2096: THEN
2097: Bom_Rtg_Error_Handler.Log_Error
2098: ( p_sub_resource_tbl => l_sub_resource_tbl
2099: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2100: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2101: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2102: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2103: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2096: THEN
2097: Bom_Rtg_Error_Handler.Log_Error
2098: ( p_sub_resource_tbl => l_sub_resource_tbl
2099: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2100: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2101: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2102: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2103: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2104: , p_mesg_token_tbl => l_mesg_token_tbl
2097: Bom_Rtg_Error_Handler.Log_Error
2098: ( p_sub_resource_tbl => l_sub_resource_tbl
2099: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2100: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2101: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2102: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2103: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2104: , p_mesg_token_tbl => l_mesg_token_tbl
2105: , p_error_status => 'W'
2098: ( p_sub_resource_tbl => l_sub_resource_tbl
2099: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2100: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2101: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2102: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2103: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2104: , p_mesg_token_tbl => l_mesg_token_tbl
2105: , p_error_status => 'W'
2106: , p_error_level => Error_Handler.G_SR_LEVEL
2099: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2100: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2101: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2102: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2103: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2104: , p_mesg_token_tbl => l_mesg_token_tbl
2105: , p_error_status => 'W'
2106: , p_error_level => Error_Handler.G_SR_LEVEL
2107: , p_entity_index => I
2169: ELSIF l_return_status ='S' AND l_mesg_token_tbl .COUNT <> 0
2170: THEN
2171: Bom_Rtg_Error_Handler.Log_Error
2172: ( p_sub_resource_tbl => l_sub_resource_tbl
2173: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2174: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2175: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2176: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2177: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2170: THEN
2171: Bom_Rtg_Error_Handler.Log_Error
2172: ( p_sub_resource_tbl => l_sub_resource_tbl
2173: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2174: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2175: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2176: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2177: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2178: , p_mesg_token_tbl => l_mesg_token_tbl
2171: Bom_Rtg_Error_Handler.Log_Error
2172: ( p_sub_resource_tbl => l_sub_resource_tbl
2173: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2174: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2175: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2176: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2177: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2178: , p_mesg_token_tbl => l_mesg_token_tbl
2179: , p_error_status => 'W'
2172: ( p_sub_resource_tbl => l_sub_resource_tbl
2173: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2174: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2175: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2176: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2177: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2178: , p_mesg_token_tbl => l_mesg_token_tbl
2179: , p_error_status => 'W'
2180: , p_error_level => Error_Handler.G_SR_LEVEL
2173: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2174: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2175: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2176: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2177: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2178: , p_mesg_token_tbl => l_mesg_token_tbl
2179: , p_error_status => 'W'
2180: , p_error_level => Error_Handler.G_SR_LEVEL
2181: , p_entity_index => I
2239: ELSIF l_return_status ='S' AND l_mesg_token_tbl .COUNT <> 0
2240: THEN
2241: Bom_Rtg_Error_Handler.Log_Error
2242: ( p_sub_resource_tbl => l_sub_resource_tbl
2243: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2244: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2245: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2246: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2247: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2240: THEN
2241: Bom_Rtg_Error_Handler.Log_Error
2242: ( p_sub_resource_tbl => l_sub_resource_tbl
2243: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2244: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2245: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2246: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2247: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2248: , p_mesg_token_tbl => l_mesg_token_tbl
2241: Bom_Rtg_Error_Handler.Log_Error
2242: ( p_sub_resource_tbl => l_sub_resource_tbl
2243: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2244: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2245: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2246: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2247: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2248: , p_mesg_token_tbl => l_mesg_token_tbl
2249: , p_error_status => 'W'
2242: ( p_sub_resource_tbl => l_sub_resource_tbl
2243: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2244: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2245: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2246: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2247: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2248: , p_mesg_token_tbl => l_mesg_token_tbl
2249: , p_error_status => 'W'
2250: , p_error_level => Error_Handler.G_SR_LEVEL
2243: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2244: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2245: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2246: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2247: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2248: , p_mesg_token_tbl => l_mesg_token_tbl
2249: , p_error_status => 'W'
2250: , p_error_level => Error_Handler.G_SR_LEVEL
2251: , p_entity_index => I
2292: l_mesg_token_tbl .COUNT <>0
2293: THEN
2294: Bom_Rtg_Error_Handler.Log_Error
2295: ( p_sub_resource_tbl => l_sub_resource_tbl
2296: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2297: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2298: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2299: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2300: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2293: THEN
2294: Bom_Rtg_Error_Handler.Log_Error
2295: ( p_sub_resource_tbl => l_sub_resource_tbl
2296: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2297: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2298: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2299: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2300: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2301: , p_mesg_token_tbl => l_mesg_token_tbl
2294: Bom_Rtg_Error_Handler.Log_Error
2295: ( p_sub_resource_tbl => l_sub_resource_tbl
2296: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2297: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2298: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2299: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2300: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2301: , p_mesg_token_tbl => l_mesg_token_tbl
2302: , p_error_status => 'W'
2295: ( p_sub_resource_tbl => l_sub_resource_tbl
2296: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2297: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2298: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2299: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2300: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2301: , p_mesg_token_tbl => l_mesg_token_tbl
2302: , p_error_status => 'W'
2303: , p_error_level => Error_Handler.G_SR_LEVEL
2296: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2297: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2298: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2299: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2300: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2301: , p_mesg_token_tbl => l_mesg_token_tbl
2302: , p_error_status => 'W'
2303: , p_error_level => Error_Handler.G_SR_LEVEL
2304: , p_entity_index => I
2348: EXCEPTION
2349: WHEN EXC_SEV_QUIT_RECORD THEN
2350: Bom_Rtg_Error_Handler.Log_Error
2351: ( p_sub_resource_tbl => l_sub_resource_tbl
2352: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2353: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2354: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2355: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2356: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2349: WHEN EXC_SEV_QUIT_RECORD THEN
2350: Bom_Rtg_Error_Handler.Log_Error
2351: ( p_sub_resource_tbl => l_sub_resource_tbl
2352: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2353: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2354: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2355: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2356: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2357: , p_mesg_token_tbl => l_mesg_token_tbl
2350: Bom_Rtg_Error_Handler.Log_Error
2351: ( p_sub_resource_tbl => l_sub_resource_tbl
2352: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2353: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2354: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2355: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2356: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2357: , p_mesg_token_tbl => l_mesg_token_tbl
2358: , p_error_status => Error_Handler.G_STATUS_ERROR
2351: ( p_sub_resource_tbl => l_sub_resource_tbl
2352: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2353: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2354: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2355: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2356: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2357: , p_mesg_token_tbl => l_mesg_token_tbl
2358: , p_error_status => Error_Handler.G_STATUS_ERROR
2359: , p_error_scope => Error_Handler.G_SCOPE_RECORD
2352: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2353: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2354: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2355: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2356: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2357: , p_mesg_token_tbl => l_mesg_token_tbl
2358: , p_error_status => Error_Handler.G_STATUS_ERROR
2359: , p_error_scope => Error_Handler.G_SCOPE_RECORD
2360: , p_error_level => Error_Handler.G_SR_LEVEL
2385: WHEN EXC_SEV_QUIT_BRANCH THEN
2386:
2387: Bom_Rtg_Error_Handler.Log_Error
2388: ( p_sub_resource_tbl => l_sub_resource_tbl
2389: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2390: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2391: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2392: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2393: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2386:
2387: Bom_Rtg_Error_Handler.Log_Error
2388: ( p_sub_resource_tbl => l_sub_resource_tbl
2389: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2390: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2391: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2392: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2393: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2394: , p_mesg_token_tbl => l_mesg_token_tbl
2387: Bom_Rtg_Error_Handler.Log_Error
2388: ( p_sub_resource_tbl => l_sub_resource_tbl
2389: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2390: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2391: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2392: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2393: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2394: , p_mesg_token_tbl => l_mesg_token_tbl
2395: , p_error_status => Error_Handler.G_STATUS_ERROR
2388: ( p_sub_resource_tbl => l_sub_resource_tbl
2389: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2390: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2391: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2392: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2393: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2394: , p_mesg_token_tbl => l_mesg_token_tbl
2395: , p_error_status => Error_Handler.G_STATUS_ERROR
2396: , p_error_scope => Error_Handler.G_SCOPE_CHILDREN
2389: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2390: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2391: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2392: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2393: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2394: , p_mesg_token_tbl => l_mesg_token_tbl
2395: , p_error_status => Error_Handler.G_STATUS_ERROR
2396: , p_error_scope => Error_Handler.G_SCOPE_CHILDREN
2397: , p_other_status => Error_Handler.G_STATUS_ERROR
2420:
2421: WHEN EXC_SEV_SKIP_BRANCH THEN
2422: Bom_Rtg_Error_Handler.Log_Error
2423: ( p_sub_resource_tbl => l_sub_resource_tbl
2424: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2425: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2426: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2427: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2428: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2421: WHEN EXC_SEV_SKIP_BRANCH THEN
2422: Bom_Rtg_Error_Handler.Log_Error
2423: ( p_sub_resource_tbl => l_sub_resource_tbl
2424: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2425: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2426: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2427: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2428: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2429: , p_mesg_token_tbl => l_mesg_token_tbl
2422: Bom_Rtg_Error_Handler.Log_Error
2423: ( p_sub_resource_tbl => l_sub_resource_tbl
2424: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2425: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2426: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2427: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2428: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2429: , p_mesg_token_tbl => l_mesg_token_tbl
2430: , p_error_status => Error_Handler.G_STATUS_ERROR
2423: ( p_sub_resource_tbl => l_sub_resource_tbl
2424: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2425: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2426: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2427: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2428: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2429: , p_mesg_token_tbl => l_mesg_token_tbl
2430: , p_error_status => Error_Handler.G_STATUS_ERROR
2431: , p_error_scope => Error_Handler.G_SCOPE_CHILDREN
2424: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2425: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2426: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2427: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2428: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2429: , p_mesg_token_tbl => l_mesg_token_tbl
2430: , p_error_status => Error_Handler.G_STATUS_ERROR
2431: , p_error_scope => Error_Handler.G_SCOPE_CHILDREN
2432: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
2453:
2454: WHEN EXC_SEV_QUIT_SIBLINGS THEN
2455: Bom_Rtg_Error_Handler.Log_Error
2456: ( p_sub_resource_tbl => l_sub_resource_tbl
2457: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2458: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2459: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2460: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2461: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2454: WHEN EXC_SEV_QUIT_SIBLINGS THEN
2455: Bom_Rtg_Error_Handler.Log_Error
2456: ( p_sub_resource_tbl => l_sub_resource_tbl
2457: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2458: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2459: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2460: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2461: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2462: , p_mesg_token_tbl => l_mesg_token_tbl
2455: Bom_Rtg_Error_Handler.Log_Error
2456: ( p_sub_resource_tbl => l_sub_resource_tbl
2457: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2458: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2459: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2460: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2461: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2462: , p_mesg_token_tbl => l_mesg_token_tbl
2463: , p_error_status => Error_Handler.G_STATUS_ERROR
2456: ( p_sub_resource_tbl => l_sub_resource_tbl
2457: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2458: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2459: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2460: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2461: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2462: , p_mesg_token_tbl => l_mesg_token_tbl
2463: , p_error_status => Error_Handler.G_STATUS_ERROR
2464: , p_error_scope => Error_Handler.G_SCOPE_SIBLINGS
2457: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2458: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2459: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2460: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2461: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2462: , p_mesg_token_tbl => l_mesg_token_tbl
2463: , p_error_status => Error_Handler.G_STATUS_ERROR
2464: , p_error_scope => Error_Handler.G_SCOPE_SIBLINGS
2465: , p_other_status => Error_Handler.G_STATUS_ERROR
2487:
2488: WHEN EXC_FAT_QUIT_BRANCH THEN
2489: Bom_Rtg_Error_Handler.Log_Error
2490: ( p_sub_resource_tbl => l_sub_resource_tbl
2491: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2492: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2493: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2494: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2495: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2488: WHEN EXC_FAT_QUIT_BRANCH THEN
2489: Bom_Rtg_Error_Handler.Log_Error
2490: ( p_sub_resource_tbl => l_sub_resource_tbl
2491: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2492: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2493: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2494: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2495: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2496: , p_mesg_token_tbl => l_mesg_token_tbl
2489: Bom_Rtg_Error_Handler.Log_Error
2490: ( p_sub_resource_tbl => l_sub_resource_tbl
2491: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2492: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2493: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2494: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2495: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2496: , p_mesg_token_tbl => l_mesg_token_tbl
2497: , p_error_status => Error_Handler.G_STATUS_FATAL
2490: ( p_sub_resource_tbl => l_sub_resource_tbl
2491: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2492: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2493: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2494: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2495: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2496: , p_mesg_token_tbl => l_mesg_token_tbl
2497: , p_error_status => Error_Handler.G_STATUS_FATAL
2498: , p_error_scope => Error_Handler.G_SCOPE_CHILDREN
2491: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2492: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2493: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2494: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2495: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2496: , p_mesg_token_tbl => l_mesg_token_tbl
2497: , p_error_status => Error_Handler.G_STATUS_FATAL
2498: , p_error_scope => Error_Handler.G_SCOPE_CHILDREN
2499: , p_other_status => Error_Handler.G_STATUS_FATAL
2517:
2518: WHEN EXC_FAT_QUIT_SIBLINGS THEN
2519: Bom_Rtg_Error_Handler.Log_Error
2520: ( p_sub_resource_tbl => l_sub_resource_tbl
2521: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2522: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2523: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2524: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2525: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2518: WHEN EXC_FAT_QUIT_SIBLINGS THEN
2519: Bom_Rtg_Error_Handler.Log_Error
2520: ( p_sub_resource_tbl => l_sub_resource_tbl
2521: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2522: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2523: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2524: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2525: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2526: , p_mesg_token_tbl => l_mesg_token_tbl
2519: Bom_Rtg_Error_Handler.Log_Error
2520: ( p_sub_resource_tbl => l_sub_resource_tbl
2521: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2522: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2523: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2524: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2525: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2526: , p_mesg_token_tbl => l_mesg_token_tbl
2527: , p_error_status => Error_Handler.G_STATUS_FATAL
2520: ( p_sub_resource_tbl => l_sub_resource_tbl
2521: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2522: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2523: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2524: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2525: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2526: , p_mesg_token_tbl => l_mesg_token_tbl
2527: , p_error_status => Error_Handler.G_STATUS_FATAL
2528: , p_error_scope => Error_Handler.G_SCOPE_SIBLINGS
2521: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2522: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2523: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2524: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2525: , p_op_network_tbl =>Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2526: , p_mesg_token_tbl => l_mesg_token_tbl
2527: , p_error_status => Error_Handler.G_STATUS_FATAL
2528: , p_error_scope => Error_Handler.G_SCOPE_SIBLINGS
2529: , p_other_status => Error_Handler.G_STATUS_FATAL
2571:
2572: WHEN EXC_UNEXP_SKIP_OBJECT THEN
2573: Bom_Rtg_Error_Handler.Log_Error
2574: ( p_sub_resource_tbl => l_sub_resource_tbl
2575: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2576: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2577: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2578: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2579: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2572: WHEN EXC_UNEXP_SKIP_OBJECT THEN
2573: Bom_Rtg_Error_Handler.Log_Error
2574: ( p_sub_resource_tbl => l_sub_resource_tbl
2575: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2576: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2577: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2578: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2579: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2580: , p_mesg_token_tbl => l_mesg_token_tbl
2573: Bom_Rtg_Error_Handler.Log_Error
2574: ( p_sub_resource_tbl => l_sub_resource_tbl
2575: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2576: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2577: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2578: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2579: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2580: , p_mesg_token_tbl => l_mesg_token_tbl
2581: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
2574: ( p_sub_resource_tbl => l_sub_resource_tbl
2575: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2576: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2577: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2578: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2579: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2580: , p_mesg_token_tbl => l_mesg_token_tbl
2581: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
2582: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
2575: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2576: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2577: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2578: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2579: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2580: , p_mesg_token_tbl => l_mesg_token_tbl
2581: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
2582: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
2583: , p_other_message => l_other_message
2637: , p_assembly_item_name IN VARCHAR2 := NULL
2638: , p_assembly_item_id IN NUMBER := NULL
2639: , p_organization_id IN NUMBER := NULL
2640: , p_alternate_rtg_code IN VARCHAR2 := NULL
2641: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
2642: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
2643: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2644: , x_return_status IN OUT NOCOPY VARCHAR2
2645: )
2638: , p_assembly_item_id IN NUMBER := NULL
2639: , p_organization_id IN NUMBER := NULL
2640: , p_alternate_rtg_code IN VARCHAR2 := NULL
2641: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
2642: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
2643: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2644: , x_return_status IN OUT NOCOPY VARCHAR2
2645: )
2646: IS
2657: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2658: l_bo_return_status VARCHAR2(1) := 'S';
2659: l_rtg_parent_exists BOOLEAN := FALSE;
2660:
2661: l_rtg_header_rec Bom_Rtg_Pub.rtg_header_Rec_Type;
2662: l_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_header_unexposed_Rec_Type;
2663: l_old_rtg_header_rec Bom_Rtg_Pub.rtg_header_Rec_Type;
2664: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
2665: l_op_network_rec Bom_Rtg_Pub.op_network_Rec_Type;
2658: l_bo_return_status VARCHAR2(1) := 'S';
2659: l_rtg_parent_exists BOOLEAN := FALSE;
2660:
2661: l_rtg_header_rec Bom_Rtg_Pub.rtg_header_Rec_Type;
2662: l_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_header_unexposed_Rec_Type;
2663: l_old_rtg_header_rec Bom_Rtg_Pub.rtg_header_Rec_Type;
2664: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
2665: l_op_network_rec Bom_Rtg_Pub.op_network_Rec_Type;
2666: l_op_network_unexp_rec Bom_Rtg_Pub.op_network_Unexposed_Rec_Type;
2659: l_rtg_parent_exists BOOLEAN := FALSE;
2660:
2661: l_rtg_header_rec Bom_Rtg_Pub.rtg_header_Rec_Type;
2662: l_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_header_unexposed_Rec_Type;
2663: l_old_rtg_header_rec Bom_Rtg_Pub.rtg_header_Rec_Type;
2664: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
2665: l_op_network_rec Bom_Rtg_Pub.op_network_Rec_Type;
2666: l_op_network_unexp_rec Bom_Rtg_Pub.op_network_Unexposed_Rec_Type;
2667: l_op_network_tbl Bom_Rtg_Pub.op_network_Tbl_Type := p_op_network_tbl;
2660:
2661: l_rtg_header_rec Bom_Rtg_Pub.rtg_header_Rec_Type;
2662: l_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_header_unexposed_Rec_Type;
2663: l_old_rtg_header_rec Bom_Rtg_Pub.rtg_header_Rec_Type;
2664: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
2665: l_op_network_rec Bom_Rtg_Pub.op_network_Rec_Type;
2666: l_op_network_unexp_rec Bom_Rtg_Pub.op_network_Unexposed_Rec_Type;
2667: l_op_network_tbl Bom_Rtg_Pub.op_network_Tbl_Type := p_op_network_tbl;
2668: l_old_op_network_rec Bom_Rtg_Pub.op_network_Rec_Type := NULL;
2661: l_rtg_header_rec Bom_Rtg_Pub.rtg_header_Rec_Type;
2662: l_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_header_unexposed_Rec_Type;
2663: l_old_rtg_header_rec Bom_Rtg_Pub.rtg_header_Rec_Type;
2664: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
2665: l_op_network_rec Bom_Rtg_Pub.op_network_Rec_Type;
2666: l_op_network_unexp_rec Bom_Rtg_Pub.op_network_Unexposed_Rec_Type;
2667: l_op_network_tbl Bom_Rtg_Pub.op_network_Tbl_Type := p_op_network_tbl;
2668: l_old_op_network_rec Bom_Rtg_Pub.op_network_Rec_Type := NULL;
2669: l_old_op_network_unexp_rec
2662: l_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_header_unexposed_Rec_Type;
2663: l_old_rtg_header_rec Bom_Rtg_Pub.rtg_header_Rec_Type;
2664: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
2665: l_op_network_rec Bom_Rtg_Pub.op_network_Rec_Type;
2666: l_op_network_unexp_rec Bom_Rtg_Pub.op_network_Unexposed_Rec_Type;
2667: l_op_network_tbl Bom_Rtg_Pub.op_network_Tbl_Type := p_op_network_tbl;
2668: l_old_op_network_rec Bom_Rtg_Pub.op_network_Rec_Type := NULL;
2669: l_old_op_network_unexp_rec
2670: Bom_Rtg_Pub.op_network_Unexposed_Rec_Type := NULL;
2663: l_old_rtg_header_rec Bom_Rtg_Pub.rtg_header_Rec_Type;
2664: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
2665: l_op_network_rec Bom_Rtg_Pub.op_network_Rec_Type;
2666: l_op_network_unexp_rec Bom_Rtg_Pub.op_network_Unexposed_Rec_Type;
2667: l_op_network_tbl Bom_Rtg_Pub.op_network_Tbl_Type := p_op_network_tbl;
2668: l_old_op_network_rec Bom_Rtg_Pub.op_network_Rec_Type := NULL;
2669: l_old_op_network_unexp_rec
2670: Bom_Rtg_Pub.op_network_Unexposed_Rec_Type := NULL;
2671: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2664: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
2665: l_op_network_rec Bom_Rtg_Pub.op_network_Rec_Type;
2666: l_op_network_unexp_rec Bom_Rtg_Pub.op_network_Unexposed_Rec_Type;
2667: l_op_network_tbl Bom_Rtg_Pub.op_network_Tbl_Type := p_op_network_tbl;
2668: l_old_op_network_rec Bom_Rtg_Pub.op_network_Rec_Type := NULL;
2669: l_old_op_network_unexp_rec
2670: Bom_Rtg_Pub.op_network_Unexposed_Rec_Type := NULL;
2671: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2672: l_operation_tbl Bom_Rtg_Pub.operation_tbl_type;
2666: l_op_network_unexp_rec Bom_Rtg_Pub.op_network_Unexposed_Rec_Type;
2667: l_op_network_tbl Bom_Rtg_Pub.op_network_Tbl_Type := p_op_network_tbl;
2668: l_old_op_network_rec Bom_Rtg_Pub.op_network_Rec_Type := NULL;
2669: l_old_op_network_unexp_rec
2670: Bom_Rtg_Pub.op_network_Unexposed_Rec_Type := NULL;
2671: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2672: l_operation_tbl Bom_Rtg_Pub.operation_tbl_type;
2673: l_op_resource_tbl Bom_Rtg_Pub.op_resource_tbl_type;
2674: l_sub_resource_tbl Bom_Rtg_Pub.sub_resource_tbl_type;
2667: l_op_network_tbl Bom_Rtg_Pub.op_network_Tbl_Type := p_op_network_tbl;
2668: l_old_op_network_rec Bom_Rtg_Pub.op_network_Rec_Type := NULL;
2669: l_old_op_network_unexp_rec
2670: Bom_Rtg_Pub.op_network_Unexposed_Rec_Type := NULL;
2671: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2672: l_operation_tbl Bom_Rtg_Pub.operation_tbl_type;
2673: l_op_resource_tbl Bom_Rtg_Pub.op_resource_tbl_type;
2674: l_sub_resource_tbl Bom_Rtg_Pub.sub_resource_tbl_type;
2675:
2668: l_old_op_network_rec Bom_Rtg_Pub.op_network_Rec_Type := NULL;
2669: l_old_op_network_unexp_rec
2670: Bom_Rtg_Pub.op_network_Unexposed_Rec_Type := NULL;
2671: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2672: l_operation_tbl Bom_Rtg_Pub.operation_tbl_type;
2673: l_op_resource_tbl Bom_Rtg_Pub.op_resource_tbl_type;
2674: l_sub_resource_tbl Bom_Rtg_Pub.sub_resource_tbl_type;
2675:
2676: l_return_value NUMBER;
2669: l_old_op_network_unexp_rec
2670: Bom_Rtg_Pub.op_network_Unexposed_Rec_Type := NULL;
2671: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2672: l_operation_tbl Bom_Rtg_Pub.operation_tbl_type;
2673: l_op_resource_tbl Bom_Rtg_Pub.op_resource_tbl_type;
2674: l_sub_resource_tbl Bom_Rtg_Pub.sub_resource_tbl_type;
2675:
2676: l_return_value NUMBER;
2677: /*below change for RBO support for OSFM*/
2670: Bom_Rtg_Pub.op_network_Unexposed_Rec_Type := NULL;
2671: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2672: l_operation_tbl Bom_Rtg_Pub.operation_tbl_type;
2673: l_op_resource_tbl Bom_Rtg_Pub.op_resource_tbl_type;
2674: l_sub_resource_tbl Bom_Rtg_Pub.sub_resource_tbl_type;
2675:
2676: l_return_value NUMBER;
2677: /*below change for RBO support for OSFM*/
2678: l_common_routing_sequence_id NUMBER;
3187: THEN
3188: Bom_Rtg_Error_Handler.Log_Error
3189: ( p_rtg_header_rec => l_rtg_header_rec
3190: , p_op_network_tbl => l_op_network_tbl
3191: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3192: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3193: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3194: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3195: , p_mesg_token_tbl => l_mesg_token_tbl
3188: Bom_Rtg_Error_Handler.Log_Error
3189: ( p_rtg_header_rec => l_rtg_header_rec
3190: , p_op_network_tbl => l_op_network_tbl
3191: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3192: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3193: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3194: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3195: , p_mesg_token_tbl => l_mesg_token_tbl
3196: , p_error_status => 'W'
3189: ( p_rtg_header_rec => l_rtg_header_rec
3190: , p_op_network_tbl => l_op_network_tbl
3191: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3192: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3193: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3194: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3195: , p_mesg_token_tbl => l_mesg_token_tbl
3196: , p_error_status => 'W'
3197: , p_error_level => Error_Handler.G_NWK_LEVEL
3190: , p_op_network_tbl => l_op_network_tbl
3191: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3192: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3193: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3194: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3195: , p_mesg_token_tbl => l_mesg_token_tbl
3196: , p_error_status => 'W'
3197: , p_error_level => Error_Handler.G_NWK_LEVEL
3198: , p_entity_index => I
3331: THEN
3332: Bom_Rtg_Error_Handler.Log_Error
3333: ( p_rtg_header_rec => l_rtg_header_rec
3334: , p_op_network_tbl => l_op_network_tbl
3335: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3336: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3337: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3338: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3339: , p_mesg_token_tbl => l_mesg_token_tbl
3332: Bom_Rtg_Error_Handler.Log_Error
3333: ( p_rtg_header_rec => l_rtg_header_rec
3334: , p_op_network_tbl => l_op_network_tbl
3335: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3336: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3337: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3338: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3339: , p_mesg_token_tbl => l_mesg_token_tbl
3340: , p_error_status => 'W'
3333: ( p_rtg_header_rec => l_rtg_header_rec
3334: , p_op_network_tbl => l_op_network_tbl
3335: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3336: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3337: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3338: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3339: , p_mesg_token_tbl => l_mesg_token_tbl
3340: , p_error_status => 'W'
3341: , p_error_level => Error_Handler.G_NWK_LEVEL
3334: , p_op_network_tbl => l_op_network_tbl
3335: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3336: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3337: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3338: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3339: , p_mesg_token_tbl => l_mesg_token_tbl
3340: , p_error_status => 'W'
3341: , p_error_level => Error_Handler.G_NWK_LEVEL
3342: , p_entity_index => I
3373: WHEN EXC_SEV_QUIT_RECORD THEN
3374: Bom_Rtg_Error_Handler.Log_Error
3375: ( p_rtg_header_rec => l_rtg_header_rec
3376: , p_op_network_tbl => l_op_network_tbl
3377: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3378: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3379: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3380: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3381: , p_mesg_token_tbl => l_mesg_token_tbl
3374: Bom_Rtg_Error_Handler.Log_Error
3375: ( p_rtg_header_rec => l_rtg_header_rec
3376: , p_op_network_tbl => l_op_network_tbl
3377: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3378: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3379: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3380: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3381: , p_mesg_token_tbl => l_mesg_token_tbl
3382: , p_error_status => Error_Handler.G_STATUS_ERROR
3375: ( p_rtg_header_rec => l_rtg_header_rec
3376: , p_op_network_tbl => l_op_network_tbl
3377: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3378: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3379: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3380: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3381: , p_mesg_token_tbl => l_mesg_token_tbl
3382: , p_error_status => Error_Handler.G_STATUS_ERROR
3383: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3376: , p_op_network_tbl => l_op_network_tbl
3377: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3378: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3379: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3380: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3381: , p_mesg_token_tbl => l_mesg_token_tbl
3382: , p_error_status => Error_Handler.G_STATUS_ERROR
3383: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3384: , p_error_level => Error_Handler.G_NWK_LEVEL
3413: WHEN EXC_SEV_QUIT_OBJECT THEN
3414: Bom_Rtg_Error_Handler.Log_Error
3415: ( p_rtg_header_rec => l_rtg_header_rec
3416: , p_op_network_tbl => l_op_network_tbl
3417: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3418: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3419: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3420: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3421: , p_mesg_token_tbl => l_mesg_token_tbl
3414: Bom_Rtg_Error_Handler.Log_Error
3415: ( p_rtg_header_rec => l_rtg_header_rec
3416: , p_op_network_tbl => l_op_network_tbl
3417: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3418: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3419: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3420: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3421: , p_mesg_token_tbl => l_mesg_token_tbl
3422: , p_error_status => Error_Handler.G_STATUS_ERROR
3415: ( p_rtg_header_rec => l_rtg_header_rec
3416: , p_op_network_tbl => l_op_network_tbl
3417: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3418: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3419: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3420: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3421: , p_mesg_token_tbl => l_mesg_token_tbl
3422: , p_error_status => Error_Handler.G_STATUS_ERROR
3423: , p_error_scope => Error_Handler.G_SCOPE_ALL
3416: , p_op_network_tbl => l_op_network_tbl
3417: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3418: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3419: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3420: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3421: , p_mesg_token_tbl => l_mesg_token_tbl
3422: , p_error_status => Error_Handler.G_STATUS_ERROR
3423: , p_error_scope => Error_Handler.G_SCOPE_ALL
3424: , p_error_level => Error_Handler.G_NWK_LEVEL
3452: WHEN EXC_FAT_QUIT_OBJECT THEN
3453:
3454: Bom_Rtg_Error_Handler.Log_Error
3455: ( p_op_network_tbl => l_op_network_tbl
3456: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
3457: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3458: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3459: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3460: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3453:
3454: Bom_Rtg_Error_Handler.Log_Error
3455: ( p_op_network_tbl => l_op_network_tbl
3456: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
3457: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3458: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3459: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3460: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3461: , p_mesg_token_tbl => l_mesg_token_tbl
3454: Bom_Rtg_Error_Handler.Log_Error
3455: ( p_op_network_tbl => l_op_network_tbl
3456: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
3457: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3458: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3459: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3460: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3461: , p_mesg_token_tbl => l_mesg_token_tbl
3462: , p_error_status => Error_Handler.G_STATUS_FATAL
3455: ( p_op_network_tbl => l_op_network_tbl
3456: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
3457: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3458: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3459: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3460: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3461: , p_mesg_token_tbl => l_mesg_token_tbl
3462: , p_error_status => Error_Handler.G_STATUS_FATAL
3463: , p_error_scope => Error_Handler.G_SCOPE_ALL
3456: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
3457: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3458: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3459: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3460: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3461: , p_mesg_token_tbl => l_mesg_token_tbl
3462: , p_error_status => Error_Handler.G_STATUS_FATAL
3463: , p_error_scope => Error_Handler.G_SCOPE_ALL
3464: , p_error_level => Error_Handler.G_NWK_LEVEL
3488: WHEN EXC_UNEXP_SKIP_OBJECT THEN
3489:
3490: Bom_Rtg_Error_Handler.Log_Error
3491: ( p_op_network_tbl => l_op_network_tbl
3492: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
3493: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3494: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3495: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3496: , p_sub_resource_tbl =>Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3489:
3490: Bom_Rtg_Error_Handler.Log_Error
3491: ( p_op_network_tbl => l_op_network_tbl
3492: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
3493: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3494: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3495: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3496: , p_sub_resource_tbl =>Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3497: , p_mesg_token_tbl => l_mesg_token_tbl
3490: Bom_Rtg_Error_Handler.Log_Error
3491: ( p_op_network_tbl => l_op_network_tbl
3492: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
3493: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3494: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3495: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3496: , p_sub_resource_tbl =>Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3497: , p_mesg_token_tbl => l_mesg_token_tbl
3498: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
3491: ( p_op_network_tbl => l_op_network_tbl
3492: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
3493: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3494: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3495: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3496: , p_sub_resource_tbl =>Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3497: , p_mesg_token_tbl => l_mesg_token_tbl
3498: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
3499: , p_error_scope => Error_Handler.G_SCOPE_ALL
3492: , p_rtg_header_rec =>Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
3493: , p_rtg_revision_tbl =>Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3494: , p_operation_tbl =>Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3495: , p_op_resource_tbl =>Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3496: , p_sub_resource_tbl =>Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3497: , p_mesg_token_tbl => l_mesg_token_tbl
3498: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
3499: , p_error_scope => Error_Handler.G_SCOPE_ALL
3500: , p_error_level => Error_Handler.G_NWK_LEVEL
3752: WHEN EXC_SEV_QUIT_OBJECT THEN
3753: Bom_Rtg_Error_Handler.Log_Error
3754: ( p_rtg_header_rec => l_rtg_header_rec
3755: , p_op_network_tbl => l_op_network_tbl
3756: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3757: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3758: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3759: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3760: , p_mesg_token_tbl => l_mesg_token_tbl
3753: Bom_Rtg_Error_Handler.Log_Error
3754: ( p_rtg_header_rec => l_rtg_header_rec
3755: , p_op_network_tbl => l_op_network_tbl
3756: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3757: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3758: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3759: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3760: , p_mesg_token_tbl => l_mesg_token_tbl
3761: , p_error_status => Error_Handler.G_STATUS_ERROR
3754: ( p_rtg_header_rec => l_rtg_header_rec
3755: , p_op_network_tbl => l_op_network_tbl
3756: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3757: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3758: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3759: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3760: , p_mesg_token_tbl => l_mesg_token_tbl
3761: , p_error_status => Error_Handler.G_STATUS_ERROR
3762: , p_error_scope => Error_Handler.G_SCOPE_ALL
3755: , p_op_network_tbl => l_op_network_tbl
3756: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
3757: , p_operation_tbl => Bom_Rtg_Pub.G_MISS_OPERATION_TBL
3758: , p_op_resource_tbl => Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
3759: , p_sub_resource_tbl => Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
3760: , p_mesg_token_tbl => l_mesg_token_tbl
3761: , p_error_status => Error_Handler.G_STATUS_ERROR
3762: , p_error_scope => Error_Handler.G_SCOPE_ALL
3763: , p_error_level => Error_Handler.G_NWK_LEVEL
3801: ( p_validation_level IN NUMBER
3802: , p_organization_id IN NUMBER := NULL
3803: , p_assembly_item_name IN VARCHAR2 := NULL
3804: , p_alternate_routing_code IN VARCHAR2 := NULL
3805: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
3806: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
3807: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
3808: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
3809: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
3802: , p_organization_id IN NUMBER := NULL
3803: , p_assembly_item_name IN VARCHAR2 := NULL
3804: , p_alternate_routing_code IN VARCHAR2 := NULL
3805: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
3806: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
3807: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
3808: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
3809: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
3810: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
3803: , p_assembly_item_name IN VARCHAR2 := NULL
3804: , p_alternate_routing_code IN VARCHAR2 := NULL
3805: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
3806: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
3807: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
3808: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
3809: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
3810: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
3811: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
3804: , p_alternate_routing_code IN VARCHAR2 := NULL
3805: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
3806: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
3807: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
3808: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
3809: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
3810: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
3811: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
3812: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
3805: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
3806: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
3807: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
3808: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
3809: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
3810: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
3811: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
3812: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
3813: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3806: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
3807: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
3808: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
3809: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
3810: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
3811: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
3812: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
3813: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3814: , x_return_status IN OUT NOCOPY VARCHAR2
3807: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
3808: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
3809: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
3810: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
3811: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
3812: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
3813: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3814: , x_return_status IN OUT NOCOPY VARCHAR2
3815: )
3808: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
3809: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
3810: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
3811: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
3812: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
3813: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3814: , x_return_status IN OUT NOCOPY VARCHAR2
3815: )
3816:
3816:
3817: IS
3818:
3819: /* Exposed and Unexposed record */
3820: l_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;
3821: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
3822: l_op_unexp_rec Bom_Rtg_Pub.Op_Unexposed_Rec_Type ;
3823: l_old_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;
3824: l_old_op_unexp_rec Bom_Rtg_Pub.Op_Unexposed_Rec_Type ;
3817: IS
3818:
3819: /* Exposed and Unexposed record */
3820: l_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;
3821: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
3822: l_op_unexp_rec Bom_Rtg_Pub.Op_Unexposed_Rec_Type ;
3823: l_old_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;
3824: l_old_op_unexp_rec Bom_Rtg_Pub.Op_Unexposed_Rec_Type ;
3825:
3818:
3819: /* Exposed and Unexposed record */
3820: l_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;
3821: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
3822: l_op_unexp_rec Bom_Rtg_Pub.Op_Unexposed_Rec_Type ;
3823: l_old_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;
3824: l_old_op_unexp_rec Bom_Rtg_Pub.Op_Unexposed_Rec_Type ;
3825:
3826: /* Other Entities */
3819: /* Exposed and Unexposed record */
3820: l_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;
3821: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
3822: l_op_unexp_rec Bom_Rtg_Pub.Op_Unexposed_Rec_Type ;
3823: l_old_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;
3824: l_old_op_unexp_rec Bom_Rtg_Pub.Op_Unexposed_Rec_Type ;
3825:
3826: /* Other Entities */
3827: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
3820: l_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;
3821: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
3822: l_op_unexp_rec Bom_Rtg_Pub.Op_Unexposed_Rec_Type ;
3823: l_old_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;
3824: l_old_op_unexp_rec Bom_Rtg_Pub.Op_Unexposed_Rec_Type ;
3825:
3826: /* Other Entities */
3827: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
3828: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
3823: l_old_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;
3824: l_old_op_unexp_rec Bom_Rtg_Pub.Op_Unexposed_Rec_Type ;
3825:
3826: /* Other Entities */
3827: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
3828: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
3829: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type := p_op_resource_tbl ;
3830: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type := p_sub_resource_tbl ;
3831: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type := p_op_network_tbl ;
3824: l_old_op_unexp_rec Bom_Rtg_Pub.Op_Unexposed_Rec_Type ;
3825:
3826: /* Other Entities */
3827: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
3828: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
3829: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type := p_op_resource_tbl ;
3830: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type := p_sub_resource_tbl ;
3831: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type := p_op_network_tbl ;
3832:
3825:
3826: /* Other Entities */
3827: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
3828: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
3829: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type := p_op_resource_tbl ;
3830: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type := p_sub_resource_tbl ;
3831: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type := p_op_network_tbl ;
3832:
3833: /* Error Handling Variables */
3826: /* Other Entities */
3827: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
3828: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
3829: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type := p_op_resource_tbl ;
3830: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type := p_sub_resource_tbl ;
3831: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type := p_op_network_tbl ;
3832:
3833: /* Error Handling Variables */
3834: l_token_tbl Error_Handler.Token_Tbl_Type ;
3827: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
3828: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
3829: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type := p_op_resource_tbl ;
3830: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type := p_sub_resource_tbl ;
3831: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type := p_op_network_tbl ;
3832:
3833: /* Error Handling Variables */
3834: l_token_tbl Error_Handler.Token_Tbl_Type ;
3835: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
4194: ( p_operation_tbl => l_operation_tbl
4195: , p_op_resource_tbl => l_op_resource_tbl
4196: , p_sub_resource_tbl => l_sub_resource_tbl
4197: , p_op_network_tbl => l_op_network_tbl
4198: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4199: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4200: , p_mesg_token_tbl => l_mesg_token_tbl
4201: , p_error_status => 'W'
4202: , p_error_level => Error_Handler.G_OP_LEVEL
4195: , p_op_resource_tbl => l_op_resource_tbl
4196: , p_sub_resource_tbl => l_sub_resource_tbl
4197: , p_op_network_tbl => l_op_network_tbl
4198: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4199: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4200: , p_mesg_token_tbl => l_mesg_token_tbl
4201: , p_error_status => 'W'
4202: , p_error_level => Error_Handler.G_OP_LEVEL
4203: , p_entity_index => I
4258: Bom_Rtg_Error_Handler.Log_Error
4259: ( p_operation_tbl => l_operation_tbl
4260: , p_op_resource_tbl => l_op_resource_tbl
4261: , p_sub_resource_tbl => l_sub_resource_tbl
4262: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4263: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4264: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4265: , p_mesg_token_tbl => l_mesg_token_tbl
4266: , p_error_status => 'W'
4259: ( p_operation_tbl => l_operation_tbl
4260: , p_op_resource_tbl => l_op_resource_tbl
4261: , p_sub_resource_tbl => l_sub_resource_tbl
4262: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4263: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4264: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4265: , p_mesg_token_tbl => l_mesg_token_tbl
4266: , p_error_status => 'W'
4267: , p_error_level => Error_Handler.G_OP_LEVEL
4260: , p_op_resource_tbl => l_op_resource_tbl
4261: , p_sub_resource_tbl => l_sub_resource_tbl
4262: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4263: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4264: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4265: , p_mesg_token_tbl => l_mesg_token_tbl
4266: , p_error_status => 'W'
4267: , p_error_level => Error_Handler.G_OP_LEVEL
4268: , p_entity_index => I
4369: Bom_Rtg_Error_Handler.Log_Error
4370: ( p_operation_tbl => l_operation_tbl
4371: , p_op_resource_tbl => l_op_resource_tbl
4372: , p_sub_resource_tbl => l_sub_resource_tbl
4373: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4374: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4375: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4376: , p_mesg_token_tbl => l_mesg_token_tbl
4377: , p_error_status => 'W'
4370: ( p_operation_tbl => l_operation_tbl
4371: , p_op_resource_tbl => l_op_resource_tbl
4372: , p_sub_resource_tbl => l_sub_resource_tbl
4373: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4374: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4375: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4376: , p_mesg_token_tbl => l_mesg_token_tbl
4377: , p_error_status => 'W'
4378: , p_error_level => Error_Handler.G_OP_LEVEL
4371: , p_op_resource_tbl => l_op_resource_tbl
4372: , p_sub_resource_tbl => l_sub_resource_tbl
4373: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4374: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4375: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4376: , p_mesg_token_tbl => l_mesg_token_tbl
4377: , p_error_status => 'W'
4378: , p_error_level => Error_Handler.G_OP_LEVEL
4379: , p_entity_index => I
4457: Bom_Rtg_Error_Handler.Log_Error
4458: ( p_operation_tbl => l_operation_tbl
4459: , p_op_resource_tbl => l_op_resource_tbl
4460: , p_sub_resource_tbl => l_sub_resource_tbl
4461: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4462: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4463: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4464: , p_mesg_token_tbl => l_mesg_token_tbl
4465: , p_error_status => 'W'
4458: ( p_operation_tbl => l_operation_tbl
4459: , p_op_resource_tbl => l_op_resource_tbl
4460: , p_sub_resource_tbl => l_sub_resource_tbl
4461: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4462: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4463: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4464: , p_mesg_token_tbl => l_mesg_token_tbl
4465: , p_error_status => 'W'
4466: , p_error_level => Error_Handler.G_OP_LEVEL
4459: , p_op_resource_tbl => l_op_resource_tbl
4460: , p_sub_resource_tbl => l_sub_resource_tbl
4461: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4462: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4463: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4464: , p_mesg_token_tbl => l_mesg_token_tbl
4465: , p_error_status => 'W'
4466: , p_error_level => Error_Handler.G_OP_LEVEL
4467: , p_entity_index => I
4522: Bom_Rtg_Error_Handler.Log_Error
4523: ( p_operation_tbl => l_operation_tbl
4524: , p_op_resource_tbl => l_op_resource_tbl
4525: , p_sub_resource_tbl => l_sub_resource_tbl
4526: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4527: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4528: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4529: , p_mesg_token_tbl => l_mesg_token_tbl
4530: , p_error_status => 'W'
4523: ( p_operation_tbl => l_operation_tbl
4524: , p_op_resource_tbl => l_op_resource_tbl
4525: , p_sub_resource_tbl => l_sub_resource_tbl
4526: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4527: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4528: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4529: , p_mesg_token_tbl => l_mesg_token_tbl
4530: , p_error_status => 'W'
4531: , p_error_level => Error_Handler.G_OP_LEVEL
4524: , p_op_resource_tbl => l_op_resource_tbl
4525: , p_sub_resource_tbl => l_sub_resource_tbl
4526: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4527: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4528: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4529: , p_mesg_token_tbl => l_mesg_token_tbl
4530: , p_error_status => 'W'
4531: , p_error_level => Error_Handler.G_OP_LEVEL
4532: , p_entity_index => I
4590: Bom_Rtg_Error_Handler.Log_Error
4591: ( p_operation_tbl => l_operation_tbl
4592: , p_op_resource_tbl => l_op_resource_tbl
4593: , p_sub_resource_tbl => l_sub_resource_tbl
4594: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4595: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4596: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4597: , p_mesg_token_tbl => l_mesg_token_tbl
4598: , p_error_status => 'W'
4591: ( p_operation_tbl => l_operation_tbl
4592: , p_op_resource_tbl => l_op_resource_tbl
4593: , p_sub_resource_tbl => l_sub_resource_tbl
4594: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4595: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4596: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4597: , p_mesg_token_tbl => l_mesg_token_tbl
4598: , p_error_status => 'W'
4599: , p_error_level => Error_Handler.G_OP_LEVEL
4592: , p_op_resource_tbl => l_op_resource_tbl
4593: , p_sub_resource_tbl => l_sub_resource_tbl
4594: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4595: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4596: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4597: , p_mesg_token_tbl => l_mesg_token_tbl
4598: , p_error_status => 'W'
4599: , p_error_level => Error_Handler.G_OP_LEVEL
4600: , p_entity_index => I
4654: Bom_Rtg_Error_Handler.Log_Error
4655: ( p_operation_tbl => l_operation_tbl
4656: , p_op_resource_tbl => l_op_resource_tbl
4657: , p_sub_resource_tbl => l_sub_resource_tbl
4658: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4659: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4660: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4661: , p_mesg_token_tbl => l_mesg_token_tbl
4662: , p_error_status => 'W'
4655: ( p_operation_tbl => l_operation_tbl
4656: , p_op_resource_tbl => l_op_resource_tbl
4657: , p_sub_resource_tbl => l_sub_resource_tbl
4658: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4659: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4660: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4661: , p_mesg_token_tbl => l_mesg_token_tbl
4662: , p_error_status => 'W'
4663: , p_error_level => Error_Handler.G_OP_LEVEL
4656: , p_op_resource_tbl => l_op_resource_tbl
4657: , p_sub_resource_tbl => l_sub_resource_tbl
4658: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4659: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4660: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4661: , p_mesg_token_tbl => l_mesg_token_tbl
4662: , p_error_status => 'W'
4663: , p_error_level => Error_Handler.G_OP_LEVEL
4664: , p_entity_index => I
4703: Bom_Rtg_Error_Handler.Log_Error
4704: ( p_operation_tbl => l_operation_tbl
4705: , p_op_resource_tbl => l_op_resource_tbl
4706: , p_sub_resource_tbl => l_sub_resource_tbl
4707: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4708: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4709: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4710: , p_mesg_token_tbl => l_mesg_token_tbl
4711: , p_error_status => 'W'
4704: ( p_operation_tbl => l_operation_tbl
4705: , p_op_resource_tbl => l_op_resource_tbl
4706: , p_sub_resource_tbl => l_sub_resource_tbl
4707: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4708: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4709: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4710: , p_mesg_token_tbl => l_mesg_token_tbl
4711: , p_error_status => 'W'
4712: , p_error_level => Error_Handler.G_OP_LEVEL
4705: , p_op_resource_tbl => l_op_resource_tbl
4706: , p_sub_resource_tbl => l_sub_resource_tbl
4707: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4708: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4709: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4710: , p_mesg_token_tbl => l_mesg_token_tbl
4711: , p_error_status => 'W'
4712: , p_error_level => Error_Handler.G_OP_LEVEL
4713: , p_entity_index => I
4770: Bom_Rtg_Error_Handler.Log_Error
4771: ( p_operation_tbl => l_operation_tbl
4772: , p_op_resource_tbl => l_op_resource_tbl
4773: , p_sub_resource_tbl => l_sub_resource_tbl
4774: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4775: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4776: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4777: , p_mesg_token_tbl => l_mesg_token_tbl
4778: , p_error_status => Error_Handler.G_STATUS_ERROR
4771: ( p_operation_tbl => l_operation_tbl
4772: , p_op_resource_tbl => l_op_resource_tbl
4773: , p_sub_resource_tbl => l_sub_resource_tbl
4774: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4775: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4776: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4777: , p_mesg_token_tbl => l_mesg_token_tbl
4778: , p_error_status => Error_Handler.G_STATUS_ERROR
4779: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4772: , p_op_resource_tbl => l_op_resource_tbl
4773: , p_sub_resource_tbl => l_sub_resource_tbl
4774: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4775: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4776: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4777: , p_mesg_token_tbl => l_mesg_token_tbl
4778: , p_error_status => Error_Handler.G_STATUS_ERROR
4779: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4780: , p_error_level => Error_Handler.G_OP_LEVEL
4812: Bom_Rtg_Error_Handler.Log_Error
4813: ( p_operation_tbl => l_operation_tbl
4814: , p_op_resource_tbl => l_op_resource_tbl
4815: , p_sub_resource_tbl => l_sub_resource_tbl
4816: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4817: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4818: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4819: , p_mesg_token_tbl => l_mesg_token_tbl
4820: , p_error_status => Error_Handler.G_STATUS_ERROR
4813: ( p_operation_tbl => l_operation_tbl
4814: , p_op_resource_tbl => l_op_resource_tbl
4815: , p_sub_resource_tbl => l_sub_resource_tbl
4816: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4817: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4818: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4819: , p_mesg_token_tbl => l_mesg_token_tbl
4820: , p_error_status => Error_Handler.G_STATUS_ERROR
4821: , p_error_scope => Error_Handler.G_SCOPE_CHILDREN
4814: , p_op_resource_tbl => l_op_resource_tbl
4815: , p_sub_resource_tbl => l_sub_resource_tbl
4816: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4817: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4818: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4819: , p_mesg_token_tbl => l_mesg_token_tbl
4820: , p_error_status => Error_Handler.G_STATUS_ERROR
4821: , p_error_scope => Error_Handler.G_SCOPE_CHILDREN
4822: , p_other_status => Error_Handler.G_STATUS_ERROR
4854: Bom_Rtg_Error_Handler.Log_Error
4855: ( p_operation_tbl => l_operation_tbl
4856: , p_op_resource_tbl => l_op_resource_tbl
4857: , p_sub_resource_tbl => l_sub_resource_tbl
4858: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4859: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4860: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4861: , p_mesg_token_tbl => l_mesg_token_tbl
4862: , p_error_status => Error_Handler.G_STATUS_ERROR
4855: ( p_operation_tbl => l_operation_tbl
4856: , p_op_resource_tbl => l_op_resource_tbl
4857: , p_sub_resource_tbl => l_sub_resource_tbl
4858: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4859: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4860: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4861: , p_mesg_token_tbl => l_mesg_token_tbl
4862: , p_error_status => Error_Handler.G_STATUS_ERROR
4863: , p_error_scope => Error_Handler.G_SCOPE_CHILDREN
4856: , p_op_resource_tbl => l_op_resource_tbl
4857: , p_sub_resource_tbl => l_sub_resource_tbl
4858: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4859: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4860: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4861: , p_mesg_token_tbl => l_mesg_token_tbl
4862: , p_error_status => Error_Handler.G_STATUS_ERROR
4863: , p_error_scope => Error_Handler.G_SCOPE_CHILDREN
4864: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
4891: Bom_Rtg_Error_Handler.Log_Error
4892: ( p_operation_tbl => l_operation_tbl
4893: , p_op_resource_tbl => l_op_resource_tbl
4894: , p_sub_resource_tbl => l_sub_resource_tbl
4895: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4896: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4897: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4898: , p_mesg_token_tbl => l_mesg_token_tbl
4899: , p_error_status => Error_Handler.G_STATUS_ERROR
4892: ( p_operation_tbl => l_operation_tbl
4893: , p_op_resource_tbl => l_op_resource_tbl
4894: , p_sub_resource_tbl => l_sub_resource_tbl
4895: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4896: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4897: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4898: , p_mesg_token_tbl => l_mesg_token_tbl
4899: , p_error_status => Error_Handler.G_STATUS_ERROR
4900: , p_error_scope => Error_Handler.G_SCOPE_SIBLINGS
4893: , p_op_resource_tbl => l_op_resource_tbl
4894: , p_sub_resource_tbl => l_sub_resource_tbl
4895: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4896: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4897: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4898: , p_mesg_token_tbl => l_mesg_token_tbl
4899: , p_error_status => Error_Handler.G_STATUS_ERROR
4900: , p_error_scope => Error_Handler.G_SCOPE_SIBLINGS
4901: , p_other_status => Error_Handler.G_STATUS_ERROR
4929: Bom_Rtg_Error_Handler.Log_Error
4930: ( p_operation_tbl => l_operation_tbl
4931: , p_op_resource_tbl => l_op_resource_tbl
4932: , p_sub_resource_tbl => l_sub_resource_tbl
4933: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4934: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4935: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4936: , p_mesg_token_tbl => l_mesg_token_tbl
4937: , p_error_status => Error_Handler.G_STATUS_FATAL
4930: ( p_operation_tbl => l_operation_tbl
4931: , p_op_resource_tbl => l_op_resource_tbl
4932: , p_sub_resource_tbl => l_sub_resource_tbl
4933: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4934: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4935: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4936: , p_mesg_token_tbl => l_mesg_token_tbl
4937: , p_error_status => Error_Handler.G_STATUS_FATAL
4938: , p_error_scope => Error_Handler.G_SCOPE_CHILDREN
4931: , p_op_resource_tbl => l_op_resource_tbl
4932: , p_sub_resource_tbl => l_sub_resource_tbl
4933: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4934: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4935: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4936: , p_mesg_token_tbl => l_mesg_token_tbl
4937: , p_error_status => Error_Handler.G_STATUS_FATAL
4938: , p_error_scope => Error_Handler.G_SCOPE_CHILDREN
4939: , p_other_status => Error_Handler.G_STATUS_FATAL
4963: Bom_Rtg_Error_Handler.Log_Error
4964: ( p_operation_tbl => l_operation_tbl
4965: , p_op_resource_tbl => l_op_resource_tbl
4966: , p_sub_resource_tbl => l_sub_resource_tbl
4967: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4968: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4969: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4970: , p_mesg_token_tbl => l_mesg_token_tbl
4971: , p_error_status => Error_Handler.G_STATUS_FATAL
4964: ( p_operation_tbl => l_operation_tbl
4965: , p_op_resource_tbl => l_op_resource_tbl
4966: , p_sub_resource_tbl => l_sub_resource_tbl
4967: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4968: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4969: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4970: , p_mesg_token_tbl => l_mesg_token_tbl
4971: , p_error_status => Error_Handler.G_STATUS_FATAL
4972: , p_error_scope => Error_Handler.G_SCOPE_SIBLINGS
4965: , p_op_resource_tbl => l_op_resource_tbl
4966: , p_sub_resource_tbl => l_sub_resource_tbl
4967: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
4968: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
4969: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
4970: , p_mesg_token_tbl => l_mesg_token_tbl
4971: , p_error_status => Error_Handler.G_STATUS_FATAL
4972: , p_error_scope => Error_Handler.G_SCOPE_SIBLINGS
4973: , p_other_status => Error_Handler.G_STATUS_FATAL
5027: Bom_Rtg_Error_Handler.Log_Error
5028: ( p_operation_tbl => l_operation_tbl
5029: , p_op_resource_tbl => l_op_resource_tbl
5030: , p_sub_resource_tbl => l_sub_resource_tbl
5031: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
5032: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
5033: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
5034: , p_mesg_token_tbl => l_mesg_token_tbl
5035: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
5028: ( p_operation_tbl => l_operation_tbl
5029: , p_op_resource_tbl => l_op_resource_tbl
5030: , p_sub_resource_tbl => l_sub_resource_tbl
5031: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
5032: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
5033: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
5034: , p_mesg_token_tbl => l_mesg_token_tbl
5035: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
5036: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
5029: , p_op_resource_tbl => l_op_resource_tbl
5030: , p_sub_resource_tbl => l_sub_resource_tbl
5031: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
5032: , p_rtg_revision_tbl => Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
5033: , p_op_network_tbl => Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
5034: , p_mesg_token_tbl => l_mesg_token_tbl
5035: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
5036: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
5037: , p_other_message => l_other_message
5201: , p_assembly_item_name IN VARCHAR2 := NULL
5202: , p_assembly_item_id IN NUMBER := NULL
5203: , p_organization_id IN NUMBER := NULL
5204: , p_alternate_rtg_code IN VARCHAR2 := NULL
5205: , p_rtg_revision_tbl IN Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5206: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
5207: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
5208: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5209: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
5202: , p_assembly_item_id IN NUMBER := NULL
5203: , p_organization_id IN NUMBER := NULL
5204: , p_alternate_rtg_code IN VARCHAR2 := NULL
5205: , p_rtg_revision_tbl IN Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5206: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
5207: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
5208: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5209: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
5210: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5203: , p_organization_id IN NUMBER := NULL
5204: , p_alternate_rtg_code IN VARCHAR2 := NULL
5205: , p_rtg_revision_tbl IN Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5206: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
5207: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
5208: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5209: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
5210: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5211: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
5204: , p_alternate_rtg_code IN VARCHAR2 := NULL
5205: , p_rtg_revision_tbl IN Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5206: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
5207: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
5208: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5209: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
5210: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5211: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
5212: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
5205: , p_rtg_revision_tbl IN Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5206: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
5207: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
5208: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5209: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
5210: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5211: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
5212: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
5213: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5206: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
5207: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
5208: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5209: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
5210: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5211: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
5212: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
5213: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5214: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
5207: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
5208: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5209: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
5210: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5211: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
5212: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
5213: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5214: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
5215: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5208: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5209: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
5210: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5211: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
5212: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
5213: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5214: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
5215: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5216: , x_return_status IN OUT NOCOPY VARCHAR2
5209: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
5210: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5211: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
5212: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
5213: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5214: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
5215: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5216: , x_return_status IN OUT NOCOPY VARCHAR2
5217: )
5210: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5211: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
5212: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
5213: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5214: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
5215: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5216: , x_return_status IN OUT NOCOPY VARCHAR2
5217: )
5218: IS
5223: l_valid BOOLEAN := TRUE;
5224: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5225: l_bo_return_status VARCHAR2(1) := 'S';
5226: l_bom_parent_exists BOOLEAN := FALSE;
5227: l_rtg_header_rec Bom_Rtg_Pub.rtg_Header_Rec_Type;
5228: l_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_unexposed_Rec_Type;
5229: l_old_rtg_header_rec Bom_Rtg_Pub.rtg_Header_Rec_Type;
5230: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
5231: l_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type;
5224: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5225: l_bo_return_status VARCHAR2(1) := 'S';
5226: l_bom_parent_exists BOOLEAN := FALSE;
5227: l_rtg_header_rec Bom_Rtg_Pub.rtg_Header_Rec_Type;
5228: l_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_unexposed_Rec_Type;
5229: l_old_rtg_header_rec Bom_Rtg_Pub.rtg_Header_Rec_Type;
5230: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
5231: l_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type;
5232: l_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type;
5225: l_bo_return_status VARCHAR2(1) := 'S';
5226: l_bom_parent_exists BOOLEAN := FALSE;
5227: l_rtg_header_rec Bom_Rtg_Pub.rtg_Header_Rec_Type;
5228: l_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_unexposed_Rec_Type;
5229: l_old_rtg_header_rec Bom_Rtg_Pub.rtg_Header_Rec_Type;
5230: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
5231: l_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type;
5232: l_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type;
5233: l_rtg_revision_tbl Bom_Rtg_Pub.rtg_Revision_Tbl_Type := p_rtg_revision_tbl;
5226: l_bom_parent_exists BOOLEAN := FALSE;
5227: l_rtg_header_rec Bom_Rtg_Pub.rtg_Header_Rec_Type;
5228: l_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_unexposed_Rec_Type;
5229: l_old_rtg_header_rec Bom_Rtg_Pub.rtg_Header_Rec_Type;
5230: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
5231: l_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type;
5232: l_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type;
5233: l_rtg_revision_tbl Bom_Rtg_Pub.rtg_Revision_Tbl_Type := p_rtg_revision_tbl;
5234: l_old_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type := NULL;
5227: l_rtg_header_rec Bom_Rtg_Pub.rtg_Header_Rec_Type;
5228: l_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_unexposed_Rec_Type;
5229: l_old_rtg_header_rec Bom_Rtg_Pub.rtg_Header_Rec_Type;
5230: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
5231: l_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type;
5232: l_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type;
5233: l_rtg_revision_tbl Bom_Rtg_Pub.rtg_Revision_Tbl_Type := p_rtg_revision_tbl;
5234: l_old_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type := NULL;
5235: l_old_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type := NULL;
5228: l_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_unexposed_Rec_Type;
5229: l_old_rtg_header_rec Bom_Rtg_Pub.rtg_Header_Rec_Type;
5230: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
5231: l_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type;
5232: l_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type;
5233: l_rtg_revision_tbl Bom_Rtg_Pub.rtg_Revision_Tbl_Type := p_rtg_revision_tbl;
5234: l_old_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type := NULL;
5235: l_old_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type := NULL;
5236: l_operation_tbl Bom_Rtg_Pub.operation_tbl_Type := p_operation_tbl;
5229: l_old_rtg_header_rec Bom_Rtg_Pub.rtg_Header_Rec_Type;
5230: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
5231: l_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type;
5232: l_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type;
5233: l_rtg_revision_tbl Bom_Rtg_Pub.rtg_Revision_Tbl_Type := p_rtg_revision_tbl;
5234: l_old_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type := NULL;
5235: l_old_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type := NULL;
5236: l_operation_tbl Bom_Rtg_Pub.operation_tbl_Type := p_operation_tbl;
5237: l_op_resource_tbl Bom_Rtg_Pub.op_resource_tbl_Type := p_op_resource_tbl;
5230: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
5231: l_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type;
5232: l_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type;
5233: l_rtg_revision_tbl Bom_Rtg_Pub.rtg_Revision_Tbl_Type := p_rtg_revision_tbl;
5234: l_old_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type := NULL;
5235: l_old_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type := NULL;
5236: l_operation_tbl Bom_Rtg_Pub.operation_tbl_Type := p_operation_tbl;
5237: l_op_resource_tbl Bom_Rtg_Pub.op_resource_tbl_Type := p_op_resource_tbl;
5238: l_sub_resource_tbl Bom_Rtg_Pub.sub_resource_tbl_Type :=
5231: l_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type;
5232: l_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type;
5233: l_rtg_revision_tbl Bom_Rtg_Pub.rtg_Revision_Tbl_Type := p_rtg_revision_tbl;
5234: l_old_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type := NULL;
5235: l_old_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type := NULL;
5236: l_operation_tbl Bom_Rtg_Pub.operation_tbl_Type := p_operation_tbl;
5237: l_op_resource_tbl Bom_Rtg_Pub.op_resource_tbl_Type := p_op_resource_tbl;
5238: l_sub_resource_tbl Bom_Rtg_Pub.sub_resource_tbl_Type :=
5239: p_sub_resource_tbl;
5232: l_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type;
5233: l_rtg_revision_tbl Bom_Rtg_Pub.rtg_Revision_Tbl_Type := p_rtg_revision_tbl;
5234: l_old_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type := NULL;
5235: l_old_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type := NULL;
5236: l_operation_tbl Bom_Rtg_Pub.operation_tbl_Type := p_operation_tbl;
5237: l_op_resource_tbl Bom_Rtg_Pub.op_resource_tbl_Type := p_op_resource_tbl;
5238: l_sub_resource_tbl Bom_Rtg_Pub.sub_resource_tbl_Type :=
5239: p_sub_resource_tbl;
5240: l_op_network_tbl Bom_Rtg_Pub.op_network_tbl_Type :=
5233: l_rtg_revision_tbl Bom_Rtg_Pub.rtg_Revision_Tbl_Type := p_rtg_revision_tbl;
5234: l_old_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type := NULL;
5235: l_old_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type := NULL;
5236: l_operation_tbl Bom_Rtg_Pub.operation_tbl_Type := p_operation_tbl;
5237: l_op_resource_tbl Bom_Rtg_Pub.op_resource_tbl_Type := p_op_resource_tbl;
5238: l_sub_resource_tbl Bom_Rtg_Pub.sub_resource_tbl_Type :=
5239: p_sub_resource_tbl;
5240: l_op_network_tbl Bom_Rtg_Pub.op_network_tbl_Type :=
5241: p_op_network_tbl;
5234: l_old_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type := NULL;
5235: l_old_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type := NULL;
5236: l_operation_tbl Bom_Rtg_Pub.operation_tbl_Type := p_operation_tbl;
5237: l_op_resource_tbl Bom_Rtg_Pub.op_resource_tbl_Type := p_op_resource_tbl;
5238: l_sub_resource_tbl Bom_Rtg_Pub.sub_resource_tbl_Type :=
5239: p_sub_resource_tbl;
5240: l_op_network_tbl Bom_Rtg_Pub.op_network_tbl_Type :=
5241: p_op_network_tbl;
5242: l_return_value NUMBER;
5236: l_operation_tbl Bom_Rtg_Pub.operation_tbl_Type := p_operation_tbl;
5237: l_op_resource_tbl Bom_Rtg_Pub.op_resource_tbl_Type := p_op_resource_tbl;
5238: l_sub_resource_tbl Bom_Rtg_Pub.sub_resource_tbl_Type :=
5239: p_sub_resource_tbl;
5240: l_op_network_tbl Bom_Rtg_Pub.op_network_tbl_Type :=
5241: p_op_network_tbl;
5242: l_return_value NUMBER;
5243: l_rtg_parent_exists BOOLEAN := FALSE ;
5244: l_Token_Tbl Error_Handler.Token_Tbl_Type;
5595: , p_operation_tbl => l_operation_tbl
5596: , p_op_resource_tbl => l_op_resource_tbl
5597: , p_sub_resource_tbl => l_sub_resource_tbl
5598: , p_op_network_tbl => l_op_network_tbl
5599: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
5600: , p_mesg_token_tbl => l_mesg_token_tbl
5601: , p_error_status => Error_Handler.G_STATUS_ERROR
5602: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5603: , p_error_level => Error_Handler.G_REV_LEVEL
5633: , p_operation_tbl => l_operation_tbl
5634: , p_op_resource_tbl => l_op_resource_tbl
5635: , p_sub_resource_tbl => l_sub_resource_tbl
5636: , p_op_network_tbl => l_op_network_tbl
5637: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
5638: , p_mesg_token_tbl => l_mesg_token_tbl
5639: , p_error_status => Error_Handler.G_STATUS_ERROR
5640: , p_error_scope => Error_Handler.G_SCOPE_ALL
5641: , p_error_level => Error_Handler.G_REV_LEVEL
5671: , p_operation_tbl => l_operation_tbl
5672: , p_op_resource_tbl => l_op_resource_tbl
5673: , p_sub_resource_tbl => l_sub_resource_tbl
5674: , p_op_network_tbl => l_op_network_tbl
5675: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
5676: , p_mesg_token_tbl => l_mesg_token_tbl
5677: , p_error_status => Error_Handler.G_STATUS_FATAL
5678: , p_error_scope => Error_Handler.G_SCOPE_ALL
5679: , p_error_level => Error_Handler.G_REV_LEVEL
5706: , p_operation_tbl => l_operation_tbl
5707: , p_op_resource_tbl => l_op_resource_tbl
5708: , p_sub_resource_tbl => l_sub_resource_tbl
5709: , p_op_network_tbl => l_op_network_tbl
5710: , p_rtg_header_rec => Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
5711: , p_mesg_token_tbl => l_mesg_token_tbl
5712: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
5713: , p_error_scope => Error_Handler.G_SCOPE_ALL
5714: , p_error_level => Error_Handler.G_REV_LEVEL
5769: ***************************************************************************/
5770: -- Header needs to be changed
5771: PROCEDURE Rtg_Header
5772: ( p_validation_level IN NUMBER
5773: , p_rtg_header_rec IN Bom_Rtg_Pub.rtg_Header_Rec_Type
5774: , p_rtg_revision_tbl IN Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5775: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
5776: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
5777: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5770: -- Header needs to be changed
5771: PROCEDURE Rtg_Header
5772: ( p_validation_level IN NUMBER
5773: , p_rtg_header_rec IN Bom_Rtg_Pub.rtg_Header_Rec_Type
5774: , p_rtg_revision_tbl IN Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5775: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
5776: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
5777: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5778: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
5771: PROCEDURE Rtg_Header
5772: ( p_validation_level IN NUMBER
5773: , p_rtg_header_rec IN Bom_Rtg_Pub.rtg_Header_Rec_Type
5774: , p_rtg_revision_tbl IN Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5775: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
5776: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
5777: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5778: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
5779: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_Header_Rec_Type
5772: ( p_validation_level IN NUMBER
5773: , p_rtg_header_rec IN Bom_Rtg_Pub.rtg_Header_Rec_Type
5774: , p_rtg_revision_tbl IN Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5775: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
5776: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
5777: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5778: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
5779: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_Header_Rec_Type
5780: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5773: , p_rtg_header_rec IN Bom_Rtg_Pub.rtg_Header_Rec_Type
5774: , p_rtg_revision_tbl IN Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5775: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
5776: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
5777: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5778: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
5779: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_Header_Rec_Type
5780: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5781: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
5774: , p_rtg_revision_tbl IN Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5775: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
5776: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
5777: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5778: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
5779: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_Header_Rec_Type
5780: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5781: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
5782: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
5775: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
5776: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
5777: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5778: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
5779: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_Header_Rec_Type
5780: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5781: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
5782: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
5783: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5776: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
5777: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5778: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
5779: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_Header_Rec_Type
5780: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5781: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
5782: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
5783: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5784: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
5777: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5778: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
5779: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_Header_Rec_Type
5780: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5781: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
5782: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
5783: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5784: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
5785: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5778: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
5779: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_Header_Rec_Type
5780: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5781: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
5782: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
5783: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5784: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
5785: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5786: , x_return_status IN OUT NOCOPY VARCHAR2
5779: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_Header_Rec_Type
5780: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5781: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
5782: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
5783: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5784: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
5785: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5786: , x_return_status IN OUT NOCOPY VARCHAR2
5787: )
5780: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.rtg_Revision_Tbl_Type
5781: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
5782: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
5783: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
5784: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
5785: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5786: , x_return_status IN OUT NOCOPY VARCHAR2
5787: )
5788: IS
5793: l_err_text VARCHAR2(2000);
5794: l_valid BOOLEAN := TRUE;
5795: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5796: l_bo_return_status VARCHAR2(1) := 'S';
5797: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
5798: l_old_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
5799: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
5800: l_rtg_header_Unexp_Rec Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type;
5801: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type := p_rtg_revision_tbl;
5794: l_valid BOOLEAN := TRUE;
5795: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5796: l_bo_return_status VARCHAR2(1) := 'S';
5797: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
5798: l_old_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
5799: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
5800: l_rtg_header_Unexp_Rec Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type;
5801: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type := p_rtg_revision_tbl;
5802: l_operation_tbl Bom_Rtg_Pub.operation_tbl_type := p_operation_tbl;
5795: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5796: l_bo_return_status VARCHAR2(1) := 'S';
5797: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
5798: l_old_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
5799: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
5800: l_rtg_header_Unexp_Rec Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type;
5801: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type := p_rtg_revision_tbl;
5802: l_operation_tbl Bom_Rtg_Pub.operation_tbl_type := p_operation_tbl;
5803: l_op_resource_tbl Bom_Rtg_Pub.op_resource_tbl_type := p_op_resource_tbl;
5796: l_bo_return_status VARCHAR2(1) := 'S';
5797: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
5798: l_old_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
5799: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
5800: l_rtg_header_Unexp_Rec Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type;
5801: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type := p_rtg_revision_tbl;
5802: l_operation_tbl Bom_Rtg_Pub.operation_tbl_type := p_operation_tbl;
5803: l_op_resource_tbl Bom_Rtg_Pub.op_resource_tbl_type := p_op_resource_tbl;
5804: l_sub_resource_tbl Bom_Rtg_Pub.sub_resource_tbl_type :=
5797: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
5798: l_old_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
5799: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
5800: l_rtg_header_Unexp_Rec Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type;
5801: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type := p_rtg_revision_tbl;
5802: l_operation_tbl Bom_Rtg_Pub.operation_tbl_type := p_operation_tbl;
5803: l_op_resource_tbl Bom_Rtg_Pub.op_resource_tbl_type := p_op_resource_tbl;
5804: l_sub_resource_tbl Bom_Rtg_Pub.sub_resource_tbl_type :=
5805: p_sub_resource_tbl;
5798: l_old_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
5799: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
5800: l_rtg_header_Unexp_Rec Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type;
5801: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type := p_rtg_revision_tbl;
5802: l_operation_tbl Bom_Rtg_Pub.operation_tbl_type := p_operation_tbl;
5803: l_op_resource_tbl Bom_Rtg_Pub.op_resource_tbl_type := p_op_resource_tbl;
5804: l_sub_resource_tbl Bom_Rtg_Pub.sub_resource_tbl_type :=
5805: p_sub_resource_tbl;
5806: l_op_network_tbl Bom_Rtg_Pub.op_network_tbl_type :=
5799: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;
5800: l_rtg_header_Unexp_Rec Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type;
5801: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type := p_rtg_revision_tbl;
5802: l_operation_tbl Bom_Rtg_Pub.operation_tbl_type := p_operation_tbl;
5803: l_op_resource_tbl Bom_Rtg_Pub.op_resource_tbl_type := p_op_resource_tbl;
5804: l_sub_resource_tbl Bom_Rtg_Pub.sub_resource_tbl_type :=
5805: p_sub_resource_tbl;
5806: l_op_network_tbl Bom_Rtg_Pub.op_network_tbl_type :=
5807: p_op_network_tbl;
5800: l_rtg_header_Unexp_Rec Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type;
5801: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type := p_rtg_revision_tbl;
5802: l_operation_tbl Bom_Rtg_Pub.operation_tbl_type := p_operation_tbl;
5803: l_op_resource_tbl Bom_Rtg_Pub.op_resource_tbl_type := p_op_resource_tbl;
5804: l_sub_resource_tbl Bom_Rtg_Pub.sub_resource_tbl_type :=
5805: p_sub_resource_tbl;
5806: l_op_network_tbl Bom_Rtg_Pub.op_network_tbl_type :=
5807: p_op_network_tbl;
5808: l_return_value NUMBER;
5802: l_operation_tbl Bom_Rtg_Pub.operation_tbl_type := p_operation_tbl;
5803: l_op_resource_tbl Bom_Rtg_Pub.op_resource_tbl_type := p_op_resource_tbl;
5804: l_sub_resource_tbl Bom_Rtg_Pub.sub_resource_tbl_type :=
5805: p_sub_resource_tbl;
5806: l_op_network_tbl Bom_Rtg_Pub.op_network_tbl_type :=
5807: p_op_network_tbl;
5808: l_return_value NUMBER;
5809: l_Token_Tbl Error_Handler.Token_Tbl_Type;
5810:
6945: ( p_api_version_number IN NUMBER
6946: , p_validation_level IN NUMBER
6947: , x_return_status IN OUT NOCOPY VARCHAR2
6948: , x_msg_count IN OUT NOCOPY NUMBER
6949: , p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
6950: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
6951: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
6952: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
6953: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
6946: , p_validation_level IN NUMBER
6947: , x_return_status IN OUT NOCOPY VARCHAR2
6948: , x_msg_count IN OUT NOCOPY NUMBER
6949: , p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
6950: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
6951: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
6952: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
6953: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
6954: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
6947: , x_return_status IN OUT NOCOPY VARCHAR2
6948: , x_msg_count IN OUT NOCOPY NUMBER
6949: , p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
6950: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
6951: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
6952: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
6953: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
6954: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
6955: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
6948: , x_msg_count IN OUT NOCOPY NUMBER
6949: , p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
6950: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
6951: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
6952: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
6953: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
6954: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
6955: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
6956: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
6949: , p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
6950: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
6951: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
6952: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
6953: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
6954: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
6955: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
6956: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
6957: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
6950: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
6951: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
6952: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
6953: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
6954: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
6955: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
6956: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
6957: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
6958: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
6951: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
6952: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
6953: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
6954: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
6955: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
6956: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
6957: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
6958: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
6959: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
6952: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
6953: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
6954: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
6955: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
6956: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
6957: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
6958: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
6959: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
6960: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
6953: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
6954: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
6955: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
6956: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
6957: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
6958: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
6959: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
6960: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
6961: )
6954: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
6955: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
6956: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
6957: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
6958: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
6959: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
6960: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
6961: )
6962: IS
6955: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
6956: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
6957: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
6958: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
6959: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
6960: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
6961: )
6962: IS
6963: l_api_version_number CONSTANT NUMBER := 1.0;
6956: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
6957: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
6958: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
6959: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
6960: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
6961: )
6962: IS
6963: l_api_version_number CONSTANT NUMBER := 1.0;
6964: l_api_name CONSTANT VARCHAR2(30):= 'Process_Rtg';
6968:
6969: l_assembly_item_name VARCHAR2(81);
6970: l_organization_code VARCHAR2(3);
6971: l_organization_id NUMBER;
6972: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
6973: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
6974: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
6975: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
6976: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
6969: l_assembly_item_name VARCHAR2(81);
6970: l_organization_code VARCHAR2(3);
6971: l_organization_id NUMBER;
6972: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
6973: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
6974: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
6975: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
6976: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
6977: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
6970: l_organization_code VARCHAR2(3);
6971: l_organization_id NUMBER;
6972: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
6973: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
6974: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
6975: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
6976: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
6977: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
6978:
6971: l_organization_id NUMBER;
6972: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
6973: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
6974: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
6975: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
6976: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
6977: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
6978:
6979:
6972: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
6973: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
6974: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
6975: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
6976: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
6977: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
6978:
6979:
6980: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
6973: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
6974: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
6975: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
6976: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
6977: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
6978:
6979:
6980: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
6981: l_other_message VARCHAR2(2000);