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_API_PUB dependencies on ZX_TDS_CALC_SERVICES_PUB_PKG

Line 580: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (l_event_class_rec ,

576:
577: /* ===============================================================================*
578: |Initialize the global structures/global temp tables owned by TDM at line level |
579: * =============================================================================*/
580: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (l_event_class_rec ,
581: 'HEADER',
582: l_return_status
583: );
584:

Line 588: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||p_api_name,G_PKG_NAME||': '||p_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.initialize returned errors');

584:
585: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
586: x_return_status := l_return_status;
587: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
588: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||p_api_name,G_PKG_NAME||': '||p_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.initialize returned errors');
589: END IF;
590: RETURN;
591: END IF;
592:

Line 868: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (p_event_class_rec => NULL,

864: 'Data Transfer Mode: '||G_DATA_TRANSFER_MODE);
865: END IF;
866:
867: --Call TDS process to reset the session for previous calculate tax calls if any
868: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (p_event_class_rec => NULL,
869: p_init_level => 'SESSION',
870: x_return_status => l_return_status
871: );
872:

Line 1016: ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(x_return_status => l_return_status);

1012: | Call to eTax service Dump Detail Tax Lines Into GT|
1013: +-----------------------------------------------------*/
1014:
1015: --IF nvl(l_event_class_rec.PROCESS_FOR_APPLICABILITY_FLAG,'Y') = 'Y' THEN
1016: ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(x_return_status => l_return_status);
1017:
1018:
1019: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1020: x_return_status := l_return_status;

Line 1023: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt returned errors');

1019: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1020: x_return_status := l_return_status;
1021: --DUMP_MSG;
1022: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1023: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt returned errors');
1024: END IF;
1025: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1026: RAISE FND_API.G_EXC_ERROR;
1027: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1035: ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination(p_event_class_rec => zx_global_structures_pkg.g_event_class_rec,

1031:
1032: /*--------------------------------------------------+
1033: | Call to eTax Service Tax Lines Determination |
1034: +--------------------------------------------------*/
1035: ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination(p_event_class_rec => zx_global_structures_pkg.g_event_class_rec,
1036: x_return_status => l_return_status
1037: );
1038:
1039: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1043: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination returned errors');

1039: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1040: x_return_status := l_return_status ;
1041: --DUMP_MSG;
1042: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1043: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination returned errors');
1044: END IF;
1045: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1046: RAISE FND_API.G_EXC_ERROR;
1047: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1630: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (p_event_class_rec => NULL,

1626: 'Data Transfer Mode: '||G_DATA_TRANSFER_MODE);
1627: END IF;
1628:
1629: --Call TDS process to reset the session for previous calculate tax calls if any
1630: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (p_event_class_rec => NULL,
1631: p_init_level => 'SESSION',
1632: x_return_status => l_return_status
1633: );
1634: set_ptnr_srvc_subscr_flag (p_event_class_rec => NULL,

Line 1874: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (l_event_class_rec ,

1870: /* ===============================================================================*
1871: |Initialize the global structures/global temp tables owned by TDM at header level |
1872: * ===============================================================================*/
1873:
1874: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (l_event_class_rec ,
1875: 'HEADER',
1876: l_return_status
1877: );
1878:

Line 1881: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.initialize returned errors');

1877: );
1878:
1879: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1880: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1881: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.initialize returned errors');
1882: END IF;
1883: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1884: RAISE FND_API.G_EXC_ERROR;
1885: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1953: ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(x_return_status => l_return_status);

1949:
1950: /*-----------------------------------------------------+
1951: | Call to eTax service Dump Detail Tax Lines Into GT|
1952: +-----------------------------------------------------*/
1953: ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(x_return_status => l_return_status);
1954:
1955:
1956: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1957: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1958: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt returned errors');

1954:
1955:
1956: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1957: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1958: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt returned errors');
1959: END IF;
1960: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1961: RAISE FND_API.G_EXC_ERROR;
1962: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1970: ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination(p_event_class_rec => l_event_class_rec,

1966:
1967: /*--------------------------------------------------+
1968: | Call to eTax Service Tax Lines Determination |
1969: +--------------------------------------------------*/
1970: ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination(p_event_class_rec => l_event_class_rec,
1971: x_return_status => l_return_status
1972: );
1973:
1974: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1976: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination returned errors');

1972: );
1973:
1974: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1975: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1976: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination returned errors');
1977: END IF;
1978: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1979: RAISE FND_API.G_EXC_ERROR;
1980: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2535: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (p_event_class_rec => NULL,

2531: -- added init for bug fix 5417887
2532: /* ===============================================================================*
2533: |Initialize the global structures/global temp tables owned by TDM at header level |
2534: * =============================================================================*/
2535: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (p_event_class_rec => NULL,
2536: p_init_level => 'SESSION',
2537: x_return_status => l_return_status
2538: );
2539:

Line 2653: ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(x_return_status => l_return_status );

2649:
2650: /*-----------------------------------------------------+
2651: | Call to eTax service Dump Detail Tax Lines Into GT|
2652: +-----------------------------------------------------*/
2653: ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(x_return_status => l_return_status );
2654:
2655: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2656: x_return_status := l_return_status ;
2657: --DUMP_MSG;

Line 2659: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt returned errors');

2655: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2656: x_return_status := l_return_status ;
2657: --DUMP_MSG;
2658: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2659: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt returned errors');
2660: END IF;
2661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2662: END IF;
2663:

Line 2667: ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination(

2663:
2664: /*--------------------------------------------------+
2665: | Call to eTax Service Tax Lines Determination |
2666: +--------------------------------------------------*/
2667: ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination(
2668: p_event_class_rec => zx_global_structures_pkg.g_event_class_rec,
2669: x_return_status => l_return_status
2670: );
2671:

Line 2676: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination returned errors');

2672: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2673: x_return_status := l_return_status;
2674: --DUMP_MSG;
2675: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2676: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination returned errors');
2677: END IF;
2678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2679: END IF;
2680:

Line 3537: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (p_event_class_rec => NULL,

3533: G_DATA_TRANSFER_MODE := 'PLS';
3534: G_EXTERNAL_API_CALL := 'N';
3535:
3536: --Call TDS process to reset the session for previous override tax calls if any
3537: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (p_event_class_rec => NULL,
3538: p_init_level => 'SESSION',
3539: x_return_status => l_return_status
3540: );
3541:

Line 3611: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (l_event_class_rec,

3607:
3608: /*===============================================================================*
3609: |Initialize the global structures/global temp tables owned by TDM at header level |
3610: *================================================================================*/
3611: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (l_event_class_rec,
3612: 'HEADER',
3613: l_return_status
3614: );
3615:

Line 3618: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.initialize returned errors');

3614: );
3615:
3616: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3617: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3618: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.initialize returned errors');
3619: END IF;
3620: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3621: RAISE FND_API.G_EXC_ERROR;
3622: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3638: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.initialize returned errors');

3634: x_return_status => l_return_status
3635: );
3636: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3637: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3638: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.initialize returned errors');
3639: END IF;
3640: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3641: RAISE FND_API.G_EXC_ERROR;
3642: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3650: ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(x_return_status => l_return_status);

3646:
3647: /*-----------------------------------------------------+
3648: | Call to eTax service Dump Detail Tax Lines Into GT|
3649: +-----------------------------------------------------*/
3650: ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(x_return_status => l_return_status);
3651:
3652: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3653: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3654: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt returned errors');

Line 3654: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt returned errors');

3650: ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(x_return_status => l_return_status);
3651:
3652: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3653: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3654: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt returned errors');
3655: END IF;
3656: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3657: RAISE FND_API.G_EXC_ERROR;
3658: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3666: ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination(p_event_class_rec => l_event_class_rec,

3662:
3663: /*--------------------------------------------------+
3664: | Call to eTax Service Tax Lines Determination |
3665: +--------------------------------------------------*/
3666: ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination(p_event_class_rec => l_event_class_rec,
3667: x_return_status => l_return_status
3668: );
3669:
3670: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 3672: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination returned errors');

3668: );
3669:
3670: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3671: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3672: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination returned errors');
3673: END IF;
3674: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3675: RAISE FND_API.G_EXC_ERROR;
3676: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 5251: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (p_event_class_rec => NULL,

5247: G_EXTERNAL_API_CALL := 'N';
5248:
5249: --Call TDS process to initialise distributions for previous calls to determine recovery
5250: --if any
5251: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (p_event_class_rec => NULL,
5252: p_init_level => 'TAX_DISTRIBUTION',
5253: x_return_status => l_return_status
5254: );
5255:

Line 5615: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (l_event_class_rec ,

5611:
5612: /* ===============================================================================*
5613: |Initialize the global structures/global temp tables owned by TDM at header level |
5614: * =============================================================================*/
5615: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (l_event_class_rec ,
5616: 'HEADER',
5617: l_return_status
5618: );
5619:

Line 5623: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.initialize returned errors');

5619:
5620: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5621: x_return_status := l_return_status;
5622: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5623: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.initialize returned errors');
5624: END IF;
5625: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5626: RAISE FND_API.G_EXC_ERROR;
5627: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 6137: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (p_event_class_rec => NULL,

6133: G_EXTERNAL_API_CALL := 'N';
6134:
6135: --Call TDS process to initialise distributions for previous calls to determine recovery
6136: --if any
6137: ZX_TDS_CALC_SERVICES_PUB_PKG.initialize (p_event_class_rec => NULL,
6138: p_init_level => 'TAX_DISTRIBUTION',
6139: x_return_status => l_return_status
6140: );
6141: /*------------------------------------------------------+

Line 7169: ZX_TDS_CALC_SERVICES_PUB_PKG.update_exchange_rate(p_event_class_rec => l_event_class_rec,

7165:
7166: /*-------------------------------------------------+
7167: | Call TDS routine update_exchange_rate |
7168: +------------------------------------------------*/
7169: ZX_TDS_CALC_SERVICES_PUB_PKG.update_exchange_rate(p_event_class_rec => l_event_class_rec,
7170: p_ledger_id => l_ledger_id,
7171: p_currency_conversion_rate => p_curr_conv_rate,
7172: p_currency_conversion_type => p_curr_conv_type,
7173: p_currency_conversion_date => p_curr_conv_date,

Line 7179: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.update_exchange_rate returned errors');

7175: );
7176:
7177: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7178: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7179: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.update_exchange_rate returned errors');
7180: END IF;
7181: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7182: RAISE FND_API.G_EXC_ERROR;
7183: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN