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.FV_APPLY_CASH_RECEIPT dependencies on AR_BATCHES

Line 513: p_BatchRec IN fv_ar_batches%ROWTYPE,

509: --* : required report format. *--
510: --****************************************************************************************--
511: PROCEDURE write_report_header
512: (
513: p_BatchRec IN fv_ar_batches%ROWTYPE,
514: p_ErrorCode OUT NOCOPY VARCHAR2,
515: p_ErrorDesc OUT NOCOPY VARCHAR2,
516: p_ErrorLoc OUT NOCOPY VARCHAR2
517: ) IS

Line 701: --* Purpose : Writes the data in the record for ar_batches using debug_msg *--

697:
698: --****************************************************************************************--
699: --* Name : dump_ar_batch *--
700: --* Type : Procedure *--
701: --* Purpose : Writes the data in the record for ar_batches using debug_msg *--
702: --* Parameters : p_ARBatchRec IN ar_batches%ROWTYPE *--
703: --* Global Vars : None *--
704: --* Called from : insert_ar_batch *--
705: --* Calls : debug_msg *--

Line 702: --* Parameters : p_ARBatchRec IN ar_batches%ROWTYPE *--

698: --****************************************************************************************--
699: --* Name : dump_ar_batch *--
700: --* Type : Procedure *--
701: --* Purpose : Writes the data in the record for ar_batches using debug_msg *--
702: --* Parameters : p_ARBatchRec IN ar_batches%ROWTYPE *--
703: --* Global Vars : None *--
704: --* Called from : insert_ar_batch *--
705: --* Calls : debug_msg *--
706: --* Tables Used : None *--

Line 711: p_ARBatchRec IN ar_batches%ROWTYPE

707: --* Logic : Call debug_msg and write the contents of p_ARBatchRec. *--
708: --****************************************************************************************--
709: PROCEDURE dump_ar_batch
710: (
711: p_ARBatchRec IN ar_batches%ROWTYPE
712: ) IS
713: l_module_name VARCHAR2(30) := 'dump_ar_batch';
714: BEGIN
715: ----------------------------------------------------------------------

Line 716: -- For Debug purposes dump the contents of ar_batches record --

712: ) IS
713: l_module_name VARCHAR2(30) := 'dump_ar_batch';
714: BEGIN
715: ----------------------------------------------------------------------
716: -- For Debug purposes dump the contents of ar_batches record --
717: ----------------------------------------------------------------------
718: debug_msg (l_module_name, '====> Contents of AR_BATCHES record <====');
719: debug_msg (l_module_name, 'batch_id => '|| p_ARBatchRec.batch_id);
720: debug_msg (l_module_name, 'last_updated_by => '|| p_ARBatchRec.last_updated_by);

Line 718: debug_msg (l_module_name, '====> Contents of AR_BATCHES record <====');

714: BEGIN
715: ----------------------------------------------------------------------
716: -- For Debug purposes dump the contents of ar_batches record --
717: ----------------------------------------------------------------------
718: debug_msg (l_module_name, '====> Contents of AR_BATCHES record <====');
719: debug_msg (l_module_name, 'batch_id => '|| p_ARBatchRec.batch_id);
720: debug_msg (l_module_name, 'last_updated_by => '|| p_ARBatchRec.last_updated_by);
721: debug_msg (l_module_name, 'last_update_date => '|| TO_CHAR(p_ARBatchRec.last_update_date, 'MM/DD/YYYY HH24:MI:SS'));
722: debug_msg (l_module_name, 'last_update_login => '|| p_ARBatchRec.last_update_login);

Line 765: --* Purpose : This procedure inserts a record into the table ar_batches *--

761:
762: --****************************************************************************************--
763: --* Name : insert_ar_batch *--
764: --* Type : Procedure *--
765: --* Purpose : This procedure inserts a record into the table ar_batches *--
766: --* Parameters : p_BatchRec IN fv_ar_batches%ROWTYPE *--
767: --* : p_ErrorCode OUT The Error Code *--
768: --* : p_ErrorDesc OUT The Error Description *--
769: --* : p_ErrorLoc OUT The Error Location *--

Line 766: --* Parameters : p_BatchRec IN fv_ar_batches%ROWTYPE *--

762: --****************************************************************************************--
763: --* Name : insert_ar_batch *--
764: --* Type : Procedure *--
765: --* Purpose : This procedure inserts a record into the table ar_batches *--
766: --* Parameters : p_BatchRec IN fv_ar_batches%ROWTYPE *--
767: --* : p_ErrorCode OUT The Error Code *--
768: --* : p_ErrorDesc OUT The Error Description *--
769: --* : p_ErrorLoc OUT The Error Location *--
770: --* Global Vars : g_SUCCESS READ *--

Line 776: --* Tables Used : ar_batches (VIEW) INSERT *--

772: --* Calls : debug_init *--
773: --* : debug_exit *--
774: --* : dump_ar_batch *--
775: --* : log_msg *--
776: --* Tables Used : ar_batches (VIEW) INSERT *--
777: --* Logic : Copy the FV_AR_BATCHES record into AR_BATCHES record. *--
778: --* : Call dump_ar_batch to display the AR_BATCHES record in debug mode *--
779: --* : Insert the AR_BATCHES record into the table ar_batches *--
780: --****************************************************************************************--

Line 777: --* Logic : Copy the FV_AR_BATCHES record into AR_BATCHES record. *--

773: --* : debug_exit *--
774: --* : dump_ar_batch *--
775: --* : log_msg *--
776: --* Tables Used : ar_batches (VIEW) INSERT *--
777: --* Logic : Copy the FV_AR_BATCHES record into AR_BATCHES record. *--
778: --* : Call dump_ar_batch to display the AR_BATCHES record in debug mode *--
779: --* : Insert the AR_BATCHES record into the table ar_batches *--
780: --****************************************************************************************--
781: PROCEDURE insert_ar_batch

Line 778: --* : Call dump_ar_batch to display the AR_BATCHES record in debug mode *--

774: --* : dump_ar_batch *--
775: --* : log_msg *--
776: --* Tables Used : ar_batches (VIEW) INSERT *--
777: --* Logic : Copy the FV_AR_BATCHES record into AR_BATCHES record. *--
778: --* : Call dump_ar_batch to display the AR_BATCHES record in debug mode *--
779: --* : Insert the AR_BATCHES record into the table ar_batches *--
780: --****************************************************************************************--
781: PROCEDURE insert_ar_batch
782: (

Line 779: --* : Insert the AR_BATCHES record into the table ar_batches *--

775: --* : log_msg *--
776: --* Tables Used : ar_batches (VIEW) INSERT *--
777: --* Logic : Copy the FV_AR_BATCHES record into AR_BATCHES record. *--
778: --* : Call dump_ar_batch to display the AR_BATCHES record in debug mode *--
779: --* : Insert the AR_BATCHES record into the table ar_batches *--
780: --****************************************************************************************--
781: PROCEDURE insert_ar_batch
782: (
783: p_BatchRec IN fv_ar_batches%ROWTYPE,

Line 783: p_BatchRec IN fv_ar_batches%ROWTYPE,

779: --* : Insert the AR_BATCHES record into the table ar_batches *--
780: --****************************************************************************************--
781: PROCEDURE insert_ar_batch
782: (
783: p_BatchRec IN fv_ar_batches%ROWTYPE,
784: p_ErrorCode OUT NOCOPY VARCHAR2,
785: p_ErrorDesc OUT NOCOPY VARCHAR2,
786: p_ErrorLoc OUT NOCOPY VARCHAR2
787: ) IS

Line 790: l_ARBatchRec ar_batches%ROWTYPE;

786: p_ErrorLoc OUT NOCOPY VARCHAR2
787: ) IS
788: l_module_name VARCHAR2(30) := 'insert_ar_batch';
789:
790: l_ARBatchRec ar_batches%ROWTYPE;
791:
792: BEGIN
793: p_ErrorCode := g_SUCCESS;
794: p_ErrorDesc := NULL;

Line 803: -- Copy the fv_ar_batches record into ar_batches record --

799: log_msg(l_module_name,'Creating Receipt Batch '||p_BatchRec.batch_name);
800:
801:
802: ----------------------------------------------------------------------
803: -- Copy the fv_ar_batches record into ar_batches record --
804: ----------------------------------------------------------------------
805:
806: l_ARBatchRec.batch_id := p_BatchRec.batch_id;
807: l_ARBatchRec.last_updated_by := p_BatchRec.last_updated_by;

Line 849: -- Call dump_ar_batch to display ar_batches record in debug mode --

845: l_ARBatchRec.set_of_books_id := p_BatchRec.set_of_books_id;
846: l_ARBatchRec.org_id := p_BatchRec.org_id;
847:
848: ----------------------------------------------------------------------
849: -- Call dump_ar_batch to display ar_batches record in debug mode --
850: ----------------------------------------------------------------------
851: dump_ar_batch (l_ARBatchRec);
852:
853: ----------------------------------------------------------------------

Line 854: -- Insert the ar_batches record into ar_batches table --

850: ----------------------------------------------------------------------
851: dump_ar_batch (l_ARBatchRec);
852:
853: ----------------------------------------------------------------------
854: -- Insert the ar_batches record into ar_batches table --
855: ----------------------------------------------------------------------
856: debug_msg (l_module_name, 'Inserting data into ar_batches');
857: INSERT INTO ar_batches
858: (

Line 856: debug_msg (l_module_name, 'Inserting data into ar_batches');

852:
853: ----------------------------------------------------------------------
854: -- Insert the ar_batches record into ar_batches table --
855: ----------------------------------------------------------------------
856: debug_msg (l_module_name, 'Inserting data into ar_batches');
857: INSERT INTO ar_batches
858: (
859: batch_id,
860: last_updated_by,

Line 857: INSERT INTO ar_batches

853: ----------------------------------------------------------------------
854: -- Insert the ar_batches record into ar_batches table --
855: ----------------------------------------------------------------------
856: debug_msg (l_module_name, 'Inserting data into ar_batches');
857: INSERT INTO ar_batches
858: (
859: batch_id,
860: last_updated_by,
861: last_update_date,

Line 1582: --* : table ar_batches and the batch_id obtained is used to update the *--

1578: --* Name : update_cash_receipt_hist *--
1579: --* Type : Procedure *--
1580: --* Purpose : Currenty the APIs for Receipt process does not have an option to *--
1581: --* : receive batch_id, hence the fv_ar_batch details are entered into the *--
1582: --* : table ar_batches and the batch_id obtained is used to update the *--
1583: --* : table ar_cash_receipt_history_all, so that it simulates the current *--
1584: --* : process of entering the receipt details through batch *--
1585: --* Parameters : p_BatchId IN The batch Id *--
1586: --* : p_CashReceiptId IN The Cash Receipt Id *--

Line 1626: -- table ar_batches --

1622:
1623: BEGIN
1624: ----------------------------------------------------------------------
1625: -- Update the table ar_cash_receipt_history_all to link it with the --
1626: -- table ar_batches --
1627: ----------------------------------------------------------------------
1628: UPDATE ar_cash_receipt_history_all
1629: SET batch_id = p_BatchId
1630: WHERE cash_receipt_id = p_CashReceiptId;

Line 1670: --* : fv_ar_batches_all.

1666: --****************************************************************************************--
1667: --* Name : update_fv_batch_status *--
1668: --* Type : Procedure *--
1669: --* Purpose : This procedure is used to update the status of the table *--
1670: --* : fv_ar_batches_all.
1671: --* Parameters : p_BatchId IN The batch Id *--
1672: --* : p_Status IN The Status to which the table to be updated *--
1673: --* : p_ErrorCode OUT The Error Code *--
1674: --* : p_ErrorDesc OUT The Error Description *--

Line 1681: --* Tables Used : fv_ar_batches_all UPDATE *--

1677: --* Called from : main *--
1678: --* Calls : debug_msg *--
1679: --* : debug_init *--
1680: --* : debug_exit *--
1681: --* Tables Used : fv_ar_batches_all UPDATE *--
1682: --* Logic : Update the table fv_ar_batches_all with the status p_Status for the *--
1683: --* : batch_id p_BatchId *--
1684: --****************************************************************************************--
1685: PROCEDURE update_fv_batch_status

Line 1682: --* Logic : Update the table fv_ar_batches_all with the status p_Status for the *--

1678: --* Calls : debug_msg *--
1679: --* : debug_init *--
1680: --* : debug_exit *--
1681: --* Tables Used : fv_ar_batches_all UPDATE *--
1682: --* Logic : Update the table fv_ar_batches_all with the status p_Status for the *--
1683: --* : batch_id p_BatchId *--
1684: --****************************************************************************************--
1685: PROCEDURE update_fv_batch_status
1686: (

Line 1706: debug_msg (l_module_name, 'Updating table fv_ar_batches_all');

1702: debug_msg (l_module_name, 'p_BatchId = '||p_BatchId);
1703: debug_msg (l_module_name, 'p_Status = '||p_Status);
1704:
1705: BEGIN
1706: debug_msg (l_module_name, 'Updating table fv_ar_batches_all');
1707:
1708: ----------------------------------------------------------------------
1709: -- Update the table fv_ar_batches_all to the status p_Status for --
1710: -- batch_id p_BatchId --

Line 1709: -- Update the table fv_ar_batches_all to the status p_Status for --

1705: BEGIN
1706: debug_msg (l_module_name, 'Updating table fv_ar_batches_all');
1707:
1708: ----------------------------------------------------------------------
1709: -- Update the table fv_ar_batches_all to the status p_Status for --
1710: -- batch_id p_BatchId --
1711: ----------------------------------------------------------------------
1712: UPDATE fv_ar_batches_all
1713: SET transfer_status = p_status

Line 1712: UPDATE fv_ar_batches_all

1708: ----------------------------------------------------------------------
1709: -- Update the table fv_ar_batches_all to the status p_Status for --
1710: -- batch_id p_BatchId --
1711: ----------------------------------------------------------------------
1712: UPDATE fv_ar_batches_all
1713: SET transfer_status = p_status
1714: WHERE batch_id = p_BatchId;
1715:
1716: debug_msg (l_module_name, 'Updated '||SQL%ROWCOUNT||' rows.');

Line 1722: p_ErrorLoc := 'UPDATE fv_ar_batches_all';

1718: EXCEPTION
1719: WHEN OTHERS THEN
1720: p_ErrorCode := g_FAILURE;
1721: p_ErrorDesc := SQLERRM;
1722: p_ErrorLoc := 'UPDATE fv_ar_batches_all';
1723: error
1724: (
1725: p_error_type => p_ErrorCode,
1726: p_pgm => l_module_name,

Line 2049: p_ExchangeRateDate IN ar_batches.exchange_date%TYPE,

2045: p_InvoiceId IN ra_customer_trx_all.customer_trx_id%TYPE,
2046: p_InvoiceLineId IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
2047: p_CurrencyCode IN fv_interim_cash_receipts.currency_code%TYPE,
2048: p_InvoiceCurrencyCode IN ra_customer_trx_all.invoice_currency_code%TYPE,
2049: p_ExchangeRateDate IN ar_batches.exchange_date%TYPE,
2050: p_ExchangeRate IN ar_batches.exchange_rate%TYPE,
2051: p_ExchangeRateType IN ar_batches.exchange_rate_type%TYPE,
2052: p_PaymentScheduleId IN ar_payment_schedules.payment_schedule_id%TYPE,
2053: p_InvoiceAmount IN NUMBER,

Line 2050: p_ExchangeRate IN ar_batches.exchange_rate%TYPE,

2046: p_InvoiceLineId IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
2047: p_CurrencyCode IN fv_interim_cash_receipts.currency_code%TYPE,
2048: p_InvoiceCurrencyCode IN ra_customer_trx_all.invoice_currency_code%TYPE,
2049: p_ExchangeRateDate IN ar_batches.exchange_date%TYPE,
2050: p_ExchangeRate IN ar_batches.exchange_rate%TYPE,
2051: p_ExchangeRateType IN ar_batches.exchange_rate_type%TYPE,
2052: p_PaymentScheduleId IN ar_payment_schedules.payment_schedule_id%TYPE,
2053: p_InvoiceAmount IN NUMBER,
2054: p_InvoiceLineAmount IN NUMBER,

Line 2051: p_ExchangeRateType IN ar_batches.exchange_rate_type%TYPE,

2047: p_CurrencyCode IN fv_interim_cash_receipts.currency_code%TYPE,
2048: p_InvoiceCurrencyCode IN ra_customer_trx_all.invoice_currency_code%TYPE,
2049: p_ExchangeRateDate IN ar_batches.exchange_date%TYPE,
2050: p_ExchangeRate IN ar_batches.exchange_rate%TYPE,
2051: p_ExchangeRateType IN ar_batches.exchange_rate_type%TYPE,
2052: p_PaymentScheduleId IN ar_payment_schedules.payment_schedule_id%TYPE,
2053: p_InvoiceAmount IN NUMBER,
2054: p_InvoiceLineAmount IN NUMBER,
2055: p_ReceiptDate IN ar_cash_receipts.receipt_date%TYPE,

Line 2438: p_ExchangeRateDate IN ar_batches.exchange_date%TYPE,

2434: p_ReceiptNumber IN fv_interim_cash_receipts.receipt_number%TYPE,
2435: p_CashReceiptId IN ar_cash_receipts_all.cash_receipt_id%TYPE,
2436: p_InvoiceId IN ra_customer_trx_all.customer_trx_id%TYPE,
2437: p_CurrencyCode IN fv_interim_cash_receipts.currency_code%TYPE,
2438: p_ExchangeRateDate IN ar_batches.exchange_date%TYPE,
2439: p_ExchangeRate IN ar_batches.exchange_rate%TYPE,
2440: p_ExchangeRateType IN ar_batches.exchange_rate_type%TYPE,
2441: p_ReceiptDate IN ar_cash_receipts.receipt_date%TYPE,
2442: p_gldate IN DATE,

Line 2439: p_ExchangeRate IN ar_batches.exchange_rate%TYPE,

2435: p_CashReceiptId IN ar_cash_receipts_all.cash_receipt_id%TYPE,
2436: p_InvoiceId IN ra_customer_trx_all.customer_trx_id%TYPE,
2437: p_CurrencyCode IN fv_interim_cash_receipts.currency_code%TYPE,
2438: p_ExchangeRateDate IN ar_batches.exchange_date%TYPE,
2439: p_ExchangeRate IN ar_batches.exchange_rate%TYPE,
2440: p_ExchangeRateType IN ar_batches.exchange_rate_type%TYPE,
2441: p_ReceiptDate IN ar_cash_receipts.receipt_date%TYPE,
2442: p_gldate IN DATE,
2443: p_RemaingReceiptAmount IN OUT NOCOPY NUMBER,

Line 2440: p_ExchangeRateType IN ar_batches.exchange_rate_type%TYPE,

2436: p_InvoiceId IN ra_customer_trx_all.customer_trx_id%TYPE,
2437: p_CurrencyCode IN fv_interim_cash_receipts.currency_code%TYPE,
2438: p_ExchangeRateDate IN ar_batches.exchange_date%TYPE,
2439: p_ExchangeRate IN ar_batches.exchange_rate%TYPE,
2440: p_ExchangeRateType IN ar_batches.exchange_rate_type%TYPE,
2441: p_ReceiptDate IN ar_cash_receipts.receipt_date%TYPE,
2442: p_gldate IN DATE,
2443: p_RemaingReceiptAmount IN OUT NOCOPY NUMBER,
2444: p_ErrorCode OUT NOCOPY VARCHAR2,

Line 2457: l_ExchangeRate ar_batches.exchange_rate%TYPE;

2453: -- l_USSGLTransactionCode ar_cash_receipts.ussgl_transaction_code%TYPE;
2454: l_ConvertedAmountDue NUMBER;
2455: l_denominator NUMBER;
2456: l_numerator NUMBER;
2457: l_ExchangeRate ar_batches.exchange_rate%TYPE;
2458: l_UnAppliedAmount NUMBER := 0;
2459:
2460: CURSOR DebitMemo_Cur (c_invoice_id NUMBER) IS
2461: SELECT distinct aps.customer_trx_id invoice_id,

Line 2664: --* Parameters : p_BatchRec IN The Complete record in fv_ar_batches for a batch_id*--

2660: --****************************************************************************************--
2661: --* Name : process_receipts *--
2662: --* Type : Procedure *--
2663: --* Purpose : This is the procedure which starts processing a receipt batch *--
2664: --* Parameters : p_BatchRec IN The Complete record in fv_ar_batches for a batch_id*--
2665: --* : p_ErrorCode OUT The Error Code *--
2666: --* : p_ErrorDesc OUT The Error Description *--
2667: --* : p_ErrorLoc OUT The Error Location *--
2668: --* Global Vars : g_SUCCESS READ *--

Line 2690: --* : 2. Insert the fv_ar_batch details into the table ar_batches by *--

2686: --* : ra_customers SELECT *--
2687: --* : ar_payment_schedules SELECT *--
2688: --* : ra_cust_trx_types SELECT *--
2689: --* Logic : 1. Write the Batch Information into the output report. *--
2690: --* : 2. Insert the fv_ar_batch details into the table ar_batches by *--
2691: --* : calling the procedure insert_ar_batch *--
2692: --* : 3. For each of the receipt in the batch fv_ar_batches do the *--
2693: --* : following *--
2694: --* : 4. Initialize the receipt report variables *--

Line 2692: --* : 3. For each of the receipt in the batch fv_ar_batches do the *--

2688: --* : ra_cust_trx_types SELECT *--
2689: --* Logic : 1. Write the Batch Information into the output report. *--
2690: --* : 2. Insert the fv_ar_batch details into the table ar_batches by *--
2691: --* : calling the procedure insert_ar_batch *--
2692: --* : 3. For each of the receipt in the batch fv_ar_batches do the *--
2693: --* : following *--
2694: --* : 4. Initialize the receipt report variables *--
2695: --* : 5. If the invoice id is filled up, use the invoice and ignore the *--
2696: --* : customer details as the receipt is against the invoice, else the *--

Line 2709: p_BatchRec IN fv_ar_batches%ROWTYPE,

2705: --* :11. Write the output report for a receipt *--
2706: --****************************************************************************************--
2707: PROCEDURE process_receipts
2708: (
2709: p_BatchRec IN fv_ar_batches%ROWTYPE,
2710: p_ErrorCode OUT NOCOPY VARCHAR2,
2711: p_ErrorDesc OUT NOCOPY VARCHAR2,
2712: p_ErrorLoc OUT NOCOPY VARCHAR2
2713: ) IS

Line 3170: --* Tables Used : fv_ar_batches SELECT *--

3166: --* : debug_msg *--
3167: --* : debug_init *--
3168: --* : debug_exit *--
3169: --* : error *--
3170: --* Tables Used : fv_ar_batches SELECT *--
3171: --* Logic : 1. Given the batch name get the record from table fv_ar_batches *--
3172: --* : 2. Call process_receipts to Start Processing the receipts in the *--
3173: --* : batch. *--
3174: --* : 3. Call update_fv_batch_status to update the batch status *--

Line 3171: --* Logic : 1. Given the batch name get the record from table fv_ar_batches *--

3167: --* : debug_init *--
3168: --* : debug_exit *--
3169: --* : error *--
3170: --* Tables Used : fv_ar_batches SELECT *--
3171: --* Logic : 1. Given the batch name get the record from table fv_ar_batches *--
3172: --* : 2. Call process_receipts to Start Processing the receipts in the *--
3173: --* : batch. *--
3174: --* : 3. Call update_fv_batch_status to update the batch status *--
3175: --****************************************************************************************--

Line 3188: l_BatchRec fv_ar_batches%ROWTYPE;

3184: l_ErrorCode NUMBER;
3185: l_ErrorDesc VARCHAR2(1024);
3186: l_ErrorLoc VARCHAR2(1024);
3187:
3188: l_BatchRec fv_ar_batches%ROWTYPE;
3189: BEGIN
3190: l_ErrorCode := g_SUCCESS;
3191: l_ErrorDesc := '';
3192: l_ErrorLoc := '';

Line 3204: -- Get the batch details from fv_ar_batches given the batch name

3200: debug_msg (l_module_name, 'p_batch_name = '||p_batch_name);
3201: log_msg (l_module_name,'p_batch_name = '||p_batch_name);
3202:
3203: ----------------------------------------------------------------------
3204: -- Get the batch details from fv_ar_batches given the batch name
3205: -- If there is no data found then it is an error.
3206: ----------------------------------------------------------------------
3207: IF (l_ErrorCode = g_SUCCESS) THEN
3208: BEGIN

Line 3212: FROM fv_ar_batches fab

3208: BEGIN
3209: debug_msg (l_module_name, 'Getting the Batch Details');
3210: SELECT *
3211: INTO l_BatchRec
3212: FROM fv_ar_batches fab
3213: WHERE batch_name = p_batch_name;
3214: EXCEPTION
3215: WHEN NO_DATA_FOUND THEN
3216: l_ErrorCode := g_FAILURE;

Line 3218: l_ErrorLoc := l_module_name || ':' || 'SELECT fv_ar_batches';

3214: EXCEPTION
3215: WHEN NO_DATA_FOUND THEN
3216: l_ErrorCode := g_FAILURE;
3217: l_ErrorDesc := 'No Batch with name <'||p_batch_name||'> Exists.';
3218: l_ErrorLoc := l_module_name || ':' || 'SELECT fv_ar_batches';
3219: error
3220: (
3221: p_error_type => l_ErrorCode,
3222: p_pgm => l_module_name,

Line 3230: l_ErrorLoc := l_module_name || ':' || 'SELECT fv_ar_batches';

3226: debug_msg (l_module_name, 'No Data Found for the batch <'||p_batch_name);
3227: WHEN OTHERS THEN
3228: l_ErrorCode := g_FAILURE;
3229: l_ErrorDesc := SQLERRM;
3230: l_ErrorLoc := l_module_name || ':' || 'SELECT fv_ar_batches';
3231: error
3232: (
3233: p_error_type => l_ErrorCode,
3234: p_pgm => l_module_name,