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_SOP dependencies on MSD_DEM_COLLECT_RETURN_HISTORY

Line 3295: MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA

3291:
3292: /* Total Backlog */
3293: BEGIN
3294:
3295: MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA
3296: (l_errbuff1,
3297: l_retcode1,
3298: p_sr_instance_id,
3299: p_collection_group,

Line 3315: msd_dem_common_utilities.log_message ('An Error occured in API call MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA,while inserting Total Backlog Data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3311: IF l_retcode1 = -1
3312: THEN
3313: retcode := l_retcode1;
3314: errbuf := l_errbuff1;
3315: msd_dem_common_utilities.log_message ('An Error occured in API call MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA,while inserting Total Backlog Data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3316: RETURN;
3317: END IF;
3318:
3319: EXCEPTION

Line 3331: MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA

3327:
3328: /* Past Due Backlog*/
3329: BEGIN
3330:
3331: MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA
3332: (l_errbuff2,
3333: l_retcode2,
3334: p_sr_instance_id,
3335: p_collection_group,

Line 3351: msd_dem_common_utilities.log_message ('An Error occured in API call MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA,while merging Past Due Backlog Data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3347: IF l_retcode2 = -1
3348: THEN
3349: retcode := l_retcode2;
3350: errbuf := l_errbuff2;
3351: msd_dem_common_utilities.log_message ('An Error occured in API call MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA,while merging Past Due Backlog Data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3352: RETURN;
3353: END IF;
3354:
3355:

Line 3440: MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA

3436:
3437: -- On-Hand Inventory
3438:
3439: BEGIN
3440: MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA
3441: (l_errbuff1,
3442: l_retcode1,
3443: p_sr_instance_id,
3444: p_collection_group,

Line 3461: msd_dem_common_utilities.log_message ('An Error occured in API call MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA,while inserting On Hand Inventory Data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3457: IF l_retcode1 = -1
3458: THEN
3459: retcode := l_retcode1;
3460: errbuf := l_errbuff1;
3461: msd_dem_common_utilities.log_message ('An Error occured in API call MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA,while inserting On Hand Inventory Data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3462: RETURN;
3463: END IF;
3464: EXCEPTION
3465: WHEN OTHERS THEN

Line 3477: MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA

3473:
3474: -- Actual Production
3475: BEGIN
3476:
3477: MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA
3478: (l_errbuff2,
3479: l_retcode2,
3480: p_sr_instance_id,
3481: p_collection_group,

Line 3497: msd_dem_common_utilities.log_message ('An Error occured in API call MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA,while merging Actual Production Data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

3493: IF l_retcode2 = -1
3494: THEN
3495: retcode := l_retcode2;
3496: errbuf := l_errbuff2;
3497: msd_dem_common_utilities.log_message ('An Error occured in API call MSD_DEM_COLLECT_RETURN_HISTORY.COLLECT_RETURN_HISTORY_DATA,while merging Actual Production Data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3498: RETURN;
3499: END IF;
3500:
3501: