DBA Data[Home] [Help]

APPS.BOM_CALC_CYNP dependencies on FND_MESSAGE

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

583: OPEN check_nwk_exists_cur( p_routing_sequence_id );
584: FETCH check_nwk_exists_cur INTO l_chk_new_exists;
585: IF check_nwk_exists_cur%notfound THEN
586: --changes for bug 9869949 begin
587: fnd_message.set_name('BOM','BOM_NO_RTG_NWK_DEF_ERROR');
588: l_message_buffer := fnd_message.get;
589: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Warning: ' || l_message_buffer);
590: return;
591: --RAISE NO_NWK_DEFINED_ERROR;

Line 588: l_message_buffer := fnd_message.get;

584: FETCH check_nwk_exists_cur INTO l_chk_new_exists;
585: IF check_nwk_exists_cur%notfound THEN
586: --changes for bug 9869949 begin
587: fnd_message.set_name('BOM','BOM_NO_RTG_NWK_DEF_ERROR');
588: l_message_buffer := fnd_message.get;
589: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Warning: ' || l_message_buffer);
590: return;
591: --RAISE NO_NWK_DEFINED_ERROR;
592: --changes for bug 9869949 end

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

643:
644: --Close_Debug_session;
645: EXCEPTION
646: WHEN MULTIPLE_JUNCTION_OP THEN
647: fnd_message.set_name('BOM','BOM_MULT_JUNC_OP');
648: fnd_message.set_token('SEQ_NUM',to_char(token));
649: fnd_message.raise_error;
650: -- err_msg := fnd_message.get;
651: -- 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 648: fnd_message.set_token('SEQ_NUM',to_char(token));

644: --Close_Debug_session;
645: EXCEPTION
646: WHEN MULTIPLE_JUNCTION_OP THEN
647: fnd_message.set_name('BOM','BOM_MULT_JUNC_OP');
648: fnd_message.set_token('SEQ_NUM',to_char(token));
649: fnd_message.raise_error;
650: -- err_msg := fnd_message.get;
651: -- 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.';
652: -- raise_application_error(-20001,err_msg,FALSE);

Line 649: fnd_message.raise_error;

645: EXCEPTION
646: WHEN MULTIPLE_JUNCTION_OP THEN
647: fnd_message.set_name('BOM','BOM_MULT_JUNC_OP');
648: fnd_message.set_token('SEQ_NUM',to_char(token));
649: fnd_message.raise_error;
650: -- err_msg := fnd_message.get;
651: -- 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.';
652: -- raise_application_error(-20001,err_msg,FALSE);
653: -- 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 650: -- err_msg := fnd_message.get;

646: WHEN MULTIPLE_JUNCTION_OP THEN
647: fnd_message.set_name('BOM','BOM_MULT_JUNC_OP');
648: fnd_message.set_token('SEQ_NUM',to_char(token));
649: fnd_message.raise_error;
650: -- err_msg := fnd_message.get;
651: -- 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.';
652: -- raise_application_error(-20001,err_msg,FALSE);
653: -- 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.');
654: -- null;

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

652: -- raise_application_error(-20001,err_msg,FALSE);
653: -- 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.');
654: -- null;
655: WHEN CYCLICAL_EXCEPTION THEN
656: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
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(-20002,err_msg,FALSE);

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

653: -- 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.');
654: -- null;
655: WHEN CYCLICAL_EXCEPTION THEN
656: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
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(-20002,err_msg,FALSE);
661: -- 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 658: fnd_message.raise_error;

654: -- null;
655: WHEN CYCLICAL_EXCEPTION THEN
656: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
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(-20002,err_msg,FALSE);
661: -- 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.');
662: -- null;

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

655: WHEN CYCLICAL_EXCEPTION THEN
656: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
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(-20002,err_msg,FALSE);
661: -- 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.');
662: -- null;
663: WHEN REWORK_FORWARD THEN

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

660: -- raise_application_error(-20002,err_msg,FALSE);
661: -- 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.');
662: -- null;
663: WHEN REWORK_FORWARD THEN
664: fnd_message.set_name('BOM','BOM_RWRK_LOOP_FOUND');
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(-20003,err_msg,FALSE);

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

661: -- 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.');
662: -- null;
663: WHEN REWORK_FORWARD THEN
664: fnd_message.set_name('BOM','BOM_RWRK_LOOP_FOUND');
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(-20003,err_msg,FALSE);
669: -- 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 666: fnd_message.raise_error;

662: -- null;
663: WHEN REWORK_FORWARD THEN
664: fnd_message.set_name('BOM','BOM_RWRK_LOOP_FOUND');
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(-20003,err_msg,FALSE);
669: -- 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.');
670: -- null;

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

663: WHEN REWORK_FORWARD THEN
664: fnd_message.set_name('BOM','BOM_RWRK_LOOP_FOUND');
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(-20003,err_msg,FALSE);
669: -- 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.');
670: -- null;
671: WHEN NO_START_OP THEN

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

668: -- raise_application_error(-20003,err_msg,FALSE);
669: -- 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.');
670: -- null;
671: WHEN NO_START_OP THEN
672: fnd_message.set_name('BOM','BOM_NO_START_OP');
673: fnd_message.raise_error;
674: -- err_msg := fnd_message.get;
675: -- raise_application_error(-20004,err_msg,FALSE);
676: -- dbms_output.put_line('There is no start operation defined in the network');

Line 673: fnd_message.raise_error;

669: -- 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.');
670: -- null;
671: WHEN NO_START_OP THEN
672: fnd_message.set_name('BOM','BOM_NO_START_OP');
673: fnd_message.raise_error;
674: -- err_msg := fnd_message.get;
675: -- raise_application_error(-20004,err_msg,FALSE);
676: -- dbms_output.put_line('There is no start operation defined in the network');
677: -- null;

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

670: -- null;
671: WHEN NO_START_OP THEN
672: fnd_message.set_name('BOM','BOM_NO_START_OP');
673: fnd_message.raise_error;
674: -- err_msg := fnd_message.get;
675: -- raise_application_error(-20004,err_msg,FALSE);
676: -- dbms_output.put_line('There is no start operation defined in the network');
677: -- null;
678: WHEN MULTIPLE_ENTRY_DUMMY THEN

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

675: -- raise_application_error(-20004,err_msg,FALSE);
676: -- dbms_output.put_line('There is no start operation defined in the network');
677: -- null;
678: WHEN MULTIPLE_ENTRY_DUMMY THEN
679: fnd_message.set_name('BOM','BOM_MULT_ENTRY_DUMMY');
680: fnd_message.set_token('SEQ_NUM',to_char(token));
681: fnd_message.raise_error;
682: -- err_msg := fnd_message.get;
683: -- raise_application_error(-20005,err_msg,FALSE);

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

676: -- dbms_output.put_line('There is no start operation defined in the network');
677: -- null;
678: WHEN MULTIPLE_ENTRY_DUMMY THEN
679: fnd_message.set_name('BOM','BOM_MULT_ENTRY_DUMMY');
680: fnd_message.set_token('SEQ_NUM',to_char(token));
681: fnd_message.raise_error;
682: -- err_msg := fnd_message.get;
683: -- raise_application_error(-20005,err_msg,FALSE);
684: -- 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 681: fnd_message.raise_error;

677: -- null;
678: WHEN MULTIPLE_ENTRY_DUMMY THEN
679: fnd_message.set_name('BOM','BOM_MULT_ENTRY_DUMMY');
680: fnd_message.set_token('SEQ_NUM',to_char(token));
681: fnd_message.raise_error;
682: -- err_msg := fnd_message.get;
683: -- raise_application_error(-20005,err_msg,FALSE);
684: -- 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.');
685: -- null;

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

678: WHEN MULTIPLE_ENTRY_DUMMY THEN
679: fnd_message.set_name('BOM','BOM_MULT_ENTRY_DUMMY');
680: fnd_message.set_token('SEQ_NUM',to_char(token));
681: fnd_message.raise_error;
682: -- err_msg := fnd_message.get;
683: -- raise_application_error(-20005,err_msg,FALSE);
684: -- 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.');
685: -- null;
686: WHEN NO_PRIMARY_LINK THEN

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

683: -- raise_application_error(-20005,err_msg,FALSE);
684: -- 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.');
685: -- null;
686: WHEN NO_PRIMARY_LINK THEN
687: fnd_message.set_name('BOM','BOM_NO_PRIMARY_LINK');
688: fnd_message.set_token('SEQ_NUM',to_char(token));
689: fnd_message.raise_error;
690: -- err_msg := fnd_message.get;
691: -- raise_application_error(-20006,err_msg,FALSE);

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

684: -- 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.');
685: -- null;
686: WHEN NO_PRIMARY_LINK THEN
687: fnd_message.set_name('BOM','BOM_NO_PRIMARY_LINK');
688: fnd_message.set_token('SEQ_NUM',to_char(token));
689: fnd_message.raise_error;
690: -- err_msg := fnd_message.get;
691: -- raise_application_error(-20006,err_msg,FALSE);
692: -- 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 689: fnd_message.raise_error;

685: -- null;
686: WHEN NO_PRIMARY_LINK THEN
687: fnd_message.set_name('BOM','BOM_NO_PRIMARY_LINK');
688: fnd_message.set_token('SEQ_NUM',to_char(token));
689: fnd_message.raise_error;
690: -- err_msg := fnd_message.get;
691: -- raise_application_error(-20006,err_msg,FALSE);
692: -- 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.');
693: -- null;

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

686: WHEN NO_PRIMARY_LINK THEN
687: fnd_message.set_name('BOM','BOM_NO_PRIMARY_LINK');
688: fnd_message.set_token('SEQ_NUM',to_char(token));
689: fnd_message.raise_error;
690: -- err_msg := fnd_message.get;
691: -- raise_application_error(-20006,err_msg,FALSE);
692: -- 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.');
693: -- null;
694: WHEN PLANNING_PCT_SUM_ERROR THEN

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

691: -- raise_application_error(-20006,err_msg,FALSE);
692: -- 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.');
693: -- null;
694: WHEN PLANNING_PCT_SUM_ERROR THEN
695: fnd_message.set_name('BOM','BOM_PLANNING_PCT_SUM_ERROR');
696: fnd_message.set_token('SEQ_NUM',to_char(token));
697: fnd_message.raise_error;
698: -- err_msg := fnd_message.get;
699: -- raise_application_error(-20009,err_msg,FALSE);

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

692: -- 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.');
693: -- null;
694: WHEN PLANNING_PCT_SUM_ERROR THEN
695: fnd_message.set_name('BOM','BOM_PLANNING_PCT_SUM_ERROR');
696: fnd_message.set_token('SEQ_NUM',to_char(token));
697: fnd_message.raise_error;
698: -- err_msg := fnd_message.get;
699: -- raise_application_error(-20009,err_msg,FALSE);
700: -- 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 697: fnd_message.raise_error;

693: -- null;
694: WHEN PLANNING_PCT_SUM_ERROR THEN
695: fnd_message.set_name('BOM','BOM_PLANNING_PCT_SUM_ERROR');
696: fnd_message.set_token('SEQ_NUM',to_char(token));
697: fnd_message.raise_error;
698: -- err_msg := fnd_message.get;
699: -- raise_application_error(-20009,err_msg,FALSE);
700: -- 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.');
701: -- null;

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

694: WHEN PLANNING_PCT_SUM_ERROR THEN
695: fnd_message.set_name('BOM','BOM_PLANNING_PCT_SUM_ERROR');
696: fnd_message.set_token('SEQ_NUM',to_char(token));
697: fnd_message.raise_error;
698: -- err_msg := fnd_message.get;
699: -- raise_application_error(-20009,err_msg,FALSE);
700: -- 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.');
701: -- null;
702: -- WHEN NO_DATA_FOUND THEN

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

706: --commented out the following exception for bug 9869949
707: --We'll only print a warning in program log file such that
708: --yields for items with network routing defined are calculated
709: /*WHEN NO_NWK_DEFINED_ERROR THEN -- BUG 4348554
710: fnd_message.set_name('BOM','BOM_NO_RTG_NWK_DEF_ERROR');
711: fnd_message.raise_error;*/
712: WHEN OTHERS THEN
713: IF succ_start THEN
714: fnd_message.set_name('BOM','BOM_UNKNOWN_ERROR');

Line 711: fnd_message.raise_error;*/

707: --We'll only print a warning in program log file such that
708: --yields for items with network routing defined are calculated
709: /*WHEN NO_NWK_DEFINED_ERROR THEN -- BUG 4348554
710: fnd_message.set_name('BOM','BOM_NO_RTG_NWK_DEF_ERROR');
711: fnd_message.raise_error;*/
712: WHEN OTHERS THEN
713: IF succ_start THEN
714: fnd_message.set_name('BOM','BOM_UNKNOWN_ERROR');
715: fnd_message.raise_error;

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

710: fnd_message.set_name('BOM','BOM_NO_RTG_NWK_DEF_ERROR');
711: fnd_message.raise_error;*/
712: WHEN OTHERS THEN
713: IF succ_start THEN
714: fnd_message.set_name('BOM','BOM_UNKNOWN_ERROR');
715: fnd_message.raise_error;
716: ELSE
717: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
718: fnd_message.set_token('SEQ_NUM',to_char(start_tbl(start_tbl.COUNT).operation_seq_num));

Line 715: fnd_message.raise_error;

711: fnd_message.raise_error;*/
712: WHEN OTHERS THEN
713: IF succ_start THEN
714: fnd_message.set_name('BOM','BOM_UNKNOWN_ERROR');
715: fnd_message.raise_error;
716: ELSE
717: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
718: fnd_message.set_token('SEQ_NUM',to_char(start_tbl(start_tbl.COUNT).operation_seq_num));
719: fnd_message.raise_error;

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

713: IF succ_start THEN
714: fnd_message.set_name('BOM','BOM_UNKNOWN_ERROR');
715: fnd_message.raise_error;
716: ELSE
717: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
718: fnd_message.set_token('SEQ_NUM',to_char(start_tbl(start_tbl.COUNT).operation_seq_num));
719: fnd_message.raise_error;
720: END IF;
721: -- err_msg := fnd_message.get;

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

714: fnd_message.set_name('BOM','BOM_UNKNOWN_ERROR');
715: fnd_message.raise_error;
716: ELSE
717: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
718: fnd_message.set_token('SEQ_NUM',to_char(start_tbl(start_tbl.COUNT).operation_seq_num));
719: fnd_message.raise_error;
720: END IF;
721: -- err_msg := fnd_message.get;
722: -- raise_application_error(-20020,err_msg,FALSE);

Line 719: fnd_message.raise_error;

715: fnd_message.raise_error;
716: ELSE
717: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
718: fnd_message.set_token('SEQ_NUM',to_char(start_tbl(start_tbl.COUNT).operation_seq_num));
719: fnd_message.raise_error;
720: END IF;
721: -- err_msg := fnd_message.get;
722: -- raise_application_error(-20020,err_msg,FALSE);
723: -- dbms_output.put_line('An unidentified error has occurred in the planning percent calculations. Please contact Oracle Support.');

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

717: fnd_message.set_name('BOM','BOM_LOOP_FOUND');
718: fnd_message.set_token('SEQ_NUM',to_char(start_tbl(start_tbl.COUNT).operation_seq_num));
719: fnd_message.raise_error;
720: END IF;
721: -- err_msg := fnd_message.get;
722: -- raise_application_error(-20020,err_msg,FALSE);
723: -- dbms_output.put_line('An unidentified error has occurred in the planning percent calculations. Please contact Oracle Support.');
724: END calc_cynp;
725: