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_BE_XLA_PKG dependencies on FND_FILE

Line 147: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start with FV_BE_XLA_PKG.Budgetary_Control');

143: l_packet_id GL_BC_PACKETS.PACKET_ID%TYPE;
144:
145: BEGIN
146:
147: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start with FV_BE_XLA_PKG.Budgetary_Control');
148:
149: l_calling_sequence := p_calling_sequence ||
150: ' -> FV_BE_XLA_PKG.BUDGETARY_CONTROL';
151:

Line 186: FND_FILE.PUT_LINE(FND_FILE.LOG,'Input Parameter values...');

182: g_ledger_id := p_ledger_id;
183: g_accounting_date:= p_accounting_date;
184: l_bc_mode := p_bc_mode;
185:
186: FND_FILE.PUT_LINE(FND_FILE.LOG,'Input Parameter values...');
187: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_application_id -->'||g_application_id);
188: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_doc_type -->'||g_doc_type);
189: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_event_type -->'||g_event_type);
190: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_doc_id -->'||g_doc_id);

Line 187: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_application_id -->'||g_application_id);

183: g_accounting_date:= p_accounting_date;
184: l_bc_mode := p_bc_mode;
185:
186: FND_FILE.PUT_LINE(FND_FILE.LOG,'Input Parameter values...');
187: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_application_id -->'||g_application_id);
188: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_doc_type -->'||g_doc_type);
189: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_event_type -->'||g_event_type);
190: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_doc_id -->'||g_doc_id);
191: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ledger_id -->'||g_ledger_id);

Line 188: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_doc_type -->'||g_doc_type);

184: l_bc_mode := p_bc_mode;
185:
186: FND_FILE.PUT_LINE(FND_FILE.LOG,'Input Parameter values...');
187: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_application_id -->'||g_application_id);
188: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_doc_type -->'||g_doc_type);
189: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_event_type -->'||g_event_type);
190: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_doc_id -->'||g_doc_id);
191: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ledger_id -->'||g_ledger_id);
192: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_accounting_date -->'||g_accounting_date);

Line 189: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_event_type -->'||g_event_type);

185:
186: FND_FILE.PUT_LINE(FND_FILE.LOG,'Input Parameter values...');
187: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_application_id -->'||g_application_id);
188: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_doc_type -->'||g_doc_type);
189: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_event_type -->'||g_event_type);
190: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_doc_id -->'||g_doc_id);
191: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ledger_id -->'||g_ledger_id);
192: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_accounting_date -->'||g_accounting_date);
193: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_bc_mode -->'||l_bc_mode);

Line 190: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_doc_id -->'||g_doc_id);

186: FND_FILE.PUT_LINE(FND_FILE.LOG,'Input Parameter values...');
187: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_application_id -->'||g_application_id);
188: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_doc_type -->'||g_doc_type);
189: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_event_type -->'||g_event_type);
190: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_doc_id -->'||g_doc_id);
191: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ledger_id -->'||g_ledger_id);
192: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_accounting_date -->'||g_accounting_date);
193: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_bc_mode -->'||l_bc_mode);
194:

Line 191: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ledger_id -->'||g_ledger_id);

187: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_application_id -->'||g_application_id);
188: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_doc_type -->'||g_doc_type);
189: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_event_type -->'||g_event_type);
190: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_doc_id -->'||g_doc_id);
191: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ledger_id -->'||g_ledger_id);
192: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_accounting_date -->'||g_accounting_date);
193: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_bc_mode -->'||l_bc_mode);
194:
195:

Line 192: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_accounting_date -->'||g_accounting_date);

188: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_doc_type -->'||g_doc_type);
189: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_event_type -->'||g_event_type);
190: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_doc_id -->'||g_doc_id);
191: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ledger_id -->'||g_ledger_id);
192: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_accounting_date -->'||g_accounting_date);
193: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_bc_mode -->'||l_bc_mode);
194:
195:
196: IF l_bc_mode ='C' THEN

Line 193: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_bc_mode -->'||l_bc_mode);

189: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_event_type -->'||g_event_type);
190: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_doc_id -->'||g_doc_id);
191: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ledger_id -->'||g_ledger_id);
192: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_accounting_date -->'||g_accounting_date);
193: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_bc_mode -->'||l_bc_mode);
194:
195:
196: IF l_bc_mode ='C' THEN
197: l_init_msg_list := FND_API.G_TRUE;

Line 211: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoke Create_BE_Acct_Event() ');

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() ');
212:
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);

Line 215: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_event_id -->'||l_event_id);

211: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoke Create_BE_Acct_Event() ');
212:
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;

Line 227: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoke populate_bc_events() ');

223: 'call populate_bc_events_tab');
224: END IF;
225:
226: -- Insert into psa_bc_xla_events_gt
227: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoke populate_bc_events() ');
228: populate_bc_events_tab;
229:
230:
231: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 237: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoke PSA_BC_XLA_PUB.Budgetary_Control() ');

233: END IF;
234:
235:
236: -- call PSA Budgetary Control API
237: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoke PSA_BC_XLA_PUB.Budgetary_Control() ');
238:
239: PSA_BC_XLA_PUB.Budgetary_Control (p_api_version => 1.0
240: ,p_init_msg_list => l_init_msg_list
241: ,x_return_status => l_return_status

Line 253: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA Budgetary Control API Success');

249: ,x_status_code => l_status_code
250: ,x_packet_id => l_packet_id);
251:
252: IF l_status_code IN ('SUCCESS','PARTIAL','ADVISORY') THEN
253: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA Budgetary Control API Success');
254: ELSIF l_status_code = 'XLA_ERROR' THEN
255: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API failed with XLA_ERROR');
256: ELSIF l_status_code IN ('FAIL','RFAIL','FATAL') THEN
257: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API failed with some technical problem');

Line 255: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API failed with XLA_ERROR');

251:
252: IF l_status_code IN ('SUCCESS','PARTIAL','ADVISORY') THEN
253: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA Budgetary Control API Success');
254: ELSIF l_status_code = 'XLA_ERROR' THEN
255: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API failed with XLA_ERROR');
256: ELSIF l_status_code IN ('FAIL','RFAIL','FATAL') THEN
257: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API failed with some technical problem');
258: ELSIF l_status_code = 'XLA_NO_JOURNAL' THEN
259: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API success but with NO SLA Journal ');

Line 257: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API failed with some technical problem');

253: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA Budgetary Control API Success');
254: ELSIF l_status_code = 'XLA_ERROR' THEN
255: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API failed with XLA_ERROR');
256: ELSIF l_status_code IN ('FAIL','RFAIL','FATAL') THEN
257: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API failed with some technical problem');
258: ELSIF l_status_code = 'XLA_NO_JOURNAL' THEN
259: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API success but with NO SLA Journal ');
260: ELSE
261: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API failed with unknown error');

Line 259: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API success but with NO SLA Journal ');

255: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API failed with XLA_ERROR');
256: ELSIF l_status_code IN ('FAIL','RFAIL','FATAL') THEN
257: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API failed with some technical problem');
258: ELSIF l_status_code = 'XLA_NO_JOURNAL' THEN
259: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API success but with NO SLA Journal ');
260: ELSE
261: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API failed with unknown error');
262: END IF;
263:

Line 261: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API failed with unknown error');

257: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API failed with some technical problem');
258: ELSIF l_status_code = 'XLA_NO_JOURNAL' THEN
259: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API success but with NO SLA Journal ');
260: ELSE
261: FND_FILE.PUT_LINE(FND_FILE.LOG,'PSA BC API failed with unknown error');
262: END IF;
263:
264: -- Assign the local status values to the return variables
265: x_status_code := l_status_code;

Line 352: FND_FILE.PUT_LINE(FND_FILE.LOG,'Begin Create_BE_Acct_event function');

348:
349: l_entity_deleted INTEGER;
350:
351: BEGIN
352: FND_FILE.PUT_LINE(FND_FILE.LOG,'Begin Create_BE_Acct_event function');
353:
354: l_module_name := G_MODULE_NAME ||'CREATE_BE_ACCT_EVENTS';
355:
356: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 468: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invoke Stamp_Event()');

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
468: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invoke Stamp_Event()');
469: stamp_event(l_event_id);
470: END IF;
471: END LOOP;
472: END;

Line 473: FND_FILE.PUT_LINE(FND_FILE.LOG,'End of Create_BE_Acct_Event');

469: stamp_event(l_event_id);
470: END IF;
471: END LOOP;
472: END;
473: FND_FILE.PUT_LINE(FND_FILE.LOG,'End of Create_BE_Acct_Event');
474:
475: return l_event_id;
476:
477: END CREATE_BE_ACCT_EVENT;

Line 507: FND_FILE.PUT_LINE(FND_FILE.LOG,'Begin Get_Event_Source_Info');

503: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
504: l_module_name VARCHAR2(1000);
505:
506: BEGIN
507: FND_FILE.PUT_LINE(FND_FILE.LOG,'Begin Get_Event_Source_Info');
508:
509: l_module_name := G_MODULE_NAME ||'GET_EVENT_SOURCE_INFO';
510:
511: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 543: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Get_Event_Source_Info');

539: l_event_source_info.application_id := g_application_id;
540: l_event_source_info.ledger_id := g_ledger_id;
541: l_event_source_info.source_id_int_1 := g_doc_id;
542:
543: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Get_Event_Source_Info');
544:
545: RETURN l_event_source_info;
546:
547: END get_event_source_info;

Line 568: FND_FILE.PUT_LINE(FND_FILE.LOG,'Begin Populate_BC_Events_Tab');

564: PROCEDURE populate_bc_events_tab
565: IS
566: BEGIN
567:
568: FND_FILE.PUT_LINE(FND_FILE.LOG,'Begin Populate_BC_Events_Tab');
569:
570: IF g_doc_id is null THEN
571: RETURN;
572: ELSE

Line 582: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Populate_BC_Events_Tab');

578: INSERT INTO psa_bc_xla_events_gt(event_id,result_code)
579: SELECT distinct event_id,'XLA_ERROR' FROM FV_BE_RPR_TRANSACTIONS WHERE transaction_id = g_doc_id;
580: END IF;
581: END IF;
582: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Populate_BC_Events_Tab');
583: END populate_bc_events_tab;
584:
585: /*=========================================================================
586: | PROCEDURE - STAMP_EVENT(PRIVATE)

Line 604: FND_FILE.PUT_LINE(FND_FILE.LOG,'Begin Stamp_Event');

600:
601: PROCEDURE stamp_event(p_event_id XLA_EVENTS.EVENT_ID%TYPE)
602: IS
603: BEGIN
604: FND_FILE.PUT_LINE(FND_FILE.LOG,'Begin Stamp_Event');
605:
606: IF g_doc_type = BE_ENTITY THEN
607: UPDATE FV_BE_TRX_DTLS
608: SET EVENT_ID = p_event_id

Line 619: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows ->'||SQL%ROWCOUNT||' updated with event_id ->'||p_event_id);

615: SET EVENT_ID = p_event_id
616: WHERE transaction_id = g_doc_id
617: AND gl_date = g_accounting_date;
618: END IF;
619: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows ->'||SQL%ROWCOUNT||' updated with event_id ->'||p_event_id);
620:
621: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Stamp_Event');
622:
623: END stamp_event;

Line 621: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Stamp_Event');

617: AND gl_date = g_accounting_date;
618: END IF;
619: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows ->'||SQL%ROWCOUNT||' updated with event_id ->'||p_event_id);
620:
621: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Stamp_Event');
622:
623: END stamp_event;
624:
625: /*============================================================================

Line 643: FND_FILE.PUT_LINE(FND_FILE.LOG,'Begin Reset_Event');

639:
640: PROCEDURE reset_event(p_event_id XLA_EVENTS.EVENT_ID%TYPE)
641: IS
642: BEGIN
643: FND_FILE.PUT_LINE(FND_FILE.LOG,'Begin Reset_Event');
644:
645: IF g_doc_type = BE_ENTITY THEN
646: UPDATE FV_BE_TRX_DTLS
647: SET EVENT_ID = null

Line 657: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows ->'||SQL%ROWCOUNT||' updated with null event_id ');

653: SET EVENT_ID = null
654: WHERE transaction_id = g_doc_id
655: AND event_id = p_event_id;
656: END IF;
657: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows ->'||SQL%ROWCOUNT||' updated with null event_id ');
658:
659: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Reset_Event');
660:
661: END reset_event;

Line 659: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Reset_Event');

655: AND event_id = p_event_id;
656: END IF;
657: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows ->'||SQL%ROWCOUNT||' updated with null event_id ');
658:
659: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Reset_Event');
660:
661: END reset_event;
662:
663: Function GET_CCID(application_short_name IN Varchar2