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 468: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

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

Line 471: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

559: p_return_status => l_return_status );
560:
561: WriteToLog ('** l_return_status = '|| l_return_status );
562:
563: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
564: WriteToLog('get_sourcing_org: ' || 'raised Unexpected error.');
565: ROLLBACK TO CTOCCR;
566: raise FND_API.G_EXC_UNEXPECTED_ERROR;
567:

Line 566: raise FND_API.G_EXC_UNEXPECTED_ERROR;

562:
563: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
564: WriteToLog('get_sourcing_org: ' || 'raised Unexpected error.');
565: ROLLBACK TO CTOCCR;
566: raise FND_API.G_EXC_UNEXPECTED_ERROR;
567:
568: elsif (l_return_status = FND_API.G_RET_STS_ERROR) then
569: retcode := 1; -- Set this for conc request to end in WARNING
570: WriteToLog('get_sourcing_org: ' || 'raised Expected error.');

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

564: WriteToLog('get_sourcing_org: ' || 'raised Unexpected error.');
565: ROLLBACK TO CTOCCR;
566: raise FND_API.G_EXC_UNEXPECTED_ERROR;
567:
568: elsif (l_return_status = FND_API.G_RET_STS_ERROR) then
569: retcode := 1; -- Set this for conc request to end in WARNING
570: WriteToLog('get_sourcing_org: ' || 'raised Expected error.');
571: ROLLBACK TO CTOCCR;
572: goto beginloop;

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

773: get_sourcing_org (p_config_item_id => l_child_config_item ,
774: p_organization_id => l_parent_org_id ,
775: p_return_status => l_return_status );
776:
777: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
778: WriteToLog('get_sourcing_org: ' || 'raised Unexpected error.');
779: ROLLBACK TO CTOCCR;
780: raise FND_API.G_EXC_UNEXPECTED_ERROR;
781: elsif (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 780: raise FND_API.G_EXC_UNEXPECTED_ERROR;

776:
777: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
778: WriteToLog('get_sourcing_org: ' || 'raised Unexpected error.');
779: ROLLBACK TO CTOCCR;
780: raise FND_API.G_EXC_UNEXPECTED_ERROR;
781: elsif (l_return_status = FND_API.G_RET_STS_ERROR) then
782: retcode := 1; -- Set this for conc request to end in WARNING
783: WriteToLog('get_sourcing_org: ' || 'raised Expected error.');
784: ROLLBACK TO CTOCCR;

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

777: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
778: WriteToLog('get_sourcing_org: ' || 'raised Unexpected error.');
779: ROLLBACK TO CTOCCR;
780: raise FND_API.G_EXC_UNEXPECTED_ERROR;
781: elsif (l_return_status = FND_API.G_RET_STS_ERROR) then
782: retcode := 1; -- Set this for conc request to end in WARNING
783: WriteToLog('get_sourcing_org: ' || 'raised Expected error.');
784: ROLLBACK TO CTOCCR;
785: goto beginloop;

Line 1162: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1158: end loop;
1159: WriteToLog ('====================================================================', 1);
1160: WriteToLog('Total records not been processed successfully .. ' || fail_item_arr.count , 1);
1161: WriteToLog ('====================================================================', 1);
1162: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1163: end if;
1164:
1165: if config_cv%ISOPEN then
1166: CLOSE config_cv;

Line 1170: when FND_API.G_EXC_ERROR then

1166: CLOSE config_cv;
1167: end if;
1168:
1169: EXCEPTION
1170: when FND_API.G_EXC_ERROR then
1171: WriteToLog('cto_cost_rollup: ' || 'EXPECTED ERROR:' || to_char(l_stat_num),1);
1172: retcode := 1;--completes with warning status -- Bug Fix 5527848
1173: l_return_status := FND_API.G_RET_STS_ERROR;
1174:

Line 1173: l_return_status := FND_API.G_RET_STS_ERROR;

1169: EXCEPTION
1170: when FND_API.G_EXC_ERROR then
1171: WriteToLog('cto_cost_rollup: ' || 'EXPECTED ERROR:' || to_char(l_stat_num),1);
1172: retcode := 1;--completes with warning status -- Bug Fix 5527848
1173: l_return_status := FND_API.G_RET_STS_ERROR;
1174:
1175:
1176: when FND_API.G_EXC_UNEXPECTED_ERROR then
1177: WriteToLog('cto_cost_rollup: ' || 'UNEXPECTED ERROR:' || to_char(l_stat_num),1);

Line 1176: when FND_API.G_EXC_UNEXPECTED_ERROR then

1172: retcode := 1;--completes with warning status -- Bug Fix 5527848
1173: l_return_status := FND_API.G_RET_STS_ERROR;
1174:
1175:
1176: when FND_API.G_EXC_UNEXPECTED_ERROR then
1177: WriteToLog('cto_cost_rollup: ' || 'UNEXPECTED ERROR:' || to_char(l_stat_num),1);
1178: retcode := 1;--completes with warning status --Bug Fix 5527848
1179: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1180:

Line 1179: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1175:
1176: when FND_API.G_EXC_UNEXPECTED_ERROR then
1177: WriteToLog('cto_cost_rollup: ' || 'UNEXPECTED ERROR:' || to_char(l_stat_num),1);
1178: retcode := 1;--completes with warning status --Bug Fix 5527848
1179: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1180:
1181:
1182: when OTHERS then
1183: WriteToLog('OTHERS excpn in cto_cost_rollup: '||to_char(l_stat_num)||'::'||sqlerrm);

Line 1186: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1182: when OTHERS then
1183: WriteToLog('OTHERS excpn in cto_cost_rollup: '||to_char(l_stat_num)||'::'||sqlerrm);
1184: errbuf := 'Completed with error';
1185: retcode := 2;--completes with error status
1186: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1187:
1188: END cto_cost_rollup;
1189:
1190: PROCEDURE get_sourcing_org (

Line 1223: p_return_status := FND_API.G_RET_STS_SUCCESS;

1219: ' and orgn_id: ' || p_organization_id) ;
1220:
1221: lStmtNum := 0 ;
1222:
1223: p_return_status := FND_API.G_RET_STS_SUCCESS;
1224:
1225: v_buy_traversed := FALSE ;
1226:
1227: WriteToLog( 'calling query sourcing org ') ;

Line 1238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1234: ,p_t_sourcing_info => v_t_sourcing_info
1235: ,x_exp_error_code => x_exp_error_code
1236: ,x_return_status => x_return_status );
1237:
1238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1239:
1240: WriteToLog(' Error in query_sourcing_org_ms.. ');
1241: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1242:

Line 1241: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1237:
1238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1239:
1240: WriteToLog(' Error in query_sourcing_org_ms.. ');
1241: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1242:
1243: END IF;
1244:
1245:

Line 1282: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1278:
1279: when others then
1280:
1281: WriteToLog( ' errored into type 1,2 at ' || lStmtNum || ' err ' || SQLERRM ) ;
1282: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1283:
1284: end ;
1285:
1286:

Line 1308: raise FND_API.G_EXC_ERROR;

1304:
1305: lStmtNum := 9;
1306: IF l_circular_src = 'Y' THEN
1307: WriteToLog( ' Circular Sourcing detected ..');
1308: raise FND_API.G_EXC_ERROR;
1309: END IF;
1310:
1311:
1312: end if;

Line 1361: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1357:
1358: when others then
1359:
1360: WriteToLog( ' errored inserting at ' || lStmtNum || ' err ' || SQLERRM ) ;
1361: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1362:
1363: end ;
1364:
1365:

Line 1394: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1390:
1391: when others then
1392:
1393: WriteToLog( ' errored into type 3 at ' || lStmtNum || ' err ' || SQLERRM) ;
1394: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1395:
1396: end ;
1397:
1398:

Line 1444: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1440:
1441: when others then
1442:
1443: WriteToLog( ' errored inserting at ' || lStmtNum || ' err ' || SQLERRM ) ;
1444: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1445:
1446: end ;
1447:
1448:

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

1464: get_sourcing_org( p_config_item_id
1465: , v_t_sourcing_info.source_organization_id(i)
1466: , x_return_status
1467: );
1468: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1469: WriteToLog('get_sourcing_org: ' || 'raised Unexpected error.');
1470: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1471:
1472: elsif (x_return_status = FND_API.G_RET_STS_ERROR) then

Line 1470: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1466: , x_return_status
1467: );
1468: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1469: WriteToLog('get_sourcing_org: ' || 'raised Unexpected error.');
1470: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1471:
1472: elsif (x_return_status = FND_API.G_RET_STS_ERROR) then
1473: WriteToLog('get_sourcing_org: ' || 'raised Expected error.');
1474: raise FND_API.G_EXC_ERROR;

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

1468: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1469: WriteToLog('get_sourcing_org: ' || 'raised Unexpected error.');
1470: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1471:
1472: elsif (x_return_status = FND_API.G_RET_STS_ERROR) then
1473: WriteToLog('get_sourcing_org: ' || 'raised Expected error.');
1474: raise FND_API.G_EXC_ERROR;
1475:
1476: end if;

Line 1474: raise FND_API.G_EXC_ERROR;

1470: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1471:
1472: elsif (x_return_status = FND_API.G_RET_STS_ERROR) then
1473: WriteToLog('get_sourcing_org: ' || 'raised Expected error.');
1474: raise FND_API.G_EXC_ERROR;
1475:
1476: end if;
1477:
1478: end if;

Line 1516: raise FND_API.G_EXC_ERROR;

1512: -- This is because if we not set the token once again the
1513: -- second add will not get the message.
1514:
1515: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
1516: raise FND_API.G_EXC_ERROR;
1517:
1518: END;
1519:
1520: l_curr_src_org := p_organization_id ;

Line 1572: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1568:
1569: when others then
1570:
1571: WriteToLog( ' errored inserting at ' || lStmtNum || ' err ' || SQLERRM ) ;
1572: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1573:
1574: end ;
1575:
1576:

Line 1582: when FND_API.G_EXC_ERROR then

1578:
1579: end if;
1580:
1581: EXCEPTION
1582: when FND_API.G_EXC_ERROR then
1583: WriteToLog('get_sourcing_org: ' || 'EXPECTED ERROR:' || to_char(lStmtNum),1);
1584: p_return_status := FND_API.G_RET_STS_ERROR;
1585:
1586:

Line 1584: p_return_status := FND_API.G_RET_STS_ERROR;

1580:
1581: EXCEPTION
1582: when FND_API.G_EXC_ERROR then
1583: WriteToLog('get_sourcing_org: ' || 'EXPECTED ERROR:' || to_char(lStmtNum),1);
1584: p_return_status := FND_API.G_RET_STS_ERROR;
1585:
1586:
1587: when FND_API.G_EXC_UNEXPECTED_ERROR then
1588: WriteToLog('get_sourcing_org: ' || 'UNEXPECTED ERROR:' || to_char(lStmtNum),1);

Line 1587: when FND_API.G_EXC_UNEXPECTED_ERROR then

1583: WriteToLog('get_sourcing_org: ' || 'EXPECTED ERROR:' || to_char(lStmtNum),1);
1584: p_return_status := FND_API.G_RET_STS_ERROR;
1585:
1586:
1587: when FND_API.G_EXC_UNEXPECTED_ERROR then
1588: WriteToLog('get_sourcing_org: ' || 'UNEXPECTED ERROR:' || to_char(lStmtNum),1);
1589: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1590:
1591:

Line 1589: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1585:
1586:
1587: when FND_API.G_EXC_UNEXPECTED_ERROR then
1588: WriteToLog('get_sourcing_org: ' || 'UNEXPECTED ERROR:' || to_char(lStmtNum),1);
1589: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1590:
1591:
1592: when OTHERS then
1593: WriteToLog('OTHERS excpn in get_sourcing_org: '||to_char(lStmtNum)||'::'||sqlerrm);

Line 1594: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1590:
1591:
1592: when OTHERS then
1593: WriteToLog('OTHERS excpn in get_sourcing_org: '||to_char(lStmtNum)||'::'||sqlerrm);
1594: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595:
1596:
1597: END get_sourcing_org;
1598: