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

APPS.CTO_WORKFLOW_API_PK dependencies on FND_API

Line 657: if x_return_status = FND_API.G_RET_STS_ERROR then

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

Line 662: raise FND_API.G_EXC_ERROR;

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

Line 663: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 668: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 684: when FND_API.G_EXC_ERROR then

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

Line 692: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

Line 758: x_return_status := FND_API.G_RET_STS_SUCCESS;

754: oe_debug_pub.add('inventory_reservation_check: ' || 'Entering inventory_reservation_check', 2);
755: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'In inventory_reservation_check');
756: End if;
757:
758: x_return_status := FND_API.G_RET_STS_SUCCESS;
759:
760: l_stmt_num := 10;
761:
762: select upper(item_type_code)

Line 843: raise FND_API.G_EXC_ERROR;

839: exception
840: when DROPSHIP_EXCEPTION then
841: cto_msg_pub.cto_message('BOM', 'CTO_RESERVATION_INELIGIBLE');
842:
843: raise FND_API.G_EXC_ERROR;
844:
845: when others then
846: raise FND_API.G_EXC_UNEXPECTED_ERROR;
847:

Line 846: raise FND_API.G_EXC_UNEXPECTED_ERROR;

842:
843: raise FND_API.G_EXC_ERROR;
844:
845: when others then
846: raise FND_API.G_EXC_UNEXPECTED_ERROR;
847:
848: end;
849:
850: end if ;

Line 892: raise FND_API.G_EXC_ERROR;

888: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'v_activity_status_code <> NOTIFIED');
889: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
890: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
891: End if;
892: raise FND_API.G_EXC_ERROR;
893: end if;
894: end if;
895: end if;
896:

Line 904: when FND_API.G_EXC_ERROR then

900: oe_debug_pub.add('inventory_reservation_check: ' || 'Exiting inventory_reservation_check', 2);
901: END IF;
902:
903: EXCEPTION
904: when FND_API.G_EXC_ERROR then
905: IF PG_DEBUG <> 0 THEN
906: oe_debug_pub.add('inventory_reservation_check: ' || 'exp error in CTO_WORKFLOW_API_PK.inventory_reservation_check::stmt number '||to_char(l_stmt_num), 1);
907: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no :'|| to_char(l_stmt_num));
908: End if;

Line 910: x_return_status := FND_API.G_RET_STS_ERROR;

906: oe_debug_pub.add('inventory_reservation_check: ' || 'exp error in CTO_WORKFLOW_API_PK.inventory_reservation_check::stmt number '||to_char(l_stmt_num), 1);
907: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no :'|| to_char(l_stmt_num));
908: End if;
909:
910: x_return_status := FND_API.G_RET_STS_ERROR;
911: cto_msg_pub.count_and_get(
912: p_msg_count => x_msg_count,
913: p_msg_data => x_msg_data
914: );

Line 915: when FND_API.G_EXC_UNEXPECTED_ERROR then

911: cto_msg_pub.count_and_get(
912: p_msg_count => x_msg_count,
913: p_msg_data => x_msg_data
914: );
915: when FND_API.G_EXC_UNEXPECTED_ERROR then
916: IF PG_DEBUG <> 0 THEN
917: oe_debug_pub.add('inventory_reservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_reservation_check::stmt number '||to_char(l_stmt_num), 1);
918: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no:'|| to_char(l_stmt_num));
919: End if;

Line 920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

930: oe_debug_pub.add('inventory_reservation_check: ' || sqlerrm);
931: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no:'||to_char(l_stmt_num) );
932: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check', sqlerrm);
933: End if;
934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
936: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
937: END IF;
938: cto_msg_pub.count_and_get(

Line 993: x_return_status := FND_API.G_RET_STS_SUCCESS;

989:
990: IF PG_DEBUG <> 0 THEN
991: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Entering wf_update_after_inv_reserv', 2);
992: END IF;
993: x_return_status := FND_API.G_RET_STS_SUCCESS;
994: l_stmt_num := 10;
995:
996: If PG_DEBUG <> 0 Then
997: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'Before selecting info from oe_order_lines_all');

Line 1068: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1064: Else
1065: if PG_DEBUG <> 0 Then
1066: oe_debug_pub.add('WF_UPDATE_AFTER_INV_RESERV: Complete_activity function returned error..',5);
1067: end if;
1068: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1069: End if;
1070:
1071: -- End of MOAC Change
1072:

Line 1180: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1176: If PG_DEBUG <> 0 Then
1177: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Raising CTO_ERROR_FROM_DISPLAY_STATUS');
1178: End if;
1179: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
1180: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1181: end if;
1182:
1183:
1184: elsif upper(v_item_type_code) = 'CONFIG' then

Line 1233: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1229: Else
1230: if PG_DEBUG <> 0 Then
1231: oe_debug_pub.add('WF_UPDATE_AFTER_INV_RESERV: Complete_activity function returned error..',5);
1232: end if;
1233: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1234: End if;
1235:
1236: -- End of MOAC Change
1237:

Line 1284: raise FND_API.G_EXC_ERROR;

1280: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_reserv', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1281: End if;
1282:
1283: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1284: raise FND_API.G_EXC_ERROR;
1285: end if;
1286:
1287: END IF; /* end of v_activity_status_code check */
1288:

Line 1311: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1307: IF PG_DEBUG <> 0 Then
1308: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Raising CTO_ERROR_FROM_DISPLAY_STATUS');
1309: End if;
1310: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
1311: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1312: END IF;
1313:
1314: end if; /* end of item_type_code check */
1315: If PG_DEBUG <> 0 then

Line 1323: when FND_API.G_EXC_ERROR then

1319: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Exiting wf_update_after_inv_reserv', 2);
1320: END IF;
1321:
1322: EXCEPTION
1323: when FND_API.G_EXC_ERROR then
1324: IF PG_DEBUG <> 0 THEN
1325: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'exp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_reserv::stmt number '||to_char(l_stmt_num), 1);
1326: END IF;
1327:

Line 1334: x_return_status := FND_API.G_RET_STS_ERROR;

1330: 'Exp error in CTO_WORKFLOW_API_PK.wf_update_inv_reserv::
1331: stmt no : '||to_char(l_stmt_num)||'::'||sqlerrm);
1332: End if;
1333:
1334: x_return_status := FND_API.G_RET_STS_ERROR;
1335: cto_msg_pub.count_and_get(
1336: p_msg_count => x_msg_count,
1337: p_msg_data => x_msg_data
1338: );

Line 1340: when FND_API.G_EXC_UNEXPECTED_ERROR then

1336: p_msg_count => x_msg_count,
1337: p_msg_data => x_msg_data
1338: );
1339:
1340: when FND_API.G_EXC_UNEXPECTED_ERROR then
1341: IF PG_DEBUG <> 0 THEN
1342: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'unexp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_reserv::stmt number '||to_char(l_stmt_num), 1);
1343: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',
1344: 'UNExp error in CTO_WORKFLOW_API_PK.wf_update_inv_reserv::

Line 1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1361: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'OTHERS excpn: stmt no : '||to_char(l_stmt_num));
1362: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', sqlerrm);
1363: End if;
1364:
1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1366: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1367: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1368: END IF;
1369: cto_msg_pub.count_and_get(

Line 1411: x_return_status := FND_API.G_RET_STS_SUCCESS;

1407: oe_debug_pub.add('inventory_unreservation_check: ' || 'Entering inventory_unreservation_check', 2);
1408: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check','Entering inventory_unreservation_check');
1409: End if;
1410:
1411: x_return_status := FND_API.G_RET_STS_SUCCESS;
1412: l_stmt_num := 10;
1413:
1414: select item_type_code, ato_line_id
1415: into v_item_type_code, v_ato_line_id

Line 1436: raise FND_API.G_EXC_ERROR;

1432: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'v_activity_status_code <> NOTIFIED');
1433: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1434: End if;
1435: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1436: raise FND_API.G_EXC_ERROR;
1437: end if;
1438: end if;
1439:
1440: --

Line 1468: raise FND_API.G_EXC_ERROR;

1464: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'v_activity_status_code <> NOTIFIED');
1465: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1466: End if;
1467: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1468: raise FND_API.G_EXC_ERROR;
1469: else
1470: IF PG_DEBUG <> 0 THEN
1471: oe_debug_pub.add ('inventory_unreservation_check: ' || 'Quantity being unreserved ('||p_rsv_quantity||') is okay.',4);
1472: END IF;

Line 1485: when FND_API.G_EXC_ERROR then

1481: End if;
1482:
1483: EXCEPTION
1484:
1485: when FND_API.G_EXC_ERROR then
1486: IF PG_DEBUG <> 0 THEN
1487: oe_debug_pub.add('inventory_unreservation_check: ' || 'exp error in CTO_WORKFLOW_API_PK.inventory_unreservation_check::stmt number '||to_char(l_stmt_num), 1);
1488: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1489: 'Raised FND_API.G_EXC_ERROR, stmt'||l_stmt_num);

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

1485: when FND_API.G_EXC_ERROR then
1486: IF PG_DEBUG <> 0 THEN
1487: oe_debug_pub.add('inventory_unreservation_check: ' || 'exp error in CTO_WORKFLOW_API_PK.inventory_unreservation_check::stmt number '||to_char(l_stmt_num), 1);
1488: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1489: 'Raised FND_API.G_EXC_ERROR, stmt'||l_stmt_num);
1490: End if;
1491: x_return_status := FND_API.G_RET_STS_ERROR;
1492: cto_msg_pub.count_and_get(
1493: p_msg_count => x_msg_count,

Line 1491: x_return_status := FND_API.G_RET_STS_ERROR;

1487: oe_debug_pub.add('inventory_unreservation_check: ' || 'exp error in CTO_WORKFLOW_API_PK.inventory_unreservation_check::stmt number '||to_char(l_stmt_num), 1);
1488: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1489: 'Raised FND_API.G_EXC_ERROR, stmt'||l_stmt_num);
1490: End if;
1491: x_return_status := FND_API.G_RET_STS_ERROR;
1492: cto_msg_pub.count_and_get(
1493: p_msg_count => x_msg_count,
1494: p_msg_data => x_msg_data
1495: );

Line 1497: when FND_API.G_EXC_UNEXPECTED_ERROR then

1493: p_msg_count => x_msg_count,
1494: p_msg_data => x_msg_data
1495: );
1496:
1497: when FND_API.G_EXC_UNEXPECTED_ERROR then
1498: IF PG_DEBUG <> 0 THEN
1499: oe_debug_pub.add('inventory_unreservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_unreservation_check::stmt number '||to_char(l_stmt_num), 1);
1500: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1501: 'Raised FND_API.G_EXC_UNEXPECTED_ERROR, stmt'||l_stmt_num);

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

1497: when FND_API.G_EXC_UNEXPECTED_ERROR then
1498: IF PG_DEBUG <> 0 THEN
1499: oe_debug_pub.add('inventory_unreservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_unreservation_check::stmt number '||to_char(l_stmt_num), 1);
1500: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1501: 'Raised FND_API.G_EXC_UNEXPECTED_ERROR, stmt'||l_stmt_num);
1502: End if;
1503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1504: cto_msg_pub.count_and_get(
1505: p_msg_count => x_msg_count,

Line 1503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1499: oe_debug_pub.add('inventory_unreservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_unreservation_check::stmt number '||to_char(l_stmt_num), 1);
1500: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1501: 'Raised FND_API.G_EXC_UNEXPECTED_ERROR, stmt'||l_stmt_num);
1502: End if;
1503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1504: cto_msg_pub.count_and_get(
1505: p_msg_count => x_msg_count,
1506: p_msg_data => x_msg_data
1507: );

Line 1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1514: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1515: 'Raised OTHERS excepn, stmt: '||l_stmt_num);
1516: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', sqlerrm);
1517: End if;
1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1519: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1520: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1521: END IF;
1522: cto_msg_pub.count_and_get(

Line 1638: x_return_status := FND_API.G_RET_STS_SUCCESS;

1634: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'In wf_update_after_inv_unreserv');
1635: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'Entering wf_update_after_inv_unreserv', 2);
1636: END IF;
1637:
1638: x_return_status := FND_API.G_RET_STS_SUCCESS;
1639: l_stmt_num := 10;
1640:
1641:
1642: -- Modified to get the split from line_id also

Line 1728: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1724: 'l_can_create_supply is=>'||l_can_create_supply,1);
1725:
1726: END IF;
1727:
1728: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1729: RAISE FND_API.G_EXC_ERROR;
1730: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1731: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1732: END IF;

Line 1729: RAISE FND_API.G_EXC_ERROR;

1725:
1726: END IF;
1727:
1728: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1729: RAISE FND_API.G_EXC_ERROR;
1730: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1731: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1732: END IF;
1733:

Line 1730: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1726: END IF;
1727:
1728: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1729: RAISE FND_API.G_EXC_ERROR;
1730: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1731: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1732: END IF;
1733:
1734: IF x_return_status = FND_API.G_RET_STS_SUCCESS

Line 1731: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1727:
1728: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1729: RAISE FND_API.G_EXC_ERROR;
1730: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1731: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1732: END IF;
1733:
1734: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1735: and

Line 1734: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1730: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1731: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1732: END IF;
1733:
1734: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1735: and
1736: l_can_create_supply = 'Y' THEN
1737:
1738: v_counter := 0;

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

1877: x_return_status => v_x_return_status,
1878: x_msg_count => v_x_msg_count,
1879: x_msg_data => v_x_msg_data);
1880:
1881: IF (v_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1882: IF PG_DEBUG <> 0 THEN
1883: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv',
1884: 'Failed in WSH_Integration_Pub.Get Tolerance');
1885: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'CTO:Failed in WSH_Integration_Pub.Get Tolerance :' || v_x_return_status, 1);

Line 1888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1884: 'Failed in WSH_Integration_Pub.Get Tolerance');
1885: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'CTO:Failed in WSH_Integration_Pub.Get Tolerance :' || v_x_return_status, 1);
1886: END IF;
1887: OE_MSG_PUB.ADD;
1888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1889: ELSE
1890: IF PG_DEBUG <> 0 THEN
1891: oe_debug_pub.add ('wf_update_after_inv_unreserv: ' || 'CTO: Returned from WSH_Integration_Pub.Get_Min_Max_Tolerance_Quantity.', 4);
1892:

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

1962: , x_return_status => v_x_return_status
1963: );
1964:
1965:
1966: IF (v_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1967:
1968: IF PG_DEBUG <> 0 THEN
1969: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv',
1970: 'WSH_INTERFACE.update_shipping_attributes');

Line 1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1970: 'WSH_INTERFACE.update_shipping_attributes');
1971: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'CTO:Failed in WSH_INTERFACE.update_shipping_attributes :', 1);
1972: END IF;
1973: OE_MSG_PUB.ADD;
1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1975: ELSE
1976: IF PG_DEBUG <> 0 THEN
1977: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || ' Renga: Success in update_shipping attributes..', 2);
1978: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserve',

Line 2002: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1998: Else
1999: if PG_DEBUG <> 0 Then
2000: oe_debug_pub.add('WF_UPDATE_AFTER_INV_RESERV: Complete_activity function returned error..',5);
2001: end if;
2002: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2003: End if;
2004: -- End of bug fix 5357300
2005: else
2006: IF PG_DEBUG <> 0 THEN

Line 2025: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2021: if PG_DEBUG <> 0 Then
2022: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Raising CTO_ERROR_FROM_DISPLAY_STATUS');
2023: End if;
2024: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
2025: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2026:
2027: end if;
2028: --end of fix for bug#1895563
2029:

Line 2048: when FND_API.G_EXC_ERROR then

2044: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'Exiting wf_update_after_inv_unreserv', 2);
2045: END IF;
2046:
2047: EXCEPTION
2048: when FND_API.G_EXC_ERROR then
2049:
2050: IF PG_DEBUG <> 0 THEN
2051: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'exp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_unreserv::stmt number '||to_char(l_stmt_num), 1);
2052: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','exp erro stmt no :'|| to_char(l_stmt_num));

Line 2055: x_return_status := FND_API.G_RET_STS_ERROR;

2051: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'exp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_unreserv::stmt number '||to_char(l_stmt_num), 1);
2052: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','exp erro stmt no :'|| to_char(l_stmt_num));
2053:
2054: END IF;
2055: x_return_status := FND_API.G_RET_STS_ERROR;
2056: cto_msg_pub.count_and_get(
2057: p_msg_count => x_msg_count,
2058: p_msg_data => x_msg_data
2059: );

Line 2061: when FND_API.G_EXC_UNEXPECTED_ERROR then

2057: p_msg_count => x_msg_count,
2058: p_msg_data => x_msg_data
2059: );
2060:
2061: when FND_API.G_EXC_UNEXPECTED_ERROR then
2062:
2063: IF PG_DEBUG <> 0 THEN
2064: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'unexp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_unreserv::stmt number '||to_char(l_stmt_num));
2065: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp err stmt no:'|| to_char(l_stmt_num));

Line 2068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2064: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'unexp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_unreserv::stmt number '||to_char(l_stmt_num));
2065: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp err stmt no:'|| to_char(l_stmt_num));
2066:
2067: END IF;
2068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2069: cto_msg_pub.count_and_get(
2070: p_msg_count => x_msg_count,
2071: p_msg_data => x_msg_data
2072: );

Line 2083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2079: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp errr stmt no :'|| to_char(l_stmt_num));
2080: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE',sqlerrm);
2081:
2082: END IF;
2083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2084: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2085: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2086: END IF;
2087: cto_msg_pub.count_and_get(

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

2145:
2146: --
2147: -- if not an ATO model line, condition is false, return 0
2148: --
2149: if (v_model_id is not NULL) AND (v_model_id <> fnd_api.g_miss_num) then
2150:
2151: -- check if the config item is created
2152: -- adding join to header_id for performance
2153:

Line 2838: if x_return_status = FND_API.G_RET_STS_ERROR THEN

2834: p_line_id => p_line_id,
2835: p_flow_status_code => p_change_status,
2836: x_return_status => x_return_status);
2837:
2838: if x_return_status = FND_API.G_RET_STS_ERROR THEN
2839: x_return_status := FND_API.G_RET_STS_SUCCESS; -- 5151111
2840: IF PG_DEBUG <> 0 THEN
2841: l_message:= 'Error occurred in updating line status to '||p_change_status||' - Stmt_num'||to_char(l_stmt_num);
2842: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);

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

2835: p_flow_status_code => p_change_status,
2836: x_return_status => x_return_status);
2837:
2838: if x_return_status = FND_API.G_RET_STS_ERROR THEN
2839: x_return_status := FND_API.G_RET_STS_SUCCESS; -- 5151111
2840: IF PG_DEBUG <> 0 THEN
2841: l_message:= 'Error occurred in updating line status to '||p_change_status||' - Stmt_num'||to_char(l_stmt_num);
2842: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);
2843: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);

Line 2851: --raise FND_API.G_EXC_ERROR;

2847: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);
2848: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);
2849:
2850: END IF;
2851: --raise FND_API.G_EXC_ERROR;
2852:
2853: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2854: x_return_status := FND_API.G_RET_STS_SUCCESS; --5151111
2855: IF PG_DEBUG <> 0 THEN

Line 2853: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2849:
2850: END IF;
2851: --raise FND_API.G_EXC_ERROR;
2852:
2853: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2854: x_return_status := FND_API.G_RET_STS_SUCCESS; --5151111
2855: IF PG_DEBUG <> 0 THEN
2856: l_message:= 'UnExp Error occurred in updating line status to '||p_change_status||' - Stmt_num'||to_char(l_stmt_num);
2857: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);

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

2850: END IF;
2851: --raise FND_API.G_EXC_ERROR;
2852:
2853: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2854: x_return_status := FND_API.G_RET_STS_SUCCESS; --5151111
2855: IF PG_DEBUG <> 0 THEN
2856: l_message:= 'UnExp Error occurred in updating line status to '||p_change_status||' - Stmt_num'||to_char(l_stmt_num);
2857: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);
2858: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);

Line 2865: --raise FND_API.G_EXC_UNEXPECTED_ERROR;

2861: l_message:= 'Progressing ahead even though line status may be wrong';
2862: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);
2863: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);
2864: END IF;
2865: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
2866:
2867: end if;
2868: IF PG_DEBUG <> 0 Then
2869: oe_debug_pub.add('Complete_activity : l_change_context_back = '||l_change_context_back,5);

Line 2887: WHEN FND_API.G_EXC_ERROR THEN

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

Line 2893: x_return_status := FND_API.G_RET_STS_ERROR;

2889: oe_debug_pub.add('Change_Status_Batch: ' || 'exp error in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);
2890: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','exp erro change_status_batch :: '||l_stmt_num||sqlerrm);
2891:
2892: END IF;
2893: x_return_status := FND_API.G_RET_STS_ERROR;
2894:
2895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2896: IF PG_DEBUG <> 0 THEN
2897: oe_debug_pub.add('Change_Status_Batch: ' || 'unexp error in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);

Line 2895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2897: oe_debug_pub.add('Change_Status_Batch: ' || 'unexp error in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);
2898: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','Unexp err change_status_batch :: '||l_stmt_num||sqlerrm);
2899: End if;
2900:
2901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2902:
2903: WHEN OTHERS THEN
2904: IF PG_DEBUG <> 0 THEN
2905: oe_debug_pub.add('Change_Status_Batch: ' || 'unexp error (others) in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);

Line 2910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2906: oe_debug_pub.add('Change_Status_Batch: ' || sqlerrm, 1);
2907: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','Unexp err change_status_batch :: '||l_stmt_num||sqlerrm);
2908:
2909: END IF;
2910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2911: END;
2912:
2913:
2914:

Line 3046: raise FND_API.G_EXC_ERROR;

3042: IF nvl(p_new_order_quantity, 0) = 0 THEN
3043: IF PG_DEBUG <> 0 THEN
3044: oe_debug_pub.add('auto_create_pur_req: ' || 'ERROR GET_NEW_ORDER_QTY:: The new order quantity is zero', 1);
3045: END IF;
3046: raise FND_API.G_EXC_ERROR;
3047: END IF;
3048: end;
3049:
3050: -- rkaza. 05/02/2005. ireq project

Line 3064: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3060: p_transit_lead_time => l_transit_lead_time,
3061: x_return_status => x_return_status,
3062: x_exp_error_code => l_exp_error_code );
3063:
3064: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3065: IF PG_DEBUG <> 0 THEN
3066: oe_debug_pub.add('auto_create_pur_req: ' || 'success from query sourcing org', 5);
3067: oe_debug_pub.add('auto_create_pur_req: ' || 'source_type = ' || l_req_input_data.source_type, 5);
3068: oe_debug_pub.add('auto_create_pur_req: ' || 'sourcing_org = ' || l_req_input_data.sourcing_org, 5);

Line 3070: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3066: oe_debug_pub.add('auto_create_pur_req: ' || 'success from query sourcing org', 5);
3067: oe_debug_pub.add('auto_create_pur_req: ' || 'source_type = ' || l_req_input_data.source_type, 5);
3068: oe_debug_pub.add('auto_create_pur_req: ' || 'sourcing_org = ' || l_req_input_data.sourcing_org, 5);
3069: END IF;
3070: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3071: IF PG_DEBUG <> 0 THEN
3072: oe_debug_pub.add('auto_create_pur_req: ' || 'unexpected error query sourcing org', 5);
3073: END IF;
3074: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3074: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3070: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3071: IF PG_DEBUG <> 0 THEN
3072: oe_debug_pub.add('auto_create_pur_req: ' || 'unexpected error query sourcing org', 5);
3073: END IF;
3074: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3075: END IF;
3076:
3077: l_stmt_num := 26;
3078:

Line 3087: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3083: p_schedule_ship_date => so_line.schedule_ship_date,
3084: x_need_by_date => l_need_by_date,
3085: x_return_status => x_return_status);
3086:
3087: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3088: IF PG_DEBUG <> 0 THEN
3089: oe_debug_pub.add('auto_create_pur_req: ' || 'success from get_need_by_date' || ' l_need_by_date=' || l_need_by_date, 5);
3090: END IF;
3091: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3091: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3087: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3088: IF PG_DEBUG <> 0 THEN
3089: oe_debug_pub.add('auto_create_pur_req: ' || 'success from get_need_by_date' || ' l_need_by_date=' || l_need_by_date, 5);
3090: END IF;
3091: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3092: IF PG_DEBUG <> 0 THEN
3093: oe_debug_pub.add('auto_create_pur_req: ' || 'unexpected error in get_need_by_date', 5);
3094: END IF;
3095: raise fnd_api.g_exc_unexpected_error;

Line 3095: raise fnd_api.g_exc_unexpected_error;

3091: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3092: IF PG_DEBUG <> 0 THEN
3093: oe_debug_pub.add('auto_create_pur_req: ' || 'unexpected error in get_need_by_date', 5);
3094: END IF;
3095: raise fnd_api.g_exc_unexpected_error;
3096: END IF;
3097:
3098: l_stmt_num := 25;
3099: --pthese attributes are for orders taken in OPM organizations

Line 3130: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3126: p_req_interface_input_data => l_req_input_data,
3127: x_return_status => x_return_status );
3128:
3129: -- Log the error based on the x_return_status.
3130: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3131: RAISE FND_API.G_EXC_ERROR;
3132:
3133: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3131: RAISE FND_API.G_EXC_ERROR;

3127: x_return_status => x_return_status );
3128:
3129: -- Log the error based on the x_return_status.
3130: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3131: RAISE FND_API.G_EXC_ERROR;
3132:
3133: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3135:

Line 3133: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3129: -- Log the error based on the x_return_status.
3130: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3131: RAISE FND_API.G_EXC_ERROR;
3132:
3133: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3135:
3136: ELSE
3137: IF PG_DEBUG <> 0 THEN

Line 3134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3130: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3131: RAISE FND_API.G_EXC_ERROR;
3132:
3133: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3135:
3136: ELSE
3137: IF PG_DEBUG <> 0 THEN
3138: oe_debug_pub.add('auto_create_pur_req: ' || 'Insert successful.',5);

Line 3149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3145: IF l_rets = 0 THEN
3146: IF PG_DEBUG <> 0 THEN
3147: 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);
3148: END IF;
3149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3150: ELSE
3151: IF PG_DEBUG <> 0 THEN
3152: oe_debug_pub.add('auto_create_pur_req: ' || 'Order updated to REQ_REQUESTED.', 5);
3153: END IF;

Line 3168: WHEN FND_API.G_EXC_ERROR THEN

3164: OE_STANDARD_WF.Save_Messages;
3165: OE_STANDARD_WF.Clear_Msg_Context;
3166:
3167: EXCEPTION
3168: WHEN FND_API.G_EXC_ERROR THEN
3169: IF PG_DEBUG <> 0 THEN
3170: oe_debug_pub.add('auto_create_pur_req: ' || 'AUTO_CREATE_PUR_REQ::exp error::'||to_char(l_stmt_num),1);
3171: END IF;
3172: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3172: x_return_status := FND_API.G_RET_STS_ERROR;

3168: WHEN FND_API.G_EXC_ERROR THEN
3169: IF PG_DEBUG <> 0 THEN
3170: oe_debug_pub.add('auto_create_pur_req: ' || 'AUTO_CREATE_PUR_REQ::exp error::'||to_char(l_stmt_num),1);
3171: END IF;
3172: x_return_status := FND_API.G_RET_STS_ERROR;
3173: 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);
3174: x_result := 'CTO_INCOMPLETE';
3175: rollback to before_process;
3176: return;

Line 3178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3174: x_result := 'CTO_INCOMPLETE';
3175: rollback to before_process;
3176: return;
3177:
3178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3179: IF PG_DEBUG <> 0 THEN
3180: oe_debug_pub.add('auto_create_pur_req: ' || 'AUTO_CREATE_PUR_REQ::unexp error::'||to_char(l_stmt_num),1);
3181: END IF;
3182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3179: IF PG_DEBUG <> 0 THEN
3180: oe_debug_pub.add('auto_create_pur_req: ' || 'AUTO_CREATE_PUR_REQ::unexp error::'||to_char(l_stmt_num),1);
3181: END IF;
3182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3183: wf_core.context('CTO_WORKFLOW', 'auto_create_pur_req, stmt_num :'||to_char(l_stmt_num),
3184: p_itemtype, p_itemkey, to_char(p_actid),
3185: p_funcmode);
3186: raise;

Line 3192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3188: WHEN OTHERS THEN
3189: IF PG_DEBUG <> 0 THEN
3190: oe_debug_pub.add('auto_create_pur_req: ' || 'AUTO_CREATE_PUR_REQ::other error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3191: END IF;
3192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3193: wf_core.context('CTO_WORKFLOW', 'auto_create_pur_req, stmt_num :'||to_char(l_stmt_num),
3194: p_itemtype, p_itemkey, to_char(p_actid),
3195: p_funcmode);
3196: raise;

Line 3548: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

3544: x_msg_count => l_msg_count,
3545: x_msg_data => l_msg_data
3546: );
3547:
3548: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3549: IF PG_DEBUG <> 0 THEN
3550: oe_debug_pub.add('get_status_tokens: '||'SUCCESS after Get_Resv_Qty',1);
3551: oe_debug_pub.add('get_status_tokens: '||'Sum of resv qty=>'||l_sum_rsv_qty,1);
3552: oe_debug_pub.add('get_status_tokens: '||'resv record count=>'||l_rsv_rec.count,1);

Line 3555: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3551: oe_debug_pub.add('get_status_tokens: '||'Sum of resv qty=>'||l_sum_rsv_qty,1);
3552: oe_debug_pub.add('get_status_tokens: '||'resv record count=>'||l_rsv_rec.count,1);
3553:
3554: END IF;
3555: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3556: IF PG_DEBUG <> 0 THEN
3557: oe_debug_pub.add('get_status_tokens: '||'status after after Get_Resv_Qty_and_Code=>'
3558: || FND_API.G_RET_STS_ERROR,1);
3559: END IF;

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

3554: END IF;
3555: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3556: IF PG_DEBUG <> 0 THEN
3557: oe_debug_pub.add('get_status_tokens: '||'status after after Get_Resv_Qty_and_Code=>'
3558: || FND_API.G_RET_STS_ERROR,1);
3559: END IF;
3560: RAISE fnd_api.g_exc_error;
3561: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3562:

Line 3560: RAISE fnd_api.g_exc_error;

3556: IF PG_DEBUG <> 0 THEN
3557: oe_debug_pub.add('get_status_tokens: '||'status after after Get_Resv_Qty_and_Code=>'
3558: || FND_API.G_RET_STS_ERROR,1);
3559: END IF;
3560: RAISE fnd_api.g_exc_error;
3561: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3562:
3563: IF PG_DEBUG <> 0 THEN
3564: oe_debug_pub.add('status after after Get_Resv_Qty_and_Code=>'

Line 3561: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3557: oe_debug_pub.add('get_status_tokens: '||'status after after Get_Resv_Qty_and_Code=>'
3558: || FND_API.G_RET_STS_ERROR,1);
3559: END IF;
3560: RAISE fnd_api.g_exc_error;
3561: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3562:
3563: IF PG_DEBUG <> 0 THEN
3564: oe_debug_pub.add('status after after Get_Resv_Qty_and_Code=>'
3565: || FND_API.G_RET_STS_UNEXP_ERROR,1 );

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

3561: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3562:
3563: IF PG_DEBUG <> 0 THEN
3564: oe_debug_pub.add('status after after Get_Resv_Qty_and_Code=>'
3565: || FND_API.G_RET_STS_UNEXP_ERROR,1 );
3566:
3567: END IF;
3568: RAISE fnd_api.g_exc_unexpected_error;
3569: END IF;

Line 3568: RAISE fnd_api.g_exc_unexpected_error;

3564: oe_debug_pub.add('status after after Get_Resv_Qty_and_Code=>'
3565: || FND_API.G_RET_STS_UNEXP_ERROR,1 );
3566:
3567: END IF;
3568: RAISE fnd_api.g_exc_unexpected_error;
3569: END IF;
3570: -- If there is no supply tied to this line
3571: -- Then the status should be as follows.
3572: l_stmt_num :=20;

Line 3588: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3584: X_msg_data => l_msg_data,
3585: x_sourcing_org => l_sourcing_org,
3586: x_message => l_return_msg
3587: );
3588: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3589: RAISE FND_API.G_EXC_ERROR;
3590: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3592: END IF;

Line 3589: RAISE FND_API.G_EXC_ERROR;

3585: x_sourcing_org => l_sourcing_org,
3586: x_message => l_return_msg
3587: );
3588: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3589: RAISE FND_API.G_EXC_ERROR;
3590: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3592: END IF;
3593:

Line 3590: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3586: x_message => l_return_msg
3587: );
3588: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3589: RAISE FND_API.G_EXC_ERROR;
3590: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3592: END IF;
3593:
3594: IF l_can_create_supply = 'N' THEN

Line 3591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3587: );
3588: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3589: RAISE FND_API.G_EXC_ERROR;
3590: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3592: END IF;
3593:
3594: IF l_can_create_supply = 'N' THEN
3595: x_token1 := 'AWAITING';

Line 3729: WHEN fnd_api.g_exc_error THEN

3725: End if; /* l_rsv_rec.count = 0 */
3726:
3727: EXCEPTION--4752854,fixed as part of code review
3728:
3729: WHEN fnd_api.g_exc_error THEN
3730: IF PG_DEBUG <> 0 THEN
3731: oe_debug_pub.add('get_status_tokens: ' || 'Exception in stmt num: '
3732: || to_char(l_stmt_num), 1);
3733: END IF;

Line 3734: x_return_status := FND_API.G_RET_STS_ERROR;

3730: IF PG_DEBUG <> 0 THEN
3731: oe_debug_pub.add('get_status_tokens: ' || 'Exception in stmt num: '
3732: || to_char(l_stmt_num), 1);
3733: END IF;
3734: x_return_status := FND_API.G_RET_STS_ERROR;
3735: -- Get message count and data
3736: cto_msg_pub.count_and_get
3737: ( p_msg_count => x_msg_count
3738: , p_msg_data => x_msg_data

Line 3740: WHEN fnd_api.g_exc_unexpected_error THEN

3736: cto_msg_pub.count_and_get
3737: ( p_msg_count => x_msg_count
3738: , p_msg_data => x_msg_data
3739: );
3740: WHEN fnd_api.g_exc_unexpected_error THEN
3741: IF PG_DEBUG <> 0 THEN
3742: oe_debug_pub.add('get_status_tokens: '|| ' Unexpected Exception in stmt num: '
3743: || to_char(l_stmt_num), 1);
3744: END IF;

Line 3745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3741: IF PG_DEBUG <> 0 THEN
3742: oe_debug_pub.add('get_status_tokens: '|| ' Unexpected Exception in stmt num: '
3743: || to_char(l_stmt_num), 1);
3744: END IF;
3745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3746: -- Get message count and data
3747: cto_msg_pub.count_and_get
3748: ( p_msg_count => x_msg_count
3749: , p_msg_data => x_msg_data

Line 3759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3755: oe_debug_pub.add('get_status_tokens: '||'errmsg'||sqlerrm,1);
3756: oe_debug_pub.add('get_status_tokens: ' || 'Others Exception in stmt num: '
3757: || to_char(l_stmt_num), 1);
3758: END IF;
3759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3760: -- Get message count and data
3761: cto_msg_pub.count_and_get
3762: ( p_msg_count => x_msg_count
3763: , p_msg_data => x_msg_data