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 145: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

141: WHEN FND_API.G_EXC_ERROR THEN
142: p_return_status := FND_API.G_RET_STS_ERROR;
143: WHEN OTHERS THEN
144: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
146: SUBSTR (SQLERRM, 1, 240) );
147: end APPEND_BUFFER_TABLES;
148:
149: --==============================================

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

251: (p_application_short_name is null)) and
252: ((p_application_id = FND_API.G_MISS_NUM) or
253: (p_application_id is null)) and
254: (p_table_size = 0) then
255: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
256: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
257: FND_MSG_PUB.Add;
258: end if;
259: raise FND_API.G_EXC_ERROR;

Line 257: FND_MSG_PUB.Add;

253: (p_application_id is null)) and
254: (p_table_size = 0) then
255: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
256: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
257: FND_MSG_PUB.Add;
258: end if;
259: raise FND_API.G_EXC_ERROR;
260: end if;
261:

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

270:
271: -- /** Since we pass appl short name only from Java wrapper, this
272: -- meesage is not necessary **/
273: --if (p_application_id <> FND_API.G_MISS_NUM) then
274: --if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
275: -- FND_MESSAGE.SET_NAME('AK','AK_APPL_SHORT_NAME_IGNORED');
276: -- FND_MSG_PUB.Add;
277: --end if;
278: --else

Line 276: -- FND_MSG_PUB.Add;

272: -- meesage is not necessary **/
273: --if (p_application_id <> FND_API.G_MISS_NUM) then
274: --if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
275: -- FND_MESSAGE.SET_NAME('AK','AK_APPL_SHORT_NAME_IGNORED');
276: -- FND_MSG_PUB.Add;
277: --end if;
278: --else
279: -- /***********************************************/
280: if (p_application_id = FND_API.G_MISS_NUM) then

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

280: if (p_application_id = FND_API.G_MISS_NUM) then
281: open l_get_appl_id_csr(p_application_short_name);
282: fetch l_get_appl_id_csr into l_application_id;
283: if (l_get_appl_id_csr%notfound) then
284: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
285: FND_MESSAGE.SET_NAME('AK','AK_APPL_SHORT_NAME_INVALID');
286: FND_MESSAGE.SET_TOKEN('APPL_SHORT_NAME', p_application_short_name);
287: FND_MSG_PUB.Add;
288: end if;

Line 287: FND_MSG_PUB.Add;

283: if (l_get_appl_id_csr%notfound) then
284: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
285: FND_MESSAGE.SET_NAME('AK','AK_APPL_SHORT_NAME_INVALID');
286: FND_MESSAGE.SET_TOKEN('APPL_SHORT_NAME', p_application_short_name);
287: FND_MSG_PUB.Add;
288: end if;
289: close l_get_appl_id_csr;
290: raise FND_API.G_EXC_ERROR;
291: end if;

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

2015: p_return_status := FND_API.G_RET_STS_SUCCESS;
2016:
2017: EXCEPTION
2018: WHEN FND_API.G_EXC_ERROR THEN
2019: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2020: FND_MESSAGE.SET_NAME('AK','AK_HEADER_DOWNLOAD_ERROR');
2021: FND_MSG_PUB.Add;
2022: end if;
2023: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2021: FND_MSG_PUB.Add;

2017: EXCEPTION
2018: WHEN FND_API.G_EXC_ERROR THEN
2019: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2020: FND_MESSAGE.SET_NAME('AK','AK_HEADER_DOWNLOAD_ERROR');
2021: FND_MSG_PUB.Add;
2022: end if;
2023: p_return_status := FND_API.G_RET_STS_ERROR;
2024: WHEN OTHERS THEN
2025: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2026: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

2022: end if;
2023: p_return_status := FND_API.G_RET_STS_ERROR;
2024: WHEN OTHERS THEN
2025: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2026: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
2027: SUBSTR (SQLERRM, 1, 240) );
2028: end DOWNLOAD_HEADER;
2029:
2030: --==============================================

Line 2100: FND_MSG_PUB.initialize;

2096:
2097: -- Initialize the message table if requested.
2098:
2099: if p_init_msg_tbl then
2100: FND_MSG_PUB.initialize;
2101: end if;
2102:
2103: --dbms_output.put_line(to_char(l_timestamp));
2104:

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

2171: -- if we cannot even get one non-blank, non-comment line from
2172: -- the file, there is nothing to be processed in this file
2173: --
2174: if (l_buffer is null and l_eof_flag = 'Y' and l_tbl_index = G_UPL_TABLE_NUM) then
2175: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2176: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_FILE');
2177: FND_MSG_PUB.Add;
2178: end if;
2179: RAISE FND_API.G_EXC_ERROR;

Line 2177: FND_MSG_PUB.Add;

2173: --
2174: if (l_buffer is null and l_eof_flag = 'Y' and l_tbl_index = G_UPL_TABLE_NUM) then
2175: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2176: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_FILE');
2177: FND_MSG_PUB.Add;
2178: end if;
2179: RAISE FND_API.G_EXC_ERROR;
2180: end if;
2181:

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

2195: );
2196:
2197: if (l_return_status = FND_API.G_RET_STS_ERROR) or
2198: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2199: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2200: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
2201: FND_MSG_PUB.Add;
2202: end if;
2203: raise FND_API.G_EXC_ERROR;

Line 2201: FND_MSG_PUB.Add;

2197: if (l_return_status = FND_API.G_RET_STS_ERROR) or
2198: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2199: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2200: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
2201: FND_MSG_PUB.Add;
2202: end if;
2203: raise FND_API.G_EXC_ERROR;
2204: end if;
2205: --dbms_output.put_line(' State:' || l_state || 'Token:' || l_token);

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

2213: -- Check for missing header info
2214: -- Language and codeset, and extract_by_object are required.
2215: --
2216: if (l_language is null) or (l_extract_by_obj is null) then
2217: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2218: FND_MESSAGE.SET_NAME('AK','AK_HEADER_INFO_MISSING');
2219: FND_MSG_PUB.Add;
2220: end if;
2221: raise FND_API.G_EXC_ERROR;

Line 2219: FND_MSG_PUB.Add;

2215: --
2216: if (l_language is null) or (l_extract_by_obj is null) then
2217: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2218: FND_MESSAGE.SET_NAME('AK','AK_HEADER_INFO_MISSING');
2219: FND_MSG_PUB.Add;
2220: end if;
2221: raise FND_API.G_EXC_ERROR;
2222: else
2223: -- dbms_output.put_line('l_language is ' || l_language);

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

2231: l_state := 1;
2232: elsif (l_token = 'DEFINE') then
2233: l_state := 10;
2234: else
2235: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2236: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2237: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2238: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2239: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN, LANGUAGE, CODESET, ' ||

Line 2241: FND_MSG_PUB.Add;

2237: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2238: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2239: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN, LANGUAGE, CODESET, ' ||
2240: 'EXTRACT_BY_OBJECT, EXTRACT_BY_APPLICATION');
2241: FND_MSG_PUB.Add;
2242: end if;
2243: raise FND_API.G_EXC_ERROR;
2244: end if; -- endif of (l_token = 'BEGIN')
2245: elsif (l_state = 1) then

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

2245: elsif (l_state = 1) then
2246: if (l_token = '=') then
2247: l_state := 2;
2248: else
2249: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2250: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2251: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2252: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2253: FND_MESSAGE.SET_TOKEN('EXPECTED','=');

Line 2254: FND_MSG_PUB.Add;

2250: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2251: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2252: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2253: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
2254: FND_MSG_PUB.Add;
2255: end if;
2256: --dbms_output.put_line('Expecting =');
2257: raise FND_API.G_EXC_ERROR;
2258: end if;

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

2267: AK_ON_OBJECTS_PVT.G_CUSTOM_REGION,
2268: AK_ON_OBJECTS_PVT.G_SECURITY,
2269: AK_ON_OBJECTS_PVT.G_QUERYOBJ,
2270: AK_ON_OBJECTS_PVT.G_AMPARAM_REGISTRY) ) then
2271: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2272: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
2273: FND_MESSAGE.SET_TOKEN('COLUMN','EXTRACT_BY_OBJECT');
2274: FND_MSG_PUB.Add;
2275: end if;

Line 2274: FND_MSG_PUB.Add;

2270: AK_ON_OBJECTS_PVT.G_AMPARAM_REGISTRY) ) then
2271: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2272: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
2273: FND_MESSAGE.SET_TOKEN('COLUMN','EXTRACT_BY_OBJECT');
2274: FND_MSG_PUB.Add;
2275: end if;
2276: raise FND_API.G_EXC_ERROR;
2277: else
2278: l_extract_by_obj := UPPER(l_token);

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

2295: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 and
2296: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12 and
2297: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14 and
2298: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15) then
2299: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2300: FND_MESSAGE.SET_NAME('AK','AK_WRONG_FILE_VERSION');
2301: FND_MSG_PUB.Add;
2302: end if;
2303: raise FND_API.G_EXC_ERROR;

Line 2301: FND_MSG_PUB.Add;

2297: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14 and
2298: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15) then
2299: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2300: FND_MESSAGE.SET_NAME('AK','AK_WRONG_FILE_VERSION');
2301: FND_MSG_PUB.Add;
2302: end if;
2303: raise FND_API.G_EXC_ERROR;
2304: end if; -- end if l_file_version
2305: else

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

2302: end if;
2303: raise FND_API.G_EXC_ERROR;
2304: end if; -- end if l_file_version
2305: else
2306: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2307: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2308: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2309: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2310: FND_MESSAGE.SET_TOKEN('EXPECTED',l_column);

Line 2311: FND_MSG_PUB.Add;

2307: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2308: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2309: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2310: FND_MESSAGE.SET_TOKEN('EXPECTED',l_column);
2311: FND_MSG_PUB.Add;
2312: end if;
2313: -- dbms_output.put_line('Expecting ' || l_column || ' value');
2314: raise FND_API.G_EXC_ERROR;
2315: end if;

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

2317: elsif (l_state = 4) then
2318: if (l_token = 'BEGIN') then
2319: l_state := 5;
2320: else
2321: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2322: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2323: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2324: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2325: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');

Line 2326: FND_MSG_PUB.Add;

2322: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2323: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2324: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2325: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
2326: FND_MSG_PUB.Add;
2327: end if;
2328: -- dbms_output.put_line('Expecting BEGIN');
2329: raise FND_API.G_EXC_ERROR;
2330: end if;

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

2576:
2577: else
2578: -- dbms_output.put_line('Expecting ATTRIBUTE, OBJECT, REGION, FLOW,
2579: -- EXCLUDED_ITEMS or RESP_SECURITY_ATTRIBUTES');
2580: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2581: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2582: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2583: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2584: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE, OBJECT, REGION,

Line 2586: FND_MSG_PUB.Add;

2582: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2583: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2584: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE, OBJECT, REGION,
2585: FLOW, EXCLUDED_ITEMS, RESP_SECURITY_ATTRIBUTES OR QUERY_OBJECT');
2586: FND_MSG_PUB.Add;
2587: end if;
2588: raise FND_API.G_EXC_ERROR;
2589: end if;
2590: l_state := 4;

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

2598: --
2599: if (l_token = 'END') then
2600: l_state := 12;
2601: elsif (l_token = 'BEGIN') then
2602: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2603: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2604: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2605: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2606: FND_MESSAGE.SET_TOKEN('EXPECTED', 'END ' || l_object_name);

Line 2607: FND_MSG_PUB.Add;

2603: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2604: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2605: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2606: FND_MESSAGE.SET_TOKEN('EXPECTED', 'END ' || l_object_name);
2607: FND_MSG_PUB.Add;
2608: end if;
2609: raise FND_API.G_EXC_ERROR;
2610: end if;
2611: elsif (l_state = 12) then

Line 2662: -- FND_MSG_PUB.Add;

2658: --
2659: -- dbms_output.put_line(to_char(l_line_num) || ' lines processed.');
2660: -- FND_MESSAGE.SET_NAME('AK','AK_LINES_PROCESSED');
2661: -- FND_MESSAGE.SET_TOKEN('NUMLINES', to_char(l_line_num));
2662: -- FND_MSG_PUB.Add;
2663:
2664: -- ************* Starts second pass *****************
2665:
2666: l_index := 2;

Line 2672: FND_MSG_PUB.Add;

2668: -- Write message informing user whether this is the first pass or the
2669: -- second pass at reading the input file
2670: --
2671: FND_MESSAGE.SET_NAME('AK','AK_UPLOAD_PASS2' || to_char(l_index));
2672: FND_MSG_PUB.Add;
2673:
2674: AK_ATTRIBUTE_PVT.UPLOAD_ATTRIBUTE_SECOND (
2675: p_validation_level => p_validation_level,
2676: p_return_status => l_return_status,

Line 2745: FND_MSG_PUB.Count_And_Get (

2741: -- deleted, call ak_attribute_pvt.delete with cascade = 'N'.
2742:
2743: p_return_status := FND_API.G_RET_STS_SUCCESS;
2744:
2745: FND_MSG_PUB.Count_And_Get (
2746: p_count => p_msg_count,
2747: p_data => p_msg_data);
2748:
2749: EXCEPTION

Line 2752: FND_MSG_PUB.Count_And_Get (

2748:
2749: EXCEPTION
2750: WHEN FND_API.G_EXC_ERROR THEN
2751: p_return_status := FND_API.G_RET_STS_ERROR;
2752: FND_MSG_PUB.Count_And_Get (
2753: p_count => p_msg_count,
2754: p_data => p_msg_data);
2755: WHEN OTHERS THEN
2756: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2757: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

2753: p_count => p_msg_count,
2754: p_data => p_msg_data);
2755: WHEN OTHERS THEN
2756: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2757: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
2758: SUBSTR (SQLERRM, 1, 240) );
2759: FND_MSG_PUB.Count_And_Get (
2760: p_count => p_msg_count,
2761: p_data => p_msg_data);

Line 2759: FND_MSG_PUB.Count_And_Get (

2755: WHEN OTHERS THEN
2756: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2757: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
2758: SUBSTR (SQLERRM, 1, 240) );
2759: FND_MSG_PUB.Count_And_Get (
2760: p_count => p_msg_count,
2761: p_data => p_msg_data);
2762: end UPLOAD;
2763:

Line 2880: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

2876: WHEN FND_API.G_EXC_ERROR THEN
2877: p_return_status := FND_API.G_RET_STS_ERROR;
2878: WHEN OTHERS THEN
2879: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2880: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
2881: SUBSTR (SQLERRM, 1, 240) );
2882: end GET_TOKEN;
2883:
2884: --=======================================================

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

2994:
2995: EXCEPTION
2996: WHEN NO_DATA_FOUND THEN
2997: if not l_done then
2998: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2999: FND_MESSAGE.SET_NAME('AK','AK_UNEXPECTED_EOF_ERROR');
3000: FND_MSG_PUB.Add;
3001: p_return_status := FND_API.G_RET_STS_ERROR;
3002: end if;

Line 3000: FND_MSG_PUB.Add;

2996: WHEN NO_DATA_FOUND THEN
2997: if not l_done then
2998: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2999: FND_MESSAGE.SET_NAME('AK','AK_UNEXPECTED_EOF_ERROR');
3000: FND_MSG_PUB.Add;
3001: p_return_status := FND_API.G_RET_STS_ERROR;
3002: end if;
3003: end if;
3004: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

3007: p_index := l_index;
3008: WHEN INVALID_CURSOR THEN
3009: --dbms_output.put_line('Invalid cursor');
3010: if not l_done then
3011: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3012: FND_MESSAGE.SET_NAME('AK','AK_UNEXPECTED_EOF_ERROR');
3013: FND_MSG_PUB.Add;
3014: end if;
3015: end if;

Line 3013: FND_MSG_PUB.Add;

3009: --dbms_output.put_line('Invalid cursor');
3010: if not l_done then
3011: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3012: FND_MESSAGE.SET_NAME('AK','AK_UNEXPECTED_EOF_ERROR');
3013: FND_MSG_PUB.Add;
3014: end if;
3015: end if;
3016: p_return_status := FND_API.G_RET_STS_ERROR;
3017: p_lines_read := l_lines_read;

Line 3022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

3018: p_eof_flag := 'Y';
3019: p_index := l_index;
3020: WHEN OTHERS THEN
3021: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3023: SUBSTR (SQLERRM, 1, 240) );
3024: p_eof_flag := 'Y';
3025: p_lines_read := l_lines_read;
3026: end READ_LINE;

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

3097: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12) then
3098: if (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = FALSE) then
3099: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_loader_timestamp;
3100: elsif (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE) then
3101: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3102: FND_MESSAGE.SET_NAME('AK','AK_MISSING_GEN_DATE');
3103: FND_MSG_PUB.Add;
3104: end if;
3105: raise FND_API.G_EXC_ERROR;

Line 3103: FND_MSG_PUB.Add;

3099: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_loader_timestamp;
3100: elsif (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE) then
3101: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3102: FND_MESSAGE.SET_NAME('AK','AK_MISSING_GEN_DATE');
3103: FND_MSG_PUB.Add;
3104: end if;
3105: raise FND_API.G_EXC_ERROR;
3106: end if;
3107: p_created_by := 1;

Line 3138: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

3134: WHEN FND_API.G_EXC_ERROR THEN
3135: p_return_status := FND_API.G_RET_STS_ERROR;
3136: WHEN OTHERS THEN
3137: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3138: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3139: SUBSTR (SQLERRM, 1, 240) );
3140: END SET_WHO;
3141:
3142:

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

3347: -- indicate error if write mode is not G_APPEND or G_OVERWRITE
3348: --
3349: if (p_write_mode <> AK_ON_OBJECTS_PUB.G_APPEND) and
3350: (p_write_mode <> AK_ON_OBJECTS_PUB.G_OVERWRITE) then
3351: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3352: FND_MESSAGE.SET_NAME('AK','AK_INVALID_WRITE_MODE');
3353: FND_MSG_PUB.Add;
3354: end if;
3355: raise FND_API.G_EXC_ERROR;

Line 3353: FND_MSG_PUB.Add;

3349: if (p_write_mode <> AK_ON_OBJECTS_PUB.G_APPEND) and
3350: (p_write_mode <> AK_ON_OBJECTS_PUB.G_OVERWRITE) then
3351: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3352: FND_MESSAGE.SET_NAME('AK','AK_INVALID_WRITE_MODE');
3353: FND_MSG_PUB.Add;
3354: end if;
3355: raise FND_API.G_EXC_ERROR;
3356: end if;
3357:

Line 3417: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

3413: WHEN FND_API.G_EXC_ERROR THEN
3414: p_return_status := FND_API.G_RET_STS_ERROR;
3415: WHEN OTHERS THEN
3416: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3417: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3418: SUBSTR (SQLERRM, 1, 240) );
3419: end WRITE_FILE;
3420:
3421: --=======================================================

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

3473: -- indicate error if write mode is not G_APPEND or G_OVERWRITE
3474: --
3475: if (p_write_mode <> AK_ON_OBJECTS_PUB.G_APPEND) and
3476: (p_write_mode <> AK_ON_OBJECTS_PUB.G_OVERWRITE) then
3477: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3478: FND_MESSAGE.SET_NAME('AK','AK_INVALID_WRITE_MODE');
3479: FND_MSG_PUB.Add;
3480: end if;
3481: raise FND_API.G_EXC_ERROR;

Line 3479: FND_MSG_PUB.Add;

3475: if (p_write_mode <> AK_ON_OBJECTS_PUB.G_APPEND) and
3476: (p_write_mode <> AK_ON_OBJECTS_PUB.G_OVERWRITE) then
3477: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3478: FND_MESSAGE.SET_NAME('AK','AK_INVALID_WRITE_MODE');
3479: FND_MSG_PUB.Add;
3480: end if;
3481: raise FND_API.G_EXC_ERROR;
3482: end if;
3483:

Line 3530: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

3526:
3527: EXCEPTION
3528: WHEN STORAGE_ERROR THEN
3529: p_return_status := FND_API.G_RET_STS_ERROR;
3530: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3531: SUBSTR (SQLERRM, 1, 240) );
3532: WHEN OTHERS THEN
3533: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3534: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

Line 3534: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

3530: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3531: SUBSTR (SQLERRM, 1, 240) );
3532: WHEN OTHERS THEN
3533: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3534: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3535: SUBSTR (SQLERRM, 1, 240) );
3536: end WRITE_LOG_FILE;
3537:
3538:

Line 3573: FND_MSG_PUB.Add;

3569: EXCEPTION
3570: WHEN insert_err THEN
3571: -- dbms_output.put_line('Exception insert_err ak_loader_temp');
3572: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_EXCEPTION');
3573: FND_MSG_PUB.Add;
3574: WHEN OTHERS THEN
3575: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_ERROR');
3576: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3577: SUBSTR (SQLERRM, 1, 240) );

Line 3576: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

3572: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_EXCEPTION');
3573: FND_MSG_PUB.Add;
3574: WHEN OTHERS THEN
3575: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_ERROR');
3576: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3577: SUBSTR (SQLERRM, 1, 240) );
3578: FND_MSG_PUB.Add;
3579: -- err_num := SQLCODE;
3580: -- err_msg := SUBSTR(SQLERRM, 1, 100);

Line 3578: FND_MSG_PUB.Add;

3574: WHEN OTHERS THEN
3575: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_ERROR');
3576: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3577: SUBSTR (SQLERRM, 1, 240) );
3578: FND_MSG_PUB.Add;
3579: -- err_num := SQLCODE;
3580: -- err_msg := SUBSTR(SQLERRM, 1, 100);
3581: -- dbms_output.put_line('Other errors in inserting into ak_loader_temp');
3582: -- dbms_output.put_line(to_char(err_num)||' '||err_msg);

Line 3649: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

3645: p_return_status := FND_API.G_RET_STS_ERROR;
3646: return FALSE;
3647: WHEN OTHERS THEN
3648: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3649: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3650: SUBSTR (SQLERRM, 1, 240) );
3651: return FALSE;
3652: end VALID_APPLICATION_ID;
3653:

Line 3721: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

3717: p_return_status := FND_API.G_RET_STS_ERROR;
3718: return FALSE;
3719: WHEN OTHERS THEN
3720: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3721: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3722: SUBSTR (SQLERRM, 1, 240) );
3723: return FALSE;
3724: end VALID_LOOKUP_CODE;
3725: