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

APPS.CTO_WORKFLOW_API_PK dependencies on CTO_WORKFLOW_API_PK

Line 1: package body CTO_WORKFLOW_API_PK as

1: package body CTO_WORKFLOW_API_PK as
2: /* $Header: CTOWFAPB.pls 120.33 2010/07/21 08:39:55 abhissri ship $ */
3:
4: /*============================================================================+
5: | Copyright (c) 1999 Oracle Corporation Belmont, California, USA |

Line 217: | call to CTO_WORKFLOW_API_PK.display_wf_status

213: |
214: | 09-Aug-2005 Kiran Konada
215: | 4545070
216: | Replaced call to OE_ORDER_WF_UTIL.update_flow_status_code with
217: | call to CTO_WORKFLOW_API_PK.display_wf_status
218: |
219: |
220: | 25-Sep-2005 Kiran Konada
221: | bugfix4637281

Line 243: G_PKG_NAME CONSTANT VARCHAR2(30):='CTO_WORKFLOW_API_PK';

239: | Main line bug#4350569
240: |
241: =============================================================================*/
242:
243: G_PKG_NAME CONSTANT VARCHAR2(30):='CTO_WORKFLOW_API_PK';
244:
245: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);
246:
247: TYPE rsv_code_tbl_type is TABLE OF VARCHAR2(1) INDEX BY Binary_integer;

Line 305: oe_debug_pub.add('query_wf_activity_status: ' || 'exception in CTO_WORKFLOW_API_PK.query_wf_activity_status'||sqlerrm, 1);

301:
302: when others then
303: p_activity_status := 'NULL';
304: IF PG_DEBUG <> 0 THEN
305: oe_debug_pub.add('query_wf_activity_status: ' || 'exception in CTO_WORKFLOW_API_PK.query_wf_activity_status'||sqlerrm, 1);
306: END IF;
307:
308: END query_wf_activity_status;
309:

Line 384: oe_debug_pub.add('get_activity_status: ' || 'exception in CTO_WORKFLOW_API_PK.get_activity_status:'||sqlerrm, 1);

380:
381: when others then
382: activity_name := 'NULL';
383: IF PG_DEBUG <> 0 THEN
384: oe_debug_pub.add('get_activity_status: ' || 'exception in CTO_WORKFLOW_API_PK.get_activity_status:'||sqlerrm, 1);
385: END IF;
386:
387: END get_activity_status;
388:

Line 452: oe_debug_pub.add('complete_activity: ' || 'exception in CTO_WORKFLOW_API_PK.complete_activity:'||sqlerrm, 1);

448: EXCEPTION
449:
450: when others then
451: IF PG_DEBUG <> 0 THEN
452: oe_debug_pub.add('complete_activity: ' || 'exception in CTO_WORKFLOW_API_PK.complete_activity:'||sqlerrm, 1);
453: END IF;
454: return (FALSE);
455:
456: END complete_activity;

Line 691: oe_debug_pub.add('display_wf_status: ' || 'CTO_WORKFLOW_API_PK.display_wf_status raised exp error::stmt number '||to_char(l_stmt_num), 1);

687:
688: EXCEPTION
689: when FND_API.G_EXC_ERROR then
690: IF PG_DEBUG <> 0 THEN
691: oe_debug_pub.add('display_wf_status: ' || 'CTO_WORKFLOW_API_PK.display_wf_status raised exp error::stmt number '||to_char(l_stmt_num), 1);
692: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',
693: 'CTO_WORKFLOW_API_PK.display_wf_status raised exp error::stmt number '|| to_char(l_stmt_num));
694: End if;
695: return 0;--bugfix 4545070

Line 693: 'CTO_WORKFLOW_API_PK.display_wf_status raised exp error::stmt number '|| to_char(l_stmt_num));

689: when FND_API.G_EXC_ERROR then
690: IF PG_DEBUG <> 0 THEN
691: oe_debug_pub.add('display_wf_status: ' || 'CTO_WORKFLOW_API_PK.display_wf_status raised exp error::stmt number '||to_char(l_stmt_num), 1);
692: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',
693: 'CTO_WORKFLOW_API_PK.display_wf_status raised exp error::stmt number '|| to_char(l_stmt_num));
694: End if;
695: return 0;--bugfix 4545070
696:
697: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 699: oe_debug_pub.add('display_wf_status: ' || 'CTO_WORKFLOW_API_PK.display_wf_status raised unexp error::stmt number '||

695: return 0;--bugfix 4545070
696:
697: when FND_API.G_EXC_UNEXPECTED_ERROR then
698: IF PG_DEBUG <> 0 THEN
699: oe_debug_pub.add('display_wf_status: ' || 'CTO_WORKFLOW_API_PK.display_wf_status raised unexp error::stmt number '||
700: to_char(l_stmt_num)||sqlerrm, 1);
701: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',
702: 'CTO_WORKFLOW_API_PK.display_wf_status raised unexp error::stmt number '|| to_char(l_stmt_num));
703: End if;

Line 702: 'CTO_WORKFLOW_API_PK.display_wf_status raised unexp error::stmt number '|| to_char(l_stmt_num));

698: IF PG_DEBUG <> 0 THEN
699: oe_debug_pub.add('display_wf_status: ' || 'CTO_WORKFLOW_API_PK.display_wf_status raised unexp error::stmt number '||
700: to_char(l_stmt_num)||sqlerrm, 1);
701: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',
702: 'CTO_WORKFLOW_API_PK.display_wf_status raised unexp error::stmt number '|| to_char(l_stmt_num));
703: End if;
704: return 0;
705: when others then
706: IF PG_DEBUG <> 0 THEN

Line 707: oe_debug_pub.add('display_wf_status: ' || 'CTO_WORKFLOW_API_PK.display_wf_status::stmt number '||to_char(l_stmt_num), 1);

703: End if;
704: return 0;
705: when others then
706: IF PG_DEBUG <> 0 THEN
707: oe_debug_pub.add('display_wf_status: ' || 'CTO_WORKFLOW_API_PK.display_wf_status::stmt number '||to_char(l_stmt_num), 1);
708: oe_debug_pub.add('display_wf_status: ' || sqlerrm, 1);
709: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',
710: 'CTO_WORKFLOW_API_PK.display_wf_status::stmt number '||
711: to_char(l_stmt_num));

Line 710: 'CTO_WORKFLOW_API_PK.display_wf_status::stmt number '||

706: IF PG_DEBUG <> 0 THEN
707: oe_debug_pub.add('display_wf_status: ' || 'CTO_WORKFLOW_API_PK.display_wf_status::stmt number '||to_char(l_stmt_num), 1);
708: oe_debug_pub.add('display_wf_status: ' || sqlerrm, 1);
709: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',
710: 'CTO_WORKFLOW_API_PK.display_wf_status::stmt number '||
711: to_char(l_stmt_num));
712: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', sqlerrm);
713: End if;
714: return 0;

Line 915: oe_debug_pub.add('inventory_reservation_check: ' || 'exp error in CTO_WORKFLOW_API_PK.inventory_reservation_check::stmt number '||to_char(l_stmt_num), 1);

911:
912: EXCEPTION
913: when FND_API.G_EXC_ERROR then
914: IF PG_DEBUG <> 0 THEN
915: oe_debug_pub.add('inventory_reservation_check: ' || 'exp error in CTO_WORKFLOW_API_PK.inventory_reservation_check::stmt number '||to_char(l_stmt_num), 1);
916: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no :'|| to_char(l_stmt_num));
917: End if;
918:
919: x_return_status := FND_API.G_RET_STS_ERROR;

Line 926: oe_debug_pub.add('inventory_reservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_reservation_check::stmt number '||to_char(l_stmt_num), 1);

922: p_msg_data => x_msg_data
923: );
924: when FND_API.G_EXC_UNEXPECTED_ERROR then
925: IF PG_DEBUG <> 0 THEN
926: oe_debug_pub.add('inventory_reservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_reservation_check::stmt number '||to_char(l_stmt_num), 1);
927: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no:'|| to_char(l_stmt_num));
928: End if;
929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
930: cto_msg_pub.count_and_get(

Line 937: oe_debug_pub.add('inventory_reservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_reservation_check::stmt number '||to_char(l_stmt_num), 1);

933: );
934:
935: when others then
936: IF PG_DEBUG <> 0 THEN
937: oe_debug_pub.add('inventory_reservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_reservation_check::stmt number '||to_char(l_stmt_num), 1);
938:
939: oe_debug_pub.add('inventory_reservation_check: ' || sqlerrm);
940: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no:'||to_char(l_stmt_num) );
941: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check', sqlerrm);

Line 1070: If (CTO_WORKFLOW_API_PK.complete_activity(

1066: End if;
1067: -- Modified for MOAC project
1068: -- Called complete_acitivity procedure instead of calling wf_engine api.
1069:
1070: If (CTO_WORKFLOW_API_PK.complete_activity(
1071: p_itemtype => G_ITEM_TYPE_NAME,
1072: p_itemkey => to_char(p_order_line_id),
1073: p_activity_name => 'CREATE_SUPPLY_ORDER_ELIGIBLE',
1074: p_result_code => 'RESERVED')) Then

Line 1237: IF (CTO_WORKFLOW_API_PK.complete_activity(

1233:
1234: -- Modified for MOAC project
1235: -- Called complete_acitivity procedure instead of calling wf_engine api.
1236:
1237: IF (CTO_WORKFLOW_API_PK.complete_activity(
1238: p_itemtype => G_ITEM_TYPE_NAME,
1239: p_itemkey => to_char(p_order_line_id),
1240: p_activity_name => 'CREATE_SUPPLY_ORDER_ELIGIBLE',
1241: p_result_code => 'RESERVED')) Then

Line 1341: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'exp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_reserv::stmt number '||to_char(l_stmt_num), 1);

1337:
1338: EXCEPTION
1339: when FND_API.G_EXC_ERROR then
1340: IF PG_DEBUG <> 0 THEN
1341: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'exp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_reserv::stmt number '||to_char(l_stmt_num), 1);
1342: END IF;
1343:
1344: If PG_DEBUG <> 0 Then
1345: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',

Line 1346: 'Exp error in CTO_WORKFLOW_API_PK.wf_update_inv_reserv::

1342: END IF;
1343:
1344: If PG_DEBUG <> 0 Then
1345: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',
1346: 'Exp error in CTO_WORKFLOW_API_PK.wf_update_inv_reserv::
1347: stmt no : '||to_char(l_stmt_num)||'::'||sqlerrm);
1348: End if;
1349:
1350: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1358: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'unexp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_reserv::stmt number '||to_char(l_stmt_num), 1);

1354: );
1355:
1356: when FND_API.G_EXC_UNEXPECTED_ERROR then
1357: IF PG_DEBUG <> 0 THEN
1358: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'unexp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_reserv::stmt number '||to_char(l_stmt_num), 1);
1359: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',
1360: 'UNExp error in CTO_WORKFLOW_API_PK.wf_update_inv_reserv::
1361: stmt no : '||to_char(l_stmt_num)||'::'||sqlerrm);
1362: End if;

Line 1360: 'UNExp error in CTO_WORKFLOW_API_PK.wf_update_inv_reserv::

1356: when FND_API.G_EXC_UNEXPECTED_ERROR then
1357: IF PG_DEBUG <> 0 THEN
1358: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'unexp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_reserv::stmt number '||to_char(l_stmt_num), 1);
1359: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',
1360: 'UNExp error in CTO_WORKFLOW_API_PK.wf_update_inv_reserv::
1361: stmt no : '||to_char(l_stmt_num)||'::'||sqlerrm);
1362: End if;
1363:
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1372: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'unexp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_reserv::stmt number '||to_char(l_stmt_num), 1);

1368: );
1369:
1370: when others then
1371: IF PG_DEBUG <> 0 THEN
1372: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'unexp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_reserv::stmt number '||to_char(l_stmt_num), 1);
1373:
1374: oe_debug_pub.add('wf_update_after_inv_reserv: ' || sqlerrm, 1);
1375: END IF;
1376: If PG_DEBUG <> 0 Then

Line 1508: oe_debug_pub.add('inventory_unreservation_check: ' || 'exp error in CTO_WORKFLOW_API_PK.inventory_unreservation_check::stmt number '||to_char(l_stmt_num), 1);

1504: EXCEPTION
1505:
1506: when FND_API.G_EXC_ERROR then
1507: IF PG_DEBUG <> 0 THEN
1508: oe_debug_pub.add('inventory_unreservation_check: ' || 'exp error in CTO_WORKFLOW_API_PK.inventory_unreservation_check::stmt number '||to_char(l_stmt_num), 1);
1509: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1510: 'Raised FND_API.G_EXC_ERROR, stmt'||l_stmt_num);
1511: End if;
1512: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1520: oe_debug_pub.add('inventory_unreservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_unreservation_check::stmt number '||to_char(l_stmt_num), 1);

1516: );
1517:
1518: when FND_API.G_EXC_UNEXPECTED_ERROR then
1519: IF PG_DEBUG <> 0 THEN
1520: oe_debug_pub.add('inventory_unreservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_unreservation_check::stmt number '||to_char(l_stmt_num), 1);
1521: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1522: 'Raised FND_API.G_EXC_UNEXPECTED_ERROR, stmt'||l_stmt_num);
1523: End if;
1524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1532: oe_debug_pub.add('inventory_unreservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_unreservation_check::stmt number '||to_char(l_stmt_num), 1);

1528: );
1529:
1530: when others then
1531: IF PG_DEBUG <> 0 THEN
1532: oe_debug_pub.add('inventory_unreservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_unreservation_check::stmt number '||to_char(l_stmt_num), 1);
1533:
1534: oe_debug_pub.add('inventory_unreservation_check: ' || sqlerrm, 1);
1535: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1536: 'Raised OTHERS excepn, stmt: '||l_stmt_num);

Line 2015: If (CTO_WORKFLOW_API_PK.complete_activity(

2011: -- Fix for bug 5357300
2012: -- Replaces the direct workflow engine call wf_engine.CompleteActivityInternalName
2013: -- To CTO wrapper api call. As the cto wrapper api will take care of org context switch
2014:
2015: If (CTO_WORKFLOW_API_PK.complete_activity(
2016: p_itemtype => G_ITEM_TYPE_NAME,
2017: p_itemkey => to_char(p_order_line_id),
2018: p_activity_name => 'SHIP_LINE',
2019: p_result_code => 'UNRESERVE')) Then

Line 2078: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'exp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_unreserv::stmt number '||to_char(l_stmt_num), 1);

2074: EXCEPTION
2075: when FND_API.G_EXC_ERROR then
2076:
2077: IF PG_DEBUG <> 0 THEN
2078: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'exp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_unreserv::stmt number '||to_char(l_stmt_num), 1);
2079: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','exp erro stmt no :'|| to_char(l_stmt_num));
2080:
2081: END IF;
2082: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2091: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'unexp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_unreserv::stmt number '||to_char(l_stmt_num));

2087:
2088: when FND_API.G_EXC_UNEXPECTED_ERROR then
2089:
2090: IF PG_DEBUG <> 0 THEN
2091: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'unexp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_unreserv::stmt number '||to_char(l_stmt_num));
2092: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp err stmt no:'|| to_char(l_stmt_num));
2093:
2094: END IF;
2095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2104: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'unexp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_unreserv::stmt number '||to_char(l_stmt_num), 1);

2100:
2101: when others then
2102:
2103: IF PG_DEBUG <> 0 THEN
2104: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'unexp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_unreserv::stmt number '||to_char(l_stmt_num), 1);
2105: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || sqlerrm, 1);
2106: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp errr stmt no :'|| to_char(l_stmt_num));
2107: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE',sqlerrm);
2108:

Line 2205: oe_debug_pub.add('configuration_item_created: ' || 'CTO_WORKFLOW_API_PK.configuration_item_created::stmt number '||

2201: EXCEPTION
2202:
2203: when no_data_found then
2204: IF PG_DEBUG <> 0 THEN
2205: oe_debug_pub.add('configuration_item_created: ' || 'CTO_WORKFLOW_API_PK.configuration_item_created::stmt number '||
2206: to_char(l_stmt_num)||'top model line does not exist, constraint condition is false', 1);
2207: END IF;
2208: x_result := 0;
2209:

Line 2212: oe_debug_pub.add('configuration_item_created: ' || 'CTO_WORKFLOW_API_PK.configuration_item_created::stmt number '||

2208: x_result := 0;
2209:
2210: when OTHERS then
2211: IF PG_DEBUG <> 0 THEN
2212: oe_debug_pub.add('configuration_item_created: ' || 'CTO_WORKFLOW_API_PK.configuration_item_created::stmt number '||
2213: to_char(l_stmt_num)||'constraint condition is false', 1);
2214: oe_debug_pub.add('configuration_item_created: ' || sqlerrm, 1);
2215: END IF;
2216: x_result := 0;

Line 2307: oe_debug_pub.add('configuration_created: ' || 'CTO_WORKFLOW_API_PK.configuration_item_created::stmt number '||

2303: EXCEPTION
2304:
2305: when no_data_found then
2306: IF PG_DEBUG <> 0 THEN
2307: oe_debug_pub.add('configuration_created: ' || 'CTO_WORKFLOW_API_PK.configuration_item_created::stmt number '||
2308: to_char(l_stmt_num)||'top model line does not exist, constraint condition is false', 1);
2309: END IF;
2310: x_result := 0;
2311:

Line 2314: oe_debug_pub.add('configuration_created: ' || 'CTO_WORKFLOW_API_PK.configuration_item_created::stmt number '||

2310: x_result := 0;
2311:
2312: when OTHERS then
2313: IF PG_DEBUG <> 0 THEN
2314: oe_debug_pub.add('configuration_created: ' || 'CTO_WORKFLOW_API_PK.configuration_item_created::stmt number '||
2315: to_char(l_stmt_num)||'constraint condition is false', 1);
2316: oe_debug_pub.add('configuration_created: ' || sqlerrm, 1);
2317: END IF;
2318: x_result := 0;

Line 2361: IF (CTO_WORKFLOW_API_PK.complete_activity(

2357: oe_debug_pub.add('configuration_created: ' || 'Workflow Status is: '||l_active_activity, 5);
2358: END IF;
2359: l_stmt_num := 20;
2360:
2361: IF (CTO_WORKFLOW_API_PK.complete_activity(
2362: p_itemtype => 'OEOL',
2363: p_itemkey => p_model_line_id,
2364: p_activity_name => l_active_activity,
2365: p_result_code => 'COMPLETE') <> TRUE)

Line 2392: oe_debug_pub.add('configuration_created: ' || 'exp error in CTO_WORKFLOW_API_PK.start_model_workflow::stmt number '||to_char(l_stmt_num), 1);

2388: exception
2389:
2390: when PROCESS_ERROR then
2391: IF PG_DEBUG <> 0 THEN
2392: oe_debug_pub.add('configuration_created: ' || 'exp error in CTO_WORKFLOW_API_PK.start_model_workflow::stmt number '||to_char(l_stmt_num), 1);
2393: END IF;
2394: return FALSE;
2395:
2396: when OTHERS then

Line 2398: oe_debug_pub.add('configuration_created: ' || 'unexp error in CTO_WORKFLOW_API_PK.start_model_workflow::stmt number '||to_char(l_stmt_num), 1);

2394: return FALSE;
2395:
2396: when OTHERS then
2397: IF PG_DEBUG <> 0 THEN
2398: oe_debug_pub.add('configuration_created: ' || 'unexp error in CTO_WORKFLOW_API_PK.start_model_workflow::stmt number '||to_char(l_stmt_num), 1);
2399: oe_debug_pub.add('configuration_created: ' || sqlerrm, 1);
2400: END IF;
2401: return FALSE;
2402:

Line 2479: oe_debug_pub.add('configuration_created: ' || 'CTO_WORKFLOW_API_PK.Update_Config_Line::stmt number '||to_char(l_stmt_num)||'not config item',1);

2475: EXCEPTION
2476:
2477: when no_data_found then
2478: IF PG_DEBUG <> 0 THEN
2479: oe_debug_pub.add('configuration_created: ' || 'CTO_WORKFLOW_API_PK.Update_Config_Line::stmt number '||to_char(l_stmt_num)||'not config item',1);
2480: END IF;
2481: x_result := 0;
2482:
2483: when OTHERS then

Line 2485: oe_debug_pub.add('configuration_created: ' || 'CTO_WORKFLOW_API_PK.Update_Config_Line::stmt number '||to_char(l_stmt_num)||'others',1);

2481: x_result := 0;
2482:
2483: when OTHERS then
2484: IF PG_DEBUG <> 0 THEN
2485: oe_debug_pub.add('configuration_created: ' || 'CTO_WORKFLOW_API_PK.Update_Config_Line::stmt number '||to_char(l_stmt_num)||'others',1);
2486:
2487: oe_debug_pub.add('configuration_created: ' || sqlerrm);
2488: END IF;
2489: x_result := 0;

Line 2624: oe_debug_pub.add('configuration_created_for_pto: ' || 'CTO_WORKFLOW_API_PK.configuration_created_for_pto::stmt number '||to_char(l_stmt_num),1);

2620: EXCEPTION
2621:
2622: when no_data_found then
2623: IF PG_DEBUG <> 0 THEN
2624: oe_debug_pub.add('configuration_created_for_pto: ' || 'CTO_WORKFLOW_API_PK.configuration_created_for_pto::stmt number '||to_char(l_stmt_num),1);
2625: oe_debug_pub.add('configuration_created_for_pto: ' || 'config item does not exist, constraint condition is false', 1);
2626: END IF;
2627: x_result := 0;
2628:

Line 2631: oe_debug_pub.add('configuration_created_for_pto: ' || 'CTO_WORKFLOW_API_PK.configuration_created_for_pto::stmt number '||to_char(l_stmt_num), 1);

2627: x_result := 0;
2628:
2629: when OTHERS then
2630: IF PG_DEBUG <> 0 THEN
2631: oe_debug_pub.add('configuration_created_for_pto: ' || 'CTO_WORKFLOW_API_PK.configuration_created_for_pto::stmt number '||to_char(l_stmt_num), 1);
2632: oe_debug_pub.add('configuration_created_for_pto: ' || 'constraint condition is false', 1);
2633: oe_debug_pub.add('configuration_created_for_pto: ' || sqlerrm, 1);
2634: END IF;
2635: x_result := 0;

Line 2694: oe_debug_pub.add('Top_Ato_Model: ' || 'CTO_WORKFLOW_API_PK.top_ato_model::stmt number '||to_char(l_stmt_num)||'not top ato model',1);

2690: EXCEPTION
2691:
2692: when no_data_found then
2693: IF PG_DEBUG <> 0 THEN
2694: oe_debug_pub.add('Top_Ato_Model: ' || 'CTO_WORKFLOW_API_PK.top_ato_model::stmt number '||to_char(l_stmt_num)||'not top ato model',1);
2695: END IF;
2696: x_result := 0;
2697:
2698: when OTHERS then

Line 2700: oe_debug_pub.add('Top_Ato_Model: ' || 'CTO_WORKFLOW_API_PK.top_ato_model::stmt number '||to_char(l_stmt_num)||'others',1);

2696: x_result := 0;
2697:
2698: when OTHERS then
2699: IF PG_DEBUG <> 0 THEN
2700: oe_debug_pub.add('Top_Ato_Model: ' || 'CTO_WORKFLOW_API_PK.top_ato_model::stmt number '||to_char(l_stmt_num)||'others',1);
2701:
2702: oe_debug_pub.add('Top_Ato_Model: ' || sqlerrm);
2703: END IF;
2704: x_result := 0;

Line 2768: oe_debug_pub.add('Config_Line: ' || 'CTO_WORKFLOW_API_PK.Config_Line::stmt number '||to_char(l_stmt_num)||'not config item',1);

2764: EXCEPTION
2765:
2766: when no_data_found then
2767: IF PG_DEBUG <> 0 THEN
2768: oe_debug_pub.add('Config_Line: ' || 'CTO_WORKFLOW_API_PK.Config_Line::stmt number '||to_char(l_stmt_num)||'not config item',1);
2769: END IF;
2770: x_result := 0;
2771:
2772: when OTHERS then

Line 2774: oe_debug_pub.add('Config_Line: ' || 'CTO_WORKFLOW_API_PK.Config_Line::stmt number '||to_char(l_stmt_num)||'others',1);

2770: x_result := 0;
2771:
2772: when OTHERS then
2773: IF PG_DEBUG <> 0 THEN
2774: oe_debug_pub.add('Config_Line: ' || 'CTO_WORKFLOW_API_PK.Config_Line::stmt number '||to_char(l_stmt_num)||'others',1);
2775: oe_debug_pub.add('Config_Line: ' || sqlerrm, 1);
2776: END IF;
2777: x_result := 0;
2778:

Line 2919: oe_debug_pub.add('Change_Status_Batch: ' || 'exp error in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);

2915: EXCEPTION
2916:
2917: WHEN FND_API.G_EXC_ERROR THEN
2918: IF PG_DEBUG <> 0 THEN
2919: oe_debug_pub.add('Change_Status_Batch: ' || 'exp error in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);
2920: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','exp erro change_status_batch :: '||l_stmt_num||sqlerrm);
2921:
2922: END IF;
2923: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2927: oe_debug_pub.add('Change_Status_Batch: ' || 'unexp error in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);

2923: x_return_status := FND_API.G_RET_STS_ERROR;
2924:
2925: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2926: IF PG_DEBUG <> 0 THEN
2927: oe_debug_pub.add('Change_Status_Batch: ' || 'unexp error in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);
2928: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','Unexp err change_status_batch :: '||l_stmt_num||sqlerrm);
2929: End if;
2930:
2931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2935: oe_debug_pub.add('Change_Status_Batch: ' || 'unexp error (others) in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);

2931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2932:
2933: WHEN OTHERS THEN
2934: IF PG_DEBUG <> 0 THEN
2935: oe_debug_pub.add('Change_Status_Batch: ' || 'unexp error (others) in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);
2936: oe_debug_pub.add('Change_Status_Batch: ' || sqlerrm, 1);
2937: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','Unexp err change_status_batch :: '||l_stmt_num||sqlerrm);
2938:
2939: END IF;

Line 3313: oe_debug_pub.add('chk_Buy_Ato_Item: ' || 'CTO_WORKFLOW_API_PK.Config_Line::stmt number '||to_char(l_stmt_num)||'not config item',1);

3309: EXCEPTION
3310:
3311: when no_data_found then
3312: IF PG_DEBUG <> 0 THEN
3313: oe_debug_pub.add('chk_Buy_Ato_Item: ' || 'CTO_WORKFLOW_API_PK.Config_Line::stmt number '||to_char(l_stmt_num)||'not config item',1);
3314: END IF;
3315: x_result := 0;
3316:
3317: when OTHERS then

Line 3319: oe_debug_pub.add('chk_Buy_Ato_Item: ' || 'CTO_WORKFLOW_API_PK.Config_Line::stmt number '||to_char(l_stmt_num)||'others',1);

3315: x_result := 0;
3316:
3317: when OTHERS then
3318: IF PG_DEBUG <> 0 THEN
3319: oe_debug_pub.add('chk_Buy_Ato_Item: ' || 'CTO_WORKFLOW_API_PK.Config_Line::stmt number '||to_char(l_stmt_num)||'others',1);
3320:
3321: oe_debug_pub.add('chk_Buy_Ato_Item: ' || sqlerrm);
3322: END IF;
3323: x_result := 0;

Line 3484: oe_debug_pub.add('CTO_WORKFLOW_API_PK: ' || 'reservation exists::'|| ' NO DATA FOUND EXCEPTION ' || l_stmt_num , 2);

3480: exception
3481: when no_data_found then
3482: x_result := 0 ;
3483: IF PG_DEBUG <> 0 THEN
3484: oe_debug_pub.add('CTO_WORKFLOW_API_PK: ' || 'reservation exists::'|| ' NO DATA FOUND EXCEPTION ' || l_stmt_num , 2);
3485: END IF;
3486: when others then
3487:
3488: x_result := 0 ;

Line 3490: oe_debug_pub.add('CTO_WORKFLOW_API_PK: ' || 'reservation exists::'|| ' OTHERS EXCEPTION ' || l_stmt_num , 2);

3486: when others then
3487:
3488: x_result := 0 ;
3489: IF PG_DEBUG <> 0 THEN
3490: oe_debug_pub.add('CTO_WORKFLOW_API_PK: ' || 'reservation exists::'|| ' OTHERS EXCEPTION ' || l_stmt_num , 2);
3491: END IF;
3492:
3493: end reservation_exists ;
3494:

Line 3802: END CTO_WORKFLOW_API_PK;

3798: End get_status_tokens;
3799:
3800:
3801:
3802: END CTO_WORKFLOW_API_PK;