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.ZX_PRD_OPTIONS_MIGRATE_PKG dependencies on FND_API

Line 113: x_return_status := FND_API.G_RET_STS_SUCCESS;

109: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
110: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
111: END IF;
112:
113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114:
115: SELECT decode(l_multi_org_flag,'N',l_org_id, sys.org_id), --org_id
116: tax_hier_po_shipment,
117: tax_hier_vendor_site,

Line 379: x_return_status := FND_API.G_RET_STS_ERROR ;

375: END IF;
376:
377: EXCEPTION
378: WHEN OTHERS THEN
379: x_return_status := FND_API.G_RET_STS_ERROR ;
380: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
381: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT',' AP Tax Options Migration : '||SQLERRM);
382: FND_MSG_PUB.Add;
383: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 402: x_return_status := FND_API.G_RET_STS_SUCCESS;

398: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
399: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
400: END IF;
401:
402: x_return_status := FND_API.G_RET_STS_SUCCESS;
403:
404: SELECT decode(l_multi_org_flag,'N',l_org_id, sys.org_id), --org_id
405: tax_hier_site_exc_rate,
406: tax_hier_cust_exc_rate,

Line 620: x_return_status := FND_API.G_RET_STS_ERROR ;

616: END IF;
617:
618: EXCEPTION
619: WHEN OTHERS THEN
620: x_return_status := FND_API.G_RET_STS_ERROR ;
621: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
622: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','AR Tax Options Migration : '||SQLERRM);
623: FND_MSG_PUB.Add;
624: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 639: x_return_status := FND_API.G_RET_STS_SUCCESS;

635: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
636: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
637: END IF;
638:
639: x_return_status := FND_API.G_RET_STS_SUCCESS;
640:
641: SELECT decode(l_multi_org_flag,'N',l_org_id, sys.org_id), --org_id
642: sys.tax_hier_ship_to_loc,
643: sys.tax_hier_item,

Line 842: x_return_status := FND_API.G_RET_STS_ERROR ;

838: END IF;
839:
840: EXCEPTION
841: WHEN OTHERS THEN
842: x_return_status := FND_API.G_RET_STS_ERROR ;
843: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
844: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','PO Tax Options Migration : '||SQLERRM);
845: FND_MSG_PUB.Add;
846: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 860: x_return_status := FND_API.G_RET_STS_SUCCESS;

856: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
857: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
858: END IF;
859:
860: x_return_status := FND_API.G_RET_STS_SUCCESS;
861:
862: SELECT decode(l_multi_org_flag,'N',l_org_id, sys.org_id), --org_id
863: output_tax_hier_site,
864: output_tax_hier_cust,

Line 1100: x_return_status := FND_API.G_RET_STS_ERROR ;

1096: END IF;
1097:
1098: EXCEPTION
1099: WHEN OTHERS THEN
1100: x_return_status := FND_API.G_RET_STS_ERROR ;
1101: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
1102: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','PA Tax Options Migration : '||SQLERRM);
1103: FND_MSG_PUB.Add;
1104: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1119: x_return_status := FND_API.G_RET_STS_SUCCESS;

1115: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1116: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1117: END IF;
1118:
1119: x_return_status := FND_API.G_RET_STS_SUCCESS;
1120:
1121: INSERT INTO ZX_PRODUCT_OPTIONS_ALL (
1122: PRODUCT_OPTIONS_ID,
1123: ORG_ID,

Line 1208: x_return_status := FND_API.G_RET_STS_ERROR ;

1204: END IF;
1205:
1206: EXCEPTION
1207: WHEN OTHERS THEN
1208: x_return_status := FND_API.G_RET_STS_ERROR ;
1209: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
1210: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','PA Tax Options Migration : '||SQLERRM);
1211: FND_MSG_PUB.Add;
1212: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1228: x_return_status := FND_API.G_RET_STS_SUCCESS;

1224: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1225: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1226: END IF;
1227:
1228: x_return_status := FND_API.G_RET_STS_SUCCESS;
1229:
1230: /*-----------------------------------------------------+
1231: | Process records from AR |
1232: +-----------------------------------------------------*/

Line 1236: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1232: +-----------------------------------------------------*/
1233: AR_PRD_OPTIONS_MIGRATE(l_return_status);
1234:
1235:
1236: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1237: x_return_status := FND_API.G_RET_STS_ERROR ;
1238: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
1239: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Product Tax Options Migration : '||SQLERRM);
1240: FND_MSG_PUB.Add;

Line 1237: x_return_status := FND_API.G_RET_STS_ERROR ;

1233: AR_PRD_OPTIONS_MIGRATE(l_return_status);
1234:
1235:
1236: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1237: x_return_status := FND_API.G_RET_STS_ERROR ;
1238: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
1239: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Product Tax Options Migration : '||SQLERRM);
1240: FND_MSG_PUB.Add;
1241: RETURN;

Line 1250: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1246: | Process records from AP |
1247: +-----------------------------------------------------*/
1248: AP_PRD_OPTIONS_MIGRATE (l_return_status);
1249:
1250: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1251: x_return_status := FND_API.G_RET_STS_ERROR ;
1252: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
1253: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Product Tax Options Migration : '||SQLERRM);
1254: FND_MSG_PUB.Add;

Line 1251: x_return_status := FND_API.G_RET_STS_ERROR ;

1247: +-----------------------------------------------------*/
1248: AP_PRD_OPTIONS_MIGRATE (l_return_status);
1249:
1250: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1251: x_return_status := FND_API.G_RET_STS_ERROR ;
1252: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
1253: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Product Tax Options Migration : '||SQLERRM);
1254: FND_MSG_PUB.Add;
1255: RETURN;

Line 1264: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1260: | Process records from PO |
1261: +-----------------------------------------------------*/
1262: PO_PRD_OPTIONS_MIGRATE (l_return_status);
1263:
1264: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1265: x_return_status := FND_API.G_RET_STS_ERROR ;
1266: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
1267: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Product Tax Options Migration : '||SQLERRM);
1268: FND_MSG_PUB.Add;

Line 1265: x_return_status := FND_API.G_RET_STS_ERROR ;

1261: +-----------------------------------------------------*/
1262: PO_PRD_OPTIONS_MIGRATE (l_return_status);
1263:
1264: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1265: x_return_status := FND_API.G_RET_STS_ERROR ;
1266: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
1267: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Product Tax Options Migration : '||SQLERRM);
1268: FND_MSG_PUB.Add;
1269: RETURN;

Line 1278: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1274: | Process records from PA |
1275: +-----------------------------------------------------*/
1276: PA_PRD_OPTIONS_MIGRATE (l_return_status);
1277:
1278: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1279: x_return_status := FND_API.G_RET_STS_ERROR ;
1280: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
1281: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Product Tax Options Migration : '||SQLERRM);
1282: FND_MSG_PUB.Add;

Line 1279: x_return_status := FND_API.G_RET_STS_ERROR ;

1275: +-----------------------------------------------------*/
1276: PA_PRD_OPTIONS_MIGRATE (l_return_status);
1277:
1278: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1279: x_return_status := FND_API.G_RET_STS_ERROR ;
1280: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
1281: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Product Tax Options Migration : '||SQLERRM);
1282: FND_MSG_PUB.Add;
1283: RETURN;

Line 1291: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1287: | Process records from OIE |
1288: +-----------------------------------------------------*/
1289: OIE_PRD_OPTIONS_MIGRATE (l_return_status);
1290:
1291: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1292: x_return_status := FND_API.G_RET_STS_ERROR ;
1293: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
1294: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Product Tax Options Migration : '||SQLERRM);
1295: FND_MSG_PUB.Add;

Line 1292: x_return_status := FND_API.G_RET_STS_ERROR ;

1288: +-----------------------------------------------------*/
1289: OIE_PRD_OPTIONS_MIGRATE (l_return_status);
1290:
1291: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1292: x_return_status := FND_API.G_RET_STS_ERROR ;
1293: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
1294: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Product Tax Options Migration : '||SQLERRM);
1295: FND_MSG_PUB.Add;
1296: RETURN;