160: -- Error if there is nothing to be read from the file
161: --
162: if (l_buffer is null and l_eof_flag = 'Y') then
163: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
164: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');
165: FND_MSG_PUB.Add;
166: end if;
167: raise FND_API.G_EXC_ERROR;
168: end if;
182:
183: if (l_return_status = FND_API.G_RET_STS_ERROR) or
184: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
185: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
186: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
187: FND_MSG_PUB.Add;
188: end if;
189: --dbms_output.put_line(l_api_name || ' Error parsing buffer');
190: raise FND_API.G_EXC_ERROR;
198: if (l_token = 'BEGIN') then
199: l_state := 1;
200: else
201: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
202: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
203: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
204: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
205: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
206: FND_MSG_PUB.Add;
199: l_state := 1;
200: else
201: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
202: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
203: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
204: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
205: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
206: FND_MSG_PUB.Add;
207: end if;
200: else
201: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
202: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
203: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
204: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
205: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
206: FND_MSG_PUB.Add;
207: end if;
208: raise FND_API.G_EXC_ERROR;
201: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
202: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
203: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
204: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
205: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
206: FND_MSG_PUB.Add;
207: end if;
208: raise FND_API.G_EXC_ERROR;
209: end if;
249: l_value_count := null;
250: l_state := 10;
251: else
252: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
253: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
254: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
255: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
256: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_CODE');
257: FND_MSG_PUB.Add;
250: l_state := 10;
251: else
252: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
253: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
254: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
255: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
256: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_CODE');
257: FND_MSG_PUB.Add;
258: end if;
251: else
252: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
253: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
254: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
255: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
256: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_CODE');
257: FND_MSG_PUB.Add;
258: end if;
259: raise FND_API.G_EXC_ERROR;
252: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
253: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
254: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
255: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
256: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_CODE');
257: FND_MSG_PUB.Add;
258: end if;
259: raise FND_API.G_EXC_ERROR;
260: end if;
302: end if;
303: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
304: (l_value_count is null) then
305: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
306: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
307: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
308: if (l_value_count is null) then
309: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
310: else
303: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
304: (l_value_count is null) then
305: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
306: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
307: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
308: if (l_value_count is null) then
309: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
310: else
311: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
305: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
306: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
307: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
308: if (l_value_count is null) then
309: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
310: else
311: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
312: end if;
313: FND_MESSAGE.SET_TOKEN('EXPECTED','CUSTOM');
307: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
308: if (l_value_count is null) then
309: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
310: else
311: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
312: end if;
313: FND_MESSAGE.SET_TOKEN('EXPECTED','CUSTOM');
314: FND_MSG_PUB.Add;
315: end if;
309: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
310: else
311: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
312: end if;
313: FND_MESSAGE.SET_TOKEN('EXPECTED','CUSTOM');
314: FND_MSG_PUB.Add;
315: end if;
316: -- dbms_output.put_line('Expecting region field, BEGIN, or END');
317: raise FND_API.G_EXC_ERROR;
321: if (l_token = '=') then
322: l_state := 12;
323: else
324: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
325: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
326: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
327: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
328: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
329: FND_MSG_PUB.Add;
322: l_state := 12;
323: else
324: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
325: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
326: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
327: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
328: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
329: FND_MSG_PUB.Add;
330: end if;
323: else
324: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
325: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
326: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
327: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
328: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
329: FND_MSG_PUB.Add;
330: end if;
331: raise FND_API.G_EXC_ERROR;
324: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
325: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
326: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
327: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
328: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
329: FND_MSG_PUB.Add;
330: end if;
331: raise FND_API.G_EXC_ERROR;
332: end if;
379: elsif (l_column = 'LAST_UPDATE_LOGIN') then
380: l_custom_rec.last_update_login := to_number(l_token);
381: else
382: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
383: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
384: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
385: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
386: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
387: FND_MSG_PUB.Add;
380: l_custom_rec.last_update_login := to_number(l_token);
381: else
382: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
383: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
384: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
385: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
386: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
387: FND_MSG_PUB.Add;
388: end if;
381: else
382: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
383: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
384: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
385: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
386: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
387: FND_MSG_PUB.Add;
388: end if;
389: raise FND_API.G_EXC_ERROR;
382: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
383: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
384: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
385: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
386: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
387: FND_MSG_PUB.Add;
388: end if;
389: raise FND_API.G_EXC_ERROR;
390: end if;
418: l_criteria_rec.region_code := l_custom_rec.region_code;
419: l_state := 200;
420: else
421: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
422: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
423: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
424: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
425: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CUSTOM_REGION, CUSTOM_REGION_ITEM, CRITERIA');
426: FND_MSG_PUB.Add;
419: l_state := 200;
420: else
421: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
422: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
423: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
424: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
425: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CUSTOM_REGION, CUSTOM_REGION_ITEM, CRITERIA');
426: FND_MSG_PUB.Add;
427: end if;
420: else
421: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
422: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
423: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
424: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
425: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CUSTOM_REGION, CUSTOM_REGION_ITEM, CRITERIA');
426: FND_MSG_PUB.Add;
427: end if;
428: raise FND_API.G_EXC_ERROR;
421: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
422: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
423: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
424: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
425: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CUSTOM_REGION, CUSTOM_REGION_ITEM, CRITERIA');
426: FND_MSG_PUB.Add;
427: end if;
428: raise FND_API.G_EXC_ERROR;
429: end if;
433: l_custom_index := l_custom_index + 1;
434: l_custom_tbl(l_custom_index) := l_custom_rec;
435: else
436: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
437: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
438: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
439: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
440: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CUSTOMIZATION');
441: FND_MSG_PUB.Add;
434: l_custom_tbl(l_custom_index) := l_custom_rec;
435: else
436: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
437: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
438: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
439: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
440: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CUSTOMIZATION');
441: FND_MSG_PUB.Add;
442: end if;
435: else
436: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
437: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
438: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
439: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
440: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CUSTOMIZATION');
441: FND_MSG_PUB.Add;
442: end if;
443: raise FND_API.G_EXC_ERROR;
436: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
437: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
438: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
439: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
440: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CUSTOMIZATION');
441: FND_MSG_PUB.Add;
442: end if;
443: raise FND_API.G_EXC_ERROR;
444: end if;
452: l_value_count := null;
453: l_state := 30;
454: else
455: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
456: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
457: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
458: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
459: FND_MESSAGE.SET_TOKEN('EXPECTED', 'PROPERTY_NAME');
460: FND_MSG_PUB.Add;
453: l_state := 30;
454: else
455: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
456: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
457: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
458: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
459: FND_MESSAGE.SET_TOKEN('EXPECTED', 'PROPERTY_NAME');
460: FND_MSG_PUB.Add;
461: end if;
454: else
455: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
456: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
457: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
458: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
459: FND_MESSAGE.SET_TOKEN('EXPECTED', 'PROPERTY_NAME');
460: FND_MSG_PUB.Add;
461: end if;
462: raise FND_API.G_EXC_ERROR;
455: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
456: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
457: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
458: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
459: FND_MESSAGE.SET_TOKEN('EXPECTED', 'PROPERTY_NAME');
460: FND_MSG_PUB.Add;
461: end if;
462: raise FND_API.G_EXC_ERROR;
463: end if;
492: end if;
493: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
494: (l_value_count is null) then
495: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
496: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
497: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
498: if (l_value_count is null) then
499: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
500: else
493: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
494: (l_value_count is null) then
495: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
496: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
497: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
498: if (l_value_count is null) then
499: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
500: else
501: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
495: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
496: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
497: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
498: if (l_value_count is null) then
499: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
500: else
501: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
502: end if;
503: FND_MESSAGE.SET_TOKEN('EXPECTED','CUSTOM_REGION');
497: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
498: if (l_value_count is null) then
499: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
500: else
501: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
502: end if;
503: FND_MESSAGE.SET_TOKEN('EXPECTED','CUSTOM_REGION');
504: FND_MSG_PUB.Add;
505: end if;
499: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
500: else
501: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
502: end if;
503: FND_MESSAGE.SET_TOKEN('EXPECTED','CUSTOM_REGION');
504: FND_MSG_PUB.Add;
505: end if;
506: raise FND_API.G_EXC_ERROR;
507: end if;
510: if (l_token = '=') then
511: l_state := 32;
512: else
513: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
514: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
515: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
516: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
517: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
518: FND_MSG_PUB.Add;
511: l_state := 32;
512: else
513: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
514: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
515: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
516: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
517: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
518: FND_MSG_PUB.Add;
519: end if;
512: else
513: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
514: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
515: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
516: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
517: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
518: FND_MSG_PUB.Add;
519: end if;
520: raise FND_API.G_EXC_ERROR;
513: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
514: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
515: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
516: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
517: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
518: FND_MSG_PUB.Add;
519: end if;
520: raise FND_API.G_EXC_ERROR;
521: end if;
554: l_cust_region_rec.last_update_login := to_number(l_token);
555: l_state := 30;
556: else
557: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
558: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
559: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
560: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
561: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
562: FND_MSG_PUB.Add;
555: l_state := 30;
556: else
557: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
558: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
559: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
560: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
561: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
562: FND_MSG_PUB.Add;
563: end if;
556: else
557: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
558: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
559: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
560: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
561: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
562: FND_MSG_PUB.Add;
563: end if;
564: raise FND_API.G_EXC_ERROR;
557: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
558: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
559: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
560: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
561: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
562: FND_MSG_PUB.Add;
563: end if;
564: raise FND_API.G_EXC_ERROR;
565: end if;
570: l_cust_region_index := l_cust_region_index + 1;
571: l_cust_region_tbl(l_cust_region_index) := l_cust_region_rec;
572: else
573: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
574: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
575: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
576: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
577: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CUSTOM_REGION');
578: FND_MSG_PUB.Add;
571: l_cust_region_tbl(l_cust_region_index) := l_cust_region_rec;
572: else
573: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
574: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
575: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
576: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
577: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CUSTOM_REGION');
578: FND_MSG_PUB.Add;
579: end if;
572: else
573: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
574: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
575: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
576: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
577: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CUSTOM_REGION');
578: FND_MSG_PUB.Add;
579: end if;
580: raise FND_API.G_EXC_ERROR;
573: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
574: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
575: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
576: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
577: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CUSTOM_REGION');
578: FND_MSG_PUB.Add;
579: end if;
580: raise FND_API.G_EXC_ERROR;
581: end if;
588: l_cust_reg_item_rec.attr_appl_id := to_number(l_token);
589: l_state := 101;
590: else
591: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
592: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
593: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
594: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
595: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPL_ID');
596: FND_MSG_PUB.Add;
589: l_state := 101;
590: else
591: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
592: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
593: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
594: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
595: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPL_ID');
596: FND_MSG_PUB.Add;
597: end if;
590: else
591: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
592: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
593: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
594: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
595: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPL_ID');
596: FND_MSG_PUB.Add;
597: end if;
598: raise FND_API.G_EXC_ERROR;
591: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
592: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
593: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
594: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
595: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPL_ID');
596: FND_MSG_PUB.Add;
597: end if;
598: raise FND_API.G_EXC_ERROR;
599: end if;
602: l_cust_reg_item_rec.attr_code := l_token;
603: l_state := 102;
604: else
605: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
606: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
607: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
608: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
609: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
610: FND_MSG_PUB.Add;
603: l_state := 102;
604: else
605: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
606: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
607: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
608: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
609: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
610: FND_MSG_PUB.Add;
611: end if;
604: else
605: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
606: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
607: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
608: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
609: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
610: FND_MSG_PUB.Add;
611: end if;
612: raise FND_API.G_EXC_ERROR;
605: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
606: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
607: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
608: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
609: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
610: FND_MSG_PUB.Add;
611: end if;
612: raise FND_API.G_EXC_ERROR;
613: end if;
617: l_value_count := null;
618: l_state := 130;
619: else
620: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
621: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
622: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
623: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
624: FND_MESSAGE.SET_TOKEN('EXPECTED', 'PROPERTY_NAME');
625: FND_MSG_PUB.Add;
618: l_state := 130;
619: else
620: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
621: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
622: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
623: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
624: FND_MESSAGE.SET_TOKEN('EXPECTED', 'PROPERTY_NAME');
625: FND_MSG_PUB.Add;
626: end if;
619: else
620: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
621: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
622: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
623: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
624: FND_MESSAGE.SET_TOKEN('EXPECTED', 'PROPERTY_NAME');
625: FND_MSG_PUB.Add;
626: end if;
627: raise FND_API.G_EXC_ERROR;
620: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
621: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
622: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
623: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
624: FND_MESSAGE.SET_TOKEN('EXPECTED', 'PROPERTY_NAME');
625: FND_MSG_PUB.Add;
626: end if;
627: raise FND_API.G_EXC_ERROR;
628: end if;
657: end if;
658: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
659: (l_value_count is null) then
660: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
661: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
662: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
663: if (l_value_count is null) then
664: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
665: else
658: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
659: (l_value_count is null) then
660: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
661: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
662: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
663: if (l_value_count is null) then
664: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
665: else
666: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
660: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
661: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
662: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
663: if (l_value_count is null) then
664: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
665: else
666: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
667: end if;
668: FND_MESSAGE.SET_TOKEN('EXPECTED','CUSTOM_REGION_ITEM');
662: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
663: if (l_value_count is null) then
664: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
665: else
666: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
667: end if;
668: FND_MESSAGE.SET_TOKEN('EXPECTED','CUSTOM_REGION_ITEM');
669: FND_MSG_PUB.Add;
670: end if;
664: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
665: else
666: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
667: end if;
668: FND_MESSAGE.SET_TOKEN('EXPECTED','CUSTOM_REGION_ITEM');
669: FND_MSG_PUB.Add;
670: end if;
671: raise FND_API.G_EXC_ERROR;
672: end if;
675: if (l_token = '=') then
676: l_state := 132;
677: else
678: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
679: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
680: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
681: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
682: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
683: FND_MSG_PUB.Add;
676: l_state := 132;
677: else
678: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
679: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
680: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
681: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
682: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
683: FND_MSG_PUB.Add;
684: end if;
677: else
678: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
679: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
680: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
681: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
682: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
683: FND_MSG_PUB.Add;
684: end if;
685: raise FND_API.G_EXC_ERROR;
678: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
679: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
680: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
681: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
682: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
683: FND_MSG_PUB.Add;
684: end if;
685: raise FND_API.G_EXC_ERROR;
686: end if;
720: l_cust_reg_item_rec.last_update_login := to_number(l_token);
721: l_state := 130;
722: else
723: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
724: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
725: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
726: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
727: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
728: FND_MSG_PUB.Add;
721: l_state := 130;
722: else
723: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
724: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
725: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
726: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
727: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
728: FND_MSG_PUB.Add;
729: end if;
722: else
723: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
724: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
725: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
726: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
727: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
728: FND_MSG_PUB.Add;
729: end if;
730: raise FND_API.G_EXC_ERROR;
723: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
724: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
725: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
726: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
727: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
728: FND_MSG_PUB.Add;
729: end if;
730: raise FND_API.G_EXC_ERROR;
731: end if;
736: l_cust_reg_item_index := l_cust_reg_item_index + 1;
737: l_cust_reg_item_tbl(l_cust_reg_item_index) := l_cust_reg_item_rec;
738: else
739: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
740: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
741: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
742: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
743: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CUSTOM_REGION_ITEM');
744: FND_MSG_PUB.Add;
737: l_cust_reg_item_tbl(l_cust_reg_item_index) := l_cust_reg_item_rec;
738: else
739: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
740: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
741: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
742: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
743: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CUSTOM_REGION_ITEM');
744: FND_MSG_PUB.Add;
745: end if;
738: else
739: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
740: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
741: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
742: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
743: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CUSTOM_REGION_ITEM');
744: FND_MSG_PUB.Add;
745: end if;
746: raise FND_API.G_EXC_ERROR;
739: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
740: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
741: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
742: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
743: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CUSTOM_REGION_ITEM');
744: FND_MSG_PUB.Add;
745: end if;
746: raise FND_API.G_EXC_ERROR;
747: end if;
754: l_criteria_rec.attribute_application_id := to_number(l_token);
755: l_state := 201;
756: else
757: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
758: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
759: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
760: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
761: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPL_ID');
762: FND_MSG_PUB.Add;
755: l_state := 201;
756: else
757: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
758: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
759: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
760: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
761: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPL_ID');
762: FND_MSG_PUB.Add;
763: end if;
756: else
757: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
758: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
759: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
760: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
761: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPL_ID');
762: FND_MSG_PUB.Add;
763: end if;
764: raise FND_API.G_EXC_ERROR;
757: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
758: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
759: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
760: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
761: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPL_ID');
762: FND_MSG_PUB.Add;
763: end if;
764: raise FND_API.G_EXC_ERROR;
765: end if;
768: l_criteria_rec.attribute_code := l_token;
769: l_state := 202;
770: else
771: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
772: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
773: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
774: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
775: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
776: end if;
769: l_state := 202;
770: else
771: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
772: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
773: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
774: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
775: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
776: end if;
777: raise FND_API.G_EXC_ERROR;
770: else
771: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
772: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
773: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
774: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
775: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
776: end if;
777: raise FND_API.G_EXC_ERROR;
778: end if;
771: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
772: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
773: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
774: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
775: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
776: end if;
777: raise FND_API.G_EXC_ERROR;
778: end if;
779: elsif (l_state = 202) then
782: l_value_count := null;
783: l_state := 230;
784: else
785: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
786: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
787: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
788: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
789: FND_MESSAGE.SET_TOKEN('EXPECTED', 'SEQUENCE_NUMBER');
790: FND_MSG_PUB.Add;
783: l_state := 230;
784: else
785: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
786: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
787: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
788: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
789: FND_MESSAGE.SET_TOKEN('EXPECTED', 'SEQUENCE_NUMBER');
790: FND_MSG_PUB.Add;
791: end if;
784: else
785: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
786: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
787: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
788: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
789: FND_MESSAGE.SET_TOKEN('EXPECTED', 'SEQUENCE_NUMBER');
790: FND_MSG_PUB.Add;
791: end if;
792: raise FND_API.G_EXC_ERROR;
785: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
786: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
787: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
788: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
789: FND_MESSAGE.SET_TOKEN('EXPECTED', 'SEQUENCE_NUMBER');
790: FND_MSG_PUB.Add;
791: end if;
792: raise FND_API.G_EXC_ERROR;
793: end if;
824: end if;
825: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
826: (l_value_count is null) then
827: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
828: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
829: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
830: if (l_value_count is null) then
831: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
832: else
825: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
826: (l_value_count is null) then
827: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
828: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
829: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
830: if (l_value_count is null) then
831: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
832: else
833: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
827: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
828: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
829: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
830: if (l_value_count is null) then
831: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
832: else
833: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
834: end if;
835: FND_MESSAGE.SET_TOKEN('EXPECTED','CRITERIA');
829: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
830: if (l_value_count is null) then
831: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
832: else
833: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
834: end if;
835: FND_MESSAGE.SET_TOKEN('EXPECTED','CRITERIA');
836: FND_MSG_PUB.Add;
837: end if;
831: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
832: else
833: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
834: end if;
835: FND_MESSAGE.SET_TOKEN('EXPECTED','CRITERIA');
836: FND_MSG_PUB.Add;
837: end if;
838: raise FND_API.G_EXC_ERROR;
839: end if;
842: if (l_token = '=') then
843: l_state := 232;
844: else
845: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
846: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
847: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
848: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
849: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
850: FND_MSG_PUB.Add;
843: l_state := 232;
844: else
845: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
846: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
847: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
848: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
849: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
850: FND_MSG_PUB.Add;
851: end if;
844: else
845: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
846: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
847: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
848: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
849: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
850: FND_MSG_PUB.Add;
851: end if;
852: raise FND_API.G_EXC_ERROR;
845: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
846: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
847: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
848: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
849: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
850: FND_MSG_PUB.Add;
851: end if;
852: raise FND_API.G_EXC_ERROR;
853: end if;
895: l_criteria_rec.last_update_login := to_number(l_token);
896: l_state := 230;
897: else
898: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
899: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
900: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
901: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
902: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
903: FND_MSG_PUB.Add;
896: l_state := 230;
897: else
898: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
899: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
900: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
901: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
902: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
903: FND_MSG_PUB.Add;
904: end if;
897: else
898: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
899: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
900: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
901: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
902: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
903: FND_MSG_PUB.Add;
904: end if;
905: raise FND_API.G_EXC_ERROR;
898: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
899: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
900: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
901: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
902: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
903: FND_MSG_PUB.Add;
904: end if;
905: raise FND_API.G_EXC_ERROR;
906: end if;
911: l_criteria_index := l_criteria_index + 1;
912: l_criteria_tbl(l_criteria_index) := l_criteria_rec;
913: else
914: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
915: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
916: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
917: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
918: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CRITERIA');
919: end if;
912: l_criteria_tbl(l_criteria_index) := l_criteria_rec;
913: else
914: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
915: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
916: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
917: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
918: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CRITERIA');
919: end if;
920: raise FND_API.G_EXC_ERROR;
913: else
914: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
915: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
916: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
917: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
918: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CRITERIA');
919: end if;
920: raise FND_API.G_EXC_ERROR;
921: end if;
914: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
915: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
916: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
917: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
918: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CRITERIA');
919: end if;
920: raise FND_API.G_EXC_ERROR;
921: end if;
922:
956: -- (state 0) or when the beginning of another business object was
957: -- detected, then the file must have ended prematurely, which is an error
958: if (l_state <> 0) and (l_more_custom) then
959: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
960: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
961: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
962: FND_MESSAGE.SET_TOKEN('TOKEN', 'END OF FILE');
963: FND_MESSAGE.SET_TOKEN('EXPECTED', null);
964: FND_MSG_PUB.Add;
957: -- detected, then the file must have ended prematurely, which is an error
958: if (l_state <> 0) and (l_more_custom) then
959: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
960: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
961: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
962: FND_MESSAGE.SET_TOKEN('TOKEN', 'END OF FILE');
963: FND_MESSAGE.SET_TOKEN('EXPECTED', null);
964: FND_MSG_PUB.Add;
965: end if;
958: if (l_state <> 0) and (l_more_custom) then
959: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
960: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
961: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
962: FND_MESSAGE.SET_TOKEN('TOKEN', 'END OF FILE');
963: FND_MESSAGE.SET_TOKEN('EXPECTED', null);
964: FND_MSG_PUB.Add;
965: end if;
966: --dbms_output.put_line('Unexpected END OF FILE: state is ' ||
959: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
960: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
961: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
962: FND_MESSAGE.SET_TOKEN('TOKEN', 'END OF FILE');
963: FND_MESSAGE.SET_TOKEN('EXPECTED', null);
964: FND_MSG_PUB.Add;
965: end if;
966: --dbms_output.put_line('Unexpected END OF FILE: state is ' ||
967: -- to_char(l_state));
1653: p_return_status := FND_API.G_RET_STS_ERROR;
1654: rollback to Start_Upload;
1655: WHEN VALUE_ERROR THEN
1656: p_return_status := FND_API.G_RET_STS_ERROR;
1657: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_VALUE_ERROR');
1658: FND_MESSAGE.SET_TOKEN('KEY',to_char(l_custom_rec.region_appl_id)||' '||
1659: l_custom_rec.region_code);
1660: FND_MSG_PUB.Add;
1661: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1654: rollback to Start_Upload;
1655: WHEN VALUE_ERROR THEN
1656: p_return_status := FND_API.G_RET_STS_ERROR;
1657: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_VALUE_ERROR');
1658: FND_MESSAGE.SET_TOKEN('KEY',to_char(l_custom_rec.region_appl_id)||' '||
1659: l_custom_rec.region_code);
1660: FND_MSG_PUB.Add;
1661: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1662: SUBSTR (SQLERRM, 1, 240)||': '||l_column||'='||l_token );
1666: rollback to Start_Upload;
1667: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1668: SUBSTR (SQLERRM, 1, 240) );
1669: FND_MSG_PUB.Add;
1670: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_VALUE_ERROR');
1671: FND_MESSAGE.SET_TOKEN('KEY', l_error_key_info);
1672: FND_MSG_PUB.Add;
1673: end UPLOAD_CUSTOM;
1674:
1667: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1668: SUBSTR (SQLERRM, 1, 240) );
1669: FND_MSG_PUB.Add;
1670: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_VALUE_ERROR');
1671: FND_MESSAGE.SET_TOKEN('KEY', l_error_key_info);
1672: FND_MSG_PUB.Add;
1673: end UPLOAD_CUSTOM;
1674:
1675: --=======================================================