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.GMF_COPY_RSRC_COST dependencies on GMF_UTIL

Line 114: gmf_util.msg_log( 'GMF_CPRC_START' );

110:
111: ---FND_FILE.PUT_NAMES('gmfcprc.log','gmfcprc.out','/sqlcom/log/dom1151');
112:
113:
114: gmf_util.msg_log( 'GMF_CPRC_START' );
115: gmf_util.msg_log( 'GMF_CPRC_SRCPARAM', nvl(TO_CHAR(pi_organization_id_from), ' '), nvl(pi_calendar_code_from, ' '), nvl(pi_period_code_from, ' '), nvl(TO_CHAR(pi_cost_type_id_from), ' '), nvl(pi_resource_class, ' '));
116: gmf_util.msg_log( 'GMF_CPRC_TGTPARAM', nvl(TO_CHAR(pi_organization_id_to), ' '), nvl(pi_calendar_code_to, ' '), nvl(pi_period_code_to, ' '), nvl(TO_CHAR(pi_cost_type_id_to), ' '));
117:
118: IF ((pi_period_code_to IS NULL) AND ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))) THEN

Line 115: gmf_util.msg_log( 'GMF_CPRC_SRCPARAM', nvl(TO_CHAR(pi_organization_id_from), ' '), nvl(pi_calendar_code_from, ' '), nvl(pi_period_code_from, ' '), nvl(TO_CHAR(pi_cost_type_id_from), ' '), nvl(pi_resource_class, ' '));

111: ---FND_FILE.PUT_NAMES('gmfcprc.log','gmfcprc.out','/sqlcom/log/dom1151');
112:
113:
114: gmf_util.msg_log( 'GMF_CPRC_START' );
115: gmf_util.msg_log( 'GMF_CPRC_SRCPARAM', nvl(TO_CHAR(pi_organization_id_from), ' '), nvl(pi_calendar_code_from, ' '), nvl(pi_period_code_from, ' '), nvl(TO_CHAR(pi_cost_type_id_from), ' '), nvl(pi_resource_class, ' '));
116: gmf_util.msg_log( 'GMF_CPRC_TGTPARAM', nvl(TO_CHAR(pi_organization_id_to), ' '), nvl(pi_calendar_code_to, ' '), nvl(pi_period_code_to, ' '), nvl(TO_CHAR(pi_cost_type_id_to), ' '));
117:
118: IF ((pi_period_code_to IS NULL) AND ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))) THEN
119: gmf_util.msg_log('GMF_CPRC_PERIODS_RANGE', nvl(pi_all_periods_from, ' '), nvl(pi_all_periods_to, ' '), nvl(pi_calendar_code_to, ' ')) ;

Line 116: gmf_util.msg_log( 'GMF_CPRC_TGTPARAM', nvl(TO_CHAR(pi_organization_id_to), ' '), nvl(pi_calendar_code_to, ' '), nvl(pi_period_code_to, ' '), nvl(TO_CHAR(pi_cost_type_id_to), ' '));

112:
113:
114: gmf_util.msg_log( 'GMF_CPRC_START' );
115: gmf_util.msg_log( 'GMF_CPRC_SRCPARAM', nvl(TO_CHAR(pi_organization_id_from), ' '), nvl(pi_calendar_code_from, ' '), nvl(pi_period_code_from, ' '), nvl(TO_CHAR(pi_cost_type_id_from), ' '), nvl(pi_resource_class, ' '));
116: gmf_util.msg_log( 'GMF_CPRC_TGTPARAM', nvl(TO_CHAR(pi_organization_id_to), ' '), nvl(pi_calendar_code_to, ' '), nvl(pi_period_code_to, ' '), nvl(TO_CHAR(pi_cost_type_id_to), ' '));
117:
118: IF ((pi_period_code_to IS NULL) AND ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))) THEN
119: gmf_util.msg_log('GMF_CPRC_PERIODS_RANGE', nvl(pi_all_periods_from, ' '), nvl(pi_all_periods_to, ' '), nvl(pi_calendar_code_to, ' ')) ;
120: END IF ;

Line 119: gmf_util.msg_log('GMF_CPRC_PERIODS_RANGE', nvl(pi_all_periods_from, ' '), nvl(pi_all_periods_to, ' '), nvl(pi_calendar_code_to, ' ')) ;

115: gmf_util.msg_log( 'GMF_CPRC_SRCPARAM', nvl(TO_CHAR(pi_organization_id_from), ' '), nvl(pi_calendar_code_from, ' '), nvl(pi_period_code_from, ' '), nvl(TO_CHAR(pi_cost_type_id_from), ' '), nvl(pi_resource_class, ' '));
116: gmf_util.msg_log( 'GMF_CPRC_TGTPARAM', nvl(TO_CHAR(pi_organization_id_to), ' '), nvl(pi_calendar_code_to, ' '), nvl(pi_period_code_to, ' '), nvl(TO_CHAR(pi_cost_type_id_to), ' '));
117:
118: IF ((pi_period_code_to IS NULL) AND ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))) THEN
119: gmf_util.msg_log('GMF_CPRC_PERIODS_RANGE', nvl(pi_all_periods_from, ' '), nvl(pi_all_periods_to, ' '), nvl(pi_calendar_code_to, ' ')) ;
120: END IF ;
121:
122: l_ins_rows := 0;
123: l_upd_rows := 0;

Line 139: gmf_util.msg_log ('GMF_CP_NO_ROWS');

135: l_period_id_from := NULL;
136: END;
137:
138: IF (l_period_id_from IS NULL) THEN
139: gmf_util.msg_log ('GMF_CP_NO_ROWS');
140: RAISE e_no_cost_rows;
141: END IF;
142: IF (pi_period_code_to IS NOT NULL) THEN
143: BEGIN

Line 157: gmf_util.msg_log ('GMF_CP_NO_ROWS');

153: pi_period_id_to := NULL;
154: END;
155:
156: IF (pi_period_id_to IS NULL) THEN
157: gmf_util.msg_log ('GMF_CP_NO_ROWS');
158: RAISE e_no_cost_rows;
159: END IF;
160: END IF;
161:

Line 166: gmf_util.msg_log ('GMF_CP_NO_ROWS');

162: --jboppana has to uncomment after testing
163: --l_num_src_rows := do_costs_exist( pi_organization_id_from, l_period_id_from, pi_resource_class);
164:
165: IF (l_num_src_rows <= 0) THEN
166: gmf_util.msg_log ('GMF_CP_NO_ROWS');
167: RAISE e_no_cost_rows;
168: END IF;
169:
170: l_sql_rsrc := '' ;

Line 195: gmf_util.trace( 'Resource Query : ' || l_sql_rsrc, 1 ) ;

191: END IF ;
192:
193: l_sql_rsrc := l_sql_rsrc || ' ORDER BY ' || ' d.resources' ;
194:
195: gmf_util.trace( 'Resource Query : ' || l_sql_rsrc, 1 ) ;
196:
197: /**************************************************************************
198: * Build SQL to get target Orgs when from/to orgns are not null. *
199: * IF (pi_all_orgn_from IS NOT NULL) AND (pi_all_orgn_to IS NOT NULL) THEN *

Line 260: gmf_util.trace( 'Periods Query : ' || l_sql_periods, 1 ) ;

256: END IF ;
257:
258: END IF;
259:
260: gmf_util.trace( 'Periods Query : ' || l_sql_periods, 1 ) ;
261: gmf_util.trace( 'Orgn Query : ' || l_sql_orgn, 1 ) ;
262:
263: /*********************************************************************************
264: * Do not pass the l_from_range and l_to_range if resource class is not specified *

Line 261: gmf_util.trace( 'Orgn Query : ' || l_sql_orgn, 1 ) ;

257:
258: END IF;
259:
260: gmf_util.trace( 'Periods Query : ' || l_sql_periods, 1 ) ;
261: gmf_util.trace( 'Orgn Query : ' || l_sql_orgn, 1 ) ;
262:
263: /*********************************************************************************
264: * Do not pass the l_from_range and l_to_range if resource class is not specified *
265: *********************************************************************************/

Line 311: gmf_util.trace( 'Values : ' || rec_rsrc_dtl.resources || ' - ' || rec_rsrc_dtl.usage_uom || ' - ' || to_char(rec_rsrc_dtl.nominal_cost), 1 );

307:
308: FETCH cv_orgn INTO l_organization_id_to ;
309: EXIT WHEN cv_orgn%NOTFOUND ;
310:
311: gmf_util.trace( 'Values : ' || rec_rsrc_dtl.resources || ' - ' || rec_rsrc_dtl.usage_uom || ' - ' || to_char(rec_rsrc_dtl.nominal_cost), 1 );
312: gmf_util.msg_log('GMF_CPRC_ORGPRD', nvl(TO_CHAR(l_organization_id_to), ' '), nvl(TO_CHAR(l_period_id_to),' '));
313:
314: UPDATE cm_rsrc_dtl
315: SET usage_uom = rec_rsrc_dtl.usage_uom,

Line 312: gmf_util.msg_log('GMF_CPRC_ORGPRD', nvl(TO_CHAR(l_organization_id_to), ' '), nvl(TO_CHAR(l_period_id_to),' '));

308: FETCH cv_orgn INTO l_organization_id_to ;
309: EXIT WHEN cv_orgn%NOTFOUND ;
310:
311: gmf_util.trace( 'Values : ' || rec_rsrc_dtl.resources || ' - ' || rec_rsrc_dtl.usage_uom || ' - ' || to_char(rec_rsrc_dtl.nominal_cost), 1 );
312: gmf_util.msg_log('GMF_CPRC_ORGPRD', nvl(TO_CHAR(l_organization_id_to), ' '), nvl(TO_CHAR(l_period_id_to),' '));
313:
314: UPDATE cm_rsrc_dtl
315: SET usage_uom = rec_rsrc_dtl.usage_uom,
316: nominal_cost = rec_rsrc_dtl.nominal_cost,

Line 330: gmf_util.trace( 'Updated ' || TO_CHAR(SQL%ROWCOUNT) || ' rows', 1 );

326:
327: IF SQL%ROWCOUNT > 0 THEN
328:
329: l_upd_rows := l_upd_rows + SQL%ROWCOUNT;
330: gmf_util.trace( 'Updated ' || TO_CHAR(SQL%ROWCOUNT) || ' rows', 1 );
331:
332: ELSE
333:
334: INSERT INTO cm_rsrc_dtl

Line 370: gmf_util.trace( 'Inserted ' || TO_CHAR(SQL%ROWCOUNT) || ' rows', 1 );

366: 0
367: );
368:
369: l_ins_rows := l_ins_rows + SQL%ROWCOUNT;
370: gmf_util.trace( 'Inserted ' || TO_CHAR(SQL%ROWCOUNT) || ' rows', 1 );
371:
372: END IF;
373: END LOOP; -- end of cursor for loop for Orgs
374: END LOOP; -- end of cursor for loop for periods

Line 377: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_ins_rows + l_upd_rows) );

373: END LOOP; -- end of cursor for loop for Orgs
374: END LOOP; -- end of cursor for loop for periods
375: END LOOP; -- end of cursor for loop for resources
376:
377: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_ins_rows + l_upd_rows) );
378: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS', TO_CHAR(l_upd_rows), TO_CHAR(l_ins_rows) );
379: gmf_util.log;
380: gmf_util.msg_log( 'GMF_CPRC_END' );
381:

Line 378: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS', TO_CHAR(l_upd_rows), TO_CHAR(l_ins_rows) );

374: END LOOP; -- end of cursor for loop for periods
375: END LOOP; -- end of cursor for loop for resources
376:
377: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_ins_rows + l_upd_rows) );
378: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS', TO_CHAR(l_upd_rows), TO_CHAR(l_ins_rows) );
379: gmf_util.log;
380: gmf_util.msg_log( 'GMF_CPRC_END' );
381:
382: po_retcode := 0;

Line 379: gmf_util.log;

375: END LOOP; -- end of cursor for loop for resources
376:
377: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_ins_rows + l_upd_rows) );
378: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS', TO_CHAR(l_upd_rows), TO_CHAR(l_ins_rows) );
379: gmf_util.log;
380: gmf_util.msg_log( 'GMF_CPRC_END' );
381:
382: po_retcode := 0;
383: po_errbuf := NULL;

Line 380: gmf_util.msg_log( 'GMF_CPRC_END' );

376:
377: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_ins_rows + l_upd_rows) );
378: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS', TO_CHAR(l_upd_rows), TO_CHAR(l_ins_rows) );
379: gmf_util.log;
380: gmf_util.msg_log( 'GMF_CPRC_END' );
381:
382: po_retcode := 0;
383: po_errbuf := NULL;
384: end_copy('NORMAL', NULL);