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.FV_SETUP_PKG dependencies on FV_UTILITY

Line 40: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message1',errbuf);

36: if l_req_id = 0 then
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

Line 58: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message2',errbuf);

54:
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;

Line 68: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message3',v_message);

64: COMMIT;
65:
66: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
67: v_message :='FACTS attributes table setup program successfully Requested';
68: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message3',v_message);
69: END IF;
70:
71: if p_yes_no = 'N' then
72: retcode := 1;

Line 75: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message4',errbuf);

71: if p_yes_no = 'N' then
72: retcode := 1;
73: errbuf := 'FACTS II requires US SGL compliance if the natural account segment has been expanded to accomodate Agency
74: specific requirements, designate a parent account that is 4-digit US SGL Account';
75: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message4',errbuf);
76: end if;
77: END IF;
78:
79: Exception

Line 83: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

79: Exception
80: When Others Then
81: errbuf := substr(SQLERRM,1,225);
82: retcode := -1;
83: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
84: l_module_name||'.final_exception',errbuf);
85: END;
86: ----------------------------------------------------------------------------
87:

Line 105: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message1',errbuf);

101:
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;

Line 112: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message2',

108: return;
109: END IF;
110: commit;
111: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
112: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message2',
113: 'Fund Available table seed data process sucessfully requested');
114: END IF;
115: EXCEPTION
116: WHEN OTHERS THEN

Line 118: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

114: END IF;
115: EXCEPTION
116: WHEN OTHERS THEN
117: errbuf := SQLERRM;
118: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
119: l_module_name||'.final_exception',errbuf);
120: RAISE;
121: End;
122: ------------------------------------------------------------------------------

Line 131: fv_utility.log_mesg('Deleting USSGL setup data!');

127:
128: BEGIN
129:
130: IF del_existing_data = 'Y' THEN
131: fv_utility.log_mesg('Deleting USSGL setup data!');
132: BEGIN
133:
134: delete from FV_FACTS_USSGL_ACCOUNTS;
135: fv_utility.log_mesg('Deleted from FV_FACTS_USSGL_ACCOUNTS');

Line 135: fv_utility.log_mesg('Deleted from FV_FACTS_USSGL_ACCOUNTS');

131: fv_utility.log_mesg('Deleting USSGL setup data!');
132: BEGIN
133:
134: delete from FV_FACTS_USSGL_ACCOUNTS;
135: fv_utility.log_mesg('Deleted from FV_FACTS_USSGL_ACCOUNTS');
136: EXCEPTION WHEN OTHERS THEN
137: fv_utility.log_mesg('When others error when deleting
138: USSGL setup data: '||SQLERRM);
139: END;

Line 137: fv_utility.log_mesg('When others error when deleting

133:
134: delete from FV_FACTS_USSGL_ACCOUNTS;
135: fv_utility.log_mesg('Deleted from FV_FACTS_USSGL_ACCOUNTS');
136: EXCEPTION WHEN OTHERS THEN
137: fv_utility.log_mesg('When others error when deleting
138: USSGL setup data: '||SQLERRM);
139: END;
140:
141: END IF;

Line 156: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message1',errbuf);

152:
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;

Line 163: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message2',

159: return;
160: END IF;
161: commit;
162: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
163: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message2',
164: 'USSGL table setup seed data process sucessfully requested');
165: END IF;
166:
167: EXCEPTION

Line 170: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);

166:
167: EXCEPTION
168: WHEN OTHERS THEN
169: errbuf := SQLERRM;
170: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
171: RAISE;
172:
173: End;
174: ------------------------------------------------------------------------------

Line 193: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message1',errbuf);

189:
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;

Line 200: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message4',

196: return;
197: END IF;
198: commit;
199: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
200: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message4',
201: 'Treasury transmission format seed data process successfully requested');
202: END IF;
203:
204: EXCEPTION

Line 207: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);

203:
204: EXCEPTION
205: WHEN OTHERS THEN
206: errbuf := SQLERRM;
207: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
208: RAISE;
209: End;
210: ------------------------------------------------------------------------------
211: Procedure CFS_TABLE_SETUP (errbuf OUT NOCOPY varchar2,

Line 237: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message1',errbuf);

233:
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;

Line 265: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message2',errbuf);

261:
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;

Line 286: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message3',errbuf);

282:
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;

Line 294: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

290: END IF;
291: commit;
292: end ;
293: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
294: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
295: l_module_name||'.message4','Financial statements table seed data process
296: sucessfully requested');
297: END IF;
298:

Line 302: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);

298:
299: EXCEPTION
300: WHEN OTHERS THEN
301: errbuf := SQLERRM;
302: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
303: RAISE;
304: End;
305: ------------------------------------------------------------------------------
306: Procedure LOAD_SF133_SETUP_DATA (errbuf OUT NOCOPY varchar2,

Line 314: fv_utility.log_mesg('Deleting 133 setup data');

310: begin
311:
312:
313: IF p_delete_133_setup = 'Y' THEN
314: fv_utility.log_mesg('Deleting 133 setup data');
315: BEGIN
316:
317: delete from FV_SF133_REP_LINE_CALC;
318: fv_utility.log_mesg('Deleted from FV_SF133_REP_LINE_CALC');

Line 318: fv_utility.log_mesg('Deleted from FV_SF133_REP_LINE_CALC');

314: fv_utility.log_mesg('Deleting 133 setup data');
315: BEGIN
316:
317: delete from FV_SF133_REP_LINE_CALC;
318: fv_utility.log_mesg('Deleted from FV_SF133_REP_LINE_CALC');
319: delete from FV_SF133_DEFINITIONS_ACCTS;
320: fv_utility.log_mesg('Deleted from FV_SF133_DEFINITIONS_ACCTS');
321: delete from FV_SF133_DEFINITIONS_LINES;
322: fv_utility.log_mesg('Deleted from FV_SF133_DEFINITIONS_LINES');

Line 320: fv_utility.log_mesg('Deleted from FV_SF133_DEFINITIONS_ACCTS');

316:
317: delete from FV_SF133_REP_LINE_CALC;
318: fv_utility.log_mesg('Deleted from FV_SF133_REP_LINE_CALC');
319: delete from FV_SF133_DEFINITIONS_ACCTS;
320: fv_utility.log_mesg('Deleted from FV_SF133_DEFINITIONS_ACCTS');
321: delete from FV_SF133_DEFINITIONS_LINES;
322: fv_utility.log_mesg('Deleted from FV_SF133_DEFINITIONS_LINES');
323: EXCEPTION WHEN OTHERS THEN
324: fv_utility.log_mesg('When others error when deleting

Line 322: fv_utility.log_mesg('Deleted from FV_SF133_DEFINITIONS_LINES');

318: fv_utility.log_mesg('Deleted from FV_SF133_REP_LINE_CALC');
319: delete from FV_SF133_DEFINITIONS_ACCTS;
320: fv_utility.log_mesg('Deleted from FV_SF133_DEFINITIONS_ACCTS');
321: delete from FV_SF133_DEFINITIONS_LINES;
322: fv_utility.log_mesg('Deleted from FV_SF133_DEFINITIONS_LINES');
323: EXCEPTION WHEN OTHERS THEN
324: fv_utility.log_mesg('When others error when deleting
325: SF133 data: '||SQLERRM);
326: END;

Line 324: fv_utility.log_mesg('When others error when deleting

320: fv_utility.log_mesg('Deleted from FV_SF133_DEFINITIONS_ACCTS');
321: delete from FV_SF133_DEFINITIONS_LINES;
322: fv_utility.log_mesg('Deleted from FV_SF133_DEFINITIONS_LINES');
323: EXCEPTION WHEN OTHERS THEN
324: fv_utility.log_mesg('When others error when deleting
325: SF133 data: '||SQLERRM);
326: END;
327:
328: END IF;

Line 343: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message1',errbuf);

339:
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;

Line 350: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message1',

346: return;
347: END IF;
348: commit;
349: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
350: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message1',
351: 'SF133 seed data process successfully requested');
352: END IF;
353:
354: EXCEPTION

Line 357: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);

353:
354: EXCEPTION
355: WHEN OTHERS THEN
356: errbuf := SQLERRM;
357: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
358: RAISE;
359: End;
360:
361: ------------------------------------------------------------------------------

Line 370: fv_utility.log_mesg('Deleting SBR setup data');

366: begin
367:
368:
369: IF p_delete_sbr_setup = 'Y' THEN
370: fv_utility.log_mesg('Deleting SBR setup data');
371: BEGIN
372:
373: delete from FV_SBR_REP_LINE_CALC;
374: fv_utility.log_mesg('Deleted from FV_SBR_REP_LINE_CALC');

Line 374: fv_utility.log_mesg('Deleted from FV_SBR_REP_LINE_CALC');

370: fv_utility.log_mesg('Deleting SBR setup data');
371: BEGIN
372:
373: delete from FV_SBR_REP_LINE_CALC;
374: fv_utility.log_mesg('Deleted from FV_SBR_REP_LINE_CALC');
375: delete from FV_SBR_DEFINITIONS_ACCTS;
376: fv_utility.log_mesg('Deleted from FV_SBR_DEFINITIONS_ACCTS');
377: delete from FV_SBR_DEFINITIONS_LINES;
378: fv_utility.log_mesg('Deleted from FV_SBR_DEFINITIONS_LINES');

Line 376: fv_utility.log_mesg('Deleted from FV_SBR_DEFINITIONS_ACCTS');

372:
373: delete from FV_SBR_REP_LINE_CALC;
374: fv_utility.log_mesg('Deleted from FV_SBR_REP_LINE_CALC');
375: delete from FV_SBR_DEFINITIONS_ACCTS;
376: fv_utility.log_mesg('Deleted from FV_SBR_DEFINITIONS_ACCTS');
377: delete from FV_SBR_DEFINITIONS_LINES;
378: fv_utility.log_mesg('Deleted from FV_SBR_DEFINITIONS_LINES');
379: EXCEPTION WHEN OTHERS THEN
380: fv_utility.log_mesg('When others error when deleting SBR data: '||SQLERRM);

Line 378: fv_utility.log_mesg('Deleted from FV_SBR_DEFINITIONS_LINES');

374: fv_utility.log_mesg('Deleted from FV_SBR_REP_LINE_CALC');
375: delete from FV_SBR_DEFINITIONS_ACCTS;
376: fv_utility.log_mesg('Deleted from FV_SBR_DEFINITIONS_ACCTS');
377: delete from FV_SBR_DEFINITIONS_LINES;
378: fv_utility.log_mesg('Deleted from FV_SBR_DEFINITIONS_LINES');
379: EXCEPTION WHEN OTHERS THEN
380: fv_utility.log_mesg('When others error when deleting SBR data: '||SQLERRM);
381: END;
382:

Line 380: fv_utility.log_mesg('When others error when deleting SBR data: '||SQLERRM);

376: fv_utility.log_mesg('Deleted from FV_SBR_DEFINITIONS_ACCTS');
377: delete from FV_SBR_DEFINITIONS_LINES;
378: fv_utility.log_mesg('Deleted from FV_SBR_DEFINITIONS_LINES');
379: EXCEPTION WHEN OTHERS THEN
380: fv_utility.log_mesg('When others error when deleting SBR data: '||SQLERRM);
381: END;
382:
383: END IF;
384: l_req_id := fnd_request.submit_request

Line 398: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message1',errbuf);

394:
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;

Line 405: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message1',

401: return;
402: END IF;
403: commit;
404: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
405: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message1',
406: 'SBR seed data process successfully requested');
407: END IF;
408:
409: EXCEPTION

Line 412: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);

408:
409: EXCEPTION
410: WHEN OTHERS THEN
411: errbuf := SQLERRM;
412: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
413: RAISE;
414: End;
415:
416: ------------------------------------------------------------------------------

Line 436: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message1',errbuf);

432:
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;

Line 443: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message2',

439: RETURN;
440: END IF;
441: COMMIT;
442: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
443: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message2',
444: 'RXi reports upload process successfully requested');
445: END IF;
446:
447: -- Updating the RX report responsiblity_id

Line 462: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);

458:
459: EXCEPTION
460: WHEN OTHERS THEN
461: errbuf := SQLERRM;
462: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
463: RAISE;
464: END;
465:
466: PROCEDURE load_reimb_act_definitions (errbuf OUT NOCOPY varchar2,

Line 488: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

484:
485: IF l_req_id = 0 THEN
486: errbuf := fnd_message.get ;
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;

Line 495: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message1',

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',
496: 'Load Reimbursement Activity Definitions process successfully requested');
497: END IF;
498: END load_reimb_act_definitions;
499:

Line 513: fv_utility.log_mesg('Deleting GTAS Attributes setup data!');

509:
510: BEGIN
511:
512: IF del_existing_data = 'Y' THEN
513: fv_utility.log_mesg('Deleting GTAS Attributes setup data!');
514: BEGIN
515: IF p_sob_id IS NOT NULL THEN
516: fv_utility.log_mesg
517: ('Deleting GTAS Attributes setup data for sob id: '||p_sob_id);

Line 516: fv_utility.log_mesg

512: IF del_existing_data = 'Y' THEN
513: fv_utility.log_mesg('Deleting GTAS Attributes setup data!');
514: BEGIN
515: IF p_sob_id IS NOT NULL THEN
516: fv_utility.log_mesg
517: ('Deleting GTAS Attributes setup data for sob id: '||p_sob_id);
518: DELETE FROM FV_GTAS_ATTRIBUTES
519: WHERE set_of_books_id = p_sob_id;
520: ELSE

Line 521: fv_utility.log_mesg

517: ('Deleting GTAS Attributes setup data for sob id: '||p_sob_id);
518: DELETE FROM FV_GTAS_ATTRIBUTES
519: WHERE set_of_books_id = p_sob_id;
520: ELSE
521: fv_utility.log_mesg
522: ('Deleting GTAS Attributes setup data for all set of books.');
523: DELETE FROM FV_GTAS_ATTRIBUTES;
524: END IF;
525:

Line 526: fv_utility.log_mesg('Deleted from FV_GTAS_ATTRIBUTES');

522: ('Deleting GTAS Attributes setup data for all set of books.');
523: DELETE FROM FV_GTAS_ATTRIBUTES;
524: END IF;
525:
526: fv_utility.log_mesg('Deleted from FV_GTAS_ATTRIBUTES');
527: EXCEPTION WHEN OTHERS THEN
528: fv_utility.log_mesg
529: ('When others error when deleting GTAS Attributes setup data: '
530: ||SQLERRM);

Line 528: fv_utility.log_mesg

524: END IF;
525:
526: fv_utility.log_mesg('Deleted from FV_GTAS_ATTRIBUTES');
527: EXCEPTION WHEN OTHERS THEN
528: fv_utility.log_mesg
529: ('When others error when deleting GTAS Attributes setup data: '
530: ||SQLERRM);
531: END;
532: END IF;

Line 547: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.message1',errbuf);

543:
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

Line 554: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

550: RETURN;
551: ELSE
552: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
553: v_message := 'GTAS attributes table setup program successfully requested';
554: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
555: l_module_name||'.message2',v_message);
556: END IF;
557: END IF;
558:

Line 563: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

559: EXCEPTION
560: WHEN OTHERS THEN
561: errbuf := substr(SQLERRM,1,225);
562: retcode := -1;
563: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
564: l_module_name||'.final_exception',errbuf);
565: END;
566: ----------------------------------------------------------------------------
567: