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

Line 55: x_return_status := FND_API.G_RET_STS_SUCCESS;

51: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.BEGIN',
52: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_FROM_SOURCE_DOC(+)');
53: END IF;
54:
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: IF (g_level_statement >= g_current_runtime_level ) THEN
58: FND_LOG.STRING(g_level_statement,
59: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',

Line 223: x_return_status := FND_API.G_RET_STS_SUCCESS;

219: ' taxation_country = ' || p_taxation_country||
220: ' document_sub_type = ' || p_document_sub_type);
221: END IF;
222:
223: x_return_status := FND_API.G_RET_STS_SUCCESS;
224:
225: l_trx_date := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_DATE(p_trx_line_index);
226:
227: l_country_code := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY(p_trx_line_index);

Line 269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

265: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LEGAL_ENTITY_ID(p_trx_line_index),
266: l_country_code,
267: x_return_status );
268:
269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
270: IF (g_level_error >= g_current_runtime_level ) THEN
271: FND_LOG.STRING(g_level_error,
272: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
273: 'Incorrect return_status after calling ' ||

Line 342: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

338: p_org_id => NULL,
339: p_default_code => l_document_sub_type,
340: p_return_status => x_return_status);
341:
342: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
343: IF (g_level_error >= g_current_runtime_level ) THEN
344: FND_LOG.STRING(g_level_error,
345: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
346: 'Incorrect return_status after calling ' ||

Line 402: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

398: JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(
399: p_trx_line_index => p_trx_line_index,
400: x_return_status => x_return_status);
401:
402: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
403: IF (g_level_error >= g_current_runtime_level ) THEN
404: FND_LOG.STRING(g_level_error,
405: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
406: 'Incorrect return_status after calling ' ||

Line 441: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

437: x_prod_fisc_class_code => l_product_fisc_class,
438: x_product_type => l_product_type
439: );
440:
441: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
442: IF (g_level_error >= g_current_runtime_level ) THEN
443: FND_LOG.STRING(g_level_error,
444: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
445: 'Incorrect return_status after calling ' ||

Line 481: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

477: -- p_org_id => NULL,
478: -- p_default_code => l_user_defined_fisc_class,
479: -- p_return_status => x_return_status);
480: --
481: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
482: -- IF (g_level_statement >= g_current_runtime_level ) THEN
483: -- FND_LOG.STRING(g_level_statement,
484: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
485: -- 'Incorrect return_status after calling ' ||

Line 517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

513: EXCEPTION
514:
515: WHEN OTHERS THEN
516:
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
519: l_context_info_rec.APPLICATION_ID := p_event_class_rec.application_id;
520: l_context_info_rec.ENTITY_CODE := p_event_class_rec.entity_code;
521: l_context_info_rec.EVENT_CLASS_CODE := p_event_class_rec.event_class_code;

Line 562: x_return_status := FND_API.G_RET_STS_SUCCESS;

558: l_context_info_rec ZX_API_PUB.context_info_rec_type;
559:
560: BEGIN
561: -- start bug#6503114
562: x_return_status := FND_API.G_RET_STS_SUCCESS;
563: -- end bug#6503114
564:
565: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
566: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

Line 628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

624: EXCEPTION
625:
626: WHEN OTHERS THEN
627:
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
630: l_context_info_rec.APPLICATION_ID := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index);
631: l_context_info_rec.ENTITY_CODE := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index);
632: l_context_info_rec.EVENT_CLASS_CODE := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index);

Line 673: x_return_status := FND_API.G_RET_STS_SUCCESS;

669: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
670: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
671: END IF;
672:
673: x_return_status := FND_API.G_RET_STS_SUCCESS;
674:
675: -- If Application is PO and Input classification code is Null then default the value.
676: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLICATION_ID(p_trx_line_index) = 201 AND
677: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE(p_trx_line_index) IS NULL THEN

Line 757: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

753: p_return_status => x_return_status,
754: p_error_buffer => l_error_buffer
755: );
756:
757: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
758:
759: IF (g_level_error >= g_current_runtime_level ) THEN
760: FND_LOG.STRING(g_level_error,
761: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_CLASSIFICATION',

Line 814: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

810: p_document_sub_type,
811: x_return_status
812: );
813:
814: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
815: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
816: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
817: 'after calling default_tax_det_factors RETURN_STATUS = ' || x_return_status);
818: END IF;

Line 830: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

826: p_tax_invoice_date,
827: x_return_status
828: );
829:
830: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
831: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
832: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
833: 'after calling default_tax_reporting_attribs RETURN_STATUS = ' || x_return_status);
834: END IF;

Line 844: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

840: p_trx_line_index,
841: x_return_status
842: );
843:
844: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
845: IF ( G_LEVEL_error >= G_CURRENT_RUNTIME_LEVEL) THEN
846: FND_LOG.STRING(G_LEVEL_error,G_MODULE_NAME||l_api_name,
847: 'after calling default_tax_classification RETURN_STATUS = ' || x_return_status);
848: END IF;

Line 881: x_return_status := FND_API.G_RET_STS_SUCCESS;

877: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.BEGIN',
878: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use(+)');
879: END IF;
880:
881: x_return_status := FND_API.G_RET_STS_SUCCESS;
882:
883: -- get tax method
884: --
885:

Line 891: IF x_return_status = FND_API.G_RET_STS_ERROR then

887: (p_application_id => p_application_id,
888: p_org_id => p_internal_org_id,
889: x_product_options_rec => l_zx_proudct_options_rec,
890: x_return_status => x_return_status);
891: IF x_return_status = FND_API.G_RET_STS_ERROR then
892: l_tax_method := 'EBTAX';
893: ELSE
894: l_tax_method := l_zx_proudct_options_rec.tax_method_code;
895: END IF;

Line 911: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

907: p_item_id => p_item_id,
908: p_default_code => x_intended_use,
909: p_return_status => x_return_status);
910:
911: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
912: IF (g_level_statement >= g_current_runtime_level ) THEN
913: FND_LOG.STRING(g_level_statement,
914: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use',
915: 'Incorrect return_status after calling ' ||

Line 937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

933:
934: EXCEPTION
935: WHEN OTHERS THEN
936:
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: x_intended_use := NULL;
939:
940: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
941: FND_MSG_PUB.Add;

Line 979: x_return_status := FND_API.G_RET_STS_SUCCESS;

975: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.BEGIN',
976: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code(+)');
977: END IF;
978:
979: x_return_status := FND_API.G_RET_STS_SUCCESS;
980:
981: ZX_GLOBAL_STRUCTURES_PKG.get_product_options_info
982: (p_application_id => p_application_id,
983: p_org_id => p_internal_org_id,

Line 986: IF x_return_status = FND_API.G_RET_STS_ERROR then

982: (p_application_id => p_application_id,
983: p_org_id => p_internal_org_id,
984: x_product_options_rec => l_zx_proudct_options_rec,
985: x_return_status => x_return_status);
986: IF x_return_status = FND_API.G_RET_STS_ERROR then
987: l_tax_method := 'EBTAX';
988: ELSE
989: l_tax_method := l_zx_proudct_options_rec.tax_method_code;
990: END IF;

Line 1002: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

998: p_org_id => p_item_org_id,
999: p_default_code => x_prod_fisc_class_code,
1000: p_return_status => x_return_status);
1001:
1002: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1003: IF (g_level_error >= g_current_runtime_level ) THEN
1004: FND_LOG.STRING(g_level_error,
1005: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code',
1006: 'Incorrect return_status after calling ' ||

Line 1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1041: FND_LOG.STRING(g_level_unexpected,
1042: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code',
1043: 'Unable to default Product Fiscal Classification which is mandatory for LTE');
1044: END IF;
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046:
1047: END;
1048: ELSIF p_item_id IS NOT NULL and p_item_org_id IS NULL THEN
1049:

Line 1068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1064: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
1065: 'Unable to default Product Fiscal Classification ot Trx Business Category'||
1066: ' which is mandatory for LTE');
1067: END IF;
1068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1069: END;
1070: END IF;
1071: END IF;
1072:

Line 1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1082:
1083: EXCEPTION
1084: WHEN OTHERS THEN
1085:
1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: x_prod_fisc_class_code := NULL;
1088:
1089: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1090: FND_MSG_PUB.Add;

Line 1129: x_return_status := FND_API.G_RET_STS_SUCCESS;

1125: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value.BEGIN',
1126: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value(+)');
1127: END IF;
1128:
1129: x_return_status := FND_API.G_RET_STS_SUCCESS;
1130:
1131: -- Just assign line_amt to the x_assessable_vale. For the logic to get default
1132: -- assessable value will be determinered based on the input parameters
1133: --

Line 1147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1143:
1144: EXCEPTION
1145: WHEN OTHERS THEN
1146:
1147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1148: x_assessable_value := NULL;
1149:
1150: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1151: FND_MSG_PUB.Add;

Line 1197: x_return_status := FND_API.G_RET_STS_SUCCESS;

1193: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.BEGIN',
1194: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(+)');
1195: END IF;
1196:
1197: x_return_status := FND_API.G_RET_STS_SUCCESS;
1198:
1199: l_tax_code_id :=
1200: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_tax_code_id(
1201: p_trx_line_index);

Line 1213: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1209: l_tax_determine_date,
1210: l_tax_point_date,
1211: x_return_status);
1212:
1213: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1214: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1215: FND_LOG.STRING(g_level_unexpected,
1216: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1217: 'Incorrect return_status after calling ' ||

Line 1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261;

1240: FND_LOG.STRING(g_level_unexpected,
1241: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1242: 'Invalid Tax Code Id: No Record Found');
1243: END IF;
1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261;
1245: END;
1246:
1247: IF l_effective_from <= l_tax_determine_date AND
1248: (l_effective_to >= l_tax_determine_date OR l_effective_to IS NULL)

Line 1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

1257: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1258: 'No Valid Tax Classification Code Found for Tax Code Id: ' ||
1259: l_tax_code_id);
1260: END IF;
1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
1262: RETURN;
1263: END IF;
1264: END IF;
1265:

Line 1285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

1281: FND_LOG.STRING(g_level_unexpected,
1282: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',
1283: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)');
1284: END IF;
1285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
1286: RETURN;
1287: END IF;
1288:
1289: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.global_attribute1(

Line 1332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

1328: FND_LOG.STRING(g_level_unexpected,
1329: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1330: 'Not MTL Item Found');
1331: END IF;
1332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
1333: END;
1334:
1335: IF l_inv_flag = 'I' THEN
1336:

Line 1379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

1375: FND_LOG.STRING(g_level_unexpected,
1376: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1377: 'Not MTL Item Found');
1378: END IF;
1379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
1380: END;
1381: END IF;
1382: END IF;
1383:

Line 1394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1390:
1391: EXCEPTION
1392: WHEN OTHERS THEN
1393:
1394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1395:
1396: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1397: l_context_info_rec.APPLICATION_ID := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index);
1398: l_context_info_rec.ENTITY_CODE := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index);

Line 1449: x_return_status := FND_API.G_RET_STS_SUCCESS;

1445: ' p_internal_org_id := ' || to_char(p_internal_org_id) ||
1446: ' p_legal_entity_id := ' || to_char(p_legal_entity_id) );
1447: END IF;
1448:
1449: x_return_status := FND_API.G_RET_STS_SUCCESS;
1450:
1451: IF p_tax_method_code = 'LTE' THEN
1452:
1453: BEGIN

Line 1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1459: AND global_attribute_category like 'JL%';
1460:
1461: EXCEPTION
1462: WHEN NO_DATA_FOUND THEN
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464: IF (g_level_statement >= g_current_runtime_level ) THEN
1465: FND_LOG.STRING(g_level_statement,
1466: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1467: 'No COUNTRY_CODE Found For LTE.');

Line 1470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1466: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1467: 'No COUNTRY_CODE Found For LTE.');
1468: END IF;
1469: WHEN OTHERS THEN
1470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1471: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1472: FND_LOG.STRING(g_level_unexpected,
1473: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1474: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));

Line 1486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1482: FROM XLE_FIRSTPARTY_INFORMATION_V le
1483: WHERE le.legal_entity_id = p_legal_entity_id;
1484: EXCEPTION
1485: WHEN NO_DATA_FOUND THEN
1486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1487: IF (g_level_statement >= g_current_runtime_level ) THEN
1488: FND_LOG.STRING(g_level_statement,
1489: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1490: 'No COUNTRY_CODE Found for EBTax. ');

Line 1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1489: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1490: 'No COUNTRY_CODE Found for EBTax. ');
1491: END IF;
1492: WHEN OTHERS THEN
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1494: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1495: FND_LOG.STRING(g_level_unexpected,
1496: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1497: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));