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.19.12020000.2 2012/08/09 15:12:48 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 1404: OE_DEBUG_PUB.add('create_config_item_wf: ' || 'CTO_WORKFLOW.create_config_item_wf ' ||

1400: EXCEPTION
1401:
1402: when FND_API.G_EXC_ERROR then
1403: IF PG_DEBUG <> 0 THEN
1404: OE_DEBUG_PUB.add('create_config_item_wf: ' || 'CTO_WORKFLOW.create_config_item_wf ' ||
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);

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

1412: rollback to savepoint before_item_creation;
1413:
1414: when FND_API.G_EXC_UNEXPECTED_ERROR then
1415: IF PG_DEBUG <> 0 THEN
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;

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

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

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

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

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

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

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

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

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

2006: when NO_DATA_FOUND then
2007: --rollback to savepoint before_item_creation;
2008: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_ITEM_ERROR');
2009: IF PG_DEBUG <> 0 THEN
2010: oe_debug_pub.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation::ndf::' || to_char(l_stmt_num) );
2011: END IF;
2012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2013:
2014:

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

2015: when PROCESS_ERROR then
2016: --rollback to savepoint before_item_creation;
2017:
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;

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

2026:
2027: when FND_API.G_EXC_UNEXPECTED_ERROR then
2028: --rollback to savepoint before_item_creation;
2029: IF PG_DEBUG <> 0 THEN
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;

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

2039: when OTHERS then
2040: --rollback to savepoint before_item_creation;
2041: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_ITEM_ERROR');
2042: IF PG_DEBUG <> 0 THEN
2043: oe_debug_pub.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation' ||
2044: to_char(l_stmt_num) || ':' ||
2045: substrb(sqlerrm, 1, 100));
2046: END IF;
2047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2315: --below code calls display_wf_status to update the correct
2316: --before booking and scheduling if item is reserved
2317: --
2318: l_stmt_num := 100;
2319: return_value:= CTO_WORKFLOW_API_PK.display_wf_status(to_number(p_itemkey));
2320:
2321: if return_value <> 1 then
2322: cto_msg_pub.cto_message('CTO', 'CTO_ERROR_FROM_DISPLAY_STATUS');
2323: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

2359:
2360: EXCEPTION
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

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

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

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

2395: END IF;
2396: /*-------------------------------------------+
2397: Error Information for Notification.
2398: +--------------------------------------------*/
2399: wf_core.context('CTO_WORKFLOW','rsv_before_booking_wf',p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
2400: raise;
2401:
2402: END rsv_before_booking_wf;
2403:

Line 2481: ( 'CTO_WORKFLOW',

2477: if fnd_msg_pub.check_msg_level
2478: (fnd_msg_pub.g_msg_lvl_unexp_error)
2479: then
2480: fnd_msg_pub.Add_Exc_msg
2481: ( 'CTO_WORKFLOW',
2482: 'check_inv_rsv_exists'
2483: );
2484: end if;
2485: cto_msg_pub.count_and_get

Line 2594: ( 'CTO_WORKFLOW',

2590: if fnd_msg_pub.check_msg_level
2591: (fnd_msg_pub.g_msg_lvl_unexp_error)
2592: then
2593: fnd_msg_pub.Add_Exc_msg
2594: ( 'CTO_WORKFLOW',
2595: 'check_inv_rsv_exists'
2596: );
2597: end if;
2598: cto_msg_pub.count_and_get

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

2729: x_result := 'COMPLETE';
2730:
2731: when PROCESS_ERROR then
2732: IF PG_DEBUG <> 0 THEN
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;

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

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 ' ||
2743: to_char(l_stmt_num) || ':' ||
2744: l_return_status);
2745: END IF;
2746: OE_STANDARD_WF.Save_Messages;

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

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

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

2751:
2752: when OTHERS then
2753: cto_msg_pub.cto_message('BOM', 'CTO_CHECK_STATUS_ERROR');
2754: IF PG_DEBUG <> 0 THEN
2755: oe_debug_pub.add('check_reservation_status_wf: ' || 'CTO_WORKFLOW.check_reservation_status_wf ' ||
2756: to_char(l_stmt_num) || ':' ||
2757: substrb(sqlerrm, 1, 100));
2758: END IF;
2759: /*-------------------------------------------+

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

2758: END IF;
2759: /*-------------------------------------------+
2760: Error Information for Notification.
2761: +--------------------------------------------*/
2762: wf_core.context('CTO_WORKFLOW', 'check_reservation_status_wf',
2763: p_itemtype, p_itemkey, to_char(p_actid),
2764: p_funcmode);
2765: raise;
2766: END check_reservation_status_wf;

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

2833:
2834: EXCEPTION
2835: when UNEXP_ERROR then
2836: IF PG_DEBUG <> 0 THEN
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;

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

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

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

2845: raise;
2846:
2847: when NO_DATA_FOUND then
2848: IF PG_DEBUG <> 0 THEN
2849: oe_debug_pub.add('calculate_cost_rollup_wf_ml: ' || 'CTO_WORKFLOW.calculate_cost_rollup_wf ' ||
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');

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

2856:
2857: when OTHERS then
2858: cto_msg_pub.cto_message('BOM', 'CTO_CALC_COST_ROLLUP_ERROR');
2859: IF PG_DEBUG <> 0 THEN
2860: oe_debug_pub.add('calculate_cost_rollup_wf_ml: ' || 'CTO_WORKFLOW.calculate_cost_rollup_wf ' ||
2861: to_char(l_stmt_num) || ':' ||
2862: substrb(sqlerrm, 1, 100),1);
2863: END IF;
2864: wf_core.context('CTO_WORKFLOW', 'calculate_cost_rollup_wf',

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

2860: oe_debug_pub.add('calculate_cost_rollup_wf_ml: ' || 'CTO_WORKFLOW.calculate_cost_rollup_wf ' ||
2861: to_char(l_stmt_num) || ':' ||
2862: substrb(sqlerrm, 1, 100),1);
2863: END IF;
2864: wf_core.context('CTO_WORKFLOW', 'calculate_cost_rollup_wf',
2865: p_itemtype, p_itemkey, to_char(p_actid),
2866: p_funcmode);
2867: raise;
2868:

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

2959: EXCEPTION
2960:
2961: when UNEXP_ERROR then
2962: IF PG_DEBUG <> 0 THEN
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;

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

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

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

2971: raise;
2972:
2973: when NO_DATA_FOUND then
2974: IF PG_DEBUG <> 0 THEN
2975: oe_debug_pub.add('set_parameter_lead_time_wf_ml: ' || 'CTO_WORKFLOW.set_parameter_lead_time_wf_ml'
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');

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

2982:
2983: when OTHERS then
2984: cto_msg_pub.cto_message('BOM', 'CTO_CALC_LEAD_TIME_ERROR');
2985: IF PG_DEBUG <> 0 THEN
2986: oe_debug_pub.add('set_parameter_lead_time_wf_ml: ' || 'CTO_WORKFLOW.set_parameter_lead_time_wf_ml'
2987: || to_char(l_stmt_num) || ':' ||
2988: substrb(sqlerrm, 1, 100),1);
2989: END IF;
2990: wf_core.context('CTO_WORKFLOW', 'set_parameter_lead_time_wf_ml',

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

2986: oe_debug_pub.add('set_parameter_lead_time_wf_ml: ' || 'CTO_WORKFLOW.set_parameter_lead_time_wf_ml'
2987: || to_char(l_stmt_num) || ':' ||
2988: substrb(sqlerrm, 1, 100),1);
2989: END IF;
2990: wf_core.context('CTO_WORKFLOW', 'set_parameter_lead_time_wf_ml',
2991: p_itemtype, p_itemkey, to_char(p_actid),
2992: p_funcmode);
2993: raise;
2994:

Line 3215: l_ret_stat :=CTO_WORKFLOW_API_PK.display_wf_status

3211: IF PG_DEBUG <> 0 THEN
3212: oe_debug_pub.add('check_supply_type_wf: ' ||'calling display_wf_status with status',1);
3213: END IF;
3214:
3215: l_ret_stat :=CTO_WORKFLOW_API_PK.display_wf_status
3216: (p_order_line_id=>p_itemkey
3217: );
3218:
3219: IF l_ret_stat = 1 THEN

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

3304: EXCEPTION
3305:
3306: when FND_API.G_EXC_ERROR then
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;

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

3314:
3315:
3316: when FND_API.G_EXC_UNEXPECTED_ERROR then
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;

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

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

3325: raise;
3326:
3327: when OTHERS then
3328: IF PG_DEBUG <> 0 THEN
3329: oe_debug_pub.add('check_supply_type_wf: ' || 'CTO_WORKFLOW.check_supply_type_wf' ||
3330: to_char(l_stmt_num)||':'||sqlerrm); --bugfix 3136206
3331: END IF;
3332: wf_core.context('CTO_WORKFLOW', 'check_supply_type_wf',
3333: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);

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

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

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

3344:
3345: /*============================================================================
3346: Procedure: create_flow_schedule__wf
3347: Description: This procedure gets called when executing the
3348: Create Flow Schedule activity in the CTO workflow.
3349:
3350:
3351: More to come...
3352: Parameters:

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

3510: EXCEPTION
3511:
3512: when FND_API.G_EXC_ERROR then
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;

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

3521: return;
3522:
3523: when NO_DATA_FOUND then
3524: IF PG_DEBUG <> 0 THEN
3525: oe_debug_pub.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf '
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');

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

3534: return;
3535:
3536: when FND_API.G_EXC_UNEXPECTED_ERROR then
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;

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

3544:
3545: when OTHERS then
3546: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_FLOW_SCHED_ERROR');
3547: IF PG_DEBUG <> 0 THEN
3548: oe_debug_pub.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf '
3549: || to_char(l_stmt_num) || ':' ||
3550: substrb(sqlerrm, 1, 250),1);
3551: END IF;
3552: wf_core.context('CTO_WORKFLOW', 'create_flow_schedule_wf',

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

3548: oe_debug_pub.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf '
3549: || to_char(l_stmt_num) || ':' ||
3550: substrb(sqlerrm, 1, 250),1);
3551: END IF;
3552: wf_core.context('CTO_WORKFLOW', 'create_flow_schedule_wf',
3553: p_itemtype, p_itemkey, to_char(p_actid),
3554: p_funcmode);
3555: raise;
3556:

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

3606: null;
3607:
3608: when record_locked then
3609: IF PG_DEBUG <> 0 THEN
3610: OE_DEBUG_PUB.add ('lock_line_id: ' || 'CTO_WORKFLOW.Lock_Line_Id: Could not lock line id '|| p_line_id ||' for update.');
3611:
3612: OE_DEBUG_PUB.add ('lock_line_id: ' || 'This line is being processed by another process.');
3613: END IF;
3614: x_result := 'COMPLETE:INCOMPLETE';

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

3614: x_result := 'COMPLETE:INCOMPLETE';
3615:
3616: when others then
3617: IF PG_DEBUG <> 0 THEN
3618: OE_DEBUG_PUB.add ('lock_line_id: ' || 'CTO_WORKFLOW.Lock_Line_Id: Unexpected Error : '||sqlerrm);
3619: END IF;
3620: x_result := 'COMPLETE:INCOMPLETE';
3621:
3622: END Lock_Line_Id;

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

3860:
3861: when record_locked then
3862: cto_msg_pub.cto_message('BOM', 'CTO_ORDER_LINE_LOCKED');
3863: IF PG_DEBUG <> 0 THEN
3864: OE_DEBUG_PUB.add ('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf: Could not lock line id '||
3865: p_itemkey ||' for update.');
3866:
3867: OE_DEBUG_PUB.add ('set_parameter_work_order_wf: ' || 'This line is being processed by another process.');
3868: END IF;

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

3875:
3876: when FND_API.G_EXC_ERROR then
3877: unlock_line_id (p_itemkey, x_result); -- bugfix 3136206
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;

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

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

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

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

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

3921: IF l_build_in_wip = 'N' THEN
3922: --set the build in wip flag
3923: cto_msg_pub.cto_message('BOM', 'CTO_BUILD_IN_WIP_FLAG');
3924: IF PG_DEBUG <> 0 THEN
3925: oe_debug_pub.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf:'
3926: ||'ERROR : Buld_in_wip_flag needs to be checked',1 );
3927: END IF;
3928:
3929: ELSE--no_data_found is for someother reason

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

3929: ELSE--no_data_found is for someother reason
3930:
3931: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_WORK_ORDER_ERROR');
3932: IF PG_DEBUG <> 0 THEN
3933: oe_debug_pub.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf'
3934: || to_char(l_stmt_num) || ':' ||
3935: substrb(sqlerrm, 1, 100),1);
3936: END IF;
3937: END IF;

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

3949: when OTHERS then
3950: unlock_line_id (p_itemkey, x_result); -- bugfix 3136206
3951: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_WORK_ORDER_ERROR');
3952: IF PG_DEBUG <> 0 THEN
3953: oe_debug_pub.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf: '
3954: || to_char(l_stmt_num) || ':' ||
3955: substrb(sqlerrm, 1, 100));
3956: END IF;
3957: wf_core.context('CTO_WORKFLOW', 'set_parameter_work_order_wf',

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

3953: oe_debug_pub.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf: '
3954: || to_char(l_stmt_num) || ':' ||
3955: substrb(sqlerrm, 1, 100));
3956: END IF;
3957: wf_core.context('CTO_WORKFLOW', 'set_parameter_work_order_wf',
3958: p_itemtype, p_itemkey, to_char(p_actid),
3959: p_funcmode);
3960:
3961: raise;

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

4088: EXCEPTION
4089:
4090: when NO_DATA_FOUND then
4091: IF PG_DEBUG <> 0 THEN
4092: oe_debug_pub.add('submit_conc_prog_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '
4093: || to_char(l_stmt_num) || ':' ||
4094: substrb(sqlerrm, 1, 100));
4095: END IF;
4096: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',

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

4092: oe_debug_pub.add('submit_conc_prog_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '
4093: || to_char(l_stmt_num) || ':' ||
4094: substrb(sqlerrm, 1, 100));
4095: END IF;
4096: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',
4097: p_itemtype, p_itemkey, to_char(p_actid),
4098: p_funcmode);
4099: raise;
4100:

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

4099: raise;
4100:
4101: when OTHERS then
4102: IF PG_DEBUG <> 0 THEN
4103: oe_debug_pub.add('submit_conc_prog_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '
4104: || to_char(l_stmt_num) || ':' ||
4105: substrb(sqlerrm, 1, 100));
4106: END IF;
4107: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',

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

4103: oe_debug_pub.add('submit_conc_prog_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '
4104: || to_char(l_stmt_num) || ':' ||
4105: substrb(sqlerrm, 1, 100));
4106: END IF;
4107: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',
4108: p_itemtype, p_itemkey, to_char(p_actid),
4109: p_funcmode);
4110: raise;
4111:

Line 4153: CTO_WORKFLOW_API_PK.query_wf_activity_status(

4149:
4150: if (p_funcmode = 'RUN') then
4151:
4152: l_stmt_num := 10;
4153: CTO_WORKFLOW_API_PK.query_wf_activity_status(
4154: p_itemtype => p_itemtype,
4155: p_itemkey => p_itemkey,
4156: p_activity_label => 'EXECLEADTIME',
4157: p_activity_name => 'EXECLEADTIME',

Line 4170: CTO_WORKFLOW_API_PK.query_wf_activity_status(

4166: IF PG_DEBUG <> 0 THEN
4167: oe_debug_pub.add('submit_and_continue_wf: ' || 'Show message for Lead Time conc program',1);
4168: END IF;
4169: ELSE
4170: CTO_WORKFLOW_API_PK.query_wf_activity_status(
4171: p_itemtype => p_itemtype,
4172: p_itemkey => p_itemkey,
4173: p_activity_label => 'EXECUTECONCPROGAFAS',
4174: p_activity_name => 'EXECUTECONCPROGAFAS',

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

4228: EXCEPTION
4229:
4230: when NO_DATA_FOUND then
4231: IF PG_DEBUG <> 0 THEN
4232: oe_debug_pub.add('submit_and_continue_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '
4233: || to_char(l_stmt_num) || ':' ||
4234: substrb(sqlerrm, 1, 100));
4235: END IF;
4236: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',

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

4232: oe_debug_pub.add('submit_and_continue_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '
4233: || to_char(l_stmt_num) || ':' ||
4234: substrb(sqlerrm, 1, 100));
4235: END IF;
4236: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',
4237: p_itemtype, p_itemkey, to_char(p_actid),
4238: p_funcmode);
4239: raise;
4240:

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

4239: raise;
4240:
4241: when OTHERS then
4242: IF PG_DEBUG <> 0 THEN
4243: oe_debug_pub.add('submit_and_continue_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '
4244: || to_char(l_stmt_num) || ':' ||
4245: substrb(sqlerrm, 1, 100));
4246: END IF;
4247: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',

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

4243: oe_debug_pub.add('submit_and_continue_wf: ' || 'CTO_WORKFLOW.submit_conc_prog_wf: '
4244: || to_char(l_stmt_num) || ':' ||
4245: substrb(sqlerrm, 1, 100));
4246: END IF;
4247: wf_core.context('CTO_WORKFLOW', 'submit_conc_prog_wf',
4248: p_itemtype, p_itemkey, to_char(p_actid),
4249: p_funcmode);
4250: raise;
4251:

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

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: '
4650: || to_char(l_stmt_num) || ':' ||
4651: substrb(sqlerrm, 1, 100));
4652: END IF;
4653: wf_core.context('CTO_WORKFLOW', 'Purchase_Price_calc_wf',

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

4649: oe_debug_pub.add('Purchase_price_calc_wf: ' || 'CTO_WORKFLOW.Purchase_Price_calc_wf: '
4650: || to_char(l_stmt_num) || ':' ||
4651: substrb(sqlerrm, 1, 100));
4652: END IF;
4653: wf_core.context('CTO_WORKFLOW', 'Purchase_Price_calc_wf',
4654: p_itemtype, p_itemkey, to_char(p_actid),
4655: p_funcmode);
4656: raise;
4657:

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

4725:
4726: EXCEPTION
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

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

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

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

4761: END IF;
4762: /*-------------------------------------------+
4763: Error Information for Notification.
4764: +--------------------------------------------*/
4765: wf_core.context('CTO_WORKFLOW','chk_rsv_after_afas_wf',p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
4766: raise;
4767:
4768: END chk_rsv_after_afas_wf;
4769:

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

4855:
4856:
4857:
4858: l_stmt_num:=25;
4859: return_value:= CTO_WORKFLOW_API_PK.display_wf_status(to_number(p_itemkey));
4860:
4861:
4862: IF PG_DEBUG <> 0 THEN
4863: oe_debug_pub.add('check_supply_creation_wf: ' || 'return value from display_wf_status'

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

4932: END IF;--l_return_status
4933:
4934:
4935: l_stmt_num:=70;
4936: return_value:= CTO_WORKFLOW_API_PK.display_wf_status(to_number(p_itemkey));
4937:
4938:
4939: IF PG_DEBUG <> 0 THEN
4940: oe_debug_pub.add('check_supply_creation_wf: ' || 'return value from display_wf_status'

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

4958: EXCEPTION
4959:
4960: when FND_API.G_EXC_ERROR then
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;

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

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;
4971:
4972:

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

4971:
4972:
4973: when FND_API.G_EXC_UNEXPECTED_ERROR then
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;

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

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

4982: raise;
4983:
4984: when OTHERS then
4985: IF PG_DEBUG <> 0 THEN
4986: oe_debug_pub.add('check_supply_creation_wf: ' || 'CTO_WORKFLOW.check_supply_creation_wf' ||
4987: to_char(l_stmt_num));
4988: oe_debug_pub.add('check_supply_creation_wf: ' || 'errmsg' ||sqlerrm,1);
4989: END IF;
4990: wf_core.context('CTO_WORKFLOW', 'check_supply_creation_wf',

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

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

Line 5006: END CTO_WORKFLOW;

5002:
5003:
5004:
5005:
5006: END CTO_WORKFLOW;