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_CONFIG_ITEM_PK dependencies on FND_API

Line 898: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

894: l_ml_mo_flag varchar2(1) := 'N';
895:
896: pAutoUnreserve varchar2(1);
897:
898: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
899: l_msg_count number;
900: l_msg_data varchar2(2000);
901: l_option_line_id number;
902:

Line 1043: raise FND_API.G_EXC_ERROR;

1039: IF PG_DEBUG <> 0 THEN
1040: oe_debug_pub.add ('delink_item: ' || 'Error : Config Line has been ship confirmed. Can not delink',1);
1041: END IF;
1042: xMessageName := 'CTO_DELINK_SHIPPING_ERROR';
1043: raise FND_API.G_EXC_ERROR;
1044: end if;
1045:
1046: EXCEPTION
1047: when no_data_found then

Line 1150: if l_status = FND_API.G_RET_STS_ERROR then

1146: p_assembly_item_id => pConfigid ,
1147: p_line_id => lConfigLineId
1148: );
1149:
1150: if l_status = FND_API.G_RET_STS_ERROR then
1151: IF PG_DEBUG <> 0 THEN
1152: oe_debug_pub.add ('delink_item: ' || 'Error: Failed in MRP_Flow_Schedule_PUB.unlink_order_line with expected error.', 1);
1153: END IF;
1154:

Line 1156: raise FND_API.G_EXC_ERROR;

1152: oe_debug_pub.add ('delink_item: ' || 'Error: Failed in MRP_Flow_Schedule_PUB.unlink_order_line with expected error.', 1);
1153: END IF;
1154:
1155: /* Bugfix 2454788 */
1156: raise FND_API.G_EXC_ERROR;
1157:
1158: elsif l_status = FND_API.G_RET_STS_UNEXP_ERROR then
1159: IF PG_DEBUG <> 0 THEN
1160: oe_debug_pub.add ('delink_item: ' || 'Error: Failed in MRP_Flow_Schedule_PUB.unlink_order_line with unexpected error.', 1);

Line 1158: elsif l_status = FND_API.G_RET_STS_UNEXP_ERROR then

1154:
1155: /* Bugfix 2454788 */
1156: raise FND_API.G_EXC_ERROR;
1157:
1158: elsif l_status = FND_API.G_RET_STS_UNEXP_ERROR then
1159: IF PG_DEBUG <> 0 THEN
1160: oe_debug_pub.add ('delink_item: ' || 'Error: Failed in MRP_Flow_Schedule_PUB.unlink_order_line with unexpected error.', 1);
1161: END IF;
1162: xMessageName := 'CTO_DELINK_ITEM_ERROR';

Line 1163: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1159: IF PG_DEBUG <> 0 THEN
1160: oe_debug_pub.add ('delink_item: ' || 'Error: Failed in MRP_Flow_Schedule_PUB.unlink_order_line with unexpected error.', 1);
1161: END IF;
1162: xMessageName := 'CTO_DELINK_ITEM_ERROR';
1163: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1164:
1165: elsif l_status = fnd_api.g_ret_sts_success then
1166: IF PG_DEBUG <> 0 THEN
1167: oe_debug_pub.add ('delink_item: ' || 'Removed config line reference from flow schedule', 2);

Line 1165: elsif l_status = fnd_api.g_ret_sts_success then

1161: END IF;
1162: xMessageName := 'CTO_DELINK_ITEM_ERROR';
1163: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1164:
1165: elsif l_status = fnd_api.g_ret_sts_success then
1166: IF PG_DEBUG <> 0 THEN
1167: oe_debug_pub.add ('delink_item: ' || 'Removed config line reference from flow schedule', 2);
1168: END IF;
1169: -- Check for l_resv_flag. If it is "N" , set it to "Y" .

Line 1232: if l_return_status = FND_API.G_RET_STS_ERROR then

1228: x_status => l_return_status,
1229: x_msg_count => l_msg_count,
1230: x_msg_data => l_msg_data);
1231:
1232: if l_return_status = FND_API.G_RET_STS_ERROR then
1233: IF PG_DEBUG <> 0 THEN
1234: oe_debug_pub.add ('delink_item: ' || 'Error: Failed in wip_so_reservations.respond_to_change_order with expected error.', 1);
1235: END IF;
1236:

Line 1238: raise FND_API.G_EXC_ERROR;

1234: oe_debug_pub.add ('delink_item: ' || 'Error: Failed in wip_so_reservations.respond_to_change_order with expected error.', 1);
1235: END IF;
1236:
1237: /* Bugfix 2454788 */
1238: raise FND_API.G_EXC_ERROR;
1239:
1240: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1241: IF PG_DEBUG <> 0 THEN
1242: oe_debug_pub.add ('delink_item: ' || 'Error: Failed in wip_so_reservations.respond_to_change_order with unexpected error.', 1);

Line 1240: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1236:
1237: /* Bugfix 2454788 */
1238: raise FND_API.G_EXC_ERROR;
1239:
1240: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1241: IF PG_DEBUG <> 0 THEN
1242: oe_debug_pub.add ('delink_item: ' || 'Error: Failed in wip_so_reservations.respond_to_change_order with unexpected error.', 1);
1243: END IF;
1244: xMessageName := 'CTO_DELINK_ITEM_ERROR';

Line 1245: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1241: IF PG_DEBUG <> 0 THEN
1242: oe_debug_pub.add ('delink_item: ' || 'Error: Failed in wip_so_reservations.respond_to_change_order with unexpected error.', 1);
1243: END IF;
1244: xMessageName := 'CTO_DELINK_ITEM_ERROR';
1245: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1246: end if;
1247:
1248: else
1249: IF PG_DEBUG <> 0 THEN

Line 1252: l_return_status := FND_API.G_RET_STS_SUCCESS;

1248: else
1249: IF PG_DEBUG <> 0 THEN
1250: oe_debug_pub.add ('delink_item: ' || 'WOS does not exist', 2);
1251: END IF;
1252: l_return_status := FND_API.G_RET_STS_SUCCESS;
1253: end if;
1254:
1255: IF PG_DEBUG <> 0 THEN
1256: oe_debug_pub.add ('delink_item: ' || 'Resp to SO changes returned' || l_return_status, 2);

Line 1262: if (l_return_status = FND_API.G_RET_STS_SUCCESS) then

1258: oe_debug_pub.add ('delink_item: ' || 'Resp to SO changes returned with msg : ' || l_msg_data, 2);
1259: END IF;
1260:
1261: lStmtNumber := 518;
1262: if (l_return_status = FND_API.G_RET_STS_SUCCESS) then
1263:
1264: OPEN reservations;
1265: LOOP
1266: FETCH reservations into l_rsv.reservation_id;

Line 1273: , p_init_msg_lst => fnd_api.g_true

1269: -- call INV delete_reservations API
1270: INV_RESERVATION_PUB.delete_reservation
1271: (
1272: p_api_version_number => 1.0
1273: , p_init_msg_lst => fnd_api.g_true
1274: , x_return_status => l_status
1275: , x_msg_count => l_msg_count
1276: , x_msg_data => l_msg_data
1277: , p_rsv_rec => l_rsv

Line 1284: IF l_status = fnd_api.g_ret_sts_success THEN

1280:
1281: IF PG_DEBUG <> 0 THEN
1282: oe_debug_pub.add ('delink_item: ' || 'After deleting rsv, rsv_id = '||to_char(l_rsv.reservation_id)||', l_status = '||l_status, 2);
1283: END IF;
1284: IF l_status = fnd_api.g_ret_sts_success THEN
1285: IF PG_DEBUG <> 0 THEN
1286: oe_debug_pub.add ('delink_item: ' || 'reservations deleted', 2);
1287: END IF;
1288: -- Added by Renga Kannan on 03/13/2001

Line 1304: raise FND_API.G_EXC_ERROR;

1300:
1301: CLOSE reservations;
1302:
1303: xMessageName := 'CTO_DELINK_ITEM_ERROR';
1304: raise FND_API.G_EXC_ERROR;
1305:
1306: ELSE
1307: FOR l_index IN 1..l_msg_count LOOP
1308: IF PG_DEBUG <> 0 THEN

Line 1318: raise FND_API.G_EXC_ERROR;

1314:
1315: CLOSE reservations;
1316:
1317: xMessageName := 'CTO_DELINK_ITEM_ERROR';
1318: raise FND_API.G_EXC_ERROR;
1319: END IF;
1320: END IF;
1321: END LOOP;
1322: CLOSE reservations;

Line 1337: if l_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then

1333: p_line_id => lConfigLineId,
1334: p_item_id => pConfigId,
1335: x_return_status => l_return_status ) ;
1336:
1337: if l_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
1338: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1339: elsif l_Return_Status = FND_API.G_RET_STS_ERROR then
1340: raise FND_API.G_EXC_ERROR;
1341: end if;

Line 1338: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1334: p_item_id => pConfigId,
1335: x_return_status => l_return_status ) ;
1336:
1337: if l_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
1338: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1339: elsif l_Return_Status = FND_API.G_RET_STS_ERROR then
1340: raise FND_API.G_EXC_ERROR;
1341: end if;
1342:

Line 1339: elsif l_Return_Status = FND_API.G_RET_STS_ERROR then

1335: x_return_status => l_return_status ) ;
1336:
1337: if l_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
1338: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1339: elsif l_Return_Status = FND_API.G_RET_STS_ERROR then
1340: raise FND_API.G_EXC_ERROR;
1341: end if;
1342:
1343: end if ; /* source_type_code = 'INTERNAL' */

Line 1340: raise FND_API.G_EXC_ERROR;

1336:
1337: if l_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
1338: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1339: elsif l_Return_Status = FND_API.G_RET_STS_ERROR then
1340: raise FND_API.G_EXC_ERROR;
1341: end if;
1342:
1343: end if ; /* source_type_code = 'INTERNAL' */
1344:

Line 1463: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1459: IF PG_DEBUG <> 0 THEN
1460: oe_debug_pub.add ('delink_item: ' || 'oe_config_util.delink_config returned' || l_return_status ,1);
1461: END IF;
1462:
1463: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1464:
1465: IF PG_DEBUG <> 0 THEN
1466: oe_debug_pub.add('delink_item: ' || 'Expected error in OE_CONFIG_UTIL.delink_config procedure....',3);
1467: END IF;

Line 1470: raise FND_API.G_EXC_ERROR;

1466: oe_debug_pub.add('delink_item: ' || 'Expected error in OE_CONFIG_UTIL.delink_config procedure....',3);
1467: END IF;
1468:
1469: /* Bugfix 2454788 */
1470: raise FND_API.G_EXC_ERROR;
1471:
1472:
1473: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1474: IF PG_DEBUG <> 0 THEN

Line 1473: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1469: /* Bugfix 2454788 */
1470: raise FND_API.G_EXC_ERROR;
1471:
1472:
1473: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1474: IF PG_DEBUG <> 0 THEN
1475: oe_debug_pub.add ('delink_item: ' || 'Unexpected Error in oe_config_util.delink_config.');
1476: END IF;
1477:

Line 1479: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1475: oe_debug_pub.add ('delink_item: ' || 'Unexpected Error in oe_config_util.delink_config.');
1476: END IF;
1477:
1478: xMessageName := 'CTO_DELINK_ITEM_ERROR';
1479: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1480:
1481: END IF;
1482:
1483:

Line 1690: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1686: x_msg_count => l_msg_count,
1687: x_msg_data => l_msg_data);
1688:
1689:
1690: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1691: IF PG_DEBUG <> 0 THEN
1692: oe_debug_pub.add('delink_item: ' || 'Expected error in change_notify procedure....',1);
1693: END IF;
1694:

Line 1697: raise FND_API.G_EXC_ERROR;

1693: END IF;
1694:
1695:
1696: /* Bugfix 2454788 */
1697: raise FND_API.G_EXC_ERROR;
1698:
1699: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1700: IF PG_DEBUG <> 0 THEN
1701: oe_debug_pub.add('delink_item: ' || 'Unexpected error occurred in change_notify...',1);

Line 1699: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1695:
1696: /* Bugfix 2454788 */
1697: raise FND_API.G_EXC_ERROR;
1698:
1699: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1700: IF PG_DEBUG <> 0 THEN
1701: oe_debug_pub.add('delink_item: ' || 'Unexpected error occurred in change_notify...',1);
1702: END IF;
1703: xMessageName := 'CTO_DELINK_ITEM_ERROR';

Line 1704: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1700: IF PG_DEBUG <> 0 THEN
1701: oe_debug_pub.add('delink_item: ' || 'Unexpected error occurred in change_notify...',1);
1702: END IF;
1703: xMessageName := 'CTO_DELINK_ITEM_ERROR';
1704: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1705:
1706: END IF;
1707:
1708: END IF;

Line 1740: if l_return_status_delink = FND_API.G_RET_STS_ERROR then

1736: IF PG_DEBUG <> 0 THEN
1737: oe_debug_pub.add ('delink_item: ' || 'Return status from MRP_OM_Interface - Delink: '||l_return_status_delink,2);
1738: END IF;
1739:
1740: if l_return_status_delink = FND_API.G_RET_STS_ERROR then
1741: IF PG_DEBUG <> 0 THEN
1742: oe_debug_pub.add ('delink_item: ' || 'Failed in MRP_OM_API_PK.mrp_om_interface with expected error.', 1);
1743: END IF;
1744:

Line 1747: raise FND_API.G_EXC_ERROR;

1743: END IF;
1744:
1745: /* Bugfix 2454788 */
1746:
1747: raise FND_API.G_EXC_ERROR;
1748:
1749: elsif l_return_status_delink = FND_API.G_RET_STS_UNEXP_ERROR then
1750: IF PG_DEBUG <> 0 THEN
1751: oe_debug_pub.add ('delink_item: ' || 'Failed in MRP_OM_API_PK.mrp_om_interface with unexpected error.', 1);

Line 1749: elsif l_return_status_delink = FND_API.G_RET_STS_UNEXP_ERROR then

1745: /* Bugfix 2454788 */
1746:
1747: raise FND_API.G_EXC_ERROR;
1748:
1749: elsif l_return_status_delink = FND_API.G_RET_STS_UNEXP_ERROR then
1750: IF PG_DEBUG <> 0 THEN
1751: oe_debug_pub.add ('delink_item: ' || 'Failed in MRP_OM_API_PK.mrp_om_interface with unexpected error.', 1);
1752: END IF;
1753:

Line 1756: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1752: END IF;
1753:
1754:
1755: xMessageName := 'CTO_DELINK_ITEM_ERROR';
1756: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1757:
1758: end if;
1759:
1760: --End Bugfix 1997355

Line 1782: when FND_API.G_EXC_ERROR then

1778: end if;
1779: return(0);
1780:
1781:
1782: when FND_API.G_EXC_ERROR then
1783:
1784: if( xMessageName is null ) then /* xMessageName can be not null in case of CTO_DELINK_SHIPPING_ERROR */
1785: /* Bugfix 2454788 */
1786: CTO_MSG_PUB.Count_And_Get(

Line 1832: when FND_API.G_EXC_UNEXPECTED_ERROR then

1828:
1829: return(0);
1830:
1831:
1832: when FND_API.G_EXC_UNEXPECTED_ERROR then
1833: CTO_MSG_PUB.Count_And_Get(
1834: p_msg_count => lCount,
1835: p_msg_data => xErrorMessage
1836: );

Line 4079: if lStatus <> FND_API.G_RET_STS_SUCCESS then

4075: IF PG_DEBUG <> 0 THEN
4076: oe_debug_pub.add ('Get_Mandatory_Components: ' || ' MRP API returns with '||lStatus, 2);
4077: END IF;
4078:
4079: if lStatus <> FND_API.G_RET_STS_SUCCESS then
4080: xErrorMessage := 'assign_Atp_input_rec returned with Error';
4081: raise proc_error;
4082: end if;
4083:

Line 4243: lReturnStatus := fnd_api.G_RET_STS_SUCCESS;

4239: l_ind_cnt number; --Bugfix 8305535
4240: sqlcnt number; --Bugfix 8305535
4241: BEGIN
4242:
4243: lReturnStatus := fnd_api.G_RET_STS_SUCCESS;
4244:
4245: gUserId := nvl(Fnd_Global.USER_ID, -1);
4246: gLoginId := nvl(Fnd_Global.LOGIN_ID, -1);
4247: lCiDel := FND_PROFILE.Value('BOM:CONFIG_ITEM_DELIMITER');

Line 4306: raise FND_API.G_EXC_ERROR;

4302:
4303:
4304: if lVAlidationOrg = -99 then -- bugfix 2646849
4305: cto_msg_pub.cto_message('BOM','CTO_VALIDATION_ORG_NOT_SET');
4306: raise FND_API.G_EXC_ERROR;
4307: end if;
4308:
4309: IF PG_DEBUG <> 0 THEN
4310: oe_debug_pub.add('Create_Item: ' || 'Validation Org is :' || lValidationOrg,2);

Line 4346: raise FND_API.G_EXC_ERROR;

4342:
4343:
4344: if lConfigSegName is NULL then
4345: cto_msg_pub.cto_message('BOM','CTO_CONFIG_SEGMENT_ERROR');
4346: raise FND_API.G_EXC_ERROR;
4347: end if;
4348:
4349: IF PG_DEBUG <> 0 THEN
4350: oe_debug_pub.add('Create_Item: ' || 'config Segment is : ' || lConfigSegName,2 );

Line 5625: raise FND_API.G_EXC_ERROR;

5621: status => x_status,
5622: pConfigId => pConfigId);--3737772 (FP 3473737)
5623:
5624: if x_status <> 0 then
5625: raise FND_API.G_EXC_ERROR;
5626: end if;
5627:
5628: IF PG_DEBUG <> 0 THEN
5629: oe_debug_pub.add('Create_Item: ' || 'Successfully executed Ato_Weight_Volume API with following outputs..',2);

Line 5796: IF (lReturnStatus = fnd_api.G_RET_STS_ERROR) THEN

5792: x_return_status => lReturnStatus,
5793: x_msg_count => xMsgCount,
5794: x_msg_data => xMsgData);
5795:
5796: IF (lReturnStatus = fnd_api.G_RET_STS_ERROR) THEN
5797: IF PG_DEBUG <> 0 THEN
5798: oe_debug_pub.add ('Create_Item: ' || 'Create_Sourcing_Rules returned with expected error.');
5799: END IF;
5800: raise FND_API.G_EXC_ERROR;

Line 5800: raise FND_API.G_EXC_ERROR;

5796: IF (lReturnStatus = fnd_api.G_RET_STS_ERROR) THEN
5797: IF PG_DEBUG <> 0 THEN
5798: oe_debug_pub.add ('Create_Item: ' || 'Create_Sourcing_Rules returned with expected error.');
5799: END IF;
5800: raise FND_API.G_EXC_ERROR;
5801:
5802: ELSIF (lReturnStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
5803: IF PG_DEBUG <> 0 THEN
5804: oe_debug_pub.add ('Create_Item: ' || 'Create_Sourcing_Rules returned with unexp error.');

Line 5802: ELSIF (lReturnStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN

5798: oe_debug_pub.add ('Create_Item: ' || 'Create_Sourcing_Rules returned with expected error.');
5799: END IF;
5800: raise FND_API.G_EXC_ERROR;
5801:
5802: ELSIF (lReturnStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
5803: IF PG_DEBUG <> 0 THEN
5804: oe_debug_pub.add ('Create_Item: ' || 'Create_Sourcing_Rules returned with unexp error.');
5805: END IF;
5806: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5806: raise FND_API.G_EXC_UNEXPECTED_ERROR;

5802: ELSIF (lReturnStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
5803: IF PG_DEBUG <> 0 THEN
5804: oe_debug_pub.add ('Create_Item: ' || 'Create_Sourcing_Rules returned with unexp error.');
5805: END IF;
5806: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5807:
5808: END IF;
5809:
5810: END LOOP;

Line 5827: raise FND_API.G_EXC_ERROR;

5823: IF lStatus <> 1 THEN
5824: IF PG_DEBUG <> 0 THEN
5825: oe_debug_pub.add ('Create_Item: ' || 'Failed in Update_Order_Lines function',1);
5826: END IF;
5827: raise FND_API.G_EXC_ERROR;
5828: END IF;
5829:
5830:
5831:

Line 5846: raise FND_API.G_EXC_ERROR;

5842: IF lStatus <> 1 THEN
5843: IF PG_DEBUG <> 0 THEN
5844: oe_debug_pub.add ('Create_Item: ' || 'Failed in Update_Src_Orgs function',1);
5845: END IF;
5846: raise FND_API.G_EXC_ERROR;
5847: END IF;
5848:
5849:
5850:

Line 5878: raise FND_API.G_EXC_ERROR;

5874: if lStatus <> 1 then
5875: IF PG_DEBUG <> 0 THEN
5876: oe_debug_pub.add ('Create_Item: ' || 'Failed in create_data function',1);
5877: END IF;
5878: raise FND_API.G_EXC_ERROR;
5879: end if;
5880:
5881: IF PG_DEBUG <> 0 THEN
5882: oe_debug_pub.add ('Create_Item: ' || 'Success in create_data function',1);

Line 5899: WHEN FND_API.G_EXC_ERROR THEN

5895: p_msg_data => xMsgData
5896: );
5897: return(0);
5898:
5899: WHEN FND_API.G_EXC_ERROR THEN
5900: IF PG_DEBUG <> 0 THEN
5901: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item::exp error::'||to_char(lStmtNumber)||sqlerrm,1);
5902: END IF;
5903: CTO_MSG_PUB.Count_And_Get(

Line 5909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5905: p_msg_data => xMsgData
5906: );
5907: return(0);
5908:
5909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5910: IF PG_DEBUG <> 0 THEN
5911: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item::unexp error::'||to_char(lStmtNumber)||sqlerrm,1);
5912: END IF;
5913: CTO_MSG_PUB.Count_And_Get(

Line 6360: RAISE FND_API.G_EXC_ERROR;

6356: END IF;
6357:
6358: if lVAlidationOrg = -99 then -- bugfix 2646849
6359: cto_msg_pub.cto_message('BOM','CTO_VALIDATION_ORG_NOT_SET');
6360: RAISE FND_API.G_EXC_ERROR;
6361: end if;
6362:
6363:
6364: /*------------------------------------------+

Line 6502: IF (xReturnStatus <> fnd_api.G_RET_STS_SUCCESS) THEN

6498: END IF;
6499:
6500: populate_item_revision (pConfigId, pModelId, pLineId, xReturnStatus);
6501:
6502: IF (xReturnStatus <> fnd_api.G_RET_STS_SUCCESS) THEN
6503: oe_debug_pub.add('Create_item_data : failed in populate_item_revision : '||substrb(sqlerrm,1,60),2);
6504: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6505:
6506: ELSE

Line 6504: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6500: populate_item_revision (pConfigId, pModelId, pLineId, xReturnStatus);
6501:
6502: IF (xReturnStatus <> fnd_api.G_RET_STS_SUCCESS) THEN
6503: oe_debug_pub.add('Create_item_data : failed in populate_item_revision : '||substrb(sqlerrm,1,60),2);
6504: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6505:
6506: ELSE
6507: IF PG_DEBUG <> 0 THEN
6508: oe_debug_pub.add('Create_item_data: done populate_item_revision successfully.',2);

Line 6514: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6510: END IF;
6511:
6512: when OTHERS then
6513: oe_debug_pub.add('Create_item_data: Failed while inserting into MTL_ITEM_REVISIONS: '||substrb(sqlerrm,1,60),2);
6514: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6515: END;*/
6516:
6517: populate_item_revision (pConfigId, pModelId, pLineId, xReturnStatus); --Bugfix 6063990
6518:

Line 6519: IF (xReturnStatus <> fnd_api.G_RET_STS_SUCCESS) THEN

6515: END;*/
6516:
6517: populate_item_revision (pConfigId, pModelId, pLineId, xReturnStatus); --Bugfix 6063990
6518:
6519: IF (xReturnStatus <> fnd_api.G_RET_STS_SUCCESS) THEN
6520: oe_debug_pub.add('Create_item_data : failed in populate_item_revision : '||substrb(sqlerrm,1,60),2);
6521: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6522:
6523: ELSE

Line 6521: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6517: populate_item_revision (pConfigId, pModelId, pLineId, xReturnStatus); --Bugfix 6063990
6518:
6519: IF (xReturnStatus <> fnd_api.G_RET_STS_SUCCESS) THEN
6520: oe_debug_pub.add('Create_item_data : failed in populate_item_revision : '||substrb(sqlerrm,1,60),2);
6521: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6522:
6523: ELSE
6524: IF PG_DEBUG <> 0 THEN
6525: oe_debug_pub.add('Create_item_data: done populate_item_revision successfully.',2);

Line 6840: raise FND_API.G_EXC_ERROR;

6836: IF PG_DEBUG <> 0 THEN
6837: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);
6838: END IF;
6839: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
6840: raise FND_API.G_EXC_ERROR;
6841: when others then
6842:
6843: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6844: end ;

Line 6843: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6839: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
6840: raise FND_API.G_EXC_ERROR;
6841: when others then
6842:
6843: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6844: end ;
6845:
6846: when others then
6847: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6847: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6843: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6844: end ;
6845:
6846: when others then
6847: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6848: end ;
6849: /* end bugfix 4057651, default CTO cost type id = 7 if it does not exist */
6850:
6851:

Line 7457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7453: IF PG_DEBUG <> 0 THEN
7454: oe_debug_pub.add('Create_Item: ' || 'CST function create_layer returned with error '||to_char(x_err_num)||', '||x_msg_name||', '||
7455: lMsgData||'for '||to_char(v_layer.org_id)||', '||to_char(v_layer.cost_group_id),1);
7456: END IF;
7457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7458: ELSE
7459: IF PG_DEBUG <> 0 THEN
7460: oe_debug_pub.add('Create_Item: ' || 'Inserted row into cql for '||to_char(l_layer_id)||', '||to_char(v_layer.org_id)||', '||
7461: to_char(v_layer.cost_group_id),1);

Line 8333: WHEN FND_API.G_EXC_ERROR THEN

8329: p_msg_data => lMsgData
8330: );
8331: return(0);
8332:
8333: WHEN FND_API.G_EXC_ERROR THEN
8334: IF PG_DEBUG <> 0 THEN
8335: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item_data::exp error::'||to_char(lStmtNumber)||sqlerrm,1);
8336: END IF;
8337: CTO_MSG_PUB.Count_And_Get(

Line 8343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8339: p_msg_data => lMsgData
8340: );
8341: return(0);
8342:
8343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8344: IF PG_DEBUG <> 0 THEN
8345: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item_data::unexp error::'||to_char(lStmtNumber)||sqlerrm,1);
8346: END IF;
8347: CTO_MSG_PUB.Count_And_Get(

Line 8384: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

8380: l_line_rec oe_order_pub.Line_Rec_type;
8381:
8382: l_msg_count number;
8383: l_msg_data varchar2(2000);
8384: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
8385: l_header_rec oe_order_pub.Header_Rec_Type;
8386: l_header_val_rec oe_order_pub.Header_Val_Rec_Type ;
8387: l_Header_Adj_tbl oe_order_pub.Header_Adj_Tbl_Type;
8388: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;

Line 8701: if (l_return_status = FND_API.G_RET_STS_ERROR) then

8697:
8698: oe_debug_pub.add ('link_item: ' || 'Process_order returned ' || l_msg_data, 2);
8699: END IF;
8700:
8701: if (l_return_status = FND_API.G_RET_STS_ERROR) then
8702: IF PG_DEBUG <> 0 THEN
8703: oe_debug_pub.add ('link_item: ' || 'Process_order returned expected error :'||l_msg_data,1);
8704: END IF;
8705: raise FND_API.G_EXC_ERROR;

Line 8705: raise FND_API.G_EXC_ERROR;

8701: if (l_return_status = FND_API.G_RET_STS_ERROR) then
8702: IF PG_DEBUG <> 0 THEN
8703: oe_debug_pub.add ('link_item: ' || 'Process_order returned expected error :'||l_msg_data,1);
8704: END IF;
8705: raise FND_API.G_EXC_ERROR;
8706:
8707: elsif (l_return_status = FND_API.G_RET_STS_ERROR) then
8708: IF PG_DEBUG <> 0 THEN
8709: oe_debug_pub.add ('link_item: ' || 'Process_order returned unexpected error :'||l_msg_data,1);

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

8703: oe_debug_pub.add ('link_item: ' || 'Process_order returned expected error :'||l_msg_data,1);
8704: END IF;
8705: raise FND_API.G_EXC_ERROR;
8706:
8707: elsif (l_return_status = FND_API.G_RET_STS_ERROR) then
8708: IF PG_DEBUG <> 0 THEN
8709: oe_debug_pub.add ('link_item: ' || 'Process_order returned unexpected error :'||l_msg_data,1);
8710: END IF;
8711: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8711: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8707: elsif (l_return_status = FND_API.G_RET_STS_ERROR) then
8708: IF PG_DEBUG <> 0 THEN
8709: oe_debug_pub.add ('link_item: ' || 'Process_order returned unexpected error :'||l_msg_data,1);
8710: END IF;
8711: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8712:
8713: end if;
8714:
8715: oe_globals.g_cascading_request_logged := TRUE;

Line 8835: if l_return_status_link = FND_API.G_RET_STS_ERROR then

8831: IF PG_DEBUG <> 0 THEN
8832: oe_debug_pub.add ('link_item: ' || 'Return status from MRP_OM_Interface - Link: '||l_return_status_link,2);
8833: END IF;
8834:
8835: if l_return_status_link = FND_API.G_RET_STS_ERROR then
8836: IF PG_DEBUG <> 0 THEN
8837: oe_debug_pub.add ('link_item: ' || 'Failed in MRP_OM_API_PK.mrp_om_interface with expected error.', 1);
8838: END IF;
8839: raise FND_API.G_EXC_ERROR;

Line 8839: raise FND_API.G_EXC_ERROR;

8835: if l_return_status_link = FND_API.G_RET_STS_ERROR then
8836: IF PG_DEBUG <> 0 THEN
8837: oe_debug_pub.add ('link_item: ' || 'Failed in MRP_OM_API_PK.mrp_om_interface with expected error.', 1);
8838: END IF;
8839: raise FND_API.G_EXC_ERROR;
8840:
8841: elsif l_return_status_link = FND_API.G_RET_STS_UNEXP_ERROR then
8842: IF PG_DEBUG <> 0 THEN
8843: oe_debug_pub.add ('link_item: ' || 'Failed in MRP_OM_API_PK.mrp_om_interface with unexpected error.', 1);

Line 8841: elsif l_return_status_link = FND_API.G_RET_STS_UNEXP_ERROR then

8837: oe_debug_pub.add ('link_item: ' || 'Failed in MRP_OM_API_PK.mrp_om_interface with expected error.', 1);
8838: END IF;
8839: raise FND_API.G_EXC_ERROR;
8840:
8841: elsif l_return_status_link = FND_API.G_RET_STS_UNEXP_ERROR then
8842: IF PG_DEBUG <> 0 THEN
8843: oe_debug_pub.add ('link_item: ' || 'Failed in MRP_OM_API_PK.mrp_om_interface with unexpected error.', 1);
8844: END IF;
8845: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8845: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8841: elsif l_return_status_link = FND_API.G_RET_STS_UNEXP_ERROR then
8842: IF PG_DEBUG <> 0 THEN
8843: oe_debug_pub.add ('link_item: ' || 'Failed in MRP_OM_API_PK.mrp_om_interface with unexpected error.', 1);
8844: END IF;
8845: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8846: end if;
8847:
8848: -- End Bugfix 1997355
8849:

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

8869: ,x_return_status => l_x_hold_return_status
8870: ,x_msg_count => l_x_error_msg_count
8871: ,x_msg_data => l_x_error_msg);
8872:
8873: IF (l_x_hold_return_status = FND_API.G_RET_STS_ERROR) THEN
8874: IF PG_DEBUG <> 0 THEN
8875: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with expected error.' ,1);
8876: END IF;
8877: raise FND_API.G_EXC_ERROR;

Line 8877: raise FND_API.G_EXC_ERROR;

8873: IF (l_x_hold_return_status = FND_API.G_RET_STS_ERROR) THEN
8874: IF PG_DEBUG <> 0 THEN
8875: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with expected error.' ,1);
8876: END IF;
8877: raise FND_API.G_EXC_ERROR;
8878:
8879: ELSIF (l_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8880: IF PG_DEBUG <> 0 THEN
8881: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with unexpected error.' ,1);

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

8875: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with expected error.' ,1);
8876: END IF;
8877: raise FND_API.G_EXC_ERROR;
8878:
8879: ELSIF (l_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8880: IF PG_DEBUG <> 0 THEN
8881: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with unexpected error.' ,1);
8882: END IF;
8883: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8883: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8879: ELSIF (l_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8880: IF PG_DEBUG <> 0 THEN
8881: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with unexpected error.' ,1);
8882: END IF;
8883: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8884:
8885: ELSE
8886: IF PG_DEBUG <> 0 THEN
8887: oe_debug_pub.add('CTOCITMB:Success in Check Holds.' ,1);

Line 8889: if l_x_hold_result_out = FND_API.G_FALSE then

8885: ELSE
8886: IF PG_DEBUG <> 0 THEN
8887: oe_debug_pub.add('CTOCITMB:Success in Check Holds.' ,1);
8888: END IF;
8889: if l_x_hold_result_out = FND_API.G_FALSE then
8890:
8891:
8892:
8893: select schedule_status_code , booked_flag into v_schedule_Status_code , v_booked_flag

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

8933: , x_return_status => l_return_status
8934: , x_msg_count => l_msg_count
8935: , x_msg_data => l_msg_data);
8936:
8937: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
8938: IF PG_DEBUG <> 0 THEN
8939: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with expected error.' ,1);
8940: END IF;
8941: raise FND_API.G_EXC_ERROR;

Line 8941: raise FND_API.G_EXC_ERROR;

8937: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
8938: IF PG_DEBUG <> 0 THEN
8939: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with expected error.' ,1);
8940: END IF;
8941: raise FND_API.G_EXC_ERROR;
8942:
8943: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8944: IF PG_DEBUG <> 0 THEN
8945: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with unexpected error.' ,1);

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

8939: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with expected error.' ,1);
8940: END IF;
8941: raise FND_API.G_EXC_ERROR;
8942:
8943: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8944: IF PG_DEBUG <> 0 THEN
8945: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with unexpected error.' ,1);
8946: END IF;
8947: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8947: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8943: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8944: IF PG_DEBUG <> 0 THEN
8945: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with unexpected error.' ,1);
8946: END IF;
8947: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8948: END IF;
8949:
8950: IF PG_DEBUG <> 0 THEN
8951: oe_debug_pub.add('CTOCITMB: An Exception Hold applied to config line.' ,1);

Line 8981: WHEN FND_API.G_EXC_ERROR THEN

8977: p_msg_data => l_Msg_Data
8978: );
8979: return(0);
8980:
8981: WHEN FND_API.G_EXC_ERROR THEN
8982: IF PG_DEBUG <> 0 THEN
8983: oe_debug_pub.add ('link_item: ' || 'ERROR: link_item::exp error::'||to_char(lStmtNumber)||sqlerrm, 1);
8984: END IF;
8985: CTO_MSG_PUB.Count_And_Get(

Line 8991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8987: p_msg_data => l_Msg_Data
8988: );
8989: return(0);
8990:
8991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8992: IF PG_DEBUG <> 0 THEN
8993: oe_debug_pub.add ('link_item: ' || 'ERROR: link_item::unexp error::'||to_char(lStmtNumber)||sqlerrm, 1);
8994: END IF;
8995: CTO_MSG_PUB.Count_And_Get(

Line 9261: xReturnStatus := fnd_api.G_RET_STS_SUCCESS;

9257: stmtnum number;
9258: x_item_rev_seq number ;
9259:
9260: BEGIN
9261: xReturnStatus := fnd_api.G_RET_STS_SUCCESS;
9262:
9263: stmtnum := 1;
9264:
9265: IF PG_DEBUG <> 0 THEN --Bugfix 6063990

Line 9418: xReturnStatus := fnd_api.G_RET_STS_UNEXP_ERROR;

9414:
9415: EXCEPTION
9416: when OTHERS then
9417: oe_debug_pub.add ('Failed in dynamic query : '||sqlerrm);
9418: xReturnStatus := fnd_api.G_RET_STS_UNEXP_ERROR;
9419:
9420: END populate_item_revision;
9421:
9422: