APPS.ZX_TCM_GEO_JUR_PKG dependencies on FND_LOG_MESSAGES

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 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 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 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 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 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 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: