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.CST_REVENUECOGSMATCH_PVT dependencies on CST_REVENUECOGSMATCH_PVT

Line 1: PACKAGE BODY CST_RevenueCogsMatch_PVT AS

1: PACKAGE BODY CST_RevenueCogsMatch_PVT AS
2: /* $Header: CSTRCMVB.pls 120.83.12020000.21 2013/03/01 05:37:11 vnagasow ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_RevenueCogsMatch_PVT';
5: G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_RevenueCogsMatch_PVT';

1: PACKAGE BODY CST_RevenueCogsMatch_PVT AS
2: /* $Header: CSTRCMVB.pls 120.83.12020000.21 2013/03/01 05:37:11 vnagasow ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_RevenueCogsMatch_PVT';
5: G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6: G_LOG_HEAD CONSTANT VARCHAR2(40) := 'cst.plsql.'||G_PKG_NAME;
7: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: g_module_name VARCHAR2(255) := G_LOG_HEAD;

Line 2057: CST_RevenueCogsMatch_PVT.acct_date(l_mmt_transaction_date(i),l_event_date_tbl(i)),

2053: --untouch to avoid breaking the current logic based on the CCE,CRCML,CRRL for CCE creation
2054: --If the problem is hitting the accounting unproper such as to much COGS recognized or not enough
2055: --this can be the starting point
2056: --nvl(l_alternate_event_date+EndDateNum+l_date_offset_tbl(i),l_event_date_tbl(i)),
2057: CST_RevenueCogsMatch_PVT.acct_date(l_mmt_transaction_date(i),l_event_date_tbl(i)),
2058: --l_event_date_tbl(i),
2059: --
2060: mtl_material_transactions_s.nextval,
2061: l_new_percentage_tbl(i),

Line 2136: CST_RevenueCogsMatch_PVT.acct_date(l_mmt_transaction_date(i),l_event_date_tbl(i)),

2132: l_primary_uom_tbl(i), -- Txn UOM
2133: l_event_quantity_tbl(i),
2134: --BUG#6809034
2135: --nvl(l_alternate_event_date+EndDateNum+l_date_offset_tbl(i),l_event_date_tbl(i)),
2136: CST_RevenueCogsMatch_PVT.acct_date(l_mmt_transaction_date(i),l_event_date_tbl(i)),
2137: -- This inventory accounting period will be reconciled in ensure_mmt_per_and_date
2138: -- We can use the routine inv_period_id to correct here but performance should be better in ensure_mmt_per_and_date
2139: l_acct_period_id_tbl(i),
2140: --CST_RevenueCogsMatch_PVT.inv_period_id(l_mmt_transaction_date(i),l_event_date_tbl(i),p_ledger_id,l_organization_id_tbl(i),l_acct_period_id_tbl(i)),

Line 2140: --CST_RevenueCogsMatch_PVT.inv_period_id(l_mmt_transaction_date(i),l_event_date_tbl(i),p_ledger_id,l_organization_id_tbl(i),l_acct_period_id_tbl(i)),

2136: CST_RevenueCogsMatch_PVT.acct_date(l_mmt_transaction_date(i),l_event_date_tbl(i)),
2137: -- This inventory accounting period will be reconciled in ensure_mmt_per_and_date
2138: -- We can use the routine inv_period_id to correct here but performance should be better in ensure_mmt_per_and_date
2139: l_acct_period_id_tbl(i),
2140: --CST_RevenueCogsMatch_PVT.inv_period_id(l_mmt_transaction_date(i),l_event_date_tbl(i),p_ledger_id,l_organization_id_tbl(i),l_acct_period_id_tbl(i)),
2141: --}
2142: l_cogs_acct_id_tbl(i),
2143: decode(l_opm_org_flg_tbl(i), 'N', 'N', NULL),
2144: decode(l_opm_org_flg_tbl(i), 'Y', 'N', NULL),

Line 6811: fnd_file.put_line(fnd_file.log, 'CST_RevenueCogsMatch_PVT:'||l_line);

6807: l_msg_level := msg_level;
6808: l_msg_module := msg_module;
6809:
6810: IF g_mrp_debug = 'Y' THEN
6811: fnd_file.put_line(fnd_file.log, 'CST_RevenueCogsMatch_PVT:'||l_line);
6812: ELSIF (INSTRB(upper(l_line), 'EXCEPTION') <> 0) THEN
6813: fnd_file.put_line(fnd_file.log, 'CST_RevenueCogsMatch_PVT:'||l_line);
6814: END IF;
6815:

Line 6813: fnd_file.put_line(fnd_file.log, 'CST_RevenueCogsMatch_PVT:'||l_line);

6809:
6810: IF g_mrp_debug = 'Y' THEN
6811: fnd_file.put_line(fnd_file.log, 'CST_RevenueCogsMatch_PVT:'||l_line);
6812: ELSIF (INSTRB(upper(l_line), 'EXCEPTION') <> 0) THEN
6813: fnd_file.put_line(fnd_file.log, 'CST_RevenueCogsMatch_PVT:'||l_line);
6814: END IF;
6815:
6816: IF (INSTRB(upper(l_line), 'EXCEPTION') <> 0) THEN
6817: l_msg_level := FND_LOG.LEVEL_EXCEPTION;

Line 6992: fnd_message.set_token('PACKAGE', 'CST_REVENUECOGSMATCH_PVT');

6988: IF next_inv_period%ISOPEN THEN CLOSE next_inv_period; END IF;
6989: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6990: debug('OTHERS EXCEPTION ensure_mmt_per_and_date:'||SQLERRM);
6991: fnd_message.set_name('BOM', 'CST_UNEXP_ERROR');
6992: fnd_message.set_token('PACKAGE', 'CST_REVENUECOGSMATCH_PVT');
6993: fnd_message.set_token('PROCEDURE','ensure_mmt_per_and_date');
6994: fnd_message.set_token('STATEMENT',to_char(l_stmt_num));
6995: fnd_msg_pub.ADD;
6996: fnd_msg_pub.count_and_get(

Line 7734: ,CST_RevenueCogsMatch_PVT.acct_date_per

7730: ,DECODE(closing_status,'F'
7731: ,DECODE(adjustment_period_flag
7732: ,'Y','C','F')
7733: ,closing_status) VARCHAR_1
7734: ,CST_RevenueCogsMatch_PVT.acct_date_per
7735: (ledger_id
7736: ,closing_status
7737: ,effective_period_num
7738: ,start_date

Line 7740: ,CST_RevenueCogsMatch_PVT.acct_date_per

7736: ,closing_status
7737: ,effective_period_num
7738: ,start_date
7739: ,'PERIOD') LIST_ID
7740: ,CST_RevenueCogsMatch_PVT.acct_date_per
7741: (ledger_id
7742: ,closing_status
7743: ,effective_period_num
7744: ,start_date

Line 7936: END CST_RevenueCogsMatch_PVT;

7932: CLOSE c;
7933: RETURN l_return;
7934: END;
7935:
7936: END CST_RevenueCogsMatch_PVT;