APPS.ZX_AR_FORMULA_MIG_PKG dependencies on FND_API

Line 166: x_return_status := FND_API.G_RET_STS_SUCCESS;

162:
163: arp_util_tax.debug('ZX_AR_FORMULA_MIG_PKG.FORMULA_MIGRATION_MAIN(+)');
164:
165: -- Initialize API return status to success
166: x_return_status := FND_API.G_RET_STS_SUCCESS;
167:
168: -- Case 1 Tax Codes in AR_VAT_TAX
169:
170: OPEN get_tax_cur;

Line 216: x_return_status := FND_API.G_RET_STS_ERROR;

212:
213:
214: EXCEPTION WHEN OTHERS THEN
215: arp_util_tax.debug('Case1: error for tax '||l_tax_code||' Error:'||sqlerrm);
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: END;
218:
219:
220: arp_util_tax.debug('case1:l_condition_grp_id:'||l_condition_grp_id);

Line 402: x_return_status := FND_API.G_RET_STS_ERROR;

398:
399:
400: EXCEPTION WHEN OTHERS THEN
401: arp_util_tax.debug('Case 3:error for tax '||l_child_tax_code||' error:'||sqlerrm);
402: x_return_status := FND_API.G_RET_STS_ERROR;
403:
404: END;
405:
406: -- result of taxable basis det is l_formula_code determined just before create_formula()

Line 539: x_return_status := FND_API.G_RET_STS_ERROR;

535: WHERE condition_group_code = l_tax_group_code|| decode(l_tax_constraint_id,NULL, '', '~'||l_tax_constraint_id);
536:
537: EXCEPTION WHEN OTHERS THEN
538: arp_util_tax.debug('Case 4:error for tax '||l_child_tax_code||' error:'||sqlerrm);
539: x_return_status := FND_API.G_RET_STS_ERROR;
540:
541: END;
542:
543: arp_util_tax.debug('Case 4:l_condition_grp_id->'||l_condition_grp_id);

Line 707: x_return_status := FND_API.G_RET_STS_ERROR;

703: arp_util_tax.debug('LAST');
704:
705: EXCEPTION WHEN OTHERS THEN
706:
707: x_return_status := FND_API.G_RET_STS_ERROR;
708:
709: END FORMULA_MIGRATION_MAIN;
710:
711:

Line 825: x_return_status := FND_API.G_RET_STS_ERROR;

821: );
822:
823: EXCEPTION WHEN OTHERS THEN
824: arp_util_tax.debug('In create_formula().formula_b: error-'||sqlerrm);
825: x_return_status := FND_API.G_RET_STS_ERROR;
826:
827: END ;
828:
829: -- Inserting values in table zx_formula_tl

Line 868: x_return_status := FND_API.G_RET_STS_ERROR;

864: AND t.language = l.language_code);
865:
866: EXCEPTION WHEN OTHERS THEN
867: arp_util_tax.debug('In create_formula().formula_tl: error-'||sqlerrm);
868: x_return_status := FND_API.G_RET_STS_ERROR;
869:
870: END;
871:
872:

Line 928: x_return_status := FND_API.G_RET_STS_ERROR;

924:
925: EXCEPTION WHEN OTHERS THEN
926: arp_util_tax.debug('In create_formula().formula_details: error-'||sqlerrm);
927:
928: x_return_status := FND_API.G_RET_STS_ERROR;
929:
930: END;
931:
932:

Line 989: x_return_status := FND_API.G_RET_STS_ERROR;

985: -- the above contains clause is introduced as part of 6718736
986:
987: EXCEPTION WHEN OTHERS THEN
988: arp_util_tax.debug('In create_formula().formula_b: error-'||sqlerrm);
989: x_return_status := FND_API.G_RET_STS_ERROR;
990:
991: END;
992:
993: END IF;

Line 1116: x_return_status := FND_API.G_RET_STS_ERROR;

1112: );
1113:
1114: EXCEPTION WHEN OTHERS THEN
1115: arp_util_tax.debug('In create_rules().rules_b: error-'||sqlerrm);
1116: x_return_status := FND_API.G_RET_STS_ERROR;
1117:
1118: END;
1119:
1120: -- Inserting values in table zx_rules_tl

Line 1159: x_return_status := FND_API.G_RET_STS_ERROR;

1155: AND t.language = l.language_code);
1156:
1157: EXCEPTION WHEN OTHERS THEN
1158: arp_util_tax.debug('In create_rules().rules_tl: error-'||sqlerrm);
1159: x_return_status := FND_API.G_RET_STS_ERROR;
1160:
1161: END;
1162:
1163: -- Inserting values in table zx_process_results

Line 1256: x_return_status := FND_API.G_RET_STS_ERROR;

1252:
1253:
1254: EXCEPTION WHEN OTHERS THEN
1255: arp_util_tax.debug('In create_rules().process_results: error-'||sqlerrm);
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257:
1258: END;
1259:
1260: END CREATE_RULES;