DBA Data[Home] [Help]

APPS.AK_KEY_PVT dependencies on AK_ON_OBJECTS_PVT

Line 139: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,

135: p_foreign_key_name => p_foreign_key_name,
136: p_database_object_name => p_database_object_name,
137: p_unique_key_name => p_unique_key_name,
138: p_application_id => p_application_id,
139: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
140: p_pass => p_pass
141: ) then
142: --dbms_output.put_line(l_api_name || 'validation failed');
143: raise FND_API.G_EXC_ERROR;

Line 254: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

250: -- old jlt files didn't have who columns and IS_UPDATEABLE
251: -- calls SET_WHO which populates those columns, for later
252: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
253:
254: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
255: p_loader_timestamp => p_loader_timestamp,
256: p_created_by => l_created_by,
257: p_creation_date => l_creation_date,
258: p_last_updated_by => l_last_updated_by,

Line 546: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,

542: p_foreign_key_name => p_foreign_key_name,
543: p_attribute_application_id => p_attribute_application_id,
544: p_attribute_code => p_attribute_code,
545: p_foreign_key_sequence => p_foreign_key_sequence,
546: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
547: p_pass => p_pass
548: ) then
549: raise FND_API.G_EXC_ERROR;
550: end if;

Line 645: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

641: -- old jlt files didn't have who columns and IS_UPDATEABLE
642: -- calls SET_WHO which populates those columns, for later
643: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
644:
645: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
646: p_loader_timestamp => p_loader_timestamp,
647: p_created_by => l_created_by,
648: p_creation_date => l_creation_date,
649: p_last_updated_by => l_last_updated_by,

Line 895: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,

891: p_return_status => l_return_status,
892: p_unique_key_name => p_unique_key_name,
893: p_database_object_name => p_database_object_name,
894: p_application_id => p_application_id,
895: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
896: p_pass => p_pass
897: ) then
898: raise FND_API.G_EXC_ERROR;
899: end if;

Line 994: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

990: -- old jlt files didn't have who columns and IS_UPDATEABLE
991: -- calls SET_WHO which populates those columns, for later
992: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
993:
994: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
995: p_loader_timestamp => p_loader_timestamp,
996: p_created_by => l_created_by,
997: p_creation_date => l_creation_date,
998: p_last_updated_by => l_last_updated_by,

Line 1232: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,

1228: p_unique_key_name => p_unique_key_name,
1229: p_attribute_application_id => p_attribute_application_id,
1230: p_attribute_code => p_attribute_code,
1231: p_unique_key_sequence => p_unique_key_sequence,
1232: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
1233: p_pass => p_pass
1234: ) then
1235: raise FND_API.G_EXC_ERROR;
1236: end if;

Line 1332: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

1328: -- old jlt files didn't have who columns and IS_UPDATEABLE
1329: -- calls SET_WHO which populates those columns, for later
1330: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
1331:
1332: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
1333: p_loader_timestamp => p_loader_timestamp,
1334: p_created_by => l_created_by,
1335: p_creation_date => l_creation_date,
1336: p_last_updated_by => l_last_updated_by,

Line 2702: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,

2698: p_from_to_name => p_from_to_name,
2699: p_from_to_description => p_from_to_description,
2700: p_to_from_name => p_to_from_name,
2701: p_to_from_description => p_to_from_description,
2702: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
2703: p_pass => p_pass
2704: ) then
2705: --dbms_output.put_line(l_api_name || ' validation failed');
2706: raise FND_API.G_EXC_ERROR;

Line 2824: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

2820: if (p_last_update_login <> FND_API.G_MISS_NUM) then
2821: l_last_update_login := p_last_update_login;
2822: end if;
2823:
2824: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
2825: p_loader_timestamp => p_loader_timestamp,
2826: p_created_by => l_created_by,
2827: p_creation_date => l_creation_date,
2828: p_last_updated_by => l_last_updated_by,

Line 3051: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,

3047: p_foreign_key_name => p_foreign_key_name,
3048: p_attribute_application_id => p_attribute_application_id,
3049: p_attribute_code => p_attribute_code,
3050: p_foreign_key_sequence => p_foreign_key_sequence,
3051: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
3052: p_pass => p_pass
3053: ) then
3054: raise FND_API.G_EXC_ERROR;
3055: end if;

Line 3148: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

3144: if (p_last_update_login <> FND_API.G_MISS_NUM) then
3145: l_last_update_login := p_last_update_login;
3146: end if;
3147:
3148: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
3149: p_loader_timestamp => p_loader_timestamp,
3150: p_created_by => l_created_by,
3151: p_creation_date => l_creation_date,
3152: p_last_updated_by => l_last_updated_by,

Line 3359: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,

3355: p_return_status => l_return_status,
3356: p_unique_key_name => p_unique_key_name,
3357: p_database_object_name => p_database_object_name,
3358: p_application_id => p_application_id,
3359: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
3360: p_pass => p_pass
3361: ) then
3362: --dbms_output.put_line(l_api_name || ' validation failed');
3363: raise FND_API.G_EXC_ERROR;

Line 3457: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

3453: if (p_last_update_login <> FND_API.G_MISS_NUM) then
3454: l_last_update_login := p_last_update_login;
3455: end if;
3456:
3457: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
3458: p_loader_timestamp => p_loader_timestamp,
3459: p_created_by => l_created_by,
3460: p_creation_date => l_creation_date,
3461: p_last_updated_by => l_last_updated_by,

Line 3664: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,

3660: p_unique_key_name => p_unique_key_name,
3661: p_attribute_application_id => p_attribute_application_id,
3662: p_attribute_code => p_attribute_code,
3663: p_unique_key_sequence => p_unique_key_sequence,
3664: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
3665: p_pass => p_pass
3666: ) then
3667: --dbms_output.put_line(l_api_name || ' validation failed');
3668: raise FND_API.G_EXC_ERROR;

Line 3759: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

3755: if (p_last_update_login <> FND_API.G_MISS_NUM) then
3756: l_last_update_login := p_last_update_login;
3757: end if;
3758:
3759: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
3760: p_loader_timestamp => p_loader_timestamp,
3761: p_created_by => l_created_by,
3762: p_creation_date => l_creation_date,
3763: p_last_updated_by => l_last_updated_by,

Line 3875: -- in package AK_ON_OBJECTS_PVT:

3871: -- validation tests are passed, or FALSE otherwise.
3872: -- Parameters Foreign Key columns
3873: -- p_caller : IN required
3874: -- Must be one of the following values defined
3875: -- in package AK_ON_OBJECTS_PVT:
3876: -- - G_CREATE (if calling from the Create API)
3877: -- - G_DOWNLOAD (if calling from the Download API)
3878: -- - G_UPDATE (if calling from the Update API)
3879: --

Line 3938: if (p_caller <> AK_ON_OBJECTS_PVT.G_DOWNLOAD) then

3934: --* (This check can be skipped if called from the download procedure
3935: --* which have already read the parent object.)
3936: --* (This check is only done if a view name is given, which may not
3937: --* be the case if called from the Update_Foreign_Key API.)
3938: if (p_caller <> AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
3939: if (p_database_object_name <> FND_API.G_MISS_CHAR) then
3940: if (NOT AK_OBJECT_PVT.OBJECT_EXISTS (
3941: p_api_version_number => 1.0,
3942: p_return_status => l_return_status,

Line 3958: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))

3954: --** check that required columns are not null and, unless calling **
3955: --** from UPDATE procedure, the columns are not missing **
3956: if ((p_database_object_name is null) or
3957: (p_database_object_name = FND_API.G_MISS_CHAR and
3958: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
3959: then
3960: l_error := TRUE;
3961: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
3962: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

Line 3970: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then

3966: end if;
3967:
3968: if ((p_unique_key_name is null) or
3969: (p_unique_key_name = FND_API.G_MISS_CHAR and
3970: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
3971: l_error := TRUE;
3972: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
3973: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
3974: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIQUE_KEY_NAME');

Line 3981: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then

3977: end if;
3978:
3979: if ((p_application_id is null) or
3980: (p_application_id = FND_API.G_MISS_NUM and
3981: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
3982: l_error := TRUE;
3983: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
3984: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
3985: FND_MESSAGE.SET_TOKEN('COLUMN', 'APPLICATION_ID');

Line 3993: if (NOT AK_ON_OBJECTS_PVT.VALID_APPLICATION_ID (

3989:
3990: --** Validate columns **
3991: -- - application ID
3992: if (p_application_id <> FND_API.G_MISS_NUM) then
3993: if (NOT AK_ON_OBJECTS_PVT.VALID_APPLICATION_ID (
3994: p_api_version_number => 1.0,
3995: p_return_status => l_return_status,
3996: p_application_id => p_application_id) ) then
3997: l_error := TRUE;

Line 4058: -- in package AK_ON_OBJECTS_PVT:

4054: -- validation tests are passed, or FALSE otherwise.
4055: -- Parameters Foreign Key Column columns
4056: -- p_caller : IN required
4057: -- Must be one of the following values defined
4058: -- in package AK_ON_OBJECTS_PVT:
4059: -- - G_CREATE (if calling from the Create API)
4060: -- - G_DOWNLOAD (if calling from the Download API)
4061: -- - G_UPDATE (if calling from the Update API)
4062: --

Line 4182: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))

4178: --** check that required columns are not null and, unless calling **
4179: --** from UPDATE procedure, the columns are not missing **
4180: if ((p_foreign_key_sequence is null) or
4181: (p_foreign_key_sequence = FND_API.G_MISS_NUM and
4182: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
4183: then
4184: l_error := TRUE;
4185: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4186: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

Line 4247: -- in package AK_ON_OBJECTS_PVT:

4243: -- validation tests are passed, or FALSE otherwise.
4244: -- Parameters Unique Key columns
4245: -- p_caller : IN required
4246: -- Must be one of the following values defined
4247: -- in package AK_ON_OBJECTS_PVT:
4248: -- - G_CREATE (if calling from the Create API)
4249: -- - G_DOWNLOAD (if calling from the Download API)
4250: -- - G_UPDATE (if calling from the Update API)
4251: --

Line 4305: if (p_caller <> AK_ON_OBJECTS_PVT.G_DOWNLOAD) then

4301: -- - Check that the parent object exists
4302: --* (This check can be skipped if called from the download procedure
4303: --* which have already read the parent object.)
4304: --* (This check will only be done if a view name is passed.)
4305: if (p_caller <> AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
4306: if (p_database_object_name <> FND_API.G_MISS_CHAR) then
4307: if (NOT AK_OBJECT_PVT.OBJECT_EXISTS (
4308: p_api_version_number => 1.0,
4309: p_return_status => l_return_status,

Line 4325: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then

4321: --** check that required columns are not null and, unless calling **
4322: --** from UPDATE procedure, the columns are not missing **
4323: if ((p_database_object_name is null) or
4324: (p_database_object_name = FND_API.G_MISS_CHAR and
4325: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
4326: l_error := TRUE;
4327: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4328: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4329: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');

Line 4336: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then

4332: end if;
4333:
4334: if ((p_application_id is null) or
4335: (p_application_id = FND_API.G_MISS_NUM and
4336: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
4337: l_error := TRUE;
4338: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4339: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4340: FND_MESSAGE.SET_TOKEN('COLUMN', 'APPLICATION_ID');

Line 4349: if (NOT AK_ON_OBJECTS_PVT.VALID_APPLICATION_ID (

4345:
4346: --** Validate columns **
4347: -- - application ID
4348: if (p_application_id <> FND_API.G_MISS_NUM) then
4349: if (NOT AK_ON_OBJECTS_PVT.VALID_APPLICATION_ID (
4350: p_api_version_number => 1.0,
4351: p_return_status => l_return_status,
4352: p_application_id => p_application_id) ) then
4353: l_error := TRUE;

Line 4399: -- in package AK_ON_OBJECTS_PVT:

4395: -- validation tests are passed, or FALSE otherwise.
4396: -- Parameters Unique Key Column columns
4397: -- p_caller : IN required
4398: -- Must be one of the following values defined
4399: -- in package AK_ON_OBJECTS_PVT:
4400: -- - G_CREATE (if calling from the Create API)
4401: -- - G_DOWNLOAD (if calling from the Download API)
4402: -- - G_UPDATE (if calling from the Update API)
4403: --

Line 4523: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))

4519: --** check that required columns are not null and, unless calling **
4520: --** from UPDATE procedure, the columns are not missing **
4521: if ((p_unique_key_sequence is null) or
4522: (p_unique_key_sequence = FND_API.G_MISS_NUM and
4523: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
4524: then
4525: l_error := TRUE;
4526: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4527: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');