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_PORTFOLIO_PROJECT_SETS_PVT dependencies on FND_LOG

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

56:
57: BEGIN
58:
59: FND_MSG_PUB.Initialize;
60: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
61: FND_LOG.STRING
62: (
63: FND_LOG.LEVEL_PROCEDURE,
64: 'FPA.SQL.fpa_portfolio_project_sets_pvt.delete_project_set_lines.begin',

Line 61: FND_LOG.STRING

57: BEGIN
58:
59: FND_MSG_PUB.Initialize;
60: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
61: FND_LOG.STRING
62: (
63: FND_LOG.LEVEL_PROCEDURE,
64: 'FPA.SQL.fpa_portfolio_project_sets_pvt.delete_project_set_lines.begin',
65: 'Entering FPA_PORTF_PROJECT_SETS.delete_project_set_lines'

Line 63: FND_LOG.LEVEL_PROCEDURE,

59: FND_MSG_PUB.Initialize;
60: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
61: FND_LOG.STRING
62: (
63: FND_LOG.LEVEL_PROCEDURE,
64: 'FPA.SQL.fpa_portfolio_project_sets_pvt.delete_project_set_lines.begin',
65: 'Entering FPA_PORTF_PROJECT_SETS.delete_project_set_lines'
66: );
67: END IF;

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

99: dbms_aw.execute('UPDATE');
100: END IF;
101: */
102:
103: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
104: FND_LOG.STRING
105: (
106: FND_LOG.LEVEL_PROCEDURE,
107: 'FPA.SQL.fpa_portfolio_project_sets.delete_project_set_lines.end',

Line 104: FND_LOG.STRING

100: END IF;
101: */
102:
103: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
104: FND_LOG.STRING
105: (
106: FND_LOG.LEVEL_PROCEDURE,
107: 'FPA.SQL.fpa_portfolio_project_sets.delete_project_set_lines.end',
108: 'Exiting fpa_portfolio_project_sets.delete_project_set_lines'

Line 106: FND_LOG.LEVEL_PROCEDURE,

102:
103: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
104: FND_LOG.STRING
105: (
106: FND_LOG.LEVEL_PROCEDURE,
107: 'FPA.SQL.fpa_portfolio_project_sets.delete_project_set_lines.end',
108: 'Exiting fpa_portfolio_project_sets.delete_project_set_lines'
109: );
110: END IF;

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

114: ROLLBACK;
115:
116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
117:
118: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
119: FND_LOG.STRING
120: (
121: FND_LOG.LEVEL_ERROR,
122: 'FPA.SQL.fpa_portfolio_project_sets.delete_project_set_lines',

Line 119: FND_LOG.STRING

115:
116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
117:
118: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
119: FND_LOG.STRING
120: (
121: FND_LOG.LEVEL_ERROR,
122: 'FPA.SQL.fpa_portfolio_project_sets.delete_project_set_lines',
123: SQLERRM

Line 121: FND_LOG.LEVEL_ERROR,

117:
118: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
119: FND_LOG.STRING
120: (
121: FND_LOG.LEVEL_ERROR,
122: 'FPA.SQL.fpa_portfolio_project_sets.delete_project_set_lines',
123: SQLERRM
124: );
125: END IF;

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

140:
141: /* Temp code ends*/
142: -- Get the Portfolio ownerId. This is used to set owner for project set.
143:
144: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
145: FND_LOG.STRING
146: (
147: FND_LOG.LEVEL_PROCEDURE,
148: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set',

Line 145: FND_LOG.STRING

141: /* Temp code ends*/
142: -- Get the Portfolio ownerId. This is used to set owner for project set.
143:
144: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
145: FND_LOG.STRING
146: (
147: FND_LOG.LEVEL_PROCEDURE,
148: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set',
149: 'Fetch Portfolio Owner Id'

Line 147: FND_LOG.LEVEL_PROCEDURE,

143:
144: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
145: FND_LOG.STRING
146: (
147: FND_LOG.LEVEL_PROCEDURE,
148: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set',
149: 'Fetch Portfolio Owner Id'
150: );
151: END IF;

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

153: open c_portfolio_owner;
154: fetch c_portfolio_owner into l_portfolio_owner_id;
155: close c_portfolio_owner;
156:
157: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
158: FND_LOG.STRING
159: (
160: FND_LOG.LEVEL_PROCEDURE,
161: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set',

Line 158: FND_LOG.STRING

154: fetch c_portfolio_owner into l_portfolio_owner_id;
155: close c_portfolio_owner;
156:
157: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
158: FND_LOG.STRING
159: (
160: FND_LOG.LEVEL_PROCEDURE,
161: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set',
162: 'Portfolio Owner ID ='||l_portfolio_owner_id

Line 160: FND_LOG.LEVEL_PROCEDURE,

156:
157: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
158: FND_LOG.STRING
159: (
160: FND_LOG.LEVEL_PROCEDURE,
161: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set',
162: 'Portfolio Owner ID ='||l_portfolio_owner_id
163: );
164: END IF;

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

164: END IF;
165:
166: FND_MSG_PUB.Initialize;
167:
168: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
169: FND_LOG.STRING
170: (
171: FND_LOG.LEVEL_PROCEDURE,
172: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.begin',

Line 169: FND_LOG.STRING

165:
166: FND_MSG_PUB.Initialize;
167:
168: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
169: FND_LOG.STRING
170: (
171: FND_LOG.LEVEL_PROCEDURE,
172: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.begin',
173: 'Entering fpa_portfolio_project_sets.create_project_set'

Line 171: FND_LOG.LEVEL_PROCEDURE,

167:
168: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
169: FND_LOG.STRING
170: (
171: FND_LOG.LEVEL_PROCEDURE,
172: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.begin',
173: 'Entering fpa_portfolio_project_sets.create_project_set'
174: );
175: END IF;

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

243:
244: -- l_project_set_id returned here is project_set_id for initial scenario.
245: -- set portfolio_project_set_submitted_r
246: -- New project set. so maintain project_set_d and set the relation
247: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
248: FND_LOG.STRING
249: (
250: FND_LOG.LEVEL_PROCEDURE,
251: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.',

Line 248: FND_LOG.STRING

244: -- l_project_set_id returned here is project_set_id for initial scenario.
245: -- set portfolio_project_set_submitted_r
246: -- New project set. so maintain project_set_d and set the relation
247: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
248: FND_LOG.STRING
249: (
250: FND_LOG.LEVEL_PROCEDURE,
251: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.',
252: 'Maintaining project_set_d with value ' || l_init_project_set_id

Line 250: FND_LOG.LEVEL_PROCEDURE,

246: -- New project set. so maintain project_set_d and set the relation
247: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
248: FND_LOG.STRING
249: (
250: FND_LOG.LEVEL_PROCEDURE,
251: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.',
252: 'Maintaining project_set_d with value ' || l_init_project_set_id
253: );
254: END IF;

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

254: END IF;
255: dbms_aw.execute('MAINTAIN project_set_d ADD ' || l_init_project_set_id);
256:
257: --Limit the values of portfolio, project_set_id
258: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
259: FND_LOG.STRING
260: (
261: FND_LOG.LEVEL_PROCEDURE,
262: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.',

Line 259: FND_LOG.STRING

255: dbms_aw.execute('MAINTAIN project_set_d ADD ' || l_init_project_set_id);
256:
257: --Limit the values of portfolio, project_set_id
258: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
259: FND_LOG.STRING
260: (
261: FND_LOG.LEVEL_PROCEDURE,
262: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.',
263: 'Limiting portfolio to ' || l_portfolio_id

Line 261: FND_LOG.LEVEL_PROCEDURE,

257: --Limit the values of portfolio, project_set_id
258: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
259: FND_LOG.STRING
260: (
261: FND_LOG.LEVEL_PROCEDURE,
262: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.',
263: 'Limiting portfolio to ' || l_portfolio_id
264: );
265: END IF;

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

264: );
265: END IF;
266: dbms_aw.execute('LMT portfolio_d TO ' || l_portfolio_id);
267:
268: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
269: FND_LOG.STRING
270: (
271: FND_LOG.LEVEL_PROCEDURE,
272: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.',

Line 269: FND_LOG.STRING

265: END IF;
266: dbms_aw.execute('LMT portfolio_d TO ' || l_portfolio_id);
267:
268: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
269: FND_LOG.STRING
270: (
271: FND_LOG.LEVEL_PROCEDURE,
272: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.',
273: 'Setting PORTFOLIO_PROJECT_SET_SUBMITTED_R with value ' || l_init_project_set_id

Line 271: FND_LOG.LEVEL_PROCEDURE,

267:
268: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
269: FND_LOG.STRING
270: (
271: FND_LOG.LEVEL_PROCEDURE,
272: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.',
273: 'Setting PORTFOLIO_PROJECT_SET_SUBMITTED_R with value ' || l_init_project_set_id
274: );
275: END IF;

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

274: );
275: END IF;
276: dbms_aw.execute('PORTFOLIO_PROJECT_SET_SUBMITTED_R = ' ||l_init_project_set_id);
277:
278: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
279: FND_LOG.STRING
280: (
281: FND_LOG.LEVEL_PROCEDURE,
282: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.',

Line 279: FND_LOG.STRING

275: END IF;
276: dbms_aw.execute('PORTFOLIO_PROJECT_SET_SUBMITTED_R = ' ||l_init_project_set_id);
277:
278: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
279: FND_LOG.STRING
280: (
281: FND_LOG.LEVEL_PROCEDURE,
282: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.',
283: 'Calling PA_PROJECT_SETS_PUB.create_project_set.'

Line 281: FND_LOG.LEVEL_PROCEDURE,

277:
278: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
279: FND_LOG.STRING
280: (
281: FND_LOG.LEVEL_PROCEDURE,
282: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.',
283: 'Calling PA_PROJECT_SETS_PUB.create_project_set.'
284: );
285: END IF;

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

304: -- project set created successfully
305: -- l_project_set_id returned here is project_set_id for approved scenario.
306: -- set portfolio_project_set_approved_r
307: -- New project set. so maintain project_set_d and set the relation
308: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
309: FND_LOG.STRING
310: (
311: FND_LOG.LEVEL_PROCEDURE,
312: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.begin',

Line 309: FND_LOG.STRING

305: -- l_project_set_id returned here is project_set_id for approved scenario.
306: -- set portfolio_project_set_approved_r
307: -- New project set. so maintain project_set_d and set the relation
308: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
309: FND_LOG.STRING
310: (
311: FND_LOG.LEVEL_PROCEDURE,
312: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.begin',
313: 'Maintaining project_set_d with value ' || l_appr_project_set_id

Line 311: FND_LOG.LEVEL_PROCEDURE,

307: -- New project set. so maintain project_set_d and set the relation
308: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
309: FND_LOG.STRING
310: (
311: FND_LOG.LEVEL_PROCEDURE,
312: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.begin',
313: 'Maintaining project_set_d with value ' || l_appr_project_set_id
314: );
315: END IF;

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

314: );
315: END IF;
316: dbms_aw.execute('MAINTAIN project_set_d ADD ' || l_appr_project_set_id);
317:
318: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
319: FND_LOG.STRING
320: (
321: FND_LOG.LEVEL_PROCEDURE,
322: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.begin',

Line 319: FND_LOG.STRING

315: END IF;
316: dbms_aw.execute('MAINTAIN project_set_d ADD ' || l_appr_project_set_id);
317:
318: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
319: FND_LOG.STRING
320: (
321: FND_LOG.LEVEL_PROCEDURE,
322: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.begin',
323: 'Limiting portfolio to value ' || l_portfolio_id

Line 321: FND_LOG.LEVEL_PROCEDURE,

317:
318: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
319: FND_LOG.STRING
320: (
321: FND_LOG.LEVEL_PROCEDURE,
322: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.begin',
323: 'Limiting portfolio to value ' || l_portfolio_id
324: );
325: END IF;

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

325: END IF;
326: --Limit the values of portfolio, project_set_id
327: dbms_aw.execute('LMT portfolio_d TO ' || l_portfolio_id);
328:
329: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
330: FND_LOG.STRING
331: (
332: FND_LOG.LEVEL_PROCEDURE,
333: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.begin',

Line 330: FND_LOG.STRING

326: --Limit the values of portfolio, project_set_id
327: dbms_aw.execute('LMT portfolio_d TO ' || l_portfolio_id);
328:
329: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
330: FND_LOG.STRING
331: (
332: FND_LOG.LEVEL_PROCEDURE,
333: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.begin',
334: 'Setting PORTFOLIO_PROJECT_SET_APPROVED_R with value ' || l_appr_project_set_id

Line 332: FND_LOG.LEVEL_PROCEDURE,

328:
329: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
330: FND_LOG.STRING
331: (
332: FND_LOG.LEVEL_PROCEDURE,
333: 'FPA.SQL.fpa_portfolio_project_sets.create_project_set.begin',
334: 'Setting PORTFOLIO_PROJECT_SET_APPROVED_R with value ' || l_appr_project_set_id
335: );
336: END IF;

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

346: COMMIT;
347: END IF;
348: */
349:
350: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
351: FND_LOG.STRING
352: (
353: FND_LOG.LEVEL_PROCEDURE,
354: 'FPA.SQL.fpa_portfolio_project_sets.Create_project_set.end',

Line 351: FND_LOG.STRING

347: END IF;
348: */
349:
350: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
351: FND_LOG.STRING
352: (
353: FND_LOG.LEVEL_PROCEDURE,
354: 'FPA.SQL.fpa_portfolio_project_sets.Create_project_set.end',
355: 'Exiting fpa_portfolio_project_sets.Create_project_set'

Line 353: FND_LOG.LEVEL_PROCEDURE,

349:
350: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
351: FND_LOG.STRING
352: (
353: FND_LOG.LEVEL_PROCEDURE,
354: 'FPA.SQL.fpa_portfolio_project_sets.Create_project_set.end',
355: 'Exiting fpa_portfolio_project_sets.Create_project_set'
356: );
357: END IF;

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

363:
364:
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366:
367: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
368: FND_LOG.STRING
369: (
370: FND_LOG.LEVEL_ERROR,
371: 'FPA.SQL.fpa_portfolio_project_sets.Create_project_set',

Line 368: FND_LOG.STRING

364:
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366:
367: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
368: FND_LOG.STRING
369: (
370: FND_LOG.LEVEL_ERROR,
371: 'FPA.SQL.fpa_portfolio_project_sets.Create_project_set',
372: SQLERRM

Line 370: FND_LOG.LEVEL_ERROR,

366:
367: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
368: FND_LOG.STRING
369: (
370: FND_LOG.LEVEL_ERROR,
371: 'FPA.SQL.fpa_portfolio_project_sets.Create_project_set',
372: SQLERRM
373: );
374: END IF;

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

413: BEGIN
414:
415: FND_MSG_PUB.Initialize;
416:
417: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
418: FND_LOG.STRING
419: (
420: FND_LOG.LEVEL_PROCEDURE,
421: 'FPA.SQL.fpa_portfolio_project_sets.add_projects_project_set.begin',

Line 418: FND_LOG.STRING

414:
415: FND_MSG_PUB.Initialize;
416:
417: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
418: FND_LOG.STRING
419: (
420: FND_LOG.LEVEL_PROCEDURE,
421: 'FPA.SQL.fpa_portfolio_project_sets.add_projects_project_set.begin',
422: 'Entering fpa_portfolio_project_sets.add_projects_project_set'

Line 420: FND_LOG.LEVEL_PROCEDURE,

416:
417: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
418: FND_LOG.STRING
419: (
420: FND_LOG.LEVEL_PROCEDURE,
421: 'FPA.SQL.fpa_portfolio_project_sets.add_projects_project_set.begin',
422: 'Entering fpa_portfolio_project_sets.add_projects_project_set'
423: );
424: END IF;

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

438: end if;
439:
440: END IF;
441:
442: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
443: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
444: 'fpa.sql.fpa_main_process_pvt.add_project_set_lines',
445: 'processing project_set_id = '|| l_project_set_id);
446: END IF;

Line 443: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

439:
440: END IF;
441:
442: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
443: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
444: 'fpa.sql.fpa_main_process_pvt.add_project_set_lines',
445: 'processing project_set_id = '|| l_project_set_id);
446: END IF;
447:

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

475:
476: IF l_proj_list.count > 0 then -- If there are no projects in Initial scenario, do nothing.
477: -- just exit the procedure.
478:
479: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
480: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
481: 'fpa.sql.fpa_main_process_pvt.add_project_set_lines',
482: 'Number of projects in this scenario = '|| l_proj_list.count);
483: END IF;

Line 480: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

476: IF l_proj_list.count > 0 then -- If there are no projects in Initial scenario, do nothing.
477: -- just exit the procedure.
478:
479: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
480: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
481: 'fpa.sql.fpa_main_process_pvt.add_project_set_lines',
482: 'Number of projects in this scenario = '|| l_proj_list.count);
483: END IF;
484:

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

515: COMMIT;
516: END IF;
517: */
518:
519: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
520: FND_LOG.STRING
521: (
522: FND_LOG.LEVEL_PROCEDURE,
523: 'FPA.SQL.fpa_portfolio_project_sets.add_projects_project_set.end',

Line 520: FND_LOG.STRING

516: END IF;
517: */
518:
519: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
520: FND_LOG.STRING
521: (
522: FND_LOG.LEVEL_PROCEDURE,
523: 'FPA.SQL.fpa_portfolio_project_sets.add_projects_project_set.end',
524: 'Exiting fpa_portfolio_project_sets.add_projects_project_set'

Line 522: FND_LOG.LEVEL_PROCEDURE,

518:
519: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
520: FND_LOG.STRING
521: (
522: FND_LOG.LEVEL_PROCEDURE,
523: 'FPA.SQL.fpa_portfolio_project_sets.add_projects_project_set.end',
524: 'Exiting fpa_portfolio_project_sets.add_projects_project_set'
525: );
526: END IF;

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

530: ROLLBACK;
531:
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533:
534: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
535: FND_LOG.STRING
536: (
537: FND_LOG.LEVEL_ERROR,
538: 'FPA.SQL.fpa_portfolio_project_sets.add_projects_project_set',

Line 535: FND_LOG.STRING

531:
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533:
534: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
535: FND_LOG.STRING
536: (
537: FND_LOG.LEVEL_ERROR,
538: 'FPA.SQL.fpa_portfolio_project_sets.add_projects_project_set',
539: SQLERRM

Line 537: FND_LOG.LEVEL_ERROR,

533:
534: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
535: FND_LOG.STRING
536: (
537: FND_LOG.LEVEL_ERROR,
538: 'FPA.SQL.fpa_portfolio_project_sets.add_projects_project_set',
539: SQLERRM
540: );
541: END IF;