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

Line 182: fnd_msg_pub.ADD;

178: fnd_message.set_token (
179: 'PERSON_ID',
180: p_person_id
181: );
182: fnd_msg_pub.ADD;
183: RAISE fnd_api.g_exc_error;
184: WHEN OTHERS
185: THEN
186: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 205: fnd_msg_pub.ADD;

201: fnd_message.set_token (
202: 'PERSON_ID',
203: p_person_id
204: );
205: fnd_msg_pub.ADD;
206: RAISE fnd_api.g_exc_error;
207: END get_approver_name;
208:
209: PROCEDURE get_all_approvers (

Line 304: fnd_msg_pub.initialize;

300: 1,
301: 'N'
302: );
303: END IF;
304: fnd_msg_pub.initialize;
305: END IF;
306:
307: -- Initialize API return status to success
308:

Line 540: p_exception_level => fnd_msg_pub.g_msg_lvl_error,

536: END IF;
537: aso_utility_pvt.handle_exceptions (
538: p_api_name => l_api_name,
539: p_pkg_name => g_pkg_name,
540: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
541: p_package_type => aso_utility_pvt.g_int,
542: p_sqlcode => SQLCODE,
543: p_sqlerrm => SQLERRM,
544: x_msg_count => x_msg_count,

Line 560: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,

556: END IF;
557: aso_utility_pvt.handle_exceptions (
558: p_api_name => l_api_name,
559: p_pkg_name => g_pkg_name,
560: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
561: p_package_type => aso_utility_pvt.g_int,
562: p_sqlcode => SQLCODE,
563: p_sqlerrm => SQLERRM,
564: x_msg_count => x_msg_count,

Line 722: fnd_msg_pub.initialize;

718: 1,
719: 'N'
720: );
721: END IF;
722: fnd_msg_pub.initialize;
723: END IF;
724:
725: -- Initialize API return status to success
726: x_return_status := fnd_api.g_ret_sts_success;

Line 1257: p_exception_level => fnd_msg_pub.g_msg_lvl_error,

1253: END IF;
1254: aso_utility_pvt.handle_exceptions (
1255: p_api_name => l_api_name,
1256: p_pkg_name => g_pkg_name,
1257: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
1258: p_package_type => aso_utility_pvt.g_int,
1259: p_sqlcode => SQLCODE,
1260: p_sqlerrm => SQLERRM,
1261: x_msg_count => x_msg_count,

Line 1277: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,

1273: END IF;
1274: aso_utility_pvt.handle_exceptions (
1275: p_api_name => l_api_name,
1276: p_pkg_name => g_pkg_name,
1277: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
1278: p_package_type => aso_utility_pvt.g_int,
1279: p_sqlcode => SQLCODE,
1280: p_sqlerrm => SQLERRM,
1281: x_msg_count => x_msg_count,

Line 1410: fnd_msg_pub.initialize;

1406: IF fnd_api.to_boolean (
1407: p_init_msg_list
1408: )
1409: THEN
1410: fnd_msg_pub.initialize;
1411: END IF;
1412:
1413: -- Initialize API return status to success
1414: x_return_status := fnd_api.g_ret_sts_success;

Line 1424: FND_MSG_PUB.ADD;

1420:
1421: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
1422: FND_MESSAGE.Set_Token ('COLUMN' , 'P_Object_approval_id', FALSE );
1423: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Object_approval_id ) , FALSE );
1424: FND_MSG_PUB.ADD;
1425: RAISE FND_API.G_EXC_ERROR;
1426: END IF;
1427:
1428: IF (p_object_approval_id IS NULL)

Line 1493: fnd_msg_pub.count_and_get(p_encoded => 'F',

1489: END IF;
1490: COMMIT WORK;
1491: END IF;
1492:
1493: fnd_msg_pub.count_and_get(p_encoded => 'F',
1494: p_count => x_msg_count,
1495: p_data => x_msg_data);
1496: for k in 1..x_msg_count loop
1497: x_msg_data := fnd_msg_pub.get(p_msg_index => k,

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

1493: fnd_msg_pub.count_and_get(p_encoded => 'F',
1494: p_count => x_msg_count,
1495: p_data => x_msg_data);
1496: for k in 1..x_msg_count loop
1497: x_msg_data := fnd_msg_pub.get(p_msg_index => k,
1498: p_encoded => 'F');
1499: end loop;
1500:
1501: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1521: p_exception_level => fnd_msg_pub.g_msg_lvl_error,

1517: END IF;
1518: aso_utility_pvt.handle_exceptions (
1519: p_api_name => l_api_name,
1520: p_pkg_name => g_pkg_name,
1521: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
1522: p_package_type => aso_utility_pvt.g_int,
1523: p_sqlcode => SQLCODE,
1524: p_sqlerrm => SQLERRM,
1525: x_msg_count => x_msg_count,

Line 1541: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,

1537: END IF;
1538: aso_utility_pvt.handle_exceptions (
1539: p_api_name => l_api_name,
1540: p_pkg_name => g_pkg_name,
1541: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
1542: p_package_type => aso_utility_pvt.g_int,
1543: p_sqlcode => SQLCODE,
1544: p_sqlerrm => SQLERRM,
1545: x_msg_count => x_msg_count,

Line 1612: fnd_msg_pub.initialize;

1608: IF fnd_api.to_boolean (
1609: p_init_msg_list
1610: )
1611: THEN
1612: fnd_msg_pub.initialize;
1613: END IF;
1614:
1615: -- Initialize API return status to success
1616: x_return_status := fnd_api.g_ret_sts_success;

Line 1710: fnd_msg_pub.initialize;

1706: IF fnd_api.to_boolean (
1707: p_init_msg_list
1708: )
1709: THEN
1710: fnd_msg_pub.initialize;
1711: END IF;
1712:
1713: -- Initialize API return status to success
1714: x_return_status := fnd_api.g_ret_sts_success;

Line 1767: p_exception_level => fnd_msg_pub.g_msg_lvl_error,

1763: THEN
1764: aso_utility_pvt.handle_exceptions (
1765: p_api_name => l_api_name,
1766: p_pkg_name => g_pkg_name,
1767: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
1768: p_package_type => aso_utility_pvt.g_int,
1769: p_sqlcode => SQLCODE,
1770: p_sqlerrm => SQLERRM,
1771: x_msg_count => x_msg_count,

Line 1780: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,

1776: THEN
1777: aso_utility_pvt.handle_exceptions (
1778: p_api_name => l_api_name,
1779: p_pkg_name => g_pkg_name,
1780: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
1781: p_package_type => aso_utility_pvt.g_int,
1782: p_sqlcode => SQLCODE,
1783: p_sqlerrm => SQLERRM,
1784: x_msg_count => x_msg_count,

Line 1864: fnd_msg_pub.initialize;

1860: IF fnd_api.to_boolean (
1861: p_init_msg_list
1862: )
1863: THEN
1864: fnd_msg_pub.initialize;
1865: END IF;
1866:
1867: -- Initialize API return status to success
1868: x_return_status := fnd_api.g_ret_sts_success;

Line 1875: FND_MSG_PUB.ADD;

1871: IF ((P_Object_approval_id IS NULL) OR (P_Object_approval_id = FND_API.G_MISS_NUM)) THEN
1872: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
1873: FND_MESSAGE.Set_Token ('COLUMN' , 'P_Object_approval_id', FALSE );
1874: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Object_approval_id ) , FALSE );
1875: FND_MSG_PUB.ADD;
1876: RAISE FND_API.G_EXC_ERROR;
1877: ELSIF ((P_itemtype IS NULL) OR (P_itemtype = FND_API.G_MISS_CHAR)) THEN
1878: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
1879: FND_MESSAGE.Set_Token ('COLUMN' , 'P_Object_approval_id', FALSE );

Line 1881: FND_MSG_PUB.ADD;

1877: ELSIF ((P_itemtype IS NULL) OR (P_itemtype = FND_API.G_MISS_CHAR)) THEN
1878: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
1879: FND_MESSAGE.Set_Token ('COLUMN' , 'P_Object_approval_id', FALSE );
1880: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Object_approval_id ) , FALSE );
1881: FND_MSG_PUB.ADD;
1882: RAISE FND_API.G_EXC_ERROR;
1883: END IF;
1884:
1885: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1924: fnd_msg_pub.count_and_get(p_encoded => 'F',

1920: END IF;
1921: COMMIT WORK;
1922: END IF;
1923:
1924: fnd_msg_pub.count_and_get(p_encoded => 'F',
1925: p_count => x_msg_count,
1926: p_data => x_msg_data);
1927: for k in 1..x_msg_count loop
1928: x_msg_data := fnd_msg_pub.get(p_msg_index => k,

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

1924: fnd_msg_pub.count_and_get(p_encoded => 'F',
1925: p_count => x_msg_count,
1926: p_data => x_msg_data);
1927: for k in 1..x_msg_count loop
1928: x_msg_data := fnd_msg_pub.get(p_msg_index => k,
1929: p_encoded => 'F');
1930: end loop;
1931:
1932:

Line 1949: p_exception_level => fnd_msg_pub.g_msg_lvl_error,

1945: THEN
1946: aso_utility_pvt.handle_exceptions (
1947: p_api_name => l_api_name,
1948: p_pkg_name => g_pkg_name,
1949: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
1950: p_package_type => aso_utility_pvt.g_int,
1951: p_sqlcode => SQLCODE,
1952: p_sqlerrm => SQLERRM,
1953: x_msg_count => x_msg_count,

Line 1962: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,

1958: THEN
1959: aso_utility_pvt.handle_exceptions (
1960: p_api_name => l_api_name,
1961: p_pkg_name => g_pkg_name,
1962: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
1963: p_package_type => aso_utility_pvt.g_int,
1964: p_sqlcode => SQLCODE,
1965: p_sqlerrm => SQLERRM,
1966: x_msg_count => x_msg_count,

Line 2033: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2029:
2030: Open c_get_qte_info(p_qte_hdr_id);
2031: Fetch c_get_qte_info into l_LAST_UPDATE_DATE,l_object_version_number;
2032: If ( c_get_qte_info%NOTFOUND) Then
2033: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2034: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_UPDATE_TARGET');
2035: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
2036: FND_MSG_PUB.Add;
2037: END IF;

Line 2036: FND_MSG_PUB.Add;

2032: If ( c_get_qte_info%NOTFOUND) Then
2033: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2034: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_UPDATE_TARGET');
2035: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
2036: FND_MSG_PUB.Add;
2037: END IF;
2038: raise FND_API.G_EXC_ERROR;
2039: END IF;
2040: Close c_get_qte_info;

Line 2048: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2044: aso_debug_pub.add('upd_status_self_appr: l_object_version_number: '|| l_object_version_number,1,'Y');
2045: END IF;
2046:
2047: If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then
2048: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2049: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
2050: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
2051: FND_MSG_PUB.ADD;
2052: END IF;

Line 2051: FND_MSG_PUB.ADD;

2047: If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then
2048: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2049: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
2050: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
2051: FND_MSG_PUB.ADD;
2052: END IF;
2053: raise FND_API.G_EXC_ERROR;
2054: End if;
2055:

Line 2058: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2054: End if;
2055:
2056: -- Check Whether record has been changed by someone else
2057: If ( (l_last_update_date <> p_last_update_date ) OR (l_object_version_number <> p_obj_ver_num ) ) Then
2058: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2059: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
2060: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
2061: FND_MSG_PUB.ADD;
2062: END IF;

Line 2061: FND_MSG_PUB.ADD;

2057: If ( (l_last_update_date <> p_last_update_date ) OR (l_object_version_number <> p_obj_ver_num ) ) Then
2058: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2059: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
2060: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
2061: FND_MSG_PUB.ADD;
2062: END IF;
2063: raise FND_API.G_EXC_ERROR;
2064: End if;
2065:

Line 2085: fnd_msg_pub.count_and_get(p_encoded => 'F',

2081: last_update_date = x_last_update_date
2082: where quote_header_id = p_qte_hdr_id;
2083:
2084:
2085: fnd_msg_pub.count_and_get(p_encoded => 'F',
2086: p_count => x_msg_count,
2087: p_data => x_msg_data);
2088: for k in 1..x_msg_count loop
2089: x_msg_data := fnd_msg_pub.get(p_msg_index => k,

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

2085: fnd_msg_pub.count_and_get(p_encoded => 'F',
2086: p_count => x_msg_count,
2087: p_data => x_msg_data);
2088: for k in 1..x_msg_count loop
2089: x_msg_data := fnd_msg_pub.get(p_msg_index => k,
2090: p_encoded => 'F');
2091: end loop;
2092:
2093: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 2103: p_exception_level => fnd_msg_pub.g_msg_lvl_error,

2099: THEN
2100: aso_utility_pvt.handle_exceptions (
2101: p_api_name => l_api_name,
2102: p_pkg_name => g_pkg_name,
2103: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
2104: p_package_type => aso_utility_pvt.g_int,
2105: p_sqlcode => SQLCODE,
2106: p_sqlerrm => SQLERRM,
2107: x_msg_count => x_msg_count,

Line 2116: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,

2112: THEN
2113: aso_utility_pvt.handle_exceptions (
2114: p_api_name => l_api_name,
2115: p_pkg_name => g_pkg_name,
2116: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
2117: p_package_type => aso_utility_pvt.g_int,
2118: p_sqlcode => SQLCODE,
2119: p_sqlerrm => SQLERRM,
2120: x_msg_count => x_msg_count,