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

160: WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;
161:
162: begin
163: --Initialise x_return_status variable
164: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
165: select ZX_PARTY_TAX_PROFILE_S.nextval into L_PARTY_TAX_PROFILE_ID from dual;
166:
167: -- commenting out for bug 10236399
168: -- BEGIN

Line 184: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

180:
181: --Perform validations before inserting data
182: --AllowOffsetTax and SetforSelfAssessment flag would be mutually exclusive
183: IF P_SELF_ASSESS_FLAG = 'Y' AND P_ALLOW_OFFSET_TAX_FLAG = 'Y' THEN
184: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
185: 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);
186: END IF;
187: --when UseLeAsSubscriberFlag is set to 'Y', then setEffectiveFromUseLe as System date
188: IF P_USE_LE_AS_SUBSCRIBER_FLAG = 'Y' THEN

Line 192: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN

188: IF P_USE_LE_AS_SUBSCRIBER_FLAG = 'Y' THEN
189: L_EFFECTIVE_FROM_USE_LE := SYSDATE;
190: END IF;
191: --Insert only when there is no error
192: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
193: insert into ZX_PARTY_TAX_PROFILE (
194: COLLECTING_AUTHORITY_FLAG,
195: PROVIDER_TYPE_CODE,
196: CREATE_AWT_DISTS_TYPE_CODE,

Line 254: DECODE(P_REP_REGISTRATION_NUMBER, fnd_api.g_miss_char,

250: P_CREATE_AWT_INVOICES_TYPE_COD,
251: P_TAX_CLASSIFICATION_CODE,
252: P_SELF_ASSESS_FLAG,
253: P_ALLOW_OFFSET_TAX_FLAG,
254: DECODE(P_REP_REGISTRATION_NUMBER, fnd_api.g_miss_char,
255: NULL, P_REP_REGISTRATION_NUMBER),
256: L_EFFECTIVE_FROM_USE_LE,
257: P_RECORD_TYPE_CODE,
258: P_REQUEST_ID,

Line 305: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

301: OPEN ptp_cur;
302: FETCH ptp_cur INTO L_PARTY_TAX_PROFILE_ID;
303: IF (ptp_cur%notfound) then
304: --Set x_return_status param
305: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
306: 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 || '."');
307: END IF;
308: CLOSE ptp_cur;
309: END IF;

Line 314: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

310: EXCEPTION
311: --Index violation check
312: WHEN DUP_VAL_ON_INDEX THEN
313: --Set x_return_status param
314: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
315: arp_util_tax.debug('Error: "The Ptp row already exists for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE || '."');
316: end INSERT_ROW;
317:
318:

Line 471: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

467: ) is
468: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;
469: begin
470: --Initialise x_return_status variable
471: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
472: --Perform validations before inserting data
473: --AllowOffsetTax and SetforSelfAssessment flag would be mutually exclusive
474: IF P_SELF_ASSESS_FLAG = 'Y' AND P_ALLOW_OFFSET_TAX_FLAG = 'Y' THEN
475: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 475: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

471: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
472: --Perform validations before inserting data
473: --AllowOffsetTax and SetforSelfAssessment flag would be mutually exclusive
474: IF P_SELF_ASSESS_FLAG = 'Y' AND P_ALLOW_OFFSET_TAX_FLAG = 'Y' THEN
475: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
476: 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);
477: END IF;
478: --when UseLeAsSubscriberFlag is set to 'Y', then setEffectiveFromUseLe as System date
479: IF P_USE_LE_AS_SUBSCRIBER_FLAG = 'Y' THEN

Line 485: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN

481: ELSE
482: L_EFFECTIVE_FROM_USE_LE := NULL;
483: END IF;
484: --Update only when there is no error
485: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
486: update ZX_PARTY_TAX_PROFILE set
487: COLLECTING_AUTHORITY_FLAG = DECODE( P_COLLECTING_AUTHORITY_FLAG, NULL, COLLECTING_AUTHORITY_FLAG, P_COLLECTING_AUTHORITY_FLAG ),
488: PROVIDER_TYPE_CODE = DECODE( P_PROVIDER_TYPE_CODE, NULL, PROVIDER_TYPE_CODE, P_PROVIDER_TYPE_CODE ),
489: 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 494: REP_REGISTRATION_NUMBER = DECODE( P_REP_REGISTRATION_NUMBER, NULL, REP_REGISTRATION_NUMBER,fnd_api.g_miss_char, NULL, P_REP_REGISTRATION_NUMBER ),

490: CREATE_AWT_INVOICES_TYPE_CODE = DECODE( P_CREATE_AWT_INVOICES_TYPE_COD, NULL, CREATE_AWT_INVOICES_TYPE_CODE, P_CREATE_AWT_INVOICES_TYPE_COD ),
491: TAX_CLASSIFICATION_CODE = DECODE( P_TAX_CLASSIFICATION_CODE, NULL, TAX_CLASSIFICATION_CODE, P_TAX_CLASSIFICATION_CODE ),
492: SELF_ASSESS_FLAG = DECODE( P_SELF_ASSESS_FLAG, NULL, SELF_ASSESS_FLAG, P_SELF_ASSESS_FLAG ),
493: ALLOW_OFFSET_TAX_FLAG = DECODE( P_ALLOW_OFFSET_TAX_FLAG, NULL, ALLOW_OFFSET_TAX_FLAG, P_ALLOW_OFFSET_TAX_FLAG ),
494: REP_REGISTRATION_NUMBER = DECODE( P_REP_REGISTRATION_NUMBER, NULL, REP_REGISTRATION_NUMBER,fnd_api.g_miss_char, NULL, P_REP_REGISTRATION_NUMBER ),
495: EFFECTIVE_FROM_USE_LE = DECODE( L_EFFECTIVE_FROM_USE_LE, NULL, EFFECTIVE_FROM_USE_LE, L_EFFECTIVE_FROM_USE_LE ),
496: RECORD_TYPE_CODE = DECODE( P_RECORD_TYPE_CODE, NULL, RECORD_TYPE_CODE, P_RECORD_TYPE_CODE ),
497: REQUEST_ID = DECODE( P_REQUEST_ID, NULL, REQUEST_ID, P_REQUEST_ID ),
498: ATTRIBUTE1 = DECODE( P_ATTRIBUTE1, NULL, ATTRIBUTE1, P_ATTRIBUTE1 ),

Line 539: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

535: COUNTRY_CODE = DECODE (P_COUNTRY_CODE,NULL, COUNTRY_CODE, P_COUNTRY_CODE)
536: where PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;
537: if (sql%notfound) then
538: --Set x_return_status param
539: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
540: 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 || '."');
541: end if;--end sql%notfound
542: end if;--end X_RETURN_STATUS
543: end UPDATE_ROW;

Line 551: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

547: x_return_status OUT NOCOPY VARCHAR2
548: ) is
549: begin
550: --Initialise x_return_status variable
551: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
552: --Delete the row
553: delete from ZX_PARTY_TAX_PROFILE
554: where PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;
555:

Line 558: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

554: where PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;
555:
556: if (sql%notfound) then
557: --Set x_return_status param
558: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
559: raise no_data_found;
560: end if;
561: end DELETE_ROW;
562:

Line 577: x_return_status := FND_API.G_RET_STS_SUCCESS;

573: l_dummy_number NUMBER(15) := NULL;
574: l_dummy_char HZ_PARTIES.party_type%TYPE;
575:
576: BEGIN
577: x_return_status := FND_API.G_RET_STS_SUCCESS;
578: x_msg_count := 0;
579: x_msg_data := NULL;
580:
581: IF p_party_id IS NULL THEN

Line 603: (p_init_msg_list => FND_API.G_TRUE

599: END;
600: END IF;
601:
602: hz_party_v2pub.get_organization_rec
603: (p_init_msg_list => FND_API.G_TRUE
604: ,p_party_id => p_party_id
605: ,x_organization_rec => l_organization_rec
606: ,x_return_status => x_return_status
607: ,x_msg_count => x_msg_count

Line 611: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

607: ,x_msg_count => x_msg_count
608: ,x_msg_data => x_msg_data
609: );
610:
611: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
612: RETURN;
613: END IF;
614:
615: IF NVL(l_organization_rec.tax_reference,FND_API.G_MISS_CHAR) <>

Line 615: IF NVL(l_organization_rec.tax_reference,FND_API.G_MISS_CHAR) <>

611: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
612: RETURN;
613: END IF;
614:
615: IF NVL(l_organization_rec.tax_reference,FND_API.G_MISS_CHAR) <>
616: NVL(p_tax_reg_num,FND_API.G_MISS_CHAR) THEN
617: l_organization_rec.tax_reference := NVL(p_tax_reg_num,FND_API.G_MISS_CHAR);
618:
619: SELECT object_version_number

Line 616: NVL(p_tax_reg_num,FND_API.G_MISS_CHAR) THEN

612: RETURN;
613: END IF;
614:
615: IF NVL(l_organization_rec.tax_reference,FND_API.G_MISS_CHAR) <>
616: NVL(p_tax_reg_num,FND_API.G_MISS_CHAR) THEN
617: l_organization_rec.tax_reference := NVL(p_tax_reg_num,FND_API.G_MISS_CHAR);
618:
619: SELECT object_version_number
620: INTO l_party_ovn

Line 617: l_organization_rec.tax_reference := NVL(p_tax_reg_num,FND_API.G_MISS_CHAR);

613: END IF;
614:
615: IF NVL(l_organization_rec.tax_reference,FND_API.G_MISS_CHAR) <>
616: NVL(p_tax_reg_num,FND_API.G_MISS_CHAR) THEN
617: l_organization_rec.tax_reference := NVL(p_tax_reg_num,FND_API.G_MISS_CHAR);
618:
619: SELECT object_version_number
620: INTO l_party_ovn
621: FROM hz_parties

Line 625: (p_init_msg_list => FND_API.G_TRUE

621: FROM hz_parties
622: WHERE party_id = p_party_id;
623:
624: hz_party_v2pub.update_organization
625: (p_init_msg_list => FND_API.G_TRUE
626: ,p_organization_rec => l_organization_rec
627: ,p_party_object_version_number => l_party_ovn
628: ,x_profile_id => l_dummy_number
629: ,x_return_status => x_return_status

Line 637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

633: END IF;
634:
635: EXCEPTION
636: WHEN OTHERS THEN
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
638: x_msg_count := 1;
639: x_msg_data := SQLERRM;
640:
641: END sync_tax_reg_num;