DBA Data[Home] [Help]

APPS.GML_RCV_DB_COMMON dependencies on GML_RCV_DB_COMMON

Line 1: PACKAGE BODY GML_RCV_DB_COMMON AS

1: PACKAGE BODY GML_RCV_DB_COMMON AS
2: /* $Header: GMLRCVCB.pls 120.2 2006/03/02 10:36:40 pbamb noship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) :='GML_RCV_DB_COMMON';

3:
4: -- Read the profile option that enables/disables the debug log
5: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30) :='GML_RCV_DB_COMMON';
8: g_module_prefix CONSTANT VARCHAR2(40) := 'gml.plsql.' || g_pkg_name || '.';
9:
10: /*##########################################################################
11: #

Line 231: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);

227:
228: EXCEPTION
229: WHEN OTHERS THEN
230: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
231: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
232: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
233: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
234: FND_MSG_PUB.ADD;
235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 254: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);

250:
251: EXCEPTION
252: WHEN OTHERS THEN
253: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
254: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
255: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
256: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
257: FND_MSG_PUB.ADD;
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 280: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);

276:
277: EXCEPTION
278: WHEN OTHERS THEN
279: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
280: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
281: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
282: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
283: FND_MSG_PUB.ADD;
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 327: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);

323:
324: EXCEPTION
325: WHEN OTHERS THEN
326: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
327: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
328: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
329: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
330: FND_MSG_PUB.ADD;
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 553: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);

549:
550: WHEN OTHERS THEN
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
553: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
554: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
555: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
556: FND_MSG_PUB.ADD;
557: /* Bug 4502018 */

Line 755: END GML_RCV_DB_COMMON;

751:
752: END VALIDATE_IO_LOT_QUANTITIES;
753:
754:
755: END GML_RCV_DB_COMMON;