317: EXIT;
318: END LOOP;
319:
320: IF ( RETCODE = '1' ) THEN
321: Fnd_Message.Set_Name('BOM','BOM_CONC_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_CONC_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_CONC_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
1523: end;
1524: stmt_num := 4;
1525: if (dummy <> 0) then
1526: -- archive table structure does not match production table structure
1527: fnd_message.set_name('BOM', 'BOM_ARCHIVE_TOO_OLD');
1528: err_text := fnd_message.get;
1529: return(2);
1530: end if;
1531: */
1524: stmt_num := 4;
1525: if (dummy <> 0) then
1526: -- archive table structure does not match production table structure
1527: fnd_message.set_name('BOM', 'BOM_ARCHIVE_TOO_OLD');
1528: err_text := fnd_message.get;
1529: return(2);
1530: end if;
1531: */
1532: SELECT
1673: begin
1674: stmt_num := 1;
1675: if(delete_type = 1)then
1676: /* item delete */
1677: Fnd_Message.set_name('BOM', 'BOM_ITEM_DELETED');
1678: Fnd_Message.set_token('ORG', org_name);
1679: Fnd_Message.set_token('ITEM', item_name);
1680: err_text1 := Fnd_Message.get;
1681: elsif(delete_type =2 )then
1674: stmt_num := 1;
1675: if(delete_type = 1)then
1676: /* item delete */
1677: Fnd_Message.set_name('BOM', 'BOM_ITEM_DELETED');
1678: Fnd_Message.set_token('ORG', org_name);
1679: Fnd_Message.set_token('ITEM', item_name);
1680: err_text1 := Fnd_Message.get;
1681: elsif(delete_type =2 )then
1682:
1675: if(delete_type = 1)then
1676: /* item delete */
1677: Fnd_Message.set_name('BOM', 'BOM_ITEM_DELETED');
1678: Fnd_Message.set_token('ORG', org_name);
1679: Fnd_Message.set_token('ITEM', item_name);
1680: err_text1 := Fnd_Message.get;
1681: elsif(delete_type =2 )then
1682:
1683: /* bill delete */
1676: /* item delete */
1677: Fnd_Message.set_name('BOM', 'BOM_ITEM_DELETED');
1678: Fnd_Message.set_token('ORG', org_name);
1679: Fnd_Message.set_token('ITEM', item_name);
1680: err_text1 := Fnd_Message.get;
1681: elsif(delete_type =2 )then
1682:
1683: /* bill delete */
1684: Fnd_Message.set_name('BOM', 'BOM_BILL_DELETED');
1680: err_text1 := Fnd_Message.get;
1681: elsif(delete_type =2 )then
1682:
1683: /* bill delete */
1684: Fnd_Message.set_name('BOM', 'BOM_BILL_DELETED');
1685: Fnd_Message.set_token('ORG', org_name);
1686: Fnd_Message.set_token('ITEM', item_name);
1687: Fnd_Message.set_token('ALTERNATE', alt_desg);
1688: err_text1 := Fnd_Message.get;
1681: elsif(delete_type =2 )then
1682:
1683: /* bill delete */
1684: Fnd_Message.set_name('BOM', 'BOM_BILL_DELETED');
1685: Fnd_Message.set_token('ORG', org_name);
1686: Fnd_Message.set_token('ITEM', item_name);
1687: Fnd_Message.set_token('ALTERNATE', alt_desg);
1688: err_text1 := Fnd_Message.get;
1689: elsif(delete_type =3 )then
1682:
1683: /* bill delete */
1684: Fnd_Message.set_name('BOM', 'BOM_BILL_DELETED');
1685: Fnd_Message.set_token('ORG', org_name);
1686: Fnd_Message.set_token('ITEM', item_name);
1687: Fnd_Message.set_token('ALTERNATE', alt_desg);
1688: err_text1 := Fnd_Message.get;
1689: elsif(delete_type =3 )then
1690: /* routing delete */
1683: /* bill delete */
1684: Fnd_Message.set_name('BOM', 'BOM_BILL_DELETED');
1685: Fnd_Message.set_token('ORG', org_name);
1686: Fnd_Message.set_token('ITEM', item_name);
1687: Fnd_Message.set_token('ALTERNATE', alt_desg);
1688: err_text1 := Fnd_Message.get;
1689: elsif(delete_type =3 )then
1690: /* routing delete */
1691: Fnd_Message.set_name('BOM', 'BOM_ROUTING_DELETED');
1684: Fnd_Message.set_name('BOM', 'BOM_BILL_DELETED');
1685: Fnd_Message.set_token('ORG', org_name);
1686: Fnd_Message.set_token('ITEM', item_name);
1687: Fnd_Message.set_token('ALTERNATE', alt_desg);
1688: err_text1 := Fnd_Message.get;
1689: elsif(delete_type =3 )then
1690: /* routing delete */
1691: Fnd_Message.set_name('BOM', 'BOM_ROUTING_DELETED');
1692: Fnd_Message.set_token('ORG', org_name);
1687: Fnd_Message.set_token('ALTERNATE', alt_desg);
1688: err_text1 := Fnd_Message.get;
1689: elsif(delete_type =3 )then
1690: /* routing delete */
1691: Fnd_Message.set_name('BOM', 'BOM_ROUTING_DELETED');
1692: Fnd_Message.set_token('ORG', org_name);
1693: Fnd_Message.set_token('ITEM', item_name);
1694: Fnd_Message.set_token('ALTERNATE', alt_desg);
1695: elsif(delete_type =4 )then
1688: err_text1 := Fnd_Message.get;
1689: elsif(delete_type =3 )then
1690: /* routing delete */
1691: Fnd_Message.set_name('BOM', 'BOM_ROUTING_DELETED');
1692: Fnd_Message.set_token('ORG', org_name);
1693: Fnd_Message.set_token('ITEM', item_name);
1694: Fnd_Message.set_token('ALTERNATE', alt_desg);
1695: elsif(delete_type =4 )then
1696: /* component delete */
1689: elsif(delete_type =3 )then
1690: /* routing delete */
1691: Fnd_Message.set_name('BOM', 'BOM_ROUTING_DELETED');
1692: Fnd_Message.set_token('ORG', org_name);
1693: Fnd_Message.set_token('ITEM', item_name);
1694: Fnd_Message.set_token('ALTERNATE', alt_desg);
1695: elsif(delete_type =4 )then
1696: /* component delete */
1697: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED1');
1690: /* routing delete */
1691: Fnd_Message.set_name('BOM', 'BOM_ROUTING_DELETED');
1692: Fnd_Message.set_token('ORG', org_name);
1693: Fnd_Message.set_token('ITEM', item_name);
1694: Fnd_Message.set_token('ALTERNATE', alt_desg);
1695: elsif(delete_type =4 )then
1696: /* component delete */
1697: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED1');
1698: Fnd_Message.set_token('ORG', org_name);
1693: Fnd_Message.set_token('ITEM', item_name);
1694: Fnd_Message.set_token('ALTERNATE', alt_desg);
1695: elsif(delete_type =4 )then
1696: /* component delete */
1697: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED1');
1698: Fnd_Message.set_token('ORG', org_name);
1699: Fnd_Message.set_token('ITEM', item_name);
1700: Fnd_Message.set_token('ALTERNATE', alt_desg);
1701: err_text1 := Fnd_Message.get;
1694: Fnd_Message.set_token('ALTERNATE', alt_desg);
1695: elsif(delete_type =4 )then
1696: /* component delete */
1697: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED1');
1698: Fnd_Message.set_token('ORG', org_name);
1699: Fnd_Message.set_token('ITEM', item_name);
1700: Fnd_Message.set_token('ALTERNATE', alt_desg);
1701: err_text1 := Fnd_Message.get;
1702: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');
1695: elsif(delete_type =4 )then
1696: /* component delete */
1697: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED1');
1698: Fnd_Message.set_token('ORG', org_name);
1699: Fnd_Message.set_token('ITEM', item_name);
1700: Fnd_Message.set_token('ALTERNATE', alt_desg);
1701: err_text1 := Fnd_Message.get;
1702: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');
1703: Fnd_Message.set_token('COMPONENT', comp_name);
1696: /* component delete */
1697: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED1');
1698: Fnd_Message.set_token('ORG', org_name);
1699: Fnd_Message.set_token('ITEM', item_name);
1700: Fnd_Message.set_token('ALTERNATE', alt_desg);
1701: err_text1 := Fnd_Message.get;
1702: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');
1703: Fnd_Message.set_token('COMPONENT', comp_name);
1704: Fnd_Message.set_token('OP', op_seq);
1697: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED1');
1698: Fnd_Message.set_token('ORG', org_name);
1699: Fnd_Message.set_token('ITEM', item_name);
1700: Fnd_Message.set_token('ALTERNATE', alt_desg);
1701: err_text1 := Fnd_Message.get;
1702: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');
1703: Fnd_Message.set_token('COMPONENT', comp_name);
1704: Fnd_Message.set_token('OP', op_seq);
1705: Fnd_Message.set_token('EFFDATE', eff_date);
1698: Fnd_Message.set_token('ORG', org_name);
1699: Fnd_Message.set_token('ITEM', item_name);
1700: Fnd_Message.set_token('ALTERNATE', alt_desg);
1701: err_text1 := Fnd_Message.get;
1702: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');
1703: Fnd_Message.set_token('COMPONENT', comp_name);
1704: Fnd_Message.set_token('OP', op_seq);
1705: Fnd_Message.set_token('EFFDATE', eff_date);
1706: err_text2 := Fnd_Message.get;
1699: Fnd_Message.set_token('ITEM', item_name);
1700: Fnd_Message.set_token('ALTERNATE', alt_desg);
1701: err_text1 := Fnd_Message.get;
1702: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');
1703: Fnd_Message.set_token('COMPONENT', comp_name);
1704: Fnd_Message.set_token('OP', op_seq);
1705: Fnd_Message.set_token('EFFDATE', eff_date);
1706: err_text2 := Fnd_Message.get;
1707: elsif(delete_type =5 )then
1700: Fnd_Message.set_token('ALTERNATE', alt_desg);
1701: err_text1 := Fnd_Message.get;
1702: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');
1703: Fnd_Message.set_token('COMPONENT', comp_name);
1704: Fnd_Message.set_token('OP', op_seq);
1705: Fnd_Message.set_token('EFFDATE', eff_date);
1706: err_text2 := Fnd_Message.get;
1707: elsif(delete_type =5 )then
1708: /* operation delete */
1701: err_text1 := Fnd_Message.get;
1702: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');
1703: Fnd_Message.set_token('COMPONENT', comp_name);
1704: Fnd_Message.set_token('OP', op_seq);
1705: Fnd_Message.set_token('EFFDATE', eff_date);
1706: err_text2 := Fnd_Message.get;
1707: elsif(delete_type =5 )then
1708: /* operation delete */
1709: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED1');
1702: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');
1703: Fnd_Message.set_token('COMPONENT', comp_name);
1704: Fnd_Message.set_token('OP', op_seq);
1705: Fnd_Message.set_token('EFFDATE', eff_date);
1706: err_text2 := Fnd_Message.get;
1707: elsif(delete_type =5 )then
1708: /* operation delete */
1709: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED1');
1710: Fnd_Message.set_token('ORG', org_name);
1705: Fnd_Message.set_token('EFFDATE', eff_date);
1706: err_text2 := Fnd_Message.get;
1707: elsif(delete_type =5 )then
1708: /* operation delete */
1709: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED1');
1710: Fnd_Message.set_token('ORG', org_name);
1711: Fnd_Message.set_token('ITEM', item_name);
1712: Fnd_Message.set_token('ALTERNATE', alt_desg);
1713: err_text1 := Fnd_Message.get;
1706: err_text2 := Fnd_Message.get;
1707: elsif(delete_type =5 )then
1708: /* operation delete */
1709: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED1');
1710: Fnd_Message.set_token('ORG', org_name);
1711: Fnd_Message.set_token('ITEM', item_name);
1712: Fnd_Message.set_token('ALTERNATE', alt_desg);
1713: err_text1 := Fnd_Message.get;
1714: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED2');
1707: elsif(delete_type =5 )then
1708: /* operation delete */
1709: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED1');
1710: Fnd_Message.set_token('ORG', org_name);
1711: Fnd_Message.set_token('ITEM', item_name);
1712: Fnd_Message.set_token('ALTERNATE', alt_desg);
1713: err_text1 := Fnd_Message.get;
1714: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED2');
1715: Fnd_Message.set_token('COMPONENT', comp_name);
1708: /* operation delete */
1709: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED1');
1710: Fnd_Message.set_token('ORG', org_name);
1711: Fnd_Message.set_token('ITEM', item_name);
1712: Fnd_Message.set_token('ALTERNATE', alt_desg);
1713: err_text1 := Fnd_Message.get;
1714: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED2');
1715: Fnd_Message.set_token('COMPONENT', comp_name);
1716: Fnd_Message.set_token('OP', op_seq);
1709: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED1');
1710: Fnd_Message.set_token('ORG', org_name);
1711: Fnd_Message.set_token('ITEM', item_name);
1712: Fnd_Message.set_token('ALTERNATE', alt_desg);
1713: err_text1 := Fnd_Message.get;
1714: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED2');
1715: Fnd_Message.set_token('COMPONENT', comp_name);
1716: Fnd_Message.set_token('OP', op_seq);
1717: Fnd_Message.set_token('EFFDATE', eff_date);
1710: Fnd_Message.set_token('ORG', org_name);
1711: Fnd_Message.set_token('ITEM', item_name);
1712: Fnd_Message.set_token('ALTERNATE', alt_desg);
1713: err_text1 := Fnd_Message.get;
1714: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED2');
1715: Fnd_Message.set_token('COMPONENT', comp_name);
1716: Fnd_Message.set_token('OP', op_seq);
1717: Fnd_Message.set_token('EFFDATE', eff_date);
1718: err_text2 := Fnd_Message.get;
1711: Fnd_Message.set_token('ITEM', item_name);
1712: Fnd_Message.set_token('ALTERNATE', alt_desg);
1713: err_text1 := Fnd_Message.get;
1714: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED2');
1715: Fnd_Message.set_token('COMPONENT', comp_name);
1716: Fnd_Message.set_token('OP', op_seq);
1717: Fnd_Message.set_token('EFFDATE', eff_date);
1718: err_text2 := Fnd_Message.get;
1719: end if;
1712: Fnd_Message.set_token('ALTERNATE', alt_desg);
1713: err_text1 := Fnd_Message.get;
1714: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED2');
1715: Fnd_Message.set_token('COMPONENT', comp_name);
1716: Fnd_Message.set_token('OP', op_seq);
1717: Fnd_Message.set_token('EFFDATE', eff_date);
1718: err_text2 := Fnd_Message.get;
1719: end if;
1720: if err_text1 IS NOT NULL THEN
1713: err_text1 := Fnd_Message.get;
1714: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED2');
1715: Fnd_Message.set_token('COMPONENT', comp_name);
1716: Fnd_Message.set_token('OP', op_seq);
1717: Fnd_Message.set_token('EFFDATE', eff_date);
1718: err_text2 := Fnd_Message.get;
1719: end if;
1720: if err_text1 IS NOT NULL THEN
1721: fnd_file.put_line (Which => FND_FILE.LOG,
1714: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED2');
1715: Fnd_Message.set_token('COMPONENT', comp_name);
1716: Fnd_Message.set_token('OP', op_seq);
1717: Fnd_Message.set_token('EFFDATE', eff_date);
1718: err_text2 := Fnd_Message.get;
1719: end if;
1720: if err_text1 IS NOT NULL THEN
1721: fnd_file.put_line (Which => FND_FILE.LOG,
1722: buff => err_text1);