DBA Data[Home] [Help]

APPS.FV_BE_XLA_PKG dependencies on FV_UTILITY

Line 157: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

153: l_module_name := G_MODULE_NAME ||'BUDGETARY_CONTROL';
154:
155: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
156:
157: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
158: 'procedure budgetary_control starts.');
159: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
160: 'l_calling_sequence -> '||l_calling_sequence);
161:

Line 159: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

155: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
156:
157: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
158: 'procedure budgetary_control starts.');
159: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
160: 'l_calling_sequence -> '||l_calling_sequence);
161:
162: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Parameter values');
163:

Line 162: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Parameter values');

158: 'procedure budgetary_control starts.');
159: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
160: 'l_calling_sequence -> '||l_calling_sequence);
161:
162: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Parameter values');
163:
164: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_ledger_id -> '
165: ||p_ledger_id);
166: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_doc_id -> '

Line 164: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_ledger_id -> '

160: 'l_calling_sequence -> '||l_calling_sequence);
161:
162: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Parameter values');
163:
164: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_ledger_id -> '
165: ||p_ledger_id);
166: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_doc_id -> '
167: ||p_doc_id);
168: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_doc_type -> '

Line 166: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_doc_id -> '

162: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Parameter values');
163:
164: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_ledger_id -> '
165: ||p_ledger_id);
166: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_doc_id -> '
167: ||p_doc_id);
168: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_doc_type -> '
169: ||p_doc_type);
170: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_event_type -> '

Line 168: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_doc_type -> '

164: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_ledger_id -> '
165: ||p_ledger_id);
166: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_doc_id -> '
167: ||p_doc_id);
168: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_doc_type -> '
169: ||p_doc_type);
170: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_event_type -> '
171: ||p_event_type);
172: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_accounting_date->'

Line 170: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_event_type -> '

166: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_doc_id -> '
167: ||p_doc_id);
168: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_doc_type -> '
169: ||p_doc_type);
170: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_event_type -> '
171: ||p_event_type);
172: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_accounting_date->'
173: ||p_accounting_date);
174: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_bc_mode -> '

Line 172: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_accounting_date->'

168: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_doc_type -> '
169: ||p_doc_type);
170: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_event_type -> '
171: ||p_event_type);
172: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_accounting_date->'
173: ||p_accounting_date);
174: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_bc_mode -> '
175: ||p_bc_mode);
176: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_user_resp_id -> '

Line 174: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_bc_mode -> '

170: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_event_type -> '
171: ||p_event_type);
172: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_accounting_date->'
173: ||p_accounting_date);
174: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_bc_mode -> '
175: ||p_bc_mode);
176: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_user_resp_id -> '
177: ||p_user_resp_id);
178:

Line 176: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_user_resp_id -> '

172: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_accounting_date->'
173: ||p_accounting_date);
174: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_bc_mode -> '
175: ||p_bc_mode);
176: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_user_resp_id -> '
177: ||p_user_resp_id);
178:
179: END IF;
180:

Line 215: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'g_user_resp_id -> '

211: else
212: g_user_resp_id := FND_GLOBAL.RESP_ID;
213: end if;
214:
215: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'g_user_resp_id -> '
216: || g_user_resp_id );
217: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
218: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
219: 'call Create_be_acct_event');

Line 218: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

214:
215: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'g_user_resp_id -> '
216: || g_user_resp_id );
217: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
218: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
219: 'call Create_be_acct_event');
220: END IF;
221: -- Invoke Create_be_acct_event
222: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoke Create_BE_Acct_Event() ');

Line 228: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'l_event_id -> '||

224: l_event_id := create_be_acct_event(p_calling_sequence => l_calling_sequence);
225:
226: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_event_id -->'||l_event_id);
227: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
228: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'l_event_id -> '||
229: l_event_id);
230: END IF;
231:
232: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 233: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

229: l_event_id);
230: END IF;
231:
232: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
233: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
234: 'call populate_bc_events_tab');
235: END IF;
236:
237: -- Insert into psa_bc_xla_events_gt

Line 243: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'call BC PSA API');

239: populate_bc_events_tab;
240:
241:
242: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
243: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'call BC PSA API');
244: END IF;
245:
246:
247: -- call PSA Budgetary Control API

Line 368: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

364:
365: l_module_name := G_MODULE_NAME ||'CREATE_BE_ACCT_EVENTS';
366:
367: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
368: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
369: 'Create_be_acct_events start..');
370: END IF;
371:
372: --Assign the event source info from transactions

Line 375: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

371:
372: --Assign the event source info from transactions
373:
374: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
375: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
376: 'Call get_event_source_info function');
377: END IF;
378:
379: l_event_source_info := get_event_source_info;

Line 391: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Call Delete_Event API');

387: FOR fv_be_event_id_Rec in fv_be_event_id
388: LOOP
389: l_event_id := fv_be_event_id_Rec.event_id;
390: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
391: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Call Delete_Event API');
392: END IF;
393:
394: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
395: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

Line 395: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

391: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Call Delete_Event API');
392: END IF;
393:
394: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
395: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
396: 'Check if event exists before deleteion for event:'||l_event_id);
397: END IF;
398: IF XLA_EVENTS_PUB_PKG.EVENT_EXISTS
399: (p_event_source_info => l_event_source_info

Line 408: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Call Delete_Event API:'||l_event_id);

404: ,p_event_number => NULL
405: ,p_valuation_method => NULL
406: ,p_security_context => l_event_security_context) THEN
407: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
408: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Call Delete_Event API:'||l_event_id);
409: END IF;
410: XLA_EVENTS_PUB_PKG.DELETE_EVENT
411: (p_event_source_info => l_event_source_info
412: ,p_event_id => l_event_id

Line 416: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Call Delete_Entity API:'||l_event_id);

412: ,p_event_id => l_event_id
413: ,p_valuation_method => NULL
414: ,p_security_context => l_event_security_context);
415: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
416: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Call Delete_Entity API:'||l_event_id);
417: END IF;
418:
419: l_entity_deleted := XLA_EVENTS_PUB_PKG.delete_entity
420: (p_source_info => l_event_source_info

Line 425: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Reset event_id:'||l_event_id);

421: ,p_valuation_method => NULL
422: ,p_security_context => l_event_security_context);
423:
424: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
425: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Reset event_id:'||l_event_id);
426: END IF;
427:
428: reset_event(l_event_id);
429:

Line 457: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Call xla_events_pub_pkg.create_event');

453: ,p_security_context => l_event_security_context) OR
454: fv_be_gl_date_Rec.event_id IS NULL THEN
455: -- Create Event
456: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
457: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Call xla_events_pub_pkg.create_event');
458: END IF;
459: l_event_id := XLA_EVENTS_PUB_PKG.CREATE_EVENT
460: (p_event_source_info => l_event_source_info
461: ,p_event_type_code => g_event_type

Line 474: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Event_id:'||l_event_id);

470: ELSE
471: l_event_id := fv_be_gl_date_Rec.event_id;
472: END IF;
473: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
474: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Event_id:'||l_event_id);
475: END IF;
476:
477: IF(l_event_id IS NOT NULL) THEN
478: -- Stamp Event in FV_BE_TRX_DTLS/FV_BE_RPR_TRANSACTIONS table

Line 523: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

519:
520: l_module_name := G_MODULE_NAME ||'GET_EVENT_SOURCE_INFO';
521:
522: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
523: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
524: 'get_event_source_info start..');
525: END IF;
526:
527: l_prepare_stmt := 'SELECT DOC_NUMBER FROM ';

Line 544: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name||'get_event_source_info start..');

540:
541: END IF;
542:
543: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
544: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name||'get_event_source_info start..');
545: END IF;
546:
547: EXECUTE IMMEDIATE l_prepare_stmt INTO l_doc_num USING g_doc_id;
548:

Line 693: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

689: l_module_name varchar2(1000);
690: Begin
691: l_module_name := G_MODULE_NAME ||'GET_CCID';
692: If (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) Then
693: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
694: 'GET_CCID Parameters ' );
695: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
696: 'Application Short Name ' || application_short_name );
697: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

Line 695: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

691: l_module_name := G_MODULE_NAME ||'GET_CCID';
692: If (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) Then
693: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
694: 'GET_CCID Parameters ' );
695: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
696: 'Application Short Name ' || application_short_name );
697: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
698: 'Flex Code ' || key_flex_code);
699: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

Line 697: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

693: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
694: 'GET_CCID Parameters ' );
695: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
696: 'Application Short Name ' || application_short_name );
697: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
698: 'Flex Code ' || key_flex_code);
699: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
700: 'Chart of Account Id ' || structure_number );
701: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

Line 699: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

695: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
696: 'Application Short Name ' || application_short_name );
697: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
698: 'Flex Code ' || key_flex_code);
699: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
700: 'Chart of Account Id ' || structure_number );
701: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
702: 'Concatenated Segments ' || concatenated_segments);
703: End If;

Line 701: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

697: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
698: 'Flex Code ' || key_flex_code);
699: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
700: 'Chart of Account Id ' || structure_number );
701: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
702: 'Concatenated Segments ' || concatenated_segments);
703: End If;
704:
705: l_date := validation_date;

Line 710: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name, 'Delimiter ' || l_delim);

706: l_delim := fnd_flex_ext.get_delimiter(
707: application_short_name
708: ,key_flex_code
709: ,structure_number);
710: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name, 'Delimiter ' || l_delim);
711:
712: l_num := fnd_flex_ext.breakup_segments(
713: concatenated_segments
714: ,l_delim

Line 717: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name, 'No of Segments ' || l_num);

713: concatenated_segments
714: ,l_delim
715: ,l_segarray);
716: If (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) Then
717: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name, 'No of Segments ' || l_num);
718: End If;
719:
720: If fnd_flex_ext.get_combination_id(
721: application_short_name => application_short_name

Line 730: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

726: ,segments => l_segarray
727: ,combination_id => l_ccid
728: ,data_set => l_data_set) Then
729: If (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) Then
730: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
731: 'Code Combination Id fetched ' || l_ccid);
732: End If;
733: Return (l_ccid);
734: End If;

Line 736: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

732: End If;
733: Return (l_ccid);
734: End If;
735: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
736: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
737: 'Code Combination Id cannot be fetched returning 0 ');
738: End If;
739: Return (0);
740: Exception

Line 743: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

739: Return (0);
740: Exception
741: When Others Then
742: If (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
743: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
744: 'Exception encountered returning 0 ');
745: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
746: 'Exception ' || sqlerrm);
747: End If;

Line 745: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

741: When Others Then
742: If (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
743: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
744: 'Exception encountered returning 0 ');
745: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
746: 'Exception ' || sqlerrm);
747: End If;
748: Return(0);
749: End GET_CCID;