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

Line 35: x_return_status := FND_API.G_RET_STS_SUCCESS;

31: R1 C1%rowtype;
32: l_level Number := 0;
33: BEGIN
34: -- Initialize API return status to success
35: x_return_status := FND_API.G_RET_STS_SUCCESS;
36: -- Insert a record with level zero
37: insert into zx_regime_relations (regime_rel_id,
38: regime_code,
39: parent_regime_code,

Line 100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

96:
97: END LOOP;
98: close c1;
99: EXCEPTION
100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
102: WHEN OTHERS THEN
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
104: END insert_rel;

Line 101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

97: END LOOP;
98: close c1;
99: EXCEPTION
100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
102: WHEN OTHERS THEN
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
104: END insert_rel;
105:

Line 103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

99: EXCEPTION
100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
102: WHEN OTHERS THEN
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
104: END insert_rel;
105:
106: /* ================================================================================================*
107: | PROCEDURE update_rel : Updates records in Tax Regime relations table and rebuilds the hierarchy |

Line 139: x_return_status := FND_API.G_RET_STS_SUCCESS;

135: R1 C1%rowtype;
136: l_err_status VARCHAR2(1) ;
137: BEGIN
138: -- Initialize API return status to success
139: x_return_status := FND_API.G_RET_STS_SUCCESS;
140: -- Delete all the current records of the child
141: Delete
142: from zx_regime_relations
143: where regime_code = p_child;

Line 168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

164:
165: END LOOP;
166: close c1;
167: EXCEPTION
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
170: WHEN OTHERS THEN
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
172: END;

Line 169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

165: END LOOP;
166: close c1;
167: EXCEPTION
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
170: WHEN OTHERS THEN
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
172: END;
173:

Line 171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

167: EXCEPTION
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
170: WHEN OTHERS THEN
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
172: END;
173:
174: /* ================================================================================================*
175: | PROCEDURE update_taxes : Updates records in Taxes table if the reporting tax authority or the |

Line 312: x_return_status := FND_API.G_RET_STS_SUCCESS;

308: l_rep_tax_auth_id NUMBER;
309: l_coll_tax_auth_id NUMBER;
310: BEGIN
311: -- Initialize API return status to success
312: x_return_status := FND_API.G_RET_STS_SUCCESS;
313: -- Check if update of reporting tax authority id or collecting tax authority has occurred..
314: OPEN C1;
315: LOOP
316: FETCH C1 INTO R1;

Line 450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

446: END IF;
447: END LOOP;
448: close c1;
449: EXCEPTION
450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
452: WHEN OTHERS THEN
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
454: end;

Line 451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

447: END LOOP;
448: close c1;
449: EXCEPTION
450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
452: WHEN OTHERS THEN
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
454: end;
455:

Line 453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

449: EXCEPTION
450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
452: WHEN OTHERS THEN
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
454: end;
455:
456: /* ===================================================================================================*
457: | PROCEDURE get_regime_details: Obtains the regime details based on the country code or tax regime code|

Line 486: x_return_status := FND_API.G_RET_STS_SUCCESS;

482: R2 C2%rowtype;
483: l_num NUMBER := 1;
484: BEGIN
485: -- Initialize API return status to success
486: x_return_status := FND_API.G_RET_STS_SUCCESS;
487: --
488: IF (p_country_code is null AND p_tax_regime_code is not null) THEN
489: OPEN C1;
490: LOOP

Line 512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

508: ELSE
509: x_return_status := 'WRONG INPUT PARAMETERS';
510: END IF;
511: EXCEPTION
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
513: WHEN OTHERS THEN
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
515: END get_regime_details;
516: /* ===============================================================================================*

Line 514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

510: END IF;
511: EXCEPTION
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
513: WHEN OTHERS THEN
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
515: END get_regime_details;
516: /* ===============================================================================================*
517: | PROCEDURE get_regime_hierarchy: Obtains the regime relations based on the tax regime code |
518: * ==============================================================================================*/

Line 538: x_return_status := FND_API.G_RET_STS_SUCCESS;

534: R1 C1%rowtype;
535: l_num NUMBER := 1;
536: BEGIN
537: -- Initialize API return status to success
538: x_return_status := FND_API.G_RET_STS_SUCCESS;
539: -- Insert a record with level zero
540: IF (p_tax_regime_code is not null) THEN
541: OPEN C1;
542: LOOP

Line 555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

551: ELSE
552: x_return_status := 'WRONG INPUT PARAMETERS';
553: END IF;
554: EXCEPTION
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
556: WHEN OTHERS THEN x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
557: END get_regime_hierarchy;
558: END;

Line 556: WHEN OTHERS THEN x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

552: x_return_status := 'WRONG INPUT PARAMETERS';
553: END IF;
554: EXCEPTION
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
556: WHEN OTHERS THEN x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
557: END get_regime_hierarchy;
558: END;