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_OP_RES_UTIL dependencies on BOM_RTG_GLOBALS

Line 125: WHERE (( l_bo_id = BOM_Rtg_Globals.G_ECO_BO

121: , p_acd_type NUMBER )
122: IS
123:
124: SELECT * FROM BOM_OPERATION_RESOURCES
125: WHERE (( l_bo_id = BOM_Rtg_Globals.G_ECO_BO
126: AND NVL(ACD_TYPE, FND_API.G_MISS_NUM)
127: = NVL(p_acd_type,FND_API.G_MISS_NUM))
128: OR
129: ( l_bo_id = BOM_Rtg_Globals.G_RTG_BO

Line 129: ( l_bo_id = BOM_Rtg_Globals.G_RTG_BO

125: WHERE (( l_bo_id = BOM_Rtg_Globals.G_ECO_BO
126: AND NVL(ACD_TYPE, FND_API.G_MISS_NUM)
127: = NVL(p_acd_type,FND_API.G_MISS_NUM))
128: OR
129: ( l_bo_id = BOM_Rtg_Globals.G_RTG_BO
130: /* AND ACD_TYPE IS NULL
131: Bug 6378493 Commenting out the condition on the parameter ACD_type */
132: )
133: )

Line 144: l_bo_id := BOM_Rtg_Globals.Get_Bo_Identifier ;

140:
141: BEGIN
142:
143: x_mesg_token_tbl := p_mesg_token_tbl;
144: l_bo_id := BOM_Rtg_Globals.Get_Bo_Identifier ;
145:
146: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
147: ('Querying an operation resource record : Res Seq Number ' || to_char(p_resource_sequence_number) || '. . . ' ) ;
148: END IF ;

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

142:
143: x_mesg_token_tbl := p_mesg_token_tbl;
144: l_bo_id := BOM_Rtg_Globals.Get_Bo_Identifier ;
145:
146: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
147: ('Querying an operation resource record : Res Seq Number ' || to_char(p_resource_sequence_number) || '. . . ' ) ;
148: END IF ;
149:
150: -- Calling from revised operation resource with

Line 153: IF l_bo_id = BOM_Rtg_Globals.G_ECO_BO AND

149:
150: -- Calling from revised operation resource with
151: -- transaction type : Create, Acd_Type: Change or Disable
152: -- to get the original value and defaulting
153: IF l_bo_id = BOM_Rtg_Globals.G_ECO_BO AND
154: p_acd_type = FND_API.G_MISS_NUM
155: THEN
156: l_bo_id := BOM_Rtg_Globals.G_RTG_BO ;
157:

Line 156: l_bo_id := BOM_Rtg_Globals.G_RTG_BO ;

152: -- to get the original value and defaulting
153: IF l_bo_id = BOM_Rtg_Globals.G_ECO_BO AND
154: p_acd_type = FND_API.G_MISS_NUM
155: THEN
156: l_bo_id := BOM_Rtg_Globals.G_RTG_BO ;
157:
158: begin
159: SELECT old_operation_sequence_id
160: INTO l_operation_sequence_id

Line 221: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Finished querying and assigning operation record . . .') ;

217: l_rev_op_resource_rec.Attribute14 := op_res_rec.ATTRIBUTE14 ;
218: l_rev_op_resource_rec.Attribute15 := op_res_rec.ATTRIBUTE15 ;
219: l_rev_op_resource_rec.Original_System_Reference := op_res_rec.ORIGINAL_SYSTEM_REFERENCE ;
220:
221: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Finished querying and assigning operation record . . .') ;
222: END IF ;
223:
224: x_return_status := BOM_Rtg_Globals.G_RECORD_FOUND ;
225: x_rev_op_resource_rec := l_rev_op_resource_rec ;

Line 224: x_return_status := BOM_Rtg_Globals.G_RECORD_FOUND ;

220:
221: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Finished querying and assigning operation record . . .') ;
222: END IF ;
223:
224: x_return_status := BOM_Rtg_Globals.G_RECORD_FOUND ;
225: x_rev_op_resource_rec := l_rev_op_resource_rec ;
226: x_rev_op_res_unexp_rec := l_rev_op_res_unexp_rec ;
227:
228: ELSE

Line 229: x_return_status := BOM_Rtg_Globals.G_RECORD_NOT_FOUND ;

225: x_rev_op_resource_rec := l_rev_op_resource_rec ;
226: x_rev_op_res_unexp_rec := l_rev_op_res_unexp_rec ;
227:
228: ELSE
229: x_return_status := BOM_Rtg_Globals.G_RECORD_NOT_FOUND ;
230: x_rev_op_resource_rec := l_rev_op_resource_rec ;
231: x_rev_op_res_unexp_rec := l_rev_op_res_unexp_rec ;
232:
233: END IF ;

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

238: END IF ;
239:
240: EXCEPTION
241: WHEN OTHERS THEN
242: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
243: ('Some unknown error in Query Row. . .' || SQLERRM );
244: END IF ;
245:
246: l_err_text := G_PKG_NAME || ' Utility (Op Resource Query Row) '

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

345: l_rev_op_res_unexp_rec := p_rev_op_res_unexp_rec ;
346: l_return_status := FND_API.G_RET_STS_SUCCESS ;
347: x_return_status := FND_API.G_RET_STS_SUCCESS ;
348:
349: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
350: ('Performing Database Writes . . .') ;
351: END IF ;
352:
353:

Line 354: IF l_rev_op_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE THEN

350: ('Performing Database Writes . . .') ;
351: END IF ;
352:
353:
354: IF l_rev_op_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE THEN
355: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
356: ('Operatin Resource : Executing Insert Row. . . ') ;
357: END IF;
358:

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

351: END IF ;
352:
353:
354: IF l_rev_op_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE THEN
355: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
356: ('Operatin Resource : Executing Insert Row. . . ') ;
357: END IF;
358:
359: Insert_Row

Line 367: ELSIF l_rev_op_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_UPDATE

363: , x_mesg_token_tbl => l_mesg_token_tbl
364: ) ;
365:
366:
367: ELSIF l_rev_op_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_UPDATE
368: THEN
369: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
370: ('Operatin Resource : Executing Update Row. . . ') ;
371: END IF ;

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

365:
366:
367: ELSIF l_rev_op_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_UPDATE
368: THEN
369: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
370: ('Operatin Resource : Executing Update Row. . . ') ;
371: END IF ;
372:
373: Update_Row

Line 380: ELSIF l_rev_op_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_DELETE

376: , x_return_status => l_return_status
377: , x_mesg_token_tbl => l_mesg_token_tbl
378: ) ;
379:
380: ELSIF l_rev_op_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_DELETE
381: THEN
382:
383: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
384: ('Operatin Resource : Executing Delete Row. . . ') ;

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

379:
380: ELSIF l_rev_op_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_DELETE
381: THEN
382:
383: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
384: ('Operatin Resource : Executing Delete Row. . . ') ;
385: END IF ;
386:
387: Delete_Row

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

400: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl ;
401:
402: EXCEPTION
403: WHEN OTHERS THEN
404: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
405: ('Some unknown error in Perform Writes . . .' || SQLERRM );
406: END IF ;
407:
408: l_err_text := G_PKG_NAME || ' Utility (Perform Writes) '

Line 513: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By

509: , p_rev_op_resource_rec.usage_rate_or_amount_inverse
510: , p_rev_op_resource_rec.basis_type
511: , p_rev_op_resource_rec.schedule_flag
512: , SYSDATE -- Last Update Date
513: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By
514: , SYSDATE -- Creation Date
515: , BOM_Rtg_Globals.Get_User_Id -- Created By
516: , BOM_Rtg_Globals.Get_Login_Id -- Last Update Login
517: , p_rev_op_resource_rec.resource_offset_percent

Line 515: , BOM_Rtg_Globals.Get_User_Id -- Created By

511: , p_rev_op_resource_rec.schedule_flag
512: , SYSDATE -- Last Update Date
513: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By
514: , SYSDATE -- Creation Date
515: , BOM_Rtg_Globals.Get_User_Id -- Created By
516: , BOM_Rtg_Globals.Get_Login_Id -- Last Update Login
517: , p_rev_op_resource_rec.resource_offset_percent
518: , p_rev_op_resource_rec.autocharge_type
519: , p_rev_op_resource_rec.attribute_category

Line 516: , BOM_Rtg_Globals.Get_Login_Id -- Last Update Login

512: , SYSDATE -- Last Update Date
513: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By
514: , SYSDATE -- Creation Date
515: , BOM_Rtg_Globals.Get_User_Id -- Created By
516: , BOM_Rtg_Globals.Get_Login_Id -- Last Update Login
517: , p_rev_op_resource_rec.resource_offset_percent
518: , p_rev_op_resource_rec.autocharge_type
519: , p_rev_op_resource_rec.attribute_category
520: , p_rev_op_resource_rec.attribute1

Line 536: , BOM_Rtg_Globals.Get_Prog_AppId -- Application Id

532: , p_rev_op_resource_rec.attribute13
533: , p_rev_op_resource_rec.attribute14
534: , p_rev_op_resource_rec.attribute15
535: , Fnd_Global.Conc_Request_Id -- Request Id
536: , BOM_Rtg_Globals.Get_Prog_AppId -- Application Id
537: , BOM_Rtg_Globals.Get_Prog_Id -- Program Id
538: , SYSDATE -- program_update_date
539: , p_rev_op_resource_rec.schedule_sequence_number
540: , nvl(p_rev_op_resource_rec.substitute_group_number, p_rev_op_res_unexp_rec.substitute_group_number)

Line 537: , BOM_Rtg_Globals.Get_Prog_Id -- Program Id

533: , p_rev_op_resource_rec.attribute14
534: , p_rev_op_resource_rec.attribute15
535: , Fnd_Global.Conc_Request_Id -- Request Id
536: , BOM_Rtg_Globals.Get_Prog_AppId -- Application Id
537: , BOM_Rtg_Globals.Get_Prog_Id -- Program Id
538: , SYSDATE -- program_update_date
539: , p_rev_op_resource_rec.schedule_sequence_number
540: , nvl(p_rev_op_resource_rec.substitute_group_number, p_rev_op_res_unexp_rec.substitute_group_number)
541: , p_rev_op_resource_rec.principle_flag

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

548:
549: EXCEPTION
550:
551: WHEN OTHERS THEN
552: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
553: ('Unexpected Error occured in Insert . . .' || SQLERRM);
554: END IF;
555:
556: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 602: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Performing update operation . . .') ;

598: BEGIN
599:
600: x_return_status := FND_API.G_RET_STS_SUCCESS ;
601:
602: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Performing update operation . . .') ;
603: END IF ;
604:
605: UPDATE BOM_OPERATION_RESOURCES
606: SET

Line 616: , last_updated_by = BOM_Rtg_Globals.Get_User_Id /* Last Updated By */

612: , usage_rate_or_amount_inverse = p_rev_op_resource_rec.usage_rate_or_amount_inverse
613: , basis_type = p_rev_op_resource_rec.basis_type
614: , schedule_flag = p_rev_op_resource_rec.schedule_flag
615: , last_update_date = SYSDATE /* Last Update Date */
616: , last_updated_by = BOM_Rtg_Globals.Get_User_Id /* Last Updated By */
617: , last_update_login = BOM_Rtg_Globals.Get_Login_Id /* Last Update Login */
618: , resource_offset_percent = p_rev_op_resource_rec.resource_offset_percent
619: , autocharge_type = p_rev_op_resource_rec.autocharge_type
620: , attribute_category = p_rev_op_resource_rec.attribute_category

Line 617: , last_update_login = BOM_Rtg_Globals.Get_Login_Id /* Last Update Login */

613: , basis_type = p_rev_op_resource_rec.basis_type
614: , schedule_flag = p_rev_op_resource_rec.schedule_flag
615: , last_update_date = SYSDATE /* Last Update Date */
616: , last_updated_by = BOM_Rtg_Globals.Get_User_Id /* Last Updated By */
617: , last_update_login = BOM_Rtg_Globals.Get_Login_Id /* Last Update Login */
618: , resource_offset_percent = p_rev_op_resource_rec.resource_offset_percent
619: , autocharge_type = p_rev_op_resource_rec.autocharge_type
620: , attribute_category = p_rev_op_resource_rec.attribute_category
621: , attribute1 = p_rev_op_resource_rec.attribute1

Line 636: , program_application_id = BOM_Rtg_Globals.Get_Prog_AppId /* Application Id */

632: , attribute12 = p_rev_op_resource_rec.attribute12
633: , attribute13 = p_rev_op_resource_rec.attribute13
634: , attribute14 = p_rev_op_resource_rec.attribute14
635: , attribute15 = p_rev_op_resource_rec.attribute15
636: , program_application_id = BOM_Rtg_Globals.Get_Prog_AppId /* Application Id */
637: , program_id = BOM_Rtg_Globals.Get_Prog_Id /* Program Id */
638: , program_update_date = SYSDATE /* program_update_date */
639: , schedule_seq_num = p_rev_op_resource_rec.schedule_sequence_number
640: , substitute_group_num = nvl(p_rev_op_resource_rec.substitute_group_number, p_rev_op_res_unexp_rec.substitute_group_number)

Line 637: , program_id = BOM_Rtg_Globals.Get_Prog_Id /* Program Id */

633: , attribute13 = p_rev_op_resource_rec.attribute13
634: , attribute14 = p_rev_op_resource_rec.attribute14
635: , attribute15 = p_rev_op_resource_rec.attribute15
636: , program_application_id = BOM_Rtg_Globals.Get_Prog_AppId /* Application Id */
637: , program_id = BOM_Rtg_Globals.Get_Prog_Id /* Program Id */
638: , program_update_date = SYSDATE /* program_update_date */
639: , schedule_seq_num = p_rev_op_resource_rec.schedule_sequence_number
640: , substitute_group_num = nvl(p_rev_op_resource_rec.substitute_group_number, p_rev_op_res_unexp_rec.substitute_group_number)
641: , principle_flag = p_rev_op_resource_rec.principle_flag

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

649:
650:
651: EXCEPTION
652: WHEN OTHERS THEN
653: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
654: ('Unexpected Error occured in Update . . .' || SQLERRM);
655: END IF;
656:
657: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 748: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Finished deleting revised operation record . . .') ;

744: END IF ;
745:
746: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
747:
748: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Finished deleting revised operation record . . .') ;
749: END IF ;
750:
751:
752: EXCEPTION

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

750:
751:
752: EXCEPTION
753: WHEN OTHERS THEN
754: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
755: ('Unexpected Error occured in Delete . . .' || SQLERRM);
756: END IF;
757:
758: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)