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

Line 153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

149: WHEN FND_API.G_EXC_ERROR THEN
150: p_return_status := FND_API.G_RET_STS_ERROR;
151: WHEN OTHERS THEN
152: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
154: SUBSTR (SQLERRM, 1, 240) );
155: end APPEND_BUFFER_TABLES;
156:
157: --==============================================

Line 263: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

259: (p_application_short_name is null)) and
260: ((p_application_id = FND_API.G_MISS_NUM) or
261: (p_application_id is null)) and
262: (p_table_size = 0) then
263: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
264: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
265: FND_MSG_PUB.Add;
266: end if;
267: raise FND_API.G_EXC_ERROR;

Line 265: FND_MSG_PUB.Add;

261: (p_application_id is null)) and
262: (p_table_size = 0) then
263: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
264: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
265: FND_MSG_PUB.Add;
266: end if;
267: raise FND_API.G_EXC_ERROR;
268: end if;
269:

Line 282: --if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

278:
279: -- /** Since we pass appl short name only from Java wrapper, this
280: -- meesage is not necessary **/
281: --if (p_application_id <> FND_API.G_MISS_NUM) then
282: --if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
283: -- FND_MESSAGE.SET_NAME('AK','AK_APPL_SHORT_NAME_IGNORED');
284: -- FND_MSG_PUB.Add;
285: --end if;
286: --else

Line 284: -- FND_MSG_PUB.Add;

280: -- meesage is not necessary **/
281: --if (p_application_id <> FND_API.G_MISS_NUM) then
282: --if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
283: -- FND_MESSAGE.SET_NAME('AK','AK_APPL_SHORT_NAME_IGNORED');
284: -- FND_MSG_PUB.Add;
285: --end if;
286: --else
287: -- /***********************************************/
288: if (p_application_id = FND_API.G_MISS_NUM) then

Line 292: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

288: if (p_application_id = FND_API.G_MISS_NUM) then
289: open l_get_appl_id_csr(p_application_short_name);
290: fetch l_get_appl_id_csr into l_application_id;
291: if (l_get_appl_id_csr%notfound) then
292: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
293: FND_MESSAGE.SET_NAME('AK','AK_APPL_SHORT_NAME_INVALID');
294: FND_MESSAGE.SET_TOKEN('APPL_SHORT_NAME', p_application_short_name);
295: FND_MSG_PUB.Add;
296: end if;

Line 295: FND_MSG_PUB.Add;

291: if (l_get_appl_id_csr%notfound) then
292: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
293: FND_MESSAGE.SET_NAME('AK','AK_APPL_SHORT_NAME_INVALID');
294: FND_MESSAGE.SET_TOKEN('APPL_SHORT_NAME', p_application_short_name);
295: FND_MSG_PUB.Add;
296: end if;
297: close l_get_appl_id_csr;
298: raise FND_API.G_EXC_ERROR;
299: end if;

Line 2027: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2023: p_return_status := FND_API.G_RET_STS_SUCCESS;
2024:
2025: EXCEPTION
2026: WHEN FND_API.G_EXC_ERROR THEN
2027: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2028: FND_MESSAGE.SET_NAME('AK','AK_HEADER_DOWNLOAD_ERROR');
2029: FND_MSG_PUB.Add;
2030: end if;
2031: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2029: FND_MSG_PUB.Add;

2025: EXCEPTION
2026: WHEN FND_API.G_EXC_ERROR THEN
2027: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2028: FND_MESSAGE.SET_NAME('AK','AK_HEADER_DOWNLOAD_ERROR');
2029: FND_MSG_PUB.Add;
2030: end if;
2031: p_return_status := FND_API.G_RET_STS_ERROR;
2032: WHEN OTHERS THEN
2033: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2034: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

2030: end if;
2031: p_return_status := FND_API.G_RET_STS_ERROR;
2032: WHEN OTHERS THEN
2033: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2034: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
2035: SUBSTR (SQLERRM, 1, 240) );
2036: end DOWNLOAD_HEADER;
2037:
2038: --==============================================

Line 2108: FND_MSG_PUB.initialize;

2104:
2105: -- Initialize the message table if requested.
2106:
2107: if p_init_msg_tbl then
2108: FND_MSG_PUB.initialize;
2109: end if;
2110:
2111: --dbms_output.put_line(to_char(l_timestamp));
2112:

Line 2183: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2179: -- if we cannot even get one non-blank, non-comment line from
2180: -- the file, there is nothing to be processed in this file
2181: --
2182: if (l_buffer is null and l_eof_flag = 'Y' and l_tbl_index = G_UPL_TABLE_NUM) then
2183: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2184: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_FILE');
2185: FND_MSG_PUB.Add;
2186: end if;
2187: RAISE FND_API.G_EXC_ERROR;

Line 2185: FND_MSG_PUB.Add;

2181: --
2182: if (l_buffer is null and l_eof_flag = 'Y' and l_tbl_index = G_UPL_TABLE_NUM) then
2183: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2184: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_FILE');
2185: FND_MSG_PUB.Add;
2186: end if;
2187: RAISE FND_API.G_EXC_ERROR;
2188: end if;
2189:

Line 2207: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2203: );
2204:
2205: if (l_return_status = FND_API.G_RET_STS_ERROR) or
2206: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2207: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2208: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
2209: FND_MSG_PUB.Add;
2210: end if;
2211: raise FND_API.G_EXC_ERROR;

Line 2209: FND_MSG_PUB.Add;

2205: if (l_return_status = FND_API.G_RET_STS_ERROR) or
2206: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2207: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2208: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
2209: FND_MSG_PUB.Add;
2210: end if;
2211: raise FND_API.G_EXC_ERROR;
2212: end if;
2213: --dbms_output.put_line(' State:' || l_state || 'Token:' || l_token);

Line 2225: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2221: -- Check for missing header info
2222: -- Language and codeset, and extract_by_object are required.
2223: --
2224: if (l_language is null) or (l_extract_by_obj is null) then
2225: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2226: FND_MESSAGE.SET_NAME('AK','AK_HEADER_INFO_MISSING');
2227: FND_MSG_PUB.Add;
2228: end if;
2229: raise FND_API.G_EXC_ERROR;

Line 2227: FND_MSG_PUB.Add;

2223: --
2224: if (l_language is null) or (l_extract_by_obj is null) then
2225: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2226: FND_MESSAGE.SET_NAME('AK','AK_HEADER_INFO_MISSING');
2227: FND_MSG_PUB.Add;
2228: end if;
2229: raise FND_API.G_EXC_ERROR;
2230: else
2231: -- dbms_output.put_line('l_language is ' || l_language);

Line 2243: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2239: l_state := 1;
2240: elsif (l_token = 'DEFINE') then
2241: l_state := 10;
2242: else
2243: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2244: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2245: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2246: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2247: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN, LANGUAGE, CODESET, ' ||

Line 2249: FND_MSG_PUB.Add;

2245: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2246: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2247: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN, LANGUAGE, CODESET, ' ||
2248: 'EXTRACT_BY_OBJECT, EXTRACT_BY_APPLICATION');
2249: FND_MSG_PUB.Add;
2250: end if;
2251: raise FND_API.G_EXC_ERROR;
2252: end if; -- endif of (l_token = 'BEGIN')
2253: elsif (l_state = 1) then

Line 2257: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2253: elsif (l_state = 1) then
2254: if (l_token = '=') then
2255: l_state := 2;
2256: else
2257: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2258: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2259: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2260: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2261: FND_MESSAGE.SET_TOKEN('EXPECTED','=');

Line 2262: FND_MSG_PUB.Add;

2258: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2259: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2260: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2261: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
2262: FND_MSG_PUB.Add;
2263: end if;
2264: --dbms_output.put_line('Expecting =');
2265: raise FND_API.G_EXC_ERROR;
2266: end if;

Line 2279: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2275: AK_ON_OBJECTS_PVT.G_CUSTOM_REGION,
2276: AK_ON_OBJECTS_PVT.G_SECURITY,
2277: AK_ON_OBJECTS_PVT.G_QUERYOBJ,
2278: AK_ON_OBJECTS_PVT.G_AMPARAM_REGISTRY) ) then
2279: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2280: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
2281: FND_MESSAGE.SET_TOKEN('COLUMN','EXTRACT_BY_OBJECT');
2282: FND_MSG_PUB.Add;
2283: end if;

Line 2282: FND_MSG_PUB.Add;

2278: AK_ON_OBJECTS_PVT.G_AMPARAM_REGISTRY) ) then
2279: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2280: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
2281: FND_MESSAGE.SET_TOKEN('COLUMN','EXTRACT_BY_OBJECT');
2282: FND_MSG_PUB.Add;
2283: end if;
2284: raise FND_API.G_EXC_ERROR;
2285: else
2286: l_extract_by_obj := UPPER(l_token);

Line 2307: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2303: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 and
2304: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12 and
2305: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14 and
2306: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15) then
2307: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2308: FND_MESSAGE.SET_NAME('AK','AK_WRONG_FILE_VERSION');
2309: FND_MSG_PUB.Add;
2310: end if;
2311: raise FND_API.G_EXC_ERROR;

Line 2309: FND_MSG_PUB.Add;

2305: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14 and
2306: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15) then
2307: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2308: FND_MESSAGE.SET_NAME('AK','AK_WRONG_FILE_VERSION');
2309: FND_MSG_PUB.Add;
2310: end if;
2311: raise FND_API.G_EXC_ERROR;
2312: end if; -- end if l_file_version
2313: else

Line 2314: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2310: end if;
2311: raise FND_API.G_EXC_ERROR;
2312: end if; -- end if l_file_version
2313: else
2314: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2315: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2316: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2317: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2318: FND_MESSAGE.SET_TOKEN('EXPECTED',l_column);

Line 2319: FND_MSG_PUB.Add;

2315: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2316: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2317: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2318: FND_MESSAGE.SET_TOKEN('EXPECTED',l_column);
2319: FND_MSG_PUB.Add;
2320: end if;
2321: -- dbms_output.put_line('Expecting ' || l_column || ' value');
2322: raise FND_API.G_EXC_ERROR;
2323: end if;

Line 2329: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2325: elsif (l_state = 4) then
2326: if (l_token = 'BEGIN') then
2327: l_state := 5;
2328: else
2329: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2330: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2331: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2332: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2333: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');

Line 2334: FND_MSG_PUB.Add;

2330: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2331: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2332: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2333: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
2334: FND_MSG_PUB.Add;
2335: end if;
2336: -- dbms_output.put_line('Expecting BEGIN');
2337: raise FND_API.G_EXC_ERROR;
2338: end if;

Line 2675: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2671:
2672: else
2673: -- dbms_output.put_line('Expecting ATTRIBUTE, OBJECT, REGION, FLOW,
2674: -- EXCLUDED_ITEMS or RESP_SECURITY_ATTRIBUTES');
2675: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2676: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2677: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2678: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2679: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE, OBJECT, REGION,

Line 2681: FND_MSG_PUB.Add;

2677: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2678: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2679: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE, OBJECT, REGION,
2680: FLOW, EXCLUDED_ITEMS, RESP_SECURITY_ATTRIBUTES OR QUERY_OBJECT');
2681: FND_MSG_PUB.Add;
2682: end if;
2683: raise FND_API.G_EXC_ERROR;
2684: end if;
2685: l_state := 4;

Line 2697: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2693: --
2694: if (l_token = 'END') then
2695: l_state := 12;
2696: elsif (l_token = 'BEGIN') then
2697: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2698: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2699: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2700: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2701: FND_MESSAGE.SET_TOKEN('EXPECTED', 'END ' || l_object_name);

Line 2702: FND_MSG_PUB.Add;

2698: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2699: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2700: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2701: FND_MESSAGE.SET_TOKEN('EXPECTED', 'END ' || l_object_name);
2702: FND_MSG_PUB.Add;
2703: end if;
2704: raise FND_API.G_EXC_ERROR;
2705: end if;
2706: elsif (l_state = 12) then

Line 2757: -- FND_MSG_PUB.Add;

2753: --
2754: -- dbms_output.put_line(to_char(l_line_num) || ' lines processed.');
2755: -- FND_MESSAGE.SET_NAME('AK','AK_LINES_PROCESSED');
2756: -- FND_MESSAGE.SET_TOKEN('NUMLINES', to_char(l_line_num));
2757: -- FND_MSG_PUB.Add;
2758:
2759: -- ************* Starts second pass *****************
2760:
2761: l_index := 2;

Line 2767: FND_MSG_PUB.Add;

2763: -- Write message informing user whether this is the first pass or the
2764: -- second pass at reading the input file
2765: --
2766: FND_MESSAGE.SET_NAME('AK','AK_UPLOAD_PASS2' || to_char(l_index));
2767: FND_MSG_PUB.Add;
2768:
2769: AK_ATTRIBUTE_PVT.UPLOAD_ATTRIBUTE_SECOND (
2770: p_validation_level => p_validation_level,
2771: p_return_status => l_return_status,

Line 2840: FND_MSG_PUB.Count_And_Get (

2836: -- deleted, call ak_attribute_pvt.delete with cascade = 'N'.
2837:
2838: p_return_status := FND_API.G_RET_STS_SUCCESS;
2839:
2840: FND_MSG_PUB.Count_And_Get (
2841: p_count => p_msg_count,
2842: p_data => p_msg_data);
2843:
2844: EXCEPTION

Line 2847: FND_MSG_PUB.Count_And_Get (

2843:
2844: EXCEPTION
2845: WHEN FND_API.G_EXC_ERROR THEN
2846: p_return_status := FND_API.G_RET_STS_ERROR;
2847: FND_MSG_PUB.Count_And_Get (
2848: p_count => p_msg_count,
2849: p_data => p_msg_data);
2850: WHEN OTHERS THEN
2851: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2852: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

2848: p_count => p_msg_count,
2849: p_data => p_msg_data);
2850: WHEN OTHERS THEN
2851: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2852: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
2853: SUBSTR (SQLERRM, 1, 240) );
2854: FND_MSG_PUB.Count_And_Get (
2855: p_count => p_msg_count,
2856: p_data => p_msg_data);

Line 2854: FND_MSG_PUB.Count_And_Get (

2850: WHEN OTHERS THEN
2851: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2852: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
2853: SUBSTR (SQLERRM, 1, 240) );
2854: FND_MSG_PUB.Count_And_Get (
2855: p_count => p_msg_count,
2856: p_data => p_msg_data);
2857: end UPLOAD;
2858:

Line 2975: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

2971: WHEN FND_API.G_EXC_ERROR THEN
2972: p_return_status := FND_API.G_RET_STS_ERROR;
2973: WHEN OTHERS THEN
2974: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2975: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
2976: SUBSTR (SQLERRM, 1, 240) );
2977: end GET_TOKEN;
2978:
2979: --=======================================================

Line 3093: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

3089:
3090: EXCEPTION
3091: WHEN NO_DATA_FOUND THEN
3092: if not l_done then
3093: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3094: FND_MESSAGE.SET_NAME('AK','AK_UNEXPECTED_EOF_ERROR');
3095: FND_MSG_PUB.Add;
3096: p_return_status := FND_API.G_RET_STS_ERROR;
3097: end if;

Line 3095: FND_MSG_PUB.Add;

3091: WHEN NO_DATA_FOUND THEN
3092: if not l_done then
3093: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3094: FND_MESSAGE.SET_NAME('AK','AK_UNEXPECTED_EOF_ERROR');
3095: FND_MSG_PUB.Add;
3096: p_return_status := FND_API.G_RET_STS_ERROR;
3097: end if;
3098: end if;
3099: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3106: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

3102: p_index := l_index;
3103: WHEN INVALID_CURSOR THEN
3104: --dbms_output.put_line('Invalid cursor');
3105: if not l_done then
3106: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3107: FND_MESSAGE.SET_NAME('AK','AK_UNEXPECTED_EOF_ERROR');
3108: FND_MSG_PUB.Add;
3109: end if;
3110: end if;

Line 3108: FND_MSG_PUB.Add;

3104: --dbms_output.put_line('Invalid cursor');
3105: if not l_done then
3106: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3107: FND_MESSAGE.SET_NAME('AK','AK_UNEXPECTED_EOF_ERROR');
3108: FND_MSG_PUB.Add;
3109: end if;
3110: end if;
3111: p_return_status := FND_API.G_RET_STS_ERROR;
3112: p_lines_read := l_lines_read;

Line 3117: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

3113: p_eof_flag := 'Y';
3114: p_index := l_index;
3115: WHEN OTHERS THEN
3116: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3117: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3118: SUBSTR (SQLERRM, 1, 240) );
3119: p_eof_flag := 'Y';
3120: p_lines_read := l_lines_read;
3121: end READ_LINE;

Line 3196: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

3192: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12) then
3193: if (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = FALSE) then
3194: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_loader_timestamp;
3195: elsif (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE) then
3196: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3197: FND_MESSAGE.SET_NAME('AK','AK_MISSING_GEN_DATE');
3198: FND_MSG_PUB.Add;
3199: end if;
3200: raise FND_API.G_EXC_ERROR;

Line 3198: FND_MSG_PUB.Add;

3194: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_loader_timestamp;
3195: elsif (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE) then
3196: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3197: FND_MESSAGE.SET_NAME('AK','AK_MISSING_GEN_DATE');
3198: FND_MSG_PUB.Add;
3199: end if;
3200: raise FND_API.G_EXC_ERROR;
3201: end if;
3202: p_created_by := 1;

Line 3233: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

3229: WHEN FND_API.G_EXC_ERROR THEN
3230: p_return_status := FND_API.G_RET_STS_ERROR;
3231: WHEN OTHERS THEN
3232: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3233: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3234: SUBSTR (SQLERRM, 1, 240) );
3235: END SET_WHO;
3236:
3237:

Line 3446: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

3442: -- indicate error if write mode is not G_APPEND or G_OVERWRITE
3443: --
3444: if (p_write_mode <> AK_ON_OBJECTS_PUB.G_APPEND) and
3445: (p_write_mode <> AK_ON_OBJECTS_PUB.G_OVERWRITE) then
3446: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3447: FND_MESSAGE.SET_NAME('AK','AK_INVALID_WRITE_MODE');
3448: FND_MSG_PUB.Add;
3449: end if;
3450: raise FND_API.G_EXC_ERROR;

Line 3448: FND_MSG_PUB.Add;

3444: if (p_write_mode <> AK_ON_OBJECTS_PUB.G_APPEND) and
3445: (p_write_mode <> AK_ON_OBJECTS_PUB.G_OVERWRITE) then
3446: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3447: FND_MESSAGE.SET_NAME('AK','AK_INVALID_WRITE_MODE');
3448: FND_MSG_PUB.Add;
3449: end if;
3450: raise FND_API.G_EXC_ERROR;
3451: end if;
3452:

Line 3512: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

3508: WHEN FND_API.G_EXC_ERROR THEN
3509: p_return_status := FND_API.G_RET_STS_ERROR;
3510: WHEN OTHERS THEN
3511: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3512: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3513: SUBSTR (SQLERRM, 1, 240) );
3514: end WRITE_FILE;
3515:
3516: --=======================================================

Line 3572: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

3568: -- indicate error if write mode is not G_APPEND or G_OVERWRITE
3569: --
3570: if (p_write_mode <> AK_ON_OBJECTS_PUB.G_APPEND) and
3571: (p_write_mode <> AK_ON_OBJECTS_PUB.G_OVERWRITE) then
3572: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3573: FND_MESSAGE.SET_NAME('AK','AK_INVALID_WRITE_MODE');
3574: FND_MSG_PUB.Add;
3575: end if;
3576: raise FND_API.G_EXC_ERROR;

Line 3574: FND_MSG_PUB.Add;

3570: if (p_write_mode <> AK_ON_OBJECTS_PUB.G_APPEND) and
3571: (p_write_mode <> AK_ON_OBJECTS_PUB.G_OVERWRITE) then
3572: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3573: FND_MESSAGE.SET_NAME('AK','AK_INVALID_WRITE_MODE');
3574: FND_MSG_PUB.Add;
3575: end if;
3576: raise FND_API.G_EXC_ERROR;
3577: end if;
3578:

Line 3625: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

3621:
3622: EXCEPTION
3623: WHEN STORAGE_ERROR THEN
3624: p_return_status := FND_API.G_RET_STS_ERROR;
3625: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3626: SUBSTR (SQLERRM, 1, 240) );
3627: WHEN OTHERS THEN
3628: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3629: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

Line 3629: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

3625: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3626: SUBSTR (SQLERRM, 1, 240) );
3627: WHEN OTHERS THEN
3628: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3629: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3630: SUBSTR (SQLERRM, 1, 240) );
3631: end WRITE_LOG_FILE;
3632:
3633:

Line 3668: FND_MSG_PUB.Add;

3664: EXCEPTION
3665: WHEN insert_err THEN
3666: -- dbms_output.put_line('Exception insert_err ak_loader_temp');
3667: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_EXCEPTION');
3668: FND_MSG_PUB.Add;
3669: WHEN OTHERS THEN
3670: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_ERROR');
3671: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3672: SUBSTR (SQLERRM, 1, 240) );

Line 3671: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

3667: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_EXCEPTION');
3668: FND_MSG_PUB.Add;
3669: WHEN OTHERS THEN
3670: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_ERROR');
3671: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3672: SUBSTR (SQLERRM, 1, 240) );
3673: FND_MSG_PUB.Add;
3674: -- err_num := SQLCODE;
3675: -- err_msg := SUBSTR(SQLERRM, 1, 100);

Line 3673: FND_MSG_PUB.Add;

3669: WHEN OTHERS THEN
3670: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_ERROR');
3671: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3672: SUBSTR (SQLERRM, 1, 240) );
3673: FND_MSG_PUB.Add;
3674: -- err_num := SQLCODE;
3675: -- err_msg := SUBSTR(SQLERRM, 1, 100);
3676: -- dbms_output.put_line('Other errors in inserting into ak_loader_temp');
3677: -- dbms_output.put_line(to_char(err_num)||' '||err_msg);

Line 3744: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

3740: p_return_status := FND_API.G_RET_STS_ERROR;
3741: return FALSE;
3742: WHEN OTHERS THEN
3743: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3744: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3745: SUBSTR (SQLERRM, 1, 240) );
3746: return FALSE;
3747: end VALID_APPLICATION_ID;
3748:

Line 3816: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

3812: p_return_status := FND_API.G_RET_STS_ERROR;
3813: return FALSE;
3814: WHEN OTHERS THEN
3815: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3816: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3817: SUBSTR (SQLERRM, 1, 240) );
3818: return FALSE;
3819: end VALID_LOOKUP_CODE;
3820: