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 143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

139: EXCEPTION
140: WHEN OTHERS THEN
141: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
142: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','INSERT_PTP : '||SQLERRM);
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
144: FND_MSG_PUB.add;
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;

Line 171: x_return_status := FND_API.G_RET_STS_SUCCESS;

167: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
168: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
169: END IF;
170:
171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172:
173: SELECT 1
174: INTO dummy
175: FROM zx_party_tax_profile

Line 223: dbms_output.put_line(FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE ));

219:
220: /*
221: IF l_msg_count > 1 THEN
222: FOR i IN 1..l_msg_count LOOP
223: dbms_output.put_line(FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE ));
224: END LOOP;
225: END IF;
226: */
227: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 227: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

223: dbms_output.put_line(FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE ));
224: END LOOP;
225: END IF;
226: */
227: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
228: /*Insert into zx_party_tax_profile*/
229: insert_ptp (p_party_id => l_party_id,
230: p_ptp_id => 1,
231: x_return_status => l_return_status

Line 261: x_return_status := FND_API.G_RET_STS_SUCCESS;

257: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
258: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
259: END IF;
260:
261: x_return_status := FND_API.G_RET_STS_SUCCESS;
262:
263: SELECT 1
264: INTO dummy
265: FROM zx_party_tax_profile

Line 313: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

309: /*dbms_output.put_line(SubStr('x_return_status = '||l_return_status,1,255));
310: dbms_output.put_line(SubStr('x_msg_count = '||TO_CHAR(l_msg_count), 1, 255));
311: dbms_output.put_line(SubStr('x_msg_data = '||l_msg_data,1,255));
312: */
313: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
314: /*Insert into zx_party_tax_profile*/
315: insert_ptp (p_party_id => l_party_id,
316: p_ptp_id => 2,
317: 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: --Get the profile value to determine if need to pass the party number
341: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER', l_gen_party_number);
342: l_dss_enabled := fnd_profile.value('HZ_DSS_ENABLED');

Line 347: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

343: fnd_profile.put('HZ_DSS_ENABLED','N');
344:
345: /*Create Vertex as TCA party*/
346: CREATE_VERTEX_TCA_ZX (x_return_status);
347: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
348: x_return_status := FND_API.G_RET_STS_ERROR ;
349: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
350: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Creating Vertex as Organization Party in TCA and PTP in eBTax : '||SQLERRM);
351: FND_MSG_PUB.Add;

Line 348: x_return_status := FND_API.G_RET_STS_ERROR ;

344:
345: /*Create Vertex as TCA party*/
346: CREATE_VERTEX_TCA_ZX (x_return_status);
347: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
348: x_return_status := FND_API.G_RET_STS_ERROR ;
349: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
350: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Creating Vertex as Organization Party in TCA and PTP in eBTax : '||SQLERRM);
351: FND_MSG_PUB.Add;
352: END IF;

Line 356: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

352: END IF;
353:
354: /*Create Taxware as TCA party*/
355: CREATE_TAXWARE_TCA_ZX (l_return_status);
356: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
357: x_return_status := FND_API.G_RET_STS_ERROR ;
358: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
359: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Creating Taxware as Organization Party in TCA and PTP in eBTax: '||SQLERRM);
360: FND_MSG_PUB.Add;

Line 357: x_return_status := FND_API.G_RET_STS_ERROR ;

353:
354: /*Create Taxware as TCA party*/
355: CREATE_TAXWARE_TCA_ZX (l_return_status);
356: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
357: x_return_status := FND_API.G_RET_STS_ERROR ;
358: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
359: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Creating Taxware as Organization Party in TCA and PTP in eBTax: '||SQLERRM);
360: FND_MSG_PUB.Add;
361: END IF;