eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_OBJECT_PVT dependencies on FND_MESSAGE

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

320: if ((p_database_object_name is null) or
321: (p_database_object_name = FND_API.G_MISS_CHAR)) then
322: l_error := TRUE;
323: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
324: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
325: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
326: FND_MSG_PUB.Add;
327: end if;
328: end if;

Line 325: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');

321: (p_database_object_name = FND_API.G_MISS_CHAR)) then
322: l_error := TRUE;
323: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
324: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
325: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
326: FND_MSG_PUB.Add;
327: end if;
328: end if;
329:

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

331: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
332: l_error := TRUE;
333: -- dbms_output.put_line('Attribute Application ID cannot be null');
334: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
335: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
336: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
337: FND_MSG_PUB.Add;
338: end if;
339: end if;

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

332: l_error := TRUE;
333: -- dbms_output.put_line('Attribute Application ID cannot be null');
334: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
335: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
336: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
337: FND_MSG_PUB.Add;
338: end if;
339: end if;
340:

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

342: (p_attribute_code = FND_API.G_MISS_CHAR)) then
343: l_error := TRUE;
344: -- dbms_output.put_line('Attribute Code cannot be null');
345: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
346: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
347: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
348: FND_MSG_PUB.Add;
349: end if;
350: end if;

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

343: l_error := TRUE;
344: -- dbms_output.put_line('Attribute Code cannot be null');
345: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
346: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
347: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
348: FND_MSG_PUB.Add;
349: end if;
350: end if;
351:

Line 364: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OBJECT_REFERENCE');

360: p_return_status => l_return_status,
361: p_database_object_name => p_database_object_name)) then
362: l_error := TRUE;
363: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
364: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OBJECT_REFERENCE');
365: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
366: FND_MSG_PUB.Add;
367: end if;
368: -- dbms_output.put_line('Parent object does not exist!');

Line 365: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);

361: p_database_object_name => p_database_object_name)) then
362: l_error := TRUE;
363: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
364: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OBJECT_REFERENCE');
365: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
366: FND_MSG_PUB.Add;
367: end if;
368: -- dbms_output.put_line('Parent object does not exist!');
369: end if;

Line 380: FND_MESSAGE.SET_NAME('AK','AK_INVALID_ATTR_REFERENCE');

376: p_attribute_application_id => p_attribute_application_id,
377: p_attribute_code => p_attribute_code) ) then
378: l_error := TRUE;
379: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
380: FND_MESSAGE.SET_NAME('AK','AK_INVALID_ATTR_REFERENCE');
381: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_attribute_application_id) ||
382: ' ' || p_attribute_code);
383: FND_MSG_PUB.Add;
384: end if;

Line 381: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_attribute_application_id) ||

377: p_attribute_code => p_attribute_code) ) then
378: l_error := TRUE;
379: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
380: FND_MESSAGE.SET_NAME('AK','AK_INVALID_ATTR_REFERENCE');
381: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_attribute_application_id) ||
382: ' ' || p_attribute_code);
383: FND_MSG_PUB.Add;
384: end if;
385: -- dbms_output.put_line('Attribute referenced does not exist!');

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

393: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
394: then
395: l_error := TRUE;
396: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
397: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
398: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATA_SOURCE_TYPE');
399: FND_MSG_PUB.Add;
400: end if;
401: end if;

Line 398: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATA_SOURCE_TYPE');

394: then
395: l_error := TRUE;
396: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
397: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
398: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATA_SOURCE_TYPE');
399: FND_MSG_PUB.Add;
400: end if;
401: end if;
402:

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

405: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
406: then
407: l_error := TRUE;
408: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
409: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
410: FND_MESSAGE.SET_TOKEN('COLUMN', 'REQUIRED_FLAG');
411: FND_MSG_PUB.Add;
412: end if;
413: end if;

Line 410: FND_MESSAGE.SET_TOKEN('COLUMN', 'REQUIRED_FLAG');

406: then
407: l_error := TRUE;
408: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
409: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
410: FND_MESSAGE.SET_TOKEN('COLUMN', 'REQUIRED_FLAG');
411: FND_MSG_PUB.Add;
412: end if;
413: end if;
414:

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

417: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
418: then
419: l_error := TRUE;
420: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
421: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
422: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_LABEL_LENGTH');
423: FND_MSG_PUB.Add;
424: end if;
425: end if;

Line 422: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_LABEL_LENGTH');

418: then
419: l_error := TRUE;
420: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
421: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
422: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_LABEL_LENGTH');
423: FND_MSG_PUB.Add;
424: end if;
425: end if;
426:

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

429: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
430: then
431: l_error := TRUE;
432: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
433: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
434: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPLAY_VALUE_LENGTH');
435: FND_MSG_PUB.Add;
436: end if;
437: end if;

Line 434: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPLAY_VALUE_LENGTH');

430: then
431: l_error := TRUE;
432: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
433: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
434: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPLAY_VALUE_LENGTH');
435: FND_MSG_PUB.Add;
436: end if;
437: end if;
438:

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

440: (p_bold = FND_API.G_MISS_CHAR and
441: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
442: l_error := TRUE;
443: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
444: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
445: FND_MESSAGE.SET_TOKEN('COLUMN', 'BOLD');
446: FND_MSG_PUB.Add;
447: end if;
448: end if;

Line 445: FND_MESSAGE.SET_TOKEN('COLUMN', 'BOLD');

441: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
442: l_error := TRUE;
443: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
444: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
445: FND_MESSAGE.SET_TOKEN('COLUMN', 'BOLD');
446: FND_MSG_PUB.Add;
447: end if;
448: end if;
449:

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

451: (p_italic = FND_API.G_MISS_CHAR and
452: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
453: l_error := TRUE;
454: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
455: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
456: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITALIC');
457: FND_MSG_PUB.Add;
458: end if;
459: end if;

Line 456: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITALIC');

452: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
453: l_error := TRUE;
454: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
455: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
456: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITALIC');
457: FND_MSG_PUB.Add;
458: end if;
459: end if;
460:

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

463: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
464: then
465: l_error := TRUE;
466: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
467: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
468: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERTICAL_ALIGNMENT');
469: FND_MSG_PUB.Add;
470: end if;
471: end if;

Line 468: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERTICAL_ALIGNMENT');

464: then
465: l_error := TRUE;
466: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
467: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
468: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERTICAL_ALIGNMENT');
469: FND_MSG_PUB.Add;
470: end if;
471: end if;
472:

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

475: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
476: then
477: l_error := TRUE;
478: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
479: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
480: FND_MESSAGE.SET_TOKEN('COLUMN', 'HORIZONTAL_ALIGNMENT');
481: FND_MSG_PUB.Add;
482: end if;
483: end if;

Line 480: FND_MESSAGE.SET_TOKEN('COLUMN', 'HORIZONTAL_ALIGNMENT');

476: then
477: l_error := TRUE;
478: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
479: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
480: FND_MESSAGE.SET_TOKEN('COLUMN', 'HORIZONTAL_ALIGNMENT');
481: FND_MSG_PUB.Add;
482: end if;
483: end if;
484:

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

492: p_lookup_type => 'DATA_SOURCE_TYPE',
493: p_lookup_code => p_data_source_type)) then
494: l_error := TRUE;
495: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
496: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
497: FND_MESSAGE.SET_TOKEN('COLUMN','DATA_SOURCE_TYPE');
498: FND_MSG_PUB.Add;
499: end if;
500: end if;

Line 497: FND_MESSAGE.SET_TOKEN('COLUMN','DATA_SOURCE_TYPE');

493: p_lookup_code => p_data_source_type)) then
494: l_error := TRUE;
495: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
496: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
497: FND_MESSAGE.SET_TOKEN('COLUMN','DATA_SOURCE_TYPE');
498: FND_MSG_PUB.Add;
499: end if;
500: end if;
501: end if;

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

509: p_lookup_type => 'DATA_STORAGE_TYPE',
510: p_lookup_code => p_data_storage_type)) then
511: l_error := TRUE;
512: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
513: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
514: FND_MESSAGE.SET_TOKEN('COLUMN','DATA_STORAGE_TYPE');
515: FND_MSG_PUB.Add;
516: end if;
517: end if;

Line 514: FND_MESSAGE.SET_TOKEN('COLUMN','DATA_STORAGE_TYPE');

510: p_lookup_code => p_data_storage_type)) then
511: l_error := TRUE;
512: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
513: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
514: FND_MESSAGE.SET_TOKEN('COLUMN','DATA_STORAGE_TYPE');
515: FND_MSG_PUB.Add;
516: end if;
517: end if;
518: end if;

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

525: if ( AK_ON_OBJECTS_PUB.G_LOAD_MODE = 'DOWNLOAD' or p_pass = 1) then
526: l_error := TRUE;
527: end if;
528: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
529: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
530: FND_MESSAGE.SET_TOKEN('COLUMN','TABLE_NAME');
531: FND_MSG_PUB.Add;
532: end if;
533: end if;

Line 530: FND_MESSAGE.SET_TOKEN('COLUMN','TABLE_NAME');

526: l_error := TRUE;
527: end if;
528: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
529: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
530: FND_MESSAGE.SET_TOKEN('COLUMN','TABLE_NAME');
531: FND_MSG_PUB.Add;
532: end if;
533: end if;
534: end if;

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

541: if ( AK_ON_OBJECTS_PUB.G_LOAD_MODE = 'DOWNLOAD' or p_pass = 1 ) then
542: l_error := TRUE;
543: end if;
544: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
545: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
546: FND_MESSAGE.SET_TOKEN('COLUMN','BASE_TABLE_COLUMN_NAME');
547: FND_MSG_PUB.Add;
548: end if;
549: end if;

Line 546: FND_MESSAGE.SET_TOKEN('COLUMN','BASE_TABLE_COLUMN_NAME');

542: l_error := TRUE;
543: end if;
544: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
545: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
546: FND_MESSAGE.SET_TOKEN('COLUMN','BASE_TABLE_COLUMN_NAME');
547: FND_MSG_PUB.Add;
548: end if;
549: end if;
550: end if;

Line 557: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');

553: if (p_required_flag <> FND_API.G_MISS_CHAR) then
554: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_required_flag)) then
555: l_error := TRUE;
556: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
557: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
558: FND_MESSAGE.SET_TOKEN('COLUMN','REQUIRED_FLAG');
559: FND_MSG_PUB.Add;
560: end if;
561: end if;

Line 558: FND_MESSAGE.SET_TOKEN('COLUMN','REQUIRED_FLAG');

554: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_required_flag)) then
555: l_error := TRUE;
556: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
557: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
558: FND_MESSAGE.SET_TOKEN('COLUMN','REQUIRED_FLAG');
559: FND_MSG_PUB.Add;
560: end if;
561: end if;
562: end if;

Line 576: FND_MESSAGE.SET_NAME('AK','AK_LOV_REG_DOES_NOT_EXIST');

572: p_region_application_id => p_lov_region_application_id,
573: p_region_code => p_lov_region_code)) then
574: l_error := TRUE;
575: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
576: FND_MESSAGE.SET_NAME('AK','AK_LOV_REG_DOES_NOT_EXIST');
577: FND_MSG_PUB.Add;
578: end if;
579: end if; /* if REGION_EXISTS */
580: end if;

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

592: p_attribute_application_id => p_lov_attribute_application_id,
593: p_attribute_code => p_lov_attribute_code)) then
594: l_error := TRUE;
595: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
596: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_ITEM_REFERENCE');
597: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_attribute_application_id) ||
598: ' ' || p_lov_attribute_code);
599: FND_MSG_PUB.Add;
600: end if;

Line 597: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_attribute_application_id) ||

593: p_attribute_code => p_lov_attribute_code)) then
594: l_error := TRUE;
595: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
596: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_ITEM_REFERENCE');
597: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_attribute_application_id) ||
598: ' ' || p_lov_attribute_code);
599: FND_MSG_PUB.Add;
600: end if;
601: end if;

Line 613: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_FK_REFERENCE');

609: p_return_status => l_return_status,
610: p_foreign_key_name => p_lov_foreign_key_name)) then
611: l_error := TRUE;
612: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
613: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_FK_REFERENCE');
614: FND_MESSAGE.SET_TOKEN('KEY', p_lov_foreign_key_name);
615: FND_MSG_PUB.Add;
616: end if;
617: end if;

Line 614: FND_MESSAGE.SET_TOKEN('KEY', p_lov_foreign_key_name);

610: p_foreign_key_name => p_lov_foreign_key_name)) then
611: l_error := TRUE;
612: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
613: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_FK_REFERENCE');
614: FND_MESSAGE.SET_TOKEN('KEY', p_lov_foreign_key_name);
615: FND_MSG_PUB.Add;
616: end if;
617: end if;
618: end if; /* if p_lov_foreign_key_name */

Line 625: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');

621: if (p_bold <> FND_API.G_MISS_CHAR) then
622: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_bold)) then
623: l_error := TRUE;
624: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
625: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
626: FND_MESSAGE.SET_TOKEN('COLUMN','BOLD');
627: FND_MSG_PUB.Add;
628: end if;
629: end if;

Line 626: FND_MESSAGE.SET_TOKEN('COLUMN','BOLD');

622: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_bold)) then
623: l_error := TRUE;
624: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
625: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
626: FND_MESSAGE.SET_TOKEN('COLUMN','BOLD');
627: FND_MSG_PUB.Add;
628: end if;
629: end if;
630: end if;

Line 637: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');

633: if (p_italic <> FND_API.G_MISS_CHAR) then
634: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_italic)) then
635: l_error := TRUE;
636: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
637: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
638: FND_MESSAGE.SET_TOKEN('COLUMN','ITALIC');
639: FND_MSG_PUB.Add;
640: end if;
641: end if;

Line 638: FND_MESSAGE.SET_TOKEN('COLUMN','ITALIC');

634: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_italic)) then
635: l_error := TRUE;
636: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
637: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
638: FND_MESSAGE.SET_TOKEN('COLUMN','ITALIC');
639: FND_MSG_PUB.Add;
640: end if;
641: end if;
642: end if;

Line 653: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN');

649: if ( AK_ON_OBJECTS_PUB.G_LOAD_MODE = 'DOWNLOAD' or p_pass = 1 ) then
650: l_error := TRUE;
651: end if;
652: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
653: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN');
654: FND_MESSAGE.SET_TOKEN('COLUMN',p_column_name);
655: FND_MESSAGE.SET_TOKEN('OBJECT',p_database_object_name);
656: FND_MSG_PUB.Add;
657: end if;

Line 654: FND_MESSAGE.SET_TOKEN('COLUMN',p_column_name);

650: l_error := TRUE;
651: end if;
652: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
653: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN');
654: FND_MESSAGE.SET_TOKEN('COLUMN',p_column_name);
655: FND_MESSAGE.SET_TOKEN('OBJECT',p_database_object_name);
656: FND_MSG_PUB.Add;
657: end if;
658: -- dbms_output.put_line('Column name not in this database object');

Line 655: FND_MESSAGE.SET_TOKEN('OBJECT',p_database_object_name);

651: end if;
652: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
653: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN');
654: FND_MESSAGE.SET_TOKEN('COLUMN',p_column_name);
655: FND_MESSAGE.SET_TOKEN('OBJECT',p_database_object_name);
656: FND_MSG_PUB.Add;
657: end if;
658: -- dbms_output.put_line('Column name not in this database object');
659: end if;

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

667: p_lookup_type => 'VERTICAL_ALIGNMENT',
668: p_lookup_code => p_vertical_alignment)) then
669: l_error := TRUE;
670: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
671: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
672: FND_MESSAGE.SET_TOKEN('COLUMN','VERTICAL_ALIGNMENT');
673: FND_MSG_PUB.Add;
674: end if;
675: end if;

Line 672: FND_MESSAGE.SET_TOKEN('COLUMN','VERTICAL_ALIGNMENT');

668: p_lookup_code => p_vertical_alignment)) then
669: l_error := TRUE;
670: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
671: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
672: FND_MESSAGE.SET_TOKEN('COLUMN','VERTICAL_ALIGNMENT');
673: FND_MSG_PUB.Add;
674: end if;
675: end if;
676: end if;

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

683: p_lookup_type => 'HORIZONTAL_ALIGNMENT',
684: p_lookup_code => p_horizontal_alignment)) then
685: l_error := TRUE;
686: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
687: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
688: FND_MESSAGE.SET_TOKEN('COLUMN','HORIZONTAL_ALIGNMENT');
689: FND_MSG_PUB.Add;
690: end if;
691: end if;

Line 688: FND_MESSAGE.SET_TOKEN('COLUMN','HORIZONTAL_ALIGNMENT');

684: p_lookup_code => p_horizontal_alignment)) then
685: l_error := TRUE;
686: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
687: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
688: FND_MESSAGE.SET_TOKEN('COLUMN','HORIZONTAL_ALIGNMENT');
689: FND_MSG_PUB.Add;
690: end if;
691: end if;
692: end if;

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

795: if ((p_database_object_name is null) or
796: (p_database_object_name = FND_API.G_MISS_CHAR)) then
797: l_error := TRUE;
798: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
799: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
800: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
801: FND_MSG_PUB.Add;
802: end if;
803: end if;

Line 800: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');

796: (p_database_object_name = FND_API.G_MISS_CHAR)) then
797: l_error := TRUE;
798: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
799: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
800: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
801: FND_MSG_PUB.Add;
802: end if;
803: end if;
804:

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

805: if ((p_attribute_application_id is null) or
806: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
807: l_error := TRUE;
808: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
809: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
810: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
811: FND_MSG_PUB.Add;
812: end if;
813: end if;

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

806: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
807: l_error := TRUE;
808: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
809: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
810: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
811: FND_MSG_PUB.Add;
812: end if;
813: end if;
814:

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

815: if ((p_attribute_code is null) or
816: (p_attribute_code = FND_API.G_MISS_CHAR)) then
817: l_error := TRUE;
818: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
819: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
820: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
821: FND_MSG_PUB.Add;
822: end if;
823: end if;

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

816: (p_attribute_code = FND_API.G_MISS_CHAR)) then
817: l_error := TRUE;
818: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
819: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
820: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
821: FND_MSG_PUB.Add;
822: end if;
823: end if;
824:

Line 841: FND_MESSAGE.SET_NAME('AK','AK_ONE_VALUE_ONLY');

837: end if;
838: if (l_count <> 1) then
839: l_error := TRUE;
840: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
841: FND_MESSAGE.SET_NAME('AK','AK_ONE_VALUE_ONLY');
842: FND_MSG_PUB.Add;
843: end if;
844: -- dbms_output.put_line('One and only one of value_vachar2, value_number' ||
845: -- ' and value_date must be non-null');

Line 857: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OA_REFERENCE');

853: if (l_check_objattr_csr%notfound) then
854: close l_check_objattr_csr;
855: l_error := TRUE;
856: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
857: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OA_REFERENCE');
858: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
859: ' ' || to_char(p_attribute_application_id) ||
860: ' ' || p_attribute_code);
861: FND_MSG_PUB.Add;

Line 858: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

854: close l_check_objattr_csr;
855: l_error := TRUE;
856: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
857: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OA_REFERENCE');
858: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
859: ' ' || to_char(p_attribute_application_id) ||
860: ' ' || p_attribute_code);
861: FND_MSG_PUB.Add;
862: end if;

Line 874: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');

870: if (upper(l_data_type) = 'VARCHAR2') then
871: if (p_value_date is not null) or (p_value_number is not null) then
872: l_error := TRUE;
873: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
874: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
875: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
876: FND_MSG_PUB.Add;
877: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
878: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');

Line 875: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');

871: if (p_value_date is not null) or (p_value_number is not null) then
872: l_error := TRUE;
873: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
874: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
875: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
876: FND_MSG_PUB.Add;
877: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
878: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');
879: FND_MSG_PUB.Add;

Line 877: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');

873: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
874: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
875: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
876: FND_MSG_PUB.Add;
877: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
878: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');
879: FND_MSG_PUB.Add;
880: end if;
881: -- dbms_output.put_line('value_date and value_number must be null');

Line 878: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');

874: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
875: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
876: FND_MSG_PUB.Add;
877: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
878: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');
879: FND_MSG_PUB.Add;
880: end if;
881: -- dbms_output.put_line('value_date and value_number must be null');
882: end if;

Line 887: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');

883: elsif (upper(l_data_type) = 'NUMBER') then
884: if (p_value_date is not null) or (p_value_varchar2 is not null) then
885: l_error := TRUE;
886: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
887: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
888: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
889: FND_MSG_PUB.Add;
890: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
891: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');

Line 888: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');

884: if (p_value_date is not null) or (p_value_varchar2 is not null) then
885: l_error := TRUE;
886: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
887: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
888: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
889: FND_MSG_PUB.Add;
890: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
891: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');
892: FND_MSG_PUB.Add;

Line 890: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');

886: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
887: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
888: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
889: FND_MSG_PUB.Add;
890: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
891: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');
892: FND_MSG_PUB.Add;
893: end if;
894: -- dbms_output.put_line('value_date and value_varchar2 must be null');

Line 891: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');

887: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
888: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
889: FND_MSG_PUB.Add;
890: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
891: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');
892: FND_MSG_PUB.Add;
893: end if;
894: -- dbms_output.put_line('value_date and value_varchar2 must be null');
895: end if;

Line 901: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');

897: (upper(l_data_type) = 'DATETIME') )then
898: if (p_value_number is not null) or (p_value_varchar2 is not null) then
899: l_error := TRUE;
900: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
901: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
902: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');
903: FND_MSG_PUB.Add;
904: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
905: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');

Line 902: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');

898: if (p_value_number is not null) or (p_value_varchar2 is not null) then
899: l_error := TRUE;
900: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
901: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
902: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');
903: FND_MSG_PUB.Add;
904: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
905: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');
906: FND_MSG_PUB.Add;

Line 904: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');

900: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
901: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
902: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');
903: FND_MSG_PUB.Add;
904: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
905: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');
906: FND_MSG_PUB.Add;
907: end if;
908: -- dbms_output.put_line('value_number and value_varchar2 must be null');

Line 905: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');

901: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
902: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');
903: FND_MSG_PUB.Add;
904: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
905: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');
906: FND_MSG_PUB.Add;
907: end if;
908: -- dbms_output.put_line('value_number and value_varchar2 must be null');
909: end if;

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

917: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
918: then
919: l_error := TRUE;
920: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
921: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
922: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_REGION_APPL_ID');
923: FND_MSG_PUB.Add;
924: end if;
925: end if;

Line 922: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_REGION_APPL_ID');

918: then
919: l_error := TRUE;
920: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
921: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
922: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_REGION_APPL_ID');
923: FND_MSG_PUB.Add;
924: end if;
925: end if;
926:

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

929: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
930: then
931: l_error := TRUE;
932: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
933: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
934: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_REGION_CODE');
935: FND_MSG_PUB.Add;
936: end if;
937: end if;

Line 934: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_REGION_CODE');

930: then
931: l_error := TRUE;
932: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
933: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
934: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_REGION_CODE');
935: FND_MSG_PUB.Add;
936: end if;
937: end if;
938:

Line 950: FND_MESSAGE.SET_NAME('AK','AK_INVALID_TO_REGION');

946: p_to_region_code,
947: p_database_object_name) ) then
948: l_error := TRUE;
949: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
950: FND_MESSAGE.SET_NAME('AK','AK_INVALID_TO_REGION');
951: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_to_region_appl_id) ||
952: ' ' || p_to_region_code);
953: FND_MESSAGE.SET_TOKEN('OBJECT', p_database_object_name );
954: FND_MSG_PUB.Add;

Line 951: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_to_region_appl_id) ||

947: p_database_object_name) ) then
948: l_error := TRUE;
949: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
950: FND_MESSAGE.SET_NAME('AK','AK_INVALID_TO_REGION');
951: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_to_region_appl_id) ||
952: ' ' || p_to_region_code);
953: FND_MESSAGE.SET_TOKEN('OBJECT', p_database_object_name );
954: FND_MSG_PUB.Add;
955: end if;

Line 953: FND_MESSAGE.SET_TOKEN('OBJECT', p_database_object_name );

949: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
950: FND_MESSAGE.SET_NAME('AK','AK_INVALID_TO_REGION');
951: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_to_region_appl_id) ||
952: ' ' || p_to_region_code);
953: FND_MESSAGE.SET_TOKEN('OBJECT', p_database_object_name );
954: FND_MSG_PUB.Add;
955: end if;
956: end if;
957: end if; /* if p_to_region_appl_id */

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

1064: if ((p_database_object_name is null) or
1065: (p_database_object_name = FND_API.G_MISS_CHAR)) then
1066: l_error := TRUE;
1067: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1068: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1069: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
1070: FND_MSG_PUB.Add;
1071: end if;
1072: end if;

Line 1069: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');

1065: (p_database_object_name = FND_API.G_MISS_CHAR)) then
1066: l_error := TRUE;
1067: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1068: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1069: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
1070: FND_MSG_PUB.Add;
1071: end if;
1072: end if;
1073:

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

1074: if ((p_attribute_application_id is null) or
1075: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
1076: l_error := TRUE;
1077: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1078: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1079: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
1080: FND_MSG_PUB.Add;
1081: end if;
1082: end if;

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

1075: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
1076: l_error := TRUE;
1077: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1078: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1079: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
1080: FND_MSG_PUB.Add;
1081: end if;
1082: end if;
1083:

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

1084: if ((p_attribute_code is null) or
1085: (p_attribute_code = FND_API.G_MISS_CHAR)) then
1086: l_error := TRUE;
1087: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1088: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1089: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
1090: FND_MSG_PUB.Add;
1091: end if;
1092: end if;

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

1085: (p_attribute_code = FND_API.G_MISS_CHAR)) then
1086: l_error := TRUE;
1087: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1088: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1089: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
1090: FND_MSG_PUB.Add;
1091: end if;
1092: end if;
1093:

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

1094: if ((p_key_value1 is null) or
1095: (p_key_value1 = FND_API.G_MISS_CHAR)) then
1096: l_error := TRUE;
1097: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1098: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1099: FND_MESSAGE.SET_TOKEN('COLUMN', 'KEY_VALUE1');
1100: FND_MSG_PUB.Add;
1101: end if;
1102: end if;

Line 1099: FND_MESSAGE.SET_TOKEN('COLUMN', 'KEY_VALUE1');

1095: (p_key_value1 = FND_API.G_MISS_CHAR)) then
1096: l_error := TRUE;
1097: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1098: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1099: FND_MESSAGE.SET_TOKEN('COLUMN', 'KEY_VALUE1');
1100: FND_MSG_PUB.Add;
1101: end if;
1102: end if;
1103:

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

1109: if (l_check_objattr_csr%notfound) then
1110: close l_check_objattr_csr;
1111: l_error := TRUE;
1112: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1113: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OA_REFERENCE');
1114: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1115: ' ' || to_char(p_attribute_application_id) ||
1116: ' ' || p_attribute_code);
1117: FND_MSG_PUB.Add;

Line 1114: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

1110: close l_check_objattr_csr;
1111: l_error := TRUE;
1112: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1113: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OA_REFERENCE');
1114: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1115: ' ' || to_char(p_attribute_application_id) ||
1116: ' ' || p_attribute_code);
1117: FND_MSG_PUB.Add;
1118: end if;

Line 1132: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');

1128: (p_value_varchar2 <> FND_API.G_MISS_CHAR) then
1129: if (upper(l_data_type) <> 'VARCHAR2') then
1130: l_error := TRUE;
1131: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1132: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
1133: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');
1134: FND_MSG_PUB.Add;
1135: end if;
1136: -- dbms_output.put_line('value_varchar2 must be null for this attribute');

Line 1133: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');

1129: if (upper(l_data_type) <> 'VARCHAR2') then
1130: l_error := TRUE;
1131: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1132: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
1133: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');
1134: FND_MSG_PUB.Add;
1135: end if;
1136: -- dbms_output.put_line('value_varchar2 must be null for this attribute');
1137: end if;

Line 1145: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');

1141: (p_value_number <> FND_API.G_MISS_NUM) then
1142: if (upper(l_data_type) <> 'NUMBER') then
1143: l_error := TRUE;
1144: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1145: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
1146: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');
1147: FND_MSG_PUB.Add;
1148: end if;
1149: --dbms_output.put_line('value_number must be null for this attribute');

Line 1146: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');

1142: if (upper(l_data_type) <> 'NUMBER') then
1143: l_error := TRUE;
1144: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1145: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
1146: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');
1147: FND_MSG_PUB.Add;
1148: end if;
1149: --dbms_output.put_line('value_number must be null for this attribute');
1150: end if;

Line 1159: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');

1155: if (upper(l_data_type) <> 'DATE') and
1156: (upper(l_data_type) <> 'DATETIME') then
1157: l_error := TRUE;
1158: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1159: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
1160: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
1161: FND_MSG_PUB.Add;
1162: end if;
1163: --dbms_output.put_line('value_date must be null for this attribute');

Line 1160: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');

1156: (upper(l_data_type) <> 'DATETIME') then
1157: l_error := TRUE;
1158: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1159: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
1160: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
1161: FND_MSG_PUB.Add;
1162: end if;
1163: --dbms_output.put_line('value_date must be null for this attribute');
1164: end if;

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

1271: if ((p_database_object_name is null) or
1272: (p_database_object_name = FND_API.G_MISS_CHAR)) then
1273: l_error := TRUE;
1274: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1275: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1276: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
1277: FND_MSG_PUB.Add;
1278: end if;
1279: end if;

Line 1276: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');

1272: (p_database_object_name = FND_API.G_MISS_CHAR)) then
1273: l_error := TRUE;
1274: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1275: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1276: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
1277: FND_MSG_PUB.Add;
1278: end if;
1279: end if;
1280:

Line 1296: FND_MESSAGE.SET_NAME('AK','AK_INVALID_VIEW_REFERENCE');

1292: if ( AK_ON_OBJECTS_PUB.G_LOAD_MODE = 'DOWNLOAD' or p_pass = 1 ) then
1293: l_error := TRUE;
1294: end if;
1295: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1296: FND_MESSAGE.SET_NAME('AK','AK_INVALID_VIEW_REFERENCE');
1297: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
1298: FND_MSG_PUB.Add;
1299: end if;
1300: end if;

Line 1297: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);

1293: l_error := TRUE;
1294: end if;
1295: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1296: FND_MESSAGE.SET_NAME('AK','AK_INVALID_VIEW_REFERENCE');
1297: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
1298: FND_MSG_PUB.Add;
1299: end if;
1300: end if;
1301: close l_check_object_csr;

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

1308: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
1309: then
1310: l_error := TRUE;
1311: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1312: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1313: FND_MESSAGE.SET_TOKEN('COLUMN', 'APPLICATION_ID');
1314: FND_MSG_PUB.Add;
1315: end if;
1316: end if;

Line 1313: FND_MESSAGE.SET_TOKEN('COLUMN', 'APPLICATION_ID');

1309: then
1310: l_error := TRUE;
1311: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1312: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1313: FND_MESSAGE.SET_TOKEN('COLUMN', 'APPLICATION_ID');
1314: FND_MSG_PUB.Add;
1315: end if;
1316: end if;
1317:

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

1324: p_return_status => l_return_status,
1325: p_application_id => p_application_id)) then
1326: l_error := TRUE;
1327: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1328: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
1329: FND_MESSAGE.SET_TOKEN('COLUMN','APPLICATION_ID');
1330: FND_MSG_PUB.Add;
1331: end if;
1332: --dbms_output.put_line('Invalid application ID');

Line 1329: FND_MESSAGE.SET_TOKEN('COLUMN','APPLICATION_ID');

1325: p_application_id => p_application_id)) then
1326: l_error := TRUE;
1327: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1328: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
1329: FND_MESSAGE.SET_TOKEN('COLUMN','APPLICATION_ID');
1330: FND_MSG_PUB.Add;
1331: end if;
1332: --dbms_output.put_line('Invalid application ID');
1333: end if;

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

1340: p_database_object_name => p_database_object_name,
1341: p_primary_key_name => p_primary_key_name)) then
1342: l_error := TRUE;
1343: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1344: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
1345: FND_MESSAGE.SET_TOKEN('COLUMN','PRIMARY_KEY_NAME');
1346: FND_MSG_PUB.Add;
1347: end if;
1348: end if;

Line 1345: FND_MESSAGE.SET_TOKEN('COLUMN','PRIMARY_KEY_NAME');

1341: p_primary_key_name => p_primary_key_name)) then
1342: l_error := TRUE;
1343: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1344: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
1345: FND_MESSAGE.SET_TOKEN('COLUMN','PRIMARY_KEY_NAME');
1346: FND_MSG_PUB.Add;
1347: end if;
1348: end if;
1349: end if;

Line 1429: FND_MESSAGE.SET_NAME('AK','AK_INSERT_OBJECT_PK_FAILED');

1425: p_object_pk_tbl => p_to_table);
1426: if (l_return_status = FND_API.G_RET_STS_ERROR) or
1427: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1428: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1429: FND_MESSAGE.SET_NAME('AK','AK_INSERT_OBJECT_PK_FAILED');
1430: FND_MSG_PUB.Add;
1431: end if;
1432: -- dbms_output.put_line(l_api_name || 'Error inserting object PK table');
1433: raise FND_API.G_EXC_ERROR;

Line 2052: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_DOES_NOT_EXIST');

2048: p_database_object_name => p_database_object_name,
2049: p_attribute_application_id => p_attribute_application_id,
2050: p_attribute_code => p_attribute_code) then
2051: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2052: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_DOES_NOT_EXIST');
2053: FND_MSG_PUB.Add;
2054: end if;
2055: raise FND_API.G_EXC_ERROR;
2056: end if;

Line 2072: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OA_NAV');

2068: l_value_number;
2069: if l_get_navigations_csr%found then
2070: close l_get_navigations_csr;
2071: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2072: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OA_NAV');
2073: FND_MSG_PUB.Add;
2074: end if;
2075: raise FND_API.G_EXC_ERROR;
2076: end if;

Line 2088: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DELETE_REFERENCE');

2084: l_key_value6, l_key_value7, l_key_value8, l_key_value9, l_key_value10;
2085: if l_get_attr_values_csr%found then
2086: close l_get_attr_values_csr;
2087: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2088: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DELETE_REFERENCE');
2089: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_OBJECT_ATTRIBUTES',TRUE);
2090: FND_MESSAGE.SET_TOKEN('REF_OBJECT', 'AK_ATTRIBUTE_VALUE',TRUE);
2091: FND_MSG_PUB.Add;
2092: end if;

Line 2089: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_OBJECT_ATTRIBUTES',TRUE);

2085: if l_get_attr_values_csr%found then
2086: close l_get_attr_values_csr;
2087: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2088: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DELETE_REFERENCE');
2089: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_OBJECT_ATTRIBUTES',TRUE);
2090: FND_MESSAGE.SET_TOKEN('REF_OBJECT', 'AK_ATTRIBUTE_VALUE',TRUE);
2091: FND_MSG_PUB.Add;
2092: end if;
2093: raise FND_API.G_EXC_ERROR;

Line 2090: FND_MESSAGE.SET_TOKEN('REF_OBJECT', 'AK_ATTRIBUTE_VALUE',TRUE);

2086: close l_get_attr_values_csr;
2087: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2088: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DELETE_REFERENCE');
2089: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_OBJECT_ATTRIBUTES',TRUE);
2090: FND_MESSAGE.SET_TOKEN('REF_OBJECT', 'AK_ATTRIBUTE_VALUE',TRUE);
2091: FND_MSG_PUB.Add;
2092: end if;
2093: raise FND_API.G_EXC_ERROR;
2094: end if;

Line 2104: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OA_ITEM');

2100: fetch l_get_region_item_csr into l_region_application_id, l_region_code;
2101: if l_get_region_item_csr%found then
2102: close l_get_region_item_csr;
2103: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2104: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OA_ITEM');
2105: FND_MSG_PUB.Add;
2106: end if;
2107: raise FND_API.G_EXC_ERROR;
2108: end if;

Line 2120: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OA_PREGIM');

2116: l_region_application_id, l_region_code;
2117: if l_get_page_region_item_csr%found then
2118: close l_get_page_region_item_csr;
2119: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2120: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OA_PREGIM');
2121: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_OBJECT_ATTRIBUTES',TRUE);
2122: FND_MESSAGE.SET_TOKEN('REF_OBJECT', 'AK_REGION_ITEMS',TRUE);
2123: FND_MSG_PUB.Add;
2124: end if;

Line 2121: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_OBJECT_ATTRIBUTES',TRUE);

2117: if l_get_page_region_item_csr%found then
2118: close l_get_page_region_item_csr;
2119: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2120: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OA_PREGIM');
2121: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_OBJECT_ATTRIBUTES',TRUE);
2122: FND_MESSAGE.SET_TOKEN('REF_OBJECT', 'AK_REGION_ITEMS',TRUE);
2123: FND_MSG_PUB.Add;
2124: end if;
2125: raise FND_API.G_EXC_ERROR;

Line 2122: FND_MESSAGE.SET_TOKEN('REF_OBJECT', 'AK_REGION_ITEMS',TRUE);

2118: close l_get_page_region_item_csr;
2119: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2120: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OA_PREGIM');
2121: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_OBJECT_ATTRIBUTES',TRUE);
2122: FND_MESSAGE.SET_TOKEN('REF_OBJECT', 'AK_REGION_ITEMS',TRUE);
2123: FND_MSG_PUB.Add;
2124: end if;
2125: raise FND_API.G_EXC_ERROR;
2126: end if;

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

2268: and attribute_code = p_attribute_code;
2269:
2270: if (sql%notfound) then
2271: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2272: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_DOES_NOT_EXIST');
2273: FND_MSG_PUB.Add;
2274: end if;
2275: raise FND_API.G_EXC_ERROR;
2276: end if;

Line 2285: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_DOES_NOT_EXIST');

2281: and attribute_code = p_attribute_code;
2282:
2283: if (sql%notfound) then
2284: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2285: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_DOES_NOT_EXIST');
2286: FND_MSG_PUB.Add;
2287: end if;
2288: raise FND_API.G_EXC_ERROR;
2289: end if;

Line 2295: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_DELETED');

2291: --
2292: -- Load success message
2293: --
2294: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2295: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_DELETED');
2296: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2297: ' ' || to_char(p_attribute_application_id) ||
2298: ' ' || p_attribute_code);
2299: FND_MSG_PUB.Add;

Line 2296: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

2292: -- Load success message
2293: --
2294: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2295: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_DELETED');
2296: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2297: ' ' || to_char(p_attribute_application_id) ||
2298: ' ' || p_attribute_code);
2299: FND_MSG_PUB.Add;
2300: end if;

Line 2311: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_NOT_DELETED');

2307:
2308: EXCEPTION
2309: WHEN FND_API.G_EXC_ERROR THEN
2310: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2311: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_NOT_DELETED');
2312: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2313: ' ' || to_char(p_attribute_application_id) ||
2314: ' ' || p_attribute_code);
2315: FND_MSG_PUB.Add;

Line 2312: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

2308: EXCEPTION
2309: WHEN FND_API.G_EXC_ERROR THEN
2310: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2311: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_NOT_DELETED');
2312: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2313: ' ' || to_char(p_attribute_application_id) ||
2314: ' ' || p_attribute_code);
2315: FND_MSG_PUB.Add;
2316: end if;

Line 2412: FND_MESSAGE.SET_NAME('AK','AK_NAV_DOES_NOT_EXIST');

2408: p_value_varchar2 => p_value_varchar2,
2409: p_value_date => p_value_date,
2410: p_value_number => p_value_number) then
2411: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2412: FND_MESSAGE.SET_NAME('AK','AK_NAV_DOES_NOT_EXIST');
2413: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_NAVIGATION', TRUE);
2414: FND_MSG_PUB.Add;
2415: end if;
2416: raise FND_API.G_EXC_ERROR;

Line 2413: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_NAVIGATION', TRUE);

2409: p_value_date => p_value_date,
2410: p_value_number => p_value_number) then
2411: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2412: FND_MESSAGE.SET_NAME('AK','AK_NAV_DOES_NOT_EXIST');
2413: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_NAVIGATION', TRUE);
2414: FND_MSG_PUB.Add;
2415: end if;
2416: raise FND_API.G_EXC_ERROR;
2417: end if;

Line 2469: FND_MESSAGE.SET_NAME('AK','AK_NAV_DOES_NOT_EXIST');

2465: end if;
2466:
2467: if (sql%notfound) then
2468: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2469: FND_MESSAGE.SET_NAME('AK','AK_NAV_DOES_NOT_EXIST');
2470: FND_MSG_PUB.Add;
2471: end if;
2472: raise FND_API.G_EXC_ERROR;
2473: end if;

Line 2479: FND_MESSAGE.SET_NAME('AK','AK_NAV_DELETED');

2475: --
2476: -- Load success message
2477: --
2478: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2479: FND_MESSAGE.SET_NAME('AK','AK_NAV_DELETED');
2480: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2481: ' ' || to_char(p_attribute_application_id) ||
2482: ' ' || p_attribute_code ||
2483: ' ' || p_value_varchar2 ||

Line 2480: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

2476: -- Load success message
2477: --
2478: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2479: FND_MESSAGE.SET_NAME('AK','AK_NAV_DELETED');
2480: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2481: ' ' || to_char(p_attribute_application_id) ||
2482: ' ' || p_attribute_code ||
2483: ' ' || p_value_varchar2 ||
2484: to_char(p_value_date) ||

Line 2498: FND_MESSAGE.SET_NAME('AK','AK_NAV_NOT_DELETED');

2494:
2495: EXCEPTION
2496: WHEN FND_API.G_EXC_ERROR THEN
2497: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2498: FND_MESSAGE.SET_NAME('AK','AK_NAV_NOT_DELETED');
2499: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_NAVIGATION', TRUE);
2500: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2501: ' ' || to_char(p_attribute_application_id)||
2502: ' ' || p_attribute_code ||

Line 2499: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_NAVIGATION', TRUE);

2495: EXCEPTION
2496: WHEN FND_API.G_EXC_ERROR THEN
2497: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2498: FND_MESSAGE.SET_NAME('AK','AK_NAV_NOT_DELETED');
2499: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_NAVIGATION', TRUE);
2500: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2501: ' ' || to_char(p_attribute_application_id)||
2502: ' ' || p_attribute_code ||
2503: ' ' || p_value_varchar2 ||

Line 2500: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

2496: WHEN FND_API.G_EXC_ERROR THEN
2497: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2498: FND_MESSAGE.SET_NAME('AK','AK_NAV_NOT_DELETED');
2499: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_NAVIGATION', TRUE);
2500: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2501: ' ' || to_char(p_attribute_application_id)||
2502: ' ' || p_attribute_code ||
2503: ' ' || p_value_varchar2 ||
2504: to_char(p_value_date) ||

Line 2659: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');

2655: p_key_value8 => p_key_value8,
2656: p_key_value9 => p_key_value9,
2657: p_key_value10 => p_key_value10) then
2658: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2659: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
2660: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2661: FND_MSG_PUB.Add;
2662: end if;
2663: raise FND_API.G_EXC_ERROR;

Line 2660: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);

2656: p_key_value9 => p_key_value9,
2657: p_key_value10 => p_key_value10) then
2658: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2659: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
2660: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2661: FND_MSG_PUB.Add;
2662: end if;
2663: raise FND_API.G_EXC_ERROR;
2664: end if;

Line 2780: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');

2776: end if;
2777:
2778: if (dbms_sql.execute(l_sql_csr) = 0) then
2779: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2780: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
2781: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2782: FND_MSG_PUB.Add;
2783: end if;
2784: dbms_sql.close_cursor(l_sql_csr);

Line 2781: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);

2777:
2778: if (dbms_sql.execute(l_sql_csr) = 0) then
2779: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2780: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
2781: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2782: FND_MSG_PUB.Add;
2783: end if;
2784: dbms_sql.close_cursor(l_sql_csr);
2785: raise FND_API.G_EXC_ERROR;

Line 2793: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DELETED');

2789: --
2790: -- Load success message
2791: --
2792: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2793: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DELETED');
2794: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2795: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2796: ' ' || to_char(p_attribute_application_id) ||
2797: ' ' || p_attribute_code ||

Line 2794: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);

2790: -- Load success message
2791: --
2792: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2793: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DELETED');
2794: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2795: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2796: ' ' || to_char(p_attribute_application_id) ||
2797: ' ' || p_attribute_code ||
2798: ' ' || p_key_value1 ||

Line 2795: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

2791: --
2792: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2793: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DELETED');
2794: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2795: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2796: ' ' || to_char(p_attribute_application_id) ||
2797: ' ' || p_attribute_code ||
2798: ' ' || p_key_value1 ||
2799: ' ' || l_key_value2 ||

Line 2820: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DELETED');

2816:
2817: EXCEPTION
2818: WHEN FND_API.G_EXC_ERROR THEN
2819: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2820: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DELETED');
2821: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2822: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2823: ' ' || to_char(p_attribute_application_id) ||
2824: ' ' || p_attribute_code ||

Line 2821: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);

2817: EXCEPTION
2818: WHEN FND_API.G_EXC_ERROR THEN
2819: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2820: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DELETED');
2821: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2822: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2823: ' ' || to_char(p_attribute_application_id) ||
2824: ' ' || p_attribute_code ||
2825: ' ' || p_key_value1 ||

Line 2822: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

2818: WHEN FND_API.G_EXC_ERROR THEN
2819: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2820: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DELETED');
2821: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2822: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2823: ' ' || to_char(p_attribute_application_id) ||
2824: ' ' || p_attribute_code ||
2825: ' ' || p_key_value1 ||
2826: ' ' || l_key_value2 ||

Line 2940: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');

2936: p_api_version_number => 1.0,
2937: p_return_status => l_return_status,
2938: p_database_object_name => p_database_object_name) then
2939: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2940: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
2941: FND_MSG_PUB.Add;
2942: end if;
2943: raise FND_API.G_EXC_ERROR;
2944: end if;

Line 2960: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OBJ_OA');

2956: l_attribute_application_id, l_attribute_code;
2957: if l_get_obj_attributes_csr%found then
2958: close l_get_obj_attributes_csr;
2959: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2960: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OBJ_OA');
2961: FND_MSG_PUB.Add;
2962: end if;
2963: raise FND_API.G_EXC_ERROR;
2964: end if;

Line 2974: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OBJ_UK');

2970: fetch l_get_unique_keys_csr into l_unique_key_name;
2971: if l_get_unique_keys_csr%found then
2972: close l_get_unique_keys_csr;
2973: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2974: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OBJ_UK');
2975: FND_MSG_PUB.Add;
2976: end if;
2977: raise FND_API.G_EXC_ERROR;
2978: end if;

Line 2988: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OBJ_FK');

2984: fetch l_get_foreign_keys_csr into l_foreign_key_name;
2985: if l_get_foreign_keys_csr%found then
2986: close l_get_foreign_keys_csr;
2987: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2988: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OBJ_FK');
2989: FND_MSG_PUB.Add;
2990: end if;
2991: raise FND_API.G_EXC_ERROR;
2992: end if;

Line 3002: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OBJ_REG');

2998: fetch l_get_regions_csr into l_region_application_id, l_region_code;
2999: if l_get_regions_csr%found then
3000: close l_get_regions_csr;
3001: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3002: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OBJ_REG');
3003: FND_MSG_PUB.Add;
3004: end if;
3005: raise FND_API.G_EXC_ERROR;
3006: end if;

Line 3122: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');

3118: where database_object_name = p_database_object_name;
3119:
3120: if (sql%notfound) then
3121: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3122: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
3123: FND_MSG_PUB.Add;
3124: end if;
3125: raise FND_API.G_EXC_ERROR;
3126: end if;

Line 3132: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DELETED');

3128: --
3129: -- Load success message
3130: --
3131: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
3132: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DELETED');
3133: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
3134: FND_MSG_PUB.Add;
3135: end if;
3136:

Line 3133: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);

3129: -- Load success message
3130: --
3131: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
3132: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DELETED');
3133: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
3134: FND_MSG_PUB.Add;
3135: end if;
3136:
3137: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3146: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DELETED');

3142:
3143: EXCEPTION
3144: WHEN FND_API.G_EXC_ERROR THEN
3145: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3146: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DELETED');
3147: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
3148: FND_MSG_PUB.Add;
3149: end if;
3150: p_return_status := FND_API.G_RET_STS_ERROR;

Line 3147: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);

3143: EXCEPTION
3144: WHEN FND_API.G_EXC_ERROR THEN
3145: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3146: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DELETED');
3147: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
3148: FND_MSG_PUB.Add;
3149: end if;
3150: p_return_status := FND_API.G_RET_STS_ERROR;
3151: rollback to start_delete_object;

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

3348: p_api_version_number => 1.0,
3349: p_return_status => l_return_status,
3350: p_database_object_name => p_database_object_name)) then
3351: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3352: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_EXISTS');
3353: FND_MSG_PUB.Add;
3354: end if;
3355: -- dbms_output.put_line(G_PKG_NAME || 'Error - Row already exists');
3356: raise FND_API.G_EXC_ERROR;

Line 3588: FND_MESSAGE.SET_NAME('AK','AK_INSERT_OBJECT_FAILED');

3584: p_api_version_number => 1.0,
3585: p_return_status => l_return_status,
3586: p_database_object_name => p_database_object_name)) then
3587: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3588: FND_MESSAGE.SET_NAME('AK','AK_INSERT_OBJECT_FAILED');
3589: FND_MSG_PUB.Add;
3590: end if;
3591: raise FND_API.G_EXC_ERROR;
3592: end if;

Line 3625: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_CREATED');

3621: where T.DATABASE_OBJECT_NAME = p_database_object_name
3622: and T.LANGUAGE = L.LANGUAGE_CODE);
3623:
3624: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3625: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_CREATED');
3626: FND_MESSAGE.SET_TOKEN('KEY',p_database_object_name);
3627: FND_MSG_PUB.Add;
3628: end if;
3629:

Line 3626: FND_MESSAGE.SET_TOKEN('KEY',p_database_object_name);

3622: and T.LANGUAGE = L.LANGUAGE_CODE);
3623:
3624: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3625: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_CREATED');
3626: FND_MESSAGE.SET_TOKEN('KEY',p_database_object_name);
3627: FND_MSG_PUB.Add;
3628: end if;
3629:
3630: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3639: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');

3635:
3636: EXCEPTION
3637: WHEN VALUE_ERROR THEN
3638: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3639: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');
3640: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
3641: FND_MSG_PUB.Add;
3642: end if;
3643: rollback to start_create_object;

Line 3640: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);

3636: EXCEPTION
3637: WHEN VALUE_ERROR THEN
3638: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3639: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');
3640: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
3641: FND_MSG_PUB.Add;
3642: end if;
3643: rollback to start_create_object;
3644: p_return_status := FND_API.G_RET_STS_ERROR;

Line 3650: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_CREATED');

3646: p_count => p_msg_count,
3647: p_data => p_msg_data);
3648: WHEN FND_API.G_EXC_ERROR THEN
3649: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3650: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_CREATED');
3651: FND_MESSAGE.SET_TOKEN('KEY',p_database_object_name);
3652: FND_MSG_PUB.Add;
3653: end if;
3654: p_return_status := FND_API.G_RET_STS_ERROR;

Line 3651: FND_MESSAGE.SET_TOKEN('KEY',p_database_object_name);

3647: p_data => p_msg_data);
3648: WHEN FND_API.G_EXC_ERROR THEN
3649: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3650: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_CREATED');
3651: FND_MESSAGE.SET_TOKEN('KEY',p_database_object_name);
3652: FND_MSG_PUB.Add;
3653: end if;
3654: p_return_status := FND_API.G_RET_STS_ERROR;
3655: rollback to start_create_object;

Line 3824: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_EXISTS');

3820: p_database_object_name => p_database_object_name,
3821: p_attribute_application_id => p_attribute_application_id,
3822: p_attribute_code => p_attribute_code) ) then
3823: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3824: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_EXISTS');
3825: FND_MSG_PUB.Add;
3826: end if;
3827: -- dbms_output.put_line('OA Key: '||p_database_object_name ||
3828: -- ' ' || to_char(p_attribute_application_id) ||

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

4178: p_database_object_name => p_database_object_name,
4179: p_attribute_application_id => p_attribute_application_id,
4180: p_attribute_code => p_attribute_code) ) then
4181: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4182: FND_MESSAGE.SET_NAME('AK','AK_INSERT_OBJECT_ATTR_FAILED');
4183: FND_MSG_PUB.Add;
4184: end if;
4185: -- dbms_output.put_line(G_PKG_NAME || 'Error - First insert failed');
4186: raise FND_API.G_EXC_ERROR;

Line 4229: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_CREATED');

4225: -- /** commit the insert **/
4226: -- commit;
4227:
4228: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4229: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_CREATED');
4230: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4231: ' ' || to_char(p_attribute_application_id) ||
4232: ' ' || p_attribute_code);
4233: FND_MSG_PUB.Add;

Line 4230: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

4226: -- commit;
4227:
4228: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4229: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_CREATED');
4230: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4231: ' ' || to_char(p_attribute_application_id) ||
4232: ' ' || p_attribute_code);
4233: FND_MSG_PUB.Add;
4234: end if;

Line 4245: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_VALUE_ERROR');

4241:
4242: EXCEPTION
4243: WHEN VALUE_ERROR THEN
4244: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4245: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_VALUE_ERROR');
4246: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4247: ' ' || to_char(p_attribute_application_id) ||
4248: ' ' || p_attribute_code );
4249: FND_MSG_PUB.Add;

Line 4246: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

4242: EXCEPTION
4243: WHEN VALUE_ERROR THEN
4244: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4245: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_VALUE_ERROR');
4246: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4247: ' ' || to_char(p_attribute_application_id) ||
4248: ' ' || p_attribute_code );
4249: FND_MSG_PUB.Add;
4250: end if;

Line 4258: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_NOT_CREATED');

4254: p_count => p_msg_count,
4255: p_data => p_msg_data);
4256: WHEN FND_API.G_EXC_ERROR THEN
4257: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4258: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_NOT_CREATED');
4259: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4260: ' ' || to_char(p_attribute_application_id) ||
4261: ' ' || p_attribute_code);
4262: FND_MSG_PUB.Add;

Line 4259: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

4255: p_data => p_msg_data);
4256: WHEN FND_API.G_EXC_ERROR THEN
4257: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4258: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_NOT_CREATED');
4259: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4260: ' ' || to_char(p_attribute_application_id) ||
4261: ' ' || p_attribute_code);
4262: FND_MSG_PUB.Add;
4263: end if;

Line 4407: FND_MESSAGE.SET_NAME('AK','AK_ONE_VALUE_ONLY');

4403: l_count := l_count + 1;
4404: end if;
4405: if (l_count <> 1) then
4406: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4407: FND_MESSAGE.SET_NAME('AK','AK_ONE_VALUE_ONLY');
4408: FND_MSG_PUB.Add;
4409: end if;
4410: -- dbms_output.put_line('One and only one value field must be non-null');
4411: raise FND_API.G_EXC_ERROR;

Line 4425: FND_MESSAGE.SET_NAME('AK','AK_NAV_EXISTS');

4421: p_value_varchar2 => p_value_varchar2,
4422: p_value_date => p_value_date,
4423: p_value_number => p_value_number) then
4424: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4425: FND_MESSAGE.SET_NAME('AK','AK_NAV_EXISTS');
4426: FND_MSG_PUB.Add;
4427: end if;
4428: raise FND_API.G_EXC_ERROR;
4429: end if;

Line 4628: FND_MESSAGE.SET_NAME('AK','AK_NAV_CREATED');

4624: -- /** commit the insert **/
4625: -- commit;
4626:
4627: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4628: FND_MESSAGE.SET_NAME('AK','AK_NAV_CREATED');
4629: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4630: ' ' || to_char(p_attribute_application_id) ||
4631: ' ' || p_attribute_code || ' ' ||
4632: p_value_varchar2 ||

Line 4629: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

4625: -- commit;
4626:
4627: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4628: FND_MESSAGE.SET_NAME('AK','AK_NAV_CREATED');
4629: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4630: ' ' || to_char(p_attribute_application_id) ||
4631: ' ' || p_attribute_code || ' ' ||
4632: p_value_varchar2 ||
4633: to_char(p_value_date) ||

Line 4647: FND_MESSAGE.SET_NAME('AK','AK_NAV_VALUE_ERROR');

4643:
4644: EXCEPTION
4645: WHEN VALUE_ERROR THEN
4646: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4647: FND_MESSAGE.SET_NAME('AK','AK_NAV_VALUE_ERROR');
4648: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4649: ' ' || to_char(p_attribute_application_id)
4650: || ' ' || p_attribute_code || ' ' ||
4651: p_value_varchar2 ||

Line 4648: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

4644: EXCEPTION
4645: WHEN VALUE_ERROR THEN
4646: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4647: FND_MESSAGE.SET_NAME('AK','AK_NAV_VALUE_ERROR');
4648: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4649: ' ' || to_char(p_attribute_application_id)
4650: || ' ' || p_attribute_code || ' ' ||
4651: p_value_varchar2 ||
4652: to_char(p_value_date) ||

Line 4663: FND_MESSAGE.SET_NAME('AK','AK_NAV_NOT_CREATED');

4659: p_count => p_msg_count,
4660: p_data => p_msg_data);
4661: WHEN FND_API.G_EXC_ERROR THEN
4662: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4663: FND_MESSAGE.SET_NAME('AK','AK_NAV_NOT_CREATED');
4664: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4665: ' ' || to_char(p_attribute_application_id)
4666: || ' ' || p_attribute_code || ' ' ||
4667: p_value_varchar2 ||

Line 4664: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

4660: p_data => p_msg_data);
4661: WHEN FND_API.G_EXC_ERROR THEN
4662: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4663: FND_MESSAGE.SET_NAME('AK','AK_NAV_NOT_CREATED');
4664: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4665: ' ' || to_char(p_attribute_application_id)
4666: || ' ' || p_attribute_code || ' ' ||
4667: p_value_varchar2 ||
4668: to_char(p_value_date) ||

Line 4799: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_EXISTS');

4795: p_key_value9 => p_key_value9,
4796: p_key_value10 => p_key_value10
4797: ) then
4798: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4799: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_EXISTS');
4800: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
4801: FND_MSG_PUB.Add;
4802: end if;
4803: -- dbms_output.put_line(l_api_name || 'Error - Row already exists');

Line 4800: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);

4796: p_key_value10 => p_key_value10
4797: ) then
4798: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4799: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_EXISTS');
4800: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
4801: FND_MSG_PUB.Add;
4802: end if;
4803: -- dbms_output.put_line(l_api_name || 'Error - Row already exists');
4804: raise FND_API.G_EXC_ERROR;

Line 4974: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_CREATED');

4970: -- /** commit the insert **/
4971: -- commit;
4972:
4973: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4974: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_CREATED');
4975: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
4976: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4977: ' ' || to_char(p_attribute_application_id) ||
4978: ' ' || p_attribute_code ||

Line 4975: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);

4971: -- commit;
4972:
4973: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4974: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_CREATED');
4975: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
4976: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4977: ' ' || to_char(p_attribute_application_id) ||
4978: ' ' || p_attribute_code ||
4979: ' ' || p_key_value1 ||

Line 4976: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

4972:
4973: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4974: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_CREATED');
4975: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
4976: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4977: ' ' || to_char(p_attribute_application_id) ||
4978: ' ' || p_attribute_code ||
4979: ' ' || p_key_value1 ||
4980: ' ' || l_key_value2 ||

Line 5001: FND_MESSAGE.SET_NAME('AK','AK_VALUE_ERROR');

4997:
4998: EXCEPTION
4999: WHEN VALUE_ERROR THEN
5000: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5001: FND_MESSAGE.SET_NAME('AK','AK_VALUE_ERROR');
5002: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
5003: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
5004: ' ' || to_char(p_attribute_application_id) ||
5005: ' ' || p_attribute_code ||

Line 5002: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);

4998: EXCEPTION
4999: WHEN VALUE_ERROR THEN
5000: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5001: FND_MESSAGE.SET_NAME('AK','AK_VALUE_ERROR');
5002: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
5003: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
5004: ' ' || to_char(p_attribute_application_id) ||
5005: ' ' || p_attribute_code ||
5006: ' ' || p_key_value1 ||

Line 5003: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

4999: WHEN VALUE_ERROR THEN
5000: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5001: FND_MESSAGE.SET_NAME('AK','AK_VALUE_ERROR');
5002: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
5003: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
5004: ' ' || to_char(p_attribute_application_id) ||
5005: ' ' || p_attribute_code ||
5006: ' ' || p_key_value1 ||
5007: ' ' || l_key_value2 ||

Line 5025: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_CREATED');

5021: p_count => p_msg_count,
5022: p_data => p_msg_data);
5023: WHEN FND_API.G_EXC_ERROR THEN
5024: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5025: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_CREATED');
5026: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
5027: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
5028: ' ' || to_char(p_attribute_application_id) ||
5029: ' ' || p_attribute_code ||

Line 5026: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);

5022: p_data => p_msg_data);
5023: WHEN FND_API.G_EXC_ERROR THEN
5024: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5025: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_CREATED');
5026: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
5027: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
5028: ' ' || to_char(p_attribute_application_id) ||
5029: ' ' || p_attribute_code ||
5030: ' ' || p_key_value1 ||

Line 5027: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

5023: WHEN FND_API.G_EXC_ERROR THEN
5024: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5025: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_CREATED');
5026: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
5027: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
5028: ' ' || to_char(p_attribute_application_id) ||
5029: ' ' || p_attribute_code ||
5030: ' ' || p_key_value1 ||
5031: ' ' || l_key_value2 ||