60: END IF;
61:
62: -- Initialize message list if p_init_msg_list is set to TRUE
63: IF FND_API.To_Boolean(p_init_msg_list) THEN
64: FND_MSG_PUB.Initialize;
65: END IF;
66:
67: --Check if there are any projects referred by changes
68: open check_project_used(p_project_id);
75:
76: IF (l_message IS NOT NULL)
77: THEN
78: FND_MESSAGE.Set_Name(g_app_name, l_message);
79: FND_MSG_PUB.Add;
80: FND_MSG_PUB.Count_And_Get(
81: p_encoded => FND_API.G_FALSE,
82: p_count => x_msg_count,
83: p_data => x_msg_data
76: IF (l_message IS NOT NULL)
77: THEN
78: FND_MESSAGE.Set_Name(g_app_name, l_message);
79: FND_MSG_PUB.Add;
80: FND_MSG_PUB.Count_And_Get(
81: p_encoded => FND_API.G_FALSE,
82: p_count => x_msg_count,
83: p_data => x_msg_data
84: );
94: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
95: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
96: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
97: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
98: FND_MSG_PUB.Add;
99: FND_MSG_PUB.Count_And_Get(
100: p_encoded => FND_API.G_FALSE,
101: p_count => x_msg_count,
102: p_data => x_msg_data
95: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
96: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
97: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
98: FND_MSG_PUB.Add;
99: FND_MSG_PUB.Count_And_Get(
100: p_encoded => FND_API.G_FALSE,
101: p_count => x_msg_count,
102: p_data => x_msg_data
103: );
146: END IF;
147:
148: -- Initialize message list if p_init_msg_list is set to TRUE
149: IF FND_API.To_Boolean(p_init_msg_list) THEN
150: FND_MSG_PUB.Initialize;
151: END IF;
152:
153: --Check if there are any projects referred by changes
154: open check_task_used(p_task_id);
161:
162: IF (l_message IS NOT NULL)
163: THEN
164: FND_MESSAGE.Set_Name(g_app_name, l_message);
165: FND_MSG_PUB.Add;
166: FND_MSG_PUB.Count_And_Get(
167: p_encoded => FND_API.G_FALSE,
168: p_count => x_msg_count,
169: p_data => x_msg_data
162: IF (l_message IS NOT NULL)
163: THEN
164: FND_MESSAGE.Set_Name(g_app_name, l_message);
165: FND_MSG_PUB.Add;
166: FND_MSG_PUB.Count_And_Get(
167: p_encoded => FND_API.G_FALSE,
168: p_count => x_msg_count,
169: p_data => x_msg_data
170: );
180: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
181: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
182: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
183: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
184: FND_MSG_PUB.Add;
185: FND_MSG_PUB.Count_And_Get(
186: p_encoded => FND_API.G_FALSE,
187: p_count => x_msg_count,
188: p_data => x_msg_data
181: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
182: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
183: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
184: FND_MSG_PUB.Add;
185: FND_MSG_PUB.Count_And_Get(
186: p_encoded => FND_API.G_FALSE,
187: p_count => x_msg_count,
188: p_data => x_msg_data
189: );