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

Line 141: p_return_status:= FND_API.G_RET_STS_SUCCESS;

137: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.CALC_TAX_DIST.BEGIN',
138: 'ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist(+)');
139: END IF;
140:
141: p_return_status:= FND_API.G_RET_STS_SUCCESS;
142:
143: l_index:= p_rnd_begin_index - 1;
144: l_new_index := NULL;
145: l_total_count := 0;

Line 221: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

217: p_rnd_end_index,
218: p_return_status,
219: p_error_buffer);
220:
221: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
222: IF (g_level_statement >= g_current_runtime_level ) THEN
223: FND_LOG.STRING(g_level_statement,
224: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
225: 'Incorrect return_status after calling ' ||

Line 243: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

239: p_rnd_end_index,
240: p_return_status,
241: p_error_buffer);
242:
243: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
244: IF (g_level_statement >= g_current_runtime_level ) THEN
245: FND_LOG.STRING(g_level_statement,
246: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
247: 'Incorrect return_status after calling ' ||

Line 267: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

263: p_rnd_end_index,
264: p_return_status,
265: p_error_buffer);
266:
267: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
268: IF (g_level_statement >= g_current_runtime_level ) THEN
269: FND_LOG.STRING(g_level_statement,
270: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
271: 'Incorrect return_status after calling ' ||

Line 288: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

284: p_rnd_end_index,
285: p_return_status,
286: p_error_buffer);
287:
288: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
289: IF (g_level_statement >= g_current_runtime_level ) THEN
290: FND_LOG.STRING(g_level_statement,
291: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
292: 'Incorrect return_status after calling ' ||

Line 308: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

304: p_rnd_end_index,
305: p_return_status,
306: p_error_buffer);
307:
308: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
309: IF (g_level_statement >= g_current_runtime_level ) THEN
310: FND_LOG.STRING(g_level_statement,
311: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
312: 'Incorrect return_status after calling ' ||

Line 331: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

327: p_rnd_begin_index,
328: p_rnd_end_index,
329: p_return_status,
330: p_error_buffer);
331: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
332: IF (g_level_statement >= g_current_runtime_level ) THEN
333: FND_LOG.STRING(g_level_statement,
334: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
335: 'Incorrect return_status after calling ' ||

Line 480: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

476: p_tax_id => p_detail_tax_line_tbl(p_tax_line_index).tax_id,
477: p_return_status => p_return_status,
478: p_error_buffer => p_error_buffer);
479:
480: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
481: IF (g_level_statement >= g_current_runtime_level ) THEN
482: FND_LOG.STRING(g_level_statement,
483: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
484: 'Incorrect return_status after calling ' ||

Line 553: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

549: p_rnd_end_index,
550: p_return_status,
551: p_error_buffer);
552:
553: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
554: IF (g_level_statement >= g_current_runtime_level ) THEN
555: FND_LOG.STRING(g_level_statement,
556: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
557: 'Incorrect return_status after calling ' ||

Line 573: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

569: p_rnd_end_index,
570: p_return_status,
571: p_error_buffer);
572:
573: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
574: IF (g_level_statement >= g_current_runtime_level ) THEN
575: FND_LOG.STRING(g_level_statement,
576: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
577: 'Incorrect return_status after calling ' ||

Line 595: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

591: p_rnd_begin_index,
592: p_rnd_end_index,
593: p_return_status,
594: p_error_buffer);
595: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
596: IF (g_level_statement >= g_current_runtime_level ) THEN
597: FND_LOG.STRING(g_level_statement,
598: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
599: 'Incorrect return_status after calling ' ||

Line 616: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

612: END IF;
613:
614: EXCEPTION
615: WHEN OTHERS THEN
616: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
618:
619: IF (g_level_unexpected >= g_current_runtime_level ) THEN
620: FND_LOG.STRING(g_level_unexpected,

Line 675: p_return_status:= FND_API.G_RET_STS_SUCCESS;

671: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.cancel_tax_line.BEGIN',
672: 'ZX_TRD_INTERNAL_SERVICES_PVT.cancel_tax_line (+)');
673: END IF;
674:
675: p_return_status:= FND_API.G_RET_STS_SUCCESS;
676: i:= p_rnd_begin_index;
677: l_old_trx_line_dist_id := NULL;
678:
679: OPEN get_tax_distributions_cur;

Line 770: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 839: p_return_status := FND_API.G_RET_STS_SUCCESS;

835: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE.BEGIN',
836: 'ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE(+)');
837: END IF;
838:
839: p_return_status := FND_API.G_RET_STS_SUCCESS;
840:
841: OPEN get_maximum_tax_dist_num_csr;
842: FETCH get_maximum_tax_dist_num_csr INTO l_max_tax_dist_number;
843: CLOSE get_maximum_tax_dist_num_csr;

Line 877: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

873: p_rnd_end_index,
874: p_return_status,
875: p_error_buffer);
876:
877: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
878: THEN
879: IF (g_level_error >= g_current_runtime_level ) THEN
880: FND_LOG.STRING(g_level_error,
881: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.det_appl_rec_type',

Line 907: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

903: p_rnd_end_index,
904: p_return_status,
905: p_error_buffer);
906:
907: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
908: THEN
909: IF (g_level_error >= g_current_runtime_level ) THEN
910: FND_LOG.STRING(g_level_error,
911: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.det_appl_rec_type',

Line 952: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

948: g_tax_recovery_info_tbl(l_tax_id).def_rec_settlement_option_code,
949: g_tax_recovery_info_tbl(l_tax_id).tax_account_source_tax;
950:
951: IF get_tax_recovery_info_cur%NOTFOUND THEN
952: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
953:
954: IF (g_level_procedure >= g_current_runtime_level ) THEN
955: FND_LOG.STRING(g_level_procedure,
956: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE.END',

Line 1035: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1031: END IF;
1032:
1033: EXCEPTION
1034: WHEN OTHERS THEN
1035: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1036: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1037:
1038: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1039: FND_LOG.STRING(g_level_unexpected,

Line 1069: p_return_status:= FND_API.G_RET_STS_SUCCESS;

1065: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_STA.BEGIN',
1066: 'ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_STA(+)');
1067: END IF;
1068:
1069: p_return_status:= FND_API.G_RET_STS_SUCCESS;
1070:
1071: FOR i IN p_rnd_begin_index..p_rnd_end_index LOOP
1072:
1073: p_rec_nrec_dist_tbl(i).application_id :=

Line 1260: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1256: END IF;
1257:
1258: EXCEPTION
1259: WHEN OTHERS THEN
1260: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1261: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1262:
1263: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1264: FND_LOG.STRING(g_level_unexpected,

Line 1296: p_return_status:= FND_API.G_RET_STS_SUCCESS;

1292: FND_LOG.STRING(g_level_procedure,
1293: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR.BEGIN',
1294: 'ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR(+)');
1295: END IF;
1296: p_return_status:= FND_API.G_RET_STS_SUCCESS;
1297:
1298: FOR i in p_rnd_begin_index..p_rnd_end_index
1299: LOOP
1300:

Line 1332: p_return_status := FND_API.G_RET_STS_ERROR;

1328: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.INTERNAL_ORGANIZATION_ID(p_trx_line_dist_index));
1329:
1330: IF p_rec_nrec_dist_tbl(i).GL_DATE IS NULL THEN
1331:
1332: p_return_status := FND_API.G_RET_STS_ERROR;
1333: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
1334: FND_MESSAGE.SET_TOKEN('DATE', to_char(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index), 'dd-mon-yyyy'));
1335:
1336: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id := p_detail_tax_line_tbl(p_tax_line_index).trx_line_id;

Line 1461: p_return_status := FND_API.G_RET_STS_ERROR;

1457: END IF;
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: IF nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_reporting_flag(p_trx_line_dist_index),'N') = 'Y' THEN
1461: p_return_status := FND_API.G_RET_STS_ERROR;
1462: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
1463: FND_MESSAGE.SET_TOKEN('DATE', to_char(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index), 'dd-mon-yyyy'));
1464:
1465: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id := p_detail_tax_line_tbl(p_tax_line_index).trx_line_id;

Line 1492: p_return_status := FND_API.G_RET_STS_ERROR;

1488:
1489: IF nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_reporting_flag(p_trx_line_dist_index),'N') = 'Y' THEN
1490: IF p_rec_nrec_dist_tbl(i).GL_DATE IS NULL THEN
1491:
1492: p_return_status := FND_API.G_RET_STS_ERROR;
1493: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
1494: FND_MESSAGE.SET_TOKEN('DATE', to_char(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index), 'dd-mon-yyyy'));
1495:
1496: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id := p_detail_tax_line_tbl(p_tax_line_index).trx_line_id;

Line 1530: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1526: END IF;
1527:
1528: EXCEPTION
1529: WHEN OTHERS THEN
1530: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1531: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1532:
1533: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1534: FND_LOG.STRING(g_level_unexpected,

Line 1739: p_return_status:= FND_API.G_RET_STS_SUCCESS;

1735: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate.BEGIN',
1736: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate(+)');
1737: END IF;
1738:
1739: p_return_status:= FND_API.G_RET_STS_SUCCESS;
1740:
1741: l_tax_id:= p_detail_tax_line_tbl(p_tax_line_index).tax_id;
1742: l_tax := p_detail_tax_line_tbl(p_tax_line_index).tax;
1743: l_tax_regime_code := p_detail_tax_line_tbl(p_tax_line_index).tax_regime_code;

Line 1786: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1782: g_tax_recovery_info_tbl(l_tax_id).def_rec_settlement_option_code,
1783: g_tax_recovery_info_tbl(l_tax_id).tax_account_source_tax;
1784:
1785: IF get_tax_rec_info_from_tax_csr%NOTFOUND THEN
1786: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1787: IF (g_level_statement >= g_current_runtime_level ) THEN
1788: FND_LOG.STRING(g_level_statement,
1789: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
1790: 'error: ' || 'no tax info can be found for '||l_tax_id);

Line 2212: p_return_status := FND_API.G_RET_STS_ERROR;

2208: l_tax_id).def_secondary_rec_rate_code;
2209: END IF;
2210:
2211: IF l_rec_rate_code IS NULL THEN
2212: p_return_status := FND_API.G_RET_STS_ERROR;
2213:
2214: FND_MESSAGE.SET_NAME('ZX','ZX_REC_RATE_CODE_NOT_FOUND');
2215: FND_MESSAGE.SET_TOKEN('REGIME_NAME', l_tax_regime_code);
2216: FND_MESSAGE.SET_TOKEN('CONTENT_OWNER_NAME',

Line 2364: p_return_status := FND_API.G_RET_STS_ERROR;

2360: l_total_rec_rate:= l_total_rec_rate + l_rec_rate;
2361:
2362: ELSE -- l_rec_rate NULL
2363:
2364: p_return_status := FND_API.G_RET_STS_ERROR;
2365:
2366: FND_MESSAGE.SET_NAME('ZX','ZX_REC_RATE_NOT_FOUND');
2367: FND_MESSAGE.SET_TOKEN('REGIME_NAME', l_tax_regime_code);
2368: FND_MESSAGE.SET_TOKEN('CONTENT_OWNER_NAME',

Line 2595: p_return_status := FND_API.G_RET_STS_ERROR;

2591:
2592:
2593: p_rec_nrec_dist_tbl(l_non_rec_index).rec_nrec_rate:= 100 - l_total_rec_rate;
2594: IF p_rec_nrec_dist_tbl(l_non_rec_index).rec_nrec_rate < 0 THEN
2595: p_return_status := FND_API.G_RET_STS_ERROR;
2596:
2597: FND_MESSAGE.SET_NAME('ZX','ZX_SUM_REC_RATE_OVER');
2598:
2599: FND_MESSAGE.SET_TOKEN('RECOVERY_TYPE_1',

Line 2645: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2641: END IF;
2642:
2643: EXCEPTION
2644: WHEN OTHERS THEN
2645: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2646: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2647:
2648: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2649: FND_LOG.STRING(g_level_unexpected,

Line 2675: p_return_status:= FND_API.G_RET_STS_SUCCESS;

2671: FND_LOG.STRING(g_level_procedure,
2672: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_REC_NREC_DIST_AMT.BEGIN',
2673: 'ZX_TRD_INTERNAL_SERVICES_PVT.GET_REC_NREC_DIST_AMT(+)');
2674: END IF;
2675: p_return_status:= FND_API.G_RET_STS_SUCCESS;
2676:
2677: For i in p_rnd_begin_index..p_rnd_end_index
2678: LOOP
2679: IF NVL(p_rec_nrec_dist_tbl(i).reverse_flag,'N') = 'N' THEN

Line 2704: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2700: END IF;
2701:
2702: EXCEPTION
2703: WHEN OTHERS THEN
2704: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2705: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2706:
2707: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2708: FND_LOG.STRING(g_level_unexpected,

Line 2749: p_return_status:= FND_API.G_RET_STS_SUCCESS;

2745: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT.BEGIN',
2746: 'ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT(+)');
2747: END IF;
2748:
2749: p_return_status:= FND_API.G_RET_STS_SUCCESS;
2750:
2751: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
2752: p_rnd_begin_index > p_rnd_end_index THEN
2753:

Line 2754: --p_return_status:= FND_API.G_RET_STS_ERROR;

2750:
2751: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
2752: p_rnd_begin_index > p_rnd_end_index THEN
2753:
2754: --p_return_status:= FND_API.G_RET_STS_ERROR;
2755: IF (g_level_statement >= g_current_runtime_level ) THEN
2756: FND_LOG.STRING(g_level_statement,
2757: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT',
2758: 'begin or end index is null, or begin index > end index');

Line 2791: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2787: p_tax_line_amt_funcl_curr,
2788: p_return_status,
2789: p_error_buffer);
2790:
2791: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2792: IF (g_level_error >= g_current_runtime_level ) THEN
2793: FND_LOG.STRING(g_level_error,
2794: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_rec_nrec_amt',
2795: 'Incorrect return_status after calling ' ||

Line 2819: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS THEN

2815: p_rnd_end_index => p_rnd_end_index,
2816: p_return_status => p_return_status,
2817: p_error_buffer => p_error_buffer);
2818:
2819: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS THEN
2820: IF (g_level_statement >= g_current_runtime_level ) THEN
2821: FND_LOG.STRING(g_level_statement,
2822: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT',
2823: 'Incorrect return_status after calling ' ||

Line 2862: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2858: END IF;
2859:
2860: EXCEPTION
2861: WHEN OTHERS THEN
2862: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2863: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2864:
2865: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2866: FND_LOG.STRING(g_level_unexpected,

Line 2919: p_return_status:= FND_API.G_RET_STS_SUCCESS;

2915: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr.BEGIN',
2916: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr(+)');
2917: END IF;
2918:
2919: p_return_status:= FND_API.G_RET_STS_SUCCESS;
2920:
2921: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
2922: p_rnd_begin_index > p_rnd_end_index THEN
2923:

Line 2924: --p_return_status:= FND_API.G_RET_STS_ERROR;

2920:
2921: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
2922: p_rnd_begin_index > p_rnd_end_index THEN
2923:
2924: --p_return_status:= FND_API.G_RET_STS_ERROR;
2925: IF (g_level_statement >= g_current_runtime_level ) THEN
2926: FND_LOG.STRING(g_level_statement,
2927: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
2928: 'begin or end index is null, or begin index > end index');

Line 2967: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

2963: p_return_status => p_return_status,
2964: p_error_buffer => p_error_buffer);
2965: END IF;
2966:
2967: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
2968: THEN
2969: IF (g_level_error >= g_current_runtime_level ) THEN
2970: FND_LOG.STRING(g_level_error,
2971: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

Line 3071: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

3067: p_rec_nrec_dist_tbl(p_rnd_begin_index).precision,
3068: p_return_status,
3069: p_error_buffer);
3070:
3071: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3072: THEN
3073: IF (g_level_error >= g_current_runtime_level ) THEN
3074: FND_LOG.STRING(g_level_error,
3075: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

Line 3123: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

3119: p_index_amt_tbl => l_non_zero_rec_tax_dists_tbl,
3120: p_return_status => p_return_status,
3121: p_error_buffer => p_error_buffer);
3122:
3123: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3124: THEN
3125: IF (g_level_error >= g_current_runtime_level ) THEN
3126: FND_LOG.STRING(g_level_error,
3127: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

Line 3150: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

3146: p_min_acct_unit => l_min_acct_unit,
3147: p_return_status => p_return_status,
3148: p_error_buffer => p_error_buffer);
3149:
3150: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3151: THEN
3152: IF (g_level_error >= g_current_runtime_level ) THEN
3153: FND_LOG.STRING(g_level_error,
3154: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

Line 3182: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

3178: p_index_amt_tbl => l_non_zero_nrec_tax_dists_tbl,
3179: p_return_status => p_return_status,
3180: p_error_buffer => p_error_buffer);
3181:
3182: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3183: THEN
3184: IF (g_level_error >= g_current_runtime_level ) THEN
3185: FND_LOG.STRING(g_level_error,
3186: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

Line 3209: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

3205: l_min_acct_unit,
3206: p_return_status,
3207: p_error_buffer);
3208:
3209: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3210: THEN
3211: IF (g_level_error >= g_current_runtime_level ) THEN
3212: FND_LOG.STRING(g_level_error,
3213: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

Line 3275: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

3271: p_index_amt_tbl => l_non_zero_nrec_tax_dists_tbl,
3272: p_return_status => p_return_status,
3273: p_error_buffer => p_error_buffer);
3274:
3275: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3276: THEN
3277: IF (g_level_error >= g_current_runtime_level ) THEN
3278: FND_LOG.STRING(g_level_error,
3279: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

Line 3304: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS

3300: l_min_acct_unit,
3301: p_return_status,
3302: p_error_buffer);
3303:
3304: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS
3305: THEN
3306: IF (g_level_error >= g_current_runtime_level ) THEN
3307: FND_LOG.STRING(g_level_error,
3308: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

Line 3337: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

3333: p_index_amt_tbl => l_non_zero_rec_tax_dists_tbl,
3334: p_return_status => p_return_status,
3335: p_error_buffer => p_error_buffer);
3336:
3337: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3338: THEN
3339: IF (g_level_error >= g_current_runtime_level ) THEN
3340: FND_LOG.STRING(g_level_error,
3341: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

Line 3366: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

3362: l_min_acct_unit,
3363: p_return_status,
3364: p_error_buffer);
3365:
3366: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3367: THEN
3368: IF (g_level_error >= g_current_runtime_level ) THEN
3369: FND_LOG.STRING(g_level_error,
3370: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

Line 3547: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3543:
3544: EXCEPTION
3545:
3546: WHEN OTHERS THEN
3547: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3548: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3549:
3550: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3551: FND_LOG.STRING(g_level_unexpected,

Line 3621: p_return_status:= FND_API.G_RET_STS_SUCCESS;

3617: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.BEGIN',
3618: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(+)');
3619: END IF;
3620:
3621: p_return_status:= FND_API.G_RET_STS_SUCCESS;
3622:
3623: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
3624: p_rnd_begin_index > p_rnd_end_index THEN
3625:

Line 3626: --p_return_status:= FND_API.G_RET_STS_ERROR;

3622:
3623: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
3624: p_rnd_begin_index > p_rnd_end_index THEN
3625:
3626: --p_return_status:= FND_API.G_RET_STS_ERROR;
3627: IF (g_level_statement >= g_current_runtime_level ) THEN
3628: FND_LOG.STRING(g_level_statement,
3629: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3630: 'begin or end index is null, or begin index > end index');

Line 3654: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

3650: END LOOP;
3651: ELSE
3652:
3653: IF p_rec_nrec_dist_tbl(p_rnd_begin_index).tax_currency_code IS NULL THEN
3654: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3655: IF (g_level_error >= g_current_runtime_level ) THEN
3656: FND_LOG.STRING(g_level_error,
3657: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3658: 'Tax currency code is NULL');

Line 3711: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

3707: p_return_status,
3708: p_error_buffer,
3709: p_rec_nrec_dist_tbl(i).currency_conversion_date); --Bug7183884
3710:
3711: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3712: THEN
3713: IF (g_level_error >= g_current_runtime_level ) THEN
3714: FND_LOG.STRING(g_level_error,
3715: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 3736: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

3732: l_precision_tax_curr,
3733: p_return_status,
3734: p_error_buffer);
3735:
3736: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3737: THEN
3738: IF (g_level_error >= g_current_runtime_level ) THEN
3739: FND_LOG.STRING(g_level_error,
3740: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 3843: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

3839: p_return_status,
3840: p_error_buffer,
3841: p_rec_nrec_dist_tbl(p_rnd_begin_index).currency_conversion_date); --Bug7183884
3842:
3843: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3844: THEN
3845: IF (g_level_error >= g_current_runtime_level ) THEN
3846: FND_LOG.STRING(g_level_error,
3847: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 3877: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

3873: l_precision_tax_curr,
3874: p_return_status,
3875: p_error_buffer);
3876:
3877: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3878: THEN
3879: IF (g_level_error >= g_current_runtime_level ) THEN
3880: FND_LOG.STRING(g_level_error,
3881: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 3915: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

3911: p_index_amt_tbl => l_non_zero_rec_tax_dists_tbl,
3912: p_return_status => p_return_status,
3913: p_error_buffer => p_error_buffer);
3914:
3915: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3916: THEN
3917: IF (g_level_error >= g_current_runtime_level ) THEN
3918: FND_LOG.STRING(g_level_error,
3919: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 3942: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

3938: p_min_acct_unit => l_min_acct_unit_tax_curr,
3939: p_return_status => p_return_status,
3940: p_error_buffer => p_error_buffer);
3941:
3942: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3943: THEN
3944: IF (g_level_error >= g_current_runtime_level ) THEN
3945: FND_LOG.STRING(g_level_error,
3946: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 3974: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

3970: p_index_amt_tbl => l_non_zero_nrec_tax_dists_tbl,
3971: p_return_status => p_return_status,
3972: p_error_buffer => p_error_buffer);
3973:
3974: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3975: THEN
3976: IF (g_level_error >= g_current_runtime_level ) THEN
3977: FND_LOG.STRING(g_level_error,
3978: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 4001: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

3997: p_min_acct_unit => l_min_acct_unit_tax_curr,
3998: p_return_status => p_return_status,
3999: p_error_buffer => p_error_buffer);
4000:
4001: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4002: THEN
4003: IF (g_level_error >= g_current_runtime_level ) THEN
4004: FND_LOG.STRING(g_level_error,
4005: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 4043: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

4039: p_index_amt_tbl => l_non_zero_nrec_tax_dists_tbl,
4040: p_return_status => p_return_status,
4041: p_error_buffer => p_error_buffer);
4042:
4043: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4044: THEN
4045: IF (g_level_error >= g_current_runtime_level ) THEN
4046: FND_LOG.STRING(g_level_error,
4047: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 4072: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

4068: p_min_acct_unit => l_min_acct_unit_tax_curr,
4069: p_return_status => p_return_status,
4070: p_error_buffer => p_error_buffer);
4071:
4072: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4073: THEN
4074: IF (g_level_error >= g_current_runtime_level ) THEN
4075: FND_LOG.STRING(g_level_error,
4076: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 4105: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

4101: p_index_amt_tbl => l_non_zero_rec_tax_dists_tbl,
4102: p_return_status => p_return_status,
4103: p_error_buffer => p_error_buffer);
4104:
4105: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4106: THEN
4107: IF (g_level_error >= g_current_runtime_level ) THEN
4108: FND_LOG.STRING(g_level_error,
4109: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 4134: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

4130: p_min_acct_unit => l_min_acct_unit_tax_curr,
4131: p_return_status => p_return_status,
4132: p_error_buffer => p_error_buffer);
4133:
4134: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4135: THEN
4136: IF (g_level_error >= g_current_runtime_level ) THEN
4137: FND_LOG.STRING(g_level_error,
4138: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 4242: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS

4238: p_return_status,
4239: p_error_buffer,
4240: p_rec_nrec_dist_tbl(i).currency_conversion_date);--Bug7183884
4241:
4242: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS
4243: THEN
4244: IF (g_level_error >= g_current_runtime_level ) THEN
4245: FND_LOG.STRING(g_level_error,
4246: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 4267: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS

4263: l_precision_tax_curr,
4264: p_return_status,
4265: p_error_buffer);
4266:
4267: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS
4268: THEN
4269: IF (g_level_error >= g_current_runtime_level ) THEN
4270: FND_LOG.STRING(g_level_error,
4271: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 4310: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS

4306: p_ledger_id => l_ledger_id,
4307: p_return_status => p_return_status,
4308: p_error_buffer => p_error_buffer);
4309:
4310: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS
4311: THEN
4312: IF (g_level_error >= g_current_runtime_level ) THEN
4313: FND_LOG.STRING(g_level_error,
4314: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 4552: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

4548: p_index_amt_tbl => l_non_zero_rec_tax_dists_tbl,
4549: p_return_status => p_return_status,
4550: p_error_buffer => p_error_buffer);
4551:
4552: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4553: THEN
4554: IF (g_level_error >= g_current_runtime_level ) THEN
4555: FND_LOG.STRING(g_level_error,
4556: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 4599: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

4595: p_index_amt_tbl => l_non_zero_nrec_tax_dists_tbl,
4596: p_return_status => p_return_status,
4597: p_error_buffer => p_error_buffer);
4598:
4599: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4600: THEN
4601: IF (g_level_error >= g_current_runtime_level ) THEN
4602: FND_LOG.STRING(g_level_error,
4603: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 4626: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

4622: p_min_acct_unit => l_min_acct_unit_funcl_curr,
4623: p_return_status => p_return_status,
4624: p_error_buffer => p_error_buffer);
4625:
4626: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4627: THEN
4628: IF (g_level_error >= g_current_runtime_level ) THEN
4629: FND_LOG.STRING(g_level_error,
4630: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 4670: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

4666: p_index_amt_tbl => l_non_zero_nrec_tax_dists_tbl,
4667: p_return_status => p_return_status,
4668: p_error_buffer => p_error_buffer);
4669:
4670: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4671: THEN
4672: IF (g_level_error >= g_current_runtime_level ) THEN
4673: FND_LOG.STRING(g_level_error,
4674: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 4700: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

4696: p_min_acct_unit => l_min_acct_unit_funcl_curr,
4697: p_return_status => p_return_status,
4698: p_error_buffer => p_error_buffer);
4699:
4700: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4701: THEN
4702: IF (g_level_error >= g_current_runtime_level ) THEN
4703: FND_LOG.STRING(g_level_error,
4704: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 4737: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

4733: p_index_amt_tbl => l_non_zero_rec_tax_dists_tbl,
4734: p_return_status => p_return_status,
4735: p_error_buffer => p_error_buffer);
4736:
4737: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4738: THEN
4739: IF (g_level_error >= g_current_runtime_level ) THEN
4740: FND_LOG.STRING(g_level_error,
4741: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 4767: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

4763: p_min_acct_unit => l_min_acct_unit_funcl_curr,
4764: p_return_status => p_return_status,
4765: p_error_buffer => p_error_buffer);
4766:
4767: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4768: THEN
4769: IF (g_level_error >= g_current_runtime_level ) THEN
4770: FND_LOG.STRING(g_level_error,
4771: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 4945: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4941:
4942: EXCEPTION
4943:
4944: WHEN OTHERS THEN
4945: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4946: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4947:
4948: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4949: FND_LOG.STRING(g_level_unexpected,

Line 4982: p_return_status:= FND_API.G_RET_STS_SUCCESS;

4978: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff(+)'||
4979: 'p_rounding_diff = ' || p_rounding_diff);
4980: END IF;
4981:
4982: p_return_status:= FND_API.G_RET_STS_SUCCESS;
4983:
4984: -- Adjust rounding difference
4985: --
4986: IF p_rounding_diff = 0 THEN

Line 5046: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5042:
5043: EXCEPTION
5044:
5045: WHEN OTHERS THEN
5046: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5047: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5048:
5049: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5050: FND_LOG.STRING(g_level_unexpected,

Line 5082: p_return_status:= FND_API.G_RET_STS_SUCCESS;

5078: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc.BEGIN',
5079: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc(+)');
5080: END IF;
5081:
5082: p_return_status:= FND_API.G_RET_STS_SUCCESS;
5083:
5084: -- initialize local variables
5085: --
5086: l_length := p_index_amt_tbl.COUNT;

Line 5135: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5131:
5132: EXCEPTION
5133:
5134: WHEN OTHERS THEN
5135: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5136: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5137:
5138: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5139: FND_LOG.STRING(g_level_unexpected,

Line 5216: p_return_status := FND_API.G_RET_STS_SUCCESS;

5212: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied.BEGIN',
5213: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied(+)');
5214: END IF;
5215:
5216: p_return_status := FND_API.G_RET_STS_SUCCESS;
5217:
5218: p_rnd_end_index := p_rnd_begin_index -1;
5219: l_rec_nrec_tax_dist_number:= 0;
5220:

Line 5366: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5362: END IF;
5363:
5364: EXCEPTION
5365: WHEN OTHERS THEN
5366: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5367: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5368:
5369: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5370: FND_LOG.STRING(g_level_unexpected,

Line 5442: p_return_status := FND_API.G_RET_STS_SUCCESS;

5438: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted.BEGIN',
5439: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted(+)');
5440: END IF;
5441:
5442: p_return_status := FND_API.G_RET_STS_SUCCESS;
5443:
5444: p_rnd_end_index := p_rnd_begin_index - 1;
5445:
5446: l_rec_nrec_tax_dist_number := 0;

Line 5552: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5548: END IF;
5549:
5550: EXCEPTION
5551: WHEN OTHERS THEN
5552: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5553: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5554:
5555: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5556: FND_LOG.STRING(g_level_unexpected,

Line 5657: p_return_status := FND_API.G_RET_STS_SUCCESS;

5653: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref.BEGIN',
5654: 'ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref(+)');
5655: END IF;
5656:
5657: p_return_status := FND_API.G_RET_STS_SUCCESS;
5658:
5659: p_rnd_end_index := p_rnd_begin_index -1;
5660:
5661: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 5707: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5703: g_tax_recovery_info_tbl(l_tax_id).def_rec_settlement_option_code,
5704: g_tax_recovery_info_tbl(l_tax_id).tax_account_source_tax;
5705:
5706: IF get_tax_recovery_info_cur%NOTFOUND THEN
5707: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5708: IF (g_level_procedure >= g_current_runtime_level ) THEN
5709: FND_LOG.STRING(g_level_procedure,
5710: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref.END',
5711: 'ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref(-)'||'error: can not find tax info for ' || l_tax_id);

Line 5900: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS

5896: p_rnd_end_index,
5897: p_return_status,
5898: p_error_buffer);
5899:
5900: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS
5901: THEN
5902: IF (g_level_error >= g_current_runtime_level ) THEN
5903: FND_LOG.STRING(g_level_error,
5904: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',

Line 5929: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5925: END IF;
5926:
5927: EXCEPTION
5928: WHEN OTHERS THEN
5929: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5930: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5931:
5932: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5933: FND_LOG.STRING(g_level_unexpected,

Line 5988: p_return_status:= FND_API.G_RET_STS_SUCCESS;

5984: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts.BEGIN',
5985: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts(+)');
5986: END IF;
5987:
5988: p_return_status:= FND_API.G_RET_STS_SUCCESS;
5989:
5990: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
5991: p_rnd_begin_index > p_rnd_end_index THEN
5992:

Line 5993: --p_return_status:= FND_API.G_RET_STS_ERROR;

5989:
5990: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
5991: p_rnd_begin_index > p_rnd_end_index THEN
5992:
5993: --p_return_status:= FND_API.G_RET_STS_ERROR;
5994: IF (g_level_error >= g_current_runtime_level ) THEN
5995: FND_LOG.STRING(g_level_error,
5996: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts ',
5997: 'begin or end index is null, or begin index > end index');

Line 6013: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS

6009: p_ledger_id => l_ledger_id,
6010: p_return_status => p_return_status,
6011: p_error_buffer => p_error_buffer);
6012:
6013: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS
6014: THEN
6015: IF (g_level_error >= g_current_runtime_level ) THEN
6016: FND_LOG.STRING(g_level_error,
6017: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts',

Line 6071: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

6067: l_precision_tax_curr,
6068: p_return_status,
6069: p_error_buffer);
6070:
6071: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
6072: THEN
6073: IF (g_level_error >= g_current_runtime_level ) THEN
6074: FND_LOG.STRING(g_level_error,
6075: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts ',

Line 6263: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6259:
6260: EXCEPTION
6261:
6262: WHEN OTHERS THEN
6263: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6264: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6265:
6266: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6267: FND_LOG.STRING(g_level_unexpected,

Line 6296: p_return_status:= FND_API.G_RET_STS_SUCCESS;

6292: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns.BEGIN',
6293: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns(+)');
6294: END IF;
6295:
6296: p_return_status:= FND_API.G_RET_STS_SUCCESS;
6297:
6298: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
6299: p_rnd_begin_index > p_rnd_end_index THEN
6300:

Line 6301: --p_return_status:= FND_API.G_RET_STS_ERROR;

6297:
6298: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
6299: p_rnd_begin_index > p_rnd_end_index THEN
6300:
6301: --p_return_status:= FND_API.G_RET_STS_ERROR;
6302: IF (g_level_statement >= g_current_runtime_level ) THEN
6303: FND_LOG.STRING(g_level_statement,
6304: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns',
6305: 'begin or end index is null, or begin index > end index');

Line 6384: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6380: END IF;
6381:
6382: EXCEPTION
6383: WHEN OTHERS THEN
6384: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6385: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6386:
6387: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6388: FND_LOG.STRING(g_level_unexpected,

Line 6412: p_return_status:= FND_API.G_RET_STS_SUCCESS;

6408: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors.BEGIN',
6409: 'ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors(+)');
6410: END IF;
6411:
6412: p_return_status:= FND_API.G_RET_STS_SUCCESS;
6413:
6414:
6415: -- Bugfix 5035461: added recoverable_flag and reverse_flag condition in
6416: -- the subquery.

Line 6671: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6667: END IF;
6668:
6669: EXCEPTION
6670: WHEN OTHERS THEN
6671: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6672: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6673:
6674: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6675: FND_LOG.STRING(g_level_unexpected,

Line 6734: p_return_status := FND_API.G_RET_STS_SUCCESS;

6730: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.create_mrc_tax_dists.BEGIN',
6731: 'ZX_TRD_INTERNAL_SERVICES_PVT.create_mrc_tax_dists(+)');
6732: END IF;
6733:
6734: p_return_status := FND_API.G_RET_STS_SUCCESS;
6735:
6736: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
6737: p_rnd_begin_index > p_rnd_end_index THEN
6738:

Line 6739: --p_return_status := FND_API.G_RET_STS_ERROR;

6735:
6736: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
6737: p_rnd_begin_index > p_rnd_end_index THEN
6738:
6739: --p_return_status := FND_API.G_RET_STS_ERROR;
6740: IF (g_level_statement >= g_current_runtime_level ) THEN
6741: FND_LOG.STRING(g_level_statement,
6742: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.create_mrc_tax_dists',
6743: 'begin or end index is null, or begin index > end index');

Line 6841: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6837: NULL,
6838: p_return_status,
6839: p_error_buffer);
6840:
6841: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6842: IF (g_level_statement >= g_current_runtime_level ) THEN
6843: FND_LOG.STRING(g_level_statement,
6844: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.create_mrc_tax_dists',
6845: 'After calling ROUND_REC_NREC_AMT p_return_status = '

Line 6863: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6859: END IF;
6860:
6861: EXCEPTION
6862: WHEN OTHERS THEN
6863: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6864:
6865: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6866: FND_LOG.STRING(g_level_unexpected,
6867: 'ZX.PLSQL.ZX_TDS_MRC_PROCESSING_PKG.create_mrc_det_tax_lines',