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

Line 363: x_return_status := FND_API.G_RET_STS_SUCCESS;

359: Insert a row into the cst_item_costs_table
360: +------------------------------------------------------- */
361:
362: lStmtNumber := 220;
363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364:
365: insert into CST_ITEM_COSTS
366: (inventory_item_id,
367: organization_id,

Line 585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

581:
582: exception
583:
584: when OTHERS THEN
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'populate_buy_cost others '||sqlerrm,2);
587:
588:
589: end populate_buy_cost_rollup;

Line 1289: raise FND_API.G_EXC_ERROR;

1285: when no_data_found then
1286: -- rollback to CTOCST; bug 4177423
1287: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
1288: -- goto endloop; bug 4177423
1289: raise FND_API.G_EXC_ERROR;
1290:
1291: when others then
1292: oe_debug_pub.add('Unexpected error while getting the cost_type_id: ' ||sqlerrm);
1293: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1293: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1289: raise FND_API.G_EXC_ERROR;
1290:
1291: when others then
1292: oe_debug_pub.add('Unexpected error while getting the cost_type_id: ' ||sqlerrm);
1293: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1294:
1295: end;
1296:
1297:

Line 1334: raise FND_API.G_EXC_ERROR;

1330: IF PG_DEBUG <> 0 THEN
1331: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);
1332: END IF;
1333: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
1334: raise FND_API.G_EXC_ERROR;
1335: when others then
1336:
1337: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1338: end ;

Line 1337: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1333: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
1334: raise FND_API.G_EXC_ERROR;
1335: when others then
1336:
1337: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1338: end ;
1339:
1340: when others then
1341: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1341: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1337: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1338: end ;
1339:
1340: when others then
1341: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1342: end ;
1343: /* end bugfix 4057651, default CTO cost type id = 7 if it does not exist */
1344:
1345:

Line 1375: raise FND_API.G_EXC_ERROR;

1371: exception
1372: when no_data_found then
1373:
1374: cto_msg_pub.cto_message('BOM','CTO_BUY_COST_NOT_FOUND');
1375: raise FND_API.G_EXC_ERROR;
1376:
1377: when others then
1378:
1379: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1379: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1375: raise FND_API.G_EXC_ERROR;
1376:
1377: when others then
1378:
1379: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1380:
1381: end;
1382:
1383: else /* fix for bug 4177423 */

Line 1475: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1471:
1472: when others then
1473: oe_debug_pub.add('Unexpected error while checking buy cost for item_id ' ||c_config_item_id|| ' in orgn '||c_org_id);
1474: oe_debug_pub.add(sqlerrm);
1475: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1476:
1477: end ;
1478:
1479:

Line 1540: raise FND_API.G_EXC_ERROR;

1536:
1537:
1538: cto_msg_pub.cto_message('BOM', 'CTO_ITEM_NOT_ENABLED_IN_POV', l_token );
1539:
1540: raise FND_API.G_EXC_ERROR;
1541:
1542:
1543:
1544:

Line 1567: if x_return_status = FND_API.G_RET_STS_ERROR then

1563: , v_buy_cost_type_id
1564: , v_buy_item_cost
1565: , x_return_status) ;
1566:
1567: if x_return_status = FND_API.G_RET_STS_ERROR then
1568: ROLLBACK to CTOCST;
1569: oe_debug_pub.add ('Expected error in populate_buy_cost_rollup.');
1570: goto endloop;
1571:

Line 1572: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1568: ROLLBACK to CTOCST;
1569: oe_debug_pub.add ('Expected error in populate_buy_cost_rollup.');
1570: goto endloop;
1571:
1572: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1573: oe_debug_pub.add ('UnExpected error in populate_buy_cost_rollup.');
1574: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1575: end if;
1576:

Line 1574: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1570: goto endloop;
1571:
1572: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1573: oe_debug_pub.add ('UnExpected error in populate_buy_cost_rollup.');
1574: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1575: end if;
1576:
1577:
1578: else

Line 1799: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1795: IF lErrorCode <> 0 THEN
1796: IF PG_DEBUG <> 0 THEN
1797: oe_debug_pub.add('populate_buy_cost: ' || 'SC Rollup API returned with error::'||lErrorMsg, 1);
1798: END IF;
1799: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1800: ELSE
1801: IF PG_DEBUG <> 0 THEN
1802: oe_debug_pub.add('populate_buy_cost: ' || 'SC Rollup API returned with success', 1);
1803: END IF;

Line 1917: WHEN FND_API.G_EXC_ERROR THEN

1913:
1914: return(0);
1915:
1916:
1917: WHEN FND_API.G_EXC_ERROR THEN
1918: oe_debug_pub.add ('Cost_Roll_Up_ML ' || 'cost_rollup::exp error::'||to_char(lStmtNumber)||sqlerrm, 1);
1919:
1920: cto_msg_pub.count_and_get
1921: ( p_msg_count => x_msg_count

Line 1929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1925:
1926: return(0);
1927:
1928:
1929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1930: oe_debug_pub.add ('Cost_Roll_Up_ML ' || 'cost_rollup::unexp error::'||to_char(lStmtNumber)||sqlerrm, 1);
1931:
1932: cto_msg_pub.count_and_get
1933: ( p_msg_count => x_msg_count

Line 2187: raise FND_API.G_EXC_ERROR;

2183: exception
2184: when no_data_found then
2185:
2186: cto_msg_pub.cto_message('BOM','CTO_BUY_COST_NOT_FOUND');
2187: raise FND_API.G_EXC_ERROR;
2188:
2189: when others then
2190:
2191: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2191: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2187: raise FND_API.G_EXC_ERROR;
2188:
2189: when others then
2190:
2191: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2192:
2193:
2194: end;
2195:

Line 2256: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2252:
2253: when others then
2254:
2255:
2256: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2257:
2258: end ;
2259:
2260:

Line 2322: raise FND_API.G_EXC_ERROR;

2318:
2319:
2320: cto_msg_pub.cto_message('BOM', 'CTO_ITEM_NOT_ENABLED_IN_POV', l_token );
2321:
2322: raise FND_API.G_EXC_ERROR;
2323:
2324:
2325:
2326:

Line 2507: raise FND_API.G_EXC_ERROR;

2503: exception
2504: when no_data_found then
2505:
2506: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
2507: raise FND_API.G_EXC_ERROR;
2508:
2509: when others then
2510:
2511: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2511: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2507: raise FND_API.G_EXC_ERROR;
2508:
2509: when others then
2510:
2511: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2512:
2513:
2514: end;
2515:

Line 2558: raise FND_API.G_EXC_ERROR;

2554: IF PG_DEBUG <> 0 THEN
2555: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);
2556: END IF;
2557: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
2558: raise FND_API.G_EXC_ERROR;
2559: when others then
2560:
2561: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2562: end ;

Line 2561: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2557: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
2558: raise FND_API.G_EXC_ERROR;
2559: when others then
2560:
2561: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2562: end ;
2563:
2564: when others then
2565: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2565: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2561: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2562: end ;
2563:
2564: when others then
2565: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2566: end ;
2567:
2568: if( lBuyCostType is null ) then
2569: v_buy_cost_type_id := v_cto_cost_type_id ;

Line 2686: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2682: IF lErrorCode <> 0 THEN
2683: IF PG_DEBUG <> 0 THEN
2684: oe_debug_pub.add('************** Cost_Rollup_ML: ' || 'SC Rollup API returned with error::'||lErrorMsg, 1);
2685: END IF;
2686: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2687: ELSE
2688: IF PG_DEBUG <> 0 THEN
2689: oe_debug_pub.add('************** Cost_Rollup_ML: ' || 'SC Rollup API returned with success', 1);
2690: END IF;

Line 2878: WHEN FND_API.G_EXC_ERROR THEN

2874:
2875: return(0);
2876:
2877:
2878: WHEN FND_API.G_EXC_ERROR THEN
2879: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::exp error::'||to_char(lStmtNumber)||sqlerrm, 1);
2880:
2881: cto_msg_pub.count_and_get
2882: ( p_msg_count => x_msg_count

Line 2890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2886:
2887: return(0);
2888:
2889:
2890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2891: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::unexp error::'||to_char(lStmtNumber)||sqlerrm, 1);
2892:
2893: cto_msg_pub.count_and_get
2894: ( p_msg_count => x_msg_count