DBA Data[Home] [Help]

APPS.AHL_PRD_DISP_MTL_TXN_PVT dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

931: OPEN get_mtl_txn_csr(p_wo_mtl_txn_id);
932: FETCH get_mtl_txn_csr INTO l_txn_rec;
933: IF (get_mtl_txn_csr%NOTFOUND) THEN
934: CLOSE get_mtl_txn_csr;
935: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_TXN_ID_INV');
936: FND_MESSAGE.Set_Token('MTL_TXN_ID', p_wo_mtl_txn_id);
937: FND_MSG_PUB.ADD;
938: RAISE FND_API.G_EXC_ERROR;
939: END IF;

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

932: FETCH get_mtl_txn_csr INTO l_txn_rec;
933: IF (get_mtl_txn_csr%NOTFOUND) THEN
934: CLOSE get_mtl_txn_csr;
935: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_TXN_ID_INV');
936: FND_MESSAGE.Set_Token('MTL_TXN_ID', p_wo_mtl_txn_id);
937: FND_MSG_PUB.ADD;
938: RAISE FND_API.G_EXC_ERROR;
939: END IF;
940: CLOSE get_mtl_txn_csr;