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.PSA_BC_XLA_PVT dependencies on PSA_UTILS

Line 63: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure psa_acctg_errors_insert');

59: l_path_name VARCHAR2(500);
60: BEGIN
61: l_path_name := g_path_name||'.psa_acctg_errors_insert';
62:
63: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure psa_acctg_errors_insert');
64:
65: FORALL i in 1..psa_events.COUNT
66: DELETE FROM psa_bc_accounting_errors
67: WHERE event_id = psa_events(i);

Line 68: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows deleted from psa_bc_accounting_erros: '||SQL%ROWCOUNT);

64:
65: FORALL i in 1..psa_events.COUNT
66: DELETE FROM psa_bc_accounting_errors
67: WHERE event_id = psa_events(i);
68: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows deleted from psa_bc_accounting_erros: '||SQL%ROWCOUNT);
69:
70: FORALL j in 1..psa_acctg_errors.COUNT
71: INSERT INTO psa_bc_accounting_errors VALUES psa_acctg_errors(j);
72: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows inserted into psa_bc_accounting_erros: '||SQL%ROWCOUNT);

Line 72: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows inserted into psa_bc_accounting_erros: '||SQL%ROWCOUNT);

68: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows deleted from psa_bc_accounting_erros: '||SQL%ROWCOUNT);
69:
70: FORALL j in 1..psa_acctg_errors.COUNT
71: INSERT INTO psa_bc_accounting_errors VALUES psa_acctg_errors(j);
72: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows inserted into psa_bc_accounting_erros: '||SQL%ROWCOUNT);
73:
74: COMMIT;
75: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure psa_acctg_errors_insert');
76:

Line 75: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure psa_acctg_errors_insert');

71: INSERT INTO psa_bc_accounting_errors VALUES psa_acctg_errors(j);
72: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows inserted into psa_bc_accounting_erros: '||SQL%ROWCOUNT);
73:
74: COMMIT;
75: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure psa_acctg_errors_insert');
76:
77: END psa_acctg_errors_insert;
78:
79:

Line 250: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure budgetary_control ' );

246: --
247: -- Start of the budgetary control
248: --
249: l_path_name := g_path_name || '.Budgetary_Control';
250: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure budgetary_control ' );
251:
252: --
253: -- Get the parameters values
254: --

Line 255: psa_utils.debug_other_string(g_state_level,l_path_name, 'Application Id = ' ||p_application_id);

251:
252: --
253: -- Get the parameters values
254: --
255: psa_utils.debug_other_string(g_state_level,l_path_name, 'Application Id = ' ||p_application_id);
256: psa_utils.debug_other_string(g_state_level,l_path_name, 'Budgetary Control Mode = ' ||p_bc_mode);
257: psa_utils.debug_other_string(g_state_level,l_path_name, 'Override Flag = ' ||p_override_flag);
258: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Id = ' ||p_user_id);
259: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Responsibility Id = ' ||p_user_resp_id);

Line 256: psa_utils.debug_other_string(g_state_level,l_path_name, 'Budgetary Control Mode = ' ||p_bc_mode);

252: --
253: -- Get the parameters values
254: --
255: psa_utils.debug_other_string(g_state_level,l_path_name, 'Application Id = ' ||p_application_id);
256: psa_utils.debug_other_string(g_state_level,l_path_name, 'Budgetary Control Mode = ' ||p_bc_mode);
257: psa_utils.debug_other_string(g_state_level,l_path_name, 'Override Flag = ' ||p_override_flag);
258: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Id = ' ||p_user_id);
259: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Responsibility Id = ' ||p_user_resp_id);
260:

Line 257: psa_utils.debug_other_string(g_state_level,l_path_name, 'Override Flag = ' ||p_override_flag);

253: -- Get the parameters values
254: --
255: psa_utils.debug_other_string(g_state_level,l_path_name, 'Application Id = ' ||p_application_id);
256: psa_utils.debug_other_string(g_state_level,l_path_name, 'Budgetary Control Mode = ' ||p_bc_mode);
257: psa_utils.debug_other_string(g_state_level,l_path_name, 'Override Flag = ' ||p_override_flag);
258: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Id = ' ||p_user_id);
259: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Responsibility Id = ' ||p_user_resp_id);
260:
261: IF (FND_API.to_boolean(p_init_msg_list)) THEN

Line 258: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Id = ' ||p_user_id);

254: --
255: psa_utils.debug_other_string(g_state_level,l_path_name, 'Application Id = ' ||p_application_id);
256: psa_utils.debug_other_string(g_state_level,l_path_name, 'Budgetary Control Mode = ' ||p_bc_mode);
257: psa_utils.debug_other_string(g_state_level,l_path_name, 'Override Flag = ' ||p_override_flag);
258: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Id = ' ||p_user_id);
259: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Responsibility Id = ' ||p_user_resp_id);
260:
261: IF (FND_API.to_boolean(p_init_msg_list)) THEN
262: FND_MSG_PUB.initialize;

Line 259: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Responsibility Id = ' ||p_user_resp_id);

255: psa_utils.debug_other_string(g_state_level,l_path_name, 'Application Id = ' ||p_application_id);
256: psa_utils.debug_other_string(g_state_level,l_path_name, 'Budgetary Control Mode = ' ||p_bc_mode);
257: psa_utils.debug_other_string(g_state_level,l_path_name, 'Override Flag = ' ||p_override_flag);
258: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Id = ' ||p_user_id);
259: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Responsibility Id = ' ||p_user_resp_id);
260:
261: IF (FND_API.to_boolean(p_init_msg_list)) THEN
262: FND_MSG_PUB.initialize;
263: END IF;

Line 273: psa_utils.debug_other_string(g_state_level,l_path_name,'Start of Parameter Validation');

269: l_bc_mode := p_bc_mode;
270: l_override_flag := p_override_flag;
271: l_application_id:= p_application_id;
272: l_xla_error := 'N';
273: psa_utils.debug_other_string(g_state_level,l_path_name,'Start of Parameter Validation');
274:
275: --
276: -- parameter validations
277: --

Line 296: psa_utils.debug_other_msg(p_level => g_error_level,

292: IF (l_bc_mode NOT IN (C_FUNDS_CHECK,C_FUNDS_CHK_FULL,C_FUNDS_RESERVE,C_FUNDS_PARTIAL,C_FUNDS_FORCE_PASS,C_FUNDS_ADVISORY)) THEN
293: Fnd_message.set_name('PSA','PSA_BC_PARAMETERS_ERROR');
294: Fnd_Message.Set_Token('PARAM_NAME','Funds Mode');
295: Fnd_Msg_Pub.ADD;
296: psa_utils.debug_other_msg(p_level => g_error_level,
297: p_full_path => l_path_name,
298: p_remove_from_stack => FALSE);
299: Fnd_file.put_line(fnd_file.log, fnd_message.get);
300: RAISE Fnd_Api.G_Exc_Error;

Line 311: psa_utils.debug_other_msg(p_level => g_error_level,

307: IF (l_override_flag NOT IN (C_YES,C_NO)) THEN
308: Fnd_message.set_name('PSA','PSA_BC_PARAMETERS_ERROR');
309: Fnd_Message.Set_Token('PARAM_NAME','Override Flag');
310: Fnd_Msg_Pub.ADD;
311: psa_utils.debug_other_msg(p_level => g_error_level,
312: p_full_path => l_path_name,
313: p_remove_from_stack => FALSE);
314: Fnd_file.put_line(fnd_file.log, fnd_message.get);
315:

Line 320: psa_utils.debug_other_string(g_state_level,l_path_name,'End of Parameter Validation');

316: RAISE Fnd_Api.G_Exc_Error;
317: END IF;
318: END IF;
319:
320: psa_utils.debug_other_string(g_state_level,l_path_name,'End of Parameter Validation');
321: --
322: -- Assign the wf parameters to global varibales.
323: -- These variables are used by accounitng engine while calling the funds checker
324: --

Line 336: psa_utils.debug_other_string(g_state_level,l_path_name,'Accounting Mode is FUNDS_CHECK');

332: -- Assign the parameters required for calling SLA Accounting engine
333: --
334: IF l_bc_mode IN (C_FUNDS_CHECK,C_FUNDS_CHK_FULL) THEN -- check funds draft mode
335: l_accounting_mode := 'FUNDS_CHECK';
336: psa_utils.debug_other_string(g_state_level,l_path_name,'Accounting Mode is FUNDS_CHECK');
337: ELSE
338: l_accounting_mode := 'FUNDS_RESERVE'; -- Reserve Funds in final mode
339: psa_utils.debug_other_string(g_state_level,l_path_name,'Accounting Mode is FUNDS_RESERVE');
340: END IF;

Line 339: psa_utils.debug_other_string(g_state_level,l_path_name,'Accounting Mode is FUNDS_RESERVE');

335: l_accounting_mode := 'FUNDS_CHECK';
336: psa_utils.debug_other_string(g_state_level,l_path_name,'Accounting Mode is FUNDS_CHECK');
337: ELSE
338: l_accounting_mode := 'FUNDS_RESERVE'; -- Reserve Funds in final mode
339: psa_utils.debug_other_string(g_state_level,l_path_name,'Accounting Mode is FUNDS_RESERVE');
340: END IF;
341:
342: l_accounting_flag := 'Y'; -- Accounting required
343: l_transfer_flag := 'N'; -- No transfer to GL

Line 372: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in psa_bc_xla_events_gt table Prior to PA/GMS API ' || l_count );

368: END IF;
369: return;
370: END IF;
371:
372: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in psa_bc_xla_events_gt table Prior to PA/GMS API ' || l_count );
373:
374: ---------------------------------------------------------------
375: -- Calling PA/GMS INTEGRATION API PRIOR TO SLA ONLINE
376: ---------------------------------------------------------------

Line 378: psa_utils.debug_other_string(g_state_level,l_path_name, 'Now invoking the PA_GMS_INTEGRATION_API' );

374: ---------------------------------------------------------------
375: -- Calling PA/GMS INTEGRATION API PRIOR TO SLA ONLINE
376: ---------------------------------------------------------------
377:
378: psa_utils.debug_other_string(g_state_level,l_path_name, 'Now invoking the PA_GMS_INTEGRATION_API' );
379: pa_gms_integration_api;
380:
381: SELECT count(*) INTO l_count
382: FROM psa_bc_xla_events_gt;

Line 384: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in psa_bc_xla_events_gt table after invoking PA/GMS API ' || l_count );

380:
381: SELECT count(*) INTO l_count
382: FROM psa_bc_xla_events_gt;
383:
384: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in psa_bc_xla_events_gt table after invoking PA/GMS API ' || l_count );
385:
386: IF l_count < 1 THEN
387:
388: x_status_code := 'FATAL';

Line 401: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

397: -- Update the PSA_BC_XLA_EVENTS_GT event records to be in 'XLA_UNPROCESSED' status
398: --
399: UPDATE psa_bc_xla_events_gt
400: SET result_code = 'XLA_UNPROCESSED';
401: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
402:
403:
404:
405:

Line 415: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from XLA_ACCT_PROG_EVENTS_GT table before insertion: ' || SQL%ROWCOUNT );

411: psa_cleanup_gt;
412:
413: /* ---- 7460759 ---------------------------------------------------------------------------
414: DELETE from XLA_ACCT_PROG_EVENTS_GT;
415: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from XLA_ACCT_PROG_EVENTS_GT table before insertion: ' || SQL%ROWCOUNT );
416: DELETE from xla_ae_headers_gt;
417: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_headers_gt table before insertion: ' || SQL%ROWCOUNT);
418: DELETE from xla_ae_lines_gt;
419: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_lines_gt table before insertion: ' || SQL%ROWCOUNT);

Line 417: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_headers_gt table before insertion: ' || SQL%ROWCOUNT);

413: /* ---- 7460759 ---------------------------------------------------------------------------
414: DELETE from XLA_ACCT_PROG_EVENTS_GT;
415: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from XLA_ACCT_PROG_EVENTS_GT table before insertion: ' || SQL%ROWCOUNT );
416: DELETE from xla_ae_headers_gt;
417: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_headers_gt table before insertion: ' || SQL%ROWCOUNT);
418: DELETE from xla_ae_lines_gt;
419: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_lines_gt table before insertion: ' || SQL%ROWCOUNT);
420: DELETE from xla_validation_lines_gt;
421: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_validation_lines_gt table before insertion: ' || SQL%ROWCOUNT);

Line 419: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_lines_gt table before insertion: ' || SQL%ROWCOUNT);

415: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from XLA_ACCT_PROG_EVENTS_GT table before insertion: ' || SQL%ROWCOUNT );
416: DELETE from xla_ae_headers_gt;
417: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_headers_gt table before insertion: ' || SQL%ROWCOUNT);
418: DELETE from xla_ae_lines_gt;
419: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_lines_gt table before insertion: ' || SQL%ROWCOUNT);
420: DELETE from xla_validation_lines_gt;
421: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_validation_lines_gt table before insertion: ' || SQL%ROWCOUNT);
422: DELETE from xla_evt_class_orders_gt;
423: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_evt_class_orders_gt; table before insertion: ' || SQL%ROWCOUNT);

Line 421: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_validation_lines_gt table before insertion: ' || SQL%ROWCOUNT);

417: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_headers_gt table before insertion: ' || SQL%ROWCOUNT);
418: DELETE from xla_ae_lines_gt;
419: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_lines_gt table before insertion: ' || SQL%ROWCOUNT);
420: DELETE from xla_validation_lines_gt;
421: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_validation_lines_gt table before insertion: ' || SQL%ROWCOUNT);
422: DELETE from xla_evt_class_orders_gt;
423: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_evt_class_orders_gt; table before insertion: ' || SQL%ROWCOUNT);
424: */
425: DELETE from psa_option_details_gt;

Line 423: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_evt_class_orders_gt; table before insertion: ' || SQL%ROWCOUNT);

419: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_lines_gt table before insertion: ' || SQL%ROWCOUNT);
420: DELETE from xla_validation_lines_gt;
421: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_validation_lines_gt table before insertion: ' || SQL%ROWCOUNT);
422: DELETE from xla_evt_class_orders_gt;
423: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_evt_class_orders_gt; table before insertion: ' || SQL%ROWCOUNT);
424: */
425: DELETE from psa_option_details_gt;
426: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from psa_option_details_gt table before insertion: ' || SQL%ROWCOUNT);
427: DELETE from psa_bc_alloc_gt;

Line 426: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from psa_option_details_gt table before insertion: ' || SQL%ROWCOUNT);

422: DELETE from xla_evt_class_orders_gt;
423: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_evt_class_orders_gt; table before insertion: ' || SQL%ROWCOUNT);
424: */
425: DELETE from psa_option_details_gt;
426: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from psa_option_details_gt table before insertion: ' || SQL%ROWCOUNT);
427: DELETE from psa_bc_alloc_gt;
428: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from psa_bc_alloc_gt table before insertion: ' || SQL%ROWCOUNT);
429: ------------------------------------------------------------------------------------- *
430:

Line 428: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from psa_bc_alloc_gt table before insertion: ' || SQL%ROWCOUNT);

424: */
425: DELETE from psa_option_details_gt;
426: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from psa_option_details_gt table before insertion: ' || SQL%ROWCOUNT);
427: DELETE from psa_bc_alloc_gt;
428: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from psa_bc_alloc_gt table before insertion: ' || SQL%ROWCOUNT);
429: ------------------------------------------------------------------------------------- *
430:
431: -- Insert rows to XLA Events GT table and Call Accounting Engine
432: -----------------------------------------------------------------

Line 436: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in inserted into XLA_ACCT_PROG_EVENTS_GT table: ' || SQL%ROWCOUNT );

432: -----------------------------------------------------------------
433:
434: INSERT into XLA_ACCT_PROG_EVENTS_GT (Event_Id)
435: SELECT event_id FROM psa_bc_xla_events_gt;
436: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in inserted into XLA_ACCT_PROG_EVENTS_GT table: ' || SQL%ROWCOUNT );
437:
438: l_accounting_events := TRUE;
439: l_accounting_batch_id := NULL;
440: l_errbuf := NULL;

Line 444: psa_utils.debug_other_string(g_state_level,l_path_name, 'PSA_BC_XLA_EVENTS_GT');

440: l_errbuf := NULL;
441: l_retcode := NULL;
442: l_request_id := NULL;
443:
444: psa_utils.debug_other_string(g_state_level,l_path_name, 'PSA_BC_XLA_EVENTS_GT');
445: psa_utils.debug_other_string(g_state_level,l_path_name, '=====================');
446:
447: FOR x in c_get_bc_xla_events_gt
448: LOOP

Line 445: psa_utils.debug_other_string(g_state_level,l_path_name, '=====================');

441: l_retcode := NULL;
442: l_request_id := NULL;
443:
444: psa_utils.debug_other_string(g_state_level,l_path_name, 'PSA_BC_XLA_EVENTS_GT');
445: psa_utils.debug_other_string(g_state_level,l_path_name, '=====================');
446:
447: FOR x in c_get_bc_xla_events_gt
448: LOOP
449: psa_utils.debug_other_string(g_state_level,l_path_name, 'EVENT_ID = '||x.event_id);

Line 449: psa_utils.debug_other_string(g_state_level,l_path_name, 'EVENT_ID = '||x.event_id);

445: psa_utils.debug_other_string(g_state_level,l_path_name, '=====================');
446:
447: FOR x in c_get_bc_xla_events_gt
448: LOOP
449: psa_utils.debug_other_string(g_state_level,l_path_name, 'EVENT_ID = '||x.event_id);
450: psa_utils.debug_other_string(g_state_level,l_path_name, 'RESULT_CODE = '||x.result_code);
451: END LOOP;
452:
453: ----------------------------------------------------------------

Line 450: psa_utils.debug_other_string(g_state_level,l_path_name, 'RESULT_CODE = '||x.result_code);

446:
447: FOR x in c_get_bc_xla_events_gt
448: LOOP
449: psa_utils.debug_other_string(g_state_level,l_path_name, 'EVENT_ID = '||x.event_id);
450: psa_utils.debug_other_string(g_state_level,l_path_name, 'RESULT_CODE = '||x.result_code);
451: END LOOP;
452:
453: ----------------------------------------------------------------
454: -- Calling SLA online accounting engine API

Line 456: psa_utils.debug_other_string(g_state_level,l_path_name, 'Calling API xla_accounting_pub_pkg.accounting_program_events');

452:
453: ----------------------------------------------------------------
454: -- Calling SLA online accounting engine API
455: ----------------------------------------------------------------
456: psa_utils.debug_other_string(g_state_level,l_path_name, 'Calling API xla_accounting_pub_pkg.accounting_program_events');
457: xla_accounting_pub_pkg.accounting_program_events
458: ( p_application_id => P_application_id
459: ,p_accounting_mode => l_accounting_mode
460: ,p_gl_posting_flag => l_gl_posting_flag

Line 466: psa_utils.debug_other_string(g_state_level,l_path_name, 'Return Code = ' || l_retcode);

462: ,p_errbuf => l_errbuf
463: ,p_retcode => l_retcode
464: );
465:
466: psa_utils.debug_other_string(g_state_level,l_path_name, 'Return Code = ' || l_retcode);
467: psa_utils.debug_other_string(g_state_level,l_path_name, 'l_errbuf = ' ||l_errbuf );
468: psa_utils.debug_other_string(g_state_level,l_path_name, 'Accounting Batch id = ' ||l_accounting_batch_id );
469:
470: -- Get psa_bc_xla_events_gt events

Line 467: psa_utils.debug_other_string(g_state_level,l_path_name, 'l_errbuf = ' ||l_errbuf );

463: ,p_retcode => l_retcode
464: );
465:
466: psa_utils.debug_other_string(g_state_level,l_path_name, 'Return Code = ' || l_retcode);
467: psa_utils.debug_other_string(g_state_level,l_path_name, 'l_errbuf = ' ||l_errbuf );
468: psa_utils.debug_other_string(g_state_level,l_path_name, 'Accounting Batch id = ' ||l_accounting_batch_id );
469:
470: -- Get psa_bc_xla_events_gt events
471: OPEN c_get_psa_events;

Line 468: psa_utils.debug_other_string(g_state_level,l_path_name, 'Accounting Batch id = ' ||l_accounting_batch_id );

464: );
465:
466: psa_utils.debug_other_string(g_state_level,l_path_name, 'Return Code = ' || l_retcode);
467: psa_utils.debug_other_string(g_state_level,l_path_name, 'l_errbuf = ' ||l_errbuf );
468: psa_utils.debug_other_string(g_state_level,l_path_name, 'Accounting Batch id = ' ||l_accounting_batch_id );
469:
470: -- Get psa_bc_xla_events_gt events
471: OPEN c_get_psa_events;
472: FETCH c_get_psa_events BULK COLLECT INTO l_psa_events;

Line 484: psa_utils.debug_other_string(g_state_level,l_path_name, 'ERROR returned in SLA Accounting Engine API');

480: -- Delete/Save errors records from/into PSA BC accounting errors table
481: psa_acctg_errors_insert(l_psa_events,l_psa_acctg_errors);
482:
483: IF l_retcode = 2 THEN
484: psa_utils.debug_other_string(g_state_level,l_path_name, 'ERROR returned in SLA Accounting Engine API');
485: l_overall_success := FALSE;
486: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
487: Fnd_Message.Set_Token('PARAM_NAME',l_errbuf);
488: Fnd_Msg_Pub.ADD;

Line 493: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

489: -- update the psa_bc_xla_events_gt event records to
490: -- XLA_ERROR status
491: UPDATE psa_bc_xla_events_gt
492: SET result_code = 'XLA_ERROR';
493: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
494: -- set the status code
495: x_status_code := 'XLA_ERROR';
496: ELSE
497: psa_utils.debug_other_string(g_state_level,l_path_name,'Events processed by SLA Accounting Engine');

Line 497: psa_utils.debug_other_string(g_state_level,l_path_name,'Events processed by SLA Accounting Engine');

493: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
494: -- set the status code
495: x_status_code := 'XLA_ERROR';
496: ELSE
497: psa_utils.debug_other_string(g_state_level,l_path_name,'Events processed by SLA Accounting Engine');
498:
499: --
500: -- Update the PSA_BC_XLA_EVENTS_GT event records to be in 'XLA_NO_JOURNAL' status
501: -- for events that remain in XLA_UNPROCESSED status

Line 508: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

504: IF l_retcode = 0 THEN
505: UPDATE psa_bc_xla_events_gt
506: SET result_code = 'XLA_NO_JOURNAL'
507: WHERE result_code = 'XLA_UNPROCESSED';
508: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
509: END IF;
510:
511: IF l_retcode = 1 THEN
512: OPEN c_xla_errors;

Line 521: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

517: x_status_code := 'XLA_ERROR';
518:
519: UPDATE psa_bc_xla_events_gt
520: SET result_code = 'XLA_ERROR';
521: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
522: END IF;
523: END IF;
524:
525: -- Intialize status code to Success

Line 558: psa_utils.debug_other_string(g_state_level,l_path_name, 'Status Code= '||x_status_code);

554: END IF; -- advisory
555:
556:
557: END IF;
558: psa_utils.debug_other_string(g_state_level,l_path_name, 'Status Code= '||x_status_code);
559: ----------------------------------------------------
560: -- packet id will returned from gl_bc_packets
561: -- if more than one event per call of BC API
562: -- first packet id will be returned

Line 587: psa_utils.debug_other_string(g_state_level,l_path_name, 'CBC Installed');

583: -- fails in reserve mode, SBC funds check changes
584: -- will also be rolled back.
585: -----------------------------------------------------
586: IF p_application_id = 201 AND IGI_GEN.is_req_installed('CBC') = TRUE THEN
587: psa_utils.debug_other_string(g_state_level,l_path_name, 'CBC Installed');
588:
589: IF (x_status_code IN('SUCCESS','ADVISORY')) THEN
590: x_return_status := IGC_CBC_GL_FC_PKG.glzcbc(p_mode => p_bc_mode, p_conc_proc => FND_API.G_FALSE);
591:

Line 612: psa_utils.debug_other_string(g_state_level,l_path_name, 'Calling pa_gms_tieback_api');

608: -- Calling PA/GMS Tieback API's in case of Errors
609: ------------------------------------------------------
610:
611: IF (x_status_code IN('FATAL','XLA_ERROR', 'XLA_NO_JOURNAL')) THEN
612: psa_utils.debug_other_string(g_state_level,l_path_name, 'Calling pa_gms_tieback_api');
613: pa_gms_tieback_api;
614: END IF;
615: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure budgetary_control ' );
616:

Line 615: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure budgetary_control ' );

611: IF (x_status_code IN('FATAL','XLA_ERROR', 'XLA_NO_JOURNAL')) THEN
612: psa_utils.debug_other_string(g_state_level,l_path_name, 'Calling pa_gms_tieback_api');
613: pa_gms_tieback_api;
614: END IF;
615: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure budgetary_control ' );
616:
617: EXCEPTION
618:
619: WHEN FND_API.G_EXC_ERROR THEN

Line 624: psa_utils.debug_other_string(g_error_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));

620: x_return_status := FND_API.G_RET_STS_ERROR ;
621: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
622: ,p_count => x_msg_count
623: ,p_data => x_msg_data);
624: psa_utils.debug_other_string(g_error_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
625: psa_utils.debug_other_string(g_error_level,l_path_name,'Error in budgetary_control Procedure' );
626: pa_gms_tieback_api;
627:
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 625: psa_utils.debug_other_string(g_error_level,l_path_name,'Error in budgetary_control Procedure' );

621: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
622: ,p_count => x_msg_count
623: ,p_data => x_msg_data);
624: psa_utils.debug_other_string(g_error_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
625: psa_utils.debug_other_string(g_error_level,l_path_name,'Error in budgetary_control Procedure' );
626: pa_gms_tieback_api;
627:
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 630: psa_utils.debug_other_string(g_unexp_level,l_path_name, 'Unexpected Error'|| sqlerrm);

626: pa_gms_tieback_api;
627:
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
630: psa_utils.debug_other_string(g_unexp_level,l_path_name, 'Unexpected Error'|| sqlerrm);
631: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
632: ,p_count => x_msg_count
633: ,p_data => x_msg_data);
634:

Line 635: psa_utils.debug_other_string(g_unexp_level,l_path_name,'ERROR: Unexpected Error in budgetary_control Procedure' );

631: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
632: ,p_count => x_msg_count
633: ,p_data => x_msg_data);
634:
635: psa_utils.debug_other_string(g_unexp_level,l_path_name,'ERROR: Unexpected Error in budgetary_control Procedure' );
636: pa_gms_tieback_api;
637: WHEN OTHERS THEN
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 642: psa_utils.debug_unexpected_msg(G_PKG_NAME);

638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
640: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, 'PSA_BC_XLA_PVT');
641: END IF;
642: psa_utils.debug_unexpected_msg(G_PKG_NAME);
643: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
644: ,p_count => x_msg_count
645: ,p_data => x_msg_data);
646: psa_utils.debug_other_string(g_excep_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));

Line 646: psa_utils.debug_other_string(g_excep_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));

642: psa_utils.debug_unexpected_msg(G_PKG_NAME);
643: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
644: ,p_count => x_msg_count
645: ,p_data => x_msg_data);
646: psa_utils.debug_other_string(g_excep_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
647: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in budgetary_control Procedure' );
648: pa_gms_tieback_api;
649:
650: END Budgetary_Control;

Line 647: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in budgetary_control Procedure' );

643: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
644: ,p_count => x_msg_count
645: ,p_data => x_msg_data);
646: psa_utils.debug_other_string(g_excep_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
647: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in budgetary_control Procedure' );
648: pa_gms_tieback_api;
649:
650: END Budgetary_Control;
651:

Line 744: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of function get_sla_notupgraded_flag' );

740: AND xal.accounting_date > cp_r12_live_date;
741: BEGIN
742:
743: l_path_name := g_path_name || '.get_sla_notupgraded_flag';
744: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of function get_sla_notupgraded_flag' );
745:
746: psa_utils.debug_other_string(g_state_level,l_path_name,'Fetch PSA: R12 Upgrade Date profile value');
747:
748: l_r12_upgrade_date :=to_date( Fnd_Profile.Value_Wnps('PSA_R12_UPGRADE_DATE'), 'MM/DD/YYYY HH24:MI:SS'); -- fetch the profile value

Line 746: psa_utils.debug_other_string(g_state_level,l_path_name,'Fetch PSA: R12 Upgrade Date profile value');

742:
743: l_path_name := g_path_name || '.get_sla_notupgraded_flag';
744: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of function get_sla_notupgraded_flag' );
745:
746: psa_utils.debug_other_string(g_state_level,l_path_name,'Fetch PSA: R12 Upgrade Date profile value');
747:
748: l_r12_upgrade_date :=to_date( Fnd_Profile.Value_Wnps('PSA_R12_UPGRADE_DATE'), 'MM/DD/YYYY HH24:MI:SS'); -- fetch the profile value
749:
750: IF l_r12_upgrade_date IS NULL THEN

Line 751: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value does not contain a value');

747:
748: l_r12_upgrade_date :=to_date( Fnd_Profile.Value_Wnps('PSA_R12_UPGRADE_DATE'), 'MM/DD/YYYY HH24:MI:SS'); -- fetch the profile value
749:
750: IF l_r12_upgrade_date IS NULL THEN
751: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value does not contain a value');
752: psa_utils.debug_other_string(g_state_level,l_path_name,'Please check whether psar12upg.sql script was run');
753: RAISE Fnd_Api.G_Exc_Error;
754: END IF;
755:

Line 752: psa_utils.debug_other_string(g_state_level,l_path_name,'Please check whether psar12upg.sql script was run');

748: l_r12_upgrade_date :=to_date( Fnd_Profile.Value_Wnps('PSA_R12_UPGRADE_DATE'), 'MM/DD/YYYY HH24:MI:SS'); -- fetch the profile value
749:
750: IF l_r12_upgrade_date IS NULL THEN
751: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value does not contain a value');
752: psa_utils.debug_other_string(g_state_level,l_path_name,'Please check whether psar12upg.sql script was run');
753: RAISE Fnd_Api.G_Exc_Error;
754: END IF;
755:
756: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value = ' || to_char(l_r12_upgrade_date));

Line 756: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value = ' || to_char(l_r12_upgrade_date));

752: psa_utils.debug_other_string(g_state_level,l_path_name,'Please check whether psar12upg.sql script was run');
753: RAISE Fnd_Api.G_Exc_Error;
754: END IF;
755:
756: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value = ' || to_char(l_r12_upgrade_date));
757:
758: psa_utils.debug_other_string(g_state_level,l_path_name,'Fetch CREATION_DATE of the Distribution '|| p_distribution_id);
759:
760: IF p_dist_link_type = 'PO_REQ_DISTRIBUTIONS_ALL' THEN

Line 758: psa_utils.debug_other_string(g_state_level,l_path_name,'Fetch CREATION_DATE of the Distribution '|| p_distribution_id);

754: END IF;
755:
756: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value = ' || to_char(l_r12_upgrade_date));
757:
758: psa_utils.debug_other_string(g_state_level,l_path_name,'Fetch CREATION_DATE of the Distribution '|| p_distribution_id);
759:
760: IF p_dist_link_type = 'PO_REQ_DISTRIBUTIONS_ALL' THEN
761: SELECT min(creation_date) INTO l_dist_creation_date
762: FROM po_req_distributions_all

Line 773: psa_utils.debug_other_string(g_state_level,l_path_name,'Invalid Distribution Link Type'|| p_dist_link_type);

769: SELECT min(creation_date) INTO l_dist_creation_date
770: FROM ap_invoice_distributions_all
771: WHERE invoice_distribution_id = p_distribution_id;
772: ELSE
773: psa_utils.debug_other_string(g_state_level,l_path_name,'Invalid Distribution Link Type'|| p_dist_link_type);
774: RAISE Fnd_Api.G_Exc_Error;
775: END IF;
776:
777: psa_utils.debug_other_string(g_state_level,l_path_name,'Distribution CREATION_DATE = ' || to_char(l_dist_creation_date));

Line 777: psa_utils.debug_other_string(g_state_level,l_path_name,'Distribution CREATION_DATE = ' || to_char(l_dist_creation_date));

773: psa_utils.debug_other_string(g_state_level,l_path_name,'Invalid Distribution Link Type'|| p_dist_link_type);
774: RAISE Fnd_Api.G_Exc_Error;
775: END IF;
776:
777: psa_utils.debug_other_string(g_state_level,l_path_name,'Distribution CREATION_DATE = ' || to_char(l_dist_creation_date));
778:
779: IF (l_dist_creation_date > l_r12_upgrade_date) OR (l_dist_creation_date IS NULL) THEN
780: l_return_val := 'N';
781: ELSIF l_dist_creation_date <= l_r12_upgrade_date THEN

Line 816: psa_utils.debug_other_string(g_state_level,l_path_name,'Return Value = ' || l_return_val);

812: END IF;
813: END IF;
814: END IF;
815:
816: psa_utils.debug_other_string(g_state_level,l_path_name,'Return Value = ' || l_return_val);
817: psa_utils.debug_other_string(g_state_level,l_path_name,'END of function get_sla_notupgraded_flag' || l_path_name);
818: RETURN l_return_val;
819: EXCEPTION
820: WHEN others THEN

Line 817: psa_utils.debug_other_string(g_state_level,l_path_name,'END of function get_sla_notupgraded_flag' || l_path_name);

813: END IF;
814: END IF;
815:
816: psa_utils.debug_other_string(g_state_level,l_path_name,'Return Value = ' || l_return_val);
817: psa_utils.debug_other_string(g_state_level,l_path_name,'END of function get_sla_notupgraded_flag' || l_path_name);
818: RETURN l_return_val;
819: EXCEPTION
820: WHEN others THEN
821: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in function get_sla_notupgraded_flag' );

Line 821: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in function get_sla_notupgraded_flag' );

817: psa_utils.debug_other_string(g_state_level,l_path_name,'END of function get_sla_notupgraded_flag' || l_path_name);
818: RETURN l_return_val;
819: EXCEPTION
820: WHEN others THEN
821: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in function get_sla_notupgraded_flag' );
822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
823: END get_sla_notupgraded_flag;
824:
825:

Line 851: psa_utils.debug_other_string(g_state_level,l_path_name, 'pa_gms_integration_api invoked');

847: BEGIN
848:
849: l_path_name := g_path_name||'.pa_gms_integration_api';
850:
851: psa_utils.debug_other_string(g_state_level,l_path_name, 'pa_gms_integration_api invoked');
852: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke PA Integration API if PA is enabled');
853:
854: IF g_bc_mode ='C' THEN
855: l_partial_resv_flag := 'Y';

Line 852: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke PA Integration API if PA is enabled');

848:
849: l_path_name := g_path_name||'.pa_gms_integration_api';
850:
851: psa_utils.debug_other_string(g_state_level,l_path_name, 'pa_gms_integration_api invoked');
852: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke PA Integration API if PA is enabled');
853:
854: IF g_bc_mode ='C' THEN
855: l_partial_resv_flag := 'Y';
856: l_bc_mode := 'C';

Line 865: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_partial_resv_flag -> '||l_partial_resv_flag);

861: l_bc_mode := g_bc_mode;
862: l_partial_resv_flag := 'N';
863: END IF;
864:
865: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_partial_resv_flag -> '||l_partial_resv_flag);
866:
867: BEGIN
868: l_industry := NULL;
869: l_prepare_stmt := NULL;

Line 879: psa_utils.debug_other_string(g_state_level,l_path_name, ' Statement prepared -> '||l_prepare_stmt);

875:
876: l_pa_enabled := 0;
877: l_prepare_stmt := 'BEGIN IF PA_BUDGET_FUND_PKG.IS_PA_BC_ENABLED() THEN'||' :1 := 1; END IF; END;';
878:
879: psa_utils.debug_other_string(g_state_level,l_path_name, ' Statement prepared -> '||l_prepare_stmt);
880:
881: EXECUTE IMMEDIATE l_prepare_stmt USING OUT l_pa_enabled;
882:
883: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_pa_enabled -> '||l_pa_enabled);

Line 883: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_pa_enabled -> '||l_pa_enabled);

879: psa_utils.debug_other_string(g_state_level,l_path_name, ' Statement prepared -> '||l_prepare_stmt);
880:
881: EXECUTE IMMEDIATE l_prepare_stmt USING OUT l_pa_enabled;
882:
883: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_pa_enabled -> '||l_pa_enabled);
884:
885: IF l_pa_enabled = 1 THEN
886:
887: l_prepare_stmt := ' BEGIN '||

Line 897: psa_utils.debug_other_string(g_error_level,l_path_name, 'PA Integration API Failed');

893: IN l_partial_resv_flag,
894: IN l_bc_mode,
895: OUT l_ret_code;
896: IF (l_ret_code = 'F') THEN
897: psa_utils.debug_other_string(g_error_level,l_path_name, 'PA Integration API Failed');
898: FND_MESSAGE.SET_NAME('PA', 'PA_BC_FUND_CHK_FAIL');
899: FND_MSG_PUB.ADD;
900: RAISE FND_API.G_EXC_ERROR;
901: ELSE

Line 902: psa_utils.debug_other_string(g_state_level,l_path_name, 'PA Integration API Successful');

898: FND_MESSAGE.SET_NAME('PA', 'PA_BC_FUND_CHK_FAIL');
899: FND_MSG_PUB.ADD;
900: RAISE FND_API.G_EXC_ERROR;
901: ELSE
902: psa_utils.debug_other_string(g_state_level,l_path_name, 'PA Integration API Successful');
903: END IF;
904:
905: END IF;
906: END IF;

Line 911: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke GMS Integration API if GMS is enabled');

907: END IF;
908:
909: END;
910:
911: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke GMS Integration API if GMS is enabled');
912: l_ret_code := NULL;
913:
914: BEGIN
915: l_industry := NULL;

Line 926: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);

922:
923: l_gms_enabled := 0;
924: l_prepare_stmt := 'BEGIN IF GMS_INSTALL.ENABLED() THEN'||' :1 := 1; END IF; END;';
925:
926: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);
927:
928: EXECUTE IMMEDIATE l_prepare_stmt USING OUT l_gms_enabled;
929:
930: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_gms_enabled -> '||l_gms_enabled);

Line 930: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_gms_enabled -> '||l_gms_enabled);

926: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);
927:
928: EXECUTE IMMEDIATE l_prepare_stmt USING OUT l_gms_enabled;
929:
930: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_gms_enabled -> '||l_gms_enabled);
931:
932: IF l_gms_enabled = 1 THEN
933:
934: l_prepare_stmt := ' BEGIN '||

Line 938: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);

934: l_prepare_stmt := ' BEGIN '||
935: ' GMS_FUNDS_CONTROL_PKG.COPY_GL_PKT_TO_GMS_PKT ( '||
936: ' :application_id, :mode, :partial_resv_flag, :ret_code); '||
937: ' END; ';
938: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);
939: EXECUTE IMMEDIATE l_prepare_stmt USING IN g_application_id,
940: IN l_bc_mode,
941: IN l_partial_resv_flag,
942: OUT l_ret_code;

Line 944: psa_utils.debug_other_string(g_state_level,l_path_name, 'GMS Integration API Failed');

940: IN l_bc_mode,
941: IN l_partial_resv_flag,
942: OUT l_ret_code;
943: IF (l_ret_code = 'F') THEN
944: psa_utils.debug_other_string(g_state_level,l_path_name, 'GMS Integration API Failed');
945: FND_MESSAGE.SET_NAME('GMS', 'GMS_FUNDS_CHECK_FAILED');
946: FND_MSG_PUB.ADD;
947: RAISE FND_API.G_EXC_ERROR;
948: ELSE

Line 949: psa_utils.debug_other_string(g_state_level,l_path_name, 'GMS Integration API Successful');

945: FND_MESSAGE.SET_NAME('GMS', 'GMS_FUNDS_CHECK_FAILED');
946: FND_MSG_PUB.ADD;
947: RAISE FND_API.G_EXC_ERROR;
948: ELSE
949: psa_utils.debug_other_string(g_state_level,l_path_name, 'GMS Integration API Successful');
950: END IF;
951:
952: END IF;
953: END IF;

Line 959: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in pa_gms_integration_api' );

955:
956: END;
957: EXCEPTION
958: WHEN others THEN
959: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in pa_gms_integration_api' );
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961:
962: END pa_gms_integration_api;
963:

Line 977: psa_utils.debug_other_string(g_state_level,l_path_name, 'PA_GMS_TIEBACK_API Invoked');

973: l_bc_mode VARCHAR2(1);
974:
975: BEGIN
976: l_path_name := g_path_name||'.pa_gms_tieback_api';
977: psa_utils.debug_other_string(g_state_level,l_path_name, 'PA_GMS_TIEBACK_API Invoked');
978:
979: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke PA Tieback API if PA is enabled');
980:
981: IF g_bc_mode = 'C' THEN

Line 979: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke PA Tieback API if PA is enabled');

975: BEGIN
976: l_path_name := g_path_name||'.pa_gms_tieback_api';
977: psa_utils.debug_other_string(g_state_level,l_path_name, 'PA_GMS_TIEBACK_API Invoked');
978:
979: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke PA Tieback API if PA is enabled');
980:
981: IF g_bc_mode = 'C' THEN
982: l_bc_mode := 'C';
983: ELSIF g_bc_mode ='P' THEN

Line 1001: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);

997:
998: l_pa_enabled := 0;
999: l_prepare_stmt := 'BEGIN IF PA_BUDGET_FUND_PKG.IS_PA_BC_ENABLED() THEN'||' :1 := 1; END IF; END;';
1000:
1001: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);
1002:
1003: EXECUTE IMMEDIATE l_prepare_stmt USING OUT l_pa_enabled;
1004:
1005: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_pa_enabled -> '||l_pa_enabled);

Line 1005: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_pa_enabled -> '||l_pa_enabled);

1001: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);
1002:
1003: EXECUTE IMMEDIATE l_prepare_stmt USING OUT l_pa_enabled;
1004:
1005: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_pa_enabled -> '||l_pa_enabled);
1006:
1007: IF l_pa_enabled = 1 THEN
1008:
1009: l_prepare_stmt := ' BEGIN '||

Line 1012: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_pa_enabled -> '||l_pa_enabled);

1008:
1009: l_prepare_stmt := ' BEGIN '||
1010: ' PA_FUNDS_CONTROL_PKG1.TIEBACK_FAILED_ACCT_STATUS( '||':bc_mode );'||
1011: ' END; ';
1012: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_pa_enabled -> '||l_pa_enabled);
1013: EXECUTE IMMEDIATE l_prepare_stmt USING IN l_bc_mode;
1014:
1015: psa_utils.debug_other_string(g_state_level,l_path_name, 'PA Tieback API Successful');
1016:

Line 1015: psa_utils.debug_other_string(g_state_level,l_path_name, 'PA Tieback API Successful');

1011: ' END; ';
1012: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_pa_enabled -> '||l_pa_enabled);
1013: EXECUTE IMMEDIATE l_prepare_stmt USING IN l_bc_mode;
1014:
1015: psa_utils.debug_other_string(g_state_level,l_path_name, 'PA Tieback API Successful');
1016:
1017: END IF;
1018: END IF;
1019: END IF;

Line 1023: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke GMS Tieback API if GMS is enabled');

1019: END IF;
1020:
1021: END;
1022:
1023: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke GMS Tieback API if GMS is enabled');
1024:
1025: BEGIN
1026: l_industry := NULL;
1027: l_prepare_stmt := NULL;

Line 1037: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);

1033:
1034: l_gms_enabled := 0;
1035: l_prepare_stmt := 'BEGIN IF GMS_INSTALL.ENABLED() THEN'||' :1 := 1; END IF; END;';
1036:
1037: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);
1038:
1039: EXECUTE IMMEDIATE l_prepare_stmt USING OUT l_gms_enabled;
1040:
1041: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_gms_enabled -> '||l_gms_enabled);

Line 1041: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_gms_enabled -> '||l_gms_enabled);

1037: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);
1038:
1039: EXECUTE IMMEDIATE l_prepare_stmt USING OUT l_gms_enabled;
1040:
1041: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_gms_enabled -> '||l_gms_enabled);
1042:
1043: IF l_gms_enabled = 1 THEN
1044:
1045: l_prepare_stmt := ' BEGIN '||

Line 1048: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);

1044:
1045: l_prepare_stmt := ' BEGIN '||
1046: ' GMS_FUNDS_CONTROL_PKG.TIEBACK_FAILED_ACCT_STATUS( '||':bc_mode );'||
1047: ' END; ';
1048: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);
1049: EXECUTE IMMEDIATE l_prepare_stmt USING IN l_bc_mode;
1050:
1051: psa_utils.debug_other_string(g_state_level,l_path_name, 'GMS Tieback API Successful');
1052:

Line 1051: psa_utils.debug_other_string(g_state_level,l_path_name, 'GMS Tieback API Successful');

1047: ' END; ';
1048: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);
1049: EXECUTE IMMEDIATE l_prepare_stmt USING IN l_bc_mode;
1050:
1051: psa_utils.debug_other_string(g_state_level,l_path_name, 'GMS Tieback API Successful');
1052:
1053: END IF;
1054: END IF;
1055: END IF;

Line 1060: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in pa_gms_tieback_api' );

1056:
1057: END;
1058: EXCEPTION
1059: WHEN others THEN
1060: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in pa_gms_tieback_api' );
1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1062:
1063: END pa_gms_tieback_api;
1064:

Line 1072: psa_utils.debug_other_string(g_state_level,l_path_name,'Cleaning up xla GT Tables');

1068: l_path_name varchar2(300) ;
1069: BEGIN
1070: l_path_name := g_path_name || '.psa_cleanup_gt';
1071:
1072: psa_utils.debug_other_string(g_state_level,l_path_name,'Cleaning up xla GT Tables');
1073: DELETE FROM XLA_AE_HEADERS_GT;
1074: psa_utils.debug_other_string(g_state_level,l_path_name, '1 XLA_AE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1075: DELETE FROM XLA_AE_LINES_GT;
1076: psa_utils.debug_other_string(g_state_level,l_path_name, '2 XLA_AE_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1074: psa_utils.debug_other_string(g_state_level,l_path_name, '1 XLA_AE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1070: l_path_name := g_path_name || '.psa_cleanup_gt';
1071:
1072: psa_utils.debug_other_string(g_state_level,l_path_name,'Cleaning up xla GT Tables');
1073: DELETE FROM XLA_AE_HEADERS_GT;
1074: psa_utils.debug_other_string(g_state_level,l_path_name, '1 XLA_AE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1075: DELETE FROM XLA_AE_LINES_GT;
1076: psa_utils.debug_other_string(g_state_level,l_path_name, '2 XLA_AE_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1077: DELETE FROM XLA_VALIDATION_HDRS_GT;
1078: psa_utils.debug_other_string(g_state_level,l_path_name, '3 XLA_VALIDATION_HDRS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1076: psa_utils.debug_other_string(g_state_level,l_path_name, '2 XLA_AE_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);

1072: psa_utils.debug_other_string(g_state_level,l_path_name,'Cleaning up xla GT Tables');
1073: DELETE FROM XLA_AE_HEADERS_GT;
1074: psa_utils.debug_other_string(g_state_level,l_path_name, '1 XLA_AE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1075: DELETE FROM XLA_AE_LINES_GT;
1076: psa_utils.debug_other_string(g_state_level,l_path_name, '2 XLA_AE_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1077: DELETE FROM XLA_VALIDATION_HDRS_GT;
1078: psa_utils.debug_other_string(g_state_level,l_path_name, '3 XLA_VALIDATION_HDRS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1079: DELETE FROM XLA_VALIDATION_LINES_GT;
1080: psa_utils.debug_other_string(g_state_level,l_path_name, '4 XLA_VALIDATION_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1078: psa_utils.debug_other_string(g_state_level,l_path_name, '3 XLA_VALIDATION_HDRS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1074: psa_utils.debug_other_string(g_state_level,l_path_name, '1 XLA_AE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1075: DELETE FROM XLA_AE_LINES_GT;
1076: psa_utils.debug_other_string(g_state_level,l_path_name, '2 XLA_AE_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1077: DELETE FROM XLA_VALIDATION_HDRS_GT;
1078: psa_utils.debug_other_string(g_state_level,l_path_name, '3 XLA_VALIDATION_HDRS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1079: DELETE FROM XLA_VALIDATION_LINES_GT;
1080: psa_utils.debug_other_string(g_state_level,l_path_name, '4 XLA_VALIDATION_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1081: DELETE FROM XLA_BAL_CTRL_CTRBS_GT;
1082: psa_utils.debug_other_string(g_state_level,l_path_name, '5 XLA_BAL_CTRL_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1080: psa_utils.debug_other_string(g_state_level,l_path_name, '4 XLA_VALIDATION_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);

1076: psa_utils.debug_other_string(g_state_level,l_path_name, '2 XLA_AE_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1077: DELETE FROM XLA_VALIDATION_HDRS_GT;
1078: psa_utils.debug_other_string(g_state_level,l_path_name, '3 XLA_VALIDATION_HDRS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1079: DELETE FROM XLA_VALIDATION_LINES_GT;
1080: psa_utils.debug_other_string(g_state_level,l_path_name, '4 XLA_VALIDATION_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1081: DELETE FROM XLA_BAL_CTRL_CTRBS_GT;
1082: psa_utils.debug_other_string(g_state_level,l_path_name, '5 XLA_BAL_CTRL_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1083: DELETE FROM XLA_BAL_PERIOD_STATS_GT;
1084: psa_utils.debug_other_string(g_state_level,l_path_name, '6 XLA_BAL_PERIOD_STATS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1082: psa_utils.debug_other_string(g_state_level,l_path_name, '5 XLA_BAL_CTRL_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1078: psa_utils.debug_other_string(g_state_level,l_path_name, '3 XLA_VALIDATION_HDRS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1079: DELETE FROM XLA_VALIDATION_LINES_GT;
1080: psa_utils.debug_other_string(g_state_level,l_path_name, '4 XLA_VALIDATION_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1081: DELETE FROM XLA_BAL_CTRL_CTRBS_GT;
1082: psa_utils.debug_other_string(g_state_level,l_path_name, '5 XLA_BAL_CTRL_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1083: DELETE FROM XLA_BAL_PERIOD_STATS_GT;
1084: psa_utils.debug_other_string(g_state_level,l_path_name, '6 XLA_BAL_PERIOD_STATS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1085: DELETE FROM XLA_BAL_RECREATE_GT;
1086: psa_utils.debug_other_string(g_state_level,l_path_name, '7

Line 1084: psa_utils.debug_other_string(g_state_level,l_path_name, '6 XLA_BAL_PERIOD_STATS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1080: psa_utils.debug_other_string(g_state_level,l_path_name, '4 XLA_VALIDATION_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1081: DELETE FROM XLA_BAL_CTRL_CTRBS_GT;
1082: psa_utils.debug_other_string(g_state_level,l_path_name, '5 XLA_BAL_CTRL_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1083: DELETE FROM XLA_BAL_PERIOD_STATS_GT;
1084: psa_utils.debug_other_string(g_state_level,l_path_name, '6 XLA_BAL_PERIOD_STATS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1085: DELETE FROM XLA_BAL_RECREATE_GT;
1086: psa_utils.debug_other_string(g_state_level,l_path_name, '7
1087: XLA_BAL_RECREATE_GT : Deleted Row count :'||SQL%ROWCOUNT);
1088: DELETE FROM XLA_BAL_ANACRI_LINES_GT;

Line 1086: psa_utils.debug_other_string(g_state_level,l_path_name, '7

1082: psa_utils.debug_other_string(g_state_level,l_path_name, '5 XLA_BAL_CTRL_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1083: DELETE FROM XLA_BAL_PERIOD_STATS_GT;
1084: psa_utils.debug_other_string(g_state_level,l_path_name, '6 XLA_BAL_PERIOD_STATS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1085: DELETE FROM XLA_BAL_RECREATE_GT;
1086: psa_utils.debug_other_string(g_state_level,l_path_name, '7
1087: XLA_BAL_RECREATE_GT : Deleted Row count :'||SQL%ROWCOUNT);
1088: DELETE FROM XLA_BAL_ANACRI_LINES_GT;
1089: psa_utils.debug_other_string(g_state_level,l_path_name, '8
1090: XLA_BAL_ANACRI_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1089: psa_utils.debug_other_string(g_state_level,l_path_name, '8

1085: DELETE FROM XLA_BAL_RECREATE_GT;
1086: psa_utils.debug_other_string(g_state_level,l_path_name, '7
1087: XLA_BAL_RECREATE_GT : Deleted Row count :'||SQL%ROWCOUNT);
1088: DELETE FROM XLA_BAL_ANACRI_LINES_GT;
1089: psa_utils.debug_other_string(g_state_level,l_path_name, '8
1090: XLA_BAL_ANACRI_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1091: DELETE FROM XLA_BAL_ANACRI_CTRBS_GT;
1092: psa_utils.debug_other_string(g_state_level,l_path_name, '9
1093: XLA_BAL_ANACRI_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1092: psa_utils.debug_other_string(g_state_level,l_path_name, '9

1088: DELETE FROM XLA_BAL_ANACRI_LINES_GT;
1089: psa_utils.debug_other_string(g_state_level,l_path_name, '8
1090: XLA_BAL_ANACRI_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1091: DELETE FROM XLA_BAL_ANACRI_CTRBS_GT;
1092: psa_utils.debug_other_string(g_state_level,l_path_name, '9
1093: XLA_BAL_ANACRI_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1094: DELETE FROM XLA_BAL_SYNCHRONIZE_GT;
1095: psa_utils.debug_other_string(g_state_level,l_path_name, '10
1096: XLA_BAL_SYNCHRONIZE_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1095: psa_utils.debug_other_string(g_state_level,l_path_name, '10

1091: DELETE FROM XLA_BAL_ANACRI_CTRBS_GT;
1092: psa_utils.debug_other_string(g_state_level,l_path_name, '9
1093: XLA_BAL_ANACRI_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1094: DELETE FROM XLA_BAL_SYNCHRONIZE_GT;
1095: psa_utils.debug_other_string(g_state_level,l_path_name, '10
1096: XLA_BAL_SYNCHRONIZE_GT : Deleted Row count :'||SQL%ROWCOUNT);
1097: DELETE FROM XLA_BAL_STATUSES_GT;
1098: psa_utils.debug_other_string(g_state_level,l_path_name, '11
1099: XLA_BAL_STATUSES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1098: psa_utils.debug_other_string(g_state_level,l_path_name, '11

1094: DELETE FROM XLA_BAL_SYNCHRONIZE_GT;
1095: psa_utils.debug_other_string(g_state_level,l_path_name, '10
1096: XLA_BAL_SYNCHRONIZE_GT : Deleted Row count :'||SQL%ROWCOUNT);
1097: DELETE FROM XLA_BAL_STATUSES_GT;
1098: psa_utils.debug_other_string(g_state_level,l_path_name, '11
1099: XLA_BAL_STATUSES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1100: DELETE FROM XLA_BAL_CTRL_LINES_GT;
1101: psa_utils.debug_other_string(g_state_level,l_path_name, '12
1102: XLA_BAL_CTRL_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1101: psa_utils.debug_other_string(g_state_level,l_path_name, '12

1097: DELETE FROM XLA_BAL_STATUSES_GT;
1098: psa_utils.debug_other_string(g_state_level,l_path_name, '11
1099: XLA_BAL_STATUSES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1100: DELETE FROM XLA_BAL_CTRL_LINES_GT;
1101: psa_utils.debug_other_string(g_state_level,l_path_name, '12
1102: XLA_BAL_CTRL_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1103: DELETE FROM XLA_EVENTS_GT;
1104: psa_utils.debug_other_string(g_state_level,l_path_name, '13 XLA_EVENTS_GT
1105: : Deleted Row count :'||SQL%ROWCOUNT);

Line 1104: psa_utils.debug_other_string(g_state_level,l_path_name, '13 XLA_EVENTS_GT

1100: DELETE FROM XLA_BAL_CTRL_LINES_GT;
1101: psa_utils.debug_other_string(g_state_level,l_path_name, '12
1102: XLA_BAL_CTRL_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1103: DELETE FROM XLA_EVENTS_GT;
1104: psa_utils.debug_other_string(g_state_level,l_path_name, '13 XLA_EVENTS_GT
1105: : Deleted Row count :'||SQL%ROWCOUNT);
1106: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
1107: psa_utils.debug_other_string(g_state_level,l_path_name, '14
1108: XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1107: psa_utils.debug_other_string(g_state_level,l_path_name, '14

1103: DELETE FROM XLA_EVENTS_GT;
1104: psa_utils.debug_other_string(g_state_level,l_path_name, '13 XLA_EVENTS_GT
1105: : Deleted Row count :'||SQL%ROWCOUNT);
1106: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
1107: psa_utils.debug_other_string(g_state_level,l_path_name, '14
1108: XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1109: DELETE FROM XLA_EVT_CLASS_ORDERS_GT;
1110: psa_utils.debug_other_string(g_state_level,l_path_name, '15
1111: XLA_EVT_CLASS_ORDERS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1110: psa_utils.debug_other_string(g_state_level,l_path_name, '15

1106: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
1107: psa_utils.debug_other_string(g_state_level,l_path_name, '14
1108: XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1109: DELETE FROM XLA_EVT_CLASS_ORDERS_GT;
1110: psa_utils.debug_other_string(g_state_level,l_path_name, '15
1111: XLA_EVT_CLASS_ORDERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1112: DELETE FROM XLA_TAB_ERRORS_GT;
1113: psa_utils.debug_other_string(g_state_level,l_path_name, '16
1114: XLA_TAB_ERRORS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1113: psa_utils.debug_other_string(g_state_level,l_path_name, '16

1109: DELETE FROM XLA_EVT_CLASS_ORDERS_GT;
1110: psa_utils.debug_other_string(g_state_level,l_path_name, '15
1111: XLA_EVT_CLASS_ORDERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1112: DELETE FROM XLA_TAB_ERRORS_GT;
1113: psa_utils.debug_other_string(g_state_level,l_path_name, '16
1114: XLA_TAB_ERRORS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1115: DELETE FROM XLA_SEQ_JE_HEADERS_GT;
1116: psa_utils.debug_other_string(g_state_level,l_path_name, '17
1117: XLA_SEQ_JE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1116: psa_utils.debug_other_string(g_state_level,l_path_name, '17

1112: DELETE FROM XLA_TAB_ERRORS_GT;
1113: psa_utils.debug_other_string(g_state_level,l_path_name, '16
1114: XLA_TAB_ERRORS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1115: DELETE FROM XLA_SEQ_JE_HEADERS_GT;
1116: psa_utils.debug_other_string(g_state_level,l_path_name, '17
1117: XLA_SEQ_JE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1118: DELETE FROM XLA_TAB_NEW_CCIDS_GT;
1119: psa_utils.debug_other_string(g_state_level,l_path_name, '18
1120: XLA_TAB_NEW_CCIDS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1119: psa_utils.debug_other_string(g_state_level,l_path_name, '18

1115: DELETE FROM XLA_SEQ_JE_HEADERS_GT;
1116: psa_utils.debug_other_string(g_state_level,l_path_name, '17
1117: XLA_SEQ_JE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1118: DELETE FROM XLA_TAB_NEW_CCIDS_GT;
1119: psa_utils.debug_other_string(g_state_level,l_path_name, '18
1120: XLA_TAB_NEW_CCIDS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1121: DELETE FROM XLA_EXTRACT_OBJECTS_GT;
1122: psa_utils.debug_other_string(g_state_level,l_path_name, '19
1123: XLA_EXTRACT_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1122: psa_utils.debug_other_string(g_state_level,l_path_name, '19

1118: DELETE FROM XLA_TAB_NEW_CCIDS_GT;
1119: psa_utils.debug_other_string(g_state_level,l_path_name, '18
1120: XLA_TAB_NEW_CCIDS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1121: DELETE FROM XLA_EXTRACT_OBJECTS_GT;
1122: psa_utils.debug_other_string(g_state_level,l_path_name, '19
1123: XLA_EXTRACT_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1124: DELETE FROM XLA_REFERENCE_OBJECTS_GT;
1125: psa_utils.debug_other_string(g_state_level,l_path_name, '20
1126: XLA_REFERENCE_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1125: psa_utils.debug_other_string(g_state_level,l_path_name, '20

1121: DELETE FROM XLA_EXTRACT_OBJECTS_GT;
1122: psa_utils.debug_other_string(g_state_level,l_path_name, '19
1123: XLA_EXTRACT_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1124: DELETE FROM XLA_REFERENCE_OBJECTS_GT;
1125: psa_utils.debug_other_string(g_state_level,l_path_name, '20
1126: XLA_REFERENCE_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1127: DELETE FROM XLA_TRANSACTION_ACCTS_GT;
1128: psa_utils.debug_other_string(g_state_level,l_path_name, '21
1129: XLA_TRANSACTION_ACCTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1128: psa_utils.debug_other_string(g_state_level,l_path_name, '21

1124: DELETE FROM XLA_REFERENCE_OBJECTS_GT;
1125: psa_utils.debug_other_string(g_state_level,l_path_name, '20
1126: XLA_REFERENCE_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1127: DELETE FROM XLA_TRANSACTION_ACCTS_GT;
1128: psa_utils.debug_other_string(g_state_level,l_path_name, '21
1129: XLA_TRANSACTION_ACCTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1130: DELETE FROM XLA_UPG_LINE_CRITERIA_GT;
1131: psa_utils.debug_other_string(g_state_level,l_path_name, '22
1132: XLA_UPG_LINE_CRITERIA_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1131: psa_utils.debug_other_string(g_state_level,l_path_name, '22

1127: DELETE FROM XLA_TRANSACTION_ACCTS_GT;
1128: psa_utils.debug_other_string(g_state_level,l_path_name, '21
1129: XLA_TRANSACTION_ACCTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1130: DELETE FROM XLA_UPG_LINE_CRITERIA_GT;
1131: psa_utils.debug_other_string(g_state_level,l_path_name, '22
1132: XLA_UPG_LINE_CRITERIA_GT : Deleted Row count :'||SQL%ROWCOUNT);
1133: DELETE FROM XLA_TRIAL_BALANCES_GT;
1134: psa_utils.debug_other_string(g_state_level,l_path_name, '23
1135: XLA_TRIAL_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1134: psa_utils.debug_other_string(g_state_level,l_path_name, '23

1130: DELETE FROM XLA_UPG_LINE_CRITERIA_GT;
1131: psa_utils.debug_other_string(g_state_level,l_path_name, '22
1132: XLA_UPG_LINE_CRITERIA_GT : Deleted Row count :'||SQL%ROWCOUNT);
1133: DELETE FROM XLA_TRIAL_BALANCES_GT;
1134: psa_utils.debug_other_string(g_state_level,l_path_name, '23
1135: XLA_TRIAL_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1136: DELETE FROM XLA_ACCT_PROG_EVENTS_GT;
1137: psa_utils.debug_other_string(g_state_level,l_path_name, '24
1138: XLA_ACCT_PROG_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1137: psa_utils.debug_other_string(g_state_level,l_path_name, '24

1133: DELETE FROM XLA_TRIAL_BALANCES_GT;
1134: psa_utils.debug_other_string(g_state_level,l_path_name, '23
1135: XLA_TRIAL_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1136: DELETE FROM XLA_ACCT_PROG_EVENTS_GT;
1137: psa_utils.debug_other_string(g_state_level,l_path_name, '24
1138: XLA_ACCT_PROG_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1139: DELETE FROM XLA_ACCT_PROG_DOCS_GT;
1140: psa_utils.debug_other_string(g_state_level,l_path_name, '25
1141: XLA_ACCT_PROG_DOCS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1140: psa_utils.debug_other_string(g_state_level,l_path_name, '25

1136: DELETE FROM XLA_ACCT_PROG_EVENTS_GT;
1137: psa_utils.debug_other_string(g_state_level,l_path_name, '24
1138: XLA_ACCT_PROG_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1139: DELETE FROM XLA_ACCT_PROG_DOCS_GT;
1140: psa_utils.debug_other_string(g_state_level,l_path_name, '25
1141: XLA_ACCT_PROG_DOCS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1142: DELETE FROM XLA_MERGE_SEG_MAPS_GT;
1143: psa_utils.debug_other_string(g_state_level,l_path_name, '26
1144: XLA_MERGE_SEG_MAPS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1143: psa_utils.debug_other_string(g_state_level,l_path_name, '26

1139: DELETE FROM XLA_ACCT_PROG_DOCS_GT;
1140: psa_utils.debug_other_string(g_state_level,l_path_name, '25
1141: XLA_ACCT_PROG_DOCS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1142: DELETE FROM XLA_MERGE_SEG_MAPS_GT;
1143: psa_utils.debug_other_string(g_state_level,l_path_name, '26
1144: XLA_MERGE_SEG_MAPS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1145: DELETE FROM XLA_EVENTS_INT_GT;
1146: psa_utils.debug_other_string(g_state_level,l_path_name, '27
1147: XLA_EVENTS_INT_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1146: psa_utils.debug_other_string(g_state_level,l_path_name, '27

1142: DELETE FROM XLA_MERGE_SEG_MAPS_GT;
1143: psa_utils.debug_other_string(g_state_level,l_path_name, '26
1144: XLA_MERGE_SEG_MAPS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1145: DELETE FROM XLA_EVENTS_INT_GT;
1146: psa_utils.debug_other_string(g_state_level,l_path_name, '27
1147: XLA_EVENTS_INT_GT : Deleted Row count :'||SQL%ROWCOUNT);
1148: DELETE FROM XLA_REPORT_BALANCES_GT;
1149: psa_utils.debug_other_string(g_state_level,l_path_name, '28
1150: XLA_REPORT_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1149: psa_utils.debug_other_string(g_state_level,l_path_name, '28

1145: DELETE FROM XLA_EVENTS_INT_GT;
1146: psa_utils.debug_other_string(g_state_level,l_path_name, '27
1147: XLA_EVENTS_INT_GT : Deleted Row count :'||SQL%ROWCOUNT);
1148: DELETE FROM XLA_REPORT_BALANCES_GT;
1149: psa_utils.debug_other_string(g_state_level,l_path_name, '28
1150: XLA_REPORT_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1151: DELETE FROM XLA_TB_BALANCES_GT;
1152: psa_utils.debug_other_string(g_state_level,l_path_name, '29
1153: XLA_TB_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1152: psa_utils.debug_other_string(g_state_level,l_path_name, '29

1148: DELETE FROM XLA_REPORT_BALANCES_GT;
1149: psa_utils.debug_other_string(g_state_level,l_path_name, '28
1150: XLA_REPORT_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1151: DELETE FROM XLA_TB_BALANCES_GT;
1152: psa_utils.debug_other_string(g_state_level,l_path_name, '29
1153: XLA_TB_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1154: DELETE FROM XLA_BAL_AC_CTRBS_GT;
1155: psa_utils.debug_other_string(g_state_level,l_path_name, '30
1156: XLA_BAL_AC_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1155: psa_utils.debug_other_string(g_state_level,l_path_name, '30

1151: DELETE FROM XLA_TB_BALANCES_GT;
1152: psa_utils.debug_other_string(g_state_level,l_path_name, '29
1153: XLA_TB_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1154: DELETE FROM XLA_BAL_AC_CTRBS_GT;
1155: psa_utils.debug_other_string(g_state_level,l_path_name, '30
1156: XLA_BAL_AC_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1157: psa_utils.debug_other_string(g_state_level,l_path_name,'clean_xla_gt -');
1158: END psa_cleanup_gt;
1159:

Line 1157: psa_utils.debug_other_string(g_state_level,l_path_name,'clean_xla_gt -');

1153: XLA_TB_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1154: DELETE FROM XLA_BAL_AC_CTRBS_GT;
1155: psa_utils.debug_other_string(g_state_level,l_path_name, '30
1156: XLA_BAL_AC_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1157: psa_utils.debug_other_string(g_state_level,l_path_name,'clean_xla_gt -');
1158: END psa_cleanup_gt;
1159:
1160:
1161: ----------------------------------------------------- --------------------------------------------------