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_PARTY_TAX_PROFILE_PKG dependencies on FND_API

Line 57: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

53: CURSOR ptp_cur IS SELECT PARTY_TAX_PROFILE_ID FROM ZX_PARTY_TAX_PROFILE
54: WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;
55: begin
56: --Initialise x_return_status variable
57: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
58: select ZX_PARTY_TAX_PROFILE_S.nextval into L_PARTY_TAX_PROFILE_ID from dual;
59: --Perform validations before inserting data
60: --AllowOffsetTax and SetforSelfAssessment flag would be mutually exclusive
61: BEGIN

Line 73: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

69: EXCEPTION
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

Line 81: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN

77: IF P_USE_LE_AS_SUBSCRIBER_FLAG = 'Y' THEN
78: L_EFFECTIVE_FROM_USE_LE := SYSDATE;
79: END IF;
80: --Insert only when there is no error
81: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
82: insert into ZX_PARTY_TAX_PROFILE (
83: COLLECTING_AUTHORITY_FLAG,
84: PROVIDER_TYPE_CODE,
85: CREATE_AWT_DISTS_TYPE_CODE,

Line 141: DECODE(P_REP_REGISTRATION_NUMBER, fnd_api.g_miss_char,

137: P_CREATE_AWT_INVOICES_TYPE_COD,
138: P_TAX_CLASSIFICATION_CODE,
139: P_SELF_ASSESS_FLAG,
140: P_ALLOW_OFFSET_TAX_FLAG,
141: DECODE(P_REP_REGISTRATION_NUMBER, fnd_api.g_miss_char,
142: NULL, P_REP_REGISTRATION_NUMBER),
143: L_EFFECTIVE_FROM_USE_LE,
144: P_RECORD_TYPE_CODE,
145: P_REQUEST_ID,

Line 190: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

186: OPEN ptp_cur;
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;

Line 199: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

195: EXCEPTION
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:

Line 259: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

255: CURSOR ptp_cur IS SELECT PARTY_TAX_PROFILE_ID FROM ZX_PARTY_TAX_PROFILE
256: WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;
257: begin
258: --Initialise x_return_status variable
259: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
260: select ZX_PARTY_TAX_PROFILE_S.nextval into L_PARTY_TAX_PROFILE_ID from dual;
261: BEGIN
262: -- Check created module name
263: select nvl(substr(created_by_module,1,3),'ZX') created_by_module

Line 275: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

271: END;
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

Line 283: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN

279: IF P_USE_LE_AS_SUBSCRIBER_FLAG = 'Y' THEN
280: L_EFFECTIVE_FROM_USE_LE := SYSDATE;
281: END IF;
282: --Insert only when there is no error
283: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
284: insert into ZX_PARTY_TAX_PROFILE (
285: COLLECTING_AUTHORITY_FLAG,
286: PROVIDER_TYPE_CODE,
287: CREATE_AWT_DISTS_TYPE_CODE,

Line 345: DECODE(P_REP_REGISTRATION_NUMBER, fnd_api.g_miss_char,

341: P_CREATE_AWT_INVOICES_TYPE_COD,
342: P_TAX_CLASSIFICATION_CODE,
343: P_SELF_ASSESS_FLAG,
344: P_ALLOW_OFFSET_TAX_FLAG,
345: DECODE(P_REP_REGISTRATION_NUMBER, fnd_api.g_miss_char,
346: NULL, P_REP_REGISTRATION_NUMBER),
347: L_EFFECTIVE_FROM_USE_LE,
348: P_RECORD_TYPE_CODE,
349: P_REQUEST_ID,

Line 396: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

392: OPEN ptp_cur;
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;

Line 405: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

401: EXCEPTION
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:

Line 460: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

456: ) is
457: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;
458: begin
459: --Initialise x_return_status variable
460: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
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;

Line 464: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

460: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
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

Line 474: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN

470: ELSE
471: L_EFFECTIVE_FROM_USE_LE := NULL;
472: END IF;
473: --Update only when there is no error
474: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
475: update ZX_PARTY_TAX_PROFILE set
476: COLLECTING_AUTHORITY_FLAG = DECODE( P_COLLECTING_AUTHORITY_FLAG, NULL, COLLECTING_AUTHORITY_FLAG, P_COLLECTING_AUTHORITY_FLAG ),
477: PROVIDER_TYPE_CODE = DECODE( P_PROVIDER_TYPE_CODE, NULL, PROVIDER_TYPE_CODE, P_PROVIDER_TYPE_CODE ),
478: CREATE_AWT_DISTS_TYPE_CODE = DECODE( P_CREATE_AWT_DISTS_TYPE_CODE, NULL, CREATE_AWT_DISTS_TYPE_CODE, P_CREATE_AWT_DISTS_TYPE_CODE ),

Line 483: REP_REGISTRATION_NUMBER = DECODE( P_REP_REGISTRATION_NUMBER, NULL, REP_REGISTRATION_NUMBER,fnd_api.g_miss_char, NULL, P_REP_REGISTRATION_NUMBER ),

479: CREATE_AWT_INVOICES_TYPE_CODE = DECODE( P_CREATE_AWT_INVOICES_TYPE_COD, NULL, CREATE_AWT_INVOICES_TYPE_CODE, P_CREATE_AWT_INVOICES_TYPE_COD ),
480: TAX_CLASSIFICATION_CODE = DECODE( P_TAX_CLASSIFICATION_CODE, NULL, TAX_CLASSIFICATION_CODE, P_TAX_CLASSIFICATION_CODE ),
481: SELF_ASSESS_FLAG = DECODE( P_SELF_ASSESS_FLAG, NULL, SELF_ASSESS_FLAG, P_SELF_ASSESS_FLAG ),
482: ALLOW_OFFSET_TAX_FLAG = DECODE( P_ALLOW_OFFSET_TAX_FLAG, NULL, ALLOW_OFFSET_TAX_FLAG, P_ALLOW_OFFSET_TAX_FLAG ),
483: REP_REGISTRATION_NUMBER = DECODE( P_REP_REGISTRATION_NUMBER, NULL, REP_REGISTRATION_NUMBER,fnd_api.g_miss_char, NULL, P_REP_REGISTRATION_NUMBER ),
484: EFFECTIVE_FROM_USE_LE = DECODE( L_EFFECTIVE_FROM_USE_LE, NULL, EFFECTIVE_FROM_USE_LE, L_EFFECTIVE_FROM_USE_LE ),
485: RECORD_TYPE_CODE = DECODE( P_RECORD_TYPE_CODE, NULL, RECORD_TYPE_CODE, P_RECORD_TYPE_CODE ),
486: REQUEST_ID = DECODE( P_REQUEST_ID, NULL, REQUEST_ID, P_REQUEST_ID ),
487: ATTRIBUTE1 = DECODE( P_ATTRIBUTE1, NULL, ATTRIBUTE1, P_ATTRIBUTE1 ),

Line 526: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

522: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
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;

Line 584: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

580: ) is
581: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;
582: begin
583: --Initialise x_return_status variable
584: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
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;

Line 588: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

584: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
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

Line 598: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN

594: ELSE
595: L_EFFECTIVE_FROM_USE_LE := NULL;
596: END IF;
597: --Update only when there is no error
598: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
599: update ZX_PARTY_TAX_PROFILE set
600: COLLECTING_AUTHORITY_FLAG = DECODE( P_COLLECTING_AUTHORITY_FLAG, NULL, COLLECTING_AUTHORITY_FLAG, P_COLLECTING_AUTHORITY_FLAG ),
601: PROVIDER_TYPE_CODE = DECODE( P_PROVIDER_TYPE_CODE, NULL, PROVIDER_TYPE_CODE, P_PROVIDER_TYPE_CODE ),
602: CREATE_AWT_DISTS_TYPE_CODE = DECODE( P_CREATE_AWT_DISTS_TYPE_CODE, NULL, CREATE_AWT_DISTS_TYPE_CODE, P_CREATE_AWT_DISTS_TYPE_CODE ),

Line 607: REP_REGISTRATION_NUMBER = DECODE( P_REP_REGISTRATION_NUMBER, NULL, REP_REGISTRATION_NUMBER,fnd_api.g_miss_char, NULL, P_REP_REGISTRATION_NUMBER ),

603: CREATE_AWT_INVOICES_TYPE_CODE = DECODE( P_CREATE_AWT_INVOICES_TYPE_COD, NULL, CREATE_AWT_INVOICES_TYPE_CODE, P_CREATE_AWT_INVOICES_TYPE_COD ),
604: TAX_CLASSIFICATION_CODE = DECODE( P_TAX_CLASSIFICATION_CODE, NULL, TAX_CLASSIFICATION_CODE, P_TAX_CLASSIFICATION_CODE ),
605: SELF_ASSESS_FLAG = DECODE( P_SELF_ASSESS_FLAG, NULL, SELF_ASSESS_FLAG, P_SELF_ASSESS_FLAG ),
606: ALLOW_OFFSET_TAX_FLAG = DECODE( P_ALLOW_OFFSET_TAX_FLAG, NULL, ALLOW_OFFSET_TAX_FLAG, P_ALLOW_OFFSET_TAX_FLAG ),
607: REP_REGISTRATION_NUMBER = DECODE( P_REP_REGISTRATION_NUMBER, NULL, REP_REGISTRATION_NUMBER,fnd_api.g_miss_char, NULL, P_REP_REGISTRATION_NUMBER ),
608: EFFECTIVE_FROM_USE_LE = DECODE( L_EFFECTIVE_FROM_USE_LE, NULL, EFFECTIVE_FROM_USE_LE, L_EFFECTIVE_FROM_USE_LE ),
609: RECORD_TYPE_CODE = DECODE( P_RECORD_TYPE_CODE, NULL, RECORD_TYPE_CODE, P_RECORD_TYPE_CODE ),
610: REQUEST_ID = DECODE( P_REQUEST_ID, NULL, REQUEST_ID, P_REQUEST_ID ),
611: ATTRIBUTE1 = DECODE( P_ATTRIBUTE1, NULL, ATTRIBUTE1, P_ATTRIBUTE1 ),

Line 652: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

648: COUNTRY_CODE = DECODE (P_COUNTRY_CODE,NULL, COUNTRY_CODE, P_COUNTRY_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;

Line 664: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

660: X_RETURN_STATUS out NOCOPY VARCHAR2
661: ) is
662: begin
663: --Initialise x_return_status variable
664: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
665: --Delete the row
666: delete from ZX_PARTY_TAX_PROFILE
667: where PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;
668:

Line 671: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

667: where PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;
668:
669: if (sql%notfound) then
670: --Set x_return_status param
671: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
672: raise no_data_found;
673: end if;
674: end DELETE_ROW;
675: