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 FND_API

Line 76: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

72: WHERE PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID
73: AND DEFAULT_REGISTRATION_FLAG = 'Y';
74: begin
75: --Initialise x_return_status variable
76: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
77: --Inclusive_tax_flag, ROUNDING_RULE_CODE and self_assess_flag for tax registrations are defaulted primary from party tax profile.
78: BEGIN
79: select INCLUSIVE_TAX_FLAG, SELF_ASSESS_FLAG, ROUNDING_RULE_CODE, PARTY_TYPE_CODE
80: INTO L_INCLUSIVE_TAX_FLAG, L_SELF_ASSESS_FLAG, L_ROUNDING_RULE_CODE, L_PARTY_TYPE_CODE

Line 84: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

80: INTO L_INCLUSIVE_TAX_FLAG, L_SELF_ASSESS_FLAG, L_ROUNDING_RULE_CODE, L_PARTY_TYPE_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

Line 89: 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;
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

Line 94: 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;
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;

Line 98: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
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;

Line 102: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
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

Line 149: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

145: NULL;
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;

Line 153: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
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

Line 158: 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;
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

Line 169: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

165: INTO L_COUNTRY_CODE
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: /*

Line 191: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

187: );
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;

Line 203: IF (default_reg_cur%notfound) AND (X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS) then

199: IF P_DEFAULT_REGISTRATION_FLAG = 'Y' THEN
200: OPEN default_reg_cur;
201: FETCH default_reg_cur INTO L_DEF_REGISTRATION_ID;
202: --If this is the only defaulted registration then update PTP
203: IF (default_reg_cur%notfound) AND (X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS) then
204: --Update PTP
205: UPDATE ZX_PARTY_TAX_PROFILE
206: SET Rep_Registration_Number = P_REGISTRATION_NUMBER,
207: Object_Version_Number = Object_Version_Number + 1

Line 211: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

207: Object_Version_Number = Object_Version_Number + 1
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

Line 217: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN

213: END IF;
214: CLOSE default_reg_cur;
215: END IF;--end P_DEFAULT_REGISTRATION_FLAG
216: --Insert only when there is no error
217: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
218: select ZX_REGISTRATIONS_S.nextval into L_REGISTRATION_ID from dual;
219: insert into ZX_REGISTRATIONS (
220: REQUEST_ID,
221: ATTRIBUTE1,

Line 335: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

331: FETCH reg_cur INTO L_REGISTRATION_ID;
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

Line 344: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

340: EXCEPTION
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 (

Line 418: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

414: AND DEFAULT_REGISTRATION_FLAG = 'Y'
415: AND REGISTRATION_ID <> P_REGISTRATION_ID;
416: begin
417: --Initialise x_return_status variable
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);

Line 421: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

417: --Initialise x_return_status variable
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

Line 426: 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;
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;

Line 430: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
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

Line 435: 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;
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

Line 483: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

479: NULL;
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;

Line 487: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
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

Line 496: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

492: /*IF P_EFFECTIVE_TO IS NOT NULL THEN
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

Line 501: 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;
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;

Line 514: IF (default_reg_cur%notfound) AND (X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS) then

510: IF P_DEFAULT_REGISTRATION_FLAG = 'Y' THEN
511: OPEN default_reg_cur;
512: FETCH default_reg_cur INTO L_DEF_REGISTRATION_ID;
513: --If this is the only defaulted registration then update PTP
514: IF (default_reg_cur%notfound) AND (X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS) then
515: --Update PTP
516: UPDATE ZX_PARTY_TAX_PROFILE SET Rep_Registration_Number = P_REGISTRATION_NUMBER,
517: Object_Version_Number = Object_Version_Number + 1
518: WHERE PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;

Line 521: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

517: Object_Version_Number = Object_Version_Number + 1
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

Line 527: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN

523: END IF;
524: CLOSE default_reg_cur;
525: END IF;--end P_DEFAULT_REGISTRATION_FLAG
526: --Update only when there is no error
527: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
528: update ZX_REGISTRATIONS set
529: REQUEST_ID = DECODE( P_REQUEST_ID, NULL, REQUEST_ID, P_REQUEST_ID ),
530: ATTRIBUTE1 = DECODE( P_ATTRIBUTE1, NULL, ATTRIBUTE1, P_ATTRIBUTE1 ),
531: ATTRIBUTE2 = DECODE( P_ATTRIBUTE2, NULL, ATTRIBUTE2, P_ATTRIBUTE2 ),

Line 583: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

579: Object_Version_Number = Object_Version_Number + 1
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;

Line 595: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

591: X_RETURN_STATUS out NOCOPY VARCHAR2
592: ) is
593: begin
594: --Initialise x_return_status variable
595: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
596: --Delete the row
597: delete from ZX_REGISTRATIONS
598: where REGISTRATION_ID = P_REGISTRATION_ID;
599:

Line 602: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

598: where REGISTRATION_ID = P_REGISTRATION_ID;
599:
600: if (sql%notfound) then
601: --Set x_return_status param
602: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
603: raise no_data_found;
604: end if;
605: end DELETE_ROW;
606: