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

Line 228: gmf_util.msg_log( 'GMF_CPIC_START' );

224: /* uncomment the call below to write to a local file */
225: FND_FILE.PUT_NAMES('gmfcpic.log','gmfcpic.out','/appslog/opm_top/utl/opmm0dv/log');
226:
227:
228: gmf_util.msg_log( 'GMF_CPIC_START' );
229:
230: gmf_util.msg_log( 'GMF_CPIC_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), ' ') );
231:
232: gmf_util.msg_log( 'GMF_CPIC_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), ' ') );

Line 230: gmf_util.msg_log( 'GMF_CPIC_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), ' ') );

226:
227:
228: gmf_util.msg_log( 'GMF_CPIC_START' );
229:
230: gmf_util.msg_log( 'GMF_CPIC_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), ' ') );
231:
232: gmf_util.msg_log( 'GMF_CPIC_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), ' ') );
233:
234: gmf_util.msg_log( 'GMF_CPIC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );

Line 232: gmf_util.msg_log( 'GMF_CPIC_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), ' ') );

228: gmf_util.msg_log( 'GMF_CPIC_START' );
229:
230: gmf_util.msg_log( 'GMF_CPIC_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), ' ') );
231:
232: gmf_util.msg_log( 'GMF_CPIC_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), ' ') );
233:
234: gmf_util.msg_log( 'GMF_CPIC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );
235: gmf_util.msg_log( 'GMF_CPIC_ITEMCCRANGE', nvl(pi_itemcc_from, ' '), nvl(pi_itemcc_to, ' ') );
236:

Line 234: gmf_util.msg_log( 'GMF_CPIC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );

230: gmf_util.msg_log( 'GMF_CPIC_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), ' ') );
231:
232: gmf_util.msg_log( 'GMF_CPIC_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), ' ') );
233:
234: gmf_util.msg_log( 'GMF_CPIC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );
235: gmf_util.msg_log( 'GMF_CPIC_ITEMCCRANGE', nvl(pi_itemcc_from, ' '), nvl(pi_itemcc_to, ' ') );
236:
237: gmf_util.msg_log( 'GMF_CPIC_INCPCT', nvl(pi_incr_pct, ' ') );
238: gmf_util.msg_log( 'GMF_CPIC_INCCOST', nvl(pi_incr_decr_cost, ' ') );

Line 235: gmf_util.msg_log( 'GMF_CPIC_ITEMCCRANGE', nvl(pi_itemcc_from, ' '), nvl(pi_itemcc_to, ' ') );

231:
232: gmf_util.msg_log( 'GMF_CPIC_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), ' ') );
233:
234: gmf_util.msg_log( 'GMF_CPIC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );
235: gmf_util.msg_log( 'GMF_CPIC_ITEMCCRANGE', nvl(pi_itemcc_from, ' '), nvl(pi_itemcc_to, ' ') );
236:
237: gmf_util.msg_log( 'GMF_CPIC_INCPCT', nvl(pi_incr_pct, ' ') );
238: gmf_util.msg_log( 'GMF_CPIC_INCCOST', nvl(pi_incr_decr_cost, ' ') );
239:

Line 237: gmf_util.msg_log( 'GMF_CPIC_INCPCT', nvl(pi_incr_pct, ' ') );

233:
234: gmf_util.msg_log( 'GMF_CPIC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );
235: gmf_util.msg_log( 'GMF_CPIC_ITEMCCRANGE', nvl(pi_itemcc_from, ' '), nvl(pi_itemcc_to, ' ') );
236:
237: gmf_util.msg_log( 'GMF_CPIC_INCPCT', nvl(pi_incr_pct, ' ') );
238: gmf_util.msg_log( 'GMF_CPIC_INCCOST', nvl(pi_incr_decr_cost, ' ') );
239:
240: -- Bug# 1419482 Copy Cost Enhancement. Uday Moogala
241: IF ( (pi_period_code_to IS NULL) AND -- all periods

Line 238: gmf_util.msg_log( 'GMF_CPIC_INCCOST', nvl(pi_incr_decr_cost, ' ') );

234: gmf_util.msg_log( 'GMF_CPIC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );
235: gmf_util.msg_log( 'GMF_CPIC_ITEMCCRANGE', nvl(pi_itemcc_from, ' '), nvl(pi_itemcc_to, ' ') );
236:
237: gmf_util.msg_log( 'GMF_CPIC_INCPCT', nvl(pi_incr_pct, ' ') );
238: gmf_util.msg_log( 'GMF_CPIC_INCCOST', nvl(pi_incr_decr_cost, ' ') );
239:
240: -- Bug# 1419482 Copy Cost Enhancement. Uday Moogala
241: IF ( (pi_period_code_to IS NULL) AND -- all periods
242: ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))

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

241: IF ( (pi_period_code_to IS NULL) AND -- all periods
242: ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))
243: ) THEN
244:
245: gmf_util.msg_log('GMF_CPIC_ALLPERIODS', nvl(pi_calendar_code_to, ' ') ) ;
246: gmf_util.msg_log('GMF_CPIC_PERIODS_RANGE', nvl(pi_all_periods_from, ' '),
247: nvl(pi_all_periods_to, ' '), nvl(pi_calendar_code_to, ' ') ) ;
248: END IF ;
249:

Line 246: gmf_util.msg_log('GMF_CPIC_PERIODS_RANGE', nvl(pi_all_periods_from, ' '),

242: ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))
243: ) THEN
244:
245: gmf_util.msg_log('GMF_CPIC_ALLPERIODS', nvl(pi_calendar_code_to, ' ') ) ;
246: gmf_util.msg_log('GMF_CPIC_PERIODS_RANGE', nvl(pi_all_periods_from, ' '),
247: nvl(pi_all_periods_to, ' '), nvl(pi_calendar_code_to, ' ') ) ;
248: END IF ;
249:
250: -- End Bug# 1419482

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

251:
252: l_rem_repl := 0;
253: IF ( pi_rem_repl = '1' ) THEN -- Remove before copy
254: l_rem_repl := 1;
255: gmf_util.msg_log( 'GMF_CPIC_OPTREM' );
256: ELSE -- Replace before copy
257: l_rem_repl := 0;
258: gmf_util.msg_log( 'GMF_CPIC_OPTREP' );
259: END IF;

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

254: l_rem_repl := 1;
255: gmf_util.msg_log( 'GMF_CPIC_OPTREM' );
256: ELSE -- Replace before copy
257: l_rem_repl := 0;
258: gmf_util.msg_log( 'GMF_CPIC_OPTREP' );
259: END IF;
260:
261: -- B2198228
262: l_copy_to_upper_lvl := 0;

Line 266: gmf_util.msg_log( 'GMF_CPIC_TO_UPPER_YES' );

262: l_copy_to_upper_lvl := 0;
263: IF ( pi_copy_to_upper_lvl = '1' ) THEN
264: -- Copy lower level cost from source to upper level at target
265: l_copy_to_upper_lvl := 1;
266: gmf_util.msg_log( 'GMF_CPIC_TO_UPPER_YES' );
267: ELSE
268: l_copy_to_upper_lvl := 0;
269: gmf_util.msg_log( 'GMF_CPIC_TO_UPPER_NO' );
270: END IF;

Line 269: gmf_util.msg_log( 'GMF_CPIC_TO_UPPER_NO' );

265: l_copy_to_upper_lvl := 1;
266: gmf_util.msg_log( 'GMF_CPIC_TO_UPPER_YES' );
267: ELSE
268: l_copy_to_upper_lvl := 0;
269: gmf_util.msg_log( 'GMF_CPIC_TO_UPPER_NO' );
270: END IF;
271:
272: gmf_util.log;
273:

Line 272: gmf_util.log;

268: l_copy_to_upper_lvl := 0;
269: gmf_util.msg_log( 'GMF_CPIC_TO_UPPER_NO' );
270: END IF;
271:
272: gmf_util.log;
273:
274: IF ( (pi_period_code_from = pi_period_code_to) AND
275: (pi_cost_type_id_from = pi_cost_type_id_to) AND
276: (pi_calendar_code_from = pi_calendar_code_to) AND

Line 279: gmf_util.msg_log( 'GMF_CP_SAME_FROMTO' );

275: (pi_cost_type_id_from = pi_cost_type_id_to) AND
276: (pi_calendar_code_from = pi_calendar_code_to) AND
277: (pi_organization_id_from = pi_organization_id_to) ) THEN
278:
279: gmf_util.msg_log( 'GMF_CP_SAME_FROMTO' );
280: RAISE e_same_from_to;
281: END IF;
282:
283: -- Determine what kind of where clause needs to be concatenated

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

289: IF ( (pi_item_from IS NOT NULL) OR (pi_item_to IS NOT NULL) ) THEN
290: l_from_range := pi_item_from;
291: l_to_range := pi_item_to;
292: l_range_type := G_ITEM;
293: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 1 );
294: ELSIF ( (pi_itemcc_from IS NOT NULL) OR (pi_itemcc_to IS NOT NULL) ) THEN
295: l_from_range := pi_itemcc_from;
296: l_to_range := pi_itemcc_to;
297: l_range_type := G_ITEMCC;

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

294: ELSIF ( (pi_itemcc_from IS NOT NULL) OR (pi_itemcc_to IS NOT NULL) ) THEN
295: l_from_range := pi_itemcc_from;
296: l_to_range := pi_itemcc_to;
297: l_range_type := G_ITEMCC;
298: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 1 );
299: ELSE
300: l_from_range := pi_item_from;
301: l_to_range := pi_item_to;
302: l_range_type := G_ITEM;

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

299: ELSE
300: l_from_range := pi_item_from;
301: l_to_range := pi_item_to;
302: l_range_type := G_ITEM;
303: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 1 );
304: END IF;
305:
306: -- Set the increase or decrease percentage and cost
307:

Line 308: gmf_util.trace( 'NLS CHAR : '|| l_dec_separator, 1 );

304: END IF;
305:
306: -- Set the increase or decrease percentage and cost
307:
308: gmf_util.trace( 'NLS CHAR : '|| l_dec_separator, 1 );
309:
310: gmf_util.trace( 'pi_incr_pct : '|| (TO_NUMBER(pi_incr_pct,'9G999D999999999', ' NLS_NUMERIC_CHARACTERS = '|| l_dec_separator)/100), 1 );
311:
312: IF( pi_incr_pct IS NOT NULL ) THEN

Line 310: gmf_util.trace( 'pi_incr_pct : '|| (TO_NUMBER(pi_incr_pct,'9G999D999999999', ' NLS_NUMERIC_CHARACTERS = '|| l_dec_separator)/100), 1 );

306: -- Set the increase or decrease percentage and cost
307:
308: gmf_util.trace( 'NLS CHAR : '|| l_dec_separator, 1 );
309:
310: gmf_util.trace( 'pi_incr_pct : '|| (TO_NUMBER(pi_incr_pct,'9G999D999999999', ' NLS_NUMERIC_CHARACTERS = '|| l_dec_separator)/100), 1 );
311:
312: IF( pi_incr_pct IS NOT NULL ) THEN
313: l_incr_pct := 1 + (TO_NUMBER(pi_incr_pct,'9G999D999999999', ' NLS_NUMERIC_CHARACTERS = '|| l_dec_separator)/100) ;
314: ELSE

Line 325: gmf_util.trace( ' Incr pct = ' || l_incr_pct || ' Incr/Decr Cost = ' ||l_incr_decr_cost, 1 );

321: ELSE
322: l_incr_decr_cost := 0;
323: END IF;
324:
325: gmf_util.trace( ' Incr pct = ' || l_incr_pct || ' Incr/Decr Cost = ' ||l_incr_decr_cost, 1 );
326:
327: -- Bug# 1419482 Copy Cost Enhancement. Uday Moogala
328:
329: BEGIN

Line 334: gmf_util.msg_log('GMF_CPIC_EFFID', l_effid_copy ) ; --niyadav

330: g_effid_copy := FND_PROFILE.VALUE('GMF_CPIC_EFF') ;
331: SELECT decode(g_effid_copy, 'Y', 'YES', 'N', 'NO', '')
332: INTO l_effid_copy
333: FROM dual ;
334: gmf_util.msg_log('GMF_CPIC_EFFID', l_effid_copy ) ; --niyadav
335:
336: EXCEPTION
337: WHEN OTHERS THEN
338: l_effid_copy := 'N' ;

Line 339: gmf_util.msg_log('GMF_CPIC_EFFID', l_effid_copy) ;

335:
336: EXCEPTION
337: WHEN OTHERS THEN
338: l_effid_copy := 'N' ;
339: gmf_util.msg_log('GMF_CPIC_EFFID', l_effid_copy) ;
340: END ;
341:
342: -- End Bug# 1419482
343:

Line 365: gmf_util.log;

361: po_errbuf := NULL;
362: end_copy( 'NORMAL', NULL );
363: COMMIT;
364:
365: gmf_util.log;
366: gmf_util.msg_log( 'GMF_CPIC_END' );
367:
368: EXCEPTION
369: WHEN e_no_cost_rows THEN

Line 366: gmf_util.msg_log( 'GMF_CPIC_END' );

362: end_copy( 'NORMAL', NULL );
363: COMMIT;
364:
365: gmf_util.log;
366: gmf_util.msg_log( 'GMF_CPIC_END' );
367:
368: EXCEPTION
369: WHEN e_no_cost_rows THEN
370: po_retcode := 0;

Line 718: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 0 );

714: 'cst.cost_analysis_code, ' ||
715: 'cst.cost_level ' ;
716:
717:
718: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 0 );
719:
720: gmf_util.trace( 'Item details Query : ' || l_sql_stmt, 3 );
721:
722:

Line 720: gmf_util.trace( 'Item details Query : ' || l_sql_stmt, 3 );

716:
717:
718: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 0 );
719:
720: gmf_util.trace( 'Item details Query : ' || l_sql_stmt, 3 );
721:
722:
723: -- get org_id for the target calendar
724:

Line 832: gmf_util.trace( 'Org Query : ' || l_sql_org, 3 );

828: l_sql_periods := l_sql_periods || ' ORDER BY c3.start_date' ;
829:
830: END IF ; -- To Period code check
831:
832: gmf_util.trace( 'Org Query : ' || l_sql_org, 3 );
833: gmf_util.trace( 'Periods Query : ' || l_sql_periods, 3 );
834:
835: IF (pi_period_id_to IS NOT NULL) THEN
836: OPEN cv_periods FOR l_sql_periods

Line 833: gmf_util.trace( 'Periods Query : ' || l_sql_periods, 3 );

829:
830: END IF ; -- To Period code check
831:
832: gmf_util.trace( 'Org Query : ' || l_sql_org, 3 );
833: gmf_util.trace( 'Periods Query : ' || l_sql_periods, 3 );
834:
835: IF (pi_period_id_to IS NOT NULL) THEN
836: OPEN cv_periods FOR l_sql_periods
837: USING pi_period_id_to;

Line 911: gmf_util.log;

907:
908: FETCH cv_org INTO l_organization_id_to ;
909: EXIT WHEN cv_org%NOTFOUND ;
910:
911: gmf_util.log;
912: gmf_util.msg_log('GMF_CPIC_ALLWHSEPRD', l_organization_id_to,l_period_id_to) ;
913:
914: -- End Bug# 1419482
915:

Line 912: gmf_util.msg_log('GMF_CPIC_ALLWHSEPRD', l_organization_id_to,l_period_id_to) ;

908: FETCH cv_org INTO l_organization_id_to ;
909: EXIT WHEN cv_org%NOTFOUND ;
910:
911: gmf_util.log;
912: gmf_util.msg_log('GMF_CPIC_ALLWHSEPRD', l_organization_id_to,l_period_id_to) ;
913:
914: -- End Bug# 1419482
915:
916: l_curr_inventory_item_id := -1;

Line 955: gmf_util.trace('item id and costcomp id...'|| r_cost_detail.inventory_item_id || '-' || r_cost_detail.cmpntcost_id,0) ;

951: */
952:
953: -- Bug# 1419482 Copy Cost Enhancement. Uday Moogala
954:
955: gmf_util.trace('item id and costcomp id...'|| r_cost_detail.inventory_item_id || '-' || r_cost_detail.cmpntcost_id,0) ;
956: gmf_util.trace( 'old cost = ' || r_cost_detail.cmpnt_cost , 3 );
957:
958: r_cost_detail.cmpnt_cost := r_cost_detail.cmpnt_cost * l_incr_pct + l_incr_decr_cost;
959: --Bug# 1584302 The above line is moved here from the inner most loop.

Line 956: gmf_util.trace( 'old cost = ' || r_cost_detail.cmpnt_cost , 3 );

952:
953: -- Bug# 1419482 Copy Cost Enhancement. Uday Moogala
954:
955: gmf_util.trace('item id and costcomp id...'|| r_cost_detail.inventory_item_id || '-' || r_cost_detail.cmpntcost_id,0) ;
956: gmf_util.trace( 'old cost = ' || r_cost_detail.cmpnt_cost , 3 );
957:
958: r_cost_detail.cmpnt_cost := r_cost_detail.cmpnt_cost * l_incr_pct + l_incr_decr_cost;
959: --Bug# 1584302 The above line is moved here from the inner most loop.
960:

Line 961: gmf_util.trace( 'New cost = ' || r_cost_detail.cmpnt_cost , 3 );

957:
958: r_cost_detail.cmpnt_cost := r_cost_detail.cmpnt_cost * l_incr_pct + l_incr_decr_cost;
959: --Bug# 1584302 The above line is moved here from the inner most loop.
960:
961: gmf_util.trace( 'New cost = ' || r_cost_detail.cmpnt_cost , 3 );
962:
963: l_cost_rows := l_cost_rows + 1;
964:
965:

Line 971: gmf_util.trace( 'Skipping rows for Item ' || r_cost_detail.inventory_item_id ||

967: BEGIN
968: IF( (l_curr_inventory_item_id = r_cost_detail.inventory_item_id) AND
969: (l_frozen_flag = 1)) THEN
970: -- Skip rows for this item
971: gmf_util.trace( 'Skipping rows for Item ' || r_cost_detail.inventory_item_id ||
972: ' Org ' || l_organization_id_to || ' period ' || l_period_id_to, 0 );
973: RAISE e_item_is_frozen;
974: END IF;
975:

Line 978: gmf_util.trace( 'Item ' || r_cost_detail.inventory_item_id ||

974: END IF;
975:
976: IF( (l_curr_inventory_item_id = r_cost_detail.inventory_item_id) AND
977: (l_assigned_flag = 0)) THEN
978: gmf_util.trace( 'Item ' || r_cost_detail.inventory_item_id ||
979: ' is not assigned to the Org ' || l_organization_id_to, 0 );
980: RAISE e_item_not_assigned;
981: END IF;
982:

Line 995: gmf_util.trace( 'Verify_frozen: Item ' || r_cost_detail.inventory_item_id ||

991: l_curr_inventory_item_id, l_organization_id_to,
992: pi_calendar_code_to, l_period_id_to,
993: pi_cost_type_id_to );
994:
995: gmf_util.trace( 'Verify_frozen: Item ' || r_cost_detail.inventory_item_id ||
996: ' Organization ' || l_organization_id_to || ' period ' || l_period_id_to ||
997: ' Status = ' || l_frozen_flag, 3 );
998:
999: l_assigned_flag := verify_item_assigned_to_org(

Line 1002: gmf_util.trace( 'Verify_item_assigned_to_org: Item ' || r_cost_detail.inventory_item_id ||

998:
999: l_assigned_flag := verify_item_assigned_to_org(
1000: l_curr_inventory_item_id, l_organization_id_to);
1001:
1002: gmf_util.trace( 'Verify_item_assigned_to_org: Item ' || r_cost_detail.inventory_item_id ||
1003: ' Organization ' || l_organization_id_to ||
1004: ' Status = ' || l_assigned_flag, 3 );
1005: END IF;
1006:

Line 1013: gmf_util.trace( 'Item ' || r_cost_detail.inventory_item_id ||

1009: RAISE e_item_is_frozen;
1010: END IF;
1011:
1012: IF( l_assigned_flag = 0 ) THEN
1013: gmf_util.trace( 'Item ' || r_cost_detail.inventory_item_id ||
1014: ' is not assigned to the Org ' || l_organization_id_to, 0 );
1015: RAISE e_item_not_assigned;
1016: END IF;
1017:

Line 1019: gmf_util.trace( 'Copying cost row:' ||

1015: RAISE e_item_not_assigned;
1016: END IF;
1017:
1018: -- Copy logic here
1019: gmf_util.trace( 'Copying cost row:' ||
1020: 'Cc_id = ' || r_cost_detail.cmpntcost_id ||
1021: ' Cmpnt = ' || r_cost_detail.cost_cmpntcls_id ||
1022: ' Ancd = ' || r_cost_detail.cost_analysis_code ||
1023: ' Level = ' || r_cost_detail.cost_level ||

Line 1028: * gmf_util.trace( 'New cost = ' || r_cost_detail.cmpnt_cost , 3 );

1024: ' Cost = ' || r_cost_detail.cmpnt_cost , 0 );
1025:
1026: /* Bug# 1584302: Moved the next 2 lines into 1st for loop.
1027: * r_cost_detail.cmpnt_cost := r_cost_detail.cmpnt_cost * l_incr_pct + l_incr_decr_cost;
1028: * gmf_util.trace( 'New cost = ' || r_cost_detail.cmpnt_cost , 3 );
1029: */
1030:
1031: /**
1032: * RS B1069117 - Call the delete stmt only once for an item

Line 1039: gmf_util.trace( 'Period ' || l_period_code ||

1035: IF( (l_curr_inventory_item_id2 = r_cost_detail.inventory_item_id) AND
1036: (l_period_status = 'F') AND ( l_rem_repl = 1 )
1037: ) THEN
1038: -- Skip this row for this item
1039: gmf_util.trace( 'Period ' || l_period_code ||
1040: ' is Frozen. You can not Delete Frozen period cost.', 0 );
1041: RAISE e_period_frozen;
1042:
1043: END IF; -- end for bug 5567102,pmarada

Line 1061: gmf_util.trace( 'Period ' || l_period_code ||

1057: l_curr_inventory_item_id2,
1058: l_period_id_to,
1059: pi_cost_type_id_to
1060: )) THEN
1061: gmf_util.trace( 'Period ' || l_period_code ||
1062: ' is Frozen. You can not Delete Frozen period cost.', 0 );
1063: RAISE e_period_frozen;
1064: END IF;
1065: END IF; -- end for bug 5567102 pmarada

Line 1120: gmf_util.trace( 'Period ' || l_period_code ||

1116: -- Verify whether the period is frozen or not. bug 5567102 start, pmarada
1117: -- if the period is frozen then don't update the cost.
1118: verify_frozen_periods(l_period_id_to, l_period_code, l_period_status);
1119: IF l_period_status = 'F' THEN
1120: gmf_util.trace( 'Period ' || l_period_code ||
1121: ' is Frozen. You can not Update Frozen period cost.', 0 );
1122: RAISE e_period_frozen;
1123: END IF; -- end for bug 5567102 pmarada
1124:

Line 1164: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from scst_led ', 1 );

1160: WHERE
1161: cmpntcost_id = l_updins_cc_id
1162: ;
1163:
1164: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from scst_led ', 1 );
1165:
1166: DELETE FROM
1167: cm_acst_led
1168: WHERE

Line 1172: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from acst_led', 1 );

1168: WHERE
1169: cmpntcost_id = l_updins_cc_id
1170: ;
1171:
1172: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from acst_led', 1 );
1173:
1174: UPDATE cm_brdn_dtl
1175: SET
1176: cmpntcost_id = NULL

Line 1181: gmf_util.trace( SQL%ROWCOUNT || ' rows updated in brdn_dtl', 0);

1177: WHERE
1178: cmpntcost_id = l_updins_cc_id
1179: ;
1180:
1181: gmf_util.trace( SQL%ROWCOUNT || ' rows updated in brdn_dtl', 0);
1182:
1183: IF ( l_copy_to_upper_lvl = 1 and r_cost_detail.cost_level = 1 ) THEN
1184: -- B2198228 We have read cost from lower level at source and user
1185: -- wants to copy it to this level at target

Line 1274: gmf_util.trace( ' row updated to cmpt_dtl', 0 );

1270: WHERE
1271: cmpntcost_id = l_updins_cc_id
1272: ;
1273:
1274: gmf_util.trace( ' row updated to cmpt_dtl', 0 );
1275:
1276: END IF; /* l_copy_to_upper_lvl = 1 */
1277: ELSE -- cursor not found
1278: -- update failed, try inserting the row into cm_cmpt_dtl

Line 1422: gmf_util.trace( SQL%ROWCOUNT || ' rows inserted to cmpt_dtl', 0 );

1418: pi_cost_type_id_to
1419: );
1420:
1421: l_cost_rows_ins := l_cost_rows_ins + 1;
1422: gmf_util.trace( SQL%ROWCOUNT || ' rows inserted to cmpt_dtl', 0 );
1423:
1424: END insert_or_update;
1425:
1426: END IF; --B10200720

Line 1442: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_cost_rows) );

1438: END LOOP; -- End of main cursor loop
1439: CLOSE cv_cost_detail;
1440:
1441: IF( l_cost_rows > 0 ) THEN
1442: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_cost_rows) );
1443: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS', TO_CHAR(l_cost_rows_upd), TO_CHAR(l_cost_rows_ins) );
1444: ELSE
1445: gmf_util.msg_log( 'GMF_CP_NO_ROWS' );
1446: END IF;

Line 1443: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS', TO_CHAR(l_cost_rows_upd), TO_CHAR(l_cost_rows_ins) );

1439: CLOSE cv_cost_detail;
1440:
1441: IF( l_cost_rows > 0 ) THEN
1442: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_cost_rows) );
1443: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS', TO_CHAR(l_cost_rows_upd), TO_CHAR(l_cost_rows_ins) );
1444: ELSE
1445: gmf_util.msg_log( 'GMF_CP_NO_ROWS' );
1446: END IF;
1447:

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

1441: IF( l_cost_rows > 0 ) THEN
1442: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_cost_rows) );
1443: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS', TO_CHAR(l_cost_rows_upd), TO_CHAR(l_cost_rows_ins) );
1444: ELSE
1445: gmf_util.msg_log( 'GMF_CP_NO_ROWS' );
1446: END IF;
1447:
1448: IF( l_cost_rows_skip > 0 ) THEN
1449: gmf_util.msg_log( 'GMF_CPIC_ROWS_FRZ', TO_CHAR(l_cost_rows_skip) );

Line 1449: gmf_util.msg_log( 'GMF_CPIC_ROWS_FRZ', TO_CHAR(l_cost_rows_skip) );

1445: gmf_util.msg_log( 'GMF_CP_NO_ROWS' );
1446: END IF;
1447:
1448: IF( l_cost_rows_skip > 0 ) THEN
1449: gmf_util.msg_log( 'GMF_CPIC_ROWS_FRZ', TO_CHAR(l_cost_rows_skip) );
1450: END IF;
1451:
1452: END LOOP ; -- Organizations loop
1453: CLOSE cv_org;

Line 1458: gmf_util.log;

1454:
1455: END LOOP ; -- Periods loop
1456: CLOSE cv_periods;
1457:
1458: gmf_util.log;
1459: gmf_util.msg_log( 'GMF_CPIC_ITM_END' );
1460: gmf_util.log;
1461:
1462: END copy_cost_dtl;

Line 1459: gmf_util.msg_log( 'GMF_CPIC_ITM_END' );

1455: END LOOP ; -- Periods loop
1456: CLOSE cv_periods;
1457:
1458: gmf_util.log;
1459: gmf_util.msg_log( 'GMF_CPIC_ITM_END' );
1460: gmf_util.log;
1461:
1462: END copy_cost_dtl;
1463:

Line 1460: gmf_util.log;

1456: CLOSE cv_periods;
1457:
1458: gmf_util.log;
1459: gmf_util.msg_log( 'GMF_CPIC_ITM_END' );
1460: gmf_util.log;
1461:
1462: END copy_cost_dtl;
1463:
1464:

Line 1542: gmf_util.trace( 'Deleting dependent rows', 0 );

1538: ;
1539:
1540: BEGIN
1541:
1542: gmf_util.trace( 'Deleting dependent rows', 0 );
1543: gmf_util.trace( 'Item:' || pi_inventory_item_id || ' Org:' || pi_organization_id ||
1544: ' Cal:' || pi_calendar_code || ' Per:' || pi_period_id || ' Mthd:' ||
1545: pi_cost_type_id , 0 );
1546:

Line 1543: gmf_util.trace( 'Item:' || pi_inventory_item_id || ' Org:' || pi_organization_id ||

1539:
1540: BEGIN
1541:
1542: gmf_util.trace( 'Deleting dependent rows', 0 );
1543: gmf_util.trace( 'Item:' || pi_inventory_item_id || ' Org:' || pi_organization_id ||
1544: ' Cal:' || pi_calendar_code || ' Per:' || pi_period_id || ' Mthd:' ||
1545: pi_cost_type_id , 0 );
1546:
1547: FOR r_cc_id IN c_cc_id(

Line 1558: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from acst_led', 3 );

1554: WHERE
1555: cmpntcost_id = r_cc_id.cmpntcost_id
1556: ;
1557:
1558: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from acst_led', 3 );
1559:
1560: -- Delete rows from scst_led
1561: DELETE FROM
1562: cm_scst_led

Line 1567: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from scst_led', 3 );

1563: WHERE
1564: cmpntcost_id = r_cc_id.cmpntcost_id
1565: ;
1566:
1567: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from scst_led', 3 );
1568:
1569: -- Update brdn_dtl
1570: UPDATE
1571: cm_brdn_dtl

Line 1578: gmf_util.trace( SQL%ROWCOUNT || ' rows updated in brdn_dtl', 3 );

1574: WHERE
1575: cmpntcost_id = r_cc_id.cmpntcost_id
1576: ;
1577:
1578: gmf_util.trace( SQL%ROWCOUNT || ' rows updated in brdn_dtl', 3 );
1579:
1580: -- Finally delete the row itself from cmpt_dtl
1581: DELETE FROM
1582: cm_cmpt_dtl

Line 1586: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from cmpt_dtl', 3 );

1582: cm_cmpt_dtl
1583: WHERE CURRENT OF c_cc_id
1584: ;
1585:
1586: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from cmpt_dtl', 3 );
1587:
1588: END LOOP;
1589:
1590: END delete_item_costs;

Line 1618: gmf_util.trace( 'Entering verify_frozen_costs', 0 );

1614: RETURN NUMBER IS
1615:
1616: l_frozen_ind NUMBER;
1617: BEGIN
1618: gmf_util.trace( 'Entering verify_frozen_costs', 0 );
1619:
1620: l_frozen_ind := 0;
1621: SELECT nvl(max(rollover_ind),0) INTO l_frozen_ind
1622: FROM

Line 1660: gmf_util.trace( 'Entering verify_frozen_periods', 0 );

1656: l_per_code gmf_period_statuses.period_code%TYPE;
1657: l_per_status gmf_period_statuses.period_status%TYPE;
1658:
1659: BEGIN
1660: gmf_util.trace( 'Entering verify_frozen_periods', 0 );
1661: OPEN cur_froz_periods (p_period_id);
1662: FETCH cur_froz_periods INTO l_per_code, l_per_status;
1663: CLOSE cur_froz_periods;
1664:

Line 1785: gmf_util.msg_log( 'GMF_CPOC_START' );

1781:
1782: FND_FILE.PUT_NAMES('gmfcpoc.log','gmfcpoc.out','/appslog/opm_top/utl/opmm0dv/log');
1783:
1784:
1785: gmf_util.msg_log( 'GMF_CPOC_START' );
1786: /*gmf_util.msg_log( 'GMF_CPOC_SRCPARAM', nvl(pi_organization_id_from, ' '), nvl(pi_calendar_code_from, ' '), nvl(pi_period_code_from, ' '), nvl(pi_cost_type_id_from, ' ') );
1787:
1788: gmf_util.msg_log( 'GMF_CPOC_TGTPARAM', nvl(pi_organization_id_to, ' '), nvl(pi_calendar_code_to, ' '), nvl(pi_period_code_to, ' '), nvl(pi_cost_type_id_to, ' ') );
1789:

Line 1786: /*gmf_util.msg_log( 'GMF_CPOC_SRCPARAM', nvl(pi_organization_id_from, ' '), nvl(pi_calendar_code_from, ' '), nvl(pi_period_code_from, ' '), nvl(pi_cost_type_id_from, ' ') );

1782: FND_FILE.PUT_NAMES('gmfcpoc.log','gmfcpoc.out','/appslog/opm_top/utl/opmm0dv/log');
1783:
1784:
1785: gmf_util.msg_log( 'GMF_CPOC_START' );
1786: /*gmf_util.msg_log( 'GMF_CPOC_SRCPARAM', nvl(pi_organization_id_from, ' '), nvl(pi_calendar_code_from, ' '), nvl(pi_period_code_from, ' '), nvl(pi_cost_type_id_from, ' ') );
1787:
1788: gmf_util.msg_log( 'GMF_CPOC_TGTPARAM', nvl(pi_organization_id_to, ' '), nvl(pi_calendar_code_to, ' '), nvl(pi_period_code_to, ' '), nvl(pi_cost_type_id_to, ' ') );
1789:
1790: gmf_util.msg_log( 'GMF_CPOC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );

Line 1788: gmf_util.msg_log( 'GMF_CPOC_TGTPARAM', nvl(pi_organization_id_to, ' '), nvl(pi_calendar_code_to, ' '), nvl(pi_period_code_to, ' '), nvl(pi_cost_type_id_to, ' ') );

1784:
1785: gmf_util.msg_log( 'GMF_CPOC_START' );
1786: /*gmf_util.msg_log( 'GMF_CPOC_SRCPARAM', nvl(pi_organization_id_from, ' '), nvl(pi_calendar_code_from, ' '), nvl(pi_period_code_from, ' '), nvl(pi_cost_type_id_from, ' ') );
1787:
1788: gmf_util.msg_log( 'GMF_CPOC_TGTPARAM', nvl(pi_organization_id_to, ' '), nvl(pi_calendar_code_to, ' '), nvl(pi_period_code_to, ' '), nvl(pi_cost_type_id_to, ' ') );
1789:
1790: gmf_util.msg_log( 'GMF_CPOC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );
1791: gmf_util.msg_log( 'GMF_CPOC_ITEMCCRANGE', nvl(pi_itemcc_from, ' '), nvl(pi_itemcc_to, ' ') );*/
1792:

Line 1790: gmf_util.msg_log( 'GMF_CPOC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );

1786: /*gmf_util.msg_log( 'GMF_CPOC_SRCPARAM', nvl(pi_organization_id_from, ' '), nvl(pi_calendar_code_from, ' '), nvl(pi_period_code_from, ' '), nvl(pi_cost_type_id_from, ' ') );
1787:
1788: gmf_util.msg_log( 'GMF_CPOC_TGTPARAM', nvl(pi_organization_id_to, ' '), nvl(pi_calendar_code_to, ' '), nvl(pi_period_code_to, ' '), nvl(pi_cost_type_id_to, ' ') );
1789:
1790: gmf_util.msg_log( 'GMF_CPOC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );
1791: gmf_util.msg_log( 'GMF_CPOC_ITEMCCRANGE', nvl(pi_itemcc_from, ' '), nvl(pi_itemcc_to, ' ') );*/
1792:
1793:
1794: -- Bug# 1419482 Copy Cost Enhancement. Uday Moogala

Line 1791: gmf_util.msg_log( 'GMF_CPOC_ITEMCCRANGE', nvl(pi_itemcc_from, ' '), nvl(pi_itemcc_to, ' ') );*/

1787:
1788: gmf_util.msg_log( 'GMF_CPOC_TGTPARAM', nvl(pi_organization_id_to, ' '), nvl(pi_calendar_code_to, ' '), nvl(pi_period_code_to, ' '), nvl(pi_cost_type_id_to, ' ') );
1789:
1790: gmf_util.msg_log( 'GMF_CPOC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );
1791: gmf_util.msg_log( 'GMF_CPOC_ITEMCCRANGE', nvl(pi_itemcc_from, ' '), nvl(pi_itemcc_to, ' ') );*/
1792:
1793:
1794: -- Bug# 1419482 Copy Cost Enhancement. Uday Moogala
1795: IF ( (pi_period_code_to IS NULL) AND -- all periods

Line 1799: gmf_util.msg_log('GMF_CPOC_ALLPERIODS', nvl(pi_calendar_code_to, ' ') ) ;

1795: IF ( (pi_period_code_to IS NULL) AND -- all periods
1796: ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))
1797: ) THEN
1798:
1799: gmf_util.msg_log('GMF_CPOC_ALLPERIODS', nvl(pi_calendar_code_to, ' ') ) ;
1800: gmf_util.msg_log('GMF_CPOC_PERIODS_RANGE', nvl(pi_all_periods_from, ' '),
1801: nvl(pi_all_periods_to, ' '), nvl(pi_calendar_code_to, ' ') ) ;
1802:
1803: END IF ;

Line 1800: gmf_util.msg_log('GMF_CPOC_PERIODS_RANGE', nvl(pi_all_periods_from, ' '),

1796: ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))
1797: ) THEN
1798:
1799: gmf_util.msg_log('GMF_CPOC_ALLPERIODS', nvl(pi_calendar_code_to, ' ') ) ;
1800: gmf_util.msg_log('GMF_CPOC_PERIODS_RANGE', nvl(pi_all_periods_from, ' '),
1801: nvl(pi_all_periods_to, ' '), nvl(pi_calendar_code_to, ' ') ) ;
1802:
1803: END IF ;
1804:

Line 1810: gmf_util.msg_log( 'GMF_CPOC_OPTREM' );

1806:
1807: l_rem_repl := 0;
1808: IF ( pi_rem_repl = '1' ) THEN -- Remove before copy
1809: l_rem_repl := 1;
1810: gmf_util.msg_log( 'GMF_CPOC_OPTREM' );
1811: ELSE -- Replace before copy
1812: l_rem_repl := 0;
1813: gmf_util.msg_log( 'GMF_CPOC_OPTREP' );
1814: END IF;

Line 1813: gmf_util.msg_log( 'GMF_CPOC_OPTREP' );

1809: l_rem_repl := 1;
1810: gmf_util.msg_log( 'GMF_CPOC_OPTREM' );
1811: ELSE -- Replace before copy
1812: l_rem_repl := 0;
1813: gmf_util.msg_log( 'GMF_CPOC_OPTREP' );
1814: END IF;
1815:
1816: gmf_util.log;
1817:

Line 1816: gmf_util.log;

1812: l_rem_repl := 0;
1813: gmf_util.msg_log( 'GMF_CPOC_OPTREP' );
1814: END IF;
1815:
1816: gmf_util.log;
1817:
1818: IF ( (pi_period_code_from = pi_period_code_to) AND
1819: (pi_cost_type_id_from = pi_cost_type_id_to) AND
1820: (pi_calendar_code_from = pi_calendar_code_to) AND

Line 1823: gmf_util.msg_log( 'GMF_CP_SAME_FROMTO' );

1819: (pi_cost_type_id_from = pi_cost_type_id_to) AND
1820: (pi_calendar_code_from = pi_calendar_code_to) AND
1821: (pi_organization_id_from = pi_organization_id_to) ) THEN
1822:
1823: gmf_util.msg_log( 'GMF_CP_SAME_FROMTO' );
1824: RAISE e_same_from_to;
1825: END IF;
1826:
1827: -- Determine what kind of where clause needs to be concatenated

Line 1836: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 0 );

1832: IF ( (pi_item_from IS NOT NULL) OR (pi_item_to IS NOT NULL) ) THEN
1833: l_from_range := pi_item_from;
1834: l_to_range := pi_item_to;
1835: l_range_type := G_ITEM;
1836: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 0 );
1837: ELSIF ( (pi_itemcc_from IS NOT NULL) OR (pi_itemcc_to IS NOT NULL) ) THEN
1838: l_from_range := pi_itemcc_from;
1839: l_to_range := pi_itemcc_to;
1840: l_range_type := G_ITEMCC;

Line 1841: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 0 );

1837: ELSIF ( (pi_itemcc_from IS NOT NULL) OR (pi_itemcc_to IS NOT NULL) ) THEN
1838: l_from_range := pi_itemcc_from;
1839: l_to_range := pi_itemcc_to;
1840: l_range_type := G_ITEMCC;
1841: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 0 );
1842: ELSE
1843: l_from_range := pi_item_from;
1844: l_to_range := pi_item_to;
1845: l_range_type := G_ITEM;

Line 1846: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 0);

1842: ELSE
1843: l_from_range := pi_item_from;
1844: l_to_range := pi_item_to;
1845: l_range_type := G_ITEM;
1846: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 0);
1847: END IF;
1848:
1849:
1850: -- Initialize WHO columns

Line 1878: gmf_util.log;

1874: end_copy( 'NORMAL', NULL );
1875: COMMIT;
1876:
1877:
1878: gmf_util.log;
1879: gmf_util.msg_log( 'GMF_CPIC_END' );
1880:
1881: EXCEPTION
1882: WHEN e_no_cost_rows THEN

Line 1879: gmf_util.msg_log( 'GMF_CPIC_END' );

1875: COMMIT;
1876:
1877:
1878: gmf_util.log;
1879: gmf_util.msg_log( 'GMF_CPIC_END' );
1880:
1881: EXCEPTION
1882: WHEN e_no_cost_rows THEN
1883: po_retcode := 0;

Line 2038: gmf_util.msg_log( 'GMF_CPIC_BUR_START' );

2034: and org.organization_id = pi_organization_id_from
2035: AND org.org_information_context = 'Accounting Information'
2036: AND gps.cost_type_id = pi_cost_type_id_from;
2037:
2038: gmf_util.msg_log( 'GMF_CPIC_BUR_START' );
2039: gmf_util.log;
2040:
2041: IF ( (pi_period_code_to IS NULL) AND -- all periods
2042: ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))

Line 2039: gmf_util.log;

2035: AND org.org_information_context = 'Accounting Information'
2036: AND gps.cost_type_id = pi_cost_type_id_from;
2037:
2038: gmf_util.msg_log( 'GMF_CPIC_BUR_START' );
2039: gmf_util.log;
2040:
2041: IF ( (pi_period_code_to IS NULL) AND -- all periods
2042: ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))
2043: ) THEN

Line 2044: gmf_util.msg_log('GMF_CPBRD_PERIODS_RANGE', nvl(pi_all_periods_from, ' '),

2040:
2041: IF ( (pi_period_code_to IS NULL) AND -- all periods
2042: ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))
2043: ) THEN
2044: gmf_util.msg_log('GMF_CPBRD_PERIODS_RANGE', nvl(pi_all_periods_from, ' '),
2045: nvl(pi_all_periods_to, ' '), nvl(pi_calendar_code_to, ' ') ) ;
2046: END IF ;
2047:
2048: l_sql_stmt_b := '';

Line 2095: gmf_util.msg_log( 'GMF_CPIC_UNKNOWN' );

2091: and z.concatenated_segments >= nvl(:b_from_itemcc, z.concatenated_segments)
2092: and z.concatenated_segments <= nvl(:b_to_itemcc, z.concatenated_segments))';
2093:
2094: ELSE
2095: gmf_util.msg_log( 'GMF_CPIC_UNKNOWN' );
2096: RETURN;
2097: END IF;
2098:
2099: l_sql_stmt_b := l_sql_stmt_b ||

Line 2106: gmf_util.trace( 'Burden Sql Stmt: ' || l_sql_stmt_b, 3 );

2102: 'bur.resources, bur.period_id, ' ||
2103: 'bur.cost_type_id, bur.cost_cmpntcls_id, bur.cost_analysis_code'
2104: ;
2105:
2106: gmf_util.trace( 'Burden Sql Stmt: ' || l_sql_stmt_b, 3 );
2107:
2108: IF (pi_organization_id_to IS NOT NULL) THEN -- copying to one organization
2109:
2110: l_sql_org_b := '' ;

Line 2208: gmf_util.trace( 'Organization Query : ' || l_sql_org_b, 3 );

2204: l_sql_periods_b := l_sql_periods_b || 'ORDER BY c3.start_date' ;
2205: END IF ; -- To Period code check
2206:
2207:
2208: gmf_util.trace( 'Organization Query : ' || l_sql_org_b, 3 );
2209: gmf_util.trace( 'Periods Query : ' || l_sql_periods_b, 3 );
2210:
2211: -- End Bug# 1419482
2212: /* begin sschinch dt 05/2/03 bug 2934528 Bind variable fix */

Line 2209: gmf_util.trace( 'Periods Query : ' || l_sql_periods_b, 3 );

2205: END IF ; -- To Period code check
2206:
2207:
2208: gmf_util.trace( 'Organization Query : ' || l_sql_org_b, 3 );
2209: gmf_util.trace( 'Periods Query : ' || l_sql_periods_b, 3 );
2210:
2211: -- End Bug# 1419482
2212: /* begin sschinch dt 05/2/03 bug 2934528 Bind variable fix */
2213:

Line 2297: gmf_util.log;

2293: pi_from_range, pi_to_range
2294: );
2295: END IF;
2296:
2297: gmf_util.log;
2298: gmf_util.msg_log('GMF_CPBRD_ALLWHSEPRD', l_organization_id_to, l_period_id_to ) ;
2299:
2300: -- Copy the burden costs
2301: l_brdn_rows := 0;

Line 2298: gmf_util.msg_log('GMF_CPBRD_ALLWHSEPRD', l_organization_id_to, l_period_id_to ) ;

2294: );
2295: END IF;
2296:
2297: gmf_util.log;
2298: gmf_util.msg_log('GMF_CPBRD_ALLWHSEPRD', l_organization_id_to, l_period_id_to ) ;
2299:
2300: -- Copy the burden costs
2301: l_brdn_rows := 0;
2302: l_brdn_rows_upd := 0;

Line 2304: gmf_util.trace('From: Organization-'||pi_organization_id_from||

2300: -- Copy the burden costs
2301: l_brdn_rows := 0;
2302: l_brdn_rows_upd := 0;
2303: l_brdn_rows_ins := 0;
2304: gmf_util.trace('From: Organization-'||pi_organization_id_from||
2305: ' cal-'||pi_calendar_code_from||' prd-'||pi_period_code_from||
2306: ' mthd-'||pi_cost_type_id_from||'itemfrom-'||pi_from_range||
2307: ' item2-'||pi_to_range,0);
2308:

Line 2319: gmf_util.trace( 'Item = ' || r_brdn_dtl.inventory_item_id ||

2315: LOOP
2316: FETCH cv_brdn_dtl INTO r_brdn_dtl;
2317: EXIT WHEN cv_brdn_dtl%NOTFOUND;
2318:
2319: gmf_util.trace( 'Item = ' || r_brdn_dtl.inventory_item_id ||
2320: ' Rsrc ' || r_brdn_dtl.resources ||
2321: ' cmpt ' || r_brdn_dtl.cost_cmpntcls_id ||
2322: ' ancd ' || r_brdn_dtl.cost_analysis_code ||
2323: ' bqty ' || r_brdn_dtl.burden_qty ||

Line 2343: gmf_util.trace( 'Verify_item_assigned_to_org: Item ' || r_brdn_dtl.inventory_item_id ||

2339: BEGIN
2340: l_assigned_flag := verify_item_assigned_to_org(
2341: r_brdn_dtl.inventory_item_id, l_organization_id_to);
2342:
2343: gmf_util.trace( 'Verify_item_assigned_to_org: Item ' || r_brdn_dtl.inventory_item_id ||
2344: ' Organization ' || l_organization_id_to ||
2345: ' Status = ' || l_assigned_flag, 3 );
2346: IF(l_assigned_flag = 0) THEN
2347: gmf_util.trace( 'Item ' || r_brdn_dtl.inventory_item_id ||

Line 2347: gmf_util.trace( 'Item ' || r_brdn_dtl.inventory_item_id ||

2343: gmf_util.trace( 'Verify_item_assigned_to_org: Item ' || r_brdn_dtl.inventory_item_id ||
2344: ' Organization ' || l_organization_id_to ||
2345: ' Status = ' || l_assigned_flag, 3 );
2346: IF(l_assigned_flag = 0) THEN
2347: gmf_util.trace( 'Item ' || r_brdn_dtl.inventory_item_id ||
2348: ' is not assigned to Organization ' || l_organization_id_to, 0 );
2349: RAISE e_item_not_assigned;
2350: END IF;
2351:

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

2461: END LOOP;
2462: CLOSE cv_brdn_dtl;
2463:
2464: IF( l_brdn_rows > 0 ) THEN
2465: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_brdn_rows) );
2466: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS', TO_CHAR(l_brdn_rows_upd), TO_CHAR(l_brdn_rows_ins) );
2467: ELSE
2468: gmf_util.msg_log( 'GMF_CP_NO_ROWS' );
2469: END IF;

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

2462: CLOSE cv_brdn_dtl;
2463:
2464: IF( l_brdn_rows > 0 ) THEN
2465: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_brdn_rows) );
2466: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS', TO_CHAR(l_brdn_rows_upd), TO_CHAR(l_brdn_rows_ins) );
2467: ELSE
2468: gmf_util.msg_log( 'GMF_CP_NO_ROWS' );
2469: END IF;
2470:

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

2464: IF( l_brdn_rows > 0 ) THEN
2465: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_brdn_rows) );
2466: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS', TO_CHAR(l_brdn_rows_upd), TO_CHAR(l_brdn_rows_ins) );
2467: ELSE
2468: gmf_util.msg_log( 'GMF_CP_NO_ROWS' );
2469: END IF;
2470:
2471: END LOOP ; -- organization loop
2472: CLOSE cv_org;

Line 2476: gmf_util.log;

2472: CLOSE cv_org;
2473: END LOOP ; -- periods loop
2474: CLOSE cv_periods;
2475:
2476: gmf_util.log;
2477: gmf_util.msg_log( 'GMF_CPIC_BUR_END' );
2478:
2479: END copy_burden_dtl;
2480:

Line 2477: gmf_util.msg_log( 'GMF_CPIC_BUR_END' );

2473: END LOOP ; -- periods loop
2474: CLOSE cv_periods;
2475:
2476: gmf_util.log;
2477: gmf_util.msg_log( 'GMF_CPIC_BUR_END' );
2478:
2479: END copy_burden_dtl;
2480:
2481: /*****************************************************************************

Line 2549: gmf_util.msg_log( 'GMF_CPIC_UNKNOWN' );

2545: and z.concatenated_segments >= nvl(:b_from_itemcc, z.concatenated_segments)
2546: and z.concatenated_segments <= nvl(:b_to_itemcc, z.concatenated_segments))';
2547:
2548: ELSE
2549: gmf_util.msg_log( 'GMF_CPIC_UNKNOWN' );
2550: RETURN;
2551: END IF;
2552:
2553: gmf_util.trace( 'Burden del sub-qry: ' || l_sub_qry_b, 3 );

Line 2553: gmf_util.trace( 'Burden del sub-qry: ' || l_sub_qry_b, 3 );

2549: gmf_util.msg_log( 'GMF_CPIC_UNKNOWN' );
2550: RETURN;
2551: END IF;
2552:
2553: gmf_util.trace( 'Burden del sub-qry: ' || l_sub_qry_b, 3 );
2554:
2555: l_del_stmt_b := l_del_stmt_b || l_sub_qry_b || ' ) ' ;
2556:
2557: gmf_util.trace( ' Burden Del Stmt: ' || l_del_stmt_b, 3 );

Line 2557: gmf_util.trace( ' Burden Del Stmt: ' || l_del_stmt_b, 3 );

2553: gmf_util.trace( 'Burden del sub-qry: ' || l_sub_qry_b, 3 );
2554:
2555: l_del_stmt_b := l_del_stmt_b || l_sub_qry_b || ' ) ' ;
2556:
2557: gmf_util.trace( ' Burden Del Stmt: ' || l_del_stmt_b, 3 );
2558:
2559: BEGIN
2560: EXECUTE IMMEDIATE l_del_stmt_b USING
2561: pi_organization_id,

Line 2568: gmf_util.trace( SQL%ROWCOUNT || ' Rows deleted from Burden Details', 0);

2564: EXCEPTION
2565: WHEN OTHERS THEN
2566: fnd_file.put_line(fnd_file.log,'THE ERROR IS :'||SQLERRM);
2567: END;
2568: gmf_util.trace( SQL%ROWCOUNT || ' Rows deleted from Burden Details', 0);
2569:
2570: END delete_burden_costs;
2571:
2572: /*****************************************************************************

Line 2594: gmf_util.trace( 'Entering verify_item_assigned_to_org', 0 );

2590: )
2591: RETURN NUMBER IS
2592: l_assigned_ind NUMBER;
2593: BEGIN
2594: gmf_util.trace( 'Entering verify_item_assigned_to_org', 0 );
2595:
2596: l_assigned_ind := 0;
2597: SELECT count(1) INTO l_assigned_ind
2598: FROM