eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_CORRECT_CC_ERRORS dependencies on AR_CC_ERROR_HISTORY

Line 26: PROCEDURE insert_p(p_cc_error_hist IN ar_cc_error_history%ROWTYPE);

22: x_first_record_flag OUT NOCOPY VARCHAR2,
23: x_cc_action_code OUT NOCOPY VARCHAR2,x_cc_action_type OUT NOCOPY VARCHAR2,
24: x_error_notes OUT NOCOPY VARCHAR2);
25:
26: PROCEDURE insert_p(p_cc_error_hist IN ar_cc_error_history%ROWTYPE);
27:
28: PROCEDURE clear_invoice_pay_info(p_customer_trx_id IN NUMBER,
29: p_cc_trx_category IN VARCHAR2,
30: p_source_receipt_id IN NUMBER DEFAULT NULL,

Line 354: FROM ar_cc_error_history cc, iby_fndcpt_tx_extensions b

350: SELECT 1
351: INTO l_dummy_number
352: FROM dual
353: WHERE NOT EXISTS ( SELECT 1
354: FROM ar_cc_error_history cc, iby_fndcpt_tx_extensions b
355: WHERE cc.cc_trx_id = p_cc_trx_id
356: AND cc.cc_trx_category = p_cc_trx_category
357: AND cc.payment_trxn_extension_id = b.trxn_extension_id
358: AND b.instr_assignment_id = l_instr_assignment_id

Line 381: FROM ar_cc_error_history cc, iby_fndcpt_tx_extensions b

377: BEGIN
378: arp_standard.debug( 'Checking if it is first time error');
379: SELECT cc.cc_error_date
380: INTO l_first_cc_error_date
381: FROM ar_cc_error_history cc, iby_fndcpt_tx_extensions b
382: WHERE cc.cc_trx_id = p_cc_trx_id
383: AND cc.cc_trx_category = p_cc_trx_category
384: AND cc.payment_trxn_extension_id = b.trxn_extension_id
385: AND b.instr_assignment_id = l_instr_assignment_id

Line 438: | Inserts the record into ar_cc_error_history

434: | PROCEDURE
435: | insert_p
436: |
437: | DESCRIPTION
438: | Inserts the record into ar_cc_error_history
439: |
440: |
441: | SCOPE - PRIVATE
442: |

Line 456: PROCEDURE insert_p(p_cc_error_hist IN ar_cc_error_history%ROWTYPE) IS

452: |
453: | MODIFICATION HISTORY - Created by Srinivasa Kini - 25-Aug-2004
454: |
455: +===========================================================================*/
456: PROCEDURE insert_p(p_cc_error_hist IN ar_cc_error_history%ROWTYPE) IS
457: BEGIN
458: IF PG_DEBUG in ('Y', 'C') THEN
459: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.insert_p()+' );
460: END IF;

Line 461: INSERT INTO ar_cc_error_history

457: BEGIN
458: IF PG_DEBUG in ('Y', 'C') THEN
459: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.insert_p()+' );
460: END IF;
461: INSERT INTO ar_cc_error_history
462: (
463: request_id,
464: cc_trx_category,
465: cc_trx_id,

Line 1739: l_cc_error_hist ar_cc_error_history%ROWTYPE;

1735: | MODIFICATION HISTORY - Created by Srinivasa Kini - 25-Aug-2004
1736: |
1737: +===========================================================================*/
1738: PROCEDURE correct_remittance_errors(p_request_id IN NUMBER) IS
1739: l_cc_error_hist ar_cc_error_history%ROWTYPE;
1740: l_cc_trx_category ar_cc_error_history.cc_trx_category%TYPE;
1741: l_error_notes VARCHAR2(240);
1742: l_cc_error_desc VARCHAR2(240);
1743: l_first_record_flag VARCHAR2(1);

Line 1740: l_cc_trx_category ar_cc_error_history.cc_trx_category%TYPE;

1736: |
1737: +===========================================================================*/
1738: PROCEDURE correct_remittance_errors(p_request_id IN NUMBER) IS
1739: l_cc_error_hist ar_cc_error_history%ROWTYPE;
1740: l_cc_trx_category ar_cc_error_history.cc_trx_category%TYPE;
1741: l_error_notes VARCHAR2(240);
1742: l_cc_error_desc VARCHAR2(240);
1743: l_first_record_flag VARCHAR2(1);
1744: l_cc_action_type VARCHAR2(1);

Line 1802: -- Insert records into ar_cc_error_history

1798: p_cc_trx_category => cr_rec.type,
1799: p_error_notes => l_error_notes);
1800: END If;
1801:
1802: -- Insert records into ar_cc_error_history
1803: IF l_cc_action_code in ('RET','REAUT REC','REV REC') THEN
1804: -- Update current_record_flag in ar_cc_error_history
1805: IF NVL(l_first_record_flag,'N') <> 'Y' THEN
1806: UPDATE ar_cc_error_history

Line 1804: -- Update current_record_flag in ar_cc_error_history

1800: END If;
1801:
1802: -- Insert records into ar_cc_error_history
1803: IF l_cc_action_code in ('RET','REAUT REC','REV REC') THEN
1804: -- Update current_record_flag in ar_cc_error_history
1805: IF NVL(l_first_record_flag,'N') <> 'Y' THEN
1806: UPDATE ar_cc_error_history
1807: SET current_record_flag = 'N',
1808: last_update_date = sysdate,

Line 1806: UPDATE ar_cc_error_history

1802: -- Insert records into ar_cc_error_history
1803: IF l_cc_action_code in ('RET','REAUT REC','REV REC') THEN
1804: -- Update current_record_flag in ar_cc_error_history
1805: IF NVL(l_first_record_flag,'N') <> 'Y' THEN
1806: UPDATE ar_cc_error_history
1807: SET current_record_flag = 'N',
1808: last_update_date = sysdate,
1809: last_updated_by = pg_user_id,
1810: last_update_login = NVL(pg_login_id,pg_conc_login_id)

Line 1865: l_cc_error_hist ar_cc_error_history%ROWTYPE;

1861: | MODIFICATION HISTORY - Created by Srinivasa Kini - 25-Aug-2004
1862: |
1863: +===========================================================================*/
1864: PROCEDURE correct_creation_errors(p_request_id IN NUMBER) IS
1865: l_cc_error_hist ar_cc_error_history%ROWTYPE;
1866: l_cc_trx_category ar_cc_error_history.cc_trx_category%TYPE;
1867: l_error_notes VARCHAR2(240);
1868: l_cc_error_desc VARCHAR2(240);
1869: l_first_record_flag VARCHAR2(1);

Line 1866: l_cc_trx_category ar_cc_error_history.cc_trx_category%TYPE;

1862: |
1863: +===========================================================================*/
1864: PROCEDURE correct_creation_errors(p_request_id IN NUMBER) IS
1865: l_cc_error_hist ar_cc_error_history%ROWTYPE;
1866: l_cc_trx_category ar_cc_error_history.cc_trx_category%TYPE;
1867: l_error_notes VARCHAR2(240);
1868: l_cc_error_desc VARCHAR2(240);
1869: l_first_record_flag VARCHAR2(1);
1870: l_cc_action_type VARCHAR2(1);

Line 1922: -- Insert records into ar_cc_error_history

1918: p_cc_trx_category => inv_rec.type,
1919: p_error_notes => l_error_notes);
1920: END IF;
1921:
1922: -- Insert records into ar_cc_error_history
1923: IF l_cc_action_code in ('RET','CLR PAY INFO') THEN
1924: -- Update current_record_flag in ar_cc_error_history
1925: IF NVL(l_first_record_flag,'N') <> 'Y' THEN
1926: UPDATE ar_cc_error_history

Line 1924: -- Update current_record_flag in ar_cc_error_history

1920: END IF;
1921:
1922: -- Insert records into ar_cc_error_history
1923: IF l_cc_action_code in ('RET','CLR PAY INFO') THEN
1924: -- Update current_record_flag in ar_cc_error_history
1925: IF NVL(l_first_record_flag,'N') <> 'Y' THEN
1926: UPDATE ar_cc_error_history
1927: SET current_record_flag = 'N',
1928: last_update_date = sysdate,

Line 1926: UPDATE ar_cc_error_history

1922: -- Insert records into ar_cc_error_history
1923: IF l_cc_action_code in ('RET','CLR PAY INFO') THEN
1924: -- Update current_record_flag in ar_cc_error_history
1925: IF NVL(l_first_record_flag,'N') <> 'Y' THEN
1926: UPDATE ar_cc_error_history
1927: SET current_record_flag = 'N',
1928: last_update_date = sysdate,
1929: last_updated_by = pg_user_id,
1930: last_update_login = NVL(pg_login_id,pg_conc_login_id)

Line 1950: arp_util.debug('Calling Insert into ar_cc_error_history');

1946: l_cc_error_hist.payment_trxn_extension_id := inv_rec.payment_trxn_extension_id;
1947: l_cc_error_hist.first_record_flag := l_first_record_flag;
1948: l_cc_error_hist.current_record_flag := 'Y';
1949:
1950: arp_util.debug('Calling Insert into ar_cc_error_history');
1951: insert_p(l_cc_error_hist);
1952: END IF;
1953: END LOOP;
1954: IF PG_DEBUG in ('Y', 'C') THEN