APPS.QPR_DELETE_AW dependencies on FND_FILE

Line 42: fnd_file.put_line(fnd_file.log, 'Price Plan not found');

38: exception
39: when no_data_found then
40: retcode := 2;
41: errbuf := sqlerrm;
42: fnd_file.put_line(fnd_file.log, 'Price Plan not found');
43: return;
44: end;
45:
46: begin

Line 54: fnd_file.put_line(fnd_file.log, 'Deal lines exists for this price plan.' ||

50: and rownum < 2;
51:
52: retcode := 1;
53: errbuf := 'Deal lines exists for this price plan';
54: fnd_file.put_line(fnd_file.log, 'Deal lines exists for this price plan.' ||
55: 'Delete deals before deleting priceplan');
56: return;
57: exception
58: when no_data_found then

Line 72: fnd_file.put_line(fnd_file.log,

68: and rownum < 2;
69:
70: retcode := 1;
71: errbuf := 'Price plan present as default priceplan for user(s).';
72: fnd_file.put_line(fnd_file.log,
73: 'Price plan present as default priceplan for user(s).' ||
74: 'Assign a new priceplan as default before deleting priceplan.');
75: return;
76: exception

Line 84: fnd_file.put_line(fnd_file.log,'the analytic workspace '||l_aw_name1||

80:
81: l_stmtnum := 10;
82:
83: if (aw_exists(l_aw_name1)) then
84: fnd_file.put_line(fnd_file.log,'the analytic workspace '||l_aw_name1||
85: 'exists in schema apps '||to_char(sysdate, 'hh24:mi:ss')||' '||l_stmtnum);
86:
87: dbms_aw.aw_detach('APPS',l_aw_name1);
88:

Line 93: fnd_file.put_line(fnd_file.log,'deleted analytic workspace '||l_aw_name1||

89: l_stmtnum := 60;
90:
91: dbms_aw.aw_delete('APPS',l_aw_name1);
92:
93: fnd_file.put_line(fnd_file.log,'deleted analytic workspace '||l_aw_name1||
94: ' '||to_char(sysdate, 'hh24:mi:ss')||' '||l_stmtnum);
95:
96: l_stmtnum := 70;
97:

Line 104: fnd_file.put_line(fnd_file.log,'updated qpr_price_plans table '||

100: where price_plan_id = p_price_plan_id;
101:
102: commit;
103:
104: fnd_file.put_line(fnd_file.log,'updated qpr_price_plans table '||
105: to_char(sysdate, 'hh24:mi:ss')||' '||l_stmtnum);
106:
107: if(p_delete_qpr_tables = 'N') then
108: l_stmtnum := 350;

Line 125: fnd_file.put_line(fnd_file.log,

121: x_msg_data =>l_msg_data
122: );
123:
124: if(l_output2 = l_success) then
125: fnd_file.put_line(fnd_file.log,
126: 'Changed status for reports for analytic workspace '||l_aw_name1);
127: else
128: retcode := 1;
129: errbuf := sqlerrm;

Line 130: fnd_file.put_line(fnd_file.log, 'Unable to reset user report status');

126: 'Changed status for reports for analytic workspace '||l_aw_name1);
127: else
128: retcode := 1;
129: errbuf := sqlerrm;
130: fnd_file.put_line(fnd_file.log, 'Unable to reset user report status');
131: return;
132: end if;
133: end if;
134: else

Line 135: fnd_file.put_line(fnd_file.log,'aw does not exists!! '||

131: return;
132: end if;
133: end if;
134: else
135: fnd_file.put_line(fnd_file.log,'aw does not exists!! '||
136: to_char(sysdate, 'hh24:mi:ss')||' '||L_STMTNUM);
137: end if;
138:
139:

Line 150: fnd_file.put_line(fnd_file.log,'Deleted reports for analytic workspace '||

146: x_return_status => l_output2);
147: l_stmtnum := 110;
148:
149: if(l_output2 = l_success) then
150: fnd_file.put_line(fnd_file.log,'Deleted reports for analytic workspace '||
151: l_aw_name1||' '||to_char(sysdate, 'hh24:mi:ss')||' '||l_stmtnum);
152:
153: l_stmtnum := 120;
154:

Line 163: fnd_file.put_line(fnd_file.log,'deleted dashboards for analytic workspace'

159: x_return_status => l_output3);
160: l_stmtnum := 130;
161:
162: if(l_output3 = l_success) then
163: fnd_file.put_line(fnd_file.log,'deleted dashboards for analytic workspace'
164: ||l_aw_name1||' '||to_char(sysdate, 'hh24:mi:ss')||' '||l_stmtnum);
165:
166: l_stmtnum := 140;
167:

Line 172: fnd_file.put_line(fnd_file.log,'deleted assignment for analytic workspace'

168: l_table_name := 'ASSIGNMENTS';
169:
170: delete from qpr_usr_price_plans where price_plan_id = p_price_plan_id;
171:
172: fnd_file.put_line(fnd_file.log,'deleted assignment for analytic workspace'
173: ||l_aw_name1||' '||to_char(sysdate, 'hh24:mi:ss')||' '||l_stmtnum);
174:
175: else
176: raise l_unable_to_delete;

Line 212: fnd_file.put_line(fnd_file.log,'deleted from qp tables for price_plan_id:'

208: delete from qpr_scopes where parent_entity_type = 'DATAMART'
209: and parent_id = p_price_plan_id;
210: l_stmtnum := 300;
211:
212: fnd_file.put_line(fnd_file.log,'deleted from qp tables for price_plan_id:'
213: ||p_price_plan_id||' '||to_char(sysdate, 'hh24:mi:ss'));
214:
215: elsif(p_delete_qpr_tables = 'N') then
216: fnd_file.put_line(fnd_file.log,

Line 216: fnd_file.put_line(fnd_file.log,

212: fnd_file.put_line(fnd_file.log,'deleted from qp tables for price_plan_id:'
213: ||p_price_plan_id||' '||to_char(sysdate, 'hh24:mi:ss'));
214:
215: elsif(p_delete_qpr_tables = 'N') then
216: fnd_file.put_line(fnd_file.log,
217: 'Price plan tables not deleted as value of qp delete tables = "N" '||
218: ' '||to_char(sysdate, 'hh24:mi:ss'));
219: else
220: l_stmtnum := 320;

Line 228: fnd_file.put_line(fnd_file.log,

224: exception
225: when l_unable_to_delete then
226: retcode := 2;
227: errbuf := sqlerrm;
228: fnd_file.put_line(fnd_file.log,
229: 'Error deleting values for price_plan_id '||p_price_plan_id||
230: ' from the tables'||' '||l_table_name||' '||to_char(sysdate, 'hh24:mi:ss')||
231: ' '||'-');
232: when OTHERS then

Line 235: fnd_file.put_line(fnd_file.log,'Error deleting price plan');

231: ' '||'-');
232: when OTHERS then
233: retcode := 2;
234: errbuf := sqlerrm;
235: fnd_file.put_line(fnd_file.log,'Error deleting price plan');
236: fnd_file.put_line(fnd_file.log, dbms_utility.format_error_backtrace);
237:
238: END DELETE_AW;
239:

Line 236: fnd_file.put_line(fnd_file.log, dbms_utility.format_error_backtrace);

232: when OTHERS then
233: retcode := 2;
234: errbuf := sqlerrm;
235: fnd_file.put_line(fnd_file.log,'Error deleting price plan');
236: fnd_file.put_line(fnd_file.log, dbms_utility.format_error_backtrace);
237:
238: END DELETE_AW;
239:
240: