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.MSC_E1APS_DEMCL dependencies on MSD_DEM_PRICE_LISTS

Line 161: /* Step 1: Deleting all rows from MSD_DEM_PRICE_LISTS */

157:
158: /* Launching Price List Collections*/
159: IF p_price_list = 1 THEN
160: BEGIN
161: /* Step 1: Deleting all rows from MSD_DEM_PRICE_LISTS */
162: DELETE
163: FROM MSD_DEM_PRICE_LISTS;
164:
165: COMMIT;

Line 163: FROM MSD_DEM_PRICE_LISTS;

159: IF p_price_list = 1 THEN
160: BEGIN
161: /* Step 1: Deleting all rows from MSD_DEM_PRICE_LISTS */
162: DELETE
163: FROM MSD_DEM_PRICE_LISTS;
164:
165: COMMIT;
166: EXCEPTION
167: WHEN OTHERS THEN

Line 168: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSD_DEM_PRICE_LISTS');

164:
165: COMMIT;
166: EXCEPTION
167: WHEN OTHERS THEN
168: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSD_DEM_PRICE_LISTS');
169: RETCODE := MSC_UTIL.G_ERROR;
170: RETURN;
171: END;
172: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_PRICE_LISTS');

Line 172: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_PRICE_LISTS');

168: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSD_DEM_PRICE_LISTS');
169: RETCODE := MSC_UTIL.G_ERROR;
170: RETURN;
171: END;
172: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_PRICE_LISTS');
173:
174: /* Step 1: Inserting rows into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIST */
175: BEGIN
176: INSERT

Line 174: /* Step 1: Inserting rows into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIST */

170: RETURN;
171: END;
172: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_PRICE_LISTS');
173:
174: /* Step 1: Inserting rows into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIST */
175: BEGIN
176: INSERT
177: INTO MSD_DEM_PRICE_LISTS
178: ( PRICE_LIST_NAME ,

Line 177: INTO MSD_DEM_PRICE_LISTS

173:
174: /* Step 1: Inserting rows into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIST */
175: BEGIN
176: INSERT
177: INTO MSD_DEM_PRICE_LISTS
178: ( PRICE_LIST_NAME ,
179: LAST_UPDATE_LOGIN,
180: LAST_UPDATE_DATE ,
181: LAST_UPDATED_BY ,

Line 196: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Inserted into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIS');

192:
193: COMMIT;
194: EXCEPTION
195: WHEN OTHERS THEN
196: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Inserted into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIS');
197: RETCODE := MSC_UTIL.G_ERROR;
198: RETURN;
199: END;
200: SELECT COUNT(*)

Line 202: FROM MSD_DEM_PRICE_LISTS;

198: RETURN;
199: END;
200: SELECT COUNT(*)
201: INTO total_rows
202: FROM MSD_DEM_PRICE_LISTS;
203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Inserted ' || total_rows || 'rows into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIS');
204:
205:
206: p_start_date := fnd_profile.value('MSC_E1APS_DEM_START_DATE_IN_MONTHS');

Line 203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Inserted ' || total_rows || 'rows into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIS');

199: END;
200: SELECT COUNT(*)
201: INTO total_rows
202: FROM MSD_DEM_PRICE_LISTS;
203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Inserted ' || total_rows || 'rows into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIS');
204:
205:
206: p_start_date := fnd_profile.value('MSC_E1APS_DEM_START_DATE_IN_MONTHS');
207: p_end_date := fnd_profile.value('MSC_E1APS_DEM_END_DATE_IN_MONTHS');