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

Line 466: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

462: , x_msg_count => l_msg_count
463: , x_msg_data => l_msg_data
464: , x_return_status => l_return_status ) ;
465:
466: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
467: WriteToLog('get_config_details: ' || 'get_config_details returned unexp error.');
468: ROLLBACK TO CTOCCR;
469: raise FND_API.G_EXC_UNEXPECTED_ERROR;
470:

Line 469: raise FND_API.G_EXC_UNEXPECTED_ERROR;

465:
466: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
467: WriteToLog('get_config_details: ' || 'get_config_details returned unexp error.');
468: ROLLBACK TO CTOCCR;
469: raise FND_API.G_EXC_UNEXPECTED_ERROR;
470:
471: elsif (l_return_status = FND_API.G_RET_STS_ERROR) then
472: retcode := 1; -- Set this for conc request to end in WARNING
473: WriteToLog('get_config_details: ' || 'get_config_details returned expected error.');

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

467: WriteToLog('get_config_details: ' || 'get_config_details returned unexp error.');
468: ROLLBACK TO CTOCCR;
469: raise FND_API.G_EXC_UNEXPECTED_ERROR;
470:
471: elsif (l_return_status = FND_API.G_RET_STS_ERROR) then
472: retcode := 1; -- Set this for conc request to end in WARNING
473: WriteToLog('get_config_details: ' || 'get_config_details returned expected error.');
474: ROLLBACK TO CTOCCR;
475: goto beginloop;

Line 580: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

576: p_return_status => l_return_status );
577:
578: WriteToLog ('** l_return_status = '|| l_return_status );
579:
580: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
581: WriteToLog('get_sourcing_org: ' || 'raised Unexpected error.');
582: ROLLBACK TO CTOCCR;
583: raise FND_API.G_EXC_UNEXPECTED_ERROR;
584:

Line 583: raise FND_API.G_EXC_UNEXPECTED_ERROR;

579:
580: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
581: WriteToLog('get_sourcing_org: ' || 'raised Unexpected error.');
582: ROLLBACK TO CTOCCR;
583: raise FND_API.G_EXC_UNEXPECTED_ERROR;
584:
585: elsif (l_return_status = FND_API.G_RET_STS_ERROR) then
586: retcode := 1; -- Set this for conc request to end in WARNING
587: WriteToLog('get_sourcing_org: ' || 'raised Expected error.');

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

581: WriteToLog('get_sourcing_org: ' || 'raised Unexpected error.');
582: ROLLBACK TO CTOCCR;
583: raise FND_API.G_EXC_UNEXPECTED_ERROR;
584:
585: elsif (l_return_status = FND_API.G_RET_STS_ERROR) then
586: retcode := 1; -- Set this for conc request to end in WARNING
587: WriteToLog('get_sourcing_org: ' || 'raised Expected error.');
588: ROLLBACK TO CTOCCR;
589: goto beginloop;

Line 810: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

806: get_sourcing_org (p_config_item_id => l_child_config_item ,
807: p_organization_id => l_parent_org_id ,
808: p_return_status => l_return_status );
809:
810: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
811: WriteToLog('get_sourcing_org: ' || 'raised Unexpected error.');
812: ROLLBACK TO CTOCCR;
813: raise FND_API.G_EXC_UNEXPECTED_ERROR;
814:

Line 813: raise FND_API.G_EXC_UNEXPECTED_ERROR;

809:
810: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
811: WriteToLog('get_sourcing_org: ' || 'raised Unexpected error.');
812: ROLLBACK TO CTOCCR;
813: raise FND_API.G_EXC_UNEXPECTED_ERROR;
814:
815: elsif (l_return_status = FND_API.G_RET_STS_ERROR) then
816: retcode := 1; -- Set this for conc request to end in WARNING
817: WriteToLog('get_sourcing_org: ' || 'raised Expected error.');

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

811: WriteToLog('get_sourcing_org: ' || 'raised Unexpected error.');
812: ROLLBACK TO CTOCCR;
813: raise FND_API.G_EXC_UNEXPECTED_ERROR;
814:
815: elsif (l_return_status = FND_API.G_RET_STS_ERROR) then
816: retcode := 1; -- Set this for conc request to end in WARNING
817: WriteToLog('get_sourcing_org: ' || 'raised Expected error.');
818: ROLLBACK TO CTOCCR;
819: goto beginloop;

Line 1204: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1200: end loop;
1201: WriteToLog ('====================================================================', 1);
1202: WriteToLog('Total records not been processed successfully .. ' || fail_item_arr.count , 1);
1203: WriteToLog ('====================================================================', 1);
1204: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1205: end if;
1206:
1207:
1208:

Line 1216: when FND_API.G_EXC_ERROR then

1212: CLOSE config_cv;
1213: end if;
1214:
1215: EXCEPTION
1216: when FND_API.G_EXC_ERROR then
1217: WriteToLog('cto_cost_rollup: ' || 'EXPECTED ERROR:' || to_char(l_stat_num),1);
1218: retcode := 1;--completes with warning status -- Bug Fix 5527848
1219: l_return_status := FND_API.G_RET_STS_ERROR;
1220:

Line 1219: l_return_status := FND_API.G_RET_STS_ERROR;

1215: EXCEPTION
1216: when FND_API.G_EXC_ERROR then
1217: WriteToLog('cto_cost_rollup: ' || 'EXPECTED ERROR:' || to_char(l_stat_num),1);
1218: retcode := 1;--completes with warning status -- Bug Fix 5527848
1219: l_return_status := FND_API.G_RET_STS_ERROR;
1220:
1221:
1222: when FND_API.G_EXC_UNEXPECTED_ERROR then
1223: WriteToLog('cto_cost_rollup: ' || 'UNEXPECTED ERROR:' || to_char(l_stat_num),1);

Line 1222: when FND_API.G_EXC_UNEXPECTED_ERROR then

1218: retcode := 1;--completes with warning status -- Bug Fix 5527848
1219: l_return_status := FND_API.G_RET_STS_ERROR;
1220:
1221:
1222: when FND_API.G_EXC_UNEXPECTED_ERROR then
1223: WriteToLog('cto_cost_rollup: ' || 'UNEXPECTED ERROR:' || to_char(l_stat_num),1);
1224: retcode := 1;--completes with warning status --Bug Fix 5527848
1225: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1226:

Line 1225: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1221:
1222: when FND_API.G_EXC_UNEXPECTED_ERROR then
1223: WriteToLog('cto_cost_rollup: ' || 'UNEXPECTED ERROR:' || to_char(l_stat_num),1);
1224: retcode := 1;--completes with warning status --Bug Fix 5527848
1225: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1226:
1227:
1228: when OTHERS then
1229: WriteToLog('OTHERS excpn in cto_cost_rollup: '||to_char(l_stat_num)||'::'||sqlerrm);

Line 1232: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1228: when OTHERS then
1229: WriteToLog('OTHERS excpn in cto_cost_rollup: '||to_char(l_stat_num)||'::'||sqlerrm);
1230: errbuf := 'Completed with error';
1231: retcode := 2;--completes with error status
1232: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1233:
1234: END cto_cost_rollup;
1235:
1236: PROCEDURE get_sourcing_org (

Line 1269: p_return_status := FND_API.G_RET_STS_SUCCESS;

1265: ' and orgn_id: ' || p_organization_id) ;
1266:
1267: lStmtNum := 0 ;
1268:
1269: p_return_status := FND_API.G_RET_STS_SUCCESS;
1270:
1271: v_buy_traversed := FALSE ;
1272:
1273: WriteToLog( 'calling query sourcing org ') ;

Line 1284: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1280: ,p_t_sourcing_info => v_t_sourcing_info
1281: ,x_exp_error_code => x_exp_error_code
1282: ,x_return_status => x_return_status );
1283:
1284: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1285:
1286: WriteToLog(' Error in query_sourcing_org_ms.. ');
1287: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1288:

Line 1287: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1283:
1284: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1285:
1286: WriteToLog(' Error in query_sourcing_org_ms.. ');
1287: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1288:
1289: END IF;
1290:
1291:

Line 1328: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1324:
1325: when others then
1326:
1327: WriteToLog( ' errored into type 1,2 at ' || lStmtNum || ' err ' || SQLERRM ) ;
1328: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1329:
1330: end ;
1331:
1332:

Line 1354: raise FND_API.G_EXC_ERROR;

1350:
1351: lStmtNum := 9;
1352: IF l_circular_src = 'Y' THEN
1353: WriteToLog( ' Circular Sourcing detected ..');
1354: raise FND_API.G_EXC_ERROR;
1355: END IF;
1356:
1357:
1358: end if;

Line 1407: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1403:
1404: when others then
1405:
1406: WriteToLog( ' errored inserting at ' || lStmtNum || ' err ' || SQLERRM ) ;
1407: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1408:
1409: end ;
1410:
1411:

Line 1440: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1436:
1437: when others then
1438:
1439: WriteToLog( ' errored into type 3 at ' || lStmtNum || ' err ' || SQLERRM) ;
1440: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1441:
1442: end ;
1443:
1444:

Line 1490: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1486:
1487: when others then
1488:
1489: WriteToLog( ' errored inserting at ' || lStmtNum || ' err ' || SQLERRM ) ;
1490: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1491:
1492: end ;
1493:
1494:

Line 1514: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1510: get_sourcing_org( p_config_item_id
1511: , v_t_sourcing_info.source_organization_id(i)
1512: , x_return_status
1513: );
1514: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1515: WriteToLog('get_sourcing_org: ' || 'raised Unexpected error.');
1516: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1517:
1518: elsif (x_return_status = FND_API.G_RET_STS_ERROR) then

Line 1516: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1512: , x_return_status
1513: );
1514: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1515: WriteToLog('get_sourcing_org: ' || 'raised Unexpected error.');
1516: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1517:
1518: elsif (x_return_status = FND_API.G_RET_STS_ERROR) then
1519: WriteToLog('get_sourcing_org: ' || 'raised Expected error.');
1520: raise FND_API.G_EXC_ERROR;

Line 1518: elsif (x_return_status = FND_API.G_RET_STS_ERROR) then

1514: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1515: WriteToLog('get_sourcing_org: ' || 'raised Unexpected error.');
1516: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1517:
1518: elsif (x_return_status = FND_API.G_RET_STS_ERROR) then
1519: WriteToLog('get_sourcing_org: ' || 'raised Expected error.');
1520: raise FND_API.G_EXC_ERROR;
1521:
1522: end if;

Line 1520: raise FND_API.G_EXC_ERROR;

1516: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1517:
1518: elsif (x_return_status = FND_API.G_RET_STS_ERROR) then
1519: WriteToLog('get_sourcing_org: ' || 'raised Expected error.');
1520: raise FND_API.G_EXC_ERROR;
1521:
1522: end if;
1523:
1524: end if;

Line 1562: raise FND_API.G_EXC_ERROR;

1558: -- This is because if we not set the token once again the
1559: -- second add will not get the message.
1560:
1561: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
1562: raise FND_API.G_EXC_ERROR;
1563:
1564: END;
1565:
1566: l_curr_src_org := p_organization_id ;

Line 1618: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1614:
1615: when others then
1616:
1617: WriteToLog( ' errored inserting at ' || lStmtNum || ' err ' || SQLERRM ) ;
1618: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1619:
1620: end ;
1621:
1622:

Line 1628: when FND_API.G_EXC_ERROR then

1624:
1625: end if;
1626:
1627: EXCEPTION
1628: when FND_API.G_EXC_ERROR then
1629: WriteToLog('get_sourcing_org: ' || 'EXPECTED ERROR:' || to_char(lStmtNum),1);
1630: p_return_status := FND_API.G_RET_STS_ERROR;
1631:
1632:

Line 1630: p_return_status := FND_API.G_RET_STS_ERROR;

1626:
1627: EXCEPTION
1628: when FND_API.G_EXC_ERROR then
1629: WriteToLog('get_sourcing_org: ' || 'EXPECTED ERROR:' || to_char(lStmtNum),1);
1630: p_return_status := FND_API.G_RET_STS_ERROR;
1631:
1632:
1633: when FND_API.G_EXC_UNEXPECTED_ERROR then
1634: WriteToLog('get_sourcing_org: ' || 'UNEXPECTED ERROR:' || to_char(lStmtNum),1);

Line 1633: when FND_API.G_EXC_UNEXPECTED_ERROR then

1629: WriteToLog('get_sourcing_org: ' || 'EXPECTED ERROR:' || to_char(lStmtNum),1);
1630: p_return_status := FND_API.G_RET_STS_ERROR;
1631:
1632:
1633: when FND_API.G_EXC_UNEXPECTED_ERROR then
1634: WriteToLog('get_sourcing_org: ' || 'UNEXPECTED ERROR:' || to_char(lStmtNum),1);
1635: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1636:
1637:

Line 1635: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1631:
1632:
1633: when FND_API.G_EXC_UNEXPECTED_ERROR then
1634: WriteToLog('get_sourcing_org: ' || 'UNEXPECTED ERROR:' || to_char(lStmtNum),1);
1635: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1636:
1637:
1638: when OTHERS then
1639: WriteToLog('OTHERS excpn in get_sourcing_org: '||to_char(lStmtNum)||'::'||sqlerrm);

Line 1640: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1636:
1637:
1638: when OTHERS then
1639: WriteToLog('OTHERS excpn in get_sourcing_org: '||to_char(lStmtNum)||'::'||sqlerrm);
1640: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1641:
1642:
1643: END get_sourcing_org;
1644: