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_FLWSTS_TRAN_MILES_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_Flwsts_Tran_Mile');
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_Flwsts_Tran_Mile');
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 92: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

334: x_obj_ver_number := p_flwsts_tran_mile_rec.object_version_number + 1;
335: END;
336:
337: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
338: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,
339: 'Returned from Update_Row table handler');
340: end if;
341:
342: -- Api body ends here

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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