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

Line 44: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

40:
41:
42: BEGIN
43:
44: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
45: fnd_log.string
46: (
47: FND_LOG.LEVEL_PROCEDURE,
48: 'fpa.sql.fpa_scenario_pvt.create_scenario.begin',

Line 45: fnd_log.string

41:
42: BEGIN
43:
44: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
45: fnd_log.string
46: (
47: FND_LOG.LEVEL_PROCEDURE,
48: 'fpa.sql.fpa_scenario_pvt.create_scenario.begin',
49: 'Entering fpa_scenario_pvt.create_scenario'

Line 47: FND_LOG.LEVEL_PROCEDURE,

43:
44: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
45: fnd_log.string
46: (
47: FND_LOG.LEVEL_PROCEDURE,
48: 'fpa.sql.fpa_scenario_pvt.create_scenario.begin',
49: 'Entering fpa_scenario_pvt.create_scenario'
50: );
51: END IF;

Line 53: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

49: 'Entering fpa_scenario_pvt.create_scenario'
50: );
51: END IF;
52:
53: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
54: fnd_log.string
55: (
56: FND_LOG.LEVEL_PROCEDURE,
57: 'fpa.sql.fpa_scenario_pvt.create_scenario',

Line 54: fnd_log.string

50: );
51: END IF;
52:
53: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
54: fnd_log.string
55: (
56: FND_LOG.LEVEL_PROCEDURE,
57: 'fpa.sql.fpa_scenario_pvt.create_scenario',
58: 'Getting next sequence value for scenario id.'

Line 56: FND_LOG.LEVEL_PROCEDURE,

52:
53: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
54: fnd_log.string
55: (
56: FND_LOG.LEVEL_PROCEDURE,
57: 'fpa.sql.fpa_scenario_pvt.create_scenario',
58: 'Getting next sequence value for scenario id.'
59: );
60: END IF;

Line 67: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

63: OPEN scenario_s_c;
64: FETCH scenario_s_c INTO x_scenario_id;
65: CLOSE scenario_s_c;
66:
67: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
68: fnd_log.string
69: (
70: FND_LOG.LEVEL_PROCEDURE,
71: 'fpa.sql.fpa_scenario_pvt.create_scenario',

Line 68: fnd_log.string

64: FETCH scenario_s_c INTO x_scenario_id;
65: CLOSE scenario_s_c;
66:
67: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
68: fnd_log.string
69: (
70: FND_LOG.LEVEL_PROCEDURE,
71: 'fpa.sql.fpa_scenario_pvt.create_scenario',
72: 'Maintaing scenario dimension with new scenario id.'

Line 70: FND_LOG.LEVEL_PROCEDURE,

66:
67: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
68: fnd_log.string
69: (
70: FND_LOG.LEVEL_PROCEDURE,
71: 'fpa.sql.fpa_scenario_pvt.create_scenario',
72: 'Maintaing scenario dimension with new scenario id.'
73: );
74: END IF;

Line 80: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

76: -- Add the new scenario to the dimension
77: dbms_aw.execute('MAINTAIN scenario_d ADD ' || x_scenario_id);
78:
79:
80: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
81: fnd_log.string
82: (
83: FND_LOG.LEVEL_PROCEDURE,
84: 'fpa.sql.fpa_scenario_pvt.create_scenario',

Line 81: fnd_log.string

77: dbms_aw.execute('MAINTAIN scenario_d ADD ' || x_scenario_id);
78:
79:
80: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
81: fnd_log.string
82: (
83: FND_LOG.LEVEL_PROCEDURE,
84: 'fpa.sql.fpa_scenario_pvt.create_scenario',
85: 'Setting PC relation for new scenario.'

Line 83: FND_LOG.LEVEL_PROCEDURE,

79:
80: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
81: fnd_log.string
82: (
83: FND_LOG.LEVEL_PROCEDURE,
84: 'fpa.sql.fpa_scenario_pvt.create_scenario',
85: 'Setting PC relation for new scenario.'
86: );
87: END IF;

Line 95: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

91: -- Associate the scenario with the planning cycle
92: dbms_aw.execute('planning_cycle_scenario_r = ' || p_pc_id);
93: dbms_aw.execute('POP scenario_d');
94:
95: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
96: fnd_log.string
97: (
98: FND_LOG.LEVEL_PROCEDURE,
99: 'fpa.sql.fpa_scenario_pvt.create_scenario',

Line 96: fnd_log.string

92: dbms_aw.execute('planning_cycle_scenario_r = ' || p_pc_id);
93: dbms_aw.execute('POP scenario_d');
94:
95: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
96: fnd_log.string
97: (
98: FND_LOG.LEVEL_PROCEDURE,
99: 'fpa.sql.fpa_scenario_pvt.create_scenario',
100: 'Updating FPA_OBJECTS_TL with scenario information name not null.'

Line 98: FND_LOG.LEVEL_PROCEDURE,

94:
95: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
96: fnd_log.string
97: (
98: FND_LOG.LEVEL_PROCEDURE,
99: 'fpa.sql.fpa_scenario_pvt.create_scenario',
100: 'Updating FPA_OBJECTS_TL with scenario information name not null.'
101: );
102: END IF;

Line 106: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

102: END IF;
103:
104: if (p_scenario_name is not null) then
105:
106: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
107: fnd_log.string
108: (
109: FND_LOG.LEVEL_PROCEDURE,
110: 'fpa.sql.fpa_scenario_pvt.create_scenario',

Line 107: fnd_log.string

103:
104: if (p_scenario_name is not null) then
105:
106: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
107: fnd_log.string
108: (
109: FND_LOG.LEVEL_PROCEDURE,
110: 'fpa.sql.fpa_scenario_pvt.create_scenario',
111: 'Scenario name is not null, Updating FPA_OBJECTS_TL with scenario information name not null.'

Line 109: FND_LOG.LEVEL_PROCEDURE,

105:
106: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
107: fnd_log.string
108: (
109: FND_LOG.LEVEL_PROCEDURE,
110: 'fpa.sql.fpa_scenario_pvt.create_scenario',
111: 'Scenario name is not null, Updating FPA_OBJECTS_TL with scenario information name not null.'
112: );
113: END IF;

Line 148: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

144: CLOSE l_language_csr;
145:
146: end if;
147:
148: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
149: fnd_log.string
150: (
151: FND_LOG.LEVEL_PROCEDURE,
152: 'fpa.sql.fpa_scenario_pvt.create_scenario.end',

Line 149: fnd_log.string

145:
146: end if;
147:
148: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
149: fnd_log.string
150: (
151: FND_LOG.LEVEL_PROCEDURE,
152: 'fpa.sql.fpa_scenario_pvt.create_scenario.end',
153: 'Exiting fpa_scenario_pvt.create_scenario'

Line 151: FND_LOG.LEVEL_PROCEDURE,

147:
148: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
149: fnd_log.string
150: (
151: FND_LOG.LEVEL_PROCEDURE,
152: 'fpa.sql.fpa_scenario_pvt.create_scenario.end',
153: 'Exiting fpa_scenario_pvt.create_scenario'
154: );
155: END IF;

Line 161: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

157: EXCEPTION
158: WHEN OTHERS THEN
159: ROLLBACK;
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
162: fnd_log.string
163: (
164: FND_LOG.LEVEL_ERROR,
165: 'fpa.sql.fpa_scenario_pvt.create_scenario',

Line 162: fnd_log.string

158: WHEN OTHERS THEN
159: ROLLBACK;
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
162: fnd_log.string
163: (
164: FND_LOG.LEVEL_ERROR,
165: 'fpa.sql.fpa_scenario_pvt.create_scenario',
166: SQLERRM

Line 164: FND_LOG.LEVEL_ERROR,

160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
162: fnd_log.string
163: (
164: FND_LOG.LEVEL_ERROR,
165: 'fpa.sql.fpa_scenario_pvt.create_scenario',
166: SQLERRM
167: );
168: END IF;

Line 196: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

192: l_api_version CONSTANT NUMBER := 1.0;
193:
194: begin
195:
196: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
197: fnd_log.string
198: (
199: FND_LOG.LEVEL_PROCEDURE,
200: 'fpa.sql.fpa_scenario_pvt.copy_scenario_data.begin',

Line 197: fnd_log.string

193:
194: begin
195:
196: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
197: fnd_log.string
198: (
199: FND_LOG.LEVEL_PROCEDURE,
200: 'fpa.sql.fpa_scenario_pvt.copy_scenario_data.begin',
201: 'Entering fpa_scenario_pvt.copy_scenario_data'

Line 199: FND_LOG.LEVEL_PROCEDURE,

195:
196: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
197: fnd_log.string
198: (
199: FND_LOG.LEVEL_PROCEDURE,
200: 'fpa.sql.fpa_scenario_pvt.copy_scenario_data.begin',
201: 'Entering fpa_scenario_pvt.copy_scenario_data'
202: );
203: END IF;

Line 205: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

201: 'Entering fpa_scenario_pvt.copy_scenario_data'
202: );
203: END IF;
204:
205: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
206: fnd_log.string
207: (
208: FND_LOG.LEVEL_PROCEDURE,
209: 'fpa.sql.fpa_scenario_pvt.copy_scenario_data.begin',

Line 206: fnd_log.string

202: );
203: END IF;
204:
205: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
206: fnd_log.string
207: (
208: FND_LOG.LEVEL_PROCEDURE,
209: 'fpa.sql.fpa_scenario_pvt.copy_scenario_data.begin',
210: 'Calling AW program COPY_SCE_DATA_PRG for scenario source: ' || p_scenario_id_source || ' and scenario target: ' || p_scenario_id_target || ' and copy flag: ' || p_copy_proposed_proj || 'values.'

Line 208: FND_LOG.LEVEL_PROCEDURE,

204:
205: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
206: fnd_log.string
207: (
208: FND_LOG.LEVEL_PROCEDURE,
209: 'fpa.sql.fpa_scenario_pvt.copy_scenario_data.begin',
210: 'Calling AW program COPY_SCE_DATA_PRG for scenario source: ' || p_scenario_id_source || ' and scenario target: ' || p_scenario_id_target || ' and copy flag: ' || p_copy_proposed_proj || 'values.'
211: );
212: END IF;

Line 214: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

210: 'Calling AW program COPY_SCE_DATA_PRG for scenario source: ' || p_scenario_id_source || ' and scenario target: ' || p_scenario_id_target || ' and copy flag: ' || p_copy_proposed_proj || 'values.'
211: );
212: END IF;
213:
214: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
215: fnd_log.string
216: (
217: FND_LOG.LEVEL_PROCEDURE,
218: 'fpa.sql.fpa_scenario_pvt.copy_scenario_data.begin',

Line 215: fnd_log.string

211: );
212: END IF;
213:
214: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
215: fnd_log.string
216: (
217: FND_LOG.LEVEL_PROCEDURE,
218: 'fpa.sql.fpa_scenario_pvt.copy_scenario_data.begin',
219: 'call copy_sce_data_prg(' || p_scenario_id_source || ' ' || p_scenario_id_target || ' ''' || p_copy_proposed_proj || ''')'

Line 217: FND_LOG.LEVEL_PROCEDURE,

213:
214: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
215: fnd_log.string
216: (
217: FND_LOG.LEVEL_PROCEDURE,
218: 'fpa.sql.fpa_scenario_pvt.copy_scenario_data.begin',
219: 'call copy_sce_data_prg(' || p_scenario_id_source || ' ' || p_scenario_id_target || ' ''' || p_copy_proposed_proj || ''')'
220: );
221: END IF;

Line 226: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

222:
223:
224: dbms_aw.execute('call copy_sce_data_prg(' || p_scenario_id_source || ' ' || p_scenario_id_target || ' ''' || p_copy_proposed_proj || ''')');
225:
226: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
227: fnd_log.string
228: (
229: FND_LOG.LEVEL_PROCEDURE,
230: 'fpa.sql.fpa_scenario_pvt.copy_scenario_data.end',

Line 227: fnd_log.string

223:
224: dbms_aw.execute('call copy_sce_data_prg(' || p_scenario_id_source || ' ' || p_scenario_id_target || ' ''' || p_copy_proposed_proj || ''')');
225:
226: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
227: fnd_log.string
228: (
229: FND_LOG.LEVEL_PROCEDURE,
230: 'fpa.sql.fpa_scenario_pvt.copy_scenario_data.end',
231: 'Entering fpa_scenario_pvt.copy_scenario_data'

Line 229: FND_LOG.LEVEL_PROCEDURE,

225:
226: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
227: fnd_log.string
228: (
229: FND_LOG.LEVEL_PROCEDURE,
230: 'fpa.sql.fpa_scenario_pvt.copy_scenario_data.end',
231: 'Entering fpa_scenario_pvt.copy_scenario_data'
232: );
233: END IF;

Line 239: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

235: EXCEPTION
236: WHEN OTHERS THEN
237: ROLLBACK;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
240: fnd_log.string
241: (
242: FND_LOG.LEVEL_ERROR,
243: 'fpa.sql.fpa_scenario_pvt.create_scenario',

Line 240: fnd_log.string

236: WHEN OTHERS THEN
237: ROLLBACK;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
240: fnd_log.string
241: (
242: FND_LOG.LEVEL_ERROR,
243: 'fpa.sql.fpa_scenario_pvt.create_scenario',
244: SQLERRM

Line 242: FND_LOG.LEVEL_ERROR,

238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
240: fnd_log.string
241: (
242: FND_LOG.LEVEL_ERROR,
243: 'fpa.sql.fpa_scenario_pvt.create_scenario',
244: SQLERRM
245: );
246: END IF;

Line 269: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

265: x_msg_data OUT NOCOPY VARCHAR2
266: )
267: IS
268: BEGIN
269: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
270: fnd_log.string
271: (
272: FND_LOG.LEVEL_PROCEDURE,
273: 'fpa.sql.fpa_scenario_pvt.lock_scenario.begin',

Line 270: fnd_log.string

266: )
267: IS
268: BEGIN
269: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
270: fnd_log.string
271: (
272: FND_LOG.LEVEL_PROCEDURE,
273: 'fpa.sql.fpa_scenario_pvt.lock_scenario.begin',
274: 'Entering fpa_project_pvt.lock_scenario'

Line 272: FND_LOG.LEVEL_PROCEDURE,

268: BEGIN
269: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
270: fnd_log.string
271: (
272: FND_LOG.LEVEL_PROCEDURE,
273: 'fpa.sql.fpa_scenario_pvt.lock_scenario.begin',
274: 'Entering fpa_project_pvt.lock_scenario'
275: );
276: END IF;

Line 280: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

276: END IF;
277:
278: IF g_attach_aw THEN
279: -- Attach the AW space read write.
280: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
281: fnd_log.string
282: (
283: FND_LOG.LEVEL_STATEMENT,
284: 'fpa.sql.fpa_scenario_pvt.lock_scenario',

Line 281: fnd_log.string

277:
278: IF g_attach_aw THEN
279: -- Attach the AW space read write.
280: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
281: fnd_log.string
282: (
283: FND_LOG.LEVEL_STATEMENT,
284: 'fpa.sql.fpa_scenario_pvt.lock_scenario',
285: 'Attaching OLAP workspace: '

Line 283: FND_LOG.LEVEL_STATEMENT,

279: -- Attach the AW space read write.
280: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
281: fnd_log.string
282: (
283: FND_LOG.LEVEL_STATEMENT,
284: 'fpa.sql.fpa_scenario_pvt.lock_scenario',
285: 'Attaching OLAP workspace: '
286: );
287: END IF;

Line 309: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

305: COMMIT;
306: END IF;
307:
308: -- Finally, detach the workspace
309: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
310: fnd_log.string
311: (
312: FND_LOG.LEVEL_STATEMENT,
313: 'fpa.sql.fpa_scenario_pvt.lock_scenario',

Line 310: fnd_log.string

306: END IF;
307:
308: -- Finally, detach the workspace
309: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
310: fnd_log.string
311: (
312: FND_LOG.LEVEL_STATEMENT,
313: 'fpa.sql.fpa_scenario_pvt.lock_scenario',
314: 'Detaching OLAP workspace: '

Line 312: FND_LOG.LEVEL_STATEMENT,

308: -- Finally, detach the workspace
309: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
310: fnd_log.string
311: (
312: FND_LOG.LEVEL_STATEMENT,
313: 'fpa.sql.fpa_scenario_pvt.lock_scenario',
314: 'Detaching OLAP workspace: '
315: );
316: END IF;

Line 319: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

315: );
316: END IF;
317: END IF;
318:
319: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
320: fnd_log.string
321: (
322: FND_LOG.LEVEL_PROCEDURE,
323: 'fpa.sql.fpa_scenario_pvt.lock_scenario.end',

Line 320: fnd_log.string

316: END IF;
317: END IF;
318:
319: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
320: fnd_log.string
321: (
322: FND_LOG.LEVEL_PROCEDURE,
323: 'fpa.sql.fpa_scenario_pvt.lock_scenario.end',
324: 'Exiting fpa_scenario_pvt.lock_scenario'

Line 322: FND_LOG.LEVEL_PROCEDURE,

318:
319: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
320: fnd_log.string
321: (
322: FND_LOG.LEVEL_PROCEDURE,
323: 'fpa.sql.fpa_scenario_pvt.lock_scenario.end',
324: 'Exiting fpa_scenario_pvt.lock_scenario'
325: );
326: END IF;

Line 333: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

329: WHEN OTHERS THEN
330: ROLLBACK;
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332:
333: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
334: fnd_log.string
335: (
336: FND_LOG.LEVEL_ERROR,
337: 'fpa.sql.fpa_scenario_pvt.lock_scenario',

Line 334: fnd_log.string

330: ROLLBACK;
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332:
333: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
334: fnd_log.string
335: (
336: FND_LOG.LEVEL_ERROR,
337: 'fpa.sql.fpa_scenario_pvt.lock_scenario',
338: SQLERRM

Line 336: FND_LOG.LEVEL_ERROR,

332:
333: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
334: fnd_log.string
335: (
336: FND_LOG.LEVEL_ERROR,
337: 'fpa.sql.fpa_scenario_pvt.lock_scenario',
338: SQLERRM
339: );
340: END IF;

Line 378: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

374: EXCEPTION
375: WHEN OTHERS THEN
376: ROLLBACK;
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
379: fnd_log.string
380: (
381: FND_LOG.LEVEL_ERROR,
382: 'fpa_scenario_pvt.Check_scenario_name',

Line 379: fnd_log.string

375: WHEN OTHERS THEN
376: ROLLBACK;
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
379: fnd_log.string
380: (
381: FND_LOG.LEVEL_ERROR,
382: 'fpa_scenario_pvt.Check_scenario_name',
383: SQLERRM

Line 381: FND_LOG.LEVEL_ERROR,

377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
379: fnd_log.string
380: (
381: FND_LOG.LEVEL_ERROR,
382: 'fpa_scenario_pvt.Check_scenario_name',
383: SQLERRM
384: );
385: END IF;

Line 411: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

407:
408: begin
409:
410:
411: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
412: fnd_log.string
413: (
414: FND_LOG.LEVEL_PROCEDURE,
415: 'fpa.sql.fpa_scenario_pvt.update_scen_approved_flag.begin',

Line 412: fnd_log.string

408: begin
409:
410:
411: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
412: fnd_log.string
413: (
414: FND_LOG.LEVEL_PROCEDURE,
415: 'fpa.sql.fpa_scenario_pvt.update_scen_approved_flag.begin',
416: 'Entering fpa_scenario_pvt.update_scen_approved_flag'

Line 414: FND_LOG.LEVEL_PROCEDURE,

410:
411: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
412: fnd_log.string
413: (
414: FND_LOG.LEVEL_PROCEDURE,
415: 'fpa.sql.fpa_scenario_pvt.update_scen_approved_flag.begin',
416: 'Entering fpa_scenario_pvt.update_scen_approved_flag'
417: );
418: END IF;

Line 436: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

432:
433: -- Set the last update date
434: -- need to wite code for this
435:
436: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
437: fnd_log.string
438: (
439: FND_LOG.LEVEL_PROCEDURE,
440: 'fpa.sql.fpa_scenario_pvt.update_scen_approved_flag.end',

Line 437: fnd_log.string

433: -- Set the last update date
434: -- need to wite code for this
435:
436: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
437: fnd_log.string
438: (
439: FND_LOG.LEVEL_PROCEDURE,
440: 'fpa.sql.fpa_scenario_pvt.update_scen_approved_flag.end',
441: 'Exiting fpa_scenario_pvt.update_scen_approved_flag'

Line 439: FND_LOG.LEVEL_PROCEDURE,

435:
436: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
437: fnd_log.string
438: (
439: FND_LOG.LEVEL_PROCEDURE,
440: 'fpa.sql.fpa_scenario_pvt.update_scen_approved_flag.end',
441: 'Exiting fpa_scenario_pvt.update_scen_approved_flag'
442: );
443: END IF;

Line 450: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

446: WHEN OTHERS THEN
447: ROLLBACK;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449:
450: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
451: fnd_log.string
452: (
453: FND_LOG.LEVEL_ERROR,
454: 'fpa.sql.fpa_scenario_pvt.update_scen_approved_flag',

Line 451: fnd_log.string

447: ROLLBACK;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449:
450: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
451: fnd_log.string
452: (
453: FND_LOG.LEVEL_ERROR,
454: 'fpa.sql.fpa_scenario_pvt.update_scen_approved_flag',
455: SQLERRM

Line 453: FND_LOG.LEVEL_ERROR,

449:
450: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
451: fnd_log.string
452: (
453: FND_LOG.LEVEL_ERROR,
454: 'fpa.sql.fpa_scenario_pvt.update_scen_approved_flag',
455: SQLERRM
456: );
457: END IF;

Line 488: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

484: l_discount_rate VARCHAR2(100);
485:
486: begin
487:
488: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
489: fnd_log.string
490: (
491: FND_LOG.LEVEL_PROCEDURE,
492: 'fpa.sql.fpa_scenario_pvt.update_scenario_disc_rate.begin',

Line 489: fnd_log.string

485:
486: begin
487:
488: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
489: fnd_log.string
490: (
491: FND_LOG.LEVEL_PROCEDURE,
492: 'fpa.sql.fpa_scenario_pvt.update_scenario_disc_rate.begin',
493: 'Entering fpa_scenario_pvt.update_scenario_disc_rate'

Line 491: FND_LOG.LEVEL_PROCEDURE,

487:
488: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
489: fnd_log.string
490: (
491: FND_LOG.LEVEL_PROCEDURE,
492: 'fpa.sql.fpa_scenario_pvt.update_scenario_disc_rate.begin',
493: 'Entering fpa_scenario_pvt.update_scenario_disc_rate'
494: );
495: END IF;

Line 497: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

493: 'Entering fpa_scenario_pvt.update_scenario_disc_rate'
494: );
495: END IF;
496:
497: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
498: fnd_log.string
499: (
500: FND_LOG.LEVEL_PROCEDURE,
501: 'fpa.sql.fpa_scenario_pvt.update_scenario_disc_rate',

Line 498: fnd_log.string

494: );
495: END IF;
496:
497: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
498: fnd_log.string
499: (
500: FND_LOG.LEVEL_PROCEDURE,
501: 'fpa.sql.fpa_scenario_pvt.update_scenario_disc_rate',
502: 'Setting the discount rate.'

Line 500: FND_LOG.LEVEL_PROCEDURE,

496:
497: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
498: fnd_log.string
499: (
500: FND_LOG.LEVEL_PROCEDURE,
501: 'fpa.sql.fpa_scenario_pvt.update_scenario_disc_rate',
502: 'Setting the discount rate.'
503: );
504: END IF;

Line 522: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

518: -- Update daily discount rate
519: dbms_aw.execute('scenario_discount_rate_daily_m = ((1+scenario_discount_rate_m)**(1/365))-1');
520: dbms_aw.execute('POP scenario_d');
521:
522: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
523: fnd_log.string
524: (
525: FND_LOG.LEVEL_PROCEDURE,
526: 'fpa.sql.fpa_scenario_pvt.update_scenario_disc_rate.end',

Line 523: fnd_log.string

519: dbms_aw.execute('scenario_discount_rate_daily_m = ((1+scenario_discount_rate_m)**(1/365))-1');
520: dbms_aw.execute('POP scenario_d');
521:
522: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
523: fnd_log.string
524: (
525: FND_LOG.LEVEL_PROCEDURE,
526: 'fpa.sql.fpa_scenario_pvt.update_scenario_disc_rate.end',
527: 'Entering fpa_scenario_pvt.update_scenario_disc_rate'

Line 525: FND_LOG.LEVEL_PROCEDURE,

521:
522: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
523: fnd_log.string
524: (
525: FND_LOG.LEVEL_PROCEDURE,
526: 'fpa.sql.fpa_scenario_pvt.update_scenario_disc_rate.end',
527: 'Entering fpa_scenario_pvt.update_scenario_disc_rate'
528: );
529: END IF;

Line 535: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

531: EXCEPTION
532: WHEN OTHERS THEN
533: ROLLBACK;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
536: fnd_log.string
537: (
538: FND_LOG.LEVEL_ERROR,
539: 'fpa.sql.fpa_scenario_pvt.create_scenario',

Line 536: fnd_log.string

532: WHEN OTHERS THEN
533: ROLLBACK;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
536: fnd_log.string
537: (
538: FND_LOG.LEVEL_ERROR,
539: 'fpa.sql.fpa_scenario_pvt.create_scenario',
540: SQLERRM

Line 538: FND_LOG.LEVEL_ERROR,

534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
536: fnd_log.string
537: (
538: FND_LOG.LEVEL_ERROR,
539: 'fpa.sql.fpa_scenario_pvt.create_scenario',
540: SQLERRM
541: );
542: END IF;

Line 572: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

568: l_scen_funds VARCHAR2(100) ;
569:
570: begin
571:
572: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
573: fnd_log.string
574: (
575: FND_LOG.LEVEL_PROCEDURE,
576: 'fpa.sql.fpa_scenario_pvt.update_scenario_funds_avail.begin',

Line 573: fnd_log.string

569:
570: begin
571:
572: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
573: fnd_log.string
574: (
575: FND_LOG.LEVEL_PROCEDURE,
576: 'fpa.sql.fpa_scenario_pvt.update_scenario_funds_avail.begin',
577: 'Entering fpa_scenario_pvt.update_scenario_funds_avail'

Line 575: FND_LOG.LEVEL_PROCEDURE,

571:
572: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
573: fnd_log.string
574: (
575: FND_LOG.LEVEL_PROCEDURE,
576: 'fpa.sql.fpa_scenario_pvt.update_scenario_funds_avail.begin',
577: 'Entering fpa_scenario_pvt.update_scenario_funds_avail'
578: );
579: END IF;

Line 581: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

577: 'Entering fpa_scenario_pvt.update_scenario_funds_avail'
578: );
579: END IF;
580:
581: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
582: fnd_log.string
583: (
584: FND_LOG.LEVEL_PROCEDURE,
585: 'fpa.sql.fpa_scenario_pvt.update_scenario_funds_avail',

Line 582: fnd_log.string

578: );
579: END IF;
580:
581: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
582: fnd_log.string
583: (
584: FND_LOG.LEVEL_PROCEDURE,
585: 'fpa.sql.fpa_scenario_pvt.update_scenario_funds_avail',
586: 'Setting the discount rate.'

Line 584: FND_LOG.LEVEL_PROCEDURE,

580:
581: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
582: fnd_log.string
583: (
584: FND_LOG.LEVEL_PROCEDURE,
585: 'fpa.sql.fpa_scenario_pvt.update_scenario_funds_avail',
586: 'Setting the discount rate.'
587: );
588: END IF;

Line 612: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

608: -- Associate the scenario with the planning cycle
609: dbms_aw.execute('scenario_funding_m = ' || l_scen_funds);
610: dbms_aw.execute('POP scenario_d');
611:
612: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
613: fnd_log.string
614: (
615: FND_LOG.LEVEL_PROCEDURE,
616: 'fpa.sql.fpa_scenario_pvt.update_scenario_funds_avail.end',

Line 613: fnd_log.string

609: dbms_aw.execute('scenario_funding_m = ' || l_scen_funds);
610: dbms_aw.execute('POP scenario_d');
611:
612: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
613: fnd_log.string
614: (
615: FND_LOG.LEVEL_PROCEDURE,
616: 'fpa.sql.fpa_scenario_pvt.update_scenario_funds_avail.end',
617: 'Entering fpa_scenario_pvt.update_scenario_funds_avail'

Line 615: FND_LOG.LEVEL_PROCEDURE,

611:
612: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
613: fnd_log.string
614: (
615: FND_LOG.LEVEL_PROCEDURE,
616: 'fpa.sql.fpa_scenario_pvt.update_scenario_funds_avail.end',
617: 'Entering fpa_scenario_pvt.update_scenario_funds_avail'
618: );
619: END IF;

Line 625: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

621: EXCEPTION
622: WHEN OTHERS THEN
623: ROLLBACK;
624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
625: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
626: fnd_log.string
627: (
628: FND_LOG.LEVEL_ERROR,
629: 'fpa.sql.fpa_scenario_pvt.update_scenario_funds_avail',

Line 626: fnd_log.string

622: WHEN OTHERS THEN
623: ROLLBACK;
624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
625: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
626: fnd_log.string
627: (
628: FND_LOG.LEVEL_ERROR,
629: 'fpa.sql.fpa_scenario_pvt.update_scenario_funds_avail',
630: SQLERRM

Line 628: FND_LOG.LEVEL_ERROR,

624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
625: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
626: fnd_log.string
627: (
628: FND_LOG.LEVEL_ERROR,
629: 'fpa.sql.fpa_scenario_pvt.update_scenario_funds_avail',
630: SQLERRM
631: );
632: END IF;

Line 659: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

655: l_api_version CONSTANT NUMBER := 1.0;
656:
657: begin
658:
659: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
660: fnd_log.string
661: (
662: FND_LOG.LEVEL_PROCEDURE,
663: 'fpa.sql.fpa_scenario_pvt.update_scenario_initial_flag.begin',

Line 660: fnd_log.string

656:
657: begin
658:
659: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
660: fnd_log.string
661: (
662: FND_LOG.LEVEL_PROCEDURE,
663: 'fpa.sql.fpa_scenario_pvt.update_scenario_initial_flag.begin',
664: 'Entering fpa_scenario_pvt.update_scenario_initial_flag.'

Line 662: FND_LOG.LEVEL_PROCEDURE,

658:
659: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
660: fnd_log.string
661: (
662: FND_LOG.LEVEL_PROCEDURE,
663: 'fpa.sql.fpa_scenario_pvt.update_scenario_initial_flag.begin',
664: 'Entering fpa_scenario_pvt.update_scenario_initial_flag.'
665: );
666: END IF;

Line 668: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

664: 'Entering fpa_scenario_pvt.update_scenario_initial_flag.'
665: );
666: END IF;
667:
668: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
669: fnd_log.string
670: (
671: FND_LOG.LEVEL_PROCEDURE,
672: 'fpa.sql.fpa_scenario_pvt.update_scenario_initial_flag.begin',

Line 669: fnd_log.string

665: );
666: END IF;
667:
668: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
669: fnd_log.string
670: (
671: FND_LOG.LEVEL_PROCEDURE,
672: 'fpa.sql.fpa_scenario_pvt.update_scenario_initial_flag.begin',
673: 'Unsetting any previous flags and setting new flag.'

Line 671: FND_LOG.LEVEL_PROCEDURE,

667:
668: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
669: fnd_log.string
670: (
671: FND_LOG.LEVEL_PROCEDURE,
672: 'fpa.sql.fpa_scenario_pvt.update_scenario_initial_flag.begin',
673: 'Unsetting any previous flags and setting new flag.'
674: );
675: END IF;

Line 692: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

688: dbms_aw.execute('scenario_initial_m = yes');
689: dbms_aw.execute('POP scenario_d');
690: dbms_aw.execute('POP planning_cycle_d');
691:
692: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
693: fnd_log.string
694: (
695: FND_LOG.LEVEL_PROCEDURE,
696: 'fpa.sql.fpa_scenario_pvt.update_scenario_initial_flag.end',

Line 693: fnd_log.string

689: dbms_aw.execute('POP scenario_d');
690: dbms_aw.execute('POP planning_cycle_d');
691:
692: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
693: fnd_log.string
694: (
695: FND_LOG.LEVEL_PROCEDURE,
696: 'fpa.sql.fpa_scenario_pvt.update_scenario_initial_flag.end',
697: 'Entering fpa_scenario_pvt.update_scenario_initial_flag.'

Line 695: FND_LOG.LEVEL_PROCEDURE,

691:
692: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
693: fnd_log.string
694: (
695: FND_LOG.LEVEL_PROCEDURE,
696: 'fpa.sql.fpa_scenario_pvt.update_scenario_initial_flag.end',
697: 'Entering fpa_scenario_pvt.update_scenario_initial_flag.'
698: );
699: END IF;

Line 705: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

701: EXCEPTION
702: WHEN OTHERS THEN
703: ROLLBACK;
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
706: fnd_log.string
707: (
708: FND_LOG.LEVEL_ERROR,
709: 'fpa.sql.fpa_scenario_pvt.update_scenario_initial_flag',

Line 706: fnd_log.string

702: WHEN OTHERS THEN
703: ROLLBACK;
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
706: fnd_log.string
707: (
708: FND_LOG.LEVEL_ERROR,
709: 'fpa.sql.fpa_scenario_pvt.update_scenario_initial_flag',
710: SQLERRM

Line 708: FND_LOG.LEVEL_ERROR,

704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
706: fnd_log.string
707: (
708: FND_LOG.LEVEL_ERROR,
709: 'fpa.sql.fpa_scenario_pvt.update_scenario_initial_flag',
710: SQLERRM
711: );
712: END IF;

Line 739: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

735: l_api_version CONSTANT NUMBER := 1.0;
736:
737: begin
738:
739: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
740: fnd_log.string
741: (
742: FND_LOG.LEVEL_PROCEDURE,
743: 'fpa.sql.fpa_scenario_pvt.update_scenario_working_flag.begin',

Line 740: fnd_log.string

736:
737: begin
738:
739: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
740: fnd_log.string
741: (
742: FND_LOG.LEVEL_PROCEDURE,
743: 'fpa.sql.fpa_scenario_pvt.update_scenario_working_flag.begin',
744: 'Entering fpa_scenario_pvt.update_scenario_working_flag.'

Line 742: FND_LOG.LEVEL_PROCEDURE,

738:
739: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
740: fnd_log.string
741: (
742: FND_LOG.LEVEL_PROCEDURE,
743: 'fpa.sql.fpa_scenario_pvt.update_scenario_working_flag.begin',
744: 'Entering fpa_scenario_pvt.update_scenario_working_flag.'
745: );
746: END IF;

Line 748: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

744: 'Entering fpa_scenario_pvt.update_scenario_working_flag.'
745: );
746: END IF;
747:
748: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
749: fnd_log.string
750: (
751: FND_LOG.LEVEL_PROCEDURE,
752: 'fpa.sql.fpa_scenario_pvt.update_scenario_working_flag',

Line 749: fnd_log.string

745: );
746: END IF;
747:
748: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
749: fnd_log.string
750: (
751: FND_LOG.LEVEL_PROCEDURE,
752: 'fpa.sql.fpa_scenario_pvt.update_scenario_working_flag',
753: 'Unsetting any previous flags and setting new flag.'

Line 751: FND_LOG.LEVEL_PROCEDURE,

747:
748: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
749: fnd_log.string
750: (
751: FND_LOG.LEVEL_PROCEDURE,
752: 'fpa.sql.fpa_scenario_pvt.update_scenario_working_flag',
753: 'Unsetting any previous flags and setting new flag.'
754: );
755: END IF;

Line 770: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

766: dbms_aw.execute('scenario_working_m = yes');
767: dbms_aw.execute('POP scenario_d');
768: dbms_aw.execute('POP planning_cycle_d');
769:
770: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
771: fnd_log.string
772: (
773: FND_LOG.LEVEL_PROCEDURE,
774: 'fpa.sql.fpa_scenario_pvt.update_scenario_working_flag.end',

Line 771: fnd_log.string

767: dbms_aw.execute('POP scenario_d');
768: dbms_aw.execute('POP planning_cycle_d');
769:
770: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
771: fnd_log.string
772: (
773: FND_LOG.LEVEL_PROCEDURE,
774: 'fpa.sql.fpa_scenario_pvt.update_scenario_working_flag.end',
775: 'Entering fpa_scenario_pvt.update_scenario_working_flag.'

Line 773: FND_LOG.LEVEL_PROCEDURE,

769:
770: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
771: fnd_log.string
772: (
773: FND_LOG.LEVEL_PROCEDURE,
774: 'fpa.sql.fpa_scenario_pvt.update_scenario_working_flag.end',
775: 'Entering fpa_scenario_pvt.update_scenario_working_flag.'
776: );
777: END IF;

Line 784: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

780: WHEN OTHERS THEN
781: --dbms_output.put_line(SQLERRM);
782: ROLLBACK;
783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
784: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
785: fnd_log.string
786: (
787: FND_LOG.LEVEL_ERROR,
788: 'fpa.sql.fpa_scenario_pvt.update_scenario_working_flag',

Line 785: fnd_log.string

781: --dbms_output.put_line(SQLERRM);
782: ROLLBACK;
783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
784: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
785: fnd_log.string
786: (
787: FND_LOG.LEVEL_ERROR,
788: 'fpa.sql.fpa_scenario_pvt.update_scenario_working_flag',
789: SQLERRM

Line 787: FND_LOG.LEVEL_ERROR,

783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
784: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
785: fnd_log.string
786: (
787: FND_LOG.LEVEL_ERROR,
788: 'fpa.sql.fpa_scenario_pvt.update_scenario_working_flag',
789: SQLERRM
790: );
791: END IF;

Line 821: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

817: l_api_version CONSTANT NUMBER := 1.0;
818:
819: begin
820:
821: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
822: fnd_log.string
823: (
824: FND_LOG.LEVEL_PROCEDURE,
825: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_flag.begin',

Line 822: fnd_log.string

818:
819: begin
820:
821: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
822: fnd_log.string
823: (
824: FND_LOG.LEVEL_PROCEDURE,
825: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_flag.begin',
826: 'Entering fpa_scenario_pvt.update_scenario_reccom_flag.'

Line 824: FND_LOG.LEVEL_PROCEDURE,

820:
821: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
822: fnd_log.string
823: (
824: FND_LOG.LEVEL_PROCEDURE,
825: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_flag.begin',
826: 'Entering fpa_scenario_pvt.update_scenario_reccom_flag.'
827: );
828: END IF;

Line 830: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

826: 'Entering fpa_scenario_pvt.update_scenario_reccom_flag.'
827: );
828: END IF;
829:
830: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
831: fnd_log.string
832: (
833: FND_LOG.LEVEL_PROCEDURE,
834: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_flag',

Line 831: fnd_log.string

827: );
828: END IF;
829:
830: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
831: fnd_log.string
832: (
833: FND_LOG.LEVEL_PROCEDURE,
834: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_flag',
835: 'Unsetting any previous flags and setting new flag.'

Line 833: FND_LOG.LEVEL_PROCEDURE,

829:
830: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
831: fnd_log.string
832: (
833: FND_LOG.LEVEL_PROCEDURE,
834: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_flag',
835: 'Unsetting any previous flags and setting new flag.'
836: );
837: END IF;

Line 844: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

840: dbms_aw.execute('lmt scenario_d to ' || p_scenario_id);
841: dbms_aw.execute('scenario_recommended_flag_m = ' || p_scenario_reccom_status);
842: dbms_aw.execute('POP scenario_d');
843:
844: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
845: fnd_log.string
846: (
847: FND_LOG.LEVEL_PROCEDURE,
848: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_flag.end',

Line 845: fnd_log.string

841: dbms_aw.execute('scenario_recommended_flag_m = ' || p_scenario_reccom_status);
842: dbms_aw.execute('POP scenario_d');
843:
844: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
845: fnd_log.string
846: (
847: FND_LOG.LEVEL_PROCEDURE,
848: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_flag.end',
849: 'Entering fpa_scenario_pvt.update_scenario_reccom_flag.'

Line 847: FND_LOG.LEVEL_PROCEDURE,

843:
844: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
845: fnd_log.string
846: (
847: FND_LOG.LEVEL_PROCEDURE,
848: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_flag.end',
849: 'Entering fpa_scenario_pvt.update_scenario_reccom_flag.'
850: );
851: END IF;

Line 858: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

854: WHEN OTHERS THEN
855: --dbms_output.put_line(SQLERRM);
856: ROLLBACK;
857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
859: fnd_log.string
860: (
861: FND_LOG.LEVEL_ERROR,
862: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_flag',

Line 859: fnd_log.string

855: --dbms_output.put_line(SQLERRM);
856: ROLLBACK;
857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
859: fnd_log.string
860: (
861: FND_LOG.LEVEL_ERROR,
862: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_flag',
863: SQLERRM

Line 861: FND_LOG.LEVEL_ERROR,

857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
859: fnd_log.string
860: (
861: FND_LOG.LEVEL_ERROR,
862: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_flag',
863: SQLERRM
864: );
865: END IF;

Line 901: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

897: l_project_id VARCHAR2(10);
898:
899: begin
900:
901: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
902: fnd_log.string
903: (
904: FND_LOG.LEVEL_PROCEDURE,
905: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status.begin',

Line 902: fnd_log.string

898:
899: begin
900:
901: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
902: fnd_log.string
903: (
904: FND_LOG.LEVEL_PROCEDURE,
905: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status.begin',
906: 'Entering fpa_scenario_pvt.update_scenario_reccom_status'

Line 904: FND_LOG.LEVEL_PROCEDURE,

900:
901: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
902: fnd_log.string
903: (
904: FND_LOG.LEVEL_PROCEDURE,
905: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status.begin',
906: 'Entering fpa_scenario_pvt.update_scenario_reccom_status'
907: );
908: END IF;

Line 910: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

906: 'Entering fpa_scenario_pvt.update_scenario_reccom_status'
907: );
908: END IF;
909:
910: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
911: fnd_log.string
912: (
913: FND_LOG.LEVEL_PROCEDURE,
914: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status.begin',

Line 911: fnd_log.string

907: );
908: END IF;
909:
910: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
911: fnd_log.string
912: (
913: FND_LOG.LEVEL_PROCEDURE,
914: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status.begin',
915: 'Limiting to scenario id passed.'

Line 913: FND_LOG.LEVEL_PROCEDURE,

909:
910: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
911: fnd_log.string
912: (
913: FND_LOG.LEVEL_PROCEDURE,
914: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status.begin',
915: 'Limiting to scenario id passed.'
916: );
917: END IF;

Line 922: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

918:
919: dbms_aw.execute('PUSH scenario_d');
920: dbms_aw.execute('LMT scenario_d TO ' || p_scenario_id);
921:
922: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
923: fnd_log.string
924: (
925: FND_LOG.LEVEL_PROCEDURE,
926: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status.begin',

Line 923: fnd_log.string

919: dbms_aw.execute('PUSH scenario_d');
920: dbms_aw.execute('LMT scenario_d TO ' || p_scenario_id);
921:
922: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
923: fnd_log.string
924: (
925: FND_LOG.LEVEL_PROCEDURE,
926: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status.begin',
927: 'Assing project id string passed to local string variable.'

Line 925: FND_LOG.LEVEL_PROCEDURE,

921:
922: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
923: fnd_log.string
924: (
925: FND_LOG.LEVEL_PROCEDURE,
926: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status.begin',
927: 'Assing project id string passed to local string variable.'
928: );
929: END IF;

Line 933: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

929: END IF;
930:
931: l_project_id_string := p_project_id;
932:
933: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
934: fnd_log.string
935: (
936: FND_LOG.LEVEL_PROCEDURE,
937: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status.begin',

Line 934: fnd_log.string

930:
931: l_project_id_string := p_project_id;
932:
933: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
934: fnd_log.string
935: (
936: FND_LOG.LEVEL_PROCEDURE,
937: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status.begin',
938: 'Loop over project id string and update recommended funding status relation.'

Line 936: FND_LOG.LEVEL_PROCEDURE,

932:
933: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
934: fnd_log.string
935: (
936: FND_LOG.LEVEL_PROCEDURE,
937: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status.begin',
938: 'Loop over project id string and update recommended funding status relation.'
939: );
940: END IF;

Line 944: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

940: END IF;
941:
942: WHILE (length(l_project_id_string) > 0) LOOP
943:
944: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
945: fnd_log.string
946: (
947: FND_LOG.LEVEL_PROCEDURE,
948: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status.begin',

Line 945: fnd_log.string

941:
942: WHILE (length(l_project_id_string) > 0) LOOP
943:
944: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
945: fnd_log.string
946: (
947: FND_LOG.LEVEL_PROCEDURE,
948: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status.begin',
949: 'Current project string: ' || l_project_id_string || ' and project id: ' || l_project_id

Line 947: FND_LOG.LEVEL_PROCEDURE,

943:
944: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
945: fnd_log.string
946: (
947: FND_LOG.LEVEL_PROCEDURE,
948: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status.begin',
949: 'Current project string: ' || l_project_id_string || ' and project id: ' || l_project_id
950: );
951: END IF;

Line 958: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

954: l_project_id_string := substr(l_project_id_string, (instr(l_project_id_string, ',') + 1));
955: --dbms_output.put_line('id: ' || l_project_id);
956: --dbms_output.put_line('string: ' || l_project_id_string);
957:
958: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
959: fnd_log.string
960: (
961: FND_LOG.LEVEL_PROCEDURE,
962: 'fpa.sql.fpa_scenario_pvt.',

Line 959: fnd_log.string

955: --dbms_output.put_line('id: ' || l_project_id);
956: --dbms_output.put_line('string: ' || l_project_id_string);
957:
958: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
959: fnd_log.string
960: (
961: FND_LOG.LEVEL_PROCEDURE,
962: 'fpa.sql.fpa_scenario_pvt.',
963: 'Updating FUNDING_STATUS_REC_SCENARIO_PROJECT_R relation for scenario: ' || p_scenario_id || ' and for project: ' || l_project_id

Line 961: FND_LOG.LEVEL_PROCEDURE,

957:
958: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
959: fnd_log.string
960: (
961: FND_LOG.LEVEL_PROCEDURE,
962: 'fpa.sql.fpa_scenario_pvt.',
963: 'Updating FUNDING_STATUS_REC_SCENARIO_PROJECT_R relation for scenario: ' || p_scenario_id || ' and for project: ' || l_project_id
964: );
965: END IF;

Line 973: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

969: END LOOP;
970:
971: dbms_aw.execute('POP scenario_d');
972:
973: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
974: fnd_log.string
975: (
976: FND_LOG.LEVEL_PROCEDURE,
977: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status.end',

Line 974: fnd_log.string

970:
971: dbms_aw.execute('POP scenario_d');
972:
973: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
974: fnd_log.string
975: (
976: FND_LOG.LEVEL_PROCEDURE,
977: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status.end',
978: 'Exiting fpa_scenario_pvt.update_scenario_reccom_status.'

Line 976: FND_LOG.LEVEL_PROCEDURE,

972:
973: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
974: fnd_log.string
975: (
976: FND_LOG.LEVEL_PROCEDURE,
977: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status.end',
978: 'Exiting fpa_scenario_pvt.update_scenario_reccom_status.'
979: );
980: END IF;

Line 986: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

982: EXCEPTION
983: WHEN OTHERS THEN
984: ROLLBACK;
985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
986: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
987: fnd_log.string
988: (
989: FND_LOG.LEVEL_ERROR,
990: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status',

Line 987: fnd_log.string

983: WHEN OTHERS THEN
984: ROLLBACK;
985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
986: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
987: fnd_log.string
988: (
989: FND_LOG.LEVEL_ERROR,
990: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status',
991: SQLERRM

Line 989: FND_LOG.LEVEL_ERROR,

985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
986: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
987: fnd_log.string
988: (
989: FND_LOG.LEVEL_ERROR,
990: 'fpa.sql.fpa_scenario_pvt.update_scenario_reccom_status',
991: SQLERRM
992: );
993: END IF;

Line 1024: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1020: l_str varchar2(2000);
1021: source_scen_id number;
1022: BEGIN
1023:
1024: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1025: fnd_log.string
1026: (
1027: FND_LOG.LEVEL_PROCEDURE,
1028: 'fpa.sql.fpa_scenario_pvt.copy_sce_project_data.begin',

Line 1025: fnd_log.string

1021: source_scen_id number;
1022: BEGIN
1023:
1024: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1025: fnd_log.string
1026: (
1027: FND_LOG.LEVEL_PROCEDURE,
1028: 'fpa.sql.fpa_scenario_pvt.copy_sce_project_data.begin',
1029: 'Entering fpa_scenario_pvt.copy_sce_project_data'

Line 1027: FND_LOG.LEVEL_PROCEDURE,

1023:
1024: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1025: fnd_log.string
1026: (
1027: FND_LOG.LEVEL_PROCEDURE,
1028: 'fpa.sql.fpa_scenario_pvt.copy_sce_project_data.begin',
1029: 'Entering fpa_scenario_pvt.copy_sce_project_data'
1030: );
1031: END IF;

Line 1049: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1045: l_str := 'call copy_proj_data_prg(' || p_target_scen_id || ', ' || source_scen_id || ', '' ' || p_project_id_str || ''')';
1046: dbms_aw.execute(l_str);
1047: --('call copy_proj_data_prg(' || p_target_scen_id || ' ' || source_scen_id || ' '' ' || p_project_id_str || ''')');
1048:
1049: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1050: fnd_log.string
1051: (
1052: FND_LOG.LEVEL_PROCEDURE,
1053: 'fpa.sql.fpa_scenario_pvt.copy_sce_project_data.end',

Line 1050: fnd_log.string

1046: dbms_aw.execute(l_str);
1047: --('call copy_proj_data_prg(' || p_target_scen_id || ' ' || source_scen_id || ' '' ' || p_project_id_str || ''')');
1048:
1049: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1050: fnd_log.string
1051: (
1052: FND_LOG.LEVEL_PROCEDURE,
1053: 'fpa.sql.fpa_scenario_pvt.copy_sce_project_data.end',
1054: 'Entering fpa_scenario_pvt.copy_sce_project_data'

Line 1052: FND_LOG.LEVEL_PROCEDURE,

1048:
1049: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1050: fnd_log.string
1051: (
1052: FND_LOG.LEVEL_PROCEDURE,
1053: 'fpa.sql.fpa_scenario_pvt.copy_sce_project_data.end',
1054: 'Entering fpa_scenario_pvt.copy_sce_project_data'
1055: );
1056: END IF;

Line 1062: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1058: EXCEPTION
1059: WHEN OTHERS THEN
1060: ROLLBACK;
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1063: fnd_log.string
1064: (
1065: FND_LOG.LEVEL_ERROR,
1066: 'fpa.sql.fpa_scenario_pvt.copy_sce_project_data',

Line 1063: fnd_log.string

1059: WHEN OTHERS THEN
1060: ROLLBACK;
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1063: fnd_log.string
1064: (
1065: FND_LOG.LEVEL_ERROR,
1066: 'fpa.sql.fpa_scenario_pvt.copy_sce_project_data',
1067: SQLERRM

Line 1065: FND_LOG.LEVEL_ERROR,

1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1063: fnd_log.string
1064: (
1065: FND_LOG.LEVEL_ERROR,
1066: 'fpa.sql.fpa_scenario_pvt.copy_sce_project_data',
1067: SQLERRM
1068: );
1069: END IF;

Line 1093: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1089:
1090: l_str varchar2(2000);
1091: BEGIN
1092:
1093: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1094: fnd_log.string
1095: (
1096: FND_LOG.LEVEL_PROCEDURE,
1097: 'fpa.sql.fpa_scenario_pvt.remove_project_from_scenario.begin',

Line 1094: fnd_log.string

1090: l_str varchar2(2000);
1091: BEGIN
1092:
1093: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1094: fnd_log.string
1095: (
1096: FND_LOG.LEVEL_PROCEDURE,
1097: 'fpa.sql.fpa_scenario_pvt.remove_project_from_scenario.begin',
1098: 'Entering fpa_scenario_pvt.remove_project_from_scenario'

Line 1096: FND_LOG.LEVEL_PROCEDURE,

1092:
1093: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1094: fnd_log.string
1095: (
1096: FND_LOG.LEVEL_PROCEDURE,
1097: 'fpa.sql.fpa_scenario_pvt.remove_project_from_scenario.begin',
1098: 'Entering fpa_scenario_pvt.remove_project_from_scenario'
1099: );
1100: END IF;

Line 1107: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1103:
1104: -- dbms_output.put_line(l_str);
1105: dbms_aw.execute(l_str);
1106:
1107: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1108: fnd_log.string
1109: (
1110: FND_LOG.LEVEL_PROCEDURE,
1111: 'fpa.sql.fpa_scenario_pvt.remove_project_from_scenario.end',

Line 1108: fnd_log.string

1104: -- dbms_output.put_line(l_str);
1105: dbms_aw.execute(l_str);
1106:
1107: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1108: fnd_log.string
1109: (
1110: FND_LOG.LEVEL_PROCEDURE,
1111: 'fpa.sql.fpa_scenario_pvt.remove_project_from_scenario.end',
1112: 'Entering fpa_scenario_pvt.remove_project_from_scenario'

Line 1110: FND_LOG.LEVEL_PROCEDURE,

1106:
1107: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1108: fnd_log.string
1109: (
1110: FND_LOG.LEVEL_PROCEDURE,
1111: 'fpa.sql.fpa_scenario_pvt.remove_project_from_scenario.end',
1112: 'Entering fpa_scenario_pvt.remove_project_from_scenario'
1113: );
1114: END IF;

Line 1120: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1116: EXCEPTION
1117: WHEN OTHERS THEN
1118: ROLLBACK;
1119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1120: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1121: fnd_log.string
1122: (
1123: FND_LOG.LEVEL_ERROR,
1124: 'fpa.sql.fpa_scenario_pvt.remove_project_from_scenario',

Line 1121: fnd_log.string

1117: WHEN OTHERS THEN
1118: ROLLBACK;
1119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1120: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1121: fnd_log.string
1122: (
1123: FND_LOG.LEVEL_ERROR,
1124: 'fpa.sql.fpa_scenario_pvt.remove_project_from_scenario',
1125: SQLERRM

Line 1123: FND_LOG.LEVEL_ERROR,

1119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1120: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1121: fnd_log.string
1122: (
1123: FND_LOG.LEVEL_ERROR,
1124: 'fpa.sql.fpa_scenario_pvt.remove_project_from_scenario',
1125: SQLERRM
1126: );
1127: END IF;

Line 1146: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1142: x_msg_count OUT NOCOPY NUMBER )
1143: IS
1144: BEGIN
1145:
1146: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1147: FND_LOG.String
1148: (
1149: FND_LOG.LEVEL_PROCEDURE,
1150: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.begin',

Line 1147: FND_LOG.String

1143: IS
1144: BEGIN
1145:
1146: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1147: FND_LOG.String
1148: (
1149: FND_LOG.LEVEL_PROCEDURE,
1150: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.begin',
1151: 'Entering FPA_Scenario_Pvt.Update_Proj_User_Ranks'

Line 1149: FND_LOG.LEVEL_PROCEDURE,

1145:
1146: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1147: FND_LOG.String
1148: (
1149: FND_LOG.LEVEL_PROCEDURE,
1150: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.begin',
1151: 'Entering FPA_Scenario_Pvt.Update_Proj_User_Ranks'
1152: );
1153: END IF;

Line 1168: /* IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1164: LOOP
1165:
1166: -- DBMS_OUTPUT.put_line(' ..Inside For loop...p_proj_metrics(i).project=' || p_proj_metrics(i).projectID );
1167: -- DBMS_OUTPUT.put_line(' ..Inside For loop...p_proj_metrics(i).user_rank=' || p_proj_metrics(i).user_rank );
1168: /* IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1169: FND_LOG.String
1170: (
1171: FND_LOG.LEVEL_PROCEDURE,
1172: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.end',

Line 1169: FND_LOG.String

1165:
1166: -- DBMS_OUTPUT.put_line(' ..Inside For loop...p_proj_metrics(i).project=' || p_proj_metrics(i).projectID );
1167: -- DBMS_OUTPUT.put_line(' ..Inside For loop...p_proj_metrics(i).user_rank=' || p_proj_metrics(i).user_rank );
1168: /* IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1169: FND_LOG.String
1170: (
1171: FND_LOG.LEVEL_PROCEDURE,
1172: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.end',
1173: 'FPA_Scenario_Pvt.Update_Proj_User_Ranks: Inside for loop:projectID='||p_proj_metrics(i).projectID

Line 1171: FND_LOG.LEVEL_PROCEDURE,

1167: -- DBMS_OUTPUT.put_line(' ..Inside For loop...p_proj_metrics(i).user_rank=' || p_proj_metrics(i).user_rank );
1168: /* IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1169: FND_LOG.String
1170: (
1171: FND_LOG.LEVEL_PROCEDURE,
1172: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.end',
1173: 'FPA_Scenario_Pvt.Update_Proj_User_Ranks: Inside for loop:projectID='||p_proj_metrics(i).projectID
1174: ||' user_rank='||p_proj_metrics(i).user_rank
1175: );

Line 1177: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1173: 'FPA_Scenario_Pvt.Update_Proj_User_Ranks: Inside for loop:projectID='||p_proj_metrics(i).projectID
1174: ||' user_rank='||p_proj_metrics(i).user_rank
1175: );
1176: END IF; */
1177: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1178: FND_LOG.String
1179: (
1180: FND_LOG.LEVEL_PROCEDURE,
1181: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.end',

Line 1178: FND_LOG.String

1174: ||' user_rank='||p_proj_metrics(i).user_rank
1175: );
1176: END IF; */
1177: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1178: FND_LOG.String
1179: (
1180: FND_LOG.LEVEL_PROCEDURE,
1181: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.end',
1182: 'FPA_Scenario_Pvt.Update_Proj_User_Ranks: Inside for loop:projectID='||p_proj_metrics(i).projectID);

Line 1180: FND_LOG.LEVEL_PROCEDURE,

1176: END IF; */
1177: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1178: FND_LOG.String
1179: (
1180: FND_LOG.LEVEL_PROCEDURE,
1181: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.end',
1182: 'FPA_Scenario_Pvt.Update_Proj_User_Ranks: Inside for loop:projectID='||p_proj_metrics(i).projectID);
1183: END IF;
1184: -- Limit project_d

Line 1189: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1185: dbms_aw.execute('LMT project_d TO ' || p_proj_metrics(i).projectID );
1186:
1187: -- Set the the user rank for each project
1188: IF p_proj_metrics(i).user_rank IS NULL THEN
1189: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1190: FND_LOG.String
1191: (
1192: FND_LOG.LEVEL_PROCEDURE,
1193: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.end',

Line 1190: FND_LOG.String

1186:
1187: -- Set the the user rank for each project
1188: IF p_proj_metrics(i).user_rank IS NULL THEN
1189: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1190: FND_LOG.String
1191: (
1192: FND_LOG.LEVEL_PROCEDURE,
1193: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.end',
1194: 'FPA_Scenario_Pvt.Update_Proj_User_Ranks: Inside for loop:User Rank = na');

Line 1192: FND_LOG.LEVEL_PROCEDURE,

1188: IF p_proj_metrics(i).user_rank IS NULL THEN
1189: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1190: FND_LOG.String
1191: (
1192: FND_LOG.LEVEL_PROCEDURE,
1193: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.end',
1194: 'FPA_Scenario_Pvt.Update_Proj_User_Ranks: Inside for loop:User Rank = na');
1195: END IF;
1196: dbms_aw.execute( 'scenario_project_user_rank_m = na');

Line 1198: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1194: 'FPA_Scenario_Pvt.Update_Proj_User_Ranks: Inside for loop:User Rank = na');
1195: END IF;
1196: dbms_aw.execute( 'scenario_project_user_rank_m = na');
1197: ELSE
1198: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1199: FND_LOG.String
1200: (
1201: FND_LOG.LEVEL_PROCEDURE,
1202: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.end',

Line 1199: FND_LOG.String

1195: END IF;
1196: dbms_aw.execute( 'scenario_project_user_rank_m = na');
1197: ELSE
1198: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1199: FND_LOG.String
1200: (
1201: FND_LOG.LEVEL_PROCEDURE,
1202: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.end',
1203: 'FPA_Scenario_Pvt.Update_Proj_User_Ranks: Inside for loop:User Rank ='||p_proj_metrics(i).user_rank);

Line 1201: FND_LOG.LEVEL_PROCEDURE,

1197: ELSE
1198: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1199: FND_LOG.String
1200: (
1201: FND_LOG.LEVEL_PROCEDURE,
1202: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.end',
1203: 'FPA_Scenario_Pvt.Update_Proj_User_Ranks: Inside for loop:User Rank ='||p_proj_metrics(i).user_rank);
1204: END IF;
1205: dbms_aw.execute( 'scenario_project_user_rank_m = ' || p_proj_metrics(i).user_rank );

Line 1212: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1208: END LOOP;
1209: END IF;
1210:
1211:
1212: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1213: FND_LOG.String
1214: (
1215: FND_LOG.LEVEL_PROCEDURE,
1216: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.end',

Line 1213: FND_LOG.String

1209: END IF;
1210:
1211:
1212: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1213: FND_LOG.String
1214: (
1215: FND_LOG.LEVEL_PROCEDURE,
1216: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.end',
1217: 'Exiting FPA_Scenario_Pvt.Update_Proj_User_Ranks'

Line 1215: FND_LOG.LEVEL_PROCEDURE,

1211:
1212: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1213: FND_LOG.String
1214: (
1215: FND_LOG.LEVEL_PROCEDURE,
1216: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.end',
1217: 'Exiting FPA_Scenario_Pvt.Update_Proj_User_Ranks'
1218: );
1219: END IF;

Line 1228: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN

1224:
1225: ROLLBACK;
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1227:
1228: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
1229: FND_LOG.String
1230: (
1231: FND_LOG.LEVEL_ERROR,
1232: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks',

Line 1229: FND_LOG.String

1225: ROLLBACK;
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1227:
1228: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
1229: FND_LOG.String
1230: (
1231: FND_LOG.LEVEL_ERROR,
1232: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks',
1233: SQLERRM

Line 1231: FND_LOG.LEVEL_ERROR,

1227:
1228: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
1229: FND_LOG.String
1230: (
1231: FND_LOG.LEVEL_ERROR,
1232: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks',
1233: SQLERRM
1234: );
1235: END IF;

Line 1270: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1266: l_api_version CONSTANT NUMBER := 1.0;
1267:
1268: begin
1269:
1270: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1271: fnd_log.string
1272: (
1273: FND_LOG.LEVEL_PROCEDURE,
1274: 'fpa.sql.fpa_scenario_pvt.calc_scenario_data.begin',

Line 1271: fnd_log.string

1267:
1268: begin
1269:
1270: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1271: fnd_log.string
1272: (
1273: FND_LOG.LEVEL_PROCEDURE,
1274: 'fpa.sql.fpa_scenario_pvt.calc_scenario_data.begin',
1275: 'Entering fpa_scenario_pvt.calc_scenario_data'

Line 1273: FND_LOG.LEVEL_PROCEDURE,

1269:
1270: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1271: fnd_log.string
1272: (
1273: FND_LOG.LEVEL_PROCEDURE,
1274: 'fpa.sql.fpa_scenario_pvt.calc_scenario_data.begin',
1275: 'Entering fpa_scenario_pvt.calc_scenario_data'
1276: );
1277: END IF;

Line 1279: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1275: 'Entering fpa_scenario_pvt.calc_scenario_data'
1276: );
1277: END IF;
1278:
1279: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1280: fnd_log.string
1281: (
1282: FND_LOG.LEVEL_PROCEDURE,
1283: 'fpa.sql.fpa_scenario_pvt.calc_scenario_data.',

Line 1280: fnd_log.string

1276: );
1277: END IF;
1278:
1279: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1280: fnd_log.string
1281: (
1282: FND_LOG.LEVEL_PROCEDURE,
1283: 'fpa.sql.fpa_scenario_pvt.calc_scenario_data.',
1284: 'Calling AW program CALC_SCE_ALL_DATA_PRG.'

Line 1282: FND_LOG.LEVEL_PROCEDURE,

1278:
1279: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1280: fnd_log.string
1281: (
1282: FND_LOG.LEVEL_PROCEDURE,
1283: 'fpa.sql.fpa_scenario_pvt.calc_scenario_data.',
1284: 'Calling AW program CALC_SCE_ALL_DATA_PRG.'
1285: );
1286: END IF;

Line 1296: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1292: elsif p_class_code_id is null
1293: then dbms_aw.execute('call calc_sce_all_data_prg(' || p_scenario_id || ' ' || p_project_id || ' na ''' || p_data_to_calc || ''')');
1294: end if;
1295:
1296: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1297: fnd_log.string
1298: (
1299: FND_LOG.LEVEL_PROCEDURE,
1300: 'fpa.sql.fpa_scenario_pvt.calc_scenario_data.end',

Line 1297: fnd_log.string

1293: then dbms_aw.execute('call calc_sce_all_data_prg(' || p_scenario_id || ' ' || p_project_id || ' na ''' || p_data_to_calc || ''')');
1294: end if;
1295:
1296: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1297: fnd_log.string
1298: (
1299: FND_LOG.LEVEL_PROCEDURE,
1300: 'fpa.sql.fpa_scenario_pvt.calc_scenario_data.end',
1301: 'Entering fpa_scenario_pvt.calc_scenario_data'

Line 1299: FND_LOG.LEVEL_PROCEDURE,

1295:
1296: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1297: fnd_log.string
1298: (
1299: FND_LOG.LEVEL_PROCEDURE,
1300: 'fpa.sql.fpa_scenario_pvt.calc_scenario_data.end',
1301: 'Entering fpa_scenario_pvt.calc_scenario_data'
1302: );
1303: END IF;

Line 1309: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1305: EXCEPTION
1306: WHEN OTHERS THEN
1307: ROLLBACK;
1308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1309: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1310: fnd_log.string
1311: (
1312: FND_LOG.LEVEL_ERROR,
1313: 'fpa.sql.fpa_scenario_pvt.calc_scenario_data',

Line 1310: fnd_log.string

1306: WHEN OTHERS THEN
1307: ROLLBACK;
1308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1309: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1310: fnd_log.string
1311: (
1312: FND_LOG.LEVEL_ERROR,
1313: 'fpa.sql.fpa_scenario_pvt.calc_scenario_data',
1314: SQLERRM

Line 1312: FND_LOG.LEVEL_ERROR,

1308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1309: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1310: fnd_log.string
1311: (
1312: FND_LOG.LEVEL_ERROR,
1313: 'fpa.sql.fpa_scenario_pvt.calc_scenario_data',
1314: SQLERRM
1315: );
1316: END IF;