DBA Data[Home] [Help]

APPS.BOM_DEFAULT_OP_SEQ dependencies on ERROR_HANDLER

Line 396: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

392: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
393: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
394: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
395: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
396: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
397: , x_return_status IN OUT NOCOPY VARCHAR2
398: )
399: IS
400: -- Variables

Line 410: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type ;

406:
407: -- Error Handlig Variables
408: l_return_status VARCHAR2(1);
409: l_err_text VARCHAR2(2000) ;
410: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type ;
411: l_token_tbl Error_Handler.Token_Tbl_Type;
412:
413: -- Exception
414: EXIT_CHECK_REF_STD_OP EXCEPTION ;

Line 411: l_token_tbl Error_Handler.Token_Tbl_Type;

407: -- Error Handlig Variables
408: l_return_status VARCHAR2(1);
409: l_err_text VARCHAR2(2000) ;
410: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type ;
411: l_token_tbl Error_Handler.Token_Tbl_Type;
412:
413: -- Exception
414: EXIT_CHECK_REF_STD_OP EXCEPTION ;
415:

Line 559: Error_Handler.Add_Error_Token

555: ( p_op_seq_id => l_com_op_unexp_rec.operation_sequence_id )
556: LOOP
557: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
558: THEN
559: Error_Handler.Add_Error_Token
560: ( p_message_name => 'BOM_OP_CANNOT_COPY_STD_OP'
561: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
562: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
563: , p_Token_Tbl => l_Token_Tbl

Line 578: Error_Handler.Add_Error_Token

574: ( p_op_seq_id => l_com_op_unexp_rec.old_operation_sequence_id )
575: LOOP
576: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
577: THEN
578: Error_Handler.Add_Error_Token
579: ( p_message_name => 'BOM_OP_CANNOT_COPY_STD_OP'
580: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
581: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
582: , p_Token_Tbl => l_Token_Tbl

Line 603: Error_Handler.Write_Debug('std op id '||to_char(l_com_op_unexp_rec.standard_operation_id) ) ;

599: --
600:
601: /*
602: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
603: Error_Handler.Write_Debug('std op id '||to_char(l_com_op_unexp_rec.standard_operation_id) ) ;
604: Error_Handler.Write_Debug('op type '||to_char(l_com_operation_rec.operation_type) ) ;
605: Error_Handler.Write_Debug('rtg seq id '||to_char(l_com_op_unexp_rec.routing_sequence_id) ) ;
606: Error_Handler.Write_Debug('org id '||to_char(l_com_op_unexp_rec.organization_id) ) ;
607: Error_Handler.Write_Debug('dept id '||to_char(l_com_op_unexp_rec.department_id) ) ;

Line 604: Error_Handler.Write_Debug('op type '||to_char(l_com_operation_rec.operation_type) ) ;

600:
601: /*
602: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
603: Error_Handler.Write_Debug('std op id '||to_char(l_com_op_unexp_rec.standard_operation_id) ) ;
604: Error_Handler.Write_Debug('op type '||to_char(l_com_operation_rec.operation_type) ) ;
605: Error_Handler.Write_Debug('rtg seq id '||to_char(l_com_op_unexp_rec.routing_sequence_id) ) ;
606: Error_Handler.Write_Debug('org id '||to_char(l_com_op_unexp_rec.organization_id) ) ;
607: Error_Handler.Write_Debug('dept id '||to_char(l_com_op_unexp_rec.department_id) ) ;
608: Error_Handler.Write_Debug('rev seq id '||to_char(l_com_op_unexp_rec.revised_item_sequence_id) ) ;

Line 605: Error_Handler.Write_Debug('rtg seq id '||to_char(l_com_op_unexp_rec.routing_sequence_id) ) ;

601: /*
602: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
603: Error_Handler.Write_Debug('std op id '||to_char(l_com_op_unexp_rec.standard_operation_id) ) ;
604: Error_Handler.Write_Debug('op type '||to_char(l_com_operation_rec.operation_type) ) ;
605: Error_Handler.Write_Debug('rtg seq id '||to_char(l_com_op_unexp_rec.routing_sequence_id) ) ;
606: Error_Handler.Write_Debug('org id '||to_char(l_com_op_unexp_rec.organization_id) ) ;
607: Error_Handler.Write_Debug('dept id '||to_char(l_com_op_unexp_rec.department_id) ) ;
608: Error_Handler.Write_Debug('rev seq id '||to_char(l_com_op_unexp_rec.revised_item_sequence_id) ) ;
609: END IF ;

Line 606: Error_Handler.Write_Debug('org id '||to_char(l_com_op_unexp_rec.organization_id) ) ;

602: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
603: Error_Handler.Write_Debug('std op id '||to_char(l_com_op_unexp_rec.standard_operation_id) ) ;
604: Error_Handler.Write_Debug('op type '||to_char(l_com_operation_rec.operation_type) ) ;
605: Error_Handler.Write_Debug('rtg seq id '||to_char(l_com_op_unexp_rec.routing_sequence_id) ) ;
606: Error_Handler.Write_Debug('org id '||to_char(l_com_op_unexp_rec.organization_id) ) ;
607: Error_Handler.Write_Debug('dept id '||to_char(l_com_op_unexp_rec.department_id) ) ;
608: Error_Handler.Write_Debug('rev seq id '||to_char(l_com_op_unexp_rec.revised_item_sequence_id) ) ;
609: END IF ;
610: */

Line 607: Error_Handler.Write_Debug('dept id '||to_char(l_com_op_unexp_rec.department_id) ) ;

603: Error_Handler.Write_Debug('std op id '||to_char(l_com_op_unexp_rec.standard_operation_id) ) ;
604: Error_Handler.Write_Debug('op type '||to_char(l_com_operation_rec.operation_type) ) ;
605: Error_Handler.Write_Debug('rtg seq id '||to_char(l_com_op_unexp_rec.routing_sequence_id) ) ;
606: Error_Handler.Write_Debug('org id '||to_char(l_com_op_unexp_rec.organization_id) ) ;
607: Error_Handler.Write_Debug('dept id '||to_char(l_com_op_unexp_rec.department_id) ) ;
608: Error_Handler.Write_Debug('rev seq id '||to_char(l_com_op_unexp_rec.revised_item_sequence_id) ) ;
609: END IF ;
610: */
611:

Line 608: Error_Handler.Write_Debug('rev seq id '||to_char(l_com_op_unexp_rec.revised_item_sequence_id) ) ;

604: Error_Handler.Write_Debug('op type '||to_char(l_com_operation_rec.operation_type) ) ;
605: Error_Handler.Write_Debug('rtg seq id '||to_char(l_com_op_unexp_rec.routing_sequence_id) ) ;
606: Error_Handler.Write_Debug('org id '||to_char(l_com_op_unexp_rec.organization_id) ) ;
607: Error_Handler.Write_Debug('dept id '||to_char(l_com_op_unexp_rec.department_id) ) ;
608: Error_Handler.Write_Debug('rev seq id '||to_char(l_com_op_unexp_rec.revised_item_sequence_id) ) ;
609: END IF ;
610: */
611:
612:

Line 627: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

623:
624: --
625: -- Set Standard Operation Value to Operation Exp and Unexp Rec.
626: --
627: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
628: ('Set Standard Operation Value to Null Operation columns.. . . ' ) ;
629: END IF ;
630:
631:

Line 723: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

719: --
720: ELSIF l_copy_std_op AND l_com_operation_rec.reference_flag = 1 -- Yes
721: THEN
722:
723: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
724: ('Reference flag is Yes, then the operation columns corresponding to in Standard Operations . . . ' ) ;
725: END IF ;
726: --
727: -- Get Standard Operatin Information

Line 739: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

735: , p_rit_seq_id => l_com_op_unexp_rec.revised_item_sequence_id
736: )
737: LOOP
738:
739: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
740: ('Std operation info should be copied over to the columns. . . ' ) ;
741: END IF ;
742:
743: -- Set Standard Operation Info.

Line 806: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

802: END IF ; -- Ref Flag is Yes
803:
804: END IF ; -- Acd Type : Add
805:
806: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
807: ('Default Standard Operation Attributes was processed. . . ' || l_return_status);
808: END IF ;
809:
810: --

Line 840: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

836: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
837:
838:
839: WHEN OTHERS THEN
840: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
841: ('Some unknown error in Entity Validation(Default Std Op) . . .' || SQLERRM );
842: END IF ;
843:
844:

Line 849: Error_Handler.Add_Error_Token

845: l_err_text := G_PKG_NAME || ' Validation (Entity Validation(Default Std Op)) '
846: || substrb(SQLERRM,1,200);
847: -- dbms_output.put_line('Unexpected Error: '||l_err_text);
848:
849: Error_Handler.Add_Error_Token
850: ( p_message_name => NULL
851: , p_message_text => l_err_text
852: , p_mesg_token_tbl => l_mesg_token_tbl
853: , x_mesg_token_tbl => l_mesg_token_tbl

Line 880: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

876: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
877: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
878: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
879: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
880: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
881: , x_return_status IN OUT NOCOPY VARCHAR2
882: )
883: IS
884: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

Line 889: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

885: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
886:
887: l_return_status VARCHAR2(1);
888: l_err_text VARCHAR2(2000) ;
889: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
890:
891: BEGIN
892:
893: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 948: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

944: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
945: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
946: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
947: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
948: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
949: , x_return_status IN OUT NOCOPY VARCHAR2
950: )
951: IS
952: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

Line 957: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

953: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
954:
955: l_return_status VARCHAR2(1);
956: l_err_text VARCHAR2(2000) ;
957: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
958:
959: BEGIN
960:
961: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1017: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

1013: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1014: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
1015: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1016: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1017: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1018: , x_return_status IN OUT NOCOPY VARCHAR2
1019: )
1020:
1021: IS

Line 1029: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

1025:
1026: l_return_status VARCHAR2(1);
1027: l_temp_return_status VARCHAR2(1);
1028: l_err_text VARCHAR2(2000) ;
1029: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1030: l_Temp_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1031:
1032:
1033: BEGIN

Line 1030: l_Temp_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

1026: l_return_status VARCHAR2(1);
1027: l_temp_return_status VARCHAR2(1);
1028: l_err_text VARCHAR2(2000) ;
1029: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1030: l_Temp_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1031:
1032:
1033: BEGIN
1034:

Line 1035: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

1031:
1032:
1033: BEGIN
1034:
1035: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1036: ('Within the Rev. Operation Attr. Defaulting...') ;
1037: END IF ;
1038:
1039: l_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1228: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

1224:
1225: -- Check if the parent routing is Flow Routing
1226: IF BOM_Rtg_Globals.Get_CFM_Rtg_Flag = BOM_Rtg_Globals.G_FLOW_RTG
1227: THEN
1228: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1229: ('Attr. Defaulting for Flow Routing...' || to_char(l_com_op_unexp_rec.routing_sequence_id)) ;
1230: END IF ;
1231:
1232: /************************************************************

Line 1281: -- IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

1277: -- Check if the parent routing is Lot Based Routing
1278: -- IF BOM_Rtg_Globals.Get_CFM_Rtg_Flag = BOM_Rtg_Globals.G_LOT_RTG
1279: -- THEN
1280:
1281: -- IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1282: -- ('Attr. Defaulting for Lot Based Routing...' || to_char(l_com_op_unexp_rec.routing_sequence_id)) ;
1283: -- END IF ;
1284:
1285: /************************************************************

Line 1332: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

1328: , p_organization_id => l_com_op_unexp_rec.organization_id
1329: , p_alternate_routing_code => l_com_operation_rec.alternate_routing_code) ;
1330:
1331:
1332: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1333: ('Generated Routing_Sequence_Id...' || to_char(l_com_op_unexp_rec.routing_sequence_id)) ;
1334: END IF ;
1335: END IF ;
1336:

Line 1381: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

1377: AND l_com_operation_rec.acd_type = 1 -- Add
1378: THEN
1379: l_com_op_unexp_rec.old_operation_sequence_id := l_com_op_unexp_rec.operation_sequence_id ;
1380:
1381: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1382: ('Set current op seq id to old op seq id as default value.') ;
1383: END IF ;
1384: END IF ;
1385:

Line 1421: Error_Handler.Write_Debug('Getting out of Operation Attribute Defualting...');

1417: x_return_status := l_return_status ;
1418: x_mesg_token_tbl := l_mesg_token_tbl ;
1419:
1420: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
1421: Error_Handler.Write_Debug('Getting out of Operation Attribute Defualting...');
1422: END IF ;
1423:
1424:
1425: EXCEPTION

Line 1427: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

1423:
1424:
1425: EXCEPTION
1426: WHEN OTHERS THEN
1427: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1428: ('Some unknown error in Attribute Defaulting . . .' || SQLERRM );
1429: END IF ;
1430:
1431:

Line 1436: Error_Handler.Add_Error_Token

1432: l_err_text := G_PKG_NAME || ' Default (Attr. Defaulting) '
1433: || substrb(SQLERRM,1,200);
1434: -- dbms_output.put_line('Unexpected Error: '||l_err_text);
1435:
1436: Error_Handler.Add_Error_Token
1437: ( p_message_name => NULL
1438: , p_message_text => l_err_text
1439: , p_mesg_token_tbl => l_mesg_token_tbl
1440: , x_mesg_token_tbl => l_mesg_token_tbl

Line 1637: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

1633: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1634: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1635:
1636: BEGIN
1637: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1638: ('Within the Rev. Operation Populate null columns...') ;
1639: END IF ;
1640:
1641: -- Initialize operation exp and unexp record

Line 1647: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

1643: l_com_op_unexp_rec := p_com_op_unexp_rec ;
1644:
1645:
1646: -- Exposed Column
1647: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1648: ('Populate null exposed columns......') ;
1649: END IF ;
1650:
1651: IF l_com_operation_rec.operation_type IN (l_PROCESS, l_LINE_OP)

Line 1884: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

1880:
1881: --
1882: -- Also copy the Unexposed Columns from Database to New record
1883: --
1884: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1885: ('Populate Null Unexposed columns......') ;
1886: END IF ;
1887:
1888:

Line 1902: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Op Seq: ' ||

1898: l_com_op_unexp_rec.Old_Operation_Sequence_Id
1899: := p_old_com_op_unexp_rec.Old_Operation_Sequence_Id ;
1900:
1901:
1902: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Op Seq: ' ||
1903: to_char(l_com_op_unexp_rec.operation_sequence_id)) ;
1904: END IF ;
1905:
1906: ELSIF l_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE

Line 1971: Error_Handler.Write_Debug('Set Op attr. of old operation to current rev op. . .') ;

1967: AND p_old_com_operation_rec.Reference_Flag = 1 -- Yes
1968: THEN
1969:
1970: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
1971: Error_Handler.Write_Debug('Set Op attr. of old operation to current rev op. . .') ;
1972: END IF ;
1973: l_com_op_unexp_rec.department_id
1974: := p_old_com_op_unexp_rec.department_id ;
1975: l_com_operation_rec.minimum_transfer_quantity

Line 2050: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

2046: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
2047: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2048: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
2049: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2050: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2051: , x_return_status IN OUT NOCOPY VARCHAR2
2052: )
2053: IS
2054: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

Line 2059: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

2055: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2056:
2057: l_return_status VARCHAR2(1);
2058: l_err_text VARCHAR2(2000) ;
2059: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2060:
2061: BEGIN
2062:
2063: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2125: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

2121: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2122: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
2123: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
2124: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2125: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2126: , x_return_status IN OUT NOCOPY VARCHAR2
2127: )
2128:
2129: IS

Line 2134: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

2130: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2131: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2132: l_return_status VARCHAR2(1);
2133: l_err_text VARCHAR2(2000) ;
2134: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2135:
2136: BEGIN
2137:
2138: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2203: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

2199: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2200: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
2201: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
2202: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2203: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2204: , x_return_status IN OUT NOCOPY VARCHAR2
2205: )
2206:
2207: IS

Line 2214: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

2210: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2211:
2212: l_return_status VARCHAR2(1);
2213: l_err_text VARCHAR2(2000) ;
2214: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2215:
2216:
2217: BEGIN
2218:

Line 2219: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

2215:
2216:
2217: BEGIN
2218:
2219: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
2220: ('Within the Rev. Operation Entity Defaulting...') ;
2221: END IF ;
2222:
2223: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2450: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

2446:
2447:
2448: EXCEPTION
2449: WHEN OTHERS THEN
2450: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
2451: ('Some unknown error in Entity Defaulting . . .' || SQLERRM );
2452: END IF ;
2453:
2454:

Line 2459: Error_Handler.Add_Error_Token

2455: l_err_text := G_PKG_NAME || ' Defaulting (Entity Defaulting) '
2456: || substrb(SQLERRM,1,200);
2457: -- dbms_output.put_line('Unexpected Error: '||l_err_text);
2458:
2459: Error_Handler.Add_Error_Token
2460: ( p_message_name => NULL
2461: , p_message_text => l_err_text
2462: , p_mesg_token_tbl => l_mesg_token_tbl
2463: , x_mesg_token_tbl => l_mesg_token_tbl