APPS.ZX_TCM_PTP_PKG dependencies on FND_LOG_MESSAGES

Line 141: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

137: l_tbl_index binary_integer;
138:
139: -- Logging Infra
140: l_procedure_name CONSTANT VARCHAR2(30) := '.GET_PTP ';
141: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
142:
143: BEGIN
144: --------------------------------------------------------------------------------------
145: -- Logging Infra: Setting up runtime level

Line 442: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

438: AND xlep.main_establishment_flag = 'Y';
439:
440: -- Logging Infra
441: l_procedure_name CONSTANT VARCHAR2(30) := '.GET_PTP_HQ';
442: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
443:
444: l_ptp_id_indx BINARY_INTEGER;
445:
446: BEGIN

Line 538: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

534: AND ptp.Party_Type_Code = 'FIRST_PARTY';
535:
536: -- Logging Infra
537: l_procedure_name CONSTANT VARCHAR2(30) := '.GET_TAX_SUBSCRIBER';
538: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
539: l_tbl_index BINARY_INTEGER;
540:
541: BEGIN
542: ---------------------------------------------------------------------------------

Line 741: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

737: WHERE organization_id = p_org_id;
738:
739: -- Logging Infra
740: l_procedure_name CONSTANT VARCHAR2(30) := '.GET_LOCATION_ID';
741: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
742:
743: BEGIN
744: --
745: -- Get the location_id of internal_organization_id

Line 853: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

849: l_tax_registration_id ZX_REGISTRATIONS.REGISTRATION_ID%TYPE;
850:
851: -- Logging Infra
852: l_procedure_name CONSTANT VARCHAR2(30) := '.CHECK_TAX_REGISTRATIONS';
853: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
854:
855: CURSOR c_get_reg_id
856: IS
857: SELECT registration_id

Line 1057: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1053: WHERE legal_registration_id = p_le_old_reg_id;
1054:
1055: -- Logging Infra
1056: l_procedure_name CONSTANT VARCHAR2(30) := 'SYNC_TAX_REGISTRATIONS';
1057: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1058:
1059: BEGIN
1060:
1061: -- Logging Infra: Setting up runtime level

Line 1494: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1490: WHERE ptp.party_id = p_party_id
1491: AND ptp.party_type_code = p_party_type_code;
1492:
1493: l_tbl_index binary_integer;
1494: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1495:
1496: BEGIN
1497:
1498: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1603: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1599: ptp.rounding_rule_code
1600: FROM zx_party_tax_profile ptp
1601: WHERE party_tax_profile_id = p_party_tax_profile_id;
1602:
1603: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1604: l_tbl_index binary_integer;
1605:
1606: BEGIN
1607: