eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_RTG_HEADER_UTIL dependencies on BOM_RTG_GLOBALS

Line 124: x_return_status := BOM_Rtg_Globals.G_RECORD_FOUND;

120: = NVL( p_alternate_routing_code, FND_API.G_MISS_CHAR )
121: ;
122:
123:
124: x_return_status := BOM_Rtg_Globals.G_RECORD_FOUND;
125: x_rtg_header_rec := l_rtg_header_rec;
126: x_rtg_header_unexp_rec := l_rtg_header_unexp_rec;
127:
128: EXCEPTION

Line 130: x_return_status := BOM_Rtg_Globals.G_RECORD_NOT_FOUND;

126: x_rtg_header_unexp_rec := l_rtg_header_unexp_rec;
127:
128: EXCEPTION
129: WHEN NO_DATA_FOUND THEN
130: x_return_status := BOM_Rtg_Globals.G_RECORD_NOT_FOUND;
131: x_rtg_header_rec := l_rtg_header_rec;
132: x_rtg_header_unexp_rec := l_rtg_header_unexp_rec;
133: WHEN OTHERS THEN
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 158: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Writing Rtg Header rec for ' || p_rtg_header_rec.assembly_item_name); END IF;

154: )
155: IS
156: BEGIN
157:
158: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Writing Rtg Header rec for ' || p_rtg_header_rec.assembly_item_name); END IF;
159:
160: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
161: INSERT INTO bom_operational_routings
162: ( assembly_item_id

Line 241: , BOM_Rtg_Globals.Get_User_Id

237: , p_rtg_header_rec.attribute13
238: , p_rtg_header_rec.attribute14
239: , p_rtg_header_rec.attribute15
240: , SYSDATE
241: , BOM_Rtg_Globals.Get_User_Id
242: , SYSDATE
243: , BOM_Rtg_Globals.Get_User_Id
244: , BOM_Rtg_Globals.Get_Login_Id
245: , p_rtg_header_rec.original_system_reference

Line 243: , BOM_Rtg_Globals.Get_User_Id

239: , p_rtg_header_rec.attribute15
240: , SYSDATE
241: , BOM_Rtg_Globals.Get_User_Id
242: , SYSDATE
243: , BOM_Rtg_Globals.Get_User_Id
244: , BOM_Rtg_Globals.Get_Login_Id
245: , p_rtg_header_rec.original_system_reference
246: , Fnd_Global.Conc_Request_Id
247: , Fnd_Global.Conc_Program_Id

Line 244: , BOM_Rtg_Globals.Get_Login_Id

240: , SYSDATE
241: , BOM_Rtg_Globals.Get_User_Id
242: , SYSDATE
243: , BOM_Rtg_Globals.Get_User_Id
244: , BOM_Rtg_Globals.Get_Login_Id
245: , p_rtg_header_rec.original_system_reference
246: , Fnd_Global.Conc_Request_Id
247: , Fnd_Global.Conc_Program_Id
248: , Fnd_Global.Prog_Appl_Id

Line 279: , BOM_Rtg_Globals.Get_User_Id

275: , p_rtg_header_unexp_rec.organization_id
276: , mp.starting_revision
277: , SYSDATE
278: , SYSDATE
279: , BOM_Rtg_Globals.Get_User_Id
280: , SYSDATE
281: , BOM_Rtg_Globals.Get_User_Id
282: , BOM_Rtg_Globals.Get_Login_Id
283: , SYSDATE

Line 281: , BOM_Rtg_Globals.Get_User_Id

277: , SYSDATE
278: , SYSDATE
279: , BOM_Rtg_Globals.Get_User_Id
280: , SYSDATE
281: , BOM_Rtg_Globals.Get_User_Id
282: , BOM_Rtg_Globals.Get_Login_Id
283: , SYSDATE
284: , Fnd_Global.Conc_Request_Id
285: , Fnd_Global.Conc_Program_Id

Line 282: , BOM_Rtg_Globals.Get_Login_Id

278: , SYSDATE
279: , BOM_Rtg_Globals.Get_User_Id
280: , SYSDATE
281: , BOM_Rtg_Globals.Get_User_Id
282: , BOM_Rtg_Globals.Get_Login_Id
283: , SYSDATE
284: , Fnd_Global.Conc_Request_Id
285: , Fnd_Global.Conc_Program_Id
286: , Fnd_Global.Prog_Appl_Id

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

293: AND organization_id = p_rtg_header_unexp_rec.organization_id
294: AND inventory_item_id = p_rtg_header_unexp_rec.assembly_item_id
295: ) ;
296:
297: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
298: ('Creating new routing revision for the created primary routing for the revised item . . . ') ;
299: END IF;
300:
301: END IF ;

Line 342: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN

338: -- CTP, Priority, completion subinventory, completion_locator,
339: -- comcommon routing information, cfm_routing_flag, mixed_model
340: -- map_flag
341: --
342: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
343: Error_Handler.Write_Debug('Updating routing seq '
344: || p_rtg_header_unexp_rec.routing_sequence_id);
345: END IF;
346:

Line 369: , last_updated_by = BOM_Rtg_Globals.Get_User_Id

365: p_rtg_header_rec.total_cycle_time
366: , serialization_start_op =
367: p_rtg_header_rec.ser_start_op_seq -- Added for SSOS (bug 2689249)
368: , last_update_date = SYSDATE
369: , last_updated_by = BOM_Rtg_Globals.Get_User_Id
370: , last_update_login = BOM_Rtg_Globals.Get_Login_Id
371: , attribute_category = p_rtg_header_rec.attribute_category
372: , attribute1 = p_rtg_header_rec.attribute1
373: , attribute2 = p_rtg_header_rec.attribute2

Line 370: , last_update_login = BOM_Rtg_Globals.Get_Login_Id

366: , serialization_start_op =
367: p_rtg_header_rec.ser_start_op_seq -- Added for SSOS (bug 2689249)
368: , last_update_date = SYSDATE
369: , last_updated_by = BOM_Rtg_Globals.Get_User_Id
370: , last_update_login = BOM_Rtg_Globals.Get_Login_Id
371: , attribute_category = p_rtg_header_rec.attribute_category
372: , attribute1 = p_rtg_header_rec.attribute1
373: , attribute2 = p_rtg_header_rec.attribute2
374: , attribute3 = p_rtg_header_rec.attribute3

Line 470: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN

466: );
467: END IF;
468:
469:
470: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
471: Error_Handler.Write_Debug('Calling MODAL_DELETE.DELETE_MANAGER ') ;
472: Error_Handler.Write_Debug('Rtg_Seq ID ' || to_char(l_rtg_header_unexp_rec.routing_sequence_id) ) ;
473: Error_Handler.Write_Debug('Alt '|| l_rtg_header_rec.alternate_routing_code ) ;
474: Error_Handler.Write_Debug('Routing Type '|| to_char(l_rtg_header_unexp_rec.routing_type) ) ;

Line 496: user_id => BOM_Rtg_Globals.Get_User_Id

492: ent_alt_designator=>
493: l_rtg_header_rec.alternate_routing_code,
494: ent_comp_seq_id => NULL,
495: ent_op_seq_id => NULL,
496: user_id => BOM_Rtg_Globals.Get_User_Id
497: );
498:
499: x_mesg_token_tbl := l_mesg_token_tbl;
500:

Line 523: IF p_rtg_header_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE

519: IS
520: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;
521: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
522: BEGIN
523: IF p_rtg_header_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE
524: THEN
525: Insert_Row
526: ( p_rtg_header_rec => p_rtg_header_rec
527: , p_rtg_header_unexp_rec => p_rtg_header_unexp_rec

Line 532: BOM_Rtg_Globals.G_OPR_UPDATE

528: , x_mesg_token_Tbl => l_mesg_token_tbl
529: , x_return_Status => l_return_status
530: );
531: ELSIF p_rtg_header_rec.transaction_type =
532: BOM_Rtg_Globals.G_OPR_UPDATE
533: THEN
534: Update_Row
535: ( p_rtg_header_rec => p_rtg_header_rec
536: , p_rtg_header_unexp_rec => p_rtg_header_unexp_rec

Line 542: BOM_Rtg_Globals.G_OPR_DELETE

538: , x_return_Status => l_return_status
539: );
540:
541: ELSIF p_rtg_header_rec.transaction_type =
542: BOM_Rtg_Globals.G_OPR_DELETE
543: THEN
544: Delete_Row
545: ( p_rtg_header_rec => p_rtg_header_rec
546: , p_rtg_header_unexp_rec => p_rtg_header_unexp_rec