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

Line 193: WHERE (( l_bo_id = BOM_Rtg_Globals.G_ECO_BO )

189: )
190: IS
191:
192: SELECT * FROM BOM_OPERATION_SEQUENCES
193: WHERE (( l_bo_id = BOM_Rtg_Globals.G_ECO_BO )
194: -- AND implementation_date IS NULL )
195: OR (l_bo_id = BOM_Rtg_Globals.G_RTG_BO
196: AND implementation_date IS NOT NULL )
197: )

Line 195: OR (l_bo_id = BOM_Rtg_Globals.G_RTG_BO

191:
192: SELECT * FROM BOM_OPERATION_SEQUENCES
193: WHERE (( l_bo_id = BOM_Rtg_Globals.G_ECO_BO )
194: -- AND implementation_date IS NULL )
195: OR (l_bo_id = BOM_Rtg_Globals.G_RTG_BO
196: AND implementation_date IS NOT NULL )
197: )
198: AND ( ( NVL(OPERATION_TYPE,1) = 1 AND -- Added nvl for bug 2856314
199: EFFECTIVITY_DATE = p_effectivity_date -- Changed for bug 2647027

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

211:
212:
213: BEGIN
214:
215: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
216: Error_Handler.Write_Debug
217: ('Querying an operation sequence record : Seq Number '
218: || to_char(p_operation_sequence_number) || '. . . ' ) ;
219: Error_Handler.Write_Debug (' : Routing seq id ' || to_char( p_routing_sequence_id));

Line 230: l_bo_id := BOM_Rtg_Globals.Get_Bo_Identifier ;

226: -- dbms_output.put_line('Effective: ' || to_char(p_effectivity_date ));
227: -- dbms_output.put_line('Rtg Seq : ' || to_char(p_routing_Sequence_Id));
228:
229: x_mesg_token_tbl := p_mesg_token_tbl;
230: l_bo_id := BOM_Rtg_Globals.Get_Bo_Identifier ;
231:
232: IF NOT op_seq_csr%ISOPEN
233: THEN
234: OPEN op_seq_csr( p_operation_sequence_number

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

310: l_com_operation_rec.Attribute15 := op_seq_rec.ATTRIBUTE15 ;
311: l_com_operation_rec.Original_System_Reference := op_seq_rec.ORIGINAL_SYSTEM_REFERENCE ;
312: l_com_operation_rec.Long_Description := op_seq_rec.LONG_DESCRIPTION ; -- Added for long description project (Bug 2689249)
313:
314: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Finished querying and assigning operation record . . .') ;
315: END IF ;
316:
317: x_return_status := BOM_Rtg_Globals.G_RECORD_FOUND ;
318: x_com_operation_rec := l_com_operation_rec ;

Line 317: x_return_status := BOM_Rtg_Globals.G_RECORD_FOUND ;

313:
314: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Finished querying and assigning operation record . . .') ;
315: END IF ;
316:
317: x_return_status := BOM_Rtg_Globals.G_RECORD_FOUND ;
318: x_com_operation_rec := l_com_operation_rec ;
319: x_com_op_unexp_rec := l_com_op_unexp_rec ;
320:
321: ELSE

Line 322: x_return_status := BOM_Rtg_Globals.G_RECORD_NOT_FOUND ;

318: x_com_operation_rec := l_com_operation_rec ;
319: x_com_op_unexp_rec := l_com_op_unexp_rec ;
320:
321: ELSE
322: x_return_status := BOM_Rtg_Globals.G_RECORD_NOT_FOUND ;
323: x_com_operation_rec := l_com_operation_rec ;
324: x_com_op_unexp_rec := l_com_op_unexp_rec ;
325:
326: END IF ;

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

511: l_com_op_unexp_rec := p_com_op_unexp_rec ;
512: l_return_status := FND_API.G_RET_STS_SUCCESS ;
513: x_return_status := FND_API.G_RET_STS_SUCCESS ;
514:
515: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
516: ('Performing Database Writes . . .') ;
517: END IF ;
518:
519:

Line 520: IF l_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE THEN

516: ('Performing Database Writes . . .') ;
517: END IF ;
518:
519:
520: IF l_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE THEN
521: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
522: ('Operation Sequence: Executing Insert Row. . . ') ;
523: END IF;
524:

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

517: END IF ;
518:
519:
520: IF l_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE THEN
521: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
522: ('Operation Sequence: Executing Insert Row. . . ') ;
523: END IF;
524:
525: /**************************************************************************

Line 535: IF BOM_Rtg_Globals.Get_Bo_Identifier = BOM_Rtg_Globals.G_ECO_BO

531: -- it is called from Rev Operation Procedure in Private API.
532: --
533: -- Revised Operation
534: --
535: IF BOM_Rtg_Globals.Get_Bo_Identifier = BOM_Rtg_Globals.G_ECO_BO
536: THEN
537: FOR l_rtg_exists_rec IN l_rtg_exists_csr
538: ( p_revised_item_id => p_com_op_unexp_rec.revised_item_id
539: , p_organization_id => p_com_op_unexp_rec.organization_id

Line 610: , p_last_updated_by => BOM_Rtg_Globals.Get_User_Id

606: , p_routing_sequence_id => l_com_op_unexp_rec.routing_sequence_id
607: , p_common_routing_sequence_id => l_com_op_unexp_rec.routing_sequence_id
608: , p_routing_type => l_routing_type
609: , p_last_update_date => SYSDATE
610: , p_last_updated_by => BOM_Rtg_Globals.Get_User_Id
611: , p_creation_date => SYSDATE
612: , p_created_by => BOM_Rtg_Globals.Get_User_Id
613: , p_login_id => BOM_Rtg_Globals.Get_Login_Id
614: , p_revised_item_sequence_id => l_com_op_unexp_rec.revised_item_sequence_id

Line 612: , p_created_by => BOM_Rtg_Globals.Get_User_Id

608: , p_routing_type => l_routing_type
609: , p_last_update_date => SYSDATE
610: , p_last_updated_by => BOM_Rtg_Globals.Get_User_Id
611: , p_creation_date => SYSDATE
612: , p_created_by => BOM_Rtg_Globals.Get_User_Id
613: , p_login_id => BOM_Rtg_Globals.Get_Login_Id
614: , p_revised_item_sequence_id => l_com_op_unexp_rec.revised_item_sequence_id
615: , p_original_system_reference => l_com_operation_rec.original_system_reference
616: , x_Mesg_Token_Tbl => l_temp_mesg_token_Tbl

Line 613: , p_login_id => BOM_Rtg_Globals.Get_Login_Id

609: , p_last_update_date => SYSDATE
610: , p_last_updated_by => BOM_Rtg_Globals.Get_User_Id
611: , p_creation_date => SYSDATE
612: , p_created_by => BOM_Rtg_Globals.Get_User_Id
613: , p_login_id => BOM_Rtg_Globals.Get_Login_Id
614: , p_revised_item_sequence_id => l_com_op_unexp_rec.revised_item_sequence_id
615: , p_original_system_reference => l_com_operation_rec.original_system_reference
616: , x_Mesg_Token_Tbl => l_temp_mesg_token_Tbl
617: , x_return_status => l_temp_return_status

Line 649: , BOM_Rtg_Globals.Get_User_Id

645: , l_com_op_unexp_rec.organization_id
646: , mp.starting_revision
647: , SYSDATE
648: , SYSDATE
649: , BOM_Rtg_Globals.Get_User_Id
650: , SYSDATE
651: , BOM_Rtg_Globals.Get_User_Id
652: , BOM_Rtg_Globals.Get_Login_Id
653: , l_com_operation_rec.eco_name

Line 651: , BOM_Rtg_Globals.Get_User_Id

647: , SYSDATE
648: , SYSDATE
649: , BOM_Rtg_Globals.Get_User_Id
650: , SYSDATE
651: , BOM_Rtg_Globals.Get_User_Id
652: , BOM_Rtg_Globals.Get_Login_Id
653: , l_com_operation_rec.eco_name
654: , SYSDATE
655: , SYSDATE

Line 652: , BOM_Rtg_Globals.Get_Login_Id

648: , SYSDATE
649: , BOM_Rtg_Globals.Get_User_Id
650: , SYSDATE
651: , BOM_Rtg_Globals.Get_User_Id
652: , BOM_Rtg_Globals.Get_Login_Id
653: , l_com_operation_rec.eco_name
654: , SYSDATE
655: , SYSDATE
656: , l_com_op_unexp_rec.revised_item_sequence_id

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

662: AND organization_id = l_com_op_unexp_rec.organization_id
663: AND inventory_item_id = l_com_op_unexp_rec.revised_item_id
664: ) ;
665:
666: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
667: ('Creating new routing revision for the created primary routing for the revised item . . . ') ;
668: END IF;
669:
670:

Line 691: ELSIF l_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_UPDATE

687: l_return_status := l_temp_return_status ;
688: l_mesg_token_Tbl := l_temp_Mesg_Token_Tbl ;
689: END IF ;
690:
691: ELSIF l_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_UPDATE
692: THEN
693: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
694: ('Operatin Sequence: Executing Update Row. . . ') ;
695: END IF ;

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

689: END IF ;
690:
691: ELSIF l_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_UPDATE
692: THEN
693: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
694: ('Operatin Sequence: Executing Update Row. . . ') ;
695: END IF ;
696:
697: Update_Row

Line 704: ELSIF l_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_DELETE

700: , x_return_status => l_return_status
701: , x_mesg_token_tbl => l_mesg_token_tbl
702: ) ;
703:
704: ELSIF l_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_DELETE
705: THEN
706:
707: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
708: ('Operatin Sequence: Executing Delete Row. . . ') ;

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

703:
704: ELSIF l_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_DELETE
705: THEN
706:
707: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
708: ('Operatin Sequence: Executing Delete Row. . . ') ;
709: END IF ;
710:
711: Delete_Row

Line 731: ELSIF l_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CANCEL

727: -- Cancel_Operation procedure is moved to Eng_Globals packate and
728: -- Eng_Globals.Cancel_Operation is called from Rev Op Private Procedure
729:
730:
731: ELSIF l_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CANCEL
732: THEN
733:
734:
735: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

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

731: ELSIF l_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CANCEL
732: THEN
733:
734:
735: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
736: ('Operatin Sequence: Perform Cancel Operation . . .') ;
737: END IF ;
738:
739: Cancel_Operation

Line 743: , p_user_id => BOM_Rtg_Globals.Get_User_Id

739: Cancel_Operation
740: ( p_operation_sequence_id => l_com_op_unexp_rec.operation_sequence_id
741: , p_cancel_comments => l_com_operation_rec.cancel_comments
742: , p_op_seq_num => l_com_operation_rec.operation_sequence_number
743: , p_user_id => BOM_Rtg_Globals.Get_User_Id
744: , p_login_id => BOM_Rtg_Globals.Get_Login_Id
745: , p_prog_id => BOM_Rtg_Globals.Get_Prog_Id
746: , p_prog_appid => BOM_Rtg_Globals.Get_Prog_AppId
747: , x_return_status => l_return_status

Line 744: , p_login_id => BOM_Rtg_Globals.Get_Login_Id

740: ( p_operation_sequence_id => l_com_op_unexp_rec.operation_sequence_id
741: , p_cancel_comments => l_com_operation_rec.cancel_comments
742: , p_op_seq_num => l_com_operation_rec.operation_sequence_number
743: , p_user_id => BOM_Rtg_Globals.Get_User_Id
744: , p_login_id => BOM_Rtg_Globals.Get_Login_Id
745: , p_prog_id => BOM_Rtg_Globals.Get_Prog_Id
746: , p_prog_appid => BOM_Rtg_Globals.Get_Prog_AppId
747: , x_return_status => l_return_status
748: , x_mesg_token_tbl => l_mesg_token_tbl

Line 745: , p_prog_id => BOM_Rtg_Globals.Get_Prog_Id

741: , p_cancel_comments => l_com_operation_rec.cancel_comments
742: , p_op_seq_num => l_com_operation_rec.operation_sequence_number
743: , p_user_id => BOM_Rtg_Globals.Get_User_Id
744: , p_login_id => BOM_Rtg_Globals.Get_Login_Id
745: , p_prog_id => BOM_Rtg_Globals.Get_Prog_Id
746: , p_prog_appid => BOM_Rtg_Globals.Get_Prog_AppId
747: , x_return_status => l_return_status
748: , x_mesg_token_tbl => l_mesg_token_tbl
749: ) ;

Line 746: , p_prog_appid => BOM_Rtg_Globals.Get_Prog_AppId

742: , p_op_seq_num => l_com_operation_rec.operation_sequence_number
743: , p_user_id => BOM_Rtg_Globals.Get_User_Id
744: , p_login_id => BOM_Rtg_Globals.Get_Login_Id
745: , p_prog_id => BOM_Rtg_Globals.Get_Prog_Id
746: , p_prog_appid => BOM_Rtg_Globals.Get_Prog_AppId
747: , x_return_status => l_return_status
748: , x_mesg_token_tbl => l_mesg_token_tbl
749: ) ;
750:

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

747: , x_return_status => l_return_status
748: , x_mesg_token_tbl => l_mesg_token_tbl
749: ) ;
750:
751: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
752: ('Cancel Operation is completed with return status ' || l_return_status ) ;
753: END IF ;
754:
755:

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

766: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl ;
767:
768: EXCEPTION
769: WHEN OTHERS THEN
770: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
771: ('Some unknown error in Perform Writes . . .' || SQLERRM );
772: END IF ;
773:
774: l_err_text := G_PKG_NAME || ' Utility (Perform Writes) '

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

839: -- in release 12 when these all files alongwith the odf will be base
840:
841: x_return_status := FND_API.G_RET_STS_SUCCESS ;
842:
843: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
844: ('Create New Routing for ECO . . .') ;
845: END IF ;
846:
847: --

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

903: , last_updated_by = p_last_updated_by -- Last Updated By
904: , last_update_login = p_login_id -- Last Update Login
905: WHERE revised_item_sequence_id = p_revised_item_sequence_id ;
906:
907: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
908: ('Set created routing sequence id : ' || to_char(p_routing_sequence_id)
909: || ' to the parenet revised item . . .') ;
910: END IF ;
911:

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

911:
912:
913: EXCEPTION
914: WHEN OTHERS THEN
915: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
916: ('Some unknown error in Creating New Routing . . .' || SQLERRM );
917: END IF ;
918:
919: l_err_text := G_PKG_NAME || 'Utilities (Create New Routing) '

Line 1011: , DECODE( BOM_Rtg_Globals.Get_Bo_Identifier

1007: , change_notice)
1008: SELECT p_operation_sequence_id
1009: , resource_seq_num
1010: , resource_id
1011: , DECODE( BOM_Rtg_Globals.Get_Bo_Identifier
1012: , BOM_Rtg_Globals.G_ECO_BO
1013: , 1 -- Acd Type : ADD
1014: , NULL )
1015: , activity_id

Line 1012: , BOM_Rtg_Globals.G_ECO_BO

1008: SELECT p_operation_sequence_id
1009: , resource_seq_num
1010: , resource_id
1011: , DECODE( BOM_Rtg_Globals.Get_Bo_Identifier
1012: , BOM_Rtg_Globals.G_ECO_BO
1013: , 1 -- Acd Type : ADD
1014: , NULL )
1015: , activity_id
1016: , standard_rate_flag

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

1019: , usage_rate_or_amount_inverse
1020: , basis_type
1021: , schedule_flag
1022: , SYSDATE -- Last Update Date
1023: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By
1024: , SYSDATE -- Creation Date
1025: , BOM_Rtg_Globals.Get_User_Id -- Created By
1026: , BOM_Rtg_Globals.Get_User_Id -- Last Update Login
1027: , autocharge_type

Line 1025: , BOM_Rtg_Globals.Get_User_Id -- Created By

1021: , schedule_flag
1022: , SYSDATE -- Last Update Date
1023: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By
1024: , SYSDATE -- Creation Date
1025: , BOM_Rtg_Globals.Get_User_Id -- Created By
1026: , BOM_Rtg_Globals.Get_User_Id -- Last Update Login
1027: , autocharge_type
1028: , attribute_category
1029: , attribute1

Line 1026: , BOM_Rtg_Globals.Get_User_Id -- Last Update Login

1022: , SYSDATE -- Last Update Date
1023: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By
1024: , SYSDATE -- Creation Date
1025: , BOM_Rtg_Globals.Get_User_Id -- Created By
1026: , BOM_Rtg_Globals.Get_User_Id -- Last Update Login
1027: , autocharge_type
1028: , attribute_category
1029: , attribute1
1030: , attribute2

Line 1045: , BOM_Rtg_Globals.Get_Prog_AppId -- Program Application Id

1041: , attribute13
1042: , attribute14
1043: , attribute15
1044: , NULL -- Request Id
1045: , BOM_Rtg_Globals.Get_Prog_AppId -- Program Application Id
1046: , BOM_Rtg_Globals.Get_Prog_Id -- Prog id
1047: , SYSDATE -- Program Update Date
1048: , substitute_group_num
1049: --, resource_seq_num -- Bug 7370692 (Schedule_Seq_num=resource_seq_num)

Line 1046: , BOM_Rtg_Globals.Get_Prog_Id -- Prog id

1042: , attribute14
1043: , attribute15
1044: , NULL -- Request Id
1045: , BOM_Rtg_Globals.Get_Prog_AppId -- Program Application Id
1046: , BOM_Rtg_Globals.Get_Prog_Id -- Prog id
1047: , SYSDATE -- Program Update Date
1048: , substitute_group_num
1049: --, resource_seq_num -- Bug 7370692 (Schedule_Seq_num=resource_seq_num)
1050: , schedule_seq_num --Bug#14550670

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

1114: , basis_type
1115: , schedule_flag
1116: , autocharge_type
1117: , SYSDATE -- Last Update Date
1118: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By
1119: , SYSDATE -- Creation Date
1120: , BOM_Rtg_Globals.Get_User_Id -- Created By
1121: , BOM_Rtg_Globals.Get_User_Id -- Last Update Login
1122: , NULL -- Request Id

Line 1120: , BOM_Rtg_Globals.Get_User_Id -- Created By

1116: , autocharge_type
1117: , SYSDATE -- Last Update Date
1118: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By
1119: , SYSDATE -- Creation Date
1120: , BOM_Rtg_Globals.Get_User_Id -- Created By
1121: , BOM_Rtg_Globals.Get_User_Id -- Last Update Login
1122: , NULL -- Request Id
1123: , BOM_Rtg_Globals.Get_Prog_AppId -- Program Application Id
1124: , BOM_Rtg_Globals.Get_Prog_Id -- Prog id

Line 1121: , BOM_Rtg_Globals.Get_User_Id -- Last Update Login

1117: , SYSDATE -- Last Update Date
1118: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By
1119: , SYSDATE -- Creation Date
1120: , BOM_Rtg_Globals.Get_User_Id -- Created By
1121: , BOM_Rtg_Globals.Get_User_Id -- Last Update Login
1122: , NULL -- Request Id
1123: , BOM_Rtg_Globals.Get_Prog_AppId -- Program Application Id
1124: , BOM_Rtg_Globals.Get_Prog_Id -- Prog id
1125: , SYSDATE -- Program Update Date

Line 1123: , BOM_Rtg_Globals.Get_Prog_AppId -- Program Application Id

1119: , SYSDATE -- Creation Date
1120: , BOM_Rtg_Globals.Get_User_Id -- Created By
1121: , BOM_Rtg_Globals.Get_User_Id -- Last Update Login
1122: , NULL -- Request Id
1123: , BOM_Rtg_Globals.Get_Prog_AppId -- Program Application Id
1124: , BOM_Rtg_Globals.Get_Prog_Id -- Prog id
1125: , SYSDATE -- Program Update Date
1126: , attribute_category
1127: , attribute1

Line 1124: , BOM_Rtg_Globals.Get_Prog_Id -- Prog id

1120: , BOM_Rtg_Globals.Get_User_Id -- Created By
1121: , BOM_Rtg_Globals.Get_User_Id -- Last Update Login
1122: , NULL -- Request Id
1123: , BOM_Rtg_Globals.Get_Prog_AppId -- Program Application Id
1124: , BOM_Rtg_Globals.Get_Prog_Id -- Prog id
1125: , SYSDATE -- Program Update Date
1126: , attribute_category
1127: , attribute1
1128: , attribute2

Line 1145: , DECODE( BOM_Rtg_Globals.Get_Bo_Identifier

1141: , attribute15
1142: , NULL -- principle_flag
1143: , NULL -- setup_id
1144: , NULL -- change_notice
1145: , DECODE( BOM_Rtg_Globals.Get_Bo_Identifier
1146: , BOM_Rtg_Globals.G_ECO_BO
1147: , 1 -- Acd Type : ADD
1148: , NULL )
1149: , NULL -- original_system_reference

Line 1146: , BOM_Rtg_Globals.G_ECO_BO

1142: , NULL -- principle_flag
1143: , NULL -- setup_id
1144: , NULL -- change_notice
1145: , DECODE( BOM_Rtg_Globals.Get_Bo_Identifier
1146: , BOM_Rtg_Globals.G_ECO_BO
1147: , 1 -- Acd Type : ADD
1148: , NULL )
1149: , NULL -- original_system_reference
1150: FROM BOM_STD_SUB_OP_RESOURCES

Line 1169: X_created_by => BOM_Rtg_Globals.Get_User_Id,

1165: X_to_pk2_value => null,
1166: X_to_pk3_value => null,
1167: X_to_pk4_value => null,
1168: X_to_pk5_value => null,
1169: X_created_by => BOM_Rtg_Globals.Get_User_Id,
1170: X_last_update_login => BOM_Rtg_Globals.Get_User_Id,
1171: X_program_application_id => BOM_Rtg_Globals.Get_Prog_AppId,
1172: X_program_id => BOM_Rtg_Globals.Get_Prog_Id,
1173: X_request_id => null

Line 1170: X_last_update_login => BOM_Rtg_Globals.Get_User_Id,

1166: X_to_pk3_value => null,
1167: X_to_pk4_value => null,
1168: X_to_pk5_value => null,
1169: X_created_by => BOM_Rtg_Globals.Get_User_Id,
1170: X_last_update_login => BOM_Rtg_Globals.Get_User_Id,
1171: X_program_application_id => BOM_Rtg_Globals.Get_Prog_AppId,
1172: X_program_id => BOM_Rtg_Globals.Get_Prog_Id,
1173: X_request_id => null
1174: ) ;

Line 1171: X_program_application_id => BOM_Rtg_Globals.Get_Prog_AppId,

1167: X_to_pk4_value => null,
1168: X_to_pk5_value => null,
1169: X_created_by => BOM_Rtg_Globals.Get_User_Id,
1170: X_last_update_login => BOM_Rtg_Globals.Get_User_Id,
1171: X_program_application_id => BOM_Rtg_Globals.Get_Prog_AppId,
1172: X_program_id => BOM_Rtg_Globals.Get_Prog_Id,
1173: X_request_id => null
1174: ) ;
1175:

Line 1172: X_program_id => BOM_Rtg_Globals.Get_Prog_Id,

1168: X_to_pk5_value => null,
1169: X_created_by => BOM_Rtg_Globals.Get_User_Id,
1170: X_last_update_login => BOM_Rtg_Globals.Get_User_Id,
1171: X_program_application_id => BOM_Rtg_Globals.Get_Prog_AppId,
1172: X_program_id => BOM_Rtg_Globals.Get_Prog_Id,
1173: X_request_id => null
1174: ) ;
1175:
1176:

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

1206: )
1207: IS
1208: BEGIN
1209:
1210: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1211: ('Debug1. . . ' ) ;
1212: END IF ;
1213:
1214: INSERT INTO BOM_OPERATION_RESOURCES

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

1268: , usage_rate_or_amount_inverse
1269: , basis_type
1270: , schedule_flag
1271: , SYSDATE -- Last Update Date
1272: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By
1273: , SYSDATE -- Creation Date
1274: , BOM_Rtg_Globals.Get_User_Id -- Created By
1275: , BOM_Rtg_Globals.Get_User_Id -- Last Update Login
1276: , resource_offset_percent

Line 1274: , BOM_Rtg_Globals.Get_User_Id -- Created By

1270: , schedule_flag
1271: , SYSDATE -- Last Update Date
1272: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By
1273: , SYSDATE -- Creation Date
1274: , BOM_Rtg_Globals.Get_User_Id -- Created By
1275: , BOM_Rtg_Globals.Get_User_Id -- Last Update Login
1276: , resource_offset_percent
1277: , autocharge_type
1278: , attribute_category

Line 1275: , BOM_Rtg_Globals.Get_User_Id -- Last Update Login

1271: , SYSDATE -- Last Update Date
1272: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By
1273: , SYSDATE -- Creation Date
1274: , BOM_Rtg_Globals.Get_User_Id -- Created By
1275: , BOM_Rtg_Globals.Get_User_Id -- Last Update Login
1276: , resource_offset_percent
1277: , autocharge_type
1278: , attribute_category
1279: , attribute1

Line 1295: , BOM_Rtg_Globals.Get_Prog_AppId -- Program Application Id

1291: , attribute13
1292: , attribute14
1293: , attribute15
1294: , NULL -- Request Id
1295: , BOM_Rtg_Globals.Get_Prog_AppId -- Program Application Id
1296: , BOM_Rtg_Globals.Get_Prog_Id -- Prog id
1297: , SYSDATE -- Program Update Date
1298: , schedule_seq_num
1299: , substitute_group_num

Line 1296: , BOM_Rtg_Globals.Get_Prog_Id -- Prog id

1292: , attribute14
1293: , attribute15
1294: , NULL -- Request Id
1295: , BOM_Rtg_Globals.Get_Prog_AppId -- Program Application Id
1296: , BOM_Rtg_Globals.Get_Prog_Id -- Prog id
1297: , SYSDATE -- Program Update Date
1298: , schedule_seq_num
1299: , substitute_group_num
1300: , principle_flag

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

1304: -- , setup_id
1305: FROM BOM_OPERATION_RESOURCES
1306: WHERE operation_sequence_id = p_old_operation_sequence_id ;
1307:
1308: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1309: ('Debug2. . . ' ) ;
1310: END IF ;
1311:
1312: INSERT INTO BOM_SUB_OPERATION_RESOURCES

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

1367: , usage_rate_or_amount_inverse
1368: , basis_type
1369: , schedule_flag
1370: , SYSDATE -- Last Update Date
1371: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By
1372: , SYSDATE -- Creation Date
1373: , BOM_Rtg_Globals.Get_User_Id -- Created By
1374: , BOM_Rtg_Globals.Get_User_Id -- Last Update Login
1375: , resource_offset_percent

Line 1373: , BOM_Rtg_Globals.Get_User_Id -- Created By

1369: , schedule_flag
1370: , SYSDATE -- Last Update Date
1371: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By
1372: , SYSDATE -- Creation Date
1373: , BOM_Rtg_Globals.Get_User_Id -- Created By
1374: , BOM_Rtg_Globals.Get_User_Id -- Last Update Login
1375: , resource_offset_percent
1376: , autocharge_type
1377: , principle_flag

Line 1374: , BOM_Rtg_Globals.Get_User_Id -- Last Update Login

1370: , SYSDATE -- Last Update Date
1371: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By
1372: , SYSDATE -- Creation Date
1373: , BOM_Rtg_Globals.Get_User_Id -- Created By
1374: , BOM_Rtg_Globals.Get_User_Id -- Last Update Login
1375: , resource_offset_percent
1376: , autocharge_type
1377: , principle_flag
1378: , attribute_category

Line 1395: , BOM_Rtg_Globals.Get_Prog_AppId -- Program Application Id

1391: , attribute13
1392: , attribute14
1393: , attribute15
1394: , NULL -- Request Id
1395: , BOM_Rtg_Globals.Get_Prog_AppId -- Program Application Id
1396: , BOM_Rtg_Globals.Get_Prog_Id -- Prog id
1397: , SYSDATE -- Program Update Date
1398: , schedule_seq_num
1399: , p_eco_name -- change_notice

Line 1396: , BOM_Rtg_Globals.Get_Prog_Id -- Prog id

1392: , attribute14
1393: , attribute15
1394: , NULL -- Request Id
1395: , BOM_Rtg_Globals.Get_Prog_AppId -- Program Application Id
1396: , BOM_Rtg_Globals.Get_Prog_Id -- Prog id
1397: , SYSDATE -- Program Update Date
1398: , schedule_seq_num
1399: , p_eco_name -- change_notice
1400: , 3 -- acd_type : Disable

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

1402: -- , setup_id
1403: FROM BOM_SUB_OPERATION_RESOURCES
1404: WHERE operation_sequence_id = p_old_operation_sequence_id ;
1405:
1406: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1407: ('Debug3. . . ' ) ;
1408: END IF ;
1409:
1410: END Copy_Old_Op_Seq_Children ;

Line 1457: l_Bo_Id := BOM_Rtg_Globals.Get_Bo_Identifier ;

1453:
1454: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1455: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1456:
1457: l_Bo_Id := BOM_Rtg_Globals.Get_Bo_Identifier ;
1458:
1459:
1460: /* Comment out to resolve Eco Bo dependency
1461: IF l_Bo_Id = BOM_Rtg_Globals.G_ECO_BO THEN

Line 1461: IF l_Bo_Id = BOM_Rtg_Globals.G_ECO_BO THEN

1457: l_Bo_Id := BOM_Rtg_Globals.Get_Bo_Identifier ;
1458:
1459:
1460: /* Comment out to resolve Eco Bo dependency
1461: IF l_Bo_Id = BOM_Rtg_Globals.G_ECO_BO THEN
1462:
1463: IF BOM_Rtg_Globals.get_debug = 'Y'
1464: THEN
1465: error_handler.write_debug('Now Eco_For_Production in Parent Revised Item is set to this revised operation');

Line 1463: IF BOM_Rtg_Globals.get_debug = 'Y'

1459:
1460: /* Comment out to resolve Eco Bo dependency
1461: IF l_Bo_Id = BOM_Rtg_Globals.G_ECO_BO THEN
1462:
1463: IF BOM_Rtg_Globals.get_debug = 'Y'
1464: THEN
1465: error_handler.write_debug('Now Eco_For_Production in Parent Revised Item is set to this revised operation');
1466: END IF;
1467:

Line 1476: l_eco_for_production := BOM_Rtg_Globals.Get_Eco_For_Production;

1472: END IF ;a
1473: */
1474:
1475:
1476: l_eco_for_production := BOM_Rtg_Globals.Get_Eco_For_Production;
1477:
1478: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
1479: INSERT INTO BOM_OPERATION_SEQUENCES(
1480: operation_sequence_id ,

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

1554: p_com_op_unexp_rec.operation_sequence_id
1555: , p_com_op_unexp_rec.routing_sequence_id
1556: , p_com_operation_rec.operation_sequence_number
1557: , SYSDATE -- Last Update Date
1558: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By
1559: , SYSDATE -- Creation Date
1560: , BOM_Rtg_Globals.Get_User_Id -- Created By
1561: , BOM_Rtg_Globals.Get_Login_Id -- Last Update Login
1562: , p_com_op_unexp_rec.standard_operation_id

Line 1560: , BOM_Rtg_Globals.Get_User_Id -- Created By

1556: , p_com_operation_rec.operation_sequence_number
1557: , SYSDATE -- Last Update Date
1558: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By
1559: , SYSDATE -- Creation Date
1560: , BOM_Rtg_Globals.Get_User_Id -- Created By
1561: , BOM_Rtg_Globals.Get_Login_Id -- Last Update Login
1562: , p_com_op_unexp_rec.standard_operation_id
1563: , p_com_op_unexp_rec.department_id
1564: , p_com_operation_rec.op_lead_time_percent

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

1557: , SYSDATE -- Last Update Date
1558: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By
1559: , SYSDATE -- Creation Date
1560: , BOM_Rtg_Globals.Get_User_Id -- Created By
1561: , BOM_Rtg_Globals.Get_Login_Id -- Last Update Login
1562: , p_com_op_unexp_rec.standard_operation_id
1563: , p_com_op_unexp_rec.department_id
1564: , p_com_operation_rec.op_lead_time_percent
1565: , p_com_operation_rec.minimum_transfer_quantity

Line 1589: , BOM_Rtg_Globals.Get_Prog_AppId -- Application Id

1585: , p_com_operation_rec.attribute13
1586: , p_com_operation_rec.attribute14
1587: , p_com_operation_rec.attribute15
1588: , Fnd_Global.Conc_Request_Id -- Request Id
1589: , BOM_Rtg_Globals.Get_Prog_AppId -- Application Id
1590: , BOM_Rtg_Globals.Get_Prog_Id -- Program Id
1591: , SYSDATE -- program_update_date
1592: , p_com_operation_rec.operation_type
1593: , p_com_operation_rec.reference_flag

Line 1590: , BOM_Rtg_Globals.Get_Prog_Id -- Program Id

1586: , p_com_operation_rec.attribute14
1587: , p_com_operation_rec.attribute15
1588: , Fnd_Global.Conc_Request_Id -- Request Id
1589: , BOM_Rtg_Globals.Get_Prog_AppId -- Application Id
1590: , BOM_Rtg_Globals.Get_Prog_Id -- Program Id
1591: , SYSDATE -- program_update_date
1592: , p_com_operation_rec.operation_type
1593: , p_com_operation_rec.reference_flag
1594: , p_com_op_unexp_rec.process_op_seq_id

Line 1612: , DECODE( l_Bo_Id, BOM_Rtg_Globals.G_RTG_BO, SYSDATE, NULL ) -- Implementation Date

1608: , NVL(p_com_operation_rec.include_in_rollup, 1)
1609: , NVL(p_com_operation_rec.op_yield_enabled_flag,1)
1610: -- For bugfix 1744254, revop does not have these cols
1611: , p_com_operation_rec.eco_name
1612: , DECODE( l_Bo_Id, BOM_Rtg_Globals.G_RTG_BO, SYSDATE, NULL ) -- Implementation Date
1613: , p_com_op_unexp_rec.old_operation_sequence_id
1614: , p_com_operation_rec.acd_type
1615: , p_com_op_unexp_rec.revised_item_sequence_id
1616: , p_com_operation_rec.original_system_reference

Line 1618: -- DECODE( l_Bo_Id, BOM_Rtg_Globals.G_ECO_BO, l_Eco_For_Production, 2) -- Eco for Production flag

1614: , p_com_operation_rec.acd_type
1615: , p_com_op_unexp_rec.revised_item_sequence_id
1616: , p_com_operation_rec.original_system_reference
1617: , l_Eco_For_Production
1618: -- DECODE( l_Bo_Id, BOM_Rtg_Globals.G_ECO_BO, l_Eco_For_Production, 2) -- Eco for Production flag
1619: , p_com_operation_rec.shutdown_type -- Added by MK for eAM changes
1620: , p_com_operation_rec.long_description -- Added for long description project (Bug 2689249)
1621: , p_com_op_unexp_rec.lowest_acceptable_yield -- Added for MES Enhancement
1622: , p_com_op_unexp_rec.use_org_settings

Line 1632: IF BOM_Rtg_Globals.get_debug = 'Y'

1628: , p_com_op_unexp_rec.show_lot_attrib
1629: , p_com_op_unexp_rec.track_multiple_res_usage_dates -- End of MES Changes
1630: );
1631:
1632: IF BOM_Rtg_Globals.get_debug = 'Y'
1633: THEN
1634: error_handler.write_debug('Operation : '|| to_char(p_com_op_unexp_rec.operation_sequence_id)
1635: ||' has been created. ' );
1636: END IF;

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

1642: THEN
1643: --
1644: -- Copy Standard Operation Resources
1645: --
1646: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1647: ('Copy Standard Operation Resources. . . ' ) ;
1648: END IF ;
1649:
1650: IF p_com_operation_rec.reference_flag = 1 OR (p_com_operation_rec.reference_flag = 2 AND nvl(BOM_Globals.Get_Caller_Type, '') <> 'MIGRATION') THEN

Line 1662: AND l_Bo_Id = BOM_Rtg_Globals.G_ECO_BO

1658: ) ;
1659: END IF;
1660:
1661: ELSIF NVL(p_com_operation_rec.acd_type , 1 ) = 3 -- Acd Type : Disable
1662: AND l_Bo_Id = BOM_Rtg_Globals.G_ECO_BO
1663: THEN
1664: --
1665: -- Copy Old Operation childeren when Rev Op's Acd type is disable
1666: --

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

1663: THEN
1664: --
1665: -- Copy Old Operation childeren when Rev Op's Acd type is disable
1666: --
1667: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1668: ('Copy Operation Resources of Old Rev Operation when the Acd Type is disable. . . ' ) ;
1669: END IF ;
1670:
1671: Copy_Old_Op_Seq_Children

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

1683:
1684: EXCEPTION
1685:
1686: WHEN OTHERS THEN
1687: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1688: ('Unexpected Error occured in Insert . . .' || SQLERRM);
1689: END IF;
1690:
1691: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

1738: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1739: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1740:
1741:
1742: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Performing update operation . . .') ;
1743: END IF ;
1744:
1745: UPDATE BOM_OPERATION_SEQUENCES
1746: SET operation_seq_num = DECODE(p_com_operation_rec.new_operation_sequence_number ,

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

1747: NULL , p_com_operation_rec.operation_sequence_number ,
1748: p_com_operation_rec.new_operation_sequence_number
1749: )
1750: , last_update_date = SYSDATE /* Last Update Date */
1751: , last_updated_by = BOM_Rtg_Globals.Get_User_Id /* Last Updated By */
1752: , last_update_login = BOM_Rtg_Globals.Get_Login_Id /* Last Update Login */
1753: , standard_operation_id = p_com_op_unexp_rec.standard_operation_id
1754: , department_id = p_com_op_unexp_rec.department_id
1755: , operation_lead_time_percent = p_com_operation_rec.op_lead_time_percent

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

1748: p_com_operation_rec.new_operation_sequence_number
1749: )
1750: , last_update_date = SYSDATE /* Last Update Date */
1751: , last_updated_by = BOM_Rtg_Globals.Get_User_Id /* Last Updated By */
1752: , last_update_login = BOM_Rtg_Globals.Get_Login_Id /* Last Update Login */
1753: , standard_operation_id = p_com_op_unexp_rec.standard_operation_id
1754: , department_id = p_com_op_unexp_rec.department_id
1755: , operation_lead_time_percent = p_com_operation_rec.op_lead_time_percent
1756: , minimum_transfer_quantity = p_com_operation_rec.minimum_transfer_quantity

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

1778: , attribute12 = p_com_operation_rec.attribute12
1779: , attribute13 = p_com_operation_rec.attribute13
1780: , attribute14 = p_com_operation_rec.attribute14
1781: , attribute15 = p_com_operation_rec.attribute15
1782: , program_application_id = BOM_Rtg_Globals.Get_Prog_AppId /* Application Id */
1783: , program_id = BOM_Rtg_Globals.Get_Prog_Id /* Program Id */
1784: , program_update_date = SYSDATE /* program_update_date */
1785: , reference_flag = p_com_operation_rec.reference_flag
1786: , process_op_seq_id = p_com_op_unexp_rec.process_op_seq_id

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

1779: , attribute13 = p_com_operation_rec.attribute13
1780: , attribute14 = p_com_operation_rec.attribute14
1781: , attribute15 = p_com_operation_rec.attribute15
1782: , program_application_id = BOM_Rtg_Globals.Get_Prog_AppId /* Application Id */
1783: , program_id = BOM_Rtg_Globals.Get_Prog_Id /* Program Id */
1784: , program_update_date = SYSDATE /* program_update_date */
1785: , reference_flag = p_com_operation_rec.reference_flag
1786: , process_op_seq_id = p_com_op_unexp_rec.process_op_seq_id
1787: , line_op_seq_id = p_com_op_unexp_rec.line_op_seq_id

Line 1814: , bic.LAST_UPDATED_BY = BOM_Rtg_Globals.Get_User_Id

1810:
1811: UPDATE BOM_INVENTORY_COMPONENTS bic
1812: SET bic.operation_lead_time_percent = p_com_operation_rec.op_lead_time_percent
1813: , bic.LAST_UPDATE_DATE = SYSDATE
1814: , bic.LAST_UPDATED_BY = BOM_Rtg_Globals.Get_User_Id
1815: , bic.LAST_UPDATE_LOGIN = BOM_Rtg_Globals.Get_Login_Id
1816: , bic.REQUEST_ID = Fnd_Global.Conc_Request_Id
1817: , bic.PROGRAM_ID = Fnd_Global.Conc_Program_Id
1818: , bic.PROGRAM_APPLICATION_ID = Fnd_Global.Prog_Appl_Id

Line 1815: , bic.LAST_UPDATE_LOGIN = BOM_Rtg_Globals.Get_Login_Id

1811: UPDATE BOM_INVENTORY_COMPONENTS bic
1812: SET bic.operation_lead_time_percent = p_com_operation_rec.op_lead_time_percent
1813: , bic.LAST_UPDATE_DATE = SYSDATE
1814: , bic.LAST_UPDATED_BY = BOM_Rtg_Globals.Get_User_Id
1815: , bic.LAST_UPDATE_LOGIN = BOM_Rtg_Globals.Get_Login_Id
1816: , bic.REQUEST_ID = Fnd_Global.Conc_Request_Id
1817: , bic.PROGRAM_ID = Fnd_Global.Conc_Program_Id
1818: , bic.PROGRAM_APPLICATION_ID = Fnd_Global.Prog_Appl_Id
1819: , bic.PROGRAM_UPDATE_DATE = SYSDATE

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

1827: AND bom.organization_id = bor.organization_id
1828: AND bor.routing_sequence_id = p_com_op_unexp_rec.routing_sequence_id) ;
1829:
1830: IF SQL%FOUND THEN
1831: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1832: ('Operation lead time in bom inventory components refered Operation Seq Num is updated.') ;
1833: END IF ;
1834:
1835: --

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

1849:
1850:
1851: EXCEPTION
1852: WHEN OTHERS THEN
1853: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1854: ('Unexpected Error occured in Update . . .' || SQLERRM);
1855: END IF;
1856:
1857: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1940: IF BOM_Rtg_Globals.Get_Bo_Identifier = BOM_Rtg_Globals.G_ECO_BO

1936: l_com_operation_rec := p_com_operation_rec ;
1937: l_com_op_unexp_rec := p_com_op_unexp_rec ;
1938:
1939:
1940: IF BOM_Rtg_Globals.Get_Bo_Identifier = BOM_Rtg_Globals.G_ECO_BO
1941: THEN
1942:
1943: DELETE FROM BOM_OPERATION_SEQUENCES
1944: WHERE OPERATION_SEQUENCE_ID = l_com_op_unexp_rec.operation_sequence_id ;

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

1974: DELETE FROM BOM_SUB_OPERATION_RESOURCES
1975: WHERE OPERATION_SEQUENCE_ID = l_com_op_unexp_rec.operation_sequence_id ;
1976:
1977:
1978: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
1979: Error_Handler.Write_Debug('Finished deleting revised operation record . . .') ;
1980: END IF ;
1981:
1982:

Line 1983: ELSIF BOM_Rtg_Globals.Get_Bo_Identifier = BOM_Rtg_Globals.G_RTG_BO

