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 STANDARD

Line 56: | item_type_code = 'Standard' and |

52: | to support ATO item under a PTO. |
53: | item_type_code for an ato item under PTO |
54: | is 'OPTION' and top_model_line_id will NOT be|
55: | null, UNLIKE an ato item order, where |
56: | item_type_code = 'Standard' and |
57: | top_model_lined_id is null |
58: | This fix has actually been provided in |
59: | branched code 115.57.1155.5 |
60: | |

Line 341: OE_STANDARD_WF.Set_Msg_Context(p_actid);

337: oe_debug_pub.add('create_config_item_wf: ' || 'Time Stamp ' || to_char( sysdate , 'dd-mon-yyyy hh24:mi:ss' ));
338: END IF;
339:
340:
341: OE_STANDARD_WF.Set_Msg_Context(p_actid);
342:
343: savepoint before_item_creation;
344:
345: if (p_funcmode = 'RUN') then

Line 1353: OE_STANDARD_WF.Save_Messages;

1349: --fnd_message.set_token('CONFIG_ITEM', l_config_item_name );
1350:
1351: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
1352:
1353: OE_STANDARD_WF.Save_Messages;
1354: OE_STANDARD_WF.Clear_Msg_Context;
1355:
1356:
1357: end if ; /* l_perform_match = 'Y' */

Line 1354: OE_STANDARD_WF.Clear_Msg_Context;

1350:
1351: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
1352:
1353: OE_STANDARD_WF.Save_Messages;
1354: OE_STANDARD_WF.Clear_Msg_Context;
1355:
1356:
1357: end if ; /* l_perform_match = 'Y' */
1358:

Line 1396: OE_STANDARD_WF.Save_Messages;

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:
1399:
1400: EXCEPTION

Line 1397: OE_STANDARD_WF.Clear_Msg_Context;

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:
1399:
1400: EXCEPTION
1401:

Line 1409: OE_STANDARD_WF.Save_Messages;

1405: to_char(l_stmt_num) || ':' ||
1406: l_x_error_msg);
1407: END IF;
1408: fnd_msg_pub.count_and_get(p_data=>x_msg_data,p_count=>x_msg_count);
1409: OE_STANDARD_WF.Save_Messages;
1410: OE_STANDARD_WF.Clear_Msg_Context;
1411: x_result := 'COMPLETE:INCOMPLETE';
1412: rollback to savepoint before_item_creation;
1413:

Line 1410: OE_STANDARD_WF.Clear_Msg_Context;

1406: l_x_error_msg);
1407: END IF;
1408: fnd_msg_pub.count_and_get(p_data=>x_msg_data,p_count=>x_msg_count);
1409: OE_STANDARD_WF.Save_Messages;
1410: OE_STANDARD_WF.Clear_Msg_Context;
1411: x_result := 'COMPLETE:INCOMPLETE';
1412: rollback to savepoint before_item_creation;
1413:
1414: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1420: OE_STANDARD_WF.Save_Messages;

1416: OE_DEBUG_PUB.add('create_config_item_wf: ' || 'CTO_WORKFLOW.create_config_item_wf ' ||
1417: to_char(l_stmt_num) || ':' ||
1418: l_x_error_msg);
1419: END IF;
1420: OE_STANDARD_WF.Save_Messages;
1421: OE_STANDARD_WF.Clear_Msg_Context;
1422: wf_core.context('CTO_WORKFLOW', 'create_config_item_wf',
1423: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
1424: raise;

Line 1421: OE_STANDARD_WF.Clear_Msg_Context;

1417: to_char(l_stmt_num) || ':' ||
1418: l_x_error_msg);
1419: END IF;
1420: OE_STANDARD_WF.Save_Messages;
1421: OE_STANDARD_WF.Clear_Msg_Context;
1422: wf_core.context('CTO_WORKFLOW', 'create_config_item_wf',
1423: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
1424: raise;
1425:

Line 1436: OE_STANDARD_WF.Save_Messages;

1432: END IF;
1433: wf_core.context('CTO_WORKFLOW', 'create_config_item_wf',
1434: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
1435:
1436: OE_STANDARD_WF.Save_Messages;
1437: OE_STANDARD_WF.Clear_Msg_Context;
1438:
1439: raise;
1440:

Line 1437: OE_STANDARD_WF.Clear_Msg_Context;

1433: wf_core.context('CTO_WORKFLOW', 'create_config_item_wf',
1434: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
1435:
1436: OE_STANDARD_WF.Save_Messages;
1437: OE_STANDARD_WF.Clear_Msg_Context;
1438:
1439: raise;
1440:
1441: END create_config_item_wf;

Line 1825: OE_STANDARD_WF.Save_Messages;

1821:
1822: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
1823:
1824:
1825: OE_STANDARD_WF.Save_Messages;
1826: OE_STANDARD_WF.Clear_Msg_Context;
1827:
1828: end if ;
1829:

Line 1826: OE_STANDARD_WF.Clear_Msg_Context;

1822: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
1823:
1824:
1825: OE_STANDARD_WF.Save_Messages;
1826: OE_STANDARD_WF.Clear_Msg_Context;
1827:
1828: end if ;
1829:
1830:

Line 1932: OE_STANDARD_WF.Save_Messages;

1928: --fnd_message.set_token('SHIP_ORG', l_organization_name );
1929:
1930: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
1931:
1932: OE_STANDARD_WF.Save_Messages;
1933: OE_STANDARD_WF.Clear_Msg_Context;
1934:
1935: end if;
1936:

Line 1933: OE_STANDARD_WF.Clear_Msg_Context;

1929:
1930: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
1931:
1932: OE_STANDARD_WF.Save_Messages;
1933: OE_STANDARD_WF.Clear_Msg_Context;
1934:
1935: end if;
1936:
1937: x_reserve_status := 'NOQTY' ;

Line 1977: OE_STANDARD_WF.Save_Messages;

1973: --fnd_message.set_token('CONFIG_ITEM', l_config_item_name );
1974:
1975: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
1976:
1977: OE_STANDARD_WF.Save_Messages;
1978: OE_STANDARD_WF.Clear_Msg_Context;
1979:
1980: end if ;
1981:

Line 1978: OE_STANDARD_WF.Clear_Msg_Context;

1974:
1975: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
1976:
1977: OE_STANDARD_WF.Save_Messages;
1978: OE_STANDARD_WF.Clear_Msg_Context;
1979:
1980: end if ;
1981:
1982: x_reserve_status := 'MATCH' ;

Line 2000: OE_STANDARD_WF.Save_Messages;

1996: OE_DEBUG_PUB.add('create_reservation: ' || 'RESERVATION_ERROR ' , 1 );
1997:
1998: OE_DEBUG_PUB.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation ' || to_char(l_stmt_num) );
1999: END IF;
2000: OE_STANDARD_WF.Save_Messages;
2001: OE_STANDARD_WF.Clear_Msg_Context;
2002:
2003: x_return_status := FND_API.G_RET_STS_ERROR ;
2004:

Line 2001: OE_STANDARD_WF.Clear_Msg_Context;

1997:
1998: OE_DEBUG_PUB.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation ' || to_char(l_stmt_num) );
1999: END IF;
2000: OE_STANDARD_WF.Save_Messages;
2001: OE_STANDARD_WF.Clear_Msg_Context;
2002:
2003: x_return_status := FND_API.G_RET_STS_ERROR ;
2004:
2005:

Line 2022: OE_STANDARD_WF.Save_Messages;

2018: IF PG_DEBUG <> 0 THEN
2019: OE_DEBUG_PUB.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation ' || to_char(l_stmt_num) );
2020: END IF;
2021:
2022: OE_STANDARD_WF.Save_Messages;
2023: OE_STANDARD_WF.Clear_Msg_Context;
2024:
2025: x_return_status := FND_API.G_RET_STS_ERROR ;
2026:

Line 2023: OE_STANDARD_WF.Clear_Msg_Context;

2019: OE_DEBUG_PUB.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation ' || to_char(l_stmt_num) );
2020: END IF;
2021:
2022: OE_STANDARD_WF.Save_Messages;
2023: OE_STANDARD_WF.Clear_Msg_Context;
2024:
2025: x_return_status := FND_API.G_RET_STS_ERROR ;
2026:
2027: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2034: OE_STANDARD_WF.Save_Messages;

2030: OE_DEBUG_PUB.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation ' ||
2031: to_char(l_stmt_num) || ':' ||
2032: l_x_error_msg);
2033: END IF;
2034: OE_STANDARD_WF.Save_Messages;
2035: OE_STANDARD_WF.Clear_Msg_Context;
2036:
2037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2038:

Line 2035: OE_STANDARD_WF.Clear_Msg_Context;

2031: to_char(l_stmt_num) || ':' ||
2032: l_x_error_msg);
2033: END IF;
2034: OE_STANDARD_WF.Save_Messages;
2035: OE_STANDARD_WF.Clear_Msg_Context;
2036:
2037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2038:
2039: when OTHERS then

Line 2060: The format follows the standard Workflow API format.

2056: Procedure: rsv_before_booking_wf
2057: Description: This works only for an ATO item .
2058: This procedure gets called just before "Create supply order Eligble"
2059: activity in the ATO workflow.
2060: The format follows the standard Workflow API format.
2061:
2062: Parameters:
2063: =============================================================================*/
2064:

Line 2101: OE_STANDARD_WF.Set_Msg_Context(p_actid);

2097: l_x_error_msg Varchar2(2000);
2098:
2099: v_aps_version number ;
2100: BEGIN
2101: OE_STANDARD_WF.Set_Msg_Context(p_actid);
2102: IF PG_DEBUG <> 0 THEN
2103: oe_debug_pub.add('rsv_before_booking_wf: ' || 'CTO Activity: Check Reservation before booking activity ', 1);
2104: END IF;
2105:

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

2266:
2267:
2268: --if an ato item
2269:
2270: IF ((upper(v_item_type_code) = 'STANDARD')
2271: OR (upper(v_item_type_code) = 'OPTION') --bug#1874380
2272: --Adding INCLUDED item type code for SUN ER#9793792
2273: OR (upper(v_item_type_code) = 'INCLUDED')
2274: )

Line 2357: OE_STANDARD_WF.Save_Messages;

2353: --end bug#1861812
2354:
2355: end if ; /*p_funcmode ='RUN"*/
2356:
2357: OE_STANDARD_WF.Save_Messages;
2358: OE_STANDARD_WF.Clear_Msg_Context;
2359:
2360: EXCEPTION
2361: when FND_API.G_EXC_ERROR then

Line 2358: OE_STANDARD_WF.Clear_Msg_Context;

2354:
2355: end if ; /*p_funcmode ='RUN"*/
2356:
2357: OE_STANDARD_WF.Save_Messages;
2358: OE_STANDARD_WF.Clear_Msg_Context;
2359:
2360: EXCEPTION
2361: when FND_API.G_EXC_ERROR then
2362: IF PG_DEBUG <> 0 THEN

Line 2365: OE_STANDARD_WF.Save_Messages;

2361: when FND_API.G_EXC_ERROR then
2362: IF PG_DEBUG <> 0 THEN
2363: OE_DEBUG_PUB.add('rsv_before_booking_wf: ' || 'CTO_WORKFLOW.rsv_before_booking_wf ' || to_char(l_stmt_num) );
2364: END IF;
2365: OE_STANDARD_WF.Save_Messages;
2366: OE_STANDARD_WF.Clear_Msg_Context;
2367: raise; -- can be re-tried
2368:
2369: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2366: OE_STANDARD_WF.Clear_Msg_Context;

2362: IF PG_DEBUG <> 0 THEN
2363: OE_DEBUG_PUB.add('rsv_before_booking_wf: ' || 'CTO_WORKFLOW.rsv_before_booking_wf ' || to_char(l_stmt_num) );
2364: END IF;
2365: OE_STANDARD_WF.Save_Messages;
2366: OE_STANDARD_WF.Clear_Msg_Context;
2367: raise; -- can be re-tried
2368:
2369: when FND_API.G_EXC_UNEXPECTED_ERROR then
2370: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

Line 2381: OE_STANDARD_WF.Save_Messages;

2377: IF PG_DEBUG <> 0 THEN
2378: oe_debug_pub.add('rsv_before_booking_wf: ' || 'corresponds to unexpected error at called program check_inv_rsv_exists '||'
2379: l_stmt_num :'|| l_stmt_num ||sqlerrm, 1);
2380: END IF;
2381: OE_STANDARD_WF.Save_Messages;
2382: OE_STANDARD_WF.Clear_Msg_Context;
2383: wf_core.context('CTO_WORKFLOW', 'rsv_before_booking_wf', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2384: raise;
2385:

Line 2382: OE_STANDARD_WF.Clear_Msg_Context;

2378: oe_debug_pub.add('rsv_before_booking_wf: ' || 'corresponds to unexpected error at called program check_inv_rsv_exists '||'
2379: l_stmt_num :'|| l_stmt_num ||sqlerrm, 1);
2380: END IF;
2381: OE_STANDARD_WF.Save_Messages;
2382: OE_STANDARD_WF.Clear_Msg_Context;
2383: wf_core.context('CTO_WORKFLOW', 'rsv_before_booking_wf', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2384: raise;
2385:
2386: when OTHERS then

Line 2612: format is follows the standard Workflow API format.

2608: obsolete ?
2609: Procedure: check_reservation_status_wf
2610: Description: This procedure gets called when executing the
2611: Check Reservation activity in the ATO workflow. The
2612: format is follows the standard Workflow API format.
2613:
2614: More to come...
2615: Parameters:
2616: =============================================================================*/

Line 2640: OE_STANDARD_WF.Set_Msg_Context(p_actid);

2636:
2637: PROCESS_ERROR EXCEPTION;
2638: UNEXP_ERROR EXCEPTION;
2639: BEGIN
2640: OE_STANDARD_WF.Set_Msg_Context(p_actid);
2641: IF PG_DEBUG <> 0 THEN
2642: oe_debug_pub.add('check_reservation_status_wf: ' || 'CTO Activity: Check Reservation', 1);
2643: END IF;
2644:

Line 2719: OE_STANDARD_WF.Save_Messages;

2715: END IF;
2716:
2717: end if; /* p_funcmode = 'RUN' */
2718:
2719: OE_STANDARD_WF.Save_Messages;
2720: OE_STANDARD_WF.Clear_Msg_Context;
2721:
2722: EXCEPTION
2723: when NO_DATA_FOUND then

Line 2720: OE_STANDARD_WF.Clear_Msg_Context;

2716:
2717: end if; /* p_funcmode = 'RUN' */
2718:
2719: OE_STANDARD_WF.Save_Messages;
2720: OE_STANDARD_WF.Clear_Msg_Context;
2721:
2722: EXCEPTION
2723: when NO_DATA_FOUND then
2724: IF PG_DEBUG <> 0 THEN

Line 2727: OE_STANDARD_WF.Save_Messages;

2723: when NO_DATA_FOUND then
2724: IF PG_DEBUG <> 0 THEN
2725: oe_debug_pub.add('check_reservation_status_wf: ' || 'Configuration Line Not Reserved.', 1);
2726: END IF;
2727: OE_STANDARD_WF.Save_Messages;
2728: OE_STANDARD_WF.Clear_Msg_Context;
2729: x_result := 'COMPLETE';
2730:
2731: when PROCESS_ERROR then

Line 2728: OE_STANDARD_WF.Clear_Msg_Context;

2724: IF PG_DEBUG <> 0 THEN
2725: oe_debug_pub.add('check_reservation_status_wf: ' || 'Configuration Line Not Reserved.', 1);
2726: END IF;
2727: OE_STANDARD_WF.Save_Messages;
2728: OE_STANDARD_WF.Clear_Msg_Context;
2729: x_result := 'COMPLETE';
2730:
2731: when PROCESS_ERROR then
2732: IF PG_DEBUG <> 0 THEN

Line 2737: OE_STANDARD_WF.Save_Messages;

2733: OE_DEBUG_PUB.add('check_reservation_status_wf: ' || 'CTO_WORKFLOW.check_reservation_status_wf ' ||
2734: to_char(l_stmt_num) || ':' ||
2735: substrb(sqlerrm, 1, 100));
2736: END IF;
2737: OE_STANDARD_WF.Save_Messages;
2738: OE_STANDARD_WF.Clear_Msg_Context;
2739:
2740: when UNEXP_ERROR then
2741: IF PG_DEBUG <> 0 THEN

Line 2738: OE_STANDARD_WF.Clear_Msg_Context;

2734: to_char(l_stmt_num) || ':' ||
2735: substrb(sqlerrm, 1, 100));
2736: END IF;
2737: OE_STANDARD_WF.Save_Messages;
2738: OE_STANDARD_WF.Clear_Msg_Context;
2739:
2740: when UNEXP_ERROR then
2741: IF PG_DEBUG <> 0 THEN
2742: OE_DEBUG_PUB.add('check_reservation_status_wf: ' || 'CTO_WORKFLOW.create_config_item_wf ' ||

Line 2746: OE_STANDARD_WF.Save_Messages;

2742: OE_DEBUG_PUB.add('check_reservation_status_wf: ' || 'CTO_WORKFLOW.create_config_item_wf ' ||
2743: to_char(l_stmt_num) || ':' ||
2744: l_return_status);
2745: END IF;
2746: OE_STANDARD_WF.Save_Messages;
2747: OE_STANDARD_WF.Clear_Msg_Context;
2748: wf_core.context('CTO_WORKFLOW', 'create_config_item_wf',
2749: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2750: raise;

Line 2747: OE_STANDARD_WF.Clear_Msg_Context;

2743: to_char(l_stmt_num) || ':' ||
2744: l_return_status);
2745: END IF;
2746: OE_STANDARD_WF.Save_Messages;
2747: OE_STANDARD_WF.Clear_Msg_Context;
2748: wf_core.context('CTO_WORKFLOW', 'create_config_item_wf',
2749: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2750: raise;
2751:

Line 2791: OE_STANDARD_WF.Set_Msg_Context(p_actid);

2787: l_status integer;
2788: UNEXP_ERROR exception;
2789:
2790: BEGIN
2791: OE_STANDARD_WF.Set_Msg_Context(p_actid);
2792: IF PG_DEBUG <> 0 THEN
2793: oe_debug_pub.add('calculate_cost_rollup_wf_ml: ' || 'CTO Activity: Calculate Cost Rollup', 1);
2794: END IF;
2795:

Line 2831: OE_STANDARD_WF.Save_Messages;

2827: x_result := 'COMPLETE';
2828:
2829: end if; /* end p_funcmode = 'RUN' */
2830:
2831: OE_STANDARD_WF.Save_Messages;
2832: OE_STANDARD_WF.Clear_Msg_Context;
2833:
2834: EXCEPTION
2835: when UNEXP_ERROR then

Line 2832: OE_STANDARD_WF.Clear_Msg_Context;

2828:
2829: end if; /* end p_funcmode = 'RUN' */
2830:
2831: OE_STANDARD_WF.Save_Messages;
2832: OE_STANDARD_WF.Clear_Msg_Context;
2833:
2834: EXCEPTION
2835: when UNEXP_ERROR then
2836: IF PG_DEBUG <> 0 THEN

Line 2841: OE_STANDARD_WF.Save_Messages;

2837: OE_DEBUG_PUB.add('calculate_cost_rollup_wf_ml: ' || 'CTO_WORKFLOW.calculate_cost_rollup_wf' ||
2838: to_char(l_stmt_num) || ':' ||
2839: l_x_msg_data);
2840: END IF;
2841: OE_STANDARD_WF.Save_Messages;
2842: OE_STANDARD_WF.Clear_Msg_Context;
2843: wf_core.context('CTO_WORKFLOW', 'calculate_cost_rollup_wf',
2844: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2845: raise;

Line 2842: OE_STANDARD_WF.Clear_Msg_Context;

2838: to_char(l_stmt_num) || ':' ||
2839: l_x_msg_data);
2840: END IF;
2841: OE_STANDARD_WF.Save_Messages;
2842: OE_STANDARD_WF.Clear_Msg_Context;
2843: wf_core.context('CTO_WORKFLOW', 'calculate_cost_rollup_wf',
2844: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2845: raise;
2846:

Line 2854: OE_STANDARD_WF.Save_Messages;

2850: to_char(l_stmt_num) || ':' ||
2851: substrb(sqlerrm, 1, 100),1);
2852: END IF;
2853: cto_msg_pub.cto_message('BOM', 'CTO_CALC_COST_ROLLUP_ERROR');
2854: OE_STANDARD_WF.Save_Messages;
2855: OE_STANDARD_WF.Clear_Msg_Context;
2856:
2857: when OTHERS then
2858: cto_msg_pub.cto_message('BOM', 'CTO_CALC_COST_ROLLUP_ERROR');

Line 2855: OE_STANDARD_WF.Clear_Msg_Context;

2851: substrb(sqlerrm, 1, 100),1);
2852: END IF;
2853: cto_msg_pub.cto_message('BOM', 'CTO_CALC_COST_ROLLUP_ERROR');
2854: OE_STANDARD_WF.Save_Messages;
2855: OE_STANDARD_WF.Clear_Msg_Context;
2856:
2857: when OTHERS then
2858: cto_msg_pub.cto_message('BOM', 'CTO_CALC_COST_ROLLUP_ERROR');
2859: IF PG_DEBUG <> 0 THEN

Line 2878: format is follows the standard Workflow API format.

2874: /*============================================================================
2875: Procedure: set_parameter_lead_time_wf_ml
2876: Description: This procedure gets called when executing the Calculate
2877: Leadtime activity in the ATO workflow. The
2878: format is follows the standard Workflow API format.
2879:
2880: More to come...
2881: Parameters:
2882: =============================================================================*/

Line 2917: OE_STANDARD_WF.Set_Msg_Context(p_actid);

2913: UNEXP_ERROR exception;
2914:
2915: BEGIN
2916:
2917: OE_STANDARD_WF.Set_Msg_Context(p_actid);
2918: IF PG_DEBUG <> 0 THEN
2919: oe_debug_pub.add('set_parameter_lead_time_wf_ml: ' || 'CTO Activity: Set Parameter lead Time', 1);
2920: END IF;
2921:

Line 2956: OE_STANDARD_WF.Save_Messages;

2952:
2953: x_result := 'COMPLETE';
2954: end if; /* p_funcmode = 'RUN' */
2955:
2956: OE_STANDARD_WF.Save_Messages;
2957: OE_STANDARD_WF.Clear_Msg_Context;
2958:
2959: EXCEPTION
2960:

Line 2957: OE_STANDARD_WF.Clear_Msg_Context;

2953: x_result := 'COMPLETE';
2954: end if; /* p_funcmode = 'RUN' */
2955:
2956: OE_STANDARD_WF.Save_Messages;
2957: OE_STANDARD_WF.Clear_Msg_Context;
2958:
2959: EXCEPTION
2960:
2961: when UNEXP_ERROR then

Line 2967: OE_STANDARD_WF.Save_Messages;

2963: OE_DEBUG_PUB.add('set_parameter_lead_time_wf_ml: ' || 'CTO_WORKFLOW.set_parameter_lead_time_wf_ml' ||
2964: to_char(l_stmt_num) || ':' ||
2965: l_x_error_msg);
2966: END IF;
2967: OE_STANDARD_WF.Save_Messages;
2968: OE_STANDARD_WF.Clear_Msg_Context;
2969: wf_core.context('CTO_WORKFLOW', 'set_parameter_lead_time_wf_ml',
2970: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2971: raise;

Line 2968: OE_STANDARD_WF.Clear_Msg_Context;

2964: to_char(l_stmt_num) || ':' ||
2965: l_x_error_msg);
2966: END IF;
2967: OE_STANDARD_WF.Save_Messages;
2968: OE_STANDARD_WF.Clear_Msg_Context;
2969: wf_core.context('CTO_WORKFLOW', 'set_parameter_lead_time_wf_ml',
2970: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2971: raise;
2972:

Line 2980: OE_STANDARD_WF.Save_Messages;

2976: || to_char(l_stmt_num) || ':' ||
2977: substrb(sqlerrm, 1, 100),1);
2978: END IF;
2979: cto_msg_pub.cto_message('BOM', 'CTO_CALC_LEAD_TIME_ERROR');
2980: OE_STANDARD_WF.Save_Messages;
2981: OE_STANDARD_WF.Clear_Msg_Context;
2982:
2983: when OTHERS then
2984: cto_msg_pub.cto_message('BOM', 'CTO_CALC_LEAD_TIME_ERROR');

Line 2981: OE_STANDARD_WF.Clear_Msg_Context;

2977: substrb(sqlerrm, 1, 100),1);
2978: END IF;
2979: cto_msg_pub.cto_message('BOM', 'CTO_CALC_LEAD_TIME_ERROR');
2980: OE_STANDARD_WF.Save_Messages;
2981: OE_STANDARD_WF.Clear_Msg_Context;
2982:
2983: when OTHERS then
2984: cto_msg_pub.cto_message('BOM', 'CTO_CALC_LEAD_TIME_ERROR');
2985: IF PG_DEBUG <> 0 THEN

Line 3002: format is follows the standard Workflow API format.

2998: /*============================================================================
2999: Procedure: check_supply_type_wf
3000: Description: This procedure gets called when executing the Reserve
3001: Configuration activity in the ATO workflow. The
3002: format is follows the standard Workflow API format.
3003:
3004: More to come...
3005: Parameters:
3006: =============================================================================*/

Line 3053: OE_STANDARD_WF.Set_Msg_Context(p_actid);

3049: v_x_hold_result_out VARCHAR2(1);
3050: v_x_hold_return_status VARCHAR2(1);
3051: v_x_error_msg VARCHAR2(150);
3052: BEGIN
3053: OE_STANDARD_WF.Set_Msg_Context(p_actid);
3054: IF PG_DEBUG <> 0 THEN
3055: oe_debug_pub.add('check_supply_type_wf: ' || 'CTO Activity: Check Supply Type', 1);
3056:
3057: oe_debug_pub.add('check_supply_type_wf: ' || 'Item key = '||p_itemkey,1);

Line 3144: OE_STANDARD_WF.Save_Messages;

3140: IF PG_DEBUG <> 0 THEN
3141: oe_debug_pub.add('check_supply_type_wf: ' || 'It is Config item Drop Ship case...',1);
3142: END IF;
3143: x_result := 'COMPLETE:DROPSHIP';
3144: OE_STANDARD_WF.Save_Messages;
3145: OE_STANDARD_WF.Clear_Msg_Context;
3146: return;
3147:
3148:

Line 3145: OE_STANDARD_WF.Clear_Msg_Context;

3141: oe_debug_pub.add('check_supply_type_wf: ' || 'It is Config item Drop Ship case...',1);
3142: END IF;
3143: x_result := 'COMPLETE:DROPSHIP';
3144: OE_STANDARD_WF.Save_Messages;
3145: OE_STANDARD_WF.Clear_Msg_Context;
3146: return;
3147:
3148:
3149: END IF ;

Line 3239: OE_STANDARD_WF.Save_Messages;

3235: END IF;
3236:
3237: --end bugfix 4556596
3238:
3239: OE_STANDARD_WF.Save_Messages;
3240: OE_STANDARD_WF.Clear_Msg_Context;
3241: return;
3242: END IF;
3243:

Line 3240: OE_STANDARD_WF.Clear_Msg_Context;

3236:
3237: --end bugfix 4556596
3238:
3239: OE_STANDARD_WF.Save_Messages;
3240: OE_STANDARD_WF.Clear_Msg_Context;
3241: return;
3242: END IF;
3243:
3244:

Line 3261: OE_STANDARD_WF.Save_Messages;

3257: oe_debug_pub.add('check_supply_type_wf: ' || 'It is ATO internal transfer case...',1);
3258: end if;
3259: END IF;
3260: x_result := 'COMPLETE:BUY';
3261: OE_STANDARD_WF.Save_Messages;
3262: OE_STANDARD_WF.Clear_Msg_Context;
3263: return;
3264: END IF;
3265:

Line 3262: OE_STANDARD_WF.Clear_Msg_Context;

3258: end if;
3259: END IF;
3260: x_result := 'COMPLETE:BUY';
3261: OE_STANDARD_WF.Save_Messages;
3262: OE_STANDARD_WF.Clear_Msg_Context;
3263: return;
3264: END IF;
3265:
3266: l_stmt_num := 400;

Line 3301: OE_STANDARD_WF.Save_Messages;

3297: oe_debug_pub.add('check_supply_type_wf: ' || 'Success in Check Supply Type', 1);
3298: END IF;
3299:
3300: end if; /* end p_funcmode = 'RUN'*/
3301: OE_STANDARD_WF.Save_Messages;
3302: OE_STANDARD_WF.Clear_Msg_Context;
3303:
3304: EXCEPTION
3305:

Line 3302: OE_STANDARD_WF.Clear_Msg_Context;

3298: END IF;
3299:
3300: end if; /* end p_funcmode = 'RUN'*/
3301: OE_STANDARD_WF.Save_Messages;
3302: OE_STANDARD_WF.Clear_Msg_Context;
3303:
3304: EXCEPTION
3305:
3306: when FND_API.G_EXC_ERROR then

Line 3311: OE_STANDARD_WF.Save_Messages;

3307: IF PG_DEBUG <> 0 THEN
3308: OE_DEBUG_PUB.add('check_supply_type_wf: ' || 'CTO_WORKFLOW.check_supply_type_wf ' ||
3309: to_char(l_stmt_num));
3310: END IF;
3311: OE_STANDARD_WF.Save_Messages;
3312: OE_STANDARD_WF.Clear_Msg_Context;
3313: x_result := 'COMPLETE:INCOMPLETE';
3314:
3315:

Line 3312: OE_STANDARD_WF.Clear_Msg_Context;

3308: OE_DEBUG_PUB.add('check_supply_type_wf: ' || 'CTO_WORKFLOW.check_supply_type_wf ' ||
3309: to_char(l_stmt_num));
3310: END IF;
3311: OE_STANDARD_WF.Save_Messages;
3312: OE_STANDARD_WF.Clear_Msg_Context;
3313: x_result := 'COMPLETE:INCOMPLETE';
3314:
3315:
3316: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 3321: OE_STANDARD_WF.Save_Messages;

3317: IF PG_DEBUG <> 0 THEN
3318: OE_DEBUG_PUB.add('check_supply_type_wf: ' || 'CTO_WORKFLOW.check_supply_type_wf ' ||
3319: to_char(l_stmt_num));
3320: END IF;
3321: OE_STANDARD_WF.Save_Messages;
3322: OE_STANDARD_WF.Clear_Msg_Context;
3323: wf_core.context('CTO_WORKFLOW', 'check_supply_type_wf',
3324: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
3325: raise;

Line 3322: OE_STANDARD_WF.Clear_Msg_Context;

3318: OE_DEBUG_PUB.add('check_supply_type_wf: ' || 'CTO_WORKFLOW.check_supply_type_wf ' ||
3319: to_char(l_stmt_num));
3320: END IF;
3321: OE_STANDARD_WF.Save_Messages;
3322: OE_STANDARD_WF.Clear_Msg_Context;
3323: wf_core.context('CTO_WORKFLOW', 'check_supply_type_wf',
3324: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
3325: raise;
3326:

Line 3335: OE_STANDARD_WF.Save_Messages;

3331: END IF;
3332: wf_core.context('CTO_WORKFLOW', 'check_supply_type_wf',
3333: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
3334:
3335: OE_STANDARD_WF.Save_Messages;
3336: OE_STANDARD_WF.Clear_Msg_Context;
3337:
3338: raise;
3339:

Line 3336: OE_STANDARD_WF.Clear_Msg_Context;

3332: wf_core.context('CTO_WORKFLOW', 'check_supply_type_wf',
3333: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
3334:
3335: OE_STANDARD_WF.Save_Messages;
3336: OE_STANDARD_WF.Clear_Msg_Context;
3337:
3338: raise;
3339:
3340: END check_supply_type_wf;

Line 3382: OE_STANDARD_WF.Set_Msg_Context(p_actid);

3378:
3379: BEGIN
3380: SAVEPOINT before_process;
3381:
3382: OE_STANDARD_WF.Set_Msg_Context(p_actid);
3383: IF PG_DEBUG <> 0 THEN
3384: oe_debug_pub.add('create_flow_schedule_wf: ' || 'CTO Activity: Create Flow Schedule', 1);
3385: END IF;
3386:

Line 3507: OE_STANDARD_WF.Save_Messages;

3503: return;
3504: end if;
3505: end if; /* p_funcmode = 'RUN' */
3506:
3507: OE_STANDARD_WF.Save_Messages;
3508: OE_STANDARD_WF.Clear_Msg_Context;
3509:
3510: EXCEPTION
3511:

Line 3508: OE_STANDARD_WF.Clear_Msg_Context;

3504: end if;
3505: end if; /* p_funcmode = 'RUN' */
3506:
3507: OE_STANDARD_WF.Save_Messages;
3508: OE_STANDARD_WF.Clear_Msg_Context;
3509:
3510: EXCEPTION
3511:
3512: when FND_API.G_EXC_ERROR then

Line 3517: OE_STANDARD_WF.Save_Messages;

3513: IF PG_DEBUG <> 0 THEN
3514: OE_DEBUG_PUB.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf raised exp error in stmt ' ||
3515: to_char(l_stmt_num) || ':' || l_x_error_msg);
3516: END IF;
3517: OE_STANDARD_WF.Save_Messages;
3518: OE_STANDARD_WF.Clear_Msg_Context;
3519: x_result := 'COMPLETE:INCOMPLETE';
3520: rollback to savepoint before_process;
3521: return;

Line 3518: OE_STANDARD_WF.Clear_Msg_Context;

3514: OE_DEBUG_PUB.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf raised exp error in stmt ' ||
3515: to_char(l_stmt_num) || ':' || l_x_error_msg);
3516: END IF;
3517: OE_STANDARD_WF.Save_Messages;
3518: OE_STANDARD_WF.Clear_Msg_Context;
3519: x_result := 'COMPLETE:INCOMPLETE';
3520: rollback to savepoint before_process;
3521: return;
3522:

Line 3530: OE_STANDARD_WF.Save_Messages;

3526: || to_char(l_stmt_num) || ':' ||
3527: substrb(sqlerrm, 1, 100),1);
3528: END IF;
3529: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_FLOW_SCHED_ERROR');
3530: OE_STANDARD_WF.Save_Messages;
3531: OE_STANDARD_WF.Clear_Msg_Context;
3532: x_result := 'COMPLETE:INCOMPLETE';
3533: rollback to savepoint before_process;
3534: return;

Line 3531: OE_STANDARD_WF.Clear_Msg_Context;

3527: substrb(sqlerrm, 1, 100),1);
3528: END IF;
3529: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_FLOW_SCHED_ERROR');
3530: OE_STANDARD_WF.Save_Messages;
3531: OE_STANDARD_WF.Clear_Msg_Context;
3532: x_result := 'COMPLETE:INCOMPLETE';
3533: rollback to savepoint before_process;
3534: return;
3535:

Line 3541: OE_STANDARD_WF.Save_Messages;

3537: IF PG_DEBUG <> 0 THEN
3538: OE_DEBUG_PUB.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf raised unexp error in stmt ' ||
3539: to_char(l_stmt_num) || ':' || l_x_error_msg);
3540: END IF;
3541: OE_STANDARD_WF.Save_Messages;
3542: OE_STANDARD_WF.Clear_Msg_Context;
3543: raise;
3544:
3545: when OTHERS then

Line 3542: OE_STANDARD_WF.Clear_Msg_Context;

3538: OE_DEBUG_PUB.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf raised unexp error in stmt ' ||
3539: to_char(l_stmt_num) || ':' || l_x_error_msg);
3540: END IF;
3541: OE_STANDARD_WF.Save_Messages;
3542: OE_STANDARD_WF.Clear_Msg_Context;
3543: raise;
3544:
3545: when OTHERS then
3546: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_FLOW_SCHED_ERROR');

Line 3729: OE_STANDARD_WF.Set_Msg_Context(p_actid);

3725: oe_debug_pub.add('set_parameter_work_order_wf: ' || 'Function Mode: ' || p_funcmode, 1);
3726:
3727: oe_debug_pub.add('set_parameter_work_order_wf: ' || 'CTO Activity: Set Parameter Work Order', 1);
3728: END IF;
3729: OE_STANDARD_WF.Set_Msg_Context(p_actid);
3730:
3731: if (p_funcmode = 'RUN') then
3732:
3733: -- Note: bugfix 3136206: The Lock_Line_Id api should be called BEFORE the SELECT FOR UPDATE

Line 3852: OE_STANDARD_WF.Save_Messages;

3848:
3849: x_result := 'COMPLETE';
3850: end if; /* p_funcmode = 'RUN' */
3851:
3852: OE_STANDARD_WF.Save_Messages;
3853: OE_STANDARD_WF.Clear_Msg_Context;
3854:
3855: EXCEPTION
3856:

Line 3853: OE_STANDARD_WF.Clear_Msg_Context;

3849: x_result := 'COMPLETE';
3850: end if; /* p_funcmode = 'RUN' */
3851:
3852: OE_STANDARD_WF.Save_Messages;
3853: OE_STANDARD_WF.Clear_Msg_Context;
3854:
3855: EXCEPTION
3856:
3857: --

Line 3870: OE_STANDARD_WF.Save_Messages;

3866:
3867: OE_DEBUG_PUB.add ('set_parameter_work_order_wf: ' || 'This line is being processed by another process.');
3868: END IF;
3869:
3870: OE_STANDARD_WF.Save_Messages;
3871: OE_STANDARD_WF.Clear_Msg_Context;
3872: x_result := 'COMPLETE:INCOMPLETE';
3873: return;
3874:

Line 3871: OE_STANDARD_WF.Clear_Msg_Context;

3867: OE_DEBUG_PUB.add ('set_parameter_work_order_wf: ' || 'This line is being processed by another process.');
3868: END IF;
3869:
3870: OE_STANDARD_WF.Save_Messages;
3871: OE_STANDARD_WF.Clear_Msg_Context;
3872: x_result := 'COMPLETE:INCOMPLETE';
3873: return;
3874:
3875:

Line 3882: OE_STANDARD_WF.Save_Messages;

3878: IF PG_DEBUG <> 0 THEN
3879: OE_DEBUG_PUB.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf raised exc error. ' ||
3880: to_char(l_stmt_num) );
3881: END IF;
3882: OE_STANDARD_WF.Save_Messages;
3883: OE_STANDARD_WF.Clear_Msg_Context;
3884: x_result := 'COMPLETE:INCOMPLETE';
3885: rollback to savepoint before_process;
3886: return;

Line 3883: OE_STANDARD_WF.Clear_Msg_Context;

3879: OE_DEBUG_PUB.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf raised exc error. ' ||
3880: to_char(l_stmt_num) );
3881: END IF;
3882: OE_STANDARD_WF.Save_Messages;
3883: OE_STANDARD_WF.Clear_Msg_Context;
3884: x_result := 'COMPLETE:INCOMPLETE';
3885: rollback to savepoint before_process;
3886: return;
3887:

Line 3896: OE_STANDARD_WF.Save_Messages;

3892: IF PG_DEBUG <> 0 THEN
3893: OE_DEBUG_PUB.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf raised unexc error. ' ||
3894: to_char(l_stmt_num) );
3895: END IF;
3896: OE_STANDARD_WF.Save_Messages;
3897: OE_STANDARD_WF.Clear_Msg_Context;
3898: wf_core.context('CTO_WORKFLOW', 'set_parameter_work_order_wf',
3899: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
3900: raise;

Line 3897: OE_STANDARD_WF.Clear_Msg_Context;

3893: OE_DEBUG_PUB.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf raised unexc error. ' ||
3894: to_char(l_stmt_num) );
3895: END IF;
3896: OE_STANDARD_WF.Save_Messages;
3897: OE_STANDARD_WF.Clear_Msg_Context;
3898: wf_core.context('CTO_WORKFLOW', 'set_parameter_work_order_wf',
3899: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
3900: raise;
3901:

Line 3941: OE_STANDARD_WF.Save_Messages;

3937: END IF;
3938:
3939: --end bugfix 2318060
3940:
3941: OE_STANDARD_WF.Save_Messages;
3942: OE_STANDARD_WF.Clear_Msg_Context;
3943:
3944: -- Begin bugfix 2053360:
3945: -- Set the result to INCOMPLETE so that the wf returns to Create Supply Order Eligible

Line 3942: OE_STANDARD_WF.Clear_Msg_Context;

3938:
3939: --end bugfix 2318060
3940:
3941: OE_STANDARD_WF.Save_Messages;
3942: OE_STANDARD_WF.Clear_Msg_Context;
3943:
3944: -- Begin bugfix 2053360:
3945: -- Set the result to INCOMPLETE so that the wf returns to Create Supply Order Eligible
3946: x_result := 'COMPLETE:INCOMPLETE';

Line 3994: OE_STANDARD_WF.Set_Msg_Context(p_actid);

3990: l_cnt number; --bug 9679523
3991:
3992: BEGIN
3993:
3994: OE_STANDARD_WF.Set_Msg_Context(p_actid);
3995: IF PG_DEBUG <> 0 THEN
3996: oe_debug_pub.add('submit_conc_prog_wf: ' || 'CTO Activity: submit_conc_prog_wf.',1);
3997: oe_debug_pub.add('submit_conc_prog_wf: ' || 'p_item_type: ' || p_itemtype, 1);
3998: oe_debug_pub.add('submit_conc_prog_wf: ' || 'p_itemkey: ' || p_itemkey, 1);

Line 4054: fnd_wf_standard.ExecuteConcProgram(p_itemtype,

4050:
4051: if (p_funcmode = 'RUN') then
4052:
4053: l_stmt_num := 100;
4054: fnd_wf_standard.ExecuteConcProgram(p_itemtype,
4055: p_itemkey,
4056: p_actid,
4057: p_funcmode,
4058: x_result);

Line 4083: OE_STANDARD_WF.Save_Messages;

4079: --fnd_message.set_token('REQUEST_ID', l_req_id);
4080:
4081: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
4082:
4083: OE_STANDARD_WF.Save_Messages;
4084: OE_STANDARD_WF.Clear_Msg_Context;
4085:
4086: end if;
4087:

Line 4084: OE_STANDARD_WF.Clear_Msg_Context;

4080:
4081: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
4082:
4083: OE_STANDARD_WF.Save_Messages;
4084: OE_STANDARD_WF.Clear_Msg_Context;
4085:
4086: end if;
4087:
4088: EXCEPTION

Line 4145: OE_STANDARD_WF.Set_Msg_Context(p_actid);

4141: l_conc_msg number := 0;
4142:
4143: BEGIN
4144:
4145: OE_STANDARD_WF.Set_Msg_Context(p_actid);
4146: IF PG_DEBUG <> 0 THEN
4147: oe_debug_pub.add('submit_and_continue_wf: ' || 'CTO Activity: submit_conc_prog_wf.',1);
4148: END IF;
4149:

Line 4190: fnd_wf_standard.SubmitConcProgram(p_itemtype,

4186: END IF;
4187: END IF;
4188:
4189: l_stmt_num := 100;
4190: fnd_wf_standard.SubmitConcProgram(p_itemtype,
4191: p_itemkey,
4192: p_actid,
4193: p_funcmode,
4194: x_result);

Line 4223: OE_STANDARD_WF.Save_Messages;

4219: --fnd_message.set_token('REQUEST_ID', l_req_id);
4220:
4221: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
4222:
4223: OE_STANDARD_WF.Save_Messages;
4224: OE_STANDARD_WF.Clear_Msg_Context;
4225:
4226: end if;
4227:

Line 4224: OE_STANDARD_WF.Clear_Msg_Context;

4220:
4221: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
4222:
4223: OE_STANDARD_WF.Save_Messages;
4224: OE_STANDARD_WF.Clear_Msg_Context;
4225:
4226: end if;
4227:
4228: EXCEPTION

Line 4334: format is follows the standard Workflow API format.

4330: /*============================================================================
4331: Procedure: validate_config_line
4332: Description: This procedure gets called when executing the Match
4333: Configuration activity in the ATO workflow. The
4334: format is follows the standard Workflow API format.
4335:
4336: More to come...
4337: Parameters:
4338: =============================================================================*/

Line 4378: ( oel.item_type_code in ('STANDARD','OPTION','INCLUDED') AND --bugfix#2111718

4374: and oel.booked_flag = 'Y'
4375: and oel.schedule_status_code = 'SCHEDULED'
4376: and ( oel.item_type_code = 'CONFIG' OR
4377: --Adding INCLUDED item type code for SUN ER#9793792
4378: ( oel.item_type_code in ('STANDARD','OPTION','INCLUDED') AND --bugfix#2111718
4379: oel.ato_line_id = p_config_line_id ) );
4380:
4381: if (l_valid_config_line > 0 ) then
4382: return TRUE;

Line 4402: format is follows the standard Workflow API format.

4398: /*============================================================================
4399: Procedure: config_line_exists
4400: Description: This procedure gets called when executing the Match
4401: Configuration activity in the ATO workflow. The
4402: format is follows the standard Workflow API format.
4403:
4404: More to come...
4405:
4406: Parameters:

Line 4470: format is follows the standard Workflow API format.

4466: /*============================================================================
4467: Procedure: reservation_exists
4468: Description: This procedure gets called when executing the Match
4469: Configuration activity in the ATO workflow. The
4470: format is follows the standard Workflow API format.
4471:
4472: More to come...
4473:
4474: Parameters:

Line 4604: OE_STANDARD_WF.Set_Msg_Context(p_actid);

4600: l_ato_line_id Number;
4601: l_batch_no Number;
4602: BEGIN
4603:
4604: OE_STANDARD_WF.Set_Msg_Context(p_actid);
4605: IF PG_DEBUG <> 0 THEN
4606: oe_debug_pub.add('Purchase_price_calc_wf: ' || 'CTO Activity: Purchase Price Calc wf.',1);
4607: END IF;
4608:

Line 4644: OE_STANDARD_WF.Save_Messages;

4640: oe_debug_pub.add('Purchase_price_calc_wf: ' || ' Failed to call Create_purchasing_doc call...',1);
4641:
4642:
4643: end if;
4644: OE_STANDARD_WF.Save_Messages;
4645: OE_STANDARD_WF.Clear_Msg_Context;
4646:
4647: Exception when OTHERS then
4648: IF PG_DEBUG <> 0 THEN

Line 4645: OE_STANDARD_WF.Clear_Msg_Context;

4641:
4642:
4643: end if;
4644: OE_STANDARD_WF.Save_Messages;
4645: OE_STANDARD_WF.Clear_Msg_Context;
4646:
4647: Exception when OTHERS then
4648: IF PG_DEBUG <> 0 THEN
4649: oe_debug_pub.add('Purchase_price_calc_wf: ' || 'CTO_WORKFLOW.Purchase_Price_calc_wf: '

Line 4664: The format follows the standard Workflow API format.

4660:
4661: /*============================================================================
4662: Procedure: chk_rsv_after_afas_wf
4663: Description:
4664: The format follows the standard Workflow API format.
4665: 06/04/02 bugfix2327972
4666: | added a new function node which calls procedure
4667: | chk_rsv_after_afas_wf.
4668: | This nodes checks if any type of reservation

Line 4698: OE_STANDARD_WF.Set_Msg_Context(p_actid);

4694:
4695:
4696:
4697: BEGIN
4698: OE_STANDARD_WF.Set_Msg_Context(p_actid);
4699: IF PG_DEBUG <> 0 THEN
4700: oe_debug_pub.add('chk_rsv_after_afas_wf: ' || 'CTO Activity: Check Reservation after afas activity ', 1);
4701: END IF;
4702:

Line 4723: OE_STANDARD_WF.Save_Messages;

4719: END IF;
4720:
4721: END IF ; /*p_funcmode ='RUN"*/
4722:
4723: OE_STANDARD_WF.Save_Messages;
4724: OE_STANDARD_WF.Clear_Msg_Context;
4725:
4726: EXCEPTION
4727: when FND_API.G_EXC_ERROR then

Line 4724: OE_STANDARD_WF.Clear_Msg_Context;

4720:
4721: END IF ; /*p_funcmode ='RUN"*/
4722:
4723: OE_STANDARD_WF.Save_Messages;
4724: OE_STANDARD_WF.Clear_Msg_Context;
4725:
4726: EXCEPTION
4727: when FND_API.G_EXC_ERROR then
4728: IF PG_DEBUG <> 0 THEN

Line 4731: OE_STANDARD_WF.Save_Messages;

4727: when FND_API.G_EXC_ERROR then
4728: IF PG_DEBUG <> 0 THEN
4729: OE_DEBUG_PUB.add('chk_rsv_after_afas_wf: ' || 'CTO_WORKFLOW.chk_rsv_after_afas_wf' || to_char(l_stmt_num) );
4730: END IF;
4731: OE_STANDARD_WF.Save_Messages;
4732: OE_STANDARD_WF.Clear_Msg_Context;
4733: raise; -- can be re-tried
4734:
4735: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 4732: OE_STANDARD_WF.Clear_Msg_Context;

4728: IF PG_DEBUG <> 0 THEN
4729: OE_DEBUG_PUB.add('chk_rsv_after_afas_wf: ' || 'CTO_WORKFLOW.chk_rsv_after_afas_wf' || to_char(l_stmt_num) );
4730: END IF;
4731: OE_STANDARD_WF.Save_Messages;
4732: OE_STANDARD_WF.Clear_Msg_Context;
4733: raise; -- can be re-tried
4734:
4735: when FND_API.G_EXC_UNEXPECTED_ERROR then
4736: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

Line 4747: OE_STANDARD_WF.Save_Messages;

4743: IF PG_DEBUG <> 0 THEN
4744: oe_debug_pub.add('chk_rsv_after_afas_wf: ' || 'corresponds to unexpected error at called program chk_rsv_after_afas_wf '||'
4745: l_stmt_num :'|| l_stmt_num ||sqlerrm, 1);
4746: END IF;
4747: OE_STANDARD_WF.Save_Messages;
4748: OE_STANDARD_WF.Clear_Msg_Context;
4749: wf_core.context('CTO_WORKFLOW', 'chk_rsv_after_afas_wf', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
4750: raise;
4751:

Line 4748: OE_STANDARD_WF.Clear_Msg_Context;

4744: oe_debug_pub.add('chk_rsv_after_afas_wf: ' || 'corresponds to unexpected error at called program chk_rsv_after_afas_wf '||'
4745: l_stmt_num :'|| l_stmt_num ||sqlerrm, 1);
4746: END IF;
4747: OE_STANDARD_WF.Save_Messages;
4748: OE_STANDARD_WF.Clear_Msg_Context;
4749: wf_core.context('CTO_WORKFLOW', 'chk_rsv_after_afas_wf', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
4750: raise;
4751:
4752: when OTHERS then

Line 4807: OE_STANDARD_WF.Set_Msg_Context(p_actid);

4803: l_message varchar2(100);
4804:
4805: BEGIN
4806:
4807: OE_STANDARD_WF.Set_Msg_Context(p_actid);
4808: IF PG_DEBUG <> 0 THEN
4809: oe_debug_pub.add('check_supply_creation_wf: ' || 'CTO Activity: Check Supply Type', 1);
4810:
4811: oe_debug_pub.add('check_supply_creation_wf: ' || 'Item key = '||p_itemkey,1);

Line 4849: OE_STANDARD_WF.Save_Messages;

4845: IF PG_DEBUG <> 0 THEN
4846: oe_debug_pub.add('check_supply_creation_wf: ' || 'It is Config item Drop Ship case...',1);
4847: END IF;
4848: x_result := 'COMPLETE';
4849: OE_STANDARD_WF.Save_Messages;
4850: OE_STANDARD_WF.Clear_Msg_Context;
4851:
4852:
4853:

Line 4850: OE_STANDARD_WF.Clear_Msg_Context;

4846: oe_debug_pub.add('check_supply_creation_wf: ' || 'It is Config item Drop Ship case...',1);
4847: END IF;
4848: x_result := 'COMPLETE';
4849: OE_STANDARD_WF.Save_Messages;
4850: OE_STANDARD_WF.Clear_Msg_Context;
4851:
4852:
4853:
4854:

Line 4955: OE_STANDARD_WF.Save_Messages;

4951: end if;
4952:
4953: END IF;--run
4954:
4955: OE_STANDARD_WF.Save_Messages;
4956: OE_STANDARD_WF.Clear_Msg_Context;
4957:
4958: EXCEPTION
4959:

Line 4956: OE_STANDARD_WF.Clear_Msg_Context;

4952:
4953: END IF;--run
4954:
4955: OE_STANDARD_WF.Save_Messages;
4956: OE_STANDARD_WF.Clear_Msg_Context;
4957:
4958: EXCEPTION
4959:
4960: when FND_API.G_EXC_ERROR then

Line 4965: OE_STANDARD_WF.Save_Messages;

4961: IF PG_DEBUG <> 0 THEN
4962: OE_DEBUG_PUB.add('check_supply_creation_wf: ' || 'CTO_WORKFLOW.check_supply_creation_wf ' ||
4963: to_char(l_stmt_num));
4964: END IF;
4965: OE_STANDARD_WF.Save_Messages;
4966: OE_STANDARD_WF.Clear_Msg_Context;
4967: --x_result := 'COMPLETE:INCOMPLETE';
4968: wf_core.context('CTO_WORKFLOW', 'check_supply_creation_wf',
4969: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);

Line 4966: OE_STANDARD_WF.Clear_Msg_Context;

4962: OE_DEBUG_PUB.add('check_supply_creation_wf: ' || 'CTO_WORKFLOW.check_supply_creation_wf ' ||
4963: to_char(l_stmt_num));
4964: END IF;
4965: OE_STANDARD_WF.Save_Messages;
4966: OE_STANDARD_WF.Clear_Msg_Context;
4967: --x_result := 'COMPLETE:INCOMPLETE';
4968: wf_core.context('CTO_WORKFLOW', 'check_supply_creation_wf',
4969: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
4970: raise;

Line 4978: OE_STANDARD_WF.Save_Messages;

4974: IF PG_DEBUG <> 0 THEN
4975: OE_DEBUG_PUB.add('check_supply_creation_wf: ' || 'CTO_WORKFLOW.check_supply_creation_wf ' ||
4976: to_char(l_stmt_num));
4977: END IF;
4978: OE_STANDARD_WF.Save_Messages;
4979: OE_STANDARD_WF.Clear_Msg_Context;
4980: wf_core.context('CTO_WORKFLOW', 'check_supply_creation_wf',
4981: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
4982: raise;

Line 4979: OE_STANDARD_WF.Clear_Msg_Context;

4975: OE_DEBUG_PUB.add('check_supply_creation_wf: ' || 'CTO_WORKFLOW.check_supply_creation_wf ' ||
4976: to_char(l_stmt_num));
4977: END IF;
4978: OE_STANDARD_WF.Save_Messages;
4979: OE_STANDARD_WF.Clear_Msg_Context;
4980: wf_core.context('CTO_WORKFLOW', 'check_supply_creation_wf',
4981: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
4982: raise;
4983:

Line 4993: OE_STANDARD_WF.Save_Messages;

4989: END IF;
4990: wf_core.context('CTO_WORKFLOW', 'check_supply_creation_wf',
4991: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
4992:
4993: OE_STANDARD_WF.Save_Messages;
4994: OE_STANDARD_WF.Clear_Msg_Context;
4995:
4996: raise;
4997:

Line 4994: OE_STANDARD_WF.Clear_Msg_Context;

4990: wf_core.context('CTO_WORKFLOW', 'check_supply_creation_wf',
4991: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
4992:
4993: OE_STANDARD_WF.Save_Messages;
4994: OE_STANDARD_WF.Clear_Msg_Context;
4995:
4996: raise;
4997:
4998: