DBA Data[Home] [Help]

APPS.EGO_ITEM_AML_PUB dependencies on FND_MESSAGE

Line 206: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');

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;

Line 207: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);

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

Line 623: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

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;

Line 624: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

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

Line 625: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

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

Line 626: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

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);

Line 746: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

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;

Line 747: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

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

Line 748: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

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

Line 749: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

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);

Line 1351: fnd_message.set_name('EGO',l_message_name);

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;

Line 1352: fnd_message.set_token('MFG_NAME',l_mfg_name);

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

Line 1353: x_message_text := fnd_message.get();

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

Line 1358: fnd_message.set_name('EGO', 'EGO_PLSQL_ERR');

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';

Line 1359: fnd_message.set_token('PKG_NAME', G_PKG_NAME);

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;

Line 1360: fnd_message.set_token('API_NAME', l_api_name);

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;

Line 1361: fnd_message.set_token('SQL_ERR_MSG', SQLERRM);

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:

Line 1363: x_message_text := fnd_message.get;

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;