DBA Data[Home] [Help]

APPS.ZX_TCM_EXT_SERVICES_PUB dependencies on FND_LOG_MESSAGES

Line 47: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

43: */
44:
45: -- Logging Infra:
46: l_procedure_name CONSTANT VARCHAR2(30) := 'get_default_status_rates';
47: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
48:
49: -- get default status code
50: CURSOR c_default_status IS
51: SELECT tax_status_code

Line 276: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

272: l_category_set ZX_FC_COUNTRY_DEFAULTS.PRIMARY_INVENTORY_CATEGORY_SET%TYPE;
273:
274: -- Logging Infra:
275: l_procedure_name CONSTANT VARCHAR2(30) := 'get_default_classif_code';
276: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
277:
278: -- get country defaults
279: CURSOR c_country_default IS
280: SELECT intended_use_default, product_categ_default, primary_inventory_category_set

Line 974: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

970: L_TBL_INDEX binary_integer;
971:
972: -- Logging Infra:
973: l_procedure_name CONSTANT VARCHAR2(30) := 'get_default_product_classif';
974: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
975:
976: -- Get default Product Fiscal Classification
977:
978: CURSOR c_country_default IS

Line 1402: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1398: RETURN Varchar2
1399: IS
1400: -- Logging Infra
1401: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Default_Tax_Reg';
1402: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1403: l_effective_date zx_registrations.effective_from%Type;
1404: --p_error_buffer varchar2(200);
1405:
1406: Cursor Default_Reg IS