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.CTO_WORKFLOW dependencies on CTO_CONFIG_BOM_PK

Line 672: oe_debug_pub.add('create_config_item_wf: ' || ' resetting CTO_CONFIG_BOM_PK.g_t_dropped_item_type ' , 1 );

668: raise FND_API.G_EXC_UNEXPECTED_ERROR;
669: end if;
670:
671:
672: oe_debug_pub.add('create_config_item_wf: ' || ' resetting CTO_CONFIG_BOM_PK.g_t_dropped_item_type ' , 1 );
673:
674: CTO_CONFIG_BOM_PK.g_t_dropped_item_type.delete ;
675:
676:

Line 674: CTO_CONFIG_BOM_PK.g_t_dropped_item_type.delete ;

670:
671:
672: oe_debug_pub.add('create_config_item_wf: ' || ' resetting CTO_CONFIG_BOM_PK.g_t_dropped_item_type ' , 1 );
673:
674: CTO_CONFIG_BOM_PK.g_t_dropped_item_type.delete ;
675:
676:
677:
678: IF PG_DEBUG <> 0 THEN

Line 700: if( CTO_CONFIG_BOM_PK.g_t_dropped_item_type.count > 0 ) then

696:
697:
698:
699:
700: if( CTO_CONFIG_BOM_PK.g_t_dropped_item_type.count > 0 ) then
701: oe_debug_pub.add( 'DROPPED component count > 0 ' , 1 ) ;
702:
703: select oeh.order_number , msi.segment1, oel.line_number || '.' || oel.shipment_number
704: into v_order_number, v_top_model_name, v_top_model_line_num

Line 712: for i in 1..CTO_CONFIG_BOM_PK.g_t_dropped_item_type.count

708: and oel.inventory_item_id = msi.inventory_item_id
709: and oel.ship_from_org_id = msi.organization_id ;
710:
711:
712: for i in 1..CTO_CONFIG_BOM_PK.g_t_dropped_item_type.count
713: loop
714:
715: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).SALES_ORDER_NUM := v_order_number ;
716: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_MODEL_NAME := v_top_model_name ;

Line 715: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).SALES_ORDER_NUM := v_order_number ;

711:
712: for i in 1..CTO_CONFIG_BOM_PK.g_t_dropped_item_type.count
713: loop
714:
715: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).SALES_ORDER_NUM := v_order_number ;
716: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_MODEL_NAME := v_top_model_name ;
717: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_MODEL_LINE_NUM := v_top_model_line_num ;
718: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_NAME := null ;
719: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_LINE_NUM := null ;

Line 716: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_MODEL_NAME := v_top_model_name ;

712: for i in 1..CTO_CONFIG_BOM_PK.g_t_dropped_item_type.count
713: loop
714:
715: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).SALES_ORDER_NUM := v_order_number ;
716: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_MODEL_NAME := v_top_model_name ;
717: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_MODEL_LINE_NUM := v_top_model_line_num ;
718: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_NAME := null ;
719: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_LINE_NUM := null ;
720: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).REQUEST_ID := null ;

Line 717: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_MODEL_LINE_NUM := v_top_model_line_num ;

713: loop
714:
715: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).SALES_ORDER_NUM := v_order_number ;
716: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_MODEL_NAME := v_top_model_name ;
717: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_MODEL_LINE_NUM := v_top_model_line_num ;
718: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_NAME := null ;
719: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_LINE_NUM := null ;
720: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).REQUEST_ID := null ;
721:

Line 718: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_NAME := null ;

714:
715: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).SALES_ORDER_NUM := v_order_number ;
716: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_MODEL_NAME := v_top_model_name ;
717: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_MODEL_LINE_NUM := v_top_model_line_num ;
718: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_NAME := null ;
719: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_LINE_NUM := null ;
720: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).REQUEST_ID := null ;
721:
722: end loop ;

Line 719: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_LINE_NUM := null ;

715: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).SALES_ORDER_NUM := v_order_number ;
716: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_MODEL_NAME := v_top_model_name ;
717: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_MODEL_LINE_NUM := v_top_model_line_num ;
718: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_NAME := null ;
719: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_LINE_NUM := null ;
720: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).REQUEST_ID := null ;
721:
722: end loop ;
723:

Line 720: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).REQUEST_ID := null ;

716: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_MODEL_NAME := v_top_model_name ;
717: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_MODEL_LINE_NUM := v_top_model_line_num ;
718: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_NAME := null ;
719: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_LINE_NUM := null ;
720: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).REQUEST_ID := null ;
721:
722: end loop ;
723:
724: end if ;

Line 736: if( CTO_CONFIG_BOM_PK.g_t_dropped_item_type.count > 0 ) then

732: oe_debug_pub.add('create_config_item_wf: ' || 'Failed in Create BOM and Routing with exp error.', 1);
733: END IF;
734:
735:
736: if( CTO_CONFIG_BOM_PK.g_t_dropped_item_type.count > 0 ) then
737:
738: if( lNotifyUsers = 1 ) then
739: oe_debug_pub.add('create_config_item_wf: ' || '********** ******* Will be Sending Notifications .', 1);
740: CTO_UTILITY_PK.send_oid_notification ; /* DROPPED COMPONENTS BOM NOT CREATED NOTIFICATION */

Line 954: if( CTO_CONFIG_BOM_PK.g_t_dropped_item_type.count > 0 ) then

950:
951:
952:
953:
954: if( CTO_CONFIG_BOM_PK.g_t_dropped_item_type.count > 0 ) then
955: oe_debug_pub.add( 'DROPPED component count > 0 ' , 1 ) ;
956:
957: select msi.segment1, oel.line_number || '.' || oel.shipment_number || '.' || nvl( oel.option_number , '' )
958: || '.' || nvl(component_number , '' )

Line 967: for i in 1..CTO_CONFIG_BOM_PK.g_t_dropped_item_type.count

963: and oel.inventory_item_id = msi.inventory_item_id
964: and oel.ship_from_org_id = msi.organization_id ;
965:
966:
967: for i in 1..CTO_CONFIG_BOM_PK.g_t_dropped_item_type.count
968: loop
969:
970: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_NAME := v_top_config_name ;
971: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_LINE_NUM := v_top_config_line_num ;

Line 970: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_NAME := v_top_config_name ;

966:
967: for i in 1..CTO_CONFIG_BOM_PK.g_t_dropped_item_type.count
968: loop
969:
970: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_NAME := v_top_config_name ;
971: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_LINE_NUM := v_top_config_line_num ;
972: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).REQUEST_ID := null ;
973:
974: end loop ;

Line 971: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_LINE_NUM := v_top_config_line_num ;

967: for i in 1..CTO_CONFIG_BOM_PK.g_t_dropped_item_type.count
968: loop
969:
970: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_NAME := v_top_config_name ;
971: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_LINE_NUM := v_top_config_line_num ;
972: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).REQUEST_ID := null ;
973:
974: end loop ;
975:

Line 972: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).REQUEST_ID := null ;

968: loop
969:
970: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_NAME := v_top_config_name ;
971: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).TOP_CONFIG_LINE_NUM := v_top_config_line_num ;
972: CTO_CONFIG_BOM_PK.g_t_dropped_item_type(i).REQUEST_ID := null ;
973:
974: end loop ;
975:
976:

Line 1394: CTO_CONFIG_BOM_PK.gApplyHold := 'N'; -- bugfix 2899529: Reset this global variable.

1390:
1391:
1392: end if; /* end of p_funcmode = 'RUN' */
1393:
1394: CTO_CONFIG_BOM_PK.gApplyHold := 'N'; -- bugfix 2899529: Reset this global variable.
1395:
1396: OE_STANDARD_WF.Save_Messages;
1397: OE_STANDARD_WF.Clear_Msg_Context;
1398:

Line 2674: l_status := CTO_CONFIG_BOM_PK.check_bom(pItemId => l_config_item_id,

2670: IF PG_DEBUG <> 0 THEN
2671: oe_debug_pub.add('check_reservation_status_wf: ' || 'Check For Config BOM ', 1);
2672: END IF;
2673:
2674: l_status := CTO_CONFIG_BOM_PK.check_bom(pItemId => l_config_item_id,
2675: pOrgId => l_mfg_org_id,
2676: xBillId => l_x_bill_seq_id);
2677:
2678: IF (l_status = 1) THEN