DBA Data[Home] [Help]

APPS.IBC_STYLESHEETS_GRP dependencies on FND_PROFILE

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

90: FETCH Get_Citem_Version INTO l_start_date, l_end_date;
91: CLOSE Get_Citem_Version;
92:
93: -- Check Profile if availabe date is enforced
94: IF (FND_PROFILE.Value('IBC_ENFORCE_AVAILABLE_DATE') IS NULL) OR
95: (FND_PROFILE.Value('IBC_ENFORCE_AVAILABLE_DATE') = 'Y') THEN
96: IF (NVL(l_start_date, SYSDATE) > SYSDATE) THEN
97: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
98: FND_MESSAGE.Set_Name('IBC', 'IBC_STYLESHEET_NOT_AVAILABLE');

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

91: CLOSE Get_Citem_Version;
92:
93: -- Check Profile if availabe date is enforced
94: IF (FND_PROFILE.Value('IBC_ENFORCE_AVAILABLE_DATE') IS NULL) OR
95: (FND_PROFILE.Value('IBC_ENFORCE_AVAILABLE_DATE') = 'Y') THEN
96: IF (NVL(l_start_date, SYSDATE) > SYSDATE) THEN
97: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
98: FND_MESSAGE.Set_Name('IBC', 'IBC_STYLESHEET_NOT_AVAILABLE');
99: FND_MESSAGE.Set_token('STYLESHEET_ITEM_ID', p_stylesheet_item_id);

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

104: END IF;
105: END IF;
106:
107: -- Check Profile if expiration date is enforced
108: IF (FND_PROFILE.Value('IBC_ENFORCE_EXPIRATION_DATE') IS NULL) OR
109: (FND_PROFILE.Value('IBC_ENFORCE_EXPIRATION_DATE') = 'Y') THEN
110: IF (NVL(l_end_date, SYSDATE) < SYSDATE) THEN
111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
112: FND_MESSAGE.Set_Name('IBC', 'IBC_STYLESHEET_EXPIRED');

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

105: END IF;
106:
107: -- Check Profile if expiration date is enforced
108: IF (FND_PROFILE.Value('IBC_ENFORCE_EXPIRATION_DATE') IS NULL) OR
109: (FND_PROFILE.Value('IBC_ENFORCE_EXPIRATION_DATE') = 'Y') THEN
110: IF (NVL(l_end_date, SYSDATE) < SYSDATE) THEN
111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
112: FND_MESSAGE.Set_Name('IBC', 'IBC_STYLESHEET_EXPIRED');
113: FND_MESSAGE.Set_token('STYLESHEET_ITEM_ID', p_stylesheet_item_id);