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

Line 30: fnd_file.put_line(FND_FILE.LOG, 'Begin create pattern slabs');

26:
27: if g_call_from_setup = 'Y' then
28: oe_debug_pub.add('Begin create pattern slabs');
29: else
30: fnd_file.put_line(FND_FILE.LOG, 'Begin create pattern slabs');
31: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
32: end if;
33: l_no_of_threads := p_no_of_threads;
34: if l_no_of_threads > p_total_lines then

Line 31: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

27: if g_call_from_setup = 'Y' then
28: oe_debug_pub.add('Begin create pattern slabs');
29: else
30: fnd_file.put_line(FND_FILE.LOG, 'Begin create pattern slabs');
31: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
32: end if;
33: l_no_of_threads := p_no_of_threads;
34: if l_no_of_threads > p_total_lines then
35: l_no_of_threads := p_total_lines;

Line 43: fnd_file.put_line(FND_FILE.LOG, 'Total lines:'||p_total_lines);

39: if g_call_from_setup = 'Y' then
40: oe_debug_pub.add('Total lines:'||p_total_lines);
41: oe_debug_pub.add('l_gap:'||l_gap);
42: else
43: fnd_file.put_line(FND_FILE.LOG, 'Total lines:'||p_total_lines);
44: fnd_file.put_line(FND_FILE.LOG, 'l_gap:'||l_gap);
45: end if;
46: if p_total_lines > 0 then
47: for line_rec in list_line loop

Line 44: fnd_file.put_line(FND_FILE.LOG, 'l_gap:'||l_gap);

40: oe_debug_pub.add('Total lines:'||p_total_lines);
41: oe_debug_pub.add('l_gap:'||l_gap);
42: else
43: fnd_file.put_line(FND_FILE.LOG, 'Total lines:'||p_total_lines);
44: fnd_file.put_line(FND_FILE.LOG, 'l_gap:'||l_gap);
45: end if;
46: if p_total_lines > 0 then
47: for line_rec in list_line loop
48:

Line 81: fnd_file.put_line(FND_FILE.LOG, 'End create pattern slabs');

77: g_pattern_upg_slab_table(l_worker_count).low_list_line_id := l_min_line;
78: g_pattern_upg_slab_table(l_worker_count).high_list_line_id := l_max_line;
79:
80: end if;
81: fnd_file.put_line(FND_FILE.LOG, 'End create pattern slabs');
82: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
83:
84: end create_pattern_slabs;
85:

Line 82: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

78: g_pattern_upg_slab_table(l_worker_count).high_list_line_id := l_max_line;
79:
80: end if;
81: fnd_file.put_line(FND_FILE.LOG, 'End create pattern slabs');
82: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
83:
84: end create_pattern_slabs;
85:
86: procedure remove_duplicate_patterns

Line 103: fnd_file.put_line(FND_FILE.LOG, 'In Remove_Duplicate_Patterns');

99: where c.pattern_type = a.pattern_type
100: and c.pattern_string = a.pattern_string);
101: begin
102:
103: fnd_file.put_line(FND_FILE.LOG, 'In Remove_Duplicate_Patterns');
104: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
105:
106: g_pattern_pattern_id_final_tbl.delete;
107: g_pattern_pat_type_final_tbl.delete;

Line 104: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

100: and c.pattern_string = a.pattern_string);
101: begin
102:
103: fnd_file.put_line(FND_FILE.LOG, 'In Remove_Duplicate_Patterns');
104: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
105:
106: g_pattern_pattern_id_final_tbl.delete;
107: g_pattern_pat_type_final_tbl.delete;
108: g_pattern_pat_string_final_tbl.delete;

Line 118: fnd_file.put_line(FND_FILE.LOG, 'No of Duplicate_Patterns='||g_pattern_pattern_id_final_tbl.count);

114: g_pattern_pat_string_final_tbl,
115: g_pattern_pattern_id_final_tbl;
116: CLOSE c_dupl_pattern;
117:
118: fnd_file.put_line(FND_FILE.LOG, 'No of Duplicate_Patterns='||g_pattern_pattern_id_final_tbl.count);
119: if g_pattern_pattern_id_final_tbl.count > 0 then
120: for i in 1..g_pattern_pattern_id_final_tbl.count
121: loop
122: select min(c.pattern_id)

Line 160: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

156: g_pattern_pattern_id_final_tbl.delete;
157: g_pattern_pat_type_final_tbl.delete;
158: g_pattern_pat_string_final_tbl.delete;
159:
160: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
161: fnd_file.put_line(FND_FILE.LOG, 'COMMIT in remove_duplicate_patterns');
162: commit;
163:
164: EXCEPTION

Line 161: fnd_file.put_line(FND_FILE.LOG, 'COMMIT in remove_duplicate_patterns');

157: g_pattern_pat_type_final_tbl.delete;
158: g_pattern_pat_string_final_tbl.delete;
159:
160: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
161: fnd_file.put_line(FND_FILE.LOG, 'COMMIT in remove_duplicate_patterns');
162: commit;
163:
164: EXCEPTION
165: WHEN OTHERS THEN

Line 169: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Remove_Duplicate_Patterns ' || SQLERRM );

165: WHEN OTHERS THEN
166: if g_call_from_setup = 'Y' then
167: oe_debug_pub.add('ATTR_GRP_PVT.Remove_Duplicate_Patterns ' || SQLERRM);
168: else
169: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Remove_Duplicate_Patterns ' || SQLERRM );
170: end if;
171:
172: end remove_duplicate_patterns;
173:

Line 203: fnd_file.put_line(FND_FILE.LOG, 'Java Engine Installed');

199:
200: BEGIN
201: -- Check Java Engine Installed profile
202: if QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' then
203: fnd_file.put_line(FND_FILE.LOG, 'Java Engine Installed');
204: fnd_file.put_line(FND_FILE.LOG, 'p_list_header_id ' || p_list_header_id);
205: fnd_file.put_line(FND_FILE.LOG, 'p_low_list_line_id ' || p_low_list_line_id);
206: fnd_file.put_line(FND_FILE.LOG, 'p_high_list_line_id ' || p_high_list_line_id);
207: fnd_file.put_line(FND_FILE.LOG, 'p_no_of_threads ' || p_no_of_threads);

Line 204: fnd_file.put_line(FND_FILE.LOG, 'p_list_header_id ' || p_list_header_id);

200: BEGIN
201: -- Check Java Engine Installed profile
202: if QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' then
203: fnd_file.put_line(FND_FILE.LOG, 'Java Engine Installed');
204: fnd_file.put_line(FND_FILE.LOG, 'p_list_header_id ' || p_list_header_id);
205: fnd_file.put_line(FND_FILE.LOG, 'p_low_list_line_id ' || p_low_list_line_id);
206: fnd_file.put_line(FND_FILE.LOG, 'p_high_list_line_id ' || p_high_list_line_id);
207: fnd_file.put_line(FND_FILE.LOG, 'p_no_of_threads ' || p_no_of_threads);
208: fnd_file.put_line(FND_FILE.LOG, 'p_spawned_request ' || p_spawned_request);

Line 205: fnd_file.put_line(FND_FILE.LOG, 'p_low_list_line_id ' || p_low_list_line_id);

201: -- Check Java Engine Installed profile
202: if QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' then
203: fnd_file.put_line(FND_FILE.LOG, 'Java Engine Installed');
204: fnd_file.put_line(FND_FILE.LOG, 'p_list_header_id ' || p_list_header_id);
205: fnd_file.put_line(FND_FILE.LOG, 'p_low_list_line_id ' || p_low_list_line_id);
206: fnd_file.put_line(FND_FILE.LOG, 'p_high_list_line_id ' || p_high_list_line_id);
207: fnd_file.put_line(FND_FILE.LOG, 'p_no_of_threads ' || p_no_of_threads);
208: fnd_file.put_line(FND_FILE.LOG, 'p_spawned_request ' || p_spawned_request);
209:

Line 206: fnd_file.put_line(FND_FILE.LOG, 'p_high_list_line_id ' || p_high_list_line_id);

202: if QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' then
203: fnd_file.put_line(FND_FILE.LOG, 'Java Engine Installed');
204: fnd_file.put_line(FND_FILE.LOG, 'p_list_header_id ' || p_list_header_id);
205: fnd_file.put_line(FND_FILE.LOG, 'p_low_list_line_id ' || p_low_list_line_id);
206: fnd_file.put_line(FND_FILE.LOG, 'p_high_list_line_id ' || p_high_list_line_id);
207: fnd_file.put_line(FND_FILE.LOG, 'p_no_of_threads ' || p_no_of_threads);
208: fnd_file.put_line(FND_FILE.LOG, 'p_spawned_request ' || p_spawned_request);
209:
210: select sid into v_sid from v$session where audsid = userenv('SESSIONID');

Line 207: fnd_file.put_line(FND_FILE.LOG, 'p_no_of_threads ' || p_no_of_threads);

203: fnd_file.put_line(FND_FILE.LOG, 'Java Engine Installed');
204: fnd_file.put_line(FND_FILE.LOG, 'p_list_header_id ' || p_list_header_id);
205: fnd_file.put_line(FND_FILE.LOG, 'p_low_list_line_id ' || p_low_list_line_id);
206: fnd_file.put_line(FND_FILE.LOG, 'p_high_list_line_id ' || p_high_list_line_id);
207: fnd_file.put_line(FND_FILE.LOG, 'p_no_of_threads ' || p_no_of_threads);
208: fnd_file.put_line(FND_FILE.LOG, 'p_spawned_request ' || p_spawned_request);
209:
210: select sid into v_sid from v$session where audsid = userenv('SESSIONID');
211:

Line 208: fnd_file.put_line(FND_FILE.LOG, 'p_spawned_request ' || p_spawned_request);

204: fnd_file.put_line(FND_FILE.LOG, 'p_list_header_id ' || p_list_header_id);
205: fnd_file.put_line(FND_FILE.LOG, 'p_low_list_line_id ' || p_low_list_line_id);
206: fnd_file.put_line(FND_FILE.LOG, 'p_high_list_line_id ' || p_high_list_line_id);
207: fnd_file.put_line(FND_FILE.LOG, 'p_no_of_threads ' || p_no_of_threads);
208: fnd_file.put_line(FND_FILE.LOG, 'p_spawned_request ' || p_spawned_request);
209:
210: select sid into v_sid from v$session where audsid = userenv('SESSIONID');
211:
212: fnd_file.put_line(FND_FILE.LOG, 'session ID = ' || v_sid);

Line 212: fnd_file.put_line(FND_FILE.LOG, 'session ID = ' || v_sid);

208: fnd_file.put_line(FND_FILE.LOG, 'p_spawned_request ' || p_spawned_request);
209:
210: select sid into v_sid from v$session where audsid = userenv('SESSIONID');
211:
212: fnd_file.put_line(FND_FILE.LOG, 'session ID = ' || v_sid);
213: else
214: fnd_file.put_line(FND_FILE.LOG, 'Java Engine not Installed');
215: return;
216: end if;

Line 214: fnd_file.put_line(FND_FILE.LOG, 'Java Engine not Installed');

210: select sid into v_sid from v$session where audsid = userenv('SESSIONID');
211:
212: fnd_file.put_line(FND_FILE.LOG, 'session ID = ' || v_sid);
213: else
214: fnd_file.put_line(FND_FILE.LOG, 'Java Engine not Installed');
215: return;
216: end if;
217:
218: --refresh the pattern data

Line 224: fnd_file.put_line(FND_FILE.LOG, 'l_req_data : ' || l_req_data);

220: if p_no_of_threads is NULL or p_no_of_threads = 0 then
221: l_no_of_threads := 1;
222: end if;
223: l_req_data := fnd_conc_global.request_data;
224: fnd_file.put_line(FND_FILE.LOG, 'l_req_data : ' || l_req_data);
225: if l_req_data is not NULL then
226: remove_duplicate_patterns;
227: return;
228: end if;

Line 231: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

227: return;
228: end if;
229:
230: select hsecs into l_start_time from v$timer;
231: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
232:
233: if p_list_header_id is null then
234: -- like upgrade, refresh everything related to patterns
235: IF (FND_INSTALLATION.GET_APP_INFO('QP', l_status, l_industry, l_qp_schema))

Line 245: fnd_file.put_line(FND_FILE.LOG, 'Deleted all records from 3 Pattern Master tables');

241: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.qp_patterns';
242: EXECUTE IMMEDIATE l_stmt;
243: END IF;
244:
245: fnd_file.put_line(FND_FILE.LOG, 'Deleted all records from 3 Pattern Master tables');
246: else
247: -- refresh only for the passed list_header_id
248: delete from qp_attribute_groups
249: where list_header_id = p_list_header_id

Line 251: fnd_file.put_line(FND_FILE.LOG, 'Deleted records from qp_attribute_groups for HP for list_header_id:'||p_list_header_id);

247: -- refresh only for the passed list_header_id
248: delete from qp_attribute_groups
249: where list_header_id = p_list_header_id
250: and list_line_id = -1;
251: fnd_file.put_line(FND_FILE.LOG, 'Deleted records from qp_attribute_groups for HP for list_header_id:'||p_list_header_id);
252:
253: end if;
254: Update_Qual_Segment_id(p_list_header_id, null, -1, -1);
255: generate_hp_atgrps(p_list_header_id, null);

Line 270: fnd_file.put_line(FND_FILE.LOG, 'l_total_lines ' || l_total_lines);

266: from qp_list_lines
267: where qualification_ind in (8,10,12,14,28,30, 4,6,20,22)
268: and list_header_id = p_list_header_id;
269: END IF;
270: fnd_file.put_line(FND_FILE.LOG, 'l_total_lines ' || l_total_lines);
271: if l_total_lines > 0 then
272: create_pattern_slabs(l_total_lines, p_list_header_id, l_no_of_threads);
273: l_slab_count := g_pattern_upg_slab_table.count;
274: fnd_file.put_line(FND_FILE.LOG, 'l_slab_count ' || l_slab_count);

Line 274: fnd_file.put_line(FND_FILE.LOG, 'l_slab_count ' || l_slab_count);

270: fnd_file.put_line(FND_FILE.LOG, 'l_total_lines ' || l_total_lines);
271: if l_total_lines > 0 then
272: create_pattern_slabs(l_total_lines, p_list_header_id, l_no_of_threads);
273: l_slab_count := g_pattern_upg_slab_table.count;
274: fnd_file.put_line(FND_FILE.LOG, 'l_slab_count ' || l_slab_count);
275: l_count := 1;
276: loop
277: l_new_request_id := fnd_request.submit_request(
278: 'QP',

Line 291: fnd_file.put_line(FND_FILE.LOG, 'err_buff ' || err_buff);

287: 'Y');
288: if l_new_request_id = 0 then
289: retcode := 2;
290: err_buff := fnd_message.get;
291: fnd_file.put_line(FND_FILE.LOG, 'err_buff ' || err_buff);
292: return;
293: end if;
294: FND_FILE.PUT_LINE(FND_FILE.LOG , 'Child '||l_count||' request_id: '||l_new_request_id);
295:

Line 294: FND_FILE.PUT_LINE(FND_FILE.LOG , 'Child '||l_count||' request_id: '||l_new_request_id);

290: err_buff := fnd_message.get;
291: fnd_file.put_line(FND_FILE.LOG, 'err_buff ' || err_buff);
292: return;
293: end if;
294: FND_FILE.PUT_LINE(FND_FILE.LOG , 'Child '||l_count||' request_id: '||l_new_request_id);
295:
296: l_count := l_count + 1;
297: exit when l_count > l_slab_count;
298: end loop;

Line 301: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

297: exit when l_count > l_slab_count;
298: end loop;
299:
300: select hsecs into l_end_time from v$timer;
301: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
302: fnd_file.put_line(fnd_file.log, 'Time taken for the header process (sec):' ||(l_end_time - l_start_time)/100);
303:
304: fnd_conc_global.set_req_globals(conc_status => 'PAUSED',
305: request_data => to_char(l_count));

Line 302: fnd_file.put_line(fnd_file.log, 'Time taken for the header process (sec):' ||(l_end_time - l_start_time)/100);

298: end loop;
299:
300: select hsecs into l_end_time from v$timer;
301: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
302: fnd_file.put_line(fnd_file.log, 'Time taken for the header process (sec):' ||(l_end_time - l_start_time)/100);
303:
304: fnd_conc_global.set_req_globals(conc_status => 'PAUSED',
305: request_data => to_char(l_count));
306:

Line 307: fnd_file.put_line(FND_FILE.LOG, 'Time after parent request PAUSE over :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

303:
304: fnd_conc_global.set_req_globals(conc_status => 'PAUSED',
305: request_data => to_char(l_count));
306:
307: fnd_file.put_line(FND_FILE.LOG, 'Time after parent request PAUSE over :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
308:
309: else -- if l_total_lines > 0
310: if p_list_header_id is null then
311: -- like upgrade, refresh everything related to patterns

Line 342: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

338: end if; -- if p_spawned_request = 'N'
339:
340: if p_spawned_request = 'Y' then
341: select hsecs into l_start_time from v$timer;
342: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
343: if p_list_header_id is null then
344: -- like upgrade, refresh everything related to patterns
345: update /*+ index_asc(lines QP_LIST_LINES_PK) */ qp_list_lines lines
346: set pattern_id = null,

Line 388: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

384: update_pp_lines(p_list_header_id,
385: p_low_list_line_id,
386: p_high_list_line_id);
387: select hsecs into l_end_time from v$timer;
388: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
389: fnd_file.put_line(fnd_file.log, 'Time taken for the line process (sec):' ||(l_end_time - l_start_time)/100);
390: end if; -- if p_spawned_request = 'Y'
391: -- commit the changes done so far
392: fnd_file.put_line(FND_FILE.LOG, 'COMMIT in Pattern_Upgrade');

Line 389: fnd_file.put_line(fnd_file.log, 'Time taken for the line process (sec):' ||(l_end_time - l_start_time)/100);

385: p_low_list_line_id,
386: p_high_list_line_id);
387: select hsecs into l_end_time from v$timer;
388: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
389: fnd_file.put_line(fnd_file.log, 'Time taken for the line process (sec):' ||(l_end_time - l_start_time)/100);
390: end if; -- if p_spawned_request = 'Y'
391: -- commit the changes done so far
392: fnd_file.put_line(FND_FILE.LOG, 'COMMIT in Pattern_Upgrade');
393: commit;

Line 392: fnd_file.put_line(FND_FILE.LOG, 'COMMIT in Pattern_Upgrade');

388: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
389: fnd_file.put_line(fnd_file.log, 'Time taken for the line process (sec):' ||(l_end_time - l_start_time)/100);
390: end if; -- if p_spawned_request = 'Y'
391: -- commit the changes done so far
392: fnd_file.put_line(FND_FILE.LOG, 'COMMIT in Pattern_Upgrade');
393: commit;
394:
395:
396: err_buff := '';

Line 403: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Pattern_Upgrade ' || SQLERRM );

399: when others then
400: if g_call_from_setup = 'Y' then
401: oe_debug_pub.add('ATTR_GRP_PVT.Pattern_Upgrade ' || SQLERRM);
402: else
403: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Pattern_Upgrade ' || SQLERRM );
404: end if;
405: err_buff := 'Others Error in procedure Pattern_Upgrade';
406: retcode := 1;
407:

Line 454: fnd_file.put_line(FND_FILE.LOG, 'Begin generate_hp_atgrps');

450: -- delete the data from cursor, temp and final tables to start with
451: if g_call_from_setup = 'Y' then
452: oe_debug_pub.add('Begin generate_hp_atgrps');
453: else
454: fnd_file.put_line(FND_FILE.LOG, 'Begin generate_hp_atgrps');
455: end if;
456: Reset_c_tables;
457: Reset_tmp_tables;
458: Reset_final_tables;

Line 491: fnd_file.put_line(FND_FILE.LOG, 'End generate_hp_atgrps');

487: end if;
488: if g_call_from_setup = 'Y' then
489: oe_debug_pub.add('End generate_hp_atgrps');
490: else
491: fnd_file.put_line(FND_FILE.LOG, 'End generate_hp_atgrps');
492: end if;
493:
494: EXCEPTION
495: WHEN OTHERS THEN

Line 499: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Generate_Hp_Atgrps ' || SQLERRM );

495: WHEN OTHERS THEN
496: if g_call_from_setup = 'Y' then
497: oe_debug_pub.add('ATTR_GRP_PVT.Generate_Hp_Atgrps ' || SQLERRM);
498: else
499: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Generate_Hp_Atgrps ' || SQLERRM );
500: end if;
501:
502: end generate_hp_atgrps;
503:

Line 643: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Generate_Lp_Atgrps ' || SQLERRM );

639: WHEN OTHERS THEN
640: if g_call_from_setup = 'Y' then
641: oe_debug_pub.add('ATTR_GRP_PVT.Generate_Lp_Atgrps ' || SQLERRM);
642: else
643: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Generate_Lp_Atgrps ' || SQLERRM );
644: end if;
645:
646: end generate_lp_atgrps;
647:

Line 722: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_Pp_Lines ' || SQLERRM );

718: WHEN OTHERS THEN
719: if g_call_from_setup = 'Y' then
720: oe_debug_pub.add('ATTR_GRP_PVT.Update_Pp_Lines ' || SQLERRM);
721: else
722: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_Pp_Lines ' || SQLERRM );
723: end if;
724:
725: end update_pp_lines;
726:

Line 749: fnd_file.put_line(FND_FILE.LOG, 'Start process_c_tables - Pattern type '||p_pattern_type);

745: else
746: QP_PREQ_GRP.Set_QP_Debug;
747: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
748: IF l_debug = FND_API.G_TRUE THEN
749: fnd_file.put_line(FND_FILE.LOG, 'Start process_c_tables - Pattern type '||p_pattern_type);
750: fnd_file.put_line(FND_FILE.LOG, 'cursor tables total = ' || g_list_header_id_c_tbl.count);
751: END IF;
752: end if;
753:

Line 750: fnd_file.put_line(FND_FILE.LOG, 'cursor tables total = ' || g_list_header_id_c_tbl.count);

746: QP_PREQ_GRP.Set_QP_Debug;
747: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
748: IF l_debug = FND_API.G_TRUE THEN
749: fnd_file.put_line(FND_FILE.LOG, 'Start process_c_tables - Pattern type '||p_pattern_type);
750: fnd_file.put_line(FND_FILE.LOG, 'cursor tables total = ' || g_list_header_id_c_tbl.count);
751: END IF;
752: end if;
753:
754: if g_list_header_id_c_tbl.count > 0 then

Line 766: fnd_file.put_line(FND_FILE.LOG, 'i = ' || i ||

762: ', operator = ' || g_comparison_opr_code_c_tbl(i));
763: --oe_debug_pub.add('l_old_list_header_id ' || l_old_list_header_id);
764: --oe_debug_pub.add('l_old_list_line_id ' || l_old_list_line_id);
765: elsif l_debug = FND_API.G_TRUE then
766: fnd_file.put_line(FND_FILE.LOG, 'i = ' || i ||
767: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
768: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
769: ', group = ' || g_qual_grouping_no_c_tbl(i) ||
770: ', operator = ' || g_comparison_opr_code_c_tbl(i));

Line 771: --fnd_file.put_line(FND_FILE.LOG, 'l_old_list_header_id ' || l_old_list_header_id);

767: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
768: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
769: ', group = ' || g_qual_grouping_no_c_tbl(i) ||
770: ', operator = ' || g_comparison_opr_code_c_tbl(i));
771: --fnd_file.put_line(FND_FILE.LOG, 'l_old_list_header_id ' || l_old_list_header_id);
772: --fnd_file.put_line(FND_FILE.LOG, 'l_old_list_line_id ' || l_old_list_line_id);
773: end if;
774:
775: if (i > 1

Line 772: --fnd_file.put_line(FND_FILE.LOG, 'l_old_list_line_id ' || l_old_list_line_id);

768: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
769: ', group = ' || g_qual_grouping_no_c_tbl(i) ||
770: ', operator = ' || g_comparison_opr_code_c_tbl(i));
771: --fnd_file.put_line(FND_FILE.LOG, 'l_old_list_header_id ' || l_old_list_header_id);
772: --fnd_file.put_line(FND_FILE.LOG, 'l_old_list_line_id ' || l_old_list_line_id);
773: end if;
774:
775: if (i > 1
776: and (g_list_header_id_c_tbl(i) <> l_old_list_header_id

Line 788: fnd_file.put_line(FND_FILE.LOG, 'inserting data for ' || G_LINES_PER_INSERT || ' lines');

784: if l_line_counter >= G_LINES_PER_INSERT then
785: if g_call_from_setup = 'Y' then
786: oe_debug_pub.add('inserting data for ' || G_LINES_PER_INSERT || ' lines');
787: elsif l_debug = FND_API.G_TRUE then
788: fnd_file.put_line(FND_FILE.LOG, 'inserting data for ' || G_LINES_PER_INSERT || ' lines');
789: end if;
790: populate_atgrps;
791: if p_pattern_type = 'LP' then
792: update_list_lines_cache_key;

Line 797: fnd_file.put_line(FND_FILE.LOG, 'committing data for ' || G_LINES_PER_INSERT || ' lines');

793: end if;
794: reset_final_tables;
795: if g_call_from_setup <> 'Y' then
796: if l_debug = FND_API.G_TRUE then
797: fnd_file.put_line(FND_FILE.LOG, 'committing data for ' || G_LINES_PER_INSERT || ' lines');
798: end if;
799: commit;
800: end if;
801: l_line_counter := 0;

Line 813: fnd_file.put_line(FND_FILE.LOG, 'record exists in temp table for current group');

809: if g_call_from_setup = 'Y' then
810: oe_debug_pub.add('record exists in temp table for current group');
811: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));
812: else
813: fnd_file.put_line(FND_FILE.LOG, 'record exists in temp table for current group');
814: fnd_file.put_line(FND_FILE.LOG, 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));
815: end if;
816: */
817:

Line 814: fnd_file.put_line(FND_FILE.LOG, 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));

810: oe_debug_pub.add('record exists in temp table for current group');
811: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));
812: else
813: fnd_file.put_line(FND_FILE.LOG, 'record exists in temp table for current group');
814: fnd_file.put_line(FND_FILE.LOG, 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));
815: end if;
816: */
817:
818: -- if grp_no -1 record is getting updated then update the other grps records for pattern string,

Line 828: fnd_file.put_line(FND_FILE.LOG, 'other_grp_index = ' || other_grp_index);

824: /*
825: if g_call_from_setup = 'Y' then
826: oe_debug_pub.add('other_grp_index = ' || other_grp_index);
827: else
828: fnd_file.put_line(FND_FILE.LOG, 'other_grp_index = ' || other_grp_index);
829: end if;
830: */
831: -- do not update the -1 grp no record as -1 grp no record will be updated automatically
832: -- outside this loop

Line 939: fnd_file.put_line(FND_FILE.LOG, 'record DOES NOT exists in temp table for current group');

935: if g_call_from_setup = 'Y' then
936: oe_debug_pub.add('record DOES NOT exists in temp table for current group');
937: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));
938: else
939: fnd_file.put_line(FND_FILE.LOG, 'record DOES NOT exists in temp table for current group');
940: fnd_file.put_line(FND_FILE.LOG, 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));
941: end if;
942: */
943:

Line 940: fnd_file.put_line(FND_FILE.LOG, 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));

936: oe_debug_pub.add('record DOES NOT exists in temp table for current group');
937: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));
938: else
939: fnd_file.put_line(FND_FILE.LOG, 'record DOES NOT exists in temp table for current group');
940: fnd_file.put_line(FND_FILE.LOG, 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));
941: end if;
942: */
943:
944: l_prefix_value_from_null_grp := 'N';

Line 955: fnd_file.put_line(FND_FILE.LOG, 'other_grp_index = ' || other_grp_index);

951: /*
952: if g_call_from_setup = 'Y' then
953: oe_debug_pub.add('other_grp_index = ' || other_grp_index);
954: else
955: fnd_file.put_line(FND_FILE.LOG, 'other_grp_index = ' || other_grp_index);
956: end if;
957: */
958:
959: if (g_start_date_active_q_c_tbl(i) is not null

Line 1157: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Process_C_Tables ' || SQLERRM );

1153: WHEN OTHERS THEN
1154: if g_call_from_setup = 'Y' then
1155: oe_debug_pub.add('ATTR_GRP_PVT.Process_C_Tables ' || SQLERRM);
1156: else
1157: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Process_C_Tables ' || SQLERRM );
1158: end if;
1159:
1160: end process_c_tables;
1161:

Line 1181: fnd_file.put_line(FND_FILE.LOG, 'PP cursor tables total = ' || g_list_header_id_c_tbl.count);

1177: else
1178: QP_PREQ_GRP.Set_QP_Debug;
1179: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1180: IF l_debug = FND_API.G_TRUE THEN
1181: fnd_file.put_line(FND_FILE.LOG, 'PP cursor tables total = ' || g_list_header_id_c_tbl.count);
1182: END IF;
1183: end if;
1184:
1185: l_first_pa_rec_for_line := 'Y';

Line 1198: fnd_file.put_line(FND_FILE.LOG, 'PP i = ' || i ||

1194: ', operator = ' || g_comparison_opr_code_c_tbl(i));
1195: --oe_debug_pub.add('PP l_old_list_header_id ' || l_old_list_header_id);
1196: --oe_debug_pub.add('PP l_old_list_line_id ' || l_old_list_line_id);
1197: elsif l_debug = FND_API.G_TRUE then
1198: fnd_file.put_line(FND_FILE.LOG, 'PP i = ' || i ||
1199: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
1200: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
1201: ', operator = ' || g_comparison_opr_code_c_tbl(i));
1202: --fnd_file.put_line(FND_FILE.LOG, 'PP l_old_list_header_id ' || l_old_list_header_id);

Line 1202: --fnd_file.put_line(FND_FILE.LOG, 'PP l_old_list_header_id ' || l_old_list_header_id);

1198: fnd_file.put_line(FND_FILE.LOG, 'PP i = ' || i ||
1199: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
1200: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
1201: ', operator = ' || g_comparison_opr_code_c_tbl(i));
1202: --fnd_file.put_line(FND_FILE.LOG, 'PP l_old_list_header_id ' || l_old_list_header_id);
1203: --fnd_file.put_line(FND_FILE.LOG, 'PP l_old_list_line_id ' || l_old_list_line_id);
1204: end if;
1205:
1206: if (i > 1

Line 1203: --fnd_file.put_line(FND_FILE.LOG, 'PP l_old_list_line_id ' || l_old_list_line_id);

1199: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
1200: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
1201: ', operator = ' || g_comparison_opr_code_c_tbl(i));
1202: --fnd_file.put_line(FND_FILE.LOG, 'PP l_old_list_header_id ' || l_old_list_header_id);
1203: --fnd_file.put_line(FND_FILE.LOG, 'PP l_old_list_line_id ' || l_old_list_line_id);
1204: end if;
1205:
1206: if (i > 1
1207: and (g_list_header_id_c_tbl(i) <> l_old_list_header_id

Line 1220: fnd_file.put_line(FND_FILE.LOG, 'inserting data for ' || G_LINES_PER_INSERT || ' lines');

1216: if l_line_counter >= G_LINES_PER_INSERT then
1217: if g_call_from_setup = 'Y' then
1218: oe_debug_pub.add('inserting data for ' || G_LINES_PER_INSERT || ' lines');
1219: elsif l_debug = FND_API.G_TRUE then
1220: fnd_file.put_line(FND_FILE.LOG, 'inserting data for ' || G_LINES_PER_INSERT || ' lines');
1221: end if;
1222: update_list_lines;
1223: reset_final_tables;
1224: if g_call_from_setup <> 'Y' then

Line 1226: fnd_file.put_line(FND_FILE.LOG, 'committing data for ' || G_LINES_PER_INSERT || ' lines');

1222: update_list_lines;
1223: reset_final_tables;
1224: if g_call_from_setup <> 'Y' then
1225: if l_debug = FND_API.G_TRUE then
1226: fnd_file.put_line(FND_FILE.LOG, 'committing data for ' || G_LINES_PER_INSERT || ' lines');
1227: end if;
1228: commit;
1229: end if;
1230: l_line_counter := 0;

Line 1332: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Process_C_Tables_Pp ' || SQLERRM );

1328: WHEN OTHERS THEN
1329: if g_call_from_setup = 'Y' then
1330: oe_debug_pub.add('ATTR_GRP_PVT.Process_C_Tables_Pp ' || SQLERRM);
1331: else
1332: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Process_C_Tables_Pp ' || SQLERRM );
1333: end if;
1334:
1335: end process_c_tables_pp;
1336:

Line 1350: fnd_file.put_line(FND_FILE.LOG, 'Moving data from temp table to final table');

1346: if g_call_from_setup = 'Y' then
1347: oe_debug_pub.add('Moving data from temp table to final table');
1348: oe_debug_pub.add('temp tables total = ' || g_list_header_id_tmp_tbl.count);
1349: else
1350: fnd_file.put_line(FND_FILE.LOG, 'Moving data from temp table to final table');
1351: fnd_file.put_line(FND_FILE.LOG, 'temp tables total = ' || g_list_header_id_tmp_tbl.count);
1352: end if;
1353: */
1354:

Line 1351: fnd_file.put_line(FND_FILE.LOG, 'temp tables total = ' || g_list_header_id_tmp_tbl.count);

1347: oe_debug_pub.add('Moving data from temp table to final table');
1348: oe_debug_pub.add('temp tables total = ' || g_list_header_id_tmp_tbl.count);
1349: else
1350: fnd_file.put_line(FND_FILE.LOG, 'Moving data from temp table to final table');
1351: fnd_file.put_line(FND_FILE.LOG, 'temp tables total = ' || g_list_header_id_tmp_tbl.count);
1352: end if;
1353: */
1354:
1355: -- find out whether any qual groups exists other than -1

Line 1365: fnd_file.put_line(FND_FILE.LOG, 'l_other_grp_exists = ' || l_other_grp_exists);

1361: /*
1362: if g_call_from_setup = 'Y' then
1363: oe_debug_pub.add('l_other_grp_exists = ' || l_other_grp_exists);
1364: else
1365: fnd_file.put_line(FND_FILE.LOG, 'l_other_grp_exists = ' || l_other_grp_exists);
1366: end if;
1367: */
1368:
1369: -- now loop thru the atgrp temp tables and move to the final atgrp tables

Line 1377: fnd_file.put_line(FND_FILE.LOG, 'grouping no = ' || grp_no_index);

1373: /*
1374: if g_call_from_setup = 'Y' then
1375: oe_debug_pub.add('grouping no = ' || grp_no_index);
1376: else
1377: fnd_file.put_line(FND_FILE.LOG, 'grouping no = ' || grp_no_index);
1378: end if;
1379: */
1380: -- if other groups exists then skip -1 record i.e. do not move temp table data to final table
1381: if l_other_grp_exists = 'Y' and grp_no_index = -1 then

Line 1394: fnd_file.put_line(FND_FILE.LOG, 'Pattern_id='||l_pattern_id);

1390: /*
1391: if g_call_from_setup = 'Y' then
1392: oe_debug_pub.add('Pattern_id='||l_pattern_id);
1393: else
1394: fnd_file.put_line(FND_FILE.LOG, 'Pattern_id='||l_pattern_id);
1395: end if;
1396: */
1397:
1398: -- maintain data in qp_pattern_phases

Line 1410: fnd_file.put_line(FND_FILE.LOG, 'move the data from tmp tables to final tables for qp_attribute_groups');

1406: /*
1407: if g_call_from_setup = 'Y' then
1408: oe_debug_pub.add('move the data from tmp tables to final tables for qp_attribute_groups');
1409: else
1410: fnd_file.put_line(FND_FILE.LOG, 'move the data from tmp tables to final tables for qp_attribute_groups');
1411: end if;
1412: */
1413:
1414: l_atgrp_final_index := g_list_header_id_final_tbl.count + 1;

Line 1448: fnd_file.put_line(FND_FILE.LOG, 'cache_key should be just list_header_id ');

1444: /*
1445: if g_call_from_setup = 'Y' then
1446: oe_debug_pub.add('cache_key should be just list_header_id ');
1447: else
1448: fnd_file.put_line(FND_FILE.LOG, 'cache_key should be just list_header_id ');
1449: end if;
1450: */
1451: else
1452: g_cache_key_final_tbl(l_atgrp_final_index) := g_cache_key_tmp_tbl(grp_no_index);

Line 1457: fnd_file.put_line(FND_FILE.LOG, 'cache_key should be standard OR null');

1453: /*
1454: if g_call_from_setup = 'Y' then
1455: oe_debug_pub.add('cache_key should be standard OR null');
1456: else
1457: fnd_file.put_line(FND_FILE.LOG, 'cache_key should be standard OR null');
1458: end if;
1459: */
1460: end if;
1461:

Line 1485: fnd_file.put_line(FND_FILE.LOG, 'End Moving data from temp table to final table');

1481: /*
1482: if g_call_from_setup = 'Y' then
1483: oe_debug_pub.add('End Moving data from temp table to final table');
1484: else
1485: fnd_file.put_line(FND_FILE.LOG, 'End Moving data from temp table to final table');
1486: end if;
1487: */
1488:
1489: EXCEPTION

Line 1494: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Move_Data_From_Tmp_To_Final ' || SQLERRM );

1490: WHEN OTHERS THEN
1491: if g_call_from_setup = 'Y' then
1492: oe_debug_pub.add('ATTR_GRP_PVT.Move_Data_From_Tmp_To_Final ' || SQLERRM);
1493: else
1494: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Move_Data_From_Tmp_To_Final ' || SQLERRM );
1495: end if;
1496:
1497: END Move_data_from_tmp_to_final;
1498:

Line 1508: fnd_file.put_line(FND_FILE.LOG, 'Begin Populate_patterns');

1504: /*
1505: if g_call_from_setup = 'Y' then
1506: oe_debug_pub.add('Begin Populate_patterns');
1507: else
1508: fnd_file.put_line(FND_FILE.LOG, 'Begin Populate_patterns');
1509: end if;
1510: */
1511:
1512: FORALL i in 1 .. G_pattern_pattern_id_final_tbl.count

Line 1565: fnd_file.put_line(FND_FILE.LOG, 'End Populate_patterns');

1561: if g_call_from_setup = 'Y' then
1562: oe_debug_pub.add('End Populate_patterns');
1563: else
1564: commit;
1565: fnd_file.put_line(FND_FILE.LOG, 'End Populate_patterns');
1566: end if;
1567: */
1568: EXCEPTION
1569: WHEN OTHERS THEN

Line 1573: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Populate_Patterns ' || SQLERRM );

1569: WHEN OTHERS THEN
1570: if g_call_from_setup = 'Y' then
1571: oe_debug_pub.add('ATTR_GRP_PVT.Populate_Patterns ' || SQLERRM);
1572: else
1573: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Populate_Patterns ' || SQLERRM );
1574: end if;
1575: raise;
1576: END Populate_Patterns;
1577:

Line 1600: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_List_Lines ' || SQLERRM );

1596: WHEN OTHERS THEN
1597: if g_call_from_setup = 'Y' then
1598: oe_debug_pub.add('ATTR_GRP_PVT.Update_List_Lines ' || SQLERRM);
1599: else
1600: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_List_Lines ' || SQLERRM );
1601: end if;
1602:
1603: end update_list_lines;
1604:

Line 1623: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_List_Lines_Cache_Key ' || SQLERRM );

1619: WHEN OTHERS THEN
1620: if g_call_from_setup = 'Y' then
1621: oe_debug_pub.add('ATTR_GRP_PVT.Update_List_Lines_Cache_Key ' || SQLERRM);
1622: else
1623: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_List_Lines_Cache_Key ' || SQLERRM );
1624: end if;
1625:
1626: end update_list_lines_cache_key;
1627:

Line 1695: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Populate_Atgrps ' || SQLERRM );

1691: WHEN OTHERS THEN
1692: if g_call_from_setup = 'Y' then
1693: oe_debug_pub.add('ATTR_GRP_PVT.Populate_Atgrps ' || SQLERRM);
1694: else
1695: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Populate_Atgrps ' || SQLERRM );
1696: end if;
1697: raise;
1698: END Populate_Atgrps;
1699:

Line 1707: fnd_file.put_line(FND_FILE.LOG, 'Reset temp tables');

1703: /*
1704: if g_call_from_setup = 'Y' then
1705: oe_debug_pub.add('Reset temp tables');
1706: else
1707: fnd_file.put_line(FND_FILE.LOG, 'Reset temp tables');
1708: end if;
1709: */
1710: g_list_header_id_tmp_tbl.delete;
1711: g_list_line_id_tmp_tbl.delete;

Line 1747: fnd_file.put_line(FND_FILE.LOG, 'Begin get_pattern_id');

1743: /*
1744: if g_call_from_setup = 'Y' then
1745: oe_debug_pub.add('Begin get_pattern_id');
1746: else
1747: fnd_file.put_line(FND_FILE.LOG, 'Begin get_pattern_id');
1748: end if;
1749: */
1750: begin
1751: l_pattern_to_be_created := 'N';

Line 1771: fnd_file.put_line(FND_FILE.LOG, 'l_pattern_to_be_created='||l_pattern_to_be_created);

1767: /*
1768: if g_call_from_setup = 'Y' then
1769: oe_debug_pub.add('l_pattern_to_be_created='||l_pattern_to_be_created);
1770: else
1771: fnd_file.put_line(FND_FILE.LOG, 'l_pattern_to_be_created='||l_pattern_to_be_created);
1772: end if;
1773: */
1774:
1775: -- move the data from temp tables to final tables for qp_patterns, if new pattern to be created

Line 1804: fnd_file.put_line(FND_FILE.LOG, 'End get_pattern_id');

1800: /*
1801: if g_call_from_setup = 'Y' then
1802: oe_debug_pub.add('End get_pattern_id');
1803: else
1804: fnd_file.put_line(FND_FILE.LOG, 'End get_pattern_id');
1805: end if;
1806: */
1807:
1808: return l_pattern_id;

Line 1815: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Get_Pattern_Id ' || SQLERRM );

1811: WHEN OTHERS THEN
1812: if g_call_from_setup = 'Y' then
1813: oe_debug_pub.add('ATTR_GRP_PVT.Get_Pattern_Id ' || SQLERRM);
1814: else
1815: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Get_Pattern_Id ' || SQLERRM );
1816: end if;
1817:
1818: end get_pattern_id;
1819:

Line 1859: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Reset_Final_Tables ' || SQLERRM );

1855: WHEN OTHERS THEN
1856: if g_call_from_setup = 'Y' then
1857: oe_debug_pub.add('ATTR_GRP_PVT.Reset_Final_Tables ' || SQLERRM);
1858: else
1859: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Reset_Final_Tables ' || SQLERRM );
1860: end if;
1861:
1862: end reset_final_tables;
1863:

Line 1894: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Reset_C_Tables ' || SQLERRM );

1890: WHEN OTHERS THEN
1891: if g_call_from_setup = 'Y' then
1892: oe_debug_pub.add('ATTR_GRP_PVT.Reset_C_Tables ' || SQLERRM);
1893: else
1894: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Reset_C_Tables ' || SQLERRM );
1895: end if;
1896: end reset_c_tables;
1897:
1898: PROCEDURE Populate_Pattern_Phases (

Line 1918: fnd_file.put_line(FND_FILE.LOG, 'Begin Populate_Pattern_Phases for HP case');

1914: /*
1915: if g_call_from_setup = 'Y' then
1916: oe_debug_pub.add('Begin Populate_Pattern_Phases for HP case');
1917: else
1918: fnd_file.put_line(FND_FILE.LOG, 'Begin Populate_Pattern_Phases for HP case');
1919: end if;
1920: */
1921: FOR j IN l_phase_id_to_insert_csr LOOP
1922: begin

Line 1971: fnd_file.put_line(FND_FILE.LOG, 'Begin Populate_Pattern_Phases for LP, PP case');

1967: /*
1968: if g_call_from_setup = 'Y' then
1969: oe_debug_pub.add('Begin Populate_Pattern_Phases for LP, PP case');
1970: else
1971: fnd_file.put_line(FND_FILE.LOG, 'Begin Populate_Pattern_Phases for LP, PP case');
1972: end if;
1973: */
1974: begin
1975: select /*+ index(qp_pp QP_PATTERN_PHASES_N1) */ 'Y'

Line 1987: fnd_file.put_line(FND_FILE.LOG, 'No pattern_phases found; go insert');

1983: /*
1984: if g_call_from_setup = 'Y' then
1985: oe_debug_pub.add('No pattern_phases found; go insert');
1986: else
1987: fnd_file.put_line(FND_FILE.LOG, 'No pattern_phases found; go insert');
1988: end if;
1989: */
1990: INSERT INTO qp_pattern_phases
1991: (pattern_id,

Line 2025: fnd_file.put_line(FND_FILE.LOG, 'Insert failure:'||sqlerrm);

2021: when others then
2022: if g_call_from_setup = 'Y' then
2023: oe_debug_pub.add('Insert failure:'||sqlerrm);
2024: else
2025: fnd_file.put_line(FND_FILE.LOG, 'Insert failure:'||sqlerrm);
2026: end if;
2027: raise;
2028: end;
2029:

Line 2035: fnd_file.put_line(FND_FILE.LOG, 'End Populate_Pattern_Phases ');

2031: /*
2032: if g_call_from_setup = 'Y' then
2033: oe_debug_pub.add('End Populate_Pattern_Phases ');
2034: else
2035: fnd_file.put_line(FND_FILE.LOG, 'End Populate_Pattern_Phases ');
2036: end if;
2037: */
2038:
2039: EXCEPTION

Line 2044: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Populate_Pattern_Phases ' || SQLERRM );

2040: WHEN OTHERS THEN
2041: if g_call_from_setup = 'Y' then
2042: oe_debug_pub.add('ATTR_GRP_PVT.Populate_Pattern_Phases ' || SQLERRM);
2043: else
2044: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Populate_Pattern_Phases ' || SQLERRM );
2045: end if;
2046: raise;
2047: END Populate_Pattern_Phases;
2048:

Line 2075: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);

2071: oe_debug_pub.add('Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2072: oe_debug_pub.add('Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2073: oe_debug_pub.add('Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
2074: else
2075: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2076: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2077: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
2078: end if;
2079:

Line 2076: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);

2072: oe_debug_pub.add('Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2073: oe_debug_pub.add('Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
2074: else
2075: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2076: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2077: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
2078: end if;
2079:
2080: -- when called while set up of modifier/price list

Line 2077: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_setup_action = ' ||p_setup_action);

2073: oe_debug_pub.add('Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
2074: else
2075: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2076: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2077: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
2078: end if;
2079:
2080: -- when called while set up of modifier/price list
2081: if p_setup_action <> 'UD' then

Line 2217: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Header_Pattern_Main ' || SQLERRM );

2213: WHEN OTHERS THEN
2214: if g_call_from_setup = 'Y' then
2215: oe_debug_pub.add('ATTR_GRP_PVT.Header_Pattern_Main ' || SQLERRM);
2216: else
2217: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Header_Pattern_Main ' || SQLERRM );
2218: end if;
2219:
2220: END Header_Pattern_Main;
2221:

Line 2243: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);

2239: oe_debug_pub.add('Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2240: oe_debug_pub.add('Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2241: oe_debug_pub.add('Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2242: else
2243: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2244: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2245: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2246: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2247: end if;

Line 2244: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);

2240: oe_debug_pub.add('Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2241: oe_debug_pub.add('Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2242: else
2243: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2244: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2245: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2246: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2247: end if;
2248:

Line 2245: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);

2241: oe_debug_pub.add('Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2242: else
2243: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2244: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2245: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2246: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2247: end if;
2248:
2249: -- when called while set up of modifier

Line 2246: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_setup_action = ' ||p_setup_action);

2242: else
2243: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2244: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2245: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2246: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2247: end if;
2248:
2249: -- when called while set up of modifier
2250: if p_setup_action <> 'UD' then

Line 2411: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Line_Pattern_Main ' || SQLERRM );

2407: WHEN OTHERS THEN
2408: if g_call_from_setup = 'Y' then
2409: oe_debug_pub.add('ATTR_GRP_PVT.Line_Pattern_Main ' || SQLERRM);
2410: else
2411: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Line_Pattern_Main ' || SQLERRM );
2412: end if;
2413:
2414: END Line_Pattern_Main;
2415:

Line 2435: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);

2431: oe_debug_pub.add('Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2432: oe_debug_pub.add('Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2433: oe_debug_pub.add('Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
2434: else
2435: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2436: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2437: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
2438: end if;
2439:

Line 2436: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);

2432: oe_debug_pub.add('Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2433: oe_debug_pub.add('Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
2434: else
2435: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2436: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2437: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
2438: end if;
2439:
2440: select qualification_ind

Line 2437: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_setup_action = ' ||p_setup_action);

2433: oe_debug_pub.add('Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
2434: else
2435: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2436: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2437: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
2438: end if;
2439:
2440: select qualification_ind
2441: into l_qual_ind

Line 2490: fnd_file.put_line(FND_FILE.LOG, 'going to populate LP');

2486: if l_qual_exists = 'Y' then
2487: if g_call_from_setup = 'Y' then
2488: oe_debug_pub.add('going to populate LP');
2489: else
2490: fnd_file.put_line(FND_FILE.LOG, 'going to populate LP');
2491: end if;
2492: Line_Pattern_Main(p_list_header_id, p_list_line_id, null, 'I');
2493: else
2494: if g_call_from_setup = 'Y' then

Line 2497: fnd_file.put_line(FND_FILE.LOG, 'going to populate PP');

2493: else
2494: if g_call_from_setup = 'Y' then
2495: oe_debug_pub.add('going to populate PP');
2496: else
2497: fnd_file.put_line(FND_FILE.LOG, 'going to populate PP');
2498: end if;
2499:
2500: remove_prod_pattern_for_line(p_list_line_id);
2501:

Line 2515: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Product_Pattern_Main ' || SQLERRM );

2511: WHEN OTHERS THEN
2512: if g_call_from_setup = 'Y' then
2513: oe_debug_pub.add('ATTR_GRP_PVT.Product_Pattern_Main ' || SQLERRM);
2514: else
2515: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Product_Pattern_Main ' || SQLERRM );
2516: end if;
2517:
2518: END Product_Pattern_Main;
2519:

Line 2540: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Remove_Prod_Pattern_For_Line ' || SQLERRM );

2536: when others then
2537: if g_call_from_setup = 'Y' then
2538: oe_debug_pub.add('ATTR_GRP_PVT.Remove_Prod_Pattern_For_Line ' || SQLERRM);
2539: else
2540: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Remove_Prod_Pattern_For_Line ' || SQLERRM );
2541: end if;
2542: raise;
2543: end remove_prod_pattern_for_line;
2544:

Line 2576: fnd_file.put_line(FND_FILE.LOG, 'Inside Update_Qual_Segment_id');

2572: if g_call_from_setup = 'Y' then
2573: oe_debug_pub.add('Inside Update_Qual_Segment_id');
2574: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2575: else
2576: fnd_file.put_line(FND_FILE.LOG, 'Inside Update_Qual_Segment_id');
2577: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2578: end if;
2579: segment_id_t.delete;
2580: context_t.delete;

Line 2577: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

2573: oe_debug_pub.add('Inside Update_Qual_Segment_id');
2574: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2575: else
2576: fnd_file.put_line(FND_FILE.LOG, 'Inside Update_Qual_Segment_id');
2577: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2578: end if;
2579: segment_id_t.delete;
2580: context_t.delete;
2581: attribute_t.delete;

Line 2593: fnd_file.put_line(FND_FILE.LOG, 'Context_t.count='||context_t.count);

2589: if context_t.count > 0 then
2590: if g_call_from_setup = 'Y' then
2591: oe_debug_pub.add('Context_t.count='||context_t.count);
2592: else
2593: fnd_file.put_line(FND_FILE.LOG, 'Context_t.count='||context_t.count);
2594: end if;
2595: FOR i in 1..context_t.count
2596: LOOP
2597: select b.segment_id

Line 2616: fnd_file.put_line(FND_FILE.LOG, 'No of qualifiers updated='||SQL%ROWCOUNT);

2612:
2613: if g_call_from_setup = 'Y' then
2614: oe_debug_pub.add('No of qualifiers updated='||SQL%ROWCOUNT);
2615: else
2616: fnd_file.put_line(FND_FILE.LOG, 'No of qualifiers updated='||SQL%ROWCOUNT);
2617: end if;
2618: end if; -- context_t.count > 0
2619:
2620: if g_call_from_setup = 'Y' then

Line 2624: fnd_file.put_line(FND_FILE.LOG, 'End Update_Qual_Segment_id');

2620: if g_call_from_setup = 'Y' then
2621: oe_debug_pub.add('End Update_Qual_Segment_id');
2622: oe_debug_pub.add('End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2623: else
2624: fnd_file.put_line(FND_FILE.LOG, 'End Update_Qual_Segment_id');
2625: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2626: end if;
2627: exception
2628: when no_data_found then

Line 2625: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

2621: oe_debug_pub.add('End Update_Qual_Segment_id');
2622: oe_debug_pub.add('End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2623: else
2624: fnd_file.put_line(FND_FILE.LOG, 'End Update_Qual_Segment_id');
2625: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2626: end if;
2627: exception
2628: when no_data_found then
2629: if g_call_from_setup = 'Y' then

Line 2632: fnd_file.put_line(FND_FILE.LOG, 'No data found in c_qual_seg_id');

2628: when no_data_found then
2629: if g_call_from_setup = 'Y' then
2630: oe_debug_pub.add('No data found in c_qual_seg_id');
2631: else
2632: fnd_file.put_line(FND_FILE.LOG, 'No data found in c_qual_seg_id');
2633: end if;
2634:
2635: when others then
2636: if g_call_from_setup = 'Y' then

Line 2639: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_Qual_Segment_Id ' || SQLERRM );

2635: when others then
2636: if g_call_from_setup = 'Y' then
2637: oe_debug_pub.add('ATTR_GRP_PVT.Update_Qual_Segment_Id ' || SQLERRM);
2638: else
2639: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_Qual_Segment_Id ' || SQLERRM );
2640: end if;
2641:
2642: raise;
2643:

Line 2681: fnd_file.put_line(FND_FILE.LOG, 'Inside Update_Prod_Pric_Segment_id');

2677: if g_call_from_setup = 'Y' then
2678: oe_debug_pub.add('Inside Update_Prod_Pric_Segment_id');
2679: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2680: else
2681: fnd_file.put_line(FND_FILE.LOG, 'Inside Update_Prod_Pric_Segment_id');
2682: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2683: end if;
2684: -- update the product_segment_id column in qp_pricing_attributes
2685: segment_id_t.delete;

Line 2682: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

2678: oe_debug_pub.add('Inside Update_Prod_Pric_Segment_id');
2679: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2680: else
2681: fnd_file.put_line(FND_FILE.LOG, 'Inside Update_Prod_Pric_Segment_id');
2682: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2683: end if;
2684: -- update the product_segment_id column in qp_pricing_attributes
2685: segment_id_t.delete;
2686: context_t.delete;

Line 2699: fnd_file.put_line(FND_FILE.LOG, 'Context_t.count='||context_t.count);

2695: if context_t.count > 0 then
2696: if g_call_from_setup = 'Y' then
2697: oe_debug_pub.add('Context_t.count='||context_t.count);
2698: else
2699: fnd_file.put_line(FND_FILE.LOG, 'Context_t.count='||context_t.count);
2700: end if;
2701: FOR i in 1..context_t.count
2702: LOOP
2703: select b.segment_id

Line 2723: fnd_file.put_line(FND_FILE.LOG, 'No of product segment ids updated='||SQL%ROWCOUNT);

2719: if g_call_from_setup = 'Y' then
2720: oe_debug_pub.add('No of product segment ids updated='||SQL%ROWCOUNT);
2721: oe_debug_pub.add('End Time product segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2722: else
2723: fnd_file.put_line(FND_FILE.LOG, 'No of product segment ids updated='||SQL%ROWCOUNT);
2724: fnd_file.put_line(FND_FILE.LOG, 'End time product segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2725: end if;
2726: end if; -- context_t.count > 0
2727:

Line 2724: fnd_file.put_line(FND_FILE.LOG, 'End time product segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

2720: oe_debug_pub.add('No of product segment ids updated='||SQL%ROWCOUNT);
2721: oe_debug_pub.add('End Time product segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2722: else
2723: fnd_file.put_line(FND_FILE.LOG, 'No of product segment ids updated='||SQL%ROWCOUNT);
2724: fnd_file.put_line(FND_FILE.LOG, 'End time product segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2725: end if;
2726: end if; -- context_t.count > 0
2727:
2728: -- update the pricing_segment_id columns in qp_pricing_attributes

Line 2743: fnd_file.put_line(FND_FILE.LOG, 'Context_t.count='||context_t.count);

2739: if context_t.count > 0 then
2740: if g_call_from_setup = 'Y' then
2741: oe_debug_pub.add('Context_t.count='||context_t.count);
2742: else
2743: fnd_file.put_line(FND_FILE.LOG, 'Context_t.count='||context_t.count);
2744: end if;
2745:
2746: FOR i in 1..context_t.count
2747: LOOP

Line 2768: fnd_file.put_line(FND_FILE.LOG, 'No of pricing segment ids updated='||SQL%ROWCOUNT);

2764: if g_call_from_setup = 'Y' then
2765: oe_debug_pub.add('No of pricing segment ids updated='||SQL%ROWCOUNT);
2766: oe_debug_pub.add('End Time pricing segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2767: else
2768: fnd_file.put_line(FND_FILE.LOG, 'No of pricing segment ids updated='||SQL%ROWCOUNT);
2769: fnd_file.put_line(FND_FILE.LOG, 'End time pricing segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2770: end if;
2771: end if; -- context_t.count > 0
2772:

Line 2769: fnd_file.put_line(FND_FILE.LOG, 'End time pricing segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

2765: oe_debug_pub.add('No of pricing segment ids updated='||SQL%ROWCOUNT);
2766: oe_debug_pub.add('End Time pricing segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2767: else
2768: fnd_file.put_line(FND_FILE.LOG, 'No of pricing segment ids updated='||SQL%ROWCOUNT);
2769: fnd_file.put_line(FND_FILE.LOG, 'End time pricing segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2770: end if;
2771: end if; -- context_t.count > 0
2772:
2773: if g_call_from_setup = 'Y' then

Line 2776: fnd_file.put_line(FND_FILE.LOG, 'End Update_Prod_Pric_Segment_id');

2772:
2773: if g_call_from_setup = 'Y' then
2774: oe_debug_pub.add('End Update_Prod_Pric_Segment_id');
2775: else
2776: fnd_file.put_line(FND_FILE.LOG, 'End Update_Prod_Pric_Segment_id');
2777: end if;
2778: exception
2779: when no_data_found then
2780: if g_call_from_setup = 'Y' then

Line 2783: fnd_file.put_line(FND_FILE.LOG, 'No data found in Update_Prod_Pric_Segment_id');

2779: when no_data_found then
2780: if g_call_from_setup = 'Y' then
2781: oe_debug_pub.add('No data found in Update_Prod_Pric_Segment_id');
2782: else
2783: fnd_file.put_line(FND_FILE.LOG, 'No data found in Update_Prod_Pric_Segment_id');
2784: end if;
2785:
2786: null;
2787:

Line 2792: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_Prod_Pric_Segment_id ' || SQLERRM );

2788: when others then
2789: if g_call_from_setup = 'Y' then
2790: oe_debug_pub.add('ATTR_GRP_PVT.Update_Prod_Pric_Segment_id ' || SQLERRM);
2791: else
2792: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_Prod_Pric_Segment_id ' || SQLERRM );
2793: end if;
2794:
2795: raise;
2796: