DBA Data[Home] [Help]

APPS.FV_APPLY_CASH_RECEIPT dependencies on AR_RECEIPT_API_PUB

Line 112: attribute_rec ar_receipt_api_pub.attribute_rec_type,

108: doc_sequence_value NUMBER,
109: -- ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE,
110: anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE,
111: called_from VARCHAR2(100),
112: attribute_rec ar_receipt_api_pub.attribute_rec_type,
113: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,
114: comments ar_receivable_applications.comments%TYPE,
115: issuer_name ar_cash_receipts.issuer_name%TYPE,
116: issue_date ar_cash_receipts.issue_date%TYPE,

Line 113: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,

109: -- ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE,
110: anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE,
111: called_from VARCHAR2(100),
112: attribute_rec ar_receipt_api_pub.attribute_rec_type,
113: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,
114: comments ar_receivable_applications.comments%TYPE,
115: issuer_name ar_cash_receipts.issuer_name%TYPE,
116: issue_date ar_cash_receipts.issue_date%TYPE,
117: issuer_bank_branch_id ar_cash_receipts.issuer_bank_branch_id%TYPE,

Line 146: attribute_rec ar_receipt_api_pub.attribute_rec_type,

142: show_closed_invoices VARCHAR2(100),
143: called_from VARCHAR2(100),
144: move_deferred_tax VARCHAR2(100),
145: link_to_trx_hist_id ar_receivable_applications.link_to_trx_hist_id%TYPE,
146: attribute_rec ar_receipt_api_pub.attribute_rec_type,
147: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,
148: comments ar_receivable_applications.comments%TYPE,
149: payment_set_id ar_receivable_applications.payment_set_id%TYPE,
150: application_ref_type ar_receivable_applications.application_ref_type%TYPE,

Line 147: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,

143: called_from VARCHAR2(100),
144: move_deferred_tax VARCHAR2(100),
145: link_to_trx_hist_id ar_receivable_applications.link_to_trx_hist_id%TYPE,
146: attribute_rec ar_receipt_api_pub.attribute_rec_type,
147: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,
148: comments ar_receivable_applications.comments%TYPE,
149: payment_set_id ar_receivable_applications.payment_set_id%TYPE,
150: application_ref_type ar_receivable_applications.application_ref_type%TYPE,
151: application_ref_id ar_receivable_applications.application_ref_id%TYPE,

Line 169: attribute_rec ar_receipt_api_pub.attribute_rec_type,

165: amount_applied ar_receivable_applications.amount_applied%TYPE,
166: apply_date ar_receivable_applications.apply_date%TYPE,
167: apply_gl_date ar_receivable_applications.gl_date%TYPE,
168: -- ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE,
169: attribute_rec ar_receipt_api_pub.attribute_rec_type,
170: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,
171: comments ar_receivable_applications.comments%TYPE
172: );
173:

Line 170: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,

166: apply_date ar_receivable_applications.apply_date%TYPE,
167: apply_gl_date ar_receivable_applications.gl_date%TYPE,
168: -- ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE,
169: attribute_rec ar_receipt_api_pub.attribute_rec_type,
170: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,
171: comments ar_receivable_applications.comments%TYPE
172: );
173:
174: ------------------------------------------------------------------------

Line 966: --* Purpose : Calls the API ar_receipt_api_pub.Apply_on_account to Apply the *--

962:
963: --****************************************************************************************--
964: --* Name : apply_on_account *--
965: --* Type : Procedure *--
966: --* Purpose : Calls the API ar_receipt_api_pub.Apply_on_account to Apply the *--
967: --* : receipt amount to On Account for the customer *--
968: --* Parameters : p_OnAccountRec IN OnAccountRecType *--
969: --* : p_ErrorCode OUT The Error Code *--
970: --* : p_ErrorDesc OUT The Error Description *--

Line 976: --* Calls : ar_receipt_api_pub.Apply_on_account *--

972: --* Global Vars : g_SUCCESS READ *--
973: --* : g_OutErrorInfo WRITE *--
974: --* : g_OutCashReceipts WRITE, READ *--
975: --* Called from : process_receipts *--
976: --* Calls : ar_receipt_api_pub.Apply_on_account *--
977: --* : fnd_msg_pub.get *--
978: --* : debug_msg *--
979: --* : debug_init *--
980: --* : debug_exit *--

Line 984: --* : ar_receipt_api_pub.Apply_on_account *--

980: --* : debug_exit *--
981: --* : error *--
982: --* Tables Used : None *--
983: --* Logic : Use the values in p_OnAccountRec and use them as parameters to call *--
984: --* : ar_receipt_api_pub.Apply_on_account *--
985: --* : If there is an error the return code in x_return_status will not be S*--
986: --* : If there is an error, check the contents of x_msg_count *--
987: --* : If x_msg_count is 1 then the error message is obtained from *--
988: --* : x_msg_data *--

Line 1016: debug_msg (l_module_name, 'Calling API ar_receipt_api_pub.Apply_on_account with the following paraeteres');

1012:
1013: ----------------------------------------------------------------------
1014: -- Print contents of P_OnAccountRec for debug purposes --
1015: ----------------------------------------------------------------------
1016: debug_msg (l_module_name, 'Calling API ar_receipt_api_pub.Apply_on_account with the following paraeteres');
1017: debug_msg (l_module_name, 'p_api_version => '||l_api_version);
1018: debug_msg (l_module_name, 'p_cash_receipt_id => '||p_OnAccountRec.cash_receipt_id);
1019: debug_msg (l_module_name, 'p_receipt_number => '||p_OnAccountRec.receipt_number);
1020: debug_msg (l_module_name, 'p_amount_applied => '||p_OnAccountRec.amount_applied);

Line 1027: -- Call API ar_receipt_api_pub.Apply_on_account for applying --

1023: -- debug_msg (l_module_name, 'p_ussgl_transaction_code => '||p_OnAccountRec.ussgl_transaction_code);
1024: debug_msg (l_module_name, 'p_comments => '||p_OnAccountRec.comments);
1025:
1026: ----------------------------------------------------------------------
1027: -- Call API ar_receipt_api_pub.Apply_on_account for applying --
1028: -- p_OnAccountRec.amount_applied towards On account for the --
1029: -- customer --
1030: ----------------------------------------------------------------------
1031: log_msg (l_module_name,'Applying On Account for an amount of '||p_OnAccountRec.amount_applied);

Line 1032: ar_receipt_api_pub.Apply_on_account

1028: -- p_OnAccountRec.amount_applied towards On account for the --
1029: -- customer --
1030: ----------------------------------------------------------------------
1031: log_msg (l_module_name,'Applying On Account for an amount of '||p_OnAccountRec.amount_applied);
1032: ar_receipt_api_pub.Apply_on_account
1033: (
1034: p_api_version => l_api_version,
1035: p_init_msg_list => FND_API.G_TRUE,
1036: p_commit => FND_API.G_FALSE,

Line 1052: debug_msg (l_module_name, 'After Calling API ar_receipt_api_pub.Apply_on_account (Return Values)');

1048: p_attribute_rec => p_OnAccountRec.attribute_rec,
1049: p_global_attribute_rec => p_OnAccountRec.global_attribute_rec,
1050: p_comments => p_OnAccountRec.comments
1051: );
1052: debug_msg (l_module_name, 'After Calling API ar_receipt_api_pub.Apply_on_account (Return Values)');
1053: debug_msg (l_module_name, 'x_return_status => '||l_ReturnStatus);
1054: debug_msg (l_module_name, 'x_msg_count => '||l_MessageCount);
1055: debug_msg (l_module_name, 'x_msg_data => '||l_MessageData);
1056:

Line 1063: p_ErrorLoc := 'After Calling API ar_receipt_api_pub.Apply_on_account.';

1059: ----------------------------------------------------------------------
1060: -- There is an error --
1061: ----------------------------------------------------------------------
1062: p_ErrorCode := g_FAILURE;
1063: p_ErrorLoc := 'After Calling API ar_receipt_api_pub.Apply_on_account.';
1064:
1065: IF (l_MessageCount = 1) THEN
1066: ----------------------------------------------------------------------
1067: -- Message Count is 1, hence the error message is in x_msg_data --

Line 1135: --* Calls : ar_receipt_api_pub.unapply *--

1131: --* Global Vars : g_SUCCESS READ *--
1132: --* : g_OutErrorInfo WRITE *--
1133: --* : g_OutCashReceipts WRITE, READ *--
1134: --* Called from : pay_debit_memos *--
1135: --* Calls : ar_receipt_api_pub.unapply *--
1136: --* : fnd_msg_pub.get *--
1137: --* : debug_msg *--
1138: --* : debug_init *--
1139: --* : debug_exit *--

Line 1146: --* : ar_receipt_api_pub.unapply to unapply the invoice *--

1142: --* Logic : For the specific Cash Receipt Id and Invoice Id see if there is any *--
1143: --* : data in the table ar_receivable_applications. *--
1144: --* : If not exit. *--
1145: --* : If there is any data in ar_receivable_applications, then call *--
1146: --* : ar_receipt_api_pub.unapply to unapply the invoice *--
1147: --* : If there is an error the return code in x_return_status will not be S*--
1148: --* : If there is an error, check the contents of x_msg_count *--
1149: --* : If x_msg_count is 1 then the error message is obtained from *--
1150: --* : x_msg_data *--

Line 1215: ar_receipt_api_pub.unapply

1211: debug_msg (l_module_name, 'l_PreviousAmount = '||l_PreviousAmount);
1212:
1213: IF (p_ErrorCode = g_SUCCESS) THEN
1214: IF (l_PreviousAmount <> 0) THEN
1215: ar_receipt_api_pub.unapply
1216: (
1217: p_api_version => l_api_version,
1218: p_init_msg_list => FND_API.G_TRUE,
1219: p_commit => FND_API.G_FALSE,

Line 1236: debug_msg (l_module_name, 'After Calling API ar_receipt_api_pub.Unapply (Return Values)');

1232: p_called_from => NULL,
1233: p_cancel_claim_flag => NULL
1234: );
1235:
1236: debug_msg (l_module_name, 'After Calling API ar_receipt_api_pub.Unapply (Return Values)');
1237: debug_msg (l_module_name, 'x_return_status => '||l_ReturnStatus);
1238: debug_msg (l_module_name, 'x_msg_count => '||l_MessageCount);
1239: debug_msg (l_module_name, 'x_msg_data => '||l_MessageData);
1240:

Line 1246: p_ErrorLoc := 'After Calling API ar_receipt_api_pub.UnApply.';

1242: ----------------------------------------------------------------------
1243: -- There is an error --
1244: ----------------------------------------------------------------------
1245: p_ErrorCode := g_FAILURE;
1246: p_ErrorLoc := 'After Calling API ar_receipt_api_pub.UnApply.';
1247:
1248: IF (l_MessageCount = 1) THEN
1249: ----------------------------------------------------------------------
1250: -- Message Count is 1, hence the error message is in x_msg_data --

Line 1308: --* Purpose : This procedure calls API ar_receipt_api_pub.Apply to apply the *--

1304:
1305: --****************************************************************************************--
1306: --* Name : CreateCashReceipt *--
1307: --* Type : Procedure *--
1308: --* Purpose : This procedure calls API ar_receipt_api_pub.Apply to apply the *--
1309: --* : receipt against an invoice or debit memo. *--
1310: --* Parameters : p_ApplyCashRec IN ApplyCashRecType *--
1311: --* : p_ErrorCode OUT The Error Code *--
1312: --* : p_ErrorDesc OUT The Error Description *--

Line 1319: --* Calls : ar_receipt_api_pub.Apply *--

1315: --* : g_OutErrorInfo WRITE *--
1316: --* : g_OutCashReceipts WRITE, READ *--
1317: --* Called from : pay_the_invoice *--
1318: --* : pay_debit_memos *--
1319: --* Calls : ar_receipt_api_pub.Apply *--
1320: --* : fnd_msg_pub.get *--
1321: --* : debug_msg *--
1322: --* : debug_init *--
1323: --* : debug_exit *--

Line 1326: --* : ar_receipt_api_pub.Apply *--

1322: --* : debug_init *--
1323: --* : debug_exit *--
1324: --* Tables Used : None *--
1325: --* Logic : Use the values in p_OnAccountRec and use them as parameters to call *--
1326: --* : ar_receipt_api_pub.Apply *--
1327: --* : If there is an error the return code in x_return_status will not be S*--
1328: --* : If there is an error, check the contents of x_msg_count *--
1329: --* : If x_msg_count is 1 then the error message is obtained from *--
1330: --* : x_msg_data *--

Line 1346: llca_def_trx_lines_tbl AR_RECEIPT_API_PUB.llca_trx_lines_tbl_type;

1342: l_api_version CONSTANT NUMBER := 1.0;
1343: l_ReturnStatus VARCHAR2(10);
1344: l_MessageCount NUMBER;
1345: l_MessageData VARCHAR2(1024);
1346: llca_def_trx_lines_tbl AR_RECEIPT_API_PUB.llca_trx_lines_tbl_type;
1347:
1348:
1349: BEGIN
1350: p_ErrorCode := g_SUCCESS;

Line 1360: debug_msg (l_module_name, 'Calling API ar_receipt_api_pub.Apply/Apply_In_Detail with the following parameters');

1356: IF (p_ErrorCode = g_SUCCESS) THEN
1357: ----------------------------------------------------------------------
1358: -- Print contents of p_ApplyCashRec for debug purposes --
1359: ----------------------------------------------------------------------
1360: debug_msg (l_module_name, 'Calling API ar_receipt_api_pub.Apply/Apply_In_Detail with the following parameters');
1361: debug_msg (l_module_name, 'p_api_version => '||l_api_version);
1362: debug_msg (l_module_name, 'p_cash_receipt_id => '||p_ApplyCashRec.cash_receipt_id);
1363: debug_msg (l_module_name, 'p_receipt_number => '||p_ApplyCashRec.receipt_number);
1364: debug_msg (l_module_name, 'p_customer_trx_id => '||p_ApplyCashRec.customer_trx_id);

Line 1408: ar_receipt_api_pub.Apply_In_Detail

1404: llca_def_trx_lines_tbl(1).line_amount := p_ApplyCashRec.amount_applied;
1405: llca_def_trx_lines_tbl(1).amount_applied := p_ApplyCashRec.amount_applied;
1406: llca_def_trx_lines_tbl(1).amount_applied_from := p_ApplyCashRec.amount_applied_from;
1407:
1408: ar_receipt_api_pub.Apply_In_Detail
1409: (
1410: p_api_version => l_api_version,
1411: p_init_msg_list => FND_API.G_TRUE,
1412: p_commit => FND_API.G_TRUE,

Line 1451: debug_msg (l_module_name, 'After Calling API ar_receipt_api_pub.Apply_In_Detail (Return Values)');

1447: p_application_ref_reason => p_ApplyCashRec.application_ref_reason,
1448: p_customer_reference => p_ApplyCashRec.customer_reference,
1449: p_org_id => p_ApplyCashRec.org_id
1450: );
1451: debug_msg (l_module_name, 'After Calling API ar_receipt_api_pub.Apply_In_Detail (Return Values)');
1452: debug_msg (l_module_name, 'x_return_status => '||l_ReturnStatus);
1453: debug_msg (l_module_name, 'x_msg_count => '||l_MessageCount);
1454: debug_msg (l_module_name, 'x_msg_data => '||l_MessageData);
1455:

Line 1458: -- Call API ar_receipt_api_pub.Apply for applying the receipt amt --

1454: debug_msg (l_module_name, 'x_msg_data => '||l_MessageData);
1455:
1456: ELSE
1457: ----------------------------------------------------------------------
1458: -- Call API ar_receipt_api_pub.Apply for applying the receipt amt --
1459: -- p_ApplyCashRec.amount_applied, p_ApplyCashRec.amount_applied_from--
1460: -- towards the invoice or debit memo --
1461: ----------------------------------------------------------------------
1462: log_msg (l_module_name,'Applying Invoice Id <'||p_ApplyCashRec.customer_trx_id||

Line 1464: ar_receipt_api_pub.Apply

1460: -- towards the invoice or debit memo --
1461: ----------------------------------------------------------------------
1462: log_msg (l_module_name,'Applying Invoice Id <'||p_ApplyCashRec.customer_trx_id||
1463: '> against Cash Receipt Id <'||p_ApplyCashRec.cash_receipt_id||'>');
1464: ar_receipt_api_pub.Apply
1465: (
1466: p_api_version => l_api_version,
1467: p_init_msg_list => FND_API.G_TRUE,
1468: p_commit => FND_API.G_FALSE,

Line 1506: debug_msg (l_module_name, 'After Calling API ar_receipt_api_pub.Apply (Return Values)');

1502: p_customer_reference => p_ApplyCashRec.customer_reference,
1503: p_org_id => p_ApplyCashRec.org_id
1504: );
1505:
1506: debug_msg (l_module_name, 'After Calling API ar_receipt_api_pub.Apply (Return Values)');
1507: debug_msg (l_module_name, 'x_return_status => '||l_ReturnStatus);
1508: debug_msg (l_module_name, 'x_msg_count => '||l_MessageCount);
1509: debug_msg (l_module_name, 'x_msg_data => '||l_MessageData);
1510:

Line 1519: p_ErrorLoc := 'After Calling API ar_receipt_api_pub.Apply.';

1515: ----------------------------------------------------------------------
1516: -- There is an error --
1517: ----------------------------------------------------------------------
1518: p_ErrorCode := g_FAILURE;
1519: p_ErrorLoc := 'After Calling API ar_receipt_api_pub.Apply.';
1520:
1521: IF (l_MessageCount = 1) THEN
1522: ----------------------------------------------------------------------
1523: -- Message Count is 1, hence the error message is in x_msg_data --

Line 1753: --* : ar_receipt_api_pub.Create_cash and returns the Cash Receipt Id to *--

1749: --****************************************************************************************--
1750: --* Name : create_cash_receipt *--
1751: --* Type : Procedure *--
1752: --* Purpose : This procedure creates a Cash Receipt ID by calling the API *--
1753: --* : ar_receipt_api_pub.Create_cash and returns the Cash Receipt Id to *--
1754: --* : calling program. This procedure also calls update_cash_receipt_hist *--
1755: --* : to update the Cash Receipt History table with the batch_id *--
1756: --* Parameters : p_BatchId IN The batch Id *--
1757: --* : p_CreateCashRec IN CreateCashRecType *--

Line 1767: --* : ar_receipt_api_pub.Create_cash *--

1763: --* : g_OutErrorInfo WRITE *--
1764: --* : g_OutCashReceipts WRITE, READ *--
1765: --* Called from : process_receipts *--
1766: --* Calls : update_cash_receipt_hist *--
1767: --* : ar_receipt_api_pub.Create_cash *--
1768: --* : fnd_msg_pub.get *--
1769: --* : debug_msg *--
1770: --* : debug_init *--
1771: --* : debug_exit *--

Line 1776: --* : ar_receipt_api_pub.Create_cash *--

1772: --* : error *--
1773: --* : log_msg *--
1774: --* Tables Used : None *--
1775: --* Logic : Use the values in p_CreateCashRec and use them as parameters to call *--
1776: --* : ar_receipt_api_pub.Create_cash *--
1777: --* : If there is an error the return code in x_return_status will not be S*--
1778: --* : If there is an error, check the contents of x_msg_count *--
1779: --* : If x_msg_count is 1 then the error message is obtained from *--
1780: --* : x_msg_data *--

Line 1814: debug_msg (l_module_name, 'Calling API ar_receipt_api_pub.Create_cash with the following paraeteres');

1810:
1811: ----------------------------------------------------------------------
1812: -- Print contents of p_CreateCashRec for debug purposes --
1813: ----------------------------------------------------------------------
1814: debug_msg (l_module_name, 'Calling API ar_receipt_api_pub.Create_cash with the following paraeteres');
1815: debug_msg (l_module_name, ' p_api_version => '||l_api_version);
1816: debug_msg (l_module_name, ' p_usr_currency_code => '||p_CreateCashRec.usr_currency_code);
1817: debug_msg (l_module_name, ' p_currency_code => '||p_CreateCashRec.currency_code);
1818: debug_msg (l_module_name, ' p_usr_exchange_rate_type => '||p_CreateCashRec.usr_exchange_rate_type);

Line 1864: -- Call API ar_receipt_api_pub.Create_cash to create a Cash Receipt --

1860: debug_msg (l_module_name, ' p_issuer_bank_branch_id => '||p_CreateCashRec.issuer_bank_branch_id);
1861: debug_msg (l_module_name, ' p_org_id => '||p_CreateCashRec.org_id);
1862:
1863: ----------------------------------------------------------------------
1864: -- Call API ar_receipt_api_pub.Create_cash to create a Cash Receipt --
1865: -- using the record p_CreateCashRec. --
1866: ----------------------------------------------------------------------
1867: log_msg (l_module_name,'Creating a Cash Receipt '||p_CreateCashRec.receipt_number);
1868: ar_receipt_api_pub.Create_cash

Line 1868: ar_receipt_api_pub.Create_cash

1864: -- Call API ar_receipt_api_pub.Create_cash to create a Cash Receipt --
1865: -- using the record p_CreateCashRec. --
1866: ----------------------------------------------------------------------
1867: log_msg (l_module_name,'Creating a Cash Receipt '||p_CreateCashRec.receipt_number);
1868: ar_receipt_api_pub.Create_cash
1869: (
1870: p_api_version => l_api_version,
1871: p_init_msg_list => FND_API.G_TRUE,
1872: p_commit => FND_API.G_FALSE,

Line 1921: debug_msg (l_module_name, 'After Calling API ar_receipt_api_pub.Create_cash (Return Values)');

1917: p_cr_id => p_CashReceiptId,
1918: p_org_id => p_CreateCashRec.org_id
1919: );
1920:
1921: debug_msg (l_module_name, 'After Calling API ar_receipt_api_pub.Create_cash (Return Values)');
1922: debug_msg (l_module_name, ' p_cr_id => '||p_CashReceiptId);
1923: debug_msg (l_module_name, ' x_return_status => '||l_ReturnStatus);
1924: debug_msg (l_module_name, ' x_msg_count => '||l_MessageCount);
1925: debug_msg (l_module_name, ' x_msg_data => '||l_MessageData);

Line 1933: p_ErrorLoc := 'After Calling API ar_receipt_api_pub.Create_cash.';

1929: ----------------------------------------------------------------------
1930: -- There is an error --
1931: ----------------------------------------------------------------------
1932: p_ErrorCode := g_FAILURE;
1933: p_ErrorLoc := 'After Calling API ar_receipt_api_pub.Create_cash.';
1934:
1935: IF (l_MessageCount = 1) THEN
1936: ----------------------------------------------------------------------
1937: -- Message Count is 1, hence the error message is in x_msg_data --