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: FND_MESSAGE.SET_NAME('ZX','ZX_OFFSET_RATE_NOT_FOUND');
180: FND_MESSAGE.SET_TOKEN('TAX_REGIME', l_offset_tax_regime_code);
181: FND_MESSAGE.SET_TOKEN('TAX',l_offset_tax);
182: FND_MESSAGE.SET_TOKEN('TAX_STATUS',l_offset_tax_status_code);

Line 213: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

209: l_offset_tax,
210: l_offset_tax_status_code,
211: p_return_status,
212: p_error_buffer);
213: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
214: RETURN;
215: END IF;
216:
217: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 226: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 302: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 316: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 334: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 354: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 499: p_return_status := FND_API.G_RET_STS_SUCCESS;

495: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_amt_columns.BEGIN',
496: 'ZX_TDS_OFFSET_TAX_DETM_PKG: set_amt_columns(+)');
497: END IF;
498:
499: p_return_status := FND_API.G_RET_STS_SUCCESS;
500:
501: --
502: -- taxable amounts would be same as the original tax line
503: -- do not need to change unrounded_taxable_amt,

Line 608: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

604: l_tax_precision,
605: p_return_status,
606: p_error_buffer);
607:
608: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
609: RETURN;
610: END IF;
611:
612: --

Line 646: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

642: END IF;
643:
644: EXCEPTION
645: WHEN OTHERS THEN
646: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
648:
649: IF (g_level_unexpected >= g_current_runtime_level ) THEN
650: FND_LOG.STRING(g_level_unexpected,

Line 682: p_return_status := FND_API.G_RET_STS_SUCCESS;

678: FND_LOG.STRING(g_level_statement,
679: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_status_id.BEGIN',
680: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_tax_status_id(+)');
681: END IF;
682: p_return_status := FND_API.G_RET_STS_SUCCESS;
683:
684: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
685: p_tax,
686: p_tax_regime_code,

Line 693: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

689: l_status_rec,
690: p_return_status,
691: p_error_buffer);
692:
693: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
694: p_tax_status_id := l_status_rec.tax_status_id;
695: END IF;
696:
697: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 706: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 741: p_return_status := FND_API.G_RET_STS_SUCCESS;

737: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_id.BEGIN',
738: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_tax_id(+)');
739: END IF;
740:
741: p_return_status := FND_API.G_RET_STS_SUCCESS;
742:
743: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
744: p_tax_regime_code,
745: p_tax,

Line 751: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

747: l_tax_rec,
748: p_return_status,
749: p_error_buffer);
750:
751: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
752: p_tax_id := l_tax_rec.tax_id;
753: END IF;
754:
755: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 766: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 819: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 846: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 899: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 926: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

922: ZX_TDS_TAX_LINES_POPU_PKG.populate_mandatory_columns(
923: p_offset_tax_line_rec,
924: p_return_status,
925: p_error_buffer);
926: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
927: RETURN;
928: END IF;
929:
930: --

Line 952: IF p_return_status <>FND_API.G_RET_STS_SUCCESS THEN

948: p_offset_tax_line_rec.tax_determine_date,
949: p_offset_tax_line_rec.tax_id,
950: p_return_status,
951: p_error_buffer);
952: IF p_return_status <>FND_API.G_RET_STS_SUCCESS THEN
953: RETURN;
954: END IF;
955:
956: p_offset_tax_line_rec.tax_status_code := p_offset_status_code;

Line 964: IF p_return_status <>FND_API.G_RET_STS_SUCCESS THEN

960: p_offset_tax_line_rec.tax_determine_date,
961: p_offset_tax_line_rec.tax_status_id,
962: p_return_status,
963: p_error_buffer);
964: IF p_return_status <>FND_API.G_RET_STS_SUCCESS THEN
965: RETURN;
966: END IF;
967:
968: p_offset_tax_line_rec.tax_type_code :=

Line 980: IF p_return_status <>FND_API.G_RET_STS_SUCCESS THEN

976: p_initial_tax_rate,
977: p_return_status,
978: p_error_buffer);
979:
980: IF p_return_status <>FND_API.G_RET_STS_SUCCESS THEN
981: RETURN;
982: END IF;
983:
984: -- bug 5580990: populate legal_reporting_status

Line 1018: IF p_return_status <>FND_API.G_RET_STS_SUCCESS THEN

1014: l_old_offset_tax_line_id,
1015: p_return_status,
1016: p_error_buffer);
1017:
1018: IF p_return_status <>FND_API.G_RET_STS_SUCCESS THEN
1019: RETURN;
1020: END IF;
1021:
1022: IF l_old_offset_tax_line_id IS NOT NULL THEN

Line 1040: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1036: END IF;
1037:
1038: EXCEPTION
1039: WHEN OTHERS THEN
1040: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1041: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1042:
1043: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1044: FND_LOG.STRING(g_level_unexpected,