[Home] [Help]
253: -- validation tests are passed, or FALSE otherwise.
254: -- Parameters Object Attribute columns
255: -- p_caller : IN required
256: -- Must be one of the following values defined
257: -- in package AK_ON_OBJECTS_PVT:
258: -- - G_CREATE (if calling from the Create API)
259: -- - G_DOWNLOAD (if calling from the Download API)
260: -- - G_UPDATE (if calling from the Update API)
261: --
360: --* (This check is not necessary during download because the download
361: --* procedure has retrieved the parent object before retrieving its
362: --* object attributes.)
363:
364: if (p_caller <> AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
365: if (NOT AK_OBJECT_PVT.OBJECT_EXISTS (
366: p_api_version_number => 1.0,
367: p_return_status => l_return_status,
368: p_database_object_name => p_database_object_name)) then
396: --** from UPDATE procedure, the columns are not missing **
397:
398: if ((p_data_source_type is null) or
399: (p_data_source_type = FND_API.G_MISS_CHAR and
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');
408: end if;
409:
410: if ((p_required_flag is null) or
411: (p_required_flag = FND_API.G_MISS_CHAR and
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');
420: end if;
421:
422: if ((p_attribute_label_length is null) or
423: (p_attribute_label_length = FND_API.G_MISS_NUM and
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');
432: end if;
433:
434: if ((p_display_value_length is null) or
435: (p_display_value_length = FND_API.G_MISS_NUM and
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');
444: end if;
445:
446: if ((p_bold is null) or
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');
455: end if;
456:
457: if ((p_italic is null) or
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');
466: end if;
467:
468: if ((p_vertical_alignment is null) or
469: (p_vertical_alignment = FND_API.G_MISS_CHAR and
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');
478: end if;
479:
480: if ((p_horizontal_alignment is null) or
481: (p_horizontal_alignment = FND_API.G_MISS_CHAR and
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');
492: --** Validate columns **
493:
494: -- - data_source_type
495: if (p_data_source_type <> FND_API.G_MISS_CHAR) then
496: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
497: p_api_version_number => 1.0,
498: p_return_status => l_return_status,
499: p_lookup_type => 'DATA_SOURCE_TYPE',
500: p_lookup_code => p_data_source_type)) then
509:
510: -- - data_storage_type
511: if (p_data_storage_type <> FND_API.G_MISS_CHAR) and
512: (p_data_storage_type is not null) then
513: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
514: p_api_version_number => 1.0,
515: p_return_status => l_return_status,
516: p_lookup_type => 'DATA_STORAGE_TYPE',
517: p_lookup_code => p_data_storage_type)) then
557: end if;
558:
559: -- - required_flag
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');
625: end if; /* if p_lov_foreign_key_name */
626:
627: -- - bold
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');
637: end if;
638:
639: -- - italic
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');
667: end if;
668:
669: -- - vertical alignment
670: if (p_vertical_alignment <> FND_API.G_MISS_CHAR) then
671: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
672: p_api_version_number => 1.0,
673: p_return_status => l_return_status,
674: p_lookup_type => 'VERTICAL_ALIGNMENT',
675: p_lookup_code => p_vertical_alignment)) then
683: end if;
684:
685: -- - horizontal alignment
686: if (p_horizontal_alignment <> FND_API.G_MISS_CHAR) then
687: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
688: p_api_version_number => 1.0,
689: p_return_status => l_return_status,
690: p_lookup_type => 'HORIZONTAL_ALIGNMENT',
691: p_lookup_code => p_horizontal_alignment)) then
734: -- validation tests are passed, or FALSE otherwise.
735: -- Parameters Attribute Navigation columns
736: -- p_caller : IN required
737: -- Must be one of the following values defined
738: -- in package AK_ON_OBJECTS_PVT:
739: -- - G_CREATE (if calling from the Create API)
740: -- - G_DOWNLOAD (if calling from the Download API)
741: -- - G_UPDATE (if calling from the Update API)
742: --
920: --** check that required columns are not null and, unless calling **
921: --** from UPDATE procedure, the columns are not missing **
922: if ((p_to_region_appl_id is null) or
923: (p_to_region_appl_id = FND_API.G_MISS_NUM and
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');
932: end if;
933:
934: if ((p_to_region_code is null) or
935: (p_to_region_code = FND_API.G_MISS_CHAR and
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');
998: -- validation tests are passed, or FALSE otherwise.
999: -- Parameters Attribute Value columns
1000: -- p_caller : IN required
1001: -- Must be one of the following values defined
1002: -- in package AK_ON_OBJECTS_PVT:
1003: -- - G_CREATE (if calling from the Create API)
1004: -- - G_DOWNLOAD (if calling from the Download API)
1005: -- - G_UPDATE (if calling from the Update API)
1006: --
1208: -- validation tests are passed, or FALSE otherwise.
1209: -- Parameters Object columns
1210: -- p_caller : IN required
1211: -- Must be one of the following values defined
1212: -- in package AK_ON_OBJECTS_PVT:
1213: -- - G_CREATE (if calling from the Create API)
1214: -- - G_DOWNLOAD (if calling from the Download API)
1215: -- - G_UPDATE (if calling from the Update API)
1216: --
1311: --** check that required columns are not null and, unless calling **
1312: --** from UPDATE procedure, the columns are not missing **
1313: if ((p_application_id is null) or
1314: (p_application_id = FND_API.G_MISS_NUM and
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');
1325: --** Validate columns **
1326:
1327: -- - application ID
1328: if (p_application_id <> FND_API.G_MISS_NUM) then
1329: if (NOT AK_ON_OBJECTS_PVT.VALID_APPLICATION_ID (
1330: p_api_version_number => 1.0,
1331: p_return_status => l_return_status,
1332: p_application_id => p_application_id)) then
1333: l_error := TRUE;
3377: p_defaulting_api_pkg => p_defaulting_api_pkg,
3378: p_defaulting_api_proc => p_defaulting_api_proc,
3379: p_validation_api_pkg => p_validation_api_pkg,
3380: p_validation_api_proc => p_validation_api_proc,
3381: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
3382: p_pass => p_pass
3383: ) then
3384: -- Do not raise an error if it's the first pass
3385: if (p_pass = 1) then
3506: -- old jlt files didn't have who columns and IS_UPDATEABLE
3507: -- calls SET_WHO which populates those columns, for later
3508: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
3509:
3510: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
3511: p_loader_timestamp => p_loader_timestamp,
3512: p_created_by => l_created_by,
3513: p_creation_date => l_creation_date,
3514: p_last_updated_by => l_last_updated_by,
3891: p_validation_api_pkg => p_validation_api_pkg,
3892: p_validation_api_proc => p_validation_api_proc,
3893: p_attribute_label_long => p_attribute_label_long,
3894: p_attribute_label_short => p_attribute_label_short,
3895: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
3896: p_pass => p_pass
3897: ) then
3898: -- dbms_output.put_line(l_api_name || 'validation failed');
3899: -- Do not raise an error if it's the first pass
4061: -- old jlt files didn't have who columns and IS_UPDATEABLE
4062: -- calls SET_WHO which populates those columns, for later
4063: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
4064:
4065: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4066: p_loader_timestamp => p_loader_timestamp,
4067: p_created_by => l_created_by,
4068: p_creation_date => l_creation_date,
4069: p_last_updated_by => l_last_updated_by,
4448: p_value_date => p_value_date,
4449: p_value_number => p_value_number,
4450: p_to_region_appl_id => p_to_region_appl_id,
4451: p_to_region_code => p_to_region_code,
4452: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
4453: p_pass => p_pass
4454: ) then
4455: -- Do not raise an error if it's the first pass
4456: if (p_pass = 1) then
4552: -- old jlt files didn't have who columns and IS_UPDATEABLE
4553: -- calls SET_WHO which populates those columns, for later
4554: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
4555:
4556: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4557: p_loader_timestamp => p_loader_timestamp,
4558: p_created_by => l_created_by,
4559: p_creation_date => l_creation_date,
4560: p_last_updated_by => l_last_updated_by,
4832: p_key_value10 => p_key_value10,
4833: p_value_varchar2 => p_value_varchar2,
4834: p_value_date => p_value_date,
4835: p_value_number => p_value_number,
4836: p_caller => AK_ON_OBJECTS_PVT.G_CREATE
4837: ) then
4838: -- dbms_output.put_line('validation failed');
4839: raise FND_API.G_EXC_ERROR;
4840: end if;
4914: -- old jlt files didn't have who columns and IS_UPDATEABLE
4915: -- calls SET_WHO which populates those columns, for later
4916: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
4917:
4918: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4919: p_loader_timestamp => p_loader_timestamp,
4920: p_created_by => l_created_by,
4921: p_creation_date => l_creation_date,
4922: p_last_updated_by => l_last_updated_by,