79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81: --msg('insitializing message list');
82: IF FND_API.to_Boolean( p_init_msg_list ) THEN
83: FND_MSG_PUB.initialize;
84: END IF;
85: --msg('validating parameters');
86: -- Validate the parameters passed.
87: IF (p_organization_id IS NULL) THEN
85: --msg('validating parameters');
86: -- Validate the parameters passed.
87: IF (p_organization_id IS NULL) THEN
88: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_ASSET_ORG_ID_REQ');
89: FND_MSG_PUB.Add;
90: x_return_status := FND_API.G_RET_STS_ERROR;
91: ELSIF (p_competence_type IS NULL AND p_competence_id IS NULL AND
92: p_person_id IS NULL AND p_resource_id IS NULL AND p_department_id IS NULL) THEN
93:
91: ELSIF (p_competence_type IS NULL AND p_competence_id IS NULL AND
92: p_person_id IS NULL AND p_resource_id IS NULL AND p_department_id IS NULL) THEN
93:
94: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCH_DEP_RES');
95: FND_MSG_PUB.Add;
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: ELSE
98: IF (p_horizon_start_date IS NULL OR p_horizon_end_date IS NULL) THEN
99: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCH_DATE_MISS');
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: ELSE
98: IF (p_horizon_start_date IS NULL OR p_horizon_end_date IS NULL) THEN
99: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCH_DATE_MISS');
100: FND_MSG_PUB.Add;
101: x_return_status := FND_API.G_RET_STS_ERROR;
102: ELSIF (p_horizon_start_date > p_horizon_end_date) THEN
103: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCHED_DT_ERROR');
104: FND_MSG_PUB.Add;
100: FND_MSG_PUB.Add;
101: x_return_status := FND_API.G_RET_STS_ERROR;
102: ELSIF (p_horizon_start_date > p_horizon_end_date) THEN
103: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCHED_DT_ERROR');
104: FND_MSG_PUB.Add;
105: x_return_status := FND_API.G_RET_STS_ERROR;
106: END IF;
107: END IF;
108:
105: x_return_status := FND_API.G_RET_STS_ERROR;
106: END IF;
107: END IF;
108:
109: FND_MSG_PUB.count_and_get(
110: p_encoded => FND_API.G_FALSE,
111: p_count => x_msg_count,
112: p_data => x_msg_data
113: );
115: IF x_msg_count > 0
116: THEN
117: FOR indexCount IN 1..x_msg_count
118: LOOP
119: l_msg_data := FND_MSG_PUB.get(indexCount, FND_API.G_FALSE);
120: --msg(indexCount ||'-'||l_msg_data);
121: END LOOP;
122: END IF;
123:
148: EXCEPTION
149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
150: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
152: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
153: FND_MSG_PUB.Count_And_Get(
154: p_count => x_msg_count,
155: p_data => x_msg_data);
156:
149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
150: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
152: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
153: FND_MSG_PUB.Count_And_Get(
154: p_count => x_msg_count,
155: p_data => x_msg_data);
156:
157: WHEN NO_DATA_FOUND THEN
156:
157: WHEN NO_DATA_FOUND THEN
158: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
159: x_return_status := FND_API.G_RET_STS_ERROR ;
160: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
161: FND_MSG_PUB.Count_And_Get(
162: p_count => x_msg_count,
163: p_data => x_msg_data);
164:
157: WHEN NO_DATA_FOUND THEN
158: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
159: x_return_status := FND_API.G_RET_STS_ERROR ;
160: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
161: FND_MSG_PUB.Count_And_Get(
162: p_count => x_msg_count,
163: p_data => x_msg_data);
164:
165: END Get_Emp_Search_Results_Pub;
194: THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: END IF;
197: IF FND_API.to_Boolean( p_init_msg_list ) THEN
198: FND_MSG_PUB.initialize;
199: END IF;
200:
201: --validate the parameters passed
202: IF (p_organization_id IS NULL) THEN
200:
201: --validate the parameters passed
202: IF (p_organization_id IS NULL) THEN
203: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_ASSET_ORG_ID_REQ');
204: FND_MSG_PUB.Add;
205: x_return_status := FND_API.G_RET_STS_ERROR;
206: ELSIF (p_person_id IS NULL) THEN
207: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCH_PERSON_MISS');
208: FND_MSG_PUB.Add;
204: FND_MSG_PUB.Add;
205: x_return_status := FND_API.G_RET_STS_ERROR;
206: ELSIF (p_person_id IS NULL) THEN
207: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCH_PERSON_MISS');
208: FND_MSG_PUB.Add;
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: ELSE
211: IF (p_horizon_start_date IS NULL OR p_horizon_end_date IS NULL) THEN
212: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCH_DATE_MISS');
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: ELSE
211: IF (p_horizon_start_date IS NULL OR p_horizon_end_date IS NULL) THEN
212: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCH_DATE_MISS');
213: FND_MSG_PUB.Add;
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: ELSIF (p_horizon_start_date > p_horizon_end_date) THEN
216: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCHED_DT_ERROR');
217: FND_MSG_PUB.Add;
213: FND_MSG_PUB.Add;
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: ELSIF (p_horizon_start_date > p_horizon_end_date) THEN
216: FND_MESSAGE.SET_NAME ( 'EAM' , 'EAM_EMPSCHED_DT_ERROR');
217: FND_MSG_PUB.Add;
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: END IF;
220: END IF;
221:
235: EXCEPTION
236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
237: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
239: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
240: FND_MSG_PUB.Count_And_Get(
241: p_count => x_msg_count,
242: p_data => x_msg_data);
243:
236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
237: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
239: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
240: FND_MSG_PUB.Count_And_Get(
241: p_count => x_msg_count,
242: p_data => x_msg_data);
243:
244: WHEN NO_DATA_FOUND THEN
243:
244: WHEN NO_DATA_FOUND THEN
245: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
246: x_return_status := FND_API.G_RET_STS_ERROR ;
247: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
248: FND_MSG_PUB.Count_And_Get(
249: p_count => x_msg_count,
250: p_data => x_msg_data);
251:
244: WHEN NO_DATA_FOUND THEN
245: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
246: x_return_status := FND_API.G_RET_STS_ERROR ;
247: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
248: FND_MSG_PUB.Count_And_Get(
249: p_count => x_msg_count,
250: p_data => x_msg_data);
251:
252: END Get_Emp_Assignment_Details_Pub;
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: END IF;
930: -- Initialize message list if p_init_msg_list is set to TRUE.
931: IF FND_API.to_Boolean( p_init_msg_list ) THEN
932: FND_MSG_PUB.initialize;
933: END IF;
934: -- Initialize API return status to success
935: x_return_status := FND_API.g_ret_sts_success;
936: --msg('Getting the calndar code.p_organization_id==>' ||p_organization_id);
1204: EXCEPTION
1205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1206: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1208: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1209: FND_MSG_PUB.Count_And_Get(
1210: p_count => x_msg_count,
1211: p_data => x_msg_data);
1212: WHEN NO_DATA_FOUND THEN
1205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1206: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1208: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1209: FND_MSG_PUB.Count_And_Get(
1210: p_count => x_msg_count,
1211: p_data => x_msg_data);
1212: WHEN NO_DATA_FOUND THEN
1213: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1211: p_data => x_msg_data);
1212: WHEN NO_DATA_FOUND THEN
1213: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1214: x_return_status := FND_API.G_RET_STS_ERROR ;
1215: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1216: FND_MSG_PUB.Count_And_Get(
1217: p_count => x_msg_count,
1218: p_data => x_msg_data);
1219: END Get_Emp_Search_Results_Pvt;
1212: WHEN NO_DATA_FOUND THEN
1213: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1214: x_return_status := FND_API.G_RET_STS_ERROR ;
1215: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1216: FND_MSG_PUB.Count_And_Get(
1217: p_count => x_msg_count,
1218: p_data => x_msg_data);
1219: END Get_Emp_Search_Results_Pvt;
1220:
1254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1255: END IF;
1256:
1257: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1258: FND_MSG_PUB.initialize;
1259: END IF;
1260: x_return_status := FND_API.g_ret_sts_success;
1261: --copy the contents into the global temporary table
1262: DELETE FROM Eam_Emp_Assignment_Details_Tbl ;
1362: EXCEPTION
1363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1364: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1366: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1367: FND_MSG_PUB.Count_And_Get(
1368: p_count => x_msg_count,
1369: p_data => x_msg_data);
1370: WHEN NO_DATA_FOUND THEN
1363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1364: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1366: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1367: FND_MSG_PUB.Count_And_Get(
1368: p_count => x_msg_count,
1369: p_data => x_msg_data);
1370: WHEN NO_DATA_FOUND THEN
1371: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1369: p_data => x_msg_data);
1370: WHEN NO_DATA_FOUND THEN
1371: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1372: x_return_status := FND_API.G_RET_STS_ERROR ;
1373: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1374: FND_MSG_PUB.Count_And_Get(
1375: p_count => x_msg_count,
1376: p_data => x_msg_data);
1377: END Get_Emp_Assignment_Details_Pvt;
1370: WHEN NO_DATA_FOUND THEN
1371: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1372: x_return_status := FND_API.G_RET_STS_ERROR ;
1373: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1374: FND_MSG_PUB.Count_And_Get(
1375: p_count => x_msg_count,
1376: p_data => x_msg_data);
1377: END Get_Emp_Assignment_Details_Pvt;
1378: