APPS.QPR_CREATE_DEMO_DATA dependencies on FND_FILE

Line 50: fnd_file.put_line(fnd_file.log, 'The Install Data Type needs to be specified.');

46:
47: else
48: if p_instance_type is null then
49: retcode := 1;
50: fnd_file.put_line(fnd_file.log, 'The Install Data Type needs to be specified.');
51: return;
52:
53: else
54: begin

Line 61: fnd_file.put_line(fnd_file.log, 'Instance:'|| p_instance_id || ' does not exist');

57: where instance_id = p_instance_id;
58: exception
59: when others then
60: retcode := 2;
61: fnd_file.put_line(fnd_file.log, 'Instance:'|| p_instance_id || ' does not exist');
62: return;
63: end;
64: load_data(errbuf, retcode, p_instance_id, p_instance_type);
65: end if;

Line 74: fnd_file.put_line(fnd_file.log,'Unexpected error '||substr(sqlerrm,1200));

70: exception
71: WHEN NO_DATA_FOUND THEN
72: retcode := 2;
73: errbuf := FND_MESSAGE.GET;
74: fnd_file.put_line(fnd_file.log,'Unexpected error '||substr(sqlerrm,1200));
75: Return;
76: end;
77:
78:

Line 150: fnd_file.put_line(fnd_file.log,'Inserting Dimension Data');

146: end;
147: instance_id := l_instance_id;
148: if (l_dim_exists = 0) then
149:
150: fnd_file.put_line(fnd_file.log,'Inserting Dimension Data');
151:
152: Insert into QPR_DIMENSION_VALUES
153: ("DIM_VALUE_ID","INSTANCE_ID","DIM_CODE","HIERARCHY_CODE",
154: "LEVEL1_VALUE","LEVEL1_DESC","LEVEL1_ATTRIBUTE1","LEVEL1_ATTRIBUTE2",

Line 44045: fnd_file.put_line(fnd_file.log,'Dimension Values already exist');

44041: sysdate,1,sysdate,1,1,null,null,null,null);
44042:
44043:
44044: else
44045: fnd_file.put_line(fnd_file.log,'Dimension Values already exist');
44046: end if;
44047:
44048: end insert_dim_values;
44049:

Line 44076: fnd_file.put_line(fnd_file.log,'Inserting Measure Data');

44072: instance_id := l_instance_id;
44073: if (l_meas_exists = 0) then
44074:
44075:
44076: fnd_file.put_line(fnd_file.log,'Inserting Measure Data');
44077:
44078: INSERT INTO QPR_MEASURE_DATA ("MEASURE_VALUE_ID", "INSTANCE_ID",
44079: "MEASURE_TYPE_CODE", "ORD_LEVEL_VALUE", "TIME_LEVEL_VALUE", "PRD_LEVEL_VALUE",
44080: "GEO_LEVEL_VALUE", "CUS_LEVEL_VALUE", "ORG_LEVEL_VALUE", "REP_LEVEL_VALUE",

Line 127755: fnd_file.put_line(fnd_file.log,'Measure Data already exist');

127751:
127752: qpr_special_etl.update_pr_segment(errbuf, retcode, instance_id, fnd_date.date_to_canonical(min_date), fnd_date.date_to_canonical(max_date));
127753:
127754: else
127755: fnd_file.put_line(fnd_file.log,'Measure Data already exist');
127756: end if;
127757:
127758:
127759: end insert_meas_data;

Line 127771: fnd_file.put_line(fnd_file.log,'Inserting Policies, Pricing Segments, Scopes');

127767: l_exist_policy number := 0;
127768: psg_level1_value number;
127769:
127770: begin
127771: fnd_file.put_line(fnd_file.log,'Inserting Policies, Pricing Segments, Scopes');
127772:
127773: l_exist_policy := 0;
127774: if (l_instance_type = 1000) then
127775: begin

Line 128191: fnd_file.put_line(fnd_file.log,'Inserting Transformation Rules');

128187: is
128188: l_exist_transf number := 0;
128189: begin
128190:
128191: fnd_file.put_line(fnd_file.log,'Inserting Transformation Rules');
128192:
128193:
128194: l_exist_transf := 0;
128195: begin