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 1321: raise FND_API.G_EXC_ERROR;

1317: when no_data_found then
1318: -- rollback to CTOCST; bug 4177423
1319: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
1320: -- goto endloop; bug 4177423
1321: raise FND_API.G_EXC_ERROR;
1322:
1323: when others then
1324: oe_debug_pub.add('Unexpected error while getting the cost_type_id: ' ||sqlerrm);
1325: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1325: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1321: raise FND_API.G_EXC_ERROR;
1322:
1323: when others then
1324: oe_debug_pub.add('Unexpected error while getting the cost_type_id: ' ||sqlerrm);
1325: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1326:
1327: end;
1328:
1329:

Line 1366: raise FND_API.G_EXC_ERROR;

1362: IF PG_DEBUG <> 0 THEN
1363: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);
1364: END IF;
1365: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
1366: raise FND_API.G_EXC_ERROR;
1367: when others then
1368:
1369: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1370: end ;

Line 1369: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1365: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
1366: raise FND_API.G_EXC_ERROR;
1367: when others then
1368:
1369: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1370: end ;
1371:
1372: when others then
1373: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1373: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1369: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1370: end ;
1371:
1372: when others then
1373: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1374: end ;
1375: /* end bugfix 4057651, default CTO cost type id = 7 if it does not exist */
1376:
1377:

Line 1407: raise FND_API.G_EXC_ERROR;

1403: exception
1404: when no_data_found then
1405:
1406: cto_msg_pub.cto_message('BOM','CTO_BUY_COST_NOT_FOUND');
1407: raise FND_API.G_EXC_ERROR;
1408:
1409: when others then
1410:
1411: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1411: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1407: raise FND_API.G_EXC_ERROR;
1408:
1409: when others then
1410:
1411: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1412:
1413: end;
1414:
1415: else /* fix for bug 4177423 */

Line 1527: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1523:
1524: when others then
1525: oe_debug_pub.add('Unexpected error while checking buy cost for item_id ' ||c_config_item_id|| ' in orgn '||c_org_id);
1526: oe_debug_pub.add(sqlerrm);
1527: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1528:
1529: end ;
1530:
1531:

Line 1592: raise FND_API.G_EXC_ERROR;

1588:
1589:
1590: cto_msg_pub.cto_message('BOM', 'CTO_ITEM_NOT_ENABLED_IN_POV', l_token );
1591:
1592: raise FND_API.G_EXC_ERROR;
1593:
1594:
1595:
1596:

Line 1619: if x_return_status = FND_API.G_RET_STS_ERROR then

1615: , v_buy_cost_type_id
1616: , v_buy_item_cost
1617: , x_return_status) ;
1618:
1619: if x_return_status = FND_API.G_RET_STS_ERROR then
1620: ROLLBACK to CTOCST;
1621: oe_debug_pub.add ('Expected error in populate_buy_cost_rollup.');
1622: goto endloop;
1623:

Line 1624: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1620: ROLLBACK to CTOCST;
1621: oe_debug_pub.add ('Expected error in populate_buy_cost_rollup.');
1622: goto endloop;
1623:
1624: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1625: oe_debug_pub.add ('UnExpected error in populate_buy_cost_rollup.');
1626: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1627: end if;
1628:

Line 1626: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1622: goto endloop;
1623:
1624: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1625: oe_debug_pub.add ('UnExpected error in populate_buy_cost_rollup.');
1626: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1627: end if;
1628:
1629:
1630: else

Line 1851: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1847: IF lErrorCode <> 0 THEN
1848: IF PG_DEBUG <> 0 THEN
1849: oe_debug_pub.add('populate_buy_cost: ' || 'SC Rollup API returned with error::'||lErrorMsg, 1);
1850: END IF;
1851: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1852: ELSE
1853: IF PG_DEBUG <> 0 THEN
1854: oe_debug_pub.add('populate_buy_cost: ' || 'SC Rollup API returned with success', 1);
1855: END IF;

Line 2038: WHEN FND_API.G_EXC_ERROR THEN

2034:
2035: return(0);
2036:
2037:
2038: WHEN FND_API.G_EXC_ERROR THEN
2039: oe_debug_pub.add ('Cost_Roll_Up_ML ' || 'cost_rollup::exp error::'||to_char(lStmtNumber)||sqlerrm, 1);
2040:
2041: cto_msg_pub.count_and_get
2042: ( p_msg_count => x_msg_count

Line 2050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2046:
2047: return(0);
2048:
2049:
2050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2051: oe_debug_pub.add ('Cost_Roll_Up_ML ' || 'cost_rollup::unexp error::'||to_char(lStmtNumber)||sqlerrm, 1);
2052:
2053: cto_msg_pub.count_and_get
2054: ( p_msg_count => x_msg_count

Line 2312: raise FND_API.G_EXC_ERROR;

2308: exception
2309: when no_data_found then
2310:
2311: cto_msg_pub.cto_message('BOM','CTO_BUY_COST_NOT_FOUND');
2312: raise FND_API.G_EXC_ERROR;
2313:
2314: when others then
2315:
2316: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2316: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2312: raise FND_API.G_EXC_ERROR;
2313:
2314: when others then
2315:
2316: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2317:
2318:
2319: end;
2320:

Line 2381: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2377:
2378: when others then
2379:
2380:
2381: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2382:
2383: end ;
2384:
2385:

Line 2447: raise FND_API.G_EXC_ERROR;

2443:
2444:
2445: cto_msg_pub.cto_message('BOM', 'CTO_ITEM_NOT_ENABLED_IN_POV', l_token );
2446:
2447: raise FND_API.G_EXC_ERROR;
2448:
2449:
2450:
2451:

Line 2632: raise FND_API.G_EXC_ERROR;

2628: exception
2629: when no_data_found then
2630:
2631: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
2632: raise FND_API.G_EXC_ERROR;
2633:
2634: when others then
2635:
2636: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2636: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2632: raise FND_API.G_EXC_ERROR;
2633:
2634: when others then
2635:
2636: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2637:
2638:
2639: end;
2640:

Line 2683: raise FND_API.G_EXC_ERROR;

2679: IF PG_DEBUG <> 0 THEN
2680: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);
2681: END IF;
2682: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
2683: raise FND_API.G_EXC_ERROR;
2684: when others then
2685:
2686: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2687: end ;

Line 2686: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2682: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
2683: raise FND_API.G_EXC_ERROR;
2684: when others then
2685:
2686: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2687: end ;
2688:
2689: when others then
2690: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2690: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2686: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2687: end ;
2688:
2689: when others then
2690: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2691: end ;
2692:
2693: if( lBuyCostType is null ) then
2694: v_buy_cost_type_id := v_cto_cost_type_id ;

Line 2811: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2807: IF lErrorCode <> 0 THEN
2808: IF PG_DEBUG <> 0 THEN
2809: oe_debug_pub.add('************** Cost_Rollup_ML: ' || 'SC Rollup API returned with error::'||lErrorMsg, 1);
2810: END IF;
2811: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2812: ELSE
2813: IF PG_DEBUG <> 0 THEN
2814: oe_debug_pub.add('************** Cost_Rollup_ML: ' || 'SC Rollup API returned with success', 1);
2815: END IF;

Line 3053: WHEN FND_API.G_EXC_ERROR THEN

3049:
3050: return(0);
3051:
3052:
3053: WHEN FND_API.G_EXC_ERROR THEN
3054: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::exp error::'||to_char(lStmtNumber)||sqlerrm, 1);
3055:
3056: cto_msg_pub.count_and_get
3057: ( p_msg_count => x_msg_count

Line 3065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3061:
3062: return(0);
3063:
3064:
3065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3066: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::unexp error::'||to_char(lStmtNumber)||sqlerrm, 1);
3067:
3068: cto_msg_pub.count_and_get
3069: ( p_msg_count => x_msg_count