APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_AP_ETDS_ERRORS_T

Line 3300: Select Error_Message from jai_ap_etds_errors_t

3296: group by base_vendor_id, base_vendor_site_id,tds_tax_id ;
3297:
3298:
3299: CURSOR c_get_errors(cp_batch_id JAI_AP_ETDS_T.batch_id%TYPE ) IS
3300: Select Error_Message from jai_ap_etds_errors_t
3301: where batch_id = cp_batch_id ;
3302:
3303: -- File Header Variables
3304: v_line_number NUMBER(6); --File.Sql.35 Cbabu := 0;

Line 3623: insert into jai_ap_etds_errors_t

3619: p_return_message => p_return_message
3620: );
3621: IF p_return_code = 'E' THEN
3622: IF lv_action = 'V' THEN
3623: insert into jai_ap_etds_errors_t
3624: (batch_id, record_type, reference_id, error_message) values
3625: ( ln_batch_id,'DD', v_line_number, p_return_message ) ;
3626: ELSE
3627: p_ret_code := jai_constants.request_error ;

Line 4041: insert into jai_ap_etds_errors_t

4037: );
4038:
4039: IF p_return_code = 'E' THEN
4040: IF lv_action = 'V' THEN
4041: insert into jai_ap_etds_errors_t
4042: (batch_id, record_type, error_message) values
4043: ( ln_batch_id, 'FH', p_return_message ) ;
4044: ELSE
4045: p_ret_code := jai_constants.request_error ;

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

4174: );
4175:
4176: IF p_return_code = 'E' THEN
4177: IF lv_action = 'V' THEN
4178: insert into jai_ap_etds_errors_t(batch_id, record_type, error_message) values
4179: ( ln_batch_id, 'BH', p_return_message ) ;
4180: ELSE
4181: p_ret_code := jai_constants.request_error ;
4182: p_err_buf := p_return_message ;

Line 4342: insert into jai_ap_etds_errors_t

4338: p_return_message => p_return_message
4339: );
4340: IF p_return_code = 'E' THEN
4341: IF lv_action = 'V' THEN
4342: insert into jai_ap_etds_errors_t
4343: (batch_id, record_type, reference_id, error_message) values
4344: ( ln_batch_id, 'CD', v_line_number, p_return_message ) ;
4345: ELSE
4346: p_ret_code := jai_constants.request_error ;