202: G_PKG_NAME) THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;
205: IF (p_change_id IS NULL AND p_change_line_id IS NULL) THEN
206: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
207: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
208: fnd_msg_pub.add;
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: x_msg_count := 1;
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;
205: IF (p_change_id IS NULL AND p_change_line_id IS NULL) THEN
206: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
207: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
208: fnd_msg_pub.add;
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: x_msg_count := 1;
211: fnd_msg_pub.Count_And_Get
619: ,p_message => 'Exception '||SQLERRM
620: );
621: x_return_status := G_RET_STS_UNEXP_ERROR;
622: -- for PL/SQL errors
623: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
624: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
625: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
626: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
627: FND_MSG_PUB.Add;
620: );
621: x_return_status := G_RET_STS_UNEXP_ERROR;
622: -- for PL/SQL errors
623: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
624: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
625: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
626: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
627: FND_MSG_PUB.Add;
628: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
621: x_return_status := G_RET_STS_UNEXP_ERROR;
622: -- for PL/SQL errors
623: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
624: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
625: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
626: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
627: FND_MSG_PUB.Add;
628: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
629: ,p_count => x_msg_count
622: -- for PL/SQL errors
623: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
624: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
625: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
626: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
627: FND_MSG_PUB.Add;
628: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
629: ,p_count => x_msg_count
630: ,p_data => x_msg_data);
742: ROLLBACK TO DELETE_AML_PENDING_CHANGES;
743: END IF;
744: x_return_status := G_RET_STS_UNEXP_ERROR;
745: -- for PL/SQL errors
746: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
747: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
748: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
749: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
750: FND_MSG_PUB.Add;
743: END IF;
744: x_return_status := G_RET_STS_UNEXP_ERROR;
745: -- for PL/SQL errors
746: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
747: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
748: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
749: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
750: FND_MSG_PUB.Add;
751: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
744: x_return_status := G_RET_STS_UNEXP_ERROR;
745: -- for PL/SQL errors
746: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
747: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
748: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
749: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
750: FND_MSG_PUB.Add;
751: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
752: ,p_count => x_msg_count
745: -- for PL/SQL errors
746: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
747: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
748: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
749: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
750: FND_MSG_PUB.Add;
751: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
752: ,p_count => x_msg_count
753: ,p_data => x_msg_data);
1347: WHEN OTHERS THEN
1348: l_mfg_name := NULL;
1349: END;
1350: x_message_name := l_message_name;
1351: fnd_message.set_name('EGO',l_message_name);
1352: fnd_message.set_token('MFG_NAME',l_mfg_name);
1353: x_message_text := fnd_message.get();
1354: x_return_status := G_EGO_SHORT_NO;
1355: END IF;
1348: l_mfg_name := NULL;
1349: END;
1350: x_message_name := l_message_name;
1351: fnd_message.set_name('EGO',l_message_name);
1352: fnd_message.set_token('MFG_NAME',l_mfg_name);
1353: x_message_text := fnd_message.get();
1354: x_return_status := G_EGO_SHORT_NO;
1355: END IF;
1356: EXCEPTION
1349: END;
1350: x_message_name := l_message_name;
1351: fnd_message.set_name('EGO',l_message_name);
1352: fnd_message.set_token('MFG_NAME',l_mfg_name);
1353: x_message_text := fnd_message.get();
1354: x_return_status := G_EGO_SHORT_NO;
1355: END IF;
1356: EXCEPTION
1357: WHEN OTHERS THEN
1354: x_return_status := G_EGO_SHORT_NO;
1355: END IF;
1356: EXCEPTION
1357: WHEN OTHERS THEN
1358: fnd_message.set_name('EGO', 'EGO_PLSQL_ERR');
1359: fnd_message.set_token('PKG_NAME', G_PKG_NAME);
1360: fnd_message.set_token('API_NAME', l_api_name);
1361: fnd_message.set_token('SQL_ERR_MSG', SQLERRM);
1362: x_message_name := 'EGO_PLSQL_ERR';
1355: END IF;
1356: EXCEPTION
1357: WHEN OTHERS THEN
1358: fnd_message.set_name('EGO', 'EGO_PLSQL_ERR');
1359: fnd_message.set_token('PKG_NAME', G_PKG_NAME);
1360: fnd_message.set_token('API_NAME', l_api_name);
1361: fnd_message.set_token('SQL_ERR_MSG', SQLERRM);
1362: x_message_name := 'EGO_PLSQL_ERR';
1363: x_message_text := fnd_message.get;
1356: EXCEPTION
1357: WHEN OTHERS THEN
1358: fnd_message.set_name('EGO', 'EGO_PLSQL_ERR');
1359: fnd_message.set_token('PKG_NAME', G_PKG_NAME);
1360: fnd_message.set_token('API_NAME', l_api_name);
1361: fnd_message.set_token('SQL_ERR_MSG', SQLERRM);
1362: x_message_name := 'EGO_PLSQL_ERR';
1363: x_message_text := fnd_message.get;
1364: END Check_No_MFG_Associations;
1357: WHEN OTHERS THEN
1358: fnd_message.set_name('EGO', 'EGO_PLSQL_ERR');
1359: fnd_message.set_token('PKG_NAME', G_PKG_NAME);
1360: fnd_message.set_token('API_NAME', l_api_name);
1361: fnd_message.set_token('SQL_ERR_MSG', SQLERRM);
1362: x_message_name := 'EGO_PLSQL_ERR';
1363: x_message_text := fnd_message.get;
1364: END Check_No_MFG_Associations;
1365:
1359: fnd_message.set_token('PKG_NAME', G_PKG_NAME);
1360: fnd_message.set_token('API_NAME', l_api_name);
1361: fnd_message.set_token('SQL_ERR_MSG', SQLERRM);
1362: x_message_name := 'EGO_PLSQL_ERR';
1363: x_message_text := fnd_message.get;
1364: END Check_No_MFG_Associations;
1365:
1366: END EGO_ITEM_AML_PUB;