eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_PQ_UTILS dependencies on FND_MESSAGE

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

1869: l_profile := nvl(FND_PROFILE.VALUE('MSC_PQUERY_EXEC_WITH_CRITERIA'), 'Y');
1870: l_temp := nvl(l_temp,0);
1871: if (l_temp = 0 and l_profile = 'Y' ) then
1872: if (p_query_type = 1) then
1873: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ITEM_YES');
1874: elsif (p_query_type = 2) then
1875: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_RES_YES');
1876: elsif (p_query_type = 4) THEN
1877: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_YES');

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

1871: if (l_temp = 0 and l_profile = 'Y' ) then
1872: if (p_query_type = 1) then
1873: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ITEM_YES');
1874: elsif (p_query_type = 2) then
1875: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_RES_YES');
1876: elsif (p_query_type = 4) THEN
1877: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_YES');
1878: elsif (p_query_type = 5) then
1879: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_YES');

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

1873: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ITEM_YES');
1874: elsif (p_query_type = 2) then
1875: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_RES_YES');
1876: elsif (p_query_type = 4) THEN
1877: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_YES');
1878: elsif (p_query_type = 5) then
1879: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_YES');
1880: elsif (p_query_type = 9) THEN -- orders
1881: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');

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

1875: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_RES_YES');
1876: elsif (p_query_type = 4) THEN
1877: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_YES');
1878: elsif (p_query_type = 5) then
1879: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_YES');
1880: elsif (p_query_type = 9) THEN -- orders
1881: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1882: elsif (p_query_type = 9) THEN -- orders
1883: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');

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

1877: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_YES');
1878: elsif (p_query_type = 5) then
1879: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_YES');
1880: elsif (p_query_type = 9) THEN -- orders
1881: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1882: elsif (p_query_type = 9) THEN -- orders
1883: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1884: elsif (p_query_type = 10) THEN -- Wlist
1885: NULL;

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

1879: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_YES');
1880: elsif (p_query_type = 9) THEN -- orders
1881: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1882: elsif (p_query_type = 9) THEN -- orders
1883: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1884: elsif (p_query_type = 10) THEN -- Wlist
1885: NULL;
1886: --fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1887: else

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

1882: elsif (p_query_type = 9) THEN -- orders
1883: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1884: elsif (p_query_type = 10) THEN -- Wlist
1885: NULL;
1886: --fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1887: else
1888: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK');
1889: end if;
1890: l_msg:= fnd_message.get;

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

1884: elsif (p_query_type = 10) THEN -- Wlist
1885: NULL;
1886: --fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1887: else
1888: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK');
1889: end if;
1890: l_msg:= fnd_message.get;
1891: l_warnning := -1;
1892: raise index_validation_error;

Line 1890: l_msg:= fnd_message.get;

1886: --fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_YES');
1887: else
1888: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK');
1889: end if;
1890: l_msg:= fnd_message.get;
1891: l_warnning := -1;
1892: raise index_validation_error;
1893: end if;
1894:

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

1893: end if;
1894:
1895: if (l_temp = 0 and l_profile = 'N' ) then
1896: if (p_query_type = 1) then
1897: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ITEM_NO');
1898: elsif (p_query_type = 2) then
1899: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_RES_NO');
1900: elsif (p_query_type = 4) THEN
1901: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_NO');

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

1895: if (l_temp = 0 and l_profile = 'N' ) then
1896: if (p_query_type = 1) then
1897: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ITEM_NO');
1898: elsif (p_query_type = 2) then
1899: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_RES_NO');
1900: elsif (p_query_type = 4) THEN
1901: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_NO');
1902: elsif (p_query_type = 5) then
1903: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_NO');

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

1897: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ITEM_NO');
1898: elsif (p_query_type = 2) then
1899: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_RES_NO');
1900: elsif (p_query_type = 4) THEN
1901: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_NO');
1902: elsif (p_query_type = 5) then
1903: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_NO');
1904: elsif (p_query_type = 9) THEN -- orders
1905: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_NO');

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

1899: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_RES_NO');
1900: elsif (p_query_type = 4) THEN
1901: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_NO');
1902: elsif (p_query_type = 5) then
1903: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_NO');
1904: elsif (p_query_type = 9) THEN -- orders
1905: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_NO');
1906: elsif (p_query_type = 10) THEN -- Wlist
1907: NULL;

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

1901: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_EXCP_NO');
1902: elsif (p_query_type = 5) then
1903: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_SUPP_NO');
1904: elsif (p_query_type = 9) THEN -- orders
1905: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_NO');
1906: elsif (p_query_type = 10) THEN -- Wlist
1907: NULL;
1908: else
1909: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK');

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

1905: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK_ORD_NO');
1906: elsif (p_query_type = 10) THEN -- Wlist
1907: NULL;
1908: else
1909: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK');
1910: end if;
1911: --fnd_message.hint;
1912: l_warnning := 0;
1913: l_msg:= fnd_message.get;

Line 1911: --fnd_message.hint;

1907: NULL;
1908: else
1909: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK');
1910: end if;
1911: --fnd_message.hint;
1912: l_warnning := 0;
1913: l_msg:= fnd_message.get;
1914: raise index_validation_error;
1915: end if;

Line 1913: l_msg:= fnd_message.get;

1909: fnd_message.set_name('MSC', 'MSC_PQ_INDEX_CHECK');
1910: end if;
1911: --fnd_message.hint;
1912: l_warnning := 0;
1913: l_msg:= fnd_message.get;
1914: raise index_validation_error;
1915: end if;
1916:
1917: if (p_query_type = 4) then

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

1924: end loop;
1925: close c_groupby;
1926:
1927: if (l_temp > 5) then
1928: fnd_message.set_name('MSC', 'MSC_PQ_GROUPBY_CHECK');
1929: --fnd_message.error;
1930: l_msg := FND_MESSAGE.get;
1931: l_warnning := -1;
1932: raise index_validation_error;

Line 1929: --fnd_message.error;

1925: close c_groupby;
1926:
1927: if (l_temp > 5) then
1928: fnd_message.set_name('MSC', 'MSC_PQ_GROUPBY_CHECK');
1929: --fnd_message.error;
1930: l_msg := FND_MESSAGE.get;
1931: l_warnning := -1;
1932: raise index_validation_error;
1933: end if;

Line 1930: l_msg := FND_MESSAGE.get;

1926:
1927: if (l_temp > 5) then
1928: fnd_message.set_name('MSC', 'MSC_PQ_GROUPBY_CHECK');
1929: --fnd_message.error;
1930: l_msg := FND_MESSAGE.get;
1931: l_warnning := -1;
1932: raise index_validation_error;
1933: end if;
1934: end if;

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

2218: v_err_msg varchar2(80);
2219: l_instance_code varchar2(30);
2220: BEGIN
2221: If get_release_status(p_sr_Instance_Id,l_instance_code) = 2 then
2222: fnd_message.set_name('MSC','MSC_ALLOW_RELEASE_INSTANCE');
2223: fnd_message.set_token('INSTANCE',l_instance_code);
2224: errbuf := fnd_message.get;
2225: retcode := 1;
2226: end if;

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

2219: l_instance_code varchar2(30);
2220: BEGIN
2221: If get_release_status(p_sr_Instance_Id,l_instance_code) = 2 then
2222: fnd_message.set_name('MSC','MSC_ALLOW_RELEASE_INSTANCE');
2223: fnd_message.set_token('INSTANCE',l_instance_code);
2224: errbuf := fnd_message.get;
2225: retcode := 1;
2226: end if;
2227: END release_status;

Line 2224: errbuf := fnd_message.get;

2220: BEGIN
2221: If get_release_status(p_sr_Instance_Id,l_instance_code) = 2 then
2222: fnd_message.set_name('MSC','MSC_ALLOW_RELEASE_INSTANCE');
2223: fnd_message.set_token('INSTANCE',l_instance_code);
2224: errbuf := fnd_message.get;
2225: retcode := 1;
2226: end if;
2227: END release_status;
2228: