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 333: fnd_file.put_line(fnd_file.log,'AccntChkFail. InvId,LineNum,DisNum:'||r_dist.invoice_id||','

329: -- Following condition is true only if Invoice Distribution Accounting did not happen
330: IF r_dist.posted_flag IS NULL OR r_dist.posted_flag <> 'Y' THEN
331: lv_codepath := jai_general_pkg.plot_codepath(3, lv_codepath);
332: IF g_debug='Y' THEN
333: fnd_file.put_line(fnd_file.log,'AccntChkFail. InvId,LineNum,DisNum:'||r_dist.invoice_id||','
334: ||r_dist.invoice_line_number||','||r_dist.distribution_line_number);
335: END IF;
336: p_process_flag := jai_constants.not_accounted;
337: --p_process_message := 'Invoice is not accounted';

Line 358: 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;

354: p_process_flag := jai_constants.already_processed;
355: RETURN;
356: END IF;
357:
358: 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;
359:
360: OPEN c_rgm_repository_id(p_source, p_payment_table_name, p_payment_document_id, r_ref.reference_id);
361: FETCH c_rgm_repository_id INTO ln_rgm_reposotory_id;
362: CLOSE c_rgm_repository_id;

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

505:
506: END IF;
507:
508: IF g_debug = 'Y' THEN
509: FND_FILE.put_line(fnd_file.log, 'RecoAmt:'||ln_recovered_amount||', RefRecobleAmt:'||r_ref.recoverable_amount
510: ||', PaymtAmt:'||ln_payment_amount||', InvAmt:'||r_dist.invoice_amount||', DiscTaken:'||r_payment.discount_taken
511: ||', rPayAmt:'||r_payment.amount||', DiscRecoAmt:'||ln_discounted_amount);
512: END IF;
513:

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

540:
541: END IF;
542:
543: IF g_debug = 'Y' THEN
544: FND_FILE.put_line(fnd_file.log, 'DiffAmt:'||ln_diff_amount||', ValidtAmt:'||ln_validate_amount
545: ||', RecoAmt:'||ln_recovered_amount||', DiscRecoAmt:'||ln_discounted_amount);
546: END IF;
547:
548: IF ln_recovered_amount = 0 THEN

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

547:
548: IF ln_recovered_amount = 0 THEN
549: lv_codepath := jai_general_pkg.plot_codepath(26, lv_codepath);
550: IF g_debug='Y' THEN
551: fnd_file.put_line(fnd_file.log,'Allready amount is recovered');
552: END IF;
553: RETURN;
554: END IF;
555: /*Bug 5879769 bduvarag start*/

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

565: );
566:
567: IF lv_process_flag <> jai_constants.successful THEN
568: lv_codepath := jai_general_pkg.plot_codepath(27.1, lv_codepath);
569: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
570: return;
571: END IF;
572: /*Bug 5879769 bduvarag End*/
573: lv_codepath := jai_general_pkg.plot_codepath(27, lv_codepath);

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

629: <>
630: lv_codepath := jai_general_pkg.plot_codepath(49, lv_codepath, 'PROCESS_PAYMENT', 'END');
631:
632: IF g_debug = 'Y' THEN
633: FND_FILE.put_line( fnd_file.log, 'Codepath:'||lv_codepath);
634: END IF;
635:
636: EXCEPTION
637: WHEN OTHERS THEN

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

636: EXCEPTION
637: WHEN OTHERS THEN
638: p_process_flag := jai_constants.unexpected_error;
639: p_process_message := 'Process Payment Error:'||SQLERRM;
640: FND_FILE.put_line( fnd_file.log, p_process_message);
641: FND_FILE.put_line( fnd_file.log, 'Error Codepath:'||lv_codepath);
642:
643: END process_payment;
644:

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

637: WHEN OTHERS THEN
638: p_process_flag := jai_constants.unexpected_error;
639: p_process_message := 'Process Payment Error:'||SQLERRM;
640: FND_FILE.put_line( fnd_file.log, p_process_message);
641: FND_FILE.put_line( fnd_file.log, 'Error Codepath:'||lv_codepath);
642:
643: END process_payment;
644:
645: ---------------------------- PROCESS_BATCH ---------------------------

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

698:
699: p_trx_from_date := fnd_date.canonical_to_date(pv_trx_from_date); --File.Sql.35 by Brathod
700: p_trx_till_date := fnd_date.canonical_to_date(pv_trx_till_date); --File.Sql.35 by Brathod
701:
702: FND_FILE.put_line(fnd_file.log,'Value of from date is '||p_trx_from_date);
703: FND_FILE.put_line(fnd_file.log,'Value of from date is '||p_trx_till_date);
704:
705:
706: g_debug := p_debug;

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

699: p_trx_from_date := fnd_date.canonical_to_date(pv_trx_from_date); --File.Sql.35 by Brathod
700: p_trx_till_date := fnd_date.canonical_to_date(pv_trx_till_date); --File.Sql.35 by Brathod
701:
702: FND_FILE.put_line(fnd_file.log,'Value of from date is '||p_trx_from_date);
703: FND_FILE.put_line(fnd_file.log,'Value of from date is '||p_trx_till_date);
704:
705:
706: g_debug := p_debug;
707: g_debug := 'Y';

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

706: g_debug := p_debug;
707: g_debug := 'Y';
708:
709: IF p_debug = 'Y' THEN
710: fnd_file.put_line(fnd_file.log, 'Enter1');
711: END IF;
712:
713: /*
714: OPEN c_previous_batch_dtls(p_regime_id, p_rgm_registration_num);

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

733: CLOSE c_rgm_effective_from_date;
734:
735: IF p_trx_from_date < ld_rgm_effective_from THEN
736:
737: FND_FILE.put_line(fnd_file.log, 'Start Date('||to_char(p_trx_from_Date,'DD-MON-YYYY')
738: ||') of Transaction Processing cannot be less than Regime Effective Date('||to_char(ld_rgm_effective_from,'DD-MON-YYYY')||')'
739: );
740: retcode := jai_constants.request_error;
741:

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

753: CLOSE cur_fetch_ou;
754: /* ends additions by ssumaith - bug#6109941*/
755:
756: /*Added by nprashar for bug # 6636517*/
757: fnd_file.put_line(fnd_file.log,'P_organization_type :' || jai_constants.orgn_type_io);
758: fnd_file.put_line(fnd_file.log,'P_organization_id :' ||ln_org_id);
759: fnd_file.put_line(fnd_file.log,'P_Location_id :' ||loop_io.location_id); /*Ends here for bug #6636517*/
760: /***************** Processing of AP Start Here *********************/
761: process_payments(

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

754: /* ends additions by ssumaith - bug#6109941*/
755:
756: /*Added by nprashar for bug # 6636517*/
757: fnd_file.put_line(fnd_file.log,'P_organization_type :' || jai_constants.orgn_type_io);
758: fnd_file.put_line(fnd_file.log,'P_organization_id :' ||ln_org_id);
759: fnd_file.put_line(fnd_file.log,'P_Location_id :' ||loop_io.location_id); /*Ends here for bug #6636517*/
760: /***************** Processing of AP Start Here *********************/
761: process_payments(
762: p_regime_id => p_regime_id,

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

755:
756: /*Added by nprashar for bug # 6636517*/
757: fnd_file.put_line(fnd_file.log,'P_organization_type :' || jai_constants.orgn_type_io);
758: fnd_file.put_line(fnd_file.log,'P_organization_id :' ||ln_org_id);
759: fnd_file.put_line(fnd_file.log,'P_Location_id :' ||loop_io.location_id); /*Ends here for bug #6636517*/
760: /***************** Processing of AP Start Here *********************/
761: process_payments(
762: p_regime_id => p_regime_id,
763: p_organization_type => jai_constants.orgn_type_io, /* ssumaith - bug# 6109941 */

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

796:
797: <>
798:
799: IF lv_process_flag IN (jai_constants.expected_error, jai_constants.unexpected_error) THEN
800: FND_FILE.put_line( FND_FILE.log, 'Problem Message:'||lv_process_message);
801: fnd_file.put_line(fnd_file.log,'Problem Message:'||lv_process_message);
802: retcode := jai_constants.request_warning;
803: errbuf := lv_process_message;
804: END IF;

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

797: <>
798:
799: IF lv_process_flag IN (jai_constants.expected_error, jai_constants.unexpected_error) THEN
800: FND_FILE.put_line( FND_FILE.log, 'Problem Message:'||lv_process_message);
801: fnd_file.put_line(fnd_file.log,'Problem Message:'||lv_process_message);
802: retcode := jai_constants.request_warning;
803: errbuf := lv_process_message;
804: END IF;
805:

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

810: WHEN OTHERS THEN
811: ROLLBACK;
812: retcode := jai_constants.request_error;
813: errbuf := 'Unexpected Error Occured:'||SQLERRM;
814: FND_FILE.put_line( fnd_file.log, 'Unexpected Error Occured:'||SQLERRM);
815:
816: END process_batch;
817:
818: PROCEDURE process_payments(

Line 1141: 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/

1137: (p_org_id => p_org_id );
1138: ln_sob_id := l_func_curr_det.ledger_id;
1139:
1140:
1141: 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*/
1142:
1143: -- this is required for to rollback the changes made in this procedure incase any unexpected error
1144: -- SAVEPOINT start_payments;
1145:

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

1148: -- if the invoice is cancelled, then no references are populated so that the lines are not processed against any
1149: -- Payements/Voids that are present for this invoice
1150: 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*/
1151:
1152: IF p_debug = 'Y' THEN fnd_file.put_line(fnd_file.log, 'Enter3 - ap_event_id:'||ap_acc_dist.accounting_event_id); END IF;
1153:
1154: --Bug 4991017. Added by Lakshmi gopalsami
1155: -- Removed the FOR.. LOOP dist.
1156:

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

1153:
1154: --Bug 4991017. Added by Lakshmi gopalsami
1155: -- Removed the FOR.. LOOP dist.
1156:
1157: IF p_debug = 'Y' THEN fnd_file.put_line(fnd_file.log, 'Enter4 - invid:'||ap_acc_dist.invoice_id
1158: ||', LineNum:'||ap_acc_dist.invoice_line_number ||',distid:'||ap_acc_dist.distribution_line_number); END IF;
1159:
1160: -- Initialization Point
1161: ln_reference_id := null;

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

1173:
1174: -- following condition is satisfied if the invoice line is already inserted into REFERENCEs table
1175: IF r_ref.reference_id IS NOT NULL THEN
1176: IF p_debug = 'Y' THEN
1177: fnd_file.put_line(fnd_file.log, 'Enter5 - Return Ref NotNull');
1178: END IF;
1179: GOTO end_of_reference_insertion;
1180: END IF;
1181:

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

1217: END IF;
1218:
1219: IF nvl(r_tax_dist_dtl.chk, 0) = 0 THEN
1220: IF p_debug = 'Y' THEN
1221: fnd_file.put_line(fnd_file.log, 'Enter6 - DistChk is 0');
1222: END IF;
1223:
1224: GOTO end_of_reference_insertion;
1225: END IF;

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

1225: END IF;
1226:
1227: IF r_tax_dist_dtl.recoverable_ptg = 0 THEN
1228: IF p_debug = 'Y' THEN
1229: fnd_file.put_line(fnd_file.log, 'Enter7 - recov_ptg is 0');
1230: END IF;
1231: FND_FILE.put_line( FND_FILE.log, 'Invoice_id, LineNum, DistNum->'||ap_acc_dist.invoice_id
1232: ||','||ap_acc_dist.invoice_line_number||','||ap_acc_dist.distribution_line_number||' is not Recoverable');
1233: GOTO end_of_reference_insertion;

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

1227: IF r_tax_dist_dtl.recoverable_ptg = 0 THEN
1228: IF p_debug = 'Y' THEN
1229: fnd_file.put_line(fnd_file.log, 'Enter7 - recov_ptg is 0');
1230: END IF;
1231: FND_FILE.put_line( FND_FILE.log, 'Invoice_id, LineNum, DistNum->'||ap_acc_dist.invoice_id
1232: ||','||ap_acc_dist.invoice_line_number||','||ap_acc_dist.distribution_line_number||' is not Recoverable');
1233: GOTO end_of_reference_insertion;
1234: END IF;
1235:

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

1309: COMMIT;
1310: ln_uncommited_trxs := 0;
1311: END IF;
1312:
1313: IF p_debug = 'Y' THEN fnd_file.put_line(fnd_file.log, 'Enter8 - Inserted Reference:'||ln_reference_id); END IF;
1314:
1315: <>
1316: NULL;
1317:

Line 1421: 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;

1417: */
1418: FOR inv_payment IN c_period_payments( p_trx_from_date, p_trx_to_date) LOOP
1419: lv_process_flag := null;
1420:
1421: 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;
1422:
1423: SAVEPOINT process_payment;
1424:
1425: process_payment(

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

1497: -- retcode := jai_constants.request_error;
1498: -- errbuf := 'Unexpected Error Occured:'||SQLERRM;
1499: p_process_flag := jai_constants.unexpected_error;
1500: p_process_message := 'Unexpected Error Occured in Process_Payments:'||SQLERRM;
1501: FND_FILE.put_line( fnd_file.log, 'Unexpected Error Occured:'||p_process_message);
1502:
1503: END process_payments;
1504:
1505: /*

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

1620:
1621: Fix :
1622: -----
1623: 1.The issue has been fixed by adding the p_registration_num and p_Regime_id in the where clause.
1624: 2.As the returning clause was not required and hence was removed. Also added the fnd_file log in
1625: the exception section of the procedure.
1626:
1627: Dependency due to this bug:-
1628: None

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

1770: lv_debug := NVL(P_DEBUG,jai_constants.no);
1771: ln_current_party_id := -9999;
1772: ln_current_party_site_id := -9999;
1773: IF lv_debug = 'Y' THEN
1774: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1. Entered in the proc with parameters :');
1775: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGIME_ID :' || P_REGIME_ID);
1776: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGISTRATION_NUM :' || P_REGISTRATION_NUM);
1777: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
1778: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);

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

1771: ln_current_party_id := -9999;
1772: ln_current_party_site_id := -9999;
1773: IF lv_debug = 'Y' THEN
1774: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1. Entered in the proc with parameters :');
1775: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGIME_ID :' || P_REGIME_ID);
1776: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGISTRATION_NUM :' || P_REGISTRATION_NUM);
1777: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
1778: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
1779: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);

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

1772: ln_current_party_site_id := -9999;
1773: IF lv_debug = 'Y' THEN
1774: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1. Entered in the proc with parameters :');
1775: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGIME_ID :' || P_REGIME_ID);
1776: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGISTRATION_NUM :' || P_REGISTRATION_NUM);
1777: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
1778: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
1779: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
1780: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);

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

1773: IF lv_debug = 'Y' THEN
1774: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1. Entered in the proc with parameters :');
1775: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGIME_ID :' || P_REGIME_ID);
1776: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGISTRATION_NUM :' || P_REGISTRATION_NUM);
1777: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
1778: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
1779: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
1780: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
1781: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);

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

1774: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1. Entered in the proc with parameters :');
1775: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGIME_ID :' || P_REGIME_ID);
1776: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGISTRATION_NUM :' || P_REGISTRATION_NUM);
1777: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
1778: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
1779: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
1780: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
1781: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
1782: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);

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

1775: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGIME_ID :' || P_REGIME_ID);
1776: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGISTRATION_NUM :' || P_REGISTRATION_NUM);
1777: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
1778: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
1779: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
1780: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
1781: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
1782: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
1783: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);

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

1776: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_REGISTRATION_NUM :' || P_REGISTRATION_NUM);
1777: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
1778: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
1779: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
1780: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
1781: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
1782: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
1783: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
1784: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);

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

1777: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
1778: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
1779: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
1780: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
1781: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
1782: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
1783: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
1784: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
1785: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);

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

1778: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
1779: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
1780: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
1781: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
1782: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
1783: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
1784: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
1785: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
1786: END IF;

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

1779: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
1780: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
1781: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
1782: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
1783: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
1784: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
1785: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
1786: END IF;
1787: ln_conc_progam_id := FND_GLOBAL.conc_program_id;

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

1780: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
1781: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
1782: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
1783: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
1784: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
1785: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
1786: END IF;
1787: ln_conc_progam_id := FND_GLOBAL.conc_program_id;
1788: ln_conc_request_id := FND_GLOBAL.conc_request_id;

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

1781: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
1782: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
1783: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
1784: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
1785: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
1786: END IF;
1787: ln_conc_progam_id := FND_GLOBAL.conc_program_id;
1788: ln_conc_request_id := FND_GLOBAL.conc_request_id;
1789: ln_conc_prog_appl_id := FND_GLOBAL.prog_appl_id;

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

1797: ln_success_delivery_Ctr :=0;
1798: ln_interface_status :=0; /*added by srjayara for bug 4702156*/
1799:
1800: IF P_PROCESS_ACTION IS NULL THEN
1801: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ P_PROCESS_ACTION parameter IS NULL Hence returning +++ ' );
1802: RETURN;
1803: END IF;
1804:
1805: FOR mainrec IN

Line 1839: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Delivery - ' || mainrec.delivery_id || ' Cannot be processed because all delivery details are not inventory interfaced');

1835: FETCH c_check_interface_status into ln_interface_status;
1836: CLOSE c_check_interface_status;
1837:
1838: IF ln_interface_status = 1 then
1839: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Delivery - ' || mainrec.delivery_id || ' Cannot be processed because all delivery details are not inventory interfaced');
1840: /* removed the return and instead making the control process the next delivery by issueing a goto stmt
1841: ssumaith - bug#6147385
1842: */
1843: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;

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

1846:
1847: /*end bug 4702156*/
1848:
1849: IF lv_debug = 'Y' THEN
1850: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Processing Delivery - ' || mainrec.delivery_id);
1851: END IF;
1852:
1853: OPEN c_regime_cur(trunc(mainrec.delivery_date));
1854: FETCH c_regime_cur into ln_regime_id;

Line 1882: 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');

1878:
1879: IF NVL(lv_Same_invoice_no,jai_constants.no) = jai_constants.yes THEN
1880:
1881: IF lv_debug = 'Y' THEN
1882: 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');
1883: END IF;
1884: ln_excise_invoice_not_done := NULL; --added by csahoo for bug#6176277
1885: OPEN c_excise_invoice_not_done (mainrec.delivery_id);
1886: FETCH c_excise_invoice_not_done INTO ln_excise_invoice_not_done;

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

1886: FETCH c_excise_invoice_not_done INTO ln_excise_invoice_not_done;
1887: CLOSE c_excise_invoice_not_done ;
1888:
1889: IF lv_debug = 'Y' THEN
1890: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_excise_invoice_not_done = ' || NVL(ln_excise_invoice_not_done,-1));
1891: END IF;
1892:
1893: IF ln_excise_invoice_not_done IS NULL THEN
1894: /*

Line 1913: 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 : '

1909:
1910: /*
1911: || Not using the debug flag for the following message because it needs to be shown to the user irrespective of debug flag.
1912: */
1913: 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 : '
1914: || mainrec.delivery_id);
1915:
1916: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
1917: goto NEXTDELIVERY;

Line 1937: 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);

1933: || Excise invoice number is not null - so the same excise invoice number needs to be used as VAT invoice number
1934: */
1935:
1936: IF lv_debug = 'Y' THEN
1937: 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);
1938: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before updating jai_om_wsh_lines_all for ex inv num');
1939: END IF;
1940:
1941: /*

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

1934: */
1935:
1936: IF lv_debug = 'Y' THEN
1937: 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);
1938: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before updating jai_om_wsh_lines_all for ex inv num');
1939: END IF;
1940:
1941: /*
1942: || Code added by aiyer for the Bug 4534166 (fixed as a part of the bug 4523205)

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

1947: vat_invoice_date = excise_invoice_date
1948: WHERE delivery_id = mainrec.delivery_id;
1949:
1950: IF lv_debug = 'Y' THEN
1951: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before updating jai_rgm_invoice_gen_t for ex inv num');
1952: END IF;
1953:
1954: UPDATE JAI_RGM_INVOICE_GEN_T
1955: SET vat_invoice_no = lv_vat_invoice_number ,

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

1964: WHERE Delivery_id = mainrec.delivery_id;
1965:
1966:
1967: IF lv_debug = 'Y' THEN
1968: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after updating jai_rgm_invoice_gen_t for ex inv num');
1969: END IF;
1970:
1971: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;
1972:

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

1970:
1971: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;
1972:
1973: IF lv_debug = 'Y' THEN
1974: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Before going to process accounting for generating accounting');
1975: END IF;
1976: lv_inv_gen_process_flag := jai_constants.successful; /*ssumaith bug# 6176277 */
1977:
1978: GOTO Processaccounting;

Line 1986: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 2. In the Loop');

1982:
1983: END IF;
1984:
1985: IF lv_debug = 'Y' THEN
1986: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 2. In the Loop');
1987: END IF;
1988:
1989: /*
1990: || Check if we need to generate vat invoice number and within that check if an invoice number is already generated.

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

2001: lv_doc_type_class :='UO'; /*made it to UO from VO */
2002: end if;
2003:
2004: IF lv_Debug = 'Y' THEN
2005: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_id : ' || ln_current_party_id);
2006: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_id : ' || mainrec.party_id);
2007: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);
2008: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);
2009: Fnd_File.PUT_LINE(Fnd_File.LOG, 'lv_doc_type_class:' || lv_doc_type_class);--kunkumar for 5233925

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

2002: end if;
2003:
2004: IF lv_Debug = 'Y' THEN
2005: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_id : ' || ln_current_party_id);
2006: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_id : ' || mainrec.party_id);
2007: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);
2008: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);
2009: Fnd_File.PUT_LINE(Fnd_File.LOG, 'lv_doc_type_class:' || lv_doc_type_class);--kunkumar for 5233925
2010: END IF;

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

2003:
2004: IF lv_Debug = 'Y' THEN
2005: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_id : ' || ln_current_party_id);
2006: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_id : ' || mainrec.party_id);
2007: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);
2008: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);
2009: Fnd_File.PUT_LINE(Fnd_File.LOG, 'lv_doc_type_class:' || lv_doc_type_class);--kunkumar for 5233925
2010: END IF;
2011:

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

2004: IF lv_Debug = 'Y' THEN
2005: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_id : ' || ln_current_party_id);
2006: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_id : ' || mainrec.party_id);
2007: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);
2008: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);
2009: Fnd_File.PUT_LINE(Fnd_File.LOG, 'lv_doc_type_class:' || lv_doc_type_class);--kunkumar for 5233925
2010: END IF;
2011:
2012: IF ln_current_party_id <> mainrec.party_id OR ln_current_party_site_id <> mainrec.party_site_id THEN

Line 2009: Fnd_File.PUT_LINE(Fnd_File.LOG, 'lv_doc_type_class:' || lv_doc_type_class);--kunkumar for 5233925

2005: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_id : ' || ln_current_party_id);
2006: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_id : ' || mainrec.party_id);
2007: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);
2008: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);
2009: Fnd_File.PUT_LINE(Fnd_File.LOG, 'lv_doc_type_class:' || lv_doc_type_class);--kunkumar for 5233925
2010: END IF;
2011:
2012: IF ln_current_party_id <> mainrec.party_id OR ln_current_party_site_id <> mainrec.party_site_id THEN
2013: /*

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

2021: lv_party_has_changed := jai_constants.value_false;
2022: END IF;
2023:
2024: IF lv_Debug = 'Y' THEN
2025: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);
2026: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
2027: END IF;
2028:
2029: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice) THEN

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

2022: END IF;
2023:
2024: IF lv_Debug = 'Y' THEN
2025: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);
2026: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
2027: END IF;
2028:
2029: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice) THEN
2030: IF NVL(p_single_invoice_num,jai_constants.No) = jai_constants.yes THEN

Line 2033: 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 );

2029: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice) THEN
2030: IF NVL(p_single_invoice_num,jai_constants.No) = jai_constants.yes THEN
2031: IF lv_inv_num_already_generated = jai_constants.value_false AND lv_party_has_changed = jai_constants.value_true THEN
2032: IF lv_Debug = 'Y' THEN
2033: 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 );
2034: END IF;
2035: jai_cmn_rgm_setup_pkg.Gen_Invoice_number(
2036: p_regime_id => ln_regime_id ,
2037: p_organization_id => mainrec.organization_id ,

Line 2047: 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);

2043: p_process_flag => lv_inv_gen_process_flag ,
2044: p_process_msg => lv_inv_gen_process_message
2045: );
2046: IF lv_Debug = 'Y' THEN
2047: 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);
2048: END IF;
2049: /*
2050: check the return status and update the JAI_OM_WSH_LINES_ALL table to set the vat invoice number
2051: */

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

2125: END IF;
2126: END IF;
2127: ELSE
2128: IF lv_Debug = 'Y' THEN
2129: Fnd_File.PUT_LINE(Fnd_File.LOG, 'In the Else when p_single_invoice is not Y ');
2130: END IF;
2131: /*
2132: || This is the Else Part of the IF p_single_invoice_num = 'Y' THEN
2133: || In this comes the code that is needed for different generating vat invoice number for every delivery

Line 2136: 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 = '

2132: || This is the Else Part of the IF p_single_invoice_num = 'Y' THEN
2133: || In this comes the code that is needed for different generating vat invoice number for every delivery
2134: */
2135: IF lv_Debug = 'Y' THEN
2136: 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 = '
2137: || ln_order_type_id || ' +++ ' );
2138:
2139: Fnd_File.PUT_LINE(Fnd_File.LOG, '0 ' || ln_regime_id || ' ' ||
2140: mainrec.organization_id || ' ' || mainrec.location_id || ' ' || mainrec.delivery_date || '' || ln_order_type_id ||

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

2135: IF lv_Debug = 'Y' THEN
2136: 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 = '
2137: || ln_order_type_id || ' +++ ' );
2138:
2139: Fnd_File.PUT_LINE(Fnd_File.LOG, '0 ' || ln_regime_id || ' ' ||
2140: mainrec.organization_id || ' ' || mainrec.location_id || ' ' || mainrec.delivery_date || '' || ln_order_type_id ||
2141: ' ' || lv_vat_invoice_number || ' ' || lv_inv_gen_process_flag || ' ' || lv_inv_gen_process_message ) ; -- test
2142:
2143: END IF;

Line 2156: 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 = '

2152: p_process_flag => lv_inv_gen_process_flag ,
2153: p_process_msg => lv_inv_gen_process_message
2154: );
2155: IF lv_Debug = 'Y' THEN
2156: 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 = '
2157: || lv_vat_invoice_number || '+++');
2158: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ after call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with lv_inv_gen_process_flag = '
2159: || lv_inv_gen_process_flag || 'lv_inv_gen_process_message '|| lv_inv_gen_process_message || '+++');
2160: END IF;

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

2154: );
2155: IF lv_Debug = 'Y' THEN
2156: 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 = '
2157: || lv_vat_invoice_number || '+++');
2158: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ after call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with lv_inv_gen_process_flag = '
2159: || lv_inv_gen_process_flag || 'lv_inv_gen_process_message '|| lv_inv_gen_process_message || '+++');
2160: END IF;
2161: IF lv_inv_gen_process_flag = jai_constants.successful THEN
2162: IF lv_vat_invoice_number IS NOT NULL THEN

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

2206: */
2207: <>
2208:
2209: IF lv_debug = 'Y' THEN
2210: Fnd_File.PUT_LINE(Fnd_File.LOG, ' In process accounting section with p_process_action = ' || p_process_action);
2211: END IF;
2212:
2213: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt,jai_constants.om_action_gen_accounting) THEN
2214: /*

Line 2219: 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 );

2215: || Only In case the parameter p_process_action in ('PROCESS ALL','PROCESS ACCOUNTING') AND
2216: ||
2217: */
2218: IF lv_Debug = 'Y' THEN
2219: 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 );
2220: END IF;
2221: IF mainrec.vat_acct_status = 'C' THEN
2222: GOTO NEXTDELIVERY;
2223: END IF;

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

2221: IF mainrec.vat_acct_status = 'C' THEN
2222: GOTO NEXTDELIVERY;
2223: END IF;
2224: IF lv_Debug = 'Y' THEN
2225: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_gen_process_flag = ' || lv_inv_gen_process_flag );
2226: END IF;
2227: IF lv_inv_gen_process_flag = jai_constants.successful THEN
2228:
2229: IF lv_vat_invoice_number IS NULL THEN

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

2234: lv_vat_invoice_number := mainrec.vat_invoice_no;
2235: END IF;
2236: --End Added by kunkumar for Bug#6012489
2237: IF lv_Debug = 'Y' THEN
2238: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Before Call to jai_cmn_rgm_vat_accnt_pkg.process_order_invoice ');
2239: END IF;
2240: jai_cmn_rgm_vat_accnt_pkg.process_order_invoice(
2241: P_REGIME_ID => ln_regime_id ,
2242: P_SOURCE => jai_constants.source_wsh ,

Line 2257: 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);

2253: P_PROCESS_FLAG => lv_acct_process_flag ,
2254: P_PROCESS_MESSAGE => lv_acct_process_message
2255: );
2256: IF lv_Debug = 'Y' THEN
2257: 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);
2258: END IF;
2259: IF lv_acct_process_flag = jai_constants.successful THEN
2260: /*
2261: || If the control comes here it means that Accounting got processed successfully.

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

2279: COMMIT;
2280: END IF;
2281: ELSE
2282: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
2283: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered after call to process_order_invoice is ' || lv_acct_process_message);
2284: END IF;
2285:
2286: IF lv_inv_gen_process_flag <> jai_constants.successful OR lv_acct_process_flag <> jai_constants.successful THEN
2287:

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

2326: /*
2327: || Coding here to mark the status of the concurrent and generating statictics.
2328: ||
2329: */
2330: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ Number of Successful deliveries : ' || ln_success_delivery_Ctr || '+++');
2331: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ Number of Failed deliveries : ' || ln_failure_delivery_ctr || '+++');
2332:
2333: IF ln_failure_delivery_ctr > 0 AND ln_success_delivery_Ctr > 0 then
2334: /*

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

2327: || Coding here to mark the status of the concurrent and generating statictics.
2328: ||
2329: */
2330: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ Number of Successful deliveries : ' || ln_success_delivery_Ctr || '+++');
2331: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ Number of Failed deliveries : ' || ln_failure_delivery_ctr || '+++');
2332:
2333: IF ln_failure_delivery_ctr > 0 AND ln_success_delivery_Ctr > 0 then
2334: /*
2335: || Atleast one delivery failed Atleast one delivery Succeeded

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

2365:
2366: EXCEPTION
2367: WHEN OTHERS THEN
2368: RETCODE := '2';
2369: Fnd_File.PUT_LINE(Fnd_File.LOG,'Unexpected Error occured in procedure jai_cmn_rgm_processing_pkg.process '||substr(sqlerrm,1,300));
2370: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',substr(sqlerrm,1,1000));
2371: ERRBUF := substr(sqlerrm,1,1000);
2372: lv_inv_gen_process_flag := jai_constants.unexpected_error;
2373: lv_acct_process_flag := jai_constants.unexpected_error;