eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_REGISTRATIONS_PKG dependencies on ARP_UTIL_TAX

Line 85: arp_util_tax.debug('Error: "No Party created in ZX_PARTY_TAX_PROFILE for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

81: from ZX_PARTY_TAX_PROFILE
82: where PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;
83: EXCEPTION WHEN NO_DATA_FOUND THEN
84: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
85: arp_util_tax.debug('Error: "No Party created in ZX_PARTY_TAX_PROFILE for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
86: END;
87: --Effective From cannot be null
88: IF P_EFFECTIVE_FROM IS NULL THEN
89: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 90: arp_util_tax.debug('Error: "Effective From cannot be null for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

86: END;
87: --Effective From cannot be null
88: IF P_EFFECTIVE_FROM IS NULL THEN
89: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
90: arp_util_tax.debug('Error: "Effective From cannot be null for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
91: END IF;
92: --Tax Regime Code cannot be null
93: IF P_TAX_REGIME_CODE IS NULL THEN
94: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 95: arp_util_tax.debug('Error: "Tax Regime Code cannot be null for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

91: END IF;
92: --Tax Regime Code cannot be null
93: IF P_TAX_REGIME_CODE IS NULL THEN
94: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
95: arp_util_tax.debug('Error: "Tax Regime Code cannot be null for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
96: END IF;
97: IF (P_EFFECTIVE_FROM IS NOT NULL) AND (P_EFFECTIVE_FROM > P_EFFECTIVE_TO) THEN
98: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
99: arp_util_tax.debug('Error: "The Effective To date must be the same as or after the Effective From date. for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

Line 99: arp_util_tax.debug('Error: "The Effective To date must be the same as or after the Effective From date. for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

95: arp_util_tax.debug('Error: "Tax Regime Code cannot be null for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
96: END IF;
97: IF (P_EFFECTIVE_FROM IS NOT NULL) AND (P_EFFECTIVE_FROM > P_EFFECTIVE_TO) THEN
98: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
99: arp_util_tax.debug('Error: "The Effective To date must be the same as or after the Effective From date. for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
100: END IF;
101: IF (P_TAX IS NULL) AND (P_TAX_JURISDICTION_CODE IS NOT NULL) THEN
102: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
103: arp_util_tax.debug('Error: "Tax must be entered if the Tax Jursidiction Code has been specified for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

Line 103: arp_util_tax.debug('Error: "Tax must be entered if the Tax Jursidiction Code has been specified for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

99: arp_util_tax.debug('Error: "The Effective To date must be the same as or after the Effective From date. for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
100: END IF;
101: IF (P_TAX IS NULL) AND (P_TAX_JURISDICTION_CODE IS NOT NULL) THEN
102: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
103: arp_util_tax.debug('Error: "Tax must be entered if the Tax Jursidiction Code has been specified for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
104: END IF;
105: --Tax is mandatory when Jurisdiction is not null
106: IF (P_TAX_REGIME_CODE IS NOT NULL) AND (P_PARTY_TAX_PROFILE_ID IS NOT NULL) THEN
107: --Registration should be unique

Line 150: arp_util_tax.debug('Error: "The registration details already exist for this party for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

146: END;
147: END IF;
148: IF L_REG_ID IS NOT NULL THEN
149: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
150: arp_util_tax.debug('Error: "The registration details already exist for this party for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
151: END IF;
152: IF L_REG_ID1 IS NOT NULL THEN
153: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
154: arp_util_tax.debug('Error: "This party already has a registration for this Jurisdiction for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

Line 154: arp_util_tax.debug('Error: "This party already has a registration for this Jurisdiction for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

150: arp_util_tax.debug('Error: "The registration details already exist for this party for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
151: END IF;
152: IF L_REG_ID1 IS NOT NULL THEN
153: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
154: arp_util_tax.debug('Error: "This party already has a registration for this Jurisdiction for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
155: END IF;
156: --If the registration is marked as default, then registration number must be entered.
157: IF P_DEFAULT_REGISTRATION_FLAG = 'Y' AND P_REGISTRATION_NUMBER IS NULL THEN
158: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 159: arp_util_tax.debug('Error: "Tax Registration Number is not valid for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

155: END IF;
156: --If the registration is marked as default, then registration number must be entered.
157: IF P_DEFAULT_REGISTRATION_FLAG = 'Y' AND P_REGISTRATION_NUMBER IS NULL THEN
158: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
159: arp_util_tax.debug('Error: "Tax Registration Number is not valid for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
160: --Check RegistrationNumber validity
161: ELSIF (P_REGISTRATION_NUMBER IS NOT NULL AND P_LEGAL_REGISTRATION_ID IS NULL) THEN
162: BEGIN
163: BEGIN

Line 170: arp_util_tax.debug('Error: "No CountryCOde exists in ZX_REGIMES_B for the Registration with Regime : "

166: FROM ZX_REGIMES_B
167: WHERE TAX_REGIME_CODE = P_TAX_REGIME_CODE;
168: EXCEPTION WHEN NO_DATA_FOUND THEN
169: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
170: arp_util_tax.debug('Error: "No CountryCOde exists in ZX_REGIMES_B for the Registration with Regime : "
171: ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
172: END;
173: /*
174: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN

Line 192: arp_util_tax.debug('Error: "Registration Number is invalid for the Registration with Regime : "

188: */
189: x_return_status1 := 'S'; -- P1
190: IF x_return_status1 <> 'S' THEN
191: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
192: arp_util_tax.debug('Error: "Registration Number is invalid for the Registration with Regime : "
193: ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
194: END IF;
195: END;
196: END IF;

Line 212: arp_util_tax.debug('Error: "Already a Regiatration has been defaulted for Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

208: WHERE PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID
209: ;
210: ELSE
211: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
212: arp_util_tax.debug('Error: "Already a Regiatration has been defaulted for Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
213: END IF;
214: CLOSE default_reg_cur;
215: END IF;--end P_DEFAULT_REGISTRATION_FLAG
216: --Insert only when there is no error

Line 336: arp_util_tax.debug('Error: "The Registration row has not been inserted for Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

332: IF (reg_cur%notfound) then
333: CLOSE reg_cur;
334: --Set x_return_status param
335: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
336: arp_util_tax.debug('Error: "The Registration row has not been inserted for Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
337: END IF;--end reg_cur%notfound
338: CLOSE reg_cur;
339: END IF;--end X_RETURN_STATUS
340: EXCEPTION

Line 345: arp_util_tax.debug('Error: "The Registration row already exists for Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

341: --Index violation check
342: WHEN DUP_VAL_ON_INDEX THEN
343: --Set x_return_status param
344: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
345: arp_util_tax.debug('Error: "The Registration row already exists for Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
346: end INSERT_ROW;
347:
348: procedure UPDATE_ROW (
349: P_REGISTRATION_ID in NUMBER,

Line 422: arp_util_tax.debug('Error: "Effective From cannot be null for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

418: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
419: --Effective From cannot be null
420: IF P_EFFECTIVE_FROM IS NULL THEN
421: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
422: arp_util_tax.debug('Error: "Effective From cannot be null for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
423: END IF;
424: --Tax Regime Code cannot be null
425: IF P_TAX_REGIME_CODE IS NULL THEN
426: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 427: arp_util_tax.debug('Error: "Tax Regime Code cannot be null for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

423: END IF;
424: --Tax Regime Code cannot be null
425: IF P_TAX_REGIME_CODE IS NULL THEN
426: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
427: arp_util_tax.debug('Error: "Tax Regime Code cannot be null for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
428: END IF;
429: IF (P_EFFECTIVE_FROM IS NOT NULL) AND (P_EFFECTIVE_FROM > P_EFFECTIVE_TO) THEN
430: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
431: arp_util_tax.debug('Error: "The Effective To date must be the same as or after the Effective From date. for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

Line 431: arp_util_tax.debug('Error: "The Effective To date must be the same as or after the Effective From date. for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

427: arp_util_tax.debug('Error: "Tax Regime Code cannot be null for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
428: END IF;
429: IF (P_EFFECTIVE_FROM IS NOT NULL) AND (P_EFFECTIVE_FROM > P_EFFECTIVE_TO) THEN
430: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
431: arp_util_tax.debug('Error: "The Effective To date must be the same as or after the Effective From date. for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
432: END IF;
433: --Tax is mandatory when Jurisdiction is not null
434: IF (P_TAX IS NULL) AND (P_TAX_JURISDICTION_CODE IS NOT NULL) THEN
435: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 436: arp_util_tax.debug('Error: "Tax must be entered if the Tax Jursidiction Code has been specified for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

432: END IF;
433: --Tax is mandatory when Jurisdiction is not null
434: IF (P_TAX IS NULL) AND (P_TAX_JURISDICTION_CODE IS NOT NULL) THEN
435: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
436: arp_util_tax.debug('Error: "Tax must be entered if the Tax Jursidiction Code has been specified for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
437: END IF;
438: IF (P_TAX_REGIME_CODE IS NOT NULL) AND (P_PARTY_TAX_PROFILE_ID IS NOT NULL) THEN
439: --Registration should be unique
440: BEGIN

Line 484: arp_util_tax.debug('Error: "The registration details already exist for this party for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

480: END;
481: END IF;
482: IF L_REG_ID IS NOT NULL THEN
483: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
484: arp_util_tax.debug('Error: "The registration details already exist for this party for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
485: END IF;
486: IF L_REG_ID1 IS NOT NULL THEN
487: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
488: arp_util_tax.debug('Error: "This party already has a registration for this Jurisdiction for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

Line 488: arp_util_tax.debug('Error: "This party already has a registration for this Jurisdiction for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

484: arp_util_tax.debug('Error: "The registration details already exist for this party for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
485: END IF;
486: IF L_REG_ID1 IS NOT NULL THEN
487: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
488: arp_util_tax.debug('Error: "This party already has a registration for this Jurisdiction for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
489: END IF;
490: --If Registration has active exemptions then it cannot be end dated.
491: -----Commented out since exemption is not based on registrations
492: /*IF P_EFFECTIVE_TO IS NOT NULL THEN

Line 497: arp_util_tax.debug('Error: "ZX_EXEMPT_EXISTS_FOR_REG for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

493: FOR exempt_rec IN exempt_cur LOOP
494: IF exempt_rec.EFFECTIVE_TO IS NOT NULL THEN
495: IF P_EFFECTIVE_TO < exempt_rec.EFFECTIVE_TO THEN
496: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
497: arp_util_tax.debug('Error: "ZX_EXEMPT_EXISTS_FOR_REG for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
498: EXIT;
499: END IF;
500: ELSE --exempt_rec.EFFECTIVE_TO IS NULL
501: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 502: arp_util_tax.debug('Error: "ZX_EXEMPT_EXISTS_FOR_REG for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

498: EXIT;
499: END IF;
500: ELSE --exempt_rec.EFFECTIVE_TO IS NULL
501: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
502: arp_util_tax.debug('Error: "ZX_EXEMPT_EXISTS_FOR_REG for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
503: EXIT;
504: END IF; -- exempt_rec.EFFECTIVE_TO
505: END LOOP;
506: END IF; -- end P_EFFECTIVE_TO

Line 522: arp_util_tax.debug('Error: "Already a Regiatration has been defaulted for Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

518: WHERE PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;
519:
520: ELSE
521: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
522: arp_util_tax.debug('Error: "Already a Regiatration has been defaulted for Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
523: END IF;
524: CLOSE default_reg_cur;
525: END IF;--end P_DEFAULT_REGISTRATION_FLAG
526: --Update only when there is no error

Line 584: arp_util_tax.debug('Error: "The Registration row has not been updated for Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

580: where REGISTRATION_ID = P_REGISTRATION_ID;
581: if (sql%notfound) then
582: --Set x_return_status param
583: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
584: arp_util_tax.debug('Error: "The Registration row has not been updated for Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
585: end if;--end sql%notfound
586: END IF;--end X_RETURN_STATUS
587: end UPDATE_ROW;
588: