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_PROCESS_LOCKBOX dependencies on ARP_PROCESS_LOCKBOX

Line 1: PACKAGE BODY ARP_PROCESS_LOCKBOX AS

1: PACKAGE BODY ARP_PROCESS_LOCKBOX AS
2: /*$Header: ARRPRLBB.pls 120.36.12020000.3 2012/11/21 07:15:15 ashlkuma ship $*/
3: TYPE option_record IS RECORD(
4: option_name ar_lookups.lookup_code%type,
5: cursor_name INTEGER);

Line 162: debug1('arp_process_lockbox.auto_associate()+');

158: l_no_batch_or_lb = 'Y'
159: );
160: --
161: BEGIN
162: debug1('arp_process_lockbox.auto_associate()+');
163: --
164: -- Assign variables to local values.
165: --
166: l_transmission_id := p_transmission_id;

Line 454: debug1('arp_process_lockbox.auto_associate(1)-');

450: -- identified to a single customer.
451: --
452: p_out_customer_id := l_customer_id;
453: p_out_customer_identified := 1;
454: debug1('arp_process_lockbox.auto_associate(1)-');
455: RETURN;
456: --
457: <>
458: -- If there was no match found, then also we must populate the

Line 514: debug1('arp_process_lockbox.auto_associate(2)-');

510: --
511: -- Following values will be used by arlvaa()
512: p_out_customer_identified := 0;
513: p_out_customer_id := NULL;
514: debug1('arp_process_lockbox.auto_associate(2)-');
515: RETURN;
516: /* Bug 2106408. Added the following UPDATE */
517: <>
518: /* Bug2980051. Replaced l_only_one_lb with l_no_batch_or_lb */

Line 569: debug1('arp_process_lockbox.auto_associate : Duplicate Matching');

565: l_no_batch_or_lb = 'Y'
566: );
567: p_out_customer_identified := 0;
568: p_out_customer_id := NULL;
569: debug1('arp_process_lockbox.auto_associate : Duplicate Matching');
570: RETURN;
571: --
572: EXCEPTION
573: -- WHEN no_data_found

Line 577: debug1('arp_process_lockbox.auto_associate(3)-');

573: -- WHEN no_data_found
574: -- THEN null;
575: WHEN others
576: THEN RAISE;
577: debug1('arp_process_lockbox.auto_associate(3)-');
578: RETURN;
579: END auto_associate;
580: --
581: --

Line 702: debug1('arp_process_lockbox.populate_resolved_columns()+');

698: l_no_batch_or_lb = 'Y'
699: );
700: --
701: BEGIN
702: debug1('arp_process_lockbox.populate_resolved_columns()+');
703: --
704: -- Assign variables to local values.
705: --
706: l_transmission_id := p_transmission_id;

Line 929: debug1('arp_process_lockbox.populate_resolved_columns(1)-');

925: --
926: -- If the program reached here, means all records were successfully
927: -- identified to a single customer.
928: --
929: debug1('arp_process_lockbox.populate_resolved_columns(1)-');
930: RETURN;
931: --
932: --
933: EXCEPTION

Line 938: debug1('arp_process_lockbox.populate_resolved_columns(2)-');

934: -- WHEN no_data_found
935: -- THEN null;
936: WHEN others
937: THEN RAISE;
938: debug1('arp_process_lockbox.populate_resolved_columns(2)-');
939: RETURN;
940: END populate_resolved_columns;
941: --
942: --

Line 1125: debug1('arp_process_lockbox.find_cust_and_trx_num()+');

1121: 'CONSOLIDATE_BILL', 4,
1122: 100);
1123: --
1124: BEGIN
1125: debug1('arp_process_lockbox.find_cust_and_trx_num()+');
1126: --
1127: -- Note that the installment numbers are passed till
1128: -- this point, but are not used, as the current functionality
1129: -- matches are on invoice (where we need to return installment

Line 1171: debug1('arp_process_lockbox.find_cust_and_trx_num(1)-');

1167: -- Note: Let the p_matching_option as it is, as there was no item.
1168: -- Also the p_customer_id is returned unchanged.
1169: debug1('No items were found.. returning NO_ITEM');
1170: p_matched_flag := 'NO_ITEM';
1171: debug1('arp_process_lockbox.find_cust_and_trx_num(1)-');
1172: RETURN;
1173: END IF;
1174: --
1175: OPEN matching_options;

Line 1186: arp_process_lockbox.get_cursor_name(p_matching_option=>l_matching_option,

1182: debug1('Fetched cursor matching_options found l_matching_option = ' || l_matching_option );
1183: --
1184: EXIT matching_options_loop WHEN matching_options%NOTFOUND;
1185: --
1186: arp_process_lockbox.get_cursor_name(p_matching_option=>l_matching_option,
1187: p_cursor_name=>l_cursor_name,
1188: p_match_successful=>l_cursor_found);
1189: IF l_cursor_found = FALSE THEN
1190: -- This condition will never arise...

Line 1193: debug1('arp_process_lockbox.find_cust_and_trx_num(6)-');

1189: IF l_cursor_found = FALSE THEN
1190: -- This condition will never arise...
1191: p_matched_flag := 'PROGRAM_ERROR';
1192: debug1('PROGRAM_ERROR');
1193: debug1('arp_process_lockbox.find_cust_and_trx_num(6)-');
1194: END IF;
1195: --
1196: debug1('Got cursor ' || to_char(l_cursor_name) ||
1197: ' for matching option ' || l_matching_option);

Line 1645: debug1('arp_process_lockbox.find_cust_and_trx_num(2)-');

1641: -- Return p_matching8_installment as it is.
1642: END IF;
1643: p_matching_option := l_matching_option;
1644: p_matched_flag := 'TRUE';
1645: debug1('arp_process_lockbox.find_cust_and_trx_num(2)-');
1646: RETURN;
1647:
1648: ELSE
1649: -- None of the eight matching_numbers matched to

Line 1681: debug1('arp_process_lockbox.find_cust_and_trx_num : Duplicate Invoice');

1677: ) THEN
1678: p_matched_flag := 'FALSE';
1679: /* Bug 2106408. The p_customer_id should be passed as -7777 whenever
1680: there is a duplicate invoice number. */
1681: debug1('arp_process_lockbox.find_cust_and_trx_num : Duplicate Invoice');
1682: p_customer_id := -7777;
1683: debug1('arp_process_lockbox.find_cust_and_trx_num(8)-');
1684: RETURN;
1685: END IF;

Line 1683: debug1('arp_process_lockbox.find_cust_and_trx_num(8)-');

1679: /* Bug 2106408. The p_customer_id should be passed as -7777 whenever
1680: there is a duplicate invoice number. */
1681: debug1('arp_process_lockbox.find_cust_and_trx_num : Duplicate Invoice');
1682: p_customer_id := -7777;
1683: debug1('arp_process_lockbox.find_cust_and_trx_num(8)-');
1684: RETURN;
1685: END IF;
1686:
1687: /* Bug2651127: if any customer_id is -6666 that means that we have an invalid

Line 1700: debug1('arp_process_lockbox.find_cust_and_trx_num : Invalid Invoice');

1696: (l_current_customer_id7 = -6666) or
1697: (l_current_customer_id8 = -6666)
1698: ) THEN
1699: p_matched_flag := 'FALSE';
1700: debug1('arp_process_lockbox.find_cust_and_trx_num : Invalid Invoice');
1701: debug1('arp_process_lockbox.find_cust_and_trx_num(8.1)-');
1702: /*RETURN;*/ /*5052049*/
1703: END IF;
1704: --

Line 1701: debug1('arp_process_lockbox.find_cust_and_trx_num(8.1)-');

1697: (l_current_customer_id8 = -6666)
1698: ) THEN
1699: p_matched_flag := 'FALSE';
1700: debug1('arp_process_lockbox.find_cust_and_trx_num : Invalid Invoice');
1701: debug1('arp_process_lockbox.find_cust_and_trx_num(8.1)-');
1702: /*RETURN;*/ /*5052049*/
1703: END IF;
1704: --
1705: /*5052049*/

Line 1902: debug1('arp_process_lockbox.find_cust_and_trx_num(3)-');

1898: END IF;
1899: p_matching_option := l_matching_option;
1900: p_customer_id := first_customer;
1901: p_matched_flag := 'TRUE';
1902: debug1('arp_process_lockbox.find_cust_and_trx_num(3)-');
1903: RETURN;
1904: ELSE /* Could not identify the customer uniquely */
1905: /* Let the p_customer_id be whatever was the input value,
1906: It will be null, if it is called form Auto_Associate or it

Line 1909: debug1('arp_process_lockbox.find_cust_and_trx_num(4)-');

1905: /* Let the p_customer_id be whatever was the input value,
1906: It will be null, if it is called form Auto_Associate or it
1907: will hold some valid value, if called from populate_resolved_coulmns */
1908: p_matched_flag := 'FALSE';
1909: debug1('arp_process_lockbox.find_cust_and_trx_num(4)-');
1910: RETURN;
1911: END IF;
1912: END IF; -- End if for first_customer <> -9999.
1913: /* Note : Do nothing and countinue with the next option in

Line 1974: debug1('arp_process_lockbox.find_cust_and_trx_num(5)-');

1970: ELSE
1971: p_match8_status := NULL;
1972: END IF;
1973: p_matched_flag := 'NO_MATCH';
1974: debug1('arp_process_lockbox.find_cust_and_trx_num(5)-');
1975: RETURN;
1976: --
1977: EXCEPTION
1978: WHEN others

Line 1980: debug1('arp_process_lockbox.find_cust_and_trx_num(7)-');

1976: --
1977: EXCEPTION
1978: WHEN others
1979: THEN
1980: debug1('arp_process_lockbox.find_cust_and_trx_num(7)-');
1981: RAISE;
1982: END find_cust_and_trx_num;
1983: --
1984: /*----------------------------------------------------------------------------

Line 2033: debug1('arp_process_lockbox.get_cursor_name()+');

2029: p_match_successful OUT NOCOPY BOOLEAN) IS
2030: --
2031: --
2032: BEGIN
2033: debug1('arp_process_lockbox.get_cursor_name()+');
2034: FOR i in 1 .. g_total_maching_options
2035: LOOP
2036: IF (opened_cursor_table(i).option_name = p_matching_option) THEN
2037: p_cursor_name := opened_cursor_table(i).cursor_name;

Line 2039: debug1('arp_process_lockbox.get_cursor_name(1)-');

2035: LOOP
2036: IF (opened_cursor_table(i).option_name = p_matching_option) THEN
2037: p_cursor_name := opened_cursor_table(i).cursor_name;
2038: p_match_successful := TRUE;
2039: debug1('arp_process_lockbox.get_cursor_name(1)-');
2040: RETURN;
2041: END IF;
2042: END LOOP; -- End loop for 1 to g_total_maching_options matching numbers.
2043: --

Line 2049: debug1('arp_process_lockbox.get_cursor_name(2)-');

2045: -- cursor was not defined. .. will return error in this case.
2046: --
2047: p_cursor_name := NULL;
2048: p_match_successful := FALSE;
2049: debug1('arp_process_lockbox.get_cursor_name(2)-');
2050: RETURN;
2051: --
2052: END get_cursor_name;
2053: --

Line 2070: debug1('arp_process_lockbox.get_cursor_name()+');

2066: ----------------------------------------------------------------------------*/
2067: PROCEDURE
2068: close_cursors IS
2069: Begin
2070: debug1('arp_process_lockbox.get_cursor_name()+');
2071: --
2072: FOR i in 1 .. g_total_maching_options
2073: LOOP
2074: IF (dbms_sql.is_open(opened_cursor_table(i).cursor_name)) THEN

Line 2080: debug1('arp_process_lockbox.get_cursor_name()-');

2076: dbms_sql.close_cursor(opened_cursor_table(i).cursor_name);
2077: END IF;
2078: END LOOP; -- End loop for 1 to g_total_maching_options matching numbers.
2079: --
2080: debug1('arp_process_lockbox.get_cursor_name()-');
2081: End close_cursors;
2082:
2083: --
2084: /*===========================================================================+

Line 2198: debug1('arp_process_lockbox.validate_llca_interface_data()+');

2194: format_amount7 varchar2(2);
2195: format_amount8 varchar2(2);
2196:
2197: BEGIN
2198: debug1('arp_process_lockbox.validate_llca_interface_data()+');
2199: p_trans_req_id := to_number(p_trans_request_id);
2200:
2201: UPDATE ar_pmts_interface_line_details
2202: SET status = 'AR_PLB_NEW_RECORD'

Line 2240: format_amount1 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

2236: FROM ar_payments_interface
2237: WHERE transmission_request_id = p_trans_req_id
2238: AND rownum = 1;
2239:
2240: format_amount1 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2241: l_trans_record_id,'AMT APP 1');
2242: format_amount2 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2243: l_trans_record_id,'AMT APP 2');
2244: format_amount3 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

Line 2242: format_amount2 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

2238: AND rownum = 1;
2239:
2240: format_amount1 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2241: l_trans_record_id,'AMT APP 1');
2242: format_amount2 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2243: l_trans_record_id,'AMT APP 2');
2244: format_amount3 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2245: l_trans_record_id,'AMT APP 3');
2246: format_amount4 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

Line 2244: format_amount3 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

2240: format_amount1 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2241: l_trans_record_id,'AMT APP 1');
2242: format_amount2 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2243: l_trans_record_id,'AMT APP 2');
2244: format_amount3 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2245: l_trans_record_id,'AMT APP 3');
2246: format_amount4 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2247: l_trans_record_id,'AMT APP 4');
2248: format_amount5 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

Line 2246: format_amount4 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

2242: format_amount2 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2243: l_trans_record_id,'AMT APP 2');
2244: format_amount3 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2245: l_trans_record_id,'AMT APP 3');
2246: format_amount4 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2247: l_trans_record_id,'AMT APP 4');
2248: format_amount5 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2249: l_trans_record_id,'AMT APP 5');
2250: format_amount6 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

Line 2248: format_amount5 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

2244: format_amount3 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2245: l_trans_record_id,'AMT APP 3');
2246: format_amount4 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2247: l_trans_record_id,'AMT APP 4');
2248: format_amount5 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2249: l_trans_record_id,'AMT APP 5');
2250: format_amount6 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2251: l_trans_record_id,'AMT APP 6');
2252: format_amount7 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

Line 2250: format_amount6 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

2246: format_amount4 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2247: l_trans_record_id,'AMT APP 4');
2248: format_amount5 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2249: l_trans_record_id,'AMT APP 5');
2250: format_amount6 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2251: l_trans_record_id,'AMT APP 6');
2252: format_amount7 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2253: l_trans_record_id,'AMT APP 7');
2254: format_amount8 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

Line 2252: format_amount7 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

2248: format_amount5 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2249: l_trans_record_id,'AMT APP 5');
2250: format_amount6 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2251: l_trans_record_id,'AMT APP 6');
2252: format_amount7 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2253: l_trans_record_id,'AMT APP 7');
2254: format_amount8 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2255: l_trans_record_id,'AMT APP 8');
2256: format_amount_app1 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

Line 2254: format_amount8 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

2250: format_amount6 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2251: l_trans_record_id,'AMT APP 6');
2252: format_amount7 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2253: l_trans_record_id,'AMT APP 7');
2254: format_amount8 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2255: l_trans_record_id,'AMT APP 8');
2256: format_amount_app1 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2257: l_trans_record_id,'AMT APP FROM 1');
2258: format_amount_app2 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

Line 2256: format_amount_app1 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

2252: format_amount7 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2253: l_trans_record_id,'AMT APP 7');
2254: format_amount8 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2255: l_trans_record_id,'AMT APP 8');
2256: format_amount_app1 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2257: l_trans_record_id,'AMT APP FROM 1');
2258: format_amount_app2 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2259: l_trans_record_id,'AMT APP FROM 2');
2260: format_amount_app3 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

Line 2258: format_amount_app2 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

2254: format_amount8 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2255: l_trans_record_id,'AMT APP 8');
2256: format_amount_app1 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2257: l_trans_record_id,'AMT APP FROM 1');
2258: format_amount_app2 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2259: l_trans_record_id,'AMT APP FROM 2');
2260: format_amount_app3 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2261: l_trans_record_id,'AMT APP FROM 3');
2262: format_amount_app4 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

Line 2260: format_amount_app3 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

2256: format_amount_app1 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2257: l_trans_record_id,'AMT APP FROM 1');
2258: format_amount_app2 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2259: l_trans_record_id,'AMT APP FROM 2');
2260: format_amount_app3 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2261: l_trans_record_id,'AMT APP FROM 3');
2262: format_amount_app4 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2263: l_trans_record_id,'AMT APP FROM 4');
2264: format_amount_app5 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

Line 2262: format_amount_app4 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

2258: format_amount_app2 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2259: l_trans_record_id,'AMT APP FROM 2');
2260: format_amount_app3 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2261: l_trans_record_id,'AMT APP FROM 3');
2262: format_amount_app4 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2263: l_trans_record_id,'AMT APP FROM 4');
2264: format_amount_app5 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2265: l_trans_record_id,'AMT APP FROM 5');
2266: format_amount_app6 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

Line 2264: format_amount_app5 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

2260: format_amount_app3 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2261: l_trans_record_id,'AMT APP FROM 3');
2262: format_amount_app4 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2263: l_trans_record_id,'AMT APP FROM 4');
2264: format_amount_app5 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2265: l_trans_record_id,'AMT APP FROM 5');
2266: format_amount_app6 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2267: l_trans_record_id,'AMT APP FROM 6');
2268: format_amount_app7 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

Line 2266: format_amount_app6 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

2262: format_amount_app4 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2263: l_trans_record_id,'AMT APP FROM 4');
2264: format_amount_app5 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2265: l_trans_record_id,'AMT APP FROM 5');
2266: format_amount_app6 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2267: l_trans_record_id,'AMT APP FROM 6');
2268: format_amount_app7 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2269: l_trans_record_id,'AMT APP FROM 7');
2270: format_amount_app8 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

Line 2268: format_amount_app7 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

2264: format_amount_app5 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2265: l_trans_record_id,'AMT APP FROM 5');
2266: format_amount_app6 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2267: l_trans_record_id,'AMT APP FROM 6');
2268: format_amount_app7 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2269: l_trans_record_id,'AMT APP FROM 7');
2270: format_amount_app8 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2271: l_trans_record_id,'AMT APP FROM 8');
2272:

Line 2270: format_amount_app8 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,

2266: format_amount_app6 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2267: l_trans_record_id,'AMT APP FROM 6');
2268: format_amount_app7 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2269: l_trans_record_id,'AMT APP FROM 7');
2270: format_amount_app8 := ARP_PROCESS_LOCKBOX.get_format_amount(p_trans_req_id,
2271: l_trans_record_id,'AMT APP FROM 8');
2272:
2273: INSERT INTO ar_pmts_interface_header_gt
2274: (transmission_request_id,

Line 3294: debug1('arp_process_lockbox.validate_llca_interface_data()-');

3290: OR interface1.invoice7_status = 'AR_PLB_INVALID_LINE_DET'
3291: OR interface1.invoice8_status = 'AR_PLB_INVALID_LINE_DET'))
3292: AND transmission_request_id = p_trans_req_id;
3293: END IF;
3294: debug1('arp_process_lockbox.validate_llca_interface_data()-');
3295: EXCEPTION
3296: WHEN OTHERS THEN
3297: p_return_status := 'E';
3298: debug1('Error '|| SQLERRM);

Line 3770: debug1('Common code for arp_process_lockbox +');

3766: --
3767: BEGIN
3768: g_include_closed_inv := NVL(FND_PROFILE.value('AR_INC_CLINV_AUTO_ASSO'), 'Y');
3769: g_total_maching_options := 0;
3770: debug1('Common code for arp_process_lockbox +');
3771: Open all_matching_options;
3772: debug1('Opened all_matching_options cursor');
3773: LOOP
3774: FETCH all_matching_options

Line 4262: debug1('Common code for arp_process_lockbox -');

4258: opened_cursor_table(g_total_maching_options).cursor_name := g_cursor_name;
4259: END LOOP;
4260: --
4261: --
4262: debug1('Common code for arp_process_lockbox -');
4263: END; -- Common First-Time-Only code.
4264: --
4265: -- END arp_process_lockbox;

Line 4265: -- END arp_process_lockbox;

4261: --
4262: debug1('Common code for arp_process_lockbox -');
4263: END; -- Common First-Time-Only code.
4264: --
4265: -- END arp_process_lockbox;