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 516: UNDO_GL_BC_PACKETS (

512: Put_Debug_Msg(l_full_path, 'Roll backed to Save point IGCFCK due to Funds Check failure');
513: Put_Debug_Msg(l_full_path, 'Processed Results Status - l_pro_ret_status ' || l_pro_ret_status);
514: Put_Debug_Msg(l_full_path, 'SBC Return Status: ' || l_sbc_ret_status || ' CBC Return Status: ' || l_cbc_ret_status );
515: END IF;
516: UNDO_GL_BC_PACKETS (
517: p_ledger_array => g_ledger_tbl,
518: p_event_array => g_event_tbl,
519: p_return_status => l_undo_ret_status);
520: IF (g_debug_mode = 'Y') THEN

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

517: p_ledger_array => g_ledger_tbl,
518: p_event_array => g_event_tbl,
519: p_return_status => l_undo_ret_status);
520: IF (g_debug_mode = 'Y') THEN
521: Put_Debug_Msg(l_full_path, 'GL_BC_PACKETS Rollbacked Status: ' ||l_undo_ret_status);
522: END IF;
523:
524: Restore_events_gt;
525:

Line 556: UNDO_GL_BC_PACKETS (

552: IF (g_debug_mode = 'Y') THEN
553: Put_Debug_Msg(l_full_path, 'Exception Occured ' || SQLERRM);
554: END IF;
555:
556: UNDO_GL_BC_PACKETS (
557: p_ledger_array => g_ledger_tbl,
558: p_event_array => g_event_tbl,
559: p_return_status => l_undo_ret_status);
560: IF (g_debug_mode = 'Y') THEN

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

557: p_ledger_array => g_ledger_tbl,
558: p_event_array => g_event_tbl,
559: p_return_status => l_undo_ret_status);
560: IF (g_debug_mode = 'Y') THEN
561: Put_Debug_Msg(l_full_path, 'Exception Occured - Rollbacked GL_BC_PACKETS Status: ' || l_undo_ret_status);
562: END IF;
563: RETURN (FALSE);
564:
565: /*R12 SLA Uptake Bug No 6341012 - End*/

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

848: Put_Debug_Msg (l_full_path, 'Processing Interface lines for Primary Ledger (Standard Budget)' );
849: END IF;
850: END IF;
851:
852: /*Extend the Vector and add the Ledger ID. This is used for reversing the GL_BC_PACKETS in case the funds check fails*/
853: g_ledger_tbl.EXTEND;
854: g_ledger_ind := g_ledger_ind+1;
855: g_ledger_tbl(g_ledger_ind) := l_ledger_id;
856:

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

942: IF (g_debug_mode = 'Y') THEN
943: Put_Debug_Msg (l_full_path, 'Completed Create Event' );
944: END IF;
945:
946: /*Extend the Vector and add the Event ID. This is used for reversing the GL_BC_PACKETS in case the funds check fails*/
947: g_event_tbl.EXTEND;
948: g_event_ind := g_event_ind + 1;
949: g_event_tbl(g_event_ind) := l_event_id;
950:

Line 1084: FROM GL_BC_PACKETS

1080:
1081: SELECT min(severity_rank) INTO l_max_sev_rank
1082: FROM igc_cc_result_code_ranks
1083: WHERE funds_checker_code IN(SELECT distinct(result_code)
1084: FROM GL_BC_PACKETS
1085: WHERE event_id IN (SELECT event_id
1086: FROM
1087: psa_bc_xla_events_gt));
1088: x_sev_rank := l_max_sev_rank;

Line 1091: PROCEDURE UNDO_GL_BC_PACKETS(

1087: psa_bc_xla_events_gt));
1088: x_sev_rank := l_max_sev_rank;
1089: END Get_Status;
1090:
1091: PROCEDURE UNDO_GL_BC_PACKETS(
1092: p_ledger_array IN PSA_FUNDS_CHECKER_PKG.num_rec,
1093: p_event_array IN PSA_FUNDS_CHECKER_PKG.num_rec,
1094: p_return_status OUT NOCOPY VARCHAR2
1095:

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

1102: l_full_path VARCHAR2(255);
1103:
1104: BEGIN
1105:
1106: l_full_path := g_path || 'UNDO_GL_BC_PACKETS';
1107: IF (g_debug_mode = 'Y') THEN
1108: Put_Debug_Msg (l_full_path, 'Switching to Autonomous Transaction Mode' );
1109: Put_Debug_Msg (l_full_path, 'Undoing GL_BC_PACKETS by calling sync_xla_errors' );
1110: END IF;

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

1105:
1106: l_full_path := g_path || 'UNDO_GL_BC_PACKETS';
1107: IF (g_debug_mode = 'Y') THEN
1108: Put_Debug_Msg (l_full_path, 'Switching to Autonomous Transaction Mode' );
1109: Put_Debug_Msg (l_full_path, 'Undoing GL_BC_PACKETS by calling sync_xla_errors' );
1110: END IF;
1111:
1112: PSA_FUNDS_CHECKER_PKG.sync_xla_errors(
1113: p_failed_ldgr_array => p_ledger_array,

Line 1134: END UNDO_GL_BC_PACKETS;

1130: Put_Debug_Msg (l_full_path, 'SQL Code: ' || l_err_code );
1131: Put_Debug_Msg (l_full_path, 'SQL Error Message: ' || l_err_msg);
1132: END IF;
1133:
1134: END UNDO_GL_BC_PACKETS;
1135:
1136: PROCEDURE PROCESS_RESULTS(
1137: x_ret_status OUT NOCOPY VARCHAR2,
1138: x_batch_result_code OUT NOCOPY VARCHAR2

Line 1179: FROM gl_bc_packets pac

1175: pac.status_code,
1176: pac.funding_budget_version_id,
1177: pac.period_name,
1178: pac.encumbrance_type_id
1179: FROM gl_bc_packets pac
1180: WHERE int.event_id = pac.event_id
1181: AND int.cc_acct_line_id = pac.source_distribution_id_num_1
1182: -- Commented as it is causing issues with result updation Refer Bug 6628196
1183: -- 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))