DBA Data[Home] [Help]

APPS.MSD_COMMON_UTILITIES_LB dependencies on FND_FILE

Line 37: fnd_file.put_line(fnd_file.log,SQLERRM);

33: return x_level_pk;
34:
35: exception
36: when others then
37: fnd_file.put_line(fnd_file.log,SQLERRM);
38: return null ;
39:
40:
41: end get_level_pk ;

Line 282: fnd_file.put_line(fnd_file.log , v_sql_stmt );

278: x_collab_liab := FND_MESSAGE.get_string('MSC', 'MSC_COLLAB_LIAB') ;
279:
280: v_sql_stmt := 'select max(end_date) from '|| x_input_param_rec.planning_server_view_name|| ' where cs_name = '||''''||x_collab_liab||'''' ;
281:
282: fnd_file.put_line(fnd_file.log , v_sql_stmt );
283:
284: OPEN c_stream FOR v_sql_stmt;
285: FETCH c_stream INTO x_max_date;
286: CLOSE c_stream;

Line 396: fnd_file.put_line(fnd_file.log , 'LIABILITY POST PROCESS' );

392: UPDATE MSD_DP_SCENARIO_REVISIONS SET plan_start_date = x_demand_plan_rec.plan_start_date
393: WHERE demand_plan_id = p_demand_plan_id and revision = p_senario_rev_num
394: and scenario_id = x_demand_plan_rec.scenario_id ;
395: /*
396: fnd_file.put_line(fnd_file.log , 'LIABILITY POST PROCESS' );
397: fnd_file.put_line(fnd_file.log , p_scenario_name );
398: fnd_file.put_line(fnd_file.log , p_senario_rev_num );
399: */
400: END LOOP ;

Line 397: fnd_file.put_line(fnd_file.log , p_scenario_name );

393: WHERE demand_plan_id = p_demand_plan_id and revision = p_senario_rev_num
394: and scenario_id = x_demand_plan_rec.scenario_id ;
395: /*
396: fnd_file.put_line(fnd_file.log , 'LIABILITY POST PROCESS' );
397: fnd_file.put_line(fnd_file.log , p_scenario_name );
398: fnd_file.put_line(fnd_file.log , p_senario_rev_num );
399: */
400: END LOOP ;
401:

Line 398: fnd_file.put_line(fnd_file.log , p_senario_rev_num );

394: and scenario_id = x_demand_plan_rec.scenario_id ;
395: /*
396: fnd_file.put_line(fnd_file.log , 'LIABILITY POST PROCESS' );
397: fnd_file.put_line(fnd_file.log , p_scenario_name );
398: fnd_file.put_line(fnd_file.log , p_senario_rev_num );
399: */
400: END LOOP ;
401:
402: --RETURN 1 ;