DBA Data[Home] [Help]

APPS.ZX_PARTY_TAX_PROFILE_PKG dependencies on ARP_UTIL_TAX

Line 74: arp_util_tax.debug('Error: "Offset Tax and Set for Self Assessment can not both be "Y" at the same time." for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE);

70: WHEN OTHERS THEN NULL;
71: END;
72: IF P_SELF_ASSESS_FLAG = 'Y' AND P_ALLOW_OFFSET_TAX_FLAG = 'Y' THEN
73: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
74: arp_util_tax.debug('Error: "Offset Tax and Set for Self Assessment can not both be "Y" at the same time." for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE);
75: END IF;
76: --when UseLeAsSubscriberFlag is set to 'Y', then setEffectiveFromUseLe as System date
77: IF P_USE_LE_AS_SUBSCRIBER_FLAG = 'Y' THEN
78: L_EFFECTIVE_FROM_USE_LE := SYSDATE;

Line 191: arp_util_tax.debug('Error: "The Ptp row has not been inserted for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE || '."');

187: FETCH ptp_cur INTO L_PARTY_TAX_PROFILE_ID;
188: IF (ptp_cur%notfound) then
189: --Set x_return_status param
190: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
191: arp_util_tax.debug('Error: "The Ptp row has not been inserted for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE || '."');
192: END IF;
193: CLOSE ptp_cur;
194: END IF;
195: EXCEPTION

Line 200: arp_util_tax.debug('Error: "The Ptp row already exists for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE || '."');

196: --Index violation check
197: WHEN DUP_VAL_ON_INDEX THEN
198: --Set x_return_status param
199: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
200: arp_util_tax.debug('Error: "The Ptp row already exists for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE || '."');
201: end INSERT_ROW;
202:
203:
204: procedure INSERT_ROW (

Line 276: arp_util_tax.debug('Error: "Offset Tax and Set for Self Assessment can not both be "Y" at the same time." for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE);

272: --Perform validations before inserting data
273: --AllowOffsetTax and SetforSelfAssessment flag would be mutually exclusive
274: IF P_SELF_ASSESS_FLAG = 'Y' AND P_ALLOW_OFFSET_TAX_FLAG = 'Y' THEN
275: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
276: arp_util_tax.debug('Error: "Offset Tax and Set for Self Assessment can not both be "Y" at the same time." for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE);
277: END IF;
278: --when UseLeAsSubscriberFlag is set to 'Y', then setEffectiveFromUseLe as System date
279: IF P_USE_LE_AS_SUBSCRIBER_FLAG = 'Y' THEN
280: L_EFFECTIVE_FROM_USE_LE := SYSDATE;

Line 397: arp_util_tax.debug('Error: "The Ptp row has not been inserted for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE || '."');

393: FETCH ptp_cur INTO L_PARTY_TAX_PROFILE_ID;
394: IF (ptp_cur%notfound) then
395: --Set x_return_status param
396: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
397: arp_util_tax.debug('Error: "The Ptp row has not been inserted for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE || '."');
398: END IF;
399: CLOSE ptp_cur;
400: END IF;
401: EXCEPTION

Line 406: arp_util_tax.debug('Error: "The Ptp row already exists for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE || '."');

402: --Index violation check
403: WHEN DUP_VAL_ON_INDEX THEN
404: --Set x_return_status param
405: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
406: arp_util_tax.debug('Error: "The Ptp row already exists for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE || '."');
407: end INSERT_ROW;
408:
409:
410: procedure UPDATE_ROW (

Line 465: arp_util_tax.debug('Error: "Offset Tax and Set for Self Assessment can not both be "Y" at the same time." for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE);

461: --Perform validations before inserting data
462: --AllowOffsetTax and SetforSelfAssessment flag would be mutually exclusive
463: IF P_SELF_ASSESS_FLAG = 'Y' AND P_ALLOW_OFFSET_TAX_FLAG = 'Y' THEN
464: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
465: arp_util_tax.debug('Error: "Offset Tax and Set for Self Assessment can not both be "Y" at the same time." for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE);
466: END IF;
467: --when UseLeAsSubscriberFlag is set to 'Y', then setEffectiveFromUseLe as System date
468: IF P_USE_LE_AS_SUBSCRIBER_FLAG = 'Y' THEN
469: L_EFFECTIVE_FROM_USE_LE := SYSDATE;

Line 527: arp_util_tax.debug('Error: "The Ptp row has not been updated for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE || '."');

523: where PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;
524: if (sql%notfound) then
525: --Set x_return_status param
526: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
527: arp_util_tax.debug('Error: "The Ptp row has not been updated for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE || '."');
528: end if;--end sql%notfound
529: end if;--end X_RETURN_STATUS
530: end UPDATE_ROW;
531:

Line 589: arp_util_tax.debug('Error: "Offset Tax and Set for Self Assessment can not both be "Y" at the same time." for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE);

585: --Perform validations before inserting data
586: --AllowOffsetTax and SetforSelfAssessment flag would be mutually exclusive
587: IF P_SELF_ASSESS_FLAG = 'Y' AND P_ALLOW_OFFSET_TAX_FLAG = 'Y' THEN
588: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
589: arp_util_tax.debug('Error: "Offset Tax and Set for Self Assessment can not both be "Y" at the same time." for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE);
590: END IF;
591: --when UseLeAsSubscriberFlag is set to 'Y', then setEffectiveFromUseLe as System date
592: IF P_USE_LE_AS_SUBSCRIBER_FLAG = 'Y' THEN
593: L_EFFECTIVE_FROM_USE_LE := SYSDATE;

Line 653: arp_util_tax.debug('Error: "The Ptp row has not been updated for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE || '."');

649: where PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;
650: if (sql%notfound) then
651: --Set x_return_status param
652: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
653: arp_util_tax.debug('Error: "The Ptp row has not been updated for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE || '."');
654: end if;--end sql%notfound
655: end if;--end X_RETURN_STATUS
656: end UPDATE_ROW;
657: