DBA Data[Home] [Help]

APPS.ZX_SRVC_TYP_PKG dependencies on ZX_ERRORS_GT

Line 971: FROM ZX_ERRORS_GT err

967: AND header.application_id = p_event_class_rec.application_id
968: AND NVL(header.validation_check_flag, 'Y') = 'Y'
969: AND NOT EXISTS(
970: SELECT 1
971: FROM ZX_ERRORS_GT err
972: WHERE err.application_id = header.application_id
973: AND err.entity_code = header.entity_code
974: AND err.event_class_code = header.event_class_code
975: AND err.trx_id = header.trx_id)

Line 2304: FROM zx_errors_gt err_gt

2300: fnd_global.user_id USER_ID_2,
2301: fnd_global.conc_login_id
2302: FROM DUAL
2303: WHERE NOT EXISTS (SELECT 'Y'
2304: FROM zx_errors_gt err_gt
2305: WHERE err_gt.application_id = p_trx_line_dist_tbl.application_id(i)
2306: AND err_gt.entity_code = p_trx_line_dist_tbl.entity_code(i)
2307: AND err_gt.event_class_code = p_trx_line_dist_tbl.event_class_code(i)
2308: AND err_gt.trx_id = p_trx_line_dist_tbl.trx_id(i))

Line 2691: FROM zx_errors_gt err_gt

2687: AND TRX_ID = p_trx_line_dist_tbl.TRX_ID(i)
2688: AND TRX_LINE_ID = p_trx_line_dist_tbl.TRX_LINE_ID(i)
2689: AND TRX_LEVEL_TYPE = p_trx_line_dist_tbl.TRX_LEVEL_TYPE(i)
2690: AND NOT EXISTS (SELECT 'Y'
2691: FROM zx_errors_gt err_gt
2692: WHERE err_gt.application_id = p_trx_line_dist_tbl.application_id(i)
2693: AND err_gt.entity_code = p_trx_line_dist_tbl.entity_code(i)
2694: AND err_gt.event_class_code = p_trx_line_dist_tbl.event_class_code(i)
2695: AND err_gt.trx_id = p_trx_line_dist_tbl.trx_id(i));

Line 2984: FROM zx_errors_gt err_gt

2980: AND TRX_ID = p_trx_line_dist_tbl.TRX_ID(i)
2981: AND TRX_LINE_ID = p_trx_line_dist_tbl.TRX_LINE_ID(i)
2982: AND TRX_LEVEL_TYPE = p_trx_line_dist_tbl.TRX_LEVEL_TYPE(i)
2983: AND NOT EXISTS (SELECT 'Y'
2984: FROM zx_errors_gt err_gt
2985: WHERE err_gt.application_id = p_trx_line_dist_tbl.application_id(i)
2986: AND err_gt.entity_code = p_trx_line_dist_tbl.entity_code(i)
2987: AND err_gt.event_class_code = p_trx_line_dist_tbl.event_class_code(i)
2988: AND err_gt.trx_id = p_trx_line_dist_tbl.trx_id(i))

Line 8630: --Commented by ssohal : Call API to dump into zx_errors_gt

8626:
8627: EXCEPTION
8628: WHEN FND_API.G_EXC_ERROR THEN
8629: ROLLBACK TO Ptnr_Bulk_Calc_Tax_Pvt;
8630: --Commented by ssohal : Call API to dump into zx_errors_gt
8631: --populate_errors(l_event_class_rec,l_return_status); --this will retest l_return_status
8632: --ZX_API_PUB.dump_msg;
8633: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
8634: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');

Line 9643: -- Add error occurred for the trx into ZX_ERRORS_GT and continue

9639: | except key attributes at a index l_trx_line_index |
9640: +--------------------------------------------------------------*/
9641: Pop_Index_Attrbs_To_Null ( p_index => l_trx_line_index,
9642: x_return_status => l_return_status);
9643: -- Add error occurred for the trx into ZX_ERRORS_GT and continue
9644: ZX_API_PUB.Dump_Msg;
9645: END IF;
9646:
9647: END; -- End of Bug fix 5524869

Line 10498: --Commented by ssohal : Call API to dump into zx_errors_gt

10494:
10495: EXCEPTION
10496: WHEN FND_API.G_EXC_ERROR THEN
10497: ROLLBACK TO Calculate_Tax_LTE;
10498: --Commented by ssohal : Call API to dump into zx_errors_gt
10499: --populate_errors(l_event_class_rec,l_return_status); --this will retest l_return_status
10500: --ZX_API_PUB.dump_msg;
10501: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
10502: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');