[Home] [Help]
28: | to support ATO item under a PTO. |
29: | item_type_code for an ato item under PTO |
30: | is 'OPTION' and top_model_line_id will NOT be |
31: | null, UNLIKE an ato item order, where |
32: | item_type_code = 'Standard' and |
33: | top_model_lined_id is null |
34: | This fix has actually been provided in |
35: | branched version 115.33.1155.3 |
36: | 08-17-2001 Kiran Konada, fix for bug#1895563 |
716:
717: /*************************************************************************
718: Procedure: inventory_reservation_check
719: Parameters: p_order_line_id
720: x_return_status - standard API output parameter
721: x_msg_count - "
722: x_msg_data - "
723:
724: Description: Check if an order line status is either
769: , v_header_id
770: from oe_order_lines_all
771: where line_id = p_order_line_id;
772:
773: -- here, we pass the Standard item line,
774: -- namely, it will return a success. */
775:
776: -- removing code to allow reservation for ATOitem
777: -- by kkonada :adding below code again for dummy assignment*/
785: ** BUG#2234858, BUG#2312701 AND BUG#2358576 Drop Ship changes to disallow reservation
786: ** for config items and ato items of external source type
787: ** ATO ITEMS will behave as strict ATO ITEMS when under a PTO or stand alone.
788: ** ATO ITEMS lose their identity when they are put as options under ATO MODELS
789: ** ATO ITEMS will have ato_line_id = line_id and item_type_code either STANDARD
790: ** or OPTION when their identity is preserved.
791: */
792:
793: l_stmt_num := 30;
794:
795: if( v_source_type_code = 'EXTERNAL' AND
796: ( ( v_item_type_code = 'CONFIG' ) OR
797: ( ( v_ato_line_id = p_order_line_id AND
798: ( v_item_type_code = 'STANDARD' OR v_item_type_code = 'OPTION' )
799: )
800: )
801: )
802: )then
946:
947: /*************************************************************************
948: Procedure: wf_update_after_inv_reserv
949: Parameters: p_order_line_id
950: x_return_status - standard API output parameter
951: x_msg_count - "
952: x_msg_data - "
953:
954: Description: update an order line status after inventory reservation
1009: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'v_item_type_code = '||v_item_type_code);
1010: End if;
1011:
1012:
1013: IF ((upper(v_item_type_code) = 'STANDARD') -- Ato item line
1014: OR (upper(v_item_type_code) = 'OPTION')) --fix for bug#1874380
1015: AND (v_ato_line_id = p_order_line_id) then
1016:
1017: -- an ATO item line
1020:
1021: l_stmt_num := 20;
1022:
1023: IF PG_DEBUG <> 0 THEN
1024: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'item_type_code is STANDARD OR OPTION => an ato item', 4);
1025: END IF;--fix for bug#1874380
1026: If PG_DEBUG <> 0 Then
1027: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Before querying wf_activity_status..');
1028: End if;
1379: /*************************************************************************
1380: Procedure: inventory_unreservation_check
1381: Parameters: p_order_line_id
1382: p_rsv_quantity - Unreservation Quantity
1383: x_return_status - standard API output parameter
1384: x_msg_count - "
1385: x_msg_data - "
1386:
1387: Description: Check if an order line status is
1440: --
1441: -- For ATO items and CONFIG items, we should check the qty being unreserved.
1442: --
1443:
1444: if (((upper(v_item_type_code) = 'STANDARD') OR (upper(v_item_type_code) = 'OPTION'))
1445: --fix for bug#1874380
1446: AND (v_ato_line_id = p_order_line_id ))
1447: OR
1448: (upper(v_item_type_code) = 'CONFIG' )
1530:
1531: /*************************************************************************
1532: Procedure: wf_update_after_inv_unreserv
1533: Parameters: p_order_line_id
1534: x_return_status - standard API output parameter
1535: x_msg_count - "
1536: x_msg_data - "
1537:
1538: Description: update an order line status after inventory unreservation
1672:
1673: if v_open_flag = 'Y' then --Bugfix 7214005
1674: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => p_order_line_id ); --bugfix 1799874
1675:
1676: IF ((upper(v_item_type_code) = 'STANDARD' OR upper(v_item_type_code) = 'OPTION' ) --fix for bug# 1874380
1677: AND (v_ato_line_id = p_order_line_id))
1678: OR upper(v_item_type_code) = 'CONFIG'
1679: THEN
1680:
2097:
2098: /**************************************************************************
2099:
2100: Procedure: configuration_item_created
2101: Parameters: p_application_id (standard signature format)
2102: p_entity_short_name
2103: p_validation_entity_short_name
2104: p_validation_tmplt_short_name
2105: p_record_set_short_name
2104: p_validation_tmplt_short_name
2105: p_record_set_short_name
2106: p_scope
2107: x_result
2108: Description: This API with standard signature format is used to check is
2109: a configured item is created. This condition is applied to
2110: an option line.
2111:
2112: *****************************************************************************/
2194:
2195: /**************************************************************************
2196:
2197: Procedure: configuration_created
2198: Parameters: p_application_id (standard signature format)
2199: p_entity_short_name
2200: p_validation_entity_short_name
2201: p_validation_tmplt_short_name
2202: p_record_set_short_name
2201: p_validation_tmplt_short_name
2202: p_record_set_short_name
2203: p_scope
2204: x_result
2205: Description: This API with standard signature format is called from
2206: the security constraints to validate whether a change is
2207: allowed on an order line.
2208: This API gets called for every item type. It returns
2209: x_result = 0 if the item is not part of an ATO
2238: select ato_line_id, header_id
2239: into l_ato_line_id, l_header_id
2240: from oe_order_lines_all
2241: where line_id = oe_line_security.g_record.line_id
2242: and item_type_code <> 'STANDARD'
2243: and ato_line_id is not null;
2244:
2245: -- check if the config item is created
2246: -- adding join to header_id for performance
2378:
2379: /**************************************************************************
2380:
2381: Procedure: Update_Config_Line
2382: Parameters: p_application_id (standard signature format)
2383: p_entity_short_name
2384: p_validation_entity_short_name
2385: p_validation_tmplt_short_name
2386: p_record_set_short_name
2385: p_validation_tmplt_short_name
2386: p_record_set_short_name
2387: p_scope
2388: x_result
2389: Description: This API with standard signature format is called from
2390: the security constraints to validate whether a change is
2391: allowed on an order line.
2392: This API gets called for every item type. It returns
2393: x_result = 0 if the item is a config item and the line is
2466:
2467: /**************************************************************************
2468:
2469: Procedure: configuration_created_for_pto
2470: Parameters: p_application_id (standard signature format)
2471: p_entity_short_name
2472: p_validation_entity_short_name
2473: p_validation_tmplt_short_name
2474: p_record_set_short_name
2473: p_validation_tmplt_short_name
2474: p_record_set_short_name
2475: p_scope
2476: x_result
2477: Description: This API with standard signature format is called from
2478: the security constraints to validate whether a change is
2479: allowed on an order line.
2480: This API gets called for every item type. It returns
2481: x_result = 0 if the item is not a PTO item or if it is a
2612:
2613: /**************************************************************************
2614:
2615: Procedure: Top_Ato_Model
2616: Parameters: p_application_id (standard signature format)
2617: p_entity_short_name
2618: p_validation_entity_short_name
2619: p_validation_tmplt_short_name
2620: p_record_set_short_name
2619: p_validation_tmplt_short_name
2620: p_record_set_short_name
2621: p_scope
2622: x_result
2623: Description: This API with standard signature format is called from
2624: the security constraints to validate whether a change is
2625: allowed on an order line.
2626: This API gets called for every item type. It returns
2627: x_result = 1 if the item is a top level ATO Model.
2681:
2682: /**************************************************************************
2683:
2684: Procedure: Config_Line
2685: Parameters: p_application_id (standard signature format)
2686: p_entity_short_name
2687: p_validation_entity_short_name
2688: p_validation_tmplt_short_name
2689: p_record_set_short_name
2688: p_validation_tmplt_short_name
2689: p_record_set_short_name
2690: p_scope
2691: x_result
2692: Description: This API with standard signature format is called from
2693: the security constraints to validate whether a change is
2694: allowed on an order line.
2695: This API gets called for every item type. It returns
2696: x_result = 0 if the item is a config item and the line is
2967: BEGIN
2968:
2969: savepoint before_process;
2970:
2971: OE_STANDARD_WF.Set_Msg_Context(p_actid);
2972: IF PG_DEBUG <> 0 THEN
2973: oe_debug_pub.add('auto_create_pur_req: ' || 'CTO WF Activity: auto_create_pur_req', 1);
2974: END IF;
2975:
3160: END IF; -- check if the record is already being processed by the concurrent request.
3161:
3162: end if; -- end of p_funcmode check
3163:
3164: OE_STANDARD_WF.Save_Messages;
3165: OE_STANDARD_WF.Clear_Msg_Context;
3166:
3167: EXCEPTION
3168: WHEN FND_API.G_EXC_ERROR THEN
3161:
3162: end if; -- end of p_funcmode check
3163:
3164: OE_STANDARD_WF.Save_Messages;
3165: OE_STANDARD_WF.Clear_Msg_Context;
3166:
3167: EXCEPTION
3168: WHEN FND_API.G_EXC_ERROR THEN
3169: IF PG_DEBUG <> 0 THEN
3240: FROM OE_ORDER_LINES_ALL
3241: WHERE line_id = oe_line_security.g_record.line_id;
3242:
3243:
3244: IF l_item_type_code in ('STANDARD','OPTION') AND
3245: l_ato_line_id = oe_line_security.g_record.line_id THEN
3246:
3247: CTO_UTILITY_PK.query_sourcing_org(
3248: p_inventory_item_id => l_inv_item_id,
3355: select ato_line_id, header_id , inventory_item_id
3356: into l_ato_line_id, l_header_id , l_cfg_item_id
3357: from oe_order_lines_all
3358: where line_id = oe_line_security.g_record.line_id
3359: and item_type_code <> 'STANDARD'
3360: and ato_line_id is not null;
3361:
3362:
3363: -- check if the config item is created
3477: -- p_ordered_quantity Expects the order lines ordered quantity Required
3478:
3479: -- OUT : x_token1 The first part of flow status code.
3480: x_token2 The second part of flow status code.
3481: x_return_status Standard error message status
3482: x_msg_count Std. error message count in the message stack
3483: x_msg_data Std. error message data in the message stack
3484: -- Version :
3485: --