DBA Data[Home] [Help]

APPS.FV_BE_XLA_PKG dependencies on FV_UTILITY

Line 156: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

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

Line 158: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

169: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_event_type -> '
170: ||p_event_type);
171: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_accounting_date->'
172: ||p_accounting_date);
173: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'p_bc_mode -> '
174: ||p_bc_mode);
175: END IF;
176:
177: -- Assign the parameters to the local variables

Line 207: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

203: g_user_id := FND_GLOBAL.USER_ID;
204: g_user_resp_id := FND_GLOBAL.RESP_ID;
205:
206: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
207: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
208: 'call Create_be_acct_event');
209: END IF;
210: -- Invoke Create_be_acct_event
211: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoke Create_BE_Acct_Event() ');

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

213: l_event_id := create_be_acct_event(p_calling_sequence => l_calling_sequence);
214:
215: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_event_id -->'||l_event_id);
216: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
217: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'l_event_id -> '||
218: l_event_id);
219: END IF;
220:
221: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 222: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

218: l_event_id);
219: END IF;
220:
221: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
222: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
223: 'call populate_bc_events_tab');
224: END IF;
225:
226: -- Insert into psa_bc_xla_events_gt

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

228: populate_bc_events_tab;
229:
230:
231: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
232: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'call BC PSA API');
233: END IF;
234:
235:
236: -- call PSA Budgetary Control API

Line 357: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

353:
354: l_module_name := G_MODULE_NAME ||'CREATE_BE_ACCT_EVENTS';
355:
356: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
357: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
358: 'Create_be_acct_events start..');
359: END IF;
360:
361: --Assign the event source info from transactions

Line 364: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

360:
361: --Assign the event source info from transactions
362:
363: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
364: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
365: 'Call get_event_source_info function');
366: END IF;
367:
368: l_event_source_info := get_event_source_info;

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

376: FOR fv_be_event_id_Rec in fv_be_event_id
377: LOOP
378: l_event_id := fv_be_event_id_Rec.event_id;
379: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
380: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Call Delete_Event API');
381: END IF;
382:
383: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
384: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

Line 384: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

380: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Call Delete_Event API');
381: END IF;
382:
383: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
384: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
385: 'Check if event exists before deleteion for event:'||l_event_id);
386: END IF;
387: IF XLA_EVENTS_PUB_PKG.EVENT_EXISTS
388: (p_event_source_info => l_event_source_info

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

393: ,p_event_number => NULL
394: ,p_valuation_method => NULL
395: ,p_security_context => l_event_security_context) THEN
396: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
397: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Call Delete_Event API:'||l_event_id);
398: END IF;
399: XLA_EVENTS_PUB_PKG.DELETE_EVENT
400: (p_event_source_info => l_event_source_info
401: ,p_event_id => l_event_id

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

401: ,p_event_id => l_event_id
402: ,p_valuation_method => NULL
403: ,p_security_context => l_event_security_context);
404: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
405: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Call Delete_Entity API:'||l_event_id);
406: END IF;
407:
408: l_entity_deleted := XLA_EVENTS_PUB_PKG.delete_entity
409: (p_source_info => l_event_source_info

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

410: ,p_valuation_method => NULL
411: ,p_security_context => l_event_security_context);
412:
413: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
414: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Reset event_id:'||l_event_id);
415: END IF;
416:
417: reset_event(l_event_id);
418:

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

442: ,p_security_context => l_event_security_context) OR
443: fv_be_gl_date_Rec.event_id IS NULL THEN
444: -- Create Event
445: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
446: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Call xla_events_pub_pkg.create_event');
447: END IF;
448: l_event_id := XLA_EVENTS_PUB_PKG.CREATE_EVENT
449: (p_event_source_info => l_event_source_info
450: ,p_event_type_code => g_event_type

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

459: ELSE
460: l_event_id := fv_be_gl_date_Rec.event_id;
461: END IF;
462: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
463: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Event_id:'||l_event_id);
464: END IF;
465:
466: IF(l_event_id IS NOT NULL) THEN
467: -- Stamp Event in FV_BE_TRX_DTLS/FV_BE_RPR_TRANSACTIONS table

Line 512: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

508:
509: l_module_name := G_MODULE_NAME ||'GET_EVENT_SOURCE_INFO';
510:
511: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
512: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
513: 'get_event_source_info start..');
514: END IF;
515:
516: l_prepare_stmt := 'SELECT DOC_NUMBER FROM ';

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

529:
530: END IF;
531:
532: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
533: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name||'get_event_source_info start..');
534: END IF;
535:
536: EXECUTE IMMEDIATE l_prepare_stmt INTO l_doc_num USING g_doc_id;
537:

Line 678: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

674: l_module_name varchar2(1000);
675: Begin
676: l_module_name := G_MODULE_NAME ||'GET_CCID';
677: If (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) Then
678: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
679: 'GET_CCID Parameters ' );
680: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
681: 'Application Short Name ' || application_short_name );
682: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

Line 680: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

676: l_module_name := G_MODULE_NAME ||'GET_CCID';
677: If (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) Then
678: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
679: 'GET_CCID Parameters ' );
680: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
681: 'Application Short Name ' || application_short_name );
682: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
683: 'Flex Code ' || key_flex_code);
684: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

Line 682: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

678: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
679: 'GET_CCID Parameters ' );
680: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
681: 'Application Short Name ' || application_short_name );
682: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
683: 'Flex Code ' || key_flex_code);
684: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
685: 'Chart of Account Id ' || structure_number );
686: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

Line 684: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

680: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
681: 'Application Short Name ' || application_short_name );
682: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
683: 'Flex Code ' || key_flex_code);
684: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
685: 'Chart of Account Id ' || structure_number );
686: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
687: 'Concatenated Segments ' || concatenated_segments);
688: End If;

Line 686: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

682: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
683: 'Flex Code ' || key_flex_code);
684: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
685: 'Chart of Account Id ' || structure_number );
686: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
687: 'Concatenated Segments ' || concatenated_segments);
688: End If;
689:
690: l_date := validation_date;

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

691: l_delim := fnd_flex_ext.get_delimiter(
692: application_short_name
693: ,key_flex_code
694: ,structure_number);
695: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name, 'Delimiter ' || l_delim);
696:
697: l_num := fnd_flex_ext.breakup_segments(
698: concatenated_segments
699: ,l_delim

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

698: concatenated_segments
699: ,l_delim
700: ,l_segarray);
701: If (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) Then
702: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name, 'No of Segments ' || l_num);
703: End If;
704:
705: If fnd_flex_ext.get_combination_id(
706: application_short_name => application_short_name

Line 715: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

711: ,segments => l_segarray
712: ,combination_id => l_ccid
713: ,data_set => l_data_set) Then
714: If (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) Then
715: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
716: 'Code Combination Id fetched ' || l_ccid);
717: End If;
718: Return (l_ccid);
719: End If;

Line 721: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

717: End If;
718: Return (l_ccid);
719: End If;
720: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
721: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
722: 'Code Combination Id cannot be fetched returning 0 ');
723: End If;
724: Return (0);
725: Exception

Line 728: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

724: Return (0);
725: Exception
726: When Others Then
727: If (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
728: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
729: 'Exception encountered returning 0 ');
730: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
731: 'Exception ' || sqlerrm);
732: End If;

Line 730: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,

726: When Others Then
727: If (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
728: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
729: 'Exception encountered returning 0 ');
730: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
731: 'Exception ' || sqlerrm);
732: End If;
733: Return(0);
734: End GET_CCID;