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 139: p_return_status:= FND_API.G_RET_STS_SUCCESS;

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

Line 211: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

207: p_rnd_end_index,
208: p_return_status,
209: p_error_buffer);
210:
211: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
212: IF (g_level_statement >= g_current_runtime_level ) THEN
213: FND_LOG.STRING(g_level_statement,
214: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
215: 'Incorrect return_status after calling ' ||

Line 233: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

229: p_rnd_end_index,
230: p_return_status,
231: p_error_buffer);
232:
233: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
234: IF (g_level_statement >= g_current_runtime_level ) THEN
235: FND_LOG.STRING(g_level_statement,
236: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
237: 'Incorrect return_status after calling ' ||

Line 257: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

253: p_rnd_end_index,
254: p_return_status,
255: p_error_buffer);
256:
257: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
258: IF (g_level_statement >= g_current_runtime_level ) THEN
259: FND_LOG.STRING(g_level_statement,
260: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
261: 'Incorrect return_status after calling ' ||

Line 278: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

274: p_rnd_end_index,
275: p_return_status,
276: p_error_buffer);
277:
278: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
279: IF (g_level_statement >= g_current_runtime_level ) THEN
280: FND_LOG.STRING(g_level_statement,
281: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
282: 'Incorrect return_status after calling ' ||

Line 298: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

294: p_rnd_end_index,
295: p_return_status,
296: p_error_buffer);
297:
298: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
299: IF (g_level_statement >= g_current_runtime_level ) THEN
300: FND_LOG.STRING(g_level_statement,
301: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
302: 'Incorrect return_status after calling ' ||

Line 321: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

317: p_rnd_begin_index,
318: p_rnd_end_index,
319: p_return_status,
320: p_error_buffer);
321: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
322: IF (g_level_statement >= g_current_runtime_level ) THEN
323: FND_LOG.STRING(g_level_statement,
324: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
325: 'Incorrect return_status after calling ' ||

Line 499: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

495: p_rnd_end_index,
496: p_return_status,
497: p_error_buffer);
498:
499: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
500: IF (g_level_statement >= g_current_runtime_level ) THEN
501: FND_LOG.STRING(g_level_statement,
502: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
503: 'Incorrect return_status after calling ' ||

Line 519: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

515: p_rnd_end_index,
516: p_return_status,
517: p_error_buffer);
518:
519: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
520: IF (g_level_statement >= g_current_runtime_level ) THEN
521: FND_LOG.STRING(g_level_statement,
522: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
523: 'Incorrect return_status after calling ' ||

Line 541: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

537: p_rnd_begin_index,
538: p_rnd_end_index,
539: p_return_status,
540: p_error_buffer);
541: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
542: IF (g_level_statement >= g_current_runtime_level ) THEN
543: FND_LOG.STRING(g_level_statement,
544: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist',
545: 'Incorrect return_status after calling ' ||

Line 562: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

558: END IF;
559:
560: EXCEPTION
561: WHEN OTHERS THEN
562: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
564:
565: IF (g_level_unexpected >= g_current_runtime_level ) THEN
566: FND_LOG.STRING(g_level_unexpected,

Line 621: p_return_status:= FND_API.G_RET_STS_SUCCESS;

617: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.cancel_tax_line.BEGIN',
618: 'ZX_TRD_INTERNAL_SERVICES_PVT.cancel_tax_line (+)');
619: END IF;
620:
621: p_return_status:= FND_API.G_RET_STS_SUCCESS;
622: i:= p_rnd_begin_index;
623: l_old_trx_line_dist_id := NULL;
624:
625: OPEN get_tax_distributions_cur;

Line 715: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

711: END IF;
712:
713: EXCEPTION
714: WHEN OTHERS THEN
715: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
717:
718: IF (g_level_unexpected >= g_current_runtime_level ) THEN
719: FND_LOG.STRING(g_level_unexpected,

Line 783: p_return_status := FND_API.G_RET_STS_SUCCESS;

779: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE.BEGIN',
780: 'ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE(+)');
781: END IF;
782:
783: p_return_status := FND_API.G_RET_STS_SUCCESS;
784:
785: OPEN get_maximum_tax_dist_num_csr;
786: FETCH get_maximum_tax_dist_num_csr INTO l_max_tax_dist_number;
787: CLOSE get_maximum_tax_dist_num_csr;

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

814: p_rnd_end_index,
815: p_return_status,
816: p_error_buffer);
817:
818: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
819: THEN
820: IF (g_level_error >= g_current_runtime_level ) THEN
821: FND_LOG.STRING(g_level_error,
822: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.det_appl_rec_type',

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

843: p_rnd_end_index,
844: p_return_status,
845: p_error_buffer);
846:
847: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
848: THEN
849: IF (g_level_error >= g_current_runtime_level ) THEN
850: FND_LOG.STRING(g_level_error,
851: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.det_appl_rec_type',

Line 889: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

885: g_tax_recovery_info_tbl(l_tax_id).def_rec_settlement_option_code,
886: g_tax_recovery_info_tbl(l_tax_id).tax_account_source_tax;
887:
888: IF get_tax_recovery_info_cur%NOTFOUND THEN
889: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
890:
891: IF (g_level_procedure >= g_current_runtime_level ) THEN
892: FND_LOG.STRING(g_level_procedure,
893: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.DET_APPL_REC_TYPE.END',

Line 972: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

968: END IF;
969:
970: EXCEPTION
971: WHEN OTHERS THEN
972: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
973: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
974:
975: IF (g_level_unexpected >= g_current_runtime_level ) THEN
976: FND_LOG.STRING(g_level_unexpected,

Line 1006: p_return_status:= FND_API.G_RET_STS_SUCCESS;

1002: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_STA.BEGIN',
1003: 'ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_STA(+)');
1004: END IF;
1005:
1006: p_return_status:= FND_API.G_RET_STS_SUCCESS;
1007:
1008: FOR i IN p_rnd_begin_index..p_rnd_end_index LOOP
1009:
1010: p_rec_nrec_dist_tbl(i).application_id :=

Line 1175: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1171: END IF;
1172:
1173: EXCEPTION
1174: WHEN OTHERS THEN
1175: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1176: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1177:
1178: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1179: FND_LOG.STRING(g_level_unexpected,

Line 1211: p_return_status:= FND_API.G_RET_STS_SUCCESS;

1207: FND_LOG.STRING(g_level_procedure,
1208: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR.BEGIN',
1209: 'ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR(+)');
1210: END IF;
1211: p_return_status:= FND_API.G_RET_STS_SUCCESS;
1212:
1213: FOR i in p_rnd_begin_index..p_rnd_end_index
1214: LOOP
1215:

Line 1247: p_return_status := FND_API.G_RET_STS_ERROR;

1243: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.INTERNAL_ORGANIZATION_ID(p_trx_line_dist_index));
1244:
1245: IF p_rec_nrec_dist_tbl(i).GL_DATE IS NULL THEN
1246:
1247: p_return_status := FND_API.G_RET_STS_ERROR;
1248: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
1249: 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'));
1250:
1251: 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 1361: p_return_status := FND_API.G_RET_STS_ERROR;

1357: p_org_id => ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.INTERNAL_ORGANIZATION_ID(p_trx_line_dist_index));
1358: EXCEPTION
1359: WHEN OTHERS THEN
1360: IF nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_reporting_flag(p_trx_line_dist_index),'N') = 'Y' THEN
1361: p_return_status := FND_API.G_RET_STS_ERROR;
1362: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
1363: 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'));
1364:
1365: 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 1394: p_return_status := FND_API.G_RET_STS_ERROR;

1390:
1391: IF nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_reporting_flag(p_trx_line_dist_index),'N') = 'Y' THEN
1392: IF p_rec_nrec_dist_tbl(i).GL_DATE IS NULL THEN
1393:
1394: p_return_status := FND_API.G_RET_STS_ERROR;
1395: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
1396: 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'));
1397:
1398: 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 1432: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1428: END IF;
1429:
1430: EXCEPTION
1431: WHEN OTHERS THEN
1432: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1433: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1434:
1435: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1436: FND_LOG.STRING(g_level_unexpected,

Line 1635: p_return_status:= FND_API.G_RET_STS_SUCCESS;

1631: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate.BEGIN',
1632: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate(+)');
1633: END IF;
1634:
1635: p_return_status:= FND_API.G_RET_STS_SUCCESS;
1636:
1637: l_tax_id:= p_detail_tax_line_tbl(p_tax_line_index).tax_id;
1638: l_tax := p_detail_tax_line_tbl(p_tax_line_index).tax;
1639: l_tax_regime_code := p_detail_tax_line_tbl(p_tax_line_index).tax_regime_code;

Line 1682: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1678: g_tax_recovery_info_tbl(l_tax_id).def_rec_settlement_option_code,
1679: g_tax_recovery_info_tbl(l_tax_id).tax_account_source_tax;
1680:
1681: IF get_tax_rec_info_from_tax_csr%NOTFOUND THEN
1682: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1683: IF (g_level_statement >= g_current_runtime_level ) THEN
1684: FND_LOG.STRING(g_level_statement,
1685: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate',
1686: 'error: ' || 'no tax info can be found for '||l_tax_id);

Line 2001: p_return_status := FND_API.G_RET_STS_ERROR;

1997: l_tax_id).def_secondary_rec_rate_code;
1998: END IF;
1999:
2000: IF l_rec_rate_code IS NULL THEN
2001: p_return_status := FND_API.G_RET_STS_ERROR;
2002:
2003: FND_MESSAGE.SET_NAME('ZX','ZX_REC_RATE_CODE_NOT_FOUND');
2004: FND_MESSAGE.SET_TOKEN('REGIME_NAME', l_tax_regime_code);
2005: FND_MESSAGE.SET_TOKEN('CONTENT_OWNER_NAME',

Line 2105: p_return_status := FND_API.G_RET_STS_ERROR;

2101: l_total_rec_rate:= l_total_rec_rate + l_rec_rate;
2102:
2103: ELSE -- l_rec_rate NULL
2104:
2105: p_return_status := FND_API.G_RET_STS_ERROR;
2106:
2107: FND_MESSAGE.SET_NAME('ZX','ZX_REC_RATE_NOT_FOUND');
2108: FND_MESSAGE.SET_TOKEN('REGIME_NAME', l_tax_regime_code);
2109: FND_MESSAGE.SET_TOKEN('CONTENT_OWNER_NAME',

Line 2335: p_return_status := FND_API.G_RET_STS_ERROR;

2331:
2332:
2333: p_rec_nrec_dist_tbl(l_non_rec_index).rec_nrec_rate:= 100 - l_total_rec_rate;
2334: IF p_rec_nrec_dist_tbl(l_non_rec_index).rec_nrec_rate < 0 THEN
2335: p_return_status := FND_API.G_RET_STS_ERROR;
2336:
2337: FND_MESSAGE.SET_NAME('ZX','ZX_SUM_REC_RATE_OVER');
2338:
2339: FND_MESSAGE.SET_TOKEN('RECOVERY_TYPE_1',

Line 2385: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2381: END IF;
2382:
2383: EXCEPTION
2384: WHEN OTHERS THEN
2385: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2386: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2387:
2388: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2389: FND_LOG.STRING(g_level_unexpected,

Line 2415: p_return_status:= FND_API.G_RET_STS_SUCCESS;

2411: FND_LOG.STRING(g_level_procedure,
2412: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_REC_NREC_DIST_AMT.BEGIN',
2413: 'ZX_TRD_INTERNAL_SERVICES_PVT.GET_REC_NREC_DIST_AMT(+)');
2414: END IF;
2415: p_return_status:= FND_API.G_RET_STS_SUCCESS;
2416:
2417: For i in p_rnd_begin_index..p_rnd_end_index
2418: LOOP
2419: IF NVL(p_rec_nrec_dist_tbl(i).reverse_flag,'N') = 'N' THEN

Line 2435: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2431: END IF;
2432:
2433: EXCEPTION
2434: WHEN OTHERS THEN
2435: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2436: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2437:
2438: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2439: FND_LOG.STRING(g_level_unexpected,

Line 2480: p_return_status:= FND_API.G_RET_STS_SUCCESS;

2476: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT.BEGIN',
2477: 'ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT(+)');
2478: END IF;
2479:
2480: p_return_status:= FND_API.G_RET_STS_SUCCESS;
2481:
2482: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
2483: p_rnd_begin_index > p_rnd_end_index THEN
2484:

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

2481:
2482: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
2483: p_rnd_begin_index > p_rnd_end_index THEN
2484:
2485: --p_return_status:= FND_API.G_RET_STS_ERROR;
2486: IF (g_level_statement >= g_current_runtime_level ) THEN
2487: FND_LOG.STRING(g_level_statement,
2488: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT',
2489: 'begin or end index is null, or begin index > end index');

Line 2522: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2518: p_tax_line_amt_funcl_curr,
2519: p_return_status,
2520: p_error_buffer);
2521:
2522: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2523: IF (g_level_error >= g_current_runtime_level ) THEN
2524: FND_LOG.STRING(g_level_error,
2525: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_rec_nrec_amt',
2526: 'Incorrect return_status after calling ' ||

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

2546: p_rnd_end_index => p_rnd_end_index,
2547: p_return_status => p_return_status,
2548: p_error_buffer => p_error_buffer);
2549:
2550: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS THEN
2551: IF (g_level_statement >= g_current_runtime_level ) THEN
2552: FND_LOG.STRING(g_level_statement,
2553: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.ROUND_REC_NREC_AMT',
2554: 'Incorrect return_status after calling ' ||

Line 2593: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2589: END IF;
2590:
2591: EXCEPTION
2592: WHEN OTHERS THEN
2593: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2594: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2595:
2596: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2597: FND_LOG.STRING(g_level_unexpected,

Line 2649: p_return_status:= FND_API.G_RET_STS_SUCCESS;

2645: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr.BEGIN',
2646: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr(+)');
2647: END IF;
2648:
2649: p_return_status:= FND_API.G_RET_STS_SUCCESS;
2650:
2651: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
2652: p_rnd_begin_index > p_rnd_end_index THEN
2653:

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

2650:
2651: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
2652: p_rnd_begin_index > p_rnd_end_index THEN
2653:
2654: --p_return_status:= FND_API.G_RET_STS_ERROR;
2655: IF (g_level_statement >= g_current_runtime_level ) THEN
2656: FND_LOG.STRING(g_level_statement,
2657: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',
2658: 'begin or end index is null, or begin index > end index');

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

2693: p_return_status => p_return_status,
2694: p_error_buffer => p_error_buffer);
2695: END IF;
2696:
2697: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
2698: THEN
2699: IF (g_level_error >= g_current_runtime_level ) THEN
2700: FND_LOG.STRING(g_level_error,
2701: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

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

2797: p_rec_nrec_dist_tbl(p_rnd_begin_index).precision,
2798: p_return_status,
2799: p_error_buffer);
2800:
2801: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
2802: THEN
2803: IF (g_level_error >= g_current_runtime_level ) THEN
2804: FND_LOG.STRING(g_level_error,
2805: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

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

2832: p_index_amt_tbl => l_non_zero_rec_tax_dists_tbl,
2833: p_return_status => p_return_status,
2834: p_error_buffer => p_error_buffer);
2835:
2836: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
2837: THEN
2838: IF (g_level_error >= g_current_runtime_level ) THEN
2839: FND_LOG.STRING(g_level_error,
2840: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

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

2859: p_min_acct_unit => l_min_acct_unit,
2860: p_return_status => p_return_status,
2861: p_error_buffer => p_error_buffer);
2862:
2863: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
2864: THEN
2865: IF (g_level_error >= g_current_runtime_level ) THEN
2866: FND_LOG.STRING(g_level_error,
2867: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

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

2891: p_index_amt_tbl => l_non_zero_nrec_tax_dists_tbl,
2892: p_return_status => p_return_status,
2893: p_error_buffer => p_error_buffer);
2894:
2895: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
2896: THEN
2897: IF (g_level_error >= g_current_runtime_level ) THEN
2898: FND_LOG.STRING(g_level_error,
2899: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

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

2918: l_min_acct_unit,
2919: p_return_status,
2920: p_error_buffer);
2921:
2922: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
2923: THEN
2924: IF (g_level_error >= g_current_runtime_level ) THEN
2925: FND_LOG.STRING(g_level_error,
2926: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

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

2967: p_index_amt_tbl => l_non_zero_nrec_tax_dists_tbl,
2968: p_return_status => p_return_status,
2969: p_error_buffer => p_error_buffer);
2970:
2971: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
2972: THEN
2973: IF (g_level_error >= g_current_runtime_level ) THEN
2974: FND_LOG.STRING(g_level_error,
2975: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

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

2996: l_min_acct_unit,
2997: p_return_status,
2998: p_error_buffer);
2999:
3000: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS
3001: THEN
3002: IF (g_level_error >= g_current_runtime_level ) THEN
3003: FND_LOG.STRING(g_level_error,
3004: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

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

3029: p_index_amt_tbl => l_non_zero_rec_tax_dists_tbl,
3030: p_return_status => p_return_status,
3031: p_error_buffer => p_error_buffer);
3032:
3033: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3034: THEN
3035: IF (g_level_error >= g_current_runtime_level ) THEN
3036: FND_LOG.STRING(g_level_error,
3037: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

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

3058: l_min_acct_unit,
3059: p_return_status,
3060: p_error_buffer);
3061:
3062: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3063: THEN
3064: IF (g_level_error >= g_current_runtime_level ) THEN
3065: FND_LOG.STRING(g_level_error,
3066: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_tax_dists_trx_curr',

Line 3147: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3143:
3144: EXCEPTION
3145:
3146: WHEN OTHERS THEN
3147: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3148: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3149:
3150: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3151: FND_LOG.STRING(g_level_unexpected,

Line 3221: p_return_status:= FND_API.G_RET_STS_SUCCESS;

3217: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists.BEGIN',
3218: 'ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists(+)');
3219: END IF;
3220:
3221: p_return_status:= FND_API.G_RET_STS_SUCCESS;
3222:
3223: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
3224: p_rnd_begin_index > p_rnd_end_index THEN
3225:

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

3222:
3223: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
3224: p_rnd_begin_index > p_rnd_end_index THEN
3225:
3226: --p_return_status:= FND_API.G_RET_STS_ERROR;
3227: IF (g_level_statement >= g_current_runtime_level ) THEN
3228: FND_LOG.STRING(g_level_statement,
3229: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3230: 'begin or end index is null, or begin index > end index');

Line 3254: p_return_status:= FND_API.G_RET_STS_ERROR;

3250: END LOOP;
3251: ELSE
3252:
3253: IF p_rec_nrec_dist_tbl(p_rnd_begin_index).tax_currency_code IS NULL THEN
3254: p_return_status:= FND_API.G_RET_STS_ERROR;
3255: IF (g_level_error >= g_current_runtime_level ) THEN
3256: FND_LOG.STRING(g_level_error,
3257: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',
3258: 'Tax currency code is NULL');

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

3307: p_return_status,
3308: p_error_buffer,
3309: p_rec_nrec_dist_tbl(i).currency_conversion_date); --Bug7183884
3310:
3311: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3312: THEN
3313: IF (g_level_error >= g_current_runtime_level ) THEN
3314: FND_LOG.STRING(g_level_error,
3315: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

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

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

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

3439: p_return_status,
3440: p_error_buffer,
3441: p_rec_nrec_dist_tbl(p_rnd_begin_index).currency_conversion_date); --Bug7183884
3442:
3443: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3444: THEN
3445: IF (g_level_error >= g_current_runtime_level ) THEN
3446: FND_LOG.STRING(g_level_error,
3447: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

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

3473: l_precision_tax_curr,
3474: p_return_status,
3475: p_error_buffer);
3476:
3477: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3478: THEN
3479: IF (g_level_error >= g_current_runtime_level ) THEN
3480: FND_LOG.STRING(g_level_error,
3481: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

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

3511: p_index_amt_tbl => l_non_zero_rec_tax_dists_tbl,
3512: p_return_status => p_return_status,
3513: p_error_buffer => p_error_buffer);
3514:
3515: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3516: THEN
3517: IF (g_level_error >= g_current_runtime_level ) THEN
3518: FND_LOG.STRING(g_level_error,
3519: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

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

3538: p_min_acct_unit => l_min_acct_unit_tax_curr,
3539: p_return_status => p_return_status,
3540: p_error_buffer => p_error_buffer);
3541:
3542: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3543: THEN
3544: IF (g_level_error >= g_current_runtime_level ) THEN
3545: FND_LOG.STRING(g_level_error,
3546: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

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

3570: p_index_amt_tbl => l_non_zero_nrec_tax_dists_tbl,
3571: p_return_status => p_return_status,
3572: p_error_buffer => p_error_buffer);
3573:
3574: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3575: THEN
3576: IF (g_level_error >= g_current_runtime_level ) THEN
3577: FND_LOG.STRING(g_level_error,
3578: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

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

3597: p_min_acct_unit => l_min_acct_unit_tax_curr,
3598: p_return_status => p_return_status,
3599: p_error_buffer => p_error_buffer);
3600:
3601: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3602: THEN
3603: IF (g_level_error >= g_current_runtime_level ) THEN
3604: FND_LOG.STRING(g_level_error,
3605: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

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

3639: p_index_amt_tbl => l_non_zero_nrec_tax_dists_tbl,
3640: p_return_status => p_return_status,
3641: p_error_buffer => p_error_buffer);
3642:
3643: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3644: THEN
3645: IF (g_level_error >= g_current_runtime_level ) THEN
3646: FND_LOG.STRING(g_level_error,
3647: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

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

3668: p_min_acct_unit => l_min_acct_unit_tax_curr,
3669: p_return_status => p_return_status,
3670: p_error_buffer => p_error_buffer);
3671:
3672: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3673: THEN
3674: IF (g_level_error >= g_current_runtime_level ) THEN
3675: FND_LOG.STRING(g_level_error,
3676: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

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

3701: p_index_amt_tbl => l_non_zero_rec_tax_dists_tbl,
3702: p_return_status => p_return_status,
3703: p_error_buffer => p_error_buffer);
3704:
3705: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
3706: THEN
3707: IF (g_level_error >= g_current_runtime_level ) THEN
3708: FND_LOG.STRING(g_level_error,
3709: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

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

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

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

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

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

3863: l_precision_tax_curr,
3864: p_return_status,
3865: p_error_buffer);
3866:
3867: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS
3868: THEN
3869: IF (g_level_error >= g_current_runtime_level ) THEN
3870: FND_LOG.STRING(g_level_error,
3871: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

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

3906: p_ledger_id => l_ledger_id,
3907: p_return_status => p_return_status,
3908: p_error_buffer => p_error_buffer);
3909:
3910: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS
3911: THEN
3912: IF (g_level_error >= g_current_runtime_level ) THEN
3913: FND_LOG.STRING(g_level_error,
3914: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

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

4148: p_index_amt_tbl => l_non_zero_rec_tax_dists_tbl,
4149: p_return_status => p_return_status,
4150: p_error_buffer => p_error_buffer);
4151:
4152: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4153: THEN
4154: IF (g_level_error >= g_current_runtime_level ) THEN
4155: FND_LOG.STRING(g_level_error,
4156: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

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

4195: p_index_amt_tbl => l_non_zero_nrec_tax_dists_tbl,
4196: p_return_status => p_return_status,
4197: p_error_buffer => p_error_buffer);
4198:
4199: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4200: THEN
4201: IF (g_level_error >= g_current_runtime_level ) THEN
4202: FND_LOG.STRING(g_level_error,
4203: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

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

4222: p_min_acct_unit => l_min_acct_unit_funcl_curr,
4223: p_return_status => p_return_status,
4224: p_error_buffer => p_error_buffer);
4225:
4226: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4227: THEN
4228: IF (g_level_error >= g_current_runtime_level ) THEN
4229: FND_LOG.STRING(g_level_error,
4230: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

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

4266: p_index_amt_tbl => l_non_zero_nrec_tax_dists_tbl,
4267: p_return_status => p_return_status,
4268: p_error_buffer => p_error_buffer);
4269:
4270: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4271: THEN
4272: IF (g_level_error >= g_current_runtime_level ) THEN
4273: FND_LOG.STRING(g_level_error,
4274: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

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

4296: p_min_acct_unit => l_min_acct_unit_funcl_curr,
4297: p_return_status => p_return_status,
4298: p_error_buffer => p_error_buffer);
4299:
4300: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4301: THEN
4302: IF (g_level_error >= g_current_runtime_level ) THEN
4303: FND_LOG.STRING(g_level_error,
4304: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

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

4333: p_index_amt_tbl => l_non_zero_rec_tax_dists_tbl,
4334: p_return_status => p_return_status,
4335: p_error_buffer => p_error_buffer);
4336:
4337: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4338: THEN
4339: IF (g_level_error >= g_current_runtime_level ) THEN
4340: FND_LOG.STRING(g_level_error,
4341: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

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

4363: p_min_acct_unit => l_min_acct_unit_funcl_curr,
4364: p_return_status => p_return_status,
4365: p_error_buffer => p_error_buffer);
4366:
4367: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4368: THEN
4369: IF (g_level_error >= g_current_runtime_level ) THEN
4370: FND_LOG.STRING(g_level_error,
4371: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.convert_tax_dists',

Line 4545: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4541:
4542: EXCEPTION
4543:
4544: WHEN OTHERS THEN
4545: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4546: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4547:
4548: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4549: FND_LOG.STRING(g_level_unexpected,

Line 4582: p_return_status:= FND_API.G_RET_STS_SUCCESS;

4578: 'ZX_TRD_INTERNAL_SERVICES_PVT.distribute_rounding_diff(+)'||
4579: 'p_rounding_diff = ' || p_rounding_diff);
4580: END IF;
4581:
4582: p_return_status:= FND_API.G_RET_STS_SUCCESS;
4583:
4584: -- Adjust rounding difference
4585: --
4586: IF p_rounding_diff = 0 THEN

Line 4646: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4642:
4643: EXCEPTION
4644:
4645: WHEN OTHERS THEN
4646: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4647: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4648:
4649: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4650: FND_LOG.STRING(g_level_unexpected,

Line 4682: p_return_status:= FND_API.G_RET_STS_SUCCESS;

4678: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc.BEGIN',
4679: 'ZX_TRD_INTERNAL_SERVICES_PVT.sort_tbl_amt_desc(+)');
4680: END IF;
4681:
4682: p_return_status:= FND_API.G_RET_STS_SUCCESS;
4683:
4684: -- initialize local variables
4685: --
4686: l_length := p_index_amt_tbl.COUNT;

Line 4735: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4731:
4732: EXCEPTION
4733:
4734: WHEN OTHERS THEN
4735: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4736: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4737:
4738: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4739: FND_LOG.STRING(g_level_unexpected,

Line 4811: p_return_status := FND_API.G_RET_STS_SUCCESS;

4807: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied.BEGIN',
4808: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied(+)');
4809: END IF;
4810:
4811: p_return_status := FND_API.G_RET_STS_SUCCESS;
4812:
4813: p_rnd_end_index := p_rnd_begin_index -1;
4814: l_rec_nrec_tax_dist_number:= 0;
4815:

Line 4897: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4893: END IF;
4894:
4895: EXCEPTION
4896: WHEN OTHERS THEN
4897: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4898: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4899:
4900: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4901: FND_LOG.STRING(g_level_unexpected,

Line 4968: p_return_status := FND_API.G_RET_STS_SUCCESS;

4964: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted.BEGIN',
4965: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted(+)');
4966: END IF;
4967:
4968: p_return_status := FND_API.G_RET_STS_SUCCESS;
4969:
4970: p_rnd_end_index := p_rnd_begin_index - 1;
4971:
4972: l_rec_nrec_tax_dist_number := 0;

Line 5013: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5009: END IF;
5010:
5011: EXCEPTION
5012: WHEN OTHERS THEN
5013: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5014: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5015:
5016: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5017: FND_LOG.STRING(g_level_unexpected,

Line 5094: p_return_status := FND_API.G_RET_STS_SUCCESS;

5090: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref.BEGIN',
5091: 'ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref(+)');
5092: END IF;
5093:
5094: p_return_status := FND_API.G_RET_STS_SUCCESS;
5095:
5096: p_rnd_end_index := p_rnd_begin_index -1;
5097:
5098: OPEN get_maximum_tax_dist_num_csr;

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

5176: p_rnd_end_index,
5177: p_return_status,
5178: p_error_buffer);
5179:
5180: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS
5181: THEN
5182: IF (g_level_error >= g_current_runtime_level ) THEN
5183: FND_LOG.STRING(g_level_error,
5184: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.enforce_recovery_from_ref',

Line 5207: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5203: END IF;
5204:
5205: EXCEPTION
5206: WHEN OTHERS THEN
5207: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5208: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5209:
5210: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5211: FND_LOG.STRING(g_level_unexpected,

Line 5266: p_return_status:= FND_API.G_RET_STS_SUCCESS;

5262: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts.BEGIN',
5263: 'ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts(+)');
5264: END IF;
5265:
5266: p_return_status:= FND_API.G_RET_STS_SUCCESS;
5267:
5268: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
5269: p_rnd_begin_index > p_rnd_end_index THEN
5270:

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

5267:
5268: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
5269: p_rnd_begin_index > p_rnd_end_index THEN
5270:
5271: --p_return_status:= FND_API.G_RET_STS_ERROR;
5272: IF (g_level_error >= g_current_runtime_level ) THEN
5273: FND_LOG.STRING(g_level_error,
5274: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts ',
5275: 'begin or end index is null, or begin index > end index');

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

5287: p_ledger_id => l_ledger_id,
5288: p_return_status => p_return_status,
5289: p_error_buffer => p_error_buffer);
5290:
5291: IF NVL(p_return_status,FND_API.G_RET_STS_ERROR)<>FND_API.G_RET_STS_SUCCESS
5292: THEN
5293: IF (g_level_error >= g_current_runtime_level ) THEN
5294: FND_LOG.STRING(g_level_error,
5295: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts',

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

5345: l_precision_tax_curr,
5346: p_return_status,
5347: p_error_buffer);
5348:
5349: IF NVL(p_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
5350: THEN
5351: IF (g_level_error >= g_current_runtime_level ) THEN
5352: FND_LOG.STRING(g_level_error,
5353: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.round_and_adjust_prd_tax_amts ',

Line 5541: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5537:
5538: EXCEPTION
5539:
5540: WHEN OTHERS THEN
5541: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5542: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5543:
5544: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5545: FND_LOG.STRING(g_level_unexpected,

Line 5574: p_return_status:= FND_API.G_RET_STS_SUCCESS;

5570: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns.BEGIN',
5571: 'ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns(+)');
5572: END IF;
5573:
5574: p_return_status:= FND_API.G_RET_STS_SUCCESS;
5575:
5576: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
5577: p_rnd_begin_index > p_rnd_end_index THEN
5578:

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

5575:
5576: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
5577: p_rnd_begin_index > p_rnd_end_index THEN
5578:
5579: --p_return_status:= FND_API.G_RET_STS_ERROR;
5580: IF (g_level_statement >= g_current_runtime_level ) THEN
5581: FND_LOG.STRING(g_level_statement,
5582: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_variance_related_columns',
5583: 'begin or end index is null, or begin index > end index');

Line 5662: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5658: END IF;
5659:
5660: EXCEPTION
5661: WHEN OTHERS THEN
5662: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5663: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5664:
5665: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5666: FND_LOG.STRING(g_level_unexpected,

Line 5690: p_return_status:= FND_API.G_RET_STS_SUCCESS;

5686: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors.BEGIN',
5687: 'ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors(+)');
5688: END IF;
5689:
5690: p_return_status:= FND_API.G_RET_STS_SUCCESS;
5691:
5692:
5693: -- Bugfix 5035461: added recoverable_flag and reverse_flag condition in
5694: -- the subquery.

Line 5764: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5760: END IF;
5761:
5762: EXCEPTION
5763: WHEN OTHERS THEN
5764: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5765: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5766:
5767: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5768: FND_LOG.STRING(g_level_unexpected,

Line 5827: p_return_status := FND_API.G_RET_STS_SUCCESS;

5823: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.create_mrc_tax_dists.BEGIN',
5824: 'ZX_TRD_INTERNAL_SERVICES_PVT.create_mrc_tax_dists(+)');
5825: END IF;
5826:
5827: p_return_status := FND_API.G_RET_STS_SUCCESS;
5828:
5829: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
5830: p_rnd_begin_index > p_rnd_end_index THEN
5831:

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

5828:
5829: IF p_rnd_begin_index IS NULL OR p_rnd_end_index IS NULL OR
5830: p_rnd_begin_index > p_rnd_end_index THEN
5831:
5832: --p_return_status := FND_API.G_RET_STS_ERROR;
5833: IF (g_level_statement >= g_current_runtime_level ) THEN
5834: FND_LOG.STRING(g_level_statement,
5835: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.create_mrc_tax_dists',
5836: 'begin or end index is null, or begin index > end index');

Line 5934: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5930: NULL,
5931: p_return_status,
5932: p_error_buffer);
5933:
5934: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5935: IF (g_level_statement >= g_current_runtime_level ) THEN
5936: FND_LOG.STRING(g_level_statement,
5937: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.create_mrc_tax_dists',
5938: 'After calling ROUND_REC_NREC_AMT p_return_status = '

Line 5956: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5952: END IF;
5953:
5954: EXCEPTION
5955: WHEN OTHERS THEN
5956: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5957:
5958: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5959: FND_LOG.STRING(g_level_unexpected,
5960: 'ZX.PLSQL.ZX_TDS_MRC_PROCESSING_PKG.create_mrc_det_tax_lines',