DBA Data[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PUB dependencies on FND_MSG_PUB

Line 32: FND_MSG_PUB.ADD;

28: FETCH get_user_id_csr INTO l_user_id;
29: IF get_user_id_csr%NOTFOUND THEN
30: FND_MESSAGE.set_name('AHL','AHL_PRD_INV_BPEL_USR');
31: FND_MESSAGE.SET_TOKEN('USER_NAME',p_user_id);
32: FND_MSG_PUB.ADD;
33: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
34: END IF;
35: CLOSE get_user_id_csr;
36:

Line 124: FND_MSG_PUB.INITIALIZE;

120:
121: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
122: IF FND_API.TO_BOOLEAN(p_init_msg_list)
123: THEN
124: FND_MSG_PUB.INITIALIZE;
125: END IF;
126:
127: --fnd_global.APPS_INITIALIZE (1003259,62211, 867);
128: --mo_global.SET_POLICY_CONTEXT('S',4698);

Line 219: FND_MSG_PUB.ADD;

215: IF (l_log_statement >= l_log_current_level) THEN
216: fnd_log.string(fnd_log.level_statement,l_debug_module,'Error after AHL_PP_MATERIALS_PVT.Create_Material_Reqst');
217: ROLLBACK TO CREATE_NON_ROUTINE_MTRLS_SP;
218: FND_MESSAGE.SET_NAME ('AHL','AHL_NR_SUCC_MATRL_FAIL');
219: FND_MSG_PUB.ADD;
220: END IF;
221: -- RAISE FND_API.G_EXC_ERROR;
222: END IF;
223:

Line 276: FND_MSG_PUB.count_and_get

272: AHL_DEBUG_PUB.debug('END - Successfully completion of '||G_PKG_NAME||'.'||l_api_name||' API ');
273: END IF;
274:
275: -- Count and Get messages
276: FND_MSG_PUB.count_and_get
277: ( p_encoded => fnd_api.g_false,
278: p_count => x_msg_count,
279: p_data => x_msg_data
280: );

Line 291: x_msg_count := FND_MSG_PUB.Count_Msg;

287: EXCEPTION
288: WHEN FND_API.G_EXC_ERROR THEN
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: ROLLBACK TO CREATE_NON_ROUTINE_SP;
291: x_msg_count := FND_MSG_PUB.Count_Msg;
292: x_msg_data := AHL_PRD_WO_PUB.GET_MSG_DATA(x_msg_count);
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294:
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 297: x_msg_count := FND_MSG_PUB.Count_Msg;

293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294:
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296: ROLLBACK TO CREATE_NON_ROUTINE_SP;
297: x_msg_count := FND_MSG_PUB.Count_Msg;
298: x_msg_data := AHL_PRD_WO_PUB.GET_MSG_DATA(x_msg_count);
299:
300: WHEN OTHERS THEN
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

299:
300: WHEN OTHERS THEN
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: ROLLBACK TO CREATE_NON_ROUTINE_SP;
303: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
304: THEN
305: FND_MSG_PUB.add_exc_msg
306: (
307: p_pkg_name => G_PKG_NAME,

Line 305: FND_MSG_PUB.add_exc_msg

301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: ROLLBACK TO CREATE_NON_ROUTINE_SP;
303: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
304: THEN
305: FND_MSG_PUB.add_exc_msg
306: (
307: p_pkg_name => G_PKG_NAME,
308: p_procedure_name => l_debug_module,
309: p_error_text => SUBSTR(SQLERRM,1,240)

Line 312: x_msg_count := FND_MSG_PUB.Count_Msg;

308: p_procedure_name => l_debug_module,
309: p_error_text => SUBSTR(SQLERRM,1,240)
310: );
311: END IF;
312: x_msg_count := FND_MSG_PUB.Count_Msg;
313: x_msg_data := AHL_PRD_WO_PUB.GET_MSG_DATA(x_msg_count);
314: END CREATE_NON_ROUTINE;
315:
316: ------------------------------------------------------------------------------------------------------------------

Line 361: FND_MSG_PUB.ADD;

357: AND wo.workorder_id = p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID;
358: EXCEPTION
359: WHEN NO_DATA_FOUND THEN
360: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
361: FND_MSG_PUB.ADD;
362: RAISE FND_API.G_EXC_ERROR;
363: WHEN TOO_MANY_ROWS THEN
364: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
365: FND_MSG_PUB.ADD;

Line 365: FND_MSG_PUB.ADD;

361: FND_MSG_PUB.ADD;
362: RAISE FND_API.G_EXC_ERROR;
363: WHEN TOO_MANY_ROWS THEN
364: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
365: FND_MSG_PUB.ADD;
366: RAISE FND_API.G_EXC_ERROR;
367: END;
368: ELSIF
369: ( (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 388: FND_MSG_PUB.ADD;

384: AND WO.WORKORDER_NAME = p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER;
385: EXCEPTION
386: WHEN NO_DATA_FOUND THEN
387: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
388: FND_MSG_PUB.ADD;
389: RAISE FND_API.G_EXC_ERROR;
390: WHEN TOO_MANY_ROWS THEN
391: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
392: FND_MSG_PUB.ADD;

Line 392: FND_MSG_PUB.ADD;

388: FND_MSG_PUB.ADD;
389: RAISE FND_API.G_EXC_ERROR;
390: WHEN TOO_MANY_ROWS THEN
391: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
392: FND_MSG_PUB.ADD;
393: RAISE FND_API.G_EXC_ERROR;
394: END;
395: ELSE
396: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');

Line 397: FND_MSG_PUB.ADD;

393: RAISE FND_API.G_EXC_ERROR;
394: END;
395: ELSE
396: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
397: FND_MSG_PUB.ADD;
398: RAISE FND_API.G_EXC_ERROR;
399: END IF;
400:
401: -- populate the request date

Line 532: FND_MSG_PUB.ADD;

528: IF get_instance_details%NOTFOUND THEN
529: CLOSE get_instance_details;
530: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_INVALID');
531: FND_MESSAGE.Set_Token('NAME',p_create_nr_input_rec.unit_name);
532: FND_MSG_PUB.ADD;
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;
535: CLOSE get_instance_details;
536: