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

APPS.AK_OBJECT_PVT dependencies on FND_MESSAGE

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

327: if ((p_database_object_name is null) or
328: (p_database_object_name = FND_API.G_MISS_CHAR)) then
329: l_error := TRUE;
330: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
331: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
332: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
333: FND_MSG_PUB.Add;
334: end if;
335: end if;

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

328: (p_database_object_name = FND_API.G_MISS_CHAR)) then
329: l_error := TRUE;
330: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
331: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
332: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
333: FND_MSG_PUB.Add;
334: end if;
335: end if;
336:

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

338: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
339: l_error := TRUE;
340: -- dbms_output.put_line('Attribute Application ID cannot be null');
341: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
342: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
343: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
344: FND_MSG_PUB.Add;
345: end if;
346: end if;

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

339: l_error := TRUE;
340: -- dbms_output.put_line('Attribute Application ID cannot be null');
341: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
342: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
343: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
344: FND_MSG_PUB.Add;
345: end if;
346: end if;
347:

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

349: (p_attribute_code = FND_API.G_MISS_CHAR)) then
350: l_error := TRUE;
351: -- dbms_output.put_line('Attribute Code cannot be null');
352: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
353: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
354: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
355: FND_MSG_PUB.Add;
356: end if;
357: end if;

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

350: l_error := TRUE;
351: -- dbms_output.put_line('Attribute Code cannot be null');
352: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
353: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
354: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
355: FND_MSG_PUB.Add;
356: end if;
357: end if;
358:

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

367: p_return_status => l_return_status,
368: p_database_object_name => p_database_object_name)) then
369: l_error := TRUE;
370: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
371: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OBJECT_REFERENCE');
372: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
373: FND_MSG_PUB.Add;
374: end if;
375: -- dbms_output.put_line('Parent object does not exist!');

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

368: p_database_object_name => p_database_object_name)) then
369: l_error := TRUE;
370: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
371: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OBJECT_REFERENCE');
372: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
373: FND_MSG_PUB.Add;
374: end if;
375: -- dbms_output.put_line('Parent object does not exist!');
376: end if;

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

383: p_attribute_application_id => p_attribute_application_id,
384: p_attribute_code => p_attribute_code) ) then
385: l_error := TRUE;
386: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
387: FND_MESSAGE.SET_NAME('AK','AK_INVALID_ATTR_REFERENCE');
388: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_attribute_application_id) ||
389: ' ' || p_attribute_code);
390: FND_MSG_PUB.Add;
391: end if;

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

384: p_attribute_code => p_attribute_code) ) then
385: l_error := TRUE;
386: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
387: FND_MESSAGE.SET_NAME('AK','AK_INVALID_ATTR_REFERENCE');
388: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_attribute_application_id) ||
389: ' ' || p_attribute_code);
390: FND_MSG_PUB.Add;
391: end if;
392: -- dbms_output.put_line('Attribute referenced does not exist!');

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

400: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
401: then
402: l_error := TRUE;
403: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
404: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
405: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATA_SOURCE_TYPE');
406: FND_MSG_PUB.Add;
407: end if;
408: end if;

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

401: then
402: l_error := TRUE;
403: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
404: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
405: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATA_SOURCE_TYPE');
406: FND_MSG_PUB.Add;
407: end if;
408: end if;
409:

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

412: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
413: then
414: l_error := TRUE;
415: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
416: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
417: FND_MESSAGE.SET_TOKEN('COLUMN', 'REQUIRED_FLAG');
418: FND_MSG_PUB.Add;
419: end if;
420: end if;

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

413: then
414: l_error := TRUE;
415: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
416: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
417: FND_MESSAGE.SET_TOKEN('COLUMN', 'REQUIRED_FLAG');
418: FND_MSG_PUB.Add;
419: end if;
420: end if;
421:

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

424: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
425: then
426: l_error := TRUE;
427: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
428: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
429: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_LABEL_LENGTH');
430: FND_MSG_PUB.Add;
431: end if;
432: end if;

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

425: then
426: l_error := TRUE;
427: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
428: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
429: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_LABEL_LENGTH');
430: FND_MSG_PUB.Add;
431: end if;
432: end if;
433:

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

436: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
437: then
438: l_error := TRUE;
439: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
440: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
441: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPLAY_VALUE_LENGTH');
442: FND_MSG_PUB.Add;
443: end if;
444: end if;

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

437: then
438: l_error := TRUE;
439: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
440: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
441: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPLAY_VALUE_LENGTH');
442: FND_MSG_PUB.Add;
443: end if;
444: end if;
445:

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

447: (p_bold = FND_API.G_MISS_CHAR and
448: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
449: l_error := TRUE;
450: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
451: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
452: FND_MESSAGE.SET_TOKEN('COLUMN', 'BOLD');
453: FND_MSG_PUB.Add;
454: end if;
455: end if;

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

448: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
449: l_error := TRUE;
450: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
451: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
452: FND_MESSAGE.SET_TOKEN('COLUMN', 'BOLD');
453: FND_MSG_PUB.Add;
454: end if;
455: end if;
456:

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

458: (p_italic = FND_API.G_MISS_CHAR and
459: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
460: l_error := TRUE;
461: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
462: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
463: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITALIC');
464: FND_MSG_PUB.Add;
465: end if;
466: end if;

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

459: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
460: l_error := TRUE;
461: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
462: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
463: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITALIC');
464: FND_MSG_PUB.Add;
465: end if;
466: end if;
467:

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

470: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
471: then
472: l_error := TRUE;
473: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
474: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
475: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERTICAL_ALIGNMENT');
476: FND_MSG_PUB.Add;
477: end if;
478: end if;

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

471: then
472: l_error := TRUE;
473: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
474: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
475: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERTICAL_ALIGNMENT');
476: FND_MSG_PUB.Add;
477: end if;
478: end if;
479:

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

482: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
483: then
484: l_error := TRUE;
485: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
486: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
487: FND_MESSAGE.SET_TOKEN('COLUMN', 'HORIZONTAL_ALIGNMENT');
488: FND_MSG_PUB.Add;
489: end if;
490: end if;

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

483: then
484: l_error := TRUE;
485: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
486: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
487: FND_MESSAGE.SET_TOKEN('COLUMN', 'HORIZONTAL_ALIGNMENT');
488: FND_MSG_PUB.Add;
489: end if;
490: end if;
491:

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

499: p_lookup_type => 'DATA_SOURCE_TYPE',
500: p_lookup_code => p_data_source_type)) then
501: l_error := TRUE;
502: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
503: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
504: FND_MESSAGE.SET_TOKEN('COLUMN','DATA_SOURCE_TYPE');
505: FND_MSG_PUB.Add;
506: end if;
507: end if;

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

500: p_lookup_code => p_data_source_type)) then
501: l_error := TRUE;
502: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
503: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
504: FND_MESSAGE.SET_TOKEN('COLUMN','DATA_SOURCE_TYPE');
505: FND_MSG_PUB.Add;
506: end if;
507: end if;
508: end if;

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

516: p_lookup_type => 'DATA_STORAGE_TYPE',
517: p_lookup_code => p_data_storage_type)) then
518: l_error := TRUE;
519: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
520: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
521: FND_MESSAGE.SET_TOKEN('COLUMN','DATA_STORAGE_TYPE');
522: FND_MSG_PUB.Add;
523: end if;
524: end if;

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

517: p_lookup_code => p_data_storage_type)) then
518: l_error := TRUE;
519: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
520: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
521: FND_MESSAGE.SET_TOKEN('COLUMN','DATA_STORAGE_TYPE');
522: FND_MSG_PUB.Add;
523: end if;
524: end if;
525: end if;

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

532: if ( AK_ON_OBJECTS_PUB.G_LOAD_MODE = 'DOWNLOAD' or p_pass = 1) then
533: l_error := TRUE;
534: end if;
535: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
536: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
537: FND_MESSAGE.SET_TOKEN('COLUMN','TABLE_NAME');
538: FND_MSG_PUB.Add;
539: end if;
540: end if;

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

533: l_error := TRUE;
534: end if;
535: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
536: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
537: FND_MESSAGE.SET_TOKEN('COLUMN','TABLE_NAME');
538: FND_MSG_PUB.Add;
539: end if;
540: end if;
541: end if;

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

548: if ( AK_ON_OBJECTS_PUB.G_LOAD_MODE = 'DOWNLOAD' or p_pass = 1 ) then
549: l_error := TRUE;
550: end if;
551: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
552: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
553: FND_MESSAGE.SET_TOKEN('COLUMN','BASE_TABLE_COLUMN_NAME');
554: FND_MSG_PUB.Add;
555: end if;
556: end if;

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

549: l_error := TRUE;
550: end if;
551: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
552: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
553: FND_MESSAGE.SET_TOKEN('COLUMN','BASE_TABLE_COLUMN_NAME');
554: FND_MSG_PUB.Add;
555: end if;
556: end if;
557: end if;

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

560: if (p_required_flag <> FND_API.G_MISS_CHAR) then
561: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_required_flag)) then
562: l_error := TRUE;
563: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
564: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
565: FND_MESSAGE.SET_TOKEN('COLUMN','REQUIRED_FLAG');
566: FND_MSG_PUB.Add;
567: end if;
568: end if;

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

561: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_required_flag)) then
562: l_error := TRUE;
563: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
564: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
565: FND_MESSAGE.SET_TOKEN('COLUMN','REQUIRED_FLAG');
566: FND_MSG_PUB.Add;
567: end if;
568: end if;
569: end if;

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

579: p_region_application_id => p_lov_region_application_id,
580: p_region_code => p_lov_region_code)) then
581: l_error := TRUE;
582: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
583: FND_MESSAGE.SET_NAME('AK','AK_LOV_REG_DOES_NOT_EXIST');
584: FND_MSG_PUB.Add;
585: end if;
586: end if; /* if REGION_EXISTS */
587: end if;

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

599: p_attribute_application_id => p_lov_attribute_application_id,
600: p_attribute_code => p_lov_attribute_code)) then
601: l_error := TRUE;
602: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
603: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_ITEM_REFERENCE');
604: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_attribute_application_id) ||
605: ' ' || p_lov_attribute_code);
606: FND_MSG_PUB.Add;
607: end if;

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

600: p_attribute_code => p_lov_attribute_code)) then
601: l_error := TRUE;
602: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
603: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_ITEM_REFERENCE');
604: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_attribute_application_id) ||
605: ' ' || p_lov_attribute_code);
606: FND_MSG_PUB.Add;
607: end if;
608: end if;

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

616: p_return_status => l_return_status,
617: p_foreign_key_name => p_lov_foreign_key_name)) then
618: l_error := TRUE;
619: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
620: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_FK_REFERENCE');
621: FND_MESSAGE.SET_TOKEN('KEY', p_lov_foreign_key_name);
622: FND_MSG_PUB.Add;
623: end if;
624: end if;

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

617: p_foreign_key_name => p_lov_foreign_key_name)) then
618: l_error := TRUE;
619: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
620: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_FK_REFERENCE');
621: FND_MESSAGE.SET_TOKEN('KEY', p_lov_foreign_key_name);
622: FND_MSG_PUB.Add;
623: end if;
624: end if;
625: end if; /* if p_lov_foreign_key_name */

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

628: if (p_bold <> FND_API.G_MISS_CHAR) then
629: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_bold)) then
630: l_error := TRUE;
631: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
632: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
633: FND_MESSAGE.SET_TOKEN('COLUMN','BOLD');
634: FND_MSG_PUB.Add;
635: end if;
636: end if;

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

629: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_bold)) then
630: l_error := TRUE;
631: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
632: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
633: FND_MESSAGE.SET_TOKEN('COLUMN','BOLD');
634: FND_MSG_PUB.Add;
635: end if;
636: end if;
637: end if;

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

640: if (p_italic <> FND_API.G_MISS_CHAR) then
641: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_italic)) then
642: l_error := TRUE;
643: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
644: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
645: FND_MESSAGE.SET_TOKEN('COLUMN','ITALIC');
646: FND_MSG_PUB.Add;
647: end if;
648: end if;

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

641: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_italic)) then
642: l_error := TRUE;
643: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
644: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
645: FND_MESSAGE.SET_TOKEN('COLUMN','ITALIC');
646: FND_MSG_PUB.Add;
647: end if;
648: end if;
649: end if;

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

656: if ( AK_ON_OBJECTS_PUB.G_LOAD_MODE = 'DOWNLOAD' or p_pass = 1 ) then
657: l_error := TRUE;
658: end if;
659: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
660: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN');
661: FND_MESSAGE.SET_TOKEN('COLUMN',p_column_name);
662: FND_MESSAGE.SET_TOKEN('OBJECT',p_database_object_name);
663: FND_MSG_PUB.Add;
664: end if;

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

657: l_error := TRUE;
658: end if;
659: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
660: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN');
661: FND_MESSAGE.SET_TOKEN('COLUMN',p_column_name);
662: FND_MESSAGE.SET_TOKEN('OBJECT',p_database_object_name);
663: FND_MSG_PUB.Add;
664: end if;
665: -- dbms_output.put_line('Column name not in this database object');

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

658: end if;
659: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
660: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN');
661: FND_MESSAGE.SET_TOKEN('COLUMN',p_column_name);
662: FND_MESSAGE.SET_TOKEN('OBJECT',p_database_object_name);
663: FND_MSG_PUB.Add;
664: end if;
665: -- dbms_output.put_line('Column name not in this database object');
666: end if;

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

674: p_lookup_type => 'VERTICAL_ALIGNMENT',
675: p_lookup_code => p_vertical_alignment)) then
676: l_error := TRUE;
677: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
678: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
679: FND_MESSAGE.SET_TOKEN('COLUMN','VERTICAL_ALIGNMENT');
680: FND_MSG_PUB.Add;
681: end if;
682: end if;

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

675: p_lookup_code => p_vertical_alignment)) then
676: l_error := TRUE;
677: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
678: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
679: FND_MESSAGE.SET_TOKEN('COLUMN','VERTICAL_ALIGNMENT');
680: FND_MSG_PUB.Add;
681: end if;
682: end if;
683: end if;

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

690: p_lookup_type => 'HORIZONTAL_ALIGNMENT',
691: p_lookup_code => p_horizontal_alignment)) then
692: l_error := TRUE;
693: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
694: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
695: FND_MESSAGE.SET_TOKEN('COLUMN','HORIZONTAL_ALIGNMENT');
696: FND_MSG_PUB.Add;
697: end if;
698: end if;

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

691: p_lookup_code => p_horizontal_alignment)) then
692: l_error := TRUE;
693: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
694: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
695: FND_MESSAGE.SET_TOKEN('COLUMN','HORIZONTAL_ALIGNMENT');
696: FND_MSG_PUB.Add;
697: end if;
698: end if;
699: end if;

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

802: if ((p_database_object_name is null) or
803: (p_database_object_name = FND_API.G_MISS_CHAR)) then
804: l_error := TRUE;
805: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
806: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
807: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
808: FND_MSG_PUB.Add;
809: end if;
810: end if;

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

803: (p_database_object_name = FND_API.G_MISS_CHAR)) then
804: l_error := TRUE;
805: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
806: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
807: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
808: FND_MSG_PUB.Add;
809: end if;
810: end if;
811:

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

812: if ((p_attribute_application_id is null) or
813: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
814: l_error := TRUE;
815: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
816: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
817: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
818: FND_MSG_PUB.Add;
819: end if;
820: end if;

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

813: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
814: l_error := TRUE;
815: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
816: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
817: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
818: FND_MSG_PUB.Add;
819: end if;
820: end if;
821:

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

822: if ((p_attribute_code is null) or
823: (p_attribute_code = FND_API.G_MISS_CHAR)) then
824: l_error := TRUE;
825: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
826: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
827: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
828: FND_MSG_PUB.Add;
829: end if;
830: end if;

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

823: (p_attribute_code = FND_API.G_MISS_CHAR)) then
824: l_error := TRUE;
825: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
826: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
827: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
828: FND_MSG_PUB.Add;
829: end if;
830: end if;
831:

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

844: end if;
845: if (l_count <> 1) then
846: l_error := TRUE;
847: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
848: FND_MESSAGE.SET_NAME('AK','AK_ONE_VALUE_ONLY');
849: FND_MSG_PUB.Add;
850: end if;
851: -- dbms_output.put_line('One and only one of value_vachar2, value_number' ||
852: -- ' and value_date must be non-null');

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

860: if (l_check_objattr_csr%notfound) then
861: close l_check_objattr_csr;
862: l_error := TRUE;
863: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
864: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OA_REFERENCE');
865: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
866: ' ' || to_char(p_attribute_application_id) ||
867: ' ' || p_attribute_code);
868: FND_MSG_PUB.Add;

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

861: close l_check_objattr_csr;
862: l_error := TRUE;
863: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
864: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OA_REFERENCE');
865: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
866: ' ' || to_char(p_attribute_application_id) ||
867: ' ' || p_attribute_code);
868: FND_MSG_PUB.Add;
869: end if;

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

877: if (upper(l_data_type) = 'VARCHAR2') then
878: if (p_value_date is not null) or (p_value_number is not null) then
879: l_error := TRUE;
880: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
881: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
882: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
883: FND_MSG_PUB.Add;
884: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
885: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');

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

878: if (p_value_date is not null) or (p_value_number is not null) then
879: l_error := TRUE;
880: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
881: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
882: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
883: FND_MSG_PUB.Add;
884: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
885: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');
886: FND_MSG_PUB.Add;

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

880: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
881: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
882: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
883: FND_MSG_PUB.Add;
884: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
885: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');
886: FND_MSG_PUB.Add;
887: end if;
888: -- dbms_output.put_line('value_date and value_number must be null');

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

881: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
882: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
883: FND_MSG_PUB.Add;
884: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
885: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');
886: FND_MSG_PUB.Add;
887: end if;
888: -- dbms_output.put_line('value_date and value_number must be null');
889: end if;

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

890: elsif (upper(l_data_type) = 'NUMBER') then
891: if (p_value_date is not null) or (p_value_varchar2 is not null) then
892: l_error := TRUE;
893: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
894: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
895: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
896: FND_MSG_PUB.Add;
897: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
898: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');

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

891: if (p_value_date is not null) or (p_value_varchar2 is not null) then
892: l_error := TRUE;
893: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
894: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
895: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
896: FND_MSG_PUB.Add;
897: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
898: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');
899: FND_MSG_PUB.Add;

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

893: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
894: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
895: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
896: FND_MSG_PUB.Add;
897: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
898: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');
899: FND_MSG_PUB.Add;
900: end if;
901: -- dbms_output.put_line('value_date and value_varchar2 must be null');

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

894: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
895: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
896: FND_MSG_PUB.Add;
897: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
898: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');
899: FND_MSG_PUB.Add;
900: end if;
901: -- dbms_output.put_line('value_date and value_varchar2 must be null');
902: end if;

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

904: (upper(l_data_type) = 'DATETIME') )then
905: if (p_value_number is not null) or (p_value_varchar2 is not null) then
906: l_error := TRUE;
907: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
908: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
909: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');
910: FND_MSG_PUB.Add;
911: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
912: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');

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

905: if (p_value_number is not null) or (p_value_varchar2 is not null) then
906: l_error := TRUE;
907: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
908: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
909: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');
910: FND_MSG_PUB.Add;
911: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
912: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');
913: FND_MSG_PUB.Add;

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

907: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
908: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
909: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');
910: FND_MSG_PUB.Add;
911: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
912: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');
913: FND_MSG_PUB.Add;
914: end if;
915: -- dbms_output.put_line('value_number and value_varchar2 must be null');

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

908: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
909: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');
910: FND_MSG_PUB.Add;
911: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
912: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');
913: FND_MSG_PUB.Add;
914: end if;
915: -- dbms_output.put_line('value_number and value_varchar2 must be null');
916: end if;

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

924: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
925: then
926: l_error := TRUE;
927: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
928: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
929: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_REGION_APPL_ID');
930: FND_MSG_PUB.Add;
931: end if;
932: end if;

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

925: then
926: l_error := TRUE;
927: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
928: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
929: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_REGION_APPL_ID');
930: FND_MSG_PUB.Add;
931: end if;
932: end if;
933:

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

936: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
937: then
938: l_error := TRUE;
939: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
940: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
941: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_REGION_CODE');
942: FND_MSG_PUB.Add;
943: end if;
944: end if;

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

937: then
938: l_error := TRUE;
939: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
940: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
941: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_REGION_CODE');
942: FND_MSG_PUB.Add;
943: end if;
944: end if;
945:

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

953: p_to_region_code,
954: p_database_object_name) ) then
955: l_error := TRUE;
956: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
957: FND_MESSAGE.SET_NAME('AK','AK_INVALID_TO_REGION');
958: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_to_region_appl_id) ||
959: ' ' || p_to_region_code);
960: FND_MESSAGE.SET_TOKEN('OBJECT', p_database_object_name );
961: FND_MSG_PUB.Add;

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

954: p_database_object_name) ) then
955: l_error := TRUE;
956: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
957: FND_MESSAGE.SET_NAME('AK','AK_INVALID_TO_REGION');
958: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_to_region_appl_id) ||
959: ' ' || p_to_region_code);
960: FND_MESSAGE.SET_TOKEN('OBJECT', p_database_object_name );
961: FND_MSG_PUB.Add;
962: end if;

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

956: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
957: FND_MESSAGE.SET_NAME('AK','AK_INVALID_TO_REGION');
958: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_to_region_appl_id) ||
959: ' ' || p_to_region_code);
960: FND_MESSAGE.SET_TOKEN('OBJECT', p_database_object_name );
961: FND_MSG_PUB.Add;
962: end if;
963: end if;
964: end if; /* if p_to_region_appl_id */

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

1071: if ((p_database_object_name is null) or
1072: (p_database_object_name = FND_API.G_MISS_CHAR)) then
1073: l_error := TRUE;
1074: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1075: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1076: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
1077: FND_MSG_PUB.Add;
1078: end if;
1079: end if;

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

1072: (p_database_object_name = FND_API.G_MISS_CHAR)) then
1073: l_error := TRUE;
1074: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1075: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1076: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
1077: FND_MSG_PUB.Add;
1078: end if;
1079: end if;
1080:

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

1081: if ((p_attribute_application_id is null) or
1082: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
1083: l_error := TRUE;
1084: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1085: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1086: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
1087: FND_MSG_PUB.Add;
1088: end if;
1089: end if;

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

1082: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
1083: l_error := TRUE;
1084: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1085: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1086: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
1087: FND_MSG_PUB.Add;
1088: end if;
1089: end if;
1090:

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

1091: if ((p_attribute_code is null) or
1092: (p_attribute_code = FND_API.G_MISS_CHAR)) then
1093: l_error := TRUE;
1094: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1095: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1096: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
1097: FND_MSG_PUB.Add;
1098: end if;
1099: end if;

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

1092: (p_attribute_code = FND_API.G_MISS_CHAR)) then
1093: l_error := TRUE;
1094: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1095: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1096: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
1097: FND_MSG_PUB.Add;
1098: end if;
1099: end if;
1100:

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

1101: if ((p_key_value1 is null) or
1102: (p_key_value1 = FND_API.G_MISS_CHAR)) then
1103: l_error := TRUE;
1104: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1105: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1106: FND_MESSAGE.SET_TOKEN('COLUMN', 'KEY_VALUE1');
1107: FND_MSG_PUB.Add;
1108: end if;
1109: end if;

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

1102: (p_key_value1 = FND_API.G_MISS_CHAR)) then
1103: l_error := TRUE;
1104: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1105: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1106: FND_MESSAGE.SET_TOKEN('COLUMN', 'KEY_VALUE1');
1107: FND_MSG_PUB.Add;
1108: end if;
1109: end if;
1110:

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

1116: if (l_check_objattr_csr%notfound) then
1117: close l_check_objattr_csr;
1118: l_error := TRUE;
1119: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1120: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OA_REFERENCE');
1121: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1122: ' ' || to_char(p_attribute_application_id) ||
1123: ' ' || p_attribute_code);
1124: FND_MSG_PUB.Add;

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

1117: close l_check_objattr_csr;
1118: l_error := TRUE;
1119: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1120: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OA_REFERENCE');
1121: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1122: ' ' || to_char(p_attribute_application_id) ||
1123: ' ' || p_attribute_code);
1124: FND_MSG_PUB.Add;
1125: end if;

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

1135: (p_value_varchar2 <> FND_API.G_MISS_CHAR) then
1136: if (upper(l_data_type) <> 'VARCHAR2') then
1137: l_error := TRUE;
1138: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1139: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
1140: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');
1141: FND_MSG_PUB.Add;
1142: end if;
1143: -- dbms_output.put_line('value_varchar2 must be null for this attribute');

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

1136: if (upper(l_data_type) <> 'VARCHAR2') then
1137: l_error := TRUE;
1138: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1139: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
1140: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_VARCHAR2');
1141: FND_MSG_PUB.Add;
1142: end if;
1143: -- dbms_output.put_line('value_varchar2 must be null for this attribute');
1144: end if;

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

1148: (p_value_number <> FND_API.G_MISS_NUM) then
1149: if (upper(l_data_type) <> 'NUMBER') then
1150: l_error := TRUE;
1151: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1152: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
1153: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');
1154: FND_MSG_PUB.Add;
1155: end if;
1156: --dbms_output.put_line('value_number must be null for this attribute');

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

1149: if (upper(l_data_type) <> 'NUMBER') then
1150: l_error := TRUE;
1151: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1152: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
1153: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_NUMBER');
1154: FND_MSG_PUB.Add;
1155: end if;
1156: --dbms_output.put_line('value_number must be null for this attribute');
1157: end if;

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

1162: if (upper(l_data_type) <> 'DATE') and
1163: (upper(l_data_type) <> 'DATETIME') then
1164: l_error := TRUE;
1165: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1166: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
1167: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
1168: FND_MSG_PUB.Add;
1169: end if;
1170: --dbms_output.put_line('value_date must be null for this attribute');

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

1163: (upper(l_data_type) <> 'DATETIME') then
1164: l_error := TRUE;
1165: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1166: FND_MESSAGE.SET_NAME('AK','AK_MUST_BE_NULL');
1167: FND_MESSAGE.SET_TOKEN('COLUMN', 'VALUE_DATE');
1168: FND_MSG_PUB.Add;
1169: end if;
1170: --dbms_output.put_line('value_date must be null for this attribute');
1171: end if;

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

1278: if ((p_database_object_name is null) or
1279: (p_database_object_name = FND_API.G_MISS_CHAR)) then
1280: l_error := TRUE;
1281: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1282: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1283: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
1284: FND_MSG_PUB.Add;
1285: end if;
1286: end if;

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

1279: (p_database_object_name = FND_API.G_MISS_CHAR)) then
1280: l_error := TRUE;
1281: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1282: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1283: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
1284: FND_MSG_PUB.Add;
1285: end if;
1286: end if;
1287:

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

1299: if ( AK_ON_OBJECTS_PUB.G_LOAD_MODE = 'DOWNLOAD' or p_pass = 1 ) then
1300: l_error := TRUE;
1301: end if;
1302: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1303: FND_MESSAGE.SET_NAME('AK','AK_INVALID_VIEW_REFERENCE');
1304: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
1305: FND_MSG_PUB.Add;
1306: end if;
1307: end if;

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

1300: l_error := TRUE;
1301: end if;
1302: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1303: FND_MESSAGE.SET_NAME('AK','AK_INVALID_VIEW_REFERENCE');
1304: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
1305: FND_MSG_PUB.Add;
1306: end if;
1307: end if;
1308: close l_check_object_csr;

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

1315: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
1316: then
1317: l_error := TRUE;
1318: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1319: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1320: FND_MESSAGE.SET_TOKEN('COLUMN', 'APPLICATION_ID');
1321: FND_MSG_PUB.Add;
1322: end if;
1323: end if;

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

1316: then
1317: l_error := TRUE;
1318: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1319: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1320: FND_MESSAGE.SET_TOKEN('COLUMN', 'APPLICATION_ID');
1321: FND_MSG_PUB.Add;
1322: end if;
1323: end if;
1324:

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

1331: p_return_status => l_return_status,
1332: p_application_id => p_application_id)) then
1333: l_error := TRUE;
1334: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1335: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
1336: FND_MESSAGE.SET_TOKEN('COLUMN','APPLICATION_ID');
1337: FND_MSG_PUB.Add;
1338: end if;
1339: --dbms_output.put_line('Invalid application ID');

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

1332: p_application_id => p_application_id)) then
1333: l_error := TRUE;
1334: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1335: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
1336: FND_MESSAGE.SET_TOKEN('COLUMN','APPLICATION_ID');
1337: FND_MSG_PUB.Add;
1338: end if;
1339: --dbms_output.put_line('Invalid application ID');
1340: end if;

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

1347: p_database_object_name => p_database_object_name,
1348: p_primary_key_name => p_primary_key_name)) then
1349: l_error := TRUE;
1350: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1351: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
1352: FND_MESSAGE.SET_TOKEN('COLUMN','PRIMARY_KEY_NAME');
1353: FND_MSG_PUB.Add;
1354: end if;
1355: end if;

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

1348: p_primary_key_name => p_primary_key_name)) then
1349: l_error := TRUE;
1350: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1351: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
1352: FND_MESSAGE.SET_TOKEN('COLUMN','PRIMARY_KEY_NAME');
1353: FND_MSG_PUB.Add;
1354: end if;
1355: end if;
1356: end if;

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

1432: p_object_pk_tbl => p_to_table);
1433: if (l_return_status = FND_API.G_RET_STS_ERROR) or
1434: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1435: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1436: FND_MESSAGE.SET_NAME('AK','AK_INSERT_OBJECT_PK_FAILED');
1437: FND_MSG_PUB.Add;
1438: end if;
1439: -- dbms_output.put_line(l_api_name || 'Error inserting object PK table');
1440: raise FND_API.G_EXC_ERROR;

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

2055: p_database_object_name => p_database_object_name,
2056: p_attribute_application_id => p_attribute_application_id,
2057: p_attribute_code => p_attribute_code) then
2058: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2059: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_DOES_NOT_EXIST');
2060: FND_MSG_PUB.Add;
2061: end if;
2062: raise FND_API.G_EXC_ERROR;
2063: end if;

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

2075: l_value_number;
2076: if l_get_navigations_csr%found then
2077: close l_get_navigations_csr;
2078: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2079: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OA_NAV');
2080: FND_MSG_PUB.Add;
2081: end if;
2082: raise FND_API.G_EXC_ERROR;
2083: end if;

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

2091: l_key_value6, l_key_value7, l_key_value8, l_key_value9, l_key_value10;
2092: if l_get_attr_values_csr%found then
2093: close l_get_attr_values_csr;
2094: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2095: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DELETE_REFERENCE');
2096: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_OBJECT_ATTRIBUTES',TRUE);
2097: FND_MESSAGE.SET_TOKEN('REF_OBJECT', 'AK_ATTRIBUTE_VALUE',TRUE);
2098: FND_MSG_PUB.Add;
2099: end if;

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

2092: if l_get_attr_values_csr%found then
2093: close l_get_attr_values_csr;
2094: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2095: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DELETE_REFERENCE');
2096: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_OBJECT_ATTRIBUTES',TRUE);
2097: FND_MESSAGE.SET_TOKEN('REF_OBJECT', 'AK_ATTRIBUTE_VALUE',TRUE);
2098: FND_MSG_PUB.Add;
2099: end if;
2100: raise FND_API.G_EXC_ERROR;

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

2093: close l_get_attr_values_csr;
2094: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2095: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DELETE_REFERENCE');
2096: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_OBJECT_ATTRIBUTES',TRUE);
2097: FND_MESSAGE.SET_TOKEN('REF_OBJECT', 'AK_ATTRIBUTE_VALUE',TRUE);
2098: FND_MSG_PUB.Add;
2099: end if;
2100: raise FND_API.G_EXC_ERROR;
2101: end if;

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

2107: fetch l_get_region_item_csr into l_region_application_id, l_region_code;
2108: if l_get_region_item_csr%found then
2109: close l_get_region_item_csr;
2110: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2111: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OA_ITEM');
2112: FND_MSG_PUB.Add;
2113: end if;
2114: raise FND_API.G_EXC_ERROR;
2115: end if;

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

2123: l_region_application_id, l_region_code;
2124: if l_get_page_region_item_csr%found then
2125: close l_get_page_region_item_csr;
2126: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2127: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OA_PREGIM');
2128: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_OBJECT_ATTRIBUTES',TRUE);
2129: FND_MESSAGE.SET_TOKEN('REF_OBJECT', 'AK_REGION_ITEMS',TRUE);
2130: FND_MSG_PUB.Add;
2131: end if;

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

2124: if l_get_page_region_item_csr%found then
2125: close l_get_page_region_item_csr;
2126: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2127: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OA_PREGIM');
2128: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_OBJECT_ATTRIBUTES',TRUE);
2129: FND_MESSAGE.SET_TOKEN('REF_OBJECT', 'AK_REGION_ITEMS',TRUE);
2130: FND_MSG_PUB.Add;
2131: end if;
2132: raise FND_API.G_EXC_ERROR;

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

2125: close l_get_page_region_item_csr;
2126: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2127: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OA_PREGIM');
2128: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_OBJECT_ATTRIBUTES',TRUE);
2129: FND_MESSAGE.SET_TOKEN('REF_OBJECT', 'AK_REGION_ITEMS',TRUE);
2130: FND_MSG_PUB.Add;
2131: end if;
2132: raise FND_API.G_EXC_ERROR;
2133: end if;

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

2275: and attribute_code = p_attribute_code;
2276:
2277: if (sql%notfound) then
2278: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2279: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_DOES_NOT_EXIST');
2280: FND_MSG_PUB.Add;
2281: end if;
2282: raise FND_API.G_EXC_ERROR;
2283: end if;

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

2288: and attribute_code = p_attribute_code;
2289:
2290: if (sql%notfound) then
2291: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2292: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_DOES_NOT_EXIST');
2293: FND_MSG_PUB.Add;
2294: end if;
2295: raise FND_API.G_EXC_ERROR;
2296: end if;

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

2298: --
2299: -- Load success message
2300: --
2301: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2302: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_DELETED');
2303: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2304: ' ' || to_char(p_attribute_application_id) ||
2305: ' ' || p_attribute_code);
2306: FND_MSG_PUB.Add;

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

2299: -- Load success message
2300: --
2301: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2302: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_DELETED');
2303: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2304: ' ' || to_char(p_attribute_application_id) ||
2305: ' ' || p_attribute_code);
2306: FND_MSG_PUB.Add;
2307: end if;

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

2314:
2315: EXCEPTION
2316: WHEN FND_API.G_EXC_ERROR THEN
2317: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2318: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_NOT_DELETED');
2319: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2320: ' ' || to_char(p_attribute_application_id) ||
2321: ' ' || p_attribute_code);
2322: FND_MSG_PUB.Add;

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

2315: EXCEPTION
2316: WHEN FND_API.G_EXC_ERROR THEN
2317: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2318: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_NOT_DELETED');
2319: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2320: ' ' || to_char(p_attribute_application_id) ||
2321: ' ' || p_attribute_code);
2322: FND_MSG_PUB.Add;
2323: end if;

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

2415: p_value_varchar2 => p_value_varchar2,
2416: p_value_date => p_value_date,
2417: p_value_number => p_value_number) then
2418: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2419: FND_MESSAGE.SET_NAME('AK','AK_NAV_DOES_NOT_EXIST');
2420: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_NAVIGATION', TRUE);
2421: FND_MSG_PUB.Add;
2422: end if;
2423: raise FND_API.G_EXC_ERROR;

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

2416: p_value_date => p_value_date,
2417: p_value_number => p_value_number) then
2418: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2419: FND_MESSAGE.SET_NAME('AK','AK_NAV_DOES_NOT_EXIST');
2420: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_NAVIGATION', TRUE);
2421: FND_MSG_PUB.Add;
2422: end if;
2423: raise FND_API.G_EXC_ERROR;
2424: end if;

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

2472: end if;
2473:
2474: if (sql%notfound) then
2475: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2476: FND_MESSAGE.SET_NAME('AK','AK_NAV_DOES_NOT_EXIST');
2477: FND_MSG_PUB.Add;
2478: end if;
2479: raise FND_API.G_EXC_ERROR;
2480: end if;

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

2482: --
2483: -- Load success message
2484: --
2485: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2486: FND_MESSAGE.SET_NAME('AK','AK_NAV_DELETED');
2487: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2488: ' ' || to_char(p_attribute_application_id) ||
2489: ' ' || p_attribute_code ||
2490: ' ' || p_value_varchar2 ||

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

2483: -- Load success message
2484: --
2485: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2486: FND_MESSAGE.SET_NAME('AK','AK_NAV_DELETED');
2487: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2488: ' ' || to_char(p_attribute_application_id) ||
2489: ' ' || p_attribute_code ||
2490: ' ' || p_value_varchar2 ||
2491: to_char(p_value_date) ||

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

2501:
2502: EXCEPTION
2503: WHEN FND_API.G_EXC_ERROR THEN
2504: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2505: FND_MESSAGE.SET_NAME('AK','AK_NAV_NOT_DELETED');
2506: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_NAVIGATION', TRUE);
2507: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2508: ' ' || to_char(p_attribute_application_id)||
2509: ' ' || p_attribute_code ||

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

2502: EXCEPTION
2503: WHEN FND_API.G_EXC_ERROR THEN
2504: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2505: FND_MESSAGE.SET_NAME('AK','AK_NAV_NOT_DELETED');
2506: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_NAVIGATION', TRUE);
2507: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2508: ' ' || to_char(p_attribute_application_id)||
2509: ' ' || p_attribute_code ||
2510: ' ' || p_value_varchar2 ||

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

2503: WHEN FND_API.G_EXC_ERROR THEN
2504: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2505: FND_MESSAGE.SET_NAME('AK','AK_NAV_NOT_DELETED');
2506: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_NAVIGATION', TRUE);
2507: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2508: ' ' || to_char(p_attribute_application_id)||
2509: ' ' || p_attribute_code ||
2510: ' ' || p_value_varchar2 ||
2511: to_char(p_value_date) ||

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

2662: p_key_value8 => p_key_value8,
2663: p_key_value9 => p_key_value9,
2664: p_key_value10 => p_key_value10) then
2665: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2666: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
2667: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2668: FND_MSG_PUB.Add;
2669: end if;
2670: raise FND_API.G_EXC_ERROR;

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

2663: p_key_value9 => p_key_value9,
2664: p_key_value10 => p_key_value10) then
2665: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2666: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
2667: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2668: FND_MSG_PUB.Add;
2669: end if;
2670: raise FND_API.G_EXC_ERROR;
2671: end if;

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

2783: end if;
2784:
2785: if (dbms_sql.execute(l_sql_csr) = 0) then
2786: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2787: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
2788: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2789: FND_MSG_PUB.Add;
2790: end if;
2791: dbms_sql.close_cursor(l_sql_csr);

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

2784:
2785: if (dbms_sql.execute(l_sql_csr) = 0) then
2786: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2787: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
2788: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2789: FND_MSG_PUB.Add;
2790: end if;
2791: dbms_sql.close_cursor(l_sql_csr);
2792: raise FND_API.G_EXC_ERROR;

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

2796: --
2797: -- Load success message
2798: --
2799: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2800: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DELETED');
2801: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2802: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2803: ' ' || to_char(p_attribute_application_id) ||
2804: ' ' || p_attribute_code ||

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

2797: -- Load success message
2798: --
2799: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2800: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DELETED');
2801: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2802: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2803: ' ' || to_char(p_attribute_application_id) ||
2804: ' ' || p_attribute_code ||
2805: ' ' || p_key_value1 ||

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

2798: --
2799: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2800: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DELETED');
2801: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2802: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2803: ' ' || to_char(p_attribute_application_id) ||
2804: ' ' || p_attribute_code ||
2805: ' ' || p_key_value1 ||
2806: ' ' || l_key_value2 ||

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

2823:
2824: EXCEPTION
2825: WHEN FND_API.G_EXC_ERROR THEN
2826: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2827: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DELETED');
2828: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2829: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2830: ' ' || to_char(p_attribute_application_id) ||
2831: ' ' || p_attribute_code ||

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

2824: EXCEPTION
2825: WHEN FND_API.G_EXC_ERROR THEN
2826: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2827: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DELETED');
2828: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2829: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2830: ' ' || to_char(p_attribute_application_id) ||
2831: ' ' || p_attribute_code ||
2832: ' ' || p_key_value1 ||

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

2825: WHEN FND_API.G_EXC_ERROR THEN
2826: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2827: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DELETED');
2828: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2829: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
2830: ' ' || to_char(p_attribute_application_id) ||
2831: ' ' || p_attribute_code ||
2832: ' ' || p_key_value1 ||
2833: ' ' || l_key_value2 ||

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

2943: p_api_version_number => 1.0,
2944: p_return_status => l_return_status,
2945: p_database_object_name => p_database_object_name) then
2946: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2947: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
2948: FND_MSG_PUB.Add;
2949: end if;
2950: raise FND_API.G_EXC_ERROR;
2951: end if;

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

2963: l_attribute_application_id, l_attribute_code;
2964: if l_get_obj_attributes_csr%found then
2965: close l_get_obj_attributes_csr;
2966: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2967: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OBJ_OA');
2968: FND_MSG_PUB.Add;
2969: end if;
2970: raise FND_API.G_EXC_ERROR;
2971: end if;

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

2977: fetch l_get_unique_keys_csr into l_unique_key_name;
2978: if l_get_unique_keys_csr%found then
2979: close l_get_unique_keys_csr;
2980: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2981: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OBJ_UK');
2982: FND_MSG_PUB.Add;
2983: end if;
2984: raise FND_API.G_EXC_ERROR;
2985: end if;

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

2991: fetch l_get_foreign_keys_csr into l_foreign_key_name;
2992: if l_get_foreign_keys_csr%found then
2993: close l_get_foreign_keys_csr;
2994: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2995: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OBJ_FK');
2996: FND_MSG_PUB.Add;
2997: end if;
2998: raise FND_API.G_EXC_ERROR;
2999: end if;

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

3005: fetch l_get_regions_csr into l_region_application_id, l_region_code;
3006: if l_get_regions_csr%found then
3007: close l_get_regions_csr;
3008: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3009: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_OBJ_REG');
3010: FND_MSG_PUB.Add;
3011: end if;
3012: raise FND_API.G_EXC_ERROR;
3013: end if;

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

3125: where database_object_name = p_database_object_name;
3126:
3127: if (sql%notfound) then
3128: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3129: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
3130: FND_MSG_PUB.Add;
3131: end if;
3132: raise FND_API.G_EXC_ERROR;
3133: end if;

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

3135: --
3136: -- Load success message
3137: --
3138: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
3139: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DELETED');
3140: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
3141: FND_MSG_PUB.Add;
3142: end if;
3143:

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

3136: -- Load success message
3137: --
3138: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
3139: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DELETED');
3140: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
3141: FND_MSG_PUB.Add;
3142: end if;
3143:
3144: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

3149:
3150: EXCEPTION
3151: WHEN FND_API.G_EXC_ERROR THEN
3152: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3153: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DELETED');
3154: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
3155: FND_MSG_PUB.Add;
3156: end if;
3157: p_return_status := FND_API.G_RET_STS_ERROR;

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

3150: EXCEPTION
3151: WHEN FND_API.G_EXC_ERROR THEN
3152: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3153: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DELETED');
3154: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
3155: FND_MSG_PUB.Add;
3156: end if;
3157: p_return_status := FND_API.G_RET_STS_ERROR;
3158: rollback to start_delete_object;

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

3355: p_api_version_number => 1.0,
3356: p_return_status => l_return_status,
3357: p_database_object_name => p_database_object_name)) then
3358: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3359: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_EXISTS');
3360: FND_MSG_PUB.Add;
3361: end if;
3362: -- dbms_output.put_line(G_PKG_NAME || 'Error - Row already exists');
3363: raise FND_API.G_EXC_ERROR;

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

3591: p_api_version_number => 1.0,
3592: p_return_status => l_return_status,
3593: p_database_object_name => p_database_object_name)) then
3594: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3595: FND_MESSAGE.SET_NAME('AK','AK_INSERT_OBJECT_FAILED');
3596: FND_MSG_PUB.Add;
3597: end if;
3598: raise FND_API.G_EXC_ERROR;
3599: end if;

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

3628: where T.DATABASE_OBJECT_NAME = p_database_object_name
3629: and T.LANGUAGE = L.LANGUAGE_CODE);
3630:
3631: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3632: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_CREATED');
3633: FND_MESSAGE.SET_TOKEN('KEY',p_database_object_name);
3634: FND_MSG_PUB.Add;
3635: end if;
3636:

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

3629: and T.LANGUAGE = L.LANGUAGE_CODE);
3630:
3631: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3632: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_CREATED');
3633: FND_MESSAGE.SET_TOKEN('KEY',p_database_object_name);
3634: FND_MSG_PUB.Add;
3635: end if;
3636:
3637: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

3642:
3643: EXCEPTION
3644: WHEN VALUE_ERROR THEN
3645: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3646: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');
3647: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
3648: FND_MSG_PUB.Add;
3649: end if;
3650: rollback to start_create_object;

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

3643: EXCEPTION
3644: WHEN VALUE_ERROR THEN
3645: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3646: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');
3647: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
3648: FND_MSG_PUB.Add;
3649: end if;
3650: rollback to start_create_object;
3651: p_return_status := FND_API.G_RET_STS_ERROR;

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

3653: p_count => p_msg_count,
3654: p_data => p_msg_data);
3655: WHEN FND_API.G_EXC_ERROR THEN
3656: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3657: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_CREATED');
3658: FND_MESSAGE.SET_TOKEN('KEY',p_database_object_name);
3659: FND_MSG_PUB.Add;
3660: end if;
3661: p_return_status := FND_API.G_RET_STS_ERROR;

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

3654: p_data => p_msg_data);
3655: WHEN FND_API.G_EXC_ERROR THEN
3656: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3657: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_CREATED');
3658: FND_MESSAGE.SET_TOKEN('KEY',p_database_object_name);
3659: FND_MSG_PUB.Add;
3660: end if;
3661: p_return_status := FND_API.G_RET_STS_ERROR;
3662: rollback to start_create_object;

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

3827: p_database_object_name => p_database_object_name,
3828: p_attribute_application_id => p_attribute_application_id,
3829: p_attribute_code => p_attribute_code) ) then
3830: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3831: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_EXISTS');
3832: FND_MSG_PUB.Add;
3833: end if;
3834: -- dbms_output.put_line('OA Key: '||p_database_object_name ||
3835: -- ' ' || to_char(p_attribute_application_id) ||

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

4185: p_database_object_name => p_database_object_name,
4186: p_attribute_application_id => p_attribute_application_id,
4187: p_attribute_code => p_attribute_code) ) then
4188: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4189: FND_MESSAGE.SET_NAME('AK','AK_INSERT_OBJECT_ATTR_FAILED');
4190: FND_MSG_PUB.Add;
4191: end if;
4192: -- dbms_output.put_line(G_PKG_NAME || 'Error - First insert failed');
4193: raise FND_API.G_EXC_ERROR;

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

4232: -- /** commit the insert **/
4233: -- commit;
4234:
4235: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4236: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_CREATED');
4237: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4238: ' ' || to_char(p_attribute_application_id) ||
4239: ' ' || p_attribute_code);
4240: FND_MSG_PUB.Add;

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

4233: -- commit;
4234:
4235: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4236: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_CREATED');
4237: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4238: ' ' || to_char(p_attribute_application_id) ||
4239: ' ' || p_attribute_code);
4240: FND_MSG_PUB.Add;
4241: end if;

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

4248:
4249: EXCEPTION
4250: WHEN VALUE_ERROR THEN
4251: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4252: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_VALUE_ERROR');
4253: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4254: ' ' || to_char(p_attribute_application_id) ||
4255: ' ' || p_attribute_code );
4256: FND_MSG_PUB.Add;

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

4249: EXCEPTION
4250: WHEN VALUE_ERROR THEN
4251: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4252: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_VALUE_ERROR');
4253: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4254: ' ' || to_char(p_attribute_application_id) ||
4255: ' ' || p_attribute_code );
4256: FND_MSG_PUB.Add;
4257: end if;

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

4261: p_count => p_msg_count,
4262: p_data => p_msg_data);
4263: WHEN FND_API.G_EXC_ERROR THEN
4264: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4265: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_NOT_CREATED');
4266: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4267: ' ' || to_char(p_attribute_application_id) ||
4268: ' ' || p_attribute_code);
4269: FND_MSG_PUB.Add;

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

4262: p_data => p_msg_data);
4263: WHEN FND_API.G_EXC_ERROR THEN
4264: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4265: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_NOT_CREATED');
4266: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4267: ' ' || to_char(p_attribute_application_id) ||
4268: ' ' || p_attribute_code);
4269: FND_MSG_PUB.Add;
4270: end if;

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

4410: l_count := l_count + 1;
4411: end if;
4412: if (l_count <> 1) then
4413: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4414: FND_MESSAGE.SET_NAME('AK','AK_ONE_VALUE_ONLY');
4415: FND_MSG_PUB.Add;
4416: end if;
4417: -- dbms_output.put_line('One and only one value field must be non-null');
4418: raise FND_API.G_EXC_ERROR;

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

4428: p_value_varchar2 => p_value_varchar2,
4429: p_value_date => p_value_date,
4430: p_value_number => p_value_number) then
4431: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4432: FND_MESSAGE.SET_NAME('AK','AK_NAV_EXISTS');
4433: FND_MSG_PUB.Add;
4434: end if;
4435: raise FND_API.G_EXC_ERROR;
4436: end if;

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

4631: -- /** commit the insert **/
4632: -- commit;
4633:
4634: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4635: FND_MESSAGE.SET_NAME('AK','AK_NAV_CREATED');
4636: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4637: ' ' || to_char(p_attribute_application_id) ||
4638: ' ' || p_attribute_code || ' ' ||
4639: p_value_varchar2 ||

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

4632: -- commit;
4633:
4634: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4635: FND_MESSAGE.SET_NAME('AK','AK_NAV_CREATED');
4636: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4637: ' ' || to_char(p_attribute_application_id) ||
4638: ' ' || p_attribute_code || ' ' ||
4639: p_value_varchar2 ||
4640: to_char(p_value_date) ||

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

4650:
4651: EXCEPTION
4652: WHEN VALUE_ERROR THEN
4653: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4654: FND_MESSAGE.SET_NAME('AK','AK_NAV_VALUE_ERROR');
4655: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4656: ' ' || to_char(p_attribute_application_id)
4657: || ' ' || p_attribute_code || ' ' ||
4658: p_value_varchar2 ||

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

4651: EXCEPTION
4652: WHEN VALUE_ERROR THEN
4653: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4654: FND_MESSAGE.SET_NAME('AK','AK_NAV_VALUE_ERROR');
4655: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4656: ' ' || to_char(p_attribute_application_id)
4657: || ' ' || p_attribute_code || ' ' ||
4658: p_value_varchar2 ||
4659: to_char(p_value_date) ||

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

4666: p_count => p_msg_count,
4667: p_data => p_msg_data);
4668: WHEN FND_API.G_EXC_ERROR THEN
4669: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4670: FND_MESSAGE.SET_NAME('AK','AK_NAV_NOT_CREATED');
4671: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4672: ' ' || to_char(p_attribute_application_id)
4673: || ' ' || p_attribute_code || ' ' ||
4674: p_value_varchar2 ||

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

4667: p_data => p_msg_data);
4668: WHEN FND_API.G_EXC_ERROR THEN
4669: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4670: FND_MESSAGE.SET_NAME('AK','AK_NAV_NOT_CREATED');
4671: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4672: ' ' || to_char(p_attribute_application_id)
4673: || ' ' || p_attribute_code || ' ' ||
4674: p_value_varchar2 ||
4675: to_char(p_value_date) ||

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

4802: p_key_value9 => p_key_value9,
4803: p_key_value10 => p_key_value10
4804: ) then
4805: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4806: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_EXISTS');
4807: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
4808: FND_MSG_PUB.Add;
4809: end if;
4810: -- dbms_output.put_line(l_api_name || 'Error - Row already exists');

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

4803: p_key_value10 => p_key_value10
4804: ) then
4805: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4806: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_EXISTS');
4807: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
4808: FND_MSG_PUB.Add;
4809: end if;
4810: -- dbms_output.put_line(l_api_name || 'Error - Row already exists');
4811: raise FND_API.G_EXC_ERROR;

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

4977: -- /** commit the insert **/
4978: -- commit;
4979:
4980: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4981: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_CREATED');
4982: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
4983: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4984: ' ' || to_char(p_attribute_application_id) ||
4985: ' ' || p_attribute_code ||

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

4978: -- commit;
4979:
4980: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4981: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_CREATED');
4982: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
4983: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4984: ' ' || to_char(p_attribute_application_id) ||
4985: ' ' || p_attribute_code ||
4986: ' ' || p_key_value1 ||

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

4979:
4980: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4981: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_CREATED');
4982: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
4983: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
4984: ' ' || to_char(p_attribute_application_id) ||
4985: ' ' || p_attribute_code ||
4986: ' ' || p_key_value1 ||
4987: ' ' || l_key_value2 ||

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

5004:
5005: EXCEPTION
5006: WHEN VALUE_ERROR THEN
5007: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5008: FND_MESSAGE.SET_NAME('AK','AK_VALUE_ERROR');
5009: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
5010: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
5011: ' ' || to_char(p_attribute_application_id) ||
5012: ' ' || p_attribute_code ||

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

5005: EXCEPTION
5006: WHEN VALUE_ERROR THEN
5007: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5008: FND_MESSAGE.SET_NAME('AK','AK_VALUE_ERROR');
5009: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
5010: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
5011: ' ' || to_char(p_attribute_application_id) ||
5012: ' ' || p_attribute_code ||
5013: ' ' || p_key_value1 ||

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

5006: WHEN VALUE_ERROR THEN
5007: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5008: FND_MESSAGE.SET_NAME('AK','AK_VALUE_ERROR');
5009: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
5010: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
5011: ' ' || to_char(p_attribute_application_id) ||
5012: ' ' || p_attribute_code ||
5013: ' ' || p_key_value1 ||
5014: ' ' || l_key_value2 ||

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

5028: p_count => p_msg_count,
5029: p_data => p_msg_data);
5030: WHEN FND_API.G_EXC_ERROR THEN
5031: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5032: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_CREATED');
5033: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
5034: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
5035: ' ' || to_char(p_attribute_application_id) ||
5036: ' ' || p_attribute_code ||

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

5029: p_data => p_msg_data);
5030: WHEN FND_API.G_EXC_ERROR THEN
5031: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5032: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_CREATED');
5033: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
5034: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
5035: ' ' || to_char(p_attribute_application_id) ||
5036: ' ' || p_attribute_code ||
5037: ' ' || p_key_value1 ||

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

5030: WHEN FND_API.G_EXC_ERROR THEN
5031: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5032: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_CREATED');
5033: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
5034: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
5035: ' ' || to_char(p_attribute_application_id) ||
5036: ' ' || p_attribute_code ||
5037: ' ' || p_key_value1 ||
5038: ' ' || l_key_value2 ||