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

Line 311: x_return_status:= FND_API.G_RET_STS_SUCCESS;

307: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.BEGIN',
308: 'ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(+) ');
309: END IF;
310:
311: x_return_status:= FND_API.G_RET_STS_SUCCESS;
312: -- g_variance_calc_flag := 'N';
313:
314: l_old_trx_line_id := NUMBER_DUMMY;
315: l_old_trx_level_type := VAR_30_DUMMY;

Line 353: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

349: ZX_TRL_MANAGE_TAX_PKG.Update_Item_Dist_Changed_Flag(
350: x_return_status,
351: p_event_class_rec);
352:
353: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
354: IF (g_level_statement >= g_current_runtime_level ) THEN
355: FND_LOG.STRING(g_level_statement,
356: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
357: 'After calling TRL, x_return_status = '|| x_return_status);

Line 374: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

370: fetch_tax_lines ( p_event_class_rec,
371: l_tax_line_tbl,
372: x_return_status);
373:
374: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
375: IF (g_level_statement >= g_current_runtime_level ) THEN
376: FND_LOG.STRING(g_level_statement,
377: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
378: 'After calling fetch tax lines, x_return_status = '

Line 444: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

440: populate_trx_line_info( l_tax_line_tbl,
441: i,
442: x_return_status);
443:
444: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
445: IF (g_level_statement >= g_current_runtime_level ) THEN
446: FND_LOG.STRING(g_level_statement,
447: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
448: 'After calling populate_trx_line_info, x_return_status = '

Line 594: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

590: p_event_class_rec,
591: x_return_status,
592: p_error_buffer);
593:
594: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
595: IF (g_level_statement >= g_current_runtime_level ) THEN
596: FND_LOG.STRING(g_level_statement,
597: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
598: 'After calling cancel_tax_line x_return_status = '

Line 728: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

724: p_event_class_rec,
725: x_return_status,
726: p_error_buffer);
727:
728: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
729: IF (g_level_statement >= g_current_runtime_level ) THEN
730: FND_LOG.STRING(g_level_statement,
731: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
732: 'After calling calc_tax_dist x_return_status = '

Line 753: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

749: l_rec_nrec_dist_begin_index,
750: l_rec_nrec_dist_end_index,
751: x_return_status);
752:
753: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
754: IF (g_level_statement >= g_current_runtime_level ) THEN
755: FND_LOG.STRING(g_level_statement,
756: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
757: 'After calling fetch_tax_distributions x_return_status = '

Line 766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

762: END IF;
763: RETURN;
764: END IF;
765: ELSE -- wrong l_action
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
767: IF (g_level_statement >= g_current_runtime_level ) THEN
768: FND_LOG.STRING(g_level_statement,
769: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
770: 'wrong dist level action code. l_action= '||l_action );

Line 866: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

862: p_event_class_rec,
863: x_return_status,
864: p_error_buffer);
865:
866: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
867: IF (g_level_statement >= g_current_runtime_level ) THEN
868: FND_LOG.STRING(g_level_statement,
869: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
870: 'After calling calc_tax_dist x_return_status = '

Line 880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

876: RETURN;
877: END IF;
878:
879: ELSE -- wrong l_action
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
881: IF (g_level_statement >= g_current_runtime_level ) THEN
882: FND_LOG.STRING(g_level_statement,
883: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
884: 'wrong dist level action code ' );

Line 905: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

901: l_rec_nrec_dist_end_index,
902: x_return_status,
903: p_error_buffer);
904:
905: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
906: IF (g_level_statement >= g_current_runtime_level ) THEN
907: FND_LOG.STRING(g_level_statement,
908: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
909: 'After calling get_rec_nrec_dist_amt x_return_status = '

Line 930: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

926: l_tax_line_tbl(i).tax_amt_funcl_curr,
927: x_return_status,
928: p_error_buffer);
929:
930: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
931: IF (g_level_statement >= g_current_runtime_level ) THEN
932: FND_LOG.STRING(g_level_statement,
933: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
934: 'After calling ROUND_REC_NREC_AMT x_return_status = '

Line 957: -- IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

953: -- l_rec_nrec_dist_end_index,
954: -- x_return_status,
955: -- p_error_buffer);
956: --
957: -- IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
958: -- IF (g_level_statement >= g_current_runtime_level ) THEN
959: -- FND_LOG.STRING(g_level_statement,
960: -- 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
961: -- 'After calling create_mrc_tax_dists x_return_status = '

Line 980: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

976: l_dist_tbl_begin_index,
977: l_rec_nrec_dist_end_index,
978: x_return_status);
979:
980: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
981: IF (g_level_statement >= g_current_runtime_level ) THEN
982: FND_LOG.STRING(g_level_statement,
983: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
984: 'After calling insert_global_table x_return_status = '

Line 1002: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

998:
999: -- populate mandatory columns before inserting.
1000: populate_mandatory_columns(l_rec_nrec_dist_tbl,x_return_status);
1001:
1002: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1003: IF (g_level_statement >= g_current_runtime_level ) THEN
1004: FND_LOG.STRING(g_level_statement,
1005: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
1006: 'After calling populate_mandatory_columns x_return_status = '

Line 1026: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1022:
1023: delete_unnecessary_tax_dists(p_event_class_rec => p_event_class_rec,
1024: x_return_status => x_return_status);
1025:
1026: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1027: IF g_level_statement >= g_current_runtime_level THEN
1028: FND_LOG.STRING(g_level_statement,
1029: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
1030: 'After calling delete_unnecessary_tax_dists, x_return_status = '

Line 1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1046: END IF;
1047:
1048: EXCEPTION
1049: WHEN OTHERS THEN
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1052:
1053: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1054: FND_LOG.STRING(g_level_unexpected,

Line 1130: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1126: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY.BEGIN',
1127: 'ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY(+)');
1128: END IF;
1129:
1130: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1131:
1132: -- Initialize p_tax_line_tbl
1133: l_rec_nrec_dist_tbl.delete;
1134: g_variance_calc_flag := 'N';

Line 1211: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1207: x_return_status,
1208: p_error_buffer
1209: );
1210:
1211: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1212:
1213: IF (g_level_statement >= g_current_runtime_level ) THEN
1214: FND_LOG.STRING(g_level_statement,
1215: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',

Line 1245: -- IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1241: -- l_rec_nrec_dist_end_index,
1242: -- x_return_status,
1243: -- p_error_buffer);
1244: --
1245: -- IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1246: -- IF (g_level_statement >= g_current_runtime_level ) THEN
1247: -- FND_LOG.STRING(g_level_statement,
1248: -- 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',
1249: -- 'After calling create_mrc_tax_dists x_return_status = '

Line 1267: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1263: l_rec_nrec_dist_begin_index,
1264: l_rec_nrec_dist_end_index,
1265: x_return_status);
1266:
1267: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1268:
1269: IF (g_level_statement >= g_current_runtime_level ) THEN
1270: FND_LOG.STRING(g_level_statement,
1271: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',

Line 1291: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1287:
1288: -- populate mandatory columns before inserting.
1289: populate_mandatory_columns(l_rec_nrec_dist_tbl, x_return_status);
1290:
1291: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1292:
1293: IF (g_level_statement >= g_current_runtime_level ) THEN
1294: FND_LOG.STRING(g_level_statement,
1295: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',

Line 1319: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1315: x_return_status,
1316: p_error_buffer
1317: );
1318:
1319: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1320:
1321: IF (g_level_statement >= g_current_runtime_level ) THEN
1322: FND_LOG.STRING(g_level_statement,
1323: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',

Line 1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1340: END IF;
1341:
1342: EXCEPTION
1343: WHEN OTHERS THEN
1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1345: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1346:
1347: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1348: FND_LOG.STRING(g_level_unexpected,

Line 1395: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1391: FND_LOG.STRING(g_level_procedure,
1392: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_TAX_DIST.BEGIN',
1393: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_TAX_DIST(+)');
1394: END IF;
1395: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1396:
1397: l_index:= 1;
1398:
1399: OPEN get_rec_nrec_dist_cur;

Line 1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1516: END IF;
1517:
1518: EXCEPTION
1519: WHEN OTHERS THEN
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1522:
1523: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1524: FND_LOG.STRING(g_level_unexpected,

Line 1576: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1572: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX.BEGIN',
1573: 'ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX(+)');
1574: END IF;
1575:
1576: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1577:
1578: l_code := NULL;
1579: l_tax_variance := 'N';
1580: l_tax_amount_range := 'N';

Line 1901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1897: END IF;
1898:
1899: EXCEPTION
1900: WHEN OTHERS THEN
1901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1902:
1903: IF get_hold_status_csr%ISOPEN THEN
1904: CLOSE get_hold_status_csr;
1905: END IF;

Line 1978: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1974: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS.BEGIN',
1975: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS(+)');
1976: END IF;
1977:
1978: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1979:
1980: -- Bug 9088833. This is used to populate reverse_flag and reversed_tax_dist_id
1981: SELECT count(*) INTO l_dist_count
1982: FROM zx_rec_nrec_dist

Line 2542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2538: END IF;
2539:
2540: EXCEPTION
2541: WHEN DUP_VAL_ON_INDEX THEN
2542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2543:
2544: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2545: FND_LOG.STRING(g_level_unexpected,
2546: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS',

Line 2554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2550: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2551: END IF;
2552:
2553: WHEN OTHERS THEN
2554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2555:
2556: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2557: FND_LOG.STRING(g_level_unexpected,
2558: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS',

Line 2704: x_return_status := FND_API.G_RET_STS_SUCCESS;

2700: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Revenue_Expense_ccid:'|| p_revenue_expense_ccid);
2701: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID','Account Source Tax Rate Id:'|| p_account_source_tax_rate_id);
2702: END IF;
2703:
2704: x_return_status := FND_API.G_RET_STS_SUCCESS;
2705:
2706: IF p_Recoverable_Flag = 'Y' then
2707: --start - Bug Fix - 5950624
2708: OPEN get_def_rec_settle_option_code(p_tax_rate_id);

Line 3187: x_return_status := FND_API.G_RET_STS_ERROR;

3183: WHEN OTHERS THEN NULL;
3184: END;
3185:
3186: IF p_Recoverable_Flag = 'Y' THEN -- bug 4893261
3187: x_return_status := FND_API.G_RET_STS_ERROR;
3188: FND_MESSAGE.SET_NAME('ZX', 'ZX_INVALID_REC_CCID');
3189: FND_MESSAGE.SET_TOKEN('TAXRATE', l_rate_code);
3190: FND_MESSAGE.SET_TOKEN('SOURCE_TAXRATE', l_source_rate_code);
3191: FND_MSG_PUB.Add;

Line 3199: x_return_status := FND_API.G_RET_STS_ERROR; -- bug 4893261,

3195: 'error: p_Recoverable_Flag is Y, but p_rec_nrec_ccid is null');
3196: END IF;
3197:
3198: ELSIF p_Recoverable_Flag = 'N' THEN
3199: x_return_status := FND_API.G_RET_STS_ERROR; -- bug 4893261,
3200: FND_MESSAGE.SET_NAME('ZX', 'ZX_INVALID_NREC_CCID');
3201: FND_MESSAGE.SET_TOKEN('TAXRATE', l_rate_code);
3202: FND_MESSAGE.SET_TOKEN('SOURCE_TAXRATE', l_source_rate_code);
3203: FND_MSG_PUB.Add;

Line 3217: x_return_status := FND_API.G_RET_STS_ERROR;

3213: -- at the tax rate level of the self assessed tax
3214: --Bug#6807089 : Need to display proper error message when the ccid is invalid.
3215:
3216: IF p_Self_Assessed_Flag = 'Y' AND p_tax_liab_ccid IS NULL THEN
3217: x_return_status := FND_API.G_RET_STS_ERROR;
3218: -- bug 8568734
3219: BEGIN
3220: IF p_account_source_tax_rate_id IS NOT NULL AND l_source_rate_code IS NULL
3221: THEN

Line 3280: x_return_status := FND_API.G_RET_STS_ERROR;

3276: structure_number => l_chart_of_accounts_id,
3277: combination_id => p_rec_nrec_ccid,
3278: security => 'ENFORCE')
3279: THEN
3280: x_return_status := FND_API.G_RET_STS_ERROR;
3281:
3282: OPEN get_account_string(p_rec_nrec_ccid);
3283: FETCH get_account_string INTO l_account_string;
3284: CLOSE get_account_string;

Line 3319: x_return_status := FND_API.G_RET_STS_ERROR;

3315: structure_number => l_chart_of_accounts_id,
3316: combination_id => p_tax_liab_ccid,
3317: security => 'ENFORCE')
3318: THEN
3319: x_return_status := FND_API.G_RET_STS_ERROR;
3320:
3321: OPEN get_account_string(p_tax_liab_ccid);
3322: FETCH get_account_string INTO l_account_string;
3323: CLOSE get_account_string;

Line 3352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3348: END IF;
3349:
3350: EXCEPTION
3351: WHEN OTHERS THEN
3352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3353:
3354: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3355: FND_LOG.STRING(g_level_unexpected,
3356: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

Line 3492: x_return_status := FND_API.G_RET_STS_SUCCESS;

3488: 'Ledger Id:'|| p_ledger_id);
3489: END IF;
3490:
3491:
3492: x_return_status := FND_API.G_RET_STS_SUCCESS;
3493:
3494: IF p_location_segment_id IS NULL THEN
3495: -- Get location_segment_id in case of credit memo for a migrated transaction
3496: open get_location_segment_id_csr(p_tax_line_id ) ;

Line 3546: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3542: p_tax_rate_id,
3543: l_tax_jurisdiction_id,
3544: x_return_status);
3545:
3546: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3547: IF (g_level_statement >= g_current_runtime_level ) THEN
3548: FND_LOG.STRING(g_level_statement,
3549: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID',
3550: 'After calling get_tax_jurisdiction_id, x_return_status = '|| x_return_status);

Line 3718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3714:
3715:
3716: EXCEPTION
3717: WHEN OTHERS THEN
3718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3719:
3720: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3721: FND_LOG.STRING(g_level_unexpected,
3722: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID',

Line 3871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3867: END IF;
3868:
3869: EXCEPTION
3870: WHEN DUP_VAL_ON_INDEX THEN
3871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3872:
3873: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3874: FND_LOG.STRING(g_level_unexpected,
3875: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_item_dist',

Line 3883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3879: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3880: END IF;
3881:
3882: WHEN OTHERS THEN
3883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3884:
3885: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3886: FND_LOG.STRING(g_level_unexpected,
3887: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_item_dist',

Line 3956: x_return_status:= FND_API.G_RET_STS_SUCCESS;

3952: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_lines.BEGIN',
3953: 'ZX_TRD_SERVICES_PUB_PKG.fetch_tax_lines(+)');
3954: END IF;
3955:
3956: x_return_status:= FND_API.G_RET_STS_SUCCESS;
3957:
3958: -- Initialize p_tax_line_tbl
3959: p_tax_line_tbl.delete;
3960:

Line 3974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3970: OPEN get_funcl_curr_info_csr(p_tax_line_tbl(detail_ctr).ledger_id);
3971: FETCH get_funcl_curr_info_csr into l_funcl_curr_code;
3972:
3973: IF get_funcl_curr_info_csr%NOTFOUND THEN
3974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3975: IF (g_level_procedure >= g_current_runtime_level ) THEN
3976: FND_LOG.STRING(g_level_procedure,
3977: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_lines',
3978: 'No data found for the specified ledger_id');

Line 3988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3984: IF p_tax_line_tbl(detail_ctr).trx_currency_code <> nvl(l_funcl_curr_code,'$$$')
3985: AND (p_tax_line_tbl(detail_ctr).tax_amt_funcl_curr is NULL
3986: OR p_tax_line_tbl(detail_ctr).taxable_amt_funcl_curr is NULL) THEN
3987:
3988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3989: l_error_buffer := 'Functional Currency Amounts cannot be NULL as Functional and Trx Currencies are different';
3990: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_TEXT');
3991: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_error_buffer);
3992: FND_MSG_PUB.Add;

Line 3998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3994: ELSIF p_tax_line_tbl(detail_ctr).tax_currency_code <> p_tax_line_tbl(detail_ctr).trx_currency_code
3995: AND (p_tax_line_tbl(detail_ctr).tax_amt_tax_curr is NULL
3996: OR p_tax_line_tbl(detail_ctr).taxable_amt_tax_curr is NULL) THEN
3997:
3998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3999: l_error_buffer := 'Tax Currency Amounts cannot be NULL as Tax and Trx Currencies are different';
4000: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_TEXT');
4001: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_error_buffer);
4002: FND_MSG_PUB.Add;

Line 4031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4027: END IF;
4028:
4029: EXCEPTION
4030: WHEN OTHERS THEN
4031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4032:
4033: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4034: FND_LOG.STRING(g_level_unexpected,
4035: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_lines',

Line 4089: x_return_status:= FND_API.G_RET_STS_SUCCESS;

4085: ' trx_line_dist_id = ' || p_trx_line_dist_id);
4086:
4087: END IF;
4088:
4089: x_return_status:= FND_API.G_RET_STS_SUCCESS;
4090:
4091: -- Initialize p_tax_line_tbl
4092: -- p_rec_nrec_dist_tbl.delete;
4093:

Line 4103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4099:
4100: IF fetch_tax_distributions_csr%NOTFOUND THEN
4101:
4102: -- there is no tax distribution for the tax line and item dist, error out
4103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4104: CLOSE fetch_tax_distributions_csr;
4105: IF (g_level_statement >= g_current_runtime_level ) THEN
4106:
4107: FND_LOG.STRING(g_level_statement,

Line 4135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4131: END IF;
4132:
4133: EXCEPTION
4134: WHEN OTHERS THEN
4135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4136:
4137: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4138: FND_LOG.STRING(g_level_unexpected,
4139: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_distributions',

Line 4256: x_return_status := FND_API.G_RET_STS_SUCCESS;

4252: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_trx_line_info.BEGIN',
4253: 'ZX_TRD_SERVICES_PUB_PKG.populate_trx_line_info(+)');
4254: END IF;
4255:
4256: x_return_status := FND_API.G_RET_STS_SUCCESS;
4257: l_index := 1;
4258:
4259: OPEN get_trx_info_csr;
4260: FETCH get_trx_info_csr INTO

Line 4405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4401: END IF;
4402:
4403: EXCEPTION
4404: WHEN OTHERS THEN
4405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4406:
4407: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4408: FND_LOG.STRING(g_level_unexpected,
4409: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_trx_line_info',

Line 4442: x_return_status:= FND_API.G_RET_STS_SUCCESS;

4438: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_global_table.BEGIN',
4439: 'ZX_TRD_SERVICES_PUB_PKG.insert_global_table(+)');
4440: END IF;
4441:
4442: x_return_status:= FND_API.G_RET_STS_SUCCESS;
4443:
4444: IF p_rec_nrec_dist_tbl.count > 1000 THEN
4445:
4446: -- insert into global temporary table when there are more than 1000 tax distributions.

Line 4452: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4448:
4449: -- populate mandatory columns before inserting.
4450: populate_mandatory_columns(p_rec_nrec_dist_tbl, x_return_status);
4451:
4452: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4453:
4454: IF (g_level_statement >= g_current_runtime_level ) THEN
4455: FND_LOG.STRING(g_level_statement,
4456: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_global_table',

Line 4487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4483: END IF;
4484:
4485: EXCEPTION
4486: WHEN OTHERS THEN
4487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4488:
4489: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4490: FND_LOG.STRING(g_level_unexpected,
4491: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_global_table',

Line 4525: x_return_status:= FND_API.G_RET_STS_SUCCESS;

4521: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns.BEGIN',
4522: 'populate_mandatory_columns(+)');
4523: END IF;
4524:
4525: x_return_status:= FND_API.G_RET_STS_SUCCESS;
4526:
4527: IF p_rec_nrec_dist_tbl.count <> 0 THEN
4528:
4529: FOR i IN NVL(p_rec_nrec_dist_tbl.FIRST,0) .. NVL(p_rec_nrec_dist_tbl.LAST,-1)

Line 4575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

4571: END IF;
4572:
4573: IF p_rec_nrec_dist_tbl(i).REC_NREC_TAX_DIST_NUMBER IS NULL THEN
4574:
4575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
4576:
4577: IF (g_level_procedure >= g_current_runtime_level ) THEN
4578: FND_LOG.STRING(g_level_procedure,
4579: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',

Line 4591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4587:
4588: END IF;
4589:
4590: IF p_rec_nrec_dist_tbl(i).REC_NREC_RATE IS NULL THEN
4591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4592:
4593: IF (g_level_procedure >= g_current_runtime_level ) THEN
4594: FND_LOG.STRING(g_level_procedure,
4595: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',

Line 4608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4604: END IF;
4605:
4606: IF p_rec_nrec_dist_tbl(i).Recoverable_Flag IS NULL THEN
4607:
4608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4609: IF (g_level_procedure >= g_current_runtime_level ) THEN
4610:
4611: FND_LOG.STRING(g_level_procedure,
4612: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',

Line 4624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4620: END IF;
4621:
4622: IF p_rec_nrec_dist_tbl(i).REC_NREC_TAX_AMT IS NULL THEN
4623:
4624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4625:
4626: IF (g_level_procedure >= g_current_runtime_level ) THEN
4627: FND_LOG.STRING(g_level_procedure,
4628: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',

Line 4660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4656: END IF;
4657:
4658: EXCEPTION
4659: WHEN OTHERS THEN
4660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4661:
4662: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4663: FND_LOG.STRING(g_level_unexpected,
4664: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',

Line 4815: x_return_status := FND_API.G_RET_STS_SUCCESS;

4811: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.update_exchange_rate.BEGIN',
4812: 'ZX_TRD_SERVICES_PUB_PKG.update_exchange_rate(+)');
4813: END IF;
4814:
4815: x_return_status := FND_API.G_RET_STS_SUCCESS;
4816:
4817: OPEN get_rec_nrec_tax_dists_csr;
4818:
4819: FETCH get_rec_nrec_tax_dists_csr BULK COLLECT INTO

Line 5554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5550: EXCEPTION
5551:
5552: WHEN OTHERS THEN
5553:
5554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5555: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5556:
5557: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5558: FND_LOG.STRING(g_level_unexpected,

Line 5836: x_return_status:= FND_API.G_RET_STS_SUCCESS;

5832: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.is_recoverability_affected.BEGIN',
5833: 'ZX_TRD_SERVICES_PUB_PKG.is_recoverability_affected(+)');
5834: END IF;
5835:
5836: x_return_status:= FND_API.G_RET_STS_SUCCESS;
5837:
5838: -- loop through the item distribution data structure passed by product
5839: --
5840: FOR i IN NVL(p_pa_item_info_tbl.FIRST, 0) .. NVL(p_pa_item_info_tbl.LAST, -1)

Line 5944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5940: END IF;
5941:
5942: EXCEPTION
5943: WHEN OTHERS THEN
5944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5945: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5946:
5947: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5948: FND_LOG.STRING(g_level_unexpected,

Line 6183: x_return_status:= FND_API.G_RET_STS_SUCCESS;

6179: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.delete_unnecessary_tax_dists.BEGIN',
6180: 'ZX_TRD_SERVICES_PUB_PKG.delete_unnecessary_tax_dists(+)');
6181: END IF;
6182:
6183: x_return_status:= FND_API.G_RET_STS_SUCCESS;
6184:
6185: -- Modified code as part of bug#7515711 to ensure that additional distributions
6186: -- are not created for Historical Invoices on re-validation.
6187:

Line 6340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6336: END IF;
6337:
6338: EXCEPTION
6339: WHEN OTHERS THEN
6340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6341:
6342: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6343: FND_LOG.STRING(g_level_unexpected,
6344: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.delete_unnecessary_tax_dists',

Line 6369: x_return_status:= FND_API.G_RET_STS_SUCCESS;

6365: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.update_posting_flag.BEGIN',
6366: 'ZX_TRD_SERVICES_PUB_PKG.update_posting_flag(+)');
6367: END IF;
6368:
6369: x_return_status:= FND_API.G_RET_STS_SUCCESS;
6370:
6371: FORALL i IN NVL(p_tax_dist_id_tbl.FIRST, 0) .. NVL(p_tax_dist_id_tbl.LAST, -1)
6372: UPDATE ZX_Rec_Nrec_Dist
6373: SET posting_flag = 'A'

Line 6384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6380: END IF;
6381:
6382: EXCEPTION
6383: WHEN OTHERS THEN
6384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6385: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6386:
6387: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6388: FND_LOG.STRING(g_level_unexpected,

Line 6514: x_return_status := FND_API.G_RET_STS_SUCCESS;

6510: 'ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID(+)');
6511:
6512: END IF;
6513:
6514: x_return_status := FND_API.G_RET_STS_SUCCESS;
6515: p_tax_jurisdiction_id := NULL;
6516:
6517: open is_jurisdiction_acc_appl(p_tax_line_id);
6518: fetch is_jurisdiction_acc_appl into l_lines_count;

Line 6569: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

6565: l_event_class_rec.trx_date := l_trx_date;
6566:
6567: init_mand_columns(l_event_class_rec,
6568: x_return_status);
6569: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6570: IF (g_level_statement >= g_current_runtime_level ) THEN
6571: FND_LOG.STRING(g_level_statement,
6572: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6573: 'After calling init_mand_columns, x_return_status = '|| x_return_status);

Line 6704: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6700: x_geography_id,
6701: x_geography_code,
6702: x_geography_name,
6703: x_return_status);
6704: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6705: IF (g_level_statement >= g_current_runtime_level ) THEN
6706: FND_LOG.STRING(g_level_statement,
6707: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6708: 'Incorrect return_status after calling ' ||

Line 6752: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6748: l_trx_date,
6749: l_zone_tbl,
6750: -----l_geography_id(i),
6751: x_return_status);
6752: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6753: IF (g_level_statement >= g_current_runtime_level ) THEN
6754: FND_LOG.STRING(g_level_statement,
6755: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6756: 'Incorrect return_status after calling ' ||

Line 6793: END IF; --x_return_status <> FND_API.G_RET_STS_SUCCESS

6789: NULL;
6790: END;
6791: END LOOP; --j in l_zone_tbl.first..l_zone_tbl.last LOOP
6792: END IF; --l_zone_tbl.count > 0 THEN
6793: END IF; --x_return_status <> FND_API.G_RET_STS_SUCCESS
6794: END IF; --g_geography_use_info_tbl(l_tbl_index).geography_use = 'MASTER_REF' THEN
6795: END IF; --NOT g_geography_use_info_tbl.EXISTS(l_tbl_index) THEN
6796: i := i + 1;
6797: END LOOP; --WHILE NOT l_jurisdiction_found LOOP

Line 6816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6812: END IF;
6813:
6814: EXCEPTION
6815: WHEN OTHERS THEN
6816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6817: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6818:
6819: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6820: FND_LOG.STRING(g_level_unexpected,

Line 6838: x_return_status := FND_API.G_RET_STS_SUCCESS;

6834: l_error_buffer VARCHAR2(200);
6835: BEGIN
6836:
6837: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6838: x_return_status := FND_API.G_RET_STS_SUCCESS;
6839:
6840: IF (g_level_procedure >= g_current_runtime_level ) THEN
6841: FND_LOG.STRING(g_level_procedure,
6842: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.INIT_MAND_COLUMNS.BEGIN',

Line 6870: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6866: IF ZX_API_PUB.G_DATA_TRANSFER_MODE <> 'TAB' THEN
6867: ZX_VALID_INIT_PARAMS_PKG.calculate_tax(x_return_status => x_return_status,
6868: p_event_class_rec => p_event_class_rec);
6869:
6870: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6871: IF (g_level_statement >= g_current_runtime_level ) THEN
6872: FND_LOG.STRING(g_level_statement,
6873: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.INIT_MAND_COLUMNS',
6874: 'After calling calculate_tax, x_return_status = '|| x_return_status);

Line 6883: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6879: END IF;
6880: ELSE
6881: ZX_VALID_INIT_PARAMS_PKG.import_document_with_tax(x_return_status => x_return_status,
6882: p_event_class_rec => p_event_class_rec);
6883: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6884: IF (g_level_statement >= g_current_runtime_level ) THEN
6885: FND_LOG.STRING(g_level_statement,
6886: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.INIT_MAND_COLUMNS',
6887: 'After calling import_document_with_tax, x_return_status = '|| x_return_status);

Line 6897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6893: END IF;
6894:
6895: EXCEPTION
6896: WHEN OTHERS THEN
6897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6898: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6899:
6900: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6901: FND_LOG.STRING(g_level_unexpected,