APPS.ZX_SRVC_TYP_PKG dependencies on ZX_ERRORS_GT

Line 990: FROM ZX_ERRORS_GT err

986: AND header.application_id = p_event_class_rec.application_id
987: AND NVL(header.validation_check_flag, 'Y') = 'Y'
988: AND NOT EXISTS(
989: SELECT 1
990: FROM ZX_ERRORS_GT err
991: WHERE err.application_id = header.application_id
992: AND err.entity_code = header.entity_code
993: AND err.event_class_code = header.event_class_code
994: AND err.trx_id = header.trx_id)

Line 2358: FROM zx_errors_gt err_gt

2354: fnd_global.conc_login_id
2355: FROM DUAL
2356: WHERE p_trx_line_dist_tbl.LINE_LEVEL_ACTION(i) IS NOT NULL
2357: AND NOT EXISTS (SELECT 'Y'
2358: FROM zx_errors_gt err_gt
2359: WHERE err_gt.application_id = p_trx_line_dist_tbl.application_id(i)
2360: AND err_gt.entity_code = p_trx_line_dist_tbl.entity_code(i)
2361: AND err_gt.event_class_code = p_trx_line_dist_tbl.event_class_code(i)
2362: AND err_gt.trx_id = p_trx_line_dist_tbl.trx_id(i));

Line 2965: FROM zx_errors_gt err_gt

2961: 'ALLOCATE_TAX_ONLY_ADJUSTMENT',
2962: 'COPY_AND_CREATE',
2963: 'RECORD_WITH_NO_TAX')
2964: AND NOT EXISTS (SELECT 'Y'
2965: FROM zx_errors_gt err_gt
2966: WHERE err_gt.application_id = p_trx_line_dist_tbl.application_id(i)
2967: AND err_gt.entity_code = p_trx_line_dist_tbl.entity_code(i)
2968: AND err_gt.event_class_code = p_trx_line_dist_tbl.event_class_code(i)
2969: AND err_gt.trx_id = p_trx_line_dist_tbl.trx_id(i));

Line 3406: FROM zx_errors_gt err_gt

3402: AND TRX_LINE_ID = p_trx_line_dist_tbl.TRX_LINE_ID(i)
3403: AND TRX_LEVEL_TYPE = p_trx_line_dist_tbl.TRX_LEVEL_TYPE(i)
3404: AND p_trx_line_dist_tbl.LINE_LEVEL_ACTION(i) IS NOT NULL
3405: AND NOT EXISTS (SELECT 'Y'
3406: FROM zx_errors_gt err_gt
3407: WHERE err_gt.application_id = p_trx_line_dist_tbl.application_id(i)
3408: AND err_gt.entity_code = p_trx_line_dist_tbl.entity_code(i)
3409: AND err_gt.event_class_code = p_trx_line_dist_tbl.event_class_code(i)
3410: AND err_gt.trx_id = p_trx_line_dist_tbl.trx_id(i));

Line 3717: FROM zx_errors_gt err_gt

3713: 'SYNCHRONIZE',
3714: 'DELETE',
3715: 'UNAPPLY_FROM')
3716: AND NOT EXISTS (SELECT 'Y'
3717: FROM zx_errors_gt err_gt
3718: WHERE err_gt.application_id = p_trx_line_dist_tbl.application_id(i)
3719: AND err_gt.entity_code = p_trx_line_dist_tbl.entity_code(i)
3720: AND err_gt.event_class_code = p_trx_line_dist_tbl.event_class_code(i)
3721: AND err_gt.trx_id = p_trx_line_dist_tbl.trx_id(i));

Line 13341: -- Dump the LTE error messages to ZX_ERRORS_GT table

13337: 'g_ptnr_srvc_subscr_flag : '||
13338: zx_global_structures_pkg.g_ptnr_srvc_subscr_flag );
13339: END IF;
13340:
13341: -- Dump the LTE error messages to ZX_ERRORS_GT table
13342: ZX_API_PUB.dump_msg;
13343:
13344: -- if l_return_status from LTE returned error, it has
13345: -- been handled by the exception already, end of this