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.JAI_AR_MATCH_TAX_PKG dependencies on FND_FILE

Line 83: 2 09-MAY-2002 Sriram. Adding fnd_file.put_line -

79: 1 04-MAY-2002 Sriram. Procedure Created . This Procedure will be
80: invoked by the concurrent
81: 'India Local Concurrent Procedure for processing Order Lines to AR' - JAINMREQ .
82: This will be only applicable for Invoiced Created from Order Entry.
83: 2 09-MAY-2002 Sriram. Adding fnd_file.put_line -
84: to write logs from concurrent program.
85: 3 24-May-2002 Sriram. Set the Code so that it works in the batch mode .
86: 4. 09-JAN-2003 Sriram - Bug # 2740546 - File Version is 615.1
87: Added the substr function to the update statement that updates the

Line 246: fnd_file.put_line(FND_FILE.LOG,' Entering Procedure - jai_ar_match_tax_pkg.process_batch');

242: v_org_id := FND_PROFILE.VALUE('ORG_ID');
243: */
244: lv_debug := nvl(p_debug,'N');
245: lv_debug := 'Y';
246: fnd_file.put_line(FND_FILE.LOG,' Entering Procedure - jai_ar_match_tax_pkg.process_batch');
247:
248: ln_org_id := mo_global.get_current_org_id() ; -- Harshita for Bug 5490479
249: /*commented by kunkumar for bug# 6066813 Start
250: 6012570 (5876390) -- Revoked the comments for 6012570*/

Line 263: fnd_file.put_line(FND_FILE.LOG,' Org id retreived is - ' || v_org_id || ' Generate for All orgs is : ' || p_all_orgs);

259: else
260: v_org_id := ln_org_id; -- p_org_id -- Harshita for Bug 5490479
261: end if;
262:
263: fnd_file.put_line(FND_FILE.LOG,' Org id retreived is - ' || v_org_id || ' Generate for All orgs is : ' || p_all_orgs);
264:
265: lv_source := 'RAXTRX';
266: FOR temp_rec IN
267: (

Line 401: fnd_file.put_line(FND_FILE.LOG , 'Error - ' || ' When Processing '||

397:
398:
399: COMMIT;
400:
401: fnd_file.put_line(FND_FILE.LOG , 'Error - ' || ' When Processing '||
402: temp_rec.customer_trx_id );
403: fnd_file.put_line(FND_FILE.LOG , 'Error is ' || var_error_mesg );
404:
405: var_error_invoice := 'Y';

Line 403: fnd_file.put_line(FND_FILE.LOG , 'Error is ' || var_error_mesg );

399: COMMIT;
400:
401: fnd_file.put_line(FND_FILE.LOG , 'Error - ' || ' When Processing '||
402: temp_rec.customer_trx_id );
403: fnd_file.put_line(FND_FILE.LOG , 'Error is ' || var_error_mesg );
404:
405: var_error_invoice := 'Y';
406:
407: END;

Line 417: fnd_file.put_line(FND_FILE.LOG, 'Processed Customer_trx_id - ' ||var_cust_trx_id);

413:
414: -- write here to log the successful processing for last invoice
415:
416: IF var_error_invoice <> 'Y' THEN
417: fnd_file.put_line(FND_FILE.LOG, 'Processed Customer_trx_id - ' ||var_cust_trx_id);
418: END IF;
419:
420: COMMIT;
421: fnd_file.put_line(FND_FILE.LOG,'Successfully Exiting PROCEDURE - jai_ar_match_tax_pkg.process_batch');

Line 421: fnd_file.put_line(FND_FILE.LOG,'Successfully Exiting PROCEDURE - jai_ar_match_tax_pkg.process_batch');

417: fnd_file.put_line(FND_FILE.LOG, 'Processed Customer_trx_id - ' ||var_cust_trx_id);
418: END IF;
419:
420: COMMIT;
421: fnd_file.put_line(FND_FILE.LOG,'Successfully Exiting PROCEDURE - jai_ar_match_tax_pkg.process_batch');
422: EXCEPTION
423: WHEN OTHERS THEN
424: ROLLBACK;
425:

Line 438: Fnd_file.put_line(FND_FILE.LOG,'EXCEPTION Occured - ' || ERRBUF || ' WHILE Processing Customer_trx_id - ' || var_cust_trx_id );

434: var_freight_amount :=0;
435:
436: ERRBUF := SQLERRM;
437: RETCODE := 2;
438: Fnd_file.put_line(FND_FILE.LOG,'EXCEPTION Occured - ' || ERRBUF || ' WHILE Processing Customer_trx_id - ' || var_cust_trx_id );
439: END process_batch;
440:
441: ------------------------------------------------ ---------------------------------------
442: --=========================================================================================--

Line 1502: fnd_file.put_line(FND_FILE.LOG, 'START process_imported_invoice');

1498: v_upd_created_from VARCHAR2(15);
1499: ln_event_id NUMBER; --added for bug#7645588
1500: BEGIN
1501:
1502: fnd_file.put_line(FND_FILE.LOG, 'START process_imported_invoice');
1503:
1504: --Lock all the rows from JAI_AR_TRX_INS_LINES_T for a customer_trx_id, which are to be processed
1505: FOR i IN cur_lock_temp(p_customer_trx_id)
1506: LOOP

Line 1523: fnd_file.put_line(FND_FILE.LOG, 'Before pre_validation');

1519: --If ln_previous_customer_trx_id is not null, then current transaction is a CM
1520: ln_previous_customer_trx_id := rec_customer_trx.previous_customer_trx_id;
1521:
1522: IF p_debug = 'Y' THEN
1523: fnd_file.put_line(FND_FILE.LOG, 'Before pre_validation');
1524: END IF;
1525:
1526: --do the basic validations before processing the transaction
1527: jai_ar_validate_data_pkg.pre_validation

Line 1533: fnd_file.put_line(FND_FILE.LOG, 'Before pre_validation');

1529: p_process_status => lv_process_status,
1530: p_process_message => lv_process_message);
1531:
1532: IF p_debug = 'Y' THEN
1533: fnd_file.put_line(FND_FILE.LOG, 'Before pre_validation');
1534: END IF;
1535:
1536: IF lv_process_status <> jai_constants.successful THEN
1537: p_process_status := lv_process_status;

Line 1567: fnd_file.put_line(FND_FILE.LOG, 'Before delete_trx_data');

1563: FETCH cur_curr_precision INTO ln_precision;
1564: CLOSE cur_curr_precision;
1565:
1566: IF p_debug = 'Y' THEN
1567: fnd_file.put_line(FND_FILE.LOG, 'Before delete_trx_data');
1568: END IF;
1569:
1570: --This procedure deletes the data from ra_cust_trx_line_gl_dist_all, ra_customer_trx_lines_all
1571: --Also deletes the MRC data from ra_cust_trx_line_gl_dist

Line 1577: fnd_file.put_line(FND_FILE.LOG, 'After delete_trx_data');

1573: p_process_status => lv_process_status,
1574: p_process_message => lv_process_message);
1575:
1576: IF p_debug = 'Y' THEN
1577: fnd_file.put_line(FND_FILE.LOG, 'After delete_trx_data');
1578: END IF;
1579:
1580: IF lv_process_status <> jai_constants.successful THEN
1581: p_process_status := lv_process_status;

Line 1613: fnd_file.put_line(FND_FILE.LOG, 'Before cur_temp_lines_insert LOOP');

1609: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, end */
1610:
1611:
1612: IF p_debug = 'Y' THEN
1613: fnd_file.put_line(FND_FILE.LOG, 'Before cur_temp_lines_insert LOOP');
1614: END IF;
1615:
1616: FOR rec_temp IN cur_temp_lines_insert(p_customer_trx_id)
1617: LOOP

Line 1662: fnd_file.put_line(FND_FILE.LOG, 'In loop cur_temp_lines_insert - before insert_trx_lines');

1658: ln_taxable_amount := rec_customer_trx_lines.extended_amount;
1659: END IF;
1660:
1661: IF p_debug = 'Y' THEN
1662: fnd_file.put_line(FND_FILE.LOG, 'In loop cur_temp_lines_insert - before insert_trx_lines');
1663: END IF;
1664:
1665:
1666: -- #### IMPORTANT FOR R12

Line 1701: fnd_file.put_line(FND_FILE.LOG, 'In loop cur_temp_lines_insert - after insert_trx_lines');

1697: p_process_status => lv_process_status,
1698: p_process_message => lv_process_message);
1699:
1700: IF p_debug = 'Y' THEN
1701: fnd_file.put_line(FND_FILE.LOG, 'In loop cur_temp_lines_insert - after insert_trx_lines');
1702: END IF;
1703:
1704: IF lv_process_status <> jai_constants.successful THEN
1705: p_process_status := lv_process_status;

Line 1711: fnd_file.put_line(FND_FILE.LOG, 'In loop cur_temp_lines_insert - before insert_trx_line_gl_dist');

1707: goto EXIT_POINT;
1708: END IF;
1709:
1710: IF p_debug = 'Y' THEN
1711: fnd_file.put_line(FND_FILE.LOG, 'In loop cur_temp_lines_insert - before insert_trx_line_gl_dist');
1712: END IF;
1713:
1714:
1715: --This procedure inserts the data into ra_cust_trx_line_gl_dist_all

Line 1741: fnd_file.put_line(FND_FILE.LOG, 'In loop cur_temp_lines_insert - after insert_trx_line_gl_dist');

1737: p_seq_id => ln_gl_seq,
1738: p_event_id => ln_event_id); --added for bug#7645588
1739:
1740: IF p_debug = 'Y' THEN
1741: fnd_file.put_line(FND_FILE.LOG, 'In loop cur_temp_lines_insert - after insert_trx_line_gl_dist');
1742: END IF;
1743:
1744: --added the following IF condition for bug#7645588
1745: IF ln_accounting_rule_id is not null and ln_previous_customer_trx_id IS NOT NULL then

Line 1840: fnd_file.put_line(FND_FILE.LOG, 'Before ln_previous_customer_trx_id is not null'||ln_previous_customer_trx_id);

1836: ln_taxable_amount; --this variable is not being used
1837: CLOSE cur_total_amt_trx_lines;
1838:
1839: IF p_debug = 'Y' THEN
1840: fnd_file.put_line(FND_FILE.LOG, 'Before ln_previous_customer_trx_id is not null'||ln_previous_customer_trx_id);
1841: END IF;
1842:
1843: IF ln_previous_customer_trx_id IS NOT NULL THEN --CM
1844:

Line 1867: fnd_file.put_line(FND_FILE.LOG, 'After INSERT call to maintain_schedules');

1863: goto EXIT_POINT;
1864: END IF;
1865:
1866: IF p_debug = 'Y' THEN
1867: fnd_file.put_line(FND_FILE.LOG, 'After INSERT call to maintain_schedules');
1868: END IF;
1869:
1870: UPDATE ar_payment_schedules_all
1871: SET amount_due_original = ROUND(NVL(amount_line_items_original,0) + ln_total_tax_amt_for_inv + ln_total_frt_amt_for_inv, ln_precision),

Line 1897: fnd_file.put_line(FND_FILE.LOG, 'After UPDATE call to maintain_schedules');

1893: goto EXIT_POINT;
1894: END IF;
1895:
1896: IF p_debug = 'Y' THEN
1897: fnd_file.put_line(FND_FILE.LOG, 'After UPDATE call to maintain_schedules');
1898: END IF;
1899:
1900:
1901: --get the min(payment_schedule_id) and term_id from ar_payment_schedules_all for customer_trx_id

Line 1930: fnd_file.put_line(FND_FILE.LOG, 'Before entering rec_payment LOOP');

1926: ln_frt_amt_cashrcpt;
1927: CLOSE cur_tot_cash_rcpt;
1928:
1929: IF p_debug = 'Y' THEN
1930: fnd_file.put_line(FND_FILE.LOG, 'Before entering rec_payment LOOP');
1931: END IF;
1932:
1933: --get the data from ar_payment_schedules_all for customer_trx_id and payment_schedule_id
1934: FOR rec_payment in cur_payment_schedule(ln_previous_customer_trx_id)

Line 1937: fnd_file.put_line(FND_FILE.LOG, 'In rec_payment LOOP');

1933: --get the data from ar_payment_schedules_all for customer_trx_id and payment_schedule_id
1934: FOR rec_payment in cur_payment_schedule(ln_previous_customer_trx_id)
1935: LOOP
1936: IF p_debug = 'Y' THEN
1937: fnd_file.put_line(FND_FILE.LOG, 'In rec_payment LOOP');
1938: END IF;
1939:
1940:
1941: --Get the relative_amount from ra_terms_lines

Line 1948: fnd_file.put_line(FND_FILE.LOG, 'after cursor cur_term_lines');

1944: FETCH cur_term_lines INTO ln_relative_amt;
1945: CLOSE cur_term_lines;
1946:
1947: IF p_debug = 'Y' THEN
1948: fnd_file.put_line(FND_FILE.LOG, 'after cursor cur_term_lines');
1949: END IF;
1950:
1951: IF rec_term_details.first_installment_code = 'ALLOCATE' THEN
1952: ln_apportion_factor := ln_relative_amt/rec_term_details.base_amount;

Line 1965: fnd_file.put_line(FND_FILE.LOG, 'after cursor cur_tot_recv_appl');

1961: FETCH cur_tot_recv_appl INTO ln_line_applied;
1962: CLOSE cur_tot_recv_appl;
1963:
1964: IF p_debug = 'Y' THEN
1965: fnd_file.put_line(FND_FILE.LOG, 'after cursor cur_tot_recv_appl');
1966: END IF;
1967:
1968: ln_inst_tax_amt_for_inv := ln_tax_amt_cms * ln_apportion_factor;
1969: ln_inst_frt_amt_for_inv := ln_frt_amt_cms * ln_apportion_factor;

Line 1978: fnd_file.put_line(FND_FILE.LOG, 'after cursor cur_trx_types');

1974: FETCH cur_trx_types INTO lv_allow_overappln_flag ;
1975: CLOSE cur_trx_types ;
1976:
1977: IF p_debug = 'Y' THEN
1978: fnd_file.put_line(FND_FILE.LOG, 'after cursor cur_trx_types');
1979: END IF;
1980:
1981:
1982: --Get the data from ar_payment_schedules_all for customer_trx_id

Line 1989: fnd_file.put_line(FND_FILE.LOG, 'after cursor cur_payment_schedule');

1985: FETCH cur_prev_payment_schedule INTO rec_prev_payment_schedule;
1986: CLOSE cur_prev_payment_schedule;
1987:
1988: IF p_debug = 'Y' THEN
1989: fnd_file.put_line(FND_FILE.LOG, 'after cursor cur_payment_schedule');
1990: END IF;
1991:
1992: ln_amt_due_rem := NVL(rec_prev_payment_schedule.amount_line_items_remaining,0)
1993: + NVL(rec_prev_payment_schedule.tax_original,0)

Line 2001: fnd_file.put_line(FND_FILE.LOG, 'ln_amt_due_rem '||ln_amt_due_rem);

1997: - ln_tax_amt_cashrcpt
1998: - ln_frt_amt_cashrcpt;
1999:
2000: IF p_debug = 'Y' THEN
2001: fnd_file.put_line(FND_FILE.LOG, 'ln_amt_due_rem '||ln_amt_due_rem);
2002: END IF;
2003:
2004: IF ( NVL(lv_allow_overappln_flag,'N') = 'Y' ) OR
2005: ( NVL(lv_allow_overappln_flag,'N') = 'N' AND ln_amt_due_rem >= 0 )

Line 2027: fnd_file.put_line(FND_FILE.LOG, 'after Call to maintain_schedules');

2023: goto EXIT_POINT;
2024: END IF;
2025:
2026: IF p_debug = 'Y' THEN
2027: fnd_file.put_line(FND_FILE.LOG, 'after Call to maintain_schedules');
2028: END IF;
2029:
2030: UPDATE ar_payment_schedules_all
2031: SET amount_due_remaining = ROUND (ln_amt_due_rem ,ln_precision) ,

Line 2042: fnd_file.put_line(FND_FILE.LOG, 'After first update fo ar_payment_schedules_all');

2038: AND payment_schedule_id = rec_payment.payment_schedule_id;
2039:
2040:
2041: IF p_debug = 'Y' THEN
2042: fnd_file.put_line(FND_FILE.LOG, 'After first update fo ar_payment_schedules_all');
2043: END IF;
2044:
2045: UPDATE ar_payment_schedules_all
2046: SET status = DECODE (amount_due_remaining, 0, 'CL', 'OP'),

Line 2054: fnd_file.put_line(FND_FILE.LOG, 'After second update fo ar_payment_schedules_all');

2050: WHERE customer_trx_id = ln_previous_customer_trx_id
2051: AND payment_schedule_id = rec_payment.payment_schedule_id;
2052:
2053: IF p_debug = 'Y' THEN
2054: fnd_file.put_line(FND_FILE.LOG, 'After second update fo ar_payment_schedules_all');
2055: END IF;
2056:
2057: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
2058: maintain_schedules( p_customer_trx_id => p_customer_trx_id,

Line 2076: fnd_file.put_line(FND_FILE.LOG, 'after Call to maintain_schedules');

2072: goto EXIT_POINT;
2073: END IF;
2074:
2075: IF p_debug = 'Y' THEN
2076: fnd_file.put_line(FND_FILE.LOG, 'after Call to maintain_schedules');
2077: END IF;
2078:
2079:
2080: --Get the receivable_application_id from ar_receivable_applications_all for the Invoice's payment_schedule_id

Line 2105: fnd_file.put_line(FND_FILE.LOG, 'after Call to maintain_applications');

2101: goto EXIT_POINT;
2102: END IF;
2103:
2104: IF p_debug = 'Y' THEN
2105: fnd_file.put_line(FND_FILE.LOG, 'after Call to maintain_applications');
2106: END IF;
2107:
2108:
2109: UPDATE ar_receivable_applications_all

Line 2134: fnd_file.put_line(FND_FILE.LOG, 'after update of ar_receivable_applications_all');

2130: || Modified by Ramananda for bug#5495711, Ends
2131: */
2132:
2133: IF p_debug = 'Y' THEN
2134: fnd_file.put_line(FND_FILE.LOG, 'after update of ar_receivable_applications_all');
2135: END IF;
2136:
2137: maintain_applications(p_customer_trx_id => p_customer_trx_id,
2138: p_receivable_application_id => ln_recv_appln_id,

Line 2153: fnd_file.put_line(FND_FILE.LOG, 'after Call to maintain_applications');

2149: goto EXIT_POINT;
2150: END IF;
2151:
2152: IF p_debug = 'Y' THEN
2153: fnd_file.put_line(FND_FILE.LOG, 'after Call to maintain_applications');
2154: END IF;
2155:
2156: IF rec_term_details.first_installment_code <> 'ALLOCATE' THEN
2157: EXIT;

Line 2175: fnd_file.put_line(FND_FILE.LOG, 'In else of previous_customer_trx_id');

2171:
2172: ln_payment_audit_id := NULL;
2173:
2174: IF p_debug = 'Y' THEN
2175: fnd_file.put_line(FND_FILE.LOG, 'In else of previous_customer_trx_id');
2176: END IF;
2177:
2178: --Get the first_installment_code and base_amount from ra_terms
2179: OPEN cur_term_details(rec_min_payment_schedule.term_id);

Line 2188: fnd_file.put_line(FND_FILE.LOG, 'In LOOP cur_payment_schedule - rec_payment.payment_schedule_id'||rec_payment.payment_schedule_id);

2184: FOR rec_payment in cur_payment_schedule(p_customer_trx_id)
2185: LOOP
2186:
2187: IF p_debug = 'Y' THEN
2188: fnd_file.put_line(FND_FILE.LOG, 'In LOOP cur_payment_schedule - rec_payment.payment_schedule_id'||rec_payment.payment_schedule_id);
2189: fnd_file.put_line(FND_FILE.LOG, 'In LOOP cur_payment_schedule - rec_term_details.first_installment_code'||rec_term_details.first_installment_code);
2190: END IF;
2191:
2192: --Get the relative_amount from ra_terms_lines

Line 2189: fnd_file.put_line(FND_FILE.LOG, 'In LOOP cur_payment_schedule - rec_term_details.first_installment_code'||rec_term_details.first_installment_code);

2185: LOOP
2186:
2187: IF p_debug = 'Y' THEN
2188: fnd_file.put_line(FND_FILE.LOG, 'In LOOP cur_payment_schedule - rec_payment.payment_schedule_id'||rec_payment.payment_schedule_id);
2189: fnd_file.put_line(FND_FILE.LOG, 'In LOOP cur_payment_schedule - rec_term_details.first_installment_code'||rec_term_details.first_installment_code);
2190: END IF;
2191:
2192: --Get the relative_amount from ra_terms_lines
2193: OPEN cur_term_lines(rec_payment.term_id,

Line 2228: fnd_file.put_line(FND_FILE.LOG, 'After call to maintain_schedules');

2224: goto EXIT_POINT;
2225: END IF;
2226:
2227: IF p_debug = 'Y' THEN
2228: fnd_file.put_line(FND_FILE.LOG, 'After call to maintain_schedules');
2229: END IF;
2230:
2231: UPDATE ar_payment_schedules_all
2232: SET amount_due_original = ROUND(NVL(amount_line_items_original,0) + NVL(ln_inst_tax_amt_for_inv,0) + NVL(ln_inst_frt_amt_for_inv,0) , ln_precision),

Line 2244: fnd_file.put_line(FND_FILE.LOG, 'After First update of ar_payment_schedules_all');

2240: WHERE customer_trx_id = p_customer_trx_id
2241: AND payment_schedule_id = rec_payment.payment_schedule_id;
2242:
2243: IF p_debug = 'Y' THEN
2244: fnd_file.put_line(FND_FILE.LOG, 'After First update of ar_payment_schedules_all');
2245: END IF;
2246:
2247: UPDATE ar_payment_schedules_all
2248: SET status = DECODE (amount_due_remaining, 0, 'CL', 'OP'),

Line 2256: fnd_file.put_line(FND_FILE.LOG, 'After Second update of ar_payment_schedules_all '||SQL%ROWCOUNT);

2252: WHERE customer_trx_id = p_customer_trx_id
2253: AND payment_schedule_id = rec_payment.payment_schedule_id;
2254:
2255: IF p_debug = 'Y' THEN
2256: fnd_file.put_line(FND_FILE.LOG, 'After Second update of ar_payment_schedules_all '||SQL%ROWCOUNT);
2257: END IF;
2258:
2259:
2260: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits

Line 2272: fnd_file.put_line(FND_FILE.LOG, 'Out ln_payment_audit_id '||ln_payment_audit_id);

2268: p_payment_audit_id => ln_payment_audit_id,
2269: p_process_status => lv_process_status,
2270: p_process_message => lv_process_message);
2271:
2272: fnd_file.put_line(FND_FILE.LOG, 'Out ln_payment_audit_id '||ln_payment_audit_id);
2273:
2274: IF lv_process_status <> jai_constants.successful THEN
2275: p_process_status := lv_process_status;
2276: p_process_message := lv_process_message;

Line 2281: fnd_file.put_line(FND_FILE.LOG, 'After call to maintain_schedules');

2277: goto EXIT_POINT;
2278: END IF;
2279:
2280: IF p_debug = 'Y' THEN
2281: fnd_file.put_line(FND_FILE.LOG, 'After call to maintain_schedules');
2282: END IF;
2283:
2284: IF rec_term_details.first_installment_code <> 'ALLOCATE' THEN
2285: EXIT;

Line 2310: fnd_file.put_line(FND_FILE.LOG,'Resource Busy,record '||p_customer_trx_id||' has been locked by another resource');

2306: NULL;
2307:
2308: EXCEPTION
2309: WHEN resource_busy THEN
2310: fnd_file.put_line(FND_FILE.LOG,'Resource Busy,record '||p_customer_trx_id||' has been locked by another resource');
2311: p_process_message:= ' Resource Busy,record '||p_customer_trx_id||' has been locked by another resource ';
2312: p_process_status := jai_constants.unexpected_error;
2313:
2314: WHEN LOCALIZATION_TAX_NOT_DEFINED THEN

Line 2315: fnd_file.put_line(FND_FILE.LOG,' ''Localization'' Tax not defined or is end-dated. Please ensure that a valid ''Localization'' Tax exists and is not enddated ');

2311: p_process_message:= ' Resource Busy,record '||p_customer_trx_id||' has been locked by another resource ';
2312: p_process_status := jai_constants.unexpected_error;
2313:
2314: WHEN LOCALIZATION_TAX_NOT_DEFINED THEN
2315: fnd_file.put_line(FND_FILE.LOG,' ''Localization'' Tax not defined or is end-dated. Please ensure that a valid ''Localization'' Tax exists and is not enddated ');
2316: p_process_message:= ' ''Localization'' Tax not defined or is end-dated. Please ensure that a valid ''Localization'' Tax exists and is not enddated ';
2317: p_process_status := jai_constants.expected_error;
2318:
2319: WHEN ROUNDING_ACCOUNT_NOT_DEFINED THEN

Line 2320: fnd_file.put_line(FND_FILE.LOG, lv_process_message );

2316: p_process_message:= ' ''Localization'' Tax not defined or is end-dated. Please ensure that a valid ''Localization'' Tax exists and is not enddated ';
2317: p_process_status := jai_constants.expected_error;
2318:
2319: WHEN ROUNDING_ACCOUNT_NOT_DEFINED THEN
2320: fnd_file.put_line(FND_FILE.LOG, lv_process_message );
2321: p_process_message := lv_process_message;
2322: p_process_status := lv_process_status;
2323:
2324: WHEN OTHERS THEN

Line 2325: fnd_file.put_line(FND_FILE.LOG,sqlerrm);

2321: p_process_message := lv_process_message;
2322: p_process_status := lv_process_status;
2323:
2324: WHEN OTHERS THEN
2325: fnd_file.put_line(FND_FILE.LOG,sqlerrm);
2326: p_process_status := jai_constants.unexpected_error;
2327: p_process_message :=SUBSTR(SQLERRM,1,120);
2328:
2329: UPDATE JAI_AR_TRX_INS_LINES_T

Line 2701: fnd_file.put_line(FND_FILE.LOG, 'Deletion in the RMA Blk...No. of rows deleted '|| v_sql_count);

2697: v_sql_count := SQL%ROWCOUNT;
2698: END IF;
2699: END LOOP;
2700: END IF;
2701: fnd_file.put_line(FND_FILE.LOG, 'Deletion in the RMA Blk...No. of rows deleted '|| v_sql_count);
2702: fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the Invoice..RMA Blk.. '|| v_trx_num);
2703:
2704: EXCEPTION
2705: WHEN OTHERS THEN

Line 2702: fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the Invoice..RMA Blk.. '|| v_trx_num);

2698: END IF;
2699: END LOOP;
2700: END IF;
2701: fnd_file.put_line(FND_FILE.LOG, 'Deletion in the RMA Blk...No. of rows deleted '|| v_sql_count);
2702: fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the Invoice..RMA Blk.. '|| v_trx_num);
2703:
2704: EXCEPTION
2705: WHEN OTHERS THEN
2706: --retcode :=3;

Line 2707: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN FOR RMA. Retcode = '|| retcode);

2703:
2704: EXCEPTION
2705: WHEN OTHERS THEN
2706: --retcode :=3;
2707: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN FOR RMA. Retcode = '|| retcode);
2708: fnd_file.put_line(FND_FILE.LOG, 'ERROR IN PROCESSING ..... ' || SQLERRM);
2709: END; --End block of RMA processing
2710: v_sql_num :=9;
2711:

Line 2708: fnd_file.put_line(FND_FILE.LOG, 'ERROR IN PROCESSING ..... ' || SQLERRM);

2704: EXCEPTION
2705: WHEN OTHERS THEN
2706: --retcode :=3;
2707: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN FOR RMA. Retcode = '|| retcode);
2708: fnd_file.put_line(FND_FILE.LOG, 'ERROR IN PROCESSING ..... ' || SQLERRM);
2709: END; --End block of RMA processing
2710: v_sql_num :=9;
2711:
2712: SELECT NVL(SUM(AMOUNT),0) INTO V_sum_amt FROM RA_CUST_TRX_LINE_GL_DIST_ALL WHERE

Line 3108: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 1.......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));

3104: Acctd_amount_due_remaining = NVL(Acctd_amount_due_remaining,0) + NVL(v_receivable_acctd_amount,0)
3105: Where Customer_Trx_ID = p_customer_trx_id
3106: And Payment_Schedule_ID = v_payment_schedule_id;
3107:
3108: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 1.......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
3109: fnd_file.put_line(FND_FILE.LOG, 'TAX REMAINING 1......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
3110: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_freight_amount,-77));
3111: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT REMAINING 1..' || v_trx_num || 'is ' || NVL(v_freight_amount,-66));
3112: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE REMAINING 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,-222));

Line 3109: fnd_file.put_line(FND_FILE.LOG, 'TAX REMAINING 1......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));

3105: Where Customer_Trx_ID = p_customer_trx_id
3106: And Payment_Schedule_ID = v_payment_schedule_id;
3107:
3108: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 1.......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
3109: fnd_file.put_line(FND_FILE.LOG, 'TAX REMAINING 1......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
3110: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_freight_amount,-77));
3111: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT REMAINING 1..' || v_trx_num || 'is ' || NVL(v_freight_amount,-66));
3112: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE REMAINING 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,-222));
3113: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,333));

Line 3110: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_freight_amount,-77));

3106: And Payment_Schedule_ID = v_payment_schedule_id;
3107:
3108: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 1.......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
3109: fnd_file.put_line(FND_FILE.LOG, 'TAX REMAINING 1......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
3110: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_freight_amount,-77));
3111: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT REMAINING 1..' || v_trx_num || 'is ' || NVL(v_freight_amount,-66));
3112: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE REMAINING 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,-222));
3113: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,333));
3114: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 1...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));

Line 3111: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT REMAINING 1..' || v_trx_num || 'is ' || NVL(v_freight_amount,-66));

3107:
3108: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 1.......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
3109: fnd_file.put_line(FND_FILE.LOG, 'TAX REMAINING 1......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
3110: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_freight_amount,-77));
3111: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT REMAINING 1..' || v_trx_num || 'is ' || NVL(v_freight_amount,-66));
3112: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE REMAINING 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,-222));
3113: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,333));
3114: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 1...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));
3115:

Line 3112: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE REMAINING 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,-222));

3108: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 1.......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
3109: fnd_file.put_line(FND_FILE.LOG, 'TAX REMAINING 1......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
3110: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_freight_amount,-77));
3111: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT REMAINING 1..' || v_trx_num || 'is ' || NVL(v_freight_amount,-66));
3112: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE REMAINING 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,-222));
3113: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,333));
3114: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 1...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));
3115:
3116: V_TEMP := NVL(v_old_amount,0) + NVL(v_tax_amt,0);

Line 3113: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,333));

3109: fnd_file.put_line(FND_FILE.LOG, 'TAX REMAINING 1......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
3110: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_freight_amount,-77));
3111: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT REMAINING 1..' || v_trx_num || 'is ' || NVL(v_freight_amount,-66));
3112: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE REMAINING 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,-222));
3113: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,333));
3114: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 1...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));
3115:
3116: V_TEMP := NVL(v_old_amount,0) + NVL(v_tax_amt,0);
3117:

Line 3114: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 1...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));

3110: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_freight_amount,-77));
3111: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT REMAINING 1..' || v_trx_num || 'is ' || NVL(v_freight_amount,-66));
3112: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE REMAINING 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,-222));
3113: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,333));
3114: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 1...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));
3115:
3116: V_TEMP := NVL(v_old_amount,0) + NVL(v_tax_amt,0);
3117:
3118: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 2.......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));

Line 3118: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 2.......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));

3114: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 1...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));
3115:
3116: V_TEMP := NVL(v_old_amount,0) + NVL(v_tax_amt,0);
3117:
3118: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 2.......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
3119: fnd_file.put_line(FND_FILE.LOG, 'TAX REMAINING 2......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
3120: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-77));
3121: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT REMAINING 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-66));
3122: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE REMAINING 2...' || v_trx_num || 'is ' || V_TEMP);

Line 3119: fnd_file.put_line(FND_FILE.LOG, 'TAX REMAINING 2......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));

3115:
3116: V_TEMP := NVL(v_old_amount,0) + NVL(v_tax_amt,0);
3117:
3118: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 2.......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
3119: fnd_file.put_line(FND_FILE.LOG, 'TAX REMAINING 2......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
3120: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-77));
3121: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT REMAINING 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-66));
3122: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE REMAINING 2...' || v_trx_num || 'is ' || V_TEMP);
3123: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 2...' || v_trx_num || 'is ' || V_TEMP);

Line 3120: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-77));

3116: V_TEMP := NVL(v_old_amount,0) + NVL(v_tax_amt,0);
3117:
3118: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 2.......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
3119: fnd_file.put_line(FND_FILE.LOG, 'TAX REMAINING 2......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
3120: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-77));
3121: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT REMAINING 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-66));
3122: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE REMAINING 2...' || v_trx_num || 'is ' || V_TEMP);
3123: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 2...' || v_trx_num || 'is ' || V_TEMP);
3124: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 2...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));

Line 3121: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT REMAINING 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-66));

3117:
3118: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 2.......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
3119: fnd_file.put_line(FND_FILE.LOG, 'TAX REMAINING 2......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
3120: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-77));
3121: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT REMAINING 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-66));
3122: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE REMAINING 2...' || v_trx_num || 'is ' || V_TEMP);
3123: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 2...' || v_trx_num || 'is ' || V_TEMP);
3124: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 2...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));
3125:

Line 3122: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE REMAINING 2...' || v_trx_num || 'is ' || V_TEMP);

3118: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 2.......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
3119: fnd_file.put_line(FND_FILE.LOG, 'TAX REMAINING 2......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
3120: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-77));
3121: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT REMAINING 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-66));
3122: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE REMAINING 2...' || v_trx_num || 'is ' || V_TEMP);
3123: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 2...' || v_trx_num || 'is ' || V_TEMP);
3124: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 2...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));
3125:
3126: end if; --END 22-MAR-02 FOR PROPER UPDATION

Line 3123: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 2...' || v_trx_num || 'is ' || V_TEMP);

3119: fnd_file.put_line(FND_FILE.LOG, 'TAX REMAINING 2......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
3120: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-77));
3121: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT REMAINING 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-66));
3122: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE REMAINING 2...' || v_trx_num || 'is ' || V_TEMP);
3123: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 2...' || v_trx_num || 'is ' || V_TEMP);
3124: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 2...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));
3125:
3126: end if; --END 22-MAR-02 FOR PROPER UPDATION
3127:

Line 3124: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 2...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));

3120: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-77));
3121: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT REMAINING 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-66));
3122: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE REMAINING 2...' || v_trx_num || 'is ' || V_TEMP);
3123: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 2...' || v_trx_num || 'is ' || V_TEMP);
3124: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 2...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));
3125:
3126: end if; --END 22-MAR-02 FOR PROPER UPDATION
3127:
3128: v_sql_num :=33;

Line 3137: fnd_file.put_line(FND_FILE.LOG, 'The total tax amount for the line is....' || v_tax_amt);

3133: v_sql_num :=34;
3134:
3135: ERRBUF :=SQLERRM;
3136: -- retcode := 0;
3137: fnd_file.put_line(FND_FILE.LOG, 'The total tax amount for the line is....' || v_tax_amt);
3138: fnd_file.put_line(FND_FILE.LOG, 'The receivable amount for the line is....' || v_receivable_amount);
3139: fnd_file.put_line(FND_FILE.LOG, 'Successfully Processed the Invoice... '|| v_trx_num);
3140: -- fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the Invoice Retcode = '|| retcode);
3141:

Line 3138: fnd_file.put_line(FND_FILE.LOG, 'The receivable amount for the line is....' || v_receivable_amount);

3134:
3135: ERRBUF :=SQLERRM;
3136: -- retcode := 0;
3137: fnd_file.put_line(FND_FILE.LOG, 'The total tax amount for the line is....' || v_tax_amt);
3138: fnd_file.put_line(FND_FILE.LOG, 'The receivable amount for the line is....' || v_receivable_amount);
3139: fnd_file.put_line(FND_FILE.LOG, 'Successfully Processed the Invoice... '|| v_trx_num);
3140: -- fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the Invoice Retcode = '|| retcode);
3141:
3142: EXCEPTION

Line 3139: fnd_file.put_line(FND_FILE.LOG, 'Successfully Processed the Invoice... '|| v_trx_num);

3135: ERRBUF :=SQLERRM;
3136: -- retcode := 0;
3137: fnd_file.put_line(FND_FILE.LOG, 'The total tax amount for the line is....' || v_tax_amt);
3138: fnd_file.put_line(FND_FILE.LOG, 'The receivable amount for the line is....' || v_receivable_amount);
3139: fnd_file.put_line(FND_FILE.LOG, 'Successfully Processed the Invoice... '|| v_trx_num);
3140: -- fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the Invoice Retcode = '|| retcode);
3141:
3142: EXCEPTION
3143: -- retcode := 5;

Line 3140: -- fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the Invoice Retcode = '|| retcode);

3136: -- retcode := 0;
3137: fnd_file.put_line(FND_FILE.LOG, 'The total tax amount for the line is....' || v_tax_amt);
3138: fnd_file.put_line(FND_FILE.LOG, 'The receivable amount for the line is....' || v_receivable_amount);
3139: fnd_file.put_line(FND_FILE.LOG, 'Successfully Processed the Invoice... '|| v_trx_num);
3140: -- fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the Invoice Retcode = '|| retcode);
3141:
3142: EXCEPTION
3143: -- retcode := 5;
3144: when others then

Line 3154: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);

3150: AND LINK_TO_CUST_TRX_LINE_ID = P_LINK_LINE_ID;
3151:
3152: COMMIT;
3153:
3154: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
3155: fnd_file.put_line(FND_FILE.LOG, 'Updated the customer_trx_id error_flag to ...' || 'R');
3156: fnd_file.put_line(FND_FILE.LOG, 'Unable to Process the invoice... '|| v_trx_num);
3157: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
3158: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM || v_sql_num);

Line 3155: fnd_file.put_line(FND_FILE.LOG, 'Updated the customer_trx_id error_flag to ...' || 'R');

3151:
3152: COMMIT;
3153:
3154: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
3155: fnd_file.put_line(FND_FILE.LOG, 'Updated the customer_trx_id error_flag to ...' || 'R');
3156: fnd_file.put_line(FND_FILE.LOG, 'Unable to Process the invoice... '|| v_trx_num);
3157: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
3158: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM || v_sql_num);
3159:

Line 3156: fnd_file.put_line(FND_FILE.LOG, 'Unable to Process the invoice... '|| v_trx_num);

3152: COMMIT;
3153:
3154: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
3155: fnd_file.put_line(FND_FILE.LOG, 'Updated the customer_trx_id error_flag to ...' || 'R');
3156: fnd_file.put_line(FND_FILE.LOG, 'Unable to Process the invoice... '|| v_trx_num);
3157: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
3158: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM || v_sql_num);
3159:
3160:

Line 3157: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);

3153:
3154: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
3155: fnd_file.put_line(FND_FILE.LOG, 'Updated the customer_trx_id error_flag to ...' || 'R');
3156: fnd_file.put_line(FND_FILE.LOG, 'Unable to Process the invoice... '|| v_trx_num);
3157: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
3158: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM || v_sql_num);
3159:
3160:
3161: END; --End Temp_Cur Block

Line 3158: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM || v_sql_num);

3154: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
3155: fnd_file.put_line(FND_FILE.LOG, 'Updated the customer_trx_id error_flag to ...' || 'R');
3156: fnd_file.put_line(FND_FILE.LOG, 'Unable to Process the invoice... '|| v_trx_num);
3157: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
3158: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM || v_sql_num);
3159:
3160:
3161: END; --End Temp_Cur Block
3162:

Line 3185: fnd_file.put_line(FND_FILE.LOG, ' DEBUG:SPATIAL) checking Tax Details updating updating v_return_reference_type_code ' || v_return_reference_type_code );

3181: Freight_Original = NVL(Freight_Original,0) + NVL(v_freight_amount,0),
3182: Amount_Due_Original = NVL(Amount_Due_Original,0) + NVL(v_receivable_amount,0)
3183: Where Customer_Trx_ID = p_customer_trx_id
3184: And Payment_Schedule_ID = v_payment_schedule_id;
3185: fnd_file.put_line(FND_FILE.LOG, ' DEBUG:SPATIAL) checking Tax Details updating updating v_return_reference_type_code ' || v_return_reference_type_code );
3186: ELSIF v_return_reference_type_code in ('Invoice India','Sales Order India')
3187: and v_credit_invoice_line_id IS NOT NULL THEN
3188:
3189: Select sum(amount) INTO v_tax_amount1

Line 3241: fnd_file.put_line(FND_FILE.LOG, 'v_tot_amount = '|| v_tot_amount);

3237: Acctd_Amount_Due_Remaining = NVL(Acctd_Amount_Due_Remaining,0) + NVL(v_freight_amount1,0)
3238: Where Customer_Trx_Id = v_prev_customer_trx_id
3239: And Payment_Schedule_Id = v_payment_Schedule_id; --18-apr-2002
3240:
3241: fnd_file.put_line(FND_FILE.LOG, 'v_tot_amount = '|| v_tot_amount);
3242: fnd_file.put_line(FND_FILE.LOG, 'v_tax_amount1 = '|| v_tax_amount1);
3243: fnd_file.put_line(FND_FILE.LOG, 'v_freight_amount1 = '|| v_freight_amount1);
3244: fnd_file.put_line(FND_FILE.LOG, ' DEBUG:SPATIAL) checking Tax Details updating updating v_return_reference_type_code ' || v_return_reference_type_code );
3245: END IF;

Line 3242: fnd_file.put_line(FND_FILE.LOG, 'v_tax_amount1 = '|| v_tax_amount1);

3238: Where Customer_Trx_Id = v_prev_customer_trx_id
3239: And Payment_Schedule_Id = v_payment_Schedule_id; --18-apr-2002
3240:
3241: fnd_file.put_line(FND_FILE.LOG, 'v_tot_amount = '|| v_tot_amount);
3242: fnd_file.put_line(FND_FILE.LOG, 'v_tax_amount1 = '|| v_tax_amount1);
3243: fnd_file.put_line(FND_FILE.LOG, 'v_freight_amount1 = '|| v_freight_amount1);
3244: fnd_file.put_line(FND_FILE.LOG, ' DEBUG:SPATIAL) checking Tax Details updating updating v_return_reference_type_code ' || v_return_reference_type_code );
3245: END IF;
3246:

Line 3243: fnd_file.put_line(FND_FILE.LOG, 'v_freight_amount1 = '|| v_freight_amount1);

3239: And Payment_Schedule_Id = v_payment_Schedule_id; --18-apr-2002
3240:
3241: fnd_file.put_line(FND_FILE.LOG, 'v_tot_amount = '|| v_tot_amount);
3242: fnd_file.put_line(FND_FILE.LOG, 'v_tax_amount1 = '|| v_tax_amount1);
3243: fnd_file.put_line(FND_FILE.LOG, 'v_freight_amount1 = '|| v_freight_amount1);
3244: fnd_file.put_line(FND_FILE.LOG, ' DEBUG:SPATIAL) checking Tax Details updating updating v_return_reference_type_code ' || v_return_reference_type_code );
3245: END IF;
3246:
3247: END IF;

Line 3244: fnd_file.put_line(FND_FILE.LOG, ' DEBUG:SPATIAL) checking Tax Details updating updating v_return_reference_type_code ' || v_return_reference_type_code );

3240:
3241: fnd_file.put_line(FND_FILE.LOG, 'v_tot_amount = '|| v_tot_amount);
3242: fnd_file.put_line(FND_FILE.LOG, 'v_tax_amount1 = '|| v_tax_amount1);
3243: fnd_file.put_line(FND_FILE.LOG, 'v_freight_amount1 = '|| v_freight_amount1);
3244: fnd_file.put_line(FND_FILE.LOG, ' DEBUG:SPATIAL) checking Tax Details updating updating v_return_reference_type_code ' || v_return_reference_type_code );
3245: END IF;
3246:
3247: END IF;
3248:

Line 3286: fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the invoice = '|| v_trx_num);

3282:
3283: COMMIT;
3284:
3285: -- retcode := 0;
3286: fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the invoice = '|| v_trx_num);
3287: -- fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the customer_trx_id Retcode = '|| retcode);
3288:
3289: EXCEPTION
3290:

Line 3287: -- fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the customer_trx_id Retcode = '|| retcode);

3283: COMMIT;
3284:
3285: -- retcode := 0;
3286: fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the invoice = '|| v_trx_num);
3287: -- fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the customer_trx_id Retcode = '|| retcode);
3288:
3289: EXCEPTION
3290:
3291: when Localization_tax_not_defined then

Line 3292: fnd_file.put_line(FND_FILE.LOG,' ''Localization'' Tax not defined or is end-dated. Please ensure that a valid ''Localization'' Tax exists and is not enddated ');

3288:
3289: EXCEPTION
3290:
3291: when Localization_tax_not_defined then
3292: fnd_file.put_line(FND_FILE.LOG,' ''Localization'' Tax not defined or is end-dated. Please ensure that a valid ''Localization'' Tax exists and is not enddated ');
3293: errbuf:= ' ''Localization'' Tax not defined or is end-dated. Please ensure that a valid ''Localization'' Tax exists and is not enddated ';
3294: retcode := 2;
3295:
3296: WHEN OTHERS THEN

Line 3303: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);

3299: UPDATE JAI_AR_TRX_INS_LINES_T SET ERROR_FLAG = 'R',ERR_MESG=ERRBUF WHERE CUSTOMER_TRX_ID=P_CUSTOMER_TRX_ID
3300: AND LINK_TO_CUST_TRX_LINE_ID = P_LINK_LINE_ID;
3301: COMMIT;
3302: -- retcode := 7;
3303: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
3304: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the invoice = '|| v_trx_num);
3305: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
3306: fnd_file.put_line(FND_FILE.LOG, 'Main Block.... the err = '|| SQLERRM);
3307: fnd_file.put_line(FND_FILE.LOG, 'Please Contact the System Administrator Or Oracle Software Support Services...');

Line 3304: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the invoice = '|| v_trx_num);

3300: AND LINK_TO_CUST_TRX_LINE_ID = P_LINK_LINE_ID;
3301: COMMIT;
3302: -- retcode := 7;
3303: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
3304: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the invoice = '|| v_trx_num);
3305: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
3306: fnd_file.put_line(FND_FILE.LOG, 'Main Block.... the err = '|| SQLERRM);
3307: fnd_file.put_line(FND_FILE.LOG, 'Please Contact the System Administrator Or Oracle Software Support Services...');
3308:

Line 3305: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);

3301: COMMIT;
3302: -- retcode := 7;
3303: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
3304: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the invoice = '|| v_trx_num);
3305: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
3306: fnd_file.put_line(FND_FILE.LOG, 'Main Block.... the err = '|| SQLERRM);
3307: fnd_file.put_line(FND_FILE.LOG, 'Please Contact the System Administrator Or Oracle Software Support Services...');
3308:
3309: END process_manual_invoice;

Line 3306: fnd_file.put_line(FND_FILE.LOG, 'Main Block.... the err = '|| SQLERRM);

3302: -- retcode := 7;
3303: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
3304: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the invoice = '|| v_trx_num);
3305: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
3306: fnd_file.put_line(FND_FILE.LOG, 'Main Block.... the err = '|| SQLERRM);
3307: fnd_file.put_line(FND_FILE.LOG, 'Please Contact the System Administrator Or Oracle Software Support Services...');
3308:
3309: END process_manual_invoice;
3310: -- Start commented by kunkumar for bug#6066813

Line 3307: fnd_file.put_line(FND_FILE.LOG, 'Please Contact the System Administrator Or Oracle Software Support Services...');

3303: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
3304: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the invoice = '|| v_trx_num);
3305: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
3306: fnd_file.put_line(FND_FILE.LOG, 'Main Block.... the err = '|| SQLERRM);
3307: fnd_file.put_line(FND_FILE.LOG, 'Please Contact the System Administrator Or Oracle Software Support Services...');
3308:
3309: END process_manual_invoice;
3310: -- Start commented by kunkumar for bug#6066813
3311: -- following function added for bug#6012570 (5876390) --> revoked the comments, 6012570

Line 3651: FND_FILE.PUT_LINE ( FND_FILE.LOG

3647: , ln_inv_org_id -- organization id of the inventory organization id
3648: );
3649:
3650: ln_total_inclu_tax_amt := ln_total_inclu_tax_amt + inclu_tax_csr.tax_amount;
3651: FND_FILE.PUT_LINE ( FND_FILE.LOG
3652: , 'Insert tax info: '
3653: || 'tax_account_id = ' || ln_tax_account_id
3654: || ' tax_amount = '|| inclu_tax_csr.tax_amount
3655: );

Line 3712: FND_FILE.PUT_LINE ( FND_FILE.LOG

3708: , pn_customer_trx_id -- value of customer_trx_id
3709: , ln_inv_org_id -- organization id of the inventory organization id
3710: );
3711:
3712: FND_FILE.PUT_LINE ( FND_FILE.LOG
3713: , 'Insert debit info: '
3714: || 'account_id = ' || ln_rec_account_id
3715: || ' amount = '|| ln_total_inclu_tax_amt
3716: );