[Home] [Help]
118: l_high_date DATE;
119:
120: BEGIN
121:
122: -- Standard start of API savepoint
123: SAVEPOINT Match_RevenueCOGS_PVT;
124:
125: l_stmt_num := 0;
126:
140: 'p_high_date = '||p_high_date||','||
141: 'p_phase = '||p_phase);
142: END IF;
143: */
144: -- Standard call to check for call compatibility
145: IF NOT FND_API.Compatible_API_Call (
146: l_api_version,
147: p_api_version,
148: l_api_name,
633: l_so_count pls_integer := 0;
634:
635: BEGIN
636:
637: -- Standard start of API savepoint
638: SAVEPOINT Insert_SoIssues_PVT;
639:
640: l_stmt_num := 0;
641:
850: BEGIN
851: debug('Insert_RmaReceipts+');
852: debug(' g_ledger_id :'||g_ledger_id);
853:
854: -- Standard start of API savepoint
855: SAVEPOINT Insert_RmaReceipts_PVT;
856:
857: l_stmt_num := 0;
858:
1517: end_of_program EXCEPTION; --BUG#5726230
1518: BEGIN
1519: debug('Create_CogsRecognitionEvents+');
1520:
1521: -- Standard start of API savepoint
1522: SAVEPOINT Create_CogsRecEvents_PVT;
1523:
1524: l_stmt_num := 0;
1525:
2572: debug(' p_cost_group_id : '||p_cost_group_id);
2573: debug(' p_quantity : '||p_quantity);
2574:
2575:
2576: -- Standard start of API savepoint
2577: SAVEPOINT Insert_OneSoIssue_PVT;
2578:
2579: l_stmt_num := 0;
2580: debug(l_stmt_num);
2594: 'p_quantity = '||p_quantity
2595: );
2596: END IF;
2597: */
2598: -- Standard call to check for call compatibility
2599: IF NOT FND_API.Compatible_API_Call (
2600: l_api_version,
2601: p_api_version,
2602: l_api_name,
2912: debug(' p_organization_id : '||p_organization_id);
2913: debug(' p_item_id : '||p_item_id);
2914: debug(' p_transaction_date : '||to_char(p_transaction_date,'MM-DD-YYYY'));
2915: debug(' p_quantity : '||p_quantity);
2916: -- Standard start of API savepoint
2917: SAVEPOINT Insert_OneRmaReceipt_PVT;
2918:
2919: l_stmt_num := 0;
2920: debug(l_stmt_num);
2932: 'p_quantity = '||p_quantity
2933: );
2934: END IF;
2935: */
2936: -- Standard call to check for call compatibility
2937: IF NOT FND_API.Compatible_API_Call (
2938: l_api_version,
2939: p_api_version,
2940: l_api_name,
3389: -- PROCEDURE --
3390: -- Record_SoIssueCost --
3391: -- This procedure is called by the distribution processors to --
3392: -- record the outgoing cost of the item at the time of the sales --
3393: -- order issue. The logic is standard across cost methods so --
3394: -- it can be called for all perpetual and PAC types. --
3395: -- --
3396: -- VERSION 1.0 --
3397: -- --
3448: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3449:
3450: BEGIN
3451:
3452: -- Standard start of API savepoint
3453: SAVEPOINT Record_SoIssueCost_PVT;
3454:
3455: l_stmt_num := 0;
3456:
3469: 'p_txn_quantity = '||p_txn_quantity
3470: );
3471: END IF;
3472:
3473: -- Standard call to check for call compatibility
3474: IF NOT FND_API.Compatible_API_Call (
3475: l_api_version,
3476: p_api_version,
3477: l_api_name,
3658: program_exception EXCEPTION;
3659:
3660: BEGIN
3661:
3662: -- Standard start of API savepoint
3663: SAVEPOINT Process_RmaReceipt_PVT;
3664:
3665: l_stmt_num := 0;
3666:
3890: -- VERSION 1.0 --
3891: -- --
3892: -- PARAMETERS --
3893: -- P_COGS_OM_LINE_ID OM Line_ID of the Sales Order issue --
3894: -- All other parameters are pretty standard for Cost Processing --
3895: -- --
3896: -- HISTORY: --
3897: -- 05/17/05 Bryan Kuntz Created --
3898: -- End of comments --
3947: l_err_msg VARCHAR2(240);
3948:
3949: BEGIN
3950:
3951: -- Standard start of API savepoint
3952: SAVEPOINT Process_CogsRecognitionTxn_PVT;
3953:
3954: l_stmt_num := 0;
3955:
4096: -- --
4097: -- VERSION 1.0 --
4098: -- --
4099: -- PARAMETERS --
4100: -- Standard return status and Who columns --
4101: -- --
4102: -- HISTORY: --
4103: -- 05/17/05 Bryan Kuntz Created --
4104: -- End of comments --
4225: l_last_fetch BOOLEAN;
4226: end_of_program EXCEPTION;
4227: BEGIN
4228:
4229: -- Standard start of API savepoint
4230: SAVEPOINT Cost_BulkCogsRecTxns_PVT;
4231:
4232: l_stmt_num := 0;
4233:
4607: l_tot_cost NUMBER;
4608:
4609: BEGIN
4610:
4611: -- Standard start of API savepoint
4612: SAVEPOINT Insert_PacSoIssue_PVT;
4613:
4614: l_stmt_num := 0;
4615:
4623: 'p_cost_group_id = '||p_cost_group_id
4624: );
4625: END IF;
4626:
4627: -- Standard call to check for call compatibility
4628: IF NOT FND_API.Compatible_API_Call (
4629: l_api_version,
4630: p_api_version,
4631: l_api_name,
4849: l_cogs_acct_id NUMBER;
4850:
4851: BEGIN
4852:
4853: -- Standard start of API savepoint
4854: SAVEPOINT Process_PacRmaReceipt_PVT;
4855:
4856: l_stmt_num := 0;
4857:
5031:
5032:
5033: BEGIN
5034:
5035: -- Standard start of API savepoint
5036: SAVEPOINT Process_PacCogsRecTxn_PVT;
5037:
5038: l_stmt_num := 0;
5039:
5326: -- Initialize message stack
5327:
5328: fnd_msg_pub.initialize;
5329:
5330: -- Standard call to get message count and if count is 1, get message info.
5331:
5332: fnd_msg_pub.Count_And_Get
5333: ( p_count => l_msg_count,
5334: p_data => l_msg_data
5333: ( p_count => l_msg_count,
5334: p_data => l_msg_data
5335: );
5336:
5337: -- Standard call to check the API version
5338:
5339: if(not fnd_api.Compatible_API_Call( l_api_version,
5340: p_api_version,
5341: l_api_name,
5381: i_sales_order_date_high => p_sales_order_date_high,
5382: i_all_lines => p_all_lines,
5383: x_xml_doc => l_xml_doc);
5384:
5385: -- Standard call to check the return status from API called
5386:
5387: if(l_return_status <> fnd_api.G_RET_STS_SUCCESS) then
5388: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
5389: end if;
5412: i_sales_order_date_high => l_sales_order_date_high,
5413: i_all_lines => p_all_lines,
5414: x_xml_doc => l_xml_doc);
5415:
5416: -- Standard call to check the return status from API called
5417:
5418: if(l_return_status <> fnd_api.G_RET_STS_SUCCESS) then
5419: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
5420: end if;
5611: 'i_all_lines = '||i_all_lines
5612: );
5613: END IF;
5614:
5615: -- Standard call to check for call compatibility.
5616:
5617: if(not fnd_api.Compatible_API_Call ( l_api_version,
5618: p_api_version,
5619: l_api_name,
5739: close l_ref_cur;
5740:
5741: dbms_lob.freetemporary(l_xml_temp);
5742:
5743: -- Standard call to get message count and if count is 1, get message info.
5744:
5745: fnd_msg_pub.Count_And_Get
5746: ( p_count => x_msg_count,
5747: p_data => x_msg_data
5886: 'i_all_lines = '||i_all_lines
5887: );
5888: END IF;
5889:
5890: -- Standard call to check for call compatibility.
5891:
5892: if(not fnd_api.Compatible_API_Call( l_api_version,
5893: p_api_version,
5894: l_api_name,
6403: dbms_xmlgen.closeContext(l_qryCtx);
6404: close l_ref_cur;
6405: dbms_lob.freetemporary(l_xml_temp);
6406:
6407: -- Standard call to get message count and if count is 1, get message info.
6408:
6409: fnd_msg_pub.Count_And_Get
6410: ( p_count => x_msg_count,
6411: p_data => x_msg_data