APPS.ZX_TCM_PTP_PKG dependencies on FND_LOG_MESSAGES

Line 148: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

144: l_party_name VARCHAR2(240);
145:
146: -- Logging Infra
147: l_procedure_name CONSTANT VARCHAR2(30) := '.GET_PTP ';
148: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
149:
150: BEGIN
151: --------------------------------------------------------------------------------------
152: -- Logging Infra: Setting up runtime level

Line 473: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

469: AND xlep.main_establishment_flag = 'Y';
470:
471: -- Logging Infra
472: l_procedure_name CONSTANT VARCHAR2(30) := '.GET_PTP_HQ';
473: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
474:
475: l_ptp_id_indx BINARY_INTEGER;
476:
477: -- bug8568734

Line 586: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

582: AND ptp.Party_Type_Code = 'FIRST_PARTY';
583:
584: -- Logging Infra
585: l_procedure_name CONSTANT VARCHAR2(30) := '.GET_TAX_SUBSCRIBER';
586: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
587: l_tbl_index BINARY_INTEGER;
588:
589: -- BUG 8568734
590: CURSOR get_ou_name_csr IS

Line 858: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

854: WHERE organization_id = p_org_id;
855:
856: -- Logging Infra
857: l_procedure_name CONSTANT VARCHAR2(30) := '.GET_LOCATION_ID';
858: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
859:
860: l_party_name VARCHAR2(240);
861:
862: BEGIN

Line 978: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

974: l_tax_registration_id ZX_REGISTRATIONS.REGISTRATION_ID%TYPE;
975:
976: -- Logging Infra
977: l_procedure_name CONSTANT VARCHAR2(30) := '.CHECK_TAX_REGISTRATIONS';
978: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
979:
980: CURSOR c_get_reg_id
981: IS
982: SELECT registration_id

Line 1186: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1182: WHERE legal_registration_id = p_le_old_reg_id;
1183:
1184: -- Logging Infra
1185: l_procedure_name CONSTANT VARCHAR2(30) := 'SYNC_TAX_REGISTRATIONS';
1186: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1187:
1188: BEGIN
1189:
1190: -- Logging Infra: Setting up runtime level

Line 1635: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1631: WHERE ptp.party_id = p_party_id
1632: AND ptp.party_type_code = p_party_type_code;
1633:
1634: l_tbl_index binary_integer;
1635: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1636:
1637: BEGIN
1638:
1639: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1744: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1740: ptp.rounding_rule_code
1741: FROM zx_party_tax_profile ptp
1742: WHERE party_tax_profile_id = p_party_tax_profile_id;
1743:
1744: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1745: l_tbl_index binary_integer;
1746:
1747: BEGIN
1748: