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_TPI_SERVICES_PKG dependencies on FND_LOG

Line 8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4: | Global Data Types |
5: * ======================================================================*/
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TPI_SERVICES_PKG';
8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

5: * ======================================================================*/
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TPI_SERVICES_PKG';
8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

6:
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TPI_SERVICES_PKG';
8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TPI_SERVICES_PKG';
8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
15: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TPI_SERVICES_PKG.';

Line 12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
15: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TPI_SERVICES_PKG.';
16:

Line 13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
15: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TPI_SERVICES_PKG.';
16:
17: NUMBER_DUMMY CONSTANT NUMBER(15):= -999999999999999;

Line 14: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
15: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TPI_SERVICES_PKG.';
16:
17: NUMBER_DUMMY CONSTANT NUMBER(15):= -999999999999999;
18:

Line 60: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

56: l_mig_exists number;
57: l_mig_glb_att_cat zx_lines.global_attribute_category%type;
58: BEGIN
59: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
60: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
61: END IF;
62:
63: /*Set the return status to Success */
64: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 163: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.END',

159: END IF; --- bug6024643
160: END IF;
161:
162: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
163: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.END',
164: G_PKG_NAME ||': '||l_api_name||'(-)'||' RETURN_STATUS = ' || x_return_status);
165: END IF;
166:
167: EXCEPTION

Line 171: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

167: EXCEPTION
168: WHEN OTHERS THEN
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
170: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
171: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
172: END IF;
173: RETURN;
174: END get_migrated_doc_info;
175:

Line 202: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

198: l_api_name CONSTANT VARCHAR2(30) := 'POPL_ALL_REGIMES_TBL';
199: l_count NUMBER;
200: BEGIN
201: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
202: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
203: END IF;
204:
205: /*Set the return status to Success */
206: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 214: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

210:
211: IF p_tax_provider_id IS NOT NULL THEN
212: l_count :=ZX_GLOBAL_STRUCTURES_PKG.trx_line_app_regime_tbl.application_id.COUNT+1 ;
213: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
214: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
215: ' l_count = ' || l_count);
216: END IF;
217: ZX_GLOBAL_STRUCTURES_PKG.trx_line_app_regime_tbl.application_id(l_count) :=
218: p_event_class_rec.application_id;

Line 234: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

230: p_event_class_rec.process_for_applicability_flag;
231: ZX_GLOBAL_STRUCTURES_PKG.G_PTNR_SRVC_SUBSCR_FLAG := 'Y';
232: END IF;
233: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
234: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
235: END IF;
236: END popl_all_regimes_tbl;
237:
238: -----------------------------------------------------------------------

Line 274: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

270: l_tax_account_source_tax ZX_TAXES_B.TAX_ACCOUNT_SOURCE_TAX%TYPE;
271:
272: BEGIN
273: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
274: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
275: END IF;
276:
277: /*Set the return status to Success */
278: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 373: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

369: partner_migrated_flag_tbl(p_ptnr_tax_line_ind) := l_lines_det_fact_rec.partner_migrated_flag;
370:
371: IF ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_application_id(p_ptnr_tax_line_ind) IS NOT NULL THEN
372: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
373: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
374: ' adjusted_doc_application_id = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_application_id(p_ptnr_tax_line_ind) ||
375: ' adjusted_doc_entity_code = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_entity_code(p_ptnr_tax_line_ind) ||
376: ' adjusted_doc_event_class_code = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_event_class_code(p_ptnr_tax_line_ind) ||
377: ' adjusted_doc_trx_id = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_trx_id(p_ptnr_tax_line_ind) ||

Line 397: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

393: l_historical_flag := NULL;
394: END;
395:
396: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
397: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
398: ' l_historical_flag = ' || l_historical_flag);
399: END IF;
400:
401: IF NVL(l_historical_flag,'N') = 'Y' THEN

Line 499: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

495: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_tax_line_id(p_ptnr_tax_line_ind) := NULL;
496: END IF;
497:
498: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
499: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
500: ' adjusted_doc_tax_line_id = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_tax_line_id(p_ptnr_tax_line_ind));
501: END IF;
502: IF prev_tax_regime_code IS NULL
503: OR prev_tax_regime_code <> ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.country_code(p_ptnr_tax_line_ind) THEN

Line 609: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

605: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.legal_justification_text3(p_ptnr_tax_line_ind) := NULL;
606: END IF;
607:
608: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
609: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
610: ' tax_exemption_id = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_exemption_id(p_ptnr_tax_line_ind));
611: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
612: ' exempt_reason_code = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.exempt_reason_code(p_ptnr_tax_line_ind));
613: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 611: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

607:
608: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
609: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
610: ' tax_exemption_id = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_exemption_id(p_ptnr_tax_line_ind));
611: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
612: ' exempt_reason_code = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.exempt_reason_code(p_ptnr_tax_line_ind));
613: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
614: ' exempt_reason = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.exempt_reason(p_ptnr_tax_line_ind));
615: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 613: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

609: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
610: ' tax_exemption_id = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_exemption_id(p_ptnr_tax_line_ind));
611: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
612: ' exempt_reason_code = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.exempt_reason_code(p_ptnr_tax_line_ind));
613: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
614: ' exempt_reason = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.exempt_reason(p_ptnr_tax_line_ind));
615: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
616: ' exempt_certificate_number = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.exempt_certificate_number(p_ptnr_tax_line_ind));
617: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 615: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

611: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
612: ' exempt_reason_code = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.exempt_reason_code(p_ptnr_tax_line_ind));
613: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
614: ' exempt_reason = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.exempt_reason(p_ptnr_tax_line_ind));
615: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
616: ' exempt_certificate_number = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.exempt_certificate_number(p_ptnr_tax_line_ind));
617: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
618: ' establishment_id = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.establishment_id(p_ptnr_tax_line_ind));
619: END IF;

Line 617: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

613: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
614: ' exempt_reason = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.exempt_reason(p_ptnr_tax_line_ind));
615: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
616: ' exempt_certificate_number = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.exempt_certificate_number(p_ptnr_tax_line_ind));
617: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
618: ' establishment_id = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.establishment_id(p_ptnr_tax_line_ind));
619: END IF;
620:
621: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 622: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME ||': '||l_api_name||'(-)');

618: ' establishment_id = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.establishment_id(p_ptnr_tax_line_ind));
619: END IF;
620:
621: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
622: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME ||': '||l_api_name||'(-)');
623: END IF;
624:
625: EXCEPTION
626: WHEN OTHERS THEN

Line 629: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

625: EXCEPTION
626: WHEN OTHERS THEN
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
628: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
629: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
630: END IF;
631: RETURN;
632: END set_detail_tax_line_values;
633:

Line 656: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

652: l_api_name CONSTANT VARCHAR2(30) := 'EXEMPTION_HANDLING';
653: l_count NUMBER;
654: BEGIN
655: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
656: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
657: END IF;
658:
659: --Set the return status to Success
660: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 707: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME ||': '||l_api_name||'(-)');

703: x_exemption_rec => l_exemption_rec);
704: END LOOP;
705:
706: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
707: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME ||': '||l_api_name||'(-)');
708: END IF;
709: END exemption_handling;
710: */
711:

Line 750: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

746: l_context_info_rec ZX_API_PUB.context_info_rec_type;
747:
748: BEGIN
749: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
750: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
751: END IF;
752:
753: /*Set the return status to Success */
754: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 764: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

760: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_app_regime_tbl.entity_code(i) = p_event_class_rec.entity_code
761: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_app_regime_tbl.event_class_code(i) = p_event_class_rec.event_class_code
762: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_app_regime_tbl.trx_id(i) = p_event_class_rec.trx_id THEN
763: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
764: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
765: ' Application Id = ' || p_event_class_rec.application_id ||
766: ' Entity code = ' || p_event_class_rec.entity_code ||
767: ' Event Class code = ' || p_event_class_rec.event_class_code ||
768: ' Trx Id = ' || p_event_class_rec.trx_id ||

Line 825: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

821: EXCEPTION
822: WHEN OTHERS THEN
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
824: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
825: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
826: END IF;
827: END;
828: END;
829: END IF;

Line 859: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

855: AND update_flag = 'Y';
856: END IF;
857:
858: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
859: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
860: G_PKG_NAME ||': '||l_api_name||'(-)'||' RETURN_STATUS = ' || x_return_status);
861: END IF;
862:
863: EXCEPTION

Line 867: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

863: EXCEPTION
864: WHEN OTHERS THEN
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
866: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
867: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
868: END IF;
869: END trx_line_app_regimes_tbl_hdl;
870:
871: -----------------------------------------------------------------------

Line 952: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

948:
949:
950: BEGIN
951: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
952: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
953: END IF;
954:
955: --Set the return status to Success
956: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1002: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

998: );
999: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1000: x_return_status := l_return_status;
1001: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1002: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1003: ' RETURN_STATUS = ' || x_return_status);
1004: END IF;
1005: RETURN;
1006: END IF;

Line 1031: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1027:
1028: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1029: x_return_status := l_return_status;
1030: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1031: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1032: ' RETURN_STATUS = ' || x_return_status);
1033: END IF;
1034: RETURN;
1035: END IF;

Line 1038: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' APPLIED_FROM_DOCUMENT :not migrated- retrieve the applicable regimes from zx_trx_line_app_regimes for original transaction');

1034: RETURN;
1035: END IF;
1036: ELSIF l_ptnr_migrated_flag ='N' THEN
1037: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1038: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' APPLIED_FROM_DOCUMENT :not migrated- retrieve the applicable regimes from zx_trx_line_app_regimes for original transaction');
1039: END IF;
1040: FOR app_docs IN app_doc_regime_csr(p_trx_line_index) LOOP
1041: IF NOT ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl.EXISTS(app_docs.tax_regime_id) THEN
1042: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(app_docs.tax_regime_id).tax_regime_id :=app_docs.tax_regime_id;

Line 1063: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1059: );
1060: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1061: x_return_status := l_return_status;
1062: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1063: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1064: ' RETURN_STATUS = ' || x_return_status);
1065: END IF;
1066: RETURN;
1067: END IF;

Line 1103: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1099:
1100: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1101: x_return_status := l_return_status;
1102: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1103: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1104: ' RETURN_STATUS = ' || x_return_status);
1105: END IF;
1106: RETURN;
1107: END IF;

Line 1132: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1128:
1129: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1130: x_return_status := l_return_status;
1131: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1132: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1133: ' RETURN_STATUS = ' || x_return_status);
1134: END IF;
1135: RETURN;
1136: END IF;

Line 1141: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' ADJ_DOC:not migrated - $' || adj_docs.tax_regime_code || '$' || adj_docs.effective_from);

1137: END IF; --- bug6024643
1138: ELSIF l_ptnr_migrated_flag ='N' THEN
1139: FOR adj_docs IN adj_doc_regime_csr(p_trx_line_index) LOOP
1140: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1141: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' ADJ_DOC:not migrated - $' || adj_docs.tax_regime_code || '$' || adj_docs.effective_from);
1142: END IF;
1143: IF NOT ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl.EXISTS(adj_docs.tax_regime_id) THEN
1144: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(adj_docs.tax_regime_id).tax_regime_id :=adj_docs.tax_regime_id;
1145: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(adj_docs.tax_regime_id).tax_regime_code := adj_docs.tax_regime_code;

Line 1164: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1160: );
1161: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1162: x_return_status := l_return_status;
1163: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1164: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1165: ' RETURN_STATUS = ' || x_return_status);
1166: END IF;
1167: RETURN;
1168: END IF;

Line 1195: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1191:
1192: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1193: x_return_status := l_return_status;
1194: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1195: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1196: ' RETURN_STATUS = ' || x_return_status);
1197: END IF;
1198: RETURN;
1199: END IF;

Line 1219: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1215: );
1216: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1217: x_return_status := l_return_status;
1218: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1219: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1220: ' RETURN_STATUS = ' || x_return_status);
1221: END IF;
1222: RETURN;
1223: END IF;

Line 1242: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1238:
1239: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1240: x_return_status := l_return_status;
1241: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1242: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1243: ' RETURN_STATUS = ' || x_return_status);
1244: END IF;
1245: RETURN;
1246: END IF;

Line 1258: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

1254:
1255: END IF;
1256:
1257: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1258: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1259: G_PKG_NAME ||': '||l_api_name||'(-)'||' RETURN_STATUS = ' || x_return_status);
1260: END IF;
1261:
1262: EXCEPTION

Line 1266: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

1262: EXCEPTION
1263: WHEN OTHERS THEN
1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1265: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1266: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1267: END IF;
1268: END popl_pvrdr_info_tax_reg_tbl;
1269:
1270: -----------------------------------------------------------------------

Line 1299: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

1295: l_tbl_index BINARY_INTEGER;
1296:
1297: BEGIN
1298: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1299: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1300: END IF;
1301:
1302: --Set the return status to Success
1303: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1306: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1302: --Set the return status to Success
1303: x_return_status := FND_API.G_RET_STS_SUCCESS;
1304:
1305: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1306: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1307: ' Application Id = ' || to_char(p_application_id) ||
1308: ' Entity code = ' || p_entity_code ||
1309: ' Event Class code = ' || p_event_class_code ||
1310: ' ZX_SECURITY.G_FIRST_PARTY_ORG_ID = ' || ZX_SECURITY.G_FIRST_PARTY_ORG_ID ||

Line 1324: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1320: AND tax_regime_tmp_tbl(l_tbl_index).event_class_code = p_event_class_code
1321: AND tax_regime_tmp_tbl(l_tbl_index).first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID
1322: AND tax_regime_tmp_tbl(l_tbl_index).tax_regime_code = p_tax_regime_code THEN
1323: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1324: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1325: ' Using tax_regime_tmp_tbl cache');
1326: END IF;
1327:
1328: x_provider_id := tax_regime_tmp_tbl(l_tbl_index).srvc_provider_id;

Line 1354: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1350: EXCEPTION
1351: WHEN NO_DATA_FOUND THEN
1352: x_provider_id := 0; --eBTax is the tax provider
1353: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1354: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1355: ' Tax Provider = eBTax' );
1356: END IF;
1357: END;
1358: tax_regime_tmp_tbl(l_tbl_index).srvc_provider_id := x_provider_id;

Line 1380: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1376: EXCEPTION
1377: WHEN OTHERS THEN
1378: l_provider_name := NULL;
1379: END;
1380: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1381: ' Tax Provider = ' || l_provider_name);
1382: END IF;
1383: END IF;
1384:

Line 1386: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

1382: END IF;
1383: END IF;
1384:
1385: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1386: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1387: G_PKG_NAME ||': '||l_api_name||'(-)'||' RETURN_STATUS = ' || x_return_status);
1388: END IF;
1389:
1390: EXCEPTION

Line 1394: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

1390: EXCEPTION
1391: WHEN OTHERS THEN
1392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1393: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1394: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1395: END IF;
1396: END get_service_provider;
1397:
1398:

Line 1426: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

1422: l_provider_name VARCHAR2(50);
1423:
1424: BEGIN
1425: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1426: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1427: END IF;
1428:
1429: --Set the return status to Success
1430: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1454: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1450: zx_party_tax_profile ptp
1451: WHERE pty.party_id = ptp.party_id
1452: AND ptp.party_tax_profile_id = x_provider_id;
1453:
1454: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1455: ' Tax Provider = ' || l_provider_name);
1456: END IF;
1457:
1458: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1459: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

1455: ' Tax Provider = ' || l_provider_name);
1456: END IF;
1457:
1458: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1459: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1460: G_PKG_NAME ||': '||l_api_name||'(-)'||' RETURN_STATUS = ' || x_return_status);
1461: END IF;
1462:
1463: EXCEPTION

Line 1467: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1463: EXCEPTION
1464: WHEN NO_DATA_FOUND THEN
1465: x_provider_id := 0; --eBTax is the tax provider
1466: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1467: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1468: ' Tax Provider = eBTax' );
1469: END IF;
1470: WHEN OTHERS THEN
1471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1473: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

1469: END IF;
1470: WHEN OTHERS THEN
1471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1472: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1473: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1474: END IF;
1475: END get_service_provider;
1476:
1477:

Line 1524: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

1520: AND rownum = 1;
1521:
1522: BEGIN
1523: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1524: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1525: END IF;
1526:
1527: --Set the return status to Success
1528: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1571: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1567: -- ZX_USER_EXT_PKG.G_EXT_ATTRS_INPUT_REC.event_id := p_event_class_rec.event_id;
1568:
1569: --Call the procedure to derive user extensible parameters
1570: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1571: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1572: ' Call the registered User extensibe procedure ' || x_return_status);
1573: END IF;
1574:
1575: -- Added Begin-Exception-End Block around ZX_USER_EXT_PKG.invoke_third_party_interface for Error Handling

Line 1587: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1583:
1584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1585: x_return_status := l_return_status;
1586: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1587: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1588: ' RETURN_STATUS = ' || x_return_status);
1589: END IF;
1590: RETURN;
1591: END IF;

Line 1606: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

1602: CLOSE get_service_provider_csr;
1603: END IF;
1604:
1605: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1606: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1607: END IF;
1608: FND_MESSAGE.SET_NAME('ZX','ZX_PTNR_SERVICE_REQD');
1609: FND_MESSAGE.SET_TOKEN('SERVICE_PROVIDER',l_service_provider);
1610: ZX_API_PUB.add_msg(p_context_info_rec => ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

Line 1698: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

1694: END;
1695: END IF; --End of p_service_type_code
1696:
1697: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1698: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1699: G_PKG_NAME ||': '||l_api_name||'(-)'||' RETURN_STATUS = ' || x_return_status);
1700: END IF;
1701:
1702: EXCEPTION

Line 1706: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

1702: EXCEPTION
1703: WHEN OTHERS THEN
1704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1705: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1706: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1707: END IF;
1708: END derive_ext_attrs;
1709:
1710: -----------------------------------------------------------------------

Line 1754: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

1750: l_tax_provider_id NUMBER; -- Bug 5090593
1751:
1752: BEGIN
1753: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1754: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1755: END IF;
1756:
1757: --Set the return status to Success
1758: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1773: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1769:
1770: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1771: x_return_status := l_return_status;
1772: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1773: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1774: ' RETURN_STATUS = ' || x_return_status);
1775: END IF;
1776: RETURN;
1777: END IF;

Line 1837: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1833: AND clsmap.entity_code = p_event_class_rec.entity_code
1834: AND clsmap.event_class_code = p_event_class_rec.event_class_code;
1835: EXCEPTION WHEN OTHERS THEN
1836: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1837: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1838: ' SYNCHRONIZE_TAX_REPOSITORY: Exception while inserting into ZX_TRX_PRE_PROC_OPTIONS_GT');
1839: END IF;
1840: END;
1841: ELSE

Line 1985: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1981: fnd_global.user_id,
1982: fnd_global.conc_login_id);
1983: EXCEPTION WHEN OTHERS THEN
1984: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1985: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1986: ' Exception while inserting into ZX_TRX_PRE_PROC_OPTIONS_GT');
1987: END IF;
1988: END;
1989:

Line 2000: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1996: FROM ZX_TRX_PRE_PROC_OPTIONS_GT;
1997: EXCEPTION WHEN OTHERS THEN
1998: l_cnt_of_options_gt := 0;
1999: END;
2000: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2001: 'The record is inserted in ZX_TRX_PRE_PROC_OPTIONS_GT = ' || l_cnt_of_options_gt);
2002: END IF;
2003: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2004: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

Line 2004: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

2000: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2001: 'The record is inserted in ZX_TRX_PRE_PROC_OPTIONS_GT = ' || l_cnt_of_options_gt);
2002: END IF;
2003: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2004: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
2005: G_PKG_NAME ||': '||l_api_name||'(-)'||' RETURN_STATUS = ' || x_return_status);
2006: END IF;
2007:
2008: EXCEPTION

Line 2014: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

2010: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).partner_processing_flag := 'F';
2011: WHEN OTHERS THEN
2012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2013: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
2014: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
2015: END IF;
2016: END partner_pre_processing;
2017:
2018:

Line 2083: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

2079: AND trx_id = p_event_class_rec.trx_id;
2080:
2081: BEGIN
2082: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2083: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2084: END IF;
2085:
2086: --Set the return status to Success
2087: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2107: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2103: AND srvc.service_type_code = p_service_type_code;
2104: EXCEPTION WHEN OTHERS THEN
2105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --tax returned by partner is not amongst candidate taxes
2106: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2107: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2108: ' The Partner Service '|| p_service_type_code || ' is not registered for ' ||
2109: p_event_class_rec.prod_family_grp_code || ',' || p_tax_regime_code ||
2110: ', and provider ' || p_tax_provider_id);
2111: END IF;

Line 2142: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2138:
2139: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2140: x_return_status := l_return_status;
2141: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2142: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2143: ' RETURN_STATUS = ' || x_return_status);
2144: END IF;
2145: RETURN;
2146: END IF;

Line 2180: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2176: -- Assign tax currencies table data to Global Tax Currencies table
2177: ZX_PTNR_SRVC_INTGRTN_PKG.G_TAX_CURRENCIES_TBL := l_tax_currencies_tbl;
2178:
2179: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2180: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2181: 'No. of records in ZX_PTNR_SRVC_INTGRTN_PKG.G_TAX_CURRENCIES_TBL : '||
2182: TO_CHAR(ZX_PTNR_SRVC_INTGRTN_PKG.G_TAX_CURRENCIES_TBL.COUNT));
2183: END IF;
2184:

Line 2188: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2184:
2185: ELSIF p_service_type_code = 'DOCUMENT_LEVEL_CHANGES' THEN
2186: --Populate trx_rec
2187: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2188: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2189: ' p_event_class_rec.event_class_mapping_id ' || p_event_class_rec.event_class_mapping_id ||
2190: ' ZX_API_PUB.G_PUB_SRVC ' || ZX_API_PUB.G_PUB_SRVC ||
2191: ' p_event_class_rec.event_type_code ' || p_event_class_rec.event_type_code ||
2192: ' p_event_class_rec.tax_event_type_code ' || p_event_class_rec.tax_event_type_code);

Line 2240: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2236: l_prev_trx_id := p_event_class_rec.trx_id;
2237: END IF;
2238:
2239: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2240: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2241: 'Error Type: '||ZX_PTNR_SRVC_INTGRTN_PKG.G_MESSAGES_TBL.ERROR_MESSAGE_TYPE(er_index));
2242: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2243: 'Error Message: '||l_error_buffer);
2244: END IF;

Line 2242: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2238:
2239: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2240: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2241: 'Error Type: '||ZX_PTNR_SRVC_INTGRTN_PKG.G_MESSAGES_TBL.ERROR_MESSAGE_TYPE(er_index));
2242: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2243: 'Error Message: '||l_error_buffer);
2244: END IF;
2245:
2246: END LOOP;

Line 2249: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2245:
2246: END LOOP;
2247:
2248: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2249: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2250: ' RETURN_STATUS = ' || x_return_status);
2251: END IF;
2252: RETURN;
2253: END IF;

Line 2256: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

2252: RETURN;
2253: END IF;
2254:
2255: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2256: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
2257: G_PKG_NAME ||': '||l_api_name||'(-)'||' RETURN_STATUS = ' || x_return_status);
2258: END IF;
2259:
2260: EXCEPTION

Line 2267: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2263: FOR er_index IN NVL(ZX_PTNR_SRVC_INTGRTN_PKG.G_MESSAGES_TBL.ERROR_MESSAGE_STRING.FIRST,1) ..
2264: NVL(ZX_PTNR_SRVC_INTGRTN_PKG.G_MESSAGES_TBL.ERROR_MESSAGE_STRING.LAST,0)
2265: LOOP
2266: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2267: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2268: 'Error Type: '||ZX_PTNR_SRVC_INTGRTN_PKG.G_MESSAGES_TBL.ERROR_MESSAGE_TYPE(er_index));
2269: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2270: 'Error Message: '||ZX_PTNR_SRVC_INTGRTN_PKG.G_MESSAGES_TBL.ERROR_MESSAGE_STRING(er_index));
2271: END IF;

Line 2269: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2265: LOOP
2266: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2267: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2268: 'Error Type: '||ZX_PTNR_SRVC_INTGRTN_PKG.G_MESSAGES_TBL.ERROR_MESSAGE_TYPE(er_index));
2269: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2270: 'Error Message: '||ZX_PTNR_SRVC_INTGRTN_PKG.G_MESSAGES_TBL.ERROR_MESSAGE_STRING(er_index));
2271: END IF;
2272: FND_MESSAGE.SET_NAME('ZX', 'GENERIC_MESSAGE');
2273: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', ZX_PTNR_SRVC_INTGRTN_PKG.G_MESSAGES_TBL.ERROR_MESSAGE_STRING(er_index));

Line 2366: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

2362: ORDER BY rate.tax_class NULLS LAST, rate.subscription_level_code;
2363:
2364: BEGIN
2365: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2366: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2367: END IF;
2368:
2369: --Set the return status to Success
2370: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2377: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'Checking whether any item lines processed for this Transaction');

2373: IF p_event_class_rec.prod_family_grp_code = 'O2C' THEN
2374: l_tax_class := 'OUTPUT';
2375:
2376: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2377: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'Checking whether any item lines processed for this Transaction');
2378: END IF;
2379:
2380: BEGIN
2381: SELECT 'Y' INTO l_ptnr_calc_flag

Line 2413: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2409:
2410: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2411: x_return_status := l_return_status;
2412: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2413: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2414: ' RETURN_STATUS = ' || x_return_status);
2415: END IF;
2416: RETURN;
2417: END IF;

Line 2439: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.END',

2435: END;
2436:
2437: IF l_allow_tax_calculation_flag = 'N' THEN
2438: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2439: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.END',
2440: G_PKG_NAME ||': '||l_api_name||'(-)'||' ptnr_post_processing_calc_tax is skipped for tax only documents');
2441: END IF;
2442: RETURN;
2443: END IF;

Line 2486: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'Tax returned by the tax partner is invalid');

2482: EXCEPTION
2483: WHEN NO_DATA_FOUND THEN
2484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ; --tax returned by partner is not amongst candidate taxes
2485: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
2486: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'Tax returned by the tax partner is invalid');
2487: END IF;
2488: RETURN;
2489: END;
2490:

Line 2516: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2512: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_currency_conversion_type(ptnr_tax_line_index) := l_tax_rec.exchange_rate_type;
2513:
2514: ELSE
2515: IF (g_level_statement >= g_current_runtime_level ) THEN
2516: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2517: 'Incorrect return_status after calling ZX_TDS_UTILITIES_PKG.get_tax_cache_info for tax '
2518: || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index)
2519: || 'RETURN_STATUS = ' || l_return_status);
2520: END IF;

Line 2526: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2522: END IF;
2523:
2524: --PRECISION CHECK
2525: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2526: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2527: ' Checking the preceision returned on tax line' || to_char(l_tax_precision));
2528: END IF;
2529:
2530: FOR i IN ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_currencies_tbl.FIRST.. nvl(ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_currencies_tbl.LAST,0)

Line 2536: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,

2532: IF ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_currencies_tbl(i).tax = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index) THEN
2533: IF ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_currencies_tbl(i).tax_currency_precision > l_tax_precision THEN -- Bug 5288518
2534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --tax returned by partner is not amongst candidate taxes
2535: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
2536: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,
2537: ' Precision returned by the tax partner is invalid ');
2538: END IF;
2539: RETURN; -- Bug 4769082
2540: END IF;

Line 2551: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2547:
2548:
2549: --Check if multiple regimes applicable for transaction line and if inclusive flag set for tax line (Point 3d)
2550: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2551: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2552: ' Inclusive Tax Line Flag: ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.inclusive_tax_line_flag(ptnr_tax_line_index));
2553: END IF;
2554: IF ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.inclusive_tax_line_flag(ptnr_tax_line_index) = 'Y' THEN
2555: BEGIN

Line 2570: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2566:
2567: IF l_app_regimes > 1 THEN
2568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --tax returned by partner cannot be inclusive
2569: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2570: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2571: ' Returned tax line for multiple regimes by the tax partner is invalid ' || x_return_status);
2572: END IF;
2573: RETURN;
2574: END IF;

Line 2607: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' In exception of zx_sco_status');

2603: AND rownum = 1
2604: ORDER BY subscription_level_code; -- Bug#5395227
2605: EXCEPTION WHEN OTHERS THEN
2606: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2607: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' In exception of zx_sco_status');
2608: END IF;
2609: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_status_code(ptnr_tax_line_index) := NULL;
2610: END;
2611:

Line 2613: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2609: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_status_code(ptnr_tax_line_index) := NULL;
2610: END;
2611:
2612: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2613: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2614: ' Determine default tax rate for status ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_status_code(ptnr_tax_line_index));
2615: END IF;
2616:
2617: /* Bug#5417753- replace by the cursor below

Line 2639: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' In exception of zx_sco_rates');

2635: AND rownum = 1
2636: ORDER BY rate.tax_class NULLS LAST, rate.subscription_level_code; -- Bug#5395227
2637: EXCEPTION WHEN OTHERS THEN
2638: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2639: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' In exception of zx_sco_rates');
2640: END IF;
2641: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_rate_code(ptnr_tax_line_index) := NULL;
2642: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.rate_type_code(ptnr_tax_line_index) := NULL;
2643: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_rate_id(ptnr_tax_line_index) := NULL;

Line 2672: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2668: l_return_status);
2669:
2670: --Max Tax condition handling (point 3C in DLD)
2671: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2672: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2673: ' Threshold Indicator Flag: ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.threshold_indicator_flag(ptnr_tax_line_index));
2674: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2675: ' Exempt Certificate Number: ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.exempt_certificate_number(ptnr_tax_line_index));
2676: END IF;

Line 2674: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2670: --Max Tax condition handling (point 3C in DLD)
2671: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2672: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2673: ' Threshold Indicator Flag: ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.threshold_indicator_flag(ptnr_tax_line_index));
2674: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2675: ' Exempt Certificate Number: ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.exempt_certificate_number(ptnr_tax_line_index));
2676: END IF;
2677:
2678: -- Added the following code to check whether Global Attributes are initialized.

Line 2724: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2720: l_error_buffer);
2721:
2722: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2723: IF (g_level_statement >= g_current_runtime_level ) THEN
2724: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2725: 'Incorrect return_status after calling ZX_TDS_UTILITIES_PKG.get_tax_cache_info for tax '
2726: || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index)
2727: || 'RETURN_STATUS = ' || l_return_status);
2728: END IF;

Line 3065: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

3061: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.establishment_id(i)
3062: from dual where line_level_action_tbl(i) <> 'DELETE';
3063: EXCEPTION WHEN OTHERS THEN
3064: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3065: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3066: ' Exception while Populate zx_detail_tax_lines_gt: ' || sqlerrm);
3067: END IF;
3068: END;
3069:

Line 3095: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

3091:
3092: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3093: x_return_status := l_return_status;
3094: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3095: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3096: ' RETURN_STATUS = ' || x_return_status);
3097: END IF;
3098: RETURN;
3099: END IF;

Line 3109: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME ||': '||l_api_name||'(-)'||' RETURN_STATUS = ' || x_return_status);

3105: partner_migrated_flag_tbl.DELETE;
3106: ZX_PTNR_SRVC_INTGRTN_PKG.G_TAX_CURRENCIES_TBL.DELETE;
3107:
3108: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3109: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME ||': '||l_api_name||'(-)'||' RETURN_STATUS = ' || x_return_status);
3110: END IF;
3111:
3112: EXCEPTION
3113: WHEN OTHERS THEN

Line 3116: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

3112: EXCEPTION
3113: WHEN OTHERS THEN
3114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3115: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
3116: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
3117: END IF;
3118: END ptnr_post_processing_calc_tax;
3119:
3120:

Line 3151: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

3147: l_return_status VARCHAR2(1);
3148:
3149: BEGIN
3150: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3151: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
3152: END IF;
3153:
3154: --Set the return status to Success
3155: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3190: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'The tax partner cannot modify an overridden tax rate');

3186: ELSIF l_last_manual_entry = 'TAX_RATE' THEN
3187: IF ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).tax_rate_percentage is not null THEN
3188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --tax rate cannot be modified
3189: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3190: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'The tax partner cannot modify an overridden tax rate');
3191: END IF;
3192: ELSIF ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).taxable_amount is not null THEN
3193: UPDATE ZX_LINES
3194: SET taxable_amt = ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).taxable_amount

Line 3215: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

3211: END IF; -- G_PUB_SRVC = OVERRIDE_TAX
3212: END LOOP;
3213:
3214: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3215: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
3216: G_PKG_NAME ||': '||l_api_name||'(-)'||' RETURN_STATUS = ' || x_return_status);
3217: END IF;
3218:
3219: EXCEPTION

Line 3223: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

3219: EXCEPTION
3220: WHEN OTHERS THEN
3221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3222: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
3223: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
3224: END IF;
3225: END ptnr_post_proc_sync_tax;
3226:
3227: FUNCTION get_incl_tax_amt (

Line 3241: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

3237: l_api_name CONSTANT VARCHAR2(30) := 'GET_INCL_TAX_AMT';
3238: l_tax_amount NUMBER;
3239: BEGIN
3240: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3241: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
3242: END IF;
3243:
3244: SELECT /*+ INDEX (TAX ZX_LINES_U1) */
3245: sum(nvl(tax.tax_amt,0))

Line 3258: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME ||': '||l_api_name||'(-)');

3254: AND tax_amt_included_flag = 'Y'
3255: AND tax_provider_id <> p_tax_provider_id;
3256:
3257: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3258: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME ||': '||l_api_name||'(-)');
3259: END IF;
3260:
3261: RETURN l_tax_amount;
3262:

Line 3266: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME ||': '||l_api_name||'(-)');

3262:
3263: EXCEPTION
3264: WHEN OTHERS THEN
3265: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3266: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME ||': '||l_api_name||'(-)');
3267: END IF;
3268: RETURN 0;
3269: END get_incl_tax_amt;
3270: