DBA Data[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PUB dependencies on FND_MSG_PUB

Line 100: FND_MSG_PUB.INITIALIZE;

96:
97: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
98: IF FND_API.TO_BOOLEAN(p_init_msg_list)
99: THEN
100: FND_MSG_PUB.INITIALIZE;
101: END IF;
102:
103:
104:

Line 196: FND_MSG_PUB.ADD;

192: IF (l_log_statement >= l_log_current_level) THEN
193: fnd_log.string(fnd_log.level_statement,l_debug_module,'Error after AHL_PP_MATERIALS_PVT.Create_Material_Reqst');
194: ROLLBACK TO CREATE_NON_ROUTINE_MTRLS_SP;
195: FND_MESSAGE.SET_NAME ('AHL','AHL_NR_SUCC_MATRL_FAIL');
196: FND_MSG_PUB.ADD;
197: END IF;
198: -- RAISE FND_API.G_EXC_ERROR;
199: END IF;
200:

Line 253: FND_MSG_PUB.count_and_get

249: AHL_DEBUG_PUB.debug('END - Successfully completion of '||G_PKG_NAME||'.'||l_api_name||' API ');
250: END IF;
251:
252: -- Count and Get messages
253: FND_MSG_PUB.count_and_get
254: ( p_encoded => fnd_api.g_false,
255: p_count => x_msg_count,
256: p_data => x_msg_data
257: );

Line 268: x_msg_count := FND_MSG_PUB.Count_Msg;

264: EXCEPTION
265: WHEN FND_API.G_EXC_ERROR THEN
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: ROLLBACK TO CREATE_NON_ROUTINE_SP;
268: x_msg_count := FND_MSG_PUB.Count_Msg;
269: x_msg_data := AHL_PRD_WO_PUB.GET_MSG_DATA(x_msg_count);
270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
271:
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 274: x_msg_count := FND_MSG_PUB.Count_Msg;

270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
271:
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273: ROLLBACK TO CREATE_NON_ROUTINE_SP;
274: x_msg_count := FND_MSG_PUB.Count_Msg;
275: x_msg_data := AHL_PRD_WO_PUB.GET_MSG_DATA(x_msg_count);
276:
277: WHEN OTHERS THEN
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

276:
277: WHEN OTHERS THEN
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: ROLLBACK TO CREATE_NON_ROUTINE_SP;
280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
281: THEN
282: FND_MSG_PUB.add_exc_msg
283: (
284: p_pkg_name => G_PKG_NAME,

Line 282: FND_MSG_PUB.add_exc_msg

278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: ROLLBACK TO CREATE_NON_ROUTINE_SP;
280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
281: THEN
282: FND_MSG_PUB.add_exc_msg
283: (
284: p_pkg_name => G_PKG_NAME,
285: p_procedure_name => l_debug_module,
286: p_error_text => SUBSTR(SQLERRM,1,240)

Line 289: x_msg_count := FND_MSG_PUB.Count_Msg;

285: p_procedure_name => l_debug_module,
286: p_error_text => SUBSTR(SQLERRM,1,240)
287: );
288: END IF;
289: x_msg_count := FND_MSG_PUB.Count_Msg;
290: x_msg_data := AHL_PRD_WO_PUB.GET_MSG_DATA(x_msg_count);
291: END CREATE_NON_ROUTINE;
292:
293: ------------------------------------------------------------------------------------------------------------------

Line 338: FND_MSG_PUB.ADD;

334: AND wo.workorder_id = p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID;
335: EXCEPTION
336: WHEN NO_DATA_FOUND THEN
337: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
338: FND_MSG_PUB.ADD;
339: RAISE FND_API.G_EXC_ERROR;
340: WHEN TOO_MANY_ROWS THEN
341: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
342: FND_MSG_PUB.ADD;

Line 342: FND_MSG_PUB.ADD;

338: FND_MSG_PUB.ADD;
339: RAISE FND_API.G_EXC_ERROR;
340: WHEN TOO_MANY_ROWS THEN
341: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
342: FND_MSG_PUB.ADD;
343: RAISE FND_API.G_EXC_ERROR;
344: END;
345: ELSIF
346: ( (p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID IS NULL OR p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID = FND_API.G_MISS_NUM )

Line 365: FND_MSG_PUB.ADD;

361: AND WO.WORKORDER_NAME = p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER;
362: EXCEPTION
363: WHEN NO_DATA_FOUND THEN
364: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
365: FND_MSG_PUB.ADD;
366: RAISE FND_API.G_EXC_ERROR;
367: WHEN TOO_MANY_ROWS THEN
368: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
369: FND_MSG_PUB.ADD;

Line 369: FND_MSG_PUB.ADD;

365: FND_MSG_PUB.ADD;
366: RAISE FND_API.G_EXC_ERROR;
367: WHEN TOO_MANY_ROWS THEN
368: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
369: FND_MSG_PUB.ADD;
370: RAISE FND_API.G_EXC_ERROR;
371: END;
372: ELSE
373: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');

Line 374: FND_MSG_PUB.ADD;

370: RAISE FND_API.G_EXC_ERROR;
371: END;
372: ELSE
373: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
374: FND_MSG_PUB.ADD;
375: RAISE FND_API.G_EXC_ERROR;
376: END IF;
377:
378: -- populate the request date

Line 517: FND_MSG_PUB.ADD;

513: IF get_instance_details%NOTFOUND THEN
514: CLOSE get_instance_details;
515: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_INVALID');
516: FND_MESSAGE.Set_Token('NAME',p_create_nr_input_rec.unit_name);
517: FND_MSG_PUB.ADD;
518: RAISE FND_API.G_EXC_ERROR;
519: END IF;
520: CLOSE get_instance_details;
521: