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.

[Home] [Help]

APPS.CST_EAMCOST_PUB dependencies on FND_LOG

Line 5: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY CST_eamCost_PUB AS
2: /* $Header: CSTPEACB.pls 120.50.12020000.5 2013/02/06 10:01:17 zazeng ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_eamCost_PUB';
5: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: PG_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
7:
8: PROCEDURE debug
9: ( line IN VARCHAR2,

Line 12: msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT)

8: PROCEDURE debug
9: ( line IN VARCHAR2,
10: msg_prefix IN VARCHAR2 DEFAULT 'CST',
11: msg_module IN VARCHAR2 DEFAULT 'CST_EAMCOST_PUB',
12: msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT)
13: IS
14: l_msg_prefix VARCHAR2(64);
15: l_msg_level NUMBER;
16: l_msg_module VARCHAR2(256);

Line 26: l_msg_level := FND_LOG.LEVEL_EXCEPTION;

22: l_msg_prefix := msg_prefix;
23: l_msg_level := msg_level;
24: l_msg_module := msg_module;
25: IF (INSTRB(upper(l_line), 'EXCEPTION') <> 0) THEN
26: l_msg_level := FND_LOG.LEVEL_EXCEPTION;
27: END IF;
28: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND PG_DEBUG = 'N' THEN
29: RETURN;
30: END IF;

Line 28: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND PG_DEBUG = 'N' THEN

24: l_msg_module := msg_module;
25: IF (INSTRB(upper(l_line), 'EXCEPTION') <> 0) THEN
26: l_msg_level := FND_LOG.LEVEL_EXCEPTION;
27: END IF;
28: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND PG_DEBUG = 'N' THEN
29: RETURN;
30: END IF;
31: IF ( l_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
32: FND_LOG.STRING(l_msg_level, l_msg_module, SUBSTRB(l_line,1,4000));

Line 31: IF ( l_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

27: END IF;
28: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND PG_DEBUG = 'N' THEN
29: RETURN;
30: END IF;
31: IF ( l_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
32: FND_LOG.STRING(l_msg_level, l_msg_module, SUBSTRB(l_line,1,4000));
33: END IF;
34: EXCEPTION
35: WHEN OTHERS THEN RAISE;

Line 32: FND_LOG.STRING(l_msg_level, l_msg_module, SUBSTRB(l_line,1,4000));

28: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND PG_DEBUG = 'N' THEN
29: RETURN;
30: END IF;
31: IF ( l_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
32: FND_LOG.STRING(l_msg_level, l_msg_module, SUBSTRB(l_line,1,4000));
33: END IF;
34: EXCEPTION
35: WHEN OTHERS THEN RAISE;
36: END debug;

Line 10165: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED>=G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

10161: /* 2- PROCEDURE */
10162: /* 1- STATEMENT */
10163:
10164:
10165: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED>=G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
10166: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
10167: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
10168:
10169: l_cnt_cebba NUMBER;

Line 10166: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

10162: /* 1- STATEMENT */
10163:
10164:
10165: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED>=G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
10166: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
10167: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
10168:
10169: l_cnt_cebba NUMBER;
10170: l_stmt_num NUMBER;

Line 10167: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

10163:
10164:
10165: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED>=G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
10166: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
10167: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
10168:
10169: l_cnt_cebba NUMBER;
10170: l_stmt_num NUMBER;
10171:

Line 10177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

10173: -- Standard Start of API savepoint
10174: SAVEPOINT Insert_eamBalAcct_PUB;
10175:
10176: if( l_pLog ) then
10177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
10178: l_module || '.begin',
10179: 'Start of ' || l_full_name || '(' ||
10180: 'p_user_id=' || p_user_id || ',' ||
10181: 'p_login_id=' || p_login_id ||',' ||

Line 10299: FND_LOG.STRING(

10295:
10296:
10297: /* Procedure level log message for Exit point */
10298: IF (l_pLog) THEN
10299: FND_LOG.STRING(
10300: FND_LOG.LEVEL_PROCEDURE,
10301: l_module || '.end',
10302: 'End of ' || l_full_name
10303: );

Line 10300: FND_LOG.LEVEL_PROCEDURE,

10296:
10297: /* Procedure level log message for Exit point */
10298: IF (l_pLog) THEN
10299: FND_LOG.STRING(
10300: FND_LOG.LEVEL_PROCEDURE,
10301: l_module || '.end',
10302: 'End of ' || l_full_name
10303: );
10304: END IF;

Line 10318: FND_LOG.STRING(

10314: ROLLBACK TO Insert_eamBalAcct_PUB;
10315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10316:
10317: IF (l_uLog) THEN
10318: FND_LOG.STRING(
10319: FND_LOG.LEVEL_UNEXPECTED,
10320: l_module || '.' || l_stmt_num ,
10321: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB(SQLERRM , 1 , 240)
10322: );

Line 10319: FND_LOG.LEVEL_UNEXPECTED,

10315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10316:
10317: IF (l_uLog) THEN
10318: FND_LOG.STRING(
10319: FND_LOG.LEVEL_UNEXPECTED,
10320: l_module || '.' || l_stmt_num ,
10321: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB(SQLERRM , 1 , 240)
10322: );
10323: END IF;

Line 10334: FND_LOG.STRING(

10330: ROLLBACK TO Insert_eamBalAcct_PUB;
10331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10332:
10333: IF (l_uLog) THEN
10334: FND_LOG.STRING(
10335: FND_LOG.LEVEL_UNEXPECTED,
10336: l_module || '.' || l_stmt_num ,
10337: l_full_name || '( '|| l_stmt_num || ') :' || SUBSTRB(SQLERRM , 1 , 240)
10338: );

Line 10335: FND_LOG.LEVEL_UNEXPECTED,

10331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10332:
10333: IF (l_uLog) THEN
10334: FND_LOG.STRING(
10335: FND_LOG.LEVEL_UNEXPECTED,
10336: l_module || '.' || l_stmt_num ,
10337: l_full_name || '( '|| l_stmt_num || ') :' || SUBSTRB(SQLERRM , 1 , 240)
10338: );
10339: END IF;

Line 10385: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED>=G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

10381:
10382: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
10383: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
10384:
10385: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED>=G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
10386: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
10387:
10388: l_stmt_num NUMBER;
10389: BEGIN

Line 10386: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

10382: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
10383: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
10384:
10385: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED>=G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
10386: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
10387:
10388: l_stmt_num NUMBER;
10389: BEGIN
10390: -- Standard Start of API savepoint

Line 10406: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

10402: FND_MSG_PUB.initialize;
10403: END IF;
10404:
10405: if( l_pLog ) then
10406: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
10407: l_module || '.begin', 'Start of ' || l_full_name );
10408: end if;
10409:
10410:

Line 10429: FND_LOG.STRING(

10425: END IF;
10426:
10427: /* Procedure level log message for Exit point */
10428: IF (l_pLog) THEN
10429: FND_LOG.STRING(
10430: FND_LOG.LEVEL_PROCEDURE,
10431: l_module || '.end',
10432: 'End of ' || l_full_name
10433: );

Line 10430: FND_LOG.LEVEL_PROCEDURE,

10426:
10427: /* Procedure level log message for Exit point */
10428: IF (l_pLog) THEN
10429: FND_LOG.STRING(
10430: FND_LOG.LEVEL_PROCEDURE,
10431: l_module || '.end',
10432: 'End of ' || l_full_name
10433: );
10434: END IF;

Line 10448: FND_LOG.STRING(

10444: ROLLBACK TO Delete_eamBalAcct_PUB;
10445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10446:
10447: IF (l_uLog) THEN
10448: FND_LOG.STRING(
10449: FND_LOG.LEVEL_UNEXPECTED,
10450: l_module || '.' || l_stmt_num ,
10451: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240));
10452: END IF;

Line 10449: FND_LOG.LEVEL_UNEXPECTED,

10445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10446:
10447: IF (l_uLog) THEN
10448: FND_LOG.STRING(
10449: FND_LOG.LEVEL_UNEXPECTED,
10450: l_module || '.' || l_stmt_num ,
10451: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240));
10452: END IF;
10453:

Line 10463: FND_LOG.STRING(

10459: ROLLBACK TO Delete_eamBalAcct_PUB;
10460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10461:
10462: IF (l_uLog) THEN
10463: FND_LOG.STRING(
10464: FND_LOG.LEVEL_UNEXPECTED,
10465: l_module || '.' || l_stmt_num,
10466: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240));
10467: END IF;

Line 10464: FND_LOG.LEVEL_UNEXPECTED,

10460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10461:
10462: IF (l_uLog) THEN
10463: FND_LOG.STRING(
10464: FND_LOG.LEVEL_UNEXPECTED,
10465: l_module || '.' || l_stmt_num,
10466: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240));
10467: END IF;
10468:

Line 10502: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED>=G_LOG_LEVEL

10498:
10499: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
10500: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
10501:
10502: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED>=G_LOG_LEVEL
10503: AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
10504: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
10505:
10506: l_stmt_num NUMBER;

Line 10503: AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

10499: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
10500: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
10501:
10502: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED>=G_LOG_LEVEL
10503: AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
10504: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
10505:
10506: l_stmt_num NUMBER;
10507:

Line 10504: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

10500: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
10501:
10502: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED>=G_LOG_LEVEL
10503: AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
10504: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
10505:
10506: l_stmt_num NUMBER;
10507:
10508: l_is_shared_proc varchar2(1);

Line 10563: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

10559: FND_MSG_PUB.initialize;
10560: END IF;
10561:
10562: IF( l_pLog ) THEN
10563: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
10564: l_module || '.begin', 'Start of ' || l_full_name );
10565: END IF;
10566:
10567: -- Initialize API return status to success

Line 10946: FND_LOG.STRING(

10942: END IF;
10943:
10944: /* Procedure level log message for Exit point */
10945: IF (l_pLog) THEN
10946: FND_LOG.STRING(
10947: FND_LOG.LEVEL_PROCEDURE,
10948: l_module || '.end',
10949: 'End of ' || l_full_name
10950: );

Line 10947: FND_LOG.LEVEL_PROCEDURE,

10943:
10944: /* Procedure level log message for Exit point */
10945: IF (l_pLog) THEN
10946: FND_LOG.STRING(
10947: FND_LOG.LEVEL_PROCEDURE,
10948: l_module || '.end',
10949: 'End of ' || l_full_name
10950: );
10951: END IF;

Line 10965: FND_LOG.STRING(

10961: ROLLBACK TO Insert_tempEstimateDetails_PUB;
10962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10963:
10964: IF (l_uLog) THEN
10965: FND_LOG.STRING(
10966: FND_LOG.LEVEL_UNEXPECTED,
10967: l_module || '.' || l_stmt_num ,
10968: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240));
10969: END IF;

Line 10966: FND_LOG.LEVEL_UNEXPECTED,

10962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10963:
10964: IF (l_uLog) THEN
10965: FND_LOG.STRING(
10966: FND_LOG.LEVEL_UNEXPECTED,
10967: l_module || '.' || l_stmt_num ,
10968: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240));
10969: END IF;
10970:

Line 10981: FND_LOG.STRING(

10977: ROLLBACK TO Insert_tempEstimateDetails_PUB;
10978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10979:
10980: IF (l_uLog) THEN
10981: FND_LOG.STRING(
10982: FND_LOG.LEVEL_UNEXPECTED,
10983: l_module || '.' || l_stmt_num,
10984: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240));
10985: END IF;

Line 10982: FND_LOG.LEVEL_UNEXPECTED,

10978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10979:
10980: IF (l_uLog) THEN
10981: FND_LOG.STRING(
10982: FND_LOG.LEVEL_UNEXPECTED,
10983: l_module || '.' || l_stmt_num,
10984: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240));
10985: END IF;
10986: