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.21.12010000.7 2008/11/28 06:22:52 aghoraka ship $*/
3: TYPE option_record IS RECORD(
4: option_name ar_lookups.lookup_code%type,
5: cursor_name INTEGER);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2191: format_amount7 varchar2(2);
2192: format_amount8 varchar2(2);
2193:
2194: BEGIN
2195: debug1('arp_process_lockbox.validate_llca_interface_data()+');
2196: fnd_file.put_line(fnd_file.log, 'arp_process_lockbox.validate_llca_interface_data()+');
2197: p_trans_req_id := to_number(p_trans_request_id);
2198:
2199: UPDATE ar_pmts_interface_line_details

Line 2196: fnd_file.put_line(fnd_file.log, 'arp_process_lockbox.validate_llca_interface_data()+');

2192: format_amount8 varchar2(2);
2193:
2194: BEGIN
2195: debug1('arp_process_lockbox.validate_llca_interface_data()+');
2196: fnd_file.put_line(fnd_file.log, 'arp_process_lockbox.validate_llca_interface_data()+');
2197: p_trans_req_id := to_number(p_trans_request_id);
2198:
2199: UPDATE ar_pmts_interface_line_details
2200: SET status = 'AR_PLB_NEW_RECORD'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3284: fnd_file.put_line(fnd_file.log, 'arp_process_lockbox.validate_llca_interface_data()-');

3280: OR interface1.invoice7_status = 'AR_PLB_INVALID_LINE_DET'
3281: OR interface1.invoice8_status = 'AR_PLB_INVALID_LINE_DET'))
3282: AND transmission_request_id = p_trans_req_id;
3283: END IF;
3284: fnd_file.put_line(fnd_file.log, 'arp_process_lockbox.validate_llca_interface_data()-');
3285: EXCEPTION
3286: WHEN OTHERS THEN
3287: p_return_status := 'E';
3288: debug1('Error '|| SQLERRM);

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

3746: --
3747: --
3748: BEGIN
3749: g_total_maching_options := 0;
3750: debug1('Common code for arp_process_lockbox +');
3751: Open all_matching_options;
3752: debug1('Opened all_matching_options cursor');
3753: LOOP
3754: FETCH all_matching_options

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

4157: opened_cursor_table(g_total_maching_options).cursor_name := g_cursor_name;
4158: END LOOP;
4159: --
4160: --
4161: debug1('Common code for arp_process_lockbox -');
4162: END; -- Common First-Time-Only code.
4163: --
4164: -- END arp_process_lockbox;

Line 4164: -- END arp_process_lockbox;

4160: --
4161: debug1('Common code for arp_process_lockbox -');
4162: END; -- Common First-Time-Only code.
4163: --
4164: -- END arp_process_lockbox;