317: EXIT;
318: END LOOP;
319:
320: IF ( RETCODE = '1' ) THEN
321: Fnd_Message.Set_Name('BOM','BOM_DEL_REQ_WARNING');
322: ERRBUF := Fnd_Message.Get;
323: ELSE
324: RETCODE := '0';
325: Fnd_Message.Set_Name('INV','INV_STATUS_SUCCESS');
318: END LOOP;
319:
320: IF ( RETCODE = '1' ) THEN
321: Fnd_Message.Set_Name('BOM','BOM_DEL_REQ_WARNING');
322: ERRBUF := Fnd_Message.Get;
323: ELSE
324: RETCODE := '0';
325: Fnd_Message.Set_Name('INV','INV_STATUS_SUCCESS');
326: ERRBUF := Fnd_Message.Get;
321: Fnd_Message.Set_Name('BOM','BOM_DEL_REQ_WARNING');
322: ERRBUF := Fnd_Message.Get;
323: ELSE
324: RETCODE := '0';
325: Fnd_Message.Set_Name('INV','INV_STATUS_SUCCESS');
326: ERRBUF := Fnd_Message.Get;
327: fnd_file.put_line( which => fnd_file.output, buff => ERRBUF);
328: END IF; -- end if ( RETCODE = '1' )
329:
322: ERRBUF := Fnd_Message.Get;
323: ELSE
324: RETCODE := '0';
325: Fnd_Message.Set_Name('INV','INV_STATUS_SUCCESS');
326: ERRBUF := Fnd_Message.Get;
327: fnd_file.put_line( which => fnd_file.output, buff => ERRBUF);
328: END IF; -- end if ( RETCODE = '1' )
329:
330: EXCEPTION
1566: end;
1567: stmt_num := 4;
1568: if (dummy <> 0) then
1569: -- archive table structure does not match production table structure
1570: fnd_message.set_name('BOM', 'BOM_ARCHIVE_TOO_OLD');
1571: err_text := fnd_message.get;
1572: return(2);
1573: end if;
1574: */
1567: stmt_num := 4;
1568: if (dummy <> 0) then
1569: -- archive table structure does not match production table structure
1570: fnd_message.set_name('BOM', 'BOM_ARCHIVE_TOO_OLD');
1571: err_text := fnd_message.get;
1572: return(2);
1573: end if;
1574: */
1575: SELECT
1716: begin
1717: stmt_num := 1;
1718: if(delete_type = 1)then
1719: /* item delete */
1720: Fnd_Message.set_name('BOM', 'BOM_ITEM_DELETED');
1721: Fnd_Message.set_token('ORG', org_name);
1722: Fnd_Message.set_token('ITEM', item_name);
1723: err_text1 := Fnd_Message.get;
1724: elsif(delete_type =2 )then
1717: stmt_num := 1;
1718: if(delete_type = 1)then
1719: /* item delete */
1720: Fnd_Message.set_name('BOM', 'BOM_ITEM_DELETED');
1721: Fnd_Message.set_token('ORG', org_name);
1722: Fnd_Message.set_token('ITEM', item_name);
1723: err_text1 := Fnd_Message.get;
1724: elsif(delete_type =2 )then
1725:
1718: if(delete_type = 1)then
1719: /* item delete */
1720: Fnd_Message.set_name('BOM', 'BOM_ITEM_DELETED');
1721: Fnd_Message.set_token('ORG', org_name);
1722: Fnd_Message.set_token('ITEM', item_name);
1723: err_text1 := Fnd_Message.get;
1724: elsif(delete_type =2 )then
1725:
1726: /* bill delete */
1719: /* item delete */
1720: Fnd_Message.set_name('BOM', 'BOM_ITEM_DELETED');
1721: Fnd_Message.set_token('ORG', org_name);
1722: Fnd_Message.set_token('ITEM', item_name);
1723: err_text1 := Fnd_Message.get;
1724: elsif(delete_type =2 )then
1725:
1726: /* bill delete */
1727: Fnd_Message.set_name('BOM', 'BOM_BILL_DELETED');
1723: err_text1 := Fnd_Message.get;
1724: elsif(delete_type =2 )then
1725:
1726: /* bill delete */
1727: Fnd_Message.set_name('BOM', 'BOM_BILL_DELETED');
1728: Fnd_Message.set_token('ORG', org_name);
1729: Fnd_Message.set_token('ITEM', item_name);
1730: Fnd_Message.set_token('ALTERNATE', alt_desg);
1731: err_text1 := Fnd_Message.get;
1724: elsif(delete_type =2 )then
1725:
1726: /* bill delete */
1727: Fnd_Message.set_name('BOM', 'BOM_BILL_DELETED');
1728: Fnd_Message.set_token('ORG', org_name);
1729: Fnd_Message.set_token('ITEM', item_name);
1730: Fnd_Message.set_token('ALTERNATE', alt_desg);
1731: err_text1 := Fnd_Message.get;
1732: elsif(delete_type =3 )then
1725:
1726: /* bill delete */
1727: Fnd_Message.set_name('BOM', 'BOM_BILL_DELETED');
1728: Fnd_Message.set_token('ORG', org_name);
1729: Fnd_Message.set_token('ITEM', item_name);
1730: Fnd_Message.set_token('ALTERNATE', alt_desg);
1731: err_text1 := Fnd_Message.get;
1732: elsif(delete_type =3 )then
1733: /* routing delete */
1726: /* bill delete */
1727: Fnd_Message.set_name('BOM', 'BOM_BILL_DELETED');
1728: Fnd_Message.set_token('ORG', org_name);
1729: Fnd_Message.set_token('ITEM', item_name);
1730: Fnd_Message.set_token('ALTERNATE', alt_desg);
1731: err_text1 := Fnd_Message.get;
1732: elsif(delete_type =3 )then
1733: /* routing delete */
1734: Fnd_Message.set_name('BOM', 'BOM_ROUTING_DELETED');
1727: Fnd_Message.set_name('BOM', 'BOM_BILL_DELETED');
1728: Fnd_Message.set_token('ORG', org_name);
1729: Fnd_Message.set_token('ITEM', item_name);
1730: Fnd_Message.set_token('ALTERNATE', alt_desg);
1731: err_text1 := Fnd_Message.get;
1732: elsif(delete_type =3 )then
1733: /* routing delete */
1734: Fnd_Message.set_name('BOM', 'BOM_ROUTING_DELETED');
1735: Fnd_Message.set_token('ORG', org_name);
1730: Fnd_Message.set_token('ALTERNATE', alt_desg);
1731: err_text1 := Fnd_Message.get;
1732: elsif(delete_type =3 )then
1733: /* routing delete */
1734: Fnd_Message.set_name('BOM', 'BOM_ROUTING_DELETED');
1735: Fnd_Message.set_token('ORG', org_name);
1736: Fnd_Message.set_token('ITEM', item_name);
1737: Fnd_Message.set_token('ALTERNATE', alt_desg);
1738: elsif(delete_type =4 )then
1731: err_text1 := Fnd_Message.get;
1732: elsif(delete_type =3 )then
1733: /* routing delete */
1734: Fnd_Message.set_name('BOM', 'BOM_ROUTING_DELETED');
1735: Fnd_Message.set_token('ORG', org_name);
1736: Fnd_Message.set_token('ITEM', item_name);
1737: Fnd_Message.set_token('ALTERNATE', alt_desg);
1738: elsif(delete_type =4 )then
1739: /* component delete */
1732: elsif(delete_type =3 )then
1733: /* routing delete */
1734: Fnd_Message.set_name('BOM', 'BOM_ROUTING_DELETED');
1735: Fnd_Message.set_token('ORG', org_name);
1736: Fnd_Message.set_token('ITEM', item_name);
1737: Fnd_Message.set_token('ALTERNATE', alt_desg);
1738: elsif(delete_type =4 )then
1739: /* component delete */
1740: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED1');
1733: /* routing delete */
1734: Fnd_Message.set_name('BOM', 'BOM_ROUTING_DELETED');
1735: Fnd_Message.set_token('ORG', org_name);
1736: Fnd_Message.set_token('ITEM', item_name);
1737: Fnd_Message.set_token('ALTERNATE', alt_desg);
1738: elsif(delete_type =4 )then
1739: /* component delete */
1740: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED1');
1741: Fnd_Message.set_token('ORG', org_name);
1736: Fnd_Message.set_token('ITEM', item_name);
1737: Fnd_Message.set_token('ALTERNATE', alt_desg);
1738: elsif(delete_type =4 )then
1739: /* component delete */
1740: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED1');
1741: Fnd_Message.set_token('ORG', org_name);
1742: Fnd_Message.set_token('ITEM', item_name);
1743: Fnd_Message.set_token('ALTERNATE', alt_desg);
1744: err_text1 := Fnd_Message.get;
1737: Fnd_Message.set_token('ALTERNATE', alt_desg);
1738: elsif(delete_type =4 )then
1739: /* component delete */
1740: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED1');
1741: Fnd_Message.set_token('ORG', org_name);
1742: Fnd_Message.set_token('ITEM', item_name);
1743: Fnd_Message.set_token('ALTERNATE', alt_desg);
1744: err_text1 := Fnd_Message.get;
1745: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');
1738: elsif(delete_type =4 )then
1739: /* component delete */
1740: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED1');
1741: Fnd_Message.set_token('ORG', org_name);
1742: Fnd_Message.set_token('ITEM', item_name);
1743: Fnd_Message.set_token('ALTERNATE', alt_desg);
1744: err_text1 := Fnd_Message.get;
1745: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');
1746: Fnd_Message.set_token('COMPONENT', comp_name);
1739: /* component delete */
1740: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED1');
1741: Fnd_Message.set_token('ORG', org_name);
1742: Fnd_Message.set_token('ITEM', item_name);
1743: Fnd_Message.set_token('ALTERNATE', alt_desg);
1744: err_text1 := Fnd_Message.get;
1745: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');
1746: Fnd_Message.set_token('COMPONENT', comp_name);
1747: Fnd_Message.set_token('OP', op_seq);
1740: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED1');
1741: Fnd_Message.set_token('ORG', org_name);
1742: Fnd_Message.set_token('ITEM', item_name);
1743: Fnd_Message.set_token('ALTERNATE', alt_desg);
1744: err_text1 := Fnd_Message.get;
1745: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');
1746: Fnd_Message.set_token('COMPONENT', comp_name);
1747: Fnd_Message.set_token('OP', op_seq);
1748: Fnd_Message.set_token('EFFDATE', eff_date);
1741: Fnd_Message.set_token('ORG', org_name);
1742: Fnd_Message.set_token('ITEM', item_name);
1743: Fnd_Message.set_token('ALTERNATE', alt_desg);
1744: err_text1 := Fnd_Message.get;
1745: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');
1746: Fnd_Message.set_token('COMPONENT', comp_name);
1747: Fnd_Message.set_token('OP', op_seq);
1748: Fnd_Message.set_token('EFFDATE', eff_date);
1749: err_text2 := Fnd_Message.get;
1742: Fnd_Message.set_token('ITEM', item_name);
1743: Fnd_Message.set_token('ALTERNATE', alt_desg);
1744: err_text1 := Fnd_Message.get;
1745: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');
1746: Fnd_Message.set_token('COMPONENT', comp_name);
1747: Fnd_Message.set_token('OP', op_seq);
1748: Fnd_Message.set_token('EFFDATE', eff_date);
1749: err_text2 := Fnd_Message.get;
1750: elsif(delete_type =5 )then
1743: Fnd_Message.set_token('ALTERNATE', alt_desg);
1744: err_text1 := Fnd_Message.get;
1745: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');
1746: Fnd_Message.set_token('COMPONENT', comp_name);
1747: Fnd_Message.set_token('OP', op_seq);
1748: Fnd_Message.set_token('EFFDATE', eff_date);
1749: err_text2 := Fnd_Message.get;
1750: elsif(delete_type =5 )then
1751: /* operation delete */
1744: err_text1 := Fnd_Message.get;
1745: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');
1746: Fnd_Message.set_token('COMPONENT', comp_name);
1747: Fnd_Message.set_token('OP', op_seq);
1748: Fnd_Message.set_token('EFFDATE', eff_date);
1749: err_text2 := Fnd_Message.get;
1750: elsif(delete_type =5 )then
1751: /* operation delete */
1752: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED1');
1745: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');
1746: Fnd_Message.set_token('COMPONENT', comp_name);
1747: Fnd_Message.set_token('OP', op_seq);
1748: Fnd_Message.set_token('EFFDATE', eff_date);
1749: err_text2 := Fnd_Message.get;
1750: elsif(delete_type =5 )then
1751: /* operation delete */
1752: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED1');
1753: Fnd_Message.set_token('ORG', org_name);
1748: Fnd_Message.set_token('EFFDATE', eff_date);
1749: err_text2 := Fnd_Message.get;
1750: elsif(delete_type =5 )then
1751: /* operation delete */
1752: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED1');
1753: Fnd_Message.set_token('ORG', org_name);
1754: Fnd_Message.set_token('ITEM', item_name);
1755: Fnd_Message.set_token('ALTERNATE', alt_desg);
1756: err_text1 := Fnd_Message.get;
1749: err_text2 := Fnd_Message.get;
1750: elsif(delete_type =5 )then
1751: /* operation delete */
1752: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED1');
1753: Fnd_Message.set_token('ORG', org_name);
1754: Fnd_Message.set_token('ITEM', item_name);
1755: Fnd_Message.set_token('ALTERNATE', alt_desg);
1756: err_text1 := Fnd_Message.get;
1757: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED2');
1750: elsif(delete_type =5 )then
1751: /* operation delete */
1752: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED1');
1753: Fnd_Message.set_token('ORG', org_name);
1754: Fnd_Message.set_token('ITEM', item_name);
1755: Fnd_Message.set_token('ALTERNATE', alt_desg);
1756: err_text1 := Fnd_Message.get;
1757: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED2');
1758: Fnd_Message.set_token('COMPONENT', comp_name);
1751: /* operation delete */
1752: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED1');
1753: Fnd_Message.set_token('ORG', org_name);
1754: Fnd_Message.set_token('ITEM', item_name);
1755: Fnd_Message.set_token('ALTERNATE', alt_desg);
1756: err_text1 := Fnd_Message.get;
1757: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED2');
1758: Fnd_Message.set_token('COMPONENT', comp_name);
1759: Fnd_Message.set_token('OP', op_seq);
1752: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED1');
1753: Fnd_Message.set_token('ORG', org_name);
1754: Fnd_Message.set_token('ITEM', item_name);
1755: Fnd_Message.set_token('ALTERNATE', alt_desg);
1756: err_text1 := Fnd_Message.get;
1757: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED2');
1758: Fnd_Message.set_token('COMPONENT', comp_name);
1759: Fnd_Message.set_token('OP', op_seq);
1760: Fnd_Message.set_token('EFFDATE', eff_date);
1753: Fnd_Message.set_token('ORG', org_name);
1754: Fnd_Message.set_token('ITEM', item_name);
1755: Fnd_Message.set_token('ALTERNATE', alt_desg);
1756: err_text1 := Fnd_Message.get;
1757: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED2');
1758: Fnd_Message.set_token('COMPONENT', comp_name);
1759: Fnd_Message.set_token('OP', op_seq);
1760: Fnd_Message.set_token('EFFDATE', eff_date);
1761: err_text2 := Fnd_Message.get;
1754: Fnd_Message.set_token('ITEM', item_name);
1755: Fnd_Message.set_token('ALTERNATE', alt_desg);
1756: err_text1 := Fnd_Message.get;
1757: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED2');
1758: Fnd_Message.set_token('COMPONENT', comp_name);
1759: Fnd_Message.set_token('OP', op_seq);
1760: Fnd_Message.set_token('EFFDATE', eff_date);
1761: err_text2 := Fnd_Message.get;
1762: end if;
1755: Fnd_Message.set_token('ALTERNATE', alt_desg);
1756: err_text1 := Fnd_Message.get;
1757: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED2');
1758: Fnd_Message.set_token('COMPONENT', comp_name);
1759: Fnd_Message.set_token('OP', op_seq);
1760: Fnd_Message.set_token('EFFDATE', eff_date);
1761: err_text2 := Fnd_Message.get;
1762: end if;
1763: if err_text1 IS NOT NULL THEN
1756: err_text1 := Fnd_Message.get;
1757: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED2');
1758: Fnd_Message.set_token('COMPONENT', comp_name);
1759: Fnd_Message.set_token('OP', op_seq);
1760: Fnd_Message.set_token('EFFDATE', eff_date);
1761: err_text2 := Fnd_Message.get;
1762: end if;
1763: if err_text1 IS NOT NULL THEN
1764: fnd_file.put_line (Which => FND_FILE.LOG,
1757: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED2');
1758: Fnd_Message.set_token('COMPONENT', comp_name);
1759: Fnd_Message.set_token('OP', op_seq);
1760: Fnd_Message.set_token('EFFDATE', eff_date);
1761: err_text2 := Fnd_Message.get;
1762: end if;
1763: if err_text1 IS NOT NULL THEN
1764: fnd_file.put_line (Which => FND_FILE.LOG,
1765: buff => err_text1);