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.PV_USER_MGMT_PVT dependencies on FND_LOG

Line 2099: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2095: BEGIN
2096:
2097: FND_MSG_PUB.initialize;
2098:
2099: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2101: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2102: ,'Entered Post Approval procedure');
2103: END IF;

Line 2100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2096:
2097: FND_MSG_PUB.initialize;
2098:
2099: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2101: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2102: ,'Entered Post Approval procedure');
2103: END IF;
2104:

Line 2109: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2105: l_userreg_id := p_event.getValueForParameter('USERTYPEREG_ID');
2106: l_usertype_key := p_event.getValueForParameter('USER_TYPE_KEY');
2107: l_usertype_appId := p_event.getValueForParameter('APPID');
2108:
2109: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2110: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2111: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2112: ,'l_userreg_id=' || l_userreg_id || ',l_usertype_key=' || l_usertype_key || ',l_usertype_appId=' || l_usertype_appId);
2113: END IF;

Line 2110: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2106: l_usertype_key := p_event.getValueForParameter('USER_TYPE_KEY');
2107: l_usertype_appId := p_event.getValueForParameter('APPID');
2108:
2109: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2110: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2111: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2112: ,'l_userreg_id=' || l_userreg_id || ',l_usertype_key=' || l_usertype_key || ',l_usertype_appId=' || l_usertype_appId);
2113: END IF;
2114:

Line 2119: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2115: OPEN c_get_user_info(l_userreg_id, l_usertype_key);
2116: FETCH c_get_user_info into l_user_id, l_user_name, l_customer_id, l_user_type_id;
2117: CLOSE c_get_user_info;
2118:
2119: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2120: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2121: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2122: ,'After c_get_user_info: l_user_id' || l_user_id || ',l_user_name=' || l_user_name || ',l_customer_id=' || l_customer_id || ',l_user_type_id=' || l_user_type_id);
2123: END IF;

Line 2120: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2116: FETCH c_get_user_info into l_user_id, l_user_name, l_customer_id, l_user_type_id;
2117: CLOSE c_get_user_info;
2118:
2119: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2120: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2121: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2122: ,'After c_get_user_info: l_user_id' || l_user_id || ',l_user_name=' || l_user_name || ',l_customer_id=' || l_customer_id || ',l_user_type_id=' || l_user_type_id);
2123: END IF;
2124:

Line 2127: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2123: END IF;
2124:
2125: OPEN c_is_partner_user(l_user_type_id);
2126: FETCH c_is_partner_user into is_partner;
2127: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2128: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2129: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2130: ,'is_partner='|| to_char(is_partner) || ';');
2131: END IF;

Line 2128: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2124:
2125: OPEN c_is_partner_user(l_user_type_id);
2126: FETCH c_is_partner_user into is_partner;
2127: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2128: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2129: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2130: ,'is_partner='|| to_char(is_partner) || ';');
2131: END IF;
2132: if (c_is_partner_user%NOTFOUND or is_partner <> 1 ) then

Line 2133: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2129: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2130: ,'is_partner='|| to_char(is_partner) || ';');
2131: END IF;
2132: if (c_is_partner_user%NOTFOUND or is_partner <> 1 ) then
2133: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2134: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2135: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2136: ,'l_user_name:' || l_user_name || '-- This user is not a partner user; no action; returning SUCCESS');
2137: END IF;

Line 2134: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2130: ,'is_partner='|| to_char(is_partner) || ';');
2131: END IF;
2132: if (c_is_partner_user%NOTFOUND or is_partner <> 1 ) then
2133: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2134: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2135: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2136: ,'l_user_name:' || l_user_name || '-- This user is not a partner user; no action; returning SUCCESS');
2137: END IF;
2138: RETURN 'SUCCESS';

Line 2148: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2144: partner_user_rec.person_rel_party_id := l_customer_id;
2145: partner_user_rec.user_id := l_user_id;
2146: partner_user_rec.user_type_id := l_user_type_id;
2147:
2148: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2149: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2150: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2151: ,'this is a partner user; created partner user rec and going to call pv_user_mgmt_pvt.register_partner_user');
2152: END IF;

Line 2149: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2145: partner_user_rec.user_id := l_user_id;
2146: partner_user_rec.user_type_id := l_user_type_id;
2147:
2148: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2149: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2150: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2151: ,'this is a partner user; created partner user rec and going to call pv_user_mgmt_pvt.register_partner_user');
2152: END IF;
2153:

Line 2166: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2162: ,x_msg_count => x_msg_count
2163: ,x_msg_data => x_msg_data
2164: );
2165:
2166: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2167: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2168: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2169: ,'after call pv_user_mgmt_pvt.register_partner_user: x_return_status='|| x_return_status || ',x_msg_count=' || to_char(x_msg_count));
2170: END IF;

Line 2167: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2163: ,x_msg_data => x_msg_data
2164: );
2165:
2166: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2167: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2168: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2169: ,'after call pv_user_mgmt_pvt.register_partner_user: x_return_status='|| x_return_status || ',x_msg_count=' || to_char(x_msg_count));
2170: END IF;
2171:

Line 2179: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2175: p_data => x_msg_data
2176: );
2177:
2178: if (x_return_status = 'S') then
2179: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2180: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2181: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2182: ,'returning SUCCESS to the function');
2183: END IF;

Line 2180: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2176: );
2177:
2178: if (x_return_status = 'S') then
2179: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2180: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2181: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2182: ,'returning SUCCESS to the function');
2183: END IF;
2184: RETURN 'SUCCESS';

Line 2187: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2183: END IF;
2184: RETURN 'SUCCESS';
2185: else
2186:
2187: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2188: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2189: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2190: ,'x_return_status is not returning S');
2191: END IF;

Line 2188: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2184: RETURN 'SUCCESS';
2185: else
2186:
2187: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2188: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2189: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2190: ,'x_return_status is not returning S');
2191: END IF;
2192: FOR k IN 1 .. x_msg_count LOOP

Line 2200: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2196: ,p_data => x_msg_data
2197: ,p_msg_index_out => x_msg_index);
2198:
2199:
2200: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2201: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2202: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2203: ,'in the error msg loop: k=' || to_char(k)|| ',x_msg_data=' || x_msg_data);
2204: END IF;

Line 2201: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2197: ,p_msg_index_out => x_msg_index);
2198:
2199:
2200: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2201: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2202: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2203: ,'in the error msg loop: k=' || to_char(k)|| ',x_msg_data=' || x_msg_data);
2204: END IF;
2205: END LOOP;