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 286: x_return_status:= FND_API.G_RET_STS_SUCCESS;

282: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY.BEGIN',
283: 'ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(+) ');
284: END IF;
285:
286: x_return_status:= FND_API.G_RET_STS_SUCCESS;
287: -- g_variance_calc_flag := 'N';
288:
289: l_old_trx_line_id := NUMBER_DUMMY;
290: l_old_trx_level_type := VAR_30_DUMMY;

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

324: ZX_TRL_MANAGE_TAX_PKG.Update_Item_Dist_Changed_Flag(
325: x_return_status,
326: p_event_class_rec);
327:
328: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
329: IF (g_level_statement >= g_current_runtime_level ) THEN
330: FND_LOG.STRING(g_level_statement,
331: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
332: 'After calling TRL, x_return_status = '|| x_return_status);

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

345: fetch_tax_lines ( p_event_class_rec,
346: l_tax_line_tbl,
347: x_return_status);
348:
349: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
350: IF (g_level_statement >= g_current_runtime_level ) THEN
351: FND_LOG.STRING(g_level_statement,
352: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
353: 'After calling fetch tax lines, x_return_status = '

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

415: populate_trx_line_info( l_tax_line_tbl,
416: i,
417: x_return_status);
418:
419: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
420: IF (g_level_statement >= g_current_runtime_level ) THEN
421: FND_LOG.STRING(g_level_statement,
422: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
423: 'After calling populate_trx_line_info, x_return_status = '

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

563: p_event_class_rec,
564: x_return_status,
565: p_error_buffer);
566:
567: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
568: IF (g_level_statement >= g_current_runtime_level ) THEN
569: FND_LOG.STRING(g_level_statement,
570: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
571: 'After calling cancel_tax_line x_return_status = '

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

691: p_event_class_rec,
692: x_return_status,
693: p_error_buffer);
694:
695: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
696: IF (g_level_statement >= g_current_runtime_level ) THEN
697: FND_LOG.STRING(g_level_statement,
698: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
699: 'After calling calc_tax_dist x_return_status = '

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

716: l_rec_nrec_dist_begin_index,
717: l_rec_nrec_dist_end_index,
718: x_return_status);
719:
720: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
721: IF (g_level_statement >= g_current_runtime_level ) THEN
722: FND_LOG.STRING(g_level_statement,
723: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
724: 'After calling fetch_tax_distributions x_return_status = '

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

729: END IF;
730: RETURN;
731: END IF;
732: ELSE -- wrong l_action
733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
734: IF (g_level_statement >= g_current_runtime_level ) THEN
735: FND_LOG.STRING(g_level_statement,
736: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
737: 'wrong dist level action code. l_action= '||l_action );

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

827: p_event_class_rec,
828: x_return_status,
829: p_error_buffer);
830:
831: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
832: IF (g_level_statement >= g_current_runtime_level ) THEN
833: FND_LOG.STRING(g_level_statement,
834: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
835: 'After calling calc_tax_dist x_return_status = '

Line 845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

841: RETURN;
842: END IF;
843:
844: ELSE -- wrong l_action
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
846: IF (g_level_statement >= g_current_runtime_level ) THEN
847: FND_LOG.STRING(g_level_statement,
848: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
849: 'wrong dist level action code ' );

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

866: l_rec_nrec_dist_end_index,
867: x_return_status,
868: p_error_buffer);
869:
870: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
871: IF (g_level_statement >= g_current_runtime_level ) THEN
872: FND_LOG.STRING(g_level_statement,
873: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
874: 'After calling get_rec_nrec_dist_amt x_return_status = '

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

891: l_tax_line_tbl(i).tax_amt_funcl_curr,
892: x_return_status,
893: p_error_buffer);
894:
895: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
896: IF (g_level_statement >= g_current_runtime_level ) THEN
897: FND_LOG.STRING(g_level_statement,
898: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
899: 'After calling ROUND_REC_NREC_AMT x_return_status = '

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

918: -- l_rec_nrec_dist_end_index,
919: -- x_return_status,
920: -- p_error_buffer);
921: --
922: -- IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
923: -- IF (g_level_statement >= g_current_runtime_level ) THEN
924: -- FND_LOG.STRING(g_level_statement,
925: -- 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
926: -- 'After calling create_mrc_tax_dists x_return_status = '

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

941: l_dist_tbl_begin_index,
942: l_rec_nrec_dist_end_index,
943: x_return_status);
944:
945: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
946: IF (g_level_statement >= g_current_runtime_level ) THEN
947: FND_LOG.STRING(g_level_statement,
948: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
949: 'After calling insert_global_table x_return_status = '

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

963:
964: -- populate mandatory columns before inserting.
965: populate_mandatory_columns(l_rec_nrec_dist_tbl,x_return_status);
966:
967: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
968: IF (g_level_statement >= g_current_runtime_level ) THEN
969: FND_LOG.STRING(g_level_statement,
970: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
971: 'After calling populate_mandatory_columns x_return_status = '

Line 991: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

987:
988: delete_unnecessary_tax_dists(p_event_class_rec => p_event_class_rec,
989: x_return_status => x_return_status);
990:
991: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
992: IF g_level_statement >= g_current_runtime_level THEN
993: FND_LOG.STRING(g_level_statement,
994: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY',
995: 'After calling delete_unnecessary_tax_dists, x_return_status = '

Line 1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1011: END IF;
1012:
1013: EXCEPTION
1014: WHEN OTHERS THEN
1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1016: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1017:
1018: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1019: FND_LOG.STRING(g_level_unexpected,

Line 1095: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1091: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY.BEGIN',
1092: 'ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY(+)');
1093: END IF;
1094:
1095: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1096:
1097: -- Initialize p_tax_line_tbl
1098: l_rec_nrec_dist_tbl.delete;
1099: g_variance_calc_flag := 'N';

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

1172: x_return_status,
1173: p_error_buffer
1174: );
1175:
1176: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1177:
1178: IF (g_level_statement >= g_current_runtime_level ) THEN
1179: FND_LOG.STRING(g_level_statement,
1180: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',

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

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

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

1228: l_rec_nrec_dist_begin_index,
1229: l_rec_nrec_dist_end_index,
1230: x_return_status);
1231:
1232: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1233:
1234: IF (g_level_statement >= g_current_runtime_level ) THEN
1235: FND_LOG.STRING(g_level_statement,
1236: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',

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

1252:
1253: -- populate mandatory columns before inserting.
1254: populate_mandatory_columns(l_rec_nrec_dist_tbl, x_return_status);
1255:
1256: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1257:
1258: IF (g_level_statement >= g_current_runtime_level ) THEN
1259: FND_LOG.STRING(g_level_statement,
1260: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',

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

1280: x_return_status,
1281: p_error_buffer
1282: );
1283:
1284: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1285:
1286: IF (g_level_statement >= g_current_runtime_level ) THEN
1287: FND_LOG.STRING(g_level_statement,
1288: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.OVERRIDE_RECOVERY',

Line 1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1305: END IF;
1306:
1307: EXCEPTION
1308: WHEN OTHERS THEN
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1310: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1311:
1312: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1313: FND_LOG.STRING(g_level_unexpected,

Line 1360: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1356: FND_LOG.STRING(g_level_procedure,
1357: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_TAX_DIST.BEGIN',
1358: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_TAX_DIST(+)');
1359: END IF;
1360: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1361:
1362: l_index:= 1;
1363:
1364: OPEN get_rec_nrec_dist_cur;

Line 1485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1481: END IF;
1482:
1483: EXCEPTION
1484: WHEN OTHERS THEN
1485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1486: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1487:
1488: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1489: FND_LOG.STRING(g_level_unexpected,

Line 1542: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1538: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX.BEGIN',
1539: 'ZX_TRD_SERVICES_PUB_PKG.VALIDATE_DOCUMENT_FOR_TAX(+)');
1540: END IF;
1541:
1542: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1543:
1544: l_code := NULL;
1545: l_tax_variance := 'N';
1546: l_tax_amount_range := 'N';

Line 1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1861: END IF;
1862:
1863: EXCEPTION
1864: WHEN OTHERS THEN
1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1866:
1867: IF get_hold_status_csr%ISOPEN THEN
1868: CLOSE get_hold_status_csr;
1869: END IF;

Line 1934: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1930: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS.BEGIN',
1931: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS(+)');
1932: END IF;
1933:
1934: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1935:
1936: SELECT zd.rec_nrec_tax_dist_id,
1937: gt.reversing_appln_id,
1938: gt.reversing_entity_code,

Line 2369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2365: END IF;
2366:
2367: EXCEPTION
2368: WHEN DUP_VAL_ON_INDEX THEN
2369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2370:
2371: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2372: FND_LOG.STRING(g_level_unexpected,
2373: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS',

Line 2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2377: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2378: END IF;
2379:
2380: WHEN OTHERS THEN
2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2382:
2383: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2384: FND_LOG.STRING(g_level_unexpected,
2385: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS',

Line 2537: x_return_status := FND_API.G_RET_STS_SUCCESS;

2533: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID.BEGIN',
2534: 'Account Source Tax Rate Id:'|| p_account_source_tax_rate_id);
2535: END IF;
2536:
2537: x_return_status := FND_API.G_RET_STS_SUCCESS;
2538:
2539: IF p_Recoverable_Flag = 'Y' then
2540: --start - Bug Fix - 5950624
2541: OPEN get_def_rec_settle_option_code(p_tax_rate_id);

Line 3106: x_return_status := FND_API.G_RET_STS_ERROR;

3102:
3103:
3104: IF p_rec_nrec_ccid is null THEN
3105: IF p_Recoverable_Flag = 'Y' THEN -- bug 4893261
3106: x_return_status := FND_API.G_RET_STS_ERROR;
3107: FND_MESSAGE.SET_NAME('ZX', 'ZX_INVALID_REC_CCID');
3108: FND_MSG_PUB.Add;
3109: IF (g_level_statement >= g_current_runtime_level ) THEN
3110:

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

3113: 'error: p_Recoverable_Flag is Y, but p_rec_nrec_ccid is null');
3114:
3115: END IF;
3116: ELSIF p_Recoverable_Flag = 'N' THEN
3117: x_return_status := FND_API.G_RET_STS_ERROR; -- bug 4893261,
3118: FND_MESSAGE.SET_NAME('ZX', 'ZX_INVALID_NREC_CCID');
3119: FND_MSG_PUB.Add;
3120: IF (g_level_statement >= g_current_runtime_level ) THEN
3121:

Line 3135: x_return_status := FND_API.G_RET_STS_ERROR;

3131: --at the tax rate level of the self assessed tax
3132: --bug 6807089 need to display proper error message when the ccid is invalid.
3133:
3134: IF p_Self_Assessed_Flag = 'Y' AND p_tax_liab_ccid IS NULL THEN
3135: x_return_status := FND_API.G_RET_STS_ERROR;
3136: FND_MESSAGE.SET_NAME('ZX', 'ZX_INVALID_LIAB_CCID');
3137: FND_MSG_PUB.Add;
3138: IF (g_level_statement >= g_current_runtime_level ) THEN
3139:

Line 3161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3157: END IF;
3158:
3159: EXCEPTION
3160: WHEN OTHERS THEN
3161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3162:
3163: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3164: FND_LOG.STRING(g_level_unexpected,
3165: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_CCID',

Line 3302: x_return_status := FND_API.G_RET_STS_SUCCESS;

3298: 'Ledger Id:'|| p_ledger_id);
3299: END IF;
3300:
3301:
3302: x_return_status := FND_API.G_RET_STS_SUCCESS;
3303:
3304: IF p_location_segment_id IS NULL THEN
3305: -- Get location_segment_id in case of credit memo for a migrated transaction
3306: open get_location_segment_id_csr(p_tax_line_id ) ;

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

3352: p_tax_rate_id,
3353: l_tax_jurisdiction_id,
3354: x_return_status);
3355:
3356: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3357: IF (g_level_statement >= g_current_runtime_level ) THEN
3358: FND_LOG.STRING(g_level_statement,
3359: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID',
3360: 'After calling get_tax_jurisdiction_id, x_return_status = '|| x_return_status);

Line 3528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3524:
3525:
3526: EXCEPTION
3527: WHEN OTHERS THEN
3528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3529:
3530: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3531: FND_LOG.STRING(g_level_unexpected,
3532: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_OUTPUT_TAX_CCID',

Line 3681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3677: END IF;
3678:
3679: EXCEPTION
3680: WHEN DUP_VAL_ON_INDEX THEN
3681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3682:
3683: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3684: FND_LOG.STRING(g_level_unexpected,
3685: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_item_dist',

Line 3693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3689: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3690: END IF;
3691:
3692: WHEN OTHERS THEN
3693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3694:
3695: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3696: FND_LOG.STRING(g_level_unexpected,
3697: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_item_dist',

Line 3758: x_return_status:= FND_API.G_RET_STS_SUCCESS;

3754: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_lines.BEGIN',
3755: 'ZX_TRD_SERVICES_PUB_PKG.fetch_tax_lines(+)');
3756: END IF;
3757:
3758: x_return_status:= FND_API.G_RET_STS_SUCCESS;
3759:
3760: -- Initialize p_tax_line_tbl
3761: p_tax_line_tbl.delete;
3762:

Line 3803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3799: END IF;
3800:
3801: EXCEPTION
3802: WHEN OTHERS THEN
3803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3804:
3805: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3806: FND_LOG.STRING(g_level_unexpected,
3807: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_lines',

Line 3861: x_return_status:= FND_API.G_RET_STS_SUCCESS;

3857: ' trx_line_dist_id = ' || p_trx_line_dist_id);
3858:
3859: END IF;
3860:
3861: x_return_status:= FND_API.G_RET_STS_SUCCESS;
3862:
3863: -- Initialize p_tax_line_tbl
3864: -- p_rec_nrec_dist_tbl.delete;
3865:

Line 3875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3871:
3872: IF fetch_tax_distributions_csr%NOTFOUND THEN
3873:
3874: -- there is no tax distribution for the tax line and item dist, error out
3875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3876: CLOSE fetch_tax_distributions_csr;
3877: IF (g_level_statement >= g_current_runtime_level ) THEN
3878:
3879: FND_LOG.STRING(g_level_statement,

Line 3907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3903: END IF;
3904:
3905: EXCEPTION
3906: WHEN OTHERS THEN
3907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3908:
3909: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3910: FND_LOG.STRING(g_level_unexpected,
3911: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.fetch_tax_distributions',

Line 4023: x_return_status := FND_API.G_RET_STS_SUCCESS;

4019: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_trx_line_info.BEGIN',
4020: 'ZX_TRD_SERVICES_PUB_PKG.populate_trx_line_info(+)');
4021: END IF;
4022:
4023: x_return_status := FND_API.G_RET_STS_SUCCESS;
4024: l_index := 1;
4025:
4026: OPEN get_trx_info_csr;
4027: FETCH get_trx_info_csr INTO

Line 4117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4113: END IF;
4114:
4115: EXCEPTION
4116: WHEN OTHERS THEN
4117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4118:
4119: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4120: FND_LOG.STRING(g_level_unexpected,
4121: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_trx_line_info',

Line 4154: x_return_status:= FND_API.G_RET_STS_SUCCESS;

4150: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_global_table.BEGIN',
4151: 'ZX_TRD_SERVICES_PUB_PKG.insert_global_table(+)');
4152: END IF;
4153:
4154: x_return_status:= FND_API.G_RET_STS_SUCCESS;
4155:
4156: IF p_rec_nrec_dist_tbl.count > 1000 THEN
4157:
4158: -- insert into global temporary table when there are more than 1000 tax distributions.

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

4160:
4161: -- populate mandatory columns before inserting.
4162: populate_mandatory_columns(p_rec_nrec_dist_tbl, x_return_status);
4163:
4164: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4165:
4166: IF (g_level_statement >= g_current_runtime_level ) THEN
4167: FND_LOG.STRING(g_level_statement,
4168: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_global_table',

Line 4199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4195: END IF;
4196:
4197: EXCEPTION
4198: WHEN OTHERS THEN
4199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4200:
4201: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4202: FND_LOG.STRING(g_level_unexpected,
4203: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.insert_global_table',

Line 4237: x_return_status:= FND_API.G_RET_STS_SUCCESS;

4233: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns.BEGIN',
4234: 'populate_mandatory_columns(+)');
4235: END IF;
4236:
4237: x_return_status:= FND_API.G_RET_STS_SUCCESS;
4238:
4239: IF p_rec_nrec_dist_tbl.count <> 0 THEN
4240:
4241: FOR i IN NVL(p_rec_nrec_dist_tbl.FIRST,0) .. NVL(p_rec_nrec_dist_tbl.LAST,-1)

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

4283: END IF;
4284:
4285: IF p_rec_nrec_dist_tbl(i).REC_NREC_TAX_DIST_NUMBER IS NULL THEN
4286:
4287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
4288:
4289: IF (g_level_procedure >= g_current_runtime_level ) THEN
4290: FND_LOG.STRING(g_level_procedure,
4291: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',

Line 4303: x_return_status := FND_API.G_RET_STS_ERROR;

4299:
4300: END IF;
4301:
4302: IF p_rec_nrec_dist_tbl(i).REC_NREC_RATE IS NULL THEN
4303: x_return_status := FND_API.G_RET_STS_ERROR;
4304:
4305: IF (g_level_procedure >= g_current_runtime_level ) THEN
4306: FND_LOG.STRING(g_level_procedure,
4307: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',

Line 4320: x_return_status := FND_API.G_RET_STS_ERROR;

4316: END IF;
4317:
4318: IF p_rec_nrec_dist_tbl(i).Recoverable_Flag IS NULL THEN
4319:
4320: x_return_status := FND_API.G_RET_STS_ERROR;
4321: IF (g_level_procedure >= g_current_runtime_level ) THEN
4322:
4323: FND_LOG.STRING(g_level_procedure,
4324: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',

Line 4336: x_return_status := FND_API.G_RET_STS_ERROR;

4332: END IF;
4333:
4334: IF p_rec_nrec_dist_tbl(i).REC_NREC_TAX_AMT IS NULL THEN
4335:
4336: x_return_status := FND_API.G_RET_STS_ERROR;
4337:
4338: IF (g_level_procedure >= g_current_runtime_level ) THEN
4339: FND_LOG.STRING(g_level_procedure,
4340: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',

Line 4372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4368: END IF;
4369:
4370: EXCEPTION
4371: WHEN OTHERS THEN
4372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4373:
4374: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4375: FND_LOG.STRING(g_level_unexpected,
4376: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_mandatory_columns',

Line 4527: x_return_status := FND_API.G_RET_STS_SUCCESS;

4523: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.update_exchange_rate.BEGIN',
4524: 'ZX_TRD_SERVICES_PUB_PKG.update_exchange_rate(+)');
4525: END IF;
4526:
4527: x_return_status := FND_API.G_RET_STS_SUCCESS;
4528:
4529: OPEN get_rec_nrec_tax_dists_csr;
4530:
4531: FETCH get_rec_nrec_tax_dists_csr BULK COLLECT INTO

Line 5268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5264: EXCEPTION
5265:
5266: WHEN OTHERS THEN
5267:
5268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5269: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5270:
5271: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5272: FND_LOG.STRING(g_level_unexpected,

Line 5550: x_return_status:= FND_API.G_RET_STS_SUCCESS;

5546: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.is_recoverability_affected.BEGIN',
5547: 'ZX_TRD_SERVICES_PUB_PKG.is_recoverability_affected(+)');
5548: END IF;
5549:
5550: x_return_status:= FND_API.G_RET_STS_SUCCESS;
5551:
5552: -- loop through the item distribution data structure passed by product
5553: --
5554: FOR i IN NVL(p_pa_item_info_tbl.FIRST, 0) .. NVL(p_pa_item_info_tbl.LAST, -1)

Line 5658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5654: END IF;
5655:
5656: EXCEPTION
5657: WHEN OTHERS THEN
5658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5659: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5660:
5661: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5662: FND_LOG.STRING(g_level_unexpected,

Line 5897: x_return_status:= FND_API.G_RET_STS_SUCCESS;

5893: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.delete_unnecessary_tax_dists.BEGIN',
5894: 'ZX_TRD_SERVICES_PUB_PKG.delete_unnecessary_tax_dists(+)');
5895: END IF;
5896:
5897: x_return_status:= FND_API.G_RET_STS_SUCCESS;
5898:
5899: -- Modified code as part of bug#7515711 to ensure that additional distributions
5900: -- are not created for Historical Invoices on re-validation.
5901:

Line 6052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6048: END IF;
6049:
6050: EXCEPTION
6051: WHEN OTHERS THEN
6052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6053:
6054: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6055: FND_LOG.STRING(g_level_unexpected,
6056: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.delete_unnecessary_tax_dists',

Line 6081: x_return_status:= FND_API.G_RET_STS_SUCCESS;

6077: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.update_posting_flag.BEGIN',
6078: 'ZX_TRD_SERVICES_PUB_PKG.update_posting_flag(+)');
6079: END IF;
6080:
6081: x_return_status:= FND_API.G_RET_STS_SUCCESS;
6082:
6083: FORALL i IN NVL(p_tax_dist_id_tbl.FIRST, 0) .. NVL(p_tax_dist_id_tbl.LAST, -1)
6084: UPDATE ZX_Rec_Nrec_Dist
6085: SET posting_flag = 'A'

Line 6096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6092: END IF;
6093:
6094: EXCEPTION
6095: WHEN OTHERS THEN
6096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6097: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6098:
6099: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6100: FND_LOG.STRING(g_level_unexpected,

Line 6186: x_return_status := FND_API.G_RET_STS_SUCCESS;

6182: 'ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID(+)');
6183:
6184: END IF;
6185:
6186: x_return_status := FND_API.G_RET_STS_SUCCESS;
6187: p_tax_jurisdiction_id := NULL;
6188:
6189: open is_jurisdiction_acc_appl(p_tax_line_id);
6190: fetch is_jurisdiction_acc_appl into l_lines_count;

Line 6273: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6269: x_geography_id,
6270: x_geography_code,
6271: x_geography_name,
6272: x_return_status);
6273: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6274: IF (g_level_statement >= g_current_runtime_level ) THEN
6275: FND_LOG.STRING(g_level_statement,
6276: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6277: 'Incorrect return_status after calling ' ||

Line 6298: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6294: l_trx_date,
6295: l_zone_tbl,
6296: -----l_geography_id(i),
6297: x_return_status);
6298: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6299: IF (g_level_statement >= g_current_runtime_level ) THEN
6300: FND_LOG.STRING(g_level_statement,
6301: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.GET_TAX_JURISDICTION_ID',
6302: 'Incorrect return_status after calling ' ||

Line 6373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6369: END IF;
6370:
6371: EXCEPTION
6372: WHEN OTHERS THEN
6373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6374: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6375:
6376: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6377: FND_LOG.STRING(g_level_unexpected,