DBA Data[Home] [Help]

APPS.MSC_PQ_UTILS dependencies on FND_MESSAGE

Line 1845: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ITEM_YES');

1841: l_profile := nvl(FND_PROFILE.VALUE('MSC_PQUERY_EXEC_WITH_CRITERIA'), 'Y');
1842: l_temp := nvl(l_temp,0);
1843: if (l_temp = 0 and l_profile = 'Y' ) then
1844: if (p_query_type = 1) then
1845: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ITEM_YES');
1846: elsif (p_query_type = 2) then
1847: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_RES_YES');
1848: elsif (p_query_type = 4) THEN
1849: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_YES');

Line 1847: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_RES_YES');

1843: if (l_temp = 0 and l_profile = 'Y' ) then
1844: if (p_query_type = 1) then
1845: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ITEM_YES');
1846: elsif (p_query_type = 2) then
1847: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_RES_YES');
1848: elsif (p_query_type = 4) THEN
1849: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_YES');
1850: elsif (p_query_type = 5) then
1851: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_YES');

Line 1849: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_YES');

1845: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ITEM_YES');
1846: elsif (p_query_type = 2) then
1847: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_RES_YES');
1848: elsif (p_query_type = 4) THEN
1849: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_YES');
1850: elsif (p_query_type = 5) then
1851: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_YES');
1852: elsif (p_query_type = 9) THEN -- orders
1853: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');

Line 1851: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_YES');

1847: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_RES_YES');
1848: elsif (p_query_type = 4) THEN
1849: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_YES');
1850: elsif (p_query_type = 5) then
1851: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_YES');
1852: elsif (p_query_type = 9) THEN -- orders
1853: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1854: elsif (p_query_type = 9) THEN -- orders
1855: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');

Line 1853: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');

1849: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_YES');
1850: elsif (p_query_type = 5) then
1851: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_YES');
1852: elsif (p_query_type = 9) THEN -- orders
1853: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1854: elsif (p_query_type = 9) THEN -- orders
1855: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1856: elsif (p_query_type = 10) THEN -- Wlist
1857: NULL;

Line 1855: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');

1851: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_YES');
1852: elsif (p_query_type = 9) THEN -- orders
1853: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1854: elsif (p_query_type = 9) THEN -- orders
1855: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1856: elsif (p_query_type = 10) THEN -- Wlist
1857: NULL;
1858: --fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1859: else

Line 1858: --fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');

1854: elsif (p_query_type = 9) THEN -- orders
1855: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1856: elsif (p_query_type = 10) THEN -- Wlist
1857: NULL;
1858: --fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1859: else
1860: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK');
1861: end if;
1862: l_msg:= fnd_message.get;

Line 1860: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK');

1856: elsif (p_query_type = 10) THEN -- Wlist
1857: NULL;
1858: --fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1859: else
1860: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK');
1861: end if;
1862: l_msg:= fnd_message.get;
1863: l_warnning := -1;
1864: raise index_validation_error;

Line 1862: l_msg:= fnd_message.get;

1858: --fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1859: else
1860: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK');
1861: end if;
1862: l_msg:= fnd_message.get;
1863: l_warnning := -1;
1864: raise index_validation_error;
1865: end if;
1866:

Line 1869: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ITEM_NO');

1865: end if;
1866:
1867: if (l_temp = 0 and l_profile = 'N' ) then
1868: if (p_query_type = 1) then
1869: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ITEM_NO');
1870: elsif (p_query_type = 2) then
1871: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_RES_NO');
1872: elsif (p_query_type = 4) THEN
1873: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_NO');

Line 1871: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_RES_NO');

1867: if (l_temp = 0 and l_profile = 'N' ) then
1868: if (p_query_type = 1) then
1869: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ITEM_NO');
1870: elsif (p_query_type = 2) then
1871: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_RES_NO');
1872: elsif (p_query_type = 4) THEN
1873: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_NO');
1874: elsif (p_query_type = 5) then
1875: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_NO');

Line 1873: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_NO');

1869: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ITEM_NO');
1870: elsif (p_query_type = 2) then
1871: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_RES_NO');
1872: elsif (p_query_type = 4) THEN
1873: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_NO');
1874: elsif (p_query_type = 5) then
1875: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_NO');
1876: elsif (p_query_type = 9) THEN -- orders
1877: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_NO');

Line 1875: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_NO');

1871: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_RES_NO');
1872: elsif (p_query_type = 4) THEN
1873: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_NO');
1874: elsif (p_query_type = 5) then
1875: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_NO');
1876: elsif (p_query_type = 9) THEN -- orders
1877: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_NO');
1878: elsif (p_query_type = 10) THEN -- Wlist
1879: NULL;

Line 1877: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_NO');

1873: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_NO');
1874: elsif (p_query_type = 5) then
1875: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_NO');
1876: elsif (p_query_type = 9) THEN -- orders
1877: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_NO');
1878: elsif (p_query_type = 10) THEN -- Wlist
1879: NULL;
1880: else
1881: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK');

Line 1881: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK');

1877: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_NO');
1878: elsif (p_query_type = 10) THEN -- Wlist
1879: NULL;
1880: else
1881: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK');
1882: end if;
1883: --fnd_message.hint;
1884: l_warnning := 0;
1885: l_msg:= fnd_message.get;

Line 1883: --fnd_message.hint;

1879: NULL;
1880: else
1881: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK');
1882: end if;
1883: --fnd_message.hint;
1884: l_warnning := 0;
1885: l_msg:= fnd_message.get;
1886: raise index_validation_error;
1887: end if;

Line 1885: l_msg:= fnd_message.get;

1881: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK');
1882: end if;
1883: --fnd_message.hint;
1884: l_warnning := 0;
1885: l_msg:= fnd_message.get;
1886: raise index_validation_error;
1887: end if;
1888:
1889: if (p_query_type = 4) then

Line 1900: fnd_message.set_name('MSC', 'MSC_PQ_GROUPBY_CHECK');

1896: end loop;
1897: close c_groupby;
1898:
1899: if (l_temp > 5) then
1900: fnd_message.set_name('MSC', 'MSC_PQ_GROUPBY_CHECK');
1901: --fnd_message.error;
1902: l_msg := FND_MESSAGE.get;
1903: l_warnning := -1;
1904: raise index_validation_error;

Line 1901: --fnd_message.error;

1897: close c_groupby;
1898:
1899: if (l_temp > 5) then
1900: fnd_message.set_name('MSC', 'MSC_PQ_GROUPBY_CHECK');
1901: --fnd_message.error;
1902: l_msg := FND_MESSAGE.get;
1903: l_warnning := -1;
1904: raise index_validation_error;
1905: end if;

Line 1902: l_msg := FND_MESSAGE.get;

1898:
1899: if (l_temp > 5) then
1900: fnd_message.set_name('MSC', 'MSC_PQ_GROUPBY_CHECK');
1901: --fnd_message.error;
1902: l_msg := FND_MESSAGE.get;
1903: l_warnning := -1;
1904: raise index_validation_error;
1905: end if;
1906: end if;

Line 2172: fnd_message.set_name('MSC','MSC_ALLOW_RELEASE_INSTANCE');

2168: v_err_msg varchar2(80);
2169: l_instance_code varchar2(30);
2170: BEGIN
2171: If get_release_status(p_sr_Instance_Id,l_instance_code) = 2 then
2172: fnd_message.set_name('MSC','MSC_ALLOW_RELEASE_INSTANCE');
2173: fnd_message.set_token('INSTANCE',l_instance_code);
2174: errbuf := fnd_message.get;
2175: retcode := 1;
2176: end if;

Line 2173: fnd_message.set_token('INSTANCE',l_instance_code);

2169: l_instance_code varchar2(30);
2170: BEGIN
2171: If get_release_status(p_sr_Instance_Id,l_instance_code) = 2 then
2172: fnd_message.set_name('MSC','MSC_ALLOW_RELEASE_INSTANCE');
2173: fnd_message.set_token('INSTANCE',l_instance_code);
2174: errbuf := fnd_message.get;
2175: retcode := 1;
2176: end if;
2177: END release_status;

Line 2174: errbuf := fnd_message.get;

2170: BEGIN
2171: If get_release_status(p_sr_Instance_Id,l_instance_code) = 2 then
2172: fnd_message.set_name('MSC','MSC_ALLOW_RELEASE_INSTANCE');
2173: fnd_message.set_token('INSTANCE',l_instance_code);
2174: errbuf := fnd_message.get;
2175: retcode := 1;
2176: end if;
2177: END release_status;
2178: