[Home] [Help]
1: PACKAGE BODY CST_RevenueCogsMatch_GRP AS
2: /* $Header: CSTRCMGB.pls 120.3.12010000.2 2008/08/08 12:32:44 smsasidh ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_RevenueCogsMatch_GRP';
5: G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
1: PACKAGE BODY CST_RevenueCogsMatch_GRP AS
2: /* $Header: CSTRCMGB.pls 120.3.12010000.2 2008/08/08 12:32:44 smsasidh ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_RevenueCogsMatch_GRP';
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:
8:
61:
62: l_stmt_num NUMBER := 0;
63: l_ledger_id NUMBER;
64:
65: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_RevenueCogsMatch_GRP.Receive_CloseLineEvent';
66: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
67: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
68: fnd_log.TEST(fnd_log.level_unexpected, l_module);
69: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
75: IF l_plog THEN
76: fnd_log.string(
77: fnd_log.level_procedure,
78: l_module||'.'||l_stmt_num,
79: 'Entering CST_RevenueCogsMatch_GRP.Receive_CloseLineEvent with '||
80: 'p_api_version = '||p_api_version||','||
81: 'p_revenue_event_line_id = '||p_revenue_event_line_id||','||
82: 'p_event_date = '||p_event_date||','||
83: 'p_ou_id = '||p_ou_id||','||
180: IF l_plog THEN
181: fnd_log.string(
182: fnd_log.level_procedure,
183: l_module||'.'||l_stmt_num,
184: 'Exiting CST_RevenueCogsMatch_GRP.Receive_CloseLineEvent with '||
185: 'x_return_status = '||x_return_status||','||
186: 'x_msg_count = '||x_msg_count||','||
187: 'x_msg_data = '||x_msg_data
188: );
196: END IF;
197:
198: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
199: fnd_msg_pub.add_exc_msg(
200: p_pkg_name => 'CST_RevenueCogsMatch_GRP',
201: p_procedure_name => 'Receive_CloseLineEvent',
202: p_error_text => 'Row already exists in cst_revenue_recognition_lines.'
203: );
204: END IF;
221:
222: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
223: THEN
224: fnd_msg_pub.add_exc_msg(
225: p_pkg_name => 'CST_RevenueCogsMatch_GRP',
226: p_procedure_name => 'Receive_CloseLineEvent',
227: p_error_text => 'An exception has occurred in statement '||to_char(l_stmt_num)||': '||substr(SQLERRM,1,200)
228: );
229: END IF;
292:
293: l_stmt_num NUMBER := 0;
294: l_closed_cst_periods NUMBER;
295:
296: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_RevenueCogsMatch_GRP.Return_PeriodStatuses';
297: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
298: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
299: fnd_log.TEST(fnd_log.level_unexpected, l_module);
300: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
308: IF l_plog THEN
309: fnd_log.string(
310: fnd_log.level_procedure,
311: l_module||'.'||l_stmt_num,
312: 'Entering CST_RevenueCogsMatch_GRP.Return_PeriodStatuses with '||
313: 'p_api_version = '||p_api_version||','||
314: 'p_set_of_books_id = '||p_set_of_books_id||','||
315: 'p_effective_period_num = '||p_effective_period_num
316: );
378: IF l_plog THEN
379: fnd_log.string(
380: fnd_log.level_procedure,
381: l_module||'.'||l_stmt_num,
382: 'Exiting CST_RevenueCogsMatch_GRP.Return_PeriodStatuses with '||
383: 'x_return_status = '||x_return_status||','||
384: 'x_msg_count = '||x_msg_count||','||
385: 'x_msg_data = '||x_msg_data||','||
386: 'x_closed_cst_periods = '||x_closed_cst_periods
413:
414: END Return_PeriodStatuses;
415:
416:
417: END CST_RevenueCogsMatch_GRP;