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 203: gmf_util.msg_log( 'GMF_CPIC_START' );

199: /* uncomment the call below to write to a local file */
200: FND_FILE.PUT_NAMES('gmfcpic.log','gmfcpic.out','/appslog/opm_top/utl/opmm0dv/log');
201:
202:
203: gmf_util.msg_log( 'GMF_CPIC_START' );
204:
205: 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), ' ') );
206:
207: 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 205: 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), ' ') );

201:
202:
203: gmf_util.msg_log( 'GMF_CPIC_START' );
204:
205: 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), ' ') );
206:
207: 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), ' ') );
208:
209: gmf_util.msg_log( 'GMF_CPIC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );

Line 207: 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), ' ') );

203: gmf_util.msg_log( 'GMF_CPIC_START' );
204:
205: 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), ' ') );
206:
207: 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), ' ') );
208:
209: gmf_util.msg_log( 'GMF_CPIC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );
210: gmf_util.msg_log( 'GMF_CPIC_ITEMCCRANGE', nvl(pi_itemcc_from, ' '), nvl(pi_itemcc_to, ' ') );
211:

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

205: 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), ' ') );
206:
207: 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), ' ') );
208:
209: gmf_util.msg_log( 'GMF_CPIC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );
210: gmf_util.msg_log( 'GMF_CPIC_ITEMCCRANGE', nvl(pi_itemcc_from, ' '), nvl(pi_itemcc_to, ' ') );
211:
212: gmf_util.msg_log( 'GMF_CPIC_INCPCT', nvl(pi_incr_pct, ' ') );
213: gmf_util.msg_log( 'GMF_CPIC_INCCOST', nvl(pi_incr_decr_cost, ' ') );

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

206:
207: 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), ' ') );
208:
209: gmf_util.msg_log( 'GMF_CPIC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );
210: gmf_util.msg_log( 'GMF_CPIC_ITEMCCRANGE', nvl(pi_itemcc_from, ' '), nvl(pi_itemcc_to, ' ') );
211:
212: gmf_util.msg_log( 'GMF_CPIC_INCPCT', nvl(pi_incr_pct, ' ') );
213: gmf_util.msg_log( 'GMF_CPIC_INCCOST', nvl(pi_incr_decr_cost, ' ') );
214:

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

208:
209: gmf_util.msg_log( 'GMF_CPIC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );
210: gmf_util.msg_log( 'GMF_CPIC_ITEMCCRANGE', nvl(pi_itemcc_from, ' '), nvl(pi_itemcc_to, ' ') );
211:
212: gmf_util.msg_log( 'GMF_CPIC_INCPCT', nvl(pi_incr_pct, ' ') );
213: gmf_util.msg_log( 'GMF_CPIC_INCCOST', nvl(pi_incr_decr_cost, ' ') );
214:
215: -- Bug# 1419482 Copy Cost Enhancement. Uday Moogala
216: IF ( (pi_period_code_to IS NULL) AND -- all periods

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

209: gmf_util.msg_log( 'GMF_CPIC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );
210: gmf_util.msg_log( 'GMF_CPIC_ITEMCCRANGE', nvl(pi_itemcc_from, ' '), nvl(pi_itemcc_to, ' ') );
211:
212: gmf_util.msg_log( 'GMF_CPIC_INCPCT', nvl(pi_incr_pct, ' ') );
213: gmf_util.msg_log( 'GMF_CPIC_INCCOST', nvl(pi_incr_decr_cost, ' ') );
214:
215: -- Bug# 1419482 Copy Cost Enhancement. Uday Moogala
216: IF ( (pi_period_code_to IS NULL) AND -- all periods
217: ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))

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

216: IF ( (pi_period_code_to IS NULL) AND -- all periods
217: ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))
218: ) THEN
219:
220: gmf_util.msg_log('GMF_CPIC_ALLPERIODS', nvl(pi_calendar_code_to, ' ') ) ;
221: gmf_util.msg_log('GMF_CPIC_PERIODS_RANGE', nvl(pi_all_periods_from, ' '),
222: nvl(pi_all_periods_to, ' '), nvl(pi_calendar_code_to, ' ') ) ;
223: END IF ;
224:

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

217: ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))
218: ) THEN
219:
220: gmf_util.msg_log('GMF_CPIC_ALLPERIODS', nvl(pi_calendar_code_to, ' ') ) ;
221: gmf_util.msg_log('GMF_CPIC_PERIODS_RANGE', nvl(pi_all_periods_from, ' '),
222: nvl(pi_all_periods_to, ' '), nvl(pi_calendar_code_to, ' ') ) ;
223: END IF ;
224:
225: -- End Bug# 1419482

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

226:
227: l_rem_repl := 0;
228: IF ( pi_rem_repl = '1' ) THEN -- Remove before copy
229: l_rem_repl := 1;
230: gmf_util.msg_log( 'GMF_CPIC_OPTREM' );
231: ELSE -- Replace before copy
232: l_rem_repl := 0;
233: gmf_util.msg_log( 'GMF_CPIC_OPTREP' );
234: END IF;

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

229: l_rem_repl := 1;
230: gmf_util.msg_log( 'GMF_CPIC_OPTREM' );
231: ELSE -- Replace before copy
232: l_rem_repl := 0;
233: gmf_util.msg_log( 'GMF_CPIC_OPTREP' );
234: END IF;
235:
236: -- B2198228
237: l_copy_to_upper_lvl := 0;

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

237: l_copy_to_upper_lvl := 0;
238: IF ( pi_copy_to_upper_lvl = '1' ) THEN
239: -- Copy lower level cost from source to upper level at target
240: l_copy_to_upper_lvl := 1;
241: gmf_util.msg_log( 'GMF_CPIC_TO_UPPER_YES' );
242: ELSE
243: l_copy_to_upper_lvl := 0;
244: gmf_util.msg_log( 'GMF_CPIC_TO_UPPER_NO' );
245: END IF;

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

240: l_copy_to_upper_lvl := 1;
241: gmf_util.msg_log( 'GMF_CPIC_TO_UPPER_YES' );
242: ELSE
243: l_copy_to_upper_lvl := 0;
244: gmf_util.msg_log( 'GMF_CPIC_TO_UPPER_NO' );
245: END IF;
246:
247: gmf_util.log;
248:

Line 247: gmf_util.log;

243: l_copy_to_upper_lvl := 0;
244: gmf_util.msg_log( 'GMF_CPIC_TO_UPPER_NO' );
245: END IF;
246:
247: gmf_util.log;
248:
249: IF ( (pi_period_code_from = pi_period_code_to) AND
250: (pi_cost_type_id_from = pi_cost_type_id_to) AND
251: (pi_calendar_code_from = pi_calendar_code_to) AND

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

250: (pi_cost_type_id_from = pi_cost_type_id_to) AND
251: (pi_calendar_code_from = pi_calendar_code_to) AND
252: (pi_organization_id_from = pi_organization_id_to) ) THEN
253:
254: gmf_util.msg_log( 'GMF_CP_SAME_FROMTO' );
255: RAISE e_same_from_to;
256: END IF;
257:
258: -- Determine what kind of where clause needs to be concatenated

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

264: IF ( (pi_item_from IS NOT NULL) OR (pi_item_to IS NOT NULL) ) THEN
265: l_from_range := pi_item_from;
266: l_to_range := pi_item_to;
267: l_range_type := G_ITEM;
268: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 1 );
269: ELSIF ( (pi_itemcc_from IS NOT NULL) OR (pi_itemcc_to IS NOT NULL) ) THEN
270: l_from_range := pi_itemcc_from;
271: l_to_range := pi_itemcc_to;
272: l_range_type := G_ITEMCC;

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

269: ELSIF ( (pi_itemcc_from IS NOT NULL) OR (pi_itemcc_to IS NOT NULL) ) THEN
270: l_from_range := pi_itemcc_from;
271: l_to_range := pi_itemcc_to;
272: l_range_type := G_ITEMCC;
273: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 1 );
274: ELSE
275: l_from_range := pi_item_from;
276: l_to_range := pi_item_to;
277: l_range_type := G_ITEM;

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

274: ELSE
275: l_from_range := pi_item_from;
276: l_to_range := pi_item_to;
277: l_range_type := G_ITEM;
278: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 1 );
279: END IF;
280:
281: -- Set the increase or decrease percentage and cost
282: IF( pi_incr_pct IS NOT NULL ) THEN

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

289: ELSE
290: l_incr_decr_cost := 0.0;
291: END IF;
292:
293: gmf_util.trace( ' Incr pct = ' || l_incr_pct || ' Incr/Decr Cost = ' ||l_incr_decr_cost, 1 );
294:
295: -- Initialize WHO columns
296: g_user_id := FND_GLOBAL.USER_ID;
297: g_login_id := FND_GLOBAL.LOGIN_ID;

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

305: g_effid_copy := FND_PROFILE.VALUE('GMF_CPIC_EFF') ;
306: SELECT decode(g_effid_copy, 'Y', 'YES', 'N', 'NO', '')
307: INTO l_effid_copy
308: FROM dual ;
309: gmf_util.msg_log('GMF_CPIC_EFFID', l_effid_copy ) ; --niyadav
310:
311: EXCEPTION
312: WHEN OTHERS THEN
313: l_effid_copy := 'N' ;

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

310:
311: EXCEPTION
312: WHEN OTHERS THEN
313: l_effid_copy := 'N' ;
314: gmf_util.msg_log('GMF_CPIC_EFFID', l_effid_copy) ;
315: END ;
316:
317: -- End Bug# 1419482
318:

Line 340: gmf_util.log;

336: po_errbuf := NULL;
337: end_copy( 'NORMAL', NULL );
338: COMMIT;
339:
340: gmf_util.log;
341: gmf_util.msg_log( 'GMF_CPIC_END' );
342:
343: EXCEPTION
344: WHEN e_no_cost_rows THEN

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

337: end_copy( 'NORMAL', NULL );
338: COMMIT;
339:
340: gmf_util.log;
341: gmf_util.msg_log( 'GMF_CPIC_END' );
342:
343: EXCEPTION
344: WHEN e_no_cost_rows THEN
345: po_retcode := 0;

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

685: 'cst.cost_analysis_code, ' ||
686: 'cst.cost_level ' ;
687:
688:
689: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 0 );
690:
691: gmf_util.trace( 'Item details Query : ' || l_sql_stmt, 3 );
692:
693:

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

687:
688:
689: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 0 );
690:
691: gmf_util.trace( 'Item details Query : ' || l_sql_stmt, 3 );
692:
693:
694: -- get org_id for the target calendar
695:

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

799: l_sql_periods := l_sql_periods || ' ORDER BY c3.start_date' ;
800:
801: END IF ; -- To Period code check
802:
803: gmf_util.trace( 'Org Query : ' || l_sql_org, 3 );
804: gmf_util.trace( 'Periods Query : ' || l_sql_periods, 3 );
805:
806: IF (pi_period_id_to IS NOT NULL) THEN
807: OPEN cv_periods FOR l_sql_periods

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

800:
801: END IF ; -- To Period code check
802:
803: gmf_util.trace( 'Org Query : ' || l_sql_org, 3 );
804: gmf_util.trace( 'Periods Query : ' || l_sql_periods, 3 );
805:
806: IF (pi_period_id_to IS NOT NULL) THEN
807: OPEN cv_periods FOR l_sql_periods
808: USING pi_period_id_to;

Line 882: gmf_util.log;

878:
879: FETCH cv_org INTO l_organization_id_to ;
880: EXIT WHEN cv_org%NOTFOUND ;
881:
882: gmf_util.log;
883: gmf_util.msg_log('GMF_CPIC_ALLWHSEPRD', l_organization_id_to,l_period_id_to) ;
884:
885: -- End Bug# 1419482
886:

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

879: FETCH cv_org INTO l_organization_id_to ;
880: EXIT WHEN cv_org%NOTFOUND ;
881:
882: gmf_util.log;
883: gmf_util.msg_log('GMF_CPIC_ALLWHSEPRD', l_organization_id_to,l_period_id_to) ;
884:
885: -- End Bug# 1419482
886:
887: l_curr_inventory_item_id := -1;

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

922: */
923:
924: -- Bug# 1419482 Copy Cost Enhancement. Uday Moogala
925:
926: gmf_util.trace('item id and costcomp id...'|| r_cost_detail.inventory_item_id || '-' || r_cost_detail.cmpntcost_id,0) ;
927: gmf_util.trace( 'old cost = ' || r_cost_detail.cmpnt_cost , 3 );
928:
929: r_cost_detail.cmpnt_cost := r_cost_detail.cmpnt_cost * l_incr_pct + l_incr_decr_cost;
930: --Bug# 1584302 The above line is moved here from the inner most loop.

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

923:
924: -- Bug# 1419482 Copy Cost Enhancement. Uday Moogala
925:
926: gmf_util.trace('item id and costcomp id...'|| r_cost_detail.inventory_item_id || '-' || r_cost_detail.cmpntcost_id,0) ;
927: gmf_util.trace( 'old cost = ' || r_cost_detail.cmpnt_cost , 3 );
928:
929: r_cost_detail.cmpnt_cost := r_cost_detail.cmpnt_cost * l_incr_pct + l_incr_decr_cost;
930: --Bug# 1584302 The above line is moved here from the inner most loop.
931:

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

928:
929: r_cost_detail.cmpnt_cost := r_cost_detail.cmpnt_cost * l_incr_pct + l_incr_decr_cost;
930: --Bug# 1584302 The above line is moved here from the inner most loop.
931:
932: gmf_util.trace( 'New cost = ' || r_cost_detail.cmpnt_cost , 3 );
933:
934: l_cost_rows := l_cost_rows + 1;
935:
936:

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

938: BEGIN
939: IF( (l_curr_inventory_item_id = r_cost_detail.inventory_item_id) AND
940: (l_frozen_flag = 1)) THEN
941: -- Skip rows for this item
942: gmf_util.trace( 'Skipping rows for Item ' || r_cost_detail.inventory_item_id ||
943: ' Org ' || l_organization_id_to || ' period ' || l_period_id_to, 0 );
944: RAISE e_item_is_frozen;
945: END IF;
946:

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

945: END IF;
946:
947: IF( (l_curr_inventory_item_id = r_cost_detail.inventory_item_id) AND
948: (l_assigned_flag = 0)) THEN
949: gmf_util.trace( 'Item ' || r_cost_detail.inventory_item_id ||
950: ' is not assigned to the Org ' || l_organization_id_to, 0 );
951: RAISE e_item_not_assigned;
952: END IF;
953:

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

962: l_curr_inventory_item_id, l_organization_id_to,
963: pi_calendar_code_to, l_period_id_to,
964: pi_cost_type_id_to );
965:
966: gmf_util.trace( 'Verify_frozen: Item ' || r_cost_detail.inventory_item_id ||
967: ' Organization ' || l_organization_id_to || ' period ' || l_period_id_to ||
968: ' Status = ' || l_frozen_flag, 3 );
969:
970: l_assigned_flag := verify_item_assigned_to_org(

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

969:
970: l_assigned_flag := verify_item_assigned_to_org(
971: l_curr_inventory_item_id, l_organization_id_to);
972:
973: gmf_util.trace( 'Verify_item_assigned_to_org: Item ' || r_cost_detail.inventory_item_id ||
974: ' Organization ' || l_organization_id_to ||
975: ' Status = ' || l_assigned_flag, 3 );
976: END IF;
977:

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

980: RAISE e_item_is_frozen;
981: END IF;
982:
983: IF( l_assigned_flag = 0 ) THEN
984: gmf_util.trace( 'Item ' || r_cost_detail.inventory_item_id ||
985: ' is not assigned to the Org ' || l_organization_id_to, 0 );
986: RAISE e_item_not_assigned;
987: END IF;
988:

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

986: RAISE e_item_not_assigned;
987: END IF;
988:
989: -- Copy logic here
990: gmf_util.trace( 'Copying cost row:' ||
991: 'Cc_id = ' || r_cost_detail.cmpntcost_id ||
992: ' Cmpnt = ' || r_cost_detail.cost_cmpntcls_id ||
993: ' Ancd = ' || r_cost_detail.cost_analysis_code ||
994: ' Level = ' || r_cost_detail.cost_level ||

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

995: ' Cost = ' || r_cost_detail.cmpnt_cost , 0 );
996:
997: /* Bug# 1584302: Moved the next 2 lines into 1st for loop.
998: * r_cost_detail.cmpnt_cost := r_cost_detail.cmpnt_cost * l_incr_pct + l_incr_decr_cost;
999: * gmf_util.trace( 'New cost = ' || r_cost_detail.cmpnt_cost , 3 );
1000: */
1001:
1002: /**
1003: * RS B1069117 - Call the delete stmt only once for an item

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

1006: IF( (l_curr_inventory_item_id2 = r_cost_detail.inventory_item_id) AND
1007: (l_period_status = 'F') AND ( l_rem_repl = 1 )
1008: ) THEN
1009: -- Skip this row for this item
1010: gmf_util.trace( 'Period ' || l_period_code ||
1011: ' is Frozen. You can not Delete Frozen period cost.', 0 );
1012: RAISE e_period_frozen;
1013:
1014: END IF; -- end for bug 5567102,pmarada

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

1028: l_curr_inventory_item_id2,
1029: l_period_id_to,
1030: pi_cost_type_id_to
1031: )) THEN
1032: gmf_util.trace( 'Period ' || l_period_code ||
1033: ' is Frozen. You can not Delete Frozen period cost.', 0 );
1034: RAISE e_period_frozen;
1035: END IF;
1036: END IF; -- end for bug 5567102 pmarada

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

1085: -- Verify whether the period is frozen or not. bug 5567102 start, pmarada
1086: -- if the period is frozen then don't update the cost.
1087: verify_frozen_periods(l_period_id_to, l_period_code, l_period_status);
1088: IF l_period_status = 'F' THEN
1089: gmf_util.trace( 'Period ' || l_period_code ||
1090: ' is Frozen. You can not Update Frozen period cost.', 0 );
1091: RAISE e_period_frozen;
1092: END IF; -- end for bug 5567102 pmarada
1093:

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

1129: WHERE
1130: cmpntcost_id = l_updins_cc_id
1131: ;
1132:
1133: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from scst_led ', 1 );
1134:
1135: DELETE FROM
1136: cm_acst_led
1137: WHERE

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

1137: WHERE
1138: cmpntcost_id = l_updins_cc_id
1139: ;
1140:
1141: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from acst_led', 1 );
1142:
1143: UPDATE cm_brdn_dtl
1144: SET
1145: cmpntcost_id = NULL

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

1146: WHERE
1147: cmpntcost_id = l_updins_cc_id
1148: ;
1149:
1150: gmf_util.trace( SQL%ROWCOUNT || ' rows updated in brdn_dtl', 0);
1151:
1152: IF ( l_copy_to_upper_lvl = 1 and r_cost_detail.cost_level = 1 ) THEN
1153: -- B2198228 We have read cost from lower level at source and user
1154: -- wants to copy it to this level at target

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

1237: WHERE
1238: cmpntcost_id = l_updins_cc_id
1239: ;
1240:
1241: gmf_util.trace( ' row updated to cmpt_dtl', 0 );
1242:
1243: END IF; /* l_copy_to_upper_lvl = 1 */
1244: ELSE -- cursor not found
1245: -- update failed, try inserting the row into cm_cmpt_dtl

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

1384: pi_cost_type_id_to
1385: );
1386:
1387: l_cost_rows_ins := l_cost_rows_ins + 1;
1388: gmf_util.trace( SQL%ROWCOUNT || ' rows inserted to cmpt_dtl', 0 );
1389:
1390: END insert_or_update;
1391:
1392: EXCEPTION

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

1402: END LOOP; -- End of main cursor loop
1403: CLOSE cv_cost_detail;
1404:
1405: IF( l_cost_rows > 0 ) THEN
1406: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_cost_rows) );
1407: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS', TO_CHAR(l_cost_rows_upd), TO_CHAR(l_cost_rows_ins) );
1408: ELSE
1409: gmf_util.msg_log( 'GMF_CP_NO_ROWS' );
1410: END IF;

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

1403: CLOSE cv_cost_detail;
1404:
1405: IF( l_cost_rows > 0 ) THEN
1406: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_cost_rows) );
1407: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS', TO_CHAR(l_cost_rows_upd), TO_CHAR(l_cost_rows_ins) );
1408: ELSE
1409: gmf_util.msg_log( 'GMF_CP_NO_ROWS' );
1410: END IF;
1411:

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

1405: IF( l_cost_rows > 0 ) THEN
1406: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_cost_rows) );
1407: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS', TO_CHAR(l_cost_rows_upd), TO_CHAR(l_cost_rows_ins) );
1408: ELSE
1409: gmf_util.msg_log( 'GMF_CP_NO_ROWS' );
1410: END IF;
1411:
1412: IF( l_cost_rows_skip > 0 ) THEN
1413: gmf_util.msg_log( 'GMF_CPIC_ROWS_FRZ', TO_CHAR(l_cost_rows_skip) );

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

1409: gmf_util.msg_log( 'GMF_CP_NO_ROWS' );
1410: END IF;
1411:
1412: IF( l_cost_rows_skip > 0 ) THEN
1413: gmf_util.msg_log( 'GMF_CPIC_ROWS_FRZ', TO_CHAR(l_cost_rows_skip) );
1414: END IF;
1415:
1416: END LOOP ; -- Organizations loop
1417: CLOSE cv_org;

Line 1422: gmf_util.log;

1418:
1419: END LOOP ; -- Periods loop
1420: CLOSE cv_periods;
1421:
1422: gmf_util.log;
1423: gmf_util.msg_log( 'GMF_CPIC_ITM_END' );
1424: gmf_util.log;
1425:
1426: END copy_cost_dtl;

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

1419: END LOOP ; -- Periods loop
1420: CLOSE cv_periods;
1421:
1422: gmf_util.log;
1423: gmf_util.msg_log( 'GMF_CPIC_ITM_END' );
1424: gmf_util.log;
1425:
1426: END copy_cost_dtl;
1427:

Line 1424: gmf_util.log;

1420: CLOSE cv_periods;
1421:
1422: gmf_util.log;
1423: gmf_util.msg_log( 'GMF_CPIC_ITM_END' );
1424: gmf_util.log;
1425:
1426: END copy_cost_dtl;
1427:
1428:

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

1502: ;
1503:
1504: BEGIN
1505:
1506: gmf_util.trace( 'Deleting dependent rows', 0 );
1507: gmf_util.trace( 'Item:' || pi_inventory_item_id || ' Org:' || pi_organization_id ||
1508: ' Cal:' || pi_calendar_code || ' Per:' || pi_period_id || ' Mthd:' ||
1509: pi_cost_type_id , 0 );
1510:

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

1503:
1504: BEGIN
1505:
1506: gmf_util.trace( 'Deleting dependent rows', 0 );
1507: gmf_util.trace( 'Item:' || pi_inventory_item_id || ' Org:' || pi_organization_id ||
1508: ' Cal:' || pi_calendar_code || ' Per:' || pi_period_id || ' Mthd:' ||
1509: pi_cost_type_id , 0 );
1510:
1511: FOR r_cc_id IN c_cc_id(

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

1518: WHERE
1519: cmpntcost_id = r_cc_id.cmpntcost_id
1520: ;
1521:
1522: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from acst_led', 3 );
1523:
1524: -- Delete rows from scst_led
1525: DELETE FROM
1526: cm_scst_led

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

1527: WHERE
1528: cmpntcost_id = r_cc_id.cmpntcost_id
1529: ;
1530:
1531: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from scst_led', 3 );
1532:
1533: -- Update brdn_dtl
1534: UPDATE
1535: cm_brdn_dtl

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

1538: WHERE
1539: cmpntcost_id = r_cc_id.cmpntcost_id
1540: ;
1541:
1542: gmf_util.trace( SQL%ROWCOUNT || ' rows updated in brdn_dtl', 3 );
1543:
1544: -- Finally delete the row itself from cmpt_dtl
1545: DELETE FROM
1546: cm_cmpt_dtl

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

1546: cm_cmpt_dtl
1547: WHERE CURRENT OF c_cc_id
1548: ;
1549:
1550: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from cmpt_dtl', 3 );
1551:
1552: END LOOP;
1553:
1554: END delete_item_costs;

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

1578: RETURN NUMBER IS
1579:
1580: l_frozen_ind NUMBER;
1581: BEGIN
1582: gmf_util.trace( 'Entering verify_frozen_costs', 0 );
1583:
1584: l_frozen_ind := 0;
1585: SELECT nvl(max(rollover_ind),0) INTO l_frozen_ind
1586: FROM

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

1620: l_per_code gmf_period_statuses.period_code%TYPE;
1621: l_per_status gmf_period_statuses.period_status%TYPE;
1622:
1623: BEGIN
1624: gmf_util.trace( 'Entering verify_frozen_periods', 0 );
1625: OPEN cur_froz_periods (p_period_id);
1626: FETCH cur_froz_periods INTO l_per_code, l_per_status;
1627: CLOSE cur_froz_periods;
1628:

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

1745:
1746: FND_FILE.PUT_NAMES('gmfcpoc.log','gmfcpoc.out','/appslog/opm_top/utl/opmm0dv/log');
1747:
1748:
1749: gmf_util.msg_log( 'GMF_CPOC_START' );
1750: /*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, ' ') );
1751:
1752: 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, ' ') );
1753:

Line 1750: /*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, ' ') );

1746: FND_FILE.PUT_NAMES('gmfcpoc.log','gmfcpoc.out','/appslog/opm_top/utl/opmm0dv/log');
1747:
1748:
1749: gmf_util.msg_log( 'GMF_CPOC_START' );
1750: /*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, ' ') );
1751:
1752: 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, ' ') );
1753:
1754: gmf_util.msg_log( 'GMF_CPOC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );

Line 1752: 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, ' ') );

1748:
1749: gmf_util.msg_log( 'GMF_CPOC_START' );
1750: /*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, ' ') );
1751:
1752: 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, ' ') );
1753:
1754: gmf_util.msg_log( 'GMF_CPOC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );
1755: gmf_util.msg_log( 'GMF_CPOC_ITEMCCRANGE', nvl(pi_itemcc_from, ' '), nvl(pi_itemcc_to, ' ') );*/
1756:

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

1750: /*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, ' ') );
1751:
1752: 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, ' ') );
1753:
1754: gmf_util.msg_log( 'GMF_CPOC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );
1755: gmf_util.msg_log( 'GMF_CPOC_ITEMCCRANGE', nvl(pi_itemcc_from, ' '), nvl(pi_itemcc_to, ' ') );*/
1756:
1757:
1758: -- Bug# 1419482 Copy Cost Enhancement. Uday Moogala

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

1751:
1752: 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, ' ') );
1753:
1754: gmf_util.msg_log( 'GMF_CPOC_ITEMRANGE', nvl(pi_item_from, ' '), nvl(pi_item_to, ' ') );
1755: gmf_util.msg_log( 'GMF_CPOC_ITEMCCRANGE', nvl(pi_itemcc_from, ' '), nvl(pi_itemcc_to, ' ') );*/
1756:
1757:
1758: -- Bug# 1419482 Copy Cost Enhancement. Uday Moogala
1759: IF ( (pi_period_code_to IS NULL) AND -- all periods

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

1759: IF ( (pi_period_code_to IS NULL) AND -- all periods
1760: ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))
1761: ) THEN
1762:
1763: gmf_util.msg_log('GMF_CPOC_ALLPERIODS', nvl(pi_calendar_code_to, ' ') ) ;
1764: gmf_util.msg_log('GMF_CPOC_PERIODS_RANGE', nvl(pi_all_periods_from, ' '),
1765: nvl(pi_all_periods_to, ' '), nvl(pi_calendar_code_to, ' ') ) ;
1766:
1767: END IF ;

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

1760: ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))
1761: ) THEN
1762:
1763: gmf_util.msg_log('GMF_CPOC_ALLPERIODS', nvl(pi_calendar_code_to, ' ') ) ;
1764: gmf_util.msg_log('GMF_CPOC_PERIODS_RANGE', nvl(pi_all_periods_from, ' '),
1765: nvl(pi_all_periods_to, ' '), nvl(pi_calendar_code_to, ' ') ) ;
1766:
1767: END IF ;
1768:

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

1770:
1771: l_rem_repl := 0;
1772: IF ( pi_rem_repl = '1' ) THEN -- Remove before copy
1773: l_rem_repl := 1;
1774: gmf_util.msg_log( 'GMF_CPOC_OPTREM' );
1775: ELSE -- Replace before copy
1776: l_rem_repl := 0;
1777: gmf_util.msg_log( 'GMF_CPOC_OPTREP' );
1778: END IF;

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

1773: l_rem_repl := 1;
1774: gmf_util.msg_log( 'GMF_CPOC_OPTREM' );
1775: ELSE -- Replace before copy
1776: l_rem_repl := 0;
1777: gmf_util.msg_log( 'GMF_CPOC_OPTREP' );
1778: END IF;
1779:
1780: gmf_util.log;
1781:

Line 1780: gmf_util.log;

1776: l_rem_repl := 0;
1777: gmf_util.msg_log( 'GMF_CPOC_OPTREP' );
1778: END IF;
1779:
1780: gmf_util.log;
1781:
1782: IF ( (pi_period_code_from = pi_period_code_to) AND
1783: (pi_cost_type_id_from = pi_cost_type_id_to) AND
1784: (pi_calendar_code_from = pi_calendar_code_to) AND

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

1783: (pi_cost_type_id_from = pi_cost_type_id_to) AND
1784: (pi_calendar_code_from = pi_calendar_code_to) AND
1785: (pi_organization_id_from = pi_organization_id_to) ) THEN
1786:
1787: gmf_util.msg_log( 'GMF_CP_SAME_FROMTO' );
1788: RAISE e_same_from_to;
1789: END IF;
1790:
1791: -- Determine what kind of where clause needs to be concatenated

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

1796: IF ( (pi_item_from IS NOT NULL) OR (pi_item_to IS NOT NULL) ) THEN
1797: l_from_range := pi_item_from;
1798: l_to_range := pi_item_to;
1799: l_range_type := G_ITEM;
1800: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 0 );
1801: ELSIF ( (pi_itemcc_from IS NOT NULL) OR (pi_itemcc_to IS NOT NULL) ) THEN
1802: l_from_range := pi_itemcc_from;
1803: l_to_range := pi_itemcc_to;
1804: l_range_type := G_ITEMCC;

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

1801: ELSIF ( (pi_itemcc_from IS NOT NULL) OR (pi_itemcc_to IS NOT NULL) ) THEN
1802: l_from_range := pi_itemcc_from;
1803: l_to_range := pi_itemcc_to;
1804: l_range_type := G_ITEMCC;
1805: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 0 );
1806: ELSE
1807: l_from_range := pi_item_from;
1808: l_to_range := pi_item_to;
1809: l_range_type := G_ITEM;

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

1806: ELSE
1807: l_from_range := pi_item_from;
1808: l_to_range := pi_item_to;
1809: l_range_type := G_ITEM;
1810: gmf_util.trace( 'Range : ' || l_from_range || ' - ' || l_to_range, 0);
1811: END IF;
1812:
1813:
1814: -- Initialize WHO columns

Line 1842: gmf_util.log;

1838: end_copy( 'NORMAL', NULL );
1839: COMMIT;
1840:
1841:
1842: gmf_util.log;
1843: gmf_util.msg_log( 'GMF_CPIC_END' );
1844:
1845: EXCEPTION
1846: WHEN e_no_cost_rows THEN

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

1839: COMMIT;
1840:
1841:
1842: gmf_util.log;
1843: gmf_util.msg_log( 'GMF_CPIC_END' );
1844:
1845: EXCEPTION
1846: WHEN e_no_cost_rows THEN
1847: po_retcode := 0;

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

1998: and org.organization_id = pi_organization_id_from
1999: AND org.org_information_context = 'Accounting Information'
2000: AND gps.cost_type_id = pi_cost_type_id_from;
2001:
2002: gmf_util.msg_log( 'GMF_CPIC_BUR_START' );
2003: gmf_util.log;
2004:
2005: IF ( (pi_period_code_to IS NULL) AND -- all periods
2006: ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))

Line 2003: gmf_util.log;

1999: AND org.org_information_context = 'Accounting Information'
2000: AND gps.cost_type_id = pi_cost_type_id_from;
2001:
2002: gmf_util.msg_log( 'GMF_CPIC_BUR_START' );
2003: gmf_util.log;
2004:
2005: IF ( (pi_period_code_to IS NULL) AND -- all periods
2006: ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))
2007: ) THEN

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

2004:
2005: IF ( (pi_period_code_to IS NULL) AND -- all periods
2006: ((pi_all_periods_from IS NOT NULL) OR (pi_all_periods_to IS NOT NULL))
2007: ) THEN
2008: gmf_util.msg_log('GMF_CPBRD_PERIODS_RANGE', nvl(pi_all_periods_from, ' '),
2009: nvl(pi_all_periods_to, ' '), nvl(pi_calendar_code_to, ' ') ) ;
2010: END IF ;
2011:
2012: l_sql_stmt_b := '';

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

2052: and z.concatenated_segments >= nvl(:b_from_itemcc, z.concatenated_segments)
2053: and z.concatenated_segments <= nvl(:b_to_itemcc, z.concatenated_segments))';
2054:
2055: ELSE
2056: gmf_util.msg_log( 'GMF_CPIC_UNKNOWN' );
2057: RETURN;
2058: END IF;
2059:
2060: l_sql_stmt_b := l_sql_stmt_b ||

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

2063: 'bur.resources, bur.period_id, ' ||
2064: 'bur.cost_type_id, bur.cost_cmpntcls_id, bur.cost_analysis_code'
2065: ;
2066:
2067: gmf_util.trace( 'Burden Sql Stmt: ' || l_sql_stmt_b, 3 );
2068:
2069: IF (pi_organization_id_to IS NOT NULL) THEN -- copying to one organization
2070:
2071: l_sql_org_b := '' ;

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

2165: l_sql_periods_b := l_sql_periods_b || 'ORDER BY c3.start_date' ;
2166: END IF ; -- To Period code check
2167:
2168:
2169: gmf_util.trace( 'Organization Query : ' || l_sql_org_b, 3 );
2170: gmf_util.trace( 'Periods Query : ' || l_sql_periods_b, 3 );
2171:
2172: -- End Bug# 1419482
2173: /* begin sschinch dt 05/2/03 bug 2934528 Bind variable fix */

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

2166: END IF ; -- To Period code check
2167:
2168:
2169: gmf_util.trace( 'Organization Query : ' || l_sql_org_b, 3 );
2170: gmf_util.trace( 'Periods Query : ' || l_sql_periods_b, 3 );
2171:
2172: -- End Bug# 1419482
2173: /* begin sschinch dt 05/2/03 bug 2934528 Bind variable fix */
2174:

Line 2258: gmf_util.log;

2254: pi_from_range, pi_to_range
2255: );
2256: END IF;
2257:
2258: gmf_util.log;
2259: gmf_util.msg_log('GMF_CPBRD_ALLWHSEPRD', l_organization_id_to, l_period_id_to ) ;
2260:
2261: -- Copy the burden costs
2262: l_brdn_rows := 0;

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

2255: );
2256: END IF;
2257:
2258: gmf_util.log;
2259: gmf_util.msg_log('GMF_CPBRD_ALLWHSEPRD', l_organization_id_to, l_period_id_to ) ;
2260:
2261: -- Copy the burden costs
2262: l_brdn_rows := 0;
2263: l_brdn_rows_upd := 0;

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

2261: -- Copy the burden costs
2262: l_brdn_rows := 0;
2263: l_brdn_rows_upd := 0;
2264: l_brdn_rows_ins := 0;
2265: gmf_util.trace('From: Organization-'||pi_organization_id_from||
2266: ' cal-'||pi_calendar_code_from||' prd-'||pi_period_code_from||
2267: ' mthd-'||pi_cost_type_id_from||'itemfrom-'||pi_from_range||
2268: ' item2-'||pi_to_range,0);
2269:

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

2276: LOOP
2277: FETCH cv_brdn_dtl INTO r_brdn_dtl;
2278: EXIT WHEN cv_brdn_dtl%NOTFOUND;
2279:
2280: gmf_util.trace( 'Item = ' || r_brdn_dtl.inventory_item_id ||
2281: ' Rsrc ' || r_brdn_dtl.resources ||
2282: ' cmpt ' || r_brdn_dtl.cost_cmpntcls_id ||
2283: ' ancd ' || r_brdn_dtl.cost_analysis_code ||
2284: ' bqty ' || r_brdn_dtl.burden_qty ||

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

2300: BEGIN
2301: l_assigned_flag := verify_item_assigned_to_org(
2302: r_brdn_dtl.inventory_item_id, l_organization_id_to);
2303:
2304: gmf_util.trace( 'Verify_item_assigned_to_org: Item ' || r_brdn_dtl.inventory_item_id ||
2305: ' Organization ' || l_organization_id_to ||
2306: ' Status = ' || l_assigned_flag, 3 );
2307: IF(l_assigned_flag = 0) THEN
2308: gmf_util.trace( 'Item ' || r_brdn_dtl.inventory_item_id ||

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

2304: gmf_util.trace( 'Verify_item_assigned_to_org: Item ' || r_brdn_dtl.inventory_item_id ||
2305: ' Organization ' || l_organization_id_to ||
2306: ' Status = ' || l_assigned_flag, 3 );
2307: IF(l_assigned_flag = 0) THEN
2308: gmf_util.trace( 'Item ' || r_brdn_dtl.inventory_item_id ||
2309: ' is not assigned to Organization ' || l_organization_id_to, 0 );
2310: RAISE e_item_not_assigned;
2311: END IF;
2312:

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

2422: END LOOP;
2423: CLOSE cv_brdn_dtl;
2424:
2425: IF( l_brdn_rows > 0 ) THEN
2426: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_brdn_rows) );
2427: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS', TO_CHAR(l_brdn_rows_upd), TO_CHAR(l_brdn_rows_ins) );
2428: ELSE
2429: gmf_util.msg_log( 'GMF_CP_NO_ROWS' );
2430: END IF;

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

2423: CLOSE cv_brdn_dtl;
2424:
2425: IF( l_brdn_rows > 0 ) THEN
2426: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_brdn_rows) );
2427: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS', TO_CHAR(l_brdn_rows_upd), TO_CHAR(l_brdn_rows_ins) );
2428: ELSE
2429: gmf_util.msg_log( 'GMF_CP_NO_ROWS' );
2430: END IF;
2431:

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

2425: IF( l_brdn_rows > 0 ) THEN
2426: gmf_util.msg_log( 'GMF_CP_ROWS_SELECTED', TO_CHAR(l_brdn_rows) );
2427: gmf_util.msg_log( 'GMF_CP_ROWS_UPDINS', TO_CHAR(l_brdn_rows_upd), TO_CHAR(l_brdn_rows_ins) );
2428: ELSE
2429: gmf_util.msg_log( 'GMF_CP_NO_ROWS' );
2430: END IF;
2431:
2432: END LOOP ; -- organization loop
2433: CLOSE cv_org;

Line 2437: gmf_util.log;

2433: CLOSE cv_org;
2434: END LOOP ; -- periods loop
2435: CLOSE cv_periods;
2436:
2437: gmf_util.log;
2438: gmf_util.msg_log( 'GMF_CPIC_BUR_END' );
2439:
2440: END copy_burden_dtl;
2441:

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

2434: END LOOP ; -- periods loop
2435: CLOSE cv_periods;
2436:
2437: gmf_util.log;
2438: gmf_util.msg_log( 'GMF_CPIC_BUR_END' );
2439:
2440: END copy_burden_dtl;
2441:
2442: /*****************************************************************************

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

2506: and z.concatenated_segments >= nvl(:b_from_itemcc, z.concatenated_segments)
2507: and z.concatenated_segments <= nvl(:b_to_itemcc, z.concatenated_segments))';
2508:
2509: ELSE
2510: gmf_util.msg_log( 'GMF_CPIC_UNKNOWN' );
2511: RETURN;
2512: END IF;
2513:
2514: gmf_util.trace( 'Burden del sub-qry: ' || l_sub_qry_b, 3 );

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

2510: gmf_util.msg_log( 'GMF_CPIC_UNKNOWN' );
2511: RETURN;
2512: END IF;
2513:
2514: gmf_util.trace( 'Burden del sub-qry: ' || l_sub_qry_b, 3 );
2515:
2516: l_del_stmt_b := l_del_stmt_b || l_sub_qry_b || ' ) ' ;
2517:
2518: gmf_util.trace( ' Burden Del Stmt: ' || l_del_stmt_b, 3 );

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

2514: gmf_util.trace( 'Burden del sub-qry: ' || l_sub_qry_b, 3 );
2515:
2516: l_del_stmt_b := l_del_stmt_b || l_sub_qry_b || ' ) ' ;
2517:
2518: gmf_util.trace( ' Burden Del Stmt: ' || l_del_stmt_b, 3 );
2519:
2520: BEGIN
2521: EXECUTE IMMEDIATE l_del_stmt_b USING
2522: pi_organization_id,

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

2525: EXCEPTION
2526: WHEN OTHERS THEN
2527: fnd_file.put_line(fnd_file.log,'THE ERROR IS :'||SQLERRM);
2528: END;
2529: gmf_util.trace( SQL%ROWCOUNT || ' Rows deleted from Burden Details', 0);
2530:
2531: END delete_burden_costs;
2532:
2533: /*****************************************************************************

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

2551: )
2552: RETURN NUMBER IS
2553: l_assigned_ind NUMBER;
2554: BEGIN
2555: gmf_util.trace( 'Entering verify_item_assigned_to_org', 0 );
2556:
2557: l_assigned_ind := 0;
2558: SELECT count(1) INTO l_assigned_ind
2559: FROM