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 1392: OE_STANDARD_WF.Save_Messages;

1388: end if; /* end of p_funcmode = 'RUN' */
1389:
1390: CTO_CONFIG_BOM_PK.gApplyHold := 'N'; -- bugfix 2899529: Reset this global variable.
1391:
1392: OE_STANDARD_WF.Save_Messages;
1393: OE_STANDARD_WF.Clear_Msg_Context;
1394:
1395:
1396: EXCEPTION

Line 1393: OE_STANDARD_WF.Clear_Msg_Context;

1389:
1390: CTO_CONFIG_BOM_PK.gApplyHold := 'N'; -- bugfix 2899529: Reset this global variable.
1391:
1392: OE_STANDARD_WF.Save_Messages;
1393: OE_STANDARD_WF.Clear_Msg_Context;
1394:
1395:
1396: EXCEPTION
1397:

Line 1405: OE_STANDARD_WF.Save_Messages;

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

Line 1406: OE_STANDARD_WF.Clear_Msg_Context;

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

Line 1416: OE_STANDARD_WF.Save_Messages;

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

Line 1417: OE_STANDARD_WF.Clear_Msg_Context;

1413: to_char(l_stmt_num) || ':' ||
1414: l_x_error_msg);
1415: END IF;
1416: OE_STANDARD_WF.Save_Messages;
1417: OE_STANDARD_WF.Clear_Msg_Context;
1418: wf_core.context('CTO_WORKFLOW', 'create_config_item_wf',
1419: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
1420: raise;
1421:

Line 1432: OE_STANDARD_WF.Save_Messages;

1428: END IF;
1429: wf_core.context('CTO_WORKFLOW', 'create_config_item_wf',
1430: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
1431:
1432: OE_STANDARD_WF.Save_Messages;
1433: OE_STANDARD_WF.Clear_Msg_Context;
1434:
1435: raise;
1436:

Line 1433: OE_STANDARD_WF.Clear_Msg_Context;

1429: wf_core.context('CTO_WORKFLOW', 'create_config_item_wf',
1430: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
1431:
1432: OE_STANDARD_WF.Save_Messages;
1433: OE_STANDARD_WF.Clear_Msg_Context;
1434:
1435: raise;
1436:
1437: END create_config_item_wf;

Line 1796: OE_STANDARD_WF.Save_Messages;

1792:
1793: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
1794:
1795:
1796: OE_STANDARD_WF.Save_Messages;
1797: OE_STANDARD_WF.Clear_Msg_Context;
1798:
1799: end if ;
1800:

Line 1797: OE_STANDARD_WF.Clear_Msg_Context;

1793: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
1794:
1795:
1796: OE_STANDARD_WF.Save_Messages;
1797: OE_STANDARD_WF.Clear_Msg_Context;
1798:
1799: end if ;
1800:
1801:

Line 1903: OE_STANDARD_WF.Save_Messages;

1899: --fnd_message.set_token('SHIP_ORG', l_organization_name );
1900:
1901: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
1902:
1903: OE_STANDARD_WF.Save_Messages;
1904: OE_STANDARD_WF.Clear_Msg_Context;
1905:
1906: end if;
1907:

Line 1904: OE_STANDARD_WF.Clear_Msg_Context;

1900:
1901: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
1902:
1903: OE_STANDARD_WF.Save_Messages;
1904: OE_STANDARD_WF.Clear_Msg_Context;
1905:
1906: end if;
1907:
1908: x_reserve_status := 'NOQTY' ;

Line 1948: OE_STANDARD_WF.Save_Messages;

1944: --fnd_message.set_token('CONFIG_ITEM', l_config_item_name );
1945:
1946: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
1947:
1948: OE_STANDARD_WF.Save_Messages;
1949: OE_STANDARD_WF.Clear_Msg_Context;
1950:
1951: end if ;
1952:

Line 1949: OE_STANDARD_WF.Clear_Msg_Context;

1945:
1946: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
1947:
1948: OE_STANDARD_WF.Save_Messages;
1949: OE_STANDARD_WF.Clear_Msg_Context;
1950:
1951: end if ;
1952:
1953: x_reserve_status := 'MATCH' ;

Line 1971: OE_STANDARD_WF.Save_Messages;

1967: OE_DEBUG_PUB.add('create_reservation: ' || 'RESERVATION_ERROR ' , 1 );
1968:
1969: OE_DEBUG_PUB.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation ' || to_char(l_stmt_num) );
1970: END IF;
1971: OE_STANDARD_WF.Save_Messages;
1972: OE_STANDARD_WF.Clear_Msg_Context;
1973:
1974: x_return_status := FND_API.G_RET_STS_ERROR ;
1975:

Line 1972: OE_STANDARD_WF.Clear_Msg_Context;

1968:
1969: OE_DEBUG_PUB.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation ' || to_char(l_stmt_num) );
1970: END IF;
1971: OE_STANDARD_WF.Save_Messages;
1972: OE_STANDARD_WF.Clear_Msg_Context;
1973:
1974: x_return_status := FND_API.G_RET_STS_ERROR ;
1975:
1976:

Line 1993: OE_STANDARD_WF.Save_Messages;

1989: IF PG_DEBUG <> 0 THEN
1990: OE_DEBUG_PUB.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation ' || to_char(l_stmt_num) );
1991: END IF;
1992:
1993: OE_STANDARD_WF.Save_Messages;
1994: OE_STANDARD_WF.Clear_Msg_Context;
1995:
1996: x_return_status := FND_API.G_RET_STS_ERROR ;
1997:

Line 1994: OE_STANDARD_WF.Clear_Msg_Context;

1990: OE_DEBUG_PUB.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation ' || to_char(l_stmt_num) );
1991: END IF;
1992:
1993: OE_STANDARD_WF.Save_Messages;
1994: OE_STANDARD_WF.Clear_Msg_Context;
1995:
1996: x_return_status := FND_API.G_RET_STS_ERROR ;
1997:
1998: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2005: OE_STANDARD_WF.Save_Messages;

2001: OE_DEBUG_PUB.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation ' ||
2002: to_char(l_stmt_num) || ':' ||
2003: l_x_error_msg);
2004: END IF;
2005: OE_STANDARD_WF.Save_Messages;
2006: OE_STANDARD_WF.Clear_Msg_Context;
2007:
2008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2009:

Line 2006: OE_STANDARD_WF.Clear_Msg_Context;

2002: to_char(l_stmt_num) || ':' ||
2003: l_x_error_msg);
2004: END IF;
2005: OE_STANDARD_WF.Save_Messages;
2006: OE_STANDARD_WF.Clear_Msg_Context;
2007:
2008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2009:
2010: when OTHERS then

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

2027: Procedure: rsv_before_booking_wf
2028: Description: This works only for an ATO item .
2029: This procedure gets called just before "Create supply order Eligble"
2030: activity in the ATO workflow.
2031: The format follows the standard Workflow API format.
2032:
2033: Parameters:
2034: =============================================================================*/
2035:

Line 2072: OE_STANDARD_WF.Set_Msg_Context(p_actid);

2068: l_x_error_msg Varchar2(2000);
2069:
2070: v_aps_version number ;
2071: BEGIN
2072: OE_STANDARD_WF.Set_Msg_Context(p_actid);
2073: IF PG_DEBUG <> 0 THEN
2074: oe_debug_pub.add('rsv_before_booking_wf: ' || 'CTO Activity: Check Reservation before booking activity ', 1);
2075: END IF;
2076:

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

2237:
2238:
2239: --if an ato item
2240:
2241: IF ((upper(v_item_type_code) = 'STANDARD') OR (upper(v_item_type_code) = 'OPTION')) --bug#1874380
2242: AND (v_ato_line_id = p_itemkey)
2243: THEN
2244:
2245: --end bug#1861812

Line 2324: OE_STANDARD_WF.Save_Messages;

2320: --end bug#1861812
2321:
2322: end if ; /*p_funcmode ='RUN"*/
2323:
2324: OE_STANDARD_WF.Save_Messages;
2325: OE_STANDARD_WF.Clear_Msg_Context;
2326:
2327: EXCEPTION
2328: when FND_API.G_EXC_ERROR then

Line 2325: OE_STANDARD_WF.Clear_Msg_Context;

2321:
2322: end if ; /*p_funcmode ='RUN"*/
2323:
2324: OE_STANDARD_WF.Save_Messages;
2325: OE_STANDARD_WF.Clear_Msg_Context;
2326:
2327: EXCEPTION
2328: when FND_API.G_EXC_ERROR then
2329: IF PG_DEBUG <> 0 THEN

Line 2332: OE_STANDARD_WF.Save_Messages;

2328: when FND_API.G_EXC_ERROR then
2329: IF PG_DEBUG <> 0 THEN
2330: OE_DEBUG_PUB.add('rsv_before_booking_wf: ' || 'CTO_WORKFLOW.rsv_before_booking_wf ' || to_char(l_stmt_num) );
2331: END IF;
2332: OE_STANDARD_WF.Save_Messages;
2333: OE_STANDARD_WF.Clear_Msg_Context;
2334: raise; -- can be re-tried
2335:
2336: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2333: OE_STANDARD_WF.Clear_Msg_Context;

2329: IF PG_DEBUG <> 0 THEN
2330: OE_DEBUG_PUB.add('rsv_before_booking_wf: ' || 'CTO_WORKFLOW.rsv_before_booking_wf ' || to_char(l_stmt_num) );
2331: END IF;
2332: OE_STANDARD_WF.Save_Messages;
2333: OE_STANDARD_WF.Clear_Msg_Context;
2334: raise; -- can be re-tried
2335:
2336: when FND_API.G_EXC_UNEXPECTED_ERROR then
2337: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

Line 2348: OE_STANDARD_WF.Save_Messages;

2344: IF PG_DEBUG <> 0 THEN
2345: oe_debug_pub.add('rsv_before_booking_wf: ' || 'corresponds to unexpected error at called program check_inv_rsv_exists '||'
2346: l_stmt_num :'|| l_stmt_num ||sqlerrm, 1);
2347: END IF;
2348: OE_STANDARD_WF.Save_Messages;
2349: OE_STANDARD_WF.Clear_Msg_Context;
2350: wf_core.context('CTO_WORKFLOW', 'rsv_before_booking_wf', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2351: raise;
2352:

Line 2349: OE_STANDARD_WF.Clear_Msg_Context;

2345: oe_debug_pub.add('rsv_before_booking_wf: ' || 'corresponds to unexpected error at called program check_inv_rsv_exists '||'
2346: l_stmt_num :'|| l_stmt_num ||sqlerrm, 1);
2347: END IF;
2348: OE_STANDARD_WF.Save_Messages;
2349: OE_STANDARD_WF.Clear_Msg_Context;
2350: wf_core.context('CTO_WORKFLOW', 'rsv_before_booking_wf', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2351: raise;
2352:
2353: when OTHERS then

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

2575: obsolete ?
2576: Procedure: check_reservation_status_wf
2577: Description: This procedure gets called when executing the
2578: Check Reservation activity in the ATO workflow. The
2579: format is follows the standard Workflow API format.
2580:
2581: More to come...
2582: Parameters:
2583: =============================================================================*/

Line 2607: OE_STANDARD_WF.Set_Msg_Context(p_actid);

2603:
2604: PROCESS_ERROR EXCEPTION;
2605: UNEXP_ERROR EXCEPTION;
2606: BEGIN
2607: OE_STANDARD_WF.Set_Msg_Context(p_actid);
2608: IF PG_DEBUG <> 0 THEN
2609: oe_debug_pub.add('check_reservation_status_wf: ' || 'CTO Activity: Check Reservation', 1);
2610: END IF;
2611:

Line 2686: OE_STANDARD_WF.Save_Messages;

2682: END IF;
2683:
2684: end if; /* p_funcmode = 'RUN' */
2685:
2686: OE_STANDARD_WF.Save_Messages;
2687: OE_STANDARD_WF.Clear_Msg_Context;
2688:
2689: EXCEPTION
2690: when NO_DATA_FOUND then

Line 2687: OE_STANDARD_WF.Clear_Msg_Context;

2683:
2684: end if; /* p_funcmode = 'RUN' */
2685:
2686: OE_STANDARD_WF.Save_Messages;
2687: OE_STANDARD_WF.Clear_Msg_Context;
2688:
2689: EXCEPTION
2690: when NO_DATA_FOUND then
2691: IF PG_DEBUG <> 0 THEN

Line 2694: OE_STANDARD_WF.Save_Messages;

2690: when NO_DATA_FOUND then
2691: IF PG_DEBUG <> 0 THEN
2692: oe_debug_pub.add('check_reservation_status_wf: ' || 'Configuration Line Not Reserved.', 1);
2693: END IF;
2694: OE_STANDARD_WF.Save_Messages;
2695: OE_STANDARD_WF.Clear_Msg_Context;
2696: x_result := 'COMPLETE';
2697:
2698: when PROCESS_ERROR then

Line 2695: OE_STANDARD_WF.Clear_Msg_Context;

2691: IF PG_DEBUG <> 0 THEN
2692: oe_debug_pub.add('check_reservation_status_wf: ' || 'Configuration Line Not Reserved.', 1);
2693: END IF;
2694: OE_STANDARD_WF.Save_Messages;
2695: OE_STANDARD_WF.Clear_Msg_Context;
2696: x_result := 'COMPLETE';
2697:
2698: when PROCESS_ERROR then
2699: IF PG_DEBUG <> 0 THEN

Line 2704: OE_STANDARD_WF.Save_Messages;

2700: OE_DEBUG_PUB.add('check_reservation_status_wf: ' || 'CTO_WORKFLOW.check_reservation_status_wf ' ||
2701: to_char(l_stmt_num) || ':' ||
2702: substrb(sqlerrm, 1, 100));
2703: END IF;
2704: OE_STANDARD_WF.Save_Messages;
2705: OE_STANDARD_WF.Clear_Msg_Context;
2706:
2707: when UNEXP_ERROR then
2708: IF PG_DEBUG <> 0 THEN

Line 2705: OE_STANDARD_WF.Clear_Msg_Context;

2701: to_char(l_stmt_num) || ':' ||
2702: substrb(sqlerrm, 1, 100));
2703: END IF;
2704: OE_STANDARD_WF.Save_Messages;
2705: OE_STANDARD_WF.Clear_Msg_Context;
2706:
2707: when UNEXP_ERROR then
2708: IF PG_DEBUG <> 0 THEN
2709: OE_DEBUG_PUB.add('check_reservation_status_wf: ' || 'CTO_WORKFLOW.create_config_item_wf ' ||

Line 2713: OE_STANDARD_WF.Save_Messages;

2709: OE_DEBUG_PUB.add('check_reservation_status_wf: ' || 'CTO_WORKFLOW.create_config_item_wf ' ||
2710: to_char(l_stmt_num) || ':' ||
2711: l_return_status);
2712: END IF;
2713: OE_STANDARD_WF.Save_Messages;
2714: OE_STANDARD_WF.Clear_Msg_Context;
2715: wf_core.context('CTO_WORKFLOW', 'create_config_item_wf',
2716: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2717: raise;

Line 2714: OE_STANDARD_WF.Clear_Msg_Context;

2710: to_char(l_stmt_num) || ':' ||
2711: l_return_status);
2712: END IF;
2713: OE_STANDARD_WF.Save_Messages;
2714: OE_STANDARD_WF.Clear_Msg_Context;
2715: wf_core.context('CTO_WORKFLOW', 'create_config_item_wf',
2716: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2717: raise;
2718:

Line 2758: OE_STANDARD_WF.Set_Msg_Context(p_actid);

2754: l_status integer;
2755: UNEXP_ERROR exception;
2756:
2757: BEGIN
2758: OE_STANDARD_WF.Set_Msg_Context(p_actid);
2759: IF PG_DEBUG <> 0 THEN
2760: oe_debug_pub.add('calculate_cost_rollup_wf_ml: ' || 'CTO Activity: Calculate Cost Rollup', 1);
2761: END IF;
2762:

Line 2798: OE_STANDARD_WF.Save_Messages;

2794: x_result := 'COMPLETE';
2795:
2796: end if; /* end p_funcmode = 'RUN' */
2797:
2798: OE_STANDARD_WF.Save_Messages;
2799: OE_STANDARD_WF.Clear_Msg_Context;
2800:
2801: EXCEPTION
2802: when UNEXP_ERROR then

Line 2799: OE_STANDARD_WF.Clear_Msg_Context;

2795:
2796: end if; /* end p_funcmode = 'RUN' */
2797:
2798: OE_STANDARD_WF.Save_Messages;
2799: OE_STANDARD_WF.Clear_Msg_Context;
2800:
2801: EXCEPTION
2802: when UNEXP_ERROR then
2803: IF PG_DEBUG <> 0 THEN

Line 2808: OE_STANDARD_WF.Save_Messages;

2804: OE_DEBUG_PUB.add('calculate_cost_rollup_wf_ml: ' || 'CTO_WORKFLOW.calculate_cost_rollup_wf' ||
2805: to_char(l_stmt_num) || ':' ||
2806: l_x_msg_data);
2807: END IF;
2808: OE_STANDARD_WF.Save_Messages;
2809: OE_STANDARD_WF.Clear_Msg_Context;
2810: wf_core.context('CTO_WORKFLOW', 'calculate_cost_rollup_wf',
2811: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2812: raise;

Line 2809: OE_STANDARD_WF.Clear_Msg_Context;

2805: to_char(l_stmt_num) || ':' ||
2806: l_x_msg_data);
2807: END IF;
2808: OE_STANDARD_WF.Save_Messages;
2809: OE_STANDARD_WF.Clear_Msg_Context;
2810: wf_core.context('CTO_WORKFLOW', 'calculate_cost_rollup_wf',
2811: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2812: raise;
2813:

Line 2821: OE_STANDARD_WF.Save_Messages;

2817: to_char(l_stmt_num) || ':' ||
2818: substrb(sqlerrm, 1, 100),1);
2819: END IF;
2820: cto_msg_pub.cto_message('BOM', 'CTO_CALC_COST_ROLLUP_ERROR');
2821: OE_STANDARD_WF.Save_Messages;
2822: OE_STANDARD_WF.Clear_Msg_Context;
2823:
2824: when OTHERS then
2825: cto_msg_pub.cto_message('BOM', 'CTO_CALC_COST_ROLLUP_ERROR');

Line 2822: OE_STANDARD_WF.Clear_Msg_Context;

2818: substrb(sqlerrm, 1, 100),1);
2819: END IF;
2820: cto_msg_pub.cto_message('BOM', 'CTO_CALC_COST_ROLLUP_ERROR');
2821: OE_STANDARD_WF.Save_Messages;
2822: OE_STANDARD_WF.Clear_Msg_Context;
2823:
2824: when OTHERS then
2825: cto_msg_pub.cto_message('BOM', 'CTO_CALC_COST_ROLLUP_ERROR');
2826: IF PG_DEBUG <> 0 THEN

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

2841: /*============================================================================
2842: Procedure: set_parameter_lead_time_wf_ml
2843: Description: This procedure gets called when executing the Calculate
2844: Leadtime activity in the ATO workflow. The
2845: format is follows the standard Workflow API format.
2846:
2847: More to come...
2848: Parameters:
2849: =============================================================================*/

Line 2884: OE_STANDARD_WF.Set_Msg_Context(p_actid);

2880: UNEXP_ERROR exception;
2881:
2882: BEGIN
2883:
2884: OE_STANDARD_WF.Set_Msg_Context(p_actid);
2885: IF PG_DEBUG <> 0 THEN
2886: oe_debug_pub.add('set_parameter_lead_time_wf_ml: ' || 'CTO Activity: Set Parameter lead Time', 1);
2887: END IF;
2888:

Line 2923: OE_STANDARD_WF.Save_Messages;

2919:
2920: x_result := 'COMPLETE';
2921: end if; /* p_funcmode = 'RUN' */
2922:
2923: OE_STANDARD_WF.Save_Messages;
2924: OE_STANDARD_WF.Clear_Msg_Context;
2925:
2926: EXCEPTION
2927:

Line 2924: OE_STANDARD_WF.Clear_Msg_Context;

2920: x_result := 'COMPLETE';
2921: end if; /* p_funcmode = 'RUN' */
2922:
2923: OE_STANDARD_WF.Save_Messages;
2924: OE_STANDARD_WF.Clear_Msg_Context;
2925:
2926: EXCEPTION
2927:
2928: when UNEXP_ERROR then

Line 2934: OE_STANDARD_WF.Save_Messages;

2930: OE_DEBUG_PUB.add('set_parameter_lead_time_wf_ml: ' || 'CTO_WORKFLOW.set_parameter_lead_time_wf_ml' ||
2931: to_char(l_stmt_num) || ':' ||
2932: l_x_error_msg);
2933: END IF;
2934: OE_STANDARD_WF.Save_Messages;
2935: OE_STANDARD_WF.Clear_Msg_Context;
2936: wf_core.context('CTO_WORKFLOW', 'set_parameter_lead_time_wf_ml',
2937: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2938: raise;

Line 2935: OE_STANDARD_WF.Clear_Msg_Context;

2931: to_char(l_stmt_num) || ':' ||
2932: l_x_error_msg);
2933: END IF;
2934: OE_STANDARD_WF.Save_Messages;
2935: OE_STANDARD_WF.Clear_Msg_Context;
2936: wf_core.context('CTO_WORKFLOW', 'set_parameter_lead_time_wf_ml',
2937: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2938: raise;
2939:

Line 2947: OE_STANDARD_WF.Save_Messages;

2943: || to_char(l_stmt_num) || ':' ||
2944: substrb(sqlerrm, 1, 100),1);
2945: END IF;
2946: cto_msg_pub.cto_message('BOM', 'CTO_CALC_LEAD_TIME_ERROR');
2947: OE_STANDARD_WF.Save_Messages;
2948: OE_STANDARD_WF.Clear_Msg_Context;
2949:
2950: when OTHERS then
2951: cto_msg_pub.cto_message('BOM', 'CTO_CALC_LEAD_TIME_ERROR');

Line 2948: OE_STANDARD_WF.Clear_Msg_Context;

2944: substrb(sqlerrm, 1, 100),1);
2945: END IF;
2946: cto_msg_pub.cto_message('BOM', 'CTO_CALC_LEAD_TIME_ERROR');
2947: OE_STANDARD_WF.Save_Messages;
2948: OE_STANDARD_WF.Clear_Msg_Context;
2949:
2950: when OTHERS then
2951: cto_msg_pub.cto_message('BOM', 'CTO_CALC_LEAD_TIME_ERROR');
2952: IF PG_DEBUG <> 0 THEN

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

2965: /*============================================================================
2966: Procedure: check_supply_type_wf
2967: Description: This procedure gets called when executing the Reserve
2968: Configuration activity in the ATO workflow. The
2969: format is follows the standard Workflow API format.
2970:
2971: More to come...
2972: Parameters:
2973: =============================================================================*/

Line 3020: OE_STANDARD_WF.Set_Msg_Context(p_actid);

3016: v_x_hold_result_out VARCHAR2(1);
3017: v_x_hold_return_status VARCHAR2(1);
3018: v_x_error_msg VARCHAR2(150);
3019: BEGIN
3020: OE_STANDARD_WF.Set_Msg_Context(p_actid);
3021: IF PG_DEBUG <> 0 THEN
3022: oe_debug_pub.add('check_supply_type_wf: ' || 'CTO Activity: Check Supply Type', 1);
3023:
3024: oe_debug_pub.add('check_supply_type_wf: ' || 'Item key = '||p_itemkey,1);

Line 3111: OE_STANDARD_WF.Save_Messages;

3107: IF PG_DEBUG <> 0 THEN
3108: oe_debug_pub.add('check_supply_type_wf: ' || 'It is Config item Drop Ship case...',1);
3109: END IF;
3110: x_result := 'COMPLETE:DROPSHIP';
3111: OE_STANDARD_WF.Save_Messages;
3112: OE_STANDARD_WF.Clear_Msg_Context;
3113: return;
3114:
3115:

Line 3112: OE_STANDARD_WF.Clear_Msg_Context;

3108: oe_debug_pub.add('check_supply_type_wf: ' || 'It is Config item Drop Ship case...',1);
3109: END IF;
3110: x_result := 'COMPLETE:DROPSHIP';
3111: OE_STANDARD_WF.Save_Messages;
3112: OE_STANDARD_WF.Clear_Msg_Context;
3113: return;
3114:
3115:
3116: END IF ;

Line 3206: OE_STANDARD_WF.Save_Messages;

3202: END IF;
3203:
3204: --end bugfix 4556596
3205:
3206: OE_STANDARD_WF.Save_Messages;
3207: OE_STANDARD_WF.Clear_Msg_Context;
3208: return;
3209: END IF;
3210:

Line 3207: OE_STANDARD_WF.Clear_Msg_Context;

3203:
3204: --end bugfix 4556596
3205:
3206: OE_STANDARD_WF.Save_Messages;
3207: OE_STANDARD_WF.Clear_Msg_Context;
3208: return;
3209: END IF;
3210:
3211:

Line 3228: OE_STANDARD_WF.Save_Messages;

3224: oe_debug_pub.add('check_supply_type_wf: ' || 'It is ATO internal transfer case...',1);
3225: end if;
3226: END IF;
3227: x_result := 'COMPLETE:BUY';
3228: OE_STANDARD_WF.Save_Messages;
3229: OE_STANDARD_WF.Clear_Msg_Context;
3230: return;
3231: END IF;
3232:

Line 3229: OE_STANDARD_WF.Clear_Msg_Context;

3225: end if;
3226: END IF;
3227: x_result := 'COMPLETE:BUY';
3228: OE_STANDARD_WF.Save_Messages;
3229: OE_STANDARD_WF.Clear_Msg_Context;
3230: return;
3231: END IF;
3232:
3233: l_stmt_num := 400;

Line 3268: OE_STANDARD_WF.Save_Messages;

3264: oe_debug_pub.add('check_supply_type_wf: ' || 'Success in Check Supply Type', 1);
3265: END IF;
3266:
3267: end if; /* end p_funcmode = 'RUN'*/
3268: OE_STANDARD_WF.Save_Messages;
3269: OE_STANDARD_WF.Clear_Msg_Context;
3270:
3271: EXCEPTION
3272:

Line 3269: OE_STANDARD_WF.Clear_Msg_Context;

3265: END IF;
3266:
3267: end if; /* end p_funcmode = 'RUN'*/
3268: OE_STANDARD_WF.Save_Messages;
3269: OE_STANDARD_WF.Clear_Msg_Context;
3270:
3271: EXCEPTION
3272:
3273: when FND_API.G_EXC_ERROR then

Line 3278: OE_STANDARD_WF.Save_Messages;

3274: IF PG_DEBUG <> 0 THEN
3275: OE_DEBUG_PUB.add('check_supply_type_wf: ' || 'CTO_WORKFLOW.check_supply_type_wf ' ||
3276: to_char(l_stmt_num));
3277: END IF;
3278: OE_STANDARD_WF.Save_Messages;
3279: OE_STANDARD_WF.Clear_Msg_Context;
3280: x_result := 'COMPLETE:INCOMPLETE';
3281:
3282:

Line 3279: OE_STANDARD_WF.Clear_Msg_Context;

3275: OE_DEBUG_PUB.add('check_supply_type_wf: ' || 'CTO_WORKFLOW.check_supply_type_wf ' ||
3276: to_char(l_stmt_num));
3277: END IF;
3278: OE_STANDARD_WF.Save_Messages;
3279: OE_STANDARD_WF.Clear_Msg_Context;
3280: x_result := 'COMPLETE:INCOMPLETE';
3281:
3282:
3283: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 3288: OE_STANDARD_WF.Save_Messages;

3284: IF PG_DEBUG <> 0 THEN
3285: OE_DEBUG_PUB.add('check_supply_type_wf: ' || 'CTO_WORKFLOW.check_supply_type_wf ' ||
3286: to_char(l_stmt_num));
3287: END IF;
3288: OE_STANDARD_WF.Save_Messages;
3289: OE_STANDARD_WF.Clear_Msg_Context;
3290: wf_core.context('CTO_WORKFLOW', 'check_supply_type_wf',
3291: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
3292: raise;

Line 3289: OE_STANDARD_WF.Clear_Msg_Context;

3285: OE_DEBUG_PUB.add('check_supply_type_wf: ' || 'CTO_WORKFLOW.check_supply_type_wf ' ||
3286: to_char(l_stmt_num));
3287: END IF;
3288: OE_STANDARD_WF.Save_Messages;
3289: OE_STANDARD_WF.Clear_Msg_Context;
3290: wf_core.context('CTO_WORKFLOW', 'check_supply_type_wf',
3291: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
3292: raise;
3293:

Line 3302: OE_STANDARD_WF.Save_Messages;

3298: END IF;
3299: wf_core.context('CTO_WORKFLOW', 'check_supply_type_wf',
3300: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
3301:
3302: OE_STANDARD_WF.Save_Messages;
3303: OE_STANDARD_WF.Clear_Msg_Context;
3304:
3305: raise;
3306:

Line 3303: OE_STANDARD_WF.Clear_Msg_Context;

3299: wf_core.context('CTO_WORKFLOW', 'check_supply_type_wf',
3300: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
3301:
3302: OE_STANDARD_WF.Save_Messages;
3303: OE_STANDARD_WF.Clear_Msg_Context;
3304:
3305: raise;
3306:
3307: END check_supply_type_wf;

Line 3349: OE_STANDARD_WF.Set_Msg_Context(p_actid);

3345:
3346: BEGIN
3347: SAVEPOINT before_process;
3348:
3349: OE_STANDARD_WF.Set_Msg_Context(p_actid);
3350: IF PG_DEBUG <> 0 THEN
3351: oe_debug_pub.add('create_flow_schedule_wf: ' || 'CTO Activity: Create Flow Schedule', 1);
3352: END IF;
3353:

Line 3474: OE_STANDARD_WF.Save_Messages;

3470: return;
3471: end if;
3472: end if; /* p_funcmode = 'RUN' */
3473:
3474: OE_STANDARD_WF.Save_Messages;
3475: OE_STANDARD_WF.Clear_Msg_Context;
3476:
3477: EXCEPTION
3478:

Line 3475: OE_STANDARD_WF.Clear_Msg_Context;

3471: end if;
3472: end if; /* p_funcmode = 'RUN' */
3473:
3474: OE_STANDARD_WF.Save_Messages;
3475: OE_STANDARD_WF.Clear_Msg_Context;
3476:
3477: EXCEPTION
3478:
3479: when FND_API.G_EXC_ERROR then

Line 3484: OE_STANDARD_WF.Save_Messages;

3480: IF PG_DEBUG <> 0 THEN
3481: OE_DEBUG_PUB.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf raised exp error in stmt ' ||
3482: to_char(l_stmt_num) || ':' || l_x_error_msg);
3483: END IF;
3484: OE_STANDARD_WF.Save_Messages;
3485: OE_STANDARD_WF.Clear_Msg_Context;
3486: x_result := 'COMPLETE:INCOMPLETE';
3487: rollback to savepoint before_process;
3488: return;

Line 3485: OE_STANDARD_WF.Clear_Msg_Context;

3481: OE_DEBUG_PUB.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf raised exp error in stmt ' ||
3482: to_char(l_stmt_num) || ':' || l_x_error_msg);
3483: END IF;
3484: OE_STANDARD_WF.Save_Messages;
3485: OE_STANDARD_WF.Clear_Msg_Context;
3486: x_result := 'COMPLETE:INCOMPLETE';
3487: rollback to savepoint before_process;
3488: return;
3489:

Line 3497: OE_STANDARD_WF.Save_Messages;

3493: || to_char(l_stmt_num) || ':' ||
3494: substrb(sqlerrm, 1, 100),1);
3495: END IF;
3496: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_FLOW_SCHED_ERROR');
3497: OE_STANDARD_WF.Save_Messages;
3498: OE_STANDARD_WF.Clear_Msg_Context;
3499: x_result := 'COMPLETE:INCOMPLETE';
3500: rollback to savepoint before_process;
3501: return;

Line 3498: OE_STANDARD_WF.Clear_Msg_Context;

3494: substrb(sqlerrm, 1, 100),1);
3495: END IF;
3496: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_FLOW_SCHED_ERROR');
3497: OE_STANDARD_WF.Save_Messages;
3498: OE_STANDARD_WF.Clear_Msg_Context;
3499: x_result := 'COMPLETE:INCOMPLETE';
3500: rollback to savepoint before_process;
3501: return;
3502:

Line 3508: OE_STANDARD_WF.Save_Messages;

3504: IF PG_DEBUG <> 0 THEN
3505: OE_DEBUG_PUB.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf raised unexp error in stmt ' ||
3506: to_char(l_stmt_num) || ':' || l_x_error_msg);
3507: END IF;
3508: OE_STANDARD_WF.Save_Messages;
3509: OE_STANDARD_WF.Clear_Msg_Context;
3510: raise;
3511:
3512: when OTHERS then

Line 3509: OE_STANDARD_WF.Clear_Msg_Context;

3505: OE_DEBUG_PUB.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf raised unexp error in stmt ' ||
3506: to_char(l_stmt_num) || ':' || l_x_error_msg);
3507: END IF;
3508: OE_STANDARD_WF.Save_Messages;
3509: OE_STANDARD_WF.Clear_Msg_Context;
3510: raise;
3511:
3512: when OTHERS then
3513: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_FLOW_SCHED_ERROR');

Line 3696: OE_STANDARD_WF.Set_Msg_Context(p_actid);

3692: oe_debug_pub.add('set_parameter_work_order_wf: ' || 'Function Mode: ' || p_funcmode, 1);
3693:
3694: oe_debug_pub.add('set_parameter_work_order_wf: ' || 'CTO Activity: Set Parameter Work Order', 1);
3695: END IF;
3696: OE_STANDARD_WF.Set_Msg_Context(p_actid);
3697:
3698: if (p_funcmode = 'RUN') then
3699:
3700: -- Note: bugfix 3136206: The Lock_Line_Id api should be called BEFORE the SELECT FOR UPDATE

Line 3819: OE_STANDARD_WF.Save_Messages;

3815:
3816: x_result := 'COMPLETE';
3817: end if; /* p_funcmode = 'RUN' */
3818:
3819: OE_STANDARD_WF.Save_Messages;
3820: OE_STANDARD_WF.Clear_Msg_Context;
3821:
3822: EXCEPTION
3823:

Line 3820: OE_STANDARD_WF.Clear_Msg_Context;

3816: x_result := 'COMPLETE';
3817: end if; /* p_funcmode = 'RUN' */
3818:
3819: OE_STANDARD_WF.Save_Messages;
3820: OE_STANDARD_WF.Clear_Msg_Context;
3821:
3822: EXCEPTION
3823:
3824: --

Line 3837: OE_STANDARD_WF.Save_Messages;

3833:
3834: OE_DEBUG_PUB.add ('set_parameter_work_order_wf: ' || 'This line is being processed by another process.');
3835: END IF;
3836:
3837: OE_STANDARD_WF.Save_Messages;
3838: OE_STANDARD_WF.Clear_Msg_Context;
3839: x_result := 'COMPLETE:INCOMPLETE';
3840: return;
3841:

Line 3838: OE_STANDARD_WF.Clear_Msg_Context;

3834: OE_DEBUG_PUB.add ('set_parameter_work_order_wf: ' || 'This line is being processed by another process.');
3835: END IF;
3836:
3837: OE_STANDARD_WF.Save_Messages;
3838: OE_STANDARD_WF.Clear_Msg_Context;
3839: x_result := 'COMPLETE:INCOMPLETE';
3840: return;
3841:
3842:

Line 3849: OE_STANDARD_WF.Save_Messages;

3845: IF PG_DEBUG <> 0 THEN
3846: OE_DEBUG_PUB.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf raised exc error. ' ||
3847: to_char(l_stmt_num) );
3848: END IF;
3849: OE_STANDARD_WF.Save_Messages;
3850: OE_STANDARD_WF.Clear_Msg_Context;
3851: x_result := 'COMPLETE:INCOMPLETE';
3852: rollback to savepoint before_process;
3853: return;

Line 3850: OE_STANDARD_WF.Clear_Msg_Context;

3846: OE_DEBUG_PUB.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf raised exc error. ' ||
3847: to_char(l_stmt_num) );
3848: END IF;
3849: OE_STANDARD_WF.Save_Messages;
3850: OE_STANDARD_WF.Clear_Msg_Context;
3851: x_result := 'COMPLETE:INCOMPLETE';
3852: rollback to savepoint before_process;
3853: return;
3854:

Line 3863: OE_STANDARD_WF.Save_Messages;

3859: IF PG_DEBUG <> 0 THEN
3860: OE_DEBUG_PUB.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf raised unexc error. ' ||
3861: to_char(l_stmt_num) );
3862: END IF;
3863: OE_STANDARD_WF.Save_Messages;
3864: OE_STANDARD_WF.Clear_Msg_Context;
3865: wf_core.context('CTO_WORKFLOW', 'set_parameter_work_order_wf',
3866: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
3867: raise;

Line 3864: OE_STANDARD_WF.Clear_Msg_Context;

3860: OE_DEBUG_PUB.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf raised unexc error. ' ||
3861: to_char(l_stmt_num) );
3862: END IF;
3863: OE_STANDARD_WF.Save_Messages;
3864: OE_STANDARD_WF.Clear_Msg_Context;
3865: wf_core.context('CTO_WORKFLOW', 'set_parameter_work_order_wf',
3866: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
3867: raise;
3868:

Line 3908: OE_STANDARD_WF.Save_Messages;

3904: END IF;
3905:
3906: --end bugfix 2318060
3907:
3908: OE_STANDARD_WF.Save_Messages;
3909: OE_STANDARD_WF.Clear_Msg_Context;
3910:
3911: -- Begin bugfix 2053360:
3912: -- Set the result to INCOMPLETE so that the wf returns to Create Supply Order Eligible

Line 3909: OE_STANDARD_WF.Clear_Msg_Context;

3905:
3906: --end bugfix 2318060
3907:
3908: OE_STANDARD_WF.Save_Messages;
3909: OE_STANDARD_WF.Clear_Msg_Context;
3910:
3911: -- Begin bugfix 2053360:
3912: -- Set the result to INCOMPLETE so that the wf returns to Create Supply Order Eligible
3913: x_result := 'COMPLETE:INCOMPLETE';

Line 3960: OE_STANDARD_WF.Set_Msg_Context(p_actid);

3956: l_token CTO_MSG_PUB.token_tbl;
3957:
3958: BEGIN
3959:
3960: OE_STANDARD_WF.Set_Msg_Context(p_actid);
3961: IF PG_DEBUG <> 0 THEN
3962: oe_debug_pub.add('submit_conc_prog_wf: ' || 'CTO Activity: submit_conc_prog_wf.',1);
3963: END IF;
3964:

Line 3968: fnd_wf_standard.ExecuteConcProgram(p_itemtype,

3964:
3965: if (p_funcmode = 'RUN') then
3966:
3967: l_stmt_num := 100;
3968: fnd_wf_standard.ExecuteConcProgram(p_itemtype,
3969: p_itemkey,
3970: p_actid,
3971: p_funcmode,
3972: x_result);

Line 3997: OE_STANDARD_WF.Save_Messages;

3993: --fnd_message.set_token('REQUEST_ID', l_req_id);
3994:
3995: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
3996:
3997: OE_STANDARD_WF.Save_Messages;
3998: OE_STANDARD_WF.Clear_Msg_Context;
3999:
4000: end if;
4001:

Line 3998: OE_STANDARD_WF.Clear_Msg_Context;

3994:
3995: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
3996:
3997: OE_STANDARD_WF.Save_Messages;
3998: OE_STANDARD_WF.Clear_Msg_Context;
3999:
4000: end if;
4001:
4002: EXCEPTION

Line 4059: OE_STANDARD_WF.Set_Msg_Context(p_actid);

4055: l_conc_msg number := 0;
4056:
4057: BEGIN
4058:
4059: OE_STANDARD_WF.Set_Msg_Context(p_actid);
4060: IF PG_DEBUG <> 0 THEN
4061: oe_debug_pub.add('submit_and_continue_wf: ' || 'CTO Activity: submit_conc_prog_wf.',1);
4062: END IF;
4063:

Line 4104: fnd_wf_standard.SubmitConcProgram(p_itemtype,

4100: END IF;
4101: END IF;
4102:
4103: l_stmt_num := 100;
4104: fnd_wf_standard.SubmitConcProgram(p_itemtype,
4105: p_itemkey,
4106: p_actid,
4107: p_funcmode,
4108: x_result);

Line 4137: OE_STANDARD_WF.Save_Messages;

4133: --fnd_message.set_token('REQUEST_ID', l_req_id);
4134:
4135: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
4136:
4137: OE_STANDARD_WF.Save_Messages;
4138: OE_STANDARD_WF.Clear_Msg_Context;
4139:
4140: end if;
4141:

Line 4138: OE_STANDARD_WF.Clear_Msg_Context;

4134:
4135: l_token := CTO_MSG_PUB.G_MISS_TOKEN_TBL; -- initialize
4136:
4137: OE_STANDARD_WF.Save_Messages;
4138: OE_STANDARD_WF.Clear_Msg_Context;
4139:
4140: end if;
4141:
4142: EXCEPTION

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

4238: /*============================================================================
4239: Procedure: validate_config_line
4240: Description: This procedure gets called when executing the Match
4241: Configuration activity in the ATO workflow. The
4242: format is follows the standard Workflow API format.
4243:
4244: More to come...
4245: Parameters:
4246: =============================================================================*/

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

4275: and oel.visible_demand_flag = 'Y'
4276: and oel.booked_flag = 'Y'
4277: and oel.schedule_status_code = 'SCHEDULED'
4278: and ( oel.item_type_code = 'CONFIG' OR
4279: ( oel.item_type_code in ('STANDARD','OPTION') AND --bugfix#2111718
4280: oel.ato_line_id = p_config_line_id ) );
4281:
4282: if (l_valid_config_line > 0 ) then
4283: return TRUE;

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

4299: /*============================================================================
4300: Procedure: config_line_exists
4301: Description: This procedure gets called when executing the Match
4302: Configuration activity in the ATO workflow. The
4303: format is follows the standard Workflow API format.
4304:
4305: More to come...
4306:
4307: Parameters:

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

4367: /*============================================================================
4368: Procedure: reservation_exists
4369: Description: This procedure gets called when executing the Match
4370: Configuration activity in the ATO workflow. The
4371: format is follows the standard Workflow API format.
4372:
4373: More to come...
4374:
4375: Parameters:

Line 4505: OE_STANDARD_WF.Set_Msg_Context(p_actid);

4501: l_ato_line_id Number;
4502: l_batch_no Number;
4503: BEGIN
4504:
4505: OE_STANDARD_WF.Set_Msg_Context(p_actid);
4506: IF PG_DEBUG <> 0 THEN
4507: oe_debug_pub.add('Purchase_price_calc_wf: ' || 'CTO Activity: Purchase Price Calc wf.',1);
4508: END IF;
4509:

Line 4545: OE_STANDARD_WF.Save_Messages;

4541: oe_debug_pub.add('Purchase_price_calc_wf: ' || ' Failed to call Create_purchasing_doc call...',1);
4542:
4543:
4544: end if;
4545: OE_STANDARD_WF.Save_Messages;
4546: OE_STANDARD_WF.Clear_Msg_Context;
4547:
4548: Exception when OTHERS then
4549: IF PG_DEBUG <> 0 THEN

Line 4546: OE_STANDARD_WF.Clear_Msg_Context;

4542:
4543:
4544: end if;
4545: OE_STANDARD_WF.Save_Messages;
4546: OE_STANDARD_WF.Clear_Msg_Context;
4547:
4548: Exception when OTHERS then
4549: IF PG_DEBUG <> 0 THEN
4550: oe_debug_pub.add('Purchase_price_calc_wf: ' || 'CTO_WORKFLOW.Purchase_Price_calc_wf: '

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

4561:
4562: /*============================================================================
4563: Procedure: chk_rsv_after_afas_wf
4564: Description:
4565: The format follows the standard Workflow API format.
4566: 06/04/02 bugfix2327972
4567: | added a new function node which calls procedure
4568: | chk_rsv_after_afas_wf.
4569: | This nodes checks if any type of reservation

Line 4599: OE_STANDARD_WF.Set_Msg_Context(p_actid);

4595:
4596:
4597:
4598: BEGIN
4599: OE_STANDARD_WF.Set_Msg_Context(p_actid);
4600: IF PG_DEBUG <> 0 THEN
4601: oe_debug_pub.add('chk_rsv_after_afas_wf: ' || 'CTO Activity: Check Reservation after afas activity ', 1);
4602: END IF;
4603:

Line 4624: OE_STANDARD_WF.Save_Messages;

4620: END IF;
4621:
4622: END IF ; /*p_funcmode ='RUN"*/
4623:
4624: OE_STANDARD_WF.Save_Messages;
4625: OE_STANDARD_WF.Clear_Msg_Context;
4626:
4627: EXCEPTION
4628: when FND_API.G_EXC_ERROR then

Line 4625: OE_STANDARD_WF.Clear_Msg_Context;

4621:
4622: END IF ; /*p_funcmode ='RUN"*/
4623:
4624: OE_STANDARD_WF.Save_Messages;
4625: OE_STANDARD_WF.Clear_Msg_Context;
4626:
4627: EXCEPTION
4628: when FND_API.G_EXC_ERROR then
4629: IF PG_DEBUG <> 0 THEN

Line 4632: OE_STANDARD_WF.Save_Messages;

4628: when FND_API.G_EXC_ERROR then
4629: IF PG_DEBUG <> 0 THEN
4630: OE_DEBUG_PUB.add('chk_rsv_after_afas_wf: ' || 'CTO_WORKFLOW.chk_rsv_after_afas_wf' || to_char(l_stmt_num) );
4631: END IF;
4632: OE_STANDARD_WF.Save_Messages;
4633: OE_STANDARD_WF.Clear_Msg_Context;
4634: raise; -- can be re-tried
4635:
4636: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 4633: OE_STANDARD_WF.Clear_Msg_Context;

4629: IF PG_DEBUG <> 0 THEN
4630: OE_DEBUG_PUB.add('chk_rsv_after_afas_wf: ' || 'CTO_WORKFLOW.chk_rsv_after_afas_wf' || to_char(l_stmt_num) );
4631: END IF;
4632: OE_STANDARD_WF.Save_Messages;
4633: OE_STANDARD_WF.Clear_Msg_Context;
4634: raise; -- can be re-tried
4635:
4636: when FND_API.G_EXC_UNEXPECTED_ERROR then
4637: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

Line 4648: OE_STANDARD_WF.Save_Messages;

4644: IF PG_DEBUG <> 0 THEN
4645: oe_debug_pub.add('chk_rsv_after_afas_wf: ' || 'corresponds to unexpected error at called program chk_rsv_after_afas_wf '||'
4646: l_stmt_num :'|| l_stmt_num ||sqlerrm, 1);
4647: END IF;
4648: OE_STANDARD_WF.Save_Messages;
4649: OE_STANDARD_WF.Clear_Msg_Context;
4650: wf_core.context('CTO_WORKFLOW', 'chk_rsv_after_afas_wf', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
4651: raise;
4652:

Line 4649: OE_STANDARD_WF.Clear_Msg_Context;

4645: oe_debug_pub.add('chk_rsv_after_afas_wf: ' || 'corresponds to unexpected error at called program chk_rsv_after_afas_wf '||'
4646: l_stmt_num :'|| l_stmt_num ||sqlerrm, 1);
4647: END IF;
4648: OE_STANDARD_WF.Save_Messages;
4649: OE_STANDARD_WF.Clear_Msg_Context;
4650: wf_core.context('CTO_WORKFLOW', 'chk_rsv_after_afas_wf', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
4651: raise;
4652:
4653: when OTHERS then

Line 4708: OE_STANDARD_WF.Set_Msg_Context(p_actid);

4704: l_message varchar2(100);
4705:
4706: BEGIN
4707:
4708: OE_STANDARD_WF.Set_Msg_Context(p_actid);
4709: IF PG_DEBUG <> 0 THEN
4710: oe_debug_pub.add('check_supply_creation_wf: ' || 'CTO Activity: Check Supply Type', 1);
4711:
4712: oe_debug_pub.add('check_supply_creation_wf: ' || 'Item key = '||p_itemkey,1);

Line 4750: OE_STANDARD_WF.Save_Messages;

4746: IF PG_DEBUG <> 0 THEN
4747: oe_debug_pub.add('check_supply_creation_wf: ' || 'It is Config item Drop Ship case...',1);
4748: END IF;
4749: x_result := 'COMPLETE';
4750: OE_STANDARD_WF.Save_Messages;
4751: OE_STANDARD_WF.Clear_Msg_Context;
4752:
4753:
4754:

Line 4751: OE_STANDARD_WF.Clear_Msg_Context;

4747: oe_debug_pub.add('check_supply_creation_wf: ' || 'It is Config item Drop Ship case...',1);
4748: END IF;
4749: x_result := 'COMPLETE';
4750: OE_STANDARD_WF.Save_Messages;
4751: OE_STANDARD_WF.Clear_Msg_Context;
4752:
4753:
4754:
4755:

Line 4856: OE_STANDARD_WF.Save_Messages;

4852: end if;
4853:
4854: END IF;--run
4855:
4856: OE_STANDARD_WF.Save_Messages;
4857: OE_STANDARD_WF.Clear_Msg_Context;
4858:
4859: EXCEPTION
4860:

Line 4857: OE_STANDARD_WF.Clear_Msg_Context;

4853:
4854: END IF;--run
4855:
4856: OE_STANDARD_WF.Save_Messages;
4857: OE_STANDARD_WF.Clear_Msg_Context;
4858:
4859: EXCEPTION
4860:
4861: when FND_API.G_EXC_ERROR then

Line 4866: OE_STANDARD_WF.Save_Messages;

4862: IF PG_DEBUG <> 0 THEN
4863: OE_DEBUG_PUB.add('check_supply_creation_wf: ' || 'CTO_WORKFLOW.check_supply_creation_wf ' ||
4864: to_char(l_stmt_num));
4865: END IF;
4866: OE_STANDARD_WF.Save_Messages;
4867: OE_STANDARD_WF.Clear_Msg_Context;
4868: --x_result := 'COMPLETE:INCOMPLETE';
4869: wf_core.context('CTO_WORKFLOW', 'check_supply_creation_wf',
4870: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);

Line 4867: OE_STANDARD_WF.Clear_Msg_Context;

4863: OE_DEBUG_PUB.add('check_supply_creation_wf: ' || 'CTO_WORKFLOW.check_supply_creation_wf ' ||
4864: to_char(l_stmt_num));
4865: END IF;
4866: OE_STANDARD_WF.Save_Messages;
4867: OE_STANDARD_WF.Clear_Msg_Context;
4868: --x_result := 'COMPLETE:INCOMPLETE';
4869: wf_core.context('CTO_WORKFLOW', 'check_supply_creation_wf',
4870: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
4871: raise;

Line 4879: OE_STANDARD_WF.Save_Messages;

4875: IF PG_DEBUG <> 0 THEN
4876: OE_DEBUG_PUB.add('check_supply_creation_wf: ' || 'CTO_WORKFLOW.check_supply_creation_wf ' ||
4877: to_char(l_stmt_num));
4878: END IF;
4879: OE_STANDARD_WF.Save_Messages;
4880: OE_STANDARD_WF.Clear_Msg_Context;
4881: wf_core.context('CTO_WORKFLOW', 'check_supply_creation_wf',
4882: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
4883: raise;

Line 4880: OE_STANDARD_WF.Clear_Msg_Context;

4876: OE_DEBUG_PUB.add('check_supply_creation_wf: ' || 'CTO_WORKFLOW.check_supply_creation_wf ' ||
4877: to_char(l_stmt_num));
4878: END IF;
4879: OE_STANDARD_WF.Save_Messages;
4880: OE_STANDARD_WF.Clear_Msg_Context;
4881: wf_core.context('CTO_WORKFLOW', 'check_supply_creation_wf',
4882: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
4883: raise;
4884:

Line 4894: OE_STANDARD_WF.Save_Messages;

4890: END IF;
4891: wf_core.context('CTO_WORKFLOW', 'check_supply_creation_wf',
4892: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
4893:
4894: OE_STANDARD_WF.Save_Messages;
4895: OE_STANDARD_WF.Clear_Msg_Context;
4896:
4897: raise;
4898:

Line 4895: OE_STANDARD_WF.Clear_Msg_Context;

4891: wf_core.context('CTO_WORKFLOW', 'check_supply_creation_wf',
4892: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
4893:
4894: OE_STANDARD_WF.Save_Messages;
4895: OE_STANDARD_WF.Clear_Msg_Context;
4896:
4897: raise;
4898:
4899: