DBA Data[Home] [Help]

APPS.AHL_PRD_DISP_MTL_TXN_PVT dependencies on FND_MESSAGE

Line 150: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_ID_INV');

146: --validate that disposition id is valid
147: OPEN get_disp_rec_csr(l_disp_mx_rec.disposition_id);
148: FETCH get_disp_rec_csr INTO l_disp_rec;
149: IF (get_disp_rec_csr%NOTFOUND) THEN
150: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_ID_INV');
151: FND_MESSAGE.Set_Token('DISPOSITION_ID', l_disp_mx_rec.disposition_id);
152: FND_MSG_PUB.ADD;
153: l_return_status := FND_API.G_RET_STS_ERROR;
154: CLOSE get_disp_rec_csr;

Line 151: FND_MESSAGE.Set_Token('DISPOSITION_ID', l_disp_mx_rec.disposition_id);

147: OPEN get_disp_rec_csr(l_disp_mx_rec.disposition_id);
148: FETCH get_disp_rec_csr INTO l_disp_rec;
149: IF (get_disp_rec_csr%NOTFOUND) THEN
150: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_ID_INV');
151: FND_MESSAGE.Set_Token('DISPOSITION_ID', l_disp_mx_rec.disposition_id);
152: FND_MSG_PUB.ADD;
153: l_return_status := FND_API.G_RET_STS_ERROR;
154: CLOSE get_disp_rec_csr;
155: RAISE FND_API.G_EXC_ERROR;

Line 164: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DIS_ASSOC_WO_STATUS'); --Cannot update disposition because of current workorder's status

160: --validate that the disposition is updateable based on the current workorder's status
161: OPEN workorder_editable_csr(l_disp_rec.workorder_id);
162: FETCH workorder_editable_csr INTO l_exist, l_job_status;
163: IF (workorder_editable_csr%FOUND) THEN
164: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DIS_ASSOC_WO_STATUS'); --Cannot update disposition because of current workorder's status
165: FND_MESSAGE.Set_Token('STATUS', l_job_status);
166: FND_MSG_PUB.ADD;
167: l_return_status := FND_API.G_RET_STS_ERROR;
168: CLOSE workorder_editable_csr;

Line 165: FND_MESSAGE.Set_Token('STATUS', l_job_status);

161: OPEN workorder_editable_csr(l_disp_rec.workorder_id);
162: FETCH workorder_editable_csr INTO l_exist, l_job_status;
163: IF (workorder_editable_csr%FOUND) THEN
164: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DIS_ASSOC_WO_STATUS'); --Cannot update disposition because of current workorder's status
165: FND_MESSAGE.Set_Token('STATUS', l_job_status);
166: FND_MSG_PUB.ADD;
167: l_return_status := FND_API.G_RET_STS_ERROR;
168: CLOSE workorder_editable_csr;
169: RAISE FND_API.G_EXC_ERROR;

Line 180: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_TXN_ID_INV');

176: --validate that mtl txn id is valid
177: OPEN get_mtl_txn_rec_csr(l_disp_mx_rec.wo_mtl_txn_id);
178: FETCH get_mtl_txn_rec_csr INTO l_mtl_txn_rec;
179: IF (get_mtl_txn_rec_csr%NOTFOUND) THEN
180: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_TXN_ID_INV');
181: FND_MESSAGE.Set_Token('MTL_TXN_ID', l_disp_mx_rec.wo_mtl_txn_id);
182: FND_MSG_PUB.ADD;
183: l_return_status := FND_API.G_RET_STS_ERROR;
184: CLOSE get_mtl_txn_rec_csr;

Line 181: FND_MESSAGE.Set_Token('MTL_TXN_ID', l_disp_mx_rec.wo_mtl_txn_id);

177: OPEN get_mtl_txn_rec_csr(l_disp_mx_rec.wo_mtl_txn_id);
178: FETCH get_mtl_txn_rec_csr INTO l_mtl_txn_rec;
179: IF (get_mtl_txn_rec_csr%NOTFOUND) THEN
180: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_TXN_ID_INV');
181: FND_MESSAGE.Set_Token('MTL_TXN_ID', l_disp_mx_rec.wo_mtl_txn_id);
182: FND_MSG_PUB.ADD;
183: l_return_status := FND_API.G_RET_STS_ERROR;
184: CLOSE get_mtl_txn_rec_csr;
185: RAISE FND_API.G_EXC_ERROR;

Line 199: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_MTL_TXN_ITEM_ILL');

195: -- (Jay found this problem) The organization_id in disposition entity maps to instance's last_vld_org_id
196: -- if the instance_id is not null. Thus it could be different from job's org which equals to material
197: -- transaction organization.
198: -- OR l_disp_rec.organization_id <> l_mtl_txn_rec.organization_id)) THEN
199: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_MTL_TXN_ITEM_ILL');
200: FND_MSG_PUB.ADD;
201: l_return_status := FND_API.G_RET_STS_ERROR;
202: RAISE FND_API.G_EXC_ERROR;
203: END IF;

Line 206: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_MTL_TXN_WO_ILL');

202: RAISE FND_API.G_EXC_ERROR;
203: END IF;
204:
205: IF (l_disp_rec.workorder_id <> l_mtl_txn_rec.workorder_id) THEN
206: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_MTL_TXN_WO_ILL');
207: FND_MSG_PUB.ADD;
208: l_return_status := FND_API.G_RET_STS_ERROR;
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;

Line 227: FND_MESSAGE.Set_Name('AHL','AHL_COM_UOM_CONV_FAILED');

223: from_name => null,
224: to_name => null);
225: l_disp_mx_rec.uom := l_disp_rec.uom;
226: IF (l_disp_mx_rec.quantity < 0) THEN
227: FND_MESSAGE.Set_Name('AHL','AHL_COM_UOM_CONV_FAILED');
228: FND_MESSAGE.Set_Token('FROM_UOM', l_disp_mx_rec.UOM);
229: FND_MESSAGE.Set_Token('TO_UOM', l_disp_rec.uom);
230: FND_MSG_PUB.ADD;
231: l_return_status := FND_API.G_RET_STS_ERROR;

Line 228: FND_MESSAGE.Set_Token('FROM_UOM', l_disp_mx_rec.UOM);

224: to_name => null);
225: l_disp_mx_rec.uom := l_disp_rec.uom;
226: IF (l_disp_mx_rec.quantity < 0) THEN
227: FND_MESSAGE.Set_Name('AHL','AHL_COM_UOM_CONV_FAILED');
228: FND_MESSAGE.Set_Token('FROM_UOM', l_disp_mx_rec.UOM);
229: FND_MESSAGE.Set_Token('TO_UOM', l_disp_rec.uom);
230: FND_MSG_PUB.ADD;
231: l_return_status := FND_API.G_RET_STS_ERROR;
232: RAISE FND_API.G_EXC_ERROR;

Line 229: FND_MESSAGE.Set_Token('TO_UOM', l_disp_rec.uom);

225: l_disp_mx_rec.uom := l_disp_rec.uom;
226: IF (l_disp_mx_rec.quantity < 0) THEN
227: FND_MESSAGE.Set_Name('AHL','AHL_COM_UOM_CONV_FAILED');
228: FND_MESSAGE.Set_Token('FROM_UOM', l_disp_mx_rec.UOM);
229: FND_MESSAGE.Set_Token('TO_UOM', l_disp_rec.uom);
230: FND_MSG_PUB.ADD;
231: l_return_status := FND_API.G_RET_STS_ERROR;
232: RAISE FND_API.G_EXC_ERROR;
233: END IF;

Line 372: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

368: p_x_disp_mtl_txn_tbl(i).disp_mtl_txn_id := l_disp_mx_rec.disp_mtl_txn_id;
369:
370: -- Check Object version number.
371: IF (l_old_disp_mx_rec.object_version_number <> l_disp_mx_rec.object_version_number) THEN
372: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
373: FND_MSG_PUB.ADD;
374: l_return_status := FND_API.G_RET_STS_ERROR;
375: CLOSE get_disp_mtl_txn_rec_csr;
376: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 517: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_QTY_EXCEEDED');

513:
514: --Verify that disposition quantity is not exceeded.
515: --No UOM conversion is necessary, because all QTYs store in Disposition UOM
516: IF (Calculate_Txned_Qty(p_x_disp_mtl_txn_tbl(i).disposition_id) > l_disp_rec.quantity) THEN
517: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_QTY_EXCEEDED');
518: FND_MESSAGE.Set_Token('DISPOSITION_ID', p_x_disp_mtl_txn_tbl(i).disposition_id);
519: FND_MSG_PUB.ADD;
520: l_return_status := FND_API.G_RET_STS_ERROR;
521: END IF;

Line 518: FND_MESSAGE.Set_Token('DISPOSITION_ID', p_x_disp_mtl_txn_tbl(i).disposition_id);

514: --Verify that disposition quantity is not exceeded.
515: --No UOM conversion is necessary, because all QTYs store in Disposition UOM
516: IF (Calculate_Txned_Qty(p_x_disp_mtl_txn_tbl(i).disposition_id) > l_disp_rec.quantity) THEN
517: FND_MESSAGE.Set_Name('AHL','AHL_PRD_DISP_QTY_EXCEEDED');
518: FND_MESSAGE.Set_Token('DISPOSITION_ID', p_x_disp_mtl_txn_tbl(i).disposition_id);
519: FND_MSG_PUB.ADD;
520: l_return_status := FND_API.G_RET_STS_ERROR;
521: END IF;
522:

Line 553: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_TXN_QTY_EXCEEDED');

549: END IF;
550:
551: --If quantity count is less than 0, then raise exception
552: IF (l_mtl_txn_rec.quantity<0) THEN
553: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_TXN_QTY_EXCEEDED');
554: FND_MESSAGE.Set_Token('MTL_TXN_ID', p_x_disp_mtl_txn_tbl(i).wo_mtl_txn_id);
555: FND_MSG_PUB.ADD;
556: l_return_status := FND_API.G_RET_STS_ERROR;
557: EXIT;

Line 554: FND_MESSAGE.Set_Token('MTL_TXN_ID', p_x_disp_mtl_txn_tbl(i).wo_mtl_txn_id);

550:
551: --If quantity count is less than 0, then raise exception
552: IF (l_mtl_txn_rec.quantity<0) THEN
553: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_TXN_QTY_EXCEEDED');
554: FND_MESSAGE.Set_Token('MTL_TXN_ID', p_x_disp_mtl_txn_tbl(i).wo_mtl_txn_id);
555: FND_MSG_PUB.ADD;
556: l_return_status := FND_API.G_RET_STS_ERROR;
557: EXIT;
558: END IF;

Line 947: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_TXN_ID_INV');

943: OPEN get_mtl_txn_csr(p_wo_mtl_txn_id);
944: FETCH get_mtl_txn_csr INTO l_txn_rec;
945: IF (get_mtl_txn_csr%NOTFOUND) THEN
946: CLOSE get_mtl_txn_csr;
947: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_TXN_ID_INV');
948: FND_MESSAGE.Set_Token('MTL_TXN_ID', p_wo_mtl_txn_id);
949: FND_MSG_PUB.ADD;
950: RAISE FND_API.G_EXC_ERROR;
951: END IF;

Line 948: FND_MESSAGE.Set_Token('MTL_TXN_ID', p_wo_mtl_txn_id);

944: FETCH get_mtl_txn_csr INTO l_txn_rec;
945: IF (get_mtl_txn_csr%NOTFOUND) THEN
946: CLOSE get_mtl_txn_csr;
947: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_TXN_ID_INV');
948: FND_MESSAGE.Set_Token('MTL_TXN_ID', p_wo_mtl_txn_id);
949: FND_MSG_PUB.ADD;
950: RAISE FND_API.G_EXC_ERROR;
951: END IF;
952: CLOSE get_mtl_txn_csr;