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_MSG_PUB

Line 323: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

319: --** check that key columns are not null and not missing **
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;

Line 326: FND_MSG_PUB.Add;

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:
330: if ((p_attribute_application_id is null) or

Line 334: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

330: if ((p_attribute_application_id is null) or
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;

Line 337: FND_MSG_PUB.Add;

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:
341: if ((p_attribute_code is null) or

Line 345: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

341: if ((p_attribute_code is null) or
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;

Line 348: FND_MSG_PUB.Add;

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:
352: -- - Check that the parent object exists

Line 363: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

359: p_api_version_number => 1.0,
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;

Line 366: FND_MSG_PUB.Add;

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

Line 379: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

375: p_return_status => l_return_status,
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;

Line 383: FND_MSG_PUB.Add;

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!');
386: end if;
387:

Line 396: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

392: (p_data_source_type = FND_API.G_MISS_CHAR and
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;

Line 399: FND_MSG_PUB.Add;

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:
403: if ((p_required_flag is null) or

Line 408: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

404: (p_required_flag = FND_API.G_MISS_CHAR and
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;

Line 411: FND_MSG_PUB.Add;

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:
415: if ((p_attribute_label_length is null) or

Line 420: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

416: (p_attribute_label_length = FND_API.G_MISS_NUM and
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;

Line 423: FND_MSG_PUB.Add;

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:
427: if ((p_display_value_length is null) or

Line 432: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

428: (p_display_value_length = FND_API.G_MISS_NUM and
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;

Line 435: FND_MSG_PUB.Add;

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:
439: if ((p_bold is null) or

Line 443: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

439: if ((p_bold is null) or
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;

Line 446: FND_MSG_PUB.Add;

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:
450: if ((p_italic is null) or

Line 454: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

450: if ((p_italic is null) or
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;

Line 457: FND_MSG_PUB.Add;

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:
461: if ((p_vertical_alignment is null) or

Line 466: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

462: (p_vertical_alignment = FND_API.G_MISS_CHAR and
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;

Line 469: FND_MSG_PUB.Add;

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:
473: if ((p_horizontal_alignment is null) or

Line 478: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

474: (p_horizontal_alignment = FND_API.G_MISS_CHAR and
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;

Line 481: FND_MSG_PUB.Add;

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:
485: --** Validate columns **

Line 495: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

491: p_return_status => l_return_status,
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;

Line 498: FND_MSG_PUB.Add;

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

Line 512: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

508: p_return_status => l_return_status,
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;

Line 515: FND_MSG_PUB.Add;

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

Line 528: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

524: -- flag an error only during download
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;

Line 531: FND_MSG_PUB.Add;

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

Line 544: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

540: -- flag an error only during download
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;

Line 547: FND_MSG_PUB.Add;

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

Line 556: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

552: -- - required_flag
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;

Line 559: FND_MSG_PUB.Add;

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

Line 575: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

571: p_return_status => l_return_status,
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 */

Line 577: FND_MSG_PUB.Add;

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

Line 595: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

591: p_region_code => p_lov_region_code,
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;

Line 599: FND_MSG_PUB.Add;

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

Line 612: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

608: p_api_version_number => 1.0,
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;

Line 615: FND_MSG_PUB.Add;

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 */
619:

Line 624: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

620: -- - bold
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;

Line 627: FND_MSG_PUB.Add;

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

Line 636: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

632: -- - italic
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;

Line 639: FND_MSG_PUB.Add;

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

Line 652: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

648: p_column_name => p_column_name) ) then
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;

Line 656: FND_MSG_PUB.Add;

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

Line 670: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

666: p_return_status => l_return_status,
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;

Line 673: FND_MSG_PUB.Add;

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

Line 686: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

682: p_return_status => l_return_status,
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;

Line 689: FND_MSG_PUB.Add;

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

Line 704: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

700: p_return_status := FND_API.G_RET_STS_ERROR;
701: return FALSE;
702: WHEN OTHERS THEN
703: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
704: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
705: SUBSTR (SQLERRM, 1, 240) );
706: FND_MSG_PUB.Add;
707: return FALSE;
708:

Line 706: FND_MSG_PUB.Add;

702: WHEN OTHERS THEN
703: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
704: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
705: SUBSTR (SQLERRM, 1, 240) );
706: FND_MSG_PUB.Add;
707: return FALSE;
708:
709: end VALIDATE_ATTRIBUTE;
710:

Line 798: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

794: --** VALUE_NUMBER must be non-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;

Line 801: FND_MSG_PUB.Add;

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:
805: if ((p_attribute_application_id is null) or

Line 808: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

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

Line 811: FND_MSG_PUB.Add;

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:
815: if ((p_attribute_code is null) or

Line 818: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

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

Line 821: FND_MSG_PUB.Add;

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:
825: l_count := 0;

Line 840: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

836: l_count := l_count + 1;
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' ||

Line 842: FND_MSG_PUB.Add;

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');
846: end if;

Line 856: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

852: fetch l_check_objattr_csr into l_dummy;
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);

Line 861: FND_MSG_PUB.Add;

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;
863: -- dbms_output.put_line('Parent object attribute does not exist!');
864: else
865: close l_check_objattr_csr;

Line 873: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

869: close l_check_datatype_csr;
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');

Line 876: FND_MSG_PUB.Add;

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

Line 879: FND_MSG_PUB.Add;

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;
883: elsif (upper(l_data_type) = 'NUMBER') then

Line 886: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

882: end if;
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');

Line 889: FND_MSG_PUB.Add;

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

Line 892: FND_MSG_PUB.Add;

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;
896: elsif ( (upper(l_data_type) = 'DATE') or

Line 900: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

896: elsif ( (upper(l_data_type) = 'DATE') or
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');

Line 903: FND_MSG_PUB.Add;

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

Line 906: FND_MSG_PUB.Add;

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

Line 920: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

916: (p_to_region_appl_id = FND_API.G_MISS_NUM and
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;

Line 923: FND_MSG_PUB.Add;

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:
927: if ((p_to_region_code is null) or

Line 932: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

928: (p_to_region_code = FND_API.G_MISS_CHAR and
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;

Line 935: FND_MSG_PUB.Add;

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:
939: --** Validate columns **

Line 949: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

945: if (NOT valid_to_region (p_to_region_appl_id,
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 );

Line 954: FND_MSG_PUB.Add;

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 */
958:

Line 969: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

965: p_return_status := FND_API.G_RET_STS_ERROR;
966: return FALSE;
967: WHEN OTHERS THEN
968: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
969: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
970: SUBSTR (SQLERRM, 1, 240) );
971: FND_MSG_PUB.Add;
972: return FALSE;
973:

Line 971: FND_MSG_PUB.Add;

967: WHEN OTHERS THEN
968: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
969: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
970: SUBSTR (SQLERRM, 1, 240) );
971: FND_MSG_PUB.Add;
972: return FALSE;
973:
974: end VALIDATE_ATTRIBUTE_NAVIGATION;
975:

Line 1067: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1063: --** so they are not checked here
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;

Line 1070: FND_MSG_PUB.Add;

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:
1074: if ((p_attribute_application_id is null) or

Line 1077: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

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

Line 1080: FND_MSG_PUB.Add;

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:
1084: if ((p_attribute_code is null) or

Line 1087: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

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

Line 1090: FND_MSG_PUB.Add;

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:
1094: if ((p_key_value1 is null) or

Line 1097: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

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

Line 1100: FND_MSG_PUB.Add;

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:
1104: -- - Check that the parent object attribute exists and that the

Line 1112: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1108: fetch l_check_objattr_csr into l_dummy;
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);

Line 1117: FND_MSG_PUB.Add;

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;
1119: -- dbms_output.put_line('Parent object attribute does not exist!');
1120: else
1121: close l_check_objattr_csr;

Line 1131: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1127: if (p_value_varchar2 is not null) and
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;

Line 1134: FND_MSG_PUB.Add;

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

Line 1144: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1140: if (p_value_number is not null) and
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;

Line 1147: FND_MSG_PUB.Add;

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

Line 1158: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1154: (p_value_date <> FND_API.G_MISS_DATE) then
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;

Line 1161: FND_MSG_PUB.Add;

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

Line 1178: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1174: p_return_status := FND_API.G_RET_STS_ERROR;
1175: return FALSE;
1176: WHEN OTHERS THEN
1177: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1178: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1179: SUBSTR (SQLERRM, 1, 240) );
1180: FND_MSG_PUB.Add;
1181: return FALSE;
1182:

Line 1180: FND_MSG_PUB.Add;

1176: WHEN OTHERS THEN
1177: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1178: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1179: SUBSTR (SQLERRM, 1, 240) );
1180: FND_MSG_PUB.Add;
1181: return FALSE;
1182:
1183: end VALIDATE_ATTRIBUTE_VALUE;
1184:

Line 1274: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

1270: --** check that key columns are not null and not missing **
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;

Line 1277: FND_MSG_PUB.Add;

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:
1281: -- - Check that the database object name is the name of a

Line 1295: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

1291: -- flag an error only during download
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;

Line 1298: FND_MSG_PUB.Add;

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

Line 1311: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

1307: (p_application_id = FND_API.G_MISS_NUM and
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;

Line 1314: FND_MSG_PUB.Add;

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:
1318: --** Validate columns **

Line 1327: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

1323: p_api_version_number => 1.0,
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;

Line 1330: FND_MSG_PUB.Add;

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

Line 1343: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

1339: if (NOT VALID_PRIMARY_KEY_NAME (
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;

Line 1346: FND_MSG_PUB.Add;

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

Line 1361: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1357: p_return_status := FND_API.G_RET_STS_ERROR;
1358: return FALSE;
1359: WHEN OTHERS THEN
1360: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1361: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1362: SUBSTR (SQLERRM, 1, 240) );
1363: FND_MSG_PUB.Add;
1364: return FALSE;
1365:

Line 1363: FND_MSG_PUB.Add;

1359: WHEN OTHERS THEN
1360: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1361: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1362: SUBSTR (SQLERRM, 1, 240) );
1363: FND_MSG_PUB.Add;
1364: return FALSE;
1365:
1366: end VALIDATE_OBJECT;
1367:

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

1424: p_database_object_name => p_from_table(l_from_index),
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');

Line 1430: FND_MSG_PUB.Add;

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

Line 1445: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1441: WHEN FND_API.G_EXC_ERROR THEN
1442: p_return_status := FND_API.G_RET_STS_ERROR;
1443: WHEN OTHERS THEN
1444: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1445: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1446: SUBSTR (SQLERRM, 1, 240) );
1447: FND_MSG_PUB.Add;
1448: end APPEND_OBJECT_PK_TABLES;
1449:

Line 1447: FND_MSG_PUB.Add;

1443: WHEN OTHERS THEN
1444: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1445: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1446: SUBSTR (SQLERRM, 1, 240) );
1447: FND_MSG_PUB.Add;
1448: end APPEND_OBJECT_PK_TABLES;
1449:
1450: --=======================================================
1451: -- Function ATTRIBUTE_EXISTS

Line 1516: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1512: p_return_status := FND_API.G_RET_STS_ERROR;
1513: return FALSE;
1514: WHEN OTHERS THEN
1515: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1516: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1517: SUBSTR (SQLERRM, 1, 240) );
1518: FND_MSG_PUB.Add;
1519: return FALSE;
1520: end ATTRIBUTE_EXISTS;

Line 1518: FND_MSG_PUB.Add;

1514: WHEN OTHERS THEN
1515: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1516: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1517: SUBSTR (SQLERRM, 1, 240) );
1518: FND_MSG_PUB.Add;
1519: return FALSE;
1520: end ATTRIBUTE_EXISTS;
1521:
1522: --=======================================================

Line 1644: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1640: p_return_status := FND_API.G_RET_STS_ERROR;
1641: return FALSE;
1642: WHEN OTHERS THEN
1643: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1644: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1645: SUBSTR (SQLERRM, 1, 240) );
1646: FND_MSG_PUB.Add;
1647: return FALSE;
1648: end ATTRIBUTE_NAVIGATION_EXISTS;

Line 1646: FND_MSG_PUB.Add;

1642: WHEN OTHERS THEN
1643: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1644: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1645: SUBSTR (SQLERRM, 1, 240) );
1646: FND_MSG_PUB.Add;
1647: return FALSE;
1648: end ATTRIBUTE_NAVIGATION_EXISTS;
1649:
1650: --=======================================================

Line 1856: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1852: p_return_status := FND_API.G_RET_STS_ERROR;
1853: return FALSE;
1854: WHEN OTHERS THEN
1855: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1856: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1857: SUBSTR (SQLERRM, 1, 240) );
1858: FND_MSG_PUB.Add;
1859: return FALSE;
1860: end ATTRIBUTE_VALUE_EXISTS;

Line 1858: FND_MSG_PUB.Add;

1854: WHEN OTHERS THEN
1855: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1856: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1857: SUBSTR (SQLERRM, 1, 240) );
1858: FND_MSG_PUB.Add;
1859: return FALSE;
1860: end ATTRIBUTE_VALUE_EXISTS;
1861:
1862: -- CREATE comes back in here

Line 1925: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

1921: p_return_status := FND_API.G_RET_STS_ERROR;
1922: return FALSE;
1923: WHEN OTHERS THEN
1924: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1925: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
1926: SUBSTR (SQLERRM, 1, 240) );
1927: return FALSE;
1928: end OBJECT_EXISTS;
1929:

Line 2037: FND_MSG_PUB.initialize;

2033:
2034: -- Initialize the message table if requested.
2035:
2036: if p_init_msg_tbl then
2037: FND_MSG_PUB.initialize;
2038: end if;
2039:
2040: savepoint start_delete_attribute;
2041:

Line 2051: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2047: p_return_status => l_return_status,
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;

Line 2053: FND_MSG_PUB.Add;

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

Line 2071: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2067: fetch l_get_navigations_csr into l_value_varchar2, l_value_date,
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;

Line 2073: FND_MSG_PUB.Add;

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;
2077: close l_get_navigations_csr;

Line 2087: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2083: l_key_value1, l_key_value2, l_key_value3, l_key_value4, l_key_value5,
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;

Line 2091: FND_MSG_PUB.Add;

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;
2095: close l_get_attr_values_csr;

Line 2103: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2099: open l_get_region_item_csr;
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;

Line 2105: FND_MSG_PUB.Add;

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;
2109: close l_get_region_item_csr;

Line 2119: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2115: l_page_application_id, l_page_code,
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;

Line 2123: FND_MSG_PUB.Add;

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;
2127: close l_get_page_region_item_csr;

Line 2271: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2267: and attribute_application_id = p_attribute_application_id
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;

Line 2273: FND_MSG_PUB.Add;

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

Line 2284: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2280: and attribute_application_id = p_attribute_application_id
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;

Line 2286: FND_MSG_PUB.Add;

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

Line 2294: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then

2290:
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);

Line 2299: FND_MSG_PUB.Add;

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;
2301:
2302: p_return_status := FND_API.G_RET_STS_SUCCESS;
2303:

Line 2304: FND_MSG_PUB.Count_And_Get (

2300: end if;
2301:
2302: p_return_status := FND_API.G_RET_STS_SUCCESS;
2303:
2304: FND_MSG_PUB.Count_And_Get (
2305: p_count => p_msg_count,
2306: p_data => p_msg_data);
2307:
2308: EXCEPTION

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

2306: p_data => p_msg_data);
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);

Line 2315: FND_MSG_PUB.Add;

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;
2317: p_return_status := FND_API.G_RET_STS_ERROR;
2318: rollback to start_delete_attribute;
2319: FND_MSG_PUB.Count_And_Get (

Line 2319: FND_MSG_PUB.Count_And_Get (

2315: FND_MSG_PUB.Add;
2316: end if;
2317: p_return_status := FND_API.G_RET_STS_ERROR;
2318: rollback to start_delete_attribute;
2319: FND_MSG_PUB.Count_And_Get (
2320: p_count => p_msg_count,
2321: p_data => p_msg_data);
2322: WHEN OTHERS THEN
2323: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

2321: p_data => p_msg_data);
2322: WHEN OTHERS THEN
2323: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2324: rollback to start_delete_attribute;
2325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
2326: SUBSTR (SQLERRM, 1, 240) );
2327: FND_MSG_PUB.Count_And_Get (
2328: p_count => p_msg_count,
2329: p_data => p_msg_data);

Line 2327: FND_MSG_PUB.Count_And_Get (

2323: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2324: rollback to start_delete_attribute;
2325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
2326: SUBSTR (SQLERRM, 1, 240) );
2327: FND_MSG_PUB.Count_And_Get (
2328: p_count => p_msg_count,
2329: p_data => p_msg_data);
2330: end DELETE_ATTRIBUTE;
2331:

Line 2394: FND_MSG_PUB.initialize;

2390:
2391: -- Initialize the message table if requested.
2392:
2393: if p_init_msg_tbl then
2394: FND_MSG_PUB.initialize;
2395: end if;
2396:
2397: savepoint start_delete_navigation;
2398:

Line 2411: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2407: p_attribute_code => p_attribute_code,
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;

Line 2414: FND_MSG_PUB.Add;

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

Line 2468: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2464: and value_number = p_value_number;
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;

Line 2470: FND_MSG_PUB.Add;

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

Line 2478: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then

2474:
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 ||

Line 2486: FND_MSG_PUB.Add;

2482: ' ' || p_attribute_code ||
2483: ' ' || p_value_varchar2 ||
2484: to_char(p_value_date) ||
2485: to_char(p_value_number) );
2486: FND_MSG_PUB.Add;
2487: end if;
2488:
2489: p_return_status := FND_API.G_RET_STS_SUCCESS;
2490:

Line 2491: FND_MSG_PUB.Count_And_Get (

2487: end if;
2488:
2489: p_return_status := FND_API.G_RET_STS_SUCCESS;
2490:
2491: FND_MSG_PUB.Count_And_Get (
2492: p_count => p_msg_count,
2493: p_data => p_msg_data);
2494:
2495: EXCEPTION

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

2493: p_data => p_msg_data);
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)||

Line 2506: FND_MSG_PUB.Add;

2502: ' ' || p_attribute_code ||
2503: ' ' || p_value_varchar2 ||
2504: to_char(p_value_date) ||
2505: to_char(p_value_number) );
2506: FND_MSG_PUB.Add;
2507: end if;
2508: p_return_status := FND_API.G_RET_STS_ERROR;
2509: rollback to start_delete_navigation;
2510: FND_MSG_PUB.Count_And_Get (

Line 2510: FND_MSG_PUB.Count_And_Get (

2506: FND_MSG_PUB.Add;
2507: end if;
2508: p_return_status := FND_API.G_RET_STS_ERROR;
2509: rollback to start_delete_navigation;
2510: FND_MSG_PUB.Count_And_Get (
2511: p_count => p_msg_count,
2512: p_data => p_msg_data);
2513: WHEN OTHERS THEN
2514: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2516: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

2512: p_data => p_msg_data);
2513: WHEN OTHERS THEN
2514: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2515: rollback to start_delete_navigation;
2516: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
2517: SUBSTR (SQLERRM, 1, 240) );
2518: FND_MSG_PUB.Count_And_Get (
2519: p_count => p_msg_count,
2520: p_data => p_msg_data);

Line 2518: FND_MSG_PUB.Count_And_Get (

2514: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2515: rollback to start_delete_navigation;
2516: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
2517: SUBSTR (SQLERRM, 1, 240) );
2518: FND_MSG_PUB.Count_And_Get (
2519: p_count => p_msg_count,
2520: p_data => p_msg_data);
2521:
2522: end DELETE_ATTRIBUTE_NAVIGATION;

Line 2603: FND_MSG_PUB.initialize;

2599:
2600: -- Initialize the message table if requested.
2601:
2602: if p_init_msg_tbl then
2603: FND_MSG_PUB.initialize;
2604: end if;
2605:
2606: savepoint start_delete_value;
2607:

Line 2658: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2654: p_key_value7 => p_key_value7,
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;

Line 2661: FND_MSG_PUB.Add;

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

Line 2779: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2775: dbms_sql.bind_variable(l_sql_csr, 'key_value10', l_key_value10);
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;

Line 2782: FND_MSG_PUB.Add;

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

Line 2792: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then

2788: dbms_sql.close_cursor(l_sql_csr);
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) ||

Line 2808: FND_MSG_PUB.Add;

2804: ' ' || l_key_value7 ||
2805: ' ' || l_key_value8 ||
2806: ' ' || l_key_value9 ||
2807: ' ' || l_key_value10);
2808: FND_MSG_PUB.Add;
2809: end if;
2810:
2811: p_return_status := FND_API.G_RET_STS_SUCCESS;
2812:

Line 2813: FND_MSG_PUB.Count_And_Get (

2809: end if;
2810:
2811: p_return_status := FND_API.G_RET_STS_SUCCESS;
2812:
2813: FND_MSG_PUB.Count_And_Get (
2814: p_count => p_msg_count,
2815: p_data => p_msg_data);
2816:
2817: EXCEPTION

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

2815: p_data => p_msg_data);
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) ||

Line 2835: FND_MSG_PUB.Add;

2831: ' ' || l_key_value7 ||
2832: ' ' || l_key_value8 ||
2833: ' ' || l_key_value9 ||
2834: ' ' || l_key_value10);
2835: FND_MSG_PUB.Add;
2836: end if;
2837: p_return_status := FND_API.G_RET_STS_ERROR;
2838: rollback to start_delete_value;
2839: FND_MSG_PUB.Count_And_Get (

Line 2839: FND_MSG_PUB.Count_And_Get (

2835: FND_MSG_PUB.Add;
2836: end if;
2837: p_return_status := FND_API.G_RET_STS_ERROR;
2838: rollback to start_delete_value;
2839: FND_MSG_PUB.Count_And_Get (
2840: p_count => p_msg_count,
2841: p_data => p_msg_data);
2842: WHEN OTHERS THEN
2843: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2845: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

2841: p_data => p_msg_data);
2842: WHEN OTHERS THEN
2843: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2844: rollback to start_delete_value;
2845: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
2846: SUBSTR (SQLERRM, 1, 240) );
2847: FND_MSG_PUB.Count_And_Get (
2848: p_count => p_msg_count,
2849: p_data => p_msg_data);

Line 2847: FND_MSG_PUB.Count_And_Get (

2843: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2844: rollback to start_delete_value;
2845: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
2846: SUBSTR (SQLERRM, 1, 240) );
2847: FND_MSG_PUB.Count_And_Get (
2848: p_count => p_msg_count,
2849: p_data => p_msg_data);
2850:
2851: end DELETE_ATTRIBUTE_VALUE;

Line 2927: FND_MSG_PUB.initialize;

2923:
2924: -- Initialize the message table if requested.
2925:
2926: if p_init_msg_tbl then
2927: FND_MSG_PUB.initialize;
2928: end if;
2929:
2930: savepoint start_delete_object;
2931:

Line 2939: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2935: if NOT AK_OBJECT_PVT.OBJECT_EXISTS (
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;

Line 2941: FND_MSG_PUB.Add;

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

Line 2959: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2955: fetch l_get_obj_attributes_csr into
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;

Line 2961: FND_MSG_PUB.Add;

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;
2965: close l_get_obj_attributes_csr;

Line 2973: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2969: open l_get_unique_keys_csr;
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;

Line 2975: FND_MSG_PUB.Add;

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;
2979: close l_get_unique_keys_csr;

Line 2987: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2983: open l_get_foreign_keys_csr;
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;

Line 2989: FND_MSG_PUB.Add;

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;
2993: close l_get_foreign_keys_csr;

Line 3001: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2997: open l_get_regions_csr;
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;

Line 3003: FND_MSG_PUB.Add;

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;
3007: close l_get_regions_csr;

Line 3121: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

3117: delete from ak_objects
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;

Line 3123: FND_MSG_PUB.Add;

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

Line 3131: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then

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

Line 3134: FND_MSG_PUB.Add;

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

Line 3139: FND_MSG_PUB.Count_And_Get (

3135: end if;
3136:
3137: p_return_status := FND_API.G_RET_STS_SUCCESS;
3138:
3139: FND_MSG_PUB.Count_And_Get (
3140: p_count => p_msg_count,
3141: p_data => p_msg_data);
3142:
3143: EXCEPTION

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

3141: p_data => p_msg_data);
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;

Line 3148: FND_MSG_PUB.Add;

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;
3152: FND_MSG_PUB.Count_And_Get (

Line 3152: FND_MSG_PUB.Count_And_Get (

3148: FND_MSG_PUB.Add;
3149: end if;
3150: p_return_status := FND_API.G_RET_STS_ERROR;
3151: rollback to start_delete_object;
3152: FND_MSG_PUB.Count_And_Get (
3153: p_count => p_msg_count,
3154: p_data => p_msg_data);
3155: WHEN OTHERS THEN
3156: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3158: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

3154: p_data => p_msg_data);
3155: WHEN OTHERS THEN
3156: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3157: rollback to start_delete_object;
3158: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3159: SUBSTR (SQLERRM, 1, 240) );
3160: FND_MSG_PUB.Count_And_Get (
3161: p_count => p_msg_count,
3162: p_data => p_msg_data);

Line 3160: FND_MSG_PUB.Count_And_Get (

3156: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3157: rollback to start_delete_object;
3158: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3159: SUBSTR (SQLERRM, 1, 240) );
3160: FND_MSG_PUB.Count_And_Get (
3161: p_count => p_msg_count,
3162: p_data => p_msg_data);
3163:
3164: end DELETE_OBJECT;

Line 3226: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

3222: WHEN FND_API.G_EXC_ERROR THEN
3223: p_return_status := FND_API.G_RET_STS_ERROR;
3224: WHEN OTHERS THEN
3225: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3226: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3227: SUBSTR (SQLERRM, 1, 240) );
3228: FND_MSG_PUB.Add;
3229: end INSERT_OBJECT_PK_TABLE;
3230:

Line 3228: FND_MSG_PUB.Add;

3224: WHEN OTHERS THEN
3225: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3226: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3227: SUBSTR (SQLERRM, 1, 240) );
3228: FND_MSG_PUB.Add;
3229: end INSERT_OBJECT_PK_TABLE;
3230:
3231: --=======================================================
3232: -- Procedure CREATE_OBJECT

Line 3341: FND_MSG_PUB.initialize;

3337:
3338: -- Initialize the message table if requested.
3339:
3340: if p_init_msg_tbl then
3341: FND_MSG_PUB.initialize;
3342: end if;
3343:
3344: savepoint start_create_object;
3345:

Line 3351: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

3347: if (AK_OBJECT_PVT.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');

Line 3353: FND_MSG_PUB.Add;

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

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

3583: if (NOT AK_OBJECT_PVT.OBJECT_EXISTS (
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;

Line 3589: FND_MSG_PUB.Add;

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

Line 3624: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

3620: from AK_OBJECTS_TL T
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;

Line 3627: FND_MSG_PUB.Add;

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

Line 3632: FND_MSG_PUB.Count_And_Get (

3628: end if;
3629:
3630: p_return_status := FND_API.G_RET_STS_SUCCESS;
3631:
3632: FND_MSG_PUB.Count_And_Get (
3633: p_count => p_msg_count,
3634: p_data => p_msg_data);
3635:
3636: EXCEPTION

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

3634: p_data => p_msg_data);
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;

Line 3641: FND_MSG_PUB.Add;

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;
3645: FND_MSG_PUB.Count_And_Get (

Line 3645: FND_MSG_PUB.Count_And_Get (

3641: FND_MSG_PUB.Add;
3642: end if;
3643: rollback to start_create_object;
3644: p_return_status := FND_API.G_RET_STS_ERROR;
3645: FND_MSG_PUB.Count_And_Get (
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

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

3645: FND_MSG_PUB.Count_And_Get (
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;

Line 3652: FND_MSG_PUB.Add;

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;
3656: FND_MSG_PUB.Count_And_Get (

Line 3656: FND_MSG_PUB.Count_And_Get (

3652: FND_MSG_PUB.Add;
3653: end if;
3654: p_return_status := FND_API.G_RET_STS_ERROR;
3655: rollback to start_create_object;
3656: FND_MSG_PUB.Count_And_Get (
3657: p_count => p_msg_count,
3658: p_data => p_msg_data);
3659: WHEN OTHERS THEN
3660: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3662: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

3658: p_data => p_msg_data);
3659: WHEN OTHERS THEN
3660: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3661: rollback to start_create_object;
3662: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3663: SUBSTR (SQLERRM, 1, 240) );
3664: FND_MSG_PUB.Count_And_Get (
3665: p_count => p_msg_count,
3666: p_data => p_msg_data);

Line 3664: FND_MSG_PUB.Count_And_Get (

3660: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3661: rollback to start_create_object;
3662: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
3663: SUBSTR (SQLERRM, 1, 240) );
3664: FND_MSG_PUB.Count_And_Get (
3665: p_count => p_msg_count,
3666: p_data => p_msg_data);
3667: end CREATE_OBJECT;
3668:

Line 3811: FND_MSG_PUB.initialize;

3807:
3808: -- Initialize the message table if requested.
3809:
3810: if p_init_msg_tbl then
3811: FND_MSG_PUB.initialize;
3812: end if;
3813:
3814: savepoint start_create_attribute;
3815:

Line 3823: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

3819: p_return_status => l_return_status,
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 ||

Line 3825: FND_MSG_PUB.Add;

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) ||
3829: -- ' ' || p_attribute_code );

Line 4181: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

4177: p_return_status => l_return_status,
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');

Line 4183: FND_MSG_PUB.Add;

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

Line 4228: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

4224:
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);

Line 4233: FND_MSG_PUB.Add;

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;
4235:
4236: p_return_status := FND_API.G_RET_STS_SUCCESS;
4237:

Line 4238: FND_MSG_PUB.Count_And_Get (

4234: end if;
4235:
4236: p_return_status := FND_API.G_RET_STS_SUCCESS;
4237:
4238: FND_MSG_PUB.Count_And_Get (
4239: p_count => p_msg_count,
4240: p_data => p_msg_data);
4241:
4242: EXCEPTION

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

4240: p_data => p_msg_data);
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 );

Line 4249: FND_MSG_PUB.Add;

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;
4251: rollback to start_create_attribute;
4252: p_return_status := FND_API.G_RET_STS_ERROR;
4253: FND_MSG_PUB.Count_And_Get (

Line 4253: FND_MSG_PUB.Count_And_Get (

4249: FND_MSG_PUB.Add;
4250: end if;
4251: rollback to start_create_attribute;
4252: p_return_status := FND_API.G_RET_STS_ERROR;
4253: FND_MSG_PUB.Count_And_Get (
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

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

4253: FND_MSG_PUB.Count_And_Get (
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);

Line 4262: FND_MSG_PUB.Add;

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;
4264: -- dbms_output.put_line('OA Key: '||p_database_object_name ||
4265: -- ' ' || to_char(p_attribute_application_id) ||
4266: -- ' ' || p_attribute_code );

Line 4269: FND_MSG_PUB.Count_And_Get (

4265: -- ' ' || to_char(p_attribute_application_id) ||
4266: -- ' ' || p_attribute_code );
4267: p_return_status := FND_API.G_RET_STS_ERROR;
4268: rollback to start_create_attribute;
4269: FND_MSG_PUB.Count_And_Get (
4270: p_count => p_msg_count,
4271: p_data => p_msg_data);
4272: WHEN OTHERS THEN
4273: --dbms_output.put_line('OA Key: '||p_database_object_name ||

Line 4278: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

4274: -- ' ' || to_char(p_attribute_application_id) ||
4275: -- ' ' || p_attribute_code );
4276: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4277: rollback to start_create_attribute;
4278: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
4279: SUBSTR (SQLERRM, 1, 240) );
4280: FND_MSG_PUB.Count_And_Get (
4281: p_count => p_msg_count,
4282: p_data => p_msg_data);

Line 4280: FND_MSG_PUB.Count_And_Get (

4276: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4277: rollback to start_create_attribute;
4278: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
4279: SUBSTR (SQLERRM, 1, 240) );
4280: FND_MSG_PUB.Count_And_Get (
4281: p_count => p_msg_count,
4282: p_data => p_msg_data);
4283: end CREATE_ATTRIBUTE;
4284:

Line 4389: FND_MSG_PUB.initialize;

4385:
4386: -- Initialize the message table if requested.
4387:
4388: if p_init_msg_tbl then
4389: FND_MSG_PUB.initialize;
4390: end if;
4391:
4392: savepoint start_create_navigation;
4393:

Line 4406: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

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

Line 4408: FND_MSG_PUB.Add;

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

Line 4424: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

4420: p_attribute_code => p_attribute_code,
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;

Line 4426: FND_MSG_PUB.Add;

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

Line 4627: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

4623:
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 || ' ' ||

Line 4635: FND_MSG_PUB.Add;

4631: ' ' || p_attribute_code || ' ' ||
4632: p_value_varchar2 ||
4633: to_char(p_value_date) ||
4634: to_char(p_value_number) );
4635: FND_MSG_PUB.Add;
4636: end if;
4637:
4638: p_return_status := FND_API.G_RET_STS_SUCCESS;
4639:

Line 4640: FND_MSG_PUB.Count_And_Get (

4636: end if;
4637:
4638: p_return_status := FND_API.G_RET_STS_SUCCESS;
4639:
4640: FND_MSG_PUB.Count_And_Get (
4641: p_count => p_msg_count,
4642: p_data => p_msg_data);
4643:
4644: EXCEPTION

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

4642: p_data => p_msg_data);
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 || ' ' ||

Line 4654: FND_MSG_PUB.Add;

4650: || ' ' || p_attribute_code || ' ' ||
4651: p_value_varchar2 ||
4652: to_char(p_value_date) ||
4653: to_char(p_value_number) );
4654: FND_MSG_PUB.Add;
4655: end if;
4656: rollback to start_create_navigation;
4657: p_return_status := FND_API.G_RET_STS_ERROR;
4658: FND_MSG_PUB.Count_And_Get (

Line 4658: FND_MSG_PUB.Count_And_Get (

4654: FND_MSG_PUB.Add;
4655: end if;
4656: rollback to start_create_navigation;
4657: p_return_status := FND_API.G_RET_STS_ERROR;
4658: FND_MSG_PUB.Count_And_Get (
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

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

4658: FND_MSG_PUB.Count_And_Get (
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 || ' ' ||

Line 4670: FND_MSG_PUB.Add;

4666: || ' ' || p_attribute_code || ' ' ||
4667: p_value_varchar2 ||
4668: to_char(p_value_date) ||
4669: to_char(p_value_number) );
4670: FND_MSG_PUB.Add;
4671: end if;
4672: p_return_status := FND_API.G_RET_STS_ERROR;
4673: rollback to start_create_navigation;
4674: FND_MSG_PUB.Count_And_Get (

Line 4674: FND_MSG_PUB.Count_And_Get (

4670: FND_MSG_PUB.Add;
4671: end if;
4672: p_return_status := FND_API.G_RET_STS_ERROR;
4673: rollback to start_create_navigation;
4674: FND_MSG_PUB.Count_And_Get (
4675: p_count => p_msg_count,
4676: p_data => p_msg_data);
4677: WHEN OTHERS THEN
4678: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4680: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

4676: p_data => p_msg_data);
4677: WHEN OTHERS THEN
4678: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4679: rollback to start_create_navigation;
4680: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
4681: SUBSTR (SQLERRM, 1, 240) );
4682: FND_MSG_PUB.Count_And_Get (
4683: p_count => p_msg_count,
4684: p_data => p_msg_data);

Line 4682: FND_MSG_PUB.Count_And_Get (

4678: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4679: rollback to start_create_navigation;
4680: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
4681: SUBSTR (SQLERRM, 1, 240) );
4682: FND_MSG_PUB.Count_And_Get (
4683: p_count => p_msg_count,
4684: p_data => p_msg_data);
4685: end CREATE_ATTRIBUTE_NAVIGATION;
4686:

Line 4775: FND_MSG_PUB.initialize;

4771:
4772: -- Initialize the message table if requested.
4773:
4774: if p_init_msg_tbl then
4775: FND_MSG_PUB.initialize;
4776: end if;
4777:
4778: savepoint start_create_value;
4779:

Line 4798: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

4794: p_key_value8 => p_key_value8,
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;

Line 4801: FND_MSG_PUB.Add;

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

Line 4973: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

4969:
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) ||

Line 4989: FND_MSG_PUB.Add;

4985: ' ' || l_key_value7 ||
4986: ' ' || l_key_value8 ||
4987: ' ' || l_key_value9 ||
4988: ' ' || l_key_value10);
4989: FND_MSG_PUB.Add;
4990: end if;
4991:
4992: p_return_status := FND_API.G_RET_STS_SUCCESS;
4993:

Line 4994: FND_MSG_PUB.Count_And_Get (

4990: end if;
4991:
4992: p_return_status := FND_API.G_RET_STS_SUCCESS;
4993:
4994: FND_MSG_PUB.Count_And_Get (
4995: p_count => p_msg_count,
4996: p_data => p_msg_data);
4997:
4998: EXCEPTION

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

4996: p_data => p_msg_data);
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) ||

Line 5016: FND_MSG_PUB.Add;

5012: ' ' || l_key_value7 ||
5013: ' ' || l_key_value8 ||
5014: ' ' || l_key_value9 ||
5015: ' ' || l_key_value10);
5016: FND_MSG_PUB.Add;
5017: end if;
5018: p_return_status := FND_API.G_RET_STS_ERROR;
5019: rollback to start_create_value;
5020: FND_MSG_PUB.Count_And_Get (

Line 5020: FND_MSG_PUB.Count_And_Get (

5016: FND_MSG_PUB.Add;
5017: end if;
5018: p_return_status := FND_API.G_RET_STS_ERROR;
5019: rollback to start_create_value;
5020: FND_MSG_PUB.Count_And_Get (
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

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

5020: FND_MSG_PUB.Count_And_Get (
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) ||

Line 5040: FND_MSG_PUB.Add;

5036: ' ' || l_key_value7 ||
5037: ' ' || l_key_value8 ||
5038: ' ' || l_key_value9 ||
5039: ' ' || l_key_value10);
5040: FND_MSG_PUB.Add;
5041: end if;
5042: p_return_status := FND_API.G_RET_STS_ERROR;
5043: rollback to start_create_value;
5044: FND_MSG_PUB.Count_And_Get (

Line 5044: FND_MSG_PUB.Count_And_Get (

5040: FND_MSG_PUB.Add;
5041: end if;
5042: p_return_status := FND_API.G_RET_STS_ERROR;
5043: rollback to start_create_value;
5044: FND_MSG_PUB.Count_And_Get (
5045: p_count => p_msg_count,
5046: p_data => p_msg_data);
5047: WHEN OTHERS THEN
5048: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5050: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

5046: p_data => p_msg_data);
5047: WHEN OTHERS THEN
5048: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5049: rollback to start_create_value;
5050: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
5051: SUBSTR (SQLERRM, 1, 240) );
5052: FND_MSG_PUB.Count_And_Get (
5053: p_count => p_msg_count,
5054: p_data => p_msg_data);

Line 5052: FND_MSG_PUB.Count_And_Get (

5048: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5049: rollback to start_create_value;
5050: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
5051: SUBSTR (SQLERRM, 1, 240) );
5052: FND_MSG_PUB.Count_And_Get (
5053: p_count => p_msg_count,
5054: p_data => p_msg_data);
5055: end CREATE_ATTRIBUTE_VALUE;
5056: