DBA Data[Home] [Help]

APPS.RCV_SLA_MRC_UPDATE_PKG dependencies on RCV_SLA_MRC_UPDATE_PKG

Line 1: PACKAGE BODY RCV_SLA_MRC_UPDATE_PKG AS

1: PACKAGE BODY RCV_SLA_MRC_UPDATE_PKG AS
2: /* $Header: RCVPUMCB.pls 120.4 2006/04/24 00:00 bigoyal noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'RCV_SLA_MRC_UPDATE_PKG';
5: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;

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

1: PACKAGE BODY RCV_SLA_MRC_UPDATE_PKG AS
2: /* $Header: RCVPUMCB.pls 120.4 2006/04/24 00:00 bigoyal noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'RCV_SLA_MRC_UPDATE_PKG';
5: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
6: gUserId number := nvl(fnd_global.user_id, -888);
7: gLoginId number := nvl(fnd_global.login_id, -888);
8: gUpdateDate DATE := sysdate;

Line 35: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.RCV_SLA_MRC_UPDATE_PKG.Update_Receiving_MRC_Subledger';

31: IS
32: l_upg_batch_id number(15):=0;
33: l_je_category_name varchar2(30);
34:
35: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.RCV_SLA_MRC_UPDATE_PKG.Update_Receiving_MRC_Subledger';
36:
37: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
38: fnd_log.TEST(fnd_log.level_unexpected, l_module);
39: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;

Line 52: 'Entering RCV_SLA_MRC_UPDATE_PKG.Update_Receiving_MRC_Subledger with '||

48: IF l_plog THEN
49: fnd_log.string(
50: fnd_log.level_procedure,
51: l_module||'.'||l_stmt_num,
52: 'Entering RCV_SLA_MRC_UPDATE_PKG.Update_Receiving_MRC_Subledger with '||
53: 'X_upg_batch_id = '||X_upg_batch_id||','||
54: 'X_je_category_name = '||X_je_category_name
55: );
56: END IF;

Line 340: 'Exiting RCV_SLA_MRC_UPDATE_PKG.Update_Receiving_MRC_Subledger with '||

336: IF l_plog THEN
337: fnd_log.string(
338: fnd_log.level_procedure,
339: l_module||'.end',
340: 'Exiting RCV_SLA_MRC_UPDATE_PKG.Update_Receiving_MRC_Subledger with '||
341: 'X_errbuf = '||X_errbuf||','||
342: 'X_retcode = '||X_retcode
343: );
344: END IF;

Line 353: p_pkg_name => 'RCV_SLA_MRC_UPDATE_PKG',

349: ROLLBACK;
350: X_retcode := FND_API.g_ret_sts_unexp_error;
351: IF l_exceptionlog THEN
352: fnd_msg_pub.add_exc_msg(
353: p_pkg_name => 'RCV_SLA_MRC_UPDATE_PKG',
354: p_procedure_name => 'Update_Receiving_MRC_Subledger',
355: p_error_text => 'An exception has occurred.'
356: );
357: fnd_log.string(

Line 396: END RCV_SLA_MRC_UPDATE_PKG;

392:
393: end Update_Receiving_MRC_Subledger;
394:
395:
396: END RCV_SLA_MRC_UPDATE_PKG;