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.JG_ZZ_VAT_SELECTION_PKG dependencies on FND_LOG

Line 11: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

7:
8: l_version_info VARCHAR2(90) := NULL;
9: C_LINES_PER_COMMIT CONSTANT NUMBER := 1000;
10:
11: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
15: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 12: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

8: l_version_info VARCHAR2(90) := NULL;
9: C_LINES_PER_COMMIT CONSTANT NUMBER := 1000;
10:
11: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
15: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

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

9: C_LINES_PER_COMMIT CONSTANT NUMBER := 1000;
10:
11: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
15: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
17: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 14: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

10:
11: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
15: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
17: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: g_error_buffer VARCHAR2(100);

Line 15: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

11: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
15: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
17: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: g_error_buffer VARCHAR2(100);
19: g_debug_flag VARCHAR2(1);

Line 16: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

12: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
15: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
17: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: g_error_buffer VARCHAR2(100);
19: g_debug_flag VARCHAR2(1);
20: g_pkg_name CONSTANT VARCHAR2(30) := 'JG_ZZ_VAT_SELECTION_PKG';

Line 17: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

13: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
15: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
17: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: g_error_buffer VARCHAR2(100);
19: g_debug_flag VARCHAR2(1);
20: g_pkg_name CONSTANT VARCHAR2(30) := 'JG_ZZ_VAT_SELECTION_PKG';
21: g_module_name CONSTANT VARCHAR2(30) := 'JG.EMEA_VAT.SELECTION_PROCESS';

Line 428: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

424:
425: BEGIN
426:
427: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
428: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
429: G_PKG_NAME||': '||l_api_name||'()+');
430: END IF;
431:
432: IF p_debug_flag = 'Y' THEN

Line 468: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||

464: | entity in the table if it does not exists and returns the vat |
465: | reporting entity identifier. |
466: +--------------------------------------------------------------------*/
467: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
468: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
469: 'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'.BEGIN',
470: G_PKG_NAME||': '||'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'
471: ||'()+');
472: END IF;

Line 486: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||

482: xv_return_message => l_return_message
483: );
484:
485: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
486: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
487: 'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'.END',
488: G_PKG_NAME||': '||'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'()-'
489: );
490: END IF;

Line 550: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||

546: | (7) Inserts status information of the Selection process into the |
547: | jg_zz_vat_rep_status table. |
548: +--------------------------------------------------------------------*/
549: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
550: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
551: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'.BEGIN',
552: G_PKG_NAME||': '||
553: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'()+');
554: END IF;

Line 569: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||

565: xv_return_message => l_return_message
566: );
567:
568: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
569: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
570: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'.END',
571: G_PKG_NAME||': ' ||
572: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'()-');
573: END IF;

Line 728: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||

724: -- post_process_update
725: -- Call the utility API to update selection_process columns of
726: -- jg_zz_vat_rep_status table by passing proper values.
727: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
728: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
729: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'.BEGIN',
730: G_PKG_NAME||': '||
731: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'()+');
732: END IF;

Line 753: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||

749: xv_return_message => l_return_message
750: );
751:
752: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
753: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
754: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'.END',
755: G_PKG_NAME||': ' ||'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'()-');
756: END IF;
757:

Line 772: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

768: END IF;
769:
770:
771: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
772: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
773: ' RETURN_STATUS = ' || retcode);
774: END IF;
775:
776: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

773: ' RETURN_STATUS = ' || retcode);
774: END IF;
775:
776: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
777: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
778: G_PKG_NAME||': ' ||l_api_name||'()-');
779: END IF;
780:
781: IF p_debug_flag = 'Y' THEN

Line 795: FND_LOG.STRING(g_level_unexpected,

791: END IF;
792:
793: FND_MSG_PUB.Add;
794: IF (g_level_unexpected >= g_current_runtime_level ) THEN
795: FND_LOG.STRING(g_level_unexpected,
796: G_MODULE_NAME||l_api_name,
797: g_error_buffer);
798: END IF;
799:

Line 829: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

825: IS
826: l_api_name CONSTANT VARCHAR2(30) := 'PURGE_TAX_DATA';
827: BEGIN
828: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
829: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
830: G_PKG_NAME||': '||l_api_name||'()+');
831: END IF;
832:
833: IF g_debug_flag = 'Y' THEN

Line 844: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

840: delete from JG_ZZ_VAT_TRX_DETAILS
841: where reporting_Status_id = p_reporting_status_id;
842:
843: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
844: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
845: ' RETURN_STATUS = ' || x_return_status);
846: END IF;
847:
848: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

845: ' RETURN_STATUS = ' || x_return_status);
846: END IF;
847:
848: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
849: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
850: G_PKG_NAME||': ' ||l_api_name||'()-');
851: END IF;
852:
853: IF g_debug_flag = 'Y' THEN

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

863: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
864: END IF;
865:
866: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
867: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
868: END IF;
869: RETURN;
870: END PURGE_TAX_DATA;
871:

Line 951: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

947: l_api_name CONSTANT VARCHAR2(30) := 'INITIALIZE';
948:
949: BEGIN
950: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
951: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
952: G_PKG_NAME||': '||l_api_name||'()+');
953: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
954: 'P_REPORTING_LEVEL = ' || P_REPORTING_LEVEL);
955: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 953: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

949: BEGIN
950: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
951: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
952: G_PKG_NAME||': '||l_api_name||'()+');
953: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
954: 'P_REPORTING_LEVEL = ' || P_REPORTING_LEVEL);
955: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
956: 'P_LEDGER = ' || P_LEDGER);
957: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 955: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

951: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
952: G_PKG_NAME||': '||l_api_name||'()+');
953: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
954: 'P_REPORTING_LEVEL = ' || P_REPORTING_LEVEL);
955: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
956: 'P_LEDGER = ' || P_LEDGER);
957: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
958: 'P_BSV = '|| P_BSV);
959: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 957: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

953: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
954: 'P_REPORTING_LEVEL = ' || P_REPORTING_LEVEL);
955: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
956: 'P_LEDGER = ' || P_LEDGER);
957: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
958: 'P_BSV = '|| P_BSV);
959: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
960: ' P_VAT_REPORTING_ENTITY_ID = ' || P_VAT_REPORTING_ENTITY_ID);
961: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 959: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

955: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
956: 'P_LEDGER = ' || P_LEDGER);
957: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
958: 'P_BSV = '|| P_BSV);
959: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
960: ' P_VAT_REPORTING_ENTITY_ID = ' || P_VAT_REPORTING_ENTITY_ID);
961: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
962: ' P_TAX_PERIOD = ' || P_TAX_PERIOD);
963: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 961: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

957: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
958: 'P_BSV = '|| P_BSV);
959: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
960: ' P_VAT_REPORTING_ENTITY_ID = ' || P_VAT_REPORTING_ENTITY_ID);
961: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
962: ' P_TAX_PERIOD = ' || P_TAX_PERIOD);
963: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
964: ' P_SOURCE = '|| P_SOURCE);
965: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 963: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

959: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
960: ' P_VAT_REPORTING_ENTITY_ID = ' || P_VAT_REPORTING_ENTITY_ID);
961: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
962: ' P_TAX_PERIOD = ' || P_TAX_PERIOD);
963: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
964: ' P_SOURCE = '|| P_SOURCE);
965: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
966: ' P_ACCTD_UNACCTD = '|| P_ACCTD_UNACCTD);
967: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 965: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

961: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
962: ' P_TAX_PERIOD = ' || P_TAX_PERIOD);
963: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
964: ' P_SOURCE = '|| P_SOURCE);
965: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
966: ' P_ACCTD_UNACCTD = '|| P_ACCTD_UNACCTD);
967: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
968: ' P_DEBUG_FLAG = '|| P_DEBUG_FLAG);
969: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 967: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

963: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
964: ' P_SOURCE = '|| P_SOURCE);
965: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
966: ' P_ACCTD_UNACCTD = '|| P_ACCTD_UNACCTD);
967: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
968: ' P_DEBUG_FLAG = '|| P_DEBUG_FLAG);
969: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
970: 'P_ERRBUF = '||P_ERRBUF);
971: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 969: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

965: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
966: ' P_ACCTD_UNACCTD = '|| P_ACCTD_UNACCTD);
967: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
968: ' P_DEBUG_FLAG = '|| P_DEBUG_FLAG);
969: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
970: 'P_ERRBUF = '||P_ERRBUF);
971: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
972: 'P_RETCODE = '||P_RETCODE);
973: END IF;

Line 971: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

967: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
968: ' P_DEBUG_FLAG = '|| P_DEBUG_FLAG);
969: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
970: 'P_ERRBUF = '||P_ERRBUF);
971: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
972: 'P_RETCODE = '||P_RETCODE);
973: END IF;
974:
975: IF p_debug_flag = 'Y' THEN

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

1004: g_conc_program_id := nvl(fnd_profile.value('CONC_PROGRAM_ID'),1);
1005: g_conc_login_id := nvl(fnd_profile.value('CONC_LOGIN_ID'),1);
1006:
1007: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1008: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1009: G_PKG_NAME||': ' ||l_api_name||'()-');
1010: END IF;
1011:
1012: IF p_debug_flag = 'Y' THEN

Line 1020: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name, g_error_buffer);

1016: EXCEPTION
1017: WHEN OTHERS THEN
1018: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1019: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1020: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name, g_error_buffer);
1021: END IF;
1022:
1023: IF p_debug_flag = 'Y' THEN
1024: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

Line 1061: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

1057: l_api_name CONSTANT VARCHAR2(30) := 'GET_PERIOD_DATE_RANGE';
1058:
1059: BEGIN
1060: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1061: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
1062: G_PKG_NAME||': '||l_api_name||'()+');
1063: END IF;
1064:
1065: /*Set the return status to Success */

Line 1082: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

1078: WHERE period_set_name = p_calendar_name
1079: AND period_name = p_period;
1080:
1081: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1082: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1083: 'TAX INVOICE DATE LOW = ' ||
1084: to_char( p_global_variables_rec.tax_invoice_date_low) );
1085: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1086: 'TAX INVOICE DATE HIGH = ' ||

Line 1085: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

1081: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1082: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1083: 'TAX INVOICE DATE LOW = ' ||
1084: to_char( p_global_variables_rec.tax_invoice_date_low) );
1085: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1086: 'TAX INVOICE DATE HIGH = ' ||
1087: to_char( p_global_variables_rec.tax_invoice_date_high) );
1088: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1089: ' RETURN_STATUS = ' || x_return_status);

Line 1088: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

1084: to_char( p_global_variables_rec.tax_invoice_date_low) );
1085: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1086: 'TAX INVOICE DATE HIGH = ' ||
1087: to_char( p_global_variables_rec.tax_invoice_date_high) );
1088: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1089: ' RETURN_STATUS = ' || x_return_status);
1090: END IF;
1091:
1092: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1089: ' RETURN_STATUS = ' || x_return_status);
1090: END IF;
1091:
1092: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1093: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1094: G_PKG_NAME||': ' ||l_api_name||'()-');
1095: END IF;
1096:
1097: IF g_debug_flag = 'Y' THEN

Line 1112: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1108: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
1109: END IF;
1110:
1111: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1112: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1113: END IF;
1114: p_global_variables_rec.retcode := 2;
1115: RETURN;
1116: END get_period_date_range;

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

1148: l_api_name CONSTANT VARCHAR2(30) := 'GET_VAT_REPORTING_DETAILS';
1149:
1150: BEGIN
1151: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1152: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1153: END IF;
1154:
1155: /*Set the return status to Success */
1156: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1178: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

1174: vat_reporting_entity_id) = p_vat_reporting_entity_id
1175: AND entity_type_code = 'LEGAL';
1176:
1177: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1178: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1179: 'LEGAL ENTITY ID = ' || p_global_variables_rec.legal_entity_id);
1180: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1181: 'TAX REGIME CODE = ' || p_global_variables_rec.tax_regime_code);
1182: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 1180: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

1176:
1177: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1178: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1179: 'LEGAL ENTITY ID = ' || p_global_variables_rec.legal_entity_id);
1180: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1181: 'TAX REGIME CODE = ' || p_global_variables_rec.tax_regime_code);
1182: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1183: 'TAX REG NUM = '|| p_global_variables_rec.tax_registration_number);
1184: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 1182: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

1178: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1179: 'LEGAL ENTITY ID = ' || p_global_variables_rec.legal_entity_id);
1180: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1181: 'TAX REGIME CODE = ' || p_global_variables_rec.tax_regime_code);
1182: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1183: 'TAX REG NUM = '|| p_global_variables_rec.tax_registration_number);
1184: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1185: 'TAX CALENDAR NAME = '|| p_global_variables_rec.tax_calendar_name);
1186: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 1184: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

1180: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1181: 'TAX REGIME CODE = ' || p_global_variables_rec.tax_regime_code);
1182: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1183: 'TAX REG NUM = '|| p_global_variables_rec.tax_registration_number);
1184: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1185: 'TAX CALENDAR NAME = '|| p_global_variables_rec.tax_calendar_name);
1186: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1187: 'DRIVING_DATE_CODE = '|| p_global_variables_rec.driving_date_code);
1188: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 1186: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

1182: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1183: 'TAX REG NUM = '|| p_global_variables_rec.tax_registration_number);
1184: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1185: 'TAX CALENDAR NAME = '|| p_global_variables_rec.tax_calendar_name);
1186: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1187: 'DRIVING_DATE_CODE = '|| p_global_variables_rec.driving_date_code);
1188: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1189: ' RETURN_STATUS = ' || x_return_status);
1190: END IF;

Line 1188: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

1184: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1185: 'TAX CALENDAR NAME = '|| p_global_variables_rec.tax_calendar_name);
1186: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1187: 'DRIVING_DATE_CODE = '|| p_global_variables_rec.driving_date_code);
1188: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1189: ' RETURN_STATUS = ' || x_return_status);
1190: END IF;
1191:
1192: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1189: ' RETURN_STATUS = ' || x_return_status);
1190: END IF;
1191:
1192: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1193: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1194: G_PKG_NAME||': ' ||l_api_name||'()-');
1195: END IF;
1196:
1197: IF g_debug_flag = 'Y' THEN

Line 1212: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1208: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
1209: END IF;
1210:
1211: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1212: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1213: END IF;
1214: p_global_variables_rec.retcode := 2;
1215: RETURN;
1216: END get_VAT_reporting_details;

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

1240:
1241: BEGIN
1242:
1243: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1244: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1245: END IF;
1246:
1247: IF g_debug_flag = 'Y' THEN
1248: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');

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

1267: RETURN TRUE;
1268: END IF;
1269:
1270: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1271: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1272: G_PKG_NAME||': ' ||l_api_name||'()-');
1273: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1274: 'Last Processed Date : ' || to_char(l_last_processed_date));
1275: END IF;

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

1269:
1270: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1271: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1272: G_PKG_NAME||': ' ||l_api_name||'()-');
1273: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1274: 'Last Processed Date : ' || to_char(l_last_processed_date));
1275: END IF;
1276:
1277: IF g_debug_flag = 'Y' THEN

Line 1290: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1286: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
1287: END IF;
1288:
1289: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1290: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1291: END IF;
1292: RETURN NULL;
1293: END is_prev_period_open;
1294:

Line 1322: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

1318: l_api_name CONSTANT VARCHAR2(30) := 'INIT_GT_VARIABLES';
1319:
1320: BEGIN
1321: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1322: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
1323: G_PKG_NAME||': '||l_api_name||'()+');
1324:
1325: END IF;
1326:

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

1556: gt_def_rec_settlement_opt_code.delete;
1557:
1558:
1559: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1560: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1561: G_PKG_NAME||': ' ||l_api_name||'()-');
1562: END IF;
1563:
1564: IF g_debug_flag = 'Y' THEN

Line 1572: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1568: EXCEPTION
1569: WHEN OTHERS THEN
1570: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1571: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1572: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1573: END IF;
1574:
1575: IF g_debug_flag = 'Y' THEN
1576: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

Line 1626: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

1622: l_tax_invoice_date_low DATE := P_GLOBAL_VARIABLES_REC.tax_invoice_date_low;
1623: BEGIN
1624:
1625: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1626: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
1627: G_PKG_NAME||': '||l_api_name||'()+');
1628: END IF;
1629:
1630: IF g_debug_flag = 'Y' THEN

Line 2121: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2117: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
2118: END IF;
2119:
2120: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2121: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2122: END IF;
2123: p_global_variables_rec.retcode := 2;
2124: RETURN;
2125: END fetch_tax_data;

Line 2158: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name ,

2154: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_TAX_DATA';
2155: BEGIN
2156:
2157: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2158: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name ,
2159: G_PKG_NAME||': '||l_api_name||'(+)');
2160: END IF;
2161:
2162: IF g_debug_flag = 'Y' THEN

Line 2170: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name ,

2166: l_count := GT_TRX_ID.COUNT;
2167:
2168:
2169: IF (g_level_procedure >= g_current_runtime_level ) THEN
2170: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name ,
2171: ' Record Count = ' ||to_char(l_count));
2172: END IF;
2173:
2174: if g_selection_process_id is null then

Line 2648: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name ,

2644: );
2645:
2646:
2647: IF (g_level_procedure >= g_current_runtime_level ) THEN
2648: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name ,
2649: ' Record successfully inserted = ' ||to_char(l_count));
2650: END IF;
2651:
2652: IF g_debug_flag = 'Y' THEN

Line 2667: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2663: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
2664: END IF;
2665:
2666: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2667: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2668: END IF;
2669: --p_global_variables_rec.retcode := 2;
2670: RETURN;
2671:

Line 2770: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

2766: --Bug6835573
2767:
2768: BEGIN
2769: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2770: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
2771: G_PKG_NAME||': '||l_api_name||'()+');
2772: END IF;
2773:
2774: IF g_debug_flag = 'Y' THEN

Line 2856: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2852: END IF;
2853:
2854: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2855:
2856: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2857: 'P_REPORTING_LEVEL = ' || l_reporting_level );
2858: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2859: 'P_REPORTING_CONTEXT = ' || l_reporting_context );
2860: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 2858: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2854: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2855:
2856: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2857: 'P_REPORTING_LEVEL = ' || l_reporting_level );
2858: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2859: 'P_REPORTING_CONTEXT = ' || l_reporting_context );
2860: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2861: 'P_LEGAL_ENTITY_ID = '|| l_legal_entity_id);
2862: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 2860: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2856: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2857: 'P_REPORTING_LEVEL = ' || l_reporting_level );
2858: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2859: 'P_REPORTING_CONTEXT = ' || l_reporting_context );
2860: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2861: 'P_LEGAL_ENTITY_ID = '|| l_legal_entity_id);
2862: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2863: ' P_PRODUCT = ' || p_global_variables_rec.SOURCE );
2864: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 2862: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2858: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2859: 'P_REPORTING_CONTEXT = ' || l_reporting_context );
2860: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2861: 'P_LEGAL_ENTITY_ID = '|| l_legal_entity_id);
2862: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2863: ' P_PRODUCT = ' || p_global_variables_rec.SOURCE );
2864: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2865: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
2866: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 2864: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2860: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2861: 'P_LEGAL_ENTITY_ID = '|| l_legal_entity_id);
2862: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2863: ' P_PRODUCT = ' || p_global_variables_rec.SOURCE );
2864: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2865: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
2866: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2867: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
2868: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 2866: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2862: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2863: ' P_PRODUCT = ' || p_global_variables_rec.SOURCE );
2864: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2865: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
2866: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2867: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
2868: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2869: ' P_TRX_DATE_LOW = '|| l_trx_date_low );
2870: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 2868: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2864: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2865: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
2866: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2867: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
2868: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2869: ' P_TRX_DATE_LOW = '|| l_trx_date_low );
2870: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2871: ' P_TRX_DATE_HIGH = '|| l_trx_date_high );
2872: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 2870: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2866: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2867: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
2868: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2869: ' P_TRX_DATE_LOW = '|| l_trx_date_low );
2870: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2871: ' P_TRX_DATE_HIGH = '|| l_trx_date_high );
2872: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2873: ' P_GL_DATE_LOW = '|| l_gl_date_low );
2874: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 2872: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2868: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2869: ' P_TRX_DATE_LOW = '|| l_trx_date_low );
2870: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2871: ' P_TRX_DATE_HIGH = '|| l_trx_date_high );
2872: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2873: ' P_GL_DATE_LOW = '|| l_gl_date_low );
2874: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2875: ' P_GL_DATE_HIGH = '|| l_gl_date_high );
2876: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 2874: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2870: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2871: ' P_TRX_DATE_HIGH = '|| l_trx_date_high );
2872: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2873: ' P_GL_DATE_LOW = '|| l_gl_date_low );
2874: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2875: ' P_GL_DATE_HIGH = '|| l_gl_date_high );
2876: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2877: ' P_TAX_INVOICE_DATE_LOW = '|| l_tax_invoice_date_low );
2878: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 2876: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2872: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2873: ' P_GL_DATE_LOW = '|| l_gl_date_low );
2874: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2875: ' P_GL_DATE_HIGH = '|| l_gl_date_high );
2876: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2877: ' P_TAX_INVOICE_DATE_LOW = '|| l_tax_invoice_date_low );
2878: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2879: ' P_TAX_INVOICE_DATE_HIGH = '|| l_tax_invoice_date_high );
2880: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 2878: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2874: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2875: ' P_GL_DATE_HIGH = '|| l_gl_date_high );
2876: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2877: ' P_TAX_INVOICE_DATE_LOW = '|| l_tax_invoice_date_low );
2878: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2879: ' P_TAX_INVOICE_DATE_HIGH = '|| l_tax_invoice_date_high );
2880: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2881: ' P_ACCOUNTING_STATUS = '|| l_accounting_status );
2882: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 2880: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2876: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2877: ' P_TAX_INVOICE_DATE_LOW = '|| l_tax_invoice_date_low );
2878: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2879: ' P_TAX_INVOICE_DATE_HIGH = '|| l_tax_invoice_date_high );
2880: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2881: ' P_ACCOUNTING_STATUS = '|| l_accounting_status );
2882: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2883: ' P_INCLUDE_ACCOUNTING_SEGMENTS = '|| l_include_acc_segments );
2884: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 2882: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2878: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2879: ' P_TAX_INVOICE_DATE_HIGH = '|| l_tax_invoice_date_high );
2880: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2881: ' P_ACCOUNTING_STATUS = '|| l_accounting_status );
2882: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2883: ' P_INCLUDE_ACCOUNTING_SEGMENTS = '|| l_include_acc_segments );
2884: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2885: ' P_TAX_REGIME_CODE = '|| p_global_variables_rec.TAX_REGIME_CODE);
2886: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 2884: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2880: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2881: ' P_ACCOUNTING_STATUS = '|| l_accounting_status );
2882: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2883: ' P_INCLUDE_ACCOUNTING_SEGMENTS = '|| l_include_acc_segments );
2884: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2885: ' P_TAX_REGIME_CODE = '|| p_global_variables_rec.TAX_REGIME_CODE);
2886: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2887: ' P_REPORTED_STATUS = '|| l_reported_status); --Bug6835573
2888:

Line 2886: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2882: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2883: ' P_INCLUDE_ACCOUNTING_SEGMENTS = '|| l_include_acc_segments );
2884: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2885: ' P_TAX_REGIME_CODE = '|| p_global_variables_rec.TAX_REGIME_CODE);
2886: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2887: ' P_REPORTED_STATUS = '|| l_reported_status); --Bug6835573
2888:
2889:
2890: END IF;

Line 2973: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2969: P_RETCODE => p_global_variables_rec.RETCODE,
2970: P_GL_OR_TRX_DATE_FILTER => p_global_variables_rec.gl_or_trx_date_filter);
2971:
2972: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2973: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2974: ' RETURN_STATUS = ' || p_global_variables_rec.RETCODE);
2975: END IF;
2976:
2977: -- Filtering based on Balancing Segment Value.

Line 3007: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

3003: WHERE ACT.request_id = x_request_id
3004: AND ACT.trx_arap_balancing_segment <> p_global_variables_rec.BSV;
3005:
3006: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3007: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3008: ' Records filtered based on bsv');
3009: END IF;
3010:
3011:

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

3011:
3012: END IF;
3013:
3014: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3015: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
3016: G_PKG_NAME||': ' ||l_api_name||'()-');
3017: END IF;
3018:
3019: IF g_debug_flag = 'Y' THEN

Line 3033: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3029: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
3030: END IF;
3031:
3032: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3033: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3034: END IF;
3035: RETURN;
3036: END call_TRL;
3037:

Line 3078: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

3074: l_return_message VARCHAR2(2000);
3075:
3076: BEGIN
3077: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3078: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
3079: G_PKG_NAME||': '||l_api_name||'()+');
3080: END IF;
3081:
3082: IF g_debug_flag = 'Y' THEN

Line 3159: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

3155: RETURN;
3156: END IF;
3157:
3158: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3159: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3160: ' RETURN_STATUS = ' || p_global_variables_rec.RETCODE);
3161: END IF;
3162:
3163: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

3160: ' RETURN_STATUS = ' || p_global_variables_rec.RETCODE);
3161: END IF;
3162:
3163: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3164: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END'
3165: ,G_PKG_NAME||': ' ||l_api_name||'()-');
3166: END IF;
3167:
3168: IF g_debug_flag = 'Y' THEN

Line 3182: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3178: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
3179: END IF;
3180:
3181: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3182: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3183: END IF;
3184: p_global_variables_rec.retcode := 2;
3185: RETURN;
3186: END control_intersecting_domains;

Line 3302: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

3298:
3299: BEGIN
3300:
3301: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3302: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
3303: G_PKG_NAME||': '||l_api_name||'()+');
3304: END IF;
3305:
3306: IF g_debug_flag = 'Y' THEN

Line 3360: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, l_msg);

3356:
3357: l_msg := l_count || ' Transactions are Finally Reported' ;
3358:
3359: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3360: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, l_msg);
3361: END IF;
3362:
3363: FND_MESSAGE.SET_NAME('JG','JG_ZZ_VAT_TRX_OVERLAPPING');
3364: FND_MESSAGE.SET_TOKEN('LOG_FILE', lv_filename );

Line 3448: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, xv_return_message);

3444:
3445: xv_return_status := fnd_api.g_ret_sts_success;
3446: xv_return_message := 'None of the transactions are finally reported';
3447: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3448: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, xv_return_message);
3449: END IF;
3450:
3451: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3452: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

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

3448: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, xv_return_message);
3449: END IF;
3450:
3451: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3452: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
3453: G_PKG_NAME||': ' || l_api_name||'()-');
3454: END IF;
3455:
3456: IF g_debug_flag = 'Y' THEN

Line 3468: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3464: xv_return_message := 'Unexpected error occurred in the
3465: procedure PURGE_REPORT_FINALREP:' || SQLCODE || ' ' ||
3466: SUBSTR(SQLERRM,1,80) ;
3467: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3468: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3469: END IF;
3470: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3471:
3472: IF g_debug_flag = 'Y' THEN

Line 3509: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

3505:
3506: BEGIN
3507:
3508: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3509: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
3510: G_PKG_NAME||': '||l_api_name||'()+');
3511: END IF;
3512:
3513:

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

3521: utl_file.put_line(v_myfilehandle,text_to_write);
3522: utl_file.fclose(v_myfilehandle);
3523:
3524: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3525: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
3526: G_PKG_NAME||': ' || l_api_name||'()-');
3527: END IF;
3528:
3529: IF g_debug_flag = 'Y' THEN

Line 3537: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3533:
3534: EXCEPTION
3535: WHEN OTHERS THEN
3536: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3537: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3538: END IF;
3539: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3540:
3541: IF g_debug_flag = 'Y' THEN

Line 3672: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

3668:
3669: BEGIN
3670:
3671: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3672: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
3673: G_PKG_NAME||': '||l_api_name||'()+');
3674: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3675: 'P_LEGAL_ENTITY_ID = '|| p_legal_entity_id);
3676: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 3674: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

3670:
3671: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3672: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
3673: G_PKG_NAME||': '||l_api_name||'()+');
3674: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3675: 'P_LEGAL_ENTITY_ID = '|| p_legal_entity_id);
3676: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3677: 'P_LEDGER_ID = '|| p_ledger_id);
3678: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 3676: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

3672: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
3673: G_PKG_NAME||': '||l_api_name||'()+');
3674: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3675: 'P_LEGAL_ENTITY_ID = '|| p_legal_entity_id);
3676: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3677: 'P_LEDGER_ID = '|| p_ledger_id);
3678: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3679: 'P_END_DATE = '|| p_end_date);
3680: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 3678: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

3674: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3675: 'P_LEGAL_ENTITY_ID = '|| p_legal_entity_id);
3676: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3677: 'P_LEDGER_ID = '|| p_ledger_id);
3678: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3679: 'P_END_DATE = '|| p_end_date);
3680: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3681: ' P_SOURCE = ' || p_source);
3682: END IF;

Line 3680: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

3676: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3677: 'P_LEDGER_ID = '|| p_ledger_id);
3678: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3679: 'P_END_DATE = '|| p_end_date);
3680: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3681: ' P_SOURCE = ' || p_source);
3682: END IF;
3683:
3684: IF g_debug_flag = 'Y' THEN

Line 3709: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

3705: /*===== Start of Payables Tax Date Maintenance Program ==============*/
3706: BEGIN
3707:
3708: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3709: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3710: 'At the Beginning of Payables Tax Date Maintenance Program');
3711: END IF;
3712:
3713: OPEN c_primary_acct_method (l_ledger_id);

Line 3743: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

3739:
3740: -- Print the Invoices for which the tax date is getting
3741: -- updated in the log file
3742: IF l_num = 0 AND ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3743: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3744: 'The tax date has been changed to cleared date for the
3745: following invoices');
3746: l_num := 1;
3747: END IF;

Line 3750: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

3746: l_num := 1;
3747: END IF;
3748:
3749: IF l_num = 1 AND ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3750: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3751: 'Invoice num :' || c_inv_null_tax_date_rec.invoice_num ||
3752: -- ' ' ||'Original Tax Date :'|| to_char(c_inv_null_tax_date_rec.tax_invoice_recording_date, 'DD-MON-YYYY')
3753: --||' '|| 'Changed Tax Date :' || to_char(c_inv_null_tax_date_rec.cleared_date, 'DD-MON-YYYY'));
3754: ' ' || 'Actual Tax Date :'|| c_inv_null_tax_date_rec.tax_invoice_recording_date

Line 3771: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,

3767: CLOSE c_inv_null_tax_date ;
3768: END IF;
3769:
3770: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3771: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,
3772: 'Unable to update the Tax_Invoice_Date in
3773: PAYABLES_MAINTENANCE PROGRAM' || ' error_msg = '
3774: || sqlcode || ':' || SUBSTR(SQLERRM, 1, 80));
3775: END IF;

Line 3792: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

3788: BEGIN
3789:
3790: l_num := 0;
3791: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3792: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3793: 'Begining of the Receivables Tax date manintenance program');
3794: l_num := 1;
3795: END IF;
3796:

Line 3801: FND_LOG.STRING ( G_LEVEL_EXCEPTION, G_MODULE_NAME || l_api_name,

3797: FOR c_cust_trx_rec IN c_cust_trx
3798: LOOP
3799: -- Write the information into log file
3800: IF l_num = 1 AND (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3801: FND_LOG.STRING ( G_LEVEL_EXCEPTION, G_MODULE_NAME || l_api_name,
3802: ' Trx Id ' || c_cust_trx_rec.customer_trx_id ||
3803: ' Actual tax date ' || c_cust_trx_rec.tax_invoice_date ||
3804: ' Updated tax date ' || c_cust_trx_rec.apply_date );
3805: END IF;

Line 3818: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,

3814: AND event_class_code = c_cust_trx_rec.event_class_code;
3815: EXCEPTION
3816: WHEN OTHERS THEN
3817: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3818: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,
3819: 'Error in updating Tax_Invoice_Date ' || ' error_msg = '
3820: || sqlcode || ':' || SUBSTR(SQLERRM, 1, 80));
3821: END IF;
3822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3828: FND_LOG.STRING ( G_LEVEL_EXCEPTION, G_MODULE_NAME || l_api_name, 'End of RECEIVABLES_MAINTENANCE PROGRAM' );

3824: END;
3825:
3826: END LOOP;
3827: IF l_num = 1 AND (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3828: FND_LOG.STRING ( G_LEVEL_EXCEPTION, G_MODULE_NAME || l_api_name, 'End of RECEIVABLES_MAINTENANCE PROGRAM' );
3829: END IF;
3830: EXCEPTION
3831: WHEN OTHERS THEN
3832: IF c_cust_trx%ISOPEN THEN

Line 3836: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,

3832: IF c_cust_trx%ISOPEN THEN
3833: CLOSE c_cust_trx ;
3834: END IF;
3835: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3836: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,
3837: 'Unable to update the Tax_Invoice_Date in
3838: RECEIVABLES_MAINTENANCE PROGRAM' || ' error_msg = '
3839: || sqlcode || ':' || SUBSTR(SQLERRM, 1, 80));
3840: END IF;

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

3844:
3845: END IF;
3846:
3847: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3848: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
3849: G_PKG_NAME||': ' ||l_api_name||'()-');
3850: END IF;
3851:
3852: IF g_debug_flag = 'Y' THEN

Line 3859: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,

3855:
3856: EXCEPTION
3857: WHEN OTHERS THEN
3858: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3859: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,
3860: 'Unable to update the Tax_Invoice_Date in TAX DATE MAINTENANCE PROGRAM'
3861: || ' error_msg = ' || sqlcode || ':' || SUBSTR(SQLERRM, 1, 80) );
3862: END IF;
3863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3885: -- g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3881: | |
3882: +=========================================================================*/
3883:
3884: BEGIN
3885: -- g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3886:
3887: select text into l_version_info from user_source
3888: where name = 'JG_ZZ_VAT_SELECTION_PKG'
3889: and text like '%Header:%'

Line 3894: FND_LOG.STRING(g_level_procedure, g_module_name||' version info :',

3890: and type = 'PACKAGE BODY'
3891: and line < 10;
3892:
3893: IF (g_level_procedure >= g_current_runtime_level ) THEN
3894: FND_LOG.STRING(g_level_procedure, g_module_name||' version info :',
3895: l_version_info);
3896: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',
3897: 'g_current_runtime_level :'||to_char(g_current_runtime_level));
3898: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',

Line 3896: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',

3892:
3893: IF (g_level_procedure >= g_current_runtime_level ) THEN
3894: FND_LOG.STRING(g_level_procedure, g_module_name||' version info :',
3895: l_version_info);
3896: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',
3897: 'g_current_runtime_level :'||to_char(g_current_runtime_level));
3898: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',
3899: 'g_level_procedure :'||to_char(g_level_procedure));
3900: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',

Line 3898: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',

3894: FND_LOG.STRING(g_level_procedure, g_module_name||' version info :',
3895: l_version_info);
3896: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',
3897: 'g_current_runtime_level :'||to_char(g_current_runtime_level));
3898: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',
3899: 'g_level_procedure :'||to_char(g_level_procedure));
3900: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',
3901: 'g_level_procedure :'||to_char(g_level_statement));
3902: END IF;

Line 3900: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',

3896: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',
3897: 'g_current_runtime_level :'||to_char(g_current_runtime_level));
3898: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',
3899: 'g_level_procedure :'||to_char(g_level_procedure));
3900: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',
3901: 'g_level_procedure :'||to_char(g_level_statement));
3902: END IF;
3903: END JG_ZZ_VAT_SELECTION_PKG;