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.QPR_AW_INTERFACE_PVT dependencies on FND_LOG

Line 9: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

5: (p_aw_name IN varchar2, p_attach_mode IN varchar2, x_return_status OUT NOCOPY varchar2)
6: is
7: execution_string varchar2(100) ;
8: BEGIN
9: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
10: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.ATTACH_AW', 'Attach_aw procedure invoked' );
11: end if;
12:
13: execution_string := 'aw attach '||p_aw_name||' '||p_attach_mode||';';

Line 10: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.ATTACH_AW', 'Attach_aw procedure invoked' );

6: is
7: execution_string varchar2(100) ;
8: BEGIN
9: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
10: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.ATTACH_AW', 'Attach_aw procedure invoked' );
11: end if;
12:
13: execution_string := 'aw attach '||p_aw_name||' '||p_attach_mode||';';
14: -- Attach specified AW in multi mode .

Line 17: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

13: execution_string := 'aw attach '||p_aw_name||' '||p_attach_mode||';';
14: -- Attach specified AW in multi mode .
15: dbms_aw.execute(execution_string);
16:
17: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
18: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.ATTACH_AW', 'DML Program Attach succeeded' );
19: end if;
20:
21: x_return_status := 'success';

Line 18: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.ATTACH_AW', 'DML Program Attach succeeded' );

14: -- Attach specified AW in multi mode .
15: dbms_aw.execute(execution_string);
16:
17: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
18: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.ATTACH_AW', 'DML Program Attach succeeded' );
19: end if;
20:
21: x_return_status := 'success';
22:

Line 23: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

19: end if;
20:
21: x_return_status := 'success';
22:
23: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
24: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.ATTACH_AW', 'Attach_aw was successful' );
25: end if;
26:
27: EXCEPTION

Line 24: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.ATTACH_AW', 'Attach_aw was successful' );

20:
21: x_return_status := 'success';
22:
23: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
24: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.ATTACH_AW', 'Attach_aw was successful' );
25: end if;
26:
27: EXCEPTION
28: when others then

Line 30: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

26:
27: EXCEPTION
28: when others then
29: x_return_status := 'error';
30: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
31: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.ATTACH_AW', 'Attach_aw failed' );
32: end if;
33:
34: END attach_aw;

Line 31: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.ATTACH_AW', 'Attach_aw failed' );

27: EXCEPTION
28: when others then
29: x_return_status := 'error';
30: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
31: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.ATTACH_AW', 'Attach_aw failed' );
32: end if;
33:
34: END attach_aw;
35:

Line 42: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

38: (p_aw_name IN varchar2,x_return_status OUT NOCOPY varchar2)
39: is
40: execution_string varchar2(100);
41: BEGIN
42: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
43: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.DETACH_AW', 'Detach_aw procedure invoked' );
44: end if;
45: execution_string := 'aw detach '||p_aw_name||';';
46: -- Detached specified AW

Line 43: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.DETACH_AW', 'Detach_aw procedure invoked' );

39: is
40: execution_string varchar2(100);
41: BEGIN
42: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
43: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.DETACH_AW', 'Detach_aw procedure invoked' );
44: end if;
45: execution_string := 'aw detach '||p_aw_name||';';
46: -- Detached specified AW
47: dbms_aw.execute(execution_string);

Line 48: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

44: end if;
45: execution_string := 'aw detach '||p_aw_name||';';
46: -- Detached specified AW
47: dbms_aw.execute(execution_string);
48: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
49: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.DETACH_AW', 'DML Program DETACH succeeded' );
50: end if;
51: x_return_status := 'success';
52: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 49: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.DETACH_AW', 'DML Program DETACH succeeded' );

45: execution_string := 'aw detach '||p_aw_name||';';
46: -- Detached specified AW
47: dbms_aw.execute(execution_string);
48: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
49: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.DETACH_AW', 'DML Program DETACH succeeded' );
50: end if;
51: x_return_status := 'success';
52: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
53: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.DETACH_AW', 'Detach_aw program succeeded' );

Line 52: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

48: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
49: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.DETACH_AW', 'DML Program DETACH succeeded' );
50: end if;
51: x_return_status := 'success';
52: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
53: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.DETACH_AW', 'Detach_aw program succeeded' );
54: end if;
55: EXCEPTION
56: when others then

Line 53: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.DETACH_AW', 'Detach_aw program succeeded' );

49: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.DETACH_AW', 'DML Program DETACH succeeded' );
50: end if;
51: x_return_status := 'success';
52: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
53: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.DETACH_AW', 'Detach_aw program succeeded' );
54: end if;
55: EXCEPTION
56: when others then
57: x_return_status := 'error';

Line 58: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

54: end if;
55: EXCEPTION
56: when others then
57: x_return_status := 'error';
58: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
59: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.DETACH_AW', 'Detach_aw program failed' );
60: end if;
61: END detach_aw;
62: -- writeback_aw

Line 59: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.DETACH_AW', 'Detach_aw program failed' );

55: EXCEPTION
56: when others then
57: x_return_status := 'error';
58: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
59: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.DETACH_AW', 'Detach_aw program failed' );
60: end if;
61: END detach_aw;
62: -- writeback_aw
63: /*

Line 75: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

71: cell_id int := 1;
72: dimCheck boolean := false;
73: modMeasVal varchar2(100);
74: begin
75: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.WRITEBACK_AW', 'writeback_aw procedure invoked' );
77: end if;
78: << outer_loop >>
79: while (1=1)

Line 76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.WRITEBACK_AW', 'writeback_aw procedure invoked' );

72: dimCheck boolean := false;
73: modMeasVal varchar2(100);
74: begin
75: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.WRITEBACK_AW', 'writeback_aw procedure invoked' );
77: end if;
78: << outer_loop >>
79: while (1=1)
80: loop

Line 118: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

114: dimCheck := false;
115: end loop outer_loop;
116: dbms_aw.execute('ALLSTAT;');
117: x_return_status := 'success';
118: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
119: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.WRITEBACK_AW', 'WRITEBACK_AW procedure succeeded' );
120: end if;
121: EXCEPTION
122: when others then

Line 119: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.WRITEBACK_AW', 'WRITEBACK_AW procedure succeeded' );

115: end loop outer_loop;
116: dbms_aw.execute('ALLSTAT;');
117: x_return_status := 'success';
118: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
119: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.WRITEBACK_AW', 'WRITEBACK_AW procedure succeeded' );
120: end if;
121: EXCEPTION
122: when others then
123: x_return_status := 'error';

Line 124: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

120: end if;
121: EXCEPTION
122: when others then
123: x_return_status := 'error';
124: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
125: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.WRITEBACK_AW', 'WRITEBACK_AW procedure failed '||sqlcode||' '||sqlerrm);
126: end if;
127:
128: end writeback_aw;

Line 125: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.WRITEBACK_AW', 'WRITEBACK_AW procedure failed '||sqlcode||' '||sqlerrm);

121: EXCEPTION
122: when others then
123: x_return_status := 'error';
124: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
125: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.WRITEBACK_AW', 'WRITEBACK_AW procedure failed '||sqlcode||' '||sqlerrm);
126: end if;
127:
128: end writeback_aw;
129: */

Line 137: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

133: AS
134: cmdString varchar2(4000);
135: dimName varchar2(4000);
136: BEGIN
137: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
138: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'EXECUTEMODEL procedure invoked' );
139: end if;
140:
141: dimName := '';

Line 138: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'EXECUTEMODEL procedure invoked' );

134: cmdString varchar2(4000);
135: dimName varchar2(4000);
136: BEGIN
137: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
138: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'EXECUTEMODEL procedure invoked' );
139: end if;
140:
141: dimName := '';
142:

Line 153: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

149: end if;
150: end loop;
151: dbms_aw.execute(cmdString);
152:
153: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'Scope set for the execution of the model' );
155: end if;
156:
157:

Line 154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'Scope set for the execution of the model' );

150: end loop;
151: dbms_aw.execute(cmdString);
152:
153: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'Scope set for the execution of the model' );
155: end if;
156:
157:
158:

Line 168: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

164: dbms_aw.execute('naskip2 = yes');
165: dbms_aw.execute(modelName ||' '||modelMeasName);
166: dbms_aw.execute('naskip2 = no');
167:
168: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'Model '||modelName ||' Executed successfully ');
170: end if;
171:
172:

Line 169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'Model '||modelName ||' Executed successfully ');

165: dbms_aw.execute(modelName ||' '||modelMeasName);
166: dbms_aw.execute('naskip2 = no');
167:
168: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'Model '||modelName ||' Executed successfully ');
170: end if;
171:
172:
173:

Line 180: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

176: cmdString := cmdString || 'limit '||modelDimension ||' to '||''''||writeBackMeas(i).measPPACode||''''||' ;';
177: cmdString := cmdString ||writeBackMeas(i).measId ||' = ' ||modelMeasName||' ; ';
178: end loop;
179: dbms_aw.execute(cmdString);
180: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'Measure Values written back after the execution of model');
182: end if;
183:
184: cmdString := 'ALLSTAT;';

Line 181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'Measure Values written back after the execution of model');

177: cmdString := cmdString ||writeBackMeas(i).measId ||' = ' ||modelMeasName||' ; ';
178: end loop;
179: dbms_aw.execute(cmdString);
180: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'Measure Values written back after the execution of model');
182: end if;
183:
184: cmdString := 'ALLSTAT;';
185: dbms_aw.execute(cmdString);

Line 187: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

183:
184: cmdString := 'ALLSTAT;';
185: dbms_aw.execute(cmdString);
186: x_return_status := 'success';
187: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
188: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'ExecuteModel Procedure successful');
189: end if;
190:
191: EXCEPTION

Line 188: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'ExecuteModel Procedure successful');

184: cmdString := 'ALLSTAT;';
185: dbms_aw.execute(cmdString);
186: x_return_status := 'success';
187: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
188: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'ExecuteModel Procedure successful');
189: end if;
190:
191: EXCEPTION
192: when others then

Line 194: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

190:
191: EXCEPTION
192: when others then
193: x_return_status := 'error';
194: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
195: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'ExecuteModel Procedure failed '||sqlcode||' '||sqlerrm);
196: end if;
197: END;
198:

Line 195: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'ExecuteModel Procedure failed '||sqlcode||' '||sqlerrm);

191: EXCEPTION
192: when others then
193: x_return_status := 'error';
194: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
195: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'ExecuteModel Procedure failed '||sqlcode||' '||sqlerrm);
196: end if;
197: END;
198:
199: --Commit

Line 212: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

208: PRAGMA EXCEPTION_INIT(LOCK_ACQUIRE_FAILED3, -37011);
209: cmdString varchar2(4000);
210: measString varchar2(4000);
211: BEGIN
212: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
213: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Procedure CommitData Invoked');
214: end if;
215:
216:

Line 213: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Procedure CommitData Invoked');

209: cmdString varchar2(4000);
210: measString varchar2(4000);
211: BEGIN
212: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
213: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Procedure CommitData Invoked');
214: end if;
215:
216:
217: cmdString := '';

Line 228: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

224: end if;
225: end loop;
226: cmdString := 'acquire '||measString||';';
227: dbms_aw.execute(cmdString);
228: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Acquired the lock for the measures that are to be committed');
230: end if;
231:
232:

Line 229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Acquired the lock for the measures that are to be committed');

225: end loop;
226: cmdString := 'acquire '||measString||';';
227: dbms_aw.execute(cmdString);
228: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Acquired the lock for the measures that are to be committed');
230: end if;
231:
232:
233:

Line 237: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

233:
234: cmdString := 'UPDATE;';
235: dbms_aw.execute(cmdString);
236:
237: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
238: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Update of measures Successful');
239: end if;
240:
241:

Line 238: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Update of measures Successful');

234: cmdString := 'UPDATE;';
235: dbms_aw.execute(cmdString);
236:
237: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
238: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Update of measures Successful');
239: end if;
240:
241:
242: cmdString := 'COMMIT;';

Line 245: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

241:
242: cmdString := 'COMMIT;';
243: dbms_aw.execute(cmdString);
244:
245: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
246: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Commit measure values Successful');
247: end if;
248:
249:

Line 246: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Commit measure values Successful');

242: cmdString := 'COMMIT;';
243: dbms_aw.execute(cmdString);
244:
245: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
246: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Commit measure values Successful');
247: end if;
248:
249:
250: cmdString := 'Release '|| measString ||';';

Line 253: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

249:
250: cmdString := 'Release '|| measString ||';';
251: dbms_aw.execute(cmdString);
252:
253: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
254: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Released the lock acquired on the measures');
255: end if;
256: x_return_status := 'success';
257: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 254: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Released the lock acquired on the measures');

250: cmdString := 'Release '|| measString ||';';
251: dbms_aw.execute(cmdString);
252:
253: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
254: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Released the lock acquired on the measures');
255: end if;
256: x_return_status := 'success';
257: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
258: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'CommitData Procedure Successful');

Line 257: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

253: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
254: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Released the lock acquired on the measures');
255: end if;
256: x_return_status := 'success';
257: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
258: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'CommitData Procedure Successful');
259: end if;
260: EXCEPTION
261: WHEN LOCK_ACQUIRE_FAILED1 THEN

Line 258: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'CommitData Procedure Successful');

254: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Released the lock acquired on the measures');
255: end if;
256: x_return_status := 'success';
257: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
258: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'CommitData Procedure Successful');
259: end if;
260: EXCEPTION
261: WHEN LOCK_ACQUIRE_FAILED1 THEN
262: x_return_status := 'LOCK_ACQUIRE_FAILED';

Line 263: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

259: end if;
260: EXCEPTION
261: WHEN LOCK_ACQUIRE_FAILED1 THEN
262: x_return_status := 'LOCK_ACQUIRE_FAILED';
263: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
264: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'CommitData Procedure failed '||x_return_status||sqlcode||' '||sqlerrm);
265: end if;
266:
267: WHEN LOCK_ACQUIRE_FAILED2 THEN

Line 264: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'CommitData Procedure failed '||x_return_status||sqlcode||' '||sqlerrm);

260: EXCEPTION
261: WHEN LOCK_ACQUIRE_FAILED1 THEN
262: x_return_status := 'LOCK_ACQUIRE_FAILED';
263: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
264: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'CommitData Procedure failed '||x_return_status||sqlcode||' '||sqlerrm);
265: end if;
266:
267: WHEN LOCK_ACQUIRE_FAILED2 THEN
268: x_return_status := 'LOCK_ACQUIRE_FAILED';

Line 269: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

265: end if;
266:
267: WHEN LOCK_ACQUIRE_FAILED2 THEN
268: x_return_status := 'LOCK_ACQUIRE_FAILED';
269: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
270: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'CommitData Procedure failed '||x_return_status||sqlcode||' '||sqlerrm);
271: end if;
272:
273: WHEN LOCK_ACQUIRE_FAILED3 THEN

Line 270: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'CommitData Procedure failed '||x_return_status||sqlcode||' '||sqlerrm);

266:
267: WHEN LOCK_ACQUIRE_FAILED2 THEN
268: x_return_status := 'LOCK_ACQUIRE_FAILED';
269: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
270: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'CommitData Procedure failed '||x_return_status||sqlcode||' '||sqlerrm);
271: end if;
272:
273: WHEN LOCK_ACQUIRE_FAILED3 THEN
274: x_return_status := 'LOCK_ACQUIRE_FAILED';

Line 275: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

271: end if;
272:
273: WHEN LOCK_ACQUIRE_FAILED3 THEN
274: x_return_status := 'LOCK_ACQUIRE_FAILED';
275: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
276: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'CommitData Procedure failed '||x_return_status||sqlcode||' '||sqlerrm);
277: end if;
278:
279: when others then

Line 276: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'CommitData Procedure failed '||x_return_status||sqlcode||' '||sqlerrm);

272:
273: WHEN LOCK_ACQUIRE_FAILED3 THEN
274: x_return_status := 'LOCK_ACQUIRE_FAILED';
275: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
276: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'CommitData Procedure failed '||x_return_status||sqlcode||' '||sqlerrm);
277: end if;
278:
279: when others then
280: x_return_status := 'error';

Line 281: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

277: end if;
278:
279: when others then
280: x_return_status := 'error';
281: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
282: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'CommitData Procedure failed '||x_return_status||sqlcode||' '||sqlerrm);
283: end if;
284:
285: END;

Line 282: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'CommitData Procedure failed '||x_return_status||sqlcode||' '||sqlerrm);

278:
279: when others then
280: x_return_status := 'error';
281: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
282: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'CommitData Procedure failed '||x_return_status||sqlcode||' '||sqlerrm);
283: end if;
284:
285: END;
286:

Line 295: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

291: PRAGMA EXCEPTION_INIT(LOCK_ACQUIRE_FAILED1, -37040);
292: PRAGMA EXCEPTION_INIT(LOCK_ACQUIRE_FAILED2, -37011);
293: dimString varchar2(4000);
294: begin
295: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.handleMeas','Enter '||acquire);
297: end if;
298:
299: for i in 1..dim.count loop

Line 296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.handleMeas','Enter '||acquire);

292: PRAGMA EXCEPTION_INIT(LOCK_ACQUIRE_FAILED2, -37011);
293: dimString varchar2(4000);
294: begin
295: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.handleMeas','Enter '||acquire);
297: end if;
298:
299: for i in 1..dim.count loop
300: if(i = 1) then

Line 326: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

322:
323: EXCEPTION
324: WHEN LOCK_ACQUIRE_FAILED1 THEN
325: x_return_status := 'LOCK_ACQUIRE_FAILED';
326: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
327: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.handleMeas', x_return_status||' '||sqlcode||' '||sqlerrm);
328: end if;
329:
330: WHEN LOCK_ACQUIRE_FAILED2 THEN

Line 327: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.handleMeas', x_return_status||' '||sqlcode||' '||sqlerrm);

323: EXCEPTION
324: WHEN LOCK_ACQUIRE_FAILED1 THEN
325: x_return_status := 'LOCK_ACQUIRE_FAILED';
326: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
327: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.handleMeas', x_return_status||' '||sqlcode||' '||sqlerrm);
328: end if;
329:
330: WHEN LOCK_ACQUIRE_FAILED2 THEN
331: x_return_status := 'LOCK_ACQUIRE_FAILED';

Line 332: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

328: end if;
329:
330: WHEN LOCK_ACQUIRE_FAILED2 THEN
331: x_return_status := 'LOCK_ACQUIRE_FAILED';
332: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
333: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.handleMeas', x_return_status||' '||sqlcode||' '||sqlerrm);
334: end if;
335:
336: when others then

Line 333: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.handleMeas', x_return_status||' '||sqlcode||' '||sqlerrm);

329:
330: WHEN LOCK_ACQUIRE_FAILED2 THEN
331: x_return_status := 'LOCK_ACQUIRE_FAILED';
332: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
333: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.handleMeas', x_return_status||' '||sqlcode||' '||sqlerrm);
334: end if;
335:
336: when others then
337: x_return_status := 'error';

Line 338: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

334: end if;
335:
336: when others then
337: x_return_status := 'error';
338: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
339: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.handleMeas', x_return_status||' '||sqlcode||' '||sqlerrm);
340: end if;
341: end;*/
342:

Line 339: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.handleMeas', x_return_status||' '||sqlcode||' '||sqlerrm);

335:
336: when others then
337: x_return_status := 'error';
338: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
339: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.handleMeas', x_return_status||' '||sqlcode||' '||sqlerrm);
340: end if;
341: end;*/
342:
343: END QPR_AW_INTERFACE_PVT;