APPS.HZ_PARTY_V2PUB dependencies on ZX_PARTY_TAX_PROFILE

Line 2740: L_PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

2736: l_msg_data varchar2(2000);
2737: l_created_by_module varchar2(150);
2738:
2739: -- Bug 4490715 : Used to store party_tax_profile_id for update
2740: L_PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
2741:
2742: CURSOR c_party IS
2743: SELECT party_name, object_version_number, rowid,
2744: created_by_module

Line 3251: -- procedure to populate ZX_PARTY_TAX_PROFILE

3247: x_party_id := l_party_rec.party_id;
3248: x_party_number := l_party_rec.party_number;
3249:
3250: -- Bug 4490715 : If party is PERSON / ORGANIZATION call eTax
3251: -- procedure to populate ZX_PARTY_TAX_PROFILE
3252: IF p_party_type IN ('PERSON', 'ORGANIZATION') THEN
3253: ZX_PARTY_TAX_PROFILE_PKG.insert_row (
3254: P_COLLECTING_AUTHORITY_FLAG => null,
3255: P_PROVIDER_TYPE_CODE => null,

Line 3253: ZX_PARTY_TAX_PROFILE_PKG.insert_row (

3249:
3250: -- Bug 4490715 : If party is PERSON / ORGANIZATION call eTax
3251: -- procedure to populate ZX_PARTY_TAX_PROFILE
3252: IF p_party_type IN ('PERSON', 'ORGANIZATION') THEN
3253: ZX_PARTY_TAX_PROFILE_PKG.insert_row (
3254: P_COLLECTING_AUTHORITY_FLAG => null,
3255: P_PROVIDER_TYPE_CODE => null,
3256: P_CREATE_AWT_DISTS_TYPE_CODE => null,
3257: P_CREATE_AWT_INVOICES_TYPE_COD => null,

Line 3439: -- procedure to populate ZX_PARTY_TAX_PROFILE

3435: p_msg_level=>fnd_log.level_procedure);
3436: END IF;
3437:
3438: -- Bug 4490715 : If party is PERSON / ORGANIZATION call eTax
3439: -- procedure to populate ZX_PARTY_TAX_PROFILE
3440: -- Call only when tax_reference is not NULL
3441: IF l_party_dup_rec.tax_reference IS NOT NULL THEN
3442: IF p_party_type IN ('PERSON', 'ORGANIZATION') THEN
3443: BEGIN

Line 3446: FROM ZX_PARTY_TAX_PROFILE

3442: IF p_party_type IN ('PERSON', 'ORGANIZATION') THEN
3443: BEGIN
3444: -- Get PARTY_TAX_PROFILE_ID to pass to update procedure
3445: SELECT PARTY_TAX_PROFILE_ID INTO L_PARTY_TAX_PROFILE_ID
3446: FROM ZX_PARTY_TAX_PROFILE
3447: WHERE PARTY_ID = p_party_id
3448: AND PARTY_TYPE_CODE = 'THIRD_PARTY'
3449: AND ROWNUM = 1;
3450: EXCEPTION

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

3449: AND ROWNUM = 1;
3450: EXCEPTION
3451: WHEN NO_DATA_FOUND THEN
3452: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
3453: fnd_message.set_token('RECORD', 'ZX_PARTY_TAX_PROFILE');
3454: fnd_message.set_token('VALUE', to_char(p_party_id) || ', THIRD_PARTY');
3455: fnd_msg_pub.add;
3456: RAISE FND_API.G_EXC_ERROR;
3457: END;

Line 3459: ZX_PARTY_TAX_PROFILE_PKG.update_row (

3455: fnd_msg_pub.add;
3456: RAISE FND_API.G_EXC_ERROR;
3457: END;
3458:
3459: ZX_PARTY_TAX_PROFILE_PKG.update_row (
3460: P_PARTY_TAX_PROFILE_ID => L_PARTY_TAX_PROFILE_ID,
3461: P_COLLECTING_AUTHORITY_FLAG => null,
3462: P_PROVIDER_TYPE_CODE => null,
3463: P_CREATE_AWT_DISTS_TYPE_CODE => null,