DBA Data[Home] [Help]

APPS.IBC_CITEM_RUNTIME_PVT dependencies on FND_PROFILE

Line 143: IF (FND_PROFILE.Value('IBC_ENFORCE_AVAILABLE_DATE') IS NULL) OR

139: FETCH Get_Citem_Version INTO x_start_date, x_end_date, x_version_number;
140: CLOSE Get_Citem_Version;
141:
142: -- Check Profile if availabe date is enforced
143: IF (FND_PROFILE.Value('IBC_ENFORCE_AVAILABLE_DATE') IS NULL) OR
144: (FND_PROFILE.Value('IBC_ENFORCE_AVAILABLE_DATE') = 'Y') THEN
145: IF (NVL(x_start_date, SYSDATE) > SYSDATE) THEN
146: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
147: FND_MESSAGE.Set_Name('IBC', 'CITEM_NOT_YET_AVAILABLE');

Line 144: (FND_PROFILE.Value('IBC_ENFORCE_AVAILABLE_DATE') = 'Y') THEN

140: CLOSE Get_Citem_Version;
141:
142: -- Check Profile if availabe date is enforced
143: IF (FND_PROFILE.Value('IBC_ENFORCE_AVAILABLE_DATE') IS NULL) OR
144: (FND_PROFILE.Value('IBC_ENFORCE_AVAILABLE_DATE') = 'Y') THEN
145: IF (NVL(x_start_date, SYSDATE) > SYSDATE) THEN
146: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
147: FND_MESSAGE.Set_Name('IBC', 'CITEM_NOT_YET_AVAILABLE');
148: FND_MESSAGE.Set_token('CITEM_ID', p_content_item_id);

Line 157: IF (FND_PROFILE.Value('IBC_ENFORCE_EXPIRATION_DATE') IS NULL) OR

153: END IF;
154: END IF;
155:
156: -- Check Profile if expiration date is enforced
157: IF (FND_PROFILE.Value('IBC_ENFORCE_EXPIRATION_DATE') IS NULL) OR
158: (FND_PROFILE.Value('IBC_ENFORCE_EXPIRATION_DATE') = 'Y') THEN
159: IF (NVL(x_end_date, SYSDATE) < SYSDATE) THEN
160: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
161: FND_MESSAGE.Set_Name('IBC', 'CITEM_EXPIRED');

Line 158: (FND_PROFILE.Value('IBC_ENFORCE_EXPIRATION_DATE') = 'Y') THEN

154: END IF;
155:
156: -- Check Profile if expiration date is enforced
157: IF (FND_PROFILE.Value('IBC_ENFORCE_EXPIRATION_DATE') IS NULL) OR
158: (FND_PROFILE.Value('IBC_ENFORCE_EXPIRATION_DATE') = 'Y') THEN
159: IF (NVL(x_end_date, SYSDATE) < SYSDATE) THEN
160: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
161: FND_MESSAGE.Set_Name('IBC', 'CITEM_EXPIRED');
162: FND_MESSAGE.Set_token('CITEM_ID', p_content_item_id);