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_CUSTOM2_PVT dependencies on FND_MSG_PUB

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

159: --
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;

Line 165: FND_MSG_PUB.Add;

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;
169:

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

181: --dbms_output.put_line(' State:' || l_state || 'Token:' || l_token);
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');

Line 187: FND_MSG_PUB.Add;

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

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

197: if (l_state = 0) then
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');

Line 206: FND_MSG_PUB.Add;

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;
210: elsif (l_state = 1) then

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

248: l_custom_rec.region_code := l_token;
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');

Line 257: FND_MSG_PUB.Add;

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;
261: elsif (l_state = 10) then

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

301: l_saved_token := l_token;
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);

Line 314: FND_MSG_PUB.Add;

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

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

320: elsif (l_state = 11) then
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','=');

Line 329: FND_MSG_PUB.Add;

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;
333: elsif (l_state = 12) then

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

378: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
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);

Line 387: FND_MSG_PUB.Add;

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;
391: l_state := 10;

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

417: l_criteria_rec.region_application_id := l_custom_rec.region_appl_id;
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');

Line 426: FND_MSG_PUB.Add;

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;
430: elsif (l_state = 19) then

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

432: l_state := 0;
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');

Line 441: FND_MSG_PUB.Add;

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;
445:

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

451: l_cust_region_rec.property_name := l_token;
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');

Line 460: FND_MSG_PUB.Add;

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;
464: elsif (l_state = 30) then

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

491: l_saved_token := l_token;
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);

Line 504: FND_MSG_PUB.Add;

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

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

509: elsif (l_state = 31) then
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', '=');

Line 518: FND_MSG_PUB.Add;

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;
522: elsif (l_state = 32) then

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

553: elsif (l_column = 'LAST_UPDATE_LOGIN') then
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');

Line 562: FND_MSG_PUB.Add;

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;
566: elsif (l_state = 39) then

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

569: l_state := 10;
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');

Line 578: FND_MSG_PUB.Add;

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;
582:

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

587: if (l_token is not null) then
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');

Line 596: FND_MSG_PUB.Add;

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;
600: elsif (l_state = 101) then

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

601: if (l_token is not null) then
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');

Line 610: FND_MSG_PUB.Add;

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;
614: elsif (l_state = 102) then

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

616: l_cust_reg_item_rec.property_name := l_token;
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');

Line 625: FND_MSG_PUB.Add;

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;
629: elsif (l_state = 130) then

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

656: l_saved_token := l_token;
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);

Line 669: FND_MSG_PUB.Add;

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

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

674: elsif (l_state = 131) then
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', '=');

Line 683: FND_MSG_PUB.Add;

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;
687: elsif (l_state = 132) then

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

719: elsif (l_column = 'LAST_UPDATE_LOGIN') then
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');

Line 728: FND_MSG_PUB.Add;

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;
732: elsif (l_state = 139) then

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

735: l_state := 10;
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');

Line 744: FND_MSG_PUB.Add;

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;
748:

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

753: if (l_token is not null) then
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');

Line 762: FND_MSG_PUB.Add;

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;
766: elsif (l_state = 201) then

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

767: if (l_token is not null) then
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');

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

781: l_criteria_rec.sequence_number := to_number(l_token);
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');

Line 790: FND_MSG_PUB.Add;

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;
794: elsif (l_state = 230) then

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

823: l_saved_token := l_token;
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);

Line 836: FND_MSG_PUB.Add;

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

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

841: elsif (l_state = 231) then
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', '=');

Line 850: FND_MSG_PUB.Add;

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;
854: elsif (l_state = 232) then

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

894: elsif (l_column = 'LAST_UPDATE_LOGIN') then
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');

Line 903: FND_MSG_PUB.Add;

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;
907: elsif (l_state = 239) then

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

910: l_state := 10;
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');

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

955: -- If the loops end in a state other then at the end of a region
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);

Line 964: FND_MSG_PUB.Add;

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

Line 1660: FND_MSG_PUB.Add;

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 );
1663: FND_MSG_PUB.Add;
1664: WHEN OTHERS THEN

Line 1661: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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 );
1663: FND_MSG_PUB.Add;
1664: WHEN OTHERS THEN
1665: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1663: FND_MSG_PUB.Add;

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 );
1663: FND_MSG_PUB.Add;
1664: WHEN OTHERS THEN
1665: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1666: rollback to Start_Upload;
1667: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 1667: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1663: FND_MSG_PUB.Add;
1664: WHEN OTHERS THEN
1665: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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);

Line 1669: FND_MSG_PUB.Add;

1665: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;

Line 1672: FND_MSG_PUB.Add;

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: --=======================================================
1676: -- Procedure UPLOAD_CUSTOM_SECOND

Line 2129: FND_MSG_PUB.Count_And_Get (

2125:
2126: EXCEPTION
2127: WHEN FND_API.G_EXC_ERROR THEN
2128: p_return_status := FND_API.G_RET_STS_ERROR;
2129: FND_MSG_PUB.Count_And_Get (
2130: p_count => l_msg_count,
2131: p_data => l_msg_data);
2132: WHEN OTHERS THEN
2133: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2134: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

2130: p_count => l_msg_count,
2131: p_data => l_msg_data);
2132: WHEN OTHERS THEN
2133: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2134: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2135: SUBSTR (SQLERRM, 1, 240) );
2136: FND_MSG_PUB.Count_And_Get (
2137: p_count => l_msg_count,
2138: p_data => l_msg_data);

Line 2136: FND_MSG_PUB.Count_And_Get (

2132: WHEN OTHERS THEN
2133: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2134: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2135: SUBSTR (SQLERRM, 1, 240) );
2136: FND_MSG_PUB.Count_And_Get (
2137: p_count => l_msg_count,
2138: p_data => l_msg_data);
2139:
2140: end UPLOAD_CUSTOM_SECOND;