APPS.EDW_GL_ACCT_M_T dependencies on EDW_OWB_COLLECTION_UTIL

Line 48: -- as the edw_log.put_names was never called in EDW_OWB_COLLECTION_UTIL, the debug_line won't work.

44: IS
45: BEGIN
46: if( g_debug) then
47: -- calling put_line directly,
48: -- as the edw_log.put_names was never called in EDW_OWB_COLLECTION_UTIL, the debug_line won't work.
49: edw_log.put_line(p_log);
50: end if;
51: END VBHDEBUG ;
52:

Line 1386: l_element_id:=edw_owb_collection_util.GET_OBJECT_ID(g_dimension_name);

1382: g_global_temp_table:=g_dimension_name||'_temp';
1383: l_seq_name:='EDW_GL_ACCT'|| p_dimension_no||'_S';
1384: l_exe_status :=true;
1385: g_completion_status:=0;
1386: l_element_id:=edw_owb_collection_util.GET_OBJECT_ID(g_dimension_name);
1387: edw_owb_collection_util.setup_conc_program_log(g_dimension_name);
1388:
1389:
1390: -- FND MESSAGE LOOKUP AREA

Line 1387: edw_owb_collection_util.setup_conc_program_log(g_dimension_name);

1383: l_seq_name:='EDW_GL_ACCT'|| p_dimension_no||'_S';
1384: l_exe_status :=true;
1385: g_completion_status:=0;
1386: l_element_id:=edw_owb_collection_util.GET_OBJECT_ID(g_dimension_name);
1387: edw_owb_collection_util.setup_conc_program_log(g_dimension_name);
1388:
1389:
1390: -- FND MESSAGE LOOKUP AREA
1391: FND_MESSAGE.SET_NAME('BIS', 'EDW_DIMENSION_LEVEL_TYPE');

Line 1448: edw_owb_collection_util.INSERT_INTO_LOAD_PROGRESS(

1444: clean_up_dimension_table;
1445: logTime('cleaning up dimension star table', l_log_timestamp);
1446:
1447: --update edw_vbh_temp table to include type info
1448: edw_owb_collection_util.INSERT_INTO_LOAD_PROGRESS(
1449: l_progress_seq_id,
1450: g_dimension_name,
1451: l_element_id,
1452: 'Updating Account Type Information',

Line 1465: edw_owb_collection_util.INSERT_INTO_LOAD_PROGRESS(

1461: setTimer(l_log_timestamp);
1462: update_class;
1463: logTime('updating class', l_log_timestamp);
1464:
1465: edw_owb_collection_util.INSERT_INTO_LOAD_PROGRESS(
1466: l_progress_seq_id,
1467: g_dimension_name,
1468: l_element_id,
1469: null,

Line 1478: edw_owb_collection_util.INSERT_INTO_LOAD_PROGRESS(

1474: 100,
1475: 'U',
1476: l_element_id);
1477:
1478: edw_owb_collection_util.INSERT_INTO_LOAD_PROGRESS(
1479: l_progress_seq_id,
1480: g_dimension_name,
1481: l_element_id,
1482: 'Insert Lowest Level into Dimension Table',

Line 1516: edw_owb_collection_util.INSERT_INTO_LOAD_PROGRESS(

1512:
1513: -- add commit here to reduce the rollback segment space requirement a bit!
1514: COMMIT;
1515:
1516: edw_owb_collection_util.INSERT_INTO_LOAD_PROGRESS(
1517: l_progress_seq_id,
1518: g_dimension_name,
1519: l_element_id,
1520: null,

Line 1557: edw_owb_collection_util.INSERT_INTO_LOAD_PROGRESS(

1553: -- not for each row, this will gain some performance back.
1554: l_CursorID := PARSE_UPDATE(l_hierachy_no);
1555:
1556:
1557: edw_owb_collection_util.INSERT_INTO_LOAD_PROGRESS(
1558: l_progress_seq_id,
1559: g_dimension_name,
1560: l_element_id,
1561: 'Build Hierarchy '|| l_hierachy_no,

Line 1588: edw_owb_collection_util.INSERT_INTO_LOAD_PROGRESS(

1584: edw_log.put_line('Warning : More than 4 roots.');
1585: end if;
1586: end if;
1587:
1588: edw_owb_collection_util.INSERT_INTO_LOAD_PROGRESS(
1589: l_progress_seq_id,
1590: g_dimension_name,
1591: l_element_id,
1592: null,

Line 1624: l_status:=edw_owb_collection_util.write_to_collection_log(

1620: setTimer(l_log_timestamp);
1621: clean_up_global_temp_table;
1622: logTime('cleaning up global temp table', l_log_timestamp);
1623:
1624: l_status:=edw_owb_collection_util.write_to_collection_log(
1625: g_dimension_name,
1626: l_element_id,
1627: 'DIMENSION',
1628: g_conc_program_id,

Line 1652: l_status:=edw_owb_collection_util.write_to_collection_log(

1648: setTimer(l_log_timestamp);
1649: clean_up_global_temp_table;
1650: logTime('cleaning up global temp table', l_log_timestamp);
1651:
1652: l_status:=edw_owb_collection_util.write_to_collection_log(
1653: g_dimension_name,
1654: l_element_id,
1655: 'DIMENSION',
1656: g_conc_program_id,

Line 1668: l_status:=edw_owb_collection_util.write_to_collection_log(

1664: elsif (g_completion_status=2) then
1665: l_program_status:=
1666: fnd_concurrent.set_completion_status('ERROR',NULL);
1667: edw_log.put_line('Error.');
1668: l_status:=edw_owb_collection_util.write_to_collection_log(
1669: g_dimension_name,
1670: l_element_id,
1671: 'DIMENSION',
1672: g_conc_program_id,

Line 1702: l_status:= edw_owb_collection_util.write_to_collection_log(

1698: Retcode:=sqlcode;
1699: l_exe_status:=false;
1700: g_completion_status:=2;
1701:
1702: l_status:= edw_owb_collection_util.write_to_collection_log(
1703: g_dimension_name,
1704: l_element_id,
1705: 'DIMENSION',
1706: g_conc_program_id,