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_CL_COPY_DP_FORECAST dependencies on MSC_UTIL

Line 39: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL stmt in GET_SOURCE_INSTANCE_ID is : ' ||lv_src_sql_stmt);

35: FROM msc_apps_instances' || DB_LINK || '
36: WHERE m2a_dblink IS NOT NULL';
37:
38: OPEN c1 FOR lv_src_sql_stmt; -- open the REF cursor
39: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL stmt in GET_SOURCE_INSTANCE_ID is : ' ||lv_src_sql_stmt);
40: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The value of lv_found_source is : ' ||lv_found_source);
41: LOOP
42: FETCH c1 INTO
43: m2a_dblink,lv_instance_id;

Line 40: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The value of lv_found_source is : ' ||lv_found_source);

36: WHERE m2a_dblink IS NOT NULL';
37:
38: OPEN c1 FOR lv_src_sql_stmt; -- open the REF cursor
39: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL stmt in GET_SOURCE_INSTANCE_ID is : ' ||lv_src_sql_stmt);
40: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The value of lv_found_source is : ' ||lv_found_source);
41: LOOP
42: FETCH c1 INTO
43: m2a_dblink,lv_instance_id;
44:

Line 55: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The formed SQL to get the source instance: ' ||

51: 'SELECT 1 FROM MRP_AP_APPS_INSTANCES_ALL@' || m2a_dblink ||
52: ' WHERE ' ||
53: 'RP_SOURCE_IND = '|| to_char(SOURCE_ID_INDICATOR);
54:
55: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The formed SQL to get the source instance: ' ||
56: lv_sql_stmt);
57: EXECUTE IMMEDIATE lv_sql_stmt INTO lv_found_source;
58:
59: IF (lv_found_source = 1 ) THEN

Line 69: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, sqlerrm);

65:
66:
67: EXCEPTION
68: WHEN OTHERS THEN
69: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, sqlerrm);
70: END;
71: END LOOP;
72:
73:

Line 76: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'For self instance. Value of lv_found_source is :'||lv_found_source);

72:
73:
74: Begin
75: --- for self instance
76: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'For self instance. Value of lv_found_source is :'||lv_found_source);
77: IF (v_rp_instance_id =v_src_instance_id) THEN
78:
79: lv_src_cent_stmt := 'SELECT instance_id
80: FROM msc_apps_instances' || DB_LINK || '

Line 85: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL to get the source instance in case of centralised inst : ' ||lv_src_cent_stmt);

81: WHERE m2a_dblink IS NULL
82: AND a2m_dblink is NULL
83: AND INSTANCE_TYPE <> 3';
84:
85: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL to get the source instance in case of centralised inst : ' ||lv_src_cent_stmt);
86: EXECUTE IMMEDIATE lv_src_cent_stmt INTO lv_instance_id;
87: SOURCE_INSTANCE_ID := lv_instance_id;
88: lv_found_source := 1;
89:

Line 93: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, sqlerrm);

89:
90: END IF;
91: EXCEPTION
92: WHEN OTHERS THEN
93: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, sqlerrm);
94: END;
95:
96: IF (lv_found_source = 0) THEN
97: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'No Common Source found for APS and RP servers');

Line 97: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'No Common Source found for APS and RP servers');

93: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, sqlerrm);
94: END;
95:
96: IF (lv_found_source = 0) THEN
97: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'No Common Source found for APS and RP servers');
98: SOURCE_INSTANCE_ID := -23453;
99: ELSE
100: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Source Instance ID : ' ||to_char (SOURCE_INSTANCE_ID));
101: END IF;

Line 100: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Source Instance ID : ' ||to_char (SOURCE_INSTANCE_ID));

96: IF (lv_found_source = 0) THEN
97: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'No Common Source found for APS and RP servers');
98: SOURCE_INSTANCE_ID := -23453;
99: ELSE
100: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Source Instance ID : ' ||to_char (SOURCE_INSTANCE_ID));
101: END IF;
102:
103: END GET_SOURCE_INSTANCE_ID;
104:

Line 117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'APS Instance Id: '|| pINSTANCE_ID); -- Instance ID of the APS server

113: v_aps_dblink1 varchar2(128);
114:
115:
116: BEGIN
117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'APS Instance Id: '|| pINSTANCE_ID); -- Instance ID of the APS server
118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Source Instance Id: '|| pSource_instance_id); -- Instance ID of the RP instance
119: -- Initialize Global Variables
120: v_src_instance_id := pSource_instance_id;
121: v_rp_instance_id := pINSTANCE_ID;

Line 118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Source Instance Id: '|| pSource_instance_id); -- Instance ID of the RP instance

114:
115:
116: BEGIN
117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'APS Instance Id: '|| pINSTANCE_ID); -- Instance ID of the APS server
118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Source Instance Id: '|| pSource_instance_id); -- Instance ID of the RP instance
119: -- Initialize Global Variables
120: v_src_instance_id := pSource_instance_id;
121: v_rp_instance_id := pINSTANCE_ID;
122:

Line 136: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'SRC DB Link- v_src_dblink is: '|| v_src_dblink );

132: INTO v_src_dblink ,v_last_update_date ,v_last_updated_by,v_creation_date ,v_created_by
133: FROM MSC_APPS_INSTANCES
134: WHERE INSTANCE_ID=pSource_instance_id;
135:
136: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'SRC DB Link- v_src_dblink is: '|| v_src_dblink );
137:
138: EXCEPTION
139: WHEN NO_DATA_FOUND THEN
140: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Source Instance Not defined for instance_id:' || to_char(pSource_instance_id));

Line 140: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Source Instance Not defined for instance_id:' || to_char(pSource_instance_id));

136: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'SRC DB Link- v_src_dblink is: '|| v_src_dblink );
137:
138: EXCEPTION
139: WHEN NO_DATA_FOUND THEN
140: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Source Instance Not defined for instance_id:' || to_char(pSource_instance_id));
141: RETCODE := MSC_UTIL.G_ERROR;
142: ERRBUF := 'Source Instance Not defined for instance_id';
143: RETURN;
144: WHEN OTHERS THEN

Line 141: RETCODE := MSC_UTIL.G_ERROR;

137:
138: EXCEPTION
139: WHEN NO_DATA_FOUND THEN
140: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Source Instance Not defined for instance_id:' || to_char(pSource_instance_id));
141: RETCODE := MSC_UTIL.G_ERROR;
142: ERRBUF := 'Source Instance Not defined for instance_id';
143: RETURN;
144: WHEN OTHERS THEN
145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);

Line 145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);

141: RETCODE := MSC_UTIL.G_ERROR;
142: ERRBUF := 'Source Instance Not defined for instance_id';
143: RETURN;
144: WHEN OTHERS THEN
145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
146: RETCODE := MSC_UTIL.G_ERROR;
147: ERRBUF := SQLERRM;
148: RETURN;
149: END;

Line 146: RETCODE := MSC_UTIL.G_ERROR;

142: ERRBUF := 'Source Instance Not defined for instance_id';
143: RETURN;
144: WHEN OTHERS THEN
145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
146: RETCODE := MSC_UTIL.G_ERROR;
147: ERRBUF := SQLERRM;
148: RETURN;
149: END;
150:

Line 155: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' Generated random number: ' || lv_random_number);

151: select dbms_random.random
152: into lv_random_number
153: from dual;
154:
155: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' Generated random number: ' || lv_random_number);
156: lv_sql_stmt := 'Update '
157: || ' mrp_ap_apps_instances_all'||'@'|| v_src_dblink
158: || ' set rp_source_ind = '|| to_char(lv_random_number)
159: || ' where instance_id = '|| pSource_instance_id ;

Line 161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Update SQL stmt is: '|| lv_sql_stmt );

157: || ' mrp_ap_apps_instances_all'||'@'|| v_src_dblink
158: || ' set rp_source_ind = '|| to_char(lv_random_number)
159: || ' where instance_id = '|| pSource_instance_id ;
160:
161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Update SQL stmt is: '|| lv_sql_stmt );
162: EXECUTE IMMEDIATE lv_sql_stmt;
163:
164: --derive aps instance_id
165: BEGIN

Line 174: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'APS DB Link- v_aps_dblink is: '|| v_aps_dblink);

170: FROM MSC_APPS_INSTANCES
171: WHERE INSTANCE_ID=pINSTANCE_ID;
172:
173:
174: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'APS DB Link- v_aps_dblink is: '|| v_aps_dblink);
175:
176: EXCEPTION
177: WHEN NO_DATA_FOUND THEN
178: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'APS Instance Not defined for instance_id:' || to_char(pINSTANCE_ID));

Line 178: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'APS Instance Not defined for instance_id:' || to_char(pINSTANCE_ID));

174: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'APS DB Link- v_aps_dblink is: '|| v_aps_dblink);
175:
176: EXCEPTION
177: WHEN NO_DATA_FOUND THEN
178: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'APS Instance Not defined for instance_id:' || to_char(pINSTANCE_ID));
179: RETCODE := MSC_UTIL.G_ERROR;
180: ERRBUF := 'Aps Instance Not defined for instance_id';
181: RETURN;
182: WHEN OTHERS THEN

Line 179: RETCODE := MSC_UTIL.G_ERROR;

175:
176: EXCEPTION
177: WHEN NO_DATA_FOUND THEN
178: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'APS Instance Not defined for instance_id:' || to_char(pINSTANCE_ID));
179: RETCODE := MSC_UTIL.G_ERROR;
180: ERRBUF := 'Aps Instance Not defined for instance_id';
181: RETURN;
182: WHEN OTHERS THEN
183: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);

Line 183: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);

179: RETCODE := MSC_UTIL.G_ERROR;
180: ERRBUF := 'Aps Instance Not defined for instance_id';
181: RETURN;
182: WHEN OTHERS THEN
183: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
184: RETCODE := MSC_UTIL.G_ERROR;
185: ERRBUF := SQLERRM;
186: RETURN;
187: END;

Line 184: RETCODE := MSC_UTIL.G_ERROR;

180: ERRBUF := 'Aps Instance Not defined for instance_id';
181: RETURN;
182: WHEN OTHERS THEN
183: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
184: RETCODE := MSC_UTIL.G_ERROR;
185: ERRBUF := SQLERRM;
186: RETURN;
187: END;
188:

Line 191: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'v_instance_id : '|| v_instance_id );

187: END;
188:
189: GET_SOURCE_INSTANCE_ID(lv_random_number,v_aps_dblink ,v_instance_id);
190:
191: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'v_instance_id : '|| v_instance_id );
192:
193: -- Call the PROCEDURE to copy forecast data and other related tables
194: COPY_DP_SCENARIOS ;
195: COPY_DP_SCENARIO_REVISIONS;

Line 202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Error in copy- No records found ' );

198: COPY_MSD_DP_SCENARIO_OP_LEVELS ;
199:
200: EXCEPTION
201: WHEN NO_DATA_FOUND THEN
202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Error in copy- No records found ' );
203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
204: RETCODE := MSC_UTIL.G_ERROR;
205: ERRBUF := 'No data found';
206: RETURN;

Line 203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);

199:
200: EXCEPTION
201: WHEN NO_DATA_FOUND THEN
202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Error in copy- No records found ' );
203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
204: RETCODE := MSC_UTIL.G_ERROR;
205: ERRBUF := 'No data found';
206: RETURN;
207: WHEN OTHERS THEN

Line 204: RETCODE := MSC_UTIL.G_ERROR;

200: EXCEPTION
201: WHEN NO_DATA_FOUND THEN
202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Error in copy- No records found ' );
203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
204: RETCODE := MSC_UTIL.G_ERROR;
205: ERRBUF := 'No data found';
206: RETURN;
207: WHEN OTHERS THEN
208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);

Line 208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);

204: RETCODE := MSC_UTIL.G_ERROR;
205: ERRBUF := 'No data found';
206: RETURN;
207: WHEN OTHERS THEN
208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
209: RETCODE := MSC_UTIL.G_ERROR;
210: ERRBUF := SQLERRM;
211: ROLLBACK;
212: RETURN;

Line 209: RETCODE := MSC_UTIL.G_ERROR;

205: ERRBUF := 'No data found';
206: RETURN;
207: WHEN OTHERS THEN
208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
209: RETCODE := MSC_UTIL.G_ERROR;
210: ERRBUF := SQLERRM;
211: ROLLBACK;
212: RETURN;
213:

Line 216: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'End of CP ');

212: RETURN;
213:
214: Commit;
215:
216: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'End of CP ');
217:
218: END LAUNCH_MONITOR;
219:
220:

Line 232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCN_ENTRIES_DENORM '|| SQL%ROWCOUNT);

228: BEGIN
229:
230: DELETE FROM MSD_DP_SCN_ENTRIES_DENORM
231: WHERE SR_INSTANCE_ID = v_src_instance_id;
232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCN_ENTRIES_DENORM '|| SQL%ROWCOUNT);
233:
234: v_sql_stmt:=
235: 'INSERT INTO MSD_DP_SCN_ENTRIES_DENORM ('
236: || 'DEMAND_PLAN_ID,'

Line 299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into denorm table is :- '||v_sql_stmt);

295: ||' WHERE RP_lid.sr_inventory_item_id = APS.sr_inventory_item_id'
296: ||' AND APS.SR_INSTANCE_ID = '||v_instance_id
297: ||' AND RP_lid.sr_instance_id = '|| v_src_instance_id;
298:
299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into denorm table is :- '||v_sql_stmt);
300:
301: EXECUTE IMMEDIATE v_sql_stmt USING v_src_instance_id;
302:
303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCN_ENTRIES_DENORM is :- '||sql%rowcount);

Line 303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCN_ENTRIES_DENORM is :- '||sql%rowcount);

299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into denorm table is :- '||v_sql_stmt);
300:
301: EXECUTE IMMEDIATE v_sql_stmt USING v_src_instance_id;
302:
303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCN_ENTRIES_DENORM is :- '||sql%rowcount);
304:
305: Commit;
306:
307: END COPY_DP_FORECAST;

Line 315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCENARIOS '|| SQL%ROWCOUNT);

311:
312: BEGIN
313:
314: Delete from MSD_DP_SCENARIOS;-- commit;
315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCENARIOS '|| SQL%ROWCOUNT);
316:
317: v_sql_stmt:=
318: 'INSERT INTO MSD_DP_SCENARIOS ('
319: || 'DEMAND_PLAN_ID,'

Line 419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DP_SCENARIOS table is :- '||v_sql_stmt);

415: || 'SC_TYPE,'
416: || 'ASSOCIATE_PARAMETER'
417: || ' from MSD_DP_SCENARIOS'|| v_aps_dblink;
418:
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DP_SCENARIOS table is :- '||v_sql_stmt);
420: EXECUTE IMMEDIATE v_sql_stmt;
421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIOS is :- '||sql%rowcount);
422:
423: Commit;

Line 421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIOS is :- '||sql%rowcount);

417: || ' from MSD_DP_SCENARIOS'|| v_aps_dblink;
418:
419: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DP_SCENARIOS table is :- '||v_sql_stmt);
420: EXECUTE IMMEDIATE v_sql_stmt;
421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIOS is :- '||sql%rowcount);
422:
423: Commit;
424:
425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Copy MSD_DP_SCENARIOS for Demantra' );

Line 425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Copy MSD_DP_SCENARIOS for Demantra' );

421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIOS is :- '||sql%rowcount);
422:
423: Commit;
424:
425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Copy MSD_DP_SCENARIOS for Demantra' );
426: v_sql_stmt:=
427: 'INSERT INTO MSD_DP_SCENARIOS ('
428: || 'DEMAND_PLAN_ID,'
429: || 'SCENARIO_ID,'

Line 453: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Demantra insert into MSD_DP_SCENARIOS table is :- '||v_sql_stmt);

449: || ' where DEMAND_PLAN_ID = ' ||5555555
450: || ' and not exists (select 1 from MSD_DP_SCENARIOS RP '
451: ||' where RP.scenario_id = APS.SCENARIO_ID)';
452:
453: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Demantra insert into MSD_DP_SCENARIOS table is :- '||v_sql_stmt);
454: EXECUTE IMMEDIATE v_sql_stmt USING v_last_update_date,v_last_updated_by,v_creation_date,v_created_by;
455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIOS for demantra is :- '||sql%rowcount);
456:
457: Commit;

Line 455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIOS for demantra is :- '||sql%rowcount);

451: ||' where RP.scenario_id = APS.SCENARIO_ID)';
452:
453: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Demantra insert into MSD_DP_SCENARIOS table is :- '||v_sql_stmt);
454: EXECUTE IMMEDIATE v_sql_stmt USING v_last_update_date,v_last_updated_by,v_creation_date,v_created_by;
455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIOS for demantra is :- '||sql%rowcount);
456:
457: Commit;
458:
459: END COPY_DP_SCENARIOS;

Line 466: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCENARIO_REVISIONS '|| SQL%ROWCOUNT);

462:
463: BEGIN
464:
465: Delete from MSD_DP_SCENARIO_REVISIONS; --commit;
466: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCENARIO_REVISIONS '|| SQL%ROWCOUNT);
467:
468: v_sql_stmt:=
469: 'Insert into MSD_DP_SCENARIO_REVISIONS ('
470: || 'DEMAND_PLAN_ID,'

Line 494: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DP_SCENARIO_REVISIONS table is :- '||v_sql_stmt);

490: || 'LAST_UPDATE_LOGIN,'
491: || 'ERROR_TYPE'
492: || ' from MSD_DP_SCENARIO_REVISIONS'|| v_aps_dblink;
493:
494: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DP_SCENARIO_REVISIONS table is :- '||v_sql_stmt);
495: EXECUTE IMMEDIATE v_sql_stmt ;
496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIO_REVISIONS is :- '||sql%rowcount);
497:
498: EXCEPTION

Line 496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIO_REVISIONS is :- '||sql%rowcount);

492: || ' from MSD_DP_SCENARIO_REVISIONS'|| v_aps_dblink;
493:
494: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DP_SCENARIO_REVISIONS table is :- '||v_sql_stmt);
495: EXECUTE IMMEDIATE v_sql_stmt ;
496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIO_REVISIONS is :- '||sql%rowcount);
497:
498: EXCEPTION
499: WHEN NO_DATA_FOUND THEN
500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No records in MSD_DP_SCENARIO_REVISIONS ' );

Line 500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No records in MSD_DP_SCENARIO_REVISIONS ' );

496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIO_REVISIONS is :- '||sql%rowcount);
497:
498: EXCEPTION
499: WHEN NO_DATA_FOUND THEN
500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No records in MSD_DP_SCENARIO_REVISIONS ' );
501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
502: --RETCODE := MSC_UTIL.G_ERROR;
503: --ERRBUF := 'No data found';
504: RETURN;

Line 501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);

497:
498: EXCEPTION
499: WHEN NO_DATA_FOUND THEN
500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No records in MSD_DP_SCENARIO_REVISIONS ' );
501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
502: --RETCODE := MSC_UTIL.G_ERROR;
503: --ERRBUF := 'No data found';
504: RETURN;
505: WHEN OTHERS THEN

Line 502: --RETCODE := MSC_UTIL.G_ERROR;

498: EXCEPTION
499: WHEN NO_DATA_FOUND THEN
500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No records in MSD_DP_SCENARIO_REVISIONS ' );
501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
502: --RETCODE := MSC_UTIL.G_ERROR;
503: --ERRBUF := 'No data found';
504: RETURN;
505: WHEN OTHERS THEN
506: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);

Line 506: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);

502: --RETCODE := MSC_UTIL.G_ERROR;
503: --ERRBUF := 'No data found';
504: RETURN;
505: WHEN OTHERS THEN
506: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
507: -- RETCODE := MSC_UTIL.G_ERROR;
508: -- ERRBUF := SQLERRM;
509: ROLLBACK;
510: RETURN;

Line 507: -- RETCODE := MSC_UTIL.G_ERROR;

503: --ERRBUF := 'No data found';
504: RETURN;
505: WHEN OTHERS THEN
506: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
507: -- RETCODE := MSC_UTIL.G_ERROR;
508: -- ERRBUF := SQLERRM;
509: ROLLBACK;
510: RETURN;
511:

Line 519: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DEMAND_PLANS '|| SQL%ROWCOUNT);

515:
516: BEGIN
517:
518: Delete from MSD_DEMAND_PLANS; -- commit;
519: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DEMAND_PLANS '|| SQL%ROWCOUNT);
520: v_sql_stmt:=
521: 'Insert into MSD_DEMAND_PLANS ('
522: || 'DEMAND_PLAN_ID,'
523: || 'ORGANIZATION_ID,'

Line 653: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DEMAND_PLANS table is :- '||v_sql_stmt);

649: || 'DELETE_REQUEST_ID'
650: || ' from MSD_DEMAND_PLANS'|| v_aps_dblink
651: || ' where sr_instance_id = '|| v_instance_id;
652:
653: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DEMAND_PLANS table is :- '||v_sql_stmt);
654: EXECUTE IMMEDIATE v_sql_stmt USING v_src_instance_id;
655: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DEMAND_PLANS is :- '||sql%rowcount);
656:
657: Commit;

Line 655: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DEMAND_PLANS is :- '||sql%rowcount);

651: || ' where sr_instance_id = '|| v_instance_id;
652:
653: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DEMAND_PLANS table is :- '||v_sql_stmt);
654: EXECUTE IMMEDIATE v_sql_stmt USING v_src_instance_id;
655: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DEMAND_PLANS is :- '||sql%rowcount);
656:
657: Commit;
658:
659: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Demantra Insert into MSD_DEMAND_PLANS table');

Line 659: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Demantra Insert into MSD_DEMAND_PLANS table');

655: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DEMAND_PLANS is :- '||sql%rowcount);
656:
657: Commit;
658:
659: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Demantra Insert into MSD_DEMAND_PLANS table');
660: v_sql_stmt:=
661: 'Insert into MSD_DEMAND_PLANS ('
662: || 'DEMAND_PLAN_ID,'
663: || 'DEMAND_PLAN_NAME,'

Line 682: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Demantra Insert into MSD_DEMAND_PLANS table is :- '||v_sql_stmt);

678: || ':v_creation_date,'
679: || ':v_created_by,'
680: || 'NULL)';
681:
682: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Demantra Insert into MSD_DEMAND_PLANS table is :- '||v_sql_stmt);
683: EXECUTE IMMEDIATE v_sql_stmt USING v_src_instance_id,v_last_update_date,v_last_updated_by,v_creation_date,v_created_by;
684: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted for demantra into MSD_DEMAND_PLANS is :- '||sql%rowcount);
685:
686: Commit;

Line 684: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted for demantra into MSD_DEMAND_PLANS is :- '||sql%rowcount);

680: || 'NULL)';
681:
682: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Demantra Insert into MSD_DEMAND_PLANS table is :- '||v_sql_stmt);
683: EXECUTE IMMEDIATE v_sql_stmt USING v_src_instance_id,v_last_update_date,v_last_updated_by,v_creation_date,v_created_by;
684: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted for demantra into MSD_DEMAND_PLANS is :- '||sql%rowcount);
685:
686: Commit;
687:
688: END COPY_DP_DEMAND_PLANS;

Line 695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCENARIO_OUTPUT_LEVELS '|| SQL%ROWCOUNT);

691:
692: BEGIN
693:
694: Delete from MSD_DP_SCENARIO_OUTPUT_LEVELS;-- Commit;
695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCENARIO_OUTPUT_LEVELS '|| SQL%ROWCOUNT);
696:
697: v_sql_stmt:=
698: 'Insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ('
699: || ' DEMAND_PLAN_ID, '

Line 728: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'SQL for insert into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| v_sql_stmt);

724: || ' PROGRAM_UPDATE_DATE '
725: || ' from MSD_DP_SCENARIO_OUTPUT_LEVELS'|| v_aps_dblink;
726:
727:
728: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'SQL for insert into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| v_sql_stmt);
729: EXECUTE IMMEDIATE v_sql_stmt ;
730: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Records inserted into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| sql%rowcount);
731:
732: Commit;

Line 730: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Records inserted into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| sql%rowcount);

726:
727:
728: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'SQL for insert into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| v_sql_stmt);
729: EXECUTE IMMEDIATE v_sql_stmt ;
730: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Records inserted into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| sql%rowcount);
731:
732: Commit;
733:
734: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Demantra insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ');

Line 734: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Demantra insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ');

730: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Records inserted into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| sql%rowcount);
731:
732: Commit;
733:
734: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Demantra insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ');
735: v_sql_stmt:=
736: 'Insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ('
737: || ' DEMAND_PLAN_ID, '
738: || ' SCENARIO_ID, '

Line 766: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'SQL for Demantra insert into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| v_sql_stmt);

762: || ' PROGRAM_UPDATE_DATE '
763: || ' from msd_dp_scn_output_levels_v'|| v_aps_dblink
764: || ' where DEMAND_PLAN_ID = '|| 5555555;
765:
766: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'SQL for Demantra insert into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| v_sql_stmt);
767: EXECUTE IMMEDIATE v_sql_stmt USING v_last_update_date,v_last_updated_by,v_creation_date,v_created_by;
768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Records inserted for demantra into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| sql%rowcount);
769:
770: Commit;

Line 768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Records inserted for demantra into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| sql%rowcount);

764: || ' where DEMAND_PLAN_ID = '|| 5555555;
765:
766: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'SQL for Demantra insert into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| v_sql_stmt);
767: EXECUTE IMMEDIATE v_sql_stmt USING v_last_update_date,v_last_updated_by,v_creation_date,v_created_by;
768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Records inserted for demantra into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| sql%rowcount);
769:
770: Commit;
771:
772: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Demantra insert into MSD_DP_SCENARIO_OUTPUT_LEVELS for level_id 7 ');

Line 772: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Demantra insert into MSD_DP_SCENARIO_OUTPUT_LEVELS for level_id 7 ');

768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Records inserted for demantra into MSD_DP_SCENARIO_OUTPUT_LEVELS is :- '|| sql%rowcount);
769:
770: Commit;
771:
772: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Demantra insert into MSD_DP_SCENARIO_OUTPUT_LEVELS for level_id 7 ');
773: v_sql_stmt:=
774: 'Insert into MSD_DP_SCENARIO_OUTPUT_LEVELS ('
775: || ' DEMAND_PLAN_ID, '
776: || ' SCENARIO_ID, '

Line 799: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'SQL for level_id Insert is :- '|| v_sql_stmt);

795: ||' where RP.scenario_id = APS.SCENARIO_ID'
796: ||' and RP.DEMAND_PLAN_ID = APS.DEMAND_PLAN_ID'
797: ||' and RP.level_id = 7)';
798:
799: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'SQL for level_id Insert is :- '|| v_sql_stmt);
800: EXECUTE IMMEDIATE v_sql_stmt USING v_last_update_date,v_last_updated_by,v_creation_date,v_created_by;
801: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'SQL for level_id Insert is :- '|| sql%rowcount);
802:
803: Commit;

Line 801: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'SQL for level_id Insert is :- '|| sql%rowcount);

797: ||' and RP.level_id = 7)';
798:
799: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'SQL for level_id Insert is :- '|| v_sql_stmt);
800: EXECUTE IMMEDIATE v_sql_stmt USING v_last_update_date,v_last_updated_by,v_creation_date,v_created_by;
801: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'SQL for level_id Insert is :- '|| sql%rowcount);
802:
803: Commit;
804: END COPY_MSD_DP_SCENARIO_OP_LEVELS;
805: