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_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.32.12010000.4 2009/01/19 12:25:04 lchevala 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:
7:
8: /* ======================================================================= */
9: -- PROCEDURE

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

9448: /* 2- PROCEDURE */
9449: /* 1- STATEMENT */
9450:
9451:
9452: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED>=G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
9453: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
9454: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
9455:
9456: l_cnt_cebba NUMBER;

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

9449: /* 1- STATEMENT */
9450:
9451:
9452: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED>=G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
9453: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
9454: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
9455:
9456: l_cnt_cebba NUMBER;
9457: l_stmt_num NUMBER;

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

9450:
9451:
9452: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED>=G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
9453: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
9454: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
9455:
9456: l_cnt_cebba NUMBER;
9457: l_stmt_num NUMBER;
9458:

Line 9464: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

9460: -- Standard Start of API savepoint
9461: SAVEPOINT Insert_eamBalAcct_PUB;
9462:
9463: if( l_pLog ) then
9464: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
9465: l_module || '.begin',
9466: 'Start of ' || l_full_name || '(' ||
9467: 'p_user_id=' || p_user_id || ',' ||
9468: 'p_login_id=' || p_login_id ||',' ||

Line 9586: FND_LOG.STRING(

9582:
9583:
9584: /* Procedure level log message for Exit point */
9585: IF (l_pLog) THEN
9586: FND_LOG.STRING(
9587: FND_LOG.LEVEL_PROCEDURE,
9588: l_module || '.end',
9589: 'End of ' || l_full_name
9590: );

Line 9587: FND_LOG.LEVEL_PROCEDURE,

9583:
9584: /* Procedure level log message for Exit point */
9585: IF (l_pLog) THEN
9586: FND_LOG.STRING(
9587: FND_LOG.LEVEL_PROCEDURE,
9588: l_module || '.end',
9589: 'End of ' || l_full_name
9590: );
9591: END IF;

Line 9605: FND_LOG.STRING(

9601: ROLLBACK TO Insert_eamBalAcct_PUB;
9602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9603:
9604: IF (l_uLog) THEN
9605: FND_LOG.STRING(
9606: FND_LOG.LEVEL_UNEXPECTED,
9607: l_module || '.' || l_stmt_num ,
9608: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB(SQLERRM , 1 , 240)
9609: );

Line 9606: FND_LOG.LEVEL_UNEXPECTED,

9602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9603:
9604: IF (l_uLog) THEN
9605: FND_LOG.STRING(
9606: FND_LOG.LEVEL_UNEXPECTED,
9607: l_module || '.' || l_stmt_num ,
9608: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB(SQLERRM , 1 , 240)
9609: );
9610: END IF;

Line 9621: FND_LOG.STRING(

9617: ROLLBACK TO Insert_eamBalAcct_PUB;
9618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9619:
9620: IF (l_uLog) THEN
9621: FND_LOG.STRING(
9622: FND_LOG.LEVEL_UNEXPECTED,
9623: l_module || '.' || l_stmt_num ,
9624: l_full_name || '( '|| l_stmt_num || ') :' || SUBSTRB(SQLERRM , 1 , 240)
9625: );

Line 9622: FND_LOG.LEVEL_UNEXPECTED,

9618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9619:
9620: IF (l_uLog) THEN
9621: FND_LOG.STRING(
9622: FND_LOG.LEVEL_UNEXPECTED,
9623: l_module || '.' || l_stmt_num ,
9624: l_full_name || '( '|| l_stmt_num || ') :' || SUBSTRB(SQLERRM , 1 , 240)
9625: );
9626: END IF;

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

9668:
9669: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
9670: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
9671:
9672: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED>=G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
9673: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
9674:
9675: l_stmt_num NUMBER;
9676: BEGIN

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

9669: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
9670: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
9671:
9672: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED>=G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
9673: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
9674:
9675: l_stmt_num NUMBER;
9676: BEGIN
9677: -- Standard Start of API savepoint

Line 9693: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

9689: FND_MSG_PUB.initialize;
9690: END IF;
9691:
9692: if( l_pLog ) then
9693: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
9694: l_module || '.begin', 'Start of ' || l_full_name );
9695: end if;
9696:
9697:

Line 9716: FND_LOG.STRING(

9712: END IF;
9713:
9714: /* Procedure level log message for Exit point */
9715: IF (l_pLog) THEN
9716: FND_LOG.STRING(
9717: FND_LOG.LEVEL_PROCEDURE,
9718: l_module || '.end',
9719: 'End of ' || l_full_name
9720: );

Line 9717: FND_LOG.LEVEL_PROCEDURE,

9713:
9714: /* Procedure level log message for Exit point */
9715: IF (l_pLog) THEN
9716: FND_LOG.STRING(
9717: FND_LOG.LEVEL_PROCEDURE,
9718: l_module || '.end',
9719: 'End of ' || l_full_name
9720: );
9721: END IF;

Line 9735: FND_LOG.STRING(

9731: ROLLBACK TO Delete_eamBalAcct_PUB;
9732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9733:
9734: IF (l_uLog) THEN
9735: FND_LOG.STRING(
9736: FND_LOG.LEVEL_UNEXPECTED,
9737: l_module || '.' || l_stmt_num ,
9738: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240));
9739: END IF;

Line 9736: FND_LOG.LEVEL_UNEXPECTED,

9732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9733:
9734: IF (l_uLog) THEN
9735: FND_LOG.STRING(
9736: FND_LOG.LEVEL_UNEXPECTED,
9737: l_module || '.' || l_stmt_num ,
9738: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240));
9739: END IF;
9740:

Line 9750: FND_LOG.STRING(

9746: ROLLBACK TO Delete_eamBalAcct_PUB;
9747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9748:
9749: IF (l_uLog) THEN
9750: FND_LOG.STRING(
9751: FND_LOG.LEVEL_UNEXPECTED,
9752: l_module || '.' || l_stmt_num,
9753: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240));
9754: END IF;

Line 9751: FND_LOG.LEVEL_UNEXPECTED,

9747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9748:
9749: IF (l_uLog) THEN
9750: FND_LOG.STRING(
9751: FND_LOG.LEVEL_UNEXPECTED,
9752: l_module || '.' || l_stmt_num,
9753: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240));
9754: END IF;
9755:

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

9785:
9786: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
9787: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
9788:
9789: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED>=G_LOG_LEVEL
9790: AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
9791: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
9792:
9793: l_stmt_num NUMBER;

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

9786: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
9787: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
9788:
9789: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED>=G_LOG_LEVEL
9790: AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
9791: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
9792:
9793: l_stmt_num NUMBER;
9794:

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

9787: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
9788:
9789: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED>=G_LOG_LEVEL
9790: AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
9791: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
9792:
9793: l_stmt_num NUMBER;
9794:
9795: l_is_shared_proc varchar2(1);

Line 9850: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

9846: FND_MSG_PUB.initialize;
9847: END IF;
9848:
9849: IF( l_pLog ) THEN
9850: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
9851: l_module || '.begin', 'Start of ' || l_full_name );
9852: END IF;
9853:
9854: -- Initialize API return status to success

Line 10233: FND_LOG.STRING(

10229: END IF;
10230:
10231: /* Procedure level log message for Exit point */
10232: IF (l_pLog) THEN
10233: FND_LOG.STRING(
10234: FND_LOG.LEVEL_PROCEDURE,
10235: l_module || '.end',
10236: 'End of ' || l_full_name
10237: );

Line 10234: FND_LOG.LEVEL_PROCEDURE,

10230:
10231: /* Procedure level log message for Exit point */
10232: IF (l_pLog) THEN
10233: FND_LOG.STRING(
10234: FND_LOG.LEVEL_PROCEDURE,
10235: l_module || '.end',
10236: 'End of ' || l_full_name
10237: );
10238: END IF;

Line 10252: FND_LOG.STRING(

10248: ROLLBACK TO Insert_tempEstimateDetails_PUB;
10249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10250:
10251: IF (l_uLog) THEN
10252: FND_LOG.STRING(
10253: FND_LOG.LEVEL_UNEXPECTED,
10254: l_module || '.' || l_stmt_num ,
10255: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240));
10256: END IF;

Line 10253: FND_LOG.LEVEL_UNEXPECTED,

10249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10250:
10251: IF (l_uLog) THEN
10252: FND_LOG.STRING(
10253: FND_LOG.LEVEL_UNEXPECTED,
10254: l_module || '.' || l_stmt_num ,
10255: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240));
10256: END IF;
10257:

Line 10268: FND_LOG.STRING(

10264: ROLLBACK TO Insert_tempEstimateDetails_PUB;
10265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10266:
10267: IF (l_uLog) THEN
10268: FND_LOG.STRING(
10269: FND_LOG.LEVEL_UNEXPECTED,
10270: l_module || '.' || l_stmt_num,
10271: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240));
10272: END IF;

Line 10269: FND_LOG.LEVEL_UNEXPECTED,

10265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10266:
10267: IF (l_uLog) THEN
10268: FND_LOG.STRING(
10269: FND_LOG.LEVEL_UNEXPECTED,
10270: l_module || '.' || l_stmt_num,
10271: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240));
10272: END IF;
10273: