DBA Data[Home] [Help]

APPS.BIS_RESPONSIBILITY_PUB dependencies on FND_MSG_PUB

Line 98: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

94: IF(cResponsibility%ISOPEN) THEN
95: CLOSE cResponsibility;
96: END IF;
97: x_return_status := FND_API.G_RET_STS_ERROR;
98: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
99: ,p_count => x_msg_count
100: ,p_data => x_msg_data);
101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
102: IF(cResponsibility%ISOPEN) THEN

Line 106: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

102: IF(cResponsibility%ISOPEN) THEN
103: CLOSE cResponsibility;
104: END IF;
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
106: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
107: ,p_count => x_msg_count
108: ,p_data => x_msg_data);
109: WHEN NO_DATA_FOUND THEN
110: IF(cResponsibility%ISOPEN) THEN

Line 114: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

110: IF(cResponsibility%ISOPEN) THEN
111: CLOSE cResponsibility;
112: END IF;
113: x_return_status := FND_API.G_RET_STS_ERROR;
114: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
115: ,p_count => x_msg_count
116: ,p_data => x_msg_data);
117: WHEN OTHERS THEN
118: IF(cResponsibility%ISOPEN) THEN

Line 123: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

119: CLOSE cResponsibility;
120: END IF;
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
122:
123: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
124: ,p_count => x_msg_count
125: ,p_data => x_msg_data);
126: IF (x_msg_data IS NULL) THEN
127: x_msg_data := SQLERRM;

Line 150: fnd_msg_pub.initialize;

146: FOR UPDATE OF menu_id NOWAIT;
147:
148: BEGIN
149:
150: fnd_msg_pub.initialize;
151:
152: SAVEPOINT SP_LOCK_ROW;
153:
154: IF cResponsibility%ISOPEN THEN

Line 162: FND_MSG_PUB.ADD;

158: FETCH cResponsibility INTO l_last_update_date;
159:
160: IF (cResponsibility%NOTFOUND) THEN
161: FND_MESSAGE.SET_NAME('BIS','BIS_RESP_DELETED_ERROR');
162: FND_MSG_PUB.ADD;
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:
166: IF p_last_update_date IS NOT NULL THEN

Line 169: FND_MSG_PUB.ADD;

165:
166: IF p_last_update_date IS NOT NULL THEN
167: IF p_last_update_date <> l_last_update_date THEN
168: FND_MESSAGE.SET_NAME('BIS','BIS_RESP_CHANGED_ERROR');
169: FND_MSG_PUB.ADD;
170: RAISE FND_API.G_EXC_ERROR;
171: END IF;
172: END IF;
173:

Line 186: FND_MSG_PUB.ADD;

182: CLOSE cResponsibility;
183: END IF;
184: ROLLBACK TO SP_LOCK_ROW;
185: FND_MESSAGE.SET_NAME('BIS','BIS_RESP_LOCKED_ERROR');
186: FND_MSG_PUB.ADD;
187: RAISE FND_API.G_EXC_ERROR;
188: END LOCK_ROW;
189:
190: END BIS_RESPONSIBILITY_PUB;