DBA Data[Home] [Help]

APPS.EAM_ASSIGN_EMP_PUB dependencies on FND_MSG_PUB

Line 83: FND_MSG_PUB.initialize;

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

Line 89: FND_MSG_PUB.Add;

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:

Line 95: FND_MSG_PUB.Add;

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

Line 100: 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');
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;

Line 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:

Line 109: FND_MSG_PUB.count_and_get(

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

Line 119: l_msg_data := FND_MSG_PUB.get(indexCount, FND_API.G_FALSE);

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:

Line 152: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

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:

Line 153: FND_MSG_PUB.Count_And_Get(

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

Line 160: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

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:

Line 161: FND_MSG_PUB.Count_And_Get(

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;

Line 198: FND_MSG_PUB.initialize;

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

Line 204: FND_MSG_PUB.Add;

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;

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

Line 213: 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');
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;

Line 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:

Line 239: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

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:

Line 240: FND_MSG_PUB.Count_And_Get(

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

Line 247: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

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:

Line 248: FND_MSG_PUB.Count_And_Get(

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;

Line 932: FND_MSG_PUB.initialize;

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

Line 1208: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

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

Line 1209: FND_MSG_PUB.Count_And_Get(

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;

Line 1215: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

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;

Line 1216: FND_MSG_PUB.Count_And_Get(

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:

Line 1258: FND_MSG_PUB.initialize;

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 ;

Line 1366: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

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

Line 1367: FND_MSG_PUB.Count_And_Get(

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;

Line 1373: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

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;

Line 1374: FND_MSG_PUB.Count_And_Get(

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: