DBA Data[Home] [Help]

APPS.AHL_PRD_DISP_UTIL_PVT dependencies on FND_MESSAGE

Line 238: FND_MESSAGE.set_name('AHL', 'AHL_PRD_DISP_JOB_ID_INVALID');

234: --Validate the input parameter p_workorder_id
235: OPEN get_job_attrs;
236: FETCH get_job_attrs INTO l_job_attrs;
237: IF get_job_attrs%NOTFOUND THEN
238: FND_MESSAGE.set_name('AHL', 'AHL_PRD_DISP_JOB_ID_INVALID');
239: FND_MESSAGE.set_token('JOBID', p_workorder_id);
240: FND_MSG_PUB.add;
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: CLOSE get_job_attrs;

Line 239: FND_MESSAGE.set_token('JOBID', p_workorder_id);

235: OPEN get_job_attrs;
236: FETCH get_job_attrs INTO l_job_attrs;
237: IF get_job_attrs%NOTFOUND THEN
238: FND_MESSAGE.set_name('AHL', 'AHL_PRD_DISP_JOB_ID_INVALID');
239: FND_MESSAGE.set_token('JOBID', p_workorder_id);
240: FND_MSG_PUB.add;
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: CLOSE get_job_attrs;
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 273: FND_MESSAGE.set_name('AHL', 'AHL_PRD_ITEM_ID_INVALID');

269: --return mode in which both value and id will be correct.
270: OPEN check_inv_item_id(p_disp_filter_rec.inventory_item_id, l_job_attrs.organization_id);
271: FETCH check_inv_item_id INTO l_inv_item_id;
272: IF check_inv_item_id%NOTFOUND THEN
273: FND_MESSAGE.set_name('AHL', 'AHL_PRD_ITEM_ID_INVALID');
274: FND_MESSAGE.set_token('ITEMID', p_disp_filter_rec.inventory_item_id);
275: FND_MSG_PUB.add;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: CLOSE check_inv_item_id;

Line 274: FND_MESSAGE.set_token('ITEMID', p_disp_filter_rec.inventory_item_id);

270: OPEN check_inv_item_id(p_disp_filter_rec.inventory_item_id, l_job_attrs.organization_id);
271: FETCH check_inv_item_id INTO l_inv_item_id;
272: IF check_inv_item_id%NOTFOUND THEN
273: FND_MESSAGE.set_name('AHL', 'AHL_PRD_ITEM_ID_INVALID');
274: FND_MESSAGE.set_token('ITEMID', p_disp_filter_rec.inventory_item_id);
275: FND_MSG_PUB.add;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: CLOSE check_inv_item_id;
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 288: FND_MESSAGE.set_name('AHL', 'AHL_PRD_ITEM_NUM_INVALID');

284: --This includes the case in which only value is provided.
285: OPEN get_inv_item_id(p_disp_filter_rec.item_number, l_job_attrs.organization_id);
286: FETCH get_inv_item_id INTO l_inv_item_id;
287: IF get_inv_item_id%NOTFOUND THEN
288: FND_MESSAGE.set_name('AHL', 'AHL_PRD_ITEM_NUM_INVALID');
289: FND_MESSAGE.set_token('ITEM', p_disp_filter_rec.item_number);
290: FND_MSG_PUB.add;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: CLOSE get_inv_item_id;

Line 289: FND_MESSAGE.set_token('ITEM', p_disp_filter_rec.item_number);

285: OPEN get_inv_item_id(p_disp_filter_rec.item_number, l_job_attrs.organization_id);
286: FETCH get_inv_item_id INTO l_inv_item_id;
287: IF get_inv_item_id%NOTFOUND THEN
288: FND_MESSAGE.set_name('AHL', 'AHL_PRD_ITEM_NUM_INVALID');
289: FND_MESSAGE.set_token('ITEM', p_disp_filter_rec.item_number);
290: FND_MSG_PUB.add;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: CLOSE get_inv_item_id;
293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 303: FND_MESSAGE.set_name('AHL', 'AHL_PRD_CON_STATUS_ID_INVALID');

299: IF (p_disp_filter_rec.condition_id IS NOT NULL) THEN
300: OPEN check_con_status_id(p_disp_filter_rec.condition_id);
301: FETCH check_con_status_id INTO l_con_status_id;
302: IF check_con_status_id%NOTFOUND THEN
303: FND_MESSAGE.set_name('AHL', 'AHL_PRD_CON_STATUS_ID_INVALID');
304: FND_MESSAGE.set_token('STATUSID', p_disp_filter_rec.condition_id);
305: FND_MSG_PUB.add;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: CLOSE check_con_status_id;

Line 304: FND_MESSAGE.set_token('STATUSID', p_disp_filter_rec.condition_id);

300: OPEN check_con_status_id(p_disp_filter_rec.condition_id);
301: FETCH check_con_status_id INTO l_con_status_id;
302: IF check_con_status_id%NOTFOUND THEN
303: FND_MESSAGE.set_name('AHL', 'AHL_PRD_CON_STATUS_ID_INVALID');
304: FND_MESSAGE.set_token('STATUSID', p_disp_filter_rec.condition_id);
305: FND_MSG_PUB.add;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: CLOSE check_con_status_id;
308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 318: FND_MESSAGE.set_name('AHL', 'AHL_PRD_CON_STATUS_INVALID');

314: --This includes the case in which only value is provided.
315: OPEN get_con_status_id(p_disp_filter_rec.condition_code);
316: FETCH get_con_status_id INTO l_con_status_id;
317: IF get_con_status_id%NOTFOUND THEN
318: FND_MESSAGE.set_name('AHL', 'AHL_PRD_CON_STATUS_INVALID');
319: FND_MESSAGE.set_token('STAUS', p_disp_filter_rec.condition_code);
320: FND_MSG_PUB.add;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: CLOSE get_con_status_id;

Line 319: FND_MESSAGE.set_token('STAUS', p_disp_filter_rec.condition_code);

315: OPEN get_con_status_id(p_disp_filter_rec.condition_code);
316: FETCH get_con_status_id INTO l_con_status_id;
317: IF get_con_status_id%NOTFOUND THEN
318: FND_MESSAGE.set_name('AHL', 'AHL_PRD_CON_STATUS_INVALID');
319: FND_MESSAGE.set_token('STAUS', p_disp_filter_rec.condition_code);
320: FND_MSG_PUB.add;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: CLOSE get_con_status_id;
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 662: FND_MESSAGE.set_name('AHL', 'AHL_PRD_CONST_MULTIPLE');

658: --In this case we need to assign constant '' to on_item_number,
659: --but it is translatable, so we put it into the message table and fetch back
660: --the translated one. And then we need to remove this particular message from
661: --the message otherwise it will interfere with other regular meaningful messages.
662: FND_MESSAGE.set_name('AHL', 'AHL_PRD_CONST_MULTIPLE');
663: FND_MSG_PUB.add;
664: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,
665: p_encoded => FND_API.G_FALSE,
666: p_data => l_translated_msg,

Line 686: FND_MESSAGE.set_name('AHL', 'AHL_PRD_CONST_IG_NAME');

682: --but it is translatable, so we put it into the message table and fetch back
683: --the translated one. And then we need to remove this particular message from
684: --the message otherwise it will interfere with other regular meaningful messages.
685: /* After discussion with Jay, now decided to display it just as (09/22/04)
686: FND_MESSAGE.set_name('AHL', 'AHL_PRD_CONST_IG_NAME');
687: FND_MSG_PUB.add;
688: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,
689: p_encoded => FND_API.G_FALSE,
690: p_data => l_translated_msg,

Line 2014: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_ID_INVALID');

2010: OPEN get_disp_dtls_csr (p_disposition_id);
2011: FETCH get_disp_dtls_csr INTO l_disp_rec;
2012: --Check if matching disposition is found..
2013: IF (get_disp_dtls_csr%NOTFOUND) THEN
2014: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_ID_INVALID');
2015: FND_MESSAGE.Set_Token('DISPOSITION_ID', p_disposition_id);
2016: FND_MSG_PUB.ADD;
2017: CLOSE get_disp_dtls_csr;
2018: RAISE FND_API.G_EXC_ERROR;

Line 2015: FND_MESSAGE.Set_Token('DISPOSITION_ID', p_disposition_id);

2011: FETCH get_disp_dtls_csr INTO l_disp_rec;
2012: --Check if matching disposition is found..
2013: IF (get_disp_dtls_csr%NOTFOUND) THEN
2014: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_ID_INVALID');
2015: FND_MESSAGE.Set_Token('DISPOSITION_ID', p_disposition_id);
2016: FND_MSG_PUB.ADD;
2017: CLOSE get_disp_dtls_csr;
2018: RAISE FND_API.G_EXC_ERROR;
2019: END IF;

Line 2025: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_ITEM_POS_NULL');

2021:
2022: --Throw an error if both item and position are null
2023: IF (l_disp_rec.inventory_item_id IS NULL AND
2024: l_disp_rec.path_position_id IS NULL) THEN
2025: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_ITEM_POS_NULL');
2026: FND_MSG_PUB.ADD;
2027: RAISE FND_API.G_EXC_ERROR;
2028: ELSIF (l_disp_rec.inventory_item_id IS NULL AND
2029: l_disp_rec.path_position_id IS NOT NULL) THEN

Line 2057: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_ITEM_ORG_INV');

2053: CLOSE get_empty_pos_item_csr;
2054:
2055: --Raise the exception because for workorder org, no matching item found.
2056: --Can not create Mtl Req because there is no inventory item
2057: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_ITEM_ORG_INV');
2058: FND_MSG_PUB.ADD;
2059: RAISE FND_API.G_EXC_ERROR;
2060: END IF;
2061: CLOSE get_pos_subut_item_csr;

Line 2174: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_MTL_REQ_UPDATED');

2170: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2171: -- Added on 1/8/05 by JR to fix Bug 4097327
2172: -- To give a different confirmation message for update
2173: IF (l_update_flag = true) THEN
2174: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_MTL_REQ_UPDATED');
2175: FND_MESSAGE.Set_Token('QUANTITY',
2176: l_req_material_u_rec.requested_quantity);
2177: FND_MESSAGE.Set_Token('UOM', l_mtl_requirement.uom);
2178: ELSE

Line 2175: FND_MESSAGE.Set_Token('QUANTITY',

2171: -- Added on 1/8/05 by JR to fix Bug 4097327
2172: -- To give a different confirmation message for update
2173: IF (l_update_flag = true) THEN
2174: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_MTL_REQ_UPDATED');
2175: FND_MESSAGE.Set_Token('QUANTITY',
2176: l_req_material_u_rec.requested_quantity);
2177: FND_MESSAGE.Set_Token('UOM', l_mtl_requirement.uom);
2178: ELSE
2179: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_MTL_REQ_SUCCESS');

Line 2177: FND_MESSAGE.Set_Token('UOM', l_mtl_requirement.uom);

2173: IF (l_update_flag = true) THEN
2174: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_MTL_REQ_UPDATED');
2175: FND_MESSAGE.Set_Token('QUANTITY',
2176: l_req_material_u_rec.requested_quantity);
2177: FND_MESSAGE.Set_Token('UOM', l_mtl_requirement.uom);
2178: ELSE
2179: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_MTL_REQ_SUCCESS');
2180: FND_MESSAGE.Set_Token('QUANTITY',
2181: l_req_material_rec.requested_quantity);

Line 2179: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_MTL_REQ_SUCCESS');

2175: FND_MESSAGE.Set_Token('QUANTITY',
2176: l_req_material_u_rec.requested_quantity);
2177: FND_MESSAGE.Set_Token('UOM', l_mtl_requirement.uom);
2178: ELSE
2179: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_MTL_REQ_SUCCESS');
2180: FND_MESSAGE.Set_Token('QUANTITY',
2181: l_req_material_rec.requested_quantity);
2182: FND_MESSAGE.Set_Token('UOM', l_req_material_rec.uom_code);
2183: END IF;

Line 2180: FND_MESSAGE.Set_Token('QUANTITY',

2176: l_req_material_u_rec.requested_quantity);
2177: FND_MESSAGE.Set_Token('UOM', l_mtl_requirement.uom);
2178: ELSE
2179: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_MTL_REQ_SUCCESS');
2180: FND_MESSAGE.Set_Token('QUANTITY',
2181: l_req_material_rec.requested_quantity);
2182: FND_MESSAGE.Set_Token('UOM', l_req_material_rec.uom_code);
2183: END IF;
2184: FND_MESSAGE.Set_Token('ITEM', l_item_number);

Line 2182: FND_MESSAGE.Set_Token('UOM', l_req_material_rec.uom_code);

2178: ELSE
2179: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_MTL_REQ_SUCCESS');
2180: FND_MESSAGE.Set_Token('QUANTITY',
2181: l_req_material_rec.requested_quantity);
2182: FND_MESSAGE.Set_Token('UOM', l_req_material_rec.uom_code);
2183: END IF;
2184: FND_MESSAGE.Set_Token('ITEM', l_item_number);
2185: FND_MSG_PUB.ADD;
2186: END IF;

Line 2184: FND_MESSAGE.Set_Token('ITEM', l_item_number);

2180: FND_MESSAGE.Set_Token('QUANTITY',
2181: l_req_material_rec.requested_quantity);
2182: FND_MESSAGE.Set_Token('UOM', l_req_material_rec.uom_code);
2183: END IF;
2184: FND_MESSAGE.Set_Token('ITEM', l_item_number);
2185: FND_MSG_PUB.ADD;
2186: END IF;
2187:
2188: --Standard check for commit

Line 2301: fnd_message.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');

2297: where disposition_id = p_disposition_id
2298: and nvl(status_code, ' ') <> 'TERMINATED';
2299: EXCEPTION
2300: WHEN NO_DATA_FOUND THEN
2301: fnd_message.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2302: fnd_message.set_token('NAME','p_disposition_id');
2303: fnd_message.set_token('VALUE',p_disposition_id);
2304: fnd_msg_pub.add;
2305: RAISE FND_API.G_EXC_ERROR;

Line 2302: fnd_message.set_token('NAME','p_disposition_id');

2298: and nvl(status_code, ' ') <> 'TERMINATED';
2299: EXCEPTION
2300: WHEN NO_DATA_FOUND THEN
2301: fnd_message.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2302: fnd_message.set_token('NAME','p_disposition_id');
2303: fnd_message.set_token('VALUE',p_disposition_id);
2304: fnd_msg_pub.add;
2305: RAISE FND_API.G_EXC_ERROR;
2306: END;

Line 2303: fnd_message.set_token('VALUE',p_disposition_id);

2299: EXCEPTION
2300: WHEN NO_DATA_FOUND THEN
2301: fnd_message.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2302: fnd_message.set_token('NAME','p_disposition_id');
2303: fnd_message.set_token('VALUE',p_disposition_id);
2304: fnd_msg_pub.add;
2305: RAISE FND_API.G_EXC_ERROR;
2306: END;
2307:

Line 2314: fnd_message.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');

2310: from cs_incidents
2311: where incident_id = p_service_request_id;
2312: EXCEPTION
2313: WHEN NO_DATA_FOUND THEN
2314: fnd_message.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2315: fnd_message.set_token('NAME','p_service_request_id');
2316: fnd_message.set_token('VALUE',p_service_request_id);
2317: fnd_msg_pub.add;
2318: RAISE FND_API.G_EXC_ERROR;

Line 2315: fnd_message.set_token('NAME','p_service_request_id');

2311: where incident_id = p_service_request_id;
2312: EXCEPTION
2313: WHEN NO_DATA_FOUND THEN
2314: fnd_message.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2315: fnd_message.set_token('NAME','p_service_request_id');
2316: fnd_message.set_token('VALUE',p_service_request_id);
2317: fnd_msg_pub.add;
2318: RAISE FND_API.G_EXC_ERROR;
2319: END;

Line 2316: fnd_message.set_token('VALUE',p_service_request_id);

2312: EXCEPTION
2313: WHEN NO_DATA_FOUND THEN
2314: fnd_message.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
2315: fnd_message.set_token('NAME','p_service_request_id');
2316: fnd_message.set_token('VALUE',p_service_request_id);
2317: fnd_msg_pub.add;
2318: RAISE FND_API.G_EXC_ERROR;
2319: END;
2320:

Line 2365: fnd_message.set_name('AHL','AHL_PRD_SR_LINK_CREATE_ERROR');

2361: x_return_status||', x_reciprocal_link_id='||l_reciprocal_link_id||', x_link_id='||
2362: x_link_id);
2363: END IF;
2364: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) Then
2365: fnd_message.set_name('AHL','AHL_PRD_SR_LINK_CREATE_ERROR');
2366: fnd_message.set_token('VALUE1',p_disposition_id);
2367: fnd_msg_pub.add;
2368: RAISE FND_API.G_EXC_ERROR;
2369: End If;

Line 2366: fnd_message.set_token('VALUE1',p_disposition_id);

2362: x_link_id);
2363: END IF;
2364: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) Then
2365: fnd_message.set_name('AHL','AHL_PRD_SR_LINK_CREATE_ERROR');
2366: fnd_message.set_token('VALUE1',p_disposition_id);
2367: fnd_msg_pub.add;
2368: RAISE FND_API.G_EXC_ERROR;
2369: End If;
2370: