DBA Data[Home] [Help]

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 4135: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4131: if ((p_region_application_id is null) or
4132: (p_region_application_id = FND_API.G_MISS_NUM)) then
4133: l_error := TRUE;
4134: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4135: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4136: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4137: FND_MSG_PUB.Add;
4138: end if;
4139: end if;

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

4132: (p_region_application_id = FND_API.G_MISS_NUM)) then
4133: l_error := TRUE;
4134: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4135: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4136: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4137: FND_MSG_PUB.Add;
4138: end if;
4139: end if;
4140:

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

4141: if ((p_region_code is null) or
4142: (p_region_code = FND_API.G_MISS_CHAR)) then
4143: l_error := TRUE;
4144: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4145: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4146: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4147: FND_MSG_PUB.Add;
4148: end if;
4149: end if;

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

4142: (p_region_code = FND_API.G_MISS_CHAR)) then
4143: l_error := TRUE;
4144: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4145: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4146: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4147: FND_MSG_PUB.Add;
4148: end if;
4149: end if;
4150:

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

4151: if ((p_attribute_application_id is null) or
4152: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
4153: l_error := TRUE;
4154: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4155: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4156: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4157: FND_MSG_PUB.Add;
4158: end if;
4159: end if;

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

4152: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
4153: l_error := TRUE;
4154: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4155: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4156: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4157: FND_MSG_PUB.Add;
4158: end if;
4159: end if;
4160:

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

4161: if ((p_attribute_code is null) or
4162: (p_attribute_code = FND_API.G_MISS_CHAR)) then
4163: l_error := TRUE;
4164: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4165: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4166: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4167: FND_MSG_PUB.Add;
4168: end if;
4169: end if;

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

4162: (p_attribute_code = FND_API.G_MISS_CHAR)) then
4163: l_error := TRUE;
4164: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4165: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4166: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4167: FND_MSG_PUB.Add;
4168: end if;
4169: end if;
4170:

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

4171: if ((p_graph_number is null) or
4172: (p_graph_number = FND_API.G_MISS_NUM)) then
4173: l_error := TRUE;
4174: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4175: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4176: FND_MESSAGE.SET_TOKEN('COLUMN', 'GRAPH_NUMBER');
4177: FND_MSG_PUB.Add;
4178: end if;
4179: end if;

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

4172: (p_graph_number = FND_API.G_MISS_NUM)) then
4173: l_error := TRUE;
4174: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4175: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4176: FND_MESSAGE.SET_TOKEN('COLUMN', 'GRAPH_NUMBER');
4177: FND_MSG_PUB.Add;
4178: end if;
4179: end if;
4180:

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

4183: fetch l_check_region_item_csr into l_dummy;
4184: if (l_check_region_item_csr%notfound) then
4185: l_error := TRUE;
4186: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4187: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
4188: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4189: ' ' || p_region_code ||' '||
4190: to_char(p_attribute_application_id) || ' '||
4191: p_attribute_code);

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

4184: if (l_check_region_item_csr%notfound) then
4185: l_error := TRUE;
4186: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4187: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
4188: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4189: ' ' || p_region_code ||' '||
4190: to_char(p_attribute_application_id) || ' '||
4191: p_attribute_code);
4192: FND_MSG_PUB.Add;

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

4199: fetch l_check_Region_graph_csr into l_dummy;
4200: if (l_check_region_graph_csr%notfound) then
4201: l_error := TRUE;
4202: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4203: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_GRAPH_REFERENCE');
4204: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4205: ' ' || p_region_code ||' '||
4206: p_graph_number);
4207: FND_MSG_PUB.Add;

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

4200: if (l_check_region_graph_csr%notfound) then
4201: l_error := TRUE;
4202: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4203: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_GRAPH_REFERENCE');
4204: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4205: ' ' || p_region_code ||' '||
4206: p_graph_number);
4207: FND_MSG_PUB.Add;
4208: end if;

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

4318: if ((p_region_application_id is null) or
4319: (p_region_application_id = FND_API.G_MISS_NUM)) then
4320: l_error := TRUE;
4321: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4322: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4323: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4324: FND_MSG_PUB.Add;
4325: end if;
4326: end if;

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

4319: (p_region_application_id = FND_API.G_MISS_NUM)) then
4320: l_error := TRUE;
4321: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4322: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4323: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4324: FND_MSG_PUB.Add;
4325: end if;
4326: end if;
4327:

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

4328: if ((p_region_code is null) or
4329: (p_region_code = FND_API.G_MISS_CHAR)) then
4330: l_error := TRUE;
4331: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4332: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4333: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4334: FND_MSG_PUB.Add;
4335: end if;
4336: end if;

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

4329: (p_region_code = FND_API.G_MISS_CHAR)) then
4330: l_error := TRUE;
4331: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4332: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4333: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4334: FND_MSG_PUB.Add;
4335: end if;
4336: end if;
4337:

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

4338: if ((p_attribute_application_id is null) or
4339: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
4340: l_error := TRUE;
4341: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4342: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4343: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4344: FND_MSG_PUB.Add;
4345: end if;
4346: end if;

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

4339: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
4340: l_error := TRUE;
4341: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4342: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4343: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4344: FND_MSG_PUB.Add;
4345: end if;
4346: end if;
4347:

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

4348: if ((p_attribute_code is null) or
4349: (p_attribute_code = FND_API.G_MISS_CHAR)) then
4350: l_error := TRUE;
4351: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4352: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4353: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4354: FND_MSG_PUB.Add;
4355: end if;
4356: end if;

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

4349: (p_attribute_code = FND_API.G_MISS_CHAR)) then
4350: l_error := TRUE;
4351: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4352: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4353: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4354: FND_MSG_PUB.Add;
4355: end if;
4356: end if;
4357:

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

4358: if ((p_lov_region_appl_id is null) or
4359: (p_lov_region_appl_id = FND_API.G_MISS_NUM)) then
4360: l_error := TRUE;
4361: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4362: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4363: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4364: FND_MSG_PUB.Add;
4365: end if;
4366: end if;

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

4359: (p_lov_region_appl_id = FND_API.G_MISS_NUM)) then
4360: l_error := TRUE;
4361: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4362: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4363: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4364: FND_MSG_PUB.Add;
4365: end if;
4366: end if;
4367:

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

4368: if ((p_lov_region_code is null) or
4369: (p_lov_region_code = FND_API.G_MISS_CHAR)) then
4370: l_error := TRUE;
4371: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4372: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4373: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4374: FND_MSG_PUB.Add;
4375: end if;
4376: end if;

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

4369: (p_lov_region_code = FND_API.G_MISS_CHAR)) then
4370: l_error := TRUE;
4371: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4372: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4373: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4374: FND_MSG_PUB.Add;
4375: end if;
4376: end if;
4377:

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

4378: if ((p_lov_attribute_appl_id is null) or
4379: (p_lov_attribute_appl_id = FND_API.G_MISS_NUM)) then
4380: l_error := TRUE;
4381: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4382: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4383: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4384: FND_MSG_PUB.Add;
4385: end if;
4386: end if;

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

4379: (p_lov_attribute_appl_id = FND_API.G_MISS_NUM)) then
4380: l_error := TRUE;
4381: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4382: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4383: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4384: FND_MSG_PUB.Add;
4385: end if;
4386: end if;
4387:

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

4388: if ((p_lov_attribute_code is null) or
4389: (p_lov_attribute_code = FND_API.G_MISS_CHAR)) then
4390: l_error := TRUE;
4391: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4392: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4393: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4394: FND_MSG_PUB.Add;
4395: end if;
4396: end if;

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

4389: (p_lov_attribute_code = FND_API.G_MISS_CHAR)) then
4390: l_error := TRUE;
4391: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4392: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4393: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4394: FND_MSG_PUB.Add;
4395: end if;
4396: end if;
4397:

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

4402: (p_base_region_appl_id = FND_API.G_MISS_NUM)) then
4403:
4404: l_error := TRUE;
4405: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4406: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4407: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_REGION_APPL_ID');
4408: FND_MSG_PUB.Add;
4409: end if;
4410: end if;

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

4403:
4404: l_error := TRUE;
4405: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4406: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4407: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_REGION_APPL_ID');
4408: FND_MSG_PUB.Add;
4409: end if;
4410: end if;
4411: **/

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

4416: if ((p_base_region_code is null) or
4417: (p_base_region_code = FND_API.G_MISS_CHAR)) then
4418: l_error := TRUE;
4419: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4420: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4421: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_REGION_CODE');
4422: FND_MSG_PUB.Add;
4423: end if;
4424: end if;

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

4417: (p_base_region_code = FND_API.G_MISS_CHAR)) then
4418: l_error := TRUE;
4419: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4420: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4421: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_REGION_CODE');
4422: FND_MSG_PUB.Add;
4423: end if;
4424: end if;
4425: **/

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

4429: if ((p_base_attribute_appl_id is null) or
4430: (p_base_attribute_appl_id = FND_API.G_MISS_NUM)) then
4431: l_error := TRUE;
4432: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4433: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4434: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_ATTRIBUTE_APPL_ID');
4435: FND_MSG_PUB.Add;
4436: end if;
4437: end if;

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

4430: (p_base_attribute_appl_id = FND_API.G_MISS_NUM)) then
4431: l_error := TRUE;
4432: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4433: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4434: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_ATTRIBUTE_APPL_ID');
4435: FND_MSG_PUB.Add;
4436: end if;
4437: end if;
4438:

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

4439: if ((p_base_attribute_code is null) or
4440: (p_base_attribute_code = FND_API.G_MISS_CHAR)) then
4441: l_error := TRUE;
4442: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4443: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4444: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_ATTRIBUTE_CODE');
4445: FND_MSG_PUB.Add;
4446: end if;
4447: end if;

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

4440: (p_base_attribute_code = FND_API.G_MISS_CHAR)) then
4441: l_error := TRUE;
4442: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4443: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4444: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_ATTRIBUTE_CODE');
4445: FND_MSG_PUB.Add;
4446: end if;
4447: end if;
4448:

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

4452: fetch l_check_region_item_csr into l_dummy;
4453: if (l_check_region_item_csr%notfound) then
4454: l_error := TRUE;
4455: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4456: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
4457: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4458: ' ' || p_region_code ||' '||
4459: to_char(p_attribute_application_id)||' '||p_attribute_code);
4460: FND_MSG_PUB.Add;

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

4453: if (l_check_region_item_csr%notfound) then
4454: l_error := TRUE;
4455: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4456: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
4457: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4458: ' ' || p_region_code ||' '||
4459: to_char(p_attribute_application_id)||' '||p_attribute_code);
4460: FND_MSG_PUB.Add;
4461: end if;

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

4467: fetch l_check_region_csr into l_dummy;
4468: if (l_check_region_csr%notfound) then
4469: l_error := TRUE;
4470: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4471: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_REG_REFERENCE');
4472: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4473: ' ' || p_lov_region_code );
4474: FND_MSG_PUB.Add;
4475: end if;

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

4468: if (l_check_region_csr%notfound) then
4469: l_error := TRUE;
4470: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4471: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_REG_REFERENCE');
4472: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4473: ' ' || p_lov_region_code );
4474: FND_MSG_PUB.Add;
4475: end if;
4476: end if;

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

4482: fetch l_check_region_item_csr into l_dummy;
4483: if (l_check_region_item_csr%notfound) then
4484: l_error := TRUE;
4485: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4486: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_ITEM_REFERENCE');
4487: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4488: ' ' || p_lov_region_code ||' '||
4489: to_char(p_lov_attribute_appl_id)||' '||p_lov_attribute_code);
4490: FND_MSG_PUB.Add;

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

4483: if (l_check_region_item_csr%notfound) then
4484: l_error := TRUE;
4485: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4486: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_ITEM_REFERENCE');
4487: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4488: ' ' || p_lov_region_code ||' '||
4489: to_char(p_lov_attribute_appl_id)||' '||p_lov_attribute_code);
4490: FND_MSG_PUB.Add;
4491: end if;

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

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

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

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

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

4517: p_lookup_type => 'LOV_DIRECTION',
4518: p_lookup_code => p_direction_flag)) then
4519: l_error := TRUE;
4520: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4521: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
4522: FND_MESSAGE.SET_TOKEN('COLUMN','DIRECTION_FLAG');
4523: FND_MSG_PUB.Add;
4524: end if;
4525: end if;

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

4518: p_lookup_code => p_direction_flag)) then
4519: l_error := TRUE;
4520: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4521: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
4522: FND_MESSAGE.SET_TOKEN('COLUMN','DIRECTION_FLAG');
4523: FND_MSG_PUB.Add;
4524: end if;
4525: end if;
4526: else

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

4525: end if;
4526: else
4527: l_error := TRUE;
4528: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4529: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4530: FND_MESSAGE.SET_TOKEN('COLUMN', 'DIRECTION_FLAG');
4531: FND_MSG_PUB.Add;
4532: end if;
4533: end if;

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

4526: else
4527: l_error := TRUE;
4528: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4529: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4530: FND_MESSAGE.SET_TOKEN('COLUMN', 'DIRECTION_FLAG');
4531: FND_MSG_PUB.Add;
4532: end if;
4533: end if;
4534:

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

4631: p_attribute_application_id => p_attribute_application_id,
4632: p_attribute_code => p_attribute_code,
4633: p_graph_number => p_graph_number) then
4634: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4635: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_EXISTS');
4636: FND_MSG_PUB.Add;
4637: end if;
4638: raise FND_API.G_EXC_ERROR;
4639: end if;

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

4707: -- ** commit the insert **
4708: -- commit;
4709:
4710: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4711: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_CREATED');
4712: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||
4713: p_region_code||' '||
4714: to_char(p_attribute_application_id)||
4715: ' '||p_attribute_code||' '||

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

4708: -- commit;
4709:
4710: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4711: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_CREATED');
4712: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||
4713: p_region_code||' '||
4714: to_char(p_attribute_application_id)||
4715: ' '||p_attribute_code||' '||
4716: to_char(p_graph_number));

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

4725:
4726: EXCEPTION
4727: WHEN VALUE_ERROR THEN
4728: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4729: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_VALUE_ERROR');
4730: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
4731: p_region_code||' '||
4732: to_char(p_attribute_application_id)||
4733: ' '||p_attribute_code||' '||

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

4726: EXCEPTION
4727: WHEN VALUE_ERROR THEN
4728: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4729: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_VALUE_ERROR');
4730: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
4731: p_region_code||' '||
4732: to_char(p_attribute_application_id)||
4733: ' '||p_attribute_code||' '||
4734: to_char(p_graph_number));

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

4852: p_direction_flag => p_direction_flag,
4853: p_base_region_appl_id => p_base_region_appl_id,
4854: p_base_region_code => p_base_region_code) then
4855: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4856: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_EXISTS');
4857: FND_MSG_PUB.Add;
4858: end if;
4859: raise FND_API.G_EXC_ERROR;
4860: end if;

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

4980: -- /** commit the insert **/
4981: -- commit;
4982:
4983: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4984: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_CREATED');
4985: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||
4986: p_region_code||' '||to_char(p_attribute_application_id)||
4987: ' '||p_attribute_code||' '||
4988: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||

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

4981: -- commit;
4982:
4983: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4984: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_CREATED');
4985: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||
4986: p_region_code||' '||to_char(p_attribute_application_id)||
4987: ' '||p_attribute_code||' '||
4988: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||
4989: ' '||to_char(p_lov_attribute_appl_id)||' '||

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

5000:
5001: EXCEPTION
5002: WHEN VALUE_ERROR THEN
5003: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5004: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
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: EXCEPTION
5002: WHEN VALUE_ERROR THEN
5003: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5004: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
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 5021: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_CREATED');

5017: p_count => p_msg_count,
5018: p_data => p_msg_data);
5019: WHEN FND_API.G_EXC_ERROR THEN
5020: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5021: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_CREATED');
5022: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5023: p_region_code||' '||to_char(p_attribute_application_id)||
5024: ' '||p_attribute_code||' '||
5025: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||

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

5018: p_data => p_msg_data);
5019: WHEN FND_API.G_EXC_ERROR THEN
5020: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5021: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_CREATED');
5022: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5023: p_region_code||' '||to_char(p_attribute_application_id)||
5024: ' '||p_attribute_code||' '||
5025: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||
5026: ' '||to_char(p_lov_attribute_appl_id)||' '||

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

5128: open l_get_row_csr;
5129: fetch l_get_row_csr into l_graph_column_rec;
5130: if (l_get_row_csr%notfound) then
5131: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5132: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_DOES_NOT_EXIST');
5133: FND_MSG_PUB.Add;
5134: end if;
5135: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
5136: close l_get_row_csr;

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

5195: and ATTRIBUTE_CODE = p_attribute_code
5196: and GRAPH_NUMBER = p_graph_number;
5197: if (sql%notfound) then
5198: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5199: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_UPDATE_FAILED');
5200: FND_MSG_PUB.Add;
5201: end if;
5202: raise FND_API.G_EXC_ERROR;
5203: end if;

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

5205: -- ** commit the update **
5206: -- commit;
5207:
5208: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5209: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_UPDATED');
5210: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5211: ' ' || p_region_code);
5212: FND_MSG_PUB.Add;
5213: end if;

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

5206: -- commit;
5207:
5208: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5209: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_UPDATED');
5210: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5211: ' ' || p_region_code);
5212: FND_MSG_PUB.Add;
5213: end if;
5214:

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

5220:
5221: EXCEPTION
5222: WHEN VALUE_ERROR THEN
5223: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5224: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_VALUE_ERROR');
5225: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5226: p_region_code||' '||
5227: to_char(p_attribute_application_id)||
5228: ' '||p_attribute_code||' '||

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

5221: EXCEPTION
5222: WHEN VALUE_ERROR THEN
5223: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5224: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_VALUE_ERROR');
5225: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5226: p_region_code||' '||
5227: to_char(p_attribute_application_id)||
5228: ' '||p_attribute_code||' '||
5229: to_char(p_graph_number));

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

5235: p_count => p_msg_count,
5236: p_data => p_msg_data);
5237: WHEN FND_API.G_EXC_ERROR THEN
5238: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5239: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_NOT_UPDATED');
5240: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5241: p_region_code||' '||
5242: to_char(p_attribute_application_id)||
5243: ' '||p_attribute_code||' '||

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

5236: p_data => p_msg_data);
5237: WHEN FND_API.G_EXC_ERROR THEN
5238: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5239: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_NOT_UPDATED');
5240: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5241: p_region_code||' '||
5242: to_char(p_attribute_application_id)||
5243: ' '||p_attribute_code||' '||
5244: to_char(p_graph_number));

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

5365: open l_get_row_csr;
5366: fetch l_get_row_csr into l_lov_relation_rec;
5367: if (l_get_row_csr%notfound) then
5368: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5369: FND_MESSAGE.SET_NAME('AK','AK_LOV_REGION_DOES_NOT_EXIST');
5370: FND_MSG_PUB.Add;
5371: end if;
5372: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
5373: close l_get_row_csr;

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

5471: and BASE_REGION_APPL_ID = p_base_region_appl_id
5472: and BASE_REGION_CODE = p_base_region_code;
5473: if (sql%notfound) then
5474: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5475: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_UPDATE_FAILED');
5476: FND_MSG_PUB.Add;
5477: end if;
5478: raise FND_API.G_EXC_ERROR;
5479: end if;

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

5481: -- /** commit the update **/
5482: -- commit;
5483:
5484: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5485: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_UPDATED');
5486: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5487: ' ' || p_region_code);
5488: FND_MSG_PUB.Add;
5489: end if;

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

5482: -- commit;
5483:
5484: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5485: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_UPDATED');
5486: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5487: ' ' || p_region_code);
5488: FND_MSG_PUB.Add;
5489: end if;
5490:

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

5497:
5498: EXCEPTION
5499: WHEN VALUE_ERROR THEN
5500: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5501: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_VALUE_ERROR');
5502: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5503: p_region_code||' '||to_char(p_attribute_application_id)||
5504: ' '||p_attribute_code||' '||
5505: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||

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

5498: EXCEPTION
5499: WHEN VALUE_ERROR THEN
5500: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5501: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_VALUE_ERROR');
5502: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5503: p_region_code||' '||to_char(p_attribute_application_id)||
5504: ' '||p_attribute_code||' '||
5505: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||
5506: ' '||to_char(p_lov_attribute_appl_id)||' '||

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

5515: p_count => p_msg_count,
5516: p_data => p_msg_data);
5517: WHEN FND_API.G_EXC_ERROR THEN
5518: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5519: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_NOT_UPDATED');
5520: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5521: p_region_code||' '||to_char(p_attribute_application_id)||
5522: ' '||p_attribute_code||' '||
5523: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||

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

5516: p_data => p_msg_data);
5517: WHEN FND_API.G_EXC_ERROR THEN
5518: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5519: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_NOT_UPDATED');
5520: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5521: p_region_code||' '||to_char(p_attribute_application_id)||
5522: ' '||p_attribute_code||' '||
5523: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||
5524: ' '||to_char(p_lov_attribute_appl_id)||' '||

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

5709: if ((p_region_application_id is null) or
5710: (p_region_application_id = FND_API.G_MISS_NUM)) then
5711: l_error := TRUE;
5712: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5713: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5714: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
5715: FND_MSG_PUB.Add;
5716: end if;
5717: end if;

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

5710: (p_region_application_id = FND_API.G_MISS_NUM)) then
5711: l_error := TRUE;
5712: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5713: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5714: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
5715: FND_MSG_PUB.Add;
5716: end if;
5717: end if;
5718:

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

5719: if ((p_region_code is null) or
5720: (p_region_code = FND_API.G_MISS_CHAR)) then
5721: l_error := TRUE;
5722: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5723: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5724: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
5725: FND_MSG_PUB.Add;
5726: end if;
5727: end if;

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

5720: (p_region_code = FND_API.G_MISS_CHAR)) then
5721: l_error := TRUE;
5722: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5723: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5724: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
5725: FND_MSG_PUB.Add;
5726: end if;
5727: end if;
5728:

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

5729: if ((p_attribute_application_id is null) or
5730: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
5731: l_error := TRUE;
5732: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5733: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5734: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
5735: FND_MSG_PUB.Add;
5736: end if;
5737: end if;

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

5730: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
5731: l_error := TRUE;
5732: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5733: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5734: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
5735: FND_MSG_PUB.Add;
5736: end if;
5737: end if;
5738:

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

5739: if ((p_attribute_code is null) or
5740: (p_attribute_code = FND_API.G_MISS_CHAR)) then
5741: l_error := TRUE;
5742: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5743: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5744: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
5745: FND_MSG_PUB.Add;
5746: end if;
5747: end if;

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

5740: (p_attribute_code = FND_API.G_MISS_CHAR)) then
5741: l_error := TRUE;
5742: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5743: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5744: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
5745: FND_MSG_PUB.Add;
5746: end if;
5747: end if;
5748:

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

5752: fetch l_check_region_item_csr into l_item_style;
5753: if (l_check_region_item_csr%notfound) then
5754: l_error := TRUE;
5755: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5756: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
5757: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5758: ' ' || p_region_code ||' '||
5759: to_char(p_attribute_application_id)||' '||p_attribute_code);
5760: FND_MSG_PUB.Add;

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

5753: if (l_check_region_item_csr%notfound) then
5754: l_error := TRUE;
5755: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5756: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
5757: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5758: ' ' || p_region_code ||' '||
5759: to_char(p_attribute_application_id)||' '||p_attribute_code);
5760: FND_MSG_PUB.Add;
5761: end if;

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

5763: if ( l_item_style <> 'ATTACHMENT_LINK' AND l_item_style <> 'ATTACHMENT_IMAGE' AND
5764: l_item_style <> 'ATTACHMENT_TABLE') then
5765: l_error := TRUE;
5766: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5767: FND_MESSAGE.SET_NAME('AK','AK_INVALID_ITEM_STYLE');
5768: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5769: ' ' || p_region_code ||' '||
5770: to_char(p_attribute_application_id)||' '||p_attribute_code||' '||l_item_style);
5771: FND_MSG_PUB.Add;

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

5764: l_item_style <> 'ATTACHMENT_TABLE') then
5765: l_error := TRUE;
5766: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5767: FND_MESSAGE.SET_NAME('AK','AK_INVALID_ITEM_STYLE');
5768: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5769: ' ' || p_region_code ||' '||
5770: to_char(p_attribute_application_id)||' '||p_attribute_code||' '||l_item_style);
5771: FND_MSG_PUB.Add;
5772: end if;

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

5779: fetch l_check_category_csr into l_dummy;
5780: if (l_check_category_csr%notfound) then
5781: l_error := TRUE;
5782: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5783: FND_MESSAGE.SET_NAME('AK','AK_INVALID_CATEGORY_REFERENCE');
5784: FND_MESSAGE.SET_TOKEN('KEY', p_category_name);
5785: FND_MSG_PUB.Add;
5786: end if;
5787: end if;

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

5780: if (l_check_category_csr%notfound) then
5781: l_error := TRUE;
5782: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5783: FND_MESSAGE.SET_NAME('AK','AK_INVALID_CATEGORY_REFERENCE');
5784: FND_MESSAGE.SET_TOKEN('KEY', p_category_name);
5785: FND_MSG_PUB.Add;
5786: end if;
5787: end if;
5788: close l_check_category_csr;

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

5888: p_attribute_application_id => p_attribute_application_id,
5889: p_attribute_code => p_attribute_code,
5890: p_category_name => p_category_name) then
5891: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5892: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_EXISTS');
5893: FND_MSG_PUB.Add;
5894: end if;
5895: raise FND_API.G_EXC_ERROR;
5896: end if;

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

5993: -- /** commit the insert **/
5994: -- commit;
5995:
5996: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5997: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_CREATED');
5998: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||
5999: p_region_code||' '||to_char(p_attribute_application_id)||
6000: ' '||p_attribute_code||' '||
6001: p_category_name);

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

5994: -- commit;
5995:
5996: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5997: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_CREATED');
5998: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||
5999: p_region_code||' '||to_char(p_attribute_application_id)||
6000: ' '||p_attribute_code||' '||
6001: p_category_name);
6002: FND_MSG_PUB.Add;

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

6010:
6011: EXCEPTION
6012: WHEN VALUE_ERROR THEN
6013: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6014: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_VALUE_ERROR');
6015: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6016: p_region_code||' '||to_char(p_attribute_application_id)||
6017: ' '||p_attribute_code||' '||
6018: p_category_name);

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

6011: EXCEPTION
6012: WHEN VALUE_ERROR THEN
6013: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6014: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_VALUE_ERROR');
6015: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6016: p_region_code||' '||to_char(p_attribute_application_id)||
6017: ' '||p_attribute_code||' '||
6018: p_category_name);
6019: FND_MSG_PUB.Add;

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

6024: p_count => p_msg_count,
6025: p_data => p_msg_data);
6026: WHEN FND_API.G_EXC_ERROR THEN
6027: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6028: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_NOT_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: p_data => p_msg_data);
6026: WHEN FND_API.G_EXC_ERROR THEN
6027: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6028: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_NOT_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 6137: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_DOES_NOT_EXIST');

6133: open l_get_row_csr;
6134: fetch l_get_row_csr into l_category_usage_rec;
6135: if (l_get_row_csr%notfound) then
6136: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6137: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_DOES_NOT_EXIST');
6138: FND_MESSAGE.SET_TOKEN('KEY', (to_char(p_region_application_id) ||' '||
6139: p_region_code ||' '|| to_char(p_attribute_application_id)||' '||
6140: p_attribute_code ||' '|| p_category_name ||' '||
6141: to_char(p_application_id)));

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

6134: fetch l_get_row_csr into l_category_usage_rec;
6135: if (l_get_row_csr%notfound) then
6136: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6137: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_DOES_NOT_EXIST');
6138: FND_MESSAGE.SET_TOKEN('KEY', (to_char(p_region_application_id) ||' '||
6139: p_region_code ||' '|| to_char(p_attribute_application_id)||' '||
6140: p_attribute_code ||' '|| p_category_name ||' '||
6141: to_char(p_application_id)));
6142: FND_MSG_PUB.Add;

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

6215: and ATTRIBUTE_CODE = p_attribute_code
6216: and CATEGORY_NAME = p_category_name;
6217: if (sql%notfound) then
6218: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6219: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_UPDATE_FAILED');
6220: FND_MSG_PUB.Add;
6221: end if;
6222: raise FND_API.G_EXC_ERROR;
6223: end if;

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

6225: -- /** commit the update **/
6226: -- commit;
6227:
6228: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
6229: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_UPDATED');
6230: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6231: ' ' || p_region_code);
6232: FND_MSG_PUB.Add;
6233: end if;

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

6226: -- commit;
6227:
6228: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
6229: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_UPDATED');
6230: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6231: ' ' || p_region_code);
6232: FND_MSG_PUB.Add;
6233: end if;
6234:

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

6242:
6243: EXCEPTION
6244: WHEN VALUE_ERROR THEN
6245: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6246: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_VALUE_ERROR');
6247: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6248: p_region_code||' '||to_char(p_attribute_application_id)||' '||
6249: p_attribute_code||' '|| p_category_name ||' '||
6250: to_char(p_application_id));

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

6243: EXCEPTION
6244: WHEN VALUE_ERROR THEN
6245: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6246: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_VALUE_ERROR');
6247: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6248: p_region_code||' '||to_char(p_attribute_application_id)||' '||
6249: p_attribute_code||' '|| p_category_name ||' '||
6250: to_char(p_application_id));
6251: FND_MSG_PUB.Add;