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.MSD_DEM_COLLECT_LEVEL_TYPES dependencies on MSD_DEM_COLLECT_LEVEL_TYPES

Line 1: PACKAGE BODY MSD_DEM_COLLECT_LEVEL_TYPES AS

1: PACKAGE BODY MSD_DEM_COLLECT_LEVEL_TYPES AS
2: /* $Header: msddemcltb.pls 120.3.12000000.2 2007/09/25 06:28:14 syenamar noship $ */
3:
4: LOC_TEMPORARY_TABLE VARCHAR2(240) := 'MSD_DEM_LOCATIONS_GTT ';
5: LOC_POPULATE_TEMP_TABLE_VIEW VARCHAR2(240) := 'MSD_DEM_LOCATIONS_GTT_V';

Line 294: msd_dem_common_utilities.log_debug ('Entering: msd_dem_collect_level_types.populate_new_items');

290: x_inv_item_id_tab INV_ITEM_ID_TAB;
291:
292: BEGIN
293:
294: msd_dem_common_utilities.log_debug ('Entering: msd_dem_collect_level_types.populate_new_items');
295:
296:
297: msd_dem_common_utilities.log_message (' Populate New Items ');
298: msd_dem_common_utilities.log_message (' --------------------');

Line 321: msd_dem_common_utilities.log_message ('Warning(1): msd_dem_collect_level_types.populate_new_items');

317: IF ( x_master_org IS NULL)
318: THEN
319: retcode := 1;
320: errbuf := 'Master organization not set.';
321: msd_dem_common_utilities.log_message ('Warning(1): msd_dem_collect_level_types.populate_new_items');
322: msd_dem_common_utilities.log_message (errbuf);
323: RETURN;
324: END IF;
325:

Line 332: msd_dem_common_utilities.log_message ('Warning(2): msd_dem_collect_level_types.populate_new_items');

328: IF (x_retcode = -1)
329: THEN
330: retcode := 1;
331: errbuf := 'Unable to get the query for populating new items into item staging table';
332: msd_dem_common_utilities.log_message ('Warning(2): msd_dem_collect_level_types.populate_new_items');
333: msd_dem_common_utilities.log_message (errbuf);
334: RETURN;
335: END IF;
336:

Line 359: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_collect_level_types.populate_new_items');

355: ELSE
356: msd_dem_common_utilities.log_message ('No new items found for processing');
357: END IF;
358:
359: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_collect_level_types.populate_new_items');
360:
361: retcode := 0;
362:
363: EXCEPTION

Line 367: msd_dem_common_utilities.log_message ('Exception: msd_dem_collect_level_types.populate_new_items');

363: EXCEPTION
364: WHEN OTHERS THEN
365: retcode := 1;
366: errbuf := substr(SQLERRM,1,150);
367: msd_dem_common_utilities.log_message ('Exception: msd_dem_collect_level_types.populate_new_items');
368: msd_dem_common_utilities.log_message (errbuf);
369: RETURN;
370:
371: END POPULATE_NEW_ITEMS;

Line 472: msd_dem_common_utilities.log_message('Warning: msd_dem_collect_level_types.collect_levels');

468: */
469: /* Failure of NPIs collection will be a 'Warning' and not 'Error' */
470: /* Bug# 5869314
471: if retcode = 1 then
472: msd_dem_common_utilities.log_message('Warning: msd_dem_collect_level_types.collect_levels');
473: msd_dem_common_utilities.log_message('Collect new items completed with warning(s).');
474: return;
475: end if;
476: end if;

Line 492: msd_dem_common_utilities.log_message ('Error: msd_dem_collect_level_types.collect_levels - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

488: msd_dem_common_utilities.log_debug ('End Call Custom Hook msd_dem_custom_hooks.item_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
489:
490: IF (retcode = -1)
491: THEN
492: msd_dem_common_utilities.log_message ('Error: msd_dem_collect_level_types.collect_levels - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
493: msd_dem_common_utilities.log_message ('Error in call to custom hook msd_dem_custom_hooks.item_hook ');
494: RETURN;
495: END IF;
496:

Line 509: msd_dem_common_utilities.log_message ('Warning: msd_dem_collect_level_types.collect_levels - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

505: msd_dem_common_utilities.log_debug ('End Analyze item staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
506:
507: IF (retcode = 1)
508: THEN
509: msd_dem_common_utilities.log_message ('Warning: msd_dem_collect_level_types.collect_levels - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
510: msd_dem_common_utilities.log_message ('Error while analyzing item staging table. ');
511: END IF;
512:
513: ELSIF (p_collect_level_type = 1) /* LOCATION */

Line 526: msd_dem_common_utilities.log_message ('Error: msd_dem_collect_level_types.collect_levels - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

522: msd_dem_common_utilities.log_debug ('End Call Custom Hook msd_dem_custom_hooks.location_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
523:
524: IF (retcode = -1)
525: THEN
526: msd_dem_common_utilities.log_message ('Error: msd_dem_collect_level_types.collect_levels - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
527: msd_dem_common_utilities.log_message ('Error in call to custom hook msd_dem_custom_hooks.location_hook ');
528: RETURN;
529: END IF;
530:

Line 543: msd_dem_common_utilities.log_message ('Warning: msd_dem_collect_level_types.collect_levels - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

539: msd_dem_common_utilities.log_debug ('End Analyze location staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
540:
541: IF (retcode = 1)
542: THEN
543: msd_dem_common_utilities.log_message ('Warning: msd_dem_collect_level_types.collect_levels - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
544: msd_dem_common_utilities.log_message ('Error while analyzing location staging table. ');
545: END IF;
546:
547: END IF;

Line 558: END MSD_DEM_COLLECT_LEVEL_TYPES;

554: retcode := -1;
555:
556: end collect_levels;
557:
558: END MSD_DEM_COLLECT_LEVEL_TYPES;