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_CURRENCY dependencies on MSD_DEM_COMMON_UTILITIES

Line 11: l_stmt := 'select max(datet), min(datet) from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'INPUTS');

7: l_stmt VARCHAR2(1000);
8:
9: BEGIN
10:
11: l_stmt := 'select max(datet), min(datet) from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'INPUTS');
12:
13: EXECUTE IMMEDIATE l_stmt
14: INTO l_max_date,
15: l_min_date;

Line 19: msd_dem_common_utilities.log_message(SUBSTR(sqlerrm, 1, 150));

15: l_min_date;
16:
17: EXCEPTION
18: WHEN others THEN
19: msd_dem_common_utilities.log_message(SUBSTR(sqlerrm, 1, 150));
20: msd_dem_common_utilities.log_debug(SUBSTR(sqlerrm, 1, 150));
21:
22: END;
23:

Line 20: msd_dem_common_utilities.log_debug(SUBSTR(sqlerrm, 1, 150));

16:
17: EXCEPTION
18: WHEN others THEN
19: msd_dem_common_utilities.log_message(SUBSTR(sqlerrm, 1, 150));
20: msd_dem_common_utilities.log_debug(SUBSTR(sqlerrm, 1, 150));
21:
22: END;
23:
24: PROCEDURE process_currency(retcode OUT NOCOPY VARCHAR2,

Line 79: l_stmt_get_seeded_unit := 'select real_value from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'REAL_VALUES') ||

75: l_stmt VARCHAR2(2000);
76:
77: BEGIN
78:
79: l_stmt_get_seeded_unit := 'select real_value from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'REAL_VALUES') ||
80: ' where real_value = ''' || p_currency_code || '''';
81:
82: open get_seeded_unit for l_stmt_get_seeded_unit;
83: fetch get_seeded_unit into l_get_seeded_unit;

Line 93: l_stmt_old_currency_real_value := 'select real_value_id, real_table from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'REAL_VALUES') || ' where real_value = ''' || p_currency_code || '''';

89: CLOSE verify_entities_inuse;
90:
91: IF l_verify_entities_inuse IS NOT NULL THEN
92:
93: l_stmt_old_currency_real_value := 'select real_value_id, real_table from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'REAL_VALUES') || ' where real_value = ''' || p_currency_code || '''';
94:
95: OPEN get_old_currency_real_value FOR l_stmt_old_currency_real_value;
96: FETCH get_old_currency_real_value
97: INTO new_currency;

Line 100: -- msd_dem_common_utilities.log_message('Currency Code: '||p_currency_code ||' already exists.');

96: FETCH get_old_currency_real_value
97: INTO new_currency;
98: CLOSE get_old_currency_real_value;
99:
100: -- msd_dem_common_utilities.log_message('Currency Code: '||p_currency_code ||' already exists.');
101:
102: ELSIF l_verify_entities_inuse IS NULL THEN
103:
104: if l_get_seeded_unit is not null then

Line 105: msd_dem_common_utilities.log_message('Seeded Display Unit with name ' || p_currency_code || ' exist in Demantra. This Currency will not be created');

101:
102: ELSIF l_verify_entities_inuse IS NULL THEN
103:
104: if l_get_seeded_unit is not null then
105: msd_dem_common_utilities.log_message('Seeded Display Unit with name ' || p_currency_code || ' exist in Demantra. This Currency will not be created');
106: msd_dem_common_utilities.log_debug('Seeded Display Unit with name ' || p_currency_code || ' exist in Demantra. This Currency will not be created');
107: retcode := 1;
108: return;
109: end if;

Line 106: msd_dem_common_utilities.log_debug('Seeded Display Unit with name ' || p_currency_code || ' exist in Demantra. This Currency will not be created');

102: ELSIF l_verify_entities_inuse IS NULL THEN
103:
104: if l_get_seeded_unit is not null then
105: msd_dem_common_utilities.log_message('Seeded Display Unit with name ' || p_currency_code || ' exist in Demantra. This Currency will not be created');
106: msd_dem_common_utilities.log_debug('Seeded Display Unit with name ' || p_currency_code || ' exist in Demantra. This Currency will not be created');
107: retcode := 1;
108: return;
109: end if;
110:

Line 111: msd_dem_common_utilities.log_message('Creating Currency : ' || p_currency_code);

107: retcode := 1;
108: return;
109: end if;
110:
111: msd_dem_common_utilities.log_message('Creating Currency : ' || p_currency_code);
112:
113: l_stmt_new_currency_real_value := 'select real_value_id, real_table ' || ' from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'REAL_VALUES') || ' where real_value_id in '
114: || ' (select distinct real_value_id from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'REAL_VALUES') || ' minus ' || ' select distinct real_value_id from '
115: || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_INDEX') || ' )' || ' and lower(real_value) like ''%ebscurrency%'' and rownum < 2';

Line 113: l_stmt_new_currency_real_value := 'select real_value_id, real_table ' || ' from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'REAL_VALUES') || ' where real_value_id in '

109: end if;
110:
111: msd_dem_common_utilities.log_message('Creating Currency : ' || p_currency_code);
112:
113: l_stmt_new_currency_real_value := 'select real_value_id, real_table ' || ' from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'REAL_VALUES') || ' where real_value_id in '
114: || ' (select distinct real_value_id from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'REAL_VALUES') || ' minus ' || ' select distinct real_value_id from '
115: || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_INDEX') || ' )' || ' and lower(real_value) like ''%ebscurrency%'' and rownum < 2';
116: msd_dem_common_utilities.log_debug(l_stmt_new_currency_real_value);
117:

Line 114: || ' (select distinct real_value_id from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'REAL_VALUES') || ' minus ' || ' select distinct real_value_id from '

110:
111: msd_dem_common_utilities.log_message('Creating Currency : ' || p_currency_code);
112:
113: l_stmt_new_currency_real_value := 'select real_value_id, real_table ' || ' from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'REAL_VALUES') || ' where real_value_id in '
114: || ' (select distinct real_value_id from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'REAL_VALUES') || ' minus ' || ' select distinct real_value_id from '
115: || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_INDEX') || ' )' || ' and lower(real_value) like ''%ebscurrency%'' and rownum < 2';
116: msd_dem_common_utilities.log_debug(l_stmt_new_currency_real_value);
117:
118: OPEN get_new_currency_real_value FOR l_stmt_new_currency_real_value;

Line 115: || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_INDEX') || ' )' || ' and lower(real_value) like ''%ebscurrency%'' and rownum < 2';

111: msd_dem_common_utilities.log_message('Creating Currency : ' || p_currency_code);
112:
113: l_stmt_new_currency_real_value := 'select real_value_id, real_table ' || ' from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'REAL_VALUES') || ' where real_value_id in '
114: || ' (select distinct real_value_id from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'REAL_VALUES') || ' minus ' || ' select distinct real_value_id from '
115: || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_INDEX') || ' )' || ' and lower(real_value) like ''%ebscurrency%'' and rownum < 2';
116: msd_dem_common_utilities.log_debug(l_stmt_new_currency_real_value);
117:
118: OPEN get_new_currency_real_value FOR l_stmt_new_currency_real_value;
119: FETCH get_new_currency_real_value

Line 116: msd_dem_common_utilities.log_debug(l_stmt_new_currency_real_value);

112:
113: l_stmt_new_currency_real_value := 'select real_value_id, real_table ' || ' from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'REAL_VALUES') || ' where real_value_id in '
114: || ' (select distinct real_value_id from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'REAL_VALUES') || ' minus ' || ' select distinct real_value_id from '
115: || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_INDEX') || ' )' || ' and lower(real_value) like ''%ebscurrency%'' and rownum < 2';
116: msd_dem_common_utilities.log_debug(l_stmt_new_currency_real_value);
117:
118: OPEN get_new_currency_real_value FOR l_stmt_new_currency_real_value;
119: FETCH get_new_currency_real_value
120: INTO new_currency;

Line 123: msd_dem_common_utilities.log_message('Cannot create new currency' || ' as no more empty dummy currency exists.');

119: FETCH get_new_currency_real_value
120: INTO new_currency;
121:
122: IF get_new_currency_real_value % NOTFOUND THEN
123: msd_dem_common_utilities.log_message('Cannot create new currency' || ' as no more empty dummy currency exists.');
124: msd_dem_common_utilities.log_debug('Cannot create new currency' || ' as no more empty dummy currency exists.');
125: CLOSE get_new_currency_real_value;
126: retcode := 1;
127: RETURN;

Line 124: msd_dem_common_utilities.log_debug('Cannot create new currency' || ' as no more empty dummy currency exists.');

120: INTO new_currency;
121:
122: IF get_new_currency_real_value % NOTFOUND THEN
123: msd_dem_common_utilities.log_message('Cannot create new currency' || ' as no more empty dummy currency exists.');
124: msd_dem_common_utilities.log_debug('Cannot create new currency' || ' as no more empty dummy currency exists.');
125: CLOSE get_new_currency_real_value;
126: retcode := 1;
127: RETURN;
128: END IF;

Line 158: l_stmt := 'update ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'REAL_VALUES') || '

154: ,:8
155: )';
156:
157: EXECUTE IMMEDIATE l_stmt USING p_currency_code, new_currency.real_table, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, fnd_global.user_id;
158: l_stmt := 'update ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'REAL_VALUES') || '
159: set real_value = :1
160: where real_value_id = :2';
161:
162: EXECUTE IMMEDIATE l_stmt USING p_currency_code,

Line 165: l_stmt_get_component := 'select dcm_product_id from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS') || ' where product_name = '''

161:
162: EXECUTE IMMEDIATE l_stmt USING p_currency_code,
163: new_currency.real_value_id;
164:
165: l_stmt_get_component := 'select dcm_product_id from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS') || ' where product_name = '''
166: || msd_dem_common_utilities.get_lookup_value('MSD_DEM_COMPONENTS', 'DEMAND_MANAGEMENT') || '''';
167:
168: OPEN get_component FOR l_stmt_get_component;
169: FETCH get_component

Line 166: || msd_dem_common_utilities.get_lookup_value('MSD_DEM_COMPONENTS', 'DEMAND_MANAGEMENT') || '''';

162: EXECUTE IMMEDIATE l_stmt USING p_currency_code,
163: new_currency.real_value_id;
164:
165: l_stmt_get_component := 'select dcm_product_id from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS') || ' where product_name = '''
166: || msd_dem_common_utilities.get_lookup_value('MSD_DEM_COMPONENTS', 'DEMAND_MANAGEMENT') || '''';
167:
168: OPEN get_component FOR l_stmt_get_component;
169: FETCH get_component
170: INTO l_component_id;

Line 173: l_stmt := 'insert into ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_INDEX') || '

169: FETCH get_component
170: INTO l_component_id;
171: CLOSE get_component;
172:
173: l_stmt := 'insert into ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_INDEX') || '
174: (dcm_product_id
175: ,real_value_id
176: )
177: (

Line 185: l_stmt_get_component_sop := 'select dcm_product_id from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS') || ' where product_name = '''

181: new_currency.real_value_id;
182:
183:
184:
185: l_stmt_get_component_sop := 'select dcm_product_id from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS') || ' where product_name = '''
186: || msd_dem_common_utilities.get_lookup_value('MSD_DEM_COMPONENTS', 'SOP') || '''';
187:
188: OPEN get_component_sop FOR l_stmt_get_component_sop;
189: FETCH get_component_sop

Line 186: || msd_dem_common_utilities.get_lookup_value('MSD_DEM_COMPONENTS', 'SOP') || '''';

182:
183:
184:
185: l_stmt_get_component_sop := 'select dcm_product_id from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS') || ' where product_name = '''
186: || msd_dem_common_utilities.get_lookup_value('MSD_DEM_COMPONENTS', 'SOP') || '''';
187:
188: OPEN get_component_sop FOR l_stmt_get_component_sop;
189: FETCH get_component_sop
190: INTO l_component_id_sop;

Line 193: l_stmt := 'insert into ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_INDEX') || '

189: FETCH get_component_sop
190: INTO l_component_id_sop;
191: CLOSE get_component_sop;
192:
193: l_stmt := 'insert into ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_INDEX') || '
194: (dcm_product_id
195: ,real_value_id
196: )
197: (

Line 203: l_stmt := 'insert into ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'INDEXES_FOR_UNITS') ||

199: )';
200: EXECUTE IMMEDIATE l_stmt USING l_component_id_sop,
201: new_currency.real_value_id;
202:
203: l_stmt := 'insert into ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'INDEXES_FOR_UNITS') ||
204: ' (display_units_id, real_value_id) ' ||
205: ' (select display_units_id, :1 from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' du, msd_dem_entities_inuse mdei ' ||
206: ' where mdei.ebs_entity = ''PRL'' and mdei.internal_name = du.display_units)';
207:

Line 205: ' (select display_units_id, :1 from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' du, msd_dem_entities_inuse mdei ' ||

201: new_currency.real_value_id;
202:
203: l_stmt := 'insert into ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'INDEXES_FOR_UNITS') ||
204: ' (display_units_id, real_value_id) ' ||
205: ' (select display_units_id, :1 from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' du, msd_dem_entities_inuse mdei ' ||
206: ' where mdei.ebs_entity = ''PRL'' and mdei.internal_name = du.display_units)';
207:
208: msd_dem_common_utilities.log_debug(l_stmt);
209:

Line 208: msd_dem_common_utilities.log_debug(l_stmt);

204: ' (display_units_id, real_value_id) ' ||
205: ' (select display_units_id, :1 from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' du, msd_dem_entities_inuse mdei ' ||
206: ' where mdei.ebs_entity = ''PRL'' and mdei.internal_name = du.display_units)';
207:
208: msd_dem_common_utilities.log_debug(l_stmt);
209:
210: execute immediate l_stmt using new_currency.real_value_id;
211:
212: END IF;

Line 214: msd_dem_common_utilities.log_message('Collecting Currency : ' || p_currency_code);

210: execute immediate l_stmt using new_currency.real_value_id;
211:
212: END IF;
213:
214: msd_dem_common_utilities.log_message('Collecting Currency : ' || p_currency_code);
215: msd_dem_common_utilities.log_debug('Collecting Currency : ' || p_currency_code);
216:
217: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS'));
218:

Line 215: msd_dem_common_utilities.log_debug('Collecting Currency : ' || p_currency_code);

211:
212: END IF;
213:
214: msd_dem_common_utilities.log_message('Collecting Currency : ' || p_currency_code);
215: msd_dem_common_utilities.log_debug('Collecting Currency : ' || p_currency_code);
216:
217: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS'));
218:
219: l_stmt := 'delete from ' || fnd_profile.VALUE('MSD_DEM_SCHEMA') || '.' || new_currency.real_table || ' where index_date between :1 and :2 ';

Line 217: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS'));

213:
214: msd_dem_common_utilities.log_message('Collecting Currency : ' || p_currency_code);
215: msd_dem_common_utilities.log_debug('Collecting Currency : ' || p_currency_code);
216:
217: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS'));
218:
219: l_stmt := 'delete from ' || fnd_profile.VALUE('MSD_DEM_SCHEMA') || '.' || new_currency.real_table || ' where index_date between :1 and :2 ';
220:
221: msd_dem_common_utilities.log_debug('Bind Variables: ');

Line 221: msd_dem_common_utilities.log_debug('Bind Variables: ');

217: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS'));
218:
219: l_stmt := 'delete from ' || fnd_profile.VALUE('MSD_DEM_SCHEMA') || '.' || new_currency.real_table || ' where index_date between :1 and :2 ';
220:
221: msd_dem_common_utilities.log_debug('Bind Variables: ');
222: msd_dem_common_utilities.log_debug('From Date: ' || p_from_date);
223: msd_dem_common_utilities.log_debug('To Date: ' || p_to_date);
224: msd_dem_common_utilities.log_debug('Delete statement for currency: ' || l_stmt);
225:

Line 222: msd_dem_common_utilities.log_debug('From Date: ' || p_from_date);

218:
219: l_stmt := 'delete from ' || fnd_profile.VALUE('MSD_DEM_SCHEMA') || '.' || new_currency.real_table || ' where index_date between :1 and :2 ';
220:
221: msd_dem_common_utilities.log_debug('Bind Variables: ');
222: msd_dem_common_utilities.log_debug('From Date: ' || p_from_date);
223: msd_dem_common_utilities.log_debug('To Date: ' || p_to_date);
224: msd_dem_common_utilities.log_debug('Delete statement for currency: ' || l_stmt);
225:
226: EXECUTE IMMEDIATE l_stmt USING p_from_date,

Line 223: msd_dem_common_utilities.log_debug('To Date: ' || p_to_date);

219: l_stmt := 'delete from ' || fnd_profile.VALUE('MSD_DEM_SCHEMA') || '.' || new_currency.real_table || ' where index_date between :1 and :2 ';
220:
221: msd_dem_common_utilities.log_debug('Bind Variables: ');
222: msd_dem_common_utilities.log_debug('From Date: ' || p_from_date);
223: msd_dem_common_utilities.log_debug('To Date: ' || p_to_date);
224: msd_dem_common_utilities.log_debug('Delete statement for currency: ' || l_stmt);
225:
226: EXECUTE IMMEDIATE l_stmt USING p_from_date,
227: p_to_date;

Line 224: msd_dem_common_utilities.log_debug('Delete statement for currency: ' || l_stmt);

220:
221: msd_dem_common_utilities.log_debug('Bind Variables: ');
222: msd_dem_common_utilities.log_debug('From Date: ' || p_from_date);
223: msd_dem_common_utilities.log_debug('To Date: ' || p_to_date);
224: msd_dem_common_utilities.log_debug('Delete statement for currency: ' || l_stmt);
225:
226: EXECUTE IMMEDIATE l_stmt USING p_from_date,
227: p_to_date;
228:

Line 243: msd_dem_common_utilities.log_debug(l_stmt);

239: ' and conversion_type = ''' || fnd_profile.value('MSD_DEM_CONVERSION_TYPE') || ''')';
240: l_stmt := REPLACE(l_stmt, 'DBLINK', g_dblink);
241: END IF;
242:
243: msd_dem_common_utilities.log_debug(l_stmt);
244:
245: EXECUTE IMMEDIATE l_stmt USING p_from_date,
246: p_to_date;
247: COMMIT;

Line 254: msd_dem_common_utilities.log_message('No records exist for currency ' || p_currency_code || ' between ' || p_from_date || ' and ' || p_to_date);

250:
251: execute immediate l_stmt into l_cur_count;
252:
253: if l_cur_count = 0 then
254: msd_dem_common_utilities.log_message('No records exist for currency ' || p_currency_code || ' between ' || p_from_date || ' and ' || p_to_date);
255: end if;
256:
257: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS'));
258: msd_dem_common_utilities.log_message('Currency : ' || p_currency_code || ' collection is finished.');

Line 257: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS'));

253: if l_cur_count = 0 then
254: msd_dem_common_utilities.log_message('No records exist for currency ' || p_currency_code || ' between ' || p_from_date || ' and ' || p_to_date);
255: end if;
256:
257: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS'));
258: msd_dem_common_utilities.log_message('Currency : ' || p_currency_code || ' collection is finished.');
259: msd_dem_common_utilities.log_debug('Currency : ' || p_currency_code || ' collection is finished.');
260:
261: END;

Line 258: msd_dem_common_utilities.log_message('Currency : ' || p_currency_code || ' collection is finished.');

254: msd_dem_common_utilities.log_message('No records exist for currency ' || p_currency_code || ' between ' || p_from_date || ' and ' || p_to_date);
255: end if;
256:
257: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS'));
258: msd_dem_common_utilities.log_message('Currency : ' || p_currency_code || ' collection is finished.');
259: msd_dem_common_utilities.log_debug('Currency : ' || p_currency_code || ' collection is finished.');
260:
261: END;
262:

Line 259: msd_dem_common_utilities.log_debug('Currency : ' || p_currency_code || ' collection is finished.');

255: end if;
256:
257: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS'));
258: msd_dem_common_utilities.log_message('Currency : ' || p_currency_code || ' collection is finished.');
259: msd_dem_common_utilities.log_debug('Currency : ' || p_currency_code || ' collection is finished.');
260:
261: END;
262:
263: PROCEDURE collect_currency(errbuf OUT NOCOPY VARCHAR2,

Line 298: msd_dem_common_utilities.log_debug('Entering: msd_dem_collect_currency.collect_currency - ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

294: l_curr_code VARCHAR2(30);
295:
296: BEGIN
297:
298: msd_dem_common_utilities.log_debug('Entering: msd_dem_collect_currency.collect_currency - ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
299: msd_dem_common_utilities.log_message('Entering: msd_dem_collect_currency.collect_currency - ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
300:
301: /* Get the db link to the source instance */ msd_dem_common_utilities.get_dblink(x_errbuf, x_retcode, p_instance_id, g_dblink);
302:

Line 299: msd_dem_common_utilities.log_message('Entering: msd_dem_collect_currency.collect_currency - ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

295:
296: BEGIN
297:
298: msd_dem_common_utilities.log_debug('Entering: msd_dem_collect_currency.collect_currency - ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
299: msd_dem_common_utilities.log_message('Entering: msd_dem_collect_currency.collect_currency - ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
300:
301: /* Get the db link to the source instance */ msd_dem_common_utilities.get_dblink(x_errbuf, x_retcode, p_instance_id, g_dblink);
302:
303: IF(x_retcode = '-1') THEN

Line 301: /* Get the db link to the source instance */ msd_dem_common_utilities.get_dblink(x_errbuf, x_retcode, p_instance_id, g_dblink);

297:
298: msd_dem_common_utilities.log_debug('Entering: msd_dem_collect_currency.collect_currency - ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
299: msd_dem_common_utilities.log_message('Entering: msd_dem_collect_currency.collect_currency - ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
300:
301: /* Get the db link to the source instance */ msd_dem_common_utilities.get_dblink(x_errbuf, x_retcode, p_instance_id, g_dblink);
302:
303: IF(x_retcode = '-1') THEN
304: retcode := -1;
305: errbuf := x_errbuf;

Line 306: msd_dem_common_utilities.log_message('Error(1): msd_dem_collect_currency.collect_currency - ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

302:
303: IF(x_retcode = '-1') THEN
304: retcode := -1;
305: errbuf := x_errbuf;
306: msd_dem_common_utilities.log_message('Error(1): msd_dem_collect_currency.collect_currency - ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
307: RETURN;
308: END IF;
309:
310: /* Get the min and max date in demantra time */

Line 324: msd_dem_common_utilities.log_message('Error: msd_dem_collect_currency.collect_currency- ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

320:
321: IF(l_date_from > l_date_to) THEN
322: retcode := -1;
323: errbuf := 'From Date should not be greater than To Date.';
324: msd_dem_common_utilities.log_message('Error: msd_dem_collect_currency.collect_currency- ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
325: msd_dem_common_utilities.log_message(errbuf);
326: RETURN;
327: END IF;
328:

Line 325: msd_dem_common_utilities.log_message(errbuf);

321: IF(l_date_from > l_date_to) THEN
322: retcode := -1;
323: errbuf := 'From Date should not be greater than To Date.';
324: msd_dem_common_utilities.log_message('Error: msd_dem_collect_currency.collect_currency- ' || to_char(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
325: msd_dem_common_utilities.log_message(errbuf);
326: RETURN;
327: END IF;
328:
329: IF(p_all_currencies = 2) THEN

Line 334: msd_dem_common_utilities.log_message('Both include list and exclude list are specified for currency collection. Please specify either include list or excluse list.');

330:
331: IF p_include_currency_list IS NOT NULL
332: AND p_exclude_currency_list IS NOT NULL THEN
333:
334: msd_dem_common_utilities.log_message('Both include list and exclude list are specified for currency collection. Please specify either include list or excluse list.');
335: msd_dem_common_utilities.log_debug('Both include list and exclude list are specified for currency collection. Please specify either include list or excluse list.');
336: retcode := -1;
337: RETURN;
338: ELSIF p_include_currency_list IS NULL

Line 335: msd_dem_common_utilities.log_debug('Both include list and exclude list are specified for currency collection. Please specify either include list or excluse list.');

331: IF p_include_currency_list IS NOT NULL
332: AND p_exclude_currency_list IS NOT NULL THEN
333:
334: msd_dem_common_utilities.log_message('Both include list and exclude list are specified for currency collection. Please specify either include list or excluse list.');
335: msd_dem_common_utilities.log_debug('Both include list and exclude list are specified for currency collection. Please specify either include list or excluse list.');
336: retcode := -1;
337: RETURN;
338: ELSIF p_include_currency_list IS NULL
339: AND p_exclude_currency_list IS NULL THEN

Line 341: msd_dem_common_utilities.log_message('None of include list and exclude list are not specified for currency collection. Please specify either include list or excluse list.');

337: RETURN;
338: ELSIF p_include_currency_list IS NULL
339: AND p_exclude_currency_list IS NULL THEN
340:
341: msd_dem_common_utilities.log_message('None of include list and exclude list are not specified for currency collection. Please specify either include list or excluse list.');
342: msd_dem_common_utilities.log_debug('None of include list and exclude list are not specified for currency collection. Please specify either include list or excluse list.');
343: retcode := -1;
344: RETURN;
345:

Line 342: msd_dem_common_utilities.log_debug('None of include list and exclude list are not specified for currency collection. Please specify either include list or excluse list.');

338: ELSIF p_include_currency_list IS NULL
339: AND p_exclude_currency_list IS NULL THEN
340:
341: msd_dem_common_utilities.log_message('None of include list and exclude list are not specified for currency collection. Please specify either include list or excluse list.');
342: msd_dem_common_utilities.log_debug('None of include list and exclude list are not specified for currency collection. Please specify either include list or excluse list.');
343: retcode := -1;
344: RETURN;
345:
346: END IF;

Line 388: msd_dem_common_utilities.log_debug(l_stmt);

384: l_stmt := l_stmt || ' in ' || '(' || l_list || ')';
385:
386: END IF;
387:
388: msd_dem_common_utilities.log_debug(l_stmt);
389:
390: OPEN c_get_curr_code FOR l_stmt;
391:
392: LOOP

Line 400: msd_dem_common_utilities.log_message('Warning: Base Currency is selected for collection');

396: EXIT
397: WHEN c_get_curr_code % NOTFOUND;
398:
399: /*if l_curr_code = l_base_curr then
400: msd_dem_common_utilities.log_message('Warning: Base Currency is selected for collection');
401: retcode := 1;
402: goto continue;
403: end if;*/
404:

Line 421: msd_dem_common_utilities.log_message('Warning: Base Currency ' || l_base_curr || ' is selected. Base Currency cannot be collected.');

417:
418: CLOSE c_get_curr_code;
419:
420: if instr(l_list2, l_base_curr) > 0 then
421: msd_dem_common_utilities.log_message('Warning: Base Currency ' || l_base_curr || ' is selected. Base Currency cannot be collected.');
422: l_list2 := RTRIM(l_list2, l_base_curr || ',');
423: retcode := 1;
424: end if;
425:

Line 430: msd_dem_common_utilities.log_message('Warning: Currencies: ' || l_list2 || ' do not exist.');

426: l_list2 := RTRIM(l_list2, ',');
427:
428: IF(l_list2 IS NOT NULL) THEN
429: retcode := 1;
430: msd_dem_common_utilities.log_message('Warning: Currencies: ' || l_list2 || ' do not exist.');
431: END IF;
432:
433: if retcode <> -1 and retcode <> 1 then
434: retcode := 0;

Line 441: msd_dem_common_utilities.log_message(errbuf);

437:
438: EXCEPTION
439: WHEN others THEN
440: errbuf := SUBSTR(sqlerrm, 1, 150);
441: msd_dem_common_utilities.log_message(errbuf);
442: msd_dem_common_utilities.log_debug(errbuf);
443: retcode := -1;
444:
445: END;

Line 442: msd_dem_common_utilities.log_debug(errbuf);

438: EXCEPTION
439: WHEN others THEN
440: errbuf := SUBSTR(sqlerrm, 1, 150);
441: msd_dem_common_utilities.log_message(errbuf);
442: msd_dem_common_utilities.log_debug(errbuf);
443: retcode := -1;
444:
445: END;
446: