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 331: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

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

Line 500: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

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

Line 613: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

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

Line 859: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

855: l_same_regime_loc_country VARCHAR2(1);
856: x_location_table_name VARCHAR2(30);
857: -- Logging Infra
858: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_jurisdictions';
859: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
860: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
861: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
862:
863: l_tbl_index BINARY_INTEGER;

Line 1254: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1250: x_location_table_name VARCHAR2(30);
1251: l_country_code VARCHAR2(30);
1252: -- Logging Infra
1253: l_procedure_name CONSTANT VARCHAR2(30) := 'get_master_geography';
1254: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1255:
1256: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;
1257: l_geography_use hz_geographies.geography_use%type;
1258: l_tbl_index binary_integer;

Line 1519: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1515: TYPE GEO_NAME_TBL_TYPE IS TABLE OF VARCHAR2(360) index by BINARY_INTEGER;
1516: l_geography_name GEO_NAME_TBL_TYPE;
1517: -- Logging Infra
1518: l_procedure_name CONSTANT VARCHAR2(30) := 'populate_loc_geography_info';
1519: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1520: BEGIN
1521: -- Logging Infra: Setting up runtime level
1522: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1523: