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 1402: when FND_API.G_EXC_ERROR then

1398:
1399:
1400: EXCEPTION
1401:
1402: when FND_API.G_EXC_ERROR then
1403: IF PG_DEBUG <> 0 THEN
1404: OE_DEBUG_PUB.add('create_config_item_wf: ' || 'CTO_WORKFLOW.create_config_item_wf ' ||
1405: to_char(l_stmt_num) || ':' ||
1406: l_x_error_msg);

Line 1414: when FND_API.G_EXC_UNEXPECTED_ERROR then

1410: OE_STANDARD_WF.Clear_Msg_Context;
1411: x_result := 'COMPLETE:INCOMPLETE';
1412: rollback to savepoint before_item_creation;
1413:
1414: when FND_API.G_EXC_UNEXPECTED_ERROR then
1415: IF PG_DEBUG <> 0 THEN
1416: OE_DEBUG_PUB.add('create_config_item_wf: ' || 'CTO_WORKFLOW.create_config_item_wf ' ||
1417: to_char(l_stmt_num) || ':' ||
1418: l_x_error_msg);

Line 1521: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1517: /*
1518: ** Check whether full match was successful for top model to create reservations
1519: */
1520:
1521: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1522: x_reserve_status := 'MATCH' ;
1523:
1524:
1525: /*

Line 1579: , p_init_msg_lst => fnd_api.g_false

1575: l_stmt_num := 150;
1576:
1577: INV_QUANTITY_TREE_GRP.create_tree
1578: ( p_api_version_number => 1.0
1579: , p_init_msg_lst => fnd_api.g_false
1580: , x_return_status => l_return_status
1581: , x_msg_count => x_msg_count
1582: , x_msg_data => x_msg_data
1583: , p_organization_id => p_mfg_org_id

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

1587: , p_is_lot_control => FALSE
1588: , p_is_serial_control => FALSE
1589: , x_tree_id => l_tree_id);
1590:
1591: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1592: IF PG_DEBUG <> 0 THEN
1593: oe_debug_pub.add('create_reservation: ' || 'Failed in create_tree with status: ' ||
1594: l_return_status, 1);
1595: END IF;

Line 1624: p_init_msg_lst => fnd_api.g_false,

1620:
1621: l_stmt_num := 165;
1622: INV_QUANTITY_TREE_GRP.query_tree
1623: (p_api_version_number => 1.0,
1624: p_init_msg_lst => fnd_api.g_false,
1625: x_return_status => l_return_status,
1626: x_msg_count => x_msg_count,
1627: x_msg_data => x_msg_data,
1628: p_tree_id => l_tree_id,

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

1637: x_qs => l_x_qs,
1638: x_att => l_x_att,
1639: x_atr => x_available_qty);
1640:
1641: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1642: IF PG_DEBUG <> 0 THEN
1643: oe_debug_pub.add('create_reservation: ' || 'Failed in create_tree with status: ' ||
1644: l_return_status, 1);
1645: END IF;

Line 2003: x_return_status := FND_API.G_RET_STS_ERROR ;

1999: END IF;
2000: OE_STANDARD_WF.Save_Messages;
2001: OE_STANDARD_WF.Clear_Msg_Context;
2002:
2003: x_return_status := FND_API.G_RET_STS_ERROR ;
2004:
2005:
2006: when NO_DATA_FOUND then
2007: --rollback to savepoint before_item_creation;

Line 2012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 2025: x_return_status := FND_API.G_RET_STS_ERROR ;

2021:
2022: OE_STANDARD_WF.Save_Messages;
2023: OE_STANDARD_WF.Clear_Msg_Context;
2024:
2025: x_return_status := FND_API.G_RET_STS_ERROR ;
2026:
2027: when FND_API.G_EXC_UNEXPECTED_ERROR then
2028: --rollback to savepoint before_item_creation;
2029: IF PG_DEBUG <> 0 THEN

Line 2027: when FND_API.G_EXC_UNEXPECTED_ERROR then

2023: OE_STANDARD_WF.Clear_Msg_Context;
2024:
2025: x_return_status := FND_API.G_RET_STS_ERROR ;
2026:
2027: when FND_API.G_EXC_UNEXPECTED_ERROR then
2028: --rollback to savepoint before_item_creation;
2029: IF PG_DEBUG <> 0 THEN
2030: OE_DEBUG_PUB.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation ' ||
2031: to_char(l_stmt_num) || ':' ||

Line 2037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2033: END IF;
2034: OE_STANDARD_WF.Save_Messages;
2035: OE_STANDARD_WF.Clear_Msg_Context;
2036:
2037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2038:
2039: when OTHERS then
2040: --rollback to savepoint before_item_creation;
2041: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_ITEM_ERROR');

Line 2047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2043: oe_debug_pub.add('create_reservation: ' || 'CTO_WORKFLOW.create_reservation' ||
2044: to_char(l_stmt_num) || ':' ||
2045: substrb(sqlerrm, 1, 100));
2046: END IF;
2047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2048:
2049:
2050: END CREATE_RESERVATION ;
2051:

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

2152: ,x_return_status => l_x_hold_return_status
2153: ,x_msg_count => l_x_error_msg_count
2154: ,x_msg_data => l_x_error_msg);
2155:
2156: IF (l_x_hold_return_status = FND_API.G_RET_STS_ERROR) THEN
2157: IF PG_DEBUG <> 0 THEN
2158: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with expected error.' ,1);
2159: END IF;
2160: raise FND_API.G_EXC_ERROR;

Line 2160: raise FND_API.G_EXC_ERROR;

2156: IF (l_x_hold_return_status = FND_API.G_RET_STS_ERROR) THEN
2157: IF PG_DEBUG <> 0 THEN
2158: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with expected error.' ,1);
2159: END IF;
2160: raise FND_API.G_EXC_ERROR;
2161:
2162: ELSIF (l_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2163: IF PG_DEBUG <> 0 THEN
2164: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with unexpected error.' ,1);

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

2158: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with expected error.' ,1);
2159: END IF;
2160: raise FND_API.G_EXC_ERROR;
2161:
2162: ELSIF (l_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2163: IF PG_DEBUG <> 0 THEN
2164: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with unexpected error.' ,1);
2165: END IF;
2166: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2166: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2162: ELSIF (l_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2163: IF PG_DEBUG <> 0 THEN
2164: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with unexpected error.' ,1);
2165: END IF;
2166: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2167:
2168: ELSE
2169: IF PG_DEBUG <> 0 THEN
2170: oe_debug_pub.add('CTOCITMB:Success in Check Holds.' ,1);

Line 2173: if l_x_hold_result_out = FND_API.G_TRUE then

2169: IF PG_DEBUG <> 0 THEN
2170: oe_debug_pub.add('CTOCITMB:Success in Check Holds.' ,1);
2171: END IF;
2172:
2173: if l_x_hold_result_out = FND_API.G_TRUE then
2174: IF PG_DEBUG <> 0 THEN
2175: oe_debug_pub.add('CTOCITMB:Create Supply Activity Hold exists on Config Line .' ,1);
2176: END IF;
2177:

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

2195: ,x_return_status => l_x_hold_return_status
2196: ,x_msg_count => l_x_error_msg_count
2197: ,x_msg_data => l_x_error_msg);
2198:
2199: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2200: IF PG_DEBUG <> 0 THEN
2201: oe_debug_pub.add('CTOCITMB:Failed in Release Holds with expected error.' ,1);
2202: END IF;
2203: raise FND_API.G_EXC_ERROR;

Line 2203: raise FND_API.G_EXC_ERROR;

2199: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2200: IF PG_DEBUG <> 0 THEN
2201: oe_debug_pub.add('CTOCITMB:Failed in Release Holds with expected error.' ,1);
2202: END IF;
2203: raise FND_API.G_EXC_ERROR;
2204:
2205: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2206: IF PG_DEBUG <> 0 THEN
2207: oe_debug_pub.add('CTOCITMB:Failed in Release Holds with unexpected error.' ,1);

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

2201: oe_debug_pub.add('CTOCITMB:Failed in Release Holds with expected error.' ,1);
2202: END IF;
2203: raise FND_API.G_EXC_ERROR;
2204:
2205: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2206: IF PG_DEBUG <> 0 THEN
2207: oe_debug_pub.add('CTOCITMB:Failed in Release Holds with unexpected error.' ,1);
2208: END IF;
2209: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2209: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2205: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2206: IF PG_DEBUG <> 0 THEN
2207: oe_debug_pub.add('CTOCITMB:Failed in Release Holds with unexpected error.' ,1);
2208: END IF;
2209: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2210: END IF;
2211:
2212: IF PG_DEBUG <> 0 THEN
2213: oe_debug_pub.add('CTOCITMB: Hold Released on config line.' ,1);

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

2232: , x_return_status => l_return_status
2233: , x_msg_count => l_msg_count
2234: , x_msg_data => l_msg_data);
2235:
2236: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2237: IF PG_DEBUG <> 0 THEN
2238: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with expected error.' ,1);
2239: END IF;
2240: raise FND_API.G_EXC_ERROR;

Line 2240: raise FND_API.G_EXC_ERROR;

2236: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2237: IF PG_DEBUG <> 0 THEN
2238: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with expected error.' ,1);
2239: END IF;
2240: raise FND_API.G_EXC_ERROR;
2241:
2242: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2243: IF PG_DEBUG <> 0 THEN
2244: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with unexpected error.' ,1);

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

2238: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with expected error.' ,1);
2239: END IF;
2240: raise FND_API.G_EXC_ERROR;
2241:
2242: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2243: IF PG_DEBUG <> 0 THEN
2244: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with unexpected error.' ,1);
2245: END IF;
2246: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2246: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2242: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2243: IF PG_DEBUG <> 0 THEN
2244: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with unexpected error.' ,1);
2245: END IF;
2246: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2247: END IF;
2248:
2249: IF PG_DEBUG <> 0 THEN
2250: oe_debug_pub.add('CTOCITMB: An Exception Hold applied to config line.' ,1);

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

2303: l_msg_data,
2304: l_return_status);
2305: -- Bugfix 3075105 end
2306:
2307: if ((l_ResultStatus=TRUE) and (l_return_status=FND_API.G_RET_STS_SUCCESS)) then
2308:
2309: IF PG_DEBUG <> 0 THEN
2310: oe_debug_pub.add('rsv_before_booking_wf: ' || 'Reservation exists, completing flow with reserved', 2);
2311: END IF;

Line 2323: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2319: return_value:= CTO_WORKFLOW_API_PK.display_wf_status(to_number(p_itemkey));
2320:
2321: if return_value <> 1 then
2322: cto_msg_pub.cto_message('CTO', 'CTO_ERROR_FROM_DISPLAY_STATUS');
2323: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2324: end if;
2325:
2326: elsif ((l_ResultStatus=FALSE) and (l_return_status=FND_API.G_RET_STS_SUCCESS)) then
2327: IF PG_DEBUG <> 0 THEN

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

2322: cto_msg_pub.cto_message('CTO', 'CTO_ERROR_FROM_DISPLAY_STATUS');
2323: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2324: end if;
2325:
2326: elsif ((l_ResultStatus=FALSE) and (l_return_status=FND_API.G_RET_STS_SUCCESS)) then
2327: IF PG_DEBUG <> 0 THEN
2328: oe_debug_pub.add('rsv_before_booking_wf: ' || 'Reservation does not exist, completing flow with complete.', 2);
2329: END IF;
2330: x_result :='COMPLETE';

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

2328: oe_debug_pub.add('rsv_before_booking_wf: ' || 'Reservation does not exist, completing flow with complete.', 2);
2329: END IF;
2330: x_result :='COMPLETE';
2331:
2332: elsif(l_return_status=FND_API.G_RET_STS_ERROR) then
2333: IF PG_DEBUG <> 0 THEN
2334: oe_debug_pub.add('rsv_before_booking_wf: ' || 'returning from check_rsv_exists with expected error.', 2);
2335: END IF;
2336: RAISE FND_API.G_EXC_ERROR;

Line 2336: RAISE FND_API.G_EXC_ERROR;

2332: elsif(l_return_status=FND_API.G_RET_STS_ERROR) then
2333: IF PG_DEBUG <> 0 THEN
2334: oe_debug_pub.add('rsv_before_booking_wf: ' || 'returning from check_rsv_exists with expected error.', 2);
2335: END IF;
2336: RAISE FND_API.G_EXC_ERROR;
2337:
2338: elsif(l_return_status=FND_API.G_RET_STS_UNEXP_ERROR) then
2339: IF PG_DEBUG <> 0 THEN
2340: oe_debug_pub.add('rsv_before_booking_wf: ' || 'returning from check_rsv_exists with unexpected error.', 2);

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

2334: oe_debug_pub.add('rsv_before_booking_wf: ' || 'returning from check_rsv_exists with expected error.', 2);
2335: END IF;
2336: RAISE FND_API.G_EXC_ERROR;
2337:
2338: elsif(l_return_status=FND_API.G_RET_STS_UNEXP_ERROR) then
2339: IF PG_DEBUG <> 0 THEN
2340: oe_debug_pub.add('rsv_before_booking_wf: ' || 'returning from check_rsv_exists with unexpected error.', 2);
2341: END IF;
2342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2338: elsif(l_return_status=FND_API.G_RET_STS_UNEXP_ERROR) then
2339: IF PG_DEBUG <> 0 THEN
2340: oe_debug_pub.add('rsv_before_booking_wf: ' || 'returning from check_rsv_exists with unexpected error.', 2);
2341: END IF;
2342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2343:
2344: end if;
2345: --start bug#1861812
2346:

Line 2361: when FND_API.G_EXC_ERROR then

2357: OE_STANDARD_WF.Save_Messages;
2358: OE_STANDARD_WF.Clear_Msg_Context;
2359:
2360: EXCEPTION
2361: when FND_API.G_EXC_ERROR then
2362: IF PG_DEBUG <> 0 THEN
2363: OE_DEBUG_PUB.add('rsv_before_booking_wf: ' || 'CTO_WORKFLOW.rsv_before_booking_wf ' || to_char(l_stmt_num) );
2364: END IF;
2365: OE_STANDARD_WF.Save_Messages;

Line 2369: when FND_API.G_EXC_UNEXPECTED_ERROR then

2365: OE_STANDARD_WF.Save_Messages;
2366: OE_STANDARD_WF.Clear_Msg_Context;
2367: raise; -- can be re-tried
2368:
2369: when FND_API.G_EXC_UNEXPECTED_ERROR then
2370: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2371: FND_MSG_PUB.Add_Exc_Msg
2372: (G_PKG_NAME
2373: ,'rsv_before_booking_wf'

Line 2461: x_return_status := FND_API.G_RET_STS_SUCCESS;

2457: IF PG_DEBUG <> 0 THEN
2458: oe_debug_pub.add ('check_inv_rsv_exists: ' || 'found that reservation exists before booking', 1);
2459: END IF;
2460: x_ResultStatus := TRUE;
2461: x_return_status := FND_API.G_RET_STS_SUCCESS;
2462:
2463: EXCEPTION
2464:
2465: when no_data_found then

Line 2467: x_return_status := FND_API.G_RET_STS_SUCCESS;

2463: EXCEPTION
2464:
2465: when no_data_found then
2466: x_ResultStatus := FALSE;
2467: x_return_status := FND_API.G_RET_STS_SUCCESS;
2468: IF PG_DEBUG <> 0 THEN
2469: oe_debug_pub.add ('check_inv_rsv_exists: ' || 'no reservations before booking, this is not an error', 1);
2470: END IF;
2471:

Line 2473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2469: oe_debug_pub.add ('check_inv_rsv_exists: ' || 'no reservations before booking, this is not an error', 1);
2470: END IF;
2471:
2472: when others then
2473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2474: IF PG_DEBUG <> 0 THEN
2475: oe_debug_pub.add ('check_inv_rsv_exists: ' || 'unexpected error in called program check_inv_rsv_exists'|| sqlerrm , 1);
2476: END IF;
2477: if fnd_msg_pub.check_msg_level

Line 2555: x_return_status := FND_API.G_RET_STS_SUCCESS;

2551: and demand_source_line = to_char(pLineId)
2552: and status <> 2; -- Flow Schedule status : 1 = Open 2 = Closed/Completed
2553: else
2554: x_ResultStatus := TRUE;
2555: x_return_status := FND_API.G_RET_STS_SUCCESS;
2556: IF PG_DEBUG <> 0 THEN
2557: oe_debug_pub.add ('check_rsv_exists: ' || 'MTL reservation exists before booking', 1);
2558: END IF;
2559: return;

Line 2564: x_return_status := FND_API.G_RET_STS_SUCCESS;

2560: end if;
2561:
2562: if lFloCount > 0 then
2563: x_ResultStatus := TRUE;
2564: x_return_status := FND_API.G_RET_STS_SUCCESS;
2565: IF PG_DEBUG <> 0 THEN
2566: oe_debug_pub.add ('check_rsv_exists: ' || 'FLOW reservation exists before booking', 1);
2567: END IF;
2568: else

Line 2570: x_return_status := FND_API.G_RET_STS_SUCCESS;

2566: oe_debug_pub.add ('check_rsv_exists: ' || 'FLOW reservation exists before booking', 1);
2567: END IF;
2568: else
2569: x_ResultStatus := FALSE;
2570: x_return_status := FND_API.G_RET_STS_SUCCESS;
2571: IF PG_DEBUG <> 0 THEN
2572: oe_debug_pub.add ('check_rsv_exists: ' || 'NO reservations before booking, this is not an error', 1);
2573: END IF;
2574: end if;

Line 2580: x_return_status := FND_API.G_RET_STS_SUCCESS;

2576: EXCEPTION
2577:
2578: when no_data_found then
2579: x_ResultStatus := FALSE;
2580: x_return_status := FND_API.G_RET_STS_SUCCESS;
2581: IF PG_DEBUG <> 0 THEN
2582: oe_debug_pub.add ('check_rsv_exists: ' || 'no reservations before booking, this is not an error', 1);
2583: END IF;
2584:

Line 2586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2582: oe_debug_pub.add ('check_rsv_exists: ' || 'no reservations before booking, this is not an error', 1);
2583: END IF;
2584:
2585: when others then
2586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2587: IF PG_DEBUG <> 0 THEN
2588: oe_debug_pub.add ('check_rsv_exists: ' || 'unexpected error in called program check_inv_rsv_exists'|| sqlerrm , 1);
2589: END IF;
2590: if fnd_msg_pub.check_msg_level

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

3100: x_return_status => v_x_hold_return_status,
3101: x_msg_count => v_x_error_msg_count,
3102: x_msg_data => v_x_error_msg);
3103:
3104: IF (v_x_hold_return_status = FND_API.G_RET_STS_ERROR) THEN
3105: IF PG_DEBUG <> 0 THEN
3106: oe_debug_pub.add('Check_supply_type_wf: ' || 'Expected error in Check Hold: ' || v_x_hold_return_status, 1);
3107: END IF;
3108: RAISE FND_API.G_EXC_ERROR;

Line 3108: RAISE FND_API.G_EXC_ERROR;

3104: IF (v_x_hold_return_status = FND_API.G_RET_STS_ERROR) THEN
3105: IF PG_DEBUG <> 0 THEN
3106: oe_debug_pub.add('Check_supply_type_wf: ' || 'Expected error in Check Hold: ' || v_x_hold_return_status, 1);
3107: END IF;
3108: RAISE FND_API.G_EXC_ERROR;
3109:
3110: ELSIF (v_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3111: IF PG_DEBUG <> 0 THEN
3112: oe_debug_pub.add('Check_supply_type_wf: ' || 'Unexp error in Check Hold ' || v_x_hold_return_status, 1);

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

3106: oe_debug_pub.add('Check_supply_type_wf: ' || 'Expected error in Check Hold: ' || v_x_hold_return_status, 1);
3107: END IF;
3108: RAISE FND_API.G_EXC_ERROR;
3109:
3110: ELSIF (v_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3111: IF PG_DEBUG <> 0 THEN
3112: oe_debug_pub.add('Check_supply_type_wf: ' || 'Unexp error in Check Hold ' || v_x_hold_return_status, 1);
3113: END IF;
3114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3110: ELSIF (v_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3111: IF PG_DEBUG <> 0 THEN
3112: oe_debug_pub.add('Check_supply_type_wf: ' || 'Unexp error in Check Hold ' || v_x_hold_return_status, 1);
3113: END IF;
3114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3115:
3116: ELSE
3117: IF PG_DEBUG <> 0 THEN
3118: oe_debug_pub.add('Check_supply_type_wf: ' || 'Success in Check Hold ' || v_x_hold_return_status, 5);

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

3117: IF PG_DEBUG <> 0 THEN
3118: oe_debug_pub.add('Check_supply_type_wf: ' || 'Success in Check Hold ' || v_x_hold_return_status, 5);
3119: END IF;
3120:
3121: IF (v_x_hold_result_out = FND_API.G_TRUE) THEN
3122: IF PG_DEBUG <> 0 THEN
3123: oe_debug_pub.add('Check_supply_type_wf: ' || 'Order Line ID ' || p_itemkey || 'is on HOLD. ' ||v_x_hold_result_out, 1);
3124: END IF;
3125: cto_msg_pub.cto_message('BOM', 'CTO_ORDER_LINE_ON_HOLD');

Line 3175: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3171: x_sourcing_org => l_sourcing_org,
3172: x_message => l_message
3173: );
3174:
3175: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3176: IF PG_DEBUG <> 0 THEN
3177: oe_debug_pub.add('check_supply_type_wf: ' ||
3178: 'Expected Error in check_cto_can_create_supply.',1);
3179: END IF;

Line 3180: raise FND_API.G_EXC_ERROR;

3176: IF PG_DEBUG <> 0 THEN
3177: oe_debug_pub.add('check_supply_type_wf: ' ||
3178: 'Expected Error in check_cto_can_create_supply.',1);
3179: END IF;
3180: raise FND_API.G_EXC_ERROR;
3181:
3182: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3183: IF PG_DEBUG <> 0 THEN
3184: oe_debug_pub.add('check_supply_type_wf: ' ||

Line 3182: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3178: 'Expected Error in check_cto_can_create_supply.',1);
3179: END IF;
3180: raise FND_API.G_EXC_ERROR;
3181:
3182: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3183: IF PG_DEBUG <> 0 THEN
3184: oe_debug_pub.add('check_supply_type_wf: ' ||
3185: 'Unexpected Error in check_cto_can_create_supply.',1);
3186: END IF;

Line 3187: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3183: IF PG_DEBUG <> 0 THEN
3184: oe_debug_pub.add('check_supply_type_wf: ' ||
3185: 'Unexpected Error in check_cto_can_create_supply.',1);
3186: END IF;
3187: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3188:
3189: END IF;
3190:
3191: l_stmt_num := 210;

Line 3233: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3229:
3230: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'call to display_wf_status failed.');
3231: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'l_ret_stat=> '||l_ret_stat);
3232:
3233: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3234: END IF;
3235: END IF;
3236:
3237: --end bugfix 4556596

Line 3306: when FND_API.G_EXC_ERROR then

3302: OE_STANDARD_WF.Clear_Msg_Context;
3303:
3304: EXCEPTION
3305:
3306: when FND_API.G_EXC_ERROR then
3307: IF PG_DEBUG <> 0 THEN
3308: OE_DEBUG_PUB.add('check_supply_type_wf: ' || 'CTO_WORKFLOW.check_supply_type_wf ' ||
3309: to_char(l_stmt_num));
3310: END IF;

Line 3316: when FND_API.G_EXC_UNEXPECTED_ERROR then

3312: OE_STANDARD_WF.Clear_Msg_Context;
3313: x_result := 'COMPLETE:INCOMPLETE';
3314:
3315:
3316: when FND_API.G_EXC_UNEXPECTED_ERROR then
3317: IF PG_DEBUG <> 0 THEN
3318: OE_DEBUG_PUB.add('check_supply_type_wf: ' || 'CTO_WORKFLOW.check_supply_type_wf ' ||
3319: to_char(l_stmt_num));
3320: END IF;

Line 3395: raise FND_API.G_EXC_ERROR;

3391: if a hold is found.
3392: +-----------------------------------------------------------*/
3393: if (validate_config_line(to_number(p_itemkey)) <> TRUE) then
3394: cto_msg_pub.cto_message('BOM','CTO_LINE_STATUS_NOT_ELIGIBLE');
3395: raise FND_API.G_EXC_ERROR;
3396: end if;
3397:
3398: --bugfix 1799874 start
3399: l_source_document_type_id := CTO_UTILITY_PK.get_source_document_id ( pLineId => to_number(p_itemkey) );

Line 3430: raise FND_API.G_EXC_ERROR;

3426: IF PG_DEBUG <> 0 THEN
3427: oe_debug_pub.add('create_flow_schedule_wf: ' || 'l_quantity <= 0', 1);
3428: END IF;
3429: cto_msg_pub.cto_message('BOM','CTO_CREATE_FLOW_SCHED_ERROR');
3430: raise FND_API.G_EXC_ERROR;
3431: end if;
3432:
3433: l_stmt_num := 120;
3434: -- Removed check hold API call from here as we are going to check for

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

3465: x_msg_txt => l_msg_txt);
3466:
3467:
3468:
3469: IF (l_x_return_status = FND_API.G_RET_STS_ERROR) THEN
3470: IF PG_DEBUG <> 0 THEN
3471: oe_debug_pub.add('create_flow_schedule_wf: ' || 'Expected error in cto_fs. ', 1);
3472: END IF;
3473: cto_msg_pub.cto_message('BOM', l_msg_name);

Line 3474: raise FND_API.G_EXC_ERROR;

3470: IF PG_DEBUG <> 0 THEN
3471: oe_debug_pub.add('create_flow_schedule_wf: ' || 'Expected error in cto_fs. ', 1);
3472: END IF;
3473: cto_msg_pub.cto_message('BOM', l_msg_name);
3474: raise FND_API.G_EXC_ERROR;
3475:
3476: ELSIF (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3477: IF PG_DEBUG <> 0 THEN
3478: oe_debug_pub.add('create_flow_schedule_wf: ' || 'Unexpected error in Create Flow Schedule for line id ' || p_itemkey, 1);

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

3472: END IF;
3473: cto_msg_pub.cto_message('BOM', l_msg_name);
3474: raise FND_API.G_EXC_ERROR;
3475:
3476: ELSIF (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3477: IF PG_DEBUG <> 0 THEN
3478: oe_debug_pub.add('create_flow_schedule_wf: ' || 'Unexpected error in Create Flow Schedule for line id ' || p_itemkey, 1);
3479: END IF;
3480: cto_msg_pub.cto_message('BOM', l_msg_name);

Line 3481: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3477: IF PG_DEBUG <> 0 THEN
3478: oe_debug_pub.add('create_flow_schedule_wf: ' || 'Unexpected error in Create Flow Schedule for line id ' || p_itemkey, 1);
3479: END IF;
3480: cto_msg_pub.cto_message('BOM', l_msg_name);
3481: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3482:
3483: END IF;
3484:
3485: --

Line 3512: when FND_API.G_EXC_ERROR then

3508: OE_STANDARD_WF.Clear_Msg_Context;
3509:
3510: EXCEPTION
3511:
3512: when FND_API.G_EXC_ERROR then
3513: IF PG_DEBUG <> 0 THEN
3514: OE_DEBUG_PUB.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf raised exp error in stmt ' ||
3515: to_char(l_stmt_num) || ':' || l_x_error_msg);
3516: END IF;

Line 3536: when FND_API.G_EXC_UNEXPECTED_ERROR then

3532: x_result := 'COMPLETE:INCOMPLETE';
3533: rollback to savepoint before_process;
3534: return;
3535:
3536: when FND_API.G_EXC_UNEXPECTED_ERROR then
3537: IF PG_DEBUG <> 0 THEN
3538: OE_DEBUG_PUB.add('create_flow_schedule_wf: ' || 'CTO_WORKFLOW.create_flow_schedule_wf raised unexp error in stmt ' ||
3539: to_char(l_stmt_num) || ':' || l_x_error_msg);
3540: END IF;

Line 3828: raise FND_API.G_EXC_ERROR;

3824: IF PG_DEBUG <> 0 THEN
3825: oe_debug_pub.add('set_parameter_work_order_wf: ' || 'Ordered quantity is zero.', 1);
3826: END IF;
3827: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_WORK_ORDER_ERROR');
3828: raise FND_API.G_EXC_ERROR;
3829: end if;
3830:
3831: l_stmt_num := 101;
3832:

Line 3876: when FND_API.G_EXC_ERROR then

3872: x_result := 'COMPLETE:INCOMPLETE';
3873: return;
3874:
3875:
3876: when FND_API.G_EXC_ERROR then
3877: unlock_line_id (p_itemkey, x_result); -- bugfix 3136206
3878: IF PG_DEBUG <> 0 THEN
3879: OE_DEBUG_PUB.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf raised exc error. ' ||
3880: to_char(l_stmt_num) );

Line 3889: when FND_API.G_EXC_UNEXPECTED_ERROR then

3885: rollback to savepoint before_process;
3886: return;
3887:
3888:
3889: when FND_API.G_EXC_UNEXPECTED_ERROR then
3890: unlock_line_id (p_itemkey, x_result); -- bugfix 3136206
3891: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_WORK_ORDER_ERROR');
3892: IF PG_DEBUG <> 0 THEN
3893: OE_DEBUG_PUB.add('set_parameter_work_order_wf: ' || 'CTO_WORKFLOW.set_parameter_work_order_wf raised unexc error. ' ||

Line 4627: if xreturnstatus = FND_API.G_RET_STS_ERROR then

4623: x_return_status => xReturnStatus,
4624: x_msg_count => XMsgCount,
4625: x_msg_data => xmsgdata);
4626:
4627: if xreturnstatus = FND_API.G_RET_STS_ERROR then
4628: IF PG_DEBUG <> 0 THEN
4629: oe_debug_pub.add('Purchase_price_calc_wf: ' || ' Failed in Create_purchasing_doc call...',1);
4630: END IF;
4631: -- raise FND_API.G_EXC_ERROR;

Line 4631: -- raise FND_API.G_EXC_ERROR;

4627: if xreturnstatus = FND_API.G_RET_STS_ERROR then
4628: IF PG_DEBUG <> 0 THEN
4629: oe_debug_pub.add('Purchase_price_calc_wf: ' || ' Failed in Create_purchasing_doc call...',1);
4630: END IF;
4631: -- raise FND_API.G_EXC_ERROR;
4632: elsif xreturnstatus = FND_API.G_RET_STS_UNEXP_ERROR then
4633: IF PG_DEBUG <> 0 THEN
4634: oe_debug_pub.add('Purchase_price_calc_wf: ' || ' Failed in Create_purchasing_doc call...',1);
4635: END IF;

Line 4632: elsif xreturnstatus = FND_API.G_RET_STS_UNEXP_ERROR then

4628: IF PG_DEBUG <> 0 THEN
4629: oe_debug_pub.add('Purchase_price_calc_wf: ' || ' Failed in Create_purchasing_doc call...',1);
4630: END IF;
4631: -- raise FND_API.G_EXC_ERROR;
4632: elsif xreturnstatus = FND_API.G_RET_STS_UNEXP_ERROR then
4633: IF PG_DEBUG <> 0 THEN
4634: oe_debug_pub.add('Purchase_price_calc_wf: ' || ' Failed in Create_purchasing_doc call...',1);
4635: END IF;
4636: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4636: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;

4632: elsif xreturnstatus = FND_API.G_RET_STS_UNEXP_ERROR then
4633: IF PG_DEBUG <> 0 THEN
4634: oe_debug_pub.add('Purchase_price_calc_wf: ' || ' Failed in Create_purchasing_doc call...',1);
4635: END IF;
4636: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;
4637: end if;
4638: */
4639:
4640: oe_debug_pub.add('Purchase_price_calc_wf: ' || ' Failed to call Create_purchasing_doc call...',1);

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

4711: l_msg_data,
4712: l_return_status
4713: );
4714:
4715: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4716: x_result :='COMPLETE:RESERVED';
4717: ELSE
4718: x_result := 'COMPLETE';
4719: END IF;

Line 4727: when FND_API.G_EXC_ERROR then

4723: OE_STANDARD_WF.Save_Messages;
4724: OE_STANDARD_WF.Clear_Msg_Context;
4725:
4726: EXCEPTION
4727: when FND_API.G_EXC_ERROR then
4728: IF PG_DEBUG <> 0 THEN
4729: OE_DEBUG_PUB.add('chk_rsv_after_afas_wf: ' || 'CTO_WORKFLOW.chk_rsv_after_afas_wf' || to_char(l_stmt_num) );
4730: END IF;
4731: OE_STANDARD_WF.Save_Messages;

Line 4735: when FND_API.G_EXC_UNEXPECTED_ERROR then

4731: OE_STANDARD_WF.Save_Messages;
4732: OE_STANDARD_WF.Clear_Msg_Context;
4733: raise; -- can be re-tried
4734:
4735: when FND_API.G_EXC_UNEXPECTED_ERROR then
4736: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
4737: FND_MSG_PUB.Add_Exc_Msg
4738: (G_PKG_NAME
4739: ,'chk_rsv_after_afas_wf'

Line 4873: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4869: oe_debug_pub.add('check_supply_creation_wf: ' || 'return value from display_wf_status'
4870: ||return_value ,1);
4871: END IF;
4872: cto_msg_pub.cto_message('CTO', 'CTO_ERROR_FROM_DISPLAY_STATUS');
4873: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4874: end if;
4875:
4876:
4877:

Line 4898: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4894: x_sourcing_org => l_sourcing_org, --new param R12 OPM
4895: x_message => l_message --new param R12 OPM
4896: );
4897:
4898: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4899: IF l_can_create_supply = 'N' THEN
4900:
4901: IF PG_DEBUG <> 0 THEN
4902: oe_debug_pub.add('check_supply_creation_wf: ' || 'It is Config item Planning case...',1);

Line 4928: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4924: END IF;
4925:
4926: END IF;--l_can_create_supply
4927:
4928: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4929: RAISE FND_API.G_EXC_ERROR;
4930: ELSE
4931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4932: END IF;--l_return_status

Line 4929: RAISE FND_API.G_EXC_ERROR;

4925:
4926: END IF;--l_can_create_supply
4927:
4928: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4929: RAISE FND_API.G_EXC_ERROR;
4930: ELSE
4931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4932: END IF;--l_return_status
4933:

Line 4931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4927:
4928: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4929: RAISE FND_API.G_EXC_ERROR;
4930: ELSE
4931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4932: END IF;--l_return_status
4933:
4934:
4935: l_stmt_num:=70;

Line 4950: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4946: oe_debug_pub.add('check_supply_creation_wf: ' || 'return value from display_wf_status'
4947: ||return_value ,1);
4948: END IF;
4949: cto_msg_pub.cto_message('CTO', 'CTO_ERROR_FROM_DISPLAY_STATUS');
4950: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4951: end if;
4952:
4953: END IF;--run
4954:

Line 4960: when FND_API.G_EXC_ERROR then

4956: OE_STANDARD_WF.Clear_Msg_Context;
4957:
4958: EXCEPTION
4959:
4960: when FND_API.G_EXC_ERROR then
4961: IF PG_DEBUG <> 0 THEN
4962: OE_DEBUG_PUB.add('check_supply_creation_wf: ' || 'CTO_WORKFLOW.check_supply_creation_wf ' ||
4963: to_char(l_stmt_num));
4964: END IF;

Line 4973: when FND_API.G_EXC_UNEXPECTED_ERROR then

4969: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
4970: raise;
4971:
4972:
4973: when FND_API.G_EXC_UNEXPECTED_ERROR then
4974: IF PG_DEBUG <> 0 THEN
4975: OE_DEBUG_PUB.add('check_supply_creation_wf: ' || 'CTO_WORKFLOW.check_supply_creation_wf ' ||
4976: to_char(l_stmt_num));
4977: END IF;