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_PERCENTAGE_BURDEN dependencies on GMF_UTIL

Line 149: gmf_util.msg_log( 'GMF_CPPB_START' );

145:
146: ----FND_FILE.PUT_NAMES('gmfcppb.log','gmfcppb.out','/sqlcom/log/dom1151');
147:
148:
149: gmf_util.msg_log( 'GMF_CPPB_START' );
150: gmf_util.msg_log( 'GMF_CPPB_SRCPARAM', nvl(pi_calendar_code_from, ' '), nvl(pi_period_code_from, ' '), nvl(TO_CHAR(pi_cost_type_id_from), ' '));
151: gmf_util.msg_log( 'GMF_CPPB_TGTPARAM', nvl(pi_calendar_code_to, ' '), nvl(pi_period_code_to, ' '), nvl(TO_CHAR(pi_cost_type_id_to), ' '));
152: gmf_util.msg_log( 'GMF_CPPB_BRDNRANGE', nvl(pi_burden_code_from, ' '), nvl(pi_burden_code_to, ' '));
153:

Line 150: gmf_util.msg_log( 'GMF_CPPB_SRCPARAM', nvl(pi_calendar_code_from, ' '), nvl(pi_period_code_from, ' '), nvl(TO_CHAR(pi_cost_type_id_from), ' '));

146: ----FND_FILE.PUT_NAMES('gmfcppb.log','gmfcppb.out','/sqlcom/log/dom1151');
147:
148:
149: gmf_util.msg_log( 'GMF_CPPB_START' );
150: gmf_util.msg_log( 'GMF_CPPB_SRCPARAM', nvl(pi_calendar_code_from, ' '), nvl(pi_period_code_from, ' '), nvl(TO_CHAR(pi_cost_type_id_from), ' '));
151: gmf_util.msg_log( 'GMF_CPPB_TGTPARAM', nvl(pi_calendar_code_to, ' '), nvl(pi_period_code_to, ' '), nvl(TO_CHAR(pi_cost_type_id_to), ' '));
152: gmf_util.msg_log( 'GMF_CPPB_BRDNRANGE', nvl(pi_burden_code_from, ' '), nvl(pi_burden_code_to, ' '));
153:
154: 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 151: gmf_util.msg_log( 'GMF_CPPB_TGTPARAM', nvl(pi_calendar_code_to, ' '), nvl(pi_period_code_to, ' '), nvl(TO_CHAR(pi_cost_type_id_to), ' '));

147:
148:
149: gmf_util.msg_log( 'GMF_CPPB_START' );
150: gmf_util.msg_log( 'GMF_CPPB_SRCPARAM', nvl(pi_calendar_code_from, ' '), nvl(pi_period_code_from, ' '), nvl(TO_CHAR(pi_cost_type_id_from), ' '));
151: gmf_util.msg_log( 'GMF_CPPB_TGTPARAM', nvl(pi_calendar_code_to, ' '), nvl(pi_period_code_to, ' '), nvl(TO_CHAR(pi_cost_type_id_to), ' '));
152: gmf_util.msg_log( 'GMF_CPPB_BRDNRANGE', nvl(pi_burden_code_from, ' '), nvl(pi_burden_code_to, ' '));
153:
154: IF ( (pi_period_code_to IS NULL) AND ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))) THEN
155:

Line 152: gmf_util.msg_log( 'GMF_CPPB_BRDNRANGE', nvl(pi_burden_code_from, ' '), nvl(pi_burden_code_to, ' '));

148:
149: gmf_util.msg_log( 'GMF_CPPB_START' );
150: gmf_util.msg_log( 'GMF_CPPB_SRCPARAM', nvl(pi_calendar_code_from, ' '), nvl(pi_period_code_from, ' '), nvl(TO_CHAR(pi_cost_type_id_from), ' '));
151: gmf_util.msg_log( 'GMF_CPPB_TGTPARAM', nvl(pi_calendar_code_to, ' '), nvl(pi_period_code_to, ' '), nvl(TO_CHAR(pi_cost_type_id_to), ' '));
152: gmf_util.msg_log( 'GMF_CPPB_BRDNRANGE', nvl(pi_burden_code_from, ' '), nvl(pi_burden_code_to, ' '));
153:
154: IF ( (pi_period_code_to IS NULL) AND ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))) THEN
155:
156: gmf_util.msg_log('GMF_CPIC_ALLPERIODS', nvl(pi_calendar_code_to, ' ')) ;

Line 156: gmf_util.msg_log('GMF_CPIC_ALLPERIODS', nvl(pi_calendar_code_to, ' ')) ;

152: gmf_util.msg_log( 'GMF_CPPB_BRDNRANGE', nvl(pi_burden_code_from, ' '), nvl(pi_burden_code_to, ' '));
153:
154: IF ( (pi_period_code_to IS NULL) AND ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))) THEN
155:
156: gmf_util.msg_log('GMF_CPIC_ALLPERIODS', nvl(pi_calendar_code_to, ' ')) ;
157: gmf_util.msg_log('GMF_CPIC_PERIODS_RANGE', nvl(pi_all_periods_from, ' '),nvl(pi_all_periods_to, ' '), nvl(pi_calendar_code_to, ' '));
158:
159: END IF ;
160:

Line 157: gmf_util.msg_log('GMF_CPIC_PERIODS_RANGE', nvl(pi_all_periods_from, ' '),nvl(pi_all_periods_to, ' '), nvl(pi_calendar_code_to, ' '));

153:
154: IF ( (pi_period_code_to IS NULL) AND ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))) THEN
155:
156: gmf_util.msg_log('GMF_CPIC_ALLPERIODS', nvl(pi_calendar_code_to, ' ')) ;
157: gmf_util.msg_log('GMF_CPIC_PERIODS_RANGE', nvl(pi_all_periods_from, ' '),nvl(pi_all_periods_to, ' '), nvl(pi_calendar_code_to, ' '));
158:
159: END IF ;
160:
161: l_rem_repl := 0;

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

162:
163: IF ( pi_rem_repl = '1' ) THEN --Remove Before Copy
164:
165: l_rem_repl := 1;
166: gmf_util.msg_log( 'GMF_CPIC_OPTREM' );
167:
168: ELSE -- Replace before copy
169:
170: l_rem_repl := 0;

Line 171: gmf_util.msg_log( 'GMF_CPIC_OPTREP' );

167:
168: ELSE -- Replace before copy
169:
170: l_rem_repl := 0;
171: gmf_util.msg_log( 'GMF_CPIC_OPTREP' );
172:
173: END IF;
174:
175: gmf_util.log;

Line 175: gmf_util.log;

171: gmf_util.msg_log( 'GMF_CPIC_OPTREP' );
172:
173: END IF;
174:
175: gmf_util.log;
176:
177: l_from_range := NULL;
178: l_to_range := NULL;
179:

Line 187: gmf_util.msg_log( 'GMF_CPPB_NO_BRDN_RANGE' );

183: l_to_range := pi_burden_code_to;
184:
185: ELSE
186:
187: gmf_util.msg_log( 'GMF_CPPB_NO_BRDN_RANGE' );
188: RAISE e_no_brdn_range;
189:
190: END IF;
191:

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

202: l_period_id_from := NULL;
203: END;
204:
205: IF l_period_id_from IS NULL THEN
206: gmf_util.msg_log( 'GMF_CP_NO_ROWS' );
207: RAISE e_no_cost_rows;
208: END IF;
209:
210: l_num_src_rows := do_pct_exist( pi_legal_entity_id_from, l_period_id_from, pi_cost_type_id_from, pi_burden_code_from, pi_burden_code_to);

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

210: l_num_src_rows := do_pct_exist( pi_legal_entity_id_from, l_period_id_from, pi_cost_type_id_from, pi_burden_code_from, pi_burden_code_to);
211:
212: IF ( l_num_src_rows <= 0 ) THEN
213:
214: gmf_util.msg_log( 'GMF_CP_NO_ROWS' );
215: RAISE e_no_cost_rows;
216:
217: END IF;
218:

Line 219: gmf_util.trace( 'Burden Codes Range : ' || l_from_range || ' - ' || l_to_range, 1 );

215: RAISE e_no_cost_rows;
216:
217: END IF;
218:
219: gmf_util.trace( 'Burden Codes Range : ' || l_from_range || ' - ' || l_to_range, 1 );
220:
221: /*************************
222: * Initialize WHO columns *
223: *************************/

Line 234: gmf_util.msg_log( 'GMF_CPPB_SAME_FROMTO' );

230: **************************************************************/
231:
232: IF ((pi_period_code_from = pi_period_code_to) AND (pi_cost_type_id_from = pi_cost_type_id_to) AND (pi_calendar_code_from = pi_calendar_code_to)) THEN
233:
234: gmf_util.msg_log( 'GMF_CPPB_SAME_FROMTO' );
235: RAISE e_same_from_to;
236:
237: ELSE
238:

Line 263: gmf_util.log;

259: po_errbuf := NULL;
260: end_copy( 'NORMAL', NULL );
261: COMMIT;
262:
263: gmf_util.log;
264: gmf_util.msg_log( 'GMF_CPPB_END' );
265:
266: EXCEPTION
267: WHEN e_no_cost_rows THEN

Line 264: gmf_util.msg_log( 'GMF_CPPB_END' );

260: end_copy( 'NORMAL', NULL );
261: COMMIT;
262:
263: gmf_util.log;
264: gmf_util.msg_log( 'GMF_CPPB_END' );
265:
266: EXCEPTION
267: WHEN e_no_cost_rows THEN
268: po_retcode := 0;

Line 432: gmf_util.trace( 'Burden Percentages Sql Stmt: ' || l_sql_stmt, 1 );

428: ' bur.burden_code <= nvl(:b_to_brdn,bur.burden_code) '||
429: ' ORDER BY ' ||
430: ' pct.legal_entity_id, pct.period_id, pct.cost_type_id, pct.burden_id';
431:
432: gmf_util.trace( 'Burden Percentages Sql Stmt: ' || l_sql_stmt, 1 );
433:
434: /*********************************************************************
435: * Build SQL to get target periods when From/To Periods are not null. *
436: *********************************************************************/

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

480: WHEN OTHERS THEN
481: pi_period_id_from := NULL;
482: END;
483:
484: gmf_util.trace( 'Periods Query : ' || l_sql_periods, 1 );
485:
486: IF (pi_period_code_to IS NOT NULL) THEN
487:
488: BEGIN

Line 549: gmf_util.log;

545: LOOP
546:
547: FETCH cv_brdn_pct INTO r_brdn_pct;
548: EXIT WHEN cv_brdn_pct%NOTFOUND;
549: gmf_util.log;
550: gmf_util.msg_log('GMF_CPPB_PERIOD_BRDN', r_brdn_pct.burden_code, to_char(l_period_id_to)) ;
551: gmf_util.trace( 'Burden : ' || r_brdn_pct.burden_code || ' Prd Id: ' || TO_CHAR(r_brdn_pct.period_id) || ' Cost Type: ' || TO_CHAR(r_brdn_pct.cost_type_id) ||
552: ' Organization Id: ' || nvl(TO_CHAR(r_brdn_pct.organization_id),'') || ' Item Id: ' || nvl(TO_CHAR(r_brdn_pct.inventory_item_id),'') || ' GL Class: ' ||
553: nvl(r_brdn_pct.gl_category_id,'') || ' ItemCC: ' || nvl(r_brdn_pct.cost_category_id,''), 3 );

Line 550: gmf_util.msg_log('GMF_CPPB_PERIOD_BRDN', r_brdn_pct.burden_code, to_char(l_period_id_to)) ;

546:
547: FETCH cv_brdn_pct INTO r_brdn_pct;
548: EXIT WHEN cv_brdn_pct%NOTFOUND;
549: gmf_util.log;
550: gmf_util.msg_log('GMF_CPPB_PERIOD_BRDN', r_brdn_pct.burden_code, to_char(l_period_id_to)) ;
551: gmf_util.trace( 'Burden : ' || r_brdn_pct.burden_code || ' Prd Id: ' || TO_CHAR(r_brdn_pct.period_id) || ' Cost Type: ' || TO_CHAR(r_brdn_pct.cost_type_id) ||
552: ' Organization Id: ' || nvl(TO_CHAR(r_brdn_pct.organization_id),'') || ' Item Id: ' || nvl(TO_CHAR(r_brdn_pct.inventory_item_id),'') || ' GL Class: ' ||
553: nvl(r_brdn_pct.gl_category_id,'') || ' ItemCC: ' || nvl(r_brdn_pct.cost_category_id,''), 3 );
554: l_brdn_rows := l_brdn_rows + 1;

Line 551: gmf_util.trace( 'Burden : ' || r_brdn_pct.burden_code || ' Prd Id: ' || TO_CHAR(r_brdn_pct.period_id) || ' Cost Type: ' || TO_CHAR(r_brdn_pct.cost_type_id) ||

547: FETCH cv_brdn_pct INTO r_brdn_pct;
548: EXIT WHEN cv_brdn_pct%NOTFOUND;
549: gmf_util.log;
550: gmf_util.msg_log('GMF_CPPB_PERIOD_BRDN', r_brdn_pct.burden_code, to_char(l_period_id_to)) ;
551: gmf_util.trace( 'Burden : ' || r_brdn_pct.burden_code || ' Prd Id: ' || TO_CHAR(r_brdn_pct.period_id) || ' Cost Type: ' || TO_CHAR(r_brdn_pct.cost_type_id) ||
552: ' Organization Id: ' || nvl(TO_CHAR(r_brdn_pct.organization_id),'') || ' Item Id: ' || nvl(TO_CHAR(r_brdn_pct.inventory_item_id),'') || ' GL Class: ' ||
553: nvl(r_brdn_pct.gl_category_id,'') || ' ItemCC: ' || nvl(r_brdn_pct.cost_category_id,''), 3 );
554: l_brdn_rows := l_brdn_rows + 1;
555:

Line 657: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_brdn_rows) );

653: CLOSE cv_brdn_pct;
654:
655: IF( l_brdn_rows > 0 ) THEN
656:
657: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_brdn_rows) );
658: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS',TO_CHAR(l_brdn_rows_upd), TO_CHAR(l_brdn_rows_ins));
659:
660: ELSE
661:

Line 658: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS',TO_CHAR(l_brdn_rows_upd), TO_CHAR(l_brdn_rows_ins));

654:
655: IF( l_brdn_rows > 0 ) THEN
656:
657: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_brdn_rows) );
658: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS',TO_CHAR(l_brdn_rows_upd), TO_CHAR(l_brdn_rows_ins));
659:
660: ELSE
661:
662: gmf_util.msg_log( 'GMF_CP_NO_ROWS' );

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

658: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS',TO_CHAR(l_brdn_rows_upd), TO_CHAR(l_brdn_rows_ins));
659:
660: ELSE
661:
662: gmf_util.msg_log( 'GMF_CP_NO_ROWS' );
663:
664: END IF;
665:
666: END LOOP ; -- periods loop

Line 726: gmf_util.trace( ' Burden Del Stmt: ' || l_del_stmt, 1 );

722: ' bur.burden_code <= nvl(:b_burden_code_to,bur.burden_code) ' ;
723:
724: l_del_stmt := l_del_stmt || l_sub_qry || ' ) ' ;
725:
726: gmf_util.trace( ' Burden Del Stmt: ' || l_del_stmt, 1 );
727:
728: EXECUTE IMMEDIATE l_del_stmt USING pi_legal_entity_id, pi_period_id, pi_cost_type_id, pi_from_range, pi_to_range;
729:
730: gmf_util.trace( SQL%ROWCOUNT || ' Rows deleted', 1 );

Line 730: gmf_util.trace( SQL%ROWCOUNT || ' Rows deleted', 1 );

726: gmf_util.trace( ' Burden Del Stmt: ' || l_del_stmt, 1 );
727:
728: EXECUTE IMMEDIATE l_del_stmt USING pi_legal_entity_id, pi_period_id, pi_cost_type_id, pi_from_range, pi_to_range;
729:
730: gmf_util.trace( SQL%ROWCOUNT || ' Rows deleted', 1 );
731:
732: END delete_burden_pct;
733:
734: /************************************************************************************