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_API_PK dependencies on STANDARD

Line 32: | item_type_code = 'Standard' and |

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 |

Line 725: x_return_status - standard API output parameter

721:
722: /*************************************************************************
723: Procedure: inventory_reservation_check
724: Parameters: p_order_line_id
725: x_return_status - standard API output parameter
726: x_msg_count - "
727: x_msg_data - "
728:
729: Description: Check if an order line status is either

Line 778: -- here, we pass the Standard item line,

774: , v_header_id
775: from oe_order_lines_all
776: where line_id = p_order_line_id;
777:
778: -- here, we pass the Standard item line,
779: -- namely, it will return a success. */
780:
781: -- removing code to allow reservation for ATOitem
782: -- by kkonada :adding below code again for dummy assignment*/

Line 796: ** ATO ITEMS will have ato_line_id = line_id and item_type_code either STANDARD

792: ** BUG#2234858, BUG#2312701 AND BUG#2358576 Drop Ship changes to disallow reservation
793: ** for config items and ato items of external source type
794: ** ATO ITEMS will behave as strict ATO ITEMS when under a PTO or stand alone.
795: ** ATO ITEMS lose their identity when they are put as options under ATO MODELS
796: ** ATO ITEMS will have ato_line_id = line_id and item_type_code either STANDARD
797: ** or OPTION when their identity is preserved.
798: */
799:
800: l_stmt_num := 30;

Line 806: --( v_item_type_code = 'STANDARD' OR v_item_type_code = 'OPTION' )

802: if( v_source_type_code = 'EXTERNAL' AND
803: ( ( v_item_type_code = 'CONFIG' ) OR
804: ( ( v_ato_line_id = p_order_line_id AND
805: --Adding INCLUDED item type code for SUN ER#9793792
806: --( v_item_type_code = 'STANDARD' OR v_item_type_code = 'OPTION' )
807: ( v_item_type_code = 'STANDARD' OR v_item_type_code = 'OPTION' OR v_item_type_code = 'INCLUDED')
808: )
809: )
810: )

Line 807: ( v_item_type_code = 'STANDARD' OR v_item_type_code = 'OPTION' OR v_item_type_code = 'INCLUDED')

803: ( ( v_item_type_code = 'CONFIG' ) OR
804: ( ( v_ato_line_id = p_order_line_id AND
805: --Adding INCLUDED item type code for SUN ER#9793792
806: --( v_item_type_code = 'STANDARD' OR v_item_type_code = 'OPTION' )
807: ( v_item_type_code = 'STANDARD' OR v_item_type_code = 'OPTION' OR v_item_type_code = 'INCLUDED')
808: )
809: )
810: )
811: )then

Line 959: x_return_status - standard API output parameter

955:
956: /*************************************************************************
957: Procedure: wf_update_after_inv_reserv
958: Parameters: p_order_line_id
959: x_return_status - standard API output parameter
960: x_msg_count - "
961: x_msg_data - "
962:
963: Description: update an order line status after inventory reservation

Line 1025: IF ( (upper(v_item_type_code) = 'STANDARD') -- Ato item line

1021: oe_debug_pub.add('wf_update_after_inv_reserv: p_order_line_id:' || p_order_line_id);
1022: End if;
1023:
1024:
1025: IF ( (upper(v_item_type_code) = 'STANDARD') -- Ato item line
1026: OR (upper(v_item_type_code) = 'OPTION') --fix for bug#1874380
1027: --Adding INCLUDED item type code for SUN ER#9793792
1028: OR (upper(v_item_type_code) = 'INCLUDED')
1029: )

Line 1040: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'item_type_code is STANDARD/OPTION/INCLUDED => an ato item', 4);

1036: l_stmt_num := 20;
1037:
1038: IF PG_DEBUG <> 0 THEN
1039: --SUN ER#9793792: Changed the debug message
1040: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'item_type_code is STANDARD/OPTION/INCLUDED => an ato item', 4);
1041: END IF;--fix for bug#1874380
1042: If PG_DEBUG <> 0 Then
1043: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Before querying wf_activity_status..');
1044: End if;

Line 1399: x_return_status - standard API output parameter

1395: /*************************************************************************
1396: Procedure: inventory_unreservation_check
1397: Parameters: p_order_line_id
1398: p_rsv_quantity - Unreservation Quantity
1399: x_return_status - standard API output parameter
1400: x_msg_count - "
1401: x_msg_data - "
1402:
1403: Description: Check if an order line status is

Line 1461: --if (((upper(v_item_type_code) = 'STANDARD') OR (upper(v_item_type_code) = 'OPTION'))

1457: -- For ATO items and CONFIG items, we should check the qty being unreserved.
1458: --
1459:
1460: --Adding INCLUDED item type code for SUN ER#9793792
1461: --if (((upper(v_item_type_code) = 'STANDARD') OR (upper(v_item_type_code) = 'OPTION'))
1462: --fix for bug#1874380
1463: if (( (upper(v_item_type_code) = 'STANDARD')
1464: OR (upper(v_item_type_code) = 'OPTION')
1465: OR (upper(v_item_type_code) = 'INCLUDED')

Line 1463: if (( (upper(v_item_type_code) = 'STANDARD')

1459:
1460: --Adding INCLUDED item type code for SUN ER#9793792
1461: --if (((upper(v_item_type_code) = 'STANDARD') OR (upper(v_item_type_code) = 'OPTION'))
1462: --fix for bug#1874380
1463: if (( (upper(v_item_type_code) = 'STANDARD')
1464: OR (upper(v_item_type_code) = 'OPTION')
1465: OR (upper(v_item_type_code) = 'INCLUDED')
1466: )
1467: AND (v_ato_line_id = p_order_line_id )

Line 1555: x_return_status - standard API output parameter

1551:
1552: /*************************************************************************
1553: Procedure: wf_update_after_inv_unreserv
1554: Parameters: p_order_line_id
1555: x_return_status - standard API output parameter
1556: x_msg_count - "
1557: x_msg_data - "
1558:
1559: Description: update an order line status after inventory unreservation

Line 1698: --IF ((upper(v_item_type_code) = 'STANDARD' OR upper(v_item_type_code) = 'OPTION' ) --fix for bug# 1874380

1694: if v_open_flag = 'Y' then --Bugfix 7214005
1695: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => p_order_line_id ); --bugfix 1799874
1696:
1697: --Adding INCLUDED item type code for SUN ER#9793792
1698: --IF ((upper(v_item_type_code) = 'STANDARD' OR upper(v_item_type_code) = 'OPTION' ) --fix for bug# 1874380
1699: IF (( upper(v_item_type_code) = 'STANDARD'
1700: OR upper(v_item_type_code) = 'OPTION'
1701: OR upper(v_item_type_code) = 'INCLUDED'
1702: )

Line 1699: IF (( upper(v_item_type_code) = 'STANDARD'

1695: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => p_order_line_id ); --bugfix 1799874
1696:
1697: --Adding INCLUDED item type code for SUN ER#9793792
1698: --IF ((upper(v_item_type_code) = 'STANDARD' OR upper(v_item_type_code) = 'OPTION' ) --fix for bug# 1874380
1699: IF (( upper(v_item_type_code) = 'STANDARD'
1700: OR upper(v_item_type_code) = 'OPTION'
1701: OR upper(v_item_type_code) = 'INCLUDED'
1702: )
1703: AND (v_ato_line_id = p_order_line_id)

Line 2128: Parameters: p_application_id (standard signature format)

2124:
2125: /**************************************************************************
2126:
2127: Procedure: configuration_item_created
2128: Parameters: p_application_id (standard signature format)
2129: p_entity_short_name
2130: p_validation_entity_short_name
2131: p_validation_tmplt_short_name
2132: p_record_set_short_name

Line 2135: Description: This API with standard signature format is used to check is

2131: p_validation_tmplt_short_name
2132: p_record_set_short_name
2133: p_scope
2134: x_result
2135: Description: This API with standard signature format is used to check is
2136: a configured item is created. This condition is applied to
2137: an option line.
2138:
2139: *****************************************************************************/

Line 2225: Parameters: p_application_id (standard signature format)

2221:
2222: /**************************************************************************
2223:
2224: Procedure: configuration_created
2225: Parameters: p_application_id (standard signature format)
2226: p_entity_short_name
2227: p_validation_entity_short_name
2228: p_validation_tmplt_short_name
2229: p_record_set_short_name

Line 2232: Description: This API with standard signature format is called from

2228: p_validation_tmplt_short_name
2229: p_record_set_short_name
2230: p_scope
2231: x_result
2232: Description: This API with standard signature format is called from
2233: the security constraints to validate whether a change is
2234: allowed on an order line.
2235: This API gets called for every item type. It returns
2236: x_result = 0 if the item is not part of an ATO

Line 2269: and item_type_code <> 'STANDARD'

2265: select ato_line_id, header_id
2266: into l_ato_line_id, l_header_id
2267: from oe_order_lines_all
2268: where line_id = oe_line_security.g_record.line_id
2269: and item_type_code <> 'STANDARD'
2270: and ato_line_id is not null;
2271:
2272: -- check if the config item is created
2273: -- adding join to header_id for performance

Line 2409: Parameters: p_application_id (standard signature format)

2405:
2406: /**************************************************************************
2407:
2408: Procedure: Update_Config_Line
2409: Parameters: p_application_id (standard signature format)
2410: p_entity_short_name
2411: p_validation_entity_short_name
2412: p_validation_tmplt_short_name
2413: p_record_set_short_name

Line 2416: Description: This API with standard signature format is called from

2412: p_validation_tmplt_short_name
2413: p_record_set_short_name
2414: p_scope
2415: x_result
2416: Description: This API with standard signature format is called from
2417: the security constraints to validate whether a change is
2418: allowed on an order line.
2419: This API gets called for every item type. It returns
2420: x_result = 0 if the item is a config item and the line is

Line 2497: Parameters: p_application_id (standard signature format)

2493:
2494: /**************************************************************************
2495:
2496: Procedure: configuration_created_for_pto
2497: Parameters: p_application_id (standard signature format)
2498: p_entity_short_name
2499: p_validation_entity_short_name
2500: p_validation_tmplt_short_name
2501: p_record_set_short_name

Line 2504: Description: This API with standard signature format is called from

2500: p_validation_tmplt_short_name
2501: p_record_set_short_name
2502: p_scope
2503: x_result
2504: Description: This API with standard signature format is called from
2505: the security constraints to validate whether a change is
2506: allowed on an order line.
2507: This API gets called for every item type. It returns
2508: x_result = 0 if the item is not a PTO item or if it is a

Line 2643: Parameters: p_application_id (standard signature format)

2639:
2640: /**************************************************************************
2641:
2642: Procedure: Top_Ato_Model
2643: Parameters: p_application_id (standard signature format)
2644: p_entity_short_name
2645: p_validation_entity_short_name
2646: p_validation_tmplt_short_name
2647: p_record_set_short_name

Line 2650: Description: This API with standard signature format is called from

2646: p_validation_tmplt_short_name
2647: p_record_set_short_name
2648: p_scope
2649: x_result
2650: Description: This API with standard signature format is called from
2651: the security constraints to validate whether a change is
2652: allowed on an order line.
2653: This API gets called for every item type. It returns
2654: x_result = 1 if the item is a top level ATO Model.

Line 2712: Parameters: p_application_id (standard signature format)

2708:
2709: /**************************************************************************
2710:
2711: Procedure: Config_Line
2712: Parameters: p_application_id (standard signature format)
2713: p_entity_short_name
2714: p_validation_entity_short_name
2715: p_validation_tmplt_short_name
2716: p_record_set_short_name

Line 2719: Description: This API with standard signature format is called from

2715: p_validation_tmplt_short_name
2716: p_record_set_short_name
2717: p_scope
2718: x_result
2719: Description: This API with standard signature format is called from
2720: the security constraints to validate whether a change is
2721: allowed on an order line.
2722: This API gets called for every item type. It returns
2723: x_result = 0 if the item is a config item and the line is

Line 3001: OE_STANDARD_WF.Set_Msg_Context(p_actid);

2997: BEGIN
2998:
2999: savepoint before_process;
3000:
3001: OE_STANDARD_WF.Set_Msg_Context(p_actid);
3002: IF PG_DEBUG <> 0 THEN
3003: oe_debug_pub.add('auto_create_pur_req: ' || 'CTO WF Activity: auto_create_pur_req', 1);
3004: END IF;
3005:

Line 3194: OE_STANDARD_WF.Save_Messages;

3190: END IF; -- check if the record is already being processed by the concurrent request.
3191:
3192: end if; -- end of p_funcmode check
3193:
3194: OE_STANDARD_WF.Save_Messages;
3195: OE_STANDARD_WF.Clear_Msg_Context;
3196:
3197: EXCEPTION
3198: WHEN FND_API.G_EXC_ERROR THEN

Line 3195: OE_STANDARD_WF.Clear_Msg_Context;

3191:
3192: end if; -- end of p_funcmode check
3193:
3194: OE_STANDARD_WF.Save_Messages;
3195: OE_STANDARD_WF.Clear_Msg_Context;
3196:
3197: EXCEPTION
3198: WHEN FND_API.G_EXC_ERROR THEN
3199: IF PG_DEBUG <> 0 THEN

Line 3275: --IF l_item_type_code in ('STANDARD','OPTION') AND

3271: WHERE line_id = oe_line_security.g_record.line_id;
3272:
3273:
3274: --Adding INCLUDED item type code for SUN ER#9793792
3275: --IF l_item_type_code in ('STANDARD','OPTION') AND
3276: IF l_item_type_code in ('STANDARD','OPTION','INCLUDED') AND
3277: l_ato_line_id = oe_line_security.g_record.line_id THEN
3278:
3279: CTO_UTILITY_PK.query_sourcing_org(

Line 3276: IF l_item_type_code in ('STANDARD','OPTION','INCLUDED') AND

3272:
3273:
3274: --Adding INCLUDED item type code for SUN ER#9793792
3275: --IF l_item_type_code in ('STANDARD','OPTION') AND
3276: IF l_item_type_code in ('STANDARD','OPTION','INCLUDED') AND
3277: l_ato_line_id = oe_line_security.g_record.line_id THEN
3278:
3279: CTO_UTILITY_PK.query_sourcing_org(
3280: p_inventory_item_id => l_inv_item_id,

Line 3391: and item_type_code <> 'STANDARD'

3387: select ato_line_id, header_id , inventory_item_id
3388: into l_ato_line_id, l_header_id , l_cfg_item_id
3389: from oe_order_lines_all
3390: where line_id = oe_line_security.g_record.line_id
3391: and item_type_code <> 'STANDARD'
3392: and ato_line_id is not null;
3393:
3394:
3395: -- check if the config item is created

Line 3513: x_return_status Standard error message status

3509: -- p_ordered_quantity Expects the order lines ordered quantity Required
3510:
3511: -- OUT : x_token1 The first part of flow status code.
3512: x_token2 The second part of flow status code.
3513: x_return_status Standard error message status
3514: x_msg_count Std. error message count in the message stack
3515: x_msg_data Std. error message data in the message stack
3516: -- Version :
3517: --