eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_WORKFLOW dependencies on CTO_WORKFLOW

Line 1: package body CTO_WORKFLOW as

1: package body CTO_WORKFLOW as
2: /* $Header: CTOWKFLB.pls 120.13.12010000.2 2008/08/26 19:15:17 ntungare ship $ */
3:
4: /*============================================================================+
5: | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |

Line 124: | and corrected use of cto_workflow_api_pk.display_wf_status

120: |
121: |
122: | 01/19/04 Sushant Sawant
123: | Fixed Bug 3380730, 3380874 to provide proper status code on config line
124: | and corrected use of cto_workflow_api_pk.display_wf_status
125: |
126: |
127: | 01/23/04 Sushant Sawant
128: | Fixed Bug 3388135 to provide message for match in case of dropship models.

Line 192: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CTO_WORKFLOW';

188: |
189: |
190: |
191: =============================================================================*/
192: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CTO_WORKFLOW';
193:
194:
195: /*
196: procedure send_oid_notification ;

Line 895: CTO_WORKFLOW_API_PK.query_wf_activity_status(

891:
892:
893: l_stmt_num := 155;
894:
895: CTO_WORKFLOW_API_PK.query_wf_activity_status(
896: p_itemtype => 'OEOL' ,
897: p_itemkey => to_char(l_config_line_id ) ,
898: p_activity_label => 'CREATE_CONFIG_BOM_ELIGIBLE',
899: p_activity_name => 'CREATE_CONFIG_BOM_ELIGIBLE',

Line 1261: CTO_WORKFLOW_API_PK.get_activity_status(

1257: oe_debug_pub.add('create_config_item_wf: ' || 'going to get Workflow Status for config line : ' ||
1258: to_char( l_config_line_id ) , 1 );
1259: END IF;
1260:
1261: CTO_WORKFLOW_API_PK.get_activity_status(
1262: itemtype => 'OEOL',
1263: itemkey => to_char(l_config_line_id),
1264: linetype => 'CONFIG',
1265: activity_name => l_active_activity);

Line 1275: CTO_WORKFLOW_API_PK.query_wf_activity_status(

1271:
1272:
1273: l_stmt_num := 178;
1274:
1275: CTO_WORKFLOW_API_PK.query_wf_activity_status(
1276: p_itemtype => 'OEOL' ,
1277: p_itemkey => to_char(l_config_line_id ) ,
1278: p_activity_label => 'SHIP_LINE',
1279: p_activity_name => 'SHIP_LINE',

Line 1400: OE_DEBUG_PUB.add('create_config_item_wf: ' || 'CTO_WORKFLOW.create_config_item_wf ' ||

1396: EXCEPTION
1397:
1398: when FND_API.G_EXC_ERROR then
1399: IF PG_DEBUG <> 0 THEN
1400: OE_DEBUG_PUB.add('create_config_item_wf: ' || 'CTO_WORKFLOW.create_config_item_wf ' ||
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);

Line 1412: OE_DEBUG_PUB.add('create_config_item_wf: ' || 'CTO_WORKFLOW.create_config_item_wf ' ||

1408: rollback to savepoint before_item_creation;
1409:
1410: when FND_API.G_EXC_UNEXPECTED_ERROR then
1411: IF PG_DEBUG <> 0 THEN
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;

Line 1418: wf_core.context('CTO_WORKFLOW', 'create_config_item_wf',

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:
1422: when OTHERS then

Line 1425: oe_debug_pub.add('create_config_item_wf: ' || 'CTO_WORKFLOW.create_config_item_wf' ||

1421:
1422: when OTHERS then
1423: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_ITEM_ERROR');
1424: IF PG_DEBUG <> 0 THEN
1425: oe_debug_pub.add('create_config_item_wf: ' || 'CTO_WORKFLOW.create_config_item_wf' ||
1426: to_char(l_stmt_num) || ':' ||
1427: substrb(sqlerrm, 1, 100));
1428: END IF;
1429: wf_core.context('CTO_WORKFLOW', 'create_config_item_wf',

Line 1429: wf_core.context('CTO_WORKFLOW', 'create_config_item_wf',

1425: oe_debug_pub.add('create_config_item_wf: ' || 'CTO_WORKFLOW.create_config_item_wf' ||
1426: to_char(l_stmt_num) || ':' ||
1427: substrb(sqlerrm, 1, 100));
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;

Line 1969: OE_DEBUG_PUB.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation ' || to_char(l_stmt_num) );

1965: --rollback to savepoint before_item_creation;
1966: IF PG_DEBUG <> 0 THEN
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:

Line 1981: oe_debug_pub.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation::ndf::' || to_char(l_stmt_num) );

1977: when NO_DATA_FOUND then
1978: --rollback to savepoint before_item_creation;
1979: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_ITEM_ERROR');
1980: IF PG_DEBUG <> 0 THEN
1981: oe_debug_pub.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation::ndf::' || to_char(l_stmt_num) );
1982: END IF;
1983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1984:
1985:

Line 1990: OE_DEBUG_PUB.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation ' || to_char(l_stmt_num) );

1986: when PROCESS_ERROR then
1987: --rollback to savepoint before_item_creation;
1988:
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;

Line 2001: OE_DEBUG_PUB.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation ' ||

1997:
1998: when FND_API.G_EXC_UNEXPECTED_ERROR then
1999: --rollback to savepoint before_item_creation;
2000: IF PG_DEBUG <> 0 THEN
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;

Line 2014: oe_debug_pub.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation' ||

2010: when OTHERS then
2011: --rollback to savepoint before_item_creation;
2012: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_ITEM_ERROR');
2013: IF PG_DEBUG <> 0 THEN
2014: oe_debug_pub.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation' ||
2015: to_char(l_stmt_num) || ':' ||
2016: substrb(sqlerrm, 1, 100));
2017: END IF;
2018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2286: return_value:= CTO_WORKFLOW_API_PK.display_wf_status(to_number(p_itemkey));

2282: --below code calls display_wf_status to update the correct
2283: --before booking and scheduling if item is reserved
2284: --
2285: l_stmt_num := 100;
2286: return_value:= CTO_WORKFLOW_API_PK.display_wf_status(to_number(p_itemkey));
2287:
2288: if return_value <> 1 then
2289: cto_msg_pub.cto_message('CTO', 'CTO_ERROR_FROM_DISPLAY_STATUS');
2290: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2330: OE_DEBUG_PUB.add('rsv_before_booking_wf: ' || 'CTO_WORKFLOW.rsv_before_booking_wf ' || to_char(l_stmt_num) );

2326:
2327: EXCEPTION
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

Line 2350: wf_core.context('CTO_WORKFLOW', 'rsv_before_booking_wf', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);

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
2354: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

Line 2366: wf_core.context('CTO_WORKFLOW','rsv_before_booking_wf',p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);

2362: END IF;
2363: /*-------------------------------------------+
2364: Error Information for Notification.
2365: +--------------------------------------------*/
2366: wf_core.context('CTO_WORKFLOW','rsv_before_booking_wf',p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2367: raise;
2368:
2369: END rsv_before_booking_wf;
2370:

Line 2448: ( 'CTO_WORKFLOW',

2444: if fnd_msg_pub.check_msg_level
2445: (fnd_msg_pub.g_msg_lvl_unexp_error)
2446: then
2447: fnd_msg_pub.Add_Exc_msg
2448: ( 'CTO_WORKFLOW',
2449: 'check_inv_rsv_exists'
2450: );
2451: end if;
2452: cto_msg_pub.count_and_get

Line 2561: ( 'CTO_WORKFLOW',

2557: if fnd_msg_pub.check_msg_level
2558: (fnd_msg_pub.g_msg_lvl_unexp_error)
2559: then
2560: fnd_msg_pub.Add_Exc_msg
2561: ( 'CTO_WORKFLOW',
2562: 'check_inv_rsv_exists'
2563: );
2564: end if;
2565: cto_msg_pub.count_and_get

Line 2700: OE_DEBUG_PUB.add('check_reservation_status_wf: ' || 'CTO_WORKFLOW.check_reservation_status_wf ' ||

2696: x_result := 'COMPLETE';
2697:
2698: when PROCESS_ERROR then
2699: IF PG_DEBUG <> 0 THEN
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;

Line 2709: OE_DEBUG_PUB.add('check_reservation_status_wf: ' || 'CTO_WORKFLOW.create_config_item_wf ' ||

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 ' ||
2710: to_char(l_stmt_num) || ':' ||
2711: l_return_status);
2712: END IF;
2713: OE_STANDARD_WF.Save_Messages;

Line 2715: wf_core.context('CTO_WORKFLOW', 'create_config_item_wf',

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:
2719: when OTHERS then

Line 2722: oe_debug_pub.add('check_reservation_status_wf: ' || 'CTO_WORKFLOW.check_reservation_status_wf ' ||

2718:
2719: when OTHERS then
2720: cto_msg_pub.cto_message('BOM', 'CTO_CHECK_STATUS_ERROR');
2721: IF PG_DEBUG <> 0 THEN
2722: oe_debug_pub.add('check_reservation_status_wf: ' || 'CTO_WORKFLOW.check_reservation_status_wf ' ||
2723: to_char(l_stmt_num) || ':' ||
2724: substrb(sqlerrm, 1, 100));
2725: END IF;
2726: /*-------------------------------------------+

Line 2729: wf_core.context('CTO_WORKFLOW', 'check_reservation_status_wf',

2725: END IF;
2726: /*-------------------------------------------+
2727: Error Information for Notification.
2728: +--------------------------------------------*/
2729: wf_core.context('CTO_WORKFLOW', 'check_reservation_status_wf',
2730: p_itemtype, p_itemkey, to_char(p_actid),
2731: p_funcmode);
2732: raise;
2733: END check_reservation_status_wf;

Line 2804: OE_DEBUG_PUB.add('calculate_cost_rollup_wf_ml: ' || 'CTO_WORKFLOW.calculate_cost_rollup_wf' ||

2800:
2801: EXCEPTION
2802: when UNEXP_ERROR then
2803: IF PG_DEBUG <> 0 THEN
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;

Line 2810: wf_core.context('CTO_WORKFLOW', 'calculate_cost_rollup_wf',

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:
2814: when NO_DATA_FOUND then

Line 2816: oe_debug_pub.add('calculate_cost_rollup_wf_ml: ' || 'CTO_WORKFLOW.calculate_cost_rollup_wf ' ||

2812: raise;
2813:
2814: when NO_DATA_FOUND then
2815: IF PG_DEBUG <> 0 THEN
2816: oe_debug_pub.add('calculate_cost_rollup_wf_ml: ' || 'CTO_WORKFLOW.calculate_cost_rollup_wf ' ||
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');

Line 2827: oe_debug_pub.add('calculate_cost_rollup_wf_ml: ' || 'CTO_WORKFLOW.calculate_cost_rollup_wf ' ||

2823:
2824: when OTHERS then
2825: cto_msg_pub.cto_message('BOM', 'CTO_CALC_COST_ROLLUP_ERROR');
2826: IF PG_DEBUG <> 0 THEN
2827: oe_debug_pub.add('calculate_cost_rollup_wf_ml: ' || 'CTO_WORKFLOW.calculate_cost_rollup_wf ' ||
2828: to_char(l_stmt_num) || ':' ||
2829: substrb(sqlerrm, 1, 100),1);
2830: END IF;
2831: wf_core.context('CTO_WORKFLOW', 'calculate_cost_rollup_wf',

Line 2831: wf_core.context('CTO_WORKFLOW', 'calculate_cost_rollup_wf',

2827: oe_debug_pub.add('calculate_cost_rollup_wf_ml: ' || 'CTO_WORKFLOW.calculate_cost_rollup_wf ' ||
2828: to_char(l_stmt_num) || ':' ||
2829: substrb(sqlerrm, 1, 100),1);
2830: END IF;
2831: wf_core.context('CTO_WORKFLOW', 'calculate_cost_rollup_wf',
2832: p_itemtype, p_itemkey, to_char(p_actid),
2833: p_funcmode);
2834: raise;
2835:

Line 2930: OE_DEBUG_PUB.add('set_parameter_lead_time_wf_ml: ' || 'CTO_WORKFLOW.set_parameter_lead_time_wf_ml' ||

2926: EXCEPTION
2927:
2928: when UNEXP_ERROR then
2929: IF PG_DEBUG <> 0 THEN
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;

Line 2936: wf_core.context('CTO_WORKFLOW', 'set_parameter_lead_time_wf_ml',

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:
2940: when NO_DATA_FOUND then

Line 2942: oe_debug_pub.add('set_parameter_lead_time_wf_ml: ' || 'CTO_WORKFLOW.set_parameter_lead_time_wf_ml'

2938: raise;
2939:
2940: when NO_DATA_FOUND then
2941: IF PG_DEBUG <> 0 THEN
2942: oe_debug_pub.add('set_parameter_lead_time_wf_ml: ' || 'CTO_WORKFLOW.set_parameter_lead_time_wf_ml'
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');

Line 2953: oe_debug_pub.add('set_parameter_lead_time_wf_ml: ' || 'CTO_WORKFLOW.set_parameter_lead_time_wf_ml'

2949:
2950: when OTHERS then
2951: cto_msg_pub.cto_message('BOM', 'CTO_CALC_LEAD_TIME_ERROR');
2952: IF PG_DEBUG <> 0 THEN
2953: oe_debug_pub.add('set_parameter_lead_time_wf_ml: ' || 'CTO_WORKFLOW.set_parameter_lead_time_wf_ml'
2954: || to_char(l_stmt_num) || ':' ||
2955: substrb(sqlerrm, 1, 100),1);
2956: END IF;
2957: wf_core.context('CTO_WORKFLOW', 'set_parameter_lead_time_wf_ml',

Line 2957: wf_core.context('CTO_WORKFLOW', 'set_parameter_lead_time_wf_ml',

2953: oe_debug_pub.add('set_parameter_lead_time_wf_ml: ' || 'CTO_WORKFLOW.set_parameter_lead_time_wf_ml'
2954: || to_char(l_stmt_num) || ':' ||
2955: substrb(sqlerrm, 1, 100),1);
2956: END IF;
2957: wf_core.context('CTO_WORKFLOW', 'set_parameter_lead_time_wf_ml',
2958: p_itemtype, p_itemkey, to_char(p_actid),
2959: p_funcmode);
2960: raise;
2961:

Line 3182: l_ret_stat :=CTO_WORKFLOW_API_PK.display_wf_status

3178: IF PG_DEBUG <> 0 THEN
3179: oe_debug_pub.add('check_supply_type_wf: ' ||'calling display_wf_status with status',1);
3180: END IF;
3181:
3182: l_ret_stat :=CTO_WORKFLOW_API_PK.display_wf_status
3183: (p_order_line_id=>p_itemkey
3184: );
3185:
3186: IF l_ret_stat = 1 THEN

Line 3275: OE_DEBUG_PUB.add('check_supply_type_wf: ' || 'CTO_WORKFLOW.check_supply_type_wf ' ||

3271: EXCEPTION
3272:
3273: when FND_API.G_EXC_ERROR then
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;

Line 3285: OE_DEBUG_PUB.add('check_supply_type_wf: ' || 'CTO_WORKFLOW.check_supply_type_wf ' ||

3281:
3282:
3283: when FND_API.G_EXC_UNEXPECTED_ERROR then
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;

Line 3290: wf_core.context('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:
3294: when OTHERS then

Line 3296: oe_debug_pub.add('check_supply_type_wf: ' || 'CTO_WORKFLOW.check_supply_type_wf' ||

3292: raise;
3293:
3294: when OTHERS then
3295: IF PG_DEBUG <> 0 THEN
3296: oe_debug_pub.add('check_supply_type_wf: ' || 'CTO_WORKFLOW.check_supply_type_wf' ||
3297: to_char(l_stmt_num)||':'||sqlerrm); --bugfix 3136206
3298: END IF;
3299: wf_core.context('CTO_WORKFLOW', 'check_supply_type_wf',
3300: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);

Line 3299: wf_core.context('CTO_WORKFLOW', 'check_supply_type_wf',

3295: IF PG_DEBUG <> 0 THEN
3296: oe_debug_pub.add('check_supply_type_wf: ' || 'CTO_WORKFLOW.check_supply_type_wf' ||
3297: to_char(l_stmt_num)||':'||sqlerrm); --bugfix 3136206
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;

Line 3315: Create Flow Schedule activity in the CTO workflow.

3311:
3312: /*============================================================================
3313: Procedure: create_flow_schedule__wf
3314: Description: This procedure gets called when executing the
3315: Create Flow Schedule activity in the CTO workflow.
3316:
3317:
3318: More to come...
3319: Parameters:

Line 3481: OE_DEBUG_PUB.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf raised exp error in stmt ' ||

3477: EXCEPTION
3478:
3479: when FND_API.G_EXC_ERROR then
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;

Line 3492: oe_debug_pub.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf '

3488: return;
3489:
3490: when NO_DATA_FOUND then
3491: IF PG_DEBUG <> 0 THEN
3492: oe_debug_pub.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf '
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');

Line 3505: OE_DEBUG_PUB.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf raised unexp error in stmt ' ||

3501: return;
3502:
3503: when FND_API.G_EXC_UNEXPECTED_ERROR then
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;

Line 3515: oe_debug_pub.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf '

3511:
3512: when OTHERS then
3513: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_FLOW_SCHED_ERROR');
3514: IF PG_DEBUG <> 0 THEN
3515: oe_debug_pub.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf '
3516: || to_char(l_stmt_num) || ':' ||
3517: substrb(sqlerrm, 1, 250),1);
3518: END IF;
3519: wf_core.context('CTO_WORKFLOW', 'create_flow_schedule_wf',

Line 3519: wf_core.context('CTO_WORKFLOW', 'create_flow_schedule_wf',

3515: oe_debug_pub.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf '
3516: || to_char(l_stmt_num) || ':' ||
3517: substrb(sqlerrm, 1, 250),1);
3518: END IF;
3519: wf_core.context('CTO_WORKFLOW', 'create_flow_schedule_wf',
3520: p_itemtype, p_itemkey, to_char(p_actid),
3521: p_funcmode);
3522: raise;
3523:

Line 3577: OE_DEBUG_PUB.add ('lock_line_id: ' || 'CTO_WORKFLOW.Lock_Line_Id: Could not lock line id '|| p_line_id ||' for update.');

3573: null;
3574:
3575: when record_locked then
3576: IF PG_DEBUG <> 0 THEN
3577: OE_DEBUG_PUB.add ('lock_line_id: ' || 'CTO_WORKFLOW.Lock_Line_Id: Could not lock line id '|| p_line_id ||' for update.');
3578:
3579: OE_DEBUG_PUB.add ('lock_line_id: ' || 'This line is being processed by another process.');
3580: END IF;
3581: x_result := 'COMPLETE:INCOMPLETE';

Line 3585: OE_DEBUG_PUB.add ('lock_line_id: ' || 'CTO_WORKFLOW.Lock_Line_Id: Unexpected Error : '||sqlerrm);

3581: x_result := 'COMPLETE:INCOMPLETE';
3582:
3583: when others then
3584: IF PG_DEBUG <> 0 THEN
3585: OE_DEBUG_PUB.add ('lock_line_id: ' || 'CTO_WORKFLOW.Lock_Line_Id: Unexpected Error : '||sqlerrm);
3586: END IF;
3587: x_result := 'COMPLETE:INCOMPLETE';
3588:
3589: END Lock_Line_Id;

Line 3831: OE_DEBUG_PUB.add ('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf: Could not lock line id '||

3827:
3828: when record_locked then
3829: cto_msg_pub.cto_message('BOM', 'CTO_ORDER_LINE_LOCKED');
3830: IF PG_DEBUG <> 0 THEN
3831: OE_DEBUG_PUB.add ('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf: Could not lock line id '||
3832: p_itemkey ||' for update.');
3833:
3834: OE_DEBUG_PUB.add ('set_parameter_work_order_wf: ' || 'This line is being processed by another process.');
3835: END IF;

Line 3846: OE_DEBUG_PUB.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf raised exc error. ' ||

3842:
3843: when FND_API.G_EXC_ERROR then
3844: unlock_line_id (p_itemkey, x_result); -- bugfix 3136206
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;

Line 3860: OE_DEBUG_PUB.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf raised unexc error. ' ||

3856: when FND_API.G_EXC_UNEXPECTED_ERROR then
3857: unlock_line_id (p_itemkey, x_result); -- bugfix 3136206
3858: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_WORK_ORDER_ERROR');
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;

Line 3865: wf_core.context('CTO_WORKFLOW', 'set_parameter_work_order_wf',

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:
3869:

Line 3892: oe_debug_pub.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf:'

3888: IF l_build_in_wip = 'N' THEN
3889: --set the build in wip flag
3890: cto_msg_pub.cto_message('BOM', 'CTO_BUILD_IN_WIP_FLAG');
3891: IF PG_DEBUG <> 0 THEN
3892: oe_debug_pub.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf:'
3893: ||'ERROR : Buld_in_wip_flag needs to be checked',1 );
3894: END IF;
3895:
3896: ELSE--no_data_found is for someother reason

Line 3900: oe_debug_pub.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf'

3896: ELSE--no_data_found is for someother reason
3897:
3898: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_WORK_ORDER_ERROR');
3899: IF PG_DEBUG <> 0 THEN
3900: oe_debug_pub.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf'
3901: || to_char(l_stmt_num) || ':' ||
3902: substrb(sqlerrm, 1, 100),1);
3903: END IF;
3904: END IF;

Line 3920: oe_debug_pub.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf: '

3916: when OTHERS then
3917: unlock_line_id (p_itemkey, x_result); -- bugfix 3136206
3918: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_WORK_ORDER_ERROR');
3919: IF PG_DEBUG <> 0 THEN
3920: oe_debug_pub.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf: '
3921: || to_char(l_stmt_num) || ':' ||
3922: substrb(sqlerrm, 1, 100));
3923: END IF;
3924: wf_core.context('CTO_WORKFLOW', 'set_parameter_work_order_wf',

Line 3924: wf_core.context('CTO_WORKFLOW', 'set_parameter_work_order_wf',

3920: oe_debug_pub.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf: '
3921: || to_char(l_stmt_num) || ':' ||
3922: substrb(sqlerrm, 1, 100));
3923: END IF;
3924: wf_core.context('CTO_WORKFLOW', 'set_parameter_work_order_wf',
3925: p_itemtype, p_itemkey, to_char(p_actid),
3926: p_funcmode);
3927:
3928: raise;

Line 4006: oe_debug_pub.add('submit_conc_prog_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '

4002: EXCEPTION
4003:
4004: when NO_DATA_FOUND then
4005: IF PG_DEBUG <> 0 THEN
4006: oe_debug_pub.add('submit_conc_prog_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '
4007: || to_char(l_stmt_num) || ':' ||
4008: substrb(sqlerrm, 1, 100));
4009: END IF;
4010: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',

Line 4010: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',

4006: oe_debug_pub.add('submit_conc_prog_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '
4007: || to_char(l_stmt_num) || ':' ||
4008: substrb(sqlerrm, 1, 100));
4009: END IF;
4010: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',
4011: p_itemtype, p_itemkey, to_char(p_actid),
4012: p_funcmode);
4013: raise;
4014:

Line 4017: oe_debug_pub.add('submit_conc_prog_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '

4013: raise;
4014:
4015: when OTHERS then
4016: IF PG_DEBUG <> 0 THEN
4017: oe_debug_pub.add('submit_conc_prog_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '
4018: || to_char(l_stmt_num) || ':' ||
4019: substrb(sqlerrm, 1, 100));
4020: END IF;
4021: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',

Line 4021: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',

4017: oe_debug_pub.add('submit_conc_prog_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '
4018: || to_char(l_stmt_num) || ':' ||
4019: substrb(sqlerrm, 1, 100));
4020: END IF;
4021: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',
4022: p_itemtype, p_itemkey, to_char(p_actid),
4023: p_funcmode);
4024: raise;
4025:

Line 4067: CTO_WORKFLOW_API_PK.query_wf_activity_status(

4063:
4064: if (p_funcmode = 'RUN') then
4065:
4066: l_stmt_num := 10;
4067: CTO_WORKFLOW_API_PK.query_wf_activity_status(
4068: p_itemtype => p_itemtype,
4069: p_itemkey => p_itemkey,
4070: p_activity_label => 'EXECLEADTIME',
4071: p_activity_name => 'EXECLEADTIME',

Line 4084: CTO_WORKFLOW_API_PK.query_wf_activity_status(

4080: IF PG_DEBUG <> 0 THEN
4081: oe_debug_pub.add('submit_and_continue_wf: ' || 'Show message for Lead Time conc program',1);
4082: END IF;
4083: ELSE
4084: CTO_WORKFLOW_API_PK.query_wf_activity_status(
4085: p_itemtype => p_itemtype,
4086: p_itemkey => p_itemkey,
4087: p_activity_label => 'EXECUTECONCPROGAFAS',
4088: p_activity_name => 'EXECUTECONCPROGAFAS',

Line 4146: oe_debug_pub.add('submit_and_continue_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '

4142: EXCEPTION
4143:
4144: when NO_DATA_FOUND then
4145: IF PG_DEBUG <> 0 THEN
4146: oe_debug_pub.add('submit_and_continue_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '
4147: || to_char(l_stmt_num) || ':' ||
4148: substrb(sqlerrm, 1, 100));
4149: END IF;
4150: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',

Line 4150: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',

4146: oe_debug_pub.add('submit_and_continue_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '
4147: || to_char(l_stmt_num) || ':' ||
4148: substrb(sqlerrm, 1, 100));
4149: END IF;
4150: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',
4151: p_itemtype, p_itemkey, to_char(p_actid),
4152: p_funcmode);
4153: raise;
4154:

Line 4157: oe_debug_pub.add('submit_and_continue_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '

4153: raise;
4154:
4155: when OTHERS then
4156: IF PG_DEBUG <> 0 THEN
4157: oe_debug_pub.add('submit_and_continue_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '
4158: || to_char(l_stmt_num) || ':' ||
4159: substrb(sqlerrm, 1, 100));
4160: END IF;
4161: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',

Line 4161: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',

4157: oe_debug_pub.add('submit_and_continue_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '
4158: || to_char(l_stmt_num) || ':' ||
4159: substrb(sqlerrm, 1, 100));
4160: END IF;
4161: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',
4162: p_itemtype, p_itemkey, to_char(p_actid),
4163: p_funcmode);
4164: raise;
4165:

Line 4550: oe_debug_pub.add('Purchase_price_calc_wf: ' || 'CTO_WORKFLOW.Purchase_Price_calc_wf: '

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: '
4551: || to_char(l_stmt_num) || ':' ||
4552: substrb(sqlerrm, 1, 100));
4553: END IF;
4554: wf_core.context('CTO_WORKFLOW', 'Purchase_Price_calc_wf',

Line 4554: wf_core.context('CTO_WORKFLOW', 'Purchase_Price_calc_wf',

4550: oe_debug_pub.add('Purchase_price_calc_wf: ' || 'CTO_WORKFLOW.Purchase_Price_calc_wf: '
4551: || to_char(l_stmt_num) || ':' ||
4552: substrb(sqlerrm, 1, 100));
4553: END IF;
4554: wf_core.context('CTO_WORKFLOW', 'Purchase_Price_calc_wf',
4555: p_itemtype, p_itemkey, to_char(p_actid),
4556: p_funcmode);
4557: raise;
4558:

Line 4630: OE_DEBUG_PUB.add('chk_rsv_after_afas_wf: ' || 'CTO_WORKFLOW.chk_rsv_after_afas_wf' || to_char(l_stmt_num) );

4626:
4627: EXCEPTION
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

Line 4650: wf_core.context('CTO_WORKFLOW', 'chk_rsv_after_afas_wf', p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);

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
4654: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

Line 4666: wf_core.context('CTO_WORKFLOW','chk_rsv_after_afas_wf',p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);

4662: END IF;
4663: /*-------------------------------------------+
4664: Error Information for Notification.
4665: +--------------------------------------------*/
4666: wf_core.context('CTO_WORKFLOW','chk_rsv_after_afas_wf',p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
4667: raise;
4668:
4669: END chk_rsv_after_afas_wf;
4670:

Line 4760: return_value:= CTO_WORKFLOW_API_PK.display_wf_status(to_number(p_itemkey));

4756:
4757:
4758:
4759: l_stmt_num:=25;
4760: return_value:= CTO_WORKFLOW_API_PK.display_wf_status(to_number(p_itemkey));
4761:
4762:
4763: IF PG_DEBUG <> 0 THEN
4764: oe_debug_pub.add('check_supply_creation_wf: ' || 'return value from display_wf_status'

Line 4837: return_value:= CTO_WORKFLOW_API_PK.display_wf_status(to_number(p_itemkey));

4833: END IF;--l_return_status
4834:
4835:
4836: l_stmt_num:=70;
4837: return_value:= CTO_WORKFLOW_API_PK.display_wf_status(to_number(p_itemkey));
4838:
4839:
4840: IF PG_DEBUG <> 0 THEN
4841: oe_debug_pub.add('check_supply_creation_wf: ' || 'return value from display_wf_status'

Line 4863: OE_DEBUG_PUB.add('check_supply_creation_wf: ' || 'CTO_WORKFLOW.check_supply_creation_wf ' ||

4859: EXCEPTION
4860:
4861: when FND_API.G_EXC_ERROR then
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;

Line 4869: wf_core.context('CTO_WORKFLOW', 'check_supply_creation_wf',

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;
4872:
4873:

Line 4876: OE_DEBUG_PUB.add('check_supply_creation_wf: ' || 'CTO_WORKFLOW.check_supply_creation_wf ' ||

4872:
4873:
4874: when FND_API.G_EXC_UNEXPECTED_ERROR then
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;

Line 4881: wf_core.context('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:
4885: when OTHERS then

Line 4887: oe_debug_pub.add('check_supply_creation_wf: ' || 'CTO_WORKFLOW.check_supply_creation_wf' ||

4883: raise;
4884:
4885: when OTHERS then
4886: IF PG_DEBUG <> 0 THEN
4887: oe_debug_pub.add('check_supply_creation_wf: ' || 'CTO_WORKFLOW.check_supply_creation_wf' ||
4888: to_char(l_stmt_num));
4889: oe_debug_pub.add('check_supply_creation_wf: ' || 'errmsg' ||sqlerrm,1);
4890: END IF;
4891: wf_core.context('CTO_WORKFLOW', 'check_supply_creation_wf',

Line 4891: wf_core.context('CTO_WORKFLOW', 'check_supply_creation_wf',

4887: oe_debug_pub.add('check_supply_creation_wf: ' || 'CTO_WORKFLOW.check_supply_creation_wf' ||
4888: to_char(l_stmt_num));
4889: oe_debug_pub.add('check_supply_creation_wf: ' || 'errmsg' ||sqlerrm,1);
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;

Line 4907: END CTO_WORKFLOW;

4903:
4904:
4905:
4906:
4907: END CTO_WORKFLOW;