DBA Data[Home] [Help]

APPS.FV_SETUP_PKG dependencies on FND_LOG

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 66: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

62: END IF;
63:
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:

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 111: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

107: rollback;
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

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 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 162: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

158: rollback;
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:

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 199: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

195: rollback;
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:

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 293: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

289: return;
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;

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 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 349: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

345: rollback;
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:

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 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 404: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

400: rollback;
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:

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 442: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

438: ROLLBACK;
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:

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 494: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

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 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 552: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

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: