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

Line 108: p_return_status := FND_API.G_RET_STS_SUCCESS;

104: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.PROCESS_OFFSET_TAX.BEGIN',
105: 'ZX_TDS_OFFSET_TAX_DETM_PKG: PROCESS_OFFSET_TAX(+)');
106: END IF;
107:
108: p_return_status := FND_API.G_RET_STS_SUCCESS;
109: p_error_buffer := NULL;
110:
111: -- Bug#5417753- determine tax_class value
112: IF p_event_class_rec.prod_family_grp_code = 'O2C' THEN

Line 140: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

136: p_tax_rate_rec => l_tax_rate_rec,
137: p_return_status => p_return_status,
138: p_error_buffer => p_error_buffer
139: );
140: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
141: IF (g_level_error >= g_current_runtime_level) THEN
142: FND_LOG.STRING(g_level_error,
143: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.PROCESS_OFFSET_TAX',
144: 'Incorrect status returned from ZX_TDS_UTILITIES_PKG.get_tax_rate_info'||

Line 174: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

170: l_offset_tax_rate,
171: p_return_status,
172: p_error_buffer);
173:
174: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
175: --
176: -- bug#4893261- need to seed ZX_OFFSET_RATE_NOT_FOUND
177: --
178: IF p_return_status = FND_API.G_RET_STS_ERROR THEN

Line 178: IF p_return_status = FND_API.G_RET_STS_ERROR THEN

174: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
175: --
176: -- bug#4893261- need to seed ZX_OFFSET_RATE_NOT_FOUND
177: --
178: IF p_return_status = FND_API.G_RET_STS_ERROR THEN
179: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.application_id :=
180: p_offset_tax_line_rec.application_id;
181: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.entity_code :=
182: p_offset_tax_line_rec.entity_code;

Line 218: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

214: l_offset_tax,
215: l_offset_tax_status_code,
216: p_return_status,
217: p_error_buffer);
218: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
219: RETURN;
220: END IF;
221:
222: IF (g_level_procedure >= g_current_runtime_level) THEN

Line 230: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

226: END IF;
227:
228: EXCEPTION
229: WHEN OTHERS THEN
230: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
231: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
232:
233: IF (g_level_unexpected >= g_current_runtime_level) THEN
234: FND_LOG.STRING(g_level_unexpected,

Line 305: p_return_status := FND_API.G_RET_STS_SUCCESS;

301: 'p_tax_class = ' || p_tax_class ||
302: 'p_tax_status_code = ' || p_tax_status_code);
303: END IF;
304:
305: p_return_status := FND_API.G_RET_STS_SUCCESS;
306:
307: /* Bug#5417753- use cache structure
308: OPEN get_offset_info_csr(p_tax_rate_code,
309: p_tax,

Line 319: p_return_status := FND_API.G_RET_STS_ERROR;

315: l_Rate_Type_Code,
316: l_percentage_rate,
317: l_quantity_rate;
318: IF get_offset_info_csr%NOTFOUND THEN
319: p_return_status := FND_API.G_RET_STS_ERROR;
320: p_error_buffer := 'No data found for the specified tax rate ';
321: END IF;
322: CLOSE get_offset_info_csr;
323: */

Line 337: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

333: l_tax_rate_rec,
334: p_return_status,
335: p_error_buffer);
336:
337: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
338: p_offset_tax_rate_id := l_tax_rate_rec.tax_rate_id;
339:
340: IF l_tax_rate_rec.Rate_Type_Code = 'PERCENTAGE' THEN
341: p_tax_rate := l_tax_rate_rec.percentage_rate;

Line 356: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

352: END IF;
353:
354: EXCEPTION
355: WHEN OTHERS THEN
356: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
358:
359: IF (FND_LOG.LEVEL_UNEXPECTED >= g_current_runtime_level) THEN
360: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

Line 507: p_return_status := FND_API.G_RET_STS_SUCCESS;

503: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_amt_columns.BEGIN',
504: 'ZX_TDS_OFFSET_TAX_DETM_PKG: set_amt_columns(+)');
505: END IF;
506:
507: p_return_status := FND_API.G_RET_STS_SUCCESS;
508:
509: --
510: -- taxable amounts would be same as the original tax line
511: -- do not need to change unrounded_taxable_amt,

Line 614: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

610: l_tax_precision,
611: p_return_status,
612: p_error_buffer);
613:
614: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
615: RETURN;
616: END IF;
617:
618: --

Line 651: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

647: END IF;
648:
649: EXCEPTION
650: WHEN OTHERS THEN
651: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
652: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
653:
654: IF (g_level_unexpected >= g_current_runtime_level) THEN
655: FND_LOG.STRING(g_level_unexpected,

Line 687: p_return_status := FND_API.G_RET_STS_SUCCESS;

683: FND_LOG.STRING(g_level_statement,
684: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_status_id.BEGIN',
685: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_tax_status_id(+)');
686: END IF;
687: p_return_status := FND_API.G_RET_STS_SUCCESS;
688:
689: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
690: p_tax,
691: p_tax_regime_code,

Line 698: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

694: l_status_rec,
695: p_return_status,
696: p_error_buffer);
697:
698: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
699: p_tax_status_id := l_status_rec.tax_status_id;
700: END IF;
701:
702: IF (g_level_statement >= g_current_runtime_level) THEN

Line 710: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

706: END IF;
707:
708: EXCEPTION
709: WHEN OTHERS THEN
710: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
712:
713: IF (g_level_unexpected >= g_current_runtime_level) THEN
714: FND_LOG.STRING(g_level_unexpected,

Line 745: p_return_status := FND_API.G_RET_STS_SUCCESS;

741: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_id.BEGIN',
742: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_tax_id(+)');
743: END IF;
744:
745: p_return_status := FND_API.G_RET_STS_SUCCESS;
746:
747: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
748: p_tax_regime_code,
749: p_tax,

Line 755: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

751: l_tax_rec,
752: p_return_status,
753: p_error_buffer);
754:
755: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
756: p_tax_id := l_tax_rec.tax_id;
757: END IF;
758:
759: IF (g_level_statement >= g_current_runtime_level) THEN

Line 769: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

765: END IF;
766:
767: EXCEPTION
768: WHEN OTHERS THEN
769: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
770: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
771:
772: IF (g_level_unexpected >= g_current_runtime_level) THEN
773: FND_LOG.STRING(g_level_unexpected,

Line 822: p_return_status := FND_API.G_RET_STS_SUCCESS;

818: 'p_offset_link_to_tax_line_id = ' ||
819: to_char(p_offset_tax_line_rec.offset_link_to_tax_line_id));
820: END IF;
821:
822: p_return_status := FND_API.G_RET_STS_SUCCESS;
823:
824: OPEN get_old_offset_tax_line_id_csr;
825: FETCH get_old_offset_tax_line_id_csr INTO p_old_offset_tax_line_id;
826: IF get_old_offset_tax_line_id_csr%NOTFOUND THEN

Line 848: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

844: END IF;
845:
846: EXCEPTION
847: WHEN OTHERS THEN
848: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
850:
851: IF (g_level_unexpected >= g_current_runtime_level) THEN
852: FND_LOG.STRING(g_level_unexpected,

Line 901: p_return_status := FND_API.G_RET_STS_SUCCESS;

897: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.create_offset_tax_line.BEGIN',
898: 'ZX_TDS_OFFSET_TAX_DETM_PKG: create_offset_tax_line(+)');
899: END IF;
900:
901: p_return_status := FND_API.G_RET_STS_SUCCESS;
902:
903: --
904: -- set link to current non offset tax line
905: --

Line 939: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

935: ZX_TDS_TAX_LINES_POPU_PKG.populate_mandatory_columns(
936: p_offset_tax_line_rec,
937: p_return_status,
938: p_error_buffer);
939: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
940: RETURN;
941: END IF;
942:
943: --

Line 965: IF p_return_status <>FND_API.G_RET_STS_SUCCESS THEN

961: p_offset_tax_line_rec.tax_determine_date,
962: p_offset_tax_line_rec.tax_id,
963: p_return_status,
964: p_error_buffer);
965: IF p_return_status <>FND_API.G_RET_STS_SUCCESS THEN
966: RETURN;
967: END IF;
968:
969: p_offset_tax_line_rec.tax_status_code := p_offset_status_code;

Line 977: IF p_return_status <>FND_API.G_RET_STS_SUCCESS THEN

973: p_offset_tax_line_rec.tax_determine_date,
974: p_offset_tax_line_rec.tax_status_id,
975: p_return_status,
976: p_error_buffer);
977: IF p_return_status <>FND_API.G_RET_STS_SUCCESS THEN
978: RETURN;
979: END IF;
980:
981: p_offset_tax_line_rec.tax_type_code :=

Line 993: IF p_return_status <>FND_API.G_RET_STS_SUCCESS THEN

989: p_initial_tax_rate,
990: p_return_status,
991: p_error_buffer);
992:
993: IF p_return_status <>FND_API.G_RET_STS_SUCCESS THEN
994: RETURN;
995: END IF;
996:
997: -- bug 5580990: populate legal_reporting_status

Line 1031: IF p_return_status <>FND_API.G_RET_STS_SUCCESS THEN

1027: l_old_offset_tax_line_id,
1028: p_return_status,
1029: p_error_buffer);
1030:
1031: IF p_return_status <>FND_API.G_RET_STS_SUCCESS THEN
1032: RETURN;
1033: END IF;
1034:
1035: IF l_old_offset_tax_line_id IS NOT NULL THEN

Line 1052: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1048: END IF;
1049:
1050: EXCEPTION
1051: WHEN OTHERS THEN
1052: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1054:
1055: IF (g_level_unexpected >= g_current_runtime_level) THEN
1056: FND_LOG.STRING(g_level_unexpected,