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

Line 30: x_return_status := FND_API.G_RET_STS_SUCCESS;

26: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
27: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
28: END IF;
29:
30: x_return_status := FND_API.G_RET_STS_SUCCESS;
31:
32: INSERT INTO zx_party_tax_profile (
33: collecting_authority_flag,
34: provider_type_code,

Line 144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

140: WHEN OTHERS THEN
141: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
142: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','INSERT_PTP : '||SQLERRM);
143: FND_MSG_PUB.add;
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
145: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
146: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
147: END IF;
148: END insert_ptp;

Line 168: x_return_status := FND_API.G_RET_STS_SUCCESS;

164: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
165: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
166: END IF;
167:
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169:
170: BEGIN
171: SELECT 1
172: INTO l_exists

Line 217: -- DBMS_OUTPUT.PUT_LINE(FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE ));

213: x_profile_id => l_profile_id);
214:
215: --IF l_msg_count > 1 THEN
216: -- FOR i IN 1..l_msg_count LOOP
217: -- DBMS_OUTPUT.PUT_LINE(FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE ));
218: -- END LOOP;
219: --END IF;
220:
221: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 221: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

217: -- DBMS_OUTPUT.PUT_LINE(FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE ));
218: -- END LOOP;
219: --END IF;
220:
221: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
222: /*Insert into zx_party_tax_profile*/
223: insert_ptp (p_party_id => l_party_id,
224: p_ptp_id => 1,
225: x_return_status => l_return_status

Line 254: x_return_status := FND_API.G_RET_STS_SUCCESS;

250: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
251: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
252: END IF;
253:
254: x_return_status := FND_API.G_RET_STS_SUCCESS;
255:
256: BEGIN
257: SELECT 1
258: INTO l_exists

Line 305: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

301: -- DBMS_OUTPUT.PUT_LINE(SubStr('x_return_status = '||l_return_status,1,255));
302: -- DBMS_OUTPUT.PUT_LINE(SubStr('x_msg_count = '||TO_CHAR(l_msg_count), 1, 255));
303: -- DBMS_OUTPUT.PUT_LINE(SubStr('x_msg_data = '||l_msg_data,1,255));
304:
305: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
306: /*Insert into zx_party_tax_profile*/
307: insert_ptp (p_party_id => l_party_id,
308: p_ptp_id => 2,
309: x_return_status => l_return_status

Line 338: x_return_status := FND_API.G_RET_STS_SUCCESS;

334: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
335: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
336: END IF;
337:
338: x_return_status := FND_API.G_RET_STS_SUCCESS;
339:
340: BEGIN
341: SELECT 1
342: INTO l_exists

Line 380: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

376: x_party_id => l_party_id,
377: x_party_number => l_party_number,
378: x_profile_id => l_profile_id);
379:
380: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
381: /*Insert into zx_party_tax_profile*/
382: insert_ptp (p_party_id => l_party_id,
383: p_ptp_id => 3,
384: x_return_status => l_return_status

Line 413: x_return_status := FND_API.G_RET_STS_SUCCESS;

409: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
410: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
411: END IF;
412:
413: x_return_status := FND_API.G_RET_STS_SUCCESS;
414:
415: BEGIN
416: SELECT 1
417: INTO l_exists

Line 455: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

451: x_party_id => l_party_id,
452: x_party_number => l_party_number,
453: x_profile_id => l_profile_id);
454:
455: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
456: /*Insert into zx_party_tax_profile*/
457: insert_ptp (p_party_id => l_party_id,
458: p_ptp_id => 4,
459: x_return_status => l_return_status

Line 481: x_return_status := FND_API.G_RET_STS_SUCCESS;

477: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
478: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
479: END IF;
480:
481: x_return_status := FND_API.G_RET_STS_SUCCESS;
482:
483: --Get the profile value to determine if need to pass the party number
484: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER', l_gen_party_number);
485: l_dss_enabled := fnd_profile.value('HZ_DSS_ENABLED');

Line 490: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

486: fnd_profile.put('HZ_DSS_ENABLED','N');
487:
488: /*Create Vertex as TCA party*/
489: CREATE_VERTEX_TCA_ZX (x_return_status);
490: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
491: x_return_status := FND_API.G_RET_STS_ERROR ;
492: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
493: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Creating Vertex as Organization Party in TCA and PTP in eBTax : '||SQLERRM);
494: FND_MSG_PUB.Add;

Line 491: x_return_status := FND_API.G_RET_STS_ERROR ;

487:
488: /*Create Vertex as TCA party*/
489: CREATE_VERTEX_TCA_ZX (x_return_status);
490: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
491: x_return_status := FND_API.G_RET_STS_ERROR ;
492: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
493: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Creating Vertex as Organization Party in TCA and PTP in eBTax : '||SQLERRM);
494: FND_MSG_PUB.Add;
495: END IF;

Line 499: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

495: END IF;
496:
497: /*Create Taxware as TCA party*/
498: CREATE_TAXWARE_TCA_ZX (l_return_status);
499: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
500: x_return_status := FND_API.G_RET_STS_ERROR ;
501: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
502: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Creating Taxware as Organization Party in TCA and PTP in eBTax: '||SQLERRM);
503: FND_MSG_PUB.Add;

Line 500: x_return_status := FND_API.G_RET_STS_ERROR ;

496:
497: /*Create Taxware as TCA party*/
498: CREATE_TAXWARE_TCA_ZX (l_return_status);
499: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
500: x_return_status := FND_API.G_RET_STS_ERROR ;
501: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
502: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Creating Taxware as Organization Party in TCA and PTP in eBTax: '||SQLERRM);
503: FND_MSG_PUB.Add;
504: END IF;

Line 508: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

504: END IF;
505:
506: /*Create Others as TCA party*/
507: CREATE_OTHERS_TCA_ZX (l_return_status);
508: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
509: x_return_status := FND_API.G_RET_STS_ERROR ;
510: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
511: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Creating Other Tax Partner as Organization Party in TCA and PTP in eBTax: '||SQLERRM);
512: FND_MSG_PUB.Add;

Line 509: x_return_status := FND_API.G_RET_STS_ERROR ;

505:
506: /*Create Others as TCA party*/
507: CREATE_OTHERS_TCA_ZX (l_return_status);
508: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
509: x_return_status := FND_API.G_RET_STS_ERROR ;
510: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
511: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Creating Other Tax Partner as Organization Party in TCA and PTP in eBTax: '||SQLERRM);
512: FND_MSG_PUB.Add;
513: END IF;

Line 517: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

513: END IF;
514:
515: /*Create CCH as TCA party*/
516: CREATE_CCH_TCA_ZX (l_return_status);
517: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
518: x_return_status := FND_API.G_RET_STS_ERROR ;
519: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
520: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Creating CCH as Organization Party in TCA and PTP in eBTax: '||SQLERRM);
521: FND_MSG_PUB.Add;

Line 518: x_return_status := FND_API.G_RET_STS_ERROR ;

514:
515: /*Create CCH as TCA party*/
516: CREATE_CCH_TCA_ZX (l_return_status);
517: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
518: x_return_status := FND_API.G_RET_STS_ERROR ;
519: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
520: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Creating CCH as Organization Party in TCA and PTP in eBTax: '||SQLERRM);
521: FND_MSG_PUB.Add;
522: END IF;