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.PJI_PA_DEL_MAIN dependencies on PA_DEBUG

Line 43: pa_debug.set_process('PLSQL');

39:
40: g_retcode := 0;
41: g_from_conc := 'Y';
42:
43: pa_debug.set_process('PLSQL');
44: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
45: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
46: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
47: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);

Line 44: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);

40: g_retcode := 0;
41: g_from_conc := 'Y';
42:
43: pa_debug.set_process('PLSQL');
44: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
45: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
46: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
47: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
48: pa_debug.log_message('Argument => Delete Financial Plans ['||p_fp_option||']', 1);

Line 45: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);

41: g_from_conc := 'Y';
42:
43: pa_debug.set_process('PLSQL');
44: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
45: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
46: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
47: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
48: pa_debug.log_message('Argument => Delete Financial Plans ['||p_fp_option||']', 1);
49: pa_debug.log_message('Argument => Financial Plan Type ['||p_plan_type||']', 1);

Line 46: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);

42:
43: pa_debug.set_process('PLSQL');
44: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
45: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
46: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
47: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
48: pa_debug.log_message('Argument => Delete Financial Plans ['||p_fp_option||']', 1);
49: pa_debug.log_message('Argument => Financial Plan Type ['||p_plan_type||']', 1);
50: pa_debug.log_message('Argument => Delete Workplans ['||p_wp_option||']', 1);

Line 47: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);

43: pa_debug.set_process('PLSQL');
44: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
45: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
46: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
47: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
48: pa_debug.log_message('Argument => Delete Financial Plans ['||p_fp_option||']', 1);
49: pa_debug.log_message('Argument => Financial Plan Type ['||p_plan_type||']', 1);
50: pa_debug.log_message('Argument => Delete Workplans ['||p_wp_option||']', 1);
51: pa_debug.log_message('Argument => Reporting Data Only ['||p_rep_only||']', 1);

Line 48: pa_debug.log_message('Argument => Delete Financial Plans ['||p_fp_option||']', 1);

44: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
45: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
46: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
47: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
48: pa_debug.log_message('Argument => Delete Financial Plans ['||p_fp_option||']', 1);
49: pa_debug.log_message('Argument => Financial Plan Type ['||p_plan_type||']', 1);
50: pa_debug.log_message('Argument => Delete Workplans ['||p_wp_option||']', 1);
51: pa_debug.log_message('Argument => Reporting Data Only ['||p_rep_only||']', 1);
52: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);

Line 49: pa_debug.log_message('Argument => Financial Plan Type ['||p_plan_type||']', 1);

45: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
46: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
47: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
48: pa_debug.log_message('Argument => Delete Financial Plans ['||p_fp_option||']', 1);
49: pa_debug.log_message('Argument => Financial Plan Type ['||p_plan_type||']', 1);
50: pa_debug.log_message('Argument => Delete Workplans ['||p_wp_option||']', 1);
51: pa_debug.log_message('Argument => Reporting Data Only ['||p_rep_only||']', 1);
52: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
53:

Line 50: pa_debug.log_message('Argument => Delete Workplans ['||p_wp_option||']', 1);

46: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
47: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
48: pa_debug.log_message('Argument => Delete Financial Plans ['||p_fp_option||']', 1);
49: pa_debug.log_message('Argument => Financial Plan Type ['||p_plan_type||']', 1);
50: pa_debug.log_message('Argument => Delete Workplans ['||p_wp_option||']', 1);
51: pa_debug.log_message('Argument => Reporting Data Only ['||p_rep_only||']', 1);
52: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
53:
54: /*Check for minimum imput parameters */

Line 51: pa_debug.log_message('Argument => Reporting Data Only ['||p_rep_only||']', 1);

47: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
48: pa_debug.log_message('Argument => Delete Financial Plans ['||p_fp_option||']', 1);
49: pa_debug.log_message('Argument => Financial Plan Type ['||p_plan_type||']', 1);
50: pa_debug.log_message('Argument => Delete Workplans ['||p_wp_option||']', 1);
51: pa_debug.log_message('Argument => Reporting Data Only ['||p_rep_only||']', 1);
52: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
53:
54: /*Check for minimum imput parameters */
55: if (p_operating_unit is null and p_from_project is null and p_to_project is null) then

Line 52: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);

48: pa_debug.log_message('Argument => Delete Financial Plans ['||p_fp_option||']', 1);
49: pa_debug.log_message('Argument => Financial Plan Type ['||p_plan_type||']', 1);
50: pa_debug.log_message('Argument => Delete Workplans ['||p_wp_option||']', 1);
51: pa_debug.log_message('Argument => Reporting Data Only ['||p_rep_only||']', 1);
52: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
53:
54: /*Check for minimum imput parameters */
55: if (p_operating_unit is null and p_from_project is null and p_to_project is null) then
56: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PARAMETER');

Line 94: pa_debug.log_message('Validated inputs :', 1);

90: else
91: l_rep_only := 'Y';
92: end if;
93:
94: pa_debug.log_message('Validated inputs :', 1);
95: pa_debug.log_message('From Project Num :'||l_from_project_num, 1);
96: pa_debug.log_message('To Project Num :'||l_to_project_num, 1);
97: pa_debug.log_message('Plan Type ID :'||l_plan_type_id, 1);
98: pa_debug.log_message('Reporting Only :'||l_rep_only, 1);

Line 95: pa_debug.log_message('From Project Num :'||l_from_project_num, 1);

91: l_rep_only := 'Y';
92: end if;
93:
94: pa_debug.log_message('Validated inputs :', 1);
95: pa_debug.log_message('From Project Num :'||l_from_project_num, 1);
96: pa_debug.log_message('To Project Num :'||l_to_project_num, 1);
97: pa_debug.log_message('Plan Type ID :'||l_plan_type_id, 1);
98: pa_debug.log_message('Reporting Only :'||l_rep_only, 1);
99:

Line 96: pa_debug.log_message('To Project Num :'||l_to_project_num, 1);

92: end if;
93:
94: pa_debug.log_message('Validated inputs :', 1);
95: pa_debug.log_message('From Project Num :'||l_from_project_num, 1);
96: pa_debug.log_message('To Project Num :'||l_to_project_num, 1);
97: pa_debug.log_message('Plan Type ID :'||l_plan_type_id, 1);
98: pa_debug.log_message('Reporting Only :'||l_rep_only, 1);
99:
100: g_wp_option := p_wp_option;

Line 97: pa_debug.log_message('Plan Type ID :'||l_plan_type_id, 1);

93:
94: pa_debug.log_message('Validated inputs :', 1);
95: pa_debug.log_message('From Project Num :'||l_from_project_num, 1);
96: pa_debug.log_message('To Project Num :'||l_to_project_num, 1);
97: pa_debug.log_message('Plan Type ID :'||l_plan_type_id, 1);
98: pa_debug.log_message('Reporting Only :'||l_rep_only, 1);
99:
100: g_wp_option := p_wp_option;
101: g_fp_option := p_fp_option;

Line 98: pa_debug.log_message('Reporting Only :'||l_rep_only, 1);

94: pa_debug.log_message('Validated inputs :', 1);
95: pa_debug.log_message('From Project Num :'||l_from_project_num, 1);
96: pa_debug.log_message('To Project Num :'||l_to_project_num, 1);
97: pa_debug.log_message('Plan Type ID :'||l_plan_type_id, 1);
98: pa_debug.log_message('Reporting Only :'||l_rep_only, 1);
99:
100: g_wp_option := p_wp_option;
101: g_fp_option := p_fp_option;
102:

Line 190: pa_debug.log_message('======= Print Output ========== :', 1);

186:
187: l_from_proj_num := p_from_project;
188: l_to_proj_num := p_to_project;
189:
190: pa_debug.log_message('======= Print Output ========== :', 1);
191: pa_debug.log_message('From Project Num :'||l_from_proj_num, 1);
192: pa_debug.log_message('To Project Num :'||l_from_proj_num, 1);
193:
194: FND_MESSAGE.SET_NAME('PA', 'PA_CISI_TEXT_DELETE');

Line 191: pa_debug.log_message('From Project Num :'||l_from_proj_num, 1);

187: l_from_proj_num := p_from_project;
188: l_to_proj_num := p_to_project;
189:
190: pa_debug.log_message('======= Print Output ========== :', 1);
191: pa_debug.log_message('From Project Num :'||l_from_proj_num, 1);
192: pa_debug.log_message('To Project Num :'||l_from_proj_num, 1);
193:
194: FND_MESSAGE.SET_NAME('PA', 'PA_CISI_TEXT_DELETE');
195: l_rpt_header := FND_MESSAGE.GET;

Line 192: pa_debug.log_message('To Project Num :'||l_from_proj_num, 1);

188: l_to_proj_num := p_to_project;
189:
190: pa_debug.log_message('======= Print Output ========== :', 1);
191: pa_debug.log_message('From Project Num :'||l_from_proj_num, 1);
192: pa_debug.log_message('To Project Num :'||l_from_proj_num, 1);
193:
194: FND_MESSAGE.SET_NAME('PA', 'PA_CISI_TEXT_DELETE');
195: l_rpt_header := FND_MESSAGE.GET;
196:

Line 274: pa_debug.log_message('======= Print Output End ========== :', 1);

270: END IF;
271: PJI_UTILS.WRITE2OUT(fnd_global.local_chr(10) ||
272: '----------------------------------------------------------'||l_rpt_footer||'----------------------------------------------------------');
273:
274: pa_debug.log_message('======= Print Output End ========== :', 1);
275:
276: end PRINT_OUTPUT;
277:
278: -- -----------------------------------------------------

Line 330: pa_debug.log_message('=======Delete Workplans Start =======', 1);

326: -- End Bug 13908783
327:
328: BEGIN
329:
330: pa_debug.log_message('=======Delete Workplans Start =======', 1);
331: pa_debug.log_message('Project ID :'||p_project_id, 1);
332: pa_debug.log_message('Reporting Only :'||p_rep_only, 1);
333:
334: l_project_id := p_project_id;

Line 331: pa_debug.log_message('Project ID :'||p_project_id, 1);

327:
328: BEGIN
329:
330: pa_debug.log_message('=======Delete Workplans Start =======', 1);
331: pa_debug.log_message('Project ID :'||p_project_id, 1);
332: pa_debug.log_message('Reporting Only :'||p_rep_only, 1);
333:
334: l_project_id := p_project_id;
335:

Line 332: pa_debug.log_message('Reporting Only :'||p_rep_only, 1);

328: BEGIN
329:
330: pa_debug.log_message('=======Delete Workplans Start =======', 1);
331: pa_debug.log_message('Project ID :'||p_project_id, 1);
332: pa_debug.log_message('Reporting Only :'||p_rep_only, 1);
333:
334: l_project_id := p_project_id;
335:
336: -- Delete only reporting data only

Line 338: pa_debug.log_message(' Delete only Reporting Data ', 1);

334: l_project_id := p_project_id;
335:
336: -- Delete only reporting data only
337: if p_rep_only = 'Y' then
338: pa_debug.log_message('** Delete only Reporting Data **', 1);
339:
340: for rec1 in c1 loop
341:
342: begin

Line 351: pa_debug.log_message('To Delete Plan Version id :'||l_budget_version_id, 1);

347: where project_id = l_project_id
348: and fin_plan_type_id = 10
349: and project_structure_version_id = rec1.element_version_id;
350:
351: pa_debug.log_message('To Delete Plan Version id :'||l_budget_version_id, 1);
352:
353: delete from pji_fp_xbs_accum_f
354: where project_id = l_project_id
355: and plan_type_id = 10

Line 358: pa_debug.log_message('Records deleted :'||sql%rowcount, 1);

354: where project_id = l_project_id
355: and plan_type_id = 10
356: and plan_version_id = l_budget_version_id;
357:
358: pa_debug.log_message('Records deleted :'||sql%rowcount, 1);
359:
360: exception
361: when no_data_found then
362: null;

Line 384: pa_debug.log_message('Calling Delete API for workplans', 1);

380: END LOOP;
381:
382: if l_structure_version_id_tbl.count >0 then
383: -- Calling DELETE_PUBLISHED_STRUCTURE_VER API
384: pa_debug.log_message('Calling Delete API for workplans', 1);
385: PA_PROJECT_STRUCTURE_PUB1.DELETE_PUBLISHED_STRUCTURE_VER
386: ( p_api_version => l_api_version_number
387: ,p_init_msg_list => l_init_msg_list
388: ,p_project_id => l_project_id

Line 404: pa_debug.Log_Message( p_message => l_msg_data, p_write_mode => 1, p_write_file => 'LOG');

400: p_count => l_msg_count,
401: p_data => l_msg_data
402: );
403: end if;
404: pa_debug.Log_Message( p_message => l_msg_data, p_write_mode => 1, p_write_file => 'LOG');
405: pa_debug.Log_Message( p_message => l_msg_data, p_write_mode => 1, p_write_file => 'OUT');
406: END IF;
407: -- End Bug 13908783
408:

Line 405: pa_debug.Log_Message( p_message => l_msg_data, p_write_mode => 1, p_write_file => 'OUT');

401: p_data => l_msg_data
402: );
403: end if;
404: pa_debug.Log_Message( p_message => l_msg_data, p_write_mode => 1, p_write_file => 'LOG');
405: pa_debug.Log_Message( p_message => l_msg_data, p_write_mode => 1, p_write_file => 'OUT');
406: END IF;
407: -- End Bug 13908783
408:
409: else

Line 410: pa_debug.log_message('No workplan versions found eligible for deleting', 1);

406: END IF;
407: -- End Bug 13908783
408:
409: else
410: pa_debug.log_message('No workplan versions found eligible for deleting', 1);
411: end if;
412:
413: end if; /* else of Delete only reporting data only */
414:

Line 415: pa_debug.log_message('Done deleting workplans', 1);

411: end if;
412:
413: end if; /* else of Delete only reporting data only */
414:
415: pa_debug.log_message('Done deleting workplans', 1);
416: pa_debug.log_message('Return status :'||l_return_status, 1);
417:
418: IF l_return_status <> 'S' THEN
419: raise API_ERROR;

Line 416: pa_debug.log_message('Return status :'||l_return_status, 1);

412:
413: end if; /* else of Delete only reporting data only */
414:
415: pa_debug.log_message('Done deleting workplans', 1);
416: pa_debug.log_message('Return status :'||l_return_status, 1);
417:
418: IF l_return_status <> 'S' THEN
419: raise API_ERROR;
420: END IF;

Line 423: pa_debug.log_message('=======Delete Workplans End =======', 1);

419: raise API_ERROR;
420: END IF;
421:
422: p_return_status := l_return_status;
423: pa_debug.log_message('=======Delete Workplans End =======', 1);
424:
425: EXCEPTION
426: WHEN NO_DATA_FOUND then
427: NULL;

Line 491: pa_debug.log_message('=======Delete Financial Plans Start =======', 1);

487: and nvl(purged_flag,'N') <> 'Y';
488:
489: BEGIN
490:
491: pa_debug.log_message('=======Delete Financial Plans Start =======', 1);
492: pa_debug.log_message('Project ID :'||p_project_id, 1);
493: pa_debug.log_message('Plan Type ID :'||p_plan_type_id, 1);
494:
495: l_project_id := p_project_id;

Line 492: pa_debug.log_message('Project ID :'||p_project_id, 1);

488:
489: BEGIN
490:
491: pa_debug.log_message('=======Delete Financial Plans Start =======', 1);
492: pa_debug.log_message('Project ID :'||p_project_id, 1);
493: pa_debug.log_message('Plan Type ID :'||p_plan_type_id, 1);
494:
495: l_project_id := p_project_id;
496: l_plan_type_id := p_plan_type_id;

Line 493: pa_debug.log_message('Plan Type ID :'||p_plan_type_id, 1);

489: BEGIN
490:
491: pa_debug.log_message('=======Delete Financial Plans Start =======', 1);
492: pa_debug.log_message('Project ID :'||p_project_id, 1);
493: pa_debug.log_message('Plan Type ID :'||p_plan_type_id, 1);
494:
495: l_project_id := p_project_id;
496: l_plan_type_id := p_plan_type_id;
497:

Line 500: pa_debug.log_message('Plan Type ID is passed', 1);

496: l_plan_type_id := p_plan_type_id;
497:
498: if (p_plan_type_id <> 0) then
499:
500: pa_debug.log_message('Plan Type ID is passed', 1);
501: FOR rec IN c2 LOOP
502:
503: if p_rep_only = 'Y' then
504: pa_debug.log_message('** Delete only Reporting Data **', 1);

Line 504: pa_debug.log_message(' Delete only Reporting Data ', 1);

500: pa_debug.log_message('Plan Type ID is passed', 1);
501: FOR rec IN c2 LOOP
502:
503: if p_rep_only = 'Y' then
504: pa_debug.log_message('** Delete only Reporting Data **', 1);
505:
506: begin
507: pa_debug.log_message('To Delete Plan Version id :'||rec.budget_version_id, 1);
508:

Line 507: pa_debug.log_message('To Delete Plan Version id :'||rec.budget_version_id, 1);

503: if p_rep_only = 'Y' then
504: pa_debug.log_message('** Delete only Reporting Data **', 1);
505:
506: begin
507: pa_debug.log_message('To Delete Plan Version id :'||rec.budget_version_id, 1);
508:
509: delete from pji_fp_xbs_accum_f
510: where project_id = l_project_id
511: and plan_version_id = rec.budget_version_id;

Line 513: pa_debug.log_message('Records deleted :'||sql%rowcount, 1);

509: delete from pji_fp_xbs_accum_f
510: where project_id = l_project_id
511: and plan_version_id = rec.budget_version_id;
512:
513: pa_debug.log_message('Records deleted :'||sql%rowcount, 1);
514:
515: exception
516: when no_data_found then
517: null;

Line 525: pa_debug.log_message('To Delete Plan Version id :'||rec.budget_version_id, 1);

521: raise_application_error(-20002, 'ORACLE error: '||sqlerrm);
522: end;
523:
524: else
525: pa_debug.log_message('To Delete Plan Version id :'||rec.budget_version_id, 1);
526: pa_fin_plan_pub.Delete_Version
527: (p_project_id => l_project_id,
528: p_budget_version_id => rec.budget_version_id,
529: p_record_version_number => rec.record_version_number,

Line 542: pa_debug.Log_Message( p_message => l_msg_data, p_write_mode => 1, p_write_file => 'LOG');

538: p_count => l_msg_count,
539: p_data => l_msg_data
540: );
541: end if;
542: pa_debug.Log_Message( p_message => l_msg_data, p_write_mode => 1, p_write_file => 'LOG');
543: pa_debug.Log_Message( p_message => l_msg_data, p_write_mode => 1, p_write_file => 'OUT');
544: END IF;
545: -- End Bug 13908783
546:

Line 543: pa_debug.Log_Message( p_message => l_msg_data, p_write_mode => 1, p_write_file => 'OUT');

539: p_data => l_msg_data
540: );
541: end if;
542: pa_debug.Log_Message( p_message => l_msg_data, p_write_mode => 1, p_write_file => 'LOG');
543: pa_debug.Log_Message( p_message => l_msg_data, p_write_mode => 1, p_write_file => 'OUT');
544: END IF;
545: -- End Bug 13908783
546:
547: end if;

Line 555: pa_debug.log_message('Done deleting Financial Plans', 1);

551: IF l_return_status <> 'S' THEN
552: raise API_ERROR;
553: END IF;
554:
555: pa_debug.log_message('Done deleting Financial Plans', 1);
556: pa_debug.log_message('Return status :'||l_return_status, 1);
557:
558: p_return_status := l_return_status;
559: pa_debug.log_message('=======Delete Financial Plans End =======', 1);

Line 556: pa_debug.log_message('Return status :'||l_return_status, 1);

552: raise API_ERROR;
553: END IF;
554:
555: pa_debug.log_message('Done deleting Financial Plans', 1);
556: pa_debug.log_message('Return status :'||l_return_status, 1);
557:
558: p_return_status := l_return_status;
559: pa_debug.log_message('=======Delete Financial Plans End =======', 1);
560:

Line 559: pa_debug.log_message('=======Delete Financial Plans End =======', 1);

555: pa_debug.log_message('Done deleting Financial Plans', 1);
556: pa_debug.log_message('Return status :'||l_return_status, 1);
557:
558: p_return_status := l_return_status;
559: pa_debug.log_message('=======Delete Financial Plans End =======', 1);
560:
561: else
562:
563: pa_debug.log_message('Plan Type ID is not passed', 1);

Line 563: pa_debug.log_message('Plan Type ID is not passed', 1);

559: pa_debug.log_message('=======Delete Financial Plans End =======', 1);
560:
561: else
562:
563: pa_debug.log_message('Plan Type ID is not passed', 1);
564: FOR rec IN c1 LOOP
565:
566: if p_rep_only = 'Y' then
567: pa_debug.log_message('** Delete only Reporting Data **', 1);

Line 567: pa_debug.log_message(' Delete only Reporting Data ', 1);

563: pa_debug.log_message('Plan Type ID is not passed', 1);
564: FOR rec IN c1 LOOP
565:
566: if p_rep_only = 'Y' then
567: pa_debug.log_message('** Delete only Reporting Data **', 1);
568:
569: begin
570: pa_debug.log_message('To Delete Plan Version id :'||rec.budget_version_id, 1);
571:

Line 570: pa_debug.log_message('To Delete Plan Version id :'||rec.budget_version_id, 1);

566: if p_rep_only = 'Y' then
567: pa_debug.log_message('** Delete only Reporting Data **', 1);
568:
569: begin
570: pa_debug.log_message('To Delete Plan Version id :'||rec.budget_version_id, 1);
571:
572: delete from pji_fp_xbs_accum_f
573: where project_id = l_project_id
574: and plan_version_id = rec.budget_version_id;

Line 576: pa_debug.log_message('Records deleted :'||sql%rowcount, 1);

572: delete from pji_fp_xbs_accum_f
573: where project_id = l_project_id
574: and plan_version_id = rec.budget_version_id;
575:
576: pa_debug.log_message('Records deleted :'||sql%rowcount, 1);
577:
578: exception
579: when no_data_found then
580: null;

Line 588: pa_debug.log_message('To Delete Plan Version id :'||rec.budget_version_id, 1);

584: raise_application_error(-20002, 'ORACLE error: '||sqlerrm);
585: end;
586:
587: else
588: pa_debug.log_message('To Delete Plan Version id :'||rec.budget_version_id, 1);
589: pa_fin_plan_pub.Delete_Version
590: (p_project_id => l_project_id,
591: p_budget_version_id => rec.budget_version_id,
592: p_record_version_number => rec.record_version_number,

Line 604: pa_debug.log_message('Done deleting Financial Plans', 1);

600: IF l_return_status <> 'S' THEN
601: raise API_ERROR;
602: END IF;
603:
604: pa_debug.log_message('Done deleting Financial Plans', 1);
605: pa_debug.log_message('Return status :'||l_return_status, 1);
606:
607: p_return_status := l_return_status;
608: pa_debug.log_message('=======Delete Financial Plans End =======', 1);

Line 605: pa_debug.log_message('Return status :'||l_return_status, 1);

601: raise API_ERROR;
602: END IF;
603:
604: pa_debug.log_message('Done deleting Financial Plans', 1);
605: pa_debug.log_message('Return status :'||l_return_status, 1);
606:
607: p_return_status := l_return_status;
608: pa_debug.log_message('=======Delete Financial Plans End =======', 1);
609:

Line 608: pa_debug.log_message('=======Delete Financial Plans End =======', 1);

604: pa_debug.log_message('Done deleting Financial Plans', 1);
605: pa_debug.log_message('Return status :'||l_return_status, 1);
606:
607: p_return_status := l_return_status;
608: pa_debug.log_message('=======Delete Financial Plans End =======', 1);
609:
610: end if;
611:
612: EXCEPTION