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 933: FND_MSG_PUB.initialize;

929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
930: END IF;
931: -- Initialize message list if p_init_msg_list is set to TRUE.
932: IF FND_API.to_Boolean( p_init_msg_list ) THEN
933: FND_MSG_PUB.initialize;
934: END IF;
935: -- Initialize API return status to success
936: x_return_status := FND_API.g_ret_sts_success;
937: --msg('Getting the calndar code.p_organization_id==>' ||p_organization_id);

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

1207: EXCEPTION
1208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1209: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1211: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1212: FND_MSG_PUB.Count_And_Get(
1213: p_count => x_msg_count,
1214: p_data => x_msg_data);
1215: WHEN NO_DATA_FOUND THEN

Line 1212: FND_MSG_PUB.Count_And_Get(

1208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1209: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1211: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1212: FND_MSG_PUB.Count_And_Get(
1213: p_count => x_msg_count,
1214: p_data => x_msg_data);
1215: WHEN NO_DATA_FOUND THEN
1216: ROLLBACK TO EAM_ASSIGN_EMP_PUB;

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

1214: p_data => x_msg_data);
1215: WHEN NO_DATA_FOUND THEN
1216: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1217: x_return_status := FND_API.G_RET_STS_ERROR ;
1218: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1219: FND_MSG_PUB.Count_And_Get(
1220: p_count => x_msg_count,
1221: p_data => x_msg_data);
1222: END Get_Emp_Search_Results_Pvt;

Line 1219: FND_MSG_PUB.Count_And_Get(

1215: WHEN NO_DATA_FOUND THEN
1216: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1217: x_return_status := FND_API.G_RET_STS_ERROR ;
1218: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1219: FND_MSG_PUB.Count_And_Get(
1220: p_count => x_msg_count,
1221: p_data => x_msg_data);
1222: END Get_Emp_Search_Results_Pvt;
1223:

Line 1261: FND_MSG_PUB.initialize;

1257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1258: END IF;
1259:
1260: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1261: FND_MSG_PUB.initialize;
1262: END IF;
1263: x_return_status := FND_API.g_ret_sts_success;
1264: --copy the contents into the global temporary table
1265: DELETE FROM Eam_Emp_Assignment_Details_Tbl ;

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

1365: EXCEPTION
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1367: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1369: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1370: FND_MSG_PUB.Count_And_Get(
1371: p_count => x_msg_count,
1372: p_data => x_msg_data);
1373: WHEN NO_DATA_FOUND THEN

Line 1370: FND_MSG_PUB.Count_And_Get(

1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1367: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1369: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1370: FND_MSG_PUB.Count_And_Get(
1371: p_count => x_msg_count,
1372: p_data => x_msg_data);
1373: WHEN NO_DATA_FOUND THEN
1374: ROLLBACK TO EAM_ASSIGN_EMP_PUB;

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

1372: p_data => x_msg_data);
1373: WHEN NO_DATA_FOUND THEN
1374: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1375: x_return_status := FND_API.G_RET_STS_ERROR ;
1376: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1377: FND_MSG_PUB.Count_And_Get(
1378: p_count => x_msg_count,
1379: p_data => x_msg_data);
1380: END Get_Emp_Assignment_Details_Pvt;

Line 1377: FND_MSG_PUB.Count_And_Get(

1373: WHEN NO_DATA_FOUND THEN
1374: ROLLBACK TO EAM_ASSIGN_EMP_PUB;
1375: x_return_status := FND_API.G_RET_STS_ERROR ;
1376: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1377: FND_MSG_PUB.Count_And_Get(
1378: p_count => x_msg_count,
1379: p_data => x_msg_data);
1380: END Get_Emp_Assignment_Details_Pvt;
1381: