APPS.ZX_AR_FORMULA_MIG_PKG dependencies on FND_API

Line 179: x_return_status := FND_API.G_RET_STS_SUCCESS;

175:
176: arp_util_tax.debug('ZX_AR_FORMULA_MIG_PKG.FORMULA_MIGRATION_MAIN(+)');
177:
178: -- Initialize API return status to success
179: x_return_status := FND_API.G_RET_STS_SUCCESS;
180:
181: -- Case 1 Tax Codes in AR_VAT_TAX
182:
183: OPEN get_tax_cur;

Line 224: x_return_status := FND_API.G_RET_STS_ERROR;

220: WHERE condition_group_code = l_tax_code;
221:
222: EXCEPTION WHEN OTHERS THEN
223: arp_util_tax.debug('Case1: error for tax '||l_tax_code||' Error:'||sqlerrm);
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: END;
226:
227: arp_util_tax.debug('case1:l_condition_grp_id:'||l_condition_grp_id);
228: arp_util_tax.debug('case1:l_condition_grp_cd:'||l_condition_grp_cd);

Line 403: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 530: x_return_status := FND_API.G_RET_STS_ERROR;

526: );
527:
528: EXCEPTION WHEN OTHERS THEN
529: arp_util_tax.debug('Case 4:error for tax '||l_child_tax_code||' error:'||sqlerrm);
530: x_return_status := FND_API.G_RET_STS_ERROR;
531:
532: END;
533:
534: arp_util_tax.debug('Case 4:l_condition_grp_id->'||l_condition_grp_id);

Line 711: x_return_status := FND_API.G_RET_STS_ERROR;

707: arp_util_tax.debug('LAST');
708:
709: EXCEPTION WHEN OTHERS THEN
710:
711: x_return_status := FND_API.G_RET_STS_ERROR;
712:
713: UPDATE ZX_TAXES_B T
714: SET TAXABLE_BASIS_RULE_FLAG = 'Y'
715: WHERE RECORD_TYPE_CODE = 'MIGRATED'

Line 838: x_return_status := FND_API.G_RET_STS_ERROR;

834: );
835:
836: EXCEPTION WHEN OTHERS THEN
837: arp_util_tax.debug('In create_formula().formula_b: error-'||sqlerrm);
838: x_return_status := FND_API.G_RET_STS_ERROR;
839:
840: END ;
841:
842: -- Inserting values in table zx_formula_tl

Line 881: x_return_status := FND_API.G_RET_STS_ERROR;

877: AND t.language = l.language_code);
878:
879: EXCEPTION WHEN OTHERS THEN
880: arp_util_tax.debug('In create_formula().formula_tl: error-'||sqlerrm);
881: x_return_status := FND_API.G_RET_STS_ERROR;
882:
883: END;
884:
885:

Line 900: x_return_status := FND_API.G_RET_STS_ERROR;

896: AND enabled_flag = p_enabled_flag;
897: -- Bug 9504903
898: EXCEPTION WHEN OTHERS THEN
899: arp_util_tax.debug('In create_formula().formula_tl: error-'||sqlerrm);
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: RETURN;
902: END;
903:
904: -- Inserting values in table zx_formula_details

Line 964: x_return_status := FND_API.G_RET_STS_ERROR;

960:
961: EXCEPTION WHEN OTHERS THEN
962: arp_util_tax.debug('In create_formula().formula_details: error-'||sqlerrm);
963:
964: x_return_status := FND_API.G_RET_STS_ERROR;
965:
966: END;
967:
968:

Line 1025: x_return_status := FND_API.G_RET_STS_ERROR;

1021: -- the above contains clause is introduced as part of 6718736
1022:
1023: EXCEPTION WHEN OTHERS THEN
1024: arp_util_tax.debug('In create_formula().formula_b: error-'||sqlerrm);
1025: x_return_status := FND_API.G_RET_STS_ERROR;
1026:
1027: END;
1028:
1029: END IF;

Line 1154: x_return_status := FND_API.G_RET_STS_ERROR;

1150: );
1151:
1152: EXCEPTION WHEN OTHERS THEN
1153: arp_util_tax.debug('In create_rules().rules_b: error-'||sqlerrm);
1154: x_return_status := FND_API.G_RET_STS_ERROR;
1155:
1156: END;
1157:
1158: -- Inserting values in table zx_rules_tl

Line 1197: x_return_status := FND_API.G_RET_STS_ERROR;

1193: AND t.language = l.language_code);
1194:
1195: EXCEPTION WHEN OTHERS THEN
1196: arp_util_tax.debug('In create_rules().rules_tl: error-'||sqlerrm);
1197: x_return_status := FND_API.G_RET_STS_ERROR;
1198:
1199: END;
1200:
1201: -- Bug 8429806

Line 1216: x_return_status := FND_API.G_RET_STS_ERROR;

1212: AND (effective_from BETWEEN p_effective_from and nvl(p_effective_to,SYSDATE)
1213: OR NVL(effective_to,sysdate) BETWEEN p_effective_from and nvl(p_effective_to,sysdate));
1214: EXCEPTION WHEN OTHERS THEN
1215: arp_util_tax.debug('In create_rules().rules_b: error-'||sqlerrm);
1216: x_return_status := FND_API.G_RET_STS_ERROR;
1217: RETURN;
1218: END;
1219: -- Bug 8429806
1220:

Line 1313: x_return_status := FND_API.G_RET_STS_ERROR;

1309:
1310:
1311: EXCEPTION WHEN OTHERS THEN
1312: arp_util_tax.debug('In create_rules().process_results: error-'||sqlerrm);
1313: x_return_status := FND_API.G_RET_STS_ERROR;
1314:
1315: END;
1316:
1317: END CREATE_RULES;