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 823: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

819: l_ml_mo_flag varchar2(1) := 'N';
820:
821: pAutoUnreserve varchar2(1);
822:
823: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
824: l_msg_count number;
825: l_msg_data varchar2(2000);
826: l_option_line_id number;
827:

Line 964: raise FND_API.G_EXC_ERROR;

960: IF PG_DEBUG <> 0 THEN
961: oe_debug_pub.add ('delink_item: ' || 'Error : Config Line has been ship confirmed. Can not delink',1);
962: END IF;
963: xMessageName := 'CTO_DELINK_SHIPPING_ERROR';
964: raise FND_API.G_EXC_ERROR;
965: end if;
966:
967: EXCEPTION
968: when no_data_found then

Line 1071: if l_status = FND_API.G_RET_STS_ERROR then

1067: p_assembly_item_id => pConfigid ,
1068: p_line_id => lConfigLineId
1069: );
1070:
1071: if l_status = FND_API.G_RET_STS_ERROR then
1072: IF PG_DEBUG <> 0 THEN
1073: oe_debug_pub.add ('delink_item: ' || 'Error: Failed in MRP_Flow_Schedule_PUB.unlink_order_line with expected error.', 1);
1074: END IF;
1075:

Line 1077: raise FND_API.G_EXC_ERROR;

1073: oe_debug_pub.add ('delink_item: ' || 'Error: Failed in MRP_Flow_Schedule_PUB.unlink_order_line with expected error.', 1);
1074: END IF;
1075:
1076: /* Bugfix 2454788 */
1077: raise FND_API.G_EXC_ERROR;
1078:
1079: elsif l_status = FND_API.G_RET_STS_UNEXP_ERROR then
1080: IF PG_DEBUG <> 0 THEN
1081: oe_debug_pub.add ('delink_item: ' || 'Error: Failed in MRP_Flow_Schedule_PUB.unlink_order_line with unexpected error.', 1);

Line 1079: elsif l_status = FND_API.G_RET_STS_UNEXP_ERROR then

1075:
1076: /* Bugfix 2454788 */
1077: raise FND_API.G_EXC_ERROR;
1078:
1079: elsif l_status = FND_API.G_RET_STS_UNEXP_ERROR then
1080: IF PG_DEBUG <> 0 THEN
1081: oe_debug_pub.add ('delink_item: ' || 'Error: Failed in MRP_Flow_Schedule_PUB.unlink_order_line with unexpected error.', 1);
1082: END IF;
1083: xMessageName := 'CTO_DELINK_ITEM_ERROR';

Line 1084: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1080: IF PG_DEBUG <> 0 THEN
1081: oe_debug_pub.add ('delink_item: ' || 'Error: Failed in MRP_Flow_Schedule_PUB.unlink_order_line with unexpected error.', 1);
1082: END IF;
1083: xMessageName := 'CTO_DELINK_ITEM_ERROR';
1084: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1085:
1086: elsif l_status = fnd_api.g_ret_sts_success then
1087: IF PG_DEBUG <> 0 THEN
1088: oe_debug_pub.add ('delink_item: ' || 'Removed config line reference from flow schedule', 2);

Line 1086: elsif l_status = fnd_api.g_ret_sts_success then

1082: END IF;
1083: xMessageName := 'CTO_DELINK_ITEM_ERROR';
1084: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1085:
1086: elsif l_status = fnd_api.g_ret_sts_success then
1087: IF PG_DEBUG <> 0 THEN
1088: oe_debug_pub.add ('delink_item: ' || 'Removed config line reference from flow schedule', 2);
1089: END IF;
1090: -- Check for l_resv_flag. If it is "N" , set it to "Y" .

Line 1153: if l_return_status = FND_API.G_RET_STS_ERROR then

1149: x_status => l_return_status,
1150: x_msg_count => l_msg_count,
1151: x_msg_data => l_msg_data);
1152:
1153: if l_return_status = FND_API.G_RET_STS_ERROR then
1154: IF PG_DEBUG <> 0 THEN
1155: oe_debug_pub.add ('delink_item: ' || 'Error: Failed in wip_so_reservations.respond_to_change_order with expected error.', 1);
1156: END IF;
1157:

Line 1159: raise FND_API.G_EXC_ERROR;

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

Line 1161: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1157:
1158: /* Bugfix 2454788 */
1159: raise FND_API.G_EXC_ERROR;
1160:
1161: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1162: IF PG_DEBUG <> 0 THEN
1163: oe_debug_pub.add ('delink_item: ' || 'Error: Failed in wip_so_reservations.respond_to_change_order with unexpected error.', 1);
1164: END IF;
1165: xMessageName := 'CTO_DELINK_ITEM_ERROR';

Line 1166: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1162: IF PG_DEBUG <> 0 THEN
1163: oe_debug_pub.add ('delink_item: ' || 'Error: Failed in wip_so_reservations.respond_to_change_order with unexpected error.', 1);
1164: END IF;
1165: xMessageName := 'CTO_DELINK_ITEM_ERROR';
1166: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1167: end if;
1168:
1169: else
1170: IF PG_DEBUG <> 0 THEN

Line 1173: l_return_status := FND_API.G_RET_STS_SUCCESS;

1169: else
1170: IF PG_DEBUG <> 0 THEN
1171: oe_debug_pub.add ('delink_item: ' || 'WOS does not exist', 2);
1172: END IF;
1173: l_return_status := FND_API.G_RET_STS_SUCCESS;
1174: end if;
1175:
1176: IF PG_DEBUG <> 0 THEN
1177: oe_debug_pub.add ('delink_item: ' || 'Resp to SO changes returned' || l_return_status, 2);

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

1179: oe_debug_pub.add ('delink_item: ' || 'Resp to SO changes returned with msg : ' || l_msg_data, 2);
1180: END IF;
1181:
1182: lStmtNumber := 518;
1183: if (l_return_status = FND_API.G_RET_STS_SUCCESS) then
1184:
1185: OPEN reservations;
1186: LOOP
1187: FETCH reservations into l_rsv.reservation_id;

Line 1194: , p_init_msg_lst => fnd_api.g_true

1190: -- call INV delete_reservations API
1191: INV_RESERVATION_PUB.delete_reservation
1192: (
1193: p_api_version_number => 1.0
1194: , p_init_msg_lst => fnd_api.g_true
1195: , x_return_status => l_status
1196: , x_msg_count => l_msg_count
1197: , x_msg_data => l_msg_data
1198: , p_rsv_rec => l_rsv

Line 1205: IF l_status = fnd_api.g_ret_sts_success THEN

1201:
1202: IF PG_DEBUG <> 0 THEN
1203: oe_debug_pub.add ('delink_item: ' || 'After deleting rsv, rsv_id = '||to_char(l_rsv.reservation_id)||', l_status = '||l_status, 2);
1204: END IF;
1205: IF l_status = fnd_api.g_ret_sts_success THEN
1206: IF PG_DEBUG <> 0 THEN
1207: oe_debug_pub.add ('delink_item: ' || 'reservations deleted', 2);
1208: END IF;
1209: -- Added by Renga Kannan on 03/13/2001

Line 1225: raise FND_API.G_EXC_ERROR;

1221:
1222: CLOSE reservations;
1223:
1224: xMessageName := 'CTO_DELINK_ITEM_ERROR';
1225: raise FND_API.G_EXC_ERROR;
1226:
1227: ELSE
1228: FOR l_index IN 1..l_msg_count LOOP
1229: IF PG_DEBUG <> 0 THEN

Line 1239: raise FND_API.G_EXC_ERROR;

1235:
1236: CLOSE reservations;
1237:
1238: xMessageName := 'CTO_DELINK_ITEM_ERROR';
1239: raise FND_API.G_EXC_ERROR;
1240: END IF;
1241: END IF;
1242: END LOOP;
1243: CLOSE reservations;

Line 1258: if l_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then

1254: p_line_id => lConfigLineId,
1255: p_item_id => pConfigId,
1256: x_return_status => l_return_status ) ;
1257:
1258: if l_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
1259: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1260: elsif l_Return_Status = FND_API.G_RET_STS_ERROR then
1261: raise FND_API.G_EXC_ERROR;
1262: end if;

Line 1259: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1255: p_item_id => pConfigId,
1256: x_return_status => l_return_status ) ;
1257:
1258: if l_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
1259: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1260: elsif l_Return_Status = FND_API.G_RET_STS_ERROR then
1261: raise FND_API.G_EXC_ERROR;
1262: end if;
1263:

Line 1260: elsif l_Return_Status = FND_API.G_RET_STS_ERROR then

1256: x_return_status => l_return_status ) ;
1257:
1258: if l_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
1259: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1260: elsif l_Return_Status = FND_API.G_RET_STS_ERROR then
1261: raise FND_API.G_EXC_ERROR;
1262: end if;
1263:
1264: end if ; /* source_type_code = 'INTERNAL' */

Line 1261: raise FND_API.G_EXC_ERROR;

1257:
1258: if l_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
1259: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1260: elsif l_Return_Status = FND_API.G_RET_STS_ERROR then
1261: raise FND_API.G_EXC_ERROR;
1262: end if;
1263:
1264: end if ; /* source_type_code = 'INTERNAL' */
1265:

Line 1384: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1380: IF PG_DEBUG <> 0 THEN
1381: oe_debug_pub.add ('delink_item: ' || 'oe_config_util.delink_config returned' || l_return_status ,1);
1382: END IF;
1383:
1384: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1385:
1386: IF PG_DEBUG <> 0 THEN
1387: oe_debug_pub.add('delink_item: ' || 'Expected error in OE_CONFIG_UTIL.delink_config procedure....',3);
1388: END IF;

Line 1391: raise FND_API.G_EXC_ERROR;

1387: oe_debug_pub.add('delink_item: ' || 'Expected error in OE_CONFIG_UTIL.delink_config procedure....',3);
1388: END IF;
1389:
1390: /* Bugfix 2454788 */
1391: raise FND_API.G_EXC_ERROR;
1392:
1393:
1394: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1395: IF PG_DEBUG <> 0 THEN

Line 1394: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1390: /* Bugfix 2454788 */
1391: raise FND_API.G_EXC_ERROR;
1392:
1393:
1394: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1395: IF PG_DEBUG <> 0 THEN
1396: oe_debug_pub.add ('delink_item: ' || 'Unexpected Error in oe_config_util.delink_config.');
1397: END IF;
1398:

Line 1400: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1396: oe_debug_pub.add ('delink_item: ' || 'Unexpected Error in oe_config_util.delink_config.');
1397: END IF;
1398:
1399: xMessageName := 'CTO_DELINK_ITEM_ERROR';
1400: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1401:
1402: END IF;
1403:
1404:

Line 1597: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1593: x_msg_count => l_msg_count,
1594: x_msg_data => l_msg_data);
1595:
1596:
1597: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1598: IF PG_DEBUG <> 0 THEN
1599: oe_debug_pub.add('delink_item: ' || 'Expected error in change_notify procedure....',1);
1600: END IF;
1601:

Line 1604: raise FND_API.G_EXC_ERROR;

1600: END IF;
1601:
1602:
1603: /* Bugfix 2454788 */
1604: raise FND_API.G_EXC_ERROR;
1605:
1606: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1607: IF PG_DEBUG <> 0 THEN
1608: oe_debug_pub.add('delink_item: ' || 'Unexpected error occurred in change_notify...',1);

Line 1606: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1602:
1603: /* Bugfix 2454788 */
1604: raise FND_API.G_EXC_ERROR;
1605:
1606: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1607: IF PG_DEBUG <> 0 THEN
1608: oe_debug_pub.add('delink_item: ' || 'Unexpected error occurred in change_notify...',1);
1609: END IF;
1610: xMessageName := 'CTO_DELINK_ITEM_ERROR';

Line 1611: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1607: IF PG_DEBUG <> 0 THEN
1608: oe_debug_pub.add('delink_item: ' || 'Unexpected error occurred in change_notify...',1);
1609: END IF;
1610: xMessageName := 'CTO_DELINK_ITEM_ERROR';
1611: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1612:
1613: END IF;
1614:
1615: END IF;

Line 1647: if l_return_status_delink = FND_API.G_RET_STS_ERROR then

1643: IF PG_DEBUG <> 0 THEN
1644: oe_debug_pub.add ('delink_item: ' || 'Return status from MRP_OM_Interface - Delink: '||l_return_status_delink,2);
1645: END IF;
1646:
1647: if l_return_status_delink = FND_API.G_RET_STS_ERROR then
1648: IF PG_DEBUG <> 0 THEN
1649: oe_debug_pub.add ('delink_item: ' || 'Failed in MRP_OM_API_PK.mrp_om_interface with expected error.', 1);
1650: END IF;
1651:

Line 1654: raise FND_API.G_EXC_ERROR;

1650: END IF;
1651:
1652: /* Bugfix 2454788 */
1653:
1654: raise FND_API.G_EXC_ERROR;
1655:
1656: elsif l_return_status_delink = FND_API.G_RET_STS_UNEXP_ERROR then
1657: IF PG_DEBUG <> 0 THEN
1658: oe_debug_pub.add ('delink_item: ' || 'Failed in MRP_OM_API_PK.mrp_om_interface with unexpected error.', 1);

Line 1656: elsif l_return_status_delink = FND_API.G_RET_STS_UNEXP_ERROR then

1652: /* Bugfix 2454788 */
1653:
1654: raise FND_API.G_EXC_ERROR;
1655:
1656: elsif l_return_status_delink = FND_API.G_RET_STS_UNEXP_ERROR then
1657: IF PG_DEBUG <> 0 THEN
1658: oe_debug_pub.add ('delink_item: ' || 'Failed in MRP_OM_API_PK.mrp_om_interface with unexpected error.', 1);
1659: END IF;
1660:

Line 1663: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1659: END IF;
1660:
1661:
1662: xMessageName := 'CTO_DELINK_ITEM_ERROR';
1663: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1664:
1665: end if;
1666:
1667: --End Bugfix 1997355

Line 1689: when FND_API.G_EXC_ERROR then

1685: end if;
1686: return(0);
1687:
1688:
1689: when FND_API.G_EXC_ERROR then
1690:
1691: if( xMessageName is null ) then /* xMessageName can be not null in case of CTO_DELINK_SHIPPING_ERROR */
1692: /* Bugfix 2454788 */
1693: CTO_MSG_PUB.Count_And_Get(

Line 1739: when FND_API.G_EXC_UNEXPECTED_ERROR then

1735:
1736: return(0);
1737:
1738:
1739: when FND_API.G_EXC_UNEXPECTED_ERROR then
1740: CTO_MSG_PUB.Count_And_Get(
1741: p_msg_count => lCount,
1742: p_msg_data => xErrorMessage
1743: );

Line 3986: if lStatus <> FND_API.G_RET_STS_SUCCESS then

3982: IF PG_DEBUG <> 0 THEN
3983: oe_debug_pub.add ('Get_Mandatory_Components: ' || ' MRP API returns with '||lStatus, 2);
3984: END IF;
3985:
3986: if lStatus <> FND_API.G_RET_STS_SUCCESS then
3987: xErrorMessage := 'assign_Atp_input_rec returned with Error';
3988: raise proc_error;
3989: end if;
3990:

Line 4148: lReturnStatus := fnd_api.G_RET_STS_SUCCESS;

4144: lOptionNum number ; -- 2652379 : new variable
4145: v_ato_line_id number ;
4146: BEGIN
4147:
4148: lReturnStatus := fnd_api.G_RET_STS_SUCCESS;
4149:
4150: gUserId := nvl(Fnd_Global.USER_ID, -1);
4151: gLoginId := nvl(Fnd_Global.LOGIN_ID, -1);
4152: lCiDel := FND_PROFILE.Value('BOM:CONFIG_ITEM_DELIMITER');

Line 4211: raise FND_API.G_EXC_ERROR;

4207:
4208:
4209: if lVAlidationOrg = -99 then -- bugfix 2646849
4210: cto_msg_pub.cto_message('BOM','CTO_VALIDATION_ORG_NOT_SET');
4211: raise FND_API.G_EXC_ERROR;
4212: end if;
4213:
4214: IF PG_DEBUG <> 0 THEN
4215: oe_debug_pub.add('Create_Item: ' || 'Validation Org is :' || lValidationOrg,2);

Line 4251: raise FND_API.G_EXC_ERROR;

4247:
4248:
4249: if lConfigSegName is NULL then
4250: cto_msg_pub.cto_message('BOM','CTO_CONFIG_SEGMENT_ERROR');
4251: raise FND_API.G_EXC_ERROR;
4252: end if;
4253:
4254: IF PG_DEBUG <> 0 THEN
4255: oe_debug_pub.add('Create_Item: ' || 'config Segment is : ' || lConfigSegName,2 );

Line 5469: raise FND_API.G_EXC_ERROR;

5465: status => x_status,
5466: pConfigId => pConfigId);--3737772 (FP 3473737)
5467:
5468: if x_status <> 0 then
5469: raise FND_API.G_EXC_ERROR;
5470: end if;
5471:
5472: IF PG_DEBUG <> 0 THEN
5473: oe_debug_pub.add('Create_Item: ' || 'Successfully executed Ato_Weight_Volume API with following outputs..',2);

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

5633: x_return_status => lReturnStatus,
5634: x_msg_count => xMsgCount,
5635: x_msg_data => xMsgData);
5636:
5637: IF (lReturnStatus = fnd_api.G_RET_STS_ERROR) THEN
5638: IF PG_DEBUG <> 0 THEN
5639: oe_debug_pub.add ('Create_Item: ' || 'Create_Sourcing_Rules returned with expected error.');
5640: END IF;
5641: raise FND_API.G_EXC_ERROR;

Line 5641: raise FND_API.G_EXC_ERROR;

5637: IF (lReturnStatus = fnd_api.G_RET_STS_ERROR) THEN
5638: IF PG_DEBUG <> 0 THEN
5639: oe_debug_pub.add ('Create_Item: ' || 'Create_Sourcing_Rules returned with expected error.');
5640: END IF;
5641: raise FND_API.G_EXC_ERROR;
5642:
5643: ELSIF (lReturnStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
5644: IF PG_DEBUG <> 0 THEN
5645: oe_debug_pub.add ('Create_Item: ' || 'Create_Sourcing_Rules returned with unexp error.');

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

5639: oe_debug_pub.add ('Create_Item: ' || 'Create_Sourcing_Rules returned with expected error.');
5640: END IF;
5641: raise FND_API.G_EXC_ERROR;
5642:
5643: ELSIF (lReturnStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
5644: IF PG_DEBUG <> 0 THEN
5645: oe_debug_pub.add ('Create_Item: ' || 'Create_Sourcing_Rules returned with unexp error.');
5646: END IF;
5647: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5647: raise FND_API.G_EXC_UNEXPECTED_ERROR;

5643: ELSIF (lReturnStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
5644: IF PG_DEBUG <> 0 THEN
5645: oe_debug_pub.add ('Create_Item: ' || 'Create_Sourcing_Rules returned with unexp error.');
5646: END IF;
5647: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5648:
5649: END IF;
5650:
5651: END LOOP;

Line 5668: raise FND_API.G_EXC_ERROR;

5664: IF lStatus <> 1 THEN
5665: IF PG_DEBUG <> 0 THEN
5666: oe_debug_pub.add ('Create_Item: ' || 'Failed in Update_Order_Lines function',1);
5667: END IF;
5668: raise FND_API.G_EXC_ERROR;
5669: END IF;
5670:
5671:
5672:

Line 5687: raise FND_API.G_EXC_ERROR;

5683: IF lStatus <> 1 THEN
5684: IF PG_DEBUG <> 0 THEN
5685: oe_debug_pub.add ('Create_Item: ' || 'Failed in Update_Src_Orgs function',1);
5686: END IF;
5687: raise FND_API.G_EXC_ERROR;
5688: END IF;
5689:
5690:
5691:

Line 5719: raise FND_API.G_EXC_ERROR;

5715: if lStatus <> 1 then
5716: IF PG_DEBUG <> 0 THEN
5717: oe_debug_pub.add ('Create_Item: ' || 'Failed in create_data function',1);
5718: END IF;
5719: raise FND_API.G_EXC_ERROR;
5720: end if;
5721:
5722: IF PG_DEBUG <> 0 THEN
5723: oe_debug_pub.add ('Create_Item: ' || 'Success in create_data function',1);

Line 5740: WHEN FND_API.G_EXC_ERROR THEN

5736: p_msg_data => xMsgData
5737: );
5738: return(0);
5739:
5740: WHEN FND_API.G_EXC_ERROR THEN
5741: IF PG_DEBUG <> 0 THEN
5742: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item::exp error::'||to_char(lStmtNumber)||sqlerrm,1);
5743: END IF;
5744: CTO_MSG_PUB.Count_And_Get(

Line 5750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5746: p_msg_data => xMsgData
5747: );
5748: return(0);
5749:
5750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5751: IF PG_DEBUG <> 0 THEN
5752: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item::unexp error::'||to_char(lStmtNumber)||sqlerrm,1);
5753: END IF;
5754: CTO_MSG_PUB.Count_And_Get(

Line 6175: RAISE FND_API.G_EXC_ERROR;

6171: END IF;
6172:
6173: if lVAlidationOrg = -99 then -- bugfix 2646849
6174: cto_msg_pub.cto_message('BOM','CTO_VALIDATION_ORG_NOT_SET');
6175: RAISE FND_API.G_EXC_ERROR;
6176: end if;
6177:
6178:
6179: /*------------------------------------------+

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

6313: END IF;
6314:
6315: populate_item_revision (pConfigId, pModelId, pLineId, xReturnStatus);
6316:
6317: IF (xReturnStatus <> fnd_api.G_RET_STS_SUCCESS) THEN
6318: oe_debug_pub.add('Create_item_data : failed in populate_item_revision : '||substrb(sqlerrm,1,60),2);
6319: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6320:
6321: ELSE

Line 6319: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6315: populate_item_revision (pConfigId, pModelId, pLineId, xReturnStatus);
6316:
6317: IF (xReturnStatus <> fnd_api.G_RET_STS_SUCCESS) THEN
6318: oe_debug_pub.add('Create_item_data : failed in populate_item_revision : '||substrb(sqlerrm,1,60),2);
6319: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6320:
6321: ELSE
6322: IF PG_DEBUG <> 0 THEN
6323: oe_debug_pub.add('Create_item_data: done populate_item_revision successfully.',2);

Line 6329: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6325: END IF;
6326:
6327: when OTHERS then
6328: oe_debug_pub.add('Create_item_data: Failed while inserting into MTL_ITEM_REVISIONS: '||substrb(sqlerrm,1,60),2);
6329: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6330: END;*/
6331:
6332: populate_item_revision (pConfigId, pModelId, pLineId, xReturnStatus); --Bugfix 6063990
6333:

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

6330: END;*/
6331:
6332: populate_item_revision (pConfigId, pModelId, pLineId, xReturnStatus); --Bugfix 6063990
6333:
6334: IF (xReturnStatus <> fnd_api.G_RET_STS_SUCCESS) THEN
6335: oe_debug_pub.add('Create_item_data : failed in populate_item_revision : '||substrb(sqlerrm,1,60),2);
6336: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6337:
6338: ELSE

Line 6336: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6332: populate_item_revision (pConfigId, pModelId, pLineId, xReturnStatus); --Bugfix 6063990
6333:
6334: IF (xReturnStatus <> fnd_api.G_RET_STS_SUCCESS) THEN
6335: oe_debug_pub.add('Create_item_data : failed in populate_item_revision : '||substrb(sqlerrm,1,60),2);
6336: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6337:
6338: ELSE
6339: IF PG_DEBUG <> 0 THEN
6340: oe_debug_pub.add('Create_item_data: done populate_item_revision successfully.',2);

Line 6655: raise FND_API.G_EXC_ERROR;

6651: IF PG_DEBUG <> 0 THEN
6652: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);
6653: END IF;
6654: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
6655: raise FND_API.G_EXC_ERROR;
6656: when others then
6657:
6658: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6659: end ;

Line 6658: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6654: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
6655: raise FND_API.G_EXC_ERROR;
6656: when others then
6657:
6658: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6659: end ;
6660:
6661: when others then
6662: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6662: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6658: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6659: end ;
6660:
6661: when others then
6662: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6663: end ;
6664: /* end bugfix 4057651, default CTO cost type id = 7 if it does not exist */
6665:
6666:

Line 7272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7268: IF PG_DEBUG <> 0 THEN
7269: oe_debug_pub.add('Create_Item: ' || 'CST function create_layer returned with error '||to_char(x_err_num)||', '||x_msg_name||', '||
7270: lMsgData||'for '||to_char(v_layer.org_id)||', '||to_char(v_layer.cost_group_id),1);
7271: END IF;
7272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7273: ELSE
7274: IF PG_DEBUG <> 0 THEN
7275: oe_debug_pub.add('Create_Item: ' || 'Inserted row into cql for '||to_char(l_layer_id)||', '||to_char(v_layer.org_id)||', '||
7276: to_char(v_layer.cost_group_id),1);

Line 8052: WHEN FND_API.G_EXC_ERROR THEN

8048: p_msg_data => lMsgData
8049: );
8050: return(0);
8051:
8052: WHEN FND_API.G_EXC_ERROR THEN
8053: IF PG_DEBUG <> 0 THEN
8054: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item_data::exp error::'||to_char(lStmtNumber)||sqlerrm,1);
8055: END IF;
8056: CTO_MSG_PUB.Count_And_Get(

Line 8062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8058: p_msg_data => lMsgData
8059: );
8060: return(0);
8061:
8062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8063: IF PG_DEBUG <> 0 THEN
8064: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item_data::unexp error::'||to_char(lStmtNumber)||sqlerrm,1);
8065: END IF;
8066: CTO_MSG_PUB.Count_And_Get(

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

8099: l_line_rec oe_order_pub.Line_Rec_type;
8100:
8101: l_msg_count number;
8102: l_msg_data varchar2(2000);
8103: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
8104: l_header_rec oe_order_pub.Header_Rec_Type;
8105: l_header_val_rec oe_order_pub.Header_Val_Rec_Type ;
8106: l_Header_Adj_tbl oe_order_pub.Header_Adj_Tbl_Type;
8107: l_Header_Adj_val_tbl oe_order_pub.Header_Adj_Val_Tbl_Type;

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

8396:
8397: oe_debug_pub.add ('link_item: ' || 'Process_order returned ' || l_msg_data, 2);
8398: END IF;
8399:
8400: if (l_return_status = FND_API.G_RET_STS_ERROR) then
8401: IF PG_DEBUG <> 0 THEN
8402: oe_debug_pub.add ('link_item: ' || 'Process_order returned expected error :'||l_msg_data,1);
8403: END IF;
8404: raise FND_API.G_EXC_ERROR;

Line 8404: raise FND_API.G_EXC_ERROR;

8400: if (l_return_status = FND_API.G_RET_STS_ERROR) then
8401: IF PG_DEBUG <> 0 THEN
8402: oe_debug_pub.add ('link_item: ' || 'Process_order returned expected error :'||l_msg_data,1);
8403: END IF;
8404: raise FND_API.G_EXC_ERROR;
8405:
8406: elsif (l_return_status = FND_API.G_RET_STS_ERROR) then
8407: IF PG_DEBUG <> 0 THEN
8408: oe_debug_pub.add ('link_item: ' || 'Process_order returned unexpected error :'||l_msg_data,1);

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

8402: oe_debug_pub.add ('link_item: ' || 'Process_order returned expected error :'||l_msg_data,1);
8403: END IF;
8404: raise FND_API.G_EXC_ERROR;
8405:
8406: elsif (l_return_status = FND_API.G_RET_STS_ERROR) then
8407: IF PG_DEBUG <> 0 THEN
8408: oe_debug_pub.add ('link_item: ' || 'Process_order returned unexpected error :'||l_msg_data,1);
8409: END IF;
8410: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8410: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8406: elsif (l_return_status = FND_API.G_RET_STS_ERROR) then
8407: IF PG_DEBUG <> 0 THEN
8408: oe_debug_pub.add ('link_item: ' || 'Process_order returned unexpected error :'||l_msg_data,1);
8409: END IF;
8410: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8411:
8412: end if;
8413:
8414: oe_globals.g_cascading_request_logged := TRUE;

Line 8534: if l_return_status_link = FND_API.G_RET_STS_ERROR then

8530: IF PG_DEBUG <> 0 THEN
8531: oe_debug_pub.add ('link_item: ' || 'Return status from MRP_OM_Interface - Link: '||l_return_status_link,2);
8532: END IF;
8533:
8534: if l_return_status_link = FND_API.G_RET_STS_ERROR then
8535: IF PG_DEBUG <> 0 THEN
8536: oe_debug_pub.add ('link_item: ' || 'Failed in MRP_OM_API_PK.mrp_om_interface with expected error.', 1);
8537: END IF;
8538: raise FND_API.G_EXC_ERROR;

Line 8538: raise FND_API.G_EXC_ERROR;

8534: if l_return_status_link = FND_API.G_RET_STS_ERROR then
8535: IF PG_DEBUG <> 0 THEN
8536: oe_debug_pub.add ('link_item: ' || 'Failed in MRP_OM_API_PK.mrp_om_interface with expected error.', 1);
8537: END IF;
8538: raise FND_API.G_EXC_ERROR;
8539:
8540: elsif l_return_status_link = FND_API.G_RET_STS_UNEXP_ERROR then
8541: IF PG_DEBUG <> 0 THEN
8542: oe_debug_pub.add ('link_item: ' || 'Failed in MRP_OM_API_PK.mrp_om_interface with unexpected error.', 1);

Line 8540: elsif l_return_status_link = FND_API.G_RET_STS_UNEXP_ERROR then

8536: oe_debug_pub.add ('link_item: ' || 'Failed in MRP_OM_API_PK.mrp_om_interface with expected error.', 1);
8537: END IF;
8538: raise FND_API.G_EXC_ERROR;
8539:
8540: elsif l_return_status_link = FND_API.G_RET_STS_UNEXP_ERROR then
8541: IF PG_DEBUG <> 0 THEN
8542: oe_debug_pub.add ('link_item: ' || 'Failed in MRP_OM_API_PK.mrp_om_interface with unexpected error.', 1);
8543: END IF;
8544: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8544: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8540: elsif l_return_status_link = FND_API.G_RET_STS_UNEXP_ERROR then
8541: IF PG_DEBUG <> 0 THEN
8542: oe_debug_pub.add ('link_item: ' || 'Failed in MRP_OM_API_PK.mrp_om_interface with unexpected error.', 1);
8543: END IF;
8544: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8545: end if;
8546:
8547: -- End Bugfix 1997355
8548:

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

8568: ,x_return_status => l_x_hold_return_status
8569: ,x_msg_count => l_x_error_msg_count
8570: ,x_msg_data => l_x_error_msg);
8571:
8572: IF (l_x_hold_return_status = FND_API.G_RET_STS_ERROR) THEN
8573: IF PG_DEBUG <> 0 THEN
8574: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with expected error.' ,1);
8575: END IF;
8576: raise FND_API.G_EXC_ERROR;

Line 8576: raise FND_API.G_EXC_ERROR;

8572: IF (l_x_hold_return_status = FND_API.G_RET_STS_ERROR) THEN
8573: IF PG_DEBUG <> 0 THEN
8574: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with expected error.' ,1);
8575: END IF;
8576: raise FND_API.G_EXC_ERROR;
8577:
8578: ELSIF (l_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8579: IF PG_DEBUG <> 0 THEN
8580: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with unexpected error.' ,1);

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

8574: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with expected error.' ,1);
8575: END IF;
8576: raise FND_API.G_EXC_ERROR;
8577:
8578: ELSIF (l_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8579: IF PG_DEBUG <> 0 THEN
8580: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with unexpected error.' ,1);
8581: END IF;
8582: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8582: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8578: ELSIF (l_x_hold_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8579: IF PG_DEBUG <> 0 THEN
8580: oe_debug_pub.add('CTOCITMB:Failed in Check Holds with unexpected error.' ,1);
8581: END IF;
8582: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8583:
8584: ELSE
8585: IF PG_DEBUG <> 0 THEN
8586: oe_debug_pub.add('CTOCITMB:Success in Check Holds.' ,1);

Line 8588: if l_x_hold_result_out = FND_API.G_FALSE then

8584: ELSE
8585: IF PG_DEBUG <> 0 THEN
8586: oe_debug_pub.add('CTOCITMB:Success in Check Holds.' ,1);
8587: END IF;
8588: if l_x_hold_result_out = FND_API.G_FALSE then
8589:
8590:
8591:
8592: select schedule_status_code , booked_flag into v_schedule_Status_code , v_booked_flag

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

8632: , x_return_status => l_return_status
8633: , x_msg_count => l_msg_count
8634: , x_msg_data => l_msg_data);
8635:
8636: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
8637: IF PG_DEBUG <> 0 THEN
8638: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with expected error.' ,1);
8639: END IF;
8640: raise FND_API.G_EXC_ERROR;

Line 8640: raise FND_API.G_EXC_ERROR;

8636: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
8637: IF PG_DEBUG <> 0 THEN
8638: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with expected error.' ,1);
8639: END IF;
8640: raise FND_API.G_EXC_ERROR;
8641:
8642: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8643: IF PG_DEBUG <> 0 THEN
8644: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with unexpected error.' ,1);

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

8638: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with expected error.' ,1);
8639: END IF;
8640: raise FND_API.G_EXC_ERROR;
8641:
8642: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8643: IF PG_DEBUG <> 0 THEN
8644: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with unexpected error.' ,1);
8645: END IF;
8646: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8646: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8642: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8643: IF PG_DEBUG <> 0 THEN
8644: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with unexpected error.' ,1);
8645: END IF;
8646: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8647: END IF;
8648:
8649: IF PG_DEBUG <> 0 THEN
8650: oe_debug_pub.add('CTOCITMB: An Exception Hold applied to config line.' ,1);

Line 8680: WHEN FND_API.G_EXC_ERROR THEN

8676: p_msg_data => l_Msg_Data
8677: );
8678: return(0);
8679:
8680: WHEN FND_API.G_EXC_ERROR THEN
8681: IF PG_DEBUG <> 0 THEN
8682: oe_debug_pub.add ('link_item: ' || 'ERROR: link_item::exp error::'||to_char(lStmtNumber)||sqlerrm, 1);
8683: END IF;
8684: CTO_MSG_PUB.Count_And_Get(

Line 8690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8686: p_msg_data => l_Msg_Data
8687: );
8688: return(0);
8689:
8690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8691: IF PG_DEBUG <> 0 THEN
8692: oe_debug_pub.add ('link_item: ' || 'ERROR: link_item::unexp error::'||to_char(lStmtNumber)||sqlerrm, 1);
8693: END IF;
8694: CTO_MSG_PUB.Count_And_Get(

Line 8960: xReturnStatus := fnd_api.G_RET_STS_SUCCESS;

8956: stmtnum number;
8957: x_item_rev_seq number ;
8958:
8959: BEGIN
8960: xReturnStatus := fnd_api.G_RET_STS_SUCCESS;
8961:
8962: stmtnum := 1;
8963:
8964: IF PG_DEBUG <> 0 THEN --Bugfix 6063990

Line 9117: xReturnStatus := fnd_api.G_RET_STS_UNEXP_ERROR;

9113:
9114: EXCEPTION
9115: when OTHERS then
9116: oe_debug_pub.add ('Failed in dynamic query : '||sqlerrm);
9117: xReturnStatus := fnd_api.G_RET_STS_UNEXP_ERROR;
9118:
9119: END populate_item_revision;
9120:
9121: