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.AR_ADD_FETCH_SELECT dependencies on STANDARD

Line 387: arp_standard.debug( 'on_select()+' );

383:
384: BEGIN
385:
386: IF PG_DEBUG in ('Y', 'C') THEN
387: arp_standard.debug( 'on_select()+' );
388: END IF;
389:
390: --
391: -- Open Transactions:

Line 900: arp_standard.debug( 'p_trx_number_find =>'||p_trx_number_find );

896: l_purchase_order_find := p_purchase_order_find;
897: l_transaction_category_find := p_transaction_category_find;
898:
899: IF PG_DEBUG in ('Y', 'C') THEN
900: arp_standard.debug( 'p_trx_number_find =>'||p_trx_number_find );
901: arp_standard.debug( 'p_trx_type_name_find =>'||p_trx_type_name_find );
902: arp_standard.debug( 'p_due_date_find =>'||p_due_date_find );
903: arp_standard.debug( 'p_trx_date_find =>'||p_trx_date_find );
904: arp_standard.debug( 'p_amt_due_rem_find =>'||p_amt_due_rem_find);

Line 901: arp_standard.debug( 'p_trx_type_name_find =>'||p_trx_type_name_find );

897: l_transaction_category_find := p_transaction_category_find;
898:
899: IF PG_DEBUG in ('Y', 'C') THEN
900: arp_standard.debug( 'p_trx_number_find =>'||p_trx_number_find );
901: arp_standard.debug( 'p_trx_type_name_find =>'||p_trx_type_name_find );
902: arp_standard.debug( 'p_due_date_find =>'||p_due_date_find );
903: arp_standard.debug( 'p_trx_date_find =>'||p_trx_date_find );
904: arp_standard.debug( 'p_amt_due_rem_find =>'||p_amt_due_rem_find);
905: END IF;

Line 902: arp_standard.debug( 'p_due_date_find =>'||p_due_date_find );

898:
899: IF PG_DEBUG in ('Y', 'C') THEN
900: arp_standard.debug( 'p_trx_number_find =>'||p_trx_number_find );
901: arp_standard.debug( 'p_trx_type_name_find =>'||p_trx_type_name_find );
902: arp_standard.debug( 'p_due_date_find =>'||p_due_date_find );
903: arp_standard.debug( 'p_trx_date_find =>'||p_trx_date_find );
904: arp_standard.debug( 'p_amt_due_rem_find =>'||p_amt_due_rem_find);
905: END IF;
906:

Line 903: arp_standard.debug( 'p_trx_date_find =>'||p_trx_date_find );

899: IF PG_DEBUG in ('Y', 'C') THEN
900: arp_standard.debug( 'p_trx_number_find =>'||p_trx_number_find );
901: arp_standard.debug( 'p_trx_type_name_find =>'||p_trx_type_name_find );
902: arp_standard.debug( 'p_due_date_find =>'||p_due_date_find );
903: arp_standard.debug( 'p_trx_date_find =>'||p_trx_date_find );
904: arp_standard.debug( 'p_amt_due_rem_find =>'||p_amt_due_rem_find);
905: END IF;
906:
907:

Line 904: arp_standard.debug( 'p_amt_due_rem_find =>'||p_amt_due_rem_find);

900: arp_standard.debug( 'p_trx_number_find =>'||p_trx_number_find );
901: arp_standard.debug( 'p_trx_type_name_find =>'||p_trx_type_name_find );
902: arp_standard.debug( 'p_due_date_find =>'||p_due_date_find );
903: arp_standard.debug( 'p_trx_date_find =>'||p_trx_date_find );
904: arp_standard.debug( 'p_amt_due_rem_find =>'||p_amt_due_rem_find);
905: END IF;
906:
907:
908: IF l_trx_number_find IS NOT NULL THEN

Line 922: arp_standard.debug( 'about to enter l_trx_bill_number_find ');

918:
919:
920: -- gtan temp
921: IF PG_DEBUG in ('Y', 'C') THEN
922: arp_standard.debug( 'about to enter l_trx_bill_number_find ');
923: END IF;
924:
925: IF l_trx_bill_number_find IS NOT NULL THEN
926: IF INSTR(l_trx_bill_number_find,'#') = 0 THEN

Line 934: arp_standard.debug( l_trx_bill_number_find);

930: l_trx_bill_number_find := ' AND ' || l_trx_bill_number_find;
931: l_trx_bill_number_find := REPLACE(l_trx_bill_number_find,'#','ci.cons_billing_number');
932: END IF;
933: IF PG_DEBUG in ('Y', 'C') THEN
934: arp_standard.debug( l_trx_bill_number_find);
935: END IF;
936:
937: -- gtan temp
938: IF PG_DEBUG in ('Y', 'C') THEN

Line 939: arp_standard.debug( 'about to leave l_trx_bill_number_find ');

935: END IF;
936:
937: -- gtan temp
938: IF PG_DEBUG in ('Y', 'C') THEN
939: arp_standard.debug( 'about to leave l_trx_bill_number_find ');
940: END IF;
941:
942: IF l_trx_type_name_find IS NOT NULL THEN
943: IF INSTR(l_trx_type_name_find,'#') = 0 THEN

Line 950: arp_standard.debug( l_trx_type_name_find );

946:
947: l_trx_type_name_find := ' AND ' ||l_trx_type_name_find;
948:
949: IF PG_DEBUG in ('Y', 'C') THEN
950: arp_standard.debug( l_trx_type_name_find );
951: END IF;
952: l_trx_type_name_find := REPLACE(l_trx_type_name_find,'#','ctt.name');
953: IF PG_DEBUG in ('Y', 'C') THEN
954: arp_standard.debug( l_trx_type_name_find );

Line 954: arp_standard.debug( l_trx_type_name_find );

950: arp_standard.debug( l_trx_type_name_find );
951: END IF;
952: l_trx_type_name_find := REPLACE(l_trx_type_name_find,'#','ctt.name');
953: IF PG_DEBUG in ('Y', 'C') THEN
954: arp_standard.debug( l_trx_type_name_find );
955: END IF;
956: END IF;
957:
958: IF l_due_date_find IS NOT NULL THEN

Line 975: arp_standard.debug( l_amt_due_rem_find);

971: END IF;
972:
973: l_amt_due_rem_find := ' AND ' ||l_amt_due_rem_find;
974: IF PG_DEBUG in ('Y', 'C') THEN
975: arp_standard.debug( l_amt_due_rem_find);
976: END IF;
977: l_amt_due_rem_find := REPLACE(l_amt_due_rem_find,'#','ps_inv.amount_due_remaining');
978: IF PG_DEBUG in ('Y', 'C') THEN
979: arp_standard.debug( l_amt_due_rem_find);

Line 979: arp_standard.debug( l_amt_due_rem_find);

975: arp_standard.debug( l_amt_due_rem_find);
976: END IF;
977: l_amt_due_rem_find := REPLACE(l_amt_due_rem_find,'#','ps_inv.amount_due_remaining');
978: IF PG_DEBUG in ('Y', 'C') THEN
979: arp_standard.debug( l_amt_due_rem_find);
980: END IF;
981: END IF;
982:
983: -- ARTA Changes

Line 1001: arp_standard.debug( 'about to leave l_amt_due_rem_find ');

997: END IF;
998:
999: -- gtan temp
1000: IF PG_DEBUG in ('Y', 'C') THEN
1001: arp_standard.debug( 'about to leave l_amt_due_rem_find ');
1002: END IF;
1003: -- ARTA Changes
1004: open_trx_lng := open_trx_lng || l_trx_type_name_find
1005: || l_due_date_find

Line 1016: arp_standard.debug( 'after open_trx_lng ');

1012: || l_order_by;
1013:
1014: -- gtan temp
1015: IF PG_DEBUG in ('Y', 'C') THEN
1016: arp_standard.debug( 'after open_trx_lng ');
1017: END IF;
1018:
1019: --
1020: -- Open, Parse and Execute the Open Transactions cursor.

Line 1027: arp_standard.debug( 'after c_open_trx ');

1023: c_open_trx := dbms_sql.open_cursor;
1024:
1025: -- gtan temp
1026: IF PG_DEBUG in ('Y', 'C') THEN
1027: arp_standard.debug( 'after c_open_trx ');
1028: END IF;
1029:
1030: dbms_sql.parse(c_open_trx , open_trx_lng , dbms_sql.v7 );
1031: -- gtan temp

Line 1033: arp_standard.debug( 'after parse c_open_trx ');

1029:
1030: dbms_sql.parse(c_open_trx , open_trx_lng , dbms_sql.v7 );
1031: -- gtan temp
1032: IF PG_DEBUG in ('Y', 'C') THEN
1033: arp_standard.debug( 'after parse c_open_trx ');
1034: END IF;
1035:
1036: dbms_sql.bind_variable(c_open_trx ,':p_apply_date' , p_apply_date );
1037: dbms_sql.bind_variable(c_open_trx ,':p_receipt_gl_date' , p_receipt_gl_date );

Line 1177: arp_standard.debug( 'Open, Parsed and Executed c_open_trx' );

1173:
1174: ignore := dbms_sql.execute(c_open_trx);
1175:
1176: IF PG_DEBUG in ('Y', 'C') THEN
1177: arp_standard.debug( 'Open, Parsed and Executed c_open_trx' );
1178: END IF;
1179:
1180: --
1181: -- Open, Parse and Execute the On Account cursor.

Line 1230: arp_standard.debug( 'Open, Parsed and Executed c_on_acct' );

1226:
1227: ignore := dbms_sql.execute(c_on_acct);
1228:
1229: IF PG_DEBUG in ('Y', 'C') THEN
1230: arp_standard.debug( 'Open, Parsed and Executed c_on_acct' );
1231: END IF;
1232:
1233: -----------------------------------------------------
1234: --

Line 1384: arp_standard.debug( 'Open, Parsed and Executed c_cm_apps' );

1380: dbms_sql.define_column(c_cm_apps,125,cm_apps_row.application_ref_type_meaning,80);
1381: ignore := dbms_sql.execute(c_cm_apps);
1382:
1383: IF PG_DEBUG in ('Y', 'C') THEN
1384: arp_standard.debug( 'Open, Parsed and Executed c_cm_apps' );
1385: END IF;
1386:
1387: END IF;
1388:

Line 1390: arp_standard.debug( 'on_select()-' );

1386:
1387: END IF;
1388:
1389: IF PG_DEBUG in ('Y', 'C') THEN
1390: arp_standard.debug( 'on_select()-' );
1391: END IF;
1392:
1393: EXCEPTION
1394: WHEN OTHERS THEN

Line 1396: arp_standard.debug( SQLERRM);

1392:
1393: EXCEPTION
1394: WHEN OTHERS THEN
1395: IF PG_DEBUG in ('Y', 'C') THEN
1396: arp_standard.debug( SQLERRM);
1397: arp_standard.debug('EXCEPTION: ar_add_fetch_select.on_select');
1398: END IF;
1399: RAISE;
1400:

Line 1397: arp_standard.debug('EXCEPTION: ar_add_fetch_select.on_select');

1393: EXCEPTION
1394: WHEN OTHERS THEN
1395: IF PG_DEBUG in ('Y', 'C') THEN
1396: arp_standard.debug( SQLERRM);
1397: arp_standard.debug('EXCEPTION: ar_add_fetch_select.on_select');
1398: END IF;
1399: RAISE;
1400:
1401: END on_select;

Line 1564: arp_standard.debug( 'on_fetch()+' );

1560:
1561: BEGIN
1562:
1563: IF PG_DEBUG in ('Y', 'C') THEN
1564: arp_standard.debug( 'on_fetch()+' );
1565: END IF;
1566:
1567: ------------------------------------------------------------
1568: --

Line 1580: arp_standard.debug( 'Open Trx Cursor is OPEN' );

1576: ------------------------------------------------------------
1577: IF dbms_sql.is_open(c_open_trx) THEN
1578:
1579: IF PG_DEBUG in ('Y', 'C') THEN
1580: arp_standard.debug( 'Open Trx Cursor is OPEN' );
1581: END IF;
1582: IF dbms_sql.fetch_rows(c_open_trx) > 0 THEN
1583:
1584: IF PG_DEBUG in ('Y', 'C') THEN

Line 1585: arp_standard.debug( 'And we have fetched a record from Open Trx' );

1581: END IF;
1582: IF dbms_sql.fetch_rows(c_open_trx) > 0 THEN
1583:
1584: IF PG_DEBUG in ('Y', 'C') THEN
1585: arp_standard.debug( 'And we have fetched a record from Open Trx' );
1586: END IF;
1587: dbms_sql.column_value_rowid(c_open_trx,1,open_trx_row.row_id);
1588: dbms_sql.column_value(c_open_trx,2,open_trx_row.cash_receipt_id);
1589: dbms_sql.column_value(c_open_trx,3,open_trx_row.customer_trx_id);

Line 1832: arp_standard.debug( 'Open Trx has no more records so we will close it' );

1828:
1829: ELSE
1830:
1831: IF PG_DEBUG in ('Y', 'C') THEN
1832: arp_standard.debug( 'Open Trx has no more records so we will close it' );
1833: END IF;
1834: dbms_sql.close_cursor(c_open_trx);
1835:
1836: IF PG_DEBUG in ('Y', 'C') THEN

Line 1837: arp_standard.debug( 'But On Acct is open' );

1833: END IF;
1834: dbms_sql.close_cursor(c_open_trx);
1835:
1836: IF PG_DEBUG in ('Y', 'C') THEN
1837: arp_standard.debug( 'But On Acct is open' );
1838: END IF;
1839: ignore := dbms_sql.fetch_rows(c_on_acct);
1840:
1841: IF PG_DEBUG in ('Y', 'C') THEN

Line 1842: arp_standard.debug( 'On Acct cursor has a record' );

1838: END IF;
1839: ignore := dbms_sql.fetch_rows(c_on_acct);
1840:
1841: IF PG_DEBUG in ('Y', 'C') THEN
1842: arp_standard.debug( 'On Acct cursor has a record' );
1843: END IF;
1844: dbms_sql.column_value_rowid(c_on_acct,1,on_acct_row.row_id);
1845: dbms_sql.column_value(c_on_acct,2,on_acct_row.cash_receipt_id);
1846: dbms_sql.column_value(c_on_acct,3,on_acct_row.customer_trx_id);

Line 1912: arp_standard.debug( 'Close On Acct Cursor' );

1908: purchase_order := NULL;
1909: transaction_category := NULL;
1910:
1911: IF PG_DEBUG in ('Y', 'C') THEN
1912: arp_standard.debug( 'Close On Acct Cursor' );
1913: END IF;
1914: dbms_sql.close_cursor(c_on_acct);
1915: return(TRUE);
1916:

Line 1931: arp_standard.debug( 'CM Apps cursor is OPEN' );

1927: -----------------------------------------------------
1928: ELSIF dbms_sql.is_open(c_cm_apps) THEN
1929:
1930: IF PG_DEBUG in ('Y', 'C') THEN
1931: arp_standard.debug( 'CM Apps cursor is OPEN' );
1932: END IF;
1933: IF dbms_sql.fetch_rows(c_cm_apps) > 0 THEN
1934:
1935: IF PG_DEBUG in ('Y', 'C') THEN

Line 1936: arp_standard.debug( 'And we have fetched a record from CM Apps' );

1932: END IF;
1933: IF dbms_sql.fetch_rows(c_cm_apps) > 0 THEN
1934:
1935: IF PG_DEBUG in ('Y', 'C') THEN
1936: arp_standard.debug( 'And we have fetched a record from CM Apps' );
1937: END IF;
1938: dbms_sql.column_value_rowid(c_cm_apps,1,cm_apps_row.row_id);
1939: dbms_sql.column_value(c_cm_apps,2,cm_apps_row.cash_receipt_id);
1940: dbms_sql.column_value(c_cm_apps,3,cm_apps_row.customer_trx_id);

Line 2197: arp_standard.debug( 'CM Apps has no more records so we will close it' );

2193:
2194: ELSE
2195:
2196: IF PG_DEBUG in ('Y', 'C') THEN
2197: arp_standard.debug( 'CM Apps has no more records so we will close it' );
2198: END IF;
2199: dbms_sql.close_cursor(c_cm_apps);
2200: return(FALSE);
2201:

Line 2207: arp_standard.debug( 'Nothing to do!' );

2203:
2204: ELSE
2205:
2206: IF PG_DEBUG in ('Y', 'C') THEN
2207: arp_standard.debug( 'Nothing to do!' );
2208: END IF;
2209: return(FALSE);
2210:
2211: END IF;

Line 2214: arp_standard.debug( 'on_fetch()-' );

2210:
2211: END IF;
2212:
2213: IF PG_DEBUG in ('Y', 'C') THEN
2214: arp_standard.debug( 'on_fetch()-' );
2215: END IF;
2216:
2217: EXCEPTION
2218: WHEN OTHERS THEN

Line 2220: arp_standard.debug('EXCEPTION: ar_add_fetch_select.on_fetch');

2216:
2217: EXCEPTION
2218: WHEN OTHERS THEN
2219: IF PG_DEBUG in ('Y', 'C') THEN
2220: arp_standard.debug('EXCEPTION: ar_add_fetch_select.on_fetch');
2221: END IF;
2222: RAISE;
2223:
2224: END on_fetch;