DBA Data[Home] [Help]

APPS.BOM_RTG_EXP dependencies on BOM_RTG_GLOBALS

Line 79: IF BOM_Rtg_Globals.get_debug = 'Y' THEN

75: l_rtg_hdr_rec Routing_Header_CUR%ROWTYPE;
76: l_common_assembly_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
77: l_completion_location_name MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE;
78: BEGIN
79: IF BOM_Rtg_Globals.get_debug = 'Y' THEN
80: Error_Handler.Write_Debug('PROCEDURE Populate_Header Entered. ');
81: END IF;
82: OPEN Routing_Header_CUR;
83: FETCH Routing_Header_CUR INTO l_rtg_hdr_rec;

Line 124: IF BOM_Rtg_Globals.get_debug = 'Y' THEN

120: G_Rtg_Header_Rec.original_system_reference := l_rtg_hdr_rec.original_system_reference;
121: -- G_Rtg_Header_Rec.Ser_Start_Op_Seq := l_rtg_hdr_rec.serialization_start_op;
122: X_routing_sequence_id := l_rtg_hdr_rec.routing_sequence_id;
123:
124: IF BOM_Rtg_Globals.get_debug = 'Y' THEN
125: Error_Handler.Write_Debug('PROCEDURE Populate_Header: One Routing Header record fetched. ');
126: END IF;
127: END Populate_Header;
128:

Line 159: IF BOM_Rtg_Globals.get_debug = 'Y' THEN

155: WHERE inventory_item_id = p_item_id
156: AND organization_id = p_organization_id;
157: i NUMBER := 1;
158: BEGIN
159: IF BOM_Rtg_Globals.get_debug = 'Y' THEN
160: Error_Handler.Write_Debug('PROCEDURE Populate_Revision entered.');
161: END IF;
162: FOR revision_rec IN Routing_Revision_CUR LOOP
163: G_rtg_revision_tbl(i).assembly_item_name := P_assembly_item_name;

Line 186: IF BOM_Rtg_Globals.get_debug = 'Y' THEN

182: G_rtg_revision_tbl(i).attribute14 := revision_rec.attribute14;
183: G_rtg_revision_tbl(i).attribute15 := revision_rec.attribute15;
184: i := i + 1;
185: END LOOP;
186: IF BOM_Rtg_Globals.get_debug = 'Y' THEN
187: Error_Handler.Write_Debug('PROCEDURE Populate_Revision: '||to_char(G_rtg_revision_tbl.COUNT)||' Routing Revision record(s) fetched.');
188: END IF;
189: END Populate_Revision;
190:

Line 242: IF BOM_Rtg_Globals.get_debug = 'Y' THEN

238: AND bst.setup_id(+) = bsor.setup_id;
239: i NUMBER;
240: j NUMBER := 0;
241: BEGIN
242: IF BOM_Rtg_Globals.get_debug = 'Y' THEN
243: Error_Handler.Write_Debug('PROCEDURE Populate_Sub_Oper_Res entered.');
244: Error_Handler.Write_Debug('Operation Sequence Number: '|| TO_CHAR(P_operation_sequence_number));
245: Error_Handler.Write_Debug('Operation Type : '|| TO_CHAR(P_operation_type));
246: Error_Handler.Write_Debug('Effectivity Date : '|| TO_CHAR(P_effectivity_date));

Line 293: IF BOM_Rtg_Globals.get_debug = 'Y' THEN

289: G_sub_resource_tbl(i).attribute15 := sub_resource_rec.attribute15;
290: G_sub_resource_tbl(i).setup_type := sub_resource_rec.setup_code;
291: i := i + 1;
292: END LOOP;
293: IF BOM_Rtg_Globals.get_debug = 'Y' THEN
294: Error_Handler.Write_Debug('PROCEDURE Populate_Sub_Oper_Res: '||TO_CHAR(G_sub_resource_tbl.COUNT - j)||' record(s) fetched.');
295: END IF;
296: END Populate_Sub_Oper_Res;
297:

Line 350: IF BOM_Rtg_Globals.get_debug = 'Y' THEN

346: i NUMBER;
347: j NUMBER;
348: l_schedule_seq_num NUMBER;
349: BEGIN
350: IF BOM_Rtg_Globals.get_debug = 'Y' THEN
351: Error_Handler.Write_Debug('PROCEDURE Populate_Oper_Resources entered.');
352: Error_Handler.Write_Debug('Operation Sequence Number: '|| TO_CHAR(P_operation_seq_num));
353: Error_Handler.Write_Debug('Operation Type : '|| P_operation_type);
354: Error_Handler.Write_Debug('Effectivity Date : '|| to_char(P_effectivity_date));

Line 422: IF BOM_Rtg_Globals.get_debug = 'Y' THEN

418: */
419: END IF;
420: i := i + 1;
421: END LOOP;
422: IF BOM_Rtg_Globals.get_debug = 'Y' THEN
423: Error_Handler.Write_Debug('PROCEDURE Populate_Sub_Oper_Res: '||to_char(g_op_resource_tbl.COUNT - j) ||' record(s) fetched. ');
424: END IF;
425: END Populate_Oper_Resources;
426:

Line 485: IF BOM_Rtg_Globals.get_debug = 'Y' THEN

481: l_op_seq_num NUMBER;
482: l_op_type NUMBER;
483: l_eff_date DATE;
484: BEGIN
485: IF BOM_Rtg_Globals.get_debug = 'Y' THEN
486: Error_Handler.Write_Debug('PROCEDURE Populate_Operations entered.');
487: END IF;
488: FOR routing_oper_rec IN Routing_Operation_CUR LOOP
489: G_operation_tbl(i).assembly_item_name := P_assembly_item_name;

Line 557: IF BOM_Rtg_Globals.get_debug = 'Y' THEN

553: P_operation_type => l_op_type,
554: P_effectivity_date => l_eff_date);
555: i := i + 1;
556: END LOOP;
557: IF BOM_Rtg_Globals.get_debug = 'Y' THEN
558: Error_Handler.Write_Debug('PROCEDURE Populate_Operations: '||to_char(G_operation_tbl.COUNT)||' record(s) fetched. ');
559: END IF;
560: END Populate_Operations;
561:

Line 602: IF BOM_Rtg_Globals.get_debug = 'Y' THEN

598: AND bos1.Operation_Sequence_Id = bonv.From_Op_Seq_Id
599: AND bos2.Operation_Sequence_Id = bonv.To_Op_Seq_Id;
600: i NUMBER := 1;
601: BEGIN
602: IF BOM_Rtg_Globals.get_debug = 'Y' THEN
603: Error_Handler.Write_Debug('PROCEDURE Populate_Oper_Networks entered.');
604: END IF;
605:
606: FOR oper_networks_rec IN Oper_Networks_CUR LOOP

Line 639: IF BOM_Rtg_Globals.get_debug = 'Y' THEN

635: G_op_network_tbl(i).attribute15 := oper_networks_rec.attribute15;
636: G_op_network_tbl(i).original_system_reference := oper_networks_rec.original_system_reference;
637: i := i + 1;
638: END LOOP;
639: IF BOM_Rtg_Globals.get_debug = 'Y' THEN
640: Error_Handler.Write_Debug('PROCEDURE Populate_Oper_Networks: '||to_char(G_op_network_tbl.COUNT)||' record(s) fetched. ');
641: END IF;
642: END Populate_Oper_Networks;
643:

Line 793: BOM_Rtg_Globals.Set_Debug(l_debug_flag);

789: */
790: l_debug_flag := 'N';
791: END IF;
792:
793: BOM_Rtg_Globals.Set_Debug(l_debug_flag);
794:
795: IF l_debug_flag = 'Y' THEN
796: Error_Handler.Open_Debug_Session
797: (p_debug_filename => p_debug_filename,

Line 803: BOM_Rtg_Globals.Set_Debug('N');

799: x_return_status => l_return_status,
800: p_mesg_token_tbl => l_mesg_token_tbl,
801: x_mesg_token_tbl => l_mesg_token_tbl);
802: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
803: BOM_Rtg_Globals.Set_Debug('N');
804: END IF;
805: END IF;
806: END IF;
807:

Line 874: IF BOM_Rtg_Globals.get_debug = 'Y' THEN

870: P_alternate_routing_code => P_alternate_routing_designator,
871: P_routing_seq_id => l_routing_seq_id);
872: END IF;
873:
874: IF BOM_Rtg_Globals.get_debug = 'Y' THEN
875: Error_Handler.Write_Debug('The Routing Export BO is passed ');
876: Error_Handler.Write_Debug('-----------------------------------------------------') ;
877: Error_Handler.Write_Debug('Header Rec - Assembly Item : ' || G_rtg_header_rec.assembly_item_name);
878: Error_Handler.Write_Debug('Num of Routing Revisions : ' || G_rtg_revision_tbl.COUNT);

Line 935: IF (BOM_RTG_GLOBALS.Get_Debug = 'Y') THEN

931: x_op_network_tbl => x_op_network_tbl);
932: */
933: x_return_status := Error_Handler.G_STATUS_ERROR;
934: x_msg_count := Error_Handler.Get_Message_Count;
935: IF (BOM_RTG_GLOBALS.Get_Debug = 'Y') THEN
936: ERROR_HANDLER.Close_Debug_Session;
937: END IF;
938:
939: WHEN G_EXC_UNEXP_SKIP_OBJECT THEN

Line 979: IF (Bom_Rtg_Globals.Get_Debug = 'Y') THEN

975: x_op_network_tbl => x_op_network_tbl);
976: */
977: x_return_status := Error_Handler.G_STATUS_UNEXPECTED;
978: x_msg_count := Error_Handler.Get_Message_Count;
979: IF (Bom_Rtg_Globals.Get_Debug = 'Y') THEN
980: ERROR_HANDLER.Close_Debug_Session;
981: END IF;
982: WHEN no_data_found THEN
983: BOM_RTG_ERROR_HANDLER.Log_Error

Line 1021: IF (BOM_RTG_GLOBALS.Get_Debug = 'Y') THEN

1017: x_op_network_tbl => X_op_network_tbl);
1018: */
1019: X_return_status := Error_Handler.G_STATUS_ERROR;
1020: X_msg_count := Error_Handler.Get_Message_Count;
1021: IF (BOM_RTG_GLOBALS.Get_Debug = 'Y') THEN
1022: ERROR_HANDLER.Close_Debug_Session;
1023: END IF;
1024: END Export_RTG;
1025: END BOM_RTG_EXP;