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.OKS_FULFILL dependencies on FND_FILE

Line 135: fnd_file.put_line(FND_FILE.LOG, 'INSIDE SPLIT RANGE');

131: c_k_index BINARY_INTEGER ;
132: v_total number;
133: x number;
134: begin
135: fnd_file.put_line(FND_FILE.LOG, 'INSIDE SPLIT RANGE');
136: fnd_file.put_line(FND_FILE.LOG, 'p_lo = '|| p_lo);
137: fnd_file.put_line(FND_FILE.LOG, 'p_hi = '|| p_hi);
138: fnd_file.put_line(FND_FILE.LOG, 'p_buckets = '|| p_buckets);
139: if p_buckets = 0 then

Line 136: fnd_file.put_line(FND_FILE.LOG, 'p_lo = '|| p_lo);

132: v_total number;
133: x number;
134: begin
135: fnd_file.put_line(FND_FILE.LOG, 'INSIDE SPLIT RANGE');
136: fnd_file.put_line(FND_FILE.LOG, 'p_lo = '|| p_lo);
137: fnd_file.put_line(FND_FILE.LOG, 'p_hi = '|| p_hi);
138: fnd_file.put_line(FND_FILE.LOG, 'p_buckets = '|| p_buckets);
139: if p_buckets = 0 then
140: return;

Line 137: fnd_file.put_line(FND_FILE.LOG, 'p_hi = '|| p_hi);

133: x number;
134: begin
135: fnd_file.put_line(FND_FILE.LOG, 'INSIDE SPLIT RANGE');
136: fnd_file.put_line(FND_FILE.LOG, 'p_lo = '|| p_lo);
137: fnd_file.put_line(FND_FILE.LOG, 'p_hi = '|| p_hi);
138: fnd_file.put_line(FND_FILE.LOG, 'p_buckets = '|| p_buckets);
139: if p_buckets = 0 then
140: return;
141: end if;

Line 138: fnd_file.put_line(FND_FILE.LOG, 'p_buckets = '|| p_buckets);

134: begin
135: fnd_file.put_line(FND_FILE.LOG, 'INSIDE SPLIT RANGE');
136: fnd_file.put_line(FND_FILE.LOG, 'p_lo = '|| p_lo);
137: fnd_file.put_line(FND_FILE.LOG, 'p_hi = '|| p_hi);
138: fnd_file.put_line(FND_FILE.LOG, 'p_buckets = '|| p_buckets);
139: if p_buckets = 0 then
140: return;
141: end if;
142: c_k_number(1) := 0;

Line 149: fnd_file.put_line(FND_FILE.LOG, 'c_k_number('||c_k_index||') = '|| c_k_number(c_k_index));

145: IF p_org_id is null and p_customer_id is null and p_grp_id is null then
146: for c_chr_csr_no_para in chr_csr_no_para loop
147: c_k_number(c_k_index) := c_chr_csr_no_para.id;
148: c_k_line(c_k_index) := c_chr_csr_no_para.line_id; -- Bug 4915691 --
149: fnd_file.put_line(FND_FILE.LOG, 'c_k_number('||c_k_index||') = '|| c_k_number(c_k_index));
150: c_k_index := c_k_index + 1;
151: end loop;
152: ELSE
153: for c_chr_csr in chr_csr loop

Line 156: fnd_file.put_line(FND_FILE.LOG, 'c_k_number('||c_k_index||') = '|| c_k_number(c_k_index));

152: ELSE
153: for c_chr_csr in chr_csr loop
154: c_k_number(c_k_index) := c_chr_csr.id;
155: c_k_line(c_k_index) := c_chr_csr.line_id; -- Bug 4915691 --
156: fnd_file.put_line(FND_FILE.LOG, 'c_k_number('||c_k_index||') = '|| c_k_number(c_k_index));
157: c_k_index := c_k_index + 1;
158: end loop;
159: END IF;
160:

Line 162: fnd_file.put_line(FND_FILE.LOG, 'v_total = '|| v_total);

158: end loop;
159: END IF;
160:
161: v_total := c_k_number.count;
162: fnd_file.put_line(FND_FILE.LOG, 'v_total = '|| v_total);
163: fnd_file.put_line(FND_FILE.LOG, 'range_arr.count = '|| range_arr.count);
164: if range_arr.count > 0 then
165: -- so we don't overlap high value of previous range
166: l_lo := p_lo + 1;

Line 163: fnd_file.put_line(FND_FILE.LOG, 'range_arr.count = '|| range_arr.count);

159: END IF;
160:
161: v_total := c_k_number.count;
162: fnd_file.put_line(FND_FILE.LOG, 'v_total = '|| v_total);
163: fnd_file.put_line(FND_FILE.LOG, 'range_arr.count = '|| range_arr.count);
164: if range_arr.count > 0 then
165: -- so we don't overlap high value of previous range
166: l_lo := p_lo + 1;
167: end if;

Line 176: fnd_file.put_line(FND_FILE.LOG, 'l_bucket_width = '|| l_bucket_width);

172: l_idx2 := range_arr.count + v_total;
173: range_arr.extend(v_total);
174: Else
175: l_bucket_width := trunc(v_total / p_buckets);
176: fnd_file.put_line(FND_FILE.LOG, 'l_bucket_width = '|| l_bucket_width);
177: range_arr.extend(p_buckets);
178: End if;
179:
180: fnd_file.put_line(FND_FILE.LOG, 'l_idx1 = '|| l_idx1);

Line 180: fnd_file.put_line(FND_FILE.LOG, 'l_idx1 = '|| l_idx1);

176: fnd_file.put_line(FND_FILE.LOG, 'l_bucket_width = '|| l_bucket_width);
177: range_arr.extend(p_buckets);
178: End if;
179:
180: fnd_file.put_line(FND_FILE.LOG, 'l_idx1 = '|| l_idx1);
181: fnd_file.put_line(FND_FILE.LOG, 'l_idx2 = '|| l_idx2);
182: for idx in l_idx1..l_idx2 loop
183:
184: range_arr(idx).lo := c_k_number(c_k_index + ((idx - l_idx1) * l_bucket_width));

Line 181: fnd_file.put_line(FND_FILE.LOG, 'l_idx2 = '|| l_idx2);

177: range_arr.extend(p_buckets);
178: End if;
179:
180: fnd_file.put_line(FND_FILE.LOG, 'l_idx1 = '|| l_idx1);
181: fnd_file.put_line(FND_FILE.LOG, 'l_idx2 = '|| l_idx2);
182: for idx in l_idx1..l_idx2 loop
183:
184: range_arr(idx).lo := c_k_number(c_k_index + ((idx - l_idx1) * l_bucket_width));
185: range_arr(idx).line_id_lo := c_k_line(c_k_index + ((idx - l_idx1) * l_bucket_width)); -- Bug 4915691 --

Line 188: fnd_file.put_line(FND_FILE.LOG, '1...X = ' ||x);

184: range_arr(idx).lo := c_k_number(c_k_index + ((idx - l_idx1) * l_bucket_width));
185: range_arr(idx).line_id_lo := c_k_line(c_k_index + ((idx - l_idx1) * l_bucket_width)); -- Bug 4915691 --
186:
187: x := c_k_index + ((idx - l_idx1) * l_bucket_width);
188: fnd_file.put_line(FND_FILE.LOG, '1...X = ' ||x);
189: if idx < l_idx2 then
190: range_arr(idx).hi := c_k_number(c_k_index+((idx - l_idx1+1) * l_bucket_width)-1);
191: range_arr(idx).line_id_hi := c_k_line(c_k_index+((idx - l_idx1+1) * l_bucket_width)-1); -- Bug 4915691 --
192: x := c_k_index+((idx - l_idx1+1) * l_bucket_width)-1;

Line 193: fnd_file.put_line(FND_FILE.LOG, '2...X = ' ||x);

189: if idx < l_idx2 then
190: range_arr(idx).hi := c_k_number(c_k_index+((idx - l_idx1+1) * l_bucket_width)-1);
191: range_arr(idx).line_id_hi := c_k_line(c_k_index+((idx - l_idx1+1) * l_bucket_width)-1); -- Bug 4915691 --
192: x := c_k_index+((idx - l_idx1+1) * l_bucket_width)-1;
193: fnd_file.put_line(FND_FILE.LOG, '2...X = ' ||x);
194: else
195: range_arr(idx).hi := p_hi;
196: range_arr(idx).line_id_hi := c_k_line(v_total);
197: end if;

Line 198: fnd_file.put_line(FND_FILE.LOG, 'range_arr('||idx||').lo = '|| range_arr(idx).lo);

194: else
195: range_arr(idx).hi := p_hi;
196: range_arr(idx).line_id_hi := c_k_line(v_total);
197: end if;
198: fnd_file.put_line(FND_FILE.LOG, 'range_arr('||idx||').lo = '|| range_arr(idx).lo);
199: fnd_file.put_line(FND_FILE.LOG, 'range_arr('||idx||').hi = '|| range_arr(idx).hi);
200:
201: end loop;
202: fnd_file.put_line(FND_FILE.LOG, 'DONE SPLIT RANGE');

Line 199: fnd_file.put_line(FND_FILE.LOG, 'range_arr('||idx||').hi = '|| range_arr(idx).hi);

195: range_arr(idx).hi := p_hi;
196: range_arr(idx).line_id_hi := c_k_line(v_total);
197: end if;
198: fnd_file.put_line(FND_FILE.LOG, 'range_arr('||idx||').lo = '|| range_arr(idx).lo);
199: fnd_file.put_line(FND_FILE.LOG, 'range_arr('||idx||').hi = '|| range_arr(idx).hi);
200:
201: end loop;
202: fnd_file.put_line(FND_FILE.LOG, 'DONE SPLIT RANGE');
203: end split_range;

Line 202: fnd_file.put_line(FND_FILE.LOG, 'DONE SPLIT RANGE');

198: fnd_file.put_line(FND_FILE.LOG, 'range_arr('||idx||').lo = '|| range_arr(idx).lo);
199: fnd_file.put_line(FND_FILE.LOG, 'range_arr('||idx||').hi = '|| range_arr(idx).hi);
200:
201: end loop;
202: fnd_file.put_line(FND_FILE.LOG, 'DONE SPLIT RANGE');
203: end split_range;
204:
205:
206:

Line 231: fnd_file.put_line(FND_FILE.LOG, 'BEGIN GENERATE RANGE');

227: l_outlier_entries_per_bucket number := 0;
228: modidx integer;
229:
230: begin
231: fnd_file.put_line(FND_FILE.LOG, 'BEGIN GENERATE RANGE');
232: range_arr := rangeArray();
233: -- number of buckets is set to 20
234:
235: fnd_file.put_line(FND_FILE.LOG, 'p_total = ' || p_total);

Line 235: fnd_file.put_line(FND_FILE.LOG, 'p_total = ' || p_total);

231: fnd_file.put_line(FND_FILE.LOG, 'BEGIN GENERATE RANGE');
232: range_arr := rangeArray();
233: -- number of buckets is set to 20
234:
235: fnd_file.put_line(FND_FILE.LOG, 'p_total = ' || p_total);
236: fnd_file.put_line(FND_FILE.LOG, 'p_lo = ' || p_lo);
237: fnd_file.put_line(FND_FILE.LOG, 'p_hi = ' || p_hi);
238: fnd_file.put_line(FND_FILE.LOG, 'l_stdlo = ' || l_stdlo);
239: fnd_file.put_line(FND_FILE.LOG, 'l_stdhi = ' || l_stdhi);

Line 236: fnd_file.put_line(FND_FILE.LOG, 'p_lo = ' || p_lo);

232: range_arr := rangeArray();
233: -- number of buckets is set to 20
234:
235: fnd_file.put_line(FND_FILE.LOG, 'p_total = ' || p_total);
236: fnd_file.put_line(FND_FILE.LOG, 'p_lo = ' || p_lo);
237: fnd_file.put_line(FND_FILE.LOG, 'p_hi = ' || p_hi);
238: fnd_file.put_line(FND_FILE.LOG, 'l_stdlo = ' || l_stdlo);
239: fnd_file.put_line(FND_FILE.LOG, 'l_stdhi = ' || l_stdhi);
240:

Line 237: fnd_file.put_line(FND_FILE.LOG, 'p_hi = ' || p_hi);

233: -- number of buckets is set to 20
234:
235: fnd_file.put_line(FND_FILE.LOG, 'p_total = ' || p_total);
236: fnd_file.put_line(FND_FILE.LOG, 'p_lo = ' || p_lo);
237: fnd_file.put_line(FND_FILE.LOG, 'p_hi = ' || p_hi);
238: fnd_file.put_line(FND_FILE.LOG, 'l_stdlo = ' || l_stdlo);
239: fnd_file.put_line(FND_FILE.LOG, 'l_stdhi = ' || l_stdhi);
240:
241: IF p_total <= 20 THEN

Line 238: fnd_file.put_line(FND_FILE.LOG, 'l_stdlo = ' || l_stdlo);

234:
235: fnd_file.put_line(FND_FILE.LOG, 'p_total = ' || p_total);
236: fnd_file.put_line(FND_FILE.LOG, 'p_lo = ' || p_lo);
237: fnd_file.put_line(FND_FILE.LOG, 'p_hi = ' || p_hi);
238: fnd_file.put_line(FND_FILE.LOG, 'l_stdlo = ' || l_stdlo);
239: fnd_file.put_line(FND_FILE.LOG, 'l_stdhi = ' || l_stdhi);
240:
241: IF p_total <= 20 THEN
242: l_total_buckets := p_total;

Line 239: fnd_file.put_line(FND_FILE.LOG, 'l_stdhi = ' || l_stdhi);

235: fnd_file.put_line(FND_FILE.LOG, 'p_total = ' || p_total);
236: fnd_file.put_line(FND_FILE.LOG, 'p_lo = ' || p_lo);
237: fnd_file.put_line(FND_FILE.LOG, 'p_hi = ' || p_hi);
238: fnd_file.put_line(FND_FILE.LOG, 'l_stdlo = ' || l_stdlo);
239: fnd_file.put_line(FND_FILE.LOG, 'l_stdhi = ' || l_stdhi);
240:
241: IF p_total <= 20 THEN
242: l_total_buckets := p_total;
243: ELSE

Line 247: fnd_file.put_line(FND_FILE.LOG, 'l_total_buckets = ' || l_total_buckets);

243: ELSE
244: l_total_buckets := MAX_JOBS;
245: END IF;
246:
247: fnd_file.put_line(FND_FILE.LOG, 'l_total_buckets = ' || l_total_buckets);
248:
249: IF p_total <= 20 THEN
250: -- split_range(p_lo, p_hi, l_total_buckets);
251: split_range(p_lo, p_hi, P_default_date,

Line 272: fnd_file.put_line(FND_FILE.LOG, 'END GENERATE RANGE');

268: p_Customer_id,
269: p_Grp_Id,
270: l_total_buckets);
271: END IF;
272: fnd_file.put_line(FND_FILE.LOG, 'END GENERATE RANGE');
273: return l_total_buckets;
274:
275: /*
276: l_outlier_buckets := l_total_buckets * (1 - l_stddev_percent);

Line 277: fnd_file.put_line(FND_FILE.LOG, 'l_outlier_buckets = ' || l_outlier_buckets);

273: return l_total_buckets;
274:
275: /*
276: l_outlier_buckets := l_total_buckets * (1 - l_stddev_percent);
277: fnd_file.put_line(FND_FILE.LOG, 'l_outlier_buckets = ' || l_outlier_buckets);
278: if l_outlier_buckets > 0 then
279: l_outlier_entries_per_bucket := p_total * (1 - l_stddev_percent)
280: / l_outlier_buckets ;
281: fnd_file.put_line(FND_FILE.LOG, 'l_outlier_entries_per_bucket = ' || l_outlier_entries_per_bucket);

Line 281: fnd_file.put_line(FND_FILE.LOG, 'l_outlier_entries_per_bucket = ' || l_outlier_entries_per_bucket);

277: fnd_file.put_line(FND_FILE.LOG, 'l_outlier_buckets = ' || l_outlier_buckets);
278: if l_outlier_buckets > 0 then
279: l_outlier_entries_per_bucket := p_total * (1 - l_stddev_percent)
280: / l_outlier_buckets ;
281: fnd_file.put_line(FND_FILE.LOG, 'l_outlier_entries_per_bucket = ' || l_outlier_entries_per_bucket);
282: end if;
283: for idx in 1..l_outlier_buckets loop
284: modidx := mod(idx,2);
285: -- alternate assignment between hi and lo buckets

Line 286: fnd_file.put_line(FND_FILE.LOG, 'modidx = ' || modidx);

282: end if;
283: for idx in 1..l_outlier_buckets loop
284: modidx := mod(idx,2);
285: -- alternate assignment between hi and lo buckets
286: fnd_file.put_line(FND_FILE.LOG, 'modidx = ' || modidx);
287: if modidx = 1
288: AND (p_hi - (l_hi_buckets+1) * l_outlier_entries_per_bucket)
289: > l_stdhi then
290: -- allocate buckets for positive outliers

Line 292: fnd_file.put_line(FND_FILE.LOG, '---- l_hi_buckets = ' || l_hi_buckets);

288: AND (p_hi - (l_hi_buckets+1) * l_outlier_entries_per_bucket)
289: > l_stdhi then
290: -- allocate buckets for positive outliers
291: l_hi_buckets := l_hi_buckets + 1;
292: fnd_file.put_line(FND_FILE.LOG, '---- l_hi_buckets = ' || l_hi_buckets);
293: elsif modidx = 0
294: AND (p_lo + (l_lo_buckets+1) * l_outlier_entries_per_bucket)
295: < l_stdlo then
296: -- allocate buckets for negative outliers

Line 298: fnd_file.put_line(FND_FILE.LOG, '---- l_lo_buckets = ' || l_lo_buckets);

294: AND (p_lo + (l_lo_buckets+1) * l_outlier_entries_per_bucket)
295: < l_stdlo then
296: -- allocate buckets for negative outliers
297: l_lo_buckets := l_lo_buckets + 1;
298: fnd_file.put_line(FND_FILE.LOG, '---- l_lo_buckets = ' || l_lo_buckets);
299: -- else min or max has been consumed, save bucket for middle
300: end if;
301: end loop;
302:

Line 316: fnd_file.put_line(FND_FILE.LOG, 'p_lo = ' || p_lo);

312: l_stdhi := p_hi;
313: end if;
314: */
315: /*
316: fnd_file.put_line(FND_FILE.LOG, 'p_lo = ' || p_lo);
317: fnd_file.put_line(FND_FILE.LOG, 'p_hi = ' || p_hi);
318: fnd_file.put_line(FND_FILE.LOG, 'l_stdlo = ' || l_stdlo);
319: fnd_file.put_line(FND_FILE.LOG, 'l_stdhi = ' || l_stdhi);
320: --fnd_file.put_line(FND_FILE.LOG, 'l_lo_buckets = ' || l_lo_buckets);

Line 317: fnd_file.put_line(FND_FILE.LOG, 'p_hi = ' || p_hi);

313: end if;
314: */
315: /*
316: fnd_file.put_line(FND_FILE.LOG, 'p_lo = ' || p_lo);
317: fnd_file.put_line(FND_FILE.LOG, 'p_hi = ' || p_hi);
318: fnd_file.put_line(FND_FILE.LOG, 'l_stdlo = ' || l_stdlo);
319: fnd_file.put_line(FND_FILE.LOG, 'l_stdhi = ' || l_stdhi);
320: --fnd_file.put_line(FND_FILE.LOG, 'l_lo_buckets = ' || l_lo_buckets);
321: --fnd_file.put_line(FND_FILE.LOG, 'l_hi_buckets = ' || l_hi_buckets);

Line 318: fnd_file.put_line(FND_FILE.LOG, 'l_stdlo = ' || l_stdlo);

314: */
315: /*
316: fnd_file.put_line(FND_FILE.LOG, 'p_lo = ' || p_lo);
317: fnd_file.put_line(FND_FILE.LOG, 'p_hi = ' || p_hi);
318: fnd_file.put_line(FND_FILE.LOG, 'l_stdlo = ' || l_stdlo);
319: fnd_file.put_line(FND_FILE.LOG, 'l_stdhi = ' || l_stdhi);
320: --fnd_file.put_line(FND_FILE.LOG, 'l_lo_buckets = ' || l_lo_buckets);
321: --fnd_file.put_line(FND_FILE.LOG, 'l_hi_buckets = ' || l_hi_buckets);
322: --fnd_file.put_line(FND_FILE.LOG, 'l_std_buckets = ' || l_std_buckets);

Line 319: fnd_file.put_line(FND_FILE.LOG, 'l_stdhi = ' || l_stdhi);

315: /*
316: fnd_file.put_line(FND_FILE.LOG, 'p_lo = ' || p_lo);
317: fnd_file.put_line(FND_FILE.LOG, 'p_hi = ' || p_hi);
318: fnd_file.put_line(FND_FILE.LOG, 'l_stdlo = ' || l_stdlo);
319: fnd_file.put_line(FND_FILE.LOG, 'l_stdhi = ' || l_stdhi);
320: --fnd_file.put_line(FND_FILE.LOG, 'l_lo_buckets = ' || l_lo_buckets);
321: --fnd_file.put_line(FND_FILE.LOG, 'l_hi_buckets = ' || l_hi_buckets);
322: --fnd_file.put_line(FND_FILE.LOG, 'l_std_buckets = ' || l_std_buckets);
323: -- ranges for negative outliers

Line 320: --fnd_file.put_line(FND_FILE.LOG, 'l_lo_buckets = ' || l_lo_buckets);

316: fnd_file.put_line(FND_FILE.LOG, 'p_lo = ' || p_lo);
317: fnd_file.put_line(FND_FILE.LOG, 'p_hi = ' || p_hi);
318: fnd_file.put_line(FND_FILE.LOG, 'l_stdlo = ' || l_stdlo);
319: fnd_file.put_line(FND_FILE.LOG, 'l_stdhi = ' || l_stdhi);
320: --fnd_file.put_line(FND_FILE.LOG, 'l_lo_buckets = ' || l_lo_buckets);
321: --fnd_file.put_line(FND_FILE.LOG, 'l_hi_buckets = ' || l_hi_buckets);
322: --fnd_file.put_line(FND_FILE.LOG, 'l_std_buckets = ' || l_std_buckets);
323: -- ranges for negative outliers
324: split_range(p_lo, l_stdlo, 2);

Line 321: --fnd_file.put_line(FND_FILE.LOG, 'l_hi_buckets = ' || l_hi_buckets);

317: fnd_file.put_line(FND_FILE.LOG, 'p_hi = ' || p_hi);
318: fnd_file.put_line(FND_FILE.LOG, 'l_stdlo = ' || l_stdlo);
319: fnd_file.put_line(FND_FILE.LOG, 'l_stdhi = ' || l_stdhi);
320: --fnd_file.put_line(FND_FILE.LOG, 'l_lo_buckets = ' || l_lo_buckets);
321: --fnd_file.put_line(FND_FILE.LOG, 'l_hi_buckets = ' || l_hi_buckets);
322: --fnd_file.put_line(FND_FILE.LOG, 'l_std_buckets = ' || l_std_buckets);
323: -- ranges for negative outliers
324: split_range(p_lo, l_stdlo, 2);
325: -- ranges for +/-1 stddev from mean

Line 322: --fnd_file.put_line(FND_FILE.LOG, 'l_std_buckets = ' || l_std_buckets);

318: fnd_file.put_line(FND_FILE.LOG, 'l_stdlo = ' || l_stdlo);
319: fnd_file.put_line(FND_FILE.LOG, 'l_stdhi = ' || l_stdhi);
320: --fnd_file.put_line(FND_FILE.LOG, 'l_lo_buckets = ' || l_lo_buckets);
321: --fnd_file.put_line(FND_FILE.LOG, 'l_hi_buckets = ' || l_hi_buckets);
322: --fnd_file.put_line(FND_FILE.LOG, 'l_std_buckets = ' || l_std_buckets);
323: -- ranges for negative outliers
324: split_range(p_lo, l_stdlo, 2);
325: -- ranges for +/-1 stddev from mean
326: split_range(l_stdlo, l_stdhi, 16);

Line 329: fnd_file.put_line(FND_FILE.LOG, 'l_total_buckets = ' || l_total_buckets);

325: -- ranges for +/-1 stddev from mean
326: split_range(l_stdlo, l_stdhi, 16);
327: -- ranges for positive outliers
328: split_range(l_stdhi, p_hi, 2);
329: fnd_file.put_line(FND_FILE.LOG, 'l_total_buckets = ' || l_total_buckets);
330: return l_total_buckets;
331: */
332:
333: end generate_ranges;

Line 427: fnd_file.put_line(FND_FILE.LOG, 'P_parallel = ' || use_parallel_worker);

423: FETCH l_fulfill_agg_csr INTO l_agg_rec;
424: CLOSE l_fulfill_agg_csr;
425: END IF;
426: use_parallel_worker := 'Y';
427: fnd_file.put_line(FND_FILE.LOG, 'P_parallel = ' || use_parallel_worker);
428:
429: END IF;
430:
431: fnd_file.put_line(FND_FILE.LOG, 'P_parallel = ' || use_parallel_worker);

Line 431: fnd_file.put_line(FND_FILE.LOG, 'P_parallel = ' || use_parallel_worker);

427: fnd_file.put_line(FND_FILE.LOG, 'P_parallel = ' || use_parallel_worker);
428:
429: END IF;
430:
431: fnd_file.put_line(FND_FILE.LOG, 'P_parallel = ' || use_parallel_worker);
432: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.minid = ' || l_agg_rec.minid);
433: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.maxid = ' || l_agg_rec.maxid);
434: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.avgid = ' || l_agg_rec.avgid);
435: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.stdid = ' || l_agg_rec.stdid);

Line 432: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.minid = ' || l_agg_rec.minid);

428:
429: END IF;
430:
431: fnd_file.put_line(FND_FILE.LOG, 'P_parallel = ' || use_parallel_worker);
432: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.minid = ' || l_agg_rec.minid);
433: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.maxid = ' || l_agg_rec.maxid);
434: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.avgid = ' || l_agg_rec.avgid);
435: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.stdid = ' || l_agg_rec.stdid);
436: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.total = ' || l_agg_rec.total);

Line 433: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.maxid = ' || l_agg_rec.maxid);

429: END IF;
430:
431: fnd_file.put_line(FND_FILE.LOG, 'P_parallel = ' || use_parallel_worker);
432: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.minid = ' || l_agg_rec.minid);
433: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.maxid = ' || l_agg_rec.maxid);
434: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.avgid = ' || l_agg_rec.avgid);
435: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.stdid = ' || l_agg_rec.stdid);
436: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.total = ' || l_agg_rec.total);
437:

Line 434: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.avgid = ' || l_agg_rec.avgid);

430:
431: fnd_file.put_line(FND_FILE.LOG, 'P_parallel = ' || use_parallel_worker);
432: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.minid = ' || l_agg_rec.minid);
433: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.maxid = ' || l_agg_rec.maxid);
434: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.avgid = ' || l_agg_rec.avgid);
435: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.stdid = ' || l_agg_rec.stdid);
436: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.total = ' || l_agg_rec.total);
437:
438: IF use_parallel_worker = 'Y' THEN

Line 435: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.stdid = ' || l_agg_rec.stdid);

431: fnd_file.put_line(FND_FILE.LOG, 'P_parallel = ' || use_parallel_worker);
432: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.minid = ' || l_agg_rec.minid);
433: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.maxid = ' || l_agg_rec.maxid);
434: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.avgid = ' || l_agg_rec.avgid);
435: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.stdid = ' || l_agg_rec.stdid);
436: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.total = ' || l_agg_rec.total);
437:
438: IF use_parallel_worker = 'Y' THEN
439: /* Added by sjanakir for Bug# 5568285 (FP Bug for 5442268) */

Line 436: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.total = ' || l_agg_rec.total);

432: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.minid = ' || l_agg_rec.minid);
433: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.maxid = ' || l_agg_rec.maxid);
434: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.avgid = ' || l_agg_rec.avgid);
435: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.stdid = ' || l_agg_rec.stdid);
436: fnd_file.put_line(FND_FILE.LOG, 'l_agg_rec.total = ' || l_agg_rec.total);
437:
438: IF use_parallel_worker = 'Y' THEN
439: /* Added by sjanakir for Bug# 5568285 (FP Bug for 5442268) */
440: IF l_agg_rec.total = 0 THEN

Line 441: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*Subscription Contract to Order Creation**** ');

437:
438: IF use_parallel_worker = 'Y' THEN
439: /* Added by sjanakir for Bug# 5568285 (FP Bug for 5442268) */
440: IF l_agg_rec.total = 0 THEN
441: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************Subscription Contract to Order Creation****************** ');
442: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
443: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
444: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************No subscription elements to be interfaced**************** ');
445: END IF;

Line 442: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');

438: IF use_parallel_worker = 'Y' THEN
439: /* Added by sjanakir for Bug# 5568285 (FP Bug for 5442268) */
440: IF l_agg_rec.total = 0 THEN
441: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************Subscription Contract to Order Creation****************** ');
442: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
443: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
444: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************No subscription elements to be interfaced**************** ');
445: END IF;
446: /* Addition Ends */

Line 443: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');

439: /* Added by sjanakir for Bug# 5568285 (FP Bug for 5442268) */
440: IF l_agg_rec.total = 0 THEN
441: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************Subscription Contract to Order Creation****************** ');
442: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
443: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
444: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************No subscription elements to be interfaced**************** ');
445: END IF;
446: /* Addition Ends */
447:

Line 444: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*No subscription elements to be interfaced** ');

440: IF l_agg_rec.total = 0 THEN
441: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************Subscription Contract to Order Creation****************** ');
442: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
443: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ');
444: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************No subscription elements to be interfaced**************** ');
445: END IF;
446: /* Addition Ends */
447:
448: l_subrequests := generate_ranges(l_agg_rec.minid, l_agg_rec.maxid,

Line 455: fnd_file.put_line(FND_FILE.LOG, 'l_subrequests = ' || l_subrequests);

451: P_Customer_id ,
452: P_Grp_Id , l_agg_rec.avgid,
453: l_agg_rec.stdid, l_agg_rec.total);
454:
455: fnd_file.put_line(FND_FILE.LOG, 'l_subrequests = ' || l_subrequests);
456: FOR idx in 1..l_subrequests LOOP
457:
458: l_ret := FND_REQUEST.submit_request('OKS','OKSKTOCR',
459: null, null, -- TRUE means isSubRequest

Line 471: fnd_file.put_line(FND_FILE.LOG, 'idx = ' || idx);

467: /* Addition Ends */
468: range_arr(idx).lo, range_arr(idx).hi,
469: range_arr(idx).line_id_lo, range_arr(idx).line_id_hi); -- Bug 4915691 --
470:
471: fnd_file.put_line(FND_FILE.LOG, 'idx = ' || idx);
472: fnd_file.put_line(FND_FILE.LOG, 'l_ret.lo = ' || range_arr(idx).lo);
473: fnd_file.put_line(FND_FILE.LOG, 'l_ret.hi = ' || range_arr(idx).hi);
474: -- fnd_file.put_line(FND_FILE.LOG, 'l_ret = ' || l_ret);
475:

Line 472: fnd_file.put_line(FND_FILE.LOG, 'l_ret.lo = ' || range_arr(idx).lo);

468: range_arr(idx).lo, range_arr(idx).hi,
469: range_arr(idx).line_id_lo, range_arr(idx).line_id_hi); -- Bug 4915691 --
470:
471: fnd_file.put_line(FND_FILE.LOG, 'idx = ' || idx);
472: fnd_file.put_line(FND_FILE.LOG, 'l_ret.lo = ' || range_arr(idx).lo);
473: fnd_file.put_line(FND_FILE.LOG, 'l_ret.hi = ' || range_arr(idx).hi);
474: -- fnd_file.put_line(FND_FILE.LOG, 'l_ret = ' || l_ret);
475:
476: IF (l_ret = 0) then

Line 473: fnd_file.put_line(FND_FILE.LOG, 'l_ret.hi = ' || range_arr(idx).hi);

469: range_arr(idx).line_id_lo, range_arr(idx).line_id_hi); -- Bug 4915691 --
470:
471: fnd_file.put_line(FND_FILE.LOG, 'idx = ' || idx);
472: fnd_file.put_line(FND_FILE.LOG, 'l_ret.lo = ' || range_arr(idx).lo);
473: fnd_file.put_line(FND_FILE.LOG, 'l_ret.hi = ' || range_arr(idx).hi);
474: -- fnd_file.put_line(FND_FILE.LOG, 'l_ret = ' || l_ret);
475:
476: IF (l_ret = 0) then
477: errbuf := fnd_message.get;

Line 474: -- fnd_file.put_line(FND_FILE.LOG, 'l_ret = ' || l_ret);

470:
471: fnd_file.put_line(FND_FILE.LOG, 'idx = ' || idx);
472: fnd_file.put_line(FND_FILE.LOG, 'l_ret.lo = ' || range_arr(idx).lo);
473: fnd_file.put_line(FND_FILE.LOG, 'l_ret.hi = ' || range_arr(idx).hi);
474: -- fnd_file.put_line(FND_FILE.LOG, 'l_ret = ' || l_ret);
475:
476: IF (l_ret = 0) then
477: errbuf := fnd_message.get;
478: retcode := 2;

Line 479: FND_FILE.PUT_LINE (FND_FILE.LOG,

475:
476: IF (l_ret = 0) then
477: errbuf := fnd_message.get;
478: retcode := 2;
479: FND_FILE.PUT_LINE (FND_FILE.LOG,
480: 'Sub-request failed to submit: ' || errbuf);
481: return;
482: ELSE
483: FND_FILE.PUT_LINE (FND_FILE.LOG,

Line 483: FND_FILE.PUT_LINE (FND_FILE.LOG,

479: FND_FILE.PUT_LINE (FND_FILE.LOG,
480: 'Sub-request failed to submit: ' || errbuf);
481: return;
482: ELSE
483: FND_FILE.PUT_LINE (FND_FILE.LOG,
484: 'Sub-request '||to_char(l_ret)||' submitted');
485: END IF;
486: END LOOP;
487: ELSE