37:
38: errbuf := fnd_message.get ;
39: retcode := -1 ;
40: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message1',errbuf);
41: raise fnd_api.g_exc_error ;
42: rollback;
43: return;
44: ELSE
45: l_req_id := fnd_request.submit_request
55: if l_req_id = 0 then
56: errbuf := fnd_message.get ;
57: retcode := -1 ;
58: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message2',errbuf);
59: raise fnd_api.g_exc_error ;
60: rollback;
61: return;
62: END IF;
63:
102: if l_req_id = 0 then
103: errbuf := fnd_message.get ;
104: retcode := -1 ;
105: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message1',errbuf);
106: raise fnd_api.g_exc_error ;
107: rollback;
108: return;
109: END IF;
110: commit;
153: if l_req_id = 0 then
154: errbuf := fnd_message.get ;
155: retcode := -1 ;
156: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message1',errbuf);
157: raise fnd_api.g_exc_error ;
158: rollback;
159: return;
160: END IF;
161: commit;
190: if l_req_id = 0 then
191: errbuf := fnd_message.get ;
192: retcode := -1 ;
193: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message1',errbuf);
194: raise fnd_api.g_exc_error ;
195: rollback;
196: return;
197: END IF;
198: commit;
234: if l_req_id = 0 then
235: errbuf := fnd_message.get ;
236: retcode := -1 ;
237: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message1',errbuf);
238: raise fnd_api.g_exc_error ;
239: rollback;
240: return;
241: END IF;
242: commit;
262: if l_req_id = 0 then
263: errbuf := fnd_message.get ;
264: retcode := -1 ;
265: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message2',errbuf);
266: raise fnd_api.g_exc_error ;
267: rollback;
268: return;
269: END IF;
270: commit;
283: if l_req_id = 0 then
284: errbuf := fnd_message.get ;
285: retcode := -1 ;
286: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message3',errbuf);
287: raise fnd_api.g_exc_error ;
288: rollback;
289: return;
290: END IF;
291: commit;
340: if l_req_id = 0 then
341: errbuf := fnd_message.get ;
342: retcode := -1 ;
343: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message1',errbuf);
344: raise fnd_api.g_exc_error ;
345: rollback;
346: return;
347: END IF;
348: commit;
395: if l_req_id = 0 then
396: errbuf := fnd_message.get ;
397: retcode := -1 ;
398: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message1',errbuf);
399: raise fnd_api.g_exc_error ;
400: rollback;
401: return;
402: END IF;
403: commit;
433: IF l_req_id = 0 THEN
434: errbuf := fnd_message.get ;
435: retcode := -1 ;
436: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message1',errbuf);
437: raise fnd_api.g_exc_error ;
438: ROLLBACK;
439: RETURN;
440: END IF;
441: COMMIT;
487: retcode := -1 ;
488: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
489: l_module_name||'.message1',errbuf);
490: ROLLBACK;
491: RAISE fnd_api.g_exc_error ;
492: END IF;
493: commit;
494: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
495: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message1',
544: IF l_req_id = 0 THEN
545: errbuf := fnd_message.get ;
546: retcode := -1 ;
547: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message1',errbuf);
548: RAISE fnd_api.g_exc_error ;
549: ROLLBACK;
550: RETURN;
551: ELSE
552: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN