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 ERROR_HANDLER

Line 152: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

148: *********************************************************************/
149: PROCEDURE Insert_Row
150: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
151: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
152: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
153: , x_return_Status IN OUT NOCOPY VARCHAR2
154: )
155: IS
156: BEGIN

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 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 307: Error_Handler.Add_Error_Token

303: x_return_status := FND_API.G_RET_STS_SUCCESS;
304:
305: EXCEPTION
306: WHEN OTHERS THEN
307: Error_Handler.Add_Error_Token
308: ( p_message_name => NULL
309: , p_message_text => G_PKG_NAME ||
310: ' :Inserting Record ' ||
311: SQLERRM

Line 330: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

326: *********************************************************************/
327: PROCEDURE Update_Row
328: ( p_RTG_header_rec IN Bom_Rtg_Pub.RTG_Header_Rec_Type
329: , p_RTG_header_unexp_rec IN Bom_Rtg_Pub.RTG_Header_Unexposed_Rec_Type
330: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
331: , x_return_Status IN OUT NOCOPY VARCHAR2
332: )
333: IS
334: BEGIN

Line 343: Error_Handler.Write_Debug('Updating routing seq '

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:
347: UPDATE bom_operational_routings

Line 412: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

408: *********************************************************************/
409: PROCEDURE Delete_Row
410: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
411: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
412: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
413: , x_return_Status IN OUT NOCOPY VARCHAR2
414: )
415: IS
416: Cursor CheckGroup is

Line 429: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

425: := p_rtg_header_unexp_rec;
426: l_rtg_header_rec Bom_Rtg_Pub.rtg_header_Rec_Type
427: := p_rtg_header_rec;
428: l_dg_sequence_id NUMBER;
429: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
430:
431: BEGIN
432: x_return_status := FND_API.G_RET_STS_SUCCESS;
433:

Line 437: Error_Handler.Add_Error_Token

433:
434: FOR DG IN CheckGroup
435: LOOP
436: IF DG.delete_type <> 3 /* Routing */ then
437: Error_Handler.Add_Error_Token
438: ( p_message_name =>
439: 'BOM_DUPLICATE_DELETE_GROUP'
440: , p_mesg_token_tbl =>
441: l_mesg_token_Tbl

Line 461: Error_Handler.Add_Error_Token

457: THEN
458: l_dg_sequence_id := l_rtg_header_unexp_rec.DG_Sequence_Id;
459: ELSE
460: l_dg_sequence_id := NULL;
461: Error_Handler.Add_Error_Token
462: ( p_message_name => 'NEW_DELETE_GROUP'
463: , p_mesg_token_tbl => l_mesg_token_Tbl
464: , x_mesg_token_tbl => l_mesg_token_tbl
465: , p_message_type => 'W' /* Warning */

Line 471: Error_Handler.Write_Debug('Calling MODAL_DELETE.DELETE_MANAGER ') ;

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) ) ;
475: Error_Handler.Write_Debug('Org'|| to_char(l_rtg_header_unexp_rec.organization_id) ) ;

Line 472: Error_Handler.Write_Debug('Rtg_Seq ID ' || to_char(l_rtg_header_unexp_rec.routing_sequence_id) ) ;

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) ) ;
475: Error_Handler.Write_Debug('Org'|| to_char(l_rtg_header_unexp_rec.organization_id) ) ;
476:

Line 473: Error_Handler.Write_Debug('Alt '|| l_rtg_header_rec.alternate_routing_code ) ;

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) ) ;
475: Error_Handler.Write_Debug('Org'|| to_char(l_rtg_header_unexp_rec.organization_id) ) ;
476:
477: END IF;

Line 474: Error_Handler.Write_Debug('Routing Type '|| to_char(l_rtg_header_unexp_rec.routing_type) ) ;

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) ) ;
475: Error_Handler.Write_Debug('Org'|| to_char(l_rtg_header_unexp_rec.organization_id) ) ;
476:
477: END IF;
478:

Line 475: Error_Handler.Write_Debug('Org'|| to_char(l_rtg_header_unexp_rec.organization_id) ) ;

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) ) ;
475: Error_Handler.Write_Debug('Org'|| to_char(l_rtg_header_unexp_rec.organization_id) ) ;
476:
477: END IF;
478:
479:

Line 516: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

512: *********************************************************************/
513: PROCEDURE Perform_Writes
514: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
515: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
516: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
517: , x_return_status IN OUT NOCOPY VARCHAR2
518: )
519: IS
520: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 520: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;

516: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
517: , x_return_status IN OUT NOCOPY VARCHAR2
518: )
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