APPS.IEX_CASE_OBJECTS_PKG dependencies on IEX_DEBUG_PUB

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 117: IEX_DEBUG_PUB.LogMessage ('INSERT_ROW: ' || 'Value of ROWID = '||X_ROWID);

113: open c;
114: fetch c into X_ROWID;
115: -- IF PG_DEBUG < 10 THEN
116: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
117: IEX_DEBUG_PUB.LogMessage ('INSERT_ROW: ' || 'Value of ROWID = '||X_ROWID);
118: END IF;
119: if (c%notfound) then
120: close c;
121: raise no_data_found;

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: