DBA Data[Home] [Help]

APPS.AK_ON_OBJECTS_PVT dependencies on FND_MESSAGE

Line 256: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');

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;
260: end if;

Line 275: -- FND_MESSAGE.SET_NAME('AK','AK_APPL_SHORT_NAME_IGNORED');

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
279: -- /***********************************************/

Line 285: FND_MESSAGE.SET_NAME('AK','AK_APPL_SHORT_NAME_INVALID');

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;
289: close l_get_appl_id_csr;

Line 286: FND_MESSAGE.SET_TOKEN('APPL_SHORT_NAME', 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;
289: close l_get_appl_id_csr;
290: raise FND_API.G_EXC_ERROR;

Line 2020: FND_MESSAGE.SET_NAME('AK','AK_HEADER_DOWNLOAD_ERROR');

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;
2024: WHEN OTHERS THEN

Line 2176: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_FILE');

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;
2180: end if;

Line 2200: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');

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;
2204: end if;

Line 2218: FND_MESSAGE.SET_NAME('AK','AK_HEADER_INFO_MISSING');

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;
2222: else

Line 2236: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

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, ' ||
2240: 'EXTRACT_BY_OBJECT, EXTRACT_BY_APPLICATION');

Line 2237: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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, ' ||
2240: 'EXTRACT_BY_OBJECT, EXTRACT_BY_APPLICATION');
2241: FND_MSG_PUB.Add;

Line 2238: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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, ' ||
2240: 'EXTRACT_BY_OBJECT, EXTRACT_BY_APPLICATION');
2241: FND_MSG_PUB.Add;
2242: end if;

Line 2239: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN, LANGUAGE, CODESET, ' ||

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, ' ||
2240: 'EXTRACT_BY_OBJECT, EXTRACT_BY_APPLICATION');
2241: FND_MSG_PUB.Add;
2242: end if;
2243: raise FND_API.G_EXC_ERROR;

Line 2250: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

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','=');
2254: FND_MSG_PUB.Add;

Line 2251: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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','=');
2254: FND_MSG_PUB.Add;
2255: end if;

Line 2252: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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','=');
2254: FND_MSG_PUB.Add;
2255: end if;
2256: --dbms_output.put_line('Expecting =');

Line 2253: FND_MESSAGE.SET_TOKEN('EXPECTED','=');

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','=');
2254: FND_MSG_PUB.Add;
2255: end if;
2256: --dbms_output.put_line('Expecting =');
2257: raise FND_API.G_EXC_ERROR;

Line 2272: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');

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;
2276: raise FND_API.G_EXC_ERROR;

Line 2273: FND_MESSAGE.SET_TOKEN('COLUMN','EXTRACT_BY_OBJECT');

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;
2276: raise FND_API.G_EXC_ERROR;
2277: else

Line 2300: FND_MESSAGE.SET_NAME('AK','AK_WRONG_FILE_VERSION');

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;
2304: end if; -- end if l_file_version

Line 2307: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

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);
2311: FND_MSG_PUB.Add;

Line 2308: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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);
2311: FND_MSG_PUB.Add;
2312: end if;

Line 2309: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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);
2311: FND_MSG_PUB.Add;
2312: end if;
2313: -- dbms_output.put_line('Expecting ' || l_column || ' value');

Line 2310: FND_MESSAGE.SET_TOKEN('EXPECTED',l_column);

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);
2311: FND_MSG_PUB.Add;
2312: end if;
2313: -- dbms_output.put_line('Expecting ' || l_column || ' value');
2314: raise FND_API.G_EXC_ERROR;

Line 2322: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

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');
2326: FND_MSG_PUB.Add;

Line 2323: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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');
2326: FND_MSG_PUB.Add;
2327: end if;

Line 2324: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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');
2326: FND_MSG_PUB.Add;
2327: end if;
2328: -- dbms_output.put_line('Expecting BEGIN');

Line 2325: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');

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');
2326: FND_MSG_PUB.Add;
2327: end if;
2328: -- dbms_output.put_line('Expecting BEGIN');
2329: raise FND_API.G_EXC_ERROR;

Line 2581: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

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,
2585: FLOW, EXCLUDED_ITEMS, RESP_SECURITY_ATTRIBUTES OR QUERY_OBJECT');

Line 2582: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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,
2585: FLOW, EXCLUDED_ITEMS, RESP_SECURITY_ATTRIBUTES OR QUERY_OBJECT');
2586: FND_MSG_PUB.Add;

Line 2583: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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,
2585: FLOW, EXCLUDED_ITEMS, RESP_SECURITY_ATTRIBUTES OR QUERY_OBJECT');
2586: FND_MSG_PUB.Add;
2587: end if;

Line 2584: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE, OBJECT, REGION,

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,
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;

Line 2603: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

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);
2607: FND_MSG_PUB.Add;

Line 2604: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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);
2607: FND_MSG_PUB.Add;
2608: end if;

Line 2605: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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);
2607: FND_MSG_PUB.Add;
2608: end if;
2609: raise FND_API.G_EXC_ERROR;

Line 2606: FND_MESSAGE.SET_TOKEN('EXPECTED', 'END ' || l_object_name);

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);
2607: FND_MSG_PUB.Add;
2608: end if;
2609: raise FND_API.G_EXC_ERROR;
2610: end if;

Line 2660: -- FND_MESSAGE.SET_NAME('AK','AK_LINES_PROCESSED');

2656: --
2657: -- Write a '# lines processed message' to the message stack
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 *****************

Line 2661: -- FND_MESSAGE.SET_TOKEN('NUMLINES', to_char(l_line_num));

2657: -- Write a '# lines processed message' to the message stack
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:

Line 2671: FND_MESSAGE.SET_NAME('AK','AK_UPLOAD_PASS2' || to_char(l_index));

2667: --
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,

Line 2999: FND_MESSAGE.SET_NAME('AK','AK_UNEXPECTED_EOF_ERROR');

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;
3003: end if;

Line 3012: FND_MESSAGE.SET_NAME('AK','AK_UNEXPECTED_EOF_ERROR');

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;
3016: p_return_status := FND_API.G_RET_STS_ERROR;

Line 3102: FND_MESSAGE.SET_NAME('AK','AK_MISSING_GEN_DATE');

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;
3106: end if;

Line 3352: FND_MESSAGE.SET_NAME('AK','AK_INVALID_WRITE_MODE');

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;
3356: end if;

Line 3478: FND_MESSAGE.SET_NAME('AK','AK_INVALID_WRITE_MODE');

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;
3482: end if;

Line 3572: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_EXCEPTION');

3568:
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,

Line 3575: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_ERROR');

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) );
3578: FND_MSG_PUB.Add;
3579: -- err_num := SQLCODE;