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

Line 1015: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1011: x_msg_data => l_msg_data,
1012: p_transaction_line_rec => l_transaction_line_rec);
1013:
1014:
1015: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1016: RETURN;
1017: END IF;
1018:
1019: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 2547: p_init_msg_list => FND_API.G_TRUE,

2543: IF l_trx_lines > l_trx_lines_sync and l_trx_lines_sync <> 0 THEN
2544:
2545:
2546: ZX_API_PUB.CALCULATE_TAX(p_api_version => 1.0,
2547: p_init_msg_list => FND_API.G_TRUE,
2548: p_commit => NULL,
2549: p_validation_level => NULL,
2550: x_return_status => l_return_status,
2551: x_msg_count => l_msg_count,

Line 2564: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2560: END IF;
2561:
2562: x_return_status := l_return_status;
2563:
2564: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2565:
2566: IF l_msg_count = 1 THEN
2567: x_msg_data := l_msg_data;
2568: ELSE

Line 2593: p_init_msg_list => FND_API.G_TRUE,

2589:
2590: ELSIF l_trx_lines = l_trx_lines_sync THEN
2591:
2592: ZX_API_PUB.SYNCHRONIZE_TAX_REPOSITORY (p_api_version => 1.0,
2593: p_init_msg_list => FND_API.G_TRUE,
2594: p_commit => NULL,
2595: p_validation_level => NULL,
2596: x_return_status => l_return_status,
2597: x_msg_count => l_msg_count,

Line 2603: p_init_msg_list => FND_API.G_TRUE,

2599: p_sync_trx_rec => NULL,
2600: p_sync_trx_lines_tbl => NULL);
2601:
2602: ZX_API_PUB.CALCULATE_TAX(p_api_version => 1.0,
2603: p_init_msg_list => FND_API.G_TRUE,
2604: p_commit => NULL,
2605: p_validation_level => NULL,
2606: x_return_status => l_return_status,
2607: x_msg_count => l_msg_count,

Line 2621: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2617: END IF;
2618:
2619: x_return_status := l_return_status;
2620:
2621: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2622:
2623: IF l_msg_count = 1 THEN
2624: x_msg_data := l_msg_data;
2625: ELSE

Line 2657: p_init_msg_list => FND_API.G_TRUE,

2653: END IF;
2654:
2655:
2656: ZX_API_PUB.CALCULATE_TAX(p_api_version => 1.0,
2657: p_init_msg_list => FND_API.G_TRUE,
2658: p_commit => NULL,
2659: p_validation_level => NULL,
2660: x_return_status => l_return_status,
2661: x_msg_count => l_msg_count,

Line 2674: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2670: END IF;
2671:
2672: x_return_status := l_return_status;
2673:
2674: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2675:
2676: IF l_msg_count = 1 THEN
2677: x_msg_data := l_msg_data;
2678: ELSE

Line 2740: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2736: END IF;
2737:
2738: EXCEPTION
2739: WHEN OTHERS THEN
2740: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2741: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2742:
2743: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
2744: FND_MSG_PUB.Add;

Line 2904: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2900: END IF;
2901:
2902: EXCEPTION
2903: WHEN OTHERS THEN
2904: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2905: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2906:
2907: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
2908: FND_MSG_PUB.Add;

Line 2948: p_return_status := FND_API.G_RET_STS_SUCCESS;

2944: 'ZX.PLSQL.ZX_TRX_DETAIL.mark_reporting_only_flag.BEGIN',
2945: 'ZX_TRX_DETAIL: mark_reporting_only_flag(+)');
2946: END IF;
2947:
2948: p_return_status := FND_API.G_RET_STS_SUCCESS;
2949:
2950: UPDATE ZX_LINES
2951: SET
2952: REPORTING_ONLY_FLAG = p_reporting_flag ,

Line 2981: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2977: END IF;
2978:
2979: EXCEPTION
2980: WHEN OTHERS THEN
2981: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2982: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2983: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
2984: FND_MSG_PUB.Add;
2985:

Line 3021: p_return_status := FND_API.G_RET_STS_SUCCESS;

3017: 'ZX.PLSQL.ZX_TRX_DETAIL.perform_purge.BEGIN',
3018: 'ZX_TRX_DETAIL: perform_purge(+)');
3019: END IF;
3020:
3021: p_return_status := FND_API.G_RET_STS_SUCCESS;
3022:
3023: IF (g_level_statement >= g_current_runtime_level ) THEN
3024: FND_LOG.STRING(g_level_statement,
3025: 'ZX.PLSQL.ZX_TRX_DETAIL.perform_purge',

Line 3122: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3118: END IF;
3119:
3120: EXCEPTION
3121: WHEN OTHERS THEN
3122: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3123: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3124: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
3125: FND_MSG_PUB.Add;
3126:

Line 3180: l_return_status := FND_API.G_RET_STS_SUCCESS;

3176: 'ZX.PLSQL.ZX_TRX_DETAIL.process_purge',
3177: 'p_trx_id = ' || TO_CHAR(p_trx_id));
3178: END IF;
3179:
3180: l_return_status := FND_API.G_RET_STS_SUCCESS;
3181:
3182: OPEN get_purge_single_csr(p_trx_id);
3183: FETCH get_purge_single_csr INTO
3184: l_application_id_tbl(1),

Line 3200: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

3196: l_trx_id_tbl,
3197: l_return_status,
3198: l_error_buffer);
3199:
3200: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3201: --
3202: -- delete row from ZX_SIM_PURGE table
3203: --
3204: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 3222: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3218: END IF;
3219:
3220: EXCEPTION
3221: WHEN OTHERS THEN
3222: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3223: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3224: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
3225: FND_MSG_PUB.Add;
3226:

Line 3275: l_return_status := FND_API.G_RET_STS_SUCCESS;

3271: 'ZX.PLSQL.ZX_TRX_DETAIL.process_purge.BEGIN',
3272: 'ZX_TRX_DETAIL: process_purge(+)');
3273: END IF;
3274:
3275: l_return_status := FND_API.G_RET_STS_SUCCESS;
3276:
3277: OPEN get_purge_all_csr;
3278: LOOP
3279: FETCH get_purge_all_csr BULK COLLECT INTO

Line 3305: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3301: l_trx_id_tbl,
3302: l_return_status,
3303: l_error_buffer);
3304:
3305: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3306: EXIT;
3307: END IF;
3308: ELSE
3309: --

Line 3318: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

3314: END LOOP;
3315:
3316: CLOSE get_purge_all_csr;
3317:
3318: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3319: --
3320: -- delete ZX_SIM_PURGE table
3321: --
3322: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 3340: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3336: END IF;
3337:
3338: EXCEPTION
3339: WHEN OTHERS THEN
3340: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3341: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3342: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
3343: FND_MSG_PUB.Add;
3344:

Line 3451: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3447:
3448:
3449: EXCEPTION
3450: WHEN OTHERS THEN
3451: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3452: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3453: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
3454: FND_MSG_PUB.Add;
3455:

Line 3516: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3512: END IF;
3513:
3514: x_msg_data := NULL;
3515:
3516: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3517: LOOP
3518: l_error_msg := FND_MSG_PUB.GET(FND_MSG_PUB.G_NEXT,
3519: FND_API.G_FALSE);
3520:

Line 3519: FND_API.G_FALSE);

3515:
3516: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3517: LOOP
3518: l_error_msg := FND_MSG_PUB.GET(FND_MSG_PUB.G_NEXT,
3519: FND_API.G_FALSE);
3520:
3521: IF l_error_msg IS NULL THEN
3522: EXIT;
3523: ELSE

Line 3527: ELSIF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3523: ELSE
3524: x_msg_data := x_msg_data ||'. '|| l_error_msg;
3525: END IF;
3526: END LOOP;
3527: ELSIF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3528: --
3529: -- should be FND_API.G_RET_STS_ERROR but
3530: -- currently many are set at wrong
3531: -- status of FND_API.G_RET_STS_UNEXP_ERROR

Line 3529: -- should be FND_API.G_RET_STS_ERROR but

3525: END IF;
3526: END LOOP;
3527: ELSIF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3528: --
3529: -- should be FND_API.G_RET_STS_ERROR but
3530: -- currently many are set at wrong
3531: -- status of FND_API.G_RET_STS_UNEXP_ERROR
3532: --
3533: --

Line 3531: -- status of FND_API.G_RET_STS_UNEXP_ERROR

3527: ELSIF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3528: --
3529: -- should be FND_API.G_RET_STS_ERROR but
3530: -- currently many are set at wrong
3531: -- status of FND_API.G_RET_STS_UNEXP_ERROR
3532: --
3533: --
3534: -- need to fetch error messages from zx_errors_gt
3535: --