[Home] [Help]
246: -- validation tests are passed, or FALSE otherwise.
247: -- Parameters Object Attribute columns
248: -- p_caller : IN required
249: -- Must be one of the following values defined
250: -- in package AK_ON_OBJECTS_PVT:
251: -- - G_CREATE (if calling from the Create API)
252: -- - G_DOWNLOAD (if calling from the Download API)
253: -- - G_UPDATE (if calling from the Update API)
254: --
353: --* (This check is not necessary during download because the download
354: --* procedure has retrieved the parent object before retrieving its
355: --* object attributes.)
356:
357: if (p_caller <> AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
358: if (NOT AK_OBJECT_PVT.OBJECT_EXISTS (
359: p_api_version_number => 1.0,
360: p_return_status => l_return_status,
361: p_database_object_name => p_database_object_name)) then
389: --** from UPDATE procedure, the columns are not missing **
390:
391: if ((p_data_source_type is null) or
392: (p_data_source_type = FND_API.G_MISS_CHAR and
393: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
394: then
395: l_error := TRUE;
396: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
397: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
401: end if;
402:
403: if ((p_required_flag is null) or
404: (p_required_flag = FND_API.G_MISS_CHAR and
405: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
406: then
407: l_error := TRUE;
408: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
409: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
413: end if;
414:
415: if ((p_attribute_label_length is null) or
416: (p_attribute_label_length = FND_API.G_MISS_NUM and
417: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
418: then
419: l_error := TRUE;
420: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
421: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
425: end if;
426:
427: if ((p_display_value_length is null) or
428: (p_display_value_length = FND_API.G_MISS_NUM and
429: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
430: then
431: l_error := TRUE;
432: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
433: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
437: end if;
438:
439: if ((p_bold is null) or
440: (p_bold = FND_API.G_MISS_CHAR and
441: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
442: l_error := TRUE;
443: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
444: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
445: FND_MESSAGE.SET_TOKEN('COLUMN', 'BOLD');
448: end if;
449:
450: if ((p_italic is null) or
451: (p_italic = FND_API.G_MISS_CHAR and
452: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
453: l_error := TRUE;
454: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
455: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
456: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITALIC');
459: end if;
460:
461: if ((p_vertical_alignment is null) or
462: (p_vertical_alignment = FND_API.G_MISS_CHAR and
463: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
464: then
465: l_error := TRUE;
466: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
467: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
471: end if;
472:
473: if ((p_horizontal_alignment is null) or
474: (p_horizontal_alignment = FND_API.G_MISS_CHAR and
475: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
476: then
477: l_error := TRUE;
478: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
479: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
485: --** Validate columns **
486:
487: -- - data_source_type
488: if (p_data_source_type <> FND_API.G_MISS_CHAR) then
489: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
490: p_api_version_number => 1.0,
491: p_return_status => l_return_status,
492: p_lookup_type => 'DATA_SOURCE_TYPE',
493: p_lookup_code => p_data_source_type)) then
502:
503: -- - data_storage_type
504: if (p_data_storage_type <> FND_API.G_MISS_CHAR) and
505: (p_data_storage_type is not null) then
506: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
507: p_api_version_number => 1.0,
508: p_return_status => l_return_status,
509: p_lookup_type => 'DATA_STORAGE_TYPE',
510: p_lookup_code => p_data_storage_type)) then
550: end if;
551:
552: -- - required_flag
553: if (p_required_flag <> FND_API.G_MISS_CHAR) then
554: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_required_flag)) then
555: l_error := TRUE;
556: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
557: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
558: FND_MESSAGE.SET_TOKEN('COLUMN','REQUIRED_FLAG');
618: end if; /* if p_lov_foreign_key_name */
619:
620: -- - bold
621: if (p_bold <> FND_API.G_MISS_CHAR) then
622: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_bold)) then
623: l_error := TRUE;
624: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
625: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
626: FND_MESSAGE.SET_TOKEN('COLUMN','BOLD');
630: end if;
631:
632: -- - italic
633: if (p_italic <> FND_API.G_MISS_CHAR) then
634: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_italic)) then
635: l_error := TRUE;
636: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
637: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
638: FND_MESSAGE.SET_TOKEN('COLUMN','ITALIC');
660: end if;
661:
662: -- - vertical alignment
663: if (p_vertical_alignment <> FND_API.G_MISS_CHAR) then
664: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
665: p_api_version_number => 1.0,
666: p_return_status => l_return_status,
667: p_lookup_type => 'VERTICAL_ALIGNMENT',
668: p_lookup_code => p_vertical_alignment)) then
676: end if;
677:
678: -- - horizontal alignment
679: if (p_horizontal_alignment <> FND_API.G_MISS_CHAR) then
680: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
681: p_api_version_number => 1.0,
682: p_return_status => l_return_status,
683: p_lookup_type => 'HORIZONTAL_ALIGNMENT',
684: p_lookup_code => p_horizontal_alignment)) then
727: -- validation tests are passed, or FALSE otherwise.
728: -- Parameters Attribute Navigation columns
729: -- p_caller : IN required
730: -- Must be one of the following values defined
731: -- in package AK_ON_OBJECTS_PVT:
732: -- - G_CREATE (if calling from the Create API)
733: -- - G_DOWNLOAD (if calling from the Download API)
734: -- - G_UPDATE (if calling from the Update API)
735: --
913: --** check that required columns are not null and, unless calling **
914: --** from UPDATE procedure, the columns are not missing **
915: if ((p_to_region_appl_id is null) or
916: (p_to_region_appl_id = FND_API.G_MISS_NUM and
917: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
918: then
919: l_error := TRUE;
920: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
921: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
925: end if;
926:
927: if ((p_to_region_code is null) or
928: (p_to_region_code = FND_API.G_MISS_CHAR and
929: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
930: then
931: l_error := TRUE;
932: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
933: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
991: -- validation tests are passed, or FALSE otherwise.
992: -- Parameters Attribute Value columns
993: -- p_caller : IN required
994: -- Must be one of the following values defined
995: -- in package AK_ON_OBJECTS_PVT:
996: -- - G_CREATE (if calling from the Create API)
997: -- - G_DOWNLOAD (if calling from the Download API)
998: -- - G_UPDATE (if calling from the Update API)
999: --
1201: -- validation tests are passed, or FALSE otherwise.
1202: -- Parameters Object columns
1203: -- p_caller : IN required
1204: -- Must be one of the following values defined
1205: -- in package AK_ON_OBJECTS_PVT:
1206: -- - G_CREATE (if calling from the Create API)
1207: -- - G_DOWNLOAD (if calling from the Download API)
1208: -- - G_UPDATE (if calling from the Update API)
1209: --
1304: --** check that required columns are not null and, unless calling **
1305: --** from UPDATE procedure, the columns are not missing **
1306: if ((p_application_id is null) or
1307: (p_application_id = FND_API.G_MISS_NUM and
1308: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
1309: then
1310: l_error := TRUE;
1311: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1312: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1318: --** Validate columns **
1319:
1320: -- - application ID
1321: if (p_application_id <> FND_API.G_MISS_NUM) then
1322: if (NOT AK_ON_OBJECTS_PVT.VALID_APPLICATION_ID (
1323: p_api_version_number => 1.0,
1324: p_return_status => l_return_status,
1325: p_application_id => p_application_id)) then
1326: l_error := TRUE;
3370: p_defaulting_api_pkg => p_defaulting_api_pkg,
3371: p_defaulting_api_proc => p_defaulting_api_proc,
3372: p_validation_api_pkg => p_validation_api_pkg,
3373: p_validation_api_proc => p_validation_api_proc,
3374: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
3375: p_pass => p_pass
3376: ) then
3377: -- Do not raise an error if it's the first pass
3378: if (p_pass = 1) then
3499: -- old jlt files didn't have who columns and IS_UPDATEABLE
3500: -- calls SET_WHO which populates those columns, for later
3501: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
3502:
3503: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
3504: p_loader_timestamp => p_loader_timestamp,
3505: p_created_by => l_created_by,
3506: p_creation_date => l_creation_date,
3507: p_last_updated_by => l_last_updated_by,
3884: p_validation_api_pkg => p_validation_api_pkg,
3885: p_validation_api_proc => p_validation_api_proc,
3886: p_attribute_label_long => p_attribute_label_long,
3887: p_attribute_label_short => p_attribute_label_short,
3888: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
3889: p_pass => p_pass
3890: ) then
3891: -- dbms_output.put_line(l_api_name || 'validation failed');
3892: -- Do not raise an error if it's the first pass
4054: -- old jlt files didn't have who columns and IS_UPDATEABLE
4055: -- calls SET_WHO which populates those columns, for later
4056: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
4057:
4058: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4059: p_loader_timestamp => p_loader_timestamp,
4060: p_created_by => l_created_by,
4061: p_creation_date => l_creation_date,
4062: p_last_updated_by => l_last_updated_by,
4441: p_value_date => p_value_date,
4442: p_value_number => p_value_number,
4443: p_to_region_appl_id => p_to_region_appl_id,
4444: p_to_region_code => p_to_region_code,
4445: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
4446: p_pass => p_pass
4447: ) then
4448: -- Do not raise an error if it's the first pass
4449: if (p_pass = 1) then
4545: -- old jlt files didn't have who columns and IS_UPDATEABLE
4546: -- calls SET_WHO which populates those columns, for later
4547: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
4548:
4549: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4550: p_loader_timestamp => p_loader_timestamp,
4551: p_created_by => l_created_by,
4552: p_creation_date => l_creation_date,
4553: p_last_updated_by => l_last_updated_by,
4825: p_key_value10 => p_key_value10,
4826: p_value_varchar2 => p_value_varchar2,
4827: p_value_date => p_value_date,
4828: p_value_number => p_value_number,
4829: p_caller => AK_ON_OBJECTS_PVT.G_CREATE
4830: ) then
4831: -- dbms_output.put_line('validation failed');
4832: raise FND_API.G_EXC_ERROR;
4833: end if;
4907: -- old jlt files didn't have who columns and IS_UPDATEABLE
4908: -- calls SET_WHO which populates those columns, for later
4909: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
4910:
4911: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4912: p_loader_timestamp => p_loader_timestamp,
4913: p_created_by => l_created_by,
4914: p_creation_date => l_creation_date,
4915: p_last_updated_by => l_last_updated_by,