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.CSD_RT_TRAN_RESPS_PVT dependencies on FND_LOG

Line 64: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

60: IF FND_API.to_Boolean( p_init_msg_list ) THEN
61: FND_MSG_PUB.initialize;
62: END IF;
63:
64: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
65: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
66: 'Entered Create_Rt_Tran_Resp');
67: END IF;
68:

Line 65: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',

61: FND_MSG_PUB.initialize;
62: END IF;
63:
64: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
65: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
66: 'Entered Create_Rt_Tran_Resp');
67: END IF;
68:
69: -- Initialize API return status to success

Line 75: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

71:
72: -- Api body starts
73:
74: -- Check the required parameters
75: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
77: 'Checking required parameters');
78: end if;
79:

Line 76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,

72: -- Api body starts
73:
74: -- Check the required parameters
75: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
77: 'Checking required parameters');
78: end if;
79:
80: -- Check the required parameters

Line 93: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

89: p_api_name => lc_api_name);
90:
91:
92: -- Insert row
93: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
94: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
95: 'Calling Insert_Row table handler');
96: end if;
97:

Line 94: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,

90:
91:
92: -- Insert row
93: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
94: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
95: 'Calling Insert_Row table handler');
96: end if;
97:
98: Begin

Line 116: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

112: );
113:
114: END;
115:
116: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
117: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
118: 'Returned from Insert_Row table handler');
119: end if;
120:

Line 117: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,

113:
114: END;
115:
116: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
117: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
118: 'Returned from Insert_Row table handler');
119: end if;
120:
121: -- Api body ends here

Line 133: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

129: FND_MSG_PUB.Count_And_Get
130: (p_count => x_msg_count,
131: p_data => x_msg_data );
132:
133: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
134: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.END',
135: 'Leaving Create_Rt_Tran_Resp');
136: END IF;
137:

Line 134: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.END',

130: (p_count => x_msg_count,
131: p_data => x_msg_data );
132:
133: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
134: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.END',
135: 'Leaving Create_Rt_Tran_Resp');
136: END IF;
137:
138: EXCEPTION

Line 152: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

148: (p_count => x_msg_count,
149: p_data => x_msg_data );
150:
151: -- save message in debug log
152: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
154: 'EXC_ERROR['||x_msg_data||']');
155: END IF;
156: WHEN FND_API.G_EXC_ERROR THEN

Line 153: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,

149: p_data => x_msg_data );
150:
151: -- save message in debug log
152: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
154: 'EXC_ERROR['||x_msg_data||']');
155: END IF;
156: WHEN FND_API.G_EXC_ERROR THEN
157: ROLLBACK TO Create_Rt_Tran_Resp;

Line 165: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

161: (p_count => x_msg_count,
162: p_data => x_msg_data );
163:
164: -- save message in debug log
165: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
166: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
167: 'EXC_ERROR['||x_msg_data||']');
168: END IF;
169:

Line 166: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,

162: p_data => x_msg_data );
163:
164: -- save message in debug log
165: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
166: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
167: 'EXC_ERROR['||x_msg_data||']');
168: END IF;
169:
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 178: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

174: -- save message in fnd stack
175: IF FND_MSG_PUB.Check_Msg_Level
176: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
177: THEN
178: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
180: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
181: end if;
182: FND_MSG_PUB.Add_Exc_Msg

Line 179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,

175: IF FND_MSG_PUB.Check_Msg_Level
176: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
177: THEN
178: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
180: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
181: end if;
182: FND_MSG_PUB.Add_Exc_Msg
183: (G_PKG_NAME ,

Line 192: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

188: ( p_count => x_msg_count,
189: p_data => x_msg_data );
190:
191: -- save message in debug log
192: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
193: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
194: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
195: END IF;
196:

Line 193: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,

189: p_data => x_msg_data );
190:
191: -- save message in debug log
192: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
193: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
194: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
195: END IF;
196:
197: WHEN OTHERS THEN

Line 205: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

201: -- save message in fnd stack
202: IF FND_MSG_PUB.Check_Msg_Level
203: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
204: THEN
205: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
207: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
208: end if;
209: FND_MSG_PUB.Add_Exc_Msg

Line 206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,

202: IF FND_MSG_PUB.Check_Msg_Level
203: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
204: THEN
205: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
207: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
208: end if;
209: FND_MSG_PUB.Add_Exc_Msg
210: (G_PKG_NAME ,

Line 219: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

215: (p_count => x_msg_count,
216: p_data => x_msg_data );
217:
218: -- save message in debug log
219: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
220: -- create a seeded message
221: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
222: 'SQL Message['||sqlerrm||']' );
223: END IF;

Line 221: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,

217:
218: -- save message in debug log
219: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
220: -- create a seeded message
221: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
222: 'SQL Message['||sqlerrm||']' );
223: END IF;
224:
225: END Create_Rt_Tran_Resp;

Line 284: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

280: IF FND_API.to_Boolean( p_init_msg_list ) THEN
281: FND_MSG_PUB.initialize;
282: END IF;
283:
284: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
286: 'Entered Update_Rt_Tran_Resp');
287: END IF;
288:

Line 285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',

281: FND_MSG_PUB.initialize;
282: END IF;
283:
284: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
286: 'Entered Update_Rt_Tran_Resp');
287: END IF;
288:
289: -- Initialize API return status to success

Line 295: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

291:
292: -- Api body starts
293:
294: -- Check the required parameters
295: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
297: 'Checking required parameters');
298: end if;
299:

Line 296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,

292: -- Api body starts
293:
294: -- Check the required parameters
295: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
297: 'Checking required parameters');
298: end if;
299:
300: CSD_PROCESS_UTIL.Check_Reqd_Param

Line 316: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

312: p_param_name => 'RESPONSIBILITY_ID',
313: p_api_name => lc_api_name);
314:
315: -- Update row
316: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
317: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
318: 'Calling Update_Row table handler');
319: end if;
320:

Line 317: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,

313: p_api_name => lc_api_name);
314:
315: -- Update row
316: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
317: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
318: 'Calling Update_Row table handler');
319: end if;
320:
321: Begin

Line 339: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

335: x_obj_ver_number := p_rt_tran_resp_rec.object_version_number + 1;
336:
337: END;
338:
339: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
340: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
341: 'Returned from Update_Row table handler');
342: end if;
343:

Line 340: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,

336:
337: END;
338:
339: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
340: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
341: 'Returned from Update_Row table handler');
342: end if;
343:
344: -- Api body ends here

Line 356: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

352: FND_MSG_PUB.Count_And_Get
353: (p_count => x_msg_count,
354: p_data => x_msg_data );
355:
356: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
357: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.END',
358: 'Leaving Update_Rt_Tran_Resp');
359: END IF;
360:

Line 357: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.END',

353: (p_count => x_msg_count,
354: p_data => x_msg_data );
355:
356: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
357: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.END',
358: 'Leaving Update_Rt_Tran_Resp');
359: END IF;
360:
361: EXCEPTION

Line 375: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

371: (p_count => x_msg_count,
372: p_data => x_msg_data );
373:
374: -- save message in debug log
375: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
376: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
377: 'EXC_ERROR['||x_msg_data||']');
378: END IF;
379: WHEN FND_API.G_EXC_ERROR THEN

Line 376: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,

372: p_data => x_msg_data );
373:
374: -- save message in debug log
375: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
376: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
377: 'EXC_ERROR['||x_msg_data||']');
378: END IF;
379: WHEN FND_API.G_EXC_ERROR THEN
380: ROLLBACK TO Update_Rt_Tran_Resp;

Line 388: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

384: (p_count => x_msg_count,
385: p_data => x_msg_data );
386:
387: -- save message in debug log
388: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
389: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
390: 'EXC_ERROR['||x_msg_data||']');
391: END IF;
392:

Line 389: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,

385: p_data => x_msg_data );
386:
387: -- save message in debug log
388: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
389: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
390: 'EXC_ERROR['||x_msg_data||']');
391: END IF;
392:
393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 400: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

396:
397: IF FND_MSG_PUB.Check_Msg_Level
398: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
399: THEN
400: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
401: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
402: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
403: end if;
404: FND_MSG_PUB.Add_Exc_Msg

Line 401: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,

397: IF FND_MSG_PUB.Check_Msg_Level
398: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
399: THEN
400: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
401: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
402: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
403: end if;
404: FND_MSG_PUB.Add_Exc_Msg
405: (G_PKG_NAME ,

Line 414: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

410: ( p_count => x_msg_count,
411: p_data => x_msg_data );
412:
413: -- save message in debug log
414: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
415: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
416: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
417: END IF;
418:

Line 415: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,

411: p_data => x_msg_data );
412:
413: -- save message in debug log
414: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
415: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
416: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
417: END IF;
418:
419: WHEN OTHERS THEN

Line 427: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

423: -- save message in fnd stack
424: IF FND_MSG_PUB.Check_Msg_Level
425: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
426: THEN
427: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
428: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
429: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
430: end if;
431: FND_MSG_PUB.Add_Exc_Msg

Line 428: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,

424: IF FND_MSG_PUB.Check_Msg_Level
425: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
426: THEN
427: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
428: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
429: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
430: end if;
431: FND_MSG_PUB.Add_Exc_Msg
432: (G_PKG_NAME ,

Line 441: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

437: (p_count => x_msg_count,
438: p_data => x_msg_data );
439:
440: -- save message in debug log
441: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
442: -- create a seeded message
443: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
444: 'SQL Message['||sqlerrm||']' );
445: END IF;

Line 443: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,

439:
440: -- save message in debug log
441: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
442: -- create a seeded message
443: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
444: 'SQL Message['||sqlerrm||']' );
445: END IF;
446:
447: END Update_Rt_Tran_Resp;

Line 495: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

491: IF FND_API.to_Boolean( p_init_msg_list ) THEN
492: FND_MSG_PUB.initialize;
493: END IF;
494:
495: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
496: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
497: 'Entered Delete_Rt_Tran_Resp');
498: END IF;
499:

Line 496: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',

492: FND_MSG_PUB.initialize;
493: END IF;
494:
495: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
496: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
497: 'Entered Delete_Rt_Tran_Resp');
498: END IF;
499:
500: -- Initialize API return status to success

Line 506: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

502:
503: -- Api body starts
504:
505: -- Check the required parameters
506: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
507: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
508: 'Checking required parameter');
509: end if;
510:

Line 507: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,

503: -- Api body starts
504:
505: -- Check the required parameters
506: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
507: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
508: 'Checking required parameter');
509: end if;
510:
511: -- Check the required parameter

Line 518: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

514: p_param_name => 'RT_TRAN_RESP_ID',
515: p_api_name => lc_api_name);
516:
517: -- Delete row
518: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
519: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
520: 'Calling Delete_Row table handler');
521: end if;
522:

Line 519: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,

515: p_api_name => lc_api_name);
516:
517: -- Delete row
518: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
519: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
520: 'Calling Delete_Row table handler');
521: end if;
522:
523: BEGIN

Line 531: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

527: ( p_rt_tran_resp_id => p_rt_tran_resp_id);
528:
529: END;
530:
531: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
532: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
533: 'Returned from Delete_Row table handler');
534: end if;
535:

Line 532: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,

528:
529: END;
530:
531: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
532: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
533: 'Returned from Delete_Row table handler');
534: end if;
535:
536: -- Api body ends here

Line 548: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

544: FND_MSG_PUB.Count_And_Get
545: (p_count => x_msg_count,
546: p_data => x_msg_data );
547:
548: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
549: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.END',
550: 'Leaving Delete_Rt_Tran_Resp');
551: END IF;
552:

Line 549: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.END',

545: (p_count => x_msg_count,
546: p_data => x_msg_data );
547:
548: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
549: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.END',
550: 'Leaving Delete_Rt_Tran_Resp');
551: END IF;
552:
553: EXCEPTION

Line 565: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

561: (p_count => x_msg_count,
562: p_data => x_msg_data );
563:
564: -- save message in debug log
565: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
566: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
567: 'EXC_ERROR['||x_msg_data||']');
568: END IF;
569:

Line 566: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,

562: p_data => x_msg_data );
563:
564: -- save message in debug log
565: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
566: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
567: 'EXC_ERROR['||x_msg_data||']');
568: END IF;
569:
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 578: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

574:
575: IF FND_MSG_PUB.Check_Msg_Level
576: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
577: THEN
578: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
579: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
580: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
581: end if;
582: FND_MSG_PUB.Add_Exc_Msg

Line 579: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,

575: IF FND_MSG_PUB.Check_Msg_Level
576: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
577: THEN
578: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
579: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
580: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
581: end if;
582: FND_MSG_PUB.Add_Exc_Msg
583: (G_PKG_NAME ,

Line 592: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

588: ( p_count => x_msg_count,
589: p_data => x_msg_data );
590:
591: -- save message in debug log
592: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
593: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
594: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
595: END IF;
596:

Line 593: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,

589: p_data => x_msg_data );
590:
591: -- save message in debug log
592: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
593: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
594: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
595: END IF;
596:
597: WHEN OTHERS THEN

Line 606: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

602: -- save message in fnd stack
603: IF FND_MSG_PUB.Check_Msg_Level
604: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
605: THEN
606: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
607: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
608: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
609: end if;
610: FND_MSG_PUB.Add_Exc_Msg

Line 607: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,

603: IF FND_MSG_PUB.Check_Msg_Level
604: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
605: THEN
606: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
607: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
608: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
609: end if;
610: FND_MSG_PUB.Add_Exc_Msg
611: (G_PKG_NAME ,

Line 620: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

616: (p_count => x_msg_count,
617: p_data => x_msg_data );
618:
619: -- save message in debug log
620: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
621: -- create a seeded message
622: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
623: 'SQL Message['||sqlerrm||']' );
624: END IF;

Line 622: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,

618:
619: -- save message in debug log
620: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
621: -- create a seeded message
622: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
623: 'SQL Message['||sqlerrm||']' );
624: END IF;
625:
626: END Delete_Rt_Tran_Resp;

Line 675: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

671: IF FND_API.to_Boolean( p_init_msg_list ) THEN
672: FND_MSG_PUB.initialize;
673: END IF;
674:
675: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
676: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
677: 'Entered Lock_Rt_Tran_Resp');
678: END IF;
679:

Line 676: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',

672: FND_MSG_PUB.initialize;
673: END IF;
674:
675: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
676: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
677: 'Entered Lock_Rt_Tran_Resp');
678: END IF;
679:
680: -- Initialize API return status to success

Line 686: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

682:
683: -- Api body starts
684:
685: -- Check the required parameters
686: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
687: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
688: 'Checking required parameters');
689: end if;
690:

Line 687: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,

683: -- Api body starts
684:
685: -- Check the required parameters
686: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
687: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
688: 'Checking required parameters');
689: end if;
690:
691: -- Check the required parameters

Line 703: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

699: p_param_name => 'OBJECT_VERSION_NUMBER',
700: p_api_name => lc_api_name);
701:
702: -- Lock row
703: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
704: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
705: 'Calling Lock_Row table handler');
706: end if;
707:

Line 704: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,

700: p_api_name => lc_api_name);
701:
702: -- Lock row
703: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
704: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
705: 'Calling Lock_Row table handler');
706: end if;
707:
708: Begin

Line 719: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

715: );
716:
717: END;
718:
719: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
720: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
721: 'Returned from Lock_Row table handler');
722: end if;
723:

Line 720: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,

716:
717: END;
718:
719: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
720: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
721: 'Returned from Lock_Row table handler');
722: end if;
723:
724: -- Api body ends here

Line 736: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

732: FND_MSG_PUB.Count_And_Get
733: (p_count => x_msg_count,
734: p_data => x_msg_data );
735:
736: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
737: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.END',
738: 'Leaving Lock_Rt_Tran_Resp');
739: END IF;
740:

Line 737: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.END',

733: (p_count => x_msg_count,
734: p_data => x_msg_data );
735:
736: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
737: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.END',
738: 'Leaving Lock_Rt_Tran_Resp');
739: END IF;
740:
741: EXCEPTION

Line 752: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

748: (p_count => x_msg_count,
749: p_data => x_msg_data );
750:
751: -- save message in debug log
752: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
753: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
754: 'EXC_ERROR['||x_msg_data||']');
755: END IF;
756:

Line 753: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,

749: p_data => x_msg_data );
750:
751: -- save message in debug log
752: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
753: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
754: 'EXC_ERROR['||x_msg_data||']');
755: END IF;
756:
757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 764: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

760:
761: IF FND_MSG_PUB.Check_Msg_Level
762: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
763: THEN
764: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
765: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
766: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
767: end if;
768: FND_MSG_PUB.Add_Exc_Msg

Line 765: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,

761: IF FND_MSG_PUB.Check_Msg_Level
762: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
763: THEN
764: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
765: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
766: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
767: end if;
768: FND_MSG_PUB.Add_Exc_Msg
769: (G_PKG_NAME ,

Line 778: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

774: ( p_count => x_msg_count,
775: p_data => x_msg_data );
776:
777: -- save message in debug log
778: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
779: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
780: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
781: END IF;
782:

Line 779: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,

775: p_data => x_msg_data );
776:
777: -- save message in debug log
778: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
779: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
780: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
781: END IF;
782:
783: WHEN OTHERS THEN

Line 791: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

787: -- save message in fnd stack
788: IF FND_MSG_PUB.Check_Msg_Level
789: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
790: THEN
791: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
792: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
793: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
794: end if;
795: FND_MSG_PUB.Add_Exc_Msg

Line 792: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,

788: IF FND_MSG_PUB.Check_Msg_Level
789: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
790: THEN
791: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
792: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
793: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
794: end if;
795: FND_MSG_PUB.Add_Exc_Msg
796: (G_PKG_NAME ,

Line 805: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

801: (p_count => x_msg_count,
802: p_data => x_msg_data );
803:
804: -- save message in debug log
805: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
806: -- create a seeded message
807: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
808: 'SQL Message['||sqlerrm||']' );
809: END IF;

Line 807: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,

803:
804: -- save message in debug log
805: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
806: -- create a seeded message
807: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
808: 'SQL Message['||sqlerrm||']' );
809: END IF;
810:
811: END Lock_Rt_Tran_Resp;