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.OKS_OC_INT_KTO_PVT dependencies on FND_MSG_PUB

Line 240: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

236: x_msg_count NUMBER;
237: x_msg_data VARCHAR2(1000);
238: BEGIN
239: IF okc_util.l_trace_flag OR okc_util.l_log_flag THEN
240: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
241: p_data => x_msg_data
242: );
243: FND_FILE.PUT_LINE( FND_FILE.LOG, '==EXCEPTION=================');
244: x_msg_data := fnd_msg_pub.get( p_msg_index => x_msg_count,

Line 244: x_msg_data := fnd_msg_pub.get( p_msg_index => x_msg_count,

240: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
241: p_data => x_msg_data
242: );
243: FND_FILE.PUT_LINE( FND_FILE.LOG, '==EXCEPTION=================');
244: x_msg_data := fnd_msg_pub.get( p_msg_index => x_msg_count,
245: p_encoded => 'F'
246: );
247: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);
248: FND_FILE.PUT_LINE( FND_FILE.LOG, '============================');

Line 897: FND_MSG_PUB.Count_And_Get (

893: px_qte_hdr_rec.order_type_id := l_order_type_id;
894:
895: okc_api.set_message(OKC_API.G_APP_NAME, 'OKC_K2Q_KCOPY', 'NUMBER', l_k_nbr);
896:
897: FND_MSG_PUB.Count_And_Get (
898: p_count => l_msg_count,
899: p_data => l_msg_data);
900:
901: px_qte_hdr_rec.quote_name := Substr( fnd_msg_pub.get( p_msg_index =>

Line 901: px_qte_hdr_rec.quote_name := Substr( fnd_msg_pub.get( p_msg_index =>

897: FND_MSG_PUB.Count_And_Get (
898: p_count => l_msg_count,
899: p_data => l_msg_data);
900:
901: px_qte_hdr_rec.quote_name := Substr( fnd_msg_pub.get( p_msg_index =>
902: l_msg_count, p_encoded => 'F'),1,50);
903:
904: FND_MSG_PUB.Delete_Msg ( p_msg_index => l_msg_count);
905:

Line 904: FND_MSG_PUB.Delete_Msg ( p_msg_index => l_msg_count);

900:
901: px_qte_hdr_rec.quote_name := Substr( fnd_msg_pub.get( p_msg_index =>
902: l_msg_count, p_encoded => 'F'),1,50);
903:
904: FND_MSG_PUB.Delete_Msg ( p_msg_index => l_msg_count);
905:
906:
907: px_qte_hdr_rec.quote_version := 1;
908: px_qte_hdr_rec.party_id := l_cust.object1_id1;

Line 1459: l_init_msg_count:=fnd_msg_pub.count_msg;

1455: l_quote_hd_price_attr_tab.DELETE;
1456: l_quote_ln_price_attr_tab.DELETE;
1457:
1458:
1459: l_init_msg_count:=fnd_msg_pub.count_msg;
1460: --FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Number = '||l_chr.contract_number);
1461: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************Subscription Contract to Order Creation****************** ');
1462:
1463: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id = '||p_contract_id);

Line 1787: FND_MSG_PUB.Count_And_Get (

1783: p_token4_value => l_ord_expiration_date,
1784: p_token5 => 'TRACEFILE',
1785: p_token5_value => okc_util.l_complete_trace_file_name2
1786: );
1787: FND_MSG_PUB.Count_And_Get (
1788: p_count => x_msg_count,
1789: p_data => x_msg_data);
1790: x_msg_data := fnd_msg_pub.get(
1791: p_msg_index => x_msg_count,

Line 1790: x_msg_data := fnd_msg_pub.get(

1786: );
1787: FND_MSG_PUB.Count_And_Get (
1788: p_count => x_msg_count,
1789: p_data => x_msg_data);
1790: x_msg_data := fnd_msg_pub.get(
1791: p_msg_index => x_msg_count,
1792: p_encoded => 'F');
1793:
1794: l_ord_creation_message := x_msg_data;

Line 1795: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);

1791: p_msg_index => x_msg_count,
1792: p_encoded => 'F');
1793:
1794: l_ord_creation_message := x_msg_data;
1795: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
1796:
1797: END IF; -- IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR
1798:
1799: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1807: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

1803: CLOSE c_k_header;
1804: END IF;
1805:
1806: x_return_status := OKC_API.G_RET_STS_ERROR;
1807: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1808: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name
1809: ,p_procedure_name => l_api_name
1810: ,p_error_text => 'Encountered error condition'
1811: );

Line 1808: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name

1804: END IF;
1805:
1806: x_return_status := OKC_API.G_RET_STS_ERROR;
1807: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1808: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name
1809: ,p_procedure_name => l_api_name
1810: ,p_error_text => 'Encountered error condition'
1811: );
1812: END IF;

Line 1826: FND_MSG_PUB.Count_And_Get (

1822: p_token2_value => l_chr.contract_number,
1823: p_token3 => 'KMODIFIER',
1824: p_token3_value => NVL(l_chr.contract_number_modifier, ' ')
1825: );
1826: FND_MSG_PUB.Count_And_Get (
1827: p_count => x_msg_count,
1828: p_data => x_msg_data);
1829: x_msg_data := fnd_msg_pub.get(
1830: p_msg_index => x_msg_count,

Line 1829: x_msg_data := fnd_msg_pub.get(

1825: );
1826: FND_MSG_PUB.Count_And_Get (
1827: p_count => x_msg_count,
1828: p_data => x_msg_data);
1829: x_msg_data := fnd_msg_pub.get(
1830: p_msg_index => x_msg_count,
1831: p_encoded => 'F');
1832:
1833: l_ord_creation_message := x_msg_data;

Line 1834: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);

1830: p_msg_index => x_msg_count,
1831: p_encoded => 'F');
1832:
1833: l_ord_creation_message := x_msg_data;
1834: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
1835:
1836: okc_util.print_output(0, l_ord_creation_message);
1837: END IF;
1838: FND_MSG_PUB.Count_And_Get (

Line 1838: FND_MSG_PUB.Count_And_Get (

1834: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
1835:
1836: okc_util.print_output(0, l_ord_creation_message);
1837: END IF;
1838: FND_MSG_PUB.Count_And_Get (
1839: p_count => x_msg_count,
1840: p_data => x_msg_data);
1841: FOR k in l_init_msg_count..x_msg_count LOOP
1842: x_msg_data := fnd_msg_pub.get( p_msg_index => k,

Line 1842: x_msg_data := fnd_msg_pub.get( p_msg_index => k,

1838: FND_MSG_PUB.Count_And_Get (
1839: p_count => x_msg_count,
1840: p_data => x_msg_data);
1841: FOR k in l_init_msg_count..x_msg_count LOOP
1842: x_msg_data := fnd_msg_pub.get( p_msg_index => k,
1843: p_encoded => 'F'
1844: );
1845: IF x_msg_data IS NOT NULL THEN
1846: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);

Line 1871: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

1867: CLOSE c_k_header;
1868: END IF;
1869:
1870: x_return_status := OKC_API.G_RET_STS_ERROR;
1871: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1872: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name
1873: ,p_procedure_name => l_api_name
1874: ,p_error_text => 'Encountered error condition'
1875: );

Line 1872: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name

1868: END IF;
1869:
1870: x_return_status := OKC_API.G_RET_STS_ERROR;
1871: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1872: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name
1873: ,p_procedure_name => l_api_name
1874: ,p_error_text => 'Encountered error condition'
1875: );
1876: END IF;

Line 1890: FND_MSG_PUB.Count_And_Get (

1886: p_token2_value => l_chr.contract_number,
1887: p_token3 => 'KMODIFIER',
1888: p_token3_value => NVL(l_chr.contract_number_modifier, ' ')
1889: );
1890: FND_MSG_PUB.Count_And_Get (
1891: p_count => x_msg_count,
1892: p_data => x_msg_data);
1893: x_msg_data := fnd_msg_pub.get(
1894: p_msg_index => x_msg_count,

Line 1893: x_msg_data := fnd_msg_pub.get(

1889: );
1890: FND_MSG_PUB.Count_And_Get (
1891: p_count => x_msg_count,
1892: p_data => x_msg_data);
1893: x_msg_data := fnd_msg_pub.get(
1894: p_msg_index => x_msg_count,
1895: p_encoded => 'F');
1896:
1897: l_ord_creation_message := x_msg_data;

Line 1898: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);

1894: p_msg_index => x_msg_count,
1895: p_encoded => 'F');
1896:
1897: l_ord_creation_message := x_msg_data;
1898: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
1899:
1900: okc_util.print_output(0, l_ord_creation_message);
1901: END IF;
1902: FND_MSG_PUB.Count_And_Get (

Line 1902: FND_MSG_PUB.Count_And_Get (

1898: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
1899:
1900: okc_util.print_output(0, l_ord_creation_message);
1901: END IF;
1902: FND_MSG_PUB.Count_And_Get (
1903: p_count => x_msg_count,
1904: p_data => x_msg_data);
1905: FOR k in l_init_msg_count..x_msg_count LOOP
1906: x_msg_data := fnd_msg_pub.get( p_msg_index => k,

Line 1906: x_msg_data := fnd_msg_pub.get( p_msg_index => k,

1902: FND_MSG_PUB.Count_And_Get (
1903: p_count => x_msg_count,
1904: p_data => x_msg_data);
1905: FOR k in l_init_msg_count..x_msg_count LOOP
1906: x_msg_data := fnd_msg_pub.get( p_msg_index => k,
1907: p_encoded => 'F'
1908: );
1909: IF x_msg_data IS NOT NULL THEN
1910: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);

Line 1959: FND_MSG_PUB.Count_And_Get (

1955: p_token5_value => l_chr.contract_number,
1956: p_token6 => 'KMODIFIER',
1957: p_token6_value => NVL(l_chr.contract_number_modifier, ' ')
1958: );
1959: FND_MSG_PUB.Count_And_Get (
1960: p_count => x_msg_count,
1961: p_data => x_msg_data);
1962:
1963: x_msg_data := fnd_msg_pub.get(

Line 1963: x_msg_data := fnd_msg_pub.get(

1959: FND_MSG_PUB.Count_And_Get (
1960: p_count => x_msg_count,
1961: p_data => x_msg_data);
1962:
1963: x_msg_data := fnd_msg_pub.get(
1964: p_msg_index => x_msg_count,
1965: p_encoded => 'F');
1966:
1967: l_ord_creation_message := x_msg_data;

Line 1968: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);

1964: p_msg_index => x_msg_count,
1965: p_encoded => 'F');
1966:
1967: l_ord_creation_message := x_msg_data;
1968: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
1969:
1970: okc_util.print_output(0, l_ord_creation_message);
1971: FND_MSG_PUB.Count_And_Get (
1972: p_count => x_msg_count,

Line 1971: FND_MSG_PUB.Count_And_Get (

1967: l_ord_creation_message := x_msg_data;
1968: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
1969:
1970: okc_util.print_output(0, l_ord_creation_message);
1971: FND_MSG_PUB.Count_And_Get (
1972: p_count => x_msg_count,
1973: p_data => x_msg_data);
1974: FOR k in l_init_msg_count..x_msg_count LOOP
1975: x_msg_data := fnd_msg_pub.get( p_msg_index => k,

Line 1975: x_msg_data := fnd_msg_pub.get( p_msg_index => k,

1971: FND_MSG_PUB.Count_And_Get (
1972: p_count => x_msg_count,
1973: p_data => x_msg_data);
1974: FOR k in l_init_msg_count..x_msg_count LOOP
1975: x_msg_data := fnd_msg_pub.get( p_msg_index => k,
1976: p_encoded => 'F'
1977: );
1978: IF x_msg_data IS NOT NULL THEN
1979: okc_util.print_output(0, 'Message : '||x_msg_data);

Line 2026: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

2022: CLOSE c_k_header;
2023: END IF;
2024:
2025: x_return_status := OKC_API.G_RET_STS_ERROR;
2026: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2027: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name
2028: ,p_procedure_name => l_api_name
2029: ,p_error_text => 'Encountered error condition'
2030: );

Line 2027: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name

2023: END IF;
2024:
2025: x_return_status := OKC_API.G_RET_STS_ERROR;
2026: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2027: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name
2028: ,p_procedure_name => l_api_name
2029: ,p_error_text => 'Encountered error condition'
2030: );
2031: END IF;

Line 2045: FND_MSG_PUB.Count_And_Get (

2041: p_token2_value => l_chr.contract_number,
2042: p_token3 => 'KMODIFIER',
2043: p_token3_value => NVL(l_chr.contract_number_modifier, ' ')
2044: );
2045: FND_MSG_PUB.Count_And_Get (
2046: p_count => x_msg_count,
2047: p_data => x_msg_data);
2048: x_msg_data := fnd_msg_pub.get(
2049: p_msg_index => x_msg_count,

Line 2048: x_msg_data := fnd_msg_pub.get(

2044: );
2045: FND_MSG_PUB.Count_And_Get (
2046: p_count => x_msg_count,
2047: p_data => x_msg_data);
2048: x_msg_data := fnd_msg_pub.get(
2049: p_msg_index => x_msg_count,
2050: p_encoded => 'F');
2051:
2052: l_ord_creation_message := x_msg_data;

Line 2053: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);

2049: p_msg_index => x_msg_count,
2050: p_encoded => 'F');
2051:
2052: l_ord_creation_message := x_msg_data;
2053: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
2054:
2055: okc_util.print_output(0, l_ord_creation_message);
2056: END IF;
2057: FND_MSG_PUB.Count_And_Get (

Line 2057: FND_MSG_PUB.Count_And_Get (

2053: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
2054:
2055: okc_util.print_output(0, l_ord_creation_message);
2056: END IF;
2057: FND_MSG_PUB.Count_And_Get (
2058: p_count => x_msg_count,
2059: p_data => x_msg_data);
2060: FOR k in l_init_msg_count..x_msg_count LOOP
2061: x_msg_data := fnd_msg_pub.get( p_msg_index => k,

Line 2061: x_msg_data := fnd_msg_pub.get( p_msg_index => k,

2057: FND_MSG_PUB.Count_And_Get (
2058: p_count => x_msg_count,
2059: p_data => x_msg_data);
2060: FOR k in l_init_msg_count..x_msg_count LOOP
2061: x_msg_data := fnd_msg_pub.get( p_msg_index => k,
2062: p_encoded => 'F'
2063: );
2064: IF x_msg_data IS NOT NULL THEN
2065: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);

Line 2080: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

2076: CLOSE c_k_header;
2077: END IF;
2078:
2079: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2080: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2081: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name
2082: ,p_procedure_name => l_api_name
2083: ,p_error_text => 'Encountered unexpected error'
2084: );

Line 2081: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name

2077: END IF;
2078:
2079: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2080: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2081: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name
2082: ,p_procedure_name => l_api_name
2083: ,p_error_text => 'Encountered unexpected error'
2084: );
2085: END IF;

Line 2104: FND_MSG_PUB.Count_And_Get (

2100: p_token2_value => l_chr.contract_number,
2101: p_token3 => 'KMODIFIER',
2102: p_token3_value => NVL(l_chr.contract_number_modifier, ' ')
2103: );
2104: FND_MSG_PUB.Count_And_Get (
2105: p_count => x_msg_count,
2106: p_data => x_msg_data);
2107: x_msg_data := fnd_msg_pub.get(
2108: p_msg_index => x_msg_count,

Line 2107: x_msg_data := fnd_msg_pub.get(

2103: );
2104: FND_MSG_PUB.Count_And_Get (
2105: p_count => x_msg_count,
2106: p_data => x_msg_data);
2107: x_msg_data := fnd_msg_pub.get(
2108: p_msg_index => x_msg_count,
2109: p_encoded => 'F');
2110:
2111: l_ord_creation_message := x_msg_data;

Line 2112: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);

2108: p_msg_index => x_msg_count,
2109: p_encoded => 'F');
2110:
2111: l_ord_creation_message := x_msg_data;
2112: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
2113:
2114: okc_util.print_output(0, l_ord_creation_message);
2115: END IF;
2116: FND_MSG_PUB.Count_And_Get (

Line 2116: FND_MSG_PUB.Count_And_Get (

2112: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
2113:
2114: okc_util.print_output(0, l_ord_creation_message);
2115: END IF;
2116: FND_MSG_PUB.Count_And_Get (
2117: p_count => x_msg_count,
2118: p_data => x_msg_data);
2119: FOR k in l_init_msg_count..x_msg_count LOOP
2120: x_msg_data := fnd_msg_pub.get( p_msg_index => k,

Line 2120: x_msg_data := fnd_msg_pub.get( p_msg_index => k,

2116: FND_MSG_PUB.Count_And_Get (
2117: p_count => x_msg_count,
2118: p_data => x_msg_data);
2119: FOR k in l_init_msg_count..x_msg_count LOOP
2120: x_msg_data := fnd_msg_pub.get( p_msg_index => k,
2121: p_encoded => 'F'
2122: );
2123: IF x_msg_data IS NOT NULL THEN
2124: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);

Line 2164: FND_MSG_PUB.Count_And_Get (

2160: p_token2_value => l_chr.contract_number,
2161: p_token3 => 'KMODIFIER',
2162: p_token3_value => NVL(l_chr.contract_number_modifier, ' ')
2163: );
2164: FND_MSG_PUB.Count_And_Get (
2165: p_count => x_msg_count,
2166: p_data => x_msg_data);
2167: x_msg_data := fnd_msg_pub.get(
2168: p_msg_index => x_msg_count,

Line 2167: x_msg_data := fnd_msg_pub.get(

2163: );
2164: FND_MSG_PUB.Count_And_Get (
2165: p_count => x_msg_count,
2166: p_data => x_msg_data);
2167: x_msg_data := fnd_msg_pub.get(
2168: p_msg_index => x_msg_count,
2169: p_encoded => 'F');
2170:
2171: l_ord_creation_message := x_msg_data;

Line 2172: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);

2168: p_msg_index => x_msg_count,
2169: p_encoded => 'F');
2170:
2171: l_ord_creation_message := x_msg_data;
2172: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
2173:
2174: okc_util.print_output(0, l_ord_creation_message);
2175: END IF;
2176: FND_MSG_PUB.Count_And_Get (

Line 2176: FND_MSG_PUB.Count_And_Get (

2172: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
2173:
2174: okc_util.print_output(0, l_ord_creation_message);
2175: END IF;
2176: FND_MSG_PUB.Count_And_Get (
2177: p_count => x_msg_count,
2178: p_data => x_msg_data);
2179: FOR k in l_init_msg_count..x_msg_count LOOP
2180: x_msg_data := fnd_msg_pub.get( p_msg_index => k,

Line 2180: x_msg_data := fnd_msg_pub.get( p_msg_index => k,

2176: FND_MSG_PUB.Count_And_Get (
2177: p_count => x_msg_count,
2178: p_data => x_msg_data);
2179: FOR k in l_init_msg_count..x_msg_count LOOP
2180: x_msg_data := fnd_msg_pub.get( p_msg_index => k,
2181: p_encoded => 'F'
2182: );
2183: IF x_msg_data IS NOT NULL THEN
2184: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);