DBA Data[Home] [Help]

APPS.GL_FUSION_TRANSFER_PKG dependencies on GL_MESSAGE

Line 493: gl_message.write_log('GLFUXFR000');

489: ----------------------------------------------------------------------------
490: -- If no data was found, then stop here
491: ----------------------------------------------------------------------------
492: IF (g_interface_row_count = 0) THEN
493: gl_message.write_log('GLFUXFR000');
494:
495: gl_fusion_transfer_pkg.insert_tracking_data('NO_DATA');
496:
497: IF (g_transfer_mode = C_INCREMENTAL) THEN

Line 611: gl_message.write_log('GLFUPRG001', 2,

607: AND system_id = g_system_id;
608:
609: l_row_count := SQL%ROWCOUNT;
610:
611: gl_message.write_log('GLFUPRG001', 2,
612: 'ROW_COUNT', l_row_count,
613: 'TABLE', 'gl_xfr_interface');
614:
615: success_exit(l_log_module);

Line 780: gl_message.write_log('GLFUXFR009', 2,

776: WHERE application_id = 101
777: AND ledger_id = g_from_ledger_id
778: AND effective_period_num = g_first_eff_per_num;
779:
780: gl_message.write_log('GLFUXFR009', 2,
781: 'OLD_PERIOD_NAME', g_original_first_period,
782: 'NEW_PERIOD_NAME', g_from_period);
783: END IF;
784:

Line 793: l_name := gl_message.get_message(

789: ---
790: --- Get the batch and journal name
791: ---
792: IF (g_transfer_mode = C_FULL) THEN
793: l_name := gl_message.get_message(
794: msg_name => 'GLFUXFR013',
795: show_num => 'N',
796: t1 => 'LEDGER',
797: v1 => substrb(g_from_ledger_shortname, 1, 7),

Line 802: l_name := gl_message.get_message(

798: t2 => 'PERIOD',
799: v2 => substrb(g_from_period, 1, 6));
800: l_name := substrb(l_name, 1, 100);
801: ELSE
802: l_name := gl_message.get_message(
803: msg_name => 'GLFUXFR014',
804: show_num => 'N',
805: t1 => 'LEDGER',
806: v1 => substrb(g_from_ledger_shortname, 1, 7));

Line 1332: gl_message.write_log('GLFUXFR001', 2,

1328: END IF;
1329:
1330: g_interface_row_count := SQL%ROWCOUNT;
1331:
1332: gl_message.write_log('GLFUXFR001', 2,
1333: 'ROW_COUNT', g_interface_row_count,
1334: 'TABLE', g_interface_table_name);
1335:
1336: success_exit(l_log_module);

Line 1382: gl_message.write_log('GLFUXFR001', 2,

1378: EXECUTE IMMEDIATE l_sqlbuf USING g_coa_mapping_id, g_request_id;
1379:
1380: l_row_count := SQL%ROWCOUNT;
1381:
1382: gl_message.write_log('GLFUXFR001', 2,
1383: 'ROW_COUNT', l_row_count,
1384: 'TABLE', 'gl_accounts_map_int_gt');
1385:
1386: IF (l_row_count = 0) THEN

Line 1403: gl_message.write_log('GLFUXFR002', 1,

1399: create_ccid => TRUE,
1400: debug => g_debug_mode);
1401: EXCEPTION
1402: WHEN GL_ACCOUNTS_MAP_GRP.GL_INVALID_MAPPING_RULES THEN
1403: gl_message.write_log('GLFUXFR002', 1,
1404: 'COA_MAPPING_NAME', g_coa_mapping_name);
1405: gl_fusion_transfer_pkg.insert_tracking_data('COA_MAP_INVALID_RULES');
1406: failure_exit(l_log_module);
1407: RAISE warning_exception;

Line 1409: gl_message.write_log('GLFUXFR003', 1,

1405: gl_fusion_transfer_pkg.insert_tracking_data('COA_MAP_INVALID_RULES');
1406: failure_exit(l_log_module);
1407: RAISE warning_exception;
1408: WHEN GL_ACCOUNTS_MAP_GRP.GL_DISABLED_MAPPING THEN
1409: gl_message.write_log('GLFUXFR003', 1,
1410: 'COA_MAPPING_NAME', g_coa_mapping_name);
1411: gl_fusion_transfer_pkg.insert_tracking_data('COA_MAP_OUT_OF_DATE');
1412: failure_exit(l_log_module);
1413: RAISE warning_exception;

Line 1415: gl_message.write_log('GLFUXFR004', 1,

1411: gl_fusion_transfer_pkg.insert_tracking_data('COA_MAP_OUT_OF_DATE');
1412: failure_exit(l_log_module);
1413: RAISE warning_exception;
1414: WHEN OTHERS THEN
1415: gl_message.write_log('GLFUXFR004', 1,
1416: 'COA_MAPPING_NAME', g_coa_mapping_name);
1417: gl_fusion_transfer_pkg.insert_tracking_data('COA_MAP_UNEXPECTED_ERROR');
1418: failure_exit(l_log_module);
1419: RAISE warning_exception;

Line 1437: gl_message.write_log('GLFUXFR005', 1,

1433: (SELECT 'has errors'
1434: FROM gl_accts_map_int_gt
1435: WHERE error_code IS NOT NULL);
1436:
1437: gl_message.write_log('GLFUXFR005', 1,
1438: 'COA_MAPPING_NAME', g_coa_mapping_name);
1439: gl_fusion_transfer_pkg.insert_tracking_data('COA_MAP_UNMAPPED');
1440: success_exit(l_log_module);
1441: RAISE warning_exception;

Line 1499: gl_message.write_log('GLFUXFR001', 2,

1495: END IF;
1496:
1497: l_row_count := SQL%ROWCOUNT;
1498:
1499: gl_message.write_log('GLFUXFR001', 2,
1500: 'ROW_COUNT', l_row_count,
1501: 'TABLE', 'gl_xfr_ccid_mappings');
1502:
1503:

Line 1544: gl_message.write_log('GLFUXFR006', 2,

1540: EXECUTE IMMEDIATE l_sqlbuf USING g_coa_mapping_id, g_request_id;
1541:
1542: l_row_count := SQL%ROWCOUNT;
1543:
1544: gl_message.write_log('GLFUXFR006', 2,
1545: 'ROW_COUNT', l_row_count,
1546: 'TABLE', g_interface_table_name);
1547:
1548: success_exit(l_log_module);

Line 1817: gl_message.write_log('GLFUXFR008', 2,

1813: AND per.period_type = lgr.accounted_period_type
1814: AND per.period_name = g_from_period;
1815: EXCEPTION
1816: WHEN NO_DATA_FOUND THEN
1817: gl_message.write_log('GLFUXFR008', 2,
1818: 'GENERAL_LEDGER_PERIOD_NAME', g_from_period,
1819: 'LEDGER_NAME', g_from_ledger_name);
1820: gl_fusion_transfer_pkg.insert_tracking_data('BAD_PERIOD');
1821: failure_exit(l_log_module);

Line 2018: gl_message.write_log('GLFUXFR007', 0);

2014: ---
2015: gl_fusion_transfer_pkg.get_system_id;
2016:
2017: IF (g_system_id IS NULL) THEN
2018: gl_message.write_log('GLFUXFR007', 0);
2019: failure_exit(l_log_module);
2020: RAISE fatal_exception;
2021: END IF;
2022:

Line 2039: gl_message.write_log('GLFUXFR010', 0);

2035: g_je_source_key := NULL;
2036: END;
2037:
2038: IF (g_je_source_key IS NULL) THEN
2039: gl_message.write_log('GLFUXFR010', 0);
2040: gl_fusion_transfer_pkg.insert_tracking_data('SYSTEM_MISSING');
2041: failure_exit(l_log_module);
2042: RAISE warning_exception;
2043: END IF;

Line 2064: gl_message.write_log('GLFUXFR011', 1,

2060: g_bsv_assignment_type := NULL;
2061: END;
2062:
2063: IF (g_bsv_assignment_type IS NULL) THEN
2064: gl_message.write_log('GLFUXFR011', 1,
2065: 'LEDGER_NAME', g_to_ledger_name);
2066: failure_exit(l_log_module);
2067: gl_fusion_transfer_pkg.insert_tracking_data('LEDGER_REJECTED');
2068: RAISE warning_exception;

Line 2097: gl_message.write_log('GLFUXFR015', 1,

2093: WHEN OTHERS THEN
2094: l_profile_name := NULL;
2095: END;
2096:
2097: gl_message.write_log('GLFUXFR015', 1,
2098: 'PROFILE_NAME', l_profile_name);
2099:
2100: failure_exit(l_log_module);
2101: RAISE fatal_exception;

Line 2236: gl_message.write_log('GLFUXFR001', 2,

2232: g_system_map_id, g_to_ledger_id;
2233:
2234: l_row_count := SQL%ROWCOUNT;
2235:
2236: gl_message.write_log('GLFUXFR001', 2,
2237: 'ROW_COUNT', l_row_count,
2238: 'TABLE', 'gl_xfr_rejected_bsvs_gt');
2239:
2240: ---

Line 2244: gl_message.write_log('GLFUXFR012', 0);

2240: ---
2241: --- If we found bsvs that wouldn't be accepted, record this.
2242: ---
2243: IF (l_row_count > 0) THEN
2244: gl_message.write_log('GLFUXFR012', 0);
2245: failure_exit(l_log_module);
2246: gl_fusion_transfer_pkg.insert_tracking_data('BSVS_REJECTED');
2247: RAISE warning_exception;
2248: END IF;