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 FND_API

Line 420: raise FND_API.G_EXC_ERROR;

416:
417: l_stmt_num := 105;
418: IF (validate_line(to_number(p_itemkey)) <> TRUE) THEN
419: cto_msg_pub.cto_message('BOM','CTO_LINE_STATUS_NOT_ELIGIBLE');
420: raise FND_API.G_EXC_ERROR;
421: END IF;
422:
423: l_stmt_num := 110;
424:

Line 440: IF (l_x_hold_return_status = FND_API.G_RET_STS_ERROR) THEN

436: x_return_status => l_x_hold_return_status,
437: x_msg_count => l_x_error_msg_count,
438: x_msg_data => l_x_error_msg);
439:
440: IF (l_x_hold_return_status = FND_API.G_RET_STS_ERROR) THEN
441: IF PG_DEBUG <> 0 THEN
442: oe_debug_pub.add('create_config_item_wf: ' || 'Failed in Check Holds with expected error.' ,1);
443: END IF;
444: raise FND_API.G_EXC_ERROR;

Line 444: raise FND_API.G_EXC_ERROR;

440: IF (l_x_hold_return_status = FND_API.G_RET_STS_ERROR) THEN
441: IF PG_DEBUG <> 0 THEN
442: oe_debug_pub.add('create_config_item_wf: ' || 'Failed in Check Holds with expected error.' ,1);
443: END IF;
444: raise FND_API.G_EXC_ERROR;
445:
446: ELSIF (l_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
447: IF PG_DEBUG <> 0 THEN
448: oe_debug_pub.add('create_config_item_wf: ' || 'Failed in Check Holds with unexpected error.' ,1);

Line 446: ELSIF (l_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

442: oe_debug_pub.add('create_config_item_wf: ' || 'Failed in Check Holds with expected error.' ,1);
443: END IF;
444: raise FND_API.G_EXC_ERROR;
445:
446: ELSIF (l_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
447: IF PG_DEBUG <> 0 THEN
448: oe_debug_pub.add('create_config_item_wf: ' || 'Failed in Check Holds with unexpected error.' ,1);
449: END IF;
450: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 450: raise FND_API.G_EXC_UNEXPECTED_ERROR;

446: ELSIF (l_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
447: IF PG_DEBUG <> 0 THEN
448: oe_debug_pub.add('create_config_item_wf: ' || 'Failed in Check Holds with unexpected error.' ,1);
449: END IF;
450: raise FND_API.G_EXC_UNEXPECTED_ERROR;
451:
452: ELSE
453: IF PG_DEBUG <> 0 THEN
454: oe_debug_pub.add('create_config_item_wf: ' || 'Success in Check Holds. ' || l_x_hold_return_status,1);

Line 456: IF (l_x_hold_result_out = FND_API.G_TRUE) THEN

452: ELSE
453: IF PG_DEBUG <> 0 THEN
454: oe_debug_pub.add('create_config_item_wf: ' || 'Success in Check Holds. ' || l_x_hold_return_status,1);
455: END IF;
456: IF (l_x_hold_result_out = FND_API.G_TRUE) THEN
457: IF PG_DEBUG <> 0 THEN
458: oe_debug_pub.add('create_config_item_wf: ' || 'Order Line ID ' || p_itemkey ||
459: 'is on HOLD. ' ||l_x_hold_result_out);
460: END IF;

Line 601: if (l_status = 0 and l_xReturnStatus = FND_API.G_RET_STS_ERROR ) then

597:
598:
599: oe_debug_pub.add('create_config_item_wf: ' || 'done create and link Item .');
600:
601: if (l_status = 0 and l_xReturnStatus = FND_API.G_RET_STS_ERROR ) then
602: IF PG_DEBUG <> 0 THEN
603: oe_debug_pub.add('create_config_item_wf: ' || 'Failed in Create and Link Item with expected error.');
604: END IF;
605:

Line 634: raise FND_API.G_EXC_ERROR;

630:
631:
632:
633:
634: raise FND_API.G_EXC_ERROR;
635:
636: elsif (l_status = 0 and l_xReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR ) then
637: IF PG_DEBUG <> 0 THEN
638: oe_debug_pub.add('create_config_item_wf: ' || 'Failed in Create and Link Item with unexpected error.');

Line 636: elsif (l_status = 0 and l_xReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR ) then

632:
633:
634: raise FND_API.G_EXC_ERROR;
635:
636: elsif (l_status = 0 and l_xReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR ) then
637: IF PG_DEBUG <> 0 THEN
638: oe_debug_pub.add('create_config_item_wf: ' || 'Failed in Create and Link Item with unexpected error.');
639: END IF;
640: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 640: raise FND_API.G_EXC_UNEXPECTED_ERROR;

636: elsif (l_status = 0 and l_xReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR ) then
637: IF PG_DEBUG <> 0 THEN
638: oe_debug_pub.add('create_config_item_wf: ' || 'Failed in Create and Link Item with unexpected error.');
639: END IF;
640: raise FND_API.G_EXC_UNEXPECTED_ERROR;
641:
642: else
643: IF PG_DEBUG <> 0 THEN
644: oe_debug_pub.add('create_config_item_wf: ' || 'Success in Create And Link Item.', 1);

Line 664: if l_xReturnStatus <> fnd_api.G_RET_STS_SUCCESS then

660: oe_debug_pub.add('create_config_item_wf: About to generate bom batch ID', 5);
661: end if;
662:
663: cto_msutil_pub.set_bom_batch_id(x_return_status => l_xReturnStatus);
664: if l_xReturnStatus <> fnd_api.G_RET_STS_SUCCESS then
665: IF PG_DEBUG <> 0 THEN
666: oe_debug_pub.add('create_config_item_wf: ' || 'Failed in set_bom_batch_id with unexp error.', 1);
667: END IF;
668: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 668: raise FND_API.G_EXC_UNEXPECTED_ERROR;

664: if l_xReturnStatus <> fnd_api.G_RET_STS_SUCCESS then
665: IF PG_DEBUG <> 0 THEN
666: oe_debug_pub.add('create_config_item_wf: ' || 'Failed in set_bom_batch_id with unexp error.', 1);
667: END IF;
668: raise FND_API.G_EXC_UNEXPECTED_ERROR;
669: end if;
670:
671:
672: oe_debug_pub.add('create_config_item_wf: ' || ' resetting CTO_CONFIG_BOM_PK.g_t_dropped_item_type ' , 1 );

Line 730: IF (l_xReturnStatus = fnd_api.G_RET_STS_ERROR) THEN

726:
727:
728:
729:
730: IF (l_xReturnStatus = fnd_api.G_RET_STS_ERROR) THEN
731: IF PG_DEBUG <> 0 THEN
732: oe_debug_pub.add('create_config_item_wf: ' || 'Failed in Create BOM and Routing with exp error.', 1);
733: END IF;
734:

Line 785: raise FND_API.G_EXC_ERROR;

781: end if; /* lNotifyUsers */
782:
783:
784:
785: raise FND_API.G_EXC_ERROR;
786:
787:
788:
789:

Line 790: ELSIF (l_xReturnStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN

786:
787:
788:
789:
790: ELSIF (l_xReturnStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
791: IF PG_DEBUG <> 0 THEN
792: oe_debug_pub.add('create_config_item_wf: ' || 'Failed in Create BOM and Routing with unexp error.', 1);
793: END IF;
794: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 794: raise FND_API.G_EXC_UNEXPECTED_ERROR;

790: ELSIF (l_xReturnStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
791: IF PG_DEBUG <> 0 THEN
792: oe_debug_pub.add('create_config_item_wf: ' || 'Failed in Create BOM and Routing with unexp error.', 1);
793: END IF;
794: raise FND_API.G_EXC_UNEXPECTED_ERROR;
795: ELSE
796: IF PG_DEBUG <> 0 THEN
797: oe_debug_pub.add('create_config_item_wf: ' || 'Success in Create BOM and Routing ', 1);
798: END IF;

Line 869: raise FND_API.G_EXC_ERROR;

865:
866: end if; /* lNotifyUsers */
867:
868:
869: raise FND_API.G_EXC_ERROR;
870: end if;
871:
872: IF PG_DEBUG <> 0 THEN
873: oe_debug_pub.add ('create_config_item_wf: ' || 'Success in link_item function', 1);

Line 1043: IF (x_Return_Status = fnd_api.G_RET_STS_ERROR) THEN

1039:
1040:
1041:
1042:
1043: IF (x_Return_Status = fnd_api.G_RET_STS_ERROR) THEN
1044: IF PG_DEBUG <> 0 THEN
1045: oe_debug_pub.add('create_config_item_wf: ' || 'Failed in Purchase Price ROLLUP .', 1);
1046: END IF;
1047:

Line 1079: raise FND_API.G_EXC_ERROR;

1075:
1076:
1077:
1078:
1079: raise FND_API.G_EXC_ERROR;
1080:
1081:
1082:
1083:

Line 1084: ELSIF ( x_Return_Status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN

1080:
1081:
1082:
1083:
1084: ELSIF ( x_Return_Status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
1085: IF PG_DEBUG <> 0 THEN
1086: oe_debug_pub.add('create_config_item_wf: ' || 'Failed in Purchase Price ROllup .', 1);
1087: END IF;
1088:

Line 1089: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1085: IF PG_DEBUG <> 0 THEN
1086: oe_debug_pub.add('create_config_item_wf: ' || 'Failed in Purchase Price ROllup .', 1);
1087: END IF;
1088:
1089: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1090: ELSE
1091: IF PG_DEBUG <> 0 THEN
1092: oe_debug_pub.add('create_config_item_wf: ' || 'Success in Purchase Price Rollup ', 1);
1093: END IF;

Line 1132: raise FND_API.G_EXC_ERROR;

1128: IF PG_DEBUG <> 0 THEN
1129: oe_debug_pub.add('create_config_item_wf: ' || 'Failure in cost_rollup ', 1);
1130: END IF;
1131: --cto_msg_pub.cto_message('BOM', l_xmsgdata);
1132: raise FND_API.G_EXC_ERROR;
1133:
1134:
1135: elsif( l_status = -1 ) then
1136: IF PG_DEBUG <> 0 THEN

Line 1140: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1136: IF PG_DEBUG <> 0 THEN
1137: oe_debug_pub.add('create_config_item_wf: ' || 'Unexpected Failure in cost_rollup ', 1);
1138: END IF;
1139: cto_msg_pub.cto_message('BOM', l_xmsgdata);
1140: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1141:
1142: else
1143: IF PG_DEBUG <> 0 THEN
1144: oe_debug_pub.add('create_config_item_wf: ' || 'Success in cost_rollup ', 1);

Line 1241: if( x_return_status = FND_API.G_RET_STS_SUCCESS ) then

1237:
1238: -- Complete the block activity in the config flow
1239: l_stmt_num := 170;
1240:
1241: if( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1242:
1243:
1244: IF PG_DEBUG <> 0 THEN
1245: oe_debug_pub.add('create_config_item_wf: ' || 'Time Stamp ' || to_char( sysdate , 'dd-mon-yyyy hh24:mi:ss' ));

Line 1398: when FND_API.G_EXC_ERROR then

1394:
1395:
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);

Line 1410: when FND_API.G_EXC_UNEXPECTED_ERROR then

1406: OE_STANDARD_WF.Clear_Msg_Context;
1407: x_result := 'COMPLETE:INCOMPLETE';
1408: rollback to savepoint before_item_creation;
1409:
1410: when FND_API.G_EXC_UNEXPECTED_ERROR then
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);

Line 1507: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1503: /*
1504: ** Check whether full match was successful for top model to create reservations
1505: */
1506:
1507: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1508: x_reserve_status := 'MATCH' ;
1509:
1510:
1511: /*

Line 1565: , p_init_msg_lst => fnd_api.g_false

1561: l_stmt_num := 150;
1562:
1563: INV_QUANTITY_TREE_GRP.create_tree
1564: ( p_api_version_number => 1.0
1565: , p_init_msg_lst => fnd_api.g_false
1566: , x_return_status => l_return_status
1567: , x_msg_count => x_msg_count
1568: , x_msg_data => x_msg_data
1569: , p_organization_id => p_mfg_org_id

Line 1577: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1573: , p_is_lot_control => FALSE
1574: , p_is_serial_control => FALSE
1575: , x_tree_id => l_tree_id);
1576:
1577: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1578: IF PG_DEBUG <> 0 THEN
1579: oe_debug_pub.add('create_reservation: ' || 'Failed in create_tree with status: ' ||
1580: l_return_status, 1);
1581: END IF;

Line 1598: p_init_msg_lst => fnd_api.g_false,

1594: l_stmt_num := 160;
1595:
1596: INV_QUANTITY_TREE_GRP.query_tree
1597: (p_api_version_number => 1.0,
1598: p_init_msg_lst => fnd_api.g_false,
1599: x_return_status => l_return_status,
1600: x_msg_count => x_msg_count,
1601: x_msg_data => x_msg_data,
1602: p_tree_id => l_tree_id,

Line 1614: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1610: x_qs => l_x_qs,
1611: x_att => l_x_att,
1612: x_atr => x_available_qty);
1613:
1614: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1615: IF PG_DEBUG <> 0 THEN
1616: oe_debug_pub.add('create_reservation: ' || 'Failed in create_tree with status: ' ||
1617: l_return_status, 1);
1618: END IF;

Line 1974: x_return_status := FND_API.G_RET_STS_ERROR ;

1970: END IF;
1971: OE_STANDARD_WF.Save_Messages;
1972: OE_STANDARD_WF.Clear_Msg_Context;
1973:
1974: x_return_status := FND_API.G_RET_STS_ERROR ;
1975:
1976:
1977: when NO_DATA_FOUND then
1978: --rollback to savepoint before_item_creation;

Line 1983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1996: x_return_status := FND_API.G_RET_STS_ERROR ;

1992:
1993: OE_STANDARD_WF.Save_Messages;
1994: OE_STANDARD_WF.Clear_Msg_Context;
1995:
1996: x_return_status := FND_API.G_RET_STS_ERROR ;
1997:
1998: when FND_API.G_EXC_UNEXPECTED_ERROR then
1999: --rollback to savepoint before_item_creation;
2000: IF PG_DEBUG <> 0 THEN

Line 1998: when FND_API.G_EXC_UNEXPECTED_ERROR then

1994: OE_STANDARD_WF.Clear_Msg_Context;
1995:
1996: x_return_status := FND_API.G_RET_STS_ERROR ;
1997:
1998: when FND_API.G_EXC_UNEXPECTED_ERROR then
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) || ':' ||

Line 2008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2004: END IF;
2005: OE_STANDARD_WF.Save_Messages;
2006: OE_STANDARD_WF.Clear_Msg_Context;
2007:
2008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2009:
2010: when OTHERS then
2011: --rollback to savepoint before_item_creation;
2012: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_ITEM_ERROR');

Line 2018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
2019:
2020:
2021: END CREATE_RESERVATION ;
2022:

Line 2127: IF (l_x_hold_return_status = FND_API.G_RET_STS_ERROR) THEN

2123: ,x_return_status => l_x_hold_return_status
2124: ,x_msg_count => l_x_error_msg_count
2125: ,x_msg_data => l_x_error_msg);
2126:
2127: IF (l_x_hold_return_status = FND_API.G_RET_STS_ERROR) THEN
2128: IF PG_DEBUG <> 0 THEN
2129: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with expected error.' ,1);
2130: END IF;
2131: raise FND_API.G_EXC_ERROR;

Line 2131: raise FND_API.G_EXC_ERROR;

2127: IF (l_x_hold_return_status = FND_API.G_RET_STS_ERROR) THEN
2128: IF PG_DEBUG <> 0 THEN
2129: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with expected error.' ,1);
2130: END IF;
2131: raise FND_API.G_EXC_ERROR;
2132:
2133: ELSIF (l_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2134: IF PG_DEBUG <> 0 THEN
2135: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with unexpected error.' ,1);

Line 2133: ELSIF (l_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2129: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with expected error.' ,1);
2130: END IF;
2131: raise FND_API.G_EXC_ERROR;
2132:
2133: ELSIF (l_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2134: IF PG_DEBUG <> 0 THEN
2135: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with unexpected error.' ,1);
2136: END IF;
2137: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2137: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2133: ELSIF (l_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2134: IF PG_DEBUG <> 0 THEN
2135: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with unexpected error.' ,1);
2136: END IF;
2137: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2138:
2139: ELSE
2140: IF PG_DEBUG <> 0 THEN
2141: oe_debug_pub.add('CTOCITMB:Success in Check Holds.' ,1);

Line 2144: if l_x_hold_result_out = FND_API.G_TRUE then

2140: IF PG_DEBUG <> 0 THEN
2141: oe_debug_pub.add('CTOCITMB:Success in Check Holds.' ,1);
2142: END IF;
2143:
2144: if l_x_hold_result_out = FND_API.G_TRUE then
2145: IF PG_DEBUG <> 0 THEN
2146: oe_debug_pub.add('CTOCITMB:Create Supply Activity Hold exists on Config Line .' ,1);
2147: END IF;
2148:

Line 2170: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

2166: ,x_return_status => l_x_hold_return_status
2167: ,x_msg_count => l_x_error_msg_count
2168: ,x_msg_data => l_x_error_msg);
2169:
2170: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2171: IF PG_DEBUG <> 0 THEN
2172: oe_debug_pub.add('CTOCITMB:Failed in Release Holds with expected error.' ,1);
2173: END IF;
2174: raise FND_API.G_EXC_ERROR;

Line 2174: raise FND_API.G_EXC_ERROR;

2170: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2171: IF PG_DEBUG <> 0 THEN
2172: oe_debug_pub.add('CTOCITMB:Failed in Release Holds with expected error.' ,1);
2173: END IF;
2174: raise FND_API.G_EXC_ERROR;
2175:
2176: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2177: IF PG_DEBUG <> 0 THEN
2178: oe_debug_pub.add('CTOCITMB:Failed in Release Holds with unexpected error.' ,1);

Line 2176: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2172: oe_debug_pub.add('CTOCITMB:Failed in Release Holds with expected error.' ,1);
2173: END IF;
2174: raise FND_API.G_EXC_ERROR;
2175:
2176: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2177: IF PG_DEBUG <> 0 THEN
2178: oe_debug_pub.add('CTOCITMB:Failed in Release Holds with unexpected error.' ,1);
2179: END IF;
2180: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2180: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2176: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2177: IF PG_DEBUG <> 0 THEN
2178: oe_debug_pub.add('CTOCITMB:Failed in Release Holds with unexpected error.' ,1);
2179: END IF;
2180: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2181: END IF;
2182:
2183: IF PG_DEBUG <> 0 THEN
2184: oe_debug_pub.add('CTOCITMB: Hold Released on config line.' ,1);

Line 2207: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

2203: , x_return_status => l_return_status
2204: , x_msg_count => l_msg_count
2205: , x_msg_data => l_msg_data);
2206:
2207: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2208: IF PG_DEBUG <> 0 THEN
2209: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with expected error.' ,1);
2210: END IF;
2211: raise FND_API.G_EXC_ERROR;

Line 2211: raise FND_API.G_EXC_ERROR;

2207: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2208: IF PG_DEBUG <> 0 THEN
2209: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with expected error.' ,1);
2210: END IF;
2211: raise FND_API.G_EXC_ERROR;
2212:
2213: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2214: IF PG_DEBUG <> 0 THEN
2215: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with unexpected error.' ,1);

Line 2213: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2209: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with expected error.' ,1);
2210: END IF;
2211: raise FND_API.G_EXC_ERROR;
2212:
2213: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2214: IF PG_DEBUG <> 0 THEN
2215: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with unexpected error.' ,1);
2216: END IF;
2217: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2217: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2213: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2214: IF PG_DEBUG <> 0 THEN
2215: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with unexpected error.' ,1);
2216: END IF;
2217: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2218: END IF;
2219:
2220: IF PG_DEBUG <> 0 THEN
2221: oe_debug_pub.add('CTOCITMB: An Exception Hold applied to config line.' ,1);

Line 2274: if ((l_ResultStatus=TRUE) and (l_return_status=FND_API.G_RET_STS_SUCCESS)) then

2270: l_msg_data,
2271: l_return_status);
2272: -- Bugfix 3075105 end
2273:
2274: if ((l_ResultStatus=TRUE) and (l_return_status=FND_API.G_RET_STS_SUCCESS)) then
2275:
2276: IF PG_DEBUG <> 0 THEN
2277: oe_debug_pub.add('rsv_before_booking_wf: ' || 'Reservation exists, completing flow with reserved', 2);
2278: END IF;

Line 2290: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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;
2291: end if;
2292:
2293: elsif ((l_ResultStatus=FALSE) and (l_return_status=FND_API.G_RET_STS_SUCCESS)) then
2294: IF PG_DEBUG <> 0 THEN

Line 2293: elsif ((l_ResultStatus=FALSE) and (l_return_status=FND_API.G_RET_STS_SUCCESS)) then

2289: cto_msg_pub.cto_message('CTO', 'CTO_ERROR_FROM_DISPLAY_STATUS');
2290: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2291: end if;
2292:
2293: elsif ((l_ResultStatus=FALSE) and (l_return_status=FND_API.G_RET_STS_SUCCESS)) then
2294: IF PG_DEBUG <> 0 THEN
2295: oe_debug_pub.add('rsv_before_booking_wf: ' || 'Reservation does not exist, completing flow with complete.', 2);
2296: END IF;
2297: x_result :='COMPLETE';

Line 2299: elsif(l_return_status=FND_API.G_RET_STS_ERROR) then

2295: oe_debug_pub.add('rsv_before_booking_wf: ' || 'Reservation does not exist, completing flow with complete.', 2);
2296: END IF;
2297: x_result :='COMPLETE';
2298:
2299: elsif(l_return_status=FND_API.G_RET_STS_ERROR) then
2300: IF PG_DEBUG <> 0 THEN
2301: oe_debug_pub.add('rsv_before_booking_wf: ' || 'returning from check_rsv_exists with expected error.', 2);
2302: END IF;
2303: RAISE FND_API.G_EXC_ERROR;

Line 2303: RAISE FND_API.G_EXC_ERROR;

2299: elsif(l_return_status=FND_API.G_RET_STS_ERROR) then
2300: IF PG_DEBUG <> 0 THEN
2301: oe_debug_pub.add('rsv_before_booking_wf: ' || 'returning from check_rsv_exists with expected error.', 2);
2302: END IF;
2303: RAISE FND_API.G_EXC_ERROR;
2304:
2305: elsif(l_return_status=FND_API.G_RET_STS_UNEXP_ERROR) then
2306: IF PG_DEBUG <> 0 THEN
2307: oe_debug_pub.add('rsv_before_booking_wf: ' || 'returning from check_rsv_exists with unexpected error.', 2);

Line 2305: elsif(l_return_status=FND_API.G_RET_STS_UNEXP_ERROR) then

2301: oe_debug_pub.add('rsv_before_booking_wf: ' || 'returning from check_rsv_exists with expected error.', 2);
2302: END IF;
2303: RAISE FND_API.G_EXC_ERROR;
2304:
2305: elsif(l_return_status=FND_API.G_RET_STS_UNEXP_ERROR) then
2306: IF PG_DEBUG <> 0 THEN
2307: oe_debug_pub.add('rsv_before_booking_wf: ' || 'returning from check_rsv_exists with unexpected error.', 2);
2308: END IF;
2309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2305: elsif(l_return_status=FND_API.G_RET_STS_UNEXP_ERROR) then
2306: IF PG_DEBUG <> 0 THEN
2307: oe_debug_pub.add('rsv_before_booking_wf: ' || 'returning from check_rsv_exists with unexpected error.', 2);
2308: END IF;
2309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2310:
2311: end if;
2312: --start bug#1861812
2313:

Line 2328: when FND_API.G_EXC_ERROR then

2324: OE_STANDARD_WF.Save_Messages;
2325: OE_STANDARD_WF.Clear_Msg_Context;
2326:
2327: EXCEPTION
2328: when FND_API.G_EXC_ERROR then
2329: IF PG_DEBUG <> 0 THEN
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;

Line 2336: when FND_API.G_EXC_UNEXPECTED_ERROR then

2332: OE_STANDARD_WF.Save_Messages;
2333: OE_STANDARD_WF.Clear_Msg_Context;
2334: raise; -- can be re-tried
2335:
2336: when FND_API.G_EXC_UNEXPECTED_ERROR then
2337: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2338: FND_MSG_PUB.Add_Exc_Msg
2339: (G_PKG_NAME
2340: ,'rsv_before_booking_wf'

Line 2428: x_return_status := FND_API.G_RET_STS_SUCCESS;

2424: IF PG_DEBUG <> 0 THEN
2425: oe_debug_pub.add ('check_inv_rsv_exists: ' || 'found that reservation exists before booking', 1);
2426: END IF;
2427: x_ResultStatus := TRUE;
2428: x_return_status := FND_API.G_RET_STS_SUCCESS;
2429:
2430: EXCEPTION
2431:
2432: when no_data_found then

Line 2434: x_return_status := FND_API.G_RET_STS_SUCCESS;

2430: EXCEPTION
2431:
2432: when no_data_found then
2433: x_ResultStatus := FALSE;
2434: x_return_status := FND_API.G_RET_STS_SUCCESS;
2435: IF PG_DEBUG <> 0 THEN
2436: oe_debug_pub.add ('check_inv_rsv_exists: ' || 'no reservations before booking, this is not an error', 1);
2437: END IF;
2438:

Line 2440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2436: oe_debug_pub.add ('check_inv_rsv_exists: ' || 'no reservations before booking, this is not an error', 1);
2437: END IF;
2438:
2439: when others then
2440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2441: IF PG_DEBUG <> 0 THEN
2442: oe_debug_pub.add ('check_inv_rsv_exists: ' || 'unexpected error in called program check_inv_rsv_exists'|| sqlerrm , 1);
2443: END IF;
2444: if fnd_msg_pub.check_msg_level

Line 2522: x_return_status := FND_API.G_RET_STS_SUCCESS;

2518: and demand_source_line = to_char(pLineId)
2519: and status <> 2; -- Flow Schedule status : 1 = Open 2 = Closed/Completed
2520: else
2521: x_ResultStatus := TRUE;
2522: x_return_status := FND_API.G_RET_STS_SUCCESS;
2523: IF PG_DEBUG <> 0 THEN
2524: oe_debug_pub.add ('check_rsv_exists: ' || 'MTL reservation exists before booking', 1);
2525: END IF;
2526: return;

Line 2531: x_return_status := FND_API.G_RET_STS_SUCCESS;

2527: end if;
2528:
2529: if lFloCount > 0 then
2530: x_ResultStatus := TRUE;
2531: x_return_status := FND_API.G_RET_STS_SUCCESS;
2532: IF PG_DEBUG <> 0 THEN
2533: oe_debug_pub.add ('check_rsv_exists: ' || 'FLOW reservation exists before booking', 1);
2534: END IF;
2535: else

Line 2537: x_return_status := FND_API.G_RET_STS_SUCCESS;

2533: oe_debug_pub.add ('check_rsv_exists: ' || 'FLOW reservation exists before booking', 1);
2534: END IF;
2535: else
2536: x_ResultStatus := FALSE;
2537: x_return_status := FND_API.G_RET_STS_SUCCESS;
2538: IF PG_DEBUG <> 0 THEN
2539: oe_debug_pub.add ('check_rsv_exists: ' || 'NO reservations before booking, this is not an error', 1);
2540: END IF;
2541: end if;

Line 2547: x_return_status := FND_API.G_RET_STS_SUCCESS;

2543: EXCEPTION
2544:
2545: when no_data_found then
2546: x_ResultStatus := FALSE;
2547: x_return_status := FND_API.G_RET_STS_SUCCESS;
2548: IF PG_DEBUG <> 0 THEN
2549: oe_debug_pub.add ('check_rsv_exists: ' || 'no reservations before booking, this is not an error', 1);
2550: END IF;
2551:

Line 2553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2549: oe_debug_pub.add ('check_rsv_exists: ' || 'no reservations before booking, this is not an error', 1);
2550: END IF;
2551:
2552: when others then
2553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2554: IF PG_DEBUG <> 0 THEN
2555: oe_debug_pub.add ('check_rsv_exists: ' || 'unexpected error in called program check_inv_rsv_exists'|| sqlerrm , 1);
2556: END IF;
2557: if fnd_msg_pub.check_msg_level

Line 3071: IF (v_x_hold_return_status = FND_API.G_RET_STS_ERROR) THEN

3067: x_return_status => v_x_hold_return_status,
3068: x_msg_count => v_x_error_msg_count,
3069: x_msg_data => v_x_error_msg);
3070:
3071: IF (v_x_hold_return_status = FND_API.G_RET_STS_ERROR) THEN
3072: IF PG_DEBUG <> 0 THEN
3073: oe_debug_pub.add('Check_supply_type_wf: ' || 'Expected error in Check Hold: ' || v_x_hold_return_status, 1);
3074: END IF;
3075: RAISE FND_API.G_EXC_ERROR;

Line 3075: RAISE FND_API.G_EXC_ERROR;

3071: IF (v_x_hold_return_status = FND_API.G_RET_STS_ERROR) THEN
3072: IF PG_DEBUG <> 0 THEN
3073: oe_debug_pub.add('Check_supply_type_wf: ' || 'Expected error in Check Hold: ' || v_x_hold_return_status, 1);
3074: END IF;
3075: RAISE FND_API.G_EXC_ERROR;
3076:
3077: ELSIF (v_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3078: IF PG_DEBUG <> 0 THEN
3079: oe_debug_pub.add('Check_supply_type_wf: ' || 'Unexp error in Check Hold ' || v_x_hold_return_status, 1);

Line 3077: ELSIF (v_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3073: oe_debug_pub.add('Check_supply_type_wf: ' || 'Expected error in Check Hold: ' || v_x_hold_return_status, 1);
3074: END IF;
3075: RAISE FND_API.G_EXC_ERROR;
3076:
3077: ELSIF (v_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3078: IF PG_DEBUG <> 0 THEN
3079: oe_debug_pub.add('Check_supply_type_wf: ' || 'Unexp error in Check Hold ' || v_x_hold_return_status, 1);
3080: END IF;
3081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3077: ELSIF (v_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3078: IF PG_DEBUG <> 0 THEN
3079: oe_debug_pub.add('Check_supply_type_wf: ' || 'Unexp error in Check Hold ' || v_x_hold_return_status, 1);
3080: END IF;
3081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3082:
3083: ELSE
3084: IF PG_DEBUG <> 0 THEN
3085: oe_debug_pub.add('Check_supply_type_wf: ' || 'Success in Check Hold ' || v_x_hold_return_status, 5);

Line 3088: IF (v_x_hold_result_out = FND_API.G_TRUE) THEN

3084: IF PG_DEBUG <> 0 THEN
3085: oe_debug_pub.add('Check_supply_type_wf: ' || 'Success in Check Hold ' || v_x_hold_return_status, 5);
3086: END IF;
3087:
3088: IF (v_x_hold_result_out = FND_API.G_TRUE) THEN
3089: IF PG_DEBUG <> 0 THEN
3090: oe_debug_pub.add('Check_supply_type_wf: ' || 'Order Line ID ' || p_itemkey || 'is on HOLD. ' ||v_x_hold_result_out, 1);
3091: END IF;
3092: cto_msg_pub.cto_message('BOM', 'CTO_ORDER_LINE_ON_HOLD');

Line 3142: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3138: x_sourcing_org => l_sourcing_org,
3139: x_message => l_message
3140: );
3141:
3142: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3143: IF PG_DEBUG <> 0 THEN
3144: oe_debug_pub.add('check_supply_type_wf: ' ||
3145: 'Expected Error in check_cto_can_create_supply.',1);
3146: END IF;

Line 3147: raise FND_API.G_EXC_ERROR;

3143: IF PG_DEBUG <> 0 THEN
3144: oe_debug_pub.add('check_supply_type_wf: ' ||
3145: 'Expected Error in check_cto_can_create_supply.',1);
3146: END IF;
3147: raise FND_API.G_EXC_ERROR;
3148:
3149: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3150: IF PG_DEBUG <> 0 THEN
3151: oe_debug_pub.add('check_supply_type_wf: ' ||

Line 3149: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3145: 'Expected Error in check_cto_can_create_supply.',1);
3146: END IF;
3147: raise FND_API.G_EXC_ERROR;
3148:
3149: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3150: IF PG_DEBUG <> 0 THEN
3151: oe_debug_pub.add('check_supply_type_wf: ' ||
3152: 'Unexpected Error in check_cto_can_create_supply.',1);
3153: END IF;

Line 3154: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3150: IF PG_DEBUG <> 0 THEN
3151: oe_debug_pub.add('check_supply_type_wf: ' ||
3152: 'Unexpected Error in check_cto_can_create_supply.',1);
3153: END IF;
3154: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3155:
3156: END IF;
3157:
3158: l_stmt_num := 210;

Line 3200: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3196:
3197: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'call to display_wf_status failed.');
3198: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'l_ret_stat=> '||l_ret_stat);
3199:
3200: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3201: END IF;
3202: END IF;
3203:
3204: --end bugfix 4556596

Line 3273: when FND_API.G_EXC_ERROR then

3269: OE_STANDARD_WF.Clear_Msg_Context;
3270:
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;

Line 3283: when FND_API.G_EXC_UNEXPECTED_ERROR then

3279: OE_STANDARD_WF.Clear_Msg_Context;
3280: x_result := 'COMPLETE:INCOMPLETE';
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;

Line 3362: raise FND_API.G_EXC_ERROR;

3358: if a hold is found.
3359: +-----------------------------------------------------------*/
3360: if (validate_config_line(to_number(p_itemkey)) <> TRUE) then
3361: cto_msg_pub.cto_message('BOM','CTO_LINE_STATUS_NOT_ELIGIBLE');
3362: raise FND_API.G_EXC_ERROR;
3363: end if;
3364:
3365: --bugfix 1799874 start
3366: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => to_number(p_itemkey) );

Line 3397: raise FND_API.G_EXC_ERROR;

3393: IF PG_DEBUG <> 0 THEN
3394: oe_debug_pub.add('create_flow_schedule_wf: ' || 'l_quantity <= 0', 1);
3395: END IF;
3396: cto_msg_pub.cto_message('BOM','CTO_CREATE_FLOW_SCHED_ERROR');
3397: raise FND_API.G_EXC_ERROR;
3398: end if;
3399:
3400: l_stmt_num := 120;
3401: -- Removed check hold API call from here as we are going to check for

Line 3436: IF (l_x_return_status = FND_API.G_RET_STS_ERROR) THEN

3432: x_msg_txt => l_msg_txt);
3433:
3434:
3435:
3436: IF (l_x_return_status = FND_API.G_RET_STS_ERROR) THEN
3437: IF PG_DEBUG <> 0 THEN
3438: oe_debug_pub.add('create_flow_schedule_wf: ' || 'Expected error in cto_fs. ', 1);
3439: END IF;
3440: cto_msg_pub.cto_message('BOM', l_msg_name);

Line 3441: raise FND_API.G_EXC_ERROR;

3437: IF PG_DEBUG <> 0 THEN
3438: oe_debug_pub.add('create_flow_schedule_wf: ' || 'Expected error in cto_fs. ', 1);
3439: END IF;
3440: cto_msg_pub.cto_message('BOM', l_msg_name);
3441: raise FND_API.G_EXC_ERROR;
3442:
3443: ELSIF (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3444: IF PG_DEBUG <> 0 THEN
3445: oe_debug_pub.add('create_flow_schedule_wf: ' || 'Unexpected error in Create Flow Schedule for line id ' || p_itemkey, 1);

Line 3443: ELSIF (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3439: END IF;
3440: cto_msg_pub.cto_message('BOM', l_msg_name);
3441: raise FND_API.G_EXC_ERROR;
3442:
3443: ELSIF (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3444: IF PG_DEBUG <> 0 THEN
3445: oe_debug_pub.add('create_flow_schedule_wf: ' || 'Unexpected error in Create Flow Schedule for line id ' || p_itemkey, 1);
3446: END IF;
3447: cto_msg_pub.cto_message('BOM', l_msg_name);

Line 3448: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3444: IF PG_DEBUG <> 0 THEN
3445: oe_debug_pub.add('create_flow_schedule_wf: ' || 'Unexpected error in Create Flow Schedule for line id ' || p_itemkey, 1);
3446: END IF;
3447: cto_msg_pub.cto_message('BOM', l_msg_name);
3448: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3449:
3450: END IF;
3451:
3452: --

Line 3479: when FND_API.G_EXC_ERROR then

3475: OE_STANDARD_WF.Clear_Msg_Context;
3476:
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;

Line 3503: when FND_API.G_EXC_UNEXPECTED_ERROR then

3499: x_result := 'COMPLETE:INCOMPLETE';
3500: rollback to savepoint before_process;
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;

Line 3795: raise FND_API.G_EXC_ERROR;

3791: IF PG_DEBUG <> 0 THEN
3792: oe_debug_pub.add('set_parameter_work_order_wf: ' || 'Ordered quantity is zero.', 1);
3793: END IF;
3794: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_WORK_ORDER_ERROR');
3795: raise FND_API.G_EXC_ERROR;
3796: end if;
3797:
3798: l_stmt_num := 101;
3799:

Line 3843: when FND_API.G_EXC_ERROR then

3839: x_result := 'COMPLETE:INCOMPLETE';
3840: return;
3841:
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) );

Line 3856: when FND_API.G_EXC_UNEXPECTED_ERROR then

3852: rollback to savepoint before_process;
3853: return;
3854:
3855:
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. ' ||

Line 4528: if xreturnstatus = FND_API.G_RET_STS_ERROR then

4524: x_return_status => xReturnStatus,
4525: x_msg_count => XMsgCount,
4526: x_msg_data => xmsgdata);
4527:
4528: if xreturnstatus = FND_API.G_RET_STS_ERROR then
4529: IF PG_DEBUG <> 0 THEN
4530: oe_debug_pub.add('Purchase_price_calc_wf: ' || ' Failed in Create_purchasing_doc call...',1);
4531: END IF;
4532: -- raise FND_API.G_EXC_ERROR;

Line 4532: -- raise FND_API.G_EXC_ERROR;

4528: if xreturnstatus = FND_API.G_RET_STS_ERROR then
4529: IF PG_DEBUG <> 0 THEN
4530: oe_debug_pub.add('Purchase_price_calc_wf: ' || ' Failed in Create_purchasing_doc call...',1);
4531: END IF;
4532: -- raise FND_API.G_EXC_ERROR;
4533: elsif xreturnstatus = FND_API.G_RET_STS_UNEXP_ERROR then
4534: IF PG_DEBUG <> 0 THEN
4535: oe_debug_pub.add('Purchase_price_calc_wf: ' || ' Failed in Create_purchasing_doc call...',1);
4536: END IF;

Line 4533: elsif xreturnstatus = FND_API.G_RET_STS_UNEXP_ERROR then

4529: IF PG_DEBUG <> 0 THEN
4530: oe_debug_pub.add('Purchase_price_calc_wf: ' || ' Failed in Create_purchasing_doc call...',1);
4531: END IF;
4532: -- raise FND_API.G_EXC_ERROR;
4533: elsif xreturnstatus = FND_API.G_RET_STS_UNEXP_ERROR then
4534: IF PG_DEBUG <> 0 THEN
4535: oe_debug_pub.add('Purchase_price_calc_wf: ' || ' Failed in Create_purchasing_doc call...',1);
4536: END IF;
4537: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4537: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;

4533: elsif xreturnstatus = FND_API.G_RET_STS_UNEXP_ERROR then
4534: IF PG_DEBUG <> 0 THEN
4535: oe_debug_pub.add('Purchase_price_calc_wf: ' || ' Failed in Create_purchasing_doc call...',1);
4536: END IF;
4537: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;
4538: end if;
4539: */
4540:
4541: oe_debug_pub.add('Purchase_price_calc_wf: ' || ' Failed to call Create_purchasing_doc call...',1);

Line 4616: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

4612: l_msg_data,
4613: l_return_status
4614: );
4615:
4616: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4617: x_result :='COMPLETE:RESERVED';
4618: ELSE
4619: x_result := 'COMPLETE';
4620: END IF;

Line 4628: when FND_API.G_EXC_ERROR then

4624: OE_STANDARD_WF.Save_Messages;
4625: OE_STANDARD_WF.Clear_Msg_Context;
4626:
4627: EXCEPTION
4628: when FND_API.G_EXC_ERROR then
4629: IF PG_DEBUG <> 0 THEN
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;

Line 4636: when FND_API.G_EXC_UNEXPECTED_ERROR then

4632: OE_STANDARD_WF.Save_Messages;
4633: OE_STANDARD_WF.Clear_Msg_Context;
4634: raise; -- can be re-tried
4635:
4636: when FND_API.G_EXC_UNEXPECTED_ERROR then
4637: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
4638: FND_MSG_PUB.Add_Exc_Msg
4639: (G_PKG_NAME
4640: ,'chk_rsv_after_afas_wf'

Line 4774: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4770: oe_debug_pub.add('check_supply_creation_wf: ' || 'return value from display_wf_status'
4771: ||return_value ,1);
4772: END IF;
4773: cto_msg_pub.cto_message('CTO', 'CTO_ERROR_FROM_DISPLAY_STATUS');
4774: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4775: end if;
4776:
4777:
4778:

Line 4799: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4795: x_sourcing_org => l_sourcing_org, --new param R12 OPM
4796: x_message => l_message --new param R12 OPM
4797: );
4798:
4799: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4800: IF l_can_create_supply = 'N' THEN
4801:
4802: IF PG_DEBUG <> 0 THEN
4803: oe_debug_pub.add('check_supply_creation_wf: ' || 'It is Config item Planning case...',1);

Line 4829: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4825: END IF;
4826:
4827: END IF;--l_can_create_supply
4828:
4829: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4830: RAISE FND_API.G_EXC_ERROR;
4831: ELSE
4832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4833: END IF;--l_return_status

Line 4830: RAISE FND_API.G_EXC_ERROR;

4826:
4827: END IF;--l_can_create_supply
4828:
4829: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4830: RAISE FND_API.G_EXC_ERROR;
4831: ELSE
4832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4833: END IF;--l_return_status
4834:

Line 4832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4828:
4829: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4830: RAISE FND_API.G_EXC_ERROR;
4831: ELSE
4832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4833: END IF;--l_return_status
4834:
4835:
4836: l_stmt_num:=70;

Line 4851: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4847: oe_debug_pub.add('check_supply_creation_wf: ' || 'return value from display_wf_status'
4848: ||return_value ,1);
4849: END IF;
4850: cto_msg_pub.cto_message('CTO', 'CTO_ERROR_FROM_DISPLAY_STATUS');
4851: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4852: end if;
4853:
4854: END IF;--run
4855:

Line 4861: when FND_API.G_EXC_ERROR then

4857: OE_STANDARD_WF.Clear_Msg_Context;
4858:
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;

Line 4874: when FND_API.G_EXC_UNEXPECTED_ERROR then

4870: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
4871: raise;
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;