APPS.JAI_ETCS_PKG dependencies on JAI_AP_ETDS_ERRORS_T

Line 2666: Select Error_Message from jai_ap_etds_errors_t

2662: FROM hr_locations_all
2663: WHERE location_id = p_location_id;
2664:
2665: CURSOR c_get_errors(cp_batch_id JAI_AP_ETDS_T.batch_id%TYPE ) IS
2666: Select Error_Message from jai_ap_etds_errors_t
2667: where batch_id = cp_batch_id ;
2668:
2669: ln_errors_exist number ;
2670:

Line 3113: INSERT INTO jai_ap_etds_errors_t

3109: );
3110:
3111: IF p_return_code = 'E' THEN
3112: IF lv_action = 'V' THEN
3113: INSERT INTO jai_ap_etds_errors_t
3114: (batch_id, record_type, reference_id, error_message) VALUES
3115: ( ln_batch_id,'DD', v_line_number, p_return_message ) ;
3116: ELSE
3117: p_ret_code := jai_constants.request_error ;

Line 3388: INSERT INTO jai_ap_etds_errors_t

3384: );
3385:
3386: IF p_return_code = 'E' THEN
3387: IF lv_action = 'V' THEN
3388: INSERT INTO jai_ap_etds_errors_t
3389: (batch_id, record_type, error_message) values
3390: ( ln_batch_id, 'FH', p_return_message ) ;
3391: ELSE
3392: p_ret_code := jai_constants.request_error ;

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

3609:
3610:
3611: IF p_return_code = 'E' THEN
3612: IF lv_action = 'V' THEN
3613: insert into jai_ap_etds_errors_t(batch_id, record_type, error_message) values
3614: ( ln_batch_id, 'BH', p_return_message ) ;
3615: ELSE
3616: p_ret_code := jai_constants.request_error ;
3617: p_err_buf := p_return_message ;

Line 3827: insert into jai_ap_etds_errors_t

3823:
3824:
3825: IF p_return_code = 'E' THEN
3826: IF lv_action = 'V' THEN
3827: insert into jai_ap_etds_errors_t
3828: (batch_id, record_type, reference_id, error_message) values
3829: ( ln_batch_id, 'CD', v_line_number, p_return_message ) ;
3830: ELSE
3831: p_ret_code := jai_constants.request_error ;