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.IGC_CBC_FUNDS_CHECKER dependencies on GL_BC_PACKETS

Line 131: PROCEDURE UNDO_GL_BC_PACKETS(

127: x_ret_status OUT NOCOPY VARCHAR2,
128: x_batch_result_code OUT NOCOPY VARCHAR2
129: );
130:
131: PROCEDURE UNDO_GL_BC_PACKETS(
132: p_ledger_array IN PSA_FUNDS_CHECKER_PKG.num_rec,
133: p_event_array IN PSA_FUNDS_CHECKER_PKG.num_rec,
134: p_return_status OUT NOCOPY VARCHAR2
135: );

Line 506: UNDO_GL_BC_PACKETS (

502: Put_Debug_Msg(l_full_path, 'Roll backed to Save point IGCFCK due to Funds Check failure');
503: Put_Debug_Msg(l_full_path, 'Processed Results');
504: Put_Debug_Msg(l_full_path, 'SBC Return Status: ' || l_sbc_ret_status || ' CBC Return Status: ' || l_cbc_ret_status );
505: END IF;
506: UNDO_GL_BC_PACKETS (
507: p_ledger_array => g_ledger_tbl,
508: p_event_array => g_event_tbl,
509: p_return_status => l_undo_ret_status);
510: IF (g_debug_mode = 'Y') THEN

Line 511: Put_Debug_Msg(l_full_path, 'GL_BC_PACKETS Rollbacked Status: ' ||l_undo_ret_status);

507: p_ledger_array => g_ledger_tbl,
508: p_event_array => g_event_tbl,
509: p_return_status => l_undo_ret_status);
510: IF (g_debug_mode = 'Y') THEN
511: Put_Debug_Msg(l_full_path, 'GL_BC_PACKETS Rollbacked Status: ' ||l_undo_ret_status);
512: END IF;
513:
514: Restore_events_gt;
515:

Line 546: UNDO_GL_BC_PACKETS (

542: IF (g_debug_mode = 'Y') THEN
543: Put_Debug_Msg(l_full_path, 'Exception Occured ' || SQLERRM);
544: END IF;
545:
546: UNDO_GL_BC_PACKETS (
547: p_ledger_array => g_ledger_tbl,
548: p_event_array => g_event_tbl,
549: p_return_status => l_undo_ret_status);
550: IF (g_debug_mode = 'Y') THEN

Line 551: Put_Debug_Msg(l_full_path, 'Exception Occured - Rollbacked GL_BC_PACKETS Status: ' || l_undo_ret_status);

547: p_ledger_array => g_ledger_tbl,
548: p_event_array => g_event_tbl,
549: p_return_status => l_undo_ret_status);
550: IF (g_debug_mode = 'Y') THEN
551: Put_Debug_Msg(l_full_path, 'Exception Occured - Rollbacked GL_BC_PACKETS Status: ' || l_undo_ret_status);
552: END IF;
553: RETURN (FALSE);
554:
555: /*R12 SLA Uptake Bug No 6341012 - End*/

Line 842: /Extend the Vector and add the Ledger ID. This is used for reversing the GL_BC_PACKETS in case the funds check fails/

838: Put_Debug_Msg (l_full_path, 'Processing Interface lines for Primary Ledger (Standard Budget)' );
839: END IF;
840: END IF;
841:
842: /*Extend the Vector and add the Ledger ID. This is used for reversing the GL_BC_PACKETS in case the funds check fails*/
843: g_ledger_tbl.EXTEND;
844: g_ledger_ind := g_ledger_ind+1;
845: g_ledger_tbl(g_ledger_ind) := l_ledger_id;
846:

Line 936: /Extend the Vector and add the Event ID. This is used for reversing the GL_BC_PACKETS in case the funds check fails/

932: IF (g_debug_mode = 'Y') THEN
933: Put_Debug_Msg (l_full_path, 'Completed Create Event' );
934: END IF;
935:
936: /*Extend the Vector and add the Event ID. This is used for reversing the GL_BC_PACKETS in case the funds check fails*/
937: g_event_tbl.EXTEND;
938: g_event_ind := g_event_ind + 1;
939: g_event_tbl(g_event_ind) := l_event_id;
940:

Line 1074: FROM GL_BC_PACKETS

1070:
1071: SELECT min(severity_rank) INTO l_max_sev_rank
1072: FROM igc_cc_result_code_ranks
1073: WHERE funds_checker_code IN(SELECT distinct(result_code)
1074: FROM GL_BC_PACKETS
1075: WHERE event_id IN (SELECT event_id
1076: FROM
1077: psa_bc_xla_events_gt));
1078: x_sev_rank := l_max_sev_rank;

Line 1081: PROCEDURE UNDO_GL_BC_PACKETS(

1077: psa_bc_xla_events_gt));
1078: x_sev_rank := l_max_sev_rank;
1079: END Get_Status;
1080:
1081: PROCEDURE UNDO_GL_BC_PACKETS(
1082: p_ledger_array IN PSA_FUNDS_CHECKER_PKG.num_rec,
1083: p_event_array IN PSA_FUNDS_CHECKER_PKG.num_rec,
1084: p_return_status OUT NOCOPY VARCHAR2
1085:

Line 1096: l_full_path := g_path || 'UNDO_GL_BC_PACKETS';

1092: l_full_path VARCHAR2(255);
1093:
1094: BEGIN
1095:
1096: l_full_path := g_path || 'UNDO_GL_BC_PACKETS';
1097: IF (g_debug_mode = 'Y') THEN
1098: Put_Debug_Msg (l_full_path, 'Switching to Autonomous Transaction Mode' );
1099: Put_Debug_Msg (l_full_path, 'Undoing GL_BC_PACKETS by calling sync_xla_errors' );
1100: END IF;

Line 1099: Put_Debug_Msg (l_full_path, 'Undoing GL_BC_PACKETS by calling sync_xla_errors' );

1095:
1096: l_full_path := g_path || 'UNDO_GL_BC_PACKETS';
1097: IF (g_debug_mode = 'Y') THEN
1098: Put_Debug_Msg (l_full_path, 'Switching to Autonomous Transaction Mode' );
1099: Put_Debug_Msg (l_full_path, 'Undoing GL_BC_PACKETS by calling sync_xla_errors' );
1100: END IF;
1101:
1102: PSA_FUNDS_CHECKER_PKG.sync_xla_errors(
1103: p_failed_ldgr_array => p_ledger_array,

Line 1124: END UNDO_GL_BC_PACKETS;

1120: Put_Debug_Msg (l_full_path, 'SQL Code: ' || l_err_code );
1121: Put_Debug_Msg (l_full_path, 'SQL Error Message: ' || l_err_msg);
1122: END IF;
1123:
1124: END UNDO_GL_BC_PACKETS;
1125:
1126: PROCEDURE PROCESS_RESULTS(
1127: x_ret_status OUT NOCOPY VARCHAR2,
1128: x_batch_result_code OUT NOCOPY VARCHAR2

Line 1166: FROM gl_bc_packets pac

1162: pac.status_code,
1163: pac.funding_budget_version_id,
1164: pac.period_name,
1165: pac.encumbrance_type_id
1166: FROM gl_bc_packets pac
1167: WHERE int.event_id = pac.event_id
1168: AND int.cc_acct_line_id = pac.source_distribution_id_num_1
1169: -- Commented as it is causing issues with result updation Refer Bug 6628196
1170: -- AND (nvl(pac.accounted_dr, 0) = nvl(INT.cc_func_dr_amt, -1) OR nvl(pac.accounted_cr, 0) = nvl(INT.cc_func_cr_amt, -1))