DBA Data[Home] [Help]

APPS.ZX_TRX_DETAIL dependencies on ZX_ERRORS_GT

Line 3485: l_error_msg ZX_ERRORS_GT.message_text%TYPE;

3481:
3482: IS
3483:
3484: l_count NUMBER;
3485: l_error_msg ZX_ERRORS_GT.message_text%TYPE;
3486:
3487: TYPE msg_string_tbl IS TABLE OF
3488: ZX_ERRORS_GT.message_text%TYPE
3489: INDEX BY BINARY_INTEGER;

Line 3488: ZX_ERRORS_GT.message_text%TYPE

3484: l_count NUMBER;
3485: l_error_msg ZX_ERRORS_GT.message_text%TYPE;
3486:
3487: TYPE msg_string_tbl IS TABLE OF
3488: ZX_ERRORS_GT.message_text%TYPE
3489: INDEX BY BINARY_INTEGER;
3490:
3491: l_msg_string_tbl MSG_STRING_TBL;
3492:

Line 3500: FROM ZX_ERRORS_GT

3496: c_application_id NUMBER,
3497: c_entity_code VARCHAR2)
3498: IS
3499: SELECT message_text
3500: FROM ZX_ERRORS_GT
3501: WHERE trx_id = c_trx_id
3502: AND event_class_code = c_event_class_code
3503: AND application_id = c_application_id
3504: AND entity_code = c_entity_code;

Line 3534: -- need to fetch error messages from zx_errors_gt

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: --
3536: OPEN c_get_error_msg(
3537: p_trx_id,
3538: p_event_class_code,

Line 3551: 'Count in zx_errors_gt: ' ||

3547:
3548: IF (g_level_procedure >= g_current_runtime_level ) THEN
3549: FND_LOG.STRING(g_level_procedure,
3550: 'ZX.PLSQL.ZX_TRX_DETAIL.get_error_msg',
3551: 'Count in zx_errors_gt: ' ||
3552: TO_CHAR(l_count));
3553: END IF;
3554:
3555: IF l_count > 0 THEN