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.ENG_CHANGE_LINE_UTIL dependencies on BOM_GLOBALS

Line 81: IF BOM_Globals.Get_Debug = 'Y' THEN

77:
78:
79: BEGIN
80:
81: IF BOM_Globals.Get_Debug = 'Y' THEN
82: Error_Handler.Write_Debug ('Querying a change line record . . . ' ) ;
83: Error_Handler.Write_Debug (' : line sequence number ' || p_line_sequence_number);
84: Error_Handler.Write_Debug (' : change notice ' || p_change_notice );
85: Error_Handler.Write_Debug (' : organization_id ' || to_char( p_organization_id ));

Line 154: IF BOM_Globals.Get_Debug = 'Y' THEN

150: l_change_line_rec.Attribute14 := cl_rec.ATTRIBUTE14 ;
151: l_change_line_rec.Attribute15 := cl_rec.ATTRIBUTE15 ;
152: */
153:
154: IF BOM_Globals.Get_Debug = 'Y' THEN
155: Error_Handler.Write_Debug('Finished querying chage line record . . .') ;
156: END IF ;
157:
158: x_return_status := BOM_Globals.G_RECORD_FOUND ;

Line 158: x_return_status := BOM_Globals.G_RECORD_FOUND ;

154: IF BOM_Globals.Get_Debug = 'Y' THEN
155: Error_Handler.Write_Debug('Finished querying chage line record . . .') ;
156: END IF ;
157:
158: x_return_status := BOM_Globals.G_RECORD_FOUND ;
159: x_change_line_rec := l_change_line_rec ;
160: x_change_line_unexp_rec := l_change_line_unexp_rec;
161:
162: ELSE

Line 164: x_return_status := BOM_Globals.G_RECORD_NOT_FOUND ;

160: x_change_line_unexp_rec := l_change_line_unexp_rec;
161:
162: ELSE
163:
164: x_return_status := BOM_Globals.G_RECORD_NOT_FOUND ;
165: x_change_line_rec := l_change_line_rec ;
166: x_change_line_unexp_rec := l_change_line_unexp_rec ;
167:
168: END IF ;

Line 237: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

233: l_change_line_unexp_rec := p_change_line_unexp_rec ;
234: l_return_status := FND_API.G_RET_STS_SUCCESS ;
235: x_return_status := FND_API.G_RET_STS_SUCCESS ;
236:
237: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
238: ('Performing Database Writes . . .') ;
239: END IF ;
240:
241:

Line 242: IF l_change_line_rec.transaction_type = BOM_Globals.G_OPR_CREATE THEN

238: ('Performing Database Writes . . .') ;
239: END IF ;
240:
241:
242: IF l_change_line_rec.transaction_type = BOM_Globals.G_OPR_CREATE THEN
243:
244: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
245: ('Change Line: Executing Insert Row. . . ') ;
246: END IF;

Line 244: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

240:
241:
242: IF l_change_line_rec.transaction_type = BOM_Globals.G_OPR_CREATE THEN
243:
244: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
245: ('Change Line: Executing Insert Row. . . ') ;
246: END IF;
247:
248:

Line 262: ELSIF l_change_line_rec.transaction_type = BOM_Globals.G_OPR_UPDATE

258: l_return_status := l_temp_return_status ;
259: l_mesg_token_Tbl := l_temp_Mesg_Token_Tbl ;
260: END IF ;
261:
262: ELSIF l_change_line_rec.transaction_type = BOM_Globals.G_OPR_UPDATE
263: THEN
264:
265:
266: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

Line 266: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

262: ELSIF l_change_line_rec.transaction_type = BOM_Globals.G_OPR_UPDATE
263: THEN
264:
265:
266: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
267: ('Change Line: Executing Update Row. . . ') ;
268: END IF ;
269:
270: Update_Row

Line 285: ELSIF l_change_line_rec.transaction_type = BOM_Globals.G_OPR_DELETE

281: END IF ;
282:
283:
284:
285: ELSIF l_change_line_rec.transaction_type = BOM_Globals.G_OPR_DELETE
286: THEN
287:
288: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
289: ('Change Line: Executing Delete Row. . . ') ;

Line 288: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

284:
285: ELSIF l_change_line_rec.transaction_type = BOM_Globals.G_OPR_DELETE
286: THEN
287:
288: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
289: ('Change Line: Executing Delete Row. . . ') ;
290: END IF ;
291:
292: Delete_Row

Line 316: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

312:
313: EXCEPTION
314: WHEN OTHERS THEN
315:
316: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
317: ('Some unknown error in Perform Writes . . .' || SQLERRM );
318: END IF ;
319:
320: l_err_text := G_PKG_NAME || ' Utility (Perform Writes) '

Line 436: , BOM_Globals.Get_User_Id -- Last Updated By

432: , p_change_line_unexp_rec.pk3_value
433: , p_change_line_unexp_rec.pk4_value
434: , p_change_line_unexp_rec.pk5_value
435: , SYSDATE -- Last Update Date
436: , BOM_Globals.Get_User_Id -- Last Updated By
437: , BOM_Globals.Get_Login_Id -- Last Update Login
438: , SYSDATE -- Creation Date
439: , BOM_Globals.Get_User_Id -- Created By
440: , NULL -- Request Id

Line 437: , BOM_Globals.Get_Login_Id -- Last Update Login

433: , p_change_line_unexp_rec.pk4_value
434: , p_change_line_unexp_rec.pk5_value
435: , SYSDATE -- Last Update Date
436: , BOM_Globals.Get_User_Id -- Last Updated By
437: , BOM_Globals.Get_Login_Id -- Last Update Login
438: , SYSDATE -- Creation Date
439: , BOM_Globals.Get_User_Id -- Created By
440: , NULL -- Request Id
441: , BOM_Globals.Get_Prog_AppId -- Application Id

Line 439: , BOM_Globals.Get_User_Id -- Created By

435: , SYSDATE -- Last Update Date
436: , BOM_Globals.Get_User_Id -- Last Updated By
437: , BOM_Globals.Get_Login_Id -- Last Update Login
438: , SYSDATE -- Creation Date
439: , BOM_Globals.Get_User_Id -- Created By
440: , NULL -- Request Id
441: , BOM_Globals.Get_Prog_AppId -- Application Id
442: , BOM_Globals.Get_Prog_Id -- Program Id
443: , SYSDATE -- program_update_date

Line 441: , BOM_Globals.Get_Prog_AppId -- Application Id

437: , BOM_Globals.Get_Login_Id -- Last Update Login
438: , SYSDATE -- Creation Date
439: , BOM_Globals.Get_User_Id -- Created By
440: , NULL -- Request Id
441: , BOM_Globals.Get_Prog_AppId -- Application Id
442: , BOM_Globals.Get_Prog_Id -- Program Id
443: , SYSDATE -- program_update_date
444: , p_change_line_rec.original_system_reference
445: , p_change_line_unexp_rec.Approval_Status_Type --Added as it is mandatory 18-6-2003

Line 442: , BOM_Globals.Get_Prog_Id -- Program Id

438: , SYSDATE -- Creation Date
439: , BOM_Globals.Get_User_Id -- Created By
440: , NULL -- Request Id
441: , BOM_Globals.Get_Prog_AppId -- Application Id
442: , BOM_Globals.Get_Prog_Id -- Program Id
443: , SYSDATE -- program_update_date
444: , p_change_line_rec.original_system_reference
445: , p_change_line_unexp_rec.Approval_Status_Type --Added as it is mandatory 18-6-2003
446: ,p_change_line_rec. Required_Flag

Line 467: , BOM_Globals.Get_User_Id

463: )
464: SELECT p_change_line_unexp_rec.change_line_id
465: , lang.language_code
466: , USERENV('LANG')
467: , BOM_Globals.Get_User_Id
468: , SYSDATE
469: , SYSDATE
470: , BOM_Globals.Get_User_Id
471: , BOM_Globals.Get_Login_Id

Line 470: , BOM_Globals.Get_User_Id

466: , USERENV('LANG')
467: , BOM_Globals.Get_User_Id
468: , SYSDATE
469: , SYSDATE
470: , BOM_Globals.Get_User_Id
471: , BOM_Globals.Get_Login_Id
472: , p_change_line_rec.name
473: , p_change_line_rec.description
474: FROM FND_LANGUAGES lang

Line 471: , BOM_Globals.Get_Login_Id

467: , BOM_Globals.Get_User_Id
468: , SYSDATE
469: , SYSDATE
470: , BOM_Globals.Get_User_Id
471: , BOM_Globals.Get_Login_Id
472: , p_change_line_rec.name
473: , p_change_line_rec.description
474: FROM FND_LANGUAGES lang
475: WHERE lang.installed_flag in ('I', 'B')

Line 483: IF BOM_Globals.get_debug = 'Y'

479: AND tl.language = lang.language_code
480: );
481:
482:
483: IF BOM_Globals.get_debug = 'Y'
484: THEN
485: error_handler.write_debug('Change Line: '|| to_char(p_change_line_unexp_rec.change_line_id)
486: ||' has been created. ' );
487: END IF;

Line 507: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

503:
504: WHEN OTHERS THEN
505:
506:
507: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
508: ('Unexpected Error occured in Insert . . .' || SQLERRM);
509: END IF;
510:
511: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 560: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Performing update change line . . .') ;

556:
557: l_return_status := FND_API.G_RET_STS_SUCCESS ;
558: x_return_status := FND_API.G_RET_STS_SUCCESS ;
559:
560: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Performing update change line . . .') ;
561: END IF ;
562:
563: UPDATE ENG_CHANGE_LINES
564: SET last_update_date = SYSDATE

Line 565: , last_updated_by = BOM_Globals.Get_User_Id

561: END IF ;
562:
563: UPDATE ENG_CHANGE_LINES
564: SET last_update_date = SYSDATE
565: , last_updated_by = BOM_Globals.Get_User_Id
566: , last_update_login = BOM_Globals.Get_Login_Id
567: , change_type_id = p_change_line_unexp_rec.change_type_id
568: , status_code = p_change_line_unexp_rec.status_code
569: , sequence_number = p_change_line_rec.sequence_number

Line 566: , last_update_login = BOM_Globals.Get_Login_Id

562:
563: UPDATE ENG_CHANGE_LINES
564: SET last_update_date = SYSDATE
565: , last_updated_by = BOM_Globals.Get_User_Id
566: , last_update_login = BOM_Globals.Get_Login_Id
567: , change_type_id = p_change_line_unexp_rec.change_type_id
568: , status_code = p_change_line_unexp_rec.status_code
569: , sequence_number = p_change_line_rec.sequence_number
570: , need_by_date = p_change_line_rec.need_by_date

Line 586: , last_updated_by = BOM_Globals.Get_User_Id

582: WHERE change_line_id = p_change_line_unexp_rec.change_line_id ;
583:
584: UPDATE ENG_CHANGE_LINES_TL
585: SET last_update_date = SYSDATE
586: , last_updated_by = BOM_Globals.Get_User_Id
587: , last_update_login = BOM_Globals.Get_Login_Id
588: , name = p_change_line_rec.name
589: , description = p_change_line_rec.description
590: WHERE change_line_id = p_change_line_unexp_rec.change_line_id

Line 587: , last_update_login = BOM_Globals.Get_Login_Id

583:
584: UPDATE ENG_CHANGE_LINES_TL
585: SET last_update_date = SYSDATE
586: , last_updated_by = BOM_Globals.Get_User_Id
587: , last_update_login = BOM_Globals.Get_Login_Id
588: , name = p_change_line_rec.name
589: , description = p_change_line_rec.description
590: WHERE change_line_id = p_change_line_unexp_rec.change_line_id
591: AND USERENV('LANG') = language;

Line 598: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

594:
595: EXCEPTION
596: WHEN OTHERS THEN
597:
598: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
599: ('Unexpected Error occured in Update . . .' || SQLERRM);
600: END IF;
601:
602: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 680: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

676: EXCEPTION
677:
678: WHEN OTHERS THEN
679:
680: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
681: ('Unexpected Error occured in Delete . . .' || SQLERRM);
682: END IF;
683:
684: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1260: SELECT Nvl(ALTERNATE_BOM_DESIGNATOR,bom_globals.retrieve_message('BOM','BOM_PRIMARY'))

1256: l_subject_url := l_csd.subject_url;
1257: IF (l_csd.entity_name = 'EGO_STRUCTURE_NAME')
1258: THEN
1259: BEGIN
1260: SELECT Nvl(ALTERNATE_BOM_DESIGNATOR,bom_globals.retrieve_message('BOM','BOM_PRIMARY'))
1261: into l_structure_name
1262: FROM BOM_BILL_OF_MATERIALS
1263: WHERE bill_sequence_id = l_csd.pk1_value;
1264: if (l_structure_name IS NOT NULL) THEN