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 205: fnd_file.put_line(FND_FILE.LOG, 'Java Engine Installed');

201: BEGIN
202: -- Check Java Engine Installed profile
203: -- FND_PROFILE.PUT('QP_INTERNAL_11510_J', 'QWERTY'); -- added to avoid the setting of profile QP_INTERNAL_11510_J to QWERTY manually
204: if QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' then
205: fnd_file.put_line(FND_FILE.LOG, 'Java Engine Installed');
206: fnd_file.put_line(FND_FILE.LOG, 'p_list_header_id ' || p_list_header_id);
207: fnd_file.put_line(FND_FILE.LOG, 'p_low_list_line_id ' || p_low_list_line_id);
208: fnd_file.put_line(FND_FILE.LOG, 'p_high_list_line_id ' || p_high_list_line_id);
209: fnd_file.put_line(FND_FILE.LOG, 'p_no_of_threads ' || p_no_of_threads);

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

202: -- Check Java Engine Installed profile
203: -- FND_PROFILE.PUT('QP_INTERNAL_11510_J', 'QWERTY'); -- added to avoid the setting of profile QP_INTERNAL_11510_J to QWERTY manually
204: if QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' then
205: fnd_file.put_line(FND_FILE.LOG, 'Java Engine Installed');
206: fnd_file.put_line(FND_FILE.LOG, 'p_list_header_id ' || p_list_header_id);
207: fnd_file.put_line(FND_FILE.LOG, 'p_low_list_line_id ' || p_low_list_line_id);
208: fnd_file.put_line(FND_FILE.LOG, 'p_high_list_line_id ' || p_high_list_line_id);
209: fnd_file.put_line(FND_FILE.LOG, 'p_no_of_threads ' || p_no_of_threads);
210: fnd_file.put_line(FND_FILE.LOG, 'p_spawned_request ' || p_spawned_request);

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

203: -- FND_PROFILE.PUT('QP_INTERNAL_11510_J', 'QWERTY'); -- added to avoid the setting of profile QP_INTERNAL_11510_J to QWERTY manually
204: if QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' then
205: fnd_file.put_line(FND_FILE.LOG, 'Java Engine Installed');
206: fnd_file.put_line(FND_FILE.LOG, 'p_list_header_id ' || p_list_header_id);
207: fnd_file.put_line(FND_FILE.LOG, 'p_low_list_line_id ' || p_low_list_line_id);
208: fnd_file.put_line(FND_FILE.LOG, 'p_high_list_line_id ' || p_high_list_line_id);
209: fnd_file.put_line(FND_FILE.LOG, 'p_no_of_threads ' || p_no_of_threads);
210: fnd_file.put_line(FND_FILE.LOG, 'p_spawned_request ' || p_spawned_request);
211:

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

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

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

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

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

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

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

210: fnd_file.put_line(FND_FILE.LOG, 'p_spawned_request ' || p_spawned_request);
211:
212: select sid into v_sid from v$session where audsid = userenv('SESSIONID');
213:
214: fnd_file.put_line(FND_FILE.LOG, 'session ID = ' || v_sid);
215: ELSE
216: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') <> 'N' THEN
217: fnd_file.put_line(FND_FILE.LOG, 'Java Engine not Installed');
218: END IF;

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

213:
214: fnd_file.put_line(FND_FILE.LOG, 'session ID = ' || v_sid);
215: ELSE
216: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') <> 'N' THEN
217: fnd_file.put_line(FND_FILE.LOG, 'Java Engine not Installed');
218: END IF;
219: QP_PS_ATTR_GRP_PVT.Pattern_Upgrade(err_buff, retcode, p_list_header_id, p_low_list_line_id, p_high_list_line_id, p_no_of_threads, p_spawned_request, p_debug);
220: return;
221: end if;

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

225: if p_no_of_threads is NULL or p_no_of_threads = 0 then
226: l_no_of_threads := 1;
227: end if;
228: l_req_data := fnd_conc_global.request_data;
229: fnd_file.put_line(FND_FILE.LOG, 'l_req_data : ' || l_req_data);
230: if l_req_data is not NULL then
231: remove_duplicate_patterns;
232: return;
233: end if;

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

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

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

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

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

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

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

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

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

275: fnd_file.put_line(FND_FILE.LOG, 'l_total_lines ' || l_total_lines);
276: if l_total_lines > 0 then
277: create_pattern_slabs(l_total_lines, p_list_header_id, l_no_of_threads);
278: l_slab_count := g_pattern_upg_slab_table.count;
279: fnd_file.put_line(FND_FILE.LOG, 'l_slab_count ' || l_slab_count);
280: l_count := 1;
281: loop
282: l_new_request_id := fnd_request.submit_request(
283: 'QP',

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

293: p_debug);
294: if l_new_request_id = 0 then
295: retcode := 2;
296: err_buff := fnd_message.get;
297: fnd_file.put_line(FND_FILE.LOG, 'err_buff ' || err_buff);
298: return;
299: end if;
300: FND_FILE.PUT_LINE(FND_FILE.LOG , 'Child '||l_count||' request_id: '||l_new_request_id);
301:

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

296: err_buff := fnd_message.get;
297: fnd_file.put_line(FND_FILE.LOG, 'err_buff ' || err_buff);
298: return;
299: end if;
300: FND_FILE.PUT_LINE(FND_FILE.LOG , 'Child '||l_count||' request_id: '||l_new_request_id);
301:
302: l_count := l_count + 1;
303: exit when l_count > l_slab_count;
304: end loop;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

405: when others then
406: if g_call_from_setup = 'Y' then
407: oe_debug_pub.add('ATTR_GRP_PVT.Pattern_Upgrade ' || SQLERRM);
408: else
409: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Pattern_Upgrade ' || SQLERRM );
410: end if;
411: err_buff := 'Others Error in procedure Pattern_Upgrade';
412: retcode := 1;
413:

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

456: -- delete the data from cursor, temp and final tables to start with
457: if g_call_from_setup = 'Y' then
458: oe_debug_pub.add('Begin generate_hp_atgrps');
459: else
460: fnd_file.put_line(FND_FILE.LOG, 'Begin generate_hp_atgrps');
461: end if;
462: Reset_c_tables;
463: Reset_tmp_tables;
464: Reset_final_tables;

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

493: end if;
494: if g_call_from_setup = 'Y' then
495: oe_debug_pub.add('End generate_hp_atgrps');
496: else
497: fnd_file.put_line(FND_FILE.LOG, 'End generate_hp_atgrps');
498: end if;
499:
500: EXCEPTION
501: WHEN OTHERS THEN

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

501: WHEN OTHERS THEN
502: if g_call_from_setup = 'Y' then
503: oe_debug_pub.add('ATTR_GRP_PVT.Generate_Hp_Atgrps ' || SQLERRM);
504: else
505: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Generate_Hp_Atgrps ' || SQLERRM );
506: end if;
507:
508: end generate_hp_atgrps;
509:

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

645: WHEN OTHERS THEN
646: if g_call_from_setup = 'Y' then
647: oe_debug_pub.add('ATTR_GRP_PVT.Generate_Lp_Atgrps ' || SQLERRM);
648: else
649: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Generate_Lp_Atgrps ' || SQLERRM );
650: end if;
651:
652: end generate_lp_atgrps;
653:

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

724: WHEN OTHERS THEN
725: if g_call_from_setup = 'Y' then
726: oe_debug_pub.add('ATTR_GRP_PVT.Update_Pp_Lines ' || SQLERRM);
727: else
728: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_Pp_Lines ' || SQLERRM );
729: end if;
730:
731: end update_pp_lines;
732:

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

751: else
752: QP_PREQ_GRP.Set_QP_Debug;
753: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
754: IF l_debug = FND_API.G_TRUE THEN
755: fnd_file.put_line(FND_FILE.LOG, 'Start process_c_tables - Pattern type '||p_pattern_type);
756: fnd_file.put_line(FND_FILE.LOG, 'cursor tables total = ' || g_list_header_id_c_tbl.count);
757: END IF;
758: end if;
759:

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

752: QP_PREQ_GRP.Set_QP_Debug;
753: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
754: IF l_debug = FND_API.G_TRUE THEN
755: fnd_file.put_line(FND_FILE.LOG, 'Start process_c_tables - Pattern type '||p_pattern_type);
756: fnd_file.put_line(FND_FILE.LOG, 'cursor tables total = ' || g_list_header_id_c_tbl.count);
757: END IF;
758: end if;
759:
760: if g_list_header_id_c_tbl.count > 0 then

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

768: ', operator = ' || g_comparison_opr_code_c_tbl(i));
769: --oe_debug_pub.add('l_old_list_header_id ' || l_old_list_header_id);
770: --oe_debug_pub.add('l_old_list_line_id ' || l_old_list_line_id);
771: elsif l_debug = FND_API.G_TRUE then
772: fnd_file.put_line(FND_FILE.LOG, 'i = ' || i ||
773: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
774: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
775: ', group = ' || g_qual_grouping_no_c_tbl(i) ||
776: ', operator = ' || g_comparison_opr_code_c_tbl(i));

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

773: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
774: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
775: ', group = ' || g_qual_grouping_no_c_tbl(i) ||
776: ', operator = ' || g_comparison_opr_code_c_tbl(i));
777: --fnd_file.put_line(FND_FILE.LOG, 'l_old_list_header_id ' || l_old_list_header_id);
778: --fnd_file.put_line(FND_FILE.LOG, 'l_old_list_line_id ' || l_old_list_line_id);
779: end if;
780:
781: if (i > 1

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

774: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
775: ', group = ' || g_qual_grouping_no_c_tbl(i) ||
776: ', operator = ' || g_comparison_opr_code_c_tbl(i));
777: --fnd_file.put_line(FND_FILE.LOG, 'l_old_list_header_id ' || l_old_list_header_id);
778: --fnd_file.put_line(FND_FILE.LOG, 'l_old_list_line_id ' || l_old_list_line_id);
779: end if;
780:
781: if (i > 1
782: and (g_list_header_id_c_tbl(i) <> l_old_list_header_id

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

790: if l_line_counter >= G_LINES_PER_INSERT then
791: if g_call_from_setup = 'Y' then
792: oe_debug_pub.add('inserting data for ' || G_LINES_PER_INSERT || ' lines');
793: elsif l_debug = FND_API.G_TRUE then
794: fnd_file.put_line(FND_FILE.LOG, 'inserting data for ' || G_LINES_PER_INSERT || ' lines');
795: end if;
796: populate_atgrps;
797: if p_pattern_type = 'LP' then
798: update_list_lines_cache_key;

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

799: end if;
800: reset_final_tables;
801: if g_call_from_setup <> 'Y' then
802: if l_debug = FND_API.G_TRUE then
803: fnd_file.put_line(FND_FILE.LOG, 'committing data for ' || G_LINES_PER_INSERT || ' lines');
804: end if;
805: commit;
806: end if;
807: l_line_counter := 0;

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

815: if g_call_from_setup = 'Y' then
816: oe_debug_pub.add('record exists in temp table for current group');
817: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));
818: else
819: fnd_file.put_line(FND_FILE.LOG, 'record exists in temp table for current group');
820: fnd_file.put_line(FND_FILE.LOG, 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));
821: end if;
822: */
823:

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

816: oe_debug_pub.add('record exists in temp table for current group');
817: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));
818: else
819: fnd_file.put_line(FND_FILE.LOG, 'record exists in temp table for current group');
820: fnd_file.put_line(FND_FILE.LOG, 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));
821: end if;
822: */
823:
824: -- if grp_no -1 record is getting updated then update the other grps records for pattern string,

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

830: /*
831: if g_call_from_setup = 'Y' then
832: oe_debug_pub.add('other_grp_index = ' || other_grp_index);
833: else
834: fnd_file.put_line(FND_FILE.LOG, 'other_grp_index = ' || other_grp_index);
835: end if;
836: */
837: -- do not update the -1 grp no record as -1 grp no record will be updated automatically
838: -- outside this loop

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

941: if g_call_from_setup = 'Y' then
942: oe_debug_pub.add('record DOES NOT exists in temp table for current group');
943: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));
944: else
945: fnd_file.put_line(FND_FILE.LOG, 'record DOES NOT exists in temp table for current group');
946: fnd_file.put_line(FND_FILE.LOG, 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));
947: end if;
948: */
949:

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

942: oe_debug_pub.add('record DOES NOT exists in temp table for current group');
943: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));
944: else
945: fnd_file.put_line(FND_FILE.LOG, 'record DOES NOT exists in temp table for current group');
946: fnd_file.put_line(FND_FILE.LOG, 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));
947: end if;
948: */
949:
950: l_prefix_value_from_null_grp := 'N';

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

957: /*
958: if g_call_from_setup = 'Y' then
959: oe_debug_pub.add('other_grp_index = ' || other_grp_index);
960: else
961: fnd_file.put_line(FND_FILE.LOG, 'other_grp_index = ' || other_grp_index);
962: end if;
963: */
964:
965: if (g_start_date_active_q_c_tbl(i) is not null

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

1159: WHEN OTHERS THEN
1160: if g_call_from_setup = 'Y' then
1161: oe_debug_pub.add('ATTR_GRP_PVT.Process_C_Tables ' || SQLERRM);
1162: else
1163: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Process_C_Tables ' || SQLERRM );
1164: end if;
1165:
1166: end process_c_tables;
1167:

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

1183: else
1184: QP_PREQ_GRP.Set_QP_Debug;
1185: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1186: IF l_debug = FND_API.G_TRUE THEN
1187: fnd_file.put_line(FND_FILE.LOG, 'PP cursor tables total = ' || g_list_header_id_c_tbl.count);
1188: END IF;
1189: end if;
1190:
1191: l_first_pa_rec_for_line := 'Y';

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

1200: ', operator = ' || g_comparison_opr_code_c_tbl(i));
1201: --oe_debug_pub.add('PP l_old_list_header_id ' || l_old_list_header_id);
1202: --oe_debug_pub.add('PP l_old_list_line_id ' || l_old_list_line_id);
1203: elsif l_debug = FND_API.G_TRUE then
1204: fnd_file.put_line(FND_FILE.LOG, 'PP i = ' || i ||
1205: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
1206: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
1207: ', operator = ' || g_comparison_opr_code_c_tbl(i));
1208: --fnd_file.put_line(FND_FILE.LOG, 'PP l_old_list_header_id ' || l_old_list_header_id);

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

1204: fnd_file.put_line(FND_FILE.LOG, 'PP i = ' || i ||
1205: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
1206: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
1207: ', operator = ' || g_comparison_opr_code_c_tbl(i));
1208: --fnd_file.put_line(FND_FILE.LOG, 'PP l_old_list_header_id ' || l_old_list_header_id);
1209: --fnd_file.put_line(FND_FILE.LOG, 'PP l_old_list_line_id ' || l_old_list_line_id);
1210: end if;
1211:
1212: if (i > 1

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

1205: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
1206: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
1207: ', operator = ' || g_comparison_opr_code_c_tbl(i));
1208: --fnd_file.put_line(FND_FILE.LOG, 'PP l_old_list_header_id ' || l_old_list_header_id);
1209: --fnd_file.put_line(FND_FILE.LOG, 'PP l_old_list_line_id ' || l_old_list_line_id);
1210: end if;
1211:
1212: if (i > 1
1213: and (g_list_header_id_c_tbl(i) <> l_old_list_header_id

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

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

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

1228: update_list_lines;
1229: reset_final_tables;
1230: if g_call_from_setup <> 'Y' then
1231: if l_debug = FND_API.G_TRUE then
1232: fnd_file.put_line(FND_FILE.LOG, 'committing data for ' || G_LINES_PER_INSERT || ' lines');
1233: end if;
1234: commit;
1235: end if;
1236: l_line_counter := 0;

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

1334: WHEN OTHERS THEN
1335: if g_call_from_setup = 'Y' then
1336: oe_debug_pub.add('ATTR_GRP_PVT.Process_C_Tables_Pp ' || SQLERRM);
1337: else
1338: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Process_C_Tables_Pp ' || SQLERRM );
1339: end if;
1340:
1341: end process_c_tables_pp;
1342:

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

1352: if g_call_from_setup = 'Y' then
1353: oe_debug_pub.add('Moving data from temp table to final table');
1354: oe_debug_pub.add('temp tables total = ' || g_list_header_id_tmp_tbl.count);
1355: else
1356: fnd_file.put_line(FND_FILE.LOG, 'Moving data from temp table to final table');
1357: fnd_file.put_line(FND_FILE.LOG, 'temp tables total = ' || g_list_header_id_tmp_tbl.count);
1358: end if;
1359: */
1360:

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

1353: oe_debug_pub.add('Moving data from temp table to final table');
1354: oe_debug_pub.add('temp tables total = ' || g_list_header_id_tmp_tbl.count);
1355: else
1356: fnd_file.put_line(FND_FILE.LOG, 'Moving data from temp table to final table');
1357: fnd_file.put_line(FND_FILE.LOG, 'temp tables total = ' || g_list_header_id_tmp_tbl.count);
1358: end if;
1359: */
1360:
1361: -- find out whether any qual groups exists other than -1

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

1367: /*
1368: if g_call_from_setup = 'Y' then
1369: oe_debug_pub.add('l_other_grp_exists = ' || l_other_grp_exists);
1370: else
1371: fnd_file.put_line(FND_FILE.LOG, 'l_other_grp_exists = ' || l_other_grp_exists);
1372: end if;
1373: */
1374:
1375: -- now loop thru the atgrp temp tables and move to the final atgrp tables

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

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

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

1396: /*
1397: if g_call_from_setup = 'Y' then
1398: oe_debug_pub.add('Pattern_id='||l_pattern_id);
1399: else
1400: fnd_file.put_line(FND_FILE.LOG, 'Pattern_id='||l_pattern_id);
1401: end if;
1402: */
1403:
1404: -- maintain data in qp_pattern_phases

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

1412: /*
1413: if g_call_from_setup = 'Y' then
1414: oe_debug_pub.add('move the data from tmp tables to final tables for qp_attribute_groups');
1415: else
1416: fnd_file.put_line(FND_FILE.LOG, 'move the data from tmp tables to final tables for qp_attribute_groups');
1417: end if;
1418: */
1419:
1420: l_atgrp_final_index := g_list_header_id_final_tbl.count + 1;

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

1450: /*
1451: if g_call_from_setup = 'Y' then
1452: oe_debug_pub.add('cache_key should be just list_header_id ');
1453: else
1454: fnd_file.put_line(FND_FILE.LOG, 'cache_key should be just list_header_id ');
1455: end if;
1456: */
1457: else
1458: g_cache_key_final_tbl(l_atgrp_final_index) := g_cache_key_tmp_tbl(grp_no_index);

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

1459: /*
1460: if g_call_from_setup = 'Y' then
1461: oe_debug_pub.add('cache_key should be standard OR null');
1462: else
1463: fnd_file.put_line(FND_FILE.LOG, 'cache_key should be standard OR null');
1464: end if;
1465: */
1466: end if;
1467:

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

1487: /*
1488: if g_call_from_setup = 'Y' then
1489: oe_debug_pub.add('End Moving data from temp table to final table');
1490: else
1491: fnd_file.put_line(FND_FILE.LOG, 'End Moving data from temp table to final table');
1492: end if;
1493: */
1494:
1495: EXCEPTION

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

1496: WHEN OTHERS THEN
1497: if g_call_from_setup = 'Y' then
1498: oe_debug_pub.add('ATTR_GRP_PVT.Move_Data_From_Tmp_To_Final ' || SQLERRM);
1499: else
1500: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Move_Data_From_Tmp_To_Final ' || SQLERRM );
1501: end if;
1502:
1503: END Move_data_from_tmp_to_final;
1504:

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

1510: /*
1511: if g_call_from_setup = 'Y' then
1512: oe_debug_pub.add('Begin Populate_patterns');
1513: else
1514: fnd_file.put_line(FND_FILE.LOG, 'Begin Populate_patterns');
1515: end if;
1516: */
1517:
1518: FORALL i in 1 .. G_pattern_pattern_id_final_tbl.count

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

1567: if g_call_from_setup = 'Y' then
1568: oe_debug_pub.add('End Populate_patterns');
1569: else
1570: commit;
1571: fnd_file.put_line(FND_FILE.LOG, 'End Populate_patterns');
1572: end if;
1573: */
1574: EXCEPTION
1575: WHEN OTHERS THEN

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

1575: WHEN OTHERS THEN
1576: if g_call_from_setup = 'Y' then
1577: oe_debug_pub.add('ATTR_GRP_PVT.Populate_Patterns ' || SQLERRM);
1578: else
1579: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Populate_Patterns ' || SQLERRM );
1580: end if;
1581: raise;
1582: END Populate_Patterns;
1583:

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

1602: WHEN OTHERS THEN
1603: if g_call_from_setup = 'Y' then
1604: oe_debug_pub.add('ATTR_GRP_PVT.Update_List_Lines ' || SQLERRM);
1605: else
1606: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_List_Lines ' || SQLERRM );
1607: end if;
1608:
1609: end update_list_lines;
1610:

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

1625: WHEN OTHERS THEN
1626: if g_call_from_setup = 'Y' then
1627: oe_debug_pub.add('ATTR_GRP_PVT.Update_List_Lines_Cache_Key ' || SQLERRM);
1628: else
1629: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_List_Lines_Cache_Key ' || SQLERRM );
1630: end if;
1631:
1632: end update_list_lines_cache_key;
1633:

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

1697: WHEN OTHERS THEN
1698: if g_call_from_setup = 'Y' then
1699: oe_debug_pub.add('ATTR_GRP_PVT.Populate_Atgrps ' || SQLERRM);
1700: else
1701: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Populate_Atgrps ' || SQLERRM );
1702: end if;
1703: raise;
1704: END Populate_Atgrps;
1705:

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

1709: /*
1710: if g_call_from_setup = 'Y' then
1711: oe_debug_pub.add('Reset temp tables');
1712: else
1713: fnd_file.put_line(FND_FILE.LOG, 'Reset temp tables');
1714: end if;
1715: */
1716: g_list_header_id_tmp_tbl.delete;
1717: g_list_line_id_tmp_tbl.delete;

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

1749: /*
1750: if g_call_from_setup = 'Y' then
1751: oe_debug_pub.add('Begin get_pattern_id');
1752: else
1753: fnd_file.put_line(FND_FILE.LOG, 'Begin get_pattern_id');
1754: end if;
1755: */
1756: begin
1757: l_pattern_to_be_created := 'N';

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

1773: /*
1774: if g_call_from_setup = 'Y' then
1775: oe_debug_pub.add('l_pattern_to_be_created='||l_pattern_to_be_created);
1776: else
1777: fnd_file.put_line(FND_FILE.LOG, 'l_pattern_to_be_created='||l_pattern_to_be_created);
1778: end if;
1779: */
1780:
1781: -- move the data from temp tables to final tables for qp_patterns, if new pattern to be created

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

1806: /*
1807: if g_call_from_setup = 'Y' then
1808: oe_debug_pub.add('End get_pattern_id');
1809: else
1810: fnd_file.put_line(FND_FILE.LOG, 'End get_pattern_id');
1811: end if;
1812: */
1813:
1814: return l_pattern_id;

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

1817: WHEN OTHERS THEN
1818: if g_call_from_setup = 'Y' then
1819: oe_debug_pub.add('ATTR_GRP_PVT.Get_Pattern_Id ' || SQLERRM);
1820: else
1821: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Get_Pattern_Id ' || SQLERRM );
1822: end if;
1823:
1824: end get_pattern_id;
1825:

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

1861: WHEN OTHERS THEN
1862: if g_call_from_setup = 'Y' then
1863: oe_debug_pub.add('ATTR_GRP_PVT.Reset_Final_Tables ' || SQLERRM);
1864: else
1865: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Reset_Final_Tables ' || SQLERRM );
1866: end if;
1867:
1868: end reset_final_tables;
1869:

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

1896: WHEN OTHERS THEN
1897: if g_call_from_setup = 'Y' then
1898: oe_debug_pub.add('ATTR_GRP_PVT.Reset_C_Tables ' || SQLERRM);
1899: else
1900: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Reset_C_Tables ' || SQLERRM );
1901: end if;
1902: end reset_c_tables;
1903:
1904: PROCEDURE Populate_Pattern_Phases (

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

1920: /*
1921: if g_call_from_setup = 'Y' then
1922: oe_debug_pub.add('Begin Populate_Pattern_Phases for HP case');
1923: else
1924: fnd_file.put_line(FND_FILE.LOG, 'Begin Populate_Pattern_Phases for HP case');
1925: end if;
1926: */
1927: FOR j IN l_phase_id_to_insert_csr LOOP
1928: begin

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

1973: /*
1974: if g_call_from_setup = 'Y' then
1975: oe_debug_pub.add('Begin Populate_Pattern_Phases for LP, PP case');
1976: else
1977: fnd_file.put_line(FND_FILE.LOG, 'Begin Populate_Pattern_Phases for LP, PP case');
1978: end if;
1979: */
1980: begin
1981: select /*+ index(qp_pp QP_PATTERN_PHASES_N1) */ 'Y'

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

1989: /*
1990: if g_call_from_setup = 'Y' then
1991: oe_debug_pub.add('No pattern_phases found; go insert');
1992: else
1993: fnd_file.put_line(FND_FILE.LOG, 'No pattern_phases found; go insert');
1994: end if;
1995: */
1996: INSERT INTO qp_pattern_phases
1997: (pattern_id,

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

2027: when others then
2028: if g_call_from_setup = 'Y' then
2029: oe_debug_pub.add('Insert failure:'||sqlerrm);
2030: else
2031: fnd_file.put_line(FND_FILE.LOG, 'Insert failure:'||sqlerrm);
2032: end if;
2033: raise;
2034: end;
2035:

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

2037: /*
2038: if g_call_from_setup = 'Y' then
2039: oe_debug_pub.add('End Populate_Pattern_Phases ');
2040: else
2041: fnd_file.put_line(FND_FILE.LOG, 'End Populate_Pattern_Phases ');
2042: end if;
2043: */
2044:
2045: EXCEPTION

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

2046: WHEN OTHERS THEN
2047: if g_call_from_setup = 'Y' then
2048: oe_debug_pub.add('ATTR_GRP_PVT.Populate_Pattern_Phases ' || SQLERRM);
2049: else
2050: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Populate_Pattern_Phases ' || SQLERRM );
2051: end if;
2052: raise;
2053: END Populate_Pattern_Phases;
2054:

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

2077: oe_debug_pub.add('Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2078: oe_debug_pub.add('Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2079: oe_debug_pub.add('Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
2080: else
2081: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2082: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2083: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
2084: end if;
2085:

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

2078: oe_debug_pub.add('Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2079: oe_debug_pub.add('Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
2080: else
2081: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2082: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2083: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
2084: end if;
2085:
2086: -- when called while set up of modifier/price list

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

2079: oe_debug_pub.add('Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
2080: else
2081: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2082: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2083: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
2084: end if;
2085:
2086: -- when called while set up of modifier/price list
2087: if p_setup_action <> 'UD' then

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

2219: WHEN OTHERS THEN
2220: if g_call_from_setup = 'Y' then
2221: oe_debug_pub.add('ATTR_GRP_PVT.Header_Pattern_Main ' || SQLERRM);
2222: else
2223: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Header_Pattern_Main ' || SQLERRM );
2224: end if;
2225:
2226: END Header_Pattern_Main;
2227:

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

2245: oe_debug_pub.add('Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2246: oe_debug_pub.add('Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2247: oe_debug_pub.add('Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2248: else
2249: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2250: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2251: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2252: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2253: end if;

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

2246: oe_debug_pub.add('Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2247: oe_debug_pub.add('Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2248: else
2249: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2250: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2251: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2252: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2253: end if;
2254:

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

2247: oe_debug_pub.add('Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2248: else
2249: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2250: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2251: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2252: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2253: end if;
2254:
2255: -- when called while set up of modifier

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

2248: else
2249: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2250: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2251: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2252: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2253: end if;
2254:
2255: -- when called while set up of modifier
2256: if p_setup_action <> 'UD' then

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

2413: WHEN OTHERS THEN
2414: if g_call_from_setup = 'Y' then
2415: oe_debug_pub.add('ATTR_GRP_PVT.Line_Pattern_Main ' || SQLERRM);
2416: else
2417: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Line_Pattern_Main ' || SQLERRM );
2418: end if;
2419:
2420: END Line_Pattern_Main;
2421:

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

2437: oe_debug_pub.add('Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2438: oe_debug_pub.add('Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2439: oe_debug_pub.add('Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
2440: else
2441: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2442: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2443: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
2444: end if;
2445:

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

2438: oe_debug_pub.add('Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2439: oe_debug_pub.add('Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
2440: else
2441: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2442: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2443: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
2444: end if;
2445:
2446: select qualification_ind

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

2439: oe_debug_pub.add('Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
2440: else
2441: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2442: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2443: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
2444: end if;
2445:
2446: select qualification_ind
2447: into l_qual_ind

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

2492: if l_qual_exists = 'Y' then
2493: if g_call_from_setup = 'Y' then
2494: oe_debug_pub.add('going to populate LP');
2495: else
2496: fnd_file.put_line(FND_FILE.LOG, 'going to populate LP');
2497: end if;
2498: Line_Pattern_Main(p_list_header_id, p_list_line_id, null, 'I');
2499: else
2500: if g_call_from_setup = 'Y' then

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

2499: else
2500: if g_call_from_setup = 'Y' then
2501: oe_debug_pub.add('going to populate PP');
2502: else
2503: fnd_file.put_line(FND_FILE.LOG, 'going to populate PP');
2504: end if;
2505:
2506: remove_prod_pattern_for_line(p_list_line_id);
2507:

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

2517: WHEN OTHERS THEN
2518: if g_call_from_setup = 'Y' then
2519: oe_debug_pub.add('ATTR_GRP_PVT.Product_Pattern_Main ' || SQLERRM);
2520: else
2521: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Product_Pattern_Main ' || SQLERRM );
2522: end if;
2523:
2524: END Product_Pattern_Main;
2525:

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

2542: when others then
2543: if g_call_from_setup = 'Y' then
2544: oe_debug_pub.add('ATTR_GRP_PVT.Remove_Prod_Pattern_For_Line ' || SQLERRM);
2545: else
2546: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Remove_Prod_Pattern_For_Line ' || SQLERRM );
2547: end if;
2548: raise;
2549: end remove_prod_pattern_for_line;
2550:

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

2578: if g_call_from_setup = 'Y' then
2579: oe_debug_pub.add('Inside Update_Qual_Segment_id');
2580: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2581: else
2582: fnd_file.put_line(FND_FILE.LOG, 'Inside Update_Qual_Segment_id');
2583: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2584: end if;
2585: segment_id_t.delete;
2586: context_t.delete;

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

2579: oe_debug_pub.add('Inside Update_Qual_Segment_id');
2580: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2581: else
2582: fnd_file.put_line(FND_FILE.LOG, 'Inside Update_Qual_Segment_id');
2583: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2584: end if;
2585: segment_id_t.delete;
2586: context_t.delete;
2587: attribute_t.delete;

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

2595: if context_t.count > 0 then
2596: if g_call_from_setup = 'Y' then
2597: oe_debug_pub.add('Context_t.count='||context_t.count);
2598: else
2599: fnd_file.put_line(FND_FILE.LOG, 'Context_t.count='||context_t.count);
2600: end if;
2601: FOR i in 1..context_t.count
2602: LOOP
2603: select b.segment_id

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

2618:
2619: if g_call_from_setup = 'Y' then
2620: oe_debug_pub.add('No of qualifiers updated='||SQL%ROWCOUNT);
2621: else
2622: fnd_file.put_line(FND_FILE.LOG, 'No of qualifiers updated='||SQL%ROWCOUNT);
2623: end if;
2624: end if; -- context_t.count > 0
2625:
2626: if g_call_from_setup = 'Y' then

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

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

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

2627: oe_debug_pub.add('End Update_Qual_Segment_id');
2628: oe_debug_pub.add('End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2629: else
2630: fnd_file.put_line(FND_FILE.LOG, 'End Update_Qual_Segment_id');
2631: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2632: end if;
2633: exception
2634: when no_data_found then
2635: if g_call_from_setup = 'Y' then

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

2634: when no_data_found then
2635: if g_call_from_setup = 'Y' then
2636: oe_debug_pub.add('No data found in c_qual_seg_id');
2637: else
2638: fnd_file.put_line(FND_FILE.LOG, 'No data found in c_qual_seg_id');
2639: end if;
2640:
2641: when others then
2642: if g_call_from_setup = 'Y' then

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

2641: when others then
2642: if g_call_from_setup = 'Y' then
2643: oe_debug_pub.add('ATTR_GRP_PVT.Update_Qual_Segment_Id ' || SQLERRM);
2644: else
2645: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_Qual_Segment_Id ' || SQLERRM );
2646: end if;
2647:
2648: raise;
2649:

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

2683: if g_call_from_setup = 'Y' then
2684: oe_debug_pub.add('Inside Update_Prod_Pric_Segment_id');
2685: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2686: else
2687: fnd_file.put_line(FND_FILE.LOG, 'Inside Update_Prod_Pric_Segment_id');
2688: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2689: end if;
2690: -- update the product_segment_id column in qp_pricing_attributes
2691: segment_id_t.delete;

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

2684: oe_debug_pub.add('Inside Update_Prod_Pric_Segment_id');
2685: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2686: else
2687: fnd_file.put_line(FND_FILE.LOG, 'Inside Update_Prod_Pric_Segment_id');
2688: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2689: end if;
2690: -- update the product_segment_id column in qp_pricing_attributes
2691: segment_id_t.delete;
2692: context_t.delete;

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

2701: if context_t.count > 0 then
2702: if g_call_from_setup = 'Y' then
2703: oe_debug_pub.add('Context_t.count='||context_t.count);
2704: else
2705: fnd_file.put_line(FND_FILE.LOG, 'Context_t.count='||context_t.count);
2706: end if;
2707: FOR i in 1..context_t.count
2708: LOOP
2709: select b.segment_id

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

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

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

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

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

2745: if context_t.count > 0 then
2746: if g_call_from_setup = 'Y' then
2747: oe_debug_pub.add('Context_t.count='||context_t.count);
2748: else
2749: fnd_file.put_line(FND_FILE.LOG, 'Context_t.count='||context_t.count);
2750: end if;
2751:
2752: FOR i in 1..context_t.count
2753: LOOP

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

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

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

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

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

2778:
2779: if g_call_from_setup = 'Y' then
2780: oe_debug_pub.add('End Update_Prod_Pric_Segment_id');
2781: else
2782: fnd_file.put_line(FND_FILE.LOG, 'End Update_Prod_Pric_Segment_id');
2783: end if;
2784: exception
2785: when no_data_found then
2786: if g_call_from_setup = 'Y' then

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

2785: when no_data_found then
2786: if g_call_from_setup = 'Y' then
2787: oe_debug_pub.add('No data found in Update_Prod_Pric_Segment_id');
2788: else
2789: fnd_file.put_line(FND_FILE.LOG, 'No data found in Update_Prod_Pric_Segment_id');
2790: end if;
2791:
2792: null;
2793:

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

2794: when others then
2795: if g_call_from_setup = 'Y' then
2796: oe_debug_pub.add('ATTR_GRP_PVT.Update_Prod_Pric_Segment_id ' || SQLERRM);
2797: else
2798: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_Prod_Pric_Segment_id ' || SQLERRM );
2799: end if;
2800:
2801: raise;
2802: