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_CMN_RGM_PROCESSING_PKG dependencies on FND_FILE

Line 1165: fnd_file.put_line(fnd_file.log,'AccntChkFail. InvId,LineNum,DisNum:'||r_dist.invoice_id||','

1161: -- Following condition is true only if Invoice Distribution Accounting did not happen
1162: IF r_dist.posted_flag IS NULL OR r_dist.posted_flag <> 'Y' THEN
1163: lv_codepath := jai_general_pkg.plot_codepath(3, lv_codepath);
1164: IF g_debug='Y' THEN
1165: fnd_file.put_line(fnd_file.log,'AccntChkFail. InvId,LineNum,DisNum:'||r_dist.invoice_id||','
1166: ||r_dist.invoice_line_number||','||r_dist.distribution_line_number);
1167: END IF;
1168: p_process_flag := jai_constants.not_accounted;
1169: --p_process_message := 'Invoice is not accounted';

Line 1190: IF g_debug='Y' THEN fnd_file.put_line(fnd_file.log,'ProPay.r_ref:'||r_ref.reference_id||',taxty:'||r_ref.tax_type); END IF;

1186: p_process_flag := jai_constants.already_processed;
1187: RETURN;
1188: END IF;
1189:
1190: IF g_debug='Y' THEN fnd_file.put_line(fnd_file.log,'ProPay.r_ref:'||r_ref.reference_id||',taxty:'||r_ref.tax_type); END IF;
1191:
1192: OPEN c_rgm_repository_id(p_source, p_payment_table_name, p_payment_document_id, r_ref.reference_id);
1193: FETCH c_rgm_repository_id INTO ln_rgm_reposotory_id;
1194: CLOSE c_rgm_repository_id;

Line 1341: FND_FILE.put_line(fnd_file.log, 'RecoAmt:'||ln_recovered_amount||', RefRecobleAmt:'||r_ref.recoverable_amount

1337:
1338: END IF;
1339:
1340: IF g_debug = 'Y' THEN
1341: FND_FILE.put_line(fnd_file.log, 'RecoAmt:'||ln_recovered_amount||', RefRecobleAmt:'||r_ref.recoverable_amount
1342: ||', PaymtAmt:'||ln_payment_amount||', InvAmt:'||r_dist.invoice_amount||', DiscTaken:'||r_payment.discount_taken
1343: ||', rPayAmt:'||r_payment.amount||', DiscRecoAmt:'||ln_discounted_amount);
1344: END IF;
1345:

Line 1376: FND_FILE.put_line(fnd_file.log, 'DiffAmt:'||ln_diff_amount||', ValidtAmt:'||ln_validate_amount

1372:
1373: END IF;
1374:
1375: IF g_debug = 'Y' THEN
1376: FND_FILE.put_line(fnd_file.log, 'DiffAmt:'||ln_diff_amount||', ValidtAmt:'||ln_validate_amount
1377: ||', RecoAmt:'||ln_recovered_amount||', DiscRecoAmt:'||ln_discounted_amount);
1378: END IF;
1379:
1380: IF ln_recovered_amount = 0 THEN

Line 1383: fnd_file.put_line(fnd_file.log,'Allready amount is recovered');

1379:
1380: IF ln_recovered_amount = 0 THEN
1381: lv_codepath := jai_general_pkg.plot_codepath(26, lv_codepath);
1382: IF g_debug='Y' THEN
1383: fnd_file.put_line(fnd_file.log,'Allready amount is recovered');
1384: END IF;
1385: RETURN;
1386: END IF;
1387: /*Bug 5879769 bduvarag start*/

Line 1400: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);

1396: p_process_message => lv_process_message
1397: );
1398: IF lv_process_flag <> jai_constants.successful THEN
1399: lv_codepath := jai_general_pkg.plot_codepath(27.1, lv_codepath);
1400: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
1401: return;
1402: END IF;
1403: /*Bug 5879769 bduvarag End*/
1404: -- Replaced rec_get_curr_dtls by r_payment for Bug 8294236

Line 1497: fnd_file.put_line( fnd_file.log, 'error in call to jai_rgm_trx_recording_pkg.exc_gain_loss_accounting - lv_process_flag '||lv_process_flag

1493: lv_process_flag = jai_constants.unexpected_error
1494: THEN
1495: p_process_flag := lv_process_flag ;
1496: p_process_message := lv_process_message ;
1497: fnd_file.put_line( fnd_file.log, 'error in call to jai_rgm_trx_recording_pkg.exc_gain_loss_accounting - lv_process_flag '||lv_process_flag
1498: ||', lv_process_message'||lv_process_message);
1499: RETURN;
1500: END IF;
1501: END IF;

Line 1517: FND_FILE.put_line( fnd_file.log, 'Codepath:'||lv_codepath);

1513: <>
1514: lv_codepath := jai_general_pkg.plot_codepath(49, lv_codepath, 'PROCESS_PAYMENT', 'END');
1515:
1516: IF g_debug = 'Y' THEN
1517: FND_FILE.put_line( fnd_file.log, 'Codepath:'||lv_codepath);
1518: END IF;
1519: EXCEPTION
1520: WHEN OTHERS THEN
1521: p_process_flag := jai_constants.unexpected_error;

Line 1523: FND_FILE.put_line( fnd_file.log, p_process_message);

1519: EXCEPTION
1520: WHEN OTHERS THEN
1521: p_process_flag := jai_constants.unexpected_error;
1522: p_process_message := 'Process Payment Error:'||SQLERRM;
1523: FND_FILE.put_line( fnd_file.log, p_process_message);
1524: FND_FILE.put_line( fnd_file.log, 'Error Codepath:'||lv_codepath);
1525:
1526: END process_payment;
1527:

Line 1524: FND_FILE.put_line( fnd_file.log, 'Error Codepath:'||lv_codepath);

1520: WHEN OTHERS THEN
1521: p_process_flag := jai_constants.unexpected_error;
1522: p_process_message := 'Process Payment Error:'||SQLERRM;
1523: FND_FILE.put_line( fnd_file.log, p_process_message);
1524: FND_FILE.put_line( fnd_file.log, 'Error Codepath:'||lv_codepath);
1525:
1526: END process_payment;
1527:
1528: ---------------------------- PROCESS_BATCH ---------------------------

Line 1585: FND_FILE.put_line(fnd_file.log,'Value of from date is '||p_trx_from_date);

1581:
1582: p_trx_from_date := fnd_date.canonical_to_date(pv_trx_from_date); --File.Sql.35 by Brathod
1583: p_trx_till_date := fnd_date.canonical_to_date(pv_trx_till_date); --File.Sql.35 by Brathod
1584:
1585: FND_FILE.put_line(fnd_file.log,'Value of from date is '||p_trx_from_date);
1586: FND_FILE.put_line(fnd_file.log,'Value of from date is '||p_trx_till_date);
1587:
1588:
1589: g_debug := p_debug;

Line 1586: FND_FILE.put_line(fnd_file.log,'Value of from date is '||p_trx_till_date);

1582: p_trx_from_date := fnd_date.canonical_to_date(pv_trx_from_date); --File.Sql.35 by Brathod
1583: p_trx_till_date := fnd_date.canonical_to_date(pv_trx_till_date); --File.Sql.35 by Brathod
1584:
1585: FND_FILE.put_line(fnd_file.log,'Value of from date is '||p_trx_from_date);
1586: FND_FILE.put_line(fnd_file.log,'Value of from date is '||p_trx_till_date);
1587:
1588:
1589: g_debug := p_debug;
1590: g_debug := 'Y';

Line 1593: fnd_file.put_line(fnd_file.log, 'Enter1');

1589: g_debug := p_debug;
1590: g_debug := 'Y';
1591:
1592: IF p_debug = 'Y' THEN
1593: fnd_file.put_line(fnd_file.log, 'Enter1');
1594: END IF;
1595:
1596: /*
1597: OPEN c_previous_batch_dtls(p_regime_id, p_rgm_registration_num);

Line 1620: FND_FILE.put_line(fnd_file.log, 'Start Date('||to_char(p_trx_from_Date,'DD-MON-YYYY')

1616: CLOSE c_rgm_effective_from_date;
1617:
1618: IF p_trx_from_date < ld_rgm_effective_from THEN
1619:
1620: FND_FILE.put_line(fnd_file.log, 'Start Date('||to_char(p_trx_from_Date,'DD-MON-YYYY')
1621: ||') of Transaction Processing cannot be less than Regime Effective Date('||to_char(ld_rgm_effective_from,'DD-MON-YYYY')||')'
1622: );
1623: retcode := jai_constants.request_error;
1624:

Line 1640: fnd_file.put_line(fnd_file.log,'P_organization_type :' || jai_constants.orgn_type_io);

1636: CLOSE cur_fetch_ou;
1637: /* ends additions by ssumaith - bug#6109941*/
1638:
1639: /*Added by nprashar for bug # 6636517*/
1640: fnd_file.put_line(fnd_file.log,'P_organization_type :' || jai_constants.orgn_type_io);
1641: fnd_file.put_line(fnd_file.log,'P_organization_id :' ||ln_org_id);
1642: fnd_file.put_line(fnd_file.log,'P_Location_id :' ||loop_io.location_id); /*Ends here for bug #6636517*/
1643: /***************** Processing of AP Start Here *********************/
1644: process_payments(

Line 1641: fnd_file.put_line(fnd_file.log,'P_organization_id :' ||ln_org_id);

1637: /* ends additions by ssumaith - bug#6109941*/
1638:
1639: /*Added by nprashar for bug # 6636517*/
1640: fnd_file.put_line(fnd_file.log,'P_organization_type :' || jai_constants.orgn_type_io);
1641: fnd_file.put_line(fnd_file.log,'P_organization_id :' ||ln_org_id);
1642: fnd_file.put_line(fnd_file.log,'P_Location_id :' ||loop_io.location_id); /*Ends here for bug #6636517*/
1643: /***************** Processing of AP Start Here *********************/
1644: process_payments(
1645: p_regime_id => p_regime_id,

Line 1642: fnd_file.put_line(fnd_file.log,'P_Location_id :' ||loop_io.location_id); /Ends here for bug #6636517/

1638:
1639: /*Added by nprashar for bug # 6636517*/
1640: fnd_file.put_line(fnd_file.log,'P_organization_type :' || jai_constants.orgn_type_io);
1641: fnd_file.put_line(fnd_file.log,'P_organization_id :' ||ln_org_id);
1642: fnd_file.put_line(fnd_file.log,'P_Location_id :' ||loop_io.location_id); /*Ends here for bug #6636517*/
1643: /***************** Processing of AP Start Here *********************/
1644: process_payments(
1645: p_regime_id => p_regime_id,
1646: p_organization_type => jai_constants.orgn_type_io, /* ssumaith - bug# 6109941 */

Line 1683: FND_FILE.put_line( FND_FILE.log, 'Problem Message:'||lv_process_message);

1679:
1680: <>
1681:
1682: IF lv_process_flag IN (jai_constants.expected_error, jai_constants.unexpected_error) THEN
1683: FND_FILE.put_line( FND_FILE.log, 'Problem Message:'||lv_process_message);
1684: fnd_file.put_line(fnd_file.log,'Problem Message:'||lv_process_message);
1685: retcode := jai_constants.request_warning;
1686: errbuf := lv_process_message;
1687: END IF;

Line 1684: fnd_file.put_line(fnd_file.log,'Problem Message:'||lv_process_message);

1680: <>
1681:
1682: IF lv_process_flag IN (jai_constants.expected_error, jai_constants.unexpected_error) THEN
1683: FND_FILE.put_line( FND_FILE.log, 'Problem Message:'||lv_process_message);
1684: fnd_file.put_line(fnd_file.log,'Problem Message:'||lv_process_message);
1685: retcode := jai_constants.request_warning;
1686: errbuf := lv_process_message;
1687: END IF;
1688:

Line 1697: FND_FILE.put_line( fnd_file.log, 'Unexpected Error Occured:'||SQLERRM);

1693: WHEN OTHERS THEN
1694: ROLLBACK;
1695: retcode := jai_constants.request_error;
1696: errbuf := 'Unexpected Error Occured:'||SQLERRM;
1697: FND_FILE.put_line( fnd_file.log, 'Unexpected Error Occured:'||SQLERRM);
1698:
1699: END process_batch;
1700:
1701: /*Bug 12805386 - Start*/

Line 2398: IF p_debug = 'Y' THEN fnd_file.put_line(fnd_file.log, 'AAA Enter2 - Organization id:'||p_organization_id||'OU ID:'||p_org_id||',sob:'||ln_sob_id); END IF;/Bug 5879769 bduvarag/

2394: (p_org_id => p_org_id );
2395: ln_sob_id := l_func_curr_det.ledger_id;
2396:
2397:
2398: IF p_debug = 'Y' THEN fnd_file.put_line(fnd_file.log, 'AAA Enter2 - Organization id:'||p_organization_id||'OU ID:'||p_org_id||',sob:'||ln_sob_id); END IF;/*Bug 5879769 bduvarag*/
2399:
2400: -- this is required for to rollback the changes made in this procedure incase any unexpected error
2401: -- SAVEPOINT start_payments;
2402:

Line 2409: IF p_debug = 'Y' THEN fnd_file.put_line(fnd_file.log, 'Enter3 - ap_event_id:'||ap_acc_dist.accounting_event_id); END IF;

2405: -- if the invoice is cancelled, then no references are populated so that the lines are not processed against any
2406: -- Payements/Voids that are present for this invoice
2407: FOR ap_acc_dist IN c_ap_accounted_inv_dist( 'Purchase Invoices', p_trx_from_date, p_trx_to_date, ln_sob_id) LOOP/*Bug 5879769 bduvarag*/
2408:
2409: IF p_debug = 'Y' THEN fnd_file.put_line(fnd_file.log, 'Enter3 - ap_event_id:'||ap_acc_dist.accounting_event_id); END IF;
2410:
2411: --Bug 4991017. Added by Lakshmi gopalsami
2412: -- Removed the FOR.. LOOP dist.
2413:

Line 2414: IF p_debug = 'Y' THEN fnd_file.put_line(fnd_file.log, 'Enter4 - invid:'||ap_acc_dist.invoice_id

2410:
2411: --Bug 4991017. Added by Lakshmi gopalsami
2412: -- Removed the FOR.. LOOP dist.
2413:
2414: IF p_debug = 'Y' THEN fnd_file.put_line(fnd_file.log, 'Enter4 - invid:'||ap_acc_dist.invoice_id
2415: ||', LineNum:'||ap_acc_dist.invoice_line_number ||',distid:'||ap_acc_dist.distribution_line_number); END IF;
2416:
2417: -- Initialization Point
2418: ln_reference_id := null;

Line 2434: fnd_file.put_line(fnd_file.log, 'Enter5 - Return Ref NotNull');

2430:
2431: -- following condition is satisfied if the invoice line is already inserted into REFERENCEs table
2432: IF r_ref.reference_id IS NOT NULL THEN
2433: IF p_debug = 'Y' THEN
2434: fnd_file.put_line(fnd_file.log, 'Enter5 - Return Ref NotNull');
2435: END IF;
2436: GOTO end_of_reference_insertion;
2437: END IF;
2438:

Line 2479: fnd_file.put_line(fnd_file.log, 'Enter6 - DistChk is 0');

2475: END IF;
2476:
2477: IF nvl(r_tax_dist_dtl.chk, 0) = 0 THEN
2478: IF p_debug = 'Y' THEN
2479: fnd_file.put_line(fnd_file.log, 'Enter6 - DistChk is 0');
2480: END IF;
2481:
2482: GOTO end_of_reference_insertion;
2483: END IF;

Line 2487: fnd_file.put_line(fnd_file.log, 'Enter7 - recov_ptg is 0');

2483: END IF;
2484:
2485: IF r_tax_dist_dtl.recoverable_ptg = 0 THEN
2486: IF p_debug = 'Y' THEN
2487: fnd_file.put_line(fnd_file.log, 'Enter7 - recov_ptg is 0');
2488: END IF;
2489: FND_FILE.put_line( FND_FILE.log, 'Invoice_id, LineNum, DistNum->'||ap_acc_dist.invoice_id
2490: ||','||ap_acc_dist.invoice_line_number||','||ap_acc_dist.distribution_line_number||' is not Recoverable');
2491: GOTO end_of_reference_insertion;

Line 2489: FND_FILE.put_line( FND_FILE.log, 'Invoice_id, LineNum, DistNum->'||ap_acc_dist.invoice_id

2485: IF r_tax_dist_dtl.recoverable_ptg = 0 THEN
2486: IF p_debug = 'Y' THEN
2487: fnd_file.put_line(fnd_file.log, 'Enter7 - recov_ptg is 0');
2488: END IF;
2489: FND_FILE.put_line( FND_FILE.log, 'Invoice_id, LineNum, DistNum->'||ap_acc_dist.invoice_id
2490: ||','||ap_acc_dist.invoice_line_number||','||ap_acc_dist.distribution_line_number||' is not Recoverable');
2491: GOTO end_of_reference_insertion;
2492: END IF;
2493:

Line 2642: IF p_debug = 'Y' THEN fnd_file.put_line(fnd_file.log, 'Enter8 - Inserted Reference:'||ln_reference_id); END IF;

2638: COMMIT;
2639: ln_uncommited_trxs := 0;
2640: END IF;
2641: end if;--Added by zhiwei for POT change Bug#13023443 on 20110930
2642: IF p_debug = 'Y' THEN fnd_file.put_line(fnd_file.log, 'Enter8 - Inserted Reference:'||ln_reference_id); END IF;
2643:
2644: <>
2645: NULL;
2646:

Line 2839: IF g_debug='Y' THEN fnd_file.put_line(fnd_file.log,'PeriodPay. Inv,DistId:'||inv_payment.invoice_id||','||inv_payment.invoice_distribution_id); END IF;

2835: */
2836: FOR inv_payment IN c_period_payments( p_trx_from_date, p_trx_to_date) LOOP
2837: lv_process_flag := null;
2838:
2839: IF g_debug='Y' THEN fnd_file.put_line(fnd_file.log,'PeriodPay. Inv,DistId:'||inv_payment.invoice_id||','||inv_payment.invoice_distribution_id); END IF;
2840:
2841: /*Bug 12805386 - Start*/
2842: get_org_location(inv_payment.invoice_id, inv_payment.invoice_line_number, inv_payment.po_distribution_id, l_organization_id, l_location_id);
2843:

Line 2890: fnd_file.put_line(fnd_file.log, 'Enter FOR pp IN c_prepayment_applications(p_trx_from_date, p_trx_to_date) LOOP pp.invoice_id'||pp.invoice_id);

2886: -- Logic to Process Prepayment Applications onto standard invoices that fall in the processing period
2887: FOR pp IN c_prepayment_applications(p_trx_from_date, p_trx_to_date) LOOP
2888: --11666653
2889: IF p_debug = 'Y' THEN
2890: fnd_file.put_line(fnd_file.log, 'Enter FOR pp IN c_prepayment_applications(p_trx_from_date, p_trx_to_date) LOOP pp.invoice_id'||pp.invoice_id);
2891: END IF;
2892:
2893: FOR dist IN c_invoice_distributions(pp.invoice_id) LOOP
2894: --11666653

Line 2896: fnd_file.put_line(fnd_file.log, 'Enter FOR dist IN c_invoice_distributions(pp.invoice_id) LOOP ');

2892:
2893: FOR dist IN c_invoice_distributions(pp.invoice_id) LOOP
2894: --11666653
2895: IF p_debug = 'Y' THEN
2896: fnd_file.put_line(fnd_file.log, 'Enter FOR dist IN c_invoice_distributions(pp.invoice_id) LOOP ');
2897: END IF;
2898: lv_process_flag := null;
2899: /*Bug 12805386 - Start*/
2900: get_org_location(pp.invoice_id, pp.invoice_line_number, pp.po_distribution_id, l_organization_id, l_location_id);

Line 2915: fnd_file.put_line(fnd_file.log, 'before call to process_payment dist.invoice_id '||dist.invoice_id||' dist.invoice_distribution_id '||dist.invoice_distribution_id);

2911: -- Add by Xiao for POT change, reg bug#12533434 on 29-May-2011, end
2912: SAVEPOINT process_prepayment;
2913: --11666653
2914: IF p_debug = 'Y' THEN
2915: fnd_file.put_line(fnd_file.log, 'before call to process_payment dist.invoice_id '||dist.invoice_id||' dist.invoice_distribution_id '||dist.invoice_distribution_id);
2916: fnd_file.put_line(fnd_file.log, 'before call to process_payment pp.invoice_distribution_id '|| pp.invoice_distribution_id);
2917: END IF;
2918: process_payment(
2919: p_batch_id => p_batch_id,

Line 2916: fnd_file.put_line(fnd_file.log, 'before call to process_payment pp.invoice_distribution_id '|| pp.invoice_distribution_id);

2912: SAVEPOINT process_prepayment;
2913: --11666653
2914: IF p_debug = 'Y' THEN
2915: fnd_file.put_line(fnd_file.log, 'before call to process_payment dist.invoice_id '||dist.invoice_id||' dist.invoice_distribution_id '||dist.invoice_distribution_id);
2916: fnd_file.put_line(fnd_file.log, 'before call to process_payment pp.invoice_distribution_id '|| pp.invoice_distribution_id);
2917: END IF;
2918: process_payment(
2919: p_batch_id => p_batch_id,
2920: p_regime_id => p_regime_id,

Line 2955: FND_FILE.put_line( fnd_file.log, 'Unexpected Error Occured:'||p_process_message);

2951: -- retcode := jai_constants.request_error;
2952: -- errbuf := 'Unexpected Error Occured:'||SQLERRM;
2953: p_process_flag := jai_constants.unexpected_error;
2954: p_process_message := 'Unexpected Error Occured in Process_Payments:'||SQLERRM;
2955: FND_FILE.put_line( fnd_file.log, 'Unexpected Error Occured:'||p_process_message);
2956:
2957: END process_payments;
2958:
2959: /*

Line 3085: 2.As the returning clause was not required and hence was removed. Also added the fnd_file log in

3081:
3082: Fix :
3083: -----
3084: 1.The issue has been fixed by adding the p_registration_num and p_Regime_id in the where clause.
3085: 2.As the returning clause was not required and hence was removed. Also added the fnd_file log in
3086: the exception section of the procedure.
3087:
3088: Dependency due to this bug:-
3089: None

Line 3319: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1. Entered in the proc with parameters :');

3315: ln_current_order_number := -9999;
3316: ln_regime_id := p_regime_id ;
3317: -- added by Allen Yang for for bug 9485355 (12.1.3 non-shippable Enhancement), end
3318: IF lv_debug = 'Y' THEN
3319: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1. Entered in the proc with parameters :');
3320: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGIME_ID :' || P_REGIME_ID);
3321: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGISTRATION_NUM :' || P_REGISTRATION_NUM);
3322: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
3323: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);

Line 3320: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGIME_ID :' || P_REGIME_ID);

3316: ln_regime_id := p_regime_id ;
3317: -- added by Allen Yang for for bug 9485355 (12.1.3 non-shippable Enhancement), end
3318: IF lv_debug = 'Y' THEN
3319: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1. Entered in the proc with parameters :');
3320: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGIME_ID :' || P_REGIME_ID);
3321: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGISTRATION_NUM :' || P_REGISTRATION_NUM);
3322: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
3323: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
3324: -- added by Allen Yang for for bug 9485355 (12.1.3 non-shippable Enhancement), begin

Line 3321: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGISTRATION_NUM :' || P_REGISTRATION_NUM);

3317: -- added by Allen Yang for for bug 9485355 (12.1.3 non-shippable Enhancement), end
3318: IF lv_debug = 'Y' THEN
3319: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1. Entered in the proc with parameters :');
3320: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGIME_ID :' || P_REGIME_ID);
3321: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGISTRATION_NUM :' || P_REGISTRATION_NUM);
3322: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
3323: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
3324: -- added by Allen Yang for for bug 9485355 (12.1.3 non-shippable Enhancement), begin
3325: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_FROM :' || P_ORDER_NUMBER_FROM);

Line 3322: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);

3318: IF lv_debug = 'Y' THEN
3319: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1. Entered in the proc with parameters :');
3320: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGIME_ID :' || P_REGIME_ID);
3321: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGISTRATION_NUM :' || P_REGISTRATION_NUM);
3322: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
3323: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
3324: -- added by Allen Yang for for bug 9485355 (12.1.3 non-shippable Enhancement), begin
3325: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_FROM :' || P_ORDER_NUMBER_FROM);
3326: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_TO :' || P_ORDER_NUMBER_TO);

Line 3323: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);

3319: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1. Entered in the proc with parameters :');
3320: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGIME_ID :' || P_REGIME_ID);
3321: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGISTRATION_NUM :' || P_REGISTRATION_NUM);
3322: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
3323: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
3324: -- added by Allen Yang for for bug 9485355 (12.1.3 non-shippable Enhancement), begin
3325: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_FROM :' || P_ORDER_NUMBER_FROM);
3326: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_TO :' || P_ORDER_NUMBER_TO);
3327: -- added by Allen Yang for for bug 9485355 (12.1.3 non-shippable Enhancement), end

Line 3325: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_FROM :' || P_ORDER_NUMBER_FROM);

3321: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGISTRATION_NUM :' || P_REGISTRATION_NUM);
3322: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
3323: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
3324: -- added by Allen Yang for for bug 9485355 (12.1.3 non-shippable Enhancement), begin
3325: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_FROM :' || P_ORDER_NUMBER_FROM);
3326: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_TO :' || P_ORDER_NUMBER_TO);
3327: -- added by Allen Yang for for bug 9485355 (12.1.3 non-shippable Enhancement), end
3328: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
3329: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);

Line 3326: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_TO :' || P_ORDER_NUMBER_TO);

3322: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
3323: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
3324: -- added by Allen Yang for for bug 9485355 (12.1.3 non-shippable Enhancement), begin
3325: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_FROM :' || P_ORDER_NUMBER_FROM);
3326: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_TO :' || P_ORDER_NUMBER_TO);
3327: -- added by Allen Yang for for bug 9485355 (12.1.3 non-shippable Enhancement), end
3328: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
3329: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
3330: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);

Line 3328: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);

3324: -- added by Allen Yang for for bug 9485355 (12.1.3 non-shippable Enhancement), begin
3325: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_FROM :' || P_ORDER_NUMBER_FROM);
3326: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_TO :' || P_ORDER_NUMBER_TO);
3327: -- added by Allen Yang for for bug 9485355 (12.1.3 non-shippable Enhancement), end
3328: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
3329: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
3330: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
3331: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
3332: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);

Line 3329: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);

3325: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_FROM :' || P_ORDER_NUMBER_FROM);
3326: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_TO :' || P_ORDER_NUMBER_TO);
3327: -- added by Allen Yang for for bug 9485355 (12.1.3 non-shippable Enhancement), end
3328: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
3329: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
3330: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
3331: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
3332: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
3333: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);

Line 3330: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);

3326: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_TO :' || P_ORDER_NUMBER_TO);
3327: -- added by Allen Yang for for bug 9485355 (12.1.3 non-shippable Enhancement), end
3328: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
3329: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
3330: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
3331: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
3332: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
3333: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
3334: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);

Line 3331: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);

3327: -- added by Allen Yang for for bug 9485355 (12.1.3 non-shippable Enhancement), end
3328: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
3329: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
3330: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
3331: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
3332: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
3333: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
3334: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
3335: END IF;

Line 3332: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);

3328: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
3329: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
3330: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
3331: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
3332: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
3333: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
3334: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
3335: END IF;
3336: ln_conc_progam_id := FND_GLOBAL.conc_program_id;

Line 3333: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);

3329: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
3330: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
3331: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
3332: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
3333: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
3334: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
3335: END IF;
3336: ln_conc_progam_id := FND_GLOBAL.conc_program_id;
3337: ln_conc_request_id := FND_GLOBAL.conc_request_id;

Line 3334: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);

3330: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
3331: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
3332: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
3333: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
3334: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
3335: END IF;
3336: ln_conc_progam_id := FND_GLOBAL.conc_program_id;
3337: ln_conc_request_id := FND_GLOBAL.conc_request_id;
3338: ln_conc_prog_appl_id := FND_GLOBAL.prog_appl_id;

Line 3350: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ P_PROCESS_ACTION parameter IS NULL Hence returning +++ ' );

3346: ln_success_delivery_Ctr :=0;
3347: ln_interface_status :=0; /*added by srjayara for bug 4702156*/
3348:
3349: IF P_PROCESS_ACTION IS NULL THEN
3350: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ P_PROCESS_ACTION parameter IS NULL Hence returning +++ ' );
3351: RETURN;
3352: END IF;
3353:
3354: -- modified by Allen Yang for for bug 9485355 (12.1.3 non-shippable Enhancement), begin

Line 3447: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Query SQL for shippable items only: '||lv_SQLStmt);

3443: -- added by zhiwei.xin on 8-NOV-2012 for VAT Invoice Generation/Accounting end
3444: -- code ported from Bl12.1.3 on 25-MAR-2013 end.
3445: IF lv_debug = 'Y'
3446: THEN
3447: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Query SQL for shippable items only: '||lv_SQLStmt);
3448: END IF; -- lv_debug = 'Y'
3449: ELSE
3450: lv_SQLStmt := sql_stmt_all;
3451: IF lv_debug = 'Y'

Line 3453: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Query SQL for shippable and non-shippable items: '||lv_SQLStmt);

3449: ELSE
3450: lv_SQLStmt := sql_stmt_all;
3451: IF lv_debug = 'Y'
3452: THEN
3453: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Query SQL for shippable and non-shippable items: '||lv_SQLStmt);
3454: END IF; -- lv_debug = 'Y'
3455: END IF; -- p_delivery_id_from IS NOT NULL AND p_delivery_id_to IS NOT NULL
3456:
3457: OPEN v_main_rec_cur FOR lv_SQLStmt;

Line 3462: --Fnd_File.PUT_LINE(Fnd_File.LOG, 'delivery_id: '||mainrec.delivery_id||' order_line_id: '||mainrec.order_line_id);

3458: LOOP
3459: FETCH v_main_rec_cur INTO mainrec;
3460: EXIT WHEN v_main_rec_cur%NOTFOUND;
3461:
3462: --Fnd_File.PUT_LINE(Fnd_File.LOG, 'delivery_id: '||mainrec.delivery_id||' order_line_id: '||mainrec.order_line_id);
3463:
3464: -- start processing records
3465: IF mainrec.delivery_id IS NOT NULL -- for shippable line
3466: THEN

Line 3475: Fnd_File.PUT_LINE(Fnd_File.LOG,

3471: CLOSE c_check_interface_status;
3472:
3473: IF ln_interface_status = 1
3474: THEN
3475: Fnd_File.PUT_LINE(Fnd_File.LOG,
3476: 'Delivery - ' || mainrec.delivery_id ||
3477: ' Cannot be processed because all delivery details'||
3478: ' are not inventory interfaced');
3479: -- added by zhiwei.xin for bug#16220878 on 5-FEB-2013 begin

Line 3488: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Processing Delivery - ' || mainrec.delivery_id);

3484: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
3485: goto NEXTDELIVERY;
3486: END IF; -- ln_interface_status = 1
3487: IF lv_debug = 'Y' THEN
3488: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Processing Delivery - ' || mainrec.delivery_id);
3489: END IF; -- lv_debug = 'Y'
3490: ELSE -- else for non-shippable line
3491: lv_p_source := jai_constants.source_nsh;
3492: IF lv_debug = 'Y' THEN

Line 3493: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Processing Non-shippable Order Line - ' ||

3489: END IF; -- lv_debug = 'Y'
3490: ELSE -- else for non-shippable line
3491: lv_p_source := jai_constants.source_nsh;
3492: IF lv_debug = 'Y' THEN
3493: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Processing Non-shippable Order Line - ' ||
3494: mainrec.order_line_id);
3495: END IF; -- lv_debug = 'Y'
3496: END IF; -- mainrec.delivery_id IS NOT NULL
3497:

Line 3507: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_id : ' || ln_current_party_id);

3503: END IF; -- check_reg_dealer(mainrec.party_id,mainrec.party_site_id)
3504:
3505: IF lv_Debug = 'Y'
3506: THEN
3507: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_id : ' || ln_current_party_id);
3508: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_id : ' || mainrec.party_id);
3509: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);
3510: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);
3511: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_order_number : ' || ln_current_order_number);

Line 3508: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_id : ' || mainrec.party_id);

3504:
3505: IF lv_Debug = 'Y'
3506: THEN
3507: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_id : ' || ln_current_party_id);
3508: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_id : ' || mainrec.party_id);
3509: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);
3510: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);
3511: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_order_number : ' || ln_current_order_number);
3512: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.order_number :' || mainrec.order_number);

Line 3509: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);

3505: IF lv_Debug = 'Y'
3506: THEN
3507: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_id : ' || ln_current_party_id);
3508: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_id : ' || mainrec.party_id);
3509: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);
3510: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);
3511: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_order_number : ' || ln_current_order_number);
3512: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.order_number :' || mainrec.order_number);
3513: Fnd_File.PUT_LINE(Fnd_File.LOG, 'lv_doc_type_class:' || lv_doc_type_class);

Line 3510: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);

3506: THEN
3507: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_id : ' || ln_current_party_id);
3508: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_id : ' || mainrec.party_id);
3509: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);
3510: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);
3511: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_order_number : ' || ln_current_order_number);
3512: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.order_number :' || mainrec.order_number);
3513: Fnd_File.PUT_LINE(Fnd_File.LOG, 'lv_doc_type_class:' || lv_doc_type_class);
3514: END IF; -- lv_Debug = 'Y'

Line 3511: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_order_number : ' || ln_current_order_number);

3507: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_id : ' || ln_current_party_id);
3508: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_id : ' || mainrec.party_id);
3509: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);
3510: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);
3511: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_order_number : ' || ln_current_order_number);
3512: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.order_number :' || mainrec.order_number);
3513: Fnd_File.PUT_LINE(Fnd_File.LOG, 'lv_doc_type_class:' || lv_doc_type_class);
3514: END IF; -- lv_Debug = 'Y'
3515:

Line 3512: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.order_number :' || mainrec.order_number);

3508: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_id : ' || mainrec.party_id);
3509: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);
3510: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);
3511: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_order_number : ' || ln_current_order_number);
3512: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.order_number :' || mainrec.order_number);
3513: Fnd_File.PUT_LINE(Fnd_File.LOG, 'lv_doc_type_class:' || lv_doc_type_class);
3514: END IF; -- lv_Debug = 'Y'
3515:
3516: IF ln_current_party_id <> mainrec.party_id OR

Line 3513: Fnd_File.PUT_LINE(Fnd_File.LOG, 'lv_doc_type_class:' || lv_doc_type_class);

3509: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);
3510: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);
3511: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_order_number : ' || ln_current_order_number);
3512: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.order_number :' || mainrec.order_number);
3513: Fnd_File.PUT_LINE(Fnd_File.LOG, 'lv_doc_type_class:' || lv_doc_type_class);
3514: END IF; -- lv_Debug = 'Y'
3515:
3516: IF ln_current_party_id <> mainrec.party_id OR
3517: ln_current_party_site_id <> mainrec.party_site_id

Line 3565: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_Same_invoice_no = Y , Hence we need not call inv num generation routine - using excise inv num instead');

3561: 2. else, use excise as VAT invoice number, and update JAI_RGM_INVOICE_GEN_T
3562: (vat_invoice_no => excise_inv_number, vat_inv_gen_status => 'C');
3563: */
3564: IF lv_debug = 'Y' THEN
3565: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_Same_invoice_no = Y , Hence we need not call inv num generation routine - using excise inv num instead');
3566: END IF; -- lv_debug = 'Y'
3567:
3568: ln_excise_invoice_not_done := NULL;
3569: OPEN c_excise_invoice_not_done (mainrec.delivery_id);

Line 3574: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_excise_invoice_not_done = ' || NVL(ln_excise_invoice_not_done,-1));

3570: FETCH c_excise_invoice_not_done INTO ln_excise_invoice_not_done;
3571: CLOSE c_excise_invoice_not_done ;
3572:
3573: IF lv_debug = 'Y' THEN
3574: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_excise_invoice_not_done = ' || NVL(ln_excise_invoice_not_done,-1));
3575: END IF; -- lv_debug = 'Y'
3576:
3577: IF ln_excise_invoice_not_done IS NULL THEN
3578: -- Excise invoice number in not found , populate it as -1

Line 3592: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Excise Invoice Generation is not generated yet for this Delivery. Please run the excise invoice number generation number for delivery : '

3588: lv_inv_gen_process_flag := jai_constants.expected_error;
3589: lv_inv_gen_process_message := 'Excise Invoice Generation is not generated yet for this Delivery. Please run the excise invoice number generation number for delivery : '
3590: || mainrec.delivery_id;
3591: -- Not using the debug flag for the following message because it needs to be shown to the user irrespective of debug flag.
3592: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Excise Invoice Generation is not generated yet for this Delivery. Please run the excise invoice number generation number for delivery : '
3593: || mainrec.delivery_id);
3594: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
3595: goto NEXTDELIVERY;
3596: ELSE

Line 3612: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Excise Invoice number - ' || lv_vat_invoice_number || ' Will be used as VAT Invoice number for delivery : ' || mainrec.delivery_id);

3608: IF lv_excise_invoice_no IS NOT NULL THEN
3609: -- Excise invoice number is not null - so the same excise invoice number needs to be used as VAT invoice number
3610: lv_vat_invoice_number := lv_excise_invoice_no;
3611: IF lv_debug = 'Y' THEN
3612: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Excise Invoice number - ' || lv_vat_invoice_number || ' Will be used as VAT Invoice number for delivery : ' || mainrec.delivery_id);
3613: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before updating jai_om_wsh_lines_all for ex inv num');
3614: END IF; -- lv_debug = 'Y'
3615:
3616: UPDATE JAI_OM_WSH_LINES_ALL

Line 3613: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before updating jai_om_wsh_lines_all for ex inv num');

3609: -- Excise invoice number is not null - so the same excise invoice number needs to be used as VAT invoice number
3610: lv_vat_invoice_number := lv_excise_invoice_no;
3611: IF lv_debug = 'Y' THEN
3612: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Excise Invoice number - ' || lv_vat_invoice_number || ' Will be used as VAT Invoice number for delivery : ' || mainrec.delivery_id);
3613: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before updating jai_om_wsh_lines_all for ex inv num');
3614: END IF; -- lv_debug = 'Y'
3615:
3616: UPDATE JAI_OM_WSH_LINES_ALL
3617: SET vat_invoice_no = excise_invoice_no

Line 3622: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before updating jai_rgm_invoice_gen_t for ex inv num');

3618: , vat_invoice_date = excise_invoice_date
3619: WHERE delivery_id = mainrec.delivery_id;
3620:
3621: IF lv_debug = 'Y' THEN
3622: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before updating jai_rgm_invoice_gen_t for ex inv num');
3623: END IF;
3624:
3625: UPDATE JAI_RGM_INVOICE_GEN_T
3626: SET vat_invoice_no = lv_vat_invoice_number

Line 3637: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after updating jai_rgm_invoice_gen_t for ex inv num');

3633: , last_update_Date = sysdate
3634: WHERE Delivery_id = mainrec.delivery_id;
3635:
3636: IF lv_debug = 'Y' THEN
3637: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after updating jai_rgm_invoice_gen_t for ex inv num');
3638: END IF;
3639:
3640: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;
3641:

Line 3643: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Before going to process accounting for generating accounting');

3639:
3640: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;
3641:
3642: IF lv_debug = 'Y' THEN
3643: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Before going to process accounting for generating accounting');
3644: END IF;
3645:
3646: lv_inv_gen_process_flag := jai_constants.successful;
3647: GOTO Processaccounting;

Line 3678: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);

3674: , vat_inv_gen_status => 'C');
3675: */
3676: IF lv_Debug = 'Y'
3677: THEN
3678: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);
3679: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
3680: END IF; -- lv_Debug = 'Y'
3681: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
3682: THEN

Line 3679: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);

3675: */
3676: IF lv_Debug = 'Y'
3677: THEN
3678: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);
3679: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
3680: END IF; -- lv_Debug = 'Y'
3681: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
3682: THEN
3683: IF lv_inv_num_already_generated = jai_constants.value_false

Line 3686: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with ln_order_type_id' || ln_order_type_id || 'date ' || mainrec.delivery_date );

3682: THEN
3683: IF lv_inv_num_already_generated = jai_constants.value_false
3684: THEN
3685: IF lv_Debug = 'Y' THEN
3686: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with ln_order_type_id' || ln_order_type_id || 'date ' || mainrec.delivery_date );
3687: END IF; -- lv_Debug = 'Y'
3688: jai_cmn_rgm_setup_pkg.Gen_Invoice_number(p_regime_id => ln_regime_id
3689: , p_organization_id => mainrec.organization_id
3690: , p_location_id => mainrec.location_id

Line 3699: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after call with lv_vat_invoice_number:' || lv_vat_invoice_number || lv_inv_gen_process_flag ||lv_inv_gen_process_message);

3695: , p_process_flag => lv_inv_gen_process_flag
3696: , p_process_msg => lv_inv_gen_process_message
3697: );
3698: IF lv_Debug = 'Y' THEN
3699: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after call with lv_vat_invoice_number:' || lv_vat_invoice_number || lv_inv_gen_process_flag ||lv_inv_gen_process_message);
3700: END IF; -- lv_Debug = 'Y'
3701:
3702: -- check the return status and update the JAI_OM_WSH_LINES_ALL table to set the vat invoice number
3703: IF lv_inv_gen_process_flag = jai_constants.successful

Line 3802: Fnd_File.PUT_LINE(Fnd_File.LOG, 'No. of Deliveries updated in jai_vat_processing_t: ' || SQL%ROWCOUNT);

3798:
3799: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + sql%rowcount ;
3800:
3801: IF lv_Debug = 'Y' THEN
3802: Fnd_File.PUT_LINE(Fnd_File.LOG, 'No. of Deliveries updated in jai_vat_processing_t: ' || SQL%ROWCOUNT);
3803: END IF; -- lv_Debug = 'Y'
3804: END IF; -- lv_vat_invoice_number IS NOT NULL
3805: END IF; -- lv_party_has_changed
3806: ELSE -- single invoice number is false

Line 3814: Fnd_File.PUT_LINE(Fnd_File.LOG, 'In the Else when p_single_invoice is not Y ');

3810: table JAI_RGM_INVOICE_GEN_T (vat_invoice_no => lv_vat_invoice_number,
3811: vat_inv_gen_status => 'C');
3812: */
3813: IF lv_Debug = 'Y' THEN
3814: Fnd_File.PUT_LINE(Fnd_File.LOG, 'In the Else when p_single_invoice is not Y ');
3815: END IF;
3816: /*
3817: || This is the Else Part of the IF p_single_invoice_num = 'Y' THEN
3818: || In this comes the code that is needed for different generating vat invoice number for every delivery

Line 3821: Fnd_File.PUT_LINE(Fnd_File.LOG, '+++ before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number In the Else when p_single_invoice is not Y with order type = '

3817: || This is the Else Part of the IF p_single_invoice_num = 'Y' THEN
3818: || In this comes the code that is needed for different generating vat invoice number for every delivery
3819: */
3820: IF lv_Debug = 'Y' THEN
3821: Fnd_File.PUT_LINE(Fnd_File.LOG, '+++ before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number In the Else when p_single_invoice is not Y with order type = '
3822: || ln_order_type_id || ' +++ ' );
3823:
3824: Fnd_File.PUT_LINE(Fnd_File.LOG, '0 ' || ln_regime_id || ' ' ||
3825: mainrec.organization_id || ' ' || mainrec.location_id || ' ' ||

Line 3824: Fnd_File.PUT_LINE(Fnd_File.LOG, '0 ' || ln_regime_id || ' ' ||

3820: IF lv_Debug = 'Y' THEN
3821: Fnd_File.PUT_LINE(Fnd_File.LOG, '+++ before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number In the Else when p_single_invoice is not Y with order type = '
3822: || ln_order_type_id || ' +++ ' );
3823:
3824: Fnd_File.PUT_LINE(Fnd_File.LOG, '0 ' || ln_regime_id || ' ' ||
3825: mainrec.organization_id || ' ' || mainrec.location_id || ' ' ||
3826: mainrec.delivery_date || '' || ln_order_type_id || ' ' ||
3827: lv_vat_invoice_number || ' ' || lv_inv_gen_process_flag || ' ' ||
3828: lv_inv_gen_process_message ) ;

Line 3842: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ after call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number In the Else when p_single_invoice is not Y with lv_vat_invoice_number = '

3838: , p_process_flag => lv_inv_gen_process_flag
3839: , p_process_msg => lv_inv_gen_process_message
3840: );
3841: IF lv_Debug = 'Y' THEN
3842: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ after call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number In the Else when p_single_invoice is not Y with lv_vat_invoice_number = '
3843: || lv_vat_invoice_number || '+++');
3844: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ after call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with lv_inv_gen_process_flag = '
3845: || lv_inv_gen_process_flag || 'lv_inv_gen_process_message '|| lv_inv_gen_process_message || '+++');
3846: END IF; -- lv_Debug = 'Y'

Line 3844: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ after call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with lv_inv_gen_process_flag = '

3840: );
3841: IF lv_Debug = 'Y' THEN
3842: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ after call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number In the Else when p_single_invoice is not Y with lv_vat_invoice_number = '
3843: || lv_vat_invoice_number || '+++');
3844: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ after call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with lv_inv_gen_process_flag = '
3845: || lv_inv_gen_process_flag || 'lv_inv_gen_process_message '|| lv_inv_gen_process_message || '+++');
3846: END IF; -- lv_Debug = 'Y'
3847: IF lv_inv_gen_process_flag = jai_constants.successful
3848: THEN

Line 3910: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_Same_invoice_no = Y , Hence we need not call inv num generation routine - using excise inv num instead');

3906: -- if same_as_excise flag is 'Y', use excise invoice number of first fetched delivery line as vat invoice number
3907: IF NVL(lv_Same_invoice_no,jai_constants.no) = jai_constants.yes --same as excise
3908: THEN
3909: IF lv_debug = 'Y' THEN
3910: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_Same_invoice_no = Y , Hence we need not call inv num generation routine - using excise inv num instead');
3911: END IF; -- lv_debug = 'Y'
3912:
3913: lv_excise_invoice_no := NULL;
3914: OPEN c_get_excise_from_shippable (mainrec.order_number);

Line 3921: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_excise_invoice_no is ' || NVL(lv_excise_invoice_no,'NULL'));

3917: ,ld_excise_invoice_date;
3918: CLOSE c_get_excise_from_shippable ;
3919:
3920: IF lv_debug = 'Y' THEN
3921: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_excise_invoice_no is ' || NVL(lv_excise_invoice_no,'NULL'));
3922: END IF; -- lv_debug = 'Y'
3923:
3924: IF lv_excise_invoice_no IS NOT NULL
3925: THEN

Line 3928: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Excise Invoice number - ' || lv_excise_invoice_no || ' Will be used as VAT Invoice number for non-shippable order line : ' || mainrec.order_line_id);

3924: IF lv_excise_invoice_no IS NOT NULL
3925: THEN
3926: -- Excise invoice number is not null - so the same excise invoice number needs to be used as VAT invoice number
3927: IF lv_debug = 'Y' THEN
3928: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Excise Invoice number - ' || lv_excise_invoice_no || ' Will be used as VAT Invoice number for non-shippable order line : ' || mainrec.order_line_id);
3929: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before updating jai_om_wsh_lines_all for ex inv num');
3930: END IF; -- lv_debug = 'Y'
3931:
3932: UPDATE JAI_OM_WSH_LINES_ALL

Line 3929: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before updating jai_om_wsh_lines_all for ex inv num');

3925: THEN
3926: -- Excise invoice number is not null - so the same excise invoice number needs to be used as VAT invoice number
3927: IF lv_debug = 'Y' THEN
3928: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Excise Invoice number - ' || lv_excise_invoice_no || ' Will be used as VAT Invoice number for non-shippable order line : ' || mainrec.order_line_id);
3929: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before updating jai_om_wsh_lines_all for ex inv num');
3930: END IF; -- lv_debug = 'Y'
3931:
3932: UPDATE JAI_OM_WSH_LINES_ALL
3933: SET vat_invoice_no = lv_excise_invoice_no

Line 3939: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before updating jai_rgm_invoice_gen_t for ex inv num');

3935: WHERE order_line_id = mainrec.order_line_id
3936: AND delivery_id IS NULL;
3937:
3938: IF lv_debug = 'Y' THEN
3939: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before updating jai_rgm_invoice_gen_t for ex inv num');
3940: END IF; -- lv_debug = 'Y'
3941:
3942: UPDATE JAI_RGM_INVOICE_GEN_T
3943: SET vat_invoice_no = lv_excise_invoice_no

Line 3954: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after updating jai_rgm_invoice_gen_t for ex inv num');

3950: , last_update_Date = sysdate
3951: WHERE order_line_id = mainrec.order_line_id;
3952:
3953: IF lv_debug = 'Y' THEN
3954: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after updating jai_rgm_invoice_gen_t for ex inv num');
3955: END IF;
3956:
3957: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;
3958:

Line 3960: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Before going to process accounting for generating accounting');

3956:
3957: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;
3958:
3959: IF lv_debug = 'Y' THEN
3960: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Before going to process accounting for generating accounting');
3961: END IF;
3962:
3963: lv_inv_gen_process_flag := jai_constants.successful;
3964: lv_inv_num_already_generated := jai_constants.value_true;

Line 3972: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);

3968:
3969: END IF; -- NVL(lv_Same_invoice_no,jai_constants.no) = jai_constants.yes
3970: */
3971:
3972: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);
3973: Fnd_File.PUT_LINE(Fnd_File.LOG, ' p_single_invoice_num :' || p_single_invoice_num);
3974:
3975: IF NVL(p_single_invoice_num,jai_constants.No) = jai_constants.yes -- single invoice number is true
3976: THEN

Line 3973: Fnd_File.PUT_LINE(Fnd_File.LOG, ' p_single_invoice_num :' || p_single_invoice_num);

3969: END IF; -- NVL(lv_Same_invoice_no,jai_constants.no) = jai_constants.yes
3970: */
3971:
3972: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);
3973: Fnd_File.PUT_LINE(Fnd_File.LOG, ' p_single_invoice_num :' || p_single_invoice_num);
3974:
3975: IF NVL(p_single_invoice_num,jai_constants.No) = jai_constants.yes -- single invoice number is true
3976: THEN
3977: IF NVL(lv_party_has_changed,jai_constants.value_false) = jai_constants.value_true -- party has changed

Line 3987: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);

3983: vat_inv_gen_status => 'C');
3984: */
3985: IF lv_Debug = 'Y'
3986: THEN
3987: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);
3988: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
3989: END IF; -- lv_Debug = 'Y'
3990: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
3991: THEN

Line 3988: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);

3984: */
3985: IF lv_Debug = 'Y'
3986: THEN
3987: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);
3988: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
3989: END IF; -- lv_Debug = 'Y'
3990: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
3991: THEN
3992: --IF lv_inv_num_already_generated = jai_constants.value_false

Line 3995: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with ln_order_type_id' || ln_order_type_id || 'date ' || mainrec.delivery_date );

3991: THEN
3992: --IF lv_inv_num_already_generated = jai_constants.value_false
3993: --THEN
3994: IF lv_Debug = 'Y' THEN
3995: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with ln_order_type_id' || ln_order_type_id || 'date ' || mainrec.delivery_date );
3996: END IF; -- lv_Debug = 'Y'
3997: jai_cmn_rgm_setup_pkg.Gen_Invoice_number( p_regime_id => ln_regime_id
3998: , p_organization_id => mainrec.organization_id
3999: , p_location_id => mainrec.location_id

Line 4008: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after call with lv_vat_invoice_number:' || lv_vat_invoice_number || lv_inv_gen_process_flag ||lv_inv_gen_process_message);

4004: , p_process_flag => lv_inv_gen_process_flag
4005: , p_process_msg => lv_inv_gen_process_message
4006: );
4007: IF lv_Debug = 'Y' THEN
4008: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after call with lv_vat_invoice_number:' || lv_vat_invoice_number || lv_inv_gen_process_flag ||lv_inv_gen_process_message);
4009: END IF; -- lv_Debug = 'Y'
4010:
4011: -- check the return status and update the JAI_OM_WSH_LINES_ALL table to set the vat invoice number
4012: IF lv_inv_gen_process_flag = jai_constants.successful

Line 4086: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_order_has_changed :' || lv_order_has_changed);

4082: vat_inv_gen_status => 'C');
4083: */
4084: IF lv_Debug = 'Y'
4085: THEN
4086: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_order_has_changed :' || lv_order_has_changed);
4087: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
4088: END IF; -- lv_Debug = 'Y'
4089: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
4090: THEN

Line 4087: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);

4083: */
4084: IF lv_Debug = 'Y'
4085: THEN
4086: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_order_has_changed :' || lv_order_has_changed);
4087: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
4088: END IF; -- lv_Debug = 'Y'
4089: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
4090: THEN
4091: --IF lv_inv_num_already_generated = jai_constants.value_false

Line 4094: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with ln_order_type_id' || ln_order_type_id || 'date ' || mainrec.delivery_date );

4090: THEN
4091: --IF lv_inv_num_already_generated = jai_constants.value_false
4092: --THEN
4093: IF lv_Debug = 'Y' THEN
4094: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with ln_order_type_id' || ln_order_type_id || 'date ' || mainrec.delivery_date );
4095: END IF; -- lv_Debug = 'Y'
4096: jai_cmn_rgm_setup_pkg.Gen_Invoice_number( p_regime_id => ln_regime_id
4097: , p_organization_id => mainrec.organization_id
4098: , p_location_id => mainrec.location_id

Line 4107: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after call with lv_vat_invoice_number:' || lv_vat_invoice_number || lv_inv_gen_process_flag ||lv_inv_gen_process_message);

4103: , p_process_flag => lv_inv_gen_process_flag
4104: , p_process_msg => lv_inv_gen_process_message
4105: );
4106: IF lv_Debug = 'Y' THEN
4107: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after call with lv_vat_invoice_number:' || lv_vat_invoice_number || lv_inv_gen_process_flag ||lv_inv_gen_process_message);
4108: END IF; -- lv_Debug = 'Y'
4109:
4110: -- check the return status and update the JAI_OM_WSH_LINES_ALL table to set the vat invoice number
4111: IF lv_inv_gen_process_flag = jai_constants.successful

Line 4182: Fnd_File.PUT_LINE(Fnd_File.LOG, ' In process accounting section with p_process_action = ' || p_process_action);

4178:
4179: <>
4180:
4181: IF lv_debug = 'Y' THEN
4182: Fnd_File.PUT_LINE(Fnd_File.LOG, ' In process accounting section with p_process_action = ' || p_process_action);
4183: END IF;
4184:
4185: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt,jai_constants.om_action_gen_accounting) THEN
4186: /*

Line 4191: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.vat_acct_status : ' || mainrec.vat_acct_status || ' lv_inv_gen_process_flag : ' || lv_inv_gen_process_flag );

4187: || Only In case the parameter p_process_action in ('PROCESS ALL','PROCESS ACCOUNTING') AND
4188: ||
4189: */
4190: IF lv_Debug = 'Y' THEN
4191: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.vat_acct_status : ' || mainrec.vat_acct_status || ' lv_inv_gen_process_flag : ' || lv_inv_gen_process_flag );
4192: END IF;
4193: IF mainrec.vat_acct_status = 'C' THEN
4194: GOTO NEXTDELIVERY;
4195: END IF;

Line 4197: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_gen_process_flag = ' || lv_inv_gen_process_flag );

4193: IF mainrec.vat_acct_status = 'C' THEN
4194: GOTO NEXTDELIVERY;
4195: END IF;
4196: IF lv_Debug = 'Y' THEN
4197: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_gen_process_flag = ' || lv_inv_gen_process_flag );
4198: END IF;
4199: IF lv_inv_gen_process_flag = jai_constants.successful THEN
4200:
4201: IF lv_vat_invoice_number IS NULL THEN

Line 4211: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Before Call to jai_cmn_rgm_vat_accnt_pkg.process_order_invoice ');

4207: lv_vat_invoice_number := mainrec.vat_invoice_no;
4208: END IF;
4209:
4210: IF lv_Debug = 'Y' THEN
4211: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Before Call to jai_cmn_rgm_vat_accnt_pkg.process_order_invoice ');
4212: END IF;
4213: jai_cmn_rgm_vat_accnt_pkg.process_order_invoice(
4214: P_REGIME_ID => ln_regime_id ,
4215: -- modified by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin

Line 4236: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after Call to jai_cmn_rgm_vat_accnt_pkg.process_order_invoice with status = ' || lv_acct_process_flag);

4232: P_PROCESS_FLAG => lv_acct_process_flag ,
4233: P_PROCESS_MESSAGE => lv_acct_process_message
4234: );
4235: IF lv_Debug = 'Y' THEN
4236: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after Call to jai_cmn_rgm_vat_accnt_pkg.process_order_invoice with status = ' || lv_acct_process_flag);
4237: END IF;
4238: IF lv_acct_process_flag = jai_constants.successful THEN
4239: /*
4240: || If the control comes here it means that Accounting got processed successfully.

Line 4266: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered after call to process_order_invoice is ' || lv_acct_process_message);

4262: COMMIT;
4263: END IF;
4264: ELSE
4265: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
4266: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered after call to process_order_invoice is ' || lv_acct_process_message);
4267: END IF;
4268:
4269: IF lv_inv_gen_process_flag <> jai_constants.successful OR lv_acct_process_flag <> jai_constants.successful THEN
4270:

Line 4328: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ Number of Successful deliveries : ' || ln_success_delivery_Ctr || '+++');

4324: /*
4325: || Coding here to mark the status of the concurrent and generating statictics.
4326: ||
4327: */
4328: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ Number of Successful deliveries : ' || ln_success_delivery_Ctr || '+++');
4329: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ Number of Failed deliveries : ' || ln_failure_delivery_ctr || '+++');
4330:
4331: IF ln_failure_delivery_ctr > 0 AND ln_success_delivery_Ctr > 0 then
4332: /*

Line 4329: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ Number of Failed deliveries : ' || ln_failure_delivery_ctr || '+++');

4325: || Coding here to mark the status of the concurrent and generating statictics.
4326: ||
4327: */
4328: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ Number of Successful deliveries : ' || ln_success_delivery_Ctr || '+++');
4329: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ Number of Failed deliveries : ' || ln_failure_delivery_ctr || '+++');
4330:
4331: IF ln_failure_delivery_ctr > 0 AND ln_success_delivery_Ctr > 0 then
4332: /*
4333: || Atleast one delivery failed Atleast one delivery Succeeded

Line 4378: Fnd_File.PUT_LINE(Fnd_File.LOG, lv_same_as_excise_conf_warning);

4374: THEN
4375: lv_same_as_excise_conf_warning := '"Generate Single Invoice" is applicable only when "VAT invoice number same as Excise invoice number" is set as No.';
4376: -- added by Allen Yang for bug 9737119, begin
4377: -------------------------------------------------
4378: Fnd_File.PUT_LINE(Fnd_File.LOG, lv_same_as_excise_conf_warning);
4379: -------------------------------------------------
4380: -- added by Allen Yang for bug 9737119, end
4381: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', lv_same_as_excise_conf_warning);
4382: retcode := '1';

Line 4392: Fnd_File.PUT_LINE(Fnd_File.LOG,'Unexpected Error occured in procedure jai_cmn_rgm_processing_pkg.process '||substr(sqlerrm,1,300));

4388:
4389: EXCEPTION
4390: WHEN OTHERS THEN
4391: RETCODE := '2';
4392: Fnd_File.PUT_LINE(Fnd_File.LOG,'Unexpected Error occured in procedure jai_cmn_rgm_processing_pkg.process '||substr(sqlerrm,1,300));
4393: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',substr(sqlerrm,1,1000));
4394: ERRBUF := substr(sqlerrm,1,1000);
4395: lv_inv_gen_process_flag := jai_constants.unexpected_error;
4396: lv_acct_process_flag := jai_constants.unexpected_error;

Line 4942: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);

4938: p_process_flag => lv_process_flag,
4939: p_process_message => lv_process_message);
4940:
4941: IF lv_process_flag <> jai_constants.successful THEN
4942: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
4943: RETURN;
4944: END IF;
4945:
4946: OPEN c_get_curr_dtls(rec_ap_dist.invoice_id);

Line 4991: fnd_file.put_line( fnd_file.log,

4987:
4988:
4989: IF lv_process_flag = jai_constants.expected_error OR
4990: lv_process_flag = jai_constants.unexpected_error THEN
4991: fnd_file.put_line( fnd_file.log,
4992: '5.1 ERROR IN CALL TO jai_cmn_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag
4993: ||', lv_process_message'||lv_process_message);
4994: p_process_flag := lv_process_flag;
4995: p_process_message := lv_process_message;

Line 5028: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);

5024: p_process_flag => lv_process_flag,
5025: p_process_message => lv_process_message);
5026:
5027: IF lv_process_flag <> jai_constants.successful THEN
5028: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
5029: RETURN;
5030: END IF;
5031:
5032: OPEN c_get_curr_dtls(rec_ap_dist.invoice_id);

Line 5086: fnd_file.put_line( fnd_file.log,

5082: p_accrual_basis => 'Y');
5083:
5084: IF lv_process_flag = jai_constants.expected_error OR
5085: lv_process_flag = jai_constants.unexpected_error THEN
5086: fnd_file.put_line( fnd_file.log,
5087: '5.1 ERROR IN CALL TO jai_cmn_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag
5088: ||', lv_process_message'||lv_process_message);
5089: p_process_flag := lv_process_flag;
5090: p_process_message := lv_process_message;

Line 5110: FND_FILE.put_line(fnd_file.log, 'reversal enter1 reversal_trxn_rec.invoice_id:'||reversal_trxn_rec.invoice_id);

5106:
5107: OPEN c_get_curr_dtls(reversal_trxn_rec.invoice_id);
5108: FETCH c_get_curr_dtls INTO rec_get_curr_dtls;
5109: CLOSE c_get_curr_dtls;
5110: FND_FILE.put_line(fnd_file.log, 'reversal enter1 reversal_trxn_rec.invoice_id:'||reversal_trxn_rec.invoice_id);
5111: FND_FILE.put_line(fnd_file.log, 'reversal enter1 reversal_trxn_rec.line_num:'||reversal_trxn_rec.line_num);
5112: FOR rec_reversal_entries IN get_reversal_entries_cur(reversal_trxn_rec.invoice_id, reversal_trxn_rec.line_num)
5113: LOOP
5114: -- Added by Qiong for Reverse Charge code port bug16001407 begin

Line 5111: FND_FILE.put_line(fnd_file.log, 'reversal enter1 reversal_trxn_rec.line_num:'||reversal_trxn_rec.line_num);

5107: OPEN c_get_curr_dtls(reversal_trxn_rec.invoice_id);
5108: FETCH c_get_curr_dtls INTO rec_get_curr_dtls;
5109: CLOSE c_get_curr_dtls;
5110: FND_FILE.put_line(fnd_file.log, 'reversal enter1 reversal_trxn_rec.invoice_id:'||reversal_trxn_rec.invoice_id);
5111: FND_FILE.put_line(fnd_file.log, 'reversal enter1 reversal_trxn_rec.line_num:'||reversal_trxn_rec.line_num);
5112: FOR rec_reversal_entries IN get_reversal_entries_cur(reversal_trxn_rec.invoice_id, reversal_trxn_rec.line_num)
5113: LOOP
5114: -- Added by Qiong for Reverse Charge code port bug16001407 begin
5115: IF jai_cmn_reverse_charge_pkg.is_reverse_charge_dist(rec_reversal_entries.invoice_distribution_id)= 'Y' THEN

Line 5151: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);

5147: p_process_flag => lv_process_flag,
5148: p_process_message => lv_process_message);
5149:
5150: IF lv_process_flag <> jai_constants.successful THEN
5151: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
5152: RETURN;
5153: END IF;
5154:
5155: ln_tax_amount := rec_reversal_entries.tax_amt;

Line 5199: fnd_file.put_line( fnd_file.log,

5195: p_accrual_basis => 'Y');
5196:
5197: IF lv_process_flag = jai_constants.expected_error OR
5198: lv_process_flag = jai_constants.unexpected_error THEN
5199: fnd_file.put_line( fnd_file.log,
5200: '5.1 ERROR IN CALL TO jai_cmn_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag
5201: ||', lv_process_message'||lv_process_message);
5202: p_process_flag := lv_process_flag;
5203: p_process_message := lv_process_message;

Line 5255: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);

5251: p_process_flag => lv_process_flag,
5252: p_process_message => lv_process_message);
5253:
5254: IF lv_process_flag <> jai_constants.successful THEN
5255: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
5256: RETURN;
5257: END IF;
5258:
5259: ld_accounting_date := rec_claim_line.accounting_date;

Line 5302: fnd_file.put_line( fnd_file.log,

5298: p_accrual_basis => 'Y');
5299:
5300: IF lv_process_flag = jai_constants.expected_error OR
5301: lv_process_flag = jai_constants.unexpected_error THEN
5302: fnd_file.put_line( fnd_file.log,
5303: '5.1 ERROR IN CALL TO jai_cmn_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag
5304: ||', lv_process_message'||lv_process_message);
5305: p_process_flag := lv_process_flag;
5306: p_process_message := lv_process_message;