APPS.FPA_PLANNINGCYCLE_PVT dependencies on FND_LOG

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

42: WHERE installed_flag IN ('I','B');
43:
44: BEGIN
45:
46: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
47: FND_LOG.String
48: (
49: FND_LOG.LEVEL_PROCEDURE,
50: 'fpa.sql.FPA_PlanningCycle_Pvt.Create_Pc.begin',

Line 47: FND_LOG.String

43:
44: BEGIN
45:
46: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
47: FND_LOG.String
48: (
49: FND_LOG.LEVEL_PROCEDURE,
50: 'fpa.sql.FPA_PlanningCycle_Pvt.Create_Pc.begin',
51: 'Entering FPA_PlanningCycle_Pvt.Create_Pc'

Line 49: FND_LOG.LEVEL_PROCEDURE,

45:
46: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
47: FND_LOG.String
48: (
49: FND_LOG.LEVEL_PROCEDURE,
50: 'fpa.sql.FPA_PlanningCycle_Pvt.Create_Pc.begin',
51: 'Entering FPA_PlanningCycle_Pvt.Create_Pc'
52: );
53: END IF;

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

117: dbms_aw.execute('portfolio_pc_r = ' || p_pc_all_obj.pc_info.portfolio );
118:
119: dbms_aw.execute('POP planning_cycle_d');
120:
121: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
122: FND_LOG.String
123: (
124: FND_LOG.LEVEL_PROCEDURE,
125: 'fpa.sql.FPA_PlanningCycle_Pvt.Create_Pc.end',

Line 122: FND_LOG.String

118:
119: dbms_aw.execute('POP planning_cycle_d');
120:
121: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
122: FND_LOG.String
123: (
124: FND_LOG.LEVEL_PROCEDURE,
125: 'fpa.sql.FPA_PlanningCycle_Pvt.Create_Pc.end',
126: 'Exiting FPA_PlanningCycle_Pvt.Create_Pc'

Line 124: FND_LOG.LEVEL_PROCEDURE,

120:
121: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
122: FND_LOG.String
123: (
124: FND_LOG.LEVEL_PROCEDURE,
125: 'fpa.sql.FPA_PlanningCycle_Pvt.Create_Pc.end',
126: 'Exiting FPA_PlanningCycle_Pvt.Create_Pc'
127: );
128: END IF;

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

138:
139: ROLLBACK;
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141:
142: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
143: FND_LOG.String
144: (
145: FND_LOG.LEVEL_ERROR,
146: 'fpa.sql.FPA_PlanningCycle_Pvt.Create_Pc',

Line 143: FND_LOG.String

139: ROLLBACK;
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141:
142: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
143: FND_LOG.String
144: (
145: FND_LOG.LEVEL_ERROR,
146: 'fpa.sql.FPA_PlanningCycle_Pvt.Create_Pc',
147: SQLERRM

Line 145: FND_LOG.LEVEL_ERROR,

141:
142: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
143: FND_LOG.String
144: (
145: FND_LOG.LEVEL_ERROR,
146: 'fpa.sql.FPA_PlanningCycle_Pvt.Create_Pc',
147: SQLERRM
148: );
149: END IF;

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

167: IS
168: l_pc_catg number;
169: l_aw_call varchar2(50);
170: BEGIN
171: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
172: FND_LOG.String
173: (
174: FND_LOG.LEVEL_PROCEDURE,
175: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix.begin',

Line 172: FND_LOG.String

168: l_pc_catg number;
169: l_aw_call varchar2(50);
170: BEGIN
171: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
172: FND_LOG.String
173: (
174: FND_LOG.LEVEL_PROCEDURE,
175: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix.begin',
176: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix'

Line 174: FND_LOG.LEVEL_PROCEDURE,

170: BEGIN
171: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
172: FND_LOG.String
173: (
174: FND_LOG.LEVEL_PROCEDURE,
175: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix.begin',
176: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix'
177: );
178: END IF;

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

218:
219: END LOOP;
220:
221:
222: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
223: FND_LOG.String
224: (
225: FND_LOG.LEVEL_PROCEDURE,
226: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix.end',

Line 223: FND_LOG.String

219: END LOOP;
220:
221:
222: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
223: FND_LOG.String
224: (
225: FND_LOG.LEVEL_PROCEDURE,
226: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix.end',
227: 'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix'

Line 225: FND_LOG.LEVEL_PROCEDURE,

221:
222: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
223: FND_LOG.String
224: (
225: FND_LOG.LEVEL_PROCEDURE,
226: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix.end',
227: 'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix'
228: );
229: END IF;

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

234:
235: ROLLBACK;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237:
238: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
239: FND_LOG.String
240: (
241: FND_LOG.LEVEL_ERROR,
242: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix',

Line 239: FND_LOG.String

235: ROLLBACK;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237:
238: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
239: FND_LOG.String
240: (
241: FND_LOG.LEVEL_ERROR,
242: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix',
243: SQLERRM

Line 241: FND_LOG.LEVEL_ERROR,

237:
238: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
239: FND_LOG.String
240: (
241: FND_LOG.LEVEL_ERROR,
242: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix',
243: SQLERRM
244: );
245: END IF;

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

268: l_financial_target_to_c VARCHAR2(100);
269: l_decimal_marker VARCHAR2(1);
270: BEGIN
271:
272: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
273: FND_LOG.String
274: (
275: FND_LOG.LEVEL_PROCEDURE,
276: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets.begin',

Line 273: FND_LOG.String

269: l_decimal_marker VARCHAR2(1);
270: BEGIN
271:
272: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
273: FND_LOG.String
274: (
275: FND_LOG.LEVEL_PROCEDURE,
276: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets.begin',
277: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets'

Line 275: FND_LOG.LEVEL_PROCEDURE,

271:
272: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
273: FND_LOG.String
274: (
275: FND_LOG.LEVEL_PROCEDURE,
276: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets.begin',
277: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets'
278: );
279: END IF;

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

334: dbms_aw.execute('pc_fintargets_range_to_m = ' || l_financial_target_to_c );
335: END LOOP;
336:
337:
338: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
339: FND_LOG.String
340: (
341: FND_LOG.LEVEL_PROCEDURE,
342: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets.end',

Line 339: FND_LOG.String

335: END LOOP;
336:
337:
338: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
339: FND_LOG.String
340: (
341: FND_LOG.LEVEL_PROCEDURE,
342: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets.end',
343: 'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets'

Line 341: FND_LOG.LEVEL_PROCEDURE,

337:
338: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
339: FND_LOG.String
340: (
341: FND_LOG.LEVEL_PROCEDURE,
342: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets.end',
343: 'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets'
344: );
345: END IF;

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

352:
353: ROLLBACK;
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
355:
356: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
357: FND_LOG.String
358: (
359: FND_LOG.LEVEL_ERROR,
360: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets',

Line 357: FND_LOG.String

353: ROLLBACK;
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
355:
356: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
357: FND_LOG.String
358: (
359: FND_LOG.LEVEL_ERROR,
360: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets',
361: SQLERRM

Line 359: FND_LOG.LEVEL_ERROR,

355:
356: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
357: FND_LOG.String
358: (
359: FND_LOG.LEVEL_ERROR,
360: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets',
361: SQLERRM
362: );
363: END IF;

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

381: l_pc_obj varchar2(3);
382:
383: BEGIN
384:
385: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
386: FND_LOG.String
387: ( FND_LOG.LEVEL_PROCEDURE,
388: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data.begin',
389: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data'

Line 386: FND_LOG.String

382:
383: BEGIN
384:
385: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
386: FND_LOG.String
387: ( FND_LOG.LEVEL_PROCEDURE,
388: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data.begin',
389: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data'
390: );

Line 387: ( FND_LOG.LEVEL_PROCEDURE,

383: BEGIN
384:
385: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
386: FND_LOG.String
387: ( FND_LOG.LEVEL_PROCEDURE,
388: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data.begin',
389: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data'
390: );
391: END IF;

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

397: --DBMS_OUTPUT.put_line(' ..p_inv_crit_tbl(1).pc_project_score_scale=' || p_inv_crit_tbl(1).pc_project_score_scale );
398:
399: -- Update the investment criteria data
400: -- Limit PCID
401: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
402: FND_LOG.String
403: ( FND_LOG.LEVEL_PROCEDURE,
404: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
405: 'Limit pc dimension to ' || p_inv_crit_tbl(1).planning_cycle || ' value.'

Line 402: FND_LOG.String

398:
399: -- Update the investment criteria data
400: -- Limit PCID
401: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
402: FND_LOG.String
403: ( FND_LOG.LEVEL_PROCEDURE,
404: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
405: 'Limit pc dimension to ' || p_inv_crit_tbl(1).planning_cycle || ' value.'
406: );

Line 403: ( FND_LOG.LEVEL_PROCEDURE,

399: -- Update the investment criteria data
400: -- Limit PCID
401: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
402: FND_LOG.String
403: ( FND_LOG.LEVEL_PROCEDURE,
404: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
405: 'Limit pc dimension to ' || p_inv_crit_tbl(1).planning_cycle || ' value.'
406: );
407: END IF;

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

407: END IF;
408: dbms_aw.execute('LMT planning_cycle_d TO ' || p_inv_crit_tbl(1).planning_cycle);
409:
410: -- Set the score source
411: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
412: FND_LOG.String
413: ( FND_LOG.LEVEL_PROCEDURE,
414: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
415: 'Setting score_type_pc_r to: ' || p_inv_crit_tbl(1).pc_project_score_source || ' value.'

Line 412: FND_LOG.String

408: dbms_aw.execute('LMT planning_cycle_d TO ' || p_inv_crit_tbl(1).planning_cycle);
409:
410: -- Set the score source
411: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
412: FND_LOG.String
413: ( FND_LOG.LEVEL_PROCEDURE,
414: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
415: 'Setting score_type_pc_r to: ' || p_inv_crit_tbl(1).pc_project_score_source || ' value.'
416: );

Line 413: ( FND_LOG.LEVEL_PROCEDURE,

409:
410: -- Set the score source
411: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
412: FND_LOG.String
413: ( FND_LOG.LEVEL_PROCEDURE,
414: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
415: 'Setting score_type_pc_r to: ' || p_inv_crit_tbl(1).pc_project_score_source || ' value.'
416: );
417: END IF;

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

417: END IF;
418: dbms_aw.execute('score_type_pc_r = ''' || p_inv_crit_tbl(1).pc_project_score_source || '''');
419:
420: -- Set the score scale
421: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
422: FND_LOG.String
423: ( FND_LOG.LEVEL_PROCEDURE,
424: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
425: 'Setting pc_project_score_scale_m to: ' || p_inv_crit_tbl(1).pc_project_score_scale || ' value.'

Line 422: FND_LOG.String

418: dbms_aw.execute('score_type_pc_r = ''' || p_inv_crit_tbl(1).pc_project_score_source || '''');
419:
420: -- Set the score scale
421: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
422: FND_LOG.String
423: ( FND_LOG.LEVEL_PROCEDURE,
424: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
425: 'Setting pc_project_score_scale_m to: ' || p_inv_crit_tbl(1).pc_project_score_scale || ' value.'
426: );

Line 423: ( FND_LOG.LEVEL_PROCEDURE,

419:
420: -- Set the score scale
421: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
422: FND_LOG.String
423: ( FND_LOG.LEVEL_PROCEDURE,
424: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
425: 'Setting pc_project_score_scale_m to: ' || p_inv_crit_tbl(1).pc_project_score_scale || ' value.'
426: );
427: END IF;

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

430:
431: FOR i IN p_inv_crit_tbl.FIRST..p_inv_crit_tbl.LAST
432: LOOP
433:
434: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
435: FND_LOG.String
436: ( FND_LOG.LEVEL_PROCEDURE,
437: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
438: 'Debugging, we are in ' || i || ' value.'

Line 435: FND_LOG.String

431: FOR i IN p_inv_crit_tbl.FIRST..p_inv_crit_tbl.LAST
432: LOOP
433:
434: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
435: FND_LOG.String
436: ( FND_LOG.LEVEL_PROCEDURE,
437: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
438: 'Debugging, we are in ' || i || ' value.'
439: );

Line 436: ( FND_LOG.LEVEL_PROCEDURE,

432: LOOP
433:
434: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
435: FND_LOG.String
436: ( FND_LOG.LEVEL_PROCEDURE,
437: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
438: 'Debugging, we are in ' || i || ' value.'
439: );
440: END IF;

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

440: END IF;
441:
442:
443: -- Limit strategic_obj_d
444: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
445: FND_LOG.String
446: ( FND_LOG.LEVEL_PROCEDURE,
447: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
448: 'Limit strategic_obj_d dimension to ' || p_inv_crit_tbl(i).investment_criteria || ' value.'

Line 445: FND_LOG.String

441:
442:
443: -- Limit strategic_obj_d
444: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
445: FND_LOG.String
446: ( FND_LOG.LEVEL_PROCEDURE,
447: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
448: 'Limit strategic_obj_d dimension to ' || p_inv_crit_tbl(i).investment_criteria || ' value.'
449: );

Line 446: ( FND_LOG.LEVEL_PROCEDURE,

442:
443: -- Limit strategic_obj_d
444: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
445: FND_LOG.String
446: ( FND_LOG.LEVEL_PROCEDURE,
447: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
448: 'Limit strategic_obj_d dimension to ' || p_inv_crit_tbl(i).investment_criteria || ' value.'
449: );
450: END IF;

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

452:
453: --DBMS_OUTPUT.put_line(' ..Inside For loop...after setting p_inv_crit_tbl(i).investment_criteria' );
454:
455: -- Set the weights for each strategic_obj
456: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
457: FND_LOG.String
458: ( FND_LOG.LEVEL_PROCEDURE,
459: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
460: 'Setting pc_strategic_obj_weights_m: ' || p_inv_crit_tbl(i).pc_inv_criteria_weight || ' value.'

Line 457: FND_LOG.String

453: --DBMS_OUTPUT.put_line(' ..Inside For loop...after setting p_inv_crit_tbl(i).investment_criteria' );
454:
455: -- Set the weights for each strategic_obj
456: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
457: FND_LOG.String
458: ( FND_LOG.LEVEL_PROCEDURE,
459: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
460: 'Setting pc_strategic_obj_weights_m: ' || p_inv_crit_tbl(i).pc_inv_criteria_weight || ' value.'
461: );

Line 458: ( FND_LOG.LEVEL_PROCEDURE,

454:
455: -- Set the weights for each strategic_obj
456: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
457: FND_LOG.String
458: ( FND_LOG.LEVEL_PROCEDURE,
459: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
460: 'Setting pc_strategic_obj_weights_m: ' || p_inv_crit_tbl(i).pc_inv_criteria_weight || ' value.'
461: );
462: END IF;

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

464:
465: --DBMS_OUTPUT.put_line(' ..Inside For loop...after setting p_inv_crit_tbl(i).pc_inv_criteria_weight' );
466:
467: -- Set the target from for each strategic_obj
468: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
469: FND_LOG.String
470: ( FND_LOG.LEVEL_PROCEDURE,
471: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
472: 'Setting pc_obj_wscore_targets_from_m: ' || p_inv_crit_tbl(i).pc_inv_crit_score_target_from || ' value.'

Line 469: FND_LOG.String

465: --DBMS_OUTPUT.put_line(' ..Inside For loop...after setting p_inv_crit_tbl(i).pc_inv_criteria_weight' );
466:
467: -- Set the target from for each strategic_obj
468: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
469: FND_LOG.String
470: ( FND_LOG.LEVEL_PROCEDURE,
471: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
472: 'Setting pc_obj_wscore_targets_from_m: ' || p_inv_crit_tbl(i).pc_inv_crit_score_target_from || ' value.'
473: );

Line 470: ( FND_LOG.LEVEL_PROCEDURE,

466:
467: -- Set the target from for each strategic_obj
468: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
469: FND_LOG.String
470: ( FND_LOG.LEVEL_PROCEDURE,
471: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
472: 'Setting pc_obj_wscore_targets_from_m: ' || p_inv_crit_tbl(i).pc_inv_crit_score_target_from || ' value.'
473: );
474: END IF;

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

483:
484: --DBMS_OUTPUT.put_line(' ..Inside For loop...after setting p_inv_crit_tbl(i).pc_inv_crit_score_target_from' );
485:
486: -- Set the target to for each strategic_obj
487: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
488: FND_LOG.String
489: ( FND_LOG.LEVEL_PROCEDURE,
490: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
491: 'Setting pc_obj_wscore_targets_to_m: ' || p_inv_crit_tbl(i).pc_inv_crit_score_target_to || ' value.'

Line 488: FND_LOG.String

484: --DBMS_OUTPUT.put_line(' ..Inside For loop...after setting p_inv_crit_tbl(i).pc_inv_crit_score_target_from' );
485:
486: -- Set the target to for each strategic_obj
487: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
488: FND_LOG.String
489: ( FND_LOG.LEVEL_PROCEDURE,
490: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
491: 'Setting pc_obj_wscore_targets_to_m: ' || p_inv_crit_tbl(i).pc_inv_crit_score_target_to || ' value.'
492: );

Line 489: ( FND_LOG.LEVEL_PROCEDURE,

485:
486: -- Set the target to for each strategic_obj
487: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
488: FND_LOG.String
489: ( FND_LOG.LEVEL_PROCEDURE,
490: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
491: 'Setting pc_obj_wscore_targets_to_m: ' || p_inv_crit_tbl(i).pc_inv_crit_score_target_to || ' value.'
492: );
493: END IF;

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

502:
503: END LOOP;
504:
505: /*
506: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
507: FND_LOG.String
508: ( FND_LOG.LEVEL_PROCEDURE,
509: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
510: 'Calling AW program: set_pc_invest_criteria_prg( ' || p_inv_crit_tbl(1).planning_cycle || ').'

Line 507: FND_LOG.String

503: END LOOP;
504:
505: /*
506: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
507: FND_LOG.String
508: ( FND_LOG.LEVEL_PROCEDURE,
509: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
510: 'Calling AW program: set_pc_invest_criteria_prg( ' || p_inv_crit_tbl(1).planning_cycle || ').'
511: );

Line 508: ( FND_LOG.LEVEL_PROCEDURE,

504:
505: /*
506: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
507: FND_LOG.String
508: ( FND_LOG.LEVEL_PROCEDURE,
509: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
510: 'Calling AW program: set_pc_invest_criteria_prg( ' || p_inv_crit_tbl(1).planning_cycle || ').'
511: );
512: END IF;

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

513: dbms_aw.execute('call set_pc_invest_criteria_prg(' || p_inv_crit_tbl(1).planning_cycle || ')');
514: */
515:
516:
517: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
518: FND_LOG.String
519: (
520: FND_LOG.LEVEL_PROCEDURE,
521: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data.end',

Line 518: FND_LOG.String

514: */
515:
516:
517: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
518: FND_LOG.String
519: (
520: FND_LOG.LEVEL_PROCEDURE,
521: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data.end',
522: 'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data'

Line 520: FND_LOG.LEVEL_PROCEDURE,

516:
517: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
518: FND_LOG.String
519: (
520: FND_LOG.LEVEL_PROCEDURE,
521: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data.end',
522: 'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data'
523: );
524: END IF;

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

529:
530: ROLLBACK;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532:
533: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
534: FND_LOG.String
535: (
536: FND_LOG.LEVEL_ERROR,
537: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',

Line 534: FND_LOG.String

530: ROLLBACK;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532:
533: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
534: FND_LOG.String
535: (
536: FND_LOG.LEVEL_ERROR,
537: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
538: SQLERRM

Line 536: FND_LOG.LEVEL_ERROR,

532:
533: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
534: FND_LOG.String
535: (
536: FND_LOG.LEVEL_ERROR,
537: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data',
538: SQLERRM
539: );
540: END IF;

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

558: IS
559:
560: BEGIN
561:
562: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
563: FND_LOG.String
564: (
565: FND_LOG.LEVEL_PROCEDURE,
566: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields.begin',

Line 563: FND_LOG.String

559:
560: BEGIN
561:
562: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
563: FND_LOG.String
564: (
565: FND_LOG.LEVEL_PROCEDURE,
566: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields.begin',
567: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields'

Line 565: FND_LOG.LEVEL_PROCEDURE,

561:
562: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
563: FND_LOG.String
564: (
565: FND_LOG.LEVEL_PROCEDURE,
566: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields.begin',
567: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields'
568: );
569: END IF;

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

580: WHERE id = p_pc_all_obj.pc_desc_fields.id
581: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG)
582: AND OBJECT = 'PLANNING_CYCLE'; --Added for bug 6142322
583:
584: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
585: FND_LOG.String
586: (
587: FND_LOG.LEVEL_PROCEDURE,
588: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields.end',

Line 585: FND_LOG.String

581: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG)
582: AND OBJECT = 'PLANNING_CYCLE'; --Added for bug 6142322
583:
584: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
585: FND_LOG.String
586: (
587: FND_LOG.LEVEL_PROCEDURE,
588: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields.end',
589: 'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields'

Line 587: FND_LOG.LEVEL_PROCEDURE,

583:
584: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
585: FND_LOG.String
586: (
587: FND_LOG.LEVEL_PROCEDURE,
588: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields.end',
589: 'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields'
590: );
591: END IF;

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

594: WHEN OTHERS THEN
595: ROLLBACK;
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
597:
598: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
599: FND_LOG.String
600: (
601: FND_LOG.LEVEL_ERROR,
602: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields',

Line 599: FND_LOG.String

595: ROLLBACK;
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
597:
598: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
599: FND_LOG.String
600: (
601: FND_LOG.LEVEL_ERROR,
602: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields',
603: SQLERRM

Line 601: FND_LOG.LEVEL_ERROR,

597:
598: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
599: FND_LOG.String
600: (
601: FND_LOG.LEVEL_ERROR,
602: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields',
603: SQLERRM
604: );
605: END IF;

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

624:
625: BEGIN
626: --DBMS_OUTPUT.put_line('Inside Set_Pc_Status....');
627:
628: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
629: FND_LOG.String
630: (
631: FND_LOG.LEVEL_PROCEDURE,
632: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Status.begin',

Line 629: FND_LOG.String

625: BEGIN
626: --DBMS_OUTPUT.put_line('Inside Set_Pc_Status....');
627:
628: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
629: FND_LOG.String
630: (
631: FND_LOG.LEVEL_PROCEDURE,
632: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Status.begin',
633: 'Entering FPA_PlanningCycle_Pvt.Set_Pc_Status'

Line 631: FND_LOG.LEVEL_PROCEDURE,

627:
628: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
629: FND_LOG.String
630: (
631: FND_LOG.LEVEL_PROCEDURE,
632: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Status.begin',
633: 'Entering FPA_PlanningCycle_Pvt.Set_Pc_Status'
634: );
635: END IF;

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

642: -- Set the new staus
643: dbms_aw.execute('status_pc_r = ''' || p_pc_status_code || '''');
644:
645:
646: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
647: FND_LOG.String
648: (
649: FND_LOG.LEVEL_PROCEDURE,
650: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Status.end',

Line 647: FND_LOG.String

643: dbms_aw.execute('status_pc_r = ''' || p_pc_status_code || '''');
644:
645:
646: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
647: FND_LOG.String
648: (
649: FND_LOG.LEVEL_PROCEDURE,
650: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Status.end',
651: 'Exiting FPA_PlanningCycle_Pvt.Set_Pc_Status'

Line 649: FND_LOG.LEVEL_PROCEDURE,

645:
646: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
647: FND_LOG.String
648: (
649: FND_LOG.LEVEL_PROCEDURE,
650: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Status.end',
651: 'Exiting FPA_PlanningCycle_Pvt.Set_Pc_Status'
652: );
653: END IF;

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

656: WHEN OTHERS THEN
657: ROLLBACK;
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659:
660: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
661: FND_LOG.String
662: (
663: FND_LOG.LEVEL_ERROR,
664: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Status',

Line 661: FND_LOG.String

657: ROLLBACK;
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659:
660: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
661: FND_LOG.String
662: (
663: FND_LOG.LEVEL_ERROR,
664: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Status',
665: SQLERRM

Line 663: FND_LOG.LEVEL_ERROR,

659:
660: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
661: FND_LOG.String
662: (
663: FND_LOG.LEVEL_ERROR,
664: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Status',
665: SQLERRM
666: );
667: END IF;

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

684: IS
685: BEGIN
686: --DBMS_OUTPUT.put_line('Inside Set_Pc_Initiate_Date....');
687:
688: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
689: FND_LOG.String
690: (
691: FND_LOG.LEVEL_PROCEDURE,
692: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Initiate_Date.begin',

Line 689: FND_LOG.String

685: BEGIN
686: --DBMS_OUTPUT.put_line('Inside Set_Pc_Initiate_Date....');
687:
688: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
689: FND_LOG.String
690: (
691: FND_LOG.LEVEL_PROCEDURE,
692: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Initiate_Date.begin',
693: 'Entering FPA_PlanningCycle_Pvt.Set_Pc_Initiate_Date'

Line 691: FND_LOG.LEVEL_PROCEDURE,

687:
688: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
689: FND_LOG.String
690: (
691: FND_LOG.LEVEL_PROCEDURE,
692: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Initiate_Date.begin',
693: 'Entering FPA_PlanningCycle_Pvt.Set_Pc_Initiate_Date'
694: );
695: END IF;

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

725: dbms_aw.execute('pc_initiate_date_r = '''
726: || to_char(to_date(p_pc_init_date, 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));
727: */
728:
729: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
730: FND_LOG.String
731: (
732: FND_LOG.LEVEL_PROCEDURE,
733: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Initiate_Date.end',

Line 730: FND_LOG.String

726: || to_char(to_date(p_pc_init_date, 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));
727: */
728:
729: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
730: FND_LOG.String
731: (
732: FND_LOG.LEVEL_PROCEDURE,
733: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Initiate_Date.end',
734: 'Exiting FPA_PlanningCycle_Pvt.Set_Pc_Initiate_Date'

Line 732: FND_LOG.LEVEL_PROCEDURE,

728:
729: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
730: FND_LOG.String
731: (
732: FND_LOG.LEVEL_PROCEDURE,
733: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Initiate_Date.end',
734: 'Exiting FPA_PlanningCycle_Pvt.Set_Pc_Initiate_Date'
735: );
736: END IF;

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

739: WHEN OTHERS THEN
740: ROLLBACK;
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742:
743: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
744: FND_LOG.String
745: (
746: FND_LOG.LEVEL_ERROR,
747: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Initiate',

Line 744: FND_LOG.String

740: ROLLBACK;
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742:
743: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
744: FND_LOG.String
745: (
746: FND_LOG.LEVEL_ERROR,
747: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Initiate',
748: SQLERRM

Line 746: FND_LOG.LEVEL_ERROR,

742:
743: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
744: FND_LOG.String
745: (
746: FND_LOG.LEVEL_ERROR,
747: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Initiate',
748: SQLERRM
749: );
750: END IF;

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

770:
771: BEGIN
772: --DBMS_OUTPUT.put_line('Inside Update_Pc_Class_Category....');
773:
774: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
775: FND_LOG.String
776: (
777: FND_LOG.LEVEL_PROCEDURE,
778: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Class_Category.begin',

Line 775: FND_LOG.String

771: BEGIN
772: --DBMS_OUTPUT.put_line('Inside Update_Pc_Class_Category....');
773:
774: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
775: FND_LOG.String
776: (
777: FND_LOG.LEVEL_PROCEDURE,
778: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Class_Category.begin',
779: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Class_Category'

Line 777: FND_LOG.LEVEL_PROCEDURE,

773:
774: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
775: FND_LOG.String
776: (
777: FND_LOG.LEVEL_PROCEDURE,
778: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Class_Category.begin',
779: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Class_Category'
780: );
781: END IF;

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

788: --DBMS_OUTPUT.put_line('Before setting pc_class_code_m ....');
789: -- Set the new class category
790: dbms_aw.execute('pc_category_m = ''' || p_catg_id || '''');
791:
792: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
793: FND_LOG.String
794: (
795: FND_LOG.LEVEL_PROCEDURE,
796: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Class_Category.end',

Line 793: FND_LOG.String

789: -- Set the new class category
790: dbms_aw.execute('pc_category_m = ''' || p_catg_id || '''');
791:
792: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
793: FND_LOG.String
794: (
795: FND_LOG.LEVEL_PROCEDURE,
796: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Class_Category.end',
797: 'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Class_Category'

Line 795: FND_LOG.LEVEL_PROCEDURE,

791:
792: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
793: FND_LOG.String
794: (
795: FND_LOG.LEVEL_PROCEDURE,
796: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Class_Category.end',
797: 'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Class_Category'
798: );
799: END IF;

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

802: WHEN OTHERS THEN
803: ROLLBACK;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805:
806: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
807: FND_LOG.String
808: (
809: FND_LOG.LEVEL_ERROR,
810: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Class_Category',

Line 807: FND_LOG.String

803: ROLLBACK;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805:
806: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
807: FND_LOG.String
808: (
809: FND_LOG.LEVEL_ERROR,
810: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Class_Category',
811: SQLERRM

Line 809: FND_LOG.LEVEL_ERROR,

805:
806: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
807: FND_LOG.String
808: (
809: FND_LOG.LEVEL_ERROR,
810: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Class_Category',
811: SQLERRM
812: );
813: END IF;

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

831:
832: BEGIN
833: --DBMS_OUTPUT.put_line('Inside Update_Pc_Calendar....');
834:
835: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
836: FND_LOG.String
837: (
838: FND_LOG.LEVEL_PROCEDURE,
839: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Calendar.begin',

Line 836: FND_LOG.String

832: BEGIN
833: --DBMS_OUTPUT.put_line('Inside Update_Pc_Calendar....');
834:
835: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
836: FND_LOG.String
837: (
838: FND_LOG.LEVEL_PROCEDURE,
839: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Calendar.begin',
840: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Calendar'

Line 838: FND_LOG.LEVEL_PROCEDURE,

834:
835: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
836: FND_LOG.String
837: (
838: FND_LOG.LEVEL_PROCEDURE,
839: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Calendar.begin',
840: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Calendar'
841: );
842: END IF;

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

894: dbms_aw.execute('pc_funding_period_to_m = ''' || p_pc_info.funding_period_to || '''');
895:
896: dbms_aw.execute('pc_effective_period_to_m = ''' || p_pc_info.effective_period_to || '''');
897:
898: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
899: FND_LOG.String
900: (
901: FND_LOG.LEVEL_PROCEDURE,
902: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Calendar.end',

Line 899: FND_LOG.String

895:
896: dbms_aw.execute('pc_effective_period_to_m = ''' || p_pc_info.effective_period_to || '''');
897:
898: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
899: FND_LOG.String
900: (
901: FND_LOG.LEVEL_PROCEDURE,
902: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Calendar.end',
903: 'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Calendar'

Line 901: FND_LOG.LEVEL_PROCEDURE,

897:
898: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
899: FND_LOG.String
900: (
901: FND_LOG.LEVEL_PROCEDURE,
902: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Calendar.end',
903: 'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Calendar'
904: );
905: END IF;

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

908: WHEN OTHERS THEN
909: ROLLBACK;
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911:
912: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
913: FND_LOG.String
914: (
915: FND_LOG.LEVEL_ERROR,
916: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Calendar',

Line 913: FND_LOG.String

909: ROLLBACK;
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911:
912: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
913: FND_LOG.String
914: (
915: FND_LOG.LEVEL_ERROR,
916: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Calendar',
917: SQLERRM

Line 915: FND_LOG.LEVEL_ERROR,

911:
912: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
913: FND_LOG.String
914: (
915: FND_LOG.LEVEL_ERROR,
916: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Calendar',
917: SQLERRM
918: );
919: END IF;

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

937:
938: BEGIN
939: --DBMS_OUTPUT.put_line('Inside Update_Pc_Currency....');
940:
941: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
942: FND_LOG.String
943: (FND_LOG.LEVEL_PROCEDURE,
944: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency.begin',
945: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Currency'

Line 942: FND_LOG.String

938: BEGIN
939: --DBMS_OUTPUT.put_line('Inside Update_Pc_Currency....');
940:
941: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
942: FND_LOG.String
943: (FND_LOG.LEVEL_PROCEDURE,
944: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency.begin',
945: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Currency'
946: );

Line 943: (FND_LOG.LEVEL_PROCEDURE,

939: --DBMS_OUTPUT.put_line('Inside Update_Pc_Currency....');
940:
941: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
942: FND_LOG.String
943: (FND_LOG.LEVEL_PROCEDURE,
944: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency.begin',
945: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Currency'
946: );
947: END IF;

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

976: -- If conversion rate date is not null then set relation to that value
977: -- else set it to todays date.
978: if p_pc_info.conversion_rate_date is not null
979: then
980: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
981: FND_LOG.String
982: (FND_LOG.LEVEL_PROCEDURE,
983: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency',
984: 'Setting currency_date_pc_r to : ' || to_char(fnd_date.chardate_to_date(p_pc_info.conversion_rate_date), 'MMDDYYYY' || '''') || ' value.' -- Bug 9264707

Line 981: FND_LOG.String

977: -- else set it to todays date.
978: if p_pc_info.conversion_rate_date is not null
979: then
980: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
981: FND_LOG.String
982: (FND_LOG.LEVEL_PROCEDURE,
983: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency',
984: 'Setting currency_date_pc_r to : ' || to_char(fnd_date.chardate_to_date(p_pc_info.conversion_rate_date), 'MMDDYYYY' || '''') || ' value.' -- Bug 9264707
985: );

Line 982: (FND_LOG.LEVEL_PROCEDURE,

978: if p_pc_info.conversion_rate_date is not null
979: then
980: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
981: FND_LOG.String
982: (FND_LOG.LEVEL_PROCEDURE,
983: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency',
984: 'Setting currency_date_pc_r to : ' || to_char(fnd_date.chardate_to_date(p_pc_info.conversion_rate_date), 'MMDDYYYY' || '''') || ' value.' -- Bug 9264707
985: );
986: END IF;

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

994: /*dbms_aw.execute('currency_date_pc_r = '''
995: || to_char(to_date(p_pc_info.conversion_rate_date,
996: 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));*/
997: else
998: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
999: FND_LOG.String
1000: (FND_LOG.LEVEL_PROCEDURE,
1001: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency',
1002: 'Setting currency_date_pc_r to sysdate value.'||to_char(sysdate,'MMDDYYYY' || '''') -- Bug 9264707

Line 999: FND_LOG.String

995: || to_char(to_date(p_pc_info.conversion_rate_date,
996: 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));*/
997: else
998: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
999: FND_LOG.String
1000: (FND_LOG.LEVEL_PROCEDURE,
1001: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency',
1002: 'Setting currency_date_pc_r to sysdate value.'||to_char(sysdate,'MMDDYYYY' || '''') -- Bug 9264707
1003: );

Line 1000: (FND_LOG.LEVEL_PROCEDURE,

996: 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));*/
997: else
998: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
999: FND_LOG.String
1000: (FND_LOG.LEVEL_PROCEDURE,
1001: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency',
1002: 'Setting currency_date_pc_r to sysdate value.'||to_char(sysdate,'MMDDYYYY' || '''') -- Bug 9264707
1003: );
1004: END IF;

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

1013: || to_char(to_date(sysdate,
1014: 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));*/
1015: end if;
1016:
1017: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1018: FND_LOG.String
1019: (
1020: FND_LOG.LEVEL_PROCEDURE,
1021: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency.end',

Line 1018: FND_LOG.String

1014: 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));*/
1015: end if;
1016:
1017: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1018: FND_LOG.String
1019: (
1020: FND_LOG.LEVEL_PROCEDURE,
1021: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency.end',
1022: 'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Currency'

Line 1020: FND_LOG.LEVEL_PROCEDURE,

1016:
1017: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1018: FND_LOG.String
1019: (
1020: FND_LOG.LEVEL_PROCEDURE,
1021: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency.end',
1022: 'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Currency'
1023: );
1024: END IF;

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

1027: WHEN OTHERS THEN
1028: ROLLBACK;
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1030:
1031: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1032: FND_LOG.String
1033: (
1034: FND_LOG.LEVEL_ERROR,
1035: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency',

Line 1032: FND_LOG.String

1028: ROLLBACK;
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1030:
1031: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1032: FND_LOG.String
1033: (
1034: FND_LOG.LEVEL_ERROR,
1035: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency',
1036: SQLERRM

Line 1034: FND_LOG.LEVEL_ERROR,

1030:
1031: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1032: FND_LOG.String
1033: (
1034: FND_LOG.LEVEL_ERROR,
1035: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency',
1036: SQLERRM
1037: );
1038: END IF;

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

1057:
1058: BEGIN
1059: --DBMS_OUTPUT.put_line('Inside Update_Pc_Sub_Due_Date....');
1060:
1061: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1062: FND_LOG.String
1063: (
1064: FND_LOG.LEVEL_PROCEDURE,
1065: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date.begin',

Line 1062: FND_LOG.String

1058: BEGIN
1059: --DBMS_OUTPUT.put_line('Inside Update_Pc_Sub_Due_Date....');
1060:
1061: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1062: FND_LOG.String
1063: (
1064: FND_LOG.LEVEL_PROCEDURE,
1065: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date.begin',
1066: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date'

Line 1064: FND_LOG.LEVEL_PROCEDURE,

1060:
1061: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1062: FND_LOG.String
1063: (
1064: FND_LOG.LEVEL_PROCEDURE,
1065: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date.begin',
1066: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date'
1067: );
1068: END IF;

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

1098: /*dbms_aw.execute('pc_submission_due_date_r = '''
1099: || to_char(to_date(p_pc_info.submission_due_date,
1100: 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));*/
1101:
1102: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1103: FND_LOG.String
1104: (
1105: FND_LOG.LEVEL_PROCEDURE,
1106: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date.end',

Line 1103: FND_LOG.String

1099: || to_char(to_date(p_pc_info.submission_due_date,
1100: 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));*/
1101:
1102: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1103: FND_LOG.String
1104: (
1105: FND_LOG.LEVEL_PROCEDURE,
1106: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date.end',
1107: 'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date'

Line 1105: FND_LOG.LEVEL_PROCEDURE,

1101:
1102: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1103: FND_LOG.String
1104: (
1105: FND_LOG.LEVEL_PROCEDURE,
1106: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date.end',
1107: 'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date'
1108: );
1109: END IF;

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

1112: WHEN OTHERS THEN
1113: ROLLBACK;
1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1115:
1116: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1117: FND_LOG.String
1118: (
1119: FND_LOG.LEVEL_ERROR,
1120: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date',

Line 1117: FND_LOG.String

1113: ROLLBACK;
1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1115:
1116: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1117: FND_LOG.String
1118: (
1119: FND_LOG.LEVEL_ERROR,
1120: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date',
1121: SQLERRM

Line 1119: FND_LOG.LEVEL_ERROR,

1115:
1116: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1117: FND_LOG.String
1118: (
1119: FND_LOG.LEVEL_ERROR,
1120: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date',
1121: SQLERRM
1122: );
1123: END IF;

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

1147:
1148: BEGIN
1149: --DBMS_OUTPUT.put_line('Inside Update_Pc_Discount_funds....');
1150:
1151: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1152: FND_LOG.String
1153: (
1154: FND_LOG.LEVEL_PROCEDURE,
1155: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds.begin',

Line 1152: FND_LOG.String

1148: BEGIN
1149: --DBMS_OUTPUT.put_line('Inside Update_Pc_Discount_funds....');
1150:
1151: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1152: FND_LOG.String
1153: (
1154: FND_LOG.LEVEL_PROCEDURE,
1155: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds.begin',
1156: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds'

Line 1154: FND_LOG.LEVEL_PROCEDURE,

1150:
1151: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1152: FND_LOG.String
1153: (
1154: FND_LOG.LEVEL_PROCEDURE,
1155: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds.begin',
1156: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds'
1157: );
1158: END IF;

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

1184:
1185:
1186: --DBMS_OUTPUT.put_line('Outside IF p_disc_funds IS NOT NULL .... ');
1187:
1188: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1189: FND_LOG.String
1190: (
1191: FND_LOG.LEVEL_PROCEDURE,
1192: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds.end',

Line 1189: FND_LOG.String

1185:
1186: --DBMS_OUTPUT.put_line('Outside IF p_disc_funds IS NOT NULL .... ');
1187:
1188: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1189: FND_LOG.String
1190: (
1191: FND_LOG.LEVEL_PROCEDURE,
1192: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds.end',
1193: 'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds'

Line 1191: FND_LOG.LEVEL_PROCEDURE,

1187:
1188: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1189: FND_LOG.String
1190: (
1191: FND_LOG.LEVEL_PROCEDURE,
1192: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds.end',
1193: 'Exiting FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds'
1194: );
1195: END IF;

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

1198: WHEN OTHERS THEN
1199: ROLLBACK;
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1201:
1202: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1203: FND_LOG.String
1204: (
1205: FND_LOG.LEVEL_ERROR,
1206: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds',

Line 1203: FND_LOG.String

1199: ROLLBACK;
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1201:
1202: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1203: FND_LOG.String
1204: (
1205: FND_LOG.LEVEL_ERROR,
1206: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds',
1207: SQLERRM

Line 1205: FND_LOG.LEVEL_ERROR,

1201:
1202: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1203: FND_LOG.String
1204: (
1205: FND_LOG.LEVEL_ERROR,
1206: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds',
1207: SQLERRM
1208: );
1209: END IF;

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

1233: l_pcName_Count NUMBER;
1234:
1235: BEGIN
1236:
1237: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1238: FND_LOG.String
1239: (
1240: FND_LOG.LEVEL_PROCEDURE,
1241: 'fpa.sql.FPA_PlanningCycle_Pvt.Check_Pc_Name.begin',

Line 1238: FND_LOG.String

1234:
1235: BEGIN
1236:
1237: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1238: FND_LOG.String
1239: (
1240: FND_LOG.LEVEL_PROCEDURE,
1241: 'fpa.sql.FPA_PlanningCycle_Pvt.Check_Pc_Name.begin',
1242: 'Entering FPA_PlanningCycle_Pvt.Check_Pc_Name'

Line 1240: FND_LOG.LEVEL_PROCEDURE,

1236:
1237: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1238: FND_LOG.String
1239: (
1240: FND_LOG.LEVEL_PROCEDURE,
1241: 'fpa.sql.FPA_PlanningCycle_Pvt.Check_Pc_Name.begin',
1242: 'Entering FPA_PlanningCycle_Pvt.Check_Pc_Name'
1243: );
1244: END IF;

Line 1266: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN

1262: END IF;
1263:
1264: RETURN l_pcName_Count;
1265:
1266: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN
1267: FND_LOG.String
1268: (
1269: FND_LOG.LEVEL_PROCEDURE,
1270: 'fpa.sql.FPA_PlanningCycle_Pvt.Check_Pc_Name.end',

Line 1267: FND_LOG.String

1263:
1264: RETURN l_pcName_Count;
1265:
1266: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN
1267: FND_LOG.String
1268: (
1269: FND_LOG.LEVEL_PROCEDURE,
1270: 'fpa.sql.FPA_PlanningCycle_Pvt.Check_Pc_Name.end',
1271: 'Exiting FPA_PlanningCycle_Pvt.Check_Pc_Name'

Line 1269: FND_LOG.LEVEL_PROCEDURE,

1265:
1266: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN
1267: FND_LOG.String
1268: (
1269: FND_LOG.LEVEL_PROCEDURE,
1270: 'fpa.sql.FPA_PlanningCycle_Pvt.Check_Pc_Name.end',
1271: 'Exiting FPA_PlanningCycle_Pvt.Check_Pc_Name'
1272: );
1273: END IF;

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

1276: WHEN OTHERS THEN
1277: ROLLBACK;
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1279:
1280: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
1281: FND_LOG.String
1282: (
1283: FND_LOG.LEVEL_ERROR,
1284: 'fpa.sql.FPA_PlanningCycle_Pvt.Check_Pc_Name',

Line 1281: FND_LOG.String

1277: ROLLBACK;
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1279:
1280: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
1281: FND_LOG.String
1282: (
1283: FND_LOG.LEVEL_ERROR,
1284: 'fpa.sql.FPA_PlanningCycle_Pvt.Check_Pc_Name',
1285: SQLERRM

Line 1283: FND_LOG.LEVEL_ERROR,

1279:
1280: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
1281: FND_LOG.String
1282: (
1283: FND_LOG.LEVEL_ERROR,
1284: 'fpa.sql.FPA_PlanningCycle_Pvt.Check_Pc_Name',
1285: SQLERRM
1286: );
1287: END IF;

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

1307: IS
1308: l_list_id NUMBER;
1309: l_obj_name VARCHAR2(80);
1310: BEGIN
1311: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1312: FND_LOG.String
1313: (
1314: FND_LOG.LEVEL_PROCEDURE,
1315: 'fpa.sql.FPA_Process_Pvt.Pa_Distrb_Lists_Insert_Row.begin',

Line 1312: FND_LOG.String

1308: l_list_id NUMBER;
1309: l_obj_name VARCHAR2(80);
1310: BEGIN
1311: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1312: FND_LOG.String
1313: (
1314: FND_LOG.LEVEL_PROCEDURE,
1315: 'fpa.sql.FPA_Process_Pvt.Pa_Distrb_Lists_Insert_Row.begin',
1316: 'Entering FPA_Process_Pvt.Pa_Distrb_Lists_Insert_Row'

Line 1314: FND_LOG.LEVEL_PROCEDURE,

1310: BEGIN
1311: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1312: FND_LOG.String
1313: (
1314: FND_LOG.LEVEL_PROCEDURE,
1315: 'fpa.sql.FPA_Process_Pvt.Pa_Distrb_Lists_Insert_Row.begin',
1316: 'Entering FPA_Process_Pvt.Pa_Distrb_Lists_Insert_Row'
1317: );
1318: END IF;

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

1348: P_LAST_UPDATE_LOGIN => fnd_global.user_id
1349: );
1350:
1351:
1352: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1353: FND_LOG.String
1354: (
1355: FND_LOG.LEVEL_PROCEDURE,
1356: 'fpa.sql.FPA_Process_Pvt.Pa_Distrb_Lists_Insert_Row.end',

Line 1353: FND_LOG.String

1349: );
1350:
1351:
1352: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1353: FND_LOG.String
1354: (
1355: FND_LOG.LEVEL_PROCEDURE,
1356: 'fpa.sql.FPA_Process_Pvt.Pa_Distrb_Lists_Insert_Row.end',
1357: 'Exiting FPA_Process_Pvt.Pa_Distrb_Lists_Insert_Row'

Line 1355: FND_LOG.LEVEL_PROCEDURE,

1351:
1352: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1353: FND_LOG.String
1354: (
1355: FND_LOG.LEVEL_PROCEDURE,
1356: 'fpa.sql.FPA_Process_Pvt.Pa_Distrb_Lists_Insert_Row.end',
1357: 'Exiting FPA_Process_Pvt.Pa_Distrb_Lists_Insert_Row'
1358: );
1359: END IF;

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

1365: ROLLBACK;
1366:
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1368:
1369: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1370: FND_LOG.String
1371: (
1372: FND_LOG.LEVEL_ERROR,
1373: 'fpa.sql.FPA_Process_Pvt.Pa_Distrb_Lists_Insert_Row',

Line 1370: FND_LOG.String

1366:
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1368:
1369: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1370: FND_LOG.String
1371: (
1372: FND_LOG.LEVEL_ERROR,
1373: 'fpa.sql.FPA_Process_Pvt.Pa_Distrb_Lists_Insert_Row',
1374: SQLERRM

Line 1372: FND_LOG.LEVEL_ERROR,

1368:
1369: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1370: FND_LOG.String
1371: (
1372: FND_LOG.LEVEL_ERROR,
1373: 'fpa.sql.FPA_Process_Pvt.Pa_Distrb_Lists_Insert_Row',
1374: SQLERRM
1375: );
1376: END IF;

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

1394: IS
1395: l_list_item_id NUMBER;
1396: l_list_id NUMBER;
1397: BEGIN
1398: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1399: FND_LOG.String
1400: (
1401: FND_LOG.LEVEL_PROCEDURE,
1402: 'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row.begin',

Line 1399: FND_LOG.String

1395: l_list_item_id NUMBER;
1396: l_list_id NUMBER;
1397: BEGIN
1398: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1399: FND_LOG.String
1400: (
1401: FND_LOG.LEVEL_PROCEDURE,
1402: 'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row.begin',
1403: 'Entering FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row'

Line 1401: FND_LOG.LEVEL_PROCEDURE,

1397: BEGIN
1398: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1399: FND_LOG.String
1400: (
1401: FND_LOG.LEVEL_PROCEDURE,
1402: 'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row.begin',
1403: 'Entering FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row'
1404: );
1405: END IF;

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

1474: END LOOP;
1475:
1476: END IF;
1477:
1478: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1479: FND_LOG.String
1480: (
1481: FND_LOG.LEVEL_PROCEDURE,
1482: 'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row.end',

Line 1479: FND_LOG.String

1475:
1476: END IF;
1477:
1478: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1479: FND_LOG.String
1480: (
1481: FND_LOG.LEVEL_PROCEDURE,
1482: 'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row.end',
1483: 'Exiting FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row'

Line 1481: FND_LOG.LEVEL_PROCEDURE,

1477:
1478: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1479: FND_LOG.String
1480: (
1481: FND_LOG.LEVEL_PROCEDURE,
1482: 'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row.end',
1483: 'Exiting FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row'
1484: );
1485: END IF;

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

1491: ROLLBACK;
1492:
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1494:
1495: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1496: FND_LOG.String
1497: (
1498: FND_LOG.LEVEL_ERROR,
1499: 'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row',

Line 1496: FND_LOG.String

1492:
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1494:
1495: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1496: FND_LOG.String
1497: (
1498: FND_LOG.LEVEL_ERROR,
1499: 'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row',
1500: SQLERRM

Line 1498: FND_LOG.LEVEL_ERROR,

1494:
1495: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1496: FND_LOG.String
1497: (
1498: FND_LOG.LEVEL_ERROR,
1499: 'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row',
1500: SQLERRM
1501: );
1502: END IF;

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

1520: l_api_version CONSTANT NUMBER := 1.0;
1521:
1522: begin
1523:
1524: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1525: fnd_log.string
1526: (
1527: FND_LOG.LEVEL_PROCEDURE,
1528: 'fpa.sql.fpa_planningcycle_pvt.Set_Pc_Investment_Criteria.begin',

Line 1525: fnd_log.string

1521:
1522: begin
1523:
1524: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1525: fnd_log.string
1526: (
1527: FND_LOG.LEVEL_PROCEDURE,
1528: 'fpa.sql.fpa_planningcycle_pvt.Set_Pc_Investment_Criteria.begin',
1529: 'Entering fpa_planningcycle_pvt.Set_Pc_Investment_Criteria.'

Line 1527: FND_LOG.LEVEL_PROCEDURE,

1523:
1524: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1525: fnd_log.string
1526: (
1527: FND_LOG.LEVEL_PROCEDURE,
1528: 'fpa.sql.fpa_planningcycle_pvt.Set_Pc_Investment_Criteria.begin',
1529: 'Entering fpa_planningcycle_pvt.Set_Pc_Investment_Criteria.'
1530: );
1531: END IF;

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

1529: 'Entering fpa_planningcycle_pvt.Set_Pc_Investment_Criteria.'
1530: );
1531: END IF;
1532:
1533: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1534: fnd_log.string
1535: (
1536: FND_LOG.LEVEL_PROCEDURE,
1537: 'fpa.sql.fpa_planningcycle_pvt.Set_Pc_Investment_Criteria.begin',

Line 1534: fnd_log.string

1530: );
1531: END IF;
1532:
1533: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1534: fnd_log.string
1535: (
1536: FND_LOG.LEVEL_PROCEDURE,
1537: 'fpa.sql.fpa_planningcycle_pvt.Set_Pc_Investment_Criteria.begin',
1538: 'Calling AW Program SET_PC_INVEST_CRITERIA_PRG.'

Line 1536: FND_LOG.LEVEL_PROCEDURE,

1532:
1533: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1534: fnd_log.string
1535: (
1536: FND_LOG.LEVEL_PROCEDURE,
1537: 'fpa.sql.fpa_planningcycle_pvt.Set_Pc_Investment_Criteria.begin',
1538: 'Calling AW Program SET_PC_INVEST_CRITERIA_PRG.'
1539: );
1540: END IF;

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

1540: END IF;
1541:
1542: dbms_aw.execute('call SET_PC_INVEST_CRITERIA_PRG(' || p_pc_id || ')');
1543:
1544: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1545: fnd_log.string
1546: (
1547: FND_LOG.LEVEL_PROCEDURE,
1548: 'fpa.sql.fpa_planningcycle_pvt.Set_Pc_Investment_Criteria.end',

Line 1545: fnd_log.string

1541:
1542: dbms_aw.execute('call SET_PC_INVEST_CRITERIA_PRG(' || p_pc_id || ')');
1543:
1544: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1545: fnd_log.string
1546: (
1547: FND_LOG.LEVEL_PROCEDURE,
1548: 'fpa.sql.fpa_planningcycle_pvt.Set_Pc_Investment_Criteria.end',
1549: 'Entering fpa_planningcycle_pvt.Set_Pc_Investment_Criteria.'

Line 1547: FND_LOG.LEVEL_PROCEDURE,

1543:
1544: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1545: fnd_log.string
1546: (
1547: FND_LOG.LEVEL_PROCEDURE,
1548: 'fpa.sql.fpa_planningcycle_pvt.Set_Pc_Investment_Criteria.end',
1549: 'Entering fpa_planningcycle_pvt.Set_Pc_Investment_Criteria.'
1550: );
1551: END IF;

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

1553: EXCEPTION
1554: WHEN OTHERS THEN
1555: ROLLBACK;
1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1557: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1558: fnd_log.string
1559: (
1560: FND_LOG.LEVEL_ERROR,
1561: 'fpa.sql.fpa_planningcycle_pvt.Set_Pc_Investment_Criteria',

Line 1558: fnd_log.string

1554: WHEN OTHERS THEN
1555: ROLLBACK;
1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1557: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1558: fnd_log.string
1559: (
1560: FND_LOG.LEVEL_ERROR,
1561: 'fpa.sql.fpa_planningcycle_pvt.Set_Pc_Investment_Criteria',
1562: SQLERRM

Line 1560: FND_LOG.LEVEL_ERROR,

1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1557: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1558: fnd_log.string
1559: (
1560: FND_LOG.LEVEL_ERROR,
1561: 'fpa.sql.fpa_planningcycle_pvt.Set_Pc_Investment_Criteria',
1562: SQLERRM
1563: );
1564: END IF;

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

1582: l_api_version CONSTANT NUMBER := 1.0;
1583:
1584: begin
1585:
1586: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1587: FND_LOG.String
1588: (
1589: FND_LOG.LEVEL_PROCEDURE,
1590: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag.begin',

Line 1587: FND_LOG.String

1583:
1584: begin
1585:
1586: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1587: FND_LOG.String
1588: (
1589: FND_LOG.LEVEL_PROCEDURE,
1590: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag.begin',
1591: 'Entering FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag'

Line 1589: FND_LOG.LEVEL_PROCEDURE,

1585:
1586: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1587: FND_LOG.String
1588: (
1589: FND_LOG.LEVEL_PROCEDURE,
1590: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag.begin',
1591: 'Entering FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag'
1592: );
1593: END IF;

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

1591: 'Entering FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag'
1592: );
1593: END IF;
1594:
1595: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1596: FND_LOG.String
1597: (
1598: FND_LOG.LEVEL_PROCEDURE,
1599: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',

Line 1596: FND_LOG.String

1592: );
1593: END IF;
1594:
1595: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1596: FND_LOG.String
1597: (
1598: FND_LOG.LEVEL_PROCEDURE,
1599: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',
1600: 'Limiting to passed PC id'

Line 1598: FND_LOG.LEVEL_PROCEDURE,

1594:
1595: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1596: FND_LOG.String
1597: (
1598: FND_LOG.LEVEL_PROCEDURE,
1599: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',
1600: 'Limiting to passed PC id'
1601: );
1602: END IF;

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

1605: dbms_aw.execute('push portfolio_d');
1606: dbms_aw.execute('oknullstatus = y');
1607: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1608:
1609: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1610: FND_LOG.String
1611: (
1612: FND_LOG.LEVEL_PROCEDURE,
1613: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',

Line 1610: FND_LOG.String

1606: dbms_aw.execute('oknullstatus = y');
1607: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1608:
1609: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1610: FND_LOG.String
1611: (
1612: FND_LOG.LEVEL_PROCEDURE,
1613: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',
1614: 'Limiting to portfolio for passed PC id'

Line 1612: FND_LOG.LEVEL_PROCEDURE,

1608:
1609: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1610: FND_LOG.String
1611: (
1612: FND_LOG.LEVEL_PROCEDURE,
1613: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',
1614: 'Limiting to portfolio for passed PC id'
1615: );
1616: END IF;

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

1615: );
1616: END IF;
1617: dbms_aw.execute('limit portfolio_d to portfolio_pc_r');
1618:
1619: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1620: FND_LOG.String
1621: (
1622: FND_LOG.LEVEL_PROCEDURE,
1623: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',

Line 1620: FND_LOG.String

1616: END IF;
1617: dbms_aw.execute('limit portfolio_d to portfolio_pc_r');
1618:
1619: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1620: FND_LOG.String
1621: (
1622: FND_LOG.LEVEL_PROCEDURE,
1623: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',
1624: 'Limiting to planning cycles for the same portfolio'

Line 1622: FND_LOG.LEVEL_PROCEDURE,

1618:
1619: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1620: FND_LOG.String
1621: (
1622: FND_LOG.LEVEL_PROCEDURE,
1623: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',
1624: 'Limiting to planning cycles for the same portfolio'
1625: );
1626: END IF;

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

1625: );
1626: END IF;
1627: dbms_aw.execute('limit planning_cycle_d to portfolio_d');
1628:
1629: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1630: FND_LOG.String
1631: (
1632: FND_LOG.LEVEL_PROCEDURE,
1633: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',

Line 1630: FND_LOG.String

1626: END IF;
1627: dbms_aw.execute('limit planning_cycle_d to portfolio_d');
1628:
1629: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1630: FND_LOG.String
1631: (
1632: FND_LOG.LEVEL_PROCEDURE,
1633: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',
1634: 'Reset last approved flag'

Line 1632: FND_LOG.LEVEL_PROCEDURE,

1628:
1629: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1630: FND_LOG.String
1631: (
1632: FND_LOG.LEVEL_PROCEDURE,
1633: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',
1634: 'Reset last approved flag'
1635: );
1636: END IF;

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

1635: );
1636: END IF;
1637: dbms_aw.execute('pc_last_approved_flag_m = na');
1638:
1639: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1640: FND_LOG.String
1641: (
1642: FND_LOG.LEVEL_PROCEDURE,
1643: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',

Line 1640: FND_LOG.String

1636: END IF;
1637: dbms_aw.execute('pc_last_approved_flag_m = na');
1638:
1639: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1640: FND_LOG.String
1641: (
1642: FND_LOG.LEVEL_PROCEDURE,
1643: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',
1644: 'Setting last approved flag to passed pc ID'

Line 1642: FND_LOG.LEVEL_PROCEDURE,

1638:
1639: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1640: FND_LOG.String
1641: (
1642: FND_LOG.LEVEL_PROCEDURE,
1643: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag',
1644: 'Setting last approved flag to passed pc ID'
1645: );
1646: END IF;

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

1648: dbms_aw.execute('pc_last_approved_flag_m = yes');
1649: dbms_aw.execute('pop planning_cycle_d');
1650: dbms_aw.execute('pop portfolio_d');
1651:
1652: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1653: FND_LOG.String
1654: (
1655: FND_LOG.LEVEL_PROCEDURE,
1656: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag.end',

Line 1653: FND_LOG.String

1649: dbms_aw.execute('pop planning_cycle_d');
1650: dbms_aw.execute('pop portfolio_d');
1651:
1652: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1653: FND_LOG.String
1654: (
1655: FND_LOG.LEVEL_PROCEDURE,
1656: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag.end',
1657: 'Exiting fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag.end'

Line 1655: FND_LOG.LEVEL_PROCEDURE,

1651:
1652: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1653: FND_LOG.String
1654: (
1655: FND_LOG.LEVEL_PROCEDURE,
1656: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag.end',
1657: 'Exiting fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag.end'
1658: );
1659: END IF;

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

1661: EXCEPTION
1662: WHEN OTHERS THEN
1663: ROLLBACK;
1664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1665: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1666: fnd_log.string
1667: (
1668: FND_LOG.LEVEL_ERROR,
1669: 'fpa.sql.fpa_planningcycle_pvt.Set_Pc_Approved_Flag',

Line 1666: fnd_log.string

1662: WHEN OTHERS THEN
1663: ROLLBACK;
1664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1665: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1666: fnd_log.string
1667: (
1668: FND_LOG.LEVEL_ERROR,
1669: 'fpa.sql.fpa_planningcycle_pvt.Set_Pc_Approved_Flag',
1670: SQLERRM

Line 1668: FND_LOG.LEVEL_ERROR,

1664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1665: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1666: fnd_log.string
1667: (
1668: FND_LOG.LEVEL_ERROR,
1669: 'fpa.sql.fpa_planningcycle_pvt.Set_Pc_Approved_Flag',
1670: SQLERRM
1671: );
1672: END IF;

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

1690: l_api_version CONSTANT NUMBER := 1.0;
1691:
1692: begin
1693:
1694: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1695: FND_LOG.String
1696: (
1697: FND_LOG.LEVEL_PROCEDURE,
1698: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag.begin',

Line 1695: FND_LOG.String

1691:
1692: begin
1693:
1694: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1695: FND_LOG.String
1696: (
1697: FND_LOG.LEVEL_PROCEDURE,
1698: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag.begin',
1699: 'Entering FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag'

Line 1697: FND_LOG.LEVEL_PROCEDURE,

1693:
1694: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1695: FND_LOG.String
1696: (
1697: FND_LOG.LEVEL_PROCEDURE,
1698: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag.begin',
1699: 'Entering FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag'
1700: );
1701: END IF;

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

1699: 'Entering FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag'
1700: );
1701: END IF;
1702:
1703: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1704: FND_LOG.String
1705: (
1706: FND_LOG.LEVEL_PROCEDURE,
1707: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',

Line 1704: FND_LOG.String

1700: );
1701: END IF;
1702:
1703: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1704: FND_LOG.String
1705: (
1706: FND_LOG.LEVEL_PROCEDURE,
1707: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',
1708: 'Limiting to passed PC id'

Line 1706: FND_LOG.LEVEL_PROCEDURE,

1702:
1703: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1704: FND_LOG.String
1705: (
1706: FND_LOG.LEVEL_PROCEDURE,
1707: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',
1708: 'Limiting to passed PC id'
1709: );
1710: END IF;

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

1713: dbms_aw.execute('push portfolio_d');
1714: dbms_aw.execute('oknullstatus = y');
1715: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1716:
1717: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1718: FND_LOG.String
1719: (
1720: FND_LOG.LEVEL_PROCEDURE,
1721: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',

Line 1718: FND_LOG.String

1714: dbms_aw.execute('oknullstatus = y');
1715: dbms_aw.execute('limit planning_cycle_d to ' || p_pc_id);
1716:
1717: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1718: FND_LOG.String
1719: (
1720: FND_LOG.LEVEL_PROCEDURE,
1721: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',
1722: 'Limiting to portfolio for passed PC id'

Line 1720: FND_LOG.LEVEL_PROCEDURE,

1716:
1717: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1718: FND_LOG.String
1719: (
1720: FND_LOG.LEVEL_PROCEDURE,
1721: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',
1722: 'Limiting to portfolio for passed PC id'
1723: );
1724: END IF;

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

1723: );
1724: END IF;
1725: dbms_aw.execute('limit portfolio_d to portfolio_pc_r');
1726:
1727: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1728: FND_LOG.String
1729: (
1730: FND_LOG.LEVEL_PROCEDURE,
1731: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',

Line 1728: FND_LOG.String

1724: END IF;
1725: dbms_aw.execute('limit portfolio_d to portfolio_pc_r');
1726:
1727: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1728: FND_LOG.String
1729: (
1730: FND_LOG.LEVEL_PROCEDURE,
1731: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',
1732: 'Limiting to planning cycles for the same portfolio'

Line 1730: FND_LOG.LEVEL_PROCEDURE,

1726:
1727: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1728: FND_LOG.String
1729: (
1730: FND_LOG.LEVEL_PROCEDURE,
1731: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',
1732: 'Limiting to planning cycles for the same portfolio'
1733: );
1734: END IF;

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

1733: );
1734: END IF;
1735: dbms_aw.execute('limit planning_cycle_d to portfolio_d');
1736:
1737: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1738: FND_LOG.String
1739: (
1740: FND_LOG.LEVEL_PROCEDURE,
1741: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',

Line 1738: FND_LOG.String

1734: END IF;
1735: dbms_aw.execute('limit planning_cycle_d to portfolio_d');
1736:
1737: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1738: FND_LOG.String
1739: (
1740: FND_LOG.LEVEL_PROCEDURE,
1741: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',
1742: 'Reset last approved flag'

Line 1740: FND_LOG.LEVEL_PROCEDURE,

1736:
1737: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1738: FND_LOG.String
1739: (
1740: FND_LOG.LEVEL_PROCEDURE,
1741: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',
1742: 'Reset last approved flag'
1743: );
1744: END IF;

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

1743: );
1744: END IF;
1745: dbms_aw.execute('pc_last_flag_m = na');
1746:
1747: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1748: FND_LOG.String
1749: (
1750: FND_LOG.LEVEL_PROCEDURE,
1751: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',

Line 1748: FND_LOG.String

1744: END IF;
1745: dbms_aw.execute('pc_last_flag_m = na');
1746:
1747: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1748: FND_LOG.String
1749: (
1750: FND_LOG.LEVEL_PROCEDURE,
1751: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',
1752: 'Setting last approved flag to passed pc ID'

Line 1750: FND_LOG.LEVEL_PROCEDURE,

1746:
1747: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1748: FND_LOG.String
1749: (
1750: FND_LOG.LEVEL_PROCEDURE,
1751: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag',
1752: 'Setting last approved flag to passed pc ID'
1753: );
1754: END IF;

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

1756: dbms_aw.execute('pc_last_flag_m = yes');
1757: dbms_aw.execute('pop planning_cycle_d');
1758: dbms_aw.execute('pop portfolio_d');
1759:
1760: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1761: FND_LOG.String
1762: (
1763: FND_LOG.LEVEL_PROCEDURE,
1764: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag.end',

Line 1761: FND_LOG.String

1757: dbms_aw.execute('pop planning_cycle_d');
1758: dbms_aw.execute('pop portfolio_d');
1759:
1760: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1761: FND_LOG.String
1762: (
1763: FND_LOG.LEVEL_PROCEDURE,
1764: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag.end',
1765: 'Exiting fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag'

Line 1763: FND_LOG.LEVEL_PROCEDURE,

1759:
1760: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1761: FND_LOG.String
1762: (
1763: FND_LOG.LEVEL_PROCEDURE,
1764: 'fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag.end',
1765: 'Exiting fpa.sql.FPA_PlanningCycle_Pvt.Set_Pc_Last_Flag'
1766: );
1767: END IF;

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

1769: EXCEPTION
1770: WHEN OTHERS THEN
1771: ROLLBACK;
1772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1773: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1774: fnd_log.string
1775: (
1776: FND_LOG.LEVEL_ERROR,
1777: 'fpa.sql.fpa_planningcycle_pvt.Set_Pc_Approved_Flag',

Line 1774: fnd_log.string

1770: WHEN OTHERS THEN
1771: ROLLBACK;
1772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1773: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1774: fnd_log.string
1775: (
1776: FND_LOG.LEVEL_ERROR,
1777: 'fpa.sql.fpa_planningcycle_pvt.Set_Pc_Approved_Flag',
1778: SQLERRM

Line 1776: FND_LOG.LEVEL_ERROR,

1772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1773: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1774: fnd_log.string
1775: (
1776: FND_LOG.LEVEL_ERROR,
1777: 'fpa.sql.fpa_planningcycle_pvt.Set_Pc_Approved_Flag',
1778: SQLERRM
1779: );
1780: END IF;

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

1806: l_api_version CONSTANT NUMBER := 1.0;
1807:
1808: begin
1809:
1810: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1811: FND_LOG.String
1812: (FND_LOG.LEVEL_PROCEDURE,
1813: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.begin',
1814: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates');

Line 1811: FND_LOG.String

1807:
1808: begin
1809:
1810: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1811: FND_LOG.String
1812: (FND_LOG.LEVEL_PROCEDURE,
1813: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.begin',
1814: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates');
1815: END IF;

Line 1812: (FND_LOG.LEVEL_PROCEDURE,

1808: begin
1809:
1810: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1811: FND_LOG.String
1812: (FND_LOG.LEVEL_PROCEDURE,
1813: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.begin',
1814: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates');
1815: END IF;
1816:

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

1814: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates');
1815: END IF;
1816:
1817: IF l_api_version <> p_api_version THEN
1818: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1819: FND_LOG.STRING
1820: ( FND_LOG.LEVEL_PROCEDURE,
1821: 'FPA.SQL.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.',
1822: 'Checking API version.');

Line 1819: FND_LOG.STRING

1815: END IF;
1816:
1817: IF l_api_version <> p_api_version THEN
1818: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1819: FND_LOG.STRING
1820: ( FND_LOG.LEVEL_PROCEDURE,
1821: 'FPA.SQL.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.',
1822: 'Checking API version.');
1823: END IF;

Line 1820: ( FND_LOG.LEVEL_PROCEDURE,

1816:
1817: IF l_api_version <> p_api_version THEN
1818: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1819: FND_LOG.STRING
1820: ( FND_LOG.LEVEL_PROCEDURE,
1821: 'FPA.SQL.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.',
1822: 'Checking API version.');
1823: END IF;
1824: RAISE FND_API.G_EXC_ERROR;

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

1823: END IF;
1824: RAISE FND_API.G_EXC_ERROR;
1825: END IF;
1826:
1827: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1828: FND_LOG.String
1829: (FND_LOG.LEVEL_PROCEDURE,
1830: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.',
1831: 'Updating Annual discount rates for the PC in AW.');

Line 1828: FND_LOG.String

1824: RAISE FND_API.G_EXC_ERROR;
1825: END IF;
1826:
1827: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1828: FND_LOG.String
1829: (FND_LOG.LEVEL_PROCEDURE,
1830: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.',
1831: 'Updating Annual discount rates for the PC in AW.');
1832: END IF;

Line 1829: (FND_LOG.LEVEL_PROCEDURE,

1825: END IF;
1826:
1827: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1828: FND_LOG.String
1829: (FND_LOG.LEVEL_PROCEDURE,
1830: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.',
1831: 'Updating Annual discount rates for the PC in AW.');
1832: END IF;
1833:

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

1834: dbms_aw.execute('lmt planning_cycle_d to ' || p_pc_id);
1835: dbms_aw.execute('lmt time_d to ''' || p_period || '''');
1836: dbms_aw.execute('pc_discount_rate_t_m = ' || p_rate);
1837:
1838: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1839: FND_LOG.String
1840: (FND_LOG.LEVEL_PROCEDURE,
1841: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.',
1842: 'Done Updating Annual discount rates for the PC in AW.');

Line 1839: FND_LOG.String

1835: dbms_aw.execute('lmt time_d to ''' || p_period || '''');
1836: dbms_aw.execute('pc_discount_rate_t_m = ' || p_rate);
1837:
1838: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1839: FND_LOG.String
1840: (FND_LOG.LEVEL_PROCEDURE,
1841: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.',
1842: 'Done Updating Annual discount rates for the PC in AW.');
1843: END IF;

Line 1840: (FND_LOG.LEVEL_PROCEDURE,

1836: dbms_aw.execute('pc_discount_rate_t_m = ' || p_rate);
1837:
1838: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1839: FND_LOG.String
1840: (FND_LOG.LEVEL_PROCEDURE,
1841: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.',
1842: 'Done Updating Annual discount rates for the PC in AW.');
1843: END IF;
1844:

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

1841: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.',
1842: 'Done Updating Annual discount rates for the PC in AW.');
1843: END IF;
1844:
1845: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1846: FND_LOG.String
1847: (FND_LOG.LEVEL_PROCEDURE,
1848: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.end',
1849: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates');

Line 1846: FND_LOG.String

1842: 'Done Updating Annual discount rates for the PC in AW.');
1843: END IF;
1844:
1845: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1846: FND_LOG.String
1847: (FND_LOG.LEVEL_PROCEDURE,
1848: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.end',
1849: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates');
1850: END IF;

Line 1847: (FND_LOG.LEVEL_PROCEDURE,

1843: END IF;
1844:
1845: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1846: FND_LOG.String
1847: (FND_LOG.LEVEL_PROCEDURE,
1848: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates.end',
1849: 'Entering FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates');
1850: END IF;
1851:

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

1854: RAISE;
1855: WHEN OTHERS THEN
1856: ROLLBACK;
1857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1858: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1859: FND_LOG.String
1860: ( FND_LOG.LEVEL_ERROR,
1861: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates',
1862: SQLERRM);

Line 1859: FND_LOG.String

1855: WHEN OTHERS THEN
1856: ROLLBACK;
1857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1858: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1859: FND_LOG.String
1860: ( FND_LOG.LEVEL_ERROR,
1861: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates',
1862: SQLERRM);
1863: END IF;

Line 1860: ( FND_LOG.LEVEL_ERROR,

1856: ROLLBACK;
1857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1858: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1859: FND_LOG.String
1860: ( FND_LOG.LEVEL_ERROR,
1861: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Annual_Disc_Rates',
1862: SQLERRM);
1863: END IF;
1864: