DBA Data[Home] [Help]

APPS.BOM_CALC_CYNP dependencies on FND_MESSAGE

Line 616: fnd_message.set_name('BOM','BOM_MULT_JUNC_OP');

612:
613: --Close_Debug_session;
614: EXCEPTION
615: WHEN MULTIPLE_JUNCTION_OP THEN
616: fnd_message.set_name('BOM','BOM_MULT_JUNC_OP');
617: fnd_message.set_token('SEQ_NUM',to_char(token));
618: fnd_message.raise_error;
619: -- err_msg := fnd_message.get;
620: -- err_msg := 'Feeder subnetwork starting with operation sequence number '||to_char(token)||' joins another sub-network in more than one place. Please correct this and try again.';

Line 617: fnd_message.set_token('SEQ_NUM',to_char(token));

613: --Close_Debug_session;
614: EXCEPTION
615: WHEN MULTIPLE_JUNCTION_OP THEN
616: fnd_message.set_name('BOM','BOM_MULT_JUNC_OP');
617: fnd_message.set_token('SEQ_NUM',to_char(token));
618: fnd_message.raise_error;
619: -- err_msg := fnd_message.get;
620: -- err_msg := 'Feeder subnetwork starting with operation sequence number '||to_char(token)||' joins another sub-network in more than one place. Please correct this and try again.';
621: -- raise_application_error(-20001,err_msg,FALSE);

Line 618: fnd_message.raise_error;

614: EXCEPTION
615: WHEN MULTIPLE_JUNCTION_OP THEN
616: fnd_message.set_name('BOM','BOM_MULT_JUNC_OP');
617: fnd_message.set_token('SEQ_NUM',to_char(token));
618: fnd_message.raise_error;
619: -- err_msg := fnd_message.get;
620: -- err_msg := 'Feeder subnetwork starting with operation sequence number '||to_char(token)||' joins another sub-network in more than one place. Please correct this and try again.';
621: -- raise_application_error(-20001,err_msg,FALSE);
622: -- dbms_output.put_line('Feeder subnetwork starting with operation sequence number '||to_char(token)||' joins another sub-network in more than one place. Please correct this and try again.');

Line 619: -- err_msg := fnd_message.get;

615: WHEN MULTIPLE_JUNCTION_OP THEN
616: fnd_message.set_name('BOM','BOM_MULT_JUNC_OP');
617: fnd_message.set_token('SEQ_NUM',to_char(token));
618: fnd_message.raise_error;
619: -- err_msg := fnd_message.get;
620: -- err_msg := 'Feeder subnetwork starting with operation sequence number '||to_char(token)||' joins another sub-network in more than one place. Please correct this and try again.';
621: -- raise_application_error(-20001,err_msg,FALSE);
622: -- dbms_output.put_line('Feeder subnetwork starting with operation sequence number '||to_char(token)||' joins another sub-network in more than one place. Please correct this and try again.');
623: -- null;

Line 625: fnd_message.set_name('BOM','BOM_LOOP_FOUND');

621: -- raise_application_error(-20001,err_msg,FALSE);
622: -- dbms_output.put_line('Feeder subnetwork starting with operation sequence number '||to_char(token)||' joins another sub-network in more than one place. Please correct this and try again.');
623: -- null;
624: WHEN CYCLICAL_EXCEPTION THEN
625: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
626: fnd_message.set_token('SEQ_NUM',to_char(token));
627: fnd_message.raise_error;
628: -- err_msg := fnd_message.get;
629: -- raise_application_error(-20002,err_msg,FALSE);

Line 626: fnd_message.set_token('SEQ_NUM',to_char(token));

622: -- dbms_output.put_line('Feeder subnetwork starting with operation sequence number '||to_char(token)||' joins another sub-network in more than one place. Please correct this and try again.');
623: -- null;
624: WHEN CYCLICAL_EXCEPTION THEN
625: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
626: fnd_message.set_token('SEQ_NUM',to_char(token));
627: fnd_message.raise_error;
628: -- err_msg := fnd_message.get;
629: -- raise_application_error(-20002,err_msg,FALSE);
630: -- dbms_output.put_line('All primary and alternate paths should go forward. Path terminating in operation with operation sequence number '||to_char(token)||' traverses backward. Please correct this and try again.');

Line 627: fnd_message.raise_error;

623: -- null;
624: WHEN CYCLICAL_EXCEPTION THEN
625: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
626: fnd_message.set_token('SEQ_NUM',to_char(token));
627: fnd_message.raise_error;
628: -- err_msg := fnd_message.get;
629: -- raise_application_error(-20002,err_msg,FALSE);
630: -- dbms_output.put_line('All primary and alternate paths should go forward. Path terminating in operation with operation sequence number '||to_char(token)||' traverses backward. Please correct this and try again.');
631: -- null;

Line 628: -- err_msg := fnd_message.get;

624: WHEN CYCLICAL_EXCEPTION THEN
625: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
626: fnd_message.set_token('SEQ_NUM',to_char(token));
627: fnd_message.raise_error;
628: -- err_msg := fnd_message.get;
629: -- raise_application_error(-20002,err_msg,FALSE);
630: -- dbms_output.put_line('All primary and alternate paths should go forward. Path terminating in operation with operation sequence number '||to_char(token)||' traverses backward. Please correct this and try again.');
631: -- null;
632: WHEN REWORK_FORWARD THEN

Line 633: fnd_message.set_name('BOM','BOM_RWRK_LOOP_FOUND');

629: -- raise_application_error(-20002,err_msg,FALSE);
630: -- dbms_output.put_line('All primary and alternate paths should go forward. Path terminating in operation with operation sequence number '||to_char(token)||' traverses backward. Please correct this and try again.');
631: -- null;
632: WHEN REWORK_FORWARD THEN
633: fnd_message.set_name('BOM','BOM_RWRK_LOOP_FOUND');
634: fnd_message.set_token('SEQ_NUM',to_char(token));
635: fnd_message.raise_error;
636: -- err_msg := fnd_message.get;
637: -- raise_application_error(-20003,err_msg,FALSE);

Line 634: fnd_message.set_token('SEQ_NUM',to_char(token));

630: -- dbms_output.put_line('All primary and alternate paths should go forward. Path terminating in operation with operation sequence number '||to_char(token)||' traverses backward. Please correct this and try again.');
631: -- null;
632: WHEN REWORK_FORWARD THEN
633: fnd_message.set_name('BOM','BOM_RWRK_LOOP_FOUND');
634: fnd_message.set_token('SEQ_NUM',to_char(token));
635: fnd_message.raise_error;
636: -- err_msg := fnd_message.get;
637: -- raise_application_error(-20003,err_msg,FALSE);
638: -- dbms_output.put_line('Some reworks are going forward in sub-network starting with operation sequence number '||to_char(token)||'. Please correct this and try again.');

Line 635: fnd_message.raise_error;

631: -- null;
632: WHEN REWORK_FORWARD THEN
633: fnd_message.set_name('BOM','BOM_RWRK_LOOP_FOUND');
634: fnd_message.set_token('SEQ_NUM',to_char(token));
635: fnd_message.raise_error;
636: -- err_msg := fnd_message.get;
637: -- raise_application_error(-20003,err_msg,FALSE);
638: -- dbms_output.put_line('Some reworks are going forward in sub-network starting with operation sequence number '||to_char(token)||'. Please correct this and try again.');
639: -- null;

Line 636: -- err_msg := fnd_message.get;

632: WHEN REWORK_FORWARD THEN
633: fnd_message.set_name('BOM','BOM_RWRK_LOOP_FOUND');
634: fnd_message.set_token('SEQ_NUM',to_char(token));
635: fnd_message.raise_error;
636: -- err_msg := fnd_message.get;
637: -- raise_application_error(-20003,err_msg,FALSE);
638: -- dbms_output.put_line('Some reworks are going forward in sub-network starting with operation sequence number '||to_char(token)||'. Please correct this and try again.');
639: -- null;
640: WHEN NO_START_OP THEN

Line 641: fnd_message.set_name('BOM','BOM_NO_START_OP');

637: -- raise_application_error(-20003,err_msg,FALSE);
638: -- dbms_output.put_line('Some reworks are going forward in sub-network starting with operation sequence number '||to_char(token)||'. Please correct this and try again.');
639: -- null;
640: WHEN NO_START_OP THEN
641: fnd_message.set_name('BOM','BOM_NO_START_OP');
642: fnd_message.raise_error;
643: -- err_msg := fnd_message.get;
644: -- raise_application_error(-20004,err_msg,FALSE);
645: -- dbms_output.put_line('There is no start operation defined in the network');

Line 642: fnd_message.raise_error;

638: -- dbms_output.put_line('Some reworks are going forward in sub-network starting with operation sequence number '||to_char(token)||'. Please correct this and try again.');
639: -- null;
640: WHEN NO_START_OP THEN
641: fnd_message.set_name('BOM','BOM_NO_START_OP');
642: fnd_message.raise_error;
643: -- err_msg := fnd_message.get;
644: -- raise_application_error(-20004,err_msg,FALSE);
645: -- dbms_output.put_line('There is no start operation defined in the network');
646: -- null;

Line 643: -- err_msg := fnd_message.get;

639: -- null;
640: WHEN NO_START_OP THEN
641: fnd_message.set_name('BOM','BOM_NO_START_OP');
642: fnd_message.raise_error;
643: -- err_msg := fnd_message.get;
644: -- raise_application_error(-20004,err_msg,FALSE);
645: -- dbms_output.put_line('There is no start operation defined in the network');
646: -- null;
647: WHEN MULTIPLE_ENTRY_DUMMY THEN

Line 648: fnd_message.set_name('BOM','BOM_MULT_ENTRY_DUMMY');

644: -- raise_application_error(-20004,err_msg,FALSE);
645: -- dbms_output.put_line('There is no start operation defined in the network');
646: -- null;
647: WHEN MULTIPLE_ENTRY_DUMMY THEN
648: fnd_message.set_name('BOM','BOM_MULT_ENTRY_DUMMY');
649: fnd_message.set_token('SEQ_NUM',to_char(token));
650: fnd_message.raise_error;
651: -- err_msg := fnd_message.get;
652: -- raise_application_error(-20005,err_msg,FALSE);

Line 649: fnd_message.set_token('SEQ_NUM',to_char(token));

645: -- dbms_output.put_line('There is no start operation defined in the network');
646: -- null;
647: WHEN MULTIPLE_ENTRY_DUMMY THEN
648: fnd_message.set_name('BOM','BOM_MULT_ENTRY_DUMMY');
649: fnd_message.set_token('SEQ_NUM',to_char(token));
650: fnd_message.raise_error;
651: -- err_msg := fnd_message.get;
652: -- raise_application_error(-20005,err_msg,FALSE);
653: -- dbms_output.put_line('Two or more rework links are coming into the dummy operation with operation sequence number '||to_char(token)||'. Please correct this and try again.');

Line 650: fnd_message.raise_error;

646: -- null;
647: WHEN MULTIPLE_ENTRY_DUMMY THEN
648: fnd_message.set_name('BOM','BOM_MULT_ENTRY_DUMMY');
649: fnd_message.set_token('SEQ_NUM',to_char(token));
650: fnd_message.raise_error;
651: -- err_msg := fnd_message.get;
652: -- raise_application_error(-20005,err_msg,FALSE);
653: -- dbms_output.put_line('Two or more rework links are coming into the dummy operation with operation sequence number '||to_char(token)||'. Please correct this and try again.');
654: -- null;

Line 651: -- err_msg := fnd_message.get;

647: WHEN MULTIPLE_ENTRY_DUMMY THEN
648: fnd_message.set_name('BOM','BOM_MULT_ENTRY_DUMMY');
649: fnd_message.set_token('SEQ_NUM',to_char(token));
650: fnd_message.raise_error;
651: -- err_msg := fnd_message.get;
652: -- raise_application_error(-20005,err_msg,FALSE);
653: -- dbms_output.put_line('Two or more rework links are coming into the dummy operation with operation sequence number '||to_char(token)||'. Please correct this and try again.');
654: -- null;
655: WHEN NO_PRIMARY_LINK THEN

Line 656: fnd_message.set_name('BOM','BOM_NO_PRIMARY_LINK');

652: -- raise_application_error(-20005,err_msg,FALSE);
653: -- dbms_output.put_line('Two or more rework links are coming into the dummy operation with operation sequence number '||to_char(token)||'. Please correct this and try again.');
654: -- null;
655: WHEN NO_PRIMARY_LINK THEN
656: fnd_message.set_name('BOM','BOM_NO_PRIMARY_LINK');
657: fnd_message.set_token('SEQ_NUM',to_char(token));
658: fnd_message.raise_error;
659: -- err_msg := fnd_message.get;
660: -- raise_application_error(-20006,err_msg,FALSE);

Line 657: fnd_message.set_token('SEQ_NUM',to_char(token));

653: -- dbms_output.put_line('Two or more rework links are coming into the dummy operation with operation sequence number '||to_char(token)||'. Please correct this and try again.');
654: -- null;
655: WHEN NO_PRIMARY_LINK THEN
656: fnd_message.set_name('BOM','BOM_NO_PRIMARY_LINK');
657: fnd_message.set_token('SEQ_NUM',to_char(token));
658: fnd_message.raise_error;
659: -- err_msg := fnd_message.get;
660: -- raise_application_error(-20006,err_msg,FALSE);
661: -- dbms_output.put_line('The Operation '||to_char(token)||' must have a primary link going out of it, if it has alternate link going out of it. Please correct this and try again.');

Line 658: fnd_message.raise_error;

654: -- null;
655: WHEN NO_PRIMARY_LINK THEN
656: fnd_message.set_name('BOM','BOM_NO_PRIMARY_LINK');
657: fnd_message.set_token('SEQ_NUM',to_char(token));
658: fnd_message.raise_error;
659: -- err_msg := fnd_message.get;
660: -- raise_application_error(-20006,err_msg,FALSE);
661: -- dbms_output.put_line('The Operation '||to_char(token)||' must have a primary link going out of it, if it has alternate link going out of it. Please correct this and try again.');
662: -- null;

Line 659: -- err_msg := fnd_message.get;

655: WHEN NO_PRIMARY_LINK THEN
656: fnd_message.set_name('BOM','BOM_NO_PRIMARY_LINK');
657: fnd_message.set_token('SEQ_NUM',to_char(token));
658: fnd_message.raise_error;
659: -- err_msg := fnd_message.get;
660: -- raise_application_error(-20006,err_msg,FALSE);
661: -- dbms_output.put_line('The Operation '||to_char(token)||' must have a primary link going out of it, if it has alternate link going out of it. Please correct this and try again.');
662: -- null;
663: WHEN PLANNING_PCT_SUM_ERROR THEN

Line 664: fnd_message.set_name('BOM','BOM_PLANNING_PCT_SUM_ERROR');

660: -- raise_application_error(-20006,err_msg,FALSE);
661: -- dbms_output.put_line('The Operation '||to_char(token)||' must have a primary link going out of it, if it has alternate link going out of it. Please correct this and try again.');
662: -- null;
663: WHEN PLANNING_PCT_SUM_ERROR THEN
664: fnd_message.set_name('BOM','BOM_PLANNING_PCT_SUM_ERROR');
665: fnd_message.set_token('SEQ_NUM',to_char(token));
666: fnd_message.raise_error;
667: -- err_msg := fnd_message.get;
668: -- raise_application_error(-20009,err_msg,FALSE);

Line 665: fnd_message.set_token('SEQ_NUM',to_char(token));

661: -- dbms_output.put_line('The Operation '||to_char(token)||' must have a primary link going out of it, if it has alternate link going out of it. Please correct this and try again.');
662: -- null;
663: WHEN PLANNING_PCT_SUM_ERROR THEN
664: fnd_message.set_name('BOM','BOM_PLANNING_PCT_SUM_ERROR');
665: fnd_message.set_token('SEQ_NUM',to_char(token));
666: fnd_message.raise_error;
667: -- err_msg := fnd_message.get;
668: -- raise_application_error(-20009,err_msg,FALSE);
669: -- dbms_output.put_line('Sum of percentages of all out going primary and alternate links for operation '||to_char(token)||' must be 100. Please correct this and try again.');

Line 666: fnd_message.raise_error;

662: -- null;
663: WHEN PLANNING_PCT_SUM_ERROR THEN
664: fnd_message.set_name('BOM','BOM_PLANNING_PCT_SUM_ERROR');
665: fnd_message.set_token('SEQ_NUM',to_char(token));
666: fnd_message.raise_error;
667: -- err_msg := fnd_message.get;
668: -- raise_application_error(-20009,err_msg,FALSE);
669: -- dbms_output.put_line('Sum of percentages of all out going primary and alternate links for operation '||to_char(token)||' must be 100. Please correct this and try again.');
670: -- null;

Line 667: -- err_msg := fnd_message.get;

663: WHEN PLANNING_PCT_SUM_ERROR THEN
664: fnd_message.set_name('BOM','BOM_PLANNING_PCT_SUM_ERROR');
665: fnd_message.set_token('SEQ_NUM',to_char(token));
666: fnd_message.raise_error;
667: -- err_msg := fnd_message.get;
668: -- raise_application_error(-20009,err_msg,FALSE);
669: -- dbms_output.put_line('Sum of percentages of all out going primary and alternate links for operation '||to_char(token)||' must be 100. Please correct this and try again.');
670: -- null;
671: -- WHEN NO_DATA_FOUND THEN

Line 676: fnd_message.set_name('BOM','BOM_NO_RTG_NWK_DEF_ERROR');

672: -- raise_application_error(-06512,'No data found error');
673: -- dbms_output.put_line('----main no data found----');
674: -- NULL;
675: WHEN NO_NWK_DEFINED_ERROR THEN -- BUG 4348554
676: fnd_message.set_name('BOM','BOM_NO_RTG_NWK_DEF_ERROR');
677: fnd_message.raise_error;
678: WHEN OTHERS THEN
679: IF succ_start THEN
680: fnd_message.set_name('BOM','BOM_UNKNOWN_ERROR');

Line 677: fnd_message.raise_error;

673: -- dbms_output.put_line('----main no data found----');
674: -- NULL;
675: WHEN NO_NWK_DEFINED_ERROR THEN -- BUG 4348554
676: fnd_message.set_name('BOM','BOM_NO_RTG_NWK_DEF_ERROR');
677: fnd_message.raise_error;
678: WHEN OTHERS THEN
679: IF succ_start THEN
680: fnd_message.set_name('BOM','BOM_UNKNOWN_ERROR');
681: fnd_message.raise_error;

Line 680: fnd_message.set_name('BOM','BOM_UNKNOWN_ERROR');

676: fnd_message.set_name('BOM','BOM_NO_RTG_NWK_DEF_ERROR');
677: fnd_message.raise_error;
678: WHEN OTHERS THEN
679: IF succ_start THEN
680: fnd_message.set_name('BOM','BOM_UNKNOWN_ERROR');
681: fnd_message.raise_error;
682: ELSE
683: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
684: fnd_message.set_token('SEQ_NUM',to_char(start_tbl(start_tbl.COUNT).operation_seq_num));

Line 681: fnd_message.raise_error;

677: fnd_message.raise_error;
678: WHEN OTHERS THEN
679: IF succ_start THEN
680: fnd_message.set_name('BOM','BOM_UNKNOWN_ERROR');
681: fnd_message.raise_error;
682: ELSE
683: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
684: fnd_message.set_token('SEQ_NUM',to_char(start_tbl(start_tbl.COUNT).operation_seq_num));
685: fnd_message.raise_error;

Line 683: fnd_message.set_name('BOM','BOM_LOOP_FOUND');

679: IF succ_start THEN
680: fnd_message.set_name('BOM','BOM_UNKNOWN_ERROR');
681: fnd_message.raise_error;
682: ELSE
683: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
684: fnd_message.set_token('SEQ_NUM',to_char(start_tbl(start_tbl.COUNT).operation_seq_num));
685: fnd_message.raise_error;
686: END IF;
687: -- err_msg := fnd_message.get;

Line 684: fnd_message.set_token('SEQ_NUM',to_char(start_tbl(start_tbl.COUNT).operation_seq_num));

680: fnd_message.set_name('BOM','BOM_UNKNOWN_ERROR');
681: fnd_message.raise_error;
682: ELSE
683: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
684: fnd_message.set_token('SEQ_NUM',to_char(start_tbl(start_tbl.COUNT).operation_seq_num));
685: fnd_message.raise_error;
686: END IF;
687: -- err_msg := fnd_message.get;
688: -- raise_application_error(-20020,err_msg,FALSE);

Line 685: fnd_message.raise_error;

681: fnd_message.raise_error;
682: ELSE
683: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
684: fnd_message.set_token('SEQ_NUM',to_char(start_tbl(start_tbl.COUNT).operation_seq_num));
685: fnd_message.raise_error;
686: END IF;
687: -- err_msg := fnd_message.get;
688: -- raise_application_error(-20020,err_msg,FALSE);
689: -- dbms_output.put_line('An unidentified error has occurred in the planning percent calculations. Please contact Oracle Support.');

Line 687: -- err_msg := fnd_message.get;

683: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
684: fnd_message.set_token('SEQ_NUM',to_char(start_tbl(start_tbl.COUNT).operation_seq_num));
685: fnd_message.raise_error;
686: END IF;
687: -- err_msg := fnd_message.get;
688: -- raise_application_error(-20020,err_msg,FALSE);
689: -- dbms_output.put_line('An unidentified error has occurred in the planning percent calculations. Please contact Oracle Support.');
690: END calc_cynp;
691: