DBA Data[Home] [Help]

APPS.IEX_CASE_DEFINITIONS_PKG dependencies on IEX_DEBUG_PUB

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

55:
56: BEGIN
57: -- IF PG_DEBUG < 10 THEN
58: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
59: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_DEFINITIONS_PKG.INSERT_ROW ******** ');
60: END IF;
61: insert into IEX_CASE_DEFINITIONS (
62: CASE_DEFINITION_ID,
63: CAS_ID,

Line 133: IEX_DEBUG_PUB.LogMessage ('INSERT_ROW: ' || 'Value of ROWID = '||X_ROWID);

129: open c;
130: fetch c into X_ROWID;
131: -- IF PG_DEBUG < 10 THEN
132: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
133: IEX_DEBUG_PUB.LogMessage ('INSERT_ROW: ' || 'Value of ROWID = '||X_ROWID);
134: END IF;
135: if (c%notfound) then
136: close c;
137: raise no_data_found;

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

138: end if;
139: close c;
140: -- IF PG_DEBUG < 10 THEN
141: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
142: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_DEFINITIONS_PKG.INSERT_ROW ******** ');
143: END IF;
144:
145: End Insert_Row;
146:

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

179: IS
180: BEGIN
181: -- IF PG_DEBUG < 10 THEN
182: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
183: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_DEFINITIONS_PKG.UPDATE_ROW ******** ');
184: END IF;
185: Update IEX_CASE_DEFINITIONS
186: SET
187: TABLE_NAME = decode( x_TABLE_NAME, FND_API.G_MISS_CHAR, TABLE_NAME, x_TABLE_NAME),

Line 223: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_DEFINITIONS_PKG.UPDATE_ROW ******** ');

219: RAISE NO_DATA_FOUND;
220: End If;
221: -- IF PG_DEBUG < 10 THEN
222: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
223: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_DEFINITIONS_PKG.UPDATE_ROW ******** ');
224: END IF;
225: END Update_Row;
226:
227: PROCEDURE Delete_Row(

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

249:
250: begin
251: -- IF PG_DEBUG < 10 THEN
252: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
253: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_DEFINITIONS_PKG.LOCK_ROW ******** ');
254: END IF;
255: open c;
256: fetch c into recinfo;
257: if (c%notfound) then

Line 273: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_DEFINITIONS_PKG.LOCK_ROW ******** ');

269: app_exception.raise_exception;
270: end if;
271: -- IF PG_DEBUG < 10 THEN
272: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
273: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_DEFINITIONS_PKG.LOCK_ROW ******** ');
274: END IF;
275: end LOCK_ROW;
276:
277: /*PROCEDURE Lock_Row(