DBA Data[Home] [Help]

APPS.BOM_DELETE_GROUPS_API dependencies on FND_MESSAGE

Line 321: Fnd_Message.Set_Name('BOM','BOM_DEL_REQ_WARNING');

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');

Line 322: ERRBUF := Fnd_Message.Get;

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;

Line 325: Fnd_Message.Set_Name('INV','INV_STATUS_SUCCESS');

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:

Line 326: ERRBUF := Fnd_Message.Get;

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

Line 1570: fnd_message.set_name('BOM', 'BOM_ARCHIVE_TOO_OLD');

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: */

Line 1571: err_text := fnd_message.get;

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

Line 1720: Fnd_Message.set_name('BOM', 'BOM_ITEM_DELETED');

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

Line 1721: Fnd_Message.set_token('ORG', org_name);

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:

Line 1722: Fnd_Message.set_token('ITEM', item_name);

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 */

Line 1723: err_text1 := Fnd_Message.get;

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');

Line 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;

Line 1728: Fnd_Message.set_token('ORG', org_name);

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

Line 1729: Fnd_Message.set_token('ITEM', item_name);

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 */

Line 1730: Fnd_Message.set_token('ALTERNATE', alt_desg);

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');

Line 1731: err_text1 := Fnd_Message.get;

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);

Line 1734: Fnd_Message.set_name('BOM', 'BOM_ROUTING_DELETED');

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

Line 1735: Fnd_Message.set_token('ORG', org_name);

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 */

Line 1736: Fnd_Message.set_token('ITEM', item_name);

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');

Line 1737: Fnd_Message.set_token('ALTERNATE', alt_desg);

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);

Line 1740: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED1');

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;

Line 1741: Fnd_Message.set_token('ORG', org_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;
1745: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');

Line 1742: Fnd_Message.set_token('ITEM', item_name);

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);

Line 1743: Fnd_Message.set_token('ALTERNATE', alt_desg);

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);

Line 1744: err_text1 := Fnd_Message.get;

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);

Line 1745: Fnd_Message.set_name('BOM', 'BOM_COMPONENT_DELETED2');

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;

Line 1746: Fnd_Message.set_token('COMPONENT', comp_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;
1750: elsif(delete_type =5 )then

Line 1747: Fnd_Message.set_token('OP', op_seq);

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 */

Line 1748: Fnd_Message.set_token('EFFDATE', eff_date);

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');

Line 1749: err_text2 := 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');
1753: Fnd_Message.set_token('ORG', org_name);

Line 1752: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED1');

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;

Line 1753: Fnd_Message.set_token('ORG', org_name);

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');

Line 1754: Fnd_Message.set_token('ITEM', item_name);

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);

Line 1755: Fnd_Message.set_token('ALTERNATE', alt_desg);

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);

Line 1756: err_text1 := Fnd_Message.get;

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);

Line 1757: Fnd_Message.set_name('BOM', 'BOM_OPERATION_DELETED2');

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;

Line 1758: Fnd_Message.set_token('COMPONENT', comp_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;
1762: end if;

Line 1759: Fnd_Message.set_token('OP', op_seq);

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

Line 1760: Fnd_Message.set_token('EFFDATE', eff_date);

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,

Line 1761: err_text2 := 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,
1765: buff => err_text1);