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 FV_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 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 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 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 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 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 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 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,