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_FUNDS_CHECKER_PKG dependencies on PSA_BC_XLA_PVT

Line 9652: and application_id = psa_bc_xla_pvt.g_application_id;

9648: where exists (select 1
9649: from xla_ae_headers h
9650: where h.event_id IN (SELECT event_id from psa_bc_xla_events_gt)
9651: and h.ae_header_id = d.ae_header_id)
9652: and application_id = psa_bc_xla_pvt.g_application_id;
9653:
9654:
9655:
9656: DEBUG_XLA_INSERT ( l_xla_events, l_xla_validation_lines, l_xla_ae_lines, l_xla_ae_headers , l_xla_distribution_links);

Line 9700: psa_bc_xla_pvt.psa_xla_error

9696: ' Related Distribution Identifier Num 1: '||bflow_rec.bflow_dist_id_num_1;
9697: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
9698: Fnd_Message.Set_Token('PARAM_NAME',l_message);
9699: -- Fnd_Msg_Pub.ADD;
9700: psa_bc_xla_pvt.psa_xla_error
9701: (
9702: p_message_code => 'PSA_BC_XLA_ERROR',
9703: p_event_id => bflow_rec.event_id
9704: );

Line 9717: psa_bc_xla_pvt.psa_xla_error

9713: WHERE l.event_id = e.event_id)) LOOP
9714: l_message := 'Event '||events_rec.event_id||' is not processed.';
9715: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
9716: Fnd_Message.Set_Token('PARAM_NAME',l_message);
9717: psa_bc_xla_pvt.psa_xla_error
9718: (
9719: p_message_code => 'PSA_BC_XLA_ERROR',
9720: p_event_id => events_rec.event_id
9721: );

Line 9734: psa_bc_xla_pvt.psa_xla_error

9730: WHERE l.event_id = e.event_id)) LOOP
9731: l_message := 'Event '||events_rec.event_id||' is not processed.';
9732: Fnd_message.set_name('PSA','PSA_GL_BC_PACKETS_EMPTY');
9733: Fnd_Message.Set_Token('PARAM_NAME',l_message);
9734: psa_bc_xla_pvt.psa_xla_error
9735: (
9736: p_message_code => 'PSA_GL_BC_PACKETS_EMPTY',
9737: p_event_id => events_rec.event_id
9738: );

Line 10068: DECODE (DECODE (psa_bc_xla_pvt.g_bc_mode,

10064: 0, 'S',
10065: 1, 'A'
10066: ),
10067: COUNT (DECODE (SUBSTR (bp.result_code, 1, 1), 'F', 1)), 'F',
10068: DECODE (DECODE (psa_bc_xla_pvt.g_bc_mode,
10069: 'C', 'Y',
10070: 'M', 'N',
10071: 'P', 'Y',
10072: 'N'

Line 10122: ' BCTRL -> MODE = '||PSA_BC_XLA_PVT.G_BC_MODE);

10118: -- ====== FND LOG ======
10119: psa_utils.debug_other_string(g_state_level,l_full_path,
10120: ' BCTRL -> P_LEDGERID = '||p_ledgerid);
10121: psa_utils.debug_other_string(g_state_level,l_full_path,
10122: ' BCTRL -> MODE = '||PSA_BC_XLA_PVT.G_BC_MODE);
10123: psa_utils.debug_other_string(g_state_level,l_full_path,
10124: ' BCTRL -> OVERRIDE = '||PSA_BC_XLA_PVT.G_OVERRIDE_FLAG);
10125: psa_utils.debug_other_string(g_state_level,l_full_path,
10126: ' BCTRL -> USER_ID = '||PSA_BC_XLA_PVT.G_USER_ID);

Line 10124: ' BCTRL -> OVERRIDE = '||PSA_BC_XLA_PVT.G_OVERRIDE_FLAG);

10120: ' BCTRL -> P_LEDGERID = '||p_ledgerid);
10121: psa_utils.debug_other_string(g_state_level,l_full_path,
10122: ' BCTRL -> MODE = '||PSA_BC_XLA_PVT.G_BC_MODE);
10123: psa_utils.debug_other_string(g_state_level,l_full_path,
10124: ' BCTRL -> OVERRIDE = '||PSA_BC_XLA_PVT.G_OVERRIDE_FLAG);
10125: psa_utils.debug_other_string(g_state_level,l_full_path,
10126: ' BCTRL -> USER_ID = '||PSA_BC_XLA_PVT.G_USER_ID);
10127: psa_utils.debug_other_string(g_state_level,l_full_path,
10128: ' BCTRL -> RESP_ID = '||PSA_BC_XLA_PVT.G_USER_RESP_ID);

Line 10126: ' BCTRL -> USER_ID = '||PSA_BC_XLA_PVT.G_USER_ID);

10122: ' BCTRL -> MODE = '||PSA_BC_XLA_PVT.G_BC_MODE);
10123: psa_utils.debug_other_string(g_state_level,l_full_path,
10124: ' BCTRL -> OVERRIDE = '||PSA_BC_XLA_PVT.G_OVERRIDE_FLAG);
10125: psa_utils.debug_other_string(g_state_level,l_full_path,
10126: ' BCTRL -> USER_ID = '||PSA_BC_XLA_PVT.G_USER_ID);
10127: psa_utils.debug_other_string(g_state_level,l_full_path,
10128: ' BCTRL -> RESP_ID = '||PSA_BC_XLA_PVT.G_USER_RESP_ID);
10129: -- ====== FND LOG ======
10130: check_for_xla_errors ('BFLOW', l_xla_return_code);

Line 10128: ' BCTRL -> RESP_ID = '||PSA_BC_XLA_PVT.G_USER_RESP_ID);

10124: ' BCTRL -> OVERRIDE = '||PSA_BC_XLA_PVT.G_OVERRIDE_FLAG);
10125: psa_utils.debug_other_string(g_state_level,l_full_path,
10126: ' BCTRL -> USER_ID = '||PSA_BC_XLA_PVT.G_USER_ID);
10127: psa_utils.debug_other_string(g_state_level,l_full_path,
10128: ' BCTRL -> RESP_ID = '||PSA_BC_XLA_PVT.G_USER_RESP_ID);
10129: -- ====== FND LOG ======
10130: check_for_xla_errors ('BFLOW', l_xla_return_code);
10131: IF (l_xla_return_code = 'Y') THEN
10132: -- ====== FND LOG ======

Line 10150: p_mode => PSA_BC_XLA_PVT.G_BC_MODE,

10146: -- ====== FND LOG ======
10147:
10148: if not glxfin (p_ledgerid => p_ledgerid,
10149: p_packetid => 0,
10150: p_mode => PSA_BC_XLA_PVT.G_BC_MODE,
10151: p_override => PSA_BC_XLA_PVT.G_OVERRIDE_FLAG,
10152: p_conc_flag => 'N',
10153: p_user_id => PSA_BC_XLA_PVT.G_USER_ID,
10154: p_user_resp_id => PSA_BC_XLA_PVT.G_USER_RESP_ID,

Line 10151: p_override => PSA_BC_XLA_PVT.G_OVERRIDE_FLAG,

10147:
10148: if not glxfin (p_ledgerid => p_ledgerid,
10149: p_packetid => 0,
10150: p_mode => PSA_BC_XLA_PVT.G_BC_MODE,
10151: p_override => PSA_BC_XLA_PVT.G_OVERRIDE_FLAG,
10152: p_conc_flag => 'N',
10153: p_user_id => PSA_BC_XLA_PVT.G_USER_ID,
10154: p_user_resp_id => PSA_BC_XLA_PVT.G_USER_RESP_ID,
10155: p_calling_prog_flag => 'S') then

Line 10153: p_user_id => PSA_BC_XLA_PVT.G_USER_ID,

10149: p_packetid => 0,
10150: p_mode => PSA_BC_XLA_PVT.G_BC_MODE,
10151: p_override => PSA_BC_XLA_PVT.G_OVERRIDE_FLAG,
10152: p_conc_flag => 'N',
10153: p_user_id => PSA_BC_XLA_PVT.G_USER_ID,
10154: p_user_resp_id => PSA_BC_XLA_PVT.G_USER_RESP_ID,
10155: p_calling_prog_flag => 'S') then
10156:
10157: -- ====== FND LOG ======

Line 10154: p_user_resp_id => PSA_BC_XLA_PVT.G_USER_RESP_ID,

10150: p_mode => PSA_BC_XLA_PVT.G_BC_MODE,
10151: p_override => PSA_BC_XLA_PVT.G_OVERRIDE_FLAG,
10152: p_conc_flag => 'N',
10153: p_user_id => PSA_BC_XLA_PVT.G_USER_ID,
10154: p_user_resp_id => PSA_BC_XLA_PVT.G_USER_RESP_ID,
10155: p_calling_prog_flag => 'S') then
10156:
10157: -- ====== FND LOG ======
10158: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL -> glxfin failed ');

Line 10253: open get_je_source_name(PSA_BC_XLA_PVT.G_APPLICATION_ID);

10249: -- ====== FND LOG ======
10250: psa_utils.debug_other_string(g_state_level,l_full_path, ' BCTRL -> Get Je_Source_name ');
10251: -- ====== FND LOG ======
10252:
10253: open get_je_source_name(PSA_BC_XLA_PVT.G_APPLICATION_ID);
10254: fetch get_je_source_name into l_je_source_name;
10255: if get_je_source_name%notfound then
10256: raise invalid_je_source_name;
10257: end if;

Line 10448: -- decode(psa_bc_xla_pvt.g_bc_mode, 'C', 'C', 'P'), Bug 6452856.

10444: ps.period_year,
10445: ps.period_num,
10446: ps.quarter_num,
10447: xv.entered_currency_code,
10448: -- decode(psa_bc_xla_pvt.g_bc_mode, 'C', 'C', 'P'), Bug 6452856.
10449: decode(psa_bc_xla_pvt.g_bc_mode, 'C', 'C','M', 'C', 'P'),
10450: sysdate,
10451: g_user_id,
10452: xv.budget_version_id, -- BUDGET_VERSION_ID

Line 10449: decode(psa_bc_xla_pvt.g_bc_mode, 'C', 'C','M', 'C', 'P'),

10445: ps.period_num,
10446: ps.quarter_num,
10447: xv.entered_currency_code,
10448: -- decode(psa_bc_xla_pvt.g_bc_mode, 'C', 'C', 'P'), Bug 6452856.
10449: decode(psa_bc_xla_pvt.g_bc_mode, 'C', 'C','M', 'C', 'P'),
10450: sysdate,
10451: g_user_id,
10452: xv.budget_version_id, -- BUDGET_VERSION_ID
10453: xv.encumbrance_type_id,

Line 10524: psa_bc_xla_pvt.g_application_id,

10520: xv.source_distribution_id_num_4,
10521: xv.source_distribution_id_num_5,
10522: l_session_id,
10523: l_serial_id,
10524: psa_bc_xla_pvt.g_application_id,
10525: xv.entity_id,
10526: NULL -- GROUP_ID
10527: BULK COLLECT INTO l_bc_pkts
10528: FROM xla_psa_bc_lines_v xv,

Line 10557: psa_utils.debug_other_string(g_state_level,l_full_path, ' BCTRL -> Application Id: '||psa_bc_xla_pvt.g_application_id);

10553: CLOSE get_ledger_category;
10554:
10555: -- ====== FND LOG ======
10556: psa_utils.debug_other_string(g_state_level,l_full_path, ' BCTRL -> Ledger Category: '||l_ledger_category);
10557: psa_utils.debug_other_string(g_state_level,l_full_path, ' BCTRL -> Application Id: '||psa_bc_xla_pvt.g_application_id);
10558: -- ====== FND LOG ======
10559:
10560: IF (l_ledger_category = 'PRIMARY') OR (psa_bc_xla_pvt.g_application_id = 602) THEN
10561: -- ==================== FND LOG ===========================

Line 10560: IF (l_ledger_category = 'PRIMARY') OR (psa_bc_xla_pvt.g_application_id = 602) THEN

10556: psa_utils.debug_other_string(g_state_level,l_full_path, ' BCTRL -> Ledger Category: '||l_ledger_category);
10557: psa_utils.debug_other_string(g_state_level,l_full_path, ' BCTRL -> Application Id: '||psa_bc_xla_pvt.g_application_id);
10558: -- ====== FND LOG ======
10559:
10560: IF (l_ledger_category = 'PRIMARY') OR (psa_bc_xla_pvt.g_application_id = 602) THEN
10561: -- ==================== FND LOG ===========================
10562: psa_utils.debug_other_string(g_state_level,l_full_path, ' l_ledger_category = PRIMARY OR (psa_bc_xla_pvt.g_application_id = 602 --> raise gl_bc_packets_empty');
10563: -- ==================== FND LOG ===========================
10564:

Line 10562: psa_utils.debug_other_string(g_state_level,l_full_path, ' l_ledger_category = PRIMARY OR (psa_bc_xla_pvt.g_application_id = 602 --> raise gl_bc_packets_empty');

10558: -- ====== FND LOG ======
10559:
10560: IF (l_ledger_category = 'PRIMARY') OR (psa_bc_xla_pvt.g_application_id = 602) THEN
10561: -- ==================== FND LOG ===========================
10562: psa_utils.debug_other_string(g_state_level,l_full_path, ' l_ledger_category = PRIMARY OR (psa_bc_xla_pvt.g_application_id = 602 --> raise gl_bc_packets_empty');
10563: -- ==================== FND LOG ===========================
10564:
10565: raise gl_bc_packets_empty;
10566: ELSE

Line 10646: PSA_BC_XLA_PVT.G_BC_MODE ,

10642: -- ====== FND LOG ======
10643:
10644: IF NOT glxfck( p_ledgerid ,
10645: l_packets(i) ,
10646: PSA_BC_XLA_PVT.G_BC_MODE ,
10647: PSA_BC_XLA_PVT.G_OVERRIDE_FLAG ,
10648: 'N' ,
10649: PSA_BC_XLA_PVT.G_USER_ID ,
10650: PSA_BC_XLA_PVT.G_USER_RESP_ID ,

Line 10647: PSA_BC_XLA_PVT.G_OVERRIDE_FLAG ,

10643:
10644: IF NOT glxfck( p_ledgerid ,
10645: l_packets(i) ,
10646: PSA_BC_XLA_PVT.G_BC_MODE ,
10647: PSA_BC_XLA_PVT.G_OVERRIDE_FLAG ,
10648: 'N' ,
10649: PSA_BC_XLA_PVT.G_USER_ID ,
10650: PSA_BC_XLA_PVT.G_USER_RESP_ID ,
10651: 'S' ,

Line 10649: PSA_BC_XLA_PVT.G_USER_ID ,

10645: l_packets(i) ,
10646: PSA_BC_XLA_PVT.G_BC_MODE ,
10647: PSA_BC_XLA_PVT.G_OVERRIDE_FLAG ,
10648: 'N' ,
10649: PSA_BC_XLA_PVT.G_USER_ID ,
10650: PSA_BC_XLA_PVT.G_USER_RESP_ID ,
10651: 'S' ,
10652: l_ret_code ) THEN
10653:

Line 10650: PSA_BC_XLA_PVT.G_USER_RESP_ID ,

10646: PSA_BC_XLA_PVT.G_BC_MODE ,
10647: PSA_BC_XLA_PVT.G_OVERRIDE_FLAG ,
10648: 'N' ,
10649: PSA_BC_XLA_PVT.G_USER_ID ,
10650: PSA_BC_XLA_PVT.G_USER_RESP_ID ,
10651: 'S' ,
10652: l_ret_code ) THEN
10653:
10654: -- ====== FND LOG ======

Line 10672: IF (PSA_BC_XLA_PVT.G_BC_MODE = 'P') AND (l_ret_code <> 'T') THEN

10668: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Update funds_status_code '||
10669: 'of xla_ae_headers_gt ');
10670: -- ====== FND LOG ======
10671:
10672: IF (PSA_BC_XLA_PVT.G_BC_MODE = 'P') AND (l_ret_code <> 'T') THEN
10673: FOR y IN get_status_per_header(l_packets(i))
10674: LOOP
10675: -- ====== FND LOG ======
10676: psa_utils.debug_other_string(g_state_level,l_full_path, ' BCTRL -> GET_STATUS_PER_HEADER DETAILS ');

Line 10810: PSA_BC_XLA_PVT.G_PACKET_ID := l_packets(1);

10806: -- ====== FND LOG ======
10807:
10808: -- Update global variable for packet_id to the first packet_id
10809:
10810: PSA_BC_XLA_PVT.G_PACKET_ID := l_packets(1);
10811:
10812: -- ====== FND LOG ======
10813: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Updated '||
10814: ' PSA_BC_XLA_PVT.G_PACKET_ID to '||PSA_BC_XLA_PVT.G_PACKET_ID);

Line 10814: ' PSA_BC_XLA_PVT.G_PACKET_ID to '||PSA_BC_XLA_PVT.G_PACKET_ID);

10810: PSA_BC_XLA_PVT.G_PACKET_ID := l_packets(1);
10811:
10812: -- ====== FND LOG ======
10813: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Updated '||
10814: ' PSA_BC_XLA_PVT.G_PACKET_ID to '||PSA_BC_XLA_PVT.G_PACKET_ID);
10815: -- ====== FND LOG ======
10816:
10817: -- ====== FND LOG ======
10818: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> l_t_status_cnt = '||l_t_status_cnt);

Line 10877: SET status_code = decode(PSA_BC_XLA_PVT.G_BC_MODE, 'C', 'F',

10873: CLOSE c_chk_funds_hier;
10874: -- update the statuses of gl_bc_packets
10875: -- related rows to 'F' Failed or 'R' Rejected.
10876: UPDATE gl_bc_packets
10877: SET status_code = decode(PSA_BC_XLA_PVT.G_BC_MODE, 'C', 'F',
10878: 'M', 'F',
10879: 'R', 'R',
10880: 'P', 'R')
10881: ,result_code = 'F77'

Line 10901: SET funds_status_code = decode(PSA_BC_XLA_PVT.G_BC_MODE, 'C', 'F',

10897: END IF;
10898: END LOOP;
10899:
10900: UPDATE xla_ae_headers_gt
10901: SET funds_status_code = decode(PSA_BC_XLA_PVT.G_BC_MODE, 'C', 'F',
10902: 'M', 'F',
10903: 'R', 'F',
10904: 'P', 'F')
10905: WHERE ae_header_id IN (SELECT ae_header_id

Line 11120: AND application_id = PSA_BC_XLA_PVT.g_application_id

11116: FROM gl_bc_packets
11117: WHERE event_id IN (SELECT event_id
11118: FROM psa_bc_xla_events_gt
11119: )
11120: AND application_id = PSA_BC_XLA_PVT.g_application_id
11121: AND status_code = 'A';
11122:
11123: dummy VARCHAR2(100);
11124: l_success_evt_exist VARCHAR2(1);

Line 11145: SET status_code = decode(PSA_BC_XLA_PVT.G_BC_MODE, 'C', 'F',

11141: -- ====== FND LOG ======
11142:
11143: FORALL i IN 1..p_failed_ldgr_array.COUNT
11144: UPDATE gl_bc_packets
11145: SET status_code = decode(PSA_BC_XLA_PVT.G_BC_MODE, 'C', 'F',
11146: 'M', 'F',
11147: 'R', 'R',
11148: 'P', 'R')
11149: ,result_code = 'F81'

Line 11151: AND application_id = PSA_BC_XLA_PVT.g_application_id

11147: 'R', 'R',
11148: 'P', 'R')
11149: ,result_code = 'F81'
11150: WHERE event_id = p_failed_evnt_array(i)
11151: AND application_id = PSA_BC_XLA_PVT.g_application_id
11152: AND ledger_id = p_failed_ldgr_array(i)
11153: AND status_code NOT IN ('F', 'R');
11154:
11155: l_f81_cnt := SQL%ROWCOUNT;

Line 11165: SET status_code = decode(PSA_BC_XLA_PVT.G_BC_MODE, 'C', 'F',

11161:
11162:
11163: FORALL j IN 1..p_failed_evnt_array.COUNT
11164: UPDATE gl_bc_packets
11165: SET status_code = decode(PSA_BC_XLA_PVT.G_BC_MODE, 'C', 'F',
11166: 'M', 'F',
11167: 'R', 'R',
11168: 'P', 'R')
11169: ,result_code = 'F82'

Line 11171: AND application_id = PSA_BC_XLA_PVT.g_application_id

11167: 'R', 'R',
11168: 'P', 'R')
11169: ,result_code = 'F82'
11170: WHERE event_id = p_failed_evnt_array(j)
11171: AND application_id = PSA_BC_XLA_PVT.g_application_id
11172: AND status_code NOT IN ('F', 'R');
11173:
11174: l_f82_cnt := SQL%ROWCOUNT;
11175:

Line 11221: AND application_id = PSA_BC_XLA_PVT.g_application_id

11217: FROM gl_bc_packets bc
11218: WHERE event_id IN ( SELECT event_id
11219: FROM psa_bc_xla_events_gt
11220: )
11221: AND application_id = PSA_BC_XLA_PVT.g_application_id
11222: AND result_code IN ('F81', 'F82')
11223: ) ;
11224:
11225: -- ====== FND LOG ======