APPS.JAI_ETCS_PKG dependencies on JAI_AP_ETDS_ERRORS_T

Line 2206: Select Error_Message from jai_ap_etds_errors_t

2202: FROM hr_locations_all
2203: WHERE location_id = p_location_id;
2204:
2205: CURSOR c_get_errors(cp_batch_id JAI_AP_ETDS_T.batch_id%TYPE ) IS
2206: Select Error_Message from jai_ap_etds_errors_t
2207: where batch_id = cp_batch_id ;
2208:
2209: ln_errors_exist number ;
2210:

Line 2607: INSERT INTO jai_ap_etds_errors_t

2603: );
2604:
2605: IF p_return_code = 'E' THEN
2606: IF lv_action = 'V' THEN
2607: INSERT INTO jai_ap_etds_errors_t
2608: (batch_id, record_type, reference_id, error_message) VALUES
2609: ( ln_batch_id,'DD', v_line_number, p_return_message ) ;
2610: ELSE
2611: p_ret_code := jai_constants.request_error ;

Line 2864: INSERT INTO jai_ap_etds_errors_t

2860: );
2861:
2862: IF p_return_code = 'E' THEN
2863: IF lv_action = 'V' THEN
2864: INSERT INTO jai_ap_etds_errors_t
2865: (batch_id, record_type, error_message) values
2866: ( ln_batch_id, 'FH', p_return_message ) ;
2867: ELSE
2868: p_ret_code := jai_constants.request_error ;

Line 3021: insert into jai_ap_etds_errors_t(batch_id, record_type, error_message) values

3017:
3018:
3019: IF p_return_code = 'E' THEN
3020: IF lv_action = 'V' THEN
3021: insert into jai_ap_etds_errors_t(batch_id, record_type, error_message) values
3022: ( ln_batch_id, 'BH', p_return_message ) ;
3023: ELSE
3024: p_ret_code := jai_constants.request_error ;
3025: p_err_buf := p_return_message ;

Line 3223: insert into jai_ap_etds_errors_t

3219:
3220:
3221: IF p_return_code = 'E' THEN
3222: IF lv_action = 'V' THEN
3223: insert into jai_ap_etds_errors_t
3224: (batch_id, record_type, reference_id, error_message) values
3225: ( ln_batch_id, 'CD', v_line_number, p_return_message ) ;
3226: ELSE
3227: p_ret_code := jai_constants.request_error ;