APPS.JTFB_DCF dependencies on JTFB_DCF

Line 1: PACKAGE BODY jtfb_dcf AS

1: PACKAGE BODY jtfb_dcf AS
2: /* $Header: jtfbdcfb.pls 115.23 2002/02/28 13:10:55 pkm ship $ */
3:
4: unexpected_error EXCEPTION;
5:

Line 399: -- dbms_output.put_line('Jtfb_Dcf.Copy.e_invalid_region_code: Please enter valid region codes');

395:
396: exception
397: when e_invalid_region_code then
398: null;
399: -- dbms_output.put_line('Jtfb_Dcf.Copy.e_invalid_region_code: Please enter valid region codes');
400: when others then
401: RAISE;
402: -- dbms_output.put_line('Jtfb_Dcf.Copy.Others: ' || sqlerrm);
403: end copy;

Line 402: -- dbms_output.put_line('Jtfb_Dcf.Copy.Others: ' || sqlerrm);

398: null;
399: -- dbms_output.put_line('Jtfb_Dcf.Copy.e_invalid_region_code: Please enter valid region codes');
400: when others then
401: RAISE;
402: -- dbms_output.put_line('Jtfb_Dcf.Copy.Others: ' || sqlerrm);
403: end copy;
404: --
405: --
406: procedure Lov_Upgrade is

Line 433: -- dbms_output.put_line('Jtfb_Dcf.Lov_Upgrade: Start ...');

429: l_upgraded boolean := false;
430:
431: begin
432:
433: -- dbms_output.put_line('Jtfb_Dcf.Lov_Upgrade: Start ...');
434: savepoint Lov_Upgrade;
435:
436: for rec in c_region_items
437: loop

Line 462: -- dbms_output.put_line('Jtfb_Dcf.Lov_Upgrade: End.');

458: l_upgraded := true;
459:
460: end loop;
461:
462: -- dbms_output.put_line('Jtfb_Dcf.Lov_Upgrade: End.');
463:
464: if (l_upgraded)
465: then
466: -- dbms_output.put_line('Lov_Upgrade completed successfully.');

Line 478: -- dbms_output.put_line('Jtfb_Dcf.Lov_Upgrade.Others: ' || sqlerrm);

474: end if;
475:
476: exception
477: when others then
478: -- dbms_output.put_line('Jtfb_Dcf.Lov_Upgrade.Others: ' || sqlerrm);
479: rollback to Lov_Upgrade;
480: raise unexpected_error;
481: end Lov_Upgrade;
482: --

Line 520: -- dbms_output.put_line('Jtfb_Dcf.Graph_Upgrade: Start ...');

516: l_upgraded boolean := false;
517:
518: begin
519:
520: -- dbms_output.put_line('Jtfb_Dcf.Graph_Upgrade: Start ...');
521:
522: savepoint Graph_Upgrade;
523:
524: for rec in cur_region_items

Line 548: -- dbms_output.put_line('Jtfb_Dcf.Graph_Upgrade: End.');

544: l_upgraded := true;
545:
546: end loop;
547:
548: -- dbms_output.put_line('Jtfb_Dcf.Graph_Upgrade: End.');
549:
550: if (l_upgraded)
551: then
552: -- dbms_output.put_line('Graph_Upgrade completed successfully.');

Line 568: -- dbms_output.put_line('Jtfb_Dcf.Graph_Upgrade.e_cur_sequence: ' ||

564: if (cur_sequence%isopen)
565: then
566: close cur_sequence;
567: end if;
568: -- dbms_output.put_line('Jtfb_Dcf.Graph_Upgrade.e_cur_sequence: ' ||
569: -- 'Unable to get next Sequence');
570: rollback to Graph_Upgrade;
571: raise unexpected_error;
572:

Line 578: -- dbms_output.put_line('Jtfb_Dcf.Graph_Upgrade.Others: ' || sqlerrm);

574: if (cur_sequence%isopen)
575: then
576: close cur_sequence;
577: end if;
578: -- dbms_output.put_line('Jtfb_Dcf.Graph_Upgrade.Others: ' || sqlerrm);
579: rollback to Graph_Upgrade;
580: raise unexpected_error;
581: end Graph_Upgrade;
582: --

Line 620: -- dbms_output.put_line('Jtfb_Dcf.Multiselect_Upgrade: Start ...');

616: for update nowait;
617:
618: begin
619:
620: -- dbms_output.put_line('Jtfb_Dcf.Multiselect_Upgrade: Start ...');
621:
622: savepoint Multiselect_Upgrade;
623:
624: for rit_rec in cur_region_items

Line 642: -- dbms_output.put_line('Jtfb_Dcf.Multiselect_Upgrade: End.');

638: where rowid = att_rec.rowid;
639: l_upgraded := true;
640: end loop;
641:
642: -- dbms_output.put_line('Jtfb_Dcf.Multiselect_Upgrade: End.');
643:
644: if (l_upgraded)
645: then
646: -- dbms_output.put_line('Multiselect_Upgrade completed successfully.');

Line 658: -- dbms_output.put_line('Jtfb_Dcf.Multiselect_Upgrade.Others: ' || sqlerrm);

654: end if;
655:
656: exception
657: when others then
658: -- dbms_output.put_line('Jtfb_Dcf.Multiselect_Upgrade.Others: ' || sqlerrm);
659: rollback to Multiselect_Upgrade;
660: raise unexpected_error;
661: end Multiselect_Upgrade;
662: --

Line 817: end jtfb_dcf;

813: raise unexpected_error;
814: end Audit_Columns_Patch;
815: --
816: --
817: end jtfb_dcf;