DBA Data[Home] [Help]

APPS.EAM_SAFETY_ASSET_NUMBER_PUB dependencies on FND_MSG_PUB

Line 67: FND_MSG_PUB.initialize;

63:
64: -- Initialize API return status to success
65: x_return_status := fnd_api.g_ret_sts_success;
66:
67: FND_MSG_PUB.initialize;
68:
69:
70: IF p_eAM_asset_safety_tbl.COUNT > 0 THEN
71:

Line 80: FND_MSG_PUB.ADD; */

76:
77: IF p_eAM_asset_safety_tbl(i).instance_id IS NULL
78: OR p_eAM_asset_safety_tbl(i).instance_id = FND_API.G_MISS_NUM THEN
79: /*FND_MESSAGE.SET_NAME('CSI','CSI_ASSET_NOT_NULL');
80: FND_MSG_PUB.ADD; */
81: x_return_status := FND_API.G_RET_STS_ERROR;
82: l_error_count:=l_error_count+1;
83: RAISE FND_API.G_EXC_ERROR;
84: END IF;

Line 122: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);

118: ,x_return_status => l_return_status
119: );
120:
121: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
122: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
123: l_error_count:=l_error_count+1;
124: -- Continue processing other records
125: RAISE FND_API.G_EXC_ERROR;
126: END IF;

Line 137: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);

133: ,x_return_status => l_return_status
134: );
135:
136: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
137: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
138: l_error_count:=l_error_count+1;
139: RAISE FND_API.G_EXC_ERROR;
140: END IF;
141: END IF;

Line 163: FND_MSG_PUB.Count_And_Get

159:
160: WHEN FND_API.G_EXC_ERROR THEN
161: x_return_status := FND_API.G_RET_STS_ERROR ;
162: ROLLBACK TO CREATEUPDATE_ASSET_SAFETY_INFO;
163: FND_MSG_PUB.Count_And_Get
164: ( p_encoded => FND_API.G_FALSE,
165: p_count => x_msg_count,
166: p_data => x_msg_data
167: );

Line 172: FND_MSG_PUB.Count_And_Get

168:
169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171: ROLLBACK TO CREATEUPDATE_ASSET_SAFETY_INFO;
172: FND_MSG_PUB.Count_And_Get
173: ( p_encoded => FND_API.G_FALSE,
174: p_count => x_msg_count,
175: p_data => x_msg_data
176: );

Line 181: IF FND_MSG_PUB.Check_Msg_Level

177:
178: WHEN OTHERS THEN
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: ROLLBACK TO CREATEUPDATE_ASSET_SAFETY_INFO;
181: IF FND_MSG_PUB.Check_Msg_Level
182: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
183: THEN
184: FND_MSG_PUB.Add_Exc_Msg
185: (G_PKG_NAME,

Line 182: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

178: WHEN OTHERS THEN
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: ROLLBACK TO CREATEUPDATE_ASSET_SAFETY_INFO;
181: IF FND_MSG_PUB.Check_Msg_Level
182: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
183: THEN
184: FND_MSG_PUB.Add_Exc_Msg
185: (G_PKG_NAME,
186: l_api_name

Line 184: FND_MSG_PUB.Add_Exc_Msg

180: ROLLBACK TO CREATEUPDATE_ASSET_SAFETY_INFO;
181: IF FND_MSG_PUB.Check_Msg_Level
182: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
183: THEN
184: FND_MSG_PUB.Add_Exc_Msg
185: (G_PKG_NAME,
186: l_api_name
187: );
188: END IF;

Line 189: FND_MSG_PUB.Count_And_Get

185: (G_PKG_NAME,
186: l_api_name
187: );
188: END IF;
189: FND_MSG_PUB.Count_And_Get
190: ( p_encoded => FND_API.G_FALSE,
191: p_count => x_msg_count,
192: p_data => x_msg_data
193: );