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.

[Home] [Help]

APPS.CTO_WORKFLOW_API_PK dependencies on FND_API

Line 662: if x_return_status = FND_API.G_RET_STS_ERROR then

658: p_change_status => l_change_status,
659: p_oe_org_id => l_oe_org_id,
660: x_return_status => x_return_status);
661:
662: if x_return_status = FND_API.G_RET_STS_ERROR then
663: IF PG_DEBUG <> 0 THEN
664: oe_debug_pub.add('display_wf_status: ' || 'change_status_batch raised expected error.', 1);
665: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'change_status_batch raised expected error.');
666: End if;

Line 667: raise FND_API.G_EXC_ERROR;

663: IF PG_DEBUG <> 0 THEN
664: oe_debug_pub.add('display_wf_status: ' || 'change_status_batch raised expected error.', 1);
665: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'change_status_batch raised expected error.');
666: End if;
667: raise FND_API.G_EXC_ERROR;
668: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
669: IF PG_DEBUG <> 0 THEN
670: oe_debug_pub.add('display_wf_status: ' || 'change_status_batch raised unexpected error.', 1);
671: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'change_status_batch raised unexpected error.');

Line 668: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

664: oe_debug_pub.add('display_wf_status: ' || 'change_status_batch raised expected error.', 1);
665: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'change_status_batch raised expected error.');
666: End if;
667: raise FND_API.G_EXC_ERROR;
668: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
669: IF PG_DEBUG <> 0 THEN
670: oe_debug_pub.add('display_wf_status: ' || 'change_status_batch raised unexpected error.', 1);
671: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'change_status_batch raised unexpected error.');
672: End if;

Line 673: raise FND_API.G_EXC_UNEXPECTED_ERROR;

669: IF PG_DEBUG <> 0 THEN
670: oe_debug_pub.add('display_wf_status: ' || 'change_status_batch raised unexpected error.', 1);
671: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'change_status_batch raised unexpected error.');
672: End if;
673: raise FND_API.G_EXC_UNEXPECTED_ERROR;
674: end if; /* x_return_status = FND_API.G_RET_STS_ERROR */
675:
676: IF PG_DEBUG <> 0 THEN
677: oe_debug_pub.add('display_wf_status: ' || 'Re-Setting the Org Context to '||l_original_org_id, 5);

Line 674: end if; /* x_return_status = FND_API.G_RET_STS_ERROR */

670: oe_debug_pub.add('display_wf_status: ' || 'change_status_batch raised unexpected error.', 1);
671: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'change_status_batch raised unexpected error.');
672: End if;
673: raise FND_API.G_EXC_UNEXPECTED_ERROR;
674: end if; /* x_return_status = FND_API.G_RET_STS_ERROR */
675:
676: IF PG_DEBUG <> 0 THEN
677: oe_debug_pub.add('display_wf_status: ' || 'Re-Setting the Org Context to '||l_original_org_id, 5);
678: END IF;

Line 689: when FND_API.G_EXC_ERROR then

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

Line 697: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

Line 763: x_return_status := FND_API.G_RET_STS_SUCCESS;

759: oe_debug_pub.add('inventory_reservation_check: ' || 'Entering inventory_reservation_check', 2);
760: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'In inventory_reservation_check');
761: End if;
762:
763: x_return_status := FND_API.G_RET_STS_SUCCESS;
764:
765: l_stmt_num := 10;
766:
767: select upper(item_type_code)

Line 852: raise FND_API.G_EXC_ERROR;

848: exception
849: when DROPSHIP_EXCEPTION then
850: cto_msg_pub.cto_message('BOM', 'CTO_RESERVATION_INELIGIBLE');
851:
852: raise FND_API.G_EXC_ERROR;
853:
854: when others then
855: raise FND_API.G_EXC_UNEXPECTED_ERROR;
856:

Line 855: raise FND_API.G_EXC_UNEXPECTED_ERROR;

851:
852: raise FND_API.G_EXC_ERROR;
853:
854: when others then
855: raise FND_API.G_EXC_UNEXPECTED_ERROR;
856:
857: end;
858:
859: end if ;

Line 901: raise FND_API.G_EXC_ERROR;

897: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'v_activity_status_code <> NOTIFIED');
898: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
899: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
900: End if;
901: raise FND_API.G_EXC_ERROR;
902: end if;
903: end if;
904: end if;
905:

Line 913: when FND_API.G_EXC_ERROR then

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

Line 919: x_return_status := FND_API.G_RET_STS_ERROR;

915: oe_debug_pub.add('inventory_reservation_check: ' || 'exp error in CTO_WORKFLOW_API_PK.inventory_reservation_check::stmt number '||to_char(l_stmt_num), 1);
916: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no :'|| to_char(l_stmt_num));
917: End if;
918:
919: x_return_status := FND_API.G_RET_STS_ERROR;
920: cto_msg_pub.count_and_get(
921: p_msg_count => x_msg_count,
922: p_msg_data => x_msg_data
923: );

Line 924: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

Line 929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

939: oe_debug_pub.add('inventory_reservation_check: ' || sqlerrm);
940: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no:'||to_char(l_stmt_num) );
941: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check', sqlerrm);
942: End if;
943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
944: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
945: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
946: END IF;
947: cto_msg_pub.count_and_get(

Line 1002: x_return_status := FND_API.G_RET_STS_SUCCESS;

998:
999: IF PG_DEBUG <> 0 THEN
1000: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Entering wf_update_after_inv_reserv', 2);
1001: END IF;
1002: x_return_status := FND_API.G_RET_STS_SUCCESS;
1003: l_stmt_num := 10;
1004:
1005: If PG_DEBUG <> 0 Then
1006: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'Before selecting info from oe_order_lines_all');

Line 1084: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1080: Else
1081: if PG_DEBUG <> 0 Then
1082: oe_debug_pub.add('WF_UPDATE_AFTER_INV_RESERV: Complete_activity function returned error..',5);
1083: end if;
1084: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1085: End if;
1086:
1087: -- End of MOAC Change
1088:

Line 1196: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1192: If PG_DEBUG <> 0 Then
1193: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Raising CTO_ERROR_FROM_DISPLAY_STATUS');
1194: End if;
1195: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
1196: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1197: end if;
1198:
1199:
1200: elsif upper(v_item_type_code) = 'CONFIG' then

Line 1249: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1245: Else
1246: if PG_DEBUG <> 0 Then
1247: oe_debug_pub.add('WF_UPDATE_AFTER_INV_RESERV: Complete_activity function returned error..',5);
1248: end if;
1249: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1250: End if;
1251:
1252: -- End of MOAC Change
1253:

Line 1300: raise FND_API.G_EXC_ERROR;

1296: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_reserv', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1297: End if;
1298:
1299: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1300: raise FND_API.G_EXC_ERROR;
1301: end if;
1302:
1303: END IF; /* end of v_activity_status_code check */
1304:

Line 1327: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1323: IF PG_DEBUG <> 0 Then
1324: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Raising CTO_ERROR_FROM_DISPLAY_STATUS');
1325: End if;
1326: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
1327: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1328: END IF;
1329:
1330: end if; /* end of item_type_code check */
1331: If PG_DEBUG <> 0 then

Line 1339: when FND_API.G_EXC_ERROR then

1335: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Exiting wf_update_after_inv_reserv', 2);
1336: END IF;
1337:
1338: EXCEPTION
1339: when FND_API.G_EXC_ERROR then
1340: IF PG_DEBUG <> 0 THEN
1341: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'exp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_reserv::stmt number '||to_char(l_stmt_num), 1);
1342: END IF;
1343:

Line 1350: x_return_status := FND_API.G_RET_STS_ERROR;

1346: 'Exp error in CTO_WORKFLOW_API_PK.wf_update_inv_reserv::
1347: stmt no : '||to_char(l_stmt_num)||'::'||sqlerrm);
1348: End if;
1349:
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: cto_msg_pub.count_and_get(
1352: p_msg_count => x_msg_count,
1353: p_msg_data => x_msg_data
1354: );

Line 1356: when FND_API.G_EXC_UNEXPECTED_ERROR then

1352: p_msg_count => x_msg_count,
1353: p_msg_data => x_msg_data
1354: );
1355:
1356: when FND_API.G_EXC_UNEXPECTED_ERROR then
1357: IF PG_DEBUG <> 0 THEN
1358: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'unexp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_reserv::stmt number '||to_char(l_stmt_num), 1);
1359: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',
1360: 'UNExp error in CTO_WORKFLOW_API_PK.wf_update_inv_reserv::

Line 1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1360: 'UNExp error in CTO_WORKFLOW_API_PK.wf_update_inv_reserv::
1361: stmt no : '||to_char(l_stmt_num)||'::'||sqlerrm);
1362: End if;
1363:
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1365: cto_msg_pub.count_and_get(
1366: p_msg_count => x_msg_count,
1367: p_msg_data => x_msg_data
1368: );

Line 1381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1377: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'OTHERS excpn: stmt no : '||to_char(l_stmt_num));
1378: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', sqlerrm);
1379: End if;
1380:
1381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1382: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1383: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1384: END IF;
1385: cto_msg_pub.count_and_get(

Line 1427: x_return_status := FND_API.G_RET_STS_SUCCESS;

1423: oe_debug_pub.add('inventory_unreservation_check: ' || 'Entering inventory_unreservation_check', 2);
1424: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check','Entering inventory_unreservation_check');
1425: End if;
1426:
1427: x_return_status := FND_API.G_RET_STS_SUCCESS;
1428: l_stmt_num := 10;
1429:
1430: select item_type_code, ato_line_id
1431: into v_item_type_code, v_ato_line_id

Line 1452: raise FND_API.G_EXC_ERROR;

1448: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'v_activity_status_code <> NOTIFIED');
1449: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1450: End if;
1451: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1452: raise FND_API.G_EXC_ERROR;
1453: end if;
1454: end if;
1455:
1456: --

Line 1489: raise FND_API.G_EXC_ERROR;

1485: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'v_activity_status_code <> NOTIFIED');
1486: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1487: End if;
1488: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1489: raise FND_API.G_EXC_ERROR;
1490: else
1491: IF PG_DEBUG <> 0 THEN
1492: oe_debug_pub.add ('inventory_unreservation_check: ' || 'Quantity being unreserved ('||p_rsv_quantity||') is okay.',4);
1493: END IF;

Line 1506: when FND_API.G_EXC_ERROR then

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

Line 1510: 'Raised FND_API.G_EXC_ERROR, stmt'||l_stmt_num);

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

Line 1512: x_return_status := FND_API.G_RET_STS_ERROR;

1508: oe_debug_pub.add('inventory_unreservation_check: ' || 'exp error in CTO_WORKFLOW_API_PK.inventory_unreservation_check::stmt number '||to_char(l_stmt_num), 1);
1509: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1510: 'Raised FND_API.G_EXC_ERROR, stmt'||l_stmt_num);
1511: End if;
1512: x_return_status := FND_API.G_RET_STS_ERROR;
1513: cto_msg_pub.count_and_get(
1514: p_msg_count => x_msg_count,
1515: p_msg_data => x_msg_data
1516: );

Line 1518: when FND_API.G_EXC_UNEXPECTED_ERROR then

1514: p_msg_count => x_msg_count,
1515: p_msg_data => x_msg_data
1516: );
1517:
1518: when FND_API.G_EXC_UNEXPECTED_ERROR then
1519: IF PG_DEBUG <> 0 THEN
1520: oe_debug_pub.add('inventory_unreservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_unreservation_check::stmt number '||to_char(l_stmt_num), 1);
1521: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1522: 'Raised FND_API.G_EXC_UNEXPECTED_ERROR, stmt'||l_stmt_num);

Line 1522: 'Raised FND_API.G_EXC_UNEXPECTED_ERROR, stmt'||l_stmt_num);

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

Line 1524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1520: oe_debug_pub.add('inventory_unreservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_unreservation_check::stmt number '||to_char(l_stmt_num), 1);
1521: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1522: 'Raised FND_API.G_EXC_UNEXPECTED_ERROR, stmt'||l_stmt_num);
1523: End if;
1524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1525: cto_msg_pub.count_and_get(
1526: p_msg_count => x_msg_count,
1527: p_msg_data => x_msg_data
1528: );

Line 1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1535: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1536: 'Raised OTHERS excepn, stmt: '||l_stmt_num);
1537: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', sqlerrm);
1538: End if;
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1540: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1541: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1542: END IF;
1543: cto_msg_pub.count_and_get(

Line 1659: x_return_status := FND_API.G_RET_STS_SUCCESS;

1655: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'In wf_update_after_inv_unreserv');
1656: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'Entering wf_update_after_inv_unreserv', 2);
1657: END IF;
1658:
1659: x_return_status := FND_API.G_RET_STS_SUCCESS;
1660: l_stmt_num := 10;
1661:
1662:
1663: -- Modified to get the split from line_id also

Line 1755: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1751: 'l_can_create_supply is=>'||l_can_create_supply,1);
1752:
1753: END IF;
1754:
1755: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1756: RAISE FND_API.G_EXC_ERROR;
1757: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1758: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1759: END IF;

Line 1756: RAISE FND_API.G_EXC_ERROR;

1752:
1753: END IF;
1754:
1755: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1756: RAISE FND_API.G_EXC_ERROR;
1757: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1758: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1759: END IF;
1760:

Line 1757: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1753: END IF;
1754:
1755: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1756: RAISE FND_API.G_EXC_ERROR;
1757: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1758: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1759: END IF;
1760:
1761: IF x_return_status = FND_API.G_RET_STS_SUCCESS

Line 1758: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1754:
1755: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1756: RAISE FND_API.G_EXC_ERROR;
1757: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1758: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1759: END IF;
1760:
1761: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1762: and

Line 1761: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1757: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1758: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1759: END IF;
1760:
1761: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1762: and
1763: l_can_create_supply = 'Y' THEN
1764:
1765: v_counter := 0;

Line 1908: IF (v_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1904: x_return_status => v_x_return_status,
1905: x_msg_count => v_x_msg_count,
1906: x_msg_data => v_x_msg_data);
1907:
1908: IF (v_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1909: IF PG_DEBUG <> 0 THEN
1910: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv',
1911: 'Failed in WSH_Integration_Pub.Get Tolerance');
1912: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'CTO:Failed in WSH_Integration_Pub.Get Tolerance :' || v_x_return_status, 1);

Line 1915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1911: 'Failed in WSH_Integration_Pub.Get Tolerance');
1912: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'CTO:Failed in WSH_Integration_Pub.Get Tolerance :' || v_x_return_status, 1);
1913: END IF;
1914: OE_MSG_PUB.ADD;
1915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1916: ELSE
1917: IF PG_DEBUG <> 0 THEN
1918: oe_debug_pub.add ('wf_update_after_inv_unreserv: ' || 'CTO: Returned from WSH_Integration_Pub.Get_Min_Max_Tolerance_Quantity.', 4);
1919:

Line 1993: IF (v_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1989: , x_return_status => v_x_return_status
1990: );
1991:
1992:
1993: IF (v_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1994:
1995: IF PG_DEBUG <> 0 THEN
1996: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv',
1997: 'WSH_INTERFACE.update_shipping_attributes');

Line 2001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1997: 'WSH_INTERFACE.update_shipping_attributes');
1998: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'CTO:Failed in WSH_INTERFACE.update_shipping_attributes :', 1);
1999: END IF;
2000: OE_MSG_PUB.ADD;
2001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2002: ELSE
2003: IF PG_DEBUG <> 0 THEN
2004: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || ' Renga: Success in update_shipping attributes..', 2);
2005: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserve',

Line 2029: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2025: Else
2026: if PG_DEBUG <> 0 Then
2027: oe_debug_pub.add('WF_UPDATE_AFTER_INV_RESERV: Complete_activity function returned error..',5);
2028: end if;
2029: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2030: End if;
2031: -- End of bug fix 5357300
2032: else
2033: IF PG_DEBUG <> 0 THEN

Line 2052: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2048: if PG_DEBUG <> 0 Then
2049: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Raising CTO_ERROR_FROM_DISPLAY_STATUS');
2050: End if;
2051: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
2052: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2053:
2054: end if;
2055: --end of fix for bug#1895563
2056:

Line 2075: when FND_API.G_EXC_ERROR then

2071: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'Exiting wf_update_after_inv_unreserv', 2);
2072: END IF;
2073:
2074: EXCEPTION
2075: when FND_API.G_EXC_ERROR then
2076:
2077: IF PG_DEBUG <> 0 THEN
2078: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'exp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_unreserv::stmt number '||to_char(l_stmt_num), 1);
2079: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','exp erro stmt no :'|| to_char(l_stmt_num));

Line 2082: x_return_status := FND_API.G_RET_STS_ERROR;

2078: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'exp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_unreserv::stmt number '||to_char(l_stmt_num), 1);
2079: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','exp erro stmt no :'|| to_char(l_stmt_num));
2080:
2081: END IF;
2082: x_return_status := FND_API.G_RET_STS_ERROR;
2083: cto_msg_pub.count_and_get(
2084: p_msg_count => x_msg_count,
2085: p_msg_data => x_msg_data
2086: );

Line 2088: when FND_API.G_EXC_UNEXPECTED_ERROR then

2084: p_msg_count => x_msg_count,
2085: p_msg_data => x_msg_data
2086: );
2087:
2088: when FND_API.G_EXC_UNEXPECTED_ERROR then
2089:
2090: IF PG_DEBUG <> 0 THEN
2091: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'unexp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_unreserv::stmt number '||to_char(l_stmt_num));
2092: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp err stmt no:'|| to_char(l_stmt_num));

Line 2095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2091: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'unexp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_unreserv::stmt number '||to_char(l_stmt_num));
2092: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp err stmt no:'|| to_char(l_stmt_num));
2093:
2094: END IF;
2095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2096: cto_msg_pub.count_and_get(
2097: p_msg_count => x_msg_count,
2098: p_msg_data => x_msg_data
2099: );

Line 2110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2106: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp errr stmt no :'|| to_char(l_stmt_num));
2107: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE',sqlerrm);
2108:
2109: END IF;
2110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2111: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2112: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2113: END IF;
2114: cto_msg_pub.count_and_get(

Line 2176: if (v_model_id is not NULL) AND (v_model_id <> fnd_api.g_miss_num) then

2172:
2173: --
2174: -- if not an ATO model line, condition is false, return 0
2175: --
2176: if (v_model_id is not NULL) AND (v_model_id <> fnd_api.g_miss_num) then
2177:
2178: -- check if the config item is created
2179: -- adding join to header_id for performance
2180:

Line 2868: if x_return_status = FND_API.G_RET_STS_ERROR THEN

2864: p_line_id => p_line_id,
2865: p_flow_status_code => p_change_status,
2866: x_return_status => x_return_status);
2867:
2868: if x_return_status = FND_API.G_RET_STS_ERROR THEN
2869: x_return_status := FND_API.G_RET_STS_SUCCESS; -- 5151111
2870: IF PG_DEBUG <> 0 THEN
2871: l_message:= 'Error occurred in updating line status to '||p_change_status||' - Stmt_num'||to_char(l_stmt_num);
2872: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);

Line 2869: x_return_status := FND_API.G_RET_STS_SUCCESS; -- 5151111

2865: p_flow_status_code => p_change_status,
2866: x_return_status => x_return_status);
2867:
2868: if x_return_status = FND_API.G_RET_STS_ERROR THEN
2869: x_return_status := FND_API.G_RET_STS_SUCCESS; -- 5151111
2870: IF PG_DEBUG <> 0 THEN
2871: l_message:= 'Error occurred in updating line status to '||p_change_status||' - Stmt_num'||to_char(l_stmt_num);
2872: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);
2873: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);

Line 2881: --raise FND_API.G_EXC_ERROR;

2877: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);
2878: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);
2879:
2880: END IF;
2881: --raise FND_API.G_EXC_ERROR;
2882:
2883: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2884: x_return_status := FND_API.G_RET_STS_SUCCESS; --5151111
2885: IF PG_DEBUG <> 0 THEN

Line 2883: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2879:
2880: END IF;
2881: --raise FND_API.G_EXC_ERROR;
2882:
2883: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2884: x_return_status := FND_API.G_RET_STS_SUCCESS; --5151111
2885: IF PG_DEBUG <> 0 THEN
2886: l_message:= 'UnExp Error occurred in updating line status to '||p_change_status||' - Stmt_num'||to_char(l_stmt_num);
2887: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);

Line 2884: x_return_status := FND_API.G_RET_STS_SUCCESS; --5151111

2880: END IF;
2881: --raise FND_API.G_EXC_ERROR;
2882:
2883: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2884: x_return_status := FND_API.G_RET_STS_SUCCESS; --5151111
2885: IF PG_DEBUG <> 0 THEN
2886: l_message:= 'UnExp Error occurred in updating line status to '||p_change_status||' - Stmt_num'||to_char(l_stmt_num);
2887: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);
2888: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);

Line 2895: --raise FND_API.G_EXC_UNEXPECTED_ERROR;

2891: l_message:= 'Progressing ahead even though line status may be wrong';
2892: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);
2893: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);
2894: END IF;
2895: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
2896:
2897: end if;
2898: IF PG_DEBUG <> 0 Then
2899: oe_debug_pub.add('Complete_activity : l_change_context_back = '||l_change_context_back,5);

Line 2917: WHEN FND_API.G_EXC_ERROR THEN

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

Line 2923: x_return_status := FND_API.G_RET_STS_ERROR;

2919: oe_debug_pub.add('Change_Status_Batch: ' || 'exp error in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);
2920: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','exp erro change_status_batch :: '||l_stmt_num||sqlerrm);
2921:
2922: END IF;
2923: x_return_status := FND_API.G_RET_STS_ERROR;
2924:
2925: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2926: IF PG_DEBUG <> 0 THEN
2927: oe_debug_pub.add('Change_Status_Batch: ' || 'unexp error in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);

Line 2925: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2927: oe_debug_pub.add('Change_Status_Batch: ' || 'unexp error in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);
2928: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','Unexp err change_status_batch :: '||l_stmt_num||sqlerrm);
2929: End if;
2930:
2931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2932:
2933: WHEN OTHERS THEN
2934: IF PG_DEBUG <> 0 THEN
2935: oe_debug_pub.add('Change_Status_Batch: ' || 'unexp error (others) in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);

Line 2940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2936: oe_debug_pub.add('Change_Status_Batch: ' || sqlerrm, 1);
2937: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','Unexp err change_status_batch :: '||l_stmt_num||sqlerrm);
2938:
2939: END IF;
2940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2941: END;
2942:
2943:
2944:

Line 3076: raise FND_API.G_EXC_ERROR;

3072: IF nvl(p_new_order_quantity, 0) = 0 THEN
3073: IF PG_DEBUG <> 0 THEN
3074: oe_debug_pub.add('auto_create_pur_req: ' || 'ERROR GET_NEW_ORDER_QTY:: The new order quantity is zero', 1);
3075: END IF;
3076: raise FND_API.G_EXC_ERROR;
3077: END IF;
3078: end;
3079:
3080: -- rkaza. 05/02/2005. ireq project

Line 3094: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3090: p_transit_lead_time => l_transit_lead_time,
3091: x_return_status => x_return_status,
3092: x_exp_error_code => l_exp_error_code );
3093:
3094: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3095: IF PG_DEBUG <> 0 THEN
3096: oe_debug_pub.add('auto_create_pur_req: ' || 'success from query sourcing org', 5);
3097: oe_debug_pub.add('auto_create_pur_req: ' || 'source_type = ' || l_req_input_data.source_type, 5);
3098: oe_debug_pub.add('auto_create_pur_req: ' || 'sourcing_org = ' || l_req_input_data.sourcing_org, 5);

Line 3100: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3096: oe_debug_pub.add('auto_create_pur_req: ' || 'success from query sourcing org', 5);
3097: oe_debug_pub.add('auto_create_pur_req: ' || 'source_type = ' || l_req_input_data.source_type, 5);
3098: oe_debug_pub.add('auto_create_pur_req: ' || 'sourcing_org = ' || l_req_input_data.sourcing_org, 5);
3099: END IF;
3100: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3101: IF PG_DEBUG <> 0 THEN
3102: oe_debug_pub.add('auto_create_pur_req: ' || 'unexpected error query sourcing org', 5);
3103: END IF;
3104: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3104: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3100: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3101: IF PG_DEBUG <> 0 THEN
3102: oe_debug_pub.add('auto_create_pur_req: ' || 'unexpected error query sourcing org', 5);
3103: END IF;
3104: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3105: END IF;
3106:
3107: l_stmt_num := 26;
3108:

Line 3117: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3113: p_schedule_ship_date => so_line.schedule_ship_date,
3114: x_need_by_date => l_need_by_date,
3115: x_return_status => x_return_status);
3116:
3117: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3118: IF PG_DEBUG <> 0 THEN
3119: oe_debug_pub.add('auto_create_pur_req: ' || 'success from get_need_by_date' || ' l_need_by_date=' || l_need_by_date, 5);
3120: END IF;
3121: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3121: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3117: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3118: IF PG_DEBUG <> 0 THEN
3119: oe_debug_pub.add('auto_create_pur_req: ' || 'success from get_need_by_date' || ' l_need_by_date=' || l_need_by_date, 5);
3120: END IF;
3121: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3122: IF PG_DEBUG <> 0 THEN
3123: oe_debug_pub.add('auto_create_pur_req: ' || 'unexpected error in get_need_by_date', 5);
3124: END IF;
3125: raise fnd_api.g_exc_unexpected_error;

Line 3125: raise fnd_api.g_exc_unexpected_error;

3121: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3122: IF PG_DEBUG <> 0 THEN
3123: oe_debug_pub.add('auto_create_pur_req: ' || 'unexpected error in get_need_by_date', 5);
3124: END IF;
3125: raise fnd_api.g_exc_unexpected_error;
3126: END IF;
3127:
3128: l_stmt_num := 25;
3129: --pthese attributes are for orders taken in OPM organizations

Line 3160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3156: p_req_interface_input_data => l_req_input_data,
3157: x_return_status => x_return_status );
3158:
3159: -- Log the error based on the x_return_status.
3160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3161: RAISE FND_API.G_EXC_ERROR;
3162:
3163: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3161: RAISE FND_API.G_EXC_ERROR;

3157: x_return_status => x_return_status );
3158:
3159: -- Log the error based on the x_return_status.
3160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3161: RAISE FND_API.G_EXC_ERROR;
3162:
3163: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3165:

Line 3163: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3159: -- Log the error based on the x_return_status.
3160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3161: RAISE FND_API.G_EXC_ERROR;
3162:
3163: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3165:
3166: ELSE
3167: IF PG_DEBUG <> 0 THEN

Line 3164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3161: RAISE FND_API.G_EXC_ERROR;
3162:
3163: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3165:
3166: ELSE
3167: IF PG_DEBUG <> 0 THEN
3168: oe_debug_pub.add('auto_create_pur_req: ' || 'Insert successful.',5);

Line 3179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3175: IF l_rets = 0 THEN
3176: IF PG_DEBUG <> 0 THEN
3177: oe_debug_pub.add('auto_create_pur_req: ' || 'UNExp Error occurred in call to display_wf_status at - Stmt_num'||to_char(l_stmt_num),1);
3178: END IF;
3179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3180: ELSE
3181: IF PG_DEBUG <> 0 THEN
3182: oe_debug_pub.add('auto_create_pur_req: ' || 'Order updated to REQ_REQUESTED.', 5);
3183: END IF;

Line 3198: WHEN FND_API.G_EXC_ERROR THEN

3194: OE_STANDARD_WF.Save_Messages;
3195: OE_STANDARD_WF.Clear_Msg_Context;
3196:
3197: EXCEPTION
3198: WHEN FND_API.G_EXC_ERROR THEN
3199: IF PG_DEBUG <> 0 THEN
3200: oe_debug_pub.add('auto_create_pur_req: ' || 'AUTO_CREATE_PUR_REQ::exp error::'||to_char(l_stmt_num),1);
3201: END IF;
3202: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3202: x_return_status := FND_API.G_RET_STS_ERROR;

3198: WHEN FND_API.G_EXC_ERROR THEN
3199: IF PG_DEBUG <> 0 THEN
3200: oe_debug_pub.add('auto_create_pur_req: ' || 'AUTO_CREATE_PUR_REQ::exp error::'||to_char(l_stmt_num),1);
3201: END IF;
3202: x_return_status := FND_API.G_RET_STS_ERROR;
3203: wf_core.context('CTO_WORKFLOW', 'auto_create_pur_req, stmt_num :'||to_char(l_stmt_num),p_itemtype, p_itemkey, to_char(p_actid),p_funcmode, 1);
3204: x_result := 'CTO_INCOMPLETE';
3205: rollback to before_process;
3206: return;

Line 3208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3204: x_result := 'CTO_INCOMPLETE';
3205: rollback to before_process;
3206: return;
3207:
3208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3209: IF PG_DEBUG <> 0 THEN
3210: oe_debug_pub.add('auto_create_pur_req: ' || 'AUTO_CREATE_PUR_REQ::unexp error::'||to_char(l_stmt_num),1);
3211: END IF;
3212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3209: IF PG_DEBUG <> 0 THEN
3210: oe_debug_pub.add('auto_create_pur_req: ' || 'AUTO_CREATE_PUR_REQ::unexp error::'||to_char(l_stmt_num),1);
3211: END IF;
3212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3213: wf_core.context('CTO_WORKFLOW', 'auto_create_pur_req, stmt_num :'||to_char(l_stmt_num),
3214: p_itemtype, p_itemkey, to_char(p_actid),
3215: p_funcmode);
3216: raise;

Line 3222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3218: WHEN OTHERS THEN
3219: IF PG_DEBUG <> 0 THEN
3220: oe_debug_pub.add('auto_create_pur_req: ' || 'AUTO_CREATE_PUR_REQ::other error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3221: END IF;
3222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3223: wf_core.context('CTO_WORKFLOW', 'auto_create_pur_req, stmt_num :'||to_char(l_stmt_num),
3224: p_itemtype, p_itemkey, to_char(p_actid),
3225: p_funcmode);
3226: raise;

Line 3580: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

3576: x_msg_count => l_msg_count,
3577: x_msg_data => l_msg_data
3578: );
3579:
3580: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3581: IF PG_DEBUG <> 0 THEN
3582: oe_debug_pub.add('get_status_tokens: '||'SUCCESS after Get_Resv_Qty',1);
3583: oe_debug_pub.add('get_status_tokens: '||'Sum of resv qty=>'||l_sum_rsv_qty,1);
3584: oe_debug_pub.add('get_status_tokens: '||'resv record count=>'||l_rsv_rec.count,1);

Line 3587: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3583: oe_debug_pub.add('get_status_tokens: '||'Sum of resv qty=>'||l_sum_rsv_qty,1);
3584: oe_debug_pub.add('get_status_tokens: '||'resv record count=>'||l_rsv_rec.count,1);
3585:
3586: END IF;
3587: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3588: IF PG_DEBUG <> 0 THEN
3589: oe_debug_pub.add('get_status_tokens: '||'status after after Get_Resv_Qty_and_Code=>'
3590: || FND_API.G_RET_STS_ERROR,1);
3591: END IF;

Line 3590: || FND_API.G_RET_STS_ERROR,1);

3586: END IF;
3587: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3588: IF PG_DEBUG <> 0 THEN
3589: oe_debug_pub.add('get_status_tokens: '||'status after after Get_Resv_Qty_and_Code=>'
3590: || FND_API.G_RET_STS_ERROR,1);
3591: END IF;
3592: RAISE fnd_api.g_exc_error;
3593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3594:

Line 3592: RAISE fnd_api.g_exc_error;

3588: IF PG_DEBUG <> 0 THEN
3589: oe_debug_pub.add('get_status_tokens: '||'status after after Get_Resv_Qty_and_Code=>'
3590: || FND_API.G_RET_STS_ERROR,1);
3591: END IF;
3592: RAISE fnd_api.g_exc_error;
3593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3594:
3595: IF PG_DEBUG <> 0 THEN
3596: oe_debug_pub.add('status after after Get_Resv_Qty_and_Code=>'

Line 3593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3589: oe_debug_pub.add('get_status_tokens: '||'status after after Get_Resv_Qty_and_Code=>'
3590: || FND_API.G_RET_STS_ERROR,1);
3591: END IF;
3592: RAISE fnd_api.g_exc_error;
3593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3594:
3595: IF PG_DEBUG <> 0 THEN
3596: oe_debug_pub.add('status after after Get_Resv_Qty_and_Code=>'
3597: || FND_API.G_RET_STS_UNEXP_ERROR,1 );

Line 3597: || FND_API.G_RET_STS_UNEXP_ERROR,1 );

3593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3594:
3595: IF PG_DEBUG <> 0 THEN
3596: oe_debug_pub.add('status after after Get_Resv_Qty_and_Code=>'
3597: || FND_API.G_RET_STS_UNEXP_ERROR,1 );
3598:
3599: END IF;
3600: RAISE fnd_api.g_exc_unexpected_error;
3601: END IF;

Line 3600: RAISE fnd_api.g_exc_unexpected_error;

3596: oe_debug_pub.add('status after after Get_Resv_Qty_and_Code=>'
3597: || FND_API.G_RET_STS_UNEXP_ERROR,1 );
3598:
3599: END IF;
3600: RAISE fnd_api.g_exc_unexpected_error;
3601: END IF;
3602: -- If there is no supply tied to this line
3603: -- Then the status should be as follows.
3604: l_stmt_num :=20;

Line 3620: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3616: X_msg_data => l_msg_data,
3617: x_sourcing_org => l_sourcing_org,
3618: x_message => l_return_msg
3619: );
3620: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3621: RAISE FND_API.G_EXC_ERROR;
3622: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3624: END IF;

Line 3621: RAISE FND_API.G_EXC_ERROR;

3617: x_sourcing_org => l_sourcing_org,
3618: x_message => l_return_msg
3619: );
3620: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3621: RAISE FND_API.G_EXC_ERROR;
3622: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3624: END IF;
3625:

Line 3622: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3618: x_message => l_return_msg
3619: );
3620: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3621: RAISE FND_API.G_EXC_ERROR;
3622: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3624: END IF;
3625:
3626: IF l_can_create_supply = 'N' THEN

Line 3623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3619: );
3620: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3621: RAISE FND_API.G_EXC_ERROR;
3622: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3624: END IF;
3625:
3626: IF l_can_create_supply = 'N' THEN
3627: x_token1 := 'AWAITING';

Line 3761: WHEN fnd_api.g_exc_error THEN

3757: End if; /* l_rsv_rec.count = 0 */
3758:
3759: EXCEPTION--4752854,fixed as part of code review
3760:
3761: WHEN fnd_api.g_exc_error THEN
3762: IF PG_DEBUG <> 0 THEN
3763: oe_debug_pub.add('get_status_tokens: ' || 'Exception in stmt num: '
3764: || to_char(l_stmt_num), 1);
3765: END IF;

Line 3766: x_return_status := FND_API.G_RET_STS_ERROR;

3762: IF PG_DEBUG <> 0 THEN
3763: oe_debug_pub.add('get_status_tokens: ' || 'Exception in stmt num: '
3764: || to_char(l_stmt_num), 1);
3765: END IF;
3766: x_return_status := FND_API.G_RET_STS_ERROR;
3767: -- Get message count and data
3768: cto_msg_pub.count_and_get
3769: ( p_msg_count => x_msg_count
3770: , p_msg_data => x_msg_data

Line 3772: WHEN fnd_api.g_exc_unexpected_error THEN

3768: cto_msg_pub.count_and_get
3769: ( p_msg_count => x_msg_count
3770: , p_msg_data => x_msg_data
3771: );
3772: WHEN fnd_api.g_exc_unexpected_error THEN
3773: IF PG_DEBUG <> 0 THEN
3774: oe_debug_pub.add('get_status_tokens: '|| ' Unexpected Exception in stmt num: '
3775: || to_char(l_stmt_num), 1);
3776: END IF;

Line 3777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3773: IF PG_DEBUG <> 0 THEN
3774: oe_debug_pub.add('get_status_tokens: '|| ' Unexpected Exception in stmt num: '
3775: || to_char(l_stmt_num), 1);
3776: END IF;
3777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3778: -- Get message count and data
3779: cto_msg_pub.count_and_get
3780: ( p_msg_count => x_msg_count
3781: , p_msg_data => x_msg_data

Line 3791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3787: oe_debug_pub.add('get_status_tokens: '||'errmsg'||sqlerrm,1);
3788: oe_debug_pub.add('get_status_tokens: ' || 'Others Exception in stmt num: '
3789: || to_char(l_stmt_num), 1);
3790: END IF;
3791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3792: -- Get message count and data
3793: cto_msg_pub.count_and_get
3794: ( p_msg_count => x_msg_count
3795: , p_msg_data => x_msg_data