[Home] [Help]
159: already_running EXCEPTION;
160:
161: BEGIN
162:
163: -- Standard start of API savepoint
164: SAVEPOINT Match_RevenueCOGS_PVT;
165:
166: l_stmt_num := 0;
167:
172: debug(' p_high_date : '|| p_high_date);
173: debug(' p_ledger_id : '|| p_ledger_id);
174: debug(' p_neg_req_id: '|| p_neg_req_id);
175:
176: -- Standard call to check for call compatibility
177: IF NOT FND_API.Compatible_API_Call (
178: l_api_version,
179: p_api_version,
180: l_api_name,
724: l_so_count pls_integer := 0;
725:
726: BEGIN
727:
728: -- Standard start of API savepoint
729: SAVEPOINT Insert_SoIssues_PVT;
730:
731: l_stmt_num := 0;
732:
1028: BEGIN
1029: debug('Insert_RmaReceipts+');
1030: debug(' g_ledger_id :'||g_ledger_id);
1031:
1032: -- Standard start of API savepoint
1033: SAVEPOINT Insert_RmaReceipts_PVT;
1034:
1035: l_stmt_num := 0;
1036:
1723: no_crrl EXCEPTION;
1724: BEGIN
1725: debug('Create_CogsRecognitionEvents+');
1726:
1727: -- Standard start of API savepoint
1728: SAVEPOINT Create_CogsRecEvents_PVT;
1729:
1730: l_stmt_num := 0;
1731:
2625: debug(' p_cost_group_id : '||p_cost_group_id);
2626: debug(' p_quantity : '||p_quantity);
2627:
2628:
2629: -- Standard start of API savepoint
2630: SAVEPOINT Insert_OneSoIssue_PVT;
2631:
2632: l_stmt_num := 0;
2633: debug(l_stmt_num);
2631:
2632: l_stmt_num := 0;
2633: debug(l_stmt_num);
2634:
2635: -- Standard call to check for call compatibility
2636: IF NOT FND_API.Compatible_API_Call (
2637: l_api_version,
2638: p_api_version,
2639: l_api_name,
2950: debug(' p_organization_id : '||p_organization_id);
2951: debug(' p_item_id : '||p_item_id);
2952: debug(' p_transaction_date : '||to_char(p_transaction_date,'MM-DD-YYYY'));
2953: debug(' p_quantity : '||p_quantity);
2954: -- Standard start of API savepoint
2955: SAVEPOINT Insert_OneRmaReceipt_PVT;
2956:
2957: l_stmt_num := 0;
2958: debug(l_stmt_num);
2956:
2957: l_stmt_num := 0;
2958: debug(l_stmt_num);
2959:
2960: -- Standard call to check for call compatibility
2961: IF NOT FND_API.Compatible_API_Call (
2962: l_api_version,
2963: p_api_version,
2964: l_api_name,
3422: -- PROCEDURE --
3423: -- Record_SoIssueCost --
3424: -- This procedure is called by the distribution processors to --
3425: -- record the outgoing cost of the item at the time of the sales --
3426: -- order issue. The logic is standard across cost methods so --
3427: -- it can be called for all perpetual and PAC types. --
3428: -- --
3429: -- VERSION 1.0 --
3430: -- --
3481: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3482:
3483: BEGIN
3484:
3485: -- Standard start of API savepoint
3486: SAVEPOINT Record_SoIssueCost_PVT;
3487:
3488: l_stmt_num := 0;
3489:
3502: 'p_txn_quantity = '||p_txn_quantity
3503: );
3504: END IF;
3505:
3506: -- Standard call to check for call compatibility
3507: IF NOT FND_API.Compatible_API_Call (
3508: l_api_version,
3509: p_api_version,
3510: l_api_name,
3692: l_accounting_created NUMBER;
3693:
3694: BEGIN
3695:
3696: -- Standard start of API savepoint
3697: SAVEPOINT Process_RmaReceipt_PVT;
3698:
3699: l_stmt_num := 0;
3700:
3954: -- VERSION 1.0 --
3955: -- --
3956: -- PARAMETERS --
3957: -- P_COGS_OM_LINE_ID OM Line_ID of the Sales Order issue --
3958: -- All other parameters are pretty standard for Cost Processing --
3959: -- --
3960: -- HISTORY: --
3961: -- 05/17/05 Bryan Kuntz Created --
3962: -- End of comments --
4011: l_err_msg VARCHAR2(240);
4012:
4013: BEGIN
4014:
4015: -- Standard start of API savepoint
4016: SAVEPOINT Process_CogsRecognitionTxn_PVT;
4017:
4018: l_stmt_num := 0;
4019:
4160: -- --
4161: -- VERSION 1.0 --
4162: -- --
4163: -- PARAMETERS --
4164: -- Standard return status and Who columns --
4165: -- --
4166: -- HISTORY: --
4167: -- 05/17/05 Bryan Kuntz Created --
4168: -- End of comments --
4289: l_last_fetch BOOLEAN;
4290: end_of_program EXCEPTION;
4291: BEGIN
4292:
4293: -- Standard start of API savepoint
4294: SAVEPOINT Cost_BulkCogsRecTxns_PVT;
4295:
4296: l_stmt_num := 0;
4297:
4684: l_cost NUMBER;/*bug 9146453*/
4685:
4686: BEGIN
4687:
4688: -- Standard start of API savepoint
4689: SAVEPOINT Insert_PacSoIssue_PVT;
4690:
4691: l_stmt_num := 0;
4692:
4700: 'p_cost_group_id = '||p_cost_group_id
4701: );
4702: END IF;
4703:
4704: -- Standard call to check for call compatibility
4705: IF NOT FND_API.Compatible_API_Call (
4706: l_api_version,
4707: p_api_version,
4708: l_api_name,
4955: l_cogs_acct_id NUMBER;
4956:
4957: BEGIN
4958:
4959: -- Standard start of API savepoint
4960: SAVEPOINT Process_PacRmaReceipt_PVT;
4961:
4962: l_stmt_num := 0;
4963:
5145:
5146:
5147: BEGIN
5148:
5149: -- Standard start of API savepoint
5150: SAVEPOINT Process_PacCogsRecTxn_PVT;
5151:
5152: l_stmt_num := 0;
5153:
5445: -- Initialize message stack
5446:
5447: fnd_msg_pub.initialize;
5448:
5449: -- Standard call to get message count and if count is 1, get message info.
5450:
5451: fnd_msg_pub.Count_And_Get
5452: ( p_count => l_msg_count,
5453: p_data => l_msg_data
5452: ( p_count => l_msg_count,
5453: p_data => l_msg_data
5454: );
5455:
5456: -- Standard call to check the API version
5457:
5458: if(not fnd_api.Compatible_API_Call( l_api_version,
5459: p_api_version,
5460: l_api_name,
5501: i_all_lines => p_all_lines,
5502: i_amt_tolerance => p_amt_tolerance,
5503: x_xml_doc => l_xml_doc);
5504:
5505: -- Standard call to check the return status from API called
5506:
5507: if(l_return_status <> fnd_api.G_RET_STS_SUCCESS) then
5508: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
5509: end if;
5533: i_all_lines => p_all_lines,
5534: i_amt_tolerance => p_amt_tolerance,
5535: x_xml_doc => l_xml_doc);
5536:
5537: -- Standard call to check the return status from API called
5538:
5539: if(l_return_status <> fnd_api.G_RET_STS_SUCCESS) then
5540: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
5541: end if;
5726: debug('i_all_lines = '||i_all_lines);
5727: debug('i_amt_tolerance = '||i_amt_tolerance);
5728:
5729:
5730: -- Standard call to check for call compatibility.
5731:
5732: if(not fnd_api.Compatible_API_Call ( l_api_version,
5733: p_api_version,
5734: l_api_name,
5856: close l_ref_cur;
5857:
5858: dbms_lob.freetemporary(l_xml_temp);
5859:
5860: -- Standard call to get message count and if count is 1, get message info.
5861:
5862: fnd_msg_pub.Count_And_Get
5863: ( p_count => x_msg_count,
5864: p_data => x_msg_data
6001: debug('i_sales_order_date_high = '||to_char(i_sales_order_date_high,'DD-MON-YYYY HH24:MI:SS'));
6002: debug('i_all_lines = '||i_all_lines);
6003: debug('i_amt_tolerance = '||i_amt_tolerance);
6004:
6005: -- Standard call to check for call compatibility.
6006:
6007: if(not fnd_api.Compatible_API_Call( l_api_version,
6008: p_api_version,
6009: l_api_name,
6740: dbms_xmlgen.closeContext(l_qryCtx);
6741: close l_ref_cur;
6742: dbms_lob.freetemporary(l_xml_temp);
6743:
6744: -- Standard call to get message count and if count is 1, get message info.
6745:
6746: fnd_msg_pub.Count_And_Get
6747: ( p_count => x_msg_count,
6748: p_data => x_msg_data