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 1010: , DECODE( BOM_Rtg_Globals.Get_Bo_Identifier

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

Line 1011: , BOM_Rtg_Globals.G_ECO_BO

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

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

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

Line 1024: , BOM_Rtg_Globals.Get_User_Id -- Created By

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

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

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

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

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

Line 1045: , BOM_Rtg_Globals.Get_Prog_Id -- Prog id

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

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

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

Line 1117: , BOM_Rtg_Globals.Get_User_Id -- Created By

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

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

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

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

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

Line 1121: , BOM_Rtg_Globals.Get_Prog_Id -- Prog id

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

Line 1142: , DECODE( BOM_Rtg_Globals.Get_Bo_Identifier

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

Line 1143: , BOM_Rtg_Globals.G_ECO_BO

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

Line 1166: X_created_by => BOM_Rtg_Globals.Get_User_Id,

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

Line 1167: X_last_update_login => BOM_Rtg_Globals.Get_User_Id,

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

Line 1168: X_program_application_id => BOM_Rtg_Globals.Get_Prog_AppId,

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

Line 1169: X_program_id => BOM_Rtg_Globals.Get_Prog_Id,

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

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

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

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

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

Line 1271: , BOM_Rtg_Globals.Get_User_Id -- Created By

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

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

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

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

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

Line 1293: , BOM_Rtg_Globals.Get_Prog_Id -- Prog id

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

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

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

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

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

Line 1370: , BOM_Rtg_Globals.Get_User_Id -- Created By

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

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

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

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

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

Line 1393: , BOM_Rtg_Globals.Get_Prog_Id -- Prog id

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

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

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

Line 1454: l_Bo_Id := BOM_Rtg_Globals.Get_Bo_Identifier ;

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

Line 1458: IF l_Bo_Id = BOM_Rtg_Globals.G_ECO_BO THEN

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

Line 1460: IF BOM_Rtg_Globals.get_debug = 'Y'

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

Line 1473: l_eco_for_production := BOM_Rtg_Globals.Get_Eco_For_Production;

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

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

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

Line 1557: , BOM_Rtg_Globals.Get_User_Id -- Created By

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

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

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

Line 1586: , BOM_Rtg_Globals.Get_Prog_AppId -- Application Id

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

Line 1587: , BOM_Rtg_Globals.Get_Prog_Id -- Program Id

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

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

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

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

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

Line 1629: IF BOM_Rtg_Globals.get_debug = 'Y'

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

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

1639: THEN
1640: --
1641: -- Copy Standard Operation Resources
1642: --
1643: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1644: ('Copy Standard Operation Resources. . . ' ) ;
1645: END IF ;
1646:
1647: 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 1659: AND l_Bo_Id = BOM_Rtg_Globals.G_ECO_BO

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1811: , bic.LAST_UPDATED_BY = BOM_Rtg_Globals.Get_User_Id

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

Line 1812: , bic.LAST_UPDATE_LOGIN = BOM_Rtg_Globals.Get_Login_Id

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

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

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

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

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

Line 1937: IF BOM_Rtg_Globals.Get_Bo_Identifier = BOM_Rtg_Globals.G_ECO_BO

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

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

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

Line 1980: ELSIF BOM_Rtg_Globals.Get_Bo_Identifier = BOM_Rtg_Globals.G_RTG_BO

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

Line 2043: user_id => BOM_Rtg_Globals.Get_User_Id

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

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

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

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

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

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

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

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

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

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

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