1979: Error_Handler.Write_Debug('Finished deleting revised operation record . . .') ;
1980: END IF ;
1981:
1982:
1983: ELSIF BOM_Rtg_Globals.Get_Bo_Identifier = BOM_Rtg_Globals.G_RTG_BO
1984: THEN
1985: FOR l_del_grp_rec IN l_del_grp_csr
1986: ( p_del_group_name => l_com_operation_rec.delete_group_name
1987: , p_organization_id => l_com_op_unexp_rec.organization_id )

Line 2046: user_id => BOM_Rtg_Globals.Get_User_Id

2042: ent_inv_item_id => l_com_op_unexp_rec.revised_item_id,
2043: ent_alt_designator => l_com_operation_rec.alternate_routing_code,
2044: ent_comp_seq_id => NULL,
2045: ent_op_seq_id => l_com_op_unexp_rec.operation_sequence_id ,
2046: user_id => BOM_Rtg_Globals.Get_User_Id
2047: ) ;
2048:
2049: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
2050: Error_Handler.Write_Debug('Finished creatin new delete group . . .') ;

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

2045: ent_op_seq_id => l_com_op_unexp_rec.operation_sequence_id ,
2046: user_id => BOM_Rtg_Globals.Get_User_Id
2047: ) ;
2048:
2049: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
2050: Error_Handler.Write_Debug('Finished creatin new delete group . . .') ;
2051: END IF ;
2052:
2053: END IF ;

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

2063:
2064: EXCEPTION
2065: WHEN DUPLICATE_DEL_GROUP THEN
2066:
2067: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
2068: ('Duplicate Delete Group Error occured in Delete . . .' || SQLERRM);
2069: END IF;
2070:
2071:

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

2087: x_return_status := FND_API.G_RET_STS_ERROR;
2088: x_mesg_token_tbl := l_mesg_token_tbl;
2089:
2090: WHEN OTHERS THEN
2091: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
2092: ('Unexpected Error occured in Delete . . .' || SQLERRM);
2093: END IF;
2094:
2095: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

2160:
2161: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2162: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2163:
2164: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
2165: Error_Handler.Write_Debug('Performing cancel revised operation : '
2166: || to_char(p_operation_sequence_id) || ' . . .') ;
2167: END IF ;
2168:

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

2349:
2350:
2351: EXCEPTION
2352: WHEN OTHERS THEN
2353: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
2354: ('Unexpected Error occured in Cancel . . .' || SQLERRM);
2355: END IF;
2356:
2357: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)