APPS.CSP_PC_FORM_PICKLINES dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 256: from mtl_material_transactions_temp

252: ELSE
253: BEGIN
254: -- validate whether the transaction temp id is valid
255: select transaction_temp_id into l_check_existence
256: from mtl_material_transactions_temp
257: where transaction_temp_id = p_transaction_temp_id
258: and inventory_item_id = p_inventory_item_id
259: and move_order_line_id = p_line_id;
260: EXCEPTION

Line 270: fnd_message.set_token('TABLE', 'MTL_MATERIAL_TRANSACTIONS_TEMP', FALSE);

266: WHEN OTHERS THEN
267: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
268: fnd_message.set_token('ERR_FIELD', 'p_transaction_temp_id', FALSE);
269: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
270: fnd_message.set_token('TABLE', 'MTL_MATERIAL_TRANSACTIONS_TEMP', FALSE);
271: FND_MSG_PUB.ADD;
272: RAISE EXCP_USER_DEFINED;
273: END;
274: END IF;

Line 466: from mtl_material_transactions_temp

462: IF nvl(p_transaction_temp_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
463: BEGIN
464: -- validate whether the transaction temp id is valid
465: select transaction_temp_id into l_check_existence
466: from mtl_material_transactions_temp
467: where transaction_temp_id = p_transaction_temp_id;
468: EXCEPTION
469: WHEN NO_DATA_FOUND THEN
470: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');

Line 478: fnd_message.set_token('TABLE', 'MTL_MATERIAL_TRANSACTIONS_TEMP', FALSE);

474: WHEN OTHERS THEN
475: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
476: fnd_message.set_token('ERR_FIELD', 'p_transaction_temp_id', FALSE);
477: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
478: fnd_message.set_token('TABLE', 'MTL_MATERIAL_TRANSACTIONS_TEMP', FALSE);
479: FND_MSG_PUB.ADD;
480: RAISE EXCP_USER_DEFINED;
481: END;
482: END IF;