APPS.IEX_CASE_OBJECTS_PKG dependencies on IEX_CASE_OBJECTS_PKG

Line 1: package body IEX_CASE_OBJECTS_PKG as

1: package body IEX_CASE_OBJECTS_PKG as
2: /* $Header: iextcobb.pls 120.0 2004/01/24 03:21:23 appldev noship $ */
3: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
4: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:

Line 45: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_OBJECTS_PKG.INSERT_ROW ******** ');

41: where CASE_OBJECT_ID = X_CASE_OBJECT_ID ;
42: begin
43: -- IF PG_DEBUG < 10 THEN
44: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
45: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_OBJECTS_PKG.INSERT_ROW ******** ');
46: END IF;
47: INSERT INTO IEX_CASE_OBJECTS(
48: CASE_OBJECT_ID,
49: object_id,

Line 126: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_OBJECTS_PKG.INSERT_ROW ******** ');

122: end if;
123: close c;
124: -- IF PG_DEBUG < 10 THEN
125: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
126: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_OBJECTS_PKG.INSERT_ROW ******** ');
127: END IF;
128: End Insert_Row;
129:
130: PROCEDURE Update_Row(

Line 163: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_OBJECTS_PKG.UPDATE_ROW ******** ');

159: X_LAST_UPDATE_LOGIN in NUMBER) is
160: BEGIN
161: -- IF PG_DEBUG < 10 THEN
162: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
163: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_OBJECTS_PKG.UPDATE_ROW ******** ');
164: END IF;
165: Update IEX_CASE_OBJECTS
166: SET
167: object_id = decode( x_object_id, FND_API.G_MISS_NUM, object_id, x_object_id),

Line 202: IEX_DEBUG_PUB.LogMessage ('Update_Row: ' || '********* End of Procedure =>IEX_CASE_OBJECTS_PKG.INSERT_ROW ******** ');

198: RAISE NO_DATA_FOUND;
199: End If;
200: -- IF PG_DEBUG < 10 THEN
201: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
202: IEX_DEBUG_PUB.LogMessage ('Update_Row: ' || '********* End of Procedure =>IEX_CASE_OBJECTS_PKG.INSERT_ROW ******** ');
203: END IF;
204: END Update_Row;
205:
206: PROCEDURE Delete_Row(

Line 232: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_OBJECTS_PKG.LOCK_ROW ******** ');

228:
229: begin
230: -- IF PG_DEBUG < 10 THEN
231: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
232: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_OBJECTS_PKG.LOCK_ROW ******** ');
233: END IF;
234: open c;
235: fetch c into recinfo;
236: if (c%notfound) then

Line 252: IEX_DEBUG_PUB.LogMessage ('LOCK_ROW: ' || '********* End of Procedure =>IEX_CASE_OBJECTS_PKG.INSERT_ROW ******** ');

248: app_exception.raise_exception;
249: end if;
250: -- IF PG_DEBUG < 10 THEN
251: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
252: IEX_DEBUG_PUB.LogMessage ('LOCK_ROW: ' || '********* End of Procedure =>IEX_CASE_OBJECTS_PKG.INSERT_ROW ******** ');
253: END IF;
254: end LOCK_ROW;
255:
256:

Line 407: End IEX_CASE_OBJECTS_PKG;

403: End If;
404: END Lock_Row;
405: */
406:
407: End IEX_CASE_OBJECTS_PKG;