DBA Data[Home] [Help]

APPS.AHL_LTP_RESRC_LEVL_PUB dependencies on FND_MSG_PUB

Line 69: FND_MSG_PUB.initialize;

65: END IF;
66: -- Standard call to check for call compatibility.
67: IF FND_API.to_boolean(p_init_msg_list)
68: THEN
69: FND_MSG_PUB.initialize;
70: END IF;
71: -- Initialize API return status to success
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 96: Fnd_Msg_Pub.ADD;

92: AND A.description = p_x_req_resources.dept_name;
93: --
94: IF l_department_id IS NULL THEN
95: Fnd_Message.Set_Name('AHL','AHL_LTP_DEPT_INVALID');
96: Fnd_Msg_Pub.ADD;
97: RAISE Fnd_Api.G_EXC_ERROR;
98: END IF;
99: ELSE
100: Fnd_Message.Set_Name('AHL','AHL_LTP_DEPT_NULL');

Line 101: Fnd_Msg_Pub.ADD;

97: RAISE Fnd_Api.G_EXC_ERROR;
98: END IF;
99: ELSE
100: Fnd_Message.Set_Name('AHL','AHL_LTP_DEPT_NULL');
101: Fnd_Msg_Pub.ADD;
102: RAISE Fnd_Api.G_EXC_ERROR;
103: END IF;
104: --
105: */

Line 155: l_msg_count := Fnd_Msg_Pub.count_msg;

151: END IF;
152:
153: ------------------------End of Body---------------------------------------
154: --Standard check to count messages
155: l_msg_count := Fnd_Msg_Pub.count_msg;
156:
157: IF l_msg_count > 0 THEN
158: X_msg_count := l_msg_count;
159: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 178: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

174: EXCEPTION
175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
176: ROLLBACK TO derive_resource_capacity;
177: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
179: p_count => x_msg_count,
180: p_data => x_msg_data);
181: IF G_DEBUG='Y' THEN
182:

Line 192: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

188: END IF;
189: WHEN FND_API.G_EXC_ERROR THEN
190: ROLLBACK TO derive_resource_capacity;
191: X_return_status := FND_API.G_RET_STS_ERROR;
192: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
193: p_count => x_msg_count,
194: p_data => X_msg_data);
195: IF G_DEBUG='Y' THEN
196:

Line 207: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

203: END IF;
204: WHEN OTHERS THEN
205: ROLLBACK TO derive_resource_capacity;
206: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
208: THEN
209: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_RESRC_LEVL_PUB',
210: p_procedure_name => 'DERIVE_RESOURCE_CAPACITY',
211: p_error_text => SUBSTR(SQLERRM,1,240));

Line 209: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_RESRC_LEVL_PUB',

205: ROLLBACK TO derive_resource_capacity;
206: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
208: THEN
209: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_RESRC_LEVL_PUB',
210: p_procedure_name => 'DERIVE_RESOURCE_CAPACITY',
211: p_error_text => SUBSTR(SQLERRM,1,240));
212: END IF;
213: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 213: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

209: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_RESRC_LEVL_PUB',
210: p_procedure_name => 'DERIVE_RESOURCE_CAPACITY',
211: p_error_text => SUBSTR(SQLERRM,1,240));
212: END IF;
213: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
214: p_count => x_msg_count,
215: p_data => X_msg_data);
216: IF G_DEBUG='Y' THEN
217:

Line 278: FND_MSG_PUB.initialize;

274: END IF;
275: -- Standard call to check for call compatibility.
276: IF FND_API.to_boolean(p_init_msg_list)
277: THEN
278: FND_MSG_PUB.initialize;
279: END IF;
280: -- Initialize API return status to success
281: x_return_status := FND_API.G_RET_STS_SUCCESS;
282: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 305: Fnd_Msg_Pub.ADD;

301: AND A.description = p_req_resources.dept_name;
302: --
303: IF l_department_id IS NULL THEN
304: Fnd_Message.Set_Name('AHL','AHL_LTP_DEPT_INVALID');
305: Fnd_Msg_Pub.ADD;
306: RAISE Fnd_Api.G_EXC_ERROR;
307: END IF;
308: ELSE
309: Fnd_Message.Set_Name('AHL','AHL_LTP_DEPT_ID_NOT_EXIST');

Line 310: Fnd_Msg_Pub.ADD;

306: RAISE Fnd_Api.G_EXC_ERROR;
307: END IF;
308: ELSE
309: Fnd_Message.Set_Name('AHL','AHL_LTP_DEPT_ID_NOT_EXIST');
310: Fnd_Msg_Pub.ADD;
311: RAISE Fnd_Api.G_EXC_ERROR;
312: END IF;
313: IF G_DEBUG='Y' THEN
314: AHL_DEBUG_PUB.debug( 'before public CallRID:'||p_req_resources.resource_id);

Line 375: l_msg_count := Fnd_Msg_Pub.count_msg;

371:
372:
373: ------------------------End of Body---------------------------------------
374: --Standard check to count messages
375: l_msg_count := Fnd_Msg_Pub.count_msg;
376:
377: IF l_msg_count > 0 THEN
378: X_msg_count := l_msg_count;
379: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 398: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

394: EXCEPTION
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: ROLLBACK TO derive_resource_consum;
397: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
399: p_count => x_msg_count,
400: p_data => x_msg_data);
401: IF G_DEBUG='Y' THEN
402:

Line 413: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

409:
410: WHEN FND_API.G_EXC_ERROR THEN
411: ROLLBACK TO derive_resource_consum;
412: X_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
414: p_count => x_msg_count,
415: p_data => X_msg_data);
416: IF G_DEBUG='Y' THEN
417:

Line 429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

425:
426: WHEN OTHERS THEN
427: ROLLBACK TO derive_resource_consum;
428: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
430: THEN
431: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_RESRC_LEVL_PUB',
432: p_procedure_name => 'DERIVE_RESOURCE_CAPACITY',
433: p_error_text => SUBSTR(SQLERRM,1,240));

Line 431: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_RESRC_LEVL_PUB',

427: ROLLBACK TO derive_resource_consum;
428: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
430: THEN
431: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_RESRC_LEVL_PUB',
432: p_procedure_name => 'DERIVE_RESOURCE_CAPACITY',
433: p_error_text => SUBSTR(SQLERRM,1,240));
434: END IF;
435: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 435: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

431: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_RESRC_LEVL_PUB',
432: p_procedure_name => 'DERIVE_RESOURCE_CAPACITY',
433: p_error_text => SUBSTR(SQLERRM,1,240));
434: END IF;
435: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
436: p_count => x_msg_count,
437: p_data => X_msg_data);
438: IF G_DEBUG='Y' THEN
439: