APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_AP_ETDS_ERRORS_T

Line 5474: Select Error_Message from jai_ap_etds_errors_t

5470:
5471: ld_tds_gl_date date;
5472:
5473: CURSOR c_get_errors(cp_batch_id JAI_AP_ETDS_T.batch_id%TYPE ) IS
5474: Select Error_Message from jai_ap_etds_errors_t
5475: where batch_id = cp_batch_id ;
5476:
5477: -- File Header Variables
5478: v_line_number NUMBER(6); --File.Sql.35 Cbabu := 0;

Line 5890: insert into jai_ap_etds_errors_t

5886: p_return_message => p_return_message
5887: );
5888: IF p_return_code = 'E' THEN
5889: IF lv_action = 'V' THEN
5890: insert into jai_ap_etds_errors_t
5891: (batch_id, record_type, reference_id, error_message) values
5892: ( v_batch_id,'DD', v_line_number, p_return_message ) ; /*Bug 8880543 - Modified ln_batch_id to v_batch_id*/
5893: ELSE
5894: p_ret_code := jai_constants.request_error ;

Line 6620: insert into jai_ap_etds_errors_t

6616: );
6617:
6618: IF p_return_code = 'E' THEN
6619: IF lv_action = 'V' THEN
6620: insert into jai_ap_etds_errors_t
6621: (batch_id, record_type, error_message) values
6622: ( v_batch_id, 'FH', p_return_message ) ; /*Bug 8880543 - Modified ln_batch_id to v_batch_id*/
6623: ELSE
6624: p_ret_code := jai_constants.request_error ;

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

6789: );
6790:
6791: IF p_return_code = 'E' THEN
6792: IF lv_action = 'V' THEN
6793: insert into jai_ap_etds_errors_t(batch_id, record_type, error_message) values
6794: ( v_batch_id, 'BH', p_return_message ) ; /*Bug 8880543 - Modified ln_batch_id to v_batch_id*/
6795: ELSE
6796: p_ret_code := jai_constants.request_error ;
6797: p_err_buf := p_return_message ;

Line 6993: insert into jai_ap_etds_errors_t

6989: p_return_message => p_return_message
6990: );
6991: IF p_return_code = 'E' THEN
6992: IF lv_action = 'V' THEN
6993: insert into jai_ap_etds_errors_t
6994: (batch_id, record_type, reference_id, error_message) values
6995: ( v_batch_id, 'CD', v_line_number, p_return_message ) ; /*Bug 8880543 - Modified ln_batch_id to v_batch_id*/
6996: ELSE
6997: p_ret_code := jai_constants.request_error ;