APPS.AR_INVOICE_TABLE_HANDLER dependencies on AR_TRX_ERRORS_GT

Line 350: INSERT INTO ar_trx_errors_gt (

346: p_error_message VARCHAR2 default NULL,
347: p_invalid_value VARCHAR2 default NULL) AS
348: BEGIN
349:
350: INSERT INTO ar_trx_errors_gt (
351: trx_header_id,
352: trx_line_id,
353: trx_dist_id,
354: trx_salescredit_id,

Line 391: FROM ar_trx_errors_gt err,

387: SELECT ct.customer_trx_id
388: FROM ra_customer_trx ct
389: WHERE
390: EXISTS (SELECT 'error'
391: FROM ar_trx_errors_gt err,
392: ar_trx_header_gt head
393: WHERE err.trx_header_id = head.trx_header_id
394: AND head.customer_trx_id = ct.customer_trx_id);
395:

Line 406: from ar_trx_errors_gt err,

402: /* Delete everything else */
403: delete from ra_customer_trx
404: where customer_trx_id in (
405: select distinct th.customer_trx_id
406: from ar_trx_errors_gt err,
407: ar_trx_header_gt th
408: where err.trx_header_id = th.trx_header_id);
409:
410: delete from ra_customer_trx_lines

Line 413: from ar_trx_errors_gt err,

409:
410: delete from ra_customer_trx_lines
411: where customer_trx_id in (
412: select distinct th.customer_trx_id
413: from ar_trx_errors_gt err,
414: ar_trx_header_gt th
415: where err.trx_header_id = th.trx_header_id);
416:
417: delete from ra_cust_trx_line_gl_dist

Line 420: from ar_trx_errors_gt err,

416:
417: delete from ra_cust_trx_line_gl_dist
418: where customer_trx_id in (
419: select distinct th.customer_trx_id
420: from ar_trx_errors_gt err,
421: ar_trx_header_gt th
422: where err.trx_header_id = th.trx_header_id);
423:
424: delete from ar_payment_schedules

Line 427: from ar_trx_errors_gt err,

423:
424: delete from ar_payment_schedules
425: where customer_trx_id in (
426: select distinct th.customer_trx_id
427: from ar_trx_errors_gt err,
428: ar_trx_header_gt th
429: where err.trx_header_id = th.trx_header_id);
430:
431: delete from RA_CUST_TRX_LINE_SALESREPS

Line 434: from ar_trx_errors_gt err,

430:
431: delete from RA_CUST_TRX_LINE_SALESREPS
432: where customer_trx_id in (
433: select distinct th.customer_trx_id
434: from ar_trx_errors_gt err,
435: ar_trx_header_gt th
436: where err.trx_header_id = th.trx_header_id);
437:
438: END;

Line 521: ar_trx_errors_gt err

517:
518: CURSOR ar_trx_header_c IS
519: SELECT * FROM ar_trx_header_gt gt
520: WHERE NOT EXISTS ( SELECT 'X' FROM
521: ar_trx_errors_gt err
522: WHERE err.trx_header_id = gt.trx_header_id);
523:
524: CURSOR ar_trx_lines_c IS
525: SELECT * FROM ar_trx_lines_gt gt

Line 881: INSERT INTO ar_trx_errors_gt

877: IF ( l_creation_sign = 'A' ) THEN
878: NULL;
879: ELSIF ( l_creation_sign = 'P' ) THEN
880: IF (NVL( l_amount, 0 ) < 0) THEN
881: INSERT INTO ar_trx_errors_gt
882: ( trx_header_id,
883: error_message)
884: VALUES
885: ( ar_trx_header_rec.trx_header_id,

Line 891: INSERT INTO ar_trx_errors_gt

887: cleanup(p_customer_trx_id=>ar_trx_header_rec.CUSTOMER_TRX_ID);
888: END IF;
889: ELSIF ( l_creation_sign = 'N' ) THEN
890: IF (NVL( l_amount, 0 ) > 0) THEN
891: INSERT INTO ar_trx_errors_gt
892: ( trx_header_id,
893: error_message)
894: VALUES
895: ( ar_trx_header_rec.trx_header_id,

Line 1105: INSERT INTO ar_trx_errors_gt (

1101: THEN
1102: cleanup(p_customer_trx_id => l_cust_trx_id);
1103: x_errmsg := sqlerrm;
1104: x_return_status := fnd_api.g_ret_sts_unexp_error;
1105: INSERT INTO ar_trx_errors_gt (
1106: trx_header_id,
1107: error_message)
1108: VALUES
1109: ( ar_trx_header_rec.trx_header_id,