DBA Data[Home] [Help]

APPS.BOM_DELETE_GROUPS_API dependencies on FND_MESSAGE

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

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

Line 322: ERRBUF := Fnd_Message.Get;

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;

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

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:

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 1527: fnd_message.set_name('BOM', 'BOM_ARCHIVE_TOO_OLD');

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

Line 1528: err_text := fnd_message.get;

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

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

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

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

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:

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

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

Line 1680: err_text1 := Fnd_Message.get;

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

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

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

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

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

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

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

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

Line 1688: err_text1 := Fnd_Message.get;

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

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

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

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

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

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

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

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

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

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

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;

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

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

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

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

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

Line 1701: err_text1 := Fnd_Message.get;

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

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

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;

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

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

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

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

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

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

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

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;

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

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

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

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

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

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

Line 1713: err_text1 := Fnd_Message.get;

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

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

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;

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

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

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

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

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,

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