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 3162: CTO_UTILITY_PK.check_cto_can_create_supply

3158: --OPM
3159: --Check if Cto can create supply
3160: --query sourcing org is replaced with this new prcoedure
3161: --by KKONADA
3162: CTO_UTILITY_PK.check_cto_can_create_supply
3163: (
3164: P_config_item_id => l_inventory_item_id,
3165: P_org_id => l_ship_from_org_id,
3166: x_can_create_supply => l_can_create_supply,

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

3395: raise FND_API.G_EXC_ERROR;
3396: end if;
3397:
3398: --bugfix 1799874 start
3399: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => to_number(p_itemkey) );
3400: --bugfix 1799874 end
3401:
3402:
3403: l_stmt_num := 110;

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

3747: end if;
3748:
3749:
3750: --bugfix 1799874 start
3751: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => to_number(p_itemkey) );
3752: --bugfix 1799874 end
3753:
3754: /*----------------------------------------------------------+
3755: Check order line status and check order line for holds.

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

4485:
4486: BEGIN
4487:
4488: --bugfix 1799874 start
4489: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => p_config_line_id );
4490: --bugfix 1799874 end
4491:
4492: select sum(nvl(mrs.reservation_quantity,0))
4493: into x_reserved_quantity

Line 4671: | This calls CTO_UTILITY_PK.chk_all_rsv_details to

Line 4692: l_rsv_details CTO_UTILITY_PK.t_resv_details;

4688:
4689: l_msg_count number;
4690: l_msg_data varchar2(2000);
4691: l_return_status varchar2(1);
4692: l_rsv_details CTO_UTILITY_PK.t_resv_details;
4693:
4694:
4695:
4696:

Line 4707: CTO_UTILITY_PK.chk_all_rsv_details

4703: IF (p_funcmode = 'RUN') then
4704:
4705: l_stmt_num := 260;
4706:
4707: CTO_UTILITY_PK.chk_all_rsv_details
4708: ( p_itemkey,
4709: l_rsv_details,
4710: l_msg_count,
4711: l_msg_data,

Line 4885: CTO_UTILITY_PK.check_cto_can_create_supply

4881:
4882: END IF ;
4883:
4884: l_stmt_num:=30;
4885: CTO_UTILITY_PK.check_cto_can_create_supply
4886: (
4887: P_config_item_id => l_inventory_item_id,
4888: P_org_id => l_ship_from_org_id,
4889: x_can_create_supply => l_can_create_supply,