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_UTILITY_PK

Line 563: CTO_UTILITY_PK.get_planner_code( v_top_model_id, v_ship_from_org_id , v_planner_code ) ;

559:
560:
561: oe_debug_pub.add('create_config_item_wf: ' || 'Going to get planner code ' , 1 );
562:
563: CTO_UTILITY_PK.get_planner_code( v_top_model_id, v_ship_from_org_id , v_planner_code ) ;
564:
565:
566: oe_debug_pub.add('create_config_item_wf: ' || 'planner code is ' || v_planner_code , 1 );
567:

Line 612: oe_debug_pub.add('create_config_item_wf: ' || 'Going to Call CTO_UTILITY_PK.handle_expected_error ..',3);

608: /* EXPECTED ERROR PROCESSING */
609:
610: if( lNotifyUsers = 1 ) then
611: IF PG_DEBUG <> 0 THEN
612: oe_debug_pub.add('create_config_item_wf: ' || 'Going to Call CTO_UTILITY_PK.handle_expected_error ..',3);
613: END IF;
614:
615: CTO_UTILITY_PK.handle_expected_error( p_error_type => CTO_UTILITY_PK.EXP_ERROR_AND_ITEM_NOT_CREATED
616: , p_inventory_item_id => v_top_model_id

Line 615: CTO_UTILITY_PK.handle_expected_error( p_error_type => CTO_UTILITY_PK.EXP_ERROR_AND_ITEM_NOT_CREATED

611: IF PG_DEBUG <> 0 THEN
612: oe_debug_pub.add('create_config_item_wf: ' || 'Going to Call CTO_UTILITY_PK.handle_expected_error ..',3);
613: END IF;
614:
615: CTO_UTILITY_PK.handle_expected_error( p_error_type => CTO_UTILITY_PK.EXP_ERROR_AND_ITEM_NOT_CREATED
616: , p_inventory_item_id => v_top_model_id
617: , p_organization_id => v_ship_from_org_id
618: , p_line_id => lTopAtoLineId
619: , p_sales_order_num => v_order_number

Line 740: CTO_UTILITY_PK.send_oid_notification ; /* DROPPED COMPONENTS BOM NOT CREATED NOTIFICATION */

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 */
741:
742: else
743: oe_debug_pub.add('create_config_item_wf: ' || '********** ******* Will not be Sending Notifications .', 1);
744:

Line 764: oe_debug_pub.add('create_config_item_wf: ' || 'Going to Call CTO_UTILITY_PK.handle_expected_error ..',3);

760:
761:
762: if( lNotifyUsers = 1 ) then
763: IF PG_DEBUG <> 0 THEN
764: oe_debug_pub.add('create_config_item_wf: ' || 'Going to Call CTO_UTILITY_PK.handle_expected_error ..',3);
765: END IF;
766:
767: CTO_UTILITY_PK.handle_expected_error( p_error_type => CTO_UTILITY_PK.EXP_ERROR_AND_ITEM_NOT_CREATED
768: , p_inventory_item_id => v_top_model_id

Line 767: CTO_UTILITY_PK.handle_expected_error( p_error_type => CTO_UTILITY_PK.EXP_ERROR_AND_ITEM_NOT_CREATED

763: IF PG_DEBUG <> 0 THEN
764: oe_debug_pub.add('create_config_item_wf: ' || 'Going to Call CTO_UTILITY_PK.handle_expected_error ..',3);
765: END IF;
766:
767: CTO_UTILITY_PK.handle_expected_error( p_error_type => CTO_UTILITY_PK.EXP_ERROR_AND_ITEM_NOT_CREATED
768: , p_inventory_item_id => v_top_model_id
769: , p_organization_id => v_ship_from_org_id
770: , p_line_id => lTopAtoLineId
771: , p_sales_order_num => v_order_number

Line 849: oe_debug_pub.add('create_config_item_wf: ' || 'Going to Call CTO_UTILITY_PK.handle_expected_error ..',3);

845:
846:
847: if( lNotifyUsers = 1 ) then
848: IF PG_DEBUG <> 0 THEN
849: oe_debug_pub.add('create_config_item_wf: ' || 'Going to Call CTO_UTILITY_PK.handle_expected_error ..',3);
850: END IF;
851:
852: CTO_UTILITY_PK.handle_expected_error( p_error_type => CTO_UTILITY_PK.EXP_ERROR_AND_ITEM_NOT_CREATED
853: , p_inventory_item_id => v_top_model_id

Line 852: CTO_UTILITY_PK.handle_expected_error( p_error_type => CTO_UTILITY_PK.EXP_ERROR_AND_ITEM_NOT_CREATED

848: IF PG_DEBUG <> 0 THEN
849: oe_debug_pub.add('create_config_item_wf: ' || 'Going to Call CTO_UTILITY_PK.handle_expected_error ..',3);
850: END IF;
851:
852: CTO_UTILITY_PK.handle_expected_error( p_error_type => CTO_UTILITY_PK.EXP_ERROR_AND_ITEM_NOT_CREATED
853: , p_inventory_item_id => v_top_model_id
854: , p_organization_id => v_ship_from_org_id
855: , p_line_id => lTopAtoLineId
856: , p_sales_order_num => v_order_number

Line 978: CTO_UTILITY_PK.send_oid_notification ; /* DROPPED COMPONENTS ITEM CREATED NOTIFICATION */

974: end loop ;
975:
976:
977: if( lNotifyUsers = 1 ) then
978: CTO_UTILITY_PK.send_oid_notification ; /* DROPPED COMPONENTS ITEM CREATED NOTIFICATION */
979:
980: else
981: oe_debug_pub.add('create_config_item_wf: ' || '********** ******* Will not be Sending Notifications .', 1);
982:

Line 1054: oe_debug_pub.add('create_config_item_wf: ' || 'Going to Call CTO_UTILITY_PK.handle_expected_error ..',3);

1050:
1051:
1052: if( lNotifyUsers = 1 ) then
1053: IF PG_DEBUG <> 0 THEN
1054: oe_debug_pub.add('create_config_item_wf: ' || 'Going to Call CTO_UTILITY_PK.handle_expected_error ..',3);
1055: END IF;
1056:
1057: CTO_UTILITY_PK.handle_expected_error( p_error_type => CTO_UTILITY_PK.EXP_ERROR_AND_ITEM_NOT_CREATED
1058: , p_inventory_item_id => v_top_model_id

Line 1057: CTO_UTILITY_PK.handle_expected_error( p_error_type => CTO_UTILITY_PK.EXP_ERROR_AND_ITEM_NOT_CREATED

1053: IF PG_DEBUG <> 0 THEN
1054: oe_debug_pub.add('create_config_item_wf: ' || 'Going to Call CTO_UTILITY_PK.handle_expected_error ..',3);
1055: END IF;
1056:
1057: CTO_UTILITY_PK.handle_expected_error( p_error_type => CTO_UTILITY_PK.EXP_ERROR_AND_ITEM_NOT_CREATED
1058: , p_inventory_item_id => v_top_model_id
1059: , p_organization_id => v_ship_from_org_id
1060: , p_line_id => lTopAtoLineId
1061: , p_sales_order_num => v_order_number

Line 3129: CTO_UTILITY_PK.check_cto_can_create_supply

3125: --OPM
3126: --Check if Cto can create supply
3127: --query sourcing org is replaced with this new prcoedure
3128: --by KKONADA
3129: CTO_UTILITY_PK.check_cto_can_create_supply
3130: (
3131: P_config_item_id => l_inventory_item_id,
3132: P_org_id => l_ship_from_org_id,
3133: x_can_create_supply => l_can_create_supply,

Line 3366: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => to_number(p_itemkey) );

3362: raise FND_API.G_EXC_ERROR;
3363: end if;
3364:
3365: --bugfix 1799874 start
3366: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => to_number(p_itemkey) );
3367: --bugfix 1799874 end
3368:
3369:
3370: l_stmt_num := 110;

Line 3718: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => to_number(p_itemkey) );

3714: end if;
3715:
3716:
3717: --bugfix 1799874 start
3718: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => to_number(p_itemkey) );
3719: --bugfix 1799874 end
3720:
3721: /*----------------------------------------------------------+
3722: Check order line status and check order line for holds.

Line 4390: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => p_config_line_id );

4386:
4387: BEGIN
4388:
4389: --bugfix 1799874 start
4390: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => p_config_line_id );
4391: --bugfix 1799874 end
4392:
4393: select sum(nvl(mrs.reservation_quantity,0))
4394: into x_reserved_quantity

Line 4572: | This calls CTO_UTILITY_PK.chk_all_rsv_details to

Line 4593: l_rsv_details CTO_UTILITY_PK.t_resv_details;

4589:
4590: l_msg_count number;
4591: l_msg_data varchar2(2000);
4592: l_return_status varchar2(1);
4593: l_rsv_details CTO_UTILITY_PK.t_resv_details;
4594:
4595:
4596:
4597:

Line 4608: CTO_UTILITY_PK.chk_all_rsv_details

4604: IF (p_funcmode = 'RUN') then
4605:
4606: l_stmt_num := 260;
4607:
4608: CTO_UTILITY_PK.chk_all_rsv_details
4609: ( p_itemkey,
4610: l_rsv_details,
4611: l_msg_count,
4612: l_msg_data,

Line 4786: CTO_UTILITY_PK.check_cto_can_create_supply

4782:
4783: END IF ;
4784:
4785: l_stmt_num:=30;
4786: CTO_UTILITY_PK.check_cto_can_create_supply
4787: (
4788: P_config_item_id => l_inventory_item_id,
4789: P_org_id => l_ship_from_org_id,
4790: x_can_create_supply => l_can_create_supply,