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_REGION2_PVT dependencies on FND_MESSAGE

Line 187: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');

183: -- Error if there is nothing to be read from the file
184: --
185: if (l_buffer is null and l_eof_flag = 'Y') then
186: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
187: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');
188: FND_MSG_PUB.Add;
189: end if;
190: raise FND_API.G_EXC_ERROR;
191: end if;

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

205:
206: if (l_return_status = FND_API.G_RET_STS_ERROR) or
207: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
208: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
209: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
210: FND_MSG_PUB.Add;
211: end if;
212: --dbms_output.put_line(l_api_name || ' Error parsing buffer');
213: raise FND_API.G_EXC_ERROR;

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

221: if (l_token = 'BEGIN') then
222: l_state := 1;
223: else
224: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
225: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
226: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
227: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
228: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
229: FND_MSG_PUB.Add;

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

222: l_state := 1;
223: else
224: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
225: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
226: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
227: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
228: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
229: FND_MSG_PUB.Add;
230: end if;

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

223: else
224: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
225: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
226: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
227: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
228: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
229: FND_MSG_PUB.Add;
230: end if;
231: raise FND_API.G_EXC_ERROR;

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

224: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
225: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
226: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
227: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
228: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
229: FND_MSG_PUB.Add;
230: end if;
231: raise FND_API.G_EXC_ERROR;
232: end if;

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

256: l_value_count := null;
257: l_state := 10;
258: else
259: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
260: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
261: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
262: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
263: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_CODE');
264: FND_MSG_PUB.Add;

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

257: l_state := 10;
258: else
259: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
260: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
261: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
262: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
263: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_CODE');
264: FND_MSG_PUB.Add;
265: end if;

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

258: else
259: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
260: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
261: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
262: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
263: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_CODE');
264: FND_MSG_PUB.Add;
265: end if;
266: raise FND_API.G_EXC_ERROR;

Line 263: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_CODE');

259: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
260: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
261: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
262: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
263: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_CODE');
264: FND_MSG_PUB.Add;
265: end if;
266: raise FND_API.G_EXC_ERROR;
267: end if;

Line 346: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');

342: end if;
343: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
344: (l_value_count is null) then
345: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
346: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
347: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
348: if (l_value_count is null) then
349: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
350: else

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

343: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
344: (l_value_count is null) then
345: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
346: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
347: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
348: if (l_value_count is null) then
349: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
350: else
351: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

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

345: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
346: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
347: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
348: if (l_value_count is null) then
349: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
350: else
351: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
352: end if;
353: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION');

Line 351: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

347: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
348: if (l_value_count is null) then
349: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
350: else
351: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
352: end if;
353: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION');
354: FND_MSG_PUB.Add;
355: end if;

Line 353: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION');

349: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
350: else
351: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
352: end if;
353: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION');
354: FND_MSG_PUB.Add;
355: end if;
356: -- dbms_output.put_line('Expecting region field, BEGIN, or END');
357: raise FND_API.G_EXC_ERROR;

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

361: if (l_token = '=') then
362: l_state := 12;
363: else
364: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
365: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
366: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
367: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
368: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
369: FND_MSG_PUB.Add;

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

362: l_state := 12;
363: else
364: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
365: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
366: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
367: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
368: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
369: FND_MSG_PUB.Add;
370: end if;

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

363: else
364: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
365: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
366: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
367: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
368: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
369: FND_MSG_PUB.Add;
370: end if;
371: raise FND_API.G_EXC_ERROR;

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

364: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
365: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
366: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
367: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
368: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
369: FND_MSG_PUB.Add;
370: end if;
371: raise FND_API.G_EXC_ERROR;
372: end if;

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

483: elsif (l_column = 'LAST_UPDATE_LOGIN') then
484: l_region_rec.last_update_login := to_number(l_token);
485: else
486: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
487: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
488: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
489: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
490: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
491: FND_MSG_PUB.Add;

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

484: l_region_rec.last_update_login := to_number(l_token);
485: else
486: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
487: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
488: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
489: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
490: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
491: FND_MSG_PUB.Add;
492: end if;

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

485: else
486: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
487: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
488: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
489: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
490: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
491: FND_MSG_PUB.Add;
492: end if;
493: raise FND_API.G_EXC_ERROR;

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

486: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
487: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
488: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
489: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
490: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
491: FND_MSG_PUB.Add;
492: end if;
493: raise FND_API.G_EXC_ERROR;
494: end if;

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

535: -- l_graph_column_rec.graph_number := l_graph_rec.graph_number;
536: l_state := 400;
537: else
538: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
539: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
540: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
541: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
542: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_ITEM, REGION_LOV_RELATION, CATEGORY_USAGE');
543: FND_MSG_PUB.Add;

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

536: l_state := 400;
537: else
538: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
539: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
540: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
541: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
542: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_ITEM, REGION_LOV_RELATION, CATEGORY_USAGE');
543: FND_MSG_PUB.Add;
544: end if;

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

537: else
538: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
539: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
540: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
541: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
542: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_ITEM, REGION_LOV_RELATION, CATEGORY_USAGE');
543: FND_MSG_PUB.Add;
544: end if;
545: raise FND_API.G_EXC_ERROR;

Line 542: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_ITEM, REGION_LOV_RELATION, CATEGORY_USAGE');

538: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
539: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
540: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
541: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
542: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_ITEM, REGION_LOV_RELATION, CATEGORY_USAGE');
543: FND_MSG_PUB.Add;
544: end if;
545: raise FND_API.G_EXC_ERROR;
546: end if;

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

550: l_region_index := l_region_index + 1;
551: l_region_tbl(l_region_index) := l_region_rec;
552: else
553: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
554: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
555: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
556: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
557: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION');
558: FND_MSG_PUB.Add;

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

551: l_region_tbl(l_region_index) := l_region_rec;
552: else
553: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
554: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
555: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
556: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
557: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION');
558: FND_MSG_PUB.Add;
559: end if;

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

552: else
553: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
554: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
555: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
556: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
557: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION');
558: FND_MSG_PUB.Add;
559: end if;
560: raise FND_API.G_EXC_ERROR;

Line 557: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION');

553: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
554: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
555: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
556: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
557: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION');
558: FND_MSG_PUB.Add;
559: end if;
560: raise FND_API.G_EXC_ERROR;
561: end if;

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

568: l_item_rec.attribute_application_id := to_number(l_token);
569: l_state := 21;
570: else
571: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
572: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
573: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
574: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
575: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
576: FND_MSG_PUB.Add;

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

569: l_state := 21;
570: else
571: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
572: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
573: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
574: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
575: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
576: FND_MSG_PUB.Add;
577: end if;

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

570: else
571: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
572: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
573: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
574: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
575: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
576: FND_MSG_PUB.Add;
577: end if;
578: raise FND_API.G_EXC_ERROR;

Line 575: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');

571: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
572: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
573: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
574: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
575: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
576: FND_MSG_PUB.Add;
577: end if;
578: raise FND_API.G_EXC_ERROR;
579: end if;

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

583: l_value_count := null;
584: l_state := 30;
585: else
586: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
587: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
588: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
589: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
590: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
591: FND_MSG_PUB.Add;

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

584: l_state := 30;
585: else
586: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
587: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
588: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
589: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
590: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
591: FND_MSG_PUB.Add;
592: end if;

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

585: else
586: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
587: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
588: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
589: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
590: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
591: FND_MSG_PUB.Add;
592: end if;
593: raise FND_API.G_EXC_ERROR;

Line 590: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');

586: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
587: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
588: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
589: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
590: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
591: FND_MSG_PUB.Add;
592: end if;
593: raise FND_API.G_EXC_ERROR;
594: end if;

Line 707: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');

703: end if;
704: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
705: (l_value_count is null) then
706: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
707: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
708: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
709: if (l_value_count is null) then
710: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
711: else

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

704: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
705: (l_value_count is null) then
706: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
707: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
708: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
709: if (l_value_count is null) then
710: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
711: else
712: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

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

706: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
707: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
708: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
709: if (l_value_count is null) then
710: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
711: else
712: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
713: end if;
714: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_ITEM');

Line 712: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

708: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
709: if (l_value_count is null) then
710: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
711: else
712: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
713: end if;
714: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_ITEM');
715: FND_MSG_PUB.Add;
716: end if;

Line 714: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_ITEM');

710: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
711: else
712: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
713: end if;
714: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_ITEM');
715: FND_MSG_PUB.Add;
716: end if;
717: raise FND_API.G_EXC_ERROR;
718: end if;

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

721: if (l_token = '=') then
722: l_state := 32;
723: else
724: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
725: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
726: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
727: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
728: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
729: FND_MSG_PUB.Add;

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

722: l_state := 32;
723: else
724: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
725: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
726: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
727: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
728: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
729: FND_MSG_PUB.Add;
730: end if;

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

723: else
724: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
725: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
726: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
727: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
728: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
729: FND_MSG_PUB.Add;
730: end if;
731: raise FND_API.G_EXC_ERROR;

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

724: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
725: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
726: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
727: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
728: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
729: FND_MSG_PUB.Add;
730: end if;
731: raise FND_API.G_EXC_ERROR;
732: end if;

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

1000: l_item_rec.DESCRIPTION := l_token;
1001: l_state := 30;
1002: else
1003: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1004: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1005: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1006: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1007: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1008: FND_MSG_PUB.Add;

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

1001: l_state := 30;
1002: else
1003: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1004: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1005: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1006: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1007: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1008: FND_MSG_PUB.Add;
1009: end if;

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

1002: else
1003: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1004: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1005: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1006: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1007: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1008: FND_MSG_PUB.Add;
1009: end if;
1010: raise FND_API.G_EXC_ERROR;

Line 1007: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');

1003: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1004: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1005: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1006: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1007: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1008: FND_MSG_PUB.Add;
1009: end if;
1010: raise FND_API.G_EXC_ERROR;
1011: end if;

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

1017: l_item_rec.lov_attribute_code := l_token;
1018: l_state := 30;
1019: else
1020: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1021: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1022: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1023: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1024: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
1025: FND_MSG_PUB.Add;

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

1018: l_state := 30;
1019: else
1020: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1021: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1022: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1023: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1024: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
1025: FND_MSG_PUB.Add;
1026: end if;

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

1019: else
1020: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1021: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1022: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1023: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1024: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
1025: FND_MSG_PUB.Add;
1026: end if;
1027: raise FND_API.G_EXC_ERROR;

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

1020: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1021: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1022: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1023: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1024: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
1025: FND_MSG_PUB.Add;
1026: end if;
1027: raise FND_API.G_EXC_ERROR;
1028: end if;

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

1033: l_item_index := l_item_index + 1;
1034: l_item_tbl(l_item_index) := l_item_rec;
1035: else
1036: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1037: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1038: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1039: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1040: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_ITEM');
1041: FND_MSG_PUB.Add;

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

1034: l_item_tbl(l_item_index) := l_item_rec;
1035: else
1036: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1037: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1038: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1039: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1040: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_ITEM');
1041: FND_MSG_PUB.Add;
1042: end if;

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

1035: else
1036: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1037: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1038: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1039: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1040: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_ITEM');
1041: FND_MSG_PUB.Add;
1042: end if;
1043: raise FND_API.G_EXC_ERROR;

Line 1040: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_ITEM');

1036: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1037: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1038: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1039: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1040: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_ITEM');
1041: FND_MSG_PUB.Add;
1042: end if;
1043: raise FND_API.G_EXC_ERROR;
1044: end if;

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

1051: l_lov_relation_rec.lov_region_appl_id := to_number(l_token);
1052: l_state := 101;
1053: else
1054: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1055: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1056: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1057: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1058: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_REGION_APPL_ID');
1059: FND_MSG_PUB.Add;

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

1052: l_state := 101;
1053: else
1054: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1055: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1056: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1057: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1058: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_REGION_APPL_ID');
1059: FND_MSG_PUB.Add;
1060: end if;

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

1053: else
1054: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1055: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1056: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1057: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1058: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_REGION_APPL_ID');
1059: FND_MSG_PUB.Add;
1060: end if;
1061: raise FND_API.G_EXC_ERROR;

Line 1058: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_REGION_APPL_ID');

1054: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1055: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1056: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1057: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1058: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_REGION_APPL_ID');
1059: FND_MSG_PUB.Add;
1060: end if;
1061: raise FND_API.G_EXC_ERROR;
1062: end if;

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

1066: l_value_count := null;
1067: l_state := 102;
1068: else
1069: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1070: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1071: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1072: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1073: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_REGION_CODE');
1074: FND_MSG_PUB.Add;

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

1067: l_state := 102;
1068: else
1069: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1070: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1071: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1072: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1073: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_REGION_CODE');
1074: FND_MSG_PUB.Add;
1075: end if;

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

1068: else
1069: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1070: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1071: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1072: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1073: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_REGION_CODE');
1074: FND_MSG_PUB.Add;
1075: end if;
1076: raise FND_API.G_EXC_ERROR;

Line 1073: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_REGION_CODE');

1069: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1070: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1071: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1072: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1073: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_REGION_CODE');
1074: FND_MSG_PUB.Add;
1075: end if;
1076: raise FND_API.G_EXC_ERROR;
1077: end if;

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

1080: l_lov_relation_rec.lov_attribute_appl_id := to_number(l_token);
1081: l_state := 103;
1082: else
1083: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1084: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1085: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1086: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1087: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_ATTRIBUTE_APPL_ID');
1088: FND_MSG_PUB.Add;

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

1081: l_state := 103;
1082: else
1083: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1084: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1085: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1086: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1087: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_ATTRIBUTE_APPL_ID');
1088: FND_MSG_PUB.Add;
1089: end if;

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

1082: else
1083: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1084: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1085: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1086: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1087: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_ATTRIBUTE_APPL_ID');
1088: FND_MSG_PUB.Add;
1089: end if;
1090: raise FND_API.G_EXC_ERROR;

Line 1087: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_ATTRIBUTE_APPL_ID');

1083: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1084: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1085: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1086: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1087: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_ATTRIBUTE_APPL_ID');
1088: FND_MSG_PUB.Add;
1089: end if;
1090: raise FND_API.G_EXC_ERROR;
1091: end if;

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

1095: l_value_count := null;
1096: l_state := 104;
1097: else
1098: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1099: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1100: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1101: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1102: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_ATTRIBUTE_CODE');
1103: FND_MSG_PUB.Add;

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

1096: l_state := 104;
1097: else
1098: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1099: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1100: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1101: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1102: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_ATTRIBUTE_CODE');
1103: FND_MSG_PUB.Add;
1104: end if;

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

1097: else
1098: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1099: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1100: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1101: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1102: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_ATTRIBUTE_CODE');
1103: FND_MSG_PUB.Add;
1104: end if;
1105: raise FND_API.G_EXC_ERROR;

Line 1102: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_ATTRIBUTE_CODE');

1098: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1099: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1100: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1101: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1102: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_ATTRIBUTE_CODE');
1103: FND_MSG_PUB.Add;
1104: end if;
1105: raise FND_API.G_EXC_ERROR;
1106: end if;

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

1109: l_lov_relation_rec.base_attribute_appl_id := to_number(l_token);
1110: l_state := 105;
1111: else
1112: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1113: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1114: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1115: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1116: FND_MESSAGE.SET_TOKEN('EXPECTED', 'BASE_ATTRIBUTE_APPL_ID');
1117: FND_MSG_PUB.Add;

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

1110: l_state := 105;
1111: else
1112: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1113: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1114: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1115: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1116: FND_MESSAGE.SET_TOKEN('EXPECTED', 'BASE_ATTRIBUTE_APPL_ID');
1117: FND_MSG_PUB.Add;
1118: end if;

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

1111: else
1112: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1113: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1114: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1115: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1116: FND_MESSAGE.SET_TOKEN('EXPECTED', 'BASE_ATTRIBUTE_APPL_ID');
1117: FND_MSG_PUB.Add;
1118: end if;
1119: raise FND_API.G_EXC_ERROR;

Line 1116: FND_MESSAGE.SET_TOKEN('EXPECTED', 'BASE_ATTRIBUTE_APPL_ID');

1112: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1113: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1114: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1115: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1116: FND_MESSAGE.SET_TOKEN('EXPECTED', 'BASE_ATTRIBUTE_APPL_ID');
1117: FND_MSG_PUB.Add;
1118: end if;
1119: raise FND_API.G_EXC_ERROR;
1120: end if;

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

1124: l_value_count := null;
1125: l_state := 106;
1126: else
1127: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1128: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1129: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1130: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1131: FND_MESSAGE.SET_TOKEN('EXPECTED', 'BASE_ATTRIBUTE_CODE');
1132: FND_MSG_PUB.Add;

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

1125: l_state := 106;
1126: else
1127: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1128: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1129: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1130: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1131: FND_MESSAGE.SET_TOKEN('EXPECTED', 'BASE_ATTRIBUTE_CODE');
1132: FND_MSG_PUB.Add;
1133: end if;

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

1126: else
1127: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1128: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1129: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1130: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1131: FND_MESSAGE.SET_TOKEN('EXPECTED', 'BASE_ATTRIBUTE_CODE');
1132: FND_MSG_PUB.Add;
1133: end if;
1134: raise FND_API.G_EXC_ERROR;

Line 1131: FND_MESSAGE.SET_TOKEN('EXPECTED', 'BASE_ATTRIBUTE_CODE');

1127: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1128: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1129: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1130: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1131: FND_MESSAGE.SET_TOKEN('EXPECTED', 'BASE_ATTRIBUTE_CODE');
1132: FND_MSG_PUB.Add;
1133: end if;
1134: raise FND_API.G_EXC_ERROR;
1135: end if;

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

1139: l_value_count := null;
1140: l_state := 130;
1141: else
1142: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1143: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1144: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1145: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1146: FND_MESSAGE.SET_TOKEN('EXPECTED', 'DIRECTION_FLAG');
1147: FND_MSG_PUB.Add;

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

1140: l_state := 130;
1141: else
1142: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1143: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1144: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1145: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1146: FND_MESSAGE.SET_TOKEN('EXPECTED', 'DIRECTION_FLAG');
1147: FND_MSG_PUB.Add;
1148: end if;

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

1141: else
1142: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1143: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1144: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1145: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1146: FND_MESSAGE.SET_TOKEN('EXPECTED', 'DIRECTION_FLAG');
1147: FND_MSG_PUB.Add;
1148: end if;
1149: raise FND_API.G_EXC_ERROR;

Line 1146: FND_MESSAGE.SET_TOKEN('EXPECTED', 'DIRECTION_FLAG');

1142: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1143: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1144: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1145: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1146: FND_MESSAGE.SET_TOKEN('EXPECTED', 'DIRECTION_FLAG');
1147: FND_MSG_PUB.Add;
1148: end if;
1149: raise FND_API.G_EXC_ERROR;
1150: end if;

Line 1182: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');

1178: end if;
1179: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1180: (l_value_count is null) then
1181: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1182: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1183: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1184: if (l_value_count is null) then
1185: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1186: else

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

1179: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1180: (l_value_count is null) then
1181: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1182: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1183: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1184: if (l_value_count is null) then
1185: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1186: else
1187: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

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

1181: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1182: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1183: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1184: if (l_value_count is null) then
1185: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1186: else
1187: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1188: end if;
1189: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_LOV_RELATION');

Line 1187: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

1183: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1184: if (l_value_count is null) then
1185: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1186: else
1187: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1188: end if;
1189: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_LOV_RELATION');
1190: FND_MSG_PUB.Add;
1191: end if;

Line 1189: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_LOV_RELATION');

1185: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1186: else
1187: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1188: end if;
1189: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_LOV_RELATION');
1190: FND_MSG_PUB.Add;
1191: end if;
1192: raise FND_API.G_EXC_ERROR;
1193: end if;

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

1196: if (l_token = '=') then
1197: l_state := 132;
1198: else
1199: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1200: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1201: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1202: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1203: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
1204: FND_MSG_PUB.Add;

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

1197: l_state := 132;
1198: else
1199: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1200: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1201: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1202: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1203: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
1204: FND_MSG_PUB.Add;
1205: end if;

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

1198: else
1199: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1200: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1201: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1202: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1203: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
1204: FND_MSG_PUB.Add;
1205: end if;
1206: raise FND_API.G_EXC_ERROR;

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

1199: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1200: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1201: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1202: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1203: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
1204: FND_MSG_PUB.Add;
1205: end if;
1206: raise FND_API.G_EXC_ERROR;
1207: end if;

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

1237: l_lov_relation_rec.last_update_login := to_number(l_token);
1238: l_state := 130;
1239: else
1240: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1241: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1242: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1243: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1244: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1245: FND_MSG_PUB.Add;

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

1238: l_state := 130;
1239: else
1240: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1241: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1242: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1243: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1244: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1245: FND_MSG_PUB.Add;
1246: end if;

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

1239: else
1240: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1241: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1242: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1243: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1244: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1245: FND_MSG_PUB.Add;
1246: end if;
1247: raise FND_API.G_EXC_ERROR;

Line 1244: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');

1240: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1241: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1242: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1243: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1244: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1245: FND_MSG_PUB.Add;
1246: end if;
1247: raise FND_API.G_EXC_ERROR;
1248: end if;

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

1253: l_lov_relation_index := l_lov_relation_index + 1;
1254: l_lov_relation_tbl(l_lov_relation_index) := l_lov_relation_rec;
1255: else
1256: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1257: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1258: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1259: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1260: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_LOV_RELATION');
1261: FND_MSG_PUB.Add;

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

1254: l_lov_relation_tbl(l_lov_relation_index) := l_lov_relation_rec;
1255: else
1256: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1257: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1258: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1259: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1260: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_LOV_RELATION');
1261: FND_MSG_PUB.Add;
1262: end if;

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

1255: else
1256: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1257: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1258: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1259: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1260: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_LOV_RELATION');
1261: FND_MSG_PUB.Add;
1262: end if;
1263: raise FND_API.G_EXC_ERROR;

Line 1260: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_LOV_RELATION');

1256: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1257: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1258: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1259: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1260: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_LOV_RELATION');
1261: FND_MSG_PUB.Add;
1262: end if;
1263: raise FND_API.G_EXC_ERROR;
1264: end if;

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

1273: l_value_count := null;
1274: l_state := 230;
1275: else
1276: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1277: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1278: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1279: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1280: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CATEGORY_ID');
1281: FND_MSG_PUB.Add;

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

1274: l_state := 230;
1275: else
1276: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1277: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1278: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1279: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1280: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CATEGORY_ID');
1281: FND_MSG_PUB.Add;
1282: end if;

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

1275: else
1276: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1277: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1278: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1279: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1280: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CATEGORY_ID');
1281: FND_MSG_PUB.Add;
1282: end if;
1283: raise FND_API.G_EXC_ERROR;

Line 1280: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CATEGORY_ID');

1276: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1277: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1278: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1279: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1280: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CATEGORY_ID');
1281: FND_MSG_PUB.Add;
1282: end if;
1283: raise FND_API.G_EXC_ERROR;
1284: end if;

Line 1316: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');

1312: end if;
1313: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1314: (l_value_count is null) then
1315: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1316: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1317: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1318: if (l_value_count is null) then
1319: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1320: else

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

1313: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1314: (l_value_count is null) then
1315: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1316: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1317: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1318: if (l_value_count is null) then
1319: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1320: else
1321: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

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

1315: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1316: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1317: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1318: if (l_value_count is null) then
1319: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1320: else
1321: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1322: end if;
1323: FND_MESSAGE.SET_TOKEN('EXPECTED','CATEGORY_USAGE');

Line 1321: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

1317: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1318: if (l_value_count is null) then
1319: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1320: else
1321: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1322: end if;
1323: FND_MESSAGE.SET_TOKEN('EXPECTED','CATEGORY_USAGE');
1324: FND_MSG_PUB.Add;
1325: end if;

Line 1323: FND_MESSAGE.SET_TOKEN('EXPECTED','CATEGORY_USAGE');

1319: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1320: else
1321: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1322: end if;
1323: FND_MESSAGE.SET_TOKEN('EXPECTED','CATEGORY_USAGE');
1324: FND_MSG_PUB.Add;
1325: end if;
1326: raise FND_API.G_EXC_ERROR;
1327: end if;

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

1330: if (l_token = '=') then
1331: l_state := 232;
1332: else
1333: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1334: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1335: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1336: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1337: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
1338: FND_MSG_PUB.Add;

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

1331: l_state := 232;
1332: else
1333: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1334: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1335: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1336: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1337: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
1338: FND_MSG_PUB.Add;
1339: end if;

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

1332: else
1333: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1334: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1335: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1336: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1337: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
1338: FND_MSG_PUB.Add;
1339: end if;
1340: raise FND_API.G_EXC_ERROR;

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

1333: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1334: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1335: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1336: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1337: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
1338: FND_MSG_PUB.Add;
1339: end if;
1340: raise FND_API.G_EXC_ERROR;
1341: end if;

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

1371: l_category_usage_rec.last_update_login := to_number(l_token);
1372: l_state := 230;
1373: else
1374: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1375: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1376: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1377: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1378: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1379: FND_MSG_PUB.Add;

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

1372: l_state := 230;
1373: else
1374: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1375: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1376: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1377: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1378: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1379: FND_MSG_PUB.Add;
1380: end if;

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

1373: else
1374: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1375: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1376: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1377: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1378: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1379: FND_MSG_PUB.Add;
1380: end if;
1381: raise FND_API.G_EXC_ERROR;

Line 1378: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');

1374: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1375: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1376: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1377: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1378: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1379: FND_MSG_PUB.Add;
1380: end if;
1381: raise FND_API.G_EXC_ERROR;
1382: end if;

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

1387: l_category_usage_index := l_category_usage_index + 1;
1388: l_category_usage_tbl(l_category_usage_index) := l_category_usage_rec;
1389: else
1390: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1391: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1392: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1393: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1394: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CATEGORY_USAGE');
1395: FND_MSG_PUB.Add;

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

1388: l_category_usage_tbl(l_category_usage_index) := l_category_usage_rec;
1389: else
1390: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1391: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1392: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1393: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1394: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CATEGORY_USAGE');
1395: FND_MSG_PUB.Add;
1396: end if;

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

1389: else
1390: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1391: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1392: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1393: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1394: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CATEGORY_USAGE');
1395: FND_MSG_PUB.Add;
1396: end if;
1397: raise FND_API.G_EXC_ERROR;

Line 1394: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CATEGORY_USAGE');

1390: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1391: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1392: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1393: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1394: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CATEGORY_USAGE');
1395: FND_MSG_PUB.Add;
1396: end if;
1397: raise FND_API.G_EXC_ERROR;
1398: end if;

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

1405: -- l_graph_rec.graph_number := to_number(l_token);
1406: l_state := 310;
1407: else
1408: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1409: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1410: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1411: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1412: FND_MESSAGE.SET_TOKEN('EXPECTED', 'GRAPH_NUMBER');
1413: FND_MSG_PUB.Add;

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

1406: l_state := 310;
1407: else
1408: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1409: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1410: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1411: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1412: FND_MESSAGE.SET_TOKEN('EXPECTED', 'GRAPH_NUMBER');
1413: FND_MSG_PUB.Add;
1414: end if;

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

1407: else
1408: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1409: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1410: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1411: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1412: FND_MESSAGE.SET_TOKEN('EXPECTED', 'GRAPH_NUMBER');
1413: FND_MSG_PUB.Add;
1414: end if;
1415: raise FND_API.G_EXC_ERROR;

Line 1412: FND_MESSAGE.SET_TOKEN('EXPECTED', 'GRAPH_NUMBER');

1408: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1409: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1410: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1411: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1412: FND_MESSAGE.SET_TOKEN('EXPECTED', 'GRAPH_NUMBER');
1413: FND_MSG_PUB.Add;
1414: end if;
1415: raise FND_API.G_EXC_ERROR;
1416: end if;

Line 1451: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');

1447: end if;
1448: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1449: (l_value_count is null) then
1450: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1451: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1452: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1453: if (l_value_count is null) then
1454: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1455: else

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

1448: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1449: (l_value_count is null) then
1450: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1451: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1452: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1453: if (l_value_count is null) then
1454: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1455: else
1456: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

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

1450: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1451: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1452: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1453: if (l_value_count is null) then
1454: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1455: else
1456: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1457: end if;
1458: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_GRAPH');

Line 1456: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

1452: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1453: if (l_value_count is null) then
1454: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1455: else
1456: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1457: end if;
1458: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_GRAPH');
1459: FND_MSG_PUB.Add;
1460: end if;

Line 1458: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_GRAPH');

1454: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1455: else
1456: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1457: end if;
1458: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_GRAPH');
1459: FND_MSG_PUB.Add;
1460: end if;
1461: raise FND_API.G_EXC_ERROR;
1462: end if;

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

1465: if (l_token = '=') then
1466: l_state := 312;
1467: else
1468: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1469: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1470: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1471: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1472: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
1473: FND_MSG_PUB.Add;

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

1466: l_state := 312;
1467: else
1468: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1469: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1470: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1471: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1472: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
1473: FND_MSG_PUB.Add;
1474: end if;

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

1467: else
1468: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1469: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1470: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1471: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1472: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
1473: FND_MSG_PUB.Add;
1474: end if;
1475: raise FND_API.G_EXC_ERROR;

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

1468: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1469: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1470: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1471: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1472: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
1473: FND_MSG_PUB.Add;
1474: end if;
1475: raise FND_API.G_EXC_ERROR;
1476: end if;

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

1509: -- l_graph_rec.last_update_login := to_number(l_token);
1510: l_state := 310;
1511: else
1512: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1513: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1514: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1515: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1516: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1517: FND_MSG_PUB.Add;

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

1510: l_state := 310;
1511: else
1512: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1513: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1514: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1515: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1516: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1517: FND_MSG_PUB.Add;
1518: end if;

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

1511: else
1512: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1513: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1514: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1515: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1516: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1517: FND_MSG_PUB.Add;
1518: end if;
1519: raise FND_API.G_EXC_ERROR;

Line 1516: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');

1512: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1513: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1514: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1515: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1516: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1517: FND_MSG_PUB.Add;
1518: end if;
1519: raise FND_API.G_EXC_ERROR;
1520: end if;

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

1525: -- l_graph_index := l_graph_index + 1;
1526: -- l_graph_tbl(l_graph_index) := l_graph_rec;
1527: else
1528: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1529: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1530: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1531: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1532: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_GRAPH');
1533: FND_MSG_PUB.Add;

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

1526: -- l_graph_tbl(l_graph_index) := l_graph_rec;
1527: else
1528: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1529: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1530: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1531: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1532: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_GRAPH');
1533: FND_MSG_PUB.Add;
1534: end if;

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

1527: else
1528: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1529: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1530: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1531: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1532: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_GRAPH');
1533: FND_MSG_PUB.Add;
1534: end if;
1535: raise FND_API.G_EXC_ERROR;

Line 1532: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_GRAPH');

1528: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1529: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1530: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1531: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1532: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_GRAPH');
1533: FND_MSG_PUB.Add;
1534: end if;
1535: raise FND_API.G_EXC_ERROR;
1536: end if;

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

1543: -- l_graph_column_rec.attribute_application_id := to_number(l_token);
1544: l_state := 401;
1545: else
1546: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1547: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1548: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1549: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1550: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
1551: FND_MSG_PUB.Add;

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

1544: l_state := 401;
1545: else
1546: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1547: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1548: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1549: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1550: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
1551: FND_MSG_PUB.Add;
1552: end if;

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

1545: else
1546: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1547: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1548: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1549: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1550: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
1551: FND_MSG_PUB.Add;
1552: end if;
1553: raise FND_API.G_EXC_ERROR;

Line 1550: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');

1546: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1547: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1548: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1549: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1550: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
1551: FND_MSG_PUB.Add;
1552: end if;
1553: raise FND_API.G_EXC_ERROR;
1554: end if;

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

1558: l_value_count := null;
1559: l_state := 410;
1560: else
1561: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1562: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1563: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1564: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1565: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
1566: FND_MSG_PUB.Add;

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

1559: l_state := 410;
1560: else
1561: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1562: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1563: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1564: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1565: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
1566: FND_MSG_PUB.Add;
1567: end if;

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

1560: else
1561: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1562: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1563: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1564: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1565: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
1566: FND_MSG_PUB.Add;
1567: end if;
1568: raise FND_API.G_EXC_ERROR;

Line 1565: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');

1561: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1562: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1563: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1564: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1565: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
1566: FND_MSG_PUB.Add;
1567: end if;
1568: raise FND_API.G_EXC_ERROR;
1569: end if;

Line 1590: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');

1586: end if;
1587: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1588: (l_value_count is null) then
1589: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1590: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1591: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1592: if (l_value_count is null) then
1593: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1594: else

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

1587: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1588: (l_value_count is null) then
1589: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1590: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1591: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1592: if (l_value_count is null) then
1593: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1594: else
1595: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

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

1589: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1590: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1591: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1592: if (l_value_count is null) then
1593: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1594: else
1595: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1596: end if;
1597: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_GRAPH_COLUMN');

Line 1595: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

1591: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1592: if (l_value_count is null) then
1593: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1594: else
1595: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1596: end if;
1597: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_GRAPH_COLUMN');
1598: FND_MSG_PUB.Add;
1599: end if;

Line 1597: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_GRAPH_COLUMN');

1593: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
1594: else
1595: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1596: end if;
1597: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_GRAPH_COLUMN');
1598: FND_MSG_PUB.Add;
1599: end if;
1600: raise FND_API.G_EXC_ERROR;
1601: end if;

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

1607: -- l_graph_column_index := l_graph_column_index + 1;
1608: -- l_graph_column_tbl(l_graph_column_index) := l_graph_column_rec;
1609: else
1610: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1611: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1612: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1613: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1614: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_GRAPH_COLUMN');
1615: FND_MSG_PUB.Add;

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

1608: -- l_graph_column_tbl(l_graph_column_index) := l_graph_column_rec;
1609: else
1610: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1611: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1612: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1613: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1614: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_GRAPH_COLUMN');
1615: FND_MSG_PUB.Add;
1616: end if;

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

1609: else
1610: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1611: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1612: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1613: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1614: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_GRAPH_COLUMN');
1615: FND_MSG_PUB.Add;
1616: end if;
1617: raise FND_API.G_EXC_ERROR;

Line 1614: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_GRAPH_COLUMN');

1610: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1611: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1612: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1613: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1614: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_GRAPH_COLUMN');
1615: FND_MSG_PUB.Add;
1616: end if;
1617: raise FND_API.G_EXC_ERROR;
1618: end if;

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

1654: -- (state 0) or when the beginning of another business object was
1655: -- detected, then the file must have ended prematurely, which is an error
1656: if (l_state <> 0) and (l_more_region) then
1657: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1658: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1659: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1660: FND_MESSAGE.SET_TOKEN('TOKEN', 'END OF FILE');
1661: FND_MESSAGE.SET_TOKEN('EXPECTED', null);
1662: FND_MSG_PUB.Add;

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

1655: -- detected, then the file must have ended prematurely, which is an error
1656: if (l_state <> 0) and (l_more_region) then
1657: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1658: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1659: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1660: FND_MESSAGE.SET_TOKEN('TOKEN', 'END OF FILE');
1661: FND_MESSAGE.SET_TOKEN('EXPECTED', null);
1662: FND_MSG_PUB.Add;
1663: end if;

Line 1660: FND_MESSAGE.SET_TOKEN('TOKEN', 'END OF FILE');

1656: if (l_state <> 0) and (l_more_region) then
1657: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1658: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1659: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1660: FND_MESSAGE.SET_TOKEN('TOKEN', 'END OF FILE');
1661: FND_MESSAGE.SET_TOKEN('EXPECTED', null);
1662: FND_MSG_PUB.Add;
1663: end if;
1664: --dbms_output.put_line('Unexpected END OF FILE: state is ' ||

Line 1661: FND_MESSAGE.SET_TOKEN('EXPECTED', null);

1657: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1658: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1659: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1660: FND_MESSAGE.SET_TOKEN('TOKEN', 'END OF FILE');
1661: FND_MESSAGE.SET_TOKEN('EXPECTED', null);
1662: FND_MSG_PUB.Add;
1663: end if;
1664: --dbms_output.put_line('Unexpected END OF FILE: state is ' ||
1665: -- to_char(l_state));

Line 2539: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_SKIPPED');

2535: if (l_category_usage_tbl(l_index).category_name is null) then
2536: open l_check_fnd_category_name_csr(l_category_usage_tbl(l_index).category_id);
2537: fetch l_check_fnd_category_name_csr into l_category_usage_tbl(l_index).category_name;
2538: if (l_check_fnd_category_name_csr%notfound) then
2539: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_SKIPPED');
2540: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_category_usage_tbl(l_index).category_id));
2541: FND_MSG_PUB.Add;
2542: end if;
2543: close l_check_fnd_category_name_csr;

Line 2540: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_category_usage_tbl(l_index).category_id));

2536: open l_check_fnd_category_name_csr(l_category_usage_tbl(l_index).category_id);
2537: fetch l_check_fnd_category_name_csr into l_category_usage_tbl(l_index).category_name;
2538: if (l_check_fnd_category_name_csr%notfound) then
2539: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_SKIPPED');
2540: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_category_usage_tbl(l_index).category_id));
2541: FND_MSG_PUB.Add;
2542: end if;
2543: close l_check_fnd_category_name_csr;
2544: elsif (l_category_usage_tbl(l_index).category_name is not null) then

Line 2549: FND_MESSAGE.SET_NAME('AK','AK_FND_CATEGORY_DOES_NOT_EXIST');

2545: open l_check_fnd_category_id_csr(l_category_usage_tbl(l_index).category_name);
2546: fetch l_check_fnd_category_id_csr into l_category_usage_tbl(l_index).category_id;
2547: if (l_check_fnd_category_id_csr%notfound) then
2548: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2549: FND_MESSAGE.SET_NAME('AK','AK_FND_CATEGORY_DOES_NOT_EXIST');
2550: FND_MESSAGE.SET_TOKEN('KEY', (l_category_usage_tbl(l_index).category_name));
2551: FND_MSG_PUB.Add;
2552: end if;
2553: close l_check_fnd_category_id_csr;

Line 2550: FND_MESSAGE.SET_TOKEN('KEY', (l_category_usage_tbl(l_index).category_name));

2546: fetch l_check_fnd_category_id_csr into l_category_usage_tbl(l_index).category_id;
2547: if (l_check_fnd_category_id_csr%notfound) then
2548: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2549: FND_MESSAGE.SET_NAME('AK','AK_FND_CATEGORY_DOES_NOT_EXIST');
2550: FND_MESSAGE.SET_TOKEN('KEY', (l_category_usage_tbl(l_index).category_name));
2551: FND_MSG_PUB.Add;
2552: end if;
2553: close l_check_fnd_category_id_csr;
2554: raise FND_API.G_EXC_ERROR;

Line 2889: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');

2885: p_return_status := FND_API.G_RET_STS_ERROR;
2886: --rollback to Start_Upload;
2887: WHEN VALUE_ERROR THEN
2888: p_return_status := FND_API.G_RET_STS_ERROR;
2889: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
2890: FND_MESSAGE.SET_TOKEN('KEY',to_char(l_region_rec.region_application_id)||' '||
2891: l_region_rec.region_code);
2892: FND_MSG_PUB.Add;
2893: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 2890: FND_MESSAGE.SET_TOKEN('KEY',to_char(l_region_rec.region_application_id)||' '||

2886: --rollback to Start_Upload;
2887: WHEN VALUE_ERROR THEN
2888: p_return_status := FND_API.G_RET_STS_ERROR;
2889: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
2890: FND_MESSAGE.SET_TOKEN('KEY',to_char(l_region_rec.region_application_id)||' '||
2891: l_region_rec.region_code);
2892: FND_MSG_PUB.Add;
2893: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2894: SUBSTR (SQLERRM, 1, 240)||': '||l_column||'='||l_token );

Line 4152: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4148: if ((p_region_application_id is null) or
4149: (p_region_application_id = FND_API.G_MISS_NUM)) then
4150: l_error := TRUE;
4151: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4152: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4153: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4154: FND_MSG_PUB.Add;
4155: end if;
4156: end if;

Line 4153: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');

4149: (p_region_application_id = FND_API.G_MISS_NUM)) then
4150: l_error := TRUE;
4151: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4152: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4153: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4154: FND_MSG_PUB.Add;
4155: end if;
4156: end if;
4157:

Line 4162: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4158: if ((p_region_code is null) or
4159: (p_region_code = FND_API.G_MISS_CHAR)) then
4160: l_error := TRUE;
4161: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4162: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4163: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4164: FND_MSG_PUB.Add;
4165: end if;
4166: end if;

Line 4163: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');

4159: (p_region_code = FND_API.G_MISS_CHAR)) then
4160: l_error := TRUE;
4161: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4162: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4163: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4164: FND_MSG_PUB.Add;
4165: end if;
4166: end if;
4167:

Line 4172: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4168: if ((p_attribute_application_id is null) or
4169: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
4170: l_error := TRUE;
4171: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4172: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4173: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4174: FND_MSG_PUB.Add;
4175: end if;
4176: end if;

Line 4173: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');

4169: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
4170: l_error := TRUE;
4171: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4172: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4173: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4174: FND_MSG_PUB.Add;
4175: end if;
4176: end if;
4177:

Line 4182: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4178: if ((p_attribute_code is null) or
4179: (p_attribute_code = FND_API.G_MISS_CHAR)) then
4180: l_error := TRUE;
4181: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4182: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4183: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4184: FND_MSG_PUB.Add;
4185: end if;
4186: end if;

Line 4183: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');

4179: (p_attribute_code = FND_API.G_MISS_CHAR)) then
4180: l_error := TRUE;
4181: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4182: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4183: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4184: FND_MSG_PUB.Add;
4185: end if;
4186: end if;
4187:

Line 4192: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4188: if ((p_graph_number is null) or
4189: (p_graph_number = FND_API.G_MISS_NUM)) then
4190: l_error := TRUE;
4191: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4192: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4193: FND_MESSAGE.SET_TOKEN('COLUMN', 'GRAPH_NUMBER');
4194: FND_MSG_PUB.Add;
4195: end if;
4196: end if;

Line 4193: FND_MESSAGE.SET_TOKEN('COLUMN', 'GRAPH_NUMBER');

4189: (p_graph_number = FND_API.G_MISS_NUM)) then
4190: l_error := TRUE;
4191: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4192: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4193: FND_MESSAGE.SET_TOKEN('COLUMN', 'GRAPH_NUMBER');
4194: FND_MSG_PUB.Add;
4195: end if;
4196: end if;
4197:

Line 4204: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');

4200: fetch l_check_region_item_csr into l_dummy;
4201: if (l_check_region_item_csr%notfound) then
4202: l_error := TRUE;
4203: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4204: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
4205: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4206: ' ' || p_region_code ||' '||
4207: to_char(p_attribute_application_id) || ' '||
4208: p_attribute_code);

Line 4205: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

4201: if (l_check_region_item_csr%notfound) then
4202: l_error := TRUE;
4203: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4204: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
4205: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4206: ' ' || p_region_code ||' '||
4207: to_char(p_attribute_application_id) || ' '||
4208: p_attribute_code);
4209: FND_MSG_PUB.Add;

Line 4220: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_GRAPH_REFERENCE');

4216: fetch l_check_Region_graph_csr into l_dummy;
4217: if (l_check_region_graph_csr%notfound) then
4218: l_error := TRUE;
4219: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4220: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_GRAPH_REFERENCE');
4221: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4222: ' ' || p_region_code ||' '||
4223: p_graph_number);
4224: FND_MSG_PUB.Add;

Line 4221: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

4217: if (l_check_region_graph_csr%notfound) then
4218: l_error := TRUE;
4219: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4220: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_GRAPH_REFERENCE');
4221: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4222: ' ' || p_region_code ||' '||
4223: p_graph_number);
4224: FND_MSG_PUB.Add;
4225: end if;

Line 4339: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4335: if ((p_region_application_id is null) or
4336: (p_region_application_id = FND_API.G_MISS_NUM)) then
4337: l_error := TRUE;
4338: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4339: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4340: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4341: FND_MSG_PUB.Add;
4342: end if;
4343: end if;

Line 4340: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');

4336: (p_region_application_id = FND_API.G_MISS_NUM)) then
4337: l_error := TRUE;
4338: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4339: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4340: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4341: FND_MSG_PUB.Add;
4342: end if;
4343: end if;
4344:

Line 4349: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4345: if ((p_region_code is null) or
4346: (p_region_code = FND_API.G_MISS_CHAR)) then
4347: l_error := TRUE;
4348: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4349: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4350: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4351: FND_MSG_PUB.Add;
4352: end if;
4353: end if;

Line 4350: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');

4346: (p_region_code = FND_API.G_MISS_CHAR)) then
4347: l_error := TRUE;
4348: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4349: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4350: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4351: FND_MSG_PUB.Add;
4352: end if;
4353: end if;
4354:

Line 4359: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4355: if ((p_attribute_application_id is null) or
4356: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
4357: l_error := TRUE;
4358: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4359: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4360: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4361: FND_MSG_PUB.Add;
4362: end if;
4363: end if;

Line 4360: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');

4356: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
4357: l_error := TRUE;
4358: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4359: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4360: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4361: FND_MSG_PUB.Add;
4362: end if;
4363: end if;
4364:

Line 4369: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4365: if ((p_attribute_code is null) or
4366: (p_attribute_code = FND_API.G_MISS_CHAR)) then
4367: l_error := TRUE;
4368: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4369: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4370: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4371: FND_MSG_PUB.Add;
4372: end if;
4373: end if;

Line 4370: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');

4366: (p_attribute_code = FND_API.G_MISS_CHAR)) then
4367: l_error := TRUE;
4368: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4369: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4370: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4371: FND_MSG_PUB.Add;
4372: end if;
4373: end if;
4374:

Line 4379: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4375: if ((p_lov_region_appl_id is null) or
4376: (p_lov_region_appl_id = FND_API.G_MISS_NUM)) then
4377: l_error := TRUE;
4378: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4379: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4380: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4381: FND_MSG_PUB.Add;
4382: end if;
4383: end if;

Line 4380: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');

4376: (p_lov_region_appl_id = FND_API.G_MISS_NUM)) then
4377: l_error := TRUE;
4378: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4379: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4380: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4381: FND_MSG_PUB.Add;
4382: end if;
4383: end if;
4384:

Line 4389: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4385: if ((p_lov_region_code is null) or
4386: (p_lov_region_code = FND_API.G_MISS_CHAR)) then
4387: l_error := TRUE;
4388: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4389: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4390: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4391: FND_MSG_PUB.Add;
4392: end if;
4393: end if;

Line 4390: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');

4386: (p_lov_region_code = FND_API.G_MISS_CHAR)) then
4387: l_error := TRUE;
4388: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4389: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4390: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4391: FND_MSG_PUB.Add;
4392: end if;
4393: end if;
4394:

Line 4399: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4395: if ((p_lov_attribute_appl_id is null) or
4396: (p_lov_attribute_appl_id = FND_API.G_MISS_NUM)) then
4397: l_error := TRUE;
4398: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4399: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4400: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4401: FND_MSG_PUB.Add;
4402: end if;
4403: end if;

Line 4400: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');

4396: (p_lov_attribute_appl_id = FND_API.G_MISS_NUM)) then
4397: l_error := TRUE;
4398: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4399: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4400: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4401: FND_MSG_PUB.Add;
4402: end if;
4403: end if;
4404:

Line 4409: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4405: if ((p_lov_attribute_code is null) or
4406: (p_lov_attribute_code = FND_API.G_MISS_CHAR)) then
4407: l_error := TRUE;
4408: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4409: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4410: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4411: FND_MSG_PUB.Add;
4412: end if;
4413: end if;

Line 4410: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');

4406: (p_lov_attribute_code = FND_API.G_MISS_CHAR)) then
4407: l_error := TRUE;
4408: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4409: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4410: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4411: FND_MSG_PUB.Add;
4412: end if;
4413: end if;
4414:

Line 4423: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4419: (p_base_region_appl_id = FND_API.G_MISS_NUM)) then
4420:
4421: l_error := TRUE;
4422: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4423: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4424: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_REGION_APPL_ID');
4425: FND_MSG_PUB.Add;
4426: end if;
4427: end if;

Line 4424: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_REGION_APPL_ID');

4420:
4421: l_error := TRUE;
4422: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4423: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4424: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_REGION_APPL_ID');
4425: FND_MSG_PUB.Add;
4426: end if;
4427: end if;
4428: **/

Line 4437: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4433: if ((p_base_region_code is null) or
4434: (p_base_region_code = FND_API.G_MISS_CHAR)) then
4435: l_error := TRUE;
4436: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4437: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4438: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_REGION_CODE');
4439: FND_MSG_PUB.Add;
4440: end if;
4441: end if;

Line 4438: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_REGION_CODE');

4434: (p_base_region_code = FND_API.G_MISS_CHAR)) then
4435: l_error := TRUE;
4436: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4437: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4438: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_REGION_CODE');
4439: FND_MSG_PUB.Add;
4440: end if;
4441: end if;
4442: **/

Line 4450: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4446: if ((p_base_attribute_appl_id is null) or
4447: (p_base_attribute_appl_id = FND_API.G_MISS_NUM)) then
4448: l_error := TRUE;
4449: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4450: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4451: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_ATTRIBUTE_APPL_ID');
4452: FND_MSG_PUB.Add;
4453: end if;
4454: end if;

Line 4451: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_ATTRIBUTE_APPL_ID');

4447: (p_base_attribute_appl_id = FND_API.G_MISS_NUM)) then
4448: l_error := TRUE;
4449: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4450: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4451: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_ATTRIBUTE_APPL_ID');
4452: FND_MSG_PUB.Add;
4453: end if;
4454: end if;
4455:

Line 4460: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4456: if ((p_base_attribute_code is null) or
4457: (p_base_attribute_code = FND_API.G_MISS_CHAR)) then
4458: l_error := TRUE;
4459: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4460: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4461: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_ATTRIBUTE_CODE');
4462: FND_MSG_PUB.Add;
4463: end if;
4464: end if;

Line 4461: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_ATTRIBUTE_CODE');

4457: (p_base_attribute_code = FND_API.G_MISS_CHAR)) then
4458: l_error := TRUE;
4459: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4460: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4461: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_ATTRIBUTE_CODE');
4462: FND_MSG_PUB.Add;
4463: end if;
4464: end if;
4465:

Line 4473: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');

4469: fetch l_check_region_item_csr into l_dummy;
4470: if (l_check_region_item_csr%notfound) then
4471: l_error := TRUE;
4472: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4473: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
4474: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4475: ' ' || p_region_code ||' '||
4476: to_char(p_attribute_application_id)||' '||p_attribute_code);
4477: FND_MSG_PUB.Add;

Line 4474: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

4470: if (l_check_region_item_csr%notfound) then
4471: l_error := TRUE;
4472: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4473: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
4474: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4475: ' ' || p_region_code ||' '||
4476: to_char(p_attribute_application_id)||' '||p_attribute_code);
4477: FND_MSG_PUB.Add;
4478: end if;

Line 4488: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_REG_REFERENCE');

4484: fetch l_check_region_csr into l_dummy;
4485: if (l_check_region_csr%notfound) then
4486: l_error := TRUE;
4487: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4488: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_REG_REFERENCE');
4489: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4490: ' ' || p_lov_region_code );
4491: FND_MSG_PUB.Add;
4492: end if;

Line 4489: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||

4485: if (l_check_region_csr%notfound) then
4486: l_error := TRUE;
4487: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4488: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_REG_REFERENCE');
4489: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4490: ' ' || p_lov_region_code );
4491: FND_MSG_PUB.Add;
4492: end if;
4493: end if;

Line 4503: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_ITEM_REFERENCE');

4499: fetch l_check_region_item_csr into l_dummy;
4500: if (l_check_region_item_csr%notfound) then
4501: l_error := TRUE;
4502: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4503: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_ITEM_REFERENCE');
4504: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4505: ' ' || p_lov_region_code ||' '||
4506: to_char(p_lov_attribute_appl_id)||' '||p_lov_attribute_code);
4507: FND_MSG_PUB.Add;

Line 4504: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||

4500: if (l_check_region_item_csr%notfound) then
4501: l_error := TRUE;
4502: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4503: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_ITEM_REFERENCE');
4504: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4505: ' ' || p_lov_region_code ||' '||
4506: to_char(p_lov_attribute_appl_id)||' '||p_lov_attribute_code);
4507: FND_MSG_PUB.Add;
4508: end if;

Line 4519: FND_MESSAGE.SET_NAME('AK','AK_INVALID_BASE_ITEM_REF');

4515: fetch l_check_region_item_csr into l_dummy;
4516: if (l_check_region_item_csr%notfound) then
4517: l_error := TRUE;
4518: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4519: FND_MESSAGE.SET_NAME('AK','AK_INVALID_BASE_ITEM_REF');
4520: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4521: ' ' || p_lov_region_code ||' '||
4522: to_char(p_base_attribute_appl_id)||' '||p_base_attribute_code);
4523: FND_MSG_PUB.Add;

Line 4520: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||

4516: if (l_check_region_item_csr%notfound) then
4517: l_error := TRUE;
4518: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4519: FND_MESSAGE.SET_NAME('AK','AK_INVALID_BASE_ITEM_REF');
4520: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4521: ' ' || p_lov_region_code ||' '||
4522: to_char(p_base_attribute_appl_id)||' '||p_base_attribute_code);
4523: FND_MSG_PUB.Add;
4524: end if;

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

4534: p_lookup_type => 'LOV_DIRECTION',
4535: p_lookup_code => p_direction_flag)) then
4536: l_error := TRUE;
4537: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4538: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
4539: FND_MESSAGE.SET_TOKEN('COLUMN','DIRECTION_FLAG');
4540: FND_MSG_PUB.Add;
4541: end if;
4542: end if;

Line 4539: FND_MESSAGE.SET_TOKEN('COLUMN','DIRECTION_FLAG');

4535: p_lookup_code => p_direction_flag)) then
4536: l_error := TRUE;
4537: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4538: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
4539: FND_MESSAGE.SET_TOKEN('COLUMN','DIRECTION_FLAG');
4540: FND_MSG_PUB.Add;
4541: end if;
4542: end if;
4543: else

Line 4546: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4542: end if;
4543: else
4544: l_error := TRUE;
4545: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4546: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4547: FND_MESSAGE.SET_TOKEN('COLUMN', 'DIRECTION_FLAG');
4548: FND_MSG_PUB.Add;
4549: end if;
4550: end if;

Line 4547: FND_MESSAGE.SET_TOKEN('COLUMN', 'DIRECTION_FLAG');

4543: else
4544: l_error := TRUE;
4545: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4546: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4547: FND_MESSAGE.SET_TOKEN('COLUMN', 'DIRECTION_FLAG');
4548: FND_MSG_PUB.Add;
4549: end if;
4550: end if;
4551:

Line 4652: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_EXISTS');

4648: p_attribute_application_id => p_attribute_application_id,
4649: p_attribute_code => p_attribute_code,
4650: p_graph_number => p_graph_number) then
4651: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4652: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_EXISTS');
4653: FND_MSG_PUB.Add;
4654: end if;
4655: raise FND_API.G_EXC_ERROR;
4656: end if;

Line 4728: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_CREATED');

4724: -- ** commit the insert **
4725: -- commit;
4726:
4727: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4728: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_CREATED');
4729: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||
4730: p_region_code||' '||
4731: to_char(p_attribute_application_id)||
4732: ' '||p_attribute_code||' '||

Line 4729: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||

4725: -- commit;
4726:
4727: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4728: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_CREATED');
4729: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||
4730: p_region_code||' '||
4731: to_char(p_attribute_application_id)||
4732: ' '||p_attribute_code||' '||
4733: to_char(p_graph_number));

Line 4746: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_VALUE_ERROR');

4742:
4743: EXCEPTION
4744: WHEN VALUE_ERROR THEN
4745: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4746: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_VALUE_ERROR');
4747: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
4748: p_region_code||' '||
4749: to_char(p_attribute_application_id)||
4750: ' '||p_attribute_code||' '||

Line 4747: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||

4743: EXCEPTION
4744: WHEN VALUE_ERROR THEN
4745: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4746: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_VALUE_ERROR');
4747: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
4748: p_region_code||' '||
4749: to_char(p_attribute_application_id)||
4750: ' '||p_attribute_code||' '||
4751: to_char(p_graph_number));

Line 4873: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_EXISTS');

4869: p_direction_flag => p_direction_flag,
4870: p_base_region_appl_id => p_base_region_appl_id,
4871: p_base_region_code => p_base_region_code) then
4872: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4873: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_EXISTS');
4874: FND_MSG_PUB.Add;
4875: end if;
4876: raise FND_API.G_EXC_ERROR;
4877: end if;

Line 5004: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_CREATED');

5000: -- /** commit the insert **/
5001: -- commit;
5002:
5003: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5004: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_CREATED');
5005: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||
5006: p_region_code||' '||to_char(p_attribute_application_id)||
5007: ' '||p_attribute_code||' '||
5008: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||

Line 5005: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||

5001: -- commit;
5002:
5003: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5004: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_CREATED');
5005: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||
5006: p_region_code||' '||to_char(p_attribute_application_id)||
5007: ' '||p_attribute_code||' '||
5008: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||
5009: ' '||to_char(p_lov_attribute_appl_id)||' '||

Line 5026: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');

5022:
5023: EXCEPTION
5024: WHEN VALUE_ERROR THEN
5025: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5026: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
5027: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5028: p_region_code||' '||to_char(p_attribute_application_id)||
5029: ' '||p_attribute_code||' '||
5030: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||

Line 5027: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||

5023: EXCEPTION
5024: WHEN VALUE_ERROR THEN
5025: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5026: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
5027: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5028: p_region_code||' '||to_char(p_attribute_application_id)||
5029: ' '||p_attribute_code||' '||
5030: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||
5031: ' '||to_char(p_lov_attribute_appl_id)||' '||

Line 5043: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_CREATED');

5039: p_count => p_msg_count,
5040: p_data => p_msg_data);
5041: WHEN FND_API.G_EXC_ERROR THEN
5042: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5043: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_CREATED');
5044: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5045: p_region_code||' '||to_char(p_attribute_application_id)||
5046: ' '||p_attribute_code||' '||
5047: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||

Line 5044: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||

5040: p_data => p_msg_data);
5041: WHEN FND_API.G_EXC_ERROR THEN
5042: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5043: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_CREATED');
5044: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5045: p_region_code||' '||to_char(p_attribute_application_id)||
5046: ' '||p_attribute_code||' '||
5047: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||
5048: ' '||to_char(p_lov_attribute_appl_id)||' '||

Line 5154: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_DOES_NOT_EXIST');

5150: open l_get_row_csr;
5151: fetch l_get_row_csr into l_graph_column_rec;
5152: if (l_get_row_csr%notfound) then
5153: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5154: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_DOES_NOT_EXIST');
5155: FND_MSG_PUB.Add;
5156: end if;
5157: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
5158: close l_get_row_csr;

Line 5221: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_UPDATE_FAILED');

5217: and ATTRIBUTE_CODE = p_attribute_code
5218: and GRAPH_NUMBER = p_graph_number;
5219: if (sql%notfound) then
5220: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5221: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_UPDATE_FAILED');
5222: FND_MSG_PUB.Add;
5223: end if;
5224: raise FND_API.G_EXC_ERROR;
5225: end if;

Line 5231: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_UPDATED');

5227: -- ** commit the update **
5228: -- commit;
5229:
5230: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5231: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_UPDATED');
5232: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5233: ' ' || p_region_code);
5234: FND_MSG_PUB.Add;
5235: end if;

Line 5232: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

5228: -- commit;
5229:
5230: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5231: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_UPDATED');
5232: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5233: ' ' || p_region_code);
5234: FND_MSG_PUB.Add;
5235: end if;
5236:

Line 5246: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_VALUE_ERROR');

5242:
5243: EXCEPTION
5244: WHEN VALUE_ERROR THEN
5245: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5246: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_VALUE_ERROR');
5247: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5248: p_region_code||' '||
5249: to_char(p_attribute_application_id)||
5250: ' '||p_attribute_code||' '||

Line 5247: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||

5243: EXCEPTION
5244: WHEN VALUE_ERROR THEN
5245: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5246: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_VALUE_ERROR');
5247: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5248: p_region_code||' '||
5249: to_char(p_attribute_application_id)||
5250: ' '||p_attribute_code||' '||
5251: to_char(p_graph_number));

Line 5261: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_NOT_UPDATED');

5257: p_count => p_msg_count,
5258: p_data => p_msg_data);
5259: WHEN FND_API.G_EXC_ERROR THEN
5260: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5261: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_NOT_UPDATED');
5262: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5263: p_region_code||' '||
5264: to_char(p_attribute_application_id)||
5265: ' '||p_attribute_code||' '||

Line 5262: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||

5258: p_data => p_msg_data);
5259: WHEN FND_API.G_EXC_ERROR THEN
5260: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5261: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_NOT_UPDATED');
5262: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5263: p_region_code||' '||
5264: to_char(p_attribute_application_id)||
5265: ' '||p_attribute_code||' '||
5266: to_char(p_graph_number));

Line 5391: FND_MESSAGE.SET_NAME('AK','AK_LOV_REGION_DOES_NOT_EXIST');

5387: open l_get_row_csr;
5388: fetch l_get_row_csr into l_lov_relation_rec;
5389: if (l_get_row_csr%notfound) then
5390: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5391: FND_MESSAGE.SET_NAME('AK','AK_LOV_REGION_DOES_NOT_EXIST');
5392: FND_MSG_PUB.Add;
5393: end if;
5394: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
5395: close l_get_row_csr;

Line 5500: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_UPDATE_FAILED');

5496: and BASE_REGION_APPL_ID = p_base_region_appl_id
5497: and BASE_REGION_CODE = p_base_region_code;
5498: if (sql%notfound) then
5499: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5500: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_UPDATE_FAILED');
5501: FND_MSG_PUB.Add;
5502: end if;
5503: raise FND_API.G_EXC_ERROR;
5504: end if;

Line 5510: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_UPDATED');

5506: -- /** commit the update **/
5507: -- commit;
5508:
5509: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5510: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_UPDATED');
5511: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5512: ' ' || p_region_code);
5513: FND_MSG_PUB.Add;
5514: end if;

Line 5511: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

5507: -- commit;
5508:
5509: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5510: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_UPDATED');
5511: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5512: ' ' || p_region_code);
5513: FND_MSG_PUB.Add;
5514: end if;
5515:

Line 5529: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_VALUE_ERROR');

5525:
5526: EXCEPTION
5527: WHEN VALUE_ERROR THEN
5528: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5529: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_VALUE_ERROR');
5530: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5531: p_region_code||' '||to_char(p_attribute_application_id)||
5532: ' '||p_attribute_code||' '||
5533: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||

Line 5530: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||

5526: EXCEPTION
5527: WHEN VALUE_ERROR THEN
5528: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5529: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_VALUE_ERROR');
5530: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5531: p_region_code||' '||to_char(p_attribute_application_id)||
5532: ' '||p_attribute_code||' '||
5533: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||
5534: ' '||to_char(p_lov_attribute_appl_id)||' '||

Line 5547: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_NOT_UPDATED');

5543: p_count => p_msg_count,
5544: p_data => p_msg_data);
5545: WHEN FND_API.G_EXC_ERROR THEN
5546: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5547: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_NOT_UPDATED');
5548: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5549: p_region_code||' '||to_char(p_attribute_application_id)||
5550: ' '||p_attribute_code||' '||
5551: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||

Line 5548: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||

5544: p_data => p_msg_data);
5545: WHEN FND_API.G_EXC_ERROR THEN
5546: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5547: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_NOT_UPDATED');
5548: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5549: p_region_code||' '||to_char(p_attribute_application_id)||
5550: ' '||p_attribute_code||' '||
5551: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||
5552: ' '||to_char(p_lov_attribute_appl_id)||' '||

Line 5741: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

5737: if ((p_region_application_id is null) or
5738: (p_region_application_id = FND_API.G_MISS_NUM)) then
5739: l_error := TRUE;
5740: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5741: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5742: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
5743: FND_MSG_PUB.Add;
5744: end if;
5745: end if;

Line 5742: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');

5738: (p_region_application_id = FND_API.G_MISS_NUM)) then
5739: l_error := TRUE;
5740: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5741: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5742: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
5743: FND_MSG_PUB.Add;
5744: end if;
5745: end if;
5746:

Line 5751: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

5747: if ((p_region_code is null) or
5748: (p_region_code = FND_API.G_MISS_CHAR)) then
5749: l_error := TRUE;
5750: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5751: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5752: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
5753: FND_MSG_PUB.Add;
5754: end if;
5755: end if;

Line 5752: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');

5748: (p_region_code = FND_API.G_MISS_CHAR)) then
5749: l_error := TRUE;
5750: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5751: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5752: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
5753: FND_MSG_PUB.Add;
5754: end if;
5755: end if;
5756:

Line 5761: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

5757: if ((p_attribute_application_id is null) or
5758: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
5759: l_error := TRUE;
5760: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5761: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5762: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
5763: FND_MSG_PUB.Add;
5764: end if;
5765: end if;

Line 5762: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');

5758: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
5759: l_error := TRUE;
5760: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5761: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5762: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
5763: FND_MSG_PUB.Add;
5764: end if;
5765: end if;
5766:

Line 5771: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

5767: if ((p_attribute_code is null) or
5768: (p_attribute_code = FND_API.G_MISS_CHAR)) then
5769: l_error := TRUE;
5770: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5771: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5772: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
5773: FND_MSG_PUB.Add;
5774: end if;
5775: end if;

Line 5772: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');

5768: (p_attribute_code = FND_API.G_MISS_CHAR)) then
5769: l_error := TRUE;
5770: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5771: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5772: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
5773: FND_MSG_PUB.Add;
5774: end if;
5775: end if;
5776:

Line 5784: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');

5780: fetch l_check_region_item_csr into l_item_style;
5781: if (l_check_region_item_csr%notfound) then
5782: l_error := TRUE;
5783: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5784: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
5785: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5786: ' ' || p_region_code ||' '||
5787: to_char(p_attribute_application_id)||' '||p_attribute_code);
5788: FND_MSG_PUB.Add;

Line 5785: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

5781: if (l_check_region_item_csr%notfound) then
5782: l_error := TRUE;
5783: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5784: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
5785: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5786: ' ' || p_region_code ||' '||
5787: to_char(p_attribute_application_id)||' '||p_attribute_code);
5788: FND_MSG_PUB.Add;
5789: end if;

Line 5795: FND_MESSAGE.SET_NAME('AK','AK_INVALID_ITEM_STYLE');

5791: if ( l_item_style <> 'ATTACHMENT_LINK' AND l_item_style <> 'ATTACHMENT_IMAGE' AND
5792: l_item_style <> 'ATTACHMENT_TABLE') then
5793: l_error := TRUE;
5794: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5795: FND_MESSAGE.SET_NAME('AK','AK_INVALID_ITEM_STYLE');
5796: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5797: ' ' || p_region_code ||' '||
5798: to_char(p_attribute_application_id)||' '||p_attribute_code||' '||l_item_style);
5799: FND_MSG_PUB.Add;

Line 5796: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

5792: l_item_style <> 'ATTACHMENT_TABLE') then
5793: l_error := TRUE;
5794: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5795: FND_MESSAGE.SET_NAME('AK','AK_INVALID_ITEM_STYLE');
5796: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5797: ' ' || p_region_code ||' '||
5798: to_char(p_attribute_application_id)||' '||p_attribute_code||' '||l_item_style);
5799: FND_MSG_PUB.Add;
5800: end if;

Line 5811: FND_MESSAGE.SET_NAME('AK','AK_INVALID_CATEGORY_REFERENCE');

5807: fetch l_check_category_csr into l_dummy;
5808: if (l_check_category_csr%notfound) then
5809: l_error := TRUE;
5810: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5811: FND_MESSAGE.SET_NAME('AK','AK_INVALID_CATEGORY_REFERENCE');
5812: FND_MESSAGE.SET_TOKEN('KEY', p_category_name);
5813: FND_MSG_PUB.Add;
5814: end if;
5815: end if;

Line 5812: FND_MESSAGE.SET_TOKEN('KEY', p_category_name);

5808: if (l_check_category_csr%notfound) then
5809: l_error := TRUE;
5810: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5811: FND_MESSAGE.SET_NAME('AK','AK_INVALID_CATEGORY_REFERENCE');
5812: FND_MESSAGE.SET_TOKEN('KEY', p_category_name);
5813: FND_MSG_PUB.Add;
5814: end if;
5815: end if;
5816: close l_check_category_csr;

Line 5920: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_EXISTS');

5916: p_attribute_application_id => p_attribute_application_id,
5917: p_attribute_code => p_attribute_code,
5918: p_category_name => p_category_name) then
5919: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5920: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_EXISTS');
5921: FND_MSG_PUB.Add;
5922: end if;
5923: raise FND_API.G_EXC_ERROR;
5924: end if;

Line 6028: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_CREATED');

6024: -- /** commit the insert **/
6025: -- commit;
6026:
6027: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
6028: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_CREATED');
6029: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||
6030: p_region_code||' '||to_char(p_attribute_application_id)||
6031: ' '||p_attribute_code||' '||
6032: p_category_name);

Line 6029: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||

6025: -- commit;
6026:
6027: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
6028: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_CREATED');
6029: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||
6030: p_region_code||' '||to_char(p_attribute_application_id)||
6031: ' '||p_attribute_code||' '||
6032: p_category_name);
6033: FND_MSG_PUB.Add;

Line 6047: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_VALUE_ERROR');

6043:
6044: EXCEPTION
6045: WHEN VALUE_ERROR THEN
6046: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6047: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_VALUE_ERROR');
6048: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6049: p_region_code||' '||to_char(p_attribute_application_id)||
6050: ' '||p_attribute_code||' '||
6051: p_category_name);

Line 6048: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||

6044: EXCEPTION
6045: WHEN VALUE_ERROR THEN
6046: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6047: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_VALUE_ERROR');
6048: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6049: p_region_code||' '||to_char(p_attribute_application_id)||
6050: ' '||p_attribute_code||' '||
6051: p_category_name);
6052: FND_MSG_PUB.Add;

Line 6061: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_NOT_CREATED');

6057: p_count => p_msg_count,
6058: p_data => p_msg_data);
6059: WHEN FND_API.G_EXC_ERROR THEN
6060: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6061: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_NOT_CREATED');
6062: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6063: p_region_code||' '||to_char(p_attribute_application_id)||
6064: ' '||p_attribute_code||' '||
6065: p_category_name);

Line 6062: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||

6058: p_data => p_msg_data);
6059: WHEN FND_API.G_EXC_ERROR THEN
6060: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6061: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_NOT_CREATED');
6062: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6063: p_region_code||' '||to_char(p_attribute_application_id)||
6064: ' '||p_attribute_code||' '||
6065: p_category_name);
6066: FND_MSG_PUB.Add;

Line 6170: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_DOES_NOT_EXIST');

6166: open l_get_row_csr;
6167: fetch l_get_row_csr into l_category_usage_rec;
6168: if (l_get_row_csr%notfound) then
6169: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6170: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_DOES_NOT_EXIST');
6171: FND_MESSAGE.SET_TOKEN('KEY', (to_char(p_region_application_id) ||' '||
6172: p_region_code ||' '|| to_char(p_attribute_application_id)||' '||
6173: p_attribute_code ||' '|| p_category_name ||' '||
6174: to_char(p_application_id)));

Line 6171: FND_MESSAGE.SET_TOKEN('KEY', (to_char(p_region_application_id) ||' '||

6167: fetch l_get_row_csr into l_category_usage_rec;
6168: if (l_get_row_csr%notfound) then
6169: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6170: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_DOES_NOT_EXIST');
6171: FND_MESSAGE.SET_TOKEN('KEY', (to_char(p_region_application_id) ||' '||
6172: p_region_code ||' '|| to_char(p_attribute_application_id)||' '||
6173: p_attribute_code ||' '|| p_category_name ||' '||
6174: to_char(p_application_id)));
6175: FND_MSG_PUB.Add;

Line 6255: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_UPDATE_FAILED');

6251: and ATTRIBUTE_CODE = p_attribute_code
6252: and CATEGORY_NAME = p_category_name;
6253: if (sql%notfound) then
6254: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6255: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_UPDATE_FAILED');
6256: FND_MSG_PUB.Add;
6257: end if;
6258: raise FND_API.G_EXC_ERROR;
6259: end if;

Line 6265: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_UPDATED');

6261: -- /** commit the update **/
6262: -- commit;
6263:
6264: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
6265: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_UPDATED');
6266: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6267: ' ' || p_region_code);
6268: FND_MSG_PUB.Add;
6269: end if;

Line 6266: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

6262: -- commit;
6263:
6264: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
6265: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_UPDATED');
6266: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6267: ' ' || p_region_code);
6268: FND_MSG_PUB.Add;
6269: end if;
6270:

Line 6284: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_VALUE_ERROR');

6280:
6281: EXCEPTION
6282: WHEN VALUE_ERROR THEN
6283: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6284: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_VALUE_ERROR');
6285: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6286: p_region_code||' '||to_char(p_attribute_application_id)||' '||
6287: p_attribute_code||' '|| p_category_name ||' '||
6288: to_char(p_application_id));

Line 6285: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||

6281: EXCEPTION
6282: WHEN VALUE_ERROR THEN
6283: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6284: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_VALUE_ERROR');
6285: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6286: p_region_code||' '||to_char(p_attribute_application_id)||' '||
6287: p_attribute_code||' '|| p_category_name ||' '||
6288: to_char(p_application_id));
6289: FND_MSG_PUB.Add;