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.FUN_BAL_PKG dependencies on FUN_BAL_ERRORS_GT

Line 36: DELETE FROM fun_bal_errors_gt;

32: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.truncate_tables', 'begin');
33: END IF;
34:
35: DELETE FROM fun_bal_results_gt;
36: DELETE FROM fun_bal_errors_gt;
37: DELETE FROM fun_bal_le_bsv_map_gt;
38: DELETE FROM fun_bal_inter_int_gt;
39: DELETE FROM fun_bal_intra_int_gt;
40: /* Using delete rather than truncate as shown in the code below. The reason is that truncate (or any DDL operations)

Line 47: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_GT', dbms_sql.native);

43: In addition, the truncate operation might not be able to delete the rows that the calling program has not commited yet,
44: which could result in that we think the rows got deleted but they still exist.
45: cur_hdl := dbms_sql.open_cursor;
46: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_GT', dbms_sql.native);
47: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_GT', dbms_sql.native);
48: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);
49: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
50: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
51: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);

Line 461: SELECT * FROM fun_bal_errors_gt;

457: SELECT * FROM fun_bal_lines_gt;
458: INSERT INTO fun_bal_results_t
459: SELECT * FROM fun_bal_results_gt;
460: INSERT INTO fun_bal_errors_t
461: SELECT * FROM fun_bal_errors_gt;
462: */
463: COMMIT;
464: END ins_t_tables_final_auto;
465:

Line 601: SELECT * FROM fun_bal_errors_gt;

597: SELECT * FROM fun_bal_lines_gt;
598: CURSOR l_results_cursor IS
599: SELECT * FROM fun_bal_results_gt;
600: CURSOR l_errors_cursor IS
601: SELECT * FROM fun_bal_errors_gt;
602: BEGIN
603: l_return_val := FND_API.G_RET_STS_SUCCESS;
604:
605: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

Line 649: FROM fun_bal_errors_gt;

645: ins_t_tables_final_auto(l_headers_tab, l_lines_tab, l_results_tab, l_errors_tab,
646: l_headers_count, l_lines_count, l_results_count, l_errors_count);
647: ELSE
648: SELECT COUNT(*) INTO l_errors_count
649: FROM fun_bal_errors_gt;
650: END IF;
651:
652: IF l_errors_count > 0 THEN
653: l_return_val := FND_API.G_RET_STS_ERROR;

Line 704: INSERT INTO fun_bal_errors_gt(error_code, group_id, bal_seg_val)

700:
701: */
702:
703: -- Bug 3310453
704: INSERT INTO fun_bal_errors_gt(error_code, group_id, bal_seg_val)
705: SELECT 'FUN_BSV_INVALID', main.group_id, main.bal_seg_val
706: FROM (SELECT DISTINCT hdrs.group_id, lines.bal_seg_val, hdrs.gl_date, hdrs.ledger_id
707: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger
708: WHERE hdrs.group_id = lines.group_id

Line 722: FROM FUN_BAL_ERRORS_GT errors

718: UPDATE fun_bal_headers_gt headers
719: SET status = 'ERROR',
720: error_code = 'FUN_BSV_INVALID'
721: WHERE EXISTS (SELECT 'Invalid BSV Error'
722: FROM FUN_BAL_ERRORS_GT errors
723: WHERE headers.group_id = errors.group_id
724: AND error_code IN ('FUN_BSV_INVALID'))
725: AND headers.status = 'OK';
726:

Line 822: INSERT INTO fun_bal_errors_gt(error_code, group_id, clearing_bsv)

818: TRUNC(NVL(vals.start_date, hdrs.gl_date))
819: AND
820: TRUNC(NVL(vals.end_date, hdrs.gl_date))));
821:
822: INSERT INTO fun_bal_errors_gt(error_code, group_id, clearing_bsv)
823: SELECT 'FUN_INTRA_OVERRIDE_BSV_ERROR', hdrs.group_id, hdrs.clearing_bsv
824: FROM fun_bal_headers_gt hdrs
825: WHERE hdrs.error_code = 'FUN_INTRA_OVERRIDE_BSV_ERROR';
826:

Line 827: INSERT INTO fun_bal_errors_gt(error_code, group_id, bal_seg_val)

823: SELECT 'FUN_INTRA_OVERRIDE_BSV_ERROR', hdrs.group_id, hdrs.clearing_bsv
824: FROM fun_bal_headers_gt hdrs
825: WHERE hdrs.error_code = 'FUN_INTRA_OVERRIDE_BSV_ERROR';
826:
827: INSERT INTO fun_bal_errors_gt(error_code, group_id, bal_seg_val)
828: SELECT 'FUN_INTER_BSV_NOT_ASSIGNED', hdrs.group_id, le_bsv_map.bal_seg_val
829: FROM fun_bal_headers_gt hdrs, fun_bal_le_bsv_map_gt le_bsv_map
830: WHERE hdrs.group_id = le_bsv_map.group_id
831: AND hdrs.error_code = 'FUN_INTER_BSV_NOT_ASSIGNED'

Line 1448: -- Insert errors into FUN_BAL_ERRORS_GT

1444: ins_t_tables_inter_2_auto(l_inter_int_tab, l_inter_int_count);
1445: END IF;
1446:
1447:
1448: -- Insert errors into FUN_BAL_ERRORS_GT
1449: INSERT INTO FUN_BAL_ERRORS_GT(error_code, group_id, from_le_id, to_le_id, ccid,
1450: acct_type, ccid_concat_display,
1451: dr_bsv, cr_bsv)
1452: SELECT DISTINCT DECODE(inter_int.rec_acct, NULL, 'FUN_INTER_REC_NOT_ASSIGNED',

Line 1449: INSERT INTO FUN_BAL_ERRORS_GT(error_code, group_id, from_le_id, to_le_id, ccid,

1445: END IF;
1446:
1447:
1448: -- Insert errors into FUN_BAL_ERRORS_GT
1449: INSERT INTO FUN_BAL_ERRORS_GT(error_code, group_id, from_le_id, to_le_id, ccid,
1450: acct_type, ccid_concat_display,
1451: dr_bsv, cr_bsv)
1452: SELECT DISTINCT DECODE(inter_int.rec_acct, NULL, 'FUN_INTER_REC_NOT_ASSIGNED',
1453: -1, 'FUN_INTER_REC_NO_DEFAULT',

Line 1496: -- Insert errors into FUN_BAL_ERRORS_GT

1492: AND cc.template_id IS NULL
1493: AND (TRUNC(inter_int.gl_date) BETWEEN TRUNC(NVL(cc.start_date_active, inter_int.gl_date))
1494: AND TRUNC(NVL(cc.end_date_active, inter_int.gl_date))))));
1495:
1496: -- Insert errors into FUN_BAL_ERRORS_GT
1497: INSERT INTO FUN_BAL_ERRORS_GT(error_code, group_id, from_le_id, to_le_id, ccid,
1498: acct_type, ccid_concat_display,
1499: dr_bsv, cr_bsv)
1500: SELECT DISTINCT DECODE(inter_int.pay_acct, NULL, 'FUN_INTER_PAY_NOT_ASSIGNED',

Line 1497: INSERT INTO FUN_BAL_ERRORS_GT(error_code, group_id, from_le_id, to_le_id, ccid,

1493: AND (TRUNC(inter_int.gl_date) BETWEEN TRUNC(NVL(cc.start_date_active, inter_int.gl_date))
1494: AND TRUNC(NVL(cc.end_date_active, inter_int.gl_date))))));
1495:
1496: -- Insert errors into FUN_BAL_ERRORS_GT
1497: INSERT INTO FUN_BAL_ERRORS_GT(error_code, group_id, from_le_id, to_le_id, ccid,
1498: acct_type, ccid_concat_display,
1499: dr_bsv, cr_bsv)
1500: SELECT DISTINCT DECODE(inter_int.pay_acct, NULL, 'FUN_INTER_PAY_NOT_ASSIGNED',
1501: -1, 'FUN_INTER_PAY_NO_DEFAULT',

Line 1548: FROM FUN_BAL_ERRORS_GT errors

1544:
1545: UPDATE fun_bal_headers_gt headers
1546: SET status = 'ERROR'
1547: WHERE EXISTS (SELECT 'Errors for Rec and Pay Accts'
1548: FROM FUN_BAL_ERRORS_GT errors
1549: WHERE headers.group_id = errors.group_id
1550: AND error_code IN ('FUN_INTER_PAY_NOT_ASSIGNED',
1551: 'FUN_INTER_REC_NOT_ASSIGNED',
1552: 'FUN_INTER_PAY_NO_DEFAULT',

Line 1645: -- Insert errors into FUN_BAL_ERRORS_GT

1641:
1642: -- Enhancement 7520196 End
1643:
1644: /* Changes for Bug # 8212023 Start */
1645: -- Insert errors into FUN_BAL_ERRORS_GT
1646: INSERT INTO FUN_BAL_ERRORS_GT(error_code, group_id, from_le_id, to_le_id, ccid,
1647: acct_type, ccid_concat_display,
1648: dr_bsv, cr_bsv)
1649: SELECT DISTINCT DECODE(inter_int.rec_acct, NULL, 'FUN_INTER_REC_NOT_ASSIGNED',

Line 1646: INSERT INTO FUN_BAL_ERRORS_GT(error_code, group_id, from_le_id, to_le_id, ccid,

1642: -- Enhancement 7520196 End
1643:
1644: /* Changes for Bug # 8212023 Start */
1645: -- Insert errors into FUN_BAL_ERRORS_GT
1646: INSERT INTO FUN_BAL_ERRORS_GT(error_code, group_id, from_le_id, to_le_id, ccid,
1647: acct_type, ccid_concat_display,
1648: dr_bsv, cr_bsv)
1649: SELECT DISTINCT DECODE(inter_int.rec_acct, NULL, 'FUN_INTER_REC_NOT_ASSIGNED',
1650: -1, 'FUN_INTER_REC_NO_DEFAULT',

Line 1693: -- Insert errors into FUN_BAL_ERRORS_GT

1689: AND cc.template_id IS NULL
1690: AND (TRUNC(inter_int.gl_date) BETWEEN TRUNC(NVL(cc.start_date_active, inter_int.gl_date))
1691: AND TRUNC(NVL(cc.end_date_active, inter_int.gl_date))))));
1692:
1693: -- Insert errors into FUN_BAL_ERRORS_GT
1694: INSERT INTO FUN_BAL_ERRORS_GT(error_code, group_id, from_le_id, to_le_id, ccid,
1695: acct_type, ccid_concat_display,
1696: dr_bsv, cr_bsv)
1697: SELECT DISTINCT DECODE(inter_int.pay_acct, NULL, 'FUN_INTER_PAY_NOT_ASSIGNED',

Line 1694: INSERT INTO FUN_BAL_ERRORS_GT(error_code, group_id, from_le_id, to_le_id, ccid,

1690: AND (TRUNC(inter_int.gl_date) BETWEEN TRUNC(NVL(cc.start_date_active, inter_int.gl_date))
1691: AND TRUNC(NVL(cc.end_date_active, inter_int.gl_date))))));
1692:
1693: -- Insert errors into FUN_BAL_ERRORS_GT
1694: INSERT INTO FUN_BAL_ERRORS_GT(error_code, group_id, from_le_id, to_le_id, ccid,
1695: acct_type, ccid_concat_display,
1696: dr_bsv, cr_bsv)
1697: SELECT DISTINCT DECODE(inter_int.pay_acct, NULL, 'FUN_INTER_PAY_NOT_ASSIGNED',
1698: -1, 'FUN_INTER_PAY_NO_DEFAULT',

Line 1745: FROM FUN_BAL_ERRORS_GT errors

1741:
1742: UPDATE fun_bal_headers_gt headers
1743: SET status = 'ERROR'
1744: WHERE EXISTS (SELECT 'Errors for Rec and Pay Accts'
1745: FROM FUN_BAL_ERRORS_GT errors
1746: WHERE headers.group_id = errors.group_id
1747: AND error_code IN ('FUN_INTER_PAY_NOT_ASSIGNED',
1748: 'FUN_INTER_REC_NOT_ASSIGNED',
1749: 'FUN_INTER_PAY_NO_DEFAULT',

Line 2118: INSERT INTO FUN_BAL_ERRORS_GT(error_code, group_id, template_id, le_id, dr_bsv, cr_bsv)

2114: AND opts.je_category_name = 'Other'
2115: AND opts.status_flag = 'Y')
2116: WHERE le_bsv_map.template_id IS NULL;
2117:
2118: INSERT INTO FUN_BAL_ERRORS_GT(error_code, group_id, template_id, le_id, dr_bsv, cr_bsv)
2119: SELECT 'FUN_INTRA_RULE_NOT_ASSIGNED',
2120: le_bsv_map.group_id, le_bsv_map.template_id,
2121: DECODE(le_bsv_map.le_id, -99, NULL, le_bsv_map.le_id),
2122: le_bsv_map.driving_dr_bsv, le_bsv_map.driving_cr_bsv

Line 2191: INSERT INTO FUN_BAL_ERRORS_GT(error_code, group_id, template_id, le_id, dr_bsv, cr_bsv)

2187: WHERE le_bsv_map.clearing_bsv IS NOT NULL;
2188:
2189: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_LE_BSV_MAP_GT');
2190:
2191: INSERT INTO FUN_BAL_ERRORS_GT(error_code, group_id, template_id, le_id, dr_bsv, cr_bsv)
2192: SELECT 'FUN_INTRA_NO_CLEARING_BSV',
2193: le_bsv_map.group_id, le_bsv_map.template_id,
2194: DECODE(le_bsv_map.le_id, -99, NULL, le_bsv_map.le_id),
2195: le_bsv_map.driving_dr_bsv, le_bsv_map.driving_cr_bsv

Line 2206: INSERT INTO FUN_BAL_ERRORS_GT(error_code, group_id, template_id, le_id, clearing_bsv,

2202:
2203: -- Check if the clearing BSV is valid (Bug 3345457)
2204: -- Perform this validation only if the Ledger BSV mapping is set to
2205: -- 'Specific' ('I')
2206: INSERT INTO FUN_BAL_ERRORS_GT(error_code, group_id, template_id, le_id, clearing_bsv,
2207: dr_bsv, cr_bsv)
2208: SELECT 'FUN_INTRA_CLEAR_BSV_INVALID',
2209: le_bsv_map.group_id, le_bsv_map.template_id,
2210: DECODE(le_bsv_map.le_id, -99, NULL, le_bsv_map.le_id),

Line 2231: FROM FUN_BAL_ERRORS_GT errors

2227:
2228: UPDATE fun_bal_headers_gt headers
2229: SET STATUS = 'ERROR'
2230: WHERE EXISTS (SELECT 'Errors for no template or no clearing bsv or clearing bsv invalid'
2231: FROM FUN_BAL_ERRORS_GT errors
2232: WHERE headers.group_id = errors.group_id
2233: AND error_code IN ('FUN_INTRA_RULE_NOT_ASSIGNED',
2234: 'FUN_INTRA_NO_CLEARING_BSV',
2235: 'FUN_INTRA_CLEAR_BSV_INVALID'))

Line 2746: INSERT INTO fun_bal_errors_gt(error_code, group_id, template_id, le_id,

2742: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
2743: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_intra_bal.get_ccid_concat_disp.begin', 'begin');
2744: END IF;
2745:
2746: INSERT INTO fun_bal_errors_gt(error_code, group_id, template_id, le_id,
2747: dr_bsv, cr_bsv, acct_type, ccid_concat_display)
2748: SELECT DISTINCT DECODE(SIGN(NVL(results.ccid, 0)),
2749: -1, 'FUN_INTRA_CC_NOT_CREATED',
2750: 0, 'FUN_INTRA_CC_NOT_CREATED',

Line 2783: FROM FUN_BAL_ERRORS_GT errors

2779:
2780: UPDATE fun_bal_headers_gt headers
2781: SET STATUS = 'ERROR'
2782: WHERE EXISTS (SELECT 'Invalid CCID error'
2783: FROM FUN_BAL_ERRORS_GT errors
2784: WHERE headers.group_id = errors.group_id
2785: AND error_code IN ('FUN_INTRA_CC_NOT_VALID',
2786: 'FUN_INTRA_CC_NOT_CREATED',
2787: 'FUN_INTRA_CC_NOT_ACTIVE'));