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.CE_FORECASTS_PKG dependencies on STANDARD

Line 190: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.create_empty_forecast');

186: EXCEPTION
187: WHEN OTHERS THEN
188: if (cc%ISOPEN) then close cc; end if;
189: if (cr%ISOPEN) then close cr; end if;
190: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.create_empty_forecast');
191: RAISE;
192: END;
193:
194: PROCEDURE add_column( X_new_forecast VARCHAR2,

Line 219: cep_standard.debug('>> CE_FORECASTS_PKG.add_column');

215: p_forecast_cell_id NUMBER;
216: p_last_column_id NUMBER;
217: p_developer_column_num NUMBER;
218: BEGIN
219: cep_standard.debug('>> CE_FORECASTS_PKG.add_column');
220: IF(X_new_forecast = 'Y')THEN
221: CE_FORECASTS_PKG.duplicate_template_header(
222: X_forecast_header_id => X_forecast_header_id,
223: X_created_by => X_created_by,

Line 232: cep_standard.debug(' - insert new column');

228: X_forecast_id => X_forecast_id,
229: X_name => X_name);
230: END IF;
231:
232: cep_standard.debug(' - insert new column');
233: --
234: -- Insert new column into column table
235: --
236: CE_FORECAST_COLUMNS_PKG.insert_row(

Line 266: cep_standard.debug(' - insert new cells');

262: X_attribute13 => null,
263: X_attribute14 => null,
264: X_attribute15 => null);
265:
266: cep_standard.debug(' - insert new cells');
267: CE_FORECASTS_PKG.fill_cells( X_forecast_header_id,
268: 'COLUMN',
269: X_forecast_column_id,
270: X_created_by,

Line 276: cep_standard.debug(' - rearrange column number');

272: X_last_updated_by,
273: X_last_update_date,
274: X_last_update_login );
275:
276: cep_standard.debug(' - rearrange column number');
277: CE_FORECASTS_PKG.rearrange_column_number( X_forecast_header_id );
278:
279: cep_standard.debug(' - arrange GLC line');
280: --

Line 279: cep_standard.debug(' - arrange GLC line');

275:
276: cep_standard.debug(' - rearrange column number');
277: CE_FORECASTS_PKG.rearrange_column_number( X_forecast_header_id );
278:
279: cep_standard.debug(' - arrange GLC line');
280: --
281: -- If template contains GLC line, copy the GLC amount from the last
282: -- column to the new column for GLC
283: --

Line 332: cep_standard.debug('<< CE_FORECASTS_PKG.add_column');

328: --
329: -- Commit work
330: --
331: COMMIT;
332: cep_standard.debug('<< CE_FORECASTS_PKG.add_column');
333:
334: EXCEPTION
335: WHEN NO_DATA_FOUND THEN
336: null;

Line 339: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.add_column');

335: WHEN NO_DATA_FOUND THEN
336: null;
337: WHEN OTHERS THEN
338: IF SQLCODE <> -1422 THEN
339: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.add_column');
340: RAISE;
341: END IF;
342: END;
343:

Line 475: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.add_row');

471: COMMIT;
472:
473: EXCEPTION
474: WHEN OTHERS THEN
475: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.add_row');
476: RAISE;
477: END;
478:
479: PROCEDURE fill_cells( X_header_id NUMBER,

Line 556: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.add_row');

552: WHEN OTHERS THEN
553: if (cc%ISOPEN) then close cc; end if;
554: if (cr%ISOPEN) then close cr; end if;
555: if (cf%ISOPEN) then close cf; end if;
556: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.add_row');
557: RAISE;
558: END;
559:
560: PROCEDURE rearrange_column_number( X_forecast_header_id NUMBER ) IS

Line 589: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.rearrage_column_number');

585:
586: EXCEPTION
587: WHEN OTHERS THEN
588: if (cc%ISOPEN) then close cc; end if;
589: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.rearrage_column_number');
590: RAISE;
591: END;
592:
593: PROCEDURE duplicate_template_header(

Line 621: cep_standard.debug('>> CE_FORECASTS_PKG.duplicate_forecast_header');

617: WHERE forecast_header_id = X_forecast_header_id;
618: RowInfo CR%ROWTYPE;
619:
620: BEGIN
621: cep_standard.debug('>> CE_FORECASTS_PKG.duplicate_forecast_header');
622: --
623: -- Create duplicate header
624: --
625: open CH;

Line 631: cep_standard.debug(' - insert header');

627: IF (CH%NOTFOUND) THEN
628: Raise NO_DATA_FOUND;
629: END IF;
630:
631: cep_standard.debug(' - insert header');
632: CE_FORECAST_HEADERS_PKG.insert_row(
633: X_rowid => p_rowid,
634: X_forecast_header_id => p_forecast_header_id,
635: X_name => X_name,

Line 667: cep_standard.debug(' DONE inserted header with id = '||to_char(p_forecast_header_id));

663: X_attribute14 => HdrInfo.attribute14,
664: X_attribute15 => HdrInfo.attribute15);
665:
666: close CH;
667: cep_standard.debug(' DONE inserted header with id = '||to_char(p_forecast_header_id));
668:
669: --
670: -- Update forecast and forecast cells with new forecast_header_id
671: --

Line 686: cep_standard.debug(' - insert column, hid = '||to_char(p_forecast_header_id)||', col num= '

682: --
683: open CC;
684: fetch CC into ColInfo;
685: WHILE (CC%FOUND) LOOP
686: cep_standard.debug(' - insert column, hid = '||to_char(p_forecast_header_id)||', col num= '
687: ||to_char(ColInfo.column_number));
688: cid := NULL;
689: CE_FORECAST_COLUMNS_PKG.insert_row(
690: X_rowid => p_rowid,

Line 734: cep_standard.debug(' - insert row');

730: --
731: open CR;
732: fetch CR into RowInfo;
733: WHILE (CR%FOUND) LOOP
734: cep_standard.debug(' - insert row');
735: rid := NULL;
736: CE_FORECAST_ROWS1_PKG.Insert_Row(
737: X_rowid => p_rowid,
738: X_forecast_row_id => rid,

Line 833: cep_standard.debug('<< CE_FORECASTS_PKG.duplicate_forecast_header');

829: fetch CR into RowInfo;
830: END LOOP;
831:
832: x_forecast_header_id := p_forecast_header_id;
833: cep_standard.debug('<< CE_FORECASTS_PKG.duplicate_forecast_header');
834:
835: EXCEPTION
836: WHEN OTHERS THEN
837: if (ch%ISOPEN) then close ch; end if;

Line 840: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.duplicate_template_header');

836: WHEN OTHERS THEN
837: if (ch%ISOPEN) then close ch; end if;
838: if (cc%ISOPEN) then close cc; end if;
839: if (cr%ISOPEN) then close cr; end if;
840: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.duplicate_template_header');
841: RAISE;
842: END;
843:
844: PROCEDURE recalc_glc(X_hid IN NUMBER) IS

Line 952: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.recalc_glc');

948:
949: EXCEPTION
950: WHEN OTHERS THEN
951: IF (C_fid%ISOPEN) THEN CLOSE C_fid; END IF;
952: cep_standard.debug('EXCEPTION: CE_FORECASTS_PKG.recalc_glc');
953: RAISE;
954: END recalc_glc;
955:
956: