eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TCM_GEO_JUR_PKG dependencies on FND_LOG

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

2: /* $Header: zxcjurb.pls 120.49.12020000.2 2012/07/23 12:51:34 srajapar noship $ */
3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_GEO_JUR_PKG';

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

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

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

6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_GEO_JUR_PKG';
13:
14: TYPE geography_id_type is TABLE OF NUMBER INDEX BY BINARY_INTEGER;

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

7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_GEO_JUR_PKG';
13:
14: TYPE geography_id_type is TABLE OF NUMBER INDEX BY BINARY_INTEGER;
15: l_jurisdiction_rec_tmp_tbl tax_jurisdiction_rec_tbl_type;

Line 36: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

32: x_loc_site OUT NOCOPY VARCHAR2,
33: x_return_status OUT NOCOPY VARCHAR2) IS
34: -- Logging Infra
35: l_procedure_name CONSTANT VARCHAR2(30) := 'get_pos_loc_or_site';
36: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
37: l_party_type_tbl_idx binary_integer;
38: l_idx BINARY_INTEGER;
39:
40: CURSOR c_get_party_type_info

Line 55: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

51: ZX_PARTY_TYPES;
52:
53: BEGIN
54: -- Logging Infra: Setting up runtime level
55: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
56: -- Logging Infra: Procedure level
57: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
58: l_log_msg := l_procedure_name||'(+)';
59: l_log_msg := l_log_msg ||' B: SEL zx_party_types: in: p_party_type='||p_party_type;

Line 60: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

56: -- Logging Infra: Procedure level
57: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
58: l_log_msg := l_procedure_name||'(+)';
59: l_log_msg := l_log_msg ||' B: SEL zx_party_types: in: p_party_type='||p_party_type;
60: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
61: END IF;
62:
63: -- Initialize API return status to success.
64:

Line 74: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

70: x_loc_tbl := ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_party_type_tbl_idx).LOCATION_SOURCE_TABLE;
71:
72: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
73: l_log_msg := 'Found the party type information in cache for:'||p_party_type;
74: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
75: END IF;
76:
77:
78: ELSE

Line 117: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

113: -- Logging Infra: Statement level: "R" means "R"eturned value to a caller
114: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
115: l_log_msg := 'R: SEL zx_party_types: out: x_loc_tbl='||x_loc_tbl||', x_loc_site='||x_loc_site;
116: l_log_msg := l_log_msg ||' '||l_procedure_name||'(-)';
117: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
118: END IF;
119:
120: EXCEPTION WHEN OTHERS THEN
121: -- Party type information could not be retrived.

Line 127: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'E: EXC: OTHERS: '||SQLCODE||': '||SQLERRM);

123: FND_MESSAGE.SET_NAME('ZX', 'ZX_TCM_NO_PARTY_TYPE_INFO');
124:
125: -- Logging Infra: Statement level
126: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
127: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'E: EXC: OTHERS: '||SQLCODE||': '||SQLERRM);
128: FND_LOG.STRING(G_LEVEL_STATEMENT,
129: G_MODULE_NAME || l_procedure_name,
130: 'E: EXC: OTHERS: p_party_type='||p_party_type ||
131: ' Party type information could not be retrived.');

Line 128: FND_LOG.STRING(G_LEVEL_STATEMENT,

124:
125: -- Logging Infra: Statement level
126: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
127: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'E: EXC: OTHERS: '||SQLCODE||': '||SQLERRM);
128: FND_LOG.STRING(G_LEVEL_STATEMENT,
129: G_MODULE_NAME || l_procedure_name,
130: 'E: EXC: OTHERS: p_party_type='||p_party_type ||
131: ' Party type information could not be retrived.');
132: END IF;

Line 166: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'B: Invalid Location_id');

162: IF l_hz_location_exists = 'TRUE' THEN
163: x_location_table_name := 'HZ_LOCATIONS';
164: ELSE
165: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
166: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'B: Invalid Location_id');
167: END IF;
168: END IF;
169: END IF;
170: ELSIF x_location_table_name = 'HZ_LOCATIONS' THEN

Line 194: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'B: Invalid Location_id');

190: IF l_hr_location_exists = 'TRUE' THEN
191: x_location_table_name := 'HR_LOCATIONS_ALL';
192: ELSE
193: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
194: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'B: Invalid Location_id');
195: END IF;
196: END IF;
197: END IF;
198: END IF;

Line 214: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name || '.begin', l_log_msg);

210: BEGIN
211:
212: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
213: l_log_msg := l_procedure_name||'(+)';
214: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name || '.begin', l_log_msg);
215: END IF;
216:
217: x_return_status := FND_API.G_RET_STS_SUCCESS;
218: IF ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl.exists(to_char(p_location_id)) then

Line 223: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,

219:
220: x_location_info_rec := zx_global_Structures_pkg.loc_info_tbl(to_char(p_location_id));
221:
222: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
223: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,
224: 'Found the location info in cache for location id: '||p_location_id||' for table '||
225: x_location_info_rec.location_table_name);
226: END IF;
227:

Line 261: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

257: EXCEPTION WHEN NO_DATA_FOUND THEN
258: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
259: l_log_msg := 'B: Invalid Location_id';
260: l_log_msg := l_log_msg ||' E: SEL country_code: no_data_found: p_location_id='||p_location_id;
261: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
262: END IF;
263:
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_LOC_REC');

Line 302: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'B: Invalid Location_id');

298:
299:
300: EXCEPTION WHEN NO_DATA_FOUND THEN
301: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
302: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'B: Invalid Location_id');
303: END IF;
304:
305: -- Logging Infra: "E" means "E"rror
306: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 308: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

304:
305: -- Logging Infra: "E" means "E"rror
306: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
307: l_log_msg := 'E: SEL country_code: no_data_found: p_location_id='||p_location_id;
308: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
309: END IF;
310:
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_LOC_REC');

Line 323: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name || '.end', l_log_msg);

319: END IF; -- Loc_info_tbl.exists
320:
321: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
322: l_log_msg := l_procedure_name||'(-)';
323: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name || '.end', l_log_msg);
324: END IF;
325:
326: END get_location_info;
327:

Line 334: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

330: l_loc_site VARCHAR2(30);
331: x_return_status VARCHAR2(1);
332: -- Logging Infra
333: l_procedure_name CONSTANT VARCHAR2(30) := 'get_location_table_name';
334: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
335:
336: BEGIN
337: -- Logging Infra: Statement level
338: -- No need to initialize g_current_runtime_level as it is done at the caller (get_zone or get_master_geo)

Line 343: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name || '.begin', l_log_msg);

339: -- Logging Infra: Statement level: "B" means "B"reak point
340: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
341: l_log_msg := l_procedure_name||'(+)';
342: l_log_msg := l_log_msg || 'B: p_location_type= '||p_location_type;
343: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name || '.begin', l_log_msg);
344: END IF;
345:
346: -- Logging Infra: Intentionally, not implementing log infra around get_pos_loc_or_site procedure
347: -- as it internally logs its messages.

Line 484: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

480: -- Logging Infra: Statement level:"R" means "R"eturned value to a caller
481: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
482: l_log_msg := 'R: x_location_table_name='||x_location_table_name;
483: l_log_msg := l_log_msg || l_procedure_name||'(-)';
484: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
485: END IF;
486:
487: EXCEPTION
488:

Line 503: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

499: p_inner_city_jurisdiction_flag IN VARCHAR2) IS
500: i BINARY_INTEGER;
501: -- Logging Infra
502: l_procedure_name CONSTANT VARCHAR2(30) := 'get_jurisdiction';
503: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
504: -----x_jurisdiction_rec_tmp_tbl tax_jurisdiction_rec_tbl_type;
505: CURSOR get_jur_info_c
506: ( c_tax VARCHAR2,
507: c_tax_regime_code VARCHAR2,

Line 536: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

532:
533: BEGIN
534:
535: -- Logging Infra: Setting up runtime level
536: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
537:
538: -- Logging Infra: Procedure level
539: -- Logging Infra: Statement level: "B" means "B"reak point
540: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 543: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name || '.begin', l_log_msg);

539: -- Logging Infra: Statement level: "B" means "B"reak point
540: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
541: l_log_msg := l_procedure_name||'(+)';
542: l_log_msg := l_log_msg ||' B: SEL zx_jurisdictions: in: p_tax='||p_tax||', p_date='||p_date||', p_tax_regime_code='||p_tax_regime_code||', p_geography_id='||p_geography_id;
543: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name || '.begin', l_log_msg);
544: END IF;
545:
546: IF l_jurisdiction_rec_tmp_tbl.count = 0 THEN
547: i := 1;

Line 576: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

572: l_log_msg := 'R: SEL zx_jurisdictions: out: tax_jurisdiction_id='||l_jurisdiction_rec_tmp_tbl(i).tax_jurisdiction_id||
573: ', tax_jurisdiction_code='||l_jurisdiction_rec_tmp_tbl(i).tax_jurisdiction_code;
574:
575: l_log_msg := l_log_msg ||' '||l_procedure_name||'(-)';
576: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
577: END IF;
578:
579: EXCEPTION WHEN NO_DATA_FOUND THEN
580: NULL;

Line 585: ---- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

581: -- Logging Infra: Procedure level
582: ---- IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
583: ---- l_log_msg := 'S: EXC: NO_DATA_FOUND: tax_jurisdiction_id='||g_jurisdiction_rec_tbl.tax_jurisdiction_id(i)||
584: ---- ', tax_jurisdiction_code='||g_jurisdiction_rec_tbl.tax_jurisdiction_code(i);
585: ---- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
586: ---- END IF;
587:
588: END get_jurisdiction;
589:

Line 616: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

612: l_zone_type_country_code VARCHAR2(30);
613:
614: -- Logging Infra
615: l_procedure_name CONSTANT VARCHAR2(30) := 'get_zone';
616: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
617:
618: -- The following 3 variables are added to make the external api (HZ_GEO_GET_PUB.get_zone)
619: -- calling place to compile. Needs to be removed later...
620: l_init_msg_list VARCHAR2(30);

Line 637: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

633: p_zone_tbl HZ_GEO_GET_PUB.zone_tbl_type;
634: l NUMBER;
635: BEGIN
636: -- Logging Infra: Setting up runtime level
637: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
638: -- Logging Infra: Procedure level
639: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
640: l_log_msg := l_procedure_name||'(+)';
641: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name || '.begin', l_log_msg);

Line 641: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name || '.begin', l_log_msg);

637: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
638: -- Logging Infra: Procedure level
639: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
640: l_log_msg := l_procedure_name||'(+)';
641: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name || '.begin', l_log_msg);
642: END IF;
643:
644: -- Initialize API return status to success.
645:

Line 662: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

658: -- Logging Infra: Statement level: "B" means "B"reak point
659: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
660: l_log_msg := 'B: hz_geo_get_pub.get_zone: in: '||'p_location_table_name='||x_location_table_name||
661: ', p_location_id='||p_location_id||', p_zone_type=' ||p_zone_type||', p_date='||p_trx_date;
662: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
663: END IF;
664:
665: get_location_info(p_location_id, x_location_table_name, l_location_info_rec, x_return_status);
666: x_location_table_name := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).location_table_name;

Line 710: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

706:
707: IF l_limited_by_geography_id IS NOT NULL THEN
708: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
709: l_log_msg := 'R: Location country and Zone Type country are matching';
710: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
711: END IF;
712:
713: -- check if geo name reference information is there in cache
714: l_tbl_index := dbms_utility.get_hash_value(

Line 725: FND_LOG.STRING(g_level_statement,

721: g_geo_name_references_tbl(l_tbl_index).location_id = p_location_id then
722: -- The geo name reference information is there in cache.
723: -- No need to read from tables
724: IF (g_level_statement >= g_current_runtime_level ) THEN
725: FND_LOG.STRING(g_level_statement,
726: G_MODULE_NAME || l_procedure_name,
727: 'Found geo name reference information in cache ');
728: END IF;
729: l_count_geo := g_geo_name_references_tbl(l_tbl_index).ref_count;

Line 733: FND_LOG.STRING(g_level_statement,

729: l_count_geo := g_geo_name_references_tbl(l_tbl_index).ref_count;
730:
731: ELSE
732: IF (g_level_statement >= g_current_runtime_level ) THEN
733: FND_LOG.STRING(g_level_statement,
734: G_MODULE_NAME || l_procedure_name,
735: 'Not found geo name reference information in cache, read from table');
736: END IF;
737: -- Bug 4551957

Line 776: FND_LOG.STRING(g_level_statement,

772: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).indx_value = l_zone_indx AND
773: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).value = 1 THEN
774:
775: IF (g_level_statement >= g_current_runtime_level ) THEN
776: FND_LOG.STRING(g_level_statement,
777: G_MODULE_NAME || l_procedure_name,
778: 'Zone Information found in cache.');
779: END IF;
780:

Line 801: FND_LOG.STRING(g_level_statement,

797: x_zone_tbl := p_zone_tbl;
798: ELSE
799:
800: IF (g_level_statement >= g_current_runtime_level ) THEN
801: FND_LOG.STRING(g_level_statement,
802: G_MODULE_NAME || l_procedure_name,
803: 'Not Found Zone info in cache... call HZ_GEO_GET_PUB.get_zone');
804: END IF;
805: HZ_GEO_GET_PUB.get_zone(

Line 817: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name,

813: x_msg_count,
814: x_msg_data);
815:
816: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
817: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name,
818: 'Returning from HZ_GEO_GET_PUB.get_zone with x_return_status:'||x_return_status
819: ||' x_msg_count:'|| x_msg_count
820: ||' x_msg_data:'||x_msg_data
821: ||'number of records in x_zone_tbl :'||x_zone_tbl.count);

Line 829: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name,x_msg_data);

825: ZX_API_PUB.G_EXTERNAL_API_CALL := 'Y';
826: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
827: IF x_msg_count = 1
828: THEN
829: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name,x_msg_data);
830: ELSIF x_msg_count > 1
831: THEN
832: FOR i in 1..x_msg_count LOOP
833: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name,

Line 833: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name,

829: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name,x_msg_data);
830: ELSIF x_msg_count > 1
831: THEN
832: FOR i in 1..x_msg_count LOOP
833: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name,
834: FND_MSG_PUB.GET(p_msg_index => i, p_encoded => FND_API.G_FALSE));
835: END LOOP;
836: END IF;
837: END IF;

Line 845: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

841:
842: FOR i in NVL(x_zone_tbl.first,0)..NVL(x_zone_tbl.last,-99) LOOP
843: l_log_msg := 'hz_geo_get_pub.get_zone: out: x_zone_id='||x_zone_tbl(i).zone_id||', x_zone_code='||x_zone_tbl(i).zone_code||
844: ', x_zone_name='||x_zone_tbl(i).zone_name||', i = '||i;
845: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
846: END LOOP;
847: END IF;
848:
849: FOR i IN 1 .. x_zone_tbl.count LOOP

Line 857: FND_LOG.STRING(g_level_unexpected,

853: p_trx_date || '|' ||
854: to_char(i);
855: IF ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl.EXISTS(l_zone_indx) THEN
856: IF (g_level_unexpected >= g_current_runtime_level ) THEN
857: FND_LOG.STRING(g_level_unexpected,
858: 'ZX.PLSQL.ZX_TCM_GEO_JUR_PKG.get_zone',
859: 'Caching issue can cause incorrect tax calculation.');
860: END IF;
861: END IF;

Line 882: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

878: IF x_zone_tbl.count > 0 THEN
879: FOR i in x_zone_tbl.first..x_zone_tbl.last LOOP
880: l_log_msg := 'R: hz_geo_get_pub.get_zone: out: x_zone_id='||x_zone_tbl(i).zone_id||', x_zone_code='||x_zone_tbl(i).zone_code||
881: ', x_zone_name='||x_zone_tbl(i).zone_name||', x_return_status='||x_return_status;
882: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
883: END LOOP;
884: END IF;
885: END IF;
886: ELSE

Line 890: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

886: ELSE
887: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
888: l_log_msg := 'R: Location country and Zone Type country are not matching';
889: l_log_msg := l_log_msg ||' '|| l_procedure_name||'(-)';
890: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
891: END IF;
892:
893: END IF;
894:

Line 905: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

901: IF x_zone_tbl.count > 0 THEN
902: FOR i in x_zone_tbl.first..x_zone_tbl.last LOOP
903: l_log_msg := 'E: EXC: FND_API.G_EXC_ERROR: x_zone_id='||x_zone_tbl(i).zone_id||', x_zone_code='||x_zone_tbl(i).zone_code||
904: ', x_zone_name='||x_zone_tbl(i).zone_name||', x_return_status='||x_return_status;
905: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
906: END LOOP;
907: END IF;
908: END IF;
909:

Line 923: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'E: EXC: OTHERS: '||SQLCODE||': '|| SQLERRM);

919: -- Logging Infra: Statement level: "E" means "E"rror
920: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
921: IF x_zone_tbl.count > 0 THEN
922: FOR i in x_zone_tbl.first..x_zone_tbl.last LOOP
923: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'E: EXC: OTHERS: '||SQLCODE||': '|| SQLERRM);
924: l_log_msg := 'E: EXC: OTHERS: x_zone_id='||x_zone_tbl(i).zone_id||', x_zone_code='||x_zone_tbl(i).zone_code||
925: ', x_zone_name='||x_zone_tbl(i).zone_name||', x_return_status='||x_return_status;
926: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
927: END LOOP;

Line 926: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

922: FOR i in x_zone_tbl.first..x_zone_tbl.last LOOP
923: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'E: EXC: OTHERS: '||SQLCODE||': '|| SQLERRM);
924: l_log_msg := 'E: EXC: OTHERS: x_zone_id='||x_zone_tbl(i).zone_id||', x_zone_code='||x_zone_tbl(i).zone_code||
925: ', x_zone_name='||x_zone_tbl(i).zone_name||', x_return_status='||x_return_status;
926: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
927: END LOOP;
928: END IF;
929: END IF;
930:

Line 974: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

970: l_same_regime_loc_country VARCHAR2(1);
971: x_location_table_name VARCHAR2(30);
972: -- Logging Infra
973: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_jurisdictions';
974: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
975: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
976: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
977:
978: l_tbl_index BINARY_INTEGER;

Line 985: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

981:
982: BEGIN
983:
984: -- Logging Infra: Setting up runtime message level
985: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
986: -- Logging Infra: Procedure level
987: -- Logging Infra: Statement level: "B" means "B"reak point
988: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
989: l_log_msg := l_procedure_name||'(+)';

Line 991: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name || '.begin', l_log_msg);

987: -- Logging Infra: Statement level: "B" means "B"reak point
988: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
989: l_log_msg := l_procedure_name||'(+)';
990: l_log_msg := l_log_msg ||' B: SEL hz_geography_types: in: p_tax='||p_tax||', p_tax_regime_code='||p_tax_regime_code;
991: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name || '.begin', l_log_msg);
992: END IF;
993:
994:
995: -- Initialize API return status to success.

Line 1017: FND_LOG.STRING(g_level_exception,

1013: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info
1014: RETURN_STATUS = ' || x_return_status||' Error Buffer = '||l_error_buffer||
1015: ', '||l_procedure_name||' (-)';
1016:
1017: FND_LOG.STRING(g_level_exception,
1018: G_MODULE_NAME || l_procedure_name||'.END',
1019: l_log_msg);
1020: END IF;
1021: RETURN;

Line 1033: FND_LOG.STRING(g_level_statement,

1029: l_country_or_group_code := l_tax_regime_rec.country_or_group_code;
1030: l_regime_country_code := l_tax_regime_rec.country_code;
1031:
1032: /*IF (g_level_statement >= g_current_runtime_level ) THEN
1033: FND_LOG.STRING(g_level_statement,
1034: G_MODULE_NAME || l_procedure_name,
1035: 'Country_or_group_code = ' ||l_country_or_group_code||
1036: 'Country_code = '||l_regime_country_code);
1037: END If;

Line 1043: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1039:
1040: IF l_country_or_group_code <> 'COUNTRY' THEN
1041: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1042: l_log_msg := 'R: Tax Regime is created for a tax zone';
1043: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1044: END IF;
1045: l_country_regime_flag := 'N';
1046: ELSE
1047: l_country_regime_flag := 'Y';

Line 1050: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1046: ELSE
1047: l_country_regime_flag := 'Y';
1048: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1049: l_log_msg := 'R: Tax Regime is created for a country';
1050: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1051: END IF;
1052: get_location_table_name(p_location_type,
1053: x_location_table_name);
1054:

Line 1076: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1072:
1073: IF l_regime_country_code = l_loc_country_code THEN
1074: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1075: l_log_msg := 'R: Country of Tax Regime is same as the country of the location';
1076: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1077: END IF;
1078: l_same_regime_loc_country := 'Y';
1079: ELSE
1080: null;

Line 1084: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1080: null;
1081: l_same_regime_loc_country := 'N';
1082: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1083: l_log_msg := 'R: Country of Tax Regime is not the same as the country of the location';
1084: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1085: END IF;
1086: END IF;
1087: END IF;
1088: IF l_country_regime_flag = 'N' or l_same_regime_loc_country = 'Y' THEN

Line 1101: FND_LOG.STRING(g_level_statement,

1097: -- The Gography usage information is there in cache. No need to read from tables
1098:
1099:
1100: IF (g_level_statement >= g_current_runtime_level ) THEN
1101: FND_LOG.STRING(g_level_statement,
1102: G_MODULE_NAME || l_procedure_name,
1103: 'Found Geography usage information in cache ');
1104: END IF;
1105:

Line 1130: FND_LOG.STRING(g_level_exception,

1126: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info
1127: RETURN_STATUS = ' || x_return_status||' Error Buffer = '||l_error_buffer||
1128: ', '||l_procedure_name||' (-)';
1129:
1130: FND_LOG.STRING(g_level_exception,
1131: G_MODULE_NAME || l_procedure_name||'.END',
1132: l_log_msg);
1133: END IF;
1134:

Line 1183: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1179:
1180: EXCEPTION WHEN NO_DATA_FOUND THEN
1181: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1182: l_log_msg := 'B: SEL hz_geography_type: Not Found for Tax';
1183: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1184: END IF;
1185: END;
1186:
1187: -- populate the l_inner_city_jurisdiction_flag value

Line 1220: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1216: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1217: l_log_msg := 'Geography Usage: ' || g_geography_use_info_tbl(l_tbl_index).geography_use ||
1218: ' for type ' || g_geography_use_info_tbl(l_tbl_index).geography_type ||
1219: ' Object type is: '|| l_obj_geo_type;
1220: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1221: END IF;
1222:
1223: IF NVL(FND_PROFILE.value('ZX_USE_LOC_INSIDE_CITY_LIMITS'), 'N') = 'Y'
1224: AND l_obj_geo_type = 'CITY' THEN

Line 1273: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1269: END LOOP;
1270: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1271: l_log_msg := 'B: SEL l_inner_city_jurisdiction_flag: ' || Nvl(l_inner_city_jurisdiction_flag,'X') ||
1272: ' from Location: ' || p_location_id || ' Tax: ' || p_tax;
1273: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1274: END IF;
1275:
1276: -- IF l_geography_type.count > 0 THEN
1277: i := 1; -- counter for geography_type_num

Line 1297: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1293: l_log_msg := 'B: SEL hz_geography_type: out: p_location_id='||p_location_id||',
1294: p_location_type='||p_location_type||
1295: ', l_geography_type='||g_geography_use_info_tbl(l_tbl_index).geography_type||
1296: ', l_geography_use='||g_geography_use_info_tbl(l_tbl_index).geography_use;
1297: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1298: END IF;
1299: IF g_geography_use_info_tbl(l_tbl_index).geography_use = 'TAX' THEN
1300: get_zone(p_location_id,
1301: p_location_type,

Line 1311: ----- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1307: -- Logging Infra: Statement level: "B" means "B"reak point
1308: ----- IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1309: ----- l_log_msg := 'B: geography info: geography_id='||l_geography_id(i)||', geography_name='||l_geography_name(i)||
1310: ----- ', x_return_status='||x_return_status;
1311: ----- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1312: ----- END IF;
1313: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1314: IF l_zone_tbl.count > 0 THEN
1315: FOR j in l_zone_tbl.first..l_zone_tbl.last LOOP

Line 1338: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1334: -- Logging Infra: Statement level: "B" means "B"reak point
1335: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1336: l_log_msg := 'B: geography info: geography_id='||l_geography_id||', geography_name='||l_geography_name||
1337: ', x_return_status='||x_return_status;
1338: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1339: END IF;
1340: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1341: IF l_geography_id IS NOT NULL THEN
1342: get_jurisdiction(p_tax,

Line 1368: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1364: x_tax_jurisdiction_rec.precedence_level := l_jurisdiction_rec_tmp_tbl(1).precedence_level;
1365: x_jurisdictions_found := 'Y';
1366: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1367: l_log_msg := 'R: Single jurisdiction has been found';
1368: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1369: END IF;
1370: ELSIF l_jurisdiction_rec_tmp_tbl.count > 1 THEN
1371: FOR n in l_jurisdiction_rec_tmp_tbl.first..l_jurisdiction_rec_tmp_tbl.last LOOP
1372: INSERT INTO zx_jurisdictions_gt

Line 1398: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1394:
1395: -- Logging Infra: Statement level: "R" means "R"eturned value to a caller
1396: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1397: l_log_msg := 'R: Inserted into zx_jurisdictions_gt table)' ;
1398: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1399: END IF;
1400: ELSIF l_jurisdiction_rec_tmp_tbl.count = 0 THEN
1401: x_jurisdictions_found := 'N';
1402: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1404: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1400: ELSIF l_jurisdiction_rec_tmp_tbl.count = 0 THEN
1401: x_jurisdictions_found := 'N';
1402: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1403: l_log_msg := 'R: No jurisdiction has been found';
1404: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1405: END IF;
1406: END IF;
1407:
1408:

Line 1413: ---- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1409: -- Logging Infra: Statement level: "R" means "R"eturned value to a caller
1410: ---- IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1411: ---- l_log_msg := 'R: tax_jurisdiction_id='||g_jurisdiction_rec_tbl(i).tax_jurisdiction_id||
1412: ---- ', tax_jurisdiction_code='||g_jurisdiction_rec_tbl(i).tax_jurisdiction_code;
1413: ---- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1414: ---- END IF;
1415: -- Logging Infra: Procedure level
1416: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1417: l_log_msg := l_procedure_name||'(-)';

Line 1418: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name || '.end', l_log_msg);

1414: ---- END IF;
1415: -- Logging Infra: Procedure level
1416: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1417: l_log_msg := l_procedure_name||'(-)';
1418: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name || '.end', l_log_msg);
1419: END IF;
1420: EXCEPTION
1421: WHEN FND_API.G_EXC_ERROR THEN
1422: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1428: ---- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1424: -- Logging Infra: Statement level
1425: ---- IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1426: ---- l_log_msg := 'E: EXC: FND_API.G_EXEC_ERROR: tax_jurisdiction_id='||g_jurisdiction_rec_tbl.tax_jurisdiction_id(i)||
1427: ---- ', tax_jurisdiction_code='||g_jurisdiction_rec_tbl.tax_jurisdiction_code(i);
1428: ---- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1429: ---- END IF;
1430:
1431:
1432: WHEN OTHERS THEN

Line 1439: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'E: EXC: OTHERS: '||SQLCODE||': '||SQLERRM);

1435: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1436:
1437: -- Logging Infra: Statement level
1438: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1439: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'E: EXC: OTHERS: '||SQLCODE||': '||SQLERRM);
1440: ---- l_log_msg := 'E: EXC: OTHERS: tax_jurisdiction_id='||g_jurisdiction_rec_tbl.tax_jurisdiction_id(i)||
1441: ---- ', tax_jurisdiction_code='||g_jurisdiction_rec_tbl.tax_jurisdiction_code(i);
1442: ---- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1443: END IF;

Line 1442: ---- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1438: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1439: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'E: EXC: OTHERS: '||SQLCODE||': '||SQLERRM);
1440: ---- l_log_msg := 'E: EXC: OTHERS: tax_jurisdiction_id='||g_jurisdiction_rec_tbl.tax_jurisdiction_id(i)||
1441: ---- ', tax_jurisdiction_code='||g_jurisdiction_rec_tbl.tax_jurisdiction_code(i);
1442: ---- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1443: END IF;
1444:
1445: END get_tax_jurisdictions;
1446:

Line 1461: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1457: x_location_table_name VARCHAR2(30);
1458: l_country_code VARCHAR2(30);
1459: -- Logging Infra
1460: l_procedure_name CONSTANT VARCHAR2(30) := 'get_master_geography';
1461: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1462:
1463: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;
1464: l_geography_use hz_geographies.geography_use%type;
1465: l_tbl_index binary_integer;

Line 1470: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1466: l_tbl_country_index binary_integer;
1467:
1468: BEGIN
1469: -- Logging Infra: Setting up runtime level
1470: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1471:
1472: -- Logging Infra: Procedure level
1473: -- Logging Infra: Statement level: "B" means "B"reak point
1474: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1477: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name || '.begin', l_log_msg);

1473: -- Logging Infra: Statement level: "B" means "B"reak point
1474: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1475: l_log_msg := l_procedure_name||'(+)';
1476: l_log_msg := l_log_msg||' B: SEL hz_geography_types: in: p_geography_type='||p_geography_type;
1477: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name || '.begin', l_log_msg);
1478: END IF;
1479:
1480: x_return_status := FND_API.G_RET_STS_SUCCESS;
1481:

Line 1499: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1495: IF l_count = 0 THEN
1496: -- Logging Infra: Statement level: "E" means "E"rror
1497: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1498: l_log_msg := 'E: SEL hz_geography_types: no_data_found: '||'p_geography_type='||p_geography_type;
1499: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1500: END IF;
1501:
1502: --x_return_status := FND_API.G_RET_STS_ERROR;
1503: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_TYPE_INVALID');

Line 1518: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1514: -- Logging Infra: Statement level: "B" means "B"reak point
1515: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1516: l_log_msg := 'B: SEL hz_geo_name_ref: in: p_location_id='||p_location_id||', p_geography_type='||p_geography_type||
1517: ', x_location_table_name='||x_location_table_name;
1518: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1519: END IF;
1520:
1521: -- Find geography id from gnr table
1522: -- ---------------------------------

Line 1535: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

1531: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type = p_geography_type) THEN
1532:
1533: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1534: l_log_msg := 'Found the geography id and geography name info in cache';
1535: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
1536: END IF;
1537:
1538: x_geography_id := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id;
1539: x_geography_code := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code;

Line 1555: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1551: AND geo.geography_id = gnr.geography_id;
1552:
1553: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1554: l_log_msg := 'B: SEL hz_geo_name_ref: out: x_geography_id='||x_geography_id;
1555: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1556: END IF;
1557:
1558: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).location_id := p_location_id;
1559: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type := p_geography_type;

Line 1572: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1568: -- Logging Infra: Statement level: "S" means "S"uccess. Geography code can be NULL.
1569: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1570: l_log_msg := 'S: SEL hz_geo_name_ref: no_data_found: '||'x_location_table_name='||x_location_table_name||' B: x_geography_id='||x_geography_id||', p_geography_type='||p_geography_type||
1571: ', p_location_id='||p_location_id||', p_geography_type='||p_geography_type;
1572: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1573: END IF;
1574: END;
1575:
1576: END IF;

Line 1587: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1583:
1584: -- Logging Infra: "B" means "B"reak point
1585: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1586: l_log_msg := 'B: SEL hz_geographies: in: l_country_code='||l_country_code;
1587: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1588: END IF;
1589:
1590: BEGIN
1591: SELECT geography_id, geography_code, geography_name

Line 1603: FND_LOG.STRING(G_LEVEL_STATEMENT,

1599: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1600: l_log_msg := 'E: SEL hz_geographies: no_data_found: '||'l_country_code='
1601: ||l_country_code||' for location '||p_location_id
1602: ||' and table '||x_location_table_name;
1603: FND_LOG.STRING(G_LEVEL_STATEMENT,
1604: G_MODULE_NAME || l_procedure_name,
1605: l_log_msg);
1606: END IF;
1607:

Line 1621: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1617: /* 3471450 -- Logging Infra: return_status changed to success status */
1618: -- Logging Infra: Statement level: "S" means "S"uccess. Geography code can be NULL.
1619: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1620: l_log_msg := 'S: hz_geo_no_geo_name_ref: p_geography_type='||p_geography_type;
1621: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1622: END IF;
1623:
1624: x_return_status := FND_API.G_RET_STS_SUCCESS;
1625:

Line 1633: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1629: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1630: l_log_msg := 'R: x_geography_id='||x_geography_id||', x_gegraphy_code='||x_geography_code||
1631: ', x_geography_name='||x_geography_name;
1632: l_log_msg := l_log_msg || '- '||l_procedure_name||'(-)';
1633: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1634: END IF;
1635:
1636: EXCEPTION
1637: WHEN FND_API.G_EXC_ERROR THEN

Line 1644: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME ||l_procedure_name,l_log_msg);

1640: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1641: l_log_msg := 'E: EXC: FND_API.G_EXC_ERROR: x_geography_id='||
1642: x_geography_id||', x_gegraphy_code='||x_geography_code||',
1643: x_geography_name='||x_geography_name;
1644: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME ||l_procedure_name,l_log_msg);
1645: END IF;
1646:
1647: WHEN OTHERS THEN
1648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1653: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,

1649: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1650: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1651:
1652: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1653: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,
1654: 'E: EXC: OTHERS: '|| SQLCODE||': '||SQLERRM);
1655: l_log_msg := 'E: EXC: OTHERS: x_geography_id='||x_geography_id||',
1656: x_gegraphy_code='||x_geography_code||
1657: ', x_geography_name='||x_geography_name;

Line 1658: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME ||l_procedure_name,l_log_msg);

1654: 'E: EXC: OTHERS: '|| SQLCODE||': '||SQLERRM);
1655: l_log_msg := 'E: EXC: OTHERS: x_geography_id='||x_geography_id||',
1656: x_gegraphy_code='||x_geography_code||
1657: ', x_geography_name='||x_geography_name;
1658: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME ||l_procedure_name,l_log_msg);
1659: END IF;
1660: END;
1661:
1662: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,

Line 1730: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1726: TYPE GEO_NAME_TBL_TYPE IS TABLE OF VARCHAR2(360) index by BINARY_INTEGER;
1727: l_geography_name GEO_NAME_TBL_TYPE;
1728: -- Logging Infra
1729: l_procedure_name CONSTANT VARCHAR2(30) := 'populate_loc_geography_info';
1730: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1731: BEGIN
1732: -- Logging Infra: Setting up runtime level
1733: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1734:

Line 1733: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1729: l_procedure_name CONSTANT VARCHAR2(30) := 'populate_loc_geography_info';
1730: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1731: BEGIN
1732: -- Logging Infra: Setting up runtime level
1733: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1734:
1735: -- Logging Infra: Procedure level
1736: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1737: l_log_msg := l_procedure_name||'(+)';

Line 1738: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name || '.begin', l_log_msg);

1734:
1735: -- Logging Infra: Procedure level
1736: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1737: l_log_msg := l_procedure_name||'(+)';
1738: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name || '.begin', l_log_msg);
1739: END IF;
1740:
1741: -- Initialize API return status to success.
1742:

Line 1755: -- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1751:
1752: -- Logging Infra: Statement level: "B" means "B"reak point
1753: -- IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1754: -- l_log_msg := 'B: get_location_table_name: out: x_loc_tbl='||x_loc_tbl;
1755: -- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1756: -- END IF;
1757:
1758: n := 1;
1759: idx1 := to_char(event_class_mapping_id)||location_type_tbl(i)||location_id_tbl(i) ||x_loc_tbl|| to_char(n);

Line 1773: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1769: geography_found := 'TRUE';
1770: -- Logging Infra: Statement level: "B" means "B"reak point
1771: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1772: l_log_msg := 'B: Geography found ';
1773: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1774: END IF;
1775: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k) :=
1776: event_class_mapping_id;
1777: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;

Line 1807: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1803: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1804: l_log_msg := 'B: Geography found ='||event_class_mapping_id||trx_id||trx_line_id||
1805: trx_level_type||x_loc_tbl||location_id_tbl(i)||g_geography_id_tbl(idx1)
1806: ||g_geography_type_tbl(idx1)||g_geography_name_tbl(idx1);
1807: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1808: END IF;
1809: n := n + 1;
1810: k := k + 1;
1811: idx1 := to_char(event_class_mapping_id)||location_type_tbl(i)||location_id_tbl(i) ||x_loc_tbl|| to_char(n);

Line 1816: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1812: ELSE
1813: -- Logging Infra: Statement level: "B" means "B"reak point
1814: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1815: l_log_msg := 'B: Geography NOT existing in cache ';
1816: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1817: END IF;
1818: EXIT;
1819: END IF;
1820: END LOOP;

Line 1825: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1821: IF geography_found <> 'TRUE' THEN
1822: -- Logging Infra: Statement level: "B" means "B"reak point
1823: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1824: l_log_msg := 'B: Fetching geography info from gnr. The Location id is'||to_char(location_id_tbl(i));
1825: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1826: END IF;
1827: BEGIN
1828: l_error_flag := 'N';
1829: SELECT gnr.geography_id, gnr.geography_type, g.geography_name

Line 1838: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1834: AND gnr.geography_id = g.geography_id
1835: ORDER BY gnr.geography_id;
1836: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1837: l_log_msg := 'B: After GNR fetch ';
1838: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1839: END IF;
1840: EXCEPTION
1841: WHEN OTHERS THEN
1842: -- Logging Infra: Statement level

Line 1844: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'E: EXC: OTHERS: '

1840: EXCEPTION
1841: WHEN OTHERS THEN
1842: -- Logging Infra: Statement level
1843: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1844: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'E: EXC: OTHERS: '
1845: || SQLCODE||': '||SQLERRM);
1846:
1847: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1848: END IF;

Line 1847: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1843: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1844: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'E: EXC: OTHERS: '
1845: || SQLCODE||': '||SQLERRM);
1846:
1847: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1848: END IF;
1849: l_error_flag := 'Y';
1850: END;
1851: IF l_error_flag <> 'Y' then

Line 1857: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1853: idx1 := to_char(event_class_mapping_id)||location_type_tbl(i)||location_id_tbl(i) ||x_loc_tbl|| to_char(n);
1854: IF l_geography_id.count > 0 THEN
1855: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1856: l_log_msg := 'B: Entering assignment loop after GNR fetch';
1857: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1858: END IF;
1859:
1860:
1861: FOR m IN l_geography_id.first..l_geography_id.last LOOP

Line 1916: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1912: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.geography_type(k)'
1913: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k);
1914: l_log_msg := l_log_msg || 'B: LOCATION_INFO_TBL.geography_value(k)'
1915: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k);
1916: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1917: END IF;
1918:
1919: hash_string := to_char(event_class_mapping_id)||'|'||
1920: to_char(trx_id)||'|'||

Line 1935: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1931: -- Logging Infra: Statement level: "B" means "B"reak point
1932: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1933: l_log_msg := 'B: Geography details populated'|| g_geography_id_tbl(idx1)
1934: ||g_geography_type_tbl(idx1)||g_geography_name_tbl(idx1);
1935: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1936: END IF;
1937:
1938: n := n + 1;
1939: k := k + 1;