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 453: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

449:
450: BEGIN
451:
452: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
453: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
454: G_PKG_NAME||': '||l_api_name||'()+');
455: END IF;
456:
457: IF p_debug_flag = 'Y' THEN

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

489: | entity in the table if it does not exists and returns the vat |
490: | reporting entity identifier. |
491: +--------------------------------------------------------------------*/
492: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
493: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
494: 'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'.BEGIN',
495: G_PKG_NAME||': '||'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'
496: ||'()+');
497: END IF;

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

507: xv_return_message => l_return_message
508: );
509:
510: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
511: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
512: 'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'.END',
513: G_PKG_NAME||': '||'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'()-'
514: );
515: END IF;

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

601: | (7) Inserts status information of the Selection process into the |
602: | jg_zz_vat_rep_status table. |
603: +--------------------------------------------------------------------*/
604: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
605: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
606: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'.BEGIN',
607: G_PKG_NAME||': '||
608: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'()+');
609: END IF;

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

620: xv_return_message => l_return_message
621: );
622:
623: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
624: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
625: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'.END',
626: G_PKG_NAME||': ' ||
627: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'()-');
628: END IF;

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

779: -- post_process_update
780: -- Call the utility API to update selection_process columns of
781: -- jg_zz_vat_rep_status table by passing proper values.
782: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
783: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
784: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'.BEGIN',
785: G_PKG_NAME||': '||
786: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'()+');
787: END IF;

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

804: xv_return_message => l_return_message
805: );
806:
807: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
808: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
809: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'.END',
810: G_PKG_NAME||': ' ||'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'()-');
811: END IF;
812:

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

823: END IF;
824:
825:
826: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
827: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
828: ' RETURN_STATUS = ' || retcode);
829: END IF;
830:
831: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

828: ' RETURN_STATUS = ' || retcode);
829: END IF;
830:
831: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
832: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
833: G_PKG_NAME||': ' ||l_api_name||'()-');
834: END IF;
835:
836: IF p_debug_flag = 'Y' THEN

Line 850: FND_LOG.STRING(g_level_unexpected,

846: END IF;
847:
848: FND_MSG_PUB.Add;
849: IF (g_level_unexpected >= g_current_runtime_level ) THEN
850: FND_LOG.STRING(g_level_unexpected,
851: G_MODULE_NAME||l_api_name,
852: g_error_buffer);
853: END IF;
854:

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

880: IS
881: l_api_name CONSTANT VARCHAR2(30) := 'PURGE_TAX_DATA';
882: BEGIN
883: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
884: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
885: G_PKG_NAME||': '||l_api_name||'()+');
886: END IF;
887:
888: IF g_debug_flag = 'Y' THEN

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

895: delete from JG_ZZ_VAT_TRX_DETAILS
896: where reporting_Status_id = p_reporting_status_id;
897:
898: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
899: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
900: ' RETURN_STATUS = ' || x_return_status);
901: END IF;
902:
903: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

900: ' RETURN_STATUS = ' || x_return_status);
901: END IF;
902:
903: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
904: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
905: G_PKG_NAME||': ' ||l_api_name||'()-');
906: END IF;
907:
908: IF g_debug_flag = 'Y' THEN

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

918: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
919: END IF;
920:
921: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
922: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
923: END IF;
924: RETURN;
925: END PURGE_TAX_DATA;
926:

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

1002: l_api_name CONSTANT VARCHAR2(30) := 'INITIALIZE';
1003:
1004: BEGIN
1005: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1006: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
1007: G_PKG_NAME||': '||l_api_name||'()+');
1008: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1009: 'P_REPORTING_LEVEL = ' || P_REPORTING_LEVEL);
1010: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

1004: BEGIN
1005: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1006: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
1007: G_PKG_NAME||': '||l_api_name||'()+');
1008: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1009: 'P_REPORTING_LEVEL = ' || P_REPORTING_LEVEL);
1010: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1011: 'P_LEDGER = ' || P_LEDGER);
1012: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

1006: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
1007: G_PKG_NAME||': '||l_api_name||'()+');
1008: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1009: 'P_REPORTING_LEVEL = ' || P_REPORTING_LEVEL);
1010: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1011: 'P_LEDGER = ' || P_LEDGER);
1012: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1013: 'P_BSV = '|| P_BSV);
1014: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

1008: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1009: 'P_REPORTING_LEVEL = ' || P_REPORTING_LEVEL);
1010: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1011: 'P_LEDGER = ' || P_LEDGER);
1012: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1013: 'P_BSV = '|| P_BSV);
1014: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1015: ' P_VAT_REPORTING_ENTITY_ID = ' || P_VAT_REPORTING_ENTITY_ID);
1016: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

1010: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1011: 'P_LEDGER = ' || P_LEDGER);
1012: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1013: 'P_BSV = '|| P_BSV);
1014: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1015: ' P_VAT_REPORTING_ENTITY_ID = ' || P_VAT_REPORTING_ENTITY_ID);
1016: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1017: ' P_TAX_PERIOD = ' || P_TAX_PERIOD);
1018: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

1012: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1013: 'P_BSV = '|| P_BSV);
1014: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1015: ' P_VAT_REPORTING_ENTITY_ID = ' || P_VAT_REPORTING_ENTITY_ID);
1016: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1017: ' P_TAX_PERIOD = ' || P_TAX_PERIOD);
1018: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1019: ' P_SOURCE = '|| P_SOURCE);
1020: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

1014: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1015: ' P_VAT_REPORTING_ENTITY_ID = ' || P_VAT_REPORTING_ENTITY_ID);
1016: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1017: ' P_TAX_PERIOD = ' || P_TAX_PERIOD);
1018: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1019: ' P_SOURCE = '|| P_SOURCE);
1020: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1021: ' P_ACCTD_UNACCTD = '|| P_ACCTD_UNACCTD);
1022: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

1016: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1017: ' P_TAX_PERIOD = ' || P_TAX_PERIOD);
1018: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1019: ' P_SOURCE = '|| P_SOURCE);
1020: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1021: ' P_ACCTD_UNACCTD = '|| P_ACCTD_UNACCTD);
1022: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1023: ' P_DEBUG_FLAG = '|| P_DEBUG_FLAG);
1024: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

1018: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1019: ' P_SOURCE = '|| P_SOURCE);
1020: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1021: ' P_ACCTD_UNACCTD = '|| P_ACCTD_UNACCTD);
1022: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1023: ' P_DEBUG_FLAG = '|| P_DEBUG_FLAG);
1024: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1025: 'P_ERRBUF = '||P_ERRBUF);
1026: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

1020: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1021: ' P_ACCTD_UNACCTD = '|| P_ACCTD_UNACCTD);
1022: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1023: ' P_DEBUG_FLAG = '|| P_DEBUG_FLAG);
1024: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1025: 'P_ERRBUF = '||P_ERRBUF);
1026: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1027: 'P_RETCODE = '||P_RETCODE);
1028: END IF;

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

1022: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1023: ' P_DEBUG_FLAG = '|| P_DEBUG_FLAG);
1024: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1025: 'P_ERRBUF = '||P_ERRBUF);
1026: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1027: 'P_RETCODE = '||P_RETCODE);
1028: END IF;
1029:
1030: IF p_debug_flag = 'Y' THEN

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

1059: g_conc_program_id := nvl(fnd_global.conc_program_id,1); --nvl(fnd_profile.value('CONC_PROGRAM_ID'),1);
1060: g_conc_login_id := nvl(fnd_global.conc_login_id,1); --nvl(fnd_profile.value('CONC_LOGIN_ID'),1);
1061:
1062: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1063: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1064: G_PKG_NAME||': ' ||l_api_name||'()-');
1065: END IF;
1066:
1067: IF p_debug_flag = 'Y' THEN

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

1071: EXCEPTION
1072: WHEN OTHERS THEN
1073: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1074: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1075: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name, g_error_buffer);
1076: END IF;
1077:
1078: IF p_debug_flag = 'Y' THEN
1079: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

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

1112: l_api_name CONSTANT VARCHAR2(30) := 'GET_PERIOD_DATE_RANGE';
1113:
1114: BEGIN
1115: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1116: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
1117: G_PKG_NAME||': '||l_api_name||'()+');
1118: END IF;
1119:
1120: /*Set the return status to Success */

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

1133: WHERE period_set_name = p_calendar_name
1134: AND period_name = p_period;
1135:
1136: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1137: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1138: 'TAX INVOICE DATE LOW = ' ||
1139: to_char( p_global_variables_rec.tax_invoice_date_low) );
1140: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1141: 'TAX INVOICE DATE HIGH = ' ||

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

1136: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1137: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1138: 'TAX INVOICE DATE LOW = ' ||
1139: to_char( p_global_variables_rec.tax_invoice_date_low) );
1140: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1141: 'TAX INVOICE DATE HIGH = ' ||
1142: to_char( p_global_variables_rec.tax_invoice_date_high) );
1143: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1144: ' RETURN_STATUS = ' || x_return_status);

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

1139: to_char( p_global_variables_rec.tax_invoice_date_low) );
1140: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1141: 'TAX INVOICE DATE HIGH = ' ||
1142: to_char( p_global_variables_rec.tax_invoice_date_high) );
1143: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1144: ' RETURN_STATUS = ' || x_return_status);
1145: END IF;
1146:
1147: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1144: ' RETURN_STATUS = ' || x_return_status);
1145: END IF;
1146:
1147: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1148: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1149: G_PKG_NAME||': ' ||l_api_name||'()-');
1150: END IF;
1151:
1152: IF g_debug_flag = 'Y' THEN

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

1163: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
1164: END IF;
1165:
1166: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1167: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1168: END IF;
1169: p_global_variables_rec.retcode := 2;
1170: RETURN;
1171: END get_period_date_range;

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

1203: l_api_name CONSTANT VARCHAR2(30) := 'GET_VAT_REPORTING_DETAILS';
1204:
1205: BEGIN
1206: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1207: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1208: END IF;
1209:
1210: /*Set the return status to Success */
1211: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1229: vat_reporting_entity_id) = p_vat_reporting_entity_id
1230: AND entity_type_code = 'LEGAL';
1231:
1232: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1233: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1234: 'LEGAL ENTITY ID = ' || p_global_variables_rec.legal_entity_id);
1235: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1236: 'TAX REGIME CODE = ' || p_global_variables_rec.tax_regime_code);
1237: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

1231:
1232: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1233: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1234: 'LEGAL ENTITY ID = ' || p_global_variables_rec.legal_entity_id);
1235: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1236: 'TAX REGIME CODE = ' || p_global_variables_rec.tax_regime_code);
1237: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1238: 'TAX REG NUM = '|| p_global_variables_rec.tax_registration_number);
1239: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

1233: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1234: 'LEGAL ENTITY ID = ' || p_global_variables_rec.legal_entity_id);
1235: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1236: 'TAX REGIME CODE = ' || p_global_variables_rec.tax_regime_code);
1237: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1238: 'TAX REG NUM = '|| p_global_variables_rec.tax_registration_number);
1239: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1240: 'TAX CALENDAR NAME = '|| p_global_variables_rec.tax_calendar_name);
1241: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

1235: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1236: 'TAX REGIME CODE = ' || p_global_variables_rec.tax_regime_code);
1237: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1238: 'TAX REG NUM = '|| p_global_variables_rec.tax_registration_number);
1239: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1240: 'TAX CALENDAR NAME = '|| p_global_variables_rec.tax_calendar_name);
1241: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1242: 'DRIVING_DATE_CODE = '|| p_global_variables_rec.driving_date_code);
1243: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

1237: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1238: 'TAX REG NUM = '|| p_global_variables_rec.tax_registration_number);
1239: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1240: 'TAX CALENDAR NAME = '|| p_global_variables_rec.tax_calendar_name);
1241: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1242: 'DRIVING_DATE_CODE = '|| p_global_variables_rec.driving_date_code);
1243: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1244: ' RETURN_STATUS = ' || x_return_status);
1245: END IF;

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

1239: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1240: 'TAX CALENDAR NAME = '|| p_global_variables_rec.tax_calendar_name);
1241: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1242: 'DRIVING_DATE_CODE = '|| p_global_variables_rec.driving_date_code);
1243: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1244: ' RETURN_STATUS = ' || x_return_status);
1245: END IF;
1246:
1247: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1244: ' RETURN_STATUS = ' || x_return_status);
1245: END IF;
1246:
1247: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1248: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1249: G_PKG_NAME||': ' ||l_api_name||'()-');
1250: END IF;
1251:
1252: IF g_debug_flag = 'Y' THEN

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

1263: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
1264: END IF;
1265:
1266: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1267: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1268: END IF;
1269: p_global_variables_rec.retcode := 2;
1270: RETURN;
1271: END get_VAT_reporting_details;

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

1296:
1297: BEGIN
1298:
1299: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1300: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1301: END IF;
1302:
1303: IF g_debug_flag = 'Y' THEN
1304: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');

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

1351: RETURN TRUE;
1352: END IF;
1353:
1354: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1355: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1356: G_PKG_NAME||': ' ||l_api_name||'()-');
1357: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1358: 'Last Processed Date : ' || to_char(l_last_processed_date));
1359: END IF;

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

1353:
1354: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1355: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1356: G_PKG_NAME||': ' ||l_api_name||'()-');
1357: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1358: 'Last Processed Date : ' || to_char(l_last_processed_date));
1359: END IF;
1360:
1361: IF g_debug_flag = 'Y' THEN

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

1370: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
1371: END IF;
1372:
1373: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1374: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1375: END IF;
1376: RETURN NULL;
1377: END is_prev_period_open;
1378:

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

1402: l_api_name CONSTANT VARCHAR2(30) := 'INIT_GT_VARIABLES';
1403:
1404: BEGIN
1405: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1406: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
1407: G_PKG_NAME||': '||l_api_name||'()+');
1408:
1409: END IF;
1410:

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

1646: gt_intra_eu_trx_type_code.delete;
1647:
1648:
1649: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1650: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1651: G_PKG_NAME||': ' ||l_api_name||'()-');
1652: END IF;
1653:
1654: IF g_debug_flag = 'Y' THEN

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

1658: EXCEPTION
1659: WHEN OTHERS THEN
1660: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1661: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1662: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1663: END IF;
1664:
1665: IF g_debug_flag = 'Y' THEN
1666: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

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

1712: l_tax_invoice_date_low DATE := P_GLOBAL_VARIABLES_REC.tax_invoice_date_low;
1713: BEGIN
1714:
1715: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1716: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
1717: G_PKG_NAME||': '||l_api_name||'()+');
1718: END IF;
1719:
1720: IF g_debug_flag = 'Y' THEN

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

2221: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
2222: END IF;
2223:
2224: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2225: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2226: END IF;
2227: p_global_variables_rec.retcode := 2;
2228: RETURN;
2229: END fetch_tax_data;

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

2258: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_TAX_DATA';
2259: BEGIN
2260:
2261: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2262: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name ,
2263: G_PKG_NAME||': '||l_api_name||'(+)');
2264: END IF;
2265:
2266: IF g_debug_flag = 'Y' THEN

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

2270: l_count := GT_TRX_ID.COUNT;
2271:
2272:
2273: IF (g_level_procedure >= g_current_runtime_level ) THEN
2274: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name ,
2275: ' Record Count = ' ||to_char(l_count));
2276: END IF;
2277:
2278: if g_selection_process_id is null then

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

2760: );
2761:
2762:
2763: IF (g_level_procedure >= g_current_runtime_level ) THEN
2764: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name ,
2765: ' Record successfully inserted = ' ||to_char(l_count));
2766: END IF;
2767:
2768: IF g_debug_flag = 'Y' THEN

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

2779: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
2780: END IF;
2781:
2782: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2783: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2784: END IF;
2785: --p_global_variables_rec.retcode := 2;
2786: RETURN;
2787:

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

2882: --Bug6835573
2883:
2884: BEGIN
2885: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2886: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
2887: G_PKG_NAME||': '||l_api_name||'()+');
2888: END IF;
2889:
2890: IF g_debug_flag = 'Y' THEN

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

2968: END IF;
2969:
2970: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2971:
2972: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2973: 'P_REPORTING_LEVEL = ' || l_reporting_level );
2974: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2975: 'P_REPORTING_CONTEXT = ' || l_reporting_context );
2976: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

2970: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2971:
2972: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2973: 'P_REPORTING_LEVEL = ' || l_reporting_level );
2974: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2975: 'P_REPORTING_CONTEXT = ' || l_reporting_context );
2976: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2977: 'P_LEGAL_ENTITY_ID = '|| l_legal_entity_id);
2978: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

2972: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2973: 'P_REPORTING_LEVEL = ' || l_reporting_level );
2974: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2975: 'P_REPORTING_CONTEXT = ' || l_reporting_context );
2976: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2977: 'P_LEGAL_ENTITY_ID = '|| l_legal_entity_id);
2978: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2979: ' P_PRODUCT = ' || p_global_variables_rec.SOURCE );
2980: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

2974: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2975: 'P_REPORTING_CONTEXT = ' || l_reporting_context );
2976: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2977: 'P_LEGAL_ENTITY_ID = '|| l_legal_entity_id);
2978: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2979: ' P_PRODUCT = ' || p_global_variables_rec.SOURCE );
2980: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2981: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
2982: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

2976: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2977: 'P_LEGAL_ENTITY_ID = '|| l_legal_entity_id);
2978: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2979: ' P_PRODUCT = ' || p_global_variables_rec.SOURCE );
2980: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2981: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
2982: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2983: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
2984: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

2978: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2979: ' P_PRODUCT = ' || p_global_variables_rec.SOURCE );
2980: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2981: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
2982: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2983: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
2984: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2985: ' P_TRX_DATE_LOW = '|| l_trx_date_low );
2986: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

2980: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2981: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
2982: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2983: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
2984: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2985: ' P_TRX_DATE_LOW = '|| l_trx_date_low );
2986: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2987: ' P_TRX_DATE_HIGH = '|| l_trx_date_high );
2988: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

2982: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2983: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
2984: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2985: ' P_TRX_DATE_LOW = '|| l_trx_date_low );
2986: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2987: ' P_TRX_DATE_HIGH = '|| l_trx_date_high );
2988: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2989: ' P_GL_DATE_LOW = '|| l_gl_date_low );
2990: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

2984: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2985: ' P_TRX_DATE_LOW = '|| l_trx_date_low );
2986: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2987: ' P_TRX_DATE_HIGH = '|| l_trx_date_high );
2988: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2989: ' P_GL_DATE_LOW = '|| l_gl_date_low );
2990: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2991: ' P_GL_DATE_HIGH = '|| l_gl_date_high );
2992: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

2986: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2987: ' P_TRX_DATE_HIGH = '|| l_trx_date_high );
2988: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2989: ' P_GL_DATE_LOW = '|| l_gl_date_low );
2990: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2991: ' P_GL_DATE_HIGH = '|| l_gl_date_high );
2992: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2993: ' P_TAX_INVOICE_DATE_LOW = '|| l_tax_invoice_date_low );
2994: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

2988: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2989: ' P_GL_DATE_LOW = '|| l_gl_date_low );
2990: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2991: ' P_GL_DATE_HIGH = '|| l_gl_date_high );
2992: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2993: ' P_TAX_INVOICE_DATE_LOW = '|| l_tax_invoice_date_low );
2994: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2995: ' P_TAX_INVOICE_DATE_HIGH = '|| l_tax_invoice_date_high );
2996: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

2990: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2991: ' P_GL_DATE_HIGH = '|| l_gl_date_high );
2992: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2993: ' P_TAX_INVOICE_DATE_LOW = '|| l_tax_invoice_date_low );
2994: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2995: ' P_TAX_INVOICE_DATE_HIGH = '|| l_tax_invoice_date_high );
2996: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2997: ' P_ACCOUNTING_STATUS = '|| l_accounting_status );
2998: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

2992: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2993: ' P_TAX_INVOICE_DATE_LOW = '|| l_tax_invoice_date_low );
2994: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2995: ' P_TAX_INVOICE_DATE_HIGH = '|| l_tax_invoice_date_high );
2996: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2997: ' P_ACCOUNTING_STATUS = '|| l_accounting_status );
2998: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2999: ' P_INCLUDE_ACCOUNTING_SEGMENTS = '|| l_include_acc_segments );
3000: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

2994: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2995: ' P_TAX_INVOICE_DATE_HIGH = '|| l_tax_invoice_date_high );
2996: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2997: ' P_ACCOUNTING_STATUS = '|| l_accounting_status );
2998: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2999: ' P_INCLUDE_ACCOUNTING_SEGMENTS = '|| l_include_acc_segments );
3000: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3001: ' P_TAX_REGIME_CODE = '|| p_global_variables_rec.TAX_REGIME_CODE);
3002: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

2996: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2997: ' P_ACCOUNTING_STATUS = '|| l_accounting_status );
2998: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2999: ' P_INCLUDE_ACCOUNTING_SEGMENTS = '|| l_include_acc_segments );
3000: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3001: ' P_TAX_REGIME_CODE = '|| p_global_variables_rec.TAX_REGIME_CODE);
3002: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3003: ' P_REPORTED_STATUS = '|| l_reported_status); --Bug6835573
3004:

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

2998: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2999: ' P_INCLUDE_ACCOUNTING_SEGMENTS = '|| l_include_acc_segments );
3000: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3001: ' P_TAX_REGIME_CODE = '|| p_global_variables_rec.TAX_REGIME_CODE);
3002: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3003: ' P_REPORTED_STATUS = '|| l_reported_status); --Bug6835573
3004:
3005:
3006: END IF;

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

3085: P_RETCODE => p_global_variables_rec.RETCODE,
3086: P_GL_OR_TRX_DATE_FILTER => p_global_variables_rec.gl_or_trx_date_filter);
3087:
3088: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3089: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3090: ' RETURN_STATUS = ' || p_global_variables_rec.RETCODE);
3091: END IF;
3092:
3093: -- Filtering based on Balancing Segment Value.

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

3119: WHERE ACT.request_id = x_request_id
3120: AND ACT.trx_arap_balancing_segment <> p_global_variables_rec.BSV;
3121:
3122: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3123: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3124: ' Records filtered based on bsv');
3125: END IF;
3126:
3127:

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

3127:
3128: END IF;
3129:
3130: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3131: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
3132: G_PKG_NAME||': ' ||l_api_name||'()-');
3133: END IF;
3134:
3135: IF g_debug_flag = 'Y' THEN

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

3145: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
3146: END IF;
3147:
3148: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3149: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3150: END IF;
3151: RETURN;
3152: END call_TRL;
3153:

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

3190: l_return_message VARCHAR2(2000);
3191:
3192: BEGIN
3193: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3194: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
3195: G_PKG_NAME||': '||l_api_name||'()+');
3196: END IF;
3197:
3198: IF g_debug_flag = 'Y' THEN

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

3336: RETURN;
3337: END IF;
3338:
3339: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3340: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3341: ' RETURN_STATUS = ' || p_global_variables_rec.RETCODE);
3342: END IF;
3343:
3344: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

3341: ' RETURN_STATUS = ' || p_global_variables_rec.RETCODE);
3342: END IF;
3343:
3344: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3345: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END'
3346: ,G_PKG_NAME||': ' ||l_api_name||'()-');
3347: END IF;
3348:
3349: IF g_debug_flag = 'Y' THEN

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

3359: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
3360: END IF;
3361:
3362: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3363: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3364: END IF;
3365: p_global_variables_rec.retcode := 2;
3366: RETURN;
3367: END control_intersecting_domains;

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

3479:
3480: BEGIN
3481:
3482: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3483: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
3484: G_PKG_NAME||': '||l_api_name||'()+');
3485: END IF;
3486:
3487: IF g_debug_flag = 'Y' THEN

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

3537:
3538: l_msg := l_count || ' Transactions are Finally Reported' ;
3539:
3540: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3541: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, l_msg);
3542: END IF;
3543:
3544: FND_MESSAGE.SET_NAME('JG','JG_ZZ_VAT_TRX_OVERLAPPING');
3545: FND_MESSAGE.SET_TOKEN('LOG_FILE', lv_filename );

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

3625:
3626: xv_return_status := fnd_api.g_ret_sts_success;
3627: xv_return_message := 'None of the transactions are finally reported';
3628: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3629: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, xv_return_message);
3630: END IF;
3631:
3632: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3633: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

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

3629: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, xv_return_message);
3630: END IF;
3631:
3632: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3633: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
3634: G_PKG_NAME||': ' || l_api_name||'()-');
3635: END IF;
3636:
3637: IF g_debug_flag = 'Y' THEN

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

3645: xv_return_message := 'Unexpected error occurred in the
3646: procedure PURGE_REPORT_FINALREP:' || SQLCODE || ' ' ||
3647: SUBSTR(SQLERRM,1,80) ;
3648: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3649: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3650: END IF;
3651: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3652:
3653: IF g_debug_flag = 'Y' THEN

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

3686:
3687: BEGIN
3688:
3689: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3690: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
3691: G_PKG_NAME||': '||l_api_name||'()+');
3692: END IF;
3693:
3694:

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

3702: utl_file.put_line(v_myfilehandle,text_to_write);
3703: utl_file.fclose(v_myfilehandle);
3704:
3705: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3706: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
3707: G_PKG_NAME||': ' || l_api_name||'()-');
3708: END IF;
3709:
3710: IF g_debug_flag = 'Y' THEN

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

3714:
3715: EXCEPTION
3716: WHEN OTHERS THEN
3717: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3718: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3719: END IF;
3720: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3721:
3722: IF g_debug_flag = 'Y' THEN

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

3855:
3856: BEGIN
3857:
3858: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3859: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
3860: G_PKG_NAME||': '||l_api_name||'()+');
3861: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3862: 'P_LEGAL_ENTITY_ID = '|| p_legal_entity_id);
3863: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

3857:
3858: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3859: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
3860: G_PKG_NAME||': '||l_api_name||'()+');
3861: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3862: 'P_LEGAL_ENTITY_ID = '|| p_legal_entity_id);
3863: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3864: 'P_LEDGER_ID = '|| p_ledger_id);
3865: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

3859: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
3860: G_PKG_NAME||': '||l_api_name||'()+');
3861: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3862: 'P_LEGAL_ENTITY_ID = '|| p_legal_entity_id);
3863: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3864: 'P_LEDGER_ID = '|| p_ledger_id);
3865: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3866: 'P_END_DATE = '|| p_end_date);
3867: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

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

3861: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3862: 'P_LEGAL_ENTITY_ID = '|| p_legal_entity_id);
3863: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3864: 'P_LEDGER_ID = '|| p_ledger_id);
3865: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3866: 'P_END_DATE = '|| p_end_date);
3867: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3868: ' P_SOURCE = ' || p_source);
3869: END IF;

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

3863: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3864: 'P_LEDGER_ID = '|| p_ledger_id);
3865: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3866: 'P_END_DATE = '|| p_end_date);
3867: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3868: ' P_SOURCE = ' || p_source);
3869: END IF;
3870:
3871: IF g_debug_flag = 'Y' THEN

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

3892: /*===== Start of Payables Tax Date Maintenance Program ==============*/
3893: BEGIN
3894:
3895: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3896: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3897: 'At the Beginning of Payables Tax Date Maintenance Program');
3898: END IF;
3899:
3900: OPEN c_primary_acct_method (l_ledger_id);

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

3926:
3927: -- Print the Invoices for which the tax date is getting
3928: -- updated in the log file
3929: IF l_num = 0 AND ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3930: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3931: 'The tax date has been changed to cleared date for the
3932: following invoices');
3933: l_num := 1;
3934: END IF;

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

3933: l_num := 1;
3934: END IF;
3935:
3936: IF l_num = 1 AND ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3937: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3938: 'Invoice num :' || c_inv_null_tax_date_rec.invoice_num ||
3939: -- ' ' ||'Original Tax Date :'|| to_char(c_inv_null_tax_date_rec.tax_invoice_recording_date, 'DD-MON-YYYY')
3940: --||' '|| 'Changed Tax Date :' || to_char(c_inv_null_tax_date_rec.cleared_date, 'DD-MON-YYYY'));
3941: ' ' || 'Actual Tax Date :'|| c_inv_null_tax_date_rec.tax_invoice_recording_date

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

3954: CLOSE c_inv_null_tax_date ;
3955: END IF;
3956:
3957: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3958: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,
3959: 'Unable to update the Tax_Invoice_Date in
3960: PAYABLES_MAINTENANCE PROGRAM' || ' error_msg = '
3961: || sqlcode || ':' || SUBSTR(SQLERRM, 1, 80));
3962: END IF;

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

3975: BEGIN
3976:
3977: l_num := 0;
3978: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3979: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
3980: 'Begining of the Receivables Tax date manintenance program');
3981: l_num := 1;
3982: END IF;
3983:

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

3990: FOR c_cust_trx_rec IN c_cust_trx
3991: LOOP
3992: -- Write the information into log file
3993: IF l_num = 1 AND (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3994: FND_LOG.STRING ( G_LEVEL_EXCEPTION, G_MODULE_NAME || l_api_name,
3995: ' Trx Id ' || c_cust_trx_rec.customer_trx_id ||
3996: ' Actual tax date ' || c_cust_trx_rec.tax_invoice_date ||
3997: ' Updated tax date ' || c_cust_trx_rec.apply_date );
3998: END IF;

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

4010: AND event_class_code = c_cust_trx_rec.event_class_code;
4011: EXCEPTION
4012: WHEN OTHERS THEN
4013: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4014: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,
4015: 'Error in updating Tax_Invoice_Date ' || ' error_msg = '
4016: || sqlcode || ':' || SUBSTR(SQLERRM, 1, 80));
4017: END IF;
4018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4020: END;
4021: END LOOP;
4022: END IF;
4023: IF l_num = 1 AND (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4024: FND_LOG.STRING ( G_LEVEL_EXCEPTION, G_MODULE_NAME || l_api_name, 'End of RECEIVABLES_MAINTENANCE PROGRAM' );
4025: END IF;
4026: EXCEPTION
4027: WHEN OTHERS THEN
4028: IF c_cust_trx%ISOPEN THEN

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

4028: IF c_cust_trx%ISOPEN THEN
4029: CLOSE c_cust_trx ;
4030: END IF;
4031: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4032: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,
4033: 'Unable to update the Tax_Invoice_Date in
4034: RECEIVABLES_MAINTENANCE PROGRAM' || ' error_msg = '
4035: || sqlcode || ':' || SUBSTR(SQLERRM, 1, 80));
4036: END IF;

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

4040:
4041: END IF;
4042:
4043: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4044: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
4045: G_PKG_NAME||': ' ||l_api_name||'()-');
4046: END IF;
4047:
4048: IF g_debug_flag = 'Y' THEN

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

4051:
4052: EXCEPTION
4053: WHEN OTHERS THEN
4054: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4055: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,
4056: 'Unable to update the Tax_Invoice_Date in TAX DATE MAINTENANCE PROGRAM'
4057: || ' error_msg = ' || sqlcode || ':' || SUBSTR(SQLERRM, 1, 80) );
4058: END IF;
4059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4077: | |
4078: +=========================================================================*/
4079:
4080: BEGIN
4081: -- g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4082:
4083: select text into l_version_info from user_source
4084: where name = 'JG_ZZ_VAT_SELECTION_PKG'
4085: and text like '%Header:%'

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

4086: and type = 'PACKAGE BODY'
4087: and line < 10;
4088:
4089: IF (g_level_procedure >= g_current_runtime_level ) THEN
4090: FND_LOG.STRING(g_level_procedure, g_module_name||' version info :',
4091: l_version_info);
4092: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',
4093: 'g_current_runtime_level :'||to_char(g_current_runtime_level));
4094: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',

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

4088:
4089: IF (g_level_procedure >= g_current_runtime_level ) THEN
4090: FND_LOG.STRING(g_level_procedure, g_module_name||' version info :',
4091: l_version_info);
4092: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',
4093: 'g_current_runtime_level :'||to_char(g_current_runtime_level));
4094: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',
4095: 'g_level_procedure :'||to_char(g_level_procedure));
4096: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',

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

4090: FND_LOG.STRING(g_level_procedure, g_module_name||' version info :',
4091: l_version_info);
4092: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',
4093: 'g_current_runtime_level :'||to_char(g_current_runtime_level));
4094: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',
4095: 'g_level_procedure :'||to_char(g_level_procedure));
4096: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',
4097: 'g_level_procedure :'||to_char(g_level_statement));
4098: END IF;

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

4092: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',
4093: 'g_current_runtime_level :'||to_char(g_current_runtime_level));
4094: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',
4095: 'g_level_procedure :'||to_char(g_level_procedure));
4096: FND_LOG.STRING(g_level_procedure, g_module_name|| ' version info :',
4097: 'g_level_procedure :'||to_char(g_level_statement));
4098: END IF;
4099: END JG_ZZ_VAT_SELECTION_PKG;