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.29.12010000.2 2008/08/05 12:21:13 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 686: 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);

682:
683: EXCEPTION
684: when FND_API.G_EXC_ERROR then
685: IF PG_DEBUG <> 0 THEN
686: 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: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',
688: 'CTO_WORKFLOW_API_PK.display_wf_status raised exp error::stmt number '|| to_char(l_stmt_num));
689: End if;
690: return 0;--bugfix 4545070

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

684: when FND_API.G_EXC_ERROR then
685: IF PG_DEBUG <> 0 THEN
686: 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: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',
688: 'CTO_WORKFLOW_API_PK.display_wf_status raised exp error::stmt number '|| to_char(l_stmt_num));
689: End if;
690: return 0;--bugfix 4545070
691:
692: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

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

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

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

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

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

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

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

Line 906: 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);

902:
903: EXCEPTION
904: when FND_API.G_EXC_ERROR then
905: IF PG_DEBUG <> 0 THEN
906: 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);
907: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no :'|| to_char(l_stmt_num));
908: End if;
909:
910: x_return_status := FND_API.G_RET_STS_ERROR;

Line 917: 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);

913: p_msg_data => x_msg_data
914: );
915: when FND_API.G_EXC_UNEXPECTED_ERROR then
916: IF PG_DEBUG <> 0 THEN
917: 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);
918: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no:'|| to_char(l_stmt_num));
919: End if;
920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: cto_msg_pub.count_and_get(

Line 928: 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);

924: );
925:
926: when others then
927: IF PG_DEBUG <> 0 THEN
928: 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);
929:
930: oe_debug_pub.add('inventory_reservation_check: ' || sqlerrm);
931: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no:'||to_char(l_stmt_num) );
932: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check', sqlerrm);

Line 1054: If (CTO_WORKFLOW_API_PK.complete_activity(

1050: End if;
1051: -- Modified for MOAC project
1052: -- Called complete_acitivity procedure instead of calling wf_engine api.
1053:
1054: If (CTO_WORKFLOW_API_PK.complete_activity(
1055: p_itemtype => G_ITEM_TYPE_NAME,
1056: p_itemkey => to_char(p_order_line_id),
1057: p_activity_name => 'CREATE_SUPPLY_ORDER_ELIGIBLE',
1058: p_result_code => 'RESERVED')) Then

Line 1221: IF (CTO_WORKFLOW_API_PK.complete_activity(

1217:
1218: -- Modified for MOAC project
1219: -- Called complete_acitivity procedure instead of calling wf_engine api.
1220:
1221: IF (CTO_WORKFLOW_API_PK.complete_activity(
1222: p_itemtype => G_ITEM_TYPE_NAME,
1223: p_itemkey => to_char(p_order_line_id),
1224: p_activity_name => 'CREATE_SUPPLY_ORDER_ELIGIBLE',
1225: p_result_code => 'RESERVED')) Then

Line 1325: 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);

1321:
1322: EXCEPTION
1323: when FND_API.G_EXC_ERROR then
1324: IF PG_DEBUG <> 0 THEN
1325: 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);
1326: END IF;
1327:
1328: If PG_DEBUG <> 0 Then
1329: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',

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

1326: END IF;
1327:
1328: If PG_DEBUG <> 0 Then
1329: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',
1330: 'Exp error in CTO_WORKFLOW_API_PK.wf_update_inv_reserv::
1331: stmt no : '||to_char(l_stmt_num)||'::'||sqlerrm);
1332: End if;
1333:
1334: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1342: 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);

1338: );
1339:
1340: when FND_API.G_EXC_UNEXPECTED_ERROR then
1341: IF PG_DEBUG <> 0 THEN
1342: 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);
1343: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',
1344: 'UNExp error in CTO_WORKFLOW_API_PK.wf_update_inv_reserv::
1345: stmt no : '||to_char(l_stmt_num)||'::'||sqlerrm);
1346: End if;

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

1340: when FND_API.G_EXC_UNEXPECTED_ERROR then
1341: IF PG_DEBUG <> 0 THEN
1342: 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);
1343: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',
1344: 'UNExp error in CTO_WORKFLOW_API_PK.wf_update_inv_reserv::
1345: stmt no : '||to_char(l_stmt_num)||'::'||sqlerrm);
1346: End if;
1347:
1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1356: 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);

1352: );
1353:
1354: when others then
1355: IF PG_DEBUG <> 0 THEN
1356: 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);
1357:
1358: oe_debug_pub.add('wf_update_after_inv_reserv: ' || sqlerrm, 1);
1359: END IF;
1360: If PG_DEBUG <> 0 Then

Line 1487: 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);

1483: EXCEPTION
1484:
1485: when FND_API.G_EXC_ERROR then
1486: IF PG_DEBUG <> 0 THEN
1487: 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);
1488: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1489: 'Raised FND_API.G_EXC_ERROR, stmt'||l_stmt_num);
1490: End if;
1491: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1499: 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);

1495: );
1496:
1497: when FND_API.G_EXC_UNEXPECTED_ERROR then
1498: IF PG_DEBUG <> 0 THEN
1499: 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);
1500: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1501: 'Raised FND_API.G_EXC_UNEXPECTED_ERROR, stmt'||l_stmt_num);
1502: End if;
1503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1511: 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);

1507: );
1508:
1509: when others then
1510: IF PG_DEBUG <> 0 THEN
1511: 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);
1512:
1513: oe_debug_pub.add('inventory_unreservation_check: ' || sqlerrm, 1);
1514: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1515: 'Raised OTHERS excepn, stmt: '||l_stmt_num);

Line 1988: If (CTO_WORKFLOW_API_PK.complete_activity(

1984: -- Fix for bug 5357300
1985: -- Replaces the direct workflow engine call wf_engine.CompleteActivityInternalName
1986: -- To CTO wrapper api call. As the cto wrapper api will take care of org context switch
1987:
1988: If (CTO_WORKFLOW_API_PK.complete_activity(
1989: p_itemtype => G_ITEM_TYPE_NAME,
1990: p_itemkey => to_char(p_order_line_id),
1991: p_activity_name => 'SHIP_LINE',
1992: p_result_code => 'UNRESERVE')) Then

Line 2051: 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);

2047: EXCEPTION
2048: when FND_API.G_EXC_ERROR then
2049:
2050: IF PG_DEBUG <> 0 THEN
2051: 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);
2052: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','exp erro stmt no :'|| to_char(l_stmt_num));
2053:
2054: END IF;
2055: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2064: 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));

2060:
2061: when FND_API.G_EXC_UNEXPECTED_ERROR then
2062:
2063: IF PG_DEBUG <> 0 THEN
2064: 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));
2065: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp err stmt no:'|| to_char(l_stmt_num));
2066:
2067: END IF;
2068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2077: 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);

2073:
2074: when others then
2075:
2076: IF PG_DEBUG <> 0 THEN
2077: 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);
2078: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || sqlerrm, 1);
2079: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp errr stmt no :'|| to_char(l_stmt_num));
2080: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE',sqlerrm);
2081:

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

2174: EXCEPTION
2175:
2176: when no_data_found then
2177: IF PG_DEBUG <> 0 THEN
2178: oe_debug_pub.add('configuration_item_created: ' || 'CTO_WORKFLOW_API_PK.configuration_item_created::stmt number '||
2179: to_char(l_stmt_num)||'top model line does not exist, constraint condition is false', 1);
2180: END IF;
2181: x_result := 0;
2182:

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

2181: x_result := 0;
2182:
2183: when OTHERS then
2184: IF PG_DEBUG <> 0 THEN
2185: oe_debug_pub.add('configuration_item_created: ' || 'CTO_WORKFLOW_API_PK.configuration_item_created::stmt number '||
2186: to_char(l_stmt_num)||'constraint condition is false', 1);
2187: oe_debug_pub.add('configuration_item_created: ' || sqlerrm, 1);
2188: END IF;
2189: x_result := 0;

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

2276: EXCEPTION
2277:
2278: when no_data_found then
2279: IF PG_DEBUG <> 0 THEN
2280: oe_debug_pub.add('configuration_created: ' || 'CTO_WORKFLOW_API_PK.configuration_item_created::stmt number '||
2281: to_char(l_stmt_num)||'top model line does not exist, constraint condition is false', 1);
2282: END IF;
2283: x_result := 0;
2284:

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

2283: x_result := 0;
2284:
2285: when OTHERS then
2286: IF PG_DEBUG <> 0 THEN
2287: oe_debug_pub.add('configuration_created: ' || 'CTO_WORKFLOW_API_PK.configuration_item_created::stmt number '||
2288: to_char(l_stmt_num)||'constraint condition is false', 1);
2289: oe_debug_pub.add('configuration_created: ' || sqlerrm, 1);
2290: END IF;
2291: x_result := 0;

Line 2334: IF (CTO_WORKFLOW_API_PK.complete_activity(

2330: oe_debug_pub.add('configuration_created: ' || 'Workflow Status is: '||l_active_activity, 5);
2331: END IF;
2332: l_stmt_num := 20;
2333:
2334: IF (CTO_WORKFLOW_API_PK.complete_activity(
2335: p_itemtype => 'OEOL',
2336: p_itemkey => p_model_line_id,
2337: p_activity_name => l_active_activity,
2338: p_result_code => 'COMPLETE') <> TRUE)

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

2361: exception
2362:
2363: when PROCESS_ERROR then
2364: IF PG_DEBUG <> 0 THEN
2365: oe_debug_pub.add('configuration_created: ' || 'exp error in CTO_WORKFLOW_API_PK.start_model_workflow::stmt number '||to_char(l_stmt_num), 1);
2366: END IF;
2367: return FALSE;
2368:
2369: when OTHERS then

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

2367: return FALSE;
2368:
2369: when OTHERS then
2370: IF PG_DEBUG <> 0 THEN
2371: oe_debug_pub.add('configuration_created: ' || 'unexp error in CTO_WORKFLOW_API_PK.start_model_workflow::stmt number '||to_char(l_stmt_num), 1);
2372: oe_debug_pub.add('configuration_created: ' || sqlerrm, 1);
2373: END IF;
2374: return FALSE;
2375:

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

2448: EXCEPTION
2449:
2450: when no_data_found then
2451: IF PG_DEBUG <> 0 THEN
2452: oe_debug_pub.add('configuration_created: ' || 'CTO_WORKFLOW_API_PK.Update_Config_Line::stmt number '||to_char(l_stmt_num)||'not config item',1);
2453: END IF;
2454: x_result := 0;
2455:
2456: when OTHERS then

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

2454: x_result := 0;
2455:
2456: when OTHERS then
2457: IF PG_DEBUG <> 0 THEN
2458: oe_debug_pub.add('configuration_created: ' || 'CTO_WORKFLOW_API_PK.Update_Config_Line::stmt number '||to_char(l_stmt_num)||'others',1);
2459:
2460: oe_debug_pub.add('configuration_created: ' || sqlerrm);
2461: END IF;
2462: x_result := 0;

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

2593: EXCEPTION
2594:
2595: when no_data_found then
2596: IF PG_DEBUG <> 0 THEN
2597: oe_debug_pub.add('configuration_created_for_pto: ' || 'CTO_WORKFLOW_API_PK.configuration_created_for_pto::stmt number '||to_char(l_stmt_num),1);
2598: oe_debug_pub.add('configuration_created_for_pto: ' || 'config item does not exist, constraint condition is false', 1);
2599: END IF;
2600: x_result := 0;
2601:

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

2600: x_result := 0;
2601:
2602: when OTHERS then
2603: IF PG_DEBUG <> 0 THEN
2604: oe_debug_pub.add('configuration_created_for_pto: ' || 'CTO_WORKFLOW_API_PK.configuration_created_for_pto::stmt number '||to_char(l_stmt_num), 1);
2605: oe_debug_pub.add('configuration_created_for_pto: ' || 'constraint condition is false', 1);
2606: oe_debug_pub.add('configuration_created_for_pto: ' || sqlerrm, 1);
2607: END IF;
2608: x_result := 0;

Line 2667: 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);

2663: EXCEPTION
2664:
2665: when no_data_found then
2666: IF PG_DEBUG <> 0 THEN
2667: 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);
2668: END IF;
2669: x_result := 0;
2670:
2671: when OTHERS then

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

2669: x_result := 0;
2670:
2671: when OTHERS then
2672: IF PG_DEBUG <> 0 THEN
2673: oe_debug_pub.add('Top_Ato_Model: ' || 'CTO_WORKFLOW_API_PK.top_ato_model::stmt number '||to_char(l_stmt_num)||'others',1);
2674:
2675: oe_debug_pub.add('Top_Ato_Model: ' || sqlerrm);
2676: END IF;
2677: x_result := 0;

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

2737: EXCEPTION
2738:
2739: when no_data_found then
2740: IF PG_DEBUG <> 0 THEN
2741: oe_debug_pub.add('Config_Line: ' || 'CTO_WORKFLOW_API_PK.Config_Line::stmt number '||to_char(l_stmt_num)||'not config item',1);
2742: END IF;
2743: x_result := 0;
2744:
2745: when OTHERS then

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

2743: x_result := 0;
2744:
2745: when OTHERS then
2746: IF PG_DEBUG <> 0 THEN
2747: oe_debug_pub.add('Config_Line: ' || 'CTO_WORKFLOW_API_PK.Config_Line::stmt number '||to_char(l_stmt_num)||'others',1);
2748: oe_debug_pub.add('Config_Line: ' || sqlerrm, 1);
2749: END IF;
2750: x_result := 0;
2751:

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

2885: EXCEPTION
2886:
2887: WHEN FND_API.G_EXC_ERROR THEN
2888: IF PG_DEBUG <> 0 THEN
2889: oe_debug_pub.add('Change_Status_Batch: ' || 'exp error in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);
2890: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','exp erro change_status_batch :: '||l_stmt_num||sqlerrm);
2891:
2892: END IF;
2893: x_return_status := FND_API.G_RET_STS_ERROR;

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

2893: x_return_status := FND_API.G_RET_STS_ERROR;
2894:
2895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2896: IF PG_DEBUG <> 0 THEN
2897: oe_debug_pub.add('Change_Status_Batch: ' || 'unexp error in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);
2898: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','Unexp err change_status_batch :: '||l_stmt_num||sqlerrm);
2899: End if;
2900:
2901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2902:
2903: WHEN OTHERS THEN
2904: IF PG_DEBUG <> 0 THEN
2905: oe_debug_pub.add('Change_Status_Batch: ' || 'unexp error (others) in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);
2906: oe_debug_pub.add('Change_Status_Batch: ' || sqlerrm, 1);
2907: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','Unexp err change_status_batch :: '||l_stmt_num||sqlerrm);
2908:
2909: END IF;

Line 3281: 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);

3277: EXCEPTION
3278:
3279: when no_data_found then
3280: IF PG_DEBUG <> 0 THEN
3281: 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);
3282: END IF;
3283: x_result := 0;
3284:
3285: when OTHERS then

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

3283: x_result := 0;
3284:
3285: when OTHERS then
3286: IF PG_DEBUG <> 0 THEN
3287: oe_debug_pub.add('chk_Buy_Ato_Item: ' || 'CTO_WORKFLOW_API_PK.Config_Line::stmt number '||to_char(l_stmt_num)||'others',1);
3288:
3289: oe_debug_pub.add('chk_Buy_Ato_Item: ' || sqlerrm);
3290: END IF;
3291: x_result := 0;

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

3448: exception
3449: when no_data_found then
3450: x_result := 0 ;
3451: IF PG_DEBUG <> 0 THEN
3452: oe_debug_pub.add('CTO_WORKFLOW_API_PK: ' || 'reservation exists::'|| ' NO DATA FOUND EXCEPTION ' || l_stmt_num , 2);
3453: END IF;
3454: when others then
3455:
3456: x_result := 0 ;

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

3454: when others then
3455:
3456: x_result := 0 ;
3457: IF PG_DEBUG <> 0 THEN
3458: oe_debug_pub.add('CTO_WORKFLOW_API_PK: ' || 'reservation exists::'|| ' OTHERS EXCEPTION ' || l_stmt_num , 2);
3459: END IF;
3460:
3461: end reservation_exists ;
3462:

Line 3770: END CTO_WORKFLOW_API_PK;

3766: End get_status_tokens;
3767:
3768:
3769:
3770: END CTO_WORKFLOW_API_PK;