APPS.HZ_PARTY_V2PUB dependencies on ZX_PARTY_TAX_PROFILE

Line 2791: L_PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

2787: l_msg_data varchar2(2000);
2788: l_created_by_module varchar2(150);
2789:
2790: -- Bug 4490715 : Used to store party_tax_profile_id for update
2791: L_PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
2792:
2793: CURSOR c_party IS
2794: SELECT party_name, object_version_number, rowid,
2795: created_by_module

Line 3302: -- procedure to populate ZX_PARTY_TAX_PROFILE

3298: x_party_id := l_party_rec.party_id;
3299: x_party_number := l_party_rec.party_number;
3300:
3301: -- Bug 4490715 : If party is PERSON / ORGANIZATION call eTax
3302: -- procedure to populate ZX_PARTY_TAX_PROFILE
3303: IF p_party_type IN ('PERSON', 'ORGANIZATION') THEN
3304: ZX_PARTY_TAX_PROFILE_PKG.insert_row (
3305: P_COLLECTING_AUTHORITY_FLAG => null,
3306: P_PROVIDER_TYPE_CODE => null,

Line 3304: ZX_PARTY_TAX_PROFILE_PKG.insert_row (

3300:
3301: -- Bug 4490715 : If party is PERSON / ORGANIZATION call eTax
3302: -- procedure to populate ZX_PARTY_TAX_PROFILE
3303: IF p_party_type IN ('PERSON', 'ORGANIZATION') THEN
3304: ZX_PARTY_TAX_PROFILE_PKG.insert_row (
3305: P_COLLECTING_AUTHORITY_FLAG => null,
3306: P_PROVIDER_TYPE_CODE => null,
3307: P_CREATE_AWT_DISTS_TYPE_CODE => null,
3308: P_CREATE_AWT_INVOICES_TYPE_COD => null,

Line 3490: -- procedure to populate ZX_PARTY_TAX_PROFILE

3486: p_msg_level=>fnd_log.level_procedure);
3487: END IF;
3488:
3489: -- Bug 4490715 : If party is PERSON / ORGANIZATION call eTax
3490: -- procedure to populate ZX_PARTY_TAX_PROFILE
3491: -- Call only when tax_reference is not NULL
3492: IF l_party_dup_rec.tax_reference IS NOT NULL THEN
3493: IF p_party_type IN ('PERSON', 'ORGANIZATION') THEN
3494: BEGIN

Line 3497: FROM ZX_PARTY_TAX_PROFILE

3493: IF p_party_type IN ('PERSON', 'ORGANIZATION') THEN
3494: BEGIN
3495: -- Get PARTY_TAX_PROFILE_ID to pass to update procedure
3496: SELECT PARTY_TAX_PROFILE_ID INTO L_PARTY_TAX_PROFILE_ID
3497: FROM ZX_PARTY_TAX_PROFILE
3498: WHERE PARTY_ID = p_party_id
3499: AND PARTY_TYPE_CODE = 'THIRD_PARTY'
3500: AND ROWNUM = 1;
3501: EXCEPTION

Line 3504: fnd_message.set_token('RECORD', 'ZX_PARTY_TAX_PROFILE');

3500: AND ROWNUM = 1;
3501: EXCEPTION
3502: WHEN NO_DATA_FOUND THEN
3503: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
3504: fnd_message.set_token('RECORD', 'ZX_PARTY_TAX_PROFILE');
3505: fnd_message.set_token('VALUE', to_char(p_party_id) || ', THIRD_PARTY');
3506: fnd_msg_pub.add;
3507: RAISE FND_API.G_EXC_ERROR;
3508: END;

Line 3510: ZX_PARTY_TAX_PROFILE_PKG.update_row (

3506: fnd_msg_pub.add;
3507: RAISE FND_API.G_EXC_ERROR;
3508: END;
3509:
3510: ZX_PARTY_TAX_PROFILE_PKG.update_row (
3511: P_PARTY_TAX_PROFILE_ID => L_PARTY_TAX_PROFILE_ID,
3512: P_COLLECTING_AUTHORITY_FLAG => null,
3513: P_PROVIDER_TYPE_CODE => null,
3514: P_CREATE_AWT_DISTS_TYPE_CODE => null,