DBA Data[Home] [Help]

APPS.AHL_MC_PATH_POSITION_PUB dependencies on FND_MSG_PUB

Line 67: FND_MSG_PUB.Initialize;

63: END IF;
64:
65: -- Initialize message list if p_init_msg_list is set to TRUE
66: IF FND_API.To_Boolean(p_init_msg_list) THEN
67: FND_MSG_PUB.Initialize;
68: END IF;
69:
70: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
71: FND_LOG.string(FND_LOG.level_statement, l_full_name,

Line 79: FND_MSG_PUB.ADD;

75: -- check for path position table
76: IF (p_path_position_tbl.COUNT < 1) THEN
77: -- input is NULL
78: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PATH_POS_TBL_NULL');
79: FND_MSG_PUB.ADD;
80: RAISE FND_API.G_EXC_ERROR;
81: END IF;
82:
83: -- call Convert_Path_Pos_Values_to_Id

Line 124: FND_MSG_PUB.Count_And_Get

120: COMMIT WORK;
121: END IF;
122:
123: -- Standard call to get message count and if count is 1, get message info
124: FND_MSG_PUB.Count_And_Get
125: ( p_count => x_msg_count,
126: p_data => x_msg_data,
127: p_encoded => FND_API.G_FALSE
128: );

Line 138: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

134: EXCEPTION
135: WHEN FND_API.G_EXC_ERROR THEN
136: Rollback to Create_Position_ID_Pub;
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
139: p_data => x_msg_data,
140: p_encoded => fnd_api.g_false);
141:
142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 145: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

141:
142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143: Rollback to Create_Position_ID_Pub;
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
146: p_data => x_msg_data,
147: p_encoded => fnd_api.g_false);
148:
149: WHEN OTHERS THEN

Line 152: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => G_PKG_NAME,

148:
149: WHEN OTHERS THEN
150: Rollback to Create_Position_ID_Pub;
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => G_PKG_NAME,
153: p_procedure_name => l_api_name,
154: p_error_text => SQLERRM);
155: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
156: p_data => x_msg_data,

Line 155: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => G_PKG_NAME,
153: p_procedure_name => l_api_name,
154: p_error_text => SQLERRM);
155: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
156: p_data => x_msg_data,
157: p_encoded => FND_API.G_FALSE);
158:
159: END Create_Position_ID;

Line 232: FND_MSG_PUB.ADD;

228: -- check for mc_name
229: IF (l_path_position_tbl(i).mc_name IS NULL) THEN
230: -- input is NULL
231: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_ID_NULL');
232: FND_MSG_PUB.ADD;
233: l_validation_failed_flag := 'Y';
234: ELSE
235: OPEN chk_mc_name_csr(l_path_position_tbl(i).mc_name);
236: FETCH chk_mc_name_csr INTO l_mc_id;

Line 242: FND_MSG_PUB.ADD;

238: IF (chk_mc_name_csr%NOTFOUND) THEN
239: -- input is invalid
240: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_ID_NAME_INV');
241: FND_MESSAGE.Set_Token('MC_NAME', l_path_position_tbl(i).mc_name);
242: FND_MSG_PUB.ADD;
243: l_validation_failed_flag := 'Y';
244: END IF;
245:
246: -- set the mc_id

Line 259: FND_MSG_PUB.ADD;

255: IF (chk_mc_id_csr%NOTFOUND) THEN
256: -- input is invalid
257: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_ID_INV');
258: FND_MESSAGE.Set_Token('MC_ID', l_path_position_tbl(i).mc_id);
259: FND_MSG_PUB.ADD;
260: l_validation_failed_flag := 'Y';
261: END IF;
262:
263: CLOSE chk_mc_id_csr;

Line 280: FND_MSG_PUB.ADD;

276: -- input is invalid
277: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_REV_INV');
278: FND_MESSAGE.Set_Token('MC_ID', l_path_position_tbl(i).mc_id);
279: FND_MESSAGE.Set_Token('MC_REV', l_path_position_tbl(i).mc_revision);
280: FND_MSG_PUB.ADD;
281: l_validation_failed_flag := 'Y';
282: END IF;
283:
284: -- set the version_number

Line 298: FND_MSG_PUB.ADD;

294: -- input is invalid
295: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_VER_NO_INV');
296: FND_MESSAGE.Set_Token('MC_ID', l_path_position_tbl(i).mc_id);
297: FND_MESSAGE.Set_Token('MC_VER_NO', l_path_position_tbl(i).version_number);
298: FND_MSG_PUB.ADD;
299: l_validation_failed_flag := 'Y';
300: END IF;
301:
302: CLOSE chk_mc_ver_no_csr